custom/plugins/AppflixCustomerMarket/src/Core/Service/CountVisitorService.php line 27

  1. <?php declare(strict_types=1);
  3. namespace Appflix\CustomerMarket\Core\Service;
  5. use Shopware\Core\Framework\Uuid\Uuid;
  6. use Doctrine\DBAL\Connection;
  8. class CountVisitorService
  9. {
  10.     public function __construct(private readonly Connection $connection)
  11.     {
  12.     }
  14.     public function update(string $appflixAdId): void
  15.     {
  16.         $visitedAdIds = [];
  17.         if (in_array($appflixAdId, $visitedAdIds)) {
  18.             return;
  19.         }
  21.         $visitedAdIds[] = $appflixAdId;
  23.         $sql = <<<SQL
  24. UPDATE `appflix_ad` 
  25. SET `visitors` = `visitors` + 1
  26. WHERE `id` = :id;
  27. SQL;
  28.         $this->connection->executeUpdate($sql, ['id' => Uuid::fromHexToBytes($appflixAdId)]);
  29.     }
  30. }