package com.example.erp.mapper.userInfo;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.erp.entity.userInfo.User;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper

public interface UserMapper extends BaseMapper<User> {
    List<User> findAll();

    User findOne(Integer id);

    User findOneLoginName(String LoginName);

    User findOnePassWord(Integer id,String passWord);
    @Select("select count(id) FROM `user` where login_name=#{userName} and password=#{password}  ")
    int  checkUser(@Param("userName") String userName,@Param("password") String password);

    @Select("select password FROM `user` where login_name=#{userId} ")
    String getUserByID(String userId);


    Boolean register(User user);

    List<String> getUserRole(Integer id);

    Boolean userDelete(Integer id);

    Boolean updatePassWordById(Integer id,String passWord);

    Boolean updateUserNameById(Integer id,String userName);

    Boolean updateProcessMp(Integer id, String process);

    List<User> findByAddress(String userName);

    String selectOptimizeParmsById(@Param("username") String username);
}