java-insagent-pc/src/main/java/com/ydtech/modules/admin/service/impl/SysUserAccountServiceImpl.java

package com.ydtech.modules.admin.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ydtech.core.page.HttpResult;
import com.ydtech.modules.admin.constants.MoneyAttrConstants;
import com.ydtech.modules.admin.constants.WithdrawTypeConstants;
import com.ydtech.modules.admin.dao.SysUserAccountMapper;
import com.ydtech.modules.admin.model.po.SysAmountAuditingEntity;
import com.ydtech.modules.admin.model.po.SysUserAccount;
import com.ydtech.modules.admin.model.po.SysUserAccountHistory;
import com.ydtech.modules.admin.model.po.SysUserBankCard;
import com.ydtech.modules.admin.model.vo.SysUserAccountVo;
import com.ydtech.modules.admin.model.vo.SysUserBankCardVO;
import com.ydtech.modules.admin.service.*;
import com.ydtech.modules.base.controller.BaseController;
import com.ydtech.modules.esm.model.EsmUserReferrer;
import com.ydtech.modules.esm.service.EsmUserReferrerService;
import com.ydtech.modules.order.entity.BasePageResult;
import com.ydtech.modules.order.entity.InsAreaCompany;
import com.ydtech.modules.order.entity.InsOrders;
import com.ydtech.modules.order.service.InsAreaCompanyService;
import com.ydtech.modules.order.service.InsOrdersService;
import com.ydtech.modules.protocols.entity.po.InsFeeOrderNew;
import com.ydtech.modules.protocols.service.InsFeeOrderNewService;
import org.apache.commons.lang3.ObjectUtils;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.util.CollectionUtils;

import java.math.BigDecimal;
import java.math.RoundingMode;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;

/**
 * @author Administrator
 * @description 针对表【sys_user_account(用户账户表)】的数据库操作Service实现
 * @createDate 2024-03-05 11:52:30
 */
@Service
public class SysUserAccountServiceImpl extends ServiceImpl<SysUserAccountMapper, SysUserAccount> implements SysUserAccountService {

    @Autowired
    private SysUserAccountHistoryService sysUserAccountHistoryService;
    @Autowired
    private EsmUserReferrerService esmUserReferrerService;
    @Autowired
    private SysAmountAuditingService sysAmountAuditingService;

    @Autowired
    private SysUserBankCardService sysUserBankCardService;
    @Autowired
    private InsAreaCompanyService insAreaCompanyService;
    @Autowired
    private InsFeeOrderNewService  insFeeOrderNewService;

    @Override
    @Transactional
    public void addOrUpdate(SysUserAccount sysUserAccount) {
        SysUserAccount newSysAccount = baseMapper.getById(sysUserAccount.getUserId());
//         初始化
        if(sysUserAccount.getHandlingFee()==null){
            sysUserAccount.setHandlingFee(BigDecimal.ZERO);
        }
        if(sysUserAccount.getDocumentary()==null){
            sysUserAccount.setDocumentary(BigDecimal.ZERO);
        }
        if(sysUserAccount.getPromotion()==null){
            sysUserAccount.setPromotion(BigDecimal.ZERO);
        }

//      如果用户id有值则累加   没有则 新增
        String userId = sysUserAccount.getUserId();
        SysUserAccount sysUserAccountEntity = super.getById(userId);
        SysUserAccount newAccount = new SysUserAccount();

        if (ObjectUtils.isNotEmpty(sysUserAccountEntity)) {
            sysUserAccountEntity.setHandlingFee(sysUserAccount.getHandlingFee().add(sysUserAccountEntity.getHandlingFee()));
            sysUserAccountEntity.setDocumentary(sysUserAccount.getDocumentary().add(sysUserAccountEntity.getDocumentary()));
            sysUserAccountEntity.setPromotion(sysUserAccount.getPromotion().add(sysUserAccountEntity.getPromotion()));
            if (StringUtils.isNotEmpty(sysUserAccount.getDocumentaryStatus())) {
                sysUserAccountEntity.setDocumentaryStatus(sysUserAccount.getDocumentaryStatus());
            }
            baseMapper.updateById(sysUserAccountEntity);
        } else {
            sysUserAccountEntity = new SysUserAccount();
            sysUserAccountEntity.setUserId(userId);
            sysUserAccountEntity.setDocumentary(sysUserAccount.getDocumentary());
            sysUserAccountEntity.setPromotion(sysUserAccount.getPromotion());
            sysUserAccountEntity.setHandlingFee(sysUserAccount.getHandlingFee());
            if (StringUtils.isNotEmpty(sysUserAccount.getDocumentaryStatus())) {
                sysUserAccountEntity.setDocumentaryStatus(sysUserAccount.getDocumentaryStatus());
            }
            baseMapper.insert(sysUserAccountEntity);
        }

        if (StringUtils.isNotEmpty(sysUserAccount.getDocumentaryStatus())) {
//          判断是否是一级二级三级
            SysUserAccountHistory sysUserAccountHistory = new SysUserAccountHistory();
            sysUserAccountHistory.setUserId(sysUserAccount.getUserId());
            sysUserAccountHistory.setDocumentary(Integer.valueOf(sysUserAccount.getDocumentaryStatus()));
            sysUserAccountHistory.setSuborder(sysUserAccount.getSuborderId());
            //跟单费
            if(sysUserAccount.getDocumentary()!=null && sysUserAccount.getDocumentary().compareTo(BigDecimal.ZERO)!=0){
                sysUserAccountHistory.setAmount(sysUserAccount.getDocumentary());
                sysUserAccountHistory.setProperty(MoneyAttrConstants.M_2.getCode());
                if(WithdrawTypeConstants.WT_2.getCode().equals(sysUserAccount.getDocumentaryStatus())){ // 收入  相加
                    sysUserAccountHistory.setSurplusAmount(sysUserAccountEntity.getDocumentary());
                }else {
                    BigDecimal subtract = newSysAccount.getDocumentary().subtract(sysUserAccount.getDocumentary());
                    sysUserAccountHistory.setSurplusAmount(subtract);
                }
                sysUserAccountHistoryService.updayteByUserAccount(sysUserAccountHistory);
            }
            //手续费
            if(sysUserAccount.getHandlingFee()!=null  &&  sysUserAccount.getHandlingFee().compareTo(BigDecimal.ZERO) !=0){
                sysUserAccountHistory.setId(null);
                sysUserAccountHistory.setAmount(sysUserAccount.getHandlingFee());
                sysUserAccountHistory.setProperty(MoneyAttrConstants.M_1.getCode());
                if(WithdrawTypeConstants.WT_2.getCode().equals(sysUserAccount.getDocumentaryStatus())){ // 收入  相加
                    sysUserAccountHistory.setSurplusAmount(sysUserAccountEntity.getHandlingFee());
                }else {
                    BigDecimal subtract = newSysAccount.getHandlingFee().subtract(sysUserAccount.getHandlingFee());
                    sysUserAccountHistory.setSurplusAmount(subtract);
                }
                sysUserAccountHistoryService.updayteByUserAccount(sysUserAccountHistory);
            }
            //推广费
            if(sysUserAccount.getPromotion() !=null && sysUserAccount.getPromotion().compareTo(BigDecimal.ZERO) !=0){
                sysUserAccountHistory.setId(null);

                sysUserAccountHistory.setAmount(sysUserAccount.getPromotion());
                sysUserAccountHistory.setProperty(MoneyAttrConstants.M_3.getCode());
                if(WithdrawTypeConstants.WT_2.getCode().equals(sysUserAccount.getDocumentaryStatus())){ // 收入  相加
                    sysUserAccountHistory.setSurplusAmount(sysUserAccountEntity.getPromotion());
                }else {
                    BigDecimal subtract = newSysAccount.getPromotion().subtract(sysUserAccount.getPromotion());
                    sysUserAccountHistory.setSurplusAmount(subtract);
                }
                sysUserAccountHistoryService.updayteByUserAccount(sysUserAccountHistory);

            }
        }


    }

