Dfrnhjy

I see my dog run

Crop image to path created in TikZ?

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

How is it possible for user's password to be changed after storage was encrypted? (on OS X, Android)

Information to fellow intern about hiring?

What does "enim et" mean?

Is a vector space a subspace of itself?

Does bootstrapped regression allow for inference?

Is this food a bread or a loaf?

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

Why do we use polarized capacitors?

Why is my log file so massive? 22gb. I am running log backups

How to manage monthly salary

Is there a name of the flying bionic bird?

If a centaur druid Wild Shapes into a Giant Elk, do their Charge features stack?

Why did the Germans forbid the possession of pet pigeons in Rostov-on-Don in 1941?

Calculate Levenshtein distance between two strings in Python

Landlord wants to switch my lease to a "Land contract" to "get back at the city"

Are cabin dividers used to "hide" the flex of the airplane?

Filling an area between two curves

Does it makes sense to buy a new cycle to learn riding?

Could a US political party gain complete control over the government by removing checks & balances?

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

What to wear for invited talk in Canada

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