@@ -, +, @@ --- C4/Letters.pm | 10 ++++++++-- tools/letter.pl | 2 +- 2 files changed, 9 insertions(+), 3 deletions(-) --- a/C4/Letters.pm +++ a/C4/Letters.pm @@ -42,6 +42,8 @@ use Koha::DateUtils qw( format_sqldatetime dt_from_string ); use Koha::Patrons; use Koha::SMTP::Servers; use Koha::Subscriptions; +use Koha::Account::Lines; +use Locale::Currency::Format; use vars qw(@ISA @EXPORT @EXPORT_OK %EXPORT_TAGS); @@ -667,11 +669,15 @@ sub GetPreparedLetter { my $OPACBaseURL = C4::Context->preference('OPACBaseURL'); $letter->{content} =~ s/<>/$OPACBaseURL/go; + my $active_currency = Koha::Acquisition::Currencies->get_active; + my $currency_format = $active_currency->currency if defined($active_currency); + my $borrowernumber = $tables->{borrowers}; my $lines = Koha::Account::Lines->search({ borrowernumber => $borrowernumber }); my ($totalfine) = $lines->total_outstanding; - $totalfine = sprintf("%.2f", $totalfine); - $letter->{content} =~ s/<>/$totalfine/go; + my $totalfine_formatted = currency_format($currency_format, "$totalfine", FMT_SYMBOL); + $totalfine_formatted = sprintf("%.2f", $totalfine) unless $totalfine_formatted; + $letter->{content} =~ s/<>/$totalfine_formatted/go; if ($want_librarian) { # parsing librarian name --- a/tools/letter.pl +++ a/tools/letter.pl @@ -247,7 +247,7 @@ sub add_form { {value => 'items.content', text => 'items.content'}, {value => 'items.fine', text => 'items.fine'}, add_fields('borrowers'), - {value => 'borrowers.totalfine', text => 'borrowers.totalfine' }; + {value => 'borrowers.account_balance', text => 'borrowers.account_balance' }; if ($module eq 'circulation') { push @{$field_selection}, add_fields('opac_news'); --