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;
}
