#!/bin/sh
# File	: wp-statistieken_proc.sh
# By	: MaartenDeBoer.nl, 241015
# Subject	: Script to process WP-statistieken mail
PGM=`basename $0|cut -d\. -f1`
VER="0.1"
LOG="${HOME}/log/${PGM}.log"
CSV="/tmp/${PGM}.csv"
MAILTO="maarten@agrarix.it"

DATADIR="/mnt/nas/DATA/WordPress"

echo "`date` ${PGM} v${VER} started."|tee -a ${LOG}
echo "  CSV=${CSV}"
echo "  DATADIR=${DATADIR}"
echo "  MAILTO=${MAILTO}"
sleep 1

if [ ! -d ${DATADIR} ]; then
  echo "  DATADIR(${DATADIR}) NOT found. Exiting"|tee -a ${LOG}
  exit 3
fi  # DATADIR

echo "# DATE;ONLINE_USERS;TODAYS_VISITORS;TODAYS_VISITS;YESTERDAY_VISITORS;YESTERDAY_VISITS;TOTAL_VISITORS;TOTAL_VISITS;" > ${CSV}

cd ${DATADIR}
ls -1 Statis*|while read FNAME
do
# Statistieken-rapportage-13-5-2024_2024-10-15-16-46-06
# Statistieken-rapportage_2024-10-15-16-46-06
  echo "  FNAME=${FNAME}"
  PART1=`echo ${FNAME}|cut -d\_ -f1`
  PART2=`echo ${FNAME}|cut -d\_ -f2`
#  echo "    PART1=${PART1} PART2=${PART2}"
  MSG_DATE=`echo ${PART1}|grep "\`date +%Y\`"|cut -d\- -f3-`
  echo "      MSG_DATE=${MSG_DATE}"

#        <li>Online Users: <strong>0</strong></li>
#        <li>Today's Visitors: <strong>35</strong></li>
#        <li>Today's Visits: <strong>316</strong></li>
#        <li>Yesterday's Visitors: <strong>42</strong></li>
#        <li>Yesterday's Visits: <strong>209</strong></li>
#        <li>Total Visitors: <strong>9,989</strong></li>
#        <li>Total Visits: <strong>50,179</strong></li>

  ONLINE_USERS=`grep "<li>" ${FNAME}|grep "Online Users:"|cut -d\> -f3|cut -d\< -f1|sed 's|,||g'`
  TODAYS_VISITORS=`grep "<li>" ${FNAME}|grep "Today's Visitors:"|cut -d\> -f3|cut -d\< -f1|sed 's|,||g'`
  TODAYS_VISITS=`grep "<li>" ${FNAME}|grep "Today's Visits:"|cut -d\> -f3|cut -d\< -f1|sed 's|,||g'`
  YESTERDAY_VISITORS=`grep "<li>" ${FNAME}|grep "Yesterday's Visitors:"|cut -d\> -f3|cut -d\< -f1|sed 's|,||g'`
  YESTERDAY_VISITS=`grep "<li>" ${FNAME}|grep "Yesterday's Visits:"|cut -d\> -f3|cut -d\< -f1|sed 's|,||g'`
  TOTAL_VISITORS=`grep "<li>" ${FNAME}|grep "Total Visitors:"|cut -d\> -f3|cut -d\< -f1|sed 's|,||g'`
  TOTAL_VISITS=`grep "<li>" ${FNAME}|grep "Total Visits:"|cut -d\> -f3|cut -d\< -f1|sed 's|,||g'`

  echo "  ONLINE_USERS=${ONLINE_USERS} TODAYS_VISITORS=${TODAYS_VISITORS} TODAYS_VISITS=${TODAYS_VISITS} YESTERDAY_VISITORS=${YESTERDAY_VISITORS} YESTERDAY_VISITS=${YESTERDAY_VISITS} TOTAL_VISITORS=${TOTAL_VISITORS} TOTAL_VISITS=${TOTAL_VISITS}"

  echo "${MSG_DATE};${ONLINE_USERS};${TODAYS_VISITORS};${TODAYS_VISITS};${YESTERDAY_VISITORS};${YESTERDAY_VISITS};${TOTAL_VISITORS};${TOTAL_VISITS};" >> ${CSV}

done  # FNAME

if [ "${MAILTO}" != "" ]; then
  date|mailx -A ${CSV} -s "WP Statistieken rapportage [${PGM} v${VER}]" ${MAILTO}
  EC=${?}
  echo "  Mailed(${EC}) to ${MAILTO}"|tee -a ${LOG}
fi  # MAILTO


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