sql/pgsql/PA.inc

<?php
//$Id: PA.inc,v 1.3 2010-07-30 08:19:50 fraynaud Exp $
include('../gen/sql/pgsql/dossier.inc.php');
$ent = "dossier -> PA";
$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 = 'PA'";
// sous formulaire
$sousformulaire=array("instruction",
                      "consultation",
                      "terrain",
                      "blocnote",
                      "destination_shon");
        
$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=1";
$href[4]['lib']= "<img src='../app/img/ico_exemplaire.png' border='0' align='top'>";

$href[5]['lien'] = "../scr/tab_sig_point.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: PA.inc,v 1.3 2010-07-30 08:19:50 fraynaud Exp $
3			include('../gen/sql/pgsql/dossier.inc.php');
4			$ent = "dossier -> PA";
5			$ico = "../img/ico_dossier.png";
6			$edition="";
7			$table=DB_PREFIXE."dossier left join ".
8	fraynaud	38	DB_PREFIXE."om_utilisateur on dossier.instructeur = om_utilisateur.om_utilisateur left join ".
9	fraynaud	11	DB_PREFIXE."avis on avis.avis=dossier.avis";
10			$champAffiche=array("dossier",
11	fraynaud	38	"om_utilisateur.nom as instructeur",
12	fraynaud	78	"demandeur_nom as nom",
13			"to_char(date_demande,'DD/MM/YYYY') as demande",
14			"to_char(date_depot,'DD/MM/YYYY') as depot",
15			"to_char(date_complet,'DD/MM/YYYY') as complet",
16			"to_char(date_notification_delai,'DD/MM/YYYY') as delai",
17			"to_char(date_limite,'DD/MM/YYYY') as limite",
18	fraynaud	11	"etat","avis.libelle as avis"
19			);
20			$champRecherche=array("dossier","demandeur_nom");
21			$tri= "order by dossier.dossier";
22			$selection=" where nature = 'PA'";
23			// sous formulaire
24			$sousformulaire=array("instruction",
25			"consultation",
26			"terrain",
27			"blocnote",
28			"destination_shon");
29
30			$href[3]['lien'] = "../pdf/pdfetat.php?idx=";
31			$href[3]['id']= "&obj=dossier";
32	fraynaud	116	$href[3]['lib']= "<span class=\"om-icon om-icon-16 om-icon-fix pdf-16\" title=\""._("Edition")."\">"._("Edition")."</span>";
33	fraynaud	11
34	fraynaud	90	$href[4]['lien'] = "../app/dossier.php?id=";
35	fraynaud	107	$href[4]['id']= "&menu=1";
36	jbastide	150	$href[4]['lib']= "<img src='../app/img/ico_exemplaire.png' border='0' align='top'>";
37	fraynaud	78
38			$href[5]['lien'] = "../scr/tab_sig_point.php?idx=";
39			$href[5]['id']= "&obj=dossier";
40	jbastide	150	$href[5]['lib']= "<span class=\"om-icon om-icon-16 om-icon-fix sig-16\" title=\""._("Sig")."\">"._("Sig")."</span>";
41	fraynaud	11	?>