Ejemplo n.º 1
0
$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();
Ejemplo n.º 2
0
$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();
Ejemplo n.º 3
0
<?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();
Ejemplo n.º 4
0
<?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
Ejemplo n.º 5
0
$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();
?>

Ejemplo n.º 6
0
// 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();
?>

Ejemplo n.º 7
0
$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);
Ejemplo n.º 8
0
$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();
?>

Ejemplo n.º 9
-4
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();
?>