#!/bin/sh
# File	: proc_autoinvoice.sh
# By	: MaartenDeBoper.nl, 190110
# Subject	: Script to process (automatic) invoicing
PGM=`basename $0|cut -d\. -f1`
VER="0.1"
TMP="/tmp/${PGM}.$$"
BASEDIR="${HOME}/autoinvoice"
YRMON="`date +%Y-%m`"
LOG="${BASEDIR}/log/${PGM}-${YRMON}.log"

MAILTO="maarten@agrarix.nl"

DATADIR="${BASEDIR}/data/"
CUSTOMER="bakkerij-vanbreemen"
CSV="${DATADIR}/${CUSTOMER}.csv"

touch ${TMP}

NAME=""
ADDR1=""
ADDR2=""
SUBJECT=""
cat ${CSV}| while read LINE
do
#  echo ${LINE}
  if [ "${NAME}" = "" ]; then
    NAME=`echo ${LINE}|grep ^#|grep 'NAME='|cut -d\= -f2`
  fi
  if [ "${ADDR1}" = "" ]; then
    ADDR1=`echo ${LINE}|grep ^#|grep 'ADDRESS1='|cut -d\= -f2`
  fi
  if [ "${ADDR2}" = "" ]; then
    ADDR2=`echo ${LINE}|grep ^#|grep 'ADDRESS2='|cut -d\= -f2`
  fi
  if [ "${SUBJECT}" = "" ]; then
    SUBJECT=`echo ${LINE}|grep ^#|grep 'SUBJECT='|cut -d\= -f2`
  fi

  echo "${NAME}, ${ADDR1}, ${ADDR2}, ${SUBJECT} ..."

# #Product;Omschrijving;Periode;Bedrag;
  PROD=`echo ${LINE}|grep -v ^#|awk -F\; '{print $1}'`
  OMSCHR=`echo ${LINE}|grep -v ^#|awk -F\; '{print $2}'`
  PERIODE=`echo ${LINE}|grep -v ^#|awk -F\; '{print $3}'`
  BEDRAG=`echo ${LINE}|grep -v ^#|awk -F\; '{print $4}'`
  echo "${PROD}-${OMSCHR}-${PERIODE}-${BEDRAG}. "
  


done  # cat LINE


#cat ${TMP}| mailx --append="Content-type: text/html" -s "HTML mail" ${MAILTO}
#echo "  Mailed to ${MAILTO}" |tee -a ${LOG}


rm ${TMP}
exit 0