summaryrefslogtreecommitdiffstats
path: root/application/models/BootMenuEntriesMapper.php
diff options
context:
space:
mode:
Diffstat (limited to 'application/models/BootMenuEntriesMapper.php')
-rw-r--r--application/models/BootMenuEntriesMapper.php21
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()) ) {