Group Product, Filter by price

Question

I have a situation where i have a slider and need to be able to filter the loaded products by min and max price. But the only products in use are group products that don't have direct prices.

Any suggestions on filtering Group Products by price.

Using the minPrice and maxPrice price generation functions.

Answer 1

My solutions was to run a loop over the category and do a price comparison

  public function priceIds($min, $max, $catid)
    {
        $products = Mage::getModel('catalog/category')->load($catid)
            ->getProductCollection();

        $ids = array();

        foreach ($products as $product) {
            if($product->getTypeId() == 'simple') {

                $price = $product->getPrice();
                echo $price;
                if($price >= $min  && $price <= $max)
                {
                    $ids[] = $price->getId();
                }
            }elseif($product->getTypeId() == 'grouped')
            {
                $associatedProducts = $product->getTypeInstance(true)->getAssociatedProducts($product);

                foreach($associatedProducts as $aproduct)
                {
                    //echo $aproduct->getPrice();
                    //echo $aproduct->getId();
                    if($aproduct->getPrice() >= $min  &&  $aproduct->getPrice() <= $max )
                    {

                        $ids[] = $product->getId();
                        break;
                    }
                }
            }
            //;



        }
        //var_dump($ids);
        return $ids;

    }

And in the filter check if the product entity_id is in the reutrned id array.

Answer 2

you can use bellow code to filter collection.

->addFieldToFilter('attr_price', 
     array(array('from'=>'0','to'=>'5000'), 
     array('from'=>'15000','to'=>'20000'))
 )

I hope this will help you.