Example #1
0
 def render(self, context):
     c = get_count(
         """
         select count(*) from msgbox_message
         where rec_user_id=%s and msgbox_message.read='u'
         and type='r'  """, (context['user'].id, ))
     return c
Example #2
0
 def render(self, context):
     c=get_count("""
         select count(*) from msgbox_message
         where rec_user_id=%s and msgbox_message.read='u'
         and type='r'  """,            
         (context['user'].id,))
     return c
Example #3
0
def view_photo(request, id):
    """
    查看图片
    """
    photo = get_object_or_404(Photo, pk=id)
    user = request.user
    if photo.show_type == 'h' and not is_superuser(user):
        raise Http404
    context_map = get_base_context_map(request)
    #TODO 评论翻页
    comments = photo.photocomment_set.all()
    if not is_superuser(user):
        comments = comments.filter(show_type='s')
    user_s_other_photo = photo.user.photo_set.all()
    if not is_superuser(user):
        user_s_other_photo = user_s_other_photo.filter(show_type='s')
    user_s_other_photo = user_s_other_photo.order_by("-create_date")[0:8]
    form = PhotoCommentForm()
    if request.method == 'POST':
        """
        添加评论
        """
        #TODO 登录判断
        if user.is_anonymous():
            return HttpResponseRedirect('/photos/%s/#beginComment' % id)
        form = PhotoCommentForm(request.POST, photo=photo, author=user)
        if form.is_valid():
            form.save()
        return HttpResponseRedirect('/photos/%s/#beginComment' % id)
    else:
        photo.view_count = photo.view_count + 1
        photo.save()
    context_map['form'] = form
    context_map['photo'] = photo
    context_map['user_s_other_photo'] = user_s_other_photo
    context_map['comments'] = comments
    context_map['user'] = user
    #TODO 查看图片是否已经收藏过了
    context_map['has_collection'] = get_count(
        """
    select count(*) from
    userpanel_collectionphoto uc
    where uc.photo_id=%s and uc.user_id=%s
    """, [photo.id, user.id])
    if user == photo.user or is_superuser(user):
        context_map['can_edit'] = True
    return render_to_response('photos/view_photo.html', context_map)
Example #4
0
def view_photo(request, id):
    """
    查看图片
    """
    photo=get_object_or_404(Photo, pk=id)
    user = request.user
    if photo.show_type=='h' and not is_superuser(user):
        raise Http404
    context_map=get_base_context_map(request)
    #TODO 评论翻页
    comments=photo.photocomment_set.all()
    if not is_superuser(user):
        comments=comments.filter(show_type='s')
    user_s_other_photo = photo.user.photo_set.all()
    if not is_superuser(user):
        user_s_other_photo = user_s_other_photo.filter(show_type='s')
    user_s_other_photo = user_s_other_photo.order_by("-create_date")[0:8]
    form = PhotoCommentForm()
    if request.method == 'POST':
        """
        添加评论
        """
        #TODO 登录判断
        if user.is_anonymous():
            return HttpResponseRedirect('/photos/%s/#beginComment' % id)
        form = PhotoCommentForm(request.POST,photo=photo,author=user)
        if form.is_valid():
            form.save()
        return HttpResponseRedirect('/photos/%s/#beginComment' % id)
    else:
        photo.view_count=photo.view_count+1
        photo.save()
    context_map['form']=form
    context_map['photo']=photo
    context_map['user_s_other_photo']=user_s_other_photo
    context_map['comments']=comments
    context_map['user']=user
    #TODO 查看图片是否已经收藏过了
    context_map['has_collection']=get_count("""
    select count(*) from
    userpanel_collectionphoto uc
    where uc.photo_id=%s and uc.user_id=%s
    """, [photo.id, user.id])
    if user==photo.user or is_superuser(user):
        context_map['can_edit']=True
    return render_to_response('photos/view_photo.html', context_map)