|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 | <?php include_once ("./lib/common.inc.php"); if ($_REQUEST['category']) { include_header("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 { include_header("Categories"); $query = "SELECT sum(value), category FROM `contractnotice` WHERE childCN = 0 GROUP BY category ORDER BY sum(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[0]) , 2); echo ("<tr><td><A href=\"displayCategory.php?category={$row[1]}\"><b>{$row[1]}</b></a></td><td>\$$value</td></tr>"); } echo "</table>"; mysql_free_result($result); } include_footer(); ?> |