Attachment 48471 Details for Bug 15675 – Bug 15675 [QA Followup] - Close out accruing fines that are not really accruing, add issue_id to accruing fines

[patch] Bug 15675 [QA Followup] - Close out accruing fines that are not really accruing, add issue_id to accruing fines

Bug-15675-QA-Followup---Close-out-accruing-fines-t.patch (text/plain), 1.48 KB, created by Jonathan Druart on 2016-02-29 17:02:09 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2016-02-29 17:02:09 UTC

Size: 1.48 KB

patch

obsolete

>From 1eb1279ee7efd99d1b74b9b30699439d5572eb7b Mon Sep 17 00:00:00 2001
>From: Kyle M Hall <kyle@bywatersolutions.com>
>Date: Wed, 3 Feb 2016 14:38:54 +0000
>Subject: [PATCH] Bug 15675 [QA Followup] - Close out accruing fines that are
> not really accruing, add issue_id to accruing fines
>
>---
> installer/data/mysql/atomicupdate/bug_15334.sql | 10 ++++++++++
> 1 file changed, 10 insertions(+)
>
>diff --git a/installer/data/mysql/atomicupdate/bug_15334.sql b/installer/data/mysql/atomicupdate/bug_15334.sql
>index 7937e81..f133705 100644
>--- a/installer/data/mysql/atomicupdate/bug_15334.sql
>+++ b/installer/data/mysql/atomicupdate/bug_15334.sql
>@@ -1 +1,11 @@
>+-- Add issue_id to accountlines table
> ALTER TABLE accountlines ADD issue_id INT(11) NULL DEFAULT NULL AFTER accountlines_id;
>+
>+-- Close out any accruing fines with no current issue
>+UPDATE accountlines LEFT JOIN issues USING ( itemnumber, borrowernumber ) SET accounttype = 'F' WHERE accounttype = 'FU' and issues.issue_id IS NULL;
>+
>+-- Close out any extra not really accruing fines, keep only the latest accring fine
>+UPDATE accountlines SET accounttype = 'F' WHERE accountlines_id NOT IN ( SELECT accountlines_id FROM ( SELECT * FROM accountlines WHERE accounttype = 'FU' ORDER BY accountlines_id DESC ) a2 GROUP BY borrowernumber, itemnumber );
>+
>+-- Update the unclosed fines to add the current issue_id to them
>+UPDATE accountlines LEFT JOIN issues USING ( itemnumber ) SET accountlines.issue_id = issues.issue_id WHERE accounttype = 'FU';
>-- 
>2.7.0

Actions: View | Diff | Splinter Review

Attachments on bug 15675: 47313 | 47314 | 47315 | 47316 | 47373 | 47374 | 47375 | 47376 | 47378 | 47379 | 47380 | 47600 | 47601 | 47810 | 48468 | 48469 | 48470 | 48471 | 48472 | 48473