Get associated products

Question

I created a new module to create a section in admin panel. This module section has a sub-section "Associated products" where I can add one or more products to each item in that module.

I am able to get the field values using functions like

• $combo->getName()
• $combo->getComments()

But I am not able to get the associated products to that item using

$combo->getAssociatedProducts()

What I tried is as follows:

<?php $comboCollection = Mage::getResourceSingleton('combo/combo_collection'); ?>
<?php 
    foreach ($comboCollection as $combo) {
        zend_debug::dump($combo->getAssociatedProducts($combo));  //giving error       
    }
?>

PS: here $combo is not a product, it is just an item in the created module.

Explanation:

---

---

Answer 1

Knowing that you created your module with the Ultimate Module Creator, here is how you can get the associated products of your entity.

$collection = $combo->getSelectedProductsCollection(); //get associated products
$collection->addAttributeToSelect('name'); //add 'name' attribute to collection - you can add others
$collection->addUrlRewrite(); //add the url rewrite to the collection
$collection->getSelect()->order('related.position'); //sort by the position you filled in the admin panel
Mage::getSingleton('catalog/product_status')->addVisibleFilterToCollection($collection); //get only enabled products
Mage::getSingleton('catalog/product_visibility')->addVisibleInCatalogFilterToCollection($collection); //get only visible products.