/[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

revision 498 by nhaye, Fri Oct 12 16:01:09 2012 UTC revision 563 by vpihour, Wed Oct 31 10:25:25 2012 UTC
# Line 4  Line 4 
4  include('../gen/sql/pgsql/consultation.form.inc.php');  include('../gen/sql/pgsql/consultation.form.inc.php');
5    
6  $champs=array("consultation",  $champs=array("consultation",
7                            "dossier",  "dossier",
8                "service",  "service",
9                "date_envoi",  "to_char(consultation.date_envoi ,'DD/MM/YYYY') as \"date_envoi\"",
10                "date_reception",  "to_char(consultation.date_reception ,'DD/MM/YYYY') as \"date_reception\"",
11                "date_limite",  "to_char(consultation.date_limite ,'DD/MM/YYYY') as \"date_limite\"",
12                "date_retour",  "to_char(consultation.date_retour ,'DD/MM/YYYY') as \"date_retour\"",
13                "avis_consultation",  "avis_consultation",
14                "motivation",  "motivation",
15                "fichier",  "fichier",
16                "lu"  "lu"
17                );  );
18    
19  $href[3]['lien'] = "../pdf/pdfetat.php?idx=";  $href[3]['lien'] = "../pdf/pdfetat.php?idx=";
20  $href[3]['id']= "&obj=consultation";  $href[3]['id']= "&obj=consultation";
21  $href[3]['lib']= "<span class=\"om-icon om-icon-16 om-icon-fix pdf-16\" title=\"".  $href[3]['lib']= "<span class=\"om-icon om-icon-16 om-icon-fix pdf-16\" title=\"".
22                      _("Edition")."\">"._("Edition")."</span>";                      _("Edition")."\">"._("Edition")."</span>";
23    
24  // Action : modifier  // Action : Edition PDF
25      $portlet_actions['pdfetat'] =  $portlet_actions['pdfetat'] =
26          array('lien' => "../pdf/pdfetat.php?idx=",      array('lien' => "../app/pdf_consultation.php?idx=",
27                'id' => "&obj=consultation",            'id' => "&obj=consultation",
28                'lib' => "<span class=\"om-prev-icon om-icon-16 om-icon-fix pdf-16\" title=\"".            'lib' => "<span class=\"om-prev-icon om-icon-16 om-icon-fix pdf-16\" title=\"".
29                      _("Edition")."\">"._("Edition")."</span>",                  _("Edition")."\">"._("Editer la consultation PDF")."</span>",
30                'ordre' => 30,            'ordre' => 28,
31                'ajax' => false);            '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' => "../app/pdf_consultation.php?idx=",
41              'id' => "&obj=consultation",
42              'lib' => "<span class=\"om-prev-icon om-icon-16 om-icon-fix lu-16\" title=\"".
43                    _("Edition")."\" onclick='alert(\"test\");'>"._("Marquer comme lu")."</span>",
44              'ordre' => 30,
45              'ajax' => false);*/
46    
47    $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)))";
48    $sql_service_by_id = "SELECT service.service, service.abrege||' '||service.libelle FROM ".DB_PREFIXE."service WHERE service = <idx>";
49                
50  ?>  ?>
Legend:
Removed from v.498  
changed lines
  Added in v.563
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26