sql/pgsql/travaux_nature.reqmo.inc.php

<?php
//$Id$ 
//gen openMairie le 10/02/2011 20:37 
$reqmo['libelle']=' public.travaux';
$reqmo['reqmo_libelle']=' public.travaux';
$reqmo['sql']="select [travaux],
                        [travaux.libelle as libelle],
                        [codelascot],
                        [solde]
                from ".DB_PREFIXE."travaux
                where travaux.dossier_autorisation_type = [nature]

                order by [tri]";
$reqmo['travaux']='checked';
$reqmo['libelle']='checked';
$reqmo['nature']="select dossier_autorisation_type,code from ".DB_PREFIXE."dossier_autorisation_type";
$reqmo['codelascot']='checked';
$reqmo['solde']='checked';
$reqmo['tri']=array('travaux','libelle','codelascot','solde');
?>
1	<?php
2	//$Id$
3	//gen openMairie le 10/02/2011 20:37
4	$reqmo['libelle']=' public.travaux';
5	$reqmo['reqmo_libelle']=' public.travaux';
6	$reqmo['sql']="select [travaux],
7	[travaux.libelle as libelle],
8	[codelascot],
9	[solde]
10	from ".DB_PREFIXE."travaux
11	where travaux.dossier_autorisation_type = [nature]
12
13	order by [tri]";
14	$reqmo['travaux']='checked';
15	$reqmo['libelle']='checked';
16	$reqmo['nature']="select dossier_autorisation_type,code from ".DB_PREFIXE."dossier_autorisation_type";
17	$reqmo['codelascot']='checked';
18	$reqmo['solde']='checked';
19	$reqmo['tri']=array('travaux','libelle','codelascot','solde');
20	?>