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)