public static function GetSubordinateSql($sAliasPrefix = "", $arParams = array()) { if (is_array($arParams) && isset($arParams['USER_ID'])) { $arDepsIDs = CTasks::GetSubordinateDeps($arParams['USER_ID']); } else { $arDepsIDs = CTasks::GetSubordinateDeps(); } if (sizeof($arDepsIDs)) { $rsDepartmentField = CUserTypeEntity::GetList(array(), array("ENTITY_ID" => "USER", "FIELD_NAME" => "UF_DEPARTMENT")); if ($arDepartmentField = $rsDepartmentField->Fetch()) { return CTasks::GetDeparmentSql($arDepsIDs, $sAliasPrefix); } } return false; }