1 -- Evergreen DB patch 0642.data.acq-worksheet-hold-count.sql
4 -- check whether patch can be applied
5 SELECT evergreen.upgrade_deps_block_check('0642', :eg_version);
7 UPDATE action_trigger.event_definition SET template =
10 [%- SET li = target; -%]
12 <div class="summary" style='font-size:110%; font-weight:bold;'>
14 <div>Title: [% helpers.get_li_attr("title", "", li.attributes) %]</div>
15 <div>Author: [% helpers.get_li_attr("author", "", li.attributes) %]</div>
16 <div class="count">Item Count: [% li.lineitem_details.size %]</div>
17 <div class="lineid">Lineitem ID: [% li.id %]</div>
18 <div>Open Holds: [% helpers.bre_open_hold_count(li.eg_bib_id) %]</div>
20 [% IF li.distribution_formulas.size > 0 %]
22 [% FOREACH form IN li.distribution_formulas; forms.push(form.formula.name); END %]
23 <div>Distribution Formulas: [% forms.join(',') %]</div>
26 [% IF li.lineitem_notes.size > 0 %]
29 [%- FOR note IN li.lineitem_notes -%]
31 [% IF note.alert_text %]
32 [% note.alert_text.code -%]
52 <th>Shelving Location</th>
58 [% FOREACH detail IN li.lineitem_details.sort('owning_lib') %]
61 SET copy = detail.eg_copy_id;
62 SET cn_label = copy.call_number.label;
65 SET cn_label = detail.cn_label;
69 <!-- acq.lineitem_detail.id = [%- detail.id -%] -->
70 <td style='padding:5px;'>[% detail.owning_lib.shortname %]</td>
71 <td style='padding:5px;'>[% IF copy.barcode %]<span class="barcode" >[% detail.barcode %]</span>[% END %]</td>
72 <td style='padding:5px;'>[% IF cn_label %]<span class="cn_label" >[% cn_label %]</span>[% END %]</td>
73 <td style='padding:5px;'>[% IF detail.fund %]<span class="fund">[% detail.fund.code %] ([% detail.fund.year %])</span>[% END %]</td>
74 <td style='padding:5px;'>[% copy.location.name %]</td>
75 <td style='padding:5px;'>[% IF detail.recv_time %]<span class="recv_time">[% detail.recv_time %]</span>[% END %]</td>
76 <td style='padding:5px;'>[% detail.note %]</td>