| | |
| | | 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); |
| | | .like( pageWrap.getModel().getLockId() !=null,Bikes::getLockId,pageWrap.getModel().getLockId()) |
| | | .ne(Bikes::getLockId,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) |
| | | .or(b->b.ne(Bikes::getCode,""))); |
| | | queryWrapper.selectAll(Bikes.class) |
| | | .selectAs(BaseParam::getName,Bikes::getParamName) |
| | | .selectAs(Sites::getName,Bikes::getSiteName) ; |