    @Override
    public BasePageResult<SysUserAccount> queryByVo(SysUserAccountVo sysUserAccountVo) {
        Page<SysUserAccount> page = new Page<>(sysUserAccountVo.getPageNum(), sysUserAccountVo.getPageSize());
        QueryWrapper<SysUserAccount> wrapper = new QueryWrapper<>();

        Page<SysUserAccount> sysUserAccountHistoryPage = baseMapper.queryPageOrder(sysUserAccountVo, page);
        return new BasePageResult<>(sysUserAccountVo.getPageNum(), page.getSize(), sysUserAccountHistoryPage.getTotal(), page.getPages(),
                sysUserAccountHistoryPage.getRecords());
    }

    @Override
    @Transactional
    public HttpResult<Object> inert(SysUserAccountVo sysUserAccountVo) {
        String userId = BaseController.getUser().getId();
        BigDecimal zero = BigDecimal.ZERO;
        BigDecimal beforeAmount;
        BigDecimal afterAmount;
//       用户当前金额
        BigDecimal amount = sysUserAccountVo.getAmount();
        SysUserAccountHistory sysUserAccountHistory = new SysUserAccountHistory();  // 记录
        sysUserAccountHistory.setDocumentary(1);  // 1提现
        sysUserAccountHistory.setUserId(userId);
        SysAmountAuditingEntity sysAmountAuditingEntity = new SysAmountAuditingEntity();//审核记录表
        sysAmountAuditingEntity.setUserId(userId);
        sysAmountAuditingEntity.setAmount(sysUserAccountVo.getAmount());
        SysAmountAuditingEntity   judge =    sysAmountAuditingService.getByUserId(userId);
        if(ObjectUtils.isNotEmpty(judge)){
            return HttpResult.ok("有未提现审核单据, 请审核完成之后再提现");
        }
//      通过银行卡id 查询卡包
        Long fromBankCardId = sysUserAccountVo.getFromBankCardId();
        if(fromBankCardId!=null){
            SysUserBankCard byId = sysUserBankCardService.getById(fromBankCardId);
            String bankUserId = byId.getUserId();
            if(!userId.equals(bankUserId)){
                return HttpResult.ok("非本人提现");
            }
            byId.setIsDefault(1);

            sysAmountAuditingEntity.setBankNumber( byId.getBankNumber());
            sysUserAccountHistory.setFromBankCard( byId.getBankNumber());
            sysUserBankCardService.updateById(byId);
        }

        if (StringUtils.isNotEmpty(userId)) {
            SysUserAccount sysUserAccount = baseMapper.getById(userId);


            if (StringUtils.isNotEmpty(sysUserAccountVo.getAmountStatus())) {
                sysUserAccountHistory.setProperty(Integer.valueOf(sysUserAccountVo.getAmountStatus()));   //金额类型

                if ("1".equals(sysUserAccountVo.getAmountStatus())) {
//                  用户当前费用金
                    beforeAmount = sysUserAccount.getHandlingFee();
                    afterAmount = beforeAmount.subtract(amount);
                } else if ("2".equals(sysUserAccountVo.getAmountStatus())) {
//                    用户当前 非跟单佣金
                    beforeAmount = sysUserAccount.getDocumentary();
                    afterAmount = beforeAmount.subtract(amount);
                } else {
                    beforeAmount = sysUserAccount.getPromotion();
                    afterAmount = beforeAmount.subtract(amount);
                }
//              用户相差
                if (beforeAmount.compareTo(zero) == 0 || afterAmount.compareTo(zero) < 0) {
                    return HttpResult.ok("余额不足");
                }
                sysUserAccountHistory.setAmount(amount);  // 金额
                sysUserAccountHistory.setSurplusAmount(afterAmount); // 剩余金额
                sysUserAccountHistory.setUserAmount(beforeAmount);   // 用户剩余金额
                sysAmountAuditingEntity.setCreateTime(new Date());
                sysAmountAuditingEntity.setAuditingStatus("2");   // 2  为待审核  3  审核通过
                sysAmountAuditingEntity.setAmountStatus(sysUserAccountVo.getAmountStatus());
//              新增金额记录
                sysAmountAuditingService.save(sysAmountAuditingEntity);
                sysUserAccountHistory.setAuditiingId(sysAmountAuditingEntity.getId());

                sysUserAccountHistoryService.updayteByUserAccount(sysUserAccountHistory);
            }

        }
        return HttpResult.ok("提现成功，等待审核");
    }

