/**
* Convert discount for old order.
*
* @param int $orderId Order id.
* @param array &$data Discount data.
* @return bool
* @throws Main\LoaderException
*/
private static function migrateDiscount($orderId, &$data)
{
if (self::$catalogIncluded === null) {
self::$catalogIncluded = Main\Loader::includeModule('catalog');
}
if (!self::$catalogIncluded) {
return false;
}
$discountData = array('COUPON' => '', 'NAME' => '', 'DISCOUNT_ID' => 0);
if ($data['DISCOUNT_NAME'] != '') {
$discountName = array();
if (preg_match('/^\\[(\\d+)\\][ ](.+)$/', $data['DISCOUNT_NAME'], $discountName) == 1) {
$discountData['NAME'] = $discountName[2];
$discountData['DISCOUNT_ID'] = $discountName[1];
}
unset($discountName);
}
if ($data['DISCOUNT_COUPON'] != '') {
$discountData['COUPON'] = $data['DISCOUNT_COUPON'];
if (!self::checkMigrateCoupon($discountData['COUPON'])) {
return false;
}
if ($discountData['DISCOUNT_ID'] == 0) {
$discountData['NAME'] = self::$migrateCouponsCache[$discountData['COUPON']]['DISCOUNT_NAME'];
$discountData['DISCOUNT_ID'] = self::$migrateCouponsCache[$discountData['COUPON']]['DISCOUNT_ID'];
} else {
if (self::$migrateCouponsCache[$discountData['COUPON']]['TYPE'] != Internals\DiscountCouponTable::TYPE_ARCHIVED && self::$migrateCouponsCache[$discountData['COUPON']]['DISCOUNT_ID'] >= 0 && $discountData['DISCOUNT_ID'] != self::$migrateCouponsCache[$discountData['COUPON']]['DISCOUNT_ID']) {
$discountData['DISCOUNT_ID'] = 0;
}
}
}
if ($discountData['DISCOUNT_ID'] == 0) {
if ($discountData['COUPON'] == '') {
return false;
}
self::createEmptyDiscount($discountData);
} else {
self::checkMigrateDiscount($discountData);
}
$saveResult = self::saveMigrateDiscount($discountData);
if (!$saveResult->isSuccess()) {
return false;
}
$migrateDiscountData = $saveResult->getData();
unset($saveResult);
$orderDiscountId = $migrateDiscountData['ORDER_DISCOUNT_ID'];
$orderCouponId = 0;
$discountDescr = current($migrateDiscountData['ACTIONS_DESCR']['BASKET']);
if ($discountData['COUPON'] != '') {
$couponData = self::$migrateCouponsCache[$discountData['COUPON']];
$couponData['ORDER_ID'] = $orderId;
$couponData['ORDER_DISCOUNT_ID'] = $migrateDiscountData['ORDER_DISCOUNT_ID'];
$couponData['DATA']['DISCOUNT_ID'] = $migrateDiscountData['DISCOUNT_ID'];
if (array_key_exists('DISCOUNT_ID', $couponData)) {
unset($couponData['DISCOUNT_ID']);
}
if (array_key_exists('DISCOUNT_NAME', $couponData)) {
unset($couponData['DISCOUNT_NAME']);
}
$saveResult = self::saveCoupon($couponData);
if (!$saveResult->isSuccess()) {
return false;
}
$migrateCoupon = $saveResult->getData();
$orderCouponId = $migrateCoupon['ID'];
}
foreach ($data['ITEMS'] as $basketItem) {
$applyDescr = $discountDescr;
if ($basketItem['DISCOUNT_VALUE'] != '') {
if ($applyDescr['TYPE'] == self::DESCR_TYPE_SIMPLE) {
$applyDescr['DESCR'] .= ' (' . $basketItem['DISCOUNT_VALUE'] . ')';
} else {
$valueData = array();
if (preg_match('/^(|\\+|-)(\\d+|[.,]\\d+|\\d+[.,]\\d+)\\s?%$/', $basketItem['DISCOUNT_VALUE'], $valueData) == 1) {
$applyDescr['RESULT_VALUE'] = (double) $basketItem['DISCOUNT_VALUE'];
$applyDescr['RESULT_UNIT'] = self::DESCR_VALUE_TYPE_PERCENT;
}
unset($valueData);
}
}
$ruleRow = array('MODULE_ID' => 'catalog', 'ORDER_DISCOUNT_ID' => $orderDiscountId, 'ORDER_ID' => $orderId, 'ENTITY_TYPE' => Internals\OrderRulesTable::ENTITY_TYPE_BASKET, 'ENTITY_ID' => $basketItem['ID'], 'ENTITY_VALUE' => $basketItem['ID'], 'COUPON_ID' => $orderCouponId, 'APPLY' => 'Y');
$ruleDescr = array('MODULE_ID' => 'catalog', 'ORDER_DISCOUNT_ID' => $orderDiscountId, 'ORDER_ID' => $orderId, 'DESCR' => array($applyDescr));
$ruleResult = Internals\OrderRulesTable::add($ruleRow);
if ($ruleResult->isSuccess()) {
$ruleDescr['RULE_ID'] = $ruleResult->getId();
$descrResult = Internals\OrderRulesDescrTable::add($ruleDescr);
if (!$descrResult->isSuccess()) {
return false;
}
} else {
return false;
}
unset($ruleResult);
}
unset($basketItem);
return true;
}
$arActions[] = array("ICON" => "print", "TEXT" => Loc::getMessage("SALE_PRINT_DESCR"), "ACTION" => $lAdmin->ActionRedirect("sale_order_print.php?ID=" . $f_ID . "&lang=" . LANGUAGE_ID . GetFilterParams("filter_")));
if ($arOrder['LOCK_STATUS'] != "red") {
if (CSaleOrder::CanUserUpdateOrder($f_ID, $arUserGroups)) {
$arActions[] = array("ICON" => "edit", "TEXT" => Loc::getMessage("SALE_OEDIT_DESCR"), "ACTION" => $lAdmin->ActionRedirect("sale_order_edit.php?ID=" . $f_ID . "&lang=" . LANGUAGE_ID . GetFilterParams("filter_")));
}
if ($saleModulePermissions == "W" || $f_PAYED != "Y" && CSaleOrder::CanUserDeleteOrder($f_ID, $arUserGroups, $intUserID)) {
$arActions[] = array("SEPARATOR" => true);
$arActions[] = array("ICON" => "delete", "TEXT" => Loc::getMessage("SALE_DELETE_DESCR"), "ACTION" => "if(confirm('" . Loc::getMessage('SALE_CONFIRM_DEL_MESSAGE') . "')) " . $lAdmin->ActionDoGroup($f_ID, "delete"));
}
}
$row->AddActions($arActions);
}
if (!empty($rowsList)) {
if (in_array('BASKET_DISCOUNT_NAME', $arVisibleColumns)) {
$discountList = array();
$discountsIterator = Sale\Internals\OrderRulesTable::getList(array('select' => array('ORDER_ID', 'DISCOUNT_NAME' => 'ORDER_DISCOUNT.NAME', 'DISCOUNT_ID' => 'ORDER_DISCOUNT.ID'), 'filter' => array('@ORDER_ID' => array_keys($rowsList)), 'order' => array('ORDER_ID' => 'ASC', 'ID' => 'ASC')));
while ($discount = $discountsIterator->fetch()) {
$discount['ORDER_ID'] = (int) $discount['ORDER_ID'];
$discount['DISCOUNT_ID'] = (int) $discount['DISCOUNT_ID'];
$discount['DISCOUNT_NAME'] = (string) $discount['DISCOUNT_NAME'];
if (!isset($discountList[$discount['ORDER_ID']])) {
$discountList[$discount['ORDER_ID']] = array();
}
$discountList[$discount['ORDER_ID']][$discount['DISCOUNT_ID']] = $discount['DISCOUNT_NAME'] != '' ? $discount['DISCOUNT_NAME'] : $discount['DISCOUNT_ID'];
}
unset($discount, $discountsIterator);
if (!empty($discountList)) {
foreach ($discountList as $order => $orderDiscounts) {
$rowsList[$order]->AddViewField('BASKET_DISCOUNT_NAME', implode('<br><br>', $orderDiscounts));
}
unset($order, $orderDiscounts);
/**
* Save discount result for exist order.
*
* @return Result
*/
protected function saveApply()
{
$result = new Result();
$process = true;
$order = $this->getOrder();
$orderId = $order->getId();
if ($this->convertedOrder) {
return $result;
}
$deleteList = array();
$rulesIterator = Internals\OrderRulesTable::getList(array('select' => array('ID', 'ORDER_ID'), 'filter' => array('=ORDER_ID' => $orderId)));
while ($rule = $rulesIterator->fetch()) {
$rule['ID'] = (int) $rule['ID'];
$deleteList[$rule['ID']] = $rule['ID'];
}
unset($rule, $rulesIterator);
$rulesList = array();
if (!empty($this->discountResult['BASKET'])) {
foreach ($this->discountResult['BASKET'] as $basketCode => $discountList) {
foreach ($discountList as $discount) {
if (!isset($discount['RULE_ID']) || (int) $discount['RULE_ID'] < 0) {
$process = false;
$result->addError(new Main\Entity\EntityError(Loc::getMessage('BX_SALE_DISCOUNT_ERR_EMPTY_RULE_ID_EXT_DISCOUNT'), self::ERROR_ID));
continue;
}
$orderDiscountId = $discount['DISCOUNT_ID'];
$ruleData = array('RULE_ID' => $discount['RULE_ID'], 'APPLY' => $discount['RESULT']['APPLY'], 'DESCR_ID' => isset($discount['RULE_DESCR_ID']) ? (int) $discount['RULE_DESCR_ID'] : 0, 'DESCR' => $discount['RESULT']['DESCR_DATA']['BASKET']);
if ($ruleData['DESCR_ID'] <= 0) {
$ruleData['DESCR_ID'] = 0;
$ruleData['MODULE_ID'] = $this->discountsCache[$orderDiscountId]['MODULE_ID'];
$ruleData['ORDER_DISCOUNT_ID'] = $orderDiscountId;
$ruleData['ORDER_ID'] = $orderId;
}
$rulesList[] = $ruleData;
unset($ruleData);
}
unset($discount);
}
unset($basketCode, $discountList);
}
if (!empty($this->discountResult['ORDER'])) {
foreach ($this->discountResult['ORDER'] as $discount) {
$orderDiscountId = $discount['DISCOUNT_ID'];
if (!empty($discount['RESULT']['BASKET'])) {
foreach ($discount['RESULT']['BASKET'] as $basketCode => $applyData) {
if (!isset($applyData['RULE_ID']) || (int) $applyData['RULE_ID'] < 0) {
$process = false;
$result->addError(new Main\Entity\EntityError(Loc::getMessage('BX_SALE_DISCOUNT_ERR_EMPTY_RULE_ID_SALE_DISCOUNT'), self::ERROR_ID));
continue;
}
$ruleData = array('RULE_ID' => $applyData['RULE_ID'], 'APPLY' => $applyData['APPLY'], 'DESCR_ID' => isset($applyData['RULE_DESCR_ID']) ? (int) $applyData['RULE_DESCR_ID'] : 0, 'DESCR' => $applyData['DESCR_DATA']);
if ($ruleData['DESCR_ID'] <= 0) {
$ruleData['DESCR_ID'] = 0;
$ruleData['MODULE_ID'] = $this->discountsCache[$orderDiscountId]['MODULE_ID'];
$ruleData['ORDER_DISCOUNT_ID'] = $orderDiscountId;
$ruleData['ORDER_ID'] = $orderId;
}
$rulesList[] = $ruleData;
unset($ruleData);
}
unset($basketCode, $applyData);
}
if (!empty($discount['RESULT']['DELIVERY'])) {
if (!isset($discount['RESULT']['DELIVERY']['RULE_ID']) || (int) $discount['RESULT']['DELIVERY']['RULE_ID'] < 0) {
$process = false;
$result->addError(new Main\Entity\EntityError(Loc::getMessage('BX_SALE_DISCOUNT_ERR_EMPTY_RULE_ID_SALE_DISCOUNT'), self::ERROR_ID));
continue;
}
$ruleData = array('RULE_ID' => $discount['RESULT']['DELIVERY']['RULE_ID'], 'APPLY' => $discount['RESULT']['DELIVERY']['APPLY'], 'DESCR_ID' => isset($discount['RESULT']['DELIVERY']['RULE_DESCR_ID']) ? (int) $discount['RESULT']['DELIVERY']['RULE_DESCR_ID'] : 0, 'DESCR' => $discount['RESULT']['DELIVERY']['DESCR_DATA']);
if ($ruleData['DESCR_ID'] <= 0) {
$ruleData['DESCR_ID'] = 0;
$ruleData['MODULE_ID'] = $this->discountsCache[$orderDiscountId]['MODULE_ID'];
$ruleData['ORDER_DISCOUNT_ID'] = $orderDiscountId;
$ruleData['ORDER_ID'] = $orderId;
}
$rulesList[] = $ruleData;
unset($ruleData);
}
}
unset($discount);
}
if ($process && !empty($rulesList)) {
foreach ($rulesList as &$ruleRow) {
$ruleResult = Internals\OrderRulesTable::update($ruleRow['RULE_ID'], array('APPLY' => $ruleRow['APPLY']));
if ($ruleResult->isSuccess()) {
if (isset($deleteList[$ruleRow['RULE_ID']])) {
unset($deleteList[$ruleRow['RULE_ID']]);
}
if ($ruleRow['DESCR_ID'] > 0) {
$descrResult = Internals\OrderRulesDescrTable::update($ruleRow['DESCR_ID'], array('DESCR' => $ruleRow['DESCR']));
} else {
$descrData = array('DESCR' => $ruleRow['DESCR'], 'MODULE_ID' => $ruleRow['MODULE_ID'], 'ORDER_DISCOUNT_ID' => $ruleRow['ORDER_DISCOUNT_ID'], 'ORDER_ID' => $ruleRow['ORDER_ID']);
$descrResult = Internals\OrderRulesDescrTable::add($descrData);
}
if (!$descrResult->isSuccess(true)) {
$process = false;
$result->addError(new Main\Entity\EntityError(Loc::getMessage('BX_SALE_DISCOUNT_ERR_SAVE_APPLY_RULES'), self::ERROR_ID));
unset($descrResult);
break;
}
unset($descrResult);
} else {
$process = false;
$result->addError(new Main\Entity\EntityError(Loc::getMessage('BX_SALE_DISCOUNT_ERR_SAVE_APPLY_RULES'), self::ERROR_ID));
unset($ruleResult);
break;
}
unset($ruleResult);
}
unset($ruleRow);
}
if ($process && !empty($deleteList)) {
$conn = Main\Application::getConnection();
$helper = $conn->getSqlHelper();
$ruleRows = array_chunk($deleteList, 500);
$mainQuery = 'delete from ' . $helper->quote(Internals\OrderRulesTable::getTableName()) . ' where ' . $helper->quote('ID') . ' in (';
$descrQuery = 'delete from ' . $helper->quote(Internals\OrderRulesDescrTable::getTableName()) . ' where ' . $helper->quote('RULE_ID') . ' in (';
foreach ($ruleRows as &$row) {
$conn->queryExecute($mainQuery . implode(', ', $row) . ')');
$conn->queryExecute($descrQuery . implode(', ', $row) . ')');
}
unset($row, $descrQuery, $mainQuery, $ruleRows);
unset($helper, $conn);
}
unset($deleteList);
if ($process) {
if (DiscountCouponsManager::usedByManager()) {
DiscountCouponsManager::clear(true);
}
}
return $result;
}
