When we work in magento with out of box customization then we might need to add feature for search order by phone in admin grid or somewhere else.
In this blog we are going to search order by phone number/telephone/mobile number in magento2.
As technially, we need to search phone in order’s address table and need to get order ids and use that order ids to get order information.
Here is code for search order by phone
<?php
declare(strict_types=1); //We recommend to use always strict_types = 1 for quality code
namespace MageDad\Module\Model;
use Magento\Sales\Model\ResourceModel\Order\CollectionFactory as OrderCollectionFactory;
use Magento\Sales\Model\ResourceModel\Order\Address\CollectionFactory as AddressCollectionFactory;
class OrderSearch
{
public function __construct(
private OrderCollectionFactory $orderCollectionFactory,
private AddressCollectionFactory $addressCollectionFactory
) { }
/**
* {@inheritdoc}
*/
public function getOrderByPhone($phone)
{
$addressCollection = $this->addressCollectionFactory->create();
$addressCollection->addFieldToFilter('telephone', ['eq' => $phone]);
$orderIds = $addressCollection->getColumnValues('parent_id');
if (count($orderIds) > 0) {
$collection = $this->orderCollectionFactory->create();
$collection->addFieldToFilter('entity_id', ['in' => $orderIds]);
return $collection->getItems();
}
return [];
}
}
If you want to create API for search order by phone then you can refere GitHub module.
I hope this blog is useful to search order by phone in magento2. In case, I missed anything or need to add some more information, Don’t heisted to leave a comment in this blog, I’ll get back with some positive approach.
Keep loving ❤️ Keep inspiring 🤩 Keep liking 👍 No sharing 😂
7 Comments
Keep up the fantastic work! Kalorifer Sobası odun, kömür, pelet gibi yakıtlarla çalışan ve ısıtma işlevi gören bir soba türüdür. Kalorifer Sobası içindeki yakıtın yanmasıyla oluşan ısıyı doğrudan çevresine yayar ve aynı zamanda suyun ısınmasını sağlar.
Keep up the fantastic work! Kalorifer Sobası odun, kömür, pelet gibi yakıtlarla çalışan ve ısıtma işlevi gören bir soba türüdür. Kalorifer Sobası içindeki yakıtın yanmasıyla oluşan ısıyı doğrudan çevresine yayar ve aynı zamanda suyun ısınmasını sağlar.
Please let me know if you’re looking for a article writer for your site. You have some really great posts and I believe I would be a good asset. If you ever want to take some of the load off, I’d love to write some articles for your blog in exchange for a link back to mine. Please blast me an e-mail if interested. Regards!
ifyıl pelet sobası ayarları
If you desire to take a great deal from this piece of writing then you have to apply such techniques to your won webpage.
Definitely, what a fantastic site and illuminating posts, I will bookmark your website.Best Regards!
I was suggested this blog by my cousin. I am not sure whether this post is written by him as no one else know such detailed about my problem. You’re incredible! Thanks!
Choose BWER for trusted weighbridge systems in Iraq, offering customized solutions to optimize your industrial operations and ensure precise weight measurement every time.