hust-epi/whepi-web/src/main/java/com/bofeng/dao/OutUserMapper.java

package com.bofeng.dao;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.bofeng.entity.OutUser;
import com.yvan.PageDb;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;

@Mapper
@Repository
public interface OutUserMapper extends BaseMapper<OutUser> {


    @Select("SELECT * FROM out_user WHERE name = #{name} and phone = #{phone} and start_date <= curdate() and end_date >= curdate()")
    OutUser getOutUserByPhone(@Param("name") String name, @Param("phone") Long phone);

    @Select("SELECT * FROM out_user WHERE phone = #{phone} and start_date <= curdate() and end_date >= curdate()")
    OutUser queryOutUserByPhone(@Param("phone") Long phone);

    List<OutUser> getAllOutUser(PageDb pageDb, Map<String, Object> queryParam);

    Integer deleteOutUsers(@Param("ids") String ids);
}