Magento 快速保存产品属性的代码 - 不能更新flat表

//********product save model*********//
    function updateAttribute($id,$values,$attribute,$tablename){
    	$connection		= $this->_getConnection('core_write');
    	$newvalues		= $values;
    	$productId		= $id;
    	$attributeId	= $this->_getAttributeId($attribute);
    	if($this->_checkIfIdExists($productId)){
    		$sql = "UPDATE " . $this->_getTableName($tablename) . " cped
    				SET  cped.value = ?
    			WHERE  cped.attribute_id = ?
    			AND cped.entity_id = ?";
    		$connection->query($sql, array($newvalues, $attributeId, $productId));
    		return 1;
    	}else{
    		return 0;
    	}
    	
    }
    //得到magento的链接,用于操作数据库。
    function _getConnection($type = 'core_read'){
    	return Mage::getSingleton('core/resource')->getConnection($type);
    }	
    //得到table的name
    function _getTableName($tableName){
    	return Mage::getSingleton('core/resource')->getTableName($tableName);
    }
    //通过code值,得到属性的id
    function _getAttributeId($attribute_code){
    	$connection = $this->_getConnection('core_read');
    	$sql = "SELECT attribute_id
    				FROM " .$this->_getTableName('eav_attribute') . "
    			WHERE
    				entity_type_id = ?
    				AND attribute_code = ?";
    	$entity_type_id = $this->_getEntityTypeId();
    	return $connection->fetchOne($sql, array($entity_type_id, $attribute_code));
    }
    //得到eav类型的id
    function _getEntityTypeId($entity_type_code = 'catalog_product'){
    	$connection = $this->_getConnection('core_read');
    	$sql		= "SELECT entity_type_id FROM " . $this->_getTableName('eav_entity_type') . " WHERE entity_type_code = ?";
    	return $connection->fetchOne($sql, array($entity_type_code));
    }
    //检查sku是否存在。
    function _checkIfIdExists($id){
    	$connection = $this->_getConnection('core_read');
    	$sql		= "SELECT COUNT(*) AS count_no FROM " . $this->_getTableName('catalog_product_entity') . "	WHERE entity_id = ?";
    	$count		= $connection->fetchOne($sql, array($id));
    	if($count > 0){
    		return true;
    	}else{
    		return false;
    	}
    }

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值