X-Git-Url: http://koha-dev.rot13.org:8081/gitweb/?a=blobdiff_plain;f=admin%2Fcurrency.pl;h=1e3f16082b92d0d7e69f9248794c9c9734193f4e;hb=e012957186426b9577bfc8498c5971990b258024;hp=e4dc61c54a2cb2e8606997e067ed85b245e1002e;hpb=682ae23959c71d4fa08862faf2ffefd2ce852740;p=koha_fer diff --git a/admin/currency.pl b/admin/currency.pl index e4dc61c54a..1e3f16082b 100755 --- a/admin/currency.pl +++ b/admin/currency.pl @@ -19,236 +19,201 @@ # if $op=delete_confirm # - we delete the record having primkey=$primkey + +# Copyright 2000-2002 Katipo Communications +# +# This file is part of Koha. +# +# Koha is free software; you can redistribute it and/or modify it under the +# terms of the GNU General Public License as published by the Free Software +# Foundation; either version 2 of the License, or (at your option) any later +# version. +# +# Koha is distributed in the hope that it will be useful, but WITHOUT ANY +# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR +# A PARTICULAR PURPOSE. See the GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License along +# with Koha; if not, write to the Free Software Foundation, Inc., +# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. + use strict; -use C4::Output; +use warnings; use CGI; -use C4::Search; -use C4::Database; - -sub StringSearch { - my ($env,$searchstring,$type)=@_; - my $dbh = &C4Connect; - $searchstring=~ s/\'/\\\'/g; - my @data=split(' ',$searchstring); - my $count=@data; - my $query="Select currency,rate from currency where (currency like \"$data[0]%\") order by currency"; - my $sth=$dbh->prepare($query); - $sth->execute; - my @results; - my $cnt=0; - while (my $data=$sth->fetchrow_hashref){ - push(@results,$data); - $cnt ++; - } - # $sth->execute; - $sth->finish; - $dbh->disconnect; - return ($cnt,\@results); -} +use C4::Context; +use C4::Auth; +use C4::Dates qw(format_date); +use C4::Output; +use C4::Budgets qw/GetCurrency GetCurrencies/; + +my $input = CGI->new; +my $searchfield = $input->param('searchfield') || $input->param('description') || q{}; +my $offset = $input->param('offset') || 0; +my $op = $input->param('op') || q{}; +my $script_name = '/cgi-bin/koha/admin/currency.pl'; +my $pagesize = 20; + +my ($template, $loggedinuser, $cookie) = get_template_and_user({ + template_name => 'admin/currency.tmpl', + query => $input, + type => 'intranet', + flagsrequired => {parameters => 1}, + authnotrequired => 0, +}); -my $input = new CGI; -my $searchfield=$input->param('searchfield'); -my $pkfield="currency"; -my $reqsel="select currency,rate from currency where $pkfield='$searchfield'"; -my $reqdel="delete from currency where $pkfield='$searchfield'"; -#my $branchcode=$input->param('branchcode'); -my $offset=$input->param('offset'); -my $script_name="/cgi-bin/koha/admin/currency.pl"; - -my $pagesize=20; -my $op = $input->param('op'); $searchfield=~ s/\,//g; -print $input->header; - -#start the page and read in includes -print startpage(); -print startmenu('admin'); - -################## ADD_FORM ################################## -# called by default. Used to create form to add or modify a record -if ($op eq 'add_form') { - #---- if primkey exists, it's a modify action, so read values to modify... - my $data; - if ($searchfield) { - my $dbh = &C4Connect; - my $sth=$dbh->prepare("select currency,rate from currency where currency='$searchfield'"); - $sth->execute; - $data=$sth->fetchrow_hashref; - $sth->finish; - } - print < - ///////////////////////////////////////////////////////////////////////////////////////////////////////////////// - function isNotNull(f,noalert) { - if (f.value.length ==0) { - return false; - } - return true; - } - ///////////////////////////////////////////////////////////////////////////////////////////////////////////////// - function toUC(f) { - var x=f.value.toUpperCase(); - f.value=x; - return true; - } - ///////////////////////////////////////////////////////////////////////////////////////////////////////////////// - function isNum(v,maybenull) { - var n = new Number(v.value); - if (isNaN(n)) { - return false; - } - if (maybenull==0 && v.value=='') { - return false; - } - return true; - } - ///////////////////////////////////////////////////////////////////////////////////////////////////////////////// - function isDate(f) { - var t = Date.parse(f.value); - if (isNaN(t)) { - return false; - } - } - ///////////////////////////////////////////////////////////////////////////////////////////////////////////////// - function Check(f) { - var ok=1; - var _alertString=""; - var alertString2; - if (f.currency.value.length==0) { - _alertString += "- currency missing\\n"; - } - if (!isNum(f.rate)) { - _alertString += "- Rate not numeric\\n"; - } - if (_alertString.length==0) { - document.Aform.submit(); - } else { - alertString2 = "Form not submitted because of the following problem(s)\\n"; - alertString2 += "------------------------------------------------------------------------------------\\n\\n"; - alertString2 += _alertString; - alert(alertString2); - } - } - -printend -;#/ - if ($searchfield) { - print "

