1 -- Evergreen DB patch XXXX.lp790329_opac_lasso_counts.sql
3 -- Resolves an error in calculating copy counts for org lassos
9 -- check whether patch can be applied
10 SELECT evergreen.upgrade_deps_block_check('0603', :eg_version);
12 -- FIXME: add/check SQL statements to perform the upgrade
13 CREATE OR REPLACE FUNCTION asset.opac_lasso_record_copy_count (i_lasso INT, rid BIGINT) RETURNS TABLE (depth INT, org_unit INT, visible BIGINT, available BIGINT, unshadow BIGINT, transcendant INT) AS $f$
18 SELECT 1 INTO trans FROM biblio.record_entry b JOIN config.bib_source src ON (b.source = src.id) WHERE src.transcendant AND b.id = rid;
20 FOR ans IN SELECT u.org_unit AS id FROM actor.org_lasso_map AS u WHERE lasso = i_lasso LOOP
25 SUM( CASE WHEN cp.status IN (0,7,12) THEN 1 ELSE 0 END ),
29 actor.org_unit_descendants(ans.id) d
30 JOIN asset.opac_visible_copies av ON (av.record = rid AND av.circ_lib = d.id)
31 JOIN asset.copy cp ON (cp.id = av.copy_id)
35 RETURN QUERY SELECT -1, ans.id, 0::BIGINT, 0::BIGINT, 0::BIGINT, trans;