| 1 |
<?php |
| 2 |
//$Id: instruction.form.inc.php 5188 2015-09-23 12:55:01Z nhaye $ |
| 3 |
//gen openMairie le 10/02/2011 20:34 |
| 4 |
include('../gen/sql/pgsql/instruction.form.inc.php'); |
| 5 |
$champs=array("instruction", |
| 6 |
"destinataire", |
| 7 |
"instruction.evenement", |
| 8 |
"date_evenement", |
| 9 |
"instruction.lettretype", |
| 10 |
"om_final_instruction_utilisateur", |
| 11 |
"date_finalisation_courrier", |
| 12 |
"date_envoi_signature", |
| 13 |
"date_envoi_rar", |
| 14 |
"date_envoi_controle_legalite", |
| 15 |
"signataire_arrete", |
| 16 |
|
| 17 |
"date_retour_signature", |
| 18 |
"date_retour_rar", |
| 19 |
"date_retour_controle_legalite", |
| 20 |
|
| 21 |
"numero_arrete", |
| 22 |
|
| 23 |
"complement_om_html", |
| 24 |
"'' as bible_auto", |
| 25 |
"'' as bible", |
| 26 |
"complement2_om_html", |
| 27 |
"'' as bible2", |
| 28 |
"complement3_om_html", |
| 29 |
"'' as bible3", |
| 30 |
"complement4_om_html", |
| 31 |
"'' as bible4", |
| 32 |
"complement5_om_html", |
| 33 |
"'' as bible5", |
| 34 |
"complement6_om_html", |
| 35 |
"'' as bible6", |
| 36 |
"complement7_om_html", |
| 37 |
"'' as bible7", |
| 38 |
"complement8_om_html", |
| 39 |
"'' as bible8", |
| 40 |
"complement9_om_html", |
| 41 |
"'' as bible9", |
| 42 |
"complement10_om_html", |
| 43 |
"'' as bible10", |
| 44 |
"complement11_om_html", |
| 45 |
"'' as bible11", |
| 46 |
"dossier", |
| 47 |
"instruction.action", |
| 48 |
"instruction.delai", |
| 49 |
"instruction.etat", |
| 50 |
"instruction.autorite_competente", |
| 51 |
"instruction.accord_tacite", |
| 52 |
"instruction.delai_notification", |
| 53 |
"instruction.avis_decision", |
| 54 |
"archive_delai", |
| 55 |
"archive_accord_tacite", |
| 56 |
"archive_etat", |
| 57 |
"archive_avis", |
| 58 |
"archive_date_complet", |
| 59 |
"archive_date_rejet", |
| 60 |
"archive_date_limite", |
| 61 |
"archive_date_notification_delai", |
| 62 |
"archive_date_decision", |
| 63 |
"archive_date_validite", |
| 64 |
"archive_date_achevement", |
| 65 |
"archive_date_conformite", |
| 66 |
"archive_date_chantier", |
| 67 |
"archive_date_dernier_depot", |
| 68 |
"date_depot", |
| 69 |
"complement12_om_html", |
| 70 |
"complement13_om_html", |
| 71 |
"complement14_om_html", |
| 72 |
"complement15_om_html", |
| 73 |
"archive_incompletude", |
| 74 |
"archive_incomplet_notifie", |
| 75 |
"archive_evenement_suivant_tacite", |
| 76 |
"archive_evenement_suivant_tacite_incompletude", |
| 77 |
"archive_etat_pendant_incompletude", |
| 78 |
"archive_date_limite_incompletude", |
| 79 |
"archive_delai_incompletude", |
| 80 |
"archive_autorite_competente", |
| 81 |
"code_barres", |
| 82 |
"om_fichier_instruction", |
| 83 |
"om_final_instruction", |
| 84 |
"document_numerise", |
| 85 |
"duree_validite_parametrage", |
| 86 |
"duree_validite", |
| 87 |
"created_by_commune", |
| 88 |
); |
| 89 |
|
| 90 |
// signataire |
| 91 |
$sql_signataire_arrete = "SELECT |
| 92 |
signataire_arrete.signataire_arrete, |
| 93 |
CONCAT(signataire_arrete.prenom, ' ', signataire_arrete.nom) |
| 94 |
FROM ".DB_PREFIXE."signataire_arrete |
| 95 |
WHERE ((signataire_arrete.om_validite_debut IS NULL AND (signataire_arrete.om_validite_fin IS NULL OR signataire_arrete.om_validite_fin > CURRENT_DATE)) OR (signataire_arrete.om_validite_debut <= CURRENT_DATE AND (signataire_arrete.om_validite_fin IS NULL OR signataire_arrete.om_validite_fin > CURRENT_DATE))) |
| 96 |
ORDER BY signataire_arrete.prenom, signataire_arrete.nom"; |
| 97 |
$sql_signataire_arrete_by_id = "SELECT |
| 98 |
signataire_arrete.signataire_arrete, |
| 99 |
CONCAT(signataire_arrete.prenom, ' ', signataire_arrete.nom) |
| 100 |
FROM ".DB_PREFIXE."signataire_arrete |
| 101 |
WHERE signataire_arrete.signataire_arrete = <idx>"; |
| 102 |
// |
| 103 |
$sql_signataire_arrete_by_di = "SELECT |
| 104 |
signataire_arrete.signataire_arrete, |
| 105 |
CONCAT(signataire_arrete.prenom, ' ', signataire_arrete.nom) |
| 106 |
FROM ".DB_PREFIXE."signataire_arrete |
| 107 |
LEFT JOIN ".DB_PREFIXE."om_collectivite ON signataire_arrete.om_collectivite = om_collectivite.om_collectivite |
| 108 |
WHERE ((signataire_arrete.om_validite_debut IS NULL AND (signataire_arrete.om_validite_fin IS NULL OR signataire_arrete.om_validite_fin > CURRENT_DATE)) OR (signataire_arrete.om_validite_debut <= CURRENT_DATE AND (signataire_arrete.om_validite_fin IS NULL OR signataire_arrete.om_validite_fin > CURRENT_DATE))) |
| 109 |
AND (om_collectivite.niveau = '2' OR signataire_arrete.om_collectivite = <collectivite_di>) |
| 110 |
ORDER BY signataire_arrete.prenom, signataire_arrete.nom"; |
| 111 |
// |
| 112 |
$sql_signataire_arrete_defaut = "SELECT |
| 113 |
signataire_arrete.signataire_arrete, |
| 114 |
CONCAT(signataire_arrete.prenom, ' ', signataire_arrete.nom) |
| 115 |
FROM ".DB_PREFIXE."signataire_arrete |
| 116 |
WHERE ((signataire_arrete.om_validite_debut IS NULL AND (signataire_arrete.om_validite_fin IS NULL OR signataire_arrete.om_validite_fin > CURRENT_DATE)) OR (signataire_arrete.om_validite_debut <= CURRENT_DATE AND (signataire_arrete.om_validite_fin IS NULL OR signataire_arrete.om_validite_fin > CURRENT_DATE))) AND signataire_arrete.defaut IS TRUE |
| 117 |
ORDER BY signataire_arrete.prenom, signataire_arrete.nom"; |
| 118 |
// |
| 119 |
$sql_signataire_arrete_defaut_by_di = "SELECT |
| 120 |
signataire_arrete.signataire_arrete, |
| 121 |
CONCAT(signataire_arrete.prenom, ' ', signataire_arrete.nom) |
| 122 |
FROM ".DB_PREFIXE."signataire_arrete |
| 123 |
LEFT JOIN ".DB_PREFIXE."om_collectivite ON signataire_arrete.om_collectivite = om_collectivite.om_collectivite |
| 124 |
WHERE ((signataire_arrete.om_validite_debut IS NULL AND (signataire_arrete.om_validite_fin IS NULL OR signataire_arrete.om_validite_fin > CURRENT_DATE)) OR (signataire_arrete.om_validite_debut <= CURRENT_DATE AND (signataire_arrete.om_validite_fin IS NULL OR signataire_arrete.om_validite_fin > CURRENT_DATE))) AND signataire_arrete.defaut IS TRUE |
| 125 |
AND (om_collectivite.niveau = '2' OR signataire_arrete.om_collectivite = <collectivite_di>) |
| 126 |
ORDER BY signataire_arrete.prenom, signataire_arrete.nom"; |
| 127 |
|
| 128 |
?> |
Parent Directory
| 
Revision Log