[Koha-bugs] [Bug 2601] Order fines by date and time
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2601 Katrin Fischer changed: What|Removed |Added Resolution|--- |DUPLICATE Status|NEW |RESOLVED --- Comment #9 from Katrin Fischer --- *** This bug has been marked as a duplicate of bug 16486 *** -- You are receiving this mail because: You are watching all bug changes. You are the QA Contact for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 2601] Order fines by date and time
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2601 Aleisha Amohia changed: What|Removed |Added CC||alei...@catalyst.net.nz --- Comment #8 from Aleisha Amohia --- I think this would be fixed by the patch from Bug 16486, which adds the timestamp as a column to fines tables, so it could be sorted on -- You are receiving this mail because: You are watching all bug changes. You are the QA Contact for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 2601] Order fines by date and time
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2601 Katrin Fischer changed: What|Removed |Added Status|ASSIGNED|NEW -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 2601] Order fines by date and time
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2601 Katrin Fischer changed: What|Removed |Added CC||katrin.fisc...@bsz-bw.de Status|Failed QA |ASSIGNED -- You are receiving this mail because: You are watching all bug changes. You are the QA Contact for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 2601] Order fines by date and time
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2601 M. Tompsett changed: What|Removed |Added CC||mtomp...@hotmail.com --- Comment #7 from M. Tompsett --- How can this be Failed QA if the patch is obsoleted? -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 2601] Order fines by date and time
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2601 Marjorie Barry-Vila changed: What|Removed |Added CC||marjorie.barry-v...@ccsr.qc ||.ca -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 2601] Order fines by date and time
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2601 Sven Coenye changed: What|Removed |Added CC||helpd...@neci.edu --- Comment #6 from Sven Coenye --- (In reply to Nicole C. Engard from comment #5) > Created attachment 17109 [details] > fines out of order > > Things are still sorted strangely - it's not the order in which the actions > took place. I numbered them in purple to show what order I entered them in. I realize I'm a bit late to this (and new to KOHA), but the accountno field in the accountlines table monotonically increases per patron/borrower for each transaction injected into the table. It can be used to sort the transactions in proper order without much of a performance hit. If this was not the proper avenue to post this, please point me in the right direction. -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 2601] Order fines by date and time
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2601 --- Comment #5 from Nicole C. Engard --- Created attachment 17109 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=17109&action=edit fines out of order Things are still sorted strangely - it's not the order in which the actions took place. I numbered them in purple to show what order I entered them in. -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 2601] Order fines by date and time
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2601 Marc Véron changed: What|Removed |Added CC||ve...@veron.ch --- Comment #4 from Marc Véron --- Accountlines primary key was added by Bug 7671. Is this bug still valid? Marc -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 2601] Order fines by date and time
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2601 Owen Leonard changed: What|Removed |Added Priority|PATCH-Sent |P5 AssignedTo|oleon...@myacpl.org |kyle.m.h...@gmail.com -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the QA Contact for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 2601] Order fines by date and time
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2601 Owen Leonard changed: What|Removed |Added Attachment #5889|0 |1 is obsolete|| -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the QA Contact for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 2601] Order fines by date and time
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2601 Ian Walls changed: What|Removed |Added Patch Status|Signed Off |Failed QA --- Comment #3 from Ian Walls 2011-10-19 17:06:43 UTC --- I disagree with adding a 1 second performance delay to fines payment just to improve sorting. C4::Accounts needs to be rewritten, anyway, and the addition of an accountlines primary key could resolve this in a more efficient manner. I'm going to mark this as Failed QA, but I recognize this is only my opinion on the matter. I'm open to debate on the subject, and will relent if the community feels this kind of performance hit is justifiable. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the QA Contact for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 2601] Order fines by date and time
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2601 Nicole C. Engard changed: What|Removed |Added Patch Status|Needs Signoff |Signed Off -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the QA Contact for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 2601] Order fines by date and time
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2601 Nicole C. Engard changed: What|Removed |Added Attachment #5881|0 |1 is obsolete|| --- Comment #2 from Nicole C. Engard 2011-10-14 13:27:55 UTC --- Created attachment 5889 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5889 [SIGNED-OFF] Fix for Bug 2601 - Order fines by date and time When a fine is paid off the modification of the original account line containing the fine gets its amount zeroed out and a line is added saying "Payment,thanks." Both these transactions happen at virtually the same time, so they cannot be ordered one after the other based on the timestamp. This patch adds a one second delay bewteen the two steps, and outputs the timestamp rather than the date of each transaction so that it is unambiguous when each one happened. NOTE: This fix will only fix the sorting of future transactions. Signed-off-by: Nicole C. Engard -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the QA Contact for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 2601] Order fines by date and time
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2601 Owen Leonard changed: What|Removed |Added Priority|P3 |PATCH-Sent Platform|PC |All Patch Status|--- |Needs Signoff -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the QA Contact for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
[Koha-bugs] [Bug 2601] Order fines by date and time
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2601 Owen Leonard changed: What|Removed |Added Status|NEW |ASSIGNED AssignedTo|gmcha...@gmail.com |oleon...@myacpl.org --- Comment #1 from Owen Leonard 2011-10-13 19:52:25 UTC --- Created attachment 5881 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5881 Proposed fix When a fine is paid off the modification of the original account line containing the fine gets its amount zeroed out and a line is added saying "Payment,thanks." Both these transactions happen at virtually the same time, so they cannot be ordered one after the other based on the timestamp. This patch adds a one second delay bewteen the two steps, and outputs the timestamp rather than the date of each transaction so that it is unambiguous when each one happened. NOTE: This fix will only fix the sorting of future transactions. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the QA Contact for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/