| 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 |
LEFT JOIN ".DB_PREFIXE."signataire_arrete ON instruction.signataire_arrete=signataire_arrete.signataire_arrete"; |
| 7 |
$champs=array("instruction", |
| 8 |
"destinataire", |
| 9 |
"instruction.evenement", |
| 10 |
"libelle", |
| 11 |
"date_evenement", |
| 12 |
"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 |
"instruction.avis_decision", |
| 43 |
"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 |
"complement12", |
| 57 |
"complement13", |
| 58 |
"complement14", |
| 59 |
"complement15" , |
| 60 |
"signataire_arrete.signataire_arrete", |
| 61 |
"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 |
"date_retour_controle_legalite", |
| 68 |
"numero_arrete" |
| 69 |
); |
| 70 |
$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 |
INNER JOIN ".DB_PREFIXE."dossier ON |
| 79 |
dossier.dossier_instruction_type=dossier_instruction_type.dossier_instruction_type"; |
| 80 |
|
| 81 |
|
| 82 |
$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 |
INNER JOIN ".DB_PREFIXE."dossier ON |
| 91 |
dossier.dossier_instruction_type=dossier_instruction_type.dossier_instruction_type |
| 92 |
where evenement=<idx>"; |
| 93 |
|
| 94 |
$sql_signataire_arrete="SELECT signataire_arrete.signataire_arrete, CONCAT(signataire_arrete.prenom, ' ', signataire_arrete.nom) FROM ".DB_PREFIXE."signataire_arrete"; |
| 95 |
$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 |
|
| 97 |
$portlet_actions['pdfetat'] = |
| 98 |
array('lien' => "../app/pdflettretype_instruction.php?idx=", |
| 99 |
'id' => '&obj=dossier', |
| 100 |
'lib' => "<span class=\"om-prev-icon om-icon-16 pdf-16\" title=\"". |
| 101 |
_("Edition")."\">"._("Edition")."</span>", |
| 102 |
'ordre' => 30, |
| 103 |
'ajax' => false); |
| 104 |
?> |
Parent Directory
| 
Revision Log