From 947f4fc58f3a7f4c4cb12062afcf851b439a53f1 Mon Sep 17 00:00:00 2001
From: jiaosong <jiaosong6760@dingtalk.com>
Date: 星期五, 13 十月 2023 18:49:23 +0800
Subject: [PATCH] #获取可退款信息

---
 server/platform/src/main/java/com/doumee/api/business/LocksController.java           |    2 
 server/services/src/main/java/com/doumee/dao/business/model/Locks.java               |   11 +++++
 server/platform/src/main/java/com/doumee/api/business/GoodsorderController.java      |    6 +-
 server/services/src/main/java/com/doumee/service/business/impl/BikesServiceImpl.java |    2 
 server/platform/src/main/java/com/doumee/api/business/BikesController.java           |    2 
 server/services/src/main/java/com/doumee/dao/business/join/LocksJoinMapper.java      |   12 ++++++
 server/services/src/main/java/com/doumee/service/business/impl/LocksServiceImpl.java |   66 +++++++++++---------------------
 7 files changed, 52 insertions(+), 49 deletions(-)

diff --git a/server/platform/src/main/java/com/doumee/api/business/BikesController.java b/server/platform/src/main/java/com/doumee/api/business/BikesController.java
index cbe067b..7e07ac9 100644
--- a/server/platform/src/main/java/com/doumee/api/business/BikesController.java
+++ b/server/platform/src/main/java/com/doumee/api/business/BikesController.java
@@ -73,7 +73,7 @@
     public ApiResponse<PageData<Bikes>> findPage (@RequestBody PageWrap<Bikes> pageWrap) {
         return ApiResponse.success(bikesService.findPage(pageWrap));
     }
