: !/bin/sh
# populate mobile config table from the Directory
SDATE="$1"
EDATE="$2"

SDATE="01/01/2010"

today=`date "+%d/%m/%Y"`

# from  directtemplate and directcustom
#    dt.recordno
#    dt.extgroupunique
#    dc.recordno
#    dc.date_updated
#    dc.empid
#    dc.mobile


#mobconf
#recordno,mobile,customid,sdate,edate,directoryid,groupid,
#datatype,purchased,supplier,manufacturer,model,carriercode,servicetype,
#introaming,gprs,simnumber,imeinumber,puk,
#dataplan,contractstart,contractfinish,archivecomment,
#updated,msg1,msg2,msg3,msg4,msg5,msg6,msg7,msg8,msg9


#runisql <<SQLCMD0
#delete from mobconf;
#insert into mobconf
#select 0, dc.mobile, "mobile_phones", "$SDATE", "", dc.recordno, "",
#1, "", "", "", "", "t", 10,
#"", "", "", "", "",
#"", "", "", "",
#"$today", "", "", "", "", "", "", "", "", ""
#from directcustom dc
#where dc.mobile is not null and dc.mobile != " ";
#SQLCMD0

#-------------------------------
# get from tbs 
tmpfile1="/tmp/popmob1.$$"
tmpfile2="/tmp/popmob2.$$"
cp /dev/null "$tmpfile1"
cp /dev/null "$tmpfile2"

# get tbs person service list data
gettbspersonservicelist "$tmpfile1"


awk -F '|' -v"SDATE=$SDATE" -v "today=$today" '
function sanetrim(s)
{
	sub(/^[ \t]*/,"",s)
	sub(/[ \t]*$/,"",s)
	gsub(/\047/,"`",s)
	gsub(/\"/,"",s)
	return s
}

{
	f = 0
	PersonID = sanetrim($++f)
	Person = sanetrim($++f)
	ServiceIDID = sanetrim($++f)
	ServiceID = sanetrim($++f)
	ShipTo = sanetrim($++f)
	FullName = sanetrim($++f)
	LocationID = sanetrim($++f)
	LocationDesc = sanetrim($++f)
	DepartmentID = sanetrim($++f)
	DepartmentDesc = sanetrim($++f)
	SupplierID = sanetrim($++f)
	SupplierName = sanetrim($++f)

	split(SupplierName, SupplierName_arr, " ")
	supplier = toupper(SupplierName_arr[1])
	carrier = tolower(substr(supplier,1,1))

	# skip if not a mobile
	if ( match(ServiceID,/^04..-......$/) <= 0 ) 
		next

	mobile = substr(ServiceID,1,4) substr(ServiceID,6,6)
	dirID = PersonID

	# mobconf table format
	printf("0|%s|mobile_phones|%s||%d||0||%s|||%s|10||||||||||%s||||||||||\n", mobile, SDATE, dirID, supplier, carrier, today)

	## getSIDMAINTconf format
	#printf("%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|\n",
	#	 recordno, sid, sidmainttype, sdate, edate,
	#	 directoryid, grid, datatype, serviceproviderdir, carriercode,
	#	 grname1, grname3, surname, firstname,
	#	 manufacturer, model, servicetype, genfld4)

}
' < "$tmpfile1" >"$tmpfile2"

runisql <<SQLCMD1
delete from mobconf;
load from "$tmpfile2" insert into mobconf;
SQLCMD1

rm -f "$tmpfile1"
rm -f "$tmpfile2"

exit 0