Data update
[contractdashboard.git] / displayAgency.php
blob:a/displayAgency.php -> blob:b/displayAgency.php
--- a/displayAgency.php
+++ b/displayAgency.php
@@ -6,6 +6,7 @@
     $agency = htmlentities(strip_tags($_REQUEST['agency']));
     include_header($agency);
 echo '<center><h1>'.$agency.'</h1></center>';
+    agencySuppliersGraph($agency);
 //    MethodCountGraph($agency);
  //   CnCGraph($agency);
  //   MethodValueGraph($agency);
@@ -29,7 +30,7 @@
     $query = 'SELECT "CNID", "description", "value", "agencyName", "category",
     "contractStart", "supplierName"
     FROM contractnotice
-    WHERE "agencyName" like :agency
+    WHERE ' .$yearQ . ' "agencyName" like :agency
     ORDER BY "value" DESC limit 100';
     $query = $conn->prepare($query);
     $query->bindParam(":agency", $agency);
@@ -66,7 +67,7 @@
     agenciesGraph();
     $query = 'SELECT SUM("value"), "agencyName"
 FROM contractnotice
-WHERE "childCN" is null 
+WHERE ' .$yearQ . ' "childCN" is null 
 GROUP BY "agencyName" ';
     $query = $conn->prepare($query);
     $query->execute();