From 00010fdb65ede4a63113ed8d5141b1e6e9b4e720 Mon Sep 17 00:00:00 2001 From: Aleisha Amohia Date: Tue, 23 May 2023 05:09:10 +0000 Subject: [PATCH] Bug 28130: [WIP] Manage a patron's subscription alerts Patch in progress --- Koha/Patron.pm | 18 +++ .../prog/en/includes/circ-menu.inc | 3 + .../en/modules/members/subscription-alerts.tt | 110 ++++++++++++++++++ members/subscription-alerts.pl | 56 +++++++++ 4 files changed, 187 insertions(+) create mode 100644 koha-tmpl/intranet-tmpl/prog/en/modules/members/subscription-alerts.tt create mode 100755 members/subscription-alerts.pl diff --git a/Koha/Patron.pm b/Koha/Patron.pm index 2a8eecf9f66..bc5df9eef45 100644 --- a/Koha/Patron.pm +++ b/Koha/Patron.pm @@ -2490,6 +2490,24 @@ sub get_savings { )->next->get_column('total_savings') // 0; } +=head3 subscription_alerts + + my $subscription_alerts = $patron->subscription_alerts; + +Return a Koha::Subscriptions object containing subscriptions for which the patron has subscribed to email alerts. + +=cut + +sub subscription_alerts { + my ( $self ) = @_; + + my $schema = Koha::Database->new->schema; + my @alerts = $schema->resultset('Alert')->search({ borrowernumber => $self->borrowernumber }); + my @subscription_ids = map { $_->externalid } @alerts; + + return Koha::Subscriptions->search({ subscriptionid => \@subscription_ids }); +} + =head2 Internal methods =head3 _type diff --git a/koha-tmpl/intranet-tmpl/prog/en/includes/circ-menu.inc b/koha-tmpl/intranet-tmpl/prog/en/includes/circ-menu.inc index 9f78956dd33..cbae570297d 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/includes/circ-menu.inc +++ b/koha-tmpl/intranet-tmpl/prog/en/includes/circ-menu.inc @@ -185,6 +185,9 @@ [% IF Koha.Preference('UseRecalls') && CAN_user_recalls %] [% IF recallsview %]
  • [% ELSE %]
  • [% END %]Recalls history
  • [% END %] + [% IF ( CAN_user_serials && patron.subscription_alerts.count ) %] + [% IF alertsview %]
  • [% ELSE %]
  • [% END %]Subscription alerts ([% patron.subscription_alerts.count | html %])
  • + [% END %] [% IF patronimages && CAN_user_tools_batch_upload_patron_images %] diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/members/subscription-alerts.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/members/subscription-alerts.tt new file mode 100644 index 00000000000..18ca65669a5 --- /dev/null +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/members/subscription-alerts.tt @@ -0,0 +1,110 @@ +[% USE raw %] +[% USE Asset %] +[% USE AuthorisedValues %] +[% USE Branches %] +[% SET footerjs = 1 %] +[% INCLUDE 'doc-head-open.inc' %] +Subscription alerts for [% INCLUDE 'patron-title.inc' no_html = 1 %] › Patrons › Koha +[% INCLUDE 'doc-head-close.inc' %] + + + +[% WRAPPER 'header.inc' %] + [% INCLUDE 'patron-search-header.inc' %] +[% END %] + +[% WRAPPER 'sub-header.inc' %] + [% WRAPPER breadcrumbs %] + [% WRAPPER breadcrumb_item %] + Patrons + [% END %] + [% WRAPPER breadcrumb_item %] + [% INCLUDE 'patron-title.inc' %] + [% END %] + [% WRAPPER breadcrumb_item bc_active= 1 %] + Subscription alerts + [% END %] + [% END #/ WRAPPER breadcrumbs %] +[% END #/ WRAPPER sub-header.inc %] + +
    +
    +
    +
    + + [% INCLUDE 'members-toolbar.inc' %] +

    Subscription alerts

    + + [% IF patron.subscription_alerts.count %] +
    + + + + + + + + + + + + + + [% FOREACH sub IN patron.subscription_alerts %] + + + + + + + + + [% END %] + +
    ISSNTitleLibraryLocationCall numberActions
    + [% IF sub.biblio.biblioitem.issn %][% sub.biblio.biblioitem.issn | html %][% END %] + + [% sub.biblio.title | html %] [% sub.biblio.subtitle | html %] + + [% IF ( sub.branchcode ) %][% Branches.GetName( sub.branchcode ) | html %][% END %] + + [% IF ( sub.location ) %][% AuthorisedValues.GetDescriptionByKohaField( kohafield => 'items.location', authorised_value => sub.location ) | html %][% END %] + + [% IF ( sub.callnumber ) %][% sub.callnumber | html %][% END %] + +
    + + + +
    +
    +
    + [% ELSE %] +
    +

    This patron has not subscribed to email alerts for any subscriptions.

    +
    + [% END %] + +
    +
    + +
    + +
    +
    + +[% MACRO jsinclude BLOCK %] + [% INCLUDE 'str/members-menu.inc' %] + [% Asset.js("js/members-menu.js") | $raw %] + [% INCLUDE 'datatables.inc' %] + +[% END %] + +[% INCLUDE 'intranet-bottom.inc' %] diff --git a/members/subscription-alerts.pl b/members/subscription-alerts.pl new file mode 100755 index 00000000000..5c9875cab90 --- /dev/null +++ b/members/subscription-alerts.pl @@ -0,0 +1,56 @@ +#!/usr/bin/perl + +# This file is part of Koha. +# +# Copyright 2023 Aleisha Amohia +# +# 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 . + +use Modern::Perl; + +use CGI qw ( -utf8 ); +use C4::Auth qw( get_template_and_user ); +use C4::Context; +use C4::Output qw( output_and_exit_if_error output_and_exit output_html_with_http_headers ); +use Koha::Patrons; + +my $input = CGI->new; + +my ( $template, $loggedinuser, $cookie ) = get_template_and_user( + { template_name => "members/subscription-alerts.tt", + query => $input, + type => "intranet", + flagsrequired => { serials => '*' }, + } +); + +my $borrowernumber = $input->param('borrowernumber'); + +my $logged_in_user = Koha::Patrons->find( $loggedinuser ); +my $patron = Koha::Patrons->find( $borrowernumber ); +output_and_exit_if_error( $input, $cookie, $template, { module => 'members', logged_in_user => $logged_in_user, current_patron => $patron } ); + +my $subscription_id = $input->param('subscription_id'); +if ( $subscription_id ) { + my $subscription = Koha::Subscriptions->find( $subscription_id ); + $subscription->remove_subscriber( $patron ); + print $input->redirect("/cgi-bin/koha/members/subscription-alerts.pl?borrowernumber=".$borrowernumber); +} + +$template->param( + patron => $patron, + alertsview => 1, +); + +output_html_with_http_headers $input, $cookie, $template->output; -- 2.30.2