sql/pgsql/consultation.inc

<?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	<?php
2	//$Id$
3	//gen openMairie le 10/02/2011 20:32
4	include('../gen/sql/pgsql/consultation.inc.php');
5	$table=DB_PREFIXE."consultation inner join ".DB_PREFIXE."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
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
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	?>