<?php
include_once 'Google.merge.v_1_0.php';
$v = new Google_Visualization("Table");
$c = new Google_Config("Table");
$c->setProperty("showRowNumber", true);
// data
$o = new Google_Data_Base();
$o->addColumn("0", "Country", "string");
$o->addColumn("1", "Sales", "number");
$o->addColumn("2", "Expenses", "number");
$o->addNewRow();
$o->addStringCellToRow("US");
$o->addNumberCellToRow(10000, "400.0");
$o->addNumberCellToRow(8000, "400.0");
$o->addNewRow();
$o->addStringCellToRow("CA");
$o->addNumberCellToRow(7000, "400.0");
$o->addNumberCellToRow(5000, "400.0");
$o->addNewRow();
$o->addStringCellToRow("CN");
$o->addNumberCellToRow(8000, "400.0");
$o->addNumberCellToRow(12000, "400.0");
$o->addNewRow();
$o->addStringCellToRow("UK");
$o->addNumberCellToRow(7000, "400.0");
$o->addNumberCellToRow(15000, "400.0");
$v->setConfig($c);
$v->setData($o);
?>
<html>
<?php
include_once 'Google.merge.v_1_0.php';
// main
$v = new Google_Visualization("Table_Format");
// config
$c = new Google_Config("Table");
$c->setProperty("allowHtml", true);
// format
$f = Google_Format::factory("Bar");
$f->min = -10000;
$f->max = 10000;
$f->drawZeroLine = true;
$f->colorNegative = 'red';
$f->showValue = false;
$f->width = 250;
$f->format("data", 1);
$c->setProperty("showRowNumber", true);
// data
$o = new Google_Data_Base();
$o->addColumn("0", "Country", "string");
$o->addColumn("1", "Sales", "number");
$o->addColumn("2", "Expenses", "number");
$o->addNewRow();
$o->addStringCellToRow("US");
$o->addNumberCellToRow(10000);
$o->addNumberCellToRow(8000);
$o->addNewRow();
$o->addStringCellToRow("CA");
$o->addNumberCellToRow(-7000);
$o->addNumberCellToRow(5000);
$chartTypes = array("AreaChart", "BarChart", "ColumnChart", "LineChart", "PieChart", "Table");
if ($_POST and array_key_exists("chartType", $_POST) and in_array($_POST["chartType"], $chartTypes)) {
$chartType = $_POST["chartType"];
if (array_key_exists("qry", $_POST) and $_POST["useQuery"] == "on") {
$query = $_POST["qry"];
} else {
$query = 'SELECT A,D WHERE D > 100 ORDER BY D';
}
} else {
$chartType = 'AreaChart';
$query = 'SELECT A,D WHERE D > 100 ORDER BY D';
}
$id = 'viz';
$url = 'http://spreadsheets.google.com/tq?key=pCQbetd-CptGXxxQIG7VFIQ&pub=1';
# new visualization using template default
$v = new Google_Visualization("Default");
# register package
$p = new Google_Package(array("packages" => array($chartType), "language" => "de_DE"));
$v->setPackage($p);
// set package object to visualization
# setup chart
$chart = new Google_Chart($chartType, Google_Base::getElementById($id));
$options = new Google_Config($chartType);
$options->setProperty("width", 550);
$chart->draw("data", $options);
# init functions
$f1 = new Google_Function('drawVisualization');
$f2 = new Google_Function('handleQueryResponse', array('response'));
# setup query
$q = new Google_Data_Query($url);
$q->setQuery($query);
