[Koha-bugs] [Bug 11129] Filtering Items based on type in opac-detail.pl

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Wed Oct 30 10:33:33 CET 2013


http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11129

Olli-Antti Kivilahti <olli-antti.kivilahti at jns.fi> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #22513|0                           |1
        is obsolete|                            |

--- Comment #5 from Olli-Antti Kivilahti <olli-antti.kivilahti at jns.fi> ---
Created attachment 22569
  -->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=22569&action=edit
Bug 11129 - Filtering Items based on type in opac-detail.pl

Currently all Items are always shown on the opac-detail.pl. This is difficult
when the amount of Items grows substantially large.
Implemented a filter to limit the Items shown (and SELECTed from the DB) based
on some typical filters,
  locationbranch, volume, number, issue, fromDate, toDate.
Also streamlined how Serials-data is pulled from the DB to prevent substantial
extra work in C4::Items::GetItemsInfo().
C4::Items::GetItemsInfo() extended to support various filters.

All modifications:
Item filter shown when there are over 50 items (lotsofitems-flag).
Filter fields can be changed based on the Biblio type (isSerial-flag).
-Volume + Issue + Number available only for serials.
Can syspref if Issue-field is used in serial records.
Can syspref a regexp to parse the Volume + Number + Issue from the enumeration
or chronology field.
FromDate and ToDate filter the serial.publisheddate when dealing with serials
otherwise target the items.timestamp -column.
C4::Items::GetItemsInfo() simplified to include the serial data in the BIG SQL.
This makes filtering by publisheddate much more faster.

User input validated using HTML5 <input "number">
Business layer validations as well.

Unit tests:
Serials enumeration and chronology filtering
Items date and branch filtering

Sponsored by the Joensuu Regional Library

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.


More information about the Koha-bugs mailing list