package com.hxzk.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.hxzk.deo.NettyPerson;
import com.hxzk.deo.PersonCCid;
import com.hxzk.deo.PersonCesium;
import com.hxzk.deo.TbPersonAndDepartment;
import com.hxzk.pojo.PowerPerson;
import com.hxzk.pojo.TbPerson;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface PersonDao extends BaseMapper<TbPerson> {

    @Select("select p.id,p.p_name,p.p_tagid,p.p_sex,p.p_minzu,p.p_phone,p.p_department,p.p_ban,p.p_zu,p.p_idcardnum,p.p_adress,p.p_canin,p.p_x,p.p_y,p.p_floor,p.p_sos,p.p_online,p.p_power,p.p_kaoqing,p.p_fence,p.p_fencename,p.p_kaoqqingname,p.p_image,p.p_addtiem,p.p_power_wanig,p.p_sousuo,p.p_shipin,p.p_shipingname,p.baoliu1,p.baoliu2,p.baoliu3,p.baoliu4,p.baoliu5,p.baoliu6,p.baoliu7,p.baoliu8,p.baoliu9,p.baoliu10,p.baoliu11,p.baoliu12,p.baoliu13,p.baoliu14,p.baoliu15,p.baoliu16,p.baoliu17,p.baoliu18,p.baoliu19,p.baoliu20,p.baoliu21,p.baoliu22,p.baoliu23,p.baoliu24,p.baoliu25,p.baoliu26,p.baoliu27,p.baoliu28,p.baoliu29,p.baoliu30,p.baoliu31,p.baoliu32,p.baoliu33,p.baoliu34,p.baoliu35,p.baoliu36,p.baoliu37,p.baoliu38,p.baoliu39,p.baoliu40,t.version as version from tb_person p INNER JOIN tb_tag t on t.tag_id = p.p_tagid where p.baoliu19 = '融合终端' or p.baoliu19 ='系统默认' or p.baoliu19 = 'lora标签' order by p.p_online desc")
    List<com.hxzk.deo.TbPerson> findAlls();

    @Select("SELECT p.*,g.ccid AS baoliu43 FROM `tb_person` p INNER JOIN tb_gps g on g.tagid = p.p_tagid where p.baoliu19 = '融合终端' or p.baoliu19 = '系统默认' or p.baoliu19 = 'lora标签' OR p.baoliu19 = '防撞标签'")
    List<PersonCCid> findPersonAll();

    @Select("select * from tb_person where baoliu19 = '车载终端' or baoliu19 ='车载带屏'")
    List<TbPerson>findAllCheLiang();

    @Select("SELECT p_tagid as userId,p_name as name,baoliu38 as photo from tb_person where baoliu38 != 'notouxiang.png'")
    List<NettyPerson> findApiList();
    @Select("SELECT p.id,p.p_name,p.p_tagid,p.p_sex,p.p_minzu,p.p_phone,p.p_department,p.p_ban,p.p_zu,p.p_idcardnum,p.p_adress,p.p_canin,p.p_x,p.p_y,p.p_floor,p.p_sos,p.p_online,p.p_power,p.p_kaoqing,p.p_fence,p.p_fencename,p.p_kaoqqingname,p.p_image,p.p_addtiem,p.p_power_wanig,p.p_sousuo,p.p_shipin,p.p_shipingname,p.baoliu1,p.baoliu2,p.baoliu3,p.baoliu4,p.baoliu5,p.baoliu6,p.baoliu7,p.baoliu8,p.baoliu9,p.baoliu10,p.baoliu11,p.baoliu12,p.baoliu13,p.baoliu14,p.baoliu15,p.baoliu16,p.baoliu17,p.baoliu18,p.baoliu19,p.baoliu20,p.baoliu21,p.baoliu22,p.baoliu23,p.baoliu24,p.baoliu25,p.baoliu26,p.baoliu27,p.baoliu28,p.baoliu29,p.baoliu30,p.baoliu31,p.baoliu32,p.baoliu33,p.baoliu34,p.baoliu35,p.baoliu36,p.baoliu37,p.baoliu38,p.baoliu39,p.baoliu40,t.version AS VERSION ,g.ccid as baoliu43  FROM tb_person p INNER JOIN tb_tag t ON t.tag_id = p.p_tagid inner join tb_gps g on p.p_tagid = g.tagid  WHERE p.p_tagid LIKE CONCAT('%', #{pTagid}, '%') OR p.p_name LIKE CONCAT('%', #{pTagid}, '%') order by p.p_online desc")
    List<com.hxzk.deo.TbPerson> findAllsearch(com.hxzk.deo.TbPerson person);

    @Select("SELECT p.id,p.p_name,p.p_tagid,p.p_sex,p.p_minzu,p.p_phone,p.p_department,p.p_ban,p.p_zu,p.p_idcardnum,p.p_adress,p.p_canin,p.p_x,p.p_y,p.p_floor,p.p_sos,p.p_online,p.p_power,p.p_kaoqing,p.p_fence,p.p_fencename,p.p_kaoqqingname,p.p_image,p.p_addtiem,p.p_power_wanig,p.p_sousuo,p.p_shipin,p.p_shipingname,p.baoliu1,p.baoliu2,p.baoliu3,p.baoliu4,p.baoliu5,p.baoliu6,p.baoliu7,p.baoliu8,p.baoliu9,p.baoliu10,p.baoliu11,p.baoliu12,p.baoliu13,p.baoliu14,p.baoliu15,p.baoliu16,p.baoliu17,p.baoliu18,p.baoliu19,p.baoliu20,p.baoliu21,p.baoliu22,p.baoliu23,p.baoliu24,p.baoliu25,p.baoliu26,p.baoliu27,p.baoliu28,p.baoliu29,p.baoliu30,p.baoliu31,p.baoliu32,p.baoliu33,p.baoliu34,p.baoliu35,p.baoliu36,p.baoliu37,p.baoliu38,p.baoliu39,p.baoliu40,t.version AS VERSION FROM tb_person p INNER JOIN tb_tag t ON t.tag_id = p.p_tagid WHERE p.p_department = #{pTagid}  and p.p_online = '1'")
    List<com.hxzk.deo.TbPerson> findAllsearchDepart(com.hxzk.deo.TbPerson person);

    @Select("SELECT p.id,p.p_name,p.p_tagid,p.p_sex,p.p_minzu,p.p_phone,p.p_department,p.p_ban,p.p_zu,p.p_idcardnum,p.p_adress,p.p_canin,p.p_x,p.p_y,p.p_floor,p.p_sos,p.p_online,p.p_power,p.p_kaoqing,p.p_fence,p.p_fencename,p.p_kaoqqingname,p.p_image,p.p_addtiem,p.p_power_wanig,p.p_sousuo,p.p_shipin,p.p_shipingname,p.baoliu1,p.baoliu2,p.baoliu3,p.baoliu4,p.baoliu5,p.baoliu6,p.baoliu7,p.baoliu8,p.baoliu9,p.baoliu10,p.baoliu11,p.baoliu12,p.baoliu13,p.baoliu14,p.baoliu15,p.baoliu16,p.baoliu17,p.baoliu18,p.baoliu19,p.baoliu20,p.baoliu21,p.baoliu22,p.baoliu23,p.baoliu24,p.baoliu25,p.baoliu26,p.baoliu27,p.baoliu28,p.baoliu29,p.baoliu30,p.baoliu31,p.baoliu32,p.baoliu33,p.baoliu34,p.baoliu35,p.baoliu36,p.baoliu37,p.baoliu38,p.baoliu39,p.baoliu40,t.version AS VERSION FROM tb_person p INNER JOIN tb_tag t ON t.tag_id = p.p_tagid WHERE p.p_online = '1' ")
    List<com.hxzk.deo.TbPerson> findAllsearchState(com.hxzk.deo.TbPerson person);
    //百度
    @Select("SELECT p.p_tagid,p.p_name,p.p_power,p.baoliu19,p_online,p.p_image,p.baoliu2,p.baoliu3,p.baoliu4,p.p_sos,p.p_floor,p.p_addtiem,d.departmentName AS bumen1, d.baoliu5 AS bumencolor,p_sousuo,p.baoliu35,p.baoliu7 FROM tb_person p INNER JOIN tb_department d ON p.p_department = d.departmentName where p.p_online = 1")
    List<TbPersonAndDepartment> findAllBuMen();
    @Select("SELECT p.p_tagid,p.p_name,p.p_power,p.baoliu19,p_online,p.p_image,p.baoliu2,p.baoliu3,p.baoliu4,p.p_sos,p.p_floor,p.p_addtiem,d.departmentName AS bumen1, d.baoliu5 AS bumencolor,p_sousuo FROM tb_person p INNER JOIN tb_department d ON p.p_department = d.departmentName")
    List<TbPersonAndDepartment> findAllBuMenLiXianNoXiaoShi();
    @Select("SELECT p.p_tagid,p.p_name,p.p_power,p_online,p.baoliu19,p.p_image,p.baoliu2,p.baoliu3,p.baoliu4,p.p_sos,p.p_addtiem,d.departmentName AS bumen1, d.baoliu5 AS bumencolor FROM tb_person p INNER JOIN tb_department d ON p.p_department = d.departmentName where p.p_online = 0")
    List<TbPersonAndDepartment> findAllBuMenNoOnLine();

    @Select("SELECT p.p_tagid,p.p_power,p.p_name,p_online,p.p_image,p.baoliu2,p.baoliu3,p.baoliu4,p.p_sos,p.p_addtiem,d.departmentName AS bumen1, d.baoliu5 AS bumencolor FROM tb_person p INNER JOIN tb_department d ON p.p_department = d.departmentName where p.p_online = 1 and p.baoliu19 ='车载终端'")
    List<TbPersonAndDepartment> getCarGPSOnLine();

    @Select("SELECT p.p_tagid,p.p_power,p.p_name,p_online,p.p_image,p.baoliu2,p.baoliu3,p.baoliu4,p.p_sos,p.p_addtiem,d.departmentName AS bumen1, d.baoliu5 AS bumencolor FROM tb_person p INNER JOIN tb_department d ON p.p_department = d.departmentName where p.p_online = 0 and p.baoliu19 ='车载终端'")
    List<TbPersonAndDepartment> getCarGPSNoOnLine();
    @Select("select p_tagid,p_name from tb_person where baoliu19 = '系统默认' or baoliu19 = '融合终端' or baoliu19 = '心率手环' or baoliu19 = 'lora标签'")
    List<TbPerson> findAllPersons();

    @Select("select p_tagid,p_name from tb_person where baoliu19 = '车载带屏' or  baoliu19 = '车载标签' or  baoliu10 = '车载终端'")
    List<TbPerson> findAllPersonsCar();

    @Select("select p_tagid,p_name from tb_person where baoliu19 = '物资标签' ")
    List<TbPerson> findAllPersonsWuZi();

    @Select("SELECT p.p_tagid as id,p.p_name as name,p.p_online as online,p.p_image as image,p_sousuo as sudu FROM tb_person p INNER JOIN tb_department d ON p.p_department = d.departmentName")
    List<PersonCesium> findAllBuMenCesium();

    @Select("SELECT p.*, d.departmentName AS bumen1, d.baoliu5 AS bumencolor FROM tb_person p INNER JOIN tb_department d ON p.p_department = d.departmentName")
    List<TbPersonAndDepartment> findAllBuMenOffOnline();

    //二维
    @Select("SELECT p.*, d.departmentName AS bumen1, d.baoliu5 AS bumencolor FROM tb_person p INNER JOIN tb_department d ON p.p_department = d.departmentName WHERE p.p_floor = 0 AND p.p_online = 1 AND p_kaoqing = 1")
    List<TbPersonAndDepartment> findAllBuMen1(String floor);

    //三维在线
    @Select("SELECT p.*, d.departmentName AS bumen1, d.baoliu5 AS bumencolor FROM tb_person p INNER JOIN tb_department d ON p.p_department = d.departmentName where p.p_online = 1")
    List<TbPersonAndDepartment> findAllBuMen2();


    //三维离线
    @Select("SELECT p.*, d.departmentName AS bumen1, d.baoliu5 AS bumencolor FROM tb_person p INNER JOIN tb_department d ON p.p_department = d.departmentName where p.p_kaoqing = 1")
    List<TbPersonAndDepartment> findAllBuMen3();

    @Select("SELECT p.*, d.departmentName AS bumen1, d.baoliu5 AS bumencolor FROM tb_person p INNER JOIN tb_department d ON p.p_department = d.departmentName where  p.p_tagid = #{pTagid} or p.p_name = #{pTagid}")
    TbPersonAndDepartment findOnePerson(TbPersonAndDepartment personAndDepartment);

    @Select("select count(*) from tb_person")
     Integer ZiDongXiaFa();

    @Select("SELECT COUNT(*) AS p_name, baoliu39 FROM `tb_person` where p_online = '1' GROUP BY baoliu39")
    List<TbPerson> FindShowJianZhu();

    @Select("SELECT COUNT(*) AS p_name  FROM `tb_person` where baoliu39 = #{baoliu39}")
    List<TbPerson> FindShowJianZhuStop();

    @Select("select p_tagid AS tagid, p_name AS name, p_power AS power,p_phone AS phone from tb_person where p_power < 20")
    List<PowerPerson> findPowerPerson();

    @Select("select p.p_name,p.p_tagid,p.`p_sex`,p.`p_minzu`,p.p_phone,p.`p_department`,p.`p_ban`,p.`p_zu`,p.`p_idcardnum`,p.`p_adress`,p.`p_canin`,p.`p_x`,p.`p_y`,p.`p_floor`,p.`p_sos`,p.`p_online`,p.`p_power`,p.`p_image`,p.`p_addtiem`,p.baoliu2,p.baoliu3,p.baoliu4,p.baoliu5,p.baoliu6,p.baoliu7,p.baoliu8,p.baoliu9,p.baoliu10,p.baoliu11,p.baoliu12,p.baoliu13,p.baoliu14,p.baoliu15,p.baoliu16,p.baoliu17,p.baoliu18,p.baoliu19,p.baoliu20,p.baoliu21,p.baoliu22,p.baoliu23,p.baoliu24,p.baoliu25,p.baoliu26,p.baoliu27,p.baoliu28,p.baoliu29,p.baoliu30,p.baoliu31,p.baoliu32,p.baoliu33,p.baoliu34,p.baoliu35,p.baoliu36,p.baoliu37,p.baoliu38,p.baoliu39,p.baoliu40,p.baoliu41,t.`version` as baoliu42  from tb_person p inner join tb_tag t on t.`tag_id` = p.`p_tagid` where  p.`p_tagid` = #{id} or p.p_name = #{id} ")
    TbPerson findtagidPerson(String id);
}