How to count only enabled product from product_link collection

Question

I've found in a template file, a code like the one below:

$collection = Mage::getModel('catalog/product_link')
            ->getCollection()
            ->addFieldToFilter('product_id', $_product->getId());

It's used to display additional tabs in product view if($collection->count()), the problem is that it doesn't care if products in collection are enabled or disabled.

What would be the easiest way to count, using "the same code", only the enabled products?

Answer 1

I only see two solutions here, but none of them are ideal in terms of performance I think.

Solution 1 : dirty loop and count

$count = 0;
foreach ($collection as $product) {
     if ($product->getStatus() == Mage_Catalog_Model_Product_Status::STATUS_ENABLED) {
         $count++;
     }
}

Solution 2: use another collection

$clone = clone $collection;
$clone->addFieldToFilter('status', Mage_Catalog_Model_Product_Status::STATUS_ENABLED);
$count = $clone->getSize();

Answer 2

Well i am not sure if thats possible at all.

Use this to get enabled products only

    $collection->getSelect()->join(
    'catalog_product_entity_int',
    // note this join clause! Here main table is catalog_product_link
    'main_table.product_id = catalog_product_entity_int.entity_id'
)
->where("attribute_id = 80 and catalog_product_entity_int.value= 1");

Or go through the loop find all enabled products. Store in an array. Get a count. Or use increment operator like Raphael says.