#!/bin/sh
# File	: afsp-db_functions.sh
# By	: Maarten.deBoer@Atos.net, 150904
# Subject	: Script with functions for AFSP-DB
#(0.2)	: Mod if [ "${DB_FILE}" != "" ]; then
#(0.3),160721	: Added DFM_
#(0.4),160726	: Added COMMENTS
#(0.5),170828	: Added some new VAR's
#(0.6),171228	: Added NetApp (NA_) VAR's
#(0.7),190626	: Added some more NetApp (NA_)'s
PGM="`basename $0|cut -d\. -f1`"
FUNCVER="0.7"

# Functions

echo "Reading functions v${FUNCVER} ${PGM} ..."

export DB_FUNC_VER
function DB_FUNC_VER
{
  echo "${PGM} v${FUNCVER}"
}

# read DB_FILE in
function DB_READ 
{
  DB_FILE=${1}
  if [ -f ${DB_FILE} ]; then
    DB_SERIAL_NUMBER="`grep ^SERIAL_NUMBER ${DB_FILE}|awk -F\= '{print $2}'`"
    DB_CONTROLER_NAME="`grep ^CONTROLER_NAME ${DB_FILE}|awk -F\= '{print $2}'`"
    DB_MODEL_NAME="`grep ^MODEL_NAME ${DB_FILE}|awk -F\= '{print $2}'`"
    DB_OS_VERSION="`grep ^OS_VERSION ${DB_FILE}|awk -F\= '{print $2}'`"
    DB_PARTNER_HOSTNAME="`grep ^PARTNER_HOSTNAME ${DB_FILE}|awk -F\= '{print $2}'`"
    DB_SNMP_CONTACT="`grep ^SNMP_CONTACT ${DB_FILE}|awk -F\= '{print $2}'`"
    DB_SNMP_LOCATION="`grep ^SNMP_LOCATION ${DB_FILE}|awk -F\= '{print $2}'`"
    DB_ASUP_GENERATED_ON="`grep ^ASUP_GENERATED_ON ${DB_FILE}|awk -F\= '{print $2}'`"
    DB_SYSTEM_ID="`grep ^SYSTEM_ID ${DB_FILE}|awk -F\= '{print $2}'`"
    DB_DFM_SERVERNAME="`grep ^DFM_SERVERNAME ${DB_FILE}|awk -F\= '{print $2}'`"
    DB_DFM_UPDATE_DATE="`grep ^DFM_UPDATE_DATE ${DB_FILE}|awk -F\= '{print $2}'`"
    DB_REMARKS="`grep ^REMARKS ${DB_FILE}|awk -F\= '{print $2}'`"
# New since 2017-08-28
    DB_CONTRACT_NAME="`grep ^CONTRACT_NAME ${DB_FILE}|awk -F\= '{print $2}'`"
    DB_SITE_NAME="`grep ^SITE_NAME ${DB_FILE}|awk -F\= '{print $2}'`"
    DB_CONTACT_NAME="`grep ^CONTACT_NAME ${DB_FILE}|awk -F\= '{print $2}'`"
# New since 2017-12-28
	DB_NA_SERIAL_NUMBER="`grep ^NA_SERIAL_NUMBER ${DB_FILE}|awk -F\= '{print $2}'`"
	DB_NA_SYSTEM_NAME="`grep ^NA_SYSTEM_NAME ${DB_FILE}|awk -F\= '{print $2}'`"
	DB_NA_PLATFORM="`grep ^NA_PLATFORM ${DB_FILE}|awk -F\= '{print $2}'`"
	DB_NA_OS_VERSION="`grep ^NA_OS_VERSION ${DB_FILE}|awk -F\= '{print $2}'`"
	DB_NA_EOS_DATE="`grep ^NA_EOS_DATE ${DB_FILE}|awk -F\= '{print $2}'`"
	DB_NA_ASUP_STATUS="`grep ^NA_ASUP_STATUS ${DB_FILE}|awk -F\= '{print $2}'`"
	DB_NA_ASUP_DECLINED_REASON="`grep ^NA_ASUP_DECLINED_REASON ${DB_FILE}|awk -F\= '{print $2}'`"
	DB_NA_LAST_ASUP="`grep ^NA_LAST_ASUP ${DB_FILE}|awk -F\= '{print $2}'`"
    DB_NA_SERVICE_LEVEL="`grep ^NA_SERVICE_LEVEL ${DB_FILE}|awk -F\= '{print $2}'`"
    DB_NA_ENTITLEMENT_STATUS="`grep ^NA_ENTITLEMENT_STATUS ${DB_FILE}|awk -F\= '{print $2}'`"
	DB_NA_PRIM_CONTACT_NAME="`grep ^NA_PRIM_CONTACT_NAME ${DB_FILE}|awk -F\= '{print $2}'`"
	DB_NA_PRIM_CONTACT_NUMBER="`grep ^NA_PRIM_CONTACT_NUMBER ${DB_FILE}|awk -F\= '{print $2}'`"
	DB_NA_PRIM_CONTACT_MAIL="`grep ^NA_PRIM_CONTACT_MAIL ${DB_FILE}|awk -F\= '{print $2}'`"
	DB_NA_GROUP_NAME="`grep ^NA_GROUP_NAME ${DB_FILE}|awk -F\= '{print $2}'`"
	DB_NA_INSTALLED_AT="`grep ^NA_INSTALLED_AT ${DB_FILE}|awk -F\= '{print $2}'`"
	DB_NA_CONTRACT="`grep ^NA_CONTRACT ${DB_FILE}|awk -F\= '{print $2}'`"
# (0.7) Added
	DB_NA_ASUP_DECLINED_REASON="`grep ^NA_ASUP_DECLINED_REASON ${DB_FILE}|awk -F\= '{print $2}'`"
    DB_NA_SERVICE_REPORT_TO_ADDRESS_STATUS="`grep ^NA_SERVICE_REPORT_TO_ADDRESS_STATUS ${DB_FILE}|awk -F\= '{print $2}'`"
    DB_NA_SERVICE_REPORT_TO_ADDRESS="`grep ^NA_SERVICE_REPORT_TO_ADDRESS ${DB_FILE}|awk -F\= '{print $2}'`"
    DB_NA_SERVICE_REPORT_TO_CITY="`grep ^NA_SERVICE_REPORT_TO_CITY ${DB_FILE}|awk -F\= '{print $2}'`"
    DB_NA_SERVICE_REPORT_TO_REGION="`grep ^NA_SERVICE_REPORT_TO_REGION ${DB_FILE}|awk -F\= '{print $2}'`"
    DB_NA_SERVICE_REPORT_TO_POSTAL_CODE="`grep ^NA_SERVICE_REPORT_TO_POSTAL_CODE ${DB_FILE}|awk -F\= '{print $2}'`"
    DB_NA_SERVICE_REPORT_TO_COUNTRY="`grep ^NA_SERVICE_REPORT_TO_COUNTRY ${DB_FILE}|awk -F\= '{print $2}'`"

    if [ "${DB_MODEL_NAME}" = "" ]; then
      DB_MODEL_NAME=""
    fi
  else
    echo "`date` No DB_FILE (${DB_FILE}) found "
  fi  # if -f
}

function DB_WRITE 
{
  DB_FILE=${1}
  if [ "${DB_FILE}" != "" ]; then
    echo "  Writing ${PGM} ${DB_FILE} ..."
    echo "SERIAL_NUMBER=${DB_SERIAL_NUMBER}" > ${DB_FILE}
    echo "CONTROLER_NAME=${DB_CONTROLER_NAME}" >> ${DB_FILE}
    echo "MODEL_NAME=${DB_MODEL_NAME}" >> ${DB_FILE}
    echo "OS_VERSION=${DB_OS_VERSION}" >> ${DB_FILE}
    echo "PARTNER_HOSTNAME=${DB_PARTNER_HOSTNAME}" >> ${DB_FILE}
    echo "SNMP_CONTACT=${DB_SNMP_CONTACT}" >> ${DB_FILE}
    echo "SNMP_LOCATION=${DB_SNMP_LOCATION}" >> ${DB_FILE}
    echo "ASUP_GENERATED_ON=${DB_ASUP_GENERATED_ON}" >> ${DB_FILE}
    echo "SYSTEM_ID=${DB_SYSTEM_ID}" >> ${DB_FILE}
    echo "DFM_SERVERNAME=${DB_DFM_SERVERNAME}" >> ${DB_FILE}
    echo "DFM_UPDATE_DATE=${DB_DFM_UPDATE_DATE}" >> ${DB_FILE}
    echo "REMARKS=${DB_REMARKS}" >> ${DB_FILE}
# New since 2017-08-28
    echo "CONTRACT_NAME=${DB_CONTRACT_NAME}" >> ${DB_FILE}
    echo "SITE_NAME=${DB_SITE_NAME}" >> ${DB_FILE}
    echo "CONTACT_NAME=${DB_CONTACT_NAME}" >> ${DB_FILE}
# New since 2017-12-28
    echo "NA_SERIAL_NUMBER=${DB_NA_SERIAL_NUMBER}" >> ${DB_FILE}
    echo "NA_SYSTEM_NAME=${DB_NA_SYSTEM_NAME}" >> ${DB_FILE}
    echo "NA_PLATFORM=${DB_NA_PLATFORM}" >> ${DB_FILE}
    echo "NA_OS_VERSION=${DB_NA_OS_VERSION}" >> ${DB_FILE}
    echo "NA_EOS_DATE=${DB_NA_EOS_DATE}" >> ${DB_FILE}
    echo "NA_ASUP_STATUS=${DB_NA_ASUP_STATUS}" >> ${DB_FILE}
    echo "NA_LAST_ASUP=${DB_NA_LAST_ASUP}" >> ${DB_FILE}
    echo "NA_SERVICE_LEVEL=${DB_NA_SERVICE_LEVEL}" >> ${DB_FILE}
    echo "NA_ENTITLEMENT_STATUS=${DB_NA_ENTITLEMENT_STATUS}" >> ${DB_FILE}
    echo "NA_PRIM_CONTACT_NAME=${DB_NA_PRIM_CONTACT_NAME}" >> ${DB_FILE}
    echo "NA_PRIM_CONTACT_NUMBER=${DB_NA_PRIM_CONTACT_NUMBER}" >> ${DB_FILE}
    echo "NA_PRIM_CONTACT_MAIL=${DB_NA_PRIM_CONTACT_MAIL}" >> ${DB_FILE}
    echo "NA_GROUP_NAME=${DB_NA_GROUP_NAME}" >> ${DB_FILE}
    echo "NA_INSTALLED_AT=${DB_NA_INSTALLED_AT}" >> ${DB_FILE}
    echo "NA_CONTRACT=${DB_NA_CONTRACT}" >> ${DB_FILE}
# (0.7)
    echo "NA_ASUP_DECLINED_REASON=${DB_NA_ASUP_DECLINED_REASON}" >> ${DB_FILE}
    echo "NA_SERVICE_REPORT_TO_ADDRESS_STATUS=${DB_SERVICE_REPORT_TO_ADDRESS_STATUS}" >> ${DB_FILE}
    echo "NA_SERVICE_REPORT_TO_ADDRESS=${DB_NA_SERVICE_REPORT_TO_ADDRESS}" >> ${DB_FILE}
    echo "NA_SERVICE_REPORT_TO_CITY=${DB_NA_SERVICE_REPORT_TO_CITY}" >> ${DB_FILE}
    echo "NA_SERVICE_REPORT_TO_REGION=${DB_NA_SERVICE_REPORT_TO_REGION}" >> ${DB_FILE}
    echo "NA_SERVICE_REPORT_TO_POSTAL_CODE=${DB_NA_SERVICE_REPORT_TO_POSTAL_CODE}" >> ${DB_FILE}
    echo "NA_SERVICE_REPORT_TO_COUNTRY=${DB_NA_SERVICE_REPORT_TO_COUNTRY}" >> ${DB_FILE}

    echo "LAST_DB_UPDATE_BY=${PGM} v${VER} at `date`" >> ${DB_FILE}
  else
    echo "`date` No DB_FILE (${DB_FILE}) defined "
  fi
}