Magento 2 Load database value to custom field in product attribute

Question

I am adding a custom field to product attributes with a plugin providing the adminhtml display.

I have it visible in Store -> Attributes -> Product -> Edit attribute and it works okay to save, but when editing a product attribute the stored value is not loaded. The value is initially correctly stored in the database, subsequent visits to edit do not load the saved value from the database.

How can I have this yesno successfully pull the stored value when an admin is editing the attribute? I'm not sure why the value isn't being pulled with the current one being selected. This is Magento 2.2.7

CompanyName\ModuleName\Setup\UpgradeSchema.php

<?php
namespace CompanyName\ModuleName\Setup;
use Magento\Framework\Setup\UpgradeSchemaInterface;
use Magento\Framework\Setup\ModuleContextInterface;
use Magento\Framework\Setup\SchemaSetupInterface;
class UpgradeSchema implements UpgradeSchemaInterface{
 public function upgrade(SchemaSetupInterface $setup, ModuleContextInterface $context){
 if (version_compare($context->getVersion(), '1.0.1') < 0) {
 $setup->startSetup();
 $setup->getConnection()->addColumn(
 $setup->getTable('catalog_eav_attribute'),
 'my_custom_field',
 ['type' => \Magento\Framework\DB\Ddl\Table::TYPE_SMALLINT,
 'length' => '1',
 'nullable' => false,
 'unsigned' => true,
 'default' => '0',
 'comment' => 'This is a custom field']);
 $setup->endSetup();
 } } }

CompanyName\ModuleName\Plugin\Block\Adminhtml\Product\Attribute\Edit\Tab\Front.php

<?php
namespace CompanyName\ModuleName\Plugin\Block\Adminhtml\Product\Attribute\Edit\Tab;

class Front
{

    /**
     * @var Yesno
     */
    protected $_yesNo;

    /**
     * @param Magento\Config\Model\Config\Source\Yesno $yesNo
     */
    public function __construct(
        \Magento\Config\Model\Config\Source\Yesno $yesNo
    ) {
        $this->_yesNo = $yesNo;
    }

    /**
     * Get form HTML
     *
     * @return string
     */
    public function aroundGetFormHtml(
        \Magento\Catalog\Block\Adminhtml\Product\Attribute\Edit\Tab\Front $subject,
        \Closure $proceed
    )
    {

        $yesnoSource = $this->_yesNo->toOptionArray();
        $form = $subject->getForm();
        $fieldset = $form->getElement('front_fieldset');
        $fieldset->addField(
            'my_custom_field',
            'select',
            [
                'name' => 'my_custom_field',
                'label' => __('Label for my custom field'),
                'title' => __('Title for my custom field'),
                'note' => __('Note for my custom field.'),
                'values' => $yesnoSource,
            ]
        );
        return $proceed();
    }
}

CompanyName/ModuleName/etc/adminhtml/di.xml

<?xml version="1.0"?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:ObjectManager/etc/config.xsd">
    <type name="Magento\Catalog\Block\Adminhtml\Product\Attribute\Edit\Tab\Front">
        <plugin name="companyname_attribute_edit_form" type="CompanyName\ModuleName\Plugin\Block\Adminhtml\Product\Attribute\Edit\Tab\Front" sortOrder="1"/>
    </type>
</config>

Rasik Miyani · Accepted Answer · 2019-07-11 17:08:26Z

If you need to select yes/no value show at selected at edit time than just change the file code of

CompanyName\ModuleName\Plugin\Block\Adminhtml\Product\Attribute\Edit\Tab\Front.php

<?php
namespace CompanyName\ModuleName\Plugin\Block\Adminhtml\Product\Attribute\Edit\Tab;


use Magento\Backend\Block\Template\Context;
use Magento\Backend\Block\Widget\Form;
use Magento\Backend\Block\Widget\Form\Generic;
use Magento\Config\Model\Config\Source\Yesno;
use Magento\Catalog\Model\Entity\Attribute;
use Magento\Eav\Block\Adminhtml\Attribute\PropertyLocker;
use Magento\Framework\Data\FormFactory;
use Magento\Framework\Registry;

class Front extends Generic
{
        /**
     * @var Yesno
     */
    protected $_yesNo;

    /**
     * @param Magento\Config\Model\Config\Source\Yesno $yesNo
     */
    public function __construct(
        Context $context,
        Registry $registry,
        FormFactory $formFactory,
        Yesno $yesNo,
        PropertyLocker $propertyLocker,
        array $data = []
    ) {
        $this->_yesNo = $yesNo;
        $this->propertyLocker = $propertyLocker;
        parent::__construct($context, $registry, $formFactory, $data);
    }


    public function aroundGetFormHtml(
        \Magento\Catalog\Block\Adminhtml\Product\Attribute\Edit\Tab\Front $subject,
        \Closure $proceed
    ) {
        $attributeObject = $this->_coreRegistry->registry('entity_attribute');
        //Your plugin code
        $yesnoSource = $this->_yesNo->toOptionArray();
        $form = $subject->getForm();
        $fieldset = $form->getElement('front_fieldset');


        $fieldset->addField(
            'my_custom_field',
            'select',
            [
                'name' => 'my_custom_field',
                'label' => __('Label for my custom field'),
                'title' => __('Title for my custom field'),
                'note' => __('Note for my custom field.'),
                'values' => $yesnoSource,
            ]
        );
        $this->_eventManager->dispatch(
            'adminhtml_catalog_product_attribute_edit_frontend_prepare_form',
            ['form' => $form, 'attribute' => $attributeObject]
        );

        $this->setForm($form);
        $form->setValues($attributeObject->getData());
        $this->propertyLocker->lock($form);

        return $proceed();
    }
}

if helpful than please give upvote. Thanks

This works, thank you! Did I miss the registry part which queries for the stored data and then needed the $form ->setvalue to set the data to the select dropdown? — 2aptech
– 2aptech, Commented Jul 11, 2019 at 21:06

Stack Exchange Network

Magento 2 Load database value to custom field in product attribute

1 Answer 1

Your Answer

Hot Network Questions

Magento 2 Load database value to custom field in product attribute

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions