package com.cloud.user.dao;
|
|
import org.apache.ibatis.annotations.*;
|
|
import com.cloud.model.sys.AppUser;
|
import com.cloud.model.sys.UserCredential;
|
|
import java.util.Map;
|
|
@Mapper
|
public interface UserCredentialsDao {
|
|
@Insert("insert into user_credentials(username, type, userId,orgId) values(#{username}, #{type}, #{userId},#{orgId})")
|
int save(UserCredential userCredential);
|
|
@Select("select * from user_credentials t where t.username = #{username} and t.userId != #{userId}")
|
UserCredential findByUsername(@Param("username") String username,@Param("userId")Long userId);
|
|
@Select("select u.* from app_user u inner join user_credentials c on c.userId = u.id where c.username = #{username}")
|
AppUser findUserByUsername(String username);
|
|
@Select("select u.* from app_user u inner join user_credentials c on c.userId = u.id where c.username = #{username} and u.delFlag=0 and u.enabled ='1' ")
|
AppUser findLoginUser(String username);
|
|
@Delete("delete from user_credentials where userId = #{id}")
|
Integer deleteAppUser(Map<String, Object> params);
|
|
@Update("REPLACE INTO user_credentials (username,type,orgId,userId) VALUES (#{username},#{type},#{orgId},#{userId})")
|
int updateUserInfo(UserCredential userCredential);
|
}
|
