package cn.iocoder.yudao.server.dal.mysql;

import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
import cn.iocoder.yudao.framework.tenant.core.aop.TenantIgnore;
import cn.iocoder.yudao.server.controller.admin.vo.IotOaPersonRespVO;
import cn.iocoder.yudao.server.dal.dataobject.TDDeviceDO;
import com.baomidou.dynamic.datasource.annotation.DS;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.sql.Timestamp;
import java.util.List;

/**
 * @author yc
 * @version 1.0
 * @className TDDeviceMapper
 * @description
 */
@Mapper
public interface PmsMapper extends BaseMapperX<TDDeviceDO> {
    @Select("SELECT * FROM rq_iot_oa_person WHERE workcode ='${workcode}'")
    @DS("pms")
    @TenantIgnore
    List<IotOaPersonRespVO> selectOaPersonByCode(@Param("workcode") String workcode);


}
