|
Lines 407-413
subtest q{Test Koha::Database->schema()->resultset('Item')->itemtype()} => sub {
Link Here
|
| 407 |
}; |
407 |
}; |
| 408 |
|
408 |
|
| 409 |
subtest 'SearchItems test' => sub { |
409 |
subtest 'SearchItems test' => sub { |
| 410 |
plan tests => 15; |
410 |
plan tests => 17; |
| 411 |
|
411 |
|
| 412 |
$schema->storage->txn_begin; |
412 |
$schema->storage->txn_begin; |
| 413 |
my $dbh = C4::Context->dbh; |
413 |
my $dbh = C4::Context->dbh; |
|
Lines 605-610
subtest 'SearchItems test' => sub {
Link Here
|
| 605 |
($items, $total_results) = SearchItems($filter); |
605 |
($items, $total_results) = SearchItems($filter); |
| 606 |
is($total_results, 1, "Search items.issues issues = 0 returns result (items.issues defaults to 0)"); |
606 |
is($total_results, 1, "Search items.issues issues = 0 returns result (items.issues defaults to 0)"); |
| 607 |
|
607 |
|
|
|
608 |
# Is null |
| 609 |
$filter = { |
| 610 |
conjunction => 'AND', |
| 611 |
filters => [ |
| 612 |
{ |
| 613 |
field => 'new_status', |
| 614 |
query => 0, |
| 615 |
operator => '=' |
| 616 |
}, |
| 617 |
{ |
| 618 |
field => 'homebranch', |
| 619 |
query => $library1->{branchcode}, |
| 620 |
operator => '=', |
| 621 |
}, |
| 622 |
], |
| 623 |
}; |
| 624 |
($items, $total_results) = SearchItems($filter); |
| 625 |
is($total_results, 0, 'found no item with new_status=0 without ifnull'); |
| 626 |
|
| 627 |
$filter->{filters}[0]->{ifnull} = 0; |
| 628 |
($items, $total_results) = SearchItems($filter); |
| 629 |
is($total_results, 1, 'found all items of library1 with new_status=0 with ifnull = 0'); |
| 630 |
|
| 608 |
$schema->storage->txn_rollback; |
631 |
$schema->storage->txn_rollback; |
| 609 |
}; |
632 |
}; |
| 610 |
|
633 |
|
| 611 |
- |
|
|