: !/bin/sh

insightcdr="/u/catcom/wb/ex2_tst/indata/Oct_2009/OPTUSINSIGHTCDR/mobile_phones/10004_Oct09.csv"

datafeed="/u/catcom/wb/ex2_tst/indata/Oct_2009/OPTUS/mobile_phones/10004_20091027.bil"

rm -f onmob*.out

(
runisql 2>/dev/null <<SQLCMD0
select unique mobile from mobconf where edate = "" or edate is null
SQLCMD0
) | \
while read onmobile
do
	if [ -z "$onmobile" -o "$onmobile" = "mobile" ]; then
		continue
	fi
	#echo "onmobile=[$onmobile]"

	sed -e 's/"//g;s/,/|/g;s/
$//;s/"$//' "$insightcdr" | \
	awk -F'|' -v "onmobile=$onmobile" '
	function trim(s)
	{
		sub(/^[ \t]*/,"",s)
		sub(/[ \t]*$/,"",s)
		return s
	}
	{
		DialledNumber = trim($5)	# insight cdr
		#print "onmobile=[" onmobile "]" "  DialleNumber=[" DialledNumber "]"
		if ( index(DialledNumber,substr(onmobile,2,9)) > 0 )
			print $0 >>"onmob_insight.out"
	}
	'

	sed -e 's/"//g;s/,/|/g;s/
$//;s/"$//' "$datafeed" | \
	awk -F'|' -v "onmobile=$onmobile" '
	function trim(s)
	{
		sub(/^[ \t]*/,"",s)
		sub(/[ \t]*$/,"",s)
		return s
	}
	{
		DialledNumber = trim($9)	# datafeed
		#print "onmobile=[" onmobile "]" "  DialleNumber=[" DialledNumber "]"
		if ( index(DialledNumber,substr(onmobile,2,9)) > 0 )
			print $0 >>"onmob_datafeed.out"
	}
	'
done