
#!//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
# set -x
PGM="`basename $0|cut -d\. -f1`"
VER="0.6"
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 "<!DOCTYPE html>" > ${OUT}
echo "<HTML>" >> ${OUT}
echo "<HEAD>" >> ${OUT}
echo "<META charset='UTF-8'>" >> ${OUT}
echo "<META content=Maarten de Boer name=AUTHOR>" >> ${OUT}
echo "<TITLE>failed disks</TITLE>" >> ${OUT}
echo "<basefont face='verdana'>" >> ${OUT}
echo "</HEAD>" >> ${OUT}

echo "<BODY aLink=red bgColor=#D3D0D3 link=red text=#000000 vLink=#ff0000>" >> ${OUT}

echo "<TABLE BORDER=0 WIDTH='100%'>" >> ${OUT}
echo "  <TR HEIGHT=40px>" >> ${OUT}
echo "    <TD bgColor=#0066A1>" >> ${OUT}
echo "      <FONT COLOR=white face='Verdana' size='5'> <B>  <A HREF="../${COUNTRY}-overview.html">Filer</A> failed disks of ${COUNTRY} </B> </FONT>" >> ${OUT}
echo "      <BR>" >> ${OUT}
echo "      <DIV align=right>" >> ${OUT}
echo "      <FONT COLOR=white face='verdana' size='-3'> For internal use. (c) Atos BTN 2015 </B> </FONT>" >> ${OUT}
echo "      </DIV>" >> ${OUT}
echo "    <TD>" >> ${OUT}
echo "  </TR>" >> ${OUT}
echo "</TABLE>" >> ${OUT}

echo "<P>" >> ${OUT}

echo "<TABLE BORDER=1 >" >> ${OUT}
echo "  <TR>" >> ${OUT}
echo "    <TD> <FONT face='verdana' size=1> <B>Name:</B> </TD> " >> ${OUT}
echo "    <TD> <FONT face='verdana' size=1> <B>Serial Number:</B> </TD> " >> ${OUT}
echo "    <TD> <FONT face='verdana' size=1> <B>Model:</B> </TD> " >> ${OUT}
echo "    <TD> <FONT face='verdana' size=1> <B>OS Version:</B> </TD> " >> ${OUT}
echo "    <TD> <FONT face='verdana' size=1> <B>Failed disks:</B> </TD> " >> ${OUT}
echo "  </TR>" >> ${OUT}


cat ${IN}|grep -v ^#|sort|while read LINE
do
  FILER="`echo ${LINE}|awk -F\; '{print $1}'|sed 's/ //g'`"
  SERNR="`echo ${LINE}|awk -F\; '{print $2}'`"
  DISKS="`echo ${LINE}|awk -F\; '{print $3}'`"
# Get information from DataBase
  DBFILE="${DBDIR}/${SERNR}.asc"
  DB_READ ${DBFILE}

  MODEL="${DB_MODEL_NAME}"
  OSVERSION="${DB_OS_VERSION}"

#  LOC="`grep ${FILER} ${FLU} |awk -F\; '{print $2}'|sed 's/ //g'`"
#  USAGE="`grep ${FILER} ${FLU} |awk -F\; '{print $3}'|sed 's/ //g'`"

  echo "${FILER} ..."

  DISKCOL=""
#  if [ "${DISKS}" != "" ]; then
#    DISKCOL="orange"
#  fi

  echo "<TR>" >> ${OUT}
  echo "  <TD> <FONT face='verdana' size=1> ${FILER} </TD> " >> ${OUT}
  echo "  <TD> <FONT face='verdana' size=1> ${SERNR} </TD> " >> ${OUT}
  echo "  <TD> <FONT face='verdana' size=1> ${MODEL} </TD> " >> ${OUT}
  echo "  <TD> <FONT face='verdana' size=1> ${OSVERSION} </TD> " >> ${OUT}
  echo "  <TD BGCOLOR=${DISKCOL}> <FONT face='verdana' size=1> ${DISKS} </TD> " >> ${OUT}
  echo "</TR>" >> ${OUT}

done
echo "  </TABLE>" >> ${OUT}

echo "<P>" >> ${OUT}
 
echo "</TR>" >> ${OUT}

echo "<TABLE WIDTH=100% > " >> ${OUT}
echo "  <TR> " >> ${OUT}
echo "    <TD bgColor=#0066A1 > " >> ${OUT}
echo "      <FONT COLOR=white face='Verdana' size='1'>" >> ${OUT}
echo "        <CENTER>" >> ${OUT}
echo "Contact: |Content Owner: <A HREF="mailto:Maarten.deBoer@Atos.net">Maarten de Boer</A> |Last Update: `date`<BR>" >> ${OUT}
echo "For internal use (c) Atos S.A. 2015 all rights reserved. Reproduction in whole or in part is prohibited without the written consent of Atos SA." >> ${OUT}
echo "        </CENTER>" >> ${OUT}
echo "      </FONT>" >> ${OUT}
echo "    </TD>" >> ${OUT}
echo "  </TR>" >> ${OUT}
echo "</TABLE>" >> ${OUT}

echo "</BODY>" >> ${OUT}
echo "</HTML>" >> ${OUT}


echo "`date` ${PGM} finished. "|tee -a ${LOG}
exit 0

