#!/usr/bin/sh
###############################################################################
#									      #
# Description: 								      #
# This Shell Script sums the 2 columns as grouped by the the columns          #
# specified 								      #  
#             								      #
###############################################################################
FILENAME=$1
DELIMITER=$2
FIRST_COL=$3
SECOND_COL=$4
SALESDATE_COL=$5
STOREID=$6
UPC=$7
GTIN=$8
PROMOID=$9
echo ""
echo ".:Summation Tool:."

for FILE in ${FILENAME}
do
	gzip -t ${FILE} 2>/dev/null

	if [ $? -eq 1 ]; 
	then
		comm=cat
	else
		comm=gzcat
	fi

	if [ $# -eq 5 ]; then
		$comm $FILE | awk -v col=$FIRST_COL -v col2=$SECOND_COL -v col3=$SALESDATE_COL -v sourcefile=$FILE -F "$DELIMITER" '
			{
				if(NR!=1)
				{
					if($col3!="" && $col!="" && $col2!="")
					{
						salesdate[$col3] = $col3
						v[$col3] += $col
						d[$col3] += $col2
					}
				}
			}
			END{
				printf("\n%s%s%s%s%s%s\n","sales_date","|","sum(POS_QTY)","|","sum(POS_AMT)|","<source_file>") 
				for (i in v)
				{
					if(salesdate[i]!=1)
					{
						printf("%s%s%d%s%10.4f%s%s\n",salesdate[i],"|",v[i],"|",d[i],"|",sourcefile)
					}
				}
			}'

	elif [ $# -eq 6 ]; then
		$comm $FILE | awk -v col=$FIRST_COL -v col2=$SECOND_COL -v col3=$SALESDATE_COL -v col4=$STOREID -v sourcefile=$FILE -F "$DELIMITER" '
			{
				if(NR!=1)
				{
					if($col3!="" && $col!="" && $col2!="")
					{
						salesdate[$col3$col4] = $col3 "|" $col4
						v[$col3$col4] += $col
						d[$col3$col4] += $col2
					}
				}
			}
			END{
				printf("\n%s%s%s%s%s%s\n","sales_date|cust_id","|","sum(POS_QTY)","|","sum(POS_AMT)|","<source_file>") 
				for (i in v)
				{
					if(salesdate[i]!=1)
					{
						printf("%s%s%d%s%10.4f%s%s\n",salesdate[i],"|",v[i],"|",d[i],"|",sourcefile)
					}
				}
			}'

                         .
                         .   (same pattern for [ $# -eq 7 ] up to [ $# -eq 9 ]
                         .

	elif [ $# -gt 10 ]; then
		echo "Too many parameters passed. Please pass only the file name, delimiter, the number columns for POS_QTY and POS_AMT, and number of fields to GROUP BY."
	elif [ $# -lt 5 ]; then
		echo "Not enough parameters passed. Please pass the file name, delimiter, the number columns for POS_QTY and POS_AMT, and number of fields to GROUP BY."
	else
		echo "No parameters passed. Please pass the file name, delimiter, the number columns for POS_QTY and POS_AMT, and number of fields to GROUP BY."
	fi
done

sh <script file name> <file or files> <delimiter> <column # to sum1> <column # to sum2> <column #s for grouping>

$ sh  getsums.sh ft-gnct-3398-cd-2012-07-07-140112.txt.gz "     " 22 23 1 2 4

sales_date|cust_id|UPC|sum(POS_QTY)|sum(POS_AMT)|<source_file>
2012-07-05|PL_000000000034014|PL_2003007476012|75|   75.9200|ft-gnct-3398-cd-2012-07-07-140112.txt.gz
2012-07-03|PL_000000000034012|PL_2003000322606|19|   19.5000|ft-gnct-3398-cd-2012-07-07-140112.txt.gz
2012-07-01|PL_000000000034010|PL_2003005081201|38|   38.9800|ft-gnct-3398-cd-2012-07-07-140112.txt.gz