Improvements on full text search.

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

diff --git a/forum/views/admin.py b/forum/views/admin.py
index bd8a565e105773ce0cd0e18bbbab5146be436b12..543623de31b16217396d1c54ec6c30647acd9ef2 100644 (file)
--- a/forum/views/admin.py
+++ b/forum/views/admin.py
@@ -1,16 +1,17 @@
 from datetime import datetime, timedelta
 from datetime import datetime, timedelta

+import time

 
 from django.shortcuts import render_to_response
 from django.core.urlresolvers import reverse
 from django.http import HttpResponseRedirect, HttpResponse, HttpResponseForbidden, Http404
 from django.template import RequestContext
 from django.utils.translation import ugettext as _
 
 from django.shortcuts import render_to_response
 from django.core.urlresolvers import reverse
 from django.http import HttpResponseRedirect, HttpResponse, HttpResponseForbidden, Http404
 from django.template import RequestContext
 from django.utils.translation import ugettext as _

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

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

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

 
 

-from forum.models import Activity, Question, Answer, User
-from forum import const
+from forum.models import Question, Answer, User, Node, Action

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


@@ -18,20 +19,85 @@ 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:

-            raise Http404
+            return HttpResponseForbidden()

 
     return wrapper
 
 
     return wrapper
 

-@super_user_required
-def index(request):
-    return render_to_response('osqaadmin/index.html', {
-        'sets': get_all_sets(),
-        'settings_pack': settings.SETTINGS_PACK,
+def admin_page(fn):
+    @super_user_required
+    def wrapper(request, *args, **kwargs):
+        res = fn(request, *args, **kwargs)
+        if isinstance(res, tuple):
+            template, context = res
+            context['basetemplate'] = settings.DJSTYLE_ADMIN_INTERFACE and "osqaadmin/djstyle_base.html" or "osqaadmin/base.html"
+            context['allsets'] = Setting.sets
+            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')]
+                    , lambda s1, s2: s1.weight - s2.weight)
+            return render_to_response(template, context, context_instance=RequestContext(request))
+        else:
+            return res
+
+    return wrapper
+
+@admin_page
+def dashboard(request):
+    return ('osqaadmin/dashboard.html', {
+        'settings_pack': unicode(settings.SETTINGS_PACK),

         'statistics': get_statistics(),
         'recent_activity': get_recent_activity(),
         'statistics': get_statistics(),
         'recent_activity': get_recent_activity(),

-    }, context_instance=RequestContext(request))
+        'flagged_posts': get_flagged_posts(),
+    })
+
+@super_user_required
+def interface_switch(request):
+    if request.GET and request.GET.get('to', None) and request.GET['to'] in ('default', 'djstyle'):
+        settings.DJSTYLE_ADMIN_INTERFACE.set_value(request.GET['to'] == 'djstyle')
+
+    return HttpResponseRedirect(reverse('admin_index'))
+
+@admin_page
+def statistics(request):
+    today = datetime.now()
+    last_month = today - timedelta(days=30)

 
 

-@super_user_required    
+    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_n_questions = Question.objects.filter(deleted=None, added_at__lt=last_month).count()
+    qgraph_data = simplejson.dumps([
+            (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
+                                                  ).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([
+            (time.mktime(d.timetuple()) * 1000, i + last_month_n_users)
+            for i, d in enumerate(last_month_users)
+    ])
+
+    return 'osqaadmin/statistics.html', {
+        'graphs': [
+            {
+                '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):
     set = Setting.sets.get(set_name, None)
 
 def settings_set(request, set_name):
     set = Setting.sets.get(set_name, None)
 


@@ -47,34 +113,49 @@ def settings_set(request, 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]))

     else:
         form = SettingsSetForm(set)
 
     else:
         form = SettingsSetForm(set)
 

-    return render_to_response('osqaadmin/set.html', {
+    return 'osqaadmin/set.html', {

         'form': form,
         'form': form,

-        'sets': get_all_sets(),
-    }, context_instance=RequestContext(request))
+        'markdown': set.markdown,
+    }
+
+@super_user_required
+def get_default(request, set_name, var_name):
+    set = Setting.sets.get(set_name, None)
+    if set is None: raise Http404
+
+    setting = dict([(s.name, s) for s in set]).get(var_name, None)
+    if setting is None: raise Http404
+
+    setting.to_default()
+
+    if request.is_ajax():
+        return HttpResponse(setting.default)
+    else:
+        return HttpResponseRedirect(reverse('admin_set', kwargs={'set_name': set_name}))

 
 

-def get_all_sets():
-    return sorted(Setting.sets.values(), lambda s1, s2: s1.weight - s2.weight)

 
 def get_recent_activity():
 
 def get_recent_activity():

-    return Activity.objects.filter(activity_type__in=(
-            const.TYPE_ACTIVITY_ASK_QUESTION, const.TYPE_ACTIVITY_ANSWER,
-            const.TYPE_ACTIVITY_COMMENT_QUESTION, const.TYPE_ACTIVITY_COMMENT_ANSWER,
-            const.TYPE_ACTIVITY_MARK_ANSWER)).order_by('-active_at')[0:10]
+    return Action.objects.order_by('-action_date')[0:30]
+
+def get_flagged_posts():
+    return Action.objects.filter(action_type="flag").order_by('-action_date')[0:30]

 
 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(),
 
 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=False).count(),
-        'questions_last_24': Question.objects.filter(deleted=False, added_at__gt=(datetime.now() - timedelta(days=1))).count(),
-        'total_answers': Answer.objects.filter(deleted=False).count(),
-        'answers_last_24': Answer.objects.filter(deleted=False, added_at__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(),

     }
 
     }
 

-@super_user_required      
+@super_user_required

 def go_bootstrap(request):
     #todo: this is the quick and dirty way of implementing a bootstrap mode
     try:
 def go_bootstrap(request):
     #todo: this is the quick and dirty way of implementing a bootstrap mode
     try:


@@ -122,15 +203,10 @@ def go_bootstrap(request):
     settings.INITIAL_REP.set_value(1)
     settings.MAX_REP_BY_UPVOTE_DAY.set_value(300)
     settings.REP_GAIN_BY_UPVOTED.set_value(15)
     settings.INITIAL_REP.set_value(1)
     settings.MAX_REP_BY_UPVOTE_DAY.set_value(300)
     settings.REP_GAIN_BY_UPVOTED.set_value(15)

-    settings.REP_LOST_BY_UPVOTE_CANCELED.set_value(15)

     settings.REP_LOST_BY_DOWNVOTED.set_value(1)
     settings.REP_LOST_BY_DOWNVOTING.set_value(0)
     settings.REP_LOST_BY_DOWNVOTED.set_value(1)
     settings.REP_LOST_BY_DOWNVOTING.set_value(0)

-    settings.REP_GAIN_BY_DOWNVOTE_CANCELED.set_value(1)
-    settings.REP_GAIN_BY_CANCELING_DOWNVOTE.set_value(0)

     settings.REP_GAIN_BY_ACCEPTED.set_value(25)
     settings.REP_GAIN_BY_ACCEPTED.set_value(25)

-    settings.REP_LOST_BY_ACCEPTED_CANCELED.set_value(25)

     settings.REP_GAIN_BY_ACCEPTING.set_value(5)
     settings.REP_GAIN_BY_ACCEPTING.set_value(5)

-    settings.REP_LOST_BY_CANCELING_ACCEPTED.set_value(5)

     settings.REP_LOST_BY_FLAGGED.set_value(2)
     settings.REP_LOST_BY_FLAGGED_3_TIMES.set_value(30)
     settings.REP_LOST_BY_FLAGGED_5_TIMES.set_value(100)
     settings.REP_LOST_BY_FLAGGED.set_value(2)
     settings.REP_LOST_BY_FLAGGED_3_TIMES.set_value(30)
     settings.REP_LOST_BY_FLAGGED_5_TIMES.set_value(100)


@@ -154,3 +230,56 @@ def go_defaults(request):
     request.user.message_set.create(message=_('All values reverted to defaults'))
     return HttpResponseRedirect(reverse('admin_index'))
 
     request.user.message_set.create(message=_('All values reverted to defaults'))
     return HttpResponseRedirect(reverse('admin_index'))
 

+
+@super_user_required
+def recalculate_denormalized(request):
+    for n in Node.objects.all():
+        n = n.leaf
+        n.score = n.votes.aggregate(score=Sum('value'))['score']
+        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.save()
+
+    request.user.message_set.create(message=_('All values recalculated'))
+    return HttpResponseRedirect(reverse('admin_index'))
+
+@admin_page
+def maintenance(request):
+    if request.POST:
+        if 'close' in request.POST or 'adjust' in request.POST:
+            form = MaintenanceModeForm(request.POST)
+
+            if form.is_valid():
+                settings.MAINTAINANCE_MODE.set_value({
+                    'allow_ips': form.cleaned_data['ips'],
+                    'message': form.cleaned_data['message']})
+
+                if 'close' in request.POST:
+                    message = _('Maintenance mode enabled')
+                else:
+                    message = _('Settings adjusted')
+
+                request.user.message_set.create(message=message)
+
+                return HttpResponseRedirect(reverse('admin_maintenance'))
+        elif 'open' in request.POST:
+            settings.MAINTAINANCE_MODE.set_value(None)
+            request.user.message_set.create(message=_("Your site is now running normally"))
+            return HttpResponseRedirect(reverse('admin_maintenance'))
+    else:
+        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})
+
+
+@admin_page
+def flagged_posts(request):
+    return ('osqaadmin/flagged_posts.html', {
+        'flagged_posts': get_flagged_posts(),
+    })
+
+