Bugzilla – Attachment 21757 Details for
Bug 5336
Acq history search
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
[PASSED QA] Bug 5336: FIX: partial status was not correctly set
PASSED-QA-Bug-5336-FIX-partial-status-was-not-corr.patch (text/plain), 1.85 KB, created by
Katrin Fischer
on 2013-10-03 11:04:42 UTC
(
hide
)
Description:
[PASSED QA] Bug 5336: FIX: partial status was not correctly set
Filename:
MIME Type:
Creator:
Katrin Fischer
Created:
2013-10-03 11:04:42 UTC
Size:
1.85 KB
patch
obsolete
>From bdc86b2535411d144010a03dc4753e156e91e331 Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@biblibre.com> >Date: Tue, 1 Oct 2013 14:06:11 +0200 >Subject: [PATCH] [PASSED QA] Bug 5336: FIX: partial status was not correctly > set > >An order (o1) is considered as partially received if (at least) another >order (o2) has the o1.ordernumber == o2.parent_ordernumber and the >quantity received is < to the quantity (to receive) and o1.ordernumber >!= o1.parent_ordernumber. > >Signed-off-by: Katrin Fischer <Katrin.Fischer.83@web.de> >--- > installer/data/mysql/updatedatabase.pl | 2 +- > 1 file changed, 1 insertion(+), 1 deletion(-) > >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index 2289420..f2dbeb8 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -7166,7 +7166,7 @@ if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { > my $return_count; > $dbh->do("ALTER TABLE aqorders ADD COLUMN orderstatus varchar(16) DEFAULT 'new' AFTER parent_ordernumber"); > $dbh->do("UPDATE aqorders SET orderstatus='ordered' WHERE basketno IN (SELECT basketno FROM aqbasket WHERE closedate IS NOT NULL)"); >- $dbh->do("UPDATE aqorders SET orderstatus='partial' WHERE quantity > quantityreceived AND quantityreceived > 0"); >+ $dbh->do("UPDATE aqorders SET orderstatus='partial' WHERE quantity > quantityreceived AND ordernumber IN ( SELECT parent_ordernumber FROM ( SELECT DISTINCT(parent_ordernumber) FROM aqorders WHERE ordernumber != parent_ordernumber) AS aq )"); > $dbh->do("UPDATE aqorders SET orderstatus='complete' WHERE quantity=quantityreceived"); > $dbh->do("UPDATE aqorders SET orderstatus='cancelled' WHERE datecancellationprinted IS NOT NULL"); > print "Upgrade to $DBversion done (Bug 5336: Add the new column aqorders.orderstatus)\n"; >-- >1.7.9.5
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 5336
:
11603
|
11604
|
11792
|
14067
|
14188
|
14213
|
16013
|
17612
|
17613
|
17615
|
17617
|
17648
|
17649
|
17650
|
17883
|
18187
|
18411
|
18412
|
18413
|
18414
|
18496
|
18497
|
18498
|
18499
|
18500
|
19317
|
19318
|
19319
|
19320
|
19321
|
19550
|
20894
|
20895
|
20896
|
20897
|
20898
|
20899
|
21689
|
21690
|
21691
|
21692
|
21693
|
21694
|
21695
|
21696
|
21697
|
21707
|
21708
|
21709
|
21751
|
21752
|
21753
|
21754
|
21755
|
21756
| 21757 |
21758