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

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

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1075 - (show annotations)
Mon Dec 17 15:15:45 2012 UTC (12 years, 1 month ago) by vpihour
File size: 2866 byte(s)
Validité xHTML du code

1 <?php
2 //$Id$
3 //gen openMairie le 08/11/2012 14:00
4
5 include('../gen/sql/pgsql/demande.form.inc.php');
6
7 /*Modification des requête générées*/
8 $sql_lien_demande_demandeur = "SELECT petitionnaire_principal,
9 demandeur,
10 demande
11 FROM ".DB_PREFIXE."lien_demande_demandeur
12 WHERE demande = <demande>";
13
14 $sql_infos_dossier = "SELECT
15 dossier_autorisation.dossier_autorisation,
16 dossier_autorisation.dossier_autorisation_type_detaille,
17 dossier_autorisation.depot_initial,
18 dossier_autorisation.terrain_references_cadastrales,
19 dossier_autorisation.terrain_adresse_voie_numero,
20 dossier_autorisation.complement,
21 dossier_autorisation.terrain_adresse_lieu_dit,
22 dossier_autorisation.terrain_adresse_localite,
23 dossier_autorisation.terrain_adresse_code_postal,
24 dossier_autorisation.terrain_adresse_bp,
25 dossier_autorisation.terrain_adresse_cedex,
26 dossier_autorisation.terrain_superficie
27 FROM ".DB_PREFIXE."dossier_autorisation
28 INNER JOIN ".DB_PREFIXE."dossier
29 ON dossier_autorisation.dossier_autorisation=dossier.dossier_autorisation
30 WHERE dossier = '<idx>'";
31
32 $sql_demande_type_details_by_id = "SELECT demande_type.demande_type, demande_type.libelle,
33 demande_type.dossier_autorisation_type_detaille,
34 demande_type. dossier_instruction_type
35 FROM ".DB_PREFIXE."demande_type WHERE demande_type = <idx>";
36
37 /*Paramétrage des actions du portlet*/
38 $portlet_actions['modifier'] = array('lien' => "form.php?obj=demande&amp;action=1&amp;idx=",
39 'id' => "&amp;premier=0&amp;advs_id=&amp;recherche=&amp;tricol=-0&amp;selectioncol=&amp;valide=&amp;retour=form",
40 'lib' => "<span class=\"om-prev-icon om-icon-16 edit-16\" title=\"".
41 _("Modifier")."\">"._("Modifier")."</span>",
42 'ordre' => 28,
43 'rights' => array('list' => array("demande", "demande_modifier"), 'operator' => 'OR'),
44 'ajax' => false);
45
46 $portlet_actions['supprimer'] = array('lien' => "form.php?obj=demande&amp;action=2&amp;idx=",
47 'id' => "&amp;premier=0&amp;advs_id=&amp;recherche=&amp;tricol=-0&amp;selectioncol=&amp;valide=&amp;retour=form",
48 'lib' => "<span class=\"om-prev-icon om-icon-16 delete-16\" title=\"".
49 _("Supprimer")."\">"._("Supprimer")."</span>",
50 'ordre' => 28,
51 'rights' => array('list' => array("demande", "demande_supprimer"), 'operator' => 'OR'),
52 'ajax' => false);
53
54 $portlet_actions['pdfetat'] =
55 array('lien' => "../app/pdf_recepisse_demande.php?idx=",
56 'id' => "&amp;obj=demande",
57 'lib' => "<span class=\"om-prev-icon om-icon-16 om-icon-fix pdf-16\" title=\"".
58 _("Edition")."\">"._("Editer le recepisse PDF")."</span>",
59 'ordre' => 30,
60 'ajax' => false);
61 ?>

[email protected]
ViewVC Help
Powered by ViewVC 1.1.26