From c3521c889382efcdcc12e206f62023075518859e Mon Sep 17 00:00:00 2001
From: lxw <810412026@qq.com>
Date: 星期四, 19 十月 2023 14:28:41 +0800
Subject: [PATCH] 根据物料id查询pic历史和dwg历史
---
src/main/java/com/whyc/service/MaterialHistoryService.java | 30 ++++++++++++++++++++++++++++++
1 files changed, 30 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/service/MaterialHistoryService.java b/src/main/java/com/whyc/service/MaterialHistoryService.java
index f7a6bb1..d845c38 100644
--- a/src/main/java/com/whyc/service/MaterialHistoryService.java
+++ b/src/main/java/com/whyc/service/MaterialHistoryService.java
@@ -1,10 +1,16 @@
package com.whyc.service;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.github.pagehelper.PageHelper;
+import com.github.pagehelper.PageInfo;
+import com.whyc.dto.Response;
import com.whyc.mapper.MaterialHistoryMapper;
import com.whyc.pojo.MaterialHistory;
import org.springframework.stereotype.Service;
+import org.springframework.web.bind.annotation.RequestParam;
import javax.annotation.Resource;
+import java.util.List;
@Service
public class MaterialHistoryService {
@@ -15,4 +21,28 @@
public void insert(MaterialHistory mh) {
mapper.insert(mh);
}
+
+ //鏍规嵁鐗╂枡id鏌ヨdwg鍘嗗彶
+ public Response getDwgHisById(int materialId, int pageCurr, int pageSize) {
+ PageHelper.startPage(pageCurr,pageSize);
+ QueryWrapper wrapper=new QueryWrapper();
+ wrapper.eq("material_id",materialId);
+ wrapper.isNotNull("dwg_url");
+ wrapper.orderByDesc("create_time");
+ List list=mapper.selectList(wrapper);
+ PageInfo pageInfo=new PageInfo(list);
+ return new Response().setII(1,list.size()>0,pageInfo,"鏍规嵁鐗╂枡id鏌ヨdwg鍘嗗彶");
+ }
+
+ //鏍规嵁鐗╂枡id鏌ヨpic鍘嗗彶
+ public Response getPicHisById(int materialId, int pageCurr, int pageSize) {
+ PageHelper.startPage(pageCurr,pageSize);
+ QueryWrapper wrapper=new QueryWrapper();
+ wrapper.eq("material_id",materialId);
+ wrapper.isNotNull("picture_url");
+ wrapper.orderByDesc("create_time");
+ List list=mapper.selectList(wrapper);
+ PageInfo pageInfo=new PageInfo(list);
+ return new Response().setII(1,list.size()>0,pageInfo,"鏍规嵁鐗╂枡id鏌ヨpic鍘嗗彶");
+ }
}
--
Gitblit v1.9.1