*/ include("session.php"); if(file_exists($_SESSION['config']['lang'].'.php')){ include($_SESSION['config']['lang'].'.php'); } else{ $_SESSION['error'] = "Language file missing...
"; } require_once("class_functions.php"); require_once("class_db.php"); require_once("class_security.php"); require_once("test_page.php"); //PREREMPLIR LES CHAMPS AVEC LE FICHIER LETTERBOX.XML if( empty($_SESSION['send_doc']['to']) && !empty($_SESSION['mail']['TO']) ) $_SESSION['send_doc']['to'] = $_SESSION['mail']['TO']; if( empty($_SESSION['send_doc']['cc']) && !empty($_SESSION['mail']['CC']) ) $_SESSION['send_doc']['cc'] = $_SESSION['mail']['CC']; if( empty($_SESSION['send_doc']['cci']) && !empty($_SESSION['mail']['CCI']) ) $_SESSION['send_doc']['cci'] = $_SESSION['mail']['CCI']; if( empty($_SESSION['send_doc']['subject']) && !empty($_SESSION['mail']['SUBJECT']) ) $_SESSION['send_doc']['subject'] = $_SESSION['mail']['SUBJECT']; $func = new functions(); $time = $func->get_session_time_expire(); //$sec = new security(); $s_id = $s_folder_id = ''; $_SESSION['send_doc']['is_folder'] = ''; $titrePage = ''; $redirect = ''; if(!isset($_SESSION['send_doc']['mailType']) || empty($_SESSION['send_doc']['mailType'])){ $_SESSION['send_doc']['mailType'] = 'spl'; } $connexion = new dbquery(); $connexion->connect(); $table =""; if(isset($_SESSION['tablechoice']) && !empty($_SESSION['tablechoice'])){ $table = $_SESSION['tablechoice']; } else{ $table = $_SESSION['ressources'][0]['tablename']; } if(isset($_GET['clean']) && !empty($_GET['clean'])){ //Clean Up $_SESSION['send_doc'] = array(); $_SESSION['send_doc']['to'] = ''; $_SESSION['send_doc']['cc'] = ''; $_SESSION['send_doc']['cci'] = ''; $_SESSION['send_doc']['subject'] = ''; $_SESSION['send_doc']['destination'] = ''; $_SESSION['send_doc']['message'] = ''; $_SESSION['send_doc']['files'] = ''; $_SESSION['send_doc']['docJoin'] = array(); $_SESSION['send_doc']['noteJoin'] = array(); $_SESSION['send_doc']['is_folder'] = ''; //$_SESSION['send_doc']['mailType'] = ''; $_SESSION['send_doc']['docServer'] = ''; $_SESSION['send_doc']['messagePath'] = ''; $_SESSION['send_doc']['messageFileSize'] = ''; $_SESSION['send_doc']['resId'] = ''; $_SESSION['send_doc']['messageFile'] = ''; $_SESSION['send_doc']['messageFileName'] = ''; } $btName = _SEND; if(isset($_GET['task']) && !empty($_GET['task'])){ //Modification d'un mail if(isset($_GET['id']) && !empty($_GET['id'])){ $conn = new dbquery(); $conn->connect(); $conn->query("select RES_ID, `TYPE_ID`, `CREATION_DATE`, `DESTINATION`, `DESCRIPTION`, `AUTHOR`, `RELATION`, `CUSTOM_T1`, `CUSTOM_T2`, `CUSTOM_T3`,`CUSTOM_T4`,`CUSTOM_T5`, `STATUS`, `IS_FOLDER`, `CUSTOM_T6`, `DOCSERVER_ID`, `PATH`, `FILENAME`, `FORMAT`, `FILESIZE` from ".$table." where RES_ID = '".$_GET['id']."' and STATUS = 'MEL' "); $mail = $conn->fetch_object(); $_SESSION['send_doc']['resId'] = $_GET['id']; $_SESSION['send_doc']['to'] = $mail->CUSTOM_T1; $_SESSION['send_doc']['cc'] = $mail->CUSTOM_T2; $_SESSION['send_doc']['cci'] = $mail->CUSTOM_T2; $_SESSION['send_doc']['subject'] = $func->show($mail->DESCRIPTION); $_SESSION['send_doc']['docJoin'] = explode(",", $mail->CUSTOM_T4); $_SESSION['send_doc']['destination'] = $mail->DESTINATION; $_SESSION['send_doc']['is_folder'] = $mail->IS_FOLDER; $_SESSION['send_doc']['noteJoin'] = explode(",", $mail->CUSTOM_T5); $_SESSION['send_doc']['mailType'] = $mail->CUSTOM_T6; $docserver = $mail->DOCSERVER_ID; $_SESSION['send_doc']['docServer'] = $mail->DOCSERVER_ID; $_SESSION['send_doc']['messagePath'] = $mail->PATH; $_SESSION['send_doc']['messageFileName'] = $mail->FILENAME; //$format = $mail->FORMAT; $_SESSION['send_doc']['messageFileSize'] = $line->FILESIZE; if($mail->IS_FOLDER == 'Y'){ $s_folder_id = $mail->RELATION; } else{ $s_id = $mail->RELATION; } $conn->query("select PATH_TEMPLATE from ".$_SESSION['tablename']['docservers']." where DOCSERVER_ID = '".$docserver."'"); $line_doc = $conn->fetch_object(); $docserver = $line_doc->PATH_TEMPLATE; if ($_SESSION['send_doc']['docServer'] == 'aidocserver'){ $file = $docserver.$_SESSION['send_doc']['messagePath'].strtoupper($_SESSION['send_doc']['messageFileName']); } else{ $file = $docserver.$_SESSION['send_doc']['messagePath'].strtolower($_SESSION['send_doc']['messageFileName']); } $file = str_replace("#", DIRECTORY_SEPARATOR, $file); $_SESSION['send_doc']['messageFile'] = $file; if(file_exists($file)){ $myfile = fopen($file, "r"); $data = fread($myfile, filesize($file)); fclose($myfile); $_SESSION['send_doc']['message'] = stripslashes($data); } else{ $_SESSION['error'] = _NO_DOC_OR_NO_RIGHTS."..."; ?>wash($_GET['id'], "num", _THE_DOC); $theID = $s_id; } elseif(isset($_GET['folder_id']) && !empty($_GET['folder_id'])){ $s_folder_id = $func->wash($_GET['folder_id'], "num", _THE_DOC); $theID = $s_folder_id; } $btName = _SEND; //RECUPERATION DE "DESTINATION" $conn = new dbquery(); $conn->connect(); $conn->query("select DESTINATION from ".$table." where RES_ID = '".$theID."' and STATUS <> 'DEL' "); $mail = $conn->fetch_object(); $_SESSION['send_doc']['destination'] = $mail->DESTINATION; } if(isset($s_id) && !empty($s_id)) { // envoie d'un document $_SESSION['send_doc']['is_folder'] = 'N'; $theID = $s_id; $redirect = 'id='.$theID; $titrePage = _DOC_N.' '.$theID; $connexion->query("select RES_ID, TITLE, FORMAT, FILESIZE, FILENAME, DESCRIPTION, SUBJECT from ".$table." where RES_ID = '".$theID."' and STATUS <> 'DEL' and STATUS <> 'REP' "); if($connexion->nb_result() < 1){ $_SESSION['error'] = _DOC_NOT_FOUND; ?> nb_result() > 1){ $_SESSION['error'] = _DOUBLED_DOC; ?> query("SELECT RES_ID, TITLE, FORMAT, FILESIZE, FILENAME, DESCRIPTION, SUBJECT FROM ".$table." WHERE (IS_FOLDER = 'Y' and RES_ID = ".$theID." ) OR ( IS_FOLDER = 'N' AND FOLDER_ID = ".$theID.") OR ( IS_FOLDER = 'N' AND RELATION = ".$theID.") AND STATUS <> 'DEL' order by CREATION_DATE"); if($connexion->nb_result() < 1){ $_SESSION['error'] = _DOC_NOT_FOUND; ?> <?php echo _SEND_BY_MAIL2." : ".$titrePage;?>
connect(); $db->query("select i.ID, i.USER_ID, i.DATE, u.FIRSTNAME, u.LASTNAME from ".$_SESSION['tablename']['notes']." i inner join ".$_SESSION['tablename']['users']." u on i.USER_ID = u.USER_ID WHERE i.RECORD_ID = ".$theID." AND ((i.ACCESS_SERVICES = 'all' AND i.ACCESS_USERS = 'all') OR (i.ACCESS_USERS = 'not' AND i.ACCESS_SERVICES LIKE '%".$_SESSION['user']['department']."%') OR (i.ACCESS_SERVICES = 'not' AND i.ACCESS_USERS LIKE '%".$_SESSION['user']['UserId']."%')) ORDER BY DATE desc"); if($db->nb_result() > 0) { ?>

*
*
*
:
fetch_object()) { ?> RES_ID, $_SESSION['send_doc']['docJoin'])){ echo 'checked="checked"'; } ?> value="RES_ID; ?>" /> TITLE != null && !empty($doc->TITLE) ) { echo stripslashes($doc->TITLE); } else if( $doc->DESCRIPTION != null && !empty($doc->DESCRIPTION) ) { echo stripslashes($doc->DESCRIPTION).",".stripslashes($doc->FILENAME); } else { echo stripslashes($doc->FILENAME); } $filSizeKO = $doc->FILESIZE/1024; if($filSizeKO > 1) { echo ' ('.(ceil($filSizeKO)).'Ko)'; } else { echo ' ('.($doc->FILESIZE).'Octet)'; } ?>
:
:
fetch_object()) { ?> ID, $_SESSION['send_doc']['noteJoin'])){ echo 'checked="checked"'; } ?> value="ID; ?>" /> format_date($note->DATE) .' '. _FROM .' '. $note->FIRSTNAME .' '. $note->LASTNAME;?>