* @author Loic Vinet */ require("test_page.php"); require_once("class_functions.php"); require_once("class_db.php"); $func = new functions(); $connexion = new dbquery(); $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)); } $_SESSION['origin'] = "details"; $_SESSION["popup_suite"] = false; if(isset($_POST['modif'])) { $connexion->query("select IDENTIFIER, CREATION_DATE, CUSTOM_T3, AUTHOR, CUSTOM_T4, CUSTOM_D2 from res_x 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 = ""; $db_istres = new dbquery(); $db_istres -> connect(); //if($_POST['gid_id'] <> '') //{ // $db_istres -> query("select count(*) as nb from res_x where GID_ID = '".$_POST['gid_id']."' "); // $res_istres = $db_istres -> fetch_object(); // if($res_istres -> nb <> 0) // { // $_SESSION['error'] .= _GID_ID_EXISTS.".
"; // } // else // { // $query .= " GID_ID = '".$_POST['gid_id']."' ,"; // } //} //else //{ // $_SESSION['error'] .= _GID_ID_MISSING.".
"; //} if(isset($_POST['emetteur']) && !empty($_POST['emetteur'])) { $query .= " AUTHOR = '".$_POST['emetteur']."' ,"; } else { $_SESSION['error'] .= _SHIPPER_FORGOTTEN."
"; } 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']."' ,"; } 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']) && !empty($_POST['priority'])) { $query .= " PRIORITY = '".$_POST['priority']."' ,"; } if(count($_SESSION['diff']) < 1) { $_SESSION['error'] .= _DEST_FORGOTTEN."
"; } else { $query .= " DEST_USER = '".$_SESSION['diff'][0]['UserID']."' ,"; if(empty($_SESSION['error'])) { $connexion->query("DELETE from ".$_SESSION['tablename']['listinstance']." where RES_ID = ".$s_id); if( $_SESSION['is_diff']) { if($_SESSION['config']['enablechangenotif'] == "true") { $mail_trait = "
"._MAIL_TO_PROCESS.".

"._HELLO.",
"._NEED_PROCESS_LETTER." :


"; $mail_copie = "
"._MAIL_IN_COPY."

"._HELLO.",
"._YOU_HAVE_MAIL_COPY." :


\n\n"; } } for($i=0;$iquery("INSERT into ".$_SESSION['tablename']['listinstance']." ( RES_TABLE, RES_ID, SEQUENCE, USER_ID) values ( 'res_x', ".$s_id.", ".$j.", '".$_SESSION['diff'][$i]['UserID']."')"); if($_SESSION['config']['enablechangenotif'] == "true") { $connexion->query("select MAIL from ".$_SESSION['tablename']['users']." where USER_ID = '".$_SESSION['diff'][$i]['UserID']."'"); $res = $connexion->fetch_object(); $mail = $res->MAIL; if( $_SESSION['is_diff'] && $i==0) { mail($mail, _PROCESS_MAIL, $mail_trait , "From: ".$_SESSION['config']['mail']."\r\nReply-To: ".$_SESSION['config']['mail']." \r\nContent-Type: text/html; charset=\"iso-8859-1\"\r\n"); } elseif($_SESSION['is_diff'] && $i > 0) { mail($mail, _FIRST_WARNING_TXT, $mail_copie , "From: ".$_SESSION['config']['mail']."\r\nReply-To: ".$_SESSION['config']['mail']." \r\nContent-Type: text/html; charset=\"iso-8859-1\"\r\n"); } } } } } if(empty($_SESSION['error'])) { $query = trim($query); $query = ereg_replace(",$", "", $query); $connexion->query("UPDATE res_x set ".$query." where RES_ID = ".$s_id); if($_SESSION['history']['resup'] ) { require_once("class_history.php"); $hist = new history(); $hist->add('res_x', $s_id, "UP",_MODIF_MAIL_INDEX.$s_id); } } } $_SESSION['detail_id'] =$s_id; if(empty($_SESSION['error']) || $_SESSION['indexation']) { $table =""; if(isset($_SESSION['tablechoice']) && !empty($_SESSION['tablechoice'])) { $table = $_SESSION['tablechoice']; } else { $table = $_SESSION['ressources'][0]['tablename']; } $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_T5, CUSTOM_T6, CUSTOM_T7, CUSTOM_T8, CUSTOM_D3, CUSTOM_T1, CUSTOM_T15, CUSTOM_T16, CUSTOM_T17, IS_INGOING, PRIORITY, SOCIETE, GID_ID FROM ".$table." where RES_ID = ".$s_id); } ?>

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








nb_result() == 0) { ?>



.


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_name = $details->AUTHOR_NAME; $dest_user = $details->DEST_USER; $destination = $details->DESTINATION; $_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; $out = FALSE; if($is_ingoing == 'N' && $status == 'OUT') { $out = TRUE; $connexion->query("select LASTNAME, FIRSTNAME from ".$_SESSION['tablename']['users']." where USER_ID = '".$author."'"); $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(); $typist = $res->FIRSTNAME.' '.$res->LASTNAME; if($res->STATUS == 'OK') { if($res->ENABLED == 'N') { $typist .= ' ('._NOT_ENABLED.')'; } } else { $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(!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; } } } $connexion->query("select SERVICE FROM ".$_SESSION['tablename']['services']." WHERE ID ='".$destination."' "); $res = $connexion->fetch_object(); $service = $res->SERVICE; $copies = array(); $connexion->query("select u.USER_ID as ID, u.FIRSTNAME as FIRST_NAME, u.LASTNAME as LAST_NAME from ".$_SESSION['tablename']['listinstance']." l, ".$_SESSION['tablename']['users']." u where l.RES_TABLE = 'res_x' and l.RES_ID = ".$s_id." and l.SEQUENCE > 1 and u.USER_ID = l.USER_ID"); while ($res = $connexion->fetch_object()) { array_push($copies, array( 'ID' => $res->ID, 'FIRST_NAME' => $res->FIRST_NAME, 'LAST_NAME'=> $res->LAST_NAME)); } if($_SESSION['user']['modif_rights']) { $connexion->query("select * from ".$_SESSION['tablename']['services']." where ENABLED = 'Y' order by SERVICE"); $modif_services = array(); while($res = $connexion->fetch_object()) { array_push($modif_services, array('ID' => $res->ID, 'LABEL' => $res->SERVICE)); } $types_list = array(); $connexion->query("select TYPE_ID, DESCRIPTION from ".$_SESSION['tablename']['doctypes']." where ENABLED = 'Y'"); $types_list = array(); while($res = $connexion->fetch_object()) { array_push($types_list, array('ID' => $res->TYPE_ID, 'LABEL' => $res->DESCRIPTION)); } } else { $dest = ""; $connexion->query("select FIRSTNAME, LASTNAME from ".$_SESSION['tablename']['users']." where USER_ID = '".$dest_user."'"); $res = $connexion->fetch_object(); $dest = $res->FIRSTNAME." ".$res->LASTNAME; } ?>

:

:   :
:   :
:   : " />
:   :
:   :
:

:

:

:

 

:

 '#courrier#') { ?>

 

false && $courrier <>'false') { $types_rep .= _MAIL2.', '; } if($courrierAR <> false && $courrierAR <>'false') { $types_rep .= _AR_MAIL.', '; } if($direct <> false && $direct <>'false') { $types_rep .= _DIRECT_CONTACT.', '; } if($mail <> false && $mail <> 'false') { $types_rep .= _MAIL.', '; } if($fax <> false && $fax <>'false') { $types_rep .= _FAX.', '; } if($noresp <> false && $norep <>'false') { $types_rep .= _NO_ANSWER_NECESSARY.', '; } if($autre <> false && $autre <>'false') { $types_rep .= " ".$autre."".', '; } $types_rep = ereg_replace(', $', '', $types_rep); ?>

0) { echo "
    "; for($i=0; $i < count($rep); $i++) { ?>
  •   
    • "; } else { echo ""._ACTUALLY_NO_ANSWER.""; } ?>

 

:

:   :
:   : " />
:   :

: