]> git.openstreetmap.org Git - osqa.git/blobdiff - forum/views/admin.py
Adds the hability to hard delete nodes in the bulk manager, and renames the tool.
[osqa.git] / forum / views / admin.py
index 7297c1f9fb8649fb8d9cf94e2d35cd530dd398db..0fa533366c13d83d3c5157bd73d6015558170a68 100644 (file)
@@ -1,5 +1,5 @@
 from datetime import datetime, timedelta
 from datetime import datetime, timedelta
-import time
+import os, time, csv, random
 
 from django.shortcuts import render_to_response, get_object_or_404
 from django.core.urlresolvers import reverse
 
 from django.shortcuts import render_to_response, get_object_or_404
 from django.core.urlresolvers import reverse
@@ -10,13 +10,17 @@ from django.utils.translation import ugettext as _
 from django.utils import simplejson
 from django.db import models
 from forum.settings.base import Setting
 from django.utils import simplejson
 from django.db import models
 from forum.settings.base import Setting
-from forum.forms import MaintenanceModeForm, PageForm
+from forum.forms import MaintenanceModeForm, PageForm, NodeManFilterForm, CreateUserForm
 from forum.settings.forms import SettingsSetForm
 from forum.settings.forms import SettingsSetForm
+from forum.utils import pagination, html
 
 
-from forum.models import Question, Answer, User, Node, Action, Page
-from forum.actions import NewPageAction, EditPageAction, PublishAction
+from forum.models import Question, Answer, User, Node, Action, Page, NodeState, Tag
+from forum.models.node import NodeMetaClass
+from forum.actions import NewPageAction, EditPageAction, PublishAction, DeleteAction, UserJoinsAction, CloseAction
 from forum import settings
 
 from forum import settings
 
+TOOLS = {}
+
 def super_user_required(fn):
     def wrapper(request, *args, **kwargs):
         if request.user.is_authenticated() and request.user.is_superuser:
 def super_user_required(fn):
     def wrapper(request, *args, **kwargs):
         if request.user.is_authenticated() and request.user.is_superuser:
@@ -30,33 +34,48 @@ def admin_page(fn):
     @super_user_required
     def wrapper(request, *args, **kwargs):
         res = fn(request, *args, **kwargs)
     @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:
+        if isinstance(res, HttpResponse):
             return res
 
             return res
 
+        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', 'accept', 'badges', 'about', 'faq', 'sidebar',
+                'form', 'moderation', 'css', 'headandfoot', 'head', 'view', 'urls')]
+                , lambda s1, s2: s1.weight - s2.weight)
+
+        context['tools'] = TOOLS
+
+        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))
+
     return wrapper
 
     return wrapper
 
+def admin_tools_page(name, label):    
+    def decorator(fn):
+        fn = admin_page(fn)
+        fn.label = label
+        TOOLS[name] = fn
+
+        return fn
+    return decorator
+
+class ActivityPaginatorContext(pagination.PaginatorContext):
+    def __init__(self):
+        super (ActivityPaginatorContext, self).__init__('ADMIN_RECENT_ACTIVITY', pagesizes=(20, 40, 80), default_pagesize=40)
+
 @admin_page
 def dashboard(request):
 @admin_page
 def dashboard(request):
-    return ('osqaadmin/dashboard.html', {
+    return ('osqaadmin/dashboard.html', pagination.paginated(request, ("recent_activity", ActivityPaginatorContext()), {
     'settings_pack': unicode(settings.SETTINGS_PACK),
     'statistics': get_statistics(),
     'recent_activity': get_recent_activity(),
     'flagged_posts': get_flagged_posts(),
     'settings_pack': unicode(settings.SETTINGS_PACK),
     'statistics': get_statistics(),
     'recent_activity': get_recent_activity(),
     'flagged_posts': get_flagged_posts(),
-    })
+    }))
 
 @super_user_required
 def interface_switch(request):
 
 @super_user_required
 def interface_switch(request):
@@ -104,6 +123,13 @@ def statistics(request):
             ]
     }
 
             ]
     }
 
