16 |
'to_char(dossier.date_limite ,\'DD/MM/YYYY\') as "'._("date_limite").'"', |
'to_char(dossier.date_limite ,\'DD/MM/YYYY\') as "'._("date_limite").'"', |
17 |
'etat as "'._("etat").'"', |
'etat as "'._("etat").'"', |
18 |
'avis_decision.libelle as "'._("avis_decision").'"', |
'avis_decision.libelle as "'._("avis_decision").'"', |
19 |
'CASE WHEN dossier.enjeu_erp is TRUE THEN \'<span class="om-icon om-icon-16 om-icon-fix enjeu_erp-16" title="'._('Enjeu ERP').'">ERP</span>\' ELSE \'\' END || |
'CASE WHEN dossier.enjeu_erp is TRUE THEN \'<span class="om-icon om-icon-16 om-icon-fix enjeu-16" title="'._('Enjeu ERP').'">ERP</span>\' ELSE \'\' END || |
20 |
CASE WHEN dossier.enjeu_urba is TRUE THEN \'<span class="om-icon om-icon-16 om-icon-fix enjeu_erp-16" title="'._('Enjeu Urba').'">URBA</span>\' ELSE \'\' END |
CASE WHEN dossier.enjeu_urba is TRUE THEN \'<span class="om-icon om-icon-16 om-icon-fix enjeu-16" title="'._('Enjeu Urba').'">URBA</span>\' ELSE \'\' END |
21 |
as "'._("enjeu").'"', |
as "'._("enjeu").'"', |
22 |
); |
); |
23 |
|
|
42 |
$selection=" where dossier.travaux ='".$idx."'"; |
$selection=" where dossier.travaux ='".$idx."'"; |
43 |
} |
} |
44 |
|
|
45 |
if (isset($_GET["obj"]) && $_GET["obj"] == "dossier") { |
if (isset($_GET["obj"]) && $_GET["obj"] == "dossier_instruction") { |
46 |
// Configuration de la recherche avancee |
// Configuration de la recherche avancee |
47 |
if (!isset($options)) { |
if (!isset($options)) { |
48 |
$options = array(); |
$options = array(); |