--- 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