Mrthdrb

Is it reasonable to ask other researchers to send me their previous grant applications?

Is it possible to make a 9x9 table fit within the default margins?

Can a PhD from a non-TU9 German university become a professor in a TU9 university?

How exploitable/balanced is this homebrew spell: Spell Permanency?

How should I connect my cat5 cable to connectors having an orange-green line?

Is it "common practice in Fourier transform spectroscopy to multiply the measured interferogram by an apodizing function"? If so, why?

Compensation for working overtime on Saturdays

Man transported from Alternate World into ours by a Neutrino Detector

Avoiding the "not like other girls" trope?

Incomplete cube

Finitely generated matrix groups whose eigenvalues are all algebraic

How to implement Comparable so it is consistent with identity-equality

Calculating discount not working

Is there a rule of thumb for determining the amount one should accept for a settlement offer?

pgfplots: How to draw a tangent graph below two others?

Small nick on power cord from an electric alarm clock, and copper wiring exposed but intact

What did the word "leisure" mean in late 18th Century usage?

Free fall ellipse or parabola?

Is it correct to say moon starry nights?

Read/write a pipe-delimited file line by line with some simple text manipulation

How to compactly explain secondary and tertiary characters without resorting to stereotypes?

Strange use of "whether ... than ..." in official text

How to show a landlord what we have in savings?

Why did the Drakh emissary look so blurred in S04:E11 "Lines of Communication"?

How to get a custom order attribute value in cart api /V1/carts/mine?

0

I have created a custom Order attribute "delivery_date" in my sales_order table.

Now I want to get this attribute value in my cart API so that I get the delivery_date along with the quote_id in response.

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();
 

Thanks in advance.

magento2 magento-2.1 magento2.2 magento2.3

share|improve this question

edited 2 days ago

Ronak Rathod

869112

asked 2 days ago

Meetali GuptaMeetali Gupta

112

New contributor

Meetali Gupta is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  where is your code with the response of quote items
  
  – magefms
  2 days ago
  

  
  
  
  

add a comment | 

0

I have created a custom Order attribute "delivery_date" in my sales_order table.

Now I want to get this attribute value in my cart API so that I get the delivery_date along with the quote_id in response.

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();
 

Thanks in advance.

magento2 magento-2.1 magento2.2 magento2.3

share|improve this question

edited 2 days ago

Ronak Rathod

869112

asked 2 days ago

Meetali GuptaMeetali Gupta

112

New contributor

Meetali Gupta is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  where is your code with the response of quote items
  
  – magefms
  2 days ago
  

  
  
  
  

add a comment | 

I have created a custom Order attribute "delivery_date" in my sales_order table.

Now I want to get this attribute value in my cart API so that I get the delivery_date along with the quote_id in response.

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();
 

Thanks in advance.

magento2 magento-2.1 magento2.2 magento2.3

share|improve this question

edited 2 days ago

Ronak Rathod

869112

asked 2 days ago

Meetali GuptaMeetali Gupta

112

New contributor

Meetali Gupta is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

<?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();
 

share|improve this question

edited 2 days ago

Ronak Rathod

869112

asked 2 days ago

Meetali GuptaMeetali Gupta

112

New contributor

Meetali Gupta is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

edited 2 days ago

Ronak Rathod

869112

asked 2 days ago

Meetali GuptaMeetali Gupta

112

New contributor

Meetali Gupta is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

edited 2 days ago

Ronak Rathod

869112

edited 2 days ago

Ronak Rathod

869112

asked 2 days ago

Meetali GuptaMeetali Gupta

112

New contributor

Meetali Gupta is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 2 days ago

Meetali GuptaMeetali Gupta

112