'; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $db = new Database(); $query = "SELECT * FROM res_view_attachments WHERE res_id_master = ? AND status NOT IN ('DEL', 'OBS') AND attachment_type NOT IN ('converted_pdf', 'print_folder') AND coll_id = ? AND (status <> 'TMP' or (typist = ? and status = 'TMP')) ORDER BY creation_date desc"; $arrayPDO = array($_REQUEST['res_id_master'], $_SESSION['collection_id_choice'], $_SESSION['user']['UserId']); $stmt = $db->query($query, $arrayPDO); while ($return_db = $stmt->fetchObject()) { if (!empty($_REQUEST['option']) && $_REQUEST['option'] == 'FT') { if ($return_db->format != 'pdf') { $stmtFullText = $db->query('SELECT res_id FROM res_view_attachments WHERE filename = ? and attachment_type = ? and path = ? ORDER BY relation desc', [str_replace('.' . $return_db->format, '.pdf', $return_db->filename), 'converted_pdf', $return_db->path]); $lineFullText = $stmtFullText->fetchObject(); if ($lineFullText && $lineFullText->res_id != 0) $resIdConverted = $lineFullText->res_id; } $stmt2 = $db->query( "SELECT count(*) as total FROM res_view_attachments WHERE res_id = ? and status not in ('DEL','OBS','TMP') and lower(translate(title,'ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûýýþÿŔŕ','aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnoooooouuuyybyRr')) like lower(?)", array($return_db->res_id,$_SESSION['searching']['where_request_parameters'][':subject']) ); $res_attach = $stmt2->fetchObject(); if ((!empty($_SESSION['fullTextAttachments']['attachments']) && in_array($return_db->res_id, $_SESSION['fullTextAttachments']['attachments'])) || (!empty($_SESSION['fullTextAttachments']['versionAttachments']) && in_array($return_db->res_id_version, $_SESSION['fullTextAttachments']['versionAttachments'])) ) { $return .= ''; } else if (!empty($resIdConverted) && !empty($_SESSION['fullTextAttachments']['attachments']) && in_array($resIdConverted, $_SESSION['fullTextAttachments']['attachments'])) { $return .= ''; } elseif($res_attach->total > 0){ $return .= ''; } else { $return .= ''; } } else if (!empty($_REQUEST['option']) && $_REQUEST['option'] == 'baskets' && $return_db->status == 'EXP_RTURN' && $return_db->validation_date && $return_db->validation_date < date('Y-m-d')) { $return .= ''; } else { $return .= ''; } $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; $return .= ''; } $return .= '

'; $return .= _CHRONO_NUMBER; $return .= '	'; $return .= _STATUS; $return .= '	'; $return .= _ATTACHMENT_TYPE; $return .= '	'; $return .= _CREATION_DATE; $return .= '	'; $return .= _BACK_DATE; $return .= '	'; $return .= _SUBJECT; $return .= '	'; $return .= _AUTHOR; $return .= '	'; $return .= _CONSULT; $return .= '
'; $return .= '  '; $return .= functions::xssafe($return_db->identifier); $return .= '	'; $return .= '  '; $query = "SELECT label_status FROM status WHERE id =?"; $arrayPDO = array($return_db->status); $stmt2 = $db->query($query, $arrayPDO); while ($status_db = $stmt2->fetchObject()) { $return .= functions::xssafe($status_db->label_status); } $return .= '	'; $return .= '  '; $attachment_types_valeur = $return_db->attachment_type; $return .= functions::xssafe($_SESSION['attachment_types'][$attachment_types_valeur]); $return .= '	'; $return .= '  '; sscanf(substr($return_db->creation_date, 0, 10), "%4s-%2s-%2s", $date_Y, $date_m, $date_d); switch ($date_m) { case '01': $date_m_txt = _JANUARY; break; case '02': $date_m_txt = _FEBRUARY; break; case '03': $date_m_txt = _MARCH; break; case '04': $date_m_txt = _APRIL; break; case '05': $date_m_txt = _MAY; break; case '06': $date_m_txt = _JUNE; break; case '07': $date_m_txt = _JULY; break; case '08': $date_m_txt = _AUGUST; break; case '09': $date_m_txt = _SEPTEMBER; break; case '10': $date_m_txt = _OCTOBER; break; case '11': $date_m_txt = _NOVEMBER; break; case '12': $date_m_txt = _DECEMBER; break; default: $date_m_txt = $date_m; } $return .= functions::xssafe($date_d.' '.$date_m_txt.' '.$date_Y); $return .= '	'; $return .= '  '; if ($return_db->validation_date) { sscanf(substr($return_db->validation_date, 0, 10), "%4s-%2s-%2s", $date_Y, $date_m, $date_d); switch ($date_m) { case '01': $date_m_txt = _JANUARY; break; case '02': $date_m_txt = _FEBRUARY; break; case '03': $date_m_txt = _MARCH; break; case '04': $date_m_txt = _APRIL; break; case '05': $date_m_txt = _MAY; break; case '06': $date_m_txt = _JUNE; break; case '07': $date_m_txt = _JULY; break; case '08': $date_m_txt = _AUGUST; break; case '09': $date_m_txt = _SEPTEMBER; break; case '10': $date_m_txt = _OCTOBER; break; case '11': $date_m_txt = _NOVEMBER; break; case '12': $date_m_txt = _DECEMBER; break; default: $date_m_txt = $date_m; } $return .= functions::xssafe($date_d.' '.$date_m_txt.' '.$date_Y); } else { $return .= '-'; } $return .= '	'; $return .= '  '; $return .= functions::xssafe($return_db->title); $return .= '	'; $return .= '  '; $current_user = $users->get_user($return_db->typist); $return .= functions::xssafe($current_user['firstname']) . ' ' . functions::xssafe($current_user['lastname']); $return .= '	'; $return .= '  '; $return .= 'res_id <> 0) { $id = $return_db->res_id; } else { $id = $return_db->res_id_version; } $return .= 'index.php?display=true&module=attachments&page=view_attachment&id='.$id.'&res_id_master=' . functions::xssafe($_REQUEST['res_id_master']); $return .= '" '; $return .= 'target="_blank" '; $return .= '>'; $return .= ''; $return .= ''; $return .= '

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