load_lang();
$db = new dbquery();
$db->connect();
$db2 = new dbquery();
$db2->connect();
$req = new request();
$list = new list_show();
$graph = new graphics();
$sec = new security();
$status_obj = new manage_status();
$ind_coll = $sec->get_ind_collection('letterbox_coll');
$table = $_SESSION['collections'][$ind_coll]['table'];
$view = $_SESSION['collections'][$ind_coll]['view'];
$search_status = $status_obj->get_searchable_status();
$id_report = $_REQUEST['id_report'];
if(empty($id_report))
{
?>
extract_date('creation_date', 'year')." = '".$_REQUEST['the_year']."'";
$date_title = _FOR_YEAR.' '.$_REQUEST['the_year'];
}
else if($period_type == 'period_month')
{
$arr_month = array('01','02','03','04','05','06','07','08','09','10','11','12');
if(empty($_REQUEST['the_month']) || !isset($_REQUEST['the_month']))
{
?>
extract_date('creation_date', 'year')." = '".$default_year."' and ".$req->extract_date('creation_date', 'month')." = '".$_REQUEST['the_month']."'";
$month = '';
switch($_REQUEST['the_month'])
{
case '01':
$month = _JANUARY;
break;
case '02':
$month = _FEBRUARY;
break;
case '03':
$month = _MARCH;
break;
case '04':
$month = _APRIL;
break;
case '05':
$month = _MAY;
break;
case '06':
$month = _JUNE;
break;
case '07':
$month = _JULY;
break;
case '08':
$month = _AUGUST;
break;
case '09':
$month = _SEPTEMBER;
break;
case '10':
$month = _OCTOBER;
break;
case '11':
$month = _NOVEMBER;
case '12':
$month = _DECEMBER;
break;
default:
$month = '';
}
$date_title = _FOR_MONTH.' '.$month;
}
else if($period_type == 'custom_period')
{
if(isset($_REQUEST['date_start']) && $_REQUEST['date_start'] <> '')
{
$where_date .= " AND ".$req->extract_date('creation_date')." > '".$db->format_date_db($_REQUEST['date_start'])."'";
$date_title .= strtolower(_SINCE).' '.$_REQUEST['date_start'].' ';
}
if(isset($_REQUEST['date_fin']) && $_REQUEST['date_fin'] <> '')
{
$where_date .= " AND ".$req->extract_date('creation_date')." < '".$db->format_date_db($_REQUEST['date_fin'])."'";
$date_title.= strtolower(_FOR).' '.$_REQUEST['date_fin'].' ';
}
if(empty($where_date))
{
$where_date = $req->extract_date('creation_date', 'year')." = '".$default_year."'";
$date_title = _FOR_YEAR.' '.$default_year;
}
}
else
{
?>
query("select type_id, description from ".$_SESSION['tablename']['doctypes']." where enabled = 'Y' order by description");
$doctypes = array();
while($res = $db->fetch_object())
{
array_push($doctypes, array('ID' => $res->type_id, 'LABEL' => $res->description));
}
if($report_type == 'graph')
{
$val_an = array();
$_SESSION['labels1'] = array();
}
elseif($report_type == 'array')
{
$data = array();
}
$has_data = false;
for($i=0; $iquery("SELECT ".$req->get_date_diff('closing_date', 'creation_date' )." AS delay FROM ".$view." WHERE ".$where_date." AND status in ".$str_status." and type_id = ".$doctypes[$i]['ID']."");
if( $db->nb_result() > 0)
{
$tmp = 0;
while($res = $db->fetch_object())
{
$tmp = $tmp + $res->delay;
}
if($report_type == 'graph')
{
array_push($val_an, (string)$tmp / $db->nb_result());
}
elseif($report_type == 'array')
{
array_push($data, array('LABEL' => $db->show_string($doctypes[$i]['LABEL']), 'VALUE' => (string)$tmp / $db->nb_result()));
}
if($tmp / $db->nb_result() > 0)
{
$has_data = true;
}
}
else
{
if($report_type == 'graph')
{
array_push($val_an, 0);
}
elseif($report_type == 'array')
{
array_push($data, array('LABEL' => $db->show_string($doctypes[$i]['LABEL']), 'VALUE' => _UNDEFINED));
}
}
if($report_type == 'graph')
{
array_push($_SESSION['labels1'], $db->show_string($doctypes[$i]['LABEL']));
}
}
if($report_type == 'graph')
{
$src1 = $_SESSION['config']['businessappurl']."index.php?display=true&module=reports&page=graphs&type=histo&largeur=1000&hauteur=400&title=".$title."&labelX="._MONTH."&labelY="._N_DAYS;
for($i=0;$i _DOCTYPE, 'VALUE' => _PROCESS_DELAY));
}
if ( $has_data)
{
if($report_type == 'graph')
{
?>
show_stats_array($title, $data);
}
}
else
{
echo '
'._NO_DATA_MESSAGE.'
';
}
}
if($id_report == 'process_delay_generic_evaluation')
{
$data = "";
//Gestion du graphique par année
//récupération des libellés de mois
$_SESSION['month'] = array();
$_SESSION['month'][1] = _JANUARY;
$_SESSION['month'][2] = _FEBRUARY;
$_SESSION['month'][3] = _MARCH;
$_SESSION['month'][4] = _APRIL;
$_SESSION['month'][5] = _MAY;
$_SESSION['month'][6] = _JUNE;
$_SESSION['month'][7] = _JULY;
$_SESSION['month'][8] = _AUGUST;
$_SESSION['month'][9] = _SEPTEMBER;
$_SESSION['month'][10] = _OCTOBER;
$_SESSION['month'][11] = _NOVEMBER;
$_SESSION['month'][12] = _DECEMBER;
if($report_type == 'graph')
{
$val_an = array();
$_SESSION['labels1'] = $_SESSION['month'];
}
elseif($report_type == 'array')
{
$data = array();
}
//Gestion en mode année
if ($period_type == 'period_year')
{
for($i=1; $i<= 12; $i++)
{
if (!isset($where_date) || empty($where_date)) {
$period = date("Y");
} else {
$period = substr($where_date, -5, -1);
}
$db->query("SELECT ".$req->get_date_diff('closing_date', 'creation_date' )." FROM ".$view." WHERE status in ".$str_status." and date_part( 'month', creation_date) = ".$i." and date_part( 'year', creation_date) = ".$period." AND STATUS = 'END'");
if( $db->nb_result() > 0)
{
$tmp = 0;
while($elm = $db->fetch_array())
{
$tmp = $tmp + $elm[0];
}
if($report_type == 'graph')
{
array_push($val_an, (string)$tmp / $db->nb_result());
}
elseif($report_type == 'array')
{
array_push($data, array('LABEL' => $_SESSION['month'][$i], 'VALUE' => (string)$tmp / $db->nb_result()));
}
if($tmp / $db->nb_result() > 0)
{
$has_data = true;
}
}
else
{
if($report_type == 'graph')
{
array_push($val_an, 0);
}
elseif($report_type == 'tab')
{
array_push($data, array('LABEL' => $_SESSION['month'][$i], 'VALUE' => _UNDEFINED));
}
}
}
$title = _REPORTS_EVO_PROCESS.' '.$date_title ;
if($report_type == 'graph')
{
$src1 = $_SESSION['config']['businessappurl']."index.php?display=true&module=reports&page=graphs&type=courbe&largeur=1000&hauteur=400&title=".$title."&labelX="._MONTH."&labelY="._N_DAYS;
for($k=1;$k<=count($_SESSION['labels1']);$k++)
{
$src1 .= "&labels[]=".$_SESSION['labels1'][$k];
}
for($l=0;$l _MONTH, 'VALUE' => _PROCESS_DELAI_AVG));
}
}
//Gestion du graphique par mois
if ($period_type == 'period_month')
{
if($report_type == 'graph')
{
$val_mois = array();
}
elseif($report_type == 'graph')
{
$data = array();
}
//$max = date("t", $_REQUEST['the_month']);
$mois = mktime( 0, 0, 0, $_REQUEST['the_month'], 1, date("Y") );
$max = date("t",$mois);
for($i=1; $i<= $max; $i++)
{
$db->query("SELECT ".$req->get_date_diff('closing_date', 'creation_date' )." FROM ".$view." WHERE status in ".$str_status." and date_part( 'month', creation_date) = ".$_REQUEST['the_month']." and date_part( 'year', creation_date) = ".date('Y')." and date_part( 'day', creation_date) = ".$i." AND STATUS = 'END'");
if( $db->nb_result() > 0)
{
$tmp = 0;
while($elm = $db->fetch_array())
{
$tmp = $tmp + $elm[0];
}
if($report_type == 'graph')
{
array_push($val_mois, (string) $tmp / $db->nb_result());
}
elseif($report_type == 'array')
{
array_push($data, array('LABEL' => $i, 'VALUE' => (string) $tmp / $db->nb_result()));
}
$has_data = true;
}
else
{
if($report_type == 'graph')
{
array_push($val_mois, 0);
}
elseif($report_type == 'array')
{
array_push($data, array('LABEL' => $i, 'VALUE' => _UNDEFINED));
}
}
}
$title2 = _REPORTS_EVO_PROCESS;
if($report_type == 'graph')
{
$src2 = $_SESSION['config']['businessappurl']."index.php?display=true&module=reports&page=graphs&type=courbe&largeur=1000&hauteur=406&title=".$title2."&labelX="._DAYS."&labelY="._N_DAYS;
for($k=1;$k<=$max;$k++)
{
$src2 .= "&labels[]=".$k;
}
for($l=0;$l _DAYS, 'VALUE' => _PROCESS_DELAI_AVG));
}
}
if ($period_type == 'period_year' && $has_data)
{
if($report_type == 'graph')
{
?>
show_stats_array($title1, $data);
}
}
elseif ($period_type == 'period_month' && $has_data)
{
if($report_type == 'graph')
{?>
show_stats_array($title2, $data);
}
}
else
{
echo '
'._NO_DATA_MESSAGE.'
';
}
}
else if($id_report == 'mail_typology')
{
$has_data = false;
$title = _MAIL_TYPOLOGY_REPORT.' '.$date_title ;
$db->query("select distinct type_id, type_label from ".$view ." where status in ".$str_status." and ".$where_date);
//$db->show();
if($report_type == 'graph')
{
$vol_an = array();
$vol_mois = array();
$_SESSION['labels1'] = array();
}
elseif($report_type == 'array')
{
$data = array();
}
while($line = $db->fetch_object())
{
$db2->query("select count(*) as total from ".$view." where status in ".$str_status." and ".$where_date." and type_id = ".$line->type_id."");
$res = $db2->fetch_object();
if($report_type == 'graph')
{
array_push($_SESSION['labels1'], (string) $line->type_label);
array_push($vol_an, $res->total);
}
elseif($report_type == 'array')
{
array_push($data, array('LABEL' =>$line->type_label, 'VALUE' => $res->total ));
}
if($res->total > 0)
{
$has_data = true;
}
}
if($report_type == 'graph')
{
$src1 = $_SESSION['config']['businessappurl']."index.php?display=true&module=reports&page=graphs&type=pie&largeur=1000&hauteur=300&title=".$title;
for($i=0;$i _DOCTYPE, 'VALUE' => _NB_MAILS1));
}
//echo $src1;
if($has_data)
{
if($report_type == 'graph')
{
?>
show_stats_array($title, $data);
}
}
else
{
echo '
'._NO_DATA_MESSAGE.'
';
}
exit();
}
else if($id_report == 'mail_vol_by_cat')
{
$has_data = false;
$title = _MAIL_VOL_BY_CAT_REPORT.' '.$date_title ;
if($report_type == 'graph')
{
$vol_an = array();
$vol_mois = array();
$_SESSION['labels1'] = array();
}
elseif($report_type == 'array')
{
$data = array();
}
foreach(array_keys($_SESSION['mail_categories']) as $key)
{
$db->query("select count(*) as total from ".$view." where status in ".$str_status." and ".$where_date." and category_id = '".$key."'");
$res = $db->fetch_object();
if($report_type == 'graph')
{
array_push($_SESSION['labels1'], $db->wash_html($_SESSION['mail_categories'][$key], 'NO_ACCENT'));
array_push($vol_an, $res->total);
}
elseif($report_type == 'array')
{
array_push($data, array('LABEL' => $_SESSION['mail_categories'][$key], 'VALUE' => $res->total ));
}
if($res->total > 0)
{
$has_data = true;
}
}
if($report_type == 'graph')
{
$src1 = $_SESSION['config']['businessappurl']."index.php?display=true&module=reports&page=graphs&type=pie&largeur=1000&hauteur=300&title=".$title;
for($i=0;$i _CATEGORY, 'VALUE' => _NB_MAILS1));
}
//echo $src1;
if($has_data)
{
if($report_type == 'graph')
{
?>
show_stats_array($title, $data);
}
}
else
{
echo '
'._NO_DATA_MESSAGE.'
';
}
exit();
}