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++)
{
if($_SESSION['user']['baskets'][$i]['abs_basket'] == true && !$abs_basket)
{
echo ''._OTHER_BASKETS.' : | ';
$abs_basket = true;
}
$nb = 0;
if( $_SESSION['user']['baskets'][$i]['result_page'] == "copy_mail" && !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();
}
else if( !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']);
//$db->show();
$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;
$_SESSION['tmp_graph']['labels'] = $_SESSION['labels1'];
$_SESSION['tmp_graph']['values'] = $val_an;
if($_SESSION['config']['enabledprocess'] == "true" && $bool_process == true )
{
$_SESSION['tmp_graph']['val_courbe2'] = $val_perso;
$src1 .= "&plot1_legend="._PLOT1_LEGEND;
$src1 .= "&plot2_legend="._PLOT2_LEGEND;
//$src1 .= "&plot2_legend=".strtoupper($_SESSION['user']['FirstName']).' '.strtoupper($_SESSION['user']['LastName']);
}
?>
!