diff options
| author | michael pereira | 2011-10-10 01:48:32 +0200 |
|---|---|---|
| committer | michael pereira | 2011-10-10 01:48:32 +0200 |
| commit | a3251a4ec1eb1432e5ef7276e212114fed65b9e0 (patch) | |
| tree | c24b096c2181bf069f4a49db8b08f510f9f93518 /library | |
| parent | vesamenu (diff) | |
| download | pbs2-a3251a4ec1eb1432e5ef7276e212114fed65b9e0.tar.gz pbs2-a3251a4ec1eb1432e5ef7276e212114fed65b9e0.tar.xz pbs2-a3251a4ec1eb1432e5ef7276e212114fed65b9e0.zip | |
date filter gefixt
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 |