sql/pgsql/instruction.form.inc.php

<?php
//$Id$ 
//gen openMairie le 10/02/2011 20:34 
include('../gen/sql/pgsql/instruction.form.inc.php');
$tableSelect=DB_PREFIXE."instruction inner join ".DB_PREFIXE."evenement on instruction.evenement=evenement.evenement";
$champs=array("instruction",
              "destinataire",
              "instruction.evenement",
              "libelle",
              "date_evenement",
              "instruction.lettretype",
              "complement",
              "'' as bible_auto",
              "'' as bible",
              "complement2",
              "'' as bible2",
              "complement3",
              "'' as bible3",
              "complement4",
              "'' as bible4",
              "complement5",
              "'' as bible5",
              "complement6",
              "'' as bible6",
              "complement7",
              "'' as bible7",
              "complement8",
              "'' as bible8",
              "complement9",
              "'' as bible9",
              "complement10",
              "'' as bible10",
              "complement11",
              "'' as bible11",
              "dossier",
              "instruction.action",
              "instruction.delai",
              "instruction.etat",
              "instruction.accord_tacite",
              "instruction.delai_notification",
              "instruction.avis_decision",
              "archive_delai",
              "archive_accord_tacite",
              "archive_etat",
              "archive_avis",
              "archive_date_complet",
              "archive_date_rejet",
              "archive_date_limite",
              "archive_date_notification_delai",
              "archive_date_decision",
              "archive_date_validite",
              "archive_date_achevement",
              "archive_date_conformite",
              "archive_date_chantier",
              "complement12",
              "complement13",
              "complement14",
              "complement15" ,
              "date_finalisation_courrier",
              "date_envoi_signature",
              "date_retour_signature",
              "date_envoi_rar",
              "date_retour_rar",
              "date_envoi_controle_legalite",
              "date_retour_controle_legalite",
              "date_finalisation_courrier",
              "date_envoi_signature", 
              "date_retour_signature", 
              "date_envoi_rar",
              "date_retour_rar", 
              "date_envoi_controle_legalite",
              "date_retour_controle_legalite"
              );
$sql_transition = "select evenement.evenement,(evenement.libelle||' ['||evenement.action||']') as lib
      from ".DB_PREFIXE."evenement
      inner join ".DB_PREFIXE."transition on evenement.evenement = transition.evenement
      INNER JOIN ".DB_PREFIXE."lien_dossier_instruction_type_evenement ON
            evenement.evenement=lien_dossier_instruction_type_evenement.evenement
        INNER JOIN ".DB_PREFIXE."dossier_instruction_type ON 
            lien_dossier_instruction_type_evenement.dossier_instruction_type =
            dossier_instruction_type.dossier_instruction_type
        INNER JOIN ".DB_PREFIXE."dossier ON
            dossier.dossier_instruction_type=dossier_instruction_type.dossier_instruction_type";
      
      
$sql_transition_by_id = "select evenement.evenement,(evenementlibelle||' ['||evenement.action||']') as lib
      from ".DB_PREFIXE."evenement
      inner join ".DB_PREFIXE."transition on evenement.evenement = transition.evenement
      INNER JOIN ".DB_PREFIXE."lien_dossier_instruction_type_evenement ON
            evenement.evenement=lien_dossier_instruction_type_evenement.evenement
        INNER JOIN ".DB_PREFIXE."dossier_instruction_type ON 
            lien_dossier_instruction_type_evenement.dossier_instruction_type =
            dossier_instruction_type.dossier_instruction_type
        INNER JOIN ".DB_PREFIXE."dossier ON
            dossier.dossier_instruction_type=dossier_instruction_type.dossier_instruction_type
          where evenement=<idx>";

$portlet_actions['pdfetat'] =
       array('lien' => "../app/pdflettretype_instruction.php?idx=",
              'id' => '&obj=dossier',
              'lib' => "<span class=\"om-prev-icon om-icon-16 pdf-16\" title=\"".
                        _("Edition")."\">"._("Edition")."</span>",
              'ordre' => 30,
              'ajax' => false);
?>
1	<?php
2	//$Id$
3	//gen openMairie le 10/02/2011 20:34
4	include('../gen/sql/pgsql/instruction.form.inc.php');
5	$tableSelect=DB_PREFIXE."instruction inner join ".DB_PREFIXE."evenement on instruction.evenement=evenement.evenement";
6	$champs=array("instruction",
7	"destinataire",
8	"instruction.evenement",
9	"libelle",
10	"date_evenement",
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	"instruction.avis_decision",
42	"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	"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	"date_finalisation_courrier",
67	"date_envoi_signature",
68	"date_retour_signature",
69	"date_envoi_rar",
70	"date_retour_rar",
71	"date_envoi_controle_legalite",
72	"date_retour_controle_legalite"
73	);
74	$sql_transition = "select evenement.evenement,(evenement.libelle\|\|' ['\|\|evenement.action\|\|']') as lib
75	from ".DB_PREFIXE."evenement
76	inner join ".DB_PREFIXE."transition on evenement.evenement = transition.evenement
77	INNER JOIN ".DB_PREFIXE."lien_dossier_instruction_type_evenement ON
78	evenement.evenement=lien_dossier_instruction_type_evenement.evenement
79	INNER JOIN ".DB_PREFIXE."dossier_instruction_type ON
80	lien_dossier_instruction_type_evenement.dossier_instruction_type =
81	dossier_instruction_type.dossier_instruction_type
82	INNER JOIN ".DB_PREFIXE."dossier ON
83	dossier.dossier_instruction_type=dossier_instruction_type.dossier_instruction_type";
84
85
86	$sql_transition_by_id = "select evenement.evenement,(evenementlibelle\|\|' ['\|\|evenement.action\|\|']') as lib
87	from ".DB_PREFIXE."evenement
88	inner join ".DB_PREFIXE."transition on evenement.evenement = transition.evenement
89	INNER JOIN ".DB_PREFIXE."lien_dossier_instruction_type_evenement ON
90	evenement.evenement=lien_dossier_instruction_type_evenement.evenement
91	INNER JOIN ".DB_PREFIXE."dossier_instruction_type ON
92	lien_dossier_instruction_type_evenement.dossier_instruction_type =
93	dossier_instruction_type.dossier_instruction_type
94	INNER JOIN ".DB_PREFIXE."dossier ON
95	dossier.dossier_instruction_type=dossier_instruction_type.dossier_instruction_type
96	where evenement=<idx>";
97
98	$portlet_actions['pdfetat'] =
99	array('lien' => "../app/pdflettretype_instruction.php?idx=",
100	'id' => '&obj=dossier',
101	'lib' => "<span class=\"om-prev-icon om-icon-16 pdf-16\" title=\"".
102	_("Edition")."\">"._("Edition")."</span>",
103	'ordre' => 30,
104	'ajax' => false);
105	?>