--- a/search.php +++ b/search.php @@ -1,35 +1,93 @@ -<?php - -/* - search ABNs - search agency name - search categories - search supplier names - --search supplier postcodes/suburbs/cities-- - search CN number - search description full text - */ -include('./lib/common.inc.php'); -if ($_REQUEST['searchID']) { - $searchIDParts = explode("-", $_REQUEST['searchID']); - $type = array_shift($searchIDParts); - $host = $_SERVER['HTTP_HOST']; - $uri = rtrim(dirname($_SERVER['PHP_SELF']), '/\\'); - - if ($type == "agency") { - header("Location: http://$host$uri/displayAgency.php?agency=" . implode("-", $searchIDParts)); - } - if ($type == "supplier") { - header("Location: http://$host$uri/displaySupplier.php?supplier=" . implode("-", $searchIDParts)); - } - if ($type == "cnid") { - header("Location: http://$host$uri/displayContract.php?CNID=" . implode("-", $searchIDParts)); - } - exit; -} else { - include_header("Search Results"); - print_r($_REQUEST); - include_footer(); -} -?> +<?php +/* + search ABNs + search agency name + search categories + search supplier names + --search supplier postcodes/suburbs/cities-- + search CN number + search description full text + */ +include('./lib/common.inc.php'); +if ($_REQUEST['searchID']) { + $searchIDParts = explode("-", $_REQUEST['searchID']); + $type = array_shift($searchIDParts); + $host = $_SERVER['HTTP_HOST']; + $uri = rtrim(dirname($_SERVER['PHP_SELF']), '/\\'); + + if ($type == "agency") { + header("Location: http://$host$uri/displayAgency.php?agency=" . implode("-", $searchIDParts)); + } + if ($type == "supplier") { + header("Location: http://$host$uri/displaySupplier.php?supplier=" . implode("-", $searchIDParts)); + } + if ($type == "cnid") { + header("Location: http://$host$uri/displayContract.php?CNID=" . implode("-", $searchIDParts)); + } + exit; +} else { + include_header("Search Results"); +/*// get a select query instance +$query = $solr_client->createSelect(); + +// set a query (all prices starting from 12) +$query->setQuery($_REQUEST['searchKeyword']); + +// set start and rows param (comparable to SQL limit) using fluent interface +$query->setStart(0)->setRows(100); + +// set fields to fetch (this overrides the default setting 'all fields') +$query->setFields(array('id','description','value','agencyName','contractStart','supplierName', 'score')); + +// sort the results by price ascending +//$query->addSort('price', $query::SORT_ASC); + +// this executes the query and returns the result +$resultset = $solr_client->select($query); + +// display the total number of documents found by solr +echo 'Found '.$resultset->getNumFound(). ' results. <table>'; + +foreach ($resultset as $row) { + foreach ($query->fetchAll() as $row) { +setlocale(LC_MONETARY, 'en_US'); + $value = number_format(doubleval($row['value'][0]), 2); + echo ("<tr> + <td><a href=\"displayContract.php?CNID={$row['id']}\">{$row['id']}</a></td> + <td><b>{$row['description'][0]}</b></a></td> + <td>\$$value</td><td>{$row['agencyName'][0]}</td> + <td>{$row['contractStart'][0]}</td> + <td>{$row['supplierName'][0]}</td> + </tr>"); + +*/ +$keyword = $_REQUEST['searchKeyword']; + $query = 'SELECT "CNID", "description", "value", "agencyName", "category", + "contractStart", "supplierName" + FROM contractnotice + WHERE ' .$yearQ . ' to_tsvector(\'english\', description) @@ plainto_tsquery(\'english\', :keyword) and "childCN" is null + ORDER BY "value" DESC limit 100'; + $query = $conn->prepare($query); + $query->bindParam(":keyword", $keyword); + $query->execute(); + databaseError($conn->errorInfo()); +echo '<table>'; + foreach ($query->fetchAll() as $row) { +//print_r($row); +setlocale(LC_MONETARY, 'en_US'); + $value = number_format($row['value'], 2); + echo ("<tr> + <td><a href=\"displayContract.php?CNID={$row['CNID']}\">{$row['CNID']}</a></td> + <td><b>{$row['description']}</b></td> + <td>\$$value</td><td>{$row['agencyName']}</td> + <td>{$row['contractStart']}</td> + <td>{$row['supplierName']}</td> + </tr>"); +} +echo "</table>"; + + include_footer(); +} +?> +