sql/pgsql/contrainte.inc.php

<?php
//$Id$ 
//gen openMairie le 03/01/2014 16:53

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

// Fil d'Ariane
$ent = _("parametrage dossiers")." -> "._("dossiers")." -> "._("contrainte");
if (isset($idx) && $idx != ']' && trim($idx) != '') {
    $ent .= "->&nbsp;".$idx."&nbsp;";
}
if (isset($idz) && trim($idz) != '') {
    $ent .= "&nbsp;".strtoupper($idz)."&nbsp;";
}

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

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

?>
1	<?php
2	//$Id$
3	//gen openMairie le 03/01/2014 16:53
4
5	include('../gen/sql/pgsql/contrainte.inc.php');
6
7	// Fil d'Ariane
8	$ent = _("parametrage dossiers")." -> "._("dossiers")." -> "._("contrainte");
9	if (isset($idx) && $idx != ']' && trim($idx) != '') {
10	$ent .= "-> ".$idx." ";
11	}
12	if (isset($idz) && trim($idz) != '') {
13	$ent .= " ".strtoupper($idz)." ";
14	}
15
16	// SELECT
17	$champAffiche = array(
18	'contrainte.contrainte as "'._("contrainte").'"',
19	'contrainte.libelle as "'._("libelle").'"',
20	'contrainte.nature as "'._("nature").'"',
21	'contrainte.groupe as "'._("groupe").'"',
22	'contrainte.sousgroupe as "'._("sousgroupe").'"',
23	"case contrainte.reference when 't' then 'Oui' else 'Non' end as \""._("reference")."\"",
24	'to_char(contrainte.om_validite_debut ,\'DD/MM/YYYY\') as "'._("om_validite_debut").'"',
25	'to_char(contrainte.om_validite_fin ,\'DD/MM/YYYY\') as "'._("om_validite_fin").'"',
26	);
27
28	// Supprime les sous-formulaires
29	$sousformulaire = array();
30
31	?>