package com.weiwojc.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.weiwojc.model.entity.User;
import org.apache.ibatis.annotations.*;

@Mapper
public interface UserMapper extends BaseMapper<User> {
    
    @Select("SELECT * FROM user WHERE username = #{username} AND is_deleted = 0")
    User findByUsername(String username);

    @Select("SELECT * FROM user WHERE user_id = #{userId} AND is_deleted = 0")
    User findById(Long userId);

    @Update("UPDATE user SET last_login = #{lastLogin} WHERE user_id = #{userId}")
    int updateLastLogin(@Param("userId") Long userId, @Param("lastLogin") java.time.LocalDateTime lastLogin);

    @Update("UPDATE user SET login_attempts = #{attempts}, locked_until = #{lockedUntil} WHERE user_id = #{userId}")
    int updateLoginAttempts(@Param("userId") Long userId, 
                          @Param("attempts") Integer attempts, 
                          @Param("lockedUntil") java.time.LocalDateTime lockedUntil);

    @Update("UPDATE user SET login_attempts = 0, locked_until = null WHERE username = #{username}")
    int resetLoginAttempts(String username);
}