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
| package com.hxzkmonitor.mapper;
|
| import com.baomidou.mybatisplus.core.metadata.IPage;
| import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
| import com.hxzkmonitor.pojo.TbEvrydayweiyi2024;
| import com.baomidou.mybatisplus.core.mapper.BaseMapper;
| import org.apache.ibatis.annotations.Param;
| import org.apache.ibatis.annotations.Select;
|
| import java.util.List;
| import java.util.Map;
|
| /**
| * <p>
| * Mapper 接口
| * </p>
| *
| * @author wangfei
| * @since 2024-08-05
| */
| public interface TbEvrydayweiyi2024Mapper extends BaseMapper<TbEvrydayweiyi2024> {
|
| IPage<Map> getResidentInfoByPage(Page<TbEvrydayweiyi2024> page);
|
| @Select("SELECT TbEquipment.*, e.tagid\n" +
| "FROM tb_equipment TbEquipment\n" +
| "JOIN tb_evrydayweiyi_2024 e ON TbEquipment.tagid = e.tagid\n" +
| "WHERE TbEquipment.companyid = #{companyid} ORDER BY addtime DESC;")
| public List<TbEvrydayweiyi2024> listall(@Param("companyid")Integer companyid );
|
|
| @Select("select id,tagid,ed,nd,td,end,edmm,ndmm,tdmm,endmm,gpsnum,filename,power,jingdu,weidu,gaodu,addtime from tb_evrydayweiyi_${datey} where filename BETWEEN #{date1} AND #{date2}")
| public List<TbEvrydayweiyi2024> listx2(@Param("datey")String datey , @Param("date1")String date1, @Param("date2")String date2);
|
| @Select("select id,tagid,ed,nd,td,end,edmm,ndmm,tdmm,endmm,gpsnum,filename,power,jingdu,weidu,gaodu,addtime from tb_evrydayweiyi_${datey} where tagid=#{tagid} AND filename BETWEEN #{date1} AND #{date2}")
| public List<TbEvrydayweiyi2024> listx3(@Param("datey")String datey ,@Param("tagid")String tagid, @Param("date1")String date1, @Param("date2")String date2);
|
|
| @Select("select id,tagid,ed,nd,td,end,edmm,ndmm,tdmm,endmm,gpsnum,filename,power,jingdu,weidu,gaodu,addtime from tb_evrydayweiyi_${date} where tagid=#{tagid} order by filename desc limit 1")
| public TbEvrydayweiyi2024 getonedesc(@Param("date")String date,@Param("tagid")String tagid);
| }
|
|
