From c061e1590cf0b5bac976d6ee6c4296f1fe0c7a91 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Fri, 10 Nov 2017 11:51:23 -0500 Subject: [PATCH] JBAS-1919 UMS monthly user balance export script/cron Generate a monthly user balance export for retrieval by UMS. Signed-off-by: Bill Erickson --- KCLS/utility-scripts/CRONTAB | 3 ++ .../ums_user_balances/ums_user_balances.sh | 38 ++++++++++++++++++++++ 2 files changed, 41 insertions(+) create mode 100755 KCLS/utility-scripts/ums_user_balances/ums_user_balances.sh diff --git a/KCLS/utility-scripts/CRONTAB b/KCLS/utility-scripts/CRONTAB index 31d57316b4..77ca08d603 100644 --- a/KCLS/utility-scripts/CRONTAB +++ b/KCLS/utility-scripts/CRONTAB @@ -166,3 +166,6 @@ BACKSTAGE_PASSWORD = BSPASS # Process and archive student import files each Sunday night at 11pm # 0 23 * * 0 cd /home/opensrf/Evergreen/KCLS/utility-scripts/import_students && ./sftp-client-agent.sh -b db01 -p -a +# Monthly UMS user balance summary export +0 3 1 * * . ~/.bashrc && cd $SCRIPT_DIR/ums_user_balances/ && ./ums_user_balances.sh + diff --git a/KCLS/utility-scripts/ums_user_balances/ums_user_balances.sh b/KCLS/utility-scripts/ums_user_balances/ums_user_balances.sh new file mode 100755 index 0000000000..1b949c8fd0 --- /dev/null +++ b/KCLS/utility-scripts/ums_user_balances/ums_user_balances.sh @@ -0,0 +1,38 @@ +#!/bin/bash +PASSFILE="$HOME/.eg-admin-pass" +AUTHTOKEN="" +TODAY=$(date +'%F'); +NOTIFY_EMAIL="bserickson@kcls.org" +LOGFILE="/openils/var/log/ums_user_balances.log" + +function set_auth_token() { + + if [ ! -f $PASSFILE ]; then + echo "Admin password file '$PASSFILE' required!" + exit 1; + fi; + + PASSWORD=$(cat $PASSFILE); + + AUTHTOKEN=$( + echo "login admin $PASSWORD" | /openils/bin/srfsh \ + | grep "Login Session:" | cut -d' ' -f3 | cut -d'.' -f1 + ); + + #echo "Authtoken acquired: $AUTHTOKEN" +} + +set_auth_token; + +# Build the request piecemeal for readability +PARAMS="{\"location\":\"KCLS\",\"start_date\":\"1900-01-01\",\"end_date\":\"$TODAY\"}"; +REQUEST="request open-ils.collections open-ils.collections.user_balance_summary.generate" + +echo "$REQUEST \"$AUTHTOKEN\", $PARAMS" | /openils/bin/srfsh > "$LOGFILE" + +if [ -n "$EG_UTIL_NOTIFY" ]; then + cat "$LOGFILE" | mailx -s \ + "UMS Monthly [$TODAY] User Balance Export Started" $NOTIFY_EMAIL +fi + + -- 2.11.0