--- a/displayAgency.php +++ b/displayAgency.php @@ -6,6 +6,7 @@ $agency = htmlentities(strip_tags($_REQUEST['agency'])); include_header($agency); echo '

'.$agency.'

'; + 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();