From a3251a4ec1eb1432e5ef7276e212114fed65b9e0 Mon Sep 17 00:00:00 2001
From: michael pereira
Date: Mon, 10 Oct 2011 01:48:32 +0200
Subject: date filter gefixt

---
 library/Pbs/Filter.php | 10 +++++-----
 1 file changed, 5 insertions(+), 5 deletions(-)

(limited to 'library')

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
-- 
cgit v1.2.3-55-g7522