1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
| 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);
| }
|
|
