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; $is_folder = $details->IS_FOLDER; $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."'"); // $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_desc = $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; } ?>