From 4789c3325c423e4f911f731da5c08632f6404127 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Wed, 29 Oct 2014 17:09:38 -0400 Subject: [PATCH] All cataloging date commits in one as of 2014-06-26 Cross-port: 3f22bff Conflicts: Open-ILS/xul/staff_client/server/cat/marcedit.js Conflicts: Open-ILS/web/opac/locale/en-US/lang.dtd --- .../kmain228/add_cataloging_date_column_to_bre.sql | 10 ++ .../rollback-add_cataloging_date_column_to_bre.sql | 6 + Open-ILS/examples/fm_IDL.xml | 1 + Open-ILS/web/opac/locale/en-US/lang.dtd | 5 + .../xul/staff_client/chrome/content/util/date.js | 2 + .../staff_client/server/cat/bib_brief_overlay.xul | 4 +- Open-ILS/xul/staff_client/server/cat/marcedit.js | 192 ++++++++++++++------- Open-ILS/xul/staff_client/server/cat/marcedit.xul | 3 + Open-ILS/xul/staff_client/server/circ/util.js | 17 ++ .../server/locale/en-US/circ.properties | 1 + 10 files changed, 180 insertions(+), 61 deletions(-) create mode 100644 KCLS/sql/kmain228/add_cataloging_date_column_to_bre.sql create mode 100644 KCLS/sql/kmain228/rollback-add_cataloging_date_column_to_bre.sql diff --git a/KCLS/sql/kmain228/add_cataloging_date_column_to_bre.sql b/KCLS/sql/kmain228/add_cataloging_date_column_to_bre.sql new file mode 100644 index 0000000000..fb4b7fff05 --- /dev/null +++ b/KCLS/sql/kmain228/add_cataloging_date_column_to_bre.sql @@ -0,0 +1,10 @@ +BEGIN; + +ALTER TABLE biblio.record_entry + ADD COLUMN cataloging_date timestamp with time zone; + +-- Run the following query if the desired result is to have all the cataloging_date's for current records to be set to now(). +-- UPDATE biblio.record_entry SET cataloging_date = now() +-- WHERE cataloging_date IS NULL; + +COMMIT; \ No newline at end of file diff --git a/KCLS/sql/kmain228/rollback-add_cataloging_date_column_to_bre.sql b/KCLS/sql/kmain228/rollback-add_cataloging_date_column_to_bre.sql new file mode 100644 index 0000000000..7b810ee034 --- /dev/null +++ b/KCLS/sql/kmain228/rollback-add_cataloging_date_column_to_bre.sql @@ -0,0 +1,6 @@ +BEGIN; + +ALTER TABLE biblio.record_entry + DROP COLUMN cataloging_date; + +COMMIT; \ No newline at end of file diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml index 4ae53b192f..3c57522f2e 100644 --- a/Open-ILS/examples/fm_IDL.xml +++ b/Open-ILS/examples/fm_IDL.xml @@ -3198,6 +3198,7 @@ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA + diff --git a/Open-ILS/web/opac/locale/en-US/lang.dtd b/Open-ILS/web/opac/locale/en-US/lang.dtd index 0f9f4bd73a..c1ff1a1d51 100644 --- a/Open-ILS/web/opac/locale/en-US/lang.dtd +++ b/Open-ILS/web/opac/locale/en-US/lang.dtd @@ -2737,6 +2737,8 @@ + + @@ -3046,6 +3048,9 @@ + + + diff --git a/Open-ILS/xul/staff_client/chrome/content/util/date.js b/Open-ILS/xul/staff_client/chrome/content/util/date.js index cbf4fd04db..970997c38d 100644 --- a/Open-ILS/xul/staff_client/chrome/content/util/date.js +++ b/Open-ILS/xul/staff_client/chrome/content/util/date.js @@ -104,6 +104,8 @@ util.date.formatted_date = function (orig_date,format) { var s = format; if (s == '') { s = '%F %H:%M'; } + //Just for cataloging date, show only the Date in mm-dd-yyyy + if (s == 'mmddyyyy') { s = mm + '-' + dd + '-' + yyyy; return s; } if (typeof window.dojo != 'undefined') { JSAN.use('OpenILS.data'); var data = new OpenILS.data(); data.stash_retrieve(); dojo.require('dojo.date.locale'); diff --git a/Open-ILS/xul/staff_client/server/cat/bib_brief_overlay.xul b/Open-ILS/xul/staff_client/server/cat/bib_brief_overlay.xul index f2a193902c..57f9f10600 100644 --- a/Open-ILS/xul/staff_client/server/cat/bib_brief_overlay.xul +++ b/Open-ILS/xul/staff_client/server/cat/bib_brief_overlay.xul @@ -42,8 +42,8 @@