Bug 18050: DBIC schema changes
[koha.git] / admin / currency.pl
blobd3dfab5e458605790d47fc2ccf1411e17fe04ede
1 #!/usr/bin/perl
3 # Copyright 2000-2002 Katipo Communications
4 # Copyright 2002 Paul Poulain
5 # Copyright Koha Development Team
7 # This file is part of Koha.
9 # Koha is free software; you can redistribute it and/or modify it
10 # under the terms of the GNU General Public License as published by
11 # the Free Software Foundation; either version 3 of the License, or
12 # (at your option) any later version.
14 # Koha is distributed in the hope that it will be useful, but
15 # WITHOUT ANY WARRANTY; without even the implied warranty of
16 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
17 # GNU General Public License for more details.
19 # You should have received a copy of the GNU General Public License
20 # along with Koha; if not, see <http://www.gnu.org/licenses>.
22 use Modern::Perl;
23 use CGI qw ( -utf8 );
24 use C4::Auth;
25 use C4::Context;
26 use C4::Output;
28 use Koha::Acquisition::Booksellers;
29 use Koha::Acquisition::Currencies;
30 use Koha::Acquisition::Orders;
32 my $input = CGI->new;
33 my $searchfield = $input->param('searchfield') || $input->param('description') || q{};
34 my $currency_code = $input->param('currency_code');
35 my $op = $input->param('op') || 'list';
36 my @messages;
38 our ( $template, $loggedinuser, $cookie ) = get_template_and_user(
39 { template_name => 'admin/currency.tt',
40 query => $input,
41 type => 'intranet',
42 flagsrequired => { acquisition => 'currencies_manage' },
46 if ( $op eq 'add_form' ) {
47 my $currency;
48 if ($currency_code) {
49 $currency = Koha::Acquisition::Currencies->find($currency_code);
52 $template->param( currency => $currency, );
53 } elsif ( $op eq 'add_validate' ) {
54 my $currency_code = $input->param('currency_code');
55 my $symbol = $input->param('symbol');
56 my $isocode = $input->param('isocode');
57 my $rate = $input->param('rate');
58 my $active = $input->param('active');
59 my $p_sep_by_space = $input->param('p_sep_by_space');
60 my $is_a_modif = $input->param('is_a_modif');
62 if ($is_a_modif) {
63 my $currency = Koha::Acquisition::Currencies->find($currency_code);
64 $currency->symbol($symbol);
65 $currency->isocode($isocode);
66 $currency->rate($rate);
67 $currency->active($active);
68 $currency->p_sep_by_space($p_sep_by_space);
69 eval { $currency->store; };
70 if ($@) {
71 push @messages, { type => 'error', code => 'error_on_update' };
72 } else {
73 push @messages, { type => 'message', code => 'success_on_update' };
75 } else {
76 my $currency = Koha::Acquisition::Currency->new(
77 { currency => $currency_code,
78 symbol => $symbol,
79 isocode => $isocode,
80 rate => $rate,
81 active => $active,
82 p_sep_by_space => $p_sep_by_space,
85 eval { $currency->store; };
86 if ($@) {
87 push @messages, { type => 'error', code => 'error_on_insert' };
88 } else {
89 push @messages, { type => 'message', code => 'success_on_insert' };
92 $searchfield = q||;
93 $op = 'list';
94 } elsif ( $op eq 'delete_confirm' ) {
95 my $currency = Koha::Acquisition::Currencies->find($currency_code);
97 my $nb_of_orders = Koha::Acquisition::Orders->search( { currency => $currency->currency } )->count;
98 my $nb_of_vendors = Koha::Acquisition::Booksellers->search( { -or => { listprice => $currency->currency, invoiceprice => $currency->currency } })->count;
99 $template->param(
100 currency => $currency,
101 nb_of_orders => $nb_of_orders,
102 nb_of_vendors => $nb_of_vendors,
104 } elsif ( $op eq 'delete_confirmed' ) {
105 my $currency = Koha::Acquisition::Currencies->find($currency_code);
106 my $deleted = eval { $currency->delete; };
108 if ( $@ or not $deleted ) {
109 push @messages, { type => 'error', code => 'error_on_delete' };
110 } else {
111 push @messages, { type => 'message', code => 'success_on_delete' };
113 $op = 'list';
116 if ( $op eq 'list' ) {
117 $searchfield =~ s/\,//g;
118 my $currencies = Koha::Acquisition::Currencies->search( { currency => { -like => "$searchfield%" } } );
120 my $no_active_currency = not Koha::Acquisition::Currencies->search( { active => 1 } )->count;
121 $template->param(
122 currencies => $currencies,
123 no_active_currency => $no_active_currency,
127 $template->param(
128 searchfield => $searchfield,
129 messages => \@messages,
130 op => $op,
133 output_html_with_http_headers $input, $cookie, $template->output;