将相关数据计数添加到joomla MVC列表视图中的每个项目 [英] Add a count of related data to each item in a joomla MVC list view

问题描述

我有一个自定义的joomla MVC组件. 该组件有一个项目表， 以及用于交付每个项目的出价表.一个项目可以有多个出价.

I have a custom joomla MVC component. The component has a table of items, and a table of bids to deliver each item. An item can have multiple bids.

我需要在foreach的每一行内的LIST视图上显示COUNT个出价.

i need to show a COUNT of the bids on the items LIST view within each row of the foreach.

实现此目标的最佳方法是什么?我曾尝试将以下内容添加到项目模型中，但为如何为每个项目行定义$ id而感到困惑.

What is the BEST way of achieving this? I have tried adding the following to the items model but I am stumped at how to define $id for each item row.

public function getBidsByItemId() { 
    $db = JFactory::getDbo();
    $query = $db->getQuery(true);
    $query->select('COUNT(*)');
    $query->from($db->quoteName('#__table_bids'));
    $query->where($db->quoteName('item_id')." = ".$id);

    // Reset the query using our newly populated query object.
    $db->setQuery($query);
    $count = $db->loadResult();

}

在这里您可以看到我添加了它的完整组件/模型/items.php: http://ideone.com /yPJHRk

Here you can see the full component/models/items.php to which I added it: http://ideone.com/yPJHRk

感谢MVC专家的帮助.

Grateful for help from the MVC experts out there.

推荐答案

您应该明确地加入，但据我了解，您想要的是出价计数?在这种情况下，您应该进行分组查询，类似于ilias所说的，但是:

you should definently make a join, but from what I understand what you want is the bid-count? In that case you should make a group-by query, similar to what ilias is saying, but:

$query->select('count(itemBids.bids) AS bidsNum');
$query->join('LEFT', '#__entrusters_bids AS itemBids ON itemBids.item_id = a.id');
$query->group('a.id'); 

还要注意联接中on语句中的引用更改，

also notice to the reference change in the on-statement in the join,

向乔纳斯致敬

这篇关于将相关数据计数添加到joomla MVC列表视图中的每个项目的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！