package com.oying.modules.system.mapper; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.oying.modules.system.domain.User; import com.oying.modules.system.domain.dto.UserQueryCriteria; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import org.apache.ibatis.annotations.Select; import java.util.Date; import java.util.List; import java.util.Set; /** * @author Z * @date 2023-06-20 */ @Mapper public interface UserMapper extends BaseMapper { Long countAll(@Param("criteria") UserQueryCriteria criteria); List findAll(@Param("criteria") UserQueryCriteria criteria); IPage findAll(@Param("criteria") UserQueryCriteria criteria, Page page); User findByUsername(@Param("username") String username); User findByOpenid(@Param("openid") String openid); User findByEmail(@Param("email") String email); User findByPhone(@Param("phone") String phone); @Select("update sys_user set password = #{password} , pwd_reset_time = #{lastPasswordResetTime} where username = #{username}") void updatePass(@Param("username") String username, @Param("password") String password, @Param("lastPasswordResetTime") Date lastPasswordResetTime); @Select("update sys_user set email = #{email} where username = #{username}") void updateEmail(@Param("username") String username, @Param("email") String email); List findByRoleId(@Param("roleId") Long roleId); List findByRoleDeptId(@Param("deptId") Long deptId); List findByMenuId(@Param("menuId") Long menuId); int countByJobs(@Param("jobIds") Set jobIds); int countByDepts(@Param("deptIds") Set deptIds); int countByRoles(@Param("roleIds") Set roleIds); void resetPwd(@Param("userIds") Set userIds, @Param("pwd") String pwd); }