mirror of
https://github.com/macports/macports-webapp.git
synced 2026-07-13 03:18:42 -07:00
47 lines
1.8 KiB
Python
47 lines
1.8 KiB
Python
import datetime
|
|
|
|
from django.shortcuts import render
|
|
from django.db.models import Subquery, Count
|
|
from django.http import HttpResponseRedirect
|
|
from django.views.decorators.cache import cache_page
|
|
|
|
from port.models import Port
|
|
from stats.models import Submission, PortInstallation
|
|
from port.filters import PortFilterByMultiple
|
|
from utilities import old_search_redirect
|
|
|
|
@cache_page(60 * 10)
|
|
def index(request):
|
|
# Support for old "?search=<QUERY>&search_by=<name,description>" links
|
|
# Check if search query is present
|
|
if request.GET.get('search'):
|
|
return HttpResponseRedirect(old_search_redirect(request))
|
|
|
|
ports_count = Port.objects.filter(active=True).count()
|
|
submissions_unique = Submission.objects.filter(timestamp__gte=datetime.datetime.now(tz=datetime.timezone.utc) - datetime.timedelta(days=30)).order_by('user', '-timestamp').distinct('user')
|
|
top_ports = PortInstallation.objects.filter(submission_id__in=Subquery(submissions_unique.values('id')), requested=True).exclude(port__icontains='mpstats').values('port').annotate(num=Count('port')).order_by('-num')[:10]
|
|
recently_added = Port.objects.all().order_by('-created_at').only('name')[:10]
|
|
|
|
return render(request, 'index.html', {
|
|
'top_ports': top_ports,
|
|
'recently_added': recently_added,
|
|
'ports_count': ports_count
|
|
})
|
|
|
|
|
|
# Respond to ajax-call triggered by the search box
|
|
def search(request):
|
|
query = request.GET.get('search_text', '')
|
|
search_by = request.GET.get('search_by', '')
|
|
ports = PortFilterByMultiple(request.GET, queryset=Port.get_active.all()).qs[:50]
|
|
|
|
return render(request, 'filtered_table.html', {
|
|
'ports': ports,
|
|
'query': query,
|
|
'search_by': search_by
|
|
})
|
|
|
|
|
|
def about_page(request):
|
|
return render(request, 'about.html')
|