// +---------------------------------------------------------------------- namespace App\Services; use App\Models\MemberModel; use App\Models\RechargeModel; /** * 充值记录管理-服务类 * @author wesmiler * @since 2020/11/11 * Class RechargeService * @package App\Services */ class RechargeService extends BaseService { /** * 构造函数 * @author wesmiler * @since 2020/11/11 * RechargeService constructor. */ public function __construct() { $this->model = new RechargeModel(); } /** * 获取订单信息 * @param $orderSn * @return array */ public function orderInfo($orderSn){ $info = $this->model::where(['order_sn'=> $orderSn, 'mark'=> 1]) ->whereIn('status',[1,2]) ->select(['id','order_sn as out_trade_no','user_id','pay_money','money as total','status']) ->first(); $info = $info? $info->toArray() : []; if($info){ $info['type'] = 2; $info['pay_money'] = $info['pay_money']? $info['pay_money'] : $info['total']; } return $info; } /** * 获取列表 * @return array * @since 2020/11/11 * @author wesmiler */ public function getList() { $params = request()->all(); $page = isset($params['pageSize']) ? intval($params['pageSize']) : PAGE; $pageSize = isset($params['pageSize']) ? intval($params['pageSize']) : PERPAGE; $dataList = $this->model::from('recharge_logs as a') ->leftJoin('member as m', 'm.id', '=', 'a.user_id') ->where(function ($query) use ($params) { $query->where('a.mark', 1); $type = isset($params['type']) ? $params['type'] : 0; if ($type > 0) { $query->where('a.type', $type); } $payType = isset($params['pay_type']) ? $params['pay_type'] : 0; if ($payType > 0) { $query->where('a.pay_type', $payType); } $userId = isset($params['user_id']) ? $params['user_id'] : 0; if ($userId > 0) { $query->where('a.user_id', $userId); } $datetime = isset($params['datetime'])? $params['datetime'] : []; $dateStart = $datetime && isset($datetime[0])? $datetime[0] : ''; $dateEnd = isset($datetime[1])? $datetime[1] : ''; if($dateStart && $dateEnd && $dateEnd> $dateStart){ $query->where('a.create_time', '>', strtotime($dateStart))->where('a.create_time','<=', strtotime($dateEnd)+86399); }else if($dateStart && $dateStart == $dateEnd){ $query->where('a.create_time', '>=', strtotime($dateStart))->where('a.create_time','<=', strtotime($dateStart)+86399); }else if ($dateStart){ $query->where('a.create_time', '<=', strtotime($dateStart)+86399); } $status = isset($params['status']) ? $params['status'] : 0; if ($status > 0) { $query->where('a.status', $status); } else { $query->whereIn('a.status', [1, 2]); } }) ->where(function ($query) use ($params) { $keyword = isset($params['keyword']) ? trim($params['keyword']) : ''; if (!empty($keyword)) { $query->where('m.nickname','like',"%{$keyword}%") ->orWhere('a.order_sn','like',"%{$keyword}%"); } }) ->select(['a.id', 'a.user_id','a.order_sn','a.trade_no','a.pay_at', 'm.nickname','a.type','a.pay_type','a.money', 'a.balance', 'a.status', 'a.create_time', 'a.update_time','a.remark']) ->orderBy('a.create_time', 'desc') ->paginate($pageSize); $dataList = $dataList ? $dataList->toArray() : []; if ($dataList) { foreach ($dataList['data'] as &$item) { $item['create_time'] = $item['create_time'] ? datetime($item['create_time'],'Y-m-d H:i:s') : ''; } unset($item); } return [ 'code' => 0, 'success'=> true, 'msg' => '操作成功', 'count' => isset($dataList['total']) ? $dataList['total'] : 0, 'data' => isset($dataList['data']) ? $dataList['data'] : 0, ]; } /** * 添加或编辑 * @return array * @since 2020/11/11 * @author wesmiler */ public function edit() { $data = request()->all(); $data['update_time'] = time(); return parent::edit($data); // TODO: Change the autogenerated stub } /** * 获取充值配置参数 * @return array|mixed */ public function params(){ $cacheKey = "caches:recharge:params"; $data = RedisService::get($cacheKey); if($data){ return message(MESSAGE_OK, true, $data); } $meals = ConfigService::make()->getConfigByGroup(11); $rate = ConfigService::make()->getConfigByCode('recharge_rate'); $data = [ 'meals'=> $meals? array_values($meals) : [], 'rate'=> $rate? $rate : 0, ]; if($meals){ RedisService::set($cacheKey, $data, rand(300, 6000)); } return message(MESSAGE_OK, true, $data); } /** * 充值 * @param $userId * @return array */ public function pay($userId){ $params = request()->all(); $payType = isset($params['payType']) ? $params['payType'] : 0; if (!in_array($payType, [1])) { return message('支付方式暂不支持', false); } // 验证用户是否已授权 $memberInfo = MemberModel::where(['id' => $userId, 'mark' => 1, 'status' => 1]) ->select('id', 'openid', 'nickname') ->first(); $memberInfo = $memberInfo? $memberInfo->toArray() : []; $openid = isset($memberInfo['openid']) ? trim($memberInfo['openid']) : ''; if (!$memberInfo) { return message('账号已被冻结,请联系客服', false); } if (empty($openid)) { return message('账号获取授权参数失败,请退出页面重试', false); } // 获取充值比例 $cacheKey = "caches:recharge:params"; $data = RedisService::get($cacheKey); $rate = isset($data['rate'])? $data['rate'] : 0; if(empty($data) || $rate<=0){ $rate = ConfigService::make()->getConfigByCode('recharge_rate'); $rate = $rate<=0? 1: $rate; } $money = isset($params['money'])? intval($params['money']) : 0; $num = intval($rate*$money); if($money == 1){ $money = 0.01; $num = 100; } // 创建订单 $data = [ 'user_id' => $userId, 'pay_type' => $payType, 'type' => 1, 'order_sn' => get_order_num('R'), 'money' => $money, 'num' => $num, 'balance' => isset($memberInfo['coupon'])? $memberInfo['coupon'] : 0, 'create_time' => time(), 'status' => 2, ]; // 订单 if (!$oid = RechargeModel::insertGetId($data)) { return message('充值订单创建失败', false); } // 支付参数 switch ($payType) { case 1: // 微信支付 $order = [ 'openid' => $openid, 'orderNo' => $data['order_sn'], 'amount' => $data['money'], 'body' => '充值订单支付', ]; $jsapiParams = WechatService::jsapiUnifiedorder($order,'recharge'); $code = isset($jsapiParams['code']) ? $jsapiParams['code'] : ''; if ($code == 'error' || empty($jsapiParams)) { $message = isset($jsapiParams['message']) && $jsapiParams['message'] ? $jsapiParams['message'] : '订单支付处理失败'; return message($message, false); } return message('订单创建成功', true, ['id' => $oid, 'params' => $jsapiParams]); break; default: break; } return message('支付处理失败', false); } }