5 #script to update charges for overdue in database
7 # is called by charges.pl
8 # written 1/1/2000 by chris@katipo.co.nz
11 # Copyright 2000-2002 Katipo Communications
13 # This file is part of Koha.
15 # Koha is free software; you can redistribute it and/or modify it under the
16 # terms of the GNU General Public License as published by the Free Software
17 # Foundation; either version 2 of the License, or (at your option) any later
20 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
21 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
22 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
24 # You should have received a copy of the GNU General Public License along with
25 # Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
26 # Suite 330, Boston, MA 02111-1307 USA
35 my $dbh = C4::Context->dbh;
36 my @names=$input->param();
38 foreach my $key (@names){
42 my $data=$input->param($key);
43 my @dat=split(',',$data);
44 my $sth_search = $dbh->prepare("select count(*) as total from categoryitem where categorycode=? and itemtype=?");
45 my $sth_insert = $dbh->prepare("insert into categoryitem (categorycode,itemtype,fine,firstremind,chargeperiod) values (?,?,?,?,?)");
46 my $sth_update=$dbh->prepare("Update categoryitem set fine=?,firstremind=?,chargeperiod=? where categorycode=? and itemtype=?");
47 $sth_search->execute($bor,$cat);
48 my $res = $sth_search->fetchrow_hashref();
50 $sth_update->execute($dat[0],$dat[1],$dat[2],$bor,$cat);
52 $sth_insert->execute($bor,$cat,$dat[0],$dat[1],$dat[2]);
55 print $input->redirect("/cgi-bin/koha/admin/charges.pl");