<?php
include_once ("./lib/common.inc.php");
if ($_REQUEST['supplier']) {
    
include_header("Supplier");
  $supplier = htmlentities(strip_tags($_REQUEST['supplier']));
  echo '<img src="graphs/displayMethodCountGraph.php?supplier=' . stripslashes($supplier) . '">';
   echo '<img src="graphs/displayCnCGraph.php?supplier=' . stripslashes($supplier) . '">';
   echo '<img src="graphs/displayMethodValueGraph.php?supplier=' . stripslashes($supplier) . '">';
  /*lobbyist ties
  
  links to ABR/ASIC/Google News/ASX/Court records
  
  total value to various agencies (bar graph)
  
  spread procurement methods + percent consultancies + percent confidential (bar graph)
  
  spread of contract values
  
  spread of industries (textual?)*/
} else {
    /*
     histograph of supplier size/value
    */
include_header("Suppliers");
  $query = "SELECT SUM(value) as val, supplierName, supplierABN
FROM `contractnotice`
WHERE childCN = 0
GROUP BY supplierName
ORDER BY val DESC
LIMIT 100";
  $result = mysql_query($query);
  echo "<table>";
  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 "</table>";
  mysql_free_result($result);
}
include_footer();
?>