def edit_exportformat(request, format_id):
export_format = get_object_or_404(ExportFormat, id=format_id)
if request.method == 'POST' and \
'manage_export_formats' in export_format.team.get_perms(request.user):
form = ExportFormatEditForm(request.POST, instance=export_format)
if form.is_valid():
if not export_format.name == form.cleaned_data.get('name') and \
ExportFormat.objects.filter(
name=form.cleaned_data.get('name')).exists():
form.add_error(
'name',
_('The name is already in use by an export format.'))
messages.error(
request,
_('The name is already in use by an export format.'))
else:
with transaction.atomic():
edited_export_format = form.save(commit=False)
edited_export_format.annotations_types.clear()
for annotation_type in form.cleaned_data[
'annotations_types']:
edited_export_format.annotations_types.add(
annotation_type)
edited_export_format.save()
messages.success(
request, _('The export format was edited successfully.'))
else:
messages.error(request,
_('There was an error editing the export format'))
return redirect(reverse('users:team', args=(export_format.team.id, )))
def view_team(request, team_id):
team = get_object_or_404(Team, id=team_id)
members = team.members.all().annotate(points=Subquery(
Verification.objects.filter(
verified=True,
annotation__user_id=OuterRef('pk'))
.values('annotation__user_id')
.annotate(count=Count('annotation__user_id'))
.values('count'), output_field=IntegerField())).all()\
.order_by(F('points').desc(nulls_last=True)).distinct()
members_30 = team.members.all().annotate(points=Subquery(
Verification.objects.filter(
verified=True,
annotation__user_id=OuterRef('pk'),
annotation__time__gte=timezone.now() - datetime.timedelta(days=30))
.values('annotation__user_id')
.annotate(count=Count('annotation__user_id'))
.values('count'), output_field=IntegerField())).filter(points__gt=0)\
.order_by(F('points').desc(nulls_last=True)).distinct()
is_member = request.user in members
admins = team.admins
imagesets = ImageSet.objects.filter(team=team).order_by('-public', 'name')
if is_member:
export_formats = ExportFormat.objects.filter(team=team).order_by('name')
else:
export_formats = ExportFormat.objects.filter(team=team, public=True).order_by('name')
export_format_forms = [ExportFormatEditForm(instance=format_instance) for format_instance in export_formats]
if not is_member:
imagesets = imagesets.filter(public=True)
return render(request, 'users/view_team.html', {
'team': team,
'members': members,
'members_30': members_30,
'admins': admins,
'imagesets': imagesets,
'date_imagesets': imagesets.order_by('-time'),
'size_imagesets': sorted(imagesets, key=lambda i: -i.image_count()),
'test_imagesets': imagesets.filter(name__icontains='test'),
'imageset_creation_form': ImageSetCreationForm(),
'team_perms': team.get_perms(request.user),
'export_formats_forms': export_format_forms,
})
def view_team(request, team_id):
team = get_object_or_404(Team, id=team_id)
members = team.members.all().order_by('-points')
members_30 = User.objects.raw(
'''
SELECT
u.id, u.password, u.last_login, u.is_superuser, u.username, u.first_name,
u.last_name, u.email, u.is_staff, u.is_active, u.date_joined, u.points,
COUNT(v.id) points_30
FROM
users_user u,
users_teammembership utm,
annotations_annotation AS a,
annotations_verification AS v
WHERE
utm.team_id = %s AND
u.id = utm.user_id AND
a.id = v.annotation_id AND
a.user_id = u.id AND
v.time >= NOW() - '30 days'::interval
GROUP BY
u.id, u.password, u.last_login, u.is_superuser, u.username, u.first_name,
u.last_name, u.email, u.is_staff, u.is_active, u.date_joined, u.points
ORDER BY
points_30
DESC
''', (team.pk, ))
is_member = request.user in members
admins = team.admins
imagesets = ImageSet.objects.filter(team=team).annotate(
image_count_agg=Count('images')).order_by('-public', 'name')
export_formats = ExportFormat.objects.filter(
team=team).prefetch_related('annotations_types').order_by('name')
if not is_member:
export_formats = export_formats.filter(public=True)
imagesets = imagesets.filter(public=True)
export_format_forms = (ExportFormatEditForm(instance=format_instance)
for format_instance in export_formats)
test_imagesets = ImageSet.objects.filter(set_tags__name='test').order_by(
'-public', 'name')
return render(
request, 'users/view_team.html', {
'team':
team,
'members':
members,
'members_30':
members_30,
'admins':
admins,
'imagesets':
imagesets,
'date_imagesets':
sorted(imagesets, key=lambda i: i.time, reverse=True),
'size_imagesets':
sorted(imagesets, key=lambda i: i.image_count, reverse=True),
'test_imagesets':
test_imagesets,
'imageset_creation_form':
ImageSetCreationForm(),
'team_perms':
team.get_perms(request.user),
'export_formats_forms':
export_format_forms,
})