/[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 543 by nhaye, Mon Oct 29 16:17:36 2012 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    $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=";  $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=\"".
# Line 10  $href[3]['lib']= "<span class=\"om-icon Line 23  $href[3]['lib']= "<span class=\"om-icon
23    
24  // Action : modifier  // Action : modifier
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")."\">"._("Edition")."</span>",
               'ordre' => 30,);  
 ?>  
30                  'ordre' => 30,
31                  'ajax' => false);
32            
33    $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)))";
34    $sql_service_by_id = "SELECT service.service, service.abrege||' '||service.libelle FROM ".DB_PREFIXE."service WHERE service = <idx>";
35                
36    ?>
Legend:
Removed from v.429  
changed lines
  Added in v.543
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26