In this blog, we will allow the admin to assign a blog to any author. Also, the admin will be able to add related products to the blog. <\/p>\n\n\n\n
Customer Collection<\/h3>\n\n\n\n
We will add the assign author feature in the status tab only. So let’s edit the Block\/Adminhtml\/Blog\/Edit\/Tab\/Status.php<\/em><\/p>\n\n\n\n We have used And in the getAuthorOptions<\/strong> function, we have loaded the collection through the model.<\/p>\n\n\n\n After that, we created an associative array of $authors<\/strong> which will be used for options. In the $authors<\/strong> array we have added an entry for admin too with the id as 0.<\/p>\n\n\n\n Note that we could have also used the collection class \\Magento\\Customer\\Model\\ResourceModel\\Customer\\CollectionFactory<\/strong>.<\/p>\n\n\n\n Now you will see the field as shown below,<\/p>\n\n\n\n Let’s add the related product feature. For that, we will create a new tab which means we will have to edit the Block\/Adminhtml\/Blog\/Edit\/Tabs.php<\/em><\/p>\n\n\n\n Updated code for Block\/Adminhtml\/Blog\/Edit\/Tabs.php<\/em> file<\/p>\n\n\n\n Here we have just added a new tab with Now let’s write code for the related products tab. We will create the class as Block\/Adminhtml\/Blog\/Edit\/Tab\/RelatedProducts.php<\/em><\/p>\n\n\n\n Code for Block\/Adminhtml\/Blog\/Edit\/Tab\/RelatedProducts.php<\/em> file<\/p>\n\n\n\n Here we have used the products collection class which is \\Magento\\Catalog\\Model\\ResourceModel\\Product\\CollectionFactory<\/strong><\/p>\n\n\n\n but could have also used the model which is \\Magento\\Catalog\\Model\\ProductFactory<\/strong>.<\/p>\n\n\n\n One more thing to note here is ->addAttributeToSelect(‘name’)<\/strong> since there is a lot of data for a product. <\/p>\n\n\n\n By default, Magento only loads basic details such as id, sku, type, etc. So we have to use addAttributeToSelect<\/strong><\/strong> to load the additional fields such as name here.<\/p>\n\n\n\n Also please note that it is a multi-select type field so the syntax for the field and option is a little bit different than what we have seen so far.<\/p>\n\n\n\n Now you should see the related products tab like,<\/p>\n\n\n\n Also, we have to modify the save controller a little bit.<\/p>\n\n\n\n To add the column let’s modify the db schema etc\/db_schema.xml<\/em><\/p>\n\n\n\n Updated code for db schema etc\/db_schema.xml<\/em> file<\/p>\n\n\n\n We have just added a column tag to add the column and the name of the column is products<\/strong>. Now we have to run these commands if you recall from Magento 2 Development 03: Creating Tables<\/a> blog.<\/p>\n\n\n\n Updated code for Controller\/Adminhtml\/Manage\/Save.php<\/em> file<\/p>\n\n\n\n We have set the fields just like before. But there are minor changes for the $data[‘products’]<\/strong><\/strong> field to check whether the Related Products are set or not. <\/p>\n\n\n\n Also, the $data[‘products’]<\/strong> is a multi-select type field we have used the implode<\/strong> function to convert to string.<\/p>\n\n\n\n We are done now. You should be able to save all the fields.<\/p>\n\n\n\n We have seen how we can use models to perform CRUD operations. Magento 2 has another thing called Repository to perform these operations. <\/p>\n\n\n\n You can think of repositories as higher level implementation than the factories. Repositories have fixed methods like get<\/strong>, list<\/strong>, save<\/strong>, and delete<\/strong>.<\/p>\n\n\n\n Magento recommends using the corresponding repositories instead of the model.<\/p>\n\n\n\n Please go through this blog and also google “Repository in Magento 2” and “Difference between Repository and Factory in Magento 2” to get a better understanding.<\/p>\n\n\n\n Magento2 Repository Design Pattern<\/strong><\/a><\/p>\n\n\n\n Please implement these recommended exercises on the front-end. Try with the factory and repository to get a better idea about them.<\/p>\n\n\n\n 1. List orders of a customer given the email id.<\/p>\n\n\n\n 2. List items of an order given the order increment id.<\/p>\n\n\n\n 3. List products and quantity purchased by a customer given the customer name (assume customers have unique names).<\/p>\n\n\n\n 4. Implement product search functionality based on the product name and sku with the sort by price and pagination feature.<\/p>\n\n\n\n 5. Print the category tree structure.<\/p>\n\n\n\n Previous Blog -> Magento 2 Development 23: Add Button<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<?php\nnamespace Webkul\\BlogManager\\Block\\Adminhtml\\Blog\\Edit\\Tab;\n\nclass Status extends \\Magento\\Backend\\Block\\Widget\\Form\\Generic\n{\n \/**\n * @var \\Webkul\\BlogManager\\Model\\Blog\\Status\n *\/\n protected $blogStatus;\n\n \/**\n * @var \\Magento\\Customer\\Model\\CustomerFactory\n *\/\n protected $customerFactory;\n\n \/**\n * Dependency Initilization\n *\n * @param \\Magento\\Backend\\Block\\Template\\Context $context\n * @param \\Magento\\Framework\\Registry $registry\n * @param \\Magento\\Framework\\Data\\FormFactory $formFactory\n * @param \\Webkul\\BlogManager\\Model\\Blog\\Status $blogStatus\n * @param \\Magento\\Customer\\Model\\CustomerFactory $customerFactory\n * @param array $data\n *\/\n public function __construct(\n \\Magento\\Backend\\Block\\Template\\Context $context,\n \\Magento\\Framework\\Registry $registry,\n \\Magento\\Framework\\Data\\FormFactory $formFactory,\n \\Webkul\\BlogManager\\Model\\Blog\\Status $blogStatus,\n \\Magento\\Customer\\Model\\CustomerFactory $customerFactory,\n array $data = []\n ) {\n $this->blogStatus = $blogStatus;\n $this->customerFactory = $customerFactory;\n parent::__construct($context, $registry, $formFactory, $data);\n }\n\n \/**\n * Prepare form data\n *\n * @return \\Magento\\Backend\\Block\\Widget\\Form\n *\/\n protected function _prepareForm()\n {\n $model = $this->_coreRegistry->registry('blog_data');\n\n $form = $this->_formFactory->create();\n\n $form->setHtmlIdPrefix('blogmanager_');\n\n $fieldset = $form->addFieldset(\n 'base_fieldset',\n ['legend' => __('Edit Blog'), 'class' => 'fieldset-wide']\n );\n\n $fieldset->addField(\n 'status',\n 'select',\n [\n 'name' => 'status',\n 'label' => __('Status'),\n 'options' => [0=>__('Disabled'), 1=>__('Enabled')],\n 'id' => 'status',\n 'title' => __('Status'),\n 'class' => 'required-entry',\n 'required' => true,\n ]\n );\n\n $fieldset->addField(\n 'user_id',\n 'select',\n [\n 'name' => 'user_id',\n 'label' => __('Author'),\n 'options' => $this->getAuthorOptions(),\n 'id' => 'user_id',\n 'title' => __('Author'),\n 'class' => 'required-entry',\n 'required' => true,\n ]\n );\n\n $form->setValues($model->getData());\n $this->setForm($form);\n\n return parent::_prepareForm();\n }\n\n \/**\n * Provides Author options\n *\n * @return array\n *\/\n private function getAuthorOptions()\n {\n $collection = $this->customerFactory->create()->getCollection();\n $authors = [0=>'Admin'];\n foreach ($collection as $model) {\n $authors[$model->getId()] = $model->getName();\n }\n return $authors;\n }\n}<\/pre>\n\n\n\n\\Magento\\Customer\\Model\\CustomerFactory<\/code><\/strong> which is a model for customer data. <\/p>\n\n\n\n![\"2021-07-22_16-22\"](\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/2021-07-22_16-22-1200x526.png\")
<\/figure>\n\n\n\n
Product Collection<\/h3>\n\n\n\n<?php\nnamespace Webkul\\BlogManager\\Block\\Adminhtml\\Blog\\Edit;\n\nclass Tabs extends \\Magento\\Backend\\Block\\Widget\\Tabs\n{\n \/**\n * @var \\Magento\\Framework\\Registry\n *\/\n protected $_coreRegistry;\n\n \/**\n * Dependency Initilization\n *\n * @param \\Magento\\Backend\\Block\\Template\\Context $context\n * @param \\Magento\\Framework\\Json\\EncoderInterface $jsonEncoder\n * @param \\Magento\\Backend\\Model\\Auth\\Session $authSession\n * @param \\Magento\\Framework\\Registry $coreRegistry\n * @param array $data\n *\/\n public function __construct(\n \\Magento\\Backend\\Block\\Template\\Context $context,\n \\Magento\\Framework\\Json\\EncoderInterface $jsonEncoder,\n \\Magento\\Backend\\Model\\Auth\\Session $authSession,\n \\Magento\\Framework\\Registry $coreRegistry,\n array $data = []\n ) {\n $this->_coreRegistry = $coreRegistry;\n parent::__construct($context, $jsonEncoder, $authSession, $data);\n }\n\n \/**\n * Dependency Initilization\n *\n * @return void\n *\/\n protected function _construct()\n {\n parent::_construct();\n $this->setId('blog_tabs');\n $this->setDestElementId('edit_form');\n $this->setTitle(__('Blog Data'));\n }\n\n \/**\n * Prepare form data\n *\n * @return \\Magento\\Backend\\Block\\Widget\\Form\n *\/\n protected function _prepareLayout()\n {\n $this->addTab(\n 'main',\n [\n 'label' => __('Blog Data'),\n 'content' => $this->getLayout()->createBlock(\n 'Webkul\\BlogManager\\Block\\Adminhtml\\Blog\\Edit\\Tab\\Main'\n )->toHtml(),\n 'active' => true\n ]\n );\n\n $this->addTab(\n 'status',\n [\n 'label' => __('Blog Status'),\n 'content' => $this->getLayout()->createBlock(\n 'Webkul\\BlogManager\\Block\\Adminhtml\\Blog\\Edit\\Tab\\Status'\n )->toHtml()\n ]\n );\n\n $this->addTab(\n 'related_products',\n [\n 'label' => __('Related Products'),\n 'content' => $this->getLayout()->createBlock(\n 'Webkul\\BlogManager\\Block\\Adminhtml\\Blog\\Edit\\Tab\\RelatedProducts'\n )->toHtml()\n ]\n );\n\n return parent::_prepareLayout();\n }\n}<\/pre>\n\n\n\n$this->addTab<\/code><\/strong> function. <\/p>\n\n\n\n<?php\nnamespace Webkul\\BlogManager\\Block\\Adminhtml\\Blog\\Edit\\Tab;\n\nclass RelatedProducts extends \\Magento\\Backend\\Block\\Widget\\Form\\Generic\n{\n \/**\n * @var \\Magento\\Catalog\\Model\\ResourceModel\\Product\\CollectionFactory\n *\/\n protected $productCollectionFactory;\n\n \/**\n * Dependency Initilization\n *\n * @param \\Magento\\Backend\\Block\\Template\\Context $context\n * @param \\Magento\\Framework\\Registry $registry\n * @param \\Magento\\Framework\\Data\\FormFactory $formFactory\n * @param \\Magento\\Catalog\\Model\\ResourceModel\\Product\\CollectionFactory $productCollectionFactory\n * @param array $data\n *\/\n public function __construct(\n \\Magento\\Backend\\Block\\Template\\Context $context,\n \\Magento\\Framework\\Registry $registry,\n \\Magento\\Framework\\Data\\FormFactory $formFactory,\n \\Magento\\Catalog\\Model\\ResourceModel\\Product\\CollectionFactory $productCollectionFactory,\n array $data = []\n ) {\n $this->productCollectionFactory = $productCollectionFactory;\n parent::__construct($context, $registry, $formFactory, $data);\n }\n\n \/**\n * Prepare form data\n *\n * @return \\Magento\\Backend\\Block\\Widget\\Form\n *\/\n protected function _prepareForm()\n {\n \n $model = $this->_coreRegistry->registry('blog_data');\n\n $form = $this->_formFactory->create();\n\n $form->setHtmlIdPrefix('blogmanager_');\n\n $fieldset = $form->addFieldset(\n 'base_fieldset',\n ['legend' => __('Related Products'), 'class' => 'fieldset-wide']\n );\n\n $fieldset->addField(\n 'products',\n 'multiselect',\n [\n 'name' => 'products',\n 'label' => __('Products'),\n 'values' => $this->getProductOptions(),\n 'id' => 'products',\n 'title' => __('Products'),\n 'required' => false,\n ]\n );\n\n $form->setValues($model->getData());\n $this->setForm($form);\n\n return parent::_prepareForm();\n }\n\n \/**\n * Get Product Options\n *\n * @return array\n *\/\n private function getProductOptions()\n {\n $collection = $this->productCollectionFactory->create()->addAttributeToSelect('name');\n $products = [];\n foreach ($collection as $model) {\n $products[] = ['value'=>$model->getId(), 'label'=>$model->getName()];\n }\n return $products;\n }\n}<\/pre>\n\n\n\n![\"2021-07-22_16-44\"](\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/2021-07-22_16-44-1200x612.png\")
<\/figure>\n\n\n\n
It looks well and good but we won’t be able to save the data yet. First of all, we will have to create a new column in the table for the related products.<\/p>\n\n\n\n<?xml version="1.0"?>\n<schema xmlns:xsi="http:\/\/www.w3.org\/2001\/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:Setup\/Declaration\/Schema\/etc\/schema.xsd">\n <table name="blogmanager_blog" resource="default" engine="innodb" comment="Blogs Table">\n <column xsi:type="int" name="entity_id" padding="10" unsigned="true" nullable="false" identity="true" comment="Entity Id"\/>\n <column xsi:type="int" name="user_id" padding="10" unsigned="true" nullable="false" comment="Customer\/User Id"\/>\n <column xsi:type="varchar" name="title" nullable="false" length="255" comment="Blog Title"\/>\n <column xsi:type="longtext" name="content" nullable="false" comment="Blog Content"\/>\n <column xsi:type="smallint" name="status" padding="11" unsigned="false" nullable="false" default="0" comment="Blog Status"\/>\n <column xsi:type="timestamp" name="created_at" on_update="false" nullable="false" default="CURRENT_TIMESTAMP" comment="Creation Time"\/>\n <column xsi:type="timestamp" name="updated_at" on_update="true" nullable="false" default="CURRENT_TIMESTAMP" comment="Updated At"\/>\n <column xsi:type="varchar" name="products" nullable="false" length="255" comment="Related products"\/>\n <constraint xsi:type="primary" referenceId="PRIMARY">\n <column name="entity_id"\/>\n <\/constraint>\n <index referenceId="BLOGMANAGER_BLOG_USER_ID" indexType="btree">\n <column name="user_id"\/>\n <\/index>\n <\/table>\n <table name="blogmanager_comment" resource="default" engine="innodb" comment="Blog Comments Table">\n <column xsi:type="int" name="entity_id" padding="10" unsigned="true" nullable="false" identity="true" comment="Entity Id"\/>\n <column xsi:type="int" name="blog_id" padding="10" unsigned="true" nullable="false" comment="Blog Id"\/>\n <column xsi:type="int" name="user_id" padding="10" unsigned="true" nullable="false" comment="User Id"\/>\n <column xsi:type="varchar" name="screen_name" nullable="false" length="255" comment="Screen Name"\/>\n <column xsi:type="text" name="comment" nullable="false" comment="Comment"\/>\n <column xsi:type="smallint" name="status" padding="11" unsigned="false" nullable="false" default="0" comment="Status"\/>\n <column xsi:type="timestamp" name="created_at" on_update="false" nullable="false" default="CURRENT_TIMESTAMP" comment="Creation Time"\/>\n <constraint xsi:type="primary" referenceId="PRIMARY">\n <column name="entity_id"\/>\n <\/constraint>\n <constraint xsi:type="foreign" referenceId="FK_BLOG_COMMENT" table="blogmanager_comment" column="blog_id" referenceTable="blogmanager_blog" referenceColumn="entity_id" onDelete="CASCADE"\/>\n <index referenceId="BLOGMANAGER_COMMENT_BLOG_ID" indexType="btree">\n <column name="blog_id"\/>\n <\/index>\n <\/table>\n<\/schema><\/pre>\n\n\n\n
php bin\/magento setup:db-declaration:generate-whitelist --module-name=Webkul_BlogManager\n\nphp bin\/magento setup:upgrade\n\nNow we have to write code to save the values in db. So we will edit <em>Controller\/Adminhtml\/Manage\/Save.php<\/em><\/pre>\n\n\n\n
<?php\nnamespace Webkul\\BlogManager\\Controller\\Adminhtml\\Manage;\n\nuse Magento\\Backend\\App\\Action;\nuse Magento\\Backend\\App\\Action\\Context;\n\nclass Save extends Action\n{\n \/**\n * @var \\Webkul\\BlogManager\\Model\\BlogFactory\n *\/\n protected $blogFactory;\n\n \/**\n * Dependency Initilization\n *\n * @param Context $context\n * @param \\Webkul\\BlogManager\\Model\\BlogFactory $blogFactory\n *\/\n public function __construct(\n Context $context,\n \\Webkul\\BlogManager\\Model\\BlogFactory $blogFactory\n ) {\n $this->blogFactory = $blogFactory;\n parent::__construct($context);\n }\n\n \/**\n * Provides content\n *\n * @return Magento\\Framework\\Controller\\Result\\Redirect\n *\/\n public function execute()\n {\n $resultRedirect = $this->resultRedirectFactory->create();\n $data = $this->getRequest()->getParams();\n if (isset($data['entity_id']) && $data['entity_id']) {\n $model = $this->blogFactory->create()->load($data['entity_id']);\n $model->setTitle($data['title'])\n ->setContent($data['content'])\n ->setStatus($data['status'])\n ->setUserId($data['user_id']);\n if (isset($data['products'])) {\n $model->setProducts(implode(',', $data['products']));\n } else {\n $model->setProducts('');\n }\n $model->save();\n $this->messageManager->addSuccess(__('You have updated the blog successfully.'));\n } else {\n $model = $this->blogFactory->create();\n $model->setTitle($data['title'])\n ->setContent($data['content'])\n ->setStatus($data['status'])\n ->setUserId($data['user_id']);\n if (isset($data['products'])) {\n $model->setProducts(implode(',', $data['products']));\n } else {\n $model->setProducts('');\n }\n $model->save();\n $this->messageManager->addSuccess(__('You have successfully created the blog.'));\n }\n return $resultRedirect->setPath('*\/*\/');\n }\n\n \/**\n * Check Autherization\n *\n * @return boolean\n *\/\n public function _isAllowed()\n {\n return $this->_authorization->isAllowed('Webkul_BlogManager::save');\n }\n}<\/pre>\n\n\n\nRepository<\/h2>\n\n\n\n
Recommended Exercises<\/h2>\n\n\n\n
Next Blog -> Magento 2 Development 25: Helper<\/a><\/p>\n\n\n\n