--- a/displaySupplier.php
+++ b/displaySupplier.php
@@ -3,10 +3,10 @@
if ($_REQUEST['supplier']) {
include_header("Supplier");
- $supplier = htmlentities(strip_tags($_REQUEST['supplier']));
- echo '';
- echo '';
- echo '';
+ $supplierS = htmlentities(strip_tags($_REQUEST['supplier']));
+ echo '';
+ echo '';
+ echo '';
/*lobbyist ties
links to ABR/ASIC/Google News/ASX/Court records
@@ -18,6 +18,38 @@
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 '';
+ echo '';
+
+ echo "
+
+ Contract Notice Number |
+ Contract Description |
+ Total Contract Value |
+ Agency |
+ Contract Start Date |
+ Supplier |
+
+ ";
+ while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
+ setlocale(LC_MONETARY, 'en_US');
+ $value = number_format(doubleval($row['value']) , 2);
+ echo ("
+ {$row['CNID']} |
+ {$row['description']} |
+ \$$value | {$row['agencyName']} |
+ {$row['contractStart']} |
+ {$row['supplierName']} |
+
");
+ }
+ echo "
";
+ mysql_free_result($result);
} else {
/*
histograph of supplier size/value
@@ -30,7 +62,12 @@
ORDER BY val DESC
LIMIT 100";
$result = mysql_query($query);
- echo "";
+ echo "
+
+ Supplier |
+ Total Contract Value |
+
+ ";
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
setlocale(LC_MONETARY, 'en_US');
$value = number_format(doubleval($row['val']) , 2);