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

Diff of /trunk/sql/pgsql/terrain.inc.php

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

trunk/sql/pgsql/terrain.inc revision 20 by fraynaud, Mon Jul 18 15:27:17 2011 UTC trunk/sql/pgsql/terrain.inc.php revision 461 by nhaye, Thu Sep 27 10:36:55 2012 UTC
# Line 2  Line 2 
2  //$Id$  //$Id$
3  //gen openMairie le 10/02/2011 20:36  //gen openMairie le 10/02/2011 20:36
4  include('../gen/sql/pgsql/terrain.inc.php');  include('../gen/sql/pgsql/terrain.inc.php');
5  $table="terrain left join parcelle on terrain.parcelle=parcelle.parcelle";  $table=DB_PREFIXE."terrain left join ".DB_PREFIXE."parcelle on terrain.parcelle=parcelle.parcelle";
6  $champAffiche=array("terrain",  $champAffiche=array("terrain",
7                      "terrain.parcelle",                      "terrain.parcelle",
8                      "nom as proprietaire",                      "nom as proprietaire",
9                      "parcelle.surface");                      "parcelle.surface");
10  $champRecherche=array("parcelle.parcelle");  $champRecherche=array("parcelle.parcelle");
11  if(isset($idx))  if(isset($idx))
12    $selection=" where dossier ='".$idx."'";    $selection=" where terrain.dossier ='".$idx."'";
13  else  else
14    $selection="";    $selection="";
15  $tri= " order by parcelle";  $tri= " order by parcelle";
Legend:
Removed from v.20  
changed lines
  Added in v.461
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26