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,anchorname 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,anchorname 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 e.*,TbEquipment.onlie from tb_evrydayweiyi_${datey} e JOIN tb_equipment TbEquipment ON TbEquipment.tagid = e.tagid where e.tagid=#{tagid} AND e.filename = #{date1} ")
    public TbEvrydayweiyi2024 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_evrydayweiyi_${date} where tagid=#{tagid} order by filename desc limit 1")
    public TbEvrydayweiyi2024 getonedesc(@Param("date")String date,@Param("tagid")String tagid);
}