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);
}