Magento Asked by Sabareesh on December 13, 2020
SQL need to change AND condtion to OR in below code
public function getOrders()
{
$po_number = "%"."A"."%";
if (!($customerId = $this->_customerSession->getCustomerId())) {
return false;
}
if (!$this->orders) {
$this->orders = $this->getOrderCollectionFactory()->create($customerId)->addFieldToSelect(
'*'
)->addFieldToFilter(
'status',
['in' => $this->_orderConfig->getVisibleOnFrontStatuses()]
);
$this->orders->getSelect()
->joinLeft(
["sop" => "amt_sales_order_payment"],
'main_table.entity_id = sop.parent_id',
['po_number']
)
->where('sop.po_number LIKE ?',$po_number);
$this->orders->setOrder(
'ext_order_id',
'desc'
);
echo $this->orders->getSelect()->__toString();
}
return $this->orders;
}
I the po_number OR condtion need to apply how can i apply this.
Current Query
SELECT `main_table`.*, `sop`.`po_number` FROM `sales_order` AS `main_table` LEFT JOIN `sales_order_payment` AS `sop` ON main_table.entity_id = sop.parent_id WHERE (`main_table`.`customer_id` = '200') AND (`status` IN('canceled', 'closed', 'complete', 'fraud', 'holded', 'partially_shipped', 'payment_review', 'pending', 'processing', 'shipped')) AND (sop.po_number LIKE '%A%')
Expecting Query
SELECT `main_table`.*, `sop`.`po_number` FROM `sales_order` AS `main_table` LEFT JOIN `sales_order_payment` AS `sop` ON main_table.entity_id = sop.parent_id WHERE (`main_table`.`customer_id` = '200') AND (`status` IN('canceled', 'closed', 'complete', 'fraud', 'holded', 'partially_shipped', 'payment_review', 'pending', 'processing', 'shipped')) OR (sop.po_number LIKE '%A%')
try replacing ->where('sop.po_number LIKE ?',$po_number);
with ->orWhere('sop.po_number LIKE ?',$po_number);
Correct answer by Marius on December 13, 2020
1 Asked on January 16, 2021 by hweb87
1 Asked on January 16, 2021
0 Asked on January 16, 2021 by kamzata
1 Asked on January 15, 2021 by sushivam
0 Asked on January 15, 2021 by usama-sohail
1 Asked on January 14, 2021 by fja3omega
0 Asked on January 13, 2021
4 Asked on January 12, 2021 by ramses
3 Asked on January 10, 2021
1 Asked on January 10, 2021 by rorytec
0 Asked on January 9, 2021 by kishor-6ugani
1 Asked on January 9, 2021 by miguel-angel-espinosa-garca
bundle bundle product bundled product dynamic price magento2 4
0 Asked on January 8, 2021 by gxrobb
1 Asked on January 8, 2021 by chad-c-davis
2 Asked on January 8, 2021 by kvin-vuillemin
1 Asked on January 6, 2021 by hitesh-balpande
1 Asked on January 6, 2021 by ramesh-kr
2 Asked on January 5, 2021 by vivek-tiwari
0 Asked on January 4, 2021 by hamendra-sunthwal
0 Asked on January 3, 2021
Get help from others!
Recent Questions
Recent Answers
© 2023 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP