Esempio n. 1
0
  @CacheName(AppConstants.DEFAULT_CACHENAME)
  public void role() {
    User user = SubjectUtils.me().getUser();
    keepPara("user_search");

    // 查询当前用户的角色
    UserRole userRole = UserRole.dao.findFirstBy("`userRole`.user_id=" + user.get("id"));
    // 当前用户的子集角色
    List<Role> roles =
        Role.dao.findChildrenById("`role`.deleted_at is null", userRole.get("role_id"));
    roles.add(0, user.getRole());
    if (!ValidateUtils.me().isNullOrEmpty(roles)) setAttr("role", user.getRole());

    List<Permission> authories = Permission.dao.findBy("`permission`.deleted_at is NULL");
    setAttr("rolestree", TreeUtils.toTree(roles));
    setAttr("permissionestree", TreeUtils.toTreeLevel(authories, 2));

    dynaRender("/view/admin/role.ftl");
  }
Esempio n. 2
0
  @CacheName(AppConstants.DEFAULT_CACHENAME)
  public void user() {
    User user = SubjectUtils.me().getUser();
    keepPara("user_search");

    // 查询当前用户的角色
    UserRole userRole = UserRole.dao.findFirstBy("`userRole`.user_id=" + user.get("id"));
    // 当前用户的子集角色
    List<Role> roles =
        Role.dao.findChildrenById("`role`.deleted_at is null", userRole.get("role_id"));
    String roleIds = "";
    if (roles != null) {
      int size = roles.size();
      int i = 0;
      for (Role role : roles) {
        roleIds += role.get("id");
        if (i < size - 1) {
          roleIds += ",";
        }
        i++;
      }
    }
    // 只能查询当前用户以下的角色
    String where =
        " `user`.id <> " + user.get("id") + " AND `userRole`.role_id in (" + roleIds + ")";
    String user_search = getPara("user_search");
    if (!ValidateUtils.me().isNullOrEmpty(user_search)) {
      where +=
          " AND (INSTR(`user`.username,'"
              + user_search
              + "')>0 OR  INSTR(`user`.full_name,'"
              + user_search
              + "')>0 "
              + "OR  INSTR(`user`.mobile,'"
              + user_search
              + "')>0 OR  INSTR(`province`.name,'"
              + user_search
              + "')>0 "
              + "OR  INSTR(`city`.name,'"
              + user_search
              + "')>0 OR  INSTR(`county`.name,'"
              + user_search
              + "')>0 "
              + "OR INSTR(`userInfo`.street,'"
              + user_search
              + "')>0 OR INSTR(`userInfo`.zip_code,'"
              + user_search
              + "')>0 "
              + "OR INSTR(`user`.created_at,'"
              + user_search
              + "')>0 OR INSTR(`user`.email,'"
              + user_search
              + "')>0) ";
    }
    //        String start_at = getPara("start_at");
    //        if (ValidateUtils.me().isDateTime(start_at)) {
    //            where += " AND `user`.created_at >= '" + start_at + "'";
    //        }
    //
    //        String end_at = getPara("end_time");
    //        if (ValidateUtils.me().isDateTime(end_at)) {
    //            where += " AND `user`.created_at <= '" + end_at + "'";
    //        }
    //
    //        Boolean deleted = getParaToBoolean("deleted");
    //        if (!ValidateUtils.me().isNullOrEmpty(deleted) && deleted) {
    //            where += " AND `user`.deleted_at is not null";
    //        } else {
    //            where += " AND `user`.deleted_at is null";
    //        }

    Page<User> users =
        User.dao.paginateInfoBy(getParaToInt(0, 1), getParaToInt("pageSize", 15), where);
    Map userGroup = SortUtils.me().sort(users.getList(), "last_name");

    setAttr("roles", roles);
    setAttr("users", users);
    setAttr("userGroup", userGroup);
    setAttr("userStates", State.dao.findBy("`state`.type='user.state'"));
    dynaRender("/view/admin/user.ftl");
  }