def account_info():
page = request.args.get('page')
limit = request.args.get('limit')
range_time = request.args.get('date')
results = {"code": RET.OK, "msg": MSG.OK, "count": 0, "data": ""}
task_one = SqlData.search_account_info()
if not range_time:
now_t = now_day()
else:
now_t = range_time
info_list = list()
for i in task_one:
class_info = i.get('class')
level = i.get('level')
if level == 'F':
math_url = SqlData.search_class_action(class_info, 'math', now_t)
lang_url = SqlData.search_class_action(class_info, 'lang', now_t)
if math_url and lang_url:
status = '已完成'
else:
status = '待完成'
i['math'] = math_url
i['lang'] = lang_url
i['status'] = status
i['level'] = '低年级'
elif level == 'T':
math_url = SqlData.search_class_action(class_info, 'math', now_t)
lang_url = SqlData.search_class_action(class_info, 'lang', now_t)
english_url = SqlData.search_class_action(class_info, 'english',
now_t)
if math_url and lang_url and english_url:
status = '已完成'
else:
status = '待完成'
i['math'] = math_url
i['lang'] = lang_url
i['english'] = lang_url
i['status'] = status
i['level'] = '高年级'
info_list.append(i)
task_info = info_list
page_list = list()
for i in range(0, len(task_info), int(limit)):
page_list.append(task_info[i:i + int(limit)])
data = page_list[int(page) - 1]
results['data'] = data
results['count'] = len(data)
return jsonify(results)
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)
