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)
balance = before + money
user_id = SqlData.search_user_field_name('id', name)
# 更新账户余额
SqlData.update_user_balance(money, 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 add_account():
if request.method == 'GET':
return render_template('admin/add_account.html')
if request.method == 'POST':
results = {"code": RET.OK, "msg": MSG.OK}
try:
data = json.loads(request.form.get('data'))
name = data.get('name').strip()
account = data.get('account').strip()
password = data.get('password').strip()
phone_num = data.get('phone_num')
create_price = float(data.get('create_price'))
min_top = float(data.get('min_top'))
max_top = float(30000)
ed_name = SqlData.search_user_field_name('account', name)
if ed_name:
results['code'] = RET.SERVERERROR
results['msg'] = '该用户名已存在!'
return jsonify(results)
if phone_num:
ret = re.match(r"^1[35789]\d{9}$", phone_num)
if not ret:
results['code'] = RET.SERVERERROR
results['msg'] = '请输入符合规范的电话号码!'
return jsonify(results)
else:
phone_num = ""
SqlData.insert_account(account, password, phone_num, name,
create_price, min_top, max_top)
# 创建用户后插入充值数据
pay_num = sum_code()
t = xianzai_time()
user_id = SqlData.search_user_field_name('id', name)
SqlData.insert_top_up(pay_num, t, 0, 0, 0, user_id)
SqlData.insert_account_trans(date=t,
trans_type="充值",
do_type="支出",
card_no=0,
do_money=0,
before_balance=0,
balance=0,
user_id=user_id)
return jsonify(results)
except Exception as e:
logging.error(e)
results['code'] = RET.SERVERERROR
results['msg'] = MSG.SERVERERROR
return jsonify(results)
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)