-    @ApiOperation("瀹炴椂杞︿綅淇℃伅-鍒嗛〉鏌ヨ")
+    @ApiOperation("瀹炴椂杞︿綅淇℃伅-鍒嗛〉鏌ヨ-寮冪敤")
     @PostMapping("/pageCurrent")
     @RequiresPermissions("business:bikes:query")
     public ApiResponse<PageData<Bikes>> pageCurrent (@RequestBody PageWrap<Bikes> pageWrap) {
diff --git a/server/platform/src/main/java/com/doumee/api/business/GoodsorderController.java b/server/platform/src/main/java/com/doumee/api/business/GoodsorderController.java
index a74c621..facb6c4 100644
--- a/server/platform/src/main/java/com/doumee/api/business/GoodsorderController.java
+++ b/server/platform/src/main/java/com/doumee/api/business/GoodsorderController.java
@@ -127,8 +127,8 @@
     @ApiOperation("寮哄埗缁撶畻璁㈠崟")
     @PostMapping("/closerGoodsorder")
     @RequiresPermissions("business:goodsorder:query")
-    public ApiResponse closerGoodsorder(@RequestParam String id){
-        goodsorderService.forceCloseGoodsorder(id);
+    public ApiResponse closerGoodsorder(@RequestBody Goodsorder goodsorder){
+        goodsorderService.forceCloseGoodsorder(goodsorder.getId());
         return ApiResponse.success(null);
     }
 
@@ -142,7 +142,7 @@
     }
 
     @ApiOperation("鑾峰彇鍙��娆句俊鎭�")
-    @PostMapping("/getGoodsorderCanBanlanceDTO")
+    @GetMapping("/getGoodsorderCanBanlanceDTO")
     @RequiresPermissions("business:goodsorder:query")
     public ApiResponse<GoodsorderCanBanlanceDTO> getGoodsorderCanBanlanceDTO(@RequestParam String orderId){
         return ApiResponse.success(goodsorderService.getGoodsorderCanBanlanceDTO(orderId));
diff --git a/server/platform/src/main/java/com/doumee/api/business/LocksController.java b/server/platform/src/main/java/com/doumee/api/business/LocksController.java
index 532d4ee..1384608 100644
--- a/server/platform/src/main/java/com/doumee/api/business/LocksController.java
+++ b/server/platform/src/main/java/com/doumee/api/business/LocksController.java
@@ -70,7 +70,7 @@
         return ApiResponse.success(null);
     }
 
-    @ApiOperation("鍒嗛〉鏌ヨ")
+    @ApiOperation("瀹炴椂杞︿綅淇℃伅-鍒嗛〉鏌ヨ")
     @PostMapping("/page")
     @RequiresPermissions("business:locks:query")
     public ApiResponse<PageData<Locks>> findPage(@RequestBody PageWrap<Locks> pageWrap) {
diff --git a/server/services/src/main/java/com/doumee/dao/business/join/LocksJoinMapper.java b/server/services/src/main/java/com/doumee/dao/business/join/LocksJoinMapper.java
new file mode 100644
index 0000000..e9e63bf
--- /dev/null
+++ b/server/services/src/main/java/com/doumee/dao/business/join/LocksJoinMapper.java
@@ -0,0 +1,12 @@
+package com.doumee.dao.business.join;
+
+import com.doumee.dao.business.model.Locks;
+import com.github.yulichang.base.mapper.MPJJoinMapper;
+import org.springframework.stereotype.Repository;
+
+/**
+ * @author T14
+ */
+@Repository
+public interface LocksJoinMapper extends MPJJoinMapper<Locks> {
+}
diff --git a/server/services/src/main/java/com/doumee/dao/business/model/Locks.java b/server/services/src/main/java/com/doumee/dao/business/model/Locks.java
index 7d56295..e5cf83f 100644
--- a/server/services/src/main/java/com/doumee/dao/business/model/Locks.java
+++ b/server/services/src/main/java/com/doumee/dao/business/model/Locks.java
@@ -67,9 +67,20 @@
     @ExcelColumn(name="绔欑偣缂栫爜(鍏宠仈sites)")
     private String siteId;
 
+    @ApiModelProperty(value = "绔欑偣缂栫爜(鍏宠仈sites)")
+    @ExcelColumn(name="绔欑偣缂栫爜(鍏宠仈sites)")
+    @TableField(select = false)
+    private String siteName;
+
     @ApiModelProperty(value = "褰撳墠閿佸畾鑷杞︾紪鍙�")
     @ExcelColumn(name="褰撳墠閿佸畾鑷杞︾紪鍙�")
     private String bikeCode;
+
+    @ApiModelProperty(value = "褰撳墠閿佸畾鑷杞︾紪鍙�")
+    @ExcelColumn(name="褰撳墠閿佸畾鑷杞︾被鍨�")
+    @TableField(select = false)
+    private String bikeType;
+
     @ApiModelProperty(value = "褰撳墠閿佸畾鑷杞︾紪鍙�")
     @TableField(select = false)
     private Sites sites;
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 d38055c..5bf3e6c 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
@@ -91,7 +91,7 @@
         QueryWrapper<Bikes> wrapper = new QueryWrapper<>(bikes);
         return bikesMapper.selectList(wrapper);
     }
-  
+
     @Override
     public PageData<Bikes> findJoinPage(PageWrap<Bikes> pageWrap) {
         IPage<Bikes> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
diff --git a/server/services/src/main/java/com/doumee/service/business/impl/LocksServiceImpl.java b/server/services/src/main/java/com/doumee/service/business/impl/LocksServiceImpl.java
index af86451..22f6c64 100644
--- a/server/services/src/main/java/com/doumee/service/business/impl/LocksServiceImpl.java
+++ b/server/services/src/main/java/com/doumee/service/business/impl/LocksServiceImpl.java
@@ -4,13 +4,18 @@
 import com.doumee.core.model.PageWrap;
 import com.doumee.core.utils.Utils;
 import com.doumee.dao.business.LocksMapper;
+import com.doumee.dao.business.join.LocksJoinMapper;
+import com.doumee.dao.business.model.BaseParam;
+import com.doumee.dao.business.model.Bikes;
 import com.doumee.dao.business.model.Locks;
+import com.doumee.dao.business.model.Sites;
 import com.doumee.service.business.LocksService;
 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.business.SitesService;
+import com.github.yulichang.wrapper.MPJLambdaWrapper;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
 import org.springframework.util.CollectionUtils;
@@ -27,6 +32,9 @@
 
     @Autowired
     private LocksMapper locksMapper;
+
+    @Autowired
+    private LocksJoinMapper locksJoinMapper;
 
     @Override
     public String create(Locks locks) {
@@ -84,58 +92,30 @@
         QueryWrapper<Locks> wrapper = new QueryWrapper<>(locks);
         return locksMapper.selectList(wrapper);
     }
-  
+
     @Override
     public PageData<Locks> findPage(PageWrap<Locks> pageWrap) {
         IPage<Locks> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
-        QueryWrapper<Locks> queryWrapper = new QueryWrapper<>();
+        MPJLambdaWrapper<Locks> queryWrapper = new MPJLambdaWrapper<>();
         Utils.MP.blankToNull(pageWrap.getModel());
-        if (pageWrap.getModel().getId() != null) {
-            queryWrapper.lambda().eq(Locks::getId, pageWrap.getModel().getId());
-        }
-        if (pageWrap.getModel().getCreateDate() != null) {
-            queryWrapper.lambda().ge(Locks::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate()));
-            queryWrapper.lambda().le(Locks::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate()));
-        }
-        if (pageWrap.getModel().getCreator() != null) {
-            queryWrapper.lambda().eq(Locks::getCreator, pageWrap.getModel().getCreator());
-        }
-        if (pageWrap.getModel().getEditDate() != null) {
-            queryWrapper.lambda().ge(Locks::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate()));
-            queryWrapper.lambda().le(Locks::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate()));
-        }
-        if (pageWrap.getModel().getEditor() != null) {
-            queryWrapper.lambda().eq(Locks::getEditor, pageWrap.getModel().getEditor());
-        }
-        if (pageWrap.getModel().getIsdeleted() != null) {
-            queryWrapper.lambda().eq(Locks::getIsdeleted, pageWrap.getModel().getIsdeleted());
-        }
-        if (pageWrap.getModel().getInfo() != null) {
-            queryWrapper.lambda().eq(Locks::getInfo, pageWrap.getModel().getInfo());
-        }
-        if (pageWrap.getModel().getName() != null) {
-            queryWrapper.lambda().eq(Locks::getName, pageWrap.getModel().getName());
-        }
+
         if (pageWrap.getModel().getCode() != null) {
-            queryWrapper.lambda().eq(Locks::getCode, pageWrap.getModel().getCode());
-        }
-        if (pageWrap.getModel().getStatus() != null) {
-            queryWrapper.lambda().eq(Locks::getStatus, pageWrap.getModel().getStatus());
+            queryWrapper.like(Locks::getCode, pageWrap.getModel().getCode());
         }
         if (pageWrap.getModel().getSiteId() != null) {
-            queryWrapper.lambda().eq(Locks::getSiteId, pageWrap.getModel().getSiteId());
+            queryWrapper.like(Locks::getSiteId, pageWrap.getModel().getSiteId());
         }
