3 SELECT evergreen.upgrade_deps_block_check('0965', :eg_version);
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 %] [% lib_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 user_data.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 %]
81 WHERE id = 10 AND template =
84 [%- SET user = target.0.usr -%]
85 [%- SET lib = target.0.circ_lib -%]
86 [%- SET lib_addr = target.0.circ_lib.billing_address -%]
87 [%- SET hours = lib.hours_of_operation -%]
89 <style> li { padding: 8px; margin 5px; }</style>
90 <div>[% date.format %]</div>
91 <div>[% lib.name %]</div>
92 <div>[% lib_addr.street1 %] [% lib_addr.street2 %]</div>
93 <div>[% lib_addr.city %], [% lib_addr.state %] [% lb_addr.post_code %]</div>
94 <div>[% lib.phone %]</div>
97 [% user.family_name %], [% user.first_given_name %]
99 [% FOR circ IN target %]
101 SET idx = loop.count - 1;
102 SET udata = user_data.$idx
105 <div>[% helpers.get_copy_bib_basics(circ.target_copy.id).title %]</div>
106 <div>Barcode: [% circ.target_copy.barcode %]</div>
107 [% IF user_data.renewal_failure %]
108 <div style='color:red;'>Renewal Failed</div>
110 <div>Due Date: [% date.format(helpers.format_date(circ.due_date), '%Y-%m-%d') %]</div>
118 [%- BLOCK format_time; date.format(time _ ' 1/1/1000', format='%I:%M %p'); END -%]
121 [% PROCESS format_time time = hours.dow_0_open %]
122 [% PROCESS format_time time = hours.dow_0_close %]
126 [% PROCESS format_time time = hours.dow_1_open %]
127 [% PROCESS format_time time = hours.dow_1_close %]
131 [% PROCESS format_time time = hours.dow_2_open %]
132 [% PROCESS format_time time = hours.dow_2_close %]
136 [% PROCESS format_time time = hours.dow_3_open %]
137 [% PROCESS format_time time = hours.dow_3_close %]
141 [% PROCESS format_time time = hours.dow_4_open %]
142 [% PROCESS format_time time = hours.dow_4_close %]
146 [% PROCESS format_time time = hours.dow_5_open %]
147 [% PROCESS format_time time = hours.dow_5_close %]
151 [% PROCESS format_time time = hours.dow_6_open %]
152 [% PROCESS format_time time = hours.dow_6_close %]