1 files changed, 103 insertions, 0 deletions
diff --git a/application/models/PasswordRecoveryMapper.php b/application/models/PasswordRecoveryMapper.php
new file mode 100644
index 0000000..bfe16e8
--- /dev/null
+++ b/application/models/PasswordRecoveryMapper.php
@@ -0,0 +1,103 @@
+<?php
+
+class Application_Model_PasswordRecoveryMapper
+{
+	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)) {
+			$dbTable = new $dbTable();
+		}
+
+		if (!$dbTable instanceof Zend_Db_Table_Abstract) {
+			throw new Exception('Invalid table data gateway provided');
+		}
+
+		$this->_dbTable = $dbTable;
+
+		return $this;
+	}
+
+	public function getDbTable()
+	{
+		if (null === $this->_dbTable) {
+			$this->setDbTable('Application_Model_DbTable_PasswordRecovery');
+		}
+
+		return $this->_dbTable;
+	}
+
+	public function save(Application_Model_PasswordRecovery $passwordrecovery)
+	{
+
+		$data = array('personID'=> $passwordrecovery->getID() ,'recoveryID'=> $passwordrecovery->getRecoveryID() );
+
+		if (null === ($id = $passwordrecovery->getID()) ) {
+			return;
+		} else {
+			$passwordRecoveryFound = $this->find($passwordrecovery->getID());
+			if(is_object($passwordRecoveryFound)) {
+				$personIDFound = $passwordRecoveryFound->getID();
+			}
+			if(isset($personIDFound)) {
+				$this->getDbTable()->update($data, array('personID = ?' => $passwordrecovery->getID()));
+			} else {
+				$this->getDbTable()->insert($data);
+			}
+		}
+	}
+
+	public function delete(Application_Model_PasswordRecovery $passwordrecovery)
+	{
+		if (null === ($id = $passwordrecovery->getID()) ) {
+			return;
+		} else {
+			$this->getDbTable()->delete(array('personID = ?' => $id));
+		}
+	}
+
+	public function find($id)
+	{
+		$result = $this->getDbTable()->find($id);
+		if (0 == count($result)) {
+			return;
+		}
+
+		$row = $result->current();
+
+		$passwordrecovery = new Application_Model_PasswordRecovery();
+		$passwordrecovery->setID($row->personID)->setRecoveryID($row->recoveryID);
+		return $passwordrecovery;
+	}
+
+	public function fetchAll()
+	{
+		$resultSet = $this->getDbTable()->fetchAll();
+		$entries   = array();
+		foreach ($resultSet as $row) {
+			$entry = new Application_Model_PasswordRecovery();
+
+			$entry->setID($row->personID)->setRecoveryID($row->recoveryID);
+
+			$entries[] = $entry;
+		}
+		return $entries;
+	}
+}
+