From edb27bfd51ffdafa61ac2f22e77045aa121cb05e Mon Sep 17 00:00:00 2001 From: miker Date: Thu, 30 Oct 2008 20:14:32 +0000 Subject: [PATCH] add item barcode match as an optional incoming matchpoint git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_4@10998 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/012.schema.vandelay.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) diff --git a/Open-ILS/src/sql/Pg/012.schema.vandelay.sql b/Open-ILS/src/sql/Pg/012.schema.vandelay.sql index 27a31582a7..737b3ec77f 100644 --- a/Open-ILS/src/sql/Pg/012.schema.vandelay.sql +++ b/Open-ILS/src/sql/Pg/012.schema.vandelay.sql @@ -534,6 +534,17 @@ BEGIN INSERT INTO vandelay.bib_match (field_type, matched_attr, queued_record, eg_record) VALUES ('tcn_value', attr.id, NEW.id, eg_rec.id); END LOOP; + -- check for a direct item barcode match + FOR eg_rec IN + SELECT DISTINCT b.* + FROM biblio.record_entry b + JOIN asset.call_number cn ON (cn.record = b.id) + JOIN asset.copy cp ON (cp.call_number = cn.id) + WHERE cp.barcode = attr.attr_value AND cp.deleted IS FALSE + LOOP + INSERT INTO vandelay.bib_match (field_type, matched_attr, queued_record, eg_record) VALUES ('id', attr.id, NEW.id, eg_rec.id); + END LOOP; + END LOOP; RETURN NULL; -- 2.11.0