def get(self, request):
global article_list
parent_id = request.GET['parent_id']
child_id = request.GET['child_id']
key = request.GET['key']
try:
if parent_id == '' and child_id == '':
article_list = Article.objects.filter(
Q(title__contains=key) | Q(user__user_name__contains=key))
elif parent_id != '' and child_id == '':
article_list = Article.objects.filter(
Q(category__parent_id=parent_id),
Q(title__contains=key) | Q(user__user_name__contains=key))
elif parent_id != '' and child_id != '':
article_list = Article.objects.filter(
Q(category__id=child_id), Q(category__parent_id=parent_id),
Q(title__contains=key) | Q(user__user_name__contains=key))
except KeyError:
article_list = Article.objects.filter(
Q(title__contains=key) | Q(user__user_name__contains=key))
article_list = article_list.order_by('-gmt_created')
page = FrontPagination()
page_articles = page.paginate_queryset(queryset=article_list,
request=request,
view=self)
articles_ser = ArticleSerializers(instance=page_articles, many=True)
return get_page_response(page, articles_ser.data)
def get(self, request, format=None): # 获取分类列表（分页 + 搜索）
global category_list
key = request.GET['key']
is_parent = request.GET['is_parent']
parent_id = request.GET.get('parent_id')
if is_parent == '0':
if parent_id == '' or parent_id is None:
category_list = Category.objects.filter(
category_name__contains=key, is_parent=0)
else:
category_list = Category.objects.filter(
category_name__contains=key, parent_id=int(parent_id))
elif is_parent == '1':
category_list = Category.objects.filter(
category_name__contains=key, is_parent=1)
elif is_parent == '' or is_parent is None:
category_list = Category.objects.filter(
category_name__contains=key)
category_list = category_list.order_by('-gmt_created')
page = StandardPagination()
page_sorts = page.paginate_queryset(queryset=category_list,
request=request,
view=self)
sorts_ser = CategorySerializers(instance=page_sorts, many=True)
return get_page_response(page, sorts_ser.data)
def get(self, request):
key = request.GET.get('key')
link_list = Link.objects.filter(
link_name__icontains=key).order_by('-created_time')
page = StandardPagination()
page_data = page.paginate_queryset(queryset=link_list,
request=request,
view=self)
links_ser = LinkSerializers(instance=page_data, many=True)
return get_page_response(page, links_ser.data)
def get(self, request):
key = request.GET['key']
slide_list = Slide.objects.filter(title__contains=key)
slide_list = slide_list.order_by('-gmt_created')
page = StandardPagination()
page_data = page.paginate_queryset(queryset=slide_list,
request=request,
view=self)
slides_ser = SlideSerializers(instance=page_data, many=True)
return get_page_response(page, slides_ser.data)
def get(self, request, format=True):
key = request.GET.get('key', '')
user_list = User.objects.filter(
Q(user_authority=0),
Q(user_name__contains=key) | Q(mobile_phone__contains=key)
| Q(email__contains=key)).order_by('id')
# print(user_list.values())
page = StandardPagination()
page_users = page.paginate_queryset(queryset=user_list,
request=request,
view=self)
users_ser = UserSerializers(instance=page_users, many=True)
return get_page_response(page, users_ser.data)
def get(self, request):
category = request.GET.get('category')
if category != '':
article_list = Article.objects.filter(
Q(category__category_name=category) | Q(category__parent__category_name=category),
Q(is_show=1))
else:
article_list = Article.objects.filter(Q(is_show=1))
article_list = article_list.order_by('-gmt_created')
page = FrontPagination()
page_articles = page.paginate_queryset(queryset=article_list, request=request, view=self)
articles_ser = ArticleSerializers(instance=page_articles, many=True)
return get_page_response(page, articles_ser.data)
def get(self, request):
global comment_list
type = request.GET.get('type')
date_min = request.GET.get('date_min')
date_max = request.GET.get('date_max')
key = request.GET.get('key')
if date_min != '':
# str转datetime
date_min = datetime.datetime.strptime(date_min, '%Y-%m-%d')
if date_max != '':
date_max = datetime.datetime.strptime(
date_max, '%Y-%m-%d') + datetime.timedelta(hours=24)
if type == '' and date_min == '' and date_max == '':
comment_list = Comment.objects.filter(
Q(user__user_name__contains=key) | Q(content__contains=key))
elif type != '' and date_min == '' and date_max == '':
if type == '1':
comment_list = Comment.objects.filter(
Q(user__user_name__contains=key)
| Q(content__contains=key), Q(to_comment_id__isnull=True))
if type == '2':
comment_list = Comment.objects.filter(
Q(user__user_name__contains=key)
| Q(content__contains=key), Q(to_comment_id__isnull=False))
elif type == '' and date_min != '' and date_max != '':
comment_list = Comment.objects.filter(
Q(user__user_name__contains=key) | Q(content__contains=key),
Q(gmt_created__gte=date_min) & Q(gmt_created__lte=date_max))
elif type == '' and date_min != '' and date_max == '':
comment_list = Comment.objects.filter(
Q(user__user_name__contains=key) | Q(content__contains=key),
Q(gmt_created__gte=date_min))
elif type == '' and date_min == '' and date_max != '':
comment_list = Comment.objects.filter(
Q(user__user_name__contains=key) | Q(content__contains=key),
Q(gmt_created__lte=date_max))
elif type != '' and date_min != '' and date_max != '':
if type == '1':
comment_list = Comment.objects.filter(
Q(user__user_name__contains=key)
| Q(content__contains=key), Q(to_comment_id__isnull=True),
Q(gmt_created__gte=date_min)
& Q(gmt_created__lte=date_max))
if type == '2':
comment_list = Comment.objects.filter(
Q(user__user_name__contains=key)
| Q(content__contains=key), Q(to_comment_id__isnull=False),
Q(gmt_created__gte=date_min)
& Q(gmt_created__lte=date_max))
elif type != '' and date_min != '' and date_max == '':
if type == '1':
comment_list = Comment.objects.filter(
Q(user__user_name__contains=key)
| Q(content__contains=key), Q(to_comment_id__isnull=True),
Q(gmt_created__gte=date_min))
if type == '2':
comment_list = Comment.objects.filter(
Q(user__user_name__contains=key)
| Q(content__contains=key), Q(to_comment_id__isnull=False),
Q(gmt_created__gte=date_min))
elif type != '' and date_min == '' and date_max != '':
if type == '1':
comment_list = Comment.objects.filter(
Q(user__user_name__contains=key)
| Q(content__contains=key), Q(to_comment_id__isnull=True),
Q(gmt_created__lte=date_max))
if type == '2':
comment_list = Comment.objects.filter(
Q(user__user_name__contains=key)
| Q(content__contains=key), Q(to_comment_id__isnull=False),
Q(gmt_created__lte=date_max))
comment_list = comment_list.order_by('-gmt_created')
page = FrontPagination()
page_data = page.paginate_queryset(queryset=comment_list,
request=request,
view=self)
comment_ser = CommentSerializers(instance=page_data, many=True)
return get_page_response(page, comment_ser.data)