'; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $db = new Database(); $query = "SELECT * FROM res_view_letterbox WHERE (exp_contact_id = ? or dest_contact_id = ?) and status <> 'DEL'"; $stmt = $db->query($query, array($_REQUEST['contact_id'], $_REQUEST['contact_id'])); $cptDocs = 0; while ($return_db = $stmt->fetchObject()) { if ($cptDocs < 10) { $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; } else { $return .= ''; break; } $cptDocs++; } $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 .= ''; $return .= ''; $return .= '	'; $return .= '  '; $query = "SELECT label_status FROM status " . "WHERE id = ?"; $stmt2 = $db->query($query, array($return_db->status)); while ($status_db = $stmt2->fetchObject()) { $return .= $status_db->label_status; } $return .= '	'; $return .= '  '; $return .= functions::format_date_db($return_db->creation_date); $return .= '	'; $return .= '  '; $return .= functions::cut_string($return_db->subject, 40); $return .= '	'; $return .= '  '; $return .= functions::xssafe($return_db->entity_label); $return .= '	'; $return .= '  '; $return .= functions::xssafe($return_db->type_label); $return .= '	'; $return .= '  '; $return .= functions::xssafe($return_db->res_id); $return .= '	'; $return .= '  '; $return .= 'res_id; $return .= '" '; $return .= 'target="_blank" '; $return .= '>'; $return .= ''; $return .= ''; $return .= '
...

'; $return .= '
'; $return .= '