Example #1
0
 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;
 }