/[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 2112 by softime, Wed Jul 24 17:08:32 2013 UTC revision 2380 by softime, Thu Oct 10 14:55:45 2013 UTC
# Line 53  $portlet_actions['lu'] = Line 53  $portlet_actions['lu'] =
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";  $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";
57  $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>";
58                            
59  ?>  ?>
Legend:
Removed from v.2112  
changed lines
  Added in v.2380
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26