/[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 716 by vpihour, Wed Oct 31 10:25:25 2012 UTC revision 717 by vpihour, Fri Nov 16 11:28:57 2012 UTC
# Line 44  $portlet_actions['lu'] = Line 44  $portlet_actions['lu'] =
44            'ordre' => 30,            'ordre' => 30,
45            'ajax' => false);*/            'ajax' => false);*/
46    
47  $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))) ORDER BY service.abrege";
48  $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>";
49                            
50  ?>  ?>
Legend:
Removed from v.716  
changed lines
  Added in v.717
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26