|
Lines 225-230
sub filter_by_bookable {
Link Here
|
| 225 |
); |
225 |
); |
| 226 |
} |
226 |
} |
| 227 |
|
227 |
|
|
|
228 |
sub filter_by_checked_out { |
| 229 |
my ( $self, $params ) = @_; |
| 230 |
|
| 231 |
$params //= {}; |
| 232 |
my $checkouts = Koha::Checkouts->search( |
| 233 |
{ %$params, 'me.itemnumber' => [ $self->get_column('itemnumber') ], }, |
| 234 |
{ |
| 235 |
columns => ['itemnumber'], |
| 236 |
distinct => 1 |
| 237 |
} |
| 238 |
)->_resultset->as_query; |
| 239 |
|
| 240 |
return $self->search( { 'me.itemnumber' => { '-in' => $checkouts } } ); |
| 241 |
} |
| 242 |
|
| 243 |
sub filter_by_in_transit { |
| 244 |
my ( $self, $params ) = @_; |
| 245 |
|
| 246 |
$params //= {}; |
| 247 |
my $transfers = Koha::Item::Transfers->search( |
| 248 |
{ %$params, 'me.itemnumber' => [ $self->get_column('itemnumber') ], }, |
| 249 |
{ |
| 250 |
columns => ['itemnumber'], |
| 251 |
distinct => 1 |
| 252 |
} |
| 253 |
)->_resultset->as_query; |
| 254 |
|
| 255 |
return $self->search( { 'me.itemnumber' => { '-in' => $transfers } } ); |
| 256 |
} |
| 257 |
|
| 258 |
sub filter_by_for_loan { |
| 259 |
|
| 260 |
} |
| 261 |
|
| 262 |
sub filter_by_has_holds { |
| 263 |
my ( $self, $params ) = @_; |
| 264 |
|
| 265 |
$params //= {}; |
| 266 |
my $holds = Koha::Holds->search( |
| 267 |
{ %$params, 'me.itemnumber' => [ $self->get_column('itemnumber') ], }, |
| 268 |
{ |
| 269 |
columns => ['itemnumber'], |
| 270 |
distinct => 1 |
| 271 |
} |
| 272 |
)->_resultset->as_query; |
| 273 |
|
| 274 |
return $self->search( { 'me.itemnumber' => { '-in' => $holds } } ); |
| 275 |
} |
| 276 |
|
| 277 |
sub filter_by_has_recalls { |
| 278 |
my ( $self, $params ) = @_; |
| 279 |
|
| 280 |
$params //= {}; |
| 281 |
my $recalls = Koha::Recalls->search( |
| 282 |
{ %$params, 'me.itemnumber' => [ $self->get_column('itemnumber') ], }, |
| 283 |
{ |
| 284 |
columns => ['itemnumber'], |
| 285 |
distinct => 1 |
| 286 |
} |
| 287 |
)->_resultset->as_query; |
| 288 |
|
| 289 |
return $self->search( { 'me.itemnumber' => { '-in' => $recalls } } ); |
| 290 |
} |
| 291 |
|
| 292 |
sub filter_by_available { |
| 293 |
my ($self) = @_; |
| 294 |
|
| 295 |
my @all_itemnumbers = $self->get_column('itemnumber'); |
| 296 |
my @item_types_notforloan = Koha::ItemTypes->search( { notforloan => { '!=' => 0 } } )->get_column('itemtype'); |
| 297 |
my @not_available_itemnumbers; |
| 298 |
push @not_available_itemnumbers, $self->filter_by_checked_out->get_column('itemnumber'); |
| 299 |
push @not_available_itemnumbers, $self->filter_by_in_transit->get_column('itemnumber'); |
| 300 |
push @not_available_itemnumbers, $self->search( |
| 301 |
{ |
| 302 |
itemlost => 0, withdrawn => 0, damaged => 0, notforloan => 0, |
| 303 |
itype => { -not_in => \@item_types_notforloan }, restricted => 0, |
| 304 |
} |
| 305 |
)->get_column('itemnumber'); |
| 306 |
push @not_available_itemnumbers, $self->filter_by_has_holds->get_column('itemnumber'); |
| 307 |
push @not_available_itemnumbers, $self->filter_by_has_recalls->get_column('itemnumber'); |
| 308 |
|
| 309 |
return Koha::Items->search( { 'me.itemnumber' => [ array_minus @all_itemnumbers, @not_available_itemnumbers ] } ); |
| 310 |
} |
| 311 |
|
| 228 |
=head3 move_to_biblio |
312 |
=head3 move_to_biblio |
| 229 |
|
313 |
|
| 230 |
$items->move_to_biblio($to_biblio); |
314 |
$items->move_to_biblio($to_biblio); |
|
Lines 492-497
sub apply_regex {
Link Here
|
| 492 |
return $value; |
576 |
return $value; |
| 493 |
} |
577 |
} |
| 494 |
|
578 |
|
|
|
579 |
sub search { |
| 580 |
my ( $self, $params, $attributes ) = @_; |
| 581 |
my $status = ( $params && ref($params) eq 'HASH' ) ? delete $params->{_status} : undef; |
| 582 |
if ($status) { |
| 583 |
if ( $status eq 'checked_out' ) { |
| 584 |
$self = $self->filter_by_checked_out( { onsite_checkout => 0 } ); |
| 585 |
} |
| 586 |
if ( $status eq 'local_use' ) { |
| 587 |
$self = $self->filter_by_checked_out( { onsite_checkout => 1 } ); |
| 588 |
} |
| 589 |
if ( $status eq 'in_transit' ) { |
| 590 |
$self = $self->filter_by_in_transit; |
| 591 |
} |
| 592 |
if ( $status eq 'lost' ) { |
| 593 |
$self = $self->search( { itemlost => { '!=' => 0 } } ); |
| 594 |
} |
| 595 |
if ( $status eq 'withdrawn' ) { |
| 596 |
$self = $self->search( { withdrawn => { '!=' => 0 } } ); |
| 597 |
} |
| 598 |
if ( $status eq 'damaged' ) { |
| 599 |
$self = $self->search( { damaged => { '!=' => 0 } } ); |
| 600 |
} |
| 601 |
if ( $status eq 'not_for_loan' ) { |
| 602 |
my @item_types_notforloan = |
| 603 |
Koha::ItemTypes->search( { notforloan => { '!=' => 0 } } )->get_column('itemtype'); |
| 604 |
$self = $self->search( [ { notforloan => { '!=' => 0 } }, { 'me.itype' => \@item_types_notforloan } ] ); |
| 605 |
} |
| 606 |
if ( $status eq 'on_hold' ) { |
| 607 |
$self = $self->filter_by_has_holds; |
| 608 |
} |
| 609 |
if ( $status eq 'recalled' ) { |
| 610 |
$self = $self->filter_by_has_recalls; |
| 611 |
} |
| 612 |
|
| 613 |
if ( $status eq 'available' ) { |
| 614 |
$self = $self->filter_by_available; |
| 615 |
} |
| 616 |
|
| 617 |
if ( $status eq 'restricted' ) { |
| 618 |
$self = $self->search( { restricted => { '!=' => 0 } } ); |
| 619 |
} |
| 620 |
} |
| 621 |
|
| 622 |
return $self->SUPER::search( $params, $attributes ); |
| 623 |
} |
| 624 |
|
| 495 |
=head3 search_ordered |
625 |
=head3 search_ordered |
| 496 |
|
626 |
|
| 497 |
$items->search_ordered; |
627 |
$items->search_ordered; |