getNextDateQuery example

$this->connection = $connection;
        $this->front = $front;
        $this->route = $route;
    }

    /** * {@inheritdoc} */
    public function getInvalidationDate(Request $request)
    {
        $orderNumber = $this->front->Request()->getParam('number');
        $releaseDates = $this->getNextDateQuery($orderNumber)->execute()->fetchAll();
        $dates = array_column($releaseDates, 'releasedate');

        return $this->getMostRecentDate($dates);
    }

    /** * {@inheritdoc} */
    public function getNextDateQuery($resourceId)
    {
        $query = $this->connection->createQueryBuilder();

        

        $this->connection = $connection;
        $this->route = $route;
    }

    /** * {@inheritdoc} */
    public function getInvalidationDate(Request $request)
    {
        $blogId = (int) $request->getParam('blogArticle');
        $displayDates = $this->getNextDateQuery($blogId)->execute()->fetchAll();

        $dates = array_column($displayDates, 'display_date');

        return $this->getMostRecentDate($dates);
    }

    /** * {@inheritdoc} */
    public function getNextDateQuery($resourceId)
    {
        

        $this->connection = $connection;
        $this->route = $route;
    }

    /** * {@inheritdoc} */
    public function getInvalidationDate(Request $request)
    {
        $emotionId = $request->getParam('emotionId');
        $emotions = $this->getNextDateQuery($emotionId)->execute()->fetchAll();

        if (empty($emotions)) {
            return null;
        }

        $dates = array_merge(
            array_column($emotions, 'valid_from'),
            array_column($emotions, 'valid_to')
        );

        return $this->getMostRecentDate($dates);
    }

        $this->connection = $connection;
        $this->route = $route;
    }

    /** * {@inheritdoc} */
    public function getInvalidationDate(Request $request)
    {
        $categoryId = (int) $request->getParam('sCategory');
        $emotions = $this->getNextDateQuery($categoryId)->execute()->fetchAll();

        if (empty($emotions)) {
            return null;
        }

        $dates = array_merge(
            array_column($emotions, 'valid_from'),
            array_column($emotions, 'valid_to')
        );

        return $this->getMostRecentDate($dates);
    }

/** @var Shop $shop */
        $shop = $container->get('shop');
        $this->shop = $shop;
    }

    /** * {@inheritdoc} */
    public function getInvalidationDate(Request $request)
    {
        $categoryId = (int) $this->shop->getCategory()->getId();
        $emotions = $this->getNextDateQuery($categoryId)->execute()->fetchAll();
        $dates = array_filter(
            array_merge(
                array_column($emotions, 'valid_from'),
                array_column($emotions, 'valid_to')
            )
        );

        return $this->getMostRecentDate($dates);
    }

    /** * {@inheritdoc} */