package com.qxueyou.scc.user.dao;

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

import org.springframework.stereotype.Repository;

import com.qxueyou.scc.base.dao.BaseDAO;
import com.qxueyou.scc.base.model.Pager;
import com.qxueyou.scc.base.model.Result;
import com.qxueyou.scc.base.util.ClientUtils;
import com.qxueyou.scc.base.util.CollectionUtils;
import com.qxueyou.scc.base.util.TraceUtils;
import com.qxueyou.scc.sys.model.SysPrivilege;
import com.qxueyou.scc.user.model.UserReRoleUser;
import com.qxueyou.scc.user.model.UserRole;

@Repository
public class UserRoleDAO extends BaseDAO {

	/**
	 * 获取角色列表
	 */
	public List<UserRole> getUserRoleLst(String keyword) {
		return find("from UserRole where deleteFlag is false and name like ? and topOrgId=?",
				CollectionUtils.newList("%" + keyword + "%",ClientUtils.getOrgId()), UserRole.class);
	}

	/**
	 * 获取人员列表
	 */
	public List<Map<String, Object>> getUserLstByRoleId(String roleId, Integer pageSize, Integer pageNum,
			String keyword) {
		return findListWithMapByHql(
				"select u.name as name ,u.userId  as userId ,u.account  as account,u.mobilePhone as mobilePhone ,u.password as password from User u , UserReRoleUser r where u .deleteFlag is false "
						+ "and r.deleteFlag is false and u.userId = r.userId and r.roleId =:roleId and u.name like :keyword and u.organizationId=:orgId",
				CollectionUtils.newObjectMap("roleId", roleId, "keyword", "%" + keyword + "%","orgId",ClientUtils.getOrgId()),
				new Pager(pageSize, pageNum));

	}

	/**
	 * 获取人员列表总条数
	 */
	public int getUserCount(String roleId, String keyword) {
		return findCountByComplexHql("select count(1) from User u , UserReRoleUser r where u .deleteFlag is false "
				+ "and r.deleteFlag is false and u.userId = r.userId and r.roleId =:roleId and u.name like :keyword and u.organizationId=:orgId ",
				CollectionUtils.newObjectMap("roleId", roleId, "keyword", "%" + keyword + "%","orgId",ClientUtils.getOrgId()));
	}

	/**
	 * 删除人员
	 */
	public boolean delete(String userId) {
		String[] userIds = userId.split(",");
		String deleteUserByhql = " update User set deleteFlag = true where deleteFlag is false and userId = ?";
		String deleteUserReByHql = "update UserReRoleUser  set deleteFlag =true where deleteFlag is false and userId = ?";

		Result deleteUserResult = bulkUpdateInLoop(deleteUserByhql, userIds);
		Result deleteUserReResult = bulkUpdateInLoop(deleteUserReByHql, userIds);

		if (deleteUserResult.isSuccess() && deleteUserReResult.isSuccess()) {
			return true;
		}
		return false;

	}

	/**
	 * 获取角色信息
	 */
	public List<Map<String, Object>> findMenuLstById(String roleId) {
		String hql = "select m.name as name ,m.menuId as menuId ,'1' as type from UserRole u ,SysPrivilege p ,SysMenu m where u.roleId = p.roleId and "
				+ "p.menuId = m.menuId  and u.roleId =:roleId and u.deleteFlag is false and p.deleteFlag is false ";

		return findListWithMapByHql(hql, CollectionUtils.newObjectMap("roleId", roleId));
	}

	/**
	 * 修改角色信息
	 * 
	 * @param roleId
	 * @param menuId
	 */
	public Result updateRole(String roleId, String menuIds, String name) {
		UserRole userRole = read(UserRole.class, roleId);
		userRole.setName(name);
		TraceUtils.setCreateTrace(userRole);
		save(userRole);

		bulkUpdate("update SysPrivilege set deleteFlag = true where roleId = ?", new Object[] { roleId });

		String[] menuIdArr = menuIds.split(",");

		SysPrivilege sysPrivilege = null;
		for (String menuId : menuIdArr) {
			sysPrivilege = new SysPrivilege();
			sysPrivilege.setMenuId(menuId);
			sysPrivilege.setRoleId(roleId);
			TraceUtils.setCreateTrace(sysPrivilege);
			save(sysPrivilege);
		}

		return new Result(true, "success");

	}

	/**
	 * 删除角色
	 * 
	 * @param roleId
	 * @return
	 */
	public Result deleteRole(String roleId) {

		UserRole userRole = read(UserRole.class, roleId);
		userRole.setDeleteFlag(true);
		TraceUtils.setCreateTrace(userRole);
		save(userRole);

		bulkUpdate("update SysPrivilege set deleteFlag = true where deleteFlag is  false and roleId = ?",
				new Object[] { roleId });

		return new Result(true, "success");
	}

	/**
	 * 获取所有菜单的列表
	 * 
	 * @return
	 */
	public List<Map<String, Object>> findMenuLst() {

		return findListWithMapByHql(
				"select menuId as menuId, name as name,  '1'  as type from SysMenu where deleteFlag is false ",
				CollectionUtils.newObjectMap());
	}

	/**
	 * 添加教师
	 * 
	 * @param teacherIds
	 * @param roleId
	 * @return
	 */
	public Result addTeachers(String teacherIds, String roleId) {
		UserReRoleUser userReRoleUser = null;

		String[] teacherIdArr = teacherIds.split(",");

		for (int i = 0; i < teacherIdArr.length; i++) {
			userReRoleUser = new UserReRoleUser();
			userReRoleUser.setRoleId(roleId);
			userReRoleUser.setUserId(teacherIdArr[i]);
			save(userReRoleUser);
		}

		return new Result(true);
	}
}