<?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';
error_reporting(E_ERROR);
include_once 'includes/trace.debugger.php';
require_once 'class/webpage.php';
require_once 'class/sql.php';
require_once 'PEAR.php';
require_once 'Auth.php';
//require_once 'ST.LIB.login.inc';
WEBPAGE::START();
// check user auth. status
$auth = new Auth('DB', WEBPAGE::$auth_options, 'checkAccess');
//$auth->setFailedLoginCallback('closePopup');
//$auth->setLoginCallback('closePopup');
$auth->start();
// to be here you need to provide valid username/password
// or have a valid session open
WEBPAGE::LOAD_SESSION();
WEBPAGE::$lang = $_GET['lang'] ? $_GET['lang'] : WEBPAGE::_DEFAULT_LANG;
$_LABELS = WEBPAGE::getCacheData(sprintf(WEBPAGE::_APP_LABELS_FILE, WEBPAGE::$lang));
$_CONF = WEBPAGE::getCacheData(sprintf(WEBPAGE::_APP_CONF_FILE, WEBPAGE::$lang));
// check permissions here .... line below is just an example
//if (!(is_numeric(WEBPAGE::$userAccessCode))) { exit; }
require './includes/index.pub.inc';
function checkAccess()
{
// scripts with public access here
$_PUB['RP.SCR.performance'] = true;
$_PUB['RP.SCR.clientData'] = true;
//check if public access
$_PUB[$_GET['scr_name']] ? '' : exit;
}
require_once 'PEAR.php';
require_once './includes/ST.LIB.login.inc';
//require_once ("Mail.php");
//require_once ("Mail/mime.php");
print "<h1>Advisor Performance Report:</h1>";
print "<hr>";
WEBPAGE::START();
/*
eng - english
esp - spanish
fra - french
*/
if (isset($_GET['lang'])) {
WEBPAGE::$lang = $_GET['lang'];
} else {
WEBPAGE::$lang = 'esp';
}
$_LABELS = WEBPAGE::getCacheData(sprintf(WEBPAGE::_APP_LABELS_FILE, WEBPAGE::$lang));
$_CONF = WEBPAGE::getCacheData(sprintf(WEBPAGE::_APP_CONF_FILE, WEBPAGE::$lang));
if (function_exists('trace')) {
//trace($_CONF);
}
$start_date = $_GET['start'];
$end_date = $_GET['end'];
// Writeoff Amount per Advisor per Date Range
if ($_GET['report'] == "02") {
$riesgo = WEBPAGE::$dbh->getAll(sprintf("SELECT u.id ,\r\n concat(u.first,' ',u.last) AS asesor ,\r\n ROUND( 100 * ( SUM( rp.riskA ) / SUM( rp.balance ) ) , 2 ) AS PAR15_percent ,\r\n ROUND( 100 * ( SUM( rp.riskB ) / SUM( rp.balance ) ) , 2 ) AS PAR30_percent ,\r\n ROUND( 100 * ( SUM( rp.riskC ) / SUM( rp.balance ) ) , 2 ) AS PAR60_percent ,\r\n ROUND( 100 * ( SUM( rp.riskD ) / SUM( rp.balance ) ) , 2 ) AS PAR90_percent ,\r\n\r\n (ROUND( 100 * ( SUM( rp.riskA ) / SUM( rp.balance ) ) , 2 ) +\r\n ROUND( 100 * ( SUM( rp.riskB ) / SUM( rp.balance ) ) , 2 ) +\r\n ROUND( 100 * ( SUM( rp.riskC ) / SUM( rp.balance ) ) , 2 ) +\r\n ROUND( 100 * ( SUM( rp.riskD ) / SUM( rp.balance ) ) , 2 )) AS riesgo_suma,\r\n rp.date\r\nFROM (tblLoans l,\r\n tblUsers u)\r\n\r\nLEFT JOIN tblRiskPortfolio rp ON (l.advisor_id = rp.advisor_id) \r\n\r\nWHERE u.id = l.advisor_id\r\n AND rp.date = '%s'\r\nGROUP BY u.id\r\nORDER BY riesgo_suma ASC;", $end_date));
$_html = "<h1>Riesgo [{$start_date} --- {$end_date}] </h1>";
$_html .= count($riesgo) ? WEBPAGE::printchart($riesgo, array_keys($riesgo[0])) : $_LABELS['noData'];
print $_html;
}
static function LOAD_SESSION()
{
self::$lang = $_SESSION['_authsession']['data']['lang'];
self::$screenWidth = $_SESSION['_authsession']['data']['screenWidth'];
self::$userID = $_SESSION['_authsession']['data']['id'];
self::$userAccessCode = $_SESSION['_authsession']['data']['access_code'];
self::$userName = $_SESSION['_authsession']['data']['first'];
self::$userZone = $_SESSION['_authsession']['data']['zone_id'];
self::$zoneName = $_SESSION['_authsession']['data']['zoneName'];
self::$tabmenu = $_SESSION['_authsession']['data']['tabmenu'];
self::$navtree = $_SESSION['_authsession']['data']['navtree'];
self::$queryCache = sprintf(self::_APP_QUERY_CACHE, str_pad(self::$userID, 3, '0', STR_PAD_LEFT));
}
