getDbTable()->select() ->from($this->_dbTable) ->where($criteria . ' = ?', $value) ->order('order'); $stmt = $select->query(); $resultSet = $stmt->fetchAll(); $entries = array(); foreach ($resultSet as $row) { $entry = new Application_Model_BootMenuEntries($row); $entry->setID($row['bootmenuentriesID']); $entries[] = $entry; } return $entries; }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_BootMenuEntries'); } return $this->_dbTable; } public function save(Application_Model_BootMenuEntries $botmenuentries) { $data = array('bootmenuentriesID' => $botmenuentries->getID(), 'bootosID'=> $botmenuentries->getBootosID() ,'bootmenuID'=> $botmenuentries->getBootmenuID() ,'configID'=> $botmenuentries->getConfigID() ,'title'=> $botmenuentries->getTitle() ,'kcl'=> $botmenuentries->getKcl() ,'order'=> $botmenuentries->getOrder() ); if (null === ($id = $botmenuentries->getID()) ) { unset($data['bootmenuentriesID']); $this->getDbTable()->insert($data); } else { $this->getDbTable()->update($data, array('bootmenuentriesID = ?' => $id)); } } 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 orderbefore(Application_Model_BootMenuEntries $botmenuentries, $oldval) { $db = Zend_Db_Table::getDefaultAdapter(); print_a($botmenuentries, $oldval); $stmt = $db->query("UPDATE pbs_bootmenuentries SET `order` = `order` + 1 WHERE `order` >= ". $botmenuentries->getOrder() . " AND `order` < " . $oldval . " AND `bootmenuID` = " . $botmenuentries->getBootmenuID()); } public function orderafter(Application_Model_BootMenuEntries $botmenuentries, $oldval) { $db = Zend_Db_Table::getDefaultAdapter(); print_a($botmenuentries, $oldval); $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()) ) { return; } else { $this->getDbTable()->delete(array('bootmenuentriesID = ?' => $id)); } } public function find($id, Application_Model_BootMenuEntries $botmenuentries) { $result = $this->getDbTable()->find($id); if (0 == count($result)) { return; } $row = $result->current(); $botmenuentries->setID($row->bootmenuentriesID)->setBootosID($row->bootosID)->setBootmenuID($row->bootmenuID)->setTitle($row->title)->setConfigID($row->configID)->setKcl($row->kcl)->setOrder($row->order); } public function fetchAll() { $resultSet = $this->getDbTable()->fetchAll(); $entries = array(); foreach ($resultSet as $row) { $entry = new Application_Model_BootMenuEntries(); $entry->setID($row->bootmenuentriesID)->setBootosID($row->bootosID)->setBootmenuID($row->bootmenuID)->setTitle($row->title)->setConfigID($row->configID)->setKcl($row->kcl)->setOrder($row->order); $entries[] = $entry; } return $entries; } }