From bceda9b030891be15e68a1eb582401501bb99ae3 Mon Sep 17 00:00:00 2001 From: Ben Ostrowsky Date: Tue, 18 Oct 2011 15:19:20 +0000 Subject: [PATCH 1/1] Added new helper utility: migration_tools.refresh_opac_visible_copies --- sql/base/base.sql | 30 ++++++++++++++++++++++++++++++ 1 files changed, 30 insertions(+), 0 deletions(-) diff --git a/sql/base/base.sql b/sql/base/base.sql index 905d1cf..18d0465 100644 --- a/sql/base/base.sql +++ b/sql/base/base.sql @@ -1266,3 +1266,33 @@ BEGIN END; $$ LANGUAGE plpgsql; + + +CREATE OR REPLACE FUNCTION migration_tools.refresh_opac_visible_copies ( ) RETURNS VOID AS $$ + +BEGIN + + TRUNCATE asset.opac_visible_copies; + + INSERT INTO asset.opac_visible_copies (id, circ_lib, record) + SELECT + cp.id, cp.circ_lib, cn.record + FROM + asset.copy cp + JOIN asset.call_number cn ON (cn.id = cp.call_number) + 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) + JOIN biblio.record_entry b ON (cn.record = b.id) + WHERE + NOT cp.deleted AND + NOT cn.deleted AND + NOT b.deleted AND + cs.opac_visible AND + cl.opac_visible AND + cp.opac_visible AND + a.opac_visible; + +END; + +$$ LANGUAGE plpgsql; -- 1.7.2.5