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

Diff of /trunk/sql/pgsql/dossier_sansparcelle.reqmo.inc.php

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 199 by fraynaud, Thu Feb 10 20:46:18 2011 UTC revision 200 by fraynaud, Mon Oct 17 07:31:00 2011 UTC
# Line 11  $reqmo['libelle']="dossier_sansparcelle" Line 11  $reqmo['libelle']="dossier_sansparcelle"
11  $reqmo['sql']="select dossier,  $reqmo['sql']="select dossier,
12                        [nature],                        [nature],
13                        [etat],                        [etat],
14                        concat(substring(date_depot,9,2),'/',substring(date_depot,6,2),'/',substring(date_depot,1,4)) as date_depot_francais                        to_char(date_depot,'DD/MM/YYYY') as date_depot_francais
15                         from dossier                         from dossier
16                         where parcelle ='' order by date_depot desc";                         where parcelle ='' order by date_depot desc";
17  $reqmo['nature']="checked";  $reqmo['nature']="checked";
Legend:
Removed from v.199  
changed lines
  Added in v.200
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26