category breakdown
[contractdashboard.git] / displaySupplier.php
blob:a/displaySupplier.php -> blob:b/displaySupplier.php
--- a/displaySupplier.php
+++ b/displaySupplier.php
@@ -17,14 +17,42 @@
     }
     include_header(str_replace("%", "", $title));
     echo '<center><h1>' . str_replace("%", "", $title) . '</h1></center>';
+
 if (isset($supplierABN)) {
+    echo "<b>ABN:</b> <a href=\"https://abr.business.gov.au/SearchByAbn.aspx?abn=$supplierABN\">$supplierABN</a>";
+
+    $cleansedName = '%'.cleanseName($title).'%';
+    $query = 'SELECT DISTINCT ON ("supplierABN") "supplierName","supplierABN" FROM contractnotice WHERE "supplierName" ILIKE :cleansedName and "supplierABN" != :supplierABN';
+    $query = $conn->prepare($query);
+    $query->bindParam(":cleansedName", $cleansedName);
+    $query->bindParam(":supplierABN", $supplierABN);
+    $query->execute();
+    databaseError($conn->errorInfo());
+    echo "<br/><b>Similar to:</b> ";
+    foreach ($query->fetchAll() as $row) {
+        echo "<a href='displaySupplier.php?supplier={$row['supplierABN']}-".urlencode($row['supplierName'])."'> {$row['supplierName']} (ABN: {$row['supplierABN']})</a>, ";
+    }
+
     $query = 'SELECT distinct on (lower("supplierName")) "supplierName" from contractnotice where "supplierABN" = :supplierABN';
     $query = $conn->prepare($query);
     $query->bindParam(":supplierABN", $supplierABN);
     $query->execute();
     databaseError($conn->errorInfo());
-    echo "<b>Also known as:</b> ".implode(', ', $query->fetchAll(PDO::FETCH_COLUMN, 0));
+    $names = Array();
+    foreach ($query->fetchAll() as $row) {
+        $names[cleanseName($row[0])] = $row[0];
+    }
+    if (count($names) < 20) {
+        echo "<br/><b>Also known as:</b> " . implode(', ', array_values($names))."<br/>";
+    } else {
+        echo "<details>
+  <summary>Also known as ...</summary>
+  <p>".implode(', ', array_values($names))."</p>
+</details>";
+    }
+
 }
+
 
     $query = '
     SELECT