<?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);