/[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 508 by vpihour, Tue Oct 16 15:18:58 2012 UTC revision 509 by nhaye, Tue Oct 16 16:50:50 2012 UTC
# Line 29  $href[3]['lib']= "<span class=\"om-icon Line 29  $href[3]['lib']= "<span class=\"om-icon
29                      _("Edition")."\">"._("Edition")."</span>",                      _("Edition")."\">"._("Edition")."</span>",
30                'ordre' => 30,                'ordre' => 30,
31                'ajax' => false);                '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.508  
changed lines
  Added in v.509
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26