From 28c0cb536f804bc0b1ac5005d479d400ec3c000b Mon Sep 17 00:00:00 2001
From: glperry <glperry@163.com>
Date: 星期四, 26 十月 2023 11:10:48 +0800
Subject: [PATCH] 查询所有的审批工单,允许通过申请人，申请时间（时间段， 默认最近7天），流程状态（默认全部）进行筛选
---
src/main/java/com/whyc/service/WorksheetMainService.java | 28 ++++++++++++++++++++++++++++
1 files changed, 28 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/service/WorksheetMainService.java b/src/main/java/com/whyc/service/WorksheetMainService.java
index 924551c..5fa9ad4 100644
--- a/src/main/java/com/whyc/service/WorksheetMainService.java
+++ b/src/main/java/com/whyc/service/WorksheetMainService.java
@@ -892,4 +892,32 @@
e.printStackTrace();
}*/
}
+
+ /**
+ * 鏌ヨ鎵�鏈夌殑宸ュ崟,鎵�鏈変汉鍙
+ * @param param
+ * @return
+ */
+ public Response getList(WorksheetMain param) {
+ Integer pageNum = param.getPageNum();
+ Integer pageSize = param.getPageSize();
+ PageHelper.startPage(pageNum,pageSize);
+
+ int createUserId = param.getCreateUserId().intValue();
+ Date beginTime = param.getBeginTime();
+ Date endTime = param.getEndTime();
+ Integer type = param.getType();
+ QueryWrapper<WorksheetMain> query = Wrappers.query();
+ if(createUserId>0){
+ query.eq("create_user_id",createUserId);
+ }
+ query.ge("begin_time",beginTime);
+ query.le("end_time",endTime);
+ if(type!=null && type>=0){
+ query.eq("type",type);
+ }
+ List<WorksheetMain> worksheetMains = mainMapper.selectList(query);
+ PageInfo pageInfo = new PageInfo(worksheetMains);
+ return new Response().set(1,pageInfo);
+ }
}
--
Gitblit v1.9.1