1
0

PerformanceLogic.php 23 KB

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