--- a/displayCalendar.php +++ b/displayCalendar.php @@ -1,15 +1,38 @@ <?php include_once("./lib/common.inc.php"); + +include_header("Months and Years"); + +if ($_REQUEST['category']) { + echo "<center><h1>".$_REQUEST['category']."</h1></center>"; + $query = "SELECT CNID, description, value, agencyName, category, contractStart, supplierName + FROM `contractnotice` + WHERE childCN = 0 + AND category = '" . $_REQUEST['category'] . "' + ORDER BY value DESC"; + $result = mysql_query($query); + echo "<table>"; + while ($row = mysql_fetch_array($result, MYSQL_BOTH)) { + setlocale(LC_MONETARY, 'en_US'); + $value = number_format(doubleval($row['value']) , 2); + echo ("<tr> + <td><a href=\"displayContract.php?CNID={$row['CNID']}\">{$row['CNID']}</a></td> + <td><b>{$row['description']}</b></a></td> + <td>\$$value</td><td>{$row['agencyName']}</td> + <td>{$row['contractStart']}</td> + <td>{$row['supplierName']}</td> + </tr>"); + } + echo "</table>"; + mysql_free_result($result); +} else { /* split by year - */ -/* todo: Year/Month drilldown - largest contracts, agencies, suppliers big picture graphs?*/ -include_header("Months and Years"); $query = "SELECT YEAR(contractStart), MONTH(contractStart), value FROM `contractnotice` WHERE childCN = 0 GROUP BY MONTH(contractStart), YEAR(contractStart) ORDER BY YEAR(contractStart), MONTH(contractStart) "; @@ -23,6 +46,6 @@ } echo "</table>"; mysql_free_result($result); - +} include_footer(); ?>