1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 | <?php include_once ("./lib/common.inc.php"); if ($_REQUEST['supplier']) { $supplierS = htmlentities(strip_tags($_REQUEST['supplier'])); $title = $supplierName; if ($supplierABN) { $query = 'SELECT text_mode("supplierName") as "supplierName" from contractnotice where "supplierABN" = :supplierABN group by "supplierABN"'; $query = $conn->prepare($query); $query->bindParam(":supplierABN", $supplierABN); $query->execute(); databaseError($conn->errorInfo()); $title = reset($query->fetchAll())['supplierName']; } include_header(str_replace("%","",$title)); echo '<center><h1>'.str_replace("%","",$title).'</h1></center>'; agenciesGraph(); /* * Make supplier name the most common name for this ABN * Common names and uncommon names * Common categories and uncommon categories * Procurement method in text, seperate Open via SON from Open * Consultancies, Confidentialities percentage */ $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 "<h3>Standing Offers/Panels</h3><table> <thead> <tr> <th>Standing Offer</th> <th>Contracts Count</th> <th>Total Contract Value</th> </tr> </thead>"; foreach ($query->fetchAll() as $row) { setlocale(LC_MONETARY, 'en_US'); $value = number_format(doubleval($row['value']), 2); echo ("<tr> <td><B><a href=\"displaySON.php?SONID={$row['SONID']}\">{$row['title']}</a></b></td> <td>{$row['count']}</td> <td>\$$value</td> </tr>"); } echo "</table><table><h3>Contracts</h3> <thead> <tr> <th>Contract Notice Number</th> <th>Contract Description</th> <th>Total Contract Value</th> <th>Agency</th> <th>Contract Start Date</th> <th>Supplier</th> </tr> </thead>"; $query = 'SELECT "CNID", "description", "value", "agencyName", "category", "contractStart", "supplierName" FROM contractnotice WHERE ' .$yearQ . ' ' . $supplierQ . ' ' . $standardQ . ' ORDER BY value DESC'; $query = $conn->prepare($query); if ($supplierParts[0] > 0) { $query->bindParam(":supplierABN", $supplierABN); } else { $query->bindParam(":supplierName", $supplierName); } $query->execute(); databaseError($conn->errorInfo()); foreach ($query->fetchAll() as $row) { setlocale(LC_MONETARY, 'en_US'); $value = number_format(doubleval($row['value']), 2); echo ("<tr> <td><a href=\"displayContract.php?CNID={$row['CNID']}\">{$row['CNID']}</a></td> <td><b>{$row['description']}</b></a></td> <td>\$$value</td><td>{$row['agencyName']}</td> <td>{$row['contractStart']}</td> <td>{$row['supplierName']}</td> </tr>"); } echo "</table>"; } else { /* histograph of supplier size/value */ include_header("Suppliers"); suppliersGraph(); $query = 'SELECT SUM("value") as val, text_mode("supplierName") as supplierName, "supplierABN",( case when "supplierABN" != 0 THEN lower("supplierABN"::text) ELSE lower("supplierName") END) as supplierID FROM contractnotice WHERE ' .$yearQ . ' "childCN" is null GROUP BY supplierID,"supplierABN" ORDER BY val DESC LIMIT 100'; $query = $conn->prepare($query); $query->execute(); databaseError($conn->errorInfo()); echo "<table> <thead> <tr> <th>Position</th> <th>Supplier</th> <th>Total Contract Value</th> </tr> </thead>"; $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 ("<tr><td>$i</td><td><b><a href=\"displaySupplier.php?supplier={$supplier}\">" . ucsmart($row['suppliername']) . "</a></b></td><td>\$$value</td></tr>\n"); $i++; } echo "</table>"; } include_footer(); ?> |