From 9ff852bed41ddec318264cd93149c802711c9776 Mon Sep 17 00:00:00 2001 From: miker Date: Thu, 19 Jun 2008 04:21:45 +0000 Subject: [PATCH] more switching to opac_visible on status git-svn-id: svn://svn.open-ils.org/ILS/trunk@9865 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- .../OpenILS/Application/Search/Biblio.pm | 2 +- .../Application/Storage/Publisher/biblio.pm | 8 ++++---- .../Application/Storage/Publisher/metabib.pm | 20 +++++++++---------- 3 files changed, 15 insertions(+), 15 deletions(-) diff --git a/Open-ILS/src/perlmods/OpenILS/Application/Search/Biblio.pm b/Open-ILS/src/perlmods/OpenILS/Application/Search/Biblio.pm index 5ddd0087ed..367e3cdc25 100644 --- a/Open-ILS/src/perlmods/OpenILS/Application/Search/Biblio.pm +++ b/Open-ILS/src/perlmods/OpenILS/Application/Search/Biblio.pm @@ -1699,7 +1699,7 @@ sub copies_by_cn_label { ); # ... and test for location and status visibility - return [ map { ($U->is_true($_->location->opac_visible) && $U->is_true($_->status->holdable)) ? ($_->id) : () } @$copies ]; + return [ map { ($U->is_true($_->location->opac_visible) && $U->is_true($_->status->opac_visible)) ? ($_->id) : () } @$copies ]; } diff --git a/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/biblio.pm b/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/biblio.pm index 6dece0a196..11836856b7 100644 --- a/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/biblio.pm +++ b/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/biblio.pm @@ -30,7 +30,7 @@ sub record_copy_count { $ancestors = "(select org_unit as id from actor.org_lasso_map where lasso = ?) u CROSS JOIN (SELECT -1 AS depth) t"; } - my $visible = 'AND a.opac_visible = TRUE AND st.holdable = TRUE AND loc.opac_visible = TRUE AND cp.opac_visible = TRUE'; + my $visible = 'AND a.opac_visible = TRUE AND st.opac_visible = TRUE AND loc.opac_visible = TRUE AND cp.opac_visible = TRUE'; if ($self->api_name =~ /staff/o) { $visible = '' } @@ -70,7 +70,7 @@ sub record_copy_count { JOIN $st_table st ON (cp.status = st.id) JOIN $loc_table loc ON (cp.location = loc.id) WHERE cn.record = ? - AND st.holdable = TRUE + AND st.opac_visible = TRUE AND loc.opac_visible = TRUE AND cp.opac_visible = TRUE AND cn.deleted IS FALSE @@ -318,7 +318,7 @@ sub global_record_copy_count { my $cl_table = asset::copy_location->table; my $cs_table = config::copy_status->table; - my $copies_visible = 'AND cp.opac_visible IS TRUE AND cs.holdable IS TRUE AND cl.opac_visible IS TRUE'; + my $copies_visible = 'AND cp.opac_visible IS TRUE AND cs.opac_visible IS TRUE AND cl.opac_visible IS TRUE'; $copies_visible = '' if ($self->api_name =~ /staff/o); my $sql = <<" SQL"; @@ -400,7 +400,7 @@ sub record_copy_status_count { AND cl.opac_visible IS TRUE AND cp.opac_visible IS TRUE AND cp.deleted IS FALSE - AND cs.holdable + AND cs.opac_visible IS TRUE GROUP BY 1,2,3; SQL diff --git a/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/metabib.pm b/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/metabib.pm index 797d4ee0ee..c095160cc3 100644 --- a/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/metabib.pm +++ b/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/metabib.pm @@ -38,7 +38,7 @@ sub ordered_records_from_metarecord { "actor.org_unit_descendants($org)" ; - my $copies_visible = 'AND d.opac_visible IS TRUE AND cp.opac_visible IS TRUE AND cs.holdable IS TRUE AND cl.opac_visible IS TRUE'; + my $copies_visible = 'AND d.opac_visible IS TRUE AND cp.opac_visible IS TRUE AND cs.opac_visible IS TRUE AND cl.opac_visible IS TRUE'; $copies_visible = '' if ($self->api_name =~ /staff/o); my $sm_table = metabib::metarecord_source_map->table; @@ -279,7 +279,7 @@ sub metarecord_copy_count { $ancestors = "(select org_unit as id from actor.org_lasso_map where lasso = ?) u CROSS JOIN (SELECT -1 AS depth) t"; } - my $copies_visible = 'AND a.opac_visible IS TRUE AND cp.opac_visible IS TRUE AND cs.holdable IS TRUE AND cl.opac_visible IS TRUE'; + my $copies_visible = 'AND a.opac_visible IS TRUE AND cp.opac_visible IS TRUE AND cs.opac_visible IS TRUE AND cl.opac_visible IS TRUE'; $copies_visible = '' if ($self->api_name =~ /staff/o); my (@types,@forms,@blvl); @@ -356,7 +356,7 @@ sub metarecord_copy_count { AND cn.deleted IS FALSE AND cp.deleted IS FALSE AND cp.opac_visible IS TRUE - AND cs.holdable IS TRUE + AND cs.opac_visible IS TRUE AND cl.opac_visible IS TRUE $t_filter $f_filter @@ -476,7 +476,7 @@ sub biblio_multi_search_full_rec { my $has_vols = 'AND cn.owning_lib = d.id'; my $has_copies = 'AND cp.call_number = cn.id'; - my $copies_visible = 'AND d.opac_visible IS TRUE AND cp.opac_visible IS TRUE AND cs.holdable IS TRUE AND cl.opac_visible IS TRUE'; + my $copies_visible = 'AND d.opac_visible IS TRUE AND cp.opac_visible IS TRUE AND cs.opac_visible IS TRUE AND cl.opac_visible IS TRUE'; if ($self->api_name =~ /staff/o) { $copies_visible = ''; @@ -796,7 +796,7 @@ sub search_class_fts { my $has_vols = 'AND cn.owning_lib = d.id'; my $has_copies = 'AND cp.call_number = cn.id'; - my $copies_visible = 'AND d.opac_visible IS TRUE AND cp.opac_visible IS TRUE AND cs.holdable IS TRUE AND cl.opac_visible IS TRUE'; + my $copies_visible = 'AND d.opac_visible IS TRUE AND cp.opac_visible IS TRUE AND cs.opac_visible IS TRUE AND cl.opac_visible IS TRUE'; my $visible_count = ', count(DISTINCT cp.id)'; my $visible_count_test = 'HAVING count(DISTINCT cp.id) > 0'; @@ -970,7 +970,7 @@ sub search_class_fts_count { my $has_vols = 'AND cn.owning_lib = d.id'; my $has_copies = 'AND cp.call_number = cn.id'; - my $copies_visible = 'AND d.opac_visible IS TRUE AND cp.opac_visible IS TRUE AND cs.holdable IS TRUE AND cl.opac_visible IS TRUE'; + my $copies_visible = 'AND d.opac_visible IS TRUE AND cp.opac_visible IS TRUE AND cs.opac_visible IS TRUE AND cl.opac_visible IS TRUE'; if ($self->api_name =~ /staff/o) { $copies_visible = ''; $has_vols = '' if ($ou_type == 0); @@ -1267,7 +1267,7 @@ sub postfilter_search_class_fts { AND cn.owning_lib = d.id AND cp.call_number = cn.id AND cp.opac_visible IS TRUE - AND cs.holdable IS TRUE + AND cs.opac_visible IS TRUE AND cl.opac_visible IS TRUE AND d.opac_visible IS TRUE AND br.active IS TRUE @@ -1304,7 +1304,7 @@ sub postfilter_search_class_fts { AND cp.circ_lib = d.id AND cp.call_number = cn.id AND cp.opac_visible IS TRUE - AND cs.holdable IS TRUE + AND cs.opac_visible IS TRUE AND cl.opac_visible IS TRUE AND d.opac_visible IS TRUE AND br.active IS TRUE @@ -1760,7 +1760,7 @@ sub postfilter_search_multi_class_fts { AND cp.circ_lib = d.id AND cp.call_number = cn.id AND cp.opac_visible IS TRUE - AND cs.holdable IS TRUE + AND cs.opac_visible IS TRUE AND cl.opac_visible IS TRUE AND d.opac_visible IS TRUE AND br.active IS TRUE @@ -2235,7 +2235,7 @@ sub biblio_search_multi_class_fts { AND cp.location = cl.id AND cp.call_number = cn.id AND cp.opac_visible IS TRUE - AND cs.holdable IS TRUE + AND cs.opac_visible IS TRUE AND cl.opac_visible IS TRUE AND d.opac_visible IS TRUE AND cp.deleted IS FALSE -- 2.43.2