diff options
Diffstat (limited to 'library')
| -rw-r--r-- | library/Pbs/Filter.php | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/library/Pbs/Filter.php b/library/Pbs/Filter.php index 5b8e53b..0a62da9 100644 --- a/library/Pbs/Filter.php +++ b/library/Pbs/Filter.php @@ -9,7 +9,7 @@ class Pbs_Filter{ { $this->db = Zend_Db_Table::getDefaultAdapter(); $db = $this->db; - $debuglevel = 0; + $debuglevel = 3; $userIDsNamespace = Zend_Session::namespaceGet('userIDs'); @@ -326,14 +326,14 @@ class Pbs_Filter{ // date $filtertypID = 11; if(!$testFilter){ - $date = date('d.m.Y'); + $date = strtotime(date('d.m.Y')); } try{ $stmt = $db->query("SELECT * FROM pbs_filterentries fe, pbs_filter f WHERE fe.filtertypeID = ".$filtertypID." AND - REPLACE(fe.filtervalue,'.','') <= ".$date." AND - ".$date." <= REPLACE(fe.filtervalue2,'.','') <= AND + fe.filtervalue <= ".$date." AND + ".$date." <= fe.filtervalue2 AND fe.filterID = f.filterID AND f.groupID = '".$groupID."'"); $result = $stmt->fetchAll(); @@ -344,7 +344,7 @@ class Pbs_Filter{ catch(Exception $e){} if($debuglevel >= 3) - print_a('date',$result,$set[$filtertypID]); + print_a('date',$result,$set[$filtertypID],$date); ######################################## $result = array(); // ErgebnisSet auswerten |