Bug 14057: Inventory is painfully slow
authorMark Tompsett <mtompset@hotmail.com>
Fri, 24 Apr 2015 04:40:46 +0000 (00:40 -0400)
committerTomas Cohen Arazi <tomascohen@gmail.com>
Wed, 6 May 2015 13:40:23 +0000 (10:40 -0300)
commit4e0468e8c2587fa4f51cb22b59ac5466383bbab1
treeb45cb3199b886e1f78d259eb7b319c242ec7dbce
parent24e0c1b756945517e4ec02af81bc761128b1a907
Bug 14057: Inventory is painfully slow

This patch is a rough start. I believe it runs exponentially
faster, but its equality to the previous version needs to be
tested before I clean it up to acceptable standards.

Nested hashes of hashes was being a debugging nightmare.

Moved the SQL select to C4::Koha.

Changed the GetItemsForInventory to have a hashref parameter.
Added interface, in case there is a need for 'opac' vs. 'staff'.

Added t/db_dependent/Items/GetItemsForInventory.t
Added t/db_dependent/Koha/GetKohaAuthorisedValuesMapping.t

Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@gmail.com>
C4/Items.pm
C4/Koha.pm
t/db_dependent/Items/GetItemsForInventory.t [new file with mode: 0755]
t/db_dependent/Koha/GetKohaAuthorisedValuesMapping.t [new file with mode: 0755]
tools/inventory.pl