3 SELECT evergreen.upgrade_deps_block_check('1114', :eg_version);
5 CREATE OR REPLACE FUNCTION asset.copy_state (cid BIGINT) RETURNS TEXT AS $$
8 the_copy asset.copy%ROWTYPE;
11 SELECT * INTO the_copy FROM asset.copy WHERE id = cid;
12 IF NOT FOUND THEN RETURN NULL; END IF;
14 IF the_copy.status = 3 THEN -- Lost
16 ELSIF the_copy.status = 4 THEN -- Missing
18 ELSIF the_copy.status = 14 THEN -- Damaged
20 ELSIF the_copy.status = 17 THEN -- Lost and paid
21 RETURN 'LOST_AND_PAID';
24 SELECT stop_fines INTO last_circ_stop
25 FROM action.circulation
26 WHERE target_copy = cid AND checkin_time IS NULL
27 ORDER BY xact_start DESC LIMIT 1;
30 IF last_circ_stop IN (
31 'CLAIMSNEVERCHECKEDOUT',
35 RETURN last_circ_stop;