From 3bdc0696f8e2b6ca6be04b27bab9551e404d135e Mon Sep 17 00:00:00 2001 From: Dan Wells Date: Fri, 9 Mar 2018 11:25:16 -0500 Subject: [PATCH] Fix billing / negative balance test cases The test cases are set up manually via SQL, but were not taught about the new data needed for billings. This caused two tests to fail. Let's go ahead and update this whole block to have more realistic data conforming to the new scheme. Signed-off-by: Dan Wells --- .../sql/neg_bal_custom_transactions.sql | 138 +++++++++--------- 1 file changed, 69 insertions(+), 69 deletions(-) diff --git a/Open-ILS/tests/datasets/sql/neg_bal_custom_transactions.sql b/Open-ILS/tests/datasets/sql/neg_bal_custom_transactions.sql index 6df7fd0ab8..46490d85b9 100644 --- a/Open-ILS/tests/datasets/sql/neg_bal_custom_transactions.sql +++ b/Open-ILS/tests/datasets/sql/neg_bal_custom_transactions.sql @@ -86,76 +86,76 @@ UPDATE asset.copy SET status = 1 WHERE id = 12; -- Create LOST and overdue fines -INSERT INTO money.billing (id, xact, billing_ts, voided, voider, void_time, amount, billing_type, btype, note) VALUES - (DEFAULT, 1, '2014-05-28 08:39:13.070326-04', false, NULL, NULL, 50.00, 'Lost Materials', 3, 'SYSTEM GENERATED'), - (DEFAULT, 2, '2014-05-28 08:39:13.070326-04', false, NULL, NULL, 50.00, 'Lost Materials', 3, 'SYSTEM GENERATED'), - (DEFAULT, 3, '2014-05-28 08:39:13.070326-04', false, NULL, NULL, 50.00, 'Lost Materials', 3, 'SYSTEM GENERATED'), - (DEFAULT, 4, '2014-05-28 08:39:13.070326-04', false, NULL, NULL, 50.00, 'Lost Materials', 3, 'SYSTEM GENERATED'), - (DEFAULT, 5, '2014-05-28 08:39:13.070326-04', false, NULL, NULL, 50.00, 'Lost Materials', 3, 'SYSTEM GENERATED'), - (DEFAULT, 6, '2014-05-22 23:59:59-04', true, 1, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 6, '2014-05-23 23:59:59-04', true, 1, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 6, '2014-05-24 23:59:59-04', true, 1, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 6, '2014-05-25 23:59:59-04', true, 1, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 6, '2014-05-26 23:59:59-04', true, 1, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 6, '2014-05-27 23:59:59-04', true, 1, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 6, '2014-05-28 23:59:59-04', true, 1, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 6, '2014-05-28 08:39:13.070326-04', false, NULL, NULL, 50.00, 'Lost Materials', 3, 'SYSTEM GENERATED'), - (DEFAULT, 7, '2014-05-22 23:59:59-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 7, '2014-05-23 23:59:59-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 7, '2014-05-24 23:59:59-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 7, '2014-05-25 23:59:59-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 7, '2014-05-26 23:59:59-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 7, '2014-05-27 23:59:59-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 7, '2014-05-28 23:59:59-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 8, NOW() - '2 hours'::interval, false, NULL, NULL, 50.00, 'Lost Materials', 3, 'SYSTEM GENERATED'), - (DEFAULT, 9, NOW() - '4 hours'::interval, false, NULL, NULL, 50.00, 'Lost Materials', 3, 'SYSTEM GENERATED'), - (DEFAULT, 11, '2014-05-22 23:59:59-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 11, '2014-05-23 23:59:59-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 11, '2014-05-24 23:59:59-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 11, '2014-05-25 23:59:59-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 11, '2014-05-26 23:59:59-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 11, '2014-05-27 23:59:59-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 11, '2014-05-28 23:59:59-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 12, '2014-05-22 23:59:59-04', true, 1, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 12, '2014-05-23 23:59:59-04', true, 1, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 12, '2014-05-24 23:59:59-04', true, 1, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 12, '2014-05-25 23:59:59-04', true, 1, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 12, '2014-05-26 23:59:59-04', true, 1, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 12, '2014-05-27 23:59:59-04', true, 1, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 12, '2014-05-28 23:59:59-04', true, 1, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 12, '2014-05-28 08:39:13.070326-04', false, NULL, NULL, 50.00, 'Lost Materials', 3, 'SYSTEM GENERATED'), - (DEFAULT, 13, '2014-05-28 08:39:13.070326-04', false, NULL, NULL, 50.00, 'Lost Materials', 3, 'SYSTEM GENERATED'), - (DEFAULT, 14, '2014-05-22 23:59:59-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 14, '2014-05-23 23:59:59-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 14, '2014-05-24 23:59:59-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 14, '2014-05-25 23:59:59-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 14, '2014-05-26 23:59:59-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 14, '2014-05-27 23:59:59-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 14, '2014-05-28 23:59:59-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 15, '2014-05-28 08:39:13.070326-04', false, NULL, NULL, 50.00, 'Lost Materials', 3, 'SYSTEM GENERATED'), - (DEFAULT, 16, '2014-05-22 23:59:59-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 16, '2014-05-23 23:59:59-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 16, '2014-05-24 23:59:59-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 16, '2014-05-25 23:59:59-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 16, '2014-05-26 23:59:59-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 16, '2014-05-27 23:59:59-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 16, '2014-05-28 23:59:59-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), +INSERT INTO money.billing (id, xact, create_date, voided, voider, void_time, amount, billing_type, btype, note, period_start, period_end) VALUES + (DEFAULT, 1, '2014-05-28 08:39:13.070326-04', false, NULL, NULL, 50.00, 'Lost Materials', 3, 'SYSTEM GENERATED', NULL, NULL), + (DEFAULT, 2, '2014-05-28 08:39:13.070326-04', false, NULL, NULL, 50.00, 'Lost Materials', 3, 'SYSTEM GENERATED', NULL, NULL), + (DEFAULT, 3, '2014-05-28 08:39:13.070326-04', false, NULL, NULL, 50.00, 'Lost Materials', 3, 'SYSTEM GENERATED', NULL, NULL), + (DEFAULT, 4, '2014-05-28 08:39:13.070326-04', false, NULL, NULL, 50.00, 'Lost Materials', 3, 'SYSTEM GENERATED', NULL, NULL), + (DEFAULT, 5, '2014-05-28 08:39:13.070326-04', false, NULL, NULL, 50.00, 'Lost Materials', 3, 'SYSTEM GENERATED', NULL, NULL), + (DEFAULT, 6, '2014-05-22 00:00:00-04', true, 1, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-22 00:00:00-04', '2014-05-22 23:59:59-04'), + (DEFAULT, 6, '2014-05-23 00:00:00-04', true, 1, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-23 00:00:00-04', '2014-05-23 23:59:59-04'), + (DEFAULT, 6, '2014-05-24 00:00:00-04', true, 1, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-24 00:00:00-04', '2014-05-24 23:59:59-04'), + (DEFAULT, 6, '2014-05-25 00:00:00-04', true, 1, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-25 00:00:00-04', '2014-05-25 23:59:59-04'), + (DEFAULT, 6, '2014-05-26 00:00:00-04', true, 1, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-26 00:00:00-04', '2014-05-26 23:59:59-04'), + (DEFAULT, 6, '2014-05-27 00:00:00-04', true, 1, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-27 00:00:00-04', '2014-05-27 23:59:59-04'), + (DEFAULT, 6, '2014-05-28 00:00:00-04', true, 1, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-28 00:00:00-04', '2014-05-28 23:59:59-04'), + (DEFAULT, 6, '2014-05-28 08:39:13.070326-04', false, NULL, NULL, 50.00, 'Lost Materials', 3, 'SYSTEM GENERATED', NULL, NULL), + (DEFAULT, 7, '2014-05-22 00:00:00-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-22 00:00:00-04', '2014-05-22 23:59:59-04'), + (DEFAULT, 7, '2014-05-23 00:00:00-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-23 00:00:00-04', '2014-05-23 23:59:59-04'), + (DEFAULT, 7, '2014-05-24 00:00:00-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-24 00:00:00-04', '2014-05-24 23:59:59-04'), + (DEFAULT, 7, '2014-05-25 00:00:00-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-25 00:00:00-04', '2014-05-25 23:59:59-04'), + (DEFAULT, 7, '2014-05-26 00:00:00-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-26 00:00:00-04', '2014-05-26 23:59:59-04'), + (DEFAULT, 7, '2014-05-27 00:00:00-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-27 00:00:00-04', '2014-05-27 23:59:59-04'), + (DEFAULT, 7, '2014-05-28 00:00:00-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-28 00:00:00-04', '2014-05-28 23:59:59-04'), + (DEFAULT, 8, NOW() - '2 hours'::interval, false, NULL, NULL, 50.00, 'Lost Materials', 3, 'SYSTEM GENERATED', NULL, NULL), + (DEFAULT, 9, NOW() - '4 hours'::interval, false, NULL, NULL, 50.00, 'Lost Materials', 3, 'SYSTEM GENERATED', NULL, NULL), + (DEFAULT, 11, '2014-05-22 00:00:00-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-22 00:00:00-04', '2014-05-22 23:59:59-04'), + (DEFAULT, 11, '2014-05-23 00:00:00-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-23 00:00:00-04', '2014-05-23 23:59:59-04'), + (DEFAULT, 11, '2014-05-24 00:00:00-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-24 00:00:00-04', '2014-05-24 23:59:59-04'), + (DEFAULT, 11, '2014-05-25 00:00:00-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-25 00:00:00-04', '2014-05-25 23:59:59-04'), + (DEFAULT, 11, '2014-05-26 00:00:00-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-26 00:00:00-04', '2014-05-26 23:59:59-04'), + (DEFAULT, 11, '2014-05-27 00:00:00-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-27 00:00:00-04', '2014-05-27 23:59:59-04'), + (DEFAULT, 11, '2014-05-28 00:00:00-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-28 00:00:00-04', '2014-05-28 23:59:59-04'), + (DEFAULT, 12, '2014-05-22 00:00:00-04', true, 1, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-22 00:00:00-04', '2014-05-22 23:59:59-04'), + (DEFAULT, 12, '2014-05-23 00:00:00-04', true, 1, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-23 00:00:00-04', '2014-05-23 23:59:59-04'), + (DEFAULT, 12, '2014-05-24 00:00:00-04', true, 1, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-24 00:00:00-04', '2014-05-24 23:59:59-04'), + (DEFAULT, 12, '2014-05-25 00:00:00-04', true, 1, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-25 00:00:00-04', '2014-05-25 23:59:59-04'), + (DEFAULT, 12, '2014-05-26 00:00:00-04', true, 1, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-26 00:00:00-04', '2014-05-26 23:59:59-04'), + (DEFAULT, 12, '2014-05-27 00:00:00-04', true, 1, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-27 00:00:00-04', '2014-05-27 23:59:59-04'), + (DEFAULT, 12, '2014-05-28 00:00:00-04', true, 1, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-28 00:00:00-04', '2014-05-28 23:59:59-04'), + (DEFAULT, 12, '2014-05-28 08:39:13.070326-04', false, NULL, NULL, 50.00, 'Lost Materials', 3, 'SYSTEM GENERATED', NULL, NULL), + (DEFAULT, 13, '2014-05-28 08:39:13.070326-04', false, NULL, NULL, 50.00, 'Lost Materials', 3, 'SYSTEM GENERATED', NULL, NULL), + (DEFAULT, 14, '2014-05-22 00:00:00-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-22 00:00:00-04', '2014-05-22 23:59:59-04'), + (DEFAULT, 14, '2014-05-23 00:00:00-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-23 00:00:00-04', '2014-05-23 23:59:59-04'), + (DEFAULT, 14, '2014-05-24 00:00:00-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-24 00:00:00-04', '2014-05-24 23:59:59-04'), + (DEFAULT, 14, '2014-05-25 00:00:00-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-25 00:00:00-04', '2014-05-25 23:59:59-04'), + (DEFAULT, 14, '2014-05-26 00:00:00-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-26 00:00:00-04', '2014-05-26 23:59:59-04'), + (DEFAULT, 14, '2014-05-27 00:00:00-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-27 00:00:00-04', '2014-05-27 23:59:59-04'), + (DEFAULT, 14, '2014-05-28 00:00:00-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-28 00:00:00-04', '2014-05-28 23:59:59-04'), + (DEFAULT, 15, '2014-05-28 08:39:13.070326-04', false, NULL, NULL, 50.00, 'Lost Materials', 3, 'SYSTEM GENERATED', NULL, NULL), + (DEFAULT, 16, '2014-05-22 00:00:00-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-22 00:00:00-04', '2014-05-22 23:59:59-04'), + (DEFAULT, 16, '2014-05-23 00:00:00-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-23 00:00:00-04', '2014-05-23 23:59:59-04'), + (DEFAULT, 16, '2014-05-24 00:00:00-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-24 00:00:00-04', '2014-05-24 23:59:59-04'), + (DEFAULT, 16, '2014-05-25 00:00:00-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-25 00:00:00-04', '2014-05-25 23:59:59-04'), + (DEFAULT, 16, '2014-05-26 00:00:00-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-26 00:00:00-04', '2014-05-26 23:59:59-04'), + (DEFAULT, 16, '2014-05-27 00:00:00-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-27 00:00:00-04', '2014-05-27 23:59:59-04'), + (DEFAULT, 16, '2014-05-28 00:00:00-04', false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-28 00:00:00-04', '2014-05-28 23:59:59-04'), -- XACTS 5 and 10 must be last, because we use CURRVAL() to put their IDs in the account adjustments - (DEFAULT, 5, '2014-05-22 23:59:59-04', false, NULL, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 5, '2014-05-23 23:59:59-04', false, NULL, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 5, '2014-05-24 23:59:59-04', false, NULL, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 5, '2014-05-25 23:59:59-04', false, NULL, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 5, '2014-05-26 23:59:59-04', false, NULL, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 5, '2014-05-27 23:59:59-04', false, NULL, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 5, '2014-05-28 23:59:59-04', false, NULL, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 10, (DATE(NOW() - '9 days'::interval) || ' 23:59:59')::TIMESTAMP, false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 10, (DATE(NOW() - '8 days'::interval) || ' 23:59:59')::TIMESTAMP, false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 10, (DATE(NOW() - '7 days'::interval) || ' 23:59:59')::TIMESTAMP, false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 10, (DATE(NOW() - '6 days'::interval) || ' 23:59:59')::TIMESTAMP, false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 10, (DATE(NOW() - '5 days'::interval) || ' 23:59:59')::TIMESTAMP, false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 10, (DATE(NOW() - '4 days'::interval) || ' 23:59:59')::TIMESTAMP, false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 10, (DATE(NOW() - '3 days'::interval) || ' 23:59:59')::TIMESTAMP, false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine'), - (DEFAULT, 10, NOW() - '3 days'::interval, false, NULL, NULL, 50.00, 'Lost Materials', 3, 'SYSTEM GENERATED'); + (DEFAULT, 5, '2014-05-22 00:00:00-04', false, NULL, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-22 00:00:00-04', '2014-05-22 23:59:59-04'), + (DEFAULT, 5, '2014-05-23 00:00:00-04', false, NULL, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-23 00:00:00-04', '2014-05-23 23:59:59-04'), + (DEFAULT, 5, '2014-05-24 00:00:00-04', false, NULL, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-24 00:00:00-04', '2014-05-24 23:59:59-04'), + (DEFAULT, 5, '2014-05-25 00:00:00-04', false, NULL, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-25 00:00:00-04', '2014-05-25 23:59:59-04'), + (DEFAULT, 5, '2014-05-26 00:00:00-04', false, NULL, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-26 00:00:00-04', '2014-05-26 23:59:59-04'), + (DEFAULT, 5, '2014-05-27 00:00:00-04', false, NULL, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-27 00:00:00-04', '2014-05-27 23:59:59-04'), + (DEFAULT, 5, '2014-05-28 00:00:00-04', false, NULL, '2014-05-28 08:39:13.070326-04', 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', '2014-05-28 00:00:00-04', '2014-05-28 23:59:59-04'), + (DEFAULT, 10, (DATE(NOW() - '9 days'::interval) || ' 00:00:00')::TIMESTAMP, false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', (DATE(NOW() - '9 days'::interval) || ' 00:00:00')::TIMESTAMP, (DATE(NOW() - '9 days'::interval) || ' 23:59:59')::TIMESTAMP), + (DEFAULT, 10, (DATE(NOW() - '8 days'::interval) || ' 00:00:00')::TIMESTAMP, false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', (DATE(NOW() - '8 days'::interval) || ' 00:00:00')::TIMESTAMP, (DATE(NOW() - '8 days'::interval) || ' 23:59:59')::TIMESTAMP), + (DEFAULT, 10, (DATE(NOW() - '7 days'::interval) || ' 00:00:00')::TIMESTAMP, false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', (DATE(NOW() - '7 days'::interval) || ' 00:00:00')::TIMESTAMP, (DATE(NOW() - '7 days'::interval) || ' 23:59:59')::TIMESTAMP), + (DEFAULT, 10, (DATE(NOW() - '6 days'::interval) || ' 00:00:00')::TIMESTAMP, false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', (DATE(NOW() - '6 days'::interval) || ' 00:00:00')::TIMESTAMP, (DATE(NOW() - '6 days'::interval) || ' 23:59:59')::TIMESTAMP), + (DEFAULT, 10, (DATE(NOW() - '5 days'::interval) || ' 00:00:00')::TIMESTAMP, false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', (DATE(NOW() - '5 days'::interval) || ' 00:00:00')::TIMESTAMP, (DATE(NOW() - '5 days'::interval) || ' 23:59:59')::TIMESTAMP), + (DEFAULT, 10, (DATE(NOW() - '4 days'::interval) || ' 00:00:00')::TIMESTAMP, false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', (DATE(NOW() - '4 days'::interval) || ' 00:00:00')::TIMESTAMP, (DATE(NOW() - '4 days'::interval) || ' 23:59:59')::TIMESTAMP), + (DEFAULT, 10, (DATE(NOW() - '3 days'::interval) || ' 00:00:00')::TIMESTAMP, false, NULL, NULL, 0.10, 'Overdue materials', 1, 'System Generated Overdue Fine', (DATE(NOW() - '9 days'::interval) || ' 00:00:00')::TIMESTAMP, (DATE(NOW() - '9 days'::interval) || ' 23:59:59')::TIMESTAMP), + (DEFAULT, 10, NOW() - '3 days'::interval, false, NULL, NULL, 50.00, 'Lost Materials', 3, 'SYSTEM GENERATED', NULL, NULL); INSERT INTO money.account_adjustment (id, xact, payment_ts, voided, amount, note, amount_collected, accepting_usr, billing) VALUES -- 2.43.2