From e29f147aab5b0b0b794d611b522b67b94423e3cf Mon Sep 17 00:00:00 2001
From: Fixiaobai <fixiaobai@163.com>
Date: 星期四, 07 九月 2023 17:56:57 +0800
Subject: [PATCH] 修改bug
---
inspection-server/src/main/java/com/yuanchu/limslaboratory/mapper/InspectionMapper.java | 77 +++++++++++++++++++++++++++++++++++---
1 files changed, 71 insertions(+), 6 deletions(-)
diff --git a/inspection-server/src/main/java/com/yuanchu/limslaboratory/mapper/InspectionMapper.java b/inspection-server/src/main/java/com/yuanchu/limslaboratory/mapper/InspectionMapper.java
index 2a3cb96..3988c98 100644
--- a/inspection-server/src/main/java/com/yuanchu/limslaboratory/mapper/InspectionMapper.java
+++ b/inspection-server/src/main/java/com/yuanchu/limslaboratory/mapper/InspectionMapper.java
@@ -1,19 +1,84 @@
package com.yuanchu.limslaboratory.mapper;
-import com.yuanchu.limslaboratory.pojo.Inspection;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.yuanchu.limslaboratory.pojo.Inspection;
+import org.apache.ibatis.annotations.Result;
+import org.apache.ibatis.annotations.ResultType;
+import org.apache.ibatis.annotations.Results;
+import java.util.HashMap;
import java.util.List;
import java.util.Map;
/**
- * <p>
- * Mapper 鎺ュ彛
- * </p>
+ * 鐢宠琛�(Inspection)琛ㄦ暟鎹簱璁块棶灞�
*
- * @author 姹熻嫃榈烽洀缃戠粶绉戞妧鏈夐檺鍏徃
- * @since 2023-07-17
+ * @author zss
+ * @since 2023-08-03 13:03:36
*/
public interface InspectionMapper extends BaseMapper<Inspection> {
+
+ /**
+ * 鏌ヨ妫�楠岀敵璇峰崟鍒楄〃
+ * @param page
+ * @param message
+ * @return
+ */
+ IPage<Map<String, Object>> selectInspectsList(Page<Object> page, String message);
+
+ //璁＄畻宸叉楠屾楠屽崟鏁伴噺
+ Integer seleCountIns();
+
+ //璁＄畻鏈楠岀殑鏁伴噺
+ Integer seleCountUnIns();
+
+ //鑾峰彇妫�楠屽崟鎬绘暟
+ Integer getcount();
+
+ //鑾峰彇妫�楠岀粨璁�,妫�楠屾暟閲�
+ List<Map<String, Object>> getResultNum();
+
+ //璁＄畻鍘熸潗鏂欑殑鍚堟牸鐜�
+ Long qualified(Integer b);
+
+ //璁＄畻鍘熸潗鏂欐楠屽崟鎬绘暟
+ Integer getallmater();
+
+ //璁＄畻鎴愬搧妫�楠屽崟鎬绘暟
+ Integer getallfin();
+
+ //璁＄畻鍘熸潗鏂欏悎鏍肩巼
+ Long qualifiedfin(Integer i);
+
+ //鏌ヨ璇ユ棩鏈熺殑鍘熸潗鏂欐楠屾暟閲�
+ Integer getMaterByDay(String time);
+
+ //鏌ヨ璇ユ棩鏈熺殑鎴愬搧妫�楠屾暟閲�
+ Integer getFinByDay(String time);
+
+ //鏌ヨ璇ユ棩鏈熺殑鍘熸潗鏂欏悎鏍兼暟閲�
+ Long getOkMaterByDay(String time);
+
+ //鏌ヨ璇ユ棩鏈熺殑鎴愬搧鍚堟牸鏁伴噺
+ Long getOkFinByDay(String time);
+
+ //鏌ヨ璇ユ湀鐨勫師鏉愭枡妫�楠屾暟閲�
+ Integer getMaterByMonth(String monthofYear);
+
+ //鏌ヨ璇ユ湀鐨勬垚鍝佹楠屾暟閲�
+ Integer getFinByMonth(String monthofYear);
+
+ //鏌ヨ璇ユ湀鐨勫師鏉愭枡鍚堟牸鐜�
+ Long getOkMaterByMonth(String monthofYear);
+
+ //鏌ヨ璇ユ湀鐨勬垚鍝佸悎鏍肩巼
+ Long getOkFinByMonth(String monthofYear);
+
+ List<Map<String, Object>>getInspectionMaterials(Long id);
+
+ Map<String, Object> selectImAndUserName(Integer id);
}
+
--
Gitblit v1.9.3