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