Details
diff --git a/analytics/src/main/java/com/ning/billing/analytics/dao/BusinessInvoiceBinder.java b/analytics/src/main/java/com/ning/billing/analytics/dao/BusinessInvoiceBinder.java
new file mode 100644
index 0000000..ad63e3f
--- /dev/null
+++ b/analytics/src/main/java/com/ning/billing/analytics/dao/BusinessInvoiceBinder.java
@@ -0,0 +1,82 @@
+/*
+ * Copyright 2010-2012 Ning, Inc.
+ *
+ * Ning licenses this file to you under the Apache License, version 2.0
+ * (the "License"); you may not use this file except in compliance with the
+ * License. You may obtain a copy of the License at:
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
+ * WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
+ * License for the specific language governing permissions and limitations
+ * under the License.
+ */
+
+package com.ning.billing.analytics.dao;
+
+import java.lang.annotation.Annotation;
+import java.lang.annotation.ElementType;
+import java.lang.annotation.Retention;
+import java.lang.annotation.RetentionPolicy;
+import java.lang.annotation.Target;
+import java.sql.Types;
+
+import org.joda.time.DateTime;
+import org.joda.time.DateTimeZone;
+import org.skife.jdbi.v2.SQLStatement;
+import org.skife.jdbi.v2.sqlobject.Binder;
+import org.skife.jdbi.v2.sqlobject.BinderFactory;
+import org.skife.jdbi.v2.sqlobject.BindingAnnotation;
+
+import com.ning.billing.analytics.model.BusinessInvoice;
+import com.ning.billing.analytics.utils.Rounder;
+
+@BindingAnnotation(BusinessInvoiceBinder.BinBinderFactory.class)
+@Retention(RetentionPolicy.RUNTIME)
+@Target({ElementType.PARAMETER})
+public @interface BusinessInvoiceBinder {
+ public static class BinBinderFactory implements BinderFactory {
+ public Binder build(final Annotation annotation) {
+ return new Binder<BusinessInvoiceBinder, BusinessInvoice>() {
+ public void bind(final SQLStatement q, final BusinessInvoiceBinder bind, final BusinessInvoice invoice) {
+ q.bind("invoice_id", invoice.getInvoiceId().toString());
+
+ final DateTime dateTimeNow = new DateTime(DateTimeZone.UTC);
+ if (invoice.getCreatedDate() != null) {
+ q.bind("created_date", invoice.getCreatedDate().getMillis());
+ } else {
+ q.bind("created_date", dateTimeNow.getMillis());
+ }
+
+ if (invoice.getUpdatedDate() != null) {
+ q.bind("updated_date", invoice.getUpdatedDate().getMillis());
+ } else {
+ q.bind("updated_date", dateTimeNow.getMillis());
+ }
+
+ q.bind("account_key", invoice.getAccountKey());
+
+ if (invoice.getInvoiceDate() != null) {
+ q.bind("invoice_date", invoice.getInvoiceDate());
+ } else {
+ q.bindNull("invoice_date", Types.BIGINT);
+ }
+
+ if (invoice.getTargetDate() != null) {
+ q.bind("target_date", invoice.getTargetDate());
+ } else {
+ q.bindNull("target_date", Types.BIGINT);
+ }
+
+ q.bind("currency", invoice.getCurrency().toString());
+ q.bind("balance", Rounder.round(invoice.getBalance()));
+ q.bind("amount_paid", Rounder.round(invoice.getAmountPaid()));
+ q.bind("amount_charged", Rounder.round(invoice.getAmountCharged()));
+ q.bind("amount_credited", Rounder.round(invoice.getAmountCredited()));
+ }
+ };
+ }
+ }
+}
diff --git a/analytics/src/main/java/com/ning/billing/analytics/dao/BusinessInvoiceItemBinder.java b/analytics/src/main/java/com/ning/billing/analytics/dao/BusinessInvoiceItemBinder.java
new file mode 100644
index 0000000..b171a5c
--- /dev/null
+++ b/analytics/src/main/java/com/ning/billing/analytics/dao/BusinessInvoiceItemBinder.java
@@ -0,0 +1,87 @@
+/*
+ * Copyright 2010-2012 Ning, Inc.
+ *
+ * Ning licenses this file to you under the Apache License, version 2.0
+ * (the "License"); you may not use this file except in compliance with the
+ * License. You may obtain a copy of the License at:
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
+ * WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
+ * License for the specific language governing permissions and limitations
+ * under the License.
+ */
+
+package com.ning.billing.analytics.dao;
+
+import java.lang.annotation.Annotation;
+import java.lang.annotation.ElementType;
+import java.lang.annotation.Retention;
+import java.lang.annotation.RetentionPolicy;
+import java.lang.annotation.Target;
+import java.sql.Types;
+
+import org.joda.time.DateTime;
+import org.joda.time.DateTimeZone;
+import org.skife.jdbi.v2.SQLStatement;
+import org.skife.jdbi.v2.sqlobject.Binder;
+import org.skife.jdbi.v2.sqlobject.BinderFactory;
+import org.skife.jdbi.v2.sqlobject.BindingAnnotation;
+
+import com.ning.billing.analytics.model.BusinessInvoiceItem;
+import com.ning.billing.analytics.utils.Rounder;
+
+@BindingAnnotation(BusinessInvoiceItemBinder.BiiBinderFactory.class)
+@Retention(RetentionPolicy.RUNTIME)
+@Target({ElementType.PARAMETER})
+public @interface BusinessInvoiceItemBinder {
+ public static class BiiBinderFactory implements BinderFactory {
+ public Binder build(final Annotation annotation) {
+ return new Binder<BusinessInvoiceItemBinder, BusinessInvoiceItem>() {
+ public void bind(final SQLStatement q, final BusinessInvoiceItemBinder bind, final BusinessInvoiceItem invoiceItem) {
+ q.bind("item_id", invoiceItem.getItemId().toString());
+
+ final DateTime dateTimeNow = new DateTime(DateTimeZone.UTC);
+ if (invoiceItem.getCreatedDate() != null) {
+ q.bind("created_date", invoiceItem.getCreatedDate().getMillis());
+ } else {
+ q.bind("created_date", dateTimeNow.getMillis());
+ }
+
+ if (invoiceItem.getUpdatedDate() != null) {
+ q.bind("updated_date", invoiceItem.getUpdatedDate().getMillis());
+ } else {
+ q.bind("updated_date", dateTimeNow.getMillis());
+ }
+
+ q.bind("invoice_id", invoiceItem.getInvoiceId().toString());
+ q.bind("item_type", invoiceItem.getItemType());
+ q.bind("external_key", invoiceItem.getExternalKey());
+ q.bind("product_name", invoiceItem.getProductName());
+ q.bind("product_type", invoiceItem.getProductType());
+ q.bind("product_category", invoiceItem.getProductCategory());
+ q.bind("slug", invoiceItem.getSlug());
+ q.bind("phase", invoiceItem.getPhase());
+ q.bind("billing_period", invoiceItem.getBillingPeriod());
+
+ if (invoiceItem.getStartDate() != null) {
+ q.bind("start_date", invoiceItem.getStartDate());
+ } else {
+ q.bindNull("start_date", Types.BIGINT);
+ }
+
+ if (invoiceItem.getEndDate() != null) {
+ q.bind("end_date", invoiceItem.getEndDate());
+ } else {
+ q.bindNull("end_date", Types.BIGINT);
+ }
+
+ q.bind("amount", Rounder.round(invoiceItem.getAmount()));
+ q.bind("currency", invoiceItem.getCurrency().toString());
+ }
+ };
+ }
+ }
+}
diff --git a/analytics/src/main/java/com/ning/billing/analytics/dao/BusinessInvoicePaymentBinder.java b/analytics/src/main/java/com/ning/billing/analytics/dao/BusinessInvoicePaymentBinder.java
new file mode 100644
index 0000000..4cc614b
--- /dev/null
+++ b/analytics/src/main/java/com/ning/billing/analytics/dao/BusinessInvoicePaymentBinder.java
@@ -0,0 +1,83 @@
+/*
+ * Copyright 2010-2012 Ning, Inc.
+ *
+ * Ning licenses this file to you under the Apache License, version 2.0
+ * (the "License"); you may not use this file except in compliance with the
+ * License. You may obtain a copy of the License at:
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
+ * WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
+ * License for the specific language governing permissions and limitations
+ * under the License.
+ */
+
+package com.ning.billing.analytics.dao;
+
+import java.lang.annotation.Annotation;
+import java.lang.annotation.ElementType;
+import java.lang.annotation.Retention;
+import java.lang.annotation.RetentionPolicy;
+import java.lang.annotation.Target;
+import java.sql.Types;
+
+import org.joda.time.DateTime;
+import org.joda.time.DateTimeZone;
+import org.skife.jdbi.v2.SQLStatement;
+import org.skife.jdbi.v2.sqlobject.Binder;
+import org.skife.jdbi.v2.sqlobject.BinderFactory;
+import org.skife.jdbi.v2.sqlobject.BindingAnnotation;
+
+import com.ning.billing.analytics.model.BusinessInvoicePayment;
+import com.ning.billing.analytics.utils.Rounder;
+
+@BindingAnnotation(BusinessInvoicePaymentBinder.BipBinderFactory.class)
+@Retention(RetentionPolicy.RUNTIME)
+@Target({ElementType.PARAMETER})
+public @interface BusinessInvoicePaymentBinder {
+ public static class BipBinderFactory implements BinderFactory {
+ public Binder build(final Annotation annotation) {
+ return new Binder<BusinessInvoicePaymentBinder, BusinessInvoicePayment>() {
+ public void bind(final SQLStatement q, final BusinessInvoicePaymentBinder bind, final BusinessInvoicePayment invoicePayment) {
+ q.bind("payment_id", invoicePayment.getPaymentId().toString());
+
+ final DateTime dateTimeNow = new DateTime(DateTimeZone.UTC);
+ if (invoicePayment.getCreatedDate() != null) {
+ q.bind("created_date", invoicePayment.getCreatedDate().getMillis());
+ } else {
+ q.bind("created_date", dateTimeNow.getMillis());
+ }
+
+ if (invoicePayment.getUpdatedDate() != null) {
+ q.bind("updated_date", invoicePayment.getUpdatedDate().getMillis());
+ } else {
+ q.bind("updated_date", dateTimeNow.getMillis());
+ }
+
+ q.bind("attempt_id", invoicePayment.getAttemptId().toString());
+ q.bind("account_key", invoicePayment.getAccountKey());
+ q.bind("invoice_id", invoicePayment.getInvoiceId().toString());
+
+ if (invoicePayment.getEffectiveDate() != null) {
+ q.bind("effective_date", invoicePayment.getEffectiveDate());
+ } else {
+ q.bindNull("effective_date", Types.BIGINT);
+ }
+
+ q.bind("amount", Rounder.round(invoicePayment.getAmount()));
+ q.bind("currency", invoicePayment.getCurrency().toString());
+ q.bind("payment_error", invoicePayment.getPaymentError());
+ q.bind("processing_status", invoicePayment.getProcessingStatus());
+ q.bind("requested_amount", Rounder.round(invoicePayment.getRequestedAmount()));
+ q.bind("plugin_name", invoicePayment.getPluginName());
+ q.bind("payment_type", invoicePayment.getPaymentType());
+ q.bind("payment_method", invoicePayment.getPaymentMethod());
+ q.bind("card_type", invoicePayment.getCardType());
+ q.bind("card_country", invoicePayment.getCardCountry());
+ }
+ };
+ }
+ }
+}
diff --git a/analytics/src/main/java/com/ning/billing/analytics/dao/BusinessOverdueStatusBinder.java b/analytics/src/main/java/com/ning/billing/analytics/dao/BusinessOverdueStatusBinder.java
new file mode 100644
index 0000000..de9629a
--- /dev/null
+++ b/analytics/src/main/java/com/ning/billing/analytics/dao/BusinessOverdueStatusBinder.java
@@ -0,0 +1,59 @@
+/*
+ * Copyright 2010-2012 Ning, Inc.
+ *
+ * Ning licenses this file to you under the Apache License, version 2.0
+ * (the "License"); you may not use this file except in compliance with the
+ * License. You may obtain a copy of the License at:
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
+ * WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
+ * License for the specific language governing permissions and limitations
+ * under the License.
+ */
+
+package com.ning.billing.analytics.dao;
+
+import java.lang.annotation.Annotation;
+import java.lang.annotation.ElementType;
+import java.lang.annotation.Retention;
+import java.lang.annotation.RetentionPolicy;
+import java.lang.annotation.Target;
+import java.sql.Types;
+
+import org.skife.jdbi.v2.SQLStatement;
+import org.skife.jdbi.v2.sqlobject.Binder;
+import org.skife.jdbi.v2.sqlobject.BinderFactory;
+import org.skife.jdbi.v2.sqlobject.BindingAnnotation;
+
+import com.ning.billing.analytics.model.BusinessOverdueStatus;
+
+@BindingAnnotation(BusinessOverdueStatusBinder.BosBinderFactory.class)
+@Retention(RetentionPolicy.RUNTIME)
+@Target({ElementType.PARAMETER})
+public @interface BusinessOverdueStatusBinder {
+ public static class BosBinderFactory implements BinderFactory {
+ public Binder build(final Annotation annotation) {
+ return new Binder<BusinessOverdueStatusBinder, BusinessOverdueStatus>() {
+ public void bind(final SQLStatement q, final BusinessOverdueStatusBinder bind, final BusinessOverdueStatus overdueStatus) {
+ q.bind("external_key", overdueStatus.getExternalKey());
+ q.bind("status", overdueStatus.getStatus());
+
+ if (overdueStatus.getStartDate() != null) {
+ q.bind("start_date", overdueStatus.getStartDate());
+ } else {
+ q.bindNull("start_date", Types.BIGINT);
+ }
+
+ if (overdueStatus.getEndDate() != null) {
+ q.bind("end_date", overdueStatus.getEndDate());
+ } else {
+ q.bindNull("end_date", Types.BIGINT);
+ }
+ }
+ };
+ }
+ }
+}
