--- a/displayContract.php +++ b/displayContract.php @@ -40,10 +40,11 @@ case "CNID": echo '<span property="pc:referenceNumber" lang="">'.$value.'</span>'; break; - case "categoryUNSPSC": - break; case "category": echo '<span rel="pc:mainObject" resource="[unspsc:'.$contractResult["categoryUNSPSC"].']">'.$value.'</span>'; + break; + case "SONID": + echo '<a href="displaySON.php?SONID=' . urlencode($value) . '">' . $value . "</a>"; break; case "agencyName": echo '<a href="displayAgency.php?agency=' . urlencode($value) . '">' . $value . "</a>"; @@ -72,6 +73,35 @@ </div>'; +/*$query = $solr_client->createMoreLikeThis(); + +$query->setQuery('id:'.$_REQUEST['CNID']); +$query->setMltFields('description'); +$query->setMinimumDocumentFrequency(1); +$query->setMinimumTermFrequency(1); +$query->setInterestingTerms('description'); +$query->setMatchInclude(true); + +// 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(). ' similar results: <table>'; + + +foreach ($resultset 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>"); +} +echo "</table>";*/ + $query = 'SELECT * FROM heuristic_results where "CNID" = :CNID'; $query = $conn->prepare($query);