From af75d7f163e283f8fa32bb98865c09cb8d73f22c Mon Sep 17 00:00:00 2001 From: Thomas Berezansky Date: Tue, 12 Mar 2013 15:25:21 -0400 Subject: [PATCH] Allow inactive patron barcode to be loaded Needs an upgrade script. AND A BETTER COMMIT MESSAGE. Signed-off-by nobody because this is horribly incomplete ;) --- Open-ILS/src/sql/Pg/020.schema.functions.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/020.schema.functions.sql b/Open-ILS/src/sql/Pg/020.schema.functions.sql index f69bfa4aa0..5ac7eeec2c 100644 --- a/Open-ILS/src/sql/Pg/020.schema.functions.sql +++ b/Open-ILS/src/sql/Pg/020.schema.functions.sql @@ -359,7 +359,8 @@ BEGIN RETURN QUERY SELECT 'booking'::TEXT, id::BIGINT, barcode FROM booking.resource WHERE barcode = ANY(asset_barcodes); END IF; IF do_actor THEN - RETURN QUERY SELECT 'actor'::TEXT, c.usr::BIGINT, c.barcode FROM actor.card c JOIN actor.usr u ON c.usr = u.id WHERE c.barcode = ANY(actor_barcodes) AND c.active AND NOT u.deleted ORDER BY usr; + RETURN QUERY SELECT 'actor'::TEXT, c.usr::BIGINT, c.barcode FROM actor.card c JOIN actor.usr u ON c.usr = u.id WHERE + ((c.barcode = ANY(actor_barcodes) AND c.active) OR c.barcode = in_barcode) AND NOT u.deleted ORDER BY usr; END IF; RETURN; END; -- 2.11.0