|  |  | 
 |  |  | package com.doumee.service.business.impl; | 
 |  |  |  | 
 |  |  | import com.doumee.biz.system.SystemDictDataBiz; | 
 |  |  | import com.doumee.core.constants.Constants; | 
 |  |  | import com.doumee.core.model.PageData; | 
 |  |  | import com.doumee.core.model.PageWrap; | 
 |  |  | 
 |  |  | 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.dao.business.web.response.MiniProgrammeDTO; | 
 |  |  | import com.doumee.dao.system.SystemDictDataMapper; | 
 |  |  | import com.doumee.dao.system.model.SystemDictData; | 
 |  |  | 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.doumee.service.system.SystemDictDataService; | 
 |  |  | 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; | 
 |  |  |  | 
 |  |  | import java.util.Arrays; | 
 |  |  | import java.util.List; | 
 |  |  | import java.util.Map; | 
 |  |  | import java.util.stream.Collectors; | 
 |  |  |  | 
 |  |  | /** | 
 |  |  |  * 自行车信息表Service实现 | 
 |  |  | 
 |  |  |     private BikesMapper bikesMapper; | 
 |  |  |     @Autowired | 
 |  |  |     private BikesJoinMapper bikesJoinMapper; | 
 |  |  |  | 
 |  |  |  | 
 |  |  |     @Autowired | 
 |  |  |     SystemDictDataMapper systemDictDataMapper; | 
 |  |  |  | 
 |  |  |     @Override | 
 |  |  |     public String create(Bikes bikes) { | 
 |  |  | 
 |  |  |         QueryWrapper<Bikes> wrapper = new QueryWrapper<>(bikes); | 
 |  |  |         return bikesMapper.selectList(wrapper); | 
 |  |  |     } | 
 |  |  |    | 
 |  |  |  | 
 |  |  |     @Override | 
 |  |  |     public PageData<Bikes> findJoinPage(PageWrap<Bikes> pageWrap) { | 
 |  |  |  | 
 |  |  |         QueryWrapper<SystemDictData> wrapper = new QueryWrapper<>(); | 
 |  |  |         wrapper.lambda() | 
 |  |  |                 .in(SystemDictData::getLabel, Arrays.asList(Constants.FORCE_BACK_SITE,Constants.FORCE_BACK_LOCK)); | 
 |  |  |         List<SystemDictData> systemDictData = systemDictDataMapper.selectList(wrapper); | 
 |  |  |         Map<String, SystemDictData> collect = systemDictData.stream().collect(Collectors.toMap(s -> s.getLabel(), s -> s)); | 
 |  |  |  | 
 |  |  |         IPage<Bikes> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); | 
 |  |  |         MPJLambdaWrapper<Bikes> queryWrapper = new MPJLambdaWrapper<>(); | 
 |  |  |         Utils.MP.blankToNull(pageWrap.getModel()); | 
 |  |  | 
 |  |  |                 .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); | 
 |  |  |                 .eq( pageWrap.getModel().getLockId() !=null,Bikes::getLockId,pageWrap.getModel().getLockId()) | 
 |  |  |                 .ne(Bikes::getLockId,Constants.formatIntegerFromStr(collect.get(Constants.FORCE_BACK_LOCK).getCode())) | 
 |  |  |                 .ne(Bikes::getSiteId,collect.get(Constants.FORCE_BACK_SITE).getCode()) | 
 |  |  |                 .and(Constants.formatIntegerNum(pageWrap.getModel().getHasBike()) == Constants.ONE, | 
 |  |  |                         s->s.isNull(Bikes::getCode) | 
 |  |  |                                 .or(b->b.eq(Bikes::getCode,""))) | 
 |  |  |                 .and(Constants.formatIntegerNum(pageWrap.getModel().getHasBike()) == Constants.TWO,s->s | 
 |  |  |                 .isNotNull(Bikes::getCode) | 
 |  |  |                 .and(b->b.ne(Bikes::getCode,""))); | 
 |  |  |         queryWrapper.selectAll(Bikes.class) | 
 |  |  |                 .selectAs(BaseParam::getName,Bikes::getParamName) | 
 |  |  |                 .selectAs(Sites::getName,Bikes::getSiteName) ; | 
 |  |  | 
 |  |  |         if (pageWrap.getModel().getLockId() != null) { | 
 |  |  |             queryWrapper.lambda().eq(Bikes::getLockId, pageWrap.getModel().getLockId()); | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getLastRentData() != null) { | 
 |  |  |             queryWrapper.lambda().ge(Bikes::getLastRentData, Utils.Date.getStart(pageWrap.getModel().getLastRentData())); | 
 |  |  |             queryWrapper.lambda().le(Bikes::getLastRentData, Utils.Date.getEnd(pageWrap.getModel().getLastRentData())); | 
 |  |  |         if (pageWrap.getModel().getLastRentDate() != null) { | 
 |  |  |             queryWrapper.lambda().ge(Bikes::getLastRentDate, Utils.Date.getStart(pageWrap.getModel().getLastRentDate())); | 
 |  |  |             queryWrapper.lambda().le(Bikes::getLastRentDate, Utils.Date.getEnd(pageWrap.getModel().getLastRentDate())); | 
 |  |  |         } | 
 |  |  |         if (pageWrap.getModel().getSoldoutDate() != null) { | 
 |  |  |             queryWrapper.lambda().ge(Bikes::getSoldoutDate, Utils.Date.getStart(pageWrap.getModel().getSoldoutDate())); |