3 # 2008 Kyle Hall <kyle.m.hall@gmail.com>
5 # This file is part of Koha.
7 # Koha is free software; you can redistribute it and/or modify it under the
8 # terms of the GNU General Public License as published by the Free Software
9 # Foundation; either version 2 of the License, or (at your option) any later
12 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
13 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
14 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
16 # You should have received a copy of the GNU General Public License along with
17 # Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
18 # Suite 330, Boston, MA 02111-1307 USA
35 use C4::BackgroundJob;
37 use Date::Calc qw( Add_Delta_Days Date_to_Days );
39 use constant DEBUG => 0;
41 # this is the file version number that we're coded against.
42 my $FILE_VERSION = '1.0';
44 our $query = CGI->new;
46 my ($template, $loggedinuser, $cookie)
47 = get_template_and_user( { template_name => "offline_circ/process_koc.tmpl",
51 flagsrequired => { circulate => "circulate_remaining_permissions" },
55 my $fileID=$query->param('uploadedfileid');
56 my $runinbackground = $query->param('runinbackground');
57 my $completedJobID = $query->param('completedJobID');
58 my %cookies = parse CGI::Cookie($cookie);
59 my $sessionID = $cookies{'CGISESSID'}->value;
61 our $dbh = C4::Context->dbh();
62 our @output = (); ## For storing messages to be displayed to the user
65 if ($completedJobID) {
66 my $job = C4::BackgroundJob->fetch($sessionID, $completedJobID);
67 my $results = $job->results();
68 $template->param(transactions_loaded => 1);
69 $template->param(messages => $results->{results});
71 my $uploaded_file = C4::UploadedFile->fetch($sessionID, $fileID);
72 my $fh = $uploaded_file->fh();
73 my @input_lines = <$fh>;
75 my $filename = $uploaded_file->name();
78 if ($runinbackground) {
79 my $job_size = scalar(@input_lines);
80 $job = C4::BackgroundJob->new($sessionID, $filename, $ENV{'SCRIPT_NAME'}, $job_size);
81 my $jobID = $job->id();
86 # return job ID as JSON
88 # prevent parent exiting from
89 # destroying the kid's database handle
90 # FIXME: according to DBI doc, this may not work for Oracle
91 $dbh->{InactiveDestroy} = 1;
93 my $reply = CGI->new("");
94 print $reply->header(-type => 'text/html');
95 print "{ jobID: '$jobID' }";
97 } elsif (defined $pid) {
99 # close STDOUT to signal to Apache that
100 # we're now running in the background
104 # fork failed, so exit immediately
105 # fork failed, so exit immediately
106 warn "fork failed while attempting to run $ENV{'SCRIPT_NAME'} as a background job";
110 # if we get here, we're a child that has detached
115 my $header_line = shift @input_lines;
116 my $file_info = parse_header_line($header_line);
117 if ($file_info->{'Version'} ne $FILE_VERSION) {
118 push( @output, { message => 1,
119 ERROR_file_version => 1,
120 upload_version => $file_info->{'Version'},
121 current_version => $FILE_VERSION
127 foreach my $line (@input_lines) {
130 my $command_line = parse_command_line($line);
132 # map command names in the file to subroutine names
133 my %dispatch_table = (
134 issue => \&kocIssueItem,
135 'return' => \&kocReturnItem,
136 payment => \&kocMakePayment,
139 # call the right sub name, passing the hashref of command_line to it.
140 if ( exists $dispatch_table{ $command_line->{'command'} } ) {
141 $dispatch_table{ $command_line->{'command'} }->($command_line);
143 warn "unknown command: '$command_line->{command}' not processed";
146 if ($runinbackground) {
151 if ($runinbackground) {
152 $job->finish({ results => \@output }) if defined($job);
154 $template->param(transactions_loaded => 1);
155 $template->param(messages => \@output);
159 output_html_with_http_headers $query, $cookie, $template->output;
163 =head2 parse_header_line
165 parses the header line from a .koc file. This is the line that
166 specifies things such as the file version, and the name and version of
167 the offline circulation tool that generated the file. See
168 L<http://wiki.koha-community.org/wiki/Koha_offline_circulation_file_format>
169 for more information.
171 pass in a string containing the header line (the first line from th
174 returns a hashref containing the information from the header.
178 sub parse_header_line {
179 my $header_line = shift;
181 $header_line =~ s/\r//g;
183 my @fields = split( /\t/, $header_line );
184 my %header_info = map { split( /=/, $_ ) } @fields;
185 return \%header_info;
188 =head2 parse_command_line
192 sub parse_command_line {
193 my $command_line = shift;
194 chomp($command_line);
195 $command_line =~ s/\r//g;
197 my ( $timestamp, $command, @args ) = split( /\t/, $command_line );
198 my ( $date, $time, $id ) = split( /\s/, $timestamp );
207 # set the rest of the keys using a hash slice
208 my $argument_names = arguments_for_command($command);
209 @command{@$argument_names} = @args;
215 =head2 arguments_for_command
217 fetches the names of the columns (and function arguments) found in the
218 .koc file for a particular command name. For instance, the C<issue>
219 command requires a C<cardnumber> and C<barcode>. In that case this
220 function returns a reference to the list C<qw( cardnumber barcode )>.
222 parameters: the command name
224 returns: listref of column names.
228 sub arguments_for_command {
231 # define the fields for this version of the file.
233 issue => [qw( cardnumber barcode )],
234 return => [qw( barcode )],
235 payment => [qw( cardnumber amount )],
238 return $format{$command};
244 $circ->{ 'barcode' } = barcodedecode($circ->{'barcode'}) if( $circ->{'barcode'} && C4::Context->preference('itemBarcodeInputFilter'));
245 my $branchcode = C4::Context->userenv->{branch};
246 my $borrower = GetMember( 'cardnumber'=>$circ->{ 'cardnumber' } );
247 my $item = GetBiblioFromItemNumber( undef, $circ->{ 'barcode' } );
248 my $issue = GetItemIssue( $item->{'itemnumber'} );
250 if ( $issue->{ 'date_due' } ) { ## Item is currently checked out to another person.
251 #warn "Item Currently Issued.";
252 my $issue = GetOpenIssue( $item->{'itemnumber'} );
254 if ( $issue->{'borrowernumber'} eq $borrower->{'borrowernumber'} ) { ## Issued to this person already, renew it.
255 #warn "Item issued to this member already, renewing.";
257 C4::Circulation::AddRenewal(
258 $issue->{'borrowernumber'}, # borrowernumber
259 $item->{'itemnumber'}, # itemnumber
261 undef, # datedue - let AddRenewal calculate it automatically
262 $circ->{'date'}, # issuedate
265 push( @output, { renew => 1,
266 title => $item->{ 'title' },
267 biblionumber => $item->{'biblionumber'},
268 barcode => $item->{ 'barcode' },
269 firstname => $borrower->{ 'firstname' },
270 surname => $borrower->{ 'surname' },
271 borrowernumber => $borrower->{'borrowernumber'},
272 cardnumber => $borrower->{'cardnumber'},
273 datetime => $circ->{ 'datetime' }
277 #warn "Item issued to a different member.";
278 #warn "Date of previous issue: $issue->{'issuedate'}";
279 #warn "Date of this issue: $circ->{'date'}";
280 my ( $i_y, $i_m, $i_d ) = split( /-/, $issue->{'issuedate'} );
281 my ( $c_y, $c_m, $c_d ) = split( /-/, $circ->{'date'} );
283 if ( Date_to_Days( $i_y, $i_m, $i_d ) < Date_to_Days( $c_y, $c_m, $c_d ) ) { ## Current issue to a different persion is older than this issue, return and issue.
284 C4::Circulation::AddIssue( $borrower, $circ->{'barcode'}, undef, undef, $circ->{'date'} ) unless ( DEBUG );
285 push( @output, { issue => 1,
286 title => $item->{ 'title' },
287 biblionumber => $item->{'biblionumber'},
288 barcode => $item->{ 'barcode' },
289 firstname => $borrower->{ 'firstname' },
290 surname => $borrower->{ 'surname' },
291 borrowernumber => $borrower->{'borrowernumber'},
292 cardnumber => $borrower->{'cardnumber'},
293 datetime => $circ->{ 'datetime' }
296 } else { ## Current issue is *newer* than this issue, write a 'returned' issue, as the item is most likely in the hands of someone else now.
297 #warn "Current issue to another member is newer. Doing nothing";
298 ## This situation should only happen of the Offline Circ data is *really* old.
299 ## FIXME: write line to old_issues and statistics
303 } else { ## Item is not checked out to anyone at the moment, go ahead and issue it
304 C4::Circulation::AddIssue( $borrower, $circ->{'barcode'}, undef, undef, $circ->{'date'} ) unless ( DEBUG );
305 push( @output, { issue => 1,
306 title => $item->{ 'title' },
307 biblionumber => $item->{'biblionumber'},
308 barcode => $item->{ 'barcode' },
309 firstname => $borrower->{ 'firstname' },
310 surname => $borrower->{ 'surname' },
311 borrowernumber => $borrower->{'borrowernumber'},
312 cardnumber => $borrower->{'cardnumber'},
313 datetime =>$circ->{ 'datetime' }
320 $circ->{'barcode'} = barcodedecode($circ->{'barcode'}) if( $circ->{'barcode'} && C4::Context->preference('itemBarcodeInputFilter'));
321 my $item = GetBiblioFromItemNumber( undef, $circ->{ 'barcode' } );
322 #warn( Data::Dumper->Dump( [ $circ, $item ], [ qw( circ item ) ] ) );
323 my $borrowernumber = _get_borrowernumber_from_barcode( $circ->{'barcode'} );
324 if ( $borrowernumber ) {
325 my $borrower = GetMember( 'borrowernumber' =>$borrowernumber );
326 C4::Circulation::MarkIssueReturned( $borrowernumber,
327 $item->{'itemnumber'},
331 push( @output, { return => 1,
332 title => $item->{ 'title' },
333 biblionumber => $item->{'biblionumber'},
334 barcode => $item->{ 'barcode' },
335 borrowernumber => $borrower->{'borrowernumber'},
336 firstname => $borrower->{'firstname'},
337 surname => $borrower->{'surname'},
338 cardnumber => $borrower->{'cardnumber'},
339 datetime => $circ->{ 'datetime' }
342 push( @output, { ERROR_no_borrower_from_item => 1,
343 badbarcode => $circ->{'barcode'}
352 my $borrower = GetMember( 'cardnumber'=>$circ->{ 'cardnumber' } );
353 recordpayment( $borrower->{'borrowernumber'}, $circ->{'amount'} );
354 push( @output, { payment => 1,
355 amount => $circ->{'amount'},
356 firstname => $borrower->{'firstname'},
357 surname => $borrower->{'surname'},
358 cardnumber => $circ->{'cardnumber'},
359 borrower => $borrower->{'borrowernumber'}
363 =head2 _get_borrowernumber_from_barcode
366 get back the borrowernumber of the patron who has it checked out.
367 undef if that can't be found
371 sub _get_borrowernumber_from_barcode {
374 return unless $barcode;
376 my $item = GetBiblioFromItemNumber( undef, $barcode );
377 return unless $item->{'itemnumber'};
379 my $issue = C4::Circulation::GetItemIssue( $item->{'itemnumber'} );
380 return unless $issue->{'borrowernumber'};
381 return $issue->{'borrowernumber'};