def get_order_list():
'''查询订单列表'''
page, size = paginate()
time_validator = TimeIntervalValidator().nt_data
paged_orders = OrderDao.get_summary(page=page,
size=size,
start=time_validator.start,
end=time_validator.end)
return Success(paged_orders)
def get_category_list():
'''查询「产品类别」列表'''
page, size = paginate()
paginator = Category.query.filter_by().paginate(page=page, per_page=size, error_out=False)
return Success({
'total': paginator.total,
'current_page': paginator.page,
'items': paginator.items
})
def get_log_list():
'''查询登录日志列表'''
page, size = paginate()
start, end = time_interval()
paginator = LoginLogDao.get_log_list(page, size, start, end)
return Success({
'total': paginator.total,
'current_page': paginator.page,
'items': paginator.items
})
def get_element_by_route():
'''查询页面元素(基于路由)'''
page, size = paginate()
route_id = RouteIdValidator().dt_data.route_id
elements = Element.query.filter_by(route_id=route_id).paginate(
page=page, per_page=size, error_out=True)
return Success({
'total': elements.total,
'current_page': elements.page,
'items': elements.items
})
def get_log_list_by_search():
'''搜索操作日志(按人员&时间&内容)'''
page, size = paginate()
start, end = time_interval()
user_name, keyword = LogSearchValidator().get_data('username', 'keyword')
paginator = OperLogDao.get_log_list_by_search(page, size, start, end, user_name, keyword)
return Success({
'total': paginator.total,
'current_page': paginator.page,
'items': paginator.items
})
def get_config_list():
'''查询参数配置列表'''
page, size = paginate()
paginator = Config.query.filter_by().paginate(page=page,
per_page=size,
error_out=True)
return Success({
'total': paginator.total,
'current_page': paginator.page,
'items': paginator.items
})
def get_dict_type_list():
'''查询字典类型列表'''
page, size = paginate()
paginator = DictType.query.filter_by().paginate(page=page,
per_page=size,
error_out=True)
return Success({
'total': paginator.total,
'current_page': paginator.page,
'items': paginator.items
})
def get_notice_list():
'''查询通知列表'''
page, size = paginate()
paginator = Notice.query.filter_by().paginate(page=page,
per_page=size,
error_out=True)
return Success({
'total': paginator.total,
'current_page': paginator.page,
'items': paginator.items
})
def get_theme_list():
'''查询主题列表(分页)'''
page, size = paginate()
paginator = Theme.query.filter_by().paginate(page=page,
per_page=size,
error_out=False)
return Success({
'total': paginator.total,
'current_page': paginator.page,
'items': paginator.items
})
def get_file_list():
'''查询文件列表'''
main_validator = FileParentIDValidator().dt_data
page, size = paginate()
files = File.query.filter_by(**main_validator) \
.paginate(page=page, per_page=size, error_out=False)
return Success({
'total': files.total,
'current_page': files.page,
'items': files.items
})
def get_dict_list():
'''查询字典数据列表'''
page, size = paginate()
type = DictTypeValidator().get_data('type')
paginator = Dict.query.filter_by(type=type).paginate(page=page,
per_page=size,
error_out=True)
return Success({
'total': paginator.total,
'current_page': paginator.page,
'items': paginator.items
})
def get_user_list():
'''查询用户列表(分页)'''
page, size = paginate()
rv = UserDao.get_user_list(page, size)
return Success(rv)
def get_log_list():
'''查询异常日志列表'''
page, size = paginate()
start, end = time_interval()
return Success()
def get_latest_article_list():
'''查询最新文章列表'''
type = ArticleTypeValidator().get_data('type')
page, size = paginate()
articles = ArticleDao.get_recent_article_list(type, page, size)
return Success(articles)
def get_admin_list():
'''查询管理员列表'''
page, size = paginate()
group_id = int(request.args.get('group_id')) # 可选
rv = AdminDao.get_admin_list(group_id=group_id, page=page, size=size)
return Success(rv)
def get_users():
'''查询用户列表'''
page, size = paginate()
paginator = OperLogDao.get_user_list(page, size)
return Success(paginator)
def get_order_list_by_user():
'''查询用户的订单列表'''
page, size = paginate()
user_id = get_request_args().uid
order_list = OrderDao.get_summary_by_user(uid=user_id, page=page, size=size)
return Success(order_list)
def get_banner_list():
'''查询订单列表'''
page, size = paginate()
banner_list = BannerDao.get_list(page=page, size=size)
return Success(banner_list)
def get_list_by_category():
'''查询类别下商品列表'''
category_id = CategoryIDValidator().nt_data.category_id
page, size = paginate()
rv = ProductDao.get_list_by_category(c_id=category_id, page=page, size=size)
return Success(rv)
def get_order_list():
'''查询订单列表'''
page, size = paginate()
paged_orders = OrderDao.get_summary_by_user(uid=g.user.id, page=page, size=size)
return Success(paged_orders)
