BootOs Name anzeigen & Reihenfolge im BootMenu

1 files changed, 20 insertions, 1 deletions

diff --git a/application/models/BootMenuEntriesMapper.php b/application/models/BootMenuEntriesMapper.php
index 346664c..a837dca 100644
--- a/application/models/BootMenuEntriesMapper.php
+++ b/application/models/BootMenuEntriesMapper.php
@@ -11,7 +11,8 @@ class Application_Model_BootMenuEntriesMapper
 			$db = Zend_Db_Table::getDefaultAdapter();
 			$select = $this->getDbTable()->select() 
 				->from($this->_dbTable) 
-				->where($criteria . ' = ?', $value); 
+				->where($criteria . ' = ?', $value)
+				->order('order'); 
 			$stmt = $select->query();
 			$resultSet = $stmt->fetchAll();
 			
@@ -67,6 +68,24 @@ class Application_Model_BootMenuEntriesMapper
 		}
 	}
 	
+	public function order(Application_Model_BootMenuEntries $botmenuentries)
+	{
+		$db = Zend_Db_Table::getDefaultAdapter();
+		$stmt = $db->query("UPDATE pbs_bootmenuentries SET `order` = `order` + 1 WHERE `order` >= ". $botmenuentries->getOrder() . " AND `bootmenuID` = " . $botmenuentries->getBootmenuID());
+	}
+	
+	public function orderremove(Application_Model_BootMenuEntries $botmenuentries)
+	{
+		$db = Zend_Db_Table::getDefaultAdapter();
+		$stmt = $db->query("UPDATE pbs_bootmenuentries SET `order` = `order` - 1 WHERE `order` > ". $botmenuentries->getOrder() . " AND `bootmenuID` = " . $botmenuentries->getBootmenuID());
+	}
+	
+	public function orderedit(Application_Model_BootMenuEntries $botmenuentries, $oldval)
+	{
+		$db = Zend_Db_Table::getDefaultAdapter();
+		$stmt = $db->query("UPDATE pbs_bootmenuentries SET `order` = `order` + 1 WHERE `order` >= ". $botmenuentries->getOrder() . " AND `order` < " . $oldval . " AND `bootmenuID` = " . $botmenuentries->getBootmenuID());
+	}
+	
 	public function delete(Application_Model_BootMenuEntries $botmenuentries)
 	{
 		if (null === ($id = $botmenuentries->getID()) ) {