/** * Add events log to a collection * The collection id field is used without corellation, so it must be unique. * DESC ordering by event will be added to the collection * * @param \Magento\Framework\Data\Collection\Db $collection * @param int $eventTypeId * @param int $eventSubjectId * @param int $subtype * @param array $skipIds * @return $this */ public function applyLogToCollection(\Magento\Framework\Data\Collection\Db $collection, $eventTypeId, $eventSubjectId, $subtype, $skipIds = []) { $idFieldName = $collection->getResource()->getIdFieldName(); $derivedSelect = $this->getReadConnection()->select()->from($this->getTable('report_event'), ['event_id' => new \Zend_Db_Expr('MAX(event_id)'), 'object_id'])->where('event_type_id = ?', (int) $eventTypeId)->where('subject_id = ?', (int) $eventSubjectId)->where('subtype = ?', (int) $subtype)->where('store_id IN(?)', $this->getCurrentStoreIds())->group('object_id'); if ($skipIds) { if (!is_array($skipIds)) { $skipIds = [(int) $skipIds]; } $derivedSelect->where('object_id NOT IN(?)', $skipIds); } $collection->getSelect()->joinInner(['evt' => new \Zend_Db_Expr("({$derivedSelect})")], "{$idFieldName} = evt.object_id", [])->order('evt.event_id ' . \Magento\Framework\DB\Select::SQL_DESC); return $this; }
/** * @param \Magento\Framework\Data\Collection\EntityFactory $entityFactory * @param \Psr\Log\LoggerInterface $logger * @param \Magento\Framework\Data\Collection\Db\FetchStrategyInterface $fetchStrategy * @param \Magento\Framework\App\Resource $resource */ public function __construct(\Magento\Framework\Data\Collection\EntityFactory $entityFactory, \Psr\Log\LoggerInterface $logger, \Magento\Framework\Data\Collection\Db\FetchStrategyInterface $fetchStrategy, \Magento\Framework\App\Resource $resource) { $this->_setIdFieldName('primary_id'); parent::__construct($entityFactory, $logger, $fetchStrategy, $resource->getConnection('review_read')); $this->_summaryTable = $resource->getTableName('review_entity_summary'); $this->_select->from($this->_summaryTable); $this->setItemObjectClass('Magento\\Review\\Model\\Review\\Summary'); }
/** * @param EntityFactory $entityFactory * @param Logger $logger * @param FetchStrategyInterface $fetchStrategy * @param ManagerInterface $eventManager * @param Order $resource * @param \Magento\Store\Model\Resource\Store\CollectionFactory $storeCollectionFactory * @param \Magento\Store\Model\StoreManagerInterface $storeManager */ public function __construct(EntityFactory $entityFactory, Logger $logger, FetchStrategyInterface $fetchStrategy, ManagerInterface $eventManager, Order $resource, \Magento\Store\Model\Resource\Store\CollectionFactory $storeCollectionFactory, StoreManagerInterface $storeManager) { $this->_eventManager = $eventManager; $this->_orderResource = $resource; $this->_storeCollectionFactory = $storeCollectionFactory; $this->_storeManager = $storeManager; parent::__construct($entityFactory, $logger, $fetchStrategy, $this->_orderResource->getReadConnection()); }
public function testToOptionHash() { $data = [10 => 'test']; $adapterMock = $this->getMock('Zend_Db_Adapter_Pdo_Mysql', ['select', 'query'], [], '', false); $selectMock = $this->getMock('Magento\\Framework\\DB\\Select', [], ['adapter' => $adapterMock]); $adapterMock->expects($this->once())->method('select')->will($this->returnValue($selectMock)); $this->fetchStrategyMock->expects($this->once())->method('fetchAll')->with($selectMock, [])->will($this->returnValue([$data])); $objectMock = $this->getMock('Magento\\Framework\\Object', ['addData', 'setIdFieldName', 'getData'], []); $objectMock->expects($this->once())->method('addData')->with($data); $objectMock->expects($this->any())->method('getData')->will($this->returnValueMap([[null, null, 10], ['name', null, 'test']])); $this->entityFactoryMock->expects($this->once())->method('create')->with('Magento\\Framework\\Object')->will($this->returnValue($objectMock)); $this->collection->setConnection($adapterMock); $this->collection->loadData(false, false); $this->collection->loadData(false, false); $this->assertEquals($data, $this->collection->toOptionHash()); }
/** * Retrieve number of loaded stores * * @return int */ public function countStores() { return sizeof($this->_stores->getItems()); }
/** * Remove item from collection by item key * * @param mixed $key * @return $this */ public function removeItemByKey($key) { if (isset($this->_items[$key])) { unset($this->_itemsById[$this->_items[$key]->getId()]); } return parent::removeItemByKey($key); }
/** * Redeclare after load method for specifying collection items original data * * @return $this */ protected function _afterLoad() { parent::_afterLoad(); foreach ($this->_items as $item) { $item->setOrigData(); if ($this->_resetItemsDataChanged) { $item->setDataChanges(false); } } $this->_eventManager->dispatch('core_collection_abstract_load_after', array('collection' => $this)); if ($this->_eventPrefix && $this->_eventObject) { $this->_eventManager->dispatch($this->_eventPrefix . '_load_after', array($this->_eventObject => $this)); } return $this; }