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