/[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 1129 - (hide annotations)
Thu Dec 27 15:23:56 2012 UTC (12 years, 1 month ago) by vpihour
File size: 3090 byte(s)
Ajout des champs manquants

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 vpihour 1127 "date_evenement",
11 fraynaud 20 "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 vpihour 1129 "complement12",
56     "complement13",
57     "complement14",
58     "complement15" ,
59     "date_finalisation_courrier",
60     "date_envoi_signature",
61     "date_retour_signature",
62     "date_envoi_rar",
63     "date_retour_rar",
64     "date_envoi_controle_legalite",
65     "date_retour_controle_legalite"
66 fraynaud 20 );
67 vpihour 1124 $sql_transition = "select evenement.evenement,(libelle||' ['||evenement.action||']') as lib
68     from ".DB_PREFIXE."evenement inner join ".DB_PREFIXE."transition on evenement.evenement = transition.evenement";
69    
70    
71     $sql_transition_by_id = "select evenement.evenement,(libelle||' ['||evenement.action||']') as lib
72     from ".DB_PREFIXE."evenement inner join ".DB_PREFIXE."transition on evenement.evenement = transition.evenement
73 nhaye 428 where evenement=<idx>";
74 fraynaud 46
75 nhaye 428 $portlet_actions['pdfetat'] =
76     array('lien' => "../app/pdflettretype_instruction.php?idx=",
77     'id' => '&obj=dossier',
78     'lib' => "<span class=\"om-prev-icon om-icon-16 pdf-16\" title=\"".
79     _("Edition")."\">"._("Edition")."</span>",
80 nhaye 469 'ordre' => 30,
81     'ajax' => false);
82 fraynaud 3 ?>

[email protected]
ViewVC Help
Powered by ViewVC 1.1.26