Skip to content

Instantly share code, notes, and snippets.

@Pum-purum
Created March 14, 2019 15:16
Show Gist options
  • Save Pum-purum/43aa931b69a0749b4e962ded3d899799 to your computer and use it in GitHub Desktop.
Save Pum-purum/43aa931b69a0749b4e962ded3d899799 to your computer and use it in GitHub Desktop.
Обновление полей сделок из CSV
<?
require($_SERVER["DOCUMENT_ROOT"] . "/bitrix/header.php");
global $USER;
\Bitrix\Main\Loader::includeModule('crm');
require_once($_SERVER['DOCUMENT_ROOT'].BX_ROOT.'/modules/main/classes/general/csv_data.php');
$csvFile = new CCSVData();
$csvFile->LoadFile("deals CSV.csv");
$csvFile->SetFieldsType('R');
$csvFile->SetFirstHeader(true);
$csvFile->SetDelimiter();
$iRow = 1;
$arHeader = Array();
$arRows = Array();
$i = 0;
while($arData = $csvFile->Fetch())
{
$i++;
$iDealID = $iContactID = 0;
$arData = $GLOBALS['APPLICATION']->ConvertCharSet($arData, 'cp1251', 'utf8');
$rsDeal = \CCrmDeal::GetListEx(array(), array("=UF_ASOFT_CODE"=>$arData[0]), false, false, array('ID'));
if ($arDeal = $rsDeal->Fetch()) {
$iDealID = $arDeal["ID"];
}
$rsContact = \CCrmContact::GetListEx(array(), array("=UF_ASOFT_CODE"=>$arData[6]), false, false, array('ID'));
if ($arContact = $rsContact->Fetch()) {
$iContactID = $arContact["ID"];
}
if ($iDealID > 0 && $iContactID > 0) {
$arFields = array('CONTACT_ID' => $iContactID);
$CCrmDeal = new CCrmDeal(false);
$CCrmDeal->Update(
$iDealID,
$arFields,
true,
true,
array('DISABLE_USER_FIELD_CHECK' => true));
}
}
require($_SERVER["DOCUMENT_ROOT"] . "/bitrix/footer.php"); ?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment