use Modern::Perl;
use CGI qw ( -utf8 );
use C4::Auth;
-use C4::Branch;
use C4::Context;
use C4::Koha qw( GetAuthorisedValues );
use C4::Output;
use Koha::AdditionalField;
use Koha::DateUtils;
+use Koha::SharedContent;
my $query = new CGI;
my $title = $query->param('title_filter') || '';
my $expiration_date = $query->param('expiration_date_filter') || '';
my $routing = $query->param('routing') || C4::Context->preference("RoutingSerials");
my $searched = $query->param('searched') || 0;
-my @subscriptionids = $query ->param('subscriptionid');
+my $mana = $query->param('mana') || 0;
+my @subscriptionids = $query->multi_param('subscriptionid');
my $op = $query->param('op');
my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
}
-my $additional_fields = Koha::AdditionalField->all( { table => 'subscription', searchable => 1 } );
+my $additional_fields = Koha::AdditionalField->all( { tablename => 'subscription', searchable => 1 } );
my $additional_field_filters;
for my $field ( @$additional_fields ) {
- if ( my $filter_value = $query->param('additional_field_' . $field->{name} . '_filter') ) {
- $additional_field_filters->{ $field->{name} } = $filter_value;
+ my $filter_value = $query->param('additional_field_' . $field->{id} . '_filter');
+ if ( defined $filter_value and $filter_value ne q|| ) {
+ $additional_field_filters->{ $field->{name} } = {
+ value => $filter_value,
+ authorised_value_category => $field->{authorised_value_category},
+ };
}
if ( $field->{authorised_value_category} ) {
$field->{authorised_value_choices} = GetAuthorisedValues( $field->{authorised_value_category} );
my $expiration_date_dt = $expiration_date ? dt_from_string( $expiration_date ) : undef;
my @subscriptions;
+my $mana_statuscode;
if ($searched){
- @subscriptions = SearchSubscriptions(
+ if ($mana) {
+ my $result = Koha::SharedContent::search_entities("subscription",{
+ title => $title,
+ issn => $ISSN,
+ ean => $EAN,
+ publisher => $publisher
+ });
+ $mana_statuscode = $result->{code};
+ @subscriptions = @{ $result->{data} };
+ }
+ else {
+ @subscriptions = SearchSubscriptions(
{
biblionumber => $biblionumber,
title => $title,
publisher => $publisher,
bookseller => $bookseller,
branch => $branch,
- additional_fields => [ map{ { name => $_, value => $additional_field_filters->{$_}} } keys %$additional_field_filters ],
+ additional_fields => [ map{ { name => $_, value => $additional_field_filters->{$_}{value}, authorised_value_category => $additional_field_filters->{$_}{authorised_value_category} } } keys %$additional_field_filters ],
location => $location,
expiration_date => $expiration_date_dt,
- }
+ });
+ }
+}
+
+if ($mana) {
+ $template->param(
+ subscriptions => \@subscriptions,
+ statuscode => $mana_statuscode,
+ total => scalar @subscriptions,
+ title_filter => $title,
+ ISSN_filter => $ISSN,
+ EAN_filter => $EAN,
+ callnumber_filter => $callnumber,
+ publisher_filter => $publisher,
+ bookseller_filter => $bookseller,
+ branch_filter => $branch,
+ location_filter => $location,
+ expiration_date_filter => $expiration_date_dt,
+ done_searched => $searched,
+ routing => $routing,
+ additional_field_filters => $additional_field_filters,
+ additional_fields_for_subscription => $additional_fields,
+ marcflavour => (uc(C4::Context->preference("marcflavour"))),
+ mana => $mana,
+ search_only => 1
);
}
+else
+{
+ # to toggle between create or edit routing list options
+ if ($routing) {
+ for my $subscription ( @subscriptions) {
+ $subscription->{routingedit} = check_routing( $subscription->{subscriptionid} );
+ }
+ }
-# to toggle between create or edit routing list options
-if ($routing) {
- for my $subscription ( @subscriptions) {
- $subscription->{routingedit} = check_routing( $subscription->{subscriptionid} );
+ my (@openedsubscriptions, @closedsubscriptions);
+ for my $sub ( @subscriptions ) {
+ unless ( $sub->{closed} ) {
+ push @openedsubscriptions, $sub
+ unless $sub->{cannotdisplay};
+ } else {
+ push @closedsubscriptions, $sub
+ unless $sub->{cannotdisplay};
+ }
}
-}
-my (@openedsubscriptions, @closedsubscriptions);
-for my $sub ( @subscriptions ) {
- unless ( $sub->{closed} ) {
- push @openedsubscriptions, $sub
- unless $sub->{cannotdisplay};
- } else {
- push @closedsubscriptions, $sub
- unless $sub->{cannotdisplay};
+ my @branches = Koha::Libraries->search( {}, { order_by => ['branchcode'] } );
+ my @branches_loop;
+ foreach my $b ( @branches ) {
+ my $selected = 0;
+ $selected = 1 if( defined $branch and $branch eq $b->branchcode );
+ push @branches_loop, {
+ branchcode => $b->branchcode,
+ branchname => $b->branchname,
+ selected => $selected,
+ };
}
-}
-my $branches = GetBranches();
-my @branches_loop;
-foreach (sort keys %$branches){
- my $selected = 0;
- $selected = 1 if( defined $branch and $branch eq $_ );
- push @branches_loop, {
- branchcode => $_,
- branchname => $branches->{$_}->{'branchname'},
- selected => $selected,
- };
+ $template->param(
+ openedsubscriptions => \@openedsubscriptions,
+ closedsubscriptions => \@closedsubscriptions,
+ total => @openedsubscriptions + @closedsubscriptions,
+ title_filter => $title,
+ ISSN_filter => $ISSN,
+ EAN_filter => $EAN,
+ callnumber_filter => $callnumber,
+ publisher_filter => $publisher,
+ bookseller_filter => $bookseller,
+ branch_filter => $branch,
+ location_filter => $location,
+ expiration_date_filter => $expiration_date_dt,
+ branches_loop => \@branches_loop,
+ done_searched => $searched,
+ routing => $routing,
+ additional_field_filters => $additional_field_filters,
+ additional_fields_for_subscription => $additional_fields,
+ marcflavour => (uc(C4::Context->preference("marcflavour"))),
+ mana => $mana
+ );
}
-
-
-$template->param(
- openedsubscriptions => \@openedsubscriptions,
- closedsubscriptions => \@closedsubscriptions,
- total => @openedsubscriptions + @closedsubscriptions,
- title_filter => $title,
- ISSN_filter => $ISSN,
- EAN_filter => $EAN,
- callnumber_filter => $callnumber,
- publisher_filter => $publisher,
- bookseller_filter => $bookseller,
- branch_filter => $branch,
- locations => C4::Koha::GetAuthorisedValues('LOC', $location),
- expiration_date_filter => $expiration_date_dt,
- branches_loop => \@branches_loop,
- done_searched => $searched,
- routing => $routing,
- additional_field_filters => $additional_field_filters,
- additional_fields_for_subscription => $additional_fields,
- marcflavour => (uc(C4::Context->preference("marcflavour")))
-);
-
output_html_with_http_headers $query, $cookie, $template->output;