$bar_data2 = array();
foreach ($result as $row) {
if ($row[1] == 0) {
$row[1] = "\n<div class=\"ui ribbon label\">All values</div>\n";
$row[0] = "<a href=\"https://wikidata.org/wiki/P" . $row[0] . "\">P" . $row[0] . "</a>";
} else {
$row[1] = "Q" . $row[1];
$row[0] = "P" . $row[0];
$sum_pie = $sum_pie + (int) $row[3];
$pie_data[] = $row[3];
$pie_data2[] = $row[1];
$row[1] = "<a href=\"https://wikidata.org/wiki/" . $row[1] . "\">" . $row[1] . "</a>";
}
$d = array($row[0], $row[1], number_format($row[2]), number_format($row[3]), fixer($row[4] / $row[2]), fixer($row[5] / $row[2]), fixer($row[6] / $row[2]), fixer($row[7] / $row[2]), fixer($row[8] / $row[2]), fixer($row[9] / $row[2]), fixer($row[10] / $row[2]));
$bar_data[] = implode(',', array(fixer($row[4] / $row[2]), fixer($row[5] / $row[2]), fixer($row[6] / $row[2]), fixer($row[7] / $row[2])));
$bar_data2[] = implode(',', array(fixer($row[8] / $row[2]), fixer($row[9] / $row[2]), fixer($row[10] / $row[2])));
echo "<tr>\n<td>{$d[0]}</td>\n<td>{$d[1]}</td><td>{$d[2]}</td><td>{$d[3]}</td><td>{$d[4]}</td><td>{$d[5]}</td><td>{$d[6]}</td><td>{$d[7]}</td><td>{$d[8]}</td><td>{$d[9]}</td><td>{$d[10]}</td></tr>";
}
echo "</tbody>\n</table>";
$pie_data[] = $first_row - $sum_pie;
$legend = array('All');
$legend = array_merge($legend, $pie_data2);
$pie_data2[] = "Other";
$pie_data = implode("|", $pie_data);
$pie_data2 = implode("|", $pie_data2);
$bar_data = implode("|", $bar_data);
$bar_data2 = implode("|", $bar_data2);
$legend = implode("|", $legend);
echo "<div class=\"ui large rounded bordered images\">";
echo "<img src=\"pie.php?d={$pie_data}&l={$pie_data2}\">";
echo "<img src=\"bar.php?d={$bar_data}&title=Average data per statement&x=&y=&xaxis=label|sitelink|desc.|claim&legend={$legend}\">";
$row[0] = "<a href=\"https://wikidata.org/wiki/Property:P" . $row[0] . "\">" . $labels["P" . $row[0]] . "</a>";
} else {
$row[0] = $labels["P" . $row[0]];
$row[1] = "P" . $row[1];
$sum_pie = $sum_pie + (int) $row[3];
$pie_data[] = $row[3];
$pie_data2[] = $row[1];
$row[1] = "<a href=\"https://wikidata.org/wiki/Property:" . $row[1] . "\">" . $labels[$row[1]] . "</a>";
}
if ($row[2] == 0) {
$row[2] = "\n<div class=\"ui ribbon label\">All values</div>\n";
} else {
$row[2] = "Q" . $row[2];
$row[2] = "<a href=\"https://wikidata.org/wiki/" . $row[2] . "\">" . $labels[$row[2]] . "</a>";
}
$d = array($row[0], $row[2], $row[1], number_format($row[3]), fixer($row[4] / $row[3]), fixer($row[5] / $row[3]), fixer($row[6] / $row[3]), fixer($row[7] / $row[3]), fixer($row[8] / $row[3]), fixer($row[9] / $row[3]));
//$bar_data[] = implode(',', array(fixer($row[4] / $row[2]), fixer($row[5] / $row[2]), fixer($row[6] / $row[2]), fixer($row[7] / $row[2])));
//$bar_data2[] = implode(',', array(fixer($row[8] / $row[2]), fixer($row[9] / $row[2]), fixer($row[10] / $row[2])));
echo "<tr>\n<td>{$d[0]}</td>\n<td>{$d[1]}</td><td>{$d[2]}</td><td>{$d[3]}</td><td>{$d[4]}</td><td>{$d[5]}</td><td>{$d[6]}</td><td>{$d[7]}</td><td>{$d[8]}</td><td>{$d[9]}</td></tr>";
}
echo "</tbody>\n</table>";
//$pie_data[] = $first_row - $sum_pie;
//$legend = array('All');
//$legend = array_merge($legend, $pie_data2);
//$pie_data2[] = "Other";
//$pie_data = implode("|", $pie_data);
//$pie_data2 = implode("|", $pie_data2);
//$bar_data = implode("|", $bar_data);
//$bar_data2 = implode("|", $bar_data2);
//$legend = implode("|", $legend);
//echo "<div class=\"ui large rounded bordered images\">";
