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

Diff of /trunk/sql/pgsql/parcelle.form.inc.php

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

trunk/sql/pgsql/parcelle.form.inc revision 9 by fraynaud, Mon Feb 14 17:51:36 2011 UTC trunk/sql/pgsql/parcelle.form.inc.php revision 420 by nhaye, Fri Sep 21 15:13:36 2012 UTC
# Line 2  Line 2 
2  //$Id$  //$Id$
3  //gen openMairie le 10/02/2011 20:40  //gen openMairie le 10/02/2011 20:40
4  include('../gen/sql/pgsql/parcelle.form.inc.php');  include('../gen/sql/pgsql/parcelle.form.inc.php');
 $champs=array("parcelle",  
               "debut",  
               "rivoli",  
               "pos",  
               "proprietaire",  
               "surface"  
               );  
 $selection="";  
 $sql_pos="select pos,(pos||' '||libelle) as lib from pos order by libelle";  
 $sql_proprietaire="select proprietaire,(nom||' '||prenom) as lib from proprietaire order by nom";  
 $sql_rivoli="select rivoli,(rivoli||' '||libelle) as lib from rivoli order by libelle";  
5    
6    $sql_pos="select pos,(pos||' '||libelle) as lib from ".DB_PREFIXE."pos order by libelle";
7    $sql_pos_by_id = "SELECT pos.pos, (pos.pos||' '||pos.libelle) FROM ".DB_PREFIXE."pos WHERE pos = '<idx>'";
8    $sql_proprietaire="select proprietaire,(nom||' '||prenom) as lib from ".DB_PREFIXE."proprietaire order by nom";
9    $sql_proprietaire_by_id = "SELECT proprietaire.proprietaire, (proprietaire.nom||' '||proprietaire.prenom) as lib  FROM ".DB_PREFIXE."proprietaire WHERE proprietaire = '<idx>'";
10    $sql_rivoli="select rivoli,(rivoli||' '||libelle) as lib from ".DB_PREFIXE."rivoli order by libelle";
11    $sql_rivoli_by_id = "SELECT rivoli.rivoli, (rivoli.rivoli||' '||rivoli.libelle) as lib FROM ".DB_PREFIXE."rivoli WHERE rivoli = '<idx>'";
12    
13    if(file_exists ("../dyn/var.inc"))
14            include ("../dyn/var.inc");
15    
16    if($vue_parcelle==1){
17        $portlet_actions['modifier'] = NULL;
18        $portlet_actions['supprimer'] = NULL;
19    }
20  ?>  ?>
Legend:
Removed from v.9  
changed lines
  Added in v.420
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26