Bug 27248 - Allow to use list of barcodes/itemnumbers with Batch extend due dates tool
Summary: Allow to use list of barcodes/itemnumbers with Batch extend due dates tool
Status: Signed Off
Alias: None
Product: Koha
Classification: Unclassified
Component: Tools (show other bugs)
Version: unspecified
Hardware: All All
: P5 - low enhancement
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-12-16 10:45 UTC by Katrin Fischer
Modified: 2025-08-11 07:40 UTC (History)
3 users (show)

See Also:
GIT URL:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:


Attachments
Bug 27248: Add barcode list input to batch extend due dates (4.07 KB, patch)
2025-07-23 15:14 UTC, Brendan Lawlor
Details | Diff | Splinter Review
Bug 27248: Fix display of new due date column in preview table (2.24 KB, patch)
2025-07-23 15:14 UTC, Brendan Lawlor
Details | Diff | Splinter Review
Bug 27248: Add barcode list input to batch extend due dates (4.22 KB, patch)
2025-08-11 07:37 UTC, OpenFifth Sandboxes
Details | Diff | Splinter Review
Bug 27248: Fix display of new due date column in preview table (2.39 KB, patch)
2025-08-11 07:37 UTC, OpenFifth Sandboxes
Details | Diff | Splinter Review

Note You need to log in before you can comment on or make changes to this bug.
Description Katrin Fischer 2020-12-16 10:45:33 UTC
In some cases libraries want to use some more complicated criteria for selecting the items that they want to extend the due dates for. For these cases it would be great if SQL reports could be used to make a list that then can be uploaded to the tool, similar to how we manage other batch operations.
Comment 1 Brendan Lawlor 2025-07-23 15:14:25 UTC
Created attachment 184562 [details] [review]
Bug 27248: Add barcode list input to batch extend due dates

This patch adds a barcode list input to batch extend due dates

Test plan:
1. Have some checkouts and copy the barcodes
2. Go to Tools > Batch extend due dates
3. Paste the barcodes in the new input one line at a time
4. Confirm you can extend the due dates for those items
5. Confirm the other limits still work
   For example if you enter a branchcode and a list of barcodes
   only items that were checked out from that branchcode and
   are on the list of items get an updated due date
Comment 2 Brendan Lawlor 2025-07-23 15:14:27 UTC
Created attachment 184563 [details] [review]
Bug 27248: Fix display of new due date column in preview table

This patch removes a duplicate call to new_due_dates.shift so that the
new due date column shows the date for all selected checkouts.

To test:
1. Have some random checkouts
2. Use the batch_extend_due_dates tool with preview results checked
3. Notice only have the selected checkouts have data in the new due date column
4. Apply patch and retry seteps 2-3
5. All selected checkouts now show a date in the new due date column
Comment 3 Brendan Lawlor 2025-07-23 15:21:46 UTC
Batch extend due dates by item barcode was a feature in our previous ILS, so we sometimes still get requests to do this with a list of barcodes.

This patch is a work in progress based on the batch item modification barcode list input. The next step would be to add it to the batch operations drop down list in SQL reports.

Setting this to needs sign off to get some feedback. Thanks!
Comment 4 OpenFifth Sandboxes 2025-08-11 07:37:29 UTC
Created attachment 185301 [details] [review]
Bug 27248: Add barcode list input to batch extend due dates

This patch adds a barcode list input to batch extend due dates

Test plan:
1. Have some checkouts and copy the barcodes
2. Go to Tools > Batch extend due dates
3. Paste the barcodes in the new input one line at a time
4. Confirm you can extend the due dates for those items
5. Confirm the other limits still work
   For example if you enter a branchcode and a list of barcodes
   only items that were checked out from that branchcode and
   are on the list of items get an updated due date

Signed-off-by: Anneli Österman <anneli.osterman@koha-suomi.fi>
Comment 5 OpenFifth Sandboxes 2025-08-11 07:37:30 UTC
Created attachment 185302 [details] [review]
Bug 27248: Fix display of new due date column in preview table

This patch removes a duplicate call to new_due_dates.shift so that the
new due date column shows the date for all selected checkouts.

To test:
1. Have some random checkouts
2. Use the batch_extend_due_dates tool with preview results checked
3. Notice only have the selected checkouts have data in the new due date column
4. Apply patch and retry seteps 2-3
5. All selected checkouts now show a date in the new due date column

Signed-off-by: Anneli Österman <anneli.osterman@koha-suomi.fi>
Comment 6 Anneli Österman 2025-08-11 07:40:47 UTC
The barcode option worked as in test plan.

I'd be happy to test and sign off the SQL report option too, because it would be a more versatile functionality. :)