#! /bin/sh
# IPND reconcilliation

# file name format
#IPNDRU.<XXXXX>.<MMMMMMM>.<NNNNNNN>.<PPP>
#IPNDRU.VICTR.0000001.0000255.001
#
#IPNDRU is a constant
#<XXXXX> is the File Source
#<MMMMMMM> is the run number identifying the output file.
#          It indicates that the file was part of the
#          MMMMMMMth run of an extract for this filesource.
#<NNNNNNN> is a file sequence number with leading 0
#<PPP>     Span number. All Output On Request download files are limited
#          to 100,000 rows of data. The first 100,000 rows are written to
#          span 001. Requests that generate > 100,000 rows are written to
#          additional spanned files. If the number of output files exceeds 999,
#          the spanned number will increment to 1000 onwards.

emailonly=""
if [ -n "$1" ]; then
	emailonly="$1"
	echo "emailonly=[$emailonly]"
fi


if [ -n "$emailonly" ]; then
	logfile="ipnd1_recon_emailonly.log"
else
	logfile="ipnd1_recon.log"
fi
rm -f "$logfile"

#IPND_emailaddresslist="rod@transmit.com.au praveen.peiris@victrack.com.au jennifer.stevens@victrack.com.au robyn.douglas@victrack.com.au sam.musso@victrack.com.au Bharath.Bhooshan@VICTRACK.com.au"
IPND_emailaddresslist="rod@transmit.com.au praveen.peiris@victrack.com.au jennifer.stevens@victrack.com.au"
#IPND_emailaddresslist="rod@transmit.com.au "

File_Source_Code="VICTR"
CSP_Code="447"
Data_Provider_Code="VICTRA"

#ipnd_user="t_victr"
ipnd_user="p_victr"

#ipnd_system="ipndfts-t"
ipnd_system="ipndfts-p"

FSNfile="ipnd1.fseq"

#ipnd_folder="/u/catcom/database/ipnd"
ipnd_folder=`pwd`

if [ -n "$1" ]; then
	DODBG="$1"
fi
DODBG="1"

if [ -f "$FSNfile" ]; then
	File_Sequence_Number=`cat "$FSNfile" | awk -v "noinc=$noinc" '{
		last_File_Sequence_Number = $1
		if ( noinc == "1" )
			File_Sequence_Number = last_File_Sequence_Number
		else
			File_Sequence_Number = last_File_Sequence_Number + 1
		printf("%0.7d", File_Sequence_Number)
	}'`
else
	File_Sequence_Number="0000001"
fi

# Testing
#IPNDRU.VICTR.0000001.0000255.001
#File_Sequence_Number="0000255"
File_Sequence_Number="0000305"
echo "Testing..." >>"$logfile"

echo "File_Sequence_Number=[$File_Sequence_Number]" >>"$logfile"

Run_Number="0000002"

reconfilename="IPNDRU.${File_Source_Code}.{Run_Number}.${File_Sequence_Number}"

# Testing
#reconfilename="IPNDRU.VICTR.0000001.0000255.001"
reconfilename="IPNDRU.VICTR.0000002.0000305.001"

# # download encrypted IPND reconciliation report file
# srcf="${ipnd_user}@${ipnd_system}:./download/${reconfilename}.asc"
# #destf="$ipnd_folder/${reconfilename}.asc"
# destf="catcom@s-vm-telmax01:$ipnd_folder/${reconfilename}.asc"
# ipnd1_scp "$srcf" "$destf"
# 
# # decrypte recon file
# 
# # decrypt err file
# chmod 644 ${reconfilename}.asc
# echo "ipnd1_recon: gpgdec ${reconfilename}" >>"$logfile"
# gpgdec "${reconfilename}"
# 
# # copy .asc encrypted recon file and decrypted version to intermediate box
# ipnd1_send "${reconfilename}.asc"
# ipnd1_send "${reconfilename}"
# 
# # move recon file and .asc incrypted version to save
# mv "${reconfilename}.asc" I_P_N_D.save
# mv "${reconfilename}" I_P_N_D.save

# Testing only
Testing="$2"
if [ "$2" = "Testing" ]; then
	Testing="$3"
	if [ -z "$Testing" ]; then
		Testing="3"
	fi
fi

# get yesterdays date
yesterday_YYYYMMDD=`date -d "1 day ago" '+%Y%m%d'`

today_YYYYMMDD=`date '+%Y%m%d'`

if [ -z "$emailonly" ]; then
    awk -v "RECON=1" \
	-v "DODBG=$DODBG" \
	-v "Testing=$Testing" \
	-v "yesterday_YYYYMMDD=$yesterday_YYYYMMDD" \
	-v "today_YYYYMMDD=$today_YYYYMMDD" \
	-v "File_Source_Code=$File_Source_Code" \
	-v "CSP_Code=$CSP_Code" \
	-v "Data_Provider_Code=$Data_Provider_Code" \
	-v "File_Sequence_Number=$File_Sequence_Number" \
	-v "outfile=$File_Sequence_Number" \
	-v "reconfilename=I_P_N_D.save/${reconfilename}" \
	-f ipnd1_recon.awk >>"$logfile"
fi

#cat "$logfile"

# file to send in email
recon_err_csv_filename="ipnd1_recon_err.csv"
recon_uploadfilename="ipnd1_recon_upload.${File_Sequence_Number}"
recon_VT_transactionsfilename="recon_VT_transactions"

# zipped  in ipnd1_recon.awk
ipnd1_recon_zipfile="ipnd_recon_${today_YYYYMMDD}.zip"

# email result
emaillist="rod@transmit.com.au"
#emaillist="telmax21@mon2"
#emaillist="rshepp44@gmail.com"
if [ -n "$emailonly" -a "$emailonly" != "1" ]; then
	emaillist="$emailonly"
fi
attfiles="$ipnd1_recon_zipfile"

t21em_content="
Please find the attached zip $ipnd1_recon_zipfile
containing these files...

  $recon_err_csv_filename
    - Reconcillation discrepancies

  $recon_uploadfilename
    - IPND upload file to correct reconcillation discrepancies

  $recon_VT_transactionsfilename
    - Current Victrack Telmax21 Directory and TBS Services used to compare

  $reconfilename
    - IPND reconcillation extract data file download from IPND server

"
export t21em_content

ematt "$attfiles" "IPND Reconcillation $today_YYYYMMDD" "$emaillist"

exit 0