Heuristic ranking analysis
[contractdashboard.git] / heuristics / viewHeuristicsColormap.php
blob:a/heuristics/viewHeuristicsColormap.php -> blob:b/heuristics/viewHeuristicsColormap.php
--- a/heuristics/viewHeuristicsColormap.php
+++ b/heuristics/viewHeuristicsColormap.php
@@ -1,5 +1,11 @@
 <?php    
   include_once("../lib/common.inc.php");
+  echo '<style>
+  div {
+  padding: 5px;
+  display: inline-block;
+  }
+  </style>';
 // http://www.herethere.net/~samson/php/color_gradient/color_gradient_generator.php.txt
 // return the interpolated value between pBegin and pEnd
 function interpolate($pBegin, $pEnd, $pStep, $pMax)
@@ -35,20 +41,19 @@
 }
 $Gradients = Gradient("66FF00" , "FF0000" , 10); 
   
-$query = "select max(sum) from (SELECT sum(heuristic_value) 
-as sum FROM heuristic_results group by CNID) as a";
-$result = mysql_query($query);
-$r = mysql_fetch_array($result, MYSQL_BOTH);
+$query = 'select max(sum) from (SELECT sum(heuristic_value) 
+as sum FROM heuristic_results group by "CNID") as a';
+    $result = $conn->query($query);
+    $r = $result->fetch();
 $maxVal = $r[0];
   
-$query = "SELECT sum(heuristic_value) as sum, CNID
-FROM `heuristic_results` group by CNID order by sum DESC LIMIT 30";
-$result = mysql_query($query);
-if (!$result) echo mysql_error().$query;
-while ($r = mysql_fetch_array($result, MYSQL_BOTH)) {
-    echo '<span style="background: #'.$Gradients[floor(($r['sum']/$maxVal) * 10)].'; padding: 5px;">';
+$query = 'SELECT sum(heuristic_value) as sum, "CNID"
+FROM heuristic_results group by "CNID" order by sum DESC LIMIT 300';
+    $result = $conn->query($query);
+foreach ($result->fetchAll() as $r) {
+    echo '<div style="background: #'.$Gradients[floor(($r['sum']/$maxVal) * 10)].';">';
     echo '<a title="'.$r['sum'].'" href="../displayContract.php?CNID='.$r['CNID'].'">X</a>';
-    echo "</span>";
+    echo "</div>";
 }
 
 ?>