/**
* 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;
}
