
#!/bin/sh
# File	: upd_oud-papier-vijos-nl.sh
# By	: MaartenDeBoer.nl, 201215
# Subject	: Script to make an index-page with several TABles
#(0.2),201216	: Added readline Planning-file
#(0.3),201216	: Mod. MON-YEAR
#(0.4),201223	: Renamed from upd_dev-vijos-nl.sh
#(0.5),210125	: YLOOP for Sat
#(0.6),210216	: Mod. "4 of 6" & "In optie" = blue (BGC_NAME}
#(0.7),210301	: Added ID=
PGM=`basename $0|cut -d\. -f1`
VER="0.7"
TMP="/tmp/${PGM}.$$"
LOG="${HOME}/log/${PGM}.log"

#PAGEDIR="//var/www/vhosts/dev.vijos.nl/html"
PAGEDIR="//var/www/vhosts/oud-papier.vijos.nl/html"
PAGE="${PAGEDIR}/index.html"
UP_DATE=`date +%Y-%m-%d-%H-%M-%S`
PLANNINGFILE="/home/mailspin/reminders/planning/ViJoS_oud_papier_ophalen"
YEAR_MON_FILTER="2021-[01][02-9]"

echo "`date` ${PGM} v${VER} started."|tee -a ${LOG}
if [ ! -f ${PAGE} ]; then
  echo "  Indexfile (${PAGE}) NOT found. Exiting ..."|tee -a ${LOG}
  exit 3
fi

# Creating HEAD
echo "<!DOCTYPE HTML> " > ${PAGE}
echo "<HTML>" >> ${PAGE}
echo "  <HEAD> " >> ${PAGE}
echo "    <META NAME='generator' content='Agrarix.IT:${PGM} v${VER}' /> " >> ${PAGE}
echo "    <META NAME='up-date' content='${UP_DATE}' /> " >> ${PAGE}
echo "  </HEAD> " >> ${PAGE}

echo "  <BODY aLink=red link=red vLink=red>>" >> ${PAGE}

echo "  <TABLE class='table0-class' border=0 width='100%' id='table0' cellpadding='0' cellspacing='0'> " >> ${PAGE}
echo "    <TR>" >> ${PAGE}
echo "      <TD WIDTH=5%>" >> ${PAGE}
echo "      </TD>" >> ${PAGE}
echo "      <TD>" >> ${PAGE}

# Using PLANNINGFILE to build pages
cat ${PLANNINGFILE}|grep -v ^#|cut -d\; -f1|awk -F\- '{print $3"-"$2}'|sort -u|grep "${YEAR_MON_FILTER}"|while read YEAR_MON
do
  MON_NR=`echo ${YEAR_MON}|cut -d\- -f2`
  YEAR=`echo ${YEAR_MON}|cut -d\- -f1`

  YEAR_MON_NR_ID="${YEAR}-${MON_NR}"

echo "  <HR>" >> ${PAGE}
echo "  <TABLE class='table1-class' border=0 width='100%' id='table1' cellpadding='0' cellspacing='0'> " >> ${PAGE}
echo "    <TR ID=${YEAR_MON_NR_ID} >" >> ${PAGE}
echo "      <TD WIDTH=10%>" >> ${PAGE}
echo "        <IMG SRC='Vijos-2018-Logo_small.jpg' height=90%>" >> ${PAGE}
echo "      </TD>" >> ${PAGE}
echo "      <TD>" >> ${PAGE}
echo "        <CENTER> <FONT face='Verdana' size='6'>Oud papier ophaalschema <BR> voor de maand </FONT> </CENTER> </TD>" >> ${PAGE}
echo "      </TD>" >> ${PAGE}
echo "      <TD WIDTH=10%>" >> ${PAGE}
echo "        <IMG SRC='Vijos-2018-Logo_small.jpg' height=90%>" >> ${PAGE}
echo "      </TD>" >> ${PAGE}
echo "    </TR>" >> ${PAGE}


echo "    <TR>" >> ${PAGE}
echo "      <TD colspan=3>" >> ${PAGE}
#echo "        <CENTER> <FONT face='Verdana' size='10'>januari 2020 </FONT> </CENTER> </TD>" >> ${PAGE}
echo "  MON_NR=${MON_NR}"
MON_NAME="."
case ${MON_NR}
in
  01) MON_NAME="januari" ;;
  02) MON_NAME="februari" ;;
  03) MON_NAME="maart" ;;
  04) MON_NAME="april" ;;
  05) MON_NAME="mei" ;;
  06) MON_NAME="juni" ;;
  07) MON_NAME="juli" ;;
  08) MON_NAME="augustus" ;;
  09) MON_NAME="september" ;;
  10) MON_NAME="oktober" ;;
  11) MON_NAME="november" ;;
  12) MON_NAME="december" ;;
esac

