RewardLogLogic.php 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251
  1. <?php
  2. namespace addons\BossWeight\common\logic;
  3. use addons\BossWeight\common\enums\BossEnum;
  4. use addons\BossWeight\common\models\AddonsBoss;
  5. use addons\BossWeight\common\models\AddonsBossCommissionItemSetting;
  6. use addons\BossWeight\common\models\AddonsBossLevelSetting;
  7. use addons\BossWeight\common\models\AddonsBossRewardLog;
  8. use common\enums\StatusEnum;
  9. use common\helpers\FormatHelper;
  10. use common\models\mall\MallAddons;
  11. use common\models\order\Order;
  12. use yii\helpers\Json;
  13. use common\models\order\OrderDetail;
  14. use common\traits\ErrorTrait;
  15. use Exception;
  16. use yii;
  17. /**
  18. * Class RewardLog
  19. * @Author: lun
  20. * @DateTime: 2021/10/25 9:39
  21. * @Copyright: copyright (c) 2021 广东七件事集团
  22. * @package addons\BossWeight\common\logic
  23. */
  24. class RewardLogLogic
  25. {
  26. use ErrorTrait;
  27. /**
  28. * @Author: hua
  29. * @DateTime: 2021/10/18 9:57
  30. * @Copyright: copyright (c) 2021 广东七件事集团
  31. * @param $data
  32. * @return bool
  33. */
  34. public function execute($data)
  35. {
  36. try {
  37. // 查询订单信息
  38. $order = Order::getOne([['id' => $data['id']]],true,['detail'],false,'id,mall_id,order_no,order_status');
  39. if (empty($order)) throw new \yii\db\Exception("data[id]={$data['id']};order_id={$order['id']},查无此订单");
  40. if (empty($order['detail'])) throw new \yii\db\Exception("order_id={$order['id']},此订单详情为空");
  41. // 初始化数据
  42. $order_list = $order['detail'];
  43. $mallId = $order_list[0]['mall_id'];
  44. $calculate = [];// 佣金计算
  45. $amounts = 0;// 订单总金额
  46. $order_price = 0;//实付金额
  47. $date = date('Ymd', time());
  48. $time = time();
  49. // 判断用户插件是否安装
  50. if (MallAddons::isInstall($mallId, BossEnum::ADDONS_NAME) == 0) return true;
  51. // 获取基础配置
  52. $config = Yii::$app->services->setting->addons->get($mallId, 'BossWeight', 'basic');
  53. // 判断是否开启插件分润
  54. if ($config['is_enable'] == StatusEnum::DISABLED) return true;
  55. // 判断结算方式,0=支付完成,1=订单完成
  56. $settlement_method = $config['settlement_method'] == 0 ? 1 : 4;
  57. if ($order['order_status'] != $settlement_method) return true;
  58. // 获取股东等级列表
  59. $field = 'level,prize,extra_prize,is_extra,extra_type,extra_is_limit,extra_limit_price,weight_turnover_ratio,weight_level_ratio';
  60. $level_arr = AddonsBossLevelSetting::getBossLevelSetting([['mall_id' => $mallId]],[],true, $field);
  61. if (empty($level_arr)) return true;
  62. $level_arr = array_column($level_arr, null, 'level');
  63. // 获取所有股东列表
  64. $boss_list = AddonsBoss::find()->where(['mall_id' => $mallId, 'status' => StatusEnum::ENABLED])->all();
  65. if (empty($boss_list)) return true;
  66. // 统计各个股东等级的总人数
  67. $level_count = AddonsBoss::find()
  68. ->select("count(id) num,level")
  69. ->where(['mall_id' => $mallId, 'status' => StatusEnum::ENABLED])
  70. ->groupBy("level")
  71. ->indexBy("level")
  72. ->asArray()
  73. ->all();
  74. //加权分红
  75. $level_list = array_unique(array_column($boss_list,'level'));
  76. $totalWeight_list = [];
  77. foreach($level_list as $level){
  78. $totalWeight_list[$level] = CommissionLogLogic::getLevelWeight($mallId,$level);
  79. }
  80. $settlement_data = [];
  81. // 循环订单详情,对不同商品进行对应的佣金结算
  82. foreach ($order_list as $index => $detail) {
  83. // 获取结算的金额
  84. /*if ($config['compute_type'] == 0) $order_money = $detail['goods_price'];// 支付金额
  85. if ($config['compute_type'] == 1) $order_money = $detail['goods_price'] - $detail['cost_price'] + $detail['adjust_money'];// 商品利润
  86. if ($config['compute_type'] == 2) $order_money = $detail['price'];// 商品售价*/
  87. if ($config['compute_type'] == 0) $order_money = $detail['goods_price']; // 支付金额
  88. if ($config['compute_type'] == 1) $order_money = $detail['goods_price'] - bcmul($detail['cost_price'], $detail['num'], 2) + $detail['adjust_money']; // 商品利润
  89. if ($config['compute_type'] == 2) $order_money = bcmul($detail['price'], $detail['num'], 2); // 商品售价
  90. $amounts = $amounts + $order_money;//订单总计算金额
  91. $order_price += $detail['goods_price'];//订单总计算金额
  92. // 获取商品的股东分红独立配置
  93. $goods_setting = AddonsBossCommissionItemSetting::getOne([['mall_id' => $mallId], ['item_id' => $detail['goods_id']]], true, ['detail']);
  94. // 商品没参与股东分红则直接退出
  95. if (!empty($goods_setting) && $goods_setting['is_enable'] == 0) continue;
  96. // 判断是否开启独立设置
  97. if (!empty($goods_setting['is_alone']) && $goods_setting['is_alone'] == 1) {
  98. // 商品独立分佣配置
  99. $level_calculate = $goods_setting['detail'];
  100. } else {
  101. // 等级分佣配置
  102. $level_calculate = $level_arr;
  103. }
  104. // 对应的等级的永久/额外佣金计算
  105. foreach ($level_calculate as $level) {
  106. $level_num = $level_count[$level['level']]['num'];// 统计的人数
  107. if ($level_num <= 0) {
  108. $forever_commonisson = $extra_commonisson = 0;
  109. } else {
  110. $forever_commonisson = $level['prize'] ? bcdiv($order_money * $level['prize'] / $level_num, 100, 2) : 0;// 永久分红佣金,单位:元
  111. $extra_commonisson = $level['extra_prize'] ? bcdiv($order_money * $level['extra_prize'] / $level_num, 100, 2) : 0;// 额外分红佣金,单位:元
  112. }
  113. // 单个商品的结算明细
  114. $settlement_data[$level['level']][] = [
  115. 'detail_id' => $detail['id'],
  116. 'goods_id' => $detail['goods_id'],
  117. 'goods_name' => $detail['goods_name'],
  118. 'amounts' => $order_money,
  119. 'prize' => $level['prize'],
  120. 'commonisson' => $forever_commonisson,
  121. 'extra_prize' => $level['extra_prize'],
  122. 'extra_commonisson' => $extra_commonisson,
  123. ];
  124. // 分红佣金计算
  125. $calculate[$level['level']] = [
  126. 'commission' => empty($calculate[$level['level']]['commission']) ? $forever_commonisson : $calculate[$level['level']]['commission'] + $forever_commonisson,
  127. 'extra_commission' => empty($calculate[$level['level']]['extra_commission']) ? $extra_commonisson : $calculate[$level['level']]['extra_commission'] + $extra_commonisson,
  128. 'average_count' => $level_num,
  129. 'settlement_data' => $settlement_data[$level['level']],
  130. ];
  131. }
  132. }
  133. // 结算的配置
  134. $settlement_config = [
  135. 'compute_type' => $config['compute_type'],// 佣金计算方式
  136. 'settlement_method' => $config['settlement_method'],// 结算方式
  137. ];
  138. // 分红计算
  139. foreach ($boss_list as $boss) {
  140. if (empty($calculate[$boss->level])) continue;
  141. // 永久分红
  142. $rows[] = [
  143. 'mall_id' => $boss->mall_id,
  144. 'order_id' => $order['id'],
  145. 'order_no' => $order['order_no'],
  146. 'user_id' => $boss->user_id,
  147. 'type' => 1,
  148. 'level' => $boss->level,// 股东等级
  149. 'average_count' => $level_count[$boss->level]['num'],// 统计人数
  150. 'amounts' => $amounts,//计算总金额
  151. 'order_price' => $order_price,//订单总金额
  152. 'settle_price' => bcdiv($amounts*$calculate[$boss->level]['settlement_data'][0]['prize'],100,2),
  153. 'commission' => $calculate[$boss->level]['commission'],
  154. 'settlement_config' => Json::encode($settlement_config),
  155. 'settlement_data' => Json::encode($calculate[$boss->level]['settlement_data']),
  156. 'date' => $date,
  157. 'created_at' => $time,
  158. 'updated_at' => $time,
  159. ];
  160. // 判断该等级是否开启额外分红
  161. if ($level_arr[$boss->level]['is_extra'] == 0) continue;
  162. $extra_settlement_config = $settlement_config;
  163. // 判断用户是否符合额外分红条件
  164. if ($level[$boss->level]['extra_type'] == 1 && $boss->upgrade_status != 1) continue;
  165. if ($level[$boss->level]['extra_type'] == 2 && $boss->upgrade_status != 2) continue;
  166. $extra_commission = $calculate[$boss->level]['extra_commission'];
  167. // 判断是否设置额外分红上限并且用户是否达到额外分红上限
  168. if ($level_arr[$boss->level]['extra_is_limit'] == 1) {
  169. // 已超额则直接退出
  170. if ($boss->temp_extra_commission >= $level_arr[$boss->level]['extra_limit_price']) continue;
  171. // 没超额,但是加上奖励金额则超额,额外分红 = 限制金额 - 已有额外金额;
  172. if ($boss->temp_extra_commission + $calculate[$boss->level]['extra_commission'] >= $level_arr[$boss->level]['extra_limit_price']) {
  173. $extra_commission = $level_arr[$boss->level]['extra_limit_price'] - $boss->temp_extra_commission;
  174. $extra_settlement_config['extra_msg'] = '额外分红金额已达到上限,应得额外分红:¥' . $calculate[$boss->level]['extra_commission'] . ',实得额外分红:¥' . $extra_commission;
  175. }
  176. }
  177. // 额外分红
  178. $rows[] = [
  179. 'mall_id' => $boss->mall_id,
  180. 'order_id' => $order['id'],
  181. 'order_no' => $order['order_no'],
  182. 'user_id' => $boss->user_id,
  183. 'type' => 2,
  184. 'level' => $boss->level,// 股东等级
  185. 'average_count' => $level_count[$boss->level]['num'],// 统计人数
  186. 'amounts' => $amounts,
  187. 'order_price' => $order_price,//订单总金额
  188. 'settle_price' => bcdiv($amounts*$calculate[$boss->level]['settlement_data'][0]['extra_prize'],100,2),
  189. 'commission' => $extra_commission,
  190. 'settlement_config' => Json::encode($extra_settlement_config),
  191. 'settlement_data' => Json::encode($calculate[$boss->level]['settlement_data']),
  192. 'date' => $date,
  193. 'created_at' => $time,
  194. 'updated_at' => $time,
  195. ];
  196. // 增加额外分红的临时额度
  197. $boss->temp_extra_commission += $calculate[$boss->level]['extra_commission'];
  198. $boss->save();
  199. }
  200. // 保存数据
  201. if (!empty($rows)) {
  202. $trans = Yii::$app->db->beginTransaction();
  203. try {
  204. // 生成数据
  205. $field = ['mall_id','order_id','order_no','user_id','type','level','average_count','amounts','order_price','settle_price','commission','settlement_config','settlement_data','date','created_at','updated_at'];
  206. Yii::$app->db->createCommand()->batchInsert(AddonsBossRewardLog::tableName(), $field, $rows)->execute();
  207. $trans->commit();
  208. } catch (Exception $e) {
  209. $trans->rollBack();
  210. $this->setError($e->getMessage());
  211. return false;
  212. }
  213. }
  214. return true;
  215. } catch (Exception $e) {
  216. $exception = FormatHelper::exception($e, '订单触发股东分红计算错误');
  217. echo $exception;
  218. $this->setError($exception);
  219. return false;
  220. }
  221. }
  222. }