/[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 901 by vpihour, Thu Nov 29 13:05:51 2012 UTC revision 2621 by vpihour, Wed Dec 18 10:45:16 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    //
7    $tableSelect .= "
8      LEFT JOIN ".DB_PREFIXE."dossier
9        ON consultation.dossier = dossier.dossier";
10    
11    //
12  $champs=array("consultation",  $champs=array("consultation",
13  "dossier",  "dossier.dossier",
14    "dossier_libelle",
15  "service",  "service",
16  "to_char(consultation.date_envoi ,'DD/MM/YYYY') as \"date_envoi\"",  "to_char(consultation.date_envoi ,'DD/MM/YYYY') as \"date_envoi\"",
17  "to_char(consultation.date_reception ,'DD/MM/YYYY') as \"date_reception\"",  "to_char(consultation.date_reception ,'DD/MM/YYYY') as \"date_reception\"",
# Line 13  $champs=array("consultation", Line 20  $champs=array("consultation",
20  "avis_consultation",  "avis_consultation",
21  "motivation",  "motivation",
22  "fichier",  "fichier",
23  "lu"  "lu",
24    "code_barres",
25    "om_fichier_consultation",
26    "om_final_consultation"
27  );  );
28    
 $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>";  
   
29  // Action : Edition PDF  // Action : Edition PDF
30  $portlet_actions['pdfetat'] =  $portlet_actions['pdfetat'] =
31      array('lien' => "../app/pdf_consultation.php?idx=",      array('lien' => "../app/pdf_consultation.php?idx=",
32            'id' => "&obj=consultation",            'id' => "",
33            '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 edition\" title=\"".
34                  _("Edition")."\">"._("Editer la consultation PDF")."</span>",                  _("Edition")."\">"._("Editer la consultation PDF")."</span>",
35            'ordre' => 28,            'ordre' => 28,
36              'target' => '_blank',
37            'ajax' => false);            'ajax' => false);
38  /*$portlet_actions['pdfretour'] =  /*$portlet_actions['pdfretour'] =
39      array('lien' => "/app/pdf_consultation.php?idx=",      array('lien' => "/app/pdf_consultation.php?idx=",
# Line 36  $portlet_actions['pdfetat'] = Line 42  $portlet_actions['pdfetat'] =
42                  _("Edition")."\">"._("Editer le retour d'avis PDF")."</span>",                  _("Edition")."\">"._("Editer le retour d'avis PDF")."</span>",
43            'ordre' => 29,            'ordre' => 29,
44            'ajax' => false);*/            'ajax' => false);*/
45              
46    //Marque comme lu une consultation au clique
47  $portlet_actions['lu'] =  $portlet_actions['lu'] =
48      array('lien' => "#\" onclick=\"markedAsRead(",      array('lien' => "#\" onclick=\"portletUpdateData(",
49            'id' => ",'consultation','consultation');\"",            'id' => ",'consultation','consultation', 'marquer_comme_lu', 'lu', 'Oui');\"",
50            'lib' => "<span class=\"om-prev-icon om-icon-16 om-icon-fix lu-16\" title=\"".            'lib' => "<span class=\"om-prev-icon om-icon-16 om-icon-fix lu-16\" title=\"".
51                  _("Edition")."\">"._("Marquer comme lu")."</span>",                  _("Edition")."\">"._("Marquer comme lu")."</span>",
52            'ordre' => 30,            'ordre' => 30,
53            'rights' => array('list' => array("consultation", "consultation_modifier_lu"), 'operator' => 'OR'),            'rights' => array('list' => array("consultation", "consultation_modifier_lu"), 'operator' => 'OR'),
54            'ajax' => false);            '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";  // Finalisation d'un document
57    $portlet_actions['finalisation'] =
58        array('lien' => "#\" onclick=\"finalizeDocument(",
59              'id' => ",'consultation', 'sousform-',1, '".(isset($_GET['retourformulaire'])?$_GET['retourformulaire']:"")."');\"",
60              'lib' => "<span class=\"om-prev-icon om-icon-16 om-icon-fix finalise\" title=\"".
61                    _("Finaliser le document")."\">"._("Finaliser le document")."</span>",
62              'ordre' => 31,
63              'rights' => array('list' => array("consultation_finaliser"), 'operator' => 'OR'),
64              'ajax' => false);
65    
66    // Dé-finalisation d'un document
67    $portlet_actions['definalisation'] =
68        array('lien' => "#\" onclick=\"finalizeDocument(",
69              'id' => ",'consultation', 'sousform-',0, '".(isset($_GET['retourformulaire'])?$_GET['retourformulaire']:"")."');\"",
70              'lib' => "<span class=\"om-prev-icon om-icon-16 om-icon-fix definalise\" title=\"".
71                    _("Reprendre la redaction du document")."\">"._("Reprendre la redaction du document")."</span>",
72              'ordre' => 32,
73              'rights' => array('list' => array("consultation_definaliser"), 'operator' => 'OR'),
74              'ajax' => false);
75    
76    $sql_service="SELECT service.service, 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.libelle";
77  $sql_service_by_id = "SELECT service.service, service.abrege||' '||service.libelle FROM ".DB_PREFIXE."service WHERE service = <idx>";  $sql_service_by_id = "SELECT service.service, service.abrege||' '||service.libelle FROM ".DB_PREFIXE."service WHERE service = <idx>";
78                            
79  ?>  ?>
Legend:
Removed from v.901  
changed lines
  Added in v.2621
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26