[Koha-devel] CVS: koha/circ branchtransfers.pl,NONE,1.1 circulation.pl,1.20,1.21

[Finlay Thompson]

Update of /cvsroot/koha/koha/circ
In directory usw-pr-cvs1:/tmp/cvs-serv25121

Modified Files:
        circulation.pl 
Added Files:
        branchtransfers.pl 
Log Message:

Branchtransfers.pl provides a form for entering barcodes and selecting a
destination branch.

New rows are entered into the branchtransfers table for each item
"transfered".



--- NEW FILE ---
#!/usr/bin/perl

#written 11/3/2002 by Finlay
#script to execute branch transfers of books

use strict;
use CGI;
use C4::Circulation::Circ2;
use C4::Search;
use C4::Output;


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";
}

# collect the stack of books already transfered so they can printed...
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) address@hidden = ($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 $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
}



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";
}

print endmenu('circulation');
print endpage;


############################################################################
#
# this is the database query that will go into C4::Circuation::Circ2
#

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);
}



Index: circulation.pl
===================================================================
RCS file: /cvsroot/koha/koha/circ/circulation.pl,v
retrieving revision 1.20
retrieving revision 1.21
diff -C2 -r1.20 -r1.21
*** circulation.pl      17 Aug 2001 07:54:38 -0000      1.20
--- circulation.pl      12 Mar 2002 21:04:32 -0000      1.21
***************
*** 263,267 ****
        $barcodeentrytext.= "<input type=hidden name=bn-0 
value=$borrower->{'borrowernumber'}>\n";
        my @datearr = localtime(time());
!       my $todaysdate = (1900+$datearr[5]).'-'.sprintf ("%0.2d", 
($datearr[4]+1)).'-'.sprintf ("%0.2d", $datearr[3]);
        my $itemtable=<<"EOF";
  <table border=0 cellpadding=5 cellspacing=0 bgcolor=#dddddd>
--- 263,268 ----
        $barcodeentrytext.= "<input type=hidden name=bn-0 
value=$borrower->{'borrowernumber'}>\n";
        my @datearr = localtime(time());
!       my $todaysdate = (1900+$datearr[5]).'-'.sprintf ("%0.2d", 
($datearr[4]+1)).'-'.
!         sprintf ("%0.2d", $datearr[3]);
        my $itemtable=<<"EOF";
  <table border=0 cellpadding=5 cellspacing=0 bgcolor=#dddddd>
***************
*** 465,470 ****
        <FONT SIZE=2  face="arial, helvetica">
        <a 
href=circulation.pl?borrnumber=$borrowernumber&module=issues&branch=$branch&printer=$printer&print>Next
 Borrower</a> ||
!       <a 
href=circulation.pl?module=returns&branch=$branch&printer=$printer>Returns</a></font><p>
!        
          
        </p>
--- 466,471 ----
        <FONT SIZE=2  face="arial, helvetica">
        <a 
href=circulation.pl?borrnumber=$borrowernumber&module=issues&branch=$branch&printer=$printer&print>Next
 Borrower</a> ||
!       <a 
href=circulation.pl?module=returns&branch=$branch&printer=$printer>Returns</a> 
||
!       <a href=branchtransfers.pl>Transfer Book</a></font><p>
          
        </p>
***************
*** 669,673 ****
                $dd="<font color=red>$dd</font>\n";
            }
!           $previssues.="<tr><td bgcolor=$color align=center>$dd</td><td 
bgcolor=$color align=center><a 
href=/cgi-bin/koha/detail.pl?bib=$bookissue->{'biblionumber'}&type=intra 
onClick=\"openWindow(this, 'Item', 480, 
640)\">$bookissue->{'barcode'}</a></td><td 
bgcolor=$color>$bookissue->{'title'}</td><td 
bgcolor=$color>$bookissue->{'author'}</td><td bgcolor=$color 
align=center>$bookissue->{'dewey'} $bookissue->{'subclass'}</td></tr>\n";
        }
        my $todaysissues='';
--- 670,674 ----
                $dd="<font color=red>$dd</font>\n";
            }
!             $previssues.="<tr><td bgcolor=$color align=center>$dd</td><td 
bgcolor=$color align=center><a 
href=/cgi-bin/koha/detail.pl?bib=$bookissue->{'biblionumber'}&type=intra 
onClick=\"openWindow(this, 'Item', 480, 
640)\">$bookissue->{'barcode'}</a></td><td 
bgcolor=$color>$bookissue->{'title'}</td><td 
bgcolor=$color>$bookissue->{'author'}</td><td bgcolor=$color 
align=center>$bookissue->{'dewey'} $bookissue->{'subclass'}</td></tr>\n";
        }
        my $todaysissues='';