Kdjykuj

On product lisitng page i want to get one more parameter "latitude" for all product,how can i achieve?

Here is my code:-

public function setCollection($collection)

    {



        $this->_collection = $collection;



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



       $this->_collection->getSelect()->join(

                $this->_collection->getTable('marketplace_product'),

                $mpJoinConditions,

                

            )->columns("marketplace_product.seller_id")->where ("marketplace_product.store_id = '0'");



             echo "<pre>" ; print_r($this->_collection->getData()) ; exit;

}

Note:-As per my requirement,i don't need to create product custom attribute OR use joins.

I tried to use addData and setData() but didn't get success.

After print_r(),added custom "key=>value" must be there for each product.

Update:-

By doing following i'm able to do set Latitude seprately and getting the same on phtml file:-

  foreach($this->_collection as $key=>$prod_data){



     $prod_data->setData('latitude',$prod_data->getId());    



}

I've to sort(DESC) the product based on latitude value,but when i'm printing

        echo "<pre>" ; print_r($this->_collection->getData()) ; exit;

then not getting 'latitude' parameter $this->_collection->getData() here due to which i can't apply setOrder().on phtml file by using $product->getLatitude() it's showing so please help me to resolve this issue.

You can loop through the collection and set the data for each item like this:

foreach ($this->_collection as $item){

    $item->setData('latitude',1);

}

That should give you the required output.

Try this code & let me know:

public function setCollection($collection)

    {



        $this->_collection = $collection;



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



       $this->_collection->getSelect()->join(

                $this->_collection->getTable('marketplace_product'),

                $mpJoinConditions,

                

            )->columns("marketplace_product.seller_id")->where ("marketplace_product.store_id = '0'");



//add custom column

$this->_collection->getSelect()->columns(['latitude' => 1]);



             echo "<pre>" ; print_r($this->_collection->getData()) ; exit;

}