/[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 242 by fraynaud, Wed Nov 23 19:39:04 2011 UTC trunk/sql/pgsql/consultation.form.inc.php revision 527 by vpihour, Fri Oct 19 16:14:11 2012 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 ".DB_PREFIXE."service order by libelle";  
 $sql_avis= "select avis,avis||' '||libelle from ".DB_PREFIXE."avis order by libelle";  
 ?>  
5    
6    $champs=array("consultation",
7                              "dossier",
8                  "service",
9                  "date_envoi",
10                  "date_reception",
11                  "date_limite",
12                  "date_retour",
13                  "avis_consultation",
14                  "motivation",
15                  "fichier",
16                  "lu"
17                  );
18    
19    $href[3]['lien'] = "../pdf/pdfetat.php?idx=";
20    $href[3]['id']= "&obj=consultation";
21    $href[3]['lib']= "<span class=\"om-icon om-icon-16 om-icon-fix pdf-16\" title=\"".
22                        _("Edition")."\">"._("Edition")."</span>";
23    
24    // Action : modifier
25        $portlet_actions['pdfetat'] =
26            array('lien' => "../app/pdf_consultation.php?idx=",
27                  'id' => "&obj=consultation",
28                  'lib' => "<span class=\"om-prev-icon om-icon-16 om-icon-fix pdf-16\" title=\"".
29                        _("Edition")."\">"._("Edition")."</span>",
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.242  
changed lines
  Added in v.527
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26