3 INSERT INTO config.upgrade_log (version) VALUES ('0208');
5 UPDATE action_trigger.event_definition SET
6 name = 'Lineitem Worksheet',
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>
19 [% IF li.distribution_formulas.size > 0 %]
21 [% FOREACH form IN li.distribution_formulas; forms.push(form.formula.name); END %]
22 <div>Distribution Formulas: [% forms.join(',') %]</div>
25 [% IF li.lineitem_notes.size > 0 %]
28 [%- FOR note IN li.lineitem_notes -%]
30 [% IF note.alert_text %]
31 [% note.alert_text.code -%]
56 [% FOREACH detail IN li.lineitem_details.sort('owning_lib') %]
59 SET copy = copy.eg_copy_id;
60 SET cn_label = copy.call_number.label;
63 SET cn_label = detail.cn_label;
67 <!-- acq.lineitem_detail.id = [%- detail.id -%] -->
68 <td style='padding:5px;'>[% detail.owning_lib.shortname %]</td>
69 <td style='padding:5px;'>[% IF copy.barcode %]<span class="barcode" >[% detail.barcode %]</span>[% END %]</td>
70 <td style='padding:5px;'>[% IF cn_label %]<span class="cn_label" >[% cn_label %]</span>[% END %]</td>
71 <td style='padding:5px;'>[% IF detail.fund %]<span class="fund">[% detail.fund.code %] ([% detail.fund.year %])</span>[% END %]</td>
72 <td style='padding:5px;'>[% IF detail.recv_time %]<span class="recv_time">[% detail.recv_time %]</span>[% END %]</td>
73 <td style='padding:5px;'>[% detail.note %]</td>
83 INSERT INTO action_trigger.environment (event_def, path) VALUES
84 ( 14, 'lineitem_notes.alert_text' ),
85 ( 14, 'distribution_formulas.formula' ),
86 ( 14, 'lineitem_details.fund' ),
87 ( 14, 'lineitem_details.eg_copy_id' ),
88 ( 14, 'lineitem_details.eg_copy_id.call_number' )