#!/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"
MAILTO="agrarix@xs4all.nl"
DATADIR="${BASEDIR}/data/"
CUSTOMER="bakkerij-vanbreemen"
CSV="${DATADIR}/${CUSTOMER}.csv"
PERIOD="2018-1[012]"
touch ${TMP}
# Init invoice
echo "" >> ${TMP}
HEADER=`grep ^# ${CSV}|grep 'HEADER='|cut -d\= -f2`
echo " ${HEADER}
" >> ${TMP}
echo " Factuur
" >> ${TMP}
NAME=`grep ^# ${CSV}|grep 'NAME='|cut -d\= -f2`
ADDR1=`grep ^# ${CSV}|grep 'ADDRESS1='|cut -d\= -f2`
ADDR2=`grep ^# ${CSV}|grep 'ADDRESS2='|cut -d\= -f2`
echo " ${NAME}
" >> ${TMP}
echo " ${ADDR1}
" >> ${TMP}
echo " ${ADDR2}
" >> ${TMP}
DATE=`grep ^# ${CSV}|grep 'DATE='|cut -d\= -f2`
if [ "${DATE}" = "" ]; then
DATE=`date +%d-%m-%Y`
fi
echo " " >> ${TMP}
echo " Factuurdatum: ${DATE}
" >> ${TMP}
echo "
" >> ${TMP}
NUMBER=`grep ^# ${CSV}|grep 'NUMBER='|cut -d\= -f2`
echo " " >> ${TMP}
echo " Factuurperiode: ${PERIOD}
" >> ${TMP}
echo "
" >> ${TMP}
# 2nd part; the invoice lines
echo " " >> ${TMP}
echo "
" >> ${TMP}
echo " " >> ${TMP}
echo " | Product | Omschrijving | Periode | Bedrag | " |tee -a ${TMP}
echo "
" >> ${TMP}
TOTAL=0
cat ${CSV}|grep -v ^#| while read LINE
do
echo "LINE=${LINE}"
# #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}'|grep "${PERIOD}"`
BEDRAG=`echo ${LINE}|grep -v ^#|awk -F\; '{print $4}'`
if [ "${PERIODE}" != "" ]; then
echo " " >> ${TMP}
echo " | ${PROD} | ${OMSCHR} | ${PERIODE} | ${BEDRAG} euro | " |tee -a ${TMP}
TOTAL=`expr ${TOTAL} + ${BEDRAG}`
echo ${TOTAL} > ${TMP}.ttl
echo "
" >> ${TMP}
fi
done # cat LINE
echo " " >> ${TMP}
TOTAL=`cat ${TMP}.ttl`
rm ${TMP}.ttl
echo " | Totaal | | | ${TOTAL} euro | " |tee -a ${TMP}
echo "
" >> ${TMP}
echo "
" >> ${TMP}
if [ "${FOOTER}" = "" ]; then
FOOTER=`grep ^# ${CSV}|grep 'FOOTER='|cut -d\= -f2`
echo " ${FOOTER}
" >> ${TMP}
fi
echo "" >> ${TMP}
if [ -s ${TMP} ]; then
cat ${TMP}| mailx --append="Content-type: text/html" -s "(auto) invoice" ${MAILTO}
echo " Mailed to ${MAILTO}" |tee -a ${LOG}
fi
rm ${TMP}
exit 0