async def user_list(request):
"""
用户列表
:param request:
:return:
"""
if request.method == 'GET':
user_query = Users.select().filter(Users.deleted == 0)
cookie = request.cookies.get("user")
user = get_cookies(AGENT_COOKIE_TOKEN, cookie)
username = user.get('username')
is_admin = user.get('is_admin')
kargs = {}
kargs['username'] = username
kargs['is_admin'] = is_admin
kargs['id'] = request.args.get("id", "")
kargs['phone'] = request.args.get("phone", "")
kargs["username"] = request.args.get("username", "")
kargs["level"] = request.args.get("level", "")
kargs["agent_id"] = request.args.get("agent_id", "")
kargs["is_admin"] = request.args.get("is_admin", "")
query = UserService().user_list(**kargs)
data = get_page_data(request, query)
return jinja.render("admin/user-list.html",
request,
kargs=kargs,
data=data,
user_query=user_query)
elif request.method == "POST":
id = request.form.get("id")
Users.update({Users.deleted: 1}).where(Users.id == id).execute()
return text("已删除")
async def pay_report_info(request):
if request.method == 'GET':
cookie = request.cookies.get("user")
user = get_cookies(AGENT_COOKIE_TOKEN, cookie)
user_id = user.get("id")
pay_report = PayOrders.select().filter(PayOrders.deleted == 0,PayOrders.user_id == user_id)
kargs = {}
kargs['user_id'] = request.args.get("user_id", "")
kargs["out_trade_no"] = request.args.get("out_trade_no", "")
# kargs["pay_trade_no"] = request.args.get("pay_trade_no","")
query = PayService().query_pay_report(kargs,user_id)
data = get_page_data(request, query)
return jinja.render("admin/pay_report.html", request, data=data, kargs=kargs, pay_report=pay_report)
async def commission_info(request):
if request.method == 'GET':
cookie = request.cookies.get("user")
user = get_cookies(AGENT_COOKIE_TOKEN, cookie)
kargs = {}
kargs["user_id"] = request.args.get("user_id", "")
kargs["from_user_id"] = request.args.get("from_user_id", "")
query = UserService().query_commission(user, **kargs)
data = get_page_data(request, query)
return jinja.render("admin/commission_list.html",
request,
data=data,
kargs=kargs)
async def balance_list(request):
kargs={}
kargs['id'] = request.args.get("id", "")
kargs['phone'] = request.args.get("phone", "")
kargs["username"] = request.args.get("username", "")
query = Balance().filter(Balance.deleted==0)
if "id" in kargs and kargs.get('id').strip():
query = query.filter(user_id=int(kargs["id"]))
if "username" in kargs and kargs.get('username').strip():
query = query.filter(username=kargs["username"])
if "phone" in kargs and kargs.get("phone").strip():
query = query.filter(phone=kargs["phone"])
data = get_page_data(request, query)
return jinja.render("admin/balance_all_list.html", request, data=data, kargs=kargs)
async def agent_info(request):
if request.method == 'GET':
cookie = request.cookies.get("user")
user = get_cookies(AGENT_COOKIE_TOKEN, cookie)
kargs = {}
kargs["agent_id"] = request.args.get("agent_id", "")
kargs["username"] = request.args.get("username", "")
kargs["user_id"] = request.args.get("user_id", "")
query = UserService().query_invite(user, **kargs)
data = get_page_data(request, query)
return jinja.render("admin/invite_report.html",
request,
data=data,
kargs=kargs)
async def order_list(request):
"""
订单列表
:param request:
:return:
"""
if request.method == 'GET':
users = request.app.user
kargs = {}
kargs["mailNo"] = request.args.get("mailNo", "")
kargs["sender_name"] = request.args.get("sender_name", "")
kargs["sender_mobile"] = request.args.get("sender_mobile", "")
kargs["recive_name"] = request.args.get("recive_name", "")
kargs["recive_mobile"] = request.args.get("recive_mobile", "")
query = OrderService().query_list(users, **kargs)
data = get_page_data(request, query)
return jinja.render("admin/order-list.html",
request,
kargs=kargs,
data=data)
async def area_list(request):
'''
地址管理
:param request:
:return:
'''
if request.method == 'GET':
cookie = request.cookies.get("user")
user = get_cookies(AGENT_COOKIE_TOKEN, cookie)
user_id = user.get("id")
send = SendAddress.select().filter(SendAddress.user_id==user_id,SendAddress.deleted == 0)
areas = Areas.select().filter(Areas.parent_code == '+86').order_by(Areas.order.asc())
kargs = {}
kargs["sender_name"] = request.args.get("sender_name", "")
kargs["sender_mobile"] = request.args.get("sender_mobile", "")
query = AreaService().query_list(user_id,**kargs)
data = get_page_data(request, query)
return jinja.render("admin/area_list.html", request, kargs=kargs, data=data, areas=areas,send=send)
elif request.method == "POST":
id = request.form.get("id")
SendAddress.update({SendAddress.deleted: 1}).where(SendAddress.id == id).execute()
return text("已删除")
async def device_ajax_list(request):
"""
条件查询
:param request:
:return:
"""
product = Product.select().filter(Product.deleted == 0)
# 广告组
advertise_group = AdvertiseGroup.select().filter(
AdvertiseGroup.deleted == 0)
# 代理人
device_agent = AgentMerchant.select().filter(AgentMerchant.deleted == 0)
# APPLY_ID
apply_id = DeviceBatchApply.select().filter(DeviceBatchApply.deleted == 0)
kargs = {}
kargs["sn_no"] = request.args.get("sn_no", "")
kargs["province"] = request.args.get("province", "")
kargs["area"] = request.args.get("area", "")
kargs["space_tag"] = request.args.get("space_tag", "")
kargs["product_name"] = request.args.get("product_name", "")
kargs["group_name"] = request.args.get("group_name", "")
kargs["agent_name"] = request.args.get("agent_name", "")
kargs["apply_id"] = request.args.get("apply_id", "")
kargs["status"] = request.args.get("status", "")
query = DeviceService().query_list(**kargs)
page = get_page_data(request, query)
data = {"render": page.render(), "result": []}
for i in page.result:
one_result = model_to_dict(i)
# 代理
if i.agent_id == 0:
one_result["agent_company"] = "无"
else:
agent = AgentMerchant.get(AgentMerchant.id == i.agent_id)
one_result["agent_company"] = agent.agent_company
# 广告组
if i.advertise_group_id == 0:
one_result["group_name"] = "无"
else:
group = AdvertiseGroup.get(
AdvertiseGroup.id == i.advertise_group_id)
one_result["group_name"] = group.group_name
# 分成
if i.profit_id == 0:
one_result["profit_name"] = "无"
else:
profit = AdvertiseProfit.get(AdvertiseProfit.id == i.profit_id)
one_result["profit_name"] = profit.profit_name
data["result"].append(one_result)
page_html = jinja.render_string("agent/ajax_device_list.html",
request,
data=data,
kargs=kargs,
products=product,
agents=device_agent,
groups=advertise_group,
apply_ids=apply_id)
return text(page_html)
async def device_list(request):
"""
条件查询
:param request:
:return:
"""
if request.method == 'GET':
# 产品
product = Product.select().filter(Product.deleted == 0)
# 广告组
advertise_group = AdvertiseGroup.select().filter(
AdvertiseGroup.deleted == 0)
# 代理人
device_agent = AgentMerchant.select().filter(
AgentMerchant.deleted == 0)
# APPLY_ID
apply_id = DeviceBatchApply.select().filter(
DeviceBatchApply.deleted == 0)
cookie = request.cookies.get('agent_user')
print("当前代理用户返回的cookies为 %s " % cookie)
agent_dict = get_cookies(AGENT_COOKIE_TOKEN, cookie)
print(agent_dict)
username = agent_dict.get('username')
level = agent_dict.get('level')
agent_id = request.app.get_id_by_show_id(agent_dict.get('show_id'))
agents = AgentMerchant.select().filter(AgentMerchant.deleted == 0)
kargs = {}
kargs['username'] = username
kargs['level'] = level
kargs['agent_id'] = agent_id
kargs["sn_no"] = request.args.get("sn_no", "")
kargs["province"] = request.args.get("province", "")
kargs["area"] = request.args.get("area", "")
kargs["space_tag"] = request.args.get("space_tag", "")
kargs["product_name"] = request.args.get("product_name", "")
kargs["group_name"] = request.args.get("group_name", "")
kargs["agent_name"] = request.args.get("agent_name", "")
kargs["apply_id"] = request.args.get("apply_id", "")
kargs["status"] = request.args.get("status", "")
kargs["produce_version"] = request.args.get("produce_no", "")
# query = DeviceService().query_list(**kargs)
query = DeviceService().query_child_device(agent_id)
page = get_page_data(request, query)
data = {"render": page.render(), "result": []}
for i in page.result:
one_result = model_to_dict(i)
# 代理
if i.agent_id == 0:
one_result["agent_company"] = "无"
else:
agent = AgentMerchant.get(AgentMerchant.id == i.agent_id)
one_result["agent_company"] = agent.agent_company
# # 广告组
# if i.advertise_group_id == 0:
# one_result["group_name"] = "无"
# else:
# group = AdvertiseGroup.get(AdvertiseGroup.id == i.advertise_group_id)
# one_result["group_name"] = group.group_name
# 分成
if i.profit_id == 0:
one_result["profit_name"] = "无"
else:
profit = AdvertiseProfit.get(AdvertiseProfit.id == i.profit_id)
one_result["profit_name"] = profit.profit_name
data["result"].append(one_result)
return jinja.render("agent/device-list.html",
request,
data=data,
kargs=kargs,
products=product,
agents=device_agent,
groups=advertise_group,
apply_ids=apply_id)
# 删除
elif request.method == "POST":
id = request.form.get("id")
Devices.update({Devices.deleted: 1}).where(Devices.id == id).execute()
device = Devices.select().filter(Devices.id == id).get()
agent_id = device.agent_id
if agent_id != 0:
id = AgentMerchant.select().filter(
AgentMerchant.id == agent_id).get()
AgentMerchant.update({
AgentMerchant.device_count:
int(id.device_count) - 1
}).where(AgentMerchant.id == id).execute()
return response.redirect('/agent_device/list')