/** * Save title of sample item in store scope * * @param \Magento\Downloadable\Model\Sample $sampleObject * @return $this */ public function saveItemTitle($sampleObject) { $writeAdapter = $this->_getWriteAdapter(); $sampleTitleTable = $this->getTable('downloadable_sample_title'); $bind = array(':sample_id' => $sampleObject->getId(), ':store_id' => (int) $sampleObject->getStoreId()); $select = $writeAdapter->select()->from($sampleTitleTable)->where('sample_id=:sample_id AND store_id=:store_id'); if ($writeAdapter->fetchOne($select, $bind)) { $where = array('sample_id = ?' => $sampleObject->getId(), 'store_id = ?' => (int) $sampleObject->getStoreId()); if ($sampleObject->getUseDefaultTitle()) { $writeAdapter->delete($sampleTitleTable, $where); } else { $writeAdapter->update($sampleTitleTable, array('title' => $sampleObject->getTitle()), $where); } } else { if (!$sampleObject->getUseDefaultTitle()) { $writeAdapter->insert($sampleTitleTable, array('sample_id' => $sampleObject->getId(), 'store_id' => (int) $sampleObject->getStoreId(), 'title' => $sampleObject->getTitle())); } } return $this; }
/** * Save title of sample item in store scope * * @param \Magento\Downloadable\Model\Sample $sampleObject * @return $this */ public function saveItemTitle($sampleObject) { $connection = $this->getConnection(); $sampleTitleTable = $this->getTable('downloadable_sample_title'); $bind = [':sample_id' => $sampleObject->getId(), ':store_id' => (int) $sampleObject->getStoreId()]; $select = $connection->select()->from($sampleTitleTable)->where('sample_id=:sample_id AND store_id=:store_id'); if ($connection->fetchOne($select, $bind)) { $where = ['sample_id = ?' => $sampleObject->getId(), 'store_id = ?' => (int) $sampleObject->getStoreId()]; if ($sampleObject->getUseDefaultTitle()) { $connection->delete($sampleTitleTable, $where); } else { $connection->update($sampleTitleTable, ['title' => $sampleObject->getTitle()], $where); } } else { if (!$sampleObject->getUseDefaultTitle()) { $connection->insert($sampleTitleTable, ['sample_id' => $sampleObject->getId(), 'store_id' => (int) $sampleObject->getStoreId(), 'title' => $sampleObject->getTitle()]); } } return $this; }