vendor/crehler/mojebambino-catalog/src/Subscriber/CatalogRawGeneratorSubscriber.php line 66

Open in your IDE?
  1. <?php
  2. declare(strict_types=1);
  3. /**
  4.  * @copyright 2020 Crehler Sp. z o. o.
  5.  * @link https://crehler.com/
  6.  * @support support@crehler.com
  7.  *
  8.  * @author Mateusz Flasiński
  9.  *
  10.  * For the full copyright and license information, please view the LICENSE
  11.  * file that was distributed with this source code.
  12.  */
  14. namespace Crehler\Catalog\Subscriber;
  16. use Crehler\Catalog\Event\CatalogMediaGeneratedEvent;
  17. use Crehler\Catalog\Service\Indexer\CatalogBookmarkIndexerEvent;
  18. use Crehler\Catalog\Service\Indexer\CatalogIndexerEvent;
  19. use Crehler\Catalog\Service\Indexer\CatalogPageIndexerEvent;
  20. use Doctrine\DBAL\Connection;
  21. use Symfony\Component\EventDispatcher\EventSubscriberInterface;
  22. use function Symfony\Component\String\u;
  24. class CatalogRawGeneratorSubscriber implements EventSubscriberInterface
  25. {
  26.     private Connection $connection;
  28.     public function __construct(Connection $connection)
  29.     {
  30.         $this->connection = $connection;
  31.     }
  33.     public static function getSubscribedEvents()
  34.     {
  35.         return [
  36.             CatalogMediaGeneratedEvent::class => 'onMediaGenerated',
  37.             CatalogBookmarkIndexerEvent::class => 'indexBookmarks',
  38.             CatalogPageIndexerEvent::class => 'indexPage',
  39.             CatalogIndexerEvent::class => 'indexCatalog',
  40.         ];
  41.     }
  43.     public function onMediaGenerated(CatalogMediaGeneratedEvent $event)
  44.     {
  45.         $path = u($event->getPath());
  46.         if ($path->startsWith('thumbnail')) {
  47.             $path = u($event->getPath())->afterLast('/')->beforeLast('_')->toString();
  48.         } else {
  49.             $path = u($event->getPath())->afterLast('/')->beforeLast('.')->toString();
  50.         }
  51.         $catalogId = $this->findPageByThumbnail($path);
  53.         if (!is_string($catalogId)) {
  54.             return;
  55.         }
  56.     }
  58.     public function indexBookmarks(CatalogBookmarkIndexerEvent $event)
  59.     {
  60.     }
  62.     public function indexCatalog(CatalogIndexerEvent $event)
  63.     {
  64.     }
  66.     public function indexPage(CatalogPageIndexerEvent $event)
  67.     {
  68.     }
  70.     private function findPageByThumbnail(string $path)
  71.     {
  72.         return $this->connection
  73.             ->createQueryBuilder()
  74.             ->select('LOWER(HEX(cp.catalog_id))')
  75.             ->from('catalog_page', 'cp')
  76.             ->innerJoin('cp', 'media', 'm', 'm.id = cp.media_id')
  77.             ->where('m.file_name LIKE :name')
  78.             ->setParameter('name', "%$path%")
  79.             ->execute()
  80.             ->fetchColumn();
  81.     }
  82. }