-        if (pageWrap.getModel().getBikeCode() != null) {
-            queryWrapper.lambda().eq(Locks::getBikeCode, pageWrap.getModel().getBikeCode());
+        if (pageWrap.getModel().getSiteName() != null) {
+            queryWrapper.like(Sites::getName, pageWrap.getModel().getSiteName());
         }
-        for(PageWrap.SortData sortData: pageWrap.getSorts()) {
-            if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) {
-                queryWrapper.orderByDesc(sortData.getProperty());
-            } else {
-                queryWrapper.orderByAsc(sortData.getProperty());
-            }
-        }
-        return PageData.from(locksMapper.selectPage(page, queryWrapper));
+        queryWrapper.leftJoin(Bikes.class,Bikes::getCode,Locks::getBikeCode)
+                    .leftJoin(BaseParam.class,BaseParam::getId,Bikes::getParamId)
+                    .leftJoin(Sites.class,Sites::getCode,Locks::getSiteId);
+        queryWrapper.orderByDesc(Locks::getBikeCode);
+        queryWrapper.selectAll(Locks.class)
+                    .selectAs(Sites::getName,Locks::getSiteName)
+                    .selectAs(BaseParam::getName,Locks::getBikeType);
+        return PageData.from(locksJoinMapper.selectJoinPage(page, Locks.class,queryWrapper));
     }
 
     @Override

--
Gitblit v1.9.3