*/ include("session.php"); if(file_exists($_SESSION['config']['lang'].'.php')) { include($_SESSION['config']['lang'].'.php'); } else { $_SESSION['error'] = "Language file missing...
"; } ?> <?php echo $_SESSION['config']['applicationname']; ?> > connect(); $db2 = new dbquery(); $db2->connect(); $couleur=0; if(empty($_SESSION['tablechoice'])) { $_SESSION['tablechoice'] = 'res_x'; } if(isset($_GET['id'])) { $s_id = $_GET['id']; } else { $s_id = ""; } $db2->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 ".$_SESSION['ressources'][0]['tablename']." where RES_ID = ".$s_id); $details = $db2->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; //$db->show(); ?>



   
   
   
   
   
   
query("select i.ID, i.INFO, i.DATE, i.USER_ID, u.LASTNAME, u.FIRSTNAME from ".$_SESSION['tablename']['notes']." i inner join ".$_SESSION['tablename']['users']." u on i.USER_ID = u.USER_ID WHERE RECORD_ID= ".$s_id." ORDER BY DATE desc"); ?> fetch_object()) { ?>
dateformat($res->DATE); ?> FIRSTNAME." ".$res->LASTNAME." "; ?> show($res->INFO); ?>