2 |
//$Id$ |
//$Id$ |
3 |
//gen openMairie le 10/02/2011 20:32 |
//gen openMairie le 10/02/2011 20:32 |
4 |
include('../gen/sql/pgsql/consultation.inc.php'); |
include('../gen/sql/pgsql/consultation.inc.php'); |
5 |
|
$table=DB_PREFIXE."consultation inner join ".DB_PREFIXE."service on consultation.service=service.service"; |
6 |
|
$champAffiche=array("consultation", |
7 |
|
"consultation.service", |
8 |
|
"libelle", |
9 |
|
"to_char(date_envoi,'DD/MM/YYYY') as date_envoi", |
10 |
|
"to_char(date_retour,'DD/MM/YYYY') as date_retour", |
11 |
|
"to_char(date_limite,'DD/MM/YYYY') as date_limite", |
12 |
|
"avis"); |
13 |
|
$champRecherche=array("libelle"); |
14 |
|
if(isset($idx)) |
15 |
|
$selection=" where dossier ='".$idx."'"; |
16 |
|
else |
17 |
|
$selection=""; |
18 |
|
// ============================================================================= |
19 |
|
// href particulier pour edition d etat |
20 |
|
// ============================================================================= |
21 |
|
|
22 |
|
$href[3]['lien'] = "../pdf/pdfetat.php?idx="; |
23 |
|
$href[3]['id']= "&obj=consultation"; |
24 |
|
$href[3]['lib']= "<span class=\"om-icon om-icon-16 om-icon-fix pdf-16\" title=\"". |
25 |
|
_("Edition")."\">"._("Edition")."</span>"; |
26 |
|
|
27 |
|
// probleme lies a la gestion par nature |
28 |
|
|
29 |
|
if ($retourformulaire== 'service'){ |
30 |
|
$href[0] = array("lien" => "#", "id" => "", "lib" => "", ); |
31 |
|
$href[1] = array("lien" => "", "id" => "", "lib" => "", ); |
32 |
|
$href[2] = array("lien" => "#", "id" => "", "lib" => "", ); |
33 |
|
$selection=" where consultation.service ='".$idx."'"; |
34 |
|
} |
35 |
|
|
36 |
?> |
?> |