예제 #1
0
  private boolean checkPermissionAccessIfAny() {
    ViewPermission viewPermission = this.getClass().getAnnotation(ViewPermission.class);
    if (viewPermission != null) {
      String permissionId = viewPermission.permissionId();
      int impliedPermissionVal = viewPermission.impliedPermissionVal();

      if (AppContext.isAdmin()) {
        return true;
      } else {
        PermissionMap permissionMap = AppContext.getPermissionMap();
        if (permissionMap == null) {
          return false;
        } else {
          Integer value = permissionMap.get(permissionId);
          if (value == null) {
            return false;
          } else {
            return PermissionChecker.isImplied(value, impliedPermissionVal);
          }
        }
      }
    } else {
      return true;
    }
  }
  public void migrate(JdbcTemplate jdbcTemplate) throws Exception {
    LOG.info("Set up initial values");

    LOG.debug("Insert default billing plan");
    SimpleJdbcInsert billingJdbcInsert =
        new SimpleJdbcInsert(jdbcTemplate)
            .withTableName("s_billing_plan")
            .usingColumns(
                "billingType",
                "numUsers",
                "volume",
                "numProjects",
                "pricing",
                "hasBugEnable",
                "hasStandupMeetingEnable",
                "hasTimeTracking")
            .usingGeneratedKeyColumns("id");

    Map<String, Object> billingParameters = new HashMap<>();
    billingParameters.put("billingType", "Community");
    billingParameters.put("numUsers", 99999999);
    billingParameters.put("volume", 999999999999L);
    billingParameters.put("numProjects", 999999);
    billingParameters.put("pricing", 0);
    billingParameters.put("hasBugEnable", Boolean.TRUE);
    billingParameters.put("hasStandupMeetingEnable", Boolean.TRUE);
    billingParameters.put("hasTimeTracking", Boolean.TRUE);

    Number billingPlanId = billingJdbcInsert.executeAndReturnKey(billingParameters);

    LOG.debug("Insert default account");
    SimpleJdbcInsert accountJdbcInsert =
        new SimpleJdbcInsert(jdbcTemplate)
            .withTableName("s_account")
            .usingColumns("status", "billingPlanId", "paymentMethod", "subdomain")
            .usingGeneratedKeyColumns("id");
    Map<String, Object> accountParameters = new HashMap<>();
    accountParameters.put("status", "Active");
    accountParameters.put("billingPlanId", billingPlanId);
    accountParameters.put("paymentMethod", "None");
    accountParameters.put("subdomain", "");
    Number accountId = accountJdbcInsert.executeAndReturnKey(accountParameters);

    LOG.debug("Insert default users");
    SimpleJdbcInsert userJdbcInsert =
        new SimpleJdbcInsert(jdbcTemplate)
            .withTableName("s_user")
            .usingColumns(
                "username",
                "firstname",
                "lastname",
                "email",
                "status",
                "registeredTime",
                "password",
                "timezone");
    Date nowDate = DateTimeUtils.convertDateTimeToUTC(new GregorianCalendar().getTime());
    String timezoneDbId = TimezoneMapper.getTimezoneDbId(TimeZone.getDefault());

    Map<String, Object> userParameters = new HashMap<>();
    userParameters.put("username", "*****@*****.**");
    userParameters.put("firstname", "");
    userParameters.put("lastname", "admin");
    userParameters.put("email", "*****@*****.**");
    userParameters.put("status", "Active");
    userParameters.put("registeredTime", nowDate);
    userParameters.put("password", PasswordEncryptHelper.encryptSaltPassword("admin123"));
    userParameters.put("timezone", timezoneDbId);
    userJdbcInsert.execute(userParameters);

    LOG.debug("Insert default user avatar");

    LOG.debug("Create associate between user and billing plan");
    SimpleJdbcInsert userAccountJdbcInsert =
        new SimpleJdbcInsert(jdbcTemplate)
            .withTableName("s_user_account")
            .usingColumns(
                "username", "accountId", "isAccountOwner", "registeredTime", "registerStatus")
            .usingGeneratedKeyColumns("id");
    Map<String, Object> userAccountParameters = new HashMap<>();
    userAccountParameters.put("username", "*****@*****.**");
    userAccountParameters.put("accountId", accountId);
    userAccountParameters.put("isAccountOwner", Boolean.TRUE);
    userAccountParameters.put("registeredTime", nowDate);
    userAccountParameters.put("registerStatus", "Active");

    userAccountJdbcInsert.executeAndReturnKey(userAccountParameters);

    LOG.debug("Insert default roles");
    SimpleJdbcInsert roleJdbcInsert =
        new SimpleJdbcInsert(jdbcTemplate)
            .withTableName("s_roles")
            .usingColumns("rolename", "description", "sAccountId", "isSystemRole")
            .usingGeneratedKeyColumns("id");

    LOG.debug("Create default admin role");
    SqlParameterSource adminRoleParameters =
        new MapSqlParameterSource()
            .addValue("rolename", "Administrator")
            .addValue("description", "Admin Role")
            .addValue("sAccountId", accountId)
            .addValue("isSystemRole", Boolean.TRUE);
    Number adminRoleId = roleJdbcInsert.executeAndReturnKey(adminRoleParameters);

    LOG.debug("Create default employee role");
    SqlParameterSource employeeRoleParameters =
        new MapSqlParameterSource()
            .addValue("rolename", "Employee")
            .addValue("description", "Employee Role")
            .addValue("sAccountId", accountId)
            .addValue("isSystemRole", Boolean.TRUE);
    Number employeeRoleId = roleJdbcInsert.executeAndReturnKey(employeeRoleParameters);

    LOG.debug("Create default guest role");
    SqlParameterSource guestRoleParameters =
        new MapSqlParameterSource()
            .addValue("rolename", "Guest")
            .addValue("description", "Guest Role")
            .addValue("sAccountId", accountId)
            .addValue("isSystemRole", Boolean.TRUE);
    Number guestRoleId = roleJdbcInsert.executeAndReturnKey(guestRoleParameters);

    LOG.debug("Associate permission with admin role");
    SimpleJdbcInsert rolePermissionJdbcInsert =
        new SimpleJdbcInsert(jdbcTemplate)
            .withTableName("s_role_permission")
            .usingColumns("roleid", "roleVal")
            .usingGeneratedKeyColumns("id");

    SqlParameterSource adminRolePermissionParameters =
        new MapSqlParameterSource()
            .addValue("roleid", adminRoleId)
            .addValue("roleVal", PermissionMap.buildAdminPermissionCollection().toJsonString());
    rolePermissionJdbcInsert.execute(adminRolePermissionParameters);

    LOG.debug("Associate permission with employee role");
    SqlParameterSource employeeRolePermissionParameters =
        new MapSqlParameterSource()
            .addValue("roleid", employeeRoleId)
            .addValue("roleVal", PermissionMap.buildEmployeePermissionCollection().toJsonString());
    rolePermissionJdbcInsert.execute(employeeRolePermissionParameters);

    LOG.debug("Associate permission with guest role");
    SqlParameterSource guestRolePermissionParameters =
        new MapSqlParameterSource()
            .addValue("roleid", guestRoleId)
            .addValue("roleVal", PermissionMap.buildGuestPermissionCollection().toJsonString());
    rolePermissionJdbcInsert.execute(guestRolePermissionParameters);
  }