function actVisitPerDay()
{
global $ST, $post;
$cond = " DATE(LOG_TIME) BETWEEN '" . dte($post->get('date_from'), 'Y-m-d') . "' AND '" . dte($post->get('date_to'), 'Y-m-d') . "'";
$noBotCond = " AND TRIM(USER_AGENT) <> ''";
foreach ($this->bot as $bot) {
$noBotCond .= " AND USER_AGENT NOT LIKE '%{$bot}%' ";
}
$noBotCond .= " AND REQUEST_URI NOT LIKE '%admin%' ";
$q = "SELECT COUNT(DISTINCT REMOTE_ADDR) as c_d, DATE(LOG_TIME) AS d FROM sc_loger\r\n\t\t\t\tWHERE {$cond} {$noBotCond}\r\n\t\t\t\tGROUP BY d";
$rs = $ST->select($q);
$result = array();
while ($rs->next()) {
$result[$rs->get('d')] = $rs->get('c_d');
}
$diagram = new Diagram();
$diagram->m_width = 3;
$diagram->m_maxHeight = 220;
$i = 0;
foreach ($result as $k => $v) {
$diagram->m_x[$i] = $k;
$diagram->m_y[$i] = $v;
$diagram->m_desc[$i] = preg_replace('|^\\d+-\\d+-|', '', $k);
$i++;
}
echo $diagram->render();
exit;
}
public function diagramsForUserNative($userId, $level)
{
$diagrams = array();
DEBUG ? $_SESSION['logs'][] = __CLASS__ . '{#}' . __FUNCTION__ . "{#}{#}" . __LINE__ : '';
$query = "select diagram.* from diagram, userdiagram\r\n where userdiagram.userId = {$userId}\r\n and userdiagram.diagramId = diagram.id" . (isset($level) ? " and userdiagram.level = '{$level}'" : '') . " order by title";
DEBUG ? $_SESSION['logs'][] = " " . __CLASS__ . '{#}' . __FUNCTION__ . "{#}{$query}{#}" . __LINE__ : '';
#echo $query;
//EXECUTE query
$result = $this->executeSQL($query, $this->con);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$diagram = new Diagram();
$diagram->loadFromSQL($row);
$diagrams[] = $diagram;
}
return $diagrams;
}
<li><span class="legend-impressions"></span><?php
echo JText::_("ADAG_HEAD_IMPRESSIONS");
?>
</li>
<li><span class="legend-clicks"></span><?php
echo JText::_("ADAG_HEAD_CLICKS");
?>
</li>
<li><span class="legend-ctr"></span><?php
echo JText::_("ADAG_HEAD_CLICK_RATIO");
?>
</li>
</ul>
<div class="ada-reports-graph-charts">
<?php
$diagram = new Diagram();
$diagram->plot($advertisers, $campaigns, $ad_name, $all_ads);
?>
</div>
</div>
<div class="ada-reports-table uk-clearfix">
<div class="ada-reports-table-heading">
<div class="uk-grid uk-grid-small">
<div class="uk-width-medium-2-3">
<h4 class="ada-reports-table-title">
<?php
echo JText::_("ADAG_DATE_RANGE_PER_SELECTED_PERIOD");
?>
</h4>
<?php
include "includes/config.php";
include "includes/class.forms.php";
include "includes/funciones.php";
?>
<html>
<head>
</head>
<body>
<?php
try {
$bd = new formas($dsnWriter);
} catch (PDOException $e) {
echo $e->getMessage();
}
$gv1 = NULL;
#arbol_admon();
arbol_admon_presupuesto();
include "includes/diagram/class.diagram.php";
$g = new Diagram();
$g->SetRectangleBorderColor(124, 128, 239);
$g->SetRectangleBackgroundColor(194, 194, 239);
$g->SetFontColor(255, 255, 255);
$g->SetBorderWidth(0);
$g->SetData($gv1);
//$g->Draw();
var_dump($gv1);
?>
</body>
</html>
function diagramGetAll($dbhandle)
{
$diagrams = array();
$query = "SELECT * FROM diagram ORDER BY title";
$result = sqlite_query($dbhandle, $query);
if ($result) {
while ($row = sqlite_fetch_array($result, SQLITE_ASSOC)) {
#print_r($row);
$d = new Diagram();
$d->loadFromSQL($row);
$diagrams[] = $d;
}
}
return $diagrams;
}
/**
* DiagramExtended::DiagramExtended()
*
* Class constructor
**/
function DiagramExtended($xml_file = '')
{
Diagram::Diagram($xml_file);
}
function diagramGetAll2($dbhandle)
{
$diagrams = array();
$query = "SELECT * FROM diagram ORDER BY title";
$results = $this->query($query);
if ($results) {
while ($row = $results->fetchArray()) {
#print_r($row);
$d = new Diagram();
$d->loadFromSQL($row);
$diagrams[] = $d;
}
}
return $diagrams;
}
<?php
require 'class.Diagram.php';
$d = new Diagram();
$d->VLine(0, 10000, 1000);
//min,max,step. FIXME hmm... detta kanske ska räknas ut av datan...
$d->VText("Changes per release");
$d->HLine(11, 24, 1);
//FIXME kanske ska räknas ut...
$d->HText("Days of development");
$d->BGCol(200, 200, 155);
$d->TextCol(0, 0, 0);
$d->LineCol(255, 255, 255);
//$d->AddH(
$d->Size(500, 300);
//pixels
$d->Display();
