OSQA-386

[osqa.git] / forum / views / admin.py

diff --git a/forum/views/admin.py b/forum/views/admin.py
index f154ea18fe1b7fe2d60fa13d086e7b81c9e92841..ad4f9b933c01137372d92360ae8022931691e34a 100644 (file)
--- a/forum/views/admin.py
+++ b/forum/views/admin.py
@@ -1,18 +1,20 @@
 from datetime import datetime, timedelta
 import time
 
 from datetime import datetime, timedelta
 import time
 

-from django.shortcuts import render_to_response
+from django.shortcuts import render_to_response, get_object_or_404

 from django.core.urlresolvers import reverse
 from django.core.urlresolvers import reverse

-from django.http import HttpResponseRedirect, HttpResponse, HttpResponseForbidden, Http404
+from django.http import HttpResponseRedirect, HttpResponse, Http404
+from forum.http_responses import HttpResponseUnauthorized

 from django.template import RequestContext
 from django.utils.translation import ugettext as _
 from django.utils import simplejson
 from django.template import RequestContext
 from django.utils.translation import ugettext as _
 from django.utils import simplejson

-from django.db.models import Sum
-
+from django.db import models

 from forum.settings.base import Setting
 from forum.settings.base import Setting

-from forum.settings.forms import SettingsSetForm, MaintenanceModeForm
+from forum.forms import MaintenanceModeForm, PageForm
+from forum.settings.forms import SettingsSetForm

 
 

-from forum.models import Question, Answer, User, Node, Action
+from forum.models import Question, Answer, User, Node, Action, Page
+from forum.actions import NewPageAction, EditPageAction, PublishAction

 from forum import settings
 
 def super_user_required(fn):
 from forum import settings
 
 def super_user_required(fn):


@@ -20,7 +22,7 @@ def super_user_required(fn):
         if request.user.is_authenticated() and request.user.is_superuser:
             return fn(request, *args, **kwargs)
         else:
         if request.user.is_authenticated() and request.user.is_superuser:
             return fn(request, *args, **kwargs)
         else:

-            return HttpResponseForbidden()
+            return HttpResponseUnauthorized(request)

 
     return wrapper
 
 
     return wrapper
 


@@ -35,8 +37,12 @@ def admin_page(fn):
             context['othersets'] = sorted(
                     [s for s in Setting.sets.values() if not s.name in
                     ('basic', 'users', 'email', 'paths', 'extkeys', 'repgain', 'minrep', 'voting', 'badges', 'about', 'faq', 'sidebar',
             context['othersets'] = sorted(
                     [s for s in Setting.sets.values() if not s.name in
                     ('basic', 'users', 'email', 'paths', 'extkeys', 'repgain', 'minrep', 'voting', 'badges', 'about', 'faq', 'sidebar',

-                    'form', 'moderation')]
+                    'form', 'moderation', 'css', 'headandfoot', 'head', 'view')]

                     , lambda s1, s2: s1.weight - s2.weight)
                     , lambda s1, s2: s1.weight - s2.weight)

+
+            unsaved = request.session.get('previewing_settings', {})
+            context['unsaved'] = set([getattr(settings, s).set.name for s in unsaved.keys() if hasattr(settings, s)])
+

             return render_to_response(template, context, context_instance=RequestContext(request))
         else:
             return res
             return render_to_response(template, context, context_instance=RequestContext(request))
         else:
             return res


@@ -46,9 +52,10 @@ def admin_page(fn):
 @admin_page
 def dashboard(request):
     return ('osqaadmin/dashboard.html', {
 @admin_page
 def dashboard(request):
     return ('osqaadmin/dashboard.html', {

-        'settings_pack': unicode(settings.SETTINGS_PACK),
-        'statistics': get_statistics(),
-        'recent_activity': get_recent_activity(),
+    'settings_pack': unicode(settings.SETTINGS_PACK),
+    'statistics': get_statistics(),
+    'recent_activity': get_recent_activity(),
+    'flagged_posts': get_flagged_posts(),

     })
 
 @super_user_required
     })
 
 @super_user_required


@@ -63,43 +70,45 @@ def statistics(request):
     today = datetime.now()
     last_month = today - timedelta(days=30)
 
     today = datetime.now()
     last_month = today - timedelta(days=30)
 

-    last_month_questions = Question.objects.filter(deleted=None, added_at__gt=last_month
-                                                  ).order_by('added_at').values_list('added_at', flat=True)
+    last_month_questions = Question.objects.filter_state(deleted=False).filter(added_at__gt=last_month
+                                                                               ).order_by('added_at').values_list(
+            'added_at', flat=True)

 
 

