public function getArticleMore($category_id = null) { $obj = new Application_Model_Articles(); $where = "status='1'"; if (!is_null($category_id)) { $where .= " AND category_id='{$category_id}'"; } $entries = $obj->fetchAll($where, "title ASC"); return $entries; }
public function articleDetailAction() { //$this->_helper->viewRenderer->setNoRender(true); $blockM = new Base_View_Block(); $path = "/layouts/scripts/page/blocks/work-study-volunteer"; $blockM->removeBlock("work-study-volunteer-categories", 'work-study-volunteer'); $params = $this->getRequest()->getParams(); $article_id = $params['id']; $preview = false; $preview = $this->_getParam("preview"); $categoryM = new Application_Model_Category(); $articleM = new Application_Model_Articles(); $data = $articleM->find($article_id); if (false != $data) { $this->view->article = $data; $this->view->preview = $preview; $this->view->categoryId = $categoryId = $data->getCategoryId(); $this->view->categoryM = $categoryM->find($categoryId); $allarticles = $articleM->fetchAll("category_id = {$categoryId} and id != {$article_id}"); /** * @Added By: Mahipal Adhikari * @Added On: 29-Dec-2010 * @Description: get Article user information to display as Author */ $userM = new Application_Model_User(); $userRes = $userM->find($data->getUserId()); $Author = "Admin"; if (false !== $userRes) { $Author = $userRes->getFirstName() . " " . $userRes->getLastName(); $this->view->author = $Author; $this->view->author_username = $userRes->getUsername(); } if (count($allarticles) > 0) { $this->view->allarticles = $allarticles; $blocks = array("name" => "work-study-volunteer-articles", "order" => "8", "path" => $path); $blockM->addBlock($blocks, 'work-study-volunteer'); } } }
public function deleteAction() { $id = $this->_getParam('id'); $model = new Application_Model_Articles(); //added by Mahipal Adhikari on 5-jan-2011, move Article to deleted table before deleting permanently $db = Zend_Registry::get("db"); $sSQL = "INSERT INTO articles_deleted SELECT * FROM articles WHERE id={$id}"; $db->query($sSQL); //now delete article $model->delete("id={$id}"); $_SESSION['errorMsg'] = "Article has been deleted successfully!"; return $this->_helper->redirector('index', 'articles', "admin"); }
public function addAction() { $request = $this->getRequest(); $form = new Admin_Form_Articles(); $model = new Application_Model_Articles(); $page_id = $this->_getParam('id'); $this->view->msg = ""; if ($this->_getParam('m') == 's') { $this->view->msg = "Advice category saved successfully"; } /*-----------------------------------------*/ if ($this->getRequest()->isPost()) { if ($form->isValid($request->getPost())) { $params = $form->getValues(); $params['status'] = 1; $usersNs = new Zend_Session_Namespace("members"); $params['userId'] = $usersNs->userId; $model = new Application_Model_Articles($params); $page_id = $model->save(); $this->_helper->redirector('add', 'articles', 'admin', array('id' => $page_id, 'm' => 's')); } } $this->view->form = $form; }