--- a/displaySON.php
+++ b/displaySON.php
@@ -9,7 +9,11 @@
$title = reset($query->fetchAll())['title'];
include_header($title);
echo "
" . $_REQUEST['SONID'] . " - " . $title . "
";
-
+ echo '
View original record @ tenders.gov.au
';
+ /*
+ * Procurement method in text, seperate Open via SON from Open
+ * Consultancies, Confidentialities percentage
+ */
$query = 'SELECT category, min("categoryUNSPSC") AS "categoryUNSPSC", count(*) AS count, sum(value) AS value
FROM contractnotice
WHERE "SONID" = :SONID
@@ -45,7 +49,6 @@
$query->bindParam(":SONID", $_REQUEST['SONID']);
$query->execute();
databaseError($conn->errorInfo());
- echo '
View original record @ tenders.gov.au
';
echo "Suppliers
@@ -100,7 +103,7 @@
split by main categories
*/
include_header("Standing Offers");
- $query = 'SELECT sum(value), count(*), contractnotice."SONID", min(title) AS title
+ $query = 'SELECT sum(value), count(*), contractnotice."SONID", min(title) AS title, text_mode(category) as category
FROM contractnotice INNER JOIN standingoffers ON contractnotice."SONID" = standingoffers."SONID"
WHERE ' . $yearQ . ' "childCN" IS NULL AND contractnotice."SONID" != \'\'
GROUP BY contractnotice."SONID" ORDER BY sum(VALUE) DESC ';
@@ -110,6 +113,7 @@
echo "
SONID |
+ Main category |
Total Contracts Value |
Number of Contracts |
@@ -117,7 +121,9 @@
foreach ($query->fetchAll() as $row) {
setlocale(LC_MONETARY, 'en_US');
$value = number_format(doubleval($row['sum']), 2);
- echo("{$row['title']} | \$$value | {$row['count']} |
");
+ $title = $row['SONID'];
+ if (strlen($row['title']) > 1) $title = $row['title'];
+ echo("$title | {$row['category']} | \$$value | {$row['count']} |
");
}
echo "
";
}