应急系统和事故管理统计接口

zhangfeng

2022-10-10 1305d0aa469fe7330fd2f8e9fbb10d95042571be

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
package com.gkhy.safePlatform.emergency.repository;
 
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.gkhy.safePlatform.emergency.entity.*;
import com.gkhy.safePlatform.emergency.query.db.EmergencyDrillExecuteDBQuery;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;
 
import java.util.List;
 
@Repository
public interface EmergencyDrillExecuteInfoRepository extends BaseMapper<EmergencyDrillExecuteInfo> {
 
    List<EmergencyDrillExecuteInfoPageDO> selectEmergencyDrillExecuteList(Page<EmergencyDrillExecuteInfoPageDO> page, @Param("query") EmergencyDrillExecuteDBQuery emergencyDrillExecuteDBQuery);
 
    void addEmergencyDrillExecute(EmergencyDrillExecuteInfo emergencyDrillExecuteInfo);
 
    EmergencyDrillExecuteInfoDetailDO selectEmergencyDrillExecuteById(@Param("id") Long id);
 
    void updateEmergencyDrillExecute(EmergencyDrillExecuteInfo emergencyDrillExecuteInfo);
 
    void deleteEmergencyDrillExecute(@Param("id") Long id);
 
    void updateStatusById(@Param("drillExecuteId")Long drillExecuteId);
 
    Integer selectEmergencyDrillExecuteIntervalTime();
 
    List<EmergencyDrillExecuteCountData> selectByMonthAndDept(@Param("startTime") String startTime ,@Param("endTime")String endTime ,@Param("deptIds")List<Long> deptIds);
 
    List<EmergencyDrillExecuteCountData> selectByYearAndDept(@Param("startTime") String startTime ,@Param("endTime")String endTime ,@Param("deptIds")List<Long> deptIds);
 
    List<EmergencyDrillExecuteCountRPC> selectByDayAndDept(@Param("startTime") String startTime ,@Param("endTime")String endTime ,@Param("deptIds")List<Long> deptIds);
 
    List<EmergencyDrillExecuteCountRPC> selectByMonthAndDeptForIntegerMonth(@Param("startTime") String startTime ,@Param("endTime")String endTime ,@Param("deptIds")List<Long> deptIds);
 
    String selectEmergencyDrillExecuteIntervalTimeByDeptId(@Param("deptId")Long deptId);
 
    String getLastTimeByDeptId(@Param("deptId")Long deptId);
 
    String getLastTimeByDeptIds(@Param("deptIdList")List<Long> deptIdList);
 
    List<EmergencyExecuteCountDO> getCountByDeptIdsAndTime(@Param("startTime")String startTime, @Param("endTime")String endTime, @Param("deptIds")List<Long> deptIds);
 
    EmergencyExecuteCountDO getCountByDeptIdAndMonth(@Param("year")Integer year, @Param("month")Integer endTime, @Param("deptId")Long deptId);
 
    List<EmergencyExecuteCountDO> getCountByDeptIdAndYear(@Param("year")Integer year, @Param("deptId")Long deptId);
 
}