X-Git-Url: http://git.rot13.org/?a=blobdiff_plain;f=admin%2Fitemtypes.pl;h=c8c224e7037f6ea31ede2a61a51937cae80b2c8c;hb=e8420b5d80558a8a74f7f6a1421352dcad2c9c88;hp=56bfb21b4eccca84e60a84c9606c42afc5c55c37;hpb=1e67687742e36bbb90746ecdd78a0c6a63aad890;p=koha.git diff --git a/admin/itemtypes.pl b/admin/itemtypes.pl index 56bfb21b4e..c8c224e703 100755 --- a/admin/itemtypes.pl +++ b/admin/itemtypes.pl @@ -1,296 +1,182 @@ #!/usr/bin/perl -#script to administer the categories table -#written 20/02/2002 by paul.poulain@free.fr -# This software is placed under the gnu General Public License, v2 (http://www.gnu.org/licenses/gpl.html) - -# ALGO : -# this script use an $op to know what to do. -# if $op is empty or none of the above values, -# - the default screen is build (with all records, or filtered datas). -# - the user can clic on add, modify or delete record. -# if $op=add_form -# - if primkey exists, this is a modification,so we read the $primkey record -# - builds the add/modify form -# if $op=add_validate -# - the user has just send datas, so we create/modify the record -# if $op=delete_form -# - we show the record having primkey=$primkey and ask for deletion validation form -# if $op=delete_confirm -# - we delete the record having primkey=$primkey - - # Copyright 2000-2002 Katipo Communications +# Copyright 2002 Paul Poulain # # 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 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 3 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. +# 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., 59 Temple Place, -# Suite 330, Boston, MA 02111-1307 USA +# You should have received a copy of the GNU General Public License +# along with Koha; if not, see . + +=head1 admin/itemtypes.pl + +=cut + +use Modern::Perl; +use CGI qw ( -utf8 ); -use strict; +use File::Spec; + +use C4::Koha; +use C4::Context; +use C4::Auth; use C4::Output; -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 * from itemtypes where (description like \"$data[0]%\") order by itemtype"; - 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 Koha::ItemTypes; +use Koha::Localizations; + +my $input = new CGI; +my $searchfield = $input->param('description'); +my $itemtype_code = $input->param('itemtype'); +my $op = $input->param('op') // 'list'; +my @messages; +$searchfield =~ s/\,//g if $searchfield; +my ( $template, $borrowernumber, $cookie ) = get_template_and_user( + { template_name => "admin/itemtypes.tt", + query => $input, + type => "intranet", + authnotrequired => 0, + flagsrequired => { parameters => 'parameters_remaining_permissions' }, + debug => 1, + } +); + +my $dbh = C4::Context->dbh; + +my $sip_media_type = $input->param('sip_media_type'); +undef($sip_media_type) if defined($sip_media_type) and $sip_media_type =~ /^\s*$/; + +if ( $op eq 'add_form' ) { + my $itemtype = Koha::ItemTypes->find($itemtype_code); + my $imagesets = C4::Koha::getImageSets( checked => ( $itemtype ? $itemtype->imageurl : undef ) ); + my $searchcategory = GetAuthorisedValues("ITEMTYPECAT"); + my $translated_languages = C4::Languages::getTranslatedLanguages( undef , C4::Context->preference('template') ); + $template->param( + itemtype => $itemtype, + imagesets => $imagesets, + searchcategory => $searchcategory, + can_be_translated => ( scalar(@$translated_languages) > 1 ? 1 : 0 ), + ); +} elsif ( $op eq 'add_validate' ) { + my $is_a_modif = $input->param('is_a_modif'); + my $itemtype = Koha::ItemTypes->find($itemtype_code); + my $description = $input->param('description'); + my $rentalcharge = $input->param('rentalcharge'); + my $image = $input->param('image') || q||; -my $input = new CGI; -my $searchfield=$input->param('description'); -my $offset=$input->param('offset'); -my $script_name="/cgi-bin/koha/admin/itemtypes.pl"; -my $itemtype=$input->param('itemtype'); -my $pagesize=20; -my $op = $input->param('op'); -$searchfield=~ s/\,//g; -print $input->header; + my $notforloan = $input->param('notforloan') ? 1 : 0; + my $imageurl = + $image eq 'removeImage' ? '' + : ( + $image eq 'remoteImage' ? $input->param('remoteImage') + : $image + ); + my $summary = $input->param('summary'); + my $checkinmsg = $input->param('checkinmsg'); + my $checkinmsgtype = $input->param('checkinmsgtype'); + my $hideinopac = $input->param('hideinopac') // 0; + my $searchcategory = $input->param('searchcategory'); -#start the page and read in includes -print startpage(); -print startmenu('admin'); + if ( $itemtype and $is_a_modif ) { # it's a modification + $itemtype->description($description); + $itemtype->rentalcharge($rentalcharge); + $itemtype->notforloan($notforloan); + $itemtype->imageurl($imageurl); + $itemtype->summary($summary); + $itemtype->checkinmsg($checkinmsg); + $itemtype->checkinmsgtype($checkinmsgtype); + $itemtype->sip_media_type($sip_media_type); + $itemtype->hideinopac($hideinopac); + $itemtype->searchcategory($searchcategory); + + eval { $itemtype->store; }; + + if ($@) { + push @messages, { type => 'error', code => 'error_on_update' }; + } else { + push @messages, { type => 'message', code => 'success_on_update' }; + } + } elsif ( not $itemtype and not $is_a_modif ) { + my $itemtype = Koha::ItemType->new( + { itemtype => $itemtype_code, + description => $description, + rentalcharge => $rentalcharge, + notforloan => $notforloan, + imageurl => $imageurl, + summary => $summary, + checkinmsg => $checkinmsg, + checkinmsgtype => $checkinmsgtype, + sip_media_type => $sip_media_type, + hideinopac => $hideinopac, + searchcategory => $searchcategory, + } + ); + eval { $itemtype->store; }; + + if ($@) { + push @messages, { type => 'error', code => 'error_on_insert' }; + } else { + push @messages, { type => 'message', code => 'success_on_insert' }; + } + } else { + push @messages, + { type => 'error', + code => 'already_exists', + }; + } + + $searchfield = ''; + $op = 'list'; +} elsif ( $op eq 'delete_confirm' ) { + + # Check both items and biblioitems + my ($total) = $dbh->selectrow_array( ' + SELECT COUNT(*) AS total FROM ( + SELECT itemtype AS t FROM biblioitems + UNION ALL + SELECT itype AS t FROM items + ) AS tmp + WHERE tmp.t=? + ', {}, $itemtype_code ); + + if ($total) { + push @messages, { type => 'error', code => 'cannot_be_deleted', total => $total }; + $op = 'list'; + } else { + my $itemtype = Koha::ItemTypes->find($itemtype_code); + $template->param( itemtype => $itemtype, ); + } + +} elsif ( $op eq 'delete_confirmed' ) { + my $itemtype = Koha::ItemTypes->find($itemtype_code); + my $deleted = eval { $itemtype->delete }; + if ( $@ or not $deleted ) { + push @messages, { type => 'error', code => 'error_on_delete' }; + } else { + push @messages, { type => 'message', code => 'success_on_delete' }; + } + + $op = 'list'; +} + +if ( $op eq 'list' ) { + my $itemtypes = Koha::ItemTypes->search; + $template->param( + itemtypes => $itemtypes, + messages => \@messages, + ); +} -################## 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 ($itemtype) { - my $dbh = &C4Connect; - my $sth=$dbh->prepare("select itemtype,description,loanlength,renewalsallowed,rentalcharge from itemtypes where itemtype='$itemtype'"); - $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.itemtype.value.length==0) { - _alertString += "- itemtype missing\\n"; - } - if (!(isNotNull(window.document.Aform.description,1))) { - _alertString += "- description missing\\n"; - } - if (!isNum(f.loanlength,0)) { - _alertString += "- loan length is not a number\\n"; - } - if (!isNum(f.rentalcharge,0)) { - _alertString += "- loan length is not a number\\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 ($itemtype) { - print "

