<?php
//$Id: contrainte.inc.php 5213 2015-09-24 14:31:59Z stimezouaght $ 
//gen openMairie le 03/01/2014 16:53

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

// Fil d'Ariane
$ent = __("parametrage dossiers")." -> ".__("dossiers")." -> ".__("contrainte");

// SELECT
$champAffiche = array(
    'contrainte.contrainte as "'.__("contrainte").'"',
    'contrainte.libelle as "'.__("libelle").'"',
    'contrainte.nature as "'.__("nature").'"',
    'contrainte.groupe as "'.__("groupe").'"',
    'contrainte.sousgroupe as "'.__("sousgroupe").'"',
    "case contrainte.reference when 't' then 'Oui' else 'Non' end as \"".__("reference")."\"",
    'to_char(contrainte.om_validite_debut ,\'DD/MM/YYYY\') as "'.__("om_validite_debut").'"',
    'to_char(contrainte.om_validite_fin ,\'DD/MM/YYYY\') as "'.__("om_validite_fin").'"',
);

//
if ($_SESSION['niveau'] == '2') {
    array_push($champAffiche, "om_collectivite.libelle as \"".__("collectivite")."\"");
}

// Supprime les sous-formulaires
$sousformulaire = array();

?>