sql/pgsql/PD_accueil.inc.php

<?php
//$Id: PD_accueil.inc,v 1.2 2010-07-28 10:58:48 fraynaud Exp $
include('../gen/sql/pgsql/dossier.inc.php');
if(isset($idx))
    if($idx != "]"){
        $ent = "dossier -> ".$idx;
        if(isset($idz) ){
        if (trim($idz!=''))
            $ent = $ent."&nbsp;<font id='idz1'>&nbsp;".
                    strtoupper($idz)."&nbsp;</font>";
        }
    }else
        $ent= "dossier -> PD accueil";
else
    $ent= "dossier -> PD accueil";
$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_decision on avis_decision.avis_decision=dossier.avis_decision";
$champAffiche=array("dossier",
                    "demandeur_nom",
                    "to_char(date_demande,'DD/MM/YYYY')  as date_demande",
                    "to_char(date_depot,'DD/MM/YYYY') as date_depot",
                    "etat"
                    );
$champRecherche=array("dossier","demandeur_nom");
$selection=" where nature = 'PD' and (etat ='initialiser' or etat='notifier') ";
$tri="ORDER BY dossier ASC";

$sousformulaire=array("instruction");
?>
1	<?php
2	//$Id: PD_accueil.inc,v 1.2 2010-07-28 10:58:48 fraynaud Exp $
3	include('../gen/sql/pgsql/dossier.inc.php');
4	if(isset($idx))
5	if($idx != "]"){
6	$ent = "dossier -> ".$idx;
7	if(isset($idz) ){
8	if (trim($idz!=''))
9	$ent = $ent." <font id='idz1'> ".
10	strtoupper($idz)." </font>";
11	}
12	}else
13	$ent= "dossier -> PD accueil";
14	else
15	$ent= "dossier -> PD accueil";
16	$ico = "../img/ico_dossier.png";
17	$edition="";
18	$table=DB_PREFIXE."dossier left join ".
19	DB_PREFIXE."om_utilisateur on dossier.instructeur = om_utilisateur.om_utilisateur left join ".
20	DB_PREFIXE."avis_decision on avis_decision.avis_decision=dossier.avis_decision";
21	$champAffiche=array("dossier",
22	"demandeur_nom",
23	"to_char(date_demande,'DD/MM/YYYY') as date_demande",
24	"to_char(date_depot,'DD/MM/YYYY') as date_depot",
25	"etat"
26	);
27	$champRecherche=array("dossier","demandeur_nom");
28	$selection=" where nature = 'PD' and (etat ='initialiser' or etat='notifier') ";
29	$tri="ORDER BY dossier ASC";
30
31	$sousformulaire=array("instruction");
32	?>