"details" )
{
echo "
"._CHOOSE_DEPARTMENT_FIRST.".
";
}
else
{ $conn = new dbquery();
$conn->connect();
if(!$_SESSION["popup_suite"])
{
$_SESSION['diff'] = array();
$fields = " USER_ID, SEQUENCE ";
if (($_SESSION['origin'] == 'validation' && $_SESSION['change_model'] == false) || $_SESSION['origin'] == "details" )
{
$table = $_SESSION['tablename']['listinstance'];
$where = " RES_ID =".$id." and RES_TABLE = 'res_x'";
$msg = _NO_LIST_DEFINED__FOR_THIS_MAIL.".";
}
else
{
$table = $_SESSION['tablename']['listmodel'];
$where = " ID='".$_SESSION['courrier']["service"]."' ";
$msg = _NO_LIST_DEFINED__FOR_THIS_DEPARTMENT.".";
if($_SESSION['change_model'] == true)
{
$_SESSION['change_model'] = false;
}
}
$conn->query("SELECT ".$fields." from ".$table." WHERE ".$where." ORDER BY SEQUENCE asc");
//$conn->show();
while($line = $conn->fetch_object())
{
$_SESSION['diff'][$line->SEQUENCE-1]['UserID'] = $line->USER_ID;
}
for ($i=0;$i
"")
{
$conn->query("SELECT u.FIRSTNAME, u.LASTNAME, u.DEPARTMENT, u.MAIL, s.SERVICE FROM ".$_SESSION['tablename']['users']." u, ".$_SESSION['tablename']['services']." s WHERE s.ID = u.DEPARTMENT and USER_ID='".$_SESSION['diff'][$i]['UserID']."'");
$line = $conn->fetch_object();
$_SESSION['diff'][$i]['FirstName'] = $line->FIRSTNAME;
$_SESSION['diff'][$i]['LastName'] = $line->LASTNAME;
$_SESSION['diff'][$i]['Service_id'] = $line->DEPARTMENT;
$_SESSION['diff'][$i]['Service'] = $line->SERVICE;
$_SESSION['diff'][$i]['Mail'] = $line->MAIL;
}
}
//$conn->show_array($_SESSION['diff']);
$_SESSION['liste_originale'] = array();
$_SESSION['liste_originale'] = $_SESSION['diff'];
}
if(count($_SESSION['diff']) < 1)
{
?>
show_array($_SESSION['diff']);?>
1)
{
?>
0)
{
?>