[Fmsystem-commits] [9323] property: dimb acl

[Sigurd Nes]

Revision: 9323
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=9323
Author:   sigurdne
Date:     2012-05-09 06:38:59 +0000 (Wed, 09 May 2012)
Log Message:
-----------
property: dimb acl

Modified Paths:
--------------
    trunk/property/inc/class.soinvoice.inc.php

Modified: trunk/property/inc/class.soinvoice.inc.php
===================================================================
--- trunk/property/inc/class.soinvoice.inc.php  2012-05-09 06:19:04 UTC (rev 
9322)
+++ trunk/property/inc/class.soinvoice.inc.php  2012-05-09 06:38:59 UTC (rev 
9323)
@@ -1103,7 +1103,7 @@
                        $dimb           = (int) $dimb;
                        $role_id        = (int) $role_id;
                        $sql = "SELECT user_id FROM fm_ecodimb_role_user"
-                       ." WHERE role_id = {$role_id} AND ecodimb = {$dimb} AND 
expired_on IS NULL AND default_user = 1";
+                       ." WHERE role_id = {$role_id} AND ecodimb = {$dimb} AND 
expired_on IS NULL AND default_user = 1  AND active_from < " . time(). ' AND 
(active_to > ' . time() . ' OR active_to = 0)';
 //_debug_array($sql);
                        $this->db->query($sql,__LINE__,__FILE__);
                        $this->db->next_record();