BEGIN; INSERT INTO config.upgrade_log (version) VALUES ('0189'); UPDATE action_trigger.event_definition SET template = $$ [%- USE date -%] [%- # find a lineitem attribute by name and optional type BLOCK get_li_attr; FOR attr IN li.attributes; IF attr.attr_name == attr_name; IF !attr_type OR attr_type == attr.attr_type; attr.attr_value; LAST; END; END; END; END -%]

Purchase Order [% target.id %]


date [% date.format(date.now, '%Y%m%d') %]
Vendor
[% target.provider.name %]
[% target.provider.addresses.0.street1 %]
[% target.provider.addresses.0.street2 %]
[% target.provider.addresses.0.city %]
[% target.provider.addresses.0.state %]
[% target.provider.addresses.0.country %]
[% target.provider.addresses.0.post_code %]
Ship to / Bill to
[% target.ordering_agency.name %]
[% target.ordering_agency.billing_address.street1 %]
[% target.ordering_agency.billing_address.street2 %]
[% target.ordering_agency.billing_address.city %]
[% target.ordering_agency.billing_address.state %]
[% target.ordering_agency.billing_address.country %]
[% target.ordering_agency.billing_address.post_code %]


Notes to the Vendor


[% subtotal = 0 %] [% FOR li IN target.lineitems %] [% count = li.lineitem_details.size %] [% price = li.estimated_unit_price %] [% litotal = (price * count) %] [% subtotal = subtotal + litotal %] [% isbn = PROCESS get_li_attr attr_name = 'isbn' %] [% ident = PROCESS get_li_attr attr_name = 'identifier' %] [% END %]
PO# ISBN or Item # Title Quantity Unit Price Line Total Notes
[% target.id %] [% isbn || ident %] [% PROCESS get_li_attr attr_name = 'title' %] [% count %] [% price %] [% litotal %]
    [% FOR note IN li.lineitem_notes %] [% IF note.vendor_public == 't' %]
  • [% note.value %]
  • [% END %] [% END %]
Sub Total [% subtotal %]

Total Line Item Count: [% target.lineitems.size %] $$ WHERE id = 4; INSERT INTO action_trigger.environment (event_def, path) VALUES (4, 'lineitems.lineitem_notes'), (4, 'notes'); COMMIT;