From 8a6d22250c7f19b061e2d0a15420d90d380ca219 Mon Sep 17 00:00:00 2001 From: miker Date: Tue, 15 Mar 2011 17:15:01 +0000 Subject: [PATCH] teach the 1.6-2.0 reingest generator about "tnf"-tag rows for title sorting git-svn-id: svn://svn.open-ils.org/ILS/trunk@19752 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/reingest-1.6-2.0.pl | 15 +++++++++++++++ Open-ILS/xul/staff_client/server/cat/marcedit.js | 6 ++++-- 2 files changed, 19 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/reingest-1.6-2.0.pl b/Open-ILS/src/sql/Pg/reingest-1.6-2.0.pl index 988a7b0..483cc92 100755 --- a/Open-ILS/src/sql/Pg/reingest-1.6-2.0.pl +++ b/Open-ILS/src/sql/Pg/reingest-1.6-2.0.pl @@ -77,6 +77,21 @@ sub fetch_num_bibs_from_database { sub header { print OUT q { +\qecho First, make sure that the rows needed for title sorting are +\qecho available. + +BEGIN; +DELETE FROM metabib.real_full_rec WHERE tag = 'tnf'; +INSERT INTO metabib.real_full_rec (record, tag, subfield, value) + SELECT record, + 'tnf', + 'a', + SUBSTRING(value, COALESCE(NULLIF(REGEXP_REPLACE(ind2,'[^0-9]','','g'),''),'0')::int + 1) + FROM metabib.real_full_rec + WHERE tag = '245' + AND subfield = 'a'; +COMMIT; + \qecho Do a partial reingest to fully populate metabib.facet_entry \qecho and update the keyword indexes to reflect changes in the default \qecho NACO normalization. This can be time consuming on large databases. diff --git a/Open-ILS/xul/staff_client/server/cat/marcedit.js b/Open-ILS/xul/staff_client/server/cat/marcedit.js index 9dc0137..8eaaad0 100644 --- a/Open-ILS/xul/staff_client/server/cat/marcedit.js +++ b/Open-ILS/xul/staff_client/server/cat/marcedit.js @@ -2440,7 +2440,9 @@ function browseAuthority (sf_popup, menu_id, target, sf, limit, page) { ); sf_popup.appendChild( createComplexXULElement( 'menuseparator' ) ); - dojo.query('record', records).forEach(function(record) { + var recs = dojo.query('record', records) + for (var i = 0; i < recs.length; i++) { + var record = recs[i]; var main_text = ''; var see_from = []; var see_also = []; @@ -2493,7 +2495,7 @@ function browseAuthority (sf_popup, menu_id, target, sf, limit, page) { buildAuthorityPopup(entry_text, record, auth_org, auth_id, sf_popup, target, sf, "font-style: italic; margin-left: 2em;"); }); - }); + } if (sf_popup.childNodes.length == 0) { sf_popup.appendChild(createLabel( { value : $('catStrings').getString('staff.cat.marcedit.no_authority_match.label') } ) ); -- 1.7.2.5