3 INSERT INTO config.upgrade_log (version) VALUES ('0283');
5 CREATE OR REPLACE FUNCTION action.usr_visible_circs (usr_id INT) RETURNS SETOF action.circulation AS $func$
7 c action.circulation%ROWTYPE;
9 usr_view_age actor.usr_setting%ROWTYPE;
10 usr_view_start actor.usr_setting%ROWTYPE;
12 SELECT * INTO usr_view_age FROM actor.usr_setting WHERE usr = usr_id AND name = 'history.circ.retention_age';
13 SELECT * INTO usr_view_start FROM actor.usr_setting WHERE usr = usr_id AND name = 'history.circ.retention_start';
15 IF usr_view_age.value IS NOT NULL AND usr_view_start.value IS NOT NULL THEN
16 -- User opted in and supplied a retention age
17 IF oils_json_to_text(usr_view_age.value)::INTERVAL > AGE(NOW(), oils_json_to_text(usr_view_start.value)::TIMESTAMPTZ) THEN
18 view_age := AGE(NOW(), oils_json_to_text(usr_view_start.value)::TIMESTAMPTZ);
20 view_age := oils_json_to_text(usr_view_age.value)::INTERVAL;
22 ELSIF usr_view_start.value IS NOT NULL THEN
24 view_age := AGE(NOW(), oils_json_to_text(usr_view_start.value)::TIMESTAMPTZ);
26 -- User did not opt in
32 FROM action.circulation
34 AND parent_circ IS NULL
35 AND xact_start > NOW() - view_age
43 $func$ LANGUAGE PLPGSQL;
45 CREATE OR REPLACE FUNCTION action.usr_visible_holds (usr_id INT) RETURNS SETOF action.hold_request AS $func$
47 h action.hold_request%ROWTYPE;
50 usr_view_count actor.usr_setting%ROWTYPE;
51 usr_view_age actor.usr_setting%ROWTYPE;
53 SELECT * INTO usr_view_count FROM actor.usr_setting WHERE usr = usr_id AND name = 'history.hold.retention_count';
54 SELECT * INTO usr_view_age FROM actor.usr_setting WHERE usr = usr_id AND name = 'history.hold.retention_age';
56 IF usr_view_count.value IS NULL AND usr_view_age.value IS NULL THEN
57 -- Only show "open" holds
60 FROM action.hold_request
62 AND fulfillment_time IS NULL
63 AND cancel_time IS NULL
72 IF usr_view_age.value IS NOT NULL THEN
73 view_age := oils_json_to_text(usr_view_age.value)::INTERVAL;
75 view_age := '2000 years'::INTERVAL;
78 IF usr_view_count.value IS NOT NULL THEN
79 view_count := oils_json_to_text(usr_view_count.value)::INT;
84 -- Else, show those /and/ some fulfilled/canceled holds
87 FROM action.hold_request
89 AND fulfillment_time IS NULL
90 AND cancel_time IS NULL
93 FROM action.hold_request
95 AND ( fulfillment_time IS NOT NULL OR cancel_time IS NOT NULL )
96 AND request_time > NOW() - view_age
105 $func$ LANGUAGE PLPGSQL;