#!//bin/sh
# File : upd_failed-disks.sh
# By : Maarten.deBoer@Atos.net, 2015-03-14
# Subject : Script to process failed disks into web-pages
#(0.2) : Show only failed disks
#(0.3) : Added BASEDIR
#(0.4) : Mod IN & sort
#(0.5) : Add COUNTRY
#(0.6) : Changed for country
#(0.7) : Added MODEL & VERSION
#(0.8),180530 : Mod SerNr, Name, Last ASUP, colors & disk-failure lines dur to change of proc_asup-files_for_disk-failure.sh
#(0.9),200622 : Mod. cellspacing='0'
#(0.10),220824 : Mod. "NOT supported"
# set -x
PGM="`basename $0|cut -d\. -f1`"
VER="0.10"
TMP="/tmp/${PGM}.$$"
#BASEDIR="/appl/mdr/afsp/NL"
BASEDIR="`pwd | sed 's/scripts//'|sed 's/bin//'`"
LOG="${BASEDIR}/log/${PGM}.log"
#FLU="${BASEDIR}/etc/filer-location-usage.csv"
IN="${BASEDIR}/data/afsp-disks-failures.csv"
OUT="${BASEDIR}/html/failed-disks.html"
DBDIR="${BASEDIR}/data/database"
COUNTRY="`echo ${BASEDIR}| cut -d\/ -f6`"
OUT="/appl/mdr/www/afsp/${COUNTRY}/failed-disks.html"
echo "`date` ${PGM} v${VER} started. "|tee -a ${LOG}
echo "BASEDIR=${BASEDIR}"
# Read Functions file
source ./afsp-db_functions.sh
DB_FUNC_VER
echo "" > ${OUT}
echo "" >> ${OUT}
echo "" >> ${OUT}
echo "" >> ${OUT}
echo "" >> ${OUT}
echo "AFSP:${COUNTRY}:failed disks" >> ${OUT}
echo "" >> ${OUT}
echo "" >> ${OUT}
echo "" >> ${OUT}
echo "" >> ${OUT}
echo " " >> ${OUT}
echo " " >> ${OUT}
echo " Filer failed disks of ${COUNTRY} " >> ${OUT}
echo "
" >> ${OUT}
echo " NOT maintained anymore " >> ${OUT}
echo " Because the other way (HTTPS) of delivery is not supported by AFSP (old way is SMTP). " >> ${OUT}
echo " " >> ${OUT}
echo " For internal use. (c) Atos BTN `date +%Y` " >> ${OUT}
echo " " >> ${OUT}
echo " | " >> ${OUT}
echo " |
" >> ${OUT}
echo "
" >> ${OUT}
echo "" >> ${OUT}
echo "
" >> ${OUT}
echo " " >> ${OUT}
echo " | Serial Number: | " >> ${OUT}
echo " Name: | " >> ${OUT}
echo " Last ASUP: | " >> ${OUT}
echo " Model: | " >> ${OUT}
echo " OS Version: | " >> ${OUT}
echo " Failed disks: | " >> ${OUT}
echo "
" >> ${OUT}
cat ${IN}|grep -v ^#|sort|while read LINE
do
SERNR="`echo ${LINE}|awk -F\; '{print $1}'`"
DISKLINE="`echo ${LINE}|awk -F\; '{print $4}'`"
# Get information from DataBase
DBFILE="${DBDIR}/${SERNR}.asc"
DB_READ ${DBFILE}
echo "${DB_CONTROLER_NAME} (${SERNR}) ..."
DISKCOL=""
ASUPCOL=""
YEAR="`date +%Y`"
ANSW="`echo "${DB_ASUP_GENERATED_ON}"|grep \" ${YEAR}\"`"
if [ "${ANSW}" = "" ]; then
ASUPCOL="red"
fi
ANSW="`echo "${DB_ASUP_GENERATED_ON}"|grep \" ${YEAR}\"`"
if [ "${ANSW}" != "" ]; then
ASUPCOL="orange"
fi
MONTH="`date +%b`"
ANSW="`echo "${DB_ASUP_GENERATED_ON}"|grep \" ${YEAR}\"|grep \" ${MONTH}\"`"
if [ "${ANSW}" != "" ]; then
ASUPCOL="yellow"
fi
DAY="`date +%d`"
ANSW="`echo "${DB_ASUP_GENERATED_ON}"|grep \" ${YEAR}\"|grep \" ${MONTH}\"|grep \" ${DAY}\"`"
if [ "${ANSW}" != "" ]; then
ASUPCOL="lightgreen"
fi
ANSW="`echo "${DB_ASUP_GENERATED_ON}"|egrep 'UTC|GMT'`"
if [ "${ANSW}" != "" ]; then
ASUPCOL="purple"
fi
echo "" >> ${OUT}
echo " | ${SERNR} | " >> ${OUT}
echo " ${DB_CONTROLER_NAME} | " >> ${OUT}
echo " ${DB_ASUP_GENERATED_ON} | " >> ${OUT}
echo " ${DB_MODEL_NAME} | " >> ${OUT}
echo " ${DB_OS_VERSION} | " >> ${OUT}
echo " ${DISKLINE} | " >> ${OUT}
echo "
" >> ${OUT}
done
echo "" >> ${OUT}
echo " | `grep failed ${IN}|wc -l` disks | " >> ${OUT}
echo "
" >> ${OUT}
echo "
" >> ${OUT}
echo "" >> ${OUT}
echo "" >> ${OUT}
echo "
" >> ${OUT}
echo " " >> ${OUT}
echo " " >> ${OUT}
echo " " >> ${OUT}
echo " " >> ${OUT}
echo "Contact: |Content Owner: Maarten de Boer |Last Update: `date` [${PGM} v${VER}]
" >> ${OUT}
echo "For internal use (c) Atos S.A. `date +%Y` all rights reserved. Reproduction in whole or in part is prohibited without the written consent of Atos SA." >> ${OUT}
echo " " >> ${OUT}
echo " " >> ${OUT}
echo " | " >> ${OUT}
echo "
" >> ${OUT}
echo "
" >> ${OUT}
echo "" >> ${OUT}
echo "" >> ${OUT}
echo "`date` ${PGM} finished. "|tee -a ${LOG}
exit 0