Alle mapper mit findBy(criteria, value) ausgestattet && clients zu pool hinzufügen

27 files changed, 429 insertions, 5 deletions

diff --git a/.zfproject.xml b/.zfproject.xml
index b36ab70..417a947 100644
--- a/.zfproject.xml
+++ b/.zfproject.xml
@@ -91,6 +91,7 @@
         <formFile formName="BootisoCreate"/>
         <formFile formName="BootisoEdit"/>
         <formFile formName="Pool"/>
+        <formFile formName="PoolClient"/>
       </formsDirectory>
       <layoutsDirectory enabled="false"/>
       <modelsDirectory>
diff --git a/application/controllers/PoolController.php b/application/controllers/PoolController.php
index 27e81a3..f4287cb 100644
--- a/application/controllers/PoolController.php
+++ b/application/controllers/PoolController.php
@@ -12,6 +12,10 @@ class PoolController extends Zend_Controller_Action
     {
         $poolMapper = new Application_Model_PoolMapper();
         $this->view->pools = $poolMapper->fetchAll();
+		
+		$poolentriesMapper = new Application_Model_PoolEntriesMapper();
+		print_a($poolentriesMapper->findBy('poolID',1));
+		
     }
 
     public function createpoolAction()
@@ -80,8 +84,51 @@ class PoolController extends Zend_Controller_Action
 
     public function linkclientAction()
     {
-        // action body
+		if(!isset($_POST['clientID'])){
+			print_a($_POST);
+			$clientmapper = new Application_Model_ClientMapper();
+			$clients = $clientmapper->fetchAll();
+			foreach($clients as $c){
+				#$client = new Application_Model_Client($c);
+				$clientsArray[] = $c->toArray();
+			}
+			$assignedclientmapper = new Application_Model_PoolEntriesMapper();
+			$assignedclients = $assignedclientmapper->fetchAll();
+			foreach($assignedclients as $c){
+				$assignedclientsArray[] = $c->toArray();
+			}
+			$freeclients  = $this->arrayDiff($clientsArray,$assignedclientsArray);
+
+			$poolclient = new Application_Form_PoolClient(array('clients'=> $freeclients)); 		
+			$this->view->poolclient = $poolclient;
+		}else {
+			#$_POST['poolID'] = $this->_request->getParam('poolID');			
+			$poolclientform = new Application_Form_PoolClient($_POST);			
+			
+			try{
+				$pool = new Application_Model_PoolEntries($_POST);
+				$pool->setPoolID($this->_request->getParam('poolID'));
+				
+				$poolmapper = new Application_Model_PoolEntriesMapper();
+				$poolmapper->save($pool);
+				$this->_redirect('/pool');			    	
+			}catch (Zend_Exception $e) {  
+    			echo "Error message 2: " . $e->getMessage() . "\n";  
+    		}
+			
+		}
     }
+	private function arrayDiff($a, $b){
+		foreach($a as $k1 => $i1){
+			foreach($b as $k2 => $i2){
+				if($i1['clientID'] == $i2['clientID']){
+					unset($a[$k1]);
+				}
+			}
+		}
+		return $a;
+	}
+	
 
     public function unlinkclientAction()
     {
diff --git a/application/forms/PoolClient.php b/application/forms/PoolClient.php
new file mode 100644
index 0000000..7bacae0
--- /dev/null
+++ b/application/forms/PoolClient.php
@@ -0,0 +1,31 @@
+<?php
+
+class Application_Form_PoolClient extends Zend_Form
+{
+	private $clients;
+
+    public function init()
+    {
+        $this->setName("addClientToPool");
+		$this->setMethod('post');
+		
+		$clientfield = $this->createElement('select','clientID');
+        $clientfield ->setLabel('Client:');
+		foreach($this->clients as $c){
+			$clientfield->addMultiOption($c['clientID'],$c['macadress']." - ".$c['hardwarehash']);
+		}            	
+		$this->addElement($clientfield);
+ 		
+		$this->addElement('submit', 'add', array(
+            'required' => false,
+            'ignore'   => true,
+            'label'    => 'Save',
+        ));  
+    }
+	public function setClients($clients){
+		$this->clients = $clients;
+		return $this;
+	}
+	
+}
+
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 632d578..83e00fc 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..350f081 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)) {
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/PoolEntriesMapper.php b/application/models/PoolEntriesMapper.php
index d730fb8..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)) {
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 be096b7..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)) {
@@ -83,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)) {
diff --git a/application/views/scripts/pool/linkclient.phtml b/application/views/scripts/pool/linkclient.phtml
index 1cc06e4..cbd2dd4 100644
--- a/application/views/scripts/pool/linkclient.phtml
+++ b/application/views/scripts/pool/linkclient.phtml
@@ -1 +1,3 @@
-<br /><br /><center>View script for controller <b>Pool</b> and script/action name <b>linkclient</b></center>
\ No newline at end of file
+<h1>Link Clients</h1>
+<?php
+echo $this->poolclient;