PerformanceLogic.php 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377
  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($worker_price, $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. self::spareAmountFrozen(['work_id'=>$work->id,'worker_id'=>$work->master_worker_id,'amount'=>(float)$freezeMoney,'remark'=>'配件费审核冻结']);
  130. Log::info('配件费超时审核冻结:'.$work->master_worker_id.',工单Id:'.$work->id. ',配件费冻结金额:'.$freezeMoney);
  131. }
  132. $settlement_amount += (float)$offering_price;
  133. 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);
  134. WorkerAccountLogLogic::addAccountLog($work,$settlement_amount,WorkerAccountLogEnum::UM_INC_ADMIN,WorkerAccountLogEnum::INC);
  135. }
  136. $work->save();
  137. //生成保修卡
  138. EffectiveLogic::receiveEffective($work);
  139. }
  140. public static function calculatePerformanceCommission($work)
  141. {
  142. Log::info('calculatePerformanceCommission:'.json_encode($work->toArray()));
  143. //工单已完结,进行结算,结算完成后设置work_pay_status为2,已结算
  144. //获取工单对应的商品id
  145. $order_sns = RechargeOrder::where('work_id',$work->id)->column('sn');
  146. $goods_id = OrderGoods::whereIn('sn',$order_sns)->value('goods_id');
  147. $commissionConfig = MasterWorkerCommissionConfig::where('master_worker_id',$work->master_worker_id)->where('voucher_status',2)->find()->toArray();
  148. $ratio = MasterWorkerCommissionRatio::where('commission_config_id',$commissionConfig['id'])->where('goods_category_id',$work->goods_category_id)->value('ratio');
  149. Log::info('calculatePerformanceCommission:'.json_encode([$commissionConfig,$ratio]));
  150. if($commissionConfig && 0 < $ratio && $ratio < 1){
  151. $work->work_pay_status = 2;
  152. //工程师金额结算
  153. //$coupon_price = RechargeOrder::where('work_id',$work->id)->sum('coupon_price');
  154. $work->worker_price = $work->work_total;
  155. //$settlement_amount = bcmul($work->work_total, $ratio,2);
  156. // 运营新定 - 配件费不包进总工单金额扣除
  157. $settlement_amount = bcmul(bcsub($work->worker_price,$work->spare_total), $ratio,2);
  158. // 缴纳质保金
  159. $masterWorkerInfo = MasterWorker::where('id', $work->master_worker_id)->where('retention_money_status', 1)->findOrEmpty()->toArray();
  160. Log::info('缴纳质保金工程师信息:'.json_encode($masterWorkerInfo));
  161. if(!empty($masterWorkerInfo) && $masterWorkerInfo['retention_pay_status'] == 2 && ($masterWorkerInfo['earnest_money'] > $masterWorkerInfo['earnest_money_usable'])){
  162. $retentionData['action'] = WorkerAccountLogEnum::INC;
  163. $retentionData['worker_id'] = $work->master_worker_id;
  164. $retentionData['work_id'] = $work->id;
  165. $amount = bcmul($work->worker_price, bcdiv($masterWorkerInfo['installment_ratio'], 100, 4),2);
  166. $retentionData['amount'] = $amount;
  167. $retentionData['remark'] = "分期缴纳质保金:工单提成--{$work->worker_price},分期每单缴纳比例--{$masterWorkerInfo['installment_ratio']}%,缴纳金额--{$amount}";
  168. $settlement_amount -= (float)$amount;
  169. $surplusMoney = RetentionMoneyLogic::retentionPayment($retentionData);
  170. Log::info('Commission-分期缴纳质保金:'.$surplusMoney,$retentionData);
  171. if($surplusMoney === false){
  172. Log::info('Commission-分期缴纳质保金支付失败-'.RetentionMoneyLogic::getError(),$retentionData);
  173. $settlement_amount += (float)$amount;
  174. }else{
  175. $settlement_amount += (float)$surplusMoney;
  176. $work->earnest_money = $amount - $surplusMoney;//质保金金额
  177. }
  178. }
  179. if($settlement_amount<0){
  180. //修改工单为待结算,后台处理
  181. $work->work_pay_status = 3;
  182. }
  183. //工程师可提现金额
  184. $work->settlement_amount = $settlement_amount;
  185. //工程师加单金额判定
  186. //$add_work_amount = 0;测试
  187. $add_work_amount = WorkAddMoneyLogic::checkAddWork($work,$work->worker_price);
  188. $work->add_work_amount = $add_work_amount;
  189. //系统回收金额
  190. $work->system_amount = $work->worker_price-$settlement_amount-$work->earnest_money-$work->add_work_amount;
  191. if($work->system_amount < 0){
  192. $work->system_amount = 0;
  193. Log::info('calculatePerformanceCommission:system_amount小于0重置为0:'.$work->system_amount.'='.$work->worker_price.'-'.$settlement_amount.'-'.$work->earnest_money.'-'.$work->add_work_amount);
  194. }
  195. //门店结算金额
  196. if($work->tenant_id > 0){
  197. $percentage = TenantRatingCommissionLogic::getCommissionByTenantId($work->tenant_id);
  198. if($percentage > 0){
  199. $work->system_amount = bcmul($work->worker_price, bcdiv($percentage, 100, 4),2);
  200. $work->tenant_all_amount = $work->worker_price - $work->system_amount;
  201. $work->tenant_amount = $work->tenant_all_amount - $settlement_amount - $work->earnest_money - $work->add_work_amount;
  202. }
  203. Log::info('calculatePerformanceCommission:平台抽成门店的比例:'.'门店ID:'.$work->tenant_id.',平台抽成:'.$percentage);
  204. }
  205. //工程师可提现金额,汇总了加单金额
  206. $settlement_amount += (float)$work->add_work_amount;
  207. //工程师可提现金额,汇总 配件总金额
  208. $offering_price = ServiceWorkSpare::where("service_work_id", $work->id)->where('status', 1)->sum('offering_price')??0;
  209. $freezeMoney = $work->spare_total - $offering_price;
  210. if($freezeMoney > 0){
  211. // work_id
  212. self::spareAmountFrozen(['work_id'=>$work->id,'worker_id'=>$work->master_worker_id,'amount'=>(float)$freezeMoney,'remark'=>'配件费审核冻结']);
  213. Log::info('配件费超时审核冻结:'.$work->master_worker_id.',工单Id:'.$work->id. ',配件费冻结金额:'.$freezeMoney);
  214. }
  215. $settlement_amount += (float)$offering_price;
  216. 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);
  217. WorkerAccountLogLogic::addAccountLog($work,$settlement_amount,WorkerAccountLogEnum::UM_INC_ADMIN,WorkerAccountLogEnum::INC);
  218. }
  219. $work->save();
  220. //生成保修卡
  221. EffectiveLogic::receiveEffective($work);
  222. }
  223. /**
  224. * @notes 保修单结算
  225. * @param $work
  226. * @return bool|mixed
  227. */
  228. public static function effectivePerformance($work)
  229. {
  230. if(empty($work->order_effective_id)){
  231. return false;
  232. }
  233. Log::info('effectivePerformance:'.json_encode($work->toArray()));
  234. // 判断该工单是否为新工程师 - 保修前工单的工程师是谁
  235. $orderEffectiveLog = OrderEffectiveLog::where('id',$work->order_effective_id)->findOrEmpty();
  236. if($orderEffectiveLog->effective_status == 3){
  237. return false;
  238. }
  239. // 前工单
  240. $serviceWork = ServiceWork::where('id',$orderEffectiveLog->work_id)->findOrEmpty();
  241. if($serviceWork->master_worker_id != $work->master_worker_id){
  242. // 扣掉 原工单工程师的提成+质保金 to 新工程师余额 + 惩罚金额
  243. $income_fee = \app\adminapi\logic\effective\OrderEffectiveLogLogic::commissionAndAssuranceDeposit($serviceWork);
  244. $new_amount = bcadd((string)$income_fee,(string)$orderEffectiveLog->penalty_amount,2);
  245. $remark = '工单号:'.$work->work_sn.',扣除金额:'.$new_amount.',扣除原因:保修工单新工程师收益';
  246. RetentionMoneyLogic::refundRetention([
  247. 'remark'=>$remark,
  248. 'work_id'=>$work->id,
  249. 'worker_id'=>$serviceWork->master_worker_id,
  250. 'amount'=>$new_amount
  251. ],false);
  252. // 新工程师收益: 原工单工程师的提成+质保金
  253. $remark = '保修单结算-工单号:'.$work->work_sn.',收益金额:'.$income_fee.',原因:保修工单新工程师收益';
  254. WorkerAccountLogLogic::addAccountLog($work,$income_fee,WorkerAccountLogEnum::UM_INC_ADMIN,WorkerAccountLogEnum::INC,$remark);
  255. Log::info('effectivePerformance:'.$remark);
  256. }else{
  257. $new_amount = $orderEffectiveLog->penalty_amount;
  258. $remark = '工单号:'.$work->work_sn.',扣除金额:'.$new_amount.',扣除原因:保修工单原工程师差额|罚金';
  259. RetentionMoneyLogic::refundRetention([
  260. 'remark'=>$remark,
  261. 'work_id'=>$work->id,
  262. 'worker_id'=>$serviceWork->master_worker_id,
  263. 'amount'=>$new_amount
  264. ],false);
  265. }
  266. $orderEffectiveLog->effective_status = 3;
  267. $orderEffectiveLog->save();
  268. $work->work_pay_status = 2;
  269. $work->save();
  270. return true;
  271. }
  272. /**
  273. * @notes 临时 - 计算工程师提成
  274. * @param $work
  275. * @return void
  276. * @throws \think\Exception
  277. * @author liugc <466014217@qq.com>
  278. * @date 2025/4/23 10:27
  279. */
  280. public static function calculatePerformanceTmp($work)
  281. {
  282. Log::info('calculatePerformance:'.json_encode($work->toArray()));
  283. Db::startTrans();
  284. try {
  285. /*$masterWorkerAccountLog = MasterWorkerAccountLog::where('action',1)->where('worker_id',$work->master_worker_id)->where('work_sn',$work->work_sn)->findOrEmpty();
  286. $masterWorkerRetentionMoneyLog = MasterWorkerRetentionMoneyLog::where('action',1)->where('work_id',$work->id)->where('worker_id',$work->master_worker_id)->findOrEmpty();
  287. $masterWorker = MasterWorker::where('id', $work->master_worker_id)->findOrEmpty();
  288. if(!$masterWorkerRetentionMoneyLog->isEmpty()){
  289. $masterWorker->earnest_money_usable -= $masterWorkerRetentionMoneyLog->amount;
  290. $masterWorkerRetentionMoneyLog->delete();
  291. //MasterWorkerRetentionMoneyLog::destroy(['id'=>$masterWorkerRetentionMoneyLog->id]);
  292. }
  293. if(!$masterWorkerAccountLog->isEmpty()){
  294. $masterWorker->user_money -= $masterWorkerAccountLog->change_amount;
  295. MasterSettlementDetails::where('account_log_id', $masterWorkerAccountLog->id)->delete();
  296. //$masterWorkerAccountLog->delete();
  297. MasterWorkerAccountLog::destroy(['id'=>$masterWorkerAccountLog->id],true);
  298. }
  299. $masterWorker->save();
  300. OrderEffectiveLog::where('work_id',$work->id)->delete();
  301. self::calculatePerformance($work);*/
  302. Db::commit();
  303. } catch (\Exception $e) {
  304. Db::rollback();
  305. throw new \Exception($e->getMessage());
  306. }
  307. }
  308. /**
  309. * 配件金额 冻结
  310. * @param $work
  311. * @throws \Exception
  312. * @author liugc <466014217@qq.com>
  313. * @date 2025/6/3 11:45
  314. */
  315. public static function spareAmountFrozen($params)
  316. {
  317. try {
  318. $masterWorkerInfo = MasterWorker::where('id', $params['worker_id'])->findOrEmpty();
  319. $masterWorkerInfo->earnest_money_freeze += $params['amount'];
  320. $masterWorkerInfo->save();
  321. MasterWorkerRetentionMoneyLog::create([
  322. 'sn' => generate_sn(MasterWorkerRetentionMoneyLog::class,'sn'),
  323. 'worker_id' => $params['worker_id'],
  324. 'action' => WorkerAccountLogEnum::DEC,
  325. 'amount' => $params['amount'],
  326. 'work_id' => $params['work_id'],
  327. 'remark' => $params['remark'],
  328. ])->getData();
  329. return true;
  330. } catch (\Exception $e) {
  331. Log::info('spareAmountFrozen:'.$e->getMessage());
  332. return false;
  333. }
  334. }
  335. }