From d87ad5f21e23f5e28fe7b970baad090d2b59eb63 Mon Sep 17 00:00:00 2001
From: Remington Steed <rjs7@calvin.edu>
Date: Wed, 24 Apr 2019 14:01:39 -0400
Subject: [PATCH] LP#1721036: Add url to item tags (DB, IDL, and OPAC link)
This commit adds a new field to the asset.copy_tag database table, adds
it to the IDL, and includes it as a link in the OPAC when present.
Signed-off-by: Remington Steed <rjs7@calvin.edu>
Signed-off-by: Kyle Huckins <khuckins@catalyte.io>
Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
---
Open-ILS/examples/fm_IDL.xml | 1 +
Open-ILS/src/sql/Pg/040.schema.asset.sql | 3 ++-
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.asset.copy_tag.url.sql | 8 ++++++++
Open-ILS/src/templates/opac/parts/record/copy_table.tt2 | 10 +++++++++-
4 files changed, 20 insertions(+), 2 deletions(-)
create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.schema.asset.copy_tag.url.sql
diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml
index 0a14cb5f14..544488e3f1 100644
--- a/Open-ILS/examples/fm_IDL.xml
+++ b/Open-ILS/examples/fm_IDL.xml
@@ -12706,6 +12706,7 @@ SELECT usr,
<field reporter:label="Staff Note" name="staff_note" reporter:datatype="text"/>
<field reporter:label="Is OPAC Visible?" name="pub" reporter:datatype="bool"/>
<field reporter:label="Owner" name="owner" reporter:datatype="org_unit" oils_obj:required="true"/>
+ <field reporter:label="URL" name="url" reporter:datatype="text"/>
</fields>
<links>
<link field="tag_type" reltype="has_a" key="code" map="" class="cctt"/>
diff --git a/Open-ILS/src/sql/Pg/040.schema.asset.sql b/Open-ILS/src/sql/Pg/040.schema.asset.sql
index 9beed1d751..198632a617 100644
--- a/Open-ILS/src/sql/Pg/040.schema.asset.sql
+++ b/Open-ILS/src/sql/Pg/040.schema.asset.sql
@@ -967,7 +967,8 @@ CREATE TABLE asset.copy_tag (
index_vector tsvector NOT NULL,
staff_note TEXT,
pub BOOLEAN DEFAULT TRUE,
- owner INTEGER NOT NULL REFERENCES actor.org_unit (id)
+ owner INTEGER NOT NULL REFERENCES actor.org_unit (id),
+ url TEXT
);
CREATE INDEX asset_copy_tag_label_idx
diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.asset.copy_tag.url.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.asset.copy_tag.url.sql
new file mode 100644
index 0000000000..b7b26ceb09
--- /dev/null
+++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.asset.copy_tag.url.sql
@@ -0,0 +1,8 @@
+BEGIN;
+
+--INSERT INTO config.upgrade_log (version, applied_to) VALUES ('XXXX', :eg_version);
+
+ALTER TABLE asset.copy_tag
+ ADD COLUMN url TEXT;
+
+COMMIT;
diff --git a/Open-ILS/src/templates/opac/parts/record/copy_table.tt2 b/Open-ILS/src/templates/opac/parts/record/copy_table.tt2
index 1e0456cf83..1c7a2de0dd 100644
--- a/Open-ILS/src/templates/opac/parts/record/copy_table.tt2
+++ b/Open-ILS/src/templates/opac/parts/record/copy_table.tt2
@@ -236,7 +236,15 @@ END; # FOREACH bib
<tr class="copy_tag_row">
<td> </td>
<td class="copy_tag" colspan="4">
- <span class="copy_tag_value">[% tag.value | html %]</span>
+ <span class="copy_tag_value">
+ [% IF tag.url %]
+ <a href="[% tag.url | html %]">
+ [% END %]
+ [% tag.value | html %]
+ [% IF tag.url %]
+ </a>
+ [% END %]
+ </span>
</td>
<tr>
[% END %]
--
2.11.0