namespace Wallabag\CoreBundle\Twig;
-use Doctrine\ORM\Query;
use Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorageInterface;
+use Symfony\Component\Translation\TranslatorInterface;
use Wallabag\CoreBundle\Repository\EntryRepository;
use Wallabag\CoreBundle\Repository\TagRepository;
private $entryRepository;
private $tagRepository;
private $lifeTime;
+ private $translator;
- public function __construct(EntryRepository $entryRepository = null, TagRepository $tagRepository = null, TokenStorageInterface $tokenStorage = null, $lifeTime = 0)
+ public function __construct(EntryRepository $entryRepository, TagRepository $tagRepository, TokenStorageInterface $tokenStorage, $lifeTime, TranslatorInterface $translator)
{
$this->entryRepository = $entryRepository;
$this->tagRepository = $tagRepository;
$this->tokenStorage = $tokenStorage;
$this->lifeTime = $lifeTime;
+ $this->translator = $translator;
}
public function getFilters()
public function getFunctions()
{
- return array(
+ return [
new \Twig_SimpleFunction('count_entries', [$this, 'countEntries']),
new \Twig_SimpleFunction('count_tags', [$this, 'countTags']),
- );
+ new \Twig_SimpleFunction('display_stats', [$this, 'displayStats']),
+ ];
}
public function removeWww($url)
$user = $this->tokenStorage->getToken() ? $this->tokenStorage->getToken()->getUser() : null;
if (null === $user || !is_object($user)) {
- return [];
+ return 0;
}
switch ($type) {
case 'starred':
$qb = $this->entryRepository->getBuilderForStarredByUser($user->getId());
break;
-
case 'archive':
$qb = $this->entryRepository->getBuilderForArchiveByUser($user->getId());
break;
-
case 'unread':
$qb = $this->entryRepository->getBuilderForUnreadByUser($user->getId());
break;
-
case 'all':
$qb = $this->entryRepository->getBuilderForAllByUser($user->getId());
break;
-
default:
throw new \InvalidArgumentException(sprintf('Type "%s" is not implemented.', $type));
}
->groupBy('e.id')
->getQuery();
- $data = $this->enableCache($query)
- ->getArrayResult();
+ $query->useQueryCache(true);
+ $query->useResultCache(true);
+ $query->setResultCacheLifetime($this->lifeTime);
- return count($data);
+ return count($query->getArrayResult());
}
/**
$user = $this->tokenStorage->getToken() ? $this->tokenStorage->getToken()->getUser() : null;
if (null === $user || !is_object($user)) {
- return [];
+ return 0;
}
- $qb = $this->tagRepository->findAllTags($user->getId());
-
- $data = $this->enableCache($qb->getQuery())
- ->getArrayResult();
-
- return count($data);
+ return $this->tagRepository->countAllTags($user->getId());
}
/**
- * Enable cache for a query.
- *
- * @param Query $query
+ * Display a single line about reading stats.
*
- * @return Query
+ * @return string
*/
- private function enableCache(Query $query)
+ public function displayStats()
{
+ $user = $this->tokenStorage->getToken() ? $this->tokenStorage->getToken()->getUser() : null;
+
+ if (null === $user || !is_object($user)) {
+ return 0;
+ }
+
+ $query = $this->entryRepository->getBuilderForArchiveByUser($user->getId())
+ ->select('e.id')
+ ->groupBy('e.id')
+ ->getQuery();
+
$query->useQueryCache(true);
$query->useResultCache(true);
$query->setResultCacheLifetime($this->lifeTime);
- return $query;
+ $nbArchives = count($query->getArrayResult());
+
+ $interval = $user->getCreatedAt()->diff(new \DateTime('now'));
+ $nbDays = (int) $interval->format('%a') ?: 1;
+
+ // force setlocale for date translation
+ setlocale(LC_TIME, strtolower($user->getConfig()->getLanguage()) . '_' . strtoupper(strtolower($user->getConfig()->getLanguage())));
+
+ return $this->translator->trans('footer.stats', [
+ '%user_creation%' => strftime('%e %B %Y', $user->getCreatedAt()->getTimestamp()),
+ '%nb_archives%' => $nbArchives,
+ '%per_day%' => round($nbArchives / $nbDays, 2),
+ ]);
}
public function getName()