public function getCountForRole($RoleID = '')
{
if (!is_array($RoleID)) {
$RoleID = [$RoleID];
}
return $this->SQL->select('a.ActivityID', 'count', 'ActivityCount')->from('Activity a')->join('ActivityType t', 'a.ActivityTypeID = t.ActivityTypeID')->join('UserRole ur', 'a.ActivityUserID = ur.UserID')->whereIn('ur.RoleID', $RoleID)->where('t.Public', '1')->get()->firstRow()->ActivityCount;
}