query("SELECT VALUE from welcome_txt WHERE ID='WELCOME'");
//$db->show();
$welcome_txt = $db->fetch_object(); ?>
show_array($_SESSION['user']['baskets']);
for($i=0;$i < count($_SESSION['user']['baskets']);$i++)
{
$nb = 0;
if($_SESSION['user']['baskets'][$i]['basket_id'] == 'CopyMailBasket' && !empty($_SESSION['user']['baskets'][$i]['table']))
{
$db->query('select r.RES_ID from '.$_SESSION['user']['baskets'][$i]['table']." r, ".$_SESSION['tablename']['listinstance']." l where ".$_SESSION['user']['baskets'][$i]['clause']);
$nb = $db->nb_result();
}
elseif($_SESSION['user']['baskets'][$i]['basket_id'] == "DepartmentBasket")
{
$where2 = '';
for($j=0; $j < count($_SESSION['user']['security']);$j++)
{
if($_SESSION['user']['baskets'][$i]['table'] == $_SESSION['user']['security'][$j]['table'])
{
$where2 = $_SESSION['user']['security'][$j]['where'];
break;
}
}
if(!empty($where2))
{
$where2 = " and (".$where2.")";
}
$db->query('select RES_ID from '.$_SESSION['user']['baskets'][$i]['table']." where ".$_SESSION['user']['baskets'][$i]['clause'].' '.$where2);
$nb = $db->nb_result();
}
elseif( !empty($_SESSION['user']['baskets'][$i]['table']) && !empty($_SESSION['user']['baskets'][$i]['clause']))
{
$db->query('select RES_ID from '.$_SESSION['user']['baskets'][$i]['table']." where ".$_SESSION['user']['baskets'][$i]['clause']);
$nb = $db->nb_result();
}
?>
:
query("SELECT datediff( custom_d3, creation_date ) AS DELAI FROM ".$table." WHERE month( creation_date ) = ".$i." AND STATUS = 'END' and YEAR(creation_date) = ".$year." AND IS_FOLDER = 'Y' ");
//$db->show();
if( $db->nb_result() > 0)
{
$tmp = 0;
while($res = $db->fetch_object())
{
$tmp = $tmp + $res->DELAI;
}
array_push($val_an, $tmp / $db->nb_result());
}
else
{
array_push($val_an, 0);
}
}
$_SESSION['labels1'] = array(_JANUARY_SHORT, _FEBRUARY_SHORT, _MARCH_SHORT, _APRIL_SHORT, _MAY_SHORT, _JUNE_SHORT, _JULY_SHORT, _AUGUST_SHORT, _SEPTEMBER_SHORT, _OCTOBER_SHORT, _NOVEMBER_SHORT, _DECEMBER_SHORT);
$title1 = _TITLE_STATS_ONE.": ".date("Y");
$type_courbe = "courbe";
$bool_process = false;
for($i=0;$i
query("SELECT datediff( custom_d3, creation_date ) AS DELAI FROM ".$table." WHERE month( creation_date ) = ".$i." AND STATUS = 'END' and YEAR(creation_date) = ".$year." and DEST_USER = '".$_SESSION['user']['UserId']."' ");
//$db->show();
if( $db->nb_result() > 0)
{
$tmp = 0;
while($res = $db->fetch_object())
{
$tmp = $tmp + $res->DELAI;
}
array_push($val_perso, $tmp / $db->nb_result());
}
else
{
array_push($val_perso, 0);
}
}
$type_courbe = "2courbes";
}
$src1 = "graphs.php?type=".$type_courbe."&largeur=320&hauteur=400&titre=".$title1."&labelX=MOIS&labelY="._N_DAYS;
for($i=0;$i
!