: !/bin/sh

platinvfile="$3"

##Testing
#platinvfile="platinv_test.unl"

tmp1file="/tmp/getinvdetail6_1.$$"

rm -f gid6.u
rm -f gid6.u1
rm -f "$tmp1file"

. tbsserver_vars

# get ReportgroupID and InvoiceNo
awk -F'|' '{ print $3 "|" $15 "|" | "sort -u" }' <"$platinvfile" > gid6.u

awk -F '|' '
BEGIN {
	print "getinvdetail6:"

	reportgroupid_to_sp_arr[1] = "spRptFaultReportData"	# Fault Reports
	reportgroupid_to_sp_arr[2] = "spRptNotSet"		# Jobs
	reportgroupid_to_sp_arr[3] = "spRptLabour"		# Labour
	reportgroupid_to_sp_arr[4] = "spRptNotSet"		# Landlines
	reportgroupid_to_sp_arr[5] = "spRptPurchasing"	# Purchasing
	reportgroupid_to_sp_arr[6] = "spRptNotSet"	# ???serviceid + First five var fields"	# Radio Faults
	reportgroupid_to_sp_arr[7] = "spRptSecurityData"		# Security
	reportgroupid_to_sp_arr[8] = "spRptNotSet"		# Base Site Rental/Electricity
	reportgroupid_to_sp_arr[9] = "spRptNotSet"			# Licences
	reportgroupid_to_sp_arr[10]= "spRptTASRentCallsOther"	#"???spRptTASRentCallsOther; spRptTASRentCallsSumm; spRptTASRentCalls" # Network Services
	reportgroupid_to_sp_arr[11]= "spRptTASCableTotal"	#"spRptTASCable"		# Network Access
	reportgroupid_to_sp_arr[12]= "spRptNotSet"		# Taxi Complaints
	reportgroupid_to_sp_arr[13]= "spRptNotSet"		# Annual Charges
	reportgroupid_to_sp_arr[14]= "spRptSmartbusFixed"	# Smartbus Fixed
	reportgroupid_to_sp_arr[15]= "spRptSmartbusGPRSMobile"	# Smartbus GPRS mobile
	reportgroupid_to_sp_arr[16]= "spRptKamcoFixed"	# Kamco Fixed
	reportgroupid_to_sp_arr[17]= "spRptNotSet"		# Kamco GPRS mobile
	reportgroupid_to_sp_arr[18]= "spRptYarraGPRSMobile"	# Yarra CAMS
	reportgroupid_to_sp_arr[19]= "spRptAggregateSmartbusGPRSMobile" # Smartbus Aggregate

	for ( reportgroupid in reportgroupid_to_sp_arr ) {
		sp = reportgroupid_to_sp_arr[reportgroupid]
		print "++++++++++ reportgroupid=" reportgroupid " sp=" sp "++++++++++"
		if ( sp != "spRptNotSet" ) {
			sql = "sp_helptext " sqquote(sp) "\n"
			tbssql(sql, "bcp")
		}
		print "++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++"
	}
}

function sqquote(s)
{
	return "\"" s "\""
}

function tbssql(sql, fmt,
   cmd)
{
	print "sql=[" sql "]"
	# run stored proc report
	cmd = cmd "echo \"" sql "\n\\go -m " fmt "\" | tbssql"
	#print "cmd=[" cmd "]"
	system(cmd)
}

{
	invoiceno = $1
	reportgroupid = $2
	sp = reportgroupid_to_sp_arr[reportgroupid]
	print "++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++"
	print "invoiceno=[" invoiceno "]" "  reportgroupid=[" reportgroupid "]" "  sp=[" sp "]"

	if ( sp != "spRptNotSet" ) {
		sql = sp " " sqquote(invoiceno) "\n"
		tbssql(sql, "pretty")
	}

	print reportgroupid | "sort -u >gid6.u1"

	#exit 0
}
' <gid6.u  >gid6.log 2>&1

rm -f "$tmp1file"
exit 0