    @Override
    public SysUserAccount getSysUserAmount(String userid) {
        SysUserAccount sysUserAccount = baseMapper.getById(userid);

        return sysUserAccount;
    }

    @Override
    public SysUserAccountVo getSysAllAmount(String userId) {
        SysUserAccountVo sysUserAccountVo = new SysUserAccountVo();
        SysUserAccount sysUserAccount = baseMapper.getById(userId);
        BeanUtils.copyProperties(sysUserAccount, sysUserAccountVo);

        BigDecimal  willHalding=BigDecimal.ZERO;        //预收手续费佣金
        BigDecimal  willDocumentary =BigDecimal.ZERO;   //预收 非跟单佣金
        BigDecimal  willPromotion =BigDecimal.ZERO;   //预收 推广
        StringBuffer stringBuffer = new StringBuffer();

        willPromotion =   this.willPromotion(willPromotion,userId);  // 佣金
        List<InsOrders> willList = insAreaCompanyService.getByUserId(userId);
        if(!CollectionUtils.isEmpty(willList)){
           for (InsOrders item : willList){
               String quoteno = item.getQuoteno();
               stringBuffer.append(quoteno).append(",");
               if(StringUtils.isNotEmpty(quoteno)){
                  this.willAmount(quoteno,willHalding,willDocumentary,sysUserAccountVo);  // 推广 非跟单
               }
           }

        }
//        体现中
        HashMap<String, Object> params = new HashMap<>();
        params.put("auditingStatus","2");  // 待审核
        params.put("userId",userId);
        List<SysAmountAuditingEntity>  sysAmountAuditingProgressIng=  sysAmountAuditingService.getProgressIng(params);
        this.judge(sysAmountAuditingProgressIng,sysUserAccountVo);
        params.clear();
        params.put("auditingStatus","3");  // 已审核审核
        params.put("userId",userId);
        List<SysAmountAuditingEntity>  sysAmountAuditingApproved=  sysAmountAuditingService.getProgressIng(params);
        this.judgeSysAmountAuditing(sysAmountAuditingApproved,sysUserAccountVo);
        sysUserAccountVo.setWillPromotion(willPromotion);
        String ids = stringBuffer.toString();
        if (ids.endsWith(",")) {
            ids = ids.substring(0, ids.length() - 1);  // 去掉末尾的逗号
        }
        sysUserAccountVo.setIds(ids);
        return sysUserAccountVo;
    }

    @Override
    public SysUserAccountVo getInsOrders(SysUserAccountVo sysUserAccountVo) {
        ArrayList<InsFeeOrderNew> resultList = new ArrayList<>();
        BigDecimal willPromotion = BigDecimal.ZERO;
        if(StringUtils.isNotEmpty(sysUserAccountVo.getIds())){
            for (String insOrderNo : sysUserAccountVo.getIds().split(",")) {
                InsAreaCompany byInsOrderNo = insAreaCompanyService.getByInsOrderNoNew(insOrderNo,sysUserAccountVo.getTimeFiltering());
                if(ObjectUtils.isNotEmpty(byInsOrderNo)){
                    String id = byInsOrderNo.getId();
                    InsFeeOrderNew insFeeOrderNew = insFeeOrderNewService.getInsFeeOrderEntity(id);
                    insFeeOrderNew.setAmountType(sysUserAccountVo.getAmountType());
                    //预收推广
                    willPromotion =this.getWillPromotion(insFeeOrderNew,willPromotion);
                    this.getWillAmount(insFeeOrderNew);  // 推广 非跟单
                    if(StringUtils.isNotEmpty(sysUserAccountVo.getAmountType())  &&  "3".equals(sysUserAccountVo.getAmountType()) ){
                        insFeeOrderNew.setWillAmount(willPromotion);
                    }
                    resultList.add(insFeeOrderNew);
                }
            }
        }
        sysUserAccountVo.setInsFeeOrderNewList(resultList);
        return sysUserAccountVo;
    }

