From b6b0cb226fcf184525ee7b36af3a09471e9c0057 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 25 三月 2024 11:29:33 +0800
Subject: [PATCH] 修改数据统计的查询条件

---
 src/main/java/com/lf/server/mapper/sys/ReportMapper.java |  202 ++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 200 insertions(+), 2 deletions(-)

diff --git a/src/main/java/com/lf/server/mapper/sys/ReportMapper.java b/src/main/java/com/lf/server/mapper/sys/ReportMapper.java
index 6ee6566..73ff766 100644
--- a/src/main/java/com/lf/server/mapper/sys/ReportMapper.java
+++ b/src/main/java/com/lf/server/mapper/sys/ReportMapper.java
@@ -1,5 +1,7 @@
 package com.lf.server.mapper.sys;
 
+import com.lf.server.entity.ctrl.CoordinateEntity;
+import com.lf.server.entity.ctrl.CountEntity;
 import com.lf.server.entity.sys.ReportEntity;
 import org.apache.ibatis.annotations.Mapper;
 import org.springframework.stereotype.Repository;
@@ -17,19 +19,21 @@
      * 鏌ヨ璁板綍鏁�
      *
      * @param name 鍚嶇О
+     * @param code 缂栫爜
      * @return 璁板綍鏁�
      */
-    public Integer selectCount(String name);
+    public Integer selectCount(String name, String code);
 
     /**
      * 鍒嗛〉鏌ヨ
      *
      * @param name   鍚嶇О
+     * @param code   缂栫爜
      * @param limit  璁板綍鏁�
      * @param offset 鍋忕Щ閲�
      * @return 鍒楄〃
      */
-    public List<ReportEntity> selectByPage(String name, Integer limit, Integer offset);
+    public List<ReportEntity> selectByPage(String name, String code, Integer limit, Integer offset);
 
     /**
      * 鏌ヨ鎵�鏈�
@@ -93,4 +97,198 @@
      * @return
      */
     public Integer updates(List<ReportEntity> list);
+
+    /**
+     * 鏁版嵁閲忕粺璁�
+     *
+     * @return
+     */
+    public List<CountEntity> countSizes();
+
+    /**
+     * 鎸夋枃浠剁被鍨嬬粺璁�
+     *
+     * @return
+     */
+    public List<CountEntity> countSizesByType();
+
+    /**
+     * 鏈嶅姟璋冪敤閲忕粺璁�
+     *
+     * @return
+     */
+    public List<CountEntity> countServices();
+
+    /**
+     * 鐢ㄦ埛娴侀噺缁熻
+     *
+     * @return
+     */
+    public List<CountEntity> countOperates();
+
+    /**
+     * 鎸夐」鐩粺璁℃暟鎹�
+     *
+     * @return
+     */
+    public List<CountEntity> countSizesByPrj();
+
+    /**
+     * 鎸夐」鐩粺璁￠捇瀛旀暟鎹�
+     *
+     * @return
+     */
+    public List<CountEntity> countExplorationPoints();
+
+    /**
+     * 鏍规嵁椤圭洰缂栫爜鏌ヨ閽诲瓟鏁版嵁鍧愭爣鐐�
+     *
+     * @param code
+     * @return
+     */
+    public List<CoordinateEntity> selectExplorationPoints(String code);
+
+    /**
+     * 鎸夐」鐩粺璁℃暟瀛楅珮绋嬫ā鍨嬮潰绉�
+     *
+     * @return
+     */
+    public List<CountEntity> countDemAreaByPrj();
+
+    /**
+     * 鎸夐」鐩粺璁′笁缁村湴褰㈡ā鍨嬮潰绉�
+     *
+     * @return
+     */
+    public List<CountEntity> countMptAreaByPrj();
+
+    /**
+     * 鎸夐」鐩粺璁″�炬枩鎽勫奖妯″瀷闈㈢Н
+     *
+     * @return
+     */
+    public List<CountEntity> countOsgbAreaByPrj();
+
+    /**
+     * 鎸夐」鐩粺璁℃縺鍏夌偣浜戞ā鍨嬮潰绉�
+     *
+     * @return
+     */
+    public List<CountEntity> countLasAreaByPrj();
+
+    /**
+     * 鎸夐」鐩粺璁″嫎瀵熷伐鐐逛釜鏁�
+     *
+     * @return
+     */
+    public List<CountEntity> countSurveyWorksiteByPrj();
+
+    /**
+     * 鎸夐」鐩粺璁″嫎瀵熸姤鍛婁釜鏁�
+     *
+     * @return
+     */
+    public List<CountEntity> countExplorationReportByPrj();
+
+    /**
+     * 鎸夐」鐩粺璁″穿濉屼釜鏁�
+     *
+     * @return
+     */
+    public List<CountEntity> countCollapseByPrj();
+
+    /**
+     * 鎸夐」鐩粺璁℃偿鐭虫祦涓暟
+     *
+     * @return
+     */
+    public List<CountEntity> countDebrisFlowByPrj();
+
+    /**
+     * 鎸夐」鐩粺璁″湴闈㈠闄蜂釜鏁�
+     *
+     * @return
+     */
+    public List<CountEntity> countGroundCollapseByPrj();
+
+    /**
+     * 鎸夐」鐩粺璁￠珮闄¤竟鍧′釜鏁�
+     *
+     * @return
+     */
+    public List<CountEntity> countHighSteepSlopeByPrj();
+
+    /**
+     * 鎸夐」鐩粺璁℃粦鍧′釜鏁�
+     *
+     * @return
+     */
+    public List<CountEntity> countLandSlideByPrj();
+
+    /**
+     * 鎸夐」鐩粺璁′笉绋冲畾鏂滃潯涓暟
+     *
+     * @return
+     */
+    public List<CountEntity> countUnstableSlopeByPrj();
+
+    /**
+     * 鎸夐」鐩粺璁℃按姣佷釜鏁�
+     *
+     * @return
+     */
+    public List<CountEntity> countWaterDamageByPrj();
+
+
+    /**
+     * 缁熻鏁板瓧绾垮垝鍥鹃潰绉�
+     *
+     * @return
+     */
+    public List<CountEntity> countDlgAreaByPrj();
+
+
+    /**
+     * 鎸夐」鐩粺璁℃暟瀛楁灏勫奖鍍忓浘闈㈢Н
+     *
+     * @return
+     */
+    public List<CountEntity> countDomAreaByPrj();
+
+    /**
+     * 鎸夐」鐩粺璁＄绾块暱搴�
+     *
+     * @return
+     */
+    public List<CountEntity> countLineLength();
+
+    /**
+     * 鎸夐」鐩粺璁″嫎鎺㈢偣涓暟
+     *
+     * @return
+     */
+    public List<CountEntity> countExplorationPointByPrj();
+
+
+    /**
+     * 鎸夐」鐩粺璁′笁缁村湴璐ㄦā鍨嬮潰绉�
+     *
+     * @return
+     */
+    public List<CountEntity> countGeoModelAreaByPrj();
+
+    /**
+     * 鎸夐」鐩粺璁″湴鐏剧偣涓暟
+     *
+     * @return
+     */
+    public List<CountEntity> countGeologicHazardByPrj();
+
+    /**
+     * 椤圭洰鏁版嵁鍒嗙被缁熻
+     *
+     * @param code
+     * @return
+     */
+    public List<CountEntity> countVariousDataByPrj(String code);
 }

--
Gitblit v1.9.3