public static function ProductRows2BasketItems($arProductRows, $srcCurrencyID = '', $dstCurrencyID = '')
{
$basketItems = array();
$srcCurrencyID = strval($srcCurrencyID);
$dstCurrencyID = strval($dstCurrencyID);
if (strlen($srcCurrencyID) <= 0 || strlen($dstCurrencyID) <= 0) {
$srcCurrencyID = $dstCurrencyID = '';
}
foreach ($arProductRows as $row) {
$freshRow = array();
$freshRow['ID'] = isset($row['ID']) ? intval($row['ID']) : 0;
$freshRow['PRODUCT_ID'] = isset($row['PRODUCT_ID']) ? intval($row['PRODUCT_ID']) : 0;
$freshRow['PRODUCT_NAME'] = isset($row['PRODUCT_NAME']) ? strval($row['PRODUCT_NAME']) : '';
$freshRow['QUANTITY'] = isset($row['QUANTITY']) ? round(doubleval($row['QUANTITY']), 2) : 0.0;
$freshRow['PRICE'] = isset($row['PRICE']) ? round(doubleval($row['PRICE']), 2) : 0.0;
if ($dstCurrencyID != $srcCurrencyID) {
$freshRow['PRICE'] = CCrmCurrency::ConvertMoney($freshRow['PRICE'], $srcCurrencyID, $dstCurrencyID);
}
$taxRate = isset($row['TAX_RATE']) ? round(doubleval($row['TAX_RATE']), 2) : 0.0;
$freshRow['VAT_RATE'] = $taxRate / 100;
$discountTypeID = isset($row['DISCOUNT_TYPE_ID']) ? intval($row['DISCOUNT_TYPE_ID']) : \Bitrix\Crm\Discount::UNDEFINED;
if ($discountTypeID !== \Bitrix\Crm\Discount::PERCENTAGE && $discountTypeID !== \Bitrix\Crm\Discount::MONETARY) {
$discountTypeID = \Bitrix\Crm\Discount::PERCENTAGE;
}
if ($discountTypeID === \Bitrix\Crm\Discount::PERCENTAGE) {
$discountRate = isset($row['DISCOUNT_RATE']) ? round(doubleval($row['DISCOUNT_RATE']), 2) : 0.0;
$exclusivePrice = CCrmProductRow::CalculateExclusivePrice($freshRow['PRICE'], $taxRate);
$freshRow['DISCOUNT_PRICE'] = round(\Bitrix\Crm\Discount::calculateDiscountSum($exclusivePrice, $discountRate), 2);
} else {
$freshRow['DISCOUNT_PRICE'] = isset($row['DISCOUNT_SUM']) ? round(doubleval($row['DISCOUNT_SUM']), 2) : 0.0;
if ($dstCurrencyID != $srcCurrencyID) {
$freshRow['DISCOUNT_PRICE'] = CCrmCurrency::ConvertMoney($freshRow['DISCOUNT_PRICE'], $srcCurrencyID, $dstCurrencyID);
}
}
$freshRow['MEASURE_CODE'] = isset($row['MEASURE_CODE']) ? intval($row['MEASURE_CODE']) : 0;
$freshRow['MEASURE_NAME'] = isset($row['MEASURE_NAME']) ? strval($row['MEASURE_NAME']) : '';
$freshRow['CUSTOMIZED'] = isset($row['CUSTOMIZED']) ? $row['CUSTOMIZED'] === 'Y' ? 'Y' : 'N' : 'Y';
$basketItems[] = $freshRow;
}
return $basketItems;
}
$ary['MEASURE_CODE'] = isset($row['MEASURE_CODE']) ? intval($row['MEASURE_CODE']) : 0;
$ary['MEASURE_NAME'] = isset($row['MEASURE_NAME']) ? $row['MEASURE_NAME'] : '';
unset($row['ORDER_ID'], $row['NAME'], $row['DISCOUNT_PRICE'], $row['VAT_RATE'], $row['CUSTOM_PRICE']);
}
if ($arResult['ALLOW_LD_TAX']) {
$row['PRICE'] = CCrmProductRow::CalculateExclusivePrice($row['PRICE'], $row['TAX_RATE']);
$row['TAX_RATE'] = 0.0;
$row['TAX_INCLUDED'] = 'N';
}
$exclusivePrice = CCrmProductRow::CalculateExclusivePrice($row['PRICE'], $row['TAX_RATE']);
$discountTypeID = intval($row['DISCOUNT_TYPE_ID']);
if ($discountTypeID === \Bitrix\Crm\Discount::MONETARY) {
$row['PRICE_NETTO'] = $exclusivePrice + $row['DISCOUNT_SUM'];
} else {
$discoutRate = doubleval($row['DISCOUNT_RATE']);
$discoutSum = $discoutRate < 100 ? \Bitrix\Crm\Discount::calculateDiscountSum($exclusivePrice, $discoutRate) : doubleval($row['DISCOUNT_SUM']);
$row['PRICE_NETTO'] = $exclusivePrice + $discoutSum;
}
$row['PRICE_BRUTTO'] = CCrmProductRow::CalculateInclusivePrice($row['PRICE_NETTO'], $row['TAX_RATE']);
$totalDiscount += round($row['QUANTITY'] * $row['DISCOUNT_SUM'], 2);
//$totalSum += round($row['QUANTITY'] * $row['PRICE'], 2);
//$totalTax += round($row['PRICE'] - $exclusivePrice, 2);
}
unset($row);
if (count($arResult['PRODUCT_ROWS']) > 0 && (!isset($arParams['TOTAL_SUM']) || !isset($arParams['TOTAL_TAX']))) {
$enableSaleDiscount = false;
$calcOptions = array();
if ($arResult['ALLOW_LD_TAX']) {
$calcOptions['LOCATION_ID'] = isset($arParams['LOCATION_ID']) ? $arParams['LOCATION_ID'] : '';
}
$result = CCrmSaleHelper::Calculate($arResult['PRODUCT_ROWS'], $currencyID, $personTypeId, $enableSaleDiscount, SITE_ID, $calcOptions);
public static function SaveRows($ownerType, $ownerID, $arRows, $accountContext = null, $checkPerms = true, $regEvent = true, $syncOwner = true, $totalInfo = array())
{
$ownerType = strval($ownerType);
$ownerID = intval($ownerID);
if (!isset($ownerType[0]) || $ownerID <= 0 || !is_array($arRows)) {
self::RegisterError('Invalid arguments are supplied.');
return false;
}
if (!is_array($totalInfo)) {
$totalInfo = array();
}
$owner = null;
if (!is_array($accountContext)) {
if ($ownerType === 'D') {
$owner = CCrmDeal::GetByID($ownerID, $checkPerms);
} elseif ($ownerType === CCrmQuote::OWNER_TYPE) {
$owner = CCrmQuote::GetByID($ownerID);
} elseif ($ownerType === 'L') {
$owner = CCrmLead::GetByID($ownerID);
}
}
// Preparing accounting context -->
if (!is_array($accountContext)) {
$accountContext = array();
if (is_array($owner)) {
if (isset($owner['CURRENCY_ID'])) {
$accountContext['CURRENCY_ID'] = $owner['CURRENCY_ID'];
}
if (isset($owner['EXCH_RATE'])) {
$accountContext['EXCH_RATE'] = $owner['EXCH_RATE'];
}
}
}
$currencyID = isset($accountContext['CURRENCY_ID']) ? $accountContext['CURRENCY_ID'] : CCrmCurrency::GetBaseCurrencyID();
$exchRate = isset($accountContext['EXCH_RATE']) ? $accountContext['EXCH_RATE'] : null;
// <-- Preparing accounting context
$productIDs = array();
$products = array();
foreach ($arRows as &$arRow) {
$productID = isset($arRow['PRODUCT_ID']) ? intval($arRow['PRODUCT_ID']) : 0;
if ($productID > 0 && !in_array($productID, $productIDs, true)) {
$productIDs[] = $productID;
}
}
unset($arRow);
if (!empty($productIDs)) {
$dbProduct = CCrmProduct::GetList(array(), array('ID' => $productIDs), array('ID', 'NAME'));
if (is_object($dbProduct)) {
while ($product = $dbProduct->Fetch()) {
$products[intval($product['ID'])] = $product;
}
}
}
$measurelessProductIDs = array();
$arSafeRows = array();
foreach ($arRows as &$arRow) {
//$rowID = isset($arRow['ID']) ? intval($arRow['ID']) : 0;
$productID = $arRow['PRODUCT_ID'] = isset($arRow['PRODUCT_ID']) ? intval($arRow['PRODUCT_ID']) : 0;
$productName = $arRow['PRODUCT_NAME'] = isset($arRow['PRODUCT_NAME']) ? $arRow['PRODUCT_NAME'] : '';
$arRow['PRICE'] = isset($arRow['PRICE']) ? round(doubleval($arRow['PRICE']), 2) : 0.0;
$arRow['QUANTITY'] = isset($arRow['QUANTITY']) ? round(doubleval($arRow['QUANTITY']), 4) : 1;
$arRow['TAX_RATE'] = isset($arRow['TAX_RATE']) ? round(doubleval($arRow['TAX_RATE']), 2) : 0.0;
$arRow['TAX_INCLUDED'] = isset($arRow['TAX_INCLUDED']) ? $arRow['TAX_INCLUDED'] === 'Y' ? 'Y' : 'N' : 'N';
$arRow['MEASURE_CODE'] = isset($arRow['MEASURE_CODE']) ? intval($arRow['MEASURE_CODE']) : 0;
$arRow['MEASURE_NAME'] = isset($arRow['MEASURE_NAME']) ? $arRow['MEASURE_NAME'] : '';
$arRow['CUSTOMIZED'] = isset($arRow['CUSTOMIZED']) && strtoupper($arRow['CUSTOMIZED']) === 'Y' ? 'Y' : 'N';
$arRow['SORT'] = isset($arRow['SORT']) ? intval($arRow['SORT']) : 0;
if ($productID > 0 && $productName !== '' && isset($products[$productID])) {
//Skip save product name if it equal to original
$product = $products[$productID];
$originalProductName = isset($product['NAME']) ? trim($product['NAME']) : '';
if ($productName === $originalProductName) {
$productName = '';
}
}
$price = $arRow['PRICE'];
$arRow['DISCOUNT_TYPE_ID'] = isset($arRow['DISCOUNT_TYPE_ID']) ? intval($arRow['DISCOUNT_TYPE_ID']) : 0;
if (!\Bitrix\Crm\Discount::isDefined($arRow['DISCOUNT_TYPE_ID'])) {
$arRow['DISCOUNT_TYPE_ID'] = \Bitrix\Crm\Discount::PERCENTAGE;
$arRow['DISCOUNT_RATE'] = 0.0;
}
$discountTypeID = $arRow['DISCOUNT_TYPE_ID'];
if ($discountTypeID === \Bitrix\Crm\Discount::PERCENTAGE) {
if (!isset($arRow['DISCOUNT_RATE'])) {
self::RegisterError("Discount Rate (DISCOUNT_RATE) is required if Percentage Discount Type (DISCOUNT_TYPE_ID) is defined.");
return false;
}
$discountRate = round(doubleval($arRow['DISCOUNT_RATE']), 2);
if (isset($arRow['DISCOUNT_SUM'])) {
$discountSum = round(doubleval($arRow['DISCOUNT_SUM']), 2);
} else {
$exclusivePrice = self::CalculateExclusivePrice($price, $arRow['TAX_RATE']);
$discountSum = round(\Bitrix\Crm\Discount::calculateDiscountSum($exclusivePrice, $discountRate), 2);
}
} else {
if (!isset($arRow['DISCOUNT_SUM'])) {
self::RegisterError("Discount Sum (DISCOUNT_SUM) is required if Monetary Discount Type (DISCOUNT_TYPE_ID) is defined.");
return false;
}
$discountSum = round(doubleval($arRow['DISCOUNT_SUM']), 2);
if (isset($arRow['DISCOUNT_RATE'])) {
$discountRate = round(doubleval($arRow['DISCOUNT_RATE']), 2);
} else {
$exclusivePrice = self::CalculateExclusivePrice($price, $arRow['TAX_RATE']);
$discountRate = \Bitrix\Crm\Discount::calculateDiscountRate($exclusivePrice + $discountSum, $exclusivePrice);
}
}
$measureCode = $arRow['MEASURE_CODE'];
if ($productID > 0 && $measureCode <= 0) {
if (!in_array($productID, $measurelessProductIDs, true)) {
$measurelessProductIDs[] = $productID;
}
}
$safeRow = array('OWNER_TYPE' => $ownerType, 'OWNER_ID' => $ownerID, 'PRODUCT_ID' => $productID, 'PRODUCT_NAME' => $productName, 'PRICE' => $price, 'QUANTITY' => $arRow['QUANTITY'], 'DISCOUNT_TYPE_ID' => $discountTypeID, 'DISCOUNT_SUM' => $discountSum, 'DISCOUNT_RATE' => $discountRate, 'TAX_RATE' => $arRow['TAX_RATE'], 'TAX_INCLUDED' => isset($arRow['TAX_INCLUDED']) ? $arRow['TAX_INCLUDED'] === 'Y' ? 'Y' : 'N' : 'N', 'MEASURE_CODE' => $measureCode, 'MEASURE_NAME' => $arRow['MEASURE_NAME'], 'CUSTOMIZED' => 'Y', 'SORT' => $arRow['SORT']);
$accData = CCrmAccountingHelper::PrepareAccountingData(array('CURRENCY_ID' => $currencyID, 'SUM' => $safeRow['PRICE'], 'EXCH_RATE' => $exchRate));
if (is_array($accData)) {
$safeRow['PRICE_ACCOUNT'] = $accData['ACCOUNT_SUM'];
}
$arSafeRows[] =& $safeRow;
unset($safeRow);
}
unset($arRow);
if (!empty($measurelessProductIDs)) {
$defaultMeasureInfo = \Bitrix\Crm\Measure::getDefaultMeasure();
$measureInfos = \Bitrix\Crm\Measure::getProductMeasures($measurelessProductIDs);
foreach ($arSafeRows as &$safeRow) {
if ($safeRow['MEASURE_CODE'] > 0) {
continue;
}
$productID = $safeRow['PRODUCT_ID'];
if (isset($measureInfos[$productID]) && !empty($measureInfos[$productID])) {
$measureInfo = $measureInfos[$productID][0];
$safeRow['MEASURE_CODE'] = $measureInfo['CODE'];
$safeRow['MEASURE_NAME'] = $measureInfo['SYMBOL'];
} elseif ($defaultMeasureInfo !== null) {
$safeRow['MEASURE_CODE'] = $defaultMeasureInfo['CODE'];
$safeRow['MEASURE_NAME'] = $defaultMeasureInfo['SYMBOL'];
}
}
unset($safeRow);
}
$arPresentRows = self::LoadRows($ownerType, $ownerID, true);
// Registering events -->
if ($regEvent) {
$arRowIDs = array();
foreach ($arRows as &$arRow) {
if (isset($arRow['ID'])) {
$arRowIDs[] = intval($arRow['ID']);
}
$rowID = isset($arRow['ID']) ? intval($arRow['ID']) : 0;
if ($rowID <= 0) {
// Row was added
self::RegisterAddEvent($ownerType, $ownerID, $arRow, $checkPerms);
continue;
}
$arPresentRow = isset($arPresentRows[$rowID]) ? $arPresentRows[$rowID] : null;
if ($arPresentRow) {
// Row was modified
self::RegisterUpdateEvent($ownerType, $ownerID, $arRow, $arPresentRow, $checkPerms);
}
}
unset($arRow);
foreach ($arPresentRows as $rowID => &$arPresentRow) {
if (!in_array($rowID, $arRowIDs, true)) {
// Product was removed
self::RegisterRemoveEvent($ownerType, $ownerID, $arPresentRow, $checkPerms);
}
}
}
// <-- Registering events
$result = CCrmProductRow::DoSaveRows($ownerType, $ownerID, $arSafeRows);
// Update list of taxes
if (!isset($totalInfo['CURRENCY_ID'])) {
$totalInfo['CURRENCY_ID'] = $currencyID;
}
self::UpdateTotalInfo($ownerType, $ownerID, $totalInfo);
// Disable sum synchronization if product rows are empty
if ($result && $syncOwner && (count($arPresentRows) > 0 || count($arSafeRows) > 0)) {
self::SynchronizeOwner($ownerType, $ownerID, $checkPerms, $totalInfo);
}
return $result;
}
