*/
session_name('LetterBox2');
session_start();
if(file_exists($_SESSION['config']['lang'].'.php'))
{
include($_SESSION['config']['lang'].'.php');
}
else
{
$_SESSION['error'] = "Language file missing...
";
}
require("class_functions.php");
require_once("class_db.php");
require_once("class_letterbox.php");
$db = new dbquery();
$db->connect();
$lb = new letterbox();
$services = array();
$users = array();
if(isset($_REQUEST['cancel']))
{
$_SESSION['chosen_doc'] = array();
?>
query("select * from ".$_SESSION['tablename']['services']." where ID in (".$_SESSION['current_basket']['redirect_services'].") and ENABLED = 'Y'");
while($res = $db->fetch_object())
{
array_push($services, array( 'ID' => $res->ID, 'LABEL' => $res->SERVICE));
}
}
if(!empty($_SESSION['current_basket']['redirect_users']) && $_SESSION['current_basket']['can_redirect'] == 'Y')
{
$db2 = new dbquery();
$db2->connect();
$db->query("select DISTINCT uc.USER_ID, u.LASTNAME from ".$_SESSION['tablename']['usergroup_content']." uc, ".$_SESSION['tablename']['users']." u where GROUP_ID in (".$_SESSION['current_basket']['redirect_users'].") and u.USER_ID = uc.USER_ID order by u.LASTNAME asc");
//$db->show();
while($res = $db->fetch_object())
{
$db2->query("select LASTNAME, FIRSTNAME from ".$_SESSION['tablename']['users']." where USER_ID = '".$res->USER_ID."' and USER_ID <> ''");
$res2 = $db2->fetch_object();
array_push($users, array( 'ID' => $res->USER_ID, 'NOM' => $res2->LASTNAME, "PRENOM" => $res2->FIRSTNAME, "SERVICE" => $res->DEPARTMENT));
}
}
if(isset($_REQUEST['valid1']))
{
for($i=0;$i < count($_SESSION['chosen_doc']);$i++)
{
$db->query("update ".$_SESSION['current_basket']['table']." set DEST_USER = 'courrier' where RES_ID = ".$_SESSION['chosen_doc'][$i]);
$db->query("update ".$_SESSION['tablename']['listinstance']." set USER_ID = '' where RES_TABLE = '".$_SESSION['current_basket']['table']."' and res_id = '".$_SESSION['chosen_doc'][$i]."' and SEQUENCE = 1 ");
if($_SESSION['history']['redirection'] == 'true')
{
require_once("class_history.php");
$hist = new history();
$hist->add($_SESSION['current_basket']['table'], $_SESSION['chosen_doc'][$i],"RED", "Redirection vers le service courrier");
}
}
$_SESSION['chosen_doc'] = array();
if($_REQUEST['process'] <> "true" || !isset($_REQUEST['process']))
{
?>
query("update ".$_SESSION['current_basket']['table']." set DESTINATION = '".$_REQUEST['service']."', DEST_USER='' where RES_ID = ".$_SESSION['chosen_doc'][$i]);
$db->query("select RES_ID, IDENTIFIER from ".$_SESSION['current_basket']['table']." where RES_ID = ".$_SESSION['chosen_doc'][$i]);
$res = $db->fetch_object();
// array_push($tmp, $res->RES_ID);
$db->query("update ".$_SESSION['tablename']['listinstance']." set USER_ID = '' where RES_TABLE = '".$_SESSION['current_basket']['table']."' and RES_ID = '".$_SESSION['chosen_doc'][$i]."' and SEQUENCE = 1 ");
if($_SESSION['history']['redirection'] == 'true')
{
require_once("class_history.php");
$hist = new history();
$hist->add($_SESSION['current_basket']['table'], $_SESSION['chosen_doc'][$i],"RED",_LETTER_N.$_SESSION['chosen_doc'][$i].' '._REDIRECTED_TO." ".$_REQUEST['service']);
}
}
$_SESSION['chosen_doc'] = array();
if($_REQUEST['process'] <> "true" || !isset($_REQUEST['process']))
{
?>
";
}
}
if(isset($_REQUEST['valid3']) )
{
if(isset($_REQUEST['user']) && !empty($_REQUEST['user']))
{
for($i=0;$i < count($_SESSION['chosen_doc']);$i++)
{
$db->query("update ".$_SESSION['current_basket']['table']." set DEST_USER = '".$_REQUEST['user']."' where RES_ID = ".$_SESSION['chosen_doc'][$i]);
$lb->manage_list($_SESSION['chosen_doc'][$i], $_REQUEST['user']);
if($_SESSION['history']['redirection'] == 'true')
{
require_once("class_history.php");
$hist = new history();
$hist->add($_SESSION['current_basket']['table'], $_SESSION['chosen_doc'][$i],"RED",_LETTER_N.$_SESSION['chosen_doc'][$i].' '._REDIRECTED_TO." ".$_REQUEST['user']);
}
}
$_SESSION['chosen_doc'] = array();
if($_REQUEST['process'] <> "true" || !isset($_REQUEST['process']))
{
?>
";
}
}
?>
<?php echo $_SESSION['config']['applicationname']; ?>
.