3 INSERT INTO config.upgrade_log (version) VALUES ('0222'); -- phasefx
5 INSERT INTO action_trigger.hook (key,core_type,description,passive) VALUES (
10 'A patron has made an acquisitions request.',
20 'A patron acquisition request has been rejected.',
28 INSERT INTO action_trigger.event_definition (
41 'Email Notice: Acquisition Request created.',
47 [%- SET user = target.usr -%]
48 [%- SET title = target.title -%]
49 [%- SET author = target.author -%]
50 [%- SET isxn = target.isxn -%]
51 [%- SET publisher = target.publisher -%]
52 [%- SET pubdate = target.pubdate -%]
54 To: [%- params.recipient_email || user.email %]
55 From: [%- params.sender_email || default_sender %]
56 Subject: Acquisition Request Notification
58 Dear [% user.family_name %], [% user.first_given_name %]
59 Our records indicate that you have made the following acquisition request:
62 [% IF author %]Author: [% author %][% END %]
63 [% IF edition %]Edition: [% edition %][% END %]
64 [% IF isbn %]ISXN: [% isxn %][% END %]
65 [% IF publisher %]Publisher: [% publisher %][% END %]
66 [% IF pubdate %]Publication Date: [% pubdate %][% END %]
72 'Email Notice: Acquisition Request Rejected.',
78 [%- SET user = target.usr -%]
79 [%- SET title = target.title -%]
80 [%- SET author = target.author -%]
81 [%- SET isxn = target.isxn -%]
82 [%- SET publisher = target.publisher -%]
83 [%- SET pubdate = target.pubdate -%]
84 [%- SET cancel_reason = target.cancel_reason.description -%]
86 To: [%- params.recipient_email || user.email %]
87 From: [%- params.sender_email || default_sender %]
88 Subject: Acquisition Request Notification
90 Dear [% user.family_name %], [% user.first_given_name %]
91 Our records indicate the following acquisition request has been rejected for this reason: [% cancel_reason %]
94 [% IF author %]Author: [% author %][% END %]
95 [% IF edition %]Edition: [% edition %][% END %]
96 [% IF isbn %]ISBN: [% isbn %][% END %]
97 [% IF publisher %]Publisher: [% publisher %][% END %]
98 [% IF pubdate %]Publication Date: [% pubdate %][% END %]
102 INSERT INTO action_trigger.environment (
108 ( 19, 'cancel_reason' )