# !/bin/sh

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

	infile="topdat/${billperiod}/data/wbttop.csv"
	echo "infile=[$infile]"

	#,,,,CHRIS HEDLEY,CHRIS.HEDLEY@ASSETCO.NET.AU,Personal Reports for CHRIS HEDLEY,P14722,WEB,PERSONAL,31-01-2011,,31-01-2011

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

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

	rm -f "$tmpfile1"
	awk -F',' '
	BEGIN {
	}
	{

		f1 = $1
		f2 = $2
		f3 = $3
		f4 = $4
		f5 = $5
		f6 = $6
		f7 = $7
		f8 = $8
		f9 = $9
		f10 = $10
		f11 = $11
		f12 = $12
		f13 = $13
		EmailAddress = f6
		lowerEmailAddress = tolower(EmailAddress)
		f6 = lowerEmailAddress
		printf("%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s\n",f1,f2,f3,f4,f5,f6,f7,f8,f9,f10,f11,f12,f13)
	}
	END {
	}' < "$infile" >"$tmpfile1"
	#cp "$tmpfile1" 1
	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