From 22b8970807c5910fcb754b4750c9da1885a95407 Mon Sep 17 00:00:00 2001 From: genjimoto Date: Thu, 2 Jun 2005 03:31:16 +0000 Subject: [PATCH] script to edit the item subcategory table. --- admin/itemtypesubcategory.pl | 199 +++++++++++++++++++++++++++++++++++ 1 file changed, 199 insertions(+) create mode 100644 admin/itemtypesubcategory.pl diff --git a/admin/itemtypesubcategory.pl b/admin/itemtypesubcategory.pl new file mode 100644 index 0000000000..3b25aea076 --- /dev/null +++ b/admin/itemtypesubcategory.pl @@ -0,0 +1,199 @@ +#!/usr/bin/perl +# NOTE: 4-character tabs + +#script to administer the itemtype subcategories table +#modified from the itemtype script written 20/02/2002 by paul.poulain@free.fr +#This script written by waylon@robertson.net.nz at 2nd June, 2005 +# 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 +# +# 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., 59 Temple Place, +# Suite 330, Boston, MA 02111-1307 USA + +use strict; +use CGI; +use C4::Context; +use C4::Output; +use C4::Search; +use C4::Auth; +use C4::Interface::CGI::Output; +use HTML::Template; + +sub StringSearch { + my ($env,$searchstring,$type)=@_; + my $dbh = C4::Context->dbh; + $searchstring=~ s/\'/\\\'/g; + my @data=split(' ',$searchstring); + my $count=@data; + my $sth=$dbh->prepare("Select * from subcategorytable where (description like ?) order by subcategorycode"); + $sth->execute("$data[0]%"); + my @results; + while (my $data=$sth->fetchrow_hashref){ + push(@results,$data); + } + # $sth->execute; + $sth->finish; + return (scalar(@results),\@results); +} + +my $input = new CGI; +my $searchfield=$input->param('description'); +my $offset=$input->param('offset'); +my $script_name="/cgi-bin/koha/admin/itemtypesubcategory.pl"; +my $subcategorycode=$input->param('subcategorycode'); +my $pagesize=20; +my $op = $input->param('op'); +$searchfield=~ s/\,//g; +my ($template, $borrowernumber, $cookie) + = get_template_and_user({template_name => "parameters/itemtypesubcategory.tmpl", + query => $input, + type => "intranet", + authnotrequired => 0, + flagsrequired => {parameters => 1, management => 1}, + debug => 1, + }); + +if ($op) { +$template->param(script_name => $script_name, + $op => 1); # we show only the TMPL_VAR names $op +} else { +$template->param(script_name => $script_name, + else => 1); # we show only the TMPL_VAR names $op +} +################## ADD_FORM ################################## +# called by default. Used to create form to add or modify a record +if ($op eq 'add_form') { + #start the page and read in includes + #---- if primkey exists, it's a modify action, so read values to modify... + my $data; + my $itemtypes; + my $dbh = C4::Context->dbh; + my @itemtypesselected; + if ($subcategorycode) { + my $sth=$dbh->prepare("select subcategorycode,description,itemtypecodes from subcategorytable where subcategorycode=?"); + $sth->execute($subcategorycode); + $data=$sth->fetchrow_hashref; + $sth->finish; + @itemtypesselected = split ( /\|/, $data->{'itemtypecodes'} ); + } + + my $sth=$dbh->prepare("select description,itemtype from itemtypes order by description"); + $sth->execute; + while (my ($description,$itemtype) = $sth->fetchrow) { + $itemtypes .=''; + } + + $template->param(subcategorycode => $subcategorycode, + description => $data->{'description'}, + itemtypes => $itemtypes + ); +; + # 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 = C4::Context->dbh; + my @itemtypecodesarray = $input->param('itemtypecodes'); + my $itemtypecodes=join('|',@itemtypecodesarray); + my $sth=$dbh->prepare("replace subcategorytable (subcategorycode,description,itemtypecodes) values (?,?,?)"); + $sth->execute( + $input->param('subcategorycode'),$input->param('description'), + $itemtypecodes + ); + $sth->finish; + print "Content-Type: text/html\n\n"; + exit; + # END $OP eq ADD_VALIDATE +################## DELETE_CONFIRM ################################## +# called by default form, used to confirm deletion of data in DB +} elsif ($op eq 'delete_confirm') { + #start the page and read in includes + my $dbh = C4::Context->dbh; + my $sth=$dbh->prepare("select subcategorycode,description,itemtypecodes from subcategorytable where subcategorycode=?"); + $sth->execute($subcategorycode); + my $data=$sth->fetchrow_hashref; + $sth->finish; + + $template->param(subcategorycode => $subcategorycode, + description => $data->{'description'}, + itemtypecodes => $data->{'itemtypecodes'}); + # 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') { + #start the page and read in includes + my $dbh = C4::Context->dbh; + my $subcategorycode=uc($input->param('subcategorycode')); + my $sth=$dbh->prepare("delete from subcategorytable where subcategorycode=?"); + $sth->execute($subcategorycode); + $sth->finish; + print "Content-Type: text/html\n\n"; + exit; + # END $OP eq DELETE_CONFIRMED +################## DEFAULT ################################## +} else { # DEFAULT + my $env; + my ($count,$results)=StringSearch($env,$searchfield,'web'); + my $toggle=0; + my @loop_data; + for (my $i=$offset; $i < ($offset+$pagesize<$count?$offset+$pagesize:$count); $i++){ + my %row_data; + if ($toggle eq 0){ + $toggle=1; + } else { + $toggle=0; + } + $row_data{toggle} = $toggle; + $row_data{subcategorycode} = $results->[$i]{subcategorycode}; + $row_data{description} = $results->[$i]{description}; + $row_data{itemtypecodes} = $results->[$i]{itemtypecodes}; + push(@loop_data, \%row_data); + } + $template->param(loop => \@loop_data); + if ($offset>0) { + my $prevpage = $offset-$pagesize; + $template->param(previous => "$script_name?offset=".$prevpage); + } + if ($offset+$pagesize<$count) { + my $nextpage =$offset+$pagesize; + $template->param(next => "$script_name?offset=".$nextpage); + } +} #---- END $OP eq DEFAULT +output_html_with_http_headers $input, $cookie, $template->output; + +# Local Variables: +# tab-width: 4 +# End: -- 2.39.5