package com.hxzk.gps.mapper.Company;

import com.github.pagehelper.PageInfo;
import com.hxzk.gps.entity.Company.TbCompany;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.hxzk.gps.entity.WarnTongJi.WarnTongjiCompany;
import com.hxzk.gps.entity.Warning.TbWarning;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author YuZhiTong
 * @since 2025-04-17
 */
public interface TbCompanyMapper extends BaseMapper<TbCompany> {

    //在线人员
    @Select({
            "<script>",
            "SELECT COUNT(*) FROM tb_person",
            "WHERE p_online = 1",
            "AND companyid IN",
            "   <foreach item='comp' collection='companyids' open='(' separator=',' close=')'>",
            "       #{comp}",
            "   </foreach>",
            "</script>"
    })
    Integer FindCompanyOnlineCount(@Param("companyids")List companyids);

    //离线人员
    @Select({
            "<script>",
            "SELECT COUNT(*) FROM tb_person",
            "WHERE p_online = 0",
            "AND companyid IN",
            "   <foreach item='comp' collection='companyids' open='(' separator=',' close=')'>",
            "       #{comp}",
            "   </foreach>",
            "</script>"
    })
    Integer FindCompanyNoOnlineCount(@Param("companyids")List companyids);

    //在线车辆
    @Select({
            "<script>",
            "SELECT COUNT(*) FROM tb_person",
            "WHERE p_online = 1",
            "AND (",
            "   (baoliu19 = '车载标签' AND companyid IN",
            "       <foreach item='comp' collection='companyids' open='(' separator=',' close=')'>",
            "           #{comp}",
            "       </foreach>)",
            "   OR (baoliu19 = '融合车载' AND companyid IN",
            "       <foreach item='comp' collection='companyids' open='(' separator=',' close=')'>",
            "           #{comp}",
            "       </foreach>)",
            "   OR (baoliu19 = '车载终端' AND companyid IN",
            "       <foreach item='comp' collection='companyids' open='(' separator=',' close=')'>",
            "           #{comp}",
            "       </foreach>)",
            ")",
            "</script>"
    })
    Integer FindCompanyOnlineCarCount(@Param("companyids")List companyids);

    //离线车辆
    @Select({
            "<script>",
            "SELECT COUNT(*) FROM tb_person",
            "WHERE p_online = 0",
            "AND (",
            "   (baoliu19 = '车载标签' AND companyid IN",
            "       <foreach item='comp' collection='companyids' open='(' separator=',' close=')'>",
            "           #{comp}",
            "       </foreach>)",
            "   OR (baoliu19 = '融合车载' AND companyid IN",
            "       <foreach item='comp' collection='companyids' open='(' separator=',' close=')'>",
            "           #{comp}",
            "       </foreach>)",
            "   OR (baoliu19 = '车载终端' AND companyid IN",
            "       <foreach item='comp' collection='companyids' open='(' separator=',' close=')'>",
            "           #{comp}",
            "       </foreach>)",
            ")",
            "</script>"
    })
    Integer FindCompanyNoOnlineCarCount(@Param("companyids")List companyids);

    //在线基站
    @Select("select count(*) from tb_achor where anchormode = '1' and company = #{company} ")
    Integer FindCompanyOnlineAchorCount(String company);

    //离线基站
    @Select("select count(*) from tb_achor where anchormode = '0' and company = #{company} ")
    Integer FindCompanyNoOnlineAchorCount(String company);


    @Select({
            "<script>",
            "SELECT COUNT(*) FROM tb_warning w",
            "INNER JOIN tb_person p ON p.p_tagid = w.objectid",
            "WHERE p.companyid IN",
            "   <foreach item='comp' collection='companyids' open='(' separator=',' close=')'>",
            "       #{comp}",
            "   </foreach>",
            "AND w.type = '静止告警'",
            "</script>"
    })
    Integer FindCompanyWarningCount1(@Param("companyids")List companyids);

    @Select({
            "<script>",
            "SELECT COUNT(*) FROM tb_warning w",
            "INNER JOIN tb_person p ON p.p_tagid = w.objectid",
            "WHERE p.companyid IN",
            "   <foreach item='item' collection='companyids' open='(' separator=',' close=')'>",
            "       #{item}",
            "   </foreach>",
            "AND w.type = 'SOS'",
            "AND w.status = '未处理'",
            "</script>"
    })
    Integer FindCompanyWarningCount2(@Param("companyids")List companyids);


