@Override public Currency getCurrency() { if (currency == null) { return null; } else { return Currency.valueOf(currency); } }
@Override public BusinessInvoiceModelDao map(final int index, final ResultSet r, final StatementContext ctx) throws SQLException { final UUID invoiceId = UUID.fromString(r.getString(1)); final Integer invoiceNumber = r.getInt(2); final DateTime createdDate = new DateTime(r.getLong(3), DateTimeZone.UTC); final DateTime updatedDate = new DateTime(r.getLong(4), DateTimeZone.UTC); final UUID accountId = UUID.fromString(r.getString(5)); final String accountKey = r.getString(6); final LocalDate invoiceDate = getDate(r, "invoice_date"); final LocalDate targetDate = getDate(r, "target_date"); final Currency currency = Currency.valueOf(r.getString(9)); final BigDecimal balance = BigDecimal.valueOf(r.getDouble(10)); final BigDecimal amountPaid = BigDecimal.valueOf(r.getDouble(11)); final BigDecimal amountCharged = BigDecimal.valueOf(r.getDouble(12)); final BigDecimal amountCredited = BigDecimal.valueOf(r.getDouble(13)); return new BusinessInvoiceModelDao(accountId, accountKey, amountCharged, amountCredited, amountPaid, balance, createdDate, currency, invoiceDate, invoiceId, invoiceNumber, targetDate, updatedDate); } }
final DateTime effectiveDate = new DateTime(r.getLong(8), DateTimeZone.UTC); final BigDecimal amount = BigDecimal.valueOf(r.getDouble(9)); final Currency currency = Currency.valueOf(r.getString(10)); final String paymentError = r.getString(11); final String processingStatus = r.getString(12);
@Override public BusinessInvoiceItemModelDao map(final int index, final ResultSet r, final StatementContext ctx) throws SQLException { final UUID itemId = getUUID(r, "item_id"); final UUID linkedItemId = getUUID(r, "linked_item_id"); final DateTime createdDate = new DateTime(r.getLong("created_date"), DateTimeZone.UTC); final DateTime updatedDate = new DateTime(r.getLong("updated_date"), DateTimeZone.UTC); final UUID invoiceId = getUUID(r, "invoice_id"); final String itemType = r.getString("item_type"); final String externalKey = r.getString("external_key"); final String productName = r.getString("product_name"); final String productType = r.getString("product_type"); final String productCategory = r.getString("product_category"); final String slug = r.getString("slug"); final String phase = r.getString("phase"); final String billingPeriod = r.getString("billing_period"); final LocalDate startDate = getDate(r, "start_date"); final LocalDate endDate = getDate(r, "end_date"); final BigDecimal amount = BigDecimal.valueOf(r.getDouble("amount")); final Currency currency = Currency.valueOf(r.getString("currency")); return new BusinessInvoiceItemModelDao(amount, billingPeriod, createdDate, currency, endDate, externalKey, invoiceId, itemId, linkedItemId, itemType, phase, productCategory, productName, productType, slug, startDate, updatedDate); } }