X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=sql%2Fbase%2Fbase.sql;h=18d04653b8d794059a6856804badf4c46e46d5d0;hp=905d1cfd62e56173a553c5815dd752005941d5e4;hb=bceda9b030891be15e68a1eb582401501bb99ae3;hpb=936eaf7f5b79a8af1139d9fb029b325425668bc2

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;