$row['TAX_RATE'] = round(doubleval($row['VAT_RATE']), 2) * 100;
$row['TAX_INCLUDED'] = 'Y';
$row['DISCOUNT_TYPE_ID'] = \Bitrix\Crm\Discount::MONETARY;
$exclusivePrice = CCrmProductRow::CalculateExclusivePrice($row['PRICE'], $row['TAX_RATE']);
$row['DISCOUNT_SUM'] = round(doubleval($row['DISCOUNT_PRICE']), 2);
$row['DISCOUNT_RATE'] = \Bitrix\Crm\Discount::calculateDiscountRate($exclusivePrice + $row['DISCOUNT_SUM'], $exclusivePrice);
$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']))) {
private static function PrepareShoppingCartItems(&$productRows, $currencyID, $siteId)
{
$items = array();
foreach ($productRows as $k => &$v) {
$item = array();
$item['PRODUCT_ID'] = isset($v['PRODUCT_ID']) ? intval($v['PRODUCT_ID']) : 0;
$isCustomized = isset($v['CUSTOMIZED']) && $v['CUSTOMIZED'] === 'Y';
if ($item['PRODUCT_ID'] > 0 && !$isCustomized) {
$item['MODULE'] = 'catalog';
$item['PRODUCT_PROVIDER_CLASS'] = 'CCatalogProductProvider';
} else {
$item['MODULE'] = $item['PRODUCT_PROVIDER_CLASS'] = '';
}
if ($isCustomized) {
$item['CUSTOM_PRICE'] = 'Y';
}
$item['TABLE_ROW_ID'] = $k;
$item['QUANTITY'] = isset($v['QUANTITY']) ? doubleval($v['QUANTITY']) : 0;
$item['QUANTITY_DEFAULT'] = $item['QUANTITY'];
$item['PRICE'] = isset($v['PRICE']) ? doubleval($v['PRICE']) : 0.0;
$item['PRICE_DEFAULT'] = $item['PRICE'];
$item['CURRENCY'] = $currencyID;
// discount info
$item['CRM_PR_FIELDS'] = array();
$item['CRM_PR_FIELDS']['DISCOUNT_TYPE_ID'] = isset($v['DISCOUNT_TYPE_ID']) ? intval($v['DISCOUNT_TYPE_ID']) : \Bitrix\Crm\Discount::PERCENTAGE;
$item['CRM_PR_FIELDS']['DISCOUNT_RATE'] = isset($v['DISCOUNT_RATE']) ? round(doubleval($v['DISCOUNT_RATE']), 2) : 0.0;
$item['CRM_PR_FIELDS']['DISCOUNT_SUM'] = isset($v['DISCOUNT_SUM']) ? round(doubleval($v['DISCOUNT_SUM']), 2) : 0.0;
// tax info
$taxRate = isset($v['TAX_RATE']) ? round(doubleval($v['TAX_RATE']), 2) : 0.0;
$allowLDTax = CCrmTax::isTaxMode();
if ($allowLDTax) {
$item['CRM_PR_FIELDS']['TAX_RATE'] = 0.0;
$item['CRM_PR_FIELDS']['TAX_INCLUDED'] = 'N';
} else {
$item['CRM_PR_FIELDS']['TAX_RATE'] = $taxRate;
$item['CRM_PR_FIELDS']['TAX_INCLUDED'] = isset($v['TAX_INCLUDED']) && $v['TAX_INCLUDED'] === 'Y' ? 'Y' : 'N';
}
// price netto, price brutto
$exclusivePrice = $taxRate !== 0.0 ? CCrmProductRow::CalculateExclusivePrice($item['PRICE'], $taxRate) : $item['PRICE'];
if ($item['CRM_PR_FIELDS']['DISCOUNT_TYPE_ID'] === \Bitrix\Crm\Discount::MONETARY) {
$priceNetto = $exclusivePrice + $item['CRM_PR_FIELDS']['DISCOUNT_SUM'];
$item['CRM_PR_FIELDS']['PRICE_NETTO'] = round($priceNetto, 2);
} else {
$discoutRate = $item['CRM_PR_FIELDS']['DISCOUNT_RATE'];
$discoutSum = $discoutRate < 100 ? \Bitrix\Crm\Discount::calculateDiscountByDiscountPrice($exclusivePrice, $discoutRate) : $item['CRM_PR_FIELDS']['DISCOUNT_SUM'];
$priceNetto = $exclusivePrice + $discoutSum;
$item['CRM_PR_FIELDS']['PRICE_NETTO'] = round($priceNetto, 2);
}
if ($item['CRM_PR_FIELDS']['DISCOUNT_SUM'] === 0.0) {
$item['CRM_PR_FIELDS']['PRICE_BRUTTO'] = $item['PRICE'];
} else {
$item['CRM_PR_FIELDS']['PRICE_BRUTTO'] = round(CCrmProductRow::CalculateInclusivePrice($priceNetto, $item['CRM_PR_FIELDS']['TAX_RATE']), 2);
}
if (isset($v['VAT_RATE'])) {
$item['VAT_RATE'] = $v['VAT_RATE'];
} elseif (isset($v['TAX_RATE'])) {
$item['VAT_RATE'] = $v['TAX_RATE'] / 100;
}
if (isset($v['MEASURE_CODE'])) {
$item['MEASURE_CODE'] = $v['MEASURE_CODE'];
}
if (isset($v['MEASURE_NAME'])) {
$item['MEASURE_NAME'] = $v['MEASURE_NAME'];
}
$item['NAME'] = isset($v['NAME']) ? $v['NAME'] : (isset($v['PRODUCT_NAME']) ? $v['PRODUCT_NAME'] : '');
$item['LID'] = $siteId;
$item['CAN_BUY'] = 'Y';
$items[] =& $item;
unset($item);
}
unset($v);
return $items;
}
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;
}
protected function innerGetList($order, $filter, $select, $navigation, &$errors)
{
$ownerID = isset($filter['OWNER_ID']) ? intval($filter['OWNER_ID']) : 0;
$ownerType = isset($filter['OWNER_TYPE']) ? $filter['OWNER_TYPE'] : '';
if ($ownerID <= 0 || $ownerType === '') {
if ($ownerID <= 0) {
$errors[] = 'The field OWNER_ID is required in filer.';
}
if ($ownerType === '') {
$errors[] = 'The field OWNER_TYPE is required in filer.';
}
return false;
}
if ($ownerType === 'I') {
//Crutch for Invoices
if (!CCrmInvoice::CheckReadPermission($ownerID)) {
$errors[] = 'Access denied.';
return false;
}
$result = array();
$productRows = CCrmInvoice::GetProductRows($ownerID);
foreach ($productRows as $productRow) {
$price = isset($productRow['PRICE']) ? $productRow['PRICE'] : 0.0;
$discountSum = isset($productRow['DISCOUNT_PRICE']) ? $productRow['DISCOUNT_PRICE'] : 0.0;
$taxRate = isset($productRow['VAT_RATE']) ? $productRow['VAT_RATE'] * 100 : 0.0;
$exclusivePrice = CCrmProductRow::CalculateExclusivePrice($price, $taxRate);
$discountRate = \Bitrix\Crm\Discount::calculateDiscountRate($exclusivePrice + $discountSum, $exclusivePrice);
$result[] = array('ID' => $productRow['ID'], 'OWNER_ID' => $ownerID, 'OWNER_TYPE' => 'I', 'PRODUCT_ID' => isset($productRow['PRODUCT_ID']) ? $productRow['PRODUCT_ID'] : 0, 'PRODUCT_NAME' => isset($productRow['PRODUCT_NAME']) ? $productRow['PRODUCT_NAME'] : '', 'PRICE' => $price, 'QUANTITY' => isset($productRow['QUANTITY']) ? $productRow['QUANTITY'] : 0, 'DISCOUNT_TYPE_ID' => \Bitrix\Crm\Discount::MONETARY, 'DISCOUNT_RATE' => $discountRate, 'DISCOUNT_SUM' => $discountSum, 'TAX_RATE' => $taxRate, 'TAX_INCLUDED' => 'Y', 'MEASURE_CODE' => isset($productRow['MEASURE_CODE']) ? $productRow['MEASURE_CODE'] : '', 'MEASURE_NAME' => isset($productRow['MEASURE_NAME']) ? $productRow['MEASURE_NAME'] : '', 'CUSTOMIZED' => isset($productRow['CUSTOM_PRICE']) ? $productRow['CUSTOM_PRICE'] : 'N');
}
return $result;
}
if (!CCrmAuthorizationHelper::CheckReadPermission(CCrmProductRow::ResolveOwnerTypeName($ownerType), $ownerID)) {
$errors[] = 'Access denied.';
return false;
}
return CCrmProductRow::GetList($order, $filter, false, $navigation, $select, array('IS_EXTERNAL_CONTEXT' => true));
}
