From 5da02311d99ca78c0fc18647c3a8348f56fe9330 Mon Sep 17 00:00:00 2001
From: fuliqi <fuliqi@qq.com>
Date: 星期四, 05 九月 2024 21:55:13 +0800
Subject: [PATCH] 考核结果导出优化
---
ycl-server/src/main/java/com/ycl/platform/mapper/YwPointMapper.java | 43 +++++++++++++++++++++++++++++++++++++++++++
1 files changed, 43 insertions(+), 0 deletions(-)
diff --git a/ycl-server/src/main/java/com/ycl/platform/mapper/YwPointMapper.java b/ycl-server/src/main/java/com/ycl/platform/mapper/YwPointMapper.java
index 32860fa..f95bd46 100644
--- a/ycl-server/src/main/java/com/ycl/platform/mapper/YwPointMapper.java
+++ b/ycl-server/src/main/java/com/ycl/platform/mapper/YwPointMapper.java
@@ -3,8 +3,10 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.ycl.platform.base.BaseSelect;
+import com.ycl.platform.domain.entity.ReportAuditingRecord;
import com.ycl.platform.domain.entity.YwPoint;
import com.ycl.platform.domain.query.YwPointQuery;
+import com.ycl.platform.domain.vo.ReportAuditingRecordVO;
import com.ycl.platform.domain.vo.YwPointVO;
import com.ycl.platform.domain.excel.PointExport;
import org.apache.ibatis.annotations.Mapper;
@@ -61,4 +63,45 @@
* @param pointList
*/
int updatePoint(List<YwPoint> pointList);
+
+ /**
+ * 缁熻鏌愮偣浣嶅搴旂殑鏈畬鎴愬伐鍗曟暟閲忥紝鐞嗚涓婃渶澶у�间负1涓伐鍗�
+ *
+ * @param pointId
+ * @return
+ */
+ YwPointVO countNotFinishedWorkOrderByPointId(@Param("pointId") Integer pointId);
+
+ /**
+ * 缁熻鏌愮偣浣嶅搴旂殑鏈畬鎴愬伐鍗曟暟閲忥紝鐞嗚涓婃渶澶у�间负1涓伐鍗�
+ *
+ * @param serialNumber
+ * @return
+ */
+ YwPointVO countNotFinishedWorkOrderByGb(@Param("serialNumber") String serialNumber);
+
+ /**
+ * 鏌ヨ鏈夐儴绾ф爣绛剧殑鐐逛綅鐨勫浗鏍囩爜
+ *
+ * @param tagType 0 閮ㄧ骇 1 閲嶇偣 2 閲嶇偣鎸囨尌鍥惧儚
+ * @return
+ */
+ List<String> getDeptPointGB(@Param("tagType") Integer tagType);
+
+ /**
+ * 鐐逛綅涓嬫媺
+ *
+ * @param keyword
+ * @param unitId
+ * @return
+ */
+ List<YwPoint> select(@Param("keyword") String keyword, @Param("unitId") Integer unitId);
+
+ /**
+ * 鑾峰彇鏈�鏂颁竴鏉℃姤澶囩粨鏋�
+ * @param serialNumber
+ * @param reportType
+ * @return
+ */
+ ReportAuditingRecordVO getReportResult(@Param("serialNumber") String serialNumber, @Param("reportType") String reportType);
}
--
Gitblit v1.8.0