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="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 avis ='' and date_limite > '".date('Y-m-d')."'" ;

       $href[0]['lien']= "";
 //      $href[0]['id']= "";
 //      $href[0]['lib']= "";
       $href[1]['lien'] = "form.php?obj=".$obj."&idx=";
       $href[1]['id'] = "&premier=".$premier."&recherche=".$recherche1;
       $href[1]['lib'] = "";
       $href[2]['lien'] = "form.php?obj=".$obj."&idx=";
       $href[2]['id'] = "&ids=1&premier=".$premier."&recherche=".$recherche1;
       $href[2]['lib'] = "<img src='../img/supprimer.gif' border='0'>";
       $href[3]['lien'] = "../pdf/pdfetat.php?idx=";
       $href[3]['id']= "&obj=consultation";
       $href[3]['lib']= "<img src='../img/ico_pdf.png' border=0>";

?>
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			$selection=" where avis ='' and date_limite > '".date('Y-m-d')."'" ;
21
22			$href[0]['lien']= "";
23			// $href[0]['id']= "";
24			// $href[0]['lib']= "";
25			$href[1]['lien'] = "form.php?obj=".$obj."&idx=";
26			$href[1]['id'] = "&premier=".$premier."&recherche=".$recherche1;
27			$href[1]['lib'] = "";
28			$href[2]['lien'] = "form.php?obj=".$obj."&idx=";
29			$href[2]['id'] = "&ids=1&premier=".$premier."&recherche=".$recherche1;
30			$href[2]['lib'] = "<img src='../img/supprimer.gif' border='0'>";
31			$href[3]['lien'] = "../pdf/pdfetat.php?idx=";
32			$href[3]['id']= "&obj=consultation";
33			$href[3]['lib']= "<img src='../img/ico_pdf.png' border=0>";
34
35			?>