
#!/bin/sh
# File	: upd_oud-papier-planning.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=
#(0.8),210510	: Add start from CUR month
#(0.9),210517	: Add RCFILE, BASEDIR (changed from upd_oud-papier-vijos-nl.sh)
PGM=`basename $0|cut -d\. -f1`
VER="0.9b"
TMP="/tmp/${PGM}.$$"
BASEDIR="${HOME}/reminders"
LOG="${BASEDIR}/log/${PGM}.log"
RCFILE="${BASEDIR}/etc/${PGM}.rc"

PAGEDIR="/var/www/vhosts/oud-papier.vijos.nl/html"
PAGE="${PAGEDIR}/index.html"
UP_DATE=`date +%Y-%m-%d-%H-%M-%S`
PLANNINGFILE="${HOME}/reminders/planning/ViJoS_oud_papier_ophalen"
YEAR_MON_FILTER="20"
#YEAR_MON_FILTER="2021-[01][05-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
if [ -f ${RCFILE} ]; then
  echo "  RCFILE (${RCFILE}) found. Using this."|tee -a ${LOG}
  . ${RCFILE}
fi
echo "PLANNINGFILE=${PLANNINGFILE}"
echo "YEAR_MON_FILTER=${YEAR_MON_FILTER}"
echo "PAGEDIR=${PAGEDIR}"
echo "PAGE=${PAGE}"

# 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 "    <TITLE>Oud papier schema</TITLE> " >> ${PAGE}
echo "    <link rel='icon' href='https://www.vijos.nl/wp-content/uploads/2017/10/cropped-Favicon-Drum-en-Showband-ViJoS-Bussum-180x180.png' type='image/jpg'> " >> ${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
# 1st count # of lines. Needed for the `grep -A` to define the start (this month)
CUR_MON=`date +%m`
CUR_YR=`date +%Y`
NRL=`cat ${PLANNINGFILE}| wc -l`
cat ${PLANNINGFILE}|grep -v ^#|grep "${CUR_MON}-${CUR_YR}" -A ${NRL}|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 (nog steeds) om <U><B>18:00</B></U> 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 (nog steeds) om <U><B>18:00</B></U> 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> `date` Reminders by <A HREF='http://www.agrarix.it'>Agrarix-IT</A> </H6> </CENTER> " >> ${PAGE}
echo "  </BODY>" >> ${PAGE}
echo "</HTML>" >> ${PAGE}




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

