From c09eef45bcddabaa6c534d3df1d1cc5218880bc2 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Tue, 27 Apr 2021 12:12:37 -0400 Subject: [PATCH] LP1904036 Remove dupe print template Signed-off-by: Bill Erickson Signed-off-by: Jane Sandberg Signed-off-by: Galen Charlton --- .../sql/Pg/upgrade/XXXX.data.angular-patron.sql | 68 ---------------------- 1 file changed, 68 deletions(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.angular-patron.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.angular-patron.sql index 708808f0e9..09919decc6 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.angular-patron.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.angular-patron.sql @@ -563,74 +563,6 @@ UPDATE config.print_template SET template = $TEMPLATE$ $TEMPLATE$ WHERE name = 'bills_historical'; -INSERT INTO config.print_template - (name, label, owner, active, locale, content_type, template) -VALUES ('bills_historical', 'Bills, Historical', 1, TRUE, 'en-US', 'text/html', ''); - - -UPDATE config.print_template SET template = $TEMPLATE$ -[% - USE date; - USE money = format('$%.2f'); - SET xacts = template_data.xacts; -%] -
- -
Welcome to [% staff_org.name %]
-
You have the following bills:
-
-
    - [% FOR xact IN xacts %] -
  1. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
    Bill #:[% xact.id %]
    Date:[% date.format(helpers.format_date( - xact.xact_start, staff_org_timezone), '%x %r') %] -
    Last Billing:[% xact.last_billing_type %]
    Total Billed:[% money(xact.total_owed) %]
    Last Payment: - [% xact.last_payment_type %] - [% IF xact.last_payment_ts %] - at [% date.format( - helpers.format_date( - xact.last_payment_ts, staff_org_timezone), '%x %r') %] - [% END %] -
    Total Paid:[% money(xact.total_paid) %]
    Balance:[% money(xact.balance_owed) %]
    -
  2. - [% END %] -
-
-
[% staff_org.name %] [% date.format(date.now, '%x %r') %]
-
You were helped by [% staff.first_given_name %]
-
-
-$TEMPLATE$ WHERE name = 'bills_historical'; - COMMIT; -- 2.11.0