From 04a319eb80c1556af1aa726b6b89a882b14641e0 Mon Sep 17 00:00:00 2001 From: jiangping <jp@doumee.com> Date: 星期三, 11 十月 2023 15:15:01 +0800 Subject: [PATCH] 接口整理 --- server/services/src/main/java/com/doumee/service/business/impl/BikesServiceImpl.java | 28 +++++++++++++++++++++++++++- 1 files changed, 27 insertions(+), 1 deletions(-) diff --git a/server/services/src/main/java/com/doumee/service/business/impl/BikesServiceImpl.java b/server/services/src/main/java/com/doumee/service/business/impl/BikesServiceImpl.java index dd8115f..547c405 100644 --- a/server/services/src/main/java/com/doumee/service/business/impl/BikesServiceImpl.java +++ b/server/services/src/main/java/com/doumee/service/business/impl/BikesServiceImpl.java @@ -1,15 +1,21 @@ package com.doumee.service.business.impl; +import com.doumee.core.constants.Constants; import com.doumee.core.model.PageData; import com.doumee.core.model.PageWrap; import com.doumee.core.utils.Utils; import com.doumee.dao.business.BikesMapper; -import com.doumee.dao.business.model.Bikes; +import com.doumee.dao.business.join.BikesJoinMapper; +import com.doumee.dao.business.model.*; +import com.doumee.dao.business.web.response.BikeLogDTO; +import com.doumee.dao.business.web.response.MemberRidesDTO; import com.doumee.service.business.BikesService; 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.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.util.CollectionUtils; @@ -26,6 +32,8 @@ @Autowired private BikesMapper bikesMapper; + @Autowired + private BikesJoinMapper bikesJoinMapper; @Override public String create(Bikes bikes) { @@ -85,6 +93,24 @@ } @Override + public PageData<Bikes> findJoinPage(PageWrap<Bikes> pageWrap) { + IPage<Bikes> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); + MPJLambdaWrapper<Bikes> queryWrapper = new MPJLambdaWrapper<>(); + Utils.MP.blankToNull(pageWrap.getModel()); + queryWrapper.orderByAsc(Bikes::getSiteId,Bikes::getLockId); + queryWrapper.leftJoin(BaseParam.class,BaseParam::getId,Bikes::getParamId) + .leftJoin(Sites.class,Sites::getId,Bikes::getSiteId) + .like(StringUtils.isNotBlank(pageWrap.getModel().getSiteId()),Bikes::getSiteId,pageWrap.getModel().getSiteId()) + .like(StringUtils.isNotBlank(pageWrap.getModel().getSiteName()), Sites::getName,pageWrap.getModel().getSiteName()) + .like(StringUtils.isNotBlank(pageWrap.getModel().getLockId()),Bikes::getLockId,pageWrap.getModel().getLockId()) + .isNull(Constants.formatIntegerNum(pageWrap.getModel().getHasBike()) == Constants.ONE,Bikes::getCode) + .isNotNull(Constants.formatIntegerNum(pageWrap.getModel().getHasBike()) == Constants.TWO,Bikes::getCode); + queryWrapper.selectAll(Bikes.class) + .selectAs(BaseParam::getName,Bikes::getParamName) + .selectAs(Sites::getName,Bikes::getSiteName) ; + return PageData.from(bikesJoinMapper.selectJoinPage(page, Bikes.class, queryWrapper)); + } + @Override public PageData<Bikes> findPage(PageWrap<Bikes> pageWrap) { IPage<Bikes> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); QueryWrapper<Bikes> queryWrapper = new QueryWrapper<>(); -- Gitblit v1.9.3