public function ajaxAction() { $id = $this->_request->getParam('id'); $model = new Model_DbTable_Sum(); $res = $model->fetchAll($model->select()->where('aimagid = ' . $id)->order('name')); $ret = array(); foreach ($res as $key => $value) { $ret[] = array('id' => $value->id, 'name' => $value->name); } echo Zend_Json::encode($ret); }
public function removeAction() { $id = $this->_request->getParam('id'); $uid = Zend_Registry::get('uid'); $aimag = new Model_DbTable_Aimag(); if (Zend_Registry::get('role') == 'moderators' || Zend_Registry::get('role') == 'admins') { $aimag->delete('id = ' . $id); $sum = new Model_DbTable_Sum(); $sum->delete('aimagid = ' . $id); } $this->_redirect('aimag/index'); }
public function addAction() { $form = new Form_Sum(); $request = $this->getRequest(); if ($request->isPost()) { if ($form->isValid($this->_request->getPost())) { $sumname = $this->_request->getParam('name'); $aimagname = $this->_request->getParam('aimag'); $aimags = new Model_DbTable_Aimag(); $aimag = $aimags->fetchAll($aimags->select()->where('name = ?', $aimagname)); foreach ($aimag as $val) { $aimagid = $val["id"]; } $news = new Model_DbTable_Sum(); $news->insert(array('aimagid' => $aimagid, 'name' => $sumname)); $this->_redirect('sum/index'); } } $form->setAction('add'); $this->view->form = $form; }