Reformatted contract view page
[contractdashboard.git] / displaySupplier.php
blob:a/displaySupplier.php -> blob:b/displaySupplier.php
--- a/displaySupplier.php
+++ b/displaySupplier.php
@@ -55,24 +55,27 @@
      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 supplierABN
+GROUP BY supplierID
 ORDER BY val DESC
 LIMIT 100";
   $result = mysql_query($query);
    echo "<table>  <thead>
     <tr>
+       <th>Position</th>
        <th>Supplier</th>
       <th>Total Contract Value</th>
     </tr>
   </thead>";
+$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 ("<tr><td><b><a href=\"displaySupplier.php?supplier={$supplier}\">".ucsmart($row['supplierName'])."</a></b></td><td>\$$value</td></tr>\n");
+    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>";
   mysql_free_result($result);