-    last_month_n_questions = Question.objects.filter(deleted=None, added_at__lt=last_month).count()
+    last_month_n_questions = Question.objects.filter_state(deleted=False).filter(added_at__lt=last_month).count()

     qgraph_data = simplejson.dumps([
     qgraph_data = simplejson.dumps([

-            (time.mktime(d.timetuple()) * 1000, i + last_month_n_questions)
-            for i, d in enumerate(last_month_questions)
+    (time.mktime(d.timetuple()) * 1000, i + last_month_n_questions)
+    for i, d in enumerate(last_month_questions)

     ])
 
     last_month_users = User.objects.filter(date_joined__gt=last_month
     ])
 
     last_month_users = User.objects.filter(date_joined__gt=last_month

-                                                  ).order_by('date_joined').values_list('date_joined', flat=True)
+                                           ).order_by('date_joined').values_list('date_joined', flat=True)

 
     last_month_n_users = User.objects.filter(date_joined__lt=last_month).count()
 
     ugraph_data = simplejson.dumps([
 
     last_month_n_users = User.objects.filter(date_joined__lt=last_month).count()
 
     ugraph_data = simplejson.dumps([

-            (time.mktime(d.timetuple()) * 1000, i + last_month_n_users)
-            for i, d in enumerate(last_month_users)
+    (time.mktime(d.timetuple()) * 1000, i + last_month_n_users)
+    for i, d in enumerate(last_month_users)

     ])
 
     return 'osqaadmin/statistics.html', {
     ])
 
     return 'osqaadmin/statistics.html', {

-        'graphs': [
+    'graphs': [

             {
             {

-                'id': 'questions_graph',
-                'caption': _("Questions Graph"),
-                'data': qgraph_data
-            },{
-                'id': 'userss_graph',
-                'caption': _("Users Graph"),
-                'data': ugraph_data
+            'id': 'questions_graph',
+            'caption': _("Questions Graph"),
+            'data': qgraph_data
+            }, {
+            'id': 'userss_graph',
+            'caption': _("Users Graph"),
+            'data': ugraph_data

             }
             }

-        ]
+            ]

     }
 
 
 @admin_page
 def settings_set(request, set_name):
     }
 
 
 @admin_page
 def settings_set(request, set_name):

-    set = Setting.sets.get(set_name, None)
+    set = Setting.sets.get(set_name, {})
+    current_preview = request.session.get('previewing_settings', {})

 
     if set is None:
         raise Http404
 
     if set is None:
         raise Http404


@@ -108,19 +117,31 @@ def settings_set(request, set_name):
         form = SettingsSetForm(set, data=request.POST, files=request.FILES)
 
         if form.is_valid():
         form = SettingsSetForm(set, data=request.POST, files=request.FILES)
 
         if form.is_valid():

-            form.save()
-            request.user.message_set.create(message=_("'%s' settings saved succesfully") % set_name)
+            if 'preview' in request.POST:
+                current_preview.update(form.cleaned_data)
+                request.session['previewing_settings'] = current_preview
+
+                return HttpResponseRedirect(reverse('index'))
+            else:
+                for s in set:
+                    current_preview.pop(s.name, None)
+
+                request.session['previewing_settings'] = current_preview
+
+                if not 'reset' in request.POST:
+                    form.save()
+                    request.user.message_set.create(message=_("'%s' settings saved succesfully") % set_name)

 
 

-            if set_name in ('minrep', 'badges', 'repgain'):
-                settings.SETTINGS_PACK.set_value("custom")
+                    if set_name in ('minrep', 'badges', 'repgain'):
+                        settings.SETTINGS_PACK.set_value("custom")

 
 

-            return HttpResponseRedirect(reverse('admin_set', args=[set_name]))
+                return HttpResponseRedirect(reverse('admin_set', args=[set_name]))

     else:
     else:

-        form = SettingsSetForm(set)
+        form = SettingsSetForm(set, unsaved=current_preview)

 
     return 'osqaadmin/set.html', {
 
     return 'osqaadmin/set.html', {

-        'form': form,
-        'markdown': set.markdown,
+    'form': form,
+    'markdown': set.markdown,

     }
 
 @super_user_required
     }
 
 @super_user_required


@@ -142,19 +163,24 @@ def get_default(request, set_name, var_name):
 def get_recent_activity():
     return Action.objects.order_by('-action_date')[0:30]
 
 def get_recent_activity():
     return Action.objects.order_by('-action_date')[0:30]
 

+def get_flagged_posts():
+    return Action.objects.filter(canceled=False, action_type="flag").order_by('-action_date')[0:30]
+

 def get_statistics():
     return {
 def get_statistics():
     return {

-        'total_users': User.objects.all().count(),
-        'users_last_24': User.objects.filter(date_joined__gt=(datetime.now() - timedelta(days=1))).count(),
-        'total_questions': Question.objects.filter(deleted=None).count(),
-        'questions_last_24': Question.objects.filter(deleted=None, added_at__gt=(datetime.now() - timedelta(days=1))).count(),
-        'total_answers': Answer.objects.filter(deleted=None).count(),
-        'answers_last_24': Answer.objects.filter(deleted=None, added_at__gt=(datetime.now() - timedelta(days=1))).count(),
+    'total_users': User.objects.all().count(),
+    'users_last_24': User.objects.filter(date_joined__gt=(datetime.now() - timedelta(days=1))).count(),
+    'total_questions': Question.objects.filter_state(deleted=False).count(),
+    'questions_last_24': Question.objects.filter_state(deleted=False).filter(
+            added_at__gt=(datetime.now() - timedelta(days=1))).count(),
+    'total_answers': Answer.objects.filter_state(deleted=False).count(),
+    'answers_last_24': Answer.objects.filter_state(deleted=False).filter(
+            added_at__gt=(datetime.now() - timedelta(days=1))).count(),

     }
 
 @super_user_required
 def go_bootstrap(request):
     }
 
 @super_user_required
 def go_bootstrap(request):

-    #todo: this is the quick and dirty way of implementing a bootstrap mode
+#todo: this is the quick and dirty way of implementing a bootstrap mode

     try:
         from forum_modules.default_badges import settings as dbsets
         dbsets.POPULAR_QUESTION_VIEWS.set_value(100)
     try:
         from forum_modules.default_badges import settings as dbsets
         dbsets.POPULAR_QUESTION_VIEWS.set_value(100)


@@ -188,6 +214,7 @@ def go_bootstrap(request):
     settings.REP_TO_COMMENT.set_value(0)
     settings.REP_TO_LIKE_COMMENT.set_value(0)
     settings.REP_TO_UPLOAD.set_value(0)
     settings.REP_TO_COMMENT.set_value(0)
     settings.REP_TO_LIKE_COMMENT.set_value(0)
     settings.REP_TO_UPLOAD.set_value(0)

+    settings.REP_TO_CREATE_TAGS.set_value(0)

     settings.REP_TO_CLOSE_OWN.set_value(60)
     settings.REP_TO_REOPEN_OWN.set_value(120)
     settings.REP_TO_RETAG.set_value(150)
     settings.REP_TO_CLOSE_OWN.set_value(60)
     settings.REP_TO_REOPEN_OWN.set_value(120)
     settings.REP_TO_RETAG.set_value(150)


@@ -232,12 +259,12 @@ def go_defaults(request):
 def recalculate_denormalized(request):
     for n in Node.objects.all():
         n = n.leaf
 def recalculate_denormalized(request):
     for n in Node.objects.all():
         n = n.leaf

-        n.score = n.votes.aggregate(score=Sum('value'))['score']
+        n.score = n.votes.aggregate(score=models.Sum('value'))['score']

         if not n.score: n.score = 0
         n.save()
 
     for u in User.objects.all():
         if not n.score: n.score = 0
         n.save()
 
     for u in User.objects.all():

-        u.reputation = u.reputes.aggregate(reputation=Sum('value'))['reputation']
+        u.reputation = u.reputes.aggregate(reputation=models.Sum('value'))['reputation']

         u.save()
 
     request.user.message_set.create(message=_('All values recalculated'))
         u.save()
 
     request.user.message_set.create(message=_('All values recalculated'))


@@ -251,8 +278,8 @@ def maintenance(request):
 
             if form.is_valid():
                 settings.MAINTAINANCE_MODE.set_value({
 
             if form.is_valid():
                 settings.MAINTAINANCE_MODE.set_value({

-                    'allow_ips': form.cleaned_data['ips'],
-                    'message': form.cleaned_data['message']})
+                'allow_ips': form.cleaned_data['ips'],
+                'message': form.cleaned_data['message']})

 
                 if 'close' in request.POST:
                     message = _('Maintenance mode enabled')
 
                 if 'close' in request.POST:
                     message = _('Maintenance mode enabled')


@@ -270,6 +297,136 @@ def maintenance(request):
         form = MaintenanceModeForm(initial={'ips': request.META['REMOTE_ADDR'],
                                             'message': _('Currently down for maintenance. We\'ll be back soon')})
 
         form = MaintenanceModeForm(initial={'ips': request.META['REMOTE_ADDR'],
                                             'message': _('Currently down for maintenance. We\'ll be back soon')})
 

-    return ('osqaadmin/maintenance.html', {'form': form, 'in_maintenance': settings.MAINTAINANCE_MODE.value is not None})
+    return ('osqaadmin/maintenance.html', {'form': form, 'in_maintenance': settings.MAINTAINANCE_MODE.value is not None
+                                           })
+
+
+@admin_page
+def flagged_posts(request):
+    return ('osqaadmin/flagged_posts.html', {
+    'flagged_posts': get_flagged_posts(),
+    })
+
+@admin_page
+def static_pages(request):
+    pages = Page.objects.all()
+
+    return ('osqaadmin/static_pages.html', {
+    'pages': pages,
+    })
+
+@admin_page
+def edit_page(request, id=None):
+    if id:
+        page = get_object_or_404(Page, id=id)
+    else:
+        page = None
+
+    if request.POST:
+        form = PageForm(page, request.POST)
+
+        if form.is_valid():
+            if form.has_changed():
+                if not page:
+                    page = NewPageAction(user=request.user, ip=request.META['REMOTE_ADDR']).save(data=form.cleaned_data
+                                                                                                 ).node
+                else:
+                    EditPageAction(user=request.user, node=page, ip=request.META['REMOTE_ADDR']).save(
+                            data=form.cleaned_data)
+
+            if ('publish' in request.POST) and (not page.published):
+                PublishAction(user=request.user, node=page, ip=request.META['REMOTE_ADDR']).save()
+            elif ('unpublish' in request.POST) and page.published:
+                page.nstate.published.cancel(ip=request.META['REMOTE_ADDR'])
+
+            return HttpResponseRedirect(reverse('admin_edit_page', kwargs={'id': page.id}))
+
+    else:
+        form = PageForm(page)
+
+    if page:
+        published = page.published
+    else:
+        published = False
+
+    return ('osqaadmin/edit_page.html', {
+    'page': page,
+    'form': form,
+    'published': published
+    })
+
+@admin_page
+def moderation(request):
+    if request.POST:
+        if not 'ids' in request.POST:
+            verify = None
+        else:
+            sort = {
+            'high-rep': '-reputation',
+            'newer': '-date_joined',
+            'older': 'date_joined',
+            }.get(request.POST.get('sort'), None)
+
+            if sort:
+                try:
+                    limit = int(request.POST['limit'])
+                except:
+                    limit = 5
+
+                verify = User.objects.order_by(sort)[:limit]
+            else:
+                verify = None
+
+        if verify:
+            possible_cheaters = []
+            verify = User.objects.order_by(sort)[:5]
+
+            cheat_score_sort = lambda c1, c2: cmp(c2.fdata['fake_score'], c1.fdata['fake_score'])
+
+            for user in verify:
+                possible_fakes = []
+                affecters = User.objects.filter(actions__node__author=user, actions__canceled=False).annotate(
+                        affect_count=models.Count('actions')).order_by('-affect_count')
+                user_ips = set(Action.objects.filter(user=user).values_list('ip', flat=True).distinct('ip'))
+
+                for affecter in affecters:
+                    if affecter == user:
+                        continue
+
+                    data = {'affect_count': affecter.affect_count}
+
+                    total_actions = affecter.actions.filter(canceled=False).exclude(node=None).count()
+                    ratio = (float(affecter.affect_count) / float(total_actions)) * 100
+
+                    if total_actions > 10 and ratio > 50:
+                        data['total_actions'] = total_actions
+                        data['action_ratio'] = ratio
+
+                        affecter_ips = set(
+                                Action.objects.filter(user=affecter).values_list('ip', flat=True).distinct('ip'))
+                        cross_ips = len(user_ips & affecter_ips)
+
+                        data['cross_ip_count'] = cross_ips
+                        data['total_ip_count'] = len(affecter_ips)
+                        data['cross_ip_ratio'] = (float(data['cross_ip_count']) / float(data['total_ip_count'])) * 100
+
+                        if affecter.email_isvalid:
+                            email_score = 0
+                        else:
+                            email_score = 50.0
+
+                        data['fake_score'] = ((data['cross_ip_ratio'] + data['action_ratio'] + email_score) / 100) * 4
+
+                        affecter.fdata = data
+                        possible_fakes.append(affecter)
+
+                if len(possible_fakes) > 0:
+                    possible_fakes = sorted(possible_fakes, cheat_score_sort)
+                    possible_cheaters.append((user, possible_fakes))
+
+            return ('osqaadmin/moderation.html', {'cheaters': possible_cheaters})
+
+    return ('osqaadmin/moderation.html', {})
+