Пример #1
0
 protected function _prepareCollection()
 {
     // Get collection
     // ---------------------------------------
     $collection = $this->productFactory->create()->getCollection()->addAttributeToSelect('name');
     // ---------------------------------------
     // ---------------------------------------
     $collection->getSelect()->distinct();
     // ---------------------------------------
     // Set filter store
     // ---------------------------------------
     $store = $this->_storeManager->getStore($this->listing->getData('store_id'));
     if ($store->getId()) {
         $collection->joinAttribute('custom_name', 'catalog_product/name', 'entity_id', NULL, 'inner', $store->getId());
         $collection->joinAttribute('thumbnail', 'catalog_product/thumbnail', 'entity_id', NULL, 'left', $store->getId());
     } else {
         $collection->addAttributeToSelect('thumbnail');
     }
     // ---------------------------------------
     // ---------------------------------------
     $productAddIds = (array) json_decode($this->listing->getChildObject()->getData('product_add_ids'), true);
     $lpTable = $this->activeRecordFactory->getObject('Listing\\Product')->getResource()->getMainTable();
     $collection->joinTable(array('lp' => $lpTable), 'product_id=entity_id', array('id' => 'id'), '{{table}}.listing_id=' . (int) $this->listing->getId());
     $elpTable = $this->activeRecordFactory->getObject('Ebay\\Listing\\Product')->getResource()->getMainTable();
     $collection->joinTable(array('elp' => $elpTable), 'listing_product_id=id', array('listing_product_id' => 'listing_product_id'));
     $collection->getSelect()->where('lp.id IN (?)', $productAddIds);
     // ---------------------------------------
     // Set collection to grid
     $this->setCollection($collection);
     return parent::_prepareCollection();
 }
Пример #2
0
 protected function _prepareCollection()
 {
     $data = $this->getHelper('Data\\GlobalData')->getValue('search_data');
     $collection = $this->customCollectionFactory->create();
     $collection->setConnection($this->resourceConnection->getConnection());
     foreach ($data['data'] as $index => $item) {
         $temp = array('id' => $index, 'general_id' => $item['general_id'], 'brand' => $item['brand'], 'title' => $item['title'], 'image_url' => $item['image_url'], 'price' => isset($item['list_price']['amount']) ? $item['list_price']['amount'] : null, 'is_variation_product' => $item['is_variation_product']);
         if ($temp['is_variation_product']) {
             if (!$item['bad_parent']) {
                 $temp += array('parentage' => $item['parentage'], 'variations' => $item['variations'], 'bad_parent' => $item['bad_parent']);
             } else {
                 $temp['bad_parent'] = $item['bad_parent'];
             }
             if (!empty($item['requested_child_id'])) {
                 $temp['requested_child_id'] = $item['requested_child_id'];
             }
         }
         $collection->addItem(new \Magento\Framework\DataObject($temp));
     }
     $collection->setCustomSize(count($data));
     $this->setCollection($collection);
     parent::_prepareCollection();
     $collection->setCustomIsLoaded(true);
     return $this;
 }
Пример #3
0
 protected function _prepareCollection()
 {
     $collection = $this->amazonFactory->getObject('Order')->getCollection();
     $collection->getSelect()->joinLeft(array('so' => $this->resourceConnection->getTableName('sales_order')), '(so.entity_id = `main_table`.magento_order_id)', array('magento_order_num' => 'increment_id'));
     // Add Filter By Account
     // ---------------------------------------
     if ($accountId = $this->getRequest()->getParam('amazonAccount')) {
         $collection->addFieldToFilter('main_table.account_id', $accountId);
     }
     // ---------------------------------------
     // Add Filter By Marketplace
     // ---------------------------------------
     if ($marketplaceId = $this->getRequest()->getParam('amazonMarketplace')) {
         $collection->addFieldToFilter('main_table.marketplace_id', $marketplaceId);
     }
     // ---------------------------------------
     // Add Not Created Magento Orders Filter
     // ---------------------------------------
     if ($this->getRequest()->getParam('not_created_only')) {
         $collection->addFieldToFilter('magento_order_id', array('null' => true));
     }
     // ---------------------------------------
     $this->setCollection($collection);
     return parent::_prepareCollection();
 }
Пример #4
0
 protected function _prepareCollection()
 {
     $collection = $this->activeRecordFactory->getObject('Order\\Log')->getCollection();
     $collection->addFieldToFilter('order_id', $this->order->getId());
     $this->setCollection($collection);
     return parent::_prepareCollection();
 }
Пример #5
0
 protected function _prepareCollection()
 {
     $collection = $this->ebayFactory->getObject('Order\\Item')->getCollection()->addFieldToFilter('order_id', $this->order->getId());
     //todo
     $collection->getSelect()->joinLeft(array('cisi' => $this->resourceConnection->getTableName('cataloginventory_stock_item')), '(cisi.product_id = `main_table`.product_id AND cisi.stock_id = 1)', array('is_in_stock'));
     $this->setCollection($collection);
     return parent::_prepareCollection();
 }
Пример #6
0
 protected function _prepareCollection()
 {
     $failedProducts = json_decode($this->getRequest()->getParam('failed_products'), 1);
     $collection = $this->productFactory->create()->getCollection()->addAttributeToSelect('sku')->addAttributeToSelect('name')->addAttributeToSelect('type_id')->joinField('qty', 'cataloginventory_stock_item', 'qty', 'product_id=entity_id', '{{table}}.stock_id=1', 'left')->joinField('is_in_stock', 'cataloginventory_stock_item', 'is_in_stock', 'product_id=entity_id', '{{table}}.stock_id=1', 'left');
     $collection->addFieldToFilter('entity_id', array('in' => $failedProducts));
     $this->setCollection($collection);
     return parent::_prepareCollection();
 }
Пример #7
0
 protected function _prepareCollection()
 {
     $this->prepareCacheData();
     $collection = $this->amazonFactory->getObject('Listing\\Other')->getCollection();
     $collection->getSelect()->group(array('account_id', 'marketplace_id'));
     // Set collection to grid
     $this->setCollection($collection);
     return parent::_prepareCollection();
 }
Пример #8
0
 protected function _prepareCollection()
 {
     $collection = $this->amazonFactory->getObject('Listing\\Other')->getCollection();
     $collection->getSelect()->joinLeft(array('mp' => $this->activeRecordFactory->getObject('Marketplace')->getResource()->getMainTable()), 'mp.id = main_table.marketplace_id', array('marketplace_title' => 'mp.title'))->joinLeft(array('am' => $this->activeRecordFactory->getObject('Amazon\\Marketplace')->getResource()->getMainTable()), 'am.marketplace_id = main_table.marketplace_id', array('currency' => 'am.default_currency'));
     // Add Filter By Account
     if ($this->getRequest()->getParam('account')) {
         $collection->addFieldToFilter('main_table.account_id', $this->getRequest()->getParam('account'));
     }
     // Add Filter By Marketplace
     if ($this->getRequest()->getParam('marketplace')) {
         $collection->addFieldToFilter('main_table.marketplace_id', $this->getRequest()->getParam('marketplace'));
     }
     $this->setCollection($collection);
     return parent::_prepareCollection();
 }
