From: Ben Ostrowsky <ben@esilibrary.com>
Date: Tue, 18 Oct 2011 15:19:20 +0000 (+0000)
Subject: Added new helper utility:  migration_tools.refresh_opac_visible_copies
X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=bceda9b030891be15e68a1eb582401501bb99ae3

Added new helper utility:  migration_tools.refresh_opac_visible_copies
---

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;