static function getItemsList(&$params, &$_item_data = null, $isform = 0, $reverse_field = 0, &$parentfield, &$parentitem, &$return_item_list = false) { // Execute query to get item list data $db = JFactory::getDBO(); $query = FlexicontentFields::createItemsListSQL($params, $_item_data, $isform, $reverse_field, $parentfield, $parentitem); $db->setQuery($query); $item_list = $db->loadObjectList('id'); if ($db->getErrorNum()) { JFactory::getApplication()->enqueueMessage(__FUNCTION__ . '(): SQL QUERY ERROR:<br/>' . nl2br($db->getErrorMsg()), 'error'); } // Item list must be returned too ... if ($return_item_list) { $return_item_list =& $item_list; } // No published related items or SQL query failed, return if (!$item_list) { return ''; } if ($_item_data) { foreach ($item_list as $_item) { // if it exists ... add prefered catid to items list data $_item->rel_catid = @$_item_data[$_item->id]->catid; } } return FlexicontentFields::createItemsListHTML($params, $item_list, $isform, $parentfield, $parentitem, $_item_data); }
static function getItemsList(&$params, &$_item_data = null, $isform = 0, $reverse_field = 0, &$parentfield, &$parentitem, &$return_item_list = false, $states = array(1, -5, 2)) { // Execute query to get item list data $db = JFactory::getDBO(); $query = FlexicontentFields::createItemsListSQL($params, $_item_data, $isform, $reverse_field, $parentfield, $parentitem, $states); $db->setQuery($query); try { $item_list = $db->loadObjectList('id'); } catch (Exception $e) { JFactory::getApplication()->enqueueMessage(__FUNCTION__ . '(): SQL QUERY ERROR:<br/>' . nl2br(JDEBUG ? $e->getMessage() : 'Joomla Debug is OFF'), 'warning'); } // Return item ids list instead of rendering their HTML if ($return_item_list) { $return_item_list =& $item_list; } // No published related items or SQL query failed, return if (!$item_list) { return ''; } if ($_item_data) { foreach ($item_list as $_item) { // if it exists ... add prefered catid to items list data $_item->rel_catid = @$_item_data[$_item->id]->catid; } } return FlexicontentFields::createItemsListHTML($params, $item_list, $isform, $parentfield, $parentitem, $_item_data); }