Bug 28130 - Show list of serial email alerts a patron subscribed to in patron account in OPAC
Summary: Show list of serial email alerts a patron subscribed to in patron account in ...
Status: Needs documenting
Alias: None
Product: Koha
Classification: Unclassified
Component: OPAC (show other bugs)
Version: unspecified
Hardware: All All
: P5 - low enhancement (vote)
Assignee: Aleisha Amohia
QA Contact: Testopia
URL:
Keywords:
: 25848 (view as bug list)
Depends on:
Blocks:
 
Reported: 2021-04-12 09:14 UTC by Katrin Fischer
Modified: 2023-12-10 20:36 UTC (History)
5 users (show)

See Also:
Change sponsored?: Sponsored
Patch complexity: Medium patch
Documentation contact:
Documentation submission:
Text to go in the release notes:
This enhancement adds an 'Alert subscriptions' page to a patron account to easily view or cancel email alerts the patron has enabled for subscriptions. This new page is available on both the staff interface and the OPAC.
Version(s) released in:
23.11.00


Attachments
Bug 28130: [WIP] Manage a patron's subscription alerts (9.96 KB, patch)
2023-05-23 05:10 UTC, Aleisha Amohia
Details | Diff | Splinter Review
Bug 28130: Manage a patron's subscription alerts (13.04 KB, patch)
2023-05-24 09:43 UTC, Aleisha Amohia
Details | Diff | Splinter Review
Bug 28130: Manage a patron's subscription alerts (13.07 KB, patch)
2023-05-24 22:00 UTC, Aleisha Amohia
Details | Diff | Splinter Review
Bug 28130: Manage subscription alerts on OPAC (10.88 KB, patch)
2023-05-24 22:00 UTC, Aleisha Amohia
Details | Diff | Splinter Review
Bug 28130: Manage a patron's subscription alerts (13.22 KB, patch)
2023-05-25 05:55 UTC, Biblibre Sandboxes
Details | Diff | Splinter Review
Bug 28130: Manage subscription alerts on OPAC (11.03 KB, patch)
2023-05-25 05:55 UTC, Biblibre Sandboxes
Details | Diff | Splinter Review
Bug 28130: Manage a patron's subscription alerts (13.26 KB, patch)
2023-05-30 16:46 UTC, Sam Lau
Details | Diff | Splinter Review
Bug 28130: Manage subscription alerts on OPAC (11.07 KB, patch)
2023-05-30 16:46 UTC, Sam Lau
Details | Diff | Splinter Review
Bug 28130: Manage a patron's subscription alerts (13.33 KB, patch)
2023-07-21 13:07 UTC, Nick Clemens
Details | Diff | Splinter Review
Bug 28130: Manage subscription alerts on OPAC (11.14 KB, patch)
2023-07-21 13:07 UTC, Nick Clemens
Details | Diff | Splinter Review
Bug 28130: (QA follow-up) Use schema result to fetch alerts to allow for prefetch (1015 bytes, patch)
2023-07-21 13:07 UTC, Nick Clemens
Details | Diff | Splinter Review
Bug 28130: (QA follow-up) Tidy (9.08 KB, patch)
2023-07-21 13:07 UTC, Nick Clemens
Details | Diff | Splinter Review

Note You need to log in before you can comment on or make changes to this bug.
Description Katrin Fischer 2021-04-12 09:14:31 UTC
It would be nice if a patron could see which email notifications for new serial issues they have subscribed to in the OPAC.

At the moment subscribing and unsubscribing is only possible from the detail screen and this makes it somewhat hard to find for patrons.
Comment 1 Katrin Fischer 2022-02-08 14:38:41 UTC
Just came up again as a question in training - would still be a nice addition :)
Comment 2 Aleisha Amohia 2023-05-23 05:10:00 UTC
Created attachment 151550 [details] [review]
Bug 28130: [WIP] Manage a patron's subscription alerts

Patch in progress
Comment 3 Aleisha Amohia 2023-05-24 09:43:10 UTC
Created attachment 151619 [details] [review]
Bug 28130: Manage a patron's subscription alerts

This enhancement adds an 'Alert subscriptions' page to a patron account to easily view or cancel email alerts the patron has subscribed to.

To test:

