public static function getStaticContent($identifire) { $model = new Application_Model_Advice(); $where = "identifire='{$identifire}'"; $row = $model->fetchRow($where); return $row; }
public function statusAction() { $id = $this->_getParam('id'); $model = new Application_Model_Advice(); $val = $model->find($id); if ($val->getStatus() == 1) { $val->setStatus(0); } else { $val->setStatus(1); } $val->save(); return $this->_helper->redirector('index', 'advice', "admin"); }
/** * @Created By : Mahipal Singh Adhikari * @Created On : 10-Feb-2011 * Description : Search advice */ public function searchAction() { $params = $this->getRequest()->getParams(); $where = "status='1'"; $order = "addedon DESC"; $categoryM = new Application_Model_Category(); //search by keyword if (isset($params['search-strg'])) { if ($params['search-strg'] != '' && $params['search-strg'] != 'Search by Keyword') { $keyword = $params['search-strg']; $where .= " AND (title LIKE '%{$keyword}%' OR content LIKE '%{$keyword}%' OR synopsis LIKE '%{$keyword}%')"; $this->view->searchstr = $keyword; } } //search by category if (isset($params['category_id']) && $params['category_id'] != '') { $this->view->category_id = $category_id = $params['category_id']; $categorydata = $categoryM->find($category_id); $category_id = $categorydata->getId(); $this->view->categoryName = $categorydata->getName(); $where .= " AND category_id = {$category_id}"; } $adviceM = new Application_Model_Advice(); //$settings = new Admin_Model_GlobalSettings(); //$page_size = $settings->settingValue('pagination_size'); //$page_size = 1; //$page = $this->_getParam('page',1); //$pageObj = new Base_Paginator(); //$paginator = $pageObj->fetchPageData($adviceM, $page, $page_size, $where); //$this->view->total = $pageObj->getTotalCount(); //$this->view->advices = $paginator; $adviceRes = $adviceM->fetchAll($where, $order); $this->view->total = count($adviceRes); $this->view->advices = $adviceRes; $this->view->categoryM = $categoryM; }