Mage_Catalog_Model_Mysql4_Convert Class Reference

List of all members.

Public Member Functions
	getConnection ()
	getSelect ()
	getTable ($table)
	getProductEntity ($field=null)
	getSkuAttribute ($field='attribute_id')
	getProductIdBySku ($sku)
	addProductToStore ($productId, $storeId)
	exportAttributes ()
	exportAttributeSets ()
	exportAttributeOptions ()
	exportProductLinks ()
	exportProductsInCategories ()
	exportProductsInStores ()
	exportCategories ()
	exportProducts ()
	exportImageGallery ()
	getProductAttributeOption ($attribute, $value)
	importProducts (array $data)
Protected Attributes
	$_productsBySku
	$_productEntity
	$_skuAttribute

---

Detailed Description

Definition at line 28 of file Catalogold.php.

---

Member Function Documentation

addProductToStore	(	$	productId,
		$	storeId
	)

Definition at line 81 of file Catalogold.php.

    {
        $write = $this->getConnection();
        $table = $this->getTable('catalog/product_store');
        try {
            if (!$write->fetchOne("select * from $table where product_id=".(int)$productId." and store_id=".(int)$storeId)) {
               $write->query("insert into $table (product_id, store_id) values (".(int)$productId.",".(int)$storeId.")");
            }
        } catch (Exception $e) {
            throw $e;
        }
        return $this;
    }

exportAttributeOptions

(

)

Definition at line 134 of file Catalogold.php.

    {
        $select = $this->getSelect()
            ->from(array('et'=>$this->getTable('eav/entity_type')), 'entity_type_code')
            ->join(array('a'=>$this->getTable('eav/attribute')), 'a.entity_type_id=et.entity_type_id', 'attribute_code')
            ->join(array('ao'=>$this->getTable('eav/attribute_option')), 'ao.attribute_id=a.attribute_id', array())
            ->where('et.entity_type_code in (?)', array('catalog_product', 'catalog_category'))
            ->order('a.attribute_code')->order('ao.sort_order');

        $stores = Mage::getConfig()->getNode('stores')->children();
        foreach ($stores as $storeName=>$storeConfig) {
            $select->joinLeft(
                array($storeName=>$this->getTable('eav/attribute_option_value')),
                "$storeName.option_id=ao.option_id and $storeName.store_id=".$storeConfig->descend('system/store/id'),
                array($storeName=>"$storeName.value")
            );
        }

        $options = $this->getConnection()->fetchAll($select);

        return $options;
    }

exportAttributes

(

)

Definition at line 95 of file Catalogold.php.

    {
        $attributeFields = array(
            'attribute_code',
            'frontend_label', 'frontend_input', 'frontend_class', 'frontend_model',
            'backend_type', 'backend_table', 'backend_model',
            'source_model', 'attribute_model',
            'is_visible', 'is_user_defined', 'is_global', 'is_required', 'is_unique',
            'is_visible_on_front', 'is_searchable', 'is_filterable', 'is_comparable',
            'default_value', 'apply_to', 'use_in_super_product',
        );

        $select = $this->getSelect()
            ->from(array('et'=>$this->getTable('eav/entity_type')), 'entity_type_code')
            ->join(array('a'=>$this->getTable('eav/attribute')), 'a.entity_type_id=et.entity_type_id', $attributeFields)
            ->where('et.entity_type_code in (?)', array('catalog_product', 'catalog_category'))
            ->order('if(not a.is_user_defined, 1, 2)')->order('attribute_code');

        $attributes = $this->getConnection()->fetchAll($select);

        return $attributes;
    }

exportAttributeSets

(

)

Definition at line 118 of file Catalogold.php.

    {
        $select = $this->getSelect()
            ->from(array('et'=>$this->getTable('eav/entity_type')), 'entity_type_code')
            ->join(array('s'=>$this->getTable('eav/attribute_set')), 's.entity_type_id=et.entity_type_id', 'attribute_set_name')
            ->join(array('g'=>$this->getTable('eav/attribute_group')), 'g.attribute_set_id=s.attribute_set_id', 'attribute_group_name')
            ->join(array('ea'=>$this->getTable('eav/entity_attribute')), 'ea.attribute_group_id=g.attribute_group_id', array())
            ->join(array('a'=>$this->getTable('eav/attribute')), 'a.attribute_id=ea.attribute_id', 'attribute_code')
            ->where('et.entity_type_code in (?)', array('catalog_product', 'catalog_category'))
            ->order('et.entity_type_code')->order('s.sort_order')->order('g.sort_order');

        $sets = $this->getConnection()->fetchAll($select);

        return $sets;
    }

exportCategories

(

)

Definition at line 204 of file Catalogold.php.

    {
        $collection = Mage::getResourceModel('catalog/category_collection')
            ->addAttributeToSelect('*')
            ->load();

        $categories = array();
        foreach ($collection as $object) {
            $row = $object->getData();
            $categories[] = $row;
        }

        return $categories;
    }

exportImageGallery

(

)

Definition at line 252 of file Catalogold.php.

    {
        return array();
    }

exportProductLinks

(

)

Definition at line 157 of file Catalogold.php.

    {
        $skuTable = $this->getTable('catalog/product').'_'.$this->getSkuAttribute('backend_type');
        $skuCond = ' and sku.store_id=0 and sku.attribute_id='.$this->getSkuAttribute('attribute_id');

        $select = $this->getSelect()
            ->from(array('lt'=>$this->getTable('catalog/product_link_type')), array('link_type'=>'code'))
            ->join(array('l'=>$this->getTable('catalog/product_link')), 'l.link_type_id=lt.link_type_id', array())
            ->join(array('sku'=>$skuTable), 'sku.entity_id=l.product_id'.$skuCond, array('sku'=>'value'))
            ->join(array('linked'=>$skuTable), 'linked.entity_id=l.product_id'.$skuCond, array('linked'=>'value'))
            ->order('sku')->order('link_type');
        $links = $this->getConnection()->fetchAll($select);

        return $links;
    }

