version 0.0.2

[fms.git] / admin / introductionstatus.php

diff --git a/admin/introductionstatus.php b/admin/introductionstatus.php
new file mode 100644 (file)
index 0000000..b4b5492
--- /dev/null
+++ b/admin/introductionstatus.php
@@ -0,0 +1,42 @@
+<?php\r
+\r
+       include_once('config.php');\r
+       include_once('linkbar.php');\r
+               \r
+function content()\r
+{\r
+       global $dblocation;\r
+       \r
+       $db=new PDO('sqlite:'.$dblocation);\r
+       $st=$db->prepare("SELECT tblLocalIdentity.Name, COUNT(Inserted) FROM tblLocalIdentity LEFT JOIN tblIdentityIntroductionInserts ON tblLocalIdentity.LocalIdentityID=tblIdentityIntroductionInserts.LocalIdentityID WHERE (Inserted='true' OR Inserted IS NULL) GROUP BY tblLocalIdentity.LocalIdentityID;");\r
+       $st->execute();\r
+       \r
+       ?>\r
+       <h2>Introduction Status</h2>\r
+       <table>\r
+               <tr>\r
+                       <th>Identity</th>\r
+                       <th>Successful introduction inserts</th>\r
+               </tr>\r
+               <?php\r
+               while($record=$st->fetch())\r
+               {\r
+                       ?>\r
+               <tr>\r
+                       <td>\r
+                               <?php print $record[0]; ?>\r
+                       </td>\r
+                       <td>\r
+                               <?php print $record[1]; ?>\r
+                       </td>\r
+               </tr>\r
+                       <?php   \r
+               }\r
+               ?>\r
+       </table>\r
+       <?php\r
+}\r
+       \r
+       include_once('template.php');\r
+\r
+?>
\ No newline at end of file