From 6f1416efc5fa001bcbae7cbbd086d3ad2a6b3292 Mon Sep 17 00:00:00 2001
From: k94314517 <8417338+k94314517@user.noreply.gitee.com>
Date: 星期五, 13 九月 2024 16:08:28 +0800
Subject: [PATCH] 代码初始化
---
server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitParkServiceImpl.java | 64 +++++++++++++++-----------------
1 files changed, 30 insertions(+), 34 deletions(-)
diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitParkServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitParkServiceImpl.java
index ce13cd4..4b60a4b 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitParkServiceImpl.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitParkServiceImpl.java
@@ -4,12 +4,15 @@
import com.doumee.core.model.PageWrap;
import com.doumee.core.utils.Utils;
import com.doumee.dao.business.VisitParkMapper;
-import com.doumee.dao.business.model.VisitPark;
+import com.doumee.dao.business.join.VisitParkJoinMapper;
+import com.doumee.dao.business.model.*;
import com.doumee.service.business.VisitParkService;
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 +29,9 @@
@Autowired
private VisitParkMapper visitParkMapper;
+
+ @Autowired
+ private VisitParkJoinMapper visitParkJoinMapper;
@Override
public Integer create(VisitPark visitPark) {
@@ -87,40 +93,30 @@
@Override
public PageData<VisitPark> findPage(PageWrap<VisitPark> pageWrap) {
IPage<VisitPark> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
- QueryWrapper<VisitPark> queryWrapper = new QueryWrapper<>();
- Utils.MP.blankToNull(pageWrap.getModel());
- queryWrapper.lambda()
- .eq(pageWrap.getModel().getId() != null, VisitPark::getId, pageWrap.getModel().getId())
- .eq(pageWrap.getModel().getCreator() != null, VisitPark::getCreator, pageWrap.getModel().getCreator())
- .ge(pageWrap.getModel().getCreateDate() != null, VisitPark::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate()))
- .le(pageWrap.getModel().getCreateDate() != null, VisitPark::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate()))
- .eq(pageWrap.getModel().getEditor() != null, VisitPark::getEditor, pageWrap.getModel().getEditor())
- .ge(pageWrap.getModel().getEditDate() != null, VisitPark::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate()))
- .le(pageWrap.getModel().getEditDate() != null, VisitPark::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate()))
- .eq(pageWrap.getModel().getIsdeleted() != null, VisitPark::getIsdeleted, pageWrap.getModel().getIsdeleted())
- .eq(pageWrap.getModel().getRemark() != null, VisitPark::getRemark, pageWrap.getModel().getRemark())
- .eq(pageWrap.getModel().getParkId() != null, VisitPark::getParkId, pageWrap.getModel().getParkId())
- .eq(pageWrap.getModel().getSortnum() != null, VisitPark::getSortnum, pageWrap.getModel().getSortnum())
- .eq(pageWrap.getModel().getVisitApplyId() != null, VisitPark::getVisitApplyId, pageWrap.getModel().getVisitApplyId())
- .eq(pageWrap.getModel().getCarCode() != null, VisitPark::getCarCode, pageWrap.getModel().getCarCode())
- .eq(pageWrap.getModel().getHkId() != null, VisitPark::getHkId, pageWrap.getModel().getHkId())
- .eq(pageWrap.getModel().getHkStatus() != null, VisitPark::getHkStatus, pageWrap.getModel().getHkStatus())
- .ge(pageWrap.getModel().getHkDate() != null, VisitPark::getHkDate, Utils.Date.getStart(pageWrap.getModel().getHkDate()))
- .le(pageWrap.getModel().getHkDate() != null, VisitPark::getHkDate, Utils.Date.getEnd(pageWrap.getModel().getHkDate()))
- .ge(pageWrap.getModel().getStartTime() != null, VisitPark::getStartTime, Utils.Date.getStart(pageWrap.getModel().getStartTime()))
- .le(pageWrap.getModel().getStartTime() != null, VisitPark::getStartTime, Utils.Date.getEnd(pageWrap.getModel().getStartTime()))
- .ge(pageWrap.getModel().getEndTime() != null, VisitPark::getEndTime, Utils.Date.getStart(pageWrap.getModel().getEndTime()))
- .le(pageWrap.getModel().getEndTime() != null, VisitPark::getEndTime, Utils.Date.getEnd(pageWrap.getModel().getEndTime()))
- .eq(pageWrap.getModel().getParkHkId() != null, VisitPark::getParkHkId, pageWrap.getModel().getParkHkId())
+ MPJLambdaWrapper<VisitPark> queryWrapper = new MPJLambdaWrapper<>();
+
+ queryWrapper.selectAll(VisitPark.class);
+ queryWrapper.selectAs(Parks::getName, VisitPark::getParksName);
+ queryWrapper.selectAs(Member::getType,VisitPark::getMemberType);
+ queryWrapper.selectAs(Member::getName,VisitPark::getMemberName);
+ queryWrapper.selectAs(Member::getPhone,VisitPark::getMemberPhone);
+ queryWrapper.selectAs(Company::getName,VisitPark::getCompanyName);
+
+ queryWrapper.leftJoin(Visits.class,Visits::getId,VisitPark::getVisitApplyId);
+ queryWrapper.leftJoin(Parks.class,Parks::getId,VisitPark::getParkId);
+ queryWrapper.leftJoin(Member.class,Member::getId,Visits::getMemberId);
+ queryWrapper.leftJoin(Company.class,Company::getId,Member::getCompanyId);
+
+ queryWrapper
+ .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()),VisitPark::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(VisitPark::getCreateDate)
;
- for(PageWrap.SortData sortData: pageWrap.getSorts()) {
- if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) {
- queryWrapper.orderByDesc(sortData.getProperty());
- } else {
- queryWrapper.orderByAsc(sortData.getProperty());
- }
- }
- return PageData.from(visitParkMapper.selectPage(page, queryWrapper));
+ IPage<VisitPark> result = visitParkJoinMapper.selectJoinPage(page, VisitPark.class,queryWrapper);
+ return PageData.from(result);
}
@Override
--
Gitblit v1.9.3