* @author Loïc Vinet */ 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"); $func = new functions(); $table = "res_x"; //****************** SIGNING **********************/ if( $_SESSION['config']['agent_in_signing_list'] == "true" || $_SESSION['config']['elu_in_signing_list'] == "true" ) { require_once("class_db.php"); $db = new dbquery(); $db->connect(); $request = "SELECT USER_ID, LASTNAME, SERVICE, ELU FROM ".$_SESSION['tablename']['users']." u, ".$_SESSION['tablename']['services']." s WHERE u.DEPARTMENT = s.ID AND ( 1=0 "; if( $_SESSION['config']['agent_in_signing_list'] == "true" ) $request .= "OR u.ELU = 'N'"; if( $_SESSION['config']['elu_in_signing_list'] == "true" ) $request .= " OR u.ELU = 'Y'"; $request .= ") AND STATUS <> 'DEL' AND u.ENABLED = 'Y' ORDER BY LASTNAME, FIRSTNAME "; $query = $db->query($request); $signing_choice = array(); while( $res = $db->fetch_object($query) ) { if( $res->ELU == 'Y' ) $signing_choice["ELU"][$res->USER_ID] = array( "LASTNAME"=> $res->LASTNAME,"FIRSTNAME" => $res->FIRSTNAME,"SERVICE" => $res->SERVICE); else $signing_choice["AGENT"][$res->USER_ID] = array( "LASTNAME"=> $res->LASTNAME,"FIRSTNAME" => $res->FIRSTNAME,"SERVICE" => $res->SERVICE); } unset($db); } /**************************************************/ $_SESSION['error'] = ""; if($_POST['choix']) { $_SESSION['upfile'] = array(); if(empty($_FILES['file']['tmp_name'])) { $_SESSION['error'] .= _FILE_MISSING.".
"; } else { $_SESSION['upfile']['tmp_name'] = $_FILES['file']['tmp_name']; } if($_FILES['file']['size'] == 0) { $_SESSION['error'] .= _FILE_EMPTY.".
"; } else { $_SESSION['upfile']['size'] = $_FILES['file']['size']; } if($_FILES['file']['error'] == 1) { $filesize = $func->return_bytes(ini_get("upload_max_filesize")); $_SESSION['error'] = _ERROR_FILE_UPLOAD_MAX."(".round($filesize/1024,2)."Ko Max).
"; } if(empty($_SESSION['error'])) { $_SESSION['upfile']['name'] = $_FILES['file']['name']; if(isset($_SESSION['upfile']) && !empty($_SESSION['upfile'])) { $extension = explode(".",$_SESSION['upfile']['name']); $count_level = count($extension)-1; $the_ext = $extension[$count_level]; require("load_extensions.php"); $ext_ok = false; for($i=0;$i."; } else { require_once("class_functions.php"); require_once("class_db.php"); require_once("class_docserver.php"); $conn = new dbquery(); $conn->connect(); $conn->query("SELECT DOCSERVER_ID, PATH_TEMPLATE, SIZE_LIMIT, ACTUAL_SIZE FROM ".$_SESSION['tablename']['docservers']." WHERE IS_READONLY = 'N' AND ENABLED = 'Y' "); if($conn->nb_result() == 0) { $_SESSION['error'] .= _NO_AVAILABLE_DOCSERVER."."._MORE_INFOS." : ".$_SESSION['config']['adminname'].".
"; } else { $info = $conn->fetch_object(); $docserver_id = $info->DOCSERVER_ID; $docserver_size = $info->ACTUAL_SIZE + $_SESSION['upfile']['size']; $path_template = trim($info->PATH_TEMPLATE); if($info->SIZE_LIMIT > 0 && $docserver_size >= $info->SIZE_LIMIT) { $_SESSION['error'] .= _NOT_ENOUGH_DISK_SPACE."."._MORE_INFOS." : ".$_SESSION['config']['adminname'].".
"; } else { if(!is_uploaded_file($_FILES['file']['tmp_name'])) { $_SESSION['error'] .= _FILE_NOT_SEND.". "._TRY_AGAIN."."._MORE_INFOS." : ".$_SESSION['config']['adminname'].".
"; } else { $path_template = $info->PATH_TEMPLATE; $docserver = new docserver(); // On effectue l'ajout de document pour chaque res_id prit en compte dans la liste de choix for($i=0;$iquery("SELECT CUSTOM_T16, CUSTOM_T17, CUSTOM_T2, CUSTOM_T3, CUSTOM_T4, DESTINATION, DEST_USER, RES_ID, IDENTIFIER, date (CUSTOM_D1) as D1, date (CUSTOM_D2) as D2, date (CREATION_DATE) as D3,AUTHOR, TYPE_ID, DESCRIPTION, date(DOC_DATE) as DC, CUSTOM_T5, CUSTOM_T6, CUSTOM_T7, CUSTOM_T8, CUSTOM_T15, CUSTOM_T1, CUSTOM_T9, CUSTOM_T10, CUSTOM_T11, CUSTOM_T12, CUSTOM_T13, CUSTOM_T14, date(CREATION_DATE) as CD, PRIORITY, SOCIETE, GID_ID, COLL_ID, STATUS, date(CUSTOM_D6) as D6, CUSTOM_T18, CUSTOM_T19, CUSTOM_T20, CUSTOM_T21, COVERAGE, MAIL_ACTION FROM ".$table." WHERE RES_ID=".$original_s_id); $line = $conn->fetch_object(); $_SESSION['mass_courrier']['identifier'] = $line->IDENTIFIER; $_SESSION['mass_courrier']['author'] = stripslashes($line->AUTHOR); $_SESSION['mass_courrier']['type_id'] = $line->TYPE_ID; $_SESSION['mass_courrier']['description'] = stripslashes($line->DESCRIPTION); $_SESSION['mass_courrier']['identifier'] = $line->IDENTIFIER; $_SESSION['mass_courrier']['date_arrivee'] = $conn->inverse_date($line->D1); $_SESSION['mass_courrier']['date_creation'] = $conn->inverse_date($line->D3); $_SESSION['mass_courrier']["date_limite"] = $conn->inverse_date($line->D2); $_SESSION['mass_courrier']["doc_date"] = $conn->inverse_date($line->DC); $_SESSION['mass_courrier']['rep_courrier_simple'] = $line->CUSTOM_T5; $_SESSION['mass_courrier']['rep_AR'] = $line->CUSTOM_T15; $_SESSION['mass_courrier']['rep_direct'] = $line->CUSTOM_T6; $_SESSION['mass_courrier']['rep_mail'] = $line->CUSTOM_T7; $_SESSION['mass_courrier']['rep_autre'] = $line->CUSTOM_T8; $_SESSION['mass_courrier']['rep_fax'] = $line->CUSTOM_T16; $_SESSION['mass_courrier']['no_rep'] = $line->CUSTOM_T17; $_SESSION['mass_courrier']['notes'] = stripslashes($line->CUSTOM_T1); $_SESSION['mass_courrier']['qualite'] = stripslashes($line->CUSTOM_T9); $_SESSION['mass_courrier']['num_rue'] = stripslashes($line->CUSTOM_T10); $_SESSION['mass_courrier']['rue'] = stripslashes($line->CUSTOM_T11); $_SESSION['mass_courrier']['ville'] = stripslashes($line->CUSTOM_T12); $_SESSION['mass_courrier']['code'] = $line->CUSTOM_T13; $_SESSION['mass_courrier']['quartier'] = stripslashes($line->CUSTOM_T14); $_SESSION['mass_courrier']['nature'] = stripslashes($line->CUSTOM_T2); $_SESSION['mass_courrier']['civ'] = stripslashes($line->CUSTOM_T3); $_SESSION['mass_courrier']['prenom'] = stripslashes($line->CUSTOM_T4); $_SESSION['mass_courrier']['service'] = $line->DESTINATION; $_SESSION['mass_courrier']['dest'] = $line->DEST_USER; $_SESSION['mass_courrier']['prio'] = $line->PRIORITY; $_SESSION['mass_courrier']['mail_action'] = $line->MAIL_ACTION; $_SESSION['mass_courrier']['theme'] = $line->COVERAGE; $_SESSION['mass_courrier']['societe'] = stripslashes($line->SOCIETE); $_SESSION['mass_courrier']['arrondissement'] = html_entity_decode($line->CUSTOM_T18); $_SESSION['mass_courrier']['canton'] = html_entity_decode($line->CUSTOM_T19); $_SESSION['mass_courrier']['epci'] = html_entity_decode($line->CUSTOM_T20); $_SESSION['mass_courrier']['epci_type'] = html_entity_decode($line->CUSTOM_T21); $result = $docserver->store($docserver_id,$path_template,$_FILES['file']['tmp_name'],$the_ext,$_SESSION['upfile']['size']); if( !is_array($result) || count($result) < 2 ) { echo $docserver->get_last_error()." ".$_SESSION['config']['adminname'].".
"; exit; } else { $signing = 'NULL'; if( isset($_POST['signing']) && $_POST['signing'] != "0" ) $signing = "'".$_POST['signing']."'"; $new_doc_date = explode("-", $_SESSION['mass_courrier']['doc_date']); $modified_doc_date = $new_doc_date[2].$new_doc_date[1].$new_doc_date[0]; $new_custom_d1 = explode("-", $_SESSION['mass_courrier']['date_arrivee']); $modified_custom_d1 = $new_custom_d1[2].$new_custom_d1[1].$new_custom_d1[0]; $new_custom_d2 = explode("-", $_SESSION['mass_courrier']['date_limite']); $modified_custom_d2 = $new_custom_d2[2].$new_custom_d2[1].$new_custom_d2[0]; $md5 = md5($result["destination_rept"].$result["file_destination_name"].".".$the_ext); $destination_rept = substr($result["destination_rept"],strlen($path_template),4); $destination_rept = str_replace(DIRECTORY_SEPARATOR,'#',$destination_rept); $file_destination_name = $result["file_destination_name"]; $_SESSION['mass_courrier']['description'] = addslashes($_SESSION['mass_courrier']['description']); $conn->query("INSERT INTO ".$table." ( TITLE, RELATION, DESCRIPTION, FORMAT, CREATION_DATE, DOC_DATE, DOCSERVER_ID, PATH, FILENAME, FILESIZE, STATUS, TYPIST, TYPE_ID, CUSTOM_T3, CUSTOM_T4, AUTHOR, CUSTOM_D1, CUSTOM_D2, DESTINATION, DEST_USER, SOURCE, GID_ID, SIGNING ) VALUES ('".addslashes($_SESSION['upfile']['name'])."', '".$original_s_id."', '".addslashes($_SESSION['mass_courrier']['description'])."', '".strtoupper($the_ext)."', now() , '".$modified_doc_date."','".$docserver_id."','" .$destination_rept."','".$file_destination_name.".".strtolower($the_ext) ."',".$_SESSION['upfile']['size'] .",'REP','".$_SESSION['user']['UserId'] ."','".$_SESSION['mass_courrier']['type_id']."','".addslashes($_SESSION['mass_courrier']['civ'])."', '".addslashes($_SESSION['mass_courrier']['prenom'])."', '".addslashes($_SESSION['mass_courrier']['author'])."', '".$modified_custom_d1."', '".$modified_custom_d2."' , '".addslashes($_SESSION['mass_courrier']['service'])."', '".$_SESSION['mass_courrier']['dest']."', 'Local File', 'R".date('Y').$original_s_id."', ".$signing." )"); $conn->query("select res_id from ".$table." where DOCSERVER_ID = '".$docserver_id."' and PATH = '".$destination_rept."' and FILENAME = '".$file_destination_name.".".strtolower($the_ext)."'" ); $res = $conn->fetch_object(); $id_rep = $res->res_id; $conn->query("update ".$table." set fingerprint = '".$md5."' where res_id = ".$id_rep); if($_SESSION['history']['resadd'] == "true") { require_once("class_history.php"); $users = new history(); $users->add($table, $_SESSION['mass_courrier']['res_id'],"ADD", _NEW_ANSWER_ADDED." : ".$_SESSION['mass_courrier']['identifier']." (".$_SESSION['mass_courrier']['type_id'].")"); } } // ------ } } } } ?> <?php echo _ATTACH_ANSWER;?>

:





0 ) { ?>