sql/pgsql/dossier_instruction.inc.php

<?php

//
include('../sql/pgsql/dossier.inc.php');

//
$ent = _("instruction")." -> "._("dossier d'instruction");
if (isset($idx) && $idx != ']' && trim($idx) != '') {
    $ent .= "->&nbsp;".$idx."&nbsp;";
}
if (isset($idz) && trim($idz) != '') {
    $ent .= "&nbsp;".strtoupper($idz)."&nbsp;";
}

//
$champAffiche_debut_commun = array(
    'dossier.dossier as "'._("dossier").'"',
    'dossier.demandeur_nom as "'._("demandeur_nom").'"',
    'to_char(dossier.date_demande ,\'DD/MM/YYYY\') as "'._("date_demande").'"',
    'to_char(dossier.date_depot ,\'DD/MM/YYYY\') as "'._("date_depot").'"',
    'to_char(dossier.date_complet ,\'DD/MM/YYYY\') as "'._("date_complet").'"',
    'to_char(dossier.date_notification_delai ,\'DD/MM/YYYY\') as "'._("date_notification_delai").'"',
    'to_char(dossier.date_limite ,\'DD/MM/YYYY\') as "'._("date_limite").'"',
    'dossier.etat as "'._("etat").'"',
);
$champAffiche_fin_commun = array(
    'CASE WHEN dossier.enjeu_urba is TRUE
          THEN \'<span class="om-icon om-icon-16 om-icon-fix enjeu_urba-16" title="'._("Enjeu URBA").'">URBA</span>\'
          ELSE \'\'
          END ||
     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
     as "'._("enjeu").'"',
);

//
$champAffiche = array_merge($champAffiche_debut_commun, array(
    'instructeur.nom as "'._("instructeur").'"',
    'division.code as "'._("division").'"',
), $champAffiche_fin_commun);

?>
1	<?php
2
3	//
4	include('../sql/pgsql/dossier.inc.php');
5
6	//
7	$ent = _("instruction")." -> "._("dossier d'instruction");
8	if (isset($idx) && $idx != ']' && trim($idx) != '') {
9	$ent .= "-> ".$idx." ";
10	}
11	if (isset($idz) && trim($idz) != '') {
12	$ent .= " ".strtoupper($idz)." ";
13	}
14
15	//
16	$champAffiche_debut_commun = array(
17	'dossier.dossier as "'._("dossier").'"',
18	'dossier.demandeur_nom as "'._("demandeur_nom").'"',
19	'to_char(dossier.date_demande ,\'DD/MM/YYYY\') as "'._("date_demande").'"',
20	'to_char(dossier.date_depot ,\'DD/MM/YYYY\') as "'._("date_depot").'"',
21	'to_char(dossier.date_complet ,\'DD/MM/YYYY\') as "'._("date_complet").'"',
22	'to_char(dossier.date_notification_delai ,\'DD/MM/YYYY\') as "'._("date_notification_delai").'"',
23	'to_char(dossier.date_limite ,\'DD/MM/YYYY\') as "'._("date_limite").'"',
24	'dossier.etat as "'._("etat").'"',
25	);
26	$champAffiche_fin_commun = array(
27	'CASE WHEN dossier.enjeu_urba is TRUE
28	THEN \'<span class="om-icon om-icon-16 om-icon-fix enjeu_urba-16" title="'._("Enjeu URBA").'">URBA</span>\'
29	ELSE \'\'
30	END \|\|
31	CASE WHEN dossier.enjeu_erp is TRUE
32	THEN \'<span class="om-icon om-icon-16 om-icon-fix enjeu_erp-16" title="'._("Enjeu ERP").'">ERP</span>\'
33	ELSE \'\'
34	END
35	as "'._("enjeu").'"',
36	);
37
38	//
39	$champAffiche = array_merge($champAffiche_debut_commun, array(
40	'instructeur.nom as "'._("instructeur").'"',
41	'division.code as "'._("division").'"',
42	), $champAffiche_fin_commun);
43
44	?>