<?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").'"',
);

// Si la collectivité de l'utilisateur est de niveau multi
// alors on ajoute pas la colonne collectivité
if ($f->isCollectiviteMono($_SESSION['collectivite']) === false) {
    $champAffiche[] = 'om_collectivite.libelle as "'.__("collectivite").'"';
}

?>