#-----------------------------------
# Start of user-changeable variables
#
# For this template, update the following variables:
#  CLIENTID
#  NAME
#  DBUSER/DBPASS/DBHOST
#  DATE
#  INPUTFILE
#-----------------------------------
#
# Define the client ID and name
CLIENTID=__CLIENTID__
NAME=__NAME__
#
# Define the database connection info
#
DBUSER=-u__DBUSER__
DBPASS=-p__DBPASS__
DBHOST=__DBHOST__
DBNAME=C_${NAME}
DBLOGIN=${DBUSER} ${DBPASS} -h${DBHOST} ${DBNAME}
TABLES=expense expense_name expense_type

RPSMISC=/app/tools/rps/bin/misc
STYLEHOME=/app/tools/support/lib/Support/DataImport/StyleTemplates

DATE=expense___TIMESTAMP__
#
# The name of the expense template
#
INPUTFILE="__INPUTFILE__"

#---------------------------------
#
# End of user-changeable variables
# 
#---------------------------------
LOWER_NAME=$(shell echo ${NAME} | tr A-Z a-z)
DUMPFILE=bk_before_${LOWER_NAME}.sql

TDTOXL=${RPSMISC}/tdtoxl_v2
STYLE=${STYLEHOME}/artist_expense_template.fmt
#
PROG=${RPSMISC}/run_import.pl
IMPORT_ARGS=__IMPORTID__
POSTIMPORT=${RPSMISC}/post_import.pl
POST_ARGS=__POSTARGS__

EXEC=-e
LOG_RO=debug_ro.txt
LOG=debug.txt
BASENAME=report_${LOWER_NAME}_expense
REPORT=${BASENAME}_import_${DATE}.txt
EXCEPTIONS=${BASENAME}_exceptions_${DATE}.txt
EXCEPTIONS_EXCEL=${BASENAME}_exceptions_${DATE}.xls
EXPENSE_REPORT=${BASENAME}_${DATE}.txt

default:
	@echo make "backup|restore||test|import"

backup:
	@mysqldump ${DBLOGIN} ${TABLES} > ${DUMPFILE}
	grep -i "create table" ${DUMPFILE}

restore:
	mysql ${DBLOGIN} < ${DUMPFILE}

test:
	nice perl ${PROG} -c ${CLIENTID} -f ${INPUTFILE} ${IMPORT_ARGS} > ${LOG_RO}
#	grep "^EXCEPTION" ${LOG_RO} | sed "s/^EXCEPTION:\t//" > ${REPORT}
	grep "^STATUS" ${LOG_RO} | sed "s/^STATUS:\t//" > ${REPORT}

import:
	nice perl ${PROG} -c ${CLIENTID} -f ${INPUTFILE} ${IMPORT_ARGS} ${EXEC} > ${LOG}
# Generate the import status and exception reports
	grep "^STATUS" ${LOG} | sed "s/^STATUS:\t//" > ${REPORT}
#
	grep "^STATUS" ${LOG} | head -1 | sed "s/^STATUS:\t//" > ${EXCEPTIONS}
	grep "^STATUS" ${LOG} | grep -e "__FAIL__" | grep -v "Expense Type" | sed "s/^STATUS:\t//" >> ${EXCEPTIONS}
	cat ${EXCEPTIONS} | ${TDTOXL} -o ${EXCEPTIONS_EXCEL} -s ${STYLE}
	#zip ${EXCEPTIONS_EXCEL}.zip ${EXCEPTIONS_EXCEL}
	nice perl ${POSTIMPORT} -c ${CLIENTID} -f ${EXCEPTIONS_EXCEL} -l ${LOG} ${POST_ARGS}
	find . -type f -not -name ${EXCEPTIONS_EXCEL} -exec gzip {} \;