From 94a45267c5445bea87f91a37ae84eea2911a0986 Mon Sep 17 00:00:00 2001 From: miker Date: Thu, 20 Mar 2008 02:50:12 +0000 Subject: [PATCH] adding extra staff checks for record visibility git-svn-id: svn://svn.open-ils.org/ILS/trunk@9094 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- .../src/sql/Pg/300.schema.staged_search.sql | 29 +++++++++++++++++++ 1 file changed, 29 insertions(+) diff --git a/Open-ILS/src/sql/Pg/300.schema.staged_search.sql b/Open-ILS/src/sql/Pg/300.schema.staged_search.sql index 89d1f7821a..5dd9ad1ac5 100644 --- a/Open-ILS/src/sql/Pg/300.schema.staged_search.sql +++ b/Open-ILS/src/sql/Pg/300.schema.staged_search.sql @@ -437,6 +437,35 @@ BEGIN CONTINUE; END IF; + ELSE + + PERFORM 1 + FROM asset.call_number cn + JOIN asset.copy cp ON (cp.call_number = cn.id) + JOIN actor.org_unit a ON (cp.circ_lib = a.id) + JOIN asset.copy_location cl ON (cp.location = cl.id) + JOIN config.copy_status cs ON (cp.status = cs.id) + WHERE NOT cn.deleted + AND NOT cp.deleted + AND cp.circ_lib IN ( SELECT * FROM search.explode_array( search_org_list ) ) + AND cn.record IN ( SELECT * FROM search.explode_array( core_result.records ) ) + LIMIT 1; + + IF NOT FOUND THEN + + PERFORM 1 + FROM asset.call_number cn + WHERE cn.record IN ( SELECT * FROM search.explode_array( core_result.records ) ) + LIMIT 1; + + IF FOUND THEN + -- RAISE NOTICE ' % were all visibility-excluded ... ', core_result.records; + excluded_count := excluded_count + 1; + CONTINUE; + END IF; + + END IF; + END IF; visible_count := visible_count + 1; -- 2.43.2