• Модуль: main
  • Путь к файлу: ~/bitrix/modules/main/classes/general/group.php
  • Класс: CAllGroup
  • Вызов: CAllGroup::GetGroupUserEx
static function GetGroupUserEx($ID)
{
	global $DB;
	$ID = intval($ID);

	if ($ID == 2)
	{
		$strSql = "SELECT U.ID as USER_ID, NULL as DATE_ACTIVE_FROM, NULL as DATE_ACTIVE_TO FROM b_user U ";
	}
	else
	{
		$strSql =
			"SELECT UG.USER_ID, ".
			"	".$DB->DateToCharFunction("UG.DATE_ACTIVE_FROM", "FULL")." as DATE_ACTIVE_FROM, ".
			"	".$DB->DateToCharFunction("UG.DATE_ACTIVE_TO", "FULL")." as DATE_ACTIVE_TO ".
			"FROM b_user_group UG ".
			"WHERE UG.GROUP_ID = ".$ID." ".
			"	AND ((UG.DATE_ACTIVE_FROM IS NULL) OR (UG.DATE_ACTIVE_FROM <= ".$DB->CurrentTimeFunction().")) ".
			"	AND ((UG.DATE_ACTIVE_TO IS NULL) OR (UG.DATE_ACTIVE_TO >= ".$DB->CurrentTimeFunction().")) ";
	}
	$res = $DB->Query($strSql, false, "FILE: ".__FILE__."
LINE: ".__LINE__); return $res; }