--- a/displaySupplier.php
+++ b/displaySupplier.php
@@ -1,41 +1,40 @@
prepare($query);
+ $query = $conn->prepare($query);
//$query->bindParam(":supplierName", $supplierName);
-$query->bindParam(":supplierABN", $supplierABN);
- $query->execute();
- if (!$query) {
- databaseError($conn->errorInfo());
- }
-echo '';
- echo '';
+ $query->bindParam(":supplierABN", $supplierABN);
+ $query->execute();
+ databaseError($conn->errorInfo());
+ echo '';
+ echo '';
- echo "
+ echo "
Contract Notice Number |
Contract Description |
@@ -45,52 +44,50 @@
Supplier |
";
- foreach ($query->fetchAll() as $row) {
- setlocale(LC_MONETARY, 'en_US');
- $value = number_format(doubleval($row['value']) , 2);
- echo ("
+ foreach ($query->fetchAll() as $row) {
+ 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 "
";
+ }
+ echo "
";
} else {
/*
- histograph of supplier size/value
- */
-include_header("Suppliers");
-suppliersGraph();
- $query = 'SELECT SUM("value") as val, MAX("supplierName") as supplierName, "supplierABN",(
+ histograph of supplier size/value
+ */
+ include_header("Suppliers");
+ suppliersGraph();
+ $query = 'SELECT SUM("value") as val, MAX("supplierName") as supplierName, "supplierABN",(
case when "supplierABN" != 0 THEN "supplierABN"::text ELSE "supplierName" END) as supplierID
FROM contractnotice
WHERE "childCN" is null
GROUP BY supplierID,"supplierABN"
ORDER BY val DESC
LIMIT 100';
-$query = $conn->prepare($query);
- $query->execute();
- if (!$query) {
- databaseError($conn->errorInfo());
- }
- echo "
+ $query = $conn->prepare($query);
+ $query->execute();
+ databaseError($conn->errorInfo());
+ echo "
Position |
Supplier |
Total Contract Value |
";
-$i = 1;
- foreach ($query->fetchAll() as $row) {
- setlocale(LC_MONETARY, 'en_US');
- $value = number_format(doubleval($row['val']) , 2);
- $supplier = stripslashes($row['supplierABN'].'-'.$row['suppliername']);
- echo ("$i | ".ucsmart($row['suppliername'])." | \$$value |
\n");
- $i++;
- }
- echo "
";
+ $i = 1;
+ foreach ($query->fetchAll() as $row) {
+ setlocale(LC_MONETARY, 'en_US');
+ $value = number_format(doubleval($row['val']), 2);
+ $supplier = stripslashes($row['supplierABN'] . '-' . $row['suppliername']);
+ echo ("$i | " . ucsmart($row['suppliername']) . " | \$$value |
\n");
+ $i++;
+ }
+ echo "
";
}
include_footer();
?>