# !/bin/sh

doit()
{
	SDATE="$1"
	EDATE="$2"
	echo "dodoit $billperiod"
	MMYYYY=`SDATEtoMMYYYY $SDATE`
	echo "MMYYYY = [$MMYYYY]"
	billperiod=`MMYYYYtobillperiod $MMYYYY _`
	SITEID="ALL"

	infile="indata/${billperiod}/tPerson.unl"
	echo "infile=[$infile]"

 	#4668|ROBYN DOUGLAS|robyn.douglas@victrack.com.au|

	tmpfile1="/tmp/tmpfxtP1$$"
	echo "tmpfile1=[$tmpfile1]"

	if [ -f "${infile}.s1" ]; then
		rm -f "$infile"
		mv "${infile}.s1" "$infile"
	fi

	rm -f "$tmpfile1"
	awk -F'|' '
	BEGIN {
	}
	{
		PersonID = $1
		Person = $2
		EmailAddress = $3
		lowerEmailAddress = tolower(EmailAddress)
		print  PersonID "|" Person "|" lowerEmailAddress "|"
	}
	END {
	}' < "$infile" >"$tmpfile1"
	mv "$infile" "${infile}.s1"
	cp "$tmpfile1" "$infile"
	rm -f "$tmpfile1"
}

#----------
##doit 01/04/2010 30/04/2010

#doit 01/01/2011 31/01/2011
#doit 01/02/2011 28/02/2011
#doit 01/03/2011 31/03/2011
#doit 01/04/2011 30/04/2011
#doit 01/05/2011 31/05/2011
#doit 01/06/2011 30/06/2011
#doit 01/07/2011 31/07/2011
#doit 01/08/2011 31/08/2011
#doit 01/09/2011 30/09/2011