* @author Loic Vinet */ require("test_page.php"); require_once("class_functions.php"); require_once("class_db.php"); require_once("class_security.php"); require_once("class_letterbox.php"); $func = new functions(); $connexion = new dbquery(); $sec = new security(); $connexion->connect(); if(($_SESSION['origin'] == "file" || $_SESSION['origin'] == "scan") && isset($_SESSION['indexation_id']) && !empty($_SESSION['indexation_id'])) { $s_id = $_SESSION['indexation_id']; $_SESSION['indexation_id'] = ""; } else { $s_id = addslashes($func->wash($_GET['id'], "num", _THE_DOC)); } $table =""; if(isset($_SESSION['tablechoice']) && !empty($_SESSION['tablechoice'])) { $table = $_SESSION['tablechoice']; } else { $table = $_SESSION['ressources'][0]['tablename']; } if($_SESSION['origin'] <> "basket" ) { $right = $sec->test_right_doc($table, $s_id); } else { $right = true; } if(!$right) { ?> load_from_db("res_x",$s_id); } $_SESSION['origin'] = "details"; $_SESSION["popup_suite"] = false; if(isset($_POST['action_value']) && $_POST['action_value'] == _DELETE_DOC) { if($_SESSION['user']['delete_rights'] == true) { $connexion->query("UPDATE ".$table." SET STATUS = 'DEL' WHERE RES_ID = ".$s_id); if($_SESSION['history']['resdel'] == "true") { require_once("class_history.php"); $hist = new history(); $hist->add('res_x', $s_id, "DEL", _DOC_DELETED.$s_id); } ?> show_array($_POST); //$connexion->show_array($_SESSION['courrier']); //exit(); $connexion->query("select IDENTIFIER, CREATION_DATE, CUSTOM_T3, AUTHOR, CUSTOM_T4, CUSTOM_D2 from ".$table." where RES_ID = ".$s_id); $res = $connexion->fetch_object(); $ref = $res->IDENTIFIER; $date_crea = $res->CREATION_DATE; $emetteur = stripslashes($res->CUSTOM_T3)." ".stripslashes($res->AUTHOR)." ".stripslashes($res->CUSTOM_T4); $date_lim = $res->CUSTOM_D2; $query = ""; if($_SESSION['config']['gdi_index'] == "true") { if($_POST['gid_id'] <> '') { $query .= " GID_ID = '".$_POST['gid_id']."' ,"; } else { $_SESSION['error'] .= _GID_ID_MISSING.".
"; } } if($_SESSION['config']['corporate'] == "true") { if(isset($_POST['societe']) ) { $query .= " SOCIETE= '".$_POST['societe']."' ,"; } else { $_SESSION['error'] .= _SOCIETY_FORGOTTEN."
"; } } if(isset($_POST['service']) && !empty($_POST['service'])) { $query .= " DESTINATION = '".$_POST['service']."' ,"; } elseif(isset($_SESSION['courrier']['service']) && !empty($_SESSION['courrier']['service'])) { $query .= " DESTINATION = '".$_SESSION['courrier']['service']."' ,"; } else { $_SESSION['error'] .= _DEPARTMENT_FORGOTTEN."
"; } if(isset($_POST['type_list']) && !empty($_POST['type_list'])) { $query .= " TYPE_ID = '".$_POST['type_list']."' ,"; } else { $_SESSION['error'] .= _TYPE_FORGOTTEN."
"; } if(isset($_POST['nature']) && !empty($_POST['nature'])) { $query .= " CUSTOM_T2 = '".$_POST['nature']."' ,"; } else { $_SESSION['error'] .= _INVOICE_TYPE_FORGOTTEN."
"; } if(isset($_POST['objet']) && !empty($_POST['objet'])) { $query .= " DESCRIPTION = '".$_POST['objet']."' ,"; } if( isset($_POST['priority']) ) { $query .= " PRIORITY = '".$_POST['priority']."' ,"; } if(isset($_POST['date_doc_date']) && !empty($_POST['date_doc_date'])) { $tmp = $func->inverse_date($_POST['date_doc_date']); $tmp = str_replace(' ', '', $tmp); if( preg_match("/[0-3][0-9]-[0-1][0-9]-[1-2][0-9][0-9][0-9]/",$_POST['date_doc_date'])==false ) { $_SESSION['error'] .= _WRONG_DATE_FORMAT.' : '.$_POST['date_doc_date']; } else { $query .= " DOC_DATE = '".$tmp."' , "; } } if(isset($_POST['date_shipping_date']) && !empty($_POST['date_shipping_date'])) { $tmp = $func->inverse_date($_POST['date_shipping_date']); $tmp = str_replace(' ', '', $tmp); if( preg_match("/[0-3][0-9]-[0-1][0-9]-[1-2][0-9][0-9][0-9]/",$_POST['date_shipping_date'])==false ) { $_SESSION['error'] .= _WRONG_DATE_FORMAT.' : '.$_POST['date_shipping_date']; } else { if ($_POST['hidden_out']) { $query .= " CREATION_DATE = '".$tmp."' , "; } else { $query .= " CUSTOM_D1 = '".$tmp."' , "; } } } if(isset($_POST['date_limit_date']) && !empty($_POST['date_limit_date'])) { $tmp = $func->inverse_date($_POST['date_limit_date']); $tmp = str_replace(' ', '', $tmp); if( preg_match("/[0-3][0-9]-[0-1][0-9]-[1-2][0-9][0-9][0-9]/",$_POST['date_limit_date'])==false ) { $_SESSION['error'] .= _WRONG_DATE_FORMAT.' : '.$_POST['date_limit_date']; } else { $query .= " CUSTOM_D2 = '".$tmp."' , "; // With this update, we need to change date in CUSTOM_D4 and CUSTOM_D5 by types // First, we need restore value of this doctypes, no need to doctypes?? $update_db_types = new dbquery(); $update_db_types -> connect(); $update_db_types -> query("SELECT DATEDIFF('".$tmp."',CUSTOM_D2) as HOW_LONG from ".$_SESSION['ressources'][0]['tablename']." WHERE RES_ID = '".$s_id."'; "); //$update_db_types -> show(); $result_interval = $update_db_types->fetch_object(); if ($result_interval->HOW_LONG <> '') { $pos = strpos($result_interval->HOW_LONG, "-"); if ($pos === false) { $negative = false; } else { $negative = true; } if ($negative == true) { $my_interval_value = str_replace('-', '',$result_interval->HOW_LONG); $query .= "CUSTOM_D4 = (CUSTOM_D4 - INTERVAL ".$my_interval_value." DAY) , "; $query .= "CUSTOM_D5 = (CUSTOM_D5 - INTERVAL ".$my_interval_value." DAY) , "; } else { $my_interval_value = $result_interval->HOW_LONG; $query .= "CUSTOM_D4 = (CUSTOM_D4 + INTERVAL ".$my_interval_value." DAY) , "; $query .= "CUSTOM_D5 = (CUSTOM_D5 + INTERVAL ".$my_interval_value." DAY) , "; } } } } if( isset($_POST['domain']) ) { $query .= " COVERAGE = '".$_POST['domain']."' ,"; } if(empty($_SESSION['error'])) { if( $_SESSION["diffusion"]->get_dest_user ) $query .= "DEST_USER = '".$_SESSION["diffusion"]->get_dest_user."', "; else $query .= "DEST_USER = NULL, "; //******** MAILER ***********// } if( isset($_SESSION['emet_exp']) && count($_SESSION['emet_exp']) > 0 ) { if(( ! isset($_SESSION['emet_exp']['LASTNAME']) || empty($_SESSION['emet_exp']['LASTNAME'])) && !$_SESSION['emet_exp']['society_tag']) { $_SESSION['error'] .= _SHIPPER_FORGOTTEN."
"; } elseif( ( ! isset($_SESSION['emet_exp']['SOCIETY']) || empty($_SESSION['emet_exp']['SOCIETY']) ) && $_SESSION['emet_exp']['society_tag']=='society') { $_SESSION['error'] .= _SOCIETY_FORGOTTEN."
"; } else { $query .= " AUTHOR = '".addslashes($_SESSION['emet_exp']['LASTNAME'])."' , CUSTOM_T3 = '".addslashes($_SESSION['emet_exp']['CIVILITY'])."' , CUSTOM_T4 = '".addslashes($_SESSION['emet_exp']['FIRSTNAME'])."' , CUSTOM_T9 = '".addslashes($_SESSION['emet_exp']['FUNCTION'])."' , CUSTOM_T10 = '".addslashes($_SESSION['emet_exp']['STREET_NUM'])."' , CUSTOM_T11 = '".addslashes($_SESSION['emet_exp']['STREET'])."' , CUSTOM_T12 = '".addslashes($_SESSION['emet_exp']['TOWN'])."' , CUSTOM_T13 = '".addslashes($_SESSION['emet_exp']['CP'])."' , SOCIETE = '".addslashes($_SESSION['emet_exp']['SOCIETY'])."' ,"; } } if(empty($_SESSION['error'])) { $query = trim($query); $query = preg_replace("/,$/", "", $query); if($_SESSION['history']['resup'] ) { require_once("class_history.php"); $hist = new history(); $hist->add($table, $s_id, "UP",_MODIF_MAIL_INDEX.$s_id); } $connexion->query("UPDATE ".$table." set ".$query." where RES_ID = ".$s_id); $connexion->query("update ".$table." set destination = '".$_POST['service']."' where is_folder = 'N' and folder_id = '".$s_id."'"); $_SESSION["diffusion"]->store(); //RAZ DIFFUSION if( isset($_SESSION["diffusion"]) ) { unset($_SESSION["diffusion"]); } //NEW INSTANCE DIFFUSION $_SESSION["diffusion"] = new diffusion($connexion,$_SESSION['user']['UserId'],$_SESSION['user']['delete_copy_rights'],$_SESSION['config']['modifycopylist'], $_SESSION['config']['redirect_list'],$_SESSION['config']['tag100_for_copy']); $_SESSION["diffusion"]->load_from_db("res_x",$s_id); $connexion->query("UPDATE ".$table." SET FLAG_NOTIF = 'N' WHERE RES_ID = '".$s_id."' AND (STATUS ='COU' OR STATUS = 'NEW') "); //Debug : on force l association de DESTINATION $_SESSION["diffusion"]->update_service($_POST['service']); } } $_SESSION['detail_id'] =$s_id; if(empty($_SESSION['error']) || $_SESSION['indexation']) { $connexion->query("SELECT TITLE, DESCRIPTION, TYPE_ID, FORMAT, TYPIST, date(CREATION_DATE) as CREATION_DATE, DOC_DATE, FINGERPRINT, IDENTIFIER, CUSTOM_T1 as DEPARTMENT, AUTHOR, FILESIZE, STATUS, CUSTOM_D1, date(CUSTOM_D2) as CUSTOM_D2, VALIDATION_DATE, AUTHOR, AUTHOR_NAME, DEST_USER, DESTINATION, CUSTOM_T2, CUSTOM_T4, CUSTOM_T5, CUSTOM_T6, CUSTOM_T7, CUSTOM_T8, CUSTOM_D3, CUSTOM_T1, CUSTOM_T15, CUSTOM_T16, CUSTOM_T17, IS_INGOING, PRIORITY, SOCIETE, GID_ID, COLL_ID, COVERAGE FROM ".$table." where RES_ID = ".$s_id); } ?>

< ( "._SHOW_MAIL_FOLDER." "; ?>)








nb_result() == 0) { ?>



.


test_reserved_time($s_id, $table); if( $by_user_id == $_SESSION['user']['UserId'] || $by_user_id == null) $locked = false; $details = $connexion->fetch_object(); $title = stripslashes($details->TITLE); $description = stripslashes($details->DESCRIPTION); $format = $details->FORMAT; $filesize = $details->FILESIZE; $creation_date = $details->CREATION_DATE; $doc_date = $details->DOC_DATE; $fingerprint = $details->FINGERPRINT; $ref = $details->IDENTIFIER; $_SESSION['courrier']['reference'] = $ref; $tmp = ""; $type = $details->TYPE_ID; $_SESSION['courrier']['type_courrier'] = $type; $status= $details-> STATUS; $datearrivee= $details -> CUSTOM_D1; $validation_date= $details -> VALIDATION_DATE; $datelimitetraitement=$details -> CUSTOM_D2; $author = stripslashes($details->AUTHOR); $author_firstname = stripslashes($details->CUSTOM_T4); $author_name = $details->AUTHOR_NAME; $dest_user = $details->DEST_USER; $destination = $details->DESTINATION; $coll = $details->COLL_ID; $_SESSION['courrier']['service'] = $destination; $nature_envoi = $details -> CUSTOM_T2; $courrier = $details -> CUSTOM_T5; $direct = $details -> CUSTOM_T6; $mail = $details -> CUSTOM_T7; $courrierAR = $details -> CUSTOM_T15; $fax = $details -> CUSTOM_T16; $norep = $details -> CUSTOM_T17; $autre = $details -> CUSTOM_T8; $date_traitement = $details->CUSTOM_D3; $notes = $details->CUSTOM_T1; $typist = $details->TYPIST; $is_ingoing = $details->IS_INGOING; $priority = $details->PRIORITY; $societe = $details->SOCIETE; $gid_id = $details->GID_ID; $the_domain = $details->COVERAGE; $out = false; if($is_ingoing == 'N' || $status == 'OUT') { $out = true; $connexion->query('select LASTNAME, FIRSTNAME from '.$_SESSION['tablename']['users'].' where USER_ID = "'.$author.'"'); if ($connexion->nb_result()>0) { $res = $connexion->fetch_object(); $author = $res->FIRSTNAME.' '.$res->LASTNAME; } } $connexion->query("select LASTNAME, FIRSTNAME, STATUS, ENABLED from ".$_SESSION['tablename']['users']." where USER_ID = '".$typist."'"); $res = $connexion->fetch_object(); if($typist <> "AUTOIMPORT") { $typist = $res->FIRSTNAME.' '.$res->LASTNAME; } if($res->STATUS == 'OK') { if($res->ENABLED == 'N') { $typist .= ' ('._NOT_ENABLED.')'; } } else { if($typist <> "AUTOIMPORT") { $typist .= ' ('._DELETED.')'; } } $connexion->query("select date(CREATION_DATE) as CREATION_DATE, RES_ID, TITLE FROM res_x WHERE STATUS='REP' AND RELATION=".$s_id." order by CREATION_DATE desc"); $rep = array(); while($line = $connexion->fetch_object()) { array_push($rep, array("ID" => $line->RES_ID, "DATE" => $connexion->inverse_date($line->CREATION_DATE), 'TITLE' => $line->TITLE)); } if($_SESSION['user']['modif_rights'] && ($status != "END" && $status != "DEL" && $status != "MEP" && $status != "RJD") ) { //SERVICE LIST : PREPARE REQUEST $services_req = "SELECT ID, SERVICE FROM ".$_SESSION['tablename']['services']." WHERE ENABLED = 'Y' AND ( ID = '".$destination."' "; if( $_SESSION['config']['restricted_diffusion_access'] === "true" ) { $services_req .= " OR ID IN ("; for( $t=0; $tquery($services_req); $modif_services = array(); while($res = $connexion->fetch_object()) { array_push($modif_services, array('ID' => $res->ID, 'LABEL' => $res->SERVICE)); } //TYPE LIST $connexion->query("select TYPE_ID, DESCRIPTION from ".$_SESSION['tablename']['doctypes']." where ENABLED = 'Y' order by description"); $types_list = array(); while($res = $connexion->fetch_object()) { array_push($types_list, array('ID' => $res->TYPE_ID, 'LABEL' => $res->DESCRIPTION)); } } else { //SERVICE $service = ""; $connexion->query("select SERVICE FROM ".$_SESSION['tablename']['services']." WHERE ID ='".$destination."'"); $res = $connexion->fetch_object(); $service = $res->SERVICE; //DEST USER $dest = ""; $connexion->query("select FIRSTNAME, LASTNAME from ".$_SESSION['tablename']['users']." where USER_ID = '".$dest_user."'"); $res = $connexion->fetch_object(); $dest = $res->FIRSTNAME." ".$res->LASTNAME; } if(!empty($type)) { $connexion->query("select DESCRIPTION, RES_TABLE from ".$_SESSION['tablename']['doctypes']." where TYPE_ID = '".$type."'"); $line_sql = $connexion->fetch_object(); $type = $line_sql->DESCRIPTION; $tmp = $line_sql->RES_TABLE; for($i=0; $i < count($_SESSION['ressources']); $i++) { if($_SESSION['ressources'][$i]['tablename'] == $tmp) { $table = $_SESSION['ressources'][$i]['comment']; break; } } } ?>

:

 

'._GID_ID.' : '; echo ''; } else { echo ''; echo '
:   :
:   : " />
<?php echo addslashes(_CALENDAR); ?>   : <?php echo addslashes(_CALENDAR); ?>
:   : <?php echo addslashes(_CALENDAR); ?>
:   :
:   :    
: get_domains($destination); } ?>       '; if($_SESSION['user']['modif_rights'] && ($status != "END" && $status != "DEL" && $status != "MEP" && $status != "RJD") ) { echo ''; } else { echo ''; } echo ' '; } ?>

 

 

:

:   :
:   : " />
:   :

 

 

:

:

 '#courrier#' && $status <> 'DEL' && ($status != "END" && $status != "DEL" && $status != "MEP" && $status != "RJD") ) { if($_SESSION['config']['private_notes'] == "true") { $windowSize = '500, 700'; } else{ $windowSize = '500, 250'; } ?>

:

:

:

:

Mailmanager :

: