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)