$graph->title->SetFont(FF_VERDANA, FS_NORMAL, 14); $graph->yaxis->title->Set("Flow"); $graph->yaxis->title->SetFont(FF_ARIAL, FS_NORMAL, 12); $graph->yaxis->title->SetMargin(10); // Create the bars and the accbar plot $bplot = new Plot\BarPlot($datay[3]); $bplot->SetFillColor("orange"); $bplot2 = new Plot\BarPlot($datay[2]); $bplot2->SetFillColor("red"); $bplot3 = new Plot\BarPlot($datay[1]); $bplot3->SetFillColor("darkgreen"); $accbplot = new Plot\AccBarPlot(array($bplot, $bplot2, $bplot3)); $accbplot->value->Show(); $graph->Add($accbplot); //Setup the table $table = new GTextTable(); $table->Set($datay); $table->SetPos($tablexpos, $tableypos + 1); $table->SetCellCSIMTarget(1, 1, 'tableex02.php', 'View details'); // Basic table formatting $table->SetFont(FF_ARIAL, FS_NORMAL, 10); $table->SetAlign('right'); $table->SetMinColWidth($cellwidth); $table->SetNumberFormat('%0.1f'); // Format table header row $table->SetRowFillColor(0, 'teal@0.7'); $table->SetRowFont(0, FF_ARIAL, FS_BOLD, 11); $table->SetRowAlign(0, 'center'); // .. and add it to the graph $graph->Add($table); $graph->StrokeCSIM();
$resultaat = $db->query($sql); $data = array(); array_push($data, array('Project shopping - balans inkomsten vs uitgaven', '', '', '')); array_push($data, array('Maand', 'Inkomsten', 'Uitgaven', 'Balans')); while ($row = $resultaat->fetch(PDO::FETCH_ASSOC)) { $tempArray = array($row["maand"], $row["inkomsten"], $row["uitgaven"], calculateBalance($row["inkomsten"], $row['uitgaven'])); array_push($data, $tempArray); } // Setup graph context $graph = new CanvasGraph(803, 387); // Setup the basic table and font $table = new GTextTable(); $table->Set($data); $table->SetFont(FF_TIMES, FS_NORMAL, 11); $table->SetFont(FF_TIMES, FS_NORMAL, 12); $table->SetCellFont(0, 0, FF_ARIAL, FS_BOLD, 16); $table->SetMinColWidth(200); $table->MergeRow(0); // Setup color $table->SetRowFillColor(0, '#0b82ff@0.5'); $table->SetColFillColor(0, '#b7ceff@0.5'); //$table->SetFillColor(0, 0, 4, 0, 'lightgray@0.5'); // Set default table alignment $table->SetAlign('right'); // Add table to graph $graph->Add($table); $table->SetAlign("center"); $table->SetColAlign(0, "left"); $table->SetRowAlign(0, 'center'); // send it back to the client $graph->Stroke();
<?php require_once 'jpgraph/jpgraph.php'; require_once 'jpgraph/jpgraph_canvas.php'; require_once 'jpgraph/jpgraph_table.php'; $cols = 4; $rows = 3; $data = array(array('', 'Jan', 'Feb', 'Mar', 'Apr'), array('Min', '15.2', '12.5', '9.9', '70.0'), array('Max', '23.9', '14.2', '18.6', '71.3')); // Setup basic graph canvas $graph = new CanvasGraph(300, 200); // Create a basic table $table = new GTextTable($cols, $rows); $table->Set($data); $table->SetCellCSIMTarget(1, 1, 'tableex02.php', 'View details'); $table->SetRowFont(0, FF_FONT1, FS_BOLD); $table->SetRowColor(0, 'navy'); $table->SetRowFillColor(0, 'lightgray'); $table->SetColFont(0, FF_FONT1, FS_BOLD); $table->SetColColor(0, 'navy'); $table->SetColFillColor(0, 'lightgray'); $graph->Add($table); $graph->StrokeCSIM();
<?php require_once 'jpgraph/jpgraph.php'; require_once 'jpgraph/jpgraph_canvas.php'; require_once 'jpgraph/jpgraph_table.php'; // Setup graph context $graph = new CanvasGraph(165, 90); // Setup the basic table $data = array(array(1, 2, 3, 4), array(5, 6, 7, 8), array(6, 8, 10, 12)); $table = new GTextTable(); $table->Set($data); // Setup overall table font $table->SetFont(FF_ARIAL, FS_NORMAL, 11); // Setup font and color for row = 2 $table->SetRowFont(2, FF_ARIAL, FS_BOLD, 11); $table->SetRowFillColor(2, 'orange@0.5'); // Setup minimum color width $table->SetMinColWidth(40); // Setup overall cell alignment for the table $table->SetAlign('right'); // Setup overall table border $table->SetBorder(0, 'black'); // Setup overall table grid $table->setGrid(0, 'black'); // Set specific frid for row = 2 $table->SetRowGrid(2, 1, 'black', TGRID_DOUBLE2); // Setup overall number format in all cells $table->SetNumberFormat("%0.1f"); // Add table to the graph $graph->Add($table); // and send it back to the browser
$data = array(array('', 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun'), array('Team 1', '15.2', '12.5', '9.9', '70.0', '22.4', '21.5'), array('Team 2', '23.9', '14.2', '18.6', '71.3', '66.8', '42.6'), array('Sum:')); $r = count($data); $c = 7; for ($i = 1; $i < $c; ++$i) { $tmp = 0; for ($j = 1; $j < $r - 1; ++$j) { $tmp += $data[$j][$i]; } $data[3][$i] = sprintf('%2.1f', $tmp); } $graph = new CanvasGraph(350, 200); $table = new GTextTable(); $table->Init(); $table->Set($data); $table->SetBorder(2, 'black'); // Highlight summation row $table->SetRowFillColor($r - 1, 'yellow'); $table->SetCellAlign($r - 1, 0, 'right'); // Setup row and column headers $table->SetRowFont(0, FF_ARIAL, FS_NORMAL, 10); $table->SetRowColor(0, 'navy'); $table->SetRowFillColor(0, 'lightgray'); $table->SetColFont(0, FF_ARIAL, FS_NORMAL, 10); $table->SetColColor(0, 'navy'); $table->SetColFillColor(0, 'lightgray'); $table->SetRowGrid($r - 1, 1, 'black', TGRID_DOUBLE); $graph->Add($table); $graph->Stroke(); ?>
// Setup the basic table and font $table = new GTextTable(); $table->Set($data); $table->SetFont(FF_ARIAL, FS_NORMAL, 11); // Set default minimum color width $table->SetMinColWidth(40); // Set default table alignment $table->SetAlign('right'); // Set table border $table->SetBorder(0); // Turn off grid $table->setGrid(0); // Setup font $table->SetRowFont(4, FF_ARIAL, FS_BOLD, 11); $table->SetRowFont(0, FF_ARIAL, FS_BOLD, 11); // Setup various grid lines $table->SetRowGrid(4, 2, 'black', TGRID_SINGLE); $table->SetColGrid(1, 3, 'black', TGRID_SINGLE); $table->SetRowGrid(1, 1, 'black', TGRID_SINGLE); // Setup various colors $table->SetFillColor(0, 1, 0, 6, 'black'); $table->SetRowColor(0, 'white'); $table->SetRowFillColor(4, 'lightyellow'); $table->SetFillColor(2, 0, 2, 6, 'lightgray'); // Add table to the graph $graph->Add($table); // Send back to client $graph->Stroke(); ?>
$table = new GTextTable($cols, $rows); $table->Init(); $table->Set($data); $table->SetBorder(2, 'black'); // Setup top row with the year title $table->MergeCells(0, 0, 0, 6); $table->SetRowFont(0, FF_ARIAL, FS_BOLD, 16); $table->SetRowColor(0, 'navy'); $table->SetRowAlign(0, 'center'); // Setup quarter header $table->MergeCells(1, 1, 1, 3); $table->MergeCells(1, 4, 1, 6); $table->SetRowAlign(1, 'center'); $table->SetRowFont(1, FF_ARIAL, FS_BOLD, 10); $table->SetRowColor(1, 'navy'); $table->SetRowFillColor(1, 'lightgray'); $table->SetRowGrid(2, '', 0); // Turn off the gridline just under the top row // Setup row and column headers $table->SetRowFont(2, FF_ARIAL, FS_NORMAL, 11); $table->SetRowColor(2, 'navy'); $table->SetRowFillColor(2, 'lightgray'); $table->SetColFont(0, FF_ARIAL, FS_NORMAL, 11); $table->SetColColor(0, 'navy'); $table->SetColFillColor(0, 'lightgray'); $table->SetCellFillColor(0, 0, 'lightgreen'); $table->SetCellFillColor(1, 0, 'lightgreen'); $table->SetCellFillColor(2, 0, 'lightgreen'); // Highlight cell 2,3 $table->SetCellFillColor(4, 3, 'yellow'); $graph->Add($table);
$table->Set($data); $table->SetFont(FF_ARIAL, FS_NORMAL, 11); // Set default minimum color width $table->SetMinColWidth(40); // Set default table alignment $table->SetAlign('right'); // Turn off grid $table->setGrid(0); // Set table border $table->SetBorder(2); // Setup font $table->SetRowFont(4, FF_ARIAL, FS_BOLD, 11); $table->SetRowFont(0, FF_ARIAL, FS_BOLD, 11); $table->SetFont(1, 2, 1, 3, FF_ARIAL, FS_BOLD, 11); // Setup grids $table->SetRowGrid(4, 2, 'black', TGRID_SINGLE); $table->SetColGrid(1, 1, 'black', TGRID_SINGLE); $table->SetRowGrid(1, 1, 'black', TGRID_SINGLE); // Setup colors $table->SetFillColor(0, 1, 0, 6, 'black'); $table->SetRowColor(0, 'white'); $table->SetRowFillColor(4, 'lightgray@0.3'); $table->SetFillColor(2, 0, 2, 6, 'lightgray@0.6'); $table->SetFillColor(1, 2, 1, 3, 'lightred'); // Add table to graph $graph->Add($table); // Send back to the client $graph->Stroke(); ?>
require_once 'jpgraph/jpgraph_table.php'; // Setup graph context $graph = new CanvasGraph(430, 150); // Setup the basic table $data = array(array('', 'w631', 'w632', 'w633', 'w634', 'w635', 'w636'), array('Critical (sum)', 13, 17, 15, 8, 3, 9), array('High (sum)', 34, 35, 26, 20, 22, 16), array('Low (sum)', 41, 43, 49, 45, 51, 47), array('Sum:', 88, 95, 90, 73, 76, 72)); // Setup a basic table $table = new GTextTable(); $table->Set($data); // Setup fonts $table->SetFont(FF_TIMES, FS_NORMAL, 11); $table->SetColFont(0, FF_ARIAL, FS_NORMAL, 11); $table->SetRowFont(0, FF_ARIAL, FS_NORMAL, 11); $table->SetRowFont(4, FF_TIMES, FS_BOLD, 14); // Turn off the grid $table->SetGrid(0); // Setup color $table->SetRowFillColor(0, 'lightgray@0.5'); $table->SetRowFillColor(4, 'lightgray@0.5'); $table->SetColFillColor(0, 'lightgray@0.5'); $table->SetFillColor(0, 0, 4, 0, 'lightgray@0.5'); // Set default minimum column width $table->SetMinColWidth(45); // Set default table alignment $table->SetAlign('right'); // Add table to the graph $graph->Add($table); // and send it back to the client $graph->Stroke(); ?>