Modify item type

"; - } else { - print "

Add item type

"; - } - print "
"; - print ""; - print ""; - print ""; - if ($itemtype) { - print ""; - } else { - print ""; - } - print ""; - print ""; - if ($data->{'renewalsallowed'} eq 1) { - print ""; - } else { - print ""; - } -# print ""; - print ""; - print ""; -print "
Item type$itemtype
Item type
Description 
loan length
Renewals allowed
Renewals allowed
Renewals allowed
Rental charge
 
"; - 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 itemtypes (itemtype,description,loanlength,renewalsallowed,rentalcharge) values ("; - $query.= $dbh->quote($input->param('itemtype')).","; - $query.= $dbh->quote($input->param('description')).","; - $query.= $dbh->quote($input->param('loanlength')).","; - if ($input->param('renewalsallowed') ne 1) { - $query.= "0,"; - } else { - $query.= "1,"; - } - $query.= $dbh->quote($input->param('rentalcharge')).")"; - 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 categoryitem where itemtype='$itemtype'"); - $sth->execute; - my $total = $sth->fetchrow_hashref; - $sth->finish; - my $sth=$dbh->prepare("select itemtype,description,loanlength,renewalsallowed,rentalcharge from itemtypes where itemtype='$itemtype'"); - $sth->execute; - my $data=$sth->fetchrow_hashref; - $sth->finish; - print mktablehdr; - print mktablerow(2,'#99cc33',bold('Item type'),bold("$itemtype"),'/images/background-mem.gif'); - print "
"; - print "Description$data->{'description'}"; - print "Loan length$data->{'loanlength'}"; - print "Renewals allowed$data->{'renewalsallowed'}"; - print "Rental charge$data->{'rentalcharge'}"; - 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 $itemtype=uc($input->param('itemtype')); - my $query = "delete from itemtypes where itemtype='$itemtype'"; - my $sth=$dbh->prepare($query); - $sth->execute; - $sth->finish; - print "data deleted"; - print "
"; - print ""; - print "
"; - # END $OP eq DELETE_CONFIRMED -################## DEFAULT ################################## -} else { # DEFAULT - my @inputs=(["text","description",$searchfield], - ["reset","reset","clr"]); - print mkheadr(2,'Item types admin'); - print mkformnotable("$script_name",@inputs); - print <param( op => $op ); -printend - ; - if ($searchfield ne '') { - print "You Searched for $searchfield

"; - } - print mktablehdr; - print mktablerow(7,'#99cc33',bold('Code'),bold('Description'),bold('loan
length'),bold('Renewals
allowed') - ,bold('Rental
charge'),' ',' ','/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(7,$toggle,$results->[$i]{'itemtype'}, - $results->[$i]{'description'},$results->[$i]{'loanlength'}, - $results->[$i]{'renewalsallowed'}==1?'Yes':'No',$results->[$i]{'rentalcharge'}, - mklink("$script_name?op=add_form&itemtype=".$results->[$i]{'itemtype'},'Edit'), - mklink("$script_name?op=delete_confirm&itemtype=".$results->[$i]{'itemtype'},'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(); +output_html_with_http_headers $input, $cookie, $template->output;