
#!//bin/sh
# File	: proc_models.sh
# By	: Maarten.deBoer@Atos.net, 2015-03-14
# Subject	: Script to process filer-release input to web-pages
#(0.3)	: Mod FONT
#(0.4)	: Add COntact
#(0.5)	: Mod dir's & added LOG
#(0.6)	: Added BASEDIR, Mod: html/versions.html
#(0.7)	: From proc_versions.sh
#(0.2)	: Add COUNTRY
# set -x
PGM="`basename $0|cut -d\. -f1`"
VER="0.1"
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/model-version/dfm-filer-name-loc-model-os-fw-sn-partner.csv"
OUT="${BASEDIR}/html/models.html"

COUNTRY="`echo ${BASEDIR}| cut -d\/ -f6`"


echo "`date` ${PGM} v${VER} started." | tee -a ${LOG}
echo "BASEDIR=${BASEDIR}"

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> models </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 WIDTH=100% HEIGHT=40px>" >> ${OUT}
echo "  <TD bgColor=#0066A1>" >> ${OUT}
echo "    <FONT COLOR=white face='verdana' size='5'> <B> <A HREF="index.html">Filer</A> models (& ontap levels / OS-versions) 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 "<TR>" >> ${OUT}

#echo "  <TABLE BORDER=1 WIDTH='100%'>" >> ${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>Model:</B> </TD> " >> ${OUT}
echo "  <TD> <FONT face='verdana' size=1> <B>Serial Number:</B> </TD> " >> ${OUT}
echo "  <TD> <FONT face='verdana' size=1> <B>OS Version:</B> </TD> " >> ${OUT}
echo "  <TD> <FONT face='verdana' size=1> <B>BIOS Version:</B> </TD> " >> ${OUT}
echo "  <TD> <FONT face='verdana' size=1> <B>Partner:</B> </TD> " >> ${OUT}
echo "  <TD> <FONT face='verdana' size=1> <B>SNMP location:</B> </TD> " >> ${OUT}
echo "  <TD> <FONT face='verdana' size=1> <B>SNMP contact:</B> </TD> " >> ${OUT}
echo "  <TD> <FONT face='verdana' size=1> <B>Usage:</B> </TD> " >> ${OUT}
echo "</TR>" >> ${OUT}


cat ${IN}|sort|grep -v ^#|while read LINE
do
  FILER="`echo ${LINE}| awk -F\; '{print $1}'`"
#  LOC="`echo ${LINE}|awk -F\, '{print $2}'|cut -d' ' -f1`"
  LOC="`grep ${FILER} ${FLU} |awk -F\; '{print $2}'|sed 's/ //g'`"

#  USAGE="`echo ${LINE}|awk -F\, '{print $2}'|cut -d\[ -f2|cut -d\] -f1`"
  USAGE="`grep ${FILER} ${FLU} |awk -F\; '{print $3}'|sed 's/ //g'`"

  MODEL="`echo ${LINE}|awk -F\; '{print $3}'|sed 's/ //g'`"
  OSVERSION="`echo ${LINE}|awk -F\; '{print $4}'`"
  FWVERSION="`echo ${LINE}|awk -F\; '{print $5}'|sed 's/ //g'`"
  SERNR="`echo ${LINE}|awk -F\; '{print $6}'|sed 's/ //g'`"
  PARTNER="`echo ${LINE}|awk -F\; '{print $7}'|sed 's/ //g'`"
  SNMPLOC="`echo ${LINE}|awk -F\; '{print $2}'`"
  SNMPCONTACT="`echo ${LINE}|awk -F\; '{print $8}'|sed 's/ //g'`"

  echo "${FILER} ..."

  case ${LOC} in
    "NL-Eindhoven-HWU") LOCCOL="orange" ;;
    "NL-Eindhoven-Hurk") LOCCOL="yellow" ;;
    "NL-Eindhoven-Best") LOCCOL="green" ;;
    "NL-Amsterdam-NRW") LOCCOL="lightblue" ;;
    *) LOCCOL="";;
  esac

  OSCOL=""
  OSPART="`echo ${OSVERSION}|cut -d' ' -f1|cut -d'P' -f1|cut -d\. -f1,2`"
  case ${OSPART} in
    "7.2") OSCOL="red" ;;
    "7.3") OSCOL="orange" ;;
    "8.2") OSCOL="green" ;;
    "8.1") OSCOL="yellow" ;;
    "8.0") OSCOL="orange" ;;
  esac

  OSMODE="`echo ${OSVERSION}| cut -d' ' -f2`"
  case ${OSMODE} in
    "Cluster-Mode") OSCOL="lightblue" ;;
  esac

  echo ${OSVERSION}|grep 'RC' 1> /dev/null
  RC=${?}
  if [ ${RC} -eq 0 ]; then
    OSCOL="red"
  fi

#  case ${OSVERSION} in
#    "7.2.5.1") OSCOL="red" ;;
#    "8.2.1 7-Mode") OSCOL="lightgreen" ;;
#    "8.2.1P2 7-Mode") OSCOL="lightgreen" ;;
#    "8.2.2P1 7-Mode") OSCOL="green" ;;
#    "8.1.2P4 7-Mode") OSCOL="yellow" ;;
#    "8.1P2 7-Mode") OSCOL="orange" ;;
#    "8.2.2 Cluster-Mode") OSCOL="green" ;;
#    *) OSCOL="";;
#  esac

  case ${MODEL} in
    FAS202*) MODELCOL="red";;
    FAS205*) MODELCOL="red";;
    FAS30*) MODELCOL="red";;
    FAS204*) MODELCOL="orange";;
    FAS31*) MODELCOL="orange";;
    V31*) MODELCOL="orange";;
    FAS60*) MODELCOL="orange";;
    N79*) MODELCOL="orange";;
    FAS32*) MODELCOL="yellow";;
    FAS62*) MODELCOL="yellow";;
    N34*) MODELCOL="yellow";;
    N62*) MODELCOL="yellow";;
    FAS22*) MODELCOL="lightgreen";;
    FAS25*) MODELCOL="green";;
    FAS80*) MODELCOL="green";;
    FAS622*) MODELCOL="lightgreen";;
    FAS625*) MODELCOL="lightgreen";;
    FAS629*) MODELCOL="lightgreen";;
    *) MODELCOL="";;
  esac


  echo "<TR>" >> ${OUT}
  echo "  <TD> <FONT face='verdana' size=1> ${FILER} </FONT> </TD> " >> ${OUT}
  echo "  <TD BGCOLOR=${MODELCOL}> <FONT face='verdana' size=1> ${MODEL} </FONT> </TD> " >> ${OUT}
  echo "  <TD> <FONT face='verdana' size=1> ${SERNR} </FONT> </TD> " >> ${OUT}
  echo "  <TD BGCOLOR=${OSCOL}> <FONT face='verdana' size=1> ${OSVERSION} </FONT> </TD> " >> ${OUT}
  echo "  <TD> <FONT face='verdana' size=1> ${FWVERSION} </FONT> </TD> " >> ${OUT}
  echo "  <TD> <FONT face='verdana' size=1> ${PARTNER} </FONT> </TD> " >> ${OUT}
  echo "  <TD> <FONT face='verdana' size=1> ${SNMPLOC} </FONT> </TD> " >> ${OUT}
  echo "  <TD> <FONT face='verdana' size=1> ${SNMPCONTACT} </FONT> </TD> " >> ${OUT}
  echo "  <TD> <FONT face='verdana' size=1> ${USAGE} </FONT> </TD> " >> ${OUT}
  echo "</TR>" >> ${OUT}


done

echo "<TR>" >> ${OUT}
echo "  <TD> <FONT face='verdana' size=1> <B>Name:</B> </TD> " >> ${OUT}
echo "  <TD> <FONT face='verdana' size=1> <B>Model:</B> </TD> " >> ${OUT}
echo "  <TD> <FONT face='verdana' size=1> <B>Serial Number:</B> </TD> " >> ${OUT}
echo "  <TD> <FONT face='verdana' size=1> <B>OS Version:</B> </TD> " >> ${OUT}
echo "  <TD> <FONT face='verdana' size=1> <B>BIOS Version:</B> </TD> " >> ${OUT}
echo "  <TD> <FONT face='verdana' size=1> <B>Partner:</B> </TD> " >> ${OUT}
echo "  <TD> <FONT face='verdana' size=1> <B>SNMP location:</B> </TD> " >> ${OUT}
echo "  <TD> <FONT face='verdana' size=1> <B>SNMP contact:</B> </TD> " >> ${OUT}
echo "  <TD> <FONT face='verdana' size=1> <B>Usage:</B> </TD> " >> ${OUT}
echo "</TR>" >> ${OUT}


COUNT="`cat ${IN}|grep -v '^#'|wc -l|awk '{print $1}'`"
echo "<TR>" >> ${OUT}
  echo "  <TD> <FONT face='verdana' size=1> ${COUNT} filers </FONT> </TD> " >> ${OUT}
echo "</TR>" >> ${OUT}

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

#echo "Processed at `date` @${HOSTNAME} by ${PGM} v${VER} <P>" >> ${OUT}
#echo "<P>" >> ${OUT}

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

echo "  <TABLE>" >> ${OUT}
echo "    <TR>" >> ${OUT}
echo "      <TD><FONT face= 'verdana' size=2>Legenda: </TD>" >> ${OUT}
echo "    </TR>" >> ${OUT}
echo "    <TR>" >> ${OUT}
echo "      <TD><FONT face= 'verdana' size=2>Model: </TD>" >> ${OUT}
echo "      <TD BGCOLOR=green> <FONT face= 'verdana' size=2>New</FONT> </TD>" >> ${OUT}
echo "      <TD BGCOLOR=lightgreen> <FONT face= 'verdana' size=2>End of Support in 2020</FONT> </TD>" >> ${OUT}
echo "      <TD BGCOLOR=yellow> <FONT face= 'verdana' size=2>End of Support in 2018</FONT> </TD>" >> ${OUT}
echo "      <TD BGCOLOR=orange> <FONT face= 'verdana' size=2>End of Support in 2017</FONT> </TD>" >> ${OUT}
echo "      <TD BGCOLOR=red> <FONT face= 'verdana' size=2>End of Support</FONT> </TD>" >> ${OUT}
echo "    </TR>" >> ${OUT}
echo "    <TR>" >> ${OUT}
echo "      <TD><FONT face= 'verdana' size=2>OS Version: </TD>" >> ${OUT}
echo "      <TD BGCOLOR=green> <FONT face= 'verdana' size=2>Latest (8.2)</FONT> </TD>" >> ${OUT}
echo "      <TD BGCOLOR=yellow> <FONT face= 'verdana' size=2>Previous (8.1)</FONT> </TD>" >> ${OUT}
echo "      <TD BGCOLOR=orange> <FONT face= 'verdana' size=2>Older (8.0 / 7.3)</FONT> </TD>" >> ${OUT}
echo "      <TD BGCOLOR=red> <FONT face= 'verdana' size=2>Old (7.2 / RC)</FONT> </TD>" >> ${OUT}
echo "    </TR>" >> ${OUT}
echo "  </TABLE>" >> ${OUT}


echo "<TABLE BORDER=0 WIDTH='100%'>" >> ${OUT}
echo "<TR WIDTH=100% > " >> ${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

