1 |
<?php |
<?php |
2 |
//$Id$ |
/** |
3 |
//gen openMairie le 10/02/2011 20:33 |
* |
4 |
include('../gen/sql/pgsql/evenement.inc.php'); |
* |
5 |
$sousformulaire=array('bible'); |
* @package openfoncier |
6 |
|
* @version SVN : $Id$ |
7 |
|
*/ |
8 |
|
|
9 |
|
// |
10 |
|
include "../gen/sql/pgsql/evenement.inc.php"; |
11 |
|
|
12 |
|
// |
13 |
|
$sousformulaire = array('bible'); |
14 |
|
|
15 |
|
|
16 |
|
// SELECT |
17 |
|
$champAffiche = array( |
18 |
|
'evenement.evenement as "'._("id").'"', |
19 |
|
'evenement.libelle as "'._("libelle").'"', |
20 |
|
'action.libelle as "'._("action").'"', |
21 |
|
|
22 |
|
"trim(concat( |
23 |
|
case |
24 |
|
when etat.libelle<>'' |
25 |
|
then concat('"._("etat")." : ', etat.libelle, '<br/>') |
26 |
|
else '' |
27 |
|
end, |
28 |
|
case |
29 |
|
when evenement.delai<>0 |
30 |
|
then concat('"._("delai")." : ', evenement.delai, '<br/>') |
31 |
|
else '' |
32 |
|
end, |
33 |
|
case |
34 |
|
when evenement.delai_notification<>0 |
35 |
|
then concat('"._("delai_notification")." : ', evenement.delai_notification, '<br/>') |
36 |
|
else '' |
37 |
|
end, |
38 |
|
case |
39 |
|
when avis_decision.libelle<>'' |
40 |
|
then concat('"._("avis_decision")." : ', avis_decision.libelle, '<br/>') |
41 |
|
else '' |
42 |
|
end, |
43 |
|
concat('"._("accord_tacite")." : ', evenement.accord_tacite, '<br/>'), |
44 |
|
'')) |
45 |
|
AS \""._("parametres")."\"", |
46 |
|
|
47 |
|
'evenement.lettretype as "'._("lettretype").'"', |
48 |
|
'evenement.type as "'._("type").'"', |
49 |
|
); |
50 |
|
|
51 |
|
// |
52 |
|
$champRecherche = array( |
53 |
|
'evenement.evenement as "'._("id").'"', |
54 |
|
'evenement.libelle as "'._("libelle").'"', |
55 |
|
'action.libelle as "'._("action").'"', |
56 |
|
'etat.libelle as "'._("etat").'"', |
57 |
|
'evenement.delai as "'._("delai").'"', |
58 |
|
'evenement.accord_tacite as "'._("accord_tacite").'"', |
59 |
|
'evenement.delai_notification as "'._("delai_notification").'"', |
60 |
|
'evenement.lettretype as "'._("lettretype").'"', |
61 |
|
'evenement.consultation as "'._("consultation").'"', |
62 |
|
'avis_decision.libelle as "'._("avis_decision").'"', |
63 |
|
'evenement.restriction as "'._("restriction").'"', |
64 |
|
'evenement.type as "'._("type").'"', |
65 |
|
'evenement3.libelle as "'._("evenement_retour_ar").'"', |
66 |
|
'evenement4.libelle as "'._("evenement_suivant_tacite").'"', |
67 |
|
); |
68 |
|
|
69 |
|
// |
70 |
$href[3] = array( |
$href[3] = array( |
71 |
"lien" => "../app/valid_copie.php?obj=".$obj."&objsf=bible&idx=", |
"lien" => "../app/valid_copie.php?obj=".$obj."&objsf=bible&idx=", |
72 |
"id" => "", |
"id" => "", |
73 |
"lib" => "<span class=\"om-icon om-icon-16 om-icon-fix copy-16\" title=\""._("Copier")."\">"._("Copier")."</span>", |
"lib" => "<span class=\"om-icon om-icon-16 om-icon-fix copy-16\" title=\""._("Copier")."\">"._("Copier")."</span>", |
74 |
); |
); |
|
?> |
|
75 |
|
|
76 |
|
?> |