/[openfoncier]/trunk/sql/pgsql/travaux_nature.reqmo.inc.php
ViewVC logotype

Annotation of /trunk/sql/pgsql/travaux_nature.reqmo.inc.php

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1138 - (hide annotations)
Thu Jan 3 15:18:21 2013 UTC (12 years, 1 month ago) by nhaye
File size: 718 byte(s)
Suppression de la colonne nature de la table dossier,
correction des requètes sql faisant appel à cette colonne.

1 fraynaud 3 <?php
2     //$Id$
3     //gen openMairie le 10/02/2011 20:37
4     $reqmo['libelle']=' public.travaux';
5     $reqmo['reqmo_libelle']=' public.travaux';
6 nhaye 1138 $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 fraynaud 3 $reqmo['travaux']='checked';
15     $reqmo['libelle']='checked';
16 nhaye 1138 $reqmo['nature']="select dossier_autorisation_type,code from ".DB_PREFIXE."dossier_autorisation_type";
17 fraynaud 3 $reqmo['codelascot']='checked';
18     $reqmo['solde']='checked';
19     $reqmo['tri']=array('travaux','libelle','codelascot','solde');
20     ?>

[email protected]
ViewVC Help
Powered by ViewVC 1.1.26