From: Mark Tompsett <mtomp...@hotmail.com>
Added Atomic Update to fix poorly transferred orders
TEST PLAN
---------
8) Apply patch (2)
9) Run the database updates
$ ./installer/data/mysql/updatedatabase.pl
-- This should run without error
10) prove -v t/db_dependent/Acquisition/TransferOrder.t
-- This should fail, because the transfer function is still
not fixed.
Signed-off-by: Indranil Das Gupta (L2C2 Technologies) <indr...@gmail.com>
---
.../Bug-13993-Correct-OrderStatus-Of-Poorly-Transferred-Orders.sql | 3 +++
1 file changed, 3 insertions(+)
create mode 100644
installer/data/mysql/atomicupdate/Bug-13993-Correct-OrderStatus-Of-Poorly-Transferred-Orders.sql
diff --git
a/installer/data/mysql/atomicupdate/Bug-13993-Correct-OrderStatus-Of-Poorly-Transferred-Orders.sql
b/installer/data/mysql/atomicupdate/Bug-13993-Correct-OrderStatus-Of-Poorly-Transferred-Orders.sql
new file mode 100644
index 0000000..0a05ae5
--- /dev/null
+++
b/installer/data/mysql/atomicupdate/Bug-13993-Correct-OrderStatus-Of-Poorly-Transferred-Orders.sql
@@ -0,0 +1,3 @@
+UPDATE aqorders SET orderstatus='cancelled'
+ WHERE (datecancellationprinted IS NOT NULL OR
+ datecancellationprinted<>'0000-00-00');
--
1.9.1
_______________________________________________
Koha-patches mailing list
Koha-patches@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-patches
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
