http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14380
Bug ID: 14380
Summary: Overriding fine on renewal will cause duplicate fines
Change sponsored?: ---
Product: Koha
Version: 3.18
Hardware: All
OS: All
Status: NEW
Severity: enhancement
Priority: P5 - low
Component: Circulation
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
CC: [email protected], [email protected]
Overriding fine on renewal will cause duplicate fines.
Because we use the due date in accountlines.description, and fines.pl uses
accountlines.description to uniquely identify fines on update, changing
date_due will create duplicate entries in accountlines.
select date,
amount,
description,
accounttype,
amountoutstanding,
lastincrement,
timestamp
from accountlines
where itemnumber = 35540
and borrowernumber = 24990\G
*************************** 1. row ***************************
date: 2015-05-05
amount: 0.500000
description: O'Connor's annotated criminal codes plus. 05/04/2015 11:59
PM
accounttype: F
amountoutstanding: 0.500000
lastincrement: 0.500000
timestamp: 2015-06-08 12:42:27
*************************** 2. row ***************************
date: 2015-06-08
amount: 4.500000
description: O'Connor's annotated criminal codes plus. 05/26/2015 11:59
PM
accounttype: FU
amountoutstanding: 4.500000
lastincrement: 0.500000
timestamp: 2015-06-08 02:02:40
2 rows in set (0.00 sec)
Looking in old_issues, you can see that the item was renewed, and that date_due
does match the second description... only the first accountlines entry is
marked woth accounttype 'F' on return, however.
select
date_due,
returndate,
lastreneweddate,
renewals,
timestamp,
issuedate
from old_issues
where itemnumber = 35540
and borrowernumber = 24990\G
*************************** 1. row ***************************
date_due: 2015-05-26 23:59:00
returndate: 2015-06-08 12:42:27
lastreneweddate: 2015-05-05 00:00:00
renewals: 1
timestamp: 2015-06-08 12:42:27
issuedate: 2015-04-13 09:23:20
To replicate:
1) check out an item
2) let the item go overdue and start accruing fines
3) renew the item
4) let the item go overdue again. Note that a second accountlines entry has
been added
5) return the item. Note that only one accountlines entry is marked with
accounttype 'F'.
--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
Koha-bugs mailing list
[email protected]
http://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/
