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