Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Attribute_Backend_Media Class Reference

Inheritance diagram for Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Attribute_Backend_Media:

List of all members.

Public Member Functions
	loadGallery ($product, $object)
	insertGallery ($data)
	deleteGallery ($valueId)
	insertGalleryValueInStore ($data)
	deleteGalleryValueInStore ($valueId, $storeId)
	duplicate ($object, $newFiles, $originalProductId, $newProductId)
Public Attributes
const	GALLERY_TABLE = 'catalog/product_attribute_media_gallery'
const	GALLERY_VALUE_TABLE = 'catalog/product_attribute_media_gallery_value'
const	GALLERY_IMAGE_TABLE = 'catalog/product_attribute_media_gallery_image'
Protected Member Functions
	_construct ()
	_removeDuplicates (&$result)

---

Detailed Description

Definition at line 34 of file Media.php.

---

Member Function Documentation

_construct

(

)

[protected]

Resource initialization

Reimplemented from Mage_Core_Model_Resource_Abstract.

Definition at line 43 of file Media.php.

    {
        $this->_init(self::GALLERY_TABLE, 'value_id');
    }

_removeDuplicates

(

&$

result

)

[protected]

Definition at line 86 of file Media.php.

    {
        $fileToId = array();

        foreach (array_keys($result) as $index) {
            if (!isset($fileToId[$result[$index]['file']])) {
                $fileToId[$result[$index]['file']] = $result[$index]['value_id'];
            } elseif ($fileToId[$result[$index]['file']] != $result[$index]['value_id']) {
                $this->deleteGallery($result[$index]['value_id']);
                unset($result[$index]);
            }
        }

        $result = array_values($result);
        return $this;
    }

deleteGallery

(

$

valueId

)

Delete gallery value in db

Parameters:

array|integer

$valueId

Returns:

Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Attribute_Backend_Media

Definition at line 121 of file Media.php.

    {
        if (is_array($valueId) && count($valueId)>0) {
            $condition = $this->_getWriteAdapter()->quoteInto('value_id IN(?) ', $valueId);
        } elseif (!is_array($valueId)) {
            $condition = $this->_getWriteAdapter()->quoteInto('value_id = ? ', $valueId);
        } else {
            return $this;
        }

        $this->_getWriteAdapter()->delete($this->getMainTable(), $condition);
        return $this;
    }

deleteGalleryValueInStore	(	$	valueId,
		$	storeId
	)

Delete gallery value for store in db

Parameters:

	integer	$valueId
	integer	$storeId

Returns:

Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Attribute_Backend_Media

Definition at line 154 of file Media.php.

    {
        $this->_getWriteAdapter()->delete(
                $this->getTable(self::GALLERY_VALUE_TABLE),
                'value_id = ' . (int)$valueId  . ' AND store_id = ' . (int)$storeId
        );

        return $this;
    }

duplicate	(	$	object,
		$	newFiles,
		$	originalProductId,
		$	newProductId
	)

Duplicates gallery db values

Parameters:

	Mage_Catalog_Model_Product_Attribute_Backend_Media	$object
	array	$newFiles
	int	$originalProductId
	int	$newProductId

Returns:

Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Attribute_Backend_Media

Definition at line 173 of file Media.php.

    {
        $select = $this->_getReadAdapter()->select()
            ->from($this->getMainTable(), array('value_id', 'value'))
            ->where('attribute_id = ?', $object->getAttribute()->getId())
            ->where('entity_id = ?', $originalProductId);

        $valueIdMap = array();
        // Duplicate main entries of gallery
        foreach ($this->_getReadAdapter()->fetchAll($select) as $row) {
            $data = array(
                'attribute_id' => $object->getAttribute()->getId(),
                'entity_id'    => $newProductId,
                'value'        => (isset($newFiles[$row['value_id']]) ? $newFiles[$row['value_id']] : $row['value'])
            );

            $valueIdMap[$row['value_id']] = $this->insertGallery($data);
        }

        if (count($valueIdMap) == 0) {
            return $this;
        }

        // Duplicate per store gallery values
        $select = $this->_getReadAdapter()->select()
            ->from($this->getTable(self::GALLERY_VALUE_TABLE))
            ->where('value_id IN(?)', array_keys($valueIdMap));

        foreach ($this->_getReadAdapter()->fetchAll($select) as $row) {
            $row['value_id'] = $valueIdMap[$row['value_id']];
            $this->insertGalleryValueInStore($row);
        }

        return $this;
    }

insertGallery

(

$

data

)

Insert gallery value to db and retrive last id

Parameters:

array

$data

Returns:

interger

Definition at line 109 of file Media.php.

    {
        $this->_getWriteAdapter()->insert($this->getMainTable(), $data);
        return $this->_getWriteAdapter()->lastInsertId();
    }

insertGalleryValueInStore

(

$

data

)

Insert gallery value for store to db

Parameters:

array

$data

Returns:

Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Attribute_Backend_Media

Definition at line 141 of file Media.php.

    {
        $this->_getWriteAdapter()->insert($this->getTable(self::GALLERY_VALUE_TABLE), $data);
        return $this;
    }

loadGallery	(	$	product,
		$	object
	)

Load gallery images for product

Parameters:

	Mage_Catalog_Model_Product	$product
	Mage_Catalog_Model_Product_Attribute_Backend_Media	$object

Returns:

array

Definition at line 55 of file Media.php.

    {
        // Select gallery images for product
        $select = $this->_getReadAdapter()->select()
            ->from(
                array('main'=>$this->getMainTable()),
                array('value_id', 'value AS file')
            )
            ->joinLeft(
                array('value'=>$this->getTable(self::GALLERY_VALUE_TABLE)),
                'main.value_id=value.value_id AND value.store_id='.(int)$product->getStoreId(),
                array('label','position','disabled')
            )
            ->joinLeft( // Joining default values
                array('default_value'=>$this->getTable(self::GALLERY_VALUE_TABLE)),
                'main.value_id=default_value.value_id AND default_value.store_id=0',
                array(
                    'label_default' => 'label',
                    'position_default' => 'position',
                    'disabled_default' => 'disabled'
                )
            )
            ->where('main.attribute_id = ?', $object->getAttribute()->getId())
            ->where('main.entity_id = ?', $product->getId())
            ->order('IF(value.position IS NULL, default_value.position, value.position) ASC');

        $result = $this->_getReadAdapter()->fetchAll($select);
        $this->_removeDuplicates($result);
        return $result;
    }

---

Member Data Documentation

const GALLERY_IMAGE_TABLE = 'catalog/product_attribute_media_gallery_image'

Definition at line 41 of file Media.php.

const GALLERY_TABLE = 'catalog/product_attribute_media_gallery'

Gallery db tables

Definition at line 39 of file Media.php.

const GALLERY_VALUE_TABLE = 'catalog/product_attribute_media_gallery_value'

Definition at line 40 of file Media.php.

---

The documentation for this class was generated from the following file:

• app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Attribute/Backend/Media.php