--- a/lib/common.inc.php
+++ b/lib/common.inc.php
@@ -1,4 +1,6 @@
0) $supplierQ = "supplierABN = '" . $supplierParts[0] . "' AND";
- else $supplierQ = "supplierName LIKE '%" . $supplierParts[1] . "%' AND";
+ if ($supplierParts[0] > 0) $supplierQ = "supplierABN = '" . $supplierParts[0] . "' AND ";
+ else $supplierQ = "supplierName LIKE '%" . $supplierParts[1] . "%' AND ";
}
+$startYear = 2007;
$year = mysql_real_escape_string(stripslashes($_REQUEST['year']));
-if ($year != "") $yearQ = "agencyName = '" . $agency . "' AND";
-
+if ($year != "") $yearQ = "YEAR(publishDate) = " . $year . " AND ";
+$standardQ = "childCN = 0 AND YEAR(contractStart) >= 2007 AND YEAR(contractStart) <= 2010";
$start =0.0;
function include_header($title) {
@@ -55,9 +60,8 @@
Contract Dashboard - <?=$title?>
-
+
-
+
+
+
+
+