views.py 4.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152
  1. import logging
  2. from django.contrib.auth.mixins import LoginRequiredMixin
  3. from django.db.models import Avg, Count, F
  4. from django.views.generic import DetailView, ListView
  5. from django.views.generic.list import MultipleObjectMixin
  6. from .models import Developer, Game, GameSystem, Genre, Publisher, GameCollection
  7. logger = logging.Logger(__name__)
  8. class RecentGameList(LoginRequiredMixin, ListView):
  9. model = Game
  10. paginate_by = 20
  11. queryset = Game.objects.order_by("-created")[:200]
  12. class LibraryGameList(ListView, LoginRequiredMixin):
  13. template_name = "games/game_library_list.html"
  14. model = Game
  15. paginate_by = 200
  16. def get_context_data(self, **kwargs):
  17. game_system_slug = self.request.GET.get("game_system")
  18. order_by = self.request.GET.get("order_by", "name")
  19. if order_by[0] == "-":
  20. order_by = order_by[1:]
  21. object_list = Game.objects.order_by(F(order_by).desc(nulls_last=True))
  22. else:
  23. object_list = Game.objects.order_by(F(order_by).asc(nulls_last=True))
  24. if game_system_slug:
  25. object_list = object_list.filter(
  26. game_system__retropie_slug=game_system_slug
  27. )
  28. context = super(LibraryGameList, self).get_context_data(
  29. object_list=object_list, **kwargs
  30. )
  31. return context
  32. class FilterableBaseListView(ListView, LoginRequiredMixin):
  33. def get_queryset(self, **kwargs):
  34. order_by = self.request.GET.get("order_by", "name")
  35. queryset = super().get_queryset(**kwargs)
  36. queryset = queryset.annotate(num_games=Count("game")).annotate(
  37. rating=Avg("game__rating")
  38. )
  39. if order_by[0] == "-":
  40. order_by = order_by[1:]
  41. queryset = queryset.order_by(F(order_by).desc(nulls_last=True))
  42. else:
  43. queryset = queryset.order_by(F(order_by).asc(nulls_last=True))
  44. return queryset
  45. class PublisherList(FilterableBaseListView):
  46. model = Publisher
  47. class DeveloperList(FilterableBaseListView):
  48. model = Developer
  49. class GenreList(FilterableBaseListView):
  50. model = Genre
  51. class GameDetail(DetailView, LoginRequiredMixin):
  52. model = Game
  53. class GamePlayDetail(DetailView, LoginRequiredMixin):
  54. template_name = "games/game_play_detail.html"
  55. model = Game
  56. class GameSystemList(ListView, LoginRequiredMixin):
  57. model = GameSystem
  58. class GameSystemDetail(DetailView, MultipleObjectMixin, LoginRequiredMixin):
  59. model = GameSystem
  60. paginate_by = 20
  61. def get_context_data(self, **kwargs):
  62. object_list = Game.objects.filter(game_system=self.get_object())
  63. context = super(GameSystemDetail, self).get_context_data(
  64. object_list=object_list, **kwargs
  65. )
  66. return context
  67. class GenreDetail(DetailView, MultipleObjectMixin, LoginRequiredMixin):
  68. model = Genre
  69. paginate_by = 20
  70. def get_context_data(self, **kwargs):
  71. object_list = Game.objects.filter(genre=self.get_object())
  72. context = super(GenreDetail, self).get_context_data(
  73. object_list=object_list, **kwargs
  74. )
  75. return context
  76. class PublisherDetail(DetailView, MultipleObjectMixin, LoginRequiredMixin):
  77. model = Publisher
  78. paginate_by = 20
  79. def get_context_data(self, **kwargs):
  80. object_list = Game.objects.filter(publisher=self.get_object())
  81. context = super(PublisherDetail, self).get_context_data(
  82. object_list=object_list, **kwargs
  83. )
  84. return context
  85. class DeveloperDetail(DetailView, MultipleObjectMixin, LoginRequiredMixin):
  86. model = Developer
  87. paginate_by = 20
  88. def get_context_data(self, **kwargs):
  89. object_list = Game.objects.filter(developer=self.get_object())
  90. context = super(DeveloperDetail, self).get_context_data(
  91. object_list=object_list, **kwargs
  92. )
  93. return context
  94. class GameCollectionList(ListView, LoginRequiredMixin):
  95. model = GameCollection
  96. class GameCollectionDetail(DetailView, LoginRequiredMixin):
  97. model = GameCollection
  98. def get_context_data(self, **kwargs):
  99. collection = self.get_object()
  100. order_by = self.request.GET.get("order_by", "release_date")
  101. object_list = collection.games.all()
  102. if order_by[0] == "-":
  103. order_by = order_by[1:]
  104. object_list = object_list.order_by(F(order_by).desc(nulls_last=True))
  105. else:
  106. object_list = object_list.order_by(F(order_by).asc(nulls_last=True))
  107. context = super(GameCollectionDetail, self).get_context_data(
  108. object_list=object_list, **kwargs
  109. )
  110. return context