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

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

Parent Directory Parent Directory | Revision Log Revision Log


Revision 440 - (show 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 <?php
2 //$Id$
3 //gen openMairie le 10/02/2011 20:40
4 include('../gen/sql/pgsql/parcelle.form.inc.php');
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
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 ?>

[email protected]
ViewVC Help
Powered by ViewVC 1.1.26