<?php /* @var $installer Mage_Customer_Model_Entity_Setup */ $installer = $this; $installer->startSetup(); // Attributes $attributeSetup = new Mage_Eav_Model_Entity_Setup('core_setup'); $entityTypeId = $attributeSetup->getEntityTypeId('customer'); $attributeSetId = $attributeSetup->getDefaultAttributeSetId($entityTypeId); $attributeGroupId = $attributeSetup->getDefaultAttributeGroupId($entityTypeId, $attributeSetId); $installer->addAttribute("customer", "customer_number", array("type" => "varchar", "label" => "Customer Number", "input" => "text", "visible" => true, "required" => false, "default" => "", "frontend" => "", "unique" => false, "note" => "")); $attribute = Mage::getSingleton("eav/config")->getAttribute("customer", "customer_number"); $attributeSetup->addAttributeToGroup($entityTypeId, $attributeSetId, $attributeGroupId, 'customer_number', '400'); $used_in_forms = array(); $used_in_forms[] = "adminhtml_customer"; $attribute->setData("used_in_forms", $used_in_forms)->setData("is_used_for_customer_segment", false)->setData("is_system", 0)->setData("is_user_defined", 1)->setData("is_visible", 0)->setData("sort_order", 400); $attribute->save(); $installer->endSetup();
<?php $installer = $this; $installer->startSetup(); $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $entityTypeId = $setup->getEntityTypeId('catalog_product'); $select = $this->_conn->select()->from($this->getTable('eav/attribute_set'))->where('entity_type_id = :entity_type_id'); $sets = $this->_conn->fetchAll($select, array('entity_type_id' => $entityTypeId)); foreach ($sets as $set) { $setup->updateAttributeGroup($entityTypeId, $set['attribute_set_id'], 'Payperrentals', 'attribute_group_name', 'Rental Bookings'); $setup->addAttributeToGroup($entityTypeId, $set['attribute_set_id'], 'Prices', 'payperrentals_pricingtype'); $setup->addAttributeToGroup($entityTypeId, $set['attribute_set_id'], 'Prices', 'payperrentals_deposit'); $setup->addAttributeToGroup($entityTypeId, $set['attribute_set_id'], 'Inventory', 'allow_overbooking'); } $installer->endSetup();
<?php /** * Created by PhpStorm. * User: pavel * Date: 18.11.2015 * Time: 16:50 */ $installer = $this; $installer->startSetup(); $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $entityTypeId = $setup->getEntityTypeId('customer'); $attributeSetId = $setup->getDefaultAttributeSetId($entityTypeId); $attributeGroupId = $setup->getDefaultAttributeGroupId($entityTypeId, $attributeSetId); $installer->addAttribute("customer", "points", array("type" => "decimal", "backend" => "", "label" => "Points for Order", "input" => "text", "source" => "", "visible" => true, "required" => false, "default" => "", "frontend" => "", "unique" => false, "note" => "Points for Order")); $attribute = Mage::getSingleton("eav/config")->getAttribute("customer", "points"); $setup->addAttributeToGroup($entityTypeId, $attributeSetId, $attributeGroupId, 'points', '999'); $used_in_forms = array(); $used_in_forms[] = "adminhtml_customer"; $used_in_forms[] = "checkout_register"; $used_in_forms[] = "customer_account_create"; $used_in_forms[] = "customer_account_edit"; $used_in_forms[] = "adminhtml_checkout"; $attribute->setData("used_in_forms", $used_in_forms)->setData("is_used_for_customer_segment", true)->setData("is_system", 0)->setData("is_user_defined", 1)->setData("is_visible", 1)->setData("sort_order", 100); $attribute->save(); $installer->endSetup();
<?php $installer = $this; $installer->startSetup(); $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $entityTypeId = $setup->getEntityTypeId('customer'); $attributeSetId = $setup->getDefaultAttributeSetId($entityTypeId); $attributeGroupId = $setup->getDefaultAttributeGroupId($entityTypeId, $attributeSetId); $installer->addAttribute("customer", "complete_sf_form", array("type" => "int", "backend" => "", "label" => "Completed SalesForce Form", "input" => "select", "source" => "eav/entity_attribute_source_boolean", "visible" => 1, "required" => 0, "default" => "0", "user_defined" => 1)); $attribute = Mage::getSingleton("eav/config")->getAttribute("customer", "complete_sf_form"); $setup->addAttributeToGroup($entityTypeId, $attributeSetId, $attributeGroupId, 'complete_sf_form', '999'); $used_in_forms = array(); $used_in_forms[] = "adminhtml_customer"; $attribute->setData("used_in_forms", $used_in_forms)->setData("is_used_for_customer_segment", true)->setData("is_system", 0)->setData("is_user_defined", 1)->setData("is_visible", 1)->setData("sort_order", 100); $attribute->save(); $installer->endSetup();
<?php /** * install-0.1.0.php created by a.voytik. * Date: 12/03/2012 06:28 */ /* @var $installer Dutycalculator_Charge_Model_Resource_Setup */ $installer = $this; $productAttributesSetup = new Mage_Eav_Model_Entity_Setup('core_setup'); $installer->startSetup(); $productAttributesSetup->addAttribute('catalog_product', 'dc_product_id', array('backend' => '', 'type' => 'int', 'frontend' => '', 'input' => 'text', 'label' => 'DutyCalculator Category', 'frontend_class' => '', 'source' => '', 'required' => false, 'user_defined' => true, 'default' => 0, 'unique' => 0, 'note' => '', 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_WEBSITE)); $productAttributesSetup->addAttributeToGroup('catalog_product', 'Default', 'Prices', 'dc_product_id', 100); $installer->getConnection()->addColumn($this->getTable('sales/order'), 'dc_order_id', 'int(11) NOT NULL DEFAULT 0'); $installer->getConnection()->addColumn($this->getTable('sales/invoice'), 'dc_order_id', 'int(11) NOT NULL DEFAULT 0'); $installer->getConnection()->addColumn($this->getTable('sales/quote'), 'dc_order_id', 'int(11) NOT NULL DEFAULT 0'); $installer->getConnection()->addColumn($this->getTable('sales/shipment'), 'commercial_invoice_url', 'varchar(255) NULL DEFAULT NULL'); $installer->getConnection()->addColumn($this->getTable('sales/shipment'), 'packing_list_url', 'varchar(255) NULL DEFAULT NULL'); $installer->getConnection()->addColumn($this->getTable('sales/order'), 'delivery_duty_type', "varchar(25) NOT NULL DEFAULT '" . Dutycalculator_Charge_Helper_Data::DC_DELIVERY_TYPE_DDU . "'"); $installer->getConnection()->addColumn($this->getTable('sales/quote'), 'delivery_duty_type', "varchar(25) NOT NULL DEFAULT '" . Dutycalculator_Charge_Helper_Data::DC_DELIVERY_TYPE_DDU . "'"); $installer->getConnection()->addColumn($this->getTable('sales/quote_address'), 'delivery_duty_type', "varchar(25) NOT NULL DEFAULT '" . Dutycalculator_Charge_Helper_Data::DC_DELIVERY_TYPE_DDU . "'"); $installer->getConnection()->addColumn($this->getTable('sales/invoice'), 'delivery_duty_type', "varchar(25) NOT NULL DEFAULT '" . Dutycalculator_Charge_Helper_Data::DC_DELIVERY_TYPE_DDU . "'"); $installer->getConnection()->addColumn($this->getTable('sales/creditmemo'), 'delivery_duty_type', "varchar(25) NOT NULL DEFAULT '" . Dutycalculator_Charge_Helper_Data::DC_DELIVERY_TYPE_DDU . "'"); $installer->getConnection()->addColumn($this->getTable('sales/shipment'), 'delivery_duty_type', "varchar(25) NOT NULL DEFAULT '" . Dutycalculator_Charge_Helper_Data::DC_DELIVERY_TYPE_DDU . "'"); $installer->getConnection()->addColumn($this->getTable('sales/quote'), 'import_duty_tax', 'decimal(10, 2) NOT NULL DEFAULT 0'); $installer->getConnection()->addColumn($this->getTable('sales/quote'), 'base_import_duty_tax', 'decimal(10, 2) NOT NULL DEFAULT 0'); $installer->getConnection()->addColumn($this->getTable('sales/quote_item'), 'import_duty_tax', 'decimal(10, 2) NOT NULL DEFAULT 0'); $installer->getConnection()->addColumn($this->getTable('sales/quote_item'), 'base_import_duty_tax', 'decimal(10, 2) NOT NULL DEFAULT 0'); $installer->getConnection()->addColumn($this->getTable('sales/order'), 'import_duty_tax', 'decimal(10, 2) NOT NULL DEFAULT 0'); $installer->getConnection()->addColumn($this->getTable('sales/order'), 'base_import_duty_tax', 'decimal(10, 2) NOT NULL DEFAULT 0'); $installer->getConnection()->addColumn($this->getTable('sales/order'), 'import_duty_tax_invoiced', 'decimal(10, 2) NOT NULL DEFAULT 0'); $installer->getConnection()->addColumn($this->getTable('sales/order'), 'base_import_duty_tax_invoiced', 'decimal(10, 2) NOT NULL DEFAULT 0');
<?php $installer = $this; $installer->startSetup(); $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $entityTypeId = $setup->getEntityTypeId('customer'); $attributeSetId = $setup->getDefaultAttributeSetId($entityTypeId); $attributeGroupId = $setup->getDefaultAttributeGroupId($entityTypeId, $attributeSetId); $installer->addAttribute("customer", "couponsSent", array("type" => "varchar", "backend" => "", "label" => "Coupons Sent", "input" => "text", "source" => "", "visible" => true, "required" => false, "default" => "", "frontend" => "", "unique" => false, "note" => "Coupons Sent")); $attribute = Mage::getSingleton("eav/config")->getAttribute("customer", "couponsSent"); $setup->addAttributeToGroup($entityTypeId, $attributeSetId, $attributeGroupId, 'couponsSent', '999');
$installer->run("ALTER TABLE {$this->getTable('rewardpoints_account')} ADD COLUMN `rewardpoints_status` VARCHAR( 255 ) NULL;"); $installer->run("ALTER TABLE {$this->getTable('rewardpoints_account')} ADD COLUMN `rewardpoints_state` VARCHAR( 255 ) NULL AFTER `rewardpoints_status`;"); $installer->run("ALTER TABLE {$this->getTable('rewardpoints_account')} ADD COLUMN `date_order` DATETIME NULL AFTER `rewardpoints_state`;"); $installer->run("ALTER TABLE {$this->getTable('rewardpoints_account')} ADD COLUMN `date_insertion` DATETIME NULL AFTER `date_order`;"); $installer->run("ALTER TABLE {$this->getTable('rewardpoints_account')} ADD COLUMN `period` DATE NULL AFTER `date_insertion`;"); $installer->run("ALTER TABLE {$this->getTable('rewardpoints_account')} ADD COLUMN `object_name` VARCHAR( 255 ) NULL AFTER `period`;"); $installer->run("ALTER TABLE {$this->getTable('rewardpoints_account')} ADD INDEX `rewardpoints_status` (`rewardpoints_status`);"); $installer->run("ALTER TABLE {$this->getTable('rewardpoints_account')} ADD INDEX `rewardpoints_state` (`rewardpoints_state`);"); $installer->run("ALTER TABLE {$this->getTable('rewardpoints_account')} ADD INDEX `object_name` (`object_name`);"); if (version_compare(Mage::getVersion(), '1.4.0', '>=')) { $installer->run("UPDATE {$this->getTable('rewardpoints_account')} SET `rewardpoints_status` = (SELECT `status` FROM {$this->getTable('sales/order')} WHERE {$this->getTable('sales/order')}.increment_id = {$this->getTable('rewardpoints_account')}.order_id), \n `rewardpoints_state` = (SELECT `state` FROM {$this->getTable('sales/order')} WHERE {$this->getTable('sales/order')}.increment_id = {$this->getTable('rewardpoints_account')}.order_id),\n `date_order` = (SELECT {$this->getTable('sales/order')}.`created_at` FROM {$this->getTable('sales/order')} WHERE {$this->getTable('sales/order')}.increment_id = {$this->getTable('rewardpoints_account')}.order_id),\n `date_insertion` = (SELECT {$this->getTable('sales/order')}.`created_at` FROM {$this->getTable('sales/order')} WHERE {$this->getTable('sales/order')}.increment_id = {$this->getTable('rewardpoints_account')}.order_id),\n `period` = (SELECT {$this->getTable('sales/order')}.`created_at` FROM {$this->getTable('sales/order')} WHERE {$this->getTable('sales/order')}.increment_id = {$this->getTable('rewardpoints_account')}.order_id);"); } else { $table_sales_order = $this->getTable('sales/order') . '_varchar'; $states = array(Mage_Sales_Model_Order::STATE_NEW, Mage_Sales_Model_Order::STATE_PENDING_PAYMENT, Mage_Sales_Model_Order::STATE_PROCESSING, Mage_Sales_Model_Order::STATE_COMPLETE, Mage_Sales_Model_Order::STATE_CLOSED, Mage_Sales_Model_Order::STATE_CANCELED, Mage_Sales_Model_Order::STATE_HOLDED); $installer->run("UPDATE {$this->getTable('rewardpoints_account')} SET `rewardpoints_state` = ( SELECT order_state.value \n FROM {$table_sales_order} as order_state \n WHERE order_state.entity_id IN ( \n SELECT orders.entity_id FROM {$this->getTable('sales/order')} as orders \n WHERE orders.increment_id = {$this->getTable('rewardpoints_account')}.order_id\n )\n WHERE order_state.value in ('" . implode("','", $states) . "') ORDER BY value_id DESC\n LIMIT 1\n ),\n `date_order` = (SELECT {$this->getTable('sales/order')}.`created_at` FROM {$this->getTable('sales/order')} WHERE {$this->getTable('sales/order')}.increment_id = {$this->getTable('rewardpoints_account')}.order_id),\n `date_insertion` = (SELECT {$this->getTable('sales/order')}.`created_at` FROM {$this->getTable('sales/order')} WHERE {$this->getTable('sales/order')}.increment_id = {$this->getTable('rewardpoints_account')}.order_id),\n `period` = (SELECT {$this->getTable('sales/order')}.`created_at` FROM {$this->getTable('sales/order')} WHERE {$this->getTable('sales/order')}.increment_id = {$this->getTable('rewardpoints_account')}.order_id);"); } $installer->run("ALTER TABLE {$this->getTable('rewardpoints_flat_account')} ADD COLUMN `notification_date` DATETIME NULL AFTER `points_lost`;"); $installer->run("ALTER TABLE {$this->getTable('rewardpoints_flat_account')} ADD COLUMN `notification_qty` integer(10) unsigned NOT NULL default '0' AFTER `points_lost`;"); // /end get all invoices and update rewardpoints & rewardpoints_gathered (from rewardpoints_account table) //Mage_Customer_Model_Entity_Setup $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $entityTypeId = $setup->getEntityTypeId('customer'); $attributeSetId = $setup->getDefaultAttributeSetId($entityTypeId); $attributeGroupId = $setup->getDefaultAttributeGroupId($entityTypeId, $attributeSetId); $setup->addAttribute('customer', 'rewardpoints_referrer', array('label' => 'Reward Points Referrer ID', 'input' => 'text', 'type' => 'int', 'visible' => 1, 'required' => 0, 'user_defined' => 1)); $setup->addAttributeToGroup($entityTypeId, $attributeSetId, $attributeGroupId, 'rewardpoints_referrer', '999'); $oAttribute = Mage::getSingleton('eav/config')->getAttribute('customer', 'rewardpoints_referrer'); $oAttribute->setData('used_in_forms', array('adminhtml_customer')); $oAttribute->save(); //$setup->endSetup(); $installer->endSetup();
<?php /* @var $installer Mage_Customer_Model_Entity_Setup */ $installer = $this; $installer->startSetup(); // Attributes $attributeSetup = new Mage_Eav_Model_Entity_Setup('core_setup'); $entityTypeId = $attributeSetup->getEntityTypeId('customer'); $attributeSetId = $attributeSetup->getDefaultAttributeSetId($entityTypeId); $attributeGroupId = $attributeSetup->getDefaultAttributeGroupId($entityTypeId, $attributeSetId); $installer->addAttribute("customer", "display_price_type", ["type" => "varchar", "label" => "Display Price Type", "input" => "text", "visible" => true, "required" => false, "default" => "0", "frontend" => "", "unique" => false, "note" => "This value indicates which price type is displayed to the customer (B2B-Store only). (0=both, 1=purchase price, 2=retail price)"]); $attribute = Mage::getSingleton("eav/config")->getAttribute("customer", "display_price_type"); $attributeSetup->addAttributeToGroup($entityTypeId, $attributeSetId, $attributeGroupId, 'display_price_type', '600'); $attribute->setData("used_in_forms", ["adminhtml_customer"])->setData("is_used_for_customer_segment", false)->setData("is_system", 0)->setData("is_user_defined", 1)->setData("is_visible", 0)->setData("sort_order", 600); $attribute->save(); $installer->endSetup();
<?php /** * Dc_BrandManager * * NOTICE OF LICENSE * * This source file is subject to the Open Software License (OSL 3.0) * that is available through the world-wide-web at this URL: * http://opensource.org/licenses/osl-3.0.php * * @category Dc * @package Dc_BrandManager * @copyright Copyright (c) 2012-2015 Damián Culotta. (http://www.damianculotta.com.ar/) * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) */ $installer = $this; $installer->startSetup(); $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $setup->addAttributeGroup(Mage_Catalog_Model_Category::ENTITY, 'Default', 'Extra Options', 10); $_attribute_set_id = $setup->getDefaultAttributeSetId(Mage_Catalog_Model_Category::ENTITY); $_attribute_group_id = $setup->getAttributeGroupId(Mage_Catalog_Model_Category::ENTITY, $_attribute_set_id, 'Extra Options'); $setup->addAttribute('catalog_category', 'brand_icon', array('type' => 'varchar', 'backend' => 'catalog/category_attribute_backend_image', 'frontend' => '', 'label' => 'Brand Icon', 'input' => 'image', 'class' => '', 'source' => '', 'global' => 0, 'visible' => 1, 'required' => 0, 'user_defined' => 1, 'default' => 0, 'searchable' => 0, 'filterable' => 0, 'comparable' => 0, 'visible_on_front' => 1, 'unique' => 0, 'position' => 1)); $setup->addAttributeToGroup(Mage_Catalog_Model_Category::ENTITY, $_attribute_set_id, $_attribute_group_id, 'brand_icon', '10'); $installer->endSetup();
<?php $installer = $this; $installer->startSetup(); $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $entityTypeId = $setup->getEntityTypeId('customer'); $attributeSetId = $setup->getDefaultAttributeSetId($entityTypeId); $attributeGroupId = $setup->getDefaultAttributeGroupId($entityTypeId, $attributeSetId); $setup->addAttribute('customer', 'master_customer', array('input' => 'select', 'type' => 'text', 'label' => 'DEALER', 'source' => 'brandattr/product_attribute_source_unit', 'backend' => '', 'visible' => 1, 'required' => 0, 'user_defined' => 1)); $setup->addAttributeToGroup($entityTypeId, $attributeSetId, $attributeGroupId, 'master_customer', '999'); $oAttribute = Mage::getSingleton('eav/config')->getAttribute('customer', 'master_customer'); $oAttribute->setData('used_in_forms', array('adminhtml_customer')); $oAttribute->save(); $installer->endSetup();
<?php /* @var $installer Mage_Customer_Model_Entity_Setup */ $installer = $this; $installer->startSetup(); // Attributes $attributeSetup = new Mage_Eav_Model_Entity_Setup('core_setup'); $entityTypeId = $attributeSetup->getEntityTypeId('customer'); $attributeSetId = $attributeSetup->getDefaultAttributeSetId($entityTypeId); $attributeGroupId = $attributeSetup->getDefaultAttributeGroupId($entityTypeId, $attributeSetId); $installer->addAttribute("customer", "purchase_price_list", ["type" => "varchar", "label" => "Purchase Price List", "input" => "text", "visible" => true, "required" => false, "default" => "", "frontend" => "", "unique" => false, "note" => ""]); $attribute = Mage::getSingleton("eav/config")->getAttribute("customer", "purchase_price_list"); $attributeSetup->addAttributeToGroup($entityTypeId, $attributeSetId, $attributeGroupId, 'purchase_price_list', '500'); $attribute->setData("used_in_forms", ["adminhtml_customer"])->setData("is_used_for_customer_segment", false)->setData("is_system", 0)->setData("is_user_defined", 1)->setData("is_visible", 0)->setData("sort_order", 500); $attribute->save(); $installer->endSetup();
<?php /* @var $installer Mage_Core_Model_Resource_Setup */ $installer = $this; $installer->startSetup(); $attributeCode = 'complete_profile_sent'; $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $entityTypeId = $setup->getEntityTypeId('customer'); $attributeSetId = $setup->getDefaultAttributeSetId($entityTypeId); $attributeGroupId = $setup->getDefaultAttributeGroupId($entityTypeId, $attributeSetId); $setup->addAttribute('customer', $attributeCode, array('label' => 'Complete Profile Mail Sent', 'input' => 'select', 'type' => 'int', 'visible' => 1, 'required' => 0, 'user_defined' => 0, 'sort_order' => 999, 'source' => 'eav/entity_attribute_source_boolean')); $setup->addAttributeToGroup($entityTypeId, $attributeSetId, $attributeGroupId, $attributeCode, '999'); $oAttribute = Mage::getSingleton('eav/config')->getAttribute('customer', $attributeCode); $oAttribute->setData('used_in_forms', array('adminhtml_customer', 'adminhtml_checkout')); $oAttribute->setData('sort_order', 999); $oAttribute->save(); $setup->endSetup();
<?php /** * Author : Nguyen Trung Hieu * Email : hieunt@smartosc.com * Date: 8/29/12 * Time: 1:18 PM */ $installer = $this; $installer->startSetup(); $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $entityTypeId = $setup->getEntityTypeId('customer'); $attributeSetId = $setup->getDefaultAttributeSetId($entityTypeId); $attributeGroupId = $setup->getDefaultAttributeGroupId($entityTypeId, $attributeSetId); $setup->addAttribute('customer', 'fullname', array('input' => 'text', 'type' => 'text', 'label' => 'Full Name', 'visible' => 1, 'required' => 1, 'user_defined' => 1)); $setup->addAttributeToGroup($entityTypeId, $attributeSetId, $attributeGroupId, 'fullname', '999'); $oAttribute = Mage::getSingleton('eav/config')->getAttribute('customer', 'fullname'); $oAttribute->setData('used_in_forms', array('adminhtml_customer')); $oAttribute->save(); $installer->endSetup();
<?php $installer = $this; $installer->startSetup(); $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $entityTypeId = $setup->getEntityTypeId('catalog_product'); $select = $this->_conn->select()->from($this->getTable('eav/attribute_set'))->where('entity_type_id = :entity_type_id'); $sets = $this->_conn->fetchAll($select, array('entity_type_id' => $entityTypeId)); foreach ($sets as $set) { $setup->addAttributeToGroup('catalog_product', $set['attribute_set_id'], 'Prices', 'payperrentals_buyoutprice'); $setup->addAttributeToGroup('catalog_product', $set['attribute_set_id'], 'Prices', 'payperrentals_enable_extend'); $setup->addAttributeToGroup('catalog_product', $set['attribute_set_id'], 'Prices', 'payperrentals_enable_buyout'); $setup->addAttributeToGroup('catalog_product', $set['attribute_set_id'], 'Prices', 'payperrentals_buyout_onproduct'); $setup->addAttributeToGroup('catalog_product', $set['attribute_set_id'], 'Prices', 'bundle_pricingtype'); } $installer->endSetup();
<?php $installer = $this; $installer->startSetup(); $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $entityTypeId = $setup->getEntityTypeId('customer'); $attributeSetId = $setup->getDefaultAttributeSetId($entityTypeId); $attributeGroupId = $setup->getDefaultAttributeGroupId($entityTypeId, $attributeSetId); $setup->addAttribute('customer', 'crossfitid', array('input' => 'text', 'type' => 'text', 'label' => 'CrossFit ID', 'visible' => 1, 'required' => 0, 'user_defined' => 1)); $setup->addAttributeToGroup($entityTypeId, $attributeSetId, $attributeGroupId, 'crossfitid', '999'); $oAttribute = Mage::getSingleton('eav/config')->getAttribute('customer', 'crossfitid'); $oAttribute->setData('used_in_forms', array('adminhtml_customer')); $oAttribute->save(); $installer->endSetup();
<?php $installer = $this; $newstoreMembersTable = $installer->getTable('ism_newstore_members/newstore_members'); $installer->startSetup(); $installer->getConnection()->dropTable($newstoreMembersTable); $table = $installer->getConnection()->newTable($newstoreMembersTable)->addColumn('id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array('identity' => true, 'nullable' => false, 'primary' => true))->addColumn('unique_key', Varien_Db_Ddl_Table::TYPE_VARCHAR, '255', array('nullable' => false))->addColumn('customer_id', Varien_Db_Ddl_Table::TYPE_INTEGER, array('nullable' => false))->addColumn('expire_date', Varien_Db_Ddl_Table::TYPE_DATE, array('nullable' => false))->addColumn('post_code', Varien_Db_Ddl_Table::TYPE_VARCHAR, '255', array('nullable' => false, 'default' => ''))->addColumn('activated', Varien_Db_Ddl_table::TYPE_TINYINT, null, array('nullable' => false, 'defalut' => 0))->addForeignKey($installer->getFkName('ism_newstore_members/newstore_members', 'customer_id', 'customer/entity', 'entity_id'), 'customer_id', $installer->getTable('customer/entity'), 'entity_id', Varien_Db_Ddl_Table::ACTION_SET_NULL, Varien_Db_Ddl_Table::ACTION_SET_NULL); $installer->getConnection()->createTable($table); $installer->getConnection()->addColumn('sales_flat_quote', 'newstore_member_code', array('nullable' => true, 'type' => Varien_Db_Ddl_Table::TYPE_TEXT, 'length' => 256, 'comment' => 'Newstore Meber Code')); $installer->getConnection()->addColumn('sales_flat_order', 'newstore_member_code', array('nullable' => true, 'type' => Varien_Db_Ddl_Table::TYPE_TEXT, 'length' => 256, 'comment' => 'Newstore Member Code')); $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $setup->addAttribute('customer', 'prev_group_id', array('type' => 'int')); $entityTypeId = $setup->getEntityTypeId('customer'); $attributeSetId = $setup->getDefaultAttributeSetId($entityTypeId); $attributeGroupId = $setup->getDefaultAttributeGroupId($entityTypeId, $attributeSetId); $setup->addAttributeToGroup($entityTypeId, $attributeSetId, $attributeGroupId, 'prev_group_id', '999'); $installer->endSetup();
$config = array('position' => 1, 'required' => 0, 'label' => 'Comprimento (cm)', 'type' => 'int', 'input' => 'text', 'apply_to' => 'simple,bundle,grouped,configurable', 'note' => 'Comprimento da embalagem do produto (Para cálculo dos Correios)'); $setup->addAttribute('catalog_product', $codigo, $config); // Add volume to prduct attribute set $codigo = 'volume_altura'; $config = array('position' => 1, 'required' => 0, 'label' => 'Altura (cm)', 'type' => 'int', 'input' => 'text', 'apply_to' => 'simple,bundle,grouped,configurable', 'note' => 'Altura da embalagem do produto (Para cálculo dos Correios)'); $setup->addAttribute('catalog_product', $codigo, $config); // Add volume to prduct attribute set $codigo = 'volume_largura'; $config = array('position' => 1, 'required' => 0, 'label' => 'Largura (cm)', 'type' => 'int', 'input' => 'text', 'apply_to' => 'simple,bundle,grouped,configurable', 'note' => 'Largura da embalagem do produto (Para cálculo dos Correios)'); $setup->addAttribute('catalog_product', $codigo, $config); $codigo = 'postmethods'; $config = array('position' => 1, 'required' => 0, 'label' => 'Serviços de Entrega', 'type' => 'text', 'input' => 'multiselect', 'source' => 'pedroteixeira_correios/source_postMethods', 'backend' => 'eav/entity_attribute_backend_array', 'apply_to' => 'simple,bundle,grouped,configurable', 'note' => 'Selecione os serviços apropriados para o produto.'); $setup->addAttribute('catalog_product', $codigo, $config); $codigo = 'fit_size'; $config = array('position' => 1, 'required' => 0, 'label' => 'Diferença do Encaixe (cm)', 'type' => 'varchar', 'input' => 'text', 'apply_to' => 'simple,bundle,grouped,configurable', 'note' => 'Exemplo: Se 1 item mede 10cm de altura, e 2 itens encaixados medem 11cm. A diferença é de 1cm.'); $setup->addAttribute('catalog_product', $codigo, $config); $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); // Add Correios Tab $setIds = $setup->getAllAttributeSetIds('catalog_product'); $attributes = array('volume_comprimento', 'volume_altura', 'volume_largura', 'postmethods', 'fit_size', 'posting_days'); foreach ($setIds as $setId) { $setup->addAttributeGroup('catalog_product', $setId, 'Correios', 2); $groupId = $setup->getAttributeGroupId('catalog_product', $setId, 'Correios'); foreach ($attributes as $attribute) { $attributeId = $setup->getAttributeId('catalog_product', $attribute); $setup->addAttributeToGroup('catalog_product', $setId, $groupId, $attributeId); } } $installer->endSetup();
<?php $installer = $this; $installer->startSetup(); $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $entityTypeId = $setup->getEntityTypeId('customer'); $attributeSetId = $setup->getDefaultAttributeSetId($entityTypeId); $attributeGroupId = $setup->getDefaultAttributeGroupId($entityTypeId, $attributeSetId); $setup->addAttribute('customer', 'dotmailer_contact_id', array('input' => 'text', 'type' => 'int', 'label' => 'Connector Contact ID', 'visible' => 1, 'required' => 0, 'user_defined' => 0, '')); $setup->addAttributeToGroup($entityTypeId, $attributeSetId, $attributeGroupId, 'dotmailer_contact_id', '999'); $oAttribute = Mage::getSingleton('eav/config')->getAttribute('customer', 'dotmailer_contact_id'); $oAttribute->setData('used_in_forms', array('adminhtml_customer')); $oAttribute->save(); $adminData = array(); $adminData[] = array('severity' => 4, 'date_added' => gmdate('Y-m-d H:i:s', time()), 'title' => 'Email Connector Was Installed. Please Enter Your API Credentials & Ensure Cron Jobs Are Running On Your Site (Find Out More)', 'description' => 'Email Connector Was Installed. Please Enter Your API Credentials & Ensure Cron Jobs Are Running On Your Site.', 'url' => 'http://www.magentocommerce.com/wiki/1_-_installation_and_configuration/how_to_setup_a_cron_job'); Mage::getModel('adminnotification/inbox')->parse($adminData); $setup->endSetup();
<?php /** * Provides a custom SOAP client to enable communication with Streicher's * Microsoft Dynamics Navision (NAV) ERP system via web services (SOAP/XMLRPC) * * @category Spe * @package Spe_NavisionConnector * @copyright Copyright (c) 2015 August Ash, Inc. (http://www.augustash.com) * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) */ /** @var $installer Mage_Core_Model_Resource_Setup */ $installer = $this; // Begin transaction $installer->startSetup(); $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $entityTypeId = $setup->getEntityTypeId('catalog_category'); $attributeSetId = $setup->getDefaultAttributeSetId($entityTypeId); $attributeGroupId = $setup->getDefaultAttributeGroupId($entityTypeId, $attributeSetId); $setup->addAttribute('catalog_category', 'thumbnail', array('type' => 'varchar', 'input' => 'image', 'backend' => 'catalog/category_attribute_backend_image', 'group' => 'General Information', 'label' => 'Thumbnail', 'visible' => 1, 'required' => 0, 'user_defined' => 1, 'frontend_input' => '', 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL, 'visible_on_front' => 1)); $setup->addAttributeToGroup($entityTypeId, $attributeSetId, $attributeGroupId, 'thumbnail', '5'); // End transaction $installer->endSetup();
<?php /* @var $installer Mage_Customer_Model_Entity_Setup */ $installer = $this; $installer->startSetup(); // Attributes $attributeSetup = new Mage_Eav_Model_Entity_Setup('core_setup'); $entityTypeId = $attributeSetup->getEntityTypeId('customer'); $attributeSetId = $attributeSetup->getDefaultAttributeSetId($entityTypeId); $attributeGroupId = $attributeSetup->getDefaultAttributeGroupId($entityTypeId, $attributeSetId); $installer->addAttribute("customer", "is_b2b_approved", ["type" => "int", "label" => "Is B2B Approved?", "input" => "select", "visible" => false, "required" => false, "default" => 0, "source" => "eav/entity_attribute_source_boolean", "unique" => false, "note" => ""]); $attribute = Mage::getSingleton("eav/config")->getAttribute("customer", "is_b2b_approved"); $attributeSetup->addAttributeToGroup($entityTypeId, $attributeSetId, $attributeGroupId, 'is_b2b_approved', '560'); $attribute->setData("used_in_forms", ["adminhtml_customer"])->setData("is_used_for_customer_segment", false)->setData("is_system", 0)->setData("is_user_defined", 1)->setData("is_visible", 0)->setData("sort_order", 560); $attribute->save(); $installer->endSetup();
<?php $installer = $this; $installer->startSetup(); $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $entityTypeId = $setup->getEntityTypeId('customer'); $attributeSetId = $setup->getDefaultAttributeSetId($entityTypeId); $attributeGroupId = $setup->getDefaultAttributeGroupId($entityTypeId, $attributeSetId); $setup->addAttribute('customer', 'linkedin_profile', array('label' => 'LinkedIn Profile URL', 'input' => 'text', 'type' => 'varchar', 'frontend_class' => 'validate-url validate-length maximum-length-250', 'visible' => true, 'visible_on_front' => true, 'adminhtml_only' => false, 'required' => false, 'user_defined' => true)); $setup->addAttributeToGroup($entityTypeId, $attributeSetId, $attributeGroupId, 'linkedin_profile', '900'); $attribute = Mage::getSingleton('eav/config')->getAttribute('customer', 'linkedin_profile'); $attribute->setData('used_in_forms', array('customer_account_create', 'customer_account_edit', 'adminhtml_customer')); $attribute->save(); $setup->endSetup();
<?php $installer = $this; $installer->startSetup(); $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $entityTypeId = $setup->getEntityTypeId('customer_address'); $attributeSetId = $setup->getDefaultAttributeSetId($entityTypeId); $attributeGroupId = $setup->getDefaultAttributeGroupId($entityTypeId, $attributeSetId); $setup->addAttributeToGroup($entityTypeId, $attributeSetId, $attributeGroupId, 'tax_invoice', '999'); $setup->endSetup(); $installer->endSetup();
<?php /* @var $installer Mage_Customer_Model_Entity_Setup */ $installer = $this; $installer->startSetup(); // Attributes $attributeSetup = new Mage_Eav_Model_Entity_Setup('core_setup'); $entityTypeId = $attributeSetup->getEntityTypeId('customer'); $attributeSetId = $attributeSetup->getDefaultAttributeSetId($entityTypeId); $attributeGroupId = $attributeSetup->getDefaultAttributeGroupId($entityTypeId, $attributeSetId); $installer->addAttribute("customer", "is_b2b_blocked", ["type" => "int", "label" => "Is B2B Blocked?", "input" => "select", "visible" => false, "required" => false, "default" => 0, "source" => "eav/entity_attribute_source_boolean", "unique" => false, "note" => ""]); $attribute = Mage::getSingleton("eav/config")->getAttribute("customer", "is_b2b_blocked"); $attributeSetup->addAttributeToGroup($entityTypeId, $attributeSetId, $attributeGroupId, "is_b2b_blocked", "570"); $attribute->setData("used_in_forms", ["adminhtml_customer"])->setData("is_used_for_customer_segment", false)->setData("is_system", 0)->setData("is_user_defined", 1)->setData("is_visible", 0)->setData("sort_order", 570); $attribute->save(); $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 $installer = $this; $installer->startSetup(); $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $entityTypeId = $setup->getEntityTypeId('catalog_product'); $select = $this->_conn->select()->from($this->getTable('eav/attribute_set'))->where('entity_type_id = :entity_type_id'); $sets = $this->_conn->fetchAll($select, array('entity_type_id' => $entityTypeId)); foreach ($sets as $set) { $setup->addAttributeToGroup('catalog_product', $set['attribute_set_id'], 'Prices', 'res_prices'); $setup->addAttributeGroup('catalog_product', $set['attribute_set_id'], 'Inventory'); $setup->addAttributeToGroup('catalog_product', $set['attribute_set_id'], 'Inventory', 'payperrentals_quantity'); $setup->addAttributeToGroup('catalog_product', $set['attribute_set_id'], 'Inventory', 'payperrentals_use_serials'); $setup->addAttributeToGroup('catalog_product', $set['attribute_set_id'], 'Inventory', 'res_serialnumbers'); } $installer->endSetup();
public function importAttributeInsideGroup($attribute_group_id, $attributeSetId, $attribute_code, $attribute_sort_order) { $mapobj = Mage::getModel('customimport/customimport'); $attributeGroupId = $mapobj->getAttributeGroupByExternalId($attribute_group_id, $attributeSetId); // $attribute_group_id is external group id if ($attributeGroupId) { $setup = new Mage_Eav_Model_Entity_Setup('core_setup'); $attribute_id = $setup->getAttributeId('catalog_product', $attribute_code); if (!$attribute_id) { $this->customHelper->reportError($this->customHelper->__("Attribute code %s is missing during attribute group %s import", $attribute_code, $attribute_group_id)); } else { $attribute_exists = $mapobj->isAttributeExistsInGroup($attribute_id, $attributeGroupId); if ($attribute_exists) { $mapobj->updateSequenceOfAttribute($attributeGroupId, $attribute_id, $attribute_sort_order, $attribute_code, $attribute_group_id); } else { $setup->addAttributeToGroup('catalog_product', $attributeSetId, $attributeGroupId, $attribute_id, $attribute_sort_order); } } } }
<?php /* @var $installer Mage_Customer_Model_Entity_Setup */ $installer = $this; $installer->startSetup(); // Attributes $attributeSetup = new Mage_Eav_Model_Entity_Setup('core_setup'); $entityTypeId = $attributeSetup->getEntityTypeId('customer'); $attributeSetId = $attributeSetup->getDefaultAttributeSetId($entityTypeId); $attributeGroupId = $attributeSetup->getDefaultAttributeGroupId($entityTypeId, $attributeSetId); $installer->addAttribute("customer", "retail_price_list", ["type" => "varchar", "label" => "Retail Price List", "input" => "text", "visible" => true, "required" => false, "default" => "", "frontend" => "", "unique" => false, "note" => ""]); $attribute = Mage::getSingleton("eav/config")->getAttribute("customer", "retail_price_list"); $attributeSetup->addAttributeToGroup($entityTypeId, $attributeSetId, $attributeGroupId, 'retail_price_list', '550'); $attribute->setData("used_in_forms", ["adminhtml_customer"])->setData("is_used_for_customer_segment", false)->setData("is_system", 0)->setData("is_user_defined", 1)->setData("is_visible", 0)->setData("sort_order", 550); $attribute->save(); $installer->endSetup();