/[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 429 by nhaye, Mon Sep 24 15:08:54 2012 UTC revision 2112 by softime, Wed Jul 24 17:08:32 2013 UTC
# Line 3  Line 3 
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');
5    
6  $href[3]['lien'] = "../pdf/pdfetat.php?idx=";  //
7  $href[3]['id']= "&obj=consultation";  $tableSelect .= "
8  $href[3]['lib']= "<span class=\"om-icon om-icon-16 om-icon-fix pdf-16\" title=\"".    LEFT JOIN ".DB_PREFIXE."dossier
9                      _("Edition")."\">"._("Edition")."</span>";      ON consultation.dossier = dossier.dossier";
10    
 // Action : modifier  
     $portlet_actions['pdfetat'] =  
         array('lien' => "../pdf/pdfetat.php?idx=",  
               'id' => "&obj=consultation",  
               'lib' => "<span class=\"om-prev-icon om-icon-16 om-icon-fix pdf-16\" title=\"".  
                     _("Edition")."\">"._("Edition")."</span>",  
               'ordre' => 30,);  
 ?>  
11    //
12    $champs=array("consultation",
13    "dossier.dossier",
14    "dossier_libelle",
15    "service",
16    "to_char(consultation.date_envoi ,'DD/MM/YYYY') as \"date_envoi\"",
17    "to_char(consultation.date_reception ,'DD/MM/YYYY') as \"date_reception\"",
18    "to_char(consultation.date_limite ,'DD/MM/YYYY') as \"date_limite\"",
19    "to_char(consultation.date_retour ,'DD/MM/YYYY') as \"date_retour\"",
20    "avis_consultation",
21    "motivation",
22    "fichier",
23    "lu",
24    "code_barres",
25    "om_fichier_consultation",
26    "om_final_consultation"
27    );
28    
29    // Action : Edition PDF
30    $portlet_actions['pdfetat'] =
31        array('lien' => "../spg/file.php?id=",
32              'id' => "&amp;obj=consultation&amp;champ=om_fichier_consultation",
33              'lib' => "<span class=\"om-prev-icon om-icon-16 om-icon-fix pdf-16\" title=\"".
34                    _("Edition")."\">"._("Editer la consultation PDF")."</span>",
35              'ordre' => 28,
36              'target' => '_blank',
37              'ajax' => false);
38    /*$portlet_actions['pdfretour'] =
39        array('lien' => "/app/pdf_consultation.php?idx=",
40              'id' => "&obj=consultation",
41              'lib' => "<span class=\"om-prev-icon om-icon-16 om-icon-fix pdf-16\" title=\"".
42                    _("Edition")."\">"._("Editer le retour d'avis PDF")."</span>",
43              'ordre' => 29,
44              'ajax' => false);*/
45              
46    //Marque comme lu une consultation au clique
47    $portlet_actions['lu'] =
48        array('lien' => "#\" onclick=\"portletUpdateData(",
49              'id' => ",'consultation','consultation', 'marquer_comme_lu', 'lu', 'Oui');\"",
50              'lib' => "<span class=\"om-prev-icon om-icon-16 om-icon-fix lu-16\" title=\"".
51                    _("Edition")."\">"._("Marquer comme lu")."</span>",
52              'ordre' => 30,
53              'rights' => array('list' => array("consultation", "consultation_modifier_lu"), 'operator' => 'OR'),
54              'ajax' => false);
55    
56    $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";
57    $sql_service_by_id = "SELECT service.service, service.abrege||' '||service.libelle FROM ".DB_PREFIXE."service WHERE service = <idx>";
58                
59    ?>
Legend:
Removed from v.429  
changed lines
  Added in v.2112
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26