exportProducts

(

)

Definition at line 219 of file Catalogold.php.

    {
        $attrSets = Mage::getResourceModel('eav/entity_attribute_set_collection')->load();
        $attrSetName = array();
        foreach ($attrSets as $attrSet) {
            $attrSetName[$attrSet->getId()] = $attrSet->getAttributeSetName();
        }

        $select = $this->getSelect()
            ->from(array('ao'=>$this->getTable('eav/attribute_option')), array('attribute_id', 'option_id'))
            ->join(array('aov'=>$this->getTable('eav/attribute_option_value')), 'aov.option_id=ao.option_id', array('value_id', 'value'))
            ->where('aov.store_id=0');

        echo $select->__toString();
        die();

        $collection = Mage::getResourceModel('catalog/product_collection')
            ->addAttributeToSelect('*')
            ->load();

        $products = array();
        foreach ($collection as $object) {
            $r = $object->getData();

            unset($r['entity_id'], $r['entity_type_id']);
            $r['attribute_set_id'] = $attrSetName[$r['attribute_set_id']];

            $products[] = $r;
        }

        return $products;
    }

exportProductsInCategories

(

)

Definition at line 173 of file Catalogold.php.

    {
        $skuTable = $this->getTable('catalog/product').'_'.$this->getSkuAttribute('backend_type');
        $skuCond = ' and sku.store_id=0 and sku.attribute_id='.$this->getSkuAttribute('attribute_id');

        $select = $this->getSelect()
            ->from(array('cp'=>$this->getTable('catalog/category_product')), array('category_id', 'position'))
            ->join(array('sku'=>$skuTable), 'sku.entity_id=cp.product_id'.$skuCond, array('sku'=>'value'))
            ->order('category_id')->order('position')->order('sku');

        $prodCats = $this->getConnection()->fetchAll($select);

        return $prodCats;
    }

exportProductsInStores

(

)

Definition at line 188 of file Catalogold.php.

    {
        $skuTable = $this->getTable('catalog/product').'_'.$this->getSkuAttribute('backend_type');
        $skuCond = ' and sku.store_id=0 and sku.attribute_id='.$this->getSkuAttribute('attribute_id');

        $select = $this->getSelect()
            ->from(array('ps'=>$this->getTable('catalog/product_store')), array())
            ->join(array('s'=>$this->getTable('core/store')), 's.store_id=ps.store_id', array('store'=>'code'))
            ->join(array('sku'=>$skuTable), 'sku.entity_id=ps.product_id'.$skuCond, array('sku'=>'value'))
            ->order('store')->order('sku');

        $prodStores = $this->getConnection()->fetchAll($select);

        return $prodStores;
    }

getConnection

(

)

Definition at line 34 of file Catalogold.php.

    {
        return Mage::getSingleton('core/resource')->getConnection('catalog_write');
    }

getProductAttributeOption	(	$	attribute,
		$	value
	)

Definition at line 257 of file Catalogold.php.

    {
        #$attribute = Mage::get
    }

getProductEntity

(

$

field = null

)

Definition at line 49 of file Catalogold.php.

    {
        if (!$this->_productEntity) {
            $this->_productEntity = Mage::getResourceModel('catalog/product')
                ->loadAllAttributes();
        }
        return is_null($field) ? $this->_productEntity : $this->_productEntity->getData($field);
    }

getProductIdBySku

(

$

sku

)

Definition at line 66 of file Catalogold.php.

    {
        if (!$this->_productsBySku) {
            $select = $this->getSelect()
                ->from($this->getTable('catalog/product'), array('entity_id', 'sku'));
            $products = $this->getConnection()->fetchAll($select);

            $this->_productsBySku = array();
            foreach ($products as $p) {
                $this->_productsBySku[$p['sku']] = $p['entity_id'];
            }
        }
        return isset($this->_productsBySku[$sku]) ? $this->_productsBySku[$sku] : false;
    }

getSelect

(

)

Definition at line 39 of file Catalogold.php.

    {
        return $this->getConnection()->select();
    }

getSkuAttribute

(

$

field = 'attribute_id'

)

Definition at line 58 of file Catalogold.php.

    {
        if (!$this->_skuAttribute) {
            $this->_skuAttribute = $this->getProductEntity()->getAttribute('sku');
        }
        return $this->_skuAttribute->getData($field);
    }

getTable

(

$

table

)

Definition at line 44 of file Catalogold.php.

    {
        return Mage::getSingleton('core/resource')->getTableName($table);
    }

importProducts

(

array $

data

)

Definition at line 262 of file Catalogold.php.

    {
        /*
        $entity = Mage::getResourceModel('catalog/product')
           ->loadAllAttributes();

        $options =

        foreach ($data as $row) {
            if (empty($row['sku'])) {
                continue;
            }
            $sku = $row['sku'];
        }
        */
    }

---

Member Data Documentation

$_productEntity [protected]

Definition at line 31 of file Catalogold.php.

$_productsBySku [protected]

Definition at line 30 of file Catalogold.php.

$_skuAttribute [protected]

Definition at line 32 of file Catalogold.php.

---

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

• app/code/core/Mage/Dataflow/Model/Mysql4/Catalogold.php