https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38924 --- Comment #263 from Sally <sally.healey@cheshiresharedservices.gov.uk> --- (In reply to Jacob O'Mara from comment #201)
Created attachment 193547 [details] [review] Bug 38924: Add patron_quotas table
Add the new patron_quotas table for storing circulation quotas
Setup: 1. Enable EnableCirculationQuotas, AllowQuotaOverride, and UseGuarantorQuota in system preferences 2. Create an Institutional patron (ORG) and a second Institutional patron (MEMBER) as guarantee of ORG 3. Create a non-institutional patron (NORELATION) with no relationships
Quota management: 4. Open ORG's detail page → verify "Circulation quota" tab visible in sidebar 5. Open NORELATION's detail page → verify no quota tab 6. Disable EnableCirculationQuotas → open ORG → verify no quota tab. Re-enable before continuing 7. Add a quota for ORG: Q1 2026, allocation 10 → verify it appears in the table 8. Add a second quota with overlapping dates → verify rejected with clash error 9. Edit the quota → verify modal prefills all fields including end date, save updates correctly 10. Add a future non-overlapping quota with no usage → verify Delete button appears. Delete it. Verify Delete button is absent on quotas that have usage
Checkout with single quota: 11. Checkout an item to ORG → verify checkout succeeds, quota used increments, ISSUE usage record visible in details 12. Exhaust ORG's quota, set AllowQuotaOverride ON → attempt checkout → verify confirmation prompt, can override 13. With quota still exhausted, set AllowQuotaOverride OFF → attempt checkout → verify blocked, cannot proceed
Checkout with guarantor quotas: 14. Give MEMBER their own active quota (allocation 5). 15. Checkout to MEMBER → verify QUOTA_SELECT prompt to choose between own and guarantor quota
Renewals and returns: 16. Renew an existing checkout that has quota usage → verify used increments and new RENEW usage record created 17. Return a checked-out item → verify quota used value is unchanged
Works as described in this test plan; signed off. -- You are receiving this mail because: You are watching all bug changes.