PerformanceLogic.php 22 KB

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