new stats box
[contractdashboard.git] / displayAgency.php
blob:a/displayAgency.php -> blob:b/displayAgency.php
--- a/displayAgency.php
+++ b/displayAgency.php
@@ -12,6 +12,24 @@
     $query->bindParam(":agency", $agency);
     $query->execute();
     databaseError($conn->errorInfo());
+
+    $query = '
+    SELECT 
+sum((consultancy = \'Yes\')::int) AS consultancy,
+sum(("confidentialityContract" = \'Yes\')::int) AS "confidentialityContract",
+sum(("confidentialityOutputs" = \'Yes\')::int) AS "confidentialityOutputs",
+sum((("procurementMethod" = \'Open\' OR "procurementMethod" = \'Open tender\') AND "SONID" IS null)::int) AS open,
+sum((("procurementMethod" = \'Open\' OR "procurementMethod" = \'Open tender\') AND "SONID" IS NOT null)::int) AS "openSON",
+sum(("procurementMethod" = \'Prequalified tender\' OR "procurementMethod" = \'Select\')::INT) AS prequalified,
+sum(("procurementMethod" = \'Direct\' OR "procurementMethod" = \'Limited tender\')::int) AS limited,
+COUNT(*) AS total
+FROM contractnotice 
+WHERE "supplierABN" = \'51194660183\'
+    ';
+    /*
+    * Procurement method in text, seperate Open via SON from Open
+    * Consultancies, Confidentialities percentage
+      Compliance statistics: amendments, delay in reporting average and number completely late */
 
 
     echo "<h3>Categories</h3><table>  <thead>
@@ -85,10 +103,6 @@
     </tr>");
     }
     echo "</table><br/>";
-    /*
-        * Procurement method in text, seperate Open via SON from Open
-        * Consultancies, Confidentialities percentage
-          Compliance statistics: amendments, delay in reporting average and number completely late */
 
     $query = 'SELECT "CNID", "description", "value", "agencyName", "category",
     "contractStart", "supplierName"