Ttdfjt

I have created a custom module and trying to save data but not saved data into custom_table. I don't know why? I compared same code with my previous Modules Everything is same.

Here is my installSchema.php

 public function install(MagentoFrameworkSetupSchemaSetupInterface $setup, MagentoFrameworkSetupModuleContextInterface $context)
 
 $installer = $setup;
 $installer->startSetup();
 if (!$installer->tableExists('table_name')) 
 $table = $installer->getConnection()->newTable(
 $installer->getTable('table_name')
 )->addColumn(
 'row_id',
 MagentoFrameworkDBDdlTable::TYPE_INTEGER,
 null,
 [
 'primary' => true,
 'nullable' => false,
 'unsigned' => false,
 ],
 'Missing Order ID'
 )->addColumn(
 'entity_id',
 MagentoFrameworkDBDdlTable::TYPE_INTEGER,
 null,
 [
 'nullable' => false,
 'unsigned' => false,
 ],
 'Qoute ID'
 )->addColumn(
 'reserved_order_id',
 MagentoFrameworkDBDdlTable::TYPE_INTEGER,
 null,
 [
 'nullable' => false,
 'unsigned' => false,
 ],
 'Reserved Order ID'
 )->addColumn(
 'customer_email',
 MagentoFrameworkDBDdlTable::TYPE_TEXT,
 100,
 [
 'nullable' => false,
 ],
 'Costumer Email'
 )->addColumn(
 'created_at',
 MagentoFrameworkDBDdlTable::TYPE_DATE,
 null,
 [

 'nullable' => false,
 ],
 'Order Date'
 )->addColumn(
 'base_grand_total',
 MagentoFrameworkDBDdlTable::TYPE_DECIMAL,
 null,
 [
 'nullable' => false,
 ],
 'Grand Total'
 )->setComment('Missing Orders');
 $installer->getConnection()->createTable($table);
 


 $installer->endSetup();

here is my code to save data

public function execute(Observer $observer)
 
 $orderIds = $observer->getEvent()->getOrderIds();
 $order = $this->orderFactory->create()->load($orderIds[0]);
 $quote = $this->_quoteFactory->create()->load($order->getQuoteId());
 $order = null;
 if (empty($order)) 
 try 
 $rowData = $this->_missingOrdersFactory->create();
 $rowData->setEntityId($quote->getEntityId());
 $rowData->setReservedOrderId($quote->getReservedOrderId());
 $rowData->setCustomerEmail($quote->getCustomerEmail());
 $rowData->setCreatedAt($quote->getCreatedAt());
 $rowData->setBaseGrandTotal($quote->getBaseGrandTotal());
 $rowData->save();
 echo "<pre>";
 print_r($rowData->getData());
 exit;
 catch (Exception $e) 
 echo $e->getMessage();
 

 
 

print_r($rowData->getDdata) is returning me

Array
(
 [entity_id] => 200
 [reserved_order_id] => 000000168
 [customer_email] => waqarcui@gmail.com
 [created_at] => 2019-07-03 04:29:03
 [base_grand_total] => 105.0000
)

Thanks.

You're not setting the 'identity' => true in your installschema.php, that's why it won't auto-increment since you're not adding data to row_id that may be the reason your data is not saving.

Your primary key field should be like this.

 ->addColumn(
 'row_id',
 MagentoFrameworkDBDdlTable::TYPE_INTEGER,
 null,
 [
 'identity' => true,
 'nullable' => false,
 'primary' => true,
 'unsigned' => true,
 ],
 'Missing Order ID'
 )

Hope it helps.