Attachment #108899 for bug #25534

View | Details | Raw Unified | Return to bug 25534
Collapse All | Expand All

Lines 1-5 Link Here

(-)a/installer/data/mysql/atomicupdate/cancellation_reason.perl (+4 lines)
1	$DBversion = 'XXX'; # will be replaced by the RM	1	$DBversion = 'XXX'; # will be replaced by the RM
2	if ( CheckVersion( $DBversion ) ) {	2	if ( CheckVersion( $DBversion ) ) {
		3	$dbh->do(q{
		4	INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');
		5	});
		6
3	if ( !column_exists( 'reserves', 'cancellation_reason' ) ) {	7	if ( !column_exists( 'reserves', 'cancellation_reason' ) ) {
4	$dbh->do(q{	8	$dbh->do(q{
5	ALTER TABLE reserves ADD COLUMN `cancellation_reason` varchar(80) default NULL AFTER cancellationdate;	9	ALTER TABLE reserves ADD COLUMN `cancellation_reason` varchar(80) default NULL AFTER cancellationdate;




            - "[% ELSE %]"
            - "The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]"
            - "[% END %]"

        - module: reserves
          code: HOLD_CANCELLATION
          branchcode: ""
          name: "Notification of hold cancellation"
          is_html: 0
          title: "Your hold was canceled."
          message_transport_type: email
          lang: default
          content:
              - "[%- USE AuthorisedValues -%]"
              - "Dear [% borrower.firstname %] [% borrower.surname %],"
              - "Your hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( 'HOLD_CANCELLATION', hold.cancellation_reason ) %]"

Return to bug 25534

Lines 1208-1210 tables: Link Here

(-)a/installer/data/mysql/en/mandatory/sample_notices.yml (-1 / +13 lines)
1208	- "[% ELSE %]"	1208	- "[% ELSE %]"
1209	- "The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due \| $KohaDates as_due_date => 1 %]"	1209	- "The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due \| $KohaDates as_due_date => 1 %]"
1210	- "[% END %]"	1210	- "[% END %]"
1211	-	1211
		1212	- module: reserves
		1213	code: HOLD_CANCELLATION
		1214	branchcode: ""
		1215	name: "Notification of hold cancellation"
		1216	is_html: 0
		1217	title: "Your hold was canceled."
		1218	message_transport_type: email
		1219	lang: default
		1220	content:
		1221	- "[%- USE AuthorisedValues -%]"
		1222	- "Dear [% borrower.firstname %] [% borrower.surname %],"
		1223	- "Your hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( 'HOLD_CANCELLATION', hold.cancellation_reason ) %]"