Modify currency

"; - } else { - print "

Add currency

"; - } - print "
"; - print ""; - print ""; - if ($searchfield) { - print ""; - } else { - print ""; - } - print ""; - print ""; - print "
Currency$searchfield
Currency
Rate 
 
"; - print "
"; -; - # END $OP eq ADD_FORM -################## ADD_VALIDATE ################################## -# called by add_form, used to insert/modify data in DB -} elsif ($op eq 'add_validate') { - my $dbh=C4Connect; - my $query = "replace currency (currency,rate) values ("; - $query.= $dbh->quote($input->param('currency')).","; - $query.= $dbh->quote($input->param('rate')).")"; - my $sth=$dbh->prepare($query); - $sth->execute; - $sth->finish; - print "data recorded"; - print "
"; - print ""; - print "
"; - # END $OP eq ADD_VALIDATE -################## DELETE_CONFIRM ################################## -# called by default form, used to confirm deletion of data in DB -} elsif ($op eq 'delete_confirm') { - my $dbh = &C4Connect; - my $sth=$dbh->prepare("select count(*) as total from aqbooksellers where currency='$searchfield'"); - $sth->execute; - my $total = $sth->fetchrow_hashref; - $sth->finish; - my $sth=$dbh->prepare($reqsel); - $sth->execute; - my $data=$sth->fetchrow_hashref; - $sth->finish; - print mktablehdr; - print mktablerow(2,'#99cc33',bold('Currency'),bold("$searchfield"),'/images/background-mem.gif'); - print "
"; - print "Rate$data->{'rate'}"; - if ($total->{'total'} >0) { - print "This record is used $total->{'total'} times. Deletion not possible"; - print "
"; - } else { - print "CONFIRM DELETION"; - print "
"; - } - # END $OP eq DELETE_CONFIRM -################## DELETE_CONFIRMED ################################## -# called by delete_confirm, used to effectively confirm deletion of data in DB -} elsif ($op eq 'delete_confirmed') { - my $dbh=C4Connect; -# my $searchfield=$input->param('branchcode'); - my $sth=$dbh->prepare($reqdel); - $sth->execute; - $sth->finish; - print "data deleted"; - print "
"; - print ""; - print "
"; - # END $OP eq DELETE_CONFIRMED -################## DEFAULT ################################## -} else { # DEFAULT - my @inputs=(["text","searchfield",$searchfield], - ["reset","reset","clr"]); - print mkheadr(2,'Currencies admin'); - print mkformnotable("$script_name",@inputs); - print <$searchfield

"; - } - print mktablehdr; - print mktablerow(4,'#99cc33',bold('Currency'),bold('Rate'), - ' ',' ','/images/background-mem.gif'); - my $env; - my ($count,$results)=StringSearch($env,$searchfield,'web'); - my $toggle="white"; - for (my $i=$offset; $i < ($offset+$pagesize<$count?$offset+$pagesize:$count); $i++){ - #find out stats - # my ($od,$issue,$fines)=categdata2($env,$results->[$i]{'borrowernumber'}); - # $fines=$fines+0; - if ($toggle eq 'white'){ - $toggle="#ffffcc"; - } else { - $toggle="white"; - } - print mktablerow(4,$toggle,$results->[$i]{'currency'},$results->[$i]{'rate'}, - mklink("$script_name?op=add_form&searchfield=".$results->[$i]{'currency'},'Edit'), - mklink("$script_name?op=delete_confirm&searchfield=".$results->[$i]{'currency'},'Delete')); - } - print mktableft; - print "

