From 10c23bd4369b1657a077a20e57d514632690ab52 Mon Sep 17 00:00:00 2001
From: Fixiaobai <fixiaobai@163.com>
Date: 星期三, 23 八月 2023 18:04:12 +0800
Subject: [PATCH] 实验室管理=》角色管理
---
inspection-server/src/main/java/com/yuanchu/limslaboratory/mapper/InspectionMapper.java | 70 ++++++++++++++++++++++++++++++----
1 files changed, 61 insertions(+), 9 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 106c79a..adcb5dd 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,24 +1,76 @@
package com.yuanchu.limslaboratory.mapper;
-import com.yuanchu.limslaboratory.pojo.Inspection;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
-import com.yuanchu.limslaboratory.pojo.dto.InspectionDto;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.yuanchu.limslaboratory.pojo.Inspection;
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> {
- List<InspectionDto> selectAllInspection(int pageSize, int countSize, Integer state);
- int selectInspectToCount(Integer state);
+ /**
+ * 鏌ヨ妫�楠岀敵璇峰崟鍒楄〃
+ * @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);
}
+
--
Gitblit v1.9.3