https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37034
David Nind <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #4 from David Nind <[email protected]> --- I've tested, it works, and I've signed it off. Some suggestions: 1. Add a sample notice similar to Bug 36915 2. Rename to booking_expired.pl and BOOKING_EXPIRED (that makes more sense to me in English) I'll leave it up to you and the QA Team to decide. Testing notes (using KTD): 1. Add a sample booking notice. 2. Apply the patch. 3. Add an email address to the patron you will make the booking for (for example, Mary Burton, [email protected]) 4. Add a booking: . Find a record . Go to Items > Priority . Change "Bookable" to "Yes" then click "Update" . Use the "Place booking" action for the record . Enter the details to create a booking (using the patron you added an email address to) 5. Update the booking in the database so that it is expired: . koha-mysql kohadev . select * from bookings; . using the booking_id, update the start and end dates for the booking: update bookings set start_date = "2024-07-03 12:00:00" where booking_id="XXX"; (where XXX is the booking_id) update bookings set end_date = "2024-07-04 12:00:00" where booking_id="XXX"; (where XXX is the booking_id); (update end_date to yesterday's date) . Check the bookings for the record - there should be no current bookings 6. Run the cron job manually: perl misc/cronjobs/bookings/bookings_outdated.pl -v 1 bookings outdated between 2024-07-04 00:00:00 and 2024-07-04 23:59:59 borrower Burton, Mary has 1 booking(s) outdated. 7. Check that a notice was generated: . Go to the notices section for the patron OR . Check the message queue in the database: - koha-mysql kohadev - select * from message_queue; -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
