--- 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,27 +18,68 @@
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
*/
include_header("Suppliers");
- $query = "SELECT SUM(value) as val, supplierName, supplierABN
+ $query = "SELECT SUM(value) as val, supplierName, supplierABN, IF(supplierABN != '',supplierABN,supplierName) as supplierID
FROM `contractnotice`
WHERE childCN = 0
-GROUP BY supplierName
+GROUP BY supplierID
ORDER BY val DESC
LIMIT 100";
$result = mysql_query($query);
- echo "";
+ echo "
+
+ Position |
+ Supplier |
+ Total Contract Value |
+
+ ";
+$i = 1;
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 ("".ucsmart($row['supplierName'])." | \$$value |
\n");
+ echo ("$i | ".ucsmart($row['supplierName'])." | \$$value |
\n");
+ $i++;
}
echo "
";
mysql_free_result($result);
}
include_footer();
?>
+