MsgAlarmMapper.java 1.6 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556
  1. package com.ozs.service.mapper;
  2. import com.ozs.common.core.domain.entity.SysUser;
  3. import com.ozs.service.entity.MsgAlarm;
  4. import com.baomidou.mybatisplus.core.mapper.BaseMapper;
  5. import com.ozs.service.entity.vo.*;
  6. import org.apache.ibatis.annotations.Mapper;
  7. import org.apache.ibatis.annotations.Param;
  8. import java.util.List;
  9. import java.util.Map;
  10. /**
  11. * <p>
  12. * 报警信息表 Mapper 接口
  13. * </p>
  14. *
  15. * @author ozs
  16. * @since 2023-02-22
  17. */
  18. @Mapper
  19. public interface MsgAlarmMapper extends BaseMapper<MsgAlarm> {
  20. //报警数据详情
  21. List<AlarmStatisticVo> list(AlarmStatisticResVo alarmStatisticResVo);
  22. //报警数据详情导出数据集合
  23. List<AlarmStatisticDto> listDto(AlarmStatisticResVo alarmStatisticResVo);
  24. //报警月统计数据导出数据集合
  25. List<AlarmStatisticMonthDto> listDtoMonth(AlarmStatisticResVo alarmStatisticResVo);
  26. //报警月统计数据导出数据集合(天)
  27. List<AlarmStatisticMonthDto> listDtoDay(AlarmStatisticResVo alarmStatisticResVo);
  28. Integer selectCameraCode(@Param("cameraCode") String cameraCode);
  29. MsgAlarm selectByCameraCode(@Param("cameraCode") String cameraCode);
  30. List<MsgAlarm> selectMsgAlarmList(MsgAlarmVo msgAlarmVo);
  31. MsgAlarm getByAlarmId(@Param("alarmId") String alarmId);
  32. Integer countMsg(MsgAlarmVo msgAlarmVo);
  33. Integer countJC(MsgAlarmVo msgAlarmVo);
  34. Integer countWJC(MsgAlarmVo msgAlarmVo);
  35. List<MsgAlarm> queryAlarmInfoByAfterTenMinute();
  36. List<MsgAlarm> selectMsgAlarmListHome(MsgAlarmVo msgAlarmVo);
  37. // 新的方法,直接查询统计结果
  38. Map<String, Integer> selectAlarmStatistics(MsgAlarmVo msgAlarmVo);
  39. }