BEGIN; INSERT INTO config.upgrade_log (version) VALUES ('0096'); UPDATE action_trigger.event_definition SET template = $$ [%- USE date -%] [%- SET user = target.0.usr -%] [%- SET lib = target.0.circ_lib -%] [%- SET lib_addr = target.0.circ_lib.billing_address -%] [%- SET hours = lib.hours_of_operation -%]
[% date.format %]
[% lib.name %]
[% lib_addr.street1 %] [% lib_addr.street2 %]
[% lib_addr.city %], [% lib_addr.state %] [% lb_addr.post_code %]
[% lib.phone %]

[% user.family_name %], [% user.first_given_name %]
    [% FOR circ IN target %] [%- SET idx = loop.count - 1; SET udata = user_data.$idx -%]
  1. [% helpers.get_copy_bib_basics(circ.target_copy.id).title %]
    Barcode: [% circ.target_copy.barcode %]
    [% IF udata.renewal_failure %]
    Renewal Failed
    [% ELSE %]
    Due Date: [% date.format(helpers.format_date(circ.due_date), '%Y-%m-%d') %]
    [% END %]
  2. [% END %]
Library Hours [%- BLOCK format_time; date.format(time _ ' 1/1/1000', format='%I:%M %p'); END -%]
Monday [% PROCESS format_time time = hours.dow_0_open %] [% PROCESS format_time time = hours.dow_0_close %]
Tuesday [% PROCESS format_time time = hours.dow_1_open %] [% PROCESS format_time time = hours.dow_1_close %]
Wednesday [% PROCESS format_time time = hours.dow_2_open %] [% PROCESS format_time time = hours.dow_2_close %]
Thursday [% PROCESS format_time time = hours.dow_3_open %] [% PROCESS format_time time = hours.dow_3_close %]
Friday [% PROCESS format_time time = hours.dow_4_open %] [% PROCESS format_time time = hours.dow_4_close %]
Saturday [% PROCESS format_time time = hours.dow_5_open %] [% PROCESS format_time time = hours.dow_5_close %]
Sunday [% PROCESS format_time time = hours.dow_6_open %] [% PROCESS format_time time = hours.dow_6_close %]
$$ WHERE id = 10; COMMIT;