    @Select({
            "<script>",
            "SELECT COUNT(*) FROM tb_warning w",
            "INNER JOIN tb_person p ON p.p_tagid = w.objectid",
            "WHERE p.companyid IN",
            "   <foreach item='item' collection='companyids' open='(' separator=',' close=')'>",
            "       #{item}",
            "   </foreach>",
            "AND w.type = '跌落告警'",
            "AND w.status = '未处理'",
            "</script>"
    })
    Integer FindCompanyWarningCount3(@Param("companyids")List companyids);


    @Select({
            "<script>",
            "SELECT COUNT(*) FROM tb_warning w",
            "INNER JOIN tb_person p ON p.p_tagid = w.objectid",
            "WHERE p.companyid IN",
            "   <foreach item='item' collection='companyids' open='(' separator=',' close=')'>",
            "       #{item}",
            "   </foreach>",
            "AND w.type = '缺员告警'",
            "AND w.status = '未处理'",
            "</script>"
    })
    Integer FindCompanyWarningCount4(@Param("companyids")List companyids);

    @Select({
            "<script>",
            "SELECT COUNT(*) FROM tb_warning w",
            "INNER JOIN tb_person p ON p.p_tagid = w.objectid",
            "WHERE p.companyid IN",
            "   <foreach item='item' collection='companyids' open='(' separator=',' close=')'>",
            "       #{item}",
            "   </foreach>",
            "AND w.type = '超员告警'",
            "AND w.status = '未处理'",
            "</script>"
    })
    Integer FindCompanyWarningCount5(@Param("companyids")List companyids);


    @Select({
            "<script>",
            "SELECT COUNT(*) FROM tb_warning w",
            "INNER JOIN tb_person p ON p.p_tagid = w.objectid",
            "WHERE p.companyid IN",
            "   <foreach item='item' collection='companyids' open='(' separator=',' close=')'>",
            "       #{item}",
            "   </foreach>",
            "AND w.type = '聚集告警'",
            "AND w.status = '未处理'",
            "</script>"
    })
    Integer FindCompanyWarningCount6(@Param("companyids")List companyids);

    @Select({
            "<script>",
            "SELECT COUNT(*) FROM tb_warning w",
            "INNER JOIN tb_person p ON p.p_tagid = w.objectid",
            "WHERE p.companyid IN",
            "   <foreach item='item' collection='companyids' open='(' separator=',' close=')'>",
            "       #{item}",
            "   </foreach>",
            "AND w.type = '出去告警'",
            "AND w.status = '未处理'",
            "</script>"
    })
    Integer FindCompanyWarningCount7(@Param("companyids")List companyids);

    @Select({
            "<script>",
            "SELECT COUNT(*) FROM tb_warning w",
            "INNER JOIN tb_person p ON p.p_tagid = w.objectid",
            "WHERE p.companyid IN",
            "   <foreach item='item' collection='companyids' open='(' separator=',' close=')'>",
            "       #{item}",
            "   </foreach>",
            "AND w.type = '进入告警'",
            "AND w.status = '未处理'",
            "</script>"
    })
    Integer FindCompanyWarningCount8(@Param("companyids")List companyids);

    @Select({
            "<script>",
            "SELECT COUNT(*) FROM tb_warning w",
            "INNER JOIN tb_person p ON p.p_tagid = w.objectid",
            "WHERE p.companyid IN",
            "   <foreach item='item' collection='companyids' open='(' separator=',' close=')'>",
            "       #{item}",
            "   </foreach>",
            "AND w.type = '低电量'",
            "AND w.status = '未处理'",
            "</script>"
    })
    Integer FindCompanyWarningCount9(@Param("companyids")List companyids);

    @Select("select * from warn_tongji_company where company = #{company} ")
    List<WarnTongjiCompany> findCompanyWarn(String company);

    @Update("update warn_tongji_company set num = #{count} where title = #{title} and company = #{company} ")
    Integer UpCompanyWarnCount(@Param("company") String company, @Param("count")Integer count, @Param("title")String title);

}