Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try {
- $db = connectPDO();
- $result = $db->query("SELECT naziv_plan AS name,
- objava_odluke AS start_date,
- datum_stupanja_glasnika AS end_date
- FROM ispu_plan
- WHERE datum_donosenja_plana
- BETWEEN '2014-01-01'
- AND CURDATE()
- ORDER BY datum_donosenja_plana ASC");
- $rows = array();
- $table = array();
- $table['cols'] = array(
- array('label' => 'Godina', 'type' => 'string'),
- array('label' => 'Odluka', 'type' => 'number'),
- array('label' => 'glasnik', 'type' => 'number')
- );
- foreach($result as $r) {
- $temp = array();
- $temp[] = array('v' => (string) $r['naziv_plan']);
- $temp[] = array('v' => (int) $r['objava_odluke']);
- $temp[] = array('v' => (int) $r['datum_stupanja_glasnika']);
- $rows[] = array('c' => $temp);
- }
- $table['rows'] = $rows;
- $jsonTable = json_encode($table,JSON_NUMERIC_CHECK);
- } catch(PDOException $e) {
- echo 'ERROR: ' . $e->getMessage();
- }
- {"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}]}]}
- google.charts.setOnLoadCallback(drawChart);
- function drawChart() {
- var container = document.getElementById('timeline');
- var chart = new google.visualization.Timeline(container);
- var data = new google.visualization.DataTable(<?php echo $jsonTable;?>);
- chart.draw(data);
- +-----------+------------------+-----------------+
- | name| | start_date | end_Date |
- +-----------+------------------+-----------------+
- | example_1 | 2014-06-06 | 2014-12-27 |
- | example_1 | 2013-12-31 | 2015-06-07 |
- | example_1 | 2016-06-06 | 2015-12-31 |
- +-----------+------------------+-----------------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement