19 |
|
|
20 |
"numero_arrete", |
"numero_arrete", |
21 |
|
|
22 |
"complement", |
"complement_om_html", |
23 |
"'' as bible_auto", |
"'' as bible_auto", |
24 |
"'' as bible", |
"'' as bible", |
25 |
"complement2", |
"complement2_om_html", |
26 |
"'' as bible2", |
"'' as bible2", |
27 |
"complement3", |
"complement3_om_html", |
28 |
"'' as bible3", |
"'' as bible3", |
29 |
"complement4", |
"complement4_om_html", |
30 |
"'' as bible4", |
"'' as bible4", |
31 |
"complement5", |
"complement5_om_html", |
32 |
"'' as bible5", |
"'' as bible5", |
33 |
"complement6", |
"complement6_om_html", |
34 |
"'' as bible6", |
"'' as bible6", |
35 |
"complement7", |
"complement7_om_html", |
36 |
"'' as bible7", |
"'' as bible7", |
37 |
"complement8", |
"complement8_om_html", |
38 |
"'' as bible8", |
"'' as bible8", |
39 |
"complement9", |
"complement9_om_html", |
40 |
"'' as bible9", |
"'' as bible9", |
41 |
"complement10", |
"complement10_om_html", |
42 |
"'' as bible10", |
"'' as bible10", |
43 |
"complement11", |
"complement11_om_html", |
44 |
"'' as bible11", |
"'' as bible11", |
45 |
"dossier", |
"dossier", |
46 |
"instruction.action", |
"instruction.action", |
47 |
"instruction.delai", |
"instruction.delai", |
48 |
"instruction.etat", |
"instruction.etat", |
49 |
|
"instruction.autorite_competente", |
50 |
"instruction.accord_tacite", |
"instruction.accord_tacite", |
51 |
"instruction.delai_notification", |
"instruction.delai_notification", |
52 |
"instruction.avis_decision", |
"instruction.avis_decision", |
64 |
"archive_date_conformite", |
"archive_date_conformite", |
65 |
"archive_date_chantier", |
"archive_date_chantier", |
66 |
"archive_date_dernier_depot", |
"archive_date_dernier_depot", |
67 |
"complement12", |
"complement12_om_html", |
68 |
"complement13", |
"complement13_om_html", |
69 |
"complement14", |
"complement14_om_html", |
70 |
"complement15", |
"complement15_om_html", |
71 |
"archive_incompletude", |
"archive_incompletude", |
72 |
"archive_evenement_suivant_tacite", |
"archive_evenement_suivant_tacite", |
73 |
"archive_evenement_suivant_tacite_incompletude", |
"archive_evenement_suivant_tacite_incompletude", |
74 |
"archive_etat_pendant_incompletude", |
"archive_etat_pendant_incompletude", |
75 |
"archive_date_limite_incompletude", |
"archive_date_limite_incompletude", |
76 |
"archive_delai_incompletude", |
"archive_delai_incompletude", |
77 |
|
"archive_autorite_competente", |
78 |
"code_barres", |
"code_barres", |
79 |
"om_fichier_instruction", |
"om_fichier_instruction", |
80 |
"om_final_instruction", |
"om_final_instruction", |
81 |
"document_numerise" |
"document_numerise", |
82 |
|
"duree_validite_parametrage", |
83 |
|
"duree_validite", |
84 |
); |
); |
85 |
|
|
86 |
// signataire |
// signataire |
87 |
$sql_signataire_arrete = "SELECT |
$sql_signataire_arrete = "SELECT |
88 |
signataire_arrete.signataire_arrete, |
signataire_arrete.signataire_arrete, |
89 |
CONCAT(signataire_arrete.prenom, ' ', signataire_arrete.nom) |
CONCAT(signataire_arrete.prenom, ' ', signataire_arrete.nom) |
90 |
FROM ".DB_PREFIXE."signataire_arrete"; |
FROM ".DB_PREFIXE."signataire_arrete |
91 |
|
ORDER BY signataire_arrete.prenom, signataire_arrete.nom"; |
92 |
$sql_signataire_arrete_by_id = "SELECT |
$sql_signataire_arrete_by_id = "SELECT |
93 |
signataire_arrete.signataire_arrete, |
signataire_arrete.signataire_arrete, |
94 |
CONCAT(signataire_arrete.prenom, ' ', signataire_arrete.nom) |
CONCAT(signataire_arrete.prenom, ' ', signataire_arrete.nom) |