I want to take the increment id from sales order table and status should be complete.I have created one custom table called hydrogen_xml_generation.
Initially the xml generated status is 0. Once the xml is generated it will be 1. How to write the below query in Magento 2.
$sales_shipment = $connection->fetchAll("SELECT increment_id FROM sales_order WHERE status = 'complete' AND sales_order.increment_id NOT IN (SELECT increment_id FROM hydrogen_xml_generation WHERE xml_generated = '1')");
You can try something like this
First, inject the OrderRepository and the yourCustomModuleRepository to the constructor parameters:
public function __construct(
\Magento\Framework\App\Action\Context $context,
\Magento\Sales\Model\ResourceModel\Order\CollectionFactory $orderCollectionFactory,
\Namespace\Module\Model\ModuleFactory $moduleFactory
) {
$this->orderCollectionFactory = $orderCollectionFactory;
$this->moduleFactory = $moduleFactory;
parent::__construct(
$context
);
}
Then you can use it like this:
$xml_generated = $this->moduleFactory->create();
$columnValues = $xml_generated->getCollection()->addFieldToFilter('xml_generated',1)->getColumnValues('increment_id')
$orderResult = $this->orderCollectionFactory->create()->addAttributeToSelect('*');
$orders = $orderResult->addFieldToFilter('increment_id',array('nin' => $columnValues);