Пример #1
0
  @Override
  public SettingsVO selectFinanacialSettings(int communityId) throws DbException {
    DataSet dataSet =
        dbSession.executeQuery(SELECT_FINANCIAL_SETTINGS_BY_COMMUNITY_ID, communityId);
    SettingsVO settingsVO = new SettingsVO();

    settingsVO.setBasicMaintenanceChargeEnabled(
        stringToBoolean(
            StringUtil.getStringValue(
                dataSet.getIntValue(0, "BASIC_MAINTENANCE_CHARGES_ENABLED"))));

    settingsVO.setBasicMaintenanceChargeType(
        ChargeType.getChargeType((dataSet.getIntValue(0, "MAINTENANCE_CHARGE_TYPE"))));

    settingsVO.setMonthlyMaintenanceRate(dataSet.getDoubleValue(0, "MONTHLY_MAINTENANCE_RATE"));

    settingsVO.setLatePaymentPenaltyEnabled(
        stringToBoolean(
            StringUtil.getStringValue(dataSet.getIntValue(0, "LATE_PAYMENT_PENALTY_ENABLED"))));

    settingsVO.setLatePaymentChargeType(
        ChargeType.getChargeType((dataSet.getIntValue(0, "LATE_PAYMENT_PENALTY_CHARGE_TYPE"))));

    settingsVO.setLatePaymentPenaltyAmount(
        dataSet.getDoubleValue(0, "LATE_PAYMENT_PENALTY_AMOUNT"));
    settingsVO.setLatePaymentMinimumBalance(
        dataSet.getDoubleValue(0, "LATE_PAYMENT_MINIMUM_BALANCE"));
    settingsVO.setLatePaymentCalculationDay(dataSet.getIntValue(0, "LATE_PAYMENT_CALCULATION_DAY"));
    settingsVO.setLatePaymentDisplayDay(dataSet.getIntValue(0, "LATE_PAYMENT_DISPLAY_DAY"));
    settingsVO.setLatePaymentReminderDays(dataSet.getIntValue(0, "LATE_PAYMENT_REMINDER_DAYS"));

    settingsVO.setChequeBouncePenaltyEnabled(
        stringToBoolean(
            StringUtil.getStringValue(dataSet.getIntValue(0, "CHEQUE_BOUNCE_PENALTY_ENABLED"))));

    settingsVO.setChequePenaltyChargeType(
        ChargeType.getChargeType((dataSet.getIntValue(0, "CHEQUE_BOUNCE_PENALTY_CHARGE_TYPE"))));
    settingsVO.setChequeBouncePenaltyAmount(
        dataSet.getDoubleValue(0, "CHEQUE_BOUNCE_PENALTY_AMOUNT"));

    return settingsVO;
  }
Пример #2
0
  @Override
  public SettingsVO selectSystemSettings(int communityId) throws DbException {
    DataSet dataSet = dbSession.executeQuery(SELECT_SYSTEM_SETTINGS_BY_COMMUNITY_ID, communityId);

    SettingsVO settingsVO = new SettingsVO();

    settingsVO.setBillGenerationDay(dataSet.getIntValue(0, "BILL_GENERATION_DAY"));
    settingsVO.setAutoBillGenerationEnabled(
        stringToBoolean(
            StringUtil.getStringValue(dataSet.getIntValue(0, "AUTO_BILL_GENERATION_ENABLED"))));
    settingsVO.setCommunicationEnabled(
        stringToBoolean(
            StringUtil.getStringValue(dataSet.getIntValue(0, "COMMUNICATION_ENABLED"))));

    /* SMS related stuff */
    settingsVO.setSmsEnabled(
        stringToBoolean(StringUtil.getStringValue(dataSet.getIntValue(0, "SMS_ENABLED"))));
    settingsVO.setSmsGatewayType(
        GatewayType.getGatewayType(dataSet.getIntValue(0, "SMS_GATEWAY_TYPE")));
    settingsVO.setSmsGatewayUsername(dataSet.getStringValue(0, "SMS_GATEWAY_USERNAME"));
    settingsVO.setSmsGatewayPassword(dataSet.getStringValue(0, "SMS_GATEWAY_PASSWORD"));
    settingsVO.setSmsGatewaySource(dataSet.getStringValue(0, "SMS_GATEWAY_SOURCE"));

    /* Email related stuff */
    settingsVO.setEmailEnabled(
        stringToBoolean(StringUtil.getStringValue(dataSet.getIntValue(0, "EMAIL_ENABLED"))));
    settingsVO.setEmailGatewayType(
        GatewayType.getGatewayType(dataSet.getIntValue(0, "EMAIL_GATEWAY_TYPE")));
    settingsVO.setEmailServerUsername(dataSet.getStringValue(0, "EMAIL_SERVER_USERNAME"));
    settingsVO.setEmailServerPassword(dataSet.getStringValue(0, "EMAIL_SERVER_PASSWORD"));
    settingsVO.setEmailServer(dataSet.getStringValue(0, "EMAIL_SERVER"));
    settingsVO.setEmailServerPort(dataSet.getIntValue(0, "EMAIL_SERVER_PORT"));

    settingsVO.setLastBillGeneratedDate(dataSet.getDateValue(0, "LAST_BILL_GENERATED_DATE"));
    settingsVO.setNextBillGenerationDate(dataSet.getDateValue(0, "NEXT_BILL_GENERATION_DATE"));
    settingsVO.setNextLatePaymentGenerationDate(
        dataSet.getDateValue(0, "NEXT_LATE_PAYMENT_GENERATION_DATE"));
    settingsVO.setLatePaymentReminderSent(
        stringToBoolean(
            StringUtil.getStringValue(dataSet.getIntValue(0, "LATE_PAYMENT_REMINDER_SENT"))));

    return settingsVO;
  }
Пример #3
0
  @Override
  public SettingsVO selectCommunicationSettings(int communityId) throws DbException {
    SettingsVO settingsVO = new SettingsVO();

    /* Check if communication, SMS and email communication are enabled */
    DataSet dataSet = dbSession.executeQuery(SELECT_SYSTEM_SETTINGS_BY_COMMUNITY_ID, communityId);

    settingsVO.setCommunicationEnabled(
        stringToBoolean(
            StringUtil.getStringValue(dataSet.getIntValue(0, "COMMUNICATION_ENABLED"))));
    settingsVO.setSmsEnabled(
        stringToBoolean(StringUtil.getStringValue(dataSet.getIntValue(0, "SMS_ENABLED"))));
    settingsVO.setEmailEnabled(
        stringToBoolean(StringUtil.getStringValue(dataSet.getIntValue(0, "EMAIL_ENABLED"))));

    /* Get communication information */
    dataSet = dbSession.executeQuery(SELECT_COMMUNICATION_SETTINGS_BY_COMMUNITY_ID, communityId);

    settingsVO.setBillGenerationSms(
        stringToBoolean(StringUtil.getStringValue(dataSet.getIntValue(0, "BILL_GENERATION_SMS"))));
    settingsVO.setBillGenerationEmail(
        stringToBoolean(StringUtil.getStringValue(dataSet.getIntValue(0, "BILL_GENERATION_MAIL"))));

    settingsVO.setLatePaymentReminderSms(
        stringToBoolean(
            StringUtil.getStringValue(dataSet.getIntValue(0, "LATE_PAYMENT_REMINDER_SMS"))));
    settingsVO.setLatePaymentReminderEmail(
        stringToBoolean(
            StringUtil.getStringValue(dataSet.getIntValue(0, "LATE_PAYMENT_REMINDER_MAIL"))));

    settingsVO.setLatePaymentSms(
        stringToBoolean(StringUtil.getStringValue(dataSet.getIntValue(0, "LATE_PAYMENT_SMS"))));
    settingsVO.setLatePaymentEmail(
        stringToBoolean(StringUtil.getStringValue(dataSet.getIntValue(0, "LATE_PAYMENT_MAIL"))));

    settingsVO.setPaymentSms(
        stringToBoolean(StringUtil.getStringValue(dataSet.getIntValue(0, "PAYMENTS_SMS"))));
    settingsVO.setPaymentEmail(
        stringToBoolean(StringUtil.getStringValue(dataSet.getIntValue(0, "PAYMENTS_MAIL"))));

    settingsVO.setBirthdaySms(
        stringToBoolean(StringUtil.getStringValue(dataSet.getIntValue(0, "BIRTHDAY_SMS"))));
    settingsVO.setBirthdayEmail(
        stringToBoolean(StringUtil.getStringValue(dataSet.getIntValue(0, "BIRTHDAY_MAIL"))));

    settingsVO.setAnniversarySms(
        stringToBoolean(StringUtil.getStringValue(dataSet.getIntValue(0, "ANNIVERSARY_SMS"))));
    settingsVO.setAnniversaryEmail(
        stringToBoolean(StringUtil.getStringValue(dataSet.getIntValue(0, "ANNIVERSARY_MAIL"))));

    return settingsVO;
  }