adding "open only" views
[Evergreen.git] / Open-ILS / src / perlmods / OpenILS / Application / Storage / CDBI / money.pm
index c49a67b..6661bac 100644 (file)
@@ -14,6 +14,13 @@ __PACKAGE__->columns(Essential => qw/xact_start usr/);
 __PACKAGE__->columns(Others => qw/xact_finish/);
 #-------------------------------------------------------------------------------
 
+package money::open_user_summary;
+use base qw/money/;
+__PACKAGE__->table('money_open_user_summary');
+__PACKAGE__->columns(Primary => 'usr');
+__PACKAGE__->columns(Essential => qw/total_paid total_owed balance_owed/);
+#-------------------------------------------------------------------------------
+
 package money::user_summary;
 use base qw/money/;
 __PACKAGE__->table('money_user_summary');
@@ -21,6 +28,13 @@ __PACKAGE__->columns(Primary => 'usr');
 __PACKAGE__->columns(Essential => qw/total_paid total_owed balance_owed/);
 #-------------------------------------------------------------------------------
 
+package money::open_user_circulation_summary;
+use base qw/money/;
+__PACKAGE__->table('money_open_user_circulation_summary');
+__PACKAGE__->columns(Primary => 'usr');
+__PACKAGE__->columns(Essential => qw/total_paid total_owed balance_owed/);
+#-------------------------------------------------------------------------------
+
 package money::user_circulation_summary;
 use base qw/money/;
 __PACKAGE__->table('money_user_circulation_summary');
@@ -28,6 +42,16 @@ __PACKAGE__->columns(Primary => 'usr');
 __PACKAGE__->columns(Essential => qw/total_paid total_owed balance_owed/);
 #-------------------------------------------------------------------------------
 
+package money::open_billable_transaction_summary;
+use base qw/money/;
+__PACKAGE__->table('money_open_billable_transaction_summary');
+__PACKAGE__->columns(Primary => 'id');
+__PACKAGE__->columns(Essential => qw/xact_start usr xact_finish total_paid
+                                    last_payment_ts total_owed last_billing_ts
+                                    balance_owed xact_type last_billing_note last_billing_type
+                                    last_payment_note last_payment_type/);
+#-------------------------------------------------------------------------------
+
 package money::billable_transaction_summary;
 use base qw/money/;
 __PACKAGE__->table('money_billable_transaction_summary');