1. Go to Cataloging. Create a biblio.
2. Go to Tools -> Notices & slips. Create a notice under the "Serials (new issue)" module, if you don't already have one.
3. Go to Serials. Create a subscription. Link the biblio you just created. Add info like the callnumber, location, library. Choose your notice under Patron notification. Fill out the remaining details and save your subscription.
4. Open this record in the OPAC. Under the Subscriptions tab, click the button to "Subscribe to email notification on new issues"
5. Go back to the staff interface. Go to your patron account.
6. Notice there is a new "Alert subscriptions" tab in the left sidebar menu. The number in brackets should say 1, for the subscription you just enabled email alerts.
7. Click into the page. Confirm your subscription shows in the table.
8. Click the button to unsubscribe. A confirmation should pop up. Confirm you can cancel the unsubscribe action. Then confirm you can unsubscribe using this button.
9. Confirm tests pass t/db_dependent/Koha/Patron.t

Sponsored-by: Bibliotheksservice-Zentrum Baden-Wuerttemberg
Comment 4 Christian Stelzenmüller 2023-05-24 13:00:31 UTC
An error occurs when trying to open a sandbox with the enhancement. Part of the error trace says:

"Error trace
Could not mkdir /tmp/cgi_compile_22068: No space left on device at /usr/share/perl5/CGI/Compile.pm line 195
1.	in CGI::Compile::_eval at /usr/share/perl5/CGI/Compile.pm line 195
2.	  192:     $tmp_dir ||= File::Spec->catfile(File::Spec->tmpdir, "cgi_compile_$$");
3.	  193: 
4.	  194:     if (! -d $tmp_dir) {
5.	  195:         mkdir $tmp_dir          or die "Could not mkdir $tmp_dir: $!";
6.	  196:         chmod 0700, $tmp_dir    or die "Could not chmod 0700 $tmp_dir: $!";
7.	  197:     }
8.	  198: "

I could send the complete error trace if needed.
Comment 5 Christian Stelzenmüller 2023-05-24 13:31:02 UTC
I'm sorry that was a sandbox issue. The enhancement works fine. 

But it's for the staff client. First of all, we would like to have it for the patron itself, in hers or his account in the opac.
Besides that, it looks fine to me.
Comment 6 Aleisha Amohia 2023-05-24 22:00:55 UTC
Created attachment 151656 [details] [review]
Bug 28130: Manage a patron's subscription alerts

This enhancement adds an 'Alert subscriptions' page to a patron account to easily view or cancel email alerts the patron has subscribed to.

To test:

1. Go to Cataloging. Create a biblio.
2. Go to Tools -> Notices & slips. Create a notice under the "Serials (new issue)" module, if you don't already have one.
3. Go to Serials. Create a subscription. Link the biblio you just created. Add info like the callnumber, location, library. Choose your notice under Patron notification. Fill out the remaining details and save your subscription.
4. Open this record in the OPAC. Under the Subscriptions tab, click the button to "Subscribe to email notification on new issues"
5. Go back to the staff interface. Go to your patron account.
6. Notice there is a new "Alert subscriptions" tab in the left sidebar menu. The number in brackets should say 1, for the subscription you just enabled email alerts.
7. Click into the page. Confirm your subscription shows in the table.
8. Click the button to unsubscribe. A confirmation should pop up. Confirm you can cancel the unsubscribe action. Then confirm you can unsubscribe using this button.
9. Confirm tests pass t/db_dependent/Koha/Patron.t

Sponsored-by: Bibliotheksservice-Zentrum Baden-Wuerttemberg
Comment 7 Aleisha Amohia 2023-05-24 22:00:58 UTC
Created attachment 151657 [details] [review]
Bug 28130: Manage subscription alerts on OPAC

This patch adds an 'Alert subscriptions' tab to the patron's account on the OPAC, so they can easily view or cancel email alerts they have subscribed to.

To test:

1. Subscribe to email alerts for one or more subscriptions via the OPAC
2. Go to your account, notice the new 'Alert subscriptions' menu option, click here
3. Confirm your subscribed alerts show here. Confirm the table sorting works etc (JS enabled).
4. Test unsubscribing from email alerts, make sure the confirmation pop-up works as expected (JS enabled).
5. Confirm that, when unsubscribing, you are redirected back to this page.
6. Confirm the menu option disappears from the left sidebar navigation if you have no alert subscriptions.

Sponsored-by: Bibliotheksservice-Zentrum Baden-Wuerttemberg
Comment 8 Biblibre Sandboxes 2023-05-25 05:55:07 UTC
Created attachment 151658 [details] [review]
Bug 28130: Manage a patron's subscription alerts

