if __name__ == '__main__':
try:
AfaLoggerFunc.tradeInfo("***农信银系统: 系统调度类.通存通兑主机对账文件下载[rccpsTDZJDZGetFile]进入***")
#==========获取中心日期================================================
AfaLoggerFunc.tradeInfo(">>>开始获取前中心工作日期")
mbrifa_where_dict = {}
mbrifa_where_dict['OPRTYPNO'] = "30"
mbrifa_dict = rccpsDBTrcc_mbrifa.selectu(mbrifa_where_dict)
if mbrifa_dict == None:
AfaLoggerFunc.tradeInfo( AfaDBFunc.sqlErrMsg )
rccpsCronFunc.cronExit("S999","查询当前中心日期异常")
NCCWKDAT = mbrifa_dict['NOTE1'][:8] #对账日期
NCCWKDAT_LIST = mbrifa_dict['NOTE3'].split(',') #需要对账的中心日期(包括本清算工作日和之前的非清算工作日)
AfaLoggerFunc.tradeInfo(">>>开始注册主机对账文件生成")
#==========主机交易前处理==============================================
TradeContext.HostCode = '8825' #交易代码
TradeContext.STRDAT = min( NCCWKDAT_LIST ) #起始日期
TradeContext.ENDDAT = max( NCCWKDAT_LIST ) #终止日期
TradeContext.BESBNO = PL_BESBNO_BCLRSB #机构号码
TradeContext.BETELR = PL_BETELR_AUTO #自动柜员
if __name__ == '__main__':
try:
AfaLoggerFunc.tradeInfo("***农信银系统: 系统调度类.查询查复业务量信息统计[rccpsXXProStat]进入***")
#==========获取中心日期================================================
AfaLoggerFunc.tradeInfo(">>>开始获取前中心工作日期")
mbrifa_where_dict = {}
mbrifa_where_dict['OPRTYPNO'] = "30"
mbrifa_dict = rccpsDBTrcc_mbrifa.selectu(mbrifa_where_dict)
if mbrifa_dict == None:
AfaLoggerFunc.tradeInfo( AfaDBFunc.sqlErrMsg )
rccpsCronFunc.cronExit("S999","查询当前中心日期异常")
NCCWKDAT = mbrifa_dict['NOTE1'][:8] #对账日期
LNCCWKDAT = "('" + mbrifa_dict['NOTE3'].replace(",","','") + "')"
AfaLoggerFunc.tradeInfo(">>>结束获取前中心工作日期")
#==================查询查复往账统计=========================================
AfaLoggerFunc.tradeInfo(">>>开始查询查复往账业务量统计")
#=====汇兑查询查复往账====
AfaLoggerFunc.tradeInfo(">>>开始汇兑查询查复往账业务量统计")
tmp_sql = ""
tmp_sql = tmp_sql + " insert into rcc_trcsta("
tmp_sql = tmp_sql + " select a.nccwkdat,b.besbno,a.trcco,'" + PL_BRSFLG_SND + "',b.btopsb,b.beacsb,count(a.occamt),sum(a.occamt),'" + PL_ISDEAL_UNDO + "','','','','',''"
tmp_sql = tmp_sql + " from rcc_hdcbka a left join rcc_subbra b on a.sndbnkco = b.bankbin"
tmp_sql = tmp_sql + " where a.sndmbrco = '1340000008' and nccwkdat in " + LNCCWKDAT + " and a.prcco='RCCI0000'"
if __name__ == '__main__':
try:
AfaLoggerFunc.tradeInfo("***农信银系统: 系统调度类.汇票业务量统计[rccpsHPProStat]进入***")
#==========获取中心日期================================================
AfaLoggerFunc.tradeInfo(">>>开始获取前中心工作日期")
mbrifa_where_dict = {}
mbrifa_where_dict['OPRTYPNO'] = "20"
mbrifa_dict = rccpsDBTrcc_mbrifa.selectu(mbrifa_where_dict)
if mbrifa_dict == None:
AfaLoggerFunc.tradeInfo( AfaDBFunc.sqlErrMsg )
rccpsCronFunc.cronExit("S999","查询当前中心日期异常")
NCCWKDAT = mbrifa_dict['NOTE1'][:8] #对账日期
LNCCWKDAT = "('" + mbrifa_dict['NOTE4'].replace(",","','") + "')"
AfaLoggerFunc.tradeInfo(">>>结束获取前中心工作日期")
#==================汇票往账统计=========================================
AfaLoggerFunc.tradeInfo(">>>开始汇票往账业务量统计")
tmp_sql = ""
tmp_sql = tmp_sql + " insert into rcc_trcsta("
tmp_sql = tmp_sql + " select a.nccwkdat,b.besbno,a.trcco,'" + PL_BRSFLG_SND + "',b.btopsb,b.beacsb,count(a.occamt),sum(a.occamt),'" + PL_ISDEAL_UNDO + "','','','','',''"
tmp_sql = tmp_sql + " from rcc_hpdzmx a left join rcc_subbra b on a.sndbnkco = b.bankbin"
tmp_sql = tmp_sql + " where a.sndmbrco = '1340000008' and nccwkdat in " + LNCCWKDAT
tmp_sql = tmp_sql + " group by a.nccwkdat,b.besbno,a.trcco,b.btopsb,b.beacsb)"
try:
AfaLoggerFunc.tradeInfo("***农信银系统: 系统调度类.通存通兑对账汇总文件导入[rccpsTDDZHZFileImport]进入***")
local_home = os.environ['AFAP_HOME'] + "/data/rccps/"
#==========获取中心日期================================================
AfaLoggerFunc.tradeInfo(">>>开始获取前中心工作日期")
mbrifa_where_dict = {}
mbrifa_where_dict['OPRTYPNO'] = "30"
mbrifa_dict = rccpsDBTrcc_mbrifa.selectu(mbrifa_where_dict)
if mbrifa_dict == None:
AfaLoggerFunc.tradeInfo( AfaDBFunc.sqlErrMsg )
rccpsCronFunc.cronExit("S999","查询当前中心日期异常")
NCCWKDAT = mbrifa_dict['NOTE1'][:8] #对账日期
AfaLoggerFunc.tradeInfo(">>>结束获取前中心工作日期")
#====================导入通存通兑对账汇总文件===================================
AfaLoggerFunc.tradeInfo(">>>开始导入通存通兑对账汇总文件")
file_path = local_home + "settlefile/TDHZCNY1340000008" + NCCWKDAT
fp = open(file_path,"r")
if fp == None:
rccpsCronFunc.cronExit("S999","打开通存通兑对账汇总文件异常")
if __name__ == '__main__':
try:
AfaLoggerFunc.tradeInfo("***农信银系统: 系统调度类.通存通兑业务量统计[rccpsTDProStat]进入***")
#==========获取中心日期================================================
AfaLoggerFunc.tradeInfo(">>>开始获取前中心工作日期")
mbrifa_where_dict = {}
mbrifa_where_dict['OPRTYPNO'] = "30"
mbrifa_dict = rccpsDBTrcc_mbrifa.selectu(mbrifa_where_dict)
if mbrifa_dict == None:
AfaLoggerFunc.tradeInfo( AfaDBFunc.sqlErrMsg )
rccpsCronFunc.cronExit("S999","查询当前中心日期异常")
NCCWKDAT = mbrifa_dict['NOTE1'][:8] #对账日期
LNCCWKDAT = "('" + mbrifa_dict['NOTE3'].replace(",","','") + "')"
AfaLoggerFunc.tradeInfo(">>>结束获取前中心工作日期")
#==================通存通兑往账统计=========================================
AfaLoggerFunc.tradeInfo(">>>开始通存通兑往账业务量统计")
tmp_sql = ""
tmp_sql = tmp_sql + " insert into rcc_trcsta("
tmp_sql = tmp_sql + " select a.nccwkdat,a.besbno,a.trcco,a.brsflg,'','',count(occamt),sum(occamt),'0','','','','',''"
tmp_sql = tmp_sql + " from rcc_wtrbka as a,rcc_spbsta as b where a.bjedte = b.bjedte and a.bspsqn = b.bspsqn"
tmp_sql = tmp_sql + " and b.bcstat = '42' and b.bdwflg = '1' and a.brsflg = '" + PL_BRSFLG_SND + "' and a.nccwkdat in " + LNCCWKDAT
tmp_sql = tmp_sql + " group by a.nccwkdat,a.besbno,a.trcco,a.brsflg)"
if __name__ == '__main__':
try:
AfaLoggerFunc.tradeInfo("***农信银系统: 系统调度类.通存通兑主机对账明细文件导入[rccpsTDZJDZImport]进入***")
#==========获取中心日期================================================
AfaLoggerFunc.tradeInfo(">>>开始获取前中心工作日期")
mbrifa_where_dict = {}
mbrifa_where_dict['OPRTYPNO'] = "30"
mbrifa_dict = rccpsDBTrcc_mbrifa.selectu(mbrifa_where_dict)
if mbrifa_dict == None:
AfaLoggerFunc.tradeInfo( AfaDBFunc.sqlErrMsg )
rccpsCronFunc.cronExit("S999","查询当前中心日期异常")
NCCWKDAT = mbrifa_dict['NOTE1'][:8] #对账日期
NCCWKDAT_LIST = mbrifa_dict['NOTE3'].split(',') #需要对账的中心日期(包括本清算工作日和之前的非清算工作日)
#==========删除记账明细簿数据=================================================
AfaLoggerFunc.tradeInfo(">>>删除记账明细簿数据")
delsql = "delete from rcc_tdzjmx"
res = AfaDBFunc.DeleteSqlCmt(delsql)
if( res==None or res == -1 ):
AfaLoggerFunc.tradeDebug(">>>记账明细簿插入数据失败,数据库会滚,抛弃报文")
AfaDBFunc.RollbackSql()
rccpsCronFunc.cronExit( '9000', '记账明细簿插入数据失败,数据库会滚,抛弃报文' )
else:
AfaDBFunc.CommitSql()
if __name__ == '__main__':
try:
AfaLoggerFunc.tradeInfo("***农信银系统: 系统调度类.通存通兑对账明细账勾兑[rccpsTDDZMXCompare]进入***")
#==========获取中心日期================================================
AfaLoggerFunc.tradeInfo(">>>开始获取前中心工作日期")
mbrifa_where_dict = {}
mbrifa_where_dict['OPRTYPNO'] = "30"
mbrifa_dict = rccpsDBTrcc_mbrifa.selectu(mbrifa_where_dict)
if mbrifa_dict == None:
AfaLoggerFunc.tradeInfo( AfaDBFunc.sqlErrMsg )
rccpsCronFunc.cronExit("S999","查询当前中心日期异常")
NCCWKDAT = mbrifa_dict['NOTE1'][:8] #对账日期
LNCCWKDAT = "('" + mbrifa_dict['NOTE3'].replace(",","','") + "')" #需要对账的中心日期(包括本清算工作日和之前的非清算工作日)
AfaLoggerFunc.tradeInfo(">>>结束获取前中心工作日期")
#===================往账,行内已记账且未抹账,中心无==============================
AfaLoggerFunc.tradeInfo(">>>开始对账往账,行内已记账且未抹账,中心无")
temp_sql = "insert into rcc_tddzcz"
temp_sql = temp_sql + " (select a.nccwkdat,a.sndbnkco,a.trcdat,a.trcno,a.rcvbnkco,a.sndmbrco,a.rcvmbrco,a.trcco,case a.dcflg when '1' then '0' else '1' end,a.pyracc,a.pyeacc,'CNY',a.occamt,a.occamt,case when a.chrgtyp='1' and a.trcco in ('3000102','3000103','3000104','3000105') then a.cuschrg else 0.00 end case,case when a.chrgtyp='1' and a.trcco in ('3000102','3000103','3000104','3000105') then a.cuschrg else 0.00 end case,'',a.bjedte,a.bspsqn,'01','中心无成员行有','01','往账,行内已记账且未抹账,中心无','0','','','',''"
temp_sql = temp_sql + " from rcc_wtrbka as a"
temp_sql = temp_sql + " where a.nccwkdat in " + LNCCWKDAT + " and a.brsflg = '0'"
temp_sql = temp_sql + " and not exists"
temp_sql = temp_sql + " (select * from rcc_tddzmx as b"
file_line = rccpsUtilTools.replaceRet(file_line)
if file_line == "":
continue
line_list = file_line.split('|')
paybnk_where_dict = {}
paybnk_where_dict['BANKBIN'] = line_list[0]
tmp_paybnk_dict = rccpsDBTrcc_paybnk.selectu(paybnk_where_dict)
if tmp_paybnk_dict == None:
if not AfaDBFunc.RollbackSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
AfaLoggerFunc.tradeError(">>>Rollback异常")
AfaLoggerFunc.tradeInfo(">>>Rollback成功")
rccpsCronFunc.cronExit("S999","查询将登记行号是否存在异常")
paybnk_dict = {}
paybnk_dict['BANKBIN'] = line_list[0][:10]
paybnk_dict['BANKSTATUS'] = line_list[1][:1]
paybnk_dict['BANKATTR'] = line_list[2][:2]
paybnk_dict['STLBANKBIN'] = line_list[3][:10]
paybnk_dict['BANKNAM'] = line_list[4][:60]
paybnk_dict['BANKADDR'] = line_list[5][:60]
paybnk_dict['BANKPC'] = line_list[6][:6]
paybnk_dict['BANKTEL'] = line_list[7][:30]
paybnk_dict['EFCTDAT'] = line_list[8][:8]
paybnk_dict['INVDAT'] = line_list[9][:8]
paybnk_dict['ALTTYPE'] = line_list[10][:1]
paybnk_dict['PRIVILEGE'] = line_list[11][:20]
paybnk_dict['STRINFO'] = line_list[12][:60]
if __name__ == '__main__':
try:
rccpsCronFunc.WrtLog("***农信银系统: 系统调度类.通存通兑对账错账处理[rccpstdzjczModify]进入***")
#==========获取中心日期================================================
AfaLoggerFunc.tradeInfo(">>>开始获取前中心工作日期")
mbrifa_where_dict = {}
mbrifa_where_dict['OPRTYPNO'] = "30"
mbrifa_dict = rccpsDBTrcc_mbrifa.selectu(mbrifa_where_dict)
if mbrifa_dict == None:
AfaLoggerFunc.tradeInfo( AfaDBFunc.sqlErrMsg )
rccpsCronFunc.cronExit("S999","查询当前中心日期异常")
NCCWKDAT = mbrifa_dict['NOTE1'][:8] #对账日期
LNCCWKDAT = "('" + mbrifa_dict['NOTE3'].replace(",","','") + "')"
AfaLoggerFunc.tradeInfo(">>>结束获取前中心工作日期")
#对前置少账类型中,前置存在此状态但流转处理标识非成功的,更新流转处理标识为成功,并更新主机日期,主机流水号
tdzjcz_where_sql = "nccwkdat in " + LNCCWKDAT + " and errtyp = '51' and isdeal = '" + PL_ISDEAL_UNDO + "'"
tdzjcz_list = rccpsDBTrcc_tdzjcz.selectm(1,0,tdzjcz_where_sql,"")
if tdzjcz_list == None:
AfaLoggerFunc.tradeInfo(AfaDBFunc.sqlErrMsg)
rccpsCronFunc.cronExit("S999","查询此错账类型相关记录异常")
elif len(tdzjcz_list) <= 0:
def backupdb(tbName,clName,backupDate):
AfaLoggerFunc.tradeInfo(">>>>开始统计表[" + tbName + "]" + backupDate + "]需备份数据")
sql = "select count(*) from " + tbName + " where " + clName + " < '" + backupDate + "'"
AfaLoggerFunc.tradeInfo(sql)
rec = AfaDBFunc.SelectSql(sql)
if rec == None:
AfaLoggerFunc.tradeInfo(">>>>统计表[" + tbName + "][" + backupDate + "]需备份数据异常")
rccpsCronFunc.cronExit("S999","统计表[" + tbName + "][" + backupDate + "]需备份数据异常")
if len(rec) <= 0:
AfaLoggerFunc.tradeInfo(">>>>统计表[" + tbName + "][" + backupDate + "]需备份数据异常")
rccpsCronFunc.cronExit("S999","统计表[" + tbName + "][" + backupDate + "]需备份数据异常")
if rec[0][0] <= 0:
AfaLoggerFunc.tradeInfo(">>>>表[" + tbName + "][" + backupDate + "]无需备份数据")
#rccpsCronFunc.cronExit("S999","实时汇兑登记簿[" + backupDate + "]无需备份数据")
else:
#导出表数据至文件
file = path + "/" + tbName + ".del"
if not os.path.exists(file):
AfaLoggerFunc.tradeInfo(">>>>开始导出表[" + tbName + "][" + backupDate + "]数据至文件")
cmd = "db2 \"export to '" + file + "' of del select * from " + tbName + " where " + clName + " < '" + backupDate + "'\""
AfaLoggerFunc.tradeInfo(cmd)
os.system(cmd)
AfaLoggerFunc.tradeInfo(">>>>结束导出表[" + tbName + "][" + backupDate + "]数据至文件")
else:
AfaLoggerFunc.tradeInfo(">>>>表[" + tbName + "][" + backupDate + "]数据文件已存在")
#导出表数据至历史表
AfaLoggerFunc.tradeInfo(">>>>开始导出表[" + tbName + "][" + backupDate + "]数据至历史表")
sql = ""
sql = sql + "insert into " + tbName + "_his "
sql = sql + "(select * from " + tbName + " where " + clName + " < '" + backupDate + "')"
AfaLoggerFunc.tradeInfo(sql)
rec = AfaDBFunc.InsertSql(sql)
if (rec < 0):
AfaLoggerFunc.tradeInfo(AfaDBFunc.sqlErrMsg)
rccpsCronFunc.cronExit("S999","导出表[" + tbName + "][" + backupDate + "]数据至历史表异常")
AfaLoggerFunc.tradeInfo(">>>>结束导出表[" + tbName + "][" + backupDate + "]数据至历史表")
#删除表数据
AfaLoggerFunc.tradeInfo(">>>>开始删除表[" + tbName + "][" + backupDate + "]数据")
sql = ""
sql = sql + "delete from " + tbName + " where " + clName + " < '" + backupDate + "'"
AfaLoggerFunc.tradeInfo(sql)
rec = AfaDBFunc.DeleteSql(sql)
if (rec < 0):
AfaLoggerFunc.tradeInfo(AfaDBFunc.sqlErrMsg)
rccpsCronFunc.cronExit("S999","删除表[" + tbName + "][" + backupDate + "]数据异常")
AfaLoggerFunc.tradeInfo(">>>>结束删除表[" + tbName + "][" + backupDate + "]数据")
#提交事务
if not AfaDBFunc.CommitSql():
AfaLoggerFunc.tradeInfo(AfaDBFunc.sqlErrMsg)
rccpsCronFunc.cronExit("S999","提交事务异常")
#重整表
AfaLoggerFunc.tradeInfo(">>>>开始重整表[" + tbName + "]")
cmd = "db2 \"reorg table " + tbName + "\" "
AfaLoggerFunc.tradeInfo(cmd)
os.system(cmd)
AfaLoggerFunc.tradeInfo(">>>>结束重整表[" + tbName + "]")
HostContext.I1WSNO = '1234567890' #终端号
HostContext.I1PYNO = '9999' #系统标识
HostContext.I1AUUS = ''
HostContext.I1AUPS = ''
#====与主机进行通讯====
AfaHostFunc.CommHost('8808')
#=====判断主机返回结果====
if TradeContext.errorCode == '0000':
#=====同步数据库表AFA_DATE====
sql = "UPDATE AFA_DATE SET WORKDATE='" + HostContext.O1TRDT + "'"
sql = sql + ", WORKTIME = '" + HostContext.O1TRTM + "'"
sql = sql + ", HOSTDATE = '" + HostContext.O1DATE + "'"
ret = AfaDBFunc.UpdateSqlCmt(sql)
if ret < 0:
AfaLoggerFunc.tradeInfo(AfaDBFunc.sqlErrMsg)
rccpsCronFunc.cronExit("S999","更新系统时间异常")
else:
AfaLoggerFunc.tradeInfo('主机日期['+HostContext.O1TRDT +']')
AfaLoggerFunc.tradeInfo('主机时间['+HostContext.O1TRTM +']')
else:
rccpsCronFunc.cronExit("S999","与主机同步系统时间异常")
AfaLoggerFunc.tradeInfo("***大前置系统: 同步主机日期与时间 退出***")
except Exception, e:
AfaDBFunc.RollbackSql()
AfaFlowControl.exitMainFlow( str(e) )
sys.exit(-1)
if __name__ == '__main__':
try:
AfaLoggerFunc.tradeInfo("***农信银系统: 系统调度类.通存通兑主机明细账勾兑[rccpsTDZJDZCompare]进入***")
#==========获取中心日期================================================
AfaLoggerFunc.tradeInfo(">>>开始获取前中心工作日期")
mbrifa_where_dict = {}
mbrifa_where_dict['OPRTYPNO'] = "30"
mbrifa_dict = rccpsDBTrcc_mbrifa.selectu(mbrifa_where_dict)
if mbrifa_dict == None:
AfaLoggerFunc.tradeInfo( AfaDBFunc.sqlErrMsg )
rccpsCronFunc.cronExit("S999","查询当前中心日期异常")
NCCWKDAT = mbrifa_dict['NOTE1'][:8] #对账日期
LNCCWKDAT = "('" + mbrifa_dict['NOTE3'].replace(",","','") + "')" #需要对账的中心日期(包括本清算工作日和之前的非清算工作日)
AfaLoggerFunc.tradeInfo(">>>结束获取前中心工作日期")
#===================前置少账==============================
AfaLoggerFunc.tradeInfo(">>>开始对账前置少账")
temp_sql = "insert into rcc_tdzjcz"
temp_sql = temp_sql + " (select a.nccwkdat,a.scfedt,a.scrbsq,'','',a.sctram,0.00,a.sceydt,a.sctlsq,'51','前置少账','0','','','',''"
temp_sql = temp_sql + " from rcc_tdzjmx as a"
temp_sql = temp_sql + " where a.nccwkdat in " + LNCCWKDAT
temp_sql = temp_sql + " and not exists ("
temp_sql = temp_sql + " select * from rcc_sstlog as b where b.fedt = a.scfedt and b.rbsq = a.scrbsq"
if __name__ == '__main__':
try:
AfaLoggerFunc.tradeInfo("***农信银系统: 系统调度类.行名行号生效处理[rccpsHHEffict]进入***")
#==========获取中心日期================================================
AfaLoggerFunc.tradeInfo(">>>开始获取前中心工作日期")
mbrifa_where_dict = {}
mbrifa_where_dict['OPRTYPNO'] = "30"
mbrifa_dict = rccpsDBTrcc_mbrifa.selectu(mbrifa_where_dict)
if mbrifa_dict == None:
AfaLoggerFunc.tradeInfo( AfaDBFunc.sqlErrMsg )
rccpsCronFunc.cronExit("S999","查询当前中心日期异常")
NCCWKDAT = mbrifa_dict['NWWKDAT'][:8] #当前中心工作日期
AfaLoggerFunc.tradeInfo(">>>结束获取前中心工作日期")
#========行号生效处理==================================================
AfaLoggerFunc.tradeInfo("开始生效行号")
bank_sql = ""
bank_sql = bank_sql + "update rcc_paybnk set note1 = '1' "
bank_sql = bank_sql + "where alttype in ('1','2') and bankbin in ("
bank_sql = bank_sql + "select bankbin from rcc_paybnk "
bank_sql = bank_sql + "where '" + NCCWKDAT + "' >= efctdat)"
AfaLoggerFunc.tradeInfo(bank_sql)
if __name__ == '__main__':
try:
AfaLoggerFunc.tradeInfo("***农信银系统: 系统调度类.汇票对账明细账勾兑[rccpshpdzMXCompare]进入***")
#==========获取中心日期================================================
AfaLoggerFunc.tradeInfo(">>>开始获取前中心工作日期")
mbrifa_where_dict = {}
mbrifa_where_dict['OPRTYPNO'] = "20"
mbrifa_dict = rccpsDBTrcc_mbrifa.selectu(mbrifa_where_dict)
if mbrifa_dict == None:
AfaLoggerFunc.tradeInfo( AfaDBFunc.sqlErrMsg )
rccpsCronFunc.cronExit("S999","查询当前中心日期异常")
NCCWKDAT = mbrifa_dict['NOTE1'][:8] #对账日期
LNCCWKDAT = "('" + mbrifa_dict['NOTE4'].replace(",","','") + "')" #需要对账的中心日期(包括本清算工作日和之前的非清算工作日)
AfaLoggerFunc.tradeInfo(">>>结束获取前中心工作日期")
#===================往账行内有,中心无====================================
AfaLoggerFunc.tradeInfo(">>>开始对账往账行内有,中心无类型")
temp_sql = ""
temp_sql = temp_sql + "insert into rcc_hpdzcz (select a.sndbnkco,a.trcdat,a.trcno,a.nccwkdat,a.trcco,a.bjedte,a.bspsqn,'01','往账行内有,中心无','" + PL_ISDEAL_UNDO + "','','','','' "
temp_sql = temp_sql + "from rcc_bilbka as a,rcc_spbsta as b "
temp_sql = temp_sql + "where a.trcco not in ('2100102','2100104') and a.bjedte = b.bjedte and a.bspsqn = b.bspsqn and a.nccwkdat in " + LNCCWKDAT + " and b.bcstat = '42' and a.brsflg = '0' and not exists "
temp_sql = temp_sql + "(select * from rcc_hpdzmx as c where a.sndbnkco = c.sndbnkco and a.trcdat = c.trcdat and a.trcno = c.trcno ))"
if __name__ == '__main__':
try:
AfaLoggerFunc.tradeInfo("***农信银系统: 系统调度类.农信银通存通兑错账文件生成及发送到差错处理平台[rccpsTDDZCZPutFile]进入***")
#==========获取中心日期================================================
AfaLoggerFunc.tradeInfo(">>>开始获取前中心工作日期")
mbrifa_where_dict = {}
mbrifa_where_dict['OPRTYPNO'] = "30"
mbrifa_dict = rccpsDBTrcc_mbrifa.selectu(mbrifa_where_dict)
if mbrifa_dict == None:
AfaLoggerFunc.tradeInfo( AfaDBFunc.sqlErrMsg )
rccpsCronFunc.cronExit("S999","查询当前中心日期异常")
NCCWKDAT = mbrifa_dict['NOTE1'][:8] #对账日期
LNCCWKDAT = "('" + mbrifa_dict['NOTE3'].replace(",","','") + "')"
AfaLoggerFunc.tradeInfo(">>>结束获取前中心工作日期")
#================根据通存通兑对账明细登记簿,生成通存通兑差错处理文件============
AfaLoggerFunc.tradeInfo(">>>开始生成通存通兑差错处理文件")
tddzcz_where_sql = "NCCWKDAT in " + LNCCWKDAT
tddzcz_list = rccpsDBTrcc_tddzcz.selectm(1,0,tddzcz_where_sql,"")
if tddzcz_list == None:
rccpsCronFunc.cronExit("S999","查询通存通兑对账错账登记簿异常")
AfaLoggerFunc.tradeInfo("***农信银系统: 系统调度类.汇兑对账错账处理[rccpsHDDZCZModify]进入***")
#==========初始化未完成标识为False=====================================
uncomplate_flag = False
#==========获取中心日期================================================
AfaLoggerFunc.tradeInfo(">>>开始获取前中心工作日期")
mbrifa_where_dict = {}
mbrifa_where_dict['OPRTYPNO'] = "20"
mbrifa_dict = rccpsDBTrcc_mbrifa.selectu(mbrifa_where_dict)
if mbrifa_dict == None:
AfaLoggerFunc.tradeInfo( AfaDBFunc.sqlErrMsg )
rccpsCronFunc.cronExit("S999","查询当前中心日期异常")
NCCWKDAT = mbrifa_dict['NOTE1'][:8] #对账日期
LNCCWKDAT = "('" + mbrifa_dict['NOTE3'].replace(",","','") + "')"
AfaLoggerFunc.tradeInfo(">>>结束获取前中心工作日期")
#================往账行内有,中心无=====================================
AfaLoggerFunc.tradeInfo(">>>开始处理往账行内有,中心无类型")
hddzcz_where_sql = "nccwkdat in " + LNCCWKDAT + " and eactyp = '01' and isdeal = '" + PL_ISDEAL_UNDO + "'"
hddzcz_list = rccpsDBTrcc_hddzcz.selectm(1,0,hddzcz_where_sql,"")
if hddzcz_list == None:
AfaLoggerFunc.tradeInfo(AfaDBFunc.sqlErrMsg)
rccpsCronFunc.cronExit("S999","查询此错账类型相关记录异常")
try:
AfaLoggerFunc.tradeInfo("***农信银系统: 系统调度类.汇兑对账汇总文件导入[rccpsHDDZHZFileImport]进入***")
local_home = os.environ['AFAP_HOME'] + "/data/rccps/"
#==========获取中心日期================================================
AfaLoggerFunc.tradeInfo(">>>开始获取前中心工作日期")
mbrifa_where_dict = {}
mbrifa_where_dict['OPRTYPNO'] = "20"
mbrifa_dict = rccpsDBTrcc_mbrifa.selectu(mbrifa_where_dict)
if mbrifa_dict == None:
AfaLoggerFunc.tradeInfo( AfaDBFunc.sqlErrMsg )
rccpsCronFunc.cronExit("S999","查询当前中心日期异常")
NCCWKDAT = mbrifa_dict['NOTE1'][:8] #对账日期
AfaLoggerFunc.tradeInfo(">>>结束获取前中心工作日期")
#====================导入汇兑对账汇总文件===================================
AfaLoggerFunc.tradeInfo(">>>开始导入汇兑对账汇总文件")
file_path = local_home + "settlefile/HDHZCNY1340000008" + NCCWKDAT
fp = open(file_path,"r")
if fp == None:
rccpsCronFunc.cronExit("S999","打开汇兑对账汇总文件异常")
if __name__ == '__main__':
try:
AfaLoggerFunc.tradeInfo("***农信银系统: 系统调度类.农信银汇兑错账文件生成及发送到主机[rccpsHDDZMXPutFile]进入***")
#==========获取中心日期================================================
AfaLoggerFunc.tradeInfo(">>>开始获取前中心工作日期")
mbrifa_where_dict = {}
mbrifa_where_dict['OPRTYPNO'] = "20"
mbrifa_dict = rccpsDBTrcc_mbrifa.selectu(mbrifa_where_dict)
if mbrifa_dict == None:
AfaLoggerFunc.tradeInfo( AfaDBFunc.sqlErrMsg )
rccpsCronFunc.cronExit("S999","查询当前中心日期异常")
NCCWKDAT = mbrifa_dict['NOTE1'][:8] #对账日期
LNCCWKDAT = "('" + mbrifa_dict['NOTE3'].replace(",","','") + "')"
AfaLoggerFunc.tradeInfo(">>>结束获取前中心工作日期")
#================根据汇兑对账明细登记簿,生成汇兑主机对账文件============
AfaLoggerFunc.tradeInfo(">>>开始生成汇兑主机对账文件")
hddzmx_where_sql = "NCCWKDAT in " + LNCCWKDAT
hddzmx_list = rccpsDBTrcc_hddzmx.selectm(1,0,hddzmx_where_sql,"")
if hddzmx_list == None:
rccpsCronFunc.cronExit("S999","查询汇兑对账明细登记簿异常")
try:
AfaLoggerFunc.tradeInfo("***农信银系统: 系统调度类.汇兑对账明细文件导入[rccpsHDDZMXFileImport]进入***")
local_home = os.environ['AFAP_HOME'] + "/data/rccps/"
#==========获取中心日期================================================
AfaLoggerFunc.tradeInfo(">>>开始获取前中心工作日期")
mbrifa_where_dict = {}
mbrifa_where_dict['OPRTYPNO'] = "20"
mbrifa_dict = rccpsDBTrcc_mbrifa.selectu(mbrifa_where_dict)
if mbrifa_dict == None:
AfaLoggerFunc.tradeInfo( AfaDBFunc.sqlErrMsg )
rccpsCronFunc.cronExit("S999","查询当前中心日期异常")
NCCWKDAT = mbrifa_dict['NOTE1'][:8] #对账日期
AfaLoggerFunc.tradeInfo(">>>结束获取前中心工作日期")
#====================导入汇兑对账明细文件===================================
AfaLoggerFunc.tradeInfo(">>>开始导入汇兑对账明细文件")
file_path = local_home + "settlefile/HDMXCNY1340000008" + NCCWKDAT
fp = open(file_path,"r")
if fp == None:
rccpsCronFunc.cronExit("S999","打开汇兑对账明细文件异常")
try:
AfaLoggerFunc.tradeInfo("***农信银系统: 系统调度类.汇兑对账文件下载[rccpsHDDZGetFile]进入***")
local_home = os.environ['AFAP_HOME'] + "/data/rccps/"
#==========获取中心日期================================================
AfaLoggerFunc.tradeInfo(">>>开始获取前中心工作日期")
mbrifa_where_dict = {}
mbrifa_where_dict['OPRTYPNO'] = "20"
mbrifa_dict = rccpsDBTrcc_mbrifa.selectu(mbrifa_where_dict)
if mbrifa_dict == None:
AfaLoggerFunc.tradeInfo( AfaDBFunc.sqlErrMsg )
rccpsCronFunc.cronExit("S999","查询当前中心日期异常")
NCCWKDAT = mbrifa_dict['NOTE1'][:8] #对账日期
AfaLoggerFunc.tradeInfo(">>>结束获取前中心工作日期")
#================判断前置机汇兑对账文件是否传送完毕=========================
AfaLoggerFunc.tradeInfo(">>>开始判断前置机汇兑对账文件是否传送完毕")
file_path = "settlefile/hdsendend1340000008"
if not rccpsFtpFunc.getRccps(file_path):
rccpsCronFunc.cronExit("S999","下载文件[" + file_path + "]异常")
local_file_path = local_home + file_path
if __name__ == '__main__':
try:
AfaLoggerFunc.tradeInfo("***农信银系统: 系统调度类.农信银通存通兑错账文件生成及发送到主机[rccpsHDDZMXPutFile]进入***")
#==========获取中心日期================================================
AfaLoggerFunc.tradeInfo(">>>开始获取前中心工作日期")
mbrifa_where_dict = {}
mbrifa_where_dict['OPRTYPNO'] = "30"
mbrifa_dict = rccpsDBTrcc_mbrifa.selectu(mbrifa_where_dict)
if mbrifa_dict == None:
AfaLoggerFunc.tradeInfo( AfaDBFunc.sqlErrMsg )
rccpsCronFunc.cronExit("S999","查询当前中心日期异常")
NCCWKDAT = mbrifa_dict['NOTE1'][:8] #对账日期
LNCCWKDAT = "('" + mbrifa_dict['NOTE3'].replace(",","','") + "')"
AfaLoggerFunc.tradeInfo(">>>结束获取前中心工作日期")
#================根据通存通兑对账明细登记簿,生成通存通兑主机对账文件============
AfaLoggerFunc.tradeInfo(">>>开始生成通存通兑主机对账文件")
tddzmx_where_sql = "NCCWKDAT in " + LNCCWKDAT
tddzmx_where_sql = tddzmx_where_sql + " and ((trcco in ('3000002','3000003','3000004','3000005') and confflg = '1') or (trcco in ('3000102','3000103','3000104','3000105') and confflg = '0')) and cancflg = '0'"
tddzmx_where_sql = tddzmx_where_sql + " and not exists (select * from rcc_tddzcz where rcc_tddzmx.sndbnkco = rcc_tddzcz.sndbnkco and rcc_tddzmx.trcdat = rcc_tddzcz.trcdat and rcc_tddzmx.trcno = rcc_tddzcz.trcno )"
tddzmx_list = rccpsDBTrcc_tddzmx.selectm(1,0,tddzmx_where_sql,"")
