sql/pgsql/instruction.inc.php

<?php
//$Id$ 
//gen openMairie le 08/08/2013 15:24

$DEBUG=0;
$serie=15;
$ico="../img/ico_application.png";
$ent = _("application")." -> "._("instruction");
if(!isset($premier)) $premier='';
if(!isset($recherche1)) $recherche1='';
if(!isset($tricolsf)) $tricolsf='';
if(!isset($premiersf)) $premiersf='';
if(!isset($selection)) $selection='';
if(!isset($retourformulaire)) $retourformulaire='';
if (isset($idx) && $idx != ']' && trim($idx) != '') {
    $ent .= "->&nbsp;".$idx."&nbsp;";
}
if (isset($idz) && trim($idz) != '') {
    $ent .= "&nbsp;".strtoupper($idz)."&nbsp;";
}
// FROM 
$table = DB_PREFIXE."instruction
    LEFT JOIN ".DB_PREFIXE."action 
        ON instruction.action=action.action 
    LEFT JOIN ".DB_PREFIXE."etat as etat1 
        ON instruction.archive_etat_pendant_incompletude=etat1.etat 
    LEFT JOIN ".DB_PREFIXE."evenement as evenement2 
        ON instruction.archive_evenement_suivant_tacite=evenement2.evenement 
    LEFT JOIN ".DB_PREFIXE."evenement as evenement3 
        ON instruction.archive_evenement_suivant_tacite_incompletude=evenement3.evenement 
    LEFT JOIN ".DB_PREFIXE."autorite_competente 
        ON instruction.autorite_competente=autorite_competente.autorite_competente 
    LEFT JOIN ".DB_PREFIXE."avis_decision 
        ON instruction.avis_decision=avis_decision.avis_decision 
    LEFT JOIN ".DB_PREFIXE."document_numerise 
        ON instruction.document_numerise=document_numerise.document_numerise 
    LEFT JOIN ".DB_PREFIXE."dossier 
        ON instruction.dossier=dossier.dossier 
    LEFT JOIN ".DB_PREFIXE."etat as etat8 
        ON instruction.etat=etat8.etat 
    LEFT JOIN ".DB_PREFIXE."evenement as evenement9 
        ON instruction.evenement=evenement9.evenement 
    LEFT JOIN ".DB_PREFIXE."signataire_arrete 
        ON instruction.signataire_arrete=signataire_arrete.signataire_arrete ";
