[Koha-bugs] [Bug 18398] CHECKIN/CHECKOUT/RENEWAL don't use AutoEmailPrimaryAddress but first valid e-mail

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

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

Caroline Cyr La Rose <caroline.cyr-la-rose at inlibro.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |caroline.cyr-la-rose at inlibr
                   |                            |o.com

--- Comment #6 from Caroline Cyr La Rose <caroline.cyr-la-rose at inlibro.com> ---
Behold, the monstruous test plan! *thunder crackles*

To test CHECKIN/CHECKOUT/RENEWAL with AutoEmailPrimaryAddress

1. Set RenewalSendNotice to 'Send'

2. Change email addresses of a patron (I used Edna Acosta)
   - In the 'Primary email' field, enter something like primary at ...
   - In the 'Secondary email' field, enter something like secondary at ...
   - In the 'Email' field of the 'Alternate address' section, enter something
like alternate at ...

3. Change messaging preferences of the same patron
   - Item check-in = email
   - Item checkout and renewal = email

4. Set AutoEmailPrimaryAddress to primary email address (home)

5. Check out an item to the patron

6. Check the to_address in the message_queue table for CHECKOUT, it should be
primary at ...

select to_address, letter_code, time_queued from message_queue where
date(time_queued) = curdate();

7. Renew the checkout

8. Check the to_address in the message_queue table for RENEWAL, it should be
primary at ...

select to_address, letter_code, time_queued from message_queue where
date(time_queued) = curdate();

9. Check in the item

10. Check the to_address in the message_queue table for CHECKIN, it should be
primary at ...

select to_address, letter_code, time_queued from message_queue where
date(time_queued) = curdate();

11. Delete the messages from the message_queue.

delete from message_queue where to_address like 'primary%';

12. Change AutoEmailPrimaryAddress to secondary email address (work)

13. Redo steps 5 to 10. The address in the message_queue table should now be
secondary at ...

14. Delete the messages from the message_queue.

delete from message_queue where to_address like 'secondary%';

15. Change AutoEmailPrimaryAddress to alternate email address (alternate)

16. Redo steps 5 to 10. The address in the message_queue table should now be
alternate at ...

17. Delete the messages from the message_queue.

delete from message_queue where to_address like 'alternate%';

18. Change AutoEmailPrimaryAddress to cardnumber as

19. Redo steps 5 to 10. The address in the message_queue table should now be
the patron's cardnumber

20. Delete the messages from the message_queue.

delete from message_queue where to_address = '23529001000463';

21. Change AutoEmailPrimaryAddress to first valid

22. Redo steps 5 to 10. The address in the message_queue table should now be
primary at ...

23. Delete the messages from the message_queue.

delete from message_queue where to_address like 'primary%';

24. Remove the patron's primary email address

25. Redo steps 5 to 10. The address in the message_queue table should now be
secondary at ...

26. Delete the messages from the message_queue.

delete from message_queue where to_address like 'secondary%';

27. Remove the patron's secondary email address

28. Redo steps 5 to 10. The address in the message_queue table should now be
alternate at ...

29. Delete the messages from the message_queue.

delete from message_queue where to_address like 'alternate%';

30. Remove the patron's alternate email address

31. Redo steps 5 to 10. The address in the message_queue table should now be
empty



To test RECALLS with AutoEmailPrimaryAddress

0. Set up recalls (see bug 19532)

1. Change email addresses of a patron (I used Edna Acosta)
   - In the 'Primary email' field, enter something like primary at ...
   - In the 'Secondary email' field, enter something like secondary at ...
   - In the 'Email' field of the 'Alternate address' section, enter something
like alternate at ...

2. Set AutoEmailPrimaryAddress to primary email address (home)

3. Place a recall from the patron's OPAC account

4. Check in the recalled item and confirm recall

5. Check the to_address in the message_queue table for CHECKIN, it should be
primary at ...

select to_address, letter_code, time_queued from message_queue where
date(time_queued) = curdate();

6. Delete the messages from the message_queue.

delete from message_queue where to_address like 'primary%';

7. Change AutoEmailPrimaryAddress to secondary email address (work)

8. From the patron's recalls in the staff interface, click Actions > Revert
waiting

9. Redo step 4 and 5. The address in the message_queue table should now be
secondary at ...

10. Delete the messages from the message_queue.

delete from message_queue where to_address like 'secondary%';

11. Change AutoEmailPrimaryAddress to alternate email address (alternate)

12. Redo step 4 and 5. The address in the message_queue table should now be
alternate at ...

13. Delete the messages from the message_queue.

delete from message_queue where to_address like 'alternate%';

14. Change AutoEmailPrimaryAddress to cardnumber as

15. Redo step 4 and 5. The address in the message_queue table should now be the
patron's cardnumber

16. Delete the messages from the message_queue.

delete from message_queue where to_address = '23529001000463';

17. Change AutoEmailPrimaryAddress to first valid

18. Redo step 4 and 5. The address in the message_queue table should now be
primary at ...

19. Delete the messages from the message_queue.

delete from message_queue where to_address like 'primary%';

20. Remove the patron's primary email address

21. Redo step 4 and 5. The address in the message_queue table should now be
secondary at ...

22. Delete the messages from the message_queue.

delete from message_queue where to_address like 'secondary%';

23. Remove the patron's secondary email address

24. Redo steps 4 and 5. The address in the message_queue table should now be
alternate at ...

25. Delete the messages from the message_queue.

delete from message_queue where to_address like 'alternate%';

26. Remove the patron's alternate email address

27. Redo steps 4 and 5. The address in the message_queue table should now be
empty

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