- Модуль: bizproc
- Путь к файлу: ~/bitrix/modules/bizproc/classes/general/taskservice.php
- Класс: CBPTaskService
- Вызов: CBPTaskService::getTaskUsers
static function getTaskUsers($taskId)
{
global $DB;
$taskId = (array)$taskId;
$taskId = array_map('intval', $taskId);
$taskId = array_filter($taskId);
if (sizeof($taskId) < 1)
throw new Exception("taskId");
$where = '';
foreach ($taskId as $id)
{
if ($where)
$where .= ' OR ';
$where .= ' TASK_ID = '.$id;
}
$users = array();
$iterator = $DB->Query('SELECT TU.*, U.PERSONAL_PHOTO, U.NAME, U.LAST_NAME, U.SECOND_NAME, U.LOGIN, U.TITLE'
.' FROM b_bp_task_user TU'
.' INNER JOIN b_user U ON (U.ID = TU.USER_ID)'
.' WHERE '.$where
.' ORDER BY TU.DATE_UPDATE DESC'
);
while ($user = $iterator->fetch())
{
$users[$user['TASK_ID']][] = $user;
}
return $users;
}