Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ...[snip]...
- <body onload="loadChart()">
- <div id="ChartDiv" style="width:600px;height:400px"></div>
- <script type="text/javascript" language="javascript">
- var chart1;
- var vardata;
- function loadChart()
- {
- chart1.setGallery(cfx.Gallery.Pie);
- PopulateBrowserUsage(chart1);
- var fields = chart1.getDataSourceSettings().getFields();
- var field1 = new cfx.FieldMap();
- field1.setName("Legend");
- field1.setUsage(cfx.FieldUsage.RowHeading);
- fields.add(field1);
- var field2 = new cfx.FieldMap();
- field2.setName("Percentage");
- field2.setUsage(cfx.FieldUsage.ColumnHeading);
- fields.add(field2);
- var crosstab = new cfx.data.CrosstabDataProvider();
- crosstab.setDataSource(chart1.getDataSource());
- chart1.setDataSource(crosstab);
- var data = chart1.getData();
- data.setSeries(1);
- chart1.getAllSeries().getPointLabels().setVisible(true);
- var titles = chart1.getTitles();
- var title = new cfx.TitleDockable();
- title.setText("Browser Usage in Africa on August 2013");
- titles.add(title);
- var divHolder = document.getElementById('ChartDiv');
- chart1.create(divHolder);
- }
- function PopulateBrowserUsage(chart1) {
- var items =<?
- // I AM SO, SO SORRY TO DO THIS
- // NO EXAMPLES OF REMOTE DATA VIA JSON
- // MY HEAD HURTS AND I WANT TO GO HOME
- // data pipe
- mysql_connect("server", "tehfuck", "is this") or die("1");
- mysql_select_db("graficos") or die("2");
- $query="select linea, (round(totales/(select sum(totales) from aporte_lineas_total),3))*100 perc from aporte_lineas_total;";
- $res = mysql_query($query) or die ("3");
- print "[";
- $rows = mysql_num_rows($res);
- for ($i=0;$i<$rows;$i++)
- {
- $row=mysql_fetch_array($res);
- $linea = $row[0];
- $perc = $row[1];
- print "{ \"$linea\",\"$perc\" }";
- if ($rows!=($i+1))
- {
- print ",";
- }
- // WAAAAAAIT FOR IT...
- }
- // WAAAAAAIT FOR IT...
- print "]";
- // WAAAAAAIT FOR IT...
- ?>;
- // DONT FORGET THE COLON AT THE END!
- chart1.setDataSource(items);
- }
- </script>
- </body>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement