: !/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.log 2>&1 rm -f "$tmp1file" exit 0