package com.hxzk.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.hxzk.pojo.TbWarning;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.springframework.stereotype.Repository;

import java.util.List;
@Repository
public interface WarningDao extends BaseMapper<TbWarning> {

    //除了人员聚集类型其他告警都获取
    @Select("SELECT w.id,w.type,w.objectid,w.status,w.time,w.baoliu1,w.baoliu2,w.baoliu3,w.baoliu4,w.baoliu5,w.baoliu6,w.baoliu7,w.baoliu8,w.baoliu9,p.p_name,p.p_phone AS pphone,w.baoliu10 FROM `tb_warning` w INNER JOIN tb_person p ON p.p_tagid = w.objectid WHERE  w.status = '未处理' AND w.baoliu6 = '0' AND w.type <> '人员聚集'")
    List<com.hxzk.deo.TbWarning> findDaPingGaoJing();
    //只获取人员聚集
    @Select("SELECT w.id,w.type,w.objectid,w.status,w.time,w.baoliu1,w.baoliu2,w.baoliu3,w.baoliu4,w.baoliu5,w.baoliu6,w.baoliu7,w.baoliu8,w.baoliu9,p.p_name,p.p_phone AS pphone,w.baoliu10,p.baoliu38 FROM `tb_warning` w INNER JOIN tb_person p ON p.p_tagid = w.objectid WHERE  w.status = '未处理' AND w.baoliu6 = '0'  AND w.`type` = '人员聚集' AND p.baoliu38 >1")
    List<com.hxzk.deo.TbWarning> findDaPingGaoJingRenYuanJuJi();
    @Select("SELECT count(*) FROM `tb_warning`  WHERE DATE(time) = CURDATE() and `status` = '未处理'")
    Integer findDaPingWeiChuLiCount();

    @Select("SELECT w.id,w.type,w.objectid,w.status,w.time,w.baoliu1,w.baoliu2,w.baoliu3,w.baoliu4,w.baoliu5,w.baoliu6,p.p_name FROM tb_warning w\n" +
            "INNER JOIN tb_person p on p.p_tagid = w.objectid where status = '未处理' order by w.time desc")
    List<com.hxzk.deo.TbWarning> findSelect();


    @Select("SELECT w.id,w.type,w.objectid,w.status,w.time,w.baoliu1,w.baoliu2,w.baoliu3,w.baoliu4,w.baoliu5,w.baoliu6,w.baoliu7,p.p_name FROM tb_warning w INNER JOIN tb_person p on p.p_tagid = w.objectid  order by w.status desc,w.time DESC")
    List<com.hxzk.deo.TbWarning> findSelectHouTai();

    @Select("SELECT w.id,w.type,w.objectid,w.status,w.time,w.baoliu1,w.baoliu2,w.baoliu3,w.baoliu4,w.baoliu5,w.baoliu6,p.p_name FROM tb_warning w\n" +
            "INNER JOIN tb_person p on p.p_tagid = w.objectid WHERE w.objectid LIKE #{objectid} and status = '未处理' OR w.type LIKE #{objectid} and status = '未处理' ORDER BY w.time DESC")
    List<com.hxzk.deo.TbWarning> findSelectsearch(String objectid);


    @Select("SELECT w.id,w.type,w.objectid,w.status,w.time,w.baoliu1,w.baoliu2,w.baoliu3,w.baoliu4,w.baoliu5,w.baoliu6,p.p_name FROM tb_warning w\n" +
            "INNER JOIN tb_person p on p.p_tagid = w.objectid WHERE w.objectid LIKE #{objectid}  OR w.type LIKE #{objectid}  ORDER BY w.status DESC")
    List<com.hxzk.deo.TbWarning> findSelectsearchHouTai(String objectid);

    @Update("update tb_warning set baoliu6 = '1' where DATE(time) = CURDATE() and type = #{type}")
    void UpWarningIsshow(String type);

    @Update("update tb_warning set status = '已处理'")
    void UpStatusAll();


    @Select("SELECT w.id,w.type,w.objectid,w.status,w.time,w.baoliu1,w.baoliu2,w.baoliu3,w.baoliu4,w.baoliu5,w.baoliu6,w.baoliu7,p.`p_phone`,p.p_name,p.p_tagid,p.p_department FROM tb_warning w Inner join tb_person p on p.`p_tagid` = w.`objectid` WHERE w.status = '未处理' and w.type = #{types} AND w.baoliu7 = '0'")
    List<com.hxzk.deo.TbWarning> findNowAll(String types);


    @Update("update tb_warning set baoliu7 = '1' where id = #{id}")
    void updateIdWarning(Integer id);
}