/**
* Save title of sample item in store scope
*
* @param Mage_Downloadable_Model_Sample $sampleObject
* @return Mage_Downloadable_Model_Mysql4_Sample
*/
public function saveItemTitle($sampleObject)
{
$stmt = $this->_getReadAdapter()->select()->from($this->getTable('downloadable/sample_title'))->where('sample_id = ?', $sampleObject->getId())->where('store_id = ?', $sampleObject->getStoreId());
if ($this->_getReadAdapter()->fetchOne($stmt)) {
$where = $this->_getReadAdapter()->quoteInto('sample_id = ?', $sampleObject->getId()) . ' AND ' . $this->_getReadAdapter()->quoteInto('store_id = ?', $sampleObject->getStoreId());
if ($sampleObject->getUseDefaultTitle()) {
$this->_getWriteAdapter()->delete($this->getTable('downloadable/sample_title'), $where);
} else {
$this->_getWriteAdapter()->update($this->getTable('downloadable/sample_title'), array('title' => $sampleObject->getTitle()), $where);
}
} else {
if (!$sampleObject->getUseDefaultTitle()) {
$this->_getWriteAdapter()->insert($this->getTable('downloadable/sample_title'), array('sample_id' => $sampleObject->getId(), 'store_id' => $sampleObject->getStoreId(), 'title' => $sampleObject->getTitle()));
}
}
return $this;
}
/**
* Delete data by item(s)
*
* @param Mage_Downloadable_Model_Sample|array|int $items
* @return Mage_Downloadable_Model_Resource_Sample
*/
public function deleteItems($items)
{
$writeAdapter = $this->_getWriteAdapter();
$where = '';
if ($items instanceof Mage_Downloadable_Model_Sample) {
$where = array('sample_id = ?' => $items->getId());
} else {
$where = array('sample_id in (?)' => $items);
}
if ($where) {
$writeAdapter->delete($this->getMainTable(), $where);
$writeAdapter->delete($this->getTable('downloadable/sample_title'), $where);
}
return $this;
}
/**
* Delete data by item(s)
*
* @param Mage_Downloadable_Model_Sample|array|int $items
* @return Mage_Downloadable_Model_Mysql4_Sample
*/
public function deleteItems($items)
{
$where = '';
if ($items instanceof Mage_Downloadable_Model_Sample) {
$where = $this->_getReadAdapter()->quoteInto('sample_id = ?', $items->getId());
} elseif (is_array($items)) {
$where = $this->_getReadAdapter()->quoteInto('sample_id in (?)', $items);
} else {
$where = $this->_getReadAdapter()->quoteInto('sample_id = ?', $items);
}
if ($where) {
$this->_getReadAdapter()->delete($this->getTable('downloadable/sample'), $where);
$this->_getReadAdapter()->delete($this->getTable('downloadable/sample_title'), $where);
}
return $this;
}
