SettleService.php 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328
  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\StoreModel;
  18. use App\Services\BaseService;
  19. use App\Services\ConfigService;
  20. use App\Services\RedisService;
  21. use Illuminate\Support\Facades\DB;
  22. /**
  23. * 结算管理-服务类
  24. * @author laravel开发员
  25. * @since 2020/11/11
  26. * @package App\Services\Api
  27. */
  28. class SettleService extends BaseService
  29. {
  30. /**
  31. * 构造函数
  32. * @author laravel开发员
  33. * @since 2020/11/11
  34. */
  35. public function __construct()
  36. {
  37. $this->model = new AccountLogModel();
  38. }
  39. /**
  40. * 静态入口
  41. * @return static|null
  42. */
  43. public static function make()
  44. {
  45. if (!self::$instance) {
  46. self::$instance = (new static());
  47. }
  48. return self::$instance;
  49. }
  50. /**
  51. * 商家收益结算
  52. * @param $storeId
  53. * @param $money 收益
  54. * @param $order 订单数据
  55. * @return array|false|int
  56. */
  57. public function storeBonus($storeId, $money, $order)
  58. {
  59. $orderNo = isset($order['order_no'])? $order['order_no'] : '';
  60. if($money<=0 && $storeId<=0){
  61. $this->error = '无企业佣金可结算';
  62. return false;
  63. }
  64. $storeInfo = StoreModel::where(['id'=> $storeId,'mark'=>1])->first();
  65. $balance = isset($storeInfo['bonus_total'])? $storeInfo['bonus_total'] : 0;
  66. $storeUserId = isset($storeInfo['user_id'])? $storeInfo['user_id'] : 0;
  67. if($storeUserId<=0){
  68. $this->error = '企业账号错误';
  69. return false;
  70. }
  71. if(!StoreModel::where(['id'=> $storeId])->update(['bonus_total'=>DB::raw("bonus_total + {$money}"),'update_time'=>time()])){
  72. $this->error = '收货错误,企业结算错误,请联系客服处理';
  73. return -1;
  74. }
  75. $log = [
  76. 'user_id'=> $storeUserId,
  77. 'store_id'=> $storeId,
  78. 'source_order_no'=> isset($order['order_no'])? $order['order_no'] : '',
  79. 'type'=> 7,
  80. 'money'=> $money,
  81. 'after_money'=> moneyFormat($balance+$money,2),
  82. 'date'=>date('Y-m-d'),
  83. 'create_time'=>time(),
  84. 'remark'=> '收益',
  85. 'status'=>1
  86. ];
  87. if(!$id = $this->model->insertGetId($log)){
  88. $this->error = '企业收益结算失败,请联系客服处理';
  89. return -1;
  90. }
  91. $result = ['id'=>$id,'store_id'=>$storeId,'bonus'=>$money];
  92. if(env('APP_DEBUG')){
  93. RedisService::set("caches:settle:{$orderNo}:store_{$storeId}", $result, 7200);
  94. }
  95. return $result;
  96. }
  97. public function businessBonus($userId, $total, $commission, $order)
  98. {
  99. }
  100. public function shopBonus($userId, $total, $commission, $order)
  101. {
  102. }
  103. /**
  104. * @param $order
  105. * @param int $orderType
  106. */
  107. public function commissionCount($order, $orderGoods, $userInfo, $orderType=1)
  108. {
  109. $userId = isset($order['user_id'])?$order['user_id']:0;
  110. $storeId = isset($order['store_id'])?$order['store_id']:0;
  111. $mealId = isset($order['meal_id'])?$order['meal_id']:0;
  112. $orderNo = isset($order['order_no'])?$order['order_no']:'';
  113. $orderTotal = isset($order['pay_total'])?$order['pay_total']:0;
  114. $profitTotal = isset($order['profit_total'])?$order['profit_total']:0;
  115. $data = [
  116. 'user_id'=> $userId,
  117. 'order_no'=> $orderNo,
  118. 'store_id'=> $storeId,
  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. $buyType = isset($pointInfo['buy_type'])?$pointInfo['buy_type']:0;
  133. $bonusStatus = isset($pointInfo['bonus_status'])?$pointInfo['bonus_status']:0;
  134. $data['direct_uid'] = $pointId;
  135. if($pointInfo && $buyType==$mealId && $bonusStatus==1){
  136. $data['direct_bonus'] = $directBonus;
  137. }else{
  138. $errors['direct_bonus']=['uid'=>$pointId,'bonus'=>$directBonus,'error'=>'节点推荐人不存在或收益已领完','point'=>$pointInfo];
  139. }
  140. /* TODO 计算见单奖和分红奖励 */
  141. $points = isset($userInfo['points'])?$userInfo['points']:'';
  142. $points = $points? explode(',',$points) : [];
  143. $points = array_filter($points);
  144. $points = array_reverse($points); // 由下到上1-6层
  145. $rewardLayer = ConfigService::make()->getConfigByCode('business_reward_layer', 6);
  146. $points = array_splice($points,0, $rewardLayer);
  147. $jdBonus = ConfigService::make()->getConfigByCode("business_jd_bonus_{$mealId}", 0);
  148. $jdBonus = $jdBonus>0 && $jdBonus< $orderTotal? $jdBonus : 0;
  149. // 计算当前平台下各个等级的会员数量
  150. $levelCounts = MemberService::make()->getCountsByLevel();
  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. ->orderByRaw("FIND_IN_SET(id, ".(implode(',',$points)).")")
  155. ->get();
  156. var_dump($pointList);
  157. foreach ($pointList as $k => $point){
  158. // 默认只分6层
  159. $layer = $k+1;
  160. if($layer>$rewardLayer){
  161. continue;
  162. }
  163. // 处理见单奖
  164. $pid = isset($point['id'])?$point['id']:0;
  165. $pMark = isset($point['mark'])?$point['mark']:0;
  166. $buyType = isset($point['buy_type'])?$point['buy_type']:0;
  167. $bonusStatus = isset($point['bonus_status'])?$point['bonus_status']:0;
  168. $pLevel = isset($point['member_level'])?$point['member_level']:0;
  169. $levelWeightCountData = isset($levelCounts[$pLevel])? $levelCounts[$pLevel] : 0;
  170. $levelWeightCount = isset($levelWeightCountData['count'])? $levelWeightCountData['count']:0;
  171. $levelWeightBonus = isset($levelWeightCountData['bonus'])? $levelWeightCountData['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'=> $levelWeightBonus,
  181. 'level_bonus'=> 0,
  182. ];
  183. if($pMark==1 && $buyType==$mealId && $bonusStatus==1){
  184. $bonusData['jd_bonus'] = $jdBonus;
  185. }else{
  186. $errors["bonus_{$layer}_uid_jd"]=['uid'=>$pid,'bonus'=>$jdBonus,'error'=>"上{$layer}级节点推荐人不存在或收益已领完",'point'=>$point];
  187. }
  188. // 处理加权分红
  189. if($pLevel>0 && $levelWeightCount>0 && $levelWeightBonus>0){
  190. $bonusData['level_bonus'] = moneyFormat($levelWeightBonus * 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. if($orderGoods){
  210. foreach ($orderGoods as $goods){
  211. $lsScoreRate = isset($goods['ls_score_rate'])?$goods['ls_score_rate']:0;
  212. $lsScoreRate = $lsScoreRate>0 && $lsScoreRate<=50?$lsScoreRate : 0;
  213. $profitTotal = isset($goods['profit_total'])?$goods['profit_total'] : 0;
  214. if($profitTotal>0 && $lsScoreRate>0){
  215. $lsScoreTotal += moneyFormat($profitTotal * $lsScoreRate/100,2);
  216. }
  217. $data['ls_score_rates'][$goods['goods_id']] = $lsScoreRate;
  218. }
  219. }
  220. $data['ls_score'] = $lsScoreTotal;
  221. $data['ls_score_rates'] = json_encode($data['ls_score_rates'], 256);
  222. /* TODO 计算数字资产+底池金额 */
  223. $ptPoolRate = ConfigService::make()->getConfigByCode('pt_pool_rate', 0);
  224. $ptPoolRate = $ptPoolRate>0 && $ptPoolRate<50?$ptPoolRate:0;
  225. $rewardPropertyRate = ConfigService::make()->getConfigByCode('reward_property_rate', 0);
  226. $rewardPropertyRate = $rewardPropertyRate > 0 && $rewardPropertyRate <= 50 ? $rewardPropertyRate : 0;
  227. $propertyTotal = moneyFormat($rewardPropertyRate * $profitTotal/100,2);
  228. $poolTotal = moneyFormat($ptPoolRate * $profitTotal/100,2);
  229. $data['pt_pool_rate'] = $ptPoolRate;
  230. $data['pt_pool'] = $poolTotal;
  231. $data['property'] = $propertyTotal;
  232. $data['property_rate'] = $rewardPropertyRate;
  233. }
  234. // 佣金数据入库
  235. if(!$cid = OrderCommissionModel::where(['order_no'=>$orderNo])->value('id')){
  236. $cid = OrderCommissionModel::insertGetId($data);
  237. }else{
  238. OrderCommissionModel::where(['id'=>$cid])->update($data);
  239. }
  240. $this->error = '佣金计算成功';
  241. $data['id'] = $cid;
  242. return $data;
  243. }
  244. /**
  245. * 新人注册奖励
  246. * @param $userId
  247. * @return array|bool
  248. */
  249. public function registerReward($userId)
  250. {
  251. $rewardOpen = ConfigService::make()->getConfigByCode('register_award_coupon',0);
  252. $rewardCouponId = ConfigService::make()->getConfigByCode('register_reward_coupon_id',0);
  253. if($rewardCouponId<=0 || $rewardOpen!= 1){
  254. $this->error = '未开启或配置注册优惠券奖励';
  255. return true;
  256. }
  257. $couponInfo = CouponModel::where(['id'=>$rewardCouponId,'mark'=>1])
  258. ->first();
  259. $status = isset($couponInfo['status'])?$couponInfo['status']:0;
  260. if(empty($couponInfo) || $status != 1){
  261. $this->error = '配置的注册奖励优惠券不存在或无效';
  262. return true;
  263. }
  264. $data = [
  265. 'coupon_id'=> $rewardCouponId,
  266. 'user_id'=> $userId,
  267. 'store_id'=> isset($couponInfo['store_id'])?$couponInfo['store_id']:0,
  268. 'name'=> isset($couponInfo['name'])?$couponInfo['name']:'',
  269. 'coupon_type'=> isset($couponInfo['coupon_type'])?$couponInfo['coupon_type']: 20,
  270. 'reduce_price'=> isset($couponInfo['reduce_price'])?$couponInfo['reduce_price']:0,
  271. 'discount'=> isset($couponInfo['discount'])?$couponInfo['discount']:0,
  272. 'min_price'=> isset($couponInfo['min_price'])?$couponInfo['min_price']:0,
  273. 'expire_day'=> isset($couponInfo['expire_day'])?$couponInfo['expire_day']:0,
  274. 'start_time'=> isset($couponInfo['start_time'])?$couponInfo['start_time']:0,
  275. 'end_time'=> isset($couponInfo['end_time'])?$couponInfo['end_time']:0,
  276. 'goods_ids'=> isset($couponInfo['goods_ids'])&&$couponInfo['goods_ids']?$couponInfo['goods_ids']:'',
  277. 'create_time'=> time(),
  278. 'status'=> 1,
  279. ];
  280. if(!$id = MemberCouponModel::insertGetId($data)){
  281. $this->error = '奖励注册优惠券失败';
  282. return true;
  283. }
  284. $data['id'] = $id;
  285. $data['discount'] = floatval($data['discount']);
  286. $data['reduce_price'] = floatval($data['reduce_price']);
  287. unset($data['create_time']);
  288. unset($data['status']);
  289. unset($data['goods_ids']);
  290. $this->error = '奖励注册优惠券成功';
  291. return $data;
  292. }
  293. }