Bug 24502: object.search also filter by prefetched columns
[koha.git] / Koha / REST / Plugin / Objects.pm
1 package Koha::REST::Plugin::Objects;
2
3 # This file is part of Koha.
4 #
5 # Koha is free software; you can redistribute it and/or modify it
6 # under the terms of the GNU General Public License as published by
7 # the Free Software Foundation; either version 3 of the License, or
8 # (at your option) any later version.
9 #
10 # Koha is distributed in the hope that it will be useful, but
11 # WITHOUT ANY WARRANTY; without even the implied warranty of
12 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13 # GNU General Public License for more details.
14 #
15 # You should have received a copy of the GNU General Public License
16 # along with Koha; if not, see <http://www.gnu.org/licenses>.
17
18 use Modern::Perl;
19
20 use Mojo::Base 'Mojolicious::Plugin';
21
22 use JSON qw(decode_json);
23
24 =head1 NAME
25
26 Koha::REST::Plugin::Objects
27
28 =head1 API
29
30 =head2 Helper methods
31
32 =head3 objects.search
33
34     my $patrons_rs = Koha::Patrons->new;
35     my $patrons = $c->objects->search( $patrons_rs );
36
37 Performs a database search using given Koha::Objects object and query parameters.
38
39 Returns an arrayref of the hashrefs representing the resulting objects
40 for API rendering.
41
42 =cut
43
44 sub register {
45     my ( $self, $app ) = @_;
46
47     $app->helper(
48         'objects.search' => sub {
49             my ( $c, $result_set ) = @_;
50
51             my $args = $c->validation->output;
52             my $attributes = {};
53
54             # Extract reserved params
55             my ( $filtered_params, $reserved_params, $path_params ) = $c->extract_reserved_params($args);
56             # Look for embeds
57             my $embed = $c->stash('koha.embed');
58
59             # Merge sorting into query attributes
60             $c->dbic_merge_sorting(
61                 {
62                     attributes => $attributes,
63                     params     => $reserved_params,
64                     result_set => $result_set
65                 }
66             );
67
68             # Merge pagination into query attributes
69             $c->dbic_merge_pagination(
70                 {
71                     filter => $attributes,
72                     params => $reserved_params
73                 }
74             );
75
76             # Generate prefetches for embedded stuff
77             $c->dbic_merge_prefetch(
78                 {
79                     attributes => $attributes,
80                     result_set => $result_set
81                 }
82             );
83
84             # Call the to_model function by reference, if defined
85             if ( defined $filtered_params ) {
86
87                 # Apply the mapping function to the passed params
88                 $filtered_params = $result_set->attributes_from_api($filtered_params);
89                 $filtered_params = $c->build_query_params( $filtered_params, $reserved_params );
90             }
91
92             if ( defined $path_params ) {
93
94                 # Apply the mapping function to the passed params
95                 $filtered_params //= {};
96                 $path_params = $result_set->attributes_from_api($path_params);
97                 foreach my $param (keys %{$path_params}) {
98                     $filtered_params->{$param} = $path_params->{$param};
99                 }
100             }
101
102             if( defined $reserved_params->{q} || defined $reserved_params->{query} || defined $reserved_params->{'x-koha-query'}) {
103                 $filtered_params //={};
104                 my @query_params_array;
105                 my $query_params;
106                 push @query_params_array, $reserved_params->{query} if defined $reserved_params->{query};
107                 push @query_params_array, decode_json($reserved_params->{q}) if defined $reserved_params->{q};
108                 push @query_params_array, decode_json($reserved_params->{'x-koha-query'}) if defined $reserved_params->{'x-koha-query'};
109
110                 if(scalar(@query_params_array) > 1) {
111                     $query_params = {'-and' => \@query_params_array};
112                 } else {
113                     $query_params = $query_params_array[0];
114                 }
115
116                 $filtered_params = $c->merge_q_params( $filtered_params, $query_params, $result_set );
117             }
118             # Perform search
119             my $objects = $result_set->search( $filtered_params, $attributes );
120
121             if ($objects->is_paged) {
122                 $c->add_pagination_headers({
123                     total => $objects->pager->total_entries,
124                     params => $args,
125                 });
126             }
127
128             return $objects->to_api({ embed => $embed });
129         }
130     );
131 }
132
133 1;