Advertisement
Guest User

Untitled

a guest
Sep 29th, 2016
47
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.71 KB | None | 0 0
  1. try {
  2. $db = connectPDO();
  3. $result = $db->query("SELECT naziv_plan AS name,
  4. objava_odluke AS start_date,
  5. datum_stupanja_glasnika AS end_date
  6. FROM ispu_plan
  7. WHERE datum_donosenja_plana
  8. BETWEEN '2014-01-01'
  9. AND CURDATE()
  10. ORDER BY datum_donosenja_plana ASC");
  11.  
  12. $rows = array();
  13. $table = array();
  14. $table['cols'] = array(
  15. array('label' => 'Godina', 'type' => 'string'),
  16. array('label' => 'Odluka', 'type' => 'number'),
  17. array('label' => 'glasnik', 'type' => 'number')
  18. );
  19.  
  20. foreach($result as $r) {
  21. $temp = array();
  22. $temp[] = array('v' => (string) $r['naziv_plan']);
  23. $temp[] = array('v' => (int) $r['objava_odluke']);
  24. $temp[] = array('v' => (int) $r['datum_stupanja_glasnika']);
  25. $rows[] = array('c' => $temp);
  26. }
  27. $table['rows'] = $rows;
  28. $jsonTable = json_encode($table,JSON_NUMERIC_CHECK);
  29. } catch(PDOException $e) {
  30. echo 'ERROR: ' . $e->getMessage();
  31. }
  32.  
  33. {"cols":[{"label":"Godina","type":"string"},{"label":"Odluka","type":"number"},{"label":"glasnik","type":"number"}],"rows":[{"c":[{"v":"Stambenog susjedstva - Stubiu010dki Trnac - I.ID"},{"v":2014},{"v":2014}]},{"c":[{"v":"Prostorni plan ureu0111enja Grada Krapine - IV. ID"},{"v":2013},{"v":2015}]},{"c":[{"v":"Prostorni plan ureu0111enja Grada Donja Stubica - I ID"},{"v":2014},{"v":2015}]},{"c":[{"v":"Generalni urbanistiu010dki plan Grada Krapine - V.ID"},{"v":2015},{"v":2016}]}]}
  34.  
  35. google.charts.setOnLoadCallback(drawChart);
  36. function drawChart() {
  37.  
  38. var container = document.getElementById('timeline');
  39. var chart = new google.visualization.Timeline(container);
  40. var data = new google.visualization.DataTable(<?php echo $jsonTable;?>);
  41. chart.draw(data);
  42.  
  43. +-----------+------------------+-----------------+
  44. | name| | start_date | end_Date |
  45. +-----------+------------------+-----------------+
  46. | example_1 | 2014-06-06 | 2014-12-27 |
  47. | example_1 | 2013-12-31 | 2015-06-07 |
  48. | example_1 | 2016-06-06 | 2015-12-31 |
  49. +-----------+------------------+-----------------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement