From 2faa5b8945dc76267f0d110e312ceb5e4c03c48e Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Thu, 12 Dec 2019 16:01:20 -0500 Subject: [PATCH] preloaded audio format for lp1835736 --- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 13 +++++++++++- .../Pg/upgrade/xxxx.data.preloaded_audio.sql | 19 +++++++++++++++++ .../icon_format/preloadedaudio.png | Bin 0 -> 1827 bytes .../Administration/preloaded_audio.adoc | 20 ++++++++++++++++++ .../Cataloging/preloaded_audio.adoc | 8 +++++++ 5 files changed, 59 insertions(+), 1 deletion(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/xxxx.data.preloaded_audio.sql create mode 100644 Open-ILS/web/images/format_icons/icon_format/preloadedaudio.png create mode 100644 docs/RELEASE_NOTES_NEXT/Administration/preloaded_audio.adoc create mode 100644 docs/RELEASE_NOTES_NEXT/Cataloging/preloaded_audio.adoc diff --git a/Open-ILS/src/sql/Pg/950.data.seed-values.sql b/Open-ILS/src/sql/Pg/950.data.seed-values.sql index 32dcd0fffa..47bbde598b 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -9099,6 +9099,14 @@ INSERT INTO config.coded_value_map (id, ctype, code, value, opac_visible) VALUES INSERT INTO config.coded_value_map (id, ctype, code, value, opac_visible) VALUES (1733, 'ills4', 'o', oils_i18n_gettext('1733', 'Photographs', 'ccvm', 'value'), FALSE); INSERT INTO config.coded_value_map (id, ctype, code, value, opac_visible) VALUES (1734, 'ills4', 'p', oils_i18n_gettext('1734', 'Illuminations', 'ccvm', 'value'), FALSE); +INSERT INTO config.coded_value_map (id,ctype,code,opac_visible,is_simple,value,search_label) VALUES +(1736,'icon_format','preloadedaudio',TRUE,FALSE, + oils_i18n_gettext(1736, 'Preloaded Audio', 'ccvm', 'value'), + oils_i18n_gettext(1736, 'Preloaded Audio', 'ccvm', 'search_label')), +(1737,'search_format','preloadedaudio',TRUE,FALSE, + oils_i18n_gettext(1737, 'Preloaded Audio', 'ccvm', 'value'), + oils_i18n_gettext(1737, 'Preloaded Audio', 'ccvm', 'search_label')) +; -- carve out a slot of 10k IDs for stock CCVMs SELECT SETVAL('config.coded_value_map_id_seq'::TEXT, 10000); @@ -9362,7 +9370,10 @@ INSERT INTO config.composite_attr_entry_definition (coded_value, definition) VAL INSERT INTO config.composite_attr_entry_definition (coded_value, definition) VALUES (1672, '[{"_attr":"ills4","_val":"o"},{"_attr":"ills3","_val":"o"},{"_attr":"ills2","_val":"o"},{"_attr":"ills1","_val":"o"}]'); INSERT INTO config.composite_attr_entry_definition (coded_value, definition) VALUES (1673, '[{"_attr":"ills4","_val":"p"},{"_attr":"ills3","_val":"p"},{"_attr":"ills2","_val":"p"},{"_attr":"ills1","_val":"p"}]'); - +--preloaded audio +INSERT INTO config.composite_attr_entry_definition (id, coded_value, definition) VALUES +(1674,(SELECT id from config.coded_value_map where ctype = 'search_format' AND code = 'preloadedaudio'),'{"0":{"_attr":"item_type","_val":"i"},"1":{"_attr":"item_form","_val":"q"}}'), +(1675,(SELECT id from config.coded_value_map where ctype = 'icon_format' AND code = 'preloadedaudio'),'{"0":{"_attr":"item_type","_val":"i"},"1":{"_attr":"item_form","_val":"q"}}'); -- Trigger Event Definitions ------------------------------------------------- diff --git a/Open-ILS/src/sql/Pg/upgrade/xxxx.data.preloaded_audio.sql b/Open-ILS/src/sql/Pg/upgrade/xxxx.data.preloaded_audio.sql new file mode 100644 index 0000000000..e5ee9e112a --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/xxxx.data.preloaded_audio.sql @@ -0,0 +1,19 @@ +BEGIN; + +SELECT evergreen.upgrade_deps_block_check('xxxx', :eg_version); + +INSERT INTO config.coded_value_map (id,ctype,code,opac_visible,is_simple,value,search_label) VALUES +(1736,'icon_format','preloadedaudio',TRUE,FALSE, + oils_i18n_gettext(1736, 'Preloaded Audio', 'ccvm', 'value'), + oils_i18n_gettext(1736, 'Preloaded Audio', 'ccvm', 'search_label')), +(1737,'search_format','preloadedaudio',TRUE,FALSE, + oils_i18n_gettext(1737, 'Preloaded Audio', 'ccvm', 'value'), + oils_i18n_gettext(1737, 'Preloaded Audio', 'ccvm', 'search_label')) +; + +INSERT INTO config.composite_attr_entry_definition (coded_value, definition) VALUES +((SELECT id from config.coded_value_map where ctype = 'search_format' AND code = 'preloadedaudio'),'{"0":{"_attr":"item_type","_val":"i"},"1":{"_attr":"item_form","_val":"q"}}'), +((SELECT id from config.coded_value_map where ctype = 'icon_format' AND code = 'preloadedaudio'),'{"0":{"_attr":"item_type","_val":"i"},"1":{"_attr":"item_form","_val":"q"}}'); + + +COMMIT; diff --git a/Open-ILS/web/images/format_icons/icon_format/preloadedaudio.png b/Open-ILS/web/images/format_icons/icon_format/preloadedaudio.png new file mode 100644 index 0000000000000000000000000000000000000000..56d521c16321a2d4bc7df3c46c7bde87a48f4c4e GIT binary patch literal 1827 zcmaJ?c~}x@9475Dq}WQWwrn2ku$~0LK$yfbz{J8(D39EVW7LUY2*$u;^U7Mn?Nlp| zEVJy=GOg4Ot*tiKSXU`qwQ{Sq+FB!PU9YSiDsBH*_j_jMJD&G_f9Lm%K^U-vFlNda z91cg|`*DM?*~$8jw!yxLAEyhOCZoI%RD?vJI*A6t`N$C|1n`xTNGJ%B$YVCtKwdbU zEeRHfpdo@~pbSxxB~}bsuT*1f9L{T@UM-O+AQX^7k+6zQvRtep0kE7+3Z@I(1!@iy z1^dNnAW>|9SQe|0vE-zM-hh`L!~~QODgpG$^(rl>XOlkag4o)6Od$auA*g~)`s7rI zKnQRU4Fu519&R#sDivTb$kh3C27@{ept)0N6nE@lxKZbWbOuQC1U?TEW=$iH0E4)` zpKW0~HYo~4)gXnU)9J`M4>F>Oq)=HbmQ{mBbHfmB+87lo(YvX%E&~c&NGsF8Y7|CP zfK^cRmhe+p~G zF=~hs1Zk0IjSMSXgp1Xb8sumo35saM2(o@4i^3=bMYK_f8sLZ+fNL4ga2OmOmCGC8auHdy z5>lZ9T=^I7{2{s4R#2)j%UnnUZ-nH&8bk?v3>k!n_Jum6-e<0SXkTbUaw(WI6l-Ds zRp@~utb44>!M4RVgN+ZVux{62ZJjbZ=O^s8?B#QP#QNqk@tP=6@T97)r@uc`>~3L% zW*rr;vpwmML)>!hjgUt0J1#D<{pN;K`=Y$UGkY(ex^v*7pPb?mN(-~K^pOji!S>FxK5^=v__rLU`RY|)9ioq4J669VIR zIGb+YK2=l%HNYwL&(+NBc}yz$D7i+yZgg9tDO+{{G3NW3%kHjImbNUtA)V*AXNEzt z?{s+an%T1@fsuzBYwJ8!WuZk|D=#KY{<`IGSWL&`f*;LI^&Lmd6-!oZef+kkIQ(*K z*U!^B^B{$y_DM&0Wqgk%Fu(peHX0gsHz(TL+o$c=k#PUjQ78M6gpnz=ZR-l=xVX4H zQtM?hPD`VZ;pzFLqxZQX@Cyt==n$h?id`850gKiZ+HJ^|=?#1@ynIv&# z*5s3}y?Xu;;?m<;+eUJ_moTyknx=OAuJX*4S4=B+orn6paSrlDoDj+x=5oA1;B|s% zhuavjzcCG6ecEZH6K!*VPl|lXw0CJ$n&w&zw#cPxQ0U{RV&j0`b literal 0 HcmV?d00001 diff --git a/docs/RELEASE_NOTES_NEXT/Administration/preloaded_audio.adoc b/docs/RELEASE_NOTES_NEXT/Administration/preloaded_audio.adoc new file mode 100644 index 0000000000..a56bef5364 --- /dev/null +++ b/docs/RELEASE_NOTES_NEXT/Administration/preloaded_audio.adoc @@ -0,0 +1,20 @@ +Preloaded Audio Icon and Search Format +^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ +A new search and icon format called Preloaded Audio now exists +that overlaps with the eAudio format. If you want to exclude +the Preloaded Audio format from overlapping with eAudio +you can use the following SQL: + +UPDATE config.composite_attr_entry_definition SET definition = '{"0":{"_attr":"item_type","_val":"i"},"1":[{"_attr":"item_form","_val":"o"},{"_attr":"item_form","_val":"s"}]}' + WHERE coded_value IN (SELECT id FROM config.coded_value_map WHERE code = 'eaudio'); + +It is also recommended that you reingest your bibliographic records +to updated the fixed field indexes. You can accomplish this by running +the following query in your database: + +SELECT metabib.reingest_record_attributes(source) +FROM metabib.record_attr_vector_list WHERE +(SELECT id FROM config.coded_value_map WHERE ctype = 'item_form' AND code = 'q') = ANY(vlist) +AND (SELECT id FROM config.coded_value_map WHERE ctype = 'item_type' AND code = 'i') = ANY(vlist); + + diff --git a/docs/RELEASE_NOTES_NEXT/Cataloging/preloaded_audio.adoc b/docs/RELEASE_NOTES_NEXT/Cataloging/preloaded_audio.adoc new file mode 100644 index 0000000000..1132094b88 --- /dev/null +++ b/docs/RELEASE_NOTES_NEXT/Cataloging/preloaded_audio.adoc @@ -0,0 +1,8 @@ +Preloaded Audio Icon and Search Format +^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ +A new search and icon format called Preloaded Audio now exists +using the following atttributes: itemtype i, item form q. This +overlaps with the eAudio format. If you want to exclude +preloaded audio from eAudio there is a script in the Administration +notes to exclude it. + -- 2.43.2