https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43799
--- Comment #3 from Andrew Fuerste-Henry <[email protected]> --- Created attachment 207933 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=207933&action=edit Bug 43799: Update cart_to_shelf to use greater than or equal To test 1 - from the commandline, set up two items with location CART and timestamps 1 and 2 hours in the past sudo koha-mysql kohadev update items set location='CART',permanent_location='GEN',timestamp=date_sub(now(),interval 121 minute) where barcode=39999000005592; update items set location='CART',permanent_location='GEN',timestamp=date_sub(now(),interval 61 minute) where barcode=39999000005578; 2 - in the staff interface, load biblio 134 and confirm items show shelving location "General stacks (Book cart)" 3 - OPTIONAL, check those timestamps and TIMESTAMPDIFF values: SELECT barcode, timestamp, TIMESTAMPDIFF(HOUR, items.timestamp, NOW()) from items where barcode in (39999000005592,39999000005578); 4 - run the cron for 1 hour perl misc/cronjobs cart_to_shelf.pl -h 1 5 - confirm neither item updated 6 - run the cron for 2 hours perl misc/cronjobs cart_to_shelf.pl -h 2 7 - confirm 1 item updated 8 - run the cron for 3 hours perl misc/cronjobs cart_to_shelf.pl -h 3 9 - confirm the second item updated APPLY PATCH, restart_all 10 - repeat steps 1 - 4 11 - confirm 1 item updated 12 - repeat step 6 13 - confirm the other item updated Signed-off-by: Barbara Johnson <[email protected]> -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list -- [email protected] To unsubscribe send an email to [email protected] website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
