store_info['store_id']); $order_key = input('post.order_sn'); if (preg_match('/^\d{10,20}$/', $order_key)) { $condition[] = array('order_sn', '=', $order_key); } elseif ($order_key != '') { $condition[] = array('goods_name', 'like', '%' . $order_key . '%'); } $state_type = input('post.state_type'); if ($state_type != '') { $condition[] = array('order_state', '=', str_replace( $allow_state_array = array('state_new', 'state_pay', 'state_success', 'state_cancel'), array(ORDER_STATE_NEW, ORDER_STATE_PAY, ORDER_STATE_SUCCESS, ORDER_STATE_CANCEL), $state_type)); } $query_start_date = input('post.query_start_date'); $query_end_date = input('post.query_end_date'); $if_start_date = preg_match('/^20\d{2}-\d{2}-\d{2}$/', $query_start_date); $if_end_date = preg_match('/^20\d{2}-\d{2}-\d{2}$/', $query_end_date); $start_unixtime = $if_start_date ? strtotime($query_start_date) : null; $end_unixtime = $if_end_date ? strtotime($query_end_date) : null; if ($start_unixtime || $end_unixtime) { $condition[] = array('add_time', 'time', array($start_unixtime, $end_unixtime)); } if (input('post.skip_off') == 1) { $condition[] = array('order_state', '<>', ORDER_STATE_CANCEL); } $order_list = $vrorder_model->getVrorderList($condition, $this->pagesize, '*', 'order_id desc'); $mobile_page = $vrorder_model->page_info; foreach ($order_list as $key => $order) { //显示取消订单 $order_list[$key]['if_cancel'] = $vrorder_model->getVrorderOperateState('store_cancel', $order); $order_list[$key]['goods_image_url'] = goods_cthumb($order['goods_image'], 240, $order['store_id']); } $result = array_merge(array('order_list' => $order_list), mobile_page($mobile_page)); ds_json_encode(10000, '', $result); } /** * @api {POST} api/Sellervrorder/order_cancel 取消虚拟订单 * @apiVersion 1.0.0 * @apiGroup Sellervrorder * * @apiHeader {String} X-DS-KEY 卖家授权token * * @apiParam {String} order_id 订单id * @apiParam {String} reason 理由 * * @apiSuccess {String} code 返回码,10000为成功 * @apiSuccess {String} message 返回消息 * @apiSuccess {Object} result 返回数据 */ public function order_cancel() { $order_id = intval(input('post.order_id')); $reason = input('post.reason'); $vrorder_model = model('vrorder'); $logic_vrorder = model('vrorder', 'logic'); $condition = array(); $condition[] = array('order_id','=',$order_id); $condition[] = array('store_id','=',$this->store_info['store_id']); $order_info = $vrorder_model->getVrorderInfo($condition); $if_allow = $vrorder_model->getVrorderOperateState('store_cancel', $order_info); if (!$if_allow) { return callback(false, lang('have_right_operate')); } try { Db::startTrans(); $logic_vrorder->changeOrderStateCancel($order_info, 'seller', $reason, true); if (!empty($order_info['deduction_amount']) && $order_info['card_id'] != 0) { //这两个都满足的情况下,走退款 删除支付记录里的订单关联数据 //1.回滚卡片余额 $cardWhere = []; $cardWhere[] = ['id', '=', $order_info['card_id']]; $cardWhere[] = ['member_id', '=', $this->member_info['member_id']]; $cardInfo = Db::name('sub_card')->where($cardWhere)->find(); if (($cardInfo['balance'] + $order_info['deduction_amount']) == $cardInfo['worth']) { $cardStatus = 1; } else { $cardStatus = 2; } $cardUpdate = [ 'card_status' => $cardStatus, 'balance' => $cardInfo['balance'] + $order_info['deduction_amount'], 'freeze' => $cardInfo['freeze'] - $order_info['deduction_amount'], 'update_time' => time(), 'used_count' => $cardInfo['used_count'] - 1, ]; $cardRes = Db::name('sub_card')->where($cardWhere)->update($cardUpdate); if ($cardRes) { //如果卡的数据恢复成功了 删除卡的消费记录 Db::name('sub_card_expense')->where([ ['card_id', '=', $cardInfo['id']], ['order_id', '=', $order_info['order_id']], ])->update(['expense_status' => 2]); } } } catch (\Exception $e) { Db::rollback(); ds_json_encode(10001, $e->getMessage()); } Db::commit(); ds_json_encode(10000, '', 1); } /** * @api {POST} api/Sellervrorder/exchange 兑换码消费 * @apiVersion 1.0.0 * @apiGroup Sellervrorder * * @apiHeader {String} X-DS-KEY 卖家授权token * * @apiParam {String} vr_code 兑换码 * * @apiSuccess {String} code 返回码,10000为成功 * @apiSuccess {String} message 返回消息 * @apiSuccess {Object} result 订单信息 (返回字段参考vrorder) */ public function exchange() { $vr_code = input('param.vr_code'); if ($vr_code) { if (!preg_match('/^[a-zA-Z0-9]{15,18}$/', $vr_code)) { ds_json_encode(10001, lang('exchange_code_format_error')); } $vrorder_model = model('vrorder'); $vr_code_info = $vrorder_model->getVrordercodeInfo(array('vr_code' => $vr_code)); if (empty($vr_code_info) || $vr_code_info['store_id'] != $this->store_info['store_id']) { ds_json_encode(10001, lang('exchange_code_not_exist')); } if ($vr_code_info['vr_state'] == '1') { ds_json_encode(10001, lang('exchange_code_been_used')); } if ($vr_code_info['vr_indate'] < TIMESTAMP) { ds_json_encode(10001, lang('exchange_code_expired') . date('Y-m-d H:i:s', $vr_code_info['vr_indate'])); } if ($vr_code_info['refund_lock'] > 0) {//退款锁定状态:0为正常,1为锁定(待审核),2为同意 ds_json_encode(10001, lang('exchange_code_been_applied_refund')); } //更新兑换码状态 $update = array(); $update['vr_state'] = 1; $update['vr_usetime'] = TIMESTAMP; $update = $vrorder_model->editVrorderCode($update, array('vr_code' => $vr_code)); //如果全部兑换完成,更新订单状态 model('vrorder', 'logic')->changeOrderStateSuccess($vr_code_info['order_id']); if ($update) { //取得返回信息 $order_info = $vrorder_model->getVrorderInfo(array('order_id' => $vr_code_info['order_id'])); if ($order_info['use_state'] == '0') { $vrorder_model->editVrorder(array('use_state' => 1), array('order_id' => $vr_code_info['order_id'])); } $order_info['img_240'] = goods_thumb($order_info, 240); ds_json_encode(10000, lang('exchange_successful'), $order_info); } } else { ds_json_encode(10001, lang('param_error')); } } /** * @api {POST} api/Sellervrorder/order_info 虚拟订单详情 * @apiVersion 1.0.0 * @apiGroup Sellervrorder * * @apiHeader {String} X-DS-KEY 卖家授权token * * @apiParam {String} order_id 订单id * * @apiSuccess {String} code 返回码,10000为成功 * @apiSuccess {String} message 返回消息 * @apiSuccess {Object} result 返回数据 (返回字段参考vrorder) */ public function order_info() { $order_id = intval(input('param.order_id')); if ($order_id <= 0) { ds_json_encode(10001, lang('param_error')); } $vrorder_model = model('vrorder'); $condition = array(); $condition[] = array('order_id','=',$order_id); $condition[] = array('store_id','=',$this->store_info['store_id']); $order_info = $vrorder_model->getVrorderInfo($condition); if (empty($order_info) || $order_info['delete_state'] == ORDER_DEL_STATE_DROP) { ds_json_encode(10001, lang('store_order_none_exist')); } $order_list = array(); $order_list[$order_id] = $order_info; //显示取消订单 $order_info['if_cancel'] = $vrorder_model->getVrorderOperateState('buyer_cancel', $order_info); $order_info['goods_image_url'] = goods_cthumb($order_info['goods_image'], 240, $order_info['store_id']); $ownShopIds = model('store')->getOwnShopIds(); $order_info['ownshop'] = in_array($order_info['store_id'], $ownShopIds); $order_info['vr_indate'] = $order_info['vr_indate'] ? date('Y-m-d', $order_info['vr_indate']) : ''; $order_info['add_time'] = date('Y-m-d', $order_info['add_time']); $order_info['payment_time'] = $order_info['payment_time'] ? date('Y-m-d', $order_info['payment_time']) : ''; $order_info['finnshed_time'] = $order_info['finnshed_time'] ? date('Y-m-d', $order_info['finnshed_time']) : ''; //取兑换码列表 $vr_code_list = $vrorder_model->getShowVrordercodeList(array('order_id' => $order_info['order_id'])); $order_info['code_list'] = $vr_code_list ? $vr_code_list : array(); ds_json_encode(10000, '', array('order_info' => $order_info)); } } ?>