/** * Get products by IDs * @param array $productIds * @param null|int $chunkSize * @param bool $filterVisibility * @return \Magento\Catalog\Model\Resource\Product\Collection */ public function getProducts(array $productIds = [], $chunkSize = null, $filterVisibility = true) { $this->_productCollection->addAttributeToSelect('sku')->addAttributeToSelect($this->_config->getProductAttributes())->addAttributeToSelect('status')->addAttributeToSelect('visibility'); if ($filterVisibility) { $this->_productCollection->addAttributeToFilter('visibility', ['in' => [Visibility::VISIBILITY_IN_CATALOG, Visibility::VISIBILITY_BOTH]])->addAttributeToFilter('status', Status::STATUS_ENABLED); } if (!empty($productIds)) { $this->_productCollection->addIdFilter($productIds); } if ($chunkSize !== null) { $this->_productCollection->setPageSize($chunkSize); } return $this->_productCollection; }
/** * Prepare configurable data for export * * @param \Magento\Catalog\Model\Resource\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 = []; $variationsPrices = []; $variationsLabels = []; foreach ($productAttributeOption as $optValues) { $variations[$optValues['sku']][] = $optValues['attribute_code'] . '=' . $optValues['option_title']; $priceType = $optValues['pricing_is_percent'] ? 'percent' : 'fixed'; $variationsPrices[] = 'name=' . $optValues['attribute_code'] . ImportProduct::DEFAULT_GLOBAL_MULTI_VALUE_SEPARATOR . 'value=' . $optValues['option_title'] . ImportProduct::DEFAULT_GLOBAL_MULTI_VALUE_SEPARATOR . 'price=' . $optValues['pricing_value'] . ImportProduct::DEFAULT_GLOBAL_MULTI_VALUE_SEPARATOR . 'price_type=' . $priceType; 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); $variationsPrices = array_unique($variationsPrices); $variationsPrices = implode(ImportProduct::PSEUDO_MULTI_LINE_SEPARATOR, $variationsPrices); $variationsLabels = implode(ImportProduct::DEFAULT_GLOBAL_MULTI_VALUE_SEPARATOR, $variationsLabels); $this->configurableData[$product->getId()] = ['configurable_variations' => $variations, 'configurable_variation_prices' => $variationsPrices, 'configurable_variation_labels' => $variationsLabels]; } } }
/** * Prepare configurable data for export * * @param \Magento\Catalog\Model\Resource\Product\Collection $collection * @param int $productIds * @return void */ public function prepareData($collection, $productIds) { $collection->addAttributeToFilter('entity_id', array('in' => $productIds))->addAttributeToFilter('type_id', array('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()] = array(); foreach ($productAttributeOption as $optionValues) { $priceType = $optionValues['pricing_is_percent'] ? '%' : ''; $this->configurableData[$product->getId()][] = array('_super_products_sku' => $optionValues['sku'], '_super_attribute_code' => $optionValues['attribute_code'], '_super_attribute_option' => $optionValues['option_title'], '_super_attribute_price_corr' => $optionValues['pricing_value'] . $priceType); } } } }
/** * Add attribute to filter * * @param AbstractAttribute|string $attribute * @param array|null $condition * @param string $joinType * @return $this */ public function addAttributeToFilter($attribute, $condition = null, $joinType = 'inner') { switch ($attribute) { case 'rt.review_id': case 'rt.created_at': case 'rt.status_id': case 'rdt.title': case 'rdt.nickname': case 'rdt.detail': $conditionSql = $this->_getConditionSql($attribute, $condition); $this->getSelect()->where($conditionSql); break; case 'stores': $this->setStoreFilter($condition); break; case 'type': if ($condition == 1) { $conditionParts = array($this->_getConditionSql('rdt.customer_id', array('is' => new \Zend_Db_Expr('NULL'))), $this->_getConditionSql('rdt.store_id', array('eq' => \Magento\Store\Model\Store::DEFAULT_STORE_ID))); $conditionSql = implode(' AND ', $conditionParts); } elseif ($condition == 2) { $conditionSql = $this->_getConditionSql('rdt.customer_id', array('gt' => 0)); } else { $conditionParts = array($this->_getConditionSql('rdt.customer_id', array('is' => new \Zend_Db_Expr('NULL'))), $this->_getConditionSql('rdt.store_id', array('neq' => \Magento\Store\Model\Store::DEFAULT_STORE_ID))); $conditionSql = implode(' AND ', $conditionParts); } $this->getSelect()->where($conditionSql); break; default: parent::addAttributeToFilter($attribute, $condition, $joinType); break; } return $this; }