Attachment #23674 for bug #11425

View | Details | Raw Unified | Return to bug 11425
Collapse All | Expand All

Lines 544-549 our $PERL_DEPS = { Link Here

(-)a/C4/Installer/PerlDependencies.pm (+5 lines)
544	'required' => '1',	544	'required' => '1',
545	'min_ver' => '0.03',	545	'min_ver' => '0.03',
546	},	546	},
		547	'Template::Plugin::JSON::Escape' => {
		548	'usage' => 'Core',
		549	'required' => '1',
		550	'min_ver' => '0.02',
		551	},
547	'Data::Paginator' => {	552	'Data::Paginator' => {
548	'usage' => 'Core',	553	'usage' => 'Core',
549	'required' => '0',	554	'required' => '0',




use Data::Dumper; # used as part of logging item record changes, not just for
                  # debugging; so please don't remove this
use Koha::DateUtils qw/dt_from_string/;
use C4::SQLHelper qw(GetColumns);

use vars qw($VERSION @ISA @EXPORT);


	GetAnalyticsCount
        GetItemHolds

        SearchItemsByField
        SearchItems

        PrepareItemrecordDisplay

    return $holds;
}

=head2 SearchItemsByField

    my $items = SearchItemsByField($field, $value);

SearchItemsByField will search for items on a specific given field.
For instance you can search all items with a specific stocknumber like this:

    my $items = SearchItemsByField('stocknumber', $stocknumber);

=cut

sub SearchItemsByField {
    my ($field, $value) = @_;

    my $filters = [ {
            field => $field,
            query => $value,
    } ];

    my ($results) = SearchItems($filters);
    return $results;
}

sub _SearchItems_build_where_fragment {
    my ($filter) = @_;

    my $where_fragment;
    if (exists($filter->{conjunction})) {
        my (@where_strs, @where_args);
        foreach my $f (@{ $filter->{filters} }) {
            my $fragment = _SearchItems_build_where_fragment($f);
            if ($fragment) {
                push @where_strs, $fragment->{str};
                push @where_args, @{ $fragment->{args} };
            }
        }
        my $where_str = '';
        if (@where_strs) {
            $where_str = '(' . join (' ' . $filter->{conjunction} . ' ', @where_strs) . ')';
            $where_fragment = {
                str => $where_str,
                args => \@where_args,
            };
        }
    } else {
        my @columns = GetColumns('items');
        push @columns, GetColumns('biblio');
        push @columns, GetColumns('biblioitems');
        my @operators = qw(= != > < >= <= like);
        my $field = $filter->{field};
        if ( (0 < grep /^$field$/, @columns) or (substr($field, 0, 5) eq 'marc:') ) {
            my $op = $filter->{operator};
            my $query = $filter->{query};

            if (!$op or (0 == grep /^$op$/, @operators)) {
                $op = '='; # default operator
            }

            my $column;
            if ($field =~ /^marc:(\d{3})(?:\$(\w))?$/) {
                my $marcfield = $1;
                my $marcsubfield = $2;
                my $xpath;
                if ($marcfield < 10) {
                    $xpath = "//record/controlfield[\@tag=\"$marcfield\"]";
                } else {
                    $xpath = "//record/datafield[\@tag=\"$marcfield\"]/subfield[\@code=\"$marcsubfield\"]";
                }
                $column = "ExtractValue(marcxml, '$xpath')";
            } else {
                $column = $field;
            }

            if (ref $query eq 'ARRAY') {
                if ($op eq '=') {
                    $op = 'IN';
                } elsif ($op eq '!=') {
                    $op = 'NOT IN';
                }
                $where_fragment = {
                    str => "$column $op (" . join (',', ('?') x @$query) . ")",
                    args => $query,
                };
            } else {
                $where_fragment = {
                    str => "$column $op ?",
                    args => [ $query ],
                };
            }
        }
    }

    return $where_fragment;
}

=head2 SearchItems

    my ($items, $total) = SearchItemsByField($filters, $params);

Perform a search among items
For instance you can search all items with a specific stocknumber like this:

$filters is a reference to an array of filters, where each filter is a hash with
the following keys:

=over 2

=item * field: the name of a SQL column in table items

=item * query: the value to search in this column

=item * operator: comparison operator. Can be one of = != > < >= <= like

=back

A logical AND is used to combine filters.

$params is a reference to a hash that can contain the following parameters:

=over 2

=item * rows: Number of items to return. 0 returns everything (default: 0)

=item * page: Page to return (return items from (page-1)*rows to (page*rows)-1)
               (default: 1)

=item * sortby: A SQL column name in items table to sort on

=item * sortorder: 'ASC' or 'DESC'

=back

=cut

sub SearchItems {
    my ($filter, $params) = @_;

    $filter //= {};
    $params //= {};
    return unless ref $filter eq 'HASH';
    return unless ref $params eq 'HASH';

    # Default parameters
    $params->{rows} ||= 0;
    $params->{page} ||= 1;
    $params->{sortby} ||= 'itemnumber';
    $params->{sortorder} ||= 'ASC';

    my ($where_str, @where_args);
    my $where_fragment = _SearchItems_build_where_fragment($filter);
    if ($where_fragment) {
        $where_str = $where_fragment->{str};
        @where_args = @{ $where_fragment->{args} };
    }

    my $dbh = C4::Context->dbh;
    my $query = q{
        SELECT SQL_CALC_FOUND_ROWS items.*
        FROM items
          LEFT JOIN biblio ON biblio.biblionumber = items.biblionumber
          LEFT JOIN biblioitems ON biblioitems.biblioitemnumber = items.biblioitemnumber
    };
    if (defined $where_str and $where_str ne '') {
        $query .= qq{ WHERE $where_str };
    }

    my @columns = GetColumns('items');
    push @columns, GetColumns('biblio');
    push @columns, GetColumns('biblioitems');
    my $sortby = (0 < grep {$params->{sortby} eq $_} @columns)
        ? $params->{sortby} : 'itemnumber';
    my $sortorder = (uc($params->{sortorder}) eq 'ASC') ? 'ASC' : 'DESC';
    $query .= qq{ ORDER BY $sortby $sortorder };

    my $rows = $params->{rows};
    my @limit_args;
    if ($rows > 0) {
        my $offset = $rows * ($params->{page}-1);
        $query .= qq { LIMIT ?, ? };
        push @limit_args, $offset, $rows;
    }

    my $sth = $dbh->prepare($query);
    my $rv = $sth->execute(@where_args, @limit_args);

    return unless ($rv);
    my ($total_rows) = $dbh->selectrow_array(q{ SELECT FOUND_ROWS() });

    return ($sth->fetchall_arrayref({}), $total_rows);
}






	UpdateInTable
	GetPrimaryKeys
        clear_columns_cache
    GetColumns
);
	%EXPORT_TAGS = ( all =>[qw( InsertInTable DeleteInTable SearchInTable UpdateInTable GetPrimaryKeys)]
				);

    return $hashref->{$tablename};
}

=head2 GetColumns

    my @columns = GetColumns($tablename);

Given a tablename, returns an array of columns names.

=cut

sub GetColumns {
    my ($tablename) = @_;

    return unless $tablename;
    return unless $tablename =~ /^[a-zA-Z0-9_]+$/;

    # Get the database handle.
    my $dbh = C4::Context->dbh;

    # Pure ANSI SQL goodness.
    my $sql = "SELECT * FROM $tablename WHERE 1=0;";

    # Run the SQL statement to load STH's readonly properties.
    my $sth = $dbh->prepare($sql);
    my $rv = $sth->execute();

    my @data;
    if ($rv) {
        @data = @{$sth->{NAME}};
    }

    return @data;
}

=head2 _filter_columns

=over 4




package Koha::Item::Search::Field;

use Modern::Perl;
use base qw( Exporter );

our @EXPORT_OK = qw(
    AddItemSearchField
    ModItemSearchField
    DelItemSearchField
    GetItemSearchField
    GetItemSearchFields
);

use C4::Context;

sub AddItemSearchField {
    my ($field) = @_;

    my ( $name, $label, $tagfield, $tagsubfield, $av_category ) =
      @$field{qw(name label tagfield tagsubfield authorised_values_category)};

    my $dbh = C4::Context->dbh;
    my $query = q{
        INSERT INTO items_search_fields (name, label, tagfield, tagsubfield, authorised_values_category)
        VALUES (?, ?, ?, ?, ?)
    };
    my $sth = $dbh->prepare($query);
    my $rv = $sth->execute($name, $label, $tagfield, $tagsubfield, $av_category);

    return ($rv) ? $field : undef;
}

sub ModItemSearchField {
    my ($field) = @_;

    my ( $name, $label, $tagfield, $tagsubfield, $av_category ) =
      @$field{qw(name label tagfield tagsubfield authorised_values_category)};

    my $dbh = C4::Context->dbh;
    my $query = q{
        UPDATE items_search_fields
        SET label = ?,
            tagfield = ?,
            tagsubfield = ?,
            authorised_values_category = ?
        WHERE name = ?
    };
    my $sth = $dbh->prepare($query);
    my $rv = $sth->execute($label, $tagfield, $tagsubfield, $av_category, $name);

    return ($rv) ? $field : undef;
}

sub DelItemSearchField {
    my ($name) = @_;

    my $dbh = C4::Context->dbh;
    my $query = q{
        DELETE FROM items_search_fields
        WHERE name = ?
    };
    my $sth = $dbh->prepare($query);
    my $rv = $sth->execute($name);

    my $is_deleted = $rv ? int($rv) : 0;
    if (!$is_deleted) {
        warn "DelItemSearchField: Field '$name' doesn't exist";
    }

    return $is_deleted;
}

sub GetItemSearchField {
    my ($name) = @_;

    my $dbh = C4::Context->dbh;
    my $query = q{
        SELECT * FROM items_search_fields
        WHERE name = ?
    };
    my $sth = $dbh->prepare($query);
    my $rv = $sth->execute($name);

    my $field;
    if ($rv) {
        $field = $sth->fetchrow_hashref;
    }

    return $field;
}

sub GetItemSearchFields {
    my $dbh = C4::Context->dbh;
    my $query = q{
        SELECT * FROM items_search_fields
    };
    my $sth = $dbh->prepare($query);
    my $rv = $sth->execute();

    my @fields;
    if ($rv) {
        my $fields = $sth->fetchall_arrayref( {} );
        @fields = @$fields;
    }

    return @fields;
}

Lines 43-49 my @value = $input->param('value[]'); Link Here

