public static function deleteByUrl($url) { $db = FrontController::getInstance()->getDbAdapter(); $navigationItem = new Navigation_Model_Item(); $query = "SELECT * FROM {$navigationItem->table} WHERE url = {$db->quote($url)}"; $rows = $db->fetchAll($query); $numRows = count($rows); for ($i = 0; $i < $numRows; $i++) { $navigationItem->setRow($rows[$i]); $navigationItem->delete(); } }
public function delete($doAudit = true) { // get top level items and delete them, which will delete all children $itemTable = new Navigation_Model_Db_Item(); $select = $itemTable->select()->where('trackId = ?', $this->row->trackId)->where('parentId = 0'); $rows = $itemTable->fetchAll($select); $numRows = count($rows); if ($numRows) { for ($i = 0; $i < $numRows; $i++) { $item = new Navigation_Model_Item(); $item->row = $rows[$i]; $item->delete($doAudit); } } parent::delete($doAudit); }
public function indexAction() { echo $this->getLinks(); echo 'this is the index'; $track = new Navigation_Model_Track(2); echo $track->getHtml('test-track'); // $track->save(); $item = new Navigation_Model_Item(); $item->setRow(array( 'trackId' => 1, 'title' => 'test item' )); // $item->save(); // show_array($item->errors); }
public function deleteItemAction() { $items = Redokes_Controller_Front::getInstance()->getParam('items', '[]'); $items = json_decode($items, true); for ($i = 0; $i < count($items); $i++) { $itemId = intval($items[$i]['itemId']); $trackId = intval($items[$i]['trackId']); if ($trackId) { if ($itemId) { // deleting an item $item = new Navigation_Model_Item($itemId); $item->delete(); $track = new Navigation_Model_Track($item->row->trackId); $track->clearCache(); } else { // deleting an entire track $track = new Navigation_Model_Track($trackId); $track->clearCache(); $track->delete(); } } } }