sql/pgsql/consultation_retour.inc.php

<?php
//$Id: consultation_retour.inc,v 1.2 2010-07-28 10:58:48 fraynaud Exp $
$DEBUG=0;
$serie=15;
$ent = "retour -> consultation";
$ico = "../img/ico_dossier.png";
$edition="";
//
$table=DB_PREFIXE."consultation inner join ".DB_PREFIXE."service on consultation.service=service.service";
$champAffiche=array("consultation",
                    "consultation.service",
                    "dossier",
                    "libelle",
                    "to_char(date_envoi,'DD/MM/YYYY') as date_envoi",
                    "to_char(date_retour,'DD/MM/YYYY') as date_retour",
                    "to_char(date_limite,'DD/MM/YYYY') as date_limite",
                   "avis_consultation");
$champRecherche=array("dossier");
$tri= "";
$selection=" where date_limite > '".date('Y-m-d')."' and avis_consultation is null" ;

$href[3]['lien'] = "../pdf/pdfetat.php?idx=";
$href[3]['id']= "&obj=consultation";
$href[3]['lib']= "<span class=\"om-icon om-icon-16 om-icon-fix pdf-16\" title=\"".
                    _("Edition")."\">"._("Edition")."</span>";
?>
1	<?php
2	//$Id: consultation_retour.inc,v 1.2 2010-07-28 10:58:48 fraynaud Exp $
3	$DEBUG=0;
4	$serie=15;
5	$ent = "retour -> consultation";
6	$ico = "../img/ico_dossier.png";
7	$edition="";
8	//
9	$table=DB_PREFIXE."consultation inner join ".DB_PREFIXE."service on consultation.service=service.service";
10	$champAffiche=array("consultation",
11	"consultation.service",
12	"dossier",
13	"libelle",
14	"to_char(date_envoi,'DD/MM/YYYY') as date_envoi",
15	"to_char(date_retour,'DD/MM/YYYY') as date_retour",
16	"to_char(date_limite,'DD/MM/YYYY') as date_limite",
17	"avis_consultation");
18	$champRecherche=array("dossier");
19	$tri= "";
20	$selection=" where date_limite > '".date('Y-m-d')."' and avis_consultation is null" ;
21
22	$href[3]['lien'] = "../pdf/pdfetat.php?idx=";
23	$href[3]['id']= "&obj=consultation";
24	$href[3]['lib']= "<span class=\"om-icon om-icon-16 om-icon-fix pdf-16\" title=\"".
25	_("Edition")."\">"._("Edition")."</span>";
26	?>