|
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 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 | <?php include_once ("./lib/common.inc.php"); if ($_REQUEST['supplier']) { include_header("Supplier"); $supplierS = htmlentities(strip_tags($_REQUEST['supplier'])); echo '<img src="graphs/displayMethodCountGraph.php?supplier=' . stripslashes($supplierS) . '">'; echo '<img src="graphs/displayCnCGraph.php?supplier=' . stripslashes($supplierS) . '">'; echo '<img src="graphs/displayMethodValueGraph.php?supplier=' . stripslashes($supplierS) . '">'; /*lobbyist ties links to ABR/ASIC/Google News/ASX/Court records total value to various agencies (bar graph) spread procurement methods + percent consultancies + percent confidential (bar graph) spread of contract values spread of industries (textual?)*/ $query = "SELECT CNID, description, value, agencyName, category, contractStart, supplierName FROM `contractnotice` WHERE $supplierQ $standardQ ORDER BY value DESC"; echo $query; $result = mysql_query($query); echo '<img src="graphs/displayMethodCountGraph.php?month=' . stripslashes($supplier) . '">'; echo '<img src="graphs/displayCnCGraph.php?month=' . stripslashes($supplier) . '">'; echo "<table> <thead> <tr> <th>Contract Notice Number</th> <th>Contract Description</th> <th>Total Contract Value</th> <th>Agency</th> <th>Contract Start Date</th> <th>Supplier</th> </tr> </thead>"; 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 { /* histograph of supplier size/value */ include_header("Suppliers"); $query = "SELECT SUM(value) as val, supplierName, supplierABN FROM `contractnotice` WHERE childCN = 0 GROUP BY supplierName ORDER BY val DESC LIMIT 100"; $result = mysql_query($query); echo "<table> <thead> <tr> <th>Supplier</th> <th>Total Contract Value</th> </tr> </thead>"; while ($row = mysql_fetch_array($result, MYSQL_BOTH)) { setlocale(LC_MONETARY, 'en_US'); $value = number_format(doubleval($row['val']) , 2); $supplier = stripslashes($row['supplierABN'].'-'.$row['supplierName']); echo ("<tr><td><b><a href=\"displaySupplier.php?supplier={$supplier}\">".ucsmart($row['supplierName'])."</a></b></td><td>\$$value</td></tr>\n"); } echo "</table>"; mysql_free_result($result); } include_footer(); ?> |