Einführung einer Rightcategory

1 files changed, 99 insertions, 0 deletions

diff --git a/application/models/RightCategoryMapper.php b/application/models/RightCategoryMapper.php
new file mode 100644
index 0000000..e0e324d
--- /dev/null
+++ b/application/models/RightCategoryMapper.php
@@ -0,0 +1,99 @@
+<?php
+
+class Application_Model_RightCategoryMapper
+{
+
+	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_RightCategory');
+		}
+
+		return $this->_dbTable;
+	}
+
+	public function save(Application_Model_RightCategory $rightCategory)
+	{
+
+		$data = array('rightcategoryID'=> $rightCategory->getID() ,'title'=> $rightCategory->getTitle() );
+
+		if (null === ($id = $rightCategory->getID()) ) {
+			unset($data['rightcategoryID']);
+			$this->getDbTable()->insert($data);
+		} else {
+			$this->getDbTable()->update($data, array('rightcategoryID = ?' => $id));
+		}
+	}
+
+	public function delete(Application_Model_RightCategory  $rightCategory)
+	{
+		if (null === ($id = $rightCategory->getID()) ) {
+			return;
+		} else {
+			$this->getDbTable()->delete(array('rightcategoryID = ?' => $id));
+		}
+	}
+
+	public function find($id)
+	{
+		$result = $this->getDbTable()->find($id);
+		if (0 == count($result)) {
+			return;
+		}
+
+		$row = $result->current();
+
+		$rightCategory = new Application_Model_RightCategory();
+		$rightCategory->setID($row->rightcategoryID)->setTitle($row->title);
+		return $rightCategory;
+	}
+
+	public function fetchAll()
+	{
+		$resultSet = $this->getDbTable()->fetchAll();
+		$entries   = array();
+		foreach ($resultSet as $row) {
+			$entry = new Application_Model_RightCategory();
+
+			$entry->setID($row->rightcategoryID)->setTitle($row->title);
+			$entries[] = $entry;
+		}
+		return $entries;
+	}
+
+
+
+}
+