3 SELECT evergreen.upgrade_deps_block_check('0770', :eg_version);
5 CREATE OR REPLACE FUNCTION evergreen.get_barcodes(select_ou INT, type TEXT, in_barcode TEXT) RETURNS SETOF evergreen.barcode_set AS $$
10 asset_barcodes TEXT[];
11 actor_barcodes TEXT[];
12 do_asset BOOL = false;
13 do_serial BOOL = false;
14 do_booking BOOL = false;
15 do_actor BOOL = false;
16 completion_set config.barcode_completion%ROWTYPE;
19 IF position('asset' in type) > 0 THEN
22 IF position('serial' in type) > 0 THEN
25 IF position('booking' in type) > 0 THEN
28 IF do_asset OR do_serial OR do_booking THEN
29 asset_barcodes = asset_barcodes || in_barcode;
31 IF position('actor' in type) > 0 THEN
33 actor_barcodes = actor_barcodes || in_barcode;
36 barcode_len := length(in_barcode);
39 SELECT * FROM config.barcode_completion
41 AND org_unit IN (SELECT aou.id FROM actor.org_unit_ancestors(select_ou) aou)
43 IF completion_set.prefix IS NULL THEN
44 completion_set.prefix := '';
46 IF completion_set.suffix IS NULL THEN
47 completion_set.suffix := '';
49 IF completion_set.length = 0 OR completion_set.padding IS NULL OR length(completion_set.padding) = 0 THEN
50 cur_barcode = completion_set.prefix || in_barcode || completion_set.suffix;
52 completion_len = completion_set.length - length(completion_set.prefix) - length(completion_set.suffix);
53 IF completion_len >= barcode_len THEN
54 IF completion_set.padding_end THEN
55 cur_barcode = rpad(in_barcode, completion_len, completion_set.padding);
57 cur_barcode = lpad(in_barcode, completion_len, completion_set.padding);
59 cur_barcode = completion_set.prefix || cur_barcode || completion_set.suffix;
62 IF completion_set.actor THEN
63 actor_barcodes = actor_barcodes || cur_barcode;
65 IF completion_set.asset THEN
66 asset_barcodes = asset_barcodes || cur_barcode;
70 IF do_asset AND do_serial THEN
71 RETURN QUERY SELECT 'asset'::TEXT, id, barcode FROM ONLY asset.copy WHERE barcode = ANY(asset_barcodes) AND deleted = false;
72 RETURN QUERY SELECT 'serial'::TEXT, id, barcode FROM serial.unit WHERE barcode = ANY(asset_barcodes) AND deleted = false;
74 RETURN QUERY SELECT 'asset'::TEXT, id, barcode FROM asset.copy WHERE barcode = ANY(asset_barcodes) AND deleted = false;
76 RETURN QUERY SELECT 'serial'::TEXT, id, barcode FROM serial.unit WHERE barcode = ANY(asset_barcodes) AND deleted = false;
79 RETURN QUERY SELECT 'booking'::TEXT, id::BIGINT, barcode FROM booking.resource WHERE barcode = ANY(asset_barcodes);
82 RETURN QUERY SELECT 'actor'::TEXT, c.usr::BIGINT, c.barcode FROM actor.card c JOIN actor.usr u ON c.usr = u.id WHERE
83 ((c.barcode = ANY(actor_barcodes) AND c.active) OR c.barcode = in_barcode) AND NOT u.deleted ORDER BY usr;