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_MemberCard(); $entry->setId($row->id)->setName($row->name)->setOprice($row->oprice)->setDprice($row->dprice)->setPoints($row->points)->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(); $cards = array(); if (count($data) > 0) { foreach ($data as $da) { $cardModel = new Application_Model_O_MemberCard(); $cardModel->setId($da->id)->setName($da->name)->setOprice($da->oprice)->setDprice($da->dprice)->setPoints($da->points)->setCtime($da->ctime)->setUtime($da->utime)->setStatus($da->status); array_push($cards, $cardModel); } } $res = array('cards' => $cards, 'pages' => $pages); return $res; }
public function asyncajaxAction() { $this->getResponse()->setHeader('Content-Type', 'application/json'); $this->_helper->viewRenderer->setNoRender(true); $this->_helper->layout()->disableLayout(); $params = $this->_getAllParams(); //echo "<pre>";var_dump($params);exit; $card = new Application_Model_O_MemberCard(); $validate = new Yy_Validate_Value(); if ($validate->isValid($params['id'])) { $card->setId($params['id']); } else { $card->setCtime(date('Y-m-d H:i:s')); } if ($validate->isValid($params['name'])) { $card->setName($params['name']); } if ($validate->isValid($params['oprice'])) { $card->setOprice($params['oprice']); } if ($validate->isValid($params['dprice'])) { $card->setDprice($params['dprice']); } if ($validate->isValid($params['points'])) { $card->setPoints($params['points']); } if ($validate->isValid($params['status'])) { $card->setStatus($params['status']); } try { $card->save(); $id = $card->getId(); $url = '/card/view?id=' . $id; $this->redirect($url); } catch (Zend_Db_Exception $e) { //$this->redirect('/error'); $this->redirect('/error?message=' . $e->getMessage()); } }