From 4a3ecd121a19119f3aac23419990c2db748dc501 Mon Sep 17 00:00:00 2001
From: xiangpei <xiangpei@timesnew.cn>
Date: 星期二, 25 三月 2025 23:43:18 +0800
Subject: [PATCH] 项目查询条件完善
---
business/src/main/resources/mapper/ProjectInfoMapper.xml | 3 +++
business/src/main/java/com/ycl/domain/query/ProjectInfoQuery.java | 10 ++++++++++
2 files changed, 13 insertions(+), 0 deletions(-)
diff --git a/business/src/main/java/com/ycl/domain/query/ProjectInfoQuery.java b/business/src/main/java/com/ycl/domain/query/ProjectInfoQuery.java
index 4b8d65b..17d0c9c 100644
--- a/business/src/main/java/com/ycl/domain/query/ProjectInfoQuery.java
+++ b/business/src/main/java/com/ycl/domain/query/ProjectInfoQuery.java
@@ -46,19 +46,29 @@
private String investType;
//琛屾斂鍖哄垝
private String area;
+
@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
private Date projectStartTime;
+
@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
private Date projectEndTime;
+
//浠庢湁娌℃湁娴佺▼鍒ゆ柇鏄瓨鍌ㄨ繕鏄棭鏈�
private String reserveOrPrevious;
+
private Integer role;// 涓氫富锛�0锛屽鏍革細1
+
//鏌ヨ鏉′欢涓氫富鍗曚綅
private Long projectOwnerUnit;
+
private Integer usedStatus;
+
//鏌ヨ鏉′欢涓荤閮ㄩ棬
private Long competentDepartment;
+ @ApiModelProperty("椤圭洰鐮�")
+ private String coding;
+
@ApiModelProperty("鏄惁鏄紓甯搁」鐩煡璇細0 涓嶆槸 1鏄�")
private Integer exe;
diff --git a/business/src/main/resources/mapper/ProjectInfoMapper.xml b/business/src/main/resources/mapper/ProjectInfoMapper.xml
index 36801ea..8791fc5 100644
--- a/business/src/main/resources/mapper/ProjectInfoMapper.xml
+++ b/business/src/main/resources/mapper/ProjectInfoMapper.xml
@@ -116,6 +116,9 @@
LEFT JOIN sys_dept d ON d.dept_id = TPI.project_owner_unit
<where>
TPI.deleted = 0
+ <if test="query.coding !=null and query.coding!=''">
+ and TPI.coding = #{query.coding}
+ </if>
<if test="query.projectName !=null and query.projectName!=''">
and TPI.project_name like concat('%',#{query.projectName},'%')
</if>
--
Gitblit v1.8.0