    private void getWillAmount(InsFeeOrderNew insFeeOrderNew) {
        if(ObjectUtils.isNotEmpty(insFeeOrderNew)){
            //交强手续费出口比例
            BigDecimal jqExportProceduresFee = insFeeOrderNew.getJqPremium().multiply(insFeeOrderNew.getJqSuperviseCostsProportion().divide(new BigDecimal(100))).setScale(2,BigDecimal.ROUND_DOWN);
            //商业手续费出口比例
            BigDecimal syExportProceduresFee = insFeeOrderNew.getSyPremium().multiply(insFeeOrderNew.getSySuperviseCostsProportion().divide(new BigDecimal(100))).setScale(2,BigDecimal.ROUND_DOWN);
            //非车手续费出口比例
            BigDecimal noExportProceduresFee = insFeeOrderNew.getNoPremium().multiply(insFeeOrderNew.getNoSuperviseCostsProportion().divide(new BigDecimal(100))).setScale(2,BigDecimal.ROUND_DOWN);


            //非车出口比例
            //总机构 交强管理比例
            BigDecimal sumJqDeptProportion = insFeeOrderNew.getJqDeptProportionLevel1()
                    .add(insFeeOrderNew.getJqDeptProportionLevel2())
                    .add(insFeeOrderNew.getJqDeptProportionLevel3())
                    .add(insFeeOrderNew.getJqDeptProportionLevel4())
                    .add(insFeeOrderNew.getJqDeptProportionLevel5());

            //总机构 商业管理比例
            BigDecimal sumSyDeptProportion = insFeeOrderNew.getSyDeptProportionLevel1()
                    .add(insFeeOrderNew.getSyDeptProportionLevel2())
                    .add(insFeeOrderNew.getSyDeptProportionLevel3())
                    .add(insFeeOrderNew.getSyDeptProportionLevel4())
                    .add(insFeeOrderNew.getSyDeptProportionLevel5());

            //总机构 非车管理比例
            BigDecimal sumNoDeptProportion = insFeeOrderNew.getNoDeptProportionLevel1()
                    .add(insFeeOrderNew.getNoDeptProportionLevel2())
                    .add(insFeeOrderNew.getNoDeptProportionLevel3())
                    .add(insFeeOrderNew.getNoDeptProportionLevel4())
                    .add(insFeeOrderNew.getNoDeptProportionLevel5());
            BigDecimal noExportProceduresProportion = new BigDecimal(0);
            //总分销比例
            BigDecimal sumRetail = insFeeOrderNew.getFirstDetailProportion().add(insFeeOrderNew.getSecondDetailProportion()).add(insFeeOrderNew.getThirdDetailProportion());
            if(insFeeOrderNew.getNoCostsProportion().compareTo(sumNoDeptProportion.add(sumRetail))>0){
                noExportProceduresProportion = insFeeOrderNew.getNoCostsProportion().subtract(sumNoDeptProportion).subtract(sumRetail);
            }
            //商业出口比例
            BigDecimal syExportProceduresProportion = new BigDecimal(0);
            if(insFeeOrderNew.getSyCostsProportion().compareTo(sumSyDeptProportion.add(sumRetail))>0){
                syExportProceduresProportion = insFeeOrderNew.getSyCostsProportion().subtract(sumSyDeptProportion).subtract(sumRetail);
            }
            //交强出口比例
            BigDecimal jqExportProceduresProportion = new BigDecimal(0);
            if(insFeeOrderNew.getJqCostsProportion().compareTo(sumJqDeptProportion.add(sumRetail))>0){
                jqExportProceduresProportion = insFeeOrderNew.getJqCostsProportion().subtract(sumJqDeptProportion).subtract(sumRetail);
            }
            //交强跟单出口费用
            BigDecimal jqExportOtherFee = insFeeOrderNew.getJqPremium()
                    .multiply(jqExportProceduresProportion
                            .subtract(insFeeOrderNew.getJqSuperviseCostsProportion()).divide(new BigDecimal(100))).setScale(2,BigDecimal.ROUND_DOWN);

            //商业跟单出口比例
            BigDecimal syExportOtherFee = insFeeOrderNew.getSyPremium()
                    .multiply(syExportProceduresProportion
                            .subtract(insFeeOrderNew.getSySuperviseCostsProportion()).divide(new BigDecimal(100))).setScale(2,BigDecimal.ROUND_DOWN);
            //非车跟单出口比例
            BigDecimal noExportOtherFee = insFeeOrderNew.getNoPremium()
                    .multiply(noExportProceduresProportion
                            .subtract(insFeeOrderNew.getNoSuperviseCostsProportion()).divide(new BigDecimal(100))).setScale(2,BigDecimal.ROUND_DOWN);

            if(StringUtils.isNotEmpty(insFeeOrderNew.getAmountType())){
                if("1".equals(insFeeOrderNew.getAmountType())){
                    //用户出口手续费
                    insFeeOrderNew.setWillAmount(jqExportProceduresFee.add(syExportProceduresFee).add(noExportProceduresFee));
                }
                if("2".equals(insFeeOrderNew.getAmountType())){
                    //用户出口跟单费
                    insFeeOrderNew.setWillAmount(jqExportOtherFee.add(syExportOtherFee).add(noExportOtherFee));
                }
            }
        }
    }

