+ def translators_first_names(self):
+ return ', '.join(a.first_name for a in self.translators.all())
+
+ def translators_last_names(self):
+ return ', '.join(a.last_name for a in self.translators.all())
+
+ def document_book__project(self):
+ b = self.document_books.first()
+ if b is None: return ''
+ if b.project is None: return ''
+ return b.project.name
+
+ def audience(self):
+ try:
+ return self.document_books.first().wldocument().book_info.audience or ''
+ except:
+ return ''
+
+ def get_estimated_costs(self):
+ return {
+ work_type: work_type.calculate(self)
+ for work_type in WorkType.objects.all()
+ }
+
+ def scans_galleries(self):
+ return [bs.pk for bs in self.booksource_set.all()]
+
+ def is_published(self):
+ return any(b.is_published() for b in self.document_books.all())
+
+ def update_monthly_stats(self):
+ # Find publication date.
+ # By default, get previous 12 months.
+ this_month = date.today().replace(day=1)
+ cutoff = this_month.replace(year=this_month.year - 1)
+ months = 12
+
+ # If the book was published later,
+ # find out the denominator.
+ pbr = apps.get_model('documents', 'BookPublishRecord').objects.filter(
+ book__catalogue_book=self).order_by('timestamp').first()
+ if pbr is not None and pbr.timestamp.date() > cutoff:
+ months = (this_month - pbr.timestamp.date()).days / 365 * 12
+
+ if not months:
+ return
+
+ stats = self.bookmonthlystats_set.filter(date__gte=cutoff).aggregate(
+ views_page=models.Sum('views_page'),
+ views_reader=models.Sum('views_reader')
+ )
+ self.monthly_views_page = stats['views_page'] / months
+ self.monthly_views_reader = stats['views_reader'] / months
+ self.save(update_fields=['monthly_views_page', 'monthly_views_reader'])
+
+ @property
+ def content_stats(self):
+ if hasattr(self, '_content_stats'):
+ return self._content_stats
+ try:
+ stats = self.document_books.first().wldocument(librarian2=True).get_statistics()['total']
+ except Exception as e:
+ stats = {}
+ self._content_stats = stats
+ return stats
+
+ @property
+ def are_sources_ready(self):
+ if not self.booksource_set.exists():
+ return False
+ for bs in self.booksource_set.all():
+ if not bs.source.has_view_files() or not bs.source.has_ocr_files() or bs.source.modified_at > bs.source.processed_at:
+ return False
+ return True
+
+ chars = lambda self: self.content_stats.get('chars', '')
+ chars_with_fn = lambda self: self.content_stats.get('chars_with_fn', '')
+ words = lambda self: self.content_stats.get('words', '')
+ words_with_fn = lambda self: self.content_stats.get('words_with_fn', '')
+ verses = lambda self: self.content_stats.get('verses', '')
+ verses_with_fn = lambda self: self.content_stats.get('verses_with_fn', '')
+ chars_out_verse = lambda self: self.content_stats.get('chars_out_verse', '')
+ chars_out_verse_with_fn = lambda self: self.content_stats.get('chars_out_verse_with_fn', '')
+
+
+class EditorNote(models.Model):
+ book = models.ForeignKey(Book, models.CASCADE)
+ user = models.ForeignKey(settings.AUTH_USER_MODEL, models.CASCADE)
+ created_at = models.DateTimeField(auto_now_add=True)
+ changed_at = models.DateTimeField(auto_now=True)
+ note = models.TextField(blank=True)
+ rate = models.IntegerField(default=3, choices=[
+ (n, n) for n in range(1, 6)
+ ])
+
+
+class CollectionCategory(models.Model):
+ name = models.CharField(_("name"), max_length=255)
+ parent = models.ForeignKey('self', models.SET_NULL, related_name='children', null=True, blank=True, verbose_name=_("parent"))
+ notes = models.TextField(_("notes"), blank=True, help_text=_('private'))
+
+ class Meta:
+ ordering = ('parent__name', 'name')
+ verbose_name = _('collection category')
+ verbose_name_plural = _('collection categories')
+
+ def __str__(self):
+ if self.parent:
+ return f"{self.parent} / {self.name}"
+ else:
+ return self.name