sql/pgsql/PC.inc.php

<?php
//$Id: PC.inc,v 1.4 2010-08-22 21:40:12 fraynaud Exp $
include('../gen/sql/pgsql/dossier.inc.php');
if(isset($idx))
     if($idx != "]")
        $ent = "dossier -> ".$idx;
     else
        $ent= "dossier -> PC";
else
    $ent= "dossier -> PC";
$ico = "../img/ico_dossier.png";
$edition="";
$table=DB_PREFIXE."dossier left join ".
       DB_PREFIXE."om_utilisateur on dossier.instructeur = om_utilisateur.om_utilisateur left join ".
       DB_PREFIXE."avis on avis.avis=dossier.avis";
$champAffiche=array("dossier",
                    "om_utilisateur.nom as instructeur",
                    "demandeur_nom as nom",
                    "to_char(date_demande,'DD/MM/YYYY')  as demande",
                    "to_char(date_depot,'DD/MM/YYYY') as depot",
                    "to_char(date_complet,'DD/MM/YYYY') as  complet",
                    "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 = 'PC'";

$sousformulaire=array("instruction",
                    "consultation",
                    "terrain",
                    "blocnote",
                    "destination_shon",
                    "modificatif");


$href[3]['lien'] = "../pdf/pdfetat.php?idx=";
$href[3]['id']= "&obj=dossier";
$href[3]['lib']= "<img src='../img/ico_pdf.png' border=0>";

$href[4]['lien'] = "../app/dossier.php?id=";
$href[4]['id']= "&menu=1";
$href[4]['lib']= "<img src='../app/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='../app/img/sig.png' border=0>"; 
?>
1	fraynaud	11	<?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	fraynaud	29	DB_PREFIXE."om_utilisateur on dossier.instructeur = om_utilisateur.om_utilisateur left join ".
15	fraynaud	11	DB_PREFIXE."avis on avis.avis=dossier.avis";
16			$champAffiche=array("dossier",
17	fraynaud	29	"om_utilisateur.nom as instructeur",
18	fraynaud	78	"demandeur_nom as nom",
19			"to_char(date_demande,'DD/MM/YYYY') as demande",
20			"to_char(date_depot,'DD/MM/YYYY') as depot",
21			"to_char(date_complet,'DD/MM/YYYY') as complet",
22			"to_char(date_notification_delai,'DD/MM/YYYY') as delai",
23			"to_char(date_limite,'DD/MM/YYYY') as limite",
24	fraynaud	11	"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	fraynaud	90	$href[4]['lien'] = "../app/dossier.php?id=";
43	fraynaud	20	$href[4]['id']= "&menu=1";
44	fraynaud	103	$href[4]['lib']= "<img src='../app/img/ico_exemplaire.png' border=0>";
45	fraynaud	11
46	fraynaud	68	$href[5]['lien'] = "../scr/tab_sig_point.php?idx=";
47	fraynaud	11	$href[5]['id']= "&obj=dossier";
48	fraynaud	103	$href[5]['lib']= "<img src='../app/img/sig.png' border=0>";
49	fraynaud	11	?>