/[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 1571 - (hide annotations)
Thu Mar 28 12:22:00 2013 UTC (11 years, 10 months ago) by nhaye
File size: 3069 byte(s)
Ajout du champ date_dernier_depot à la table dossier + régénération
Ajouter un champ regle_date_dernier_depot à la table action,
Ajouter un champ archive_date_dernier_depot à la table instruction,
reproduire le fonctionnement de la gestion de la date de complétude.
La date de dernier dépôt = date demande lors du dépôt initial.

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 20 $champs=array("instruction",
6     "destinataire",
7     "instruction.evenement",
8 vpihour 1127 "date_evenement",
9 fraynaud 20 "instruction.lettretype",
10 nhaye 1439 "date_finalisation_courrier",
11     "date_envoi_signature",
12     "date_envoi_rar",
13     "date_envoi_controle_legalite",
14 fmichon 1540 "signataire_arrete",
15 nhaye 1439
16     "date_retour_signature",
17     "date_retour_rar",
18     "date_retour_controle_legalite",
19    
20     "numero_arrete",
21    
22 fraynaud 20 "complement",
23     "'' as bible_auto",
24     "'' as bible",
25     "complement2",
26     "'' as bible2",
27     "complement3",
28     "'' as bible3",
29     "complement4",
30     "'' as bible4",
31     "complement5",
32     "'' as bible5",
33     "complement6",
34     "'' as bible6",
35     "complement7",
36     "'' as bible7",
37     "complement8",
38     "'' as bible8",
39     "complement9",
40     "'' as bible9",
41     "complement10",
42     "'' as bible10",
43     "complement11",
44     "'' as bible11",
45     "dossier",
46     "instruction.action",
47     "instruction.delai",
48     "instruction.etat",
49     "instruction.accord_tacite",
50     "instruction.delai_notification",
51 vpihour 489 "instruction.avis_decision",
52 fraynaud 20 "archive_delai",
53     "archive_accord_tacite",
54     "archive_etat",
55     "archive_avis",
56     "archive_date_complet",
57     "archive_date_rejet",
58     "archive_date_limite",
59     "archive_date_notification_delai",
60     "archive_date_decision",
61     "archive_date_validite",
62     "archive_date_achevement",
63     "archive_date_conformite",
64     "archive_date_chantier",
65 nhaye 1571 "archive_date_dernier_depot",
66 vpihour 1129 "complement12",
67     "complement13",
68     "complement14",
69 nhaye 1439 "complement15"
70 fraynaud 20 );
71 fraynaud 46
72 fmichon 1540 // signataire
73     $sql_signataire_arrete = "SELECT
74     signataire_arrete.signataire_arrete,
75     CONCAT(signataire_arrete.prenom, ' ', signataire_arrete.nom)
76     FROM ".DB_PREFIXE."signataire_arrete";
77     $sql_signataire_arrete_by_id = "SELECT
78     signataire_arrete.signataire_arrete,
79     CONCAT(signataire_arrete.prenom, ' ', signataire_arrete.nom)
80     FROM ".DB_PREFIXE."signataire_arrete
81     WHERE signataire_arrete.signataire_arrete = <idx>";
82    
83     // action contextuelle
84 nhaye 428 $portlet_actions['pdfetat'] =
85 fmichon 1363 array('lien' => "../app/pdf_instruction.php?idx=",
86     'id' => '',
87 nhaye 428 'lib' => "<span class=\"om-prev-icon om-icon-16 pdf-16\" title=\"".
88     _("Edition")."\">"._("Edition")."</span>",
89 fmichon 1363 'target' => '_blank',
90 nhaye 469 'ordre' => 30,
91     'ajax' => false);
92 fmichon 1540
93     ?>

[email protected]
ViewVC Help
Powered by ViewVC 1.1.26