#!/usr/bin/perl
-# WARNING: 4-character tab stops here
# Copyright 2000-2002 Katipo Communications
#
# Suite 330, Boston, MA 02111-1307 USA
use strict;
+use warnings;
+
use CGI;
use C4::Auth;
use HTML::Template::Pro;
use C4::Items;
use C4::Acquisition;
use C4::Search;
-use C4::Dates qw( DHTMLcalendar );
+use C4::Dates;
use C4::Koha; # XXX subfield_is_koha_internal_p
+use C4::Debug;
+use List::Util qw( max min );
+use POSIX;
#use Smart::Comments;
#use Data::Dumper;
+BEGIN {
+ $debug = $debug || $cgi_debug;
+ if ($debug) {
+ require Data::Dumper;
+ import Data::Dumper qw(Dumper);
+ }
+}
+
# Creates a scrolling list with the associated default value.
# Using more than one scrolling list in a CGI assigns the same default value to all the
# scrolling lists on the page !?!? That's why this function was written.
-my $query = new CGI;
-my $type = $query->param('type');
-my $op = $query->param('op');
-my $batch_id = $query->param('batch_id');
-my $dateaccessioned = $query->param('dateaccessioned');
+my $query = new CGI;
+
+my $type = $query->param('type');
+my $op = $query->param('op') || '';
+my $batch_id = $query->param('batch_id');
+my $ccl_query = $query->param('ccl_query');
my $dbh = C4::Context->dbh;
-my $startfrom = $query->param('startfrom') || 0;
+my $startfrom = $query->param('startfrom') || 1;
my ( $template, $loggedinuser, $cookie );
-my (@marclist,@and_or,@excluding,@operator,@value,$orderby,@tags,$results,$total,$error,$marcresults);
-my $resultsperpage = $query->param('resultsperpage') || 19;
+my (
+ $total_hits, $orderby, $results, $total, $error,
+ $marcresults, $idx, $datefrom, $dateto, $ccl_textbox
+);
+
+my $resultsperpage = C4::Context->preference('numSearchResults') || '20';
my $show_results = 0;
-if ( $op eq "do_search" ) {
- @marclist = $query->param('marclist');
- @and_or = $query->param('and_or');
- @excluding = $query->param('excluding');
- @operator = $query->param('operator');
- @value = $query->param('value');
- $orderby = $query->param('orderby');
- if (scalar @marclist) {
- #catalogsearch( $dbh, \@tags, \@and_or, \@excluding, \@operator, \@value,
- # $startfrom * $resultsperpage,
- # $resultsperpage, $orderby );
- ($error, $marcresults) = SimpleSearch($marclist[0]);
- if ($marcresults) {
- $show_results = scalar @$marcresults;
- } else {
- warn "ERROR label-item-search: no results from SimpleSearch";
- # leave $show_results undef
- }
+
+if ($op eq "do_search") {
+ $idx = $query->param('idx');
+ $ccl_textbox = $query->param('ccl_textbox');
+ if ($ccl_textbox && $idx) {
+ $ccl_query = "$idx=$ccl_textbox" ;
+ }
+
+ $datefrom = $query->param('datefrom');
+ $dateto = $query->param('dateto');
+
+ if ($datefrom) {
+ $datefrom = C4::Dates->new($datefrom);
+ $ccl_query .= ' and ' if $ccl_textbox;
+ $ccl_query .= "acqdate,st-date-normalized,ge=" . $datefrom->output("iso");
+ }
+
+ if ($dateto) {
+ $dateto = C4::Dates->new($dateto);
+ $ccl_query .= ' and ' if ($ccl_textbox || $datefrom) ;
+ $ccl_query .= "acqdate,st-date-normalized,le=". $dateto->output("iso");
+ }
+
+ my $offset = $startfrom > 1 ? $startfrom - 1 : 0;
+ ($error, $marcresults, $total_hits) =
+ SimpleSearch($ccl_query, $offset, $resultsperpage);
+
+ if ($marcresults) {
+ $show_results = scalar @$marcresults;
+ } else {
+ warn "ERROR label-item-search: no results from SimpleSearch";
+
+ # leave $show_results undef
}
}
-if ( $show_results ) {
+if ($show_results) {
my $hits = $show_results;
- my (@results,@results2);
- for(my $i=0; $i<$hits; $i++) {
+ my (@results, @items);
+
+ # This code needs to be refactored using these subs...
+ #my @items = &GetItemsInfo( $biblio->{biblionumber}, 'intra' );
+ #my $dat = &GetBiblioData( $biblio->{biblionumber} );
+ for (my $i = 0 ; $i < $hits ; $i++) {
+
+ #DEBUG Notes: Decode the MARC record from each resulting MARC record...
my $marcrecord = MARC::File::USMARC::decode($marcresults->[$i]);
- my $biblio = TransformMarcToKoha(C4::Context->dbh,$marcrecord,'');
- #build the hash for the template.
- $biblio->{highlight} = ($i % 2)?(1):(0);
- #warn $biblio->{biblionumber};
+
+ #DEBUG Notes: Transform it to Koha form...
+ my $biblio = TransformMarcToKoha(C4::Context->dbh, $marcrecord, '');
+
+# Begin building the hash for the template...
+# I don't think we need this with the current template design, but I'm leaving it in place. -fbcit
+#$biblio->{highlight} = ($i % 2)?(1):(0);
+#DEBUG Notes: Stuff the bib into @results...
push @results, $biblio;
my $biblionumber = $biblio->{'biblionumber'};
- my $itemnums = get_itemnumbers_of($biblionumber);
- my $iii = $itemnums->{$biblionumber} ;
+
+ #DEBUG Notes: Grab the item numbers associated with this MARC record...
+ my $itemnums = get_itemnumbers_of($biblionumber);
+
+ #DEBUG Notes: Retrieve the item data for each number...
+ my $iii = $itemnums->{$biblionumber};
if ($iii) {
- my $item_results = &GetItemInfosOf( @$iii );
- foreach my $item (keys %$item_results) {
- for my $bibdata (keys %{$results[$i]}) {
- #warn Dumper($bibdata);
- #warn Dumper($results[$i]->{$bibdata});
- $item_results->{$item}{$bibdata} = $results[$i]->{$bibdata};
+ my $item_results = GetItemInfosOf(@$iii);
+ foreach my $item (keys %$item_results) {
+
+#DEBUG Notes: Build an array element 'item' of the correct bib (results) hash which contains item-specific data...
+ if ($item_results->{$item}->{'biblionumber'} eq
+ $results[$i]->{'biblionumber'}) {
+
+# NOTE: The order of the elements in this array must be preserved or the table dependent on it will be incorrectly rendered.
+# This is a real hack, but I can't think of a better way right now. -fbcit
+# It is conceivable that itemcallnumber and/or barcode fields might be empty so the trinaries cover this possibility.
+ push @{ $results[$i]->{'item'} }, { i_itemnumber1 =>
+ $item_results->{$item}->{'itemnumber'} };
+ push @{ $results[$i]->{'item'} },
+ { i_itemcallnumber => (
+ $item_results->{$item}->{'itemcallnumber'}
+ ? $item_results->{$item}->{'itemcallnumber'} : 'NA'
+ )
+ };
+ push @{ $results[$i]->{'item'} }, { i_dateaccessioned =>
+ $item_results->{$item}->{'dateaccessioned'} };
+ push @{ $results[$i]->{'item'} },
+ { i_barcode => (
+ $item_results->{$item}->{'barcode'}
+ ? $item_results->{$item}->{'barcode'} : 'NA'
+ )
+ };
+ push @{ $results[$i]->{'item'} }, { i_itemnumber2 =>
+ $item_results->{$item}->{'itemnumber'} };
}
- push @results2, $item_results->{$item};
}
}
- }
- ( $template, $loggedinuser, $cookie ) = get_template_and_user(
- {
- template_name => "labels/result.tmpl",
- query => $query,
- type => "intranet",
- authnotrequired => 0,
- flagsrequired => { borrowers => 1 },
- flagsrequired => { catalogue => 1 },
- debug => 1,
- }
- );
+ }
+ $debug and warn "**********\@results**********\n";
+ $debug and warn Dumper(@results);
- # multi page display gestion
- my $displaynext = 0;
- my $displayprev = $startfrom;
- if ( ( $total - ( ( $startfrom + 1 ) * ($resultsperpage) ) ) > 0 ) {
- $displaynext = 1;
- }
+ ($template, $loggedinuser, $cookie) = get_template_and_user(
+ { template_name => "labels/result.tmpl",
+ query => $query,
+ type => "intranet",
+ authnotrequired => 0,
+ flagsrequired => { borrowers => 1 },
+ flagsrequired => { catalogue => 1 },
+ debug => 1,
+ }
+ );
- my @field_data = ();
+ # build page nav stuff.
+ my (@field_data, @numbers);
+ $total = $total_hits;
- # FIXME: this relies on symmetric order of CGI params that IS NOT GUARANTEED by spec.
+ my ($from, $to, $startfromnext, $startfromprev, $displaynext, $displayprev);
- for ( my $i = 0 ; $i <= $#marclist ; $i++ ) {
- push @field_data, { term => "marclist", val => $marclist[$i] };
- push @field_data, { term => "and_or", val => $and_or[$i] };
- push @field_data, { term => "excluding", val => $excluding[$i] };
- push @field_data, { term => "operator", val => $operator[$i] };
- push @field_data, { term => "value", val => $value[$i] };
- }
+ if ($total > $resultsperpage) {
+ my $num_of_pages = ceil($total / $resultsperpage + 1);
+ for (my $page = 1 ; $page < $num_of_pages ; $page++) {
+ my $startfrm = (($page - 1) * $resultsperpage) + 1;
+ push @numbers,
+ { number => $page,
+ startfrom => $startfrm
+ };
+ }
- my @numbers = ();
- if ( $total > $resultsperpage ) {
- for ( my $i = 1 ; $i < $total / $resultsperpage + 1 ; $i++ ) {
- if ( $i < 16 ) {
- my $highlight = 0;
- ( $startfrom == ( $i - 1 ) ) && ( $highlight = 1 );
- push @numbers,
- {
- number => $i,
- highlight => $highlight,
- searchdata => \@field_data,
- startfrom => ( $i - 1 )
- };
- }
- }
+ $from = $startfrom;
+ $startfromprev = $startfrom - $resultsperpage;
+ $startfromnext = $startfrom + $resultsperpage;
+
+ $to =
+ $startfrom + $resultsperpage > $total
+ ? $total
+ : $startfrom + $resultsperpage - 1;
+
+ # multi page display
+ $displaynext = 0;
+ $displayprev = $startfrom > 1 ? $startfrom : 0;
+
+ $displaynext = 1 if $to < $total_hits;
+
+ } else {
+ $displayprev = 0;
+ $displaynext = 0;
}
- my $from = $startfrom * $resultsperpage + 1;
- my $temp = ( $startfrom + 1 ) * $resultsperpage;
- my $to = ($total < $temp) ? $total : $temp;
-
- # this gets the results of the search (which are bibs)
- # and then does a lookup on all items that exist for that bib
- # then pushes the items onto a new array, as we really want the
- # items attached to the bibs not thew bibs themselves
-
- # my @results2;
- # for (my $i = 0 ; $i < $total ; $i++ )
- # {
- #warn $i;
- #warn Dumper $results->[$i]{'bibid'};
- # my $type = 'intra';
- # my @item_results = &ItemInfo( 0, $results->[$i]{'biblionumber'}, $type );
- # FIXME: ItemInfo doesn't exist !!
-# push @results2,\@item_results;
- # foreach my $item (@item_results) {
- # warn Dumper $item;
- # push @results2, $item;
- # }
-# }
-#
- $template->param(
- result => \@results2,
- startfrom => $startfrom,
- displaynext => $displaynext,
- displayprev => $displayprev,
- resultsperpage => $resultsperpage,
- startfromnext => $startfrom + 1,
- startfromprev => $startfrom - 1,
- searchdata => \@field_data,
- total => $total,
- from => $from,
- to => $to,
- numbers => \@numbers,
- batch_id => $batch_id,
- );
+ $template->param(
+ total => $total_hits,
+ from => $from,
+ to => $to,
+ startfromnext => $startfromnext,
+ startfromprev => $startfromprev,
+ startfrom => $startfrom,
+ displaynext => $displaynext,
+ displayprev => $displayprev,
+ resultsperpage => $resultsperpage,
+ numbers => \@numbers,
+ );
+
+ $template->param(
+ result => \@results,
+ batch_id => $batch_id,
+ type => $type,
+ idx => $idx,
+ ccl_query => $ccl_query,
+ );
}
#
debug => 1,
}
);
-
- #using old rel2.2 getitemtypes for testing!!!!, not devweek's GetItemTypes()
-
my $itemtypes = GetItemTypes;
my @itemtypeloop;
- my ($thisitemtype );
- foreach my $thisitemtype (keys %$itemtypes) {
- my %row =(value => $thisitemtype,
- description => $itemtypes->{$thisitemtype}->{'description'},
- );
- push @itemtypeloop, \%row;
- }
+ foreach my $thisitemtype ( keys %$itemtypes ) {
+ my %row = (
+ value => $thisitemtype,
+ description => $itemtypes->{$thisitemtype}->{'description'},
+ );
+ push @itemtypeloop, \%row;
+ }
$template->param(
- itemtypeloop =>\@itemtypeloop,
+ itemtypeloop => \@itemtypeloop,
batch_id => $batch_id,
+ type => $type,
);
}
+
# Print the page
-$template->param(
- DHTMLcalendar_dateformat => C4::Dates->DHTMLcalendar(),
-);
+$template->param( DHTMLcalendar_dateformat => C4::Dates->DHTMLcalendar(), );
output_html_with_http_headers $query, $cookie, $template->output;
-
-# Local Variables:
-# tab-width: 4
-# End: