ConnectTestHelper::getRandomUser() - Code Metrics - Inspection of "CON-4611 Check exported product on removeStreams" - shopware/SwagConnect - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Pull Request — master (#336)

by Stefan

created 2017-07-13 14:39 UTC

ConnectTestHelper::getRandomUser() B

↳ Parent: Project

Complexity

Conditions	7
Paths	24

Size

Total Lines	63
Code Lines	44

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	63
rs	7.2689
c	0
b	0
f	0
cc	7
eloc	44
nc	24
nop	0

How to fix Long Method

<?php

namespace Tests\ShopwarePlugins\Connect;

use Shopware\Connect\Gateway\PDO;
use Shopware\Connect\Struct\Property;
use Shopware\Connect\Struct\Translation;
use ShopwarePlugins\Connect\Components\CategoryResolver\DefaultCategoryResolver;
use ShopwarePlugins\Connect\Components\ConnectExport;
use ShopwarePlugins\Connect\Components\ConnectFactory;
use ShopwarePlugins\Connect\Components\ErrorHandler;
use ShopwarePlugins\Connect\Components\Gateway\ProductTranslationsGateway\PdoProductTranslationsGateway;
use ShopwarePlugins\Connect\Components\ImageImport;
use ShopwarePlugins\Connect\Components\Logger;
use ShopwarePlugins\Connect\Components\Marketplace\MarketplaceGateway;
use ShopwarePlugins\Connect\Components\ProductToShop;
use ShopwarePlugins\Connect\Components\Validator\ProductAttributesValidator\ProductsAttributesValidator;
use Shopware\CustomModels\Connect\Attribute;
use ShopwarePlugins\Connect\Components\Config;
use Shopware\Models\Article\Article;
use Shopware\Models\Article\Detail;
use ShopwarePlugins\Connect\Components\VariantConfigurator;

class ConnectTestHelper extends \Enlight_Components_Test_Plugin_TestCase
{
    const IMAGE_PROVIDER_URL = 'http://www.shopware.de/ShopwareCommunityCenter/img/logo.png';

    public function setUp()
    {
        parent::setUp();

        set_error_handler(null);
        set_exception_handler(null);
    }

    /**
     * @return \ShopwarePlugins\Connect\Components\ConnectFactory
     */
    public function getConnectFactory()
    {
        if (!$this->connectFactory) {
            $this->connectFactory = new ConnectFactory();
        }

        return $this->connectFactory;
    }

    /**
     * @return \Shopware\Connect\SDK
     */
    public function getSDK()
    {
        if (!$this->sdk) {
            $this->sdk = $this->getConnectFactory()->createSdk();
        }

        return $this->sdk;
    }

    /**
     * @return int
     */
    public function getConnectProductArticleId($sourceId, $shopId=3)
    {
        $id = Shopware()->Db()->fetchOne(
            'SELECT article_id FROM s_plugin_connect_items WHERE source_id = ? and shop_id =  ? LIMIT 1',
            array($sourceId, $shopId)
        );
        return $id;
    }

    public function getExternalProductSourceId()
    {
        $sql = 'SELECT source_id FROM s_plugin_connect_items WHERE shop_id IS NOT NULL';
        $sourceId = Shopware()->Db()->fetchOne($sql);

        return $sourceId;
    }

    /**
     * @return \ShopwarePlugins\Connect\Components\Helper
     */
    public function getHelper()
    {
        return Shopware()->Plugins()->Backend()->SwagConnect()->getHelper();
    }


    public function callPrivate($class, $method, $args)
    {
        $method = new \ReflectionMethod(
            $class, $method
        );

        $method->setAccessible(true);

        return call_user_func(array($method, 'invoke', $args));
    }

    /**
     * @return ConnectExport
     */
    public function getConnectExport()
    {
        return new ConnectExport(
            $this->getHelper(),
            $this->getSDK(),
            Shopware()->Models(),
            new ProductsAttributesValidator(),
            new Config(Shopware()->Models()),
            new ErrorHandler(),
            Shopware()->Container()->get('events')
        );
    }


    /**
     * @return ImageImport
     */
    public function getImageImport()
    {
        return new ImageImport(
            Shopware()->Models(),
            $this->getHelper(),
            Shopware()->Container()->get('thumbnail_manager'),
            new Logger(Shopware()->Db())
        );
    }

    public function changeCategoryConnectMappingForCategoryTo($categoryId, $mapping)
    {
        $modelManager = Shopware()->Models();
        $categoryRepository = $modelManager->getRepository('Shopware\Models\Category\Category');
        $category = $categoryRepository->find($categoryId);

        if (!$category) {
            $this->fail('Could not find category with ID ' . $categoryId);
        }

        $attribute = $category->getAttribute() ?: new \Shopware\Models\Attribute\Category();
        $attribute->setConnectImportMapping($mapping);
        $attribute->setConnectExportMapping($mapping);
        $category->setAttribute($attribute);
        $attribute->setCategory($category);

        $modelManager->persist($category);
        $modelManager->persist($attribute);

        $modelManager->flush();
    }

    public static function dispatchRpcCall($service, $command, array $args)
    {
        $sdk = Shopware()->Container()->get('ConnectSDK');
        $refl = new \ReflectionObject($sdk);
        $property = $refl->getProperty('dependencies');
        $property->setAccessible(true);
        $deps = $property->getValue($sdk);
        $serviceRegistry = $deps->getServiceRegistry();
        $callable = $serviceRegistry->getService($service, $command);

        return call_user_func_array(array($callable['provider'], $callable['command']), $args);
    }

    protected function getProduct($withImage = false, $withVariantImages = false)
    {
        $purchasePrice = 6.99;
        $offerValidUntil = time() + 1 * 365 * 24 * 60 * 60; // One year
        $number = rand(1, 999999999);
        $product =  new \Shopware\Connect\Struct\Product(array(
            'shopId' => 3,
            'revisionId' => time(),
            'sourceId' => $number,
            'ean' => $number,
            'sku' => 'sku#' . $number,
            'url' => 'http://shopware.de',
            'title' => 'MassImport #'. $number,
            'shortDescription' => 'Ein Produkt aus shopware Connect',
            'longDescription' => 'Ein Produkt aus shopware Connect',
            'additionalDescription' => 'Ein Produkt aus shopware Connect',
            'vendor' => array(
                'url' => 'http://connect.shopware.de/',
                'name' => 'shopware Connect',
                'logo_url' => self::IMAGE_PROVIDER_URL,
                'page_title' => 'shopware Connect title',
                'description' => 'shopware Connect description'
            ),
            'stream' => 'Awesome products',
            'price' => 9.99,
            'purchasePrice' => $purchasePrice,
            'purchasePriceHash' => hash_hmac(
                'sha256',
                sprintf('%.3F %d', $purchasePrice, $offerValidUntil), '54642546-0001-48ee-b4d0-4f54af66d822'
            ),
            'offerValidUntil' => $offerValidUntil,
            'availability' => 100,
            'categories' => array(
                '/bücher' => 'Bücher',
            ),
            'translations' => array(
                'en' => new Translation(array(
                    'title' => 'MassImport #'. $number . ' EN',
                    'longDescription' => 'Ein Produkt aus shopware Connect EN',
                    'shortDescription' => 'Ein Produkt aus shopware Connect short EN',
                    'additionalDescription' => 'Ein Produkt aus shopware Verbinden Sie mit zusätzlicher Beschreibung EN',
                    'url' => 'http://shopware.de',
                ))
            )
        ));

        if ($withImage) {
            $product->images = array(self::IMAGE_PROVIDER_URL . '?' . $number);
        }

        if ($withVariantImages) {
            $product->variantImages = array(self::IMAGE_PROVIDER_URL . '?' . $number . '-variantImage');
        }

        return $product;
    }

    protected function getProperties()
    {
        return array(
            new Property(array(
                'groupName' => 'Nike',
                'comparable' => false,
                'sortMode' => 1,
                'option' => 'color',
                'filterable' => false,
                'value' => 'red'
            )),
            new Property(array(
                'groupName' => 'Nike',
                'comparable' => false,
                'sortMode' => 1,
                'option' => 'size',
                'filterable' => false,
                'value' => 'XXL',
                'valuePosition' => 1
            )),
            new Property(array(
                'groupName' => 'Nike',
                'comparable' => false,
                'sortMode' => 1,
                'option' => 'size',
                'filterable' => false,
                'value' => '3XL'
            ))
        );
    }

    protected function getProducts($number = 10, $withImage = false, $withVariantImages = false)
    {
        $products = array();
        for($i=0; $i<$number; $i++) {
            $products[] = $this->getProduct($withImage, $withVariantImages);
        }
        return $products;
    }

    protected function getVariants()
    {
        $number = $groupId = rand(1, 999999999);
        $color = array(
            array('de' => 'Weiss-Blau' . $number, 'en' => 'White-Blue'),
            array('de' => 'Weiss-Rot' . $number, 'en' => 'White-Red'),
            array('de' => 'Blau-Rot' . $number, 'en' => 'Blue-Red'),
            array('de' => 'Schwarz-Rot' . $number, 'en' => 'Black-Red'),
        );

        $variants = array();
        $mainVariant = $this->getProduct(true);
        $mainVariantColor = array_pop($color);
        $mainVariant->variant['Farbe'] = $mainVariantColor['de'];
        $mainVariant->groupId = $groupId;
        $variants[] = $mainVariant;

        //add translations
        $mainVariant->translations['en']->variantLabels = array(
            'Farbe' => 'Color',
        );
        $mainVariant->translations['en']->variantValues = array(
            $mainVariantColor['de'] => $mainVariantColor['en'],
        );

        for ($i = 0; $i < 4 - 1; $i++) {
            $variant = $this->getProduct(true);
            $variantSourceId = $mainVariant->sourceId . '-' . $i;
            $variant->title = 'MassImport #' . $variantSourceId;
            $variant->sourceId = $variantSourceId;
            $variant->ean = $variantSourceId;
            $variantColor = array_pop($color);
            $variant->variant['Farbe'] = $variantColor['de'];
            $variant->groupId = $groupId;
            $variant->translations = array(
                'en' => new Translation(array(
                    'title' => 'MassImport #' . $variantSourceId . ' EN',
                    'longDescription' => $mainVariant->longDescription . ' EN',
                    'shortDescription' => $mainVariant->shortDescription . ' EN',
                    'variantLabels' => array(
                        'Farbe' => 'Color',
                    ),
                    'variantValues' => array(
                        $variantColor['de'] => $variantColor['en'],
                    ),
                )),
            );

            $variants[] = $variant;
        }

        return $variants;
    }

    public function getLocalArticle()
    {
        $number = rand(1, 999999999);

        $article = new Article();
        $article->fromArray(array(
            'name' => 'LocalArticle #'. $number,
            'active' => true,
        ));
        $tax = Shopware()->Models()->getRepository('Shopware\Models\Tax\Tax')->find(1);
        $article->setTax($tax);

        $supplier = Shopware()->Models()->getRepository('Shopware\Models\Article\Supplier')->find(1);
        $article->setSupplier($supplier);

        Shopware()->Models()->persist($article);
        Shopware()->Models()->flush();

        $mainDetail = new Detail();
        $mainDetail->fromArray(array(
            'number' => $number,
            'inStock' => 30,
            'article' => $article
        ));
        $article->setMainDetail($mainDetail);
        $detailAtrribute = new \Shopware\Models\Attribute\Article();
        $detailAtrribute->fromArray(array(
            'article' => $article,
            'articleDetail' => $mainDetail,
        ));

        /** @var \Shopware\Models\Customer\Group $customerGroup */
        $customerGroup = Shopware()->Models()->getRepository('Shopware\Models\Customer\Group')->findOneByKey('EK');

        $connectAttribute = new Attribute();
        $connectAttribute->fromArray(array(
            'isMainVariant' => true,
            'article' => $article,
            'articleDetail' => $article->getMainDetail(),
            'sourceId' => $article->getId(),
            'category' => '/bücher',
            'fixedPrice' => false,
            'purchasePriceHash' => '',
            'offerValidUntil' => 0,
            'stream' => '',
        ));

        Shopware()->Models()->persist($mainDetail);
        Shopware()->Models()->persist($detailAtrribute);
        Shopware()->Models()->persist($connectAttribute);
        Shopware()->Models()->flush();

        // set price via plain SQL because shopware throws exception
        // undefined index: key when error handler is disabled
        Shopware()->Db()->executeQuery(
            'INSERT INTO `s_articles_prices`(`pricegroup`, `from`, `to`, `articleID`, `articledetailsID`, `price`, `baseprice`)
          VALUES (?, 1, "beliebig", ?, ?, ?, ?)
          ', [$customerGroup->getKey(), $article->getId(), $mainDetail->getId(), 8.99, 3.99]);

        return $article;
    }

    public function getProductToShop()
    {
        $manager = Shopware()->Models();
        return new ProductToShop(
            $this->getHelper(),
            Shopware()->Models(),
            $this->getImageImport(),
            new Config(Shopware()->Models()),
            new VariantConfigurator(
                $manager,
                new PdoProductTranslationsGateway(Shopware()->Db())
            ),
            new MarketplaceGateway($manager),
            new PdoProductTranslationsGateway(Shopware()->Db()),
            new DefaultCategoryResolver(
                $manager,
                $manager->getRepository('Shopware\CustomModels\Connect\RemoteCategory'),
                $manager->getRepository('Shopware\CustomModels\Connect\ProductToRemoteCategory')
            ),
            new PDO(Shopware()->Db()->getConnection()),
            Shopware()->Container()->get('events')
        );
    }

    protected function insertOrUpdateProducts($number, $withImage, $withVariantImages)
    {
        $commands = array();
        foreach ($this->getProducts($number, $withImage, $withVariantImages) as $product) {
            $commands[$product->sourceId] = new \Shopware\Connect\Struct\Change\ToShop\InsertOrUpdate(array(
                'product' => $product,
                'revision' => time(),
            ));
        }

        $this->dispatchRpcCall('products', 'toShop', array(
            $commands
        ));

        return array_keys($commands);
    }

    protected function getRandomUser()
    {
        $user = Shopware()->Db()->fetchRow("SELECT * FROM s_user WHERE id = 1 LIMIT 1");

        $billing = Shopware()->Db()->fetchRow(
            "SELECT * FROM s_user_billingaddress WHERE userID = :id",
            array(':id' => $user['id'])
        );
        $billing['stateID'] = isset($billing['stateId'])?$billing['stateID']:'1';
        $shipping = Shopware()->Db()->fetchRow(
            "SELECT * FROM s_user_shippingaddress WHERE userID = :id",
            array(':id' => $user['id'])
        );
        $shipping['stateID'] = isset($shipping['stateId'])?$shipping['stateID']:'1';
        $country = Shopware()->Db()->fetchRow(
            "SELECT * FROM s_core_countries WHERE id = :id",
            array(':id' => $billing['countryID'])
        );
        $state = Shopware()->Db()->fetchRow(
            "SELECT * FROM s_core_countries_states WHERE id = :id",
            array(':id' => $billing['stateID'])
        );
        $countryShipping = Shopware()->Db()->fetchRow(
            "SELECT * FROM s_core_countries WHERE id = :id",
            array(':id' => $shipping['countryID'])
        );
        $payment = Shopware()->Db()->fetchRow(
            "SELECT * FROM s_core_paymentmeans WHERE id = :id",
            array(':id' => $user['paymentID'])
        );
        $customerGroup = Shopware()->Db()->fetchRow(
            "SELECT * FROM s_core_customergroups WHERE groupkey = :key",
            array(':key' => $user['customergroup'])
        );

        $taxFree = (bool) ($countryShipping['taxfree']);
        if ($countryShipping['taxfree_ustid']) {
            if ($countryShipping['id'] == $country['id'] && $billing['ustid']) {
                $taxFree = true;
            }
        }

        if ($taxFree) {
            $customerGroup['tax'] = 0;
        }

        Shopware()->Session()->sUserGroupData = $customerGroup;

        return array(
            'user' => $user,
            'billingaddress' => $billing,
            'shippingaddress' => $shipping,
            'customerGroup' => $customerGroup,
            'additional' => array(
                'country' => $country,
                'state'   => $state,
                'user'    => $user,
                'countryShipping' => $countryShipping,
                'payment' => $payment,
                'charge_vat' => !$taxFree
            )
        );
    }
}


1			<?php
2
3			namespace Tests\ShopwarePlugins\Connect;
4
5			use Shopware\Connect\Gateway\PDO;
6			use Shopware\Connect\Struct\Property;
7			use Shopware\Connect\Struct\Translation;
8			use ShopwarePlugins\Connect\Components\CategoryResolver\DefaultCategoryResolver;
9			use ShopwarePlugins\Connect\Components\ConnectExport;
10			use ShopwarePlugins\Connect\Components\ConnectFactory;
11			use ShopwarePlugins\Connect\Components\ErrorHandler;
12			use ShopwarePlugins\Connect\Components\Gateway\ProductTranslationsGateway\PdoProductTranslationsGateway;
13			use ShopwarePlugins\Connect\Components\ImageImport;
14			use ShopwarePlugins\Connect\Components\Logger;
15			use ShopwarePlugins\Connect\Components\Marketplace\MarketplaceGateway;
16			use ShopwarePlugins\Connect\Components\ProductToShop;
17			use ShopwarePlugins\Connect\Components\Validator\ProductAttributesValidator\ProductsAttributesValidator;
18			use Shopware\CustomModels\Connect\Attribute;
19			use ShopwarePlugins\Connect\Components\Config;
20			use Shopware\Models\Article\Article;
21			use Shopware\Models\Article\Detail;
22			use ShopwarePlugins\Connect\Components\VariantConfigurator;
23
24			class ConnectTestHelper extends \Enlight_Components_Test_Plugin_TestCase
25			{
26			const IMAGE_PROVIDER_URL = 'http://www.shopware.de/ShopwareCommunityCenter/img/logo.png';
27
28			public function setUp()
29			{
30			parent::setUp();
31
32			set_error_handler(null);
33			set_exception_handler(null);
34			}
35
36			/**
37			* @return \ShopwarePlugins\Connect\Components\ConnectFactory
38			*/
39			public function getConnectFactory()
40			{
41			if (!$this->connectFactory) {
42			$this->connectFactory = new ConnectFactory();
43			}
44
45			return $this->connectFactory;
46			}
47
48			/**
49			* @return \Shopware\Connect\SDK
50			*/
51			public function getSDK()
52			{
53			if (!$this->sdk) {
54			$this->sdk = $this->getConnectFactory()->createSdk();
55			}
56
57			return $this->sdk;
58			}
59
60			/**
61			* @return int
62			*/
63			public function getConnectProductArticleId($sourceId, $shopId=3)
64			{
65			$id = Shopware()->Db()->fetchOne(
66			'SELECT article_id FROM s_plugin_connect_items WHERE source_id = ? and shop_id = ? LIMIT 1',
67			array($sourceId, $shopId)
68			);
69			return $id;
70			}
71
72			public function getExternalProductSourceId()
73			{
74			$sql = 'SELECT source_id FROM s_plugin_connect_items WHERE shop_id IS NOT NULL';
75			$sourceId = Shopware()->Db()->fetchOne($sql);
76
77			return $sourceId;
78			}
79
80			/**
81			* @return \ShopwarePlugins\Connect\Components\Helper
82			*/
83			public function getHelper()
84			{
85			return Shopware()->Plugins()->Backend()->SwagConnect()->getHelper();
86			}
87
88
89			public function callPrivate($class, $method, $args)
90			{
91			$method = new \ReflectionMethod(
92			$class, $method
93			);
94
95			$method->setAccessible(true);
96
97			return call_user_func(array($method, 'invoke', $args));
98			}
99
100			/**
101			* @return ConnectExport
102			*/
103			public function getConnectExport()
104			{
105			return new ConnectExport(
106			$this->getHelper(),
107			$this->getSDK(),
108			Shopware()->Models(),
109			new ProductsAttributesValidator(),
110			new Config(Shopware()->Models()),
111			new ErrorHandler(),
112			Shopware()->Container()->get('events')
113			);
114			}
115
116
117			/**
118			* @return ImageImport
119			*/
120			public function getImageImport()
121			{
122			return new ImageImport(
123			Shopware()->Models(),
124			$this->getHelper(),
125			Shopware()->Container()->get('thumbnail_manager'),
126			new Logger(Shopware()->Db())
127			);
128			}
129
130			public function changeCategoryConnectMappingForCategoryTo($categoryId, $mapping)
131			{
132			$modelManager = Shopware()->Models();
133			$categoryRepository = $modelManager->getRepository('Shopware\Models\Category\Category');
134			$category = $categoryRepository->find($categoryId);
135
136			if (!$category) {
137			$this->fail('Could not find category with ID ' . $categoryId);
138			}
139
140			$attribute = $category->getAttribute() ?: new \Shopware\Models\Attribute\Category();
141			$attribute->setConnectImportMapping($mapping);
142			$attribute->setConnectExportMapping($mapping);
143			$category->setAttribute($attribute);
144			$attribute->setCategory($category);
145
146			$modelManager->persist($category);
147			$modelManager->persist($attribute);
148
149			$modelManager->flush();
150			}
151
152			public static function dispatchRpcCall($service, $command, array $args)
153			{
154			$sdk = Shopware()->Container()->get('ConnectSDK');
155			$refl = new \ReflectionObject($sdk);
156			$property = $refl->getProperty('dependencies');
157			$property->setAccessible(true);
158			$deps = $property->getValue($sdk);
159			$serviceRegistry = $deps->getServiceRegistry();
160			$callable = $serviceRegistry->getService($service, $command);
161
162			return call_user_func_array(array($callable['provider'], $callable['command']), $args);
163			}
164
165			protected function getProduct($withImage = false, $withVariantImages = false)
166			{
167			$purchasePrice = 6.99;
168			$offerValidUntil = time() + 1 * 365 * 24 * 60 * 60; // One year
169			$number = rand(1, 999999999);
170			$product = new \Shopware\Connect\Struct\Product(array(
171			'shopId' => 3,
172			'revisionId' => time(),
173			'sourceId' => $number,
174			'ean' => $number,
175			'sku' => 'sku#' . $number,
176			'url' => 'http://shopware.de',
177			'title' => 'MassImport #'. $number,
178			'shortDescription' => 'Ein Produkt aus shopware Connect',
179			'longDescription' => 'Ein Produkt aus shopware Connect',
180			'additionalDescription' => 'Ein Produkt aus shopware Connect',
181			'vendor' => array(
182			'url' => 'http://connect.shopware.de/',
183			'name' => 'shopware Connect',
184			'logo_url' => self::IMAGE_PROVIDER_URL,
185			'page_title' => 'shopware Connect title',
186			'description' => 'shopware Connect description'
187			),
188			'stream' => 'Awesome products',
189			'price' => 9.99,
190			'purchasePrice' => $purchasePrice,
191			'purchasePriceHash' => hash_hmac(
192			'sha256',
193			sprintf('%.3F %d', $purchasePrice, $offerValidUntil), '54642546-0001-48ee-b4d0-4f54af66d822'
194			),
195			'offerValidUntil' => $offerValidUntil,
196			'availability' => 100,
197			'categories' => array(
198			'/bücher' => 'Bücher',
199			),
200			'translations' => array(
201			'en' => new Translation(array(
202			'title' => 'MassImport #'. $number . ' EN',
203			'longDescription' => 'Ein Produkt aus shopware Connect EN',
204			'shortDescription' => 'Ein Produkt aus shopware Connect short EN',
205			'additionalDescription' => 'Ein Produkt aus shopware Verbinden Sie mit zusätzlicher Beschreibung EN',
206			'url' => 'http://shopware.de',
207			))
208			)
209			));
210
211			if ($withImage) {
212			$product->images = array(self::IMAGE_PROVIDER_URL . '?' . $number);
213			}
214
215			if ($withVariantImages) {
216			$product->variantImages = array(self::IMAGE_PROVIDER_URL . '?' . $number . '-variantImage');
217			}
218
219			return $product;
220			}
221
222			protected function getProperties()
223			{
224			return array(
225			new Property(array(
226			'groupName' => 'Nike',
227			'comparable' => false,
228			'sortMode' => 1,
229			'option' => 'color',
230			'filterable' => false,
231			'value' => 'red'
232			)),
233			new Property(array(
234			'groupName' => 'Nike',
235			'comparable' => false,
236			'sortMode' => 1,
237			'option' => 'size',
238			'filterable' => false,
239			'value' => 'XXL',
240			'valuePosition' => 1
241			)),
242			new Property(array(
243			'groupName' => 'Nike',
244			'comparable' => false,
245			'sortMode' => 1,
246			'option' => 'size',
247			'filterable' => false,
248			'value' => '3XL'
249			))
250			);
251			}
252
253			protected function getProducts($number = 10, $withImage = false, $withVariantImages = false)
254			{
255			$products = array();
256			for($i=0; $i<$number; $i++) {
257			$products[] = $this->getProduct($withImage, $withVariantImages);
258			}
259			return $products;
260			}
261
262			protected function getVariants()
263			{
264			$number = $groupId = rand(1, 999999999);
265			$color = array(
266			array('de' => 'Weiss-Blau' . $number, 'en' => 'White-Blue'),
267			array('de' => 'Weiss-Rot' . $number, 'en' => 'White-Red'),
268			array('de' => 'Blau-Rot' . $number, 'en' => 'Blue-Red'),
269			array('de' => 'Schwarz-Rot' . $number, 'en' => 'Black-Red'),
270			);
271
272			$variants = array();
273			$mainVariant = $this->getProduct(true);
274			$mainVariantColor = array_pop($color);
275			$mainVariant->variant['Farbe'] = $mainVariantColor['de'];
276			$mainVariant->groupId = $groupId;
277			$variants[] = $mainVariant;
278
279			//add translations
280			$mainVariant->translations['en']->variantLabels = array(
281			'Farbe' => 'Color',
282			);
283			$mainVariant->translations['en']->variantValues = array(
284			$mainVariantColor['de'] => $mainVariantColor['en'],
285			);
286
287			for ($i = 0; $i < 4 - 1; $i++) {
288			$variant = $this->getProduct(true);
289			$variantSourceId = $mainVariant->sourceId . '-' . $i;
290			$variant->title = 'MassImport #' . $variantSourceId;
291			$variant->sourceId = $variantSourceId;
292			$variant->ean = $variantSourceId;
293			$variantColor = array_pop($color);
294			$variant->variant['Farbe'] = $variantColor['de'];
295			$variant->groupId = $groupId;
296			$variant->translations = array(
297			'en' => new Translation(array(
298			'title' => 'MassImport #' . $variantSourceId . ' EN',
299			'longDescription' => $mainVariant->longDescription . ' EN',
300			'shortDescription' => $mainVariant->shortDescription . ' EN',
301			'variantLabels' => array(
302			'Farbe' => 'Color',
303			),
304			'variantValues' => array(
305			$variantColor['de'] => $variantColor['en'],
306			),
307			)),
308			);
309
310			$variants[] = $variant;
311			}
312
313			return $variants;
314			}
315
316			public function getLocalArticle()
317			{
318			$number = rand(1, 999999999);
319
320			$article = new Article();
321			$article->fromArray(array(
322			'name' => 'LocalArticle #'. $number,
323			'active' => true,
324			));
325			$tax = Shopware()->Models()->getRepository('Shopware\Models\Tax\Tax')->find(1);
326			$article->setTax($tax);
327
328			$supplier = Shopware()->Models()->getRepository('Shopware\Models\Article\Supplier')->find(1);
329			$article->setSupplier($supplier);
330
331			Shopware()->Models()->persist($article);
332			Shopware()->Models()->flush();
333
334			$mainDetail = new Detail();
335			$mainDetail->fromArray(array(
336			'number' => $number,
337			'inStock' => 30,
338			'article' => $article
339			));
340			$article->setMainDetail($mainDetail);
341			$detailAtrribute = new \Shopware\Models\Attribute\Article();
342			$detailAtrribute->fromArray(array(
343			'article' => $article,
344			'articleDetail' => $mainDetail,
345			));
346
347			/** @var \Shopware\Models\Customer\Group $customerGroup */
348			$customerGroup = Shopware()->Models()->getRepository('Shopware\Models\Customer\Group')->findOneByKey('EK');
349
350			$connectAttribute = new Attribute();
351			$connectAttribute->fromArray(array(
352			'isMainVariant' => true,
353			'article' => $article,
354			'articleDetail' => $article->getMainDetail(),
355			'sourceId' => $article->getId(),
356			'category' => '/bücher',
357			'fixedPrice' => false,
358			'purchasePriceHash' => '',
359			'offerValidUntil' => 0,
360			'stream' => '',
361			));
362
363			Shopware()->Models()->persist($mainDetail);
364			Shopware()->Models()->persist($detailAtrribute);
365			Shopware()->Models()->persist($connectAttribute);
366			Shopware()->Models()->flush();
367
368			// set price via plain SQL because shopware throws exception
369			// undefined index: key when error handler is disabled
370			Shopware()->Db()->executeQuery(
371			'INSERT INTO `s_articles_prices`(`pricegroup`, `from`, `to`, `articleID`, `articledetailsID`, `price`, `baseprice`)
372			VALUES (?, 1, "beliebig", ?, ?, ?, ?)
373			', [$customerGroup->getKey(), $article->getId(), $mainDetail->getId(), 8.99, 3.99]);
374
375			return $article;
376			}
377
378			public function getProductToShop()
379			{
380			$manager = Shopware()->Models();
381			return new ProductToShop(
382			$this->getHelper(),
383			Shopware()->Models(),
384			$this->getImageImport(),
385			new Config(Shopware()->Models()),
386			new VariantConfigurator(
387			$manager,
388			new PdoProductTranslationsGateway(Shopware()->Db())
389			),
390			new MarketplaceGateway($manager),
391			new PdoProductTranslationsGateway(Shopware()->Db()),
392			new DefaultCategoryResolver(
393			$manager,
394			$manager->getRepository('Shopware\CustomModels\Connect\RemoteCategory'),
395			$manager->getRepository('Shopware\CustomModels\Connect\ProductToRemoteCategory')
396			),
397			new PDO(Shopware()->Db()->getConnection()),
398			Shopware()->Container()->get('events')
399			);
400			}
401
402			protected function insertOrUpdateProducts($number, $withImage, $withVariantImages)
403			{
404			$commands = array();
405			foreach ($this->getProducts($number, $withImage, $withVariantImages) as $product) {
406			$commands[$product->sourceId] = new \Shopware\Connect\Struct\Change\ToShop\InsertOrUpdate(array(
407			'product' => $product,
408			'revision' => time(),
409			));
410			}
411
412			$this->dispatchRpcCall('products', 'toShop', array(
413			$commands
414			));
415
416			return array_keys($commands);
417			}
418
419			protected function getRandomUser()
420			{
421			$user = Shopware()->Db()->fetchRow("SELECT * FROM s_user WHERE id = 1 LIMIT 1");
422
423			$billing = Shopware()->Db()->fetchRow(
424			"SELECT * FROM s_user_billingaddress WHERE userID = :id",
425			array(':id' => $user['id'])
426			);
427			$billing['stateID'] = isset($billing['stateId'])?$billing['stateID']:'1';
428			$shipping = Shopware()->Db()->fetchRow(
429			"SELECT * FROM s_user_shippingaddress WHERE userID = :id",
430			array(':id' => $user['id'])
431			);
432			$shipping['stateID'] = isset($shipping['stateId'])?$shipping['stateID']:'1';
433			$country = Shopware()->Db()->fetchRow(
434			"SELECT * FROM s_core_countries WHERE id = :id",
435			array(':id' => $billing['countryID'])
436			);
437			$state = Shopware()->Db()->fetchRow(
438			"SELECT * FROM s_core_countries_states WHERE id = :id",
439			array(':id' => $billing['stateID'])
440			);
441			$countryShipping = Shopware()->Db()->fetchRow(
442			"SELECT * FROM s_core_countries WHERE id = :id",
443			array(':id' => $shipping['countryID'])
444			);
445			$payment = Shopware()->Db()->fetchRow(
446			"SELECT * FROM s_core_paymentmeans WHERE id = :id",
447			array(':id' => $user['paymentID'])
448			);
449			$customerGroup = Shopware()->Db()->fetchRow(
450			"SELECT * FROM s_core_customergroups WHERE groupkey = :key",
451			array(':key' => $user['customergroup'])
452			);
453
454			$taxFree = (bool) ($countryShipping['taxfree']);
455			if ($countryShipping['taxfree_ustid']) {
456			if ($countryShipping['id'] == $country['id'] && $billing['ustid']) {
457			$taxFree = true;
458			}
459			}
460
461			if ($taxFree) {
462			$customerGroup['tax'] = 0;
463			}
464
465			Shopware()->Session()->sUserGroupData = $customerGroup;
466
467			return array(
468			'user' => $user,
469			'billingaddress' => $billing,
470			'shippingaddress' => $shipping,
471			'customerGroup' => $customerGroup,
472			'additional' => array(
473			'country' => $country,
474			'state' => $state,
475			'user' => $user,
476			'countryShipping' => $countryShipping,
477			'payment' => $payment,
478			'charge_vat' => !$taxFree
479			)
480			);
481			}
482			}
483

shopware / SwagConnect

Pull Request — master (#336)

ConnectTestHelper::getRandomUser() B

Complexity

Size

Duplication

Importance

How to fix Long Method

Long Method

Duplication Side-by-Side

Filter issues like