maxout

<?php
/**
     * Retrieve Basket Checkout URL
     * Returns the checkout URL for the current basket that will used in the iFrame on shop checkout.
     * @param $basketUrl
     * @param $namespaces
     * @return string
     */
    private function getCheckoutUrl($basketUrl, $namespaces)
    {

maxout

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<basketItem xmlns:xlink="http://www.w3.org/1999/xlink" xmlns="http://api.spreadshirt.net">
	<links>
		<link type="edit" xlink:href="http://shopware-sprd.maxout.de/"/>
		<link type="continueShopping" xlink:href="http://shopware-sprd.maxout.de"/>
	</links>
	<quantity>1</quantity>
	<element type="sprd:product" xlink:href="http://api.spreadshirt.net/api/v1/shops/436258/product/134011849">
		<properties>
			<property key="appearance">4</property>

maxout

select @i := 200000;
update s_articles_details set `ordernumber` = CONCAT('STM-',(select @i := @i + 1));

maxout

SELECT `id`, `ordernumber` FROM s_order WHERE EXISTS ( SELECT `id` FROM s_order dub WHERE s_order.`ordernumber` = dub.`ordernumber` AND s_order.`id` <> dub.`id`) ORDER BY `ordernumber`

maxout

DELETE FROM s_order USING s_order, s_order as Dup WHERE NOT s_order.`id` = Dup.`id` AND s_order.`id` <> Dup.`id` AND s_order.`ordernumber` = Dup.`ordernumber`

maxout

{if !$sArticle.sConfigurator && !$sArticle.variants && !$sArticle.sVariantArticle}

        <a href="{url controller=checkout action=addArticle sAdd=$sArticle.ordernumber sQuantity=1}"
            data-add-article="true"
            data-showModal="false"
            data-addArticleUrl="{url controller=checkout action=ajaxAddArticleCart sAdd=$sArticle.ordernumber  sQuantity=1}"
            data-text="{s name="ListingBoxLinkCart"}In den Warenkorb{/s}"
            title="{s name="ListingBoxLinkCart"}In den Warenkorb{/s}"
            class="product--action action--add tooltip">

maxout

<?php
class Shopware_Plugins_Frontend_GlassesStockVariant_Bootstrap extends Shopware_Components_Plugin_Bootstrap {
    public function getCapabilities() {
        return array(
            'install' => true,
            'update' => true,
            'enable' => true
        );
    }
 

maxout

$criteria = new Criteria();
$criteria->limit(10);
$criteria->addCondition(new CategoryCondition([3]));
$criteria->addSorting(new PriceSorting());

$context = $this->get('shopware_storefront.context_service')->getShopContext();
$service = $this->get('shopware_search.product_number_search');

/**@var $result ProductNumberSearchResult*/
$result = $service->search($criteria, $context);

maxout

SELECT * FROM `product` WHERE product_manufacturer_id not in (SELECT id from product_manufacturer)

maxout

SELECT p.id,p.manufacturer_number ,pt.product_id,JSON_EXTRACT(custom_fields, '$.custom_rim_details_number') 
FROM product_translation pt
INNER JOIN product p ON pt.product_id = p.id 
WHERE JSON_EXTRACT(custom_fields, '$.custom_rim_details_number') IS NOT NULL
AND JSON_EXTRACT(custom_fields, '$.custom_rim_details_number') != 'null';