/[openfoncier]/branches/2.x/sql/mysql/PC.inc
ViewVC logotype

Contents of /branches/2.x/sql/mysql/PC.inc

Parent Directory Parent Directory | Revision Log Revision Log


Revision 2 - (show annotations)
Tue Feb 8 10:07:21 2011 UTC (13 years, 11 months ago) by fmichon
File size: 2708 byte(s)
Import de la version 2.x d'openfoncier anciennement sous CVS

1 <?php
2 //$Id: PC.inc,v 1.20 2010-07-30 08:19:50 fraynaud Exp $
3 $DEBUG=0;
4 $serie=15;
5 if(isset($idx))
6 if($idx != "]")
7 $ent = "dossier -> ".$idx;
8 else
9 $ent= "dossier -> PC";
10 else
11 $ent= "dossier -> PC";
12 $ico = "../img/ico_dossier.png";
13 $edition="";
14 //
15 $table="dossier left join utilisateur on dossier.instructeur = utilisateur.idutilisateur left join avis on avis.avis=dossier.avis";
16 //$table="dossier";
17 $champAffiche=array("dossier",
18 "utilisateur.nom as 'instructeur'",
19 "demandeur_nom",
20 "concat(substring(date_demande,9,2),'/',substring(date_demande,6,2),'/',substring(date_demande,1,4)) as date_demande",
21 "concat(substring(date_depot,9,2),'/',substring(date_depot,6,2),'/',substring(date_depot,1,4)) as date_depot",
22 "concat(substring(date_complet,9,2),'/',substring(date_complet,6,2),'/',substring(date_complet,1,4)) as date_complet",
23 "concat(substring(date_notification_delai,9,2),'/',substring(date_notification_delai,6,2),'/',substring(date_notification_delai,1,4)) as date_notification_delai",
24 "concat(substring(date_limite,9,2),'/',substring(date_limite,6,2),'/',substring(date_limite,1,4)) as date_limite",
25 "etat","pos","sig","avis.libelle as avis"
26 );
27 $champRecherche=array("dossier","demandeur_nom");
28 $tri= "order by dossier.dossier";
29 $selection=" where nature = 'PC'";
30 //if($_SESSION['profil']<4)
31 // $selection=$selection." and utilisateur.nom ='".$_SESSION['nom']."'";
32 // sous formulaire
33 $sousformulaire=array("instruction","consultation","terrain","blocnote","destination_shon","modificatif");
34 $sousformulaire_class="sousformulaire_profil";
35 $soustab="onglets_profil";
36 // permis modificatif et transfert de permis
37 $href[0]['lien'] = "form.php?obj=".$obj;
38 $href[0]['id'] = "";
39 $href[0]['lib'] = "<img src='../img/ajouter.gif' border='0'>";
40
41 $href[1]['lien'] = "form.php?obj=".$obj."&idx=";
42 $href[1]['id'] = "&premier=".$premier."&recherche=".$recherche1;
43 $href[1]['lib'] = "";
44
45 $href[2]['lien'] = "form.php?obj=".$obj."&idx=";
46 $href[2]['id'] = "&ids=1&premier=".$premier."&recherche=".$recherche1;
47 $href[2]['lib'] = "<img src='../img/supprimer.gif' border='0'>";
48
49 $href[3]['lien'] = "../pdf/pdfetat.php?idx=";
50 $href[3]['id']= "&obj=dossier";
51 $href[3]['lib']= "<img src='../img/ico_pdf.png' border=0>";
52
53 $href[4]['lien'] = "../scr/dossier.php?id=";
54 $href[4]['id']= " target=_blanck";
55 $href[4]['lib']= "<img src='../img/ico_exemplaire.png' border=0>";
56
57 ?>

[email protected]
ViewVC Help
Powered by ViewVC 1.1.26