--- a/displaySupplier.php +++ b/displaySupplier.php @@ -17,14 +17,42 @@ } include_header(str_replace("%", "", $title)); echo '

' . str_replace("%", "", $title) . '

'; + if (isset($supplierABN)) { + echo "ABN: $supplierABN"; + + $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 "
Similar to: "; + foreach ($query->fetchAll() as $row) { + echo " {$row['supplierName']} (ABN: {$row['supplierABN']}), "; + } + $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 "Also known as: ".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 "
Also known as: " . implode(', ', array_values($names))."
"; + } else { + echo "
+ Also known as ... +

".implode(', ', array_values($names))."

+
"; + } + } + $query = ' SELECT