package com.hxzkmonitor.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.hxzkmonitor.pojo.TbTestdata20240706;
|
import com.hxzkmonitor.pojo.TbTestdata20240706;
|
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 TbTestdata20240706Mapper extends BaseMapper<TbTestdata20240706> {
|
IPage<Map> getResidentInfoByPage(Page<TbTestdata20240706> 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<TbTestdata20240706> listall(@Param("datey")String datey ,@Param("companyid")Integer companyid );
|
@Select("select * from tb_testdata_${datey} ORDER BY addtime DESC")
|
IPage<TbTestdata20240706> listall(Page<TbTestdata20240706> page, @Param("datey") String datey);
|
|
@Select("select * from tb_testdata_${datey} where tagid=#{keyword} or anchorname=#{keyword} ORDER BY addtime DESC")
|
IPage<TbTestdata20240706> seachlistall(Page<TbTestdata20240706> page, @Param("datey") String datey, @Param("keyword") String keyword);
|
|
@Select("select * from tb_testdata_${datey} where tagid=#{keyword} or anchorname=#{keyword} and companyid =#{companyid} ORDER BY addtime DESC")
|
IPage<TbTestdata20240706> seachlistallname(Page<TbTestdata20240706> page, @Param("datey") String datey, @Param("keyword") String keyword,@Param("companyid") String companyid);
|
|
@Select("select*from tb_testdata_${datey} ")
|
public List<TbTestdata20240706> listx2(@Param("datey")String datey);
|
|
@Select("select * from tb_testdata_${datey} where tagid=#{tagid}")
|
public List<TbTestdata20240706> listx3(@Param("datey")String datey ,@Param("tagid")String tagid);
|
|
@Select("select e.*,TbEquipment.onlie from tb_testdata_${datey} e JOIN tb_equipment TbEquipment ON TbEquipment.tagid = e.tagid where e.tagid=#{tagid} AND e.filename = #{date1} ")
|
public TbTestdata20240706 getweiyi(@Param("datey")String datey ,@Param("tagid")String tagid, @Param("date1")String date1);
|
|
@Select("select id,tagid,ed,nd,td,end,edmm,ndmm,tdmm,endmm,gpsnum,filename,power,jingdu,weidu,gaodu,addtime from tb_testdata_${date} where tagid=#{tagid} order by filename desc limit 1")
|
public TbTestdata20240706 getonedesc(@Param("date")String date,@Param("tagid")String tagid);
|
}
|
