Mrthdrb

I have created a sales attribute "port" in sale_order table. I want to POST this post attribute in shipping information API payload and get it in response as extension attribute. I also want to save the value of extension attribute to save in DB using Api only i.e. there is no extra filed for port in backend or frontend.
Please help. Thanks in advance.

Vendor/Module/Setup/InstallSchema.php

<?php

namespace VendorModuleSetup;

use MagentoFrameworkSetupInstallSchemaInterface;
use MagentoFrameworkSetupSchemaSetupInterface;
use MagentoFrameworkSetupModuleContextInterface;

class InstallSchema implements InstallSchemaInterface

 public function install(SchemaSetupInterface $setup, ModuleContextInterface $context)
 
 $setup->startSetup();

 $tableName = $setup->getTable('sales_order_grid');

 $tableNameSales = $setup->getTable('sales_order');
 $tableNameQuote = $setup->getTable('quote');

 // Check if the table already exists

 $columns = [
 'delivery_date' => [
 'type' => 'datetime',
 'nullable' => true,
 'comment' => 'Delivery Date',
 ],
 'no_of_days' => [
 'type' => MagentoFrameworkDBDdlTable::TYPE_INTEGER,
 'nullable' => true,
 'comment' => 'Number of Days',
 ],
 'no_of_crew' => [
 'type' => MagentoFrameworkDBDdlTable::TYPE_INTEGER,
 'nullable' => true,
 'comment' => 'Number of Crew',
 ],
 'port' => [
 'type' => MagentoFrameworkDBDdlTable::TYPE_INTEGER,
 'nullable' => true,
 'comment' => 'Port',
 ]
 ];

 $connection = $setup->getConnection();

 foreach ($columns as $name => $definition) 
 $connection->addColumn($tableName, $name, $definition);
 $connection->addColumn($tableNameSales, $name, $definition);
 $connection->addColumn($tableNameQuote, $name, $definition);
 

 $setup->endSetup();
 

Vendor/Module/etc/extension_attributes.xml

<?xml version="1.0"?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:Api/etc/extension_attributes.xsd">
 <extension_attributes for="MagentoCheckoutApiDataShippingInformationInterface">
 <attribute code="delivery_date" type="string"/>
 </extension_attributes>

Vendor/Module/etc/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="MagentoCheckoutModelShippingInformationManagement">
 <plugin name="sr_save_delivery_date_in_quote" type="VendorModulePluginCheckoutModelShippingInformationManagement" sortOrder="1"/>
 </type>
 <virtualType name="MagentoSalesModelResourceModelOrderGrid" type="MagentoSalesModelResourceModelGrid">
 <arguments>
 <argument name="columns" xsi:type="array">
 <item name="delivery_date" xsi:type="string">sales_order.delivery_date</item>
 </argument>
 </arguments>
 </virtualType>
</config>

Vendor/Module/Plugin/Checkout/Model/ShippingInformationManagement.php

<?php
namespace VendorModulePluginCheckoutModel;
class ShippingInformationManagement

 protected $quoteRepository;
 public function __construct(
 MagentoQuoteModelQuoteRepository $quoteRepository
 ) 
 $this->quoteRepository = $quoteRepository;
 
 /**
 * @param MagentoCheckoutModelShippingInformationManagement $subject
 * @param $cartId
 * @param MagentoCheckoutApiDataShippingInformationInterface $addressInformation
 */
 public function beforeSaveAddressInformation(
 MagentoCheckoutModelShippingInformationManagement $subject,
 $cartId,
 MagentoCheckoutApiDataShippingInformationInterface $addressInformation
 ) 
 $extAttributes = $addressInformation->getExtensionAttributes();
 $deliveryDate = $extAttributes->getDeliveryDate();
 $quote = $this->quoteRepository->getActive($cartId);
 $quote->setDeliveryDate($deliveryDate);