3 INSERT INTO config.upgrade_log (version) VALUES ('0096');
5 UPDATE action_trigger.event_definition SET template =
8 [%- SET user = target.0.usr -%]
9 [%- SET lib = target.0.circ_lib -%]
10 [%- SET lib_addr = target.0.circ_lib.billing_address -%]
11 [%- SET hours = lib.hours_of_operation -%]
13 <style> li { padding: 8px; margin 5px; }</style>
14 <div>[% date.format %]</div>
15 <div>[% lib.name %]</div>
16 <div>[% lib_addr.street1 %] [% lib_addr.street2 %]</div>
17 <div>[% lib_addr.city %], [% lib_addr.state %] [% lb_addr.post_code %]</div>
18 <div>[% lib.phone %]</div>
21 [% user.family_name %], [% user.first_given_name %]
23 [% FOR circ IN target %]
25 SET idx = loop.count - 1;
26 SET udata = user_data.$idx
29 <div>[% helpers.get_copy_bib_basics(circ.target_copy.id).title %]</div>
30 <div>Barcode: [% circ.target_copy.barcode %]</div>
31 [% IF udata.renewal_failure %]
32 <div style='color:red;'>Renewal Failed</div>
34 <div>Due Date: [% date.format(helpers.format_date(circ.due_date), '%Y-%m-%d') %]</div>
42 [%- BLOCK format_time; date.format(time _ ' 1/1/1000', format='%I:%M %p'); END -%]
45 [% PROCESS format_time time = hours.dow_0_open %]
46 [% PROCESS format_time time = hours.dow_0_close %]
50 [% PROCESS format_time time = hours.dow_1_open %]
51 [% PROCESS format_time time = hours.dow_1_close %]
55 [% PROCESS format_time time = hours.dow_2_open %]
56 [% PROCESS format_time time = hours.dow_2_close %]
60 [% PROCESS format_time time = hours.dow_3_open %]
61 [% PROCESS format_time time = hours.dow_3_close %]
65 [% PROCESS format_time time = hours.dow_4_open %]
66 [% PROCESS format_time time = hours.dow_4_close %]
70 [% PROCESS format_time time = hours.dow_5_open %]
71 [% PROCESS format_time time = hours.dow_5_close %]
75 [% PROCESS format_time time = hours.dow_6_open %]
76 [% PROCESS format_time time = hours.dow_6_close %]