/**
* KSSystem::getTableByIds()
*
* @param mixed $ids
* @param mixed $table
* @param mixed $fields
* @param bool $published
* @param bool $implode_keys
* @param bool $single
* @return
*/
public static function getTableByIds(array $ids, $table, array $fields, $published = true, $implode_keys = false, $single = false)
{
if (!empty($ids) && is_array($ids)) {
if (empty(self::$ext_name)) {
self::setGlobalVar('ext_name');
}
$db = JFactory::getDBO();
$query = $db->getQuery(true);
$query->select($fields)->from($db->qn('#__' . self::$ext_name . '_' . $table, 't'));
if ($implode_keys) {
$query->where('(' . $db->qn('t.id') . ' IN (' . KSSystem::key_implode(', ', $ids) . '))');
} else {
$query->where('(' . $db->qn('t.id') . ' IN (' . implode(', ', $db->q($ids)) . '))');
}
if ($published) {
$query->where('t.published=1');
}
$db->setQuery($query);
// exit($query->dump());
if ($single) {
$object = $db->loadObject();
} else {
$object = $db->loadObjectList();
}
if (!empty($object)) {
return $object;
}
}
return new stdClass();
}