echo "        <CENTER> <FONT face='Verdana' size='10'> ${MON_NAME} ${YEAR} </FONT> </CENTER> </TD>" >> ${PAGE}
echo "      </TD>" >> ${PAGE}
echo "    </TR>" >> ${PAGE}
echo "  </TABLE>" >> ${PAGE}

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

echo "  <TABLE class='table2-class' border=1 width='100%' id='table2' cellpadding='0' cellspacing='0'> " >> ${PAGE}
echo "    <TR>" >> ${PAGE}
echo "      <TD BGCOLOR=lightgrey WIDTH=33%>" >> ${PAGE}
echo "        <FONT face='Verdana' size='4'>" >> ${PAGE}
echo "1e wo-avond v.d. maand (4 nodig) <BR> In de Hilversumse Meent. <BR> Starten om 19:00 in de Meent bij de bushalte op de Noordermeent tov de Pluimenmeent" >> ${PAGE}
echo "        </FONT>" >> ${PAGE}
echo "      </TD>" >> ${PAGE}
echo "      <TD BGCOLOR=lightgrey>" >> ${PAGE}
echo "        <FONT face='Verdana' size='4'>" >> ${PAGE}
echo "2e za-ochtend v.d. maand (4 of 6 nodig) <BR> In Bussum Zuid <BR> Starten om 09:00 vanaf de Ceintuurbaan 45 " >> ${PAGE}
echo "        </FONT>" >> ${PAGE}
echo "      </TD>" >> ${PAGE}
echo "      <TD BGCOLOR=lightgrey WIDTH=33%>" >> ${PAGE}
echo "        <FONT face='Verdana' size='4'>" >> ${PAGE}
echo "3e wo-avond v.d. maand (2 nodig) <BR> In Bussum Zuid <BR> Starten om 19:00 vanaf de Ceintuurbaan 45 " >> ${PAGE}
echo "        </FONT>" >> ${PAGE}
echo "      </TD>" >> ${PAGE}
echo "    </TR>" >> ${PAGE}
# Datums
echo "    <TR>" >> ${PAGE}
echo "      <TD BGCOLOR=#F0F0F0 WIDTH=33%>" >> ${PAGE}
echo "        <FONT face='Verdana' size='5'>" >> ${PAGE}
DAY_FROM_FILE=`grep "\-${MON_NR}-${YEAR}" ${PLANNINGFILE} |grep -v ^#|cut -d\; -f1|sort -u|head -1|tail -1`
echo "1:${DAY_FROM_FILE}" 
echo "${DAY_FROM_FILE}" >> ${PAGE}
echo "        </FONT>" >> ${PAGE}
echo "      </TD>" >> ${PAGE}
echo "      <TD BGCOLOR=#F0F0F0 WIDTH=33%>" >> ${PAGE}
echo "        <FONT face='Verdana' size='5'>" >> ${PAGE}
DAY_FROM_FILE=`grep "\-${MON_NR}-${YEAR}" ${PLANNINGFILE} |grep -v ^#|cut -d\; -f1|sort -u|head -2|tail -1`
echo "2:${DAY_FROM_FILE}" 
echo "${DAY_FROM_FILE}" >> ${PAGE}
echo "        </FONT>" >> ${PAGE}
echo "      </TD>" >> ${PAGE}
echo "      <TD BGCOLOR=#F0F0F0 WIDTH=33%>" >> ${PAGE}
echo "        <FONT face='Verdana' size='5'>" >> ${PAGE}
DAY_FROM_FILE=`grep "\-${MON_NR}-${YEAR}" ${PLANNINGFILE} |grep -v ^#|cut -d\; -f1|sort -u|head -3|tail -1`
echo "3:${DAY_FROM_FILE}" 
echo "${DAY_FROM_FILE}" >> ${PAGE}
echo "        </FONT>" >> ${PAGE}
echo "      </TD>" >> ${PAGE}
echo "    </TR>" >> ${PAGE}

