Advertisement
jci

Untitled

jci
May 31st, 2014
220
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.98 KB | None | 0 0
  1. ...[snip]...
  2. <body onload="loadChart()">
  3. <div id="ChartDiv" style="width:600px;height:400px"></div>
  4. <script type="text/javascript" language="javascript">
  5. var chart1;
  6. var vardata;
  7. function loadChart()
  8.  
  9. {
  10.  
  11. chart1.setGallery(cfx.Gallery.Pie);
  12. PopulateBrowserUsage(chart1);
  13. var fields = chart1.getDataSourceSettings().getFields();
  14.  
  15. var field1 = new cfx.FieldMap();
  16. field1.setName("Legend");
  17. field1.setUsage(cfx.FieldUsage.RowHeading);
  18. fields.add(field1);
  19.  
  20. var field2 = new cfx.FieldMap();
  21. field2.setName("Percentage");
  22. field2.setUsage(cfx.FieldUsage.ColumnHeading);
  23. fields.add(field2);
  24.  
  25. var crosstab = new cfx.data.CrosstabDataProvider();
  26.  
  27. crosstab.setDataSource(chart1.getDataSource());
  28. chart1.setDataSource(crosstab);
  29. var data = chart1.getData();
  30. data.setSeries(1);
  31.  
  32. chart1.getAllSeries().getPointLabels().setVisible(true);
  33. var titles = chart1.getTitles();
  34. var title = new cfx.TitleDockable();
  35. title.setText("Browser Usage in Africa on August 2013");
  36. titles.add(title);
  37.  
  38. var divHolder = document.getElementById('ChartDiv');
  39. chart1.create(divHolder);
  40.  
  41. }
  42.  
  43. function PopulateBrowserUsage(chart1) {
  44. var items =<?
  45.  
  46. // I AM SO, SO SORRY TO DO THIS
  47. // NO EXAMPLES OF REMOTE DATA VIA JSON
  48. // MY HEAD HURTS AND I WANT TO GO HOME
  49.  
  50. // data pipe
  51. mysql_connect("server", "tehfuck", "is this") or die("1");
  52. mysql_select_db("graficos") or die("2");
  53. $query="select linea, (round(totales/(select sum(totales) from aporte_lineas_total),3))*100 perc from aporte_lineas_total;";
  54. $res = mysql_query($query) or die ("3");
  55.  
  56. print "[";
  57. $rows = mysql_num_rows($res);
  58. for ($i=0;$i<$rows;$i++)
  59. {
  60. $row=mysql_fetch_array($res);
  61. $linea = $row[0];
  62. $perc = $row[1];
  63. print "{ \"$linea\",\"$perc\" }";
  64.  
  65. if ($rows!=($i+1))
  66. {
  67. print ",";
  68. }
  69.  
  70. // WAAAAAAIT FOR IT...
  71. }
  72. // WAAAAAAIT FOR IT...
  73. print "]";
  74. // WAAAAAAIT FOR IT...
  75. ?>;
  76.  
  77. // DONT FORGET THE COLON AT THE END!
  78.  
  79. chart1.setDataSource(items);
  80. }
  81.  
  82. </script>
  83. </body>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement