assemble example

|| $request->isPost()
            || $request->isXmlHttpRequest()             // is a ajax call             || $request->has('callback')                // is a jsonp call             || $request->getModuleName() != 'frontend'  // is not frontend             || !$request->getParam('rewriteAlias')      // is not a rewrite url alias         ) {
            return;
        }
        $router = $args->getSubject()->ensureRouter();

        $query = $request->getQuery();
        $location = $router->assemble($query);

        // Fix shop redirect / if it's not a seo url         if (preg_match('#\/[0-9]+$#', $location, $match) > 0) {
            $location = $request->getBaseUrl() . '/';
        }

        $current = $request->getScheme() . '://' . $request->getHttpHost() . $request->getRequestUri();
        if ($location !== $current) {
            $response->setRedirect($location, 301);
        }
    }
}

throw new Zend_Db_Select_Exception("Unrecognized method '$method()'");
    }

    /** * Implements magic method. * * @return string this object as a SELECT string */
    public function __toString()
    {
        try {
            $sql = $this->assemble();
        } catch (Exception $e) {
            trigger_error($e->getMessage(), E_USER_WARNING);
            $sql = '';
        }

        return (string) $sql;
    }

    /** * Get bind variables * * @return array */

if (!empty(Shopware()->Config()->get('CaptchaColor'))) {
                /** @var \Shopware\Components\Captcha\CaptchaValidator $captchaValidator */
                $captchaValidator = $this->container->get('shopware.captcha.validator');

                if (!$captchaValidator->validate($this->Request())) {
                    $variables['sError'] = true;
                }
            }

            if ($variables['sError'] == false) {
                // Prepare eMail                 $product['linkDetails'] = $this->Front()->ensureRouter()->assemble(['sViewport' => 'detail', 'sArticle' => $product['articleID']]);

                $context = [
                    'sName' => $this->sSYSTEM->_POST['sName'],
                    'sArticle' => html_entity_decode($product['articleName']),
                    'sLink' => $product['linkDetails'],
                ];

                if ($this->sSYSTEM->_POST['sComment']) {
                    $context['sComment'] = strip_tags(html_entity_decode($this->sSYSTEM->_POST['sComment']));
                } else {
                    $context['sComment'] = '';
                }

$AlreadyNotified = $connection->fetchAssoc(' SELECT * FROM `s_articles_notification` WHERE `ordernumber`=? AND `mail` = ? AND send = 0 ', [$notifyOrderNumber, $email]);

                if (empty($AlreadyNotified)) {
                    $action->View()->assign('NotifyAlreadyRegistered', false);

                    $hash = Random::getAlphanumericString(32);
                    $link = $action->Front()->ensureRouter()->assemble([
                        'sViewport' => 'detail',
                        'sArticle' => $id,
                        'sNotificationConfirmation' => $hash,
                        'sNotify' => '1',
                        'action' => 'notifyConfirm',
                        'number' => $notifyOrderNumber,
                    ]);

                    /** @var Shopware_Components_Modules $modules */
                    $modules = $this->get('modules');

                    

private function getUrls(Type $type): array
    {
        $shops = $this->getModelManager()->getRepository(Shop::class)->getActiveShopsFixed();

        $urls = [];

        foreach ($shops as $shop) {
            $shop->registerResources();

            $urls[] = [
                'name' => $shop->getName(),
                'url' => $this->Front()->ensureRouter()->assemble([
                    'controller' => $type->getControllerName(),
                    'module' => 'frontend',
                    'action' => 'index',
                    'fullPath' => true,
                ]),
            ];
        }

        return $urls;
    }
}

$hrefs = [];

        foreach ($shops as $languageShop) {
            $shop = $this->getDetachedShop($languageShop['id']);

            $config->setShop($shop);

            $href = new HrefLang();
            $href->setShopId($languageShop['id']);
            $href->setLocale($languageShop['locale']);
            $routingContext = $this->getContext($shop, $config);
            $href->setLink($this->filterUrl((string) $this->rewriteRouter->assemble($parameters, $routingContext), $parameters));

            if (!$config->get('hrefLangCountry')) {
                $href->setLocale(explode('-', $languageShop['locale'])[0]);
            }

            if ((int) $languageShop['id'] === $config->get('hrefLangDefaultShop')) {
                $href->setLocale('x-default');
            }

            if ($this->config->get('hrefLangJustSeoUrl') && !$this->isSeoUrl($parameters, $href->getLink(), $routingContext)) {
                continue;
            }

        }

        $customerId = Shopware()->Modules()->Admin()->sGetUserByMail($email);
        if (empty($customerId)) {
            return [];
        }

        $hash = Random::getAlphanumericString(32);

        $context = [
            'sUrlReset' => $this->Front()->ensureRouter()->assemble(['controller' => 'account', 'action' => 'resetPassword', 'hash' => $hash]),
            'sUrl' => $this->Front()->ensureRouter()->assemble(['controller' => 'account', 'action' => 'resetPassword']),
            'sKey' => $hash,
        ];

        $sql = 'SELECT s_user.accountmode, s_user.active, s_user.affiliate, s_user.birthday, s_user.confirmationkey, s_user.customergroup, s_user.customernumber, s_user.email, s_user.failedlogins, s_user.firstlogin, s_user.lastlogin, s_user.language, s_user.internalcomment, s_user.lockeduntil, s_user.subshopID, s_user.title, s_user.salutation, s_user.firstname, s_user.lastname, s_user.lastlogin, s_user.newsletter FROM s_user WHERE id = ?';

/** * @param array<string, mixed> $categoryContent */
    private function getRedirectLocation(array $categoryContent, bool $hasEmotion, ShopContextInterface $context): ?string
    {
        if (\is_string($categoryContent['external']) && $categoryContent['external'] !== '') {
            return $categoryContent['external'];
        }

        if ($this->isShopsBaseCategoryPage($categoryContent['id'])) {
            return $this->Front()->ensureRouter()->assemble(['controller' => 'index']);
        }

        $checkRedirect = ($hasEmotion && $this->Request()->getParam('sPage')) || (!$hasEmotion);

        if (!$checkRedirect || !$this->config->get('categoryDetailLink')) {
            return null;
        }

        $criteria = $this->storeFrontCriteriaFactory->createListingCriteria($this->Request(), $context);
        $criteria->resetFacets()
            ->resetConditions()
            

Shopware()->System()->_POST = [
            'email' => $user['email'],
            'passwordMD5' => $user['password'],
        ];
        Shopware()->Modules()->Admin()->sLogin(true);

        $hash = $this->container->get(OptinServiceInterface::class)->add(OptinServiceInterface::TYPE_CUSTOMER_LOGIN_FROM_BACKEND, 300, [
            'sessionId' => Shopware()->Session()->get('sessionId'),
            'shopId' => $shop->getId(),
        ]);

        $url = $this->Front()->ensureRouter()->assemble([
            'action' => 'performOrderRedirect',
            'hash' => $hash,
            'fullPath' => true,
        ]);

        if ($shop->getHost()) {
            // change the url to the subshop url             $url = str_replace('://' . $this->Request()->getHttpHost(), '://' . $shop->getHost(), $url);
        }

        $this->redirect($url);
    }

// Check each column to ensure it only references the primary table                     if ($column) {
                        if (!isset($from[$table]) || $from[$table]['tableName'] != $primary) {
                            throw new Zend_Db_Table_Select_Exception('Select query cannot join with another table');
                        }
                    }
                }
            }
        }

        return parent::assemble();
    }
}

return $finalDisallow;
    }

    /** * @return string[] */
    public function getSitemaps(): array
    {
        $finalSitemaps = [];

        foreach ($this->routerContext as $context) {
            $finalSitemaps[] = 'Sitemap: ' . $this->router->assemble([
                'module' => 'frontend',
                'controller' => 'sitemap_index.xml',
                'fullPath' => true,
            ], $context);
        }

        $finalSitemaps = array_unique($finalSitemaps);

        return $finalSitemaps;
    }

    

$repository = $this->get('models')->getRepository(Shop::class);
        $shop = $repository->getActiveById($shopId);

        if (!$shop instanceof Shop) {
            throw new Exception('Invalid shop provided.');
        }

        $this->get(ShopRegistrationServiceInterface::class)->registerShop($shop);

        Shopware()->Session()->set('Admin', true);

        $url = $this->Front()->ensureRouter()->assemble(
            [
                'module' => 'frontend',
                'controller' => 'detail',
                'sArticle' => $productId,
            ]
        );

        $this->Response()->headers->setCookie(new Cookie('shop', (string) $shopId, 0, $shop->getBasePath()));
        $this->redirect($url);
    }

    

if (!empty($title)) {
            $queryArray['title'] = $title;
        }
        $queryArray['module'] = 'frontend';

        $newQueryArray = [];
        foreach ($queryArray as $key => $queryItem) {
            $newQueryArray[(string) $key] = $queryItem;
        }

        return $this->front->ensureRouter()->assemble($newQueryArray);
    }
}

if ($product) {
                $blogArticleData['sRelatedArticles'][] = $product;
            }
        }

        // Adding average vote data to the blog article         $avgVoteQuery = $this->repository->getAverageVoteQuery($blogArticleId, $shop->getId());
        $blogArticleData['sVoteAverage'] = $avgVoteQuery->getOneOrNullResult(AbstractQuery::HYDRATE_SINGLE_SCALAR);

        // Generate breadcrumb         $breadcrumb = $this->getCategoryBreadcrumb($blogArticleData['categoryId']);
        $blogDetailLink = $this->Front()->ensureRouter()->assemble([
            'sViewport' => 'blog', 'sCategory' => $blogArticleData['categoryId'],
            'action' => 'detail', 'blogArticle' => $blogArticleId,
        ]);

        $breadcrumb[] = ['link' => $blogDetailLink, 'name' => $blogArticleData['title']];

        $this->View()->assign([
            'sBreadcrumb' => $breadcrumb,
            'sArticle' => $blogArticleData,
            'rand' => Random::getAlphanumericString(32),
            'sNumberPages' => 1,
        ]);

if ($request->getParam('sAction') && $request->getParam('sAction') === 'doSale') {
                    $request->setControllerName('checkout')->setActionName('finish')->setDispatched(false);
                } else {
                    $request->setControllerName('checkout')->setActionName('confirm')->setDispatched(false);
                }
                break;
            case 'cat':
                $request->setControllerName('listing')->setDispatched(false);
                break;
            case 'supplier':
                $url = $args->getSubject()->Router()->assemble([
                        'controller' => 'listing',
                        'action' => 'manufacturer',
                        'sSupplier' => $request->getParam('sSupplier'),
                ]);
                $args->getSubject()->Response()->setRedirect($url, 301);
                break;
            case 'captcha':
                $request->setModuleName('widgets')->setControllerName('captcha')->setDispatched(false);
                break;
            case 'password':
            case 'login':