sql/pgsql/PC.inc.php

<?php
//$Id: PC.inc,v 1.4 2010-08-22 21:40:12 fraynaud Exp $
include('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 -> 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","demandeur_nom as nom",
                    "om_utilisateur.nom as instructeur",
                    "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",
                    "statistique",
                    "modificatif");


$href[3]['lien'] = "../pdf/pdfetat.php?idx=";
$href[3]['id']= "&obj=dossier";
$href[3]['lib']=  "<span class=\"om-icon om-icon-16 om-icon-fix pdf-16\" title=\""._("Edition")."\">"._("Edition")."</span>";

$href[4]['lien'] = "../app/dossier.php?id=";
$href[4]['id']= "&menu=2";
$href[4]['lib']= "<img src='../app/img/ico_exemplaire.png' border='0' align='top'>";

$href[5]['lien'] = "../scr/tab_sig.php?idx=";
$href[5]['id']= "&obj=dossier";
$href[5]['lib']= "<span class=\"om-icon om-icon-16 om-icon-fix sig-16\" title=\""._("Sig")."\">"._("Sig")."</span>"; 
?>
1	fraynaud	11	<?php
2			//$Id: PC.inc,v 1.4 2010-08-22 21:40:12 fraynaud Exp $
3	atreal	312	include('dossier.inc.php');
4	fraynaud	11	if(isset($idx))
5	fraynaud	196	if($idx != "]"){
6	fraynaud	11	$ent = "dossier -> ".$idx;
7	fraynaud	196	if(isset($idz) ){
8			if (trim($idz!=''))
9			$ent = $ent." <font id='idz1'> ".
10			strtoupper($idz)." </font>";
11			}
12			}else
13	fraynaud	11	$ent= "dossier -> PC";
14			else
15			$ent= "dossier -> PC";
16			$ico = "../img/ico_dossier.png";
17			$edition="";
18			$table=DB_PREFIXE."dossier left join ".
19	fraynaud	29	DB_PREFIXE."om_utilisateur on dossier.instructeur = om_utilisateur.om_utilisateur left join ".
20	fraynaud	11	DB_PREFIXE."avis on avis.avis=dossier.avis";
21	fraynaud	196	$champAffiche=array("dossier","demandeur_nom as nom",
22	fraynaud	29	"om_utilisateur.nom as instructeur",
23	fraynaud	78	"to_char(date_demande,'DD/MM/YYYY') as demande",
24			"to_char(date_depot,'DD/MM/YYYY') as depot",
25			"to_char(date_complet,'DD/MM/YYYY') as complet",
26			"to_char(date_notification_delai,'DD/MM/YYYY') as delai",
27			"to_char(date_limite,'DD/MM/YYYY') as limite",
28	fraynaud	11	"etat","avis.libelle as avis"
29			);
30			$champRecherche=array("dossier","demandeur_nom");
31			$tri= "order by dossier.dossier";
32			$selection=" where nature = 'PC'";
33
34			$sousformulaire=array("instruction",
35			"consultation",
36			"terrain",
37			"blocnote",
38			"destination_shon",
39	fraynaud	168	"statistique",
40	fraynaud	11	"modificatif");
41
42
43			$href[3]['lien'] = "../pdf/pdfetat.php?idx=";
44			$href[3]['id']= "&obj=dossier";
45	fraynaud	116	$href[3]['lib']= "<span class=\"om-icon om-icon-16 om-icon-fix pdf-16\" title=\""._("Edition")."\">"._("Edition")."</span>";
46	fraynaud	11
47	fraynaud	90	$href[4]['lien'] = "../app/dossier.php?id=";
48	jbastide	158	$href[4]['id']= "&menu=2";
49	jbastide	150	$href[4]['lib']= "<img src='../app/img/ico_exemplaire.png' border='0' align='top'>";
50	fraynaud	11
51	fraynaud	141	$href[5]['lien'] = "../scr/tab_sig.php?idx=";
52	fraynaud	11	$href[5]['id']= "&obj=dossier";
53	jbastide	150	$href[5]['lib']= "<span class=\"om-icon om-icon-16 om-icon-fix sig-16\" title=\""._("Sig")."\">"._("Sig")."</span>";
54	fraynaud	11	?>