fix search
[contractdashboard.git] / search_autosuggest.php
blob:a/search_autosuggest.php -> blob:b/search_autosuggest.php
--- a/search_autosuggest.php
+++ b/search_autosuggest.php
@@ -6,10 +6,10 @@
 $limit = isset($_GET['limit']) ? (int) $_GET['limit'] : 0;
 $aResults = array();
 $count = 0;
-if ($len) {
-    $query = 'SELECT mode("supplierName"), MAX("supplierABN"), count(*) as count
+if ($len > 2) {
+    $query = 'SELECT text_mode("supplierName"), MAX("supplierABN"), count(*) as count
 FROM contractnotice
-WHERE "supplierName" ILIKE :supplierName
+WHERE "supplierName" ILIKE :supplierName or "supplierABN"::text = :supplierABN
 GROUP BY "supplierName"
 ORDER BY count(*) DESC
 LIMIT 4;
@@ -17,12 +17,14 @@
     $query = $conn->prepare($query);
     $supplierName = $input . '%';
     $query->bindParam(":supplierName", $supplierName);
+    $supplierABN = $input ;
+    $query->bindParam(":supplierABN", $supplierABN);
     $query->execute();
     databaseError($conn->errorInfo());
     foreach ($query->fetchAll() as $row) {
         $count++;
         $aResults[] = array(
-            "id" => "supplier-" . $row[1] . '-' . $row[0],
+            "id" => "supplier-" . $row[1] . '-' . htmlspecialchars($row[0]),
             "value" => htmlspecialchars($row[0]),
             "info" => htmlspecialchars("Supplier - " . $row['count'] . " records")
         );