SettleService.php 29 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704
  1. <?php
  2. // +----------------------------------------------------------------------
  3. // | LARAVEL8.0 框架 [ LARAVEL ][ RXThinkCMF ]
  4. // +----------------------------------------------------------------------
  5. // | 版权所有 2017~2021 LARAVEL研发中心
  6. // +----------------------------------------------------------------------
  7. // | 官方网站: http://www.laravel.cn
  8. // +----------------------------------------------------------------------
  9. // | Author: laravel开发员 <laravel.qq.com>
  10. // +----------------------------------------------------------------------
  11. namespace App\Services\Api;
  12. use App\Models\AccountLogModel;
  13. use App\Models\CouponModel;
  14. use App\Models\MemberCouponModel;
  15. use App\Models\MemberModel;
  16. use App\Models\OrderCommissionModel;
  17. use App\Models\OrderModel;
  18. use App\Models\PtAccountModel;
  19. use App\Models\StoreModel;
  20. use App\Services\BaseService;
  21. use App\Services\Common\MemberLevelService;
  22. use App\Services\ConfigService;
  23. use App\Services\RedisService;
  24. use Illuminate\Support\Facades\DB;
  25. /**
  26. * 结算管理-服务类
  27. * @author laravel开发员
  28. * @since 2020/11/11
  29. * @package App\Services\Api
  30. */
  31. class SettleService extends BaseService
  32. {
  33. /**
  34. * 构造函数
  35. * @author laravel开发员
  36. * @since 2020/11/11
  37. */
  38. public function __construct()
  39. {
  40. $this->model = new AccountLogModel();
  41. }
  42. /**
  43. * 静态入口
  44. * @return static|null
  45. */
  46. public static function make()
  47. {
  48. if (!self::$instance) {
  49. self::$instance = (new static());
  50. }
  51. return self::$instance;
  52. }
  53. /**
  54. * 商家收益结算
  55. * @param $storeId
  56. * @param $money 收益
  57. * @param $order 订单数据
  58. * @return array|false|int
  59. */
  60. public function storeBonus($storeId, $money, $order)
  61. {
  62. $orderNo = isset($order['order_no'])? $order['order_no'] : '';
  63. if($money<=0 && $storeId<=0){
  64. $this->error = '无企业佣金可结算';
  65. return false;
  66. }
  67. $storeInfo = StoreModel::where(['id'=> $storeId,'mark'=>1])->first();
  68. $balance = isset($storeInfo['bonus_total'])? $storeInfo['bonus_total'] : 0;
  69. $storeUserId = isset($storeInfo['user_id'])? $storeInfo['user_id'] : 0;
  70. if($storeUserId<=0){
  71. $this->error = '企业账号错误';
  72. return false;
  73. }
  74. if(!StoreModel::where(['id'=> $storeId])->update(['bonus_total'=>DB::raw("bonus_total + {$money}"),'update_time'=>time()])){
  75. $this->error = '收货错误,企业结算错误,请联系客服处理';
  76. return -1;
  77. }
  78. $log = [
  79. 'user_id'=> $storeUserId,
  80. 'store_id'=> $storeId,
  81. 'source_order_no'=> isset($order['order_no'])? $order['order_no'] : '',
  82. 'type'=> 7,
  83. 'money'=> $money,
  84. 'after_money'=> moneyFormat($balance+$money,2),
  85. 'date'=>date('Y-m-d'),
  86. 'create_time'=>time(),
  87. 'remark'=> '收益',
  88. 'status'=>1
  89. ];
  90. if(!$id = $this->model->insertGetId($log)){
  91. $this->error = '企业收益结算失败,请联系客服处理';
  92. return -1;
  93. }
  94. $result = ['id'=>$id,'store_id'=>$storeId,'bonus'=>$money];
  95. if(env('APP_DEBUG')){
  96. RedisService::set("caches:settle:{$orderNo}:store_{$storeId}", $result, 7200);
  97. }
  98. return $result;
  99. }
  100. /**
  101. * @param $order
  102. * @param int $orderType
  103. */
  104. public function commissionCount($order, $orderGoods, $userInfo, $orderType=1)
  105. {
  106. $userId = isset($order['user_id'])?$order['user_id']:0;
  107. $storeId = isset($order['store_id'])?$order['store_id']:0;
  108. $mealId = isset($order['meal_id'])?$order['meal_id']:0;
  109. $orderId = isset($order['id'])?$order['id']:0;
  110. $orderNo = isset($order['order_no'])?$order['order_no']:'';
  111. $orderTotal = isset($order['pay_total'])?$order['pay_total']:0;
  112. $profitTotal = isset($order['profit_total'])?$order['profit_total']:0;
  113. $data = [
  114. 'order_id'=> $orderId,
  115. 'user_id'=> $userId,
  116. 'order_no'=> $orderNo,
  117. 'store_id'=> $storeId,
  118. 'total'=> $orderTotal,
  119. 'create_time'=>time(),
  120. 'status'=>2,
  121. 'mark'=>1,
  122. ];
  123. $errors = [];
  124. if($orderType==2){
  125. /* TODO 计算直推奖 */
  126. $pointId = isset($userInfo['point_id'])? $userInfo['point_id']:0;
  127. $directBonus = ConfigService::make()->getConfigByCode('business_direct_bonus', 0);
  128. $directBonus = $directBonus>0 && $directBonus<$orderTotal?$directBonus:0;
  129. $pointInfo = MemberModel::where(['id' => $pointId,'mark'=>1])
  130. ->select(['id','nickname','buy_type','bonus_status','status','mark'])
  131. ->first();
  132. $bonusStatus = isset($pointInfo['bonus_status'])?$pointInfo['bonus_status']:0;
  133. $data['direct_uid'] = $pointId;
  134. if($pointInfo && $bonusStatus==1){
  135. $data['direct_bonus'] = json_encode(['uid'=>$pointId,'bonus'=>$directBonus],256);
  136. }else{
  137. $data['direct_bonus']= json_encode(['uid'=>$pointId,'direct_bonus'=>$directBonus,'meal_id'=>$mealId,'error'=>'节点推荐人不存在或收益已领完','point'=>$pointInfo],256);
  138. }
  139. /* TODO 计算见单奖和分红奖励 */
  140. $points = isset($userInfo['points'])?$userInfo['points']:'';
  141. $points = $points? explode(',',$points) : [];
  142. $points = array_filter($points);
  143. $points = array_reverse($points); // 由下到上1-6层
  144. $rewardLayer = ConfigService::make()->getConfigByCode('business_reward_layer', 6);
  145. $points = array_splice($points,0, $rewardLayer);
  146. $jdBonus = ConfigService::make()->getConfigByCode("business_jd_bonus_{$mealId}", 0);
  147. $jdBonus = $jdBonus>0 && $jdBonus< $orderTotal? $jdBonus : 0;
  148. // 计算当前平台下各个等级的会员数量
  149. $levelCounts = MemberService::make()->getCountsByLevel();
  150. $levelList = MemberLevelService::make()->getListByLevel();
  151. if($points){
  152. $pointList = MemberModel::with(['levelData'])->whereIn('id', $points)
  153. ->select(['id','nickname','mobile','buy_type','member_level','bonus_status','status','mark'])
  154. ->orderBy(DB::raw("FIELD(id, ".implode(',',$points).")"))
  155. ->get();
  156. foreach ($pointList as $k => $point){
  157. // 默认只分6层
  158. $layer = $k+1;
  159. if($layer>$rewardLayer){
  160. continue;
  161. }
  162. // 处理见单奖
  163. $pid = isset($point['id'])?$point['id']:0;
  164. $pMark = isset($point['mark'])?$point['mark']:0;
  165. $buyType = isset($point['buy_type'])?$point['buy_type']:0;
  166. $bonusStatus = isset($point['bonus_status'])?$point['bonus_status']:0;
  167. $pLevel = isset($point['member_level'])?$point['member_level']:0;
  168. $levelWeightCountData = isset($levelCounts[$pLevel])? $levelCounts[$pLevel] : 0;
  169. $levelData = isset($levelList[$pLevel])? $levelList[$pLevel] : 0;
  170. $levelWeightCount = isset($levelWeightCountData['count'])? $levelWeightCountData['count']:0;
  171. $levelBonus = isset($levelData['bonus'])? $levelData['bonus']:0;
  172. $data["bonus_{$layer}_uid"] = $pid;
  173. $bonusData = [
  174. 'id'=> $pid,
  175. 'nickname'=> isset($point['nickname'])?$point['nickname']:'',
  176. 'mobile'=> isset($point['mobile'])?$point['mobile']:'',
  177. 'jd_bonus'=> 0,
  178. 'level'=> $pLevel,
  179. 'weight'=> $levelWeightCount,
  180. 'weight_bonus'=> $levelBonus,
  181. 'level_bonus'=> 0,
  182. ];
  183. if($pMark==1 && $bonusStatus==1){
  184. $bonusData['jd_bonus'] = $jdBonus;
  185. }else{
  186. $bonusData["error"]= "上{$layer}级节点推荐人不存在或收益已领完";
  187. }
  188. // 处理加权分红
  189. if($pLevel>0 && $levelWeightCount>0 && $levelBonus>0 && $bonusStatus==1){
  190. $bonusData['level_bonus'] = moneyFormat($levelBonus * 6/$levelWeightCount,2);
  191. }
  192. // 数据
  193. $data["bonus_{$layer}_data"] = json_encode($bonusData,256);
  194. }
  195. }
  196. }else{
  197. /* TODO 计算商家佣金 */
  198. $storeInfo = StoreModel::where(['id' => $storeId])->first();
  199. $bonusRate = isset($storeInfo['bonus_rate']) ? floatval($storeInfo['bonus_rate']) : 0;
  200. $storeBonusRate = ConfigService::make()->getConfigByCode('store_bonus_rate', 0);
  201. $storeBonusRate = $storeBonusRate > 0 && $storeBonusRate <= 100 ? $storeBonusRate : 0;
  202. $bonusRate = $bonusRate > 0 && $bonusRate <= 100 ? $bonusRate : $storeBonusRate;
  203. $bonus = moneyFormat($orderTotal * $bonusRate / 100, 2);
  204. $data['bonus'] = $bonus;
  205. $data['bonus_rate'] = $bonusRate;
  206. /* TODO 计算绿色积分奖励 */
  207. $lsScoreTotal = 0;
  208. $data['ls_score_rates'] = [];
  209. $ptLsScoreRate = ConfigService::make()->getConfigByCode('ls_score_rate',0);
  210. $ptLsScoreRate = $ptLsScoreRate>0&&$ptLsScoreRate<=50?$ptLsScoreRate:0;
  211. if($orderGoods){
  212. foreach ($orderGoods as $goods){
  213. $lsScoreRate = isset($goods['ls_score_rate'])?$goods['ls_score_rate']:0;
  214. $lsScoreRate = $lsScoreRate>0 && $lsScoreRate<=50?$lsScoreRate : $ptLsScoreRate;
  215. $profitTotal = isset($goods['profit_total'])?$goods['profit_total'] : 0;
  216. if($profitTotal>0 && $lsScoreRate>0){
  217. $lsScoreTotal += moneyFormat($profitTotal * $lsScoreRate/100,2);
  218. }
  219. $data['ls_score_rates'][$goods['goods_id']] = [
  220. 'goods_id'=> $goods['goods_id'],
  221. 'score'=>$lsScoreRate
  222. ];
  223. }
  224. }
  225. $data['ls_score'] = $lsScoreTotal;
  226. $data['ls_score_rates'] = json_encode($data['ls_score_rates'], 256);
  227. /* TODO 计算数字资产+底池金额 */
  228. $ptPoolRate = ConfigService::make()->getConfigByCode('pt_pool_rate', 0);
  229. $ptPoolRate = $ptPoolRate>0 && $ptPoolRate<50?$ptPoolRate:0;
  230. $rewardPropertyRate = ConfigService::make()->getConfigByCode('reward_property_rate', 0);
  231. $rewardPropertyRate = $rewardPropertyRate > 0 && $rewardPropertyRate <= 50 ? $rewardPropertyRate : 0;
  232. $propertyTotal = moneyFormat($rewardPropertyRate * $profitTotal/100,2);
  233. $poolTotal = moneyFormat($ptPoolRate * $profitTotal/100,2);
  234. $data['pt_pool_rate'] = $ptPoolRate;
  235. $data['pt_pool'] = $poolTotal;
  236. $data['property'] = $propertyTotal;
  237. $data['property_rate'] = $rewardPropertyRate;
  238. }
  239. // 佣金数据入库
  240. if(!$cid = OrderCommissionModel::where(['order_no'=>$orderNo])->value('id')){
  241. $cid = OrderCommissionModel::insertGetId($data);
  242. }else{
  243. OrderCommissionModel::where(['id'=>$cid])->update($data);
  244. }
  245. $this->error = '佣金计算成功';
  246. $data['id'] = $cid;
  247. return $data;
  248. }
  249. /**
  250. * 订单结算
  251. * @param $orderId
  252. * @return array|false
  253. */
  254. public function commissionSettle($orderId)
  255. {
  256. $info = OrderModel::with(['commission'])
  257. ->where(['id'=>$orderId,'mark'=>1])
  258. ->select(['id','order_no','type','user_id','total','pay_total','bd_score','pay_status','status','refund_status'])
  259. ->first();
  260. $info = $info?$info->toArray() : [];
  261. if(empty($info)){
  262. $this->error = '结算订单不存在';
  263. return false;
  264. }
  265. if($info['status']<=1 || $info['pay_status'] == 10){
  266. $this->error = '订单未支付';
  267. return false;
  268. }
  269. if(in_array($info['refund_status'],[1,2,3])){
  270. $this->error = '订单已退款';
  271. return false;
  272. }
  273. $orderType = isset($info['type'])?$info['type'] : 1;
  274. $orderNo = isset($info['order_no'])?$info['order_no'] : '';
  275. $orderUserId = isset($info['user_id'])?$info['user_id'] : 0;
  276. $commission = isset($info['commission'])?$info['commission'] : [];
  277. $commissionId = isset($commission['id'])?$commission['id'] : 0;
  278. if(empty($commission) || $commissionId<=0){
  279. $this->error = '结算订单收益参数错误';
  280. return false;
  281. }
  282. if($commission['status'] == 1){
  283. $this->error = '订单收益已结算';
  284. return false;
  285. }
  286. $cacheKey = "caches:ordersCommission:{$orderNo}_{$orderUserId}:";
  287. if(RedisService::get("{$cacheKey}lock")){
  288. $this->error = '订单结算中';
  289. // return false;
  290. }
  291. // 创业订单
  292. $logs = [];
  293. $success = [];
  294. RedisService::set("{$cacheKey}lock", $info, 300);
  295. DB::beginTransaction();
  296. if($orderType == 2){
  297. // TODO 结算直推奖
  298. $directData = isset($commission['direct_bonus'])? $commission['direct_bonus'] : [];
  299. $directUserId = isset($commission['direct_uid'])? $commission['direct_uid'] : 0;
  300. $directBonus = isset($directData['bonus'])? $directData['bonus'] : 0;
  301. var_dump($directUserId);
  302. dump($directData);
  303. var_dump($directBonus);
  304. if($directUserId>0 && $directBonus>0){
  305. $directUser = isset($commission['direct_user'])? $commission['direct_user'] : [];
  306. $directUserBalance = isset($directUser['balance'])?$directUser['balance'] : 0;
  307. if($directUser){
  308. $updateData = [
  309. 'balance'=>DB::raw("balance + {$directBonus}"),
  310. 'bonus_total'=>DB::raw("bonus_total + {$directBonus}"),
  311. 'update_time'=>time()
  312. ];
  313. if(!MemberModel::where(['id'=>$directUserId])->update($updateData)){
  314. DB::rollBack();
  315. RedisService::clear("{$cacheKey}lock");
  316. $this->error = '直推奖励结算错误';
  317. return false;
  318. }
  319. $data = [
  320. 'user_id'=> $directUserId,
  321. 'source_order_no'=> $orderNo,
  322. 'user_type'=> 1,
  323. 'account_type'=> 1, // 余额
  324. 'type'=> 8,
  325. 'bonus_type'=> 1,
  326. 'money'=> $directBonus,
  327. 'after_money'=>moneyFormat($directUserBalance + $directBonus,2),
  328. 'date'=>date('Y-m-d'),
  329. 'create_time'=>time(),
  330. 'remark'=> '直推奖',
  331. 'remark1'=> "用户ID:{$orderUserId}购买礼包直推奖励",
  332. 'status'=>1,
  333. 'mark'=>1
  334. ];
  335. $logs[] = $data;
  336. }
  337. }
  338. // TODO 结算见单奖+分红
  339. $bonusUids = [];
  340. for($i=1; $i<=6; $i++){
  341. $uid = isset($commission["bonus_{$i}_uid"])? $commission["bonus_{$i}_uid"]:0;
  342. if($uid){
  343. $bonusUids[] = $uid;
  344. }
  345. }
  346. $bonusUsers = MemberModel::whereIn('id', $bonusUids)
  347. ->select(['id','openid','balance','mobile','nickname','property','ls_score','status'])
  348. ->get()
  349. ->keyBy('id');
  350. $bonusUsers = $bonusUsers? $bonusUsers->toArray() : [];
  351. var_dump($bonusUsers);
  352. var_dump($bonusUids);
  353. for($i=1; $i<=6; $i++){
  354. $uid = isset($commission["bonus_{$i}_uid"])? $commission["bonus_{$i}_uid"]:0;
  355. $bonusData = isset($commission["bonus_{$i}_data"])? $commission["bonus_{$i}_data"]:0;
  356. $jdBonus = isset($bonusData['jd_bonus'])?$bonusData['jd_bonus']:0;
  357. $levelBonus = isset($bonusData['level_bonus'])?$bonusData['level_bonus']:0;
  358. $bonusUser = isset($bonusUsers[$uid])?$bonusUsers[$uid] : [];
  359. $bonusUserBalance = isset($bonusUser['balance'])?$bonusUser['balance'] : 0;
  360. $bonusTotal = moneyFormat($jdBonus + $levelBonus,2);
  361. if($uid && $bonusUser && $bonusTotal>0){
  362. $updateData = [
  363. 'balance'=>DB::raw("balance + {$bonusTotal}"),
  364. 'bonus_total'=>DB::raw("bonus_total + {$bonusTotal}"),
  365. 'update_time'=>time()
  366. ];
  367. if(!MemberModel::where(['id'=> $uid])->update($updateData)){
  368. DB::rollBack();
  369. $this->error = '见单和分红奖励结算错误';
  370. RedisService::clear("{$cacheKey}lock");
  371. return false;
  372. }
  373. if($jdBonus>0){
  374. $bonusUserBalance = moneyFormat($bonusUserBalance + $jdBonus,2);
  375. $data = [
  376. 'user_id'=> $uid,
  377. 'source_order_no'=> $orderNo,
  378. 'user_type'=> 1,
  379. 'account_type'=> 1, // 余额
  380. 'type'=> 8,
  381. 'bonus_type'=> 2,
  382. 'money'=> $jdBonus,
  383. 'after_money'=> $bonusUserBalance,
  384. 'date'=>date('Y-m-d'),
  385. 'create_time'=>time()+$i,
  386. 'remark'=> '见单奖',
  387. 'remark1'=> "下{$i}级用户ID:{$orderUserId}购买礼包见单奖",
  388. 'status'=>1,
  389. 'mark'=>1
  390. ];
  391. $logs[] = $data;
  392. }
  393. if($levelBonus>0){
  394. $bonusUserBalance = moneyFormat($bonusUserBalance + $levelBonus,2);
  395. $data = [
  396. 'user_id'=> $uid,
  397. 'source_order_no'=> $orderNo,
  398. 'user_type'=> 1,
  399. 'account_type'=> 1, // 余额
  400. 'type'=> 8,
  401. 'bonus_type'=> 3,
  402. 'money'=> $levelBonus,
  403. 'after_money'=> $bonusUserBalance,
  404. 'date'=>date('Y-m-d'),
  405. 'create_time'=>time()+$i,
  406. 'remark'=> '分红收益',
  407. 'remark1'=> "下{$i}级用户ID:{$orderUserId}购买礼包分红收益",
  408. 'status'=>1,
  409. 'mark'=>1
  410. ];
  411. $logs[] = $data;
  412. }
  413. }
  414. }
  415. }
  416. // 商城订单
  417. else {
  418. // TODO 商家结算
  419. $storeInfo = isset($commission['store'])?$commission['store'] : [];
  420. $storeId = isset($commission['store_id'])?$commission['store_id'] : 0;
  421. $storeBonus = isset($commission['bonus'])?$commission['bonus'] : 0;
  422. $storeUserId = isset($storeInfo['user_id'])?$storeInfo['user_id'] : 0;
  423. $storeBalance = isset($storeInfo['balance'])?$storeInfo['balance'] : 0;
  424. if($storeId>0 && $storeInfo && $storeBonus>0){
  425. $updateData = [
  426. 'balance'=>DB::raw("balance + {$storeBonus}"),
  427. 'income'=>DB::raw("income + {$storeBonus}"),
  428. 'update_time'=>time()
  429. ];
  430. if(!StoreModel::where(['id'=> $storeId])->update($updateData)){
  431. DB::rollBack();
  432. $this->error = '商家提成结算失败';
  433. RedisService::clear("{$cacheKey}lock");
  434. return false;
  435. }
  436. $storeBalance = moneyFormat($storeBalance + $storeBonus,2);
  437. $data = [
  438. 'user_id'=> $storeUserId,
  439. 'store_id'=> $storeId,
  440. 'source_order_no'=> $orderNo,
  441. 'user_type'=> 2,
  442. 'account_type'=> 1, // 余额
  443. 'type'=> 7,
  444. 'bonus_type'=> 0,
  445. 'money'=> $storeBonus,
  446. 'after_money'=> $storeBalance,
  447. 'date'=>date('Y-m-d'),
  448. 'create_time'=>time(),
  449. 'remark'=> '商家提成结算',
  450. 'remark1'=> "用户ID:{$orderUserId}购买商品提成结算",
  451. 'status'=>1,
  452. 'mark'=>1
  453. ];
  454. $logs[] = $data;
  455. }
  456. // TODO 绿色积分结算
  457. $userInfo = isset($commission['user'])?$commission['user']:[];
  458. $userId = isset($commission['user_id'])?$commission['user_id']:0;
  459. $userLsScore = isset($userInfo['ls_score'])?$userInfo['ls_score']:0;
  460. $lsScore = isset($commission['ls_score'])?$commission['ls_score']:0;
  461. if($userId>0 && $userInfo && $lsScore>0){
  462. $updateData = [
  463. 'ls_score'=>DB::raw("ls_score + {$lsScore}"),
  464. 'ls_score_total'=>DB::raw("ls_score_total + {$lsScore}"),
  465. 'update_time'=>time()
  466. ];
  467. if(!MemberModel::where(['id'=>$userId])->update($updateData)){
  468. DB::rollBack();
  469. $this->error = '绿色积分奖励结算错误';
  470. RedisService::clear("{$cacheKey}lock");
  471. return false;
  472. }
  473. $data = [
  474. 'user_id'=> $userId,
  475. 'source_order_no'=> $orderNo,
  476. 'user_type'=> 1,
  477. 'account_type'=> 4, // 绿色积分
  478. 'type'=> 8,
  479. 'bonus_type'=> 4,
  480. 'money'=> $lsScore,
  481. 'after_money'=>moneyFormat($userLsScore + $lsScore,2),
  482. 'date'=>date('Y-m-d'),
  483. 'create_time'=>time(),
  484. 'remark'=> '绿色积分奖励',
  485. 'remark1'=> "用户ID:{$orderUserId}购买商品绿色积分奖励",
  486. 'status'=>1,
  487. 'mark'=>1
  488. ];
  489. $logs[] = $data;
  490. }
  491. // TODO 数字资产和底池
  492. $property = isset($commission['property'])?$commission['property']:0;
  493. $userProperty = isset($userInfo['property'])?$userInfo['property']:0;
  494. if($userId>0 && $userInfo && $property>0){
  495. $updateData = [
  496. 'property'=>DB::raw("property + {$property}"),
  497. 'property_total'=>DB::raw("property_total + {$property}"),
  498. 'update_time'=>time()
  499. ];
  500. if(!MemberModel::where(['id'=>$userId])->update($updateData)){
  501. DB::rollBack();
  502. $this->error = '数字资产奖励结算错误';
  503. RedisService::clear("{$cacheKey}lock");
  504. return false;
  505. }
  506. $data = [
  507. 'user_id'=> $userId,
  508. 'source_order_no'=> $orderNo,
  509. 'user_type'=> 1,
  510. 'account_type'=> 2, // 数字资产
  511. 'type'=> 8,
  512. 'bonus_type'=> 5,
  513. 'money'=> $property,
  514. 'after_money'=>moneyFormat($userProperty + $property,2),
  515. 'date'=>date('Y-m-d'),
  516. 'create_time'=>time(),
  517. 'remark'=> '数字资产奖励',
  518. 'remark1'=> "用户ID:{$orderUserId}购买商品数字资产奖励",
  519. 'status'=>1,
  520. 'mark'=>1
  521. ];
  522. $logs[] = $data;
  523. }
  524. // 平台底池结算
  525. $ptAccount = PtAccountModel::where(['mark'=>1])->first();
  526. $accountId = isset($ptAccount['id'])?$ptAccount['id'] : 0;
  527. $poolTotal = isset($ptAccount['pool_total'])?$ptAccount['pool_total'] : 0;
  528. $ptPool = isset($commission['pt_pool'])?$commission['pt_pool'] : 0;
  529. if($ptAccount && ($ptPool>0 || $property>0)){
  530. $updateData = [
  531. 'pool_total'=>DB::raw("pool_total + {$ptPool}"),
  532. 'today_pool'=>DB::raw("today_pool + {$ptPool}"),
  533. 'today_property'=>DB::raw("today_property + {$property}"),
  534. 'update_time'=>time()
  535. ];
  536. if(!PtAccountModel::where(['id'=>$accountId])->update($updateData)){
  537. DB::rollBack();
  538. $this->error = '平台底池和资产结算错误';
  539. RedisService::clear("{$cacheKey}lock");
  540. return false;
  541. }
  542. // 底池明细
  543. if($ptPool>0){
  544. $data = [
  545. 'user_id'=> 0,
  546. 'source_order_no'=> $orderNo,
  547. 'user_type'=> 0,
  548. 'account_type'=> 5, // 平台账户
  549. 'type'=> 10,
  550. 'bonus_type'=> 6,
  551. 'money'=> $ptPool,
  552. 'after_money'=>moneyFormat($poolTotal + $ptPool,2),
  553. 'date'=>date('Y-m-d'),
  554. 'create_time'=>time(),
  555. 'remark'=> '返回底池',
  556. 'remark1'=> "用户ID:{$orderUserId}购买商品返回底池",
  557. 'status'=>1,
  558. 'mark'=>1
  559. ];
  560. $logs[] = $data;
  561. }
  562. }
  563. }
  564. // TODO 明细入表
  565. RedisService::set("{$cacheKey}logs", $logs, 3600);
  566. if($logs && !AccountLogModel::insert($logs)){
  567. DB::rollBack();
  568. $this->error = '奖励明细结算处理错误';
  569. RedisService::clear("{$cacheKey}lock");
  570. return false;
  571. }
  572. // 订单结算状态更新
  573. // if(!OrderCommissionModel::where(['id'=>$commissionId])->update(['status'=>1,'arrival_at'=>date('Y-m-d H:i:s'),'update_time'=>time()])){
  574. // DB::rollBack();
  575. // $this->error = '订单结算状态更新失败';
  576. // return false;
  577. // }
  578. DB::commit();
  579. $this->error = '订单结算完成';
  580. RedisService::clear("{$cacheKey}lock");
  581. RedisService::set("{$cacheKey}result", $info, 3600);
  582. return ['id'=>$orderId,'user_id'=>$orderUserId,'logs'=>$logs,'commission'=>$commission];
  583. }
  584. /**
  585. * 新人注册奖励
  586. * @param $userId
  587. * @return array|bool
  588. */
  589. public function registerReward($userId)
  590. {
  591. $rewardOpen = ConfigService::make()->getConfigByCode('register_award_coupon',0);
  592. $rewardCouponId = ConfigService::make()->getConfigByCode('register_reward_coupon_id',0);
  593. if($rewardCouponId<=0 || $rewardOpen!= 1){
  594. $this->error = '未开启或配置注册优惠券奖励';
  595. return true;
  596. }
  597. $couponInfo = CouponModel::where(['id'=>$rewardCouponId,'mark'=>1])
  598. ->first();
  599. $status = isset($couponInfo['status'])?$couponInfo['status']:0;
  600. if(empty($couponInfo) || $status != 1){
  601. $this->error = '配置的注册奖励优惠券不存在或无效';
  602. return true;
  603. }
  604. $data = [
  605. 'coupon_id'=> $rewardCouponId,
  606. 'user_id'=> $userId,
  607. 'store_id'=> isset($couponInfo['store_id'])?$couponInfo['store_id']:0,
  608. 'name'=> isset($couponInfo['name'])?$couponInfo['name']:'',
  609. 'coupon_type'=> isset($couponInfo['coupon_type'])?$couponInfo['coupon_type']: 20,
  610. 'reduce_price'=> isset($couponInfo['reduce_price'])?$couponInfo['reduce_price']:0,
  611. 'discount'=> isset($couponInfo['discount'])?$couponInfo['discount']:0,
  612. 'min_price'=> isset($couponInfo['min_price'])?$couponInfo['min_price']:0,
  613. 'expire_day'=> isset($couponInfo['expire_day'])?$couponInfo['expire_day']:0,
  614. 'start_time'=> isset($couponInfo['start_time'])?$couponInfo['start_time']:0,
  615. 'end_time'=> isset($couponInfo['end_time'])?$couponInfo['end_time']:0,
  616. 'goods_ids'=> isset($couponInfo['goods_ids'])&&$couponInfo['goods_ids']?$couponInfo['goods_ids']:'',
  617. 'create_time'=> time(),
  618. 'status'=> 1,
  619. ];
  620. if(!$id = MemberCouponModel::insertGetId($data)){
  621. $this->error = '奖励注册优惠券失败';
  622. return true;
  623. }
  624. $data['id'] = $id;
  625. $data['discount'] = floatval($data['discount']);
  626. $data['reduce_price'] = floatval($data['reduce_price']);
  627. unset($data['create_time']);
  628. unset($data['status']);
  629. unset($data['goods_ids']);
  630. $this->error = '奖励注册优惠券成功';
  631. return $data;
  632. }
  633. }