public function addAttribute($entityTypeId, $code, array $attr) { if (isset($this->_flatEntityTables[$entityTypeId]) && $this->_flatTableExist($this->_flatEntityTables[$entityTypeId])) { $this->_addFlatAttribute($this->_flatEntityTables[$entityTypeId], $code, $attr); } else { parent::addAttribute($entityTypeId, $code, $attr); } return $this; }
<?php /** @var $this Mage_Core_Model_Resource_Setup */ $_installer = $this; $_installer->startSetup(); $_setup = new Mage_Eav_Model_Entity_Setup('core_setup'); try { $_setup->removeAttribute('catalog_product', 'allow_shipping'); } catch (Exception $_e) { Mage::logException($_e); } $_setup->addAttribute(Mage_Catalog_Model_Product::ENTITY, 'allow_shipping', array('group' => 'Rental Shipping Method', 'type' => 'int', 'backend' => '', 'frontend' => '', 'label' => 'Customer can chose Shipping Method on Product Page', 'input' => 'select', 'source' => 'eav/entity_attribute_source_boolean', 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL, 'is_visible' => true, 'required' => false, 'user_defined' => true, 'default' => '', 'is_searchable' => false, 'is_filterable' => false, 'is_comparable' => false, 'is_visible_on_front' => true, 'is_visible_in_advanced_search' => false, 'is_used_in_product_listing' => false, 'unique' => false)); $_installer->endSetup();
* @package RewardsPoint2 * @copyright Copyright (c) 2009 J2T DESIGN. (http://www.j2t-design.com) * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) */ $installer = $this; $attributeInfoFb = Mage::getResourceModel('eav/entity_attribute_collection')->setCodeFilter('rewardsocial_facebook')->getFirstItem(); $attributeInfoGp = Mage::getResourceModel('eav/entity_attribute_collection')->setCodeFilter('rewardsocial_google')->getFirstItem(); $attributeInfoTt = Mage::getResourceModel('eav/entity_attribute_collection')->setCodeFilter('rewardsocial_twitter')->getFirstItem(); $entityTypeId = Mage::getModel('eav/entity')->setType('catalog_product')->getTypeId(); $attributeGroup = Mage::getResourceModel('eav/entity_attribute_set_collection')->addFieldToFilter('attribute_set_name', array('eq' => 'Default'))->addFieldToFilter('entity_type_id', array('eq' => $entityTypeId))->getFirstItem(); if (!$attributeGroup->getAttributeSetId()) { $installer->addAttributeSet(Mage_Catalog_Model_Product::ENTITY, 'Default'); $attributeGroup = Mage::getResourceModel('eav/entity_attribute_set_collection')->addFieldToFilter('attribute_set_name', array('eq' => 'Default'))->addFieldToFilter('entity_type_id', array('eq' => $entityTypeId))->getFirstItem(); } if (!$attributeInfoFb->getAttributeId() && !$attributeInfoGp->getAttributeId() && !$attributeInfoTt->getAttributeId() && $attributeGroup->getAttributeSetId()) { $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $installer->startSetup(); /** * Adding Different Attributes */ // adding attribute group $setup->addAttributeGroup('catalog_product', 'Default', 'J2T Reward Social', 1000); $entityTypeId = $installer->getEntityTypeId('catalog_product'); $attributeSetId = $installer->getDefaultAttributeSetId($entityTypeId); $attributeGroupId = $installer->getDefaultAttributeGroupId($entityTypeId, $attributeSetId); // the attribute added will be displayed under the group/tab Special Attributes in product edit page $setup->addAttribute('catalog_product', 'rewardsocial_facebook', array('group' => 'J2T Reward Social', 'input' => 'text', 'type' => 'text', 'label' => 'Facebook Like Points', 'frontend_class' => 'validate-digits', 'backend' => '', 'visible' => 1, 'required' => 0, 'user_defined' => 0, 'searchable' => 0, 'filterable' => 0, 'comparable' => 0, 'visible_on_front' => 0, 'visible_in_advanced_search' => 0, 'is_html_allowed_on_front' => 0, 'used_in_product_listing' => true, 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL)); $setup->addAttribute('catalog_product', 'rewardsocial_google', array('group' => 'J2T Reward Social', 'input' => 'text', 'type' => 'text', 'label' => 'Google + Points', 'frontend_class' => 'validate-digits', 'backend' => '', 'visible' => 1, 'required' => 0, 'user_defined' => 0, 'searchable' => 0, 'filterable' => 0, 'comparable' => 0, 'visible_on_front' => 0, 'visible_in_advanced_search' => 0, 'is_html_allowed_on_front' => 0, 'used_in_product_listing' => true, 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL)); $setup->addAttribute('catalog_product', 'rewardsocial_twitter', array('group' => 'J2T Reward Social', 'input' => 'text', 'type' => 'text', 'label' => 'Twitter Share Points', 'frontend_class' => 'validate-digits', 'backend' => '', 'visible' => 1, 'required' => 0, 'user_defined' => 0, 'searchable' => 0, 'filterable' => 0, 'comparable' => 0, 'visible_on_front' => 0, 'visible_in_advanced_search' => 0, 'is_html_allowed_on_front' => 0, 'used_in_product_listing' => true, 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL)); $installer->endSetup(); }
* on any other Magento edition except Magento enterprise edition. * aheadWorks does not provide extension support in case of * incorrect edition usage. * ================================================================= * * @category AW * @package AW_Onsale * @version 2.4.0 * @copyright Copyright (c) 2010-2012 aheadWorks Co. (http://www.aheadworks.com) * @license http://ecommerce.aheadworks.com/AW-LICENSE.txt */ $installer = $this; $installer->startSetup(); $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $setup->removeAttribute('catalog_product', 'aw_os_product_display'); $setup->removeAttribute('catalog_product', 'aw_os_product_position'); $setup->removeAttribute('catalog_product', 'aw_os_product_image'); $setup->removeAttribute('catalog_product', 'aw_os_product_text'); $setup->removeAttribute('catalog_product', 'aw_os_category_display'); $setup->removeAttribute('catalog_product', 'aw_os_category_position'); $setup->removeAttribute('catalog_product', 'aw_os_category_image'); $setup->removeAttribute('catalog_product', 'aw_os_category_text'); $setup->addAttribute('catalog_product', 'aw_os_product_display', array('backend' => 'onsale/entity_attribute_backend_boolean_config', 'source' => 'onsale/entity_attribute_source_boolean_config', 'label' => 'Display', 'group' => 'Product Label', 'input' => 'select', 'class' => 'validate-digit', 'global' => true, 'visible' => true, 'required' => true, 'user_defined' => false, 'default' => '0', 'visible_on_front' => false)); $setup->addAttribute('catalog_product', 'aw_os_product_position', array('backend' => 'onsale/entity_attribute_backend_position', 'source' => 'onsale/entity_attribute_source_position', 'label' => 'Position', 'group' => 'Product Label', 'input' => 'select', 'class' => 'validate-digit', 'global' => true, 'visible' => true, 'required' => true, 'user_defined' => false, 'default' => 'BR', 'visible_on_front' => false)); $setup->addAttribute('catalog_product', 'aw_os_product_image', array('backend' => 'onsale/entity_attribute_backend_image', 'label' => 'Image', 'group' => 'Product Label', 'input' => 'image', 'class' => 'validate-digit', 'global' => true, 'visible' => true, 'required' => false, 'user_defined' => false, 'default' => '', 'visible_on_front' => false)); $setup->addAttribute('catalog_product', 'aw_os_product_text', array('source' => 'onsale/entity_attribute_source_text', 'group' => 'Product Label', 'label' => 'Text', 'note' => 'You can use predefined values in this field. Please refer to extension manual.', 'input' => 'text', 'class' => '', 'global' => true, 'visible' => true, 'required' => false, 'user_defined' => false, 'default' => 'CUSTOM', 'visible_on_front' => false)); $setup->addAttribute('catalog_product', 'aw_os_category_display', array('backend' => 'onsale/entity_attribute_backend_boolean_config', 'source' => 'onsale/entity_attribute_source_boolean_config', 'label' => 'Display', 'group' => 'Category Label', 'input' => 'select', 'class' => 'validate-digit', 'global' => true, 'visible' => true, 'required' => true, 'user_defined' => false, 'default' => '0', 'visible_on_front' => false)); $setup->addAttribute('catalog_product', 'aw_os_category_position', array('backend' => 'onsale/entity_attribute_backend_position', 'source' => 'onsale/entity_attribute_source_position', 'label' => 'Position', 'group' => 'Category Label', 'input' => 'select', 'class' => 'validate-digit', 'global' => true, 'visible' => true, 'required' => true, 'user_defined' => false, 'default' => 'BR', 'visible_on_front' => false)); $setup->addAttribute('catalog_product', 'aw_os_category_image', array('backend' => 'onsale/entity_attribute_backend_image', 'label' => 'Image', 'group' => 'Category Label', 'input' => 'image', 'class' => 'validate-digit', 'global' => true, 'visible' => true, 'required' => false, 'user_defined' => false, 'default' => '', 'visible_on_front' => false)); $setup->addAttribute('catalog_product', 'aw_os_category_text', array('source' => 'onsale/entity_attribute_source_text', 'group' => 'Category Label', 'label' => 'Text', 'note' => 'You can use predefined values in this field. Please refer to extension manual.', 'input' => 'text', 'class' => '', 'global' => true, 'visible' => true, 'required' => false, 'user_defined' => false, 'default' => 'CUSTOM', 'visible_on_front' => false)); $installer->endSetup();
<?php /** * Pan_JewelryDesigner Extension * * @category Pan * @package Pan_JewelryDesigner * @copyright Copyright (c) 2014 August Ash, Inc. (http://www.augustash.com) * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) * @author August Ash Team <*****@*****.**> */ $installer = new Mage_Eav_Model_Entity_Setup(); // start transaction $installer->startSetup(); /** * Is Dangle Charm (is_dangle_charm) * * Helps identify beads that are "danglers" b/c their * registration point should be closer to the top than * the center of the image */ $installer->addAttribute(Mage_Catalog_Model_Product::ENTITY, 'is_dangle_charm', array('group' => 'Jewelry Designer', 'input' => 'boolean', 'label' => 'Is Dangle Charm?', 'visible' => true, 'required' => false, 'visible_on_front' => false, 'user_defined' => true, 'default_value' => false, 'used_in_product_listing' => true, 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL)); /** * Bracelet has spots for clips? (bracelet_has_clip_spots) * * Helps identify bracelets that may not have spots for clips * and therefore do not have exclusion zones */ $installer->addAttribute(Mage_Catalog_Model_Product::ENTITY, 'bracelet_has_clip_spots', array('group' => 'Jewelry Designer', 'input' => 'boolean', 'label' => 'Bracelet has spots for clips?', 'visible' => true, 'required' => false, 'visible_on_front' => false, 'user_defined' => true, 'default_value' => true, 'used_in_product_listing' => true, 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL)); // end transaction $installer->endSetup();
<?php /** * Mirasvit * * This source file is subject to the Mirasvit Software License, which is available at http://mirasvit.com/license/. * Do not edit or add to this file if you wish to upgrade the to newer versions in the future. * If you wish to customize this module for your needs * Please refer to http://www.magentocommerce.com for more information. * * @category Mirasvit * @package Sphinx Search Ultimate * @version 2.3.1 * @revision 602 * @copyright Copyright (C) 2013 Mirasvit (http://mirasvit.com/) */ //2.2.9 - 2.2.9.1 $installer = $this; $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $installer->startSetup(); try { $setup->addAttribute('catalog_category', 'searchindex_weight', array('group' => 'General Information', 'input' => 'text', 'type' => 'text', 'label' => 'Search Weight', 'backend' => '', 'visible' => 1, 'required' => 0, 'user_defined' => 1, 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE)); $setup->addAttribute('catalog_product', 'searchindex_weight', array('group' => 'General', 'input' => 'text', 'type' => 'text', 'label' => 'Search Weight', 'backend' => '', 'visible' => 1, 'required' => 0, 'user_defined' => 1, 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE)); } catch (Exception $e) { Mage::logException($e); } $installer->endSetup();
public function testAction() { $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $entity_type = Mage::getSingleton("eav/entity_type")->loadByCode("catalog_product"); $entity_type_id = $entity_type->getId(); $collection = Mage::getModel("eav/entity_attribute")->getCollection()->addFieldToFilter("entity_type_id", $entity_type_id)->addFieldToFilter("attribute_code", "giftwrap"); if (count($collection)) { $collection->getFirstItem()->delete(); } if (!count($collection)) { $data = array('group' => 'General', 'type' => 'int', 'input' => 'select', 'label' => 'Wrappable', 'backend' => '', 'frontend' => '', 'source' => 'giftwrap/attribute_wrappable', 'visible' => 1, 'required' => 1, 'user_defined' => 1, 'is_searchable' => 1, 'is_filterable' => 0, 'is_comparable' => 1, 'is_visible_on_front' => 0, 'is_visible_in_advanced_search' => 1, 'used_for_sort_by' => 0, 'used_in_product_listing' => 1, 'used_for_price_rules' => 1, 'is_used_for_promo_rules' => 1, 'position' => 2, 'unique' => 0, 'is_configurable' => 1, 'default' => 0, 'is_global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE); $setup->addAttribute('catalog_product', 'giftwrap', $data); $entity_type_id = $setup->getEntityTypeId('catalog_product'); $data['entity_type_id'] = $entity_type_id; $attribute = Mage::getModel("eav/entity_attribute")->setData($data)->setId($setup->getAttributeId('catalog_product', 'giftwrap')); $attribute->save(); } }
/** * aheadWorks Co. * * NOTICE OF LICENSE * * This source file is subject to the EULA * that is bundled with this package in the file LICENSE.txt. * It is also available through the world-wide-web at this URL: * http://ecommerce.aheadworks.com/AW-LICENSE.txt * * ================================================================= * MAGENTO EDITION USAGE NOTICE * ================================================================= * This package designed for Magento COMMUNITY edition * aheadWorks does not guarantee correct work of this extension * on any other Magento edition except Magento COMMUNITY edition. * aheadWorks does not provide extension support in case of * incorrect edition usage. * ================================================================= * * @category AW * @package AW_Ajaxcartpro * @version 3.0.0 * @copyright Copyright (c) 2010-2012 aheadWorks Co. (http://www.aheadworks.com) * @license http://ecommerce.aheadworks.com/AW-LICENSE.txt */ $installer = $this; $installer->startSetup(); $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $setup->addAttribute('catalog_product', 'aw_acp_disabled', array('backend' => 'giftmessage/entity_attribute_backend_boolean_config', 'input' => 'select', 'label' => 'Disable Ajax Cart Pro for that product', 'source' => 'eav/entity_attribute_source_boolean', 'required' => false, 'entity_model' => 'catalog/product', 'group' => 'ACP Options', 'global' => true, 'visible' => true, 'user_defined' => false, 'default' => '0', 'visible_on_front' => false)); $installer->endSetup();
<?php $installer = $this; $installer->startSetup(); $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $setup->addAttribute('catalog_product', 'cjm_imageswitcher', array('group' => 'Images', 'input' => 'text', 'type' => 'text', 'label' => 'Image Switch Code', 'backend' => '', 'frontend' => '', 'visible' => false, 'required' => false, 'user_defined' => false, 'searchable' => false, 'filterable' => false, 'comparable' => false, 'visible_on_front' => false, 'visible_in_advanced_search' => false, 'is_html_allowed_on_front' => false, 'apply_to' => 'configurable', 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE, 'note' => 'Do Not Edit!')); $setup->addAttribute('catalog_product', 'cjm_moreviews', array('group' => 'Images', 'input' => 'text', 'type' => 'text', 'label' => 'More Views Code', 'backend' => '', 'frontend' => '', 'visible' => false, 'required' => false, 'user_defined' => false, 'searchable' => false, 'filterable' => false, 'comparable' => false, 'visible_on_front' => false, 'visible_in_advanced_search' => false, 'is_html_allowed_on_front' => false, 'apply_to' => 'configurable', 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE, 'note' => 'Do Not Edit!')); $tableName = Mage::getSingleton('core/resource')->getTableName('catalog_product_entity_media_gallery_value'); $installer->run("ALTER TABLE `" . $tableName . "` ADD `defaultimg` TINYINT( 4 ) UNSIGNED NOT NULL DEFAULT '0'"); $installer->endSetup();
<?php $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $setup->addAttribute('order', 'mw_customercomment', array('label' => 'Customer Comment', 'type' => 'text', 'input' => 'text', 'visible' => true, 'required' => false, 'position' => 1));
<?php $this->startSetup(); $this->run(''); $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $setup->addAttribute(Mage_Catalog_Model_Category::ENTITY, Vikont_Fitment_Helper_Data::ARI_ACTIVITY_ATTRIBUTE_CODE, array('group' => 'ARI', 'type' => 'int', 'label' => 'ARI activity', 'input' => 'select', 'source' => 'fitment/source_ari_activity', 'backend' => '', 'visible' => true, 'required' => false, 'visible_on_front' => false, 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL, 'note' => '')); $this->endSetup();
<?php $installer = $this; $installer->startSetup(); $newFields = array('delivery_datetime' => array('type' => 'datetime', 'required' => 0, 'input' => 'text', 'default' => '')); $order = Mage::getModel('sales/order'); $entityType = $order->getResource()->getEntityType(); $entityTypeId = $entityType->getId(); $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); foreach ($newFields as $attributeName => $attributeDefs) { $setup->addAttribute($entityTypeId, $attributeName, array('position' => 1, 'type' => $attributeDefs['type'], 'required' => $attributeDefs['required'], 'input' => $attributeDefs['input'], 'default' => $attributeDefs['default'])); } $installer->endSetup();
<?php $installer = $this; $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $installer->startSetup(); $setup->removeAttribute('catalog_product', 'use_manufacturer_part_no'); $setup->addAttribute('catalog_product', 'use_manufacturer_part_no', array('group' => 'General', 'input' => 'select', 'type' => 'int', 'label' => 'Use Manufacturer Part No.', 'source' => 'eav/entity_attribute_source_boolean', 'backend' => 'eav/entity_attribute_backend_array', 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL, 'visible' => true, 'required' => false, 'default_value' => '0')); $installer->endSetup();
<?php $installer = $this; $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $installer->startSetup(); $setup->addAttribute('catalog_product', 'unm_disable_add_to_cart', array('group' => 'General', 'input' => 'select', 'type' => 'int', 'label' => 'Disable Add To Cart', 'source' => 'eav/entity_attribute_source_boolean', 'backend' => 'eav/entity_attribute_backend_array', 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL, 'visible' => true, 'required' => false, 'default_value' => '0')); $installer->endSetup();
<?php $installer = $this; $installer->startSetup(); // ======================================== // criacao dos atributos dos produtos // ======================================== if (Mage::getVersion() >= 1.5) { $setup = Mage::getModel('catalog/resource_setup', 'core_setup'); } else { $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); } $setup->addAttribute('catalog_product', 'novaPontoCom_importError', array('type' => 'text', 'backend' => '', 'frontend' => '', 'label' => 'Import Error - NovaPontoCom', 'input' => 'text', 'class' => '', 'source' => '', 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL, 'visible' => false, 'required' => false, 'user_defined' => false, 'default' => '', 'searchable' => false, 'filterable' => false, 'comparable' => false, 'visible_on_front' => false, 'unique' => false, 'apply_to' => 'simple,bundle,grouped,configurable', 'is_configurable' => false)); $installer->endSetup();
<?php $installer = $this; $installer->startSetup(); if (version_compare(Mage::getVersion(), '1.5.0', '>=')) { $setup = new Mage_Sales_Model_Resource_Setup('core_setup'); } else { $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); } $installer->getConnection()->addColumn($installer->getTable('sales_flat_quote'), 'pickup_datetime', 'DATETIME'); $setup->addAttribute('quote', 'pickup_datetime', array('type' => 'static', 'visible' => false)); $installer->run("ALTER TABLE {$this->getTable('sales_flat_order')} \n MODIFY `shipping_description` varchar(1500);\n"); $installer->getConnection()->addColumn($installer->getTable('sales_flat_order'), 'pickup_datetime', 'DATETIME'); $setup->addAttribute('order', 'pickup_datetime', array('type' => 'static', 'visible' => false)); $installer->getConnection()->addColumn($installer->getTable('sales_flat_order_grid'), 'pickup_datetime', 'DATETIME'); $setup->addAttribute('order', 'pickup_datetime', array('type' => 'static', 'visible' => false)); $installer->endSetup();
<?php $installer = $this; $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $installer->startSetup(); $setup->addAttribute('catalog_category', 'erp_id', array('group' => 'Display Settings', 'input' => 'text', 'type' => 'varchar', 'label' => 'ERP Id', 'visible' => true, 'required' => false, 'user_defined' => true, 'visible_on_front' => false, 'unique' => true, 'sort_order' => 500)); $installer->endSetup();
<?php $installer = $this; $installer->startSetup(); $installer->run("\r\nCREATE TABLE IF NOT EXISTS `{$this->getTable('rewardsref_referral')}` (\r\n `rewardsref_referral_id` int(11) unsigned NOT NULL auto_increment,\r\n `referral_parent_id` int(11) unsigned NOT NULL,\r\n `referral_child_id` int(11) unsigned default NULL,\r\n `referral_email` varchar(255) NOT NULL default '',\r\n `referral_name` varchar(255) default NULL,\r\n `referral_status` tinyint(1) default '0',\r\n `created_ts` timestamp NOT NULL default CURRENT_TIMESTAMP,\r\n PRIMARY KEY (`rewardsref_referral_id`),\r\n UNIQUE KEY `email` (`referral_email`),\r\n UNIQUE KEY `son_id` (`referral_child_id`),\r\n KEY `FK_customer_entity` (`referral_parent_id`),\r\n CONSTRAINT `rewardsref_referral_child_fk1` \r\n FOREIGN KEY (`referral_child_id`) REFERENCES `{$this->getTable('customer_entity')}` (`entity_id`),\r\n CONSTRAINT `rewardsref_referral_parent_fk` \r\n FOREIGN KEY (`referral_parent_id`) REFERENCES `{$this->getTable('customer_entity')}` (`entity_id`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n\r\n"); $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $setup->addAttribute('customer', 'rewardsref_notify_on_referral', array('label' => Mage::helper('rewardsref')->__('Notify on Referral'), 'type' => 'int', 'input' => 'select', 'visible' => true, 'required' => false, 'position' => 1, 'default' => 1, 'default_value' => 1, 'source' => "rewardsref/attribute_notify")); $installer->endSetup();
Mage::app()->setCurrentStore(Mage::getModel('core/store')->load(Mage_Core_Model_App::ADMIN_STORE_ID)); $installer = $this; $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $installer->startSetup(); /** * Adding a lookup table for Divido */ $conn = $installer->getConnection(); $lookup_table = $conn->newTable($installer->getTable('callback/lookup')); $lookup_table->addColumn('lookup_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array('identity' => true, 'unsigned' => true, 'nullable' => false, 'primary' => true), 'Id')->addColumn('salt', Varien_Db_Ddl_Table::TYPE_VARCHAR, 255, array('nullable' => false), 'Salt')->addColumn('quote_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array('nullable' => false, 'unsigned' => true), 'Quote ID'); $lookup_table->addIndex($installer->getIdxName('callback/lookup', array('quote_id'), Varien_Db_Adapter_Interface::INDEX_TYPE_UNIQUE), array('quote_id'), array('type' => Varien_Db_Adapter_Interface::INDEX_TYPE_UNIQUE)); $conn->createTable($lookup_table); /** * Adding Divido attributes to products */ $groupName = 'Divido'; $entityTypeId = $setup->getEntityTypeId('catalog_product'); $defaultAttrSetId = $setup->getDefaultAttributeSetId($entityTypeId); // adding attribute group $setup->addAttributeGroup($entityTypeId, $defaultAttrSetId, $groupName, 1000); $groupId = $setup->getAttributeGroupId($entityTypeId, $defaultAttrSetId, $groupName); // Add attributes $planOptionAttrCode = 'divido_plan_option'; $setup->addAttribute($entityTypeId, $planOptionAttrCode, array('label' => 'Available on finance', 'type' => 'varchar', 'input' => 'select', 'backend' => 'eav/entity_attribute_backend_array', 'frontend' => '', 'source' => 'pay/source_option', 'default' => 'default_plans', 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL, 'visible' => true, 'required' => true, 'user_defined' => true, 'searchable' => true, 'filterable' => false, 'comparable' => false, 'visible_on_front' => true, 'unique' => false)); $planOptionAttrId = $setup->getAttributeId($entityTypeId, $planOptionAttrCode); $setup->addAttributeToGroup($entityTypeId, $defaultAttrSetId, $groupId, $planOptionAttrId, null); $planSelectionAttrCode = 'divido_plan_selection'; $setup->addAttribute($entityTypeId, $planSelectionAttrCode, array('label' => 'Selected plans', 'type' => 'varchar', 'input' => 'multiselect', 'backend' => 'eav/entity_attribute_backend_array', 'frontend' => '', 'source' => 'pay/source_defaultprodplans', 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL, 'visible' => true, 'required' => false, 'user_defined' => true, 'searchable' => true, 'filterable' => false, 'comparable' => false, 'visible_on_front' => true, 'unique' => false)); $planSelectionAttrId = $setup->getAttributeId($entityTypeId, $planSelectionAttrCode); $setup->addAttributeToGroup($entityTypeId, $defaultAttrSetId, $groupId, $planSelectionAttrId, null); $installer->endSetup();
<?php $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $setup->addAttribute('catalog_product', 'featured', array('label' => 'Featured', 'type' => 'int', 'input' => 'select', 'source' => 'eav/entity_attribute_source_boolean', 'visible' => true, 'required' => false, 'position' => 10));
* that is bundled with this package in the file LICENSE.txt. * It is also available through the world-wide-web at this URL: * http://opensource.org/licenses/osl-3.0.php * If you did not receive a copy of the license and are unable to * obtain it through the world-wide-web, please send an email * to license@magentocommerce.com so we can send you a copy immediately. * * @category Phoenix * @package Phoenix_CashOnDelivery * @copyright Copyright (c) 2010 Phoenix Medien GmbH & Co. KG (http://www.phoenix-medien.de) * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) */ $this->startSetup(); $this->_conn->addColumn($this->getTable('sales_flat_quote'), 'cod_fee', 'decimal(12,4)'); $this->_conn->addColumn($this->getTable('sales_flat_quote'), 'base_cod_fee', 'decimal(12,4)'); $this->_conn->addColumn($this->getTable('sales_flat_quote_address'), 'cod_fee', 'decimal(12,4)'); $this->_conn->addColumn($this->getTable('sales_flat_quote_address'), 'base_cod_fee', 'decimal(12,4)'); $eav = new Mage_Eav_Model_Entity_Setup('sales_setup'); $eav->addAttribute('order', 'cod_fee', array('type' => 'decimal')); $eav->addAttribute('order', 'base_cod_fee', array('type' => 'decimal')); $eav->addAttribute('order', 'cod_fee_invoiced', array('type' => 'decimal')); $eav->addAttribute('order', 'base_cod_fee_invoiced', array('type' => 'decimal')); //$eav->addAttribute('order', 'cod_fee_refunded', array('type' => 'decimal',)); //$eav->addAttribute('order', 'base_cod_fee_refunded', array('type' => 'decimal')); //$eav->addAttribute('order', 'cod_fee_canceled', array('type' => 'decimal',)); //$eav->addAttribute('order', 'base_cod_fee_canceled', array('type' => 'decimal')); $eav->addAttribute('invoice', 'cod_fee', array('type' => 'decimal')); $eav->addAttribute('invoice', 'base_cod_fee', array('type' => 'decimal')); //$eav->addAttribute('creditmemo', 'cod_fee', array('type' => 'decimal',)); //$eav->addAttribute('creditmemo', 'base_cod_fee', array('type' => 'decimal')); $this->endSetup();
<?php $installer = $this; $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $installer->startSetup(); /** * Adding Different Attributes */ // adding attribute group //$setup->addAttributeGroup('catalog_product', 'Default', 'General', 1000); // the attribute added will be displayed under the group/tab Special Attributes in product edit page $setup->addAttribute('catalog_product', 'creareseo_discontinued', array('group' => 'General', 'type' => 'varchar', 'input' => 'select', 'backend' => 'eav/entity_attribute_backend_array', 'label' => 'Discontinued', 'visible' => 1, 'required' => 0, 'user_defined' => 1, 'searchable' => 0, 'filterable' => 0, 'comparable' => 0, 'visible_on_front' => 1, 'visible_in_advanced_search' => 0, 'is_html_allowed_on_front' => 0, 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE, 'option' => array('value' => array('none' => array('No Redirect (404)'), 'category' => array('301 Redirect to Category'), 'homepage' => array('301 Redirect to Homepage'), 'product' => array('301 Redirect to Product SKU'))))); $setup->addAttribute('catalog_product', 'creareseo_discontinued_product', array('group' => 'General', 'type' => 'varchar', 'input' => 'text', 'backend' => '', 'label' => 'Redirect to Product SKU', 'visible' => 1, 'required' => 0, 'user_defined' => 1, 'searchable' => 0, 'filterable' => 0, 'comparable' => 0, 'visible_on_front' => 1, 'visible_in_advanced_search' => 0, 'is_html_allowed_on_front' => 0, 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE)); $installer->endSetup();
* * ============================================================== * MAGENTO EDITION USAGE NOTICE * ============================================================== * This package designed for Magento COMMUNITY edition * Apptha does not guarantee correct work of this extension * on any other Magento edition except Magento COMMUNITY edition. * Apptha does not provide extension support in case of * incorrect edition usage. * ============================================================== * * @category Apptha * @package Apptha_Marketplace * @version 1.2.3 * @author Apptha Team <*****@*****.**> * @copyright Copyright (c) 2014 Apptha. (http://www.apptha.com) * @license http://www.apptha.com/LICENSE.txt * */ $installer = $this; $installer->startSetup(); $installer = new Mage_Eav_Model_Entity_Setup('core_setup'); $installer->addAttribute('customer', 'login_provider', array('label' => 'Provider', 'type' => 'varchar', 'input' => 'text', 'visible' => true, 'required' => false)); $eavConfig = Mage::getSingleton('eav/config'); $attribute = $eavConfig->getAttribute('customer', 'login_provider'); /** * enable all action * */ $attribute->setData('used_in_forms', array('adminhtml_customer', 'customer_account_create', 'customer_account_edit')); $attribute->save(); $installer->endSetup();
<?php /** * This source file is subject to the MIT License. * It is also available through http://opensource.org/licenses/MIT * * @category PedroTeixeira * @package PedroTeixeira_Correios * @author Pedro Teixeira <*****@*****.**> * @copyright 2015 Pedro Teixeira (http://pedroteixeira.io) * @license http://opensource.org/licenses/MIT MIT * @link https://github.com/pedro-teixeira/correios */ /** @var $installer Mage_Core_Model_Resource_Setup */ $installer = $this; $installer->startSetup(); /* @var $installer Mage_Catalog_Model_Resource_Eav_Mysql4_Setup */ $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $codigo = 'posting_days'; $config = array('position' => 1, 'required' => 0, 'label' => 'Prazo de Postagem', 'type' => 'int', 'input' => 'text', 'apply_to' => 'simple,bundle,grouped,configurable', 'note' => 'O prazo total é o Prazo dos Correios acrescido do maior Prazo de Postagem dos produtos no carrinho.'); $setup->addAttribute('catalog_product', $codigo, $config); $installer->endSetup();
<?php $installer = $this; $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $installer->startSetup(); $setup->addAttributeGroup('catalog_product', 'Default', 'Special Attributes', 1000); $setup->addAttribute('catalog_product', 'test_attribute', array('group' => 'Special Attributes', 'label' => 'Slide', 'type' => 'int', 'input' => 'select', 'backend' => '', 'frontend' => '', 'source' => 'ainstainer_homepage/source_slide', 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL, 'visible' => true, 'required' => false, 'user_defined' => true, 'searchable' => false, 'filterable' => false, 'comparable' => false, 'visible_on_front' => true, 'visible_in_advanced_search' => true, 'unique' => false)); $installer->endSetup();
<?php $installer = $this; $installer->startSetup(); $installer->run("\n\n\nDROP TABLE IF EXISTS {$this->getTable('magik_socialbar')};\nCREATE TABLE IF NOT EXISTS {$this->getTable('magik_socialbar')} (id int not null auto_increment, name varchar(200),show_socialsites varchar(255), social_block_code text, show_pagelocation varchar(150), \n\t\t\t show_category varchar(255),store_id varchar(100), primary key(id));\n\n\nDROP TABLE IF EXISTS {$this->getTable('magik_socialsites')};\nCREATE TABLE IF NOT EXISTS {$this->getTable('magik_socialsites')} (id int not null auto_increment, name varchar(255) NOT NULL, favicon varchar(255) NOT NULL,\n url text NOT NULL,\n primary key(id));\n\nINSERT INTO {$this->getTable('magik_socialsites')} VALUES (1,'Delicious','delicious.png','http://delicious.com/post?url=PERMALINK&title=TITLE&notes=EXCERPT'),\n(2,'Digg','digg.png','http://digg.com/submit?phase=2&url=PERMALINK&title=TITLE&bodytext=EXCERPT'),\n(3,'Facebook','facebook.png','http://www.facebook.com/share.php?u=PERMALINK&t=TITLE'),\n(4,'LinkedIn','linkedin.png','http://www.linkedin.com/shareArticle?mini=true&url=PERMALINK&title=TITLE&source=BLOGNAME&summary=EXCERPT'),\n(5,'Reddit','reddit.png','http://reddit.com/submit?url=PERMALINK&title=TITLE'),(16,'RSS','rss.png','FEEDLINK'),\n(6,'StumbleUpon','stumbleupon.png','http://www.stumbleupon.com/submit?url=PERMALINK&title=TITLE'),\n(7,'Tumblr','tumblr.png','http://www.tumblr.com/share?v=3&u=PERMALINK&t=TITLE&s=EXCERPT'),\n(8,'Twitter','twitter.png','http://twitter.com/home?status=TITLE%20-%20PERMALINK'),\n('9','Pinterest','PinExt.png','http://pinterest.com/pin/create/link/?url=PERMALINK&media=Productmedia&description=DESCRIPTION'),\n('10','Google Plus','googleplus.png','https://plus.google.com/share?url=PERMALINK');\n"); $installer->endSetup(); $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $setup->addAttribute('catalog_product', 'product_socialbar', array('group' => 'Magik Socialbar', 'type' => 'int', 'backend' => '', 'frontend' => '', 'label' => 'Disable Social Bar for this product', 'input' => 'boolean', 'class' => '', 'source' => '', 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL, 'visible' => true, 'required' => false, 'user_defined' => false, 'default' => '0', 'searchable' => false, 'filterable' => false, 'comparable' => false, 'visible_on_front' => false, 'unique' => false, 'is_configurable' => false));
<?php /** * Created by PhpStorm. * User: Евгений * Date: 27.01.2016 * Time: 21:18 */ $installer = $this; $installer->startSetup(); $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $setup->addAttribute('order', 'ref', array('position' => 1, 'input' => 'text', 'type' => 'varchar', 'label' => 'ref number', 'visible' => 1, 'required' => 0, 'user_defined' => 1, 'global' => 1, 'visible_on_front' => 0)); $installer->endSetup();
* Apptha does not guarantee correct work of this extension * on any other Magento edition except Magento COMMUNITY edition. * Apptha does not provide extension support in case of * incorrect edition usage. * ============================================================== * * @category Apptha * @package Apptha_Marketplace * @version 1.7 * @author Apptha Team <*****@*****.**> * @copyright Copyright (c) 2015 Apptha. (http://www.apptha.com) * @license http://www.apptha.com/LICENSE.txt * */ /** * This file is used to create table for "Seller Vacation Mode" */ $installer = $this; /** * @var $installer Mage_Core_Model_Resource_Setup */ $installer->startSetup(); $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $applyTo = array('simple', 'configurable'); $setup->updateAttribute('catalog_product', 'seller_shipping_option', 'apply_to', join(',', $applyTo)); $setup->updateAttribute('catalog_product', 'national_shipping_price', 'apply_to', join(',', $applyTo)); $setup->updateAttribute('catalog_product', 'international_shipping_price', 'apply_to', join(',', $applyTo)); $setup->updateAttribute('catalog_product', 'default_country', 'apply_to', join(',', $applyTo)); $setup->addAttribute('catalog_product', 'is_assign_product', array('group' => 'Special Attributes', 'input' => 'text', 'type' => 'text', 'label' => 'Is assign product', 'backend' => '', 'visible' => 1, 'required' => 0, 'user_defined' => 1, 'searchable' => 1, 'filterable' => 0, 'comparable' => 1, 'visible_on_front' => 1, 'visible_in_advanced_search' => 0, 'is_html_allowed_on_front' => 0, 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL)); $setup->addAttribute('catalog_product', 'assign_product_id', array('group' => 'Special Attributes', 'input' => 'text', 'type' => 'text', 'label' => 'Assign product id', 'backend' => '', 'visible' => 1, 'required' => 0, 'user_defined' => 1, 'searchable' => 1, 'filterable' => 0, 'comparable' => 1, 'visible_on_front' => 1, 'visible_in_advanced_search' => 0, 'is_html_allowed_on_front' => 0, 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL)); $installer->endSetup();
* @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) * @version 1.0.2 * @link http://www.magentocommerce.com/magento-connect/debitpayment.html */ // load id for customer entity $read = Mage::getSingleton('core/resource')->getConnection('core_read'); $eid = $read->fetchRow("select entity_type_id from {$this->getTable('eav_entity_type')} where entity_type_code = 'customer'"); $customerTypeId = $eid['entity_type_id']; $attrDate = array('type' => 'datetime', 'input' => 'label', 'label' => 'Account update date', 'global' => 1, 'required' => 0, 'default' => '', 'position' => '100'); $attrName = array('type' => 'varchar', 'input' => 'text', 'label' => 'Account Name', 'global' => 1, 'required' => 0, 'default' => '', 'position' => '100'); $attrNumber = array('type' => 'varchar', 'input' => 'text', 'label' => 'Account number', 'backend' => 'debit/entity_customer_attribute_backend_encrypted', 'global' => 1, 'required' => 0, 'default' => '', 'position' => '100'); $attrBlz = array('type' => 'varchar', 'input' => 'text', 'label' => 'Bank code', 'backend' => 'debit/entity_customer_attribute_backend_encrypted', 'global' => 1, 'required' => 0, 'default' => '', 'position' => '100'); $installer = $this; $installer->startSetup(); $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $setup->addAttribute($customerTypeId, 'debit_payment_acount_update', $attrDate); $setup->addAttribute($customerTypeId, 'debit_payment_acount_name', $attrName); $setup->addAttribute($customerTypeId, 'debit_payment_acount_number', $attrNumber); $setup->addAttribute($customerTypeId, 'debit_payment_acount_blz', $attrBlz); // Since 1.4.2.0 this is necessary! $eavConfig = Mage::getSingleton('eav/config'); $attribute = $eavConfig->getAttribute($customerTypeId, 'debit_payment_acount_update'); $attribute->setData('used_in_forms', array('customer_account_edit', 'customer_account_create', 'adminhtml_customer')); $attribute->save(); $attribute = $eavConfig->getAttribute($customerTypeId, 'debit_payment_acount_name'); $attribute->setData('used_in_forms', array('customer_account_edit', 'customer_account_create', 'adminhtml_customer')); $attribute->save(); $attribute = $eavConfig->getAttribute($customerTypeId, 'debit_payment_acount_number'); $attribute->setData('used_in_forms', array('customer_account_edit', 'customer_account_create', 'adminhtml_customer')); $attribute->save(); $attribute = $eavConfig->getAttribute($customerTypeId, 'debit_payment_acount_blz');
<?php $installer = $this; $installer->startSetup(); $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $setup->addAttribute('catalog_category', 'fabia_custom_cat_desc5', array('group' => 'Fabia Menu Settings', 'label' => 'Custom Category Description For Version 5', 'note' => 'All fields will be showed for only top-level categories and mega menu type. This settings will be available only for version 5.', 'type' => 'text', 'input' => 'textarea', 'visible' => true, 'required' => false, 'backend' => '', 'frontend' => '', 'searchable' => false, 'filterable' => false, 'comparable' => false, 'user_defined' => true, 'visible_on_front' => true, 'wysiwyg_enabled' => true, 'is_html_allowed_on_front' => true, 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE)); $installer->endSetup();