(-)a/acqui/check_uniqueness.pl (-1 / +1 lines)
43	my $r = {};	43	my $r = {};
44	my $i = 0;	44	my $i = 0;
45	for ( my $i=0; $i<@field; $i++ ) {	45	for ( my $i=0; $i<@field; $i++ ) {
46	my $items = C4::Items::SearchItems($field[$i], $value[$i]);	46	my $items = C4::Items::SearchItemsByField($field[$i], $value[$i]);
47		47
48	if ( @$items ) {	48	if ( @$items ) {
49	push @{ $r->{$field[$i]} }, $value[$i];	49	push @{ $r->{$field[$i]} }, $value[$i];




#!/usr/bin/perl
# Copyright 2013 BibLibre
#
# This file is part of Koha
#
# Koha is free software; you can redistribute it and/or modify it under the
# terms of the GNU General Public License as published by the Free Software
# Foundation; either version 3 of the License, or (at your option) any later
# version.
#
# Koha is distributed in the hope that it will be useful, but WITHOUT ANY
# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
# A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License along
# with Koha; if not, write to the Free Software Foundation, Inc.,
# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.

use Modern::Perl;
use CGI;

use C4::Auth;
use C4::Output;
use C4::Koha;

use Koha::Item::Search::Field qw(GetItemSearchField ModItemSearchField);

my $cgi = new CGI;

my ($template, $borrowernumber, $cookie) = get_template_and_user({
    template_name => 'admin/items_search_field.tt',
    query => $cgi,
    type => 'intranet',
    authnotrequired => 0,
    flagsrequired   => { catalogue => 1 },
});

my $op = $cgi->param('op') || '';
my $name = $cgi->param('name');

if ($op eq 'mod') {
    my %vars = $cgi->Vars;
    my $field = { name => $name };
    my @params = qw(label tagfield tagsubfield authorised_values_category);
    @$field{@params} = @vars{@params};
    if ( $field->{authorised_values_category} eq '' ) {
        $field->{authorised_values_category} = undef;
    }
    $field = ModItemSearchField($field);
    my $updated = ($field) ? 1 : 0;
    print $cgi->redirect('/cgi-bin/koha/admin/items_search_fields.pl?updated=' . $updated);
    exit;
}

my $field = GetItemSearchField($name);
my $authorised_values_categories = C4::Koha::GetAuthorisedValueCategories();

$template->param(
    field => $field,
    authorised_values_categories => $authorised_values_categories,
);

output_html_with_http_headers $cgi, $cookie, $template->output;




#!/usr/bin/perl
# Copyright 2013 BibLibre
#
# This file is part of Koha
#
# Koha is free software; you can redistribute it and/or modify it under the
# terms of the GNU General Public License as published by the Free Software
# Foundation; either version 3 of the License, or (at your option) any later
# version.
#
# Koha is distributed in the hope that it will be useful, but WITHOUT ANY
# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
# A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License along
# with Koha; if not, write to the Free Software Foundation, Inc.,
# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.

use Modern::Perl;
use CGI;

use C4::Auth;
use C4::Output;
use C4::Koha;

use Koha::Item::Search::Field qw(AddItemSearchField GetItemSearchFields DelItemSearchField);

my $cgi = new CGI;

my ($template, $borrowernumber, $cookie) = get_template_and_user({
    template_name => 'admin/items_search_fields.tt',
    query => $cgi,
    type => 'intranet',
    authnotrequired => 0,
    flagsrequired   => { catalogue => 1 },
});

my $op = $cgi->param('op') || '';

if ($op eq 'add') {
    my %vars = $cgi->Vars;
    my $field;
    my @params = qw(name label tagfield tagsubfield authorised_values_category);
    @$field{@params} = @vars{@params};
    if ( $field->{authorised_values_category} eq '' ) {
        $field->{authorised_values_category} = undef;
    }
    $field = AddItemSearchField($field);
    if ($field) {
        $template->param(field_added => $field);
    } else {
        $template->param(field_not_added => 1);
    }
} elsif ($op eq 'del') {
    my $name = $cgi->param('name');
    my $rv = DelItemSearchField($name);
    if ($rv) {
        $template->param(field_deleted => 1);
    } else {
        $template->param(field_not_deleted => 1);
    }
} else {
    my $updated = $cgi->param('updated');
    if (defined $updated) {
        if ($updated) {
            $template->param(field_updated => 1);
        } else {
            $template->param(field_not_updated => 1);
        }
    }
}

my @fields = GetItemSearchFields();
my $authorised_values_categories = C4::Koha::GetAuthorisedValueCategories();

$template->param(
    fields => \@fields,
    authorised_values_categories => $authorised_values_categories,
);

output_html_with_http_headers $cgi, $cookie, $template->output;




#!/usr/bin/perl
# Copyright 2013 BibLibre
#
# This file is part of Koha
#
# Koha is free software; you can redistribute it and/or modify it under the
# terms of the GNU General Public License as published by the Free Software
# Foundation; either version 3 of the License, or (at your option) any later
# version.
#
# Koha is distributed in the hope that it will be useful, but WITHOUT ANY
# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
# A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License along
# with Koha; if not, write to the Free Software Foundation, Inc.,
# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.

use Modern::Perl;
use CGI;

use JSON;

use C4::Auth;
use C4::Output;
use C4::Items;
use C4::Biblio;
use C4::Branch;
use C4::Koha;
use C4::ItemType;

use Koha::Item::Search::Field qw(GetItemSearchFields);

my $cgi = new CGI;
my %params = $cgi->Vars;

my $format = $cgi->param('format');
my ($template_name, $content_type);
if (defined $format and $format eq 'json') {
    $template_name = 'catalogue/itemsearch.json.tt';
    $content_type = 'json';

    # Map DataTables parameters with 'regular' parameters
    $cgi->param('rows', $cgi->param('iDisplayLength'));
    $cgi->param('page', ($cgi->param('iDisplayStart') / $cgi->param('iDisplayLength')) + 1);
    my @columns = split /,/, $cgi->param('sColumns');
    $cgi->param('sortby', $columns[ $cgi->param('iSortCol_0') ]);
    $cgi->param('sortorder', $cgi->param('sSortDir_0'));

    my @f = $cgi->param('f');
    my @q = $cgi->param('q');
    push @q, '' if @q == 0;
    my @op = $cgi->param('op');
    my @c = $cgi->param('c');
    foreach my $i (0 .. ($cgi->param('iColumns') - 1)) {
        my $sSearch = $cgi->param("sSearch_$i");
        if ($sSearch) {
            my @words = split /\s+/, $sSearch;
            foreach my $word (@words) {
                push @f, $columns[$i];
                push @q, "%$word%";
                push @op, 'like';
                push @c, 'and';
            }
        }
    }
    $cgi->param('f', @f);
    $cgi->param('q', @q);
    $cgi->param('op', @op);
    $cgi->param('c', @c);
} elsif (defined $format and $format eq 'csv') {
    $template_name = 'catalogue/itemsearch.csv.tt';

    # Retrieve all results
    $cgi->param('rows', 0);
} else {
    $format = 'html';
    $template_name = 'catalogue/itemsearch.tt';
    $content_type = 'html';
}

my ($template, $borrowernumber, $cookie) = get_template_and_user({
    template_name => $template_name,
    query => $cgi,
    type => 'intranet',
    authnotrequired => 0,
    flagsrequired   => { catalogue => 1 },
});

my $notforloan_avcode = GetAuthValCode('items.notforloan');
my $notforloan_values = GetAuthorisedValues($notforloan_avcode);

if (scalar keys %params > 0) {
    # Parameters given, it's a search

    my $filter = {
        conjunction => 'AND',
        filters => [],
    };

    foreach my $p (qw(homebranch location itype ccode issues datelastborrowed)) {
        if (my @q = $cgi->param($p)) {
            if ($q[0] ne '') {
                my $f = {
                    field => $p,
                    query => \@q,
                };
                if (my $op = $cgi->param($p . '_op')) {
                    $f->{operator} = $op;
                }
                push @{ $filter->{filters} }, $f;
            }
        }
    }

    my @c = $cgi->param('c');
    my @fields = $cgi->param('f');
    my @q = $cgi->param('q');
    my @op = $cgi->param('op');

    my $f;
    for (my $i = 0; $i < @fields; $i++) {
        my $field = $fields[$i];
        my $q = shift @q;
        my $op = shift @op;
        if (defined $q and $q ne '') {
            if ($i == 0) {
                $f = {
                    field => $field,
                    query => $q,
                    operator => $op,
                };
            } else {
                my $c = shift @c;
                $f = {
                    conjunction => $c,
                    filters => [
                        $f, {
                            field => $field,
                            query => $q,
                            operator => $op,
                        }
                    ],
                };
            }
        }
    }
    push @{ $filter->{filters} }, $f;

    # Yes/No parameters
    foreach my $p (qw(damaged itemlost)) {
        my $v = $cgi->param($p) // '';
        my $f = {
            field => $p,
            query => 0,
        };
        if ($v eq 'yes') {
            $f->{operator} = '!=';
            push @{ $filter->{filters} }, $f;
        } elsif ($v eq 'no') {
            $f->{operator} = '=';
            push @{ $filter->{filters} }, $f;
        }
    }

    if (my $itemcallnumber_from = $cgi->param('itemcallnumber_from')) {
        push @{ $filter->{filters} }, {
            field => 'itemcallnumber',
            query => $itemcallnumber_from,
            operator => '>=',
        };
    }
    if (my $itemcallnumber_to = $cgi->param('itemcallnumber_to')) {
        push @{ $filter->{filters} }, {
            field => 'itemcallnumber',
            query => $itemcallnumber_to,
            operator => '<=',
        };
    }

    my $search_params = {
        rows => $cgi->param('rows') // 20,
        page => $cgi->param('page') || 1,
        sortby => $cgi->param('sortby') || 'itemnumber',
        sortorder => $cgi->param('sortorder') || 'asc',
    };

    my ($results, $total_rows) = SearchItems($filter, $search_params);
    if ($results) {
        # Get notforloan labels
        my $notforloan_map = {};
        foreach my $nfl_value (@$notforloan_values) {
            $notforloan_map->{$nfl_value->{authorised_value}} = $nfl_value->{lib};
        }

        foreach my $item (@$results) {
            $item->{biblio} = GetBiblio($item->{biblionumber});
            ($item->{biblioitem}) = GetBiblioItemByBiblioNumber($item->{biblionumber});
            $item->{status} = $notforloan_map->{$item->{notforloan}};
        }
    }

    $template->param(
        filter => $filter,
        search_params => $search_params,
        results => $results,
        total_rows => $total_rows,
        search_done => 1,
    );

    if ($format eq 'html') {
        # Build pagination bar
        my $url = $cgi->url(-absolute => 1);
        my @params;
        foreach my $p (keys %params) {
            my @v = $cgi->param($p);
            push @params, map { "$p=" . $_ } @v;
        }
        $url .= '?' . join ('&', @params);
        my $nb_pages = 1 + int($total_rows / $search_params->{rows});
        my $current_page = $search_params->{page};
        my $pagination_bar = pagination_bar($url, $nb_pages, $current_page, 'page');

        $template->param(pagination_bar => $pagination_bar);
    }
}

if ($format eq 'html') {
    # Retrieve data required for the form.

    my $branches = GetBranches();
    my @branches;
    foreach my $branchcode (keys %$branches) {
        push @branches, {
            value => $branchcode,
            label => $branches->{$branchcode}->{branchname},
        };
    }
    my $locations = GetAuthorisedValues('LOC');
    my @locations;
    foreach my $location (@$locations) {
        push @locations, {
            value => $location->{authorised_value},
            label => $location->{lib},
        };
    }
    my @itemtypes = C4::ItemType->all();
    foreach my $itemtype (@itemtypes) {
        $itemtype->{value} = $itemtype->{itemtype};
        $itemtype->{label} = $itemtype->{description};
    }
    my $ccode_avcode = GetAuthValCode('items.ccode') || 'CCODE';
    my $ccodes = GetAuthorisedValues($ccode_avcode);
    my @ccodes;
    foreach my $ccode (@$ccodes) {
        push @ccodes, {
            value => $ccode->{authorised_value},
            label => $ccode->{lib},
        };
    }

    my @notforloans;
    foreach my $value (@$notforloan_values) {
        push @notforloans, {
            value => $value->{authorised_value},
            label => $value->{lib},
        };
    }

    my @items_search_fields = GetItemSearchFields();

    my $authorised_values = {};
    foreach my $field (@items_search_fields) {
        if (my $category = ($field->{authorised_values_category})) {
            $authorised_values->{$category} = GetAuthorisedValues($category);
        }
    }

    $template->param(
        branches => \@branches,
        locations => \@locations,
        itemtypes => \@itemtypes,
        ccodes => \@ccodes,
        notforloans => \@notforloans,
        items_search_fields => \@items_search_fields,
        authorised_values_json => to_json($authorised_values),
    );
}

if ($format eq 'csv') {
    print $cgi->header({
        type => 'text/csv',
        attachment => 'items.csv',
    });
    print $template->output;
} else {
    output_with_http_headers $cgi, $cookie, $template->output, $content_type;
}




  CONSTRAINT `mmta_ibfk_1` FOREIGN KEY (`template_id`) REFERENCES `marc_modification_templates` (`template_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

--
-- Table structure for table 'items_search_fields'
--

DROP TABLE IF EXISTS items_search_fields;
CREATE TABLE items_search_fields (
  name VARCHAR(255) NOT NULL,
  label VARCHAR(255) NOT NULL,
  tagfield CHAR(3) NOT NULL,
  tagsubfield CHAR(1) NULL DEFAULT NULL,
  authorised_values_category VARCHAR(16) NULL DEFAULT NULL,
  PRIMARY KEY(name),
  CONSTRAINT items_search_fields_authorised_values_category
    FOREIGN KEY (authorised_values_category) REFERENCES authorised_values (category)
    ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;




   SetVersion ($DBversion);
}

$DBversion = "XXX";
if ( CheckVersion($DBversion) ) {
    $dbh->do(q{
        CREATE TABLE IF NOT EXISTS items_search_fields (
          name VARCHAR(255) NOT NULL,
          label VARCHAR(255) NOT NULL,
          tagfield CHAR(3) NOT NULL,
          tagsubfield CHAR(1) NULL DEFAULT NULL,
          authorised_values_category VARCHAR(16) NULL DEFAULT NULL,
          PRIMARY KEY(name),
          CONSTRAINT items_search_fields_authorised_values_category
            FOREIGN KEY (authorised_values_category) REFERENCES authorised_values (category)
            ON DELETE SET NULL ON UPDATE CASCADE
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    });
    print "Upgrade to $DBversion done (Bug XXXXX: Add items_search_fields table)\n";
    SetVersion($DBversion);
}


=head1 FUNCTIONS

=head2 TableExists($table)




.form-field {
  margin: 5px 0;
}

.form-field > * {
  vertical-align: middle;
}

.form-field-label {
  display: inline-block;
  text-align: right;
  width: 10em;
}

.form-field-conjunction[disabled] {
  visibility: hidden;
}

.form-field-radio > * {
  vertical-align: middle;
}

.form-actions {
  margin-top: 20px;
}

th.active {
  padding-right: 21px;
  background-repeat: no-repeat;
  background-position: 100% 50%;
}

th.sort-asc {
  background-image: url('../../img/asc.gif');
}

th.sort-desc {
  background-image: url('../../img/desc.gif');
}

th select {
  width: 100%;
  font-weight: normal;
}




<ul>
  <li>
    <label for="name">Name</label>
    [% IF field %]
      <input type="text" name="name" value="[% field.name %]" disabled="disabled">
      <input type="hidden" name="name" value="[% field.name %]">
    [% ELSE %]
      <input type="text" name="name" />
    [% END %]
  </li>
  <li>
    <label for="label">Label</label>
    [% IF field %]
      <input type="text" name="label" value="[% field.label %]" />
    [% ELSE %]
      <input type="text" name="label" />
    [% END %]
  </li>
  <li>
    <label for="tagfield">MARC field</label>
    <select name="tagfield">
      [% FOREACH tagfield IN ['001'..'999'] %]
        [% IF field && field.tagfield == tagfield %]
          <option value="[% tagfield %]" selected="selected">[% tagfield %]</option>
        [% ELSE %]
          <option value="[% tagfield %]">[% tagfield %]</option>
        [% END %]
      [% END %]
    </select>
  </li>
  <li>
    <label for="tagsubfield">MARC subfield</label>
    <select name="tagsubfield">
      [% codes = [''] %]
      [% codes = codes.merge([0..9], ['a'..'z']) %]
      [% FOREACH tagsubfield IN codes %]
        [% IF field && field.tagsubfield == tagsubfield %]
          <option value="[% tagsubfield %]" selected="selected">[% tagsubfield %]</option>
        [% ELSE %]
          <option value="[% tagsubfield %]">[% tagsubfield %]</option>
        [% END %]
      [% END %]
    </select>
  </li>
  <li>
    <label for="authorised_values_category">Authorised values category</label>
    <select name="authorised_values_category">
      <option value="">- None -</option>
      [% FOREACH category IN authorised_values_categories %]
        [% IF field && field.authorised_values_category == category %]
          <option value="[% category %]" selected="selected">[% category %]</option>
        [% ELSE %]
          <option value="[% category %]">[% category %]</option>
        [% END %]
      [% END %]
    </select>
  </li>
</ul>

Lines 46-51 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/includes/admin-menu.inc (+1 lines)
46	<li><a href="/cgi-bin/koha/admin/classsources.pl">Classification sources</a></li>	46	<li><a href="/cgi-bin/koha/admin/classsources.pl">Classification sources</a></li>
47	<li><a href="/cgi-bin/koha/admin/matching-rules.pl">Record matching rules</a></li>	47	<li><a href="/cgi-bin/koha/admin/matching-rules.pl">Record matching rules</a></li>
48	<li><a href="/cgi-bin/koha/admin/oai_sets.pl">OAI sets configuration</a></li>	48	<li><a href="/cgi-bin/koha/admin/oai_sets.pl">OAI sets configuration</a></li>
		49	<li><a href="/cgi-bin/koha/admin/items_search_fields.pl">Items search fields</a></li>
49	</ul>	50	</ul>
50		51
51	<h5>Acquisition parameters</h5>	52	<h5>Acquisition parameters</h5>

Line 0 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/includes/catalogue/itemsearch_item.csv.inc (+4 lines)
	1	[%- USE Branches -%]
	2	[%- biblio = item.biblio -%]
	3	[%- biblioitem = item.biblioitem -%]
	4	"[% biblio.title \|html %] by [% biblio.author \|html %]", "[% biblioitem.publicationyear \|html %]", "[% biblioitem.publishercode \|html %]", "[% biblioitem.collectiontitle \|html %]", "[% item.barcode \|html %]", "[% item.itemcallnumber \|html %]", "[% Branches.GetName(item.homebranch) \|html %]", "[% Branches.GetName(item.holdingbranch) \|html %]", "[% item.location \|html %]", "[% item.stocknumber \|html %]", "[% item.status \|html %]", "[% (item.issues \|\| 0) \|html %]"




[%- USE Branches -%]
[% biblio = item.biblio %]
[% biblioitem = item.biblioitem %]
<tr>
  <td>
    <a href="/cgi-bin/koha/catalogue/detail.pl?biblionumber=[% biblio.biblionumber %]" title="Go to record detail page">[% biblio.title %]</a>
    by [% biblio.author %]
  </td>
  <td>[% biblioitem.publicationyear %]</td>
  <td>[% biblioitem.publishercode %]</td>
  <td>[% biblioitem.collectiontitle %]</td>
  <td>
    <a href="/cgi-bin/koha/catalogue/moredetail.pl?biblionumber=[% biblio.biblionumber %]#item[% item.itemnumber %]" title="Go to item details">[% item.barcode %]</a>
  </td>
  <td>[% item.itemcallnumber %]</td>
  <td>[% Branches.GetName(item.homebranch) %]</td>
  <td>[% Branches.GetName(item.holdingbranch) %]</td>
  <td>[% item.location %]</td>
  <td>[% item.stocknumber %]</td>
  <td>[% item.status %]</td>
  <td>[% item.issues || 0 %]</td>
  <td><a href="/cgi-bin/koha/cataloguing/additem.pl?op=edititem&biblionumber=[% item.biblionumber %]&itemnumber=[% item.itemnumber %]">Modify</a></td>
</tr>




[%- USE Branches -%]
[%- biblio = item.biblio -%]
[%- biblioitem = item.biblioitem -%]
[
  "<a href='/cgi-bin/koha/catalogue/detail.pl?biblionumber=[% biblio.biblionumber %]' title='Go to record detail page'>[% biblio.title |html %]</a> by [% biblio.author |html %]",
  "[% biblioitem.publicationyear |html %]",
  "[% biblioitem.publishercode |html %]",
  "[% biblioitem.collectiontitle |html %]",
  "<a href='/cgi-bin/koha/catalogue/moredetail.pl?biblionumber=[% biblio.biblionumber %]#item[% item.itemnumber %]' title='Go to item details'>[% item.barcode |html %]</a>",
  "[% item.itemcallnumber |html %]",
  "[% Branches.GetName(item.homebranch) |html %]",
  "[% Branches.GetName(item.holdingbranch) |html %]",
  "[% item.location |html %]",
  "[% item.stocknumber |html %]",
  "[% item.status |html %]",
  "[% (item.issues || 0) |html %]",
  "<a href='/cgi-bin/koha/cataloguing/additem.pl?op=edititem&biblionumber=[% item.biblionumber %]&itemnumber=[% item.itemnumber %]'>Modify</a>"
]




[% names = CGI.param() %]
[% params = [] %]
[% FOREACH name IN names %]
  [% IF name != 'sortby' AND name != 'sortorder' %]
    [% params.push(name _ "=" _ CGI.param(name)) %]
  [% END %]
[% END %]
[% base_url = "/cgi-bin/koha/catalogue/itemsearch.pl?" _ params.join('&') %]

[% BLOCK itemsearch_header %]
  [% sortorder = 'asc' %]
  [% classes = [] %]
  [% IF CGI.param('sortby') == name %]
    [% classes.push('active') %]
    [% classes.push('sort-' _ CGI.param('sortorder')) %]
    [% IF CGI.param('sortorder') == 'asc' %]
      [% sortorder = 'desc' %]
    [% END %]
  [% END %]
  [% url = base_url _ '&sortby=' _ name _ '&sortorder=' _ sortorder %]
  <th class="[% classes.join(' ') %]">
    <a href="[% url %]" title="Sort on [% label %] ([% sortorder %])">[% text %]</a>
  </th>
[% END %]

<table>
  <thead>
    <tr>
      [% INCLUDE itemsearch_header name='title' label='title' text='Bibliographic reference' %]
      [% INCLUDE itemsearch_header name='publicationyear' label='publication date' text='Publication date' %]
      [% INCLUDE itemsearch_header name='publishercode' label='publisher' text='Publisher' %]
      [% INCLUDE itemsearch_header name='collectiontitle' label='collection' text='Collection' %]
      [% INCLUDE itemsearch_header name='barcode' label='barcode' text='Barcode' %]
      [% INCLUDE itemsearch_header name='itemcallnumber' label='callnumber' text='Callnumber' %]
      [% INCLUDE itemsearch_header name='homebranch' label='home branch' text='Home branch' %]
      [% INCLUDE itemsearch_header name='holdingbranch' label='holding branch' text='Holding branch' %]
      [% INCLUDE itemsearch_header name='location' label='location' text='Location' %]
      [% INCLUDE itemsearch_header name='stocknumber' label='stock number' text='Stock number' %]
      [% INCLUDE itemsearch_header name='notforloan' label='status' text='Status' %]
      [% INCLUDE itemsearch_header name='issues' label='issues' text='Issues' %]
      <th></th>
    </tr>
  </thead>
  <tbody>
    [% FOREACH item IN items %]
      [% INCLUDE 'catalogue/itemsearch_item.inc' item = item %]
    [% END %]
  </tbody>
</table>

Lines 80-85 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/admin-home.tt (+2 lines)
80	<dd>Manage rules for automatically matching MARC records during record imports.</dd>	80	<dd>Manage rules for automatically matching MARC records during record imports.</dd>
81	<dt><a href="/cgi-bin/koha/admin/oai_sets.pl">OAI sets configuration</a></dt>	81	<dt><a href="/cgi-bin/koha/admin/oai_sets.pl">OAI sets configuration</a></dt>
82	<dd>Manage OAI Sets</dd>	82	<dd>Manage OAI Sets</dd>
		83	<dt><a href="/cgi-bin/koha/admin/items_search_fields.pl">Items search fields</a></dt>
		84	<dd>Manage custom fields for items search</dd>
83	[% IF ( SearchEngine != 'Zebra' ) %]	85	[% IF ( SearchEngine != 'Zebra' ) %]
84	<dt><a href="/cgi-bin/koha/admin/searchengine/solr/indexes.pl">Search engine configuration</a></dt>	86	<dt><a href="/cgi-bin/koha/admin/searchengine/solr/indexes.pl">Search engine configuration</a></dt>
85	<dd>Manage indexes, facets, and their mappings to MARC fields and subfields.</dd>	87	<dd>Manage indexes, facets, and their mappings to MARC fields and subfields.</dd>




[% INCLUDE 'doc-head-open.inc' %]
  <title>Koha &rsaquo; Administration &rsaquo; Items search fields</title>
  [% INCLUDE 'doc-head-close.inc' %]
</head>
<body id="admin_itemssearchfields" class="admin">
  [% INCLUDE 'header.inc' %]
  [% INCLUDE 'cat-search.inc' %]
  <div id="breadcrumbs">
    <a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo;
    <a href="/cgi-bin/koha/admin/admin-home.pl">Administration</a> &rsaquo;
    <a href="/cgi-bin/koha/admin/items_search_fields.pl">Items search fields</a> &rsaquo;
    [% field.name %]
  </div>

  <div id="doc3" class="yui-t2">
    <div id="bd">
      <div id="yui-main">
        <div class="yui-b">
          <h1>Items search field: [% field.label %]</h1>

          <form action="" method="POST">
            <fieldset class="rows">
              <legend>Edit field</legend>
              [% INCLUDE 'admin-items-search-field-form.inc' field=field %]
              <div>
                <input type="hidden" name="op" value="mod" />
              </div>
              <fieldset class="action">
                <input type="submit" value="Update" />
              </fieldset>
            </fieldset>
          </form>
          <a href="/cgi-bin/koha/admin/items_search_fields.pl">Return to items search fields overview page</a>
        </div>
      </div>
      <div class="yui-b">
        [% INCLUDE 'admin-menu.inc' %]
      </div>
    </div>

    [% INCLUDE 'intranet-bottom.inc' %]




[% INCLUDE 'doc-head-open.inc' %]
  <title>Koha &rsaquo; Administration &rsaquo; Items search fields</title>
  [% INCLUDE 'doc-head-close.inc' %]
</head>
<body id="admin_itemssearchfields" class="admin">
  [% INCLUDE 'header.inc' %]
  [% INCLUDE 'cat-search.inc' %]
  <div id="breadcrumbs">
    <a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo;
    <a href="/cgi-bin/koha/admin/admin-home.pl">Administration</a> &rsaquo;
    Items search fields
  </div>

  <div id="doc3" class="yui-t2">
    <div id="bd">
      <div id="yui-main">
        <div class="yui-b">
          [% IF field_added %]
            <div class="dialog">
              Field successfully added: [% field_added.label %]
            </div>
          [% ELSIF field_not_added %]
            <div class="alert">
              <p>Failed to add field. Please check if the field name doesn't already exist.</p>
              <p>Check logs for more details.</p>
            </div>
          [% ELSIF field_deleted %]
            <div class="dialog">
              Field successfully deleted.
            </div>
          [% ELSIF field_not_deleted %]
            <div class="alert">
              <p>Failed to delete field.</p>
              <p>Check logs for more details.</p>
            </div>
          [% ELSIF field_updated %]
            <div class="dialog">
              Field successfully updated: [% field_updated.label %]
            </div>
          [% ELSIF field_not_updated %]
            <div class="alert">
              <p>Failed to update field.</p>
              <p>Check logs for more details.</p>
            </div>
          [% END %]
          <h1>Items search fields</h1>
          [% IF fields.size %]
            <table>
              <thead>
                <tr>
                  <th>Name</th>
                  <th>Label</th>
                  <th>MARC field</th>
                  <th>MARC subfield</th>
                  <th>Authorised values category</th>
                  <th>Operations</th>
                </tr>
              </thead>
              <tbody>
                [% FOREACH field IN fields %]
                  <tr>
                    <td>[% field.name %]</td>
                    <td>[% field.label %]</td>
                    <td>[% field.tagfield %]</td>
                    <td>[% field.tagsubfield %]</td>
                    <td>[% field.authorised_values_category %]</td>
                    <td>
                      <a href="/cgi-bin/koha/admin/items_search_field.pl?name=[% field.name %]" title="Edit [% field.name %] field">Edit</a>
                      <a href="/cgi-bin/koha/admin/items_search_fields.pl?op=del&name=[% field.name %]" title="Delete [% field.name %] field">Delete</a>
                    </td>
                  </tr>
                [% END %]
              </tbody>
            </table>
          [% END %]
          <form action="" method="POST">
            <fieldset class="rows">
              <legend>Add a new field</legend>
              [% INCLUDE 'admin-items-search-field-form.inc' field=undef %]
              <div>
                <input type="hidden" name="op" value="add" />
              </div>
              <fieldset class="action">
                <input type="submit" value="Add this field" />
              </fieldset>
            </fieldset>
          </form>
        </div>
      </div>
      <div class="yui-b">
        [% INCLUDE 'admin-menu.inc' %]
      </div>
    </div>

    [% INCLUDE 'intranet-bottom.inc' %]

Lines 30-35 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/advsearch.tt (+1 lines)
30	<form action="search.pl" method="get">	30	<form action="search.pl" method="get">
31	<div id="advanced-search">	31	<div id="advanced-search">
32	<h1>Advanced search</h1>	32	<h1>Advanced search</h1>
		33	<a href="/cgi-bin/koha/catalogue/itemsearch.pl">Go to item search</a>
33		34
34	[% IF ( outer_servers_loop ) %]	35	[% IF ( outer_servers_loop ) %]
35	<!-- DATABASES -->	36	<!-- DATABASES -->

Line 0 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/itemsearch.csv.tt (+4 lines)
	1	Bibliographic reference, Publication Date, Publisher, Collection, Barcode, Callnumber, Home branch, Holding branch, Location, Stock number, Status, Issues
	2	[% FOREACH item IN results -%]
	3	[%- INCLUDE 'catalogue/itemsearch_item.csv.inc' item = item -%]
	4	[%- END -%]




[%- USE CGI -%]
{
  "sEcho": [% CGI.param('sEcho') %],
  "iTotalRecords": [% total_rows %],
  "iTotalDisplayRecords": [% total_rows %],
  "aaData": [
  [%- FOREACH item IN results -%]
    [%- INCLUDE 'catalogue/itemsearch_item.json.inc' item = item -%]
    [%- UNLESS loop.last %],[% END -%]
  [%- END -%]
  ]
}




[% USE CGI %]
[% USE JSON.Escape %]

[% BLOCK form_field_select %]
  <div class="form-field form-field-select">
    <label class="form-field-label" for="[% name %]">[% label %]</label>
    <select id="[% name %]_op" name="[% name %]_op">
      <option value="=">is</option>
      [% IF CGI.param(name _ '_op') == '!=' %]
        <option value="!=" selected="selected">is not</option>
      [% ELSE %]
        <option value="!=" >is not</option>
      [% END %]
    </select>
    [% values = CGI.param(name) %]
    <select id="[% name %]" name="[% name %]" multiple="multiple" size="[% options.size < 4 ? options.size + 1 : 4 %]">
      [% IF (values == '') %]
        <option value="" selected="selected">
      [% ELSE %]
        <option value="">
      [% END %]
        [% empty_option || "All" %]
      </option>
      [% FOREACH option IN options %]
        [% IF values.grep(option.value).size %]
          <option value="[% option.value %]" selected="selected">[% option.label %]</option>
        [% ELSE %]
          <option value="[% option.value %]">[% option.label %]</option>
        [% END %]
      [% END %]
    </select>
  </div>
[% END %]

[% BLOCK form_field_select_option %]
  [% IF params.f == value %]
    <option value="[% value %]" selected="selected">[% label %]</option>
  [% ELSE %]
    <option value="[% value %]">[% label %]</option>
  [% END %]
[% END %]

[% BLOCK form_field_select_text %]
  <div class="form-field form-field-select-text">
    [% IF params.exists('c') %]
      <select name="c" class="form-field-conjunction">
        <option value="and">AND</option>
        [% IF params.c == 'or' %]
          <option value="or" selected="selected">OR</option>
        [% ELSE %]
          <option value="or">OR</option>
        [% END %]
      </select>
    [% ELSE %]
      <select name="c" class="form-field-conjunction" disabled="disabled">
        <option value="and">AND</option>
        <option value="or">OR</option>
      </select>
    [% END %]
    <select name="f" class="form-field-column">
      [% INCLUDE form_field_select_option value='barcode' label='Barcode' %]
      [% INCLUDE form_field_select_option value='itemcallnumber' label='Callnumber' %]
      [% INCLUDE form_field_select_option value='stocknumber' label='Stock number' %]
      [% INCLUDE form_field_select_option value='title' label='Title' %]
      [% INCLUDE form_field_select_option value='author' label='Author' %]
      [% INCLUDE form_field_select_option value='publishercode' label='Publisher' %]
      [% INCLUDE form_field_select_option value='publicationdate' label='Publication date' %]
      [% INCLUDE form_field_select_option value='collectiontitle' label='Collection' %]
      [% INCLUDE form_field_select_option value='isbn' label='ISBN' %]
      [% INCLUDE form_field_select_option value='issn' label='ISSN' %]
      [% IF items_search_fields.size %]
        <optgroup label="Custom search fields">
          [% FOREACH field IN items_search_fields %]
            [% marcfield = field.tagfield %]
            [% IF field.tagsubfield %]
              [% marcfield = marcfield _ '$' _ field.tagsubfield %]
            [% END %]
            [% IF params.f == "marc:$marcfield" %]
              <option value="marc:[% marcfield %]" data-authorised-values-category="[% field.authorised_values_category %]" selected="selected">[% field.label %] ([% marcfield %])</option>
            [% ELSE %]
              <option value="marc:[% marcfield %]" data-authorised-values-category="[% field.authorised_values_category %]">[% field.label %] ([% marcfield %])</option>
            [% END %]
          [% END %]
        </optgroup>
      [% END %]
    </select>
    <input type="text" name="q" class="form-field-value" value="[% params.q %]" />
    <input type="hidden" name="op" value="like" />
  </div>
[% END %]

[% BLOCK form_field_select_text_block %]
  [% c = CGI.param('c').list %]
  [% f = CGI.param('f').list %]
  [% q = CGI.param('q').list %]
  [% op = CGI.param('op').list %]
  [% IF q.size %]
    [% size = q.size - 1 %]
    [% FOREACH i IN [0 .. size] %]
      [%
        params = {
          f => f.$i
          q = q.$i
          op = op.$i
        }
      %]
      [% IF i > 0 %]
        [% j = i - 1 %]
        [% params.c = c.$j %]
      [% END %]
      [% INCLUDE form_field_select_text params=params %]
    [% END %]
  [% ELSE %]
    [% INCLUDE form_field_select_text %]
  [% END %]
[% END %]

[% BLOCK form_field_radio_yes_no %]
  <div class="form-field">
    <label class="form-field-label" for="[% name %]">[% label %]:</label>
    <input type="radio" name="[% name %]" id="[% name %]_indifferent" value="" checked="checked"/>
    <label for="[% name %]_indifferent">Indifferent</label>
    <input type="radio" name="[% name %]" id="[% name %]_yes" value="yes" />
    <label for="[% name %]_yes">Yes</label>
    <input type="radio" name="[% name %]" id="[% name %]_no" value="no" />
    <label for="[% name %]_no">No</label>
  </div>
[% END %]

[%# Page starts here %]

[% INCLUDE 'doc-head-open.inc' %]
  <title>Koha &rsaquo; Catalog &rsaquo; Advanced search</title>
  [% INCLUDE 'doc-head-close.inc' %]
  [% INCLUDE 'datatables.inc' %]
  <script type="text/javascript" src="[% themelang %]/lib/jquery/plugins/jquery.dataTables.columnFilter.js"></script>
  <link rel="stylesheet" type="text/css" href="[% themelang %]/css/datatables.css" />
  <link rel="stylesheet" type="text/css" href="[% themelang %]/css/itemsearchform.css" />
  <script type="text/javascript">
    //<![CDATA[
    var authorised_values = [% authorised_values_json %];

    function loadAuthorisedValuesSelect(select) {
      var selected = select.find('option:selected');
      var category = selected.data('authorised-values-category');
      var form_field_value = select.siblings('.form-field-value');
      if (category && category in authorised_values) {
        var values = authorised_values[category];
        var html = '<select name="q" class="form-field-value">\n';
        for (i in values) {
          var value = values[i];
          html += '<option value="' + value.authorised_value + '">' + value.lib + '</option>\n';
        }
        html += '</select>\n';
        var new_form_field_value = $(html);
        new_form_field_value.val(form_field_value.val());
        form_field_value.replaceWith(new_form_field_value);
      } else {
        if (form_field_value.prop('tagName').toLowerCase() == 'select') {
          html = '<input name="q" type="text" class="form-field-value" />';
          var new_form_field_value = $(html);
          form_field_value.replaceWith(new_form_field_value);
        }
      }
    }

    function addNewField() {
      var form_field = $('div.form-field-select-text').last();
      var copy = form_field.clone(true);
      copy.find('input,select').not('[type="hidden"]').each(function() {
        $(this).val('');
      });
      copy.find('.form-field-conjunction').removeAttr('disabled');
      form_field.after(copy);
      copy.find('select.form-field-column').change();
    }

    function submitForm($form) {
      var tr = ''
        + '    <tr>'
        + '      <th>' + _("Bibliographic reference") + '</th>'
        + '      <th>' + _("Publication date") + '</th>'
        + '      <th>' + _("Publisher") + '</th>'
        + '      <th>' + _("Collection") + '</th>'
        + '      <th>' + _("Barcode") + '</th>'
        + '      <th>' + _("Callnumber") + '</th>'
        + '      <th>' + _("Home branch") + '</th>'
        + '      <th>' + _("Holding branch") + '</th>'
        + '      <th>' + _("Location") + '</th>'
        + '      <th>' + _("Stock number") + '</th>'
        + '      <th>' + _("Status") + '</th>'
        + '      <th>' + _("Issues") + '</th>'
        + '      <th></th>'
        + '    </tr>'
      var table = ''
        + '<table id="results">'
        + '  <thead>' + tr + tr + '</thead>'
        + '  <tbody></tbody>'
        + '</table>';
      $('#results-wrapper').empty().html(table);

      var params = [];
      $form.find('select,input[type="text"],input[type="hidden"]').not('[disabled]').each(function () {
        params.push({ 'name': $(this).attr('name'), 'value': $(this).val() });
      });
      $form.find('input[type="radio"]:checked').each(function() {
        params.push({ 'name': $(this).attr('name'), 'value': $(this).val() });
      });

      $('#results').dataTable($.extend(true, {}, dataTablesDefaults, {
        'bDestroy': true,
        'bServerSide': true,
        'sAjaxSource': '/cgi-bin/koha/catalogue/itemsearch.pl',
        'fnServerParams': function(aoData) {
          aoData.push( { 'name': 'format', 'value': 'json' } );
          for (i in params) {
            aoData.push(params[i]);
          }
        },
        'sDom': '<"top pager"ilp>t<"bottom pager"ip>',
        'aoColumns': [
          { 'sName': 'title' },
          { 'sName': 'publicationyear' },
          { 'sName': 'publishercode' },
          { 'sName': 'collectiontitle' },
          { 'sName': 'barcode' },
          { 'sName': 'itemcallnumber' },
          { 'sName': 'homebranch' },
          { 'sName': 'holdingbranch' },
          { 'sName': 'location' },
          { 'sName': 'stocknumber' },
          { 'sName': 'notforloan' },
          { 'sName': 'issues' },
          { 'sName': 'checkbox', 'bSortable': false }
        ]
      })).columnFilter({
        'sPlaceHolder': 'head:after',
        'aoColumns': [
          { 'type': 'text' },
          { 'type': 'text' },
          { 'type': 'text' },
          { 'type': 'text' },
          { 'type': 'text' },
          { 'type': 'text' },
          { 'type': 'select', 'values': [% branches.json %] },
          { 'type': 'select', 'values': [% branches.json %] },
          { 'type': 'select', 'values': [% locations.json %] },
          { 'type': 'text' },
          { 'type': 'select', 'values': [% notforloans.json %] },
          { 'type': 'text' },
          null
        ]
      });
    }

    function hideForm($form) {
      $form.hide();
      $('#editsearchlink').show();
    }

    $(document).ready(function () {
      // Add the "New field" link.
      var form_field = $('div.form-field-select-text').last()
      var button_field_new = $('<a href="#" class="button-field-new" title="Add a new field">New field</a>');
      button_field_new.click(function() {
        addNewField();
        return false;
      });
      form_field.after(button_field_new);

      // If a field is linked to an authorised values list, display the list.
      $('div.form-field-select-text select').change(function() {
        loadAuthorisedValuesSelect($(this));
      }).change();

      // Prevent user to select the 'All ...' option with other options.
      $('div.form-field-select').each(function() {
        $(this).find('select').filter(':last').change(function() {
          values = $(this).val();
          if (values.length > 1) {
            var idx = $.inArray('', values);
            if (idx != -1) {
              values.splice(idx, 1);
              $(this).val(values);
            }
          }
        });
      });

      $('#itemsearchform').submit(function() {
        var format = $(this).find('input[name="format"]:checked').val();
        if (format == 'html') {
          submitForm($(this));
          hideForm($(this));
          return false;
        }
      });

      $('#editsearchlink').click(function() {
        $('#itemsearchform').show();
        $(this).hide();
        return false;
      });
    });
    //]]>
  </script>
</head>
<body id="catalog_itemsearch" class="catalog">
  [% INCLUDE 'header.inc' %]
  <div id="breadcrumbs">
    <a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo; Item search
  </div>

  <div id="doc" class="yui-t7">
    <div id="bd">
      <h1>Item search</h1>
      <a href="/cgi-bin/koha/catalogue/search.pl">Go to advanced search</a>
      <form action="" method="get" id="itemsearchform">
        <fieldset>
          <legend>Item search</legend>
          <fieldset>
            [% INCLUDE form_field_select
              name="homebranch"
              label="Home branch"
              options = branches
              empty_option = "All branches"
            %]
            [% INCLUDE form_field_select
              name="location"
              label="Location"
              options = locations
              empty_option = "All locations"
            %]
          </fieldset>
          <fieldset>
            [% INCLUDE form_field_select
              name="itype"
              label="Item type"
              options = itemtypes
              empty_option = "All item types"
            %]
            [% INCLUDE form_field_select
              name="ccode"
              label="Collection code"
              options = ccodes
              empty_option = "All collection codes"
            %]
          </fieldset>
          <fieldset>
            [% INCLUDE form_field_select_text_block %]
            <p class="hint">You can use the following joker characters: % _</p>
          </fieldset>
          <fieldset>
            <div class="form-field">
              <label class="form-field-label" for="itemcallnumber_from">From call number:</label>
              [% value = CGI.param('itemcallnumber_from') %]
              <input type="text" id="itemcallnumber_from" name="itemcallnumber_from" value="[% value %]" />
              <span class="hint">(inclusive)</span>
            </div>
            <div class="form-field">
              [% value = CGI.param('itemcallnumber_to') %]
              <label class="form-field-label" for="itemcallnumber_to">To call number:</label>
              <input type="text" id="itemcallnumber_to" name="itemcallnumber_to" value="[% value %]" />
              <span class="hint">(inclusive)</span>
            </div>
            [% INCLUDE form_field_radio_yes_no name="damaged" label="Damaged" %]
            [% INCLUDE form_field_radio_yes_no name="itemlost" label="Lost" %]
            <div class="form-field">
              <label class="form-field-label" for="issues">Issues count:</label>
              <select id="issues_op" name="issues_op">
                <option value=">">&gt;</option>
                <option value="<">&lt;</option>
                <option value="=">=</option>
                <option value="!=">!=</option>
              </select>
              <input type="text" name="issues" />
            </div>
            <div class="form-field">
              <label class="form-field-label" for="datelastborrowed">Last issue date:</label>
              <select id="datelastborrowed_op" name="datelastborrowed_op">
                <option value=">">After</option>
                <option value="<">Before</option>
                <option value="=">On</option>
              </select>
              <input type="text" name="datelastborrowed" />
              <span class="hint">ISO Format (AAAA-MM-DD)</span>
            </div>
          </fieldset>
          <fieldset>
            <div class="form-field-radio">
              <label>Output:</label>
              <input type="radio" id="format-html" name="format" value="html" checked="checked" /> <label for="format-html">Screen</label>
              <input type="radio" id="format-csv" name="format" value="csv" /> <label for="format-csv">CSV</label>
            </div>
            <div class="form-actions">
              <input type="submit" value="Search" />
            </div>
          </fieldset>
        </fieldset>
      </form>

      <p><a id="editsearchlink" href="#" style="display:none">Edit search</a></p>

      <div id="results-wrapper">
        [% IF search_done %]

          [% IF total_rows > 0 %]
            <p>Found [% total_rows %] results.</p>
          [% ELSE %]
            <p>No results found.</p>
          [% END %]

          [% IF results %]
            [% INCLUDE 'catalogue/itemsearch_items.inc' items = results %]
          [% END %]

          <div id="pagination-bar">
            [% pagination_bar %]
          </div>

        [% END %]
      </div>
    </div>

    [% INCLUDE 'intranet-bottom.inc' %]

Return to bug 11425

Lines 56-61 BEGIN { Link Here

(-)a/C4/SQLHelper.pm (+33 lines)
56	UpdateInTable	56	UpdateInTable
57	GetPrimaryKeys	57	GetPrimaryKeys
58	clear_columns_cache	58	clear_columns_cache
		59	GetColumns
59	);	60	);
60	%EXPORT_TAGS = ( all =>[qw( InsertInTable DeleteInTable SearchInTable UpdateInTable GetPrimaryKeys)]	61	%EXPORT_TAGS = ( all =>[qw( InsertInTable DeleteInTable SearchInTable UpdateInTable GetPrimaryKeys)]
61	);	62	);
Lines 296-301 sub _get_columns { Link Here
296	return $hashref->{$tablename};	297	return $hashref->{$tablename};
297	}	298	}
298		299
		300	=head2 GetColumns
		301
		302	my @columns = GetColumns($tablename);
		303
		304	Given a tablename, returns an array of columns names.
		305
		306	=cut
		307
		308	sub GetColumns {
		309	my ($tablename) = @_;
		310
		311	return unless $tablename;
		312	return unless $tablename =~ /^[a-zA-Z0-9_]+$/;
		313
		314	# Get the database handle.
		315	my $dbh = C4::Context->dbh;
		316
		317	# Pure ANSI SQL goodness.
		318	my $sql = "SELECT * FROM $tablename WHERE 1=0;";
		319
		320	# Run the SQL statement to load STH's readonly properties.
		321	my $sth = $dbh->prepare($sql);
		322	my $rv = $sth->execute();
		323
		324	my @data;
		325	if ($rv) {
		326	@data = @{$sth->{NAME}};
		327	}
		328
		329	return @data;
		330	}
		331
299	=head2 _filter_columns	332	=head2 _filter_columns
300		333
301	=over 4	334	=over 4

Lines 3394-3399 CREATE TABLE IF NOT EXISTS marc_modification_template_actions ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (+17 lines)
3394	CONSTRAINT `mmta_ibfk_1` FOREIGN KEY (`template_id`) REFERENCES `marc_modification_templates` (`template_id`) ON DELETE CASCADE ON UPDATE CASCADE	3394	CONSTRAINT `mmta_ibfk_1` FOREIGN KEY (`template_id`) REFERENCES `marc_modification_templates` (`template_id`) ON DELETE CASCADE ON UPDATE CASCADE
3395	) ENGINE=InnoDB DEFAULT CHARSET=utf8;	3395	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3396		3396
		3397	--
		3398	-- Table structure for table 'items_search_fields'
		3399	--
		3400
		3401	DROP TABLE IF EXISTS items_search_fields;
		3402	CREATE TABLE items_search_fields (
		3403	name VARCHAR(255) NOT NULL,
		3404	label VARCHAR(255) NOT NULL,
		3405	tagfield CHAR(3) NOT NULL,
		3406	tagsubfield CHAR(1) NULL DEFAULT NULL,
		3407	authorised_values_category VARCHAR(16) NULL DEFAULT NULL,
		3408	PRIMARY KEY(name),
		3409	CONSTRAINT items_search_fields_authorised_values_category
		3410	FOREIGN KEY (authorised_values_category) REFERENCES authorised_values (category)
		3411	ON DELETE SET NULL ON UPDATE CASCADE
		3412	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
		3413
3397	/!40103 SET TIME_ZONE=@OLD_TIME_ZONE /;	3414	/!40103 SET TIME_ZONE=@OLD_TIME_ZONE /;
3398	/!40101 SET SQL_MODE=@OLD_SQL_MODE /;	3415	/!40101 SET SQL_MODE=@OLD_SQL_MODE /;
3399	/!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS /;	3416	/!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS /;

Lines 7853-7858 if ( CheckVersion($DBversion) ) { Link Here

(-)a/installer/data/mysql/updatedatabase.pl (+20 lines)
7853	SetVersion ($DBversion);	7853	SetVersion ($DBversion);
7854	}	7854	}
7855		7855
		7856	$DBversion = "XXX";
		7857	if ( CheckVersion($DBversion) ) {
		7858	$dbh->do(q{
		7859	CREATE TABLE IF NOT EXISTS items_search_fields (
		7860	name VARCHAR(255) NOT NULL,
		7861	label VARCHAR(255) NOT NULL,
		7862	tagfield CHAR(3) NOT NULL,
		7863	tagsubfield CHAR(1) NULL DEFAULT NULL,
		7864	authorised_values_category VARCHAR(16) NULL DEFAULT NULL,
		7865	PRIMARY KEY(name),
		7866	CONSTRAINT items_search_fields_authorised_values_category
		7867	FOREIGN KEY (authorised_values_category) REFERENCES authorised_values (category)
		7868	ON DELETE SET NULL ON UPDATE CASCADE
		7869	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
		7870	});
		7871	print "Upgrade to $DBversion done (Bug XXXXX: Add items_search_fields table)\n";
		7872	SetVersion($DBversion);
		7873	}
		7874
		7875
7856	=head1 FUNCTIONS	7876	=head1 FUNCTIONS
7857		7877
7858	=head2 TableExists($table)	7878	=head2 TableExists($table)

Lines 35-40 use DateTime::Format::MySQL; Link Here

(-)a/C4/Items.pm (-20 / +177 lines)
35	use Data::Dumper; # used as part of logging item record changes, not just for	35	use Data::Dumper; # used as part of logging item record changes, not just for
36	# debugging; so please don't remove this	36	# debugging; so please don't remove this
37	use Koha::DateUtils qw/dt_from_string/;	37	use Koha::DateUtils qw/dt_from_string/;
		38	use C4::SQLHelper qw(GetColumns);
38		39
39	use vars qw($VERSION @ISA @EXPORT);	40	use vars qw($VERSION @ISA @EXPORT);
40		41
Lines 85-90 BEGIN { Link Here
85	GetAnalyticsCount	86	GetAnalyticsCount
86	GetItemHolds	87	GetItemHolds
87		88
		89	SearchItemsByField
88	SearchItems	90	SearchItems
89		91
90	PrepareItemrecordDisplay	92	PrepareItemrecordDisplay
Lines 2546-2584 sub GetItemHolds { Link Here
2546	return $holds;	2548	return $holds;
2547	}	2549	}
2548		2550
2549	# Return the list of the column names of items table	2551	=head2 SearchItemsByField
2550	sub _get_items_columns {	2552
2551	my $dbh = C4::Context->dbh;	2553	my $items = SearchItemsByField($field, $value);
2552	my $sth = $dbh->column_info(undef, undef, 'items', '%');	2554
2553	$sth->execute;	2555	SearchItemsByField will search for items on a specific given field.
2554	my $results = $sth->fetchall_hashref('COLUMN_NAME');	2556	For instance you can search all items with a specific stocknumber like this:
2555	return keys %$results;	2557
		2558	my $items = SearchItemsByField('stocknumber', $stocknumber);
		2559
		2560	=cut
		2561
		2562	sub SearchItemsByField {
		2563	my ($field, $value) = @_;
		2564
		2565	my $filters = [ {
		2566	field => $field,
		2567	query => $value,
		2568	} ];
		2569
		2570	my ($results) = SearchItems($filters);
		2571	return $results;
		2572	}
		2573
		2574	sub _SearchItems_build_where_fragment {
		2575	my ($filter) = @_;
		2576
		2577	my $where_fragment;
		2578	if (exists($filter->{conjunction})) {
		2579	my (@where_strs, @where_args);
		2580	foreach my $f (@{ $filter->{filters} }) {
		2581	my $fragment = _SearchItems_build_where_fragment($f);
		2582	if ($fragment) {
		2583	push @where_strs, $fragment->{str};
		2584	push @where_args, @{ $fragment->{args} };
		2585	}
		2586	}
		2587	my $where_str = '';
		2588	if (@where_strs) {
		2589	$where_str = '(' . join (' ' . $filter->{conjunction} . ' ', @where_strs) . ')';
		2590	$where_fragment = {
		2591	str => $where_str,
		2592	args => \@where_args,
		2593	};
		2594	}
		2595	} else {
		2596	my @columns = GetColumns('items');
		2597	push @columns, GetColumns('biblio');
		2598	push @columns, GetColumns('biblioitems');
		2599	my @operators = qw(= != > < >= <= like);
		2600	my $field = $filter->{field};
		2601	if ( (0 < grep /^$field$/, @columns) or (substr($field, 0, 5) eq 'marc:') ) {
		2602	my $op = $filter->{operator};
		2603	my $query = $filter->{query};
		2604
		2605	if (!$op or (0 == grep /^$op$/, @operators)) {
		2606	$op = '='; # default operator
		2607	}
		2608
		2609	my $column;
		2610	if ($field =~ /^marc:(\d{3})(?:\$(\w))?$/) {
		2611	my $marcfield = $1;
		2612	my $marcsubfield = $2;
		2613	my $xpath;
		2614	if ($marcfield < 10) {
		2615	$xpath = "//record/controlfield[\@tag=\"$marcfield\"]";
		2616	} else {
		2617	$xpath = "//record/datafield[\@tag=\"$marcfield\"]/subfield[\@code=\"$marcsubfield\"]";
		2618	}
		2619	$column = "ExtractValue(marcxml, '$xpath')";
		2620	} else {
		2621	$column = $field;
2622	}
2623
2624	if (ref $query eq 'ARRAY') {
2625	if ($op eq '=') {
2626	$op = 'IN';
2627	} elsif ($op eq '!=') {
2628	$op = 'NOT IN';
2629	}
2630	$where_fragment = {
2631	str => "$column $op (" . join (',', ('?') x @$query) . ")",
2632	args => $query,
2633	};
2634	} else {
2635	$where_fragment = {
2636	str => "$column $op ?",
2637	args => [ $query ],
2638	};
2639	}
2640	}
2641	}
2642
2643	return $where_fragment;
2556	}	2644	}
2557		2645
2558	=head2 SearchItems	2646	=head2 SearchItems
2559		2647
2560	my $items = SearchItems($field, $value);	2648	my ($items, $total) = SearchItemsByField($filters, $params);
2561		2649
2562	SearchItems will search for items on a specific given field.	2650	Perform a search among items
2563	For instance you can search all items with a specific stocknumber like this:
2564		2651
2565	my $items = SearchItems('stocknumber', $stocknumber);	2652	$filters is a reference to an array of filters, where each filter is a hash with
		2653	the following keys:
		2654
		2655	=over 2
		2656
		2657	=item * field: the name of a SQL column in table items
		2658
		2659	=item * query: the value to search in this column
		2660
		2661	=item * operator: comparison operator. Can be one of = != > < >= <= like
		2662
		2663	=back
		2664
		2665	A logical AND is used to combine filters.
		2666
		2667	$params is a reference to a hash that can contain the following parameters:
		2668
		2669	=over 2
		2670
		2671	=item * rows: Number of items to return. 0 returns everything (default: 0)
		2672
		2673	=item * page: Page to return (return items from (page-1)rows to (pagerows)-1)
		2674	(default: 1)
		2675
		2676	=item * sortby: A SQL column name in items table to sort on
		2677
		2678	=item * sortorder: 'ASC' or 'DESC'
		2679
		2680	=back
2566		2681
2567	=cut	2682	=cut
2568		2683
2569	sub SearchItems {	2684	sub SearchItems {
2570	my ($field, $value) = @_;	2685	my ($filter, $params) = @_;
		2686
		2687	$filter //= {};
		2688	$params //= {};
		2689	return unless ref $filter eq 'HASH';
		2690	return unless ref $params eq 'HASH';
		2691
		2692	# Default parameters
		2693	$params->{rows} \|\|= 0;
		2694	$params->{page} \|\|= 1;
		2695	$params->{sortby} \|\|= 'itemnumber';
		2696	$params->{sortorder} \|\|= 'ASC';
		2697
		2698	my ($where_str, @where_args);
		2699	my $where_fragment = _SearchItems_build_where_fragment($filter);
		2700	if ($where_fragment) {
		2701	$where_str = $where_fragment->{str};
		2702	@where_args = @{ $where_fragment->{args} };
		2703	}
2571		2704
2572	my $dbh = C4::Context->dbh;	2705	my $dbh = C4::Context->dbh;
2573	my @columns = _get_items_columns;	2706	my $query = q{
2574	my $results = [];	2707	SELECT SQL_CALC_FOUND_ROWS items.*
2575	if(0 < grep /^$field$/, @columns) {	2708	FROM items
2576	my $query = "SELECT $field FROM items WHERE $field = ?";	2709	LEFT JOIN biblio ON biblio.biblionumber = items.biblionumber
2577	my $sth = $dbh->prepare( $query );	2710	LEFT JOIN biblioitems ON biblioitems.biblioitemnumber = items.biblioitemnumber
2578	$sth->execute( $value );	2711	};
2579	$results = $sth->fetchall_arrayref({});	2712	if (defined $where_str and $where_str ne '') {
		2713	$query .= qq{ WHERE $where_str };
2580	}	2714	}
2581	return $results;	2715
		2716	my @columns = GetColumns('items');
		2717	push @columns, GetColumns('biblio');
		2718	push @columns, GetColumns('biblioitems');
		2719	my $sortby = (0 < grep {$params->{sortby} eq $_} @columns)
		2720	? $params->{sortby} : 'itemnumber';
		2721	my $sortorder = (uc($params->{sortorder}) eq 'ASC') ? 'ASC' : 'DESC';
		2722	$query .= qq{ ORDER BY $sortby $sortorder };
		2723
		2724	my $rows = $params->{rows};
		2725	my @limit_args;
		2726	if ($rows > 0) {
		2727	my $offset = $rows * ($params->{page}-1);
		2728	$query .= qq { LIMIT ?, ? };
		2729	push @limit_args, $offset, $rows;
		2730	}
		2731
		2732	my $sth = $dbh->prepare($query);
		2733	my $rv = $sth->execute(@where_args, @limit_args);
		2734
		2735	return unless ($rv);
		2736	my ($total_rows) = $dbh->selectrow_array(q{ SELECT FOUND_ROWS() });
		2737
		2738	return ($sth->fetchall_arrayref({}), $total_rows);
2582	}	2739	}
2583		2740
2584		2741

Line 0 Link Here

(-)a/Koha/Item/Search/Field.pm (+107 lines)
		1	package Koha::Item::Search::Field;
		2
		3	use Modern::Perl;
		4	use base qw( Exporter );
		5
		6	our @EXPORT_OK = qw(
		7	AddItemSearchField
		8	ModItemSearchField
		9	DelItemSearchField
		10	GetItemSearchField
		11	GetItemSearchFields
		12	);
		13
		14	use C4::Context;
		15
		16	sub AddItemSearchField {
		17	my ($field) = @_;
		18
		19	my ( $name, $label, $tagfield, $tagsubfield, $av_category ) =
		20	@$field{qw(name label tagfield tagsubfield authorised_values_category)};
		21
		22	my $dbh = C4::Context->dbh;
		23	my $query = q{
		24	INSERT INTO items_search_fields (name, label, tagfield, tagsubfield, authorised_values_category)
		25	VALUES (?, ?, ?, ?, ?)
		26	};
		27	my $sth = $dbh->prepare($query);
		28	my $rv = $sth->execute($name, $label, $tagfield, $tagsubfield, $av_category);
		29
		30	return ($rv) ? $field : undef;
		31	}
		32
		33	sub ModItemSearchField {
		34	my ($field) = @_;
		35
		36	my ( $name, $label, $tagfield, $tagsubfield, $av_category ) =
		37	@$field{qw(name label tagfield tagsubfield authorised_values_category)};
		38
		39	my $dbh = C4::Context->dbh;
		40	my $query = q{
		41	UPDATE items_search_fields
		42	SET label = ?,
		43	tagfield = ?,
		44	tagsubfield = ?,
		45	authorised_values_category = ?
		46	WHERE name = ?
		47	};
		48	my $sth = $dbh->prepare($query);
		49	my $rv = $sth->execute($label, $tagfield, $tagsubfield, $av_category, $name);
		50
		51	return ($rv) ? $field : undef;
		52	}
		53
		54	sub DelItemSearchField {
		55	my ($name) = @_;
		56
		57	my $dbh = C4::Context->dbh;
		58	my $query = q{
		59	DELETE FROM items_search_fields
		60	WHERE name = ?
		61	};
		62	my $sth = $dbh->prepare($query);
		63	my $rv = $sth->execute($name);
		64
65	my $is_deleted = $rv ? int($rv) : 0;
66	if (!$is_deleted) {
67	warn "DelItemSearchField: Field '$name' doesn't exist";
68	}
69
70	return $is_deleted;
71	}
72
73	sub GetItemSearchField {
74	my ($name) = @_;
75
76	my $dbh = C4::Context->dbh;
77	my $query = q{
78	SELECT * FROM items_search_fields
79	WHERE name = ?
80	};
81	my $sth = $dbh->prepare($query);
82	my $rv = $sth->execute($name);
83
84	my $field;
85	if ($rv) {
86	$field = $sth->fetchrow_hashref;
87	}
88
89	return $field;
90	}
91
92	sub GetItemSearchFields {
93	my $dbh = C4::Context->dbh;
94	my $query = q{
95	SELECT * FROM items_search_fields
96	};
97	my $sth = $dbh->prepare($query);
98	my $rv = $sth->execute();
99
100	my @fields;
101	if ($rv) {
102	my $fields = $sth->fetchall_arrayref( {} );
103	@fields = @$fields;
104	}
105
106	return @fields;
107	}

Line 0 Link Here

(-)a/admin/items_search_field.pl (+63 lines)
	1	#!/usr/bin/perl
	2	# Copyright 2013 BibLibre
	3	#
	4	# This file is part of Koha
	5	#
	6	# Koha is free software; you can redistribute it and/or modify it under the
	7	# terms of the GNU General Public License as published by the Free Software
	8	# Foundation; either version 3 of the License, or (at your option) any later
	9	# version.
	10	#
	11	# Koha is distributed in the hope that it will be useful, but WITHOUT ANY
	12	# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
	13	# A PARTICULAR PURPOSE. See the GNU General Public License for more details.
	14	#
	15	# You should have received a copy of the GNU General Public License along
	16	# with Koha; if not, write to the Free Software Foundation, Inc.,
	17	# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
	18
	19	use Modern::Perl;
	20	use CGI;
	21
	22	use C4::Auth;
	23	use C4::Output;
	24	use C4::Koha;
	25
	26	use Koha::Item::Search::Field qw(GetItemSearchField ModItemSearchField);
	27
	28	my $cgi = new CGI;
	29
	30	my ($template, $borrowernumber, $cookie) = get_template_and_user({
	31	template_name => 'admin/items_search_field.tt',
	32	query => $cgi,
	33	type => 'intranet',
	34	authnotrequired => 0,
	35	flagsrequired => { catalogue => 1 },
	36	});
	37
	38	my $op = $cgi->param('op') \|\| '';
	39	my $name = $cgi->param('name');
	40
	41	if ($op eq 'mod') {
	42	my %vars = $cgi->Vars;
	43	my $field = { name => $name };
	44	my @params = qw(label tagfield tagsubfield authorised_values_category);
	45	@$field{@params} = @vars{@params};
	46	if ( $field->{authorised_values_category} eq '' ) {
	47	$field->{authorised_values_category} = undef;
	48	}
	49	$field = ModItemSearchField($field);
	50	my $updated = ($field) ? 1 : 0;
	51	print $cgi->redirect('/cgi-bin/koha/admin/items_search_fields.pl?updated=' . $updated);
	52	exit;
	53	}
	54
	55	my $field = GetItemSearchField($name);
	56	my $authorised_values_categories = C4::Koha::GetAuthorisedValueCategories();
	57
	58	$template->param(
	59	field => $field,
	60	authorised_values_categories => $authorised_values_categories,
	61	);
	62
	63	output_html_with_http_headers $cgi, $cookie, $template->output;

Line 0 Link Here

(-)a/admin/items_search_fields.pl (+81 lines)
		1	#!/usr/bin/perl
		2	# Copyright 2013 BibLibre
		3	#
		4	# This file is part of Koha
		5	#
		6	# Koha is free software; you can redistribute it and/or modify it under the
		7	# terms of the GNU General Public License as published by the Free Software
		8	# Foundation; either version 3 of the License, or (at your option) any later
		9	# version.
		10	#
		11	# Koha is distributed in the hope that it will be useful, but WITHOUT ANY
		12	# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
		13	# A PARTICULAR PURPOSE. See the GNU General Public License for more details.
		14	#
		15	# You should have received a copy of the GNU General Public License along
		16	# with Koha; if not, write to the Free Software Foundation, Inc.,
		17	# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
		18
		19	use Modern::Perl;
		20	use CGI;
		21
		22	use C4::Auth;
		23	use C4::Output;
		24	use C4::Koha;
		25
		26	use Koha::Item::Search::Field qw(AddItemSearchField GetItemSearchFields DelItemSearchField);
		27
		28	my $cgi = new CGI;
		29
		30	my ($template, $borrowernumber, $cookie) = get_template_and_user({
		31	template_name => 'admin/items_search_fields.tt',
		32	query => $cgi,
		33	type => 'intranet',
		34	authnotrequired => 0,
		35	flagsrequired => { catalogue => 1 },
		36	});
		37
		38	my $op = $cgi->param('op') \|\| '';
		39
		40	if ($op eq 'add') {
		41	my %vars = $cgi->Vars;
		42	my $field;
		43	my @params = qw(name label tagfield tagsubfield authorised_values_category);
		44	@$field{@params} = @vars{@params};
		45	if ( $field->{authorised_values_category} eq '' ) {
		46	$field->{authorised_values_category} = undef;
		47	}
		48	$field = AddItemSearchField($field);
		49	if ($field) {
		50	$template->param(field_added => $field);
		51	} else {
		52	$template->param(field_not_added => 1);
		53	}
		54	} elsif ($op eq 'del') {
		55	my $name = $cgi->param('name');
		56	my $rv = DelItemSearchField($name);
		57	if ($rv) {
		58	$template->param(field_deleted => 1);
		59	} else {
		60	$template->param(field_not_deleted => 1);
		61	}
		62	} else {
		63	my $updated = $cgi->param('updated');
		64	if (defined $updated) {
65	if ($updated) {
66	$template->param(field_updated => 1);
67	} else {
68	$template->param(field_not_updated => 1);
69	}
70	}
71	}
72
73	my @fields = GetItemSearchFields();
74	my $authorised_values_categories = C4::Koha::GetAuthorisedValueCategories();
75
76	$template->param(
77	fields => \@fields,
78	authorised_values_categories => $authorised_values_categories,
79	);
80
81	output_html_with_http_headers $cgi, $cookie, $template->output;

Line 0 Link Here

(-)a/catalogue/itemsearch.pl (+298 lines)
		1	#!/usr/bin/perl
		2	# Copyright 2013 BibLibre
		3	#
		4	# This file is part of Koha
		5	#
		6	# Koha is free software; you can redistribute it and/or modify it under the
		7	# terms of the GNU General Public License as published by the Free Software
		8	# Foundation; either version 3 of the License, or (at your option) any later
		9	# version.
		10	#
		11	# Koha is distributed in the hope that it will be useful, but WITHOUT ANY
		12	# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
		13	# A PARTICULAR PURPOSE. See the GNU General Public License for more details.
		14	#
		15	# You should have received a copy of the GNU General Public License along
		16	# with Koha; if not, write to the Free Software Foundation, Inc.,
		17	# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
		18
		19	use Modern::Perl;
		20	use CGI;
		21
		22	use JSON;
		23
		24	use C4::Auth;
		25	use C4::Output;
		26	use C4::Items;
		27	use C4::Biblio;
		28	use C4::Branch;
		29	use C4::Koha;
		30	use C4::ItemType;
		31
		32	use Koha::Item::Search::Field qw(GetItemSearchFields);
		33
		34	my $cgi = new CGI;
		35	my %params = $cgi->Vars;
		36
		37	my $format = $cgi->param('format');
		38	my ($template_name, $content_type);
		39	if (defined $format and $format eq 'json') {
		40	$template_name = 'catalogue/itemsearch.json.tt';
		41	$content_type = 'json';
		42
		43	# Map DataTables parameters with 'regular' parameters
		44	$cgi->param('rows', $cgi->param('iDisplayLength'));
		45	$cgi->param('page', ($cgi->param('iDisplayStart') / $cgi->param('iDisplayLength')) + 1);
		46	my @columns = split /,/, $cgi->param('sColumns');
		47	$cgi->param('sortby', $columns[ $cgi->param('iSortCol_0') ]);
		48	$cgi->param('sortorder', $cgi->param('sSortDir_0'));
		49
		50	my @f = $cgi->param('f');
		51	my @q = $cgi->param('q');
		52	push @q, '' if @q == 0;
		53	my @op = $cgi->param('op');
		54	my @c = $cgi->param('c');
		55	foreach my $i (0 .. ($cgi->param('iColumns') - 1)) {
		56	my $sSearch = $cgi->param("sSearch_$i");
		57	if ($sSearch) {
		58	my @words = split /\s+/, $sSearch;
		59	foreach my $word (@words) {
		60	push @f, $columns[$i];
		61	push @q, "%$word%";
		62	push @op, 'like';
		63	push @c, 'and';
		64	}
65	}
66	}
67	$cgi->param('f', @f);
68	$cgi->param('q', @q);
69	$cgi->param('op', @op);
70	$cgi->param('c', @c);
71	} elsif (defined $format and $format eq 'csv') {
72	$template_name = 'catalogue/itemsearch.csv.tt';
73
74	# Retrieve all results
75	$cgi->param('rows', 0);
76	} else {
77	$format = 'html';
78	$template_name = 'catalogue/itemsearch.tt';
79	$content_type = 'html';
80	}
81
82	my ($template, $borrowernumber, $cookie) = get_template_and_user({
83	template_name => $template_name,
84	query => $cgi,
85	type => 'intranet',
86	authnotrequired => 0,
87	flagsrequired => { catalogue => 1 },
88	});
89
90	my $notforloan_avcode = GetAuthValCode('items.notforloan');
91	my $notforloan_values = GetAuthorisedValues($notforloan_avcode);
92
93	if (scalar keys %params > 0) {
94	# Parameters given, it's a search
95
96	my $filter = {
97	conjunction => 'AND',
98	filters => [],
99	};
100
101	foreach my $p (qw(homebranch location itype ccode issues datelastborrowed)) {
102	if (my @q = $cgi->param($p)) {
103	if ($q[0] ne '') {
104	my $f = {
105	field => $p,
106	query => \@q,
107	};
108	if (my $op = $cgi->param($p . '_op')) {
109	$f->{operator} = $op;
110	}
111	push @{ $filter->{filters} }, $f;
112	}
113	}
114	}
115
116	my @c = $cgi->param('c');
117	my @fields = $cgi->param('f');
118	my @q = $cgi->param('q');
119	my @op = $cgi->param('op');
120
121	my $f;
122	for (my $i = 0; $i < @fields; $i++) {
123	my $field = $fields[$i];
124	my $q = shift @q;
125	my $op = shift @op;
126	if (defined $q and $q ne '') {
127	if ($i == 0) {
128	$f = {
129	field => $field,
130	query => $q,
131	operator => $op,
132	};
133	} else {
134	my $c = shift @c;
135	$f = {
136	conjunction => $c,
137	filters => [
138	$f, {
139	field => $field,
140	query => $q,
141	operator => $op,
142	}
143	],
144	};
145	}
146	}
147	}
148	push @{ $filter->{filters} }, $f;
149
150	# Yes/No parameters
151	foreach my $p (qw(damaged itemlost)) {
152	my $v = $cgi->param($p) // '';
153	my $f = {
154	field => $p,
155	query => 0,
156	};
157	if ($v eq 'yes') {
158	$f->{operator} = '!=';
159	push @{ $filter->{filters} }, $f;
160	} elsif ($v eq 'no') {
161	$f->{operator} = '=';
162	push @{ $filter->{filters} }, $f;
163	}
164	}
165
166	if (my $itemcallnumber_from = $cgi->param('itemcallnumber_from')) {
167	push @{ $filter->{filters} }, {
168	field => 'itemcallnumber',
169	query => $itemcallnumber_from,
170	operator => '>=',
171	};
172	}
173	if (my $itemcallnumber_to = $cgi->param('itemcallnumber_to')) {
174	push @{ $filter->{filters} }, {
175	field => 'itemcallnumber',
176	query => $itemcallnumber_to,
177	operator => '<=',
178	};
179	}
180
181	my $search_params = {
182	rows => $cgi->param('rows') // 20,
183	page => $cgi->param('page') \|\| 1,
184	sortby => $cgi->param('sortby') \|\| 'itemnumber',
185	sortorder => $cgi->param('sortorder') \|\| 'asc',
186	};
187
188	my ($results, $total_rows) = SearchItems($filter, $search_params);
189	if ($results) {
190	# Get notforloan labels
191	my $notforloan_map = {};
192	foreach my $nfl_value (@$notforloan_values) {
193	$notforloan_map->{$nfl_value->{authorised_value}} = $nfl_value->{lib};
194	}
195
196	foreach my $item (@$results) {
197	$item->{biblio} = GetBiblio($item->{biblionumber});
198	($item->{biblioitem}) = GetBiblioItemByBiblioNumber($item->{biblionumber});
199	$item->{status} = $notforloan_map->{$item->{notforloan}};
200	}
201	}
202
203	$template->param(
204	filter => $filter,
205	search_params => $search_params,
206	results => $results,
207	total_rows => $total_rows,
208	search_done => 1,
209	);
210
211	if ($format eq 'html') {
212	# Build pagination bar
213	my $url = $cgi->url(-absolute => 1);
214	my @params;
215	foreach my $p (keys %params) {
216	my @v = $cgi->param($p);
217	push @params, map { "$p=" . $_ } @v;
218	}
219	$url .= '?' . join ('&', @params);
220	my $nb_pages = 1 + int($total_rows / $search_params->{rows});
221	my $current_page = $search_params->{page};
222	my $pagination_bar = pagination_bar($url, $nb_pages, $current_page, 'page');
223
224	$template->param(pagination_bar => $pagination_bar);
225	}
226	}
227
228	if ($format eq 'html') {
229	# Retrieve data required for the form.
230
231	my $branches = GetBranches();
232	my @branches;
233	foreach my $branchcode (keys %$branches) {
234	push @branches, {
235	value => $branchcode,
236	label => $branches->{$branchcode}->{branchname},
237	};
238	}
239	my $locations = GetAuthorisedValues('LOC');
240	my @locations;
241	foreach my $location (@$locations) {
242	push @locations, {
243	value => $location->{authorised_value},
244	label => $location->{lib},
245	};
246	}
247	my @itemtypes = C4::ItemType->all();
248	foreach my $itemtype (@itemtypes) {
249	$itemtype->{value} = $itemtype->{itemtype};
250	$itemtype->{label} = $itemtype->{description};
251	}
252	my $ccode_avcode = GetAuthValCode('items.ccode') \|\| 'CCODE';
253	my $ccodes = GetAuthorisedValues($ccode_avcode);
254	my @ccodes;
255	foreach my $ccode (@$ccodes) {
256	push @ccodes, {
257	value => $ccode->{authorised_value},
258	label => $ccode->{lib},
259	};
260	}
261
262	my @notforloans;
263	foreach my $value (@$notforloan_values) {
264	push @notforloans, {
265	value => $value->{authorised_value},
266	label => $value->{lib},
267	};
268	}
269
270	my @items_search_fields = GetItemSearchFields();
271
272	my $authorised_values = {};
273	foreach my $field (@items_search_fields) {
274	if (my $category = ($field->{authorised_values_category})) {
275	$authorised_values->{$category} = GetAuthorisedValues($category);
276	}
277	}
278
279	$template->param(
280	branches => \@branches,
281	locations => \@locations,
282	itemtypes => \@itemtypes,
283	ccodes => \@ccodes,
284	notforloans => \@notforloans,
285	items_search_fields => \@items_search_fields,
286	authorised_values_json => to_json($authorised_values),
287	);
288	}
289
290	if ($format eq 'csv') {
291	print $cgi->header({
292	type => 'text/csv',
293	attachment => 'items.csv',
294	});
295	print $template->output;
296	} else {
297	output_with_http_headers $cgi, $cookie, $template->output, $content_type;
298	}

Line 0 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/css/itemsearchform.css (+44 lines)
	1	.form-field {
	2	margin: 5px 0;
	3	}
	4
	5	.form-field > * {
	6	vertical-align: middle;
	7	}
	8
	9	.form-field-label {
	10	display: inline-block;
	11	text-align: right;
	12	width: 10em;
	13	}
	14
	15	.form-field-conjunction[disabled] {
	16	visibility: hidden;
	17	}
	18
	19	.form-field-radio > * {
	20	vertical-align: middle;
	21	}
	22
	23	.form-actions {
	24	margin-top: 20px;
	25	}
	26
	27	th.active {
	28	padding-right: 21px;
	29	background-repeat: no-repeat;
	30	background-position: 100% 50%;
	31	}
	32
	33	th.sort-asc {
	34	background-image: url('../../img/asc.gif');
	35	}
	36
	37	th.sort-desc {
	38	background-image: url('../../img/desc.gif');
	39	}
	40
	41	th select {
	42	width: 100%;
	43	font-weight: normal;
	44	}

Line 0 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/includes/admin-items-search-field-form.inc (+58 lines)
	1	<ul>
	2	<li>
	3	<label for="name">Name</label>
	4	[% IF field %]
	5	<input type="text" name="name" value="[% field.name %]" disabled="disabled">
	6	<input type="hidden" name="name" value="[% field.name %]">
	7	[% ELSE %]
	8	<input type="text" name="name" />
	9	[% END %]
	10	</li>
	11	<li>
	12	<label for="label">Label</label>
	13	[% IF field %]
	14	<input type="text" name="label" value="[% field.label %]" />
	15	[% ELSE %]
	16	<input type="text" name="label" />
	17	[% END %]
	18	</li>
	19	<li>
	20	<label for="tagfield">MARC field</label>
	21	<select name="tagfield">
	22	[% FOREACH tagfield IN ['001'..'999'] %]
	23	[% IF field && field.tagfield == tagfield %]
	24	<option value="[% tagfield %]" selected="selected">[% tagfield %]</option>
	25	[% ELSE %]
	26	<option value="[% tagfield %]">[% tagfield %]</option>
	27	[% END %]
	28	[% END %]
	29	</select>
	30	</li>
	31	<li>
	32	<label for="tagsubfield">MARC subfield</label>
	33	<select name="tagsubfield">
	34	[% codes = [''] %]
	35	[% codes = codes.merge([0..9], ['a'..'z']) %]
	36	[% FOREACH tagsubfield IN codes %]
	37	[% IF field && field.tagsubfield == tagsubfield %]
	38	<option value="[% tagsubfield %]" selected="selected">[% tagsubfield %]</option>
	39	[% ELSE %]
	40	<option value="[% tagsubfield %]">[% tagsubfield %]</option>
	41	[% END %]
	42	[% END %]
	43	</select>
	44	</li>
	45	<li>
	46	<label for="authorised_values_category">Authorised values category</label>
	47	<select name="authorised_values_category">
	48	<option value="">- None -</option>
	49	[% FOREACH category IN authorised_values_categories %]
	50	[% IF field && field.authorised_values_category == category %]
	51	<option value="[% category %]" selected="selected">[% category %]</option>
	52	[% ELSE %]
	53	<option value="[% category %]">[% category %]</option>
	54	[% END %]
	55	[% END %]
	56	</select>
	57	</li>
	58	</ul>

Line 0 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/includes/catalogue/itemsearch_item.inc (+23 lines)
	1	[%- USE Branches -%]
	2	[% biblio = item.biblio %]
	3	[% biblioitem = item.biblioitem %]
	4	<tr>
	5	<td>
	6	<a href="/cgi-bin/koha/catalogue/detail.pl?biblionumber=[% biblio.biblionumber %]" title="Go to record detail page">[% biblio.title %]</a>
	7	by [% biblio.author %]
	8	</td>
	9	<td>[% biblioitem.publicationyear %]</td>
	10	<td>[% biblioitem.publishercode %]</td>
	11	<td>[% biblioitem.collectiontitle %]</td>
	12	<td>
	13	<a href="/cgi-bin/koha/catalogue/moredetail.pl?biblionumber=[% biblio.biblionumber %]#item[% item.itemnumber %]" title="Go to item details">[% item.barcode %]</a>
	14	</td>
	15	<td>[% item.itemcallnumber %]</td>
	16	<td>[% Branches.GetName(item.homebranch) %]</td>
	17	<td>[% Branches.GetName(item.holdingbranch) %]</td>
	18	<td>[% item.location %]</td>
	19	<td>[% item.stocknumber %]</td>
	20	<td>[% item.status %]</td>
	21	<td>[% item.issues \|\| 0 %]</td>
	22	<td><a href="/cgi-bin/koha/cataloguing/additem.pl?op=edititem&biblionumber=[% item.biblionumber %]&itemnumber=[% item.itemnumber %]">Modify</a></td>
	23	</tr>

Line 0 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/includes/catalogue/itemsearch_items.inc (+49 lines)
	1	[% names = CGI.param() %]
	2	[% params = [] %]
	3	[% FOREACH name IN names %]
	4	[% IF name != 'sortby' AND name != 'sortorder' %]
	5	[% params.push(name _ "=" _ CGI.param(name)) %]
	6	[% END %]
	7	[% END %]
	8	[% base_url = "/cgi-bin/koha/catalogue/itemsearch.pl?" _ params.join('&') %]
	9
	10	[% BLOCK itemsearch_header %]
	11	[% sortorder = 'asc' %]
	12	[% classes = [] %]
	13	[% IF CGI.param('sortby') == name %]
	14	[% classes.push('active') %]
	15	[% classes.push('sort-' _ CGI.param('sortorder')) %]
	16	[% IF CGI.param('sortorder') == 'asc' %]
	17	[% sortorder = 'desc' %]
	18	[% END %]
	19	[% END %]
	20	[% url = base_url _ '&sortby=' _ name _ '&sortorder=' _ sortorder %]
	21	<th class="[% classes.join(' ') %]">
	22	<a href="[% url %]" title="Sort on [% label %] ([% sortorder %])">[% text %]</a>
	23	</th>
	24	[% END %]
	25
	26	<table>
	27	<thead>
	28	<tr>
	29	[% INCLUDE itemsearch_header name='title' label='title' text='Bibliographic reference' %]
	30	[% INCLUDE itemsearch_header name='publicationyear' label='publication date' text='Publication date' %]
	31	[% INCLUDE itemsearch_header name='publishercode' label='publisher' text='Publisher' %]
	32	[% INCLUDE itemsearch_header name='collectiontitle' label='collection' text='Collection' %]
	33	[% INCLUDE itemsearch_header name='barcode' label='barcode' text='Barcode' %]
	34	[% INCLUDE itemsearch_header name='itemcallnumber' label='callnumber' text='Callnumber' %]
	35	[% INCLUDE itemsearch_header name='homebranch' label='home branch' text='Home branch' %]
	36	[% INCLUDE itemsearch_header name='holdingbranch' label='holding branch' text='Holding branch' %]
	37	[% INCLUDE itemsearch_header name='location' label='location' text='Location' %]
	38	[% INCLUDE itemsearch_header name='stocknumber' label='stock number' text='Stock number' %]
	39	[% INCLUDE itemsearch_header name='notforloan' label='status' text='Status' %]
	40	[% INCLUDE itemsearch_header name='issues' label='issues' text='Issues' %]
	41	<th></th>
	42	</tr>
	43	</thead>
	44	<tbody>
	45	[% FOREACH item IN items %]
	46	[% INCLUDE 'catalogue/itemsearch_item.inc' item = item %]
	47	[% END %]
	48	</tbody>
	49	</table>

Line 0 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/items_search_field.tt (+41 lines)
	1	[% INCLUDE 'doc-head-open.inc' %]
	2	<title>Koha &rsaquo; Administration &rsaquo; Items search fields</title>
	3	[% INCLUDE 'doc-head-close.inc' %]
	4	</head>
	5	<body id="admin_itemssearchfields" class="admin">
	6	[% INCLUDE 'header.inc' %]
	7	[% INCLUDE 'cat-search.inc' %]
	8	<div id="breadcrumbs">
	9	<a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo;
	10	<a href="/cgi-bin/koha/admin/admin-home.pl">Administration</a> &rsaquo;
	11	<a href="/cgi-bin/koha/admin/items_search_fields.pl">Items search fields</a> &rsaquo;
	12	[% field.name %]
	13	</div>
	14
	15	<div id="doc3" class="yui-t2">
	16	<div id="bd">
	17	<div id="yui-main">
	18	<div class="yui-b">
	19	<h1>Items search field: [% field.label %]</h1>
	20
	21	<form action="" method="POST">
	22	<fieldset class="rows">
	23	<legend>Edit field</legend>
	24	[% INCLUDE 'admin-items-search-field-form.inc' field=field %]
	25	<div>
	26	<input type="hidden" name="op" value="mod" />
	27	</div>
	28	<fieldset class="action">
	29	<input type="submit" value="Update" />
	30	</fieldset>
	31	</fieldset>
	32	</form>
	33	<a href="/cgi-bin/koha/admin/items_search_fields.pl">Return to items search fields overview page</a>
	34	</div>
	35	</div>
	36	<div class="yui-b">
	37	[% INCLUDE 'admin-menu.inc' %]
	38	</div>
	39	</div>
	40
	41	[% INCLUDE 'intranet-bottom.inc' %]

Line 0 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/itemsearch.json.tt (+12 lines)
	1	[%- USE CGI -%]
	2	{
	3	"sEcho": [% CGI.param('sEcho') %],
	4	"iTotalRecords": [% total_rows %],
	5	"iTotalDisplayRecords": [% total_rows %],
	6	"aaData": [
	7	[%- FOREACH item IN results -%]
	8	[%- INCLUDE 'catalogue/itemsearch_item.json.inc' item = item -%]
	9	[%- UNLESS loop.last %],[% END -%]
	10	[%- END -%]
	11	]
	12	}

Line 0 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/itemsearch.tt (-1 / +425 lines)
0	-	1	[% USE CGI %]
		2	[% USE JSON.Escape %]
		3
		4	[% BLOCK form_field_select %]
		5	<div class="form-field form-field-select">
		6	<label class="form-field-label" for="[% name %]">[% label %]</label>
		7	<select id="[% name %]_op" name="[% name %]_op">
		8	<option value="=">is</option>
		9	[% IF CGI.param(name _ '_op') == '!=' %]
		10	<option value="!=" selected="selected">is not</option>
		11	[% ELSE %]
		12	<option value="!=" >is not</option>
		13	[% END %]
		14	</select>
		15	[% values = CGI.param(name) %]
		16	<select id="[% name %]" name="[% name %]" multiple="multiple" size="[% options.size < 4 ? options.size + 1 : 4 %]">
		17	[% IF (values == '') %]
		18	<option value="" selected="selected">
		19	[% ELSE %]
		20	<option value="">
		21	[% END %]
		22	[% empty_option \|\| "All" %]
		23	</option>
		24	[% FOREACH option IN options %]
		25	[% IF values.grep(option.value).size %]
		26	<option value="[% option.value %]" selected="selected">[% option.label %]</option>
		27	[% ELSE %]
		28	<option value="[% option.value %]">[% option.label %]</option>
		29	[% END %]
		30	[% END %]
		31	</select>
		32	</div>
		33	[% END %]
		34
		35	[% BLOCK form_field_select_option %]
		36	[% IF params.f == value %]
		37	<option value="[% value %]" selected="selected">[% label %]</option>
		38	[% ELSE %]
		39	<option value="[% value %]">[% label %]</option>
		40	[% END %]
		41	[% END %]
		42
		43	[% BLOCK form_field_select_text %]
		44	<div class="form-field form-field-select-text">
		45	[% IF params.exists('c') %]
		46	<select name="c" class="form-field-conjunction">
		47	<option value="and">AND</option>
		48	[% IF params.c == 'or' %]
		49	<option value="or" selected="selected">OR</option>
		50	[% ELSE %]
		51	<option value="or">OR</option>
		52	[% END %]
		53	</select>
		54	[% ELSE %]
		55	<select name="c" class="form-field-conjunction" disabled="disabled">
		56	<option value="and">AND</option>
		57	<option value="or">OR</option>
		58	</select>
		59	[% END %]
		60	<select name="f" class="form-field-column">
		61	[% INCLUDE form_field_select_option value='barcode' label='Barcode' %]
		62	[% INCLUDE form_field_select_option value='itemcallnumber' label='Callnumber' %]
		63	[% INCLUDE form_field_select_option value='stocknumber' label='Stock number' %]
		64	[% INCLUDE form_field_select_option value='title' label='Title' %]
		65	[% INCLUDE form_field_select_option value='author' label='Author' %]
66	[% INCLUDE form_field_select_option value='publishercode' label='Publisher' %]
67	[% INCLUDE form_field_select_option value='publicationdate' label='Publication date' %]
68	[% INCLUDE form_field_select_option value='collectiontitle' label='Collection' %]
69	[% INCLUDE form_field_select_option value='isbn' label='ISBN' %]
70	[% INCLUDE form_field_select_option value='issn' label='ISSN' %]
71	[% IF items_search_fields.size %]
72	<optgroup label="Custom search fields">
73	[% FOREACH field IN items_search_fields %]
74	[% marcfield = field.tagfield %]
75	[% IF field.tagsubfield %]
76	[% marcfield = marcfield _ '$' _ field.tagsubfield %]
77	[% END %]
78	[% IF params.f == "marc:$marcfield" %]
79	<option value="marc:[% marcfield %]" data-authorised-values-category="[% field.authorised_values_category %]" selected="selected">[% field.label %] ([% marcfield %])</option>
80	[% ELSE %]
81	<option value="marc:[% marcfield %]" data-authorised-values-category="[% field.authorised_values_category %]">[% field.label %] ([% marcfield %])</option>
82	[% END %]
83	[% END %]
84	</optgroup>
85	[% END %]
86	</select>
87	<input type="text" name="q" class="form-field-value" value="[% params.q %]" />
88	<input type="hidden" name="op" value="like" />
89	</div>
90	[% END %]
91
92	[% BLOCK form_field_select_text_block %]
93	[% c = CGI.param('c').list %]
94	[% f = CGI.param('f').list %]
95	[% q = CGI.param('q').list %]
96	[% op = CGI.param('op').list %]
97	[% IF q.size %]
98	[% size = q.size - 1 %]
99	[% FOREACH i IN [0 .. size] %]
100	[%
101	params = {
102	f => f.$i
103	q = q.$i
104	op = op.$i
105	}
106	%]
107	[% IF i > 0 %]
108	[% j = i - 1 %]
109	[% params.c = c.$j %]
110	[% END %]
111	[% INCLUDE form_field_select_text params=params %]
112	[% END %]
113	[% ELSE %]
114	[% INCLUDE form_field_select_text %]
115	[% END %]
116	[% END %]
117
118	[% BLOCK form_field_radio_yes_no %]
119	<div class="form-field">
120	<label class="form-field-label" for="[% name %]">[% label %]:</label>
121	<input type="radio" name="[% name %]" id="[% name %]_indifferent" value="" checked="checked"/>
122	<label for="[% name %]_indifferent">Indifferent</label>
123	<input type="radio" name="[% name %]" id="[% name %]_yes" value="yes" />
124	<label for="[% name %]_yes">Yes</label>
125	<input type="radio" name="[% name %]" id="[% name %]_no" value="no" />
126	<label for="[% name %]_no">No</label>
127	</div>
128	[% END %]
129
130	[%# Page starts here %]
131
132	[% INCLUDE 'doc-head-open.inc' %]
133	<title>Koha &rsaquo; Catalog &rsaquo; Advanced search</title>
134	[% INCLUDE 'doc-head-close.inc' %]
135	[% INCLUDE 'datatables.inc' %]
136	<script type="text/javascript" src="[% themelang %]/lib/jquery/plugins/jquery.dataTables.columnFilter.js"></script>
137	<link rel="stylesheet" type="text/css" href="[% themelang %]/css/datatables.css" />
138	<link rel="stylesheet" type="text/css" href="[% themelang %]/css/itemsearchform.css" />
139	<script type="text/javascript">
140	//<![CDATA[
141	var authorised_values = [% authorised_values_json %];
142
143	function loadAuthorisedValuesSelect(select) {
144	var selected = select.find('option:selected');
145	var category = selected.data('authorised-values-category');
146	var form_field_value = select.siblings('.form-field-value');
147	if (category && category in authorised_values) {
148	var values = authorised_values[category];
149	var html = '<select name="q" class="form-field-value">\n';
150	for (i in values) {
151	var value = values[i];
152	html += '<option value="' + value.authorised_value + '">' + value.lib + '</option>\n';
153	}
154	html += '</select>\n';
155	var new_form_field_value = $(html);
156	new_form_field_value.val(form_field_value.val());
157	form_field_value.replaceWith(new_form_field_value);
158	} else {
159	if (form_field_value.prop('tagName').toLowerCase() == 'select') {
160	html = '<input name="q" type="text" class="form-field-value" />';
161	var new_form_field_value = $(html);
162	form_field_value.replaceWith(new_form_field_value);
163	}
164	}
165	}
166
167	function addNewField() {
168	var form_field = $('div.form-field-select-text').last();
169	var copy = form_field.clone(true);
170	copy.find('input,select').not('[type="hidden"]').each(function() {
171	$(this).val('');
172	});
173	copy.find('.form-field-conjunction').removeAttr('disabled');
174	form_field.after(copy);
175	copy.find('select.form-field-column').change();
176	}
177
178	function submitForm($form) {
179	var tr = ''
180	+ ' <tr>'
181	+ ' <th>' + _("Bibliographic reference") + '</th>'
182	+ ' <th>' + _("Publication date") + '</th>'
183	+ ' <th>' + _("Publisher") + '</th>'
184	+ ' <th>' + _("Collection") + '</th>'
185	+ ' <th>' + _("Barcode") + '</th>'
186	+ ' <th>' + _("Callnumber") + '</th>'
187	+ ' <th>' + _("Home branch") + '</th>'
188	+ ' <th>' + _("Holding branch") + '</th>'
189	+ ' <th>' + _("Location") + '</th>'
190	+ ' <th>' + _("Stock number") + '</th>'
191	+ ' <th>' + _("Status") + '</th>'
192	+ ' <th>' + _("Issues") + '</th>'
193	+ ' <th></th>'
194	+ ' </tr>'
195	var table = ''
196	+ '<table id="results">'
197	+ ' <thead>' + tr + tr + '</thead>'
198	+ ' <tbody></tbody>'
199	+ '</table>';
200	$('#results-wrapper').empty().html(table);
201
202	var params = [];
203	$form.find('select,input[type="text"],input[type="hidden"]').not('[disabled]').each(function () {
204	params.push({ 'name': $(this).attr('name'), 'value': $(this).val() });
205	});
206	$form.find('input[type="radio"]:checked').each(function() {
207	params.push({ 'name': $(this).attr('name'), 'value': $(this).val() });
208	});
209
210	$('#results').dataTable($.extend(true, {}, dataTablesDefaults, {
211	'bDestroy': true,
212	'bServerSide': true,
213	'sAjaxSource': '/cgi-bin/koha/catalogue/itemsearch.pl',
214	'fnServerParams': function(aoData) {
215	aoData.push( { 'name': 'format', 'value': 'json' } );
216	for (i in params) {
217	aoData.push(params[i]);
218	}
219	},
220	'sDom': '<"top pager"ilp>t<"bottom pager"ip>',
221	'aoColumns': [
222	{ 'sName': 'title' },
223	{ 'sName': 'publicationyear' },
224	{ 'sName': 'publishercode' },
225	{ 'sName': 'collectiontitle' },
226	{ 'sName': 'barcode' },
227	{ 'sName': 'itemcallnumber' },
228	{ 'sName': 'homebranch' },
229	{ 'sName': 'holdingbranch' },
230	{ 'sName': 'location' },
231	{ 'sName': 'stocknumber' },
232	{ 'sName': 'notforloan' },
233	{ 'sName': 'issues' },
234	{ 'sName': 'checkbox', 'bSortable': false }
235	]
236	})).columnFilter({
237	'sPlaceHolder': 'head:after',
238	'aoColumns': [
239	{ 'type': 'text' },
240	{ 'type': 'text' },
241	{ 'type': 'text' },
242	{ 'type': 'text' },
243	{ 'type': 'text' },
244	{ 'type': 'text' },
245	{ 'type': 'select', 'values': [% branches.json %] },
246	{ 'type': 'select', 'values': [% branches.json %] },
247	{ 'type': 'select', 'values': [% locations.json %] },
248	{ 'type': 'text' },
249	{ 'type': 'select', 'values': [% notforloans.json %] },
250	{ 'type': 'text' },
251	null
252	]
253	});
254	}
255
256	function hideForm($form) {
257	$form.hide();
258	$('#editsearchlink').show();
259	}
260
261	$(document).ready(function () {
262	// Add the "New field" link.
263	var form_field = $('div.form-field-select-text').last()
264	var button_field_new = $('<a href="#" class="button-field-new" title="Add a new field">New field</a>');
265	button_field_new.click(function() {
266	addNewField();
267	return false;
268	});
269	form_field.after(button_field_new);
270
271	// If a field is linked to an authorised values list, display the list.
272	$('div.form-field-select-text select').change(function() {
273	loadAuthorisedValuesSelect($(this));
274	}).change();
275
276	// Prevent user to select the 'All ...' option with other options.
277	$('div.form-field-select').each(function() {
278	$(this).find('select').filter(':last').change(function() {
279	values = $(this).val();
280	if (values.length > 1) {
281	var idx = $.inArray('', values);
282	if (idx != -1) {
283	values.splice(idx, 1);
284	$(this).val(values);
285	}
286	}
287	});
288	});
289
290	$('#itemsearchform').submit(function() {
291	var format = $(this).find('input[name="format"]:checked').val();
292	if (format == 'html') {
293	submitForm($(this));
294	hideForm($(this));
295	return false;
296	}
297	});
298
299	$('#editsearchlink').click(function() {
300	$('#itemsearchform').show();
301	$(this).hide();
302	return false;
303	});
304	});
305	//]]>
306	</script>
307	</head>
308	<body id="catalog_itemsearch" class="catalog">
309	[% INCLUDE 'header.inc' %]
310	<div id="breadcrumbs">
311	<a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo; Item search
312	</div>
313
314	<div id="doc" class="yui-t7">
315	<div id="bd">
316	<h1>Item search</h1>
317	<a href="/cgi-bin/koha/catalogue/search.pl">Go to advanced search</a>
318	<form action="" method="get" id="itemsearchform">
319	<fieldset>
320	<legend>Item search</legend>
321	<fieldset>
322	[% INCLUDE form_field_select
323	name="homebranch"
324	label="Home branch"
325	options = branches
326	empty_option = "All branches"
327	%]
328	[% INCLUDE form_field_select
329	name="location"
330	label="Location"
331	options = locations
332	empty_option = "All locations"
333	%]
334	</fieldset>
335	<fieldset>
336	[% INCLUDE form_field_select
337	name="itype"
338	label="Item type"
339	options = itemtypes
340	empty_option = "All item types"
341	%]
342	[% INCLUDE form_field_select
343	name="ccode"
344	label="Collection code"
345	options = ccodes
346	empty_option = "All collection codes"
347	%]
348	</fieldset>
349	<fieldset>
350	[% INCLUDE form_field_select_text_block %]
351	<p class="hint">You can use the following joker characters: % _</p>
352	</fieldset>
353	<fieldset>
354	<div class="form-field">
355	<label class="form-field-label" for="itemcallnumber_from">From call number:</label>
356	[% value = CGI.param('itemcallnumber_from') %]
357	<input type="text" id="itemcallnumber_from" name="itemcallnumber_from" value="[% value %]" />
358	<span class="hint">(inclusive)</span>
359	</div>
360	<div class="form-field">
361	[% value = CGI.param('itemcallnumber_to') %]
362	<label class="form-field-label" for="itemcallnumber_to">To call number:</label>
363	<input type="text" id="itemcallnumber_to" name="itemcallnumber_to" value="[% value %]" />
364	<span class="hint">(inclusive)</span>
365	</div>
366	[% INCLUDE form_field_radio_yes_no name="damaged" label="Damaged" %]
367	[% INCLUDE form_field_radio_yes_no name="itemlost" label="Lost" %]
368	<div class="form-field">
369	<label class="form-field-label" for="issues">Issues count:</label>
370	<select id="issues_op" name="issues_op">
371	<option value=">">></option>
372	<option value="<"><</option>
373	<option value="=">=</option>
374	<option value="!=">!=</option>
375	</select>
376	<input type="text" name="issues" />
377	</div>
378	<div class="form-field">
379	<label class="form-field-label" for="datelastborrowed">Last issue date:</label>
380	<select id="datelastborrowed_op" name="datelastborrowed_op">
381	<option value=">">After</option>
382	<option value="<">Before</option>
383	<option value="=">On</option>
384	</select>
385	<input type="text" name="datelastborrowed" />
386	<span class="hint">ISO Format (AAAA-MM-DD)</span>
387	</div>
388	</fieldset>
389	<fieldset>
390	<div class="form-field-radio">
391	<label>Output:</label>
392	<input type="radio" id="format-html" name="format" value="html" checked="checked" /> <label for="format-html">Screen</label>
393	<input type="radio" id="format-csv" name="format" value="csv" /> <label for="format-csv">CSV</label>
394	</div>
395	<div class="form-actions">
396	<input type="submit" value="Search" />
397	</div>
398	</fieldset>
399	</fieldset>
400	</form>
401
402	<p><a id="editsearchlink" href="#" style="display:none">Edit search</a></p>
403
404	<div id="results-wrapper">
405	[% IF search_done %]
406
407	[% IF total_rows > 0 %]
408	<p>Found [% total_rows %] results.</p>
409	[% ELSE %]
410	<p>No results found.</p>
411	[% END %]
412
413	[% IF results %]
414	[% INCLUDE 'catalogue/itemsearch_items.inc' items = results %]
415	[% END %]
416
417	<div id="pagination-bar">
418	[% pagination_bar %]
419	</div>
420
421	[% END %]
422	</div>
423	</div>
424
425	[% INCLUDE 'intranet-bottom.inc' %]