<?php
// client portfolio graph
// called by RP.SCR.performancePlotter
error_reporting(E_ERROR);
require_once 'class/webpage.php';
require_once 'class/sql.php';
require_once 'PEAR.php';
require_once 'class/graph.php';
WEBPAGE::START();
$_LABELS = WEBPAGE::getCacheData(sprintf(WEBPAGE::_APP_LABELS_FILE, $_GET['lang']));
$_CONF = WEBPAGE::getCacheData(sprintf(WEBPAGE::_APP_CONF_FILE, $_GET['lang']));
if ($_GET['mode'] == 'total') {
$_GET['mode'] = 1;
$_GET['1'] = 1;
}
switch ($_GET['cycle']) {
case 'DAY':
$xrange = WEBPAGE::$dbh->getAll(sprintf('select 1000*YEAR(c.date)+DAYOFYEAR(c.date) as date from tblCalendar as c where c.date >= "%s" and c.date <= "%s" group by date', $_GET['dateFrom'], $_GET['dateTo']));
$mrow = WEBPAGE::$dbh->getAll(sprintf('select 1000*YEAR(cp.date)+DAYOFYEAR(cp.date) as date, sum(cp.clients) as clients, sum(cp.female) as female, sum(cp.male) as male, sum(cp.client_i) as client_i, sum(cp.client_b) as client_b from tblClientPortfolio as cp where 1000*YEAR(cp.date)+DAYOFYEAR(cp.date) >= "%s" and 1000*YEAR(cp.date)+DAYOFYEAR(cp.date) <= "%s" and %s = %s group by date', $xrange[0]['date'], $xrange[count($xrange) - 1]['date'], $_GET['mode'], $_GET[$_GET['mode']]));
$xmin = $_GET['dateFrom'];
$xmax = $_GET['dateTo'];
break;
case 'WEEK':
$xrange = WEBPAGE::$dbh->getAll(sprintf('select 1000*YEAR(c.date)+WEEK(c.date,"%s") as date from tblCalendar as c where c.date >= "%s" and c.date <= "%s" group by date', $_GET['dateFrom'], $_GET['dateFrom'], $_GET['dateTo']));
$mrow = WEBPAGE::$dbh->getAll(sprintf('select 1000*YEAR(cp.date)+WEEK(cp.date,"%s") as date, sum(cp.clients)/7 as clients, sum(cp.female)/7 as female, sum(cp.male)/7 as male, sum(cp.client_i)/7 as client_i, sum(cp.client_b)/7 as client_b from tblClientPortfolio as cp where 1000*YEAR(cp.date)+WEEK(cp.date,"%s") >= "%s" and 1000*YEAR(cp.date)+WEEK(cp.date,"%s") <= "%s" and %s = %s group by date', $_GET['dateFrom'], $_GET['dateFrom'], $xrange[0]['date'], $_GET['dateFrom'], $xrange[count($xrange) - 1]['date'], $_GET['mode'], $_GET[$_GET['mode']]));
$xmin = sprintf('%s/%s', $xrange[0]['date'] - 1000 * floor($xrange[0]['date'] / 1000), floor($xrange[0]['date'] / 1000));
$xmax = sprintf('%s/%s', $xrange[count($xrange) - 1]['date'] - 1000 * floor($xrange[count($xrange) - 1]['date'] / 1000), floor($xrange[count($xrange) - 1]['date'] / 1000));
break;
case 'MONTH':
$xrange = WEBPAGE::$dbh->getAll(sprintf('select 1000*YEAR(c.date)+MONTH(c.date) as date from tblCalendar as c where c.date >= "%s" and c.date <= "%s" group by date', $_GET['dateFrom'], $_GET['dateTo']));
<?php
error_reporting(E_ERROR);
require_once 'class/webpage.php';
require_once 'class/sql.php';
require_once 'PEAR.php';
require_once './includes/ST.LIB.login.inc';
WEBPAGE::START();
WEBPAGE::$lang = 'eng';
$_LABELS = WEBPAGE::getCacheData(sprintf(WEBPAGE::_APP_LABELS_FILE, WEBPAGE::$lang));
$_CONF = WEBPAGE::getCacheData(sprintf(WEBPAGE::_APP_CONF_FILE, WEBPAGE::$lang));
// check run mode
switch (WEBPAGE::$runMode) {
case WEBPAGE::_RUN_MODE_OUTDATED:
break;
default:
if ($_CONF['auto_cron'] == '1') {
exit;
}
WEBPAGE::redirect(sprintf('index.php?lang=%s', WEBPAGE::$lang));
exit;
}
// Chequea que no se ha hecho bk en el dia
//count(WEBPAGE::$dbh->getAll(sprintf("select id from tblDataLog where date = '%s' and script = '%s'",date('Y-m-d'),'index.cron.php'))) ? exit : '';
$rdate = explode('-', WEBPAGE::$runDate);
$p_date = date('Y-m-d', mktime(0, 0, 0, $rdate[1], $rdate[2], $rdate[0], 0) + 24 * 60 * 60);
// Pone sistema en modo 'mantenimiento'. Nadie puede entrar en este modo.
// Usuarios 'logeados' previamente seran desocnectados en la primera accion que ejecuten
WEBPAGE::$dbh->query(sprintf("insert into tblDataLog values ('null','%s',CURTIME(),'maintenance','index.cron.php','','')", $p_date));
// correr procesos
//require 'index.cron.clientPortfolio.inc';
<?php
error_reporting(E_ERROR);
require_once 'class/webpage.php';
require_once 'class/sql.php';
require_once 'PEAR.php';
require_once 'class/graph.php';
WEBPAGE::START();
$_LABELS = WEBPAGE::getCacheData(sprintf(WEBPAGE::_APP_LABELS_FILE, $_GET['lang']));
$mrow = WEBPAGE::$dbh->getAll('select c.gender, zp.short_name as branch, count(c.id) as hits from tblClients as c, tblZones as z, tblZones as zp
where c.zone_id > 0 and z.id = c.zone_id and zp.id = z.parent_id group by c.gender, zp.id');
foreach ($mrow as $key => $val) {
$data[$_LABELS[sprintf('tblClients.gender.%s', $val['gender'])]]['TOTAL'] += $val['hits'];
$data[$_LABELS[sprintf('tblClients.gender.%s', $val['gender'])]][$val['branch']] = $val['hits'];
}
$graph = new Graph('', $_LABELS['tblUsers.zone_id'], '%', $data);
Graph::printStdCols($graph);
