def SubModuleDoFst():
#=====判断是否重复交易====
sel_dict = {'TRCNO':TradeContext.TRCNO,'TRCDAT':TradeContext.TRCDAT,'SNDBNKCO':TradeContext.SNDBNKCO}
record = rccpsDBTrcc_existp.selectu(sel_dict)
if record == None:
return AfaFlowControl.ExitThisFlow('S999','判断是否重复报文，查询汇兑业务登记簿相同报文异常')
elif len(record) > 0:
AfaLoggerFunc.tradeInfo('紧急止付业务登记簿中存在相同数据,重复报文,进入下一流程')
#=====为通讯回执报文赋值====
out_context_dict = {}
out_context_dict['sysType'] = 'rccpst'
out_context_dict['TRCCO'] = '9900503'
out_context_dict['MSGTYPCO'] = 'SET008'
out_context_dict['RCVMBRCO'] = TradeContext.SNDMBRCO
out_context_dict['SNDMBRCO'] = TradeContext.RCVMBRCO
out_context_dict['SNDBRHCO'] = TradeContext.BESBNO
out_context_dict['SNDCLKNO'] = TradeContext.BETELR
out_context_dict['SNDTRDAT'] = TradeContext.BJEDTE
out_context_dict['SNDTRTIM'] = TradeContext.BJETIM
out_context_dict['ORMFN'] = TradeContext.MSGFLGNO
out_context_dict['MSGFLGNO'] = out_context_dict['SNDMBRCO'] + TradeContext.BJEDTE + TradeContext.SerialNo
out_context_dict['NCCWKDAT'] = TradeContext.NCCworkDate
out_context_dict['OPRTYPNO'] = '99'
out_context_dict['ROPRTPNO'] = TradeContext.OPRTYPNO
out_context_dict['TRANTYP'] = '0'
out_context_dict['ORTRCCO'] = trc_dict['TRCCO']
out_context_dict['PRCCO'] = 'RCCI0000'
out_context_dict['STRINFO'] = '重复报文'
rccpsMap0000Dout_context2CTradeContext.map(out_context_dict)
#=====发送afe====
AfaAfeFunc.CommAfe()
return AfaFlowControl.ExitThisFlow('S999','重复报文，退出处理流程')
#=====根据发送行号,委托日期,交易流水号查询原交易信息===========
AfaLoggerFunc.tradeInfo(">>>开始根据发送行号,委托日期,交易流水号查询交易信息")
trc_dict = {}
if not rccpsDBFunc.getTransTrcPK(TradeContext.SNDMBRCO,TradeContext.ORTRCDAT,TradeContext.ORTRCNO,trc_dict):
return AfaFlowControl.ExitThisFlow('S999','汇兑业务登记簿中无此交易,抛弃报文')
AfaLoggerFunc.tradeInfo(">>>结束根据发送行号,委托日期,交易流水号查询交易信息")
#=====需要插入紧急止付业务登记簿existp====
existp = {}
if not rccpsMap1130CTradeContext2Dexistp.map(existp):
return AfaFlowControl.ExitThisFlow('S999','字典赋值出错,抛弃报文')
existp['BOJEDT'] = trc_dict['BJEDTE']
existp['BOSPSQ'] = trc_dict['BSPSQN']
existp['CUR'] = '01'
#=====张恒 20091203 新增 将机构落到原交易机构 ====
existp['BESBNO'] = trc_dict['BESBNO']
ret = rccpsDBTrcc_existp.insertCmt(existp)
if ret < 0:
return AfaFlowControl.ExitThisflow('S999','插入止付业务登记簿出错,抛弃报文')
#======检查原业务状态是否为自动挂账－成功====
#if not (trc_dict['BCSTAT'] != PL_BCSTAT_HANG and trc_dict['BDWFLG'] != PL_BDWFLG_SUCC ):
if (trc_dict['BCSTAT'] != PL_BCSTAT_HANG or trc_dict['TRCCO'][:2] != '20' or trc_dict['TRCCO'] == '2000009'):
out_context_dict = {}
out_context_dict['sysType'] = 'rccpst'
out_context_dict['TRCCO'] = '9900503'
out_context_dict['MSGTYPCO'] = 'SET008'
out_context_dict['RCVMBRCO'] = TradeContext.SNDMBRCO
out_context_dict['SNDMBRCO'] = TradeContext.RCVMBRCO
out_context_dict['SNDBRHCO'] = TradeContext.BESBNO
out_context_dict['SNDCLKNO'] = TradeContext.BETELR
out_context_dict['SNDTRDAT'] = TradeContext.BJEDTE
out_context_dict['SNDTRTIM'] = TradeContext.BJETIM
out_context_dict['ORMFN'] = TradeContext.MSGFLGNO
out_context_dict['MSGFLGNO'] = out_context_dict['SNDMBRCO'] + TradeContext.BJEDTE + TradeContext.SerialNo
out_context_dict['NCCWKDAT'] = TradeContext.NCCworkDate
out_context_dict['OPRTYPNO'] = '99'
out_context_dict['ROPRTPNO'] = TradeContext.OPRTYPNO
out_context_dict['TRANTYP'] = '0'
out_context_dict['ORTRCCO'] = trc_dict['TRCCO']
out_context_dict['PRCCO'] = 'RCCI0000'
out_context_dict['STRINFO'] = '该笔业务已入账，不允许退汇'
rccpsMap0000Dout_context2CTradeContext.map(out_context_dict)
TradeContext.SNDSTLBIN = TradeContext.RCVMBRCO #发起成员行号
#=====发送afe====
AfaAfeFunc.CommAfe()
return AfaFlowControl.ExitThisFlow('S999','重复报文，退出处理流程')
TradeContext.BOSPSQ = trc_dict['BSPSQN']
TradeContext.BOJEDT = trc_dict['BJEDTE']
TradeContext.ORPYRACC = trc_dict['PYRACC']
TradeContext.ORPYRNAM = trc_dict['PYRNAM']
TradeContext.ORPYEACC = trc_dict['PYEACC']
TradeContext.ORPYENAM = trc_dict['PYENAM']
TradeContext.ORTRCCO = trc_dict['TRCCO']
#=====汇兑业务登记簿trcbka赋值新增一条记录====
trc_dict['BOJEDT'] = trc_dict['BJEDTE']
trc_dict['BOSPSQ'] = trc_dict['BSPSQN']
trc_dict['ORTRCDAT']= trc_dict['TRCDAT']
trc_dict['ORTRCNO'] = trc_dict['TRCNO']
trc_dict['ORTRCCO'] = trc_dict['TRCCO']
trc_dict['TRCCO'] = '2000004'
trc_dict['OPRNO'] = '09'
trc_dict['DCFLG'] = PL_DCFLG_CRE
trc_dict['BJEDTE'] = TradeContext.BJEDTE
trc_dict['BSPSQN'] = TradeContext.BSPSQN
trc_dict['TRCDAT'] = TradeContext.TRCDAT
trc_dict['TRCNO'] = TradeContext.SerialNo
trc_dict['BRSFLG'] = PL_BRSFLG_SND #往账
trc_dict['BBSSRC'] = '3' #待销账
#=====接收成员行号与发送成员行号互换====
TradeContext.temp = trc_dict['SNDMBRCO']
trc_dict['SNDMBRCO']= trc_dict['RCVMBRCO']
trc_dict['RCVMBRCO']= TradeContext.temp
#=====接收行号与发送行号互换====
TradeContext.temp = trc_dict['SNDBNKCO']
trc_dict['SNDBNKCO']= trc_dict['RCVBNKCO']
trc_dict['RCVBNKCO']= TradeContext.temp
#=====接收行名与发送行名互换====
TradeContext.temp = trc_dict['SNDBNKNM']
trc_dict['SNDBNKNM']= trc_dict['RCVBNKNM']
trc_dict['RCVBNKNM']= TradeContext.temp
#=====开始插入数据库====
if not rccpsDBFunc.insTransTrc(trc_dict):
#=====RollBack操作====
AfaDBFunc.RollbackSql()
return AfaFlowControl.ExitThisFlow('D002', '插入数据库出错,RollBack成功')
else:
#=====commit操作====
AfaDBFunc.CommitSql()
AfaLoggerFunc.tradeInfo('插入汇兑业务登记簿，COMMIT成功')
#=====设置状态为记账-处理中====
sstlog = {}
sstlog['BSPSQN'] = TradeContext.BSPSQN
sstlog['BJEDTE'] = TradeContext.BJEDTE
sstlog['BCSTAT'] = PL_BCSTAT_ACC
sstlog['BDWFLG'] = PL_BDWFLG_WAIT
if not rccpsState.setTransState(sstlog):
#=====RollBack操作====
AfaDBFunc.RollbackSql()
return AfaFlowControl.ExitThisFlow(TradeContext.errorCode, TradeContext.errorMsg)
else:
#=====commit操作====
AfaDBFunc.CommitSql()
AfaLoggerFunc.tradeInfo('>>>commit成功')
#=====开始拼借贷方账号====
TradeContext.DASQ = trc_dict['DASQ']
TradeContext.RBAC = TradeContext.BESBNO + PL_ACC_NXYDQSWZ
TradeContext.OCCAMT= TradeContext.OROCCAMT
TradeContext.HostCode = '8813'
#=====开始调函数拼贷方账号第25位校验位====
TradeContext.RBAC = rccpsHostFunc.CrtAcc(TradeContext.RBAC, 25)
AfaLoggerFunc.tradeInfo( '贷方账号:' + TradeContext.RBAC )
rccpsHostFunc.CommHost(TradeContext.HostCode)
AfaLoggerFunc.tradeInfo( '>>>开始判断主机返回结果' )
status_dict = {}
status_dict['BSPSQN'] = TradeContext.BSPSQN #报单序号
status_dict['BJEDTE'] = TradeContext.BJEDTE #交易日期
status_dict['BCSTAT'] = PL_BCSTAT_ACC #记账
#=====判断主机返回结果====
if TradeContext.errorCode != '0000':
status_dict['BDWFLG'] = PL_BDWFLG_FAIL #失败
else:
status_dict['BDWFLG'] = PL_BDWFLG_SUCC #成功
status_dict['TRDT'] = TradeContext.TRDT #主机日期
status_dict['TLSQ'] = TradeContext.TLSQ #主机流水号
status_dict['MGID'] = TradeContext.MGID #主机返回信息
status_dict['DASQ'] = TradeContext.DASQ #销账序号
#=====修改退汇记录的状态====
if not rccpsState.setTransState(status_dict):
#=====RollBack操作====
AfaDBFunc.RollbackSql()
return AfaFlowControl.ExitThisFlow(TradeContext.errorCode, TradeContext.errorMsg)
else:
#=====commit操作====
AfaDBFunc.CommitSql()
AfaLoggerFunc.tradeInfo('>>>commit成功')
#=====判断主机返回结果,是否继续流程====
if TradeContext.errorCode != '0000':
out_context_dict = {}
out_context_dict['sysType'] = 'rccpst'
out_context_dict['TRCCO'] = '9900503'
out_context_dict['MSGTYPCO'] = 'SET008'
out_context_dict['RCVMBRCO'] = TradeContext.SNDMBRCO
out_context_dict['SNDMBRCO'] = TradeContext.RCVMBRCO
out_context_dict['SNDBRHCO'] = TradeContext.BESBNO
out_context_dict['SNDCLKNO'] = TradeContext.BETELR
out_context_dict['SNDTRDAT'] = TradeContext.TRCDAT
out_context_dict['SNDTRTIM'] = TradeContext.BJETIM
out_context_dict['ORMFN'] = TradeContext.MSGFLGNO
out_context_dict['MSGFLGNO'] = out_context_dict['SNDMBRCO'] + TradeContext.BJEDTE + TradeContext.SerialNo
out_context_dict['NCCWKDAT'] = TradeContext.NCCworkDate
out_context_dict['OPRTYPNO'] = '99'
out_context_dict['ROPRTPNO'] = TradeContext.OPRTYPNO
out_context_dict['TRANTYP'] = '0'
out_context_dict['ORTRCCO'] = TradeContext.ORTRCCO
out_context_dict['PRCCO'] = 'RCCI0000'
out_context_dict['STRINFO'] = '该笔业务已入账，不允许退汇'
rccpsMap0000Dout_context2CTradeContext.map(out_context_dict)
TradeContext.SNDSTLBIN = TradeContext.RCVMBRCO #发起成员行号
#=====发送afe====
AfaAfeFunc.CommAfe()
return AfaFlowControl.ExitThisFlow('S999','该笔业务已被主机处理，不允许退汇')
#=====新增记录的状态为：发送-处理中====
if not rccpsState.newTransState(TradeContext.BJEDTE,TradeContext.BSPSQN,PL_BCSTAT_SND,PL_BDWFLG_WAIT):
#=====RollBack操作====
AfaDBFunc.RollbackSql()
return AfaFlowControl.ExitThisFlow('M999', '设置状态失败,系统自动回滚')
else:
#=====commit操作====
AfaDBFunc.CommitSql()
out_context_dict = {}
out_context_dict['sysType'] = 'rccpst'
out_context_dict['TRCCO'] = '9900503'
out_context_dict['MSGTYPCO'] = 'SET008'
out_context_dict['RCVMBRCO'] = TradeContext.SNDMBRCO
out_context_dict['SNDMBRCO'] = TradeContext.RCVMBRCO
out_context_dict['SNDBRHCO'] = TradeContext.BESBNO
out_context_dict['SNDCLKNO'] = TradeContext.BETELR
out_context_dict['SNDTRDAT'] = TradeContext.TRCDAT
out_context_dict['SNDTRTIM'] = TradeContext.BJETIM
out_context_dict['ORMFN'] = TradeContext.MSGFLGNO
out_context_dict['MSGFLGNO'] = out_context_dict['SNDMBRCO'] + TradeContext.BJEDTE + TradeContext.SerialNo
out_context_dict['NCCWKDAT'] = TradeContext.NCCworkDate
out_context_dict['OPRTYPNO'] = '99'
out_context_dict['ROPRTPNO'] = TradeContext.OPRTYPNO
out_context_dict['TRANTYP'] = '0'
out_context_dict['ORTRCCO'] = TradeContext.ORTRCCO
out_context_dict['PRCCO'] = 'RCCI0000'
out_context_dict['STRINFO'] = '成功'
rccpsMap0000Dout_context2CTradeContext.map(out_context_dict)
TradeContext.SNDSTLBIN = TradeContext.RCVMBRCO #发起成员行号
return True
AfaLoggerFunc.tradeInfo("密押错,自动挂账")
NOTE3 = "密押错,自动挂账"
else:
#====校验密押异常,自动挂账=========================
AfaLoggerFunc.tradeInfo("校验密押异常,自动挂账")
NOTE3 = "校验密押异常,自动挂账"
TradeContext.HostCode = '8813' #调用8813主机接口
TradeContext.NOTE3 = NOTE3 #挂账原因
TradeContext.BCSTAT = PL_BCSTAT_HANG #自动挂账
TradeContext.BDWFLG = PL_BDWFLG_WAIT #处理中
#====拼借贷方账户====
TradeContext.SBAC = TradeContext.BESBNO + PL_ACC_NXYDQSLZ #借方账户
TradeContext.SBAC = rccpsHostFunc.CrtAcc(TradeContext.SBAC, 25)
TradeContext.RBAC = TradeContext.BESBNO + "".rjust(15,'0')
TradeContext.REAC = TradeContext.BESBNO + PL_ACC_NXYDXZ #挂账账户
TradeContext.REAC = rccpsHostFunc.CrtAcc(TradeContext.REAC, 25)
AfaLoggerFunc.tradeInfo( '借方账号:' + TradeContext.SBAC )
AfaLoggerFunc.tradeInfo( '贷方账号:' + TradeContext.RBAC )
AfaLoggerFunc.tradeInfo( '挂账账号:' + TradeContext.REAC )
else:
#======密押校验通过,自动入账===========================
AfaLoggerFunc.tradeInfo("密押校验通过,自动入账")
TradeContext.HostCode = '8813' #调用8813主机接口
def SubModuleDoFst():
AfaLoggerFunc.tradeInfo( '***农信银系统：往账.主机类操作(1.本地操作).个人现金通存[TRCC002_8561]进入***' )
#=================必要性检查===============================================
AfaLoggerFunc.tradeInfo(">>>开始必要性检查")
#检查本机构是否有通存通兑业务权限
if not rccpsDBFunc.chkTDBESAuth(TradeContext.BESBNO):
return AfaFlowControl.ExitThisFlow("S999","本机构无通存通兑业务权限")
#磁道信息
if TradeContext.PYETYP == '0':
if TradeContext.SCTRKINF == '':
return AfaFlowControl.ExitThisFlow("磁道信息不能为空")
#if TradeContext.THTRKINF == '':
# return AfaFlowControl.ExitThisFlow("磁道信息不能为空")
if len(TradeContext.SCTRKINF) > 37:
return AfaFlowControl.ExitThisFlow('S999','磁道信息非法')
#if len(TradeContext.THTRKINF) > 104:
# return AfaFlowControl.ExitThisFlow('S999','磁道信息非法')
elif TradeContext.PYETYP == '2':
TradeContext.SCTRKINF = ''.rjust(37,'0')
TradeContext.THTRKINF = ''.rjust(37,'0')
#存折号码
if TradeContext.PYETYP == '1':
if TradeContext.BNKBKNO == '':
return AfaFlowControl.ExitThisFlow('存折号码不能为空')
elif TradeContext.PYETYP == '3':
TradeContext.BNKBKNO = ''
AfaLoggerFunc.tradeInfo(">>>结束必要性检查")
#=================登记通存通兑业务登记簿===================================
AfaLoggerFunc.tradeInfo(">>>开始登记通存通兑业务登记簿")
TradeContext.SNDMBRCO = TradeContext.SNDSTLBIN #发送成员行号
TradeContext.RCVMBRCO = TradeContext.RCVSTLBIN #接收成员行号
TradeContext.TRCNO = TradeContext.SerialNo #交易流水号
TradeContext.NCCWKDAT = TradeContext.NCCworkDate #中心工作日期
TradeContext.MSGFLGNO = TradeContext.SNDMBRCO + TradeContext.TRCDAT + TradeContext.TRCNO #报文标识号
TradeContext.OPRNO = PL_TDOPRNO_TC #业务种类:个人现金通存
TradeContext.DCFLG = PL_DCFLG_CRE #借贷标识:贷记
TradeContext.BRSFLG = PL_BRSFLG_SND #往来标识:往账
#if TradeContext.PYITYP == '0' or '2':
# TradeContext.TRCCO = '3000002' #交易代码:3000002卡现金通存
#elif TradeContext.PYITYP == '1' or '3':
# TradeContext.TRCCO = '3000004' #交易代码:3000004折现金通存
#else:
# return AfaFlowContorl.ExitThisFlow("S999","收款人账户类型非法")
TradeContext.PYRMBRCO = TradeContext.SNDSTLBIN
TradeContext.PYEMBRCO = TradeContext.RCVSTLBIN
wtrbka_dict = {}
if not rccpsMap8563CTradeContext2Dwtrbka_dict.map(wtrbka_dict):
return AfaFlowContorl.ExitThisFlow("S999","为通存通兑业务登记簿赋值异常")
if not rccpsDBFunc.insTransWtr(wtrbka_dict):
return AfaFlowControl.ExitThisFlow('S999','登记通存通兑业务登记簿异常')
AfaLoggerFunc.tradeInfo(">>>结束登记通存通兑业务登记簿")
#=================设置业务状态为记账处理中=================================
AfaLoggerFunc.tradeInfo(">>>开始设置业务状态为记账处理中")
stat_dict = {}
stat_dict['BJEDTE'] = TradeContext.BJEDTE #交易日期
stat_dict['BSPSQN'] = TradeContext.BSPSQN #报单序号
stat_dict['BCSTAT'] = PL_BCSTAT_ACC #PL_BCSTAT_ACC 记账
stat_dict['BDWFLG'] = PL_BDWFLG_WAIT #PL_BDWFLG_WAIT 处理中
if not rccpsState.setTransState(stat_dict):
return AfaFlowControl.ExitThisFlow('S999','设置状态为记账处理中异常')
AfaLoggerFunc.tradeInfo(">>>结束设置业务状态为记账处理中")
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
return AfaFlowControl.ExitThisFlow("S999","Commit异常")
AfaLoggerFunc.tradeInfo(">>>结束设置业务状态为记账处理中")
#=================为主机记账做准备=========================================
AfaLoggerFunc.tradeInfo(">>>开始为主机记账做准备")
TradeContext.HostCode = '8813'
TradeContext.PKFG = 'T' #通存通兑标识
TradeContext.CATR = '0' #现转标识:0-现金
TradeContext.RCCSMCD = PL_RCCSMCD_XJTCWZ #主机摘要码:现金通存往账
TradeContext.SBAC = ''
TradeContext.ACNM = ''
TradeContext.RBAC = TradeContext.BESBNO + PL_ACC_NXYDQSWZ #贷方账号
TradeContext.RBAC = rccpsHostFunc.CrtAcc(TradeContext.RBAC,25)
TradeContext.OTNM = "农信银待清算往账"
TradeContext.CTFG = '7' #结转标识:结转-0
AfaLoggerFunc.tradeInfo("借方账号1:[" + TradeContext.SBAC + "]")
AfaLoggerFunc.tradeInfo("贷方账号1:[" + TradeContext.RBAC + "]")
if TradeContext.CHRGTYP == '0':
#现金收取手续费
TradeContext.ACUR = '2' #重复次数
TradeContext.I2PKFG = 'T' #通存通兑标识
TradeContext.I2CATR = '0' #现转标识:0-现金
TradeContext.I2TRAM = TradeContext.CUSCHRG #手续费金额
TradeContext.I2SMCD = PL_RCCSMCD_SXF #主机摘要码:手续费
TradeContext.I2SBAC = ''
TradeContext.I2ACNM = ''
TradeContext.I2RBAC = TradeContext.BESBNO + PL_ACC_TCTDSXF #贷方账号:通存通兑手续费
TradeContext.I2RBAC = rccpsHostFunc.CrtAcc(TradeContext.I2RBAC,25)
TradeContext.I2OTNM = "农信银手续费"
TradeContext.I2CTFG = '8' #结转标识:不结转-1
elif TradeContext.CHRGTYP == '1':
#现金通存无法收取本行账户手续费
return AfaFlowControl.ExitThisFlow("S999","现金通存无法转账收取手续费")
elif TradeContext.CHRGTYP == '2':
AfaLoggerFunc.tradeInfo(">>>不收手续费")
else:
return AfaFlowControl.ExitThisFlow("S999","非法手续费收取方式")
if TradeContext.existVariable("I2SBAC") and TradeContext.existVariable('I2RBAC'):
AfaLoggerFunc.tradeInfo("借方账号2:[" + TradeContext.I2SBAC + "]")
AfaLoggerFunc.tradeInfo("贷方账号2:[" + TradeContext.I2RBAC + "]")
AfaLoggerFunc.tradeInfo(">>>结束为主机记账做准备")
AfaLoggerFunc.tradeInfo( '***农信银系统：往账.主机类操作(1.本地操作).个人现金通存[TRCC002_8561]退出***' )
return True
def SubModuleDoTrd():
AfaLoggerFunc.tradeInfo( '***农信银系统：往账.主机类操作(3.中心记账).个人现金通存[TRCC002_8561]进入***' )
#=================设置业务状态为发送成功或失败,若发送失败则自动抹账========
stat_dict = {}
stat_dict['BJEDTE'] = TradeContext.BJEDTE
stat_dict['BSPSQN'] = TradeContext.BSPSQN
stat_dict['BESBNO'] = TradeContext.BESBNO
stat_dict['BETELR'] = TradeContext.BETELR
stat_dict['BCSTAT'] = PL_BCSTAT_SND
stat_dict['BDWFLG'] = PL_BDWFLG_SUCC
stat_dict['PRCCO'] = TradeContext.errorCode
stat_dict['STRINFO'] = TradeContext.errorMsg
AfaLoggerFunc.tradeInfo("TradeContext.errorCode = [" + TradeContext.errorCode + "]")
if TradeContext.errorCode == '0000':
AfaLoggerFunc.tradeInfo(">>>开始设置业务状态为发送成功")
stat_dict['BCSTAT'] = PL_BCSTAT_SND
stat_dict['BDWFLG'] = PL_BDWFLG_SUCC
if not rccpsState.setTransState(stat_dict):
return AfaFlowControl.ExitThisFlow('S999', "设置业务状态为发送成功异常")
AfaLoggerFunc.tradeInfo(">>>结束设置业务状态为发送成功")
else:
AfaLoggerFunc.tradeInfo(">>>开始设置业务状态为发送失败")
stat_dict['BCSTAT'] = PL_BCSTAT_SND
stat_dict['BDWFLG'] = PL_BDWFLG_FAIL
if not rccpsState.setTransState(stat_dict):
return AfaFlowControl.ExitThisFlow('S999', "设置业务状态为发送失败异常")
AfaLoggerFunc.tradeInfo(">>>结束设置业务状态为发送失败")
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
return AfaFlowControl.ExitThisFlow("S999","Commit异常")
#=============发起主机抹账=============================================
AfaLoggerFunc.tradeInfo(">>>开始设置业务状态为抹账处理中")
#=====特殊处理 关彬捷 20081127 调8813抹账,需产生新的前置流水号进行记账====
if rccpsGetFunc.GetRBSQ(PL_BRSFLG_SND) == -1 :
return AfaFlowControl.ExisThisFlow('S999',"产生新的前置流水号异常")
#为抹账会计分录赋值
TradeContext.HostCode='8813'
TradeContext.PKFG = 'T' #通存通兑标识
TradeContext.RVFG = '2' #红蓝字标志 2
TradeContext.CATR = '0' #现转标识:0-现金
TradeContext.RCCSMCD = PL_RCCSMCD_XJTCWZ #主机摘要码:现金通存往账
TradeContext.SBAC = ''
TradeContext.ACNM = ''
TradeContext.RBAC = TradeContext.BESBNO + PL_ACC_NXYDQSWZ #贷方账号
TradeContext.RBAC = rccpsHostFunc.CrtAcc(TradeContext.RBAC,25)
TradeContext.OTNM = "农信银待清算往账"
TradeContext.CTFG = '7' #结转标识:结转-0
AfaLoggerFunc.tradeInfo("借方账号1:[" + TradeContext.SBAC + "]")
AfaLoggerFunc.tradeInfo("贷方账号1:[" + TradeContext.RBAC + "]")
if TradeContext.CHRGTYP == '0':
#现金收取手续费
TradeContext.ACUR = '2' #重复次数
TradeContext.I2PKFG = 'T' #通存通兑标识
TradeContext.I2RVFG = '2' #红蓝字标志 2
TradeContext.I2CATR = '0' #现转标识:0-现金
TradeContext.I2TRAM = TradeContext.LOCCUSCHRG #手续费金额
TradeContext.I2SMCD = PL_RCCSMCD_SXF #主机摘要码:手续费
TradeContext.I2SBAC = ''
TradeContext.I2ACNM = ''
TradeContext.I2RBAC = TradeContext.BESBNO + PL_ACC_TCTDSXF #贷方账号:通存通兑手续费
TradeContext.I2RBAC = rccpsHostFunc.CrtAcc(TradeContext.I2RBAC,25)
TradeContext.I2OTNM = "农信银手续费"
TradeContext.I2CTFG = '8' #结转标识:不结转-1
#====设置业务状态为抹账处理中====
if not rccpsState.newTransState(TradeContext.BJEDTE,TradeContext.BSPSQN,PL_BCSTAT_HCAC,PL_BDWFLG_WAIT):
return AfaFlowControl.ExitThisFlow('S999','设置业务状态为抹账处理中异常')
AfaLoggerFunc.tradeInfo(">>>结束设置业务状态为抹账处理中")
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
return AfaFlowControl.ExitThisFlow("S999","Commit异常")
AfaLoggerFunc.tradeInfo(">>>开始发起主机抹账")
#=====调起抹账主机接口====
rccpsHostFunc.CommHost( TradeContext.HostCode )
AfaLoggerFunc.tradeInfo(">>>结束发起主机抹账")
stat_dict = {}
stat_dict['BJEDTE'] = TradeContext.BJEDTE
stat_dict['BSPSQN'] = TradeContext.BSPSQN
stat_dict['MGID'] = TradeContext.errorCode
stat_dict['STRINFO'] = TradeContext.errorMsg
AfaLoggerFunc.tradeInfo("TradeContext.errorCode = [" + TradeContext.errorCode + "]")
if TradeContext.errorCode == '0000':
AfaLoggerFunc.tradeInfo(">>>开始设置业务状态为抹账成功")
stat_dict['BCSTAT'] = PL_BCSTAT_HCAC
stat_dict['BDWFLG'] = PL_BDWFLG_SUCC
stat_dict['TRDT'] = TradeContext.TRDT
stat_dict['TLSQ'] = TradeContext.TLSQ
stat_dict['PRTCNT'] = 1 #打印次数
if not rccpsState.setTransState(stat_dict):
return AfaFlowControl.ExitThisFlow('S999','设置业务状态抹账成功异常')
AfaLoggerFunc.tradeInfo(">>>结束设置业务状态为抹账成功")
else:
AfaLoggerFunc.tradeInfo(">>>开始设置业务状态为抹账失败")
stat_dict['BCSTAT'] = PL_BCSTAT_HCAC
stat_dict['BDWFLG'] = PL_BDWFLG_FAIL
if not rccpsState.setTransState(stat_dict):
return AfaFlowControl.ExitThisFlow('S999','设置业务状态抹账成功异常')
AfaLoggerFunc.tradeInfo(">>>结束设置业务状态为抹账失败")
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
return AfaFlowControl.ExitThisFlow("S999","Commit异常")
TradeContext.errorCode = '0000'
AfaLoggerFunc.tradeInfo( '***农信银系统：往账.主机类操作(3.中心记账).个人现金通存[TRCC002_8561]退出***' )
return True
def SubModuleDoFst():
AfaLoggerFunc.tradeInfo( '***农信银系统：往账.主机类操作(1.本地操作).汇票解付[TRCC003_8502]进入***' )
#====begin 蔡永贵 20110215 增加====
#新票据号是16位，需要取后8位，版本号为02，同时要兼容老票据号8位，版本号为01
if TradeContext.BILVER == '02':
TradeContext.TMP_BILNO = TradeContext.BILNO[-8:]
else:
TradeContext.TMP_BILNO = TradeContext.BILNO
#============end============
#置代理付款行为本机构行号
TradeContext.PAYBNKCO = TradeContext.SNDBNKCO
TradeContext.PAYBNKNM = TradeContext.SNDBNKNM
if TradeContext.BILTYP == PL_BILTYP_CASH:
#=================现金汇票置持票人账号为2431账号科目========================
TradeContext.PYHACC = TradeContext.BESBNO + PL_ACC_NXYDXZ
TradeContext.PYHACC = rccpsHostFunc.CrtAcc(TradeContext.PYHACC,25)
AfaLoggerFunc.tradeInfo("TradeContext.PYHACC=" + TradeContext.PYHACC)
AfaLoggerFunc.tradeInfo("TradeContext.PYHNAM=" + TradeContext.PYHNAM)
#=================交易必要性检查============================================
AfaLoggerFunc.tradeInfo(">>>开始交易必要性检查")
if abs(float(TradeContext.BILAMT) - float(TradeContext.OCCAMT) - float(TradeContext.RMNAMT)) >= 0.001:
return AfaFlowControl.ExitThisFlow("S999","多余金额非出票金额与实际结算金额之差")
AfaLoggerFunc.tradeInfo(">>>结束交易必要性检查")
#=================检验是否重复交易==========================================
AfaLoggerFunc.tradeInfo(">>>开始校验重复交易")
bilbka_where_dict = {}
bilbka_where_dict['BILRS'] = PL_BILRS_OUT
bilbka_where_dict['BILVER'] = TradeContext.BILVER
bilbka_where_dict['BILNO'] = TradeContext.BILNO
bilbka_where_dict['HPSTAT'] = PL_HPSTAT_PAYC
bilbka_dict = rccpsDBTrcc_bilbka.selectu(bilbka_where_dict)
if bilbka_dict == None:
return AfaFlowControl.ExitThisFlow("S999","查询原汇票信息异常,校验重复交易失败")
if len(bilbka_dict) > 0:
return AfaFlowControl.ExitThisFlow("S999","此汇票已被解付,重复交易,禁止提交")
AfaLoggerFunc.tradeInfo(">>>结束校验重复交易")
if TradeContext.BILTYP != PL_BILTYP_CASH:
#=================校验入账账号户名======================================
AfaLoggerFunc.tradeInfo(">>>开始校验入账账号户名")
TradeContext.HostCode = '8810'
TradeContext.ACCNO = TradeContext.PYHACC
AfaLoggerFunc.tradeDebug("gbj test :" + TradeContext.ACCNO)
rccpsHostFunc.CommHost( TradeContext.HostCode )
if TradeContext.errorCode != '0000':
return AfaFlowControl.ExitThisFlow(TradeContext.errorCode,TradeContext.errorMsg)
AfaLoggerFunc.tradeDebug("gbj test :" + TradeContext.ACCNM)
if TradeContext.ACCNM != TradeContext.PYHNAM:
return AfaFlowControl.ExitThisFlow('S999',"账号户名不符")
if TradeContext.ACCST != '0' and TradeContext.ACCST != '2':
return AfaFlowControl.ExitThisFlow('S999','入账账号状态不正常')
AfaLoggerFunc.tradeInfo(">>>结束校验入账账号户名")
#=================校验汇票密押==============================================
AfaLoggerFunc.tradeInfo(">>>开始校验汇票密押")
if TradeContext.BILTYP == PL_BILTYP_CASH:
TYPE = PL_TYPE_XJHP
elif TradeContext.BILTYP == PL_BILTYP_TRAN:
TYPE = PL_TYPE_ZZHP
else:
return AfaFlowControl.ExitThisFlow("S999","汇票类型非法")
AfaLoggerFunc.tradeDebug('TradeContext密押:' + TradeContext.SEAL )
MIYA = TradeContext.SEAL
TRCDAT = TradeContext.BILDAT
TRCNO = TradeContext.BILNO
REMBNKCO = TradeContext.REMBNKCO #签发行
PAYBNKCO = TradeContext.PAYBNKCO #代理付款行
REMBNKCO = REMBNKCO.rjust(12,'0')
PAYBNKCO = PAYBNKCO.rjust(12,'0')
AMOUNT = str(TradeContext.BILAMT).split('.')[0] + str(TradeContext.BILAMT).split('.')[1]
AMOUNT = AMOUNT.rjust(15,'0')
INFO = ""
AfaLoggerFunc.tradeDebug('处理类型(0-编押 1-核押):' + str(PL_SEAL_DEC) )
AfaLoggerFunc.tradeDebug('业务种类(1-现金汇票 2-转账汇票 3-电子汇兑业务):' + TYPE )
AfaLoggerFunc.tradeDebug('出票日期:' + TRCDAT )
AfaLoggerFunc.tradeDebug('汇票号码:' + TRCNO )
AfaLoggerFunc.tradeDebug('出票金额:' + str(AMOUNT) )
AfaLoggerFunc.tradeDebug('出票行号:' + str(REMBNKCO) )
AfaLoggerFunc.tradeDebug('代理付款行号:' + str(PAYBNKCO) )
AfaLoggerFunc.tradeDebug('汇票密押:' + MIYA )
AfaLoggerFunc.tradeDebug('OTHERINFO[' + str(INFO) + ']')
AfaLoggerFunc.tradeDebug('TradeContext密押:' + TradeContext.SEAL )
#====begin 蔡永贵 20110215 修改====
#ret = miya.DraftEncrypt(PL_SEAL_DEC,TYPE,TRCDAT,TRCNO,AMOUNT,REMBNKCO,PAYBNKCO,INFO,MIYA)
ret = miya.DraftEncrypt(PL_SEAL_DEC,TYPE,TRCDAT,TradeContext.TMP_BILNO,AMOUNT,REMBNKCO,PAYBNKCO,INFO,MIYA)
#============end============
AfaLoggerFunc.tradeDebug('TradeContext密押:' + TradeContext.SEAL )
AfaLoggerFunc.tradeDebug( 'ret=' + str(ret) )
if ret == 9005:
return AfaFlowControl.ExitThisFlow('S999','密押错,请检查业务要素和密押')
elif ret > 0:
return AfaFlowControl.ExitThisFlow('S999','调用密押服务器失败')
AfaLoggerFunc.tradeInfo(">>>结束校验汇票密押")
#=================登记汇票登记簿========================================
AfaLoggerFunc.tradeInfo(">>>开始登记汇票登记簿")
#=================为汇票业务登记簿赋值==================================
TradeContext.OPRNO = PL_HPOPRNO_JF #业务类型解付
TradeContext.DCFLG = PL_DCFLG_CRE
TradeContext.BILRS = PL_BILRS_OUT
TradeContext.NCCWKDAT = TradeContext.NCCworkDate
TradeContext.TRCNO = TradeContext.SerialNo
TradeContext.SNDMBRCO = TradeContext.SNDSTLBIN
TradeContext.RCVMBRCO = '1000000000'
bilbka_dict = {}
if not rccpsMap8502CTradeContext2Dbilbka.map(bilbka_dict):
return AfaFlowControl.ExitThisFlow('S999','为汇票业务登记簿赋值异常')
#=================登记汇票业务登记簿====================================
if not rccpsDBFunc.insTransBil(bilbka_dict):
if not AfaDBFunc.RollbackSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
AfaLoggerFunc.tradeError(">>>Rollback异常")
AfaLoggerFunc.tradeInfo(">>>Rollback成功")
return AfaFlowControl.ExitThisFlow('S999','登记汇票业务登记簿异常')
#=================为汇票信息登记簿赋值==================================
bilinf_dict = {}
if not rccpsMap8502CTradeContext2Dbilinf.map(bilinf_dict):
if not AfaDBFunc.RollbackSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
AfaLoggerFunc.tradeError(">>>Rollback异常")
AfaLoggerFunc.tradeInfo(">>>Rollback成功")
return AfaFlowControl.ExitThisFlow('S999','为汇票信息登记簿赋值异常')
bilinf_dict['NOTE3'] = TradeContext.BESBNO #将交易机构赋值到汇票信息登记簿中note3字段
#=================登记汇票信息登记簿====================================
if not rccpsDBFunc.insInfoBil(bilinf_dict):
if not AfaDBFunc.RollbackSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
AfaLoggerFunc.tradeError(">>>Rollback异常")
AfaLoggerFunc.tradeInfo(">>>Rollback成功")
return AfaFlowControl.ExitThisFlow('S999','登记汇票信息登记簿异常')
AfaLoggerFunc.tradeInfo(">>>结束登记汇票登记簿")
#=================设置状态为发送处理中======================================
AfaLoggerFunc.tradeInfo(">>>开始设置业务状态为发送处理中")
stat_dict = {}
stat_dict['BJEDTE'] = TradeContext.BJEDTE
stat_dict['BSPSQN'] = TradeContext.BSPSQN
stat_dict['BCSTAT'] = PL_BCSTAT_SND
stat_dict['BDWFLG'] = PL_BDWFLG_WAIT
if not rccpsState.setTransState(stat_dict):
if not AfaDBFunc.RollbackSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
AfaLoggerFunc.tradeError(">>>Rollback异常")
AfaLoggerFunc.tradeInfo(">>>Rollback成功")
return AfaFlowControl.ExitThisFlow('S999','设置状态为发送处理中异常')
AfaLoggerFunc.tradeInfo(">>>结束设置业务状态为发送处理中")
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
return AfaFlowControl.ExitThisFlow("S999","Commit异常")
AfaLoggerFunc.tradeInfo(">>>Commit成功")
AfaLoggerFunc.tradeInfo( '***农信银系统：往账.主机类操作(1.本地操作).汇票解付[TRCC003_8502]结束***' )
#=================为汇票解付报文赋值========================================
AfaLoggerFunc.tradeInfo(">>>开始为解付报文赋值")
TradeContext.MSGTYPCO = "SET008"
TradeContext.SNDBRHCO = TradeContext.BESBNO
TradeContext.SNDCLKNO = TradeContext.BETELR
TradeContext.SNDTRDAT = TradeContext.BJEDTE
TradeContext.SNDTRTIM = TradeContext.BJETIM
TradeContext.MSGFLGNO = TradeContext.SNDSTLBIN + TradeContext.TRCDAT + TradeContext.SerialNo
TradeContext.NCCWKDAT = TradeContext.NCCworkDate
TradeContext.OPRTYPNO = "21"
TradeContext.ROPRTPNO = ""
TradeContext.TRANTYP = "0"
TradeContext.ORTRCCO = ""
TradeContext.TRCCO = '2100100'
TradeContext.TRCNO = TradeContext.SerialNo
TradeContext.RCVSTLBIN = TradeContext.RCVMBRCO
TradeContext.OPRATTNO = ""
AfaLoggerFunc.tradeInfo(">>>结束为解付报文赋值")
return True
def SubModuleDoFst():
AfaLoggerFunc.tradeInfo( "====开始汇票解付接收处理====" )
#=====判断是否重复交易====
sel_dict = {'TRCNO':TradeContext.TRCNO,'TRCDAT':TradeContext.TRCDAT,'SNDBNKCO':TradeContext.SNDBNKCO}
record = rccpsDBTrcc_bilbka.selectu(sel_dict)
if record == None:
return AfaFlowControl.ExitThisFlow('S999','判断是否重复报文，查询汇兑业务登记簿相同报文异常')
elif len(record) > 0:
AfaLoggerFunc.tradeInfo('汇票业务登记簿中存在相同数据,重复报文,进入下一流程')
#=====为通讯回执报文赋值====
out_context_dict = {}
out_context_dict['sysType'] = 'rccpst'
out_context_dict['TRCCO'] = '9900503'
out_context_dict['MSGTYPCO'] = 'SET008'
out_context_dict['RCVMBRCO'] = TradeContext.SNDMBRCO
out_context_dict['SNDMBRCO'] = TradeContext.RCVMBRCO
out_context_dict['SNDBRHCO'] = TradeContext.BESBNO
out_context_dict['SNDCLKNO'] = TradeContext.BETELR
out_context_dict['SNDTRDAT'] = TradeContext.BJEDTE
out_context_dict['SNDTRTIM'] = TradeContext.BJETIM
out_context_dict['ORMFN'] = TradeContext.MSGFLGNO
out_context_dict['MSGFLGNO'] = out_context_dict['SNDMBRCO'] + TradeContext.BJEDTE + TradeContext.SerialNo
out_context_dict['NCCWKDAT'] = TradeContext.NCCworkDate
out_context_dict['OPRTYPNO'] = '99'
out_context_dict['ROPRTPNO'] = TradeContext.OPRTYPNO
out_context_dict['TRANTYP'] = '0'
out_context_dict['ORTRCCO'] = TradeContext.TRCCO
out_context_dict['PRCCO'] = 'RCCI0000'
out_context_dict['STRINFO'] = '重复报文'
rccpsMap0000Dout_context2CTradeContext.map(out_context_dict)
#=====发送afe====
AfaAfeFunc.CommAfe()
return AfaFlowControl.ExitThisFlow('S999','重复报文，退出处理流程')
AfaLoggerFunc.tradeInfo(">>>结束判断是否重复报文")
#=====币种转换====
if TradeContext.CUR == 'CNY':
TradeContext.CUR = '01'
TradeContext.DCFLG = '1'
TradeContext.HPSTAT= PL_HPSTAT_PAYC #解付 02
TradeContext.OPRNO = PL_HPOPRNO_JF
#=====插入数据库====
AfaLoggerFunc.tradeInfo(">>>开始记录数据库操作")
bilbka_dict = {}
if not rccpsMap1113CTradeContext2Dbilbka.map(bilbka_dict):
return AfaFlowControl.ExitThisFlow("S999","为汇票业务登记簿赋值异常")
if not rccpsDBFunc.insTransBil(bilbka_dict):
return AfaFlowControl.ExitThisFlow('S999','登记汇票业务登记簿异常')
AfaDBFunc.CommitSql()
AfaLoggerFunc.tradeInfo(">>>结束记录数据库操作")
#=====设置状态为收妥====
sstlog = {}
sstlog['BSPSQN'] = TradeContext.BSPSQN
sstlog['BJEDTE'] = TradeContext.BJEDTE
sstlog['BCSTAT'] = PL_BCSTAT_BNKRCV
sstlog['BDWFLG'] = PL_BDWFLG_SUCC
#=====设置状态为 收妥-成功 ====
if not rccpsState.setTransState(sstlog):
#=====RollBack操作====
AfaDBFunc.RollbackSql()
return AfaFlowControl.ExitThisFlow(TradeContext.errorCode, TradeContext.errorMsg)
else:
#=====commit操作====
AfaDBFunc.CommitSql()
AfaLoggerFunc.tradeInfo('>>>commit成功')
#=====设置汇票业务登记簿和信息登记簿状态====
#=====设置汇票状态为解付====
AfaLoggerFunc.tradeInfo(">>>开始设置汇票状态为解付")
if not rccpsState.newBilState(TradeContext.BJEDTE,TradeContext.BSPSQN,PL_HPSTAT_PAYC):
return AfaFlowControl.ExitThisFlow("S999","设置汇票状态异常")
AfaLoggerFunc.tradeInfo(">>>结束设置汇票状态为解付")
#=====commit操作====
AfaDBFunc.CommitSql()
#=====设置汇票解付金额====
bil_dict = {}
bil_dict['BILNO'] = TradeContext.BILNO
bil_dict['BILVER'] = TradeContext.BILVER
bil_dict['BILRS'] = TradeContext.BILRS
bil_end = {}
bil_end['OCCAMT'] = TradeContext.OCCAMT
bil_end['RMNAMT'] = TradeContext.RMNAMT
bil_end['PAYBNKCO']= TradeContext.SNDBNKCO
bil_end['PAYBNKNM']= TradeContext.SNDBNKNM
ret = rccpsDBTrcc_bilinf.update(bil_end,bil_dict)
if (ret <= 0):
return AfaFlowControl.ExitThisFlow("S999","更新汇票信息异常")
AfaDBFunc.CommitSql()
AfaLoggerFunc.tradeInfo('>>>commit成功')
AfaLoggerFunc.tradeInfo(">>>开始判断是否存在多余款操作")
if float(TradeContext.RMNAMT) != 0.00:
AfaLoggerFunc.tradeInfo(">>>第二次记账赋值操作")
TradeContext.ACUR = '2' #记账循环次数
TradeContext.TRFG = '9' #凭证处理标识'
TradeContext.I2CETY = '' #凭证种类
TradeContext.I2TRAM = TradeContext.RMNAMT #结余金额
TradeContext.I2SMCD = PL_RCCSMCD_HPJF #摘要代码
TradeContext.I2RBAC = TradeContext.BESBNO + PL_ACC_DYKJQ #贷方账号
TradeContext.I2SBAC = TradeContext.BESBNO + PL_ACC_HCHK #借方账号
TradeContext.I2REAC = TradeContext.BESBNO + PL_ACC_NXYDXZ #挂账账号
#=====生成账号校验位====
TradeContext.I2SBAC = rccpsHostFunc.CrtAcc(TradeContext.I2SBAC,25)
TradeContext.I2RBAC = rccpsHostFunc.CrtAcc(TradeContext.I2RBAC,25)
TradeContext.I2REAC = rccpsHostFunc.CrtAcc(TradeContext.I2REAC,25)
AfaLoggerFunc.tradeInfo(">>>结束判断是否存在多余款操作")
AfaLoggerFunc.tradeInfo(">>>开始组织报文上送主机记账操作")
#=====组织报文发送主机记账====
TradeContext.RBAC = TradeContext.BESBNO + PL_ACC_NXYDQSLZ #贷方账号
TradeContext.SBAC = TradeContext.BESBNO + PL_ACC_HCHK #借方账号
TradeContext.REAC = TradeContext.BESBNO + PL_ACC_NXYDXZ #挂账账号
#=====生成账号校验位====
TradeContext.RBAC = rccpsHostFunc.CrtAcc(TradeContext.RBAC,25)
TradeContext.SBAC = rccpsHostFunc.CrtAcc(TradeContext.SBAC,25)
TradeContext.REAC = rccpsHostFunc.CrtAcc(TradeContext.REAC,25)
TradeContext.HostCode = '8813'
#关彬捷 20081007
#TradeContext.NOTE3 = '主机记账'
TradeContext.NOTE3 = ''
TradeContext.RCCSMCD = PL_RCCSMCD_HPJF #摘要代码
AfaLoggerFunc.tradeInfo(">>>结束组织报文上送主机记账操作")
AfaLoggerFunc.tradeInfo(">>>开始更新登记簿状态")
#关彬捷 20081007 改记账状态为自动入账
#TradeContext.BCSTAT = PL_BCSTAT_ACC #记账
TradeContext.BCSTAT = PL_BCSTAT_AUTO #自动入账
TradeContext.BDWFLG = PL_BDWFLG_WAIT #处理中
#=====新增sstlog表状态记录====
if not rccpsState.newTransState(TradeContext.BJEDTE,TradeContext.BSPSQN,TradeContext.BCSTAT,TradeContext.BDWFLG):
#=====RollBack操作====
AfaDBFunc.RollbackSql()
return AfaFlowControl.ExitThisFlow('M999', '设置状态['+TradeContext.BCSTAT+']['+TradeContext.BDWFLG+']失败,系统自动回滚')
else:
#=====commit操作====
AfaDBFunc.CommitSql()
AfaLoggerFunc.tradeInfo(">>>结束更新登记簿状态")
return True
def SubModuleDoFst():
AfaLoggerFunc.tradeInfo( '***农信银系统：往账.主机类操作(1.本地操作).行内账户转异地[TRCC002_8563]进入***' )
#=================必要性检查===============================================
AfaLoggerFunc.tradeInfo(">>>开始必要性检查")
#检查本机构是否有通存通兑业务权限
if not rccpsDBFunc.chkTDBESAuth(TradeContext.BESBNO):
return AfaFlowControl.ExitThisFlow("S999","本机构无通存通兑业务权限")
if TradeContext.PYRTYP == '1':
#折,调用8811校验支付条件
AfaLoggerFunc.tradeInfo(">>>开始校验付款人账号支付条件")
TradeContext.HostCode = '8811'
TradeContext.ACCNO = TradeContext.PYRACC #付款人账户
if TradeContext.PYRTYP == '0':
TradeContext.WARNTNO = TradeContext.PYRACC[6:18]
rccpsHostFunc.CommHost( TradeContext.HostCode )
if TradeContext.errorCode != '0000':
return AfaFlowControl.ExitThisFlow('S999','查询账户支付条件异常:' + TradeContext.errorMsg[7:])
elif TradeContext.PAYTYP != TradeContext.HPAYTYP:
return AfaFlowControl.ExitThisFlow('S999','支付条件错误')
AfaLoggerFunc.tradeInfo(">>>结束校验付款人账号支付条件")
AfaLoggerFunc.tradeInfo(">>>结束必要性检查")
#=================登记通存通兑业务登记簿===================================
AfaLoggerFunc.tradeInfo(">>>开始登记通存通兑业务登记簿")
TradeContext.SNDMBRCO = TradeContext.SNDSTLBIN #发送成员行号
TradeContext.RCVMBRCO = TradeContext.RCVSTLBIN #接收成员行号
TradeContext.TRCNO = TradeContext.SerialNo #交易流水号
TradeContext.NCCWKDAT = TradeContext.NCCworkDate #中心工作日期
TradeContext.MSGFLGNO = TradeContext.SNDMBRCO + TradeContext.TRCDAT + TradeContext.TRCNO
TradeContext.OPRNO = PL_TDOPRNO_BZY #业务种类:行内账户转异地
TradeContext.DCFLG = PL_DCFLG_CRE #借贷标识:贷记
TradeContext.BRSFLG = PL_BRSFLG_SND #往来标识:往账
#if TradeContext.PYITYP == '0' or '2':
# TradeContext.TRCCO = '3000003' #交易代码:3000003卡本转异
#elif TradeContext.PYITYP == '1' or '3':
# TradeContext.TRCCO = '3000005' #交易代码:3000005折本转异
#else:
# return AfaFlowContorl.ExitThisFlow("S999","收款人账户非法")
TradeContext.PYRMBRCO = TradeContext.SNDSTLBIN
TradeContext.PYEMBRCO = TradeContext.RCVSTLBIN
wtrbka_dict = {}
if not rccpsMap8563CTradeContext2Dwtrbka_dict.map(wtrbka_dict):
return AfaFlowContorl.ExitThisFlow("S999","为通存通兑业务登记簿赋值异常")
if not rccpsDBFunc.insTransWtr(wtrbka_dict):
return AfaFlowControl.ExitThisFlow('S999','登记通存通兑业务登记簿异常')
AfaLoggerFunc.tradeInfo(">>>结束登记通存通兑业务登记簿")
#=================设置业务状态为记账处理中=================================
AfaLoggerFunc.tradeInfo(">>>开始设置业务状态为记账处理中")
stat_dict = {}
stat_dict['BJEDTE'] = TradeContext.BJEDTE #交易日期
stat_dict['BSPSQN'] = TradeContext.BSPSQN #报单序号
stat_dict['BCSTAT'] = PL_BCSTAT_ACC #PL_BCSTAT_ACC 记账
stat_dict['BDWFLG'] = PL_BDWFLG_WAIT #PL_BDWFLG_WAIT 处理中
if not rccpsState.setTransState(stat_dict):
return AfaFlowControl.ExitThisFlow('S999','设置状态为记账处理中异常')
AfaLoggerFunc.tradeInfo(">>>结束设置业务状态为记账处理中")
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
return AfaFlowControl.ExitThisFlow("S999","Commit异常")
AfaLoggerFunc.tradeInfo(">>>结束设置业务状态为记账处理中")
#=================为主机记账做准备=========================================
AfaLoggerFunc.tradeInfo(">>>开始为主机记账做准备")
TradeContext.HostCode = '8813'
TradeContext.PKFG = 'T' #通存通兑标识
TradeContext.OCCAMT = str(TradeContext.OCCAMT) #出票金额
TradeContext.RCCSMCD = PL_RCCSMCD_BZYWZ #主机摘要码:本转异往账
TradeContext.SBAC = TradeContext.PYRACC #借方账号:客户账
TradeContext.ACNM = TradeContext.PYRNAM #借方户名
TradeContext.RBAC = TradeContext.BESBNO + PL_ACC_NXYDQSWZ #贷方账号:汇出汇款
TradeContext.RBAC = rccpsHostFunc.CrtAcc(TradeContext.RBAC,25)
TradeContext.OTNM = "农信银待清算往账"
TradeContext.PASSWD = TradeContext.PASSWD #付款人密码
AfaLoggerFunc.tradeInfo("PYRTYP = [" + TradeContext.PYRTYP + "]")
if TradeContext.PYRTYP == '0':
TradeContext.WARNTNO = TradeContext.SBAC[6:18]
TradeContext.CERTTYPE = TradeContext.CERTTYPE #证件类型
TradeContext.CERTNO = TradeContext.CERTNO #证件号码
TradeContext.CTFG = '7' #结转标识:结转-0
AfaLoggerFunc.tradeInfo("借方账号1:[" + TradeContext.SBAC + "]")
AfaLoggerFunc.tradeInfo("贷方账号1:[" + TradeContext.RBAC + "]")
AfaLoggerFunc.tradeInfo("凭证号码1:[" + TradeContext.WARNTNO + "]")
if TradeContext.CHRGTYP == '0':
#现金收取
AfaLoggerFunc.tradeInfo(">>>现金收取手续费")
TradeContext.ACUR = '2' #重复次数
TradeContext.I2PKFG = 'T' #通存通兑标识
TradeContext.I2CATR = '0' #现转标识:0-现金
TradeContext.I2TRAM = str(TradeContext.CUSCHRG) #手续费金额
TradeContext.I2SMCD = PL_RCCSMCD_SXF #主机摘要码:手续费
TradeContext.I2SBAC = "" #借方账号:柜员尾箱
TradeContext.I2ACNM = ""
TradeContext.I2RBAC = TradeContext.BESBNO + PL_ACC_TCTDSXF #贷方账号:通存通兑手续费
TradeContext.I2RBAC = rccpsHostFunc.CrtAcc(TradeContext.I2RBAC,25)
TradeContext.I2OTNM = "手续费"
TradeContext.I2CTFG = '8' #结转标识:不结转-1
elif TradeContext.CHRGTYP == '1':
#本地账户收取
AfaLoggerFunc.tradeInfo(">>>本地账户收取手续费")
TradeContext.ACUR = '2' #重复次数
TradeContext.I2PKFG = '8' #通存通兑标识
TradeContext.I2TRAM = str(TradeContext.CUSCHRG) #手续费金额
TradeContext.I2SMCD = PL_RCCSMCD_SXF #主机摘要码:手续费
TradeContext.I2SBAC = TradeContext.PYRACC #借方账号:客户账
TradeContext.I2ACNM = TradeContext.PYRNAM
TradeContext.I2RBAC = TradeContext.BESBNO + PL_ACC_TCTDSXF #贷方账号:通存通兑手续费
TradeContext.I2RBAC = rccpsHostFunc.CrtAcc(TradeContext.I2RBAC,25)
TradeContext.I2OTNM = "手续费"
TradeContext.I2PSWD = TradeContext.PASSWD #付款人密码
TradeContext.I2WARNTNO = TradeContext.WARNTNO
TradeContext.I2CERTTYPE = TradeContext.CERTTYPE #证件类型
TradeContext.I2CERTNO = TradeContext.CERTNO #证件号码
TradeContext.I2CTFG = 'T' #结转标识:不结转-1
else:
AfaLoggerFunc.tradeInfo(">>>不收手续费")
if TradeContext.existVariable("I2SBAC") and TradeContext.existVariable('I2RBAC'):
AfaLoggerFunc.tradeInfo("借方账号2:[" + TradeContext.I2SBAC + "]")
AfaLoggerFunc.tradeInfo("贷方账号2:[" + TradeContext.I2RBAC + "]")
AfaLoggerFunc.tradeInfo(">>>结束为主机记账做准备")
AfaLoggerFunc.tradeInfo( '***农信银系统：往账.主机类操作(1.本地操作).行内账户转异地[TRCC002_8563]退出***' )
return True
def SubModuleDoFst():
AfaLoggerFunc.tradeInfo( '***农信银系统: 往账.本地类操作交易[RCC001_8591]通存通兑错帐处理标识维护进入***' )
AfaLoggerFunc.tradeInfo('个性化处理(本地操作)')
#=====判断接口变量是否存在====
if not TradeContext.existVariable("SNDBNKCO"):
return AfaFlowControl.ExitThisFlow('A099','发送行号不能为空' )
if not TradeContext.existVariable("TRCDAT"):
return AfaFlowControl.ExitThisFlow('A009','委托日期不能为空')
if not TradeContext.existVariable("TRCNO"):
return AfaFlowControl.ExitThisFlow('A009','交易流水号不能为空')
if not TradeContext.existVariable("BJEDTE"):
return AfaFlowControl.ExitThisFlow('A009','报单日期不能为空')
if not TradeContext.existVariable("BSPSQN"):
return AfaFlowControl.ExitThisFlow('A009','报单序号不能为空')
AfaLoggerFunc.tradeInfo('个性化处理结束(本地操作)')
#=====得到nccwkdat====
if not rccpsFunc.GetNCCDate( ) : #NCCworkDate
raise AfaFlowControl.flowException( )
#=====查询错账登记簿====
where_dict = {}
where_dict = {'BJEDTE':TradeContext.BJEDTE,'BSPSQN':TradeContext.BSPSQN,'SNDBNKCO':TradeContext.SNDBNKCO,'TRCDAT':TradeContext.TRCDAT,'TRCNO':TradeContext.TRCNO}
tddzcz_record = rccpsDBTrcc_tddzcz.selectu(where_dict)
if(tddzcz_record == None):
return AfaFlowControl.ExitThisFlow('A009','查询错账登记簿失败')
elif(len(tddzcz_record) == 0):
return AfaFlowControl.ExitThisFlow('A009','查询错账登记簿为空')
else:
AfaLoggerFunc.tradeInfo("查询错账登记簿成功")
#=====查询原业务的信息====
AfaLoggerFunc.tradeInfo('查询原业务信息')
where_dict = {}
where_dict = {'BJEDTE':TradeContext.BJEDTE,'BSPSQN':TradeContext.BSPSQN}
wtrbka_record = rccpsDBTrcc_wtrbka.selectu(where_dict)
if(wtrbka_record == None):
return AfaFlowControl.ExitThisFlow('A009','查询业务登记簿失败')
elif(len(wtrbka_record) == 0):
return AfaFlowControl.ExitThisFlow('A009','查询业务登记簿为空')
else:
AfaLoggerFunc.tradeInfo('查询业务登记簿成功')
#=====查询业务的当前信息====
wtr_dict = {}
if not rccpsDBFunc.getTransWtr(TradeContext.BJEDTE,TradeContext.BSPSQN,wtr_dict):
return AfaFlowControl.ExitThisFlow('A009','查询业务的当前信息失败')
if(wtr_dict['BRSFLG'] == PL_BRSFLG_SND):
sstlog_dict = {}
if not rccpsState.getTransStateSet(TradeContext.BJEDTE,TradeContext.BSPSQN,PL_BCSTAT_ACC,PL_BDWFLG_SUCC,sstlog_dict):
return AfaFlowControl.ExitThisFlow('A009','查询业务状态信息失败')
wtr_dict['FEDT'] = sstlog_dict['FEDT']
wtr_dict['RBSQ'] = sstlog_dict['RBSQ']
TradeContext.CLDT = wtr_dict['FEDT']
TradeContext.UNSQ = wtr_dict['RBSQ']
if rccpsGetFunc.GetRBSQ(PL_BRSFLG_SND) == -1 : #RBSQ
return AfaFlowControl.ExitThisFlow('A099','产生前置流水号失败')
TradeContext.FEDT=AfaUtilTools.GetHostDate( ) #FEDT
#=====判断当前业务是否已经结转====
if(wtr_dict['BCSTAT'] == PL_BCSTAT_TRAS and wtr_dict['BDWFLG'] == PL_BDWFLG_SUCC):
return AfaFlowControl.ExitThisFlow('A009','该账务已经结转')
#=====判断业务的往来标示====
AfaLoggerFunc.tradeInfo('<<<<<<判断业务的往来标示')
if(wtrbka_record['BRSFLG'] == PL_BRSFLG_SND):
AfaLoggerFunc.tradeInfo('<<<<<<业务为往账')
acc = 0
hcac = 0
canc = 0
cancel = 0
#=====查询是否有记账成功的状态====
sstlog_list = []
if rccpsState.getTransStateSetm(TradeContext.BJEDTE,TradeContext.BSPSQN,PL_BCSTAT_ACC,PL_BDWFLG_SUCC,sstlog_list):
acc = len(sstlog_list)
#=====查询是否有抹账的状态====
sstlog_list = []
if rccpsState.getTransStateSetm(TradeContext.BJEDTE,TradeContext.BSPSQN,PL_BCSTAT_HCAC,PL_BDWFLG_SUCC,sstlog_list):
hcac = len(sstlog_list)
#=====查询是否有冲销的状态====
sstlog_list = []
if rccpsState.getTransStateSetm(TradeContext.BJEDTE,TradeContext.BSPSQN,PL_BCSTAT_CANC,PL_BDWFLG_SUCC,sstlog_list):
canc = len(sstlog_list)
#=====查询是否有冲正的状态====
ssltog_list = []
if rccpsState.getTransStateSetm(TradeContext.BJEDTE,TradeContext.BSPSQN,PL_BCSTAT_CANCEL,PL_BDWFLG_SUCC,sstlog_list):
cancel = len(sstlog_list)
#=====判断是否需要清算状态调整====
AfaLoggerFunc.tradeInfo('<<<<<<判断是否需要清算状态调整')
if(acc - (hcac + canc + cancel) >= 0):
AfaLoggerFunc.tradeInfo('<<<<<<需要进行清算状态调整')
TradeContext.BETELR = PL_BETELR_AUTO
TradeContext.BRSFLG = wtrbka_record['BRSFLG']
TradeContext.CHRGTYP = wtrbka_record['CHRGTYP']
TradeContext.BESBNO = wtrbka_record['BESBNO']
#=====卡折存现/本转异地====
if(wtrbka_record['TRCCO'] in ('3000002','3000003','3000004','3000005')):
AfaLoggerFunc.tradeInfo('卡折存现/本转异地')
TradeContext.HostCode = '8813'
TradeContext.ACUR = '1'
TradeContext.RCCSMCD = PL_RCCSMCD_DZBJ
TradeContext.SBAC = wtrbka_record['BESBNO'] + PL_ACC_NXYDQSWZ #借方账号
TradeContext.SBAC = rccpsHostFunc.CrtAcc(TradeContext.SBAC,25)
TradeContext.ACNM = '农信银待清算往账' #借方户名
TradeContext.RBAC = wtrbka_record['BESBNO'] + PL_ACC_NXYWZ #贷方账号
TradeContext.RBAC = rccpsHostFunc.CrtAcc(TradeContext.RBAC,25)
TradeContext.OTNM = '农信银往账' #贷方户名
TradeContext.OCCAMT = str(wtrbka_record['OCCAMT']) #发生额
TradeContext.PKFG = 'W'
TradeContext.CTFG = '7'
#=====卡折取现/异地转本地====
elif(wtrbka_record['TRCCO'] in ('3000102','3000103','3000104','3000105')):
AfaLoggerFunc.tradeInfo('卡折取现/异地转本地')
if(wtrbka_record['CHRGTYP'] == '1'): #转收
AfaLoggerFunc.tradeInfo("<<<<<转收手续费")
TradeContext.HostCode = '8813'
TradeContext.ACUR = '1'
TradeContext.RCCSMCD = PL_RCCSMCD_DZBJ
TradeContext.SBAC = wtrbka_record['BESBNO'] + PL_ACC_NXYWZ #借方账号
TradeContext.SBAC = rccpsHostFunc.CrtAcc(TradeContext.SBAC,25)
TradeContext.ACNM = '农信银往账'
TradeContext.RBAC = wtrbka_record['BESBNO'] + PL_ACC_NXYDQSWZ #贷方账号
TradeContext.RBAC = rccpsHostFunc.CrtAcc(TradeContext.RBAC,25)
TradeContext.OTNM = '农信银待清算往账'
TradeContext.OCCAMT = str(wtrbka_record['OCCAMT'] + wtrbka_record['CUSCHRG'])
TradeContext.PKFG = 'W'
TradeContext.CTFG = '9'
else: #现收
AfaLoggerFunc.tradeInfo("<<<<<现收手续费，或不收")
TradeContext.HostCode = '8813'
TradeContext.ACUR = '1'
TradeContext.RCCSMCD = PL_RCCSMCD_DZBJ
TradeContext.SBAC = wtrbka_record['BESBNO'] + PL_ACC_NXYWZ #借方账号
TradeContext.SBAC = rccpsHostFunc.CrtAcc(TradeContext.SBAC,25)
TradeContext.ACNM = '农信银往账'
TradeContext.RBAC = wtrbka_record['BESBNO'] + PL_ACC_NXYDQSWZ #贷方账号
TradeContext.RBAC = rccpsHostFunc.CrtAcc(TradeContext.RBAC,25)
TradeContext.OTNM = '农信银待清算往账'
TradeContext.OCCAMT = str(wtrbka_record['OCCAMT'])
TradeContext.PKFG = 'W'
TradeContext.CTFG = '9'
else:
return AfaFlowControl.ExitThisFlow('A099','原交易交易代码非法')
#=====增加原交易的状态--结转====
if not rccpsState.newTransState(TradeContext.BJEDTE,TradeContext.BSPSQN,PL_BCSTAT_TRAS,PL_BDWFLG_WAIT):
AfaDBFunc.RollbackSql()
return AfaFlowControl.ExitThisFlow('A099','增加原交易的状态--结转，失败')
else:
AfaDBFunc.CommitSql()
#=====调用主机交易====
rccpsHostFunc.CommHost( TradeContext.HostCode )
#=====判断主机交易是否成功====
if(TradeContext.errorCode != '0000'):
AfaLoggerFunc.tradeInfo("主机交易失败")
#=====更改原交易状态====
state_dict = {'BJEDTE':TradeContext.BJEDTE,'BSPSQN':TradeContext.BSPSQN,'BCSTAT':PL_BCSTAT_TRAS,'BDWFLG':PL_BDWFLG_FAIL}
state_dict['STRINFO'] = TradeContext.errorMsg
if not rccpsState.setTransState(state_dict):
AfaDBFunc.RollbackSql()
return AfaFlowControl.ExitThisFlow('A099','更改原交易状态失败')
else:
AfaDBFunc.CommitSql()
return AfaFlowControl.ExitThisFlow('A099','主机记账失败')
else:
AfaLoggerFunc.tradeInfo('主机记账成功')
#=====更改原交易状态====
state_dict = {}
state_dict['BJEDTE'] = TradeContext.BJEDTE
state_dict['BSPSQN'] = TradeContext.BSPSQN
state_dict['BCSTAT'] = PL_BCSTAT_TRAS
state_dict['BDWFLG'] = PL_BDWFLG_SUCC
if(TradeContext.existVariable("SBAC")):
state_dict['SBAC'] = TradeContext.SBAC
if(TradeContext.existVariable("RBAC")):
state_dict['RBAC'] = TradeContext.RBAC
state_dict['STRINFO'] = '主机成功'
if(TradeContext.existVariable('TRDT')):
state_dict['TRDT'] = TradeContext.TRDT
if(TradeContext.existVariable('TLSQ')):
state_dict['TLSQ'] = TradeContext.TLSQ
if not rccpsState.setTransState(state_dict):
AfaDBFunc.RollbackSql()
return AfaFlowControl.ExitThisFlow('A099','更改原交易状态失败')
else:
AfaDBFunc.CommitSql()
else:
return AfaFlowControl.ExitThisFlow('A009','原交易不能进行清算调整')
else:
AfaLoggerFunc.tradeInfo('<<<<<<业务为来账')
autopay = 0
auto = 0
hcac = 0
canc = 0
cancel = 0
#=====查询是否有记账成功的状态====
sstlog_list = []
if rccpsState.getTransStateSetm(TradeContext.BJEDTE,TradeContext.BSPSQN,PL_BCSTAT_AUTO,PL_BDWFLG_SUCC,sstlog_list):
auto = len(sstlog_list)
sstlog_list = []
if rccpsState.getTransStateSetm(TradeContext.BJEDTE,TradeContext.BSPSQN,PL_BCSTAT_AUTOPAY,PL_BDWFLG_SUCC,sstlog_list):
autopay = len(sstlog_list)
#=====查询是否有抹账的状态====
sstlog_list = []
if rccpsState.getTransStateSetm(TradeContext.BJEDTE,TradeContext.BSPSQN,PL_BCSTAT_HCAC,PL_BDWFLG_SUCC,sstlog_list):
hcac = len(sstlog_list)
#=====查询是否有冲销的状态====
sstlog_list = []
if rccpsState.getTransStateSetm(TradeContext.BJEDTE,TradeContext.BSPSQN,PL_BCSTAT_CANC,PL_BDWFLG_SUCC,sstlog_list):
canc = len(sstlog_list)
#=====查询是否有冲正的状态====
ssltog_list = []
if rccpsState.getTransStateSetm(TradeContext.BJEDTE,TradeContext.BSPSQN,PL_BCSTAT_CANCEL,PL_BDWFLG_SUCC,sstlog_list):
cancel = len(sstlog_list)
#=====判断原业务是否需要进行清算状态调整====
AfaLoggerFunc.tradeInfo("判断原业务是否需要进行清算状态调整")
if((auto + autopay) - (hcac + canc + cancel) >= 0):
AfaLoggerFunc.tradeInfo("原业务需要进行清算状态调整")
TradeContext.BETELR = PL_BETELR_AUTO
TradeContext.BRSFLG = wtrbka_record['BRSFLG']
TradeContext.CHRGTYP = wtrbka_record['CHRGTYP']
TradeContext.BESBNO = wtrbka_record['BESBNO']
#=====卡折存现/本转异地====
if(wtrbka_record['TRCCO'] in ('3000002','3000003','3000004','3000005')):
AfaLoggerFunc.tradeInfo('卡折存现/本转异地')
TradeContext.HostCode = '8813'
TradeContext.ACUR = '1'
TradeContext.RCCSMCD = PL_RCCSMCD_DZBJ
TradeContext.SBAC = wtrbka_record['BESBNO'] + PL_ACC_NXYLZ
TradeContext.SBAC = rccpsHostFunc.CrtAcc(TradeContext.SBAC,25)
TradeContext.ACNM = '农信银来账'
TradeContext.RBAC = wtrbka_record['BESBNO'] + PL_ACC_NXYDQSLZ
TradeContext.RBAC = rccpsHostFunc.CrtAcc(TradeContext.RBAC,25)
TradeContext.OTNM = '农信银待清算来账'
TradeContext.OCCAMT = str(wtrbka_record['OCCAMT'])
TradeContext.PKFG = 'W'
TradeContext.CTFG = '7'
#=====卡折取现/异地转本地====
elif(wtrbka_record['TRCCO'] in ('3000102','3000103','3000104','3000105')):
AfaLoggerFunc.tradeInfo('卡折存现/本转异地')
TradeContext.HostCode = '8813'
TradeContext.ACUR = '1'
TradeContext.RCCSMCD = PL_RCCSMCD_DZBJ
TradeContext.SBAC = wtrbka_record['BESBNO'] + PL_ACC_NXYDQSLZ
TradeContext.SBAC = rccpsHostFunc.CrtAcc(TradeContext.SBAC,25)
TradeContext.ACNM = '农信银待清算来账'
TradeContext.RBAC = wtrbka_record['BESBNO'] + PL_ACC_NXYLZ
TradeContext.RBAC = rccpsHostFunc.CrtAcc(TradeContext.RBAC,25)
TradeContext.OTNM = '农信银来账'
TradeContext.OCCAMT = str(wtrbka_record['OCCAMT'] + wtrbka_record['CUSCHRG'])
TradeContext.PKFG = 'W'
TradeContext.CTFG = '9'
else:
return AfaFlowControl.ExitThisFlow('A099','原交易交易代码非法')
#=====增加原交易的状态--结转====
if not rccpsState.newTransState(TradeContext.BJEDTE,TradeContext.BSPSQN,PL_BCSTAT_TRAS,PL_BDWFLG_WAIT):
AfaDBFunc.RollbackSql()
return AfaFlowControl.ExitThisFlow('A099','增加原交易的状态--结转，失败')
else:
AfaDBFunc.CommitSql()
#=====调用主机交易====
rccpsHostFunc.CommHost( TradeContext.HostCode )
#=====判断主机交易是否成功====
if(TradeContext.errorCode != '0000'):
AfaLoggerFunc.tradeInfo("主机交易失败")
#=====更改原交易状态====
state_dict = {'BJEDTE':TradeContext.BJEDTE,'BSPSQN':TradeContext.BSPSQN,'BCSTAT':PL_BCSTAT_TRAS,'BDWFLG':PL_BDWFLG_FAIL}
state_dict['STRINFO'] = TradeContext.errorMsg
if not rccpsState.setTransState(state_dict):
AfaDBFunc.RollbackSql()
return AfaFlowControl.ExitThisFlow('A099','更改原交易状态失败')
else:
AfaDBFunc.CommitSql()
return AfaFlowControl.ExitThisFlow('A099','主机记账失败')
else:
AfaLoggerFunc.tradeInfo('主机记账成功')
#=====更改原交易状态====
state_dict = {}
state_dict['BJEDTE'] = TradeContext.BJEDTE
state_dict['BSPSQN'] = TradeContext.BSPSQN
state_dict['BCSTAT'] = PL_BCSTAT_TRAS
state_dict['BDWFLG'] = PL_BDWFLG_SUCC
state_dict['STRINFO'] = '主机成功'
if(TradeContext.existVariable("SBAC")):
state_dict['SBAC'] = TradeContext.SBAC
if(TradeContext.existVariable("RBAC")):
state_dict['RBAC'] = TradeContext.RBAC
if(TradeContext.existVariable('TRDT')):
state_dict['TRDT'] = TradeContext.TRDT
if(TradeContext.existVariable('TLSQ')):
state_dict['TLSQ'] = TradeContext.TLSQ
if not rccpsState.setTransState(state_dict):
AfaDBFunc.RollbackSql()
return AfaFlowControl.ExitThisFlow('A099','更改原交易状态失败')
else:
AfaDBFunc.CommitSql()
else:
return AfaFlowControl.ExitThisFlow('A009','原交易不能进行清算调整')
#=====给修改字典赋值====
update_dict = {}
update_dict = {'ISDEAL':'1','NOTE3':'此笔错账已结转'}
where_dict = {}
where_dict = {'SNDBNKCO':TradeContext.SNDBNKCO,'TRCDAT':TradeContext.TRCDAT,'TRCNO':TradeContext.TRCNO,\
'BJEDTE':TradeContext.BJEDTE,'BSPSQN':TradeContext.BSPSQN}
#=====修改数据库中的数据====
AfaLoggerFunc.tradeInfo("通存通兑错帐处理标识修改")
res = rccpsDBTrcc_tddzcz.updateCmt(update_dict,where_dict)
if( res == -1 ):
return AfaFlowControl.ExitThisFlow('A099','修改通存通兑错帐处理标识失败')
elif( res == 0 ):
return AfaFlowControl.ExitThisFlow('A099','交易记录不存在')
#=====向下发的通知表中插入数据====
AfaLoggerFunc.tradeInfo("<<<<<<向通知表中插入数据")
insert_dict = {}
insert_dict['NOTDAT'] = AfaUtilTools.GetHostDate( )
insert_dict['BESBNO'] = wtrbka_record['BESBNO']
if(wtrbka_record['BRSFLG'] == PL_BRSFLG_RCV):
insert_dict['STRINFO'] = "此笔错账["+wtrbka_record['BSPSQN']+"]["+wtrbka_record['BJEDTE']+"]已做手工结转处理"
else:
insert_dict['STRINFO'] = "此笔错账["+wtrbka_record['BSPSQN']+"]["+wtrbka_record['BJEDTE']+"]已做手工结转处理 请用8522补打往账凭证"
if not rccpsDBTrcc_notbka.insertCmt(insert_dict):
return AfaFlowControl.ExitThisFlow('S999','向下发的通知表中插入数据失败')
AfaLoggerFunc.tradeInfo("<<<<<<向通知表中插入数据成功")
#=====给输出接口赋值====
TradeContext.errorCode = "0000"
TradeContext.errorMsg = "修改通存通兑错帐处理标识成功"
TradeContext.ISDEAL = '1'
# TradeContext.TLSQ = TradeContext.TLSQ
# TradeContext.RBSQ = TradeContext.RBSQ
# TradeContext.TRDT = TradeContext.TRDT
AfaLoggerFunc.tradeInfo( '***农信银系统: 往账.本地类操作交易[RCC001_8591]通存通兑错帐处理标识维护退出***' )
return True
def SubModuleDoFst():
AfaLoggerFunc.tradeInfo( '***农信银系统：往账.主机类操作(1.本地操作).汇票签发[TRCC002_8501]进入***' )
#====begin 蔡永贵 20110215 增加====
#新票据号是16位，需要取后8位，版本号为02，同时要兼容老票据号8位，版本号为01
if TradeContext.BILVER == '02':
TradeContext.TMP_BILNO = TradeContext.BILNO[-8:]
else:
TradeContext.TMP_BILNO = TradeContext.BILNO
#============end============
#=====汇票类交易接收成员行为总中心====
TradeContext.RCVSTLBIN = PL_RCV_CENTER
#=====出票日期为当前交易日期====
TradeContext.BILDAT = TradeContext.BJEDTE
#=====出票行为发起行号====
TradeContext.REMBNKCO = TradeContext.SNDBNKCO
TradeContext.REMBNKNM = TradeContext.SNDBNKNM
#=====生成汇票密押=====
AfaLoggerFunc.tradeInfo(">>>开始生成汇票密押")
#=====根据汇票类型赋值编押业务种类和兑付方式====
#=====PL_BILTYP_CASH 现金 PL_TYPE_XJHP 现金汇票====
#=====PL_BILTYP_TRAN 转账 PL_TYPE_ZZHP 转账汇票====
if TradeContext.BILTYP == PL_BILTYP_CASH:
TYPE = PL_TYPE_XJHP
TradeContext.PAYWAY = PL_PAYWAY_CASH
elif TradeContext.BILTYP == PL_BILTYP_TRAN:
TYPE = PL_TYPE_ZZHP
TradeContext.PAYWAY = PL_PAYWAY_TRAN
else:
return AfaFlowControl.ExitThisFlow("S999","汇票类型非法")
#=====资金来源为1-个人结算户时，需要调用8811校验支付条件====
if TradeContext.BBSSRC == '1':
TradeContext.HostCode = '8811'
TradeContext.ACCNO = TradeContext.PYRACC #付款人账户
rccpsHostFunc.CommHost( '8811' )
if TradeContext.errorCode != '0000':
return AfaFlowControl.ExitThisFlow('S999','查询凭证信息出错')
else:
if TradeContext.PAYTYP != TradeContext.HPAYTYP:
return AfaFlowControl.ExitThisFlow('S999','支付条件错误')
MIYA = "".rjust(10,' ')
TRCDAT = TradeContext.BILDAT #委托日期
TRCNO = TradeContext.BILNO #汇票号码
REMBNKCO = TradeContext.REMBNKCO #签发行
PAYBNKCO = TradeContext.PAYBNKCO #代理付款行
REMBNKCO = REMBNKCO.rjust(12,'0')
PAYBNKCO = PAYBNKCO.rjust(12,'0')
AMOUNT = str(TradeContext.BILAMT).split('.')[0] + str(TradeContext.BILAMT).split('.')[1]
AMOUNT = AMOUNT.rjust(15,'0')
INFO = ""
AfaLoggerFunc.tradeDebug('处理类型(0-编押 1-核押):' + str(PL_SEAL_ENC) )
AfaLoggerFunc.tradeDebug('业务种类(1-现金汇票 2-转账汇票 3-电子汇兑业务):' + TYPE )
AfaLoggerFunc.tradeDebug('出票日期:' + TRCDAT )
AfaLoggerFunc.tradeDebug('汇票号码:' + TRCNO )
AfaLoggerFunc.tradeDebug('出票金额:' + str(AMOUNT) )
AfaLoggerFunc.tradeDebug('出票行号:' + str(REMBNKCO) )
AfaLoggerFunc.tradeDebug('代理付款行号:' + str(PAYBNKCO) )
AfaLoggerFunc.tradeDebug('汇票密押:' + MIYA )
AfaLoggerFunc.tradeDebug('OTHERINFO[' + str(INFO) + ']')
#====begin 蔡永贵 20110215 修改====
#ret = miya.DraftEncrypt(PL_SEAL_ENC,TYPE,TRCDAT,TRCNO,AMOUNT,REMBNKCO,PAYBNKCO,INFO,MIYA)
ret = miya.DraftEncrypt(PL_SEAL_ENC,TYPE,TRCDAT,TradeContext.TMP_BILNO,AMOUNT,REMBNKCO,PAYBNKCO,INFO,MIYA)
#============end============
AfaLoggerFunc.tradeDebug( 'ret=' + str(ret) )
if ret > 0:
return AfaFlowControl.ExitThisFlow('S999','调用密押服务器生成密押失败')
TradeContext.SEAL = MIYA
AfaLoggerFunc.tradeDebug('TradeContext密押:' + TradeContext.SEAL )
AfaLoggerFunc.tradeInfo(">>>结束生成汇票密押")
#=====登记汇票业务登记簿====
AfaLoggerFunc.tradeInfo(">>>开始登记汇票业务登记簿")
TradeContext.SNDMBRCO = TradeContext.SNDSTLBIN #发送成员行号
TradeContext.RCVMBRCO = TradeContext.RCVSTLBIN #接收成员行号
TradeContext.TRCNO = TradeContext.SerialNo #交易流水号
TradeContext.NCCWKDAT = TradeContext.NCCworkDate #中心工作日期
TradeContext.OPRNO = PL_HPOPRNO_QF #业务种类:汇票签发
TradeContext.DCFLG = PL_DCFLG_CRE #借贷标识:贷记
TradeContext.BRSFLG = PL_BRSFLG_SND #往来标识:往账
TradeContext.TRCCO = '2100001' #交易代码:2100001汇票签发
bilbka_dict = {}
if not rccpsMap8501CTradeContext2Dbilbka.map(bilbka_dict):
return AfaFlowContorl.ExitThisFlow("S999","为汇票业务登记簿赋值异常")
if not rccpsDBFunc.insTransBil(bilbka_dict):
return AfaFlowControl.ExitThisFlow('S999','登记汇票业务登记簿异常')
AfaLoggerFunc.tradeInfo(">>>结束登记汇票业务登记簿")
#=====登记汇票信息登记簿====
AfaLoggerFunc.tradeInfo(">>>开始登记汇票信息登记簿")
TradeContext.NOTE1 = TradeContext.BJEDTE
TradeContext.NOTE2 = TradeContext.BSPSQN
TradeContext.NOTE3 = TradeContext.BESBNO
bilinf_dict = {}
if not rccpsMap8501CTradeContext2Dbilinf.map(bilinf_dict):
return AfaFlowContorl.ExitThisFlow("S999","为汇票信息登记簿赋值异常")
if not rccpsDBFunc.insInfoBil(bilinf_dict):
return AfaFlowControl.ExitThisFlow('S999','登记汇票信息登记簿异常')
AfaLoggerFunc.tradeInfo(">>>结束登记汇票信息登记簿")
#=====设置业务状态为记账处理中====
AfaLoggerFunc.tradeInfo(">>>开始设置业务状态为记账处理中")
stat_dict = {}
stat_dict['BJEDTE'] = TradeContext.BJEDTE #交易日期
stat_dict['BSPSQN'] = TradeContext.BSPSQN #报单序号
stat_dict['BCSTAT'] = PL_BCSTAT_ACC #PL_BCSTAT_ACC 记账
stat_dict['BDWFLG'] = PL_BDWFLG_WAIT #PL_BDWFLG_WAIT 处理中
if not rccpsState.setTransState(stat_dict):
return AfaFlowControl.ExitThisFlow('S999','设置状态为记账处理中异常')
AfaLoggerFunc.tradeInfo(">>>结束设置业务状态为记账处理中")
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
return AfaFlowControl.ExitThisFlow("S999","Commit异常")
#=====为主机记账做准备====
AfaLoggerFunc.tradeInfo(">>>开始为主机记账做准备")
#=====非待销账,借付款人账号,待销账,借方账号赋空====
if TradeContext.BBSSRC != '3':
TradeContext.SBAC = TradeContext.PYRACC #借方账号
TradeContext.ACNM = TradeContext.PYRNAM
else:
TradeContext.SBAC = ''
TradeContext.ACNM = ''
TradeContext.RBAC = TradeContext.BESBNO + PL_ACC_HCHK #贷方账号
TradeContext.RBAC = rccpsHostFunc.CrtAcc(TradeContext.RBAC,25)
TradeContext.OTNM = "汇出汇款"
AfaLoggerFunc.tradeInfo("借方账号:[" + TradeContext.SBAC + "]")
AfaLoggerFunc.tradeInfo("贷方账号:[" + TradeContext.RBAC + "]")
#=====银行卡,凭证号码取账号的7到18位====
if TradeContext.BBSSRC == '0':
TradeContext.WARNTNO = TradeContext.SBAC[6:18]
AfaLoggerFunc.tradeDebug("凭证号码:[" + TradeContext.WARNTNO + "]")
TradeContext.HostCode = '8813'
TradeContext.OCCAMT = TradeContext.BILAMT #出票金额
TradeContext.RCCSMCD = PL_RCCSMCD_HPQF #主机摘要码:汇票签发
TradeContext.ACUR = '2' #重复次数
TradeContext.TRFG = '4' #凭证处理标识
AfaLoggerFunc.tradeDebug("TradeContext.TRFG=[" + TradeContext.TRFG + "]")
AfaLoggerFunc.tradeDebug("TradeContext.PASSWD=[" + TradeContext.PASSWD + "]")
AfaLoggerFunc.tradeDebug("TradeContext.WARNTNO=[" + TradeContext.WARNTNO + "]")
AfaLoggerFunc.tradeInfo(">>>结束为主机记账做准备")
AfaLoggerFunc.tradeInfo( '***农信银系统：往账.主机类操作(1.本地操作).汇票签发[TRCC002_8501]退出***' )
return True
def SubModuleDoTrd():
AfaLoggerFunc.tradeInfo( '***农信银系统：往账.主机类操作(3.中心记账).汇票签发[TRCC002_8501]进入***' )
stat_dict = {}
stat_dict['BJEDTE'] = TradeContext.BJEDTE
stat_dict['BSPSQN'] = TradeContext.BSPSQN
stat_dict['BESBNO'] = TradeContext.BESBNO
stat_dict['BETELR'] = TradeContext.BETELR
stat_dict['BCSTAT'] = PL_BCSTAT_SND
stat_dict['BDWFLG'] = PL_BDWFLG_SUCC
stat_dict['PRCCO'] = TradeContext.errorCode
stat_dict['STRINFO'] = TradeContext.errorMsg
AfaLoggerFunc.tradeInfo("TradeContext.errorCode = [" + TradeContext.errorCode + "]")
if TradeContext.errorCode == '0000':
#=====发送农信银成功,设置状态为发送成功====
stat_dict['BCSTAT'] = PL_BCSTAT_SND
stat_dict['BDWFLG'] = PL_BDWFLG_SUCC
if not rccpsState.setTransState(stat_dict):
return AfaFlowControl.ExitThisFlow('S999', "设置业务状态为发送成功异常")
AfaLoggerFunc.tradeInfo(">>>设置业务状态为发送成功")
else:
#=====发送农信银失败,设置状态为发送失败====
stat_dict['BCSTAT'] = PL_BCSTAT_SND
stat_dict['BDWFLG'] = PL_BDWFLG_FAIL
if not rccpsState.setTransState(stat_dict):
return AfaFlowControl.ExitThisFlow('S999', "设置业务状态为发送失败异常")
AfaLoggerFunc.tradeInfo(">>>设置业务状态为发送失败")
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
return AfaFlowControl.ExitThisFlow("S999","Commit异常")
#====自动抹账====
AfaLoggerFunc.tradeInfo(">>>开始自动抹账")
#====设置业务状态为抹账处理中====
if not rccpsState.newTransState(TradeContext.BJEDTE,TradeContext.BSPSQN,PL_BCSTAT_HCAC,PL_BDWFLG_WAIT):
return AfaFlowControl.ExitThisFlow('S999','设置业务状态为抹账处理中异常')
AfaLoggerFunc.tradeInfo(">>>设置业务状态为抹账处理中")
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
return AfaFlowControl.ExitThisFlow("S999","Commit异常")
#=====发起主机抹账====
#=====如果资金来源为代销账，使用8813红字冲销====
TradeContext.BOJEDT = TradeContext.BJEDTE #给前置日期赋值
TradeContext.BOSPSQ = TradeContext.BSPSQN #给前置流水号赋值
if TradeContext.BBSSRC == '3': #待销账
TradeContext.HostCode= '8813'
TradeContext.DASQ = ''
TradeContext.RVFG = '0' #红蓝字标志 0红字
TradeContext.SBAC = TradeContext.BESBNO + PL_ACC_HCHK #借方账号
TradeContext.RBAC = TradeContext.BESBNO + PL_ACC_NXYDXZ #贷方账号
#=====开始调函数拼贷方账号第25位校验位====
TradeContext.SBAC = rccpsHostFunc.CrtAcc(TradeContext.SBAC, 25)
TradeContext.RBAC = rccpsHostFunc.CrtAcc(TradeContext.RBAC, 25)
AfaLoggerFunc.tradeInfo( '借方账号:' + TradeContext.SBAC )
AfaLoggerFunc.tradeInfo( '贷方账号:' + TradeContext.RBAC )
else:
TradeContext.HostCode='8820'
#=====调起抹账主机接口====
rccpsHostFunc.CommHost( TradeContext.HostCode )
stat_dict = {}
stat_dict['BJEDTE'] = TradeContext.BJEDTE
stat_dict['BSPSQN'] = TradeContext.BSPSQN
stat_dict['BESBNO'] = TradeContext.BESBNO
stat_dict['BETELR'] = TradeContext.BETELR
if TradeContext.HostCode == '8813':
stat_dict['SBAC'] = TradeContext.SBAC
stat_dict['RBAC'] = TradeContext.RBAC
if TradeContext.existVariable('TRDT'):
stat_dict['TRDT'] = TradeContext.TRDT
if TradeContext.existVariable('TLSQ'):
stat_dict['TLSQ'] = TradeContext.TLSQ
stat_dict['MGID'] = TradeContext.errorCode
stat_dict['STRINFO'] = TradeContext.errorMsg
AfaLoggerFunc.tradeInfo("TradeContext.errorCode = [" + TradeContext.errorCode + "]")
if TradeContext.errorCode == '0000':
#=====主机抹账成功,设置业务状态为抹账成功====
stat_dict['BCSTAT'] = PL_BCSTAT_HCAC
stat_dict['BDWFLG'] = PL_BDWFLG_SUCC
if not rccpsState.setTransState(stat_dict):
return AfaFlowControl.ExitThisFlow('S999','设置业务状态抹账成功异常')
AfaLoggerFunc.tradeInfo(">>>设置业务状态为抹账成功")
else:
#=====主机抹账失败,设置业务状态为抹账失败====
stat_dict['BCSTAT'] = PL_BCSTAT_HCAC
stat_dict['BDWFLG'] = PL_BDWFLG_FAIL
if not rccpsState.setTransState(stat_dict):
return AfaFlowControl.ExitThisFlow('S999','设置业务状态抹账成功异常')
AfaLoggerFunc.tradeInfo(">>>设置业务状态为抹账失败")
AfaLoggerFunc.tradeInfo(">>>结束自动抹账")
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
return AfaFlowControl.ExitThisFlow("S999","Commit异常")
AfaLoggerFunc.tradeInfo( '***农信银系统：往账.主机类操作(3.中心记帐).汇票签发[TRCC002_8501]退出***' )
return True
def SubModuleDoFst():
AfaLoggerFunc.tradeInfo("农信银系统：来账.中心类操作(1.本地操作).柜台冲正来账接收[TRCC006_1144]进入")
AfaLoggerFunc.tradeDebug(">>>BJEDTE==" + TradeContext.BJEDTE)
AfaLoggerFunc.tradeDebug(">>>BSPSQN==" + TradeContext.BSPSQN)
#=====判断是否为重复交易====
AfaLoggerFunc.tradeInfo(">>>判断是否为重复交易")
where_dict = {}
where_dict = {'MSGFLGNO':TradeContext.MSGFLGNO}
record = rccpsDBTrcc_atcbka.selectu(where_dict)
if( record == None ):
AfaLoggerFunc.tradeDebug(">>>查找冲正登记簿异常,抛弃报文,等待中心重新发送自动冲正报文")
return AfaFlowControl.ExitThisFlow('A099',"查找冲正登记簿异常,抛弃报文,等待中心重新发送自动冲正报文")
elif( len(record) > 0 ): #重复交易
AfaLoggerFunc.tradeDebug(">>>自动冲正交易重复")
#=====为返回自动冲正成功发送成功回执====
#TradeContext.MSGTYPCO = 'SET010' #报文类代码
#TradeContext.PRCCO = 'RCCI0000' #中心返回码
#TradeContext.ORMFN = TradeContext.MSGFLGNO #参考报文标示号
#TradeContext.SNDSTLBIN= TradeContext.RCVMBRCO #发送成员行号
#TradeContext.RCVSTLBIN= TradeContext.SNDMBRCO #接收成员行号
#TradeContext.STRINFO = '自动冲正交易重复' #附言
#
#return True
TradeContext.BJEDTE = record['BJEDTE']
TradeContext.BSPSQN = record['BSPSQN']
else:
#TradeContext.OR_BJEDTE = TradeContext.BJEDTE #为下面更新atcbka表时的字典赋值
#TradeContext.OR_BSPSQN = TradeContext.BSPSQN #为下面更新atcbka表时的字典赋值
#=====开始登记自动冲正登记簿====
AfaLoggerFunc.tradeDebug(">>>登记自动冲正登记簿")
atcbka_dict = {}
if not rccpsMap1144CTradeContext2Datcbka_dict.map(atcbka_dict):
AfaLoggerFunc.tradeDebug(">>>自动冲正登记簿字典赋值失败,抛弃报文,等待自动冲正报文下次来得")
return AfaFlowControl.ExitThisFlow('A099',"自动冲正登记簿字典赋值失败")
res = rccpsDBTrcc_atcbka.insertCmt(atcbka_dict)
if( res == -1):
AfaLoggerFunc.tradeDebug(">>>自动冲正登记簿插入数据失败,数据库会滚,抛弃报文")
AfaDBFunc.RollbackSql()
return AfaFlowControl.ExitThisFlow('A099',"冲正登记簿插入数据失败")
else:
AfaDBFunc.CommitSql()
#=====判断中心日期是否相同====
if TradeContext.NCCWKDAT != TradeContext.NCCworkDate:
AfaLoggerFunc.tradeDebug(">>>查找原交易失败,未收到原交易,直接回复成功报文")
#=====为返回自动冲正成功发送成功回执====
TradeContext.MSGTYPCO = 'SET010' #报文类代码
TradeContext.PRCCO = 'RCCI0006' #中心返回码
TradeContext.ORMFN = TradeContext.MSGFLGNO #参考报文标示号
TradeContext.SNDSTLBIN= TradeContext.RCVMBRCO #发送成员行号
TradeContext.RCVSTLBIN= TradeContext.SNDMBRCO #接收成员行号
TradeContext.STRINFO = '冲正日期不合法' #附言
return True
#=====判断原交易代码====
if TradeContext.ORTRCCO == '3000504':
#=====3000504 柜台冲销报文====
AfaLoggerFunc.tradeDebug('>>>查找原冲销业务是否存在')
mpcbka_where = {'MSGFLGNO':TradeContext.ORMFN}
record = rccpsDBTrcc_mpcbka.selectu(mpcbka_where)
if record == None:
AfaLoggerFunc.tradeDebug('>>>查找原冲销业务异常,抛弃报文,等待中心再次发生自动冲正')
return AfaFlowControl.ExitThisFlow('S999','抛弃报文')
elif len(record) <= 0:
AfaLoggerFunc.tradeDebug('>>>查找原冲销业务空,回复成功')
#=====为返回冲正成功发送成功回执====
TradeContext.MSGTYPCO = 'SET010' #报文类代码
TradeContext.PRCCO = 'RCCI0000' #中心返回码
TradeContext.ORMFN = TradeContext.MSGFLGNO #参考报文标示号
TradeContext.SNDSTLBIN= TradeContext.RCVMBRCO #发送成员行号
TradeContext.RCVSTLBIN= TradeContext.SNDMBRCO #接收成员行号
TradeContext.STRINFO = '原冲销业务已冲正成功' #附言
return True
#return AfaFlowControl.ExitThisFlow('S999','抛弃报文')
else:
AfaLoggerFunc.tradeDebug('>>>查找冲销业务成功')
#=====将原报单序号 原交易日期更新到冲正登记簿中====
AfaLoggerFunc.tradeInfo('>>>更新原报单序号\原交易日期')
atcbka_where={}
atcbka_where['BJEDTE'] = TradeContext.BJEDTE #交易日期
atcbka_where['BSPSQN'] = TradeContext.BSPSQN #报单序号
atcbka_dict ={}
atcbka_dict['BOJEDT'] = record['BJEDTE'] #原交易日期
atcbka_dict['BOSPSQ'] = record['BSPSQN'] #原报单序号
atcbka_dict['STRINFO'] = TradeContext.STRINFO #附言
atcbka_dict['ORTRCDAT']= record['TRCDAT'] #原委托日期
atcbka_dict['BESBNO'] = record['BESBNO'] #原机构号
atcbka_dict['OPRNO'] = PL_TDOPRNO_CZ #业务类型
ret = rccpsDBTrcc_atcbka.update(atcbka_dict,atcbka_where)
AfaLoggerFunc.tradeDebug('>>>ret=='+str(ret))
if ret <= 0:
AfaDBFunc.RollbackSql( )
return AfaFlowControl.ExitThisFlow('S999', "更新自动冲正登记簿原报单序号和原交易日期异常,抛弃报文")
else:
AfaDBFunc.CommitSql( )
AfaLoggerFunc.tradeInfo(">>>结束更新冲销登记簿原交易日期和原报单序号")
#=====通过冲销登记簿查找原业务====
AfaLoggerFunc.tradeDebug('>>>通过冲销登记簿中原报单序号和原交易日期查询原业务')
wtr_where = {'BJEDTE':record['BOJEDT'],'BSPSQN':record['BOSPSQ']}
wtr_dict = rccpsDBTrcc_wtrbka.selectu(wtr_where)
if wtr_dict == None:
AfaLoggerFunc.tradeDebug('>>>通过冲销登记簿中原报单序号和原交易日期查询原交易异常,抛弃报文,等待中心再次发生自动冲正')
return AfaFlowControl.ExitThisFlow('S999','抛弃报文')
elif len(wtr_dict) <= 0:
AfaLoggerFunc.tradeDebug('>>>通过冲销登记簿中原报单序号和原交易日期查询原交易败,抛弃报文,等待中心再次发生自动冲正')
return AfaFlowControl.ExitThisFlow('S999','抛弃报文')
else:
AfaLoggerFunc.tradeDebug('>>>查找原业务成功')
#=====取原业务的业务状态====
AfaLoggerFunc.tradeDebug('>>>取原业务业务状态')
spb_where = {'BJEDTE':wtr_dict['BJEDTE'],'BSPSQN':wtr_dict['BSPSQN']}
spb_dict = rccpsDBTrcc_spbsta.selectu(spb_where)
if spb_dict == None:
AfaLoggerFunc.tradeDebug('>>>取原业务业务状态异常,抛弃报文,等待中心再次发生自动冲正')
return AfaFlowControl.ExitThisFlow('S999','抛弃报文')
elif len(spb_dict) <= 0:
AfaLoggerFunc.tradeDebug('>>>取原业务业务状态失败,抛弃报文,等待中心再次发生自动冲正')
return AfaFlowControl.ExitThisFlow('S999','抛弃报文')
else:
AfaLoggerFunc.tradeDebug('>>>取原业务业务状态成功')
#关彬捷 20081226 新增查询交易当前状态详细信息
#查询交易当前状态详细信息
sstlog_where = {'BJEDTE':wtr_dict['BJEDTE'],'BSPSQN':wtr_dict['BSPSQN'],'BCURSQ':spb_dict['BCURSQ']}
spb_dict = rccpsDBTrcc_sstlog.selectu(sstlog_where)
if( spb_dict == None ):
return AfaFlowControl.ExitThisFlow('S999','取原业务业务状态详细信息异常,抛弃报文,等待中心再次发生自动冲正')
elif len(spb_dict) <= 0:
return AfaFlowControl.ExitThisFlow('S999','取原业务业务状态详细信息失败,抛弃报文,等待中心再次发生自动冲正')
else:
AfaLoggerFunc.tradeDebug('>>>取原业务业务状态详细信息成功')
#关彬捷 20081226 新增若交易当前状态为自动扣款,自动入账,冲销,冲正处理中状态,则直接拒绝此冲销
if (spb_dict['BCSTAT'] == PL_BCSTAT_AUTO or spb_dict['BCSTAT'] == PL_BCSTAT_AUTOPAY or spb_dict['BCSTAT'] == PL_BCSTAT_CANC or spb_dict['BCSTAT'] == PL_BCSTAT_CANCEL) and spb_dict['BDWFLG'] == PL_BDWFLG_WAIT:
return AfaFlowControl.ExitThisFlow('S999','原业务账务状态未知,抛弃报文,等待中心再次发起自动冲正')
#关彬捷 20081226 新增若交易当前状态为自动扣款,自动入账,冲销,冲正失败状态,则调用8816查询账务状态
if (spb_dict['BCSTAT'] == PL_BCSTAT_AUTO or spb_dict['BCSTAT'] == PL_BCSTAT_AUTOPAY or spb_dict['BCSTAT'] == PL_BCSTAT_CANC or spb_dict['BCSTAT'] == PL_BCSTAT_CANCEL) and spb_dict['BDWFLG'] == PL_BDWFLG_FAIL:
AfaLoggerFunc.tradeDebug('>>>调用8816查找该业务[' + wtr_dict['BSPSQN'] + ']状态')
TradeContext.HostCode = '8816' #主机交易码
TradeContext.OPFG = '1' #查询类型
TradeContext.NBBH = 'RCC' #代理业务标识
TradeContext.FEDT = spb_dict['FEDT'] #原前置日期
TradeContext.RBSQ = spb_dict['RBSQ'] #原前置流水号
TradeContext.DAFG = '1' #抹/记账标志 1:记 2:抹
TradeContext.BESBNO = spb_dict['BESBNO'] #机构号
TradeContext.BETELR = spb_dict['BETELR'] #柜员号
rccpsHostFunc.CommHost( TradeContext.HostCode )
#=====分析主机返回====
if TradeContext.errorCode == '0000':
#此账务已成功记主机账,修改原交易状态为记账成功
AfaLoggerFunc.tradeInfo("此账务已成功记主机账,修改原交易状态为记账成功")
stat_dict = {}
stat_dict['BJEDTE'] = spb_dict['BJEDTE']
stat_dict['BSPSQN'] = spb_dict['BSPSQN']
stat_dict['BCSTAT'] = spb_dict['BCSTAT']
stat_dict['BDWFLG'] = PL_BDWFLG_SUCC
stat_dict['TRDT'] = HostContext.O1DADT #主机日期
stat_dict['TLSQ'] = HostContext.O1AMTL #主机流水
stat_dict['MGID'] = '0000'
stat_dict['STRINFO']= '主机成功'
if not rccpsState.setTransState(stat_dict):
return AfaFlowControl.ExitThisFlow('S999','设置原交易业务状态为记账成功异常,抛弃报文,等待下次冲正')
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
return AfaFlowControl.ExitThisFlow("S999","Commit异常")
#更新查询出交易状态
spb_dict['BDWFLG'] = PL_BDWFLG_SUCC
spb_dict['TRDT'] = HostContext.O1DADT
spb_dict['TLSQ'] = HostContext.O1AMTL
elif TradeContext.errorCode == 'XCR0001':
AfaLoggerFunc.tradeInfo(">>>主机返回原交易记账失败,继续冲销")
else:
AfaLoggerFunc.tradeInfo(">>>查询原交易账务状态异常,返回拒绝应答")
#回滚原被冲销交易状态为冲销前状态
AfaLoggerFunc.tradeInfo(">>>开始回滚原被冲销交易状态为冲销前状态")
spbsta_dict = {}
if not rccpsState.getTransStateDes(spb_dict['BJEDTE'],spb_dict['BSPSQN'],spbsta_dict,1):
return AfaFlowControl.ExitThisFlow('S999','查询原被冲销交易冲销前状态异常')
if not rccpsState.newTransState(spbsta_dict['BJEDTE'],spbsta_dict['BSPSQN'],spbsta_dict['BCSTAT'],spbsta_dict['BDWFLG']):
return AfaFlowControl.ExitThisFlow('S999','回滚状态为冲销前状态异常')
else:
AfaDBFunc.CommitSql()
sstlog_dict = {}
sstlog_dict['BJEDTE'] = spbsta_dict['BJEDTE']
sstlog_dict['BSPSQN'] = spbsta_dict['BSPSQN']
sstlog_dict['BCSTAT'] = spbsta_dict['BCSTAT']
sstlog_dict['BDWFLG'] = spbsta_dict['BDWFLG']
sstlog_dict['NOTE3'] = '冲销交易被冲正,回滚为冲销前状态'
if spbsta_dict.has_key('FEDT'): #前置日期
sstlog_dict['FEDT'] = spbsta_dict['FEDT']
if spbsta_dict.has_key('RBSQ'): #前置流水号
sstlog_dict['RBSQ'] = spbsta_dict['RBSQ']
if spbsta_dict.has_key('TRDT'): #主机日期
sstlog_dict['TRDT'] = spbsta_dict['TRDT']
if spbsta_dict.has_key('TLSQ'): #主机流水号
sstlog_dict['TLSQ'] = spbsta_dict['TLSQ']
sstlog_dict['MGID'] = spbsta_dict['MGID'] #主机返回码
sstlog_dict['STRINFO'] = spbsta_dict['STRINFO'] #主机返回信息
if not rccpsState.setTransState(sstlog_dict):
return AfaFlowControl.ExitThisFlow('S999','回滚状态为冲正前状态详细信息异常')
else:
AfaDBFunc.CommitSql()
AfaLoggerFunc.tradeInfo(">>>结束回滚原被冲销交易状态为冲销前状态")
#=====为返回冲销成功发送拒绝回执====
TradeContext.MSGTYPCO = 'SET010' #报文类代码
TradeContext.PRCCO = 'RCCO1006' #中心返回码
TradeContext.ORMFN = TradeContext.MSGFLGNO #参考报文标示号
TradeContext.SNDSTLBIN= TradeContext.RCVMBRCO #发送成员行号
TradeContext.RCVSTLBIN= TradeContext.SNDMBRCO #接收成员行号
TradeContext.STRINFO = '原交易账务状态未知' #附言
return True
#=====判断原业务业务状态====
#=====PL_BCSTAT_CANC 冲销====
if not (spb_dict['BCSTAT'] == PL_BCSTAT_CANC and spb_dict['BDWFLG'] == PL_BDWFLG_SUCC):
#=====原业务未冲销,直接回复成功即可====
AfaLoggerFunc.tradeDebug(">>>原交易未冲销成功,回复成功")
#=====为返回冲销成功发送成功回执====
TradeContext.MSGTYPCO = 'SET010' #报文类代码
TradeContext.PRCCO = 'RCCI0000' #中心返回码
TradeContext.ORMFN = TradeContext.MSGFLGNO #参考报文标示号
TradeContext.SNDSTLBIN= TradeContext.RCVMBRCO #发送成员行号
TradeContext.RCVSTLBIN= TradeContext.SNDMBRCO #接收成员行号
TradeContext.STRINFO = '原冲销业务已冲正成功' #附言
return True
elif spb_dict['TRDT'] == '' and spb_dict['TLSQ'] == '':
#=====原业务冲销成功,但未抹账,回滚冲销前状态,回复冲正成功====
AfaLoggerFunc.tradeDebug(">>>原业务冲销成功,但未抹账,回滚冲销前状态,回复冲正成功")
#回滚原被冲销交易状态为冲销前状态
AfaLoggerFunc.tradeInfo(">>>开始回滚原被冲销交易状态为冲销前状态")
spbsta_dict = {}
if not rccpsState.getTransStateDes(spb_dict['BJEDTE'],spb_dict['BSPSQN'],spbsta_dict,1):
return AfaFlowControl.ExitThisFlow('S999','查询原被冲销交易冲销前状态异常')
if not rccpsState.newTransState(spbsta_dict['BJEDTE'],spbsta_dict['BSPSQN'],spbsta_dict['BCSTAT'],spbsta_dict['BDWFLG']):
return AfaFlowControl.ExitThisFlow('S999','回滚状态为冲销前状态异常')
else:
AfaDBFunc.CommitSql()
sstlog_dict = {}
sstlog_dict['BJEDTE'] = spbsta_dict['BJEDTE']
sstlog_dict['BSPSQN'] = spbsta_dict['BSPSQN']
sstlog_dict['BCSTAT'] = spbsta_dict['BCSTAT']
sstlog_dict['BDWFLG'] = spbsta_dict['BDWFLG']
sstlog_dict['NOTE3'] = '冲销交易被冲正,回滚为冲销前状态'
if spbsta_dict.has_key('FEDT'): #前置日期
sstlog_dict['FEDT'] = spbsta_dict['FEDT']
if spbsta_dict.has_key('RBSQ'): #前置流水号
sstlog_dict['RBSQ'] = spbsta_dict['RBSQ']
if spbsta_dict.has_key('TRDT'): #主机日期
sstlog_dict['TRDT'] = spbsta_dict['TRDT']
if spbsta_dict.has_key('TLSQ'): #主机流水号
sstlog_dict['TLSQ'] = spbsta_dict['TLSQ']
sstlog_dict['MGID'] = spbsta_dict['MGID'] #主机返回码
sstlog_dict['STRINFO'] = spbsta_dict['STRINFO'] #主机返回信息
if not rccpsState.setTransState(sstlog_dict):
return AfaFlowControl.ExitThisFlow('S999','回滚状态为冲正前状态详细信息异常')
else:
AfaDBFunc.CommitSql()
AfaLoggerFunc.tradeInfo(">>>结束回滚原被冲销交易状态为冲销前状态")
#=====为返回冲销成功发送成功回执====
TradeContext.MSGTYPCO = 'SET010' #报文类代码
TradeContext.PRCCO = 'RCCI0000' #中心返回码
TradeContext.ORMFN = TradeContext.MSGFLGNO #参考报文标示号
TradeContext.SNDSTLBIN= TradeContext.RCVMBRCO #发送成员行号
TradeContext.RCVSTLBIN= TradeContext.SNDMBRCO #接收成员行号
TradeContext.STRINFO = '原冲销业务已冲正成功' #附言
return True
else:
AfaLoggerFunc.tradeDebug('>>>准备调用8813再次记账')
#=====记账前赋值操作====
AfaLoggerFunc.tradeDebug('>>>记账前赋值操作')
if rccpsGetFunc.GetRBSQ(PL_BRSFLG_RCV) == -1 :
return AfaFlowControl.ExitThisFlow('S999','重新生成前置流水号失败,抛弃报文')
TradeContext.BESBNO = wtr_dict['BESBNO'] #机构号
TradeContext.BETELR = wtr_dict['BETELR'] #柜员号
TradeContext.BEAUUS = wtr_dict['BEAUUS'] #授权柜员
TradeContext.BEAUPS = wtr_dict['BEAUPS'] #授权密码
TradeContext.TERMID = wtr_dict['TERMID'] #终端号
TradeContext.HostCode = '8813' #主机交易码
TradeContext.PYRACC = wtr_dict['PYRACC'] #付款人账户
TradeContext.PYRNAM = wtr_dict['PYRNAM'] #付款人名称
TradeContext.OCCAMT = str(wtr_dict['OCCAMT']) #金额
TradeContext.CUSCHRG = str(wtr_dict['CUSCHRG']) #手续费金额
TradeContext.BANKNO = wtr_dict['BNKBKNO'] #存折号码
if wtr_dict['TRCCO'] in ('3000002','3000004'):
#=====通存====
AfaLoggerFunc.tradeDebug('>>>通存')
TradeContext.RCCSMCD = PL_RCCSMCD_XJTCLZ #摘要代码 PL_RCCSMCD_XJTCLZ 通存来账
TradeContext.SBAC = TradeContext.BESBNO + PL_ACC_NXYDQSLZ #借方账户:农信银待清算来账
TradeContext.SBNM = "农信银待清算来账"
TradeContext.RBAC = wtr_dict['PYEACC'] #贷方账户:收款人账户
TradeContext.RBNM = wtr_dict['PYENAM'] #贷方户名:收款人户名
TradeContext.OCCAMT = str(wtr_dict['OCCAMT'])
#=====add by pgt 12-4====
TradeContext.CTFG = '7' #本金 手续费标识 7 本金 8手续费 9 本金＋手续费
TradeContext.PKFG = 'T' #通存通兑标识
TradeContext.SBAC = rccpsHostFunc.CrtAcc(TradeContext.SBAC, 25)
elif wtr_dict['TRCCO'] in ('3000102','3000104'):
#=====通兑====
AfaLoggerFunc.tradeDebug('>>>通兑')
if float(wtr_dict['CUSCHRG']) <= 0:
#=====对方现金收取手续费或不收费====
AfaLoggerFunc.tradeDebug('>>>现金收取手续费')
TradeContext.RCCSMCD = PL_RCCSMCD_XJTDLZ #主机摘要代码
TradeContext.SBAC = TradeContext.PYRACC #借方账户:付款人账户
TradeContext.ACNM = TradeContext.PYRNAM #借方户名 付款人户名
TradeContext.RBAC = TradeContext.BESBNO + PL_ACC_NXYDQSLZ #贷方账户:农信银待清算来账
TradeContext.RBAC = rccpsHostFunc.CrtAcc(TradeContext.RBAC, 25)
TradeContext.RBNM = '农信银待清算来账' #贷方户名
#=====add by pgt 12-4====
TradeContext.CTFG = '7' #本金 手续费标识 7 本金 8手续费 9 本金＋手续费
TradeContext.PKFG = 'T' #通存通兑标识
if wtr_dict['TRCCO'] == '3000104':
TradeContext.WARNTNO = '49' + TradeContext.BANKNO
else:
TradeContext.WARNTNO = TradeContext.SBAC[6:18]
else:
#=====对方转账收取手续费====
AfaLoggerFunc.tradeDebug('>>>转账收取手续费')
TradeContext.ACUR = '3' #记账次数
#=========交易金额============
TradeContext.RCCSMCD = PL_RCCSMCD_XJTDLZ #摘要代码
TradeContext.SBAC = TradeContext.PYRACC #借方账号
TradeContext.ACNM = TradeContext.PYRNAM #借方户名
TradeContext.RBAC = TradeContext.BESBNO + PL_ACC_NXYDJLS #贷方账号
TradeContext.RBAC = rccpsHostFunc.CrtAcc(TradeContext.RBAC,25)
TradeContext.OTNM = '待解临时款项' #贷方户名
TradeContext.CTFG = '7' #本金 手续费标识 7 本金 8手续费 9 本金＋手续费
TradeContext.PKFG = 'T' #通存通兑标识
AfaLoggerFunc.tradeInfo( '>>>交易金额:借方账号' + TradeContext.SBAC )
AfaLoggerFunc.tradeInfo( '>>>交易金额:贷方账号' + TradeContext.RBAC )
#=========结算手续费收入户===========
TradeContext.I2SMCD = PL_RCCSMCD_SXF #摘要代码
TradeContext.I2SBAC = TradeContext.PYRACC #借方账号
TradeContext.I2ACNM = TradeContext.PYRNAM #借方户名
TradeContext.I2RBAC = TradeContext.BESBNO + PL_ACC_NXYDJLS #贷方账号
TradeContext.I2RBAC = rccpsHostFunc.CrtAcc(TradeContext.I2RBAC,25)
TradeContext.I2OTNM = '待解临时款项' #贷方户名
TradeContext.I2TRAM = str(TradeContext.CUSCHRG) #发生额
TradeContext.I2CTFG = '8' #本金 手续费标识 7 本金 8手续费 9 本金＋手续费
TradeContext.I2PKFG = 'T' #通存通兑标识
AfaLoggerFunc.tradeInfo( '>>>结算手续费收入户:借方账号' + TradeContext.I2SBAC )
AfaLoggerFunc.tradeInfo( '>>>结算手续费收入户:贷方账号' + TradeContext.I2RBAC )
#=========交易金额+手续费===================
TradeContext.I3SMCD = PL_RCCSMCD_XJTDLZ #摘要代码
TradeContext.I3SBAC = TradeContext.BESBNO + PL_ACC_NXYDJLS #借方账号
TradeContext.I3SBAC = rccpsHostFunc.CrtAcc(TradeContext.I3SBAC,25)
TradeContext.I3ACNM = '待解临时款项' #借方户名
TradeContext.I3RBAC = TradeContext.BESBNO + PL_ACC_NXYDQSLZ #贷方账号
TradeContext.I3RBAC = rccpsHostFunc.CrtAcc(TradeContext.I3RBAC,25)
TradeContext.I3OTNM = '农信银来账' #贷方户名
TradeContext.I3TRAM = rccpsUtilTools.AddDot(TradeContext.OCCAMT,TradeContext.CUSCHRG) #发生额
TradeContext.I3CTFG = '9' #本金 手续费标识 7 本金 8手续费 9 本金＋手续费
TradeContext.I3PKFG = 'T' #通存通兑标识
#=====凭证号码====
if wtr_dict['TRCCO'] == '3000102':
#=====卡====
TradeContext.WARNTNO = TradeContext.SBAC[6:18]
TradeContext.I2WARNTNO = TradeContext.I2SBAC[6:18]
else:
#=====折====
TradeContext.WARNTNO = '49' + TradeContext.BANKNO
TradeContext.I2WARNTNO = '49' + TradeContext.BANKNO
elif wtr_dict['TRCCO'] in ('3000003','3000005'):
#=====本转异====
AfaLoggerFunc.tradeDebug('>>>本转异')
TradeContext.RCCSMCD = PL_RCCSMCD_XJTCLZ #摘要代码 PL_RCCSMCD_XJTCLZ 通存来账
TradeContext.SBAC = TradeContext.BESBNO + PL_ACC_NXYDQSLZ #借方账户:农信银待清算来账
TradeContext.SBNM = "农信银待清算来账"
TradeContext.RBAC = wtr_dict['PYEACC'] #贷方账户:收款人账户
TradeContext.RBNM = wtr_dict['PYENAM'] #贷方户名:收款人户名
TradeContext.OCCAMT = str(wtr_dict['OCCAMT'])
#=====add by pgt 12-4====
TradeContext.CTFG = '7' #本金 手续费标识 7 本金 8手续费 9 本金＋手续费
TradeContext.PKFG = 'T' #通存通兑标识
TradeContext.SBAC = rccpsHostFunc.CrtAcc(TradeContext.SBAC, 25)
elif wtr_dict['TRCCO'] in ('3000103','3000105'):
#=====异转本====
AfaLoggerFunc.tradeDebug('>>>异转本')
if( float(TradeContext.CUSCHRG) <= 0 ):
#=====现金====
AfaLoggerFunc.tradeDebug('>>>现金收取手续费')
TradeContext.RCCSMCD = PL_RCCSMCD_YZBWZ#主机摘要代码
TradeContext.SBAC = TradeContext.PYRACC #借方账户:付款人账户
TradeContext.ACNM = TradeContext.PYRNAM #借方户名 付款人户名
TradeContext.RBAC = TradeContext.BESBNO + PL_ACC_NXYDQSLZ #贷方账户:农信银待清算来账
TradeContext.RBAC = rccpsHostFunc.CrtAcc(TradeContext.RBAC, 25)
TradeContext.RBNM = '农信银待清算来账' #贷方户名:
TradeContext.CTFG = '7' #本金 手续费标识 7 本金 8手续费 9 本金＋手续费
TradeContext.PKFG = 'T' #通存通兑标识
if wtr_dict['TRCCO'] == '3000103':
TradeContext.WARNTNO = TradeContext.SBAC[6:18]
else:
TradeContext.WARNTNO = '49' + TradeContext.BANKNO
AfaLoggerFunc.tradeDebug( '>>>借方账号:' + TradeContext.SBAC )
AfaLoggerFunc.tradeDebug( '>>>贷方账号:' + TradeContext.RBAC )
AfaLoggerFunc.tradeDebug( '>>>凭证号码:' + TradeContext.WARNTNO )
else:
#=====转账=====
AfaLoggerFunc.tradeDebug('>>>转账收取手续费')
TradeContext.ACUR = '3' #记账次数
#=========交易金额============
TradeContext.RCCSMCD = PL_RCCSMCD_YZBWZ #摘要代码
TradeContext.SBAC = TradeContext.PYRACC #借方账号
TradeContext.ACNM = TradeContext.PYRNAM #借方户名
TradeContext.RBAC = TradeContext.BESBNO + PL_ACC_NXYDJLS #贷方账号
TradeContext.RBAC = rccpsHostFunc.CrtAcc(TradeContext.RBAC,25)
TradeContext.OTNM = '待解临时款项' #贷方户名
TradeContext.OCCAMT = str(TradeContext.OCCAMT) #发生额
TradeContext.CTFG = '7' #本金 手续费标识 7 本金 8手续费 9 本金＋手续费
TradeContext.PKFG = 'T' #通存通兑标识
AfaLoggerFunc.tradeDebug( '>>>交易金额:借方账号' + TradeContext.SBAC )
AfaLoggerFunc.tradeDebug( '>>>交易金额:贷方账号' + TradeContext.RBAC )
#=========结算手续费收入户===========
TradeContext.I2SMCD = PL_RCCSMCD_SXF #摘要代码
TradeContext.I2SBAC = TradeContext.PYRACC #借方账号
TradeContext.I2ACNM = TradeContext.PYRNAM #借方户名
TradeContext.I2RBAC = TradeContext.BESBNO + PL_ACC_NXYDJLS #贷方账号
TradeContext.I2RBAC = rccpsHostFunc.CrtAcc(TradeContext.I2RBAC,25)
TradeContext.I2OTNM = '待解临时款项' #贷方户名
TradeContext.I2TRAM = str(TradeContext.CUSCHRG) #发生额
TradeContext.I2CTFG = '8' #本金 手续费标识 7 本金 8手续费 9 本金＋手续费
TradeContext.I2PKFG = 'T' #通存通兑标识
AfaLoggerFunc.tradeDebug( '>>>结算手续费收入户:借方账号' + TradeContext.I2SBAC )
AfaLoggerFunc.tradeDebug( '>>>结算手续费收入户:贷方账号' + TradeContext.I2RBAC )
#=========交易金额+手续费===================
TradeContext.I3SMCD = PL_RCCSMCD_YZBWZ #摘要代码
TradeContext.I3SBAC = TradeContext.BESBNO + PL_ACC_NXYDJLS #借方账号
TradeContext.I3SBAC = rccpsHostFunc.CrtAcc(TradeContext.I3SBAC,25)
TradeContext.I3ACNM = '待解临时款项' #借方户名
TradeContext.I3RBAC = TradeContext.BESBNO + PL_ACC_NXYDQSLZ #贷方账号
TradeContext.I3RBAC = rccpsHostFunc.CrtAcc(TradeContext.I3RBAC,25)
TradeContext.I3OTNM = '农信银来账' #贷方户名
TradeContext.I3TRAM = rccpsUtilTools.AddDot(TradeContext.OCCAMT,TradeContext.CUSCHRG) #发生额
TradeContext.I3CTFG = '9' #本金 手续费标识 7 本金 8手续费 9 本金＋手续费
TradeContext.I3PKFG = 'T' #通存通兑标识
AfaLoggerFunc.tradeDebug( '>>>交易金额+手续费:借方账号' + TradeContext.I3SBAC )
AfaLoggerFunc.tradeDebug( '>>>交易金额+手续费:贷方账号' + TradeContext.I3RBAC )
if wtr_dict['TRCCO'] == '3000103':
TradeContext.WARNTNO = TradeContext.SBAC[6:18]
TradeContext.I2WARNTNO = TradeContext.I2SBAC[6:18]
else:
TradeContext.WARNTNO = '49' + TradeContext.BANKNO
TradeContext.I2WARNTNO = '49' + TradeContext.BANKNO
else:
AfaLoggerFunc.tradeInfo('>>>原交易码错误')
return AfaFlowControl.ExitThisFlow('S999','抛弃报文')
#=====新增状态====
if wtr_dict['TRCCO'] in ('3000002','3000004','3000003','3000005'):
#=====通存 本转异 状态为:自动入账====
TradeContext.BCSTAT = PL_BCSTAT_AUTO
else:
#=====通兑 异转本 状态为:自动扣款====
TradeContext.BCSTAT = PL_BCSTAT_AUTOPAY
#=====开始设置状态====
#if not rccpsState.newTransState(TradeContext.BJEDTE,TradeContext.BSPSQN,TradeContext.BCSTAT,PL_BDWFLG_WAIT):
if not rccpsState.newTransState(wtr_dict['BJEDTE'],wtr_dict['BSPSQN'],TradeContext.BCSTAT,PL_BDWFLG_WAIT):
AfaDBFunc.RollbackSql()
return AfaFlowControl.ExitThisFlow('S999','设置业务状态为自动入账/扣款-处理中异常')
else:
AfaDBFunc.CommitSql()
#=====开始与主机进行通讯====
AfaLoggerFunc.tradeInfo('>>>准备开始与主机通讯')
rccpsHostFunc.CommHost( TradeContext.HostCode )
#=====分析主机返回====
AfaLoggerFunc.tradeInfo('>>>分析主机返回')
sstlog = {}
sstlog['BJEDTE'] = wtr_dict['BJEDTE']
sstlog['BSPSQN'] = wtr_dict['BSPSQN']
sstlog['BCSTAT'] = TradeContext.BCSTAT
sstlog['MGID'] = TradeContext.errorCode
if TradeContext.errorCode == '0000':
sstlog['TRDT'] = TradeContext.TRDT #主机日期
sstlog['TLSQ'] = TradeContext.TLSQ #主机流水
sstlog['BDWFLG']= PL_BDWFLG_SUCC
sstlog['STRINFO'] = '冲销交易被冲正,补记账务成功' #附言
else:
sstlog['BDWFLG']= PL_BDWFLG_FAIL
sstlog['STRINFO'] = TradeContext.errorMsg #附言
#=====设置状态====
if not rccpsState.setTransState(sstlog):
AfaDBFunc.RollbackSql()
return AfaFlowControl.ExitThisFlow('S999', "设置业务状态异常")
else:
AfaDBFunc.CommitSql()
#=====主机成功后返回正确回执报文====
AfaLoggerFunc.tradeInfo('>>>发送成功回执')
TradeContext.MSGTYPCO = 'SET010' #报文类代码
TradeContext.PRCCO = 'RCCI0000' #中心返回码
TradeContext.ORMFN = TradeContext.MSGFLGNO #参考报文标示号
TradeContext.SNDSTLBIN= TradeContext.RCVMBRCO #发送成员行号
TradeContext.RCVSTLBIN= TradeContext.SNDMBRCO #接收成员行号
TradeContext.STRINFO = '成功' #附言
return True
elif TradeContext.ORTRCCO == '3000505':
#=====3000505 补正业务====
AfaLoggerFunc.tradeDebug('>>>查找原补正业务是否存在')
#关彬捷 20081230 若原业务为补正,直接回复冲正成功应答
AfaLoggerFunc.tradeInfo('>>>发送成功回执')
TradeContext.MSGTYPCO = 'SET010' #报文类代码
TradeContext.PRCCO = 'RCCI0000' #中心返回码
TradeContext.ORMFN = TradeContext.MSGFLGNO #参考报文标示号
TradeContext.SNDSTLBIN= TradeContext.RCVMBRCO #发送成员行号
TradeContext.RCVSTLBIN= TradeContext.SNDMBRCO #接收成员行号
TradeContext.STRINFO = '成功' #附言
return True
else:
#=====冲正原来账/往账正常业务====
#=====查找原交易是否存在====
AfaLoggerFunc.tradeDebug(">>>查找原交易是否存在")
where_dict = {'MSGFLGNO':TradeContext.ORMFN}
wtrbka_dict = rccpsDBTrcc_wtrbka.selectu(where_dict)
if( wtrbka_dict == -1 ):
AfaLoggerFunc.tradeInfo(">>>查找原交易失败,原业务中心流水号["+str(TradeContext.ORTRCNO)+"]")
return AfaFlowControl.ExitThisFlow('A099',"查找原交易失败,抛弃报文,等待中心自动冲正")
if( len(wtrbka_dict) == 0 ):
#=====未查找到原交易====
AfaLoggerFunc.tradeDebug(">>>查找原交易失败,未收到原交易,直接回复成功报文")
#=====为返回冲销成功发送成功回执====
TradeContext.MSGTYPCO = 'SET010' #报文类代码
TradeContext.PRCCO = 'RCCI0000' #中心返回码
TradeContext.ORMFN = TradeContext.MSGFLGNO #参考报文标示号
TradeContext.SNDSTLBIN= TradeContext.RCVMBRCO #发送成员行号
TradeContext.RCVSTLBIN= TradeContext.SNDMBRCO #接收成员行号
TradeContext.STRINFO = '成功' #附言
return True
else:
#=====查找原交易成功====
AfaLoggerFunc.tradeInfo(">>>查找原交易成功")
#=====将原报单序号 原交易日期更新到冲销登记簿中====
AfaLoggerFunc.tradeInfo('>>>更新原报单序号\原交易日期')
atcbka_where={}
atcbka_where['BSPSQN'] = TradeContext.BSPSQN #报单序号
atcbka_where['BJEDTE'] = TradeContext.BJEDTE #交易日期
atcbka_dict ={}
atcbka_dict['BOJEDT'] = wtrbka_dict['BJEDTE'] #原交易日期
atcbka_dict['BOSPSQ'] = wtrbka_dict['BSPSQN'] #原报单序号
#关彬捷 20081225 更新冲正登记簿中登记机构号为原交易机构号
atcbka_dict['BESBNO'] = wtrbka_dict['BESBNO'] #原机构号
atcbka_dict['STRINFO'] = TradeContext.STRINFO #附言
atcbka_dict['ORTRCDAT']= wtrbka_dict['TRCDAT'] #原委托日期
atcbka_dict['OPRNO'] = PL_TDOPRNO_CZ #业务类型
ret = rccpsDBTrcc_atcbka.update(atcbka_dict,atcbka_where)
if ret <= 0:
AfaDBFunc.RollbackSql( )
return AfaFlowControl.ExitThisFlow('S999', "更新自动冲正登记簿原报单序号和原交易日期异常,抛弃报文")
else:
AfaDBFunc.CommitSql( )
AfaLoggerFunc.tradeInfo(">>>结束更新冲销登记簿原交易日期和原报单序号")
#=====查找原来账业务状态====
AfaLoggerFunc.tradeInfo(">>>查找原业务状态")
spbsta_where = {'BJEDTE':wtrbka_dict['BJEDTE'],'BSPSQN':wtrbka_dict['BSPSQN']}
spbsta_dict = rccpsDBTrcc_spbsta.selectu(spbsta_where)
if( spbsta_dict == None ):
AfaLoggerFunc.tradeDebug(">>>查找原业务状态失败,发送中心失败报文")
#=====为返回冲销成功发送拒绝回执====
TradeContext.MSGTYPCO = 'SET010' #报文类代码
TradeContext.PRCCO = 'RCCO1006' #中心返回码
TradeContext.ORMFN = TradeContext.MSGFLGNO #参考报文标示号
TradeContext.SNDSTLBIN= TradeContext.RCVMBRCO #发送成员行号
TradeContext.RCVSTLBIN= TradeContext.SNDMBRCO #接收成员行号
TradeContext.STRINFO = '开户行处理失败' #附言
return True
#关彬捷 20081226 新增查询交易当前状态详细信息
#查询交易当前状态详细信息
sstlog_where = {'BJEDTE':wtrbka_dict['BJEDTE'],'BSPSQN':wtrbka_dict['BSPSQN'],'BCURSQ':spbsta_dict['BCURSQ']}
spbsta_dict = rccpsDBTrcc_sstlog.selectu(sstlog_where)
if( spbsta_dict == None ):
AfaLoggerFunc.tradeDebug(">>>查找原业务状态失败,发送中心失败报文")
#=====为返回冲销成功发送拒绝回执====
TradeContext.MSGTYPCO = 'SET010' #报文类代码
TradeContext.PRCCO = 'RCCO1006' #中心返回码
TradeContext.ORMFN = TradeContext.MSGFLGNO #参考报文标示号
TradeContext.SNDSTLBIN= TradeContext.RCVMBRCO #发送成员行号
TradeContext.RCVSTLBIN= TradeContext.SNDMBRCO #接收成员行号
TradeContext.STRINFO = '开户行处理失败' #附言
return True
#关彬捷 20081226 新增若交易当前状态为自动扣款,自动入账,冲销,冲正处理中状态,退出,等待下个冲正报文
if (spbsta_dict['BCSTAT'] == PL_BCSTAT_AUTO or spbsta_dict['BCSTAT'] == PL_BCSTAT_AUTOPAY or spbsta_dict['BCSTAT'] == PL_BCSTAT_CANC or spbsta_dict['BCSTAT'] == PL_BCSTAT_CANCEL) and spbsta_dict['BDWFLG'] == PL_BDWFLG_WAIT:
return AfaFlowControl.ExitThisFlow('S999','原业务账务状态未知,抛弃报文,等待中心再次发起自动冲正')
#关彬捷 20081226 新增若交易当前状态为自动扣款,自动入账,冲销,冲正失败状态,则调用8816查询账务状态
if (spbsta_dict['BCSTAT'] == PL_BCSTAT_AUTO or spbsta_dict['BCSTAT'] == PL_BCSTAT_AUTOPAY or spbsta_dict['BCSTAT'] == PL_BCSTAT_CANC or spbsta_dict['BCSTAT'] == PL_BCSTAT_CANCEL) and spbsta_dict['BDWFLG'] == PL_BDWFLG_FAIL:
AfaLoggerFunc.tradeDebug('>>>调用8816查找该业务[' + wtrbka_dict['BSPSQN'] + ']状态')
TradeContext.HostCode = '8816' #主机交易码
TradeContext.OPFG = '1' #查询类型
TradeContext.NBBH = 'RCC' #代理业务标识
TradeContext.FEDT = spbsta_dict['FEDT'] #原前置日期
TradeContext.RBSQ = spbsta_dict['RBSQ'] #原前置流水号
TradeContext.DAFG = '1' #抹/记账标志 1:记 2:抹
TradeContext.BESBNO = spbsta_dict['BESBNO'] #机构号
TradeContext.BETELR = spbsta_dict['BETELR'] #柜员号
rccpsHostFunc.CommHost( TradeContext.HostCode )
#=====分析主机返回====
if TradeContext.errorCode == '0000':
#此账务已成功记主机账,修改原交易状态为记账成功
AfaLoggerFunc.tradeInfo("此账务已成功记主机账,修改原交易状态为记账成功")
stat_dict = {}
stat_dict['BJEDTE'] = spbsta_dict['BJEDTE']
stat_dict['BSPSQN'] = spbsta_dict['BSPSQN']
stat_dict['BCSTAT'] = spbsta_dict['BCSTAT']
stat_dict['BDWFLG'] = PL_BDWFLG_SUCC
stat_dict['TRDT'] = HostContext.O1DADT #主机日期
stat_dict['TLSQ'] = HostContext.O1AMTL #主机流水
stat_dict['MGID'] = '0000'
stat_dict['STRINFO']= '主机成功'
if not rccpsState.setTransState(stat_dict):
return AfaFlowControl.ExitThisFlow('S999','设置原交易业务状态为记账成功异常')
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
return AfaFlowControl.ExitThisFlow("S999","Commit异常")
#更新查询出交易状态
spbsta_dict['BDWFLG'] = PL_BDWFLG_SUCC
spbsta_dict['TRDT'] = HostContext.O1DADT
spbsta_dict['TLSQ'] = HostContext.O1AMTL
elif TradeContext.errorCode == 'XCR0001':
AfaLoggerFunc.tradeInfo(">>>主机返回原交易记账失败,继续冲正")
else:
AfaLoggerFunc.tradeInfo(">>>查询原交易账务状态异常,返回拒绝应答,等待下次冲正报文")
#=====为返回冲正拒绝回执赋值====
TradeContext.MSGTYPCO = 'SET010' #报文类代码
TradeContext.PRCCO = 'RCCO1006' #中心返回码
TradeContext.STRINFO = '原交易账务状态未知' #附言
TradeContext.ORMFN = TradeContext.MSGFLGNO #参考报文标示号
TradeContext.SNDSTLBIN= TradeContext.RCVMBRCO #发送成员行号
TradeContext.RCVSTLBIN= TradeContext.SNDMBRCO #接收成员行号
return True
#=====根据来往帐标识进行冲正状态判断====
if( wtrbka_dict['BRSFLG'] == PL_BRSFLG_RCV ):
#=====来账业务====
AfaLoggerFunc.tradeDebug(">>>来账业务")
#=====PL_BCSTAT_AUTOPAY 自动扣款====
#=====PL_BCSTAT_CONFPAY 确认付款====
#=====PL_BCSTAT_CONFACC 确认入账====
#=====PL_BCSTAT_MFERFE 拒绝====
#=====PL_BCSTAT_CANC 柜台冲销====
#=====PL_BCSTAT_CANCEL 自动冲正====
if( ((spbsta_dict['BCSTAT']==PL_BCSTAT_AUTO or spbsta_dict['BCSTAT']==PL_BCSTAT_AUTOPAY) and spbsta_dict['BDWFLG']==PL_BDWFLG_FAIL) \
or (spbsta_dict['BCSTAT'] == PL_BCSTAT_MFERFE and spbsta_dict['BDWFLG'] == PL_BDWFLG_SUCC) \
or (spbsta_dict['BCSTAT'] == PL_BCSTAT_CANC and spbsta_dict['BDWFLG'] == PL_BDWFLG_SUCC) \
or (spbsta_dict['BCSTAT'] == PL_BCSTAT_CANCEL and spbsta_dict['BDWFLG'] == PL_BDWFLG_SUCC) \
or (spbsta_dict['BCSTAT'] == PL_BCSTAT_CONFPAY and spbsta_dict['BDWFLG'] == PL_BDWFLG_SUCC) \
or (spbsta_dict['BCSTAT'] == PL_BCSTAT_CONFACC and spbsta_dict['BDWFLG'] == PL_BDWFLG_SUCC)):
#=====不允许冲正====
AfaLoggerFunc.tradeDebug(">>>原业务["+str(spbsta_dict['BSPSQN'])+"]记账失败或被拒绝或冲销或自动冲正或存款确认,无需再抹账,发送成功报文")
if spbsta_dict['BCSTAT'] not in (PL_BCSTAT_MFERFE,PL_BCSTAT_CANC,PL_BCSTAT_CANCEL):
AfaLoggerFunc.tradeDebug('>>>新增原业务状态为自动冲正-成功')
if not rccpsState.newTransState(spbsta_dict['BJEDTE'],spbsta_dict['BSPSQN'],PL_BCSTAT_CANCEL,PL_BDWFLG_SUCC):
AfaDBFunc.RollbackSql()
return AfaFlowControl.ExitThisFlow('S999','设置业务状态为自动冲正-成功异常')
else:
AfaDBFunc.CommitSql( )
else:
AfaLoggerFunc.tradeDebug('>>>原业务状态为[拒绝/冲销/冲正],不需要新增状态')
#=====原交易无需抹账,返回冲正成功应答====
TradeContext.MSGTYPCO = 'SET010' #报文类代码
TradeContext.PRCCO = 'RCCI0000' #中心返回码
TradeContext.ORMFN = TradeContext.MSGFLGNO #参考报文标示号
TradeContext.SNDSTLBIN= TradeContext.RCVMBRCO #发送成员行号
TradeContext.RCVSTLBIN= TradeContext.SNDMBRCO #接收成员行号
TradeContext.STRINFO = '原业务冲正成功' #附言
return True
else:
#=====新增原业务状态为冲正-处理中====
AfaLoggerFunc.tradeDebug('>>>新增原业务状态为自动冲正-处理中')
#=====直接调用8820冲正原业务====
TradeContext.BOSPSQ = spbsta_dict['BSPSQN'] #原报单序号
TradeContext.BOJEDT = spbsta_dict['BJEDTE'] #原交易日期
TradeContext.HostCode = '8820' #主机交易码
if not rccpsState.newTransState(spbsta_dict['BJEDTE'],spbsta_dict['BSPSQN'],PL_BCSTAT_CANCEL,PL_BDWFLG_WAIT):
AfaDBFunc.RollbackSql()
return AfaFlowControl.ExitThisFlow('S999','设置业务状态为自动冲正处理中异常')
else:
AfaDBFunc.CommitSql( )
#=====向主机发起8820抹账处理====
AfaLoggerFunc.tradeDebug('>>>向主机发起8820抹账处理')
rccpsHostFunc.CommHost( TradeContext.HostCode )
#=====判断主机返回====
sstlog_dict={}
sstlog_dict['BJEDTE'] = spbsta_dict['BJEDTE']
sstlog_dict['BSPSQN'] = spbsta_dict['BSPSQN']
sstlog_dict['BCSTAT'] = PL_BCSTAT_CANCEL #冲正
sstlog_dict['MGID'] = TradeContext.errorCode #主机返回码
if TradeContext.existVariable('BOJEDT'): #前置日期
sstlog_dict['FEDT'] = TradeContext.BOJEDT
if TradeContext.existVariable('BOSPSQ'): #前置流水号
sstlog_dict['RBSQ'] = TradeContext.BOSPSQ
if TradeContext.existVariable('TRDT'): #主机日期
sstlog_dict['TRDT'] = TradeContext.TRDT
if TradeContext.existVariable('TLSQ'): #主机流水号
sstlog_dict['TLSQ'] = TradeContext.TLSQ
#关彬捷 20090219 增加冲销成功的主机错误码判断:SXR0010(此笔交易已被冲正)
if TradeContext.errorCode in ('0000','SXR0010'):
#=====更改状态====
sstlog_dict['BDWFLG'] = PL_BDWFLG_SUCC #流转标识 PL_BDWFLG_SUCC 成功
sstlog_dict['STRINFO'] = '来账冲正成功' #附言
TradeContext.PRCCO = 'RCCI0000'
TradeContext.STRINFO = '原业务冲正成功'
else:
sstlog_dict['BDWFLG'] = PL_BDWFLG_FAIL #流转标识 PL_BDWFLG_FAIL 失败
sstlog_dict['STRINFO'] = TradeContext.errorMsg #附言
TradeContext.PRCCO = 'NN1IA999'
TradeContext.STRINFO = '原业务冲正失败 ' + TradeContext.errorMsg
#=====修改原业务状态====
AfaLoggerFunc.tradeDebug('>>>修改原业务状态')
res = rccpsState.setTransState(sstlog_dict)
if( res == False ):
AfaDBFunc.RollbackSql()
return AfaFlowControl.ExitThisFlow('A099', '更改被冲正的交易状态失败')
else:
AfaDBFunc.CommitSql( )
#关彬捷 20081226 修改如果冲正失败则回滚冲正前状态
if TradeContext.errorCode not in ('0000','SXR0010'):
#冲正失败,回滚状态为冲正前状态
if not rccpsState.newTransState(spbsta_dict['BJEDTE'],spbsta_dict['BSPSQN'],spbsta_dict['BCSTAT'],spbsta_dict['BDWFLG']):
AfaDBFunc.RollBackSql()
return AfaFlowControl.ExitThisFlow('S999','回滚状态为冲正前状态异常')
else:
AfaDBFunc.CommitSql()
sstlog_dict = {}
sstlog_dict['BJEDTE'] = spbsta_dict['BJEDTE']
sstlog_dict['BSPSQN'] = spbsta_dict['BSPSQN']
sstlog_dict['BCSTAT'] = spbsta_dict['BCSTAT']
sstlog_dict['BDWFLG'] = spbsta_dict['BDWFLG']
sstlog_dict['NOTE3'] = '原业务冲正失败,回滚为冲正前状态'
if spbsta_dict.has_key('FEDT'): #前置日期
sstlog_dict['FEDT'] = spbsta_dict['FEDT']
if spbsta_dict.has_key('RBSQ'): #前置流水号
sstlog_dict['RBSQ'] = spbsta_dict['RBSQ']
if spbsta_dict.has_key('TRDT'): #主机日期
sstlog_dict['TRDT'] = spbsta_dict['TRDT']
if spbsta_dict.has_key('TLSQ'): #主机流水号
sstlog_dict['TLSQ'] = spbsta_dict['TLSQ']
sstlog_dict['MGID'] = spbsta_dict['MGID'] #主机返回码
sstlog_dict['STRINFO'] = spbsta_dict['STRINFO'] #主机返回信息
if not rccpsState.setTransState(sstlog_dict):
return AfaFlowControl.ExitThisFlow('S999','回滚状态为冲正前状态详细信息异常')
else:
AfaDBFunc.CommitSql()
#=====发送回执====
AfaLoggerFunc.tradeDebug('>>>发送成功回执到对方行')
#=====为返回冲销成功发送成功回执====
TradeContext.MSGTYPCO = 'SET010' #报文类代码
#TradeContext.PRCCO = 'RCCI0000' #中心返回码
#TradeContext.STRINFO = '原业务冲正成功' #附言
TradeContext.ORMFN = TradeContext.MSGFLGNO #参考报文标示号
TradeContext.SNDSTLBIN= TradeContext.RCVMBRCO #发送成员行号
TradeContext.RCVSTLBIN= TradeContext.SNDMBRCO #接收成员行号
return True
else:
#=====往帐业务====
AfaLoggerFunc.tradeDebug(">>>往帐业务")
#=====发送回执====
AfaLoggerFunc.tradeDebug('>>>发送拒绝回执到对方行')
#=====为返回冲销成功发送成功回执====
TradeContext.MSGTYPCO = 'SET010' #报文类代码
TradeContext.PRCCO = 'RCCO1006' #中心返回码
TradeContext.STRINFO = '往帐业务只能由受理方冲正' #附言
TradeContext.ORMFN = TradeContext.MSGFLGNO #参考报文标示号
TradeContext.SNDSTLBIN= TradeContext.RCVMBRCO #发送成员行号
TradeContext.RCVSTLBIN= TradeContext.SNDMBRCO #接收成员行号
AfaLoggerFunc.tradeInfo("农信银系统：来账.中心类操作(1.本地操作).柜台冲正来账接收[TRCC006_1144]进入")
return True
def SubModuleDoFst():
AfaLoggerFunc.tradeInfo( '***农信银系统：往账.回执类操作(1.本地操作).业务回执报文接收[TRCC006_1110]进入***' )
#=================初始化返回信息============================================
if AfaUtilTools.trim(TradeContext.STRINFO) == "":
TradeContext.STRINFO = rccpsDBFunc.getErrInfo(TradeContext.PRCCO)
AfaLoggerFunc.tradeDebug("TradeContext.STRINFO=" + TradeContext.STRINFO)
#==========检查业务类型==========
if TradeContext.ROPRTPNO == "20":
#==========实时汇兑业务=============================================
AfaLoggerFunc.tradeInfo(">>>原业务类型为20,汇兑业务")
#==========根据发送行号,委托日期,交易流水号查询原交易信息===========
AfaLoggerFunc.tradeInfo(">>>开始根据发送行号,委托日期,交易流水号查询交易信息")
ORSNDMBRCO = TradeContext.ORMFN[:10]
ORTRCDAT = TradeContext.ORMFN[10:18]
ORTRCNO = TradeContext.ORMFN[18:]
trc_dict = {}
if not rccpsDBFunc.getTransTrcPK(ORSNDMBRCO,ORTRCDAT,ORTRCNO,trc_dict):
return False
AfaLoggerFunc.tradeInfo(">>>结束根据发送行号,委托日期,交易流水号查询交易信息")
#==========检查原业务是否MFE收妥===================================
tmp_stat_dict = {}
if not rccpsState.getTransStateSet(trc_dict['BJEDTE'],trc_dict['BSPSQN'],PL_BCSTAT_MFERCV,PL_BDWFLG_SUCC,tmp_stat_dict):
return AfaFlowControl.ExitThisFlow("S999","原汇兑业务MFE尚未收妥,停止处理")
#==========根据中心返回码设置原交易状态============================
AfaLoggerFunc.tradeInfo(">>>中心处理码为[" + TradeContext.PRCCO + "]")
stat_dict = {}
stat_dict['BJEDTE'] = trc_dict['BJEDTE']
stat_dict['BSPSQN'] = trc_dict['BSPSQN']
stat_dict['BESBNO'] = trc_dict['BESBNO']
stat_dict['BETELR'] = TradeContext.BETELR
stat_dict['PRCCO'] = TradeContext.PRCCO
#stat_dict['STRINFO']= TradeContext.STRINFO
if TradeContext.PRCCO == "RCCI0000":
return AfaFlowControl.ExitThisFlow("S999","业务回执报文中心处理码不应为RCCI0000")
elif TradeContext.PRCCO == "RCCO1078" or TradeContext.PRCCO == "RCCO1079":
#==========中心返回表示排队的处理码,开始设置状态为排队=====
AfaLoggerFunc.tradeInfo(">>>开始设置状态为排队")
if not rccpsState.newTransState(trc_dict['BJEDTE'],trc_dict['BSPSQN'],PL_BCSTAT_MFEQUE,PL_BDWFLG_WAIT):
return False
if not AfaDBFunc.CommitSql( ):
return AfaFlowControl.ExitThisFlow("S999","Commit异常")
AfaLoggerFunc.tradeInfo(">>>Commit成功")
stat_dict['BCSTAT'] = PL_BCSTAT_MFEQUE
stat_dict['BDWFLG'] = PL_BDWFLG_SUCC
if not rccpsState.setTransState(stat_dict):
return False
AfaLoggerFunc.tradeInfo(">>>结束设置状态为排队")
else:
#==========中心返回表示拒绝的处理码,开始设置状态为拒绝=====
AfaLoggerFunc.tradeInfo(">>>开始设置状态为拒绝")
if not rccpsState.newTransState(trc_dict['BJEDTE'],trc_dict['BSPSQN'],PL_BCSTAT_MFERFE,PL_BDWFLG_WAIT):
return False
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
return AfaFlowControl.ExitThisFlow("S999","Commit异常")
AfaLoggerFunc.tradeInfo(">>>Commit成功")
stat_dict['BCSTAT'] = PL_BCSTAT_MFERFE
stat_dict['BDWFLG'] = PL_BDWFLG_SUCC
if not rccpsState.setTransState(stat_dict):
return False
AfaLoggerFunc.tradeInfo(">>>结束设置状态为拒绝")
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
return AfaFlowControl.ExitThisFlow("S999","Commit异常")
AfaLoggerFunc.tradeInfo(">>>Commit成功")
#==========设置当前机构为原机构============================
TradeContext.BESBNO = trc_dict['BESBNO']
TradeContext.BETELR = trc_dict['BETELR']
TradeContext.TERMID = trc_dict['TERMID']
#==========设置原交易状态为抹账处理中======================
AfaLoggerFunc.tradeInfo(">>>开始设置状态为抹账处理中")
TradeContext.NOTE3 = "中心拒绝,行内自动抹账"
if not rccpsState.newTransState(trc_dict['BJEDTE'],trc_dict['BSPSQN'],PL_BCSTAT_HCAC,PL_BDWFLG_WAIT):
return False
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
return AfaFlowControl.ExitThisFlow("S999","Commit异常")
AfaLoggerFunc.tradeInfo(">>>Commit成功")
AfaLoggerFunc.tradeInfo(">>>结束设置状态为抹账处理中")
#==========发起主机抹账====================================
AfaLoggerFunc.tradeInfo(">>>开始主机抹账")
##====== 张恒 抹账操作 增加于20091112 ==============##
#汇兑往帐抹帐字典赋值
input_dict = {}
input_dict['BJEDTE'] = trc_dict['BJEDTE']
input_dict['BSPSQN'] = trc_dict['BSPSQN']
if len(trc_dict['PYRACC']) != 0 :
input_dict['PYRACC'] = trc_dict['PYRACC']
else:
input_dict['PYRACC'] = ''
input_dict['OCCAMT'] = str(trc_dict['OCCAMT'])
input_dict['BBSSRC'] = trc_dict['BBSSRC']
input_dict['BESBNO'] = TradeContext.BESBNO
#调用汇兑往帐抹帐
rccpsEntries.HDWZMZ(input_dict)
#=====设置记账函数接口====
rccpsHostFunc.CommHost( TradeContext.HostCode )
AfaLoggerFunc.tradeInfo(">>>结束主机抹账")
stat_dict['PRCCO'] = ''
if TradeContext.errorCode == '0000':
#==========设置原交易状态为抹账成功============================
AfaLoggerFunc.tradeInfo(">>>开始设置状态为抹账成功")
stat_dict['BCSTAT'] = PL_BCSTAT_HCAC
stat_dict['BDWFLG'] = PL_BDWFLG_SUCC
if TradeContext.existVariable('TRDT'):
AfaLoggerFunc.tradeInfo("TRDT:" + TradeContext.TRDT)
stat_dict['TRDT'] = TradeContext.TRDT
if TradeContext.existVariable('TLSQ'):
AfaLoggerFunc.tradeInfo("TLSQ:" + TradeContext.TLSQ)
stat_dict['TLSQ'] = TradeContext.TLSQ
if TradeContext.existVariable('DASQ'):
AfaLoggerFunc.tradeInfo("DASQ:" + TradeContext.DASQ)
stat_dict['DASQ'] = TradeContext.DASQ
stat_dict['MGID'] = TradeContext.errorCode
stat_dict['STRINFO']= TradeContext.errorMsg
if not rccpsState.setTransState(stat_dict):
return False
AfaLoggerFunc.tradeInfo(">>>结束设置状态为抹账成功")
if trc_dict['TRCCO'] == '2000004':
#===========退汇业务,更新原交易挂账代销账序号==============
AfaLoggerFunc.tradeInfo(">>>开始更新原交易挂账代销账序号")
orstat_dict = {}
orstat_dict['BJEDTE'] = trc_dict['BOJEDT']
orstat_dict['BSPSQN'] = trc_dict['BOSPSQ']
orstat_dict['BCSTAT'] = PL_BCSTAT_HANG
orstat_dict['BDWFLG'] = PL_BDWFLG_SUCC
if TradeContext.existVariable('DASQ'):
orstat_dict['DASQ'] = TradeContext.DASQ
if not rccpsState.setTransState(orstat_dict):
return False
AfaLoggerFunc.tradeInfo(">>>结束更新原交易挂账代销账序号")
else:
#==========设置原交易状态为抹账失败========================
AfaLoggerFunc.tradeInfo(">>>开始设置状态为抹账失败")
stat_dict['BCSTAT'] = PL_BCSTAT_HCAC
stat_dict['BDWFLG'] = PL_BDWFLG_FAIL
if TradeContext.existVariable('TRDT'):
AfaLoggerFunc.tradeInfo("TRDT:" + TradeContext.TRDT)
stat_dict['TRDT'] = TradeContext.TRDT
if TradeContext.existVariable('TLSQ'):
AfaLoggerFunc.tradeInfo("TLSQ:" + TradeContext.TLSQ)
stat_dict['TLSQ'] = TradeContext.TLSQ
if TradeContext.existVariable('DASQ'):
AfaLoggerFunc.tradeInfo("DASQ:" + TradeContext.DASQ)
stat_dict['DASQ'] = TradeContext.DASQ
stat_dict['MGID'] = TradeContext.errorCode
stat_dict['STRINFO']= TradeContext.errorMsg
if not rccpsState.setTransState(stat_dict):
return False
AfaLoggerFunc.tradeInfo(">>>结束设置状态为抹账失败")
elif TradeContext.ROPRTPNO == "21":
#==========全国汇票业务============================================
AfaLoggerFunc.tradeInfo(">>>原业务类型为21,汇票业务")
#==========根据发送行号,委托日期,交易流水号查询原交易信息==========
AfaLoggerFunc.tradeInfo(">>>开始根据发送行号,委托日期,交易流水号查询交易信息")
ORSNDMBRCO = TradeContext.ORMFN[:10]
ORTRCDAT = TradeContext.ORMFN[10:18]
ORTRCNO = TradeContext.ORMFN[18:]
trc_dict = {}
if not rccpsDBFunc.getTransBilPK(ORSNDMBRCO,ORTRCDAT,ORTRCNO,trc_dict):
return False
if not rccpsDBFunc.getInfoBil(trc_dict['BILVER'],trc_dict['BILNO'],trc_dict['BILRS'],trc_dict):
return False
TradeContext.ORTRCCO = trc_dict['TRCCO']
AfaLoggerFunc.tradeInfo(">>>结束根据发送行号,委托日期,交易流水号查询交易信息")
#==========检查原业务是否MFE收妥===================================
tmp_stat_dict = {}
if not rccpsState.getTransStateSet(trc_dict['BJEDTE'],trc_dict['BSPSQN'],PL_BCSTAT_MFERCV,PL_BDWFLG_SUCC,tmp_stat_dict):
return AfaFlowControl.ExitThisFlow("S999","原汇票业务MFE尚未收妥,停止处理")
#==========根据中心返回码设置原交易状态============================
AfaLoggerFunc.tradeInfo(">>>中心处理码为[" + TradeContext.PRCCO + "]")
stat_dict = {}
stat_dict['BJEDTE'] = trc_dict['BJEDTE']
stat_dict['BSPSQN'] = trc_dict['BSPSQN']
stat_dict['BESBNO'] = trc_dict['BESBNO']
stat_dict['BETELR'] = TradeContext.BETELR
stat_dict['PRCCO'] = TradeContext.PRCCO
stat_dict['STRINFO']= TradeContext.STRINFO
if TradeContext.PRCCO == "RCCI0000":
return AfaFlowControl.ExitThisFlow("S999","业务回执报文中心处理码不应为RCCI0000")
elif TradeContext.PRCCO == "RCCO1078" or TradeContext.PRCCO == "RCCO1079":
#==========中心返回表示排队的处理码,开始设置状态为排队======
AfaLoggerFunc.tradeInfo(">>>开始设置状态为排队")
if not rccpsState.newTransState(trc_dict['BJEDTE'],trc_dict['BSPSQN'],PL_BCSTAT_MFEQUE,PL_BDWFLG_WAIT):
return False
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
return AfaFlowControl.ExitThisFlow("S999","Commit异常")
AfaLoggerFunc.tradeInfo(">>>Commit成功")
stat_dict['BCSTAT'] = PL_BCSTAT_MFEQUE
stat_dict['BDWFLG'] = PL_BDWFLG_SUCC
if not rccpsState.setTransState(stat_dict):
return False
AfaLoggerFunc.tradeInfo(">>>结束设置状态为排队")
else:
#==========中心返回表示拒绝的处理码,开始设置状态为拒绝======
AfaLoggerFunc.tradeInfo(">>>开始设置状态为拒绝")
if not rccpsState.newTransState(trc_dict['BJEDTE'],trc_dict['BSPSQN'],PL_BCSTAT_MFERFE,PL_BDWFLG_WAIT):
return False
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
return AfaFlowControl.ExitThisFlow("S999","Commit异常")
AfaLoggerFunc.tradeInfo(">>>Commit成功")
stat_dict['BCSTAT'] = PL_BCSTAT_MFERFE
stat_dict['BDWFLG'] = PL_BDWFLG_SUCC
if not rccpsState.setTransState(stat_dict):
return False
AfaLoggerFunc.tradeInfo(">>>结束设置状态为拒绝")
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
return AfaFlowControl.ExitThisFlow("S999","Commit异常")
AfaLoggerFunc.tradeInfo(">>>Commit成功")
#==========如果原交易为汇票签发,需自动抹账=======
if TradeContext.ORTRCCO == '2100001':
#==========设置当前机构为原机构,当前柜员为原柜员===========
TradeContext.BESBNO = trc_dict['BESBNO']
TradeContext.BETELR = trc_dict['BETELR']
TradeContext.TERMID = trc_dict['TERMID']
#==========设置原交易状态为抹账处理中======================
AfaLoggerFunc.tradeInfo(">>>开始设置状态为抹账处理中")
TradeContext.NOTE3 = "中心拒绝,行内自动抹账"
if not rccpsState.newTransState(trc_dict['BJEDTE'],trc_dict['BSPSQN'],PL_BCSTAT_HCAC,PL_BDWFLG_WAIT):
return False
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
return AfaFlowControl.ExitThisFlow("S999","Commit异常")
AfaLoggerFunc.tradeInfo(">>>Commit成功")
AfaLoggerFunc.tradeInfo(">>>结束设置状态为抹账处理中")
#==========发起主机抹账====================================
AfaLoggerFunc.tradeInfo(">>>开始主机抹账")
#=====如果资金来源为代销账，使用8813红字冲销====
if trc_dict['BBSSRC'] == '3': #待销账
TradeContext.BJEDTE = trc_dict['BJEDTE']
TradeContext.BSPSQN = trc_dict['BSPSQN']
TradeContext.OCCAMT = str(trc_dict['BILAMT']) #抹账金额为出票金额
TradeContext.HostCode = '8813'
TradeContext.RCCSMCD = PL_RCCSMCD_HPQF #主机摘要码:汇票签发
TradeContext.DASQ = ''
TradeContext.RVFG = '0' #红蓝字标志 0
TradeContext.SBAC = TradeContext.BESBNO + PL_ACC_HCHK #借方账号(汇票签发,借汇出汇款)
TradeContext.RBAC = TradeContext.BESBNO + PL_ACC_NXYDXZ #贷方账号(贷农信银代销账)
#=====开始调函数拼贷方账号第25位校验位====
TradeContext.SBAC = rccpsHostFunc.CrtAcc(TradeContext.SBAC, 25)
TradeContext.RBAC = rccpsHostFunc.CrtAcc(TradeContext.RBAC, 25)
AfaLoggerFunc.tradeInfo( '借方账号:' + TradeContext.SBAC )
AfaLoggerFunc.tradeInfo( '贷方账号:' + TradeContext.RBAC )
else:
TradeContext.BOJEDT = trc_dict['BJEDTE']
TradeContext.BOSPSQ = trc_dict['BSPSQN']
TradeContext.HostCode='8820'
#=====调起主机记账接口====
rccpsHostFunc.CommHost( TradeContext.HostCode )
AfaLoggerFunc.tradeInfo(">>>结束主机抹账")
if TradeContext.errorCode == '0000':
#==========设置原交易状态为抹账成功========================
AfaLoggerFunc.tradeInfo(">>>开始设置状态为抹账成功")
stat_dict['BCSTAT'] = PL_BCSTAT_HCAC
stat_dict['BDWFLG'] = PL_BDWFLG_SUCC
if TradeContext.existVariable('TRDT'):
AfaLoggerFunc.tradeInfo("TRDT:" + TradeContext.TRDT)
stat_dict['TRDT'] = TradeContext.TRDT
if TradeContext.existVariable('TLSQ'):
AfaLoggerFunc.tradeInfo("TLSQ:" + TradeContext.TLSQ)
stat_dict['TLSQ'] = TradeContext.TLSQ
if TradeContext.existVariable('DASQ'):
AfaLoggerFunc.tradeInfo("DASQ:" + TradeContext.DASQ)
stat_dict['DASQ'] = TradeContext.DASQ
stat_dict['MGID'] = TradeContext.errorCode
stat_dict['STRINFO']= TradeContext.errorMsg
if not rccpsState.setTransState(stat_dict):
return False
AfaLoggerFunc.tradeInfo(">>>结束设置状态为抹账成功")
else:
#==========设置原交易状态为抹账失败========================
AfaLoggerFunc.tradeInfo(">>>开始设置状态为抹账失败")
stat_dict['BCSTAT'] = PL_BCSTAT_HCAC
stat_dict['BDWFLG'] = PL_BDWFLG_FAIL
if TradeContext.existVariable('TRDT'):
AfaLoggerFunc.tradeInfo("TRDT:" + TradeContext.TRDT)
stat_dict['TRDT'] = TradeContext.TRDT
if TradeContext.existVariable('TLSQ'):
AfaLoggerFunc.tradeInfo("TLSQ:" + TradeContext.TLSQ)
stat_dict['TLSQ'] = TradeContext.TLSQ
if TradeContext.existVariable('DASQ'):
AfaLoggerFunc.tradeInfo("DASQ:" + TradeContext.DASQ)
stat_dict['DASQ'] = TradeContext.DASQ
stat_dict['MGID'] = TradeContext.errorCode
stat_dict['STRINFO']= TradeContext.errorMsg
if not rccpsState.setTransState(stat_dict):
return False
AfaLoggerFunc.tradeInfo(">>>结束设置状态为抹账失败")
#==========如果原交易为汇票退票,需重置实际结算金额和结余金额=======
if TradeContext.ORTRCCO == '2100103':
AfaLoggerFunc.tradeInfo(">>>汇票退票,开始重置实际结算金额和结余金额")
bilinf_update_dict = {}
bilinf_update_dict['OCCAMT'] = "0.00"
bilinf_update_dict['RMNAMT'] = "0.00"
bilinf_where_dict = {}
bilinf_where_dict['BILVER'] = trc_dict['BILVER']
bilinf_where_dict['BILNO'] = trc_dict['BILNO']
ret = rccpsDBTrcc_bilinf.update(bilinf_update_dict,bilinf_where_dict)
if ret == None:
return AfaFlowControl.ExitThisFlow("S999","更新汇票信息登记簿异常")
if ret <= 0:
return AfaFlowControl.ExitThisFlow("S999","无对应的汇票信息")
AfaLoggerFunc.tradeInfo(">>>汇票退票,结束重置实际结算金额和结余金额")
elif TradeContext.ROPRTPNO == "99":
#==========信息类业务===============================================
AfaLoggerFunc.tradeInfo(">>>原业务类型为99,信息类业务")
#==========根据发送行号,委托日期,交易流水号查询原交易信息===========
AfaLoggerFunc.tradeInfo(">>>开始根据发送行号,委托日期,交易流水号查询交易信息")
bka_where_dict = {}
bka_where_dict['SNDMBRCO'] = TradeContext.ORMFN[:10]
bka_where_dict['TRCDAT'] = TradeContext.ORMFN[10:18]
bka_where_dict['TRCNO'] = TradeContext.ORMFN[18:]
bka_update_dict = {}
bka_update_dict['PRCCO'] = TradeContext.PRCCO
bka_update_dict['STRINFO'] = TradeContext.STRINFO
#==========查询汇兑查询查复登记簿======================================
AfaLoggerFunc.tradeInfo(">>>开始查询汇兑查询查复登记簿")
bka_dict = rccpsDBTrcc_hdcbka.selectu(bka_where_dict)
if bka_dict == None:
return AfaFlowControl.ExitThisFlow("S999", "查询汇兑查询业务登记簿异常")
if len(bka_dict) > 0:
#======汇兑查询查复登记簿中找到原交易信息,开始更新回执信息=========
AfaLoggerFunc.tradeInfo(">>>汇兑查询查复登记簿中找到原交易信息,开始更新回执信息")
ret = rccpsDBTrcc_hdcbka.updateCmt(bka_update_dict,bka_where_dict)
if ret <= 0:
return AfaFlowControl.ExitThisFlow("S999", "更新回执信息异常")
AfaLoggerFunc.tradeInfo(">>>结束更新回执信息")
if (bka_dict['TRCCO'] == '9900512' or bka_dict['TRCCO'] == '9900523') and TradeContext.PRCCO != 'RCCI0000':
#======汇兑\特约汇兑查复业务,中心返回码非成功,修改原查询交易查询查复标识为未查复==
AfaLoggerFunc.tradeInfo(">>>汇兑\特约汇兑查复业务,中心返回码非成功")
AfaLoggerFunc.tradeInfo(">>>开始修改原汇兑\特约汇兑查询交易查询查复标识为未查复")
bka_update_dict = {'ISDEAL':PL_ISDEAL_UNDO}
bka_where_dict = {'BJEDTE':bka_dict['BOJEDT'],'BSPSQN':bka_dict['BOSPSQ']}
ret = rccpsDBTrcc_hdcbka.updateCmt(bka_update_dict,bka_where_dict)
if ret <= 0:
return AfaFlowControl.ExitThisFlow("S999", "更新原汇兑\特约汇兑查询交易查询查复标识为未查复异常")
AfaLoggerFunc.tradeInfo(">>>结束修改原汇兑\特约汇兑查询交易查询查复标识为未查复")
else:
#======汇兑查询查复登记簿中未找到原交易信息,开始查询票据查询查复登记簿====
AfaLoggerFunc.tradeInfo(">>>汇兑查询查复登记簿中未找到原交易信息,开始查询票据查询查复登记簿")
bka_dict = rccpsDBTrcc_pjcbka.selectu(bka_where_dict)
if bka_dict == None:
return AfaFlowControl.ExitThisFlow("S999", "查询票据查询业务登记簿异常")
if len(bka_dict) > 0:
#======票据查询查复登记簿中找到原交易信息,开始更新回执信息====
AfaLoggerFunc.tradeInfo(">>>票据查询查复登记簿中找到原交易信息,开始更新回执信息")
ret = rccpsDBTrcc_pjcbka.updateCmt(bka_update_dict,bka_where_dict)
if ret <= 0:
return AfaFlowControl.ExitThisFlow("S999", "更新回执信息异常")
AfaLoggerFunc.tradeInfo(">>>结束更新回执信息")
if bka_dict['TRCCO'] == '9900521' and TradeContext.PRCCO != 'RCCI0000':
#======票据查复业务,中心返回码非成功,修改原查询交易查询查复标识为未查复==
AfaLoggerFunc.tradeInfo(">>>票据查复业务,中心返回码非成功")
AfaLoggerFunc.tradeInfo(">>>开始修改原票据查询交易查询查复标识为未查复")
bka_update_dict = {'ISDEAL':PL_ISDEAL_UNDO}
bka_where_dict = {'BJEDTE':bka_dict['BOJEDT'],'BSPSQN':bka_dict['BOSPSQ']}
ret = rccpsDBTrcc_pjcbka.updateCmt(bka_update_dict,bka_where_dict)
if ret <= 0:
return AfaFlowControl.ExitThisFlow("S999", "更新原票据查询交易查询查复标识为未查复异常")
AfaLoggerFunc.tradeInfo(">>>结束修改原票据查询交易查询查复标识为未查复")
else:
#======票据查询查复登记簿中未找到原交易信息,开始查询汇票查询查复登记簿====
AfaLoggerFunc.tradeInfo(">>>票据查询查复登记簿中未找到原交易信息,开始查询汇票查询查复登记簿")
bka_dict = rccpsDBTrcc_hpcbka.selectu(bka_where_dict)
if bka_dict == None:
return AfaFlowControl.ExitThisFlow("S999", "查询汇票查询业务登记簿异常")
if len(bka_dict) > 0:
#======汇票查询查复登记簿中找到原交易信息,开始更新回执信息====
AfaLoggerFunc.tradeInfo(">>>汇票查询查复登记簿中找到原交易信息,开始更新回执信息")
ret = rccpsDBTrcc_hpcbka.updateCmt(bka_update_dict,bka_where_dict)
if ret <= 0:
return AfaFlowControl.ExitThisFlow("S999", "更新回执信息异常")
AfaLoggerFunc.tradeInfo(">>>结束更新回执信息")
if bka_dict['TRCCO'] == '9900527' and TradeContext.PRCCO != 'RCCI0000':
#======汇票查复业务,中心返回码非成功,修改原查询交易查询查复标识为未查复==
AfaLoggerFunc.tradeInfo(">>>汇票查复业务,中心返回码非成功")
AfaLoggerFunc.tradeInfo(">>>开始修改原汇票查询交易查询查复标识为未查复")
bka_update_dict = {'ISDEAL':PL_ISDEAL_UNDO}
bka_where_dict = {'BJEDTE':bka_dict['BOJEDT'],'BSPSQN':bka_dict['BOSPSQ']}
ret = rccpsDBTrcc_hpcbka.updateCmt(bka_update_dict,bka_where_dict)
if ret <= 0:
return AfaFlowControl.ExitThisFlow("S999", "更新原汇票查询交易查询查复标识为未查复异常")
AfaLoggerFunc.tradeInfo(">>>结束修改原汇票查询交易查询查复标识为未查复")
else:
#======汇票查询查复登记簿中未找到原交易信息,开始查询支付业务状态查询查复登记簿====
AfaLoggerFunc.tradeInfo(">>>汇票查询查复登记簿中未找到原交易信息,开始查询支付业务状态查询查复登记簿")
bka_dict = rccpsDBTrcc_ztcbka.selectu(bka_where_dict)
if bka_dict == None:
return AfaFlowControl.ExitThisFlow("S999", "查询业务状态查询业务登记簿异常")
if len(bka_dict) > 0:
#======业务状态查询查复登记簿中找到原交易信息,开始更新回执信息====
AfaLoggerFunc.tradeInfo(">>>业务状态查询查复登记簿中找到原交易信息,开始更新回执信息")
ret = rccpsDBTrcc_ztcbka.updateCmt(bka_update_dict,bka_where_dict)
if ret <= 0:
return AfaFlowControl.ExitThisFlow("S999", "更新回执信息异常")
AfaLoggerFunc.tradeInfo(">>>结束更新回执信息")
if bka_dict['TRCCO'] == '9900507' and TradeContext.PRCCO != 'RCCI0000':
#======支付业务状态查复业务,中心返回码非成功,修改原查询交易查询查复标识为未查复==
AfaLoggerFunc.tradeInfo(">>>支付业务状态查复业务,中心返回码非成功")
AfaLoggerFunc.tradeInfo(">>>开始修改原支付业务状态查询交易查询查复标识为未查复")
bka_update_dict = {'ISDEAL':PL_ISDEAL_UNDO}
bka_where_dict = {'BJEDTE':bka_dict['BOJEDT'],'BSPSQN':bka_dict['BOSPSQ']}
ret = rccpsDBTrcc_hpcbka.updateCmt(bka_update_dict,bka_where_dict)
if ret <= 0:
return AfaFlowControl.ExitThisFlow("S999", "更新原支付业务状态查询交易查询查复标识为未查复异常")
AfaLoggerFunc.tradeInfo(">>>结束修改原支付业务状态查询交易查询查复标识为未查复")
else:
#==支付业务状态查询查复登记簿中未找到原交易信息,开始查询撤销申请登记簿==
AfaLoggerFunc.tradeInfo(">>>支付业务状态查询查复登记簿中未找到原交易信息,开始查询撤销申请登记簿")
bka_dict = rccpsDBTrcc_trccan.selectu(bka_where_dict)
if bka_dict == None:
return AfaFlowControl.ExitThisFlow("S999", "查询资金调拨申请登记簿异常")
if len(bka_dict) > 0:
#==撤销申请登记簿中找到原交易信息,开始更新回执信息=========
AfaLoggerFunc.tradeInfo(">>>撤销申请登记簿中找到原交易信息,开始更新回执信息")
ret = rccpsDBTrcc_trccan.updateCmt(bka_update_dict,bka_where_dict)
if ret <= 0:
return AfaFlowControl.ExitThisFlow("S999","更新回执信息异常")
AfaLoggerFunc.tradeInfo(">>>结束更新回执信息")
else:
#==撤销申请登记簿中未找到原交易信息,开始查询紧急止付登记簿==
AfaLoggerFunc.tradeInfo(">>>支付业务状态查询查复登记簿中未找到原交易信息,开始查询紧急止付登记簿")
bka_dict = rccpsDBTrcc_existp.selectu(bka_where_dict)
if bka_dict == None:
return AfaFlowControl.ExitThisFlow("S999", "查询紧急止付登记簿异常")
if len(bka_dict) > 0:
#==紧急止付登记簿中找到原交易信息,开始更新回执信息===========
AfaLoggerFunc.tradeInfo(">>>紧急止付登记簿中找到原交易信息,开始更新回执信息")
ret = rccpsDBTrcc_existp.updateCmt(bka_update_dict,bka_where_dict)
if ret <= 0:
return AfaFlowControl.ExitThisFlow("S999","更新回执信息异常")
AfaLoggerFunc.tradeInfo(">>>结束更新回执信息")
else:
#==紧急止付登记簿中未找到原交易信息,开始查询资金调拨申请登记簿==
AfaLoggerFunc.tradeInfo(">>>紧急止付登记簿中未找到原交易信息,开始查询资金调拨申请登记簿")
bka_dict = rccpsDBTrcc_mrqtbl.selectu(bka_where_dict)
if bka_dict == None:
return AfaFlowControl.ExitThisFlow("S999", "查询资金调拨申请登记簿异常")
if len(bka_dict) > 0:
#==资金调拨申请登记簿中找到原交易信息,开始更新回执信息=========
AfaLoggerFunc.tradeInfo(">>>资金调拨申请登记簿中找到原交易信息,开始更新回执信息")
ret = rccpsDBTrcc_mrqtbl.updateCmt(bka_update_dict,bka_where_dict)
if ret <= 0:
return AfaFlowControl.ExitThisFlow("S999","更新回执信息异常")
AfaLoggerFunc.tradeInfo(">>>结束更新回执信息")
else:
#==资金调拨申请登记簿中未找到原交易信息,开始查询清算账户余额通知登记簿==
AfaLoggerFunc.tradeInfo(">>>资金调拨申请登记簿中未找到原交易信息,开始查询清算账户余额通知登记簿")
bka_dict = rccpsDBTrcc_rekbal.selectu(bka_where_dict)
if bka_dict == None:
return AfaFlowControl.ExitThisFlow("S999", "查询清算账户余额通知登记簿异常")
if len(bka_dict) > 0:
#==清算账户余额通知登记簿中找到原交易信息,开始更新回执信息==
AfaLoggerFunc.tradeInfo(">>清算账户余额通知登记簿中找到原交易信息,开始更新回执信息")
ret = rccpsDBTrcc_rekbal.updateCmt(bka_update_dict,bka_where_dict)
if ret <= 0:
return AfaFlowControl.ExitThisFlow("S999","更新回执信息异常")
AfaLoggerFunc.tradeInfo(">>>结束更新回执信息")
else:
#==未找到原交易信息,丢弃报文===========
return AfaFlowControl.ExitThisFlow("S999", "未找到原交易信息,丢弃报文")
else:
#==========原业务类型非法===========================================
return AfaFlowControl.ExitThisFlow("S999", "原业务类型[" + TradeContext.ROPRTPNO + "]非法")
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
return AfaFlowControl.ExitThisFlow("S999","Commit异常")
AfaLoggerFunc.tradeInfo(">>>Commit成功")
#================为通讯回执报文赋值=========================================
AfaLoggerFunc.tradeInfo(">>>开始为通讯回执报文赋值")
#======为通讯回执报文赋值===================================================
out_context_dict = {}
out_context_dict['sysType'] = 'rccpst'
out_context_dict['TRCCO'] = '9900503'
out_context_dict['MSGTYPCO'] = 'SET008'
out_context_dict['RCVMBRCO'] = TradeContext.SNDMBRCO
out_context_dict['SNDMBRCO'] = TradeContext.RCVMBRCO
out_context_dict['SNDBRHCO'] = TradeContext.BESBNO
out_context_dict['SNDCLKNO'] = TradeContext.BETELR
out_context_dict['SNDTRDAT'] = TradeContext.BJEDTE
out_context_dict['SNDTRTIM'] = TradeContext.BJETIM
out_context_dict['MSGFLGNO'] = out_context_dict['SNDMBRCO'] + TradeContext.BJEDTE + TradeContext.SerialNo
out_context_dict['ORMFN'] = TradeContext.MSGFLGNO
out_context_dict['NCCWKDAT'] = TradeContext.NCCworkDate
out_context_dict['OPRTYPNO'] = '99'
out_context_dict['ROPRTPNO'] = TradeContext.OPRTYPNO
out_context_dict['TRANTYP'] = '0'
out_context_dict['ORTRCCO'] = TradeContext.TRCCO
out_context_dict['PRCCO'] = 'RCCI0000'
out_context_dict['STRINFO'] = '成功'
rccpsMap0000Dout_context2CTradeContext.map(out_context_dict)
AfaLoggerFunc.tradeInfo(">>>结束为通讯回执报文赋值")
AfaLoggerFunc.tradeInfo( '***农信银系统：往账.回执类操作(1.本地操作).业务回执报文接收[TRCC006_1110]退出***' )
return True
def SubModuleDoFst():
AfaLoggerFunc.tradeInfo( '***农信银系统：来账.中心类操作(1.本地操作).存款确认请求报文接收[TRCC006_1143]进入***' )
#判断是否重复报文
AfaLoggerFunc.tradeInfo(">>>开始判断是否重复报文")
sel_dict = {'COTRCNO':TradeContext.TRCNO,'COTRCDAT':TradeContext.TRCDAT,'SNDBNKCO':TradeContext.SNDBNKCO}
record = rccpsDBTrcc_wtrbka.selectu(sel_dict)
if record == None:
return AfaFlowControl.ExitThisFlow('S999','判断是否重复存款确认报文,查询通存通兑业务登记簿相同报文异常')
elif len(record) > 0:
AfaLoggerFunc.tradeInfo('通存通兑业务登记簿中存在相同数据,重复报文,返回应答报文')
TradeContext.STRINFO = "重复报文"
else:
#查询原存款交易信息
AfaLoggerFunc.tradeInfo(">>>非重复报文,开始查询原存款交易信息")
wtrbka_dict = {}
if not rccpsDBFunc.getTransWtrAK(TradeContext.SNDBNKCO,TradeContext.TRCDAT,TradeContext.ORTRCNO,wtrbka_dict):
AfaFlowControl.ExitThisFlow('S999',"查询原存款交易信息异常")
TradeContext.BJEDTE = wtrbka_dict['BJEDTE']
TradeContext.BSPSQN = wtrbka_dict['BSPSQN']
TradeContext.PYEACC = wtrbka_dict['PYEACC']
TradeContext.PYENAM = wtrbka_dict['PYENAM']
TradeContext.OCCAMT = wtrbka_dict['OCCAMT']
TradeContext.BESBNO = wtrbka_dict['BESBNO']
AfaLoggerFunc.tradeInfo(">>>结束查询原存款交易信息")
#检查交易当前状态是否为确认入账成功,非此状态则丢弃报文
AfaLoggerFunc.tradeInfo(">>>开始判断交易当前状态是否为确认入账成功")
stat_dict = {}
if not rccpsState.getTransStateCur(TradeContext.BJEDTE,TradeContext.BSPSQN,stat_dict):
return AfaFlowControl.ExitThisFlow('S999',"获取原存款交易当前状态异常")
#if not (stat_dict['BCSTAT'] == PL_BCSTAT_CONFACC and stat_dict['BDWFLG'] == PL_BDWFLG_SUCC):
# return AfaFlowControl.ExitThisFlow('S999',"原存款交易当前状态非确认入账成功,丢弃报文")
AfaLoggerFunc.tradeInfo(">>>结束判断交易当前状态是否为确认入账成功")
#更新通存通兑登记簿存款确认相关信息
AfaLoggerFunc.tradeInfo(">>>开始更新通存通兑登记簿存款确认相关信息")
wtrbka_where_dict = {}
wtrbka_where_dict = {'BJEDTE':TradeContext.BJEDTE,'BSPSQN':TradeContext.BSPSQN}
wtrbka_update_dict = {}
wtrbka_update_dict = {'COTRCDAT':TradeContext.TRCDAT,'COTRCNO':TradeContext.TRCNO,'COMSGFLGNO':TradeContext.MSGFLGNO}
ret = rccpsDBTrcc_wtrbka.update(wtrbka_update_dict,wtrbka_where_dict)
if ret <= 0:
return AfaFlowControl.ExitThisFlow('S999',"更新通存通兑登记簿存款确认相关信息异常")
AfaLoggerFunc.tradeInfo(">>>结束更新通存通兑登记簿存款确认相关信息")
#设置业务状态为自动入账处理中
AfaLoggerFunc.tradeInfo(">>>开始设置业务状态为自动入账处理中")
if not rccpsState.newTransState(TradeContext.BJEDTE,TradeContext.BSPSQN,PL_BCSTAT_CONFACC,PL_BDWFLG_WAIT):
return AfaFlowControl.ExitThisFlow('S999','设置业务状态为自动入账处理中异常')
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
return AfaFlowControl.ExitThisFlow("S999","Commit异常")
AfaLoggerFunc.tradeInfo(">>>开始设置业务状态为自动入账处理中")
#发起主机记账
AfaLoggerFunc.tradeInfo(">>>开始发起主机记账")
TradeContext.HostCode = '8813' #调用8813主机接口
TradeContext.RCCSMCD = PL_RCCSMCD_HDLZ #主机摘要代码：汇兑来账
TradeContext.SBAC = TradeContext.BESBNO + PL_ACC_NXYDQSLZ #借方账户:农信银待清算来账
TradeContext.SBNM = "农信银待清算来账"
TradeContext.RBAC = TradeContext.PYEACC #贷方账户:收款人账户
TradeContext.RBNM = TradeContext.PYENAM #贷方户名:收款人户名
TradeContext.OCCAMT = str(TradeContext.OCCAMT)
#=====add by pgt 12-5====
TradeContext.CTFG = '7' #本金 手续费标识 7 本金 8手续费 9 本金＋手续费
TradeContext.PKFG = 'T' #通存通兑标识
TradeContext.SBAC = rccpsHostFunc.CrtAcc(TradeContext.SBAC, 25)
AfaLoggerFunc.tradeInfo( '借方账号:' + TradeContext.SBAC )
AfaLoggerFunc.tradeInfo( '贷方账号:' + TradeContext.RBAC )
rccpsHostFunc.CommHost( TradeContext.HostCode )
AfaLoggerFunc.tradeInfo(">>>结束发起主机记账")
#根据主机返回码,设置业务状态为自动入账成功或失败
AfaLoggerFunc.tradeInfo(">>>开始根据主机返回码,设置业务状态为自动入账成功或失败")
stat_dict = {}
stat_dict['BJEDTE'] = TradeContext.BJEDTE
stat_dict['BJETIM'] = TradeContext.BJETIM
stat_dict['BSPSQN'] = TradeContext.BSPSQN
stat_dict['BESBNO'] = TradeContext.BESBNO
stat_dict['BETELR'] = TradeContext.BETELR
stat_dict['SBAC'] = TradeContext.SBAC
stat_dict['ACNM'] = TradeContext.SBNM
stat_dict['RBAC'] = TradeContext.RBAC
stat_dict['OTNM'] = TradeContext.RBNM
stat_dict['PRCCO'] = TradeContext.errorCode
stat_dict['STRINFO'] = TradeContext.errorMsg
AfaLoggerFunc.tradeInfo("主机返回码[" + TradeContext.errorCode + "],主机返回信息[" + TradeContext.errorMsg +"]")
if TradeContext.errorCode == '0000':
#=====发送农信银成功,设置状态为自动入账成功====
stat_dict['TRDT'] = TradeContext.TRDT
stat_dict['TLSQ'] = TradeContext.TLSQ
stat_dict['BCSTAT'] = PL_BCSTAT_AUTO
stat_dict['BDWFLG'] = PL_BDWFLG_SUCC
TradeContext.STRINFO = '成功'
if not rccpsState.setTransState(stat_dict):
return AfaFlowControl.ExitThisFlow('S999', "设置业务状态为自动入账成功异常")
AfaLoggerFunc.tradeInfo(">>>设置业务状态为自动入账成功完成")
else:
#=====发送农信银失败,设置状态为自动入账失败====
stat_dict['BCSTAT'] = PL_BCSTAT_AUTO
stat_dict['BDWFLG'] = PL_BDWFLG_FAIL
TradeContext.STRINFO = '行内自动入账失败'
if not rccpsState.setTransState(stat_dict):
return AfaFlowControl.ExitThisFlow('S999', "设置业务状态为自动入账失败异常")
AfaLoggerFunc.tradeInfo(">>>设置业务状态为自动入账失败完成")
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
return AfaFlowControl.ExitThisFlow("S999","Commit异常")
#为存款确认应答报文赋值
TradeContext.sysType = 'rccpst'
TradeContext.MSGTYPCO = 'SET010'
TradeContext.RCVSTLBIN = TradeContext.SNDMBRCO
TradeContext.SNDSTLBIN = TradeContext.RCVMBRCO
TradeContext.SNDBRHCO = TradeContext.BESBNO
TradeContext.SNDCLKNO = TradeContext.BETELR
#TradeContext.SNDTRDAT = TradeContext.BJEDTE
#TradeContext.SNDTRTIM = TradeContext.BJETIM
TradeContext.ORMFN = TradeContext.MSGFLGNO
#TradeContext.MSGFLGNO = TradeContext.SNDMBRCO + TradeContext.BJEDTE + TradeContext.SerialNo
#TradeContext.NCCWKDAT = TradeContext.NCCworkDate
TradeContext.OPRTYPNO = '30'
TradeContext.ROPRTPNO = TradeContext.OPRTYPNO
TradeContext.TRANTYP = '0'
TradeContext.CUR = 'CNY'
TradeContext.PRCCO = 'RCCI0000'
AfaLoggerFunc.tradeInfo( '***农信银系统：来账.中心类操作(1.本地操作).存款确认请求报文接收[TRCC006_1143]退出***' )
return True
def SubModuleDoFst():
AfaLoggerFunc.tradeInfo( '***农信银系统: 往账.本地类操作交易[RCC004_1163]进入***' )
#=====判断是否存在自动冲正报文====
AfaLoggerFunc.tradeDebug('>>>判断是否存在自动冲正报文')
atcbka_where={'ORMFN':TradeContext.MSGFLGNO}
atcbka_dict = rccpsDBTrcc_atcbka.selectu(atcbka_where)
if( len(atcbka_dict) > 0 ):
#=====冲销业务存在自动冲正报文,更新表数据为冲销失败,回复冲销失败报文====
AfaLoggerFunc.tradeDebug('>>>已存在自动冲正报文,抛弃报文')
return AfaFlowControl.ExitThisFlow('S999','存在自动冲正报文，抛弃报文')
else:
AfaLoggerFunc.tradeDebug('>>>未查找到针对补正报文的自动冲正报文,流程继续')
#=====判断原补正交易是否存在====
AfaLoggerFunc.tradeDebug('>>>判断是否存在原补正报文')
wtrbka_where={'MSGFLGNO':TradeContext.ORMFN}
wtrbka_dict = rccpsDBTrcc_wtrbka.selectu(wtrbka_where)
wtrbka_temp_dict = wtrbka_dict
if len(wtrbka_dict) <= 0:
AfaLoggerFunc.tradeDebug('>>>未找到原补正报文，抛弃报文，不做任何处理')
return AfaFlowControl.ExitThisFlow('S999','未找到原补正报文，抛弃报文，不做任何处理')
else:
AfaLoggerFunc.tradeDebug('>>>找到原补正报文，继续流程处理')
#=====查找原业务====
AfaLoggerFunc.tradeDebug('>>>查询原业务')
wtrbka_where={'BJEDTE':wtrbka_dict['NOTE1'],'BSPSQN':wtrbka_dict['NOTE2']}
wtrbka_dict = rccpsDBTrcc_wtrbka.selectu(wtrbka_where)
if len(wtrbka_dict) <= 0:
AfaLoggerFunc.tradeDebug('>>>未找到原业务，抛弃报文，不做任何处理')
return AfaFlowControl.ExitThisFlow('S999','未找到原业务，抛弃报文，不做任何处理')
else:
AfaLoggerFunc.tradeDebug('>>>找到原业务，继续流程处理')
#=====查找原业务状态====
AfaLoggerFunc.tradeDebug('>>>查找原业务状态')
spb_where = {'BJEDTE':wtrbka_dict['BJEDTE'],'BSPSQN':wtrbka_dict['BSPSQN']}
spb_dict = rccpsDBTrcc_spbsta.selectu(spb_where)
if len(spb_dict) <= 0:
AfaLoggerFunc.tradeDebug('>>>查找原业务状态失败，抛弃报文，不做任何处理')
return AfaFlowControl.ExitThisFlow('S999','查找原业务状态失败，抛弃报文，不做任何处理')
else:
AfaLoggerFunc.tradeDebug('>>>查找原业务状态成功，继续流程处理')
#=====判断原业务状态是否允许进行补正账务补录====
if spb_dict['BCSTAT'] != PL_BCSTAT_CANC and spb_dict['BDWFLG'] != PL_BDWFLG_SUCC:
AfaLoggerFunc.tradeDebug('>>>原业务状态['+str(spbsta_dict['BCSTAT'])+'不允许补正，抛弃报文，不做任何处理')
return AfaFlowControl.ExitThisFlow('S999','原业务不允许补正，抛弃报文，不做任何处理')
else:
AfaLoggerFunc.tradeDebug('>>>原业务进入补正账务流程处理')
#=================若应答报文回复拒绝,则设置状态为拒绝,停止处理=============
if TradeContext.PRCCO != 'RCCI0000':
AfaLoggerFunc.tradeInfo(">>>对方返回拒绝应答")
#=============设置业务状态为拒绝处理中=================================
if not rccpsState.newTransState(wtrbka_temp_dict['BJEDTE'],wtrbka_temp_dict['BSPSQN'],PL_BCSTAT_MFERFE,PL_BDWFLG_SUCC):
return AfaFlowControl.ExitThisFlow('S999',"设置业务状态为拒绝处理中异常")
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
return AfaFlowControl.ExitThisFlow("S999","Commit异常")
return AfaFlowControl.ExitThisFlow("S999","对方拒绝,停止处理")
else:
AfaLoggerFunc.tradeInfo(">>>对方返回成功应答")
#=====记账接口8813I1赋值操作====
TradeContext.HostCode = '8813'
TradeContext.BESBNO = wtrbka_dict['BESBNO'] #机构号
TradeContext.BETELR = wtrbka_dict['BETELR'] #柜员号
TradeContext.TERMID = wtrbka_dict['TERMID'] #终端号
TradeContext.BJEDTE = wtrbka_dict['BJEDTE'] #交易日期
TradeContext.BSPSQN = wtrbka_dict['BSPSQN'] #报单序号
#=====判断交易代码，进行账务补正====
if TradeContext.ORTRCCO in ('3000002','3000004'):
#=====通存====
AfaLoggerFunc.tradeDebug('>>>通存业务补正')
elif TradeContext.ORTRCCO in ('3000102','3000104'):
#=====通兑====
AfaLoggerFunc.tradeDebug('>>>通兑业务补正')
if( wtrbka_dict['CHRGTYP'] != '1'):
TradeContext.RCCSMCD = PL_RCCSMCD_XJTDWZ #主机摘要代码
TradeContext.RBAC = '' #借方账户:付款人账户
TradeContext.RBNM = '现金' #借方户名 付款人户名
TradeContext.SBAC = TradeContext.BESBNO + PL_ACC_NXYDQSWZ #贷方账户:农信银待清算来账
TradeContext.SBAC = rccpsHostFunc.CrtAcc(TradeContext.SBAC, 25)
TradeContext.ACNM = '农信银待清算来账' #贷方户名:
TradeContext.CTFG = '7' #本金 手续费标识 7 本金 8手续费 9 本金＋手续费
TradeContext.PKFG = 'T' #通存通兑标识
TradeContext.CATR = '0' #现金
AfaLoggerFunc.tradeInfo( '借方账号:' + TradeContext.SBAC )
AfaLoggerFunc.tradeInfo( '贷方账号:' + TradeContext.RBAC )
else:
#=====转账====
TradeContext.ACUR = '3' #记账次数
TradeContext.I3TRAM = str(TradeContext.CUSCHRG) #发生额
TradeContext.I2TRAM = str(TradeContext.OCCAMT) #发生额
TradeContext.OCCAMT = rccpsUtilTools.AddDot(TradeContext.OCCAMT,TradeContext.CUSCHRG) #发生额
#=========交易金额+手续费===================
TradeContext.RCCSMCD = PL_RCCSMCD_XJTDWZ #摘要代码
TradeContext.SBAC = TradeContext.BESBNO + PL_ACC_NXYDQSWZ #借方账号
TradeContext.SBAC = rccpsHostFunc.CrtAcc(TradeContext.SBAC,25)
TradeContext.ACNM = '待解临时款项' #借方户名
TradeContext.RBAC = TradeContext.BESBNO + PL_ACC_NXYDJLS #贷方账号
TradeContext.RBAC = rccpsHostFunc.CrtAcc(TradeContext.RBAC,25)
TradeContext.OTNM = '农信银来账' #贷方户名
TradeContext.CTFG = '9' #本金 手续费标识 7 本金 8手续费 9 本金＋手续费
TradeContext.PKFG = 'T' #通存通兑标识
AfaLoggerFunc.tradeInfo( '>>>交易金额+手续费:借方账号' + TradeContext.SBAC )
AfaLoggerFunc.tradeInfo( '>>>交易金额+手续费:贷方账号' + TradeContext.RBAC )
#=========交易金额============
TradeContext.I2SMCD = PL_RCCSMCD_XJTDWZ #摘要代码
TradeContext.I2RBAC = '' #借方账号
TradeContext.I2ACNM = TradeContext.PYRNAM #借方户名
TradeContext.I2SBAC = TradeContext.BESBNO + PL_ACC_NXYDJLS #贷方账号
TradeContext.I2SBAC = rccpsHostFunc.CrtAcc(TradeContext.I2SBAC,25)
TradeContext.I2CTFG = '7' #本金 手续费标识 7 本金 8手续费 9 本金＋手续费
TradeContext.I2PKFG = 'T' #通存通兑标识
TradeContext.I2CATR = '0' #现金
AfaLoggerFunc.tradeInfo( '>>>交易金额:借方账号' + TradeContext.I2SBAC )
AfaLoggerFunc.tradeInfo( '>>>交易金额:贷方账号' + TradeContext.I2RBAC )
#=========结算手续费收入户===========
TradeContext.I3SMCD = PL_RCCSMCD_SXF #摘要代码
TradeContext.I3SBAC = TradeContext.BESBNO + PL_ACC_NXYDJLS #借方账号
TradeContext.I3ACNM = TradeContext.PYRNAM #借方户名
TradeContext.I3RBAC = TradeContext.BESBNO + PL_ACC_TCTDSXF #贷方账号
TradeContext.I3RBAC = rccpsHostFunc.CrtAcc(TradeContext.I3RBAC,25)
TradeContext.I3SBAC = rccpsHostFunc.CrtAcc(TradeContext.I3SBAC,25)
TradeContext.I3OTNM = '待解临时款项' #贷方户名
TradeContext.I3CTFG = '8' #本金 手续费标识 7 本金 8手续费 9 本金＋手续费
TradeContext.I3PKFG = 'T' #通存通兑标识
AfaLoggerFunc.tradeInfo( '>>>结算手续费收入户:借方账号' + TradeContext.I3SBAC )
AfaLoggerFunc.tradeInfo( '>>>结算手续费收入户:贷方账号' + TradeContext.I3RBAC )
elif TradeContext.ORTRCCO in ('3000003','3000005'):
#=====本转异====
AfaLoggerFunc.tradeDebug('>>>本转异业务补正')
elif TradeContext.ORTRCCO in ('3000103','3000105'):
#=====异转本====
AfaLoggerFunc.tradeDebug('>>>异转本业务补正')
#=====判断手续费收取方式====
if wtrbka_dict['CHRGTYP'] == '1':
#=====转账====
TradeContext.ACUR = '3' #记账次数
TradeContext.I3TRAM = str(TradeContext.CUSCHRG) #发生额 手续费
TradeContext.I2TRAM = str(TradeContext.OCCAMT) #发生额 本金
TradeContext.OCCAMT = str(float(TradeContext.OCCAMT) + float(TradeContext.CUSCHRG)) #发生额
#=========交易金额+手续费===================
TradeContext.RCCSMCD = PL_RCCSMCD_YZBWZ #摘要代码 PL_RCCSMCD_YZBWZ 异转本
TradeContext.SBAC = TradeContext.BESBNO + PL_ACC_NXYDQSWZ #借方账号
TradeContext.SBAC = rccpsHostFunc.CrtAcc(TradeContext.SBAC,25)
TradeContext.ACNM = '农信银往账' #借方户名
TradeContext.RBAC = TradeContext.BESBNO + PL_ACC_NXYDJLS #贷方账号
TradeContext.RBAC = rccpsHostFunc.CrtAcc(TradeContext.RBAC,25)
TradeContext.OTNM = '应解汇款' #贷方户名
TradeContext.CTFG = '9' #本金 手续费标识 7 本金 8手续费 9 本金＋手续费
TradeContext.PKFG = 'T' #通存通兑标识
AfaLoggerFunc.tradeInfo( '>>>交易金额+手续费:借方账号' + TradeContext.SBAC )
AfaLoggerFunc.tradeInfo( '>>>交易金额+手续费:贷方账号' + TradeContext.RBAC )
#=========交易金额============
TradeContext.I2SMCD = PL_RCCSMCD_YZBWZ #摘要代码
TradeContext.I2SBAC = TradeContext.BESBNO + PL_ACC_NXYDJLS #借方账号
TradeContext.I2SBAC = rccpsHostFunc.CrtAcc(TradeContext.I2SBAC,25)
TradeContext.I2ACNM = '应解汇款' #借方户名
TradeContext.I2RBAC = TradeContext.PYEACC #贷方账号
TradeContext.I2OTNM = TradeContext.PYENAM #贷方户名
TradeContext.I2CTFG = '7' #本金 手续费标识 7 本金 8手续费 9 本金＋手续费
TradeContext.I2PKFG = 'T' #通存通兑标识
AfaLoggerFunc.tradeInfo( '>>>交易金额:借方账号' + TradeContext.I2SBAC )
AfaLoggerFunc.tradeInfo( '>>>交易金额:贷方账号' + TradeContext.I2RBAC )
#=========结算手续费收入户===========
TradeContext.I3SMCD = PL_RCCSMCD_SXF #摘要代码
TradeContext.I3SBAC = TradeContext.BESBNO + PL_ACC_NXYDJLS #借方账号
TradeContext.I3SBAC = rccpsHostFunc.CrtAcc(TradeContext.I3SBAC,25)
TradeContext.I3ACNM = '应解汇款' #借方户名
TradeContext.I3RBAC = TradeContext.BESBNO + PL_ACC_TCTDSXF #贷方账号
TradeContext.I3RBAC = rccpsHostFunc.CrtAcc(TradeContext.I3RBAC,25)
TradeContext.I3OTNM = '结算手续费' #贷方户名
TradeContext.I3CTFG = '8' #本金 手续费标识 7 本金 8手续费 9 本金＋手续费
TradeContext.I3PKFG = 'T' #通存通兑标识
else:
#=====不收费或者现金====
TradeContext.ACUR = '1' #记账次数
TradeContext.RCCSMCD = PL_RCCSMCD_YZBWZ #摘要代码
TradeContext.SBAC = TradeContext.BESBNO + PL_ACC_NXYDQSWZ #借方账号
TradeContext.SBAC = rccpsHostFunc.CrtAcc(TradeContext.SBAC,25)
TradeContext.RBAC = TradeContext.PYEACC #贷方账号
TradeContext.OTNM = TradeContext.PYENAM #贷方户名
TradeContext.CTFG = '7' #本金 手续费标识 7 本金 8手续费 9 本金＋手续费
TradeContext.PKFG = 'T' #通存通兑标识
else:
#=====原交易代码错，抛弃报文====
AfaLoggerFunc.tradeDebug('>>>原交易代码错，抛弃报文')
return AfaFlowControl.ExitThisFlow('S999','原交易代码错，抛弃报文')
#=====重新生成前置流水号====
if rccpsGetFunc.GetRBSQ(PL_BRSFLG_SND) == -1 :
return AfaFlowControl.ExitThisFlow('S999','重新生成前置流水号失败,抛弃报文')
#=====modify by pgt 12-8====
if wtrbka_temp_dict['DCFLG'] == PL_DCFLG_DEB:
# if TradeContext.ORTRCCO in ('3000102','3000104','3000103','3000105'):
#=====通兑、异转本====
if not rccpsState.newTransState(TradeContext.BJEDTE,TradeContext.BSPSQN,PL_BCSTAT_AUTOPAY,PL_BDWFLG_WAIT):
AfaDBFunc.RollbackSql()
return AfaFlowControl.ExitThisFlow('S999','新增自动扣款－处理中失败，抛弃报文')
else:
AfaDBFunc.CommitSql()
#=====向主机发起记账====
rccpsHostFunc.CommHost( TradeContext.HostCode )
#=====判断主机返回====
sstlog_dict={}
sstlog_dict['BJEDTE'] = TradeContext.BJEDTE
sstlog_dict['BSPSQN'] = TradeContext.BSPSQN
sstlog_dict['BCSTAT'] = PL_BCSTAT_AUTOPAY
if TradeContext.errorCode == '0000':
sstlog_dict['BDWFLG'] = PL_BDWFLG_SUCC
sstlog_dict['RBSQ'] = TradeContext.RBSQ
sstlog_dict['TLSQ'] = TradeContext.TLSQ
sstlog_dict['TRDT'] = TradeContext.TRDT
sstlog_dict['MGID'] = TradeContext.errorCode
sstlog_dict['STRINFO']= '主机补正记账成功'
AfaLoggerFunc.tradeInfo('>>>补正记账成功')
else:
sstlog_dict['BDWFLG'] = PL_BDWFLG_FAIL
sstlog_dict['MGID'] = TradeContext.errorCode
sstlog_dict['STRINFO']= TradeContext.errorMsg
AfaLoggerFunc.tradeInfo('>>>补正记账失败')
if not rccpsState.setTransState(sstlog_dict):
AfaDBFunc.RollbackSql()
return AfaFlowControl.ExitThisFlow('S999','修改自动扣款－成功中失败，抛弃报文')
else:
AfaDBFunc.CommitSql()
else:
#====通存、本转异====
AfaLoggerFunc.tradeDebug('>>>新增确认付款－处理中')
if not rccpsState.newTransState(TradeContext.BJEDTE,TradeContext.BSPSQN,PL_BCSTAT_CONFACC,PL_BDWFLG_SUCC):
AfaDBFunc.RollbackSql()
return AfaFlowControl.ExitThisFlow('S999','新增确认付款－处理中失败，抛弃报文')
else:
AfaDBFunc.CommitSql()
#=================为存款确认请求报文做准备=================================
AfaLoggerFunc.tradeInfo(">>>开始为存款确认请求报文做准备")
#=====================获取中心流水号====================================
if rccpsGetFunc.GetRccSerialno( ) == -1 :
raise AfaFlowControl.flowException( )
TradeContext.MSGTYPCO = 'SET009'
TradeContext.SNDSTLBIN = TradeContext.RCVMBRCO
TradeContext.RCVSTLBIN = TradeContext.SNDMBRCO
TradeContext.SNDBRHCO = TradeContext.BESBNO
TradeContext.SNDCLKNO = TradeContext.BETELR
TradeContext.ORMFN = TradeContext.ORMFN
TradeContext.OPRTYPNO = '30'
TradeContext.ROPRTPNO = '30'
TradeContext.TRANTYP = '0'
TradeContext.ORTRCCO = '3000505'
TradeContext.ORTRCNO = TradeContext.TRCNO
TradeContext.TRCCO = '3000503'
TradeContext.TRCNO = TradeContext.SerialNo
TradeContext.CURPIN = ""
TradeContext.STRINFO = '收到补正应答,自动发送存款确认'
AfaLoggerFunc.tradeInfo(">>>交易代码["+str(TradeContext.TRCCO)+"]")
AfaLoggerFunc.tradeInfo(">>>结束为存款确认请求报文做准备")
#=====更新原记录的存款确认字段====
#=====modify by pgt 12-8====
wtr_up_where = {'BJEDTE':wtrbka_temp_dict['BJEDTE'],'BSPSQN':wtrbka_temp_dict['BSPSQN']}
# wtr_up_where = {'BJEDTE':TradeContext.BJEDTE,'BSPSQN':TradeContext.BSPSQN}
wtr_end_dict = {}
wtr_end_dict['COTRCDAT'] = TradeContext.TRCDAT
wtr_end_dict['COTRCNO'] = TradeContext.TRCNO
wtr_end_dict['TRCNO'] = TradeContext.ORTRCNO
wtr_end_dict['COMSGFLGNO']= TradeContext.SNDBNKCO+TradeContext.TRCDAT+TradeContext.TRCNO
wtr_end_dict['MSGFLGNO'] = TradeContext.MSGFLGNO
rccpsDBTrcc_wtrbka.update(wtr_end_dict,wtr_up_where)
AfaDBFunc.CommitSql()
AfaAfeFunc.CommAfe()
if TradeContext.errorCode == '0000':
AfaLoggerFunc.tradeInfo('>>>发送成功')
else:
AfaLoggerFunc.tradeInfo('>>>发送失败')
return True
def SubModuleDoTrd():
AfaLoggerFunc.tradeInfo( '***农信银系统：往账.主机类操作(3.中心记账).行内账户转异地[TRCC002_8563]进入***' )
#=================设置业务状态为发送成功或失败,若发送失败则自动抹账========
stat_dict = {}
stat_dict['BJEDTE'] = TradeContext.BJEDTE
stat_dict['BSPSQN'] = TradeContext.BSPSQN
stat_dict['BESBNO'] = TradeContext.BESBNO
stat_dict['BETELR'] = TradeContext.BETELR
stat_dict['BCSTAT'] = PL_BCSTAT_SND
stat_dict['BDWFLG'] = PL_BDWFLG_SUCC
stat_dict['PRCCO'] = TradeContext.errorCode
stat_dict['STRINFO'] = TradeContext.errorMsg
AfaLoggerFunc.tradeInfo("TradeContext.errorCode = [" + TradeContext.errorCode + "]")
if TradeContext.errorCode == '0000':
AfaLoggerFunc.tradeInfo(">>>开始设置业务状态为发送成功")
stat_dict['BCSTAT'] = PL_BCSTAT_SND
stat_dict['BDWFLG'] = PL_BDWFLG_SUCC
if not rccpsState.setTransState(stat_dict):
return AfaFlowControl.ExitThisFlow('S999', "设置业务状态为发送成功异常")
AfaLoggerFunc.tradeInfo(">>>结束设置业务状态为发送成功")
else:
AfaLoggerFunc.tradeInfo(">>>开始设置业务状态为发送失败")
stat_dict['BCSTAT'] = PL_BCSTAT_SND
stat_dict['BDWFLG'] = PL_BDWFLG_FAIL
if not rccpsState.setTransState(stat_dict):
return AfaFlowControl.ExitThisFlow('S999', "设置业务状态为发送失败异常")
AfaLoggerFunc.tradeInfo(">>>结束设置业务状态为发送失败")
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
return AfaFlowControl.ExitThisFlow("S999","Commit异常")
#=============发起主机抹账=============================================
AfaLoggerFunc.tradeInfo(">>>开始设置业务状态为抹账处理中")
#=====特殊处理 关彬捷 20081127 调8813抹账,需产生新的前置流水号进行记账====
if rccpsGetFunc.GetRBSQ(PL_BRSFLG_SND) == -1 :
return AfaFlowControl.ExisThisFlow('S999',"产生新的前置流水号异常")
#为抹账会计分录赋值
if TradeContext.CHRGTYP == '0':
#现金收取
AfaLoggerFunc.tradeInfo(">>>现金收取手续费")
TradeContext.HostComm = '8813'
TradeContext.ACUR = '2' #重复次数
TradeContext.PKFG = 'T' #通存通兑标识
TradeContext.OCCAMT = "-" + str(TradeContext.OCCAMT) #出票金额
TradeContext.RCCSMCD = PL_RCCSMCD_BZYWZ #主机摘要码:本转异往账
TradeContext.SBAC = TradeContext.PYRACC #借方账号:客户账
TradeContext.ACNM = TradeContext.PYRNAM #借方户名
TradeContext.RBAC = TradeContext.BESBNO + PL_ACC_NXYDQSWZ #贷方账号:汇出汇款
TradeContext.RBAC = rccpsHostFunc.CrtAcc(TradeContext.RBAC,25)
TradeContext.OTNM = "农信银待清算往账"
TradeContext.PASSWD = TradeContext.PASSWD #付款人密码
if TradeContext.PYRTYP == '0':
TradeContext.WARNTNO = TradeContext.SBAC[6:18]
TradeContext.CERTTYPE = TradeContext.CERTTYPE #证件类型
TradeContext.CERTNO = TradeContext.CERTNO #证件号码
TradeContext.CTFG = '7' #本金标识:本金-1
AfaLoggerFunc.tradeInfo("借方账号1:[" + TradeContext.SBAC + "]")
AfaLoggerFunc.tradeInfo("贷方账号1:[" + TradeContext.RBAC + "]")
AfaLoggerFunc.tradeInfo("凭证号码1:[" + TradeContext.WARNTNO + "]")
TradeContext.I2PKFG = 'T' #通存通兑标识
TradeContext.I2RVFG = '2' #红蓝字标志 2
TradeContext.I2CATR = '0' #现转标识:0-现金
TradeContext.I2TRAM = str(TradeContext.LOCCUSCHRG) #手续费金额
TradeContext.I2SMCD = PL_RCCSMCD_SXF #主机摘要码:手续费
TradeContext.I2SBAC = "" #借方账号:柜员尾箱
TradeContext.I2ACNM = ""
TradeContext.I2RBAC = TradeContext.BESBNO + PL_ACC_TCTDSXF #贷方账号:通存通兑手续费
TradeContext.I2RBAC = rccpsHostFunc.CrtAcc(TradeContext.I2RBAC,25)
TradeContext.I2OTNM = "手续费"
TradeContext.I2CTFG = '8' #本金标识:手续费-0
AfaLoggerFunc.tradeInfo("借方账号2:[" + TradeContext.I2SBAC + "]")
AfaLoggerFunc.tradeInfo("贷方账号2:[" + TradeContext.I2RBAC + "]")
else:
TradeContext.HostCode='8820'
TradeContext.BOJEDT = TradeContext.BJEDTE
TradeContext.BOSPSQ = TradeContext.BSPSQN
#====设置业务状态为抹账处理中====
if not rccpsState.newTransState(TradeContext.BJEDTE,TradeContext.BSPSQN,PL_BCSTAT_HCAC,PL_BDWFLG_WAIT):
return AfaFlowControl.ExitThisFlow('S999','设置业务状态为抹账处理中异常')
AfaLoggerFunc.tradeInfo(">>>结束设置业务状态为抹账处理中")
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
return AfaFlowControl.ExitThisFlow("S999","Commit异常")
#====自动抹账====
AfaLoggerFunc.tradeInfo(">>>开始发起主机抹账")
#=====调起抹账主机接口====
rccpsHostFunc.CommHost( TradeContext.HostCode )
AfaLoggerFunc.tradeInfo(">>>结束发起主机抹账")
stat_dict = {}
stat_dict['BJEDTE'] = TradeContext.BJEDTE
stat_dict['BSPSQN'] = TradeContext.BSPSQN
stat_dict['MGID'] = TradeContext.errorCode
stat_dict['STRINFO'] = TradeContext.errorMsg
AfaLoggerFunc.tradeInfo("TradeContext.errorCode = [" + TradeContext.errorCode + "]")
if TradeContext.errorCode == '0000':
AfaLoggerFunc.tradeInfo(">>>开始设置业务状态为抹账成功")
stat_dict['BCSTAT'] = PL_BCSTAT_HCAC
stat_dict['BDWFLG'] = PL_BDWFLG_SUCC
stat_dict['TRDT'] = TradeContext.TRDT
stat_dict['TLSQ'] = TradeContext.TLSQ
stat_dict['PRTCNT'] = 1 #打印次数
if not rccpsState.setTransState(stat_dict):
return AfaFlowControl.ExitThisFlow('S999','设置业务状态抹账成功异常')
AfaLoggerFunc.tradeInfo(">>>结束设置业务状态为抹账成功")
else:
AfaLoggerFunc.tradeInfo(">>>开始设置业务状态为抹账失败")
stat_dict['BCSTAT'] = PL_BCSTAT_HCAC
stat_dict['BDWFLG'] = PL_BDWFLG_FAIL
if not rccpsState.setTransState(stat_dict):
return AfaFlowControl.ExitThisFlow('S999','设置业务状态抹账成功异常')
AfaLoggerFunc.tradeInfo(">>>结束设置业务状态为抹账失败")
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
return AfaFlowControl.ExitThisFlow("S999","Commit异常")
AfaLoggerFunc.tradeInfo( '***农信银系统：往账.主机类操作(3.中心记账).行内账户转异地[TRCC002_8563]退出***' )
return True
def SubModuleDoFst():
AfaLoggerFunc.tradeInfo( '***农信银系统：来账.中心类操作(1.本地操作).折通兑来帐请求报文接收[TRCC006_1140]进入***' )
#初始化返回码
TradeContext.PRCCO = 'RCCI0000'
TradeContext.STRINFO = "成功"
#判断是否重复报文
AfaLoggerFunc.tradeInfo(">>>开始判断是否重复报文")
sel_dict = {'COTRCNO':TradeContext.TRCNO,'COTRCDAT':TradeContext.TRCDAT,'SNDBNKCO':TradeContext.SNDBNKCO}
record = rccpsDBTrcc_wtrbka.selectu(sel_dict)
if record == None:
AfaLoggerFunc.tradeDebug('>>>判断是否重复扣款确认报文,查询通存通兑业务登记簿相同报文异常')
TradeContext.PRCCO = "NN1ID999"
TradeContext.STRINFO = "数据库其他错误"
elif len(record) > 0:
AfaLoggerFunc.tradeInfo('通存通兑业务登记簿中存在相同数据,重复报文,返回拒绝应答报文')
TradeContext.PRCCO = 'NN1ISO999'
TradeContext.STRINFO = "重复报文"
AfaLoggerFunc.tradeInfo(">>>结束判断是否重复报文")
#登记通存通兑登记簿
AfaLoggerFunc.tradeInfo(">>>开始登记通存通兑业务登记簿")
#=====币种转换====
if TradeContext.CUR == 'CNY':
TradeContext.CUR = '01'
#=====手续费收取方式=====
if float(TradeContext.CUSCHRG) > 0.001:
TradeContext.CHRGTYP = '1'
else:
TradeContext.CHRGTYP = '0'
#====开始向字典赋值====
if TradeContext.PRCCO == 'RCCI0000':
wtrbka_dict = {}
if not rccpsMap1140CTradeContext2Dwtrbka_dict.map(wtrbka_dict):
AfaLoggerFunc.tradeDebug('>>>字典赋值出错')
TradeContext.PRCCO = "NN1ID999"
TradeContext.STRINFO = "数据库其他错误"
wtrbka_dict['DCFLG'] = PL_DCFLG_DEB #借贷标识
wtrbka_dict['OPRNO'] = PL_TDOPRNO_TD #业务种类
#=====开始插入数据库====
if TradeContext.PRCCO == 'RCCI0000':
if not rccpsDBFunc.insTransWtr(wtrbka_dict):
AfaLoggerFunc.tradeDebug('>>>登记通存通兑业务登记簿异常')
TradeContext.PRCCO = "NN1ID999"
TradeContext.STRINFO = "数据库其他错误"
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
TradeContext.PRCCO = "NN1ID999"
TradeContext.STRINFO = "数据库其他错误"
AfaLoggerFunc.tradeInfo(">>>结束登记通存通兑业务登记簿")
#设置业务状态为行内收妥成功
AfaLoggerFunc.tradeInfo(">>>开始设置业务状态为收妥成功")
stat_dict = {}
stat_dict['BSPSQN'] = TradeContext.BSPSQN
stat_dict['BJEDTE'] = TradeContext.BJEDTE
stat_dict['BCSTAT'] = PL_BCSTAT_BNKRCV
stat_dict['BDWFLG'] = PL_BDWFLG_SUCC
if TradeContext.PRCCO == 'RCCI0000':
if not rccpsState.setTransState(stat_dict):
AfaLoggerFunc.tradeDebug('>>>设置业务状态收妥成功异常')
TradeContext.PRCCO = "NN1ID999"
TradeContext.STRINFO = "数据库其他错误"
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
TradeContext.PRCCO = "NN1ID999"
TradeContext.STRINFO = "数据库其他错误"
AfaLoggerFunc.tradeInfo(">>>结束设置业务状态为收妥成功")
#设置业务状态为自动扣款处理中
AfaLoggerFunc.tradeInfo(">>>开始设置业务状态为自动扣款处理中")
if TradeContext.PRCCO == 'RCCI0000':
if not rccpsState.newTransState(TradeContext.BJEDTE,TradeContext.BSPSQN,PL_BCSTAT_AUTOPAY,PL_BDWFLG_WAIT):
AfaLoggerFunc.tradeDebug('>>>设置业务状态为自动扣款处理中异常')
TradeContext.PRCCO = "NN1ID999"
TradeContext.STRINFO = "数据库其他错误"
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
TradeContext.PRCCO = "NN1ID999"
TradeContext.STRINFO = "数据库其他错误"
AfaLoggerFunc.tradeInfo(">>>开始设置业务状态为自动扣款处理中")
TradeContext.BCSTAT = PL_BCSTAT_AUTOPAY #状态:自动扣款
TradeContext.BCSTATNM = "自动扣款"
#进行必要性检查,若校验通过,则返回成功应答报文,若校验未通过,则返回拒绝应答报文
AfaLoggerFunc.tradeInfo(">>>开始必要性检查")
#检查冲正登记簿中是否有此笔业务的冲正业务,存在则返回拒绝应答报文,并设置业务状态为冲正处理中
if TradeContext.PRCCO == 'RCCI0000':
atcbka_where_dict = {}
atcbka_where_dict['ORMFN'] = TradeContext.MSGFLGNO
atcbka_dict = rccpsDBTrcc_atcbka.selectu(atcbka_where_dict)
if atcbka_dict == None:
AfaLoggerFunc.tradeInfo(">>>查询冲正登记簿异常")
TradeContext.PRCCO = 'NN1ID999'
TradeContext.STRINFO = "查询冲正登记簿异常"
TradeContext.BCSTAT = PL_BCSTAT_MFERFE
TradeContext.BCSTATNM = "拒绝"
else:
if len(atcbka_dict) <= 0:
AfaLoggerFunc.tradeInfo(">>>此交易未被冲正,继续校验")
else:
AfaLoggerFunc.tradeInfo(">>>此交易已被冲正,返回拒绝应答报文")
TradeContext.PRCCO = 'NN1IO307'
TradeContext.STRINFO = "此交易已被冲正"
TradeContext.BCSTAT = PL_BCSTAT_MFERFE
TradeContext.BCSTATNM = "拒绝"
#解密客户密码
if TradeContext.PRCCO == 'RCCI0000':
MIMA = ' '
PIN = TradeContext.CURPIN
ACC = TradeContext.PYRACC
AfaLoggerFunc.tradeDebug('密码[' + PIN + ']')
AfaLoggerFunc.tradeDebug('账号[' + ACC + ']')
ret = jiami.secDecryptPin(PIN,ACC,MIMA)
if ret != 0:
AfaLoggerFunc.tradeDebug("ret=[" + str(ret) + "]")
AfaLoggerFunc.tradeDebug('调用加密服务器失败')
TradeContext.PRCCO = 'NN1IS999'
TradeContext.STRINFO = "解密密码失败"
TradeContext.BCSTAT = PL_BCSTAT_MFERFE
TradeContext.BCSTATNM = "拒绝"
else:
TradeContext.CURPIN = MIMA
AfaLoggerFunc.tradeDebug('密码new[' + TradeContext.CURPIN + ']')
#唐斌新增#
sql = "SELECT ischkactname,ischklate FROM rcc_chlabt where transcode='"+TradeContext.TransCode+"' and channelno= '"+(TradeContext.SNDCLKNO)[6:8]+"'"
AfaLoggerFunc.tradeInfo(sql)
records = AfaDBFunc.SelectSql( sql)
if (records == None):
return False
elif (len(records) == 0):
AfaLoggerFunc.tradeDebug("查询结果为空,查询条件[" + sql + "]")
return False
AfaLoggerFunc.tradeDebug(str(records))
#校验账户状态是否正常和账号户名是否相符
if TradeContext.PRCCO == 'RCCI0000':
#调用主机接口查询账户信息
TradeContext.HostCode = '8810'
TradeContext.ACCNO = TradeContext.PYRACC
AfaLoggerFunc.tradeDebug("gbj test :" + TradeContext.ACCNO)
rccpsHostFunc.CommHost( TradeContext.HostCode )
if TradeContext.errorCode != '0000':
#return AfaFlowControl.ExitThisFlow(TradeContext.errorCode,TradeContext.errorMsg)
AfaLoggerFunc.tradeInfo("查询账户信息异常,主机返回码[" + TradeContext.errorCode + "],主机返回信息[" + TradeContext.errorMsg +"]")
#TradeContext.PRCCO = 'NN1IA999'
TradeContext.PRCCO = rccpsDBFunc.HostErr2RccErr(TradeContext.errorCode)
TradeContext.STRINFO = TradeContext.errorMsg
TradeContext.BCSTAT = PL_BCSTAT_MFERFE
TradeContext.BCSTATNM = "拒绝"
else:
#查询成功,更新通存通兑登记簿账务机构号
AfaLoggerFunc.tradeInfo(">>>查询主机账户成功")
#if( TradeContext.BESBNO != PL_BESBNO_BCLRSB ):
# AfaLoggerFunc.tradeInfo(">>>" + TradeContext.BESBNO + ">>>" + TradeContext.ACCSO)
# if( TradeContext.BESBNO[:6] != TradeContext.ACCSO[:6] ):
# AfaLoggerFunc.tradeInfo(">>>不许跨法人做此交易")
# TradeContext.PRCCO = 'NN1IO999'
# TradeContext.STRINFO = "接收行与账户开户行不属于同一法人"
# TradeContext.BCSTAT = PL_BCSTAT_MFERFE
# TradeContext.BCSTATNM = "拒绝"
#检查本机构是否有通存通兑业务权限
if not rccpsDBFunc.chkTDBESAuth(TradeContext.ACCSO):
TradeContext.PRCCO = 'NN1IO999'
TradeContext.STRINFO = "本账户开户机构无通存通兑业务权限"
TradeContext.BCSTAT = PL_BCSTAT_MFERFE
TradeContext.BCSTATNM = "拒绝"
AfaLoggerFunc.tradeInfo(">>>开始更新机构号为开户机构")
TradeContext.BESBNO = TradeContext.ACCSO
wtrbka_update_dict = {'BESBNO':TradeContext.ACCSO}
wtrbka_where_dict = {'BJEDTE':TradeContext.BJEDTE,'BSPSQN':TradeContext.BSPSQN}
ret = rccpsDBTrcc_wtrbka.updateCmt(wtrbka_update_dict,wtrbka_where_dict)
if ret <= 0:
AfaLoggerFunc.tradeInfo(">>>更新机构号为开户机构异常")
TradeContext.PRCCO = 'NN1ID006'
TradeContext.STRINFO = "更新账务机构号异常"
TradeContext.BCSTAT = PL_BCSTAT_MFERFE
TradeContext.BCSTATNM = "拒绝"
else:
AfaLoggerFunc.tradeInfo(">>>更新机构号为开户机构成功")
AfaLoggerFunc.tradeDebug("主机返回户名ACCNM :[" + TradeContext.ACCNM + "]")
AfaLoggerFunc.tradeDebug("报文接收户名PYRNAM:[" + TradeContext.PYRNAM + "]")
AfaLoggerFunc.tradeDebug("主机返回账户状态ACCST:[" + TradeContext.ACCST + "]")
AfaLoggerFunc.tradeDebug("证件类型ACITY:[" + TradeContext.ACITY + "]")
AfaLoggerFunc.tradeDebug("证件号码ACINO:[" + TradeContext.ACINO + "]")
if TradeContext.ACCNM != TradeContext.PYRNAM:
#唐斌新增#
if(records[0][0]=='1'):
AfaLoggerFunc.tradeInfo(">>>账号户名不符")
TradeContext.PRCCO = 'NN1IA102'
TradeContext.STRINFO = '账号户名不符'
TradeContext.BCSTAT = PL_BCSTAT_MFERFE
TradeContext.BCSTATNM = "拒绝"
elif TradeContext.ACCST != '0' and TradeContext.ACCST != '2':
AfaLoggerFunc.tradeInfo(">>>账户状态不正常")
TradeContext.PRCCO = 'NN1IA999'
TradeContext.STRINFO = '账户状态不正常'
TradeContext.BCSTAT = PL_BCSTAT_MFERFE
TradeContext.BCSTATNM = "拒绝"
elif not (TradeContext.ACCCD == '0428' and TradeContext.ACCEM == '21111'):
AfaLoggerFunc.tradeInfo(">>>此账户非个人结算户")
TradeContext.PRCCO = 'NN1IA999'
TradeContext.STRINFO = '此账户非个人结算户'
TradeContext.BCSTAT = PL_BCSTAT_MFERFE
TradeContext.BCSTATNM = "拒绝"
#=====交易金额判断====
chk_dict = {}
chk_dict['BPARAD'] = 'TD001' #通存通兑凭证金额校验
dict = rccpsDBTrcc_pamtbl.selectu(chk_dict)
AfaLoggerFunc.tradeInfo('dict='+str(dict))
if dict == None:
AfaLoggerFunc.tradeInfo(">>>校验交易金额失败")
TradeContext.PRCCO = 'NN1ID003'
TradeContext.STRINFO = '校验交易金额失败'
TradeContext.BCSTAT = PL_BCSTAT_MFERFE
TradeContext.BCSTATNM = "拒绝"
if len(dict) == 0:
AfaLoggerFunc.tradeInfo(">>>查询PAMTBL校验交易金额表记录错误")
TradeContext.PRCCO = 'NN1ID010'
TradeContext.STRINFO = '查询PAMTBL校验交易金额表记录错误'
TradeContext.BCSTAT = PL_BCSTAT_MFERFE
TradeContext.BCSTATNM = "拒绝"
#=====判断农信银中心规定校验凭证上线====
if float(TradeContext.OCCAMT) > float(dict['BPADAT']):
#=====交易金额大于农信银中心规定金额，需要输入证件====
if TradeContext.existVariable('CERTTYPE') and len(TradeContext.CERTTYPE) == 0:
AfaLoggerFunc.tradeInfo(">>>请选择证件类型")
TradeContext.PRCCO = 'NN1IA999'
TradeContext.STRINFO = '请选择证件类型'
TradeContext.BCSTAT = PL_BCSTAT_MFERFE
TradeContext.BCSTATNM = "拒绝"
elif(TradeContext.CERTTYPE == '06'):
if( TradeContext.ACITY != '06' and TradeContext.ACITY != '07' and TradeContext.ACITY != '08' and TradeContext.ACITY != '09'):
AfaLoggerFunc.tradeInfo(">>>证件类型错误")
TradeContext.PRCCO = 'NN1IA999'
TradeContext.STRINFO = '证件类型错误'
TradeContext.BCSTAT = PL_BCSTAT_MFERFE
TradeContext.BCSTATNM = "拒绝"
elif( TradeContext.CERTTYPE != TradeContext.ACITY ):
AfaLoggerFunc.tradeInfo(">>>证件类型错误")
TradeContext.PRCCO = 'NN1IA999'
TradeContext.STRINFO = '证件类型错误'
TradeContext.BCSTAT = PL_BCSTAT_MFERFE
TradeContext.BCSTATNM = "拒绝"
if TradeContext.existVariable('CERTNO') and len(TradeContext.CERTNO) == 0:
AfaLoggerFunc.tradeInfo(">>>请输入证件号码")
TradeContext.PRCCO = 'NN1IA999'
TradeContext.STRINFO = '请输入证件号码'
TradeContext.BCSTAT = PL_BCSTAT_MFERFE
TradeContext.BCSTATNM = "拒绝"
elif( TradeContext.CERTNO != TradeContext.ACINO ):
AfaLoggerFunc.tradeInfo(">>>证件号码错误")
TradeContext.PRCCO = 'NN1IA999'
TradeContext.STRINFO = '证件号码错误'
TradeContext.BCSTAT = PL_BCSTAT_MFERFE
TradeContext.BCSTATNM = "拒绝"
#校验交易金额是否超当日限额
if not rccpsDBFunc.chkLimited(TradeContext.BJEDTE,TradeContext.PYRACC,TradeContext.OCCAMT):
AfaLoggerFunc.tradeInfo(">>>交易金额超限")
TradeContext.PRCCO = 'NN1IA999'
TradeContext.STRINFO = '交易金额超限'
TradeContext.BCSTAT = PL_BCSTAT_MFERFE
TradeContext.BCSTATNM = "拒绝"
AfaLoggerFunc.tradeInfo(">>>结束必要性检查")
#发起主机记账
AfaLoggerFunc.tradeInfo(">>>开始发起主机记账")
TradeContext.sCertType = TradeContext.CERTTYPE
TradeContext.sCertNo = TradeContext.CERTNO
TradeContext.sOccamt = TradeContext.OCCAMT
TradeContext.sCuschrg = TradeContext.CUSCHRG
AfaLoggerFunc.tradeInfo(">>>" + TradeContext.PRCCO)
if TradeContext.PRCCO == 'RCCI0000':
TradeContext.HostCode = '8813' #调用8813主机接口
#TradeContext.PASSWD = TradeContext.CURPIN
#来账对方现金收取手续费
if( TradeContext.CHRGTYP != '1' ):
TradeContext.RCCSMCD = PL_RCCSMCD_XJTDLZ #主机摘要代码
TradeContext.SBAC = TradeContext.PYRACC #借方账户:付款人账户
TradeContext.ACNM = TradeContext.PYRNAM #借方户名 付款人户名
TradeContext.RBAC = TradeContext.BESBNO + PL_ACC_NXYDQSLZ #贷方账户:农信银待清算来账
TradeContext.RBAC = rccpsHostFunc.CrtAcc(TradeContext.RBAC, 25)
TradeContext.OTNM = '农信银待清算来账' #贷方户名:
TradeContext.CTFG = '7' #本金 手续费标识 7 本金 8手续费 9 本金＋手续费
TradeContext.PKFG = 'T' #通存通兑标识
TradeContext.WARNTNO = '49' + TradeContext.BNKBKNO
TradeContext.CERTTYPE = ''
TradeContext.CERTNO = ''
TradeContext.PASSWD = TradeContext.CURPIN #密码
AfaLoggerFunc.tradeInfo( '借方账号:' + TradeContext.SBAC )
AfaLoggerFunc.tradeInfo( '贷方账号:' + TradeContext.RBAC )
AfaLoggerFunc.tradeInfo( '凭证号码:' + TradeContext.WARNTNO )
else:
#对方转账收取手续费时s
TradeContext.ACUR = '3' #记账次数
#=========交易金额============
TradeContext.RCCSMCD = PL_RCCSMCD_XJTDLZ #摘要代码
TradeContext.SBAC = TradeContext.PYRACC #借方账号
TradeContext.ACNM = TradeContext.PYRNAM #借方户名
TradeContext.RBAC = TradeContext.BESBNO + PL_ACC_NXYDJLS #贷方账号
TradeContext.RBAC = rccpsHostFunc.CrtAcc(TradeContext.RBAC,25)
TradeContext.OTNM = '待解临时款项' #贷方户名
TradeContext.OCCAMT = str(TradeContext.sOccamt) #发生额
TradeContext.CTFG = '7' #本金 手续费标识 7 本金 8手续费 9 本金＋手续费
TradeContext.PKFG = 'T' #通存通兑标识
TradeContext.WARNTNO = '49' + TradeContext.BNKBKNO
TradeContext.PASSWD = TradeContext.CURPIN #密码
TradeContext.sCertType = TradeContext.CERTTYPE
TradeContext.sCertNo = TradeContext.CERTNO
TradeContext.CERTTYPE = ''
TradeContext.CERTNO = ''
AfaLoggerFunc.tradeInfo( '>>>交易金额:借方账号' + TradeContext.SBAC )
AfaLoggerFunc.tradeInfo( '>>>交易金额:贷方账号' + TradeContext.RBAC )
AfaLoggerFunc.tradeInfo( '凭证号码:' + TradeContext.WARNTNO )
#=========结算手续费收入户===========
TradeContext.I2SMCD = PL_RCCSMCD_SXF #摘要代码
TradeContext.I2SBAC = TradeContext.PYRACC #借方账号
TradeContext.I2ACNM = TradeContext.PYRNAM #借方户名
TradeContext.I2RBAC = TradeContext.BESBNO + PL_ACC_NXYDJLS #贷方账号
TradeContext.I2RBAC = rccpsHostFunc.CrtAcc(TradeContext.I2RBAC,25)
TradeContext.I2OTNM = '待解临时款项' #贷方户名
TradeContext.I2TRAM = str(TradeContext.sCuschrg) #发生额
TradeContext.I2CTFG = '8' #本金 手续费标识 7 本金 8手续费 9 本金＋手续费
TradeContext.I2PKFG = 'T' #通存通兑标识
TradeContext.I2WARNTNO = '49' + TradeContext.BNKBKNO
TradeContext.I2PASSWD = TradeContext.CURPIN #密码
AfaLoggerFunc.tradeInfo( '>>>结算手续费收入户:借方账号' + TradeContext.I2SBAC )
AfaLoggerFunc.tradeInfo( '>>>结算手续费收入户:贷方账号' + TradeContext.I2RBAC )
AfaLoggerFunc.tradeInfo( '凭证号码:' + TradeContext.I2WARNTNO )
#=========交易金额+手续费===================
TradeContext.I3SMCD = PL_RCCSMCD_XJTDLZ #摘要代码
TradeContext.I3SBAC = TradeContext.BESBNO + PL_ACC_NXYDJLS #借方账号
TradeContext.I3SBAC = rccpsHostFunc.CrtAcc(TradeContext.I3SBAC,25)
TradeContext.I3ACNM = '待解临时款项' #借方户名
TradeContext.I3RBAC = TradeContext.BESBNO + PL_ACC_NXYDQSLZ #贷方账号
TradeContext.I3RBAC = rccpsHostFunc.CrtAcc(TradeContext.I3RBAC,25)
TradeContext.I3OTNM = '农信银来账' #贷方户名
TradeContext.I3TRAM = rccpsUtilTools.AddDot(TradeContext.OCCAMT,TradeContext.CUSCHRG) #发生额
TradeContext.I3CTFG = '9' #本金 手续费标识 7 本金 8手续费 9 本金＋手续费
TradeContext.I3PKFG = 'T' #通存通兑标识
AfaLoggerFunc.tradeInfo( '>>>交易金额+手续费:借方账号' + TradeContext.I3SBAC )
AfaLoggerFunc.tradeInfo( '>>>交易金额+手续费:贷方账号' + TradeContext.I3RBAC )
rccpsHostFunc.CommHost( TradeContext.HostCode )
AfaLoggerFunc.tradeInfo(">>>结束发起主机记账")
#TradeContext.errorCode, TradeContext.errorMsg = '0000', '主机成功'
#根据主机返回码,设置业务状态为自动入账成功或失败
AfaLoggerFunc.tradeInfo(">>>开始根据主机放回码,设置业务状态为自动扣款成功或失败")
stat_dict = {}
stat_dict['BJEDTE'] = TradeContext.BJEDTE
stat_dict['BSPSQN'] = TradeContext.BSPSQN
stat_dict['BESBNO'] = TradeContext.BESBNO
stat_dict['BETELR'] = TradeContext.BETELR
stat_dict['SBAC'] = TradeContext.SBAC
stat_dict['ACNM'] = TradeContext.ACNM
stat_dict['RBAC'] = TradeContext.RBAC
stat_dict['OTNM'] = TradeContext.OTNM
#=====modify by pgt 1129====
stat_dict['MGID'] = TradeContext.errorCode
if TradeContext.existVariable('TRDT'):
stat_dict['TRDT'] = TradeContext.TRDT
if TradeContext.existVariable('TLSQ'):
stat_dict['TLSQ'] = TradeContext.TLSQ
stat_dict['STRINFO'] = TradeContext.errorMsg
AfaLoggerFunc.tradeInfo("主机返回码[" + TradeContext.errorCode + "],主机返回信息[" + TradeContext.errorMsg +"]")
if TradeContext.errorCode == '0000':
#=====发送农信银成功,设置状态为自动入账成功====
stat_dict['BCSTAT'] = PL_BCSTAT_AUTOPAY
stat_dict['BDWFLG'] = PL_BDWFLG_SUCC
TradeContext.PRCCO = 'RCCI0000'
TradeContext.STRINFO = '成功'
if not rccpsState.setTransState(stat_dict):
return AfaFlowControl.ExitThisFlow('S999', "设置业务状态为自动入账成功异常")
AfaLoggerFunc.tradeInfo(">>>设置业务状态为自动扣款成功完成")
else:
#=====发送农信银失败,设置状态为拒绝成功====
stat_dict['BCSTAT'] = PL_BCSTAT_MFERFE
stat_dict['BDWFLG'] = PL_BDWFLG_SUCC
#TradeContext.PRCCO = 'NN1CA999'
TradeContext.PRCCO = rccpsDBFunc.HostErr2RccErr(TradeContext.errorCode)
AfaLoggerFunc.tradeInfo(">>>>>>>>>>>>>>>>>>>>" + TradeContext.PRCCO)
TradeContext.STRINFO = TradeContext.errorMsg
if not rccpsState.setTransState(stat_dict):
AfaLoggerFunc.tradeFatal( '设置业务状态为拒绝成功异常' )
TradeContext.PRCCO = "NN1ID999"
TradeContext.STRINFO = "数据库其他错误"
AfaLoggerFunc.tradeInfo(">>>设置业务状态为拒绝成功完成")
else:
stat_dict = {}
stat_dict['BJEDTE'] = TradeContext.BJEDTE
stat_dict['BSPSQN'] = TradeContext.BSPSQN
stat_dict['BESBNO'] = TradeContext.BESBNO
stat_dict['BETELR'] = TradeContext.BETELR
stat_dict['PRCCO'] = TradeContext.PRCCO
stat_dict['STRINFO'] = TradeContext.STRINFO
stat_dict['BCSTAT'] = PL_BCSTAT_MFERFE
stat_dict['BDWFLG'] = PL_BDWFLG_SUCC
if not rccpsState.setTransState(stat_dict):
AfaLoggerFunc.tradeFatal( '设置业务状态为拒绝成功异常' )
TradeContext.PRCCO = "NN1ID999"
TradeContext.STRINFO = "数据库其他错误"
AfaLoggerFunc.tradeInfo(">>>设置业务状态为拒绝成功完成")
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
TradeContext.PRCCO = "NN1ID999"
TradeContext.STRINFO = "数据库其他错误"
AfaLoggerFunc.tradeInfo(">>>开始根据主机放回码,设置业务状态为自动入账成功或失败")
#为自动扣款应答报文赋值
TradeContext.sysType = 'rccpst'
TradeContext.MSGTYPCO = 'SET007' #报文类代码
#TradeContext.RCVMBRCO = TradeContext.SNDMBRCO #接收方成员行号
TradeContext.RCVSTLBIN = TradeContext.SNDMBRCO #收款方成员行号
TradeContext.SNDSTLBIN = TradeContext.RCVMBRCO #付款方成员行号
TradeContext.SNDBRHCO = TradeContext.BESBNO #发起行网点号
TradeContext.SNDCLKNO = TradeContext.BETELR #发起行柜员号
TradeContext.SNDTRDAT = TradeContext.BJEDTE #发起行交易日期
TradeContext.SNDTRTIM = TradeContext.BJETIM #发起行交易时间
TradeContext.ORMFN = TradeContext.MSGFLGNO #参考报文标识号
TradeContext.MSGFLGNO = TradeContext.SNDMBRCO + TradeContext.BJEDTE + TradeContext.SerialNo #报文标识号
TradeContext.NCCWKDAT = TradeContext.NCCworkDate #中心工作日期
TradeContext.OPRTYPNO = '30' #业务类型
TradeContext.ROPRTPNO = TradeContext.OPRTYPNO #参考业务类型
TradeContext.TRANTYP = '0' #传输类型
TradeContext.CERTTYPE = TradeContext.sCertType
TradeContext.CERTNO = TradeContext.sCertNo
TradeContext.OCCAMT = TradeContext.sOccamt
TradeContext.CUSCHRG = TradeContext.sCuschrg
TradeContext.CUR = 'CNY' #货币符号
AfaLoggerFunc.tradeInfo( '***农信银系统：来账.中心类操作(1.本地操作).折通兑来帐请求报文接收[TRCC006_1140]退出***' )
return True
def SubModuleDoFst():
time.sleep(10)
AfaLoggerFunc.tradeInfo('>>>进入撤销应答接收')
#==========判断是否重复报文,如果是重复报文,直接进入下一流程================
AfaLoggerFunc.tradeInfo(">>>开始检查是否重复报文")
trccan_where_dict = {}
trccan_where_dict['SNDBNKCO'] = TradeContext.SNDBNKCO
trccan_where_dict['TRCDAT'] = TradeContext.TRCDAT
trccan_where_dict['TRCNO'] = TradeContext.TRCNO
trc_dict = rccpsDBTrcc_trccan.selectu(trccan_where_dict)
if trc_dict == None:
return AfaFlowControl.ExitThisFlow("S999","校验重复报文异常")
if len(trc_dict) > 0:
AfaLoggerFunc.tradeInfo("汇兑查询查复自由格式登记簿中存在相同查复交易,此报文为重复报文,进入下一流程,发送表示成功的通讯回执")
#======为通讯回执报文赋值===============================================
out_context_dict = {}
out_context_dict['TRCCO'] = '9900503'
out_context_dict['MSGTYPCO'] = 'SET008'
out_context_dict['RCVMBRCO'] = TradeContext.SNDMBRCO
out_context_dict['SNDMBRCO'] = TradeContext.RCVMBRCO
out_context_dict['SNDBRHCO'] = TradeContext.BESBNO
out_context_dict['SNDCLKNO'] = TradeContext.BETELR
out_context_dict['SNDTRDAT'] = TradeContext.BJEDTE
out_context_dict['SNDTRTIM'] = TradeContext.BJETIM
out_context_dict['MSGFLGNO'] = out_context_dict['SNDMBRCO'] + TradeContext.BJEDTE + TradeContext.SerialNo
out_context_dict['ORMFN'] = TradeContext.MSGFLGNO
out_context_dict['NCCWKDAT'] = TradeContext.NCCworkDate
out_context_dict['OPRTYPNO'] = '99'
out_context_dict['ROPRTPNO'] = TradeContext.OPRTYPNO
out_context_dict['TRANTYP'] = '0'
out_context_dict['ORTRCCO'] = TradeContext.TRCCO
out_context_dict['PRCCO'] = 'RCCI0000'
out_context_dict['STRINFO'] = '重复报文'
rccpsMap0000Dout_context2CTradeContext.map(out_context_dict)
TradeContext.SNDSTLBIN = TradeContext.RCVMBRCO #发起成员行号
return True
AfaLoggerFunc.tradeInfo(">>>结束检查是否重复报文")
#==========根据发送行号,委托日期,交易流水号查询原交易信息===========
AfaLoggerFunc.tradeInfo(">>>开始根据发送行号,委托日期,交易流水号查询交易信息")
dict_where = {}
dict_where['SNDBNKCO'] = TradeContext.OQTSBNK
dict_where['TRCDAT'] = TradeContext.OCADAT
dict_where['TRCNO'] = TradeContext.OCATNO
dict = rccpsDBTrcc_trccan.selectu(dict_where)
if dict == None:
return AfaFlowControl.ExitThisFlow("S999","校验重复报文异常")
tran_dict_where = {}
tran_dict_where['BJEDTE'] = dict['BOJEDT']
tran_dict_where['BSPSQN'] = dict['BOSPSQ']
tran_dict = rccpsDBTrcc_trcbka.selectu(tran_dict_where)
if tran_dict <= 0:
return AfaFlowControl.ExitThisFlow("S999","未找到原交易")
AfaLoggerFunc.tradeInfo(">>>结束根据发送行号,委托日期,交易流水号查询交易信息")
#=====从TradeContext向字典trccan_dict赋值====
TradeContext.BBSSRC = tran_dict['BBSSRC']
TradeContext.BOJEDT = dict['BJEDTE']
TradeContext.BOSPSQ = dict['BSPSQN']
TradeContext.ORTRCCO = dict['TRCCO']
TradeContext.CUR = '01'
TradeContext.OCCAMT = str(dict['OCCAMT'])
AfaLoggerFunc.tradeDebug('>>>资金来源['+TradeContext.BBSSRC+']')
trccan_dict = {}
if not rccpsMap1106CTradeContext2Dtrccan_dict.map(trccan_dict):
return AfaFlowControl.ExitThisFlow('S999','赋值错误')
#=====插入登记簿rcc_trccan====
AfaLoggerFunc.tradeDebug('>>>开始插入数据库')
ret = rccpsDBTrcc_trccan.insertCmt(trccan_dict)
if ret <= 0:
return AfaFlowControl.ExitThisFlow('S999','插入数据库撤销申请登记簿trccan错误,抛弃报文')
#=====更新原撤销申请状态====
trc_update = {}
trc_update_where = {}
trc_update_where['BJEDTE'] = TradeContext.BOJEDT
trc_update_where['BSPSQN'] = TradeContext.BSPSQN
trc_update['CLRESPN']= TradeContext.CLRESPN
ret = rccpsDBTrcc_trccan.updateCmt(trc_update,trc_update_where)
if ret <= 0:
return AfaFlowControl.ExitThisFlow('S999','修改撤销申请登记簿原记录状态错误,抛弃报文')
#=====原汇兑交易流水号,8820抹账使用====
TradeContext.BOJEDT = tran_dict['BJEDTE']
TradeContext.BOSPSQ = tran_dict['BSPSQN']
#=====判断撤销应答标志是否允许撤销 0-允许撤销 1-不允许撤销 ====
if TradeContext.CLRESPN == '1':
#=====发送接收正常回执====
AfaLoggerFunc.tradeDebug('>>>中心不允许撤销,发送成功回执')
out_context_dict = {}
out_context_dict['sysType'] = 'rccpst'
out_context_dict['TRCCO'] = '9900503'
out_context_dict['MSGTYPCO'] = 'SET008'
out_context_dict['RCVMBRCO'] = TradeContext.SNDMBRCO
out_context_dict['SNDMBRCO'] = TradeContext.RCVMBRCO
out_context_dict['SNDBRHCO'] = TradeContext.BESBNO
out_context_dict['SNDCLKNO'] = TradeContext.BETELR
out_context_dict['SNDTRDAT'] = TradeContext.BJEDTE
out_context_dict['SNDTRTIM'] = TradeContext.BJETIM
out_context_dict['MSGFLGNO'] = out_context_dict['SNDMBRCO'] + TradeContext.BJEDTE + TradeContext.SerialNo
out_context_dict['ORMFN'] = TradeContext.MSGFLGNO
out_context_dict['NCCWKDAT'] = TradeContext.NCCworkDate
out_context_dict['OPRTYPNO'] = '99'
out_context_dict['ROPRTPNO'] = TradeContext.OPRTYPNO
out_context_dict['TRANTYP'] = '0'
out_context_dict['ORTRCCO'] = TradeContext.TRCCO
out_context_dict['PRCCO'] = 'RCCI0000'
out_context_dict['STRINFO'] = '成功'
rccpsMap0000Dout_context2CTradeContext.map(out_context_dict)
return True
AfaLoggerFunc.tradeDebug('>>>中心允许撤销,向主机发起记账')
#=====设置sstlog表中原记录状态为：抹账-处理中====
TradeContext.BCSTAT = PL_BCSTAT_HCAC
TradeContext.BDWFLG = PL_BDWFLG_WAIT
if not rccpsState.newTransState(dict['BOJEDT'],dict['BOSPSQ'],TradeContext.BCSTAT,TradeContext.BDWFLG):
return AfaFlowControl.ExitThisFlow('S999','设置状态出错,抛弃此报文')
#=====commit操作====
AfaDBFunc.CommitSql()
AfaLoggerFunc.tradeDebug('>>>开始向主机接口赋值')
#=====设置主机记账/抹账数据====
if TradeContext.BBSSRC == '3':
#=====代销账要发起8813红蓝字记账====
TradeContext.HostCode = '8813'
TradeContext.RCCSMCD = '614' #往撤销
TradeContext.DASQ = ''
TradeContext.RVFG = '0' #红蓝字标志 0
#关彬捷 20080728 修改抹账挂账原因
#TradeContext.NOTE3 = '向主机发起红蓝字记账冲销'
TradeContext.NOTE3 = '中心允许撤销,自动抹账'
TradeContext.RBAC = TradeContext.BESBNO + PL_ACC_NXYDXZ #贷方账号
TradeContext.SBAC = TradeContext.BESBNO + PL_ACC_NXYDQSWZ #借方账号
#=====开始调函数拼贷方账号第25位校验位====
TradeContext.RBAC = rccpsHostFunc.CrtAcc(TradeContext.RBAC, 25)
TradeContext.SBAC = rccpsHostFunc.CrtAcc(TradeContext.SBAC, 25)
AfaLoggerFunc.tradeInfo( '贷方账号:' + TradeContext.RBAC )
AfaLoggerFunc.tradeInfo( '借方账号:' + TradeContext.SBAC )
else:
TradeContext.HostCode = '8820'
#关彬捷 20080728 修改抹账挂账原因
#TradeContext.NOTE3 = '向主机发起抹账'
TradeContext.NOTE3 = '中心允许撤销,自动抹账'
AfaLoggerFunc.tradeDebug('>>>更新sstlog表中原交易状态成功,开始更新交易状态')
#=====设置sstlog标志状态为:抹账-处理中====
if not rccpsState.newTransState(TradeContext.BJEDTE,TradeContext.BSPSQN,TradeContext.BCSTAT,TradeContext.BDWFLG):
return AfaFlowControl.ExitThisFlow('S999','设置状态出错,抛弃此报文')
else:
#=====commit操作====
AfaDBFunc.CommitSql()
AfaLoggerFunc.tradeDebug('>>>开始调用主机函数')
AfaLoggerFunc.tradeDebug('>>>主机交易代码['+TradeContext.HostCode+']')
#=====向主机发起抹账操作====
rccpsHostFunc.CommHost(TradeContext.HostCode)
#=====判断主机返回结果设置状态====
sstlog_dict = {}
sstlog_dict['BJEDTE'] = TradeContext.BJEDTE
AfaLoggerFunc.tradeDebug('>>>交易日期['+TradeContext.BJEDTE+']')
sstlog_dict['BSPSQN'] = TradeContext.BSPSQN
AfaLoggerFunc.tradeDebug('>>>报单序号['+TradeContext.BSPSQN+']')
sstlog_dict['BCSTAT'] = TradeContext.BCSTAT
AfaLoggerFunc.tradeDebug('>>>业务状态['+TradeContext.BCSTAT+']')
sstlog_dict['NOTE4'] = TradeContext.errorMsg
AfaLoggerFunc.tradeDebug('>>>主机返回信息['+TradeContext.errorMsg+']')
sstlog_dict['NOTE3'] = TradeContext.NOTE3
AfaLoggerFunc.tradeDebug('>>>NOTE3['+TradeContext.NOTE3+']')
AfaLoggerFunc.tradeDebug('>>>errorCode['+TradeContext.errorCode+']')
if TradeContext.existVariable('TRDT'):
sstlog_dict['TRDT'] = TradeContext.TRDT
AfaLoggerFunc.tradeDebug('>>>主机日期['+TradeContext.TRDT+']')
if TradeContext.existVariable('TLSQ'):
sstlog_dict['TLSQ'] = TradeContext.TLSQ
AfaLoggerFunc.tradeDebug('>>>主机流水['+TradeContext.TLSQ+']')
if TradeContext.errorCode == '0000':
AfaLoggerFunc.tradeDebug('>>>测试')
if TradeContext.HostCode == '8813':
sstlog_dict['DASQ'] = TradeContext.DASQ
AfaLoggerFunc.tradeDebug('>>>销账序号['+TradeContext.DASQ+']')
sstlog_dict['SBAC'] = TradeContext.SBAC
AfaLoggerFunc.tradeDebug('>>>借方账号['+TradeContext.SBAC+']')
sstlog_dict['RBAC'] = TradeContext.RBAC
AfaLoggerFunc.tradeDebug('>>>贷方账号['+TradeContext.RBAC+']')
AfaLoggerFunc.tradeDebug('>>>测试2')
sstlog_dict['BDWFLG'] = PL_BDWFLG_SUCC
else:
AfaLoggerFunc.tradeDebug('>>>测试1')
sstlog_dict['BDWFLG'] = PL_BDWFLG_FAIL
AfaLoggerFunc.tradeDebug('>>>主机返回信息')
#=====设置原交易状态====
if not rccpsState.setTransState(sstlog_dict):
return AfaFlowControl.ExitThisFlow('S999','更新主机返回信息出错,抛弃报文')
#=====commit操作====
AfaDBFunc.CommitSql()
#=====设置交易状态====
sstlog_dict['BJEDTE'] = TradeContext.BOJEDT
sstlog_dict['BSPSQN'] = TradeContext.BOSPSQ
if not rccpsState.setTransState(sstlog_dict):
return AfaFlowControl.ExitThisFlow('S999','更新主机返回信息出错,抛弃报文')
#=====commit操作====
AfaDBFunc.CommitSql()
#=====发送回执,其它错误====
out_context_dict = {}
out_context_dict['sysType'] = 'rccpst'
out_context_dict['TRCCO'] = '9900503'
out_context_dict['MSGTYPCO'] = 'SET008'
out_context_dict['RCVMBRCO'] = TradeContext.SNDMBRCO
out_context_dict['SNDMBRCO'] = TradeContext.RCVMBRCO
out_context_dict['SNDBRHCO'] = TradeContext.BESBNO
out_context_dict['SNDCLKNO'] = TradeContext.BETELR
out_context_dict['SNDTRDAT'] = TradeContext.BJEDTE
out_context_dict['SNDTRTIM'] = TradeContext.BJETIM
out_context_dict['MSGFLGNO'] = out_context_dict['SNDMBRCO'] + TradeContext.BJEDTE + TradeContext.SerialNo
out_context_dict['ORMFN'] = TradeContext.MSGFLGNO
out_context_dict['NCCWKDAT'] = TradeContext.NCCworkDate
out_context_dict['OPRTYPNO'] = '99'
out_context_dict['ROPRTPNO'] = TradeContext.OPRTYPNO
out_context_dict['TRANTYP'] = '0'
out_context_dict['ORTRCCO'] = TradeContext.TRCCO
out_context_dict['PRCCO'] = 'RCCI0000'
out_context_dict['STRINFO'] = '成功'
rccpsMap0000Dout_context2CTradeContext.map(out_context_dict)
return True
def SubModuleDoFst():
AfaLoggerFunc.tradeInfo( '***农信银系统：往账.本地类操作(1.本地操作).异转本_卡应答[TRCC004_1158]进入***' )
#=================初始化返回信息============================================
if AfaUtilTools.trim(TradeContext.STRINFO) == "":
TradeContext.STRINFO = rccpsDBFunc.getErrInfo(TradeContext.PRCCO)
AfaLoggerFunc.tradeDebug("TradeContext.STRINFO=" + TradeContext.STRINFO)
#=====根据参考报文标识号查找原交易====
TradeContext.ORSNDBNKCO = TradeContext.ORMFN[:10] #原发送行号
TradeContext.BOJEDT = TradeContext.ORMFN[10:18] #原交易日期
TradeContext.ORTRCNO = TradeContext.ORMFN[18:] #原交易流水号
wtr_dict = {}
if not rccpsDBFunc.getTransWtrAK(TradeContext.ORSNDBNKCO,TradeContext.BOJEDT,TradeContext.ORTRCNO,wtr_dict):
#=====查询原交易失败，等待前台超时发起冲正，抛弃此报文====
return AfaFlowControl.ExitThisFlow('S999','等待前台发起冲正，抛弃报文')
AfaLoggerFunc.tradeInfo( '>>>查询原交易结束' )
#=================若应答报文回复拒绝,则设置状态为拒绝,停止处理=============
if TradeContext.PRCCO != 'RCCI0000':
AfaLoggerFunc.tradeInfo(">>>对方返回拒绝应答")
#=============设置业务状态为拒绝处理中=================================
if not rccpsState.newTransState(wtr_dict['BJEDTE'],wtr_dict['BSPSQN'],PL_BCSTAT_MFERFE,PL_BDWFLG_WAIT):
return AfaFlowControl.ExitThisFlow('S999',"设置业务状态为拒绝成功异常")
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
return AfaFlowControl.ExitThisFlow("S999","Commit异常")
#=============设置业务状态为拒绝成功===================================
stat_dict = {}
stat_dict['BJEDTE'] = wtr_dict['BJEDTE']
stat_dict['BSPSQN'] = wtr_dict['BSPSQN']
stat_dict['BCSTAT'] = PL_BCSTAT_MFERFE
stat_dict['BDWFLG'] = PL_BDWFLG_SUCC
stat_dict['PRCCO'] = TradeContext.PRCCO
stat_dict['STRINFO'] = TradeContext.STRINFO
if not rccpsState.setTransState(stat_dict):
return AfaFlowControl.ExitThisFlow('S999', "设置业务状态为拒绝成功异常")
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
return AfaFlowControl.ExitThisFlow("S999","Commit异常")
return AfaFlowControl.ExitThisFlow('S999',"对方拒绝，交易终止")
#====查找自动冲正登记簿是否存在本交易的冲正====
#====查找自动冲正登记簿是否存在本交易的冲正====
wheresql = ''
wheresql = wheresql + "BOJEDT = '" + wtr_dict['BJEDTE'] + "'" #报单日期
wheresql = wheresql + "AND BOSPSQ = '" + wtr_dict['BSPSQN'] + "'" #报单序号
ret = rccpsDBTrcc_atcbka.count(wheresql)
if ret == -1:
return AfaFlowControl.ExitThisFlow('S999','查找自动冲正登记簿异常')
elif ret > 0:
#=====原交易已自动冲正，抛弃报文====
return AfaFlowControl.ExitThisFlow('S999','原交易已冲正，抛弃报文')
AfaLoggerFunc.tradeInfo( '>>>查询冲正登记簿结束' )
#=====主机记账前处理====
TradeContext.BESBNO = wtr_dict['BESBNO'] #机构号
TradeContext.BETELR = wtr_dict['BETELR'] #柜员号
TradeContext.BEAUUS = wtr_dict['BEAUUS'] #授权柜员
TradeContext.BEAUPS = wtr_dict['BEAUPS'] #授权密码
TradeContext.TERMID = wtr_dict['TERMID'] #终端号
TradeContext.BJEDTE = wtr_dict['BJEDTE'] #交易日期
TradeContext.BSPSQN = wtr_dict['BSPSQN'] #报单序号
TradeContext.BRSFLG = wtr_dict['BRSFLG'] #往来账标志
TradeContext.HostCode= '8813' #主机交易码
AfaLoggerFunc.tradeInfo( '>>>主机前处理赋值结束' )
#=====开始更新原交易,新增状态记账－处理中====
if not rccpsState.newTransState(wtr_dict['BJEDTE'],wtr_dict['BSPSQN'],PL_BCSTAT_ACC,PL_BDWFLG_WAIT):
#=====RollBack操作====
AfaDBFunc.RollbackSql()
return AfaFlowControl.ExitThisFlow('M999', '设置状态失败,系统自动回滚')
else:
#=====commit操作====
AfaDBFunc.CommitSql()
AfaLoggerFunc.tradeInfo( '>>>设置状态记账-处理中结束' )
#=====根据原记录中的手续费收取方式，判断账务处理模式====
if wtr_dict['CHRGTYP'] == '1':
#=====转账====
TradeContext.ACUR = '3' #记账次数
#=========交易金额+手续费===================
TradeContext.RCCSMCD = PL_RCCSMCD_YZBWZ #摘要代码 PL_RCCSMCD_YZBWZ 异转本
TradeContext.SBAC = TradeContext.BESBNO + PL_ACC_NXYDQSWZ #借方账号
TradeContext.SBAC = rccpsHostFunc.CrtAcc(TradeContext.SBAC,25)
TradeContext.ACNM = '农信银往账' #借方户名
TradeContext.RBAC = TradeContext.BESBNO + PL_ACC_NXYDJLS #贷方账号
TradeContext.RBAC = rccpsHostFunc.CrtAcc(TradeContext.RBAC,25)
TradeContext.OTNM = '应解汇款' #贷方户名
TradeContext.OCCAMT = str(wtr_dict['OCCAMT'] + wtr_dict['CUSCHRG']) #发生额
TradeContext.PKFG = 'T'
TradeContext.CTFG = '9'
TradeContext.WARNTNO = ''
TradeContext.CERTTYPE = ''
TradeContext.CERTNO = ''
AfaLoggerFunc.tradeInfo( '>>>交易金额+手续费:借方账号' + TradeContext.SBAC )
AfaLoggerFunc.tradeInfo( '>>>交易金额+手续费:贷方账号' + TradeContext.RBAC )
#=========交易金额============
TradeContext.I2SMCD = PL_RCCSMCD_YZBWZ #摘要代码
TradeContext.I2SBAC = TradeContext.BESBNO + PL_ACC_NXYDJLS #借方账号
TradeContext.I2SBAC = rccpsHostFunc.CrtAcc(TradeContext.I2SBAC,25)
TradeContext.I2ACNM = '应解汇款' #借方户名
TradeContext.I2RBAC = TradeContext.PYEACC #贷方账号
TradeContext.I2OTNM = TradeContext.PYENAM #贷方户名
TradeContext.I2TRAM = str(wtr_dict['OCCAMT']) #发生额
TradeContext.I2CTFG = '7'
TradeContext.I2PKFG = 'T'
#TradeContext.I2WARNTNO = ''
#TradeContext.I2CERTTYPE = ''
#TradeContext.I2CERTNO = ''
AfaLoggerFunc.tradeInfo( '>>>交易金额:借方账号' + TradeContext.I2SBAC )
AfaLoggerFunc.tradeInfo( '>>>交易金额:贷方账号' + TradeContext.I2RBAC )
#=========结算手续费收入户===========
TradeContext.I3SMCD = PL_RCCSMCD_SXF #摘要代码
TradeContext.I3SBAC = TradeContext.BESBNO + PL_ACC_NXYDJLS #借方账号
TradeContext.I3SBAC = rccpsHostFunc.CrtAcc(TradeContext.I3SBAC,25)
TradeContext.I3ACNM = '应解汇款' #借方户名
TradeContext.I3RBAC = TradeContext.BESBNO + PL_ACC_TCTDSXF #贷方账号
TradeContext.I3RBAC = rccpsHostFunc.CrtAcc(TradeContext.I3RBAC,25)
TradeContext.I3OTNM = '结算手续费' #贷方户名
TradeContext.I3TRAM = str(wtr_dict['CUSCHRG']) #发生额
TradeContext.I3CTFG = '8'
TradeContext.I3PKFG = 'T'
AfaLoggerFunc.tradeInfo( '>>>结算手续费收入户:借方账号' + TradeContext.I3SBAC )
AfaLoggerFunc.tradeInfo( '>>>结算手续费收入户:贷方账号' + TradeContext.I3RBAC )
elif wtr_dict['CHRGTYP'] == '0':
#=====本金====
TradeContext.ACUR = '2' #记账次数
TradeContext.RCCSMCD = PL_RCCSMCD_YZBWZ #摘要代码
TradeContext.SBAC = TradeContext.BESBNO + PL_ACC_NXYDQSWZ #借方账号
TradeContext.SBAC = rccpsHostFunc.CrtAcc(TradeContext.SBAC,25)
TradeContext.ACNM = '农信银往账' #借方户名
TradeContext.RBAC = TradeContext.PYEACC #贷方账号
TradeContext.OTNM = TradeContext.PYENAM #贷方户名
TradeContext.OCCAMT = str(wtr_dict['OCCAMT']) #金额
TradeContext.CTFG = '7'
TradeContext.PKFG = 'T'
TradeContext.WARNTNO = ''
TradeContext.CERTTYPE = ''
TradeContext.CERTNO = ''
#=====手续费记账赋值====
TradeContext.I2SMCD = PL_RCCSMCD_SXF #摘要代码
TradeContext.I2SBAC = '' #借方账号
TradeContext.I2RBAC = TradeContext.BESBNO + PL_ACC_TCTDSXF #贷方账号
TradeContext.I2RBAC = rccpsHostFunc.CrtAcc(TradeContext.I2RBAC,25)
TradeContext.I2OTNM = '手续费科目' #贷方户名
TradeContext.I2TRAM = str(wtr_dict['CUSCHRG']) #金额
TradeContext.I2CTFG = '8'
TradeContext.I2PKFG = 'T'
TradeContext.I2CATR = '0' #现转标志
elif wtr_dict['CHRGTYP'] == '2':
#=====不收费====
TradeContext.ACUR = '1' #记账次数
TradeContext.RCCSMCD = PL_RCCSMCD_YZBWZ #摘要代码
TradeContext.SBAC = TradeContext.BESBNO + PL_ACC_NXYDQSWZ #借方账号
TradeContext.SBAC = rccpsHostFunc.CrtAcc(TradeContext.SBAC,25)
TradeContext.RBAC = TradeContext.PYEACC #贷方账号
TradeContext.OTNM = TradeContext.PYENAM #贷方户名
TradeContext.OCCAMT = str(wtr_dict['OCCAMT']) #金额
TradeContext.CTFG = '7'
TradeContext.PKFG = 'T'
TradeContext.WARNTNO = ''
TradeContext.CERTTYPE = ''
TradeContext.CERTNO = ''
else:
#=====出错====
return AfaFlowControl.ExitThisFlow('S999','手续费收费方式错，抛弃报文')
AfaLoggerFunc.tradeInfo( '>>>根据手续费收取方式记账赋值处理结束' )
#=====主机记账处理====
rccpsHostFunc.CommHost(TradeContext.HostCode)
#=====主机后处理====
set_dict = {}
set_dict['BSPSQN'] = TradeContext.BSPSQN
set_dict['BJEDTE'] = TradeContext.BJEDTE
set_dict['BCSTAT'] = PL_BCSTAT_ACC
set_dict["SBAC"] = TradeContext.SBAC #借方账号
set_dict["RBAC"] = TradeContext.RBAC #贷方账号
set_dict["OTNM"] = TradeContext.OTNM #贷方户名
set_dict['MGID'] = TradeContext.errorCode #主机返回码
set_dict["STRINFO"]= TradeContext.errorMsg #主机返回信息
if TradeContext.errorCode == '0000':
#=====主机记账成功====
set_dict['BDWFLG'] = PL_BDWFLG_SUCC
set_dict['TRDT'] = TradeContext.TRDT
set_dict['TLSQ'] = TradeContext.TLSQ
else:
set_dict['BDWFLG'] = PL_BDWFLG_FAIL
if not rccpsState.setTransState(set_dict):
return AfaFlowControl.ExitThisFlow(TradeContext.errorCode, TradeContext.errorMsg)
else:
#=====commit操作====
AfaDBFunc.CommitSql()
AfaLoggerFunc.tradeInfo('>>>设置主机返回状态成功')
if TradeContext.errorCode == '0000':
#=====开始更新原交易,新增状态清算成功====
if not rccpsState.newTransState(wtr_dict['BJEDTE'],wtr_dict['BSPSQN'],PL_BCSTAT_MFESTL,PL_BDWFLG_SUCC):
#=====RollBack操作====
AfaDBFunc.RollbackSql()
return AfaFlowControl.ExitThisFlow('M999', '设置状态失败,系统自动回滚')
else:
#=====commit操作====
AfaDBFunc.CommitSql()
AfaLoggerFunc.tradeInfo( '***农信银系统：往账.本地类操作(1.本地操作).异转本_卡应答[TRCC004_1158]退出***' )
return True
def SubModuleDoFst():
#====开始取流水号对应信息====
trcbka_dict = {}
dict = rccpsDBFunc.getTransTrc(TradeContext.BOJEDT,TradeContext.BOSPSQ,trcbka_dict)
if dict == False:
return AfaFlowControl.ExitThisFlow('M999','取交易信息失败')
#=====判断撤销信息====
if trcbka_dict['BRSFLG'] != PL_BRSFLG_RCV:
return AfaFlowControl.ExitThisFlow('M999','原交易为往帐业务，不允许退汇操作')
if TradeContext.BESBNO != trcbka_dict["BESBNO"]:
return AfaFlowControl.ExitThisFlow('M999','不允许跨机构退汇')
if str(trcbka_dict['TRCCO']) == '2000009':
return AfaFlowControl.ExitThisFlow('M999','特约汇兑业务不允许退汇')
if str(trcbka_dict['TRCCO']) == '2000004':
return AfaFlowControl.ExitThisFlow('M999','退汇业务不允许再次退汇')
if str(trcbka_dict['TRCCO'])[0:2] != '20':
return AfaFlowControl.ExitThisFlow('M999','非汇兑业务不允许退汇')
if trcbka_dict["BCSTAT"] != PL_BCSTAT_HANG: #自动挂账状态 1 成功
return AfaFlowControl.ExitThisFlow('M999','当前业务状态为['+str(trcbka_dict["BCSTAT"])+']不允许退汇' )
TradeContext.ORSNDBNK = trcbka_dict['SNDBNKCO']
TradeContext.ORRCVBNK = trcbka_dict['RCVBNKCO']
TradeContext.ORSNDBNKNM = trcbka_dict['SNDBNKNM']
TradeContext.ORRCVBNKNM = trcbka_dict['RCVBNKNM']
#=====开始插入数据库====
trcbka_dict["BRSFLG"] = TradeContext.BRSFLG
trcbka_dict["BOJEDT"] = trcbka_dict["BJEDTE"]
trcbka_dict["BOSPSQ"] = trcbka_dict["BSPSQN"]
trcbka_dict["ORTRCDAT"] = trcbka_dict["TRCDAT"]
trcbka_dict["ORTRCCO"] = trcbka_dict["TRCCO"]
trcbka_dict["ORTRCNO"] = trcbka_dict["TRCNO"]
trcbka_dict["ORSNDBNK"] = trcbka_dict["SNDBNKCO"]
trcbka_dict["ORRCVBNK"] = trcbka_dict["RCVBNKCO"]
trcbka_dict["BJEDTE"] = TradeContext.BJEDTE
trcbka_dict["BSPSQN"] = TradeContext.BSPSQN
trcbka_dict["BJETIM"] = TradeContext.BJETIM
trcbka_dict["TRCDAT"] = TradeContext.TRCDAT
trcbka_dict["STRINFO"] = TradeContext.STRINFO
trcbka_dict["TRCCO"] = TradeContext.TRCCO
trcbka_dict["TRCNO"] = TradeContext.SerialNo
trcbka_dict["SNDBNKCO"] = TradeContext.SNDBNKCO
trcbka_dict["SNDBNKNM"] = TradeContext.SNDBNKNM
trcbka_dict["SNDMBRCO"] = TradeContext.SNDSTLBIN
trcbka_dict["RCVBNKCO"] = TradeContext.RCVBNKCO
trcbka_dict["RCVBNKNM"] = TradeContext.RCVBNKNM
trcbka_dict["RCVMBRCO"] = TradeContext.RCVSTLBIN
trcbka_dict["OPRNO"] = "09"
trcbka_dict["BBSSRC"] = "3"
trcbka_dict["BETELR"] = TradeContext.BETELR
trcbka_dict["TERMID"] = TradeContext.TERMID
#=====刘雨龙 2008-09-17 注释对业务类型的赋空操作====
#trcbka_dict["OPRATTNO"] = ""
trcbka_dict["NCCWKDAT"] = TradeContext.NCCworkDate
trcbka_dict["SEAL"] = ""
#=====为发送退汇报文赋值====
TradeContext.OPRTYPNO = '20' #汇兑
TradeContext.ORTRCCO = trcbka_dict['ORTRCCO']
TradeContext.ORTRCDAT = trcbka_dict['ORTRCDAT']
TradeContext.ORTRCNO = trcbka_dict['ORTRCNO']
TradeContext.ORPYRACC = trcbka_dict['PYRACC']
TradeContext.ORPYRNAM = trcbka_dict['PYRNAM']
TradeContext.ORPYEACC = trcbka_dict['PYEACC']
TradeContext.ORPYENAM = trcbka_dict['PYENAM']
TradeContext.PYRACC = trcbka_dict['PYRACC']
TradeContext.PYRNAM = trcbka_dict['PYRNAM']
TradeContext.PYRADDR = trcbka_dict['PYRADDR']
TradeContext.PYEACC = trcbka_dict['PYEACC']
TradeContext.PYENAM = trcbka_dict['PYENAM']
TradeContext.PYEADDR = trcbka_dict['PYEADDR']
AfaLoggerFunc.tradeInfo( '字典trccan_dict：' + str(trcbka_dict) )
#=====开始插入数据库====
if not rccpsDBFunc.insTransTrc(trcbka_dict):
#=====RollBack操作====
AfaDBFunc.RollbackSql()
return AfaFlowControl.ExitThisFlow('D002', '插入数据库出错,RollBack成功')
#=====commit操作====
if not AfaDBFunc.CommitSql():
#=====RollBack操作====
AfaDBFunc.RollbackSql()
return AfaFlowControl.ExitThisFlow('D011', '数据库Commit失败')
else:
AfaLoggerFunc.tradeDebug('COMMIT成功')
#=====设置sstlog表中状态为：记账-处理中====
status = {}
status['BJEDTE'] = TradeContext.BJEDTE
status['BSPSQN'] = TradeContext.BSPSQN
status['BCSTAT'] = PL_BCSTAT_ACC
status['BDWFLG'] = PL_BDWFLG_WAIT
if not rccpsState.setTransState(status):
#=====RollBack操作====
AfaDBFunc.RollbackSql()
return AfaFlowControl.ExitThisFlow(TradeContext.errorCode, TradeContext.errorMsg)
else:
#=====commit操作====
AfaDBFunc.CommitSql()
AfaLoggerFunc.tradeInfo('>>>commit成功')
#=====主机记账8813====
TradeContext.HostCode = '8813'
TradeContext.OCCAMT = str(trcbka_dict['OCCAMT']) #金额
TradeContext.RCCSMCD = PL_RCCSMCD_LTH #主机摘要代码：来账退汇
TradeContext.DASQ = trcbka_dict['DASQ']
#=====开始拼借贷方账号====
TradeContext.RBAC = TradeContext.BESBNO + PL_ACC_NXYDQSWZ
#TradeContext.SBAC = TradeContext.BESBNO + PL_ACC_NXYDXZ
#=====开始调函数拼贷方账号第25位校验位====
TradeContext.RBAC = rccpsHostFunc.CrtAcc(TradeContext.RBAC, 25)
#TradeContext.SBAC = rccpsHostFunc.CrtAcc(TradeContext.SBAC, 25)
AfaLoggerFunc.tradeInfo( '贷方账号:' + TradeContext.RBAC )
#AfaLoggerFunc.tradeInfo( '借方账号:' + TradeContext.SBAC )
return True
