[Koha-bugs] [Bug 34059] advance_notices.pl -c --digest-per-branch does not work as intended

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34059

--- Comment #1 from Pedro Amorim <pedro.amorim at ptfs-europe.com> ---
Created attachment 152475
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=152475&action=edit
Bug 34059: Add only issues from the branch that is creating the notice

Test plan, on k-t-d
1) Go to 'my account' on top right user menu
2) On 'Patron messaging preferences', click 'Edit'
3) On the 'Item due' row, check the 'Email' and 'Digests only' checkboxes and
save
4) On the top search bar, press 'Check out' and enter '42' (koha user
cardnumber)
5) On the checkout input bar, enter 39999000001372 and press checkout
7) Go to 'Set library' on top right user menu and pick a different library
8) Repeat step 4), then, on the checkout input, enter 39999000004571 and press
checkout
9) Verify that this user now has 2 items checked out, from 2 different
libraries at /cgi-bin/koha/circ/circulation.pl?borrowernumber=51
9) Run the following 2 queries to force the due_date to be equal to 'today's'
date for both issues:
NOTE: change the YYYY-MM-DD below to whatever day it is you're running this
test plan

UPDATE issues SET date_due = '2023-06-19 23:59:00' where issue_id = 1;
UPDATE issues SET date_due = '2023-06-19 23:59:00' where issue_id = 2;

10) Run the cronjob:
./koha/misc/cronjobs/advance_notices.pl -c --digest-per-branch

11) Verify that two DUEDGEST notices were created, one per each library, but
both notices contain both issues:
SELECT letter_code, time_queued, content FROM message_queue ORDER BY message_id
DESC LIMIT 2;

12) Apply patch, then do 10) and 11) again
13) Verify that each notice only contains the issue for its respective library

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.