    private BigDecimal getWillPromotion(InsFeeOrderNew insFeeOrderNew,BigDecimal  willPromotion) {
        for (int i = 1; i <4 ; i++) {
            InsOrders   InsOrders = insAreaCompanyService.selectByInFeeOrderNew(insFeeOrderNew,i);
            if(ObjectUtils.isNotEmpty(InsOrders)){
                BigDecimal willFirstPremiums = InsOrders.getWillFirstPremiums();
                BigDecimal willSecondPremiums = InsOrders.getWillSecondPremiums();
                BigDecimal willThreePremiums = InsOrders.getWillThreePremiums();
                if(ObjectUtils.isNotEmpty(InsOrders)){
                    if(willFirstPremiums==null){
                        willFirstPremiums=BigDecimal.ZERO;
                    }
                    if(willSecondPremiums==null){
                        willSecondPremiums=BigDecimal.ZERO;
                    }
                    if(willThreePremiums==null){
                        willThreePremiums=BigDecimal.ZERO;
                    }
                    return   willPromotion.add(willFirstPremiums).add(willThreePremiums).add(willSecondPremiums);
                }
            }
        }
        return null;
    }


    private void judgeSysAmountAuditing(List<SysAmountAuditingEntity> sysAmountAuditingApproved, SysUserAccountVo sysUserAccountVo) {
        if(!CollectionUtils.isEmpty(sysAmountAuditingApproved)){
            for (SysAmountAuditingEntity  item:   sysAmountAuditingApproved){
                if("1".equals(item.getAmountStatus())){  //手续费
                    BigDecimal amount = item.getAmount();
                    sysUserAccountVo.setApprovedHalding(amount);
                }
                if("2".equals(item.getAmountStatus())){  //非跟单
                    BigDecimal amount = item.getAmount();
                    sysUserAccountVo.setApprovedDocumentary(amount);
                }
                if("3".equals(item.getAmountStatus())){  //推广费
                    BigDecimal amount = item.getAmount();
                    sysUserAccountVo.setApprovedPromotion(amount);
                }

            }
        }
    }

