def main(inn,out):
transform.inn2out(inn,out) #as bots needs an outgoing file, the file with header is just passed; goes to channel DISCARD; is not used
for hdr in inn.getloop({'BOTSID':'HDR'}):
INVNUM = hdr.get({'BOTSID':'HDR','INVNUM':None})
save_hdr_value('BCHDATE', INVNUM,hdr.get({'BOTSID':'HDR','BCHDATE':None}))
save_hdr_value('INVDATE', INVNUM,hdr.get({'BOTSID':'HDR','INVDATE':None}))
save_hdr_value('ORDNUM', INVNUM,hdr.get({'BOTSID':'HDR','ORDNUM':None}))
save_hdr_value('TOTEXCGST',INVNUM,hdr.get({'BOTSID':'HDR','TOTEXCGST':None}))
save_hdr_value('TOTGSTAMT',INVNUM,hdr.get({'BOTSID':'HDR','TOTGSTAMT':None}))
save_hdr_value('TOTINCGST',INVNUM,hdr.get({'BOTSID':'HDR','TOTINCGST':None}))
def main(inn,out):
transform.inn2out(inn,out) #997 is 'copied' as output, gets formatted as xmlnocheck)
reference = inn.get({'BOTSID':'ST'},{'BOTSID':'AK1','AK102':None})
#~ print reference,inn.ta_info['frompartner'],inn.ta_info['topartner']
botslib.changeq('''UPDATE ta
SET confirmed=%(confirmed)s, confirmidta=%(confirmidta)s
WHERE reference=%(reference)s
AND status=%(status)s
AND confirmasked=%(confirmasked)s
AND confirmtype=%(confirmtype)s
AND frompartner=%(frompartner)s
AND topartner=%(topartner)s
''',
{'status':MERGED,'reference':reference,'confirmed':True,'confirmtype':'ask-x12-997','confirmidta':inn.ta_info['idta_fromfile'],
'confirmasked':True,'frompartner':inn.ta_info['topartner'],'topartner':inn.ta_info['frompartner']})
def main(inn, out):
transform.inn2out(
inn, out) #997 is 'copied' as output, gets formatted as xmlnocheck)
reference = inn.get({'BOTSID': 'ST'}, {'BOTSID': 'AK1', 'AK102': None})
#~ print reference,inn.ta_info['frompartner'],inn.ta_info['topartner']
botslib.changeq(
'''UPDATE ta
SET confirmed=%(confirmed)s, confirmidta=%(confirmidta)s
WHERE reference=%(reference)s
AND status=%(status)s
AND confirmasked=%(confirmasked)s
AND confirmtype=%(confirmtype)s
AND frompartner=%(frompartner)s
AND topartner=%(topartner)s
''', {
'status': MERGED,
'reference': reference,
'confirmed': True,
'confirmtype': 'ask-x12-997',
'confirmidta': inn.ta_info['idta_fromfile'],
'confirmasked': True,
'frompartner': inn.ta_info['topartner'],
'topartner': inn.ta_info['frompartner']
})
def main(inn, out):
transform.inn2out(inn, out)
out.delete({'BOTSID': 'ST'}, {'BOTSID': 'REF', 'REF01': '87'})
def main(inn, out):
transform.inn2out(inn, out)
def main(inn,out):
transform.inn2out(inn,out)
tag2validxmltag(out.root) #edifact tags are numerical; xml does not allow numerical tags. This function fixed this
def main(inn, out):
transform.inn2out(inn, out) #receive ISA; send out as xml_nocheck