#!/usr/bin/perl
-#written 11/3/2002 by Finlay
#script to execute branch transfers of books
+# Copyright 2000-2002 Katipo Communications
+# copyright 2010 BibLibre
+#
+# 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 warnings;
use CGI;
-use C4::Circulation::Circ2;
-use C4::Search;
+use C4::Circulation;
use C4::Output;
+use C4::Reserves;
+use C4::Biblio;
+use C4::Items;
+use C4::Auth qw/:DEFAULT get_session/;
+use C4::Branch; # GetBranches
+use C4::Koha;
+use C4::Members;
+
+###############################################
+# Getting state
+
+my $query = new CGI;
+
+if (!C4::Context->userenv){
+ my $sessionID = $query->cookie("CGISESSID");
+ my $session;
+ $session = get_session($sessionID) if $sessionID;
+ if (!$session or $session->param('branch') eq 'NO_LIBRARY_SET'){
+ # no branch set we can't transfer
+ print $query->redirect("/cgi-bin/koha/circ/selectbranchprinter.pl");
+ exit;
+ }
+}
-
-my %env;
-my $headerbackgroundcolor='#99cc33';
-my $circbackgroundcolor='#ffffcc';
-my $circbackgroundcolor='white';
-my $linecolor1='#ffffcc';
-my $linecolor2='white';
-my $backgroundimage="/images/background-mem.gif";
-
-my $query=new CGI;
-my $branches=getbranches(\%env);
-
-my $tobranchcd=$query->param('tobranchcd');
-my $frbranchcd='';
-
-$env{'tobranchcd'}=$tobranchcd;
-
-
-my $tobranchoptions;
-foreach (keys %$branches) {
- (next) unless ($_);
- (next) if (/^TR$/);
- my $selected='';
- ($selected='selected') if ($_ eq $tobranchcd);
- $tobranchoptions.="<option value=$_ $selected>$branches->{$_}->{'branchname'}\n";
+#######################################################################################
+# Make the page .....
+my ($template, $user, $cookie) = get_template_and_user(
+ {
+ template_name => "circ/branchtransfers.tmpl",
+ query => $query,
+ type => "intranet",
+ authnotrequired => 0,
+ flagsrequired => { circulate => "circulate_remaining_permissions" },
+ }
+);
+
+my $branches = GetBranches;
+
+my $messages;
+my $found;
+my $reserved;
+my $waiting;
+my $reqmessage;
+my $cancelled;
+my $setwaiting;
+
+my $request = $query->param('request') || '';
+my $borrowernumber = $query->param('borrowernumber') || 0;
+my $tobranchcd = $query->param('tobranchcd') || '';
+
+my $ignoreRs = 0;
+############
+# Deal with the requests....
+if ( $request eq "KillWaiting" ) {
+ my $item = $query->param('itemnumber');
+ CancelReserve({
+ itemnumber => $item,
+ borrowernumber => $borrowernumber
+ });
+ $cancelled = 1;
+ $reqmessage = 1;
+}
+elsif ( $request eq "SetWaiting" ) {
+ my $item = $query->param('itemnumber');
+ ModReserveAffect( $item, $borrowernumber );
+ $ignoreRs = 1;
+ $setwaiting = 1;
+ $reqmessage = 1;
+}
+elsif ( $request eq 'KillReserved' ) {
+ my $biblio = $query->param('biblionumber');
+ CancelReserve({
+ biblionumber => $biblio,
+ borrowernumber => $borrowernumber
+ });
+ $cancelled = 1;
+ $reqmessage = 1;
}
# collect the stack of books already transfered so they can printed...
+my @trsfitemloop;
my %transfereditems;
-my $ritext = '';
-my %frbranchcds;
-my %tobranchcds;
-foreach ($query->param){
- (next) unless (/bc-(\d*)/);
- my $counter=$1;
- (next) if ($counter>20);
- my $barcode=$query->param("bc-$counter");
- my $frbcd=$query->param("fb-$counter");
- my $tobcd=$query->param("tb-$counter");
- $counter++;
- $transfereditems{$counter}=$barcode;
- $frbranchcds{$counter}=$frbcd;
- $tobranchcds{$counter}=$tobcd;
- $ritext.="<input type=hidden name=bc-$counter value=$barcode>\n";
- $ritext.="<input type=hidden name=fb-$counter value=$frbcd>\n";
- $ritext.="<input type=hidden name=tb-$counter value=$tobcd>\n";
- }
-
-#if the barcode has been entered action that and write a message and onto the top of the stack...
-my $iteminformation;
-my @messages;
-my $todaysdate;
-if (my $barcode=$query->param('barcode')) {
- my $iteminformation = getiteminformation(\%env,0, $barcode);
- my $fail=0;
- if (not $iteminformation) {
- $fail=1;
- @messages = ("There is no book with barcode: $barcode ", @messages);
- }
- $frbranchcd = $iteminformation->{'holdingbranch'};
- %env->{'frbranchcd'} = $frbranchcd;
- if ($frbranchcd eq $tobranchcd) {
- $fail=1;
- @messages = ("You can't transfer the book to the branch it is already at!", @messages);
- }
-# should add some more tests ... like is the book already out, maybe it cant be moved....
- if (not $fail) {
- my ($transfered, $message) = transferbook(\%env, $iteminformation, $barcode);
- if (not $transfered) {@messages = ($message, @messages);}
- else {
- $ritext.="<input type=hidden name=bc-0 value=$barcode>\n";
- $ritext.="<input type=hidden name=fb-0 value=$frbranchcd>\n";
- $ritext.="<input type=hidden name=tb-0 value=$tobranchcd>\n";
- $transfereditems{0}=$barcode;
- $frbranchcds{0}=$frbranchcd;
- $tobranchcds{0}=$tobranchcd;
- @messages = ("Book: $barcode has been transfered", @messages);
- }
+my $transfered;
+my $barcode = $query->param('barcode');
+# strip whitespace
+defined $barcode and $barcode =~ s/\s*//g; # FIXME: barcodeInputFilter
+# warn "barcode : $barcode";
+if ($barcode) {
+
+ my $iteminformation;
+ ( $transfered, $messages, $iteminformation ) =
+ transferbook( $tobranchcd, $barcode, $ignoreRs );
+# use Data::Dumper;
+# warn "Transfered : $transfered / ".Dumper($messages);
+ $found = $messages->{'ResFound'};
+ if ($transfered) {
+ my %item;
+ my $frbranchcd = C4::Context->userenv->{'branch'};
+# if ( not($found) ) {
+ $item{'biblionumber'} = $iteminformation->{'biblionumber'};
+ $item{'itemnumber'} = $iteminformation->{'itemnumber'};
+ $item{'title'} = $iteminformation->{'title'};
+ $item{'author'} = $iteminformation->{'author'};
+ $item{'itemtype'} = $iteminformation->{'itemtype'};
+ $item{'ccode'} = $iteminformation->{'ccode'};
+ $item{'itemcallnumber'} = $iteminformation->{'itemcallnumber'};
+ $item{'location'} = GetKohaAuthorisedValueLib("LOC",$iteminformation->{'location'});
+ $item{'frbrname'} = $branches->{$frbranchcd}->{'branchname'};
+ $item{'tobrname'} = $branches->{$tobranchcd}->{'branchname'};
+# }
+ $item{counter} = 0;
+ $item{barcode} = $barcode;
+ $item{frombrcd} = $frbranchcd;
+ $item{tobrcd} = $tobranchcd;
+ push( @trsfitemloop, \%item );
+# warn Dumper(@trsfitemloop);
}
}
-my $entrytext= << "EOF";
-<form method=post action=/cgi-bin/koha/circ/branchtransfers.pl>
-<table border=0 cellpadding=5 cellspacing=0 bgcolor=#dddddd >
-<tr><td colspan=2 bgcolor=$headerbackgroundcolor align=center background=$backgroundimage>
-<font color=black><b>Select Branch</b></font></td></tr>
-<tr><td>Destination Branch:</td><td>
- <select name=tobranchcd> $tobranchoptions </select>
-</td></tr>
-
-</table><table border=0 cellpadding=5 cellspacing=0 bgcolor=#dddddd >
-<tr><td colspan=2 bgcolor=$headerbackgroundcolor align=center background=$backgroundimage>
-<font color=black><b>Enter Book Barcode</b></font></td></tr>
-<tr><td>Item Barcode:</td><td><input name=barcode size=10></td></tr>
-</table>
-
-<input type=hidden name=tobranchcd value=$tobranchcd>
-$ritext
-EOF
-
-my $messagetable;
-if (@messages) {
- my $messagetext='';
- foreach (@messages) {
- $messagetext.="$_<p>\n";
- }
- $messagetable = << "EOF";
-<table border=0 cellpadding=5 cellspacing=0 bgcolor='#dddddd'>
-<tr><th bgcolor=$headerbackgroundcolor background=$backgroundimage><font color=black>Messages</font></th></tr>
-<tr><td> $messagetext </td></tr></table>
-EOF
+foreach ( $query->param ) {
+ (next) unless (/bc-(\d*)/);
+ my $counter = $1;
+ my %item;
+ my $bc = $query->param("bc-$counter");
+ my $frbcd = $query->param("fb-$counter");
+ my $tobcd = $query->param("tb-$counter");
+ $counter++;
+ $item{counter} = $counter;
+ $item{barcode} = $bc;
+ $item{frombrcd} = $frbcd;
+ $item{tobrcd} = $tobcd;
+ my ($iteminformation) = GetBiblioFromItemNumber( GetItemnumberFromBarcode($bc) );
+ $item{'biblionumber'} = $iteminformation->{'biblionumber'};
+ $item{'itemnumber'} = $iteminformation->{'itemnumber'};
+ $item{'title'} = $iteminformation->{'title'};
+ $item{'author'} = $iteminformation->{'author'};
+ $item{'itemtype'} = $iteminformation->{'itemtype'};
+ $item{'ccode'} = $iteminformation->{'ccode'};
+ $item{'itemcallnumber'} = $iteminformation->{'itemcallnumber'};
+ $item{'location'} = GetKohaAuthorisedValueLib("LOC",$iteminformation->{'location'});
+ $item{'frbrname'} = $branches->{$frbcd}->{'branchname'};
+ $item{'tobrname'} = $branches->{$tobcd}->{'branchname'};
+ push( @trsfitemloop, \%item );
}
+my $itemnumber;
+my $biblionumber;
+#####################
-print $query->header;
-print startpage;
-print startmenu('circulation');
-print "<h3>Branch Transfers</h3>";
-
-
-print $messagetable if (@messages);
-
-
-print $entrytext;
-
-if (%transfereditems) {
- print << "EOF";
-<p>
-<table border=0 cellpadding=5 cellspacing=0 bgcolor=#dddddd>
-<tr><th colspan=6 bgcolor=$headerbackgroundcolor background=$backgroundimage><font color=black>Transfered Items</font></th></tr>
-<tr><th>Bar Code</th><th>Title</th><th>Author</th><th>Type</th><th>From</th><th>To</th></tr>
-EOF
- my $color='';
- foreach (keys %transfereditems) {
- ($color eq $linecolor1) ? ($color=$linecolor2) : ($color=$linecolor1);
- my $barcode=$transfereditems{$_};
- my $frbcd=$frbranchcds{$_};
- my $tobcd=$tobranchcds{$_};
- my ($iteminformation) = getiteminformation(\%env, 0, $barcode);
- print << "EOF";
-<tr><td bgcolor=$color align=center>
-<a href=/cgi-bin/koha/detail.pl?bib=$iteminformation->{'biblionumber'}
-&type=intra onClick=\"openWindow(this, 'Item', 480, 640)\">$barcode</a></td>
-<td bgcolor=$color>$iteminformation->{'title'}</td>
-<td bgcolor=$color>$iteminformation->{'author'}</td>
-<td bgcolor=$color align=center>$iteminformation->{'itemtype'}</td>
-<td bgcolor=$color align=center>$branches->{$frbcd}->{'branchname'}</td>
-<td bgcolor=$color align=center>$branches->{$tobcd}->{'branchname'}</td>
-</tr>\n
-EOF
-}
- print "</table>\n";
-}
+if ($found) {
+ my $res = $messages->{'ResFound'};
+ $itemnumber = $res->{'itemnumber'};
-print endmenu('circulation');
-print endpage;
+ if ( $res->{'ResFound'} eq "Waiting" ) {
+ $waiting = 1;
+ }
+ elsif ( $res->{'ResFound'} eq "Reserved" ) {
+ $reserved = 1;
+ $biblionumber = $res->{'biblionumber'};
+ }
+}
+#####################
-############################################################################
-#
-# this is the database query that will go into C4::Circuation::Circ2
-#
+# Used for branch transfer limits error messages.
+my $codeTypeDescription = 'Collection Code';
+my $codeType = C4::Context->preference("BranchTransferLimitsType");
+if ( $codeType eq 'itemtype' ) {
+ $codeTypeDescription = 'Item Type';
+}
-use DBI;
-use C4::Database;
-
-sub transferbook {
- my ($env, $iteminformation, $barcode) = @_;
- my $messages;
- my $dbh=&C4Connect;
- #new entry in branchtransfers....
- my $sth = $dbh->prepare("insert into branchtransfers (itemnumber, frombranch, datearrived, tobranch) values($iteminformation->{'itemnumber'}, '$env->{'frbranchcd'}', now(), '$env->{'tobranchcd'}')");
- $sth->execute || return (0,"database error: $sth->errstr");
- $sth->finish;
- #update holdingbranch in items .....
- $sth = $dbh->prepare("update items set holdingbranch='$env->{'tobranchcd'}' where items.itemnumber=$iteminformation->{'itemnumber'}");
- $sth->execute || return (0,"database error: $sth->errstr");
- $sth->execute;
- $sth->finish;
- $dbh->disconnect;
- return (1, $messages);
+my @errmsgloop;
+foreach my $code ( keys %$messages ) {
+ if ( $code ne 'WasTransfered' ) {
+ my %err;
+ if ( $code eq 'BadBarcode' ) {
+ $err{msg} = $messages->{'BadBarcode'};
+ $err{errbadcode} = 1;
+ }
+ elsif ( $code eq "NotAllowed" ) {
+ warn "NotAllowed: $messages->{'NotAllowed'} to " . $branches->{ $messages->{'NotAllowed'} }->{'branchname'};
+ # Do we really want a error log message here? --atz
+ $err{errnotallowed} = 1;
+ my ( $tbr, $typecode ) = split( /::/, $messages->{'NotAllowed'} );
+ $err{tbr} = $branches->{ $tbr }->{'branchname'};
+ $err{code} = $typecode;
+ $err{codeType} = $codeTypeDescription;
+ }
+ elsif ( $code eq 'IsPermanent' ) {
+ $err{errispermanent} = 1;
+ $err{msg} = $branches->{ $messages->{'IsPermanent'} }->{'branchname'};
+ }
+ elsif ( $code eq 'WasReturned' ) {
+ $err{errwasreturned} = 1;
+ $err{borrowernumber} = $messages->{'WasReturned'};
+ my $borrower = GetMember('borrowernumber'=>$messages->{'WasReturned'});
+ $err{title} = $borrower->{'title'};
+ $err{firstname} = $borrower->{'firstname'};
+ $err{surname} = $borrower->{'surname'};
+ $err{cardnumber} = $borrower->{'cardnumber'};
+ }
+ $err{errdesteqholding} = ( $code eq 'DestinationEqualsHolding' );
+ push( @errmsgloop, \%err );
+ }
}
+# use Data::Dumper;
+# warn "FINAL ============= ".Dumper(@trsfitemloop);
+$template->param(
+ found => $found,
+ reserved => $reserved,
+ waiting => $waiting,
+ borrowernumber => $borrowernumber,
+ itemnumber => $itemnumber,
+ barcode => $barcode,
+ biblionumber => $biblionumber,
+ tobranchcd => $tobranchcd,
+ reqmessage => $reqmessage,
+ cancelled => $cancelled,
+ setwaiting => $setwaiting,
+ trsfitemloop => \@trsfitemloop,
+ branchoptionloop => GetBranchesLoop($tobranchcd),
+ errmsgloop => \@errmsgloop,
+ CircAutocompl => C4::Context->preference("CircAutocompl")
+);
+output_html_with_http_headers $query, $cookie, $template->output;
projects / koha.git / blobdiff