This enhancement adds an 'Alert subscriptions' page to a patron account to easily view or cancel email alerts the patron has subscribed to.

To test:

1. Go to Cataloging. Create a biblio.
2. Go to Tools -> Notices & slips. Create a notice under the "Serials (new issue)" module, if you don't already have one.
3. Go to Serials. Create a subscription. Link the biblio you just created. Add info like the callnumber, location, library. Choose your notice under Patron notification. Fill out the remaining details and save your subscription.
4. Open this record in the OPAC. Under the Subscriptions tab, click the button to "Subscribe to email notification on new issues"
5. Go back to the staff interface. Go to your patron account.
6. Notice there is a new "Alert subscriptions" tab in the left sidebar menu. The number in brackets should say 1, for the subscription you just enabled email alerts.
7. Click into the page. Confirm your subscription shows in the table.
8. Click the button to unsubscribe. A confirmation should pop up. Confirm you can cancel the unsubscribe action. Then confirm you can unsubscribe using this button.
9. Confirm tests pass t/db_dependent/Koha/Patron.t

Sponsored-by: Bibliotheksservice-Zentrum Baden-Wuerttemberg
Signed-off-by: Christian Stelzenmüller <christian.stelzenmueller@bsz-bw.de>
Comment 9 Biblibre Sandboxes 2023-05-25 05:55:09 UTC
Created attachment 151659 [details] [review]
Bug 28130: Manage subscription alerts on OPAC

This patch adds an 'Alert subscriptions' tab to the patron's account on the OPAC, so they can easily view or cancel email alerts they have subscribed to.

To test:

1. Subscribe to email alerts for one or more subscriptions via the OPAC
2. Go to your account, notice the new 'Alert subscriptions' menu option, click here
3. Confirm your subscribed alerts show here. Confirm the table sorting works etc (JS enabled).
4. Test unsubscribing from email alerts, make sure the confirmation pop-up works as expected (JS enabled).
5. Confirm that, when unsubscribing, you are redirected back to this page.
6. Confirm the menu option disappears from the left sidebar navigation if you have no alert subscriptions.

Sponsored-by: Bibliotheksservice-Zentrum Baden-Wuerttemberg
Signed-off-by: Christian Stelzenmüller <christian.stelzenmueller@bsz-bw.de>
Comment 10 Christian Stelzenmüller 2023-05-25 05:57:03 UTC
Tested with alerts for two different subscriptions, looks good to me. 

Maybe someone else can have a look at it too to verify.
Comment 11 Aleisha Amohia 2023-05-26 03:10:49 UTC
I'm not sure why this was set to Patch doesn't apply, it applies cleanly on main for me.
Comment 12 Sam Lau 2023-05-30 16:46:39 UTC
Created attachment 151814 [details] [review]
Bug 28130: Manage a patron's subscription alerts

This enhancement adds an 'Alert subscriptions' page to a patron account to easily view or cancel email alerts the patron has subscribed to.

To test:

1. Go to Cataloging. Create a biblio.
2. Go to Tools -> Notices & slips. Create a notice under the "Serials (new issue)" module, if you don't already have one.
3. Go to Serials. Create a subscription. Link the biblio you just created. Add info like the callnumber, location, library. Choose your notice under Patron notification. Fill out the remaining details and save your subscription.
4. Open this record in the OPAC. Under the Subscriptions tab, click the button to "Subscribe to email notification on new issues"
5. Go back to the staff interface. Go to your patron account.
6. Notice there is a new "Alert subscriptions" tab in the left sidebar menu. The number in brackets should say 1, for the subscription you just enabled email alerts.
7. Click into the page. Confirm your subscription shows in the table.
8. Click the button to unsubscribe. A confirmation should pop up. Confirm you can cancel the unsubscribe action. Then confirm you can unsubscribe using this button.
9. Confirm tests pass t/db_dependent/Koha/Patron.t

Sponsored-by: Bibliotheksservice-Zentrum Baden-Wuerttemberg
Signed-off-by: Christian Stelzenmüller <christian.stelzenmueller@bsz-bw.de>
Signed-off-by: Sam Lau <samalau@gmail.com>
Comment 13 Sam Lau 2023-05-30 16:46:42 UTC
Created attachment 151815 [details] [review]
Bug 28130: Manage subscription alerts on OPAC

