--- a/displayAgency.php
+++ b/displayAgency.php
@@ -6,30 +6,17 @@
     $agency = htmlentities(strip_tags($_REQUEST['agency']));
     include_header($agency);
 echo '<center><h1>'.$agency.'</h1></center>';
-//    MethodCountGraph($agency);
- //   CnCGraph($agency);
- //   MethodValueGraph($agency);
-    /* biggest contracts
-      spending by year
-      spending by industry/category
-      spending by supplier
-
-      spread procurement methods (stacked bar graph)
-      + percent consultancies + percent confidential (bar graph)
-
-      Average value by procurement type
-
-      --- info
-      website, procurement plan, annual reports
-      Breakdown of divisions/branches
-      Breakdown percentage,number,value by procurement type
-      Histograph, overlaying number value reported per week over X years
+    agencySuppliersGraph($agency);
+/*
+ *     * Common categories and uncommon categories
+    * 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"
     FROM contractnotice
-    WHERE "agencyName" like :agency
+    WHERE ' .$yearQ . ' "agencyName" like :agency and "childCN" is null
     ORDER BY "value" DESC limit 100';
     $query = $conn->prepare($query);
     $query->bindParam(":agency", $agency);
@@ -66,7 +53,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();