# Namen
YLOOP="1 2 3 4 5 6"
XLOOP="1 2 3"  # 3 days (Wed, Sat, Wed)
for Y in ${YLOOP} 
do
  echo "    <TR>" >> ${PAGE}
  for X in ${XLOOP} 
  do

      echo -n "${X}.${Y} "
      DAY_FROM_FILE=""
      NAME=""
      BGC_NAME=""
      if [ ${X} -eq 1 ]; then
        DAY_FROM_FILE=`grep "\-${MON_NR}-${YEAR}" ${PLANNINGFILE} |grep -v ^#|cut -d\; -f1|sort -u|head -1|tail -1`
      fi
      if [ ${X} -eq 2 ]; then
        DAY_FROM_FILE=`grep "\-${MON_NR}-${YEAR}" ${PLANNINGFILE} |grep -v ^#|cut -d\; -f1|sort -u|head -2|tail -1`
      fi
      if [ ${X} -eq 3 ]; then
        DAY_FROM_FILE=`grep "\-${MON_NR}-${YEAR}" ${PLANNINGFILE} |grep -v ^#|cut -d\; -f1|sort -u|head -3|tail -1`
      fi
      if [ "${DAY_FROM_FILE}" != "" ] && [ ${Y} -eq 1 ]; then
        NAME=`grep "${DAY_FROM_FILE}" ${PLANNINGFILE} |grep -v ^#|cut -d\; -f2|cut -d\< -f1|head -1|tail -1`
        if [ "${NAME}" = "" ]; then
          NAME="???"
        fi
      fi
      if [ "${DAY_FROM_FILE}" != "" ] && [ ${Y} -eq 2 ]; then
        NAME=`grep "${DAY_FROM_FILE}" ${PLANNINGFILE} |grep -v ^#|cut -d\; -f2|cut -d\< -f1|head -2|tail -1`
        if [ "${NAME}" = "" ]; then
          NAME="???"
        fi
      fi
      if [ "${DAY_FROM_FILE}" != "" ] && [ ${Y} -eq 3 ]; then
        NAME=`grep "${DAY_FROM_FILE}" ${PLANNINGFILE} |grep -v ^#|cut -d\; -f2|cut -d\< -f1|head -3|tail -1`
        if [ "${NAME}" = "" ]; then
          NAME="???"
        fi
      fi
      if [ "${DAY_FROM_FILE}" != "" ] && [ ${Y} -eq 4 ]; then
        NAME=`grep "${DAY_FROM_FILE}" ${PLANNINGFILE} |grep -v ^#|cut -d\; -f2|cut -d\< -f1|head -4|tail -1`
        if [ "${NAME}" = "" ]; then
          NAME="???"
        fi  # NAME
      fi  # DAY_FROM_FILE
      if [ "${DAY_FROM_FILE}" != "" ] && [ ${Y} -eq 5 ]; then
        NAME=`grep "${DAY_FROM_FILE}" ${PLANNINGFILE} |grep -v ^#|cut -d\; -f2|cut -d\< -f1|head -5|tail -1`
        if [ "${NAME}" = "" ]; then
          NAME="???"
        fi  # NAME
      fi  # DAY_FROM_FILE
      if [ "${DAY_FROM_FILE}" != "" ] && [ ${Y} -eq 6 ]; then
        NAME=`grep "${DAY_FROM_FILE}" ${PLANNINGFILE} |grep -v ^#|cut -d\; -f2|cut -d\< -f1|head -6|tail -1`
        if [ "${NAME}" = "" ]; then
          NAME="???"
        fi  # NAME
      fi  # DAY_FROM_FILE
# Empty "non used" days
    if [ "${X}.${Y}" = "1.5" ]; then
      NAME=""
      BGC=""
    fi
    if [ "${X}.${Y}" = "1.6" ]; then
      NAME=""
      BGC=""
    fi
    if [ "${X}.${Y}" = "3.3" ]; then
      NAME=""
      BGC=""
    fi
    if [ "${X}.${Y}" = "3.4" ]; then
      NAME=""
      BGC=""
    fi
    if [ "${X}.${Y}" = "3.5" ]; then
      NAME=""
      BGC=""
    fi
    if [ "${X}.${Y}" = "3.6" ]; then
      NAME=""
      BGC=""
    fi
    if [ "${NAME}" = "???" ]; then
      BGC_NAME="yellow"
    fi
    if [ "${NAME}" = "In optie" ]; then
      BGC_NAME="lightblue"
    fi
    echo "|DAY_FROM_FILE=${DAY_FROM_FILE}|NAME=${NAME}|"
      
    echo "      <TD WIDTH=33% BGCOLOR=${BGC_NAME}>" >> ${PAGE}
    echo "        <FONT face='Verdana' size='6'> ${NAME} </FONT>" >> ${PAGE}

    echo "      </TD>" >> ${PAGE}

  done  # X
  echo "    </TR>" >> ${PAGE}
done  # Y


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

echo "  <BR>" >> ${PAGE}
echo "  <BR>" >> ${PAGE}
echo "  <BR>" >> ${PAGE}
echo "  <div style='break-after:page'></div> " >> ${PAGE}

done  # MON_NR


echo "      </TD>" >> ${PAGE}
echo "      <TD WIDTH=5%>" >> ${PAGE}
echo "      </TD>" >> ${PAGE}
echo "    </TR>" >> ${PAGE}
echo "  </TABLE>" >> ${PAGE}


echo "  <div style='break-after:page'></div> " >> ${PAGE}
echo "  <HR> " >> ${PAGE}
echo "  <CENTER> <H6> Last update : `date` by ${PGM} v${VER} at `hostname` <A HREF='http://agrarix.it'>Design by Agrarix-IT</A> </H6> </CENTER> " >> ${PAGE}
echo "  </BODY>" >> ${PAGE}
echo "</HTML>" >> ${PAGE}




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

