public static function fetchAll($where = null, $order = null, $limit = null, $offset = null) { $resultSet = self::getDbTable()->fetchAll($where, $order, $limit, $offset); $entries = array(); foreach ($resultSet as $row) { $entry = new Application_Model_O_Feedback(); $entry->setId($row->id)->setContent($row->content)->setContact($row->contact)->setCtime($row->ctime)->setUtime($row->utime)->setStatus($row->status); $entry->setNew(false); $entries[] = $entry; } return $entries; }
public static function fetchAllPage($page = 1, $perpage = 30) { $select = self::select(); $adapter = new Zend_Paginator_Adapter_DbTableSelect($select); $paginator = new Zend_Paginator($adapter); $paginator->setItemCountPerPage($perpage)->setCurrentPageNumber($page); $data = $paginator->getCurrentItems(); $pages = $paginator->count(); $feedbacks = array(); if (count($data) > 0) { foreach ($data as $da) { $feedbackModel = new Application_Model_O_Feedback(); $feedbackModel->setId($da->id)->setContent($da->content)->setContact($da->contact)->setCtime($da->ctime)->setUtime($da->utime)->setStatus($da->status); array_push($feedbacks, $feedbackModel); } } $res = array('feedbacks' => $feedbacks, 'pages' => $pages); return $res; }
public function feedbackAction() { $content = $this->_getParam('content'); $contact = $this->_getParam('contact'); if (!$content && !$contact) { $out['errno'] = '1'; $out['msg'] = Yy_ErrMsg_More::getMsg('feedback', $out['errno']); Yy_Utils::jsonOut($out); return; } $feedback = new Application_Model_O_Feedback(); $feedback->setContent($content)->setContact($contact)->setCtime(date('Y-m-d H:i:s'))->setStatus(1); try { Application_Model_M_Feedback::save($feedback); $out['errno'] = '0'; } catch (Zend_Db_Exception $e) { echo $e->getMessage(); $out['errno'] = '1'; } $out['msg'] = Yy_ErrMsg_More::getMsg('feedback', $out['errno']); Yy_Utils::jsonOut($out); }