// SELECT 
$champAffiche = array(
    'instruction.instruction as "'._("instruction").'"',
    'instruction.destinataire as "'._("destinataire").'"',
    'to_char(instruction.date_evenement ,\'DD/MM/YYYY\') as "'._("date_evenement").'"',
    'evenement9.libelle as "'._("evenement").'"',
    'instruction.lettretype as "'._("lettretype").'"',
    'dossier.annee as "'._("dossier").'"',
    'action.libelle as "'._("action").'"',
    'instruction.delai as "'._("delai").'"',
    'etat8.libelle as "'._("etat").'"',
    'instruction.accord_tacite as "'._("accord_tacite").'"',
    'instruction.delai_notification as "'._("delai_notification").'"',
    'instruction.archive_delai as "'._("archive_delai").'"',
    'to_char(instruction.archive_date_complet ,\'DD/MM/YYYY\') as "'._("archive_date_complet").'"',
    'to_char(instruction.archive_date_rejet ,\'DD/MM/YYYY\') as "'._("archive_date_rejet").'"',
    'to_char(instruction.archive_date_limite ,\'DD/MM/YYYY\') as "'._("archive_date_limite").'"',
    'to_char(instruction.archive_date_notification_delai ,\'DD/MM/YYYY\') as "'._("archive_date_notification_delai").'"',
    'instruction.archive_accord_tacite as "'._("archive_accord_tacite").'"',
    'instruction.archive_etat as "'._("archive_etat").'"',
    'to_char(instruction.archive_date_decision ,\'DD/MM/YYYY\') as "'._("archive_date_decision").'"',
    'instruction.archive_avis as "'._("archive_avis").'"',
    'to_char(instruction.archive_date_validite ,\'DD/MM/YYYY\') as "'._("archive_date_validite").'"',
    'to_char(instruction.archive_date_achevement ,\'DD/MM/YYYY\') as "'._("archive_date_achevement").'"',
    'to_char(instruction.archive_date_chantier ,\'DD/MM/YYYY\') as "'._("archive_date_chantier").'"',
    'to_char(instruction.archive_date_conformite ,\'DD/MM/YYYY\') as "'._("archive_date_conformite").'"',
    'avis_decision.libelle as "'._("avis_decision").'"',
    'to_char(instruction.date_finalisation_courrier ,\'DD/MM/YYYY\') as "'._("date_finalisation_courrier").'"',
    'to_char(instruction.date_envoi_signature ,\'DD/MM/YYYY\') as "'._("date_envoi_signature").'"',
    'to_char(instruction.date_retour_signature ,\'DD/MM/YYYY\') as "'._("date_retour_signature").'"',
    'to_char(instruction.date_envoi_rar ,\'DD/MM/YYYY\') as "'._("date_envoi_rar").'"',
    'to_char(instruction.date_retour_rar ,\'DD/MM/YYYY\') as "'._("date_retour_rar").'"',
    'to_char(instruction.date_envoi_controle_legalite ,\'DD/MM/YYYY\') as "'._("date_envoi_controle_legalite").'"',
    'to_char(instruction.date_retour_controle_legalite ,\'DD/MM/YYYY\') as "'._("date_retour_controle_legalite").'"',
    'signataire_arrete.civilite as "'._("signataire_arrete").'"',
    'instruction.numero_arrete as "'._("numero_arrete").'"',
    'to_char(instruction.archive_date_dernier_depot ,\'DD/MM/YYYY\') as "'._("archive_date_dernier_depot").'"',
    "case instruction.archive_incompletude when 't' then 'Oui' else 'Non' end as \""._("archive_incompletude")."\"",
    'evenement2.libelle as "'._("archive_evenement_suivant_tacite").'"',
    'evenement3.libelle as "'._("archive_evenement_suivant_tacite_incompletude").'"',
    'etat1.libelle as "'._("archive_etat_pendant_incompletude").'"',
    'to_char(instruction.archive_date_limite_incompletude ,\'DD/MM/YYYY\') as "'._("archive_date_limite_incompletude").'"',
    'instruction.archive_delai_incompletude as "'._("archive_delai_incompletude").'"',
    'instruction.code_barres as "'._("code_barres").'"',
    'instruction.om_fichier_instruction as "'._("om_fichier_instruction").'"',
    "case instruction.om_final_instruction when 't' then 'Oui' else 'Non' end as \""._("om_final_instruction")."\"",
    'document_numerise.uid as "'._("document_numerise").'"',
    'instruction.archive_autorite_competente as "'._("archive_autorite_competente").'"',
    'autorite_competente.libelle as "'._("autorite_competente").'"',
    'instruction.duree_validite_parametrage as "'._("duree_validite_parametrage").'"',
    'instruction.duree_validite as "'._("duree_validite").'"',
    );
//
$champNonAffiche = array(
    'instruction.complement as "'._("complement").'"',
    'instruction.complement2 as "'._("complement2").'"',
    'instruction.complement3 as "'._("complement3").'"',
    'instruction.complement4 as "'._("complement4").'"',
    'instruction.complement5 as "'._("complement5").'"',
    'instruction.complement6 as "'._("complement6").'"',
    'instruction.complement7 as "'._("complement7").'"',
    'instruction.complement8 as "'._("complement8").'"',
    'instruction.complement9 as "'._("complement9").'"',
    'instruction.complement10 as "'._("complement10").'"',
    'instruction.complement11 as "'._("complement11").'"',
    'instruction.complement12 as "'._("complement12").'"',
    'instruction.complement13 as "'._("complement13").'"',
    'instruction.complement14 as "'._("complement14").'"',
    'instruction.complement15 as "'._("complement15").'"',
    );
