1 # This file is part of Wolne Lektury, licensed under GNU Affero GPLv3 or later.
2 # Copyright © Fundacja Wolne Lektury. See NOTICE for more information.
4 from oauthlib.common import urlencode, generate_token
5 from random import randint
6 from django.db import models
7 from django.conf import settings
8 from django.contrib.auth.models import User
9 from django.core.exceptions import ValidationError
10 from django.core.mail import send_mail
11 from django.urls import reverse
12 from django.utils.timezone import now
13 from catalogue.models import Book
14 from wolnelektury.utils import cached_render, clear_cached_renders
17 class BannerGroup(models.Model):
18 name = models.CharField('nazwa', max_length=255, unique=True)
19 created_at = models.DateTimeField('utworzona', auto_now_add=True)
23 verbose_name = 'grupa bannerów'
24 verbose_name_plural = 'grupy bannerów'
29 def get_absolute_url(self):
30 """This is used for testing."""
31 return "%s?banner_group=%d" % (reverse('main_page'), self.id)
34 banners = self.cite_set.all()
35 count = banners.count()
38 return banners[randint(0, count-1)]
41 class Cite(models.Model):
42 book = models.ForeignKey(Book, models.CASCADE, verbose_name='książka', null=True, blank=True)
43 text = models.TextField('tekst', blank=True)
44 small = models.BooleanField(
45 'mały', default=False, help_text='Sprawia, że cytat wyświetla się mniejszym fontem.')
46 vip = models.CharField('VIP', max_length=128, null=True, blank=True)
47 link = models.URLField('odnośnik')
48 video = models.URLField('wideo', blank=True)
49 picture = models.ImageField('ilustracja', blank=True,
50 help_text='Najlepsze wymiary: 975 x 315 z tekstem, 487 x 315 bez tekstu.')
51 picture_alt = models.CharField('alternatywny tekst ilustracji', max_length=255, blank=True)
52 picture_title = models.CharField('tytuł ilustracji', max_length=255, null=True, blank=True)
53 picture_author = models.CharField('autor ilustracji', max_length=255, blank=True, null=True)
54 picture_link = models.URLField('link ilustracji', blank=True, null=True)
55 picture_license = models.CharField('nazwa licencji ilustracji', max_length=255, blank=True, null=True)
56 picture_license_link = models.URLField('adres licencji ilustracji', blank=True, null=True)
58 sticky = models.BooleanField('przyklejony', default=False, db_index=True,
59 help_text='Przyklejone cytaty mają pierwszeństwo.')
60 background_plain = models.BooleanField('jednobarwne tło', default=False)
61 background_color = models.CharField('kolor tła', max_length=32, blank=True)
62 image = models.ImageField(
63 'obraz tła', upload_to='social/cite', null=True, blank=True,
64 help_text='Najlepsze tło ma wielkość 975 x 315 px i waży poniżej 100kB.')
65 image_title = models.CharField('tytuł obrazu tła', max_length=255, null=True, blank=True)
66 image_author = models.CharField('autor obrazu tła', max_length=255, blank=True, null=True)
67 image_link = models.URLField('link obrazu tła', blank=True, null=True)
68 image_license = models.CharField('nazwa licencji obrazu tła', max_length=255, blank=True, null=True)
69 image_license_link = models.URLField('adres licencji obrazu tła', blank=True, null=True)
71 created_at = models.DateTimeField('utworzony', auto_now_add=True)
72 group = models.ForeignKey(BannerGroup, verbose_name='grupa', null=True, blank=True, on_delete=models.SET_NULL)
75 ordering = ('vip', 'text')
76 verbose_name = 'banner'
77 verbose_name_plural = 'bannery'
82 t.append(self.text[:60])
84 t.append('[ks.]'[:60])
85 t.append(self.link[:60])
87 t.append('vip: ' + self.vip)
94 def get_absolute_url(self):
95 """This is used for testing."""
96 return "%s?banner=%d" % (reverse('main_page'), self.id)
99 return self.video or self.picture
102 return self.vip or self.text or self.book
109 pieces.append('text')
110 return '-'.join(pieces)
113 def save(self, *args, **kwargs):
114 ret = super(Cite, self).save(*args, **kwargs)
118 @cached_render('social/cite_promo.html')
125 def clear_cache(self):
126 clear_cached_renders(self.main_box)
129 class Carousel(models.Model):
130 placement = models.SlugField('miejsce', choices=[
132 ('main_2022', 'main 2022'),
134 priority = models.SmallIntegerField('priorytet', default=0)
135 language = models.CharField('język', max_length=2, blank=True, default='', choices=settings.LANGUAGES)
138 # ordering = ('placement', '-priority')
139 verbose_name = 'karuzela'
140 verbose_name_plural = 'karuzele'
143 return self.placement
146 def get(cls, placement):
147 carousel = cls.objects.filter(placement=placement).order_by('-priority', '?').first()
149 carousel = cls.objects.create(placement=placement)
153 class CarouselItem(models.Model):
154 order = models.PositiveSmallIntegerField('kolejność')
155 carousel = models.ForeignKey(Carousel, models.CASCADE, verbose_name='karuzela')
156 banner = models.ForeignKey(
157 Cite, models.CASCADE, null=True, blank=True, verbose_name='banner')
158 banner_group = models.ForeignKey(
159 BannerGroup, models.CASCADE, null=True, blank=True, verbose_name='grupa bannerów')
162 ordering = ('order',)
163 verbose_name = 'element karuzeli'
164 verbose_name_plural = 'elementy karuzeli'
167 return str(self.banner or self.banner_group)
170 if not self.banner and not self.banner_group:
171 raise ValidationError('Proszę wskazać banner albo grupę bannerów.')
172 elif self.banner and self.banner_group:
173 raise ValidationError('Proszę wskazać banner albo grupę bannerów.')
175 def get_banner(self):
176 return self.banner or self.banner_group.get_banner()
179 class UserConfirmation(models.Model):
180 user = models.ForeignKey(User, models.CASCADE)
181 created_at = models.DateTimeField(auto_now_add=True)
182 key = models.CharField(max_length=128, unique=True)
186 'Potwierdź konto w bibliotece Wolne Lektury',
187 f'https://beta.wolnelektury.pl/ludzie/potwierdz/{self.key}/',
188 settings.CONTACT_EMAIL,
194 user.is_active = True
199 def request(cls, user):
207 class Progress(models.Model):
208 user = models.ForeignKey(User, models.CASCADE)
209 book = models.ForeignKey('catalogue.Book', models.CASCADE)
210 created_at = models.DateTimeField(auto_now_add=True)
211 updated_at = models.DateTimeField(auto_now=True)
212 deleted = models.BooleanField(default=False)
213 last_mode = models.CharField(max_length=64, choices=[
217 text_percent = models.FloatField(null=True, blank=True)
218 text_anchor = models.CharField(max_length=64, blank=True)
219 audio_percent = models.FloatField(null=True, blank=True)
220 audio_timestamp = models.FloatField(null=True, blank=True)
221 implicit_text_percent = models.FloatField(null=True, blank=True)
222 implicit_text_anchor = models.CharField(max_length=64, blank=True)
223 implicit_audio_percent = models.FloatField(null=True, blank=True)
224 implicit_audio_timestamp = models.FloatField(null=True, blank=True)
227 unique_together = [('user', 'book')]
230 def sync(cls, user, slug, ts, data):
231 obj, _created = cls.objects.get_or_create(user=user, book__slug=slug)
232 if _created or obj.updated_at < ts:
235 for k, v in data.items():
241 def save(self, *args, **kwargs):
242 audio_l = self.book.get_audio_length()
244 self.text_percent = 33
246 self.implicit_audio_percent = 40
247 self.implicit_audio_timestamp = audio_l * .4
248 if self.audio_timestamp:
249 if self.audio_timestamp > audio_l:
250 self.audio_timestamp = audio_l
252 self.audio_percent = 100 * self.audio_timestamp / audio_l
253 self.implicit_text_percent = 60
254 self.implicit_text_anchor = 'f20'
255 return super().save(*args, **kwargs)
258 class UserList(models.Model):
259 slug = models.SlugField(unique=True)
260 user = models.ForeignKey(User, models.CASCADE)
261 name = models.CharField(max_length=1024)
262 favorites = models.BooleanField(default=False)
263 public = models.BooleanField(default=False)
264 deleted = models.BooleanField(default=False)
265 created_at = models.DateTimeField(auto_now_add=True)
266 updated_at = models.DateTimeField()
268 def get_absolute_url(self):
270 'tagged_object_list',
271 args=[f'polka/{self.slug}']
279 return f'polka/{self.slug}'
282 def create(cls, user, name):
283 return cls.objects.create(
286 slug=get_random_hash(name),
291 def get_by_name(cls, user, name, create=False):
292 l = cls.objects.filter(
296 if l is None and create:
297 l = cls.create(user, name)
301 def get_favorites_list(cls, user, create=False):
303 return cls.objects.get(
307 except cls.DoesNotExist:
309 return cls.objects.create(
312 slug=get_random_hash(name),
317 except cls.MultipleObjectsReturned:
319 lists = list(cls.objects.filter(user=user, favorites=True))
321 t.userlistitem_set.all().update(
328 def likes(cls, user, book):
329 ls = cls.get_favorites_list(user)
332 return ls.userlistitem_set.filter(deleted=False, book=book).exists()
334 def append(self, book):
335 # TODO: check for duplicates?
336 self.userlistitem_set.create(
338 order=self.userlistitem_set.aggregate(m=models.Max('order'))['m'] + 1,
341 book.update_popularity()
343 def remove(self, book):
344 self.userlistitem_set.filter(book=book).update(
348 book.update_popularity()
351 def like(cls, user, book):
352 ul = cls.get_favorites_list(user, create=True)
356 def unlike(cls, user, book):
357 ul = cls.get_favorites_list(user)
362 return [item.book for item in self.userlistitem_set.exclude(deleted=True).exclude(book=None)]
365 class UserListItem(models.Model):
366 list = models.ForeignKey(UserList, models.CASCADE)
367 order = models.IntegerField()
368 deleted = models.BooleanField(default=False)
369 created_at = models.DateTimeField(auto_now_add=True)
370 updated_at = models.DateTimeField()
372 book = models.ForeignKey('catalogue.Book', models.SET_NULL, null=True, blank=True)
373 fragment = models.ForeignKey('catalogue.Fragment', models.SET_NULL, null=True, blank=True)
374 quote = models.ForeignKey('bookmarks.Quote', models.SET_NULL, null=True, blank=True)
375 bookmark = models.ForeignKey('bookmarks.Bookmark', models.SET_NULL, null=True, blank=True)
377 note = models.TextField(blank=True)