
#!/bin/sh
# File	: upd_temp-info.sh
# By	: Maarten.deBoer@atos.net, 240826
# Subject	: Script to update temperature info
# Next:
#(0.2),240916	: Upd HEADER & TITLE
#(0.3),250227	: Upd from CXTEMPDB
#(0.4),250228	: Add header /20 lines
PGM=`basename $0|cut -d\. -f1`
VER="0.4"
TMP="/tmp/${PGM}.$$"
LOG="${HOME}/log/${PGM}.log"
RCFILE="${HOME}/etc/${PGM}.rc"

#CSV="${HOME}/data/${PGM}.csv"
CSV="${HOME}/data/upd_cx-info_temperature.csv"
CXTEMPDB="/CX-info/_CXtempDB"

WEBDIR="/var/www/html/techlab/cx"
HTML="${WEBDIR}/temp-info.html"
FONTSIZE=1

HEADER="<A HREF='/techlab'>TechLab:</A> CX temperatures information page"
TITLE="TechLab: CX temperatures information page"

echo "`date` ${PGM} v${VER} started."|tee -a ${LOG}
if [ -f ${RCFILE} ]; then
  echo "  RCFILE (${RCFILE}) found. Reading ..."|tee -a ${LOG}
  . ${RCFILE}
fi  # RCFILE
echo "  CHK_SRV=${CHK_SRV}"
echo "  CSV=${CSV}"
echo "  HTML=${HTML}"
echo "  WEBDIR=${WEBDIR}"
echo "  TITLE=${TITLE}"
echo "  CXTEMPDB=${CXTEMPDB}"
sleep 1

if [ ! -d ${WEBDIR} ]; then
  echo "  NO WEBDIR (${WEBDIR}) found. Exiting ..."|tee -a ${LOG}
  exit 4
fi
if [ ! -d ${CXTEMPDB} ]; then
  echo "  NO CXTEMPDB (${CXTEMPDB}) found. Exiting ..."|tee -a ${LOG}
  exit 5
fi

touch ${TMP} 

echo "<!DOCTYPE html>" > ${HTML}
echo "<HTML>" >> ${HTML}
echo "<HEAD>" >> ${HTML}
echo "<META charset='UTF-8'>" >> ${HTML}
echo "<META content=Maarten de Boer name=AUTHOR>" >> ${HTML}
echo "<TITLE> ${TITLE} </TITLE>" >> ${HTML}
echo "<basefont face='verdana'>" >> ${HTML}
echo "</HEAD>" >> ${HTML}
echo "<BODY aLink=red bgColor=#D3D0D3 link=red text=#000000 vLink=#ff0000>" >> ${HTML}

echo "<TABLE BORDER=0 WIDTH='100%' cellspacing='0'>" >> ${HTML}
echo "<TR WIDTH=100% HEIGHT=40px>" >> ${HTML}
echo "  <TD bgColor=#0066A1>" >> ${HTML}
echo "    <FONT COLOR=white face='verdana' size='5'> ${HEADER} <BR> </FONT>" >> ${HTML}
echo "    <DIV align=right>" >> ${HTML}
echo "      <FONT COLOR=white face='verdana' size='-3'> For internal use. (c) Atos `date +%Y` </B> </FONT>" >> ${HTML}
echo "    </DIV>" >> ${HTML}
echo "  </TD>" >> ${HTML}
echo "</TR>" >> ${HTML}
echo "</TABLE>" >> ${HTML}


#----------------------------------------------------------------
echo "<TABLE BORDER=1 WIDTH='100%' cellspacing='0'>" >> ${HTML}
echo "  <TR WIDTH=100% <FONT face='verdana' size=\"${FONTSIZE}\"> " >> ${HTML}

#echo "  <TH> <FONT face=\"verdana\" size=\"${FONTSIZE}\"> Date Time </TH>" |tee -a ${HTML}
#LINE=`cat ${CSV}|grep ^#|grep "Header:"|tail -1|cut -d\: -f2`
#LINE2=`echo ${LINE}|sed "s|;|</TH><TH> <FONT face=\"verdana\" size=\"${FONTSIZE}\"> |g"`
#echo "  <TH> <FONT face=\"verdana\" size=\"${FONTSIZE}\"> ${LINE2} </TH>" |tee -a ${HTML}
#echo "  </TR>" >> ${HTML}

#tac ${CSV}|grep -v ^#|head -20 | while read LINE
#do
#  echo "  <TR> " >> ${HTML}
#  LINE2=`echo ${LINE}|sed 's|;|</TD><TD>|g'`
#  echo "  <TD> ${LINE2} </TD>" |tee -a ${HTML}
#  echo "  </TR>" >> ${HTML}
#done  # LINE

HTML_HDR()
{
# Date-Time header
echo "  <TH> <FONT face=\"verdana\" size=\"${FONTSIZE}\"> Date Time </TH>" |tee -a ${HTML}
cd ${CXTEMPDB}
ls -1 *temp.csv|cut -d\_ -f1|while read CX
do
  echo "${CX}"
  echo "  <TH> <FONT face=\"verdana\" size=\"${FONTSIZE}\"> ${CX} </TH>" >> ${HTML}
#  cat ${CXTEMPDB}/${CX}_temp.csv
done  # LINE
echo "  </TR> " >> ${HTML}
}

HTML_HDR

LINE_CNT=0
# Create date-time lines
cat *temp.csv|cut -d\; -f1|sort -ru|while read DATE_TIME
do
  LINE_CNT=`expr ${LINE_CNT} + 1`
  if [ ${LINE_CNT} -gt 10 ]; then
    HTML_HDR
    LINE_CNT=0
  fi  # LINE_CNT
  echo "LINE_CNT=${LINE_CNT}"

  echo "  <TR WIDTH=100% <FONT face='verdana' size=\"${FONTSIZE}\"> " >> ${HTML}
  echo "  DATE_TIME=${DATE_TIME}"
  echo "  <TD> ${DATE_TIME} </TD>" >> ${HTML}
  ls -1 *temp.csv|cut -d\_ -f1|while read CX
  do
#    echo "    CX=${CX}"
    TEMP=`cat *temp.csv|grep "${DATE_TIME}"|grep "${CX}"|awk -F\; '{print $3}'`
    echo "  <TD> ${TEMP} </TD>" >> ${HTML}
  done  # CX
  echo "  </TR> " >> ${HTML}
done  # DATE_TIME

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



#----------------------------------------------------------------
echo "<TABLE BORDER=0 WIDTH='100%' cellspacing='0'>" >> ${HTML}
echo "<TR WIDTH=100% > " >> ${HTML}
echo "  <TD bgColor=#0066A1 > " >> ${HTML}
echo "    <FONT COLOR=white face='Verdana' size='1'>" >> ${HTML}
echo "      <CENTER>" >> ${HTML}
echo "Contact: |Content Owner: <A HREF="mailto:Maarten.deBoer@Atos.net">Maarten de Boer</A> |Last Update: `date`|[${PGM} v${VER}]<BR>" >> ${HTML}
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." >> ${HTML}
echo "      </CENTER>" >> ${HTML}
echo "    </FONT>" >> ${HTML}
echo "  </TD>" >> ${HTML}
echo "</TR>" >> ${HTML}
echo "</TABLE>" >> ${HTML}

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



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

