本文介绍了将相关数据计数添加到joomla MVC列表视图中的每个项目的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我有一个自定义的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列表视图中的每个项目的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-14 13:44