public static function fetchAllPage($role, $page = 1, $perpage = 30)
{
if ($role != 0 && $role != 1 && $role != 2 && $role != 3) {
return array();
}
$select = self::select();
if ($role != 0) {
$select->where('urole = ?', $role)->order('ctime desc');
}
$adapter = new Zend_Paginator_Adapter_DbTableSelect($select);
$paginator = new Zend_Paginator($adapter);
$paginator->setItemCountPerPage($perpage)->setCurrentPageNumber($page);
$data = $paginator->getCurrentItems();
$pages = $paginator->count();
$orders = array();
if (count($data) > 0) {
foreach ($data as $da) {
$orderModel = new Application_Model_O_MemberCardOrder();
$orderModel->setId($da->id)->setOrder_id($da->order_id)->setUid($da->uid)->setUrole($da->urole)->setMember_card_id($da->member_card_id)->setTotal_price($da->total_price)->setPayment_status($da->payment_status)->setRemark($da->remark)->setCtime($da->ctime)->setUtime($da->utime)->setStatus($da->status);
array_push($orders, $orderModel);
}
}
$res = array('orders' => $orders, 'pages' => $pages);
return $res;
}
public function orderAction()
{
$id = $this->_getParam('id');
if ($this->_auth->userid && $this->_auth->role) {
$card = Application_Model_M_MemberCard::find($id);
if ($card) {
$orderid = Application_Model_M_MemberCardOrder::getOrderID($this->_auth->userid, $this->_auth->role);
$total_price = $card->getDprice();
$payment_status = 0;
$cardOrder = new Application_Model_O_MemberCardOrder();
$cardOrder->setOrder_id($orderid)->setUid($this->_auth->userid)->setUrole($this->_auth->role)->setMember_card_id($id)->setTotal_price($total_price)->setPayment_status($payment_status)->setCtime(date('Y-m-d H:i:s'));
try {
$out['errno'] = '0';
$mer_front_end_url = "";
$deadtime = 0;
$notify_url = "http://" . $_SERVER['HTTP_HOST'] . "/card/notify";
$tn = Yy_Upmp_Upmp::getUpmpTn($orderid, $id, $total_price, $mer_front_end_url, $deadtime, $notify_url);
$cardOrder->setRemark($tn);
$cardOrder->save();
$out['tn'] = $tn;
} catch (Zend_Db_Exception $e) {
$out['errno'] = '255';
}
} else {
$out['errno'] = '1';
}
} else {
$out['errno'] = '200';
}
$out['msg'] = Yy_ErrMsg_Card::getMsg('order', $out['errno']);
Yy_Utils::jsonOut($out);
}
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_MemberCardOrder();
$entry->setId($row->id)->setOrder_id($row->order_id)->setUid($row->uid)->setUrole($row->urole)->setMember_card_id($row->member_card_id)->setTotal_price($row->total_price)->setPayment_status($row->payment_status)->setRemark($row->remark)->setCtime($row->ctime)->setUtime($row->utime)->setStatus($row->status);
$entry->setNew(false);
$entries[] = $entry;
}
return $entries;
}
