/[openfoncier]/trunk/sql/pgsql/consultation.form.inc.php
ViewVC logotype

Diff of /trunk/sql/pgsql/consultation.form.inc.php

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

trunk/sql/pgsql/consultation.form.inc revision 20 by fraynaud, Mon Jul 18 15:27:17 2011 UTC trunk/sql/pgsql/consultation.form.inc.php revision 1930 by vpihour, Tue May 28 12:24:39 2013 UTC
# Line 2  Line 2 
2  //$Id$  //$Id$
3  //gen openMairie le 10/02/2011 20:32  //gen openMairie le 10/02/2011 20:32
4  include('../gen/sql/pgsql/consultation.form.inc.php');  include('../gen/sql/pgsql/consultation.form.inc.php');
 $sql_service= "select service, service||' '||libelle from service order by libelle";  
 $sql_avis= "select avis,avis||' '||libelle from avis order by libelle";  
 ?>  
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    "code_barres",
18    "om_fichier_consultation",
19    "om_final_consultation"
20    );
21    
22    // Action : Edition PDF
23    $portlet_actions['pdfetat'] =
24        array('lien' => "../spg/file.php?id=",
25              'id' => "&obj=consultation&champ=om_fichier_consultation",
26              'lib' => "<span class=\"om-prev-icon om-icon-16 om-icon-fix pdf-16\" title=\"".
27                    _("Edition")."\">"._("Editer la consultation PDF")."</span>",
28              'ordre' => 28,
29              'target' => '_blank',
30              'ajax' => false);
31    /*$portlet_actions['pdfretour'] =
32        array('lien' => "/app/pdf_consultation.php?idx=",
33              'id' => "&obj=consultation",
34              'lib' => "<span class=\"om-prev-icon om-icon-16 om-icon-fix pdf-16\" title=\"".
35                    _("Edition")."\">"._("Editer le retour d'avis PDF")."</span>",
36              'ordre' => 29,
37              'ajax' => false);*/
38              
39    //Marque comme lu une consultation au clique
40    $portlet_actions['lu'] =
41        array('lien' => "#\" onclick=\"portletUpdateData(",
42              'id' => ",'consultation','consultation', 'marquer_comme_lu', 'lu', 'Oui');\"",
43              'lib' => "<span class=\"om-prev-icon om-icon-16 om-icon-fix lu-16\" title=\"".
44                    _("Edition")."\">"._("Marquer comme lu")."</span>",
45              'ordre' => 30,
46              'rights' => array('list' => array("consultation", "consultation_modifier_lu"), 'operator' => 'OR'),
47              'ajax' => false);
48    
49    $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";
50    $sql_service_by_id = "SELECT service.service, service.abrege||' '||service.libelle FROM ".DB_PREFIXE."service WHERE service = <idx>";
51                
52    ?>
Legend:
Removed from v.20  
changed lines
  Added in v.1930
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26