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)