sql/pgsql/consultation_retour.inc

<?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="consultation inner join 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");
$champRecherche=array("dossier");
$tri= "";
$selection=" where date_limite > '".date('Y-m-d')."' and avis 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	fraynaud	25	<?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="consultation inner join 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");
18			$champRecherche=array("dossier");
19			$tri= "";
20	fraynaud	80	$selection=" where date_limite > '".date('Y-m-d')."' and avis is null" ;
21	fraynaud	25
22	fraynaud	154	$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	fraynaud	25	?>