sql/pgsql/consultation.form.inc.php

<?php
//$Id$ 
//gen openMairie le 10/02/2011 20:32 
include('../gen/sql/pgsql/consultation.form.inc.php');

$champs=array("consultation",
"dossier",
"service",
"to_char(consultation.date_envoi ,'DD/MM/YYYY') as \"date_envoi\"",
"to_char(consultation.date_reception ,'DD/MM/YYYY') as \"date_reception\"",
"to_char(consultation.date_limite ,'DD/MM/YYYY') as \"date_limite\"",
"to_char(consultation.date_retour ,'DD/MM/YYYY') as \"date_retour\"",
"avis_consultation",
"motivation",
"fichier",
"lu"
);

$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>";

// Action : Edition PDF
$portlet_actions['pdfetat'] =
    array('lien' => "../app/pdf_consultation.php?idx=",
          'id' => "&obj=consultation",
          'lib' => "<span class=\"om-prev-icon om-icon-16 om-icon-fix pdf-16\" title=\"".
                _("Edition")."\">"._("Editer la consultation PDF")."</span>",
          'ordre' => 28,
          'ajax' => false);
/*$portlet_actions['pdfretour'] =
    array('lien' => "/app/pdf_consultation.php?idx=",
          'id' => "&obj=consultation",
          'lib' => "<span class=\"om-prev-icon om-icon-16 om-icon-fix pdf-16\" title=\"".
                _("Edition")."\">"._("Editer le retour d'avis PDF")."</span>",
          'ordre' => 29,
          'ajax' => false);*/
$portlet_actions['lu'] =
    array('lien' => "#\" onclick=\"markedAsRead(",
          'id' => ");\"",
          'lib' => "<span class=\"om-prev-icon om-icon-16 om-icon-fix lu-16\" title=\"".
                _("Edition")."\">"._("Marquer comme lu")."</span>",
          'ordre' => 30,
          'rights' => 'consultation_modifier_lu',
          'ajax' => false);

$sql_service="SELECT service.service, service.abrege||' '||service.libelle FROM ".DB_PREFIXE."service WHERE ((service.om_validite_debut IS NULL AND (service.om_validite_fin IS NULL OR service.om_validite_fin > CURRENT_DATE)) OR (service.om_validite_debut <= CURRENT_DATE AND (service.om_validite_fin IS NULL OR service.om_validite_fin > CURRENT_DATE))) ORDER BY service.abrege";
$sql_service_by_id = "SELECT service.service, service.abrege||' '||service.libelle FROM ".DB_PREFIXE."service WHERE service = <idx>";
             
?>
1	fraynaud	3	<?php
2			//$Id$
3			//gen openMairie le 10/02/2011 20:32
4			include('../gen/sql/pgsql/consultation.form.inc.php');
5	nhaye	429
6	vpihour	497	$champs=array("consultation",
7	nhaye	543	"dossier",
8			"service",
9			"to_char(consultation.date_envoi ,'DD/MM/YYYY') as \"date_envoi\"",
10			"to_char(consultation.date_reception ,'DD/MM/YYYY') as \"date_reception\"",
11			"to_char(consultation.date_limite ,'DD/MM/YYYY') as \"date_limite\"",
12			"to_char(consultation.date_retour ,'DD/MM/YYYY') as \"date_retour\"",
13			"avis_consultation",
14			"motivation",
15			"fichier",
16			"lu"
17			);
18	vpihour	492
19	nhaye	429	$href[3]['lien'] = "../pdf/pdfetat.php?idx=";
20			$href[3]['id']= "&obj=consultation";
21			$href[3]['lib']= "<span class=\"om-icon om-icon-16 om-icon-fix pdf-16\" title=\"".
22			_("Edition")."\">"._("Edition")."</span>";
23
24	vpihour	555	// Action : Edition PDF
25			$portlet_actions['pdfetat'] =
26			array('lien' => "../app/pdf_consultation.php?idx=",
27			'id' => "&obj=consultation",
28			'lib' => "<span class=\"om-prev-icon om-icon-16 om-icon-fix pdf-16\" title=\"".
29			_("Edition")."\">"._("Editer la consultation PDF")."</span>",
30			'ordre' => 28,
31			'ajax' => false);
32	vpihour	563	/*$portlet_actions['pdfretour'] =
33			array('lien' => "/app/pdf_consultation.php?idx=",
34	vpihour	555	'id' => "&obj=consultation",
35			'lib' => "<span class=\"om-prev-icon om-icon-16 om-icon-fix pdf-16\" title=\"".
36			_("Edition")."\">"._("Editer le retour d'avis PDF")."</span>",
37			'ordre' => 29,
38	vpihour	881	'ajax' => false);*/
39	vpihour	555	$portlet_actions['lu'] =
40	vpihour	881	array('lien' => "#\" onclick=\"markedAsRead(",
41			'id' => ");\"",
42	vpihour	555	'lib' => "<span class=\"om-prev-icon om-icon-16 om-icon-fix lu-16\" title=\"".
43	vpihour	881	_("Edition")."\">"._("Marquer comme lu")."</span>",
44	vpihour	555	'ordre' => 30,
45	vpihour	892	'rights' => 'consultation_modifier_lu',
46	vpihour	881	'ajax' => false);
47	vpihour	555
48	vpihour	717	$sql_service="SELECT service.service, service.abrege\|\|' '\|\|service.libelle FROM ".DB_PREFIXE."service WHERE ((service.om_validite_debut IS NULL AND (service.om_validite_fin IS NULL OR service.om_validite_fin > CURRENT_DATE)) OR (service.om_validite_debut <= CURRENT_DATE AND (service.om_validite_fin IS NULL OR service.om_validite_fin > CURRENT_DATE))) ORDER BY service.abrege";
49	nhaye	509	$sql_service_by_id = "SELECT service.service, service.abrege\|\|' '\|\|service.libelle FROM ".DB_PREFIXE."service WHERE service = <idx>";
50	vpihour	527
51	nhaye	498	?>