* @author Loic Vinet */ require("class_functions.php"); require_once("class_db.php"); require_once("class_letterbox.php"); require_once("class_diffusion.php"); include("session.php"); if(file_exists($_SESSION['config']['lang'].'.php')) { include($_SESSION['config']['lang'].'.php'); } else { $_SESSION['error'] = "Language file missing...
"; } $lb = new letterbox(); //En mode collectif on reserve à nouveau le courrier pendant la durée de la redirection if(isset($_SESSION['current_basket']['locktime']) && $_SESSION['current_basket']['locktime'] > 0 ) { $lb->is_locked($_SESSION['courrier']['res_id'], $_SESSION['ressources'][0]['tablename'],$_SESSION['current_basket']['locktime']); } $db = new dbquery(); $db->connect(); $func = new functions(); $services = array(); $users = array(); $connexion = new dbquery(); $connexion->connect(); if(isset($_REQUEST['cancel'])) { $_SESSION['chosen_doc'] = array(); header("location: process_frame.php?id=".$_SESSION['courrier']['res_id']); exit(); } if(!empty($_SESSION['current_basket']['redirect_services']) && $_SESSION['current_basket']['can_redirect'] == 'Y') { $db->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)); } function cmp($a, $b) { return strcmp($a["LABEL"], $b["LABEL"]); } usort($services, "cmp"); } if(!empty($_SESSION['current_basket']['redirect_users']) && $_SESSION['current_basket']['can_redirect'] == 'Y') { $db2 = new dbquery(); $db2->connect(); $sql_users = "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 and ENABLED='Y'"; $order_by = "order by u.LASTNAME asc"; if($_SESSION['config']['show_only_elu_in_mailing_list'] == 'true') $sql_users .= " AND u.ELU = 'Y' "; $db->query($sql_users." ".$order_by); //$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++) { $_SESSION["diffusion"]->reload(); $_SESSION["diffusion"]->redirect_to_user("courrier"); $_SESSION["diffusion"]->store(); 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_SERVICE_REDIRECT); } $lb->release($_SESSION['chosen_doc'][$i],"res_x"); } $_SESSION['chosen_doc'] = array(); unset($_SESSION["diffusion"]); ?> redirect_to_service($_REQUEST['service']); $_SESSION["diffusion"]->store(); if($_SESSION['config']['enablechangenotif'] == "true") { //Load mail for the new dest_user $connexion->query("select MAIL, NOTIFICATION from ".$_SESSION['tablename']['users']." where USER_ID = '".$_SESSION["diffusion"]->get_dest_user()."'"); $res = $connexion->fetch_object(); $mail = $res->MAIL; $notif_exec = $res->NOTIFICATION; if($notif_exec & 1) { //Load ressource information $connexion->query("select TYPE_ID, DESCRIPTION, date(CREATION_DATE) as CREATION_DATE, date(CUSTOM_D2) as D2 from ".$_SESSION['ressources'][0]['tablename']." where RES_ID = '".$_SESSION['chosen_doc'][$i]."'"); $res = $connexion->fetch_object(); $b_type_id = $res->TYPE_ID; $b_description = $res->DESCRIPTION; $b_creation_date = $res->CREATION_DATE; $b_date_limite = $res->D2; $mail_trait = "
"._MAIL_TO_PROCESS."

"._HELLO.",

"._NEED_PROCESS_LETTER." :


"; mail($mail, _NEW_CASE_MAIL_OBJECT, $mail_trait , "From: ".$_SESSION['config']['adminmail']."\nReply-To: ".$_SESSION['config']['adminmail']." \nContent-Type: text/html; charset=\"iso-8859-1\"\n"); } } $connexion->query("UPDATE ".$_SESSION['ressources'][0]['tablename']." SET FLAG_NOTIF = 'N' WHERE RES_ID = '".$_SESSION['chosen_doc'][$i]."' "); 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']." "._WITH_DIFFUSION_LIST); } } } $_SESSION['chosen_doc'] = array(); $lb->release($_SESSION['chosen_doc'][$i],"res_x"); ?> "; } } if(isset($_REQUEST['valid3']) ) { if(isset($_REQUEST['user']) && !empty($_REQUEST['user'])) { for($i=0;$i < count($_SESSION['chosen_doc']);$i++) { if( isset($_REQUEST['mail_actions']) && !empty($_REQUEST['mail_actions']) ) $mail_actions = $_REQUEST['mail_actions']; else $mail_actions = null; $_SESSION["diffusion"]->reload(); $_SESSION["diffusion"]->redirect_to_user($_REQUEST['user'],$mail_actions); $_SESSION["diffusion"]->store(); if($_SESSION['config']['enablechangenotif'] == "true") { //Load mail for the new dest_user $connexion->query("select MAIL, NOTIFICATION from ".$_SESSION['tablename']['users']." where USER_ID = '".$_SESSION["diffusion"]->get_dest_user()."'"); $res = $connexion->fetch_object(); $mail = $res->MAIL; $notif_exec = $res->NOTIFICATION; if($notif_exec & 1) { //Load ressource information $connexion->query("select TYPE_ID, DESCRIPTION, date(CREATION_DATE) as CREATION_DATE, date(CUSTOM_D2) as D2 from ".$_SESSION['ressources'][0]['tablename']." where RES_ID = '".$_SESSION['chosen_doc'][$i]."'"); $res = $connexion->fetch_object(); $b_type_id = $res->TYPE_ID; $b_description = $res->DESCRIPTION; $b_creation_date = $res->CREATION_DATE; $b_date_limite = $res->D2; $mail_trait = "
"._MAIL_TO_PROCESS."

"._HELLO.",

"._NEED_PROCESS_LETTER." :


"; mail($mail, _NEW_CASE_MAIL_OBJECT, $mail_trait , "From: ".$_SESSION['config']['adminmail']."\nReply-To: ".$_SESSION['config']['adminmail']." \nContent-Type: text/html; charset=\"iso-8859-1\"\n"); } } 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']); } $lb->release($_SESSION['chosen_doc'][$i],"res_x"); } $_SESSION['chosen_doc'] = array(); ?> "; } } ?> <?php echo $_SESSION['config']['applicationname']; ?> 0) { echo "onLoad=\" setTimeout(function(){window.parent.top.close();},".($_SESSION['current_basket']['locktime'] * 60 * 1000).");\""; } ?>>







                

.