//
$champRecherche = array(
    'instruction.instruction as "'._("instruction").'"',
    'instruction.destinataire as "'._("destinataire").'"',
    'evenement9.libelle as "'._("evenement").'"',
    'instruction.lettretype as "'._("lettretype").'"',
    'dossier.annee as "'._("dossier").'"',
    'action.libelle as "'._("action").'"',
    'instruction.delai as "'._("delai").'"',
    'etat8.libelle as "'._("etat").'"',
    'instruction.accord_tacite as "'._("accord_tacite").'"',
    'instruction.delai_notification as "'._("delai_notification").'"',
    'instruction.archive_delai as "'._("archive_delai").'"',
    'instruction.archive_accord_tacite as "'._("archive_accord_tacite").'"',
    'instruction.archive_etat as "'._("archive_etat").'"',
    'instruction.archive_avis as "'._("archive_avis").'"',
    'avis_decision.libelle as "'._("avis_decision").'"',
    'signataire_arrete.civilite as "'._("signataire_arrete").'"',
    'instruction.numero_arrete as "'._("numero_arrete").'"',
    'evenement2.libelle as "'._("archive_evenement_suivant_tacite").'"',
    'evenement3.libelle as "'._("archive_evenement_suivant_tacite_incompletude").'"',
    'etat1.libelle as "'._("archive_etat_pendant_incompletude").'"',
    'instruction.archive_delai_incompletude as "'._("archive_delai_incompletude").'"',
    'instruction.code_barres as "'._("code_barres").'"',
    'instruction.om_fichier_instruction as "'._("om_fichier_instruction").'"',
    'document_numerise.uid as "'._("document_numerise").'"',
    'instruction.archive_autorite_competente as "'._("archive_autorite_competente").'"',
    'autorite_competente.libelle as "'._("autorite_competente").'"',
    'instruction.duree_validite_parametrage as "'._("duree_validite_parametrage").'"',
    'instruction.duree_validite as "'._("duree_validite").'"',
    );
$tri="ORDER BY instruction.destinataire ASC NULLS LAST";
$edition="instruction";
$selection='';
if ($retourformulaire== 'action') {
    $selection=" WHERE (instruction.action ='".$idx."')";
}
if ($retourformulaire== 'etat') {
    $selection=" WHERE (instruction.archive_etat_pendant_incompletude ='".$idx."' OR instruction.etat ='".$idx."')";
}
if ($retourformulaire== 'evenement') {
    $selection=" WHERE (instruction.archive_evenement_suivant_tacite ='".$idx."' OR instruction.archive_evenement_suivant_tacite_incompletude ='".$idx."' OR instruction.evenement ='".$idx."')";
}
if ($retourformulaire== 'autorite_competente') {
    $selection=" WHERE (instruction.autorite_competente ='".$idx."')";
}
if ($retourformulaire== 'avis_decision') {
    $selection=" WHERE (instruction.avis_decision ='".$idx."')";
}
if ($retourformulaire== 'document_numerise') {
    $selection=" WHERE (instruction.document_numerise ='".$idx."')";
}
if ($retourformulaire== 'dossier') {
    $selection=" WHERE (instruction.dossier ='".$idx."')";
}
if ($retourformulaire== 'signataire_arrete') {
    $selection=" WHERE (instruction.signataire_arrete ='".$idx."')";
}
$sousformulaire = array(
    'demande',);