Пример #9
0
 protected function _prepareCollection()
 {
     $componentMode = $this->getHelper('Data\\GlobalData')->getValue('componentMode');
     $ignoreListings = (array) $this->getHelper('Data\\GlobalData')->getValue('ignoreListings');
     // Update statistic table values
     $this->activeRecordFactory->getObject('Listing')->getResource()->updateStatisticColumns();
     $this->activeRecordFactory->getObject(ucfirst($componentMode) . '\\Listing')->getResource()->updateStatisticColumns();
     $collection = $this->parentFactory->getObject($componentMode, 'Listing')->getCollection();
     foreach ($ignoreListings as $listingId) {
         $collection->addFieldToFilter('main_table.id', array('neq' => $listingId));
     }
     $this->addAccountAndMarketplaceFilter($collection);
     $this->setCollection($collection);
     return parent::_prepareCollection();
 }
Пример #10
0
 protected function _prepareCollection()
 {
     // Prepare selling format collection
     // ---------------------------------------
     $collectionSellingFormat = $this->activeRecordFactory->getObject('Template\\SellingFormat')->getCollection();
     $collectionSellingFormat->getSelect()->reset(Select::COLUMNS);
     $collectionSellingFormat->getSelect()->columns(array('id as template_id', 'title', new \Zend_Db_Expr('\'' . self::TEMPLATE_SELLING_FORMAT . '\' as `type`'), new \Zend_Db_Expr('\'0\' as `marketplace_id`'), 'create_date', 'update_date', new \Zend_Db_Expr('NULL as `category_path`'), new \Zend_Db_Expr('NULL as `browsenode_id`'), new \Zend_Db_Expr('NULL as `is_new_asin_accepted`')));
     $collectionSellingFormat->getSelect()->where('component_mode = (?)', \Ess\M2ePro\Helper\Component\Amazon::NICK);
     // ---------------------------------------
     // Prepare synchronization collection
     // ---------------------------------------
     $collectionSynchronization = $this->activeRecordFactory->getObject('Template\\Synchronization')->getCollection();
     $collectionSynchronization->getSelect()->reset(Select::COLUMNS);
     $collectionSynchronization->getSelect()->columns(array('id as template_id', 'title', new \Zend_Db_Expr('\'' . self::TEMPLATE_SYNCHRONIZATION . '\' as `type`'), new \Zend_Db_Expr('\'0\' as `marketplace_id`'), 'create_date', 'update_date', new \Zend_Db_Expr('NULL as `category_path`'), new \Zend_Db_Expr('NULL as `browsenode_id`'), new \Zend_Db_Expr('NULL as `is_new_asin_accepted`')));
     $collectionSynchronization->getSelect()->where('component_mode = (?)', \Ess\M2ePro\Helper\Component\Amazon::NICK);
     // ---------------------------------------
     // Prepare shipping override collection
     // ---------------------------------------
     $collectionShippingOverride = $this->activeRecordFactory->getObject('Amazon\\Template\\ShippingOverride')->getCollection();
     $collectionShippingOverride->getSelect()->reset(Select::COLUMNS);
     $collectionShippingOverride->getSelect()->columns(array('id as template_id', 'title', new \Zend_Db_Expr('\'' . self::TEMPLATE_SHIPPING_OVERRIDE . '\' as `type`'), 'marketplace_id', 'create_date', 'update_date', new \Zend_Db_Expr('NULL as `category_path`'), new \Zend_Db_Expr('NULL as `browsenode_id`'), new \Zend_Db_Expr('NULL as `is_new_asin_accepted`')));
     // ---------------------------------------
     // Prepare shipping override collection
     // ---------------------------------------
     $collectionDescription = $this->amazonFactory->getObject('Template\\Description')->getCollection();
     $collectionDescription->getSelect()->join(array('mm' => $this->activeRecordFactory->getObject('Marketplace')->getResource()->getMainTable()), 'mm.id=second_table.marketplace_id', array());
     $collectionDescription->addFieldToFilter('mm.status', \Ess\M2ePro\Model\Marketplace::STATUS_ENABLE);
     $collectionDescription->getSelect()->reset(Select::COLUMNS);
     $collectionDescription->getSelect()->columns(array('id as template_id', 'title', new \Zend_Db_Expr('\'' . self::TEMPLATE_DESCRIPTION . '\' as `type`'), 'second_table.marketplace_id', 'create_date', 'update_date', 'second_table.category_path', 'second_table.browsenode_id', 'second_table.is_new_asin_accepted'));
     // ---------------------------------------
     // Prepare union select
     // ---------------------------------------
     $unionSelect = $this->resourceConnection->getConnection()->select();
     $unionSelect->union(array($collectionSellingFormat->getSelect(), $collectionSynchronization->getSelect(), $collectionDescription->getSelect(), $collectionShippingOverride->getSelect()));
     // ---------------------------------------
     // Prepare result collection
     // ---------------------------------------
     /** @var \Ess\M2ePro\Model\ResourceModel\Collection\Custom $resultCollection */
     $resultCollection = $this->customCollectionFactory->create();
     $resultCollection->setConnection($this->resourceConnection->getConnection());
     $resultCollection->getSelect()->reset()->from(array('main_table' => $unionSelect), array('template_id', 'title', 'type', 'marketplace_id', 'create_date', 'update_date', 'category_path', 'browsenode_id', 'is_new_asin_accepted'));
     // ---------------------------------------
     //        echo $resultCollection->getSelectSql(true); exit;
     $this->setCollection($resultCollection);
     return parent::_prepareCollection();
 }
Пример #11
0
 protected function _prepareCollection()
 {
     $collection = $this->ebayFactory->getObject('Listing\\Other')->getCollection();
     $collection->getSelect()->joinLeft(array('mp' => $this->activeRecordFactory->getObject('Marketplace')->getResource()->getMainTable()), 'mp.id = main_table.marketplace_id', array('marketplace_title' => 'mp.title'));
     $collection->getSelect()->joinLeft(array('mea' => $this->activeRecordFactory->getObject('Ebay\\Account')->getResource()->getMainTable()), 'mea.account_id = main_table.account_id', array('account_mode' => 'mea.mode'));
     // Add Filter By Account
     if ($accountId = $this->getRequest()->getParam('account')) {
         $collection->addFieldToFilter('main_table.account_id', $accountId);
     }
     // Add Filter By Marketplace
     if ($marketplaceId = $this->getRequest()->getParam('marketplace')) {
         $collection->addFieldToFilter('main_table.marketplace_id', $marketplaceId);
     }
     $collection->getSelect()->reset(\Zend_Db_Select::COLUMNS);
     $collection->getSelect()->columns(array('id' => 'main_table.id', 'account_id' => 'main_table.account_id', 'marketplace_id' => 'main_table.marketplace_id', 'product_id' => 'main_table.product_id', 'title' => 'second_table.title', 'sku' => 'second_table.sku', 'item_id' => 'second_table.item_id', 'online_qty' => new \Zend_Db_Expr('(second_table.online_qty - second_table.online_qty_sold)'), 'online_qty_sold' => 'second_table.online_qty_sold', 'online_price' => 'second_table.online_price', 'status' => 'main_table.status', 'start_date' => 'second_table.start_date', 'end_date' => 'second_table.end_date', 'currency' => 'second_table.currency', 'account_mode' => 'mea.mode'));
     $this->setCollection($collection);
     return parent::_prepareCollection();
 }
Пример #12
0
 protected function _prepareCollection()
 {
     $listingProductsIds = $this->listing->getSetting('additional_data', 'adding_listing_products_ids');
     // Get collection
     // ---------------------------------------
     /* @var $collection \Ess\M2ePro\Model\ResourceModel\Magento\Product\Collection */
     $collection = $this->magentoProductCollectionFactory->create();
     $collection->setStoreId($this->listing['store_id'])->setListingProductModeOn()->addAttributeToSelect('name')->addAttributeToSelect('sku');
     $collection->joinTable(array('cisi' => 'cataloginventory_stock_item'), 'product_id=entity_id', array('qty' => 'qty'), '{{table}}.stock_id=1', 'left');
     // ---------------------------------------
     $lpTable = $this->activeRecordFactory->getObject('Listing\\Product')->getResource()->getMainTable();
     $collection->joinTable(array('lp' => $lpTable), 'product_id=entity_id', array('id' => 'id', 'component_mode' => 'component_mode', 'amazon_status' => 'status', 'additional_data' => 'additional_data'), '{{table}}.listing_id=' . (int) $this->listing['id']);
     $alpTable = $this->activeRecordFactory->getObject('Amazon\\Listing\\Product')->getResource()->getMainTable();
     $collection->joinTable(array('alp' => $alpTable), 'listing_product_id=id', array('general_id' => 'general_id', 'general_id_search_info' => 'general_id_search_info', 'search_settings_status' => 'search_settings_status', 'search_settings_data' => 'search_settings_data', 'variation_child_statuses' => 'variation_child_statuses', 'amazon_sku' => 'sku', 'online_qty' => 'online_qty', 'online_price' => 'online_price', 'online_sale_price' => 'online_sale_price', 'is_afn_channel' => 'is_afn_channel', 'is_general_id_owner' => 'is_general_id_owner', 'is_variation_parent' => 'is_variation_parent'), '{{table}}.variation_parent_id is NULL');
     $collection->getSelect()->where('lp.id IN (?)', $listingProductsIds);
     // ---------------------------------------
     $this->setCollection($collection);
     return parent::_prepareCollection();
 }
Пример #13
0
 protected function _prepareCollection()
 {
     // Get collection
     // ---------------------------------------
     $collection = $this->ebayFactory->getObject('Listing\\Product\\Variation')->getCollection();
     $collection->getSelect()->where('main_table.listing_product_id = ?', (int) $this->getListingProductId());
     $collection->getSelect()->group('main_table.id');
     // ---------------------------------------
     // Join variation option tables
     // ---------------------------------------
     $collection->getSelect()->join(array('mlpvo' => $this->activeRecordFactory->getObject('Listing\\Product\\Variation\\Option')->getResource()->getMainTable()), '`mlpvo`.`listing_product_variation_id`=`main_table`.`id`', array());
     $collection->getSelect()->reset(\Zend_Db_Select::COLUMNS);
     $collection->getSelect()->columns(array('id' => 'main_table.id', 'listing_product_id' => 'main_table.listing_product_id', 'additional_data' => 'main_table.additional_data', 'add' => 'second_table.add', 'delete' => 'second_table.delete', 'online_price' => 'second_table.online_price', 'online_sku' => 'second_table.online_sku', 'available_qty' => new \Zend_Db_Expr('(second_table.online_qty - second_table.online_qty_sold)'), 'online_qty_sold' => 'second_table.online_qty_sold', 'status' => 'second_table.status', 'attributes' => 'GROUP_CONCAT(`mlpvo`.`attribute`, \'==\', `mlpvo`.`option` SEPARATOR \'||\')', 'products_ids' => 'GROUP_CONCAT(`mlpvo`.`attribute`, \'==\', `mlpvo`.`product_id` SEPARATOR \'||\')'));
     $resultCollection = $this->customCollection->create();
     $resultCollection->setConnection($this->resourceConnection->getConnection());
     $resultCollection->getSelect()->reset()->from(array('main_table' => $collection->getSelect()), array('id', 'listing_product_id', 'additional_data', 'add', 'delete', 'online_price', 'available_qty', 'online_sku', 'online_qty_sold', 'status', 'attributes', 'products_ids'));
     // Set collection to grid
     $this->setCollection($resultCollection);
     return parent::_prepareCollection();
 }
Пример #14
0
 protected function _prepareCollection()
 {
     $collection = $this->activeRecordFactory->getObject('Order\\Log')->getCollection();
     $collection->getSelect()->joinLeft(array('mo' => $this->activeRecordFactory->getObject('Order')->getResource()->getMainTable()), '(mo.id = `main_table`.order_id)', array('magento_order_id'));
     $componentNick = $this->getHelper('Data\\GlobalData')->getValue('component_nick');
     if ($componentNick) {
         $accountId = (int) $this->getRequest()->getParam($componentNick . 'Account', false);
         $marketplaceId = (int) $this->getRequest()->getParam($componentNick . 'Marketplace', false);
         if ($accountId) {
             $collection->getSelect()->where('mo.account_id = ?', $accountId);
         }
         if ($marketplaceId) {
             $collection->getSelect()->where('mo.marketplace_id = ?', $marketplaceId);
         }
     }
     $collection->getSelect()->joinLeft(array('so' => $this->resourceConnection->getTableName('sales_order')), '(so.entity_id = `mo`.magento_order_id)', array('magento_order_number' => 'increment_id'));
     $orderId = $this->getRequest()->getParam('order_id');
     if ($orderId && !$this->getRequest()->isXmlHttpRequest()) {
         $collection->addFieldToFilter('main_table.order_id', (int) $orderId);
         /** @var \Ess\M2ePro\Model\Order $order */
         $order = $this->activeRecordFactory->getObjectLoaded('Order', (int) $orderId);
         $channelOrderId = $order->getData($order->getComponentMode() . '_order_id');
         $this->_setFilterValues(array('channel_order_id' => $channelOrderId, 'component_mode' => $order->getComponentMode()));
     }
     $channel = $this->getRequest()->getParam('channel');
     if (!empty($channel)) {
         $collection->getSelect()->where('main_table.component_mode = ?', $channel);
     } else {
         $components = $this->getHelper('View')->getComponentHelper()->getEnabledComponents();
         $collection->addFieldToFilter('main_table.component_mode', array('in' => $components));
     }
     // ---------------------------------------
     if ($this->getRequest()->getParam('sort', 'create_date') == 'create_date') {
         $collection->setOrder('id', $this->getRequest()->getParam('dir', 'DESC'));
     }
     // ---------------------------------------
     $this->setCollection($collection);
     return parent::_prepareCollection();
 }
Пример #15
0
 protected function _prepareCollection()
 {
     $select = $this->resourceConnection->getConnection()->select()->from($this->resourceConnection->getTableName('m2epro_amazon_dictionary_specific'))->where('marketplace_id = ?', (int) $this->marketplaceId)->where('product_data_nick = ?', $this->productDataNick)->where('type != ?', \Ess\M2ePro\Model\Amazon\Template\Description\Specific::DICTIONARY_TYPE_CONTAINER)->where('xpath LIKE ?', "{$this->currentXpath}/%")->order('title ASC');
     if ($this->searchQuery) {
         $select->where('title LIKE ?', "%{$this->searchQuery}%");
     }
     $filteredResult = [];
     $queryStmt = $select->query();
     while ($row = $queryStmt->fetch()) {
         if (in_array($row['xpath'], $this->renderedSpecifics) || in_array($row['xpath'], $this->selectedSpecifics)) {
             continue;
         }
         $row['data_definition'] = (array) json_decode($row['data_definition'], true);
         $row['is_desired'] = !empty($row['data_definition']['is_desired']) && $row['data_definition']['is_desired'];
         if ($this->onlyDesired && !$row['is_desired']) {
             continue;
         }
         $filteredResult[] = $row;
     }
     usort($filteredResult, function ($a, $b) {
         if ($a['is_desired'] && !$b['is_desired']) {
             return -1;
         }
         if ($b['is_desired'] && !$a['is_desired']) {
             return 1;
         }
         return $a['title'] == $b['title'] ? 0 : ($a['title'] > $b['title'] ? 1 : -1);
     });
     $collection = $this->customCollectionFactory->create();
     $collection->setConnection($this->resourceConnection->getConnection());
     foreach ($filteredResult as $item) {
         $collection->addItem(new \Magento\Framework\DataObject($item));
     }
     $collection->setCustomSize(count($filteredResult));
     $this->setCollection($collection);
     parent::_prepareCollection();
     $collection->setCustomIsLoaded(true);
     return $this;
 }
Пример #16
0
 protected function _prepareCollection()
 {
     // Get collection logs
     // ---------------------------------------
     $categoriesCollection = $this->activeRecordFactory->getObject('Listing\\Auto\\Category')->getCollection();
     $categoriesCollection->getSelect()->reset(\Zend_Db_Select::FROM);
     $categoriesCollection->getSelect()->from(array('mlac' => $this->activeRecordFactory->getObject('Listing\\Auto\\Category')->getResource()->getMainTable()));
     $categoriesCollection->getSelect()->reset(\Zend_Db_Select::COLUMNS);
     $categoriesCollection->getSelect()->columns(new \Zend_Db_Expr('GROUP_CONCAT(`category_id`)'));
     $categoriesCollection->getSelect()->where('mlac.group_id = main_table.id');
     $collection = $this->activeRecordFactory->getObject('Listing\\Auto\\Category\\Group')->getCollection();
     $collection->addFieldToFilter('main_table.listing_id', $this->getRequest()->getParam('id'));
     $collection->getSelect()->columns(array('categories' => new \Zend_Db_Expr('(' . $categoriesCollection->getSelect() . ')')));
     // ---------------------------------------
     // we need sort by id also, because create_date may be same for some adjustment entries
     // ---------------------------------------
     if ($this->getRequest()->getParam('sort', 'create_date') == 'create_date') {
         $collection->setOrder('id', $this->getRequest()->getParam('dir', 'DESC'));
     }
     // ---------------------------------------
     // Set collection to grid
     $this->setCollection($collection);
     return parent::_prepareCollection();
 }
Пример #17
0
 protected function _prepareCollection()
 {
     $this->setNoTemplatesText();
     /** @var \Ess\M2ePro\Model\ResourceModel\Amazon\Template\Description\Collection $descriptionCollection */
     $descriptionCollection = $this->parentFactory->getObject(\Ess\M2ePro\Helper\View\Amazon::NICK, 'Template\\Description')->getCollection();
     $descriptionCollection->addFieldToFilter('marketplace_id', $this->getMarketplaceId());
     $preparedCollection = $this->customCollectionFactory->create();
     $preparedCollection->setConnection($this->resourceConnection->getConnection());
     $data = $descriptionCollection->getData();
     $preparedData = [];
     foreach ($data as $item) {
         if (!$this->getCheckNewAsinAccepted()) {
             $item['description_template_action_status'] = self::ACTION_STATUS_READY_TO_BE_ASSIGNED;
             $preparedData[] = $item;
             continue;
         }
         if (!$item['is_new_asin_accepted']) {
             $item['description_template_action_status'] = self::ACTION_STATUS_NEW_ASIN_NOT_ACCEPTED;
             $preparedData[] = $item;
             continue;
         }
         $variationProductsIds = $this->getVariationsProductsIds();
         if (!empty($variationProductsIds)) {
             $detailsModel = $this->modelFactory->getObject('Amazon\\Marketplace\\Details');
             $detailsModel->setMarketplaceId($this->getMarketplaceId());
             $themes = $detailsModel->getVariationThemes($item['product_data_nick']);
             if (empty($themes)) {
                 $item['description_template_action_status'] = self::ACTION_STATUS_VARIATIONS_NOT_SUPPORTED;
                 $preparedData[] = $item;
                 continue;
             }
         }
         $item['description_template_action_status'] = self::ACTION_STATUS_READY_TO_BE_ASSIGNED;
         $preparedData[] = $item;
         continue;
     }
     if (!empty($preparedData)) {
         usort($preparedData, function ($a, $b) {
             return $a["description_template_action_status"] < $b["description_template_action_status"];
         });
         foreach ($preparedData as $item) {
             $preparedCollection->addItem(new \Magento\Framework\DataObject($item));
         }
     }
     $preparedCollection->setCustomSize(count($preparedData));
     $this->setCollection($preparedCollection);
     parent::_prepareCollection();
     $preparedCollection->setCustomIsLoaded(true);
     return $this;
 }
Пример #18
0
 protected function _prepareCollection()
 {
     $collection = $this->productModel->getCollection()->addAttributeToSelect('sku')->addAttributeToSelect('name')->addAttributeToSelect('type_id')->joinField('qty', 'cataloginventory_stock_item', 'qty', 'product_id=entity_id', '{{table}}.stock_id=1', 'left')->joinField('is_in_stock', 'cataloginventory_stock_item', 'is_in_stock', 'product_id=entity_id', '{{table}}.stock_id=1', 'left');
     $this->setCollection($collection);
     return parent::_prepareCollection();
 }
