From 6765787baa5e0b771d71f865c4deb776367410c4 Mon Sep 17 00:00:00 2001 From: jiangping <jp@doumee.com> Date: 星期二, 13 八月 2024 13:38:19 +0800 Subject: [PATCH] 修复bug --- server/dmvisit_service/src/main/java/com/doumee/service/business/impl/ParkBookServiceImpl.java | 120 ++++++++++++++++++++++++++++++++++------------------------- 1 files changed, 69 insertions(+), 51 deletions(-) diff --git a/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/ParkBookServiceImpl.java b/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/ParkBookServiceImpl.java index 68da0bc..c12d4e2 100644 --- a/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/ParkBookServiceImpl.java +++ b/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/ParkBookServiceImpl.java @@ -1,31 +1,48 @@ package com.doumee.service.business.impl; +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.Utils; import com.doumee.dao.business.ParkBookMapper; -import com.doumee.dao.business.model.ParkBook; +import com.doumee.dao.business.join.ParkBookJoinMapper; +import com.doumee.dao.business.model.*; import com.doumee.service.business.ParkBookService; 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.doumee.service.business.impl.hksync.HkSyncParkServiceImpl; +import com.github.yulichang.wrapper.MPJLambdaWrapper; +import org.apache.commons.lang3.StringUtils; +import org.apache.shiro.SecurityUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.util.CollectionUtils; +import java.util.Date; import java.util.List; /** * 杞﹁締棰勭害璁板綍淇℃伅琛⊿ervice瀹炵幇 * @author 姹熻箘韫� - * @date 2023/11/23 18:16 + * @date 2023/11/30 15:33 */ @Service public class ParkBookServiceImpl implements ParkBookService { @Autowired private ParkBookMapper parkBookMapper; + @Autowired + private HkSyncParkServiceImpl hkSyncParkService; + + @Autowired + private ParkBookJoinMapper parkBookJoinMapper; + + @Override public Integer create(ParkBook parkBook) { @@ -35,7 +52,15 @@ @Override public void deleteById(Integer id) { - parkBookMapper.deleteById(id); + LoginUserInfo user =(LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); + ParkBook parkBook = new ParkBook(); + parkBook.setIsdeleted(Constants.ZERO); + parkBook.setEditDate(new Date()); + parkBook.setParkId(id); + parkBook.setEditor(user.getId()); + parkBook.setHkStatus(Constants.ZERO); + parkBook.setRemark("寰呭悓姝ュ畨闃插钩鍙�"); + parkBookMapper.updateById(parkBook); } @Override @@ -71,6 +96,22 @@ public ParkBook findById(Integer id) { return parkBookMapper.selectById(id); } + @Override + public void reUpdate(ParkBook param) { + MPJLambdaWrapper<ParkBook> queryWrapper = new MPJLambdaWrapper<>(); + queryWrapper.selectAll(ParkBook.class); + queryWrapper.selectAs(Parks::getHkId,ParkBook::getParkHkId); + queryWrapper.leftJoin(Parks.class,Parks::getId,ParkBook::getParkId); + queryWrapper.selectAs(Device::getHkId,Empower::getDeviceIndexCode); + queryWrapper.eq(ParkBook::getHkStatus,Constants.ZERO) + .eq(ParkBook::getIsdeleted,Constants.ZERO) + .eq(ParkBook::getId,param.getId()); + ParkBook model = parkBookJoinMapper.selectJoinOne(ParkBook.class,queryWrapper); + if(model== null){ + throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"璇ヨ褰曞綋鍓嶄笉鏀寔閲嶆柊涓嬪彂鏉′欢锛�"); + } + hkSyncParkService.syncParkBookBySingleModel(model); + } @Override public ParkBook findOne(ParkBook parkBook) { @@ -87,54 +128,31 @@ @Override public PageData<ParkBook> findPage(PageWrap<ParkBook> pageWrap) { IPage<ParkBook> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); - QueryWrapper<ParkBook> queryWrapper = new QueryWrapper<>(); - Utils.MP.blankToNull(pageWrap.getModel()); - if (pageWrap.getModel().getId() != null) { - queryWrapper.lambda().eq(ParkBook::getId, pageWrap.getModel().getId()); - } - if (pageWrap.getModel().getCreator() != null) { - queryWrapper.lambda().eq(ParkBook::getCreator, pageWrap.getModel().getCreator()); - } - if (pageWrap.getModel().getCreateDate() != null) { - queryWrapper.lambda().ge(ParkBook::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate())); - queryWrapper.lambda().le(ParkBook::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate())); - } - if (pageWrap.getModel().getEdirot() != null) { - queryWrapper.lambda().eq(ParkBook::getEdirot, pageWrap.getModel().getEdirot()); - } - if (pageWrap.getModel().getEditDate() != null) { - queryWrapper.lambda().ge(ParkBook::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate())); - queryWrapper.lambda().le(ParkBook::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate())); - } - if (pageWrap.getModel().getIsdeleted() != null) { - queryWrapper.lambda().eq(ParkBook::getIsdeleted, pageWrap.getModel().getIsdeleted()); - } - if (pageWrap.getModel().getRemark() != null) { - queryWrapper.lambda().eq(ParkBook::getRemark, pageWrap.getModel().getRemark()); - } - if (pageWrap.getModel().getHkId() != null) { - queryWrapper.lambda().eq(ParkBook::getHkId, pageWrap.getModel().getHkId()); - } - if (pageWrap.getModel().getSortnum() != null) { - queryWrapper.lambda().eq(ParkBook::getSortnum, pageWrap.getModel().getSortnum()); - } - if (pageWrap.getModel().getVisitId() != null) { - queryWrapper.lambda().eq(ParkBook::getVisitId, pageWrap.getModel().getVisitId()); - } - if (pageWrap.getModel().getCarCode() != null) { - queryWrapper.lambda().eq(ParkBook::getCarCode, pageWrap.getModel().getCarCode()); - } - if (pageWrap.getModel().getParkId() != null) { - queryWrapper.lambda().eq(ParkBook::getParkId, pageWrap.getModel().getParkId()); - } - for(PageWrap.SortData sortData: pageWrap.getSorts()) { - if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) { - queryWrapper.orderByDesc(sortData.getProperty()); - } else { - queryWrapper.orderByAsc(sortData.getProperty()); - } - } - return PageData.from(parkBookMapper.selectPage(page, queryWrapper)); + MPJLambdaWrapper<ParkBook> queryWrapper = new MPJLambdaWrapper<>(); + + queryWrapper.selectAll(ParkBook.class); + queryWrapper.selectAs(Parks::getName,Cars::getParksName); + queryWrapper.selectAs(Member::getType,Cars::getMemberType); + queryWrapper.selectAs(Member::getName,Cars::getMemberName); + queryWrapper.selectAs(Member::getPhone,Cars::getMemberPhone); + queryWrapper.selectAs(Company::getName,Cars::getCompanyName); + + queryWrapper.leftJoin(Parks.class,Parks::getId,ParkBook::getParkId); + queryWrapper.leftJoin(Member.class,Member::getId,ParkBook::getMemberId); + queryWrapper.leftJoin(Company.class,Company::getId,Member::getCompanyId); + + queryWrapper +// .eq(ParkBook::getIsdeleted, Constants.ZERO) + .and(StringUtils.isNotBlank(pageWrap.getModel().getMemberName()), ms->ms.like(Member::getPhone,pageWrap.getModel().getMemberName()) + .or().like(Member::getName,pageWrap.getModel().getMemberName())); + queryWrapper.like(StringUtils.isNotBlank(pageWrap.getModel().getCarCode()),ParkBook::getCarCode,pageWrap.getModel().getCarCode()); + queryWrapper.like(StringUtils.isNotBlank(pageWrap.getModel().getCompanyName()),Company::getName,pageWrap.getModel().getCompanyName()); + queryWrapper.like(StringUtils.isNotBlank(pageWrap.getModel().getParksName()),Parks::getName,pageWrap.getModel().getParksName()); + queryWrapper.orderByDesc(ParkBook::getCreateDate); + + IPage<ParkBook> result = parkBookJoinMapper.selectJoinPage(page, ParkBook.class,queryWrapper); + + return PageData.from(result); } @Override -- Gitblit v1.9.3