/**
* Method to return the JAccessRules object for an asset. The returned object can optionally hold
* only the rules explicitly set for the asset or the summation of all inherited rules from
* parent assets and explicit rules.
*
* @param mixed $asset Integer asset id or the name of the asset as a string.
* @param boolean $recursive True to return the rules object with inherited rules.
* @return object Rules object for the asset.
*/
public static function getAssetRules($asset, $recursive = false)
{
// Get the database connection object.
/*$db = App::get('db');
// Build the database query to get the rules for the asset.
$query = $db->getQuery(true);
$query->select($recursive ? 'b.rules' : 'a.rules');
$query->from('#__assets AS a');
//sqlsrv change
$query->group($recursive ? 'b.id, b.rules, b.lft' : 'a.id, a.rules, a.lft');
// If the asset identifier is numeric assume it is a primary key, else lookup by name.
if (is_numeric($asset))
{
$query->where('(a.id = ' . (int) $asset . ')');
}
else
{
$query->where('(a.name = ' . $db->quote($asset) . ')');
}
// If we want the rules cascading up to the global asset node we need a self-join.
if ($recursive)
{
$query->leftJoin('#__assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt');
$query->order('b.lft');
}
// Execute the query and load the rules from the result.
$db->setQuery($query);
$result = $db->loadColumn();*/
// Build the database query to get the rules for the asset.
$query = Asset::all()->select($recursive ? 'b.rules' : 'a.rules');
$query->from($query->getTableName(), 'a');
// If the asset identifier is numeric assume it is a primary key, else lookup by name.
if (is_numeric($asset)) {
$query->whereEquals('a.id', (int) $asset);
} else {
$query->whereEquals('a.name', $asset);
}
// If we want the rules cascading up to the global asset node we need a self-join.
if ($recursive) {
$query->joinRaw($query->getTableName() . ' AS b', 'b.lft <= a.lft AND b.rgt >= a.rgt', 'left');
$query->order('b.lft', 'asc');
}
$query->group($recursive ? 'b.id, b.rules, b.lft' : 'a.id, a.rules, a.lft');
$result = $query->rows();
// Get the root even if the asset is not found and in recursive mode
if (empty($result)) {
$result = Asset::oneOrFail(Asset::getRootId());
$result = array($result);
}
// Instantiate and return the JAccessRules object for the asset rules.
$rules = new Rules();
$rules->mergeCollection($result);
return $rules;
}
