<?php
include_once ("./lib/common.inc.php");
$input = strtolower($_GET['input']);
$len = strlen($input);
$limit = isset($_GET['limit']) ? (int)$_GET['limit'] : 0;
$aResults = array();
$count = 0;
if ($len) {
  $query = "SELECT supplierName, supplierABN, supplierName, count(*) as count
FROM `contractnotice`
WHERE supplierName LIKE '$input%'
GROUP BY supplierName
ORDER BY count DESC
LIMIT 4;
";
  $result = mysql_query($query);
  while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
    $count++;
    $aResults[] = array(
      "id" => "supplier-".$row['supplierABN'].'-'.$row['supplierName'],
      "value" => htmlspecialchars($row['supplierName']) ,
      "info" => htmlspecialchars("Supplier - ". $row['count']." records")
    );
  }
  $query = "SELECT agencyName, count(*) as count
FROM `contractnotice`
WHERE agencyName LIKE '$input%'
GROUP BY agencyName
ORDER BY count DESC
LIMIT 4;";
  $result = mysql_query($query);
  while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
    $count++;
    $aResults[] = array(
      "id" => "agency-".$row['agencyName'],
      "value" => htmlspecialchars($row['agencyName']) ,
      "info" => htmlspecialchars("Government Agency - ". $row['count']." records")
    );
  }
}
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); // Date in the past
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // always modified
header("Cache-Control: no-cache, must-revalidate"); // HTTP/1.1
header("Pragma: no-cache"); // HTTP/1.0
if (isset($_REQUEST['json'])) {
  header("Content-Type: application/json");
  echo "{\"results\": [";
  $arr = array();
  for ($i = 0;$i < count($aResults);$i++) {
    $arr[] = "{\"id\": \"" . $aResults[$i]['id'] . "\", \"value\": \"" . $aResults[$i]['value'] . "\", \"info\": \"\"}";
  }
  echo implode(", ", $arr);
  echo "]}";
} else {
  header("Content-Type: text/xml");
  echo "<?xml version=\"1.0\" encoding=\"utf-8\" ?><results>";
  for ($i = 0;$i < count($aResults);$i++) {
    echo "<rs id=\"" . $aResults[$i]['id'] . "\" info=\"" . $aResults[$i]['info'] . "\">" . $aResults[$i]['value'] . "</rs>";
  }
  echo "</results>";
}
?>