: !/bin/sh

SDATE="$1"
EDATE="$2"

#mcsvoutdir="topdat"
mcsvoutfilepref="import"


#Testing
SDATE="01/04/2010"
EDATE="30/04/2010"
#SDATE="01/12/2010"
#EDATE="31/12/2010"
mcsvoutdir="import"


#if [ "$mcsvoutdir" != "." -a -d "${mcsvoutdir}" ]; then
#       rm -r "${mcsvoutdir}"
#       mkdir -p "${mcsvoutdir}"
#fi

echo "getallmcsv6:"
echo "    EXCLUDEINVBIT = $EXCLUDEINVBIT"
echo ""
echo "    EXCLUDEBATCHIDBIT = $EXCLUDEBATCHIDBIT"
echo ""

tmp1file="/tmp/gallmcsv6_$$"

rm -f "$tmp1file"

IOFFSETDAYS="9"

# convert EDATE to YYYYMMDD
EYYYYMMDD=`awk -v "ADATE=$EDATE" -v "sep=" '
BEGIN {
	dd = 0 + substr(ADATE,1,2);
	mm = 0 + substr(ADATE,4,2);
	yyyy = 0 + substr(ADATE,7,4);
	YYYYMMDD = sprintf("%04d%s%02d%s%02d", yyyy, sep, mm, sep, dd);
	print YYYYMMDD
	exit
}'`
echo "EYYYYMMDD=[$EYYYYMMDD]"

. tbsserver_vars

# get required bill Periods from TBS invoice tables
# based on InvoiceDate
(
sqsh -S $server -D $dbname -U $username -P $password <<SQLCMD0
SELECT DISTINCT Period
--, convert(varchar, tInvoice.InvoiceDate, 120) as Idate
--, PlatinumInvoiceNo
FROM tInvoice, tInvoiceDetail
where tInvoiceDetail.InvoiceID = tInvoice.ID
--#  and tInvoice.ID NOT IN (
--#	SELECT distinct tInvoice.CreditNoteInvID
--#		FROM tInvoice
--#		WHERE tInvoice.CreditNoteInvID is not null
--#  )
  and tInvoice.InvoiceDate > dateadd(dd,$IOFFSETDAYS,'$EYYYYMMDD')
  and tInvoice.InvoiceDate <= dateadd(mm,1,dateadd(dd,$IOFFSETDAYS,'$EYYYYMMDD'))
  $EXCLUDEINVBIT
  $EXCLUDEBATCHIDBIT
ORDER BY
 Period
\go -m bcp
SQLCMD0
) | sed 's/\|$//' > "$tmp1file"

# loop for each required bill Period
cat "$tmp1file" | \
while read aperiod
do
	echo "aperiod=[$aperiod]"

        ###################################
        # monthly customer import csv files
        getmcsv6 $EYYYYMMDD $IOFFSETDAYS "$aperiod" "$SHIPTO" "$BATCHID" "$INVOICENO" "$mcsvoutdir" "$mcsvoutfilepref"

done

rm -f "$tmp1file"
exit 0