public function byCategoryAction() { $id = (int) $this->getRequest()->getParam('id'); $table = new Application_Model_DbTable_News(); $this->view->category = $table->categoriesTable()->find($id)->getRow(0); $this->view->select = $table->select()->where('CategoryID = ?', $id); }
public function deleteAction() { if (isset($_POST['submit'])) { $dbTable = new Application_Model_DbTable_News(); $dbTable->delete(array('id = ? ' => $_GET['id'])); header('Location: ../'); } }
public function deleteAction() { $node = $this->_table->find($id = $this->getRequest()->getPost('id'))->getRow(0)->loadTree(); if ($node->getName() != 'Uncategorized') { $node->delete(); } $news = new Application_Model_DbTable_News(); foreach ($news->findForCategory($id) as $item) { $item->categorySetByName('Uncategorized'); $item->save(); } }
public function indexAction() { //Pega as apresentações que estão no banco. $dbTablePresentation = new Application_Model_DbTable_Presentation(); $sqlPresentation = $dbTablePresentation->getText(); $this->view->presentation = $sqlPresentation; //pega as noticias do banco. $dbTableNews = new Application_Model_DbTable_News(); $sqlNews = $dbTableNews->getText(); $this->view->news = $sqlNews; $dbTableText = new Application_Model_DbTable_Text(); $sqlBlock = $dbTableText->getText(); $this->view->text = $sqlBlock; $dbTableBlock = new Application_Model_DbTable_Block(); $sqlBlock = $dbTableBlock->getText(); $this->view->block = $sqlBlock; }
public function updateAction() { $result = array("succ" => false, "desc" => "Неизвестная ошибка"); $formData = $this->getRequest()->getPost(); // если поступили данные if ($formData) { $newsObj = new Application_Model_DbTable_News(); $news = $newsObj->fetchRow('id_news = ' . $formData['id_news']); //->toArray(); // если такая новость if ($news) { $form = new Application_Form_News(); // если все валидно if ($form->isValid($formData)) { $news->header = $form->getValue('header'); $news->anons = $form->getValue('anons'); $news->context = $form->getValue('context'); $news->up_date = strtotime("now"); $news->posted = $formData['posted']; $news->save(); // save echo json_encode(['succ' => true, "data" => [$news->header, $news->anons, $news->context, $news->add_date, $news->posted]]); die; } else { echo json_encode(['succ' => false, 'desc' => "Неверно заполнены поля"]); die("no valid"); } } else { $result['desc'] = "Данной новости не существует"; } } else { /*TODO: error*/ } $result['succ'] = true; echo Zend_Json::encode($result); die; }