--- a/displaySupplier.php
+++ b/displaySupplier.php
@@ -21,6 +21,47 @@
spread of contract values
spread of industries (textual?) */
+ // echo '';
+ // echo '';
+$query = 'select contractnotice."SONID", min(title) as title, count(*), sum(value) as value from contractnotice inner join standingoffers on contractnotice."SONID" = standingoffers."SONID" WHERE ' .$yearQ . ' ' .
+ $supplierQ . ' ' . $standardQ
+ . ' and contractnotice."SONID" != \'\' group by contractnotice."SONID"';
+$query = $conn->prepare($query);
+
+
+ if ($supplierParts[0] > 0) {
+ $query->bindParam(":supplierABN", $supplierABN);
+ } else {
+ $query->bindParam(":supplierName", $supplierName);
+ }
+ $query->execute();
+ databaseError($conn->errorInfo());
+echo "
+
+ Standing Offer |
+ Contracts Count |
+ Total Contract Value |
+
+ ";
+ foreach ($query->fetchAll() as $row) {
+ setlocale(LC_MONETARY, 'en_US');
+ $value = number_format(doubleval($row['value']), 2);
+ echo ("
+ {$row['title']} |
+ {$row['count']} |
+ \$$value |
+
");
+ }
+ echo "
+
+ Contract Notice Number |
+ Contract Description |
+ Total Contract Value |
+ Agency |
+ Contract Start Date |
+ Supplier |
+
+ ";
$query = 'SELECT "CNID", "description", "value", "agencyName", "category",
"contractStart", "supplierName"
FROM contractnotice WHERE ' .$yearQ . ' ' .
@@ -37,19 +78,6 @@
}
$query->execute();
databaseError($conn->errorInfo());
- // echo '';
- // echo '';
-
- echo "
-
- Contract Notice Number |
- Contract Description |
- Total Contract Value |
- Agency |
- Contract Start Date |
- Supplier |
-
- ";
foreach ($query->fetchAll() as $row) {
setlocale(LC_MONETARY, 'en_US');
$value = number_format(doubleval($row['value']), 2);