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	<?php
2	//$Id$
3	//gen openMairie le 10/02/2011 20:32
4	include('../gen/sql/pgsql/consultation.form.inc.php');
5
6	$champs=array("consultation",
7	"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
19	$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	// 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	/*$portlet_actions['pdfretour'] =
33	array('lien' => "/app/pdf_consultation.php?idx=",
34	'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	'ajax' => false);*/
39	$portlet_actions['lu'] =
40	array('lien' => "#\" onclick=\"markedAsRead(",
41	'id' => ");\"",
42	'lib' => "<span class=\"om-prev-icon om-icon-16 om-icon-fix lu-16\" title=\"".
43	_("Edition")."\">"._("Marquer comme lu")."</span>",
44	'ordre' => 30,
45	'rights' => 'consultation_modifier_lu',
46	'ajax' => false);
47
48	$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	$sql_service_by_id = "SELECT service.service, service.abrege\|\|' '\|\|service.libelle FROM ".DB_PREFIXE."service WHERE service = <idx>";
50
51	?>