?>
1	<?php
2	//$Id$
3	//gen openMairie le 08/08/2013 15:24
4
5	$DEBUG=0;
6	$serie=15;
7	$ico="../img/ico_application.png";
8	$ent = _("application")." -> "._("instruction");
9	if(!isset($premier)) $premier='';
10	if(!isset($recherche1)) $recherche1='';
11	if(!isset($tricolsf)) $tricolsf='';
12	if(!isset($premiersf)) $premiersf='';
13	if(!isset($selection)) $selection='';
14	if(!isset($retourformulaire)) $retourformulaire='';
15	if (isset($idx) && $idx != ']' && trim($idx) != '') {
16	$ent .= "-> ".$idx." ";
17	}
18	if (isset($idz) && trim($idz) != '') {
19	$ent .= " ".strtoupper($idz)." ";
20	}
21	// FROM
22	$table = DB_PREFIXE."instruction
23	LEFT JOIN ".DB_PREFIXE."action
24	ON instruction.action=action.action
25	LEFT JOIN ".DB_PREFIXE."etat as etat1
26	ON instruction.archive_etat_pendant_incompletude=etat1.etat
27	LEFT JOIN ".DB_PREFIXE."evenement as evenement2
28	ON instruction.archive_evenement_suivant_tacite=evenement2.evenement
29	LEFT JOIN ".DB_PREFIXE."evenement as evenement3
30	ON instruction.archive_evenement_suivant_tacite_incompletude=evenement3.evenement
31	LEFT JOIN ".DB_PREFIXE."autorite_competente
32	ON instruction.autorite_competente=autorite_competente.autorite_competente
33	LEFT JOIN ".DB_PREFIXE."avis_decision
34	ON instruction.avis_decision=avis_decision.avis_decision
35	LEFT JOIN ".DB_PREFIXE."document_numerise
36	ON instruction.document_numerise=document_numerise.document_numerise
37	LEFT JOIN ".DB_PREFIXE."dossier
38	ON instruction.dossier=dossier.dossier
39	LEFT JOIN ".DB_PREFIXE."etat as etat8
40	ON instruction.etat=etat8.etat
41	LEFT JOIN ".DB_PREFIXE."evenement as evenement9
42	ON instruction.evenement=evenement9.evenement
43	LEFT JOIN ".DB_PREFIXE."signataire_arrete
44	ON instruction.signataire_arrete=signataire_arrete.signataire_arrete ";
45	// SELECT
46	$champAffiche = array(
47	'instruction.instruction as "'._("instruction").'"',
48	'instruction.destinataire as "'._("destinataire").'"',
49	'to_char(instruction.date_evenement ,\'DD/MM/YYYY\') as "'._("date_evenement").'"',
50	'evenement9.libelle as "'._("evenement").'"',
51	'instruction.lettretype as "'._("lettretype").'"',
52	'dossier.annee as "'._("dossier").'"',
53	'action.libelle as "'._("action").'"',
54	'instruction.delai as "'._("delai").'"',
55	'etat8.libelle as "'._("etat").'"',
56	'instruction.accord_tacite as "'._("accord_tacite").'"',
57	'instruction.delai_notification as "'._("delai_notification").'"',
58	'instruction.archive_delai as "'._("archive_delai").'"',
59	'to_char(instruction.archive_date_complet ,\'DD/MM/YYYY\') as "'._("archive_date_complet").'"',
60	'to_char(instruction.archive_date_rejet ,\'DD/MM/YYYY\') as "'._("archive_date_rejet").'"',
61	'to_char(instruction.archive_date_limite ,\'DD/MM/YYYY\') as "'._("archive_date_limite").'"',
62	'to_char(instruction.archive_date_notification_delai ,\'DD/MM/YYYY\') as "'._("archive_date_notification_delai").'"',
63	'instruction.archive_accord_tacite as "'._("archive_accord_tacite").'"',
64	'instruction.archive_etat as "'._("archive_etat").'"',
65	'to_char(instruction.archive_date_decision ,\'DD/MM/YYYY\') as "'._("archive_date_decision").'"',
66	'instruction.archive_avis as "'._("archive_avis").'"',
67	'to_char(instruction.archive_date_validite ,\'DD/MM/YYYY\') as "'._("archive_date_validite").'"',
68	'to_char(instruction.archive_date_achevement ,\'DD/MM/YYYY\') as "'._("archive_date_achevement").'"',
69	'to_char(instruction.archive_date_chantier ,\'DD/MM/YYYY\') as "'._("archive_date_chantier").'"',
70	'to_char(instruction.archive_date_conformite ,\'DD/MM/YYYY\') as "'._("archive_date_conformite").'"',
71	'avis_decision.libelle as "'._("avis_decision").'"',
72	'to_char(instruction.date_finalisation_courrier ,\'DD/MM/YYYY\') as "'._("date_finalisation_courrier").'"',
73	'to_char(instruction.date_envoi_signature ,\'DD/MM/YYYY\') as "'._("date_envoi_signature").'"',
74	'to_char(instruction.date_retour_signature ,\'DD/MM/YYYY\') as "'._("date_retour_signature").'"',
75	'to_char(instruction.date_envoi_rar ,\'DD/MM/YYYY\') as "'._("date_envoi_rar").'"',
76	'to_char(instruction.date_retour_rar ,\'DD/MM/YYYY\') as "'._("date_retour_rar").'"',
77	'to_char(instruction.date_envoi_controle_legalite ,\'DD/MM/YYYY\') as "'._("date_envoi_controle_legalite").'"',
78	'to_char(instruction.date_retour_controle_legalite ,\'DD/MM/YYYY\') as "'._("date_retour_controle_legalite").'"',
79	'signataire_arrete.civilite as "'._("signataire_arrete").'"',
80	'instruction.numero_arrete as "'._("numero_arrete").'"',
81	'to_char(instruction.archive_date_dernier_depot ,\'DD/MM/YYYY\') as "'._("archive_date_dernier_depot").'"',
82	"case instruction.archive_incompletude when 't' then 'Oui' else 'Non' end as \""._("archive_incompletude")."\"",
83	'evenement2.libelle as "'._("archive_evenement_suivant_tacite").'"',
84	'evenement3.libelle as "'._("archive_evenement_suivant_tacite_incompletude").'"',
85	'etat1.libelle as "'._("archive_etat_pendant_incompletude").'"',
86	'to_char(instruction.archive_date_limite_incompletude ,\'DD/MM/YYYY\') as "'._("archive_date_limite_incompletude").'"',
87	'instruction.archive_delai_incompletude as "'._("archive_delai_incompletude").'"',
88	'instruction.code_barres as "'._("code_barres").'"',
89	'instruction.om_fichier_instruction as "'._("om_fichier_instruction").'"',
90	"case instruction.om_final_instruction when 't' then 'Oui' else 'Non' end as \""._("om_final_instruction")."\"",
91	'document_numerise.uid as "'._("document_numerise").'"',
92	'instruction.archive_autorite_competente as "'._("archive_autorite_competente").'"',
93	'autorite_competente.libelle as "'._("autorite_competente").'"',
94	'instruction.duree_validite_parametrage as "'._("duree_validite_parametrage").'"',
95	'instruction.duree_validite as "'._("duree_validite").'"',
96	);
97	//
98	$champNonAffiche = array(
99	'instruction.complement as "'._("complement").'"',
100	'instruction.complement2 as "'._("complement2").'"',
101	'instruction.complement3 as "'._("complement3").'"',
102	'instruction.complement4 as "'._("complement4").'"',
103	'instruction.complement5 as "'._("complement5").'"',
104	'instruction.complement6 as "'._("complement6").'"',
105	'instruction.complement7 as "'._("complement7").'"',
106	'instruction.complement8 as "'._("complement8").'"',
107	'instruction.complement9 as "'._("complement9").'"',
108	'instruction.complement10 as "'._("complement10").'"',
109	'instruction.complement11 as "'._("complement11").'"',
110	'instruction.complement12 as "'._("complement12").'"',
111	'instruction.complement13 as "'._("complement13").'"',
112	'instruction.complement14 as "'._("complement14").'"',
113	'instruction.complement15 as "'._("complement15").'"',
114	);
115	//
116	$champRecherche = array(
117	'instruction.instruction as "'._("instruction").'"',
118	'instruction.destinataire as "'._("destinataire").'"',
119	'evenement9.libelle as "'._("evenement").'"',
120	'instruction.lettretype as "'._("lettretype").'"',
121	'dossier.annee as "'._("dossier").'"',
122	'action.libelle as "'._("action").'"',
123	'instruction.delai as "'._("delai").'"',
124	'etat8.libelle as "'._("etat").'"',
125	'instruction.accord_tacite as "'._("accord_tacite").'"',
126	'instruction.delai_notification as "'._("delai_notification").'"',
127	'instruction.archive_delai as "'._("archive_delai").'"',
128	'instruction.archive_accord_tacite as "'._("archive_accord_tacite").'"',
129	'instruction.archive_etat as "'._("archive_etat").'"',
130	'instruction.archive_avis as "'._("archive_avis").'"',
131	'avis_decision.libelle as "'._("avis_decision").'"',
132	'signataire_arrete.civilite as "'._("signataire_arrete").'"',
133	'instruction.numero_arrete as "'._("numero_arrete").'"',
134	'evenement2.libelle as "'._("archive_evenement_suivant_tacite").'"',
135	'evenement3.libelle as "'._("archive_evenement_suivant_tacite_incompletude").'"',
136	'etat1.libelle as "'._("archive_etat_pendant_incompletude").'"',
137	'instruction.archive_delai_incompletude as "'._("archive_delai_incompletude").'"',
138	'instruction.code_barres as "'._("code_barres").'"',
139	'instruction.om_fichier_instruction as "'._("om_fichier_instruction").'"',
140	'document_numerise.uid as "'._("document_numerise").'"',
141	'instruction.archive_autorite_competente as "'._("archive_autorite_competente").'"',
142	'autorite_competente.libelle as "'._("autorite_competente").'"',
143	'instruction.duree_validite_parametrage as "'._("duree_validite_parametrage").'"',
144	'instruction.duree_validite as "'._("duree_validite").'"',
145	);
146	$tri="ORDER BY instruction.destinataire ASC NULLS LAST";
147	$edition="instruction";
148	$selection='';
149	if ($retourformulaire== 'action') {
150	$selection=" WHERE (instruction.action ='".$idx."')";
151	}
152	if ($retourformulaire== 'etat') {
153	$selection=" WHERE (instruction.archive_etat_pendant_incompletude ='".$idx."' OR instruction.etat ='".$idx."')";
154	}
155	if ($retourformulaire== 'evenement') {
156	$selection=" WHERE (instruction.archive_evenement_suivant_tacite ='".$idx."' OR instruction.archive_evenement_suivant_tacite_incompletude ='".$idx."' OR instruction.evenement ='".$idx."')";
157	}
158	if ($retourformulaire== 'autorite_competente') {
159	$selection=" WHERE (instruction.autorite_competente ='".$idx."')";
160	}
161	if ($retourformulaire== 'avis_decision') {
162	$selection=" WHERE (instruction.avis_decision ='".$idx."')";
163	}
164	if ($retourformulaire== 'document_numerise') {
165	$selection=" WHERE (instruction.document_numerise ='".$idx."')";
166	}
167	if ($retourformulaire== 'dossier') {
168	$selection=" WHERE (instruction.dossier ='".$idx."')";
169	}
170	if ($retourformulaire== 'signataire_arrete') {
171	$selection=" WHERE (instruction.signataire_arrete ='".$idx."')";
172	}
173	$sousformulaire = array(
174	'demande',);
175	?>