2 CREATE OR REPLACE FUNCTION search.query_parser_fts (
15 param_pref_ou INT DEFAULT NULL
16 ) RETURNS SETOF search.search_result AS $func$
19 current_res search.search_result%ROWTYPE;
20 search_org_list INT[];
30 core_cursor REFCURSOR;
35 deleted_count INT := 0;
36 visible_count INT := 0;
37 excluded_count INT := 0;
42 check_limit := COALESCE( param_check, 1000 );
43 core_limit := COALESCE( param_limit, 25000 );
44 core_offset := COALESCE( param_offset, 0 );
46 SELECT COALESCE( enabled, FALSE ) INTO luri_as_copy FROM config.global_flag WHERE name = 'opac.located_uri.act_as_copy';
48 -- core_skip_chk := COALESCE( param_skip_chk, 1 );
50 IF param_search_ou > 0 THEN
51 IF param_depth IS NOT NULL THEN
52 SELECT ARRAY_AGG(distinct id) INTO search_org_list FROM actor.org_unit_descendants( param_search_ou, param_depth );
54 SELECT ARRAY_AGG(distinct id) INTO search_org_list FROM actor.org_unit_descendants( param_search_ou );
58 SELECT ARRAY_AGG(distinct id) INTO luri_org_list FROM actor.org_unit_full_path( param_search_ou );
60 SELECT ARRAY_AGG(distinct id) INTO luri_org_list FROM actor.org_unit_ancestors( param_search_ou );
63 ELSIF param_search_ou < 0 THEN
64 SELECT ARRAY_AGG(distinct org_unit) INTO search_org_list FROM actor.org_lasso_map WHERE lasso = -param_search_ou;
66 FOR tmp_int IN SELECT * FROM UNNEST(search_org_list) LOOP
69 SELECT ARRAY_AGG(distinct id) INTO tmp_int_list FROM actor.org_unit_full_path( tmp_int );
71 SELECT ARRAY_AGG(distinct id) INTO tmp_int_list FROM actor.org_unit_ancestors( tmp_int );
74 luri_org_list := luri_org_list || tmp_int_list;
77 SELECT ARRAY_AGG(DISTINCT x.id) INTO luri_org_list FROM UNNEST(luri_org_list) x(id);
79 ELSIF param_search_ou = 0 THEN
80 -- reserved for user lassos (ou_buckets/type='lasso') with ID passed in depth ... hack? sure.
83 IF param_pref_ou IS NOT NULL THEN
85 SELECT ARRAY_AGG(distinct id) INTO tmp_int_list FROM actor.org_unit_full_path( param_pref_ou );
87 SELECT ARRAY_AGG(distinct id) INTO tmp_int_list FROM actor.org_unit_ancestors( param_pref_ou );
90 luri_org_list := luri_org_list || tmp_int_list;
93 OPEN core_cursor FOR EXECUTE param_query;
97 FETCH core_cursor INTO core_result;
99 EXIT WHEN total_count >= core_limit;
101 total_count := total_count + 1;
103 CONTINUE WHEN total_count NOT BETWEEN core_offset + 1 AND check_limit + core_offset;
105 check_count := check_count + 1;
107 IF NOT deleted_search THEN
109 PERFORM 1 FROM biblio.record_entry b WHERE NOT b.deleted AND b.id IN ( SELECT * FROM unnest( core_result.records ) );
111 -- RAISE NOTICE ' % were all deleted ... ', core_result.records;
112 deleted_count := deleted_count + 1;
117 FROM biblio.record_entry b
118 JOIN config.bib_source s ON (b.source = s.id)
120 AND b.id IN ( SELECT * FROM unnest( core_result.records ) );
123 -- RAISE NOTICE ' % were all transcendant ... ', core_result.records;
124 visible_count := visible_count + 1;
126 current_res.id = core_result.id;
127 current_res.rel = core_result.rel;
131 SELECT COUNT(DISTINCT s.source) INTO tmp_int FROM metabib.metarecord_source_map s WHERE s.metarecord = core_result.id;
135 current_res.record = core_result.records[1];
137 current_res.record = NULL;
140 RETURN NEXT current_res;
146 FROM asset.call_number cn
147 JOIN asset.uri_call_number_map map ON (map.call_number = cn.id)
148 JOIN asset.uri uri ON (map.uri = uri.id)
150 AND cn.label = '##URI##'
152 AND ( param_locations IS NULL OR array_upper(param_locations, 1) IS NULL )
153 AND cn.record IN ( SELECT * FROM unnest( core_result.records ) )
154 AND cn.owning_lib IN ( SELECT * FROM unnest( luri_org_list ) )
158 -- RAISE NOTICE ' % have at least one URI ... ', core_result.records;
159 visible_count := visible_count + 1;
161 current_res.id = core_result.id;
162 current_res.rel = core_result.rel;
166 SELECT COUNT(DISTINCT s.source) INTO tmp_int FROM metabib.metarecord_source_map s WHERE s.metarecord = core_result.id;
170 current_res.record = core_result.records[1];
172 current_res.record = NULL;
175 RETURN NEXT current_res;
180 IF param_statuses IS NOT NULL AND array_upper(param_statuses, 1) > 0 THEN
183 FROM asset.call_number cn
184 JOIN asset.copy cp ON (cp.call_number = cn.id)
187 AND cp.status IN ( SELECT * FROM unnest( param_statuses ) )
188 AND cn.record IN ( SELECT * FROM unnest( core_result.records ) )
189 AND cp.circ_lib IN ( SELECT * FROM unnest( search_org_list ) )
194 FROM biblio.peer_bib_copy_map pr
195 JOIN asset.copy cp ON (cp.id = pr.target_copy)
197 AND cp.status IN ( SELECT * FROM unnest( param_statuses ) )
198 AND pr.peer_record IN ( SELECT * FROM unnest( core_result.records ) )
199 AND cp.circ_lib IN ( SELECT * FROM unnest( search_org_list ) )
203 -- RAISE NOTICE ' % and multi-home linked records were all status-excluded ... ', core_result.records;
204 excluded_count := excluded_count + 1;
211 IF param_locations IS NOT NULL AND array_upper(param_locations, 1) > 0 THEN
214 FROM asset.call_number cn
215 JOIN asset.copy cp ON (cp.call_number = cn.id)
218 AND cp.location IN ( SELECT * FROM unnest( param_locations ) )
219 AND cn.record IN ( SELECT * FROM unnest( core_result.records ) )
220 AND cp.circ_lib IN ( SELECT * FROM unnest( search_org_list ) )
225 FROM biblio.peer_bib_copy_map pr
226 JOIN asset.copy cp ON (cp.id = pr.target_copy)
228 AND cp.location IN ( SELECT * FROM unnest( param_locations ) )
229 AND pr.peer_record IN ( SELECT * FROM unnest( core_result.records ) )
230 AND cp.circ_lib IN ( SELECT * FROM unnest( search_org_list ) )
234 -- RAISE NOTICE ' % and multi-home linked records were all copy_location-excluded ... ', core_result.records;
235 excluded_count := excluded_count + 1;
242 IF staff IS NULL OR NOT staff THEN
245 FROM asset.opac_visible_copies
246 WHERE circ_lib IN ( SELECT * FROM unnest( search_org_list ) )
247 AND record IN ( SELECT * FROM unnest( core_result.records ) )
252 FROM biblio.peer_bib_copy_map pr
253 JOIN asset.opac_visible_copies cp ON (cp.copy_id = pr.target_copy)
254 WHERE cp.circ_lib IN ( SELECT * FROM unnest( search_org_list ) )
255 AND pr.peer_record IN ( SELECT * FROM unnest( core_result.records ) )
260 -- RAISE NOTICE ' % and multi-home linked records were all visibility-excluded ... ', core_result.records;
261 excluded_count := excluded_count + 1;
269 FROM asset.call_number cn
270 JOIN asset.copy cp ON (cp.call_number = cn.id)
273 AND cp.circ_lib IN ( SELECT * FROM unnest( search_org_list ) )
274 AND cn.record IN ( SELECT * FROM unnest( core_result.records ) )
280 FROM biblio.peer_bib_copy_map pr
281 JOIN asset.copy cp ON (cp.id = pr.target_copy)
283 AND cp.circ_lib IN ( SELECT * FROM unnest( search_org_list ) )
284 AND pr.peer_record IN ( SELECT * FROM unnest( core_result.records ) )
290 FROM asset.call_number cn
291 JOIN asset.copy cp ON (cp.call_number = cn.id)
292 WHERE cn.record IN ( SELECT * FROM unnest( core_result.records ) )
297 -- Recheck Located URI visibility in the case of no "foreign" copies
299 FROM asset.call_number cn
300 JOIN asset.uri_call_number_map map ON (map.call_number = cn.id)
301 JOIN asset.uri uri ON (map.uri = uri.id)
303 AND cn.label = '##URI##'
305 AND cn.record IN ( SELECT * FROM unnest( core_result.records ) )
306 AND cn.owning_lib NOT IN ( SELECT * FROM unnest( luri_org_list ) )
310 -- RAISE NOTICE ' % were excluded for foreign located URIs... ', core_result.records;
311 excluded_count := excluded_count + 1;
315 -- RAISE NOTICE ' % and multi-home linked records were all visibility-excluded ... ', core_result.records;
316 excluded_count := excluded_count + 1;
327 visible_count := visible_count + 1;
329 current_res.id = core_result.id;
330 current_res.rel = core_result.rel;
334 SELECT COUNT(DISTINCT s.source) INTO tmp_int FROM metabib.metarecord_source_map s WHERE s.metarecord = core_result.id;
338 current_res.record = core_result.records[1];
340 current_res.record = NULL;
343 RETURN NEXT current_res;
345 IF visible_count % 1000 = 0 THEN
346 -- RAISE NOTICE ' % visible so far ... ', visible_count;
351 current_res.id = NULL;
352 current_res.rel = NULL;
353 current_res.record = NULL;
354 current_res.total = total_count;
355 current_res.checked = check_count;
356 current_res.deleted = deleted_count;
357 current_res.visible = visible_count;
358 current_res.excluded = excluded_count;
362 RETURN NEXT current_res;
365 $func$ LANGUAGE PLPGSQL;