| <?php | <?php |
| /*// most interesting | /*// most interesting |
| SELECT sum(heuristic_value) as sum, CNID | SELECT sum(heuristic_value) as sum, CNID |
| FROM heuristic_results group by CNID order by sum DESC limit 30 | FROM heuristic_results group by CNID order by sum DESC limit 30 |
| // spread of values | // spread of values |
| select floor(sum) as val,count(*) from (SELECT sum(heuristic_value) | select floor(sum) as val,count(*) from (SELECT sum(heuristic_value) |
| as sum FROM heuristic_results group by CNID) as a group by val*/ | as sum FROM heuristic_results group by "CNID") as a group by val*/ |
| $series = Array(); | $series = Array(); |
| include_once("../lib/common.inc.php"); | include_once("../lib/common.inc.php"); |
| $query = "select heuristic_name, floor(heuristic_value) as val,count(*) from heuristic_results group by heuristic_name, val"; | $query = "select heuristic_name, floor(heuristic_value) as val,count(*) from heuristic_results group by heuristic_name, val"; |
| $result = $conn->query($query); | $result = $conn->query($query); |
| foreach ($result->fetchAll() as $r) { | foreach ($result->fetchAll() as $r) { |
| $series[$r["heuristic_name"]][$r["val"]] = $r[2]; | $series[$r["heuristic_name"]][$r["val"]] = $r[2]; |
| } | } |
| $labels = Array(); | |
| foreach ($series as $value) { | |
| $labels = $labels+array_keys($value); | |
| } | |
| $labels = Array(0,1,2,3,4,5); | |
| foreach ($series as $seriesName => $seriesEntry) { | |
| $data; | |
| foreach ($labels as $label) { | |
| $data[$label] = ($seriesEntry[$label] ? $seriesEntry[$label] : 0); | |
| } | |
| } | |
| print_r($labels); | |
| print_r($data); | |
| ?> | ?> |