1 |
<?php |
<?php |
2 |
//$Id: PD.inc,v 1.3 2010-07-30 08:19:50 fraynaud Exp $ |
//$Id: PD.inc,v 1.3 2010-07-30 08:19:50 fraynaud Exp $ |
3 |
include('../gen/sql/pgsql/dossier.inc.php'); |
include('dossier.inc.php'); |
4 |
$ent = "dossier -> PD"; |
if(isset($idx)) |
5 |
$ico = "../img/ico_dossier.png"; |
if($idx != "]"){ |
6 |
$edition=""; |
$ent = "dossier -> ".$idx; |
7 |
$table=DB_PREFIXE."dossier left join ". |
if(isset($idz) ){ |
8 |
DB_PREFIXE."om_utilisateur on dossier.instructeur = om_utilisateur.om_utilisateur left join ". |
if (trim($idz!='')) |
9 |
DB_PREFIXE."avis on avis.avis=dossier.avis"; |
$ent = $ent." <font id='idz1'> ". |
10 |
$champAffiche=array("dossier", |
strtoupper($idz)." </font>"; |
11 |
"om_utilisateur.nom as instructeur", |
} |
12 |
"demandeur_nom as nom", |
}else |
13 |
"to_char(date_demande,'DD/MM/YYYY') as demande", |
$ent= "dossier -> PD"; |
14 |
"to_char(date_depot,'DD/MM/YYYY') as depot", |
else |
15 |
"to_char(date_complet,'DD/MM/YYYY') as complet", |
$ent= "dossier -> PD"; |
|
"to_char(date_notification_delai,'DD/MM/YYYY') as delai", |
|
|
"to_char(date_limite,'DD/MM/YYYY') as limite", |
|
|
"etat","avis.libelle as avis" |
|
|
); |
|
|
$champRecherche=array("dossier","demandeur_nom"); |
|
|
$tri= "order by dossier.dossier"; |
|
|
$selection=" where nature = 'PD'"; |
|
|
$sousformulaire=array("instruction", |
|
|
"consultation", |
|
|
"terrain", |
|
|
"blocnote"); |
|
|
|
|
|
$href[3]['lien'] = "../pdf/pdfetat.php?idx="; |
|
|
$href[3]['id']= "&obj=dossier"; |
|
|
$href[3]['lib']= "<img src='../img/ico_pdf.png' border=0>"; |
|
16 |
|
|
17 |
$href[4]['lien'] = "../app/dossier.php?id="; |
$selection=" where nature = 'PD'"; |
|
$href[4]['id']= " target=_blanck"; |
|
|
$href[4]['lib']= "<img src='../img/ico_exemplaire.png' border=0>"; |
|
|
|
|
|
$href[5]['lien'] = "../scr/tab_sig_point.php?idx="; |
|
|
$href[5]['id']= "&obj=dossier"; |
|
|
$href[5]['lib']= "<img src='../img/sig.png' border=0>"; |
|
18 |
?> |
?> |