@@ -, +, @@ SELECT * FROM account_debit_types; --- installer/data/mysql/account_debit_types.sql | 2 +- installer/data/mysql/atomicupdate/bug_25010_rewewal.perl | 8 ++++++++ installer/data/mysql/updatedatabase.pl | 2 +- koha-tmpl/intranet-tmpl/prog/en/includes/accounts.inc | 2 +- .../opac-tmpl/bootstrap/en/includes/account-table.inc | 2 +- 5 files changed, 12 insertions(+), 4 deletions(-) create mode 100644 installer/data/mysql/atomicupdate/bug_25010_rewewal.perl --- a/installer/data/mysql/account_debit_types.sql +++ a/installer/data/mysql/account_debit_types.sql @@ -10,6 +10,6 @@ INSERT INTO account_debit_types ( code, description, can_be_invoiced, can_be_sol ('RENT', 'Rental fee', 0, 0, NULL, 1), ('RENT_DAILY', 'Daily rental fee', 0, 0, NULL, 1), ('RENT_RENEW', 'Renewal of rental item', 0, 0, NULL, 1), -('RENT_DAILY_RENEW', 'Rewewal of daily rental item', 0, 0, NULL, 1), +('RENT_DAILY_RENEW', 'Renewal of daily rental item', 0, 0, NULL, 1), ('RESERVE', 'Hold fee', 0, 0, NULL, 1), ('RESERVE_EXPIRED', 'Hold waiting too long', 0, 0, NULL, 1); --- a/installer/data/mysql/atomicupdate/bug_25010_rewewal.perl +++ a/installer/data/mysql/atomicupdate/bug_25010_rewewal.perl @@ -0,0 +1,8 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + # you can use $dbh here like: + $dbh->do( "UPDATE account_debit_types SET description = REPLACE(description,'Rewewal','Renewal') WHERE description like '%Rewewal%'" ); + + # Always end with this (adjust the bug info) + NewVersion( $DBversion, 25010, "Fix typo in account_debit_type description"); +} --- a/installer/data/mysql/updatedatabase.pl +++ a/installer/data/mysql/updatedatabase.pl @@ -19781,7 +19781,7 @@ if ( CheckVersion($DBversion) ) { ('RENT', 'Rental fee', 0, NULL, 1), ('RENT_DAILY', 'Daily rental fee', 0, NULL, 1), ('RENT_RENEW', 'Renewal of rental item', 0, NULL, 1), - ('RENT_DAILY_RENEW', 'Rewewal of daily rental item', 0, NULL, 1), + ('RENT_DAILY_RENEW', 'Renewal of daily rental item', 0, NULL, 1), ('RESERVE', 'Hold fee', 0, NULL, 1) } ); --- a/koha-tmpl/intranet-tmpl/prog/en/includes/accounts.inc +++ a/koha-tmpl/intranet-tmpl/prog/en/includes/accounts.inc @@ -22,7 +22,7 @@ [%- CASE 'RENT' -%]Rental fee [%- CASE 'RENT_DAILY' -%]Daily rental fee [%- CASE 'RENT_RENEW' -%]Renewal of rental item - [%- CASE 'RENT_DAILY_RENEW' -%]Rewewal of daily rental item + [%- CASE 'RENT_DAILY_RENEW' -%]Renewal of daily rental item [%- CASE 'RESERVE' -%]Hold fee [%- CASE 'RESERVE_EXPIRED' -%]Hold waiting too long [%- CASE 'Payout' -%]Payout --- a/koha-tmpl/opac-tmpl/bootstrap/en/includes/account-table.inc +++ a/koha-tmpl/opac-tmpl/bootstrap/en/includes/account-table.inc @@ -190,7 +190,7 @@ [%- CASE 'RENT' -%]Rental fee [%- CASE 'RENT_DAILY' -%]Daily rental fee [%- CASE 'RENT_RENEW' -%]Renewal of rental item - [%- CASE 'RENT_DAILY_RENEW' -%]Rewewal of daily rental item + [%- CASE 'RENT_DAILY_RENEW' -%]Renewal of daily rental item [%- CASE 'RESERVE' -%]Hold fee [%- CASE 'RESERVE_EXPIRED' -%]Hold waiting too long [%- CASE -%][% account.debit_type.description | html %] --