3 INSERT INTO config.upgrade_log (version) VALUES ('0355'); -- phasefx
5 INSERT INTO action_trigger.hook (key,core_type,description,passive) VALUES
6 ( 'circ.format.missing_pieces.slip.print',
9 'circ.format.missing_pieces.slip.print',
10 'A missing pieces slip needs to be formatted for printing.',
16 ,( 'circ.format.missing_pieces.letter.print',
19 'circ.format.missing_pieces.letter.print',
20 'A missing pieces patron letter needs to be formatted for printing.',
28 INSERT INTO action_trigger.event_definition (
43 'circ.missing_pieces.slip.print',
44 'circ.format.missing_pieces.slip.print',
51 [%- SET user = target.0.usr -%]
52 <div style="li { padding: 8px; margin 5px; }">
53 <div>[% date.format %]</div><br/>
56 [% FOR circ IN target %]
57 <li>Barcode: [% circ.target_copy.barcode %] Transaction ID: [% circ.id %] Due: [% circ.due_date.format %]<br />
58 [% helpers.get_copy_bib_basics(circ.target_copy.id).title %]
69 'circ.missing_pieces.letter.print',
70 'circ.format.missing_pieces.letter.print',
77 [%- SET user = target.0.usr -%]
79 Dear [% user.prefix %] [% user.first_given_name %] [% user.family_name %],
81 We are missing pieces for the following returned items:
82 [% FOR circ IN target %]
83 Barcode: [% circ.target_copy.barcode %] Transaction ID: [% circ.id %] Due: [% circ.due_date.format %]
84 [% helpers.get_copy_bib_basics(circ.target_copy.id).title %]
87 Please return these pieces as soon as possible.
96 INSERT INTO action_trigger.environment (
99 ) VALUES -- for fleshing circ objects
101 ,( 33, 'target_copy')
102 ,( 33, 'target_copy.circ_lib')
103 ,( 33, 'target_copy.circ_lib.mailing_address')
104 ,( 33, 'target_copy.circ_lib.billing_address')
105 ,( 33, 'target_copy.call_number')
106 ,( 33, 'target_copy.call_number.owning_lib')
107 ,( 33, 'target_copy.call_number.owning_lib.mailing_address')
108 ,( 33, 'target_copy.call_number.owning_lib.billing_address')
110 ,( 33, 'circ_lib.mailing_address')
111 ,( 33, 'circ_lib.billing_address')
113 ,( 34, 'target_copy')
114 ,( 34, 'target_copy.circ_lib')
115 ,( 34, 'target_copy.circ_lib.mailing_address')
116 ,( 34, 'target_copy.circ_lib.billing_address')
117 ,( 34, 'target_copy.call_number')
118 ,( 34, 'target_copy.call_number.owning_lib')
119 ,( 34, 'target_copy.call_number.owning_lib.mailing_address')
120 ,( 34, 'target_copy.call_number.owning_lib.billing_address')
122 ,( 34, 'circ_lib.mailing_address')
123 ,( 34, 'circ_lib.billing_address')
126 -- DELETE FROM config.upgrade_log WHERE version = 'temp'; DELETE FROM action_trigger.event WHERE event_def IN (33,34); DELETE FROM action_trigger.environment WHERE event_def IN (33,34); DELETE FROM action_trigger.event_definition WHERE id IN (33,34); DELETE FROM action_trigger.hook WHERE key IN ( 'circ.format.missing_pieces.slip.print', 'circ.format.missing_pieces.letter.print' );