Advertisement
AD_min

Untitled

Apr 13th, 2020
310
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.59 KB | None | 0 0
  1. require_once($_SERVER["DOCUMENT_ROOT"] . "/bitrix/modules/main/classes/general/csv_data.php");
  2.  
  3. $filePath = $_SERVER['DOCUMENT_ROOT'] . '/upload/users.csv';
  4. $fp = fopen($filePath, 'w+');
  5. @fclose($fp);
  6.  
  7. $fields_type = 'R'; //дописываем строки в файл
  8. $delimiter = ";";   //разделитель для csv-файла
  9. $csvFile = new \CCSVData($fields_type, false);
  10. $csvFile->SetFieldsType($fields_type);
  11. $csvFile->SetDelimiter($delimiter);
  12. $csvFile->SetFirstHeader(true);
  13.  
  14.  
  15. $arUsers = array();
  16. $csvFile->SaveFile($filePath, array("LOGIN", "ACTIVE", "NAME", "LAST NAME", "E-MAIL", "DATE_REGISTER", "ID", "Раздел регистрации", "UTM_CAMPAIGN", "UTM_TERM", "UTM_CONTENT", "UTM_SOURCE", "UTM_MEDIUM", "Баллы за рефералов", "Реферальный код"));
  17.  
  18. $res = CUser::GetList(($by="id"), ($order="desc"), [], ["SELECT"=>["LOGIN", "ACTIVE", "NAME", "LAST_NAME", "EMAIL", "DATE_REGISTER", "ID", "UF_SECTION_REGISTR", "UF_UTM_CAMPAIGN", "UF_UTM_TERM", "UF_UTM_CONTENT", "UF_UTM_SOURCE", "UF_UTM_MEDIUM", "UF_POINTS_REF", "UF_REF_PARENT"]]);
  19. while($arUser = $res->Fetch()) {
  20.     $arUsers[] = [
  21.         $arUser["LOGIN"],
  22.         $arUser["ACTIVE"],
  23.         $arUser["NAME"],
  24.         $arUser["LAST_NAME"],
  25.         $arUser["EMAIL"],
  26.         $arUser["DATE_REGISTER"],
  27.         $arUser["ID"],
  28.         $arUser["UF_SECTION_REGISTR"],
  29.         $arUser["UF_UTM_CAMPAIGN"],
  30.         $arUser["UF_UTM_TERM"],
  31.         $arUser["UF_UTM_CONTENT"],
  32.         $arUser["UF_UTM_SOURCE"],
  33.         $arUser["UF_UTM_MEDIUM"],
  34.         $arUser["UF_POINTS_REF"],
  35.         $arUser["UF_REF_PARENT"]
  36.     ];
  37. }
  38.  
  39. foreach($arUsers as $row)
  40. {
  41.     $csvFile->SaveFile($filePath, $row);
  42. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement