
#!/bin/sh
# File	: upd_netapp_video-page.sh
# By	: MaartenDeBoer, 2018-03-09
# Subject	: Script to update (NetApp-)video (WEB)page
#(0.2),180309	: Added SUBJECT+URL, RCFILE
#(0.3),180309	: Category
#(0.4),180730	: Changed name (from upd_video-page.sh)
PGM=`basename $0|cut -d\. -f1`
VER="0.4"
TMP="/tmp/${PGM}.$$"
LOG="${HOME}/log/${PGM}.log"
HOSTNAME=`hostname|cut -d\. -f1`
MAILTO="netapp@agrarix.nl"

RCFILE="${HOME}/etc/${PGM}.rc"
INFILE="${HOME}/data/netapp/videos"
PAGEDIR="/var/www/vhosts/netapp.agrarix.com/html/videos"
PAGE="${PAGEDIR}/index.html"

TITLE="Videos about NetApp from others then NetApp"
BORDER="0"
TXTSIZE="3"
TXTFACE="arial"
SORTKEYS="4,5"

SUBJECT=""
URL=""
AUTHOR=""
CATEGORY=""
REMARKS=""

echo "`date` ${PGM} v${VER} started. (${HOSTNAME})"|tee -a ${LOG}
touch ${TMP}
if [ ! -d ${PAGEDIR} ]; then
  echo "  Pagedir ${PAGEDIR} does NOT exist. Exiting ..."|tee -a ${LOG}
  exit 2
fi
if [ ! -f ${INFILE} ]; then
  echo "  Input file ${INFILE} does NOT exist. Exiting ..."|tee -a ${LOG}
  exit 3
fi

if [ -f ${RCFILE} ]; then
  echo "  Reading RC-file (${RCFILE})..."|tee -a ${LOG}
  . ${RCFILE}
fi

echo "<HTML>" > ${PAGE} 
echo "<HEAD>" >> ${PAGE} 
echo "<META charset='UTF-8'>" >> ${PAGE} 
echo "<META name='author' content='Maarten de Boer' />" >> ${PAGE} 
echo "<META name='author' content='Maarten de Boer' />" >> ${PAGE} 
echo "<META name='generator' content='${PGM} v${VER}' />">> ${PAGE} 
echo '<link rel="icon" href="netapp-logo-N.png" type="image/png">'>> ${PAGE} 
echo "<TITLE>${TITLE}</TITLE>" >> ${PAGE} 
echo "<basefont face='arial'>" >> ${PAGE} 
echo "</HEAD>" >> ${PAGE} 

#echo "<BODY aLink=red bgColor=#D3D0D3 link=red text=#000000 vLink=red>" >> ${PAGE} 
echo "<BODY aLink=red bgColor=white link=red text=#000000 vLink=red>" >> ${PAGE} 
echo "<TABLE BORDER=0 WIDTH='100%'>" >> ${PAGE} 
echo "<TR HEIGHT=40px>" >> ${PAGE} 
echo " <TD bgColor=#1E4B8E>" >> ${PAGE} 
echo " <FONT COLOR=white face='arial' size='5'> ${TITLE} </FONT>" >> ${PAGE} 
echo " <BR>" >> ${PAGE} 
echo " <DIV align=left>" >> ${PAGE}
echo " <DIV align=right>" >> ${PAGE} 
echo " </DIV>" >> ${PAGE} 
echo " <TD>" >> ${PAGE} 
echo "</TR>" >> ${PAGE} 
echo "</TABLE>" >> ${PAGE}


echo "  <TABLE BORDER=${BORDER}>" >> ${PAGE}

echo "   <TR> " >> ${PAGE}
#echo "    <TD><FONT COLOR=black face='arial'><B>Subject</B></TD> " >> ${PAGE}
#echo "    <TD><FONT COLOR=black face='arial'><B>URL</B></TD> " >> ${PAGE}
echo "    <TD><FONT COLOR=black face='arial'><B>Date</B></TD> " >> ${PAGE}
echo "    <TD><FONT COLOR=black face='arial'><B>Subject (+ URL) </B></TD> " >> ${PAGE}
echo "    <TD><FONT COLOR=black face='arial'><B>Category</B></TD> " >> ${PAGE}
echo "    <TD><FONT COLOR=black face='arial'><B>Author</B></TD> " >> ${PAGE}
echo "    <TD><FONT COLOR=black face='arial'><B>Remarks</B></TD> " >> ${PAGE}
echo "   </TR> " >> ${PAGE}

echo "  Writing to ${PAGE}"|tee -a ${LOG}

cat ${INFILE}|grep -v ^#|sort --field-separator=';' --key="${SORTKEYS}" --reverse|while read LINE
do
  echo "${LINE}"
  SUBJECT=`echo ${LINE}|awk -F\; '{print $1}'`
  CATEGORY=`echo ${LINE}|awk -F\; '{print $2}'`
  URL=`echo ${LINE}|awk -F\; '{print $3}'`
  DATE=`echo ${LINE}|awk -F\; '{print $4}'`
  AUTHOR=`echo ${LINE}|awk -F\; '{print $5}'`
  REMARKS=`echo ${LINE}|awk -F\; '{print $6}'`

  BGC=""
  echo "   <TR> " >> ${PAGE}
#  echo "    <TD BGCOLOR=${BGC}><FONT COLOR=black face=${TXTFACE} size=${TXTSIZE}> ${SUBJECT} </TD> " >> ${PAGE}
#  echo "    <TD BGCOLOR=${BGC}><FONT COLOR=black face=${TXTFACE} size=${TXTSIZE}> <A HREF="${URL}" TARGET=\"_blank\"> ${URL} </A> </TD> " >> ${PAGE}
  echo "    <TD BGCOLOR=${BGC}><FONT COLOR=black face=${TXTFACE} size=${TXTSIZE}> ${DATE} </TD> " >> ${PAGE}
  echo "    <TD BGCOLOR=${BGC}><FONT COLOR=black face=${TXTFACE} size=${TXTSIZE}> <A HREF="${URL}" TARGET=\"_blank\"> ${SUBJECT} </A> </TD> " >> ${PAGE}
  echo "    <TD BGCOLOR=${BGC}><FONT COLOR=black face=${TXTFACE} size=${TXTSIZE}> ${CATEGORY} </TD> " >> ${PAGE}
  echo "    <TD BGCOLOR=${BGC}><FONT COLOR=black face=${TXTFACE} size=${TXTSIZE}> ${AUTHOR} </TD> " >> ${PAGE}
  echo "    <TD BGCOLOR=${BGC}><FONT COLOR=black face=${TXTFACE} size=${TXTSIZE}> ${REMARKS} </TD> " >> ${PAGE}
  
  echo "   </TR> " >> ${PAGE}

done  # cat

echo "  <BR>" >> ${PAGE}

echo "<TABLE BORDER=0 WIDTH='100%'>" >> ${PAGE} 
echo "<TR>" >> ${PAGE} 
echo " <TD bgColor=#1E4B8E>" >> ${PAGE} 
echo " <FONT COLOR=white face='Verdana' size='1'>" >> ${PAGE} 
echo " <CENTER>" >> ${PAGE} 
echo "Content Owner & Contact (if you have more URLs of videos) : <A HREF=mailto:${MAILTO}>${MAILTO}</A> |Last Update:`date`" >> ${PAGE} 
echo " <BR>" >> ${PAGE} 
echo " </CENTER>" >> ${PAGE} 
echo " </FONT>" >> ${PAGE} 
echo " </TD>" >> ${PAGE} 
echo "</TR>" >> ${PAGE} 
echo "</TABLE>" >> ${PAGE} 
echo "</BODY>" >> ${PAGE} 
echo "</HTML>" >> ${PAGE}

exit 0

