sql/pgsql/consultation.inc.php

<?php
//$Id$ 
//gen openMairie le 10/02/2011 20:32 
include('../gen/sql/pgsql/consultation.inc.php');
$table=DB_PREFIXE."consultation inner join ".DB_PREFIXE."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']= "<span class=\"om-icon om-icon-16 om-icon-fix pdf-16\" title=\"".
                    _("Edition")."\">"._("Edition")."</span>";

// 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	242	$table=DB_PREFIXE."consultation inner join ".DB_PREFIXE."service on consultation.service=service.service";
6	fraynaud	20	$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	fraynaud	116	$href[3]['lib']= "<span class=\"om-icon om-icon-16 om-icon-fix pdf-16\" title=\"".
25			_("Edition")."\">"._("Edition")."</span>";
26	fraynaud	38
27			// probleme lies a la gestion par nature
28
29			if ($retourformulaire== 'service'){
30			$href[0] = array("lien" => "#", "id" => "", "lib" => "", );
31			$href[1] = array("lien" => "", "id" => "", "lib" => "", );
32			$href[2] = array("lien" => "#", "id" => "", "lib" => "", );
33			$selection=" where consultation.service ='".$idx."'";
34			}
35
36	fraynaud	3	?>