X-Git-Url: http://koha-dev.rot13.org:8081/gitweb/?a=blobdiff_plain;f=C4%2FBiblio.pm;h=5d9cd9e7e0f1fdfc8925cd2e9ce3da661b5c8cf2;hb=386284d2d5a773e274d30e7ecf1deb137593734e;hp=f1aaac6a332fd94c0326faa147689a5279f0488c;hpb=4e95e94727b09b33d2f6c597bdd218a59dcc3681;p=koha_gimpoz diff --git a/C4/Biblio.pm b/C4/Biblio.pm index f1aaac6a33..5d9cd9e7e0 100644 --- a/C4/Biblio.pm +++ b/C4/Biblio.pm @@ -27,7 +27,6 @@ use Carp; use MARC::Record; use MARC::File::USMARC; use MARC::File::XML; -use ZOOM; use POSIX qw(strftime); use C4::Koha; @@ -35,9 +34,6 @@ use C4::Dates qw/format_date/; use C4::Log; # logaction use C4::ClassSource; use C4::Charset; -require C4::Heading; -require C4::Serials; -require C4::Items; use vars qw($VERSION @ISA @EXPORT); @@ -94,6 +90,9 @@ BEGIN { &PrepHostMarcField &CountItemsIssued + &CountBiblioInOrders + &GetSubscriptionsId + &GetHolds ); # To modify something @@ -128,7 +127,6 @@ BEGIN { &TransformHtmlToMarc2 &TransformHtmlToMarc &TransformHtmlToXml - &PrepareItemrecordDisplay &GetNoZebraIndexes ); } @@ -140,10 +138,11 @@ eval { import Memoize::Memcached qw(memoize_memcached); my $memcached = { - servers => [$servers], - key_prefix => C4::Context->config('memcached_namespace') || 'koha', - }; - memoize_memcached( 'GetMarcStructure', memcached => $memcached, expire_time => 600 ); #cache for 10 minutes + servers => [$servers], + key_prefix => C4::Context->config('memcached_namespace') || 'koha', + expire_time => 600 + }; # cache for 10 mins, if you want to cache for different make a different memcached hash + memoize_memcached( 'GetMarcStructure', memcached => $memcached ); } }; @@ -317,7 +316,7 @@ sub ModBiblio { SetUTF8Flag($record); my $dbh = C4::Context->dbh; - $frameworkcode = "" unless $frameworkcode; + $frameworkcode = "" if !$frameworkcode || $frameworkcode eq "Default"; # XXX _strip_item_fields($record, $frameworkcode); @@ -386,7 +385,7 @@ sub ModBiblioframework { =head2 DelBiblio - my $error = &DelBiblio($dbh,$biblionumber); + my $error = &DelBiblio($biblionumber); Exported function (core API) for deleting a biblio in koha. Deletes biblio record from Zebra and Koha tables (biblio,biblioitems,items) @@ -414,9 +413,10 @@ sub DelBiblio { return $error if $error; # We delete attached subscriptions - my $subscriptions = &C4::Serials::GetFullSubscriptionsFromBiblionumber($biblionumber); + require C4::Serials; + my $subscriptions = C4::Serials::GetFullSubscriptionsFromBiblionumber($biblionumber); foreach my $subscription (@$subscriptions) { - &C4::Serials::DelSubscription( $subscription->{subscriptionid} ); + C4::Serials::DelSubscription( $subscription->{subscriptionid} ); } # Delete in Zebra. Be careful NOT to move this line after _koha_delete_biblio @@ -474,6 +474,7 @@ MARC record. =cut sub LinkBibHeadingsToAuthorities { + require C4::Heading; my $bib = shift; my $num_headings_changed = 0; @@ -1040,9 +1041,12 @@ for the given frameworkcode sub GetMarcFromKohaField { my ( $kohafield, $frameworkcode ) = @_; - return 0, 0 unless $kohafield and defined $frameworkcode; + return (0, undef) unless $kohafield and defined $frameworkcode; my $relations = C4::Context->marcfromkohafield; - return ( $relations->{$frameworkcode}->{$kohafield}->[0], $relations->{$frameworkcode}->{$kohafield}->[1] ); + if ( my $mf = $relations->{$frameworkcode}->{$kohafield} ) { + return @$mf; + } + return (0, undef); } =head2 GetMarcBiblio @@ -1101,20 +1105,17 @@ sub GetXmlBiblio { =head2 GetCOinSBiblio - my $coins = GetCOinSBiblio($biblionumber); + my $coins = GetCOinSBiblio($record); -Returns the COinS(a span) which can be included in a biblio record +Returns the COinS (a span) which can be included in a biblio record =cut sub GetCOinSBiblio { - my ($biblionumber) = @_; - my $record = GetMarcBiblio($biblionumber); + my $record = shift; # get the coin format if ( ! $record ) { - # can't get a valid MARC::Record object, bail out at this point - warn "We called GetMarcBiblio with a biblionumber that doesn't exist biblionumber=$biblionumber"; return; } my $pos7 = substr $record->leader(), 7, 1; @@ -1612,7 +1613,8 @@ sub GetMarcAuthors { $separator = C4::Context->preference('authoritysep'); } push @subfields_loop, - { code => $subfieldcode, + { tag => $field->tag(), + code => $subfieldcode, value => $value, link_loop => \@this_link_loop, separator => $separator @@ -1827,17 +1829,30 @@ sub GetFrameworkCode { This function builds partial MARC::Record from a hash Hash entries can be from biblio or biblioitems. -This function is called in acquisition module, to create a basic catalogue entry from user entry +This function is called in acquisition module, to create a basic catalogue +entry from user entry =cut + sub TransformKohaToMarc { - my ($hash) = @_; - my $sth = C4::Context->dbh->prepare( "SELECT tagfield,tagsubfield FROM marc_subfield_structure WHERE frameworkcode=? AND kohafield=?" ); + my $hash = shift; my $record = MARC::Record->new(); SetMarcUnicodeFlag( $record, C4::Context->preference("marcflavour") ); - foreach ( keys %{$hash} ) { - &TransformKohaToMarcOneField( $sth, $record, $_, $hash->{$_}, '' ); + my $db_to_marc = C4::Context->marcfromkohafield; + while ( my ($name, $value) = each %$hash ) { + next unless my $dtm = $db_to_marc->{''}->{$name}; + my ($tag, $letter) = @$dtm; + foreach my $value ( split(/\s?\|\s?/, $value, -1) ) { + if ( my $field = $record->field($tag) ) { + $field->add_subfields( $letter => $value ); + } + else { + $record->insert_fields_ordered( MARC::Field->new( + $tag, " ", " ", $letter => $value ) ); + } + } + } return $record; } @@ -1921,42 +1936,6 @@ sub PrepHostMarcField { return $hostmarcfield; } - -=head2 TransformKohaToMarcOneField - - $record = TransformKohaToMarcOneField( $sth, $record, $kohafieldname, $value, $frameworkcode ); - -=cut - -sub TransformKohaToMarcOneField { - my ( $sth, $record, $kohafieldname, $value, $frameworkcode ) = @_; - $frameworkcode = '' unless $frameworkcode; - my $tagfield; - my $tagsubfield; - - if ( !defined $sth ) { - my $dbh = C4::Context->dbh; - $sth = $dbh->prepare( "SELECT tagfield,tagsubfield FROM marc_subfield_structure WHERE frameworkcode=? AND kohafield=?" ); - } - $sth->execute( $frameworkcode, $kohafieldname ); - if ( ( $tagfield, $tagsubfield ) = $sth->fetchrow ) { - my @values = split(/\s?\|\s?/, $value, -1); - - foreach my $itemvalue (@values){ - my $tag = $record->field($tagfield); - if ($tag) { - $tag->add_subfields( $tagsubfield => $itemvalue ); - $record->delete_field($tag); - $record->insert_fields_ordered($tag); - } - else { - $record->add_fields( $tagfield, " ", " ", $tagsubfield => $itemvalue ); - } - } - } - return $record; -} - =head2 TransformHtmlToXml $xml = TransformHtmlToXml( $tags, $subfields, $values, $indicator, @@ -2077,7 +2056,7 @@ sub TransformHtmlToXml { } $prevtag = @$tags[$i]; } - $xml .= "\n" if @$tags > 0; + $xml .= "\n" if $xml =~ m/preference('marcflavour') eq 'UNIMARC' and !$unimarc_and_100_exist ) { # warn "SETTING 100 for $auth_type"; @@ -2463,232 +2442,6 @@ sub TransformMarcToKohaOneField { return $result; } -=head1 OTHER FUNCTIONS - - -=head2 PrepareItemrecordDisplay - - PrepareItemrecordDisplay($itemrecord,$bibnum,$itemumber,$frameworkcode); - -Returns a hash with all the fields for Display a given item data in a template - -The $frameworkcode returns the item for the given frameworkcode, ONLY if bibnum is not provided - -=cut - -sub PrepareItemrecordDisplay { - - my ( $bibnum, $itemnum, $defaultvalues, $frameworkcode ) = @_; - - my $dbh = C4::Context->dbh; - $frameworkcode = &GetFrameworkCode($bibnum) if $bibnum; - my ( $itemtagfield, $itemtagsubfield ) = &GetMarcFromKohaField( "items.itemnumber", $frameworkcode ); - my $tagslib = &GetMarcStructure( 1, $frameworkcode ); - - # return nothing if we don't have found an existing framework. - return q{} unless $tagslib; - my $itemrecord; - if ($itemnum) { - $itemrecord = C4::Items::GetMarcItem( $bibnum, $itemnum ); - } - my @loop_data; - my $authorised_values_sth = $dbh->prepare( "SELECT authorised_value,lib FROM authorised_values WHERE category=? ORDER BY lib" ); - foreach my $tag ( sort keys %{$tagslib} ) { - my $previous_tag = ''; - if ( $tag ne '' ) { - - # loop through each subfield - my $cntsubf; - foreach my $subfield ( sort keys %{ $tagslib->{$tag} } ) { - next if ( subfield_is_koha_internal_p($subfield) ); - next if ( $tagslib->{$tag}->{$subfield}->{'tab'} ne "10" ); - my %subfield_data; - $subfield_data{tag} = $tag; - $subfield_data{subfield} = $subfield; - $subfield_data{countsubfield} = $cntsubf++; - $subfield_data{kohafield} = $tagslib->{$tag}->{$subfield}->{'kohafield'}; - - # $subfield_data{marc_lib}=$tagslib->{$tag}->{$subfield}->{lib}; - $subfield_data{marc_lib} = $tagslib->{$tag}->{$subfield}->{lib}; - $subfield_data{mandatory} = $tagslib->{$tag}->{$subfield}->{mandatory}; - $subfield_data{repeatable} = $tagslib->{$tag}->{$subfield}->{repeatable}; - $subfield_data{hidden} = "display:none" - if $tagslib->{$tag}->{$subfield}->{hidden}; - my ( $x, $defaultvalue ); - if ($itemrecord) { - ( $x, $defaultvalue ) = _find_value( $tag, $subfield, $itemrecord ); - } - $defaultvalue = $tagslib->{$tag}->{$subfield}->{defaultvalue} unless $defaultvalue; - if ( !defined $defaultvalue ) { - $defaultvalue = q||; - } - $defaultvalue =~ s/"/"/g; - - # search for itemcallnumber if applicable - if ( $tagslib->{$tag}->{$subfield}->{kohafield} eq 'items.itemcallnumber' - && C4::Context->preference('itemcallnumber') ) { - my $CNtag = substr( C4::Context->preference('itemcallnumber'), 0, 3 ); - my $CNsubfield = substr( C4::Context->preference('itemcallnumber'), 3, 1 ); - if ($itemrecord) { - my $temp = $itemrecord->field($CNtag); - if ($temp) { - $defaultvalue = $temp->subfield($CNsubfield); - } - } - } - if ( $tagslib->{$tag}->{$subfield}->{kohafield} eq 'items.itemcallnumber' - && $defaultvalues - && $defaultvalues->{'callnumber'} ) { - my $temp; - if ($itemrecord) { - $temp = $itemrecord->field($subfield); - } - unless ($temp) { - $defaultvalue = $defaultvalues->{'callnumber'} if $defaultvalues; - } - } - if ( ( $tagslib->{$tag}->{$subfield}->{kohafield} eq 'items.holdingbranch' || $tagslib->{$tag}->{$subfield}->{kohafield} eq 'items.homebranch' ) - && $defaultvalues - && $defaultvalues->{'branchcode'} ) { - my $temp; - if ($itemrecord) { - $temp = $itemrecord->field($subfield); - } - unless ($temp) { - $defaultvalue = $defaultvalues->{branchcode} if $defaultvalues; - } - } - if ( ( $tagslib->{$tag}->{$subfield}->{kohafield} eq 'items.location' ) - && $defaultvalues - && $defaultvalues->{'location'} ) { - my $temp = $itemrecord->field($subfield) if ($itemrecord); - unless ($temp) { - $defaultvalue = $defaultvalues->{location} if $defaultvalues; - } - } - if ( $tagslib->{$tag}->{$subfield}->{authorised_value} ) { - my @authorised_values; - my %authorised_lib; - - # builds list, depending on authorised value... - #---- branch - if ( $tagslib->{$tag}->{$subfield}->{'authorised_value'} eq "branches" ) { - if ( ( C4::Context->preference("IndependantBranches") ) - && ( C4::Context->userenv->{flags} % 2 != 1 ) ) { - my $sth = $dbh->prepare( "SELECT branchcode,branchname FROM branches WHERE branchcode = ? ORDER BY branchname" ); - $sth->execute( C4::Context->userenv->{branch} ); - push @authorised_values, "" - unless ( $tagslib->{$tag}->{$subfield}->{mandatory} ); - while ( my ( $branchcode, $branchname ) = $sth->fetchrow_array ) { - push @authorised_values, $branchcode; - $authorised_lib{$branchcode} = $branchname; - } - } else { - my $sth = $dbh->prepare( "SELECT branchcode,branchname FROM branches ORDER BY branchname" ); - $sth->execute; - push @authorised_values, "" - unless ( $tagslib->{$tag}->{$subfield}->{mandatory} ); - while ( my ( $branchcode, $branchname ) = $sth->fetchrow_array ) { - push @authorised_values, $branchcode; - $authorised_lib{$branchcode} = $branchname; - } - } - - #----- itemtypes - } elsif ( $tagslib->{$tag}->{$subfield}->{authorised_value} eq "itemtypes" ) { - my $sth = $dbh->prepare( "SELECT itemtype,description FROM itemtypes ORDER BY description" ); - $sth->execute; - push @authorised_values, "" - unless ( $tagslib->{$tag}->{$subfield}->{mandatory} ); - while ( my ( $itemtype, $description ) = $sth->fetchrow_array ) { - push @authorised_values, $itemtype; - $authorised_lib{$itemtype} = $description; - } - #---- class_sources - } elsif ( $tagslib->{$tag}->{$subfield}->{authorised_value} eq "cn_source" ) { - push @authorised_values, "" unless ( $tagslib->{$tag}->{$subfield}->{mandatory} ); - - my $class_sources = GetClassSources(); - my $default_source = C4::Context->preference("DefaultClassificationSource"); - - foreach my $class_source (sort keys %$class_sources) { - next unless $class_sources->{$class_source}->{'used'} or - ($class_source eq $default_source); - push @authorised_values, $class_source; - $authorised_lib{$class_source} = $class_sources->{$class_source}->{'description'}; - } - - #---- "true" authorised value - } else { - $authorised_values_sth->execute( $tagslib->{$tag}->{$subfield}->{authorised_value} ); - push @authorised_values, "" - unless ( $tagslib->{$tag}->{$subfield}->{mandatory} ); - while ( my ( $value, $lib ) = $authorised_values_sth->fetchrow_array ) { - push @authorised_values, $value; - $authorised_lib{$value} = $lib; - } - } - $subfield_data{marc_value} = CGI::scrolling_list( - -name => 'field_value', - -values => \@authorised_values, - -default => "$defaultvalue", - -labels => \%authorised_lib, - -size => 1, - -tabindex => '', - -multiple => 0, - ); - } elsif ( $tagslib->{$tag}->{$subfield}->{value_builder} ) { - # opening plugin - my $plugin = C4::Context->intranetdir . "/cataloguing/value_builder/" . $tagslib->{$tag}->{$subfield}->{'value_builder'}; - if (do $plugin) { - my $temp; - my $extended_param = plugin_parameters( $dbh, $temp, $tagslib, $subfield_data{id}, undef ); - my ( $function_name, $javascript ) = plugin_javascript( $dbh, $temp, $tagslib, $subfield_data{id}, undef ); - $subfield_data{random} = int(rand(1000000)); # why do we need 2 different randoms? - my $index_subfield = int(rand(1000000)); - $subfield_data{id} = "tag_".$tag."_subfield_".$subfield."_".$index_subfield; - $subfield_data{marc_value} = qq[ - ... - $javascript]; - } else { - warn "Plugin Failed: $plugin"; - $subfield_data{marc_value} = qq(); # supply default input form - } - } - elsif ( $tag eq '' ) { # it's an hidden field - $subfield_data{marc_value} = qq(); - } - elsif ( $tagslib->{$tag}->{$subfield}->{'hidden'} ) { # FIXME: shouldn't input type be "hidden" ? - $subfield_data{marc_value} = qq(); - } - elsif ( length($defaultvalue) > 100 - or (C4::Context->preference("marcflavour") eq "UNIMARC" and - 300 <= $tag && $tag < 400 && $subfield eq 'a' ) - or (C4::Context->preference("marcflavour") eq "MARC21" and - 500 <= $tag && $tag < 600 ) - ) { - # oversize field (textarea) - $subfield_data{marc_value} = qq(\n"); - } else { - $subfield_data{marc_value} = ""; - } - push( @loop_data, \%subfield_data ); - } - } - } - my $itemnumber; - if ( $itemrecord && $itemrecord->field($itemtagfield) ) { - $itemnumber = $itemrecord->subfield( $itemtagfield, $itemtagsubfield ); - } - return { - 'itemtagfield' => $itemtagfield, - 'itemtagsubfield' => $itemtagsubfield, - 'itemnumber' => $itemnumber, - 'iteminformation' => \@loop_data - }; -} #" @@ -2852,6 +2605,7 @@ sub EmbedItemsInMarcBiblio { my @item_fields; my ( $itemtag, $itemsubfield ) = GetMarcFromKohaField( "items.itemnumber", $frameworkcode ); while (my ($itemnumber) = $sth->fetchrow_array) { + require C4::Items; my $item_marc = C4::Items::GetMarcItem($biblionumber, $itemnumber); push @item_fields, $item_marc->field($itemtag); } @@ -3179,9 +2933,24 @@ sub _koha_marc_update_bib_ids { # we drop the original field # we add the new builded field. my ( $biblio_tag, $biblio_subfield ) = GetMarcFromKohaField( "biblio.biblionumber", $frameworkcode ); + die qq{No biblionumber tag for framework "$frameworkcode"} unless $biblio_tag; my ( $biblioitem_tag, $biblioitem_subfield ) = GetMarcFromKohaField( "biblioitems.biblioitemnumber", $frameworkcode ); + die qq{No biblioitemnumber tag for framework "$frameworkcode"} unless $biblio_tag; - if ( $biblio_tag != $biblioitem_tag ) { + if ( $biblio_tag == $biblioitem_tag ) { + + # biblionumber & biblioitemnumber are in the same field (can't be <10 as fields <10 have only 1 value) + my $new_field = MARC::Field->new( + $biblio_tag, '', '', + "$biblio_subfield" => $biblionumber, + "$biblioitem_subfield" => $biblioitemnumber + ); + + # drop old field and create new one... + my $old_field = $record->field($biblio_tag); + $record->delete_field($old_field) if $old_field; + $record->insert_fields_ordered($new_field); + } else { # biblionumber & biblioitemnumber are in different fields @@ -3209,20 +2978,6 @@ sub _koha_marc_update_bib_ids { $old_field = $record->field($biblioitem_tag); $record->delete_field($old_field) if $old_field; $record->insert_fields_ordered($new_field); - - } else { - - # biblionumber & biblioitemnumber are in the same field (can't be <10 as fields <10 have only 1 value) - my $new_field = MARC::Field->new( - $biblio_tag, '', '', - "$biblio_subfield" => $biblionumber, - "$biblioitem_subfield" => $biblioitemnumber - ); - - # drop old field and create new one... - my $old_field = $record->field($biblio_tag); - $record->delete_field($old_field) if $old_field; - $record->insert_fields_ordered($new_field); } } @@ -3519,9 +3274,12 @@ sub _koha_delete_biblio { $bkup_sth->finish; # delete the biblio - my $del_sth = $dbh->prepare("DELETE FROM biblio WHERE biblionumber=?"); - $del_sth->execute($biblionumber); - $del_sth->finish; + my $sth2 = $dbh->prepare("DELETE FROM biblio WHERE biblionumber=?"); + $sth2->execute($biblionumber); + # update the timestamp (Bugzilla 7146) + $sth2= $dbh->prepare("UPDATE deletedbiblio SET timestamp=NOW() WHERE biblionumber=?"); + $sth2->execute($biblionumber); + $sth2->finish; } $sth->finish; return undef; @@ -3565,9 +3323,12 @@ sub _koha_delete_biblioitems { $bkup_sth->finish; # delete the biblioitem - my $del_sth = $dbh->prepare("DELETE FROM biblioitems WHERE biblioitemnumber=?"); - $del_sth->execute($biblioitemnumber); - $del_sth->finish; + my $sth2 = $dbh->prepare("DELETE FROM biblioitems WHERE biblioitemnumber=?"); + $sth2->execute($biblioitemnumber); + # update the timestamp (Bugzilla 7146) + $sth2= $dbh->prepare("UPDATE deletedbiblioitems SET timestamp=NOW() WHERE biblioitemnumber=?"); + $sth2->execute($biblioitemnumber); + $sth2->finish; } $sth->finish; return undef; @@ -3638,112 +3399,6 @@ sub ModBiblioMarc { return $biblionumber; } -=head2 z3950_extended_services - - z3950_extended_services($serviceType,$serviceOptions,$record); - -z3950_extended_services is used to handle all interactions with Zebra's extended serices package, which is employed to perform all management of the MARC data stored in Zebra. - -C<$serviceType> one of: itemorder,create,drop,commit,update,xmlupdate - -C<$serviceOptions> a has of key/value pairs. For instance, if service_type is 'update', $service_options should contain: - - action => update action, one of specialUpdate, recordInsert, recordReplace, recordDelete, elementUpdate. - -and maybe - - recordidOpaque => Opaque Record ID (user supplied) or recordidNumber => Record ID number (system number). - syntax => the record syntax (transfer syntax) - databaseName = Database from connection object - -To set serviceOptions, call set_service_options($serviceType) - -C<$record> the record, if one is needed for the service type - -A record should be in XML. You can convert it to XML from MARC by running it through marc2xml(). - -=cut - -sub z3950_extended_services { - my ( $server, $serviceType, $action, $serviceOptions ) = @_; - - # get our connection object - my $Zconn = C4::Context->Zconn( $server, 0, 1 ); - - # create a new package object - my $Zpackage = $Zconn->package(); - - # set our options - $Zpackage->option( action => $action ); - - if ( $serviceOptions->{'databaseName'} ) { - $Zpackage->option( databaseName => $serviceOptions->{'databaseName'} ); - } - if ( $serviceOptions->{'recordIdNumber'} ) { - $Zpackage->option( recordIdNumber => $serviceOptions->{'recordIdNumber'} ); - } - if ( $serviceOptions->{'recordIdOpaque'} ) { - $Zpackage->option( recordIdOpaque => $serviceOptions->{'recordIdOpaque'} ); - } - - # this is an ILL request (Zebra doesn't support it, but Koha could eventually) - #if ($serviceType eq 'itemorder') { - # $Zpackage->option('contact-name' => $serviceOptions->{'contact-name'}); - # $Zpackage->option('contact-phone' => $serviceOptions->{'contact-phone'}); - # $Zpackage->option('contact-email' => $serviceOptions->{'contact-email'}); - # $Zpackage->option('itemorder-item' => $serviceOptions->{'itemorder-item'}); - #} - - if ( $serviceOptions->{record} ) { - $Zpackage->option( record => $serviceOptions->{record} ); - - # can be xml or marc - if ( $serviceOptions->{'syntax'} ) { - $Zpackage->option( syntax => $serviceOptions->{'syntax'} ); - } - } - - # send the request, handle any exception encountered - eval { $Zpackage->send($serviceType) }; - if ( $@ && $@->isa("ZOOM::Exception") ) { - return "error: " . $@->code() . " " . $@->message() . "\n"; - } - - # free up package resources - $Zpackage->destroy(); -} - -=head2 set_service_options - - my $serviceOptions = set_service_options($serviceType); - -C<$serviceType> itemorder,create,drop,commit,update,xmlupdate - -Currently, we only support 'create', 'commit', and 'update'. 'drop' support will be added as soon as Zebra supports it. - -=cut - -sub set_service_options { - my ($serviceType) = @_; - my $serviceOptions; - - # FIXME: This needs to be an OID ... if we ever need 'syntax' this sub will need to change - # $serviceOptions->{ 'syntax' } = ''; #zebra doesn't support syntaxes other than xml - - if ( $serviceType eq 'commit' ) { - - # nothing to do - } - if ( $serviceType eq 'create' ) { - - # nothing to do - } - if ( $serviceType eq 'drop' ) { - die "ERROR: 'drop' not currently supported (by Zebra)"; - } - return $serviceOptions; -} - =head2 get_biblio_authorised_values find the types and values for all authorised values assigned to this biblio. @@ -3806,6 +3461,76 @@ sub get_biblio_authorised_values { return $authorised_values; } +=head2 CountBiblioInOrders + +=over 4 +$count = &CountBiblioInOrders( $biblionumber); + +=back + +This function return count of biblios in orders with $biblionumber + +=cut + +sub CountBiblioInOrders { + my ($biblionumber) = @_; + my $dbh = C4::Context->dbh; + my $query = "SELECT count(*) + FROM aqorders + WHERE biblionumber=? AND (datecancellationprinted IS NULL OR datecancellationprinted='0000-00-00')"; + my $sth = $dbh->prepare($query); + $sth->execute($biblionumber); + my $count = $sth->fetchrow; + return ($count); +} + +=head2 GetSubscriptionsId + +=over 4 +$subscriptions = &GetSubscriptionsId($biblionumber); + +=back + +This function return an array of subscriptionid with $biblionumber + +=cut + +sub GetSubscriptionsId { + my ($biblionumber) = @_; + my $dbh = C4::Context->dbh; + my $query = "SELECT subscriptionid + FROM subscription + WHERE biblionumber=?"; + my $sth = $dbh->prepare($query); + $sth->execute($biblionumber); + my @subscriptions = $sth->fetchrow_array; + return (@subscriptions); +} + +=head2 GetHolds + +=over 4 +$holds = &GetHolds($biblionumber); + +=back + +This function return the count of holds with $biblionumber + +=cut + +sub GetHolds { + my ($biblionumber) = @_; + my $dbh = C4::Context->dbh; + my $query = "SELECT count(*) + FROM reserves + WHERE biblionumber=?"; + my $sth = $dbh->prepare($query); + $sth->execute($biblionumber); + my $holds = $sth->fetchrow; + return ($holds); +} + + 1; __END__