Magento 2 : How to get order collection group by customer?
To get order collection by customer wise i.e.., customer A and customer B have placed order and it should retrieve by customer wise per collection?
public function getOrdersByCustomer() {
$collect = $this->_orderCollectionFactory->create()->addFieldToSelect('*');
$collection = $collect->getSelect()->group('customer_id');
return $collection;
}
The above returns null.Thanks in advance
magento2 customer sales-order customer-group order-collection
add a comment |
To get order collection by customer wise i.e.., customer A and customer B have placed order and it should retrieve by customer wise per collection?
public function getOrdersByCustomer() {
$collect = $this->_orderCollectionFactory->create()->addFieldToSelect('*');
$collection = $collect->getSelect()->group('customer_id');
return $collection;
}
The above returns null.Thanks in advance
magento2 customer sales-order customer-group order-collection
1
You want to get customer's order data?
– Rohan Hapani
yesterday
No, I want to fetch the order collection group by customer_id. Hope you understand the question?
– G Prathap
yesterday
1
Please share full code .Seems code is right
– Amit Bera♦
yesterday
That's it from block and retrieving on phtml $_ordersbycustomer = $block->getOrdersByCustomer(); print_r($_ordersbycustomer->getData()); exit();
– G Prathap
yesterday
add a comment |
To get order collection by customer wise i.e.., customer A and customer B have placed order and it should retrieve by customer wise per collection?
public function getOrdersByCustomer() {
$collect = $this->_orderCollectionFactory->create()->addFieldToSelect('*');
$collection = $collect->getSelect()->group('customer_id');
return $collection;
}
The above returns null.Thanks in advance
magento2 customer sales-order customer-group order-collection
To get order collection by customer wise i.e.., customer A and customer B have placed order and it should retrieve by customer wise per collection?
public function getOrdersByCustomer() {
$collect = $this->_orderCollectionFactory->create()->addFieldToSelect('*');
$collection = $collect->getSelect()->group('customer_id');
return $collection;
}
The above returns null.Thanks in advance
magento2 customer sales-order customer-group order-collection
magento2 customer sales-order customer-group order-collection
edited yesterday
asked yesterday
G Prathap
829
829
1
You want to get customer's order data?
– Rohan Hapani
yesterday
No, I want to fetch the order collection group by customer_id. Hope you understand the question?
– G Prathap
yesterday
1
Please share full code .Seems code is right
– Amit Bera♦
yesterday
That's it from block and retrieving on phtml $_ordersbycustomer = $block->getOrdersByCustomer(); print_r($_ordersbycustomer->getData()); exit();
– G Prathap
yesterday
add a comment |
1
You want to get customer's order data?
– Rohan Hapani
yesterday
No, I want to fetch the order collection group by customer_id. Hope you understand the question?
– G Prathap
yesterday
1
Please share full code .Seems code is right
– Amit Bera♦
yesterday
That's it from block and retrieving on phtml $_ordersbycustomer = $block->getOrdersByCustomer(); print_r($_ordersbycustomer->getData()); exit();
– G Prathap
yesterday
1
1
You want to get customer's order data?
– Rohan Hapani
yesterday
You want to get customer's order data?
– Rohan Hapani
yesterday
No, I want to fetch the order collection group by customer_id. Hope you understand the question?
– G Prathap
yesterday
No, I want to fetch the order collection group by customer_id. Hope you understand the question?
– G Prathap
yesterday
1
1
Please share full code .Seems code is right
– Amit Bera♦
yesterday
Please share full code .Seems code is right
– Amit Bera♦
yesterday
That's it from block and retrieving on phtml $_ordersbycustomer = $block->getOrdersByCustomer(); print_r($_ordersbycustomer->getData()); exit();
– G Prathap
yesterday
That's it from block and retrieving on phtml $_ordersbycustomer = $block->getOrdersByCustomer(); print_r($_ordersbycustomer->getData()); exit();
– G Prathap
yesterday
add a comment |
1 Answer
1
active
oldest
votes
Try using these cods:
public function getOrders()
{
if (!($customerId = $this->_customerSession->getCustomerId())) {
return false;
}
if (!$this->orders) {
$this->orders = $this->getOrderCollectionFactory()->create($customerId)->addFieldToSelect(
'*'
)->addFieldToFilter(
'status',
['in' => $this->_orderConfig->getVisibleOnFrontStatuses()]
)->setOrder(
'created_at',
'desc'
);
}
return $this->orders;
}
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "479"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f256736%2fmagento-2-how-to-get-order-collection-group-by-customer%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Try using these cods:
public function getOrders()
{
if (!($customerId = $this->_customerSession->getCustomerId())) {
return false;
}
if (!$this->orders) {
$this->orders = $this->getOrderCollectionFactory()->create($customerId)->addFieldToSelect(
'*'
)->addFieldToFilter(
'status',
['in' => $this->_orderConfig->getVisibleOnFrontStatuses()]
)->setOrder(
'created_at',
'desc'
);
}
return $this->orders;
}
add a comment |
Try using these cods:
public function getOrders()
{
if (!($customerId = $this->_customerSession->getCustomerId())) {
return false;
}
if (!$this->orders) {
$this->orders = $this->getOrderCollectionFactory()->create($customerId)->addFieldToSelect(
'*'
)->addFieldToFilter(
'status',
['in' => $this->_orderConfig->getVisibleOnFrontStatuses()]
)->setOrder(
'created_at',
'desc'
);
}
return $this->orders;
}
add a comment |
Try using these cods:
public function getOrders()
{
if (!($customerId = $this->_customerSession->getCustomerId())) {
return false;
}
if (!$this->orders) {
$this->orders = $this->getOrderCollectionFactory()->create($customerId)->addFieldToSelect(
'*'
)->addFieldToFilter(
'status',
['in' => $this->_orderConfig->getVisibleOnFrontStatuses()]
)->setOrder(
'created_at',
'desc'
);
}
return $this->orders;
}
Try using these cods:
public function getOrders()
{
if (!($customerId = $this->_customerSession->getCustomerId())) {
return false;
}
if (!$this->orders) {
$this->orders = $this->getOrderCollectionFactory()->create($customerId)->addFieldToSelect(
'*'
)->addFieldToFilter(
'status',
['in' => $this->_orderConfig->getVisibleOnFrontStatuses()]
)->setOrder(
'created_at',
'desc'
);
}
return $this->orders;
}
answered 18 hours ago
Md. Ehsanul Haque Kanan
154
154
add a comment |
add a comment |
Thanks for contributing an answer to Magento Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f256736%2fmagento-2-how-to-get-order-collection-group-by-customer%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
You want to get customer's order data?
– Rohan Hapani
yesterday
No, I want to fetch the order collection group by customer_id. Hope you understand the question?
– G Prathap
yesterday
1
Please share full code .Seems code is right
– Amit Bera♦
yesterday
That's it from block and retrieving on phtml $_ordersbycustomer = $block->getOrdersByCustomer(); print_r($_ordersbycustomer->getData()); exit();
– G Prathap
yesterday