| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048 |
- <?php
- // +----------------------------------------------------------------------
- // | LARAVEL8.0 框架 [ LARAVEL ][ RXThinkCMF ]
- // +----------------------------------------------------------------------
- // | 版权所有 2017~2021 LARAVEL研发中心
- // +----------------------------------------------------------------------
- // | 官方网站: http://www.laravel.cn
- // +----------------------------------------------------------------------
- // | Author: laravel开发员 <laravel.qq.com>
- // +----------------------------------------------------------------------
- namespace App\Services\Api;
- use App\Models\GoodsModel;
- use App\Models\GoodsSkuModel;
- use App\Models\MeetingModel;
- use App\Models\MeetingRecordsModel;
- use App\Models\MemberModel;
- use App\Models\OrderGoodsModel;
- use App\Models\OrderModel;
- use App\Models\StoreModel;
- use App\Services\BaseService;
- use App\Services\ConfigService;
- use App\Services\Kd100Service;
- use App\Services\PaymentService;
- use App\Services\RedisService;
- use Illuminate\Support\Facades\DB;
- /**
- * 订单-服务类
- * @author laravel开发员
- * @since 2020/11/11
- * @package App\Services\Api
- */
- class OrderService extends BaseService
- {
- // 静态对象
- protected static $instance = null;
- /**
- * 构造函数
- * @author laravel开发员
- * @since 2020/11/11
- */
- public function __construct()
- {
- $this->model = new OrderModel();
- }
- /**
- * 静态入口
- */
- public static function make()
- {
- if (!self::$instance) {
- self::$instance = new static();
- }
- return self::$instance;
- }
- /**
- * 订单列表
- * @param $params
- * @param int $pageSize
- * @return array
- */
- public function getDataList($params, $pageSize = 15)
- {
- $model = $this->getQuery($params);
- // 数据
- $list = $model->where(function ($query) use ($params) {
- $status = isset($params['status']) ? $params['status'] : 0;
- if ($status > 0 && is_array($status)) {
- $query->whereIn('a.status', $status)->where('a.refund_status', 0);
- } else if ($status == 4) {
- $query->where('a.status', $status)->where('a.refund_status', 0);
- } else if ($status > 0) {
- $query->where('a.status', $status)->where('a.refund_status', 0);
- }
- })->select(['a.*'])
- ->orderBy('a.id', 'desc')
- ->paginate($pageSize > 0 ? $pageSize : 9999999);
- $list = $list ? $list->toArray() : [];
- if ($list) {
- $statusArr = [1 => '待支付', 2 => '待发货', 3 => '待收货', 4 => '确认收货'];
- foreach ($list['data'] as &$item) {
- $item['create_time'] = $item['create_time'] ? dateFormat(strtotime($item['create_time']), 'Y-m-d') : '';
- $status = isset($item['status']) ? $item['status'] : 0;
- $item['status_text'] = '待支付';
- if ($status) {
- $item['status_text'] = isset($statusArr[$status]) ? $statusArr[$status] : '';
- }
- if ($item['refund_status'] > 0) {
- $item['status_text'] = '退款/售后';
- }
- $item['goods'] = isset($item['goods']) && $item['goods'] ? $item['goods'] : [];
- $item['real_total'] = $item['pay_total'];
- $item['pay_total'] = moneyFormat($item['pay_total'] + $item['delivery_fee'], 2);
- }
- unset($item);
- }
- return [
- 'pageSize' => $pageSize,
- 'total' => isset($list['total']) ? $list['total'] : 0,
- 'list' => isset($list['data']) ? $list['data'] : []
- ];
- }
- /**
- * 查询条件
- * @param $params
- * @return mixed
- */
- public function getQuery($params)
- {
- $where = ['a.is_hide' => 0, 'a.mark' => 1];
- return $this->model->from('orders as a')
- ->with(['orderGoods', 'store'])
- ->leftJoin('member as b', 'b.id', '=', 'a.user_id')
- ->where($where)
- ->where(function ($query) use ($params) {
- $userId = isset($params['user_id']) ? intval($params['user_id']) : 0;
- if ($userId > 0) {
- $query->where('a.user_id', $userId);
- }
- // 关联会议
- $meetingId = isset($params['meeting_id']) ? intval($params['meeting_id']) : 0;
- if ($meetingId > 0) {
- $query->where('a.meeting_id', $meetingId);
- }
- })
- ->where(function ($query) use ($params) {
- $keyword = isset($params['keyword']) ? $params['keyword'] : '';
- if ($keyword) {
- $query->where('a.order_no', 'like', "%{$keyword}%")
- ->orWhere('b.mobile', 'like', "%{$keyword}%");
- }
- });
- }
- /**
- * 订单详情
- * @param $id
- */
- public function getOrderInfo($id, $no = '')
- {
- $where = ['a.order_no' => $no, 'a.id' => $id, 'a.mark' => 1];
- if ($no) {
- unset($where['a.id']);
- } else {
- unset($where['a.order_no']);
- }
- $statusArr = [1 => '待支付', 2 => '待发货', 3 => '待收货', 4 => '已完成'];
- $info = $this->model->from('orders as a')
- ->with(['orderGoods', 'store'])
- ->leftJoin('member as b', 'b.id', '=', 'a.user_id')
- ->where($where)
- ->select(['a.*'])
- ->first();
- if ($info) {
- $info = $info->toArray();
- $info['create_time'] = $info['create_time'] ? datetime($info['create_time'], 'Y-m-d H:i:s') : '';
- $info['pay_at'] = $info['pay_at'] ? datetime(strtotime($info['pay_at']), 'Y-m-d H:i:s') : '';
- $info['receiver_mobile_text'] = $info['receiver_mobile'] ? format_mobile($info['receiver_mobile']) : '';
- $info['real_total'] = $info['pay_total'];
- $info['pay_total'] = moneyFormat($info['pay_total'] + $info['delivery_fee'], 2);
- $status = isset($info['status']) ? $info['status'] : 0;
- $info['status_text'] = '待支付';
- if ($status) {
- $info['status_text'] = isset($statusArr[$status]) ? $statusArr[$status] : '';
- }
- }
- return $info;
- }
- /**
- * 创建订单
- * @param $userId 用户
- * @param $params 参数
- * @return array|false
- */
- public function createOrder($userId, $params)
- {
- $addressId = isset($params['address_id']) && $params['address_id'] ? $params['address_id'] : 0;
- $goods = isset($params['goods']) && $params['goods'] ? $params['goods'] : [];
- $ids = $goods ? array_column($goods, 'id') : [];
- // 参数验证
- if (empty($goods) || empty($ids)) {
- $this->error = '商品参数不为空';
- return false;
- }
- if ($addressId <= 0) {
- $this->error = '请选择收货地址';
- return false;
- }
- // 缓存锁
- $cacheLockKey = "caches:orders:submit_lock:{$userId}";
- if (RedisService::get($cacheLockKey)) {
- $this->error = '订单处理中~';
- return false;
- }
- // 用户信息
- RedisService::set($cacheLockKey, ['params' => $params, 'user_id' => $userId], rand(3, 5));
- $userInfo = MemberModel::where(['id' => $userId, 'mark' => 1])
- ->select(['id', 'openid', 'discount_point', 'status'])
- ->first();
- $status = isset($userInfo['status']) ? $userInfo['status'] : 0;
- $openid = isset($userInfo['openid']) ? $userInfo['openid'] : 0;
- $discountPoint = isset($userInfo['discount_point']) ? $userInfo['discount_point'] : 0; // 折扣
- if (empty($userInfo) || $status != 1) {
- $this->error = 1045;
- return false;
- }
- if (empty($openid)) {
- $this->error = 1042;
- return false;
- }
- // 商品数据
- $orderNo = get_order_num('JK');
- $result = GoodsService::make()->getOrderGoods($ids, $goods, $userId, $orderNo,$discountPoint);
- if (empty($result)) {
- RedisService::clear($cacheLockKey);
- $this->error = GoodsService::make()->getError();
- return false;
- }
- $orderGoods = isset($result['goods']) ? $result['goods'] : [];
- $goodsTotal = isset($result['goods_total']) ? $result['goods_total'] : 0; // 商品总价
- $orderTotal = isset($result['order_total']) ? $result['order_total'] : 0; // 订单结算金额(折后)
- $discountTotal = isset($result['discount_total']) ? $result['discount_total'] : 0; // 折扣金额
- $orderCount = isset($result['count']) ? $result['count'] : 0;
- $deliveryFee = isset($result['delivery_fee']) ? $result['delivery_fee'] : 0; // 运费
- $storeId = isset($result['store_id']) ? $result['store_id'] : 0; // 企业/商家
- if (empty($orderGoods)) {
- RedisService::clear($cacheLockKey);
- $this->error = '获取订单商品错误~';
- return false;
- }
- if ($orderTotal <= 0) {
- RedisService::clear($cacheLockKey);
- $this->error = '订单金额错误~';
- return false;
- }
- if ($orderCount <= 0) {
- RedisService::clear($cacheLockKey);
- $this->error = '订单商品数量错误~';
- return false;
- }
- // 收货地址信息
- $addressInfo = MemberAddressService::make()->getBindInfo($userId, $addressId);
- $realname = isset($addressInfo['realname']) ? $addressInfo['realname'] : '';
- $mobile = isset($addressInfo['mobile']) ? $addressInfo['mobile'] : '';
- $area = isset($addressInfo['area']) ? $addressInfo['area'] : '';
- $address = isset($addressInfo['address']) ? $addressInfo['address'] : '';
- if (empty($addressInfo) || empty($realname) || empty($mobile) || empty($area) || empty($address)) {
- RedisService::clear($cacheLockKey);
- $this->error = '收货地址信息错误,请核对后重试~';
- return false;
- }
- // 商家佣金
- $storeInfo = StoreModel::where(['id' => $storeId])->first();
- $bonusRate = isset($storeInfo['bonus_rate']) ? floatval($storeInfo['bonus_rate']) : 0;
- $storeBonusRate = ConfigService::make()->getConfigByCode('store_bonus_rate', 0);
- $storeBonusRate = $storeBonusRate > 0 && $storeBonusRate <= 100 ? $storeBonusRate : 0;
- $bonusRate = $bonusRate > 0 && $bonusRate <= 100 ? $bonusRate : $storeBonusRate;
- $bonus = moneyFormat($orderTotal * $bonusRate / 100, 2);
- // 检查是否关联为会议订单,先签到的会议先关联
- $record = MeetingRecordsModel::with(['meeting'])->where(['user_id'=>$userId,'mark'=>1])
- ->where('expired_at','>=', date('Y-m-d H:i:s'))
- ->orderBy('id', 'asc')
- ->first();
- $recordMeetingId = isset($record['meeting_id'])? $record['meeting_id'] : 0;
- $meeting = isset($record['meeting'])?$record['meeting'] : [];
- $meetingBonusRate = isset($meeting['bonus_rate'])?$meeting['bonus_rate'] : 0;
- $meetingBonusRate = $meetingBonusRate>0 && $meetingBonusRate<100? $meetingBonusRate : 0;
- $meetingBonus = moneyFormat($orderTotal * $meetingBonusRate / 100, 2);
- // 是否开启分账功能
- $payTotal = moneyFormat($orderTotal + $deliveryFee, 2); // 含运费支付金额
- $revenueOpen = ConfigService::make()->getConfigByCode('order_revenue_open', 0);
- $revenueRate = ConfigService::make()->getConfigByCode('order_revenue_rate', 30);
- $revenueRate = $revenueRate>0 && $revenueRate<100? $revenueRate: 30;
- $revenueAmount = moneyFormat($payTotal * $revenueRate/100,2);
- if (env('PAY_DEBUG')) {
- $revenueAmount = 0.01;
- $payTotal = 0.01;
- }
- // 订单数据
- $order = [
- 'order_no' => $orderNo,
- 'user_id' => $userId,
- 'store_id' => $storeId,
- 'meeting_id' => $recordMeetingId, // 关联会议
- 'total' => $goodsTotal, // 商品总价
- 'num' => $orderCount,
- 'pay_total' => $orderTotal, // 折扣后商品总价(不含运费)
- 'discount_point' => $discountPoint,
- 'discount_total' => $discountTotal, // 折扣金额
- 'delivery_fee' => $deliveryFee, // 运费
- 'receiver_name' => $realname,
- 'receiver_mobile' => $mobile,
- 'receiver_area' => $area,
- 'receiver_address' => $address,
- 'bonus' => $bonus,
- 'bonus_rate' => $bonusRate,
- 'is_revenue' => $revenueOpen==1?1: 2,
- 'revenue_no' => $revenueOpen==1?(str_replace('JK','RE',$orderNo)):'',
- 'revenue_amount' => $revenueOpen==1?$revenueAmount:0,
- 'meeting_bonus_rate' => $meetingBonusRate,
- 'meeting_bonus' => $meetingBonus,
- 'create_time' => time(),
- 'update_time' => time(),
- 'status' => 1,
- 'mark' => 1,
- ];
- // 订单处理
- DB::beginTransaction();
- if (!$orderId = $this->model->insertGetId($order)) {
- DB::rollBack();
- $this->error = '创建订单失败';
- RedisService::clear($cacheLockKey);
- return false;
- }
- // 订单商品
- if ($orderGoods && !OrderGoodsModel::insert($orderGoods)) {
- DB::rollBack();
- $this->error = '处理订单商品错误';
- RedisService::clear($cacheLockKey);
- return false;
- }
- // 获取支付参数
- /* TODO 支付处理 */
- $payOrder = [
- 'type' => 1,
- 'order_no' => $orderNo,
- 'is_revenue' => $order['is_revenue'],
- 'pay_money' => $payTotal,
- 'body' => '订单付款',
- 'openid' => $openid
- ];
- // 调起支付
- $payment = PaymentService::make()->minPay($userInfo, $payOrder, 'store');
- if (empty($payment)) {
- // DB::rollBack();
- RedisService::clear($cacheLockKey);
- $this->error = PaymentService::make()->getError();
- return false;
- }
- // 商品库存扣除
- if ($orderGoods) {
- foreach ($orderGoods as $goods) {
- $id = isset($goods['goods_id']) ? $goods['goods_id'] : 0;
- $num = isset($goods['num']) ? $goods['num'] : 0;
- $skuId = isset($goods['sku_id']) ? $goods['sku_id'] : 0;
- if ($id && !GoodsModel::where(['id' => $id])->update(['stock' => DB::raw("stock - {$num}"), 'update_time' => time()])) {
- DB::rollBack();
- RedisService::clear($cacheLockKey);
- $this->error = '商品库存处理失败';
- return false;
- }
- if ($skuId && !GoodsSkuModel::where(['id' => $skuId])->update(['stock' => DB::raw("stock - {$num}"), 'update_time' => time()])) {
- DB::rollBack();
- RedisService::clear($cacheLockKey);
- $this->error = '商品库存处理失败';
- return false;
- }
- }
- }
- // 用户操作记录
- DB::commit();
- $this->error = '订单创建成功,请前往支付~';
- RedisService::clear($cacheLockKey);
- return [
- 'order_id' => $orderId,
- 'payment' => $payment,
- 'total' => $payOrder['pay_money'],
- 'pay_type' => 10,
- ];
- }
- /**
- * 订单支付
- * @param $userId
- * @param $id
- * @return array|false
- */
- public function pay($userId, $id)
- {
- if ($id <= 0) {
- $this->error = '请选择支付订单';
- return false;
- }
- // 缓存锁
- $cacheLockKey = "caches:orders:pay_lock:{$userId}_{$id}";
- if (RedisService::get($cacheLockKey)) {
- $this->error = '订单处理中~';
- return false;
- }
- // 商品数据
- RedisService::set($cacheLockKey, ['order_id' => $id, 'user_id' => $userId], rand(3, 5));
- // 用户信息
- $userInfo = MemberModel::where(['id' => $userId, 'mark' => 1])
- ->select(['id', 'openid', 'mobile', 'nickname', 'realname', 'balance', 'status'])
- ->first();
- $status = isset($userInfo['status']) ? $userInfo['status'] : 0;
- $openid = isset($userInfo['openid']) ? $userInfo['openid'] : '';
- if (empty($userInfo) || $status != 1) {
- $this->error = 1045;
- RedisService::clear($cacheLockKey);
- return false;
- }
- if (empty($openid)) {
- $this->error = '用户微信未授权,请重新授权登录';
- RedisService::clear($cacheLockKey);
- return false;
- }
- // 订单信息
- $info = $this->model->where(['id' => $id, 'mark' => 1])
- ->select(['id', 'order_no', 'pay_total', 'delivery_fee', 'status'])
- ->first();
- $orderTotal = isset($info['pay_total']) ? $info['pay_total'] : 0;
- $deliveryFee = isset($info['delivery_fee']) ? $info['delivery_fee'] : 0;
- $orderNo = isset($info['order_no']) ? $info['order_no'] : '';
- $status = isset($info['status']) ? $info['status'] : 0;
- if (empty($info) || empty($orderNo)) {
- $this->error = '订单信息不存在';
- RedisService::clear($cacheLockKey);
- return false;
- }
- if ($status != 1) {
- $this->error = '订单已支付';
- RedisService::clear($cacheLockKey);
- return false;
- }
- // 获取支付参数
- /* TODO 支付处理 */
- $payOrder = [
- 'type' => 1,
- 'order_no' => $orderNo,
- 'pay_money' => moneyFormat($orderTotal + $deliveryFee),
- 'body' => '购物消费',
- 'openid' => $openid
- ];
- // 调起支付
- $payment = PaymentService::make()->minPay($userInfo, $payOrder, 'store');
- if (empty($payment)) {
- DB::rollBack();
- RedisService::clear($cacheLockKey);
- $this->error = PaymentService::make()->getError();
- return false;
- }
- // 用户操作记录
- DB::commit();
- $this->error = '支付请求成功,请前往支付~';
- RedisService::clear($cacheLockKey);
- return [
- 'order_id' => $id,
- 'payment' => $payment,
- 'total' => $payOrder['pay_money'],
- 'pay_type' => 10,
- ];
- }
- /**
- * 订单取消
- * @param $userId
- * @param $orderId
- * @return array|false
- */
- public function cancel($userId, $orderId)
- {
- if ($orderId <= 0) {
- $this->error = '请选择订单';
- return false;
- }
- // 缓存锁
- $cacheLockKey = "caches:orders:cancel_lock:{$userId}_{$orderId}";
- if (RedisService::get($cacheLockKey)) {
- $this->error = '订单处理中~';
- return false;
- }
- RedisService::set($cacheLockKey, ['order_id' => $orderId, 'user_id' => $userId], rand(3, 5));
- // 用户信息
- $userInfo = MemberModel::where(['id' => $userId, 'mark' => 1])
- ->select(['id', 'openid', 'mobile', 'nickname', 'realname', 'balance', 'status'])
- ->first();
- $status = isset($userInfo['status']) ? $userInfo['status'] : 0;
- if (empty($userInfo) || $status != 1) {
- $this->error = 1045;
- RedisService::clear($cacheLockKey);
- return false;
- }
- // 订单信息
- $info = $this->model->where(['id' => $orderId, 'mark' => 1])
- ->select(['id', 'order_no', 'pay_total', 'status'])
- ->first();
- $orderNo = isset($info['order_no']) ? $info['order_no'] : '';
- $status = isset($info['status']) ? $info['status'] : 0;
- if (empty($info) || empty($orderNo)) {
- $this->error = '订单信息不存在';
- RedisService::clear($cacheLockKey);
- return false;
- }
- if ($status != 1) {
- $this->error = '订单已支付';
- RedisService::clear($cacheLockKey);
- return false;
- }
- $orderGoods = OrderGoodsModel::where(['order_no' => $orderNo, 'mark' => 1])
- ->select(['goods_id', 'num', 'sku_id'])
- ->get();
- DB::beginTransaction();
- if ($orderGoods) {
- foreach ($orderGoods as $goods) {
- $goodsId = isset($goods['goods_id']) ? $goods['goods_id'] : 0;
- $num = isset($goods['num']) ? $goods['num'] : 0;
- $skuId = isset($goods['sku_id']) ? $goods['sku_id'] : 0;
- if ($goodsId && !GoodsModel::where(['id' => $goodsId])->update(['stock' => DB::raw("stock + {$num}"), 'update_time' => time()])) {
- DB::rollBack();
- RedisService::clear($cacheLockKey);
- $this->error = '商品库存处理失败';
- return false;
- }
- if ($skuId && !GoodsSkuModel::where(['id' => $skuId])->update(['stock' => DB::raw("stock + {$num}"), 'update_time' => time()])) {
- DB::rollBack();
- RedisService::clear($cacheLockKey);
- $this->error = '商品库存处理失败';
- return false;
- }
- }
- }
- $this->error = '取消订单成功';
- $this->model->where(['user_id' => $userId, 'mark' => 0])->where('update_time', '<=', time() - 300)->delete();
- OrderGoodsModel::where(['order_no' => $orderNo, 'mark' => 0])->where('update_time', '<=', time() - 300)->delete();
- $this->model->where(['id' => $orderId])->update(['mark' => 0, 'update_time' => time()]);
- OrderGoodsModel::where(['order_no' => $orderNo])->update(['mark' => 0, 'update_time' => time()]);
- DB::commit();
- return ['id' => $orderId];
- }
- /**
- * 订单删除隐藏
- * @param $userId
- * @param $orderId
- * @return array|false
- */
- public function hide($userId, $orderId)
- {
- if ($orderId <= 0) {
- $this->error = '请选择订单';
- return false;
- }
- // 缓存锁
- $cacheLockKey = "caches:orders:hide_lock:{$userId}_{$orderId}";
- if (RedisService::get($cacheLockKey)) {
- $this->error = '订单删除中~';
- return false;
- }
- RedisService::set($cacheLockKey, ['order_id' => $orderId, 'user_id' => $userId], rand(3, 5));
- // 用户信息
- $userInfo = MemberModel::where(['id' => $userId, 'mark' => 1])
- ->select(['id', 'openid', 'mobile', 'nickname', 'realname', 'balance', 'status'])
- ->first();
- $status = isset($userInfo['status']) ? $userInfo['status'] : 0;
- if (empty($userInfo) || $status != 1) {
- $this->error = 1045;
- RedisService::clear($cacheLockKey);
- return false;
- }
- // 订单信息
- $info = $this->model->where(['id' => $orderId, 'mark' => 1])
- ->select(['id', 'order_no', 'pay_total', 'status'])
- ->first();
- $orderNo = isset($info['order_no']) ? $info['order_no'] : '';
- $status = isset($info['status']) ? $info['status'] : 0;
- if (empty($info) || empty($orderNo)) {
- $this->error = '订单信息不存在';
- RedisService::clear($cacheLockKey);
- return false;
- }
- if ($status != 4) {
- $this->error = '订单未完成';
- RedisService::clear($cacheLockKey);
- return false;
- }
- $this->error = '删除订单成功';
- $this->model->where(['id' => $orderId])->update(['is_hide' => 1, 'update_time' => time()]);
- return ['id' => $orderId];
- }
- /**
- * 订单完成
- * @param $userId 订单用户ID
- * @param $id 订单ID
- * @return array|false
- */
- public function complete($userId, $id, $check = true)
- {
- if ($id <= 0) {
- $this->error = '请选择订单';
- return false;
- }
- // 缓存锁
- $cacheLockKey = "caches:orders:complete_lock:{$userId}_{$id}";
- if (RedisService::get($cacheLockKey)) {
- $this->error = '订单处理中~';
- return false;
- }
- // 商品数据
- RedisService::set($cacheLockKey, ['order_id' => $id, 'user_id' => $userId], rand(3, 5));
- // 用户信息
- $userInfo = MemberModel::where(['id' => $userId, 'mark' => 1])
- ->select(['id', 'openid', 'mobile', 'parent_id', 'nickname', 'realname', 'balance', 'status'])
- ->first();
- $status = isset($userInfo['status']) ? $userInfo['status'] : 0;
- $parentId = isset($userInfo['parent_id']) ? $userInfo['parent_id'] : 0;
- if ($check && (empty($userInfo) || $status != 1)) {
- $this->error = 1045;
- RedisService::clear($cacheLockKey);
- return false;
- }
- // 订单信息
- $info = $this->model->with(['orderGoods'])->where(['id' => $id, 'mark' => 1])
- ->select(['id', 'order_no','user_id', 'store_id','meeting_id', 'pay_total', 'bonus', 'delivery_no', 'delivery_company', 'delivery_code', 'status'])
- ->first();
- $orderNo = isset($info['order_no']) ? $info['order_no'] : '';
- $deliveryNo = isset($info['delivery_no']) ? $info['delivery_no'] : '';
- $deliverCompany = isset($info['delivery_company']) ? $info['delivery_company'] : '';
- $orderUserId = isset($info['user_id']) ? $info['user_id'] : 0;
- $storeId = isset($info['store_id']) ? $info['store_id'] : 0;
- $meetingId = isset($info['meeting_id']) ? $info['meeting_id'] : 0;
- $orderTotal = isset($info['pay_total']) ? $info['pay_total'] : 0;
- $bonus = isset($info['bonus']) ? $info['bonus'] : 0;
- $status = isset($info['status']) ? $info['status'] : 0;
- $orderGoods = isset($info['order_goods']) ? $info['order_goods'] : [];
- if (empty($info) || empty($orderNo)) {
- $this->error = '订单信息不存在';
- RedisService::clear($cacheLockKey);
- return false;
- }
- if ($status != 3) {
- $this->error = '订单未发货';
- RedisService::clear($cacheLockKey);
- return false;
- }
- if (empty($deliveryNo) || empty($deliverCompany)) {
- $this->error = '订单发货信息错误,请联系客服';
- $this->model->where(['id' => $id])->update(['is_complete' => 1, 'complete_remark' => $this->error]);
- RedisService::clear("caches:orders:completeList");
- RedisService::clear($cacheLockKey);
- return false;
- }
- DB::beginTransaction();
- $updateData = ['status' => 4, 'complete_at' => date('Y-m-d H:i:s'), 'update_time' => time()];
- if (!$check) {
- $updateData['is_complete'] = 1;
- $updateData['complete_remark'] = '自动收货';
- }
- $this->model->where(['id' => $id])->update($updateData);
- // 商家订单数据统计
- $updateData = ['order_count' => DB::raw('order_count+1'), 'order_total' => DB::raw("order_total + {$orderTotal}")];
- StoreModel::where(['id' => $storeId])->update($updateData);
- // 商品销量数据
- if ($orderGoods) {
- $counts = [];
- foreach ($orderGoods as $item) {
- $counts[$item['goods_id']] = isset($counts[$item['goods_id']]) ? $counts[$item['goods_id']] : 0;
- $counts[$item['goods_id']] += $item['num'];
- }
- if ($counts) {
- foreach ($counts as $id => $v) {
- GoodsModel::where(['id' => $id])->update(['sales' => DB::raw("sales + {$v}"), 'update_time' => time()]);
- }
- }
- }
- // 结算商家收益
- if (SettleService::make()->storeBonus($storeId, $bonus, $info) < 0) {
- DB::rollBack();
- $this->error = SettleService::make()->getError();
- RedisService::clear($cacheLockKey);
- return false;
- }
- // 关联会议统计
- if($meetingId){
- // 会议成交统计
- $updateData = ['order_count' => DB::raw('order_count+1'), 'order_total' => DB::raw("order_total + {$orderTotal}")];
- MeetingModel::where(['id' => $meetingId])->update($updateData);
- // 签到用户成交统计
- $updateData = ['order_count' => DB::raw('order_count+1'), 'order_total' => DB::raw("order_total + {$orderTotal}")];
- MeetingRecordsModel::where(['meeting_id' => $meetingId,'user_id'=>$orderUserId])->update($updateData);
- }
- DB::commit();
- $this->error = '确认收货成功';
- RedisService::clear("caches:orders:completeList");
- RedisService::clear("caches:orders:revenueList");
- return ['id' => $id, 'msg' => $this->error];
- }
- /**
- * 售后或退款
- * @param $userId
- * @param $params
- * @return array|false
- */
- public function after($userId, $params)
- {
- $id = isset($params['id']) ? $params['id'] : 0;
- $afterType = isset($params['after_type']) ? $params['after_type'] : 1;
- if ($id <= 0) {
- $this->error = '请选择订单';
- return false;
- }
- // 缓存锁
- $cacheLockKey = "caches:orders:after_lock:{$userId}_{$id}";
- if (RedisService::get($cacheLockKey)) {
- $this->error = '订单处理中~';
- return false;
- }
- // 商品数据
- RedisService::set($cacheLockKey, ['params' => $params, 'user_id' => $userId], rand(3, 5));
- // 用户信息
- $userInfo = MemberModel::where(['id' => $userId, 'mark' => 1])
- ->select(['id', 'openid', 'mobile', 'nickname', 'realname', 'balance', 'status'])
- ->first();
- $status = isset($userInfo['status']) ? $userInfo['status'] : 0;
- if (empty($userInfo) || $status != 1) {
- $this->error = 1045;
- RedisService::clear($cacheLockKey);
- return false;
- }
- // 订单信息
- $info = $this->model->where(['id' => $id, 'mark' => 1])
- ->select(['id', 'order_no', 'after_type', 'refund_status', 'pay_total', 'status'])
- ->first();
- $orderNo = isset($info['order_no']) ? $info['order_no'] : '';
- $status = isset($info['status']) ? $info['status'] : 0;
- $refundStatus = isset($info['refund_status']) ? $info['refund_status'] : 0;
- if (empty($info) || empty($orderNo)) {
- $this->error = '订单信息不存在';
- RedisService::clear($cacheLockKey);
- return false;
- }
- if ($status == 1) {
- $this->error = '订单未支付';
- RedisService::clear($cacheLockKey);
- return false;
- }
- if ($status == 4 && $afterType == 2) {
- $this->error = '订单已完成';
- RedisService::clear($cacheLockKey);
- return false;
- }
- if ($refundStatus > 0 && $refundStatus != 4) {
- $this->error = '订单售后处理中';
- RedisService::clear($cacheLockKey);
- return false;
- }
- $afterRealname = isset($params['after_realname']) ? $params['after_realname'] : '';
- $afterPhone = isset($params['after_phone']) ? $params['after_phone'] : '';
- $afterRemark = isset($params['after_remark']) ? $params['after_remark'] : '';
- if ($afterType == 1) {
- if (empty($afterRealname) || empty($afterPhone) || empty($afterRemark)) {
- $this->error = '请填写售后信息';
- RedisService::clear($cacheLockKey);
- return false;
- }
- }
- $data = [
- 'after_type' => $afterType,
- 'after_realname' => $afterRealname,
- 'after_phone' => $afterPhone,
- 'after_remark' => $afterRemark,
- 'refund_remark' => isset($params['refund_remark']) ? $params['refund_remark'] : '',
- 'refund_status' => 3,
- 'update_time' => time()
- ];
- $this->model->where(['id' => $id])->update($data);
- $this->error = '订单申请售后成功';
- return ['id' => $id];
- }
- /**
- * 物流查询
- * @param $id
- * @return array|false|mixed
- */
- public function getDelivery($id)
- {
- $info = $this->model->where(['id' => $id, 'mark' => 1])->first();
- $deliveryNo = isset($info['delivery_no']) ? $info['delivery_no'] : '';
- $deliveryCode = isset($info['delivery_code']) ? $info['delivery_code'] : '';
- $mobile = isset($info['receiver_mobile']) ? $info['receiver_mobile'] : '';
- $receiverArea = isset($info['receiver_area']) && $info['receiver_area'] ? $info['receiver_area'] : '';
- if (empty($info)) {
- $this->error = '请选择订单';
- return false;
- }
- $cacheKey = "caches:kd100:order_{$id}";
- $data = RedisService::get($cacheKey);
- if ($data) {
- return $data;
- }
- $result = Kd100Service::make()->query($deliveryNo, $mobile, $deliveryCode, $receiverArea);
- RedisService::set($cacheKey . '_result', $result, 300);
- $status = isset($result['status']) ? $result['status'] : 0;
- $data = isset($result['data']) ? $result['data'] : [];
- $courierInfo = isset($result['courierInfo']) ? $result['courierInfo'] : [];
- $arrivalTime = isset($result['arrivalTime']) ? $result['arrivalTime'] : '';
- $predictedRoute = isset($result['predictedRoute']) ? $result['predictedRoute'] : [];
- $predictedData = $predictedRoute ? end($predictedRoute) : [];
- $arrivalData = [];
- if ($arrivalTime) {
- $arrivalData['arrivalTime'] = dayFormat(strtotime($arrivalTime . ':00:00'));
- $arrivalData['predictedData'] = $predictedData;
- }
- if ($courierInfo && $courierInfo['deliveryManPhone']) {
- $courierInfo['deliveryManPhone'] = explode(',', $courierInfo['deliveryManPhone']);
- $courierInfo['deliveryPhone'] = $courierInfo['deliveryManPhone'][1] ? $courierInfo['deliveryManPhone'][1] : $courierInfo['deliveryManPhone'][0];
- }
- if ($data && $status == 200) {
- RedisService::set($cacheKey, ['info' => $courierInfo, 'arrivalData' => $arrivalData, 'list' => $data], 1200);
- }
- return $data ? ['info' => $courierInfo, 'arrivalData' => $arrivalData, 'list' => $data] : [];
- }
- /**
- * 已发货待完成订单
- * @return array|mixed
- */
- public function getCompleteOrders()
- {
- $cacheKey = "caches:orders:completeList";
- $datas = RedisService::get($cacheKey);
- if ($datas) {
- return $datas;
- }
- $completeDay = ConfigService::make()->getConfigByCode('order_complete_day', 7);
- $limitNum = ConfigService::make()->getConfigByCode('order_complete_batch_num', 300);
- $limitNum = $limitNum > 10 && $limitNum < 2000 ? $limitNum : 300;
- $completeDay = $completeDay >= 1 && $completeDay < 30 ? $completeDay : 7;
- $datas = $this->model->where(['status' => 3, 'is_complete' => 2, 'mark' => 1])
- ->whereNotNull('delivery_no')
- ->select(['id', 'user_id', 'order_no', 'status'])
- ->where('pay_at', '<=', date('Y-m-d H:i:s', time() - $completeDay * 86400))
- ->limit($limitNum)
- ->get();
- $datas = $datas ? $datas->toArray() : [];
- if ($datas) {
- RedisService::set($cacheKey, $datas, rand(300, 600));
- }
- return $datas;
- }
- /**
- * 已完成,待分账订单
- * @return array|mixed
- */
- public function getRevenueOrderList()
- {
- $cacheKey = "caches:orders:revenueList";
- $datas = RedisService::get($cacheKey);
- if ($datas) {
- return $datas;
- }
- $limitNum = ConfigService::make()->getConfigByCode('order_revenue_batch_num', 300);
- $limitNum = $limitNum > 10 && $limitNum < 2000 ? $limitNum : 300;
- $datas = $this->model->where(['status' => 4, 'is_revenue' => 1, 'revenue_status' => 2, 'mark' => 1])
- ->select(['id', 'user_id','pay_total', 'order_no','revenue_no','transaction_id', 'status'])
- ->limit($limitNum)
- ->get();
- $datas = $datas ? $datas->toArray() : [];
- if ($datas) {
- RedisService::set($cacheKey, $datas, rand(300, 600));
- }
- return $datas;
- }
- /**
- * 订单分账处理
- * @param $id
- * @return false
- * @throws \Yansongda\Pay\Exception\ContainerException
- * @throws \Yansongda\Pay\Exception\InvalidParamsException
- */
- public function revenue($id)
- {
- if ($id <= 0) {
- $this->error = '订单参数错误';
- return false;
- }
- // 缓存锁
- $cacheLockKey = "caches:orders:revenue_lock:{$id}";
- if (RedisService::get($cacheLockKey)) {
- $this->error = '订单分账处理中~';
- return false;
- }
- // 是否设置分账账户
- $revenueOpenid = ConfigService::make()->getConfigByCode('order_revenue_openid', '');
- if(empty($revenueOpenid)){
- $this->error = '订单分账账户未配置';
- return false;
- }
- // 订单信息
- RedisService::set($cacheLockKey, ['id'=>$id,'date'=>date('Y-m-d H:i:s')], 20);
- $info = $this->model->where(['id' => $id, 'mark' => 1])
- ->select(['id', 'order_no','revenue_no','user_id','transaction_id', 'pay_total','is_revenue','revenue_status','revenue_amount', 'status'])
- ->first();
- $revenueOrderNo = isset($info['revenue_no']) ? $info['revenue_no'] : '';
- $revenueAmount = isset($info['revenue_amount']) ? $info['revenue_amount'] : 0;
- $status = isset($info['status']) ? $info['status'] : 0;
- $isRevenue = isset($info['is_revenue']) ? $info['is_revenue'] : 0;
- $revenueStatus = isset($info['revenue_status']) ? $info['revenue_status'] : 0;
- if($status != 4){
- RedisService::clear($cacheLockKey);
- $this->error = '订单状态错误,未完成收货的订单无法分账';
- return false;
- }
- if($isRevenue != 1){
- RedisService::clear($cacheLockKey);
- $this->error = '该订单不是分账订单';
- return false;
- }
- if($revenueStatus != 2){
- RedisService::clear($cacheLockKey);
- $this->error = '该订单分账已处理完成';
- return false;
- }
- if($revenueAmount<=0){
- RedisService::clear($cacheLockKey);
- $this->error = '订单分账金额不足';
- return false;
- }
- $order = [
- 'transaction_id'=> $info['transaction_id'],
- 'out_order_no'=> $revenueOrderNo,
- 'body'=> '订单分账',
- 'amount'=> $revenueAmount,
- 'unsplit'=> true, // 只分一次
- ];
- $result = PaymentService::make()->profitsharing($revenueOpenid, $order);
- $state = isset($result->state)? $result->state : 0;
- $message = isset($result->message)? $result->message : '分账失败';
- $orderId = isset($result->order_id)? $result->order_id : '';
- if($state == 'FINISHED'){
- $this->model->where(['id'=>$id])->update(['revenue_status'=>1,'revenue_order_id'=>$orderId,'update_time'=>time()]);
- RedisService::clear($cacheLockKey);
- RedisService::clear("caches:orders:revenueList");
- $this->error = '分账处理成功';
- return true;
- }else{
- RedisService::clear($cacheLockKey);
- $this->error = $message;
- return false;
- }
- }
- }
|