query("SELECT VALUE from welcome_txt WHERE ID='WELCOME'");
//$db->show();
$welcome_txt = $db->fetch_object(); ?>
:
0)
{
echo"";
}
////$db->show_array($_SESSION['user']['baskets']);
//exit;
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;
//SELECT
if( isset($_SESSION['user']['baskets'][$i]['select']) )
{
$select = $_SESSION['user']['baskets'][$i]['select'];
}
else
{
$select = " * ";
}
//FROM
if( isset($_SESSION['user']['baskets'][$i]['table']) )
{
$from = $_SESSION['user']['baskets'][$i]['table'];
}
else
{
$from = "";
}
//WHERE
if( isset($_SESSION['user']['baskets'][$i]['clause']) )
{
$where = $_SESSION['user']['baskets'][$i]['clause'];
}
else
{
$where = "";
}
//GROUP_BY
if( isset($_SESSION['user']['baskets'][$i]['group_by']) )
{
$group_by = $_SESSION['user']['baskets'][$i]['group_by'];
}
else
{
$group_by = "";
}
//ORDER_BY
if( isset($_SESSION['user']['baskets'][$i]['order_by']) )
{
$order_by = $_SESSION['user']['baskets'][$i]['order_by'];
}
else
{
$order_by = "";
}
//LIMIT
if( isset($_SESSION['user']['baskets'][$i]['limit']) )
{
$limit = $_SESSION['user']['baskets'][$i]['limit'];
}
else
{
$limit = "";
}
$query = "SELECT ".$select." FROM ".$from." WHERE ".$where." ";
if( $group_by != "" ) $query .= " GROUP BY ".$group_by;
if( $order_by != "" ) $query .= " ORDER BY ".$order_by;
if( $limit != "" ) $query .= " LIMIT ".$limit;
$db->query($query);
$nb = $db->nb_result();
/* OLD BASKET
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();
}
*/
?>
 | : | |
0)
{
echo"
";
}
?>
:
0)
{
echo"";
}
//$db->show_array($_SESSION['user']['baskets_gdd']);
for($i=0;$i < count($_SESSION['user']['baskets_gdd']);$i++)
{
$nb = 0;
//SELECT
if( isset($_SESSION['user']['baskets_gdd'][$i]['select']) )
{
$select = $_SESSION['user']['baskets_gdd'][$i]['select'];
}
else
{
$select = " * ";
}
//FROM
if( isset($_SESSION['user']['baskets_gdd'][$i]['table']) )
{
$from = $_SESSION['user']['baskets_gdd'][$i]['table'];
}
else
{
$from = "";
}
//WHERE
if( isset($_SESSION['user']['baskets_gdd'][$i]['clause']) )
{
$where = $_SESSION['user']['baskets_gdd'][$i]['clause'];
}
else
{
$where = "";
}
//GROUP_BY
if( isset($_SESSION['user']['baskets_gdd'][$i]['group_by']) )
{
$group_by = $_SESSION['user']['baskets_gdd'][$i]['group_by'];
}
else
{
$group_by = "";
}
//ORDER_BY
if( isset($_SESSION['user']['baskets_gdd'][$i]['order_by']) )
{
$order_by = $_SESSION['user']['baskets_gdd'][$i]['order_by'];
}
else
{
$order_by = "";
}
//LIMIT
if( isset($_SESSION['user']['baskets_gdd'][$i]['limit']) )
{
$limit = $_SESSION['user']['baskets_gdd'][$i]['limit'];
}
else
{
$limit = "";
}
$query = "SELECT ".$select." FROM ".$from." WHERE ".$where." ";
if( $group_by != "" ) $query .= " GROUP BY ".$group_by;
if( $order_by != "" ) $query .= " ORDER BY ".$order_by;
if( $limit != "" ) $query .= " LIMIT ".$limit;
$db->query($query);
$nb = $db->nb_result();
?>
| | : | |
0)
{
echo"
";
}
?>
:
0)
{
echo"";
}
//$db->show_array($_SESSION['user']['other_link']);
for($i=0;$i < count($_SESSION['user']['other_link']);$i++)
{
/*
$nb = 0;
if( $_SESSION['user']['other_link'][$i]['result_page'] == "copy_mail" && !empty($_SESSION['user']['other_link'][$i]['table']))
{
$db->query('select r.RES_ID from '.$_SESSION['user']['other_link'][$i]['table']." r, ".$_SESSION['tablename']['listinstance']." l where ".$_SESSION['user']['other_link'][$i]['clause']);
$nb = $db->nb_result();
}
else if( !empty($_SESSION['user']['other_link'][$i]['table']) && !empty($_SESSION['user']['other_link'][$i]['clause']))
{
$db->query('select RES_ID from '.$_SESSION['user']['other_link'][$i]['table']." where ".$_SESSION['user']['other_link'][$i]['clause']);
//$db->show();
$nb = $db->nb_result();
}
*/
$nb = 0;
//SELECT
if( isset($_SESSION['user']['other_link'][$i]['select']) )
{
$select = $_SESSION['user']['other_link'][$i]['select'];
}
else
{
$select = " * ";
}
//FROM
if( isset($_SESSION['user']['other_link'][$i]['table']) )
{
$from = $_SESSION['user']['other_link'][$i]['table'];
}
else
{
$from = "";
}
//WHERE
if( isset($_SESSION['user']['other_link'][$i]['clause']) )
{
$where = $_SESSION['user']['other_link'][$i]['clause'];
}
else
{
$where = "";
}
//GROUP_BY
if( isset($_SESSION['user']['other_link'][$i]['group_by']) )
{
$group_by = $_SESSION['user']['other_link'][$i]['group_by'];
}
else
{
$group_by = "";
}
//ORDER_BY
if( isset($_SESSION['user']['other_link'][$i]['order_by']) )
{
$order_by = $_SESSION['user']['other_link'][$i]['order_by'];
}
else
{
$order_by = "";
}
//LIMIT
if( isset($_SESSION['user']['other_link'][$i]['limit']) )
{
$limit = $_SESSION['user']['other_link'][$i]['limit'];
}
else
{
$limit = "";
}
$query = "SELECT ".$select." FROM ".$from." WHERE ".$where." ";
if( $group_by != "" ) $query .= " GROUP BY ".$group_by;
if( $order_by != "" ) $query .= " ORDER BY ".$order_by;
if( $limit != "" ) $query .= " LIMIT ".$limit;
$db->query($query);
$nb = $db->nb_result();
?>
| | : | |
0)
{
echo"
";
}
?>
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']);
}
?>
!