sql/pgsql/consultation.inc.php

<?php
//$Id$ 
//gen openMairie le 10/02/2011 20:32 
include('../gen/sql/pgsql/consultation.inc.php');
$table="consultation inner join service on consultation.service=service.service";
$champAffiche=array("consultation",
                    "consultation.service",
                    "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("libelle");
if(isset($idx))
  $selection=" where dossier ='".$idx."'";
else
  $selection="";
// =============================================================================
// href particulier pour edition d etat
// =============================================================================

$href[3]['lien'] = "../pdf/pdfetat.php?idx=";
$href[3]['id']= "&obj=consultation";
$href[3]['lib']= "<img src='../img/ico_pdf.png' border=0>";

// probleme lies a la gestion par nature

if ($retourformulaire== 'service'){
    $href[0] = array("lien" => "#", "id" => "", "lib" => "", );
    $href[1] = array("lien" => "", "id" => "", "lib" => "", );
    $href[2] = array("lien" => "#", "id" => "", "lib" => "", );
    $selection=" where consultation.service ='".$idx."'";
}

?>
1	fraynaud	3	<?php
2			//$Id$
3			//gen openMairie le 10/02/2011 20:32
4			include('../gen/sql/pgsql/consultation.inc.php');
5	fraynaud	20	$table="consultation inner join service on consultation.service=service.service";
6			$champAffiche=array("consultation",
7			"consultation.service",
8			"libelle",
9			"to_char(date_envoi,'DD/MM/YYYY') as date_envoi",
10			"to_char(date_retour,'DD/MM/YYYY') as date_retour",
11			"to_char(date_limite,'DD/MM/YYYY') as date_limite",
12			"avis");
13			$champRecherche=array("libelle");
14			if(isset($idx))
15			$selection=" where dossier ='".$idx."'";
16			else
17			$selection="";
18			// =============================================================================
19			// href particulier pour edition d etat
20			// =============================================================================
21	fraynaud	38
22			$href[3]['lien'] = "../pdf/pdfetat.php?idx=";
23			$href[3]['id']= "&obj=consultation";
24			$href[3]['lib']= "<img src='../img/ico_pdf.png' border=0>";
25
26			// probleme lies a la gestion par nature
27
28			if ($retourformulaire== 'service'){
29			$href[0] = array("lien" => "#", "id" => "", "lib" => "", );
30			$href[1] = array("lien" => "", "id" => "", "lib" => "", );
31			$href[2] = array("lien" => "#", "id" => "", "lib" => "", );
32			$selection=" where consultation.service ='".$idx."'";
33			}
34
35	fraynaud	3	?>