WICHTIG findBy Methode geändert & alles angepasst, siehe Ticket

1 files changed, 31 insertions, 4 deletions

diff --git a/application/models/MembershipMapper.php b/application/models/MembershipMapper.php
index 5aa0bfd..67b4985 100644
--- a/application/models/MembershipMapper.php
+++ b/application/models/MembershipMapper.php
@@ -4,17 +4,44 @@ class Application_Model_MembershipMapper
 {
 	
 	protected $_dbTable;
-
-	public function findBy($criteria, $value) 
+	
+	public function findBy($where, $array=false, $order=false) 
 	{		
+		foreach($where as $k => $v){
+			if($v != null)
+				$where2[] = "$k = '$v'"; 
+			else 
+				$where2[] = "$k IS NULL"; 
+		}
+		$where = implode(" AND " ,$where2);
+		
 		try{ 
 			$db = Zend_Db_Table::getDefaultAdapter();
 			$select = $this->getDbTable()->select() 
 				->from($this->_dbTable) 
-				->where($criteria . ' = ?', $value); 
+				->where($where); 
+				
+			if(is_array($order)){
+				foreach ($order as $k => $v)
+					$a[] = "$k $v";
+				$select->order($a);
+			}
+				
 			$stmt = $select->query();
 			$result = $stmt->fetchAll();
-			return $result;
+			
+			if(!$array){
+				$entries = array();
+				foreach ($result as $row) {
+					$entry = new Application_Model_Membership($row);
+					$entry->setID($row['membershipID']);
+					$entries[] = $entry;
+				}
+				return $entries;
+			}else{
+				return $result;
+			}
+			
 		}catch (Zend_Exception $e) {  
 			echo "Error message 2: " . $e->getMessage() . "\n";  
 		}