2 |
//$Id$ |
//$Id$ |
3 |
//gen openMairie le 10/02/2011 20:34 |
//gen openMairie le 10/02/2011 20:34 |
4 |
include('../gen/sql/pgsql/instruction.form.inc.php'); |
include('../gen/sql/pgsql/instruction.form.inc.php'); |
5 |
$tableSelect=DB_PREFIXE."instruction inner join ".DB_PREFIXE."evenement on instruction.evenement=evenement.evenement"; |
$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", |
$champs=array("instruction", |
8 |
"destinataire", |
"destinataire", |
9 |
"instruction.evenement", |
"instruction.evenement", |
57 |
"complement13", |
"complement13", |
58 |
"complement14", |
"complement14", |
59 |
"complement15" , |
"complement15" , |
60 |
|
"signataire_arrete.signataire_arrete", |
61 |
"date_finalisation_courrier", |
"date_finalisation_courrier", |
62 |
"date_envoi_signature", |
"date_envoi_signature", |
63 |
"date_retour_signature", |
"date_retour_signature", |
90 |
dossier.dossier_instruction_type=dossier_instruction_type.dossier_instruction_type |
dossier.dossier_instruction_type=dossier_instruction_type.dossier_instruction_type |
91 |
where evenement=<idx>"; |
where evenement=<idx>"; |
92 |
|
|
93 |
|
$sql_signataire_arrete="SELECT signataire_arrete.signataire_arrete, CONCAT(signataire_arrete.prenom, ' ', signataire_arrete.nom) FROM ".DB_PREFIXE."signataire_arrete"; |
94 |
|
$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>"; |
95 |
|
|
96 |
$portlet_actions['pdfetat'] = |
$portlet_actions['pdfetat'] = |
97 |
array('lien' => "../app/pdflettretype_instruction.php?idx=", |
array('lien' => "../app/pdflettretype_instruction.php?idx=", |
98 |
'id' => '&obj=dossier', |
'id' => '&obj=dossier', |