maxout

PUPPETEER_SKIP_CHROMIUM_DOWNLOAD=1 bin/build-storefront.sh

maxout

SELECT DISTINCT scru.org_path,scru.path, sad.ordernumber, SUBSTRING_INDEX(scru.org_path,'=',-1) AS aid from s_core_rewrite_urls scru
LEFT JOIN s_articles_details sad ON sad.articleID = SUBSTRING_INDEX(scru.org_path,'=',-1)
WHERE scru.org_path LIKE "sViewport=detail&sArticle=%"
GROUP BY scru.org_path 

maxout

rsync -av --progress . ./stage --exclude stage

maxout

UPDATE property_group_option_translation SET custom_fields= REPLACE (custom_fields  ,'search','replace');

maxout

UPDATE product_translation SET custom_fields = JSON_SET(custom_fields,"$.recipes", NULL);

maxout

INSERT INTO `state_machine_state` (`id`, `technical_name`, `state_machine_id`, `created_at`, `updated_at`) VALUES(0xC4D5A7E42A4741568FD6DDC5819B3A0E, 'clarification_required', 0xCEC9270BA8804885A8C91074E8BA0282, '0000-00-00 00:00:00.000', NULL);
INSERT INTO `state_machine_state_translation` (`language_id`, `state_machine_state_id`, `name`, `custom_fields`, `created_at`, `updated_at`) VALUES(0x2FBB5FE2E29A4D70AA5854CE7CE3E20B, 0xC4D5A7E42A4741568FD6DDC5819B3A0E, 'klärung Notwendig', NULL, '0000-00-00 00:00:00.000', NULL),(0xFA4FC3F8247147538CA4F00B156F4BB5, 0xC4D5A7E42A4741568FD6DDC5819B3A0E, 'Clarification Required', NULL, '0000-00-00 00:00:00.000', NULL);
INSERT INTO `state_machine_transition` (`id`, `action_name`, `state_machine_id`, `from_state_id`, `to_state_id`, `custom_fields`, `created_at`, `updated_at`) VALUES(0x2fbb5fe2e29a4d70aa5864ce7ce3e31b, 'clarification', 0xCEC9270BA8804885A8C91074E8BA0282, 0xBE17F95BFE4E475C97A7BED180FED69C, 0xC4D5A7E42A4741568FD6DDC5819B3A0E, NULL, '0000-00-00 00:00:00.000', 

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';

maxout

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

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

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