public function getMenuXML()
{
$menu_pages = $this->fetchAll(array('active = 1', "type = 'page'"), 'order');
$news = new App_Model_News();
$menu_news = $news->fetchAll(array('active = 1'), 'created DESC', 10);
$posts = new App_Model_Posts();
$menu_posts = $posts->fetchAll(array('active = 1'), 'created DESC', 10);
Zend_Debug::dump($menu_pages, 'Pages');
}
public function editAction()
{
$id = (int) $this->getRequest()->getParam('id');
$form = new Admin_Form_News_Edit();
$model = new App_Model_News();
if ($this->getRequest()->isPost()) {
if ($form->isValid($this->getRequest()->getPost())) {
$model->updateNews($form->getValues(), $id);
$this->_helper->flashMessenger->addMessage('Edited');
return $this->_redirect('/admin/news');
}
}
if ($id > 0) {
$news = $model->fetchRow('id=' . $id);
$form->populate($news->toArray());
}
$this->view->form = $form;
}
/**
* @before _secured, _admin
*/
public function index()
{
$view = $this->getActionView();
$latestnews = App_Model_News::all(array('active = ?' => true), array('author', 'title', 'shortBody', 'created'), array('created' => 'DESC'), 8);
$latestgallery = App_Model_Gallery::all(array('active = ?' => true), array('title', 'created', 'isPublic'), array('created' => 'DESC'), 10);
$latestmembers = App_Model_User::all(array('active = ?' => true, 'role = ?' => 'role_member'), array('firstname', 'lastname', 'imgThumb', 'created'), array('created' => 'DESC'), 10);
$latestdogs = App_Model_Dog::fetchAllLimit();
$view->set('latestnews', $latestnews)->set('latestgallery', $latestgallery)->set('latestmembers', $latestmembers)->set('latestdogs', $latestdogs);
}
/**
*
* @param type $urlkey
*/
public function detail($urlkey)
{
$view = $this->getActionView();
$layoutView = $this->getLayoutView();
$news = App_Model_News::first(array('urlKey = ?' => $urlkey, 'active = ?' => true));
if (null === $news) {
$view->warningMessage(self::ERROR_MESSAGE_2);
$this->_willRenderActionView = false;
self::redirect('/aktuality');
}
$this->_checkMetaData($layoutView, $news);
$layoutView->set('article', 1)->set('artcreated', $news->getCreated())->set('artmodified', $news->getModified());
$view->set('news', $news);
}
public function getMenuXML()
{
$this->_name = 'page_test';
$menu_pages = $this->fetchAll(array('active = 1', "type = 'page'"), 'created ASC');
$news = new App_Model_News();
$menu_news = $news->fetchAll(array('active = 1'), 'created DESC', 10);
$posts = new App_Model_Posts();
$menu_posts = $posts->fetchAll(array('active = 1'), 'created DESC', 10);
$i = 0;
foreach ($menu_pages as $row) {
$this->menuRecursion($row);
}
return $this->menuArray;
Zend_Debug::dump($this->menuArray, 'Pages');
}
/**
*
* @param type $page
*/
public function index()
{
$view = $this->getActionView();
$layoutView = $this->getLayoutView();
$config = Registry::get('configuration');
$content = $this->getCache()->get('news-1');
$npp = $config->news_per_page;
if (NULL !== $content) {
$news = $content;
} else {
$news = App_Model_News::all(array('active = ?' => true, 'expirationDate >= ?' => date('Y-m-d H:i:s')), array('id', 'urlKey', 'author', 'title', 'shortBody', 'created', 'rank'), array('rank' => 'desc', 'created' => 'DESC'), (int) $npp, 1);
$this->getCache()->set('news-1', $news);
}
$newsCount = App_Model_News::count(array('active = ?' => true, 'expirationDate >= ?' => date('Y-m-d H:i:s')));
$newsPageCount = ceil($newsCount / $npp);
$view->set('newsbatch', $news)->set('newspagecount', $newsPageCount);
$canonical = 'http://' . $this->getServerHost() . '/';
$layoutView->set('canonical', $canonical);
}
public function viewAction()
{
$title = $this->getRequest()->getParam('item');
$model = new App_Model_News();
$this->view->news = $model->fetchRow(array("title ='" . $title . "'"));
}
/**
* @before _secured, _admin
*/
public function load()
{
$this->willRenderActionView = false;
$this->willRenderLayoutView = false;
$page = (int) RequestMethods::post('page', 0);
$search = RequestMethods::issetpost('sSearch') ? RequestMethods::post('sSearch') : '';
if ($search != '') {
$whereCond = "nw.created='?' OR nw.expirationDate='?' " . "OR nw.author LIKE '%%?%%' OR nw.title LIKE '%%?%%'";
$query = App_Model_News::getQuery(array('nw.id', 'nw.author', 'nw.title', 'nw.expirationDate', 'nw.active', 'nw.created'))->wheresql($whereCond, $search, $search, $search, $search);
if (RequestMethods::issetpost('iSortCol_0')) {
$dir = RequestMethods::issetpost('sSortDir_0') ? RequestMethods::post('sSortDir_0') : 'asc';
$column = RequestMethods::post('iSortCol_0');
if ($column == 0) {
$query->order('nw.id', $dir);
} elseif ($column == 2) {
$query->order('nw.title', $dir);
} elseif ($column == 3) {
$query->order('nw.author', $dir);
} elseif ($column == 4) {
$query->order('nw.expirationDate', $dir);
} elseif ($column == 5) {
$query->order('nw.created', $dir);
}
} else {
$query->order('nw.id', 'desc');
}
$limit = (int) RequestMethods::post('iDisplayLength');
$query->limit($limit, $page + 1);
$news = App_Model_News::initialize($query);
$countQuery = App_Model_News::getQuery(array('nw.id'))->wheresql($whereCond, $search, $search, $search, $search);
$newsCount = App_Model_News::initialize($countQuery);
unset($countQuery);
$count = count($newsCount);
unset($newsCount);
} else {
$query = App_Model_News::getQuery(array('nw.id', 'nw.author', 'nw.title', 'nw.expirationDate', 'nw.active', 'nw.created'));
if (RequestMethods::issetpost('iSortCol_0')) {
$dir = RequestMethods::issetpost('sSortDir_0') ? RequestMethods::post('sSortDir_0') : 'asc';
$column = RequestMethods::post('iSortCol_0');
if ($column == 0) {
$query->order('nw.id', $dir);
} elseif ($column == 2) {
$query->order('nw.title', $dir);
} elseif ($column == 3) {
$query->order('nw.author', $dir);
} elseif ($column == 4) {
$query->order('nw.expirationDate', $dir);
} elseif ($column == 5) {
$query->order('nw.created', $dir);
}
} else {
$query->order('nw.id', 'desc');
}
$limit = (int) RequestMethods::post('iDisplayLength');
$query->limit($limit, $page + 1);
$news = App_Model_News::initialize($query);
$count = App_Model_News::count();
}
$draw = $page + 1 + time();
$str = '{ "draw": ' . $draw . ', "recordsTotal": ' . $count . ', "recordsFiltered": ' . $count . ', "data": [';
$returnArr = array();
if ($news !== null) {
foreach ($news as $_news) {
if ($_news->active) {
$label = "<span class='labelProduct labelProductGreen'>Aktivní</span>";
} else {
$label = "<span class='labelProduct labelProductRed'>Neaktivní</span>";
}
$arr = array();
$arr[] = "[ \"" . $_news->getId() . "\"";
$arr[] = "\"" . $_news->getTitle() . "\"";
$arr[] = "\"" . $_news->getAuthor() . "\"";
$arr[] = "\"" . $_news->getExpirationDate() . "\"";
$arr[] = "\"" . $_news->getCreated() . "\"";
$arr[] = "\"" . $label . "\"";
$tempStr = "\"<a href='/admin/news/edit/" . $_news->id . "' class='btn btn3 btn_pencil' title='Upravit'></a>";
if ($this->isAdmin()) {
$tempStr .= "<a href='/admin/news/delete/" . $_news->id . "' class='btn btn3 btn_trash ajaxDelete' title='Smazat'></a>";
}
$arr[] = $tempStr . "\"]";
$returnArr[] = join(',', $arr);
}
$str .= join(',', $returnArr) . "]}";
echo $str;
} else {
$str .= "[ \"\",\"\",\"\",\"\",\"\",\"\",\"\"]]}";
echo $str;
}
}