"; - print ""; - if ($offset>0) { - my $prevpage = $offset-$pagesize; - print mklink("$script_name?offset=".$prevpage,'<< Prev'); - } - print "      "; - if ($offset+$pagesize<$count) { - my $nextpage =$offset+$pagesize; - print mklink("$script_name?offset=".$nextpage,'Next >>'); - } - print "

"; - print "
"; -} #---- END $OP eq DEFAULT -print endmenu('admin'); -print endpage(); + + +$template->param(searchfield => $searchfield, + script_name => $script_name); + +my $dbh = C4::Context->dbh; + +if ( $op eq 'add_form' ) { + add_form($searchfield); +} elsif ( $op eq 'save' ) { + add_validate(); + print $input->redirect('/cgi-bin/koha/admin/currency.pl'); +} elsif ( $op eq 'delete_confirm' ) { + delete_confirm($searchfield); +} elsif ( $op eq 'delete_confirmed' ) { + delete_currency($searchfield); +} else { + default_path($searchfield); +} + +output_html_with_http_headers $input, $cookie, $template->output; + +sub default_path { + my $searchfield = shift; + $template->param( else => 1 ); + + my @currencies = GetCurrencies(); + if ($searchfield) { + @currencies = grep { $_->{currency} =~ m/^$searchfield/o } @currencies; + } + my $end_of_page = $offset + $pagesize; + if ( $end_of_page > @currencies ) { + $end_of_page = @currencies; + } else { + $template->param( + ltcount => 1, + nextpage => $end_of_page + ); + } + $end_of_page--; + my @display_curr = @currencies[ $offset .. $end_of_page ]; + for my $c (@display_curr) { + $c->{timestamp} = format_date( $c->{timestamp} ); + } + my $activecurrency = GetCurrency(); + + $template->param( + loop => \@display_curr, + activecurrency => defined $activecurrency, + ); + + if ( $offset > 0 ) { + $template->param( + offsetgtzero => 1, + prevpage => $offset - $pagesize + ); + } + return; +} + +sub delete_currency { + my $curr = shift; + + # TODO This should be a method of Currency + # also what about any orders using this currency + $template->param( delete_confirmed => 1 ); + $dbh->do( 'delete from currency where currency=?', {}, $curr ); + return; +} + +sub delete_confirm { + my $curr = shift; + + $template->param( delete_confirm => 1 ); + my $total_row = $dbh->selectrow_hashref( + 'select count(*) as total from aqbooksellers where currency=?', + {}, $curr ); + + my $curr_ref = $dbh->selectrow_hashref( + 'select currency,rate from currency where currency=?', + {}, $curr ); + + if ( $total_row->{total} ) { + $template->param( totalgtzero => 1 ); + } + + $template->param( + rate => $curr_ref->{rate}, + total => $total_row->{total} + ); + + return; +} + +sub add_form { + my $curr = shift; + + $template->param( add_form => 1 ); + + #---- if primkey exists, it's a modify action, so read values to modify... + if ($curr) { + my $curr_rec = + $dbh->selectrow_hashref( 'select * from currency where currency=?', + {}, $curr ); + for ( keys %{$curr_rec} ) { + $template->param( $_ => $curr_rec->{$_} ); + } + } + my $date = $template->param('timestamp'); + if ($date) { + $template->param( 'timestamp' => format_date($date) ); + } + + return; +} + +sub add_validate { + $template->param( add_validate => 1 ); + + my $rec = { + rate => $input->param('rate'), + symbol => $input->param('symbol') || q{}, + active => $input->param('active') || 0, + currency => $input->param('currency'), + }; + + if ( $rec->{active} == 1 ) { + $dbh->do('UPDATE currency SET active = 0'); + } + + my ($row_count) = $dbh->selectrow_array( + 'select count(*) as count from currency where currency = ?', + {}, $input->param('currency') ); + if ($row_count) { + $dbh->do( +q|UPDATE currency SET rate = ?, symbol = ?, active = ? WHERE currency = ? |, + {}, + $rec->{rate}, + $rec->{symbol}, + $rec->{active}, + $rec->{currency} + ); + } else { + $dbh->do( +q|INSERT INTO currency (currency, rate, symbol, active) VALUES (?,?,?,?) |, + {}, + $rec->{currency}, + $rec->{rate}, + $rec->{symbol}, + $rec->{active} + ); + + } + return; +}