ezsystems / ezpublish-kernel

    /**

     * {@inheritdoc}

     */

    public function loadBookmarkDataByUserIdAndLocationId(int $userId, array $locationIds): array

    {

        $query = $this->connection->createQueryBuilder();

        $query

            ->select(...$this->getColumns())

            ->from(self::TABLE_BOOKMARKS)

            ->where($query->expr()->andX(

                $query->expr()->eq(self::COLUMN_USER_ID, ':user_id'),

                $query->expr()->in(self::COLUMN_LOCATION_ID, ':location_id')

            ))

            ->setParameter(':user_id', $userId, PDO::PARAM_INT)

            ->setParameter(':location_id', $locationIds, Connection::PARAM_INT_ARRAY);

        return $query->execute()->fetchAll(PDO::FETCH_ASSOC);

    }

    /**

     * {@inheritdoc}

        return (int) $this->connection->lastInsertId();

    }

    public function getUserPreferenceByUserIdAndName(int $userId, string $name): array

    {

        $query = $this->connection->createQueryBuilder();

        $query

            ->select(...$this->getColumns())

            ->from(self::TABLE_USER_PREFERENCES)

            ->where($query->expr()->eq(self::COLUMN_USER_ID, ':userId'))

            ->andWhere($query->expr()->eq(self::COLUMN_NAME, ':name'));

        $query->setParameter(':userId', $userId, ParameterType::INTEGER);

        $query->setParameter(':name', $name, ParameterType::STRING);

        return $query->execute()->fetchAll(FetchMode::ASSOCIATIVE);

    }

    /**

     * {@inheritdoc}