/*
|
* Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
|
*
|
* Redistribution and use in source and binary forms, with or without
|
* modification, are permitted provided that the following conditions are met:
|
*
|
* Redistributions of source code must retain the above copyright notice,
|
* this list of conditions and the following disclaimer.
|
* Redistributions in binary form must reproduce the above copyright
|
* notice, this list of conditions and the following disclaimer in the
|
* documentation and/or other materials provided with the distribution.
|
* Neither the name of the dreamlu.net developer nor the names of its
|
* contributors may be used to endorse or promote products derived from
|
* this software without specific prior written permission.
|
* Author: Chill 庄骞 (smallchill@163.com)
|
*/
|
package org.springblade.jfpt.alarm.mapper;
|
|
import com.baomidou.mybatisplus.annotation.SqlParser;
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import org.apache.ibatis.annotations.Param;
|
import org.springblade.common.entity.ReportReturnData;
|
import org.springblade.jfpt.alarm.entity.Alarm;
|
import org.springblade.common.entity.AlarmExcel;
|
import org.springblade.jfpt.alarm.vo.AlarmVO;
|
import org.springblade.jfpt.parcel.vo.ConditionVo;
|
import org.springblade.system.user.entity.User;
|
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* Mapper 接口
|
*
|
* @author BladeX
|
* @since 2020-07-04
|
*/
|
public interface AlarmMapper extends BaseMapper<Alarm> {
|
|
/**
|
* 自定义分页
|
*
|
* @param page
|
* @param alarm
|
* @return
|
*/
|
List<AlarmVO> selectAlarmPage(IPage page, AlarmVO alarm);
|
List<AlarmVO> listAll();
|
List<AlarmVO> selectList(String jtype, String district, String waringType, String beginTime, String endTime);
|
List<AlarmVO> getLimit();
|
List<AlarmVO> selectInfo(String id);
|
List<AlarmVO> selecttx(String id);
|
void deletejj(String id);
|
|
/**
|
* 查询近7天的警情数据
|
* @param beginTime 开始时间
|
* @param endTime 结束时间
|
* @return
|
*/
|
List<AlarmVO> selectListSe(String beginTime, String endTime);
|
void s(Alarm alarm);
|
void updateJtype(String id, String jtype, String bz,String securityArr);
|
void updatePoliceStatus(String id, String status);
|
void updateOne(Alarm alarm);
|
void updateVaddress(String vaddress,String uids ,String jid);
|
void updateAaddress(String aaddress ,String jid);
|
|
List<Map<String, Object>> selectScount(String time);
|
List<Map<String, Object>> selectEq(String time);
|
|
/**
|
* 查询警情总数
|
* @return
|
*/
|
Integer selectAlarmCount(@Param("conditionVo") ConditionVo conditionVo);
|
|
/**
|
* 查询7天内主动报警（紧急求助）每天的数量
|
* @return
|
*/
|
List<Integer> selectAlarmData();
|
|
/**
|
* 主动报警统计 饼图展示
|
* @param conditionVo status 0:本日 1：本月 2：本月
|
* @return
|
*/
|
List<Map<String, Object>> selectAlarmSum(@Param("conditionVo") ConditionVo conditionVo);
|
|
List<User> queryPolice();
|
|
List<AlarmVO> queryPoliceTime(List policeIdArr);
|
|
List<Map<String, Object>> queryBa();
|
|
List<AlarmVO> getAlarm(@Param("alarm") AlarmVO alarm);
|
|
List<AlarmVO> getAlarming(@Param("alarm") AlarmVO alarm);
|
|
boolean setAlarm(@Param("alarm") AlarmVO alarm);
|
|
/**
|
* 查询当前时间段一键求助报警总次数
|
* @param conditionVo
|
* @return
|
*/
|
Integer selAlarmTimeCount(@Param("conditionVo") ConditionVo conditionVo);
|
|
/**
|
* 查询当前时间段内一键求助报警的数据集合
|
* @param conditionVo
|
* @return
|
*/
|
List<Alarm> selectAlarmList(@Param("conditionVo")ConditionVo conditionVo);
|
|
/**
|
* 统计时间段内一键求助警情数量数据
|
* @param conditionVo
|
* @return
|
*/
|
@SqlParser(filter = true)
|
List<Integer> selectAlarmTimeData(@Param("conditionVo")ConditionVo conditionVo);
|
|
List<Map<String, Object>> queryYearAlarm(String deviceNumber,List childList);
|
|
/**
|
* 导出主动报警数据表格
|
* @param alarmVO 查询条件
|
*/
|
List<AlarmExcel> exportAlarm(@Param("alarm")AlarmVO alarmVO);
|
|
/**
|
* 获取实时警情图表统计数据
|
* @param alarmVO
|
* @return
|
*/
|
List<ReportReturnData> getAlarmPie(@Param("alarm")AlarmVO alarmVO);
|
|
/**
|
* 查询未处理及处理中的警情总数量
|
* @param deviceNumber 设备编号
|
* @return
|
*/
|
Integer selectEqCount(String deviceNumber);
|
|
/**
|
* 查询所有在线的接警员信息
|
* @param province 省
|
* @param city 市
|
* @return
|
*/
|
List<User> selOnlinePolice(Integer province,Integer city);
|
|
/**
|
* 当web端点击办结，推送110，派送保安是 更新警情的接警员信息
|
* @param alarm 警情信息
|
* @return
|
*/
|
int updateReceivingAlarmPoliceInfo(@Param("alarm") Alarm alarm);
|
}
|
