: /bin/sh

INFILE="TIMS_Upload.csv"

exec 2>&1 >aeie2.log

if [ ! -f "$INFILE" ]; then
	echo "No $INFILE to process - " `date`
	exit 0
fi

#----------------------------------------------------

saveoldandloadnewdata()
{
	#unload -d catcom -t directcustom -f arc/old/dc.unl.$$
	#unload -d catcom -t directtemplate -f arc/old/dt.unl.$$
	#unload -d catcom -t gengroup -f arc/old/gg.unl.$$
	#unload -d catcom -t groupname -f arc/old/gn.unl.$$
	#unload -d catcom -t gnextra -f arc/old/gne.unl.$$
#
	runisql 2>&1 <<SQLCMD0
	delete from directcustom;
	delete from directtemplate;
	delete from gengroup;
	delete from groupname;
	delete from gnextra;
SQLCMD0

	cp dc.unl arc/dc.unl.$$
	cp dt.unl arc/dt.unl.$$
	cp gg.unl arc/gg.unl.$$
	cp gn.unl arc/gn.unl.$$
	cp gne.unl arc/gne.unl.$$

	load -d catcom -t directcustom -f dc.unl
	load -d catcom -t directtemplate -f dt.unl
	load -d catcom -t gengroup -f gg.unl
	load -d catcom -t groupname -f gn.unl
	load -d catcom -t gnextra -f gne.unl
	tail -12 $MESSLOG
}

#----------------------------------------------------
unload -d catcom -t site -f site.unl
unload -d catcom -t extranges -f extranges.unl
#----------------------------------------------------

today=`date "+%d/%m/%Y"`
echo "today=$today"
#awk -F'|' -v"today=$today" -f aeie2.awk < "$INFILE" 2>&1
#strip CR (^M) and SUB (^Z) from input data
tr -d "\032\015" <$INFILE | awk -F'|' -v"today=$today" -f aeie2.awk 2>&1

#----------------------------------------------------

#201|E2BOD001|E|2|TOP.BOD.BOD|B00000000|1|T||
awk -F'|' '
{
	print $2 | "sort | uniq -d >gn.d"
	print $2 | "sort -u >gn.u"
}
' < gn.unl

#E2BOD001|BOARD OF DIRECTORS|
awk -F'|' '
{
	print $1 | "sort | uniq -d >gne.d"
	print $1 | "sort -u >gne.u"
}
' < gne.unl

awk -F'|' '
{
	print $1 | "sort | uniq -d >gg.d"
	print $1 | "sort -u >gg.u"
}
' < gg.unl

if [ -s gn.d ]; then
	echo "ERROR: aeie2; duplicate grids created (see gn.d) - " `date`
	exit 1
fi

if [ -s gne.d ]; then
	echo "ERROR: aeie2; duplicate grids created (see gne.d) - " `date`
	exit 1
fi

if [ -s gg.d ]; then
	echo "ERROR: aeie2; duplicate child grids created (see gg.d) - " `date`
	exit 1
fi

if [ -s gne.d ]; then
	echo "ERROR: aeie2; dupgrids created (see gne.d) - " `date`
	exit 1
fi

if [ -s ugrid1.unl -a -s gn.unl -a -s gg.unl -a -s gne.unl -a -s dt.unl -a -s dc.unl ]; then
	echo "INFO: aeie2; installing new data - " `date`
	mv $INFILE arc/${INFILE}.$$
	cp ugrid1.unl arc/ugrid.unl.$$
	cp rej.unl arc/rej.unl.$$
	mv ugrid1.unl ugrid.unl
	saveoldandloadnewdata
else
	echo ""
	echo ""
	echo ""
	echo ""
	echo ""
	echo ""
	echo ""
	echo ""
	echo ""
	echo ""
	echo ""
	echo "ERROR: aeie2; 1 or more 0 size load files created - " `date`
	echo "       DATA NOT LOADED"
fi

# send email
tail -36 aeie2.log | mail -s "Integral Directory/Hierarchy Import" support@transmit.com.au Aust_CSC_-_NMS_VOICE@csc.com

exit 0