Пример #19
0
 protected function _prepareCollection()
 {
     // Get collection products in listing
     // ---------------------------------------
     $nameAttribute = $this->resourceCatalogProduct->getAttribute('name');
     $nameAttributeId = $nameAttribute ? (int) $nameAttribute->getId() : 0;
     $listingProductCollection = $this->ebayFactory->getObject('Listing\\Product')->getCollection();
     $listingProductCollection->getSelect()->distinct();
     $listingProductCollection->getSelect()->join(array('l' => $this->activeRecordFactory->getObject('Listing')->getResource()->getMainTable()), '`l`.`id` = `main_table`.`listing_id`');
     $listingProductCollection->getSelect()->join(array('em' => $this->activeRecordFactory->getObject('Ebay\\Marketplace')->getResource()->getMainTable()), '`em`.`marketplace_id` = `l`.`marketplace_id`');
     $listingProductCollection->getSelect()->join(array('cpe' => $this->resourceConnection->getTableName('catalog_product_entity')), 'cpe.entity_id = `main_table`.product_id');
     $listingProductCollection->getSelect()->joinLeft(array('cpev' => $this->resourceConnection->getTableName('catalog_product_entity_varchar')), '`cpev`.`entity_id` = `main_table`.`product_id`' . ' AND `cpev`.`attribute_id` = ' . $nameAttributeId . ' AND `cpev`.`store_id` = 0');
     $listingProductCollection->getSelect()->joinLeft(array('ebit' => $this->activeRecordFactory->getObject('Ebay\\Item')->getResource()->getMainTable()), '(`ebit`.`id` = `second_table`.`ebay_item_id`)', array('item_id'));
     // ---------------------------------------
     // add stock availability, status & visibility to select
     // ---------------------------------------
     $listingProductCollection->getSelect()->joinLeft(array('cisi' => $this->resourceStockItem->getMainTable()), '(`cisi`.`product_id` = `main_table`.`product_id` AND `cisi`.`stock_id` = 1)', array('is_in_stock'));
     // ---------------------------------------
     $listingProductCollection->getSelect()->reset(\Zend_Db_Select::COLUMNS);
     $listingProductCollection->getSelect()->columns(array('account_id' => 'l.account_id', 'marketplace_id' => 'l.marketplace_id', 'product_id' => 'main_table.product_id', 'product_name' => 'cpev.value', 'product_sku' => 'cpe.sku', 'currency' => 'em.currency', 'ebay_item_id' => 'ebit.item_id', 'listing_product_id' => 'main_table.id', 'listing_other_id' => new \Zend_Db_Expr('NULL'), 'additional_data' => 'main_table.additional_data', 'status' => 'main_table.status', 'online_sku' => 'second_table.online_sku', 'online_title' => 'second_table.online_title', 'online_qty' => new \Zend_Db_Expr('(second_table.online_qty - second_table.online_qty_sold)'), 'online_qty_sold' => 'second_table.online_qty_sold', 'online_bids' => 'second_table.online_bids', 'online_start_price' => 'second_table.online_start_price', 'online_current_price' => 'second_table.online_current_price', 'online_reserve_price' => 'second_table.online_reserve_price', 'online_buyitnow_price' => 'second_table.online_buyitnow_price', 'min_online_price' => 'IF(
                 (`t`.`variation_min_price` IS NULL),
                 `second_table`.`online_current_price`,
                 `t`.`variation_min_price`
             )', 'max_online_price' => 'IF(
                 (`t`.`variation_max_price` IS NULL),
                 `second_table`.`online_current_price`,
                 `t`.`variation_max_price`
             )', 'listing_id' => 'l.id', 'listing_title' => 'l.title', 'is_m2epro_listing' => new \Zend_Db_Expr(1), 'is_in_stock' => 'cisi.is_in_stock'));
     $listingProductCollection->getSelect()->joinLeft(new \Zend_Db_Expr('(
             SELECT
                 `mlpv`.`listing_product_id`,
                 MIN(`melpv`.`online_price`) as variation_min_price,
                 MAX(`melpv`.`online_price`) as variation_max_price
             FROM `' . $this->activeRecordFactory->getObject('Listing\\Product\\Variation')->getResource()->getMainTable() . '` AS `mlpv`
             INNER JOIN `' . $this->activeRecordFactory->getObject('Ebay\\Listing\\Product\\Variation')->getResource()->getMainTable() . '` AS `melpv`
                 ON (`mlpv`.`id` = `melpv`.`listing_product_variation_id`)
             WHERE `melpv`.`status` != ' . \Ess\M2ePro\Model\Listing\Product::STATUS_NOT_LISTED . '
             GROUP BY `mlpv`.`listing_product_id`
         )'), 'second_table.listing_product_id=t.listing_product_id', array('variation_min_price' => 'variation_min_price', 'variation_max_price' => 'variation_max_price'));
     // ---------------------------------------
     // ---------------------------------------
     $listingOtherCollection = $this->ebayFactory->getObject('Listing\\Other')->getCollection();
     $listingOtherCollection->getSelect()->distinct();
     // add stock availability, type id, status & visibility to select
     // ---------------------------------------
     $listingOtherCollection->getSelect()->joinLeft(array('cisi' => $this->resourceStockItem->getMainTable()), '(`cisi`.`product_id` = `main_table`.`product_id` AND cisi.stock_id = 1)', array('is_in_stock'));
     // ---------------------------------------
     $listingOtherCollection->getSelect()->reset(\Zend_Db_Select::COLUMNS);
     $listingOtherCollection->getSelect()->columns(array('account_id' => 'main_table.account_id', 'marketplace_id' => 'main_table.marketplace_id', 'product_id' => 'main_table.product_id', 'product_name' => 'second_table.title', 'product_sku' => 'second_table.sku', 'currency' => 'second_table.currency', 'ebay_item_id' => 'second_table.item_id', 'listing_product_id' => new \Zend_Db_Expr('NULL'), 'listing_other_id' => 'main_table.id', 'additional_data' => new \Zend_Db_Expr('NULL'), 'status' => 'main_table.status', 'online_sku' => new \Zend_Db_Expr('NULL'), 'online_title' => new \Zend_Db_Expr('NULL'), 'online_qty' => new \Zend_Db_Expr('(second_table.online_qty - second_table.online_qty_sold)'), 'online_qty_sold' => 'second_table.online_qty_sold', 'online_bids' => new \Zend_Db_Expr('NULL'), 'online_start_price' => new \Zend_Db_Expr('NULL'), 'online_current_price' => 'second_table.online_price', 'online_reserve_price' => new \Zend_Db_Expr('NULL'), 'online_buyitnow_price' => new \Zend_Db_Expr('NULL'), 'min_online_price' => 'second_table.online_price', 'max_online_price' => 'second_table.online_price', 'listing_id' => new \Zend_Db_Expr('NULL'), 'listing_title' => new \Zend_Db_Expr('NULL'), 'is_m2epro_listing' => new \Zend_Db_Expr(0), 'is_in_stock' => 'cisi.is_in_stock', 'variation_min_price' => new \Zend_Db_Expr('NULL'), 'variation_max_price' => new \Zend_Db_Expr('NULL')));
     // ---------------------------------------
     // ---------------------------------------
     $selects = array($listingProductCollection->getSelect());
     $selects[] = $listingOtherCollection->getSelect();
     $unionSelect = $this->resourceConnection->getConnection()->select();
     $unionSelect->union($selects);
     $resultCollection = $this->customCollectionFactory->create();
     $resultCollection->setConnection($this->resourceConnection->getConnection());
     $resultCollection->getSelect()->reset()->from(array('main_table' => $unionSelect), array('account_id', 'marketplace_id', 'product_id', 'product_name', 'product_sku', 'currency', 'ebay_item_id', 'listing_product_id', 'listing_other_id', 'additional_data', 'status', 'online_sku', 'online_title', 'online_qty', 'online_qty_sold', 'online_bids', 'online_start_price', 'online_current_price', 'online_reserve_price', 'online_buyitnow_price', 'min_online_price', 'max_online_price', 'listing_id', 'listing_title', 'is_m2epro_listing', 'is_in_stock'));
     // ---------------------------------------
     $accountId = (int) $this->getRequest()->getParam('ebayAccount', false);
     $marketplaceId = (int) $this->getRequest()->getParam('ebayMarketplace', false);
     $listingType = (int) $this->getRequest()->getParam('listing_type', false);
     if ($accountId) {
         $resultCollection->getSelect()->where('account_id = ?', $accountId);
     }
     if ($marketplaceId) {
         $resultCollection->getSelect()->where('marketplace_id = ?', $marketplaceId);
     }
     if ($listingType) {
         if ($listingType == Switcher::LISTING_TYPE_M2E_PRO) {
             $resultCollection->getSelect()->where('is_m2epro_listing = ?', 1);
         } elseif ($listingType == Switcher::LISTING_TYPE_LISTING_OTHER) {
             $resultCollection->getSelect()->where('is_m2epro_listing = ?', 0);
         }
     }
     $this->setCollection($resultCollection);
     return parent::_prepareCollection();
 }
Пример #20
0
 protected function _prepareCollection()
 {
     // Prepare selling format collection
     // ---------------------------------------
     $collectionSellingFormat = $this->activeRecordFactory->getObject('Template\\SellingFormat')->getCollection();
     $collectionSellingFormat->getSelect()->join(array('etsf' => $this->activeRecordFactory->getObject('Ebay\\Template\\SellingFormat')->getResource()->getMainTable()), 'main_table.id=etsf.template_selling_format_id', array('is_custom_template'));
     $collectionSellingFormat->getSelect()->reset(Select::COLUMNS);
     $collectionSellingFormat->getSelect()->columns(array('id as template_id', 'title', new \Zend_Db_Expr('\'0\' as `marketplace`'), new \Zend_Db_Expr('\'' . \Ess\M2ePro\Model\Ebay\Template\Manager::TEMPLATE_SELLING_FORMAT . '\' as `nick`'), 'create_date', 'update_date'));
     $collectionSellingFormat->addFieldToFilter('component_mode', \Ess\M2ePro\Helper\Component\Ebay::NICK);
     $collectionSellingFormat->addFieldToFilter('is_custom_template', 0);
     // ---------------------------------------
     // Prepare synchronization collection
     // ---------------------------------------
     $collectionSynchronization = $this->activeRecordFactory->getObject('Template\\Synchronization')->getCollection();
     $collectionSynchronization->getSelect()->join(array('ets' => $this->activeRecordFactory->getObject('Ebay\\Template\\Synchronization')->getResource()->getMainTable()), 'main_table.id=ets.template_synchronization_id', array('is_custom_template'));
     $collectionSynchronization->getSelect()->reset(Select::COLUMNS);
     $collectionSynchronization->getSelect()->columns(array('id as template_id', 'title', new \Zend_Db_Expr('\'0\' as `marketplace`'), new \Zend_Db_Expr('\'' . \Ess\M2ePro\Model\Ebay\Template\Manager::TEMPLATE_SYNCHRONIZATION . '\' as `nick`'), 'create_date', 'update_date'));
     $collectionSynchronization->addFieldToFilter('component_mode', \Ess\M2ePro\Helper\Component\Ebay::NICK);
     $collectionSynchronization->addFieldToFilter('is_custom_template', 0);
     // ---------------------------------------
     // Prepare description collection
     // ---------------------------------------
     $collectionDescription = $this->activeRecordFactory->getObject('Template\\Description')->getCollection();
     $collectionDescription->getSelect()->join(array('ets' => $this->activeRecordFactory->getObject('Ebay\\Template\\Description')->getResource()->getMainTable()), 'main_table.id=ets.template_description_id', array('is_custom_template'));
     $collectionDescription->getSelect()->reset(Select::COLUMNS);
     $collectionDescription->getSelect()->columns(array('id as template_id', 'title', new \Zend_Db_Expr('\'0\' as `marketplace`'), new \Zend_Db_Expr('\'' . \Ess\M2ePro\Model\Ebay\Template\Manager::TEMPLATE_DESCRIPTION . '\' as `nick`'), 'create_date', 'update_date'));
     $collectionDescription->addFieldToFilter('component_mode', \Ess\M2ePro\Helper\Component\Ebay::NICK);
     $collectionDescription->addFieldToFilter('is_custom_template', 0);
     // ---------------------------------------
     // Prepare payment collection
     // ---------------------------------------
     $collectionPayment = $this->activeRecordFactory->getObject('Ebay\\Template\\Payment')->getCollection();
     $collectionPayment->getSelect()->reset(Select::COLUMNS);
     $collectionPayment->getSelect()->columns(array('id as template_id', 'title', 'marketplace_id as marketplace', new \Zend_Db_Expr('\'' . \Ess\M2ePro\Model\Ebay\Template\Manager::TEMPLATE_PAYMENT . '\' as `nick`'), 'create_date', 'update_date'));
     $collectionPayment->addFieldToFilter('is_custom_template', 0);
     $collectionPayment->addFieldToFilter('marketplace_id', array('in' => $this->getEnabledMarketplacesIds()));
     // ---------------------------------------
     // Prepare shipping collection
     // ---------------------------------------
     $collectionShipping = $this->activeRecordFactory->getObject('Ebay\\Template\\Shipping')->getCollection();
     $collectionShipping->getSelect()->reset(Select::COLUMNS);
     $collectionShipping->getSelect()->columns(array('id as template_id', 'title', 'marketplace_id as marketplace', new \Zend_Db_Expr('\'' . \Ess\M2ePro\Model\Ebay\Template\Manager::TEMPLATE_SHIPPING . '\' as `nick`'), 'create_date', 'update_date'));
     $collectionShipping->addFieldToFilter('is_custom_template', 0);
     $collectionShipping->addFieldToFilter('marketplace_id', array('in' => $this->getEnabledMarketplacesIds()));
     // ---------------------------------------
     // Prepare return collection
     // ---------------------------------------
     $collectionReturn = $this->activeRecordFactory->getObject('Ebay\\Template\\ReturnPolicy')->getCollection();
     $collectionReturn->getSelect()->reset(Select::COLUMNS);
     $collectionReturn->getSelect()->columns(array('id as template_id', 'title', 'marketplace_id as marketplace', new \Zend_Db_Expr('\'' . \Ess\M2ePro\Model\Ebay\Template\Manager::TEMPLATE_RETURN_POLICY . '\' as `nick`'), 'create_date', 'update_date'));
     $collectionReturn->addFieldToFilter('is_custom_template', 0);
     $collectionReturn->addFieldToFilter('marketplace_id', array('in' => $this->getEnabledMarketplacesIds()));
     // ---------------------------------------
     // Prepare union select
     // ---------------------------------------
     $unionSelect = $this->resourceConnection->getConnection()->select();
     $unionSelect->union(array($collectionSellingFormat->getSelect(), $collectionSynchronization->getSelect(), $collectionDescription->getSelect(), $collectionPayment->getSelect(), $collectionShipping->getSelect(), $collectionReturn->getSelect()));
     // ---------------------------------------
     // Prepare result collection
     // ---------------------------------------
     /** @var \Ess\M2ePro\Model\ResourceModel\Collection\Custom $resultCollection */
     $resultCollection = $this->customCollectionFactory->create();
     $resultCollection->setConnection($this->resourceConnection->getConnection());
     $resultCollection->getSelect()->reset()->from(array('main_table' => $unionSelect), array('template_id', 'title', 'nick', 'marketplace', 'create_date', 'update_date'));
     // ---------------------------------------
     $this->setCollection($resultCollection);
     return parent::_prepareCollection();
 }
Пример #21
0
 protected function _prepareCollection()
 {
     // Get collection products in listing
     // ---------------------------------------
     $listingProductCollection = $this->amazonFactory->getObject('Listing\\Product')->getCollection();
     $listingProductCollection->getSelect()->distinct();
     $listingProductCollection->getSelect()->join(array('l' => $this->activeRecordFactory->getObject('Listing')->getResource()->getMainTable()), '(`l`.`id` = `main_table`.`listing_id`)', array('listing_title' => 'title', 'store_id', 'marketplace_id'))->join(array('al' => $this->activeRecordFactory->getObject('Amazon\\Listing')->getResource()->getMainTable()), '(`al`.`listing_id` = `l`.`id`)', array('template_selling_format_id'));
     // ---------------------------------------
     // only parents and individuals
     $listingProductCollection->getSelect()->where('second_table.variation_parent_id IS NULL');
     // Communicate with magento product table
     // ---------------------------------------
     $dbSelect = $this->resourceConnection->getConnection()->select()->from($this->resourceConnection->getTableName('catalog_product_entity_varchar'), new \Zend_Db_Expr('MAX(`store_id`)'))->where("`entity_id` = `main_table`.`product_id`")->where("`attribute_id` = `ea`.`attribute_id`")->where("`store_id` = 0 OR `store_id` = `l`.`store_id`");
     $listingProductCollection->getSelect()->join(array('cpe' => $this->resourceConnection->getTableName('catalog_product_entity')), '(cpe.entity_id = `main_table`.product_id)', array('magento_sku' => 'sku'))->join(array('cisi' => $this->resourceConnection->getTableName('cataloginventory_stock_item')), '(cisi.product_id = `main_table`.product_id AND cisi.stock_id = 1)', array('is_in_stock'))->join(array('cpev' => $this->resourceConnection->getTableName('catalog_product_entity_varchar')), "(`cpev`.`entity_id` = `main_table`.product_id)", array('value'))->join(array('ea' => $this->resourceConnection->getTableName('eav_attribute')), '(`cpev`.`attribute_id` = `ea`.`attribute_id` AND `ea`.`attribute_code` = \'name\')', array())->where('`cpev`.`store_id` = (' . $dbSelect->__toString() . ')');
     // ---------------------------------------
     $listingProductCollection->getSelect()->reset(\Zend_Db_Select::COLUMNS);
     $listingProductCollection->getSelect()->columns(array('is_m2epro_listing' => new \Zend_Db_Expr('1'), 'magento_sku' => 'cpe.sku', 'is_in_stock' => 'cisi.is_in_stock', 'product_name' => 'cpev.value', 'listing_title' => 'l.title', 'store_id' => 'l.store_id', 'account_id' => 'l.account_id', 'marketplace_id' => 'l.marketplace_id', 'template_selling_format_id' => 'al.template_selling_format_id', 'listing_product_id' => 'main_table.id', 'product_id' => 'main_table.product_id', 'listing_id' => 'main_table.listing_id', 'status' => 'main_table.status', 'is_general_id_owner' => 'second_table.is_general_id_owner', 'general_id' => 'second_table.general_id', 'is_afn_channel' => 'second_table.is_afn_channel', 'is_variation_parent' => 'second_table.is_variation_parent', 'variation_child_statuses' => 'second_table.variation_child_statuses', 'online_sku' => 'second_table.sku', 'online_qty' => 'second_table.online_qty', 'online_price' => 'second_table.online_price', 'online_sale_price' => 'second_table.online_sale_price', 'online_sale_price_start_date' => 'second_table.online_sale_price_start_date', 'online_sale_price_end_date' => 'second_table.online_sale_price_end_date', 'min_online_price' => 'IF(
                 (`t`.`variation_min_price` IS NULL),
                 IF(
                   `second_table`.`online_sale_price_start_date` IS NOT NULL AND
                   `second_table`.`online_sale_price_end_date` IS NOT NULL AND
                   `second_table`.`online_sale_price_start_date` <= CURRENT_DATE() AND
                   `second_table`.`online_sale_price_end_date` >= CURRENT_DATE(),
                   `second_table`.`online_sale_price`,
                   `second_table`.`online_price`
                 ),
                 `t`.`variation_min_price`
             )', 'max_online_price' => 'IF(
                 (`t`.`variation_max_price` IS NULL),
                 IF(
                   `second_table`.`online_sale_price_start_date` IS NOT NULL AND
                   `second_table`.`online_sale_price_end_date` IS NOT NULL AND
                   `second_table`.`online_sale_price_start_date` <= CURRENT_DATE() AND
                   `second_table`.`online_sale_price_end_date` >= CURRENT_DATE(),
                   `second_table`.`online_sale_price`,
                   `second_table`.`online_price`
                 ),
                 `t`.`variation_max_price`
             )'));
     $listingProductCollection->getSelect()->joinLeft(new \Zend_Db_Expr('(
             SELECT
                 `malp`.`variation_parent_id`,
                 MIN(
                     IF(
                         `malp`.`online_sale_price_start_date` IS NOT NULL AND
                         `malp`.`online_sale_price_end_date` IS NOT NULL AND
                         `malp`.`online_sale_price_start_date` <= CURRENT_DATE() AND
                         `malp`.`online_sale_price_end_date` >= CURRENT_DATE(),
                         `malp`.`online_sale_price`,
                         `malp`.`online_price`
                     )
                 ) as variation_min_price,
                 MAX(
                     IF(
                         `malp`.`online_sale_price_start_date` IS NOT NULL AND
                         `malp`.`online_sale_price_end_date` IS NOT NULL AND
                         `malp`.`online_sale_price_start_date` <= CURRENT_DATE() AND
                         `malp`.`online_sale_price_end_date` >= CURRENT_DATE(),
                         `malp`.`online_sale_price`,
                         `malp`.`online_price`
                     )
                 ) as variation_max_price
             FROM `' . $this->activeRecordFactory->getObject('Amazon\\Listing\\Product')->getResource()->getMainTable() . '` as malp
             INNER JOIN `' . $this->activeRecordFactory->getObject('Listing\\Product')->getResource()->getMainTable() . '` AS `mlp`
                 ON (`malp`.`listing_product_id` = `mlp`.`id`)
             WHERE `mlp`.`status` IN (
                 ' . \Ess\M2ePro\Model\Listing\Product::STATUS_LISTED . ',
                 ' . \Ess\M2ePro\Model\Listing\Product::STATUS_STOPPED . ',
                 ' . \Ess\M2ePro\Model\Listing\Product::STATUS_UNKNOWN . '
             ) AND `malp`.`variation_parent_id` IS NOT NULL
             GROUP BY `malp`.`variation_parent_id`
         )'), 'second_table.listing_product_id=t.variation_parent_id', array('variation_min_price' => 'variation_min_price', 'variation_max_price' => 'variation_max_price'));
     // ---------------------------------------
     $listingOtherCollection = $this->amazonFactory->getObject('Listing\\Other')->getCollection();
     $listingOtherCollection->getSelect()->distinct();
     // add stock availability, type id, status & visibility to select
     // ---------------------------------------
     $listingOtherCollection->getSelect()->joinLeft(array('cisi' => $this->resourceStockItem->getMainTable()), '(`cisi`.`product_id` = `main_table`.`product_id` AND cisi.stock_id = 1)', array('is_in_stock'))->joinLeft(array('cpe' => $this->resourceConnection->getTableName('catalog_product_entity')), '(cpe.entity_id = `main_table`.product_id)', array('magento_sku' => 'sku'));
     // ---------------------------------------
     $listingOtherCollection->getSelect()->reset(\Zend_Db_Select::COLUMNS);
     $listingOtherCollection->getSelect()->columns(array('is_m2epro_listing' => new \Zend_Db_Expr(0), 'magento_sku' => 'cpe.sku', 'is_in_stock' => 'cisi.is_in_stock', 'product_name' => 'second_table.title', 'listing_title' => new \Zend_Db_Expr('NULL'), 'store_id' => new \Zend_Db_Expr(0), 'account_id' => 'main_table.account_id', 'marketplace_id' => 'main_table.marketplace_id', 'template_selling_format_id' => new \Zend_Db_Expr('NULL'), 'listing_product_id' => new \Zend_Db_Expr('NULL'), 'product_id' => 'main_table.product_id', 'listing_id' => new \Zend_Db_Expr('NULL'), 'status' => 'main_table.status', 'is_general_id_owner' => new \Zend_Db_Expr('NULL'), 'general_id' => 'second_table.general_id', 'is_afn_channel' => 'second_table.is_afn_channel', 'is_variation_parent' => new \Zend_Db_Expr('NULL'), 'variation_child_statuses' => new \Zend_Db_Expr('NULL'), 'online_sku' => 'second_table.sku', 'online_qty' => 'second_table.online_qty', 'online_price' => 'second_table.online_price', 'online_sale_price' => new \Zend_Db_Expr('NULL'), 'online_sale_price_start_date' => new \Zend_Db_Expr('NULL'), 'online_sale_price_end_date' => new \Zend_Db_Expr('NULL'), 'min_online_price' => 'second_table.online_price', 'max_online_price' => 'second_table.online_price', 'variation_min_price' => new \Zend_Db_Expr('NULL'), 'variation_max_price' => new \Zend_Db_Expr('NULL')));
     // ---------------------------------------
     // ---------------------------------------
     $selects = array($listingProductCollection->getSelect(), $listingOtherCollection->getSelect());
     $unionSelect = $this->resourceConnection->getConnection()->select();
     $unionSelect->union($selects);
     $resultCollection = $this->customCollectionFactory->create();
     $resultCollection->setConnection($this->resourceConnection->getConnection());
     $resultCollection->getSelect()->reset()->from(array('main_table' => $unionSelect), array('is_m2epro_listing', 'magento_sku', 'is_in_stock', 'product_name', 'listing_title', 'store_id', 'account_id', 'marketplace_id', 'template_selling_format_id', 'listing_product_id', 'product_id', 'listing_id', 'status', 'is_general_id_owner', 'general_id', 'is_afn_channel', 'is_variation_parent', 'variation_child_statuses', 'online_sku', 'online_qty', 'online_price', 'online_sale_price', 'online_sale_price_start_date', 'online_sale_price_end_date', 'min_online_price', 'max_online_price', 'variation_min_price', 'variation_max_price'));
     // ---------------------------------------
     $accountId = (int) $this->getRequest()->getParam('amazonAccount', false);
     $marketplaceId = (int) $this->getRequest()->getParam('amazonMarketplace', false);
     $listingType = (int) $this->getRequest()->getParam('listing_type', false);
     if ($accountId) {
         $resultCollection->getSelect()->where('account_id = ?', $accountId);
     }
     if ($marketplaceId) {
         $resultCollection->getSelect()->where('marketplace_id = ?', $marketplaceId);
     }
     if ($listingType) {
         if ($listingType == Switcher::LISTING_TYPE_M2E_PRO) {
             $resultCollection->getSelect()->where('is_m2epro_listing = ?', 1);
         } elseif ($listingType == Switcher::LISTING_TYPE_LISTING_OTHER) {
             $resultCollection->getSelect()->where('is_m2epro_listing = ?', 0);
         }
     }
     // Set collection to grid
     $this->setCollection($resultCollection);
     return parent::_prepareCollection();
 }
Пример #22
0
 protected function _prepareCollection()
 {
     // Get collection
     // ---------------------------------------
     $collection = $this->amazonFactory->getObject('Listing\\Product')->getCollection();
     $collection->getSelect()->distinct();
     $collection->getSelect()->where("`second_table`.`variation_parent_id` = ?", (int) $this->getListingProduct()->getId());
     // ---------------------------------------
     $lpvTable = $this->activeRecordFactory->getObject('Listing\\Product\\Variation')->getResource()->getMainTable();
     $lpvoTable = $this->activeRecordFactory->getObject('Listing\\Product\\Variation\\Option')->getResource()->getMainTable();
     $collection->getSelect()->joinLeft(new \Zend_Db_Expr('(
             SELECT
                 mlpv.listing_product_id,
                 GROUP_CONCAT(`mlpvo`.`attribute`, \'==\', `mlpvo`.`product_id` SEPARATOR \'||\') as products_ids
             FROM `' . $lpvTable . '` as mlpv
             INNER JOIN `' . $lpvoTable . '` AS `mlpvo` ON (`mlpvo`.`listing_product_variation_id`=`mlpv`.`id`)
             WHERE `mlpv`.`component_mode` = \'amazon\'
             GROUP BY `mlpv`.`listing_product_id`
         )'), 'main_table.id=t.listing_product_id', array('products_ids' => 'products_ids'));
     //        TODO
     //        $collection->getSelect()->joinLeft(
     //            array('malpr' => Mage::getResourceModel('M2ePro/Amazon_Listing_Product_Repricing')->getMainTable()),
     //            '(`second_table`.`listing_product_id` = `malpr`.`listing_product_id`)',
     //            array(
     //                'is_repricing' => 'listing_product_id',
     //                'is_repricing_disabled' => 'is_online_disabled',
     //            )
     //        );
     // Set collection to grid
     $this->setCollection($collection);
     return parent::_prepareCollection();
 }
Пример #23
0
 protected function _prepareCollection()
 {
     $collection = $this->order->getChildObject()->getExternalTransactionsCollection();
     $this->setCollection($collection);
     return parent::_prepareCollection();
 }