Add standing offers
[contractdashboard.git] / displayContract.php
blob:a/displayContract.php -> blob:b/displayContract.php
--- a/displayContract.php
+++ b/displayContract.php
@@ -45,6 +45,9 @@
             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>";
                 break;
@@ -72,6 +75,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);