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