Merge branch 'master' of openslx.org:lsfks/master-teamprojekt/pbs2

24 files changed, 367 insertions, 18 deletions

diff --git a/application/models/BootIsoMapper.php b/application/models/BootIsoMapper.php
index 0039677..11af0d7 100644
--- a/application/models/BootIsoMapper.php
+++ b/application/models/BootIsoMapper.php
@@ -5,6 +5,21 @@ class Application_Model_BootIsoMapper
 	
 	protected $_dbTable;
 
+	public function findBy($criteria, $value) 
+	{		
+		try{ 
+			$db = Zend_Db_Table::getDefaultAdapter();
+			$select = $this->getDbTable()->select() 
+				->from($this->_dbTable) 
+				->where($criteria . ' = ?', $value); 
+			$stmt = $select->query();
+			$result = $stmt->fetchAll();
+			return $result;
+		}catch (Zend_Exception $e) {  
+			echo "Error message 2: " . $e->getMessage() . "\n";  
+		}
+	} 
+
 	public function setDbTable($dbTable)
 	{
 		if (is_string($dbTable)) {
diff --git a/application/models/BootMenuEntriesMapper.php b/application/models/BootMenuEntriesMapper.php
index a2a497a..d697c10 100644
--- a/application/models/BootMenuEntriesMapper.php
+++ b/application/models/BootMenuEntriesMapper.php
@@ -5,6 +5,21 @@ class Application_Model_BootMenuEntriesMapper
 	
 	protected $_dbTable;
 
+	public function findBy($criteria, $value) 
+	{		
+		try{ 
+			$db = Zend_Db_Table::getDefaultAdapter();
+			$select = $this->getDbTable()->select() 
+				->from($this->_dbTable) 
+				->where($criteria . ' = ?', $value); 
+			$stmt = $select->query();
+			$result = $stmt->fetchAll();
+			return $result;
+		}catch (Zend_Exception $e) {  
+			echo "Error message 2: " . $e->getMessage() . "\n";  
+		}
+	} 
+
 	public function setDbTable($dbTable)
 	{
 		if (is_string($dbTable)) {
diff --git a/application/models/BootMenuMapper.php b/application/models/BootMenuMapper.php
index 51e85ef..550e956 100644
--- a/application/models/BootMenuMapper.php
+++ b/application/models/BootMenuMapper.php
@@ -5,6 +5,21 @@ class Application_Model_BootMenuMapper
 	
 	protected $_dbTable;
 
+	public function findBy($criteria, $value) 
+	{		
+		try{ 
+			$db = Zend_Db_Table::getDefaultAdapter();
+			$select = $this->getDbTable()->select() 
+				->from($this->_dbTable) 
+				->where($criteria . ' = ?', $value); 
+			$stmt = $select->query();
+			$result = $stmt->fetchAll();
+			return $result;
+		}catch (Zend_Exception $e) {  
+			echo "Error message 2: " . $e->getMessage() . "\n";  
+		}
+	} 
+
 	public function setDbTable($dbTable)
 	{
 		if (is_string($dbTable)) {
diff --git a/application/models/BootOsMapper.php b/application/models/BootOsMapper.php
index d4a43af..2f43916 100644
--- a/application/models/BootOsMapper.php
+++ b/application/models/BootOsMapper.php
@@ -5,6 +5,21 @@ class Application_Model_BootOsMapper
 	
 	protected $_dbTable;
 
+	public function findBy($criteria, $value) 
+	{		
+		try{ 
+			$db = Zend_Db_Table::getDefaultAdapter();
+			$select = $this->getDbTable()->select() 
+				->from($this->_dbTable) 
+				->where($criteria . ' = ?', $value); 
+			$stmt = $select->query();
+			$result = $stmt->fetchAll();
+			return $result;
+		}catch (Zend_Exception $e) {  
+			echo "Error message 2: " . $e->getMessage() . "\n";  
+		}
+	} 
+
 	public function setDbTable($dbTable)
 	{
 		if (is_string($dbTable)) {
diff --git a/application/models/ClientMapper.php b/application/models/ClientMapper.php
index bf513ea..7016ae7 100644
--- a/application/models/ClientMapper.php
+++ b/application/models/ClientMapper.php
@@ -5,6 +5,21 @@ class Application_Model_ClientMapper
 	
 	protected $_dbTable;
 
+	public function findBy($criteria, $value) 
+	{		
+		try{ 
+			$db = Zend_Db_Table::getDefaultAdapter();
+			$select = $this->getDbTable()->select() 
+				->from($this->_dbTable) 
+				->where($criteria . ' = ?', $value); 
+			$stmt = $select->query();
+			$result = $stmt->fetchAll();
+			return $result;
+		}catch (Zend_Exception $e) {  
+			echo "Error message 2: " . $e->getMessage() . "\n";  
+		}
+	} 
+
 	public function setDbTable($dbTable)
 	{
 		if (is_string($dbTable)) {
@@ -75,8 +90,7 @@ class Application_Model_ClientMapper
 			$entries[] = $entry;
 		}
 		return $entries;
-	}
-
+	}	
 
 	
 }
diff --git a/application/models/ConfigMapper.php b/application/models/ConfigMapper.php
index 8ee9e0c..dc2a524 100644
--- a/application/models/ConfigMapper.php
+++ b/application/models/ConfigMapper.php
@@ -5,6 +5,21 @@ class Application_Model_ConfigMapper
 	
 	protected $_dbTable;
 
+	public function findBy($criteria, $value) 
+	{		
+		try{ 
+			$db = Zend_Db_Table::getDefaultAdapter();
+			$select = $this->getDbTable()->select() 
+				->from($this->_dbTable) 
+				->where($criteria . ' = ?', $value); 
+			$stmt = $select->query();
+			$result = $stmt->fetchAll();
+			return $result;
+		}catch (Zend_Exception $e) {  
+			echo "Error message 2: " . $e->getMessage() . "\n";  
+		}
+	} 
+
 	public function setDbTable($dbTable)
 	{
 		if (is_string($dbTable)) {
diff --git a/application/models/FilterEntriesMapper.php b/application/models/FilterEntriesMapper.php
index 10fd3f1..bf57dbd 100644
--- a/application/models/FilterEntriesMapper.php
+++ b/application/models/FilterEntriesMapper.php
@@ -5,6 +5,21 @@ class Application_Model_FilterEntriesMapper
 	
 	protected $_dbTable;
 
+	public function findBy($criteria, $value) 
+	{		
+		try{ 
+			$db = Zend_Db_Table::getDefaultAdapter();
+			$select = $this->getDbTable()->select() 
+				->from($this->_dbTable) 
+				->where($criteria . ' = ?', $value); 
+			$stmt = $select->query();
+			$result = $stmt->fetchAll();
+			return $result;
+		}catch (Zend_Exception $e) {  
+			echo "Error message 2: " . $e->getMessage() . "\n";  
+		}
+	} 
+
 	public function setDbTable($dbTable)
 	{
 		if (is_string($dbTable)) {
@@ -92,13 +107,7 @@ class Application_Model_FilterEntriesMapper
 						->setFiltervalue2($row->filtervalue2);
 		return $filterentries;
 	}
-	public function findBy($field,$value)
-    {
-		$db = $this->getAdapter();
-		$where = $db->quoteInto($db->quoteIdentifier($field).' = ?', value);
-		return $this->fetchAll($where);
 
-    }
 
 	public function fetchAll()
 	{
diff --git a/application/models/FilterMapper.php b/application/models/FilterMapper.php
index 3960c0d..eba9b71 100644
--- a/application/models/FilterMapper.php
+++ b/application/models/FilterMapper.php
@@ -5,6 +5,21 @@ class Application_Model_FilterMapper
 	
 	protected $_dbTable;
 
+	public function findBy($criteria, $value) 
+	{		
+		try{ 
+			$db = Zend_Db_Table::getDefaultAdapter();
+			$select = $this->getDbTable()->select() 
+				->from($this->_dbTable) 
+				->where($criteria . ' = ?', $value); 
+			$stmt = $select->query();
+			$result = $stmt->fetchAll();
+			return $result;
+		}catch (Zend_Exception $e) {  
+			echo "Error message 2: " . $e->getMessage() . "\n";  
+		}
+	} 
+
 	public function setDbTable($dbTable)
 	{
 		if (is_string($dbTable)) {
diff --git a/application/models/FilterTypeMapper.php b/application/models/FilterTypeMapper.php
index 8ed2722..105daf4 100644
--- a/application/models/FilterTypeMapper.php
+++ b/application/models/FilterTypeMapper.php
@@ -5,6 +5,21 @@ class Application_Model_FilterTypeMapper
 	
 	protected $_dbTable;
 
+	public function findBy($criteria, $value) 
+	{		
+		try{ 
+			$db = Zend_Db_Table::getDefaultAdapter();
+			$select = $this->getDbTable()->select() 
+				->from($this->_dbTable) 
+				->where($criteria . ' = ?', $value); 
+			$stmt = $select->query();
+			$result = $stmt->fetchAll();
+			return $result;
+		}catch (Zend_Exception $e) {  
+			echo "Error message 2: " . $e->getMessage() . "\n";  
+		}
+	} 
+
 	public function setDbTable($dbTable)
 	{
 		if (is_string($dbTable)) {
diff --git a/application/models/GroupGroupsMapper.php b/application/models/GroupGroupsMapper.php
index 79bf774..d7f5095 100644
--- a/application/models/GroupGroupsMapper.php
+++ b/application/models/GroupGroupsMapper.php
@@ -5,6 +5,21 @@ class Application_Model_GroupGroupsMapper
 	
 	protected $_dbTable;
 
+	public function findBy($criteria, $value) 
+	{		
+		try{ 
+			$db = Zend_Db_Table::getDefaultAdapter();
+			$select = $this->getDbTable()->select() 
+				->from($this->_dbTable) 
+				->where($criteria . ' = ?', $value); 
+			$stmt = $select->query();
+			$result = $stmt->fetchAll();
+			return $result;
+		}catch (Zend_Exception $e) {  
+			echo "Error message 2: " . $e->getMessage() . "\n";  
+		}
+	} 
+
 	public function setDbTable($dbTable)
 	{
 		if (is_string($dbTable)) {
diff --git a/application/models/GroupMapper.php b/application/models/GroupMapper.php
index b9c7e30..f48fc5f 100644
--- a/application/models/GroupMapper.php
+++ b/application/models/GroupMapper.php
@@ -5,6 +5,21 @@ class Application_Model_GroupMapper
 	
 	protected $_dbTable;
 
+	public function findBy($criteria, $value) 
+	{		
+		try{ 
+			$db = Zend_Db_Table::getDefaultAdapter();
+			$select = $this->getDbTable()->select() 
+				->from($this->_dbTable) 
+				->where($criteria . ' = ?', $value); 
+			$stmt = $select->query();
+			$result = $stmt->fetchAll();
+			return $result;
+		}catch (Zend_Exception $e) {  
+			echo "Error message 2: " . $e->getMessage() . "\n";  
+		}
+	} 
+
 	public function setDbTable($dbTable)
 	{
 		if (is_string($dbTable)) {
diff --git a/application/models/GroupRequestMapper.php b/application/models/GroupRequestMapper.php
index c09e047..aa83095 100644
--- a/application/models/GroupRequestMapper.php
+++ b/application/models/GroupRequestMapper.php
@@ -5,6 +5,21 @@ class Application_Model_GroupRequestMapper
 	
 	protected $_dbTable;
 
+	public function findBy($criteria, $value) 
+	{		
+		try{ 
+			$db = Zend_Db_Table::getDefaultAdapter();
+			$select = $this->getDbTable()->select() 
+				->from($this->_dbTable) 
+				->where($criteria . ' = ?', $value); 
+			$stmt = $select->query();
+			$result = $stmt->fetchAll();
+			return $result;
+		}catch (Zend_Exception $e) {  
+			echo "Error message 2: " . $e->getMessage() . "\n";  
+		}
+	} 
+
 	public function setDbTable($dbTable)
 	{
 		if (is_string($dbTable)) {
diff --git a/application/models/MembershipFiltersMapper.php b/application/models/MembershipFiltersMapper.php
index e894c82..353eea1 100644
--- a/application/models/MembershipFiltersMapper.php
+++ b/application/models/MembershipFiltersMapper.php
@@ -5,6 +5,21 @@ class Application_Model_MembershipFiltersMapper
 	
 	protected $_dbTable;
 
+	public function findBy($criteria, $value) 
+	{		
+		try{ 
+			$db = Zend_Db_Table::getDefaultAdapter();
+			$select = $this->getDbTable()->select() 
+				->from($this->_dbTable) 
+				->where($criteria . ' = ?', $value); 
+			$stmt = $select->query();
+			$result = $stmt->fetchAll();
+			return $result;
+		}catch (Zend_Exception $e) {  
+			echo "Error message 2: " . $e->getMessage() . "\n";  
+		}
+	} 
+
 	public function setDbTable($dbTable)
 	{
 		if (is_string($dbTable)) {
diff --git a/application/models/MembershipMapper.php b/application/models/MembershipMapper.php
index f2c0aee..58fa9d5 100644
--- a/application/models/MembershipMapper.php
+++ b/application/models/MembershipMapper.php
@@ -5,6 +5,21 @@ class Application_Model_MembershipMapper
 	
 	protected $_dbTable;
 
+	public function findBy($criteria, $value) 
+	{		
+		try{ 
+			$db = Zend_Db_Table::getDefaultAdapter();
+			$select = $this->getDbTable()->select() 
+				->from($this->_dbTable) 
+				->where($criteria . ' = ?', $value); 
+			$stmt = $select->query();
+			$result = $stmt->fetchAll();
+			return $result;
+		}catch (Zend_Exception $e) {  
+			echo "Error message 2: " . $e->getMessage() . "\n";  
+		}
+	} 
+
 	public function setDbTable($dbTable)
 	{
 		if (is_string($dbTable)) {
diff --git a/application/models/PersonMapper.php b/application/models/PersonMapper.php
index 07c0347..79a84c7 100644
--- a/application/models/PersonMapper.php
+++ b/application/models/PersonMapper.php
@@ -5,6 +5,21 @@ class Application_Model_PersonMapper
 	
 	protected $_dbTable;
 
+	public function findBy($criteria, $value) 
+	{		
+		try{ 
+			$db = Zend_Db_Table::getDefaultAdapter();
+			$select = $this->getDbTable()->select() 
+				->from($this->_dbTable) 
+				->where($criteria . ' = ?', $value); 
+			$stmt = $select->query();
+			$result = $stmt->fetchAll();
+			return $result;
+		}catch (Zend_Exception $e) {  
+			echo "Error message 2: " . $e->getMessage() . "\n";  
+		}
+	} 
+
 	public function setDbTable($dbTable)
 	{
 		if (is_string($dbTable)) {
diff --git a/application/models/PoolEntries.php b/application/models/PoolEntries.php
index 31caf5f..102dc9d 100644
--- a/application/models/PoolEntries.php
+++ b/application/models/PoolEntries.php
@@ -2,6 +2,7 @@
 
 class Application_Model_PoolEntries
 {
+	protected $_poolentriesID;
 	protected $_poolID;
 	protected $_clientID;
 
@@ -42,7 +43,15 @@ class Application_Model_PoolEntries
 		return $this;
 	}
 
-
+	public function getID()
+	{
+		return $this->_poolentriesID;
+	}
+	public function setID($_poolentriesID)
+	{
+		$this->_poolentriesID = $_poolentriesID;
+		return $this;
+	}
 	public function getPoolID()
 	{
 		return $this->_poolID;
diff --git a/application/models/PoolEntriesMapper.php b/application/models/PoolEntriesMapper.php
index 5d92f4c..61e4e0a 100644
--- a/application/models/PoolEntriesMapper.php
+++ b/application/models/PoolEntriesMapper.php
@@ -5,6 +5,21 @@ class Application_Model_PoolEntriesMapper
 	
 	protected $_dbTable;
 
+	public function findBy($criteria, $value) 
+	{		
+		try{ 
+			$db = Zend_Db_Table::getDefaultAdapter();
+			$select = $this->getDbTable()->select() 
+				->from($this->_dbTable) 
+				->where($criteria . ' = ?', $value); 
+			$stmt = $select->query();
+			$result = $stmt->fetchAll();
+			return $result;
+		}catch (Zend_Exception $e) {  
+			echo "Error message 2: " . $e->getMessage() . "\n";  
+		}
+	} 
+
 	public function setDbTable($dbTable)
 	{
 		if (is_string($dbTable)) {
@@ -32,13 +47,13 @@ class Application_Model_PoolEntriesMapper
 	public function save(Application_Model_PoolEntries $polentries)
 	{
 		
-		$data = array('poolID'=> $polentries->getPoolID() ,'clientID'=> $polentries->getClientID() );
+		$data = array('poolentriesID' => $polentries->getID(), 'poolID'=> $polentries->getPoolID() ,'clientID'=> $polentries->getClientID() );
 
 		if (null === ($id = $polentries->getID()) ) {
-			unset($data['polentriesID']);
+			unset($data['poolentriesID']);
 			$this->getDbTable()->insert($data);
 		} else {
-			$this->getDbTable()->update($data, array('polentriesID = ?' => $id));
+			$this->getDbTable()->update($data, array('poolentriesID = ?' => $id));
 		}
 	}
 	
@@ -47,7 +62,7 @@ class Application_Model_PoolEntriesMapper
 		if (null === ($id = $polentries->getID()) ) {
 			return;
 		} else {
-			$this->getDbTable()->delete(array('polentriesID = ?' => $id));
+			$this->getDbTable()->delete(array('poolentriesID = ?' => $id));
 		}
 	}
 
@@ -60,7 +75,7 @@ class Application_Model_PoolEntriesMapper
 
 		$row = $result->current();
 		
-		$polentries->setPoolID($row->poolID)->setClientID($row->clientID);
+		$polentries->setID($row->poolentriesID)->setPoolID($row->poolID)->setClientID($row->clientID);
 	}
 
 	public function fetchAll()
@@ -70,7 +85,7 @@ class Application_Model_PoolEntriesMapper
 		foreach ($resultSet as $row) {
 			$entry = new Application_Model_PoolEntries();
 			
-			$entry->setPoolID($row->poolID)->setClientID($row->clientID);	
+			$entry->setID($row->poolentriesID)->setPoolID($row->poolID)->setClientID($row->clientID);	
 
 			$entries[] = $entry;
 		}
diff --git a/application/models/PoolFiltersMapper.php b/application/models/PoolFiltersMapper.php
index 582f955..7cc20bb 100644
--- a/application/models/PoolFiltersMapper.php
+++ b/application/models/PoolFiltersMapper.php
@@ -5,6 +5,21 @@ class Application_Model_PoolFiltersMapper
 	
 	protected $_dbTable;
 
+	public function findBy($criteria, $value) 
+	{		
+		try{ 
+			$db = Zend_Db_Table::getDefaultAdapter();
+			$select = $this->getDbTable()->select() 
+				->from($this->_dbTable) 
+				->where($criteria . ' = ?', $value); 
+			$stmt = $select->query();
+			$result = $stmt->fetchAll();
+			return $result;
+		}catch (Zend_Exception $e) {  
+			echo "Error message 2: " . $e->getMessage() . "\n";  
+		}
+	} 
+
 	public function setDbTable($dbTable)
 	{
 		if (is_string($dbTable)) {
diff --git a/application/models/PoolMapper.php b/application/models/PoolMapper.php
index e2d351a..994a3fd 100644
--- a/application/models/PoolMapper.php
+++ b/application/models/PoolMapper.php
@@ -5,6 +5,21 @@ class Application_Model_PoolMapper
 	
 	protected $_dbTable;
 
+	public function findBy($criteria, $value) 
+	{		
+		try{ 
+			$db = Zend_Db_Table::getDefaultAdapter();
+			$select = $this->getDbTable()->select() 
+				->from($this->_dbTable) 
+				->where($criteria . ' = ?', $value); 
+			$stmt = $select->query();
+			$result = $stmt->fetchAll();
+			return $result;
+		}catch (Zend_Exception $e) {  
+			echo "Error message 2: " . $e->getMessage() . "\n";  
+		}
+	} 
+
 	public function setDbTable($dbTable)
 	{
 		if (is_string($dbTable)) {
@@ -31,7 +46,7 @@ class Application_Model_PoolMapper
 
 	public function save(Application_Model_Pool $pol)
 	{
-		
+		print_a($pol);
 		$data = array('poolID'=> $pol->getID() ,
 				'title'=> $pol->getTitle() ,
 				'description'=> $pol->getDescription() ,
@@ -63,7 +78,10 @@ class Application_Model_PoolMapper
 
 		$row = $result->current();
 		
-		$pol->setID($row->poolID)->setTitle($row->title)->setDescription($row->description)->setLocation($row->location);
+		$pol->setID($row->poolID)
+			->setTitle($row->title)
+			->setDescription($row->description)
+			->setLocation($row->location);
 	}
 
 	public function fetchAll()
@@ -80,7 +98,6 @@ class Application_Model_PoolMapper
 		return $entries;
 	}
 
-
 	
 }
 
diff --git a/application/models/RightMapper.php b/application/models/RightMapper.php
index 35e5b05..570259a 100644
--- a/application/models/RightMapper.php
+++ b/application/models/RightMapper.php
@@ -5,6 +5,21 @@ class Application_Model_RightMapper
 	
 	protected $_dbTable;
 
+	public function findBy($criteria, $value) 
+	{		
+		try{ 
+			$db = Zend_Db_Table::getDefaultAdapter();
+			$select = $this->getDbTable()->select() 
+				->from($this->_dbTable) 
+				->where($criteria . ' = ?', $value); 
+			$stmt = $select->query();
+			$result = $stmt->fetchAll();
+			return $result;
+		}catch (Zend_Exception $e) {  
+			echo "Error message 2: " . $e->getMessage() . "\n";  
+		}
+	} 
+
 	public function setDbTable($dbTable)
 	{
 		if (is_string($dbTable)) {
diff --git a/application/models/RightRolesMapper.php b/application/models/RightRolesMapper.php
index ae409d8..e2adff5 100644
--- a/application/models/RightRolesMapper.php
+++ b/application/models/RightRolesMapper.php
@@ -5,6 +5,21 @@ class Application_Model_RightRolesMapper
 	
 	protected $_dbTable;
 
+	public function findBy($criteria, $value) 
+	{		
+		try{ 
+			$db = Zend_Db_Table::getDefaultAdapter();
+			$select = $this->getDbTable()->select() 
+				->from($this->_dbTable) 
+				->where($criteria . ' = ?', $value); 
+			$stmt = $select->query();
+			$result = $stmt->fetchAll();
+			return $result;
+		}catch (Zend_Exception $e) {  
+			echo "Error message 2: " . $e->getMessage() . "\n";  
+		}
+	} 
+
 	public function setDbTable($dbTable)
 	{
 		if (is_string($dbTable)) {
diff --git a/application/models/RoleMapper.php b/application/models/RoleMapper.php
index da8d73a..bc9bc48 100644
--- a/application/models/RoleMapper.php
+++ b/application/models/RoleMapper.php
@@ -5,6 +5,21 @@ class Application_Model_RoleMapper
 	
 	protected $_dbTable;
 
+	public function findBy($criteria, $value) 
+	{		
+		try{ 
+			$db = Zend_Db_Table::getDefaultAdapter();
+			$select = $this->getDbTable()->select() 
+				->from($this->_dbTable) 
+				->where($criteria . ' = ?', $value); 
+			$stmt = $select->query();
+			$result = $stmt->fetchAll();
+			return $result;
+		}catch (Zend_Exception $e) {  
+			echo "Error message 2: " . $e->getMessage() . "\n";  
+		}
+	} 
+
 	public function setDbTable($dbTable)
 	{
 		if (is_string($dbTable)) {
diff --git a/application/models/RolesMapper.php b/application/models/RolesMapper.php
index 681c173..d48d747 100644
--- a/application/models/RolesMapper.php
+++ b/application/models/RolesMapper.php
@@ -5,6 +5,21 @@ class Application_Model_RolesMapper
 	
 	protected $_dbTable;
 
+	public function findBy($criteria, $value) 
+	{		
+		try{ 
+			$db = Zend_Db_Table::getDefaultAdapter();
+			$select = $this->getDbTable()->select() 
+				->from($this->_dbTable) 
+				->where($criteria . ' = ?', $value); 
+			$stmt = $select->query();
+			$result = $stmt->fetchAll();
+			return $result;
+		}catch (Zend_Exception $e) {  
+			echo "Error message 2: " . $e->getMessage() . "\n";  
+		}
+	} 
+
 	public function setDbTable($dbTable)
 	{
 		if (is_string($dbTable)) {
diff --git a/application/models/SessionMapper.php b/application/models/SessionMapper.php
index dac5c4e..57b2fdf 100644
--- a/application/models/SessionMapper.php
+++ b/application/models/SessionMapper.php
@@ -5,6 +5,21 @@ class Application_Model_SessionMapper
 	
 	protected $_dbTable;
 
+	public function findBy($criteria, $value) 
+	{		
+		try{ 
+			$db = Zend_Db_Table::getDefaultAdapter();
+			$select = $this->getDbTable()->select() 
+				->from($this->_dbTable) 
+				->where($criteria . ' = ?', $value); 
+			$stmt = $select->query();
+			$result = $stmt->fetchAll();
+			return $result;
+		}catch (Zend_Exception $e) {  
+			echo "Error message 2: " . $e->getMessage() . "\n";  
+		}
+	} 
+
 	public function setDbTable($dbTable)
 	{
 		if (is_string($dbTable)) {