This patch adds an 'Alert subscriptions' tab to the patron's account on the OPAC, so they can easily view or cancel email alerts they have subscribed to.

To test:

1. Subscribe to email alerts for one or more subscriptions via the OPAC
2. Go to your account, notice the new 'Alert subscriptions' menu option, click here
3. Confirm your subscribed alerts show here. Confirm the table sorting works etc (JS enabled).
4. Test unsubscribing from email alerts, make sure the confirmation pop-up works as expected (JS enabled).
5. Confirm that, when unsubscribing, you are redirected back to this page.
6. Confirm the menu option disappears from the left sidebar navigation if you have no alert subscriptions.

Sponsored-by: Bibliotheksservice-Zentrum Baden-Wuerttemberg
Signed-off-by: Christian Stelzenmüller <christian.stelzenmueller@bsz-bw.de>
Signed-off-by: Sam Lau <samalau@gmail.com>
Comment 14 Nick Clemens 2023-07-21 13:07:17 UTC
Created attachment 153779 [details] [review]
Bug 28130: Manage a patron's subscription alerts

This enhancement adds an 'Alert subscriptions' page to a patron account to easily view or cancel email alerts the patron has subscribed to.

To test:

1. Go to Cataloging. Create a biblio.
2. Go to Tools -> Notices & slips. Create a notice under the "Serials (new issue)" module, if you don't already have one.
3. Go to Serials. Create a subscription. Link the biblio you just created. Add info like the callnumber, location, library. Choose your notice under Patron notification. Fill out the remaining details and save your subscription.
4. Open this record in the OPAC. Under the Subscriptions tab, click the button to "Subscribe to email notification on new issues"
5. Go back to the staff interface. Go to your patron account.
6. Notice there is a new "Alert subscriptions" tab in the left sidebar menu. The number in brackets should say 1, for the subscription you just enabled email alerts.
7. Click into the page. Confirm your subscription shows in the table.
8. Click the button to unsubscribe. A confirmation should pop up. Confirm you can cancel the unsubscribe action. Then confirm you can unsubscribe using this button.
9. Confirm tests pass t/db_dependent/Koha/Patron.t

Sponsored-by: Bibliotheksservice-Zentrum Baden-Wuerttemberg
Signed-off-by: Christian Stelzenmüller <christian.stelzenmueller@bsz-bw.de>
Signed-off-by: Sam Lau <samalau@gmail.com>
Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
Comment 15 Nick Clemens 2023-07-21 13:07:19 UTC
Created attachment 153780 [details] [review]
Bug 28130: Manage subscription alerts on OPAC

This patch adds an 'Alert subscriptions' tab to the patron's account on the OPAC, so they can easily view or cancel email alerts they have subscribed to.

To test:

1. Subscribe to email alerts for one or more subscriptions via the OPAC
2. Go to your account, notice the new 'Alert subscriptions' menu option, click here
3. Confirm your subscribed alerts show here. Confirm the table sorting works etc (JS enabled).
4. Test unsubscribing from email alerts, make sure the confirmation pop-up works as expected (JS enabled).
5. Confirm that, when unsubscribing, you are redirected back to this page.
6. Confirm the menu option disappears from the left sidebar navigation if you have no alert subscriptions.

Sponsored-by: Bibliotheksservice-Zentrum Baden-Wuerttemberg
Signed-off-by: Christian Stelzenmüller <christian.stelzenmueller@bsz-bw.de>
Signed-off-by: Sam Lau <samalau@gmail.com>
Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
Comment 16 Nick Clemens 2023-07-21 13:07:22 UTC
Created attachment 153781 [details] [review]
Bug 28130: (QA follow-up) Use schema result to fetch alerts to allow for prefetch

Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
Comment 17 Nick Clemens 2023-07-21 13:07:25 UTC
Created attachment 153782 [details] [review]
Bug 28130: (QA follow-up) Tidy

Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
Comment 18 Tomás Cohen Arazi 2023-10-11 13:34:02 UTC
Pushed to master for 23.11.

Nice work everyone, thanks!
Comment 19 Fridolin Somers 2023-10-12 21:03:34 UTC
Enhancement not pushed to 23.05.x
Comment 20 Aleisha Amohia 2023-12-10 20:36:37 UTC
*** Bug 25848 has been marked as a duplicate of this bug. ***