package com.doumee.service.business.impl; import cn.hutool.core.lang.PatternPool; import cn.hutool.core.lang.Validator; import cn.hutool.core.util.ReUtil; import com.doumee.core.haikang.model.HKConstants; import com.doumee.core.model.PageData; import com.doumee.core.model.PageWrap; import com.doumee.core.utils.Constants; import com.doumee.core.utils.Utils; import com.doumee.dao.admin.response.CarEventDTO; import com.doumee.dao.business.MemberCardMapper; import com.doumee.dao.business.join.MemberCardJoinMapper; import com.doumee.dao.business.model.Company; import com.doumee.dao.business.model.Member; import com.doumee.dao.business.model.MemberCard; import com.doumee.dao.business.model.Retention; import com.doumee.dao.system.model.SystemDictData; import com.doumee.service.business.MemberCardService; 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.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.util.CollectionUtils; import java.util.*; import java.util.function.Function; import java.util.stream.Collectors; /** * 用户卡片绑定信息表Service实现 * @author 江蹄蹄 * @date 2023/11/30 15:33 */ @Service public class MemberCardServiceImpl implements MemberCardService { @Autowired private MemberCardMapper memberCardMapper; @Autowired private MemberCardJoinMapper memberCardJoinMapper; @Override public Integer create(MemberCard memberCard) { memberCardMapper.insert(memberCard); return memberCard.getId(); } @Override public void deleteById(Integer id) { memberCardMapper.deleteById(id); } @Override public void delete(MemberCard memberCard) { UpdateWrapper deleteWrapper = new UpdateWrapper<>(memberCard); memberCardMapper.delete(deleteWrapper); } @Override public void deleteByIdInBatch(List ids) { if (CollectionUtils.isEmpty(ids)) { return; } memberCardMapper.deleteBatchIds(ids); } @Override public void updateById(MemberCard memberCard) { memberCardMapper.updateById(memberCard); } @Override public void updateByIdInBatch(List memberCards) { if (CollectionUtils.isEmpty(memberCards)) { return; } for (MemberCard memberCard: memberCards) { this.updateById(memberCard); } } public void updateRefundCard(MemberCard memberCard) { int i = memberCardMapper.updateById(memberCard); // 调用service 同步更新海康那边的对应卡状态,也改为退卡 if(i > 0){ } } @Override public MemberCard findById(Integer id) { return memberCardMapper.selectById(id); } @Override public MemberCard findOne(MemberCard memberCard) { QueryWrapper wrapper = new QueryWrapper<>(memberCard); return memberCardMapper.selectOne(wrapper); } @Override public List findList(MemberCard memberCard) { QueryWrapper wrapper = new QueryWrapper<>(memberCard); wrapper.lambda().eq(MemberCard::getIsdeleted, Constants.ZERO); wrapper.lambda().eq(MemberCard::getHkStatus, Constants.ONE); // 启用和退卡的卡号 wrapper.lambda().and(param -> param.eq(MemberCard::getStatus,Constants.ZERO). or().eq(MemberCard::getStatus,Constants.TWO)); return memberCardMapper.selectList(wrapper); } @Override public PageData findPage(PageWrap pageWrap) { IPage page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); MPJLambdaWrapper queryWrapper = new MPJLambdaWrapper<>(); Utils.MP.blankToNull(pageWrap.getModel()); if (pageWrap.getModel().getId() != null) { queryWrapper.eq(MemberCard::getId, pageWrap.getModel().getId()); } if (pageWrap.getModel().getCreator() != null) { queryWrapper.eq(MemberCard::getCreator, pageWrap.getModel().getCreator()); } if (pageWrap.getModel().getCreateDate() != null) { queryWrapper.ge(MemberCard::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate())); queryWrapper.le(MemberCard::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate())); } if (pageWrap.getModel().getEditor() != null) { queryWrapper.eq(MemberCard::getEditor, pageWrap.getModel().getEditor()); } if (pageWrap.getModel().getEditDate() != null) { queryWrapper.ge(MemberCard::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate())); queryWrapper.le(MemberCard::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate())); } if (pageWrap.getModel().getIsdeleted() != null) { queryWrapper.eq(MemberCard::getIsdeleted, pageWrap.getModel().getIsdeleted()); } if (pageWrap.getModel().getRemark() != null) { queryWrapper.eq(MemberCard::getRemark, pageWrap.getModel().getRemark()); } if (pageWrap.getModel().getMemberId() != null) { queryWrapper.eq(MemberCard::getMemberId, pageWrap.getModel().getMemberId()); } if (pageWrap.getModel().getCode() != null) { queryWrapper.eq(MemberCard::getCode, pageWrap.getModel().getCode()); } if (pageWrap.getModel().getPassward() != null) { queryWrapper.eq(MemberCard::getPassward, pageWrap.getModel().getPassward()); } if (pageWrap.getModel().getHkId() != null) { queryWrapper.eq(MemberCard::getHkId, pageWrap.getModel().getHkId()); } if (pageWrap.getModel().getHkStatus() != null) { queryWrapper.eq(MemberCard::getHkStatus, pageWrap.getModel().getHkStatus()); } if (pageWrap.getModel().getHkDate() != null) { queryWrapper.ge(MemberCard::getHkDate, Utils.Date.getStart(pageWrap.getModel().getHkDate())); queryWrapper.le(MemberCard::getHkDate, Utils.Date.getEnd(pageWrap.getModel().getHkDate())); } if (pageWrap.getModel().getStatus() != null) { queryWrapper.eq(MemberCard::getStatus, pageWrap.getModel().getStatus()); } queryWrapper.orderByDesc(MemberCard::getCreateDate); //是否是数字 boolean number = Validator.isNumber(pageWrap.getModel().getKeyWords()); //是否包含中文 boolean b = Validator.hasChinese(pageWrap.getModel().getKeyWords()); //是否包含英文 boolean hasWord = ReUtil.contains(PatternPool.WORD, pageWrap.getModel().getKeyWords()); queryWrapper.leftJoin(Member.class,Member::getId,MemberCard::getMemberId) .leftJoin(Company.class,Company::getId,Member::getCompanyId); queryWrapper.selectAll(MemberCard.class) .selectAs(Member::getName,MemberCard::getMemberName) .selectAs(Member::getPhone,MemberCard::getMemberPhone) .selectAs(Company::getName,MemberCard::getCompanyName); queryWrapper.like(Objects.nonNull(pageWrap.getModel().getCode()),MemberCard::getCode,pageWrap.getModel().getCode()) .eq(Objects.nonNull(pageWrap.getModel().getStatus()),MemberCard::getStatus,pageWrap.getModel().getStatus()) .eq(Objects.nonNull(pageWrap.getModel().getStatus()),MemberCard::getStatus,pageWrap.getModel().getStatus()) .like(number,Member::getPhone,pageWrap.getModel().getKeyWords()) .like((b||hasWord),Member::getName,pageWrap.getModel().getKeyWords()); IPage memberCardIPage = memberCardJoinMapper.selectJoinPage(page, MemberCard.class,queryWrapper); if(null != memberCardIPage && memberCardIPage.getRecords().size() > 0) { memberCardIPage.setRecords(getDataPackage(memberCardIPage)); } return PageData.from(memberCardIPage); } @Override public long count(MemberCard memberCard) { QueryWrapper wrapper = new QueryWrapper<>(memberCard); return memberCardMapper.selectCount(wrapper); } private List getDataPackage(IPage memberCardIPage) { List newDataList = new ArrayList<>(); memberCardIPage.getRecords().stream().forEach(obj->{ if(null != obj.getType()) { if(Constants.equalsInteger(obj.getCardType(),Constants.ZERO)) { obj.setTypeName(Constants.Status.LW_FK.getDes()); }else if(Constants.equalsInteger(obj.getCardType(),Constants.ONE)){ obj.setTypeName(Constants.Status.PT_FK.getDes()); }else if(Constants.equalsInteger(obj.getCardType(),Constants.TWO)){ obj.setTypeName(Constants.Status.NB_FK.getDes()); } } if(null != obj.getCardType()) { if(Constants.equalsInteger(obj.getCardType(),Constants.ZERO)) { obj.setCardTypeName(HKConstants.CardStatus.DISABLE.getName()); }else if(Constants.equalsInteger(obj.getCardType(),Constants.ONE)) { obj.setCardTypeName(HKConstants.CardStatus.ENABLE.getName()); }else if(Constants.equalsInteger(obj.getCardType(),Constants.TWO)) { obj.setCardTypeName(HKConstants.CardStatus.REFUNDCARD.getName()); }else if(Constants.equalsInteger(obj.getCardType(),Constants.THREE)) { obj.setCardTypeName(HKConstants.CardStatus.LOSS.getName()); } } if(null != obj.getStatus()) { if(Constants.equalsInteger(obj.getCardType(),Constants.ONE)) { obj.setCardTypeName(HKConstants.CardStatus.IC.getName()); }else if(Constants.equalsInteger(obj.getCardType(),Constants.TWO)) { obj.setCardTypeName(HKConstants.CardStatus.CPU.getName()); }else if(Constants.equalsInteger(obj.getCardType(),Constants.THREE)) { obj.setCardTypeName(HKConstants.CardStatus.YJLCARD.getName()); }else if(Constants.equalsInteger(obj.getCardType(),Constants.FOUR)) { obj.setCardTypeName(HKConstants.CardStatus.MCARD.getName()); } } newDataList.add(obj); }); return newDataList; } }