/**
* {@inheritdoc}
*/
public function install(array $fixtures)
{
$this->configWriter->save('sales/msrp/enabled', 1);
foreach ($fixtures as $fileName) {
$fileName = $this->fixtureManager->getFixture($fileName);
if (!file_exists($fileName)) {
continue;
}
$rows = $this->csvReader->getData($fileName);
$header = array_shift($rows);
foreach ($rows as $row) {
$data = [];
foreach ($row as $key => $value) {
$data[$header[$key]] = $value;
}
$row = $data;
$productId = $this->getProductIdBySku($row['sku']);
if (!$productId) {
continue;
}
/** @var \Magento\Catalog\Model\Product $product */
$product = $this->productCollection->getItemById($productId);
$product->setMsrpDisplayActualPriceType(Type::TYPE_ON_GESTURE);
if (!empty($row['msrp'])) {
$price = $row['msrp'];
} else {
$price = $product->getPrice() * 1.1;
}
$product->setMsrp($price);
$product->save();
}
}
}
public function testGetCollection()
{
$this->collectionMock->expects($this->once())->method('addAttributeToFilter');
$this->productLinkRepositoryMock->expects($this->once())->method('getList')->willReturn([]);
$this->requestMock->expects($this->exactly(2))->method('getParam')->willReturn(1);
$this->assertInstanceOf(Collection::class, $this->getModel()->getCollection());
}
/**
* Set up
*/
protected function setUp()
{
$this->objectManagerHelper = new ObjectManagerHelper($this);
$this->rowCustomizerMock = $this->objectManagerHelper->getObject('\\Magento\\BundleImportExport\\Model\\Export\\RowCustomizer');
$this->productResourceCollection = $this->getMock('\\Magento\\Catalog\\Model\\ResourceModel\\Product\\Collection', ['addAttributeToFilter', 'getIterator'], [], '', false);
$this->product = $this->getMock('\\Magento\\Catalog\\Model\\Product', ['getId', 'getPriceType', 'getSkuType', 'getPriceView', 'getWeightType', 'getTypeInstance', 'getOptionsCollection', 'getSelectionsCollection'], [], '', false);
$this->product->expects($this->any())->method('getId')->willReturn(1);
$this->product->expects($this->any())->method('getPriceType')->willReturn(1);
$this->product->expects($this->any())->method('getSkuType')->willReturn(1);
$this->product->expects($this->any())->method('getPriceView')->willReturn(1);
$this->product->expects($this->any())->method('getWeightType')->willReturn(1);
$this->product->expects($this->any())->method('getTypeInstance')->willReturnSelf();
$this->optionsCollection = $this->getMock('\\Magento\\Bundle\\Model\\ResourceModel\\Option\\Collection', ['setOrder', 'getIterator'], [], '', false);
$this->product->expects($this->any())->method('getOptionsCollection')->willReturn($this->optionsCollection);
$this->optionsCollection->expects($this->any())->method('setOrder')->willReturnSelf();
$this->option = $this->getMock('\\Magento\\Bundle\\Model\\Option', ['getId', 'getTitle', 'getType', 'getRequired'], [], '', false);
$this->option->expects($this->any())->method('getId')->willReturn(1);
$this->option->expects($this->any())->method('getTitle')->willReturn('title');
$this->option->expects($this->any())->method('getType')->willReturn(1);
$this->option->expects($this->any())->method('getRequired')->willReturn(1);
$this->optionsCollection->expects($this->any())->method('getIterator')->will($this->returnValue(new \ArrayIterator([$this->option])));
$this->selection = $this->getMock('\\Magento\\Catalog\\Model\\Product', ['getSku', 'getSelectionPriceValue', 'getIsDefault', 'getSelectionQty', 'getSelectionPriceType'], [], '', false);
$this->selection->expects($this->any())->method('getSku')->willReturn(1);
$this->selection->expects($this->any())->method('getSelectionPriceValue')->willReturn(1);
$this->selection->expects($this->any())->method('getSelectionQty')->willReturn(1);
$this->selection->expects($this->any())->method('getSelectionPriceType')->willReturn(1);
$this->selectionsCollection = $this->getMock('\\Magento\\Bundle\\Model\\ResourceModel\\Selection\\Collection', ['getIterator', 'addAttributeToSort'], [], '', false);
$this->selectionsCollection->expects($this->any())->method('getIterator')->will($this->returnValue(new \ArrayIterator([$this->selection])));
$this->selectionsCollection->expects($this->any())->method('addAttributeToSort')->willReturnSelf();
$this->product->expects($this->any())->method('getSelectionsCollection')->willReturn($this->selectionsCollection);
$this->productResourceCollection->expects($this->any())->method('addAttributeToFilter')->willReturnSelf();
$this->productResourceCollection->expects($this->any())->method('getIterator')->will($this->returnValue(new \ArrayIterator([$this->product])));
}
/**
* Make collection not to load products that are in specified quote
*
* @param \Magento\Catalog\Model\ResourceModel\Product\Collection $collection
* @param int $quoteId
* @return $this
*/
public function addExcludeProductFilter($collection, $quoteId)
{
$connection = $this->getConnection();
$exclusionSelect = $connection->select()->from($this->getTable('quote_item'), ['product_id'])->where('quote_id = ?', $quoteId);
$condition = $connection->prepareSqlCondition('e.entity_id', ['nin' => $exclusionSelect]);
$collection->getSelect()->where($condition);
return $this;
}
/**
* Collect validated attributes for Product Collection
*
* @param \Magento\Catalog\Model\ResourceModel\Product\Collection $productCollection
* @return $this
*/
public function collectValidatedAttributes($productCollection)
{
$alias = array_keys($productCollection->getSelect()->getPart('from'))[0];
foreach ($this->getConditions() as $condition) {
$condition->setData('attribute', $alias . '.' . $condition->getData('attribute'));
$condition->addToCollection($productCollection);
}
return $this;
}
/**
* {@inheritDoc}
*/
protected function addFilterByAttributes(ProductCollection $productCollection, array $attributes)
{
foreach ($attributes as $code => $option) {
if (!is_array($option)) {
$option = [$option];
}
$productCollection->addAttributeToFilter($code, ['in' => $option]);
}
}
/**
* Execute per test cleanup
*/
public function tearDown()
{
/** @var \Magento\Framework\Registry $registry */
$registry = \Magento\TestFramework\Helper\Bootstrap::getObjectManager()->get('Magento\\Framework\\Registry');
$registry->unregister('isSecureArea');
$registry->register('isSecureArea', true);
$this->productCollection->addFieldToFilter('entity_id', ['in' => [10, 11, 12]])->delete();
unset($this->productCollection);
$registry->unregister('isSecureArea');
$registry->register('isSecureArea', false);
}
public function testGetData()
{
$items = ['testProduct1', 'testProduct2'];
$expectedData = ['totalRecords' => count($items), 'items' => $items];
$this->configMock->expects($this->once())->method('getComposableTypes')->willReturn([self::ALLOWED_TYPE]);
$this->collectionMock->expects($this->once())->method('isLoaded')->willReturn(false);
$this->collectionMock->expects($this->once())->method('addAttributeToFilter')->with('type_id', [self::ALLOWED_TYPE]);
$this->collectionMock->expects($this->once())->method('toArray')->willReturn($items);
$this->collectionMock->expects($this->once())->method('getSize')->willReturn(count($items));
$this->assertEquals($expectedData, $this->getModel()->getData());
}
public function testAddProductCategoriesFilter()
{
$condition = ['in' => [1, 2]];
$values = [1, 2];
$conditionType = 'nin';
$preparedSql = "category_id IN(1,2)";
$tableName = "catalog_category_product";
$this->connectionMock->expects($this->any())->method('getId')->willReturn(1);
$this->connectionMock->expects($this->exactly(2))->method('prepareSqlCondition')->withConsecutive(['cat.category_id', $condition], ['e.entity_id', [$conditionType => $this->selectMock]])->willReturnOnConsecutiveCalls($preparedSql, 'e.entity_id IN (1,2)');
$this->selectMock->expects($this->once())->method('from')->with(['cat' => $tableName], 'cat.product_id')->willReturnSelf();
$this->selectMock->expects($this->exactly(2))->method('where')->withConsecutive([$preparedSql], ['e.entity_id IN (1,2)'])->willReturnSelf();
$this->collection->addCategoriesFilter([$conditionType => $values]);
}
/**
* Replace WHERE-filtering by HAVING-filtering.
*
* @param \Magento\CatalogInventory\Ui\DataProvider\Product\AddQuantityFilterToCollection $subject
* @param \Closure $proceed
* @param \Magento\Catalog\Model\ResourceModel\Product\Collection $collection
* @param $field
* @param null $condition
*/
public function aroundAddFilter(\Magento\CatalogInventory\Ui\DataProvider\Product\AddQuantityFilterToCollection $subject, \Closure $proceed, \Magento\Catalog\Model\ResourceModel\Product\Collection $collection, $field, $condition = null)
{
/* skip identical conditions () */
$regKey = print_r($condition, true);
if (!isset($this->_regCond[$regKey])) {
$conn = $collection->getConnection();
$select = $collection->getSelect();
$equation = $this->_repoModifierProductGFrid->getEquationQty();
$prepared = $conn->prepareSqlCondition($equation, $condition);
$select->having($prepared);
$this->_regCond[$regKey] = true;
}
return;
}
/**
* Replace default stock id in the where clause by stock id corresponded with store id.
*
* @param \Magento\CatalogInventory\Model\ResourceModel\Stock\Status $subject
* @param \Magento\Catalog\Model\ResourceModel\Product\Collection $result
* @return \Magento\Catalog\Model\ResourceModel\Product\Collection
*/
public function afterAddStockDataToCollection(\Magento\CatalogInventory\Model\ResourceModel\Stock\Status $subject, \Magento\Catalog\Model\ResourceModel\Product\Collection $result)
{
/** @var \Magento\Framework\Db\Select $select */
$select = $result->getSelect();
$from = $select->getPart('from');
$join = $from['stock_status_index'];
$cond = $join['joinCondition'];
$stockId = $this->_manStock->getCurrentStockId();
$fixed = str_replace('.stock_id = 1', '.stock_id = ' . $stockId, $cond);
$join['joinCondition'] = $fixed;
$from['stock_status_index'] = $join;
$select->setPart('from', $from);
return $result;
}
/**
* @return $this
*/
protected function _prepareData()
{
$product = $this->_coreRegistry->registry('product');
/* @var $product \Magento\Catalog\Model\Product */
$this->_itemCollection = $product->getRelatedProductCollection()->addAttributeToSelect('required_options')->setPositionOrder()->addStoreFilter();
if ($this->moduleManager->isEnabled('Magento_Checkout')) {
$this->_addProductAttributesAndPrices($this->_itemCollection);
}
$this->_itemCollection->setVisibility($this->_catalogProductVisibility->getVisibleInCatalogIds());
$this->_itemCollection->load();
foreach ($this->_itemCollection as $product) {
$product->setDoNotUseCategoryId(true);
}
return $this;
}
public function testFindAttributeIdsByProductIds()
{
$productIds = [1, 2, 3];
$attributeSetIds = [3, 4, 6];
$select = $this->getMockBuilder(Select::class)->disableOriginalConstructor()->getMock();
$select->expects($this->once())->method('reset')->with(Select::COLUMNS)->willReturnSelf();
$select->expects($this->once())->method('columns')->with(ProductInterface::ATTRIBUTE_SET_ID)->willReturnSelf();
$select->expects($this->once())->method('where')->with('entity_id IN (?)', $productIds)->willReturnSelf();
$select->expects($this->once())->method('group')->with(ProductInterface::ATTRIBUTE_SET_ID)->willReturnSelf();
$connection = $this->getMock(AdapterInterface::class);
$connection->expects($this->once())->method('fetchCol')->with($select)->willReturn($attributeSetIds);
$this->productCollection->expects($this->once())->method('getSelect')->willReturn($select);
$this->productCollection->expects($this->once())->method('getConnection')->willReturn($connection);
$this->assertEquals($attributeSetIds, $this->attributeSetFinder->findAttributeSetIdsByProductIds($productIds));
}
/**
* Premare block data
* @return $this
*/
protected function _prepareCollection()
{
$post = $this->_coreRegistry->registry('current_blog_post');
$this->_itemCollection = $this->_productCollectionFactory->create()->addAttributeToSelect('required_options')->addStoreFilter()->addAttributeToFilter('entity_id', array('in' => $post->getRelatedProductIds() ?: array(0)));
if ($this->_moduleManager->isEnabled('Magento_Checkout')) {
$this->_addProductAttributesAndPrices($this->_itemCollection);
}
$this->_itemCollection->setVisibility($this->_catalogProductVisibility->getVisibleInCatalogIds());
$this->_itemCollection->setPageSize((int) $this->_scopeConfig->getValue('mfblog/post_view/related_products/number_of_products', \Magento\Store\Model\ScopeInterface::SCOPE_STORE));
$this->_itemCollection->load();
foreach ($this->_itemCollection as $product) {
$product->setDoNotUseCategoryId(true);
}
return $this;
}
/**
* Premare block data
* @return $this
*/
protected function _prepareCollection()
{
$post = $this->getPost();
$this->_itemCollection = $post->getRelatedProducts()->addAttributeToSelect('required_options');
if ($this->_moduleManager->isEnabled('Magento_Checkout')) {
$this->_addProductAttributesAndPrices($this->_itemCollection);
}
$this->_itemCollection->setVisibility($this->_catalogProductVisibility->getVisibleInCatalogIds());
$this->_itemCollection->setPageSize((int) $this->_scopeConfig->getValue('mfblog/post_view/related_products/number_of_products', \Magento\Store\Model\ScopeInterface::SCOPE_STORE));
$this->_itemCollection->getSelect()->order('rl.position', 'ASC');
$this->_itemCollection->load();
foreach ($this->_itemCollection as $product) {
$product->setDoNotUseCategoryId(true);
}
return $this;
}
/**
* Add attribute to sort
*
* @param string $attribute
* @param string $dir
* @return $this|\Magento\Catalog\Model\ResourceModel\Product\Collection
*/
public function addAttributeToSort($attribute, $dir = self::SORT_ORDER_ASC)
{
if (in_array($attribute, ['review_cnt', 'last_created', 'avg_rating', 'avg_rating_approved'])) {
$this->getSelect()->order($attribute . ' ' . $dir);
return $this;
}
return parent::addAttributeToSort($attribute, $dir);
}
protected function addfilterByParent()
{
$this->productCollectionMock->method('getTable')->with('catalog_product_relation')->willReturn('catalog_product_relation');
$zendDbSelectMock = $this->getMock('Magento\\Framework\\DB\\Select', [], [], '', false);
$this->productCollectionMock->method('getSelect')->willReturn($zendDbSelectMock);
$zendDbSelectMock->method('join')->willReturn($zendDbSelectMock);
$zendDbSelectMock->method('where')->willReturn($zendDbSelectMock);
}
protected function _initConfigurableData()
{
$productIds = [1, 2, 3];
$productAttributesOptions = [[['pricing_is_percent' => true, 'sku' => '_sku_', 'attribute_code' => 'code_of_attribute', 'option_title' => 'Option Title', 'pricing_value' => 112345, 'super_attribute_label' => 'Super attribute label'], ['pricing_is_percent' => false, 'sku' => '_sku_', 'attribute_code' => 'code_of_attribute', 'option_title' => 'Option Title', 'pricing_value' => 212345, 'super_attribute_label' => ''], ['pricing_is_percent' => false, 'sku' => '_sku_2', 'attribute_code' => 'code_of_attribute_2', 'option_title' => 'Option Title 2', 'pricing_value' => 312345, 'super_attribute_label' => 'Super attribute label 2']]];
$expectedConfigurableData = $this->getExpectedConfigurableData();
$productMock = $this->getMock('Magento\\Catalog\\Model\\Product', ['getId', 'getTypeInstance', '__wakeup'], [], '', false);
$productMock->expects($this->any())->method('getId')->will($this->returnValue($this->initiatedProductId));
$typeInstanceMock = $this->getMock('Magento\\ConfigurableProduct\\Model\\Product\\Type\\Configurable', [], [], '', false);
$typeInstanceMock->expects($this->any())->method('getConfigurableOptions')->will($this->returnValue($productAttributesOptions));
$productMock->expects($this->any())->method('getTypeInstance')->will($this->returnValue($typeInstanceMock));
$this->_collectionMock->expects($this->at(0))->method('addAttributeToFilter')->with('entity_id', ['in' => $productIds])->will($this->returnSelf());
$this->_collectionMock->expects($this->at(1))->method('addAttributeToFilter')->with('type_id', ['eq' => \Magento\ConfigurableProduct\Model\Product\Type\Configurable::TYPE_CODE])->will($this->returnSelf());
$this->_collectionMock->expects($this->at(2))->method('fetchItem')->will($this->returnValue($productMock));
$this->_collectionMock->expects($this->at(3))->method('fetchItem')->will($this->returnValue(false));
$this->_model->prepareData($this->_collectionMock, $productIds);
$configurableData = $this->getPropertyValue($this->_model, 'configurableData');
$this->assertEquals($expectedConfigurableData, $configurableData);
}
/**
* @return $this
*/
protected function _prepareData()
{
$product = $this->_coreRegistry->registry('product');
/* @var $product \Magento\Catalog\Model\Product */
$this->_itemCollection = $product->getUpSellProductCollection()->setPositionOrder()->addStoreFilter();
if ($this->moduleManager->isEnabled('Magento_Checkout')) {
$this->_addProductAttributesAndPrices($this->_itemCollection);
}
$this->_itemCollection->setVisibility($this->_catalogProductVisibility->getVisibleInCatalogIds());
$this->_itemCollection->load();
/**
* Updating collection with desired items
*/
$this->_eventManager->dispatch('catalog_product_upsell', ['product' => $product, 'collection' => $this->_itemCollection, 'limit' => null]);
foreach ($this->_itemCollection as $product) {
$product->setDoNotUseCategoryId(true);
}
return $this;
}
/**
* @magentoDataFixture Magento/Catalog/_files/products.php
* @magentoAppIsolation enabled
*/
public function testAddPriceDataOnSave()
{
$this->processor->getIndexer()->setScheduled(false);
$this->assertFalse($this->processor->getIndexer()->isScheduled());
$productRepository = \Magento\TestFramework\Helper\Bootstrap::getObjectManager()->create('Magento\\Catalog\\Api\\ProductRepositoryInterface');
/** @var \Magento\Catalog\Api\Data\ProductInterface $product */
$product = $productRepository->get('simple');
$this->assertNotEquals(15, $product->getPrice());
$product->setPrice(15);
$productRepository->save($product);
$this->collection->addPriceData(0, 1);
$this->collection->load();
/** @var \Magento\Catalog\Api\Data\ProductInterface[] $product */
$items = $this->collection->getItems();
/** @var \Magento\Catalog\Api\Data\ProductInterface $product */
$product = reset($items);
$this->assertCount(2, $items);
$this->assertEquals(15, $product->getPrice());
}
/**
* Add filtering
*
* @param string $field
* @param null|string $condition
* @return $this
*/
public function addFieldToFilter($field, $condition = null)
{
if ($field == 'link_title') {
$conditionSql = $this->_getConditionSql('l.title', $condition);
$this->getSelect()->where($conditionSql);
} else {
parent::addFieldToFilter($field, $condition);
}
return $this;
}
/**
* @SuppressWarnings(PHPMD.ExcessiveMethodLength)
*/
protected function setUp()
{
parent::setUp();
$this->setCollectionFactory = $this->getMock('Magento\\Eav\\Model\\ResourceModel\\Entity\\Attribute\\Set\\CollectionFactory', ['create'], [], '', false);
$this->setCollection = $this->getMock('Magento\\Eav\\Model\\ResourceModel\\Entity\\Attribute\\Set\\Collection', ['setEntityTypeFilter'], [], '', false);
$this->setCollectionFactory->expects($this->any())->method('create')->will($this->returnValue($this->setCollection));
$item = new \Magento\Framework\DataObject(['id' => 1, 'attribute_set_name' => 'Default', '_attribute_set' => 'Default']);
$this->setCollection->expects($this->any())->method('setEntityTypeFilter')->will($this->returnValue([$item]));
$this->attrCollectionFactory = $this->getMock('Magento\\Catalog\\Model\\ResourceModel\\Product\\Attribute\\CollectionFactory', ['create'], [], '', false);
$this->attrCollection = $this->getMock('\\Magento\\Catalog\\Model\\ResourceModel\\Product\\Attribute\\Collection', ['setAttributeSetFilter'], [], '', false);
$superAttributes = [];
foreach ($this->_getSuperAttributes() as $superAttribute) {
$item = $this->getMock('\\Magento\\Eav\\Model\\Entity\\Attribute\\AbstractAttribute', ['isStatic'], $superAttribute, '', false);
$item->setData($superAttribute);
$item->method('isStatic')->will($this->returnValue(false));
$superAttributes[] = $item;
}
$this->attrCollectionFactory->expects($this->any())->method('create')->will($this->returnValue($this->attrCollection));
$this->attrCollection->expects($this->any())->method('setAttributeSetFilter')->will($this->returnValue($superAttributes));
$this->_entityModel = $this->getMock('Magento\\CatalogImportExport\\Model\\Import\\Product', ['getNewSku', 'getOldSku', 'getNextBunch', 'isRowAllowedToImport', 'getConnection', 'getAttrSetIdToName', 'getErrorAggregator', 'getAttributeOptions'], [], '', false);
$this->_entityModel->method('getErrorAggregator')->willReturn($this->getErrorAggregatorObject());
$this->params = [0 => $this->_entityModel, 1 => 'configurable'];
$this->_connection = $this->getMock('Magento\\Framework\\DB\\Adapter\\Pdo\\Mysql', ['select', 'fetchAll', 'fetchPairs', 'joinLeft', 'insertOnDuplicate', 'delete', 'quoteInto'], [], '', false);
$this->select = $this->getMock('Magento\\Framework\\DB\\Select', ['from', 'where', 'joinLeft', 'getConnection'], [], '', false);
$this->select->expects($this->any())->method('from')->will($this->returnSelf());
$this->select->expects($this->any())->method('where')->will($this->returnSelf());
$this->select->expects($this->any())->method('joinLeft')->will($this->returnSelf());
$this->_connection->expects($this->any())->method('select')->will($this->returnValue($this->select));
$connectionMock = $this->getMock('Magento\\Framework\\DB\\Adapter\\Pdo\\Mysql', [], [], '', false);
$connectionMock->expects($this->any())->method('quoteInto')->will($this->returnValue('query'));
$this->select->expects($this->any())->method('getConnection')->willReturn($connectionMock);
$this->_connection->expects($this->any())->method('insertOnDuplicate')->willReturnSelf();
$this->_connection->expects($this->any())->method('delete')->willReturnSelf();
$this->_connection->expects($this->any())->method('quoteInto')->willReturn('');
$this->_connection->expects($this->any())->method('fetchAll')->will($this->returnValue([]));
$this->resource = $this->getMock('\\Magento\\Framework\\App\\ResourceConnection', ['getConnection', 'getTableName'], [], '', false);
$this->resource->expects($this->any())->method('getConnection')->will($this->returnValue($this->_connection));
$this->resource->expects($this->any())->method('getTableName')->will($this->returnValue('tableName'));
$this->_entityModel->expects($this->any())->method('getConnection')->will($this->returnValue($this->_connection));
$this->productCollectionFactory = $this->getMock('\\Magento\\Catalog\\Model\\ResourceModel\\Product\\CollectionFactory', ['create'], [], '', false);
$this->productCollection = $this->getMock('\\Magento\\Catalog\\Model\\ResourceModel\\Product\\Collection', ['addFieldToFilter', 'addAttributeToSelect'], [], '', false);
$products = [];
$testProducts = [['id' => 1, 'attribute_set_id' => 4, 'testattr2' => 1, 'testattr3' => 1], ['id' => 2, 'attribute_set_id' => 4, 'testattr2' => 1, 'testattr3' => 1], ['id' => 20, 'attribute_set_id' => 4, 'testattr2' => 1, 'testattr3' => 1]];
foreach ($testProducts as $product) {
$item = $this->getMock('\\Magento\\Framework\\DataObject', ['getAttributeSetId'], [], '', false);
$item->setData($product);
$item->expects($this->any())->method('getAttributeSetId')->willReturn(4);
$products[] = $item;
}
$this->productCollectionFactory->expects($this->any())->method('create')->will($this->returnValue($this->productCollection));
$this->productCollection->expects($this->any())->method('addFieldToFilter')->will($this->returnValue($this->productCollection));
$this->productCollection->expects($this->any())->method('addAttributeToSelect')->will($this->returnValue($products));
$this->_entityModel->expects($this->any())->method('getAttributeOptions')->will($this->returnValue(['attr2val1' => '1', 'attr2val2' => '2', 'attr2val3' => '3', 'testattr3v1' => '4', 'testattr30v1' => '4', 'testattr3v2' => '5', 'testattr3v3' => '6']));
$this->configurable = $this->objectManagerHelper->getObject('Magento\\ConfigurableImportExport\\Model\\Import\\Product\\Type\\Configurable', ['attrSetColFac' => $this->setCollectionFactory, 'prodAttrColFac' => $this->attrCollectionFactory, 'params' => $this->params, 'resource' => $this->resource, 'productColFac' => $this->productCollectionFactory]);
}
/**
* Separate query for product and order data
*
* @param array $productIds
* @return array
* @throws \Magento\Framework\Exception\LocalizedException
*/
protected function getProductData(array $productIds)
{
$productConnection = $this->productResource->getConnection();
$productAttrName = $this->productResource->getAttribute('name');
$productAttrNameId = (int) $productAttrName->getAttributeId();
$productAttrPrice = $this->productResource->getAttribute('price');
$productAttrPriceId = (int) $productAttrPrice->getAttributeId();
$select = clone $this->productResource->getSelect();
$select->reset();
$select->from(['main_table' => $this->getTable('catalog_product_entity')])->useStraightJoin(true)->joinInner(['product_name' => $productAttrName->getBackend()->getTable()], 'product_name.entity_id = main_table.entity_id' . ' AND product_name.attribute_id = ' . $productAttrNameId . ' AND product_name.store_id = ' . \Magento\Store\Model\Store::DEFAULT_STORE_ID, ['name' => 'product_name.value'])->joinInner(['product_price' => $productAttrPrice->getBackend()->getTable()], "product_price.entity_id = main_table.entity_id AND product_price.attribute_id = {$productAttrPriceId}", ['price' => new \Zend_Db_Expr('product_price.value')])->where('main_table.entity_id IN (?)', $productIds);
$productData = $productConnection->fetchAssoc($select);
return $productData;
}
/**
* Retrieve product ID by sku
*
* @param string $sku
* @return int|null
*/
protected function getProductIdBySku($sku)
{
if (empty($this->productIds)) {
$this->productCollection->addAttributeToSelect('sku');
foreach ($this->productCollection as $product) {
$this->productIds[$product->getSku()] = $product->getId();
}
}
if (isset($this->productIds[$sku])) {
return $this->productIds[$sku];
}
return null;
}
public function testGetData()
{
$items = ['testProduct1', 'testProduct2'];
$expectedData = ['totalRecords' => count($items), 'items' => $items];
$this->dataHelperMock->expects($this->once())->method('getAllowedSelectionTypes')->willReturn([self::ALLOWED_TYPE]);
$this->collectionMock->expects($this->once())->method('isLoaded')->willReturn(false);
$this->collectionMock->expects($this->once())->method('addAttributeToFilter')->with('type_id', [self::ALLOWED_TYPE]);
$this->collectionMock->expects($this->once())->method('addFilterByRequiredOptions');
$this->collectionMock->expects($this->once())->method('addStoreFilter')->with(\Magento\Store\Model\Store::DEFAULT_STORE_ID);
$this->collectionMock->expects($this->once())->method('toArray')->willReturn($items);
$this->collectionMock->expects($this->once())->method('getSize')->willReturn(count($items));
$this->assertEquals($expectedData, $this->getModel()->getData());
}
/**
* @return array|\Magento\Framework\Data\Collection\AbstractDb
*/
public function getItems()
{
$order = $this->getOrder();
if (!$order) {
return [];
}
$items = $order->getAllVisibleItems();
$productIds = [];
//get the product ids for the collection
foreach ($items as $item) {
$productIds[] = $item->getProductId();
}
$items = $this->productCollection->addAttributeToSelect('*')->addFieldToFilter('entity_id', ['in' => $productIds]);
return $items;
}
/**
* Prepare configurable data for export
*
* @param \Magento\Catalog\Model\ResourceModel\Product\Collection $collection
* @param int $productIds
* @return void
*/
public function prepareData($collection, $productIds)
{
$collection->addAttributeToFilter('entity_id', ['in' => $productIds])->addAttributeToFilter('type_id', ['eq' => \Magento\ConfigurableProduct\Model\Product\Type\Configurable::TYPE_CODE]);
while ($product = $collection->fetchItem()) {
$productAttributesOptions = $product->getTypeInstance()->getConfigurableOptions($product);
foreach ($productAttributesOptions as $productAttributeOption) {
$this->configurableData[$product->getId()] = [];
$variations = [];
$variationsLabels = [];
foreach ($productAttributeOption as $optValues) {
$variations[$optValues['sku']][] = $optValues['attribute_code'] . '=' . $optValues['option_title'];
if (!empty($optValues['super_attribute_label'])) {
$variationsLabels[$optValues['attribute_code']] = $optValues['attribute_code'] . '=' . $optValues['super_attribute_label'];
}
}
foreach ($variations as $sku => $values) {
$variations[$sku] = 'sku=' . $sku . ImportProduct::DEFAULT_GLOBAL_MULTI_VALUE_SEPARATOR . implode(ImportProduct::DEFAULT_GLOBAL_MULTI_VALUE_SEPARATOR, $values);
}
$variations = implode(ImportProduct::PSEUDO_MULTI_LINE_SEPARATOR, $variations);
$variationsLabels = implode(ImportProduct::DEFAULT_GLOBAL_MULTI_VALUE_SEPARATOR, $variationsLabels);
$this->configurableData[$product->getId()] = ['configurable_variations' => $variations, 'configurable_variation_labels' => $variationsLabels];
}
}
}
/**
* @magentoDataFixture Magento/Catalog/_files/products_crosssell.php
*/
public function testAddLinkAttributeToFilterNoResults()
{
$om = \Magento\TestFramework\Helper\Bootstrap::getObjectManager();
$link = $om->get('Magento\\Catalog\\Model\\Product\\Link')->useCrossSellLinks();
$this->collection->setLinkModel($link);
$this->collection->addLinkAttributeToFilter('position', ['from' => 2, 'to' => 3]);
$product = $om->get('Magento\\Catalog\\Model\\Product')->load(2);
$this->collection->setProduct($product);
$this->collection->load();
$this->assertCount(0, $this->collection->getItems());
}
public function getAllIds($limit = null, $offset = null)
{
if (!$this->listingProductMode) {
return parent::getAllIds($limit, $offset);
}
// hack for selecting listing product ids instead entity ids
$idsSelect = clone $this->getSelect();
$idsSelect->reset(\Zend_Db_Select::ORDER);
$idsSelect->reset(\Zend_Db_Select::LIMIT_COUNT);
$idsSelect->reset(\Zend_Db_Select::LIMIT_OFFSET);
$idsSelect->columns('lp.' . $this->getIdFieldName());
$idsSelect->limit($limit, $offset);
$data = $this->getConnection()->fetchAll($idsSelect, $this->_bindParams);
$ids = array();
foreach ($data as $row) {
$ids[] = $row[$this->getIdFieldName()];
}
return $ids;
}
/**
* Add only is in stock products filter to product collection
*
* @param \Magento\Catalog\Model\ResourceModel\Product\Collection $collection
* @return $this
*/
public function addIsInStockFilterToCollection($collection)
{
$websiteId = $this->_storeManager->getStore($collection->getStoreId())->getWebsiteId();
$joinCondition = $this->getConnection()->quoteInto('e.entity_id = stock_status_index.product_id' . ' AND stock_status_index.website_id = ?', $websiteId);
$joinCondition .= $this->getConnection()->quoteInto(' AND stock_status_index.stock_id = ?', Stock::DEFAULT_STOCK_ID);
$collection->getSelect()->join(['stock_status_index' => $this->getMainTable()], $joinCondition, [])->where('stock_status_index.stock_status=?', Stock\Status::STATUS_IN_STOCK);
return $this;
}