Magento，sql，setup的方式添加一个select属性，add attribute selet by module sql

本文主要是介绍Magento，sql，setup的方式添加一个select属性，add attribute selet by module sql，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

1.

新建一个模块

Resource里面这么定义：

 <resources><wailian_setup><setup><module>Lon_Wailian</module><class>Mage_Catalog_Model_Resource_Setup</class></setup><connection><use>core_setup</use></connection></wailian_setup></resources>  

注意：在<setup>里面

<class>Mage_Catalog_Model_Resource_Setup</class>，这个一定要填写正确
Mage_Catalog_Model_Resource_Setup

2.数据库文件

<?php$installer = $this;
$installer->startSetup();//属性的Attribute Code，只能用字母和下划线，中间可以加入数字
$attribute_name = 'ccc';
//属性集中的group，和general等一个东西，是后台产品详细页面左侧的标签
$AttributeGroup = "sss";if(! ($this instanceof Mage_Catalog_Model_Resource_Setup) )
{throw new Exception("Resource Class needs to inherit from " ."Mage_Catalog_Model_Resource_Setup for this to work");
}
//属性定义
$attr = array ('attribute_model' => NULL,'backend' => '','type' => 'int','table' => '','frontend' => '','input' => 'select',  //Catalog Input Type for Store Owner'label' => 'bbb',  //label'frontend_class' => '','source' => '','required' => '0',  //Values Required'user_defined' => '1','default' => '','unique' => '0','note' => '','input_renderer' => NULL,'global' => '1',  //Scope'visible' => '1','searchable' => '1', //Use in Quick Search'filterable' => '1', //Use In Layered Navigation'comparable' => '1', //Comparable on Front-end'visible_on_front' => '0','is_html_allowed_on_front' => '0',  //Allow HTML Tags on Frontend'is_used_for_price_rules' => '1','filterable_in_search' => '1', //Use In Search Results Layered Navigation'used_in_product_listing' => '0', //Used in Product Listing'used_for_sort_by' => '0', //Used for Sorting in Product Listing'is_configurable' => '1', //Use To Create Configurable Product'apply_to' => 'simple', //Apply To *'visible_in_advanced_search' => '1', //Use in Advanced Search'position' => '1', //Position'wysiwyg_enabled' => '0','used_for_promo_rules' => '1','option' => array ('values' => array (0 => 'Green',1 => 'Silver',2 => 'Black',3 => 'Blue',4 => 'Red',5 => 'Pink',6 => 'Magneta',7 => 'Brown',8 => 'White',9 => 'Gray',),),
);
//新建属性
$this->addAttribute('catalog_product',$attribute_name,$attr);//下面的部分为把新建的属性加入属性集
//得到属性的id
$attributeId = $installer->getAttributeId('catalog_product',$attribute_name
);//得到属性集的id
$defaultSetId = $installer->getAttributeSetId('catalog_product', 'default');//在属性集里面新建group，也就是打开产品后，左边的标签，譬如general
$installer->addAttributeGroup('catalog_product',$defaultSetId,$AttributeGroup
);//得到新建的group的id
$groupId = $installer->getAttributeGroup('catalog_product',$defaultSetId,$AttributeGroup,'attribute_group_id'
);//把属性加入到属性集，并在上面新建的group中
if ($attributeId > 0) {$installer->addAttributeToSet('catalog_product',$defaultSetId,$groupId,$attributeId);
}//OK新建一个select属性到这里就完成了$installer->endSetup(); 

清空缓存，运行，就会建立起来属性了

这篇关于Magento，sql，setup的方式添加一个select属性，add attribute selet by module sql的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---