package com.hxzkappboot.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.hxzkappboot.pojo.TbAchor;
|
import com.hxzkappboot.pojo.TbFakaji;
|
import com.hxzkappboot.pojo.TbFence;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.util.List;
|
|
|
/**
|
* <p>
|
* Mapper 接口
|
* </p>
|
*
|
* @author wangfei
|
* @since 2024-11-26
|
*/
|
public interface TbFakajiMapper extends BaseMapper<TbFakaji> {
|
|
@Select("SELECT f.*,c.cabinetname as cabinetname FROM tb_fakaji f LEFT JOIN tb_cabinet c ON f.deviceid=c.cabinetnum GROUP BY f.deviceid")
|
List<TbFakaji> getfakjigui();
|
|
}
|
