'; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $db = new dbquery(); $db->connect(); $query = "select * from res_view_letterbox where (exp_contact_id = " . $_REQUEST['contact_id'] . " or dest_contact_id = " . $_REQUEST['contact_id'] .") and status <> 'DEL'"; $db->query($query); $cptDocs = 0; while ($return_db = $db->fetch_object()) { if ($cptDocs < 10) { $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= '

	'; $return .= _STATUS; $return .= '	'; $return .= _DATE; $return .= '	'; $return .= _SUBJECT; $return .= '	'; $return .= _DEPARTMENT_DEST; $return .= '	'; $return .= _DOCTYPE; $return .= '	'; $return .= _ID; $return .= '
'; $return .= '  '; $return .= 'res_id; $return .= '" '; $return .= 'target="_blank" '; $return .= '>'; $return .= 'connect(); $query = "select label_status from status " . "where id ='".$return_db->status."'"; $db2->query($query); while ($status_db = $db2->fetch_object()) { $return .= $status_db->label_status; } $return .= '	'; $return .= '  '; $return .= $db2->format_date_db($return_db->creation_date); $return .= '	'; $return .= '  '; $return .= $db2->cut_string($return_db->subject, 40); $return .= '	'; $return .= '  '; $return .= $return_db->entity_label; $return .= '	'; $return .= '  '; $return .= $return_db->type_label; $return .= '	'; $return .= '  '; $return .= $return_db->res_id; $return .= '	'; $return .= '  '; $return .= 'res_id; $return .= '" '; $return .= 'target="_blank" '; $return .= '>'; $return .= '