Sarrerak megalito mota bakoitzeko

Gogoan hartu sarrera batzuk (harrespilak eta eremu tumularrak gehien bat) monumentu multzoak direla. Araba eta Iparraldeko datuak osatugabeak dira oraindik.

<?php // GUZTIRA $result = db_query('SELECT COUNT(*) zenbat, td.name FROM node n LEFT JOIN term_node tn ON n.nid = tn.nid LEFT JOIN term_data td ON tn.tid = td.tid LEFT JOIN term_node tn2 ON n.nid = tn2.nid WHERE td.vid = 27 AND n.type = "megalito" AND tn2.tid IN (SELECT tid FROM term_hierarchy WHERE parent = 1) GROUP BY tn.tid ORDER BY td.tid'); $i = 0; $rows = array(); while($row = db_fetch_object($result)){ $rows[] = "data.setValue($i, 0, '$row->name')\n"; $rows[] = "data.setValue($i, 1, $row->zenbat)\n"; $i++; } ?> google.load("visualization", "1", {packages:["piechart"]}); google.setOnLoadCallback(drawChart); function drawChart() { var data = new google.visualization.DataTable(); data.addColumn('string', 'Megalito mota'); data.addColumn('number', 'Kopurua'); data.addRows(<?php print $i ?>); <?php print join($rows, ''); ?> var chart = new google.visualization.PieChart(document.getElementById('kopuruak')); chart.draw(data, {width: 600, height: 300, is3D: true, title: 'Sarrerak monumentu mota bakoitzeko, guztira.'}); }

Sarrerak monumentu mota nagusi bakoitzeko (bestelakoak bazterrean utzita, errazago alderatzeko).

<?php // NAFARROAN $result = db_query('SELECT COUNT(*) zenbat, td.name FROM node n LEFT JOIN term_node tn ON n.nid = tn.nid LEFT JOIN term_data td ON tn.tid = td.tid LEFT JOIN term_node tn2 ON n.nid = tn2.nid WHERE tn.tid IN (1803, 1804, 1805, 1806) AND n.type = "megalito" AND tn2.tid = 5 GROUP BY tn.tid ORDER BY td.tid'); $i = 0; $rows = array(); while($row = db_fetch_object($result)){ $rows[] = "data.setValue($i, 0, '$row->name')\n"; $rows[] = "data.setValue($i, 1, $row->zenbat)\n"; $i++; } ?> google.load("visualization", "1", {packages:["piechart"]}); google.setOnLoadCallback(drawChart); function drawChart() { var data = new google.visualization.DataTable(); data.addColumn('string', 'Megalito mota'); data.addColumn('number', 'Kopurua'); data.addRows(<?php print $i ?>); <?php print join($rows, ''); ?> var chart = new google.visualization.PieChart(document.getElementById('nafarroa')); chart.draw(data, {width:600, height: 300, is3D: true, title: 'Sarrerak monumentu mota bakoitzeko, Nafarroan.'}); }

<?php // GIPUZKOAN $result = db_query('SELECT COUNT(*) zenbat, td.name FROM node n LEFT JOIN term_node tn ON n.nid = tn.nid LEFT JOIN term_data td ON tn.tid = td.tid LEFT JOIN term_node tn2 ON n.nid = tn2.nid WHERE tn.tid IN (1803, 1804, 1805, 1806) AND n.type = "megalito" AND tn2.tid = 4 GROUP BY tn.tid ORDER BY td.tid'); $i = 0; $rows = array(); while($row = db_fetch_object($result)){ $rows[] = "data.setValue($i, 0, '$row->name')\n"; $rows[] = "data.setValue($i, 1, $row->zenbat)\n"; $i++; } ?> google.load("visualization", "1", {packages:["piechart"]}); google.setOnLoadCallback(drawChart); function drawChart() { var data = new google.visualization.DataTable(); data.addColumn('string', 'Megalito mota'); data.addColumn('number', 'Kopurua'); data.addRows(<?php print $i ?>); <?php print join($rows, ''); ?> var chart = new google.visualization.PieChart(document.getElementById('gipuzkoa')); chart.draw(data, {width: 600, height: 300, is3D: true, title: 'Sarrerak monumentu mota bakoitzeko, Gipuzkoan.'}); }

<?php // BIZKAIAN $result = db_query('SELECT COUNT(*) zenbat, td.name FROM node n LEFT JOIN term_node tn ON n.nid = tn.nid LEFT JOIN term_data td ON tn.tid = td.tid LEFT JOIN term_node tn2 ON n.nid = tn2.nid WHERE tn.tid IN (1803, 1804, 1805, 1806) AND n.type = "megalito" AND tn2.tid = 3 GROUP BY tn.tid ORDER BY td.tid'); $i = 0; $rows = array(); while($row = db_fetch_object($result)){ $rows[] = "data.setValue($i, 0, '$row->name')\n"; $rows[] = "data.setValue($i, 1, $row->zenbat)\n"; $i++; } ?> google.load("visualization", "1", {packages:["piechart"]}); google.setOnLoadCallback(drawChart); function drawChart() { var data = new google.visualization.DataTable(); data.addColumn('string', 'Megalito mota'); data.addColumn('number', 'Kopurua'); data.addRows(<?php print $i ?>); <?php print join($rows, ''); ?> var chart = new google.visualization.PieChart(document.getElementById('bizkaia')); chart.draw(data, {width: 600, height: 300, is3D: true, title: 'Sarrerak monumentu mota bakoitzeko, Bizkaian.'}); }