'._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'._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." ORDER BY type_label ASC");
$db->query("select type_id, description from ".$_SESSION['tablename']['doctypes']." where enabled = 'Y' order by description");
//$db->show();
if($report_type == 'graph')
{
$vol_an = array();
$vol_mois = array();
$_SESSION['labels1'] = array();
}
elseif($report_type == 'array')
{
$data = array();
}
$totalCourrier=array();
$totalEntities = count($entities);
$z=0;
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)utf8_decode($line->type_label));
array_push($_SESSION['labels1'], (string)utf8_decode($line->description));
array_push($vol_an, $res->total);
}
elseif($report_type == 'array')
{
array_push($data, array('LABEL' =>$line->description, 'VALUE' => $res->total ));
array_push($totalCourrier, $res->total);
}
if($res->total > 0)
{
$has_data = true;
}
$totalDocTypes=$z++;
}
if($report_type == 'array'){
$totalCourriers=array_sum($totalCourrier);
array_push($data, array('LABEL' => 'Total :', 'VALUE' => $totalCourriers ));
}
if($report_type == 'graph')
{
$largeur=50*$totalDocTypes;
if ($totalDocTypes<20){
$largeur=1000;
}
$src1 = $_SESSION['config']['businessappurl']."index.php?display=true&module=reports&page=graphs&type=histo&largeur=$largeur&hauteur=600&marge_bas=150&title=".$title;
$_SESSION['GRAPH']['VALUES']='';
for($i=0;$ishow_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();
}
$totalCourrier=array();
$totalEntities = count($entities);
foreach(array_keys($_SESSION['coll_categories']['letterbox_coll']) as $key)
{
if($key!='default_category'){
$db->query("select count(*) as total from ".$view." where status not in ('DEL') and ".$where_date." and category_id = '".$key."'");
$res = $db->fetch_object();
if($report_type == 'graph')
{
array_push($_SESSION['labels1'], utf8_decode($db->wash_html($_SESSION['coll_categories']['letterbox_coll'][$key], 'NO_ACCENT')));
array_push($vol_an, $res->total);
}
elseif($report_type == 'array')
{
array_push($data, array('LABEL' => $_SESSION['coll_categories']['letterbox_coll'][$key], 'VALUE' => $res->total ));
array_push($totalCourrier, $res->total);
}
if($res->total > 0)
{
$has_data = true;
}
}
}
if($report_type == 'array'){
$totalCourriers=array_sum($totalCourrier);
array_push($data, array('LABEL' => 'Total :', 'VALUE' => $totalCourriers ));
}
if($report_type == 'graph')
{
$largeur=50*$totalEntities;
if ($totalEntities<5){
$largeur=1000;
}
$src1 = $_SESSION['config']['businessappurl']."index.php?display=true&module=reports&page=graphs&type=histo&largeur=$largeur&hauteur=600&marge_bas=150&title=".$title;
$_SESSION['GRAPH']['VALUES']='';
for($i=0;$ishow_stats_array($title, $data); } } else { echo '
'._NO_DATA_MESSAGE.'
';
}
exit();
}