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

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

Parent Directory Parent Directory | Revision Log Revision Log


Revision 440 - (hide annotations)
Tue Sep 25 14:30:46 2012 UTC (12 years, 4 months ago) by nhaye
File size: 1283 byte(s)
Régénération des table de sig suite à la maj du core

1 fraynaud 3 <?php
2     //$Id$
3     //gen openMairie le 10/02/2011 20:40
4     include('../gen/sql/pgsql/parcelle.form.inc.php');
5 nhaye 416
6 fraynaud 242 $sql_pos="select pos,(pos||' '||libelle) as lib from ".DB_PREFIXE."pos order by libelle";
7 nhaye 420 $sql_pos_by_id = "SELECT pos.pos, (pos.pos||' '||pos.libelle) FROM ".DB_PREFIXE."pos WHERE pos = '<idx>'";
8 fraynaud 242 $sql_proprietaire="select proprietaire,(nom||' '||prenom) as lib from ".DB_PREFIXE."proprietaire order by nom";
9 nhaye 420 $sql_proprietaire_by_id = "SELECT proprietaire.proprietaire, (proprietaire.nom||' '||proprietaire.prenom) as lib FROM ".DB_PREFIXE."proprietaire WHERE proprietaire = '<idx>'";
10 fraynaud 242 $sql_rivoli="select rivoli,(rivoli||' '||libelle) as lib from ".DB_PREFIXE."rivoli order by libelle";
11 nhaye 420 $sql_rivoli_by_id = "SELECT rivoli.rivoli, (rivoli.rivoli||' '||rivoli.libelle) as lib FROM ".DB_PREFIXE."rivoli WHERE rivoli = '<idx>'";
12 nhaye 416
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 nhaye 440
21     $portlet_actions['sig'] = array('lien' => '../scr/tab_sig.php?idx=',
22     'id' => '&obj=parcelle&geometrie=polygon&zoom=18',
23     'lib' => "<span class=\"om-prev-icon om-icon-16 sig-16\" title=\""._("Sig")."\">"._("Sig")."</span>",
24     'ordre' => 30,);
25    
26 fraynaud 3 ?>

[email protected]
ViewVC Help
Powered by ViewVC 1.1.26