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	fmichon	647	<?php
2
3			//
4			include('../sql/pgsql/dossier.inc.php');
5
6	fmichon	656	//
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	fmichon	686	//
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	nhaye	1023	'dossier.etat as "'._("etat").'"',
25	fmichon	686	);
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	fmichon	647	?>