public function getItem($pk = null)
{
if ($item = parent::getItem($pk)) {
if (!isset($item->rating_fields)) {
$group_id = empty($item->rating_group_id) ? $this->getState('review.rating_group_id') : $item->rating_group_id;
$query = $this->_db->getQuery(true);
$query->select('f.*, i.rating');
$query->from('#__djrevs_rating_fields as f');
$query->join('LEFT', '#__djrevs_reviews_items as i ON i.field_id = f.id AND i.review_id = ' . (int) $item->id);
$query->where('f.group_id=' . (int) $group_id . ' AND f.published = 1');
$query->order('f.ordering ASC');
$this->_db->setQuery($query);
$item->rating_fields = $this->_db->loadObjectList('id');
}
return $item;
}
return false;
}
