Как получить значения ID и записать построчно в .xls?

Question

[countZer0]

Всем привет !

Формирую массив вида:

Array
(
    [0] => Array
        (
            [NAME] => Иванов
            [LAST_NAME] => Иван
            [UF_SELECT_MON] => Array
                (
                    [0] => 1362
                )

            [UF_SELECT_TUE] => Array
                (
                    [0] => 1362
                    [1] => 1363
                )

            [UF_SELECT_WED] => Array
                (
                    [0] => 1362
                    [1] => 1363
                )

            [UF_SELECT_THU] => Array
                (
                    [0] => 1362
                    [1] => 1363
                )

            [UF_SELECT_FRI] => Array
                (
                    [0] => 1362
                )

            [UF_SELECT_SAT] => Array
                (
                    [0] => 1362
                )

            [UF_SELECT_SUN] => Array
                (
                    [0] => 1362
                    [1] => 1363
                )

            [UF_ADDRESS] => 1374
        )

    [1] => Array
...

В UF_SELECT_MON, UF_SELECT_THU... хранятся ID элементов в инфоблоке. Нужно получить названия элементов и как то записать в EXCEL файл, по типу:
Юзер | День недели | Блюдо
adm | Понедельник | <тут список элементов>

Буду рад любой помощи.

Спасибо !

Answer 1

[Алексей]

Формируется массив в CIBlockElement::GetList ???
Если да, то там можно делать выборку по связанным элементам. В массиве выборки:

PROPERTY_WHATEVER.NAME

Записывать можно в csv через fputcsv.

Comments

[countZer0]

Это выборка из
CUser::GetList
А можно пример с
PROPERTY_WHATEVER.NAME

[Алексей]

Тогда после выборки CUser::GetList, нужно пройтись по ней, записать все айди элементов из связанного ИБ и сделать по ним выборку.

$arElementsId = [1,123,3123,123123,666]; // массив айди из выборки CUser::GetList
$arSelectedElements = []; // пустой массив для загруженных связанных элементов
\Bitrix\Main\Loader::includeModule('iblock');
$rsElements = \CIBlockElement::GetList(['ID'=>'ASC'],['IBLOCK_ID' => 666, 'ID' => $arElementsId]);
while ($arElement = $rsElements->fetch()) {
    $arSelectedElements[$arElement['ID']] = $arElement['NAME'];
}

и после этого, можно формировать данные для записи.

[countZer0]

Алексей, Ну я примерно так и думал, вопрос с формированием есть. Допустим я получил названия элементов как мне записать их в нужный массив ? С нужным юзером. Что бы, например, было так:

0] => Array
        (
            [NAME] => Иванов
            [LAST_NAME] => Иван
            [UF_SELECT_MON] => Array
                (
                    [0] => Элемент 1
                    [1] => Элемент 2
                    ...
                )
...

[Алексей]

countZer0, можно как-то так

$arUsers = []; // выборка полученная через CUser::GetList
$arSelectedElements = []; // выборка полученная через CIBlockElement::GetList со связанными эл-ми
$arDaysFields = [
    'UF_SELECT_MON', 
    // ... остальные дни
    'UF_SELECT_SUN'
];
foreach ($arUsers as $topKey => $userArray) {
    // по всем юзерам
    foreach ($arDaysFields as $field) {
        // по всем дням
        foreach ($userArray[$field] as $innerKey => $element) {
            // заменяем в исходном массиве айди элементов на их NAME
            $userArray[$field][$innerKey] = $arSelectedElements[$element];
        }
    }
}

[countZer0]

Алексей, А подскажите еще, результирующий массив (userArray), выходит вот таким:

Array
(
    [ID] => 1
    [NAME] => Иванов
    [LAST_NAME] => Иван
    [UF_SELECT_MON] => Array
        (
            [0] => Багет 
            [1] => 1941
        )

    [UF_SELECT_TUE] => Array
        (
            [0] => 1941
            [1] => 1921
        )

    [UF_SELECT_WED] => Array
        (
            [0] => 1846
            [1] => 1842
        )

    [UF_SELECT_THU] => Array
        (
            [0] => 1968
            [1] => 1921
            [2] => 1963
        )

    [UF_SELECT_FRI] => Array
        (
            [0] => 1845
            [1] => 1931
            [2] => 1846
            [3] => 1856
            [4] => 1973
            [5] => 1886
        )

    [UF_SELECT_SAT] => Array
        (
            [0] => 1880
            [1] => 1845
            [2] => 1941
        )

    [UF_SELECT_SUN] => Array
        (
            [0] => 1845
            [1] => 1995
            [2] => 1971
            [3] => 1937
            [4] => 1855
            [5] => 1852
            [6] => 1871
            [7] => 1929
            [8] => 1974
            [9] => 1903
            [10] => 1870
            [11] => 1975
            [12] => 1966
        )

    [UF_ADDRESS] => 1373
)
Array
(
    [ID] => 1
    [NAME] => Иванов
    [LAST_NAME] => Иван
    [UF_SELECT_MON] => Array
        (
            [0] => Багет 
            [1] => Баранина тушеная с рагу из баклажанов и кабачков 260/15 
        )

    [UF_SELECT_TUE] => Array
        (
            [0] => 1941
            [1] => 1921
        )

    [UF_SELECT_WED] => Array
        (
            [0] => 1846
            [1] => 1842
        )

    [UF_SELECT_THU] => Array
        (
            [0] => 1968
            [1] => 1921
            [2] => 1963
        )

    [UF_SELECT_FRI] => Array
        (
            [0] => 1845
            [1] => 1931
            [2] => 1846
            [3] => 1856
            [4] => 1973
            [5] => 1886
        )

    [UF_SELECT_SAT] => Array
        (
            [0] => 1880
            [1] => 1845
            [2] => 1941
        )

    [UF_SELECT_SUN] => Array
        (
            [0] => 1845
            [1] => 1995
            [2] => 1971
            [3] => 1937
            [4] => 1855
            [5] => 1852
            [6] => 1871
            [7] => 1929
            [8] => 1974
            [9] => 1903
            [10] => 1870
            [11] => 1975
            [12] => 1966
        )

    [UF_ADDRESS] => 1373
)
Array
(
    [ID] => 1
    [NAME] => Иванов
    [LAST_NAME] => Иван
    [UF_SELECT_MON] => Array
        (
            [0] => Багет 
            [1] => Баранина тушеная с рагу из баклажанов и кабачков 260/15 
        )

    [UF_SELECT_TUE] => Array
        (
            [0] => Баранина тушеная с рагу из баклажанов и кабачков 260/15 
            [1] => 1921
        )

    [UF_SELECT_WED] => Array
        (
            [0] => 1846
            [1] => 1842
        )

    [UF_SELECT_THU] => Array
        (
            [0] => 1968
            [1] => 1921
            [2] => 1963
        )

    [UF_SELECT_FRI] => Array
        (
            [0] => 1845
            [1] => 1931
            [2] => 1846
            [3] => 1856
            [4] => 1973
            [5] => 1886
        )

    [UF_SELECT_SAT] => Array
        (
            [0] => 1880
            [1] => 1845
            [2] => 1941
        )

    [UF_SELECT_SUN] => Array
        (
            [0] => 1845
            [1] => 1995
            [2] => 1971
            [3] => 1937
            [4] => 1855
            [5] => 1852
            [6] => 1871
            [7] => 1929
            [8] => 1974
            [9] => 1903
            [10] => 1870
            [11] => 1975
            [12] => 1966
        )

    [UF_ADDRESS] => 1373
)
Array
(
    [ID] => 1
    [NAME] => Иванов
    [LAST_NAME] => Иван
    [UF_SELECT_MON] => Array
        (
            [0] => Багет 
            [1] => Баранина тушеная с рагу из баклажанов и кабачков 260/15 
        )

    [UF_SELECT_TUE] => Array
        (
            [0] => Баранина тушеная с рагу из баклажанов и кабачков 260/15 
            [1] => Борщ с говядиной 200/30г 
        )

    [UF_SELECT_WED] => Array
        (
            [0] => 1846
            [1] => 1842
        )

    [UF_SELECT_THU] => Array
        (
            [0] => 1968
            [1] => 1921
            [2] => 1963
        )

    [UF_SELECT_FRI] => Array
        (
            [0] => 1845
            [1] => 1931
            [2] => 1846
            [3] => 1856
            [4] => 1973
            [5] => 1886
        )

    [UF_SELECT_SAT] => Array
        (
            [0] => 1880
            [1] => 1845
            [2] => 1941
        )

    [UF_SELECT_SUN] => Array
        (
            [0] => 1845
            [1] => 1995
            [2] => 1971
            [3] => 1937
            [4] => 1855
            [5] => 1852
            [6] => 1871
            [7] => 1929
            [8] => 1974
            [9] => 1903
            [10] => 1870
            [11] => 1975
            [12] => 1966
        )

    [UF_ADDRESS] => 1373
)
...

Я что то не так делаю ?

[Алексей]

countZer0, да.
userArray состоит из данных только одного пользователя?

[countZer0]

Я делал по Вашей инструкции. Всего пользователей больше чем один, я скинул распечатку массива одного пользователя для примера просто. Вот мой код:

global $USER;
 	// Получаем номер телефона и адрес стационара текущего юзера
 	// $filter = Array("ID" => $_SESSION['SESS_AUTH']['USER_ID']);
 	$arParams["SELECT"] = array( "UF_SELECT_MON", "UF_SELECT_TUE", "UF_SELECT_WED", "UF_SELECT_THU", "UF_SELECT_FRI", "UF_SELECT_SAT", "UF_SELECT_SUN", "UF_ADDRESS");
 	$rsUsers = CUser::GetList(($by="personal_phone"), ($order="desc"), false, $arParams); 
 	while ($arUser = $rsUsers->Fetch()) {
 		$tmp[] = $arUser["UF_SELECT_MON"]; //записываю все ID нужных свойств
 		$tmp[] = $arUser["UF_SELECT_TUE"];
 		$tmp[] = $arUser["UF_SELECT_WED"];
 		$tmp[] = $arUser["UF_SELECT_THU"];
 		$tmp[] = $arUser["UF_SELECT_FRI"];
 		$tmp[] = $arUser["UF_SELECT_SAT"];
 		$tmp[] = $arUser["UF_SELECT_SUN"];
 		$allUser[] = array( // тут запись всех пользователей со свойствами
 			"ID" => $arUser["ID"],
 			"NAME" => $arUser["NAME"],
 			"LAST_NAME" => $arUser["LAST_NAME"],
 			"UF_SELECT_MON" => $arUser["UF_SELECT_MON"],
 			"UF_SELECT_TUE" => $arUser["UF_SELECT_TUE"],
 			"UF_SELECT_WED" => $arUser["UF_SELECT_WED"],
 			"UF_SELECT_THU" => $arUser["UF_SELECT_THU"],
 			"UF_SELECT_FRI" => $arUser["UF_SELECT_FRI"],
 			"UF_SELECT_SAT" => $arUser["UF_SELECT_SAT"],
 			"UF_SELECT_SUN" => $arUser["UF_SELECT_SUN"],
 			"UF_ADDRESS" => $arUser["UF_ADDRESS"]
 		);
 	}

foreach ($tmp as $key => $value) {
	foreach ($value as $k => $v) {
		$arElementsId[] = $v; // тут формирую массив из всех ID связанных элементов
	}
}
 	$arSelectedElements = []; // пустой массив для загруженных связанных элементов
 	$rsElements = \CIBlockElement::GetList(['ID'=>'ASC'],['IBLOCK_ID' => 17, 'ID' => $arElementsId]);
 	while ($arElement = $rsElements->fetch()) {
 	    $arSelectedElements[$arElement['ID']] = $arElement['NAME'];
 	}

 	$arDaysFields = [
 	    'UF_SELECT_MON',
 	    'UF_SELECT_TUE',
 	    'UF_SELECT_WED',
 	    'UF_SELECT_THU',
 	    'UF_SELECT_FRI',
 	    'UF_SELECT_SAT', 
 	    'UF_SELECT_SUN'
 	];
 	foreach ($allUser as $topKey => $userArray) {
 	    // по всем юзерам
 	    foreach ($arDaysFields as $field) {
 	        // по всем дням
 	        foreach ($userArray[$field] as $innerKey => $element) {
 	            // заменяем в исходном массиве айди элементов на их NAME
 	            $userArray[$field][$innerKey] = $arSelectedElements[$element];

 	        }
 	    }
 	}

[Алексей]

countZer0, примерно так должно быть

global $USER;

$allUser =  $arElementsId =  $arSelectedElements = [];

$rsUsers = CUser::GetList(
    ($by="personal_phone"), 
    ($order="desc"), 
    false, 
    [
        'SELECT' => [
                        "UF_SELECT_MON", 
                        "UF_SELECT_TUE", 
                        "UF_SELECT_WED", 
                        "UF_SELECT_THU", 
                        "UF_SELECT_FRI", 
                        "UF_SELECT_SAT", 
                        "UF_SELECT_SUN", 
                        "UF_ADDRESS"
                    ]
    ]
); 
while ($arUser = $rsUsers->Fetch()) {
    $arElementsId = array_merge(
        $arElementsId,
        $arUser["UF_SELECT_MON"],
        $arUser["UF_SELECT_TUE"],
        $arUser["UF_SELECT_WED"],
        $arUser["UF_SELECT_THU"],
        $arUser["UF_SELECT_FRI"],
        $arUser["UF_SELECT_SAT"],
        $arUser["UF_SELECT_SUN"],
    );

    $allUser[] = [
        "ID" => $arUser["ID"],
        "NAME" => $arUser["NAME"],
        "LAST_NAME" => $arUser["LAST_NAME"],
        "UF_ADDRESS" => $arUser["UF_ADDRESS"],

        "UF_SELECT_MON" => $arUser["UF_SELECT_MON"],
        "UF_SELECT_TUE" => $arUser["UF_SELECT_TUE"],
        "UF_SELECT_WED" => $arUser["UF_SELECT_WED"],
        "UF_SELECT_THU" => $arUser["UF_SELECT_THU"],
        "UF_SELECT_FRI" => $arUser["UF_SELECT_FRI"],
        "UF_SELECT_SAT" => $arUser["UF_SELECT_SAT"],
        "UF_SELECT_SUN" => $arUser["UF_SELECT_SUN"],
    ];
}

$arElementsId = array_unique($arElementsId);
   
$rsElements = \CIBlockElement::GetList(
    ['ID'=>'ASC'],
    [
        'IBLOCK_ID' => 17, 
        'ID' => $arElementsId
    ]);

while ($arElement = $rsElements->fetch()) {
    $arSelectedElements[$arElement['ID']] = $arElement['NAME'];
}

$arDaysFields = [
    'UF_SELECT_MON',
    'UF_SELECT_TUE',
    'UF_SELECT_WED',
    'UF_SELECT_THU',
    'UF_SELECT_FRI',
    'UF_SELECT_SAT', 
    'UF_SELECT_SUN'
];
foreach ($allUser as $topKey => $userArray) {
    // по всем юзерам
    foreach ($arDaysFields as $day => $values) {
        // по всем дням
        foreach ($values as $innerKey => $element) {
            // заменяем в исходном массиве айди элементов на их NAME
            $allUser[$topKey][$day][$innerKey] = $arSelectedElements[$element];
        }
    }
}