Login   Register  
PHP Classes
elePHPant
Icontem

File: demos/005.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Tom Schaefer  >  d3Google  >  demos/005.php  >  Download  
File: demos/005.php
Role: Example script
Content type: text/plain
Description: fill data tables with data
Class: d3Google
Generate JavaScript to show Google charts and maps
Author: By
Last change:
Date: 2012-12-29 12:28
Size: 1,477 bytes
 

Contents

Class file image Download
<pre><?php 

include_once '../d3.classes.inc.php';
include_once '../google.classes.inc.php';
include_once '../element.php';

$employees = array(
    array("Mike", new Date(2008, 1, 28)),
    array("Bob", new Date(2007, 5, 1)),
    array("Alice", new Date(2006, 7, 16)),
    array("Frank", new Date(2007, 11, 28)),
    array("Floyd", new Date(2005, 3, 13)),
    array("Fritz", new Date(2007, 9, 2)),
);

$data = google()->visualization->DataTable()->createVar("data");
stack()->add($data);
stack()->add(google(true, $data->getVar())->addColumn("string", "Employee Name"));
stack()->add(google(true, $data->getVar())->addColumn("date", "Start Date"));
stack()->add(google(true, $data->getVar())->addRows(6));

foreach($employees as $index => $employee) {
    stack()->add(google(true, $data->getVar())->setCell($index, 0, $employee[0]));
    stack()->add(google(true, $data->getVar())->setCell($index, 1, $employee[1]));
}



$view = google()->visualization->DataView($data->getVar())->createVar("view");
stack()->add($view);

$filter = google(false, $view->getVar())
        ->getFilteredRows(array(array("column" => 1, "minValue" => new Date(2007, 0, 1) ) ) );

stack()->add( google(true, $view->getVar())->setRows($filter) );

$table = google()->visualization->Table(document()->getElementById("test_dataview"))->createVar("table");
stack()->add($table);
stack()->add(google(true, $table->getVar())->draw($view->getVar(), array("sortColumn" => 1)));

echo stack();