use Modern::Perl;
use CGI qw ( -utf8 );
-use C4::Acquisition;
-use C4::Auth;
-use C4::Budgets;
-use C4::Koha;
-use C4::Dates qw/format_date/;
-use C4::Serials;
-use C4::Output;
+use C4::Auth qw( get_template_and_user checkauth );
+use C4::Serials qw( CloseSubscription ReopenSubscription GetSubscription GetExpirationDate GetSerials HasSubscriptionStrictlyExpired CountIssues HasItems DelSubscription check_routing abouttoexpire can_edit_subscription );
+use C4::Output qw( output_and_exit output_html_with_http_headers );
use C4::Context;
-use C4::Search qw/enabled_staff_search_views/;
+use C4::Search qw( enabled_staff_search_views );
+use Koha::AdditionalFields;
+use Koha::AuthorisedValues;
+use Koha::DateUtils qw( output_pref );
use Koha::Acquisition::Bookseller;
+use Koha::Subscriptions;
-use Date::Calc qw/Today Day_of_Year Week_of_Year Add_Delta_Days/;
-use Carp;
+use Carp qw( carp );
-my $query = new CGI;
+use Koha::SharedContent;
+
+my $query = CGI->new;
my $op = $query->param('op') || q{};
my $issueconfirmed = $query->param('issueconfirmed');
my $dbh = C4::Context->dbh;
C4::Serials::ReopenSubscription( $subscriptionid );
}
-# the subscription must be deletable if there is NO issues for a reason or another (should not happend, but...)
+# the subscription must be deletable if there is NO issues for a reason or another (should not happened, but...)
# Permission needed if it is a deletion (del) : delete_subscription
# Permission needed otherwise : *
= get_template_and_user({template_name => "serials/subscription-detail.tt",
query => $query,
type => "intranet",
- authnotrequired => 0,
flagsrequired => {serials => $permission},
- debug => 1,
});
-
my $subs = GetSubscription($subscriptionid);
+
+output_and_exit( $query, $cookie, $template, 'unknown_subscription')
+ unless $subs;
+
$subs->{enddate} ||= GetExpirationDate($subscriptionid);
my ($totalissues,@serialslist) = GetSerials($subscriptionid);
$totalissues-- if $totalissues; # the -1 is to have 0 if this is a new subscription (only 1 issue)
if ($op eq 'del') {
- if ($$subs{'cannotedit'}){
- carp "Attempt to delete subscription $subscriptionid by ".C4::Context->userenv->{'id'}." not allowed";
- print $query->redirect("/cgi-bin/koha/serials/subscription-detail.pl?subscriptionid=$subscriptionid");
- exit;
- }
-
+ if ($$subs{'cannotedit'}){
+ carp "Attempt to delete subscription $subscriptionid by ".C4::Context->userenv->{'id'}." not allowed";
+ print $query->redirect("/cgi-bin/koha/serials/subscription-detail.pl?subscriptionid=$subscriptionid");
+ exit;
+ }
+
# Asking for confirmation if the subscription has not strictly expired yet or if it has linked issues
my $strictlyexpired = HasSubscriptionStrictlyExpired($subscriptionid);
my $linkedissues = CountIssues($subscriptionid);
my $countitems = HasItems($subscriptionid);
if ($strictlyexpired == 0 || $linkedissues > 0 || $countitems>0) {
- $template->param(NEEDSCONFIRMATION => 1);
- if ($strictlyexpired == 0) { $template->param("NOTEXPIRED" => 1); }
- if ($linkedissues > 0) { $template->param("LINKEDISSUES" => 1); }
- if ($countitems > 0) { $template->param("LINKEDITEMS" => 1); }
+ $template->param(NEEDSCONFIRMATION => 1);
+ if ($strictlyexpired == 0) { $template->param("NOTEXPIRED" => 1); }
+ if ($linkedissues > 0) { $template->param("LINKEDISSUES" => 1); }
+ if ($countitems > 0) { $template->param("LINKEDITEMS" => 1); }
} else {
- $issueconfirmed = "1";
+ $issueconfirmed = "1";
}
# If it's ok to delete the subscription, we do so
if ($issueconfirmed eq "1") {
- &DelSubscription($subscriptionid);
+ &DelSubscription($subscriptionid);
print $query->redirect("/cgi-bin/koha/serials/serials-home.pl");
exit;
}
}
+elsif ( $op and $op eq "share" ) {
+ my $mana_language = $query->param('mana_language');
+ my $result = Koha::SharedContent::send_entity($mana_language, $loggedinuser, $subscriptionid, 'subscription');
+ $template->param( mana_code => $result->{msg} );
+ $subs->{mana_id} = $result->{id};
+}
+
my $hasRouting = check_routing($subscriptionid);
(undef, $cookie, undef, undef)
# COMMENT hdl : IMHO, we should think about passing more and more data hash to template->param rather than duplicating code a new coding Guideline ?
for my $date ( qw(startdate enddate firstacquidate histstartdate histenddate) ) {
- $$subs{$date} = format_date($$subs{$date}) if $date && $$subs{$date};
+ $subs->{$date} = output_pref( { str => $subs->{$date}, dateonly => 1 } )
+ if $subs->{$date};
}
-$subs->{location} = GetKohaAuthorisedValueLib("LOC",$subs->{location});
+my $av = Koha::AuthorisedValues->search({ category => 'LOC', authorised_value => $subs->{location} });
+$subs->{location} = $av->count ? $av->next->lib : '';
+$av = Koha::AuthorisedValues->search({ category => 'CCODE', authorised_value => $subs->{ccode} });
+$subs->{ccode} = $av->count ? $av->next->lib : '';
$subs->{abouttoexpire} = abouttoexpire($subs->{subscriptionid});
$template->param(%{ $subs });
$template->param(biblionumber_for_new_subscription => $subs->{bibnum});
my $frequency = C4::Serials::Frequency::GetSubscriptionFrequency($subs->{periodicity});
my $numberpattern = C4::Serials::Numberpattern::GetSubscriptionNumberpattern($subs->{numberpattern});
-my $default_bib_view = get_default_view();
-
-my ( $order, $bookseller, $tmpl_infos );
-if ( defined $subscriptionid ) {
- my $lastOrderNotReceived = GetLastOrderNotReceivedFromSubscriptionid $subscriptionid;
- my $lastOrderReceived = GetLastOrderReceivedFromSubscriptionid $subscriptionid;
- if ( defined $lastOrderNotReceived ) {
- my $basket = GetBasket $lastOrderNotReceived->{basketno};
- my $bookseller = Koha::Acquisition::Bookseller->fetch({ id => $basket->{booksellerid} });
- ( $tmpl_infos->{valuegsti_ordered}, $tmpl_infos->{valuegste_ordered} ) = get_value_with_gst_params ( $lastOrderNotReceived->{ecost}, $lastOrderNotReceived->{gstrate}, $bookseller );
- $tmpl_infos->{valuegsti_ordered} = sprintf( "%.2f", $tmpl_infos->{valuegsti_ordered} );
- $tmpl_infos->{valuegste_ordered} = sprintf( "%.2f", $tmpl_infos->{valuegste_ordered} );
- $tmpl_infos->{budget_name_ordered} = GetBudgetName $lastOrderNotReceived->{budget_id};
- $tmpl_infos->{basketno} = $lastOrderNotReceived->{basketno};
- $tmpl_infos->{ordered_exists} = 1;
- }
- if ( defined $lastOrderReceived ) {
- my $basket = GetBasket $lastOrderReceived->{basketno};
- my $bookseller = Koha::Acquisition::Bookseller->fetch({ id => $basket->{booksellerid} });
- ( $tmpl_infos->{valuegsti_spent}, $tmpl_infos->{valuegste_spent} ) = get_value_with_gst_params ( $lastOrderReceived->{unitprice}, $lastOrderReceived->{gstrate}, $bookseller );
- $tmpl_infos->{valuegsti_spent} = sprintf( "%.2f", $tmpl_infos->{valuegsti_spent} );
- $tmpl_infos->{valuegste_spent} = sprintf( "%.2f", $tmpl_infos->{valuegste_spent} );
- $tmpl_infos->{budget_name_spent} = GetBudgetName $lastOrderReceived->{budget_id};
- $tmpl_infos->{invoiceid} = $lastOrderReceived->{invoiceid};
- $tmpl_infos->{spent_exists} = 1;
+my $subscription_object = Koha::Subscriptions->find( $subscriptionid );
+$template->param(
+ available_additional_fields => Koha::AdditionalFields->search( { tablename => 'subscription' } ),
+ additional_field_values => {
+ map { $_->field->name => $_->value }
+ $subscription_object->additional_field_values->as_list
+ },
+);
+
+# FIXME Do we want to hide canceled orders?
+my $orders = Koha::Acquisition::Orders->search( { subscriptionid => $subscriptionid }, { order_by => [ { -desc => 'timestamp' }, \[ "field(orderstatus, 'ordered', 'partial', 'complete')" ] ] } );
+my $orders_grouped;
+while ( my $o = $orders->next ) {
+ if ( $o->ordernumber == $o->parent_ordernumber ) {
+ $orders_grouped->{$o->parent_ordernumber}->{datereceived} = $o->datereceived;
+ $orders_grouped->{$o->parent_ordernumber}->{orderstatus} = $o->orderstatus;
+ $orders_grouped->{$o->parent_ordernumber}->{basket} = $o->basket;
}
+ $orders_grouped->{$o->parent_ordernumber}->{quantity} += $o->quantity;
+ $orders_grouped->{$o->parent_ordernumber}->{ecost_tax_excluded} += sprintf('%.2f', $o->ecost_tax_excluded * $o->quantity);
+ $orders_grouped->{$o->parent_ordernumber}->{ecost_tax_included} += sprintf('%.2f', $o->ecost_tax_included * $o->quantity);
+ $orders_grouped->{$o->parent_ordernumber}->{unitprice_tax_excluded} += sprintf('%.2f', $o->unitprice_tax_excluded * $o->quantity);
+ $orders_grouped->{$o->parent_ordernumber}->{unitprice_tax_included} += sprintf('%.2f', $o->unitprice_tax_included * $o->quantity);
+ push @{$orders_grouped->{$o->parent_ordernumber}->{orders}}, $o;
}
$template->param(
intranetstylesheet => C4::Context->preference('intranetstylesheet'),
intranetcolorstylesheet => C4::Context->preference('intranetcolorstylesheet'),
irregular_issues => scalar @irregular_issues,
- default_bib_view => $default_bib_view,
+ orders_grouped => $orders_grouped,
(uc(C4::Context->preference("marcflavour"))) => 1,
- show_acquisition_details => defined $tmpl_infos->{ordered_exists} || defined $tmpl_infos->{spent_exists} ? 1 : 0,
- basketno => $order->{basketno},
- %$tmpl_infos,
+ mana_comments => $subs->{comments},
);
output_html_with_http_headers $query, $cookie, $template->output;
-
-sub get_default_view {
- my $defaultview = C4::Context->preference('IntranetBiblioDefaultView');
- my %views = C4::Search::enabled_staff_search_views();
- if ( $defaultview eq 'isbd' && $views{can_view_ISBD} ) {
- return 'ISBDdetail';
- }
- elsif ( $defaultview eq 'marc' && $views{can_view_MARC} ) {
- return 'MARCdetail';
- }
- elsif ( $defaultview eq 'labeled_marc' && $views{can_view_labeledMARC} ) {
- return 'labeledMARCdetail';
- }
- return 'detail';
-}
-
-sub get_value_with_gst_params {
- my $value = shift;
- my $gstrate = shift;
- my $bookseller = shift;
- if ( $bookseller->{listincgst} ) {
- return ( $value, $value / ( 1 + $gstrate ) );
- } else {
- return ( $value * ( 1 + $gstrate ), $value );
- }
-}
-
-sub get_gste {
- my $value = shift;
- my $gstrate = shift;
- my $bookseller = shift;
- if ( $bookseller->{invoiceincgst} ) {
- return $value / ( 1 + $gstrate );
- } else {
- return $value;
- }
-}
-
-sub get_gst {
- my $value = shift;
- my $gstrate = shift;
- my $bookseller = shift;
- if ( $bookseller->{invoiceincgst} ) {
- return $value / ( 1 + $gstrate ) * $gstrate;
- } else {
- return $value * ( 1 + $gstrate ) - $value;
- }
-}