killbill-memoizeit

diff --git a/osgi-bundles/bundles/analytics/src/main/resources/reports/analytics.ini b/osgi-bundles/bundles/analytics/src/main/resources/reports/analytics.ini
index a3804e5..f3190b7 100644
--- a/osgi-bundles/bundles/analytics/src/main/resources/reports/analytics.ini
+++ b/osgi-bundles/bundles/analytics/src/main/resources/reports/analytics.ini
@@ -16,6 +16,10 @@
 
 ; Built-in default set of reports
 
+[new_trials_last_24_hours]
+tableName = v_new_trials_last_24_hours
+prettyName = Last 24 hours trials
+
 [new_accounts_per_day]
 tableName = v_new_accounts_per_day
 prettyName = Accounts created per day
@@ -32,6 +36,22 @@ prettyName = Conversions per day
 tableName = v_cancellations_per_day
 prettyName = Effective cancellations per day
 
+[payments_per_day]
+tableName = v_payments_per_day
+prettyName = Payments
+
+[refunds_per_day]
+tableName = v_refunds_per_day
+prettyName = Refunds
+
+[chargebacks_per_day]
+tableName = v_chargebacks_per_day
+prettyName = Chargebacks
+
+[system_report_notifications_per_queue_name]
+tableName = v_system_report_notifications_per_queue_name
+prettyName = AVAILABLE notifications
+
 [system_report_payment_plugin_failure_aborted]
 tableName = v_system_report_payment_plugin_failure_aborted
 prettyName = PLUGIN_FAILURE_ABORTED and UNKNOWN

diff --git a/osgi-bundles/bundles/analytics/src/main/resources/reports/chargebacks_per_day.sql b/osgi-bundles/bundles/analytics/src/main/resources/reports/chargebacks_per_day.sql
new file mode 100644
index 0000000..d67770f
--- /dev/null
+++ b/osgi-bundles/bundles/analytics/src/main/resources/reports/chargebacks_per_day.sql
@@ -0,0 +1,10 @@
+create or replace view v_chargebacks_per_day as
+select
+  currency as pivot
+, date_format(created_date, '%Y-%m-%d') as day
+, sum(amount) as count
+from bipc
+where report_group = 'default'
+group by 1, 2
+order by 1, 2 asc
+;

diff --git a/osgi-bundles/bundles/analytics/src/main/resources/reports/new_trials_last_24_hours.sql b/osgi-bundles/bundles/analytics/src/main/resources/reports/new_trials_last_24_hours.sql
new file mode 100644
index 0000000..aef9c0d
--- /dev/null
+++ b/osgi-bundles/bundles/analytics/src/main/resources/reports/new_trials_last_24_hours.sql
@@ -0,0 +1,14 @@
+create or replace view v_new_trials_last_24_hours as
+select
+  next_slug as pivot
+, date_format(next_start_date, '%Y-%m-%dT%H:00:00Z') as day
+, count(*) as count
+from bst
+where next_start_date > date_sub(curdate(), interval 24 hour)
+and next_start_date <= curdate()
+and event = 'ADD_BASE'
+and next_phase = 'TRIAL'
+and report_group = 'default'
+group by 1, 2
+order by 1, 2 asc
+;

diff --git a/osgi-bundles/bundles/analytics/src/main/resources/reports/payments_per_day.sql b/osgi-bundles/bundles/analytics/src/main/resources/reports/payments_per_day.sql
new file mode 100644
index 0000000..5a8d288
--- /dev/null
+++ b/osgi-bundles/bundles/analytics/src/main/resources/reports/payments_per_day.sql
@@ -0,0 +1,10 @@
+create or replace view v_payments_per_day as
+select
+  currency as pivot
+, date_format(created_date, '%Y-%m-%d') as day
+, sum(amount) as count
+from bip
+where report_group = 'default'
+group by 1, 2
+order by 1, 2 asc
+;

diff --git a/osgi-bundles/bundles/analytics/src/main/resources/reports/refunds_per_day.sql b/osgi-bundles/bundles/analytics/src/main/resources/reports/refunds_per_day.sql
new file mode 100644
index 0000000..5e028b6
--- /dev/null
+++ b/osgi-bundles/bundles/analytics/src/main/resources/reports/refunds_per_day.sql
@@ -0,0 +1,10 @@
+create or replace view v_refunds_per_day as
+select
+  currency as pivot
+, date_format(created_date, '%Y-%m-%d') as day
+, sum(amount) as count
+from bipr
+where report_group = 'default'
+group by 1, 2
+order by 1, 2 asc
+;

diff --git a/osgi-bundles/bundles/analytics/src/main/resources/reports/system_report_notifications_per_queue_name.sql b/osgi-bundles/bundles/analytics/src/main/resources/reports/system_report_notifications_per_queue_name.sql
new file mode 100644
index 0000000..fe6947d
--- /dev/null
+++ b/osgi-bundles/bundles/analytics/src/main/resources/reports/system_report_notifications_per_queue_name.sql
@@ -0,0 +1,10 @@
+create or replace view v_system_report_notifications_per_queue_name as
+select
+  queue_name as pivot
+, date_format(effective_date, '%Y-%m-%d') as day
+, count(*) as count
+from notifications
+where processing_state = 'AVAILABLE'
+group by 1, 2
+order by 1, 2 asc
+;