向 joomla MVC 列表视图中的每个项目添加相关数据的计数

2022-01-06 00:00:00 php mysql joomla

我有一个自定义的 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 的每一行内的项目列表视图中显示 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');

还要注意join中on语句的引用变化，

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

问候乔纳斯

相关文章