From 01c1b5b7dfa3ad26179b26214366818142c2c876 Mon Sep 17 00:00:00 2001 From: Bradley Bonner Date: Thu, 2 Mar 2017 13:35:16 -0800 Subject: [PATCH] JBAS-1750 Lib use only status updates Switch available items with circulate flag = false to Lib Use Only status. Bradley Bonner bbonner@kcls.org --- KCLS/utility-scripts/CRONTAB | 3 +++ .../make_items_lib_use_only/make_lib_use_only.sh | 6 ++++++ .../make_items_lib_use_only/make_lib_use_only.sql | 20 ++++++++++++++++++++ 3 files changed, 29 insertions(+) create mode 100644 KCLS/utility-scripts/make_items_lib_use_only/make_lib_use_only.sh create mode 100644 KCLS/utility-scripts/make_items_lib_use_only/make_lib_use_only.sql diff --git a/KCLS/utility-scripts/CRONTAB b/KCLS/utility-scripts/CRONTAB index 777b04c044..efc17f7490 100644 --- a/KCLS/utility-scripts/CRONTAB +++ b/KCLS/utility-scripts/CRONTAB @@ -60,6 +60,9 @@ BACKSTAGE_PASSWORD = BSPASS # Update copy status for BC #0 22 * * * . ~/.bashrc && cd $SCRIPT_DIR/bc_missing/ && ./bc_missing.sh +# Update copy status - make items lib use only +#0 3 * * * . ~/.bashrc && cd $SCRIPT_DIR/make_items_lib_use_only/ && ./make_lib_use_only.sh + # Update Envisionware patron access #30 0 * * * . ~/.bashrc && cd $SCRIPT_DIR/envware_access/ && ./envware_access.sh diff --git a/KCLS/utility-scripts/make_items_lib_use_only/make_lib_use_only.sh b/KCLS/utility-scripts/make_items_lib_use_only/make_lib_use_only.sh new file mode 100644 index 0000000000..1acbbe2838 --- /dev/null +++ b/KCLS/utility-scripts/make_items_lib_use_only/make_lib_use_only.sh @@ -0,0 +1,6 @@ +#!/bin/bash + +psql -U evergreen < make_lib_use_only.sql > log.make_lib_use_only + +cat log.make_lib_use_only | mailx -s "Items made Lib Use Only" bbonner@kcls.org + diff --git a/KCLS/utility-scripts/make_items_lib_use_only/make_lib_use_only.sql b/KCLS/utility-scripts/make_items_lib_use_only/make_lib_use_only.sql new file mode 100644 index 0000000000..b8467193d8 --- /dev/null +++ b/KCLS/utility-scripts/make_items_lib_use_only/make_lib_use_only.sql @@ -0,0 +1,20 @@ +BEGIN; + +SET SESSION STATEMENT_TIMEOUT TO 0; + +SELECT +asset.copy.id, asset.copy.barcode +FROM +asset.copy +WHERE +deleted = 'f' and circulate = 'f' and status = 0 and call_number != -1; + +UPDATE asset.copy SET status = '102' where asset.copy.id IN ( +SELECT +asset.copy.id +FROM +asset.copy +WHERE +deleted = 'f' and circulate = 'f' and status = 0 and call_number != -1 +); +COMMIT; -- 2.11.0