def account_info():
page = request.args.get('page')
limit = request.args.get('limit')
customer = request.args.get('customer')
results = {"code": RET.OK, "msg": MSG.OK, "count": 0, "data": ""}
if customer:
sql = "WHERE name LIKE '%" + customer + "%'"
else:
sql = ''
task_one = SqlData.search_account_info(sql)
if len(task_one) == 0:
results['MSG'] = MSG.NODATA
return results
task_info = list()
all_moneys = TransactionRecord().all_alias_money()
for u in task_one:
u_id = u.get('u_id')
# card_count = SqlData.search_card_count(u_id, '')
out_money = SqlData.search_trans_sum(u_id)
bento_income_money = SqlData.search_income_money(u_id)
# u['card_num'] = card_count
u['out_money'] = float("%.2f" % float(out_money - bento_income_money))
account_all_amount = 0
# all_moneys = TransactionRecord().all_alias_money()
all_cardids = SqlDataNative.attribution_fount_cardid(alias=u.get("name"))
if len(all_moneys) > 0 and len(all_cardids) > 0:
for all_cardid in all_cardids:
for all_money in all_moneys:
if all_cardid == all_money.get("cardid"):
account_all_amount = account_all_amount + all_money.get("availableAmount")
count_del_quant = SqlDataNative.count_del_data(alias=u.get("name"))
u['del_card_num'] = count_del_quant
u['account_all_money'] = float("%.2f" % account_all_amount)
u['card_balance'] = float("%.2f" % float(out_money - bento_income_money - account_all_amount))
u['in_card_num'] = len(all_cardids)
task_info.append(u)
page_list = list()
task_info = list(reversed(task_info))
for i in range(0, len(task_info), int(limit)):
page_list.append(task_info[i:i + int(limit)])
results['data'] = page_list[int(page) - 1]
results['count'] = len(task_info)
return jsonify(results)
def user_main():
user_id = g.user_id
balance = SqlData.search_user_field('balance', user_id)
# 支出中有部分退款产生，所以所有支出减去退款才是真实支出
sum_out_money = SqlData.search_trans_sum(
user_id) - SqlData.search_income_money(user_id)
sum_top_money = SqlData.search_user_field('sum_balance', user_id)
card_num = SqlData.search_card_status("WHERE user_id={}".format(user_id))
vice_num = SqlData.search_vice_count(user_id)
notice = SqlData.search_admin_field('notice')
card_remain = SqlData.search_sum_card_balance(user_id)
update_t = '2020-01-01 12:23:32'
context = dict()
context['balance'] = balance
context['sum_out_money'] = sum_out_money
context['sum_top_money'] = sum_top_money
context['card_num'] = card_num
context['card_remain'] = card_remain
context['update_t'] = update_t
context['vice_num'] = vice_num
context['notice'] = notice
return render_template('user/main.html', **context)
