#! /bin/sh


umask 002

INFILE="brrs_mobiles_20160225.csv"

UNALLOCMOBFILE="unalloc_mob.csv"

tag="mob3"

logfile="${tag}.log"

exec 2>&1 >"$logfile"

#echo "put back original mobconf data"
#echo "delete from mobconf;" | runisql 2>&1
#load -d catcom -t mobconf -f mobconf_20160227.unl
#tail -4 "$MESSLOG"
#echo ""

#----------------------------------------------------
# get current Telmax21 Directory/Hierarchy/Mobiles

gett21info()
{
	unload -d catcom -t gengroup -f gengroup.unl
	unload -d catcom -t groupname -f groupname.unl
	unload -d catcom -t gnextra -f gnextra.unl
	unload -d catcom -t directtemplate -f directtemplate.unl
	unload -d catcom -t directcustom -f directcustom.unl

	rm -f mobconf.unl
	txsql -F'|' -o mobconf.unl -q "select * from mobconf"
}


#----------------------------------------------------
# load new T21 directory/hierarchu
#
#loadnewdata()
#{
#	echo "$0: loadnewdata..."
#}


#----------------------------------------------------
# Main

today=`date "+%d/%m/%Y"`
echo "today=$today"


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

. /u/catcom/scripts/stdsqlheader
gett21info

sed -e 's/\\//g' < "$INFILE" | \
awk -F',' \
   -v"brss=1" \
   -v"today=$today" \
   -v"unallocmobfile=$UNALLOCMOBFILE" \
   -f ${tag}.awk 2>&1


#exit 0

#loadfileerr="0"
#if [ "$loadfileerr" -eq 0 ]; then
#	echo "INFO: ${tag}; installing new data - " `date`
#	#mv $INFILE arc/${INFILE}.$$
#	#cp rej.unl arc/rej.unl.$$
#	echo "WOULD: loadnewdata"
#	#loadnewdata
##else
#	echo ""
#	echo ""
#	echo ""
#	echo ""
#	echo "       DATA NOT LOADED"
#fi

	#echo "load new mobile..."
	#load -d catcom -t mobconf -f "mob3_new.unl"
	#tail -4 "$MESSLOG"
	#echo ""

echo ""
echo "Finished: " `date`

#exit 0

addcr "$logfile" > "${logfile}.txt"

rm -f mob3.zip
zip mob3.zip "$INFILE" "${logfile}.txt" mob3_new.unl

# send email
subject="Telmax21 mob3 Import"
emailaddr="support@transmit.com.au"
#emailaddr="s.santoso@alfred.org.au support@transmit.com.au"
#emailaddr="S.McGrath@alfred.org.au U.Avci@alfred.org.au support@transmit.com.au"
#
# Force mail to pass DATE as GMT
TZ=''; export TZ
(
	echo "Please find mob3 import Log"
	echo ""
	#uuencode "$logfile" "$logfile"
	uuencode "mob3.zip" "mob3.zip"
) | mail -s "$subject" $emailaddr


exit 0