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,"")