def unbind(): if request.method == 'POST': agentNo = request.form.get('agentNo') #获取接口请求中form-data的username参数传入的值 eqno = request.form.get('eqno') #获取接口请求中form-data的username参数传入的值 elif request.method == 'GET': agentNo = request.args.get('agentNo') eqno = request.args.get('eqno') else: agentNo = request.args.get('agentNo') eqno = request.args.get('eqno') if not agentNo and not eqno: log.info('没有获取到商户编号,并且没有获取到设备编号,请重新请求') return jsonify({ 'retCode': '-99', 'retMsg': 'has no agentNo ,and has no eqno!' }) #return jsonify({'retCode':'-99','retMsg':'没有获取到商户编号,也没有获取到设备编号'}) #return {'retCode':'-99','retMsg':'没有获取到商户编号,也没有获取到设备编号'} #if len(agentNo)>0 and len(eqno)>0: if agentNo and eqno: log.info("获取到的商户编号是:【" + agentNo + "】;设备编号是:【" + eqno + "】") sql = "select top 10 标识 id,插入时间 insertTime,设备编号 eqno,商户编号 agentNo,备注 remark,设备类型 equipType from [agent].[商户_绑定_设备] WHERE 商户编号='%s' and 设备编号='%s' " data = (agentNo, eqno) elif agentNo and not eqno: log.info("获取到的商户编号是:【" + agentNo + "】") sql = "select top 10 标识 id,插入时间 insertTime,设备编号 eqno,商户编号 agentNo,备注 remark,设备类型 equipType from [agent].[商户_绑定_设备] WHERE 商户编号='%s'" data = (agentNo) elif eqno and not agentNo: log.info("获取到的设备编号是:【" + eqno + "】") sql = "select top 10 标识 id,插入时间 insertTime,设备编号 eqno,商户编号 agentNo,备注 remark,设备类型 equipType from [agent].[商户_绑定_设备] WHERE 设备编号='%s'" data = (eqno) mssql = DBUtil('sqlserver') resp = mssql.ExecQuery(sql % data) if not resp: if agentNo and eqno: log.info("未查询到商户【" + agentNo + "】绑定设备【" + eqno + "】记录") elif agentNo and not eqno: log.info("该商户【" + agentNo + "】暂未查询到有绑定设备记录") elif eqno and not agentNo: log.info("该设备【" + eqno + "】暂未查询到有绑定记录") return jsonify({ 'retCode': '-98', 'retMsg': 'has no this agent records or eqno bind log' }) #return jsonify({'retCode':'-98','retMsg':'未查询到该商户或设备有绑定设备记录' }) #return {'retCode':'-98','retMsg':'未查询到该商户或设备有绑定设备记录' } updateFlag = True for i in range(len(resp)): log.info("该商户【" + resp[i]['agentNo'] + "】绑定的设备有:" + resp[i]['eqno']) sql = "UPDATE TOP(1) [agent].[商户_绑定_设备] SET 设备编号=设备编号+'_del' WHERE 设备编号='%s' " data2 = (resp[i]['eqno']) rowcount = mssql.ExecNonQuery(sql % data2) if rowcount == 1: log.info("设备编号【" + resp[i]['eqno'] + "】更新成功") else: log.info("设备编号【" + resp[i]['eqno'] + "】更新失败") updateFlag = False if not updateFlag: return jsonify({'retCode': '-1', 'retMsg': '设备解绑失败'}) #return jsonify({'retCode':'-1','retMsg':'eqno unbind fail!' }) #return {'retCode':'-1','retMsg':'设备解绑失败' } return jsonify({'retCode': '00', 'retMsg': 'eqno unbind success!'})
def updateUpgradeCodeType(): if request.method == 'POST': agentNo = request.form.get('agentNo') upgradeType = request.form.get('upgradeType') flag = request.form.get( 'flag') # 0 查询升级码类别对应的费率 1 要更新为新的升级码类别 elif request.method == 'GET': agentNo = request.args.get('agentNo') upgradeType = request.args.get('upgradeType') flag = request.args.get('flag') else: agentNo = request.args.get('agentNo') upgradeType = request.args.get('upgradeType') flag = request.args.get('flag') mssql = DBUtil('sqlserver') #查询费率信息 if flag == "0": if not upgradeType: log.info('查询升级码类别为空,请重新请求。') return jsonify({ 'retCode': '-99', 'retMsg': 'unvalid upgradeCode! please request Again!' }) #return jsonify({'retCode':'-99','retMsg':'升级码类别不能为空,请重新请求。'}) #return {'retCode':'-99','retMsg':'升级码类别不能为空,请重新请求。'} sql = '''SELECT TOP 1 CAST(交易费率 AS varchar(50)) rate,交易费率封顶值 rateLimit,结算策略组 settleType, CAST(加急费率 AS varchar(50)) quickRate,加急封顶 quickRateLimit FROM code.升级码_类别 WHERE 升级码类别='%s' AND 注册子渠道='大财神' ORDER BY 记录时间 DESC''' data = (upgradeType) resp = mssql.ExecQuery(sql % data) if not resp: log.info('获取到的升级码类别是:【' + upgradeType + '】,未查到该升级码类别对应的费率信息。') return jsonify({ 'retCode': '-96', 'retMsg': 'has no this upgradeCode!' }) #return jsonify({'retCode':'-96','retMsg':'未查到该升级码类别对应的费率信息。'}) #return {'retCode':'-96','retMsg':'未查到该升级码类别对应的费率信息。'} orderRate = resp[0]['rate'] rateInfo1 = "获取到的升级码类别是:【" + upgradeType + "】,查询相关信息:\n交易费率:【" + orderRate + "】,交易封顶金额:【" + str( resp[0]['rateLimit']) + "】" rateInfo2 = ",结算周期:【" + resp[0]['settleType'] + "】,\n加急费率:【" + str( resp[0]['quickRate']) + "】,加急封顶金额:【" + str( resp[0]['quickRateLimit']) + "】" rateInfo = rateInfo1 + rateInfo2 log.info(rateInfo) return jsonify({ 'retCode': '00', 'retMsg': 'query success!', 'codeType': upgradeType, 'fees': orderRate, 'feesCap': resp[0]['rateLimit'], 'settleTime': resp[0]['settleType'], 'urgentRate': resp[0]['quickRate'], 'urgentRateCap': resp[0]['quickRateLimit'] }) #return {'retCode':'00','retMsg':'查询成功','codeType':upgradeType,'fees':orderRate,'feesCap':resp[0]['rateLimit'],'settleTime':resp[0]['settleType'],'urgentRate':resp[0]['quickRate'],'urgentRateCap':resp[0]['quickRateLimit']} #更新费率 if not agentNo or not upgradeType: log.info('商户编号或者升级码类别为空,请重新请求。') #return jsonify({'retCode':'-99','retMsg':'商户编号或者升级码类别不能为空,请重新请求。'}) return jsonify({ 'retCode': '-99', 'retMsg': 'agentNo or upgradeCode can not empty!' }) #return {'retCode':'-99','retMsg':'商户编号或者升级码类别不能为空,请重新请求。'} sql2 = "SELECT TOP 1 升级码类别 codeType,升级码 code FROM [code].[升级码_经销商库存表] WITH(NOLOCK) WHERE 状态='已使用' and 升级码使用商户编号='%s'" data2 = (agentNo) resp2 = mssql.ExecQuery(sql2 % data2) if not resp2: log.info('获取到的商户编号是:【' + agentNo + '】,未查到该商户的升级码使用记录。') return jsonify({ 'retCode': '-98', 'retMsg': 'has no use records for this agent' }) #return jsonify({'retCode':'-98','retMsg':'未查到该商户的升级码使用记录。'}) #return {'retCode':'-98','retMsg':'未查到该商户的升级码使用记录。'} log.info("获取到的商户编号是:【" + agentNo + "】,修改前的升级码是:【" + resp2[0]['code'] + "】,修改前的升级码类别为:【" + resp2[0]['codeType'] + "】,修改后的升级码类别为:【" + upgradeType + "】。") sql3 = "SELECT 升级码类别 codeType FROM agent.商户信息表 a WITH(NOLOCK),[code].[升级码_类别] c WITH(NOLOCK) WHERE a.来源子渠道=c.注册子渠道 AND 是否删除=0 AND 商户编号='%s' AND 升级码类别='%s' " data3 = (agentNo, upgradeType) resp3 = mssql.ExecQuery(sql3 % data3) if not resp3: log.info("该商户编号:【" + agentNo + "】暂不支持此【" + upgradeType + "】升级码类别。") return jsonify({ 'retCode': '-97', 'retMsg': 'unsupport this upgradeCode type:【' + upgradeType + '】 ' }) #return jsonify({'retCode':'-97','retMsg':'暂不支持此【'+upgradeType+'】升级码类别。'}) #return {'retCode':'-97','retMsg':'暂不支持此【'+upgradeType+'】升级码类别。'} sql4 = "UPDATE TOP(1) [code].[升级码_经销商库存表] SET 升级码类别='%s' WHERE 状态='已使用' and 升级码使用商户编号='%s'" data4 = (upgradeType, agentNo) rowcount = mssql.ExecNonQuery(sql4 % data4) if rowcount == 1: log.info("商户编号【" + agentNo + "】对应的升级码类别更新成功。") return jsonify({'retCode': '00', 'retMsg': 'ragte update success!'}) #return jsonify({'retCode':'00','retMsg':'费率更新成功'}) #return {'retCode':'00','retMsg':'费率更新成功'} else: log.info("商户编号【" + agentNo + "】对应的升级码类别更新失败。") #return jsonify({'retCode':'-1','retMsg':'费率更新失败'}) return jsonify({'retCode': '00', 'retMsg': 'ragte update fail!'})