X-Git-Url: https://git.openstreetmap.org./osqa.git/blobdiff_plain/9b450de133375fb612625b826f1920b672ab2acc..25d2724e64a7828113860d6f7232815a34133ec1:/forum/views/admin.py diff --git a/forum/views/admin.py b/forum/views/admin.py index 7a29922..7297c1f 100644 --- a/forum/views/admin.py +++ b/forum/views/admin.py @@ -1,17 +1,20 @@ 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.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.db.models import Sum - +from django.utils import simplejson +from django.db import models from forum.settings.base import Setting +from forum.forms import MaintenanceModeForm, PageForm from forum.settings.forms import SettingsSetForm -from forum.models import Activity, Question, Answer, User, Node -from forum import const +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): @@ -19,22 +22,93 @@ def super_user_required(fn): if request.user.is_authenticated() and request.user.is_superuser: return fn(request, *args, **kwargs) else: - raise Http404 + return HttpResponseUnauthorized(request) return wrapper +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', 'css', 'headandfoot', 'head')] + , 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 wrapper + +@admin_page +def dashboard(request): + return ('osqaadmin/dashboard.html', { + 'settings_pack': unicode(settings.SETTINGS_PACK), + 'statistics': get_statistics(), + 'recent_activity': get_recent_activity(), + 'flagged_posts': get_flagged_posts(), + }) + @super_user_required -def index(request): - return render_to_response('osqaadmin/index.html', { - 'sets': get_all_sets(), - 'settings_pack': settings.SETTINGS_PACK, - 'statistics': get_statistics(), - 'recent_activity': get_recent_activity(), - }, context_instance=RequestContext(request)) - -@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) + + 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_state(deleted=False).filter(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) + set = Setting.sets.get(set_name, {}) + current_preview = request.session.get('previewing_settings', {}) if set is None: raise Http404 @@ -43,41 +117,70 @@ def settings_set(request, set_name): 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 set_name in ('minrep', 'badges', 'repgain'): - settings.SETTINGS_PACK.set_value("custom") + 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") + + return HttpResponseRedirect(reverse('admin_set', args=[set_name])) else: - form = SettingsSetForm(set) + form = SettingsSetForm(set, unsaved=current_preview) - return render_to_response('osqaadmin/set.html', { - 'form': form, - 'sets': get_all_sets(), - }, context_instance=RequestContext(request)) + return 'osqaadmin/set.html', { + 'form': form, + '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(): - 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(canceled=False, 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(), - '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_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 +@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) @@ -111,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_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) @@ -123,15 +227,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.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_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_LOST_BY_ACCEPTED_CANCELED.set_value(25) 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) @@ -160,14 +259,174 @@ def go_defaults(request): def recalculate_denormalized(request): for n in Node.objects.all(): n = n.leaf - n.vote_up_count = n.votes.filter(canceled=False, vote=1).count() - n.vote_down_count = n.votes.filter(canceled=False, vote=-1).count() + 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(): - u.reputation = u.reputes.filter(canceled=False).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')) 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(), + }) + +@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', {}) + + +