package com.cloud.user.dao;

import java.util.List;
import java.util.Map;

import com.cloud.user.model.OrgNameAppUser;
import org.apache.ibatis.annotations.*;

import com.cloud.model.sys.AppUser;

@Mapper
public interface AppUserDao {

	//@Options(useGeneratedKeys = true, keyProperty = "id")
	//@Insert("insert into app_user(username, password, nickname, headImgUrl, phone, sex, enabled, type, createTime, updateTime) "
			//+ "values(#{username}, #{password}, #{nickname}, #{headImgUrl}, #{phone}, #{sex}, #{enabled}, #{type}, #{createTime}, #{updateTime})")
	Long save(AppUser appUser);

	int update(AppUser appUser);

	@Select("select * from app_user t where t.username = #{username} and t.delFlag='0'")
	AppUser findByUsername(String username);

	//@Select("select * from app_user t where t.id = #{id}")
	AppUser findById(Map<String,Object> params);

	AppUser login(Map<String,Object> params);

	int count(Map<String, Object> params);

	List<OrgNameAppUser> findData(Map<String, Object> params);

	@Select("select id from app_user t where t.username = #{username} and t.orgId = #{orgId} and t.delFlag='0'")
	Long findUserId(@Param("username") String username, @Param("orgId") Long orgId);

	@Update("update app_user set delFlag = 1 where id = #{id}")
	Integer deleteAppUser(Map<String, Object> params);

	@Update("update app_user set delFlag = 1,updateTime = now() where orgId = #{id}")
    void deleteAppUserByOrgId(String id);

	//通过组织机构id查询该机构下的所有人员
	List<AppUser> findDataByOfficeId(Map<String, Object> params);

	//组织机构变更
	int updateOfficeId(Map<String, Object> params);
}