productDev/yunyibao.git

			@@ -12,10 +12,7 @@
			import com.doumee.core.utils.DateUtil;
			import com.doumee.core.utils.Utils;
			import com.doumee.dao.business.*;
			import com.doumee.dao.business.dto.ApplyChangeCyclePriceDTO;
			import com.doumee.dao.business.dto.ApplyChangeOptDTO;
			import com.doumee.dao.business.dto.CountCyclePriceDTO;
			import com.doumee.dao.business.dto.InsuranceApplyOptDTO;
			import com.doumee.dao.business.dto.*;
			import com.doumee.dao.business.join.*;
			import com.doumee.dao.business.model.*;
			import com.doumee.dao.business.vo.CountCyclePriceVO;
			@@ -25,6 +22,7 @@
			import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
			import com.baomidou.mybatisplus.core.metadata.IPage;
			import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
			import com.doumee.service.business.SmsEmailService;
			import com.doumee.service.business.third.SignService;
			import com.github.xiaoymin.knife4j.core.util.CollectionUtils;
			import com.github.yulichang.wrapper.MPJLambdaWrapper;
			@@ -82,6 +80,9 @@
			private MemberInsuranceJoinMapper memberInsuranceJoinMapper;

			@Autowired
			private ApplyChangeDetailJoinMapper applyChangeDetailJoinMapper;

			@Autowired
			private MemberMapper memberMapper;

			@Autowired
			@@ -101,6 +102,10 @@
			@Autowired
			private SolutionsMapper solutionsMapper;

			@Autowired
			private SmsEmailService smsEmailService;
			@Autowired
			private NoticesMapper noticesMapper;
			/**
			* 平台退回投保
			* @param param
			@@ -117,21 +122,52 @@
			if(model == null \|\|!Constants.equalsInteger(model.getIsdeleted(),Constants.ZERO)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY);
			}
			if(Constants.equalsInteger(model.getStatus(),Constants.ApplyChangeStatus.UPLOAD.getKey())
			\|\|Constants.equalsInteger(model.getStatus(),Constants.ApplyChangeStatus.APPROVE.getKey())){
			//已提交和已完成状态不支持审核不通过
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"对不起，该申请状态已流转，当前不支持该操作~");

			InsuranceApply insuranceApply = insuranceApplyMapper.selectById(model.getApplyId());
			if(Objects.isNull(insuranceApply)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY);
			}
			if(insuranceApply.getIsdeleted().equals(Constants.ONE)){
			throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"数据已删除,无法进行该操作");
			}
			Solutions solutions = solutionsMapper.selectById(insuranceApply.getSolutionId());
			if(Objects.isNull(solutions)){
			throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"未查询到方案信息");
			}

			if(Constants.equalsInteger(solutions.getType(),Constants.ZERO)){
			if(Constants.equalsInteger(model.getStatus(),Constants.ApplyChangeStatus.APPROVE.getKey())){
			//已提交和已完成状态不支持审核不通过
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"对不起，该申请状态已流转，当前不支持该操作~");
			}
			}else if(Constants.equalsInteger(solutions.getType(),Constants.ZERO)){
			if(Constants.equalsInteger(model.getStatus(),Constants.ApplyChangeStatus.UPLOAD.getKey())
			\|\| Constants.equalsInteger(model.getStatus(),Constants.ApplyChangeStatus.SIGNATURE.getKey()) ){
			//已提交和已完成状态不支持审核不通过
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"对不起，该申请状态已流转，当前不支持该操作~");
			}
			}
			LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
			ApplyChange update = new ApplyChange();
			update.setEditDate(new Date());
			update.setEditor(user.getId());
			update.setStatus(Constants.ApplyChangeStatus.PALTFORM_CHECK_PASS_NO.getKey());
			update.setStatus(Constants.ApplyChangeStatus.PLATFORM_AGREE.getKey());
			update.setCheckDate(update.getEditDate());
			update.setCheckInfo(param.getCheckInfo());
			update.setCheckUserId(user.getId());
			update.setId(model.getId());
			applyChangeMapper.updateById(update);

			//存储待办信息
			Constants.NoticeObjectType noticeObjectType = Constants.NoticeObjectType.APPLY_CHANGE;
			if(model.getType().equals(Constants.ONE)){
			noticeObjectType = Constants.NoticeObjectType.CHANGE_FACTORY;
			}
			//删除其他待办
			noticesMapper.delete(new QueryWrapper<Notices>().lambda().eq(Notices::getObjType,noticeObjectType.getKey()).eq(Notices::getObjId,model.getId()));
			Notices notices = new Notices(noticeObjectType,Constants.ONE,model.getId(),solutions.getName(),
			insuranceApply.getCompanyId(), Constants.NoticeType.FOUR);
			noticesMapper.insert(notices);

			Constants.ApplyLogType applyLogType = Constants.ApplyLogType.CA_PLATFORM_CHECK_PASS_NO;
			String info =applyLogType.getInfo();
			@@ -162,6 +198,11 @@
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"对不起，该申请状态已流转，当前不支持该操作~");
			}

			InsuranceApply insuranceApply = insuranceApplyMapper.selectById(model.getApplyId());
			if(Objects.isNull(insuranceApply)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询到保单信息");
			}

			LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
			ApplyChange update = new ApplyChange();
			update.setEditDate(new Date());
			@@ -169,11 +210,12 @@
			update.setStatus(Constants.ApplyChangeStatus.APPROVE.getKey());
			update.setCheckDate(update.getEditDate());
			update.setCheckInfo(param.getCheckInfo());
			update.setApplyId(model.getApplyId());
			update.setCheckUserId(user.getId());
			update.setId(model.getId());
			update.setValidCode(param.getValidCode());
			update.setApplyStartTime(model.getApplyStartTime());
			applyChangeMapper.updateById(update);
			update.setApplyStartTime(param.getApplyStartTime());
			update.setCode(model.getCode());

			param.getPidanFile().setIsdeleted(Constants.ZERO);
			param.getPidanFile().setCreator(user.getId());
			@@ -182,16 +224,22 @@
			param.getPidanFile().setObjType(Constants.MultiFile.CA_PD_PDF.getKey());
			param.getPidanFile().setType(Constants.TWO);
			multifileMapper.insert(param.getPidanFile());

			update.setApplyId(model.getApplyId());


			if(Constants.equalsInteger(model.getType(),Constants.ZERO)){
			//如果是加减保申请处理加减保明细数据
			dealDetailsValidTime(update);
			dealDetailsValidTime(update,insuranceApply);
			}else{
			//如果是换厂申请处理明细数据
			dealDetailsDUdata(update);
			dealDetailsDUdata(update,insuranceApply);
			}

			applyChangeMapper.updateById(update);

			// if(1==1){
			// throw new BusinessException(ResponseStatus.DATA_EMPTY);
			// }

			Constants.ApplyLogType applyLogType = Constants.ApplyLogType.CA_PLATFORM_APPROVE;
			String info = "";
			@@ -237,6 +285,15 @@
			update.setId(model.getId());
			update.setValidCode(param.getValidCode());
			applyChangeMapper.updateById(update);

			//修改员工保单记录
			memberInsuranceJoinMapper.update(null,new UpdateWrapper<MemberInsurance>()
			.lambda()
			.set(MemberInsurance::getPdCode,param.getValidCode())
			.eq(MemberInsurance::getRelationType,Constants.ONE)
			.eq(MemberInsurance::getApplyChangeId,model.getId())
			);

			//删除原有的保单信息
			multifileMapper.delete(new UpdateWrapper<Multifile>().lambda()
			.set(Multifile::getIsdeleted,Constants.ZERO)
			@@ -266,100 +323,174 @@
			* 处理加减保明细数据
			* @param update
			*/
			private void dealDetailsDUdata(ApplyChange update ) {
			private void dealDetailsDUdata(ApplyChange update,InsuranceApply insuranceApply) {
			List<ApplyChagneDetail> detailList = applyChagneDetailJoinMapper.selectJoinList(ApplyChagneDetail.class,
			new MPJLambdaWrapper<ApplyChagneDetail>()
			.selectAll(ApplyChagneDetail.class)
			.selectAs(Solutions::getTimeUnit,ApplyChagneDetail::getSolutionTimeUnit)
			.selectAs(Solutions::getPrice,ApplyChagneDetail::getSolutionPrice)
			.selectAs(Solutions::getId,ApplyChagneDetail::getSolutionId)
			.selectAs(Solutions::getName,ApplyChagneDetail::getSolutionsName)
			.selectAs(Worktype::getName,ApplyChagneDetail::getWorkTypeName)
			.selectAs(DispatchUnit::getName,ApplyChagneDetail::getDuName)
			.leftJoin(ApplyChange.class, ApplyChange::getId, ApplyChagneDetail::getApplyChangeId)
			.leftJoin(InsuranceApply.class, InsuranceApply::getId, ApplyChange::getApplyId)
			.leftJoin(Solutions.class, Solutions::getId, InsuranceApply::getSolutionId)
			.leftJoin(Solutions.class, Solutions::getId, ApplyChange::getSolutionsId)
			.selectAs(Member::getIdcardNo,ApplyChagneDetail::getIdcardNo)
			.selectAs(Member::getName, ApplyChagneDetail::getMemberName)
			.selectAs(InsuranceApply::getCode,ApplyChagneDetail::getApplyCode)
			.leftJoin(Member.class, Member::getId, ApplyChagneDetail::getMemberId)
			.leftJoin(ApplyChange.class, ApplyChange::getId, ApplyChagneDetail::getApplyChangeId)
			.leftJoin(InsuranceApply.class, InsuranceApply::getId, ApplyChange::getApplyId)
			.leftJoin(Solutions.class, Solutions::getId, InsuranceApply::getSolutionId)
			.leftJoin(Worktype.class,Worktype::getId,ApplyChagneDetail::getWorktypeId)
			.leftJoin(DispatchUnit.class,DispatchUnit::getId,ApplyChagneDetail::getDuId)
			.eq(ApplyChagneDetail::getApplyChangeId,update.getId())
			.eq(ApplyChagneDetail::getIsdeleted,Constants.ZERO) );

			if(detailList ==null \|\| detailList.size()==0){
			return;
			}
			//实际批单生效日期
			Date applyStartTime = DateUtil.getMontageDate(update.getApplyStartTime(),1);
			for(ApplyChagneDetail detail : detailList){
			//查询减保人员是否存在冲突的保单明细数据
			if(applyDetailJoinMapper.selectCount(new QueryWrapper<ApplyDetail>()
			.lambda()
			.eq(ApplyDetail::getApplyId,update.getApplyId())
			.eq(ApplyDetail::getIdcardNo,detail.getIdcardNo())
			.le(ApplyDetail::getStartTime,applyStartTime)
			.ge(ApplyDetail::getEndTime,applyStartTime)
			)<=Constants.ZERO){
			throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "当前保单下，换厂人员【" + detail.getMemberName() + "】未查询到符合批单日期的数据");
			}

			//查询员工是在主单下是否存在生效中的数据
			ApplyDetail oldModel = applyDetailJoinMapper.selectOne(new QueryWrapper<ApplyDetail>().lambda()
			.eq(ApplyDetail::getApplyId, update.getApplyId())
			.eq(ApplyDetail::getMemberId, detail.getMemberId())
			.le(ApplyDetail::getStartTime,applyStartTime)
			.ge(ApplyDetail::getEndTime,applyStartTime)
			.orderByDesc(ApplyDetail::getCreateDate)
			.last("limit 1"));
			if(oldModel == null ){
			throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"对不起，用户【"+detail.getMemberName()+"】原保单信息有误，当前申请不支持减保处理！");
			throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"对不起，用户【"+detail.getMemberName()+"】原保单信息有误，批单日期未在保单日期内！");
			}
			Date endDate = oldModel.getEndTime();
			//当前日期大于批单日期需要回滚数据实际数据
			Boolean flag = DateUtil.getMontageDate(new Date(),2).compareTo(DateUtil.getMontageDate(update.getStartTime(),2))>0;
			//换厂后历史记录的费用 fee
			Integer days = DateUtil.daysBetweenDates(DateUtil.getMontageDate(update.getStartTime(),2),DateUtil.getMontageDate(oldModel.getStartTime(),1)) + 1;
			BigDecimal oldFee = this.getApplyPrice(update.getApplyId(),days);
			BigDecimal fee = oldModel.getFee();
			BigDecimal oldCurrentFee = oldModel.getCurrentFee();
			applyDetailJoinMapper.update(null, new UpdateWrapper<ApplyDetail>().lambda()
			.set(ApplyDetail::getEditor,update.getEditor())
			.set(ApplyDetail::getEditDate,update.getEditDate())
			.set(ApplyDetail::getEndTime,DateUtil.getMontageDate(update.getStartTime(),2))
			.set(ApplyDetail::getFee,oldFee)
			.set(flag,ApplyDetail::getCurrentFee,oldFee)
			.eq(ApplyDetail::getId,oldModel.getApplyId())
			);

			//修改员工投保明细记录历史数据
			memberInsuranceJoinMapper.update(null,new UpdateWrapper<MemberInsurance>().lambda()
			.set(MemberInsurance::getEndTime,update.getApplyStartTime())
			.set(MemberInsurance::getFee,oldFee)
			.eq(MemberInsurance::getRelationId,oldModel.getId())
			);
			//如果实际批单日期和原记录日期相等则直接修改记录派遣单位与工种信息
			if(applyStartTime.compareTo(oldModel.getStartTime())!=Constants.ZERO){
			//当前日期大于批单日期需要回滚数据实际数据
			Boolean flag = DateUtil.getMontageDate(new Date(),2).compareTo(DateUtil.getMontageDate(update.getApplyStartTime(),2))>0;
			//换厂后历史记录的费用 fee
			Integer days = DateUtil.daysBetweenDates(DateUtil.getMontageDate(update.getApplyStartTime(),3),DateUtil.getMontageDate(oldModel.getStartTime(),1))+1;
			BigDecimal oldFee = this.getApplyPrice(update.getApplyId(),days);
			BigDecimal fee = oldModel.getFee();
			BigDecimal oldCurrentFee = oldModel.getCurrentFee();

			ApplyDetail applyDetail = new ApplyDetail();
			applyDetail.setApplyId(oldModel.getApplyId());
			applyDetail.setCreateDate(new Date());
			applyDetail.setCreator(update.getEditor());
			applyDetail.setMemberId(oldModel.getMemberId());
			applyDetail.setStartTime(DateUtil.getMontageDate(update.getApplyStartTime(),1));
			applyDetail.setEndTime(endDate);
			applyDetail.setDuId(detail.getDuId());
			applyDetail.setWorktypeId(detail.getWorktypeId());
			applyDetail.setIdcardNo(oldModel.getIdcardNo());
			applyDetail.setFee(fee.subtract(oldFee));
			if(flag){
			applyDetail.setCurrentFee(oldCurrentFee.multiply(oldFee));
			applyDetailJoinMapper.update(null, new UpdateWrapper<ApplyDetail>().lambda()
			.set(ApplyDetail::getEditor,update.getEditor())
			.set(ApplyDetail::getEditDate,update.getEditDate())
			.set(ApplyDetail::getEndTime,DateUtil.getMontageDate(update.getApplyStartTime(),3))
			.set(ApplyDetail::getFee,oldFee)
			.set(flag,ApplyDetail::getCurrentFee,oldFee)
			.eq(ApplyDetail::getId,oldModel.getId())
			);

			//修改员工投保明细记录历史数据
			memberInsuranceJoinMapper.update(null,new UpdateWrapper<MemberInsurance>().lambda()
			.set(MemberInsurance::getEndTime,update.getApplyStartTime())
			.set(MemberInsurance::getFee,oldFee)
			.eq(MemberInsurance::getRelationId,oldModel.getId())
			);

			ApplyDetail applyDetail = new ApplyDetail();
			applyDetail.setApplyId(oldModel.getApplyId());
			applyDetail.setCreateDate(new Date());
			applyDetail.setCreator(update.getEditor());
			applyDetail.setMemberId(oldModel.getMemberId());
			applyDetail.setIdcardNo(detail.getIdcardNo());
			applyDetail.setSex(Constants.getSexByIdCard(detail.getIdcardNo()));
			applyDetail.setMemberName(detail.getMemberName());
			applyDetail.setStartTime(DateUtil.getMontageDate(update.getApplyStartTime(),1));
			applyDetail.setEndTime(endDate);
			applyDetail.setDuId(detail.getDuId());
			applyDetail.setWorktypeId(detail.getWorktypeId());
			applyDetail.setIdcardNo(oldModel.getIdcardNo());
			applyDetail.setFee(fee.subtract(oldFee));
			applyDetail.setIsdeleted(Constants.ZERO);
			if(flag){
			applyDetail.setCurrentFee(oldCurrentFee.multiply(oldFee));
			}else{
			applyDetail.setCurrentFee(BigDecimal.ZERO);
			}
			applyDetail.setSex(oldModel.getSex());
			applyDetail.setMemberName(oldModel.getMemberName());
			applyDetail.setFromId(detail.getId());
			applyDetailJoinMapper.insert(applyDetail);

			MemberInsurance memberInsurance = new MemberInsurance(applyDetail,update.getId());
			memberInsurance.setSolutionId(detail.getSolutionId());
			memberInsurance.setWorktypeName(detail.getWorkTypeName());
			memberInsurance.setDuName(detail.getDuName());
			memberInsurance.setApplyChangeId(detail.getApplyChangeId());
			memberInsurance.setSolutionName(detail.getSolutionsName());
			memberInsurance.setPdCode(update.getValidCode());
			memberInsurance.setBdCode(insuranceApply.getCode());
			memberInsurance.setRelationType(Constants.ONE);
			memberInsuranceJoinMapper.insert(memberInsurance);
			}else{
			applyDetail.setCurrentFee(BigDecimal.ZERO);
			applyDetailJoinMapper.update(null, new UpdateWrapper<ApplyDetail>().lambda()
			.set(ApplyDetail::getEditor,update.getEditor())
			.set(ApplyDetail::getEditDate,update.getEditDate())
			.set(ApplyDetail::getDuId,detail.getDuId())
			.set(ApplyDetail::getWorktypeId,detail.getWorktypeId())
			.eq(ApplyDetail::getId,oldModel.getId())
			);
			//员工投保明细记录历史数据
			memberInsuranceJoinMapper.update(null,new UpdateWrapper<MemberInsurance>().lambda()
			.set(MemberInsurance::getDuId,detail.getDuId())
			.set(MemberInsurance::getDuName,detail.getDuName())
			.set(MemberInsurance::getWorktypeId,detail.getWorktypeId())
			.set(MemberInsurance::getWorktypeName,detail.getWorkTypeName())
			.eq(MemberInsurance::getRelationId,oldModel.getId())
			);
			}
			applyDetail.setSex(oldModel.getSex());
			applyDetail.setMemberName(oldModel.getMemberName());
			applyDetail.setFromId(detail.getId());
			applyDetailJoinMapper.insert(applyDetail);

			MemberInsurance memberInsurance = new MemberInsurance(applyDetail,update.getId());
			memberInsuranceJoinMapper.insert(memberInsurance);
			Member member = memberMapper.selectById(detail.getMemberId());
			if(Objects.isNull(member)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询到员工数据");
			}
			member.setApplyId(update.getApplyId());
			member.setDuId(detail.getDuId());
			member.setWorktypeId(detail.getWorktypeId());
			member.setStartTime(detail.getStartTime());
			member.setEndTime(detail.getEndTime());
			memberMapper.updateById(member);

			applyChangeDetailJoinMapper.update(null,new UpdateWrapper<ApplyChagneDetail>().lambda()
			.set(ApplyChagneDetail::getStartTime,DateUtil.getMontageDate(update.getApplyStartTime(), 1))
			.eq(ApplyChagneDetail::getId,detail.getId())
			);
			}
			}
			/**
			* 处理加减保明细数据
			* @param update
			*/
			private void dealDetailsValidTime(ApplyChange update) {
			private void dealDetailsValidTime(ApplyChange update,InsuranceApply insuranceApply) {
			List<ApplyChagneDetail> detailList = applyChagneDetailJoinMapper.selectJoinList(ApplyChagneDetail.class,
			new MPJLambdaWrapper<ApplyChagneDetail>()
			.selectAll(ApplyChagneDetail.class)
			.selectAs(Member::getIdcardNo,ApplyChagneDetail::getIdcardNo)
			.selectAs(Solutions::getTimeUnit, ApplyChagneDetail::getSolutionTimeUnit)
			.selectAs(Solutions::getPrice, ApplyChagneDetail::getSolutionPrice)
			.selectAs(Worktype::getName, ApplyChagneDetail::getWorkTypeName)
			.selectAs(DispatchUnit::getName, ApplyChagneDetail::getDuName)
			.selectAs(Member::getName, ApplyChagneDetail::getMemberName)
			.selectAs(Solutions::getName,ApplyChagneDetail::getSolutionsName)
			.selectAs(InsuranceApply::getCode,ApplyChagneDetail::getApplyCode)
			.leftJoin(ApplyChange.class, ApplyChange::getId, ApplyChagneDetail::getApplyChangeId)
			.leftJoin(Member.class, Member::getId, ApplyChagneDetail::getMemberId)
			.leftJoin(InsuranceApply.class, InsuranceApply::getId, ApplyChange::getApplyId)
			.leftJoin(Solutions.class, Solutions::getId, InsuranceApply::getSolutionId)
			.leftJoin(Solutions.class, Solutions::getId, ApplyChange::getSolutionsId)
			.leftJoin(Worktype.class, Worktype::getId, ApplyChagneDetail::getWorktypeId)
			.leftJoin(DispatchUnit.class, DispatchUnit::getId, ApplyChagneDetail::getDuId)
			.eq(ApplyChagneDetail::getApplyChangeId, update.getId())
			@@ -374,25 +505,44 @@
			//投保记录加保数据加入新数据减保数据修改老数据
			List<MemberInsurance> memberInsuranceList = new ArrayList<>();


			//加保业务使用的加保金额
			ApplyChangeCyclePriceDTO applyChangeCyclePriceDTO_add = new ApplyChangeCyclePriceDTO();
			applyChangeCyclePriceDTO_add.setApplyId(update.getApplyId());
			applyChangeCyclePriceDTO_add.setValidTime(DateUtil.getMontageDate(update.getStartTime(), 1));
			applyChangeCyclePriceDTO_add.setValidTime(DateUtil.getMontageDate(update.getApplyStartTime(), 1));
			//加保添加的金额
			CountCyclePriceVO countCyclePriceVO_add = this.getChangeCountCyclePriceVO(applyChangeCyclePriceDTO_add);


			//减保业务使用的减保金额
			ApplyChangeCyclePriceDTO applyChangeCyclePriceDTO_reduce = new ApplyChangeCyclePriceDTO();
			applyChangeCyclePriceDTO_reduce.setApplyId(update.getApplyId());
			applyChangeCyclePriceDTO_reduce.setValidTime(DateUtil.getMontageDate(update.getStartTime(), 3));
			//减保需要减少的金额
			CountCyclePriceVO countCyclePriceVO_reduce = this.getChangeCountCyclePriceVO(applyChangeCyclePriceDTO_reduce);
			Solutions solutions = solutionsMapper.selectById(insuranceApply.getSolutionId());
			if(Objects.isNull(solutions)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询到保险方案");
			}
			if(solutions.getDataType().equals(Constants.ONE)){
			solutions = solutionsMapper.selectOne(new QueryWrapper<Solutions>().lambda().eq(Solutions::getBaseId,solutions.getBaseId()).eq(Solutions::getDataType,Constants.TWO).last("limit 1"));
			if(Objects.isNull(solutions)){
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"未查询到方案最新版本信息");
			}
			}


			for (ApplyChagneDetail detail : detailList) {
			Member member = memberMapper.selectById(detail.getMemberId());
			if(Objects.isNull(member)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询到员工数据");
			}
			if (Constants.equalsInteger(detail.getType(), Constants.ZERO)) {

			//查询加保人员是否存在冲突的保单明细数据
			if(applyDetailJoinMapper.selectCount(new QueryWrapper<ApplyDetail>()
			.lambda()
			.eq(ApplyDetail::getApplyId,update.getApplyId())
			.eq(ApplyDetail::getIdcardNo,detail.getIdcardNo())
			.le(ApplyDetail::getStartTime,DateUtil.getMontageDate(update.getApplyStartTime(),1))
			.ge(ApplyDetail::getEndTime,DateUtil.getMontageDate(detail.getEndTime(),2))
			)>Constants.ZERO){
			throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "当前保单下，加保人员【" + detail.getMemberName() + "】存在日期冲突的数据");
			}


			//加保
			ApplyDetail add = new ApplyDetail();
			add.setApplyId(update.getApplyId());
			@@ -404,29 +554,41 @@
			add.setMemberId(detail.getMemberId());
			add.setMemberName(detail.getMemberName());
			add.setWorktypeId(detail.getWorktypeId());
			add.setIsdeleted(Constants.ZERO);
			add.setIdcardNo(detail.getIdcardNo());
			add.setSex(Constants.getSexByIdCard(detail.getIdcardNo()));
			add.setMemberName(detail.getMemberName());
			add.setDuId(detail.getDuId());
			add.setStartTime(update.getApplyStartTime());
			add.setEndTime(detail.getEndTime());
			add.setFee(new BigDecimal(0));
			// add.setFee(Constants.countDetailFee(detail.getSolutionTimeUnit(),detail.getSolutionPrice(), add.getStartTime(),add.getEndTime()));
			if (DateUtil.daysBetweenDates(add.getStartTime(), new Date()) >= 0) {
			add.setStartTime(DateUtil.getMontageDate(update.getApplyStartTime(), 1));
			add.setEndTime(DateUtil.getMontageDate(detail.getEndTime(), 2));
			add.setStartTime(DateUtil.getMontageDate(update.getApplyStartTime(), 1));
			add.setEndTime(DateUtil.getMontageDate(detail.getEndTime(), 2));
			add.setFee(countCyclePriceVO_add.getCyclePrice());

			add.setFee(countCyclePriceVO_add.getCyclePrice());
			if (DateUtil.daysBetweenDates(DateUtil.getMontageDate(add.getStartTime(), 2), new Date()) >= 0) {
			Integer days = DateUtil.daysBetweenDates(new Date(), DateUtil.getMontageDate(add.getStartTime(), 2)) + 1;
			//如果已产生费用，计算已产生费用
			add.setCurrentFee(this.getApplyPrice(update.getApplyId(), days));
			}
			// addList.add(add);
			applyDetailJoinMapper.insert(add);
			totalFee.add(add.getFee());
			currentFee.add(add.getCurrentFee());

			MemberInsurance memberInsurance = new MemberInsurance(detail, update, update.getEditor(), add.getId());
			memberInsuranceList.add(memberInsurance);
			} else {
			if(new Date().compareTo(DateUtil.getMontageDate(detail.getStartTime(), 2))>=0){
			Integer days = DateUtil.daysBetweenDates(DateUtil.getMontageDate(new Date(), 2), detail.getStartTime()) + 1;
			//如果已已产生费用，计算已已产生费用
			add.setCurrentFee(this.getApplyPrice(update.getApplyId(), days));
			}else{
			add.setCurrentFee(BigDecimal.ZERO);
			}
			applyDetailJoinMapper.insert(add);
			totalFee = totalFee.add(add.getFee());
			currentFee = currentFee.add(add.getCurrentFee());

			MemberInsurance memberInsurance = new MemberInsurance(detail, update, update.getEditor(), add.getId(),solutions.getId());
			memberInsurance.setStartTime(add.getStartTime());
			memberInsurance.setEndTime(add.getEndTime());
			memberInsurance.setRelationType(Constants.ONE);
			memberInsuranceList.add(memberInsurance);

			applyChangeDetailJoinMapper.update(null,new UpdateWrapper<ApplyChagneDetail>().lambda()
			.set(ApplyChagneDetail::getFee,add.getFee())
			.set(ApplyChagneDetail::getStartTime,DateUtil.getMontageDate(update.getApplyStartTime(), 1))
			.eq(ApplyChagneDetail::getId,detail.getId())
			);

			} else {
			//减保操作
			//查询员工是在主单下是否存在生效中的数据
			ApplyDetail oldModel = applyDetailJoinMapper.selectOne(new QueryWrapper<ApplyDetail>().lambda()
			@@ -437,59 +599,75 @@
			if (oldModel == null \|\| oldModel.getStartTime() == null \|\| oldModel.getStartTime().getTime() > update.getApplyStartTime().getTime()) {
			throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(), "对不起，用户【" + detail.getMemberName() + "】原保单信息有误，当前申请不支持减保处理！");
			}
			//退保需要退回的费用
			//减保业务使用的减保金额
			ApplyChangeCyclePriceDTO applyChangeCyclePriceDTO_reduce = new ApplyChangeCyclePriceDTO();
			applyChangeCyclePriceDTO_reduce.setApplyId(update.getApplyId());
			applyChangeCyclePriceDTO_reduce.setValidTime(DateUtil.getMontageDate(update.getApplyStartTime(), 2));
			//减保需要减少的金额即退保需要退回的费用
			CountCyclePriceVO countCyclePriceVO_reduce = this.getChangeCountCyclePriceVO(applyChangeCyclePriceDTO_reduce);
			BigDecimal updateFee = countCyclePriceVO_reduce.getCyclePrice().multiply(new BigDecimal(-1));
			BigDecimal updateCurrentFee = oldModel.getFee().subtract(updateFee);

			// BigDecimal updateCurrentFee = new BigDecimal(0);
			// if(DateUtil.daysBetweenDates(update.getApplyStartTime(),new Date() )>0){
			// //如果生效时间是今天之前，退回已产生费用，计算已产生费用(总费用-已产生费用)
			// updateCurrentFee = updateFee.subtract(oldModel.getCurrentFee());
			// }

			// BigDecimal updateFee = (Constants.countDetailFee(detail.getSolutionTimeUnit(), detail.getSolutionPrice(), oldModel.getStartTime(), update.getApplyStartTime()));
			// BigDecimal updateCurrentFee = new BigDecimal(0);
			if (DateUtil.daysBetweenDates(update.getApplyStartTime(), new Date()) > 0) {
			//如果生效时间是今天之前，退回已产生费用，计算已产生费用(总费用-已产生费用)
			updateCurrentFee = updateFee.subtract(Constants.formatBigdecimal(oldModel.getCurrentFee()));
			//当审批时间大于申请的时间时计算实际减少金额因为已扣金额会大于应扣金额
			BigDecimal updateCurrentFee = BigDecimal.ZERO;
			if (DateUtil.daysBetweenDates(DateUtil.getMontageDate(new Date(), 2),update.getApplyStartTime()) > 0) {
			applyChangeCyclePriceDTO_reduce.setValidTime(DateUtil.getMontageDate(new Date(), 2));
			//获取大于审批日期导致多减的金额
			CountCyclePriceVO timeoutCountCyclePriceVOReduce = this.getChangeCountCyclePriceVO(applyChangeCyclePriceDTO_reduce);
			updateCurrentFee = timeoutCountCyclePriceVOReduce.getCyclePrice().subtract(countCyclePriceVO_reduce.getCyclePrice());
			}


			applyDetailJoinMapper.update(null, new UpdateWrapper<ApplyDetail>().lambda()
			.setSql(" fee = ifnull(fee,0)+" + updateFee)
			.setSql(" current_fee = " + updateCurrentFee)
			.set(ApplyDetail::getEndTime, update.getApplyStartTime())
			.set(insuranceApply.getStartTime().compareTo(update.getApplyStartTime())!=0,ApplyDetail::getEndTime, DateUtil.getMontageDate(update.getApplyStartTime(), 3))
			.set(insuranceApply.getStartTime().compareTo(update.getApplyStartTime())==0,ApplyDetail::getEndTime, DateUtil.getMontageDate(update.getApplyStartTime(), 2))
			.set(ApplyDetail::getEditor, update.getEditor())
			.set(ApplyDetail::getEditDate, update.getEditDate())
			.eq(ApplyDetail::getId, oldModel.getApplyId())
			.eq(ApplyDetail::getId, oldModel.getId())
			);
			totalFee.add(updateFee);
			currentFee.add(updateCurrentFee);
			totalFee = totalFee.add(updateFee);
			currentFee = currentFee.add(updateCurrentFee);

			//修改员工投保明细记录历史数据
			memberInsuranceJoinMapper.update(null, new UpdateWrapper<MemberInsurance>().lambda()
			.setSql(" fee = ifnull(fee,0)+" + updateFee)
			.set(MemberInsurance::getEndTime, update.getApplyStartTime())
			.set(insuranceApply.getStartTime().compareTo(update.getApplyStartTime())!=0,MemberInsurance::getEndTime,DateUtil.getMontageDate(update.getApplyStartTime(), 3))
			.set(insuranceApply.getStartTime().compareTo(update.getApplyStartTime())==0,MemberInsurance::getEndTime,DateUtil.getMontageDate(update.getApplyStartTime(), 2))
			.set(MemberInsurance::getStartTime, update.getApplyStartTime())
			.eq(MemberInsurance::getRelationId, oldModel.getId())
			);

			}
			//修改业务明细行数据实际批单日期
			applyChangeDetailJoinMapper.update(null,new UpdateWrapper<ApplyChagneDetail>().lambda()
			.set(ApplyChagneDetail::getFee,updateFee)
			.set(ApplyChagneDetail::getEndTime,DateUtil.getMontageDate(update.getApplyStartTime(), 3))
			.eq(ApplyChagneDetail::getId,detail.getId())
			);

			}

			member.setApplyId(update.getApplyId());
			member.setDuId(detail.getDuId());
			member.setWorktypeId(detail.getWorktypeId());
			member.setStartTime(detail.getStartTime());
			member.setEndTime(detail.getEndTime());
			memberMapper.updateById(member);

			if (memberInsuranceList != null && memberInsuranceList.size() > 0) {
			// applyDetailJoinMapper.insertBatchSomeColumn(addList);
			memberInsuranceJoinMapper.insertBatchSomeColumn(memberInsuranceList);
			}
			if (totalFee.compareTo(new BigDecimal(0)) != 0) {
			//如果保单金额发生编码，更新总保单金额
			insuranceApplyMapper.update(null, new UpdateWrapper<InsuranceApply>().lambda()
			.setSql(" fee = ifnull(fee,0)+" + totalFee)
			.setSql(" current_fee = ifnull(current_fee,0)+" + currentFee)
			.set(InsuranceApply::getEditor, update.getEditor())
			.set(InsuranceApply::getEditDate, update.getEditDate())
			.eq(InsuranceApply::getId, update.getApplyId())
			);
			}
			if (totalFee.compareTo(new BigDecimal(0)) != 0) {
			//如果保单金额发生编码，更新总保单金额
			insuranceApplyMapper.update(null, new UpdateWrapper<InsuranceApply>().lambda()
			.setSql(" fee = ifnull(fee,0)+" + totalFee)
			.setSql(" current_fee = ifnull(current_fee,0)+" + currentFee)
			.set(InsuranceApply::getEditor, update.getEditor())
			.set(InsuranceApply::getEditDate, update.getEditDate())
			.eq(InsuranceApply::getId, update.getApplyId())
			);

			}

			update.setFee(totalFee);
			}
			}

			@@ -510,32 +688,50 @@
			throw new BusinessException(ResponseStatus.DATA_EMPTY);
			}

			InsuranceApply insuranceApply = insuranceApplyMapper.selectById(model.getApplyId());
			if(Objects.isNull(insuranceApply)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY);
			}
			if(insuranceApply.getIsdeleted().equals(Constants.ONE)){
			throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"数据已删除,无法进行该操作");
			}
			Solutions solutions = solutionsMapper.selectById(insuranceApply.getSolutionId());
			if(Objects.isNull(solutions)){
			throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"未查询到方案信息");
			}

			LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
			Constants.ApplyLogType applyLogType = null;
			String info = "";
			ApplyChange update = new ApplyChange();
			Constants.NoticeType noticeType = Constants.NoticeType.FOUR;
			if(param.getDealBackApply() ==1){
			//如果是驳回,只能可驳回已签章状态下的退回申请状态进行操作
			if(!Constants.equalsInteger(model.getStatus(),Constants.ApplyChangeStatus.RETURN_APPLY_SIGNATURE.getKey())){
			if(!(Constants.equalsInteger(model.getStatus(),Constants.ApplyChangeStatus.RETURN_APPLY_SIGNATURE.getKey())
			\|\|Constants.equalsInteger(model.getStatus(),Constants.ApplyChangeStatus.RETURN_APPLY_UPLOAD.getKey()))
			){
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"对不起，该申请状态已流转，当前不支持该操作~");
			}
			if(Constants.equalsInteger(model.getStatus(),Constants.ApplyChangeStatus.RETURN_APPLY_SIGNATURE.getKey())){
			update.setStatus(Constants.ApplyChangeStatus.SIGNATURE.getKey());
			}else {
			update.setStatus(Constants.ApplyChangeStatus.UPLOAD.getKey());
			}
			applyLogType = Constants.ApplyLogType.CA_PALTFORM_REFUSE_APPLY;
			info = applyLogType.getInfo();
			info = info.replace("${param}", param.getCheckInfo());
			update.setStatus(Constants.ApplyChangeStatus.SIGNATURE.getKey());

			noticeType = Constants.NoticeType.FIVE;
			}else{
			//如果是同意,两种申请退回状态都可操作
			if(!(Constants.equalsInteger(model.getStatus(),Constants.ApplyChangeStatus.RETURN_APPLY_SIGNATURE.getKey())
			\|\|Constants.equalsInteger(model.getStatus(),Constants.ApplyChangeStatus.RETURN_APPLY_UPLOAD.getKey()))){
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"对不起，该申请状态已流转，当前不支持该操作~");
			}
			applyLogType = Constants.ApplyLogType.CA_PALTFORM_REFUSE_APPLY;
			if( Constants.equalsInteger(model.getStatus(),Constants.ApplyChangeStatus.RETURN_APPLY_SIGNATURE.getKey())){
			update.setStatus(Constants.ApplyChangeStatus.SIGNATURE.getKey());
			}else if( Constants.equalsInteger(model.getStatus(),Constants.ApplyChangeStatus.RETURN_APPLY_UPLOAD.getKey())){
			update.setStatus(Constants.ApplyChangeStatus.UPLOAD.getKey());
			}
			update.setStatus(Constants.ApplyChangeStatus.PLATFORM_AGREE.getKey());
			applyLogType = Constants.ApplyLogType.CA_PLATFORM_AGREE_BACK_APPLY;
			}

			update.setEditDate(new Date());
			update.setEditor(user.getId());
			//同意退回，直接回到最初状态，如果驳回退回申请，则保单状态回到待上传保险单
			@@ -544,6 +740,18 @@
			update.setCheckUserId(user.getId());
			update.setId(model.getId());
			applyChangeMapper.updateById(update);


			//存储待办信息
			Constants.NoticeObjectType noticeObjectType = Constants.NoticeObjectType.APPLY_CHANGE;
			if(model.getType().equals(Constants.ONE)){
			noticeObjectType = Constants.NoticeObjectType.CHANGE_FACTORY;
			}
			//删除其他待办
			noticesMapper.delete(new QueryWrapper<Notices>().lambda().eq(Notices::getObjType,noticeObjectType.getKey()).eq(Notices::getObjId,model.getId()));
			Notices notices = new Notices(noticeObjectType,Constants.ONE,model.getId(),solutions.getName(),
			insuranceApply.getCompanyId(), noticeType);
			noticesMapper.insert(notices);

			ApplyLog log = new ApplyLog(update,applyLogType.getName(),info,update.getId(),applyLogType.getKey(),JSONObject.toJSONString(model), JSONObject.toJSONString(update));
			applyLogMapper.insert(log);
			@@ -567,13 +775,15 @@
			if (!loginUserInfo.getType().equals(Constants.ONE)) {
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "用户类型错误：非企业用户无法进行该操作");
			}
			BigDecimal fee = BigDecimal.ZERO;

			InsuranceApply insuranceApply = insuranceApplyMapper.selectById(applyChange.getApplyId());
			if (Objects.isNull(insuranceApply)) {
			throw new BusinessException(ResponseStatus.DATA_EMPTY);
			}
			if (!Constants.equalsInteger(insuranceApply.getStatus(),Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey())) {
			if (!(Constants.equalsInteger(insuranceApply.getStatus(), Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey())
			\|\|Constants.equalsInteger(insuranceApply.getStatus(), Constants.InsuranceApplyStatus.WTB_DONE.getKey())
			)
			) {
			throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(), "保单状态错误");
			}
			if (DateUtil.compareDate(insuranceApply.getEndTime(),new Date()) >= Constants.ZERO
			@@ -584,9 +794,17 @@
			if(Objects.isNull(solutions)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询到保险方案");
			}
			if(solutions.getDataType().equals(Constants.ONE)){
			solutions = solutionsMapper.selectOne(new QueryWrapper<Solutions>().lambda().eq(Solutions::getBaseId,solutions.getBaseId()).eq(Solutions::getDataType,Constants.TWO).last("limit 1"));
			if(Objects.isNull(solutions)){
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"未查询到方案最新版本信息");
			}
			}


			CompanySolution companySolution = companySolutionMapper.selectOne(new QueryWrapper<CompanySolution>().lambda()
			.eq(CompanySolution::getCompanyId,loginUserInfo.getCompanyId())
			.eq(CompanySolution::getSolutionBaseId,solutions.getId())
			.eq(CompanySolution::getSolutionBaseId,solutions.getBaseId())
			.eq(CompanySolution::getIsdeleted,Constants.ZERO)
			.last(" limit 1 ")
			);
			@@ -598,21 +816,37 @@
			&& DateUtil.compareDate( applyChange.getValidTime(),insuranceApply.getEndTime()) >= Constants.ZERO)) {
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "申请日期未处于保单日期内，无法进行该操作");
			}
			//查询保单下是否存在进行中的加减保/换厂单据
			if(applyChangeMapper.selectCount(new QueryWrapper<ApplyChange>().lambda()
			.eq(ApplyChange::getApplyId,insuranceApply.getId())
			.notIn(ApplyChange::getStatus,Constants.ApplyChangeStatus.APPROVE.getKey(),Constants.ApplyChangeStatus.CLOSE.getKey())

			)>Constants.ZERO){
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "存在进行中的加减保/换厂申请");
			};


			applyChange.setCreateDate(new Date());
			applyChange.setCreator(loginUserInfo.getId());
			applyChange.setEditor(loginUserInfo.getId());
			applyChange.setEditDate(new Date());
			applyChange.setIsdeleted(Constants.ZERO);
			applyChange.setApplyStartTime(applyChange.getValidTime());
			applyChange.setStatus(Constants.ZERO);
			applyChangeMapper.insert(applyChange);

			this.dealApplyChangeData(applyChange,insuranceApply,companySolution,solutions,loginUserInfo,fee);
			BigDecimal fee = this.dealApplyChangeData(applyChange,insuranceApply,companySolution,solutions,loginUserInfo,BigDecimal.ZERO);

			ApplyChange applyChangeFee = new ApplyChange();
			applyChangeFee.setId(applyChange.getId());
			applyChangeFee.setFee(fee);
			applyChangeMapper.updateById(applyChangeFee);

			this.saveApplyLog(applyChange,Constants.ApplyChangeLogStatus.UPLOAD,null);
			Constants.ApplyLogType applyLogType = Constants.ApplyLogType.CA_COMPANY_COMMIT;
			ApplyLog log = new ApplyLog(applyChange,applyLogType.getName(),"",applyChange.getId(),applyLogType.getKey(), null, null);
			applyLogMapper.insert(log);


			return applyChange.getId();
			}

			@@ -639,7 +873,9 @@
			if(Objects.isNull(dbApplyChange)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY);
			}
			if(!dbApplyChange.getStatus().equals(Constants.ApplyChangeStatus.PLATFORM_AGREE.getKey())){
			if(! (dbApplyChange.getStatus().equals(Constants.ApplyChangeStatus.PLATFORM_AGREE.getKey())
			\|\| dbApplyChange.getStatus().equals(Constants.ApplyChangeStatus.PALTFORM_CHECK_PASS_NO.getKey()) )
			){
			throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(), "业务保申请单状态错误");
			}

			@@ -658,9 +894,15 @@
			if(Objects.isNull(solutions)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询到保险方案");
			}
			if(solutions.getDataType().equals(Constants.ONE)){
			solutions = solutionsMapper.selectOne(new QueryWrapper<Solutions>().lambda().eq(Solutions::getBaseId,solutions.getBaseId()).eq(Solutions::getDataType,Constants.TWO).last("limit 1"));
			if(Objects.isNull(solutions)){
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"未查询到方案最新版本信息");
			}
			}
			CompanySolution companySolution = companySolutionMapper.selectOne(new QueryWrapper<CompanySolution>().lambda()
			.eq(CompanySolution::getCompanyId,loginUserInfo.getCompanyId())
			.eq(CompanySolution::getSolutionBaseId,solutions.getId())
			.eq(CompanySolution::getSolutionBaseId,solutions.getBaseId())
			.eq(CompanySolution::getIsdeleted,Constants.ZERO)
			.last(" limit 1 ")
			);
			@@ -672,23 +914,37 @@
			&& DateUtil.compareDate( applyChange.getValidTime(),insuranceApply.getEndTime()) >= Constants.ZERO)) {
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "申请日期未处于保单日期内，无法进行该操作");
			}

			//查询保单下是否存在进行中的加减保/换厂单据
			if(applyChangeMapper.selectCount(new QueryWrapper<ApplyChange>().lambda()
			.eq(ApplyChange::getApplyId,insuranceApply.getId())
			.ne(ApplyChange::getId,applyChange.getId())
			.notIn(ApplyChange::getStatus,Constants.ApplyChangeStatus.APPROVE.getKey(),Constants.ApplyChangeStatus.CLOSE.getKey())
			)>Constants.ZERO){
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "存在进行中的加减保/换厂申请");
			};
			applyChange.setEditDate(new Date());
			applyChange.setEditor(loginUserInfo.getId());
			applyChange.setApplyStartTime(applyChange.getValidTime());
			applyChange.setStatus(Constants.ZERO);
			BigDecimal fee = BigDecimal.ZERO;
			//删除历史数据
			applyChagneDetailJoinMapper.delete(new QueryWrapper<ApplyChagneDetail>().lambda().eq(ApplyChagneDetail::getApplyChangeId,applyChange.getId()));

			this.dealApplyChangeData(applyChange,insuranceApply,companySolution,solutions,loginUserInfo,fee);
			BigDecimal fee = this.dealApplyChangeData(applyChange,insuranceApply,companySolution,solutions,loginUserInfo,BigDecimal.ZERO);
			applyChange.setFee(fee);
			applyChangeMapper.updateById(applyChange);
			this.saveApplyLog(applyChange,Constants.ApplyChangeLogStatus.UPLOAD,null);

			Constants.ApplyLogType applyLogType = Constants.ApplyLogType.CA_UPLOAD_AGAIN;
			String info =applyLogType.getInfo();
			info = info.replace("${param}", "");
			ApplyLog log = new ApplyLog(applyChange,applyLogType.getName(),info,applyChange.getId(),applyLogType.getKey(), null, null);
			applyLogMapper.insert(log);


			return applyChange.getId();
			}


			public void dealApplyChangeData(ApplyChange applyChange,InsuranceApply insuranceApply,CompanySolution companySolution,Solutions solutions,LoginUserInfo loginUserInfo,BigDecimal fee){
			public BigDecimal dealApplyChangeData(ApplyChange applyChange,InsuranceApply insuranceApply,CompanySolution companySolution,Solutions solutions,LoginUserInfo loginUserInfo,BigDecimal fee){


			//查询保险方案下的所有派遣单位
			@@ -700,7 +956,7 @@
			.eq(DispatchUnit::getUnitStatus,Constants.ONE)
			.eq(DuSolution::getIsdeleted,Constants.ZERO)
			.eq(DuSolution::getStatus,Constants.ONE)
			.eq(DuSolution::getSolutionId,insuranceApply.getSolutionId()));
			.eq(DuSolution::getSolutionId,companySolution.getSolutionId()));
			if(!CollectionUtils.isNotEmpty(duSolutionList)){
			throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"数据异常：保险方案下未查询到派遣单位");
			}
			@@ -723,8 +979,15 @@
			if(companySolution.getCanAdd().equals(Constants.ZERO)){
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "该企业分配保险方案无法进行加保");
			}
			//验证是否存在重复数据
			List<String> idcarNo = addDetailList.stream().map(m->m.getIdcardNo()).collect(Collectors.toList());
			Set<String> set = new HashSet<>(idcarNo);
			if(idcarNo.size() != set.size()){
			throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"对不起，人员录入数据存在相同数据！");
			}

			//加保明细数据计算金额根据批单时间计算
			applyChangeCyclePriceDTO.setValidTime(DateUtil.getMontageDate(insuranceApply.getStartTime(),1));
			applyChangeCyclePriceDTO.setValidTime(DateUtil.getMontageDate(applyChange.getValidTime(),1));
			CountCyclePriceVO countCyclePriceVO = this.getChangeCountCyclePriceVO(applyChangeCyclePriceDTO);
			BigDecimal detailFee = countCyclePriceVO.getCyclePrice();

			@@ -736,14 +999,21 @@
			//减保数据
			List<ApplyChagneDetail> delDetailList = applyChange.getDelDetailList();
			if (CollectionUtils.isNotEmpty(delDetailList)) {
			//验证是否存在重复数据
			List<String> idcarNo = delDetailList.stream().map(m->m.getIdcardNo()).collect(Collectors.toList());
			Set<String> set = new HashSet<>(idcarNo);
			if(idcarNo.size() != set.size()){
			throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"对不起，人员录入数据存在相同数据！");
			}

			if(companySolution.getCanReduce().equals(Constants.ZERO)){
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "该企业分配保险方案无法进行减保");
			}
			//减保明细数据计算金额根据批单时间前一天计算
			applyChangeCyclePriceDTO.setValidTime(DateUtil.getMontageDate(insuranceApply.getStartTime(),3));
			applyChangeCyclePriceDTO.setValidTime(DateUtil.getMontageDate(applyChange.getValidTime(),2));
			CountCyclePriceVO countCyclePriceVO = this.getChangeCountCyclePriceVO(applyChangeCyclePriceDTO);
			BigDecimal detailFee = countCyclePriceVO.getCyclePrice();
			this.delChangeDetail(applyChange,delDetailList,insuranceApply,solutions,loginUserInfo,detailFee);
			this.delChangeDetail(applyChange,delDetailList,insuranceApply,solutions,loginUserInfo,detailFee,applyChangeCyclePriceDTO.getValidTime());
			fee = fee.add(delDetailList.stream().map(ApplyChagneDetail::getFee).reduce(BigDecimal.ZERO,BigDecimal::add));
			}

			@@ -752,26 +1022,22 @@
			if (CollectionUtils.isNotEmpty(changeDetailList)) {
			this.changeDetail(applyChange,changeDetailList,duWorktypeList,duSolutionList,loginUserInfo);
			}
			return fee;
			}





			public void saveApplyLog(ApplyChange applyChange,Constants.ApplyChangeLogStatus applyChangeLogStatus,String content){
			public void saveApplyLog(ApplyChange applyChange,Constants.ApplyLogType applyLogType,String content){
			LoginUserInfo loginUserInfo = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
			ApplyLog applyLog = new ApplyLog();
			applyLog.setCreateDate(new Date());
			applyLog.setCreator(loginUserInfo.getId());
			applyLog.setIsdeleted(Constants.ZERO);
			applyLog.setApplyId(applyChange.getApplyId());
			applyLog.setTitle(applyChangeLogStatus.getName());
			applyLog.setTitle(applyLogType.getName());
			if(StringUtils.isNotBlank(content)){
			applyLog.setContent(applyChangeLogStatus.getInfo().replace("${param}",content));
			}else{
			applyLog.setContent(applyChangeLogStatus.getInfo());
			applyLog.setContent(applyLogType.getInfo().replace("${param}",content));
			}
			applyLog.setObjType(applyChangeLogStatus.getKey());
			applyLog.setObjType(applyLogType.getKey());
			applyLog.setObjId( applyChange.getId());
			applyLog.setStatus(applyChange.getStatus());
			applyLogMapper.insert(applyLog);
			@@ -784,11 +1050,24 @@
			* @param delDetailList
			* @param loginUserInfo
			*/
			public void delChangeDetail(ApplyChange applyChange ,List<ApplyChagneDetail> delDetailList,InsuranceApply insuranceApply,Solutions solutions,LoginUserInfo loginUserInfo,BigDecimal detailFee){
			public void delChangeDetail(ApplyChange applyChange ,List<ApplyChagneDetail> delDetailList,InsuranceApply insuranceApply,Solutions solutions,
			LoginUserInfo loginUserInfo,BigDecimal detailFee,Date endTime){
			for (ApplyChagneDetail applyChagneDetail : delDetailList) {
			if (Objects.isNull(applyChagneDetail.getMemberId())) {
			throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "减保人员【" + applyChagneDetail.getMemberName() + "】必填项缺失");
			}

			//查询减保人员是否存在冲突的保单明细数据
			if(applyDetailJoinMapper.selectCount(new QueryWrapper<ApplyDetail>()
			.lambda()
			.eq(ApplyDetail::getApplyId,applyChange.getApplyId())
			.eq(ApplyDetail::getIdcardNo,applyChagneDetail.getIdcardNo())
			.le(ApplyDetail::getStartTime,DateUtil.getMontageDate(applyChange.getApplyStartTime(),1))
			.ge(ApplyDetail::getEndTime,DateUtil.getMontageDate(applyChange.getApplyStartTime(),3))
			)<=Constants.ZERO){
			throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "当前保单下，减保人员【" + applyChagneDetail.getMemberName() + "】未查询到符合批单日期的数据");
			}

			Member member = memberMapper.selectById(applyChagneDetail.getMemberId());
			if (Objects.isNull(member)) {
			throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "减保人员【" + applyChagneDetail.getMemberName() + "】未查询到系统人员信息");
			@@ -797,6 +1076,7 @@
			if (applyChagneDetailJoinMapper.selectJoinCount(
			new MPJLambdaWrapper<ApplyChagneDetail>()
			.leftJoin(ApplyChange.class, ApplyChange::getId, ApplyChagneDetail::getApplyChangeId)
			.eq(ApplyChange::getApplyId,applyChange.getApplyId())
			.eq(ApplyChagneDetail::getMemberId, applyChagneDetail.getMemberId())
			.in(ApplyChange::getStatus, Constants.ZERO, Constants.ONE)
			) > Constants.ZERO) {
			@@ -806,6 +1086,8 @@
			List<ApplyDetail> applyDetailList = applyDetailJoinMapper.selectList(new QueryWrapper<ApplyDetail>().lambda()
			.eq(ApplyDetail::getApplyId, applyChange.getApplyId())
			.eq(ApplyDetail::getMemberId, applyChagneDetail.getMemberId())
			.le(ApplyDetail::getStartTime,DateUtil.getMontageDate(applyChange.getApplyStartTime(),1))
			.ge(ApplyDetail::getEndTime,DateUtil.getMontageDate(applyChange.getApplyStartTime(),3))
			.orderByDesc(ApplyDetail::getCreateDate));
			if (applyDetailList.size() > Constants.ONE) {
			throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "减保人员【" + applyChagneDetail.getMemberName() + "】保单信息异常，存在多条数据");
			@@ -814,14 +1096,23 @@
			if (applyChange.getValidTime().compareTo(applyDetail.getEndTime()) > 0) {
			throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "减保人员【" + applyChagneDetail.getMemberName() + "】保单保障日期至：【" + applyDetail.getEndTime() + "】无法通过本次申请");
			}

			applyChagneDetail.setPrice(applyDetail.getPrice());
			applyChagneDetail.setCreateDate(new Date());
			applyChagneDetail.setCreator(loginUserInfo.getId());
			applyChagneDetail.setIsdeleted(Constants.ZERO);
			applyChagneDetail.setApplyChangeId(applyChange.getId());
			applyChagneDetail.setType(Constants.ONE);

			applyChagneDetail.setStartTime(DateUtil.getMontageDate(applyDetail.getStartTime(),1));
			applyChagneDetail.setEndTime(DateUtil.getMontageDate(applyChange.getStartTime(),3));
			applyChagneDetail.setStartTime(applyDetail.getStartTime());
			applyChagneDetail.setEndTime(endTime);

			member.setApplyId(insuranceApply.getId());
			member.setDuId(applyChagneDetail.getDuId());
			member.setWorktypeId(applyChagneDetail.getWorktypeId());
			member.setStartTime(applyChagneDetail.getStartTime());
			member.setEndTime(applyChagneDetail.getEndTime());
			memberMapper.updateById(member);

			applyChagneDetail.setFee( detailFee.multiply(new BigDecimal(-1)));
			applyChagneDetailJoinMapper.insert(applyChagneDetail);
			@@ -838,7 +1129,9 @@
			* @param duSolutionList
			* @param loginUserInfo
			*/
			public void addChangeDetail(ApplyChange applyChange ,List<ApplyChagneDetail> addDetailList,List<DuWorktype> duWorktypeList,List<DuSolution> duSolutionList,InsuranceApply insuranceApply,Solutions solutions,LoginUserInfo loginUserInfo,BigDecimal detailFee){
			public void addChangeDetail(ApplyChange applyChange ,List<ApplyChagneDetail> addDetailList,
			List<DuWorktype> duWorktypeList,List<DuSolution> duSolutionList,
			InsuranceApply insuranceApply,Solutions solutions,LoginUserInfo loginUserInfo,BigDecimal detailFee){
			for (ApplyChagneDetail applyChagneDetail : addDetailList) {
			if ( Objects.isNull(applyChagneDetail.getDuId())
			\|\| Objects.isNull(applyChagneDetail.getWorktypeId())
			@@ -846,7 +1139,32 @@
			) {
			throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "加保人员【" + applyChagneDetail.getMemberName() + "】必填项缺失");
			}
			//查询加保人员是否存在冲突的保单明细数据
			if(applyDetailJoinMapper.selectCount(new QueryWrapper<ApplyDetail>()
			.lambda()
			.eq(ApplyDetail::getApplyId,applyChange.getApplyId())
			.eq(ApplyDetail::getIdcardNo,applyChagneDetail.getIdcardNo())
			.le(ApplyDetail::getStartTime,DateUtil.getMontageDate(applyChange.getApplyStartTime(),1))
			.ge(ApplyDetail::getEndTime,DateUtil.getMontageDate(insuranceApply.getEndTime(),2))
			//.ge(ApplyDetail::getEndTime,DateUtil.getMontageDate(applyChange.getApplyStartTime(),3))
			)>Constants.ZERO){
			throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "当前保单下，加保人员【" + applyChagneDetail.getMemberName() + "】存在日期冲突的数据");
			}

			ApplyDetail applyDetail = applyDetailJoinMapper.selectOne(new QueryWrapper<ApplyDetail>()
			.lambda()
			.eq(ApplyDetail::getApplyId,applyChange.getApplyId()).last("limit 1"));
			if(Objects.isNull(applyDetail)){
			throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "保单中未存在明细记录");
			}
			applyChagneDetail.setPrice(applyDetail.getPrice());
			applyChagneDetail.setCreateDate(new Date());
			applyChagneDetail.setCreator(loginUserInfo.getId());
			applyChagneDetail.setIsdeleted(Constants.ZERO);
			applyChagneDetail.setApplyChangeId(applyChange.getId());
			applyChagneDetail.setStartTime(DateUtil.getMontageDate(applyChange.getApplyStartTime(),1));
			applyChagneDetail.setEndTime(DateUtil.getMontageDate(insuranceApply.getEndTime(),2));
			applyChagneDetail.setType(Constants.ZERO);
			Member member = new Member();
			if(Objects.isNull(applyChagneDetail.getMemberId())){
			//查询是否存在该用户
			@@ -868,11 +1186,15 @@
			member.setApplyId(insuranceApply.getId());
			member.setDuId(applyChagneDetail.getDuId());
			member.setWorktypeId(applyChagneDetail.getWorktypeId());
			member.setStartTime(applyChagneDetail.getStartTime());
			member.setEndTime(applyChagneDetail.getEndTime());
			memberMapper.insert(member);
			}else{
			member.setApplyId(insuranceApply.getId());
			member.setDuId(applyChagneDetail.getDuId());
			member.setWorktypeId(applyChagneDetail.getWorktypeId());
			member.setStartTime(applyChagneDetail.getStartTime());
			member.setEndTime(applyChagneDetail.getEndTime());
			memberMapper.updateById(member);
			}
			}else{
			@@ -883,17 +1205,31 @@
			member.setApplyId(insuranceApply.getId());
			member.setDuId(applyChagneDetail.getDuId());
			member.setWorktypeId(applyChagneDetail.getWorktypeId());
			member.setStartTime(applyChagneDetail.getStartTime());
			member.setEndTime(applyChagneDetail.getEndTime());
			memberMapper.updateById(member);
			}

			//根据员工身份证进行判断年龄
			long age = Constants.getAgeByIdCard(member.getIdcardNo());
			if(Objects.isNull(age)
			\|\| age > solutions.getMaxAge()
			\|\| age < solutions.getMinAge()){
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"【"+applyChagneDetail.getMemberName()+"】员工年龄超出方案配置方案配置【"+solutions.getMinAge()+" - "+solutions.getMaxAge()+"】存在异常数据！");
			}

			//查询员工是否存在 0待签署 1已签章的此类业务保数据同一主单下
			if (applyChagneDetailJoinMapper.selectJoinCount(
			new MPJLambdaWrapper<ApplyChagneDetail>()
			.leftJoin(ApplyChange.class, ApplyChange::getId, ApplyChagneDetail::getApplyChangeId)
			.eq(ApplyChagneDetail::getMemberId, applyChagneDetail.getMemberId())
			.eq(ApplyChange::getApplyId,applyChange.getApplyId())
			.in(ApplyChange::getStatus, Constants.ZERO, Constants.ONE)
			) > Constants.ZERO) {
			throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "加保人员【" + applyChagneDetail.getMemberName() + "】存在申请中的加减保/换厂单据");
			}


			//查询员工是在主单下是否存在生效中的数据
			if(!Objects.isNull(applyChagneDetail.getMemberId())){
			if (applyDetailJoinMapper.selectCount(new QueryWrapper<ApplyDetail>().lambda()
			@@ -914,13 +1250,6 @@
			throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(), "【" + applyChagneDetail.getMemberName() + "】员工工种信息未查询到！");
			}
			applyChagneDetail.setMemberId(member.getId());
			applyChagneDetail.setCreateDate(new Date());
			applyChagneDetail.setCreator(loginUserInfo.getId());
			applyChagneDetail.setIsdeleted(Constants.ZERO);
			applyChagneDetail.setApplyChangeId(applyChange.getId());
			applyChagneDetail.setStartTime(DateUtil.getMontageDate(applyChange.getStartTime(),1));
			applyChagneDetail.setEndTime(DateUtil.getMontageDate(insuranceApply.getEndTime(),2));
			applyChagneDetail.setType(Constants.ZERO);
			applyChagneDetail.setFee(detailFee);
			applyChagneDetailJoinMapper.insert(applyChagneDetail);
			}
			@@ -945,6 +1274,18 @@
			) {
			throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "换厂人员【" + applyChagneDetail.getMemberName() + "】必填项缺失");
			}

			//查询换厂人员是否存在有效的保单明细数据
			if(applyDetailJoinMapper.selectCount(new QueryWrapper<ApplyDetail>()
			.lambda()
			.eq(ApplyDetail::getApplyId,applyChange.getApplyId())
			.eq(ApplyDetail::getIdcardNo,applyChagneDetail.getIdcardNo())
			.le(ApplyDetail::getStartTime,DateUtil.getMontageDate(applyChange.getApplyStartTime(),1))
			.ge(ApplyDetail::getEndTime,DateUtil.getMontageDate(applyChange.getApplyStartTime(),1))
			)<=Constants.ZERO){
			throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "当前保单下，换厂人员【" + applyChagneDetail.getMemberName() + "】未查询到符合批单日期的数据");
			}

			Member member = memberMapper.selectById(applyChagneDetail.getMemberId());
			if (Objects.isNull(member)) {
			throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "换厂人员【" + applyChagneDetail.getMemberName() + "】未查询到系统人员信息");
			@@ -954,6 +1295,7 @@
			new MPJLambdaWrapper<ApplyChagneDetail>()
			.leftJoin(ApplyChange.class, ApplyChange::getId, ApplyChagneDetail::getApplyChangeId)
			.eq(ApplyChagneDetail::getMemberId, applyChagneDetail.getMemberId())
			.eq(ApplyChange::getApplyId, applyChange.getApplyId())
			.in(ApplyChange::getStatus, Constants.ZERO, Constants.ONE)
			) > Constants.ZERO) {
			throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "换厂人员【" + applyChagneDetail.getMemberName() + "】存在申请中的加减保/换厂单据");
			@@ -962,10 +1304,12 @@
			List<ApplyDetail> applyDetailList = applyDetailJoinMapper.selectList(new QueryWrapper<ApplyDetail>().lambda()
			.eq(ApplyDetail::getApplyId, applyChange.getApplyId())
			.eq(ApplyDetail::getMemberId, applyChagneDetail.getMemberId())
			.le(ApplyDetail::getStartTime, DateUtil.getDate(new Date(),"yyyy-MM-dd HH:mm:ss"))
			.ge(ApplyDetail::getEndTime, DateUtil.getDate(new Date(),"yyyy-MM-dd HH:mm:ss")));
			.le(ApplyDetail::getStartTime,DateUtil.getMontageDate(applyChange.getApplyStartTime(),1))
			.ge(ApplyDetail::getEndTime,DateUtil.getMontageDate(applyChange.getApplyStartTime(),1)));
			if(applyDetailList.size()>Constants.ONE){
			throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "换厂人员【" + applyChagneDetail.getMemberName() + "】保单信息异常，存在多条数据");
			}else if(applyDetailList.size()==Constants.ZERO){
			throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "换厂人员【" + applyChagneDetail.getMemberName() + "】未查询到投保记录");
			}
			ApplyDetail applyDetail = applyDetailList.get(Constants.ZERO);
			if(applyChange.getValidTime().compareTo( applyDetail.getEndTime())>0){
			@@ -979,12 +1323,28 @@
			.collect(Collectors.toList()).size() <= Constants.ZERO) {
			throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(), "换厂人员【" + applyChagneDetail.getMemberName() + "】员工工种信息未查询到！");
			}
			if(applyChagneDetail.getOldDuId().equals(applyChagneDetail.getDuId())
			&& applyChagneDetail.getOldWorktypeId().equals(applyChagneDetail.getWorktypeId())){
			throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(), "换厂人员【" + applyChagneDetail.getMemberName() + "】换厂数据相同！");
			}
			applyChagneDetail.setPrice(applyDetail.getPrice());
			applyChagneDetail.setCreateDate(new Date());
			applyChagneDetail.setCreator(loginUserInfo.getId());
			applyChagneDetail.setIsdeleted(Constants.ZERO);
			applyChagneDetail.setApplyChangeId(applyChange.getId());
			applyChagneDetail.setType(Constants.TWO);
			applyChagneDetail.setStartTime(applyDetail.getStartTime());
			applyChagneDetail.setEndTime(applyDetail.getEndTime());

			applyChagneDetailJoinMapper.insert(applyChagneDetail);

			member.setApplyId(applyChange.getApplyId());
			member.setDuId(applyChagneDetail.getDuId());
			member.setWorktypeId(applyChagneDetail.getWorktypeId());
			member.setStartTime(applyChagneDetail.getStartTime());
			member.setEndTime(applyChagneDetail.getEndTime());
			memberMapper.updateById(member);

			}
			}

			@@ -1041,6 +1401,8 @@

			@Override
			public PageData<ApplyChange> findPage(PageWrap<ApplyChange> pageWrap) {

			LoginUserInfo loginUserInfo = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
			IPage<ApplyChange> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
			MPJLambdaWrapper<ApplyChange> queryWrapper = new MPJLambdaWrapper<>();
			Utils.MP.blankToNull(pageWrap.getModel());
			@@ -1048,6 +1410,7 @@
			queryWrapper
			.selectAll(ApplyChange.class)
			.selectAs(InsuranceApply::getCode,ApplyChange::getApplyCode)
			.selectAs( Solutions::getType,InsuranceApply::getSolutionType)
			.select("( select count(1) from apply_chagne_detail ad where t.id = ad.APPLY_CHANGE_ID and ad.TYPE = 0 )",ApplyChange::getAddNum)
			.select("( select count(1) from apply_chagne_detail ad where t.id = ad.APPLY_CHANGE_ID and ad.TYPE = 1 )",ApplyChange::getDelNum)
			.select("( select count(1) from apply_chagne_detail ad where t.id = ad.APPLY_CHANGE_ID and ad.TYPE = 2 )",ApplyChange::getChangeNum)
			@@ -1059,10 +1422,22 @@
			.in(!Objects.isNull(model.getStatus())&&model.getStatus().equals(Constants.ApplyChangeStatus.RETURN_APPLY_UPLOAD.getKey()),ApplyChange::getStatus,
			Constants.ApplyChangeStatus.RETURN_APPLY_UPLOAD.getKey(),
			Constants.ApplyChangeStatus.RETURN_APPLY_SIGNATURE.getKey())
			.eq(!Objects.isNull(model.getSolutionType()),Solutions::getType,model.getSolutionType())
			.eq(!Objects.isNull(model.getCompanyId()),InsuranceApply::getCompanyId,model.getCompanyId())
			.eq(!Objects.isNull(model.getSolutionsId()),ApplyChange::getSolutionsId,model.getSolutionsId())
			.ge(StringUtils.isNotBlank(model.getCreateDateS()),ApplyChange::getCreateDate, model.getCreateDateS()+" 00:00:00" )
			.le(StringUtils.isNotBlank(model.getCreateDateE()),ApplyChange::getCreateDate, model.getCreateDateE()+" 23:59:59" );
			if(loginUserInfo.getType().equals(Constants.TWO)){
			//如果是商户查看
			if(pageWrap.getModel().getSolutionType()!=null && pageWrap.getModel().getSolutionType() ==0){
			queryWrapper.exists("select cs.id from company_solution cs where cs.isdeleted=0 and cs.company_id=t1.company_id and cs.shop_id="+loginUserInfo.getCompanyId());
			}else if(pageWrap.getModel().getSolutionType()!=null && pageWrap.getModel().getSolutionType() ==1){
			queryWrapper.eq(Solutions::getShopId,loginUserInfo.getCompanyId());
			}else{
			queryWrapper.apply("((t1.type=0 and exists(select cs.id from company_solution cs where cs.isdeleted=0 and cs.company_id=t1.company_id and cs.shop_id="+loginUserInfo.getCompanyId()+")) or (" +
			"t2.type=1 and t2.shop_id="+loginUserInfo.getCompanyId()+"))") ;
			}
			}

			for(PageWrap.SortData sortData: pageWrap.getSorts()) {
			if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) {
			@@ -1093,32 +1468,159 @@
			.selectAll(ApplyChange.class)
			.selectAs(InsuranceApply::getCode,ApplyChange::getApplyCode)
			.selectAs(Solutions::getName,ApplyChange::getSolutionsName)
			.selectAs(Solutions::getType,ApplyChange::getSolutionType)
			.selectAs(Company::getName,ApplyChange::getCompanyName)
			.select("( select count(1) from apply_chagne_detail ad where t.id = ad.APPLY_CHANGE_ID and ad.TYPE = 0 )",ApplyChange::getAddNum)
			.select("( select count(1) from apply_chagne_detail ad where t.id = ad.APPLY_CHANGE_ID and ad.TYPE = 1 )",ApplyChange::getDelNum)
			.select("( select count(1) from apply_chagne_detail ad where t.id = ad.APPLY_CHANGE_ID and ad.TYPE = 2 )",ApplyChange::getChangeNum)
			.select("( select ifnull(sum(ad.FEE),0) from apply_chagne_detail ad where t.id = ad.APPLY_CHANGE_ID )",ApplyChange::getChangeMoney)
			.leftJoin(InsuranceApply.class,InsuranceApply::getId,ApplyChange::getApplyId)
			.leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId)
			.leftJoin(Company.class,Company::getId,InsuranceApply::getCompanyId)
			.eq(!Objects.isNull(model.getType()),ApplyChange::getType,model.getType())
			.eq(!Objects.isNull(model.getStatus())&&!model.getStatus().equals(Constants.ApplyChangeStatus.RETURN_APPLY_UPLOAD.getKey()),ApplyChange::getStatus,model.getStatus())
			.in(!Objects.isNull(model.getStatus())&&model.getStatus().equals(Constants.ApplyChangeStatus.RETURN_APPLY_UPLOAD.getKey()),ApplyChange::getStatus,
			Constants.ApplyChangeStatus.RETURN_APPLY_UPLOAD.getKey(),
			Constants.ApplyChangeStatus.RETURN_APPLY_SIGNATURE.getKey())
			.eq(!Objects.isNull(model.getUnionApplyId()),InsuranceApply::getUnionApplyId,model.getUnionApplyId())
			// .eq(!Objects.isNull(model.getSolutionsId()),ApplyChange::getSolutionsId,model.getSolutionsId())
			.eq(!Objects.isNull(model.getSolutionType()),Solutions::getType,model.getSolutionType())
			.eq(!Objects.isNull(model.getApplyId()),ApplyChange::getApplyId,model.getApplyId())
			.eq(!Objects.isNull(model.getBaseSolutionsId()),Solutions::getBaseId,model.getBaseSolutionsId())
			.like(StringUtils.isNotBlank(model.getSolutionsName()),Solutions::getName,model.getSolutionsName())
			.ge(StringUtils.isNotBlank(model.getCreateDateS()),ApplyChange::getCreateDate, model.getCreateDateS()+" 00:00:00" )
			.le(StringUtils.isNotBlank(model.getCreateDateE()),ApplyChange::getCreateDate, model.getCreateDateE()+" 23:59:59" )
			.ge(StringUtils.isNotBlank(model.getApplyStartS()),ApplyChange::getApplyStartTime, model.getApplyStartS()+" 00:00:00" )
			.le(StringUtils.isNotBlank(model.getApplyStartE()),ApplyChange::getApplyStartTime, model.getApplyStartE()+" 23:59:59" );
			LoginUserInfo loginUserInfo =(LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
			//企业人员查看本企业数据
			if(loginUserInfo.getType().equals(Constants.ONE)){
			queryWrapper.eq(InsuranceApply::getCompanyId, loginUserInfo.getCompanyId());
			}else if(loginUserInfo.getType().equals(Constants.TWO)){
			//如果是商户查看
			if(pageWrap.getModel().getSolutionType()!=null && pageWrap.getModel().getSolutionType() ==0){
			queryWrapper.exists("select cs.id from company_solution cs where cs.isdeleted=0 and cs.company_id=t1.company_id and cs.shop_id="+loginUserInfo.getCompanyId());
			}else if(pageWrap.getModel().getSolutionType()!=null && pageWrap.getModel().getSolutionType() ==1){
			queryWrapper.eq(Solutions::getShopId,loginUserInfo.getCompanyId());
			}else{
			queryWrapper.apply("((t1.type=0 and exists(select cs.id from company_solution cs where cs.isdeleted=0 and cs.company_id=t1.company_id and cs.shop_id="+loginUserInfo.getCompanyId()+")) or (" +
			"t2.type=1 and t2.shop_id="+loginUserInfo.getCompanyId()+"))") ;
			}
			}else{
			if(loginUserInfo.getCompanyIdList()!=null && loginUserInfo.getCompanyIdList().size()>0){
			queryWrapper.in(InsuranceApply::getCompanyId, loginUserInfo.getCompanyIdList());
			}else{
			queryWrapper.eq(InsuranceApply::getCompanyId, -1);
			}
			queryWrapper.eq(pageWrap.getModel().getCompanyId()!=null,InsuranceApply::getCompanyId, pageWrap.getModel().getCompanyId());
			}

			queryWrapper.orderByDesc(ApplyDetail::getCreateDate);

			PageData<ApplyChange> pageData = PageData.from(applyChangeJoinMapper.selectJoinPage(page,ApplyChange.class, queryWrapper));
			return pageData;
			}

			@Override
			public List<ApplyChange> findListForCompany(ApplyChange model) {
			MPJLambdaWrapper<ApplyChange> queryWrapper = new MPJLambdaWrapper<>();
			queryWrapper
			.selectAll(ApplyChange.class)
			.selectAs(InsuranceApply::getCode,ApplyChange::getApplyCode)
			.selectAs(InsuranceApply::getStartTime,ApplyChange::getStartTime)
			.selectAs(InsuranceApply::getCode,ApplyChange::getValidCode)
			.selectAs(InsuranceApply::getEndTime,ApplyChange::getEndTime)
			.selectAs(Solutions::getName,ApplyChange::getSolutionsName)
			.selectAs(Solutions::getType,ApplyChange::getSolutionType)
			.selectAs(Company::getName,ApplyChange::getCompanyName)
			.select("( select count(1) from apply_chagne_detail ad where t.id = ad.APPLY_CHANGE_ID and ad.TYPE = 0 )",ApplyChange::getAddNum)
			.select("( select count(1) from apply_chagne_detail ad where t.id = ad.APPLY_CHANGE_ID and ad.TYPE = 1 )",ApplyChange::getDelNum)
			.select("( select count(1) from apply_chagne_detail ad where t.id = ad.APPLY_CHANGE_ID and ad.TYPE = 2 )",ApplyChange::getChangeNum)
			.select("( select ifnull(sum(ad.FEE),0) from apply_chagne_detail ad where t.id = ad.APPLY_CHANGE_ID )",ApplyChange::getChangeMoney)
			.leftJoin(InsuranceApply.class,InsuranceApply::getId,ApplyChange::getApplyId)
			.leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId)
			.leftJoin(Company.class,Company::getId,InsuranceApply::getCompanyId)
			.eq(!Objects.isNull(model.getType()),ApplyChange::getType,model.getType())
			.eq(!Objects.isNull(model.getStatus())&&!model.getStatus().equals(Constants.ApplyChangeStatus.RETURN_APPLY_UPLOAD.getKey()),ApplyChange::getStatus,model.getStatus())
			.in(!Objects.isNull(model.getStatus())&&model.getStatus().equals(Constants.ApplyChangeStatus.RETURN_APPLY_UPLOAD.getKey()),ApplyChange::getStatus,
			.in(!Objects.isNull(model.getStatus())&&model.getStatus().equals(Constants.ApplyChangeStatus.RETURN_APPLY_UPLOAD.getKey()),
			ApplyChange::getStatus,
			Constants.ApplyChangeStatus.RETURN_APPLY_UPLOAD.getKey(),
			Constants.ApplyChangeStatus.RETURN_APPLY_SIGNATURE.getKey())
			.eq(!Objects.isNull(model.getCompanyId()),InsuranceApply::getCompanyId,model.getCompanyId())
			.eq(!Objects.isNull(model.getUnionApplyId()),InsuranceApply::getUnionApplyId,model.getUnionApplyId())
			// .eq(!Objects.isNull(model.getSolutionsId()),ApplyChange::getSolutionsId,model.getSolutionsId())
			.eq(!Objects.isNull(model.getSolutionType()),Solutions::getType,model.getSolutionType())
			.eq(!Objects.isNull(model.getApplyId()),ApplyChange::getApplyId,model.getApplyId())
			.eq(!Objects.isNull(model.getUnionChangeId()),ApplyChange::getUnionChangeId,model.getUnionChangeId())
			.eq(!Objects.isNull(model.getBaseSolutionsId()),Solutions::getBaseId,model.getBaseSolutionsId())
			.like(StringUtils.isNotBlank(model.getSolutionsName()),Solutions::getName,model.getSolutionsName())
			.ge(StringUtils.isNotBlank(model.getCreateDateS()),ApplyChange::getCreateDate, model.getCreateDateS()+" 00:00:00" )
			.le(StringUtils.isNotBlank(model.getCreateDateE()),ApplyChange::getCreateDate, model.getCreateDateE()+" 23:59:59" );
			.le(StringUtils.isNotBlank(model.getCreateDateE()),ApplyChange::getCreateDate, model.getCreateDateE()+" 23:59:59" )
			.ge(StringUtils.isNotBlank(model.getApplyStartS()),ApplyChange::getApplyStartTime, model.getApplyStartS()+" 00:00:00" )
			.le(StringUtils.isNotBlank(model.getApplyStartE()),ApplyChange::getApplyStartTime, model.getApplyStartE()+" 23:59:59" );
			LoginUserInfo loginUserInfo =(LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
			//企业人员查看本企业数据
			if(loginUserInfo.getType().equals(Constants.ONE)){
			queryWrapper.eq(InsuranceApply::getCompanyId, loginUserInfo.getCompanyId());
			}else if(loginUserInfo.getType().equals(Constants.TWO)){
			//如果是商户查看
			if(model.getSolutionType()!=null && model.getSolutionType() ==0){
			queryWrapper.exists("select cs.id from company_solution cs where cs.isdeleted=0 and cs.company_id=t1.company_id and cs.shop_id="+loginUserInfo.getCompanyId());
			}else if(model.getSolutionType()!=null && model.getSolutionType() ==1){
			queryWrapper.eq(Solutions::getShopId,loginUserInfo.getCompanyId());
			}else{
			queryWrapper.apply("((t2.type=0 and exists(select cs.id from company_solution cs where cs.isdeleted=0 and cs.company_id=t1.company_id and cs.shop_id="+loginUserInfo.getCompanyId()+")) or (" +
			"t2.type=1 and t2.shop_id="+loginUserInfo.getCompanyId()+"))") ;
			}
			}else{
			if(loginUserInfo.getCompanyIdList()!=null && loginUserInfo.getCompanyIdList().size()>0){
			queryWrapper.in(InsuranceApply::getCompanyId, loginUserInfo.getCompanyIdList());
			}else{
			queryWrapper.eq(InsuranceApply::getCompanyId, -1);
			}
			queryWrapper.eq(model.getCompanyId()!=null,InsuranceApply::getCompanyId, model.getCompanyId());
			}

			for(PageWrap.SortData sortData: pageWrap.getSorts()) {
			if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) {
			queryWrapper.orderByDesc(sortData.getProperty());
			} else {
			queryWrapper.orderByAsc(sortData.getProperty());
			queryWrapper.orderByDesc(ApplyDetail::getCreateDate);
			List<ApplyChange> list =applyChangeJoinMapper.selectJoinList(ApplyChange.class,queryWrapper);
			if(Constants.equalsObject(model.getGetFiles(),Constants.ONE)){
			//如果是合并单,需要查询附件信息
			initFileForList(list);
			}
			return list;
			}
			private void initFileForList(List<ApplyChange> list) {
			List<Integer> objList = new ArrayList<>();
			if(list!=null && list.size()>0){
			for(ApplyChange param : list){
			objList.add(param.getId());
			}
			}else{
			return;
			}
			List<Multifile> multifiles = multifileMapper.selectList(new QueryWrapper<Multifile>().lambda()
			.in(Multifile::getObjId,objList)
			.in(Multifile::getObjType,Arrays.asList(new Integer[]{Constants.MultiFile.CA_PD_PDF.getKey()}))
			.eq(Multifile::getIsdeleted,Constants.ZERO)
			.orderByAsc(Multifile::getId));
			if(multifiles!=null && multifiles.size()>0){
			String path = systemDictDataBiz.queryByCode(Constants.OSS,Constants.RESOURCE_PATH).getCode()
			+systemDictDataBiz.queryByCode(Constants.OSS,Constants.APPLY_FILE).getCode();
			for(ApplyChange model : list){
			for(Multifile f : multifiles) {
			if (StringUtils.isBlank(f.getFileurl())) {
			continue;
			}
			f.setFileurlFull(path+f.getFileurl());
			if(Constants.equalsInteger(f.getObjId(), model.getId()) ){
			if (Constants.equalsInteger(f.getObjType(), Constants.MultiFile.CA_PD_PDF.getKey())) {
			//签署前的投保单
			model.setPidanFile(f);
			}
			}
			}
			}
			}
			PageData<ApplyChange> pageData = PageData.from(applyChangeJoinMapper.selectJoinPage(page,ApplyChange.class, queryWrapper));
			return pageData;

			}


			@@ -1127,7 +1629,7 @@
			public void changeOpt(ApplyChangeOptDTO applyChangeOptDTO){
			if(Objects.isNull(applyChangeOptDTO)
			\|\|Objects.isNull(applyChangeOptDTO.getApplyId())
			\|\|StringUtils.isBlank(applyChangeOptDTO.getOptIllustration())){
			){
			throw new BusinessException(ResponseStatus.BAD_REQUEST);
			}
			LoginUserInfo loginUserInfo = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
			@@ -1143,11 +1645,20 @@
			if(applyChange.getIsdeleted().equals(Constants.ONE)){
			throw new BusinessException(ResponseStatus.DATA_ERRO.getCode(),"数据已删除,无法进行该操作");
			}
			Constants.ApplyChangeLogStatus applyChangeLogStatus = Constants.ApplyChangeLogStatus.RETURN_APPLY;
			Solutions solutions = solutionsMapper.selectById(insuranceApply.getSolutionId());
			if(Objects.isNull(solutions)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询方案信息");
			}

			Constants.ApplyLogType applyLogType = Constants.ApplyLogType.CA_PLATFORM_CHECK_PASS_NO;

			Constants.NoticeObjectType noticeObjectType = Constants.NoticeObjectType.APPLY_CHANGE;
			if(applyChange.getType().equals(Constants.ONE)){
			noticeObjectType = Constants.NoticeObjectType.CHANGE_FACTORY;
			}
			if(applyChangeOptDTO.getOptType().equals(3)){
			//发起退回申请
			if(loginUserInfo.getType().equals(Constants.ONE)){
			if(!loginUserInfo.getType().equals(Constants.ONE)){
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"非企业端用户无法进行该操作");
			}
			if(!(applyChange.getStatus().equals(Constants.ApplyChangeStatus.UPLOAD.getKey())
			@@ -1161,8 +1672,21 @@
			applyChange.setStatus(Constants.ApplyChangeStatus.RETURN_APPLY_SIGNATURE.getKey());
			}

			//存储待办信息
			//删除其他待办
			noticesMapper.delete(new QueryWrapper<Notices>().lambda().eq(Notices::getObjType,noticeObjectType.getKey()).eq(Notices::getObjId,applyChange.getId()));
			Notices notices = new Notices(noticeObjectType,Constants.ZERO,applyChange.getId(),solutions.getName(),
			insuranceApply.getCompanyId(), Constants.NoticeType.THREE);
			noticesMapper.insert(notices);
			//商户待办
			if(Objects.nonNull(solutions.getShopId())){
			Notices shopNotices = new Notices(noticeObjectType,Constants.TWO,
			applyChange.getId(),solutions.getName(),solutions.getShopId(),Constants.NoticeType.THREE);
			noticesMapper.insert(shopNotices);
			}

			}else if(applyChangeOptDTO.getOptType().equals(4)){
			applyChangeLogStatus = Constants.ApplyChangeLogStatus.PLATFORM_AGREE;
			applyLogType = Constants.ApplyLogType.CA_PLATFORM_AGREE_BACK_APPLY;
			//平台同意退回
			if(loginUserInfo.getType().equals(Constants.ZERO)){
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"非平台端用户无法进行该操作");
			@@ -1173,7 +1697,7 @@
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"数据状态错误无法进行该操作!");
			}
			}else if(applyChangeOptDTO.getOptType().equals(5)){
			applyChangeLogStatus = Constants.ApplyChangeLogStatus.PLATFORM_UN_AGREE;
			applyLogType = Constants.ApplyLogType.CA_PALTFORM_REFUSE_APPLY;
			//平台驳回退回
			if(loginUserInfo.getType().equals(Constants.ZERO)){
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"非平台端用户无法进行该操作");
			@@ -1190,14 +1714,16 @@
			}
			}else if(applyChangeOptDTO.getOptType().equals(6)){
			//企业关闭
			applyChangeLogStatus = Constants.ApplyChangeLogStatus.CLOSE;
			if(loginUserInfo.getType().equals(Constants.ONE)){
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"非企业端用户无法进行该操作");
			}
			if(!applyChange.getStatus().equals(Constants.ApplyChangeStatus.PLATFORM_AGREE.getKey())){
			applyLogType = Constants.ApplyLogType.CA_COMPANY_CLOSE;
			if(!(applyChange.getStatus().equals(Constants.ApplyChangeStatus.PLATFORM_AGREE.getKey())
			\|\|applyChange.getStatus().equals(Constants.ApplyChangeStatus.CHECHED_PASSED.getKey()))){
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"数据状态错误无法进行该操作!");
			}
			applyChange.setStatus(Constants.ApplyChangeStatus.CLOSE.getKey());
			//存储待办信息
			//删除其他待办
			noticesMapper.delete(new QueryWrapper<Notices>().lambda().eq(Notices::getObjType,noticeObjectType.getKey()).eq(Notices::getObjId,applyChange.getId()));

			}else{
			throw new BusinessException(ResponseStatus.BAD_REQUEST );
			}
			@@ -1205,8 +1731,14 @@
			applyChange.setEditDate(new Date());
			applyChangeMapper.updateById(applyChange);

			//存储日志数据
			this.saveApplyLog(applyChange,applyChangeLogStatus,applyChangeOptDTO.getOptIllustration());
			String info = applyLogType.getInfo();
			if(StringUtils.isNotBlank(applyChangeOptDTO.getOptIllustration())){
			info = info.replace("${param}", applyChangeOptDTO.getOptIllustration());
			}else{
			info = info.replace("${param}", "");
			}
			ApplyLog log = new ApplyLog(applyChange,applyLogType.getName(),info,applyChange.getId(),applyLogType.getKey(), null, null);
			applyLogMapper.insert(log);
			}


			@@ -1215,10 +1747,13 @@
			MPJLambdaWrapper<ApplyChange> queryWrapper = new MPJLambdaWrapper<>();
			queryWrapper.selectAll(ApplyChange.class)
			.selectAs(InsuranceApply::getCode,ApplyChange::getApplyCode)
			.selectAs(Company::getId,ApplyChange::getCompanyId)
			.selectAs(Company::getName,ApplyChange::getCompanyName)
			.selectAs(InsuranceApply::getStartTime,ApplyChange::getStartTime)
			.selectAs(InsuranceApply::getEndTime,ApplyChange::getEndTime)
			.selectAs(Solutions::getName,ApplyChange::getSolutionsName)
			.selectAs(Solutions::getType,ApplyChange::getSolutionType)
			.selectAs(Solutions::getId,ApplyChange::getSolutionsId)
			.select("( select count(1) from apply_chagne_detail ad where t.id = ad.APPLY_CHANGE_ID and ad.TYPE = 0 )",ApplyChange::getAddNum)
			.select("( select count(1) from apply_chagne_detail ad where t.id = ad.APPLY_CHANGE_ID and ad.TYPE = 1 )",ApplyChange::getDelNum)
			.select("( select count(1) from apply_chagne_detail ad where t.id = ad.APPLY_CHANGE_ID and ad.TYPE = 2 )",ApplyChange::getChangeNum)
			@@ -1237,16 +1772,17 @@
			.selectAs(Company::getName,ApplyLog::getCompanyName)
			.leftJoin(SystemUser.class,SystemUser::getId,ApplyLog::getCreator)
			.leftJoin(Company.class,Company::getId,SystemUser::getCompanyId)
			.in(ApplyLog::getObjType,Constants.ApplyLogType.getTypeList(Constants.ONE))
			.eq(ApplyLog::getObjId,applyChange.getId())
			.orderByAsc(ApplyLog::getCreateDate)
			);
			applyChange.setApplyLogList(applyLogList);

			List<Multifile> multifiles = multifileMapper.selectList(new QueryWrapper<Multifile>().lambda()
			.eq(Multifile::getObjId,applyChange.getId())
			.in(Multifile::getObjType, Arrays.asList(new Integer[]{Constants.MultiFile.CA_APPLY_JIAJIAN_SIGN.getKey()
			,Constants.MultiFile.CA_PD_PDF.getKey()
			,Constants.MultiFile.CA_APPLY_CHANGEUNIT_SIGN.getKey()}))
			.eq(Multifile::getObjId, applyChange.getId() )
			// .in(Multifile::getObjType, Arrays.asList(new Integer[]{Constants.MultiFile.CA_APPLY_JIAJIAN_SIGN.getKey()
			// ,Constants.MultiFile.CA_PD_PDF.getKey()
			// ,Constants.MultiFile.CA_APPLY_CHANGEUNIT_SIGN.getKey()}))
			.eq(Multifile::getIsdeleted,Constants.ZERO));
			if(multifiles!=null){
			String path = systemDictDataBiz.queryByCode(Constants.OSS,Constants.RESOURCE_PATH).getCode()
			@@ -1319,17 +1855,25 @@
			}
			LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
			Company company = user.getCompany();
			if(debugModel){
			company = companyMapper.selectById(model.getCompanyId());
			}
			/*if(debugModel){
			company = companyMapper.selectById(model.getCompanyId());
			}*/
			if(company== null \|\| StringUtils.isBlank( company.getEmail()) \|\| !Constants.equalsInteger(company.getSignStatus(),Constants.THREE)){
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"对不起，企业尚未具备在线签章条件，请联系平台管理员确认~");
			}
			InsuranceApply insuranceApply = insuranceApplyMapper.selectById(model.getApplyId());
			if(Objects.isNull(insuranceApply)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询保单信息");
			}
			Solutions solutions = solutionsMapper.selectById(insuranceApply.getSolutionId());
			if(Objects.isNull(solutions)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询方案信息");
			}
			String fileUrl = null;
			if(Constants.equalsObject(model.getType(), Constants.ONE)){
			fileUrl = ExcelExporter.build(ApplyChange.class).exportChangeUnitExcelToPdf(model,"换厂申请表");
			fileUrl = ExcelExporter.build(ApplyChange.class).exportChangeUnitExcelToPdf(model,"换厂申请表","投保企业");
			}else{
			fileUrl = ExcelExporter.build(ApplyChange.class).exportJiajianBaoExcelToPdf(model,"加减保申请表");
			fileUrl = ExcelExporter.build(ApplyChange.class).exportJiajianBaoExcelToPdf(model,"加减保申请表","投保企业");
			}
			String notifyUrl = systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.SIGN_DONE_NOTIFY_URL).getCode();
			notifyUrl = notifyUrl.replace("${type}","0").replace("${id}",model.getId().toString());
			@@ -1390,7 +1934,7 @@
			.selectAs(InsuranceApply::getCompanyId,ApplyChange::getCompanyId)
			.selectAs(InsuranceApply::getCode,ApplyChange::getApplyCode)
			.selectAs(InsuranceApply::getStartTime,ApplyChange::getStartTime)
			.selectAs(InsuranceApply::getStartTime,ApplyChange::getEndTime)
			.selectAs(InsuranceApply::getEndTime,ApplyChange::getEndTime)
			.leftJoin(InsuranceApply.class,InsuranceApply::getId,ApplyChange::getApplyId)
			.leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId)
			.leftJoin(Company.class,Company::getId,InsuranceApply::getCompanyId)
			@@ -1461,6 +2005,10 @@
			if(Objects.isNull(solutions)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询方案信息");
			}
			ApplyDetail applyDetail = applyDetailJoinMapper.selectOne(new QueryWrapper<ApplyDetail>().lambda().eq(ApplyDetail::getIsdeleted,Constants.ZERO).eq(ApplyDetail::getApplyId,insuranceApply.getId()).last("limit 1"));
			if(Objects.isNull(applyDetail)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询到保单明细记录");
			}
			//根据批单日期和结束日期计算金额
			//验证批单日期是否在当前日期后且在保单结束日期前申请时间必须处于保单的时间范围内
			if (!(DateUtil.compareDate( insuranceApply.getStartTime(),applyChangeCyclePriceDTO.getValidTime()) >= Constants.ZERO
			@@ -1477,7 +2025,8 @@
			BigDecimal sumPrice = countCyclePriceVO.getCyclePrice();
			CountCyclePriceVO returnCountCyclePriceVO = new CountCyclePriceVO();
			//加减保金额
			returnCountCyclePriceVO.setCyclePrice(sumPrice.divide(new BigDecimal(sumDays),2, RoundingMode.HALF_UP).multiply(new BigDecimal(optDays)));
			// returnCountCyclePriceVO.setCyclePrice(sumPrice.multiply(new BigDecimal(optDays)).divide(new BigDecimal(sumDays),2, RoundingMode.HALF_UP));
			returnCountCyclePriceVO.setCyclePrice(applyDetail.getPrice().multiply(new BigDecimal(optDays)));
			return returnCountCyclePriceVO;
			}

			@@ -1504,4 +2053,169 @@
			return sumPrice.divide(new BigDecimal(sumDays),2, RoundingMode.HALF_UP).multiply(new BigDecimal(optDays));
			}

			public ApplyChange queryApplyChangeData(Integer applyChangeId){
			ApplyChange model = findDetail(applyChangeId);
			if(Objects.isNull(model) \|\|! Constants.equalsInteger(Constants.ZERO,model.getIsdeleted())){
			throw new BusinessException(ResponseStatus.DATA_EMPTY);
			}
			MPJLambdaWrapper<ApplyChagneDetail> queryWrapper = new MPJLambdaWrapper<>();
			queryWrapper.selectAll(ApplyChagneDetail.class);
			queryWrapper.select("t2.name",ApplyChagneDetail::getWorkTypeName);
			queryWrapper.select("t3.name",ApplyChagneDetail::getDuName);
			queryWrapper.select("t4.name",ApplyChagneDetail::getOldWorkTypeName);
			queryWrapper.select("t5.name",ApplyChagneDetail::getOldDuName);
			queryWrapper.selectAs(Member::getName,ApplyChagneDetail::getMemberName);
			queryWrapper.selectAs(Member::getSex,ApplyChagneDetail::getSex);
			queryWrapper.selectAs(Member::getIdcardNo,ApplyChagneDetail::getMemberIdcardNo);
			queryWrapper.leftJoin(Member.class,Member::getId,ApplyChagneDetail::getMemberId);
			queryWrapper.leftJoin(Worktype.class,Worktype::getId,ApplyChagneDetail::getWorktypeId);
			queryWrapper.leftJoin(DispatchUnit.class,DispatchUnit::getId,ApplyChagneDetail::getDuId);
			queryWrapper.leftJoin(Worktype.class,Worktype::getId,ApplyChagneDetail::getOldWorktypeId);
			queryWrapper.leftJoin(DispatchUnit.class,DispatchUnit::getId,ApplyChagneDetail::getOldDuId);
			queryWrapper.eq(ApplyChagneDetail::getApplyChangeId,applyChangeId);
			List<ApplyChagneDetail> list = applyChangeDetailJoinMapper.selectJoinList(ApplyChagneDetail.class, queryWrapper);
			for (ApplyChagneDetail applyChagneDetail:list) {
			applyChagneDetail.setAge(Constants.getAgeByIdCard(applyChagneDetail.getMemberIdcardNo()));
			}
			if(CollectionUtils.isNotEmpty(list)){
			model.setAddDetailList(list.stream().filter(m->m.getType().equals(Constants.ZERO)).collect(Collectors.toList()));
			model.setDelDetailList(list.stream().filter(m->m.getType().equals(Constants.ONE)).collect(Collectors.toList()));
			model.setChangeDetailList(list.stream().filter(m->m.getType().equals(Constants.TWO)).collect(Collectors.toList()));
			}
			return model;
			}

			/**
			* 人员名单签章
			*/
			@Override
			public String getChangeMemberListOnlineSignLink(SmsCheckDTO smsCheckDTO) {
			if(Objects.isNull(smsCheckDTO)
			\|\| Objects.isNull(smsCheckDTO.getBusinessId())
			\|\| StringUtils.isBlank(smsCheckDTO.getCode())
			){
			throw new BusinessException(ResponseStatus.BAD_REQUEST);
			}
			//验证验证码
			if(!debugModel){
			smsEmailService.validateCode(smsCheckDTO.getCode());
			}
			ApplyChange model = this.queryApplyChangeData(smsCheckDTO.getBusinessId());
			if(Objects.isNull(model)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询加减保/换厂信息");
			}
			if(Objects.isNull(model) \|\|! Constants.equalsInteger(Constants.ZERO,model.getIsdeleted())){
			throw new BusinessException(ResponseStatus.DATA_EMPTY);
			}

			LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
			Company company = companyMapper.selectById(model.getCompanyId());
			if(company== null \|\| StringUtils.isBlank( company.getEmail()) \|\| !Constants.equalsInteger(company.getSignStatus(),Constants.THREE)){
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"对不起，企业尚未具备在线签章条件，请联系平台管理员确认~");
			}
			Solutions solutions = solutionsMapper.selectById(model.getSolutionsId());
			if(Objects.isNull(solutions)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询方案信息");
			}
			String fileUrl = null;
			if(solutions.getType().equals(Constants.ONE)){
			if(!Constants.equalsInteger(Constants.ZERO,model.getStatus())){
			throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"对不起，该申请状态已流转，当前不支持签章操作！");
			}
			if(Constants.equalsObject(model.getType(), Constants.ONE)){
			fileUrl = ExcelExporter.build(ApplyChange.class).exportChangeUnitExcelToPdf(model,"换厂申请表","被保险人");
			}else{
			fileUrl = ExcelExporter.build(ApplyChange.class).exportJiajianBaoExcelToPdf(model,"加减保申请表","被保险人");
			}
			String notifyUrl = systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.SIGN_DONE_NOTIFY_URL).getCode();
			notifyUrl = notifyUrl.replace("${type}","0").replace("${id}",model.getId().toString());
			String applyNo = signService.applySignLocalFile(company.getName(),company.getName(),fileUrl,company.getCode(),company.getEmail(),"人员名单签章",company.getSignId(),notifyUrl);
			if(StringUtils.isBlank(applyNo) ){
			throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"对不起，获取在线签章地址失败，请稍后重试！");
			}
			String link = signService.signLink(applyNo,company.getName(),company.getCode());
			if(StringUtils.isBlank(link) ){
			throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"对不起，获取在线签章地址失败，请稍后重试！");
			}
			ApplyChange update= new ApplyChange();
			update.setId(model.getId());
			update.setEditor(user.getId());
			update.setEditDate(new Date());
			update.setSignMemberListNo(applyNo);
			applyChangeMapper.updateById(update);
			return link;
			}else{
			if(model.getType().equals(Constants.ONE)){
			return this.getSignLinkChangeUnit(model);
			}else{
			return this.getSignLinkJiajiabao(model);
			}



			}
			}



			@Override
			@Transactional(rollbackFor = {Exception.class,BusinessException.class})
			public Integer check(ApplyChange applyChange) {
			LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
			if(!user.getType().equals(Constants.TWO)){
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"非商户端无法进行该操作");
			}
			if(applyChange.getId() == null){
			throw new BusinessException(ResponseStatus.BAD_REQUEST);
			}
			ApplyChange model = applyChangeJoinMapper.selectJoinOne(ApplyChange.class,
			new MPJLambdaWrapper<ApplyChange>()
			.selectAll(ApplyChange.class)
			.selectAs(InsuranceApply::getSolutionId,ApplyChange::getSolutionsId)
			.leftJoin(InsuranceApply.class,InsuranceApply::getId,ApplyChange::getApplyId)
			.eq(ApplyChange::getId,applyChange.getId())
			.last(" limit 1")
			);

			if(model == null \|\|!Constants.equalsInteger(model.getIsdeleted(),Constants.ZERO)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY);
			}
			Solutions solutions = solutionsMapper.selectById(model.getSolutionsId());
			if(Objects.isNull(solutions)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询方案信息");
			}
			if(solutions.getType().equals(Constants.ZERO)){
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"直保单据无法进行该操作");
			}else{
			if(!Constants.equalsInteger(model.getStatus(),Constants.ApplyChangeStatus.SIGNATURE.getKey())){
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"对不起，该申请状态已流转，当前不支持该操作~");
			}
			}

			ApplyChange update = new ApplyChange();
			update.setEditDate(new Date());
			update.setEditor(user.getId());
			update.setCheckDate(update.getEditDate());
			update.setCheckInfo(applyChange.getCheckInfo());
			update.setCheckUserId(user.getId());
			update.setId(model.getId());
			if(applyChange.getDealBackApply() ==1){
			//如果是不通过
			update.setStatus(Constants.ApplyChangeStatus.PLATFORM_AGREE.getKey());
			}else{
			update.setStatus(Constants.ApplyChangeStatus.CHECHED_PASSED.getKey());
			}
			applyChangeJoinMapper.updateById(update);
			Constants.NoticeObjectType noticeObjectType = Constants.NoticeObjectType.APPLY_CHANGE;
			if(Constants.equalsInteger(applyChange.getType(),Constants.ONE)){
			noticeObjectType = Constants.NoticeObjectType.CHANGE_FACTORY;
			}
			//删除全部待办
			noticesMapper.delete(new QueryWrapper<Notices>().lambda()
			.eq(Notices::getObjType, noticeObjectType.getKey())
			.eq(Notices::getObjId, model.getId()));
			return 1;

			}

			}