/[openfoncier]/trunk/sql/pgsql/PC.inc
ViewVC logotype

Contents of /trunk/sql/pgsql/PC.inc

Parent Directory Parent Directory | Revision Log Revision Log


Revision 11 - (show annotations)
Mon Feb 28 20:15:19 2011 UTC (13 years, 11 months ago) by fraynaud
File size: 1820 byte(s)
trs om 4.00



1 <?php
2 //$Id: PC.inc,v 1.4 2010-08-22 21:40:12 fraynaud Exp $
3 include('../gen/sql/pgsql/dossier.inc.php');
4 if(isset($idx))
5 if($idx != "]")
6 $ent = "dossier -> ".$idx;
7 else
8 $ent= "dossier -> PC";
9 else
10 $ent= "dossier -> PC";
11 $ico = "../img/ico_dossier.png";
12 $edition="";
13 $table=DB_PREFIXE."dossier left join ".
14 DB_PREFIXE."utilisateur on dossier.instructeur = utilisateur.idutilisateur left join ".
15 DB_PREFIXE."avis on avis.avis=dossier.avis";
16 $champAffiche=array("dossier",
17 "utilisateur.nom as instructeur",
18 "demandeur_nom",
19 "to_char(date_demande,'DD/MM/YYYY') as date_demande",
20 "to_char(date_depot,'DD/MM/YYYY') as date_depot",
21 "to_char(date_complet,'DD/MM/YYYY') as date_complet",
22 "to_char(date_notification_delai,'DD/MM/YYYY') as date_notification_delai",
23 "to_char(date_limite,'DD/MM/YYYY') as date_limite",
24 "etat","avis.libelle as avis"
25 );
26 $champRecherche=array("dossier","demandeur_nom");
27 $tri= "order by dossier.dossier";
28 $selection=" where nature = 'PC'";
29
30 $sousformulaire=array("instruction",
31 "consultation",
32 "terrain",
33 "blocnote",
34 "destination_shon",
35 "modificatif");
36
37
38 $href[3]['lien'] = "../pdf/pdfetat.php?idx=";
39 $href[3]['id']= "&obj=dossier";
40 $href[3]['lib']= "<img src='../img/ico_pdf.png' border=0>";
41
42 $href[4]['lien'] = "../scr/dossier.php?id=";
43 $href[4]['id']= " target=_blanck";
44 $href[4]['lib']= "<img src='../img/ico_exemplaire.png' border=0>";
45
46 $href[5]['lien'] = "../sig/tab_sig?idx=";
47 $href[5]['id']= "&obj=dossier";
48 $href[5]['lib']= "<img src='../img/sig.png' border=0>";
49 ?>

[email protected]
ViewVC Help
Powered by ViewVC 1.1.26