/[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 881 by vpihour, Thu Nov 29 09:40:07 2012 UTC revision 892 by vpihour, Thu Nov 29 10:49:14 2012 UTC
# Line 42  $portlet_actions['lu'] = Line 42  $portlet_actions['lu'] =
42            'lib' => "<span class=\"om-prev-icon om-icon-16 om-icon-fix lu-16\" title=\"".            'lib' => "<span class=\"om-prev-icon om-icon-16 om-icon-fix lu-16\" title=\"".
43                  _("Edition")."\">"._("Marquer comme lu")."</span>",                  _("Edition")."\">"._("Marquer comme lu")."</span>",
44            'ordre' => 30,            'ordre' => 30,
45              'rights' => 'consultation_modifier_lu',
46            'ajax' => false);            'ajax' => false);
47    
48  $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.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";
Legend:
Removed from v.881  
changed lines
  Added in v.892
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26