1 |
fraynaud |
11 |
<?php |
2 |
|
|
//$Id: PA.inc,v 1.3 2010-07-30 08:19:50 fraynaud Exp $ |
3 |
|
|
include('../gen/sql/pgsql/dossier.inc.php'); |
4 |
|
|
$ent = "dossier -> PA"; |
5 |
|
|
$ico = "../img/ico_dossier.png"; |
6 |
|
|
$edition=""; |
7 |
|
|
$table=DB_PREFIXE."dossier left join ". |
8 |
fraynaud |
38 |
DB_PREFIXE."om_utilisateur on dossier.instructeur = om_utilisateur.om_utilisateur left join ". |
9 |
fraynaud |
11 |
DB_PREFIXE."avis on avis.avis=dossier.avis"; |
10 |
|
|
$champAffiche=array("dossier", |
11 |
fraynaud |
38 |
"om_utilisateur.nom as instructeur", |
12 |
fraynaud |
78 |
"demandeur_nom as nom", |
13 |
|
|
"to_char(date_demande,'DD/MM/YYYY') as demande", |
14 |
|
|
"to_char(date_depot,'DD/MM/YYYY') as depot", |
15 |
|
|
"to_char(date_complet,'DD/MM/YYYY') as complet", |
16 |
|
|
"to_char(date_notification_delai,'DD/MM/YYYY') as delai", |
17 |
|
|
"to_char(date_limite,'DD/MM/YYYY') as limite", |
18 |
fraynaud |
11 |
"etat","avis.libelle as avis" |
19 |
|
|
); |
20 |
|
|
$champRecherche=array("dossier","demandeur_nom"); |
21 |
|
|
$tri= "order by dossier.dossier"; |
22 |
|
|
$selection=" where nature = 'PA'"; |
23 |
|
|
// sous formulaire |
24 |
|
|
$sousformulaire=array("instruction", |
25 |
|
|
"consultation", |
26 |
|
|
"terrain", |
27 |
|
|
"blocnote", |
28 |
|
|
"destination_shon"); |
29 |
|
|
|
30 |
|
|
$href[3]['lien'] = "../pdf/pdfetat.php?idx="; |
31 |
|
|
$href[3]['id']= "&obj=dossier"; |
32 |
fraynaud |
107 |
$href[3]['lib']= "<img src='../app/img/ico_pdf.png' border=0>"; |
33 |
fraynaud |
11 |
|
34 |
fraynaud |
90 |
$href[4]['lien'] = "../app/dossier.php?id="; |
35 |
fraynaud |
107 |
$href[4]['id']= "&menu=1"; |
36 |
|
|
$href[4]['lib']= "<img src='../app/img/ico_exemplaire.png' border=0>"; |
37 |
fraynaud |
78 |
|
38 |
|
|
$href[5]['lien'] = "../scr/tab_sig_point.php?idx="; |
39 |
|
|
$href[5]['id']= "&obj=dossier"; |
40 |
fraynaud |
107 |
$href[5]['lib']= "<img src='../app/img/sig.png' border=0>"; |
41 |
fraynaud |
11 |
?> |