Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Type_Configurable Class Reference

Inheritance diagram for Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Type_Configurable:

List of all members.

Public Member Functions
	saveProducts ($mainProductId, $productIds)
	getChildrenIds ($parentId, $required=true)
	getParentIdsByChild ($childId)
Protected Member Functions
	_construct ()

---

Detailed Description

Definition at line 34 of file Configurable.php.

---

Member Function Documentation

_construct

(

)

[protected]

Init resource

Reimplemented from Mage_Core_Model_Resource_Abstract.

Definition at line 40 of file Configurable.php.

    {
        $this->_init('catalog/product_super_link', 'link_id');
    }

getChildrenIds	(	$	parentId,
		$	required = true
	)

Retrieve Required children ids Return grouped array, ex array( group => array(ids) )

Parameters:

	int	$parentId
	bool	$required

Returns:

array

Definition at line 76 of file Configurable.php.

    {
        $childrenIds = array();
        $select = $this->_getReadAdapter()->select()
            ->from(array('l' => $this->getMainTable()), array('product_id', 'parent_id'))
            ->join(
                array('e' => $this->getTable('catalog/product')),
                'e.entity_id=l.product_id AND e.required_options=0',
                array()
            )
            ->where('parent_id=?', $parentId);

        $childrenIds = array(0 => array());
        foreach ($this->_getReadAdapter()->fetchAll($select) as $row) {
            $childrenIds[0][$row['product_id']] = $row['product_id'];
        }

        return $childrenIds;
    }

getParentIdsByChild

(

$

childId

)

Retrieve parent ids array by requered child

Parameters:

int|array

$childId

Returns:

array

Definition at line 102 of file Configurable.php.

    {
        $parentIds = array();

        $select = $this->_getReadAdapter()->select()
            ->from($this->getMainTable(), array('product_id', 'parent_id'))
            ->where('product_id IN(?)', $childId);
        foreach ($this->_getReadAdapter()->fetchAll($select) as $row) {
            $parentIds[] = $row['parent_id'];
        }

        return $parentIds;
    }

saveProducts	(	$	mainProductId,
		$	productIds
	)

Save product

Parameters:

	int	$mainProductId the parent id
	array	$productIds the children id array

Returns:

Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Type_Configurable

Definition at line 52 of file Configurable.php.

    {
        $this->_getWriteAdapter()->delete($this->getMainTable(),
            $this->_getWriteAdapter()->quoteInto('parent_id=?', $mainProductId)
        );
        foreach ($productIds as $productId) {
            $this->_getWriteAdapter()->insert($this->getMainTable(), array(
               'product_id'    => $productId,
               'parent_id'     => $mainProductId
            ));
        }
        return $this;
    }

---

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

• app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Type/Configurable.php