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

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

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1124 - (hide annotations)
Thu Dec 27 09:32:24 2012 UTC (12 years, 1 month ago) by vpihour
File size: 2825 byte(s)
Modification des requêtes SQL faisaint appelles à action dans transition

1 fraynaud 3 <?php
2     //$Id$
3     //gen openMairie le 10/02/2011 20:34
4     include('../gen/sql/pgsql/instruction.form.inc.php');
5 fraynaud 242 $tableSelect=DB_PREFIXE."instruction inner join ".DB_PREFIXE."evenement on instruction.evenement=evenement.evenement";
6 fraynaud 20 $champs=array("instruction",
7     "destinataire",
8     "instruction.evenement",
9     "libelle",
10     "datecourrier",
11     "instruction.lettretype",
12     "complement",
13     "'' as bible_auto",
14     "'' as bible",
15     "complement2",
16     "'' as bible2",
17     "complement3",
18     "'' as bible3",
19     "complement4",
20     "'' as bible4",
21     "complement5",
22     "'' as bible5",
23     "complement6",
24     "'' as bible6",
25     "complement7",
26     "'' as bible7",
27     "complement8",
28     "'' as bible8",
29     "complement9",
30     "'' as bible9",
31     "complement10",
32     "'' as bible10",
33     "complement11",
34     "'' as bible11",
35     "dossier",
36     "instruction.action",
37     "instruction.delai",
38     "instruction.etat",
39     "instruction.accord_tacite",
40     "instruction.delai_notification",
41 vpihour 489 "instruction.avis_decision",
42 fraynaud 20 "archive_delai",
43     "archive_accord_tacite",
44     "archive_etat",
45     "archive_avis",
46     "archive_date_complet",
47     "archive_date_rejet",
48     "archive_date_limite",
49     "archive_date_notification_delai",
50     "archive_date_decision",
51     "archive_date_validite",
52     "archive_date_achevement",
53     "archive_date_conformite",
54     "archive_date_chantier",
55 nhaye 428 "complement12",
56     "complement13",
57     "complement14",
58     "complement15"
59 fraynaud 20 );
60 vpihour 1124 $sql_transition = "select evenement.evenement,(libelle||' ['||evenement.action||']') as lib
61     from ".DB_PREFIXE."evenement inner join ".DB_PREFIXE."transition on evenement.evenement = transition.evenement";
62    
63    
64     $sql_transition_by_id = "select evenement.evenement,(libelle||' ['||evenement.action||']') as lib
65     from ".DB_PREFIXE."evenement inner join ".DB_PREFIXE."transition on evenement.evenement = transition.evenement
66 nhaye 428 where evenement=<idx>";
67 fraynaud 46
68 nhaye 428 $portlet_actions['pdfetat'] =
69     array('lien' => "../app/pdflettretype_instruction.php?idx=",
70     'id' => '&obj=dossier',
71     'lib' => "<span class=\"om-prev-icon om-icon-16 pdf-16\" title=\"".
72     _("Edition")."\">"._("Edition")."</span>",
73 nhaye 469 'ordre' => 30,
74     'ajax' => false);
75 fraynaud 3 ?>

[email protected]
ViewVC Help
Powered by ViewVC 1.1.26