    private void judge(List<SysAmountAuditingEntity> sysAmountAuditingProgressIng,SysUserAccountVo sysUserAccountVo) {
        if(!CollectionUtils.isEmpty(sysAmountAuditingProgressIng)){
            for (SysAmountAuditingEntity  item:   sysAmountAuditingProgressIng){
                if("1".equals(item.getAmountStatus())){  //手续费
                    BigDecimal amount = item.getAmount();
                    sysUserAccountVo.setWithdrawalHalding(amount);
                }
                if("2".equals(item.getAmountStatus())){  //非跟单
                    BigDecimal amount = item.getAmount();
                    sysUserAccountVo.setWithdrawalDocumentary(amount);
                }
                if("3".equals(item.getAmountStatus())){  //推广费
                    BigDecimal amount = item.getAmount();
                    sysUserAccountVo.setWithdrawalPromotion(amount);
                }

            }
        }

    }

    private BigDecimal willPromotion(BigDecimal willPromotion, String userId) {
        for (int i = 1; i <4 ; i++) {
            InsOrders   InsOrders = insAreaCompanyService.selectPromotionBy(userId,i);
            if(ObjectUtils.isNotEmpty(InsOrders)){
                BigDecimal willFirstPremiums = InsOrders.getWillFirstPremiums();
                BigDecimal willSecondPremiums = InsOrders.getWillSecondPremiums();
                BigDecimal willThreePremiums = InsOrders.getWillThreePremiums();
                if(ObjectUtils.isNotEmpty(InsOrders)){
                    if(willFirstPremiums==null){
                        willFirstPremiums=BigDecimal.ZERO;
                    }
                    if(willSecondPremiums==null){
                        willSecondPremiums=BigDecimal.ZERO;
                    }
                    if(willThreePremiums==null){
                        willThreePremiums=BigDecimal.ZERO;
                    }
                 return   willPromotion.add(willFirstPremiums).add(willThreePremiums).add(willSecondPremiums);
                }
            }
        }
        return null;
    }

    private void willAmount(String quoteno, BigDecimal willHalding, BigDecimal willDocumentary,SysUserAccountVo sysUserAccountVo) {
        InsFeeOrderNew insFeeOrderNew = insFeeOrderNewService.getInsFeeOrderNewByCompanyId(quoteno);
        //交强手续费出口比例
        BigDecimal jqExportProceduresFee = insFeeOrderNew.getJqPremium().multiply(insFeeOrderNew.getJqSuperviseCostsProportion().divide(new BigDecimal(100))).setScale(2,BigDecimal.ROUND_DOWN);
        //商业手续费出口比例
        BigDecimal syExportProceduresFee = insFeeOrderNew.getSyPremium().multiply(insFeeOrderNew.getSySuperviseCostsProportion().divide(new BigDecimal(100))).setScale(2,BigDecimal.ROUND_DOWN);
        //非车手续费出口比例
        BigDecimal noExportProceduresFee = insFeeOrderNew.getNoPremium().multiply(insFeeOrderNew.getNoSuperviseCostsProportion().divide(new BigDecimal(100))).setScale(2,BigDecimal.ROUND_DOWN);
        //用户出口手续费
        willHalding = willHalding.add(jqExportProceduresFee).add(syExportProceduresFee).add(noExportProceduresFee);
        if(sysUserAccountVo.getWillHalding()==null){
            sysUserAccountVo.setWillHalding(willHalding);
        }
        sysUserAccountVo.setWillHalding(sysUserAccountVo.getWillHalding().add(willHalding));

        //非车出口比例
        //总机构 交强管理比例
        BigDecimal sumJqDeptProportion = insFeeOrderNew.getJqDeptProportionLevel1()
                .add(insFeeOrderNew.getJqDeptProportionLevel2())
                .add(insFeeOrderNew.getJqDeptProportionLevel3())
                .add(insFeeOrderNew.getJqDeptProportionLevel4())
                .add(insFeeOrderNew.getJqDeptProportionLevel5());

        //总机构 商业管理比例
        BigDecimal sumSyDeptProportion = insFeeOrderNew.getSyDeptProportionLevel1()
                .add(insFeeOrderNew.getSyDeptProportionLevel2())
                .add(insFeeOrderNew.getSyDeptProportionLevel3())
                .add(insFeeOrderNew.getSyDeptProportionLevel4())
                .add(insFeeOrderNew.getSyDeptProportionLevel5());

        //总机构 非车管理比例
        BigDecimal sumNoDeptProportion = insFeeOrderNew.getNoDeptProportionLevel1()
                .add(insFeeOrderNew.getNoDeptProportionLevel2())
                .add(insFeeOrderNew.getNoDeptProportionLevel3())
                .add(insFeeOrderNew.getNoDeptProportionLevel4())
                .add(insFeeOrderNew.getNoDeptProportionLevel5());
        BigDecimal noExportProceduresProportion = new BigDecimal(0);
        //总分销比例
        BigDecimal sumRetail = insFeeOrderNew.getFirstDetailProportion().add(insFeeOrderNew.getSecondDetailProportion()).add(insFeeOrderNew.getThirdDetailProportion());
        if(insFeeOrderNew.getNoCostsProportion().compareTo(sumNoDeptProportion.add(sumRetail))>0){
            noExportProceduresProportion = insFeeOrderNew.getNoCostsProportion().subtract(sumNoDeptProportion).subtract(sumRetail);
        }
        //商业出口比例
        BigDecimal syExportProceduresProportion = new BigDecimal(0);
        if(insFeeOrderNew.getSyCostsProportion().compareTo(sumSyDeptProportion.add(sumRetail))>0){
            syExportProceduresProportion = insFeeOrderNew.getSyCostsProportion().subtract(sumSyDeptProportion).subtract(sumRetail);
        }
        //交强出口比例
        BigDecimal jqExportProceduresProportion = new BigDecimal(0);
        if(insFeeOrderNew.getJqCostsProportion().compareTo(sumJqDeptProportion.add(sumRetail))>0){
            jqExportProceduresProportion = insFeeOrderNew.getJqCostsProportion().subtract(sumJqDeptProportion).subtract(sumRetail);
        }
        //交强跟单出口费用
        BigDecimal jqExportOtherFee = insFeeOrderNew.getJqPremium()
                .multiply(jqExportProceduresProportion
                        .subtract(insFeeOrderNew.getJqSuperviseCostsProportion()).divide(new BigDecimal(100))).setScale(2,BigDecimal.ROUND_DOWN);

        //商业跟单出口比例
        BigDecimal syExportOtherFee = insFeeOrderNew.getSyPremium()
                .multiply(syExportProceduresProportion
                        .subtract(insFeeOrderNew.getSySuperviseCostsProportion()).divide(new BigDecimal(100))).setScale(2,BigDecimal.ROUND_DOWN);
        //非车跟单出口比例
        BigDecimal noExportOtherFee = insFeeOrderNew.getNoPremium()
                .multiply(noExportProceduresProportion
                        .subtract(insFeeOrderNew.getNoSuperviseCostsProportion()).divide(new BigDecimal(100))).setScale(2,BigDecimal.ROUND_DOWN);
        //用户出口跟单费
        willDocumentary = willDocumentary.add(jqExportOtherFee).add(syExportOtherFee).add(noExportOtherFee);
        if(sysUserAccountVo.getWillDocumentary()==null){
            sysUserAccountVo.setWillDocumentary(willDocumentary);
        }
        sysUserAccountVo.setWillDocumentary(sysUserAccountVo.getWillDocumentary().add(willDocumentary));

    }


}