PerformanceLogic.php 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363
  1. <?php
  2. namespace app\api\logic;
  3. use app\common\enum\worker\WorkerAccountLogEnum;
  4. use app\common\logic\BaseLogic;
  5. use app\common\logic\EffectiveLogic;
  6. use app\common\logic\WorkAddMoneyLogic;
  7. use app\common\logic\WorkerAccountLogLogic;
  8. use app\common\model\financial\MasterSettlementDetails;
  9. use app\common\model\master_worker\MasterWorkerAccountLog;
  10. use app\common\model\master_worker\MasterWorkerRetentionMoneyLog;
  11. use app\common\model\orders\OrderEffectiveLog;
  12. use app\common\model\master_commission\MasterWorkerCommissionConfig;
  13. use app\common\model\master_commission\MasterWorkerCommissionRatio;
  14. use app\common\model\master_worker\MasterWorker;
  15. use app\common\model\orders\RechargeOrder;
  16. use app\common\model\performance\PerformanceRules;
  17. use app\common\model\recharge\OrderGoods;
  18. use app\common\logic\RetentionMoneyLogic;
  19. use app\common\model\works\ServiceWork;
  20. use app\common\model\works\ServiceWorkLog;
  21. use app\common\model\works\ServiceWorkSpare;
  22. use think\facade\Db;
  23. use think\facade\Log;
  24. /**
  25. * 工程师业绩逻辑层
  26. * Class PerformanceLogic
  27. * @package app\api\logic
  28. */
  29. class PerformanceLogic extends BaseLogic
  30. {
  31. /**
  32. * @param $work
  33. * @return false|void
  34. */
  35. public static function calculatePerformance($work)
  36. {
  37. Log::info('calculatePerformance:'.json_encode($work->toArray()));
  38. //工单已完结,进行结算,结算完成后设置work_pay_status为2,已结算
  39. //获取工单对应的商品id
  40. $order_sns = RechargeOrder::where('work_id',$work->id)->column('sn');
  41. $goods_id = OrderGoods::whereIn('sn',$order_sns)->value('goods_id');
  42. $rule = PerformanceRules::whereFindInSet('goods_id',$goods_id)->findOrEmpty();
  43. if($rule->isEmpty()){
  44. $work->work_pay_status = 3;
  45. }else{
  46. $work->work_pay_status = 2;
  47. }
  48. Log::info('calculatePerformance:'.json_encode($rule->toArray()));
  49. //工程师金额结算
  50. if(!$rule->isEmpty()){
  51. $coupon_price = RechargeOrder::where('work_id',$work->id)->sum('coupon_price');
  52. switch ($rule['type']){
  53. case 0://按照总金额结算
  54. $settlement_amount = bcmul(bcsub($work->work_total ,$work->spare_total), $rule['rate'],2);
  55. break;
  56. case 1://按照结算金额结算
  57. $worker_price = $work->work_amount;
  58. //$settlement_amount = bcmul($worker_price, $rule['rate'],2);
  59. // 运营新定 - 配件费不包进总工单金额扣除
  60. $settlement_amount = bcmul(bcsub($worker_price ,$work->spare_total) , $rule['rate'],2);
  61. break;
  62. case 2://按照服务总费用结算
  63. //搜索所有优惠券
  64. $worker_price = $work->service_fee-$coupon_price;
  65. $settlement_amount = bcmul(bcsub($worker_price,$work->spare_total), $rule['rate'],2);
  66. break;
  67. default://按照固定金额结算
  68. $worker_price = $work->service_fee-$coupon_price;
  69. $quantity = OrderGoods::whereIn('sn',$order_sns)->value('quantity')??1;
  70. $settlement_amount = bcmul($quantity, $rule['rate'],2);
  71. }
  72. $work->worker_price = $worker_price;
  73. // 缴纳质保金
  74. $masterWorkerInfo = MasterWorker::where('id', $work->master_worker_id)->where('retention_money_status', 1)->findOrEmpty()->toArray();
  75. Log::info('缴纳质保金工程师信息:'.json_encode($masterWorkerInfo));
  76. if(!empty($masterWorkerInfo) && $masterWorkerInfo['retention_pay_status'] == 2 && ($masterWorkerInfo['earnest_money'] > $masterWorkerInfo['earnest_money_usable'])){
  77. $retentionData['action'] = WorkerAccountLogEnum::INC;
  78. $retentionData['worker_id'] = $work->master_worker_id;
  79. $retentionData['work_id'] = $work->id;
  80. $amount = bcmul($worker_price, bcdiv($masterWorkerInfo['installment_ratio'], 100, 4),2);
  81. //$amount = bcmul($settlement_amount, bcdiv($masterWorkerInfo['installment_ratio'], 100, 4),2);
  82. $retentionData['amount'] = $amount;
  83. //$retentionData['remark'] = "分期缴纳质保金:该单实提成--{$settlement_amount},分期每单缴纳比例--{$masterWorkerInfo['installment_ratio']}%,缴纳金额--{$amount}";
  84. $retentionData['remark'] = "分期缴纳质保金:工单提成--{$worker_price},分期每单缴纳比例--{$masterWorkerInfo['installment_ratio']}%,缴纳金额--{$amount}";
  85. $settlement_amount -= (float)$amount;
  86. $surplusMoney = RetentionMoneyLogic::retentionPayment($retentionData);
  87. Log::info('分期缴纳质保金:'.$surplusMoney,$retentionData);
  88. if($surplusMoney === false){
  89. Log::info('分期缴纳质保金支付失败-'.RetentionMoneyLogic::getError(),$retentionData);
  90. $settlement_amount += (float)$amount;
  91. }else{
  92. $settlement_amount += (float)$surplusMoney;
  93. $work->earnest_money = $amount - $surplusMoney;//质保金金额
  94. }
  95. }
  96. if($settlement_amount<0){
  97. //修改工单为待结算,后台处理
  98. $work->work_pay_status = 3;
  99. }
  100. //工程师可提现金额
  101. $work->settlement_amount = $settlement_amount;
  102. //工程师加单金额判定
  103. //$add_work_amount = 0;测试
  104. $add_work_amount = WorkAddMoneyLogic::checkAddWork($work,$worker_price);
  105. $work->add_work_amount = $add_work_amount;
  106. //系统回收金额
  107. $work->system_amount = $worker_price-$settlement_amount-$work->earnest_money-$work->add_work_amount;
  108. if($work->system_amount < 0){
  109. $work->system_amount = 0;
  110. Log::info('system_amount小于0重置为0:'.$work->system_amount.'='.$worker_price.'-'.$settlement_amount.'-'.$work->earnest_money.'-'.$work->add_work_amount);
  111. }
  112. //门店结算金额
  113. if($work->tenant_id > 0){
  114. $percentage = TenantRatingCommissionLogic::getCommissionByTenantId($work->tenant_id);
  115. if($percentage > 0){
  116. $work->system_amount = bcmul($worker_price, bcdiv($percentage, 100, 4),2);
  117. $work->tenant_all_amount = $worker_price - $work->system_amount;
  118. $work->tenant_amount = $work->tenant_all_amount - $settlement_amount - $work->earnest_money - $work->add_work_amount;
  119. }
  120. Log::info('平台抽成门店的比例:'.'门店ID:'.$work->tenant_id.',平台抽成:'.$percentage);
  121. }
  122. //工程师可提现金额,汇总了加单金额
  123. $settlement_amount += (float)$work->add_work_amount;
  124. //工程师可提现金额,汇总 配件总金额
  125. $offering_price = ServiceWorkSpare::where("service_work_id", $work->id)->where('status', 1)->sum('offering_price')??0;
  126. $freezeMoney = $work->spare_total - $offering_price;
  127. if($freezeMoney > 0){
  128. // work_id
  129. $retentionMoneyLog = MasterWorkerRetentionMoneyLog::create([
  130. 'sn' => generate_sn(MasterWorkerRetentionMoneyLog::class,'sn'),
  131. 'worker_id' => $work->master_worker_id,
  132. 'action' => WorkerAccountLogEnum::DEC,
  133. 'amount' => (float)$freezeMoney,
  134. 'work_id' => $work->id,
  135. 'remark' => '配件费超时审核冻结',
  136. ])->getData();
  137. Log::info('配件费超时审核冻结:'.$work->master_worker_id.',工单Id:'.$work->id);
  138. }
  139. $settlement_amount += (float)$offering_price;
  140. Log::info('工单'.$work->id.',总服务费:'.$worker_price.'可提现金额:'.$settlement_amount.',加单金额:'.$work->add_work_amount.',缴纳质保金:'.$work->earnest_money.',系统回收金额:'.$work->system_amount.',门店总金额(包含工程师):'.$work->tenant_all_amount . ',门店实际金额:'.$work->tenant_amount);
  141. WorkerAccountLogLogic::addAccountLog($work,$settlement_amount,WorkerAccountLogEnum::UM_INC_ADMIN,WorkerAccountLogEnum::INC);
  142. }
  143. $work->save();
  144. //生成保修卡
  145. EffectiveLogic::receiveEffective($work);
  146. }
  147. public static function calculatePerformanceCommission($work)
  148. {
  149. Log::info('calculatePerformanceCommission:'.json_encode($work->toArray()));
  150. //工单已完结,进行结算,结算完成后设置work_pay_status为2,已结算
  151. //获取工单对应的商品id
  152. $order_sns = RechargeOrder::where('work_id',$work->id)->column('sn');
  153. $goods_id = OrderGoods::whereIn('sn',$order_sns)->value('goods_id');
  154. $commissionConfig = MasterWorkerCommissionConfig::where('master_worker_id',$work->master_worker_id)->where('voucher_status',2)->find()->toArray();
  155. $ratio = MasterWorkerCommissionRatio::where('commission_config_id',$commissionConfig['id'])->where('goods_category_id',$work->goods_category_id)->value('ratio');
  156. Log::info('calculatePerformanceCommission:'.json_encode([$commissionConfig,$ratio]));
  157. if($commissionConfig && 0 < $ratio && $ratio < 1){
  158. $work->work_pay_status = 2;
  159. //工程师金额结算
  160. //$coupon_price = RechargeOrder::where('work_id',$work->id)->sum('coupon_price');
  161. $work->worker_price = $work->work_total;
  162. //$settlement_amount = bcmul($work->work_total, $ratio,2);
  163. // 运营新定 - 配件费不包进总工单金额扣除
  164. $settlement_amount = bcmul(bcsub($work->worker_price,$work->spare_total), $ratio,2);
  165. // 缴纳质保金
  166. $masterWorkerInfo = MasterWorker::where('id', $work->master_worker_id)->where('retention_money_status', 1)->findOrEmpty()->toArray();
  167. Log::info('缴纳质保金工程师信息:'.json_encode($masterWorkerInfo));
  168. if(!empty($masterWorkerInfo) && $masterWorkerInfo['retention_pay_status'] == 2 && ($masterWorkerInfo['earnest_money'] > $masterWorkerInfo['earnest_money_usable'])){
  169. $retentionData['action'] = WorkerAccountLogEnum::INC;
  170. $retentionData['worker_id'] = $work->master_worker_id;
  171. $retentionData['work_id'] = $work->id;
  172. $amount = bcmul($work->worker_price, bcdiv($masterWorkerInfo['installment_ratio'], 100, 4),2);
  173. $retentionData['amount'] = $amount;
  174. $retentionData['remark'] = "分期缴纳质保金:工单提成--{$work->worker_price},分期每单缴纳比例--{$masterWorkerInfo['installment_ratio']}%,缴纳金额--{$amount}";
  175. $settlement_amount -= (float)$amount;
  176. $surplusMoney = RetentionMoneyLogic::retentionPayment($retentionData);
  177. Log::info('Commission-分期缴纳质保金:'.$surplusMoney,$retentionData);
  178. if($surplusMoney === false){
  179. Log::info('Commission-分期缴纳质保金支付失败-'.RetentionMoneyLogic::getError(),$retentionData);
  180. $settlement_amount += (float)$amount;
  181. }else{
  182. $settlement_amount += (float)$surplusMoney;
  183. $work->earnest_money = $amount - $surplusMoney;//质保金金额
  184. }
  185. }
  186. if($settlement_amount<0){
  187. //修改工单为待结算,后台处理
  188. $work->work_pay_status = 3;
  189. }
  190. //工程师可提现金额
  191. $work->settlement_amount = $settlement_amount;
  192. //工程师加单金额判定
  193. //$add_work_amount = 0;测试
  194. $add_work_amount = WorkAddMoneyLogic::checkAddWork($work,$work->worker_price);
  195. $work->add_work_amount = $add_work_amount;
  196. //系统回收金额
  197. $work->system_amount = $work->worker_price-$settlement_amount-$work->earnest_money-$work->add_work_amount;
  198. if($work->system_amount < 0){
  199. $work->system_amount = 0;
  200. Log::info('calculatePerformanceCommission:system_amount小于0重置为0:'.$work->system_amount.'='.$work->worker_price.'-'.$settlement_amount.'-'.$work->earnest_money.'-'.$work->add_work_amount);
  201. }
  202. //门店结算金额
  203. if($work->tenant_id > 0){
  204. $percentage = TenantRatingCommissionLogic::getCommissionByTenantId($work->tenant_id);
  205. if($percentage > 0){
  206. $work->system_amount = bcmul($work->worker_price, bcdiv($percentage, 100, 4),2);
  207. $work->tenant_all_amount = $work->worker_price - $work->system_amount;
  208. $work->tenant_amount = $work->tenant_all_amount - $settlement_amount - $work->earnest_money - $work->add_work_amount;
  209. }
  210. Log::info('calculatePerformanceCommission:平台抽成门店的比例:'.'门店ID:'.$work->tenant_id.',平台抽成:'.$percentage);
  211. }
  212. //工程师可提现金额,汇总了加单金额
  213. $settlement_amount += (float)$work->add_work_amount;
  214. //工程师可提现金额,汇总 配件总金额
  215. $offering_price = ServiceWorkSpare::where("service_work_id", $work->id)->where('status', 1)->sum('offering_price')??0;
  216. $freezeMoney = $work->spare_total - $offering_price;
  217. if($freezeMoney > 0){
  218. // work_id
  219. $retentionMoneyLog = MasterWorkerRetentionMoneyLog::create([
  220. 'sn' => generate_sn(MasterWorkerRetentionMoneyLog::class,'sn'),
  221. 'worker_id' => $work->master_worker_id,
  222. 'action' => WorkerAccountLogEnum::DEC,
  223. 'amount' => (float)$freezeMoney,
  224. 'work_id' => $work->id,
  225. 'remark' => '配件费超时审核冻结',
  226. ])->getData();
  227. Log::info('配件费超时审核冻结:'.$work->master_worker_id.',工单Id:'.$work->id);
  228. }
  229. $settlement_amount += (float)$offering_price;
  230. Log::info('calculatePerformanceCommission:工单'.$work->id.',总服务费:'.$work->worker_price.'可提现金额:'.$settlement_amount.',加单金额:'.$work->add_work_amount.',缴纳质保金:'.$work->earnest_money.',系统回收金额:'.$work->system_amount.',门店总金额(包含工程师):'.$work->tenant_all_amount . ',门店实际金额:'.$work->tenant_amount);
  231. WorkerAccountLogLogic::addAccountLog($work,$settlement_amount,WorkerAccountLogEnum::UM_INC_ADMIN,WorkerAccountLogEnum::INC);
  232. }
  233. $work->save();
  234. //生成保修卡
  235. EffectiveLogic::receiveEffective($work);
  236. }
  237. /**
  238. * @notes 保修单结算
  239. * @param $work
  240. * @return bool|mixed
  241. */
  242. public static function effectivePerformance($work)
  243. {
  244. if(empty($work->order_effective_id)){
  245. return false;
  246. }
  247. Log::info('effectivePerformance:'.json_encode($work->toArray()));
  248. // 判断该工单是否为新工程师 - 保修前工单的工程师是谁
  249. $orderEffectiveLog = OrderEffectiveLog::where('id',$work->order_effective_id)->findOrEmpty();
  250. if($orderEffectiveLog->effective_status == 3){
  251. return false;
  252. }
  253. // 前工单
  254. $serviceWork = ServiceWork::where('id',$orderEffectiveLog->work_id)->findOrEmpty();
  255. if($serviceWork->master_worker_id != $work->master_worker_id){
  256. // 扣掉 原工单工程师的提成+质保金 to 新工程师余额 + 惩罚金额
  257. $income_fee = \app\adminapi\logic\effective\OrderEffectiveLogLogic::commissionAndAssuranceDeposit($serviceWork);
  258. $new_amount = bcadd((string)$income_fee,(string)$orderEffectiveLog->penalty_amount,2);
  259. $remark = '工单号:'.$work->work_sn.',扣除金额:'.$new_amount.',扣除原因:保修工单新工程师收益';
  260. RetentionMoneyLogic::refundRetention([
  261. 'remark'=>$remark,
  262. 'work_id'=>$work->id,
  263. 'worker_id'=>$serviceWork->master_worker_id,
  264. 'amount'=>$new_amount
  265. ],false);
  266. // 新工程师收益: 原工单工程师的提成+质保金
  267. $remark = '保修单结算-工单号:'.$work->work_sn.',收益金额:'.$income_fee.',原因:保修工单新工程师收益';
  268. WorkerAccountLogLogic::addAccountLog($work,$income_fee,WorkerAccountLogEnum::UM_INC_ADMIN,WorkerAccountLogEnum::INC,$remark);
  269. Log::info('effectivePerformance:'.$remark);
  270. }else{
  271. $new_amount = $orderEffectiveLog->penalty_amount;
  272. $remark = '工单号:'.$work->work_sn.',扣除金额:'.$new_amount.',扣除原因:保修工单原工程师差额|罚金';
  273. RetentionMoneyLogic::refundRetention([
  274. 'remark'=>$remark,
  275. 'work_id'=>$work->id,
  276. 'worker_id'=>$serviceWork->master_worker_id,
  277. 'amount'=>$new_amount
  278. ],false);
  279. }
  280. $orderEffectiveLog->effective_status = 3;
  281. $orderEffectiveLog->save();
  282. $work->work_pay_status = 2;
  283. $work->save();
  284. return true;
  285. }
  286. /**
  287. * @notes 临时 - 计算工程师提成
  288. * @param $work
  289. * @return void
  290. * @throws \think\Exception
  291. * @author liugc <466014217@qq.com>
  292. * @date 2025/4/23 10:27
  293. */
  294. public static function calculatePerformanceTmp($work)
  295. {
  296. Log::info('calculatePerformance:'.json_encode($work->toArray()));
  297. Db::startTrans();
  298. try {
  299. /*$masterWorkerAccountLog = MasterWorkerAccountLog::where('action',1)->where('worker_id',$work->master_worker_id)->where('work_sn',$work->work_sn)->findOrEmpty();
  300. $masterWorkerRetentionMoneyLog = MasterWorkerRetentionMoneyLog::where('action',1)->where('work_id',$work->id)->where('worker_id',$work->master_worker_id)->findOrEmpty();
  301. $masterWorker = MasterWorker::where('id', $work->master_worker_id)->findOrEmpty();
  302. if(!$masterWorkerRetentionMoneyLog->isEmpty()){
  303. $masterWorker->earnest_money_usable -= $masterWorkerRetentionMoneyLog->amount;
  304. $masterWorkerRetentionMoneyLog->delete();
  305. //MasterWorkerRetentionMoneyLog::destroy(['id'=>$masterWorkerRetentionMoneyLog->id]);
  306. }
  307. if(!$masterWorkerAccountLog->isEmpty()){
  308. $masterWorker->user_money -= $masterWorkerAccountLog->change_amount;
  309. MasterSettlementDetails::where('account_log_id', $masterWorkerAccountLog->id)->delete();
  310. //$masterWorkerAccountLog->delete();
  311. MasterWorkerAccountLog::destroy(['id'=>$masterWorkerAccountLog->id],true);
  312. }
  313. $masterWorker->save();
  314. OrderEffectiveLog::where('work_id',$work->id)->delete();
  315. self::calculatePerformance($work);*/
  316. Db::commit();
  317. } catch (\Exception $e) {
  318. Db::rollback();
  319. throw new \Exception($e->getMessage());
  320. }
  321. }
  322. }