package com.hxzk.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.hxzk.pojo.TbKaoqing;
import com.hxzk.service.KaoQinService;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface KaoQinDao extends BaseMapper<TbKaoqing> {


    @Select("select * from tb_kaoqing_${nyr}")
    public List<TbKaoqing> findAllKaoQin(String nyr);

    @Select("select * from tb_kaoqing_${name} where intime >= #{intime} ${bumen} where outtime <= #{outtime}")
    public List<TbKaoqing> findSearchTime(TbKaoqing kaoqing);

    @Select("SELECT * FROM tb_kaoqing_${name} WHERE name = #{tagid} or tagid = #{tagid}  UNION SELECT * FROM tb_kaoqing_${bumen} WHERE name = #{tagid} or tagid = #{tagid}  and intime >= #{intime} and outtime <= #{outtime}")
    public List<TbKaoqing> findSearch(TbKaoqing kaoqing);
}