<?php
//$Id: commission.inc.php 4418 2015-02-24 17:30:28Z tbenita $ 
//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")."\"",
    );
?>