sql/pgsql/commission.inc.php

<?php
//$Id$ 
//gen openMairie le 07/12/2012 17:33

include('../gen/sql/pgsql/commission.inc.php');

$ent = _("suivi")." -> "._("commissions")." -> "._("gestion");


//Suppression de l'onglet inutile
$sousformulaire = array();

$tri="ORDER BY commission.date_commission DESC NULLS LAST";

$champAffiche = array(
    'commission.commission as "'._("commission").'"',
    'commission.code as "'._("code").'"',
    'commission_type.libelle as "'._("commission_type").'"',
    'commission.libelle as "'._("libelle").'"',
    'to_char(commission.date_commission ,\'DD/MM/YYYY\') as "'._("date_commission").'"',
    'commission.heure_commission as "'._("heure_commission").'"',
    'commission.lieu_adresse_ligne1 as "'._("lieu_adresse_ligne1").'"',
    'commission.lieu_adresse_ligne2 as "'._("lieu_adresse_ligne2").'"',
    'commission.lieu_salle as "'._("lieu_salle").'"',
    );
//
$champNonAffiche = array(
    'commission.listes_de_diffusion as "'._("listes_de_diffusion").'"',
    'commission.participants as "'._("participants").'"',
    'commission.om_fichier_commission_ordre_jour
    as "'._("om_fichier_commission_ordre_jour").'"',
    "case commission.om_final_commission_ordre_jour
    when 't' then 'Oui' else 'Non' end
    as \""._("om_final_commission_ordre_jour")."\"",
    'commission.om_fichier_commission_compte_rendu
    as "'._("om_fichier_commission_compte_rendu").'"',
    "case commission.om_final_commission_compte_rendu
    when 't' then 'Oui' else 'Non' end
    as \""._("om_final_commission_compte_rendu")."\"",
    );
?>
1	<?php
2	//$Id$
3	//gen openMairie le 07/12/2012 17:33
4
5	include('../gen/sql/pgsql/commission.inc.php');
6
7	$ent = _("suivi")." -> "._("commissions")." -> "._("gestion");
8
9
10	//Suppression de l'onglet inutile
11	$sousformulaire = array();
12
13	$tri="ORDER BY commission.date_commission DESC NULLS LAST";
14
15	$champAffiche = array(
16	'commission.commission as "'._("commission").'"',
17	'commission.code as "'._("code").'"',
18	'commission_type.libelle as "'._("commission_type").'"',
19	'commission.libelle as "'._("libelle").'"',
20	'to_char(commission.date_commission ,\'DD/MM/YYYY\') as "'._("date_commission").'"',
21	'commission.heure_commission as "'._("heure_commission").'"',
22	'commission.lieu_adresse_ligne1 as "'._("lieu_adresse_ligne1").'"',
23	'commission.lieu_adresse_ligne2 as "'._("lieu_adresse_ligne2").'"',
24	'commission.lieu_salle as "'._("lieu_salle").'"',
25	);
26	//
27	$champNonAffiche = array(
28	'commission.listes_de_diffusion as "'._("listes_de_diffusion").'"',
29	'commission.participants as "'._("participants").'"',
30	'commission.om_fichier_commission_ordre_jour
31	as "'._("om_fichier_commission_ordre_jour").'"',
32	"case commission.om_final_commission_ordre_jour
33	when 't' then 'Oui' else 'Non' end
34	as \""._("om_final_commission_ordre_jour")."\"",
35	'commission.om_fichier_commission_compte_rendu
36	as "'._("om_fichier_commission_compte_rendu").'"',
37	"case commission.om_final_commission_compte_rendu
38	when 't' then 'Oui' else 'Non' end
39	as \""._("om_final_commission_compte_rendu")."\"",
40	);
41	?>