The database changes
//Add house number and addon
$customerAddressEntity = 'customer_address_entity';
$quoteAddress = 'quote_address';
$salesOrderAddress = 'sales_order_address';
$installer->getConnection()
->addColumn(
$installer->getTable($customerAddressEntity), 'number', [
'type' => Table::TYPE_INTEGER,
'unsigned' => true,
'comment' => 'House number'
]
);
$installer->getConnection()
->addColumn(
$installer->getTable($customerAddressEntity), 'number_addon', [
'type' => Table::TYPE_TEXT,
'length' => 20,
'comment' => 'House number addon'
]
);
$installer->getConnection()
->addColumn(
$installer->getTable($quoteAddress), 'number', [
'type' => Table::TYPE_INTEGER,
'unsigned' => true,
'comment' => 'House number'
]
);
$installer->getConnection()
->addColumn(
$installer->getTable($quoteAddress), 'number_addon', [
'type' => Table::TYPE_TEXT,
'length' => 20,
'comment' => 'House number addon'
]
);
$installer->getConnection()
->addColumn(
$installer->getTable($salesOrderAddress), 'number', [
'type' => Table::TYPE_INTEGER,
'unsigned' => true,
'comment' => 'House number'
]
);
$installer->getConnection()
->addColumn(
$installer->getTable($salesOrderAddress), 'number_addon', [
'type' => Table::TYPE_TEXT,
'length' => 20,
'comment' => 'House number addon'
]
);And the attributes
class InstallData implements \Magento\Framework\Setup\InstallDataInterface
{
/**
* Customer setup factory
* @var CustomerSetupFactory
*/
private $customerSetupFactory;
/**
* Init
* @param CustomerSetupFactory $customerSetupFactory
*/
public function __construct(\Magento\Customer\Setup\CustomerSetupFactory $customerSetupFactory)
{
$this->customerSetupFactory = $customerSetupFactory;
}
/**
* Upgrade
* @param ModuleDataSetupInterface $setup
* @param ModuleContextInterface $context
*/
public function install(ModuleDataSetupInterface $setup, ModuleContextInterface $context)
{
$installer = $setup;
$installer->startSetup();
$this->addCustomerAddressAttributes($installer);
$installer->endSetup();
}
/**
* Add customer address attributes
* @param object $installer
*/
protected function addCustomerAddressAttributes($installer)
{
/** @var CustomerSetup $customerSetup */
$customerSetup = $this->customerSetupFactory->create(['setup' => $installer]);
$customerAddressEntity = $customerSetup->getEavConfig()->getEntityType('customer_address');
$attributeSetId = $customerAddressEntity->getDefaultAttributeSetId();
/** @var $attributeSet AttributeSet */
$attributeSet = $this->attributeSetFactory->create();
$attributeGroupId = $attributeSet->getDefaultGroupId($attributeSetId);
$attributesInfo = [
'number' => [
'label' => 'House number',
'type' => 'static',
'input' => 'text',
'position' => 71,
'sort_order' => 71,
'visible' => true,
'required' => true,
'user_defined' => true,
'system' => 0,
],
'number_addon' => [
'label' => 'House number addon',
'visible' => true,
'required' => false,
'type' => 'static',
'input' => 'text',
'position' => 72,
'sort_order' => 72,
'validate_rules' => 'a:1:{s:15:"max_text_length";i:20;}',
'user_defined' => true,
'system' => 0,
]
];
foreach ($attributesInfo as $attributeCode => $attributeParams) {
$customerSetup->addAttribute('customer_address', $attributeCode, $attributeParams);
}
$numberAttribute = $customerSetup->getEavConfig()->getAttribute('customer_address', 'number');
$numberAttribute->addData([
'attribute_set_id' => $attributeSetId,
'attribute_group_id' => $attributeGroupId,
'used_in_forms' => ['adminhtml_customer_address', 'customer_address_edit', 'customer_register_address'],
]);
$numberAttribute->save();
$numberAddonAttribute = $customerSetup->getEavConfig()->getAttribute('customer_address', 'number_addon');
$numberAddonAttribute->addData([
'attribute_set_id' => $attributeSetId,
'attribute_group_id' => $attributeGroupId,
'used_in_forms' => ['adminhtml_customer_address', 'customer_address_edit', 'customer_register_address'],
]);
$numberAddonAttribute->save();
}
}
