"pagination_select", 'display' => false ); $tab_actions['content']['lien'] = null; $tab_actions['corner']['ajouter'] = null; $tab_actions['left']['consulter'] = null; $tab_actions['left']['previsualiser'] = array( 'lien' => ''.OM_ROUTE_SOUSFORM.'&obj='.$obj.'&action=401&idxformulaire='.$idxformulaire.'&idx=', 'id' => '&tri='.$tricolsf.'&objsf='.$obj.'&premiersf='.$premier.'&retourformulaire='.$retourformulaire.'&idxformulaire='.$idxformulaire.'&trisf='.$tricolsf.'&retour=tab', 'lib' => ' Prévisualiser ', 'rights' => array('list' => array($obj, $obj . '_previsualiser'), 'operator' => 'OR'), 'ordre' => 100, 'ajax' => false ); // Action sur la deuxième colonne de contenu $tab_actions['specific_content'][1] = array( 'lien' => OM_ROUTE_FORM.'&obj=instruction&action=405&champ=om_fichier_instruction&idx=', 'id' => '" target="_blank', 'ordre' => 10, 'ajax' => false ); // Add Join here ? $table = sprintf('( SELECT i.om_fichier_instruction, i.dossier, i.instruction::text AS instruction, i.fichier_instruction_name AS file_name, COALESCE(dt.libelle, \'N/A\') AS libelle, i.date_finalisation_courrier, i.date_retour_rar, i.date_evenement FROM %1$sinstruction AS i LEFT JOIN %1$sdocument_type AS dt ON i.document_type_instruction = dt.document_type WHERE i.om_fichier_instruction IS NOT NULL AND i.dossier = \'%2$s\' UNION ALL SELECT s.uid AS om_fichier_instruction, s.info::json->>\'dossier\' AS dossier, (\'STORAGE_\' || s.storage) AS instruction, s.filename AS file_name, COALESCE(NULLIF(s.info::json->>\'document_type_libelle\',\'\'), \'N/A\') AS libelle, NULLIF(s.info::json->>\'date_finalisation_courrier\',\'\')::date AS date_finalisation_courrier, NULLIF(s.info::json->>\'date_retour_rar\',\'\')::date AS date_retour_rar, NULLIF(s.info::json->>\'date_evenement\',\'\')::date AS date_evenement FROM %1$sstorage AS s WHERE s.info::json->>\'can_be_document_instruction\' = \'true\' AND s.info::json->>\'dossier\' = \'%2$s\' ) AS instruction', DB_PREFIXE, $f->db->escapeSimple($idxformulaire) ); $champAffiche=array( "instruction.instruction as \"".__("id")."\"", "CONCAT( '', instruction.file_name, '' ) as \"".__("nom du fichier")."\"", "instruction.libelle as type", "to_char(instruction.date_finalisation_courrier ,'DD/MM/YYYY') as \"".__("date de finalisation")."\"", "to_char(instruction.date_retour_rar ,'DD/MM/YYYY') as \"".__("date de notification")."\"", ); // Limit filter here // Filtre listing sous formulaire - dossier_instruction : // aucun (intégré à la requête de $table) $selection =""; $champRecherche = array( "instruction.instruction as \"".__("nom du fichier")."\"", "instruction.lettretype as type", "instruction.date_finalisation_courrier as \"".__("date de finalisation")."\"", "instruction.date_retour_rar as \"".__("date de notification")."\"", );