From 66db1d15cf5d4b51a346a42b66f0505bd7f31ce0 Mon Sep 17 00:00:00 2001
From: whycxzp <glperry@163.com>
Date: 星期三, 03 一月 2024 15:23:47 +0800
Subject: [PATCH] 解压
---
src/main/java/com/whyc/service/ProductLockLogService.java | 33 +++++++++++++++++++++++++++++++++
1 files changed, 33 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/service/ProductLockLogService.java b/src/main/java/com/whyc/service/ProductLockLogService.java
index cf4a67d..6677ae9 100644
--- a/src/main/java/com/whyc/service/ProductLockLogService.java
+++ b/src/main/java/com/whyc/service/ProductLockLogService.java
@@ -1,10 +1,19 @@
package com.whyc.service;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.toolkit.Wrappers;
+import com.github.pagehelper.PageHelper;
+import com.github.pagehelper.PageInfo;
+import com.whyc.dto.Response;
import com.whyc.mapper.ProductLockLogMapper;
import com.whyc.pojo.ProductLockLog;
+import com.whyc.util.ActionUtil;
+import org.aspectj.weaver.ast.And;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
+import java.util.Date;
+import java.util.List;
@Service
public class ProductLockLogService {
@@ -15,4 +24,28 @@
public void insert(ProductLockLog lockLog) {
mapper.insert(lockLog);
}
+
+ public void insertBatch(List<ProductLockLog> lockLogs){
+ mapper.insertBatchSomeColumn(lockLogs);
+ }
+
+ public List<ProductLockLog> getListByParentCodeAndCustomCode(String parentCode, String customCode) {
+ QueryWrapper<ProductLockLog> query = Wrappers.query();
+ query.eq("parent_code",parentCode).eq("custom_code",customCode).orderByDesc("id");
+ return mapper.selectList(query);
+ }
+ //鏌ヨ鍒楄〃-鏌ヨ鐢ㄦ埛鐨勮В閿佹搷浣�
+ public Response getUnlockByOwner(Date testTime1, Date testTime2, int pageCurr, int pageSize) {
+ PageHelper.startPage(pageCurr,pageSize);
+ String uName= ActionUtil.getUser().getName();
+ QueryWrapper wrapper=new QueryWrapper();
+ wrapper.eq("owner",uName);
+ wrapper.in("lock_flag",0,1);
+ wrapper.le("create_time",testTime2);
+ wrapper.ge("create_time",testTime1);
+ wrapper.orderByDesc("create_time");
+ List list=mapper.selectList(wrapper);
+ PageInfo pageInfo=new PageInfo(list);
+ return new Response().setII(1,list!=null,pageInfo,"鏌ヨ鐢ㄦ埛鐨勮В閿佹搷浣�");
+ }
}
--
Gitblit v1.9.1