+@admin_page
+def tools_page(request, name):
+    if not name in TOOLS:
+        raise Http404
+
+    return TOOLS[name](request)
+
 
 @admin_page
 def settings_set(request, set_name):
 
 @admin_page
 def settings_set(request, set_name):
@@ -161,7 +187,7 @@ def get_default(request, set_name, var_name):
 
 
 def get_recent_activity():
 
 
 def get_recent_activity():
-    return Action.objects.order_by('-action_date')[0:30]
+    return Action.objects.order_by('-action_date')
 
 def get_flagged_posts():
     return Action.objects.filter(canceled=False, action_type="flag").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]
@@ -355,78 +381,150 @@ def edit_page(request, id=None):
     'published': published
     })
 
     'published': published
     })
 
-@admin_page
-def moderation(request):
+@admin_tools_page(_('createuser'), _("Create new user"))
+def create_user(request):
     if request.POST:
     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
+        form = CreateUserForm(request.POST)
 
 
-        if verify:
-            possible_cheaters = []
-            verify = User.objects.order_by(sort)[:5]
+        if form.is_valid():
+            user_ = User(username=form.cleaned_data['username'], email=form.cleaned_data['email'])
+            user_.set_password(form.cleaned_data['password1'])
+
+            if not form.cleaned_data.get('validate_email', False):
+                user_.email_isvalid = True
 
 
-            cheat_score_sort = lambda c1, c2: cmp(c2.fdata['fake_score'], c1.fdata['fake_score'])
+            user_.save()
+            UserJoinsAction(user=user_).save()
 
 
-            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'))
+            request.user.message_set.create(message=_("New user created sucessfully. %s.") % html.hyperlink(
+                    user_.get_profile_url(), _("See %s profile") % user_.username, target="_blank"))
 
 
-                for affecter in affecters:
-                    if affecter == user:
-                        continue
+            return HttpResponseRedirect(reverse("admin_tools", kwargs={'name': 'createuser'}))
+    else:
+        form = CreateUserForm()
+
+    return ('osqaadmin/createuser.html', {
+        'form': form,
+    })
 
 
-                    data = {'affect_count': affecter.affect_count}
+class NodeManagementPaginatorContext(pagination.PaginatorContext):
+    def __init__(self, id='QUESTIONS_LIST', prefix='', default_pagesize=100):
+        super (NodeManagementPaginatorContext, self).__init__(id, sort_methods=(
+            (_('added_at'), pagination.SimpleSort(_('added_at'), '-added_at', "")),
+            (_('added_at_asc'), pagination.SimpleSort(_('added_at_asc'), 'added_at', "")),
+            (_('score'), pagination.SimpleSort(_('score'), '-score', "")),
+            (_('score_asc'), pagination.SimpleSort(_('score_asc'), 'score', "")),
+            (_('act_at'), pagination.SimpleSort(_('act_at'), '-last_activity_at', "")),
+            (_('act_at_asc'), pagination.SimpleSort(_('act_at_asc'), 'last_activity_at', "")),
+        ), pagesizes=(default_pagesize,), force_sort='added_at', default_pagesize=default_pagesize, prefix=prefix)
 
 
-                    total_actions = affecter.actions.filter(canceled=False).exclude(node=None).count()
-                    ratio = (float(affecter.affect_count) / float(total_actions)) * 100
+@admin_tools_page(_("nodeman"), _("Bulk management"))
+def node_management(request):
+    if request.POST and "save_filter" in request.POST:
+        filter_name = request.POST.get('filter_name', _('filter'))
+        params = pagination.generate_uri(request.GET, ('page',))
+        current_filters = settings.NODE_MAN_FILTERS.value
+        current_filters.append((filter_name, params))
+        settings.NODE_MAN_FILTERS.set_value(current_filters)
 
 
-                    if total_actions > 10 and ratio > 50:
-                        data['total_actions'] = total_actions
-                        data['action_ratio'] = ratio
+    if request.POST and "execute" in request.POST:
+        selected_nodes = request.POST.getlist('_selected_node')
 
 
-                        affecter_ips = set(
-                                Action.objects.filter(user=affecter).values_list('ip', flat=True).distinct('ip'))
-                        cross_ips = len(user_ips & affecter_ips)
+        if selected_nodes and request.POST.get('action', None):
+            action = request.POST['action']
+            selected_nodes = Node.objects.filter(id__in=selected_nodes)
 
 
-                        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
+            message = _("No action performed")
 
 
-                        if affecter.email_isvalid:
-                            email_score = 0
-                        else:
-                            email_score = 50.0
+            if action == 'delete_selected':
+                for node in selected_nodes:
+                    if node.node_type in ('question', 'answer', 'comment') and (not node.nis.deleted):
+                        DeleteAction(user=request.user, node=node, ip=request.META['REMOTE_ADDR']).save()
+                        
+                message = _("All selected nodes marked as deleted")
+
+            if action == "close_selected":
+                for node in selected_nodes:
+                    if node.node_type == "question" and (not node.nis.closed):
+                        CloseAction(node=node.leaf, user=request.user, extra=_("bulk close"), ip=request.META['REMOTE_ADDR']).save()
+
+                message = _("Selected questions were closed")
+
+            if action == "hard_delete_selected":
+                ids = [n.id for n in selected_nodes]
+
+                for id in ids:
+                    try:
+                        node = Node.objects.get(id=id)
+                        node.delete()
+                    except:
+                        pass                        
+
+                message = _("All selected nodes deleted")
+
+            request.user.message_set.create(message=message)
+
+            params = pagination.generate_uri(request.GET, ('page',))
+            return HttpResponseRedirect(reverse("admin_tools", kwargs={'name': 'nodeman'}) + "?" + params)
+
+
+    nodes = Node.objects.all()
+
+    if (request.GET):
+        filter_form = NodeManFilterForm(request.GET)
+    else:
+        filter_form = NodeManFilterForm({'node_type': 'all', 'state_type': 'any'})
+
+    authors = request.GET.getlist('authors')
+    tags = request.GET.getlist('tags')
+
+    if filter_form.is_valid():
+        data = filter_form.cleaned_data
+
+        if data['node_type'] != 'all':
+            nodes = nodes.filter(node_type=data['node_type'])
+
+        if (data['state_type'] != 'any'):
+            nodes = nodes.filter_state(**{str(data['state_type']): True})
+
+        if (authors):
+            nodes = nodes.filter(author__id__in=authors)
+            authors = User.objects.filter(id__in=authors)
+
+        if (tags):
+            nodes = nodes.filter(tags__id__in=tags)
+            tags = Tag.objects.filter(id__in=tags)
+
+        if data['text']:
+            filter = None
+
+            if data['text_in'] == 'title' or data['text_in'] == 'both':
+                filter = models.Q(title__icontains=data['text'])
+
+            if data['text_in'] == 'body' or data['text_in'] == 'both':
+                sec_filter = models.Q(body__icontains=data['text'])
+                if filter:
+                    filter = filter | sec_filter
+                else:
+                    filter = sec_filter
 
 
-                        data['fake_score'] = ((data['cross_ip_ratio'] + data['action_ratio'] + email_score) / 100) * 4
+            if filter:
+                nodes = nodes.filter(filter)
 
 
-                        affecter.fdata = data
-                        possible_fakes.append(affecter)
+    node_types = [('all', _("all"))] + [(k, n.friendly_name) for k, n in NodeMetaClass.types.items()]
+    state_types = NodeState.objects.filter(node__in=nodes).values_list('state_type', flat=True).distinct('state_type')
 
 
-                if len(possible_fakes) > 0:
-                    possible_fakes = sorted(possible_fakes, cheat_score_sort)
-                    possible_cheaters.append((user, possible_fakes))
+    return ('osqaadmin/nodeman.html', pagination.paginated(request, ("nodes", NodeManagementPaginatorContext()), {
+    'nodes': nodes,
+    'node_types': node_types,
+    'state_types': state_types,
+    'filter_form': filter_form,
+    'authors': authors,
+    'tags': tags,
+    'hide_menu': True
+    }))
 
 
-            return ('osqaadmin/moderation.html', {'cheaters': possible_cheaters})
 
 
-    return ('osqaadmin/moderation.html', {})