def lum_change():
phone = request.args.get('phone')
user_name = request.args.get('userName')
account = request.args.get('account')
key = request.args.get('key')
t = time.time() + 4
if t < float(key):
return jsonify({'code': 404, 'msg': '超出范围时间!'})
send = CCP()
res = send.send_Template_sms(int(phone), [user_name, account], 476970)
return jsonify({'code': res, 'msg': ''})
def top_up():
results = {"code": RET.OK, "msg": MSG.OK}
try:
data = request.form.get('money')
name = request.form.get('name')
pay_num = sum_code()
t = xianzai_time()
money = float(data)
before = SqlData().search_user_field_name('balance', name)
user_id = SqlData().search_user_field_name('id', name)
# 更新账户余额
SqlData().update_user_balance(money, user_id)
# 实时查询当前余额,不以理论计算为结果
balance = SqlData().search_user_field('balance', user_id)
# 更新客户充值记录
SqlData().insert_top_up(pay_num, t, money, before, balance, user_id, '系统')
phone = SqlData().search_user_field_name('phone_num', name)
if phone:
CCP().send_Template_sms(phone, [name, t, money], 478898)
return jsonify(results)
except Exception as e:
logging.error(e)
results['code'] = RET.SERVERERROR
results['msg'] = MSG.SERVERERROR
return jsonify(results)
def ver_code_send():
'''
手机验证码的保存于验证
:return:
'''
if request.method == 'POST':
data = json.loads(request.form.get('data'))
phone = data.get('phone')
ver_key = data.get('ver_key')
_code = verify_code(6, False)
res = CCP().send_Template_sms(phone, [_code, '60s'], 488547,)
if res == 0:
cache.set(ver_key, _code, timeout=120)
return jsonify({'code': RET.OK, 'msg': MSG.OK})
else:
return jsonify({'code': RET.SERVERERROR, 'msg': '短信发送失败!请检查号码是否正确!'})
def top_up():
if request.method == 'GET':
pay_time = request.args.get('pay_time')
cus_name = request.args.get('cus_name')
bank_msg = request.args.get('bank_msg')
context = dict()
context['pay_time'] = pay_time
context['cus_name'] = cus_name
context['bank_msg'] = bank_msg
return render_template('verify_pay/check.html', **context)
if request.method == 'POST':
try:
results = dict()
data = json.loads(request.form.get('data'))
pay_time = data.get('pay_time')
cus_name = data.get('cus_name')
check = data.get('check')
ver_code = data.get('ver_code')
bank_address = data.get("bank_msg")
# 校验参数验证激活码
if check != 'yes':
results['code'] = RET.SERVERERROR
results['msg'] = '请确认已收款!'
return jsonify(results)
pass_wd = SqlData.search_pay_code('ver_code', cus_name, pay_time)
if pass_wd != ver_code:
results['code'] = RET.SERVERERROR
results['msg'] = '验证码错误!'
return jsonify(results)
status = SqlData.search_pay_code('status', cus_name, pay_time)
if status != '待充值':
results['code'] = RET.SERVERERROR
results['msg'] = '该订单已充值,请刷新界面!'
return jsonify(results)
# 验证成功后,做客户账户充值
cus_id = SqlData.search_user_field_name('id', cus_name)
'''
# 判断是否需要更改充值金额(取消改动充值金额权限)
if not money:
money = SqlData.search_pay_code('top_money', cus_name, pay_time)
else:
money = float(money)
# 更新新的充值金额
SqlData.update_pay_money(money, cus_id, pay_time)
'''
money = SqlData.search_pay_code('top_money', cus_name, pay_time)
pay_num = sum_code()
t = xianzai_time()
before = SqlData.search_user_field_name('balance', cus_name)
balance = before + money
user_id = SqlData.search_user_field_name('id', cus_name)
pay_money = SqlData.search_pay_code('pay_money', cus_name,
pay_time)
# 更新银行卡收款金额
if bank_address:
pattern = re.compile(r'\d+\.?\d*')
bank_number = pattern.findall(bank_address)
bank_money = SqlData.search_bank_top(bank_number)
update_money = float(pay_money) + float(bank_money)
SqlData.update_bank_top(bank_number, float(pay_money),
update_money)
else:
# 更新首款码收款金额
# pay_money = SqlData.search_pay_code('pay_money', cus_name, pay_time)
url = SqlData.search_pay_code('url', cus_name, pay_time)
SqlData.update_qr_money('top_money', pay_money, url)
# 更新账户余额
SqlData.update_user_balance(money, user_id)
# 更新客户充值记录
SqlData.insert_top_up(pay_num, t, money, before, balance, user_id)
# 更新pay_log的订单的充值状态
SqlData.update_pay_status('已充值', t, cus_id, pay_time)
phone = SqlData.search_user_field_name('phone_num', cus_name)
mid_phone = SqlData.search_pay_code('phone', cus_name, pay_time)
# 给客户和代充值人发送短信通知
money_msg = "{}元, 可用余额{}".format(money, balance)
if phone:
phone_list = phone.split(",")
for p in phone_list:
CCP().send_Template_sms(p, [cus_name, t, money_msg],
485108)
if mid_phone:
CCP().send_Template_sms(mid_phone, [cus_name, t, money_msg],
485108)
results['code'] = RET.OK
results['msg'] = MSG.OK
return jsonify(results)
except Exception as e:
logging.error(str(e))
results = dict()
results['code'] = RET.SERVERERROR
results['msg'] = str(e)
return jsonify(results)
def top_up():
if request.method == 'GET':
pay_time = request.args.get('pay_time')
cus_name = request.args.get('cus_name')
context = dict()
context['pay_time'] = pay_time
context['cus_name'] = cus_name
return render_template('verify_pay/check.html', **context)
if request.method == 'POST':
try:
results = dict()
data = json.loads(request.form.get('data'))
pay_time = data.get('pay_time')
cus_name = data.get('cus_name')
check = data.get('check')
ver_code = data.get('ver_code')
money = data.get('money')
# 校验参数验证激活码
if check != 'yes':
results['code'] = RET.SERVERERROR
results['msg'] = '请确认已收款!'
return jsonify(results)
pass_wd = SqlData().search_pay_code('ver_code', cus_name, pay_time)
if pass_wd != ver_code:
results['code'] = RET.SERVERERROR
results['msg'] = '验证码错误!'
return jsonify(results)
status = SqlData().search_pay_code('status', cus_name, pay_time)
if status != '待充值':
results['code'] = RET.SERVERERROR
results['msg'] = '该订单已充值,请刷新界面!'
return jsonify(results)
# 验证成功后,做客户账户充值
cus_id = SqlData().search_user_field_name('id', cus_name)
# 判断是否需要根据输入的美元金额扣除手续费在充值
if money:
money = float(money)
# 更新新的充值金额
dollar_hand = SqlData().search_admin_field('dollar_hand')
money = round(money / (1+dollar_hand), 2)
SqlData().update_pay_money(money, cus_id, pay_time)
money = SqlData().search_pay_code('top_money', cus_name, pay_time)
pay_num = sum_code()
t = xianzai_time()
before = SqlData().search_user_field_name('balance', cus_name)
user_id = SqlData().search_user_field_name('id', cus_name)
# 更新首款码收款金额
pay_money = SqlData().search_pay_code('pay_money', cus_name, pay_time)
url = SqlData().search_pay_code('url', cus_name, pay_time)
SqlData().update_qr_money('top_money', pay_money, url)
# 更新账户余额
SqlData().update_user_balance(money, user_id)
# 实时查询当前余额不以理论计算为结果
balance = SqlData().search_user_field('balance', user_id)
# 更新客户充值记录
SqlData().insert_top_up(pay_num, t, money, before, balance, user_id, '系统')
# 更新pay_log的订单的充值状态
SqlData().update_pay_status('已充值', t, cus_id, pay_time)
phone = SqlData().search_user_field_name('phone_num', cus_name)
mid_phone = SqlData().search_pay_code('phone', cus_name, pay_time)
# 判断是否是相同电话，是则只发送一次短信
if phone and mid_phone and phone == mid_phone:
CCP().send_Template_sms(phone, [cus_name, t, money], 478898)
else:
# 给客户和代充值人发送短信通知
if phone:
CCP().send_Template_sms(phone, [cus_name, t, money], 478898)
if mid_phone:
CCP().send_Template_sms(mid_phone, [cus_name, t, money], 478898)
results['code'] = RET.OK
results['msg'] = MSG.OK
return jsonify(results)
except Exception as e:
logging.error(str(e))
results = dict()
results['code'] = RET.SERVERERROR
results['msg'] = MSG.SERVERERROR
return jsonify(results)
def reg_check():
if request.method == 'GET':
pay_time = request.args.get('pay_time')
u_name = request.args.get('u_name')
package = request.args.get('package')
context = dict()
context['pay_time'] = pay_time
context['u_name'] = u_name
context['package'] = package
return render_template('verify_pay/reg_check.html', **context)
if request.method == 'POST':
try:
results = dict()
data = json.loads(request.form.get('data'))
pay_time = data.get('pay_time')
u_name = data.get('u_name')
package = data.get('package')
check = data.get('check')
ver_code = data.get('ver_code')
# 校验参数验证激活码
if check != 'yes':
results['code'] = RET.SERVERERROR
results['msg'] = '请确认已收款!'
return jsonify(results)
# 查询邮件中的验证码
pass_wd = SqlData().search_account_reg_field('ver_code', pay_time, u_name)
if pass_wd != ver_code:
results['code'] = RET.SERVERERROR
results['msg'] = '验证码错误!'
return jsonify(results)
# 却认订单状态
status = SqlData().search_account_reg_field('status', pay_time, u_name)
if status:
results['code'] = RET.SERVERERROR
results['msg'] = '该订单已充值,请刷新界面!'
return jsonify(results)
# 验证成功后,做新增客户端账号(基础参数还需:建卡费, 最低充值,最高充值)
# 根据选择的套餐查出对应的收费标准
data = SqlData().search_reg_money(package)
price = data.get('price')
refund = data.get('refund')
min_top = data.get('min_top')
max_top = data.get('max_top')
u_acc = SqlData().search_account_reg_field('u_acc', pay_time, u_name)
u_pass = SqlData().search_account_reg_field('u_pass', pay_time, u_name)
phone = SqlData().search_account_reg_field('phone', pay_time, u_name)
start_time = SqlData().search_account_reg_field('start_time', pay_time, u_name)
stop_time = SqlData().search_account_reg_field('stop_time', pay_time, u_name)
SqlData().insert_account(u_acc, u_pass, phone, u_name, price, refund, min_top, max_top, start_time, stop_time)
# 添加默认充值记录0元(用于单独充值结算总充值金额避免BUG)
n_time = xianzai_time()
account_id = SqlData().search_user_field_name('id', u_name)
SqlData().insert_top_up('10001', n_time, 0, 0, 0, account_id, '系统')
# 判断是否是中介介绍,如果是则绑定到中介
middle_id = SqlData().search_account_reg_field('middle_id', pay_time, u_name)
if middle_id:
SqlData().update_user_field_int('middle_id', middle_id, account_id)
# 更新首款码收款金额
pay_money = SqlData().search_account_reg_field('reg_money', pay_time, u_name)
url = SqlData().search_account_reg_field('url', pay_time, u_name)
SqlData().update_qr_money('top_money', pay_money, url)
# 更新订单状态和确认时间
SqlData().update_account_reg_field('status', '已确认', pay_time, u_name)
SqlData().update_account_reg_field('ver_time', n_time, pay_time, u_name)
# 给客户和代充值人发送短信通知
if phone:
CCP().send_Template_sms(phone, [u_name, n_time, u_acc, u_pass], 488712)
results['code'] = RET.OK
results['msg'] = MSG.OK
return jsonify(results)
except Exception as e:
logging.error(str(e))
results = dict()
results['code'] = RET.SERVERERROR
results['msg'] = MSG.SERVERERROR
return jsonify(results)