package yangtz.cs.liu.campus.mapper.notificationGroup;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import yangtz.cs.liu.campus.domain.notificationGroup.SchoolNotificationUser;

/**
 * 通知组(SchoolNotificationGroup)表数据库访问层
 *
 * @author zxw
 * @since 2023-08-18 11:04:48
 */
@Mapper
public interface SchoolNotificationUserMapper extends BaseMapper<SchoolNotificationUser> {


  @Select(" select * from school_notification_user u where u.notification_id=#{notificationId} and u.user_id=#{userId} and u.del_flag=0  ")
  SchoolNotificationUser getOneNotificationUser(@Param("notificationId") Long notificationId,@Param("userId") Long userId);

}

