#!/usr/bin/perl
-use strict;
-use CGI;
+# This file is part of Koha.
+#
+# Koha is free software; you can redistribute it and/or modify it
+# under the terms of the GNU General Public License as published by
+# the Free Software Foundation; either version 3 of the License, or
+# (at your option) any later version.
+#
+# Koha is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with Koha; if not, see <http://www.gnu.org/licenses>.
+
+use Modern::Perl;
+use CGI qw ( -utf8 );
+use C4::Acquisition;
use C4::Auth;
+use C4::Budgets;
use C4::Koha;
-use C4::Date;
use C4::Serials;
use C4::Output;
-use C4::Interface::CGI::Output;
use C4::Context;
-use DateTime;
+use C4::Search qw/enabled_staff_search_views/;
+use Koha::DateUtils;
+
+use Koha::Acquisition::Bookseller;
+
+use Date::Calc qw/Today Day_of_Year Week_of_Year Add_Delta_Days/;
+use Carp;
my $query = new CGI;
-my $op = $query->param('op');
+my $op = $query->param('op') || q{};
+my $issueconfirmed = $query->param('issueconfirmed');
my $dbh = C4::Context->dbh;
-my $sth;
-# my $id;
-my ($template, $loggedinuser, $cookie, $subs);
-my ($subscriptionid,$auser,$librarian,$cost,$aqbooksellerid, $aqbooksellername,$aqbudgetid, $bookfundid, $startdate, $periodicity,
- $publisheddate, $dow, $irregularity, $sublength, $subtype, $numberpattern, $numberlength, $weeklength, $monthlength,
- $add1,$every1,$whenmorethan1,$setto1,$lastvalue1,$innerloop1,
- $add2,$every2,$whenmorethan2,$setto2,$lastvalue2,$innerloop2,
- $add3,$every3,$whenmorethan3,$setto3,$lastvalue3,$innerloop3,
- $numberingmethod, $status, $biblionumber, $bibliotitle, $callnumber, $notes, $hemisphere);
+my $subscriptionid = $query->param('subscriptionid');
+
+if ( $op and $op eq "close" ) {
+ C4::Serials::CloseSubscription( $subscriptionid );
+} elsif ( $op and $op eq "reopen" ) {
+ C4::Serials::ReopenSubscription( $subscriptionid );
+}
-$subscriptionid = $query->param('subscriptionid');
+# the subscription must be deletable if there is NO issues for a reason or another (should not happend, but...)
+# Permission needed if it is a deletion (del) : delete_subscription
+# Permission needed otherwise : *
+my $permission = ($op eq "del") ? "delete_subscription" : "*";
-if ($op eq 'del') {
-$biblionumber = $query->param('biblionumber');
- &DelSubscription($subscriptionid,$biblionumber);
- $query->redirect("/cgi-bin/koha/serials/serials-home.pl");
- exit;
+my ($template, $loggedinuser, $cookie)
+= 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);
+$subs->{enddate} ||= GetExpirationDate($subscriptionid);
-}
-my $subs = &GetSubscription($subscriptionid);
-my ($routing, @routinglist) = getroutinglist($subscriptionid);
my ($totalissues,@serialslist) = GetSerials($subscriptionid);
$totalissues-- if $totalissues; # the -1 is to have 0 if this is a new subscription (only 1 issue)
-# the subscription must be deletable if there is NO issues for a reason or another (should not happend, but...)
-($template, $loggedinuser, $cookie)
-= get_template_and_user({template_name => "serials/subscription-detail.tmpl",
- query => $query,
- type => "intranet",
- authnotrequired => 0,
- flagsrequired => {catalogue => 1},
- debug => 1,
- });
-
-my ($user, $cookie, $sessionID, $flags)
- = checkauth($query, 0, {catalogue => 1}, "intranet");
-
-my $weekarrayjs='';
-my $count = 0;
-my $today=get_today();
- my $dateobj=DATE_obj($today);
- my $year=$dateobj->year;
- my $month=$dateobj->month;
- my $day=$dateobj->day_of_month;
-my $firstday = $dateobj->day_of_year;
-my $wkno = $dateobj->week_number;
-my $weekno = $wkno;
-for(my $i=$firstday;$i<($firstday+365);$i=$i+7){
- $count = $i;
- if($wkno > 52){$year++; $wkno=1;}
- if($count>365){$count=$i-365;}
- my $newdate=DateTime->from_day_of_year(year=>$year,day_of_year=>$count);
- $weekarrayjs .= "'Wk $wkno: ".format_date($newdate->ymd)."',";
- $wkno++;
+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;
+ }
+
+ # 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); }
+ } else {
+ $issueconfirmed = "1";
+ }
+ # If it's ok to delete the subscription, we do so
+ if ($issueconfirmed eq "1") {
+ &DelSubscription($subscriptionid);
+ print $query->redirect("/cgi-bin/koha/serials/serials-home.pl");
+ exit;
+ }
}
-chop($weekarrayjs);
+my $hasRouting = check_routing($subscriptionid);
+
+(undef, $cookie, undef, undef)
+ = checkauth($query, 0, {catalogue => 1}, "intranet");
+
+# 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} = output_pref( { str => $subs->{$date}, dateonly => 1 } )
+ if $subs->{$date};
+}
+$subs->{location} = GetKohaAuthorisedValueLib("LOC",$subs->{location});
+$subs->{abouttoexpire} = abouttoexpire($subs->{subscriptionid});
+$template->param(%{ $subs });
+$template->param(biblionumber_for_new_subscription => $subs->{bibnum});
+my @irregular_issues = split /;/, $subs->{irregularity};
+
+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 $additional_fields = Koha::AdditionalField->all( { tablename => 'subscription' } );
+for my $field ( @$additional_fields ) {
+ if ( $field->{authorised_value_category} ) {
+ $field->{authorised_value_choices} = GetAuthorisedValues( $field->{authorised_value_category} );
+ }
+}
+$template->param( additional_fields_for_subscription => $additional_fields );
$template->param(
- routing => $routing,
- user => $subs->{auser},
- librarian => $subs->{librarian},
- aqbooksellerid => $subs->{aqbooksellerid},
- aqbooksellername => $subs->{aqbooksellername},
- cost => $subs->{cost},
- aqbudgetid => $subs->{aqbudgetid},
- bookfundid => $subs->{bookfundid},
- startdate => format_date($subs->{startdate}),
- publisheddate => format_date($subs->{publisheddate}),
- periodicity => $subs->{periodicity},
- dow => $subs->{dow},
- irregularity => $subs->{irregularity},
- numberlength => $subs->{numberlength},
- weeklength => $subs->{weeklength},
- monthlength => $subs->{monthlength},
- numberpattern => $subs->{numberpattern},
- add1 => $subs->{add1},
- every1 => $subs->{every1},
- whenmorethan1 => $subs->{whenmorethan1},
- innerloop1 => $subs->{innerloop1},
- setto1 => $subs->{setto1},
- lastvalue1 => $subs->{lastvalue1},
- add2 => $subs->{add2},
- every2 => $subs->{every2},
- whenmorethan2 => $subs->{whenmorethan2},
- setto2 => $subs->{setto2},
- lastvalue2 => $subs->{lastvalue2},
- innerloop2 => $subs->{innerloop2},
- add3 => $subs->{add3},
- every3 => $subs->{every3},
- whenmorethan3 => $subs->{whenmorethan3},
- setto3 => $subs->{setto3},
- lastvalue3 => $subs->{lastvalue3},
- innerloop3 => $subs->{innerloop3},
- weekarrayjs => $weekarrayjs,
- numberingmethod => $subs->{numberingmethod},
- status => $subs->{status},
- biblionumber => $subs->{biblionumber},
- bibliotitle => $subs->{bibliotitle},
- callnumber => $subs->{callnumber},
- notes => $subs->{notes},
- subscriptionid => $subs->{subscriptionid},
- serialslist => \@serialslist,
- totalissues => $totalissues,
- hemisphere => $hemisphere,
- );
-$template->param(
- "periodicity$subs->{periodicity}" => 1,
- "arrival$subs->{dow}" => 1,
- "numberpattern$subs->{numberpattern}" => 1,
- intranetstylesheet => C4::Context->preference("intranetstylesheet"),
- intranetcolorstylesheet => C4::Context->preference("intranetcolorstylesheet"),
- );
+ subscriptionid => $subscriptionid,
+ serialslist => \@serialslist,
+ hasRouting => $hasRouting,
+ routing => C4::Context->preference("RoutingSerials"),
+ totalissues => $totalissues,
+ cannotedit => (not C4::Serials::can_edit_subscription( $subs )),
+ frequency => $frequency,
+ numberpattern => $numberpattern,
+ has_X => ($numberpattern->{'numberingmethod'} =~ /{X}/) ? 1 : 0,
+ has_Y => ($numberpattern->{'numberingmethod'} =~ /{Y}/) ? 1 : 0,
+ has_Z => ($numberpattern->{'numberingmethod'} =~ /{Z}/) ? 1 : 0,
+ intranetstylesheet => C4::Context->preference('intranetstylesheet'),
+ intranetcolorstylesheet => C4::Context->preference('intranetcolorstylesheet'),
+ irregular_issues => scalar @irregular_issues,
+ default_bib_view => $default_bib_view,
+ (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,
+);
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;
+ }
+}