--- a/lib/common.inc.php +++ b/lib/common.inc.php @@ -95,13 +95,13 @@ if ($supplierParts[0] > 0) $supplierQ = ' "supplierABN" = :supplierABN AND '; else - $supplierQ = ' "supplierName" LIKE :supplierName AND '; + $supplierQ = ' "supplierName" ILIKE :supplierName AND '; } $startYear = 2007; $year = filter_var($_REQUEST['year'], FILTER_SANITIZE_NUMBER_INT); if ($year != "") { - $yearQ = "YEAR(publishDate) = " . $year . " AND "; + $yearQ = 'extract(year from "contractStart") = ' . $year . " AND "; } $standardQ = ' "childCN" is null '; // AND YEAR(contractStart) >= 2007 AND YEAR(contractStart) <= 2010'; $start = 0.0; @@ -266,9 +266,21 @@ <div class="container-fluid"> <div class="row-fluid"> <div class="span3"> +<h3> Filter by: </h3> <div class="well sidebar-nav"> - <li class="nav-header">Filter by:</li> - <li>2008</li> + <li class="nav-header">Year</li> +<?php +foreach (range(2008,2015) as $year) { +$get = $_GET; +$get['year'] = $year; +$query = http_build_query($get); +echo "<li><A href='?$query'>"; +if ($_GET['year'] == $year) echo "<b>"; +echo "$year"; +if ($_GET['year'] == $year) echo "</b>"; +echo "</a></li>"; +} +?> </div> </div> <div class="span9">