/[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 509 by nhaye, Tue Oct 16 16:50:50 2012 UTC revision 543 by nhaye, Mon Oct 29 16:17:36 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";
# Line 32  $href[3]['lib']= "<span class=\"om-icon Line 32  $href[3]['lib']= "<span class=\"om-icon
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)))";  $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>";  $sql_service_by_id = "SELECT service.service, service.abrege||' '||service.libelle FROM ".DB_PREFIXE."service WHERE service = <idx>";
35                              
36  ?>  ?>
Legend:
Removed from v.509  
changed lines
  Added in v.543
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26