From 1b0cf0db5c82ea8308d2f338973a91555787c34d Mon Sep 17 00:00:00 2001
From: jiangping <jp@doumee.com>
Date: 星期二, 18 三月 2025 11:17:23 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/dev' into dev
---
server/services/src/main/java/com/doumee/service/business/impl/BikesServiceImpl.java | 63 ++++++++++++++++++++++++++++---
1 files changed, 57 insertions(+), 6 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..d9e52f8 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,20 +1,34 @@
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.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.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瀹炵幇
@@ -26,6 +40,12 @@
@Autowired
private BikesMapper bikesMapper;
+ @Autowired
+ private BikesJoinMapper bikesJoinMapper;
+
+
+ @Autowired
+ SystemDictDataMapper systemDictDataMapper;
@Override
public String create(Bikes bikes) {
@@ -75,7 +95,7 @@
@Override
public Bikes findOne(Bikes bikes) {
QueryWrapper<Bikes> wrapper = new QueryWrapper<>(bikes);
- return bikesMapper.selectOne(wrapper);
+ return bikesMapper.selectOne(wrapper.last(" limit 1"));
}
@Override
@@ -83,7 +103,38 @@
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());
+ 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())
+ .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) ;
+ 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());
@@ -130,9 +181,9 @@
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()));
--
Gitblit v1.9.3