コード例 #1
0
  protected String getJoin(String key, Object value) {
    String join = StringPool.BLANK;

    if (key.equals("contactTwitterSn")) {
      join = CustomSQLUtil.get(JOIN_BY_CONTACT_TWITTER_SN);
    } else if (key.equals("noOrganizations")) {
      join = CustomSQLUtil.get(JOIN_BY_NO_ORGANIZATIONS);
    } else if (key.equals("permission")) {
      join = CustomSQLUtil.get(JOIN_BY_PERMISSION);
    } else if (key.equals("userGroupRole")) {
      join = CustomSQLUtil.get(JOIN_BY_USER_GROUP_ROLE);
    } else if (key.equals("usersGroups")) {
      join = CustomSQLUtil.get(JOIN_BY_USERS_GROUPS);
    } else if (key.equals("usersOrgs")) {
      join = CustomSQLUtil.get(JOIN_BY_USERS_ORGS);
    } else if (key.equals("usersOrgsTree")) {
      join = CustomSQLUtil.get(JOIN_BY_USERS_ORGS_TREE);
    } else if (key.equals("usersPasswordPolicies")) {
      join = CustomSQLUtil.get(JOIN_BY_USERS_PASSWORD_POLICIES);
    } else if (key.equals("usersRoles")) {
      join = CustomSQLUtil.get(JOIN_BY_USERS_ROLES);
    } else if (key.equals("usersTeams")) {
      join = CustomSQLUtil.get(JOIN_BY_USERS_TEAMS);
    } else if (key.equals("usersUserGroups")) {
      join = CustomSQLUtil.get(JOIN_BY_USERS_USER_GROUPS);
    } else if (key.equals("announcementsDeliveryEmailOrSms")) {
      join = CustomSQLUtil.get(JOIN_BY_ANNOUNCEMENTS_DELIVERY_EMAIL_OR_SMS);
    } else if (key.equals("socialMutualRelation")) {
      join = CustomSQLUtil.get(JOIN_BY_SOCIAL_MUTUAL_RELATION);
    } else if (key.equals("socialMutualRelationType")) {
      join = CustomSQLUtil.get(JOIN_BY_SOCIAL_MUTUAL_RELATION_TYPE);
    } else if (key.equals("socialRelation")) {
      join = CustomSQLUtil.get(JOIN_BY_SOCIAL_RELATION);
    } else if (key.equals("socialRelationType")) {
      join = CustomSQLUtil.get(JOIN_BY_SOCIAL_RELATION_TYPE);
    } else if (value instanceof CustomSQLParam) {
      CustomSQLParam customSQLParam = (CustomSQLParam) value;

      join = customSQLParam.getSQL();
    }

    if (Validator.isNotNull(join)) {
      int pos = join.indexOf("WHERE");

      if (pos != -1) {
        join = join.substring(0, pos);
      }
    }

    return join;
  }
コード例 #2
0
  protected String getWhere(String key, Object value) {
    String join = StringPool.BLANK;

    if (key.equals("contactTwitterSn")) {
      join = CustomSQLUtil.get(JOIN_BY_CONTACT_TWITTER_SN);
    } else if (key.equals("noOrganizations")) {
      join = CustomSQLUtil.get(JOIN_BY_NO_ORGANIZATIONS);
    } else if (key.equals("permission")) {
      join = CustomSQLUtil.get(JOIN_BY_PERMISSION);
    } else if (key.equals("userGroupRole")) {
      join = CustomSQLUtil.get(JOIN_BY_USER_GROUP_ROLE);
    } else if (key.equals("usersGroups")) {
      join = CustomSQLUtil.get(JOIN_BY_USERS_GROUPS);
    } else if (key.equals("usersOrgs")) {
      if (value instanceof Long) {
        join = CustomSQLUtil.get(JOIN_BY_USERS_ORGS);
      } else if (value instanceof Long[]) {
        Long[] organizationIds = (Long[]) value;

        if (organizationIds.length == 0) {
          join = "WHERE ((Users_Orgs.organizationId = -1) ))";
        } else {
          StringBundler sb = new StringBundler(organizationIds.length * 2 + 1);

          sb.append("WHERE (");

          for (int i = 0; i < organizationIds.length; i++) {
            sb.append("(Users_Orgs.organizationId = ?) ");

            if ((i + 1) < organizationIds.length) {
              sb.append("OR ");
            }
          }

          sb.append(")");

          join = sb.toString();
        }
      }
    } else if (key.equals("usersOrgsTree")) {
      List<Organization> organizationsTree = (List<Organization>) value;

      int size = organizationsTree.size();

      if (size > 0) {
        StringBundler sb = new StringBundler(size * 2 + 1);

        sb.append("WHERE (");

        for (int i = 0; i < size; i++) {
          sb.append("(Organization_.treePath LIKE ?) ");

          if ((i + 1) < size) {
            sb.append("OR ");
          }
        }

        sb.append(")");

        join = sb.toString();
      }
    } else if (key.equals("usersPasswordPolicies")) {
      join = CustomSQLUtil.get(JOIN_BY_USERS_PASSWORD_POLICIES);
    } else if (key.equals("usersRoles")) {
      join = CustomSQLUtil.get(JOIN_BY_USERS_ROLES);
    } else if (key.equals("usersTeams")) {
      join = CustomSQLUtil.get(JOIN_BY_USERS_TEAMS);
    } else if (key.equals("usersUserGroups")) {
      join = CustomSQLUtil.get(JOIN_BY_USERS_USER_GROUPS);
    } else if (key.equals("announcementsDeliveryEmailOrSms")) {
      join = CustomSQLUtil.get(JOIN_BY_ANNOUNCEMENTS_DELIVERY_EMAIL_OR_SMS);
    } else if (key.equals("socialMutualRelation")) {
      join = CustomSQLUtil.get(JOIN_BY_SOCIAL_MUTUAL_RELATION);
    } else if (key.equals("socialMutualRelationType")) {
      join = CustomSQLUtil.get(JOIN_BY_SOCIAL_MUTUAL_RELATION_TYPE);
    } else if (key.equals("socialRelation")) {
      join = CustomSQLUtil.get(JOIN_BY_SOCIAL_RELATION);
    } else if (key.equals("socialRelationType")) {
      join = CustomSQLUtil.get(JOIN_BY_SOCIAL_RELATION_TYPE);
    } else if (value instanceof CustomSQLParam) {
      CustomSQLParam customSQLParam = (CustomSQLParam) value;

      join = customSQLParam.getSQL();
    }

    if (Validator.isNotNull(join)) {
      int pos = join.indexOf("WHERE");

      if (pos != -1) {
        join = join.substring(pos + 5, join.length()).concat(" AND ");
      } else {
        join = StringPool.BLANK;
      }
    }

    return join;
  }