Hjdcti

What is GPS' 19 year rollover and does it present a cybersecurity issue?

How would photo IDs work for shapeshifters?

Creating a loop after a break using Markov Chain in Tikz

New order #4: World

What is it called when one voice type sings a 'solo'?

Where else does the Shulchan Aruch quote an authority by name?

aging parents with no investments

Why doesn't a const reference extend the life of a temporary object passed via a function?

Can I legally use front facing blue light in the UK?

What to wear for invited talk in Canada

What do you call something that goes against the spirit of the law, but is legal when interpreting the law to the letter?

Is there a name of the flying bionic bird?

Was there ever an axiom rendered a theorem?

LWC and complex parameters

Is ipsum/ipsa/ipse a third person pronoun, or can it serve other functions?

Are objects structures and/or vice versa?

How could a lack of term limits lead to a "dictatorship?"

How to move the player while also allowing forces to affect it

How to answer pointed "are you quitting" questioning when I don't want them to suspect

How can I plot a Farey diagram?

Find the number of surjections from A to B.

What is the command to reset a PC without deleting any files

Is this food a bread or a loaf?

Shall I use personal or official e-mail account when registering to external websites for work purpose?

Magento 2 Product Listing Issue:- You cannot define a correlation name 'mp' more than once

Magento 2.2 - custom product sorting issueJoin Query in magento 2Cannot use MagentoPaymentGatewayConfigInterface as ConfigInterface because the name is already in use in module-paymentModelMethodLogger.phpI have an Issue with “Use Product Image for Swatch if Possible” in magento 2.2Need to get name of product from previous page Magento 2.2Magento 2.3 how to add cms static block in footer on last page of product listingCategory (product Listing) page css update with Magento 2 custom themeHow can get custom table columns on product listing page using product_id of the custom table

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I'm trying to join custom table on product listing page,here is the Class and method:-

Class:- vendor/magento/module-catalog/Block/Product/ProductList/Toolbar.php

Method:- setCollection()

Here is the code of this method:-

 public function setCollection($collection)
 
 $this->_collection = $collection;

 //My Custom Code

 $mpJoinConditions = 'mp.mageproduct_id = e.entity_id';

 $this->_collection->getSelect()->join(
 ['mp' => $this->_collection->getTable('marketplace_product')],
 $mpJoinConditions,
 []
 )->columns("mp.seller_id");

 // End of My Custom Code

 $this->_collection->setCurPage($this->getCurrentPage());

 // we need to set pagination only if passed value integer and more that 0
 $limit = (int)$this->getLimit();
 if ($limit) 
 $this->_collection->setPageSize($limit);
 
 if ($this->getCurrentOrder()) 
 $this->_collection->setOrder($this->getCurrentOrder(), $this->getCurrentDirection());
 
 return $this;
 

But getting following issue:-

"You cannot define a correlation name 'mp' more than once"

Please help me to resolve the issue!!!

magento2.2.4 join-table product-listing

share|improve this question

asked 1 hour ago

wakar Ahamadwakar Ahamad

329113

add a comment | 

0

I'm trying to join custom table on product listing page,here is the Class and method:-

Class:- vendor/magento/module-catalog/Block/Product/ProductList/Toolbar.php

Method:- setCollection()

Here is the code of this method:-

 public function setCollection($collection)
 
 $this->_collection = $collection;

 //My Custom Code

 $mpJoinConditions = 'mp.mageproduct_id = e.entity_id';

 $this->_collection->getSelect()->join(
 ['mp' => $this->_collection->getTable('marketplace_product')],
 $mpJoinConditions,
 []
 )->columns("mp.seller_id");

 // End of My Custom Code

 $this->_collection->setCurPage($this->getCurrentPage());

 // we need to set pagination only if passed value integer and more that 0
 $limit = (int)$this->getLimit();
 if ($limit) 
 $this->_collection->setPageSize($limit);
 
 if ($this->getCurrentOrder()) 
 $this->_collection->setOrder($this->getCurrentOrder(), $this->getCurrentDirection());
 
 return $this;
 

But getting following issue:-

"You cannot define a correlation name 'mp' more than once"

Please help me to resolve the issue!!!

magento2.2.4 join-table product-listing

share|improve this question

asked 1 hour ago

wakar Ahamadwakar Ahamad

329113

add a comment | 

I'm trying to join custom table on product listing page,here is the Class and method:-

Class:- vendor/magento/module-catalog/Block/Product/ProductList/Toolbar.php

Method:- setCollection()

Here is the code of this method:-

 public function setCollection($collection)
 
 $this->_collection = $collection;

 //My Custom Code

 $mpJoinConditions = 'mp.mageproduct_id = e.entity_id';

 $this->_collection->getSelect()->join(
 ['mp' => $this->_collection->getTable('marketplace_product')],
 $mpJoinConditions,
 []
 )->columns("mp.seller_id");

 // End of My Custom Code

 $this->_collection->setCurPage($this->getCurrentPage());

 // we need to set pagination only if passed value integer and more that 0
 $limit = (int)$this->getLimit();
 if ($limit) 
 $this->_collection->setPageSize($limit);
 
 if ($this->getCurrentOrder()) 
 $this->_collection->setOrder($this->getCurrentOrder(), $this->getCurrentDirection());
 
 return $this;
 

But getting following issue:-

"You cannot define a correlation name 'mp' more than once"

Please help me to resolve the issue!!!

magento2.2.4 join-table product-listing

share|improve this question

asked 1 hour ago

wakar Ahamadwakar Ahamad

329113

 public function setCollection($collection)
 
 $this->_collection = $collection;

 //My Custom Code

 $mpJoinConditions = 'mp.mageproduct_id = e.entity_id';

 $this->_collection->getSelect()->join(
 ['mp' => $this->_collection->getTable('marketplace_product')],
 $mpJoinConditions,
 []
 )->columns("mp.seller_id");

 // End of My Custom Code

 $this->_collection->setCurPage($this->getCurrentPage());

 // we need to set pagination only if passed value integer and more that 0
 $limit = (int)$this->getLimit();
 if ($limit) 
 $this->_collection->setPageSize($limit);
 
 if ($this->getCurrentOrder()) 
 $this->_collection->setOrder($this->getCurrentOrder(), $this->getCurrentDirection());
 
 return $this;
 

share|improve this question

asked 1 hour ago

wakar Ahamadwakar Ahamad

329113

share|improve this question

asked 1 hour ago

wakar Ahamadwakar Ahamad

329113

asked 1 hour ago

wakar Ahamadwakar Ahamad

329113

asked 1 hour ago

wakar Ahamadwakar Ahamad

329113