Bug 11425: Add item search form in staff interface
authorJulian Maurice <julian.maurice@biblibre.com>
Thu, 4 Jul 2013 14:52:58 +0000 (16:52 +0200)
committerTomas Cohen Arazi <tomascohen@gmail.com>
Tue, 4 Nov 2014 22:08:12 +0000 (19:08 -0300)
commit7c2ff7940e0b579f6d882abd03c75c4fd191bcb1
treebd65956a53f226d2152f994b1acf1ed1ca124d3b
parent8a26171b903f52fb6c81fa891b8e2abc9d00856a
Bug 11425: Add item search form in staff interface

Item search is available at catalogue/itemsearch.pl (link is in
catalogue/search.pl)
It only uses SQL (not Zebra)
* Use DataTables and server-side processing to be able to filter on
  individual columns after the first search is done.
* Allow to export results in CSV
* With Javascript disabled, search form still works (and CSV export too)

There is the possibility to define "Custom search fields" in a new admin
page admin/items_search_fields.pl (link is in admin/admin-home.pl)
A custom item search field is defined by:
* a name: its unique identifier
* a label: the text displayed to the user
* a MARC field/subfield: the field/subfield to query (it uses
  ExtractValue)
* an authorised values list (optional): if defined the list is displayed
  in the search form

New Perl dependency: Template::Plugin::JSON::Escape

Test plan:
1/ Apply the patch and run updatedatabase.pl
2/ Go to advanced search (staff interface), then click on "Go to item
search"
3/ Play with the search form! :)
In the 3rd fieldset you can add as many fields as you want and combine them with
boolean operators (AND, OR). You can use SQL jokers characters (%, _)
You can output to screen (in a DataTables table) or to a CSV file.
4/ In the DataTables table, play with filters and try sorting columns.
5/ Disable Javascript (with Firefox: extensions NoScript or YesScript,
or in about:config 'javascript.enabled' = false
6/ Reload the search page and do some searches on screen output. (there
is no sorting or filtering features, but there is still pagination)
7/ Try again CSV output.
8/ You can re-enable Javascript.
9/ Go to Administration > Items search fields
10/ Add a new field. Example for title (in UNIMARC):
  Name: title
  Label: Title
  MARC field: 200
  MARC subfield: a
  Authorised values category: None
(add another field with an authorised values category to see the
difference).
11/ As you are there try to update and delete some fields.
12/ Go back to items search form. You can see in the 3rd fieldset that
your fields have appeared in the selects.
13/ Try searching on them.
14/ I think you're done :)

Signed-off-by: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com>
Work as described. Good new option.
No koha-qa errors

Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
24 files changed:
C4/Installer/PerlDependencies.pm
C4/Items.pm
C4/SQLHelper.pm
Koha/Item/Search/Field.pm [new file with mode: 0644]
acqui/check_uniqueness.pl
admin/items_search_field.pl [new file with mode: 0755]
admin/items_search_fields.pl [new file with mode: 0755]
catalogue/itemsearch.pl [new file with mode: 0755]
installer/data/mysql/kohastructure.sql
installer/data/mysql/updatedatabase.pl
koha-tmpl/intranet-tmpl/prog/en/css/itemsearchform.css [new file with mode: 0644]
koha-tmpl/intranet-tmpl/prog/en/includes/admin-items-search-field-form.inc [new file with mode: 0644]
koha-tmpl/intranet-tmpl/prog/en/includes/admin-menu.inc
koha-tmpl/intranet-tmpl/prog/en/includes/catalogue/itemsearch_item.csv.inc [new file with mode: 0644]
koha-tmpl/intranet-tmpl/prog/en/includes/catalogue/itemsearch_item.inc [new file with mode: 0644]
koha-tmpl/intranet-tmpl/prog/en/includes/catalogue/itemsearch_item.json.inc [new file with mode: 0644]
koha-tmpl/intranet-tmpl/prog/en/includes/catalogue/itemsearch_items.inc [new file with mode: 0644]
koha-tmpl/intranet-tmpl/prog/en/modules/admin/admin-home.tt
koha-tmpl/intranet-tmpl/prog/en/modules/admin/items_search_field.tt [new file with mode: 0644]
koha-tmpl/intranet-tmpl/prog/en/modules/admin/items_search_fields.tt [new file with mode: 0644]
koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/advsearch.tt
koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/itemsearch.csv.tt [new file with mode: 0644]
koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/itemsearch.json.tt [new file with mode: 0644]
koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/itemsearch.tt [new file with mode: 0644]