|  |  | 
 |  |  | package com.doumee.service.business.impl; | 
 |  |  |  | 
 |  |  | import cn.emay.sdk.util.StringUtil; | 
 |  |  | import cn.hutool.core.util.IdcardUtil; | 
 |  |  | import cn.hutool.core.util.PhoneUtil; | 
 |  |  | import com.doumee.core.constants.ResponseStatus; | 
 |  |  | import com.doumee.core.exception.BusinessException; | 
 |  |  | import com.doumee.core.model.LoginUserInfo; | 
 |  |  | import com.doumee.core.model.PageData; | 
 |  |  | import com.doumee.core.model.PageWrap; | 
 |  |  | import com.doumee.core.utils.Constants; | 
 |  |  | import com.doumee.core.utils.DESUtil; | 
 |  |  | import com.doumee.core.utils.Utils; | 
 |  |  | import com.doumee.dao.business.MemberMapper; | 
 |  |  | import com.doumee.dao.business.YwCustomerMapper; | 
 |  |  | import com.doumee.dao.business.model.Member; | 
 |  |  | import com.doumee.dao.business.model.YwCustomer; | 
 |  |  | import com.doumee.service.business.YwCustomerService; | 
 |  |  | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; | 
 |  |  | 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.github.yulichang.wrapper.MPJLambdaWrapper; | 
 |  |  | import org.apache.commons.lang3.StringUtils; | 
 |  |  | import org.checkerframework.checker.units.qual.A; | 
 |  |  | 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.util.Date; | 
 |  |  | import java.util.List; | 
 |  |  | import java.util.Objects; | 
 |  |  |  | 
 |  |  | /** | 
 |  |  |  * 运维客户信息表Service实现 | 
 |  |  | 
 |  |  |     @Autowired | 
 |  |  |     private YwCustomerMapper ywCustomerMapper; | 
 |  |  |  | 
 |  |  |     @Autowired | 
 |  |  |     private MemberMapper memberMapper; | 
 |  |  |  | 
 |  |  |     @Override | 
 |  |  |     @Transactional(rollbackFor = {BusinessException.class,Exception.class}) | 
 |  |  |     public Integer create(YwCustomer ywCustomer) { | 
 |  |  |         if(Objects.isNull(ywCustomer) | 
 |  |  |             || Objects.isNull(ywCustomer.getType()) | 
 |  |  |             || StringUtils.isBlank(ywCustomer.getName()) | 
 |  |  |             || Objects.isNull(ywCustomer.getMember()) | 
 |  |  |             || StringUtils.isBlank(ywCustomer.getMember().getName()) | 
 |  |  |             || StringUtils.isBlank(ywCustomer.getMember().getPhone()) | 
 |  |  |             || Objects.isNull(ywCustomer.getMember().getHighCheckor()) | 
 |  |  |             || Objects.isNull(ywCustomer.getMember().getIdcardType()) | 
 |  |  |         ){ | 
 |  |  |             throw new BusinessException(ResponseStatus.BAD_REQUEST); | 
 |  |  |         } | 
 |  |  |         LoginUserInfo loginUserInfo = ywCustomer.getLoginUserInfo(); | 
 |  |  |         ywCustomer.setStatus(Constants.ZERO); | 
 |  |  |         ywCustomer.setIsdeleted(Constants.ZERO); | 
 |  |  |         ywCustomer.setCreator(loginUserInfo.getId()); | 
 |  |  |         ywCustomer.setCreateDate(new Date()); | 
 |  |  |         ywCustomerMapper.insert(ywCustomer); | 
 |  |  |  | 
 |  |  |         Member member = ywCustomer.getMember(); | 
 |  |  |         member.setCreator(loginUserInfo.getId()); | 
 |  |  |         member.setCreateDate(new Date()); | 
 |  |  |         member.setIsdeleted(Constants.ZERO); | 
 |  |  |         member.setStatus(Constants.ZERO); | 
 |  |  |         member.setType(Constants.memberType.customer); | 
 |  |  |         member.setCustomerId(ywCustomer.getId()); | 
 |  |  |         this.checkMember(member); | 
 |  |  |         memberMapper.insert(member); | 
 |  |  |  | 
 |  |  |         ywCustomer.setMemberId(member.getId()); | 
 |  |  |         ywCustomerMapper.updateById(ywCustomer); | 
 |  |  |  | 
 |  |  |         return ywCustomer.getId(); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |  | 
 |  |  |     public void checkMember(Member member){ | 
 |  |  |         if (StringUtils.isBlank(member.getPhone())||!PhoneUtil.isPhone(member.getPhone())){ | 
 |  |  |             throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"电话号码格式有误"); | 
 |  |  |         } | 
 |  |  |         if (StringUtils.isNotBlank(member.getIdcardNo()) && Constants.equalsInteger(member.getIdcardType(),Constants.ZERO)  && !IdcardUtil.isValidCard(member.getIdcardNo())){ | 
 |  |  |             throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"身份证号格式有误"); | 
 |  |  |         } | 
 |  |  |         if(StringUtils.isNotBlank(member.getIdcardNo() ) && Constants.equalsInteger(member.getIdcardType(),Constants.ZERO) ){ | 
 |  |  |             if(memberMapper.selectCount(new QueryWrapper<Member>().lambda() | 
 |  |  |                     .eq(Member::getIdcardNo, DESUtil.encrypt(Constants.EDS_PWD, member.getIdcardNo())) | 
 |  |  |                     .eq(Member::getIsdeleted,Constants.ZERO)) >0){ | 
 |  |  |                 throw new BusinessException(ResponseStatus.DATA_EXISTS.getCode(), "身份证号【"+member.getIdcardNo()+"】已被使用,不能重复"); | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  |         if(memberMapper.selectCount(new QueryWrapper<Member>().lambda() | 
 |  |  |                 .eq(Member::getPhone,  member.getPhone()) | 
 |  |  |                 .eq(Member::getIsdeleted,Constants.ZERO) ) >0){ | 
 |  |  |             throw new BusinessException(ResponseStatus.DATA_EXISTS.getCode(), "手机号【"+member.getPhone()+"】已被使用,不能重复"); | 
 |  |  |         } | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |  | 
 |  |  |     @Override | 
 |  |  |     public void deleteById(Integer id, LoginUserInfo user) { | 
 |  |  |  | 
 |  |  |         //查询客户信息下是否存在人员信息 | 
 |  |  |         if(memberMapper.selectCount(new QueryWrapper<Member>().lambda().eq(Member::getType,Constants.memberType.customer) | 
 |  |  |                         .eq(Member::getCustomerId,id) | 
 |  |  |                 .eq(Member::getIsdeleted,Constants.ZERO))>Constants.ZERO){ | 
 |  |  |             throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"存在人员信息未删除,请先删除客户下人员信息!"); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         ywCustomerMapper.deleteById(id); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  | 
 |  |  |         if (CollectionUtils.isEmpty(ids)) { | 
 |  |  |             return; | 
 |  |  |         } | 
 |  |  |         if(memberMapper.selectCount(new QueryWrapper<Member>().lambda().eq(Member::getType,Constants.memberType.customer) | 
 |  |  |                 .in(Member::getCustomerId,ids) | 
 |  |  |                 .eq(Member::getIsdeleted,Constants.ZERO))>Constants.ZERO){ | 
 |  |  |             throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"存在人员信息未删除,请先删除客户下人员信息!"); | 
 |  |  |         } | 
 |  |  |         ywCustomerMapper.deleteBatchIds(ids); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     @Override | 
 |  |  |     public void updateById(YwCustomer ywCustomer) { | 
 |  |  |         if(Objects.isNull(ywCustomer) | 
 |  |  |                 || Objects.isNull(ywCustomer.getType()) | 
 |  |  |                 || StringUtils.isBlank(ywCustomer.getName()) | 
 |  |  |                 || Objects.isNull(ywCustomer.getMemberId()) | 
 |  |  |         ){ | 
 |  |  |             throw new BusinessException(ResponseStatus.BAD_REQUEST); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         LoginUserInfo loginUserInfo = ywCustomer.getLoginUserInfo(); | 
 |  |  |         ywCustomer.setEditor(loginUserInfo.getId()); | 
 |  |  |         ywCustomer.setEditDate(new Date()); | 
 |  |  |         ywCustomerMapper.updateById(ywCustomer); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     @Override | 
 |  |  |     public YwCustomer getDetail(Integer id) { | 
 |  |  |         YwCustomer ywCustomer = ywCustomerMapper.selectById(id); | 
 |  |  |         if(Objects.isNull(ywCustomer)){ | 
 |  |  |             throw new BusinessException(ResponseStatus.DATA_EMPTY); | 
 |  |  |         } | 
 |  |  |         Member member = memberMapper.selectById(ywCustomer.getMemberId()); | 
 |  |  |         if(Objects.nonNull(member)){ | 
 |  |  |             ywCustomer.setMember(member); | 
 |  |  |         } | 
 |  |  |         return ywCustomer; | 
 |  |  |     } | 
 |  |  |     @Override | 
 |  |  |     public YwCustomer findOne(YwCustomer ywCustomer) { | 
 |  |  |         QueryWrapper<YwCustomer> wrapper = new QueryWrapper<>(ywCustomer); | 
 |  |  |         return ywCustomerMapper.selectOne(wrapper); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     @Override | 
 |  |  |     public List<YwCustomer> findList(YwCustomer ywCustomer) { | 
 |  |  |         QueryWrapper<YwCustomer> wrapper = new QueryWrapper<>(ywCustomer); | 
 |  |  |         return ywCustomerMapper.selectList(wrapper); | 
 |  |  |     public List<YwCustomer> findList(YwCustomer model) { | 
 |  |  |         return ywCustomerMapper.selectJoinList(YwCustomer.class, | 
 |  |  |                 new MPJLambdaWrapper<YwCustomer>() | 
 |  |  |                         .selectAll(YwCustomer.class) | 
 |  |  |                         .selectAs(Member::getName,YwCustomer::getMemberName) | 
 |  |  |                         .selectAs(Member::getPhone,YwCustomer::getMemberPhone) | 
 |  |  |                         .leftJoin(Member.class,Member::getId,YwCustomer::getMemberId) | 
 |  |  |                         .eq(YwCustomer::getIsdeleted,Constants.ZERO) | 
 |  |  |                         .like(Objects.nonNull(model)&&StringUtils.isNotBlank(model.getName()),YwCustomer::getName,model.getName()) | 
 |  |  |                         .orderByDesc(YwCustomer::getCreateDate)) ; | 
 |  |  |     } | 
 |  |  |    | 
 |  |  |     @Override | 
 |  |  |     public PageData<YwCustomer> findPage(PageWrap<YwCustomer> pageWrap) { | 
 |  |  |         IPage<YwCustomer> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); | 
 |  |  |         QueryWrapper<YwCustomer> queryWrapper = new QueryWrapper<>(); | 
 |  |  |         MPJLambdaWrapper<YwCustomer> queryWrapper = new MPJLambdaWrapper<>(); | 
 |  |  |         Utils.MP.blankToNull(pageWrap.getModel()); | 
 |  |  |         if (pageWrap.getModel().getId() != null) { | 
 |  |  |             queryWrapper.lambda().eq(YwCustomer::getId, pageWrap.getModel().getId()); | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getCreator() != null) { | 
 |  |  |             queryWrapper.lambda().eq(YwCustomer::getCreator, pageWrap.getModel().getCreator()); | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getCreateDate() != null) { | 
 |  |  |             queryWrapper.lambda().ge(YwCustomer::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate())); | 
 |  |  |             queryWrapper.lambda().le(YwCustomer::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate())); | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getEditor() != null) { | 
 |  |  |             queryWrapper.lambda().eq(YwCustomer::getEditor, pageWrap.getModel().getEditor()); | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getEditDate() != null) { | 
 |  |  |             queryWrapper.lambda().ge(YwCustomer::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate())); | 
 |  |  |             queryWrapper.lambda().le(YwCustomer::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate())); | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getIsdeleted() != null) { | 
 |  |  |             queryWrapper.lambda().eq(YwCustomer::getIsdeleted, pageWrap.getModel().getIsdeleted()); | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getRemark() != null) { | 
 |  |  |             queryWrapper.lambda().eq(YwCustomer::getRemark, pageWrap.getModel().getRemark()); | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getIndustryId() != null) { | 
 |  |  |             queryWrapper.lambda().eq(YwCustomer::getIndustryId, pageWrap.getModel().getIndustryId()); | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getType() != null) { | 
 |  |  |             queryWrapper.lambda().eq(YwCustomer::getType, pageWrap.getModel().getType()); | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getName() != null) { | 
 |  |  |             queryWrapper.lambda().eq(YwCustomer::getName, pageWrap.getModel().getName()); | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getPhone() != null) { | 
 |  |  |             queryWrapper.lambda().eq(YwCustomer::getPhone, pageWrap.getModel().getPhone()); | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getIdcardNo() != null) { | 
 |  |  |             queryWrapper.lambda().eq(YwCustomer::getIdcardNo, pageWrap.getModel().getIdcardNo()); | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getIdcardDecode() != null) { | 
 |  |  |             queryWrapper.lambda().eq(YwCustomer::getIdcardDecode, pageWrap.getModel().getIdcardDecode()); | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getCode() != null) { | 
 |  |  |             queryWrapper.lambda().eq(YwCustomer::getCode, pageWrap.getModel().getCode()); | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getStatus() != null) { | 
 |  |  |             queryWrapper.lambda().eq(YwCustomer::getStatus, pageWrap.getModel().getStatus()); | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getHighCheckor() != null) { | 
 |  |  |             queryWrapper.lambda().eq(YwCustomer::getHighCheckor, pageWrap.getModel().getHighCheckor()); | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getLastLoginDate() != null) { | 
 |  |  |             queryWrapper.lambda().ge(YwCustomer::getLastLoginDate, Utils.Date.getStart(pageWrap.getModel().getLastLoginDate())); | 
 |  |  |             queryWrapper.lambda().le(YwCustomer::getLastLoginDate, Utils.Date.getEnd(pageWrap.getModel().getLastLoginDate())); | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getLoginNum() != null) { | 
 |  |  |             queryWrapper.lambda().eq(YwCustomer::getLoginNum, pageWrap.getModel().getLoginNum()); | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getUserId() != null) { | 
 |  |  |             queryWrapper.lambda().eq(YwCustomer::getUserId, pageWrap.getModel().getUserId()); | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getIdcardType() != null) { | 
 |  |  |             queryWrapper.lambda().eq(YwCustomer::getIdcardType, pageWrap.getModel().getIdcardType()); | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getAccountBank() != null) { | 
 |  |  |             queryWrapper.lambda().eq(YwCustomer::getAccountBank, pageWrap.getModel().getAccountBank()); | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getAccountNo() != null) { | 
 |  |  |             queryWrapper.lambda().eq(YwCustomer::getAccountNo, pageWrap.getModel().getAccountNo()); | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getAccountPhone() != null) { | 
 |  |  |             queryWrapper.lambda().eq(YwCustomer::getAccountPhone, pageWrap.getModel().getAccountPhone()); | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getCreditCard() != null) { | 
 |  |  |             queryWrapper.lambda().eq(YwCustomer::getCreditCard, pageWrap.getModel().getCreditCard()); | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getFpType() != null) { | 
 |  |  |             queryWrapper.lambda().eq(YwCustomer::getFpType, pageWrap.getModel().getFpType()); | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getAccountAddr() != null) { | 
 |  |  |             queryWrapper.lambda().eq(YwCustomer::getAccountAddr, pageWrap.getModel().getAccountAddr()); | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getIdentityType() != null) { | 
 |  |  |             queryWrapper.lambda().eq(YwCustomer::getIdentityType, pageWrap.getModel().getIdentityType()); | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getEmail() != null) { | 
 |  |  |             queryWrapper.lambda().eq(YwCustomer::getEmail, pageWrap.getModel().getEmail()); | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getMemberId() != null) { | 
 |  |  |             queryWrapper.lambda().eq(YwCustomer::getMemberId, pageWrap.getModel().getMemberId()); | 
 |  |  |         } | 
 |  |  |         for(PageWrap.SortData sortData: pageWrap.getSorts()) { | 
 |  |  |             if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) { | 
 |  |  |                 queryWrapper.orderByDesc(sortData.getProperty()); | 
 |  |  |             } else { | 
 |  |  |                 queryWrapper.orderByAsc(sortData.getProperty()); | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  |         return PageData.from(ywCustomerMapper.selectPage(page, queryWrapper)); | 
 |  |  |         YwCustomer model = pageWrap.getModel(); | 
 |  |  |         IPage iPage = ywCustomerMapper.selectJoinPage(page,YwCustomer.class, | 
 |  |  |                 queryWrapper | 
 |  |  |                 .selectAll(YwCustomer.class) | 
 |  |  |                 .selectAs(Member::getName,YwCustomer::getMemberName) | 
 |  |  |                 .selectAs(Member::getPhone,YwCustomer::getMemberPhone) | 
 |  |  |                 .leftJoin(Member.class,Member::getId,YwCustomer::getMemberId) | 
 |  |  |                 .eq(YwCustomer::getIsdeleted,Constants.ZERO) | 
 |  |  |                 .like(Objects.nonNull(model)&&StringUtils.isNotBlank(model.getName()),YwCustomer::getName,model.getName()) | 
 |  |  |                 .orderByDesc(YwCustomer::getCreateDate) | 
 |  |  |         ); | 
 |  |  |         return PageData.from(iPage); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     @Override |