应急统计

songhuangfeng123

2022-09-05 208b6439eb8e63b6485240a8b466ebdcfd08c57a

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
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<EmergencyDrillExecuteCountData> selectByDayAndDept(@Param("startTime") String startTime ,@Param("endTime")String endTime ,@Param("deptIds")List<Long> deptIds);
 
    String selectEmergencyDrillExecuteIntervalTimeByDeptId(@Param("deptId")Long deptId);
}