/**
* @param Main\Event $event
* @return Main\EventResult
*/
public static function onOrderAdd(Main\Event $event)
{
$parameters = $event->getParameters();
/** @var Sale\Order $order */
$order = $parameters[0];
$isNew = $parameters[1];
if (!$isNew) {
return new Main\EventResult(Main\EventResult::SUCCESS, null, 'sale');
}
if (!$order instanceof Sale\Order) {
return new Main\EventResult(Main\EventResult::ERROR, new Sale\ResultError(Main\Localization\Loc::getMessage('SALE_EVENT_COMPATIBILITY_ORDER_ADD_WRONG_ORDER'), 'SALE_EVENT_COMPATIBILITY_ORDER_ADD_WRONG_ORDER'), 'sale');
}
$id = $order->getId();
$fields = null;
$orderFields = null;
/** @var Sale\Result $resultOrderFields */
$resultOrderFields = OrderCompatibility::getOrderFields($order);
if ($resultOrderFields->isSuccess()) {
if ($orderFieldsResultData = $resultOrderFields->getData()) {
if (!empty($orderFieldsResultData['ORDER_FIELDS']) && is_array($orderFieldsResultData['ORDER_FIELDS'])) {
$orderFields = $orderFieldsResultData['ORDER_FIELDS'];
}
}
}
foreach (GetModuleEvents("sale", static::EVENT_COMPATIBILITY_ON_ORDER_ADD, true) as $oldEvent) {
ExecuteModuleEventEx($oldEvent, array($id, $orderFields));
}
return new Main\EventResult(Main\EventResult::SUCCESS, null, 'sale');
}
function CancelOrder($ID, $val, $description = "")
{
global $DB, $USER, $APPLICATION;
$isOrderConverted = \Bitrix\Main\Config\Option::get("main", "~sale_converted_15", 'N');
$ID = IntVal($ID);
$val = $val != "Y" ? "N" : "Y";
$description = Trim($description);
if ($ID <= 0) {
$APPLICATION->ThrowException(Loc::getMessage("SKGO_NO_ORDER_ID1"), "NO_ORDER_ID");
return false;
}
$arOrder = CSaleOrder::GetByID($ID);
if (!$arOrder) {
$APPLICATION->ThrowException(str_replace("#ID#", $ID, Loc::getMessage("SKGO_NO_ORDER")), "NO_ORDER");
return false;
}
if ($arOrder["CANCELED"] == $val) {
$APPLICATION->ThrowException(str_replace("#ID#", $ID, Loc::getMessage("SKGO_DUB_CANCEL")), "ALREADY_FLAG");
return false;
}
if ($isOrderConverted == "Y") {
$r = \Bitrix\Sale\Compatible\OrderCompatibility::cancel($ID, $val, $description);
if ($r->isSuccess(true)) {
$res = true;
} else {
$errorMessage = "";
foreach ($r->getErrorMessages() as $error) {
$errorMessage .= " " . $error;
}
$APPLICATION->ThrowException(Loc::getMessage("SKGO_CANCEL_ERROR", array("#MESSAGE#" => $errorMessage)), "CANCEL_ERROR");
return false;
}
} else {
foreach (GetModuleEvents("sale", "OnSaleBeforeCancelOrder", true) as $arEvent) {
if (ExecuteModuleEventEx($arEvent, array($ID, $val)) === false) {
return false;
}
}
if ($val == "Y") {
if ($arOrder["DEDUCTED"] == "Y") {
if (!CSaleOrder::DeductOrder($ID, "N")) {
return false;
}
}
if ($arOrder["RESERVED"] == "Y") {
if (!CSaleOrder::ReserveOrder($ID, "N")) {
return false;
}
}
if ($arOrder["PAYED"] == "Y") {
if (!CSaleOrder::PayOrder($ID, "N", True, True)) {
return False;
}
} else {
$arOrder["SUM_PAID"] = DoubleVal($arOrder["SUM_PAID"]);
if ($arOrder["SUM_PAID"] > 0) {
if (!CSaleUserAccount::UpdateAccount($arOrder["USER_ID"], $arOrder["SUM_PAID"], $arOrder["CURRENCY"], "ORDER_CANCEL_PART", $ID)) {
return False;
}
CSaleOrder::Update($arOrder["ID"], array("SUM_PAID" => 0));
}
}
if ($arOrder["ALLOW_DELIVERY"] == "Y") {
if (!CSaleOrder::DeliverOrder($ID, "N")) {
return False;
}
}
} else {
if (COption::GetOptionString("sale", "product_reserve_condition", "O") == "O" && $arOrder["RESERVED"] != "Y") {
if (!CSaleOrder::ReserveOrder($ID, "Y")) {
return false;
}
}
}
$arFields = array("CANCELED" => $val, "=DATE_CANCELED" => $DB->GetNowFunction(), "REASON_CANCELED" => strlen($description) > 0 ? $description : false, "EMP_CANCELED_ID" => IntVal($USER->GetID()) > 0 ? IntVal($USER->GetID()) : false);
$res = CSaleOrder::Update($ID, $arFields);
}
unset($GLOBALS["SALE_ORDER"]["SALE_ORDER_CACHE_" . $ID]);
if ($isOrderConverted != "Y") {
//this method is used only for catalogs without reservation and deduction support
CSaleBasket::OrderCanceled($ID, $val == "Y" ? True : False);
foreach (GetModuleEvents("sale", "OnSaleCancelOrder", true) as $arEvent) {
ExecuteModuleEventEx($arEvent, array($ID, $val, $description));
}
}
if ($val == "Y") {
CTimeZone::Disable();
$arOrder = CSaleOrder::GetByID($ID);
CTimeZone::Enable();
$userEmail = "";
$dbOrderProp = CSaleOrderPropsValue::GetList(array(), array("ORDER_ID" => $ID, "PROP_IS_EMAIL" => "Y"));
if ($arOrderProp = $dbOrderProp->Fetch()) {
$userEmail = $arOrderProp["VALUE"];
}
if (strlen($userEmail) <= 0) {
$dbUser = CUser::GetByID($arOrder["USER_ID"]);
if ($arUser = $dbUser->Fetch()) {
$userEmail = $arUser["EMAIL"];
}
}
if (CModule::IncludeModule("statistic")) {
CStatEvent::AddByEvents("eStore", "order_cancel", $ID, "", $arOrder["STAT_GID"]);
}
}
return $res;
}
/**
* @param Sale\Order $order
* @param Sale\Basket $basket
*
* @return Sale\Result
* @throws Main\ArgumentNullException
* @throws Main\ArgumentTypeException
* @throws Main\NotSupportedException
*/
protected static function appendBasketToOrder(Sale\Order $order, Sale\Basket $basket)
{
$result = new Sale\Result();
$orderBasketCollection = $order->getBasket();
$shipmentCollection = $order->getShipmentCollection();
$systemShipment = $shipmentCollection->getSystemShipment();
$systemShipmentItemCollection = $systemShipment->getShipmentItemCollection();
/** @var Sale\BasketItem $basketItem */
foreach ($basket as $basketItem) {
$basketProperty = array();
if ($basketPropertyCollection = $basketItem->getPropertyCollection()) {
$basketProperty = $basketPropertyCollection->getPropertyValues();
}
if ($orderBasketItem = $orderBasketCollection->getExistsItem($basketItem->getField('MODULE'), $basketItem->getField('PRODUCT_ID'), $basketProperty)) {
$fields = $basketItem->getFieldValues();
$orderBasketItem->setFields(static::clearFields($fields));
} else {
/** @var Sale\BasketItem $orderBasketItem */
$orderBasketCollection->addItem($basketItem);
$basketItem->setCollection($orderBasketCollection);
$systemShipmentItemCollection->resetCollection($orderBasketCollection);
}
}
/** @var Sale\BasketItem $basketItem */
foreach ($basket as $basketItem) {
if ($systemShipment->getDeliveryId() > 0) {
/** @var Sale\Shipment $shipment */
$shipment = OrderCompatibility::getShipmentByDeliveryId($shipmentCollection, $systemShipment->getDeliveryId());
if (!$shipment) {
if ($service = Sale\Delivery\Services\Manager::getService($systemShipment->getDeliveryId())) {
/** @var Sale\Shipment $shipment */
$shipment = $shipmentCollection->createItem($service);
}
}
if ($shipment) {
$shipmentItemCollection = $shipment->getShipmentItemCollection();
if (!($shipmentItem = $shipmentItemCollection->getItemByBasketCode($basketItem->getBasketCode()))) {
$shipmentItem = $shipmentItemCollection->createItem($basketItem);
}
/** @var Sale\Result $r */
$r = $shipmentItem->setQuantity($basketItem->getQuantity());
if (!$r->isSuccess()) {
$result->addErrors($r->getErrors());
}
}
}
}
return $result;
}
/**
* @param array $row
*
* @return array
*/
public function adapt(array $row)
{
$data = OrderCompatibility::convertDateFieldsToOldFormat($row);
return static::convertRowData($data);
}
/**
* @internal
* @param string $action
* @param array $fields
*
* @return Sale\Result
* @throws Main\ArgumentNullException
* @throws Main\ObjectNotFoundException
*/
public static function modifyOrder($action, array $fields)
{
$result = new Sale\Result();
try {
$adminSection = defined('ADMIN_SECTION') && ADMIN_SECTION === true;
/** @var Sale\Compatible\OrderCompatibility $orderCompatibility */
$orderCompatibility = Sale\Compatible\OrderCompatibility::create($fields);
/** @var Sale\Order $order */
$order = $orderCompatibility->getOrder();
$oldPrice = $order->getPrice();
// $isStartField = $order->isStartField();
/** @var Sale\Basket $basket */
$basket = $order->getBasket();
if (!$basket && $action == static::ORDER_COMPAT_ACTION_SAVE) {
$fUserId = null;
$userId = $order->getUserId();
if ($userId > 0) {
$fUserId = Sale\Fuser::getIdByUserId($userId);
} else {
if (!empty($fields['BASKET_ITEMS']) && is_array($fields['BASKET_ITEMS'])) {
foreach ($fields['BASKET_ITEMS'] as $basketItemData) {
if (!empty($basketItemData['FUSER_ID']) && intval($basketItemData['FUSER_ID']) > 0) {
$fUserId = intval($basketItemData['FUSER_ID']);
break;
}
}
}
}
if (intval($fUserId) <= 0 && !$adminSection) {
$fUserId = Sale\Fuser::getId();
}
if (intval($fUserId) <= 0) {
$result->addError(new Sale\ResultError(Main\Localization\Loc::getMessage('SALE_COMPATIBLE_ORDER_FUSERID_NOT_FOUND'), "SALE_COMPATIBLE_ORDER_FUSERID_NOT_FOUND"));
return $result;
}
if (!$adminSection) {
$siteId = !empty($fields["SITE_ID"]) ? $fields["SITE_ID"] : (!empty($fields["LID"]) ? $fields['LID'] : null);
/** @var Sale\Basket $allBasket */
$allBasket = Sale\Basket::loadItemsForFUser($fUserId, $siteId);
if ($allBasket) {
$basket = $allBasket->getOrderableItems();
}
}
if (!$basket) {
$basket = Sale\Basket::create($order->getSiteId());
$basket->setFUserId($fUserId);
}
}
$isStartField = $order->isStartField(true);
if ($basket) {
$basketCompatibility = BasketCompatibility::create($orderCompatibility);
// $orderCompatibility->resetOrderPrice($basket, $fields);
/** @var Sale\Result $r */
$r = $basketCompatibility->fillBasket($basket, $fields);
if (!$r->isSuccess()) {
$result->addErrors($r->getErrors());
return $result;
}
if ($action == static::ORDER_COMPAT_ACTION_SAVE && $order->getId() == 0 && count($basket) > 0) {
$order->setMathActionOnly(true);
$order->setBasket($basket);
$order->setMathActionOnly(false);
}
if ($orderCompatibility->isExistPrice() && $oldPrice == $order->getPrice()) {
$order->setFieldNoDemand('PRICE', $orderCompatibility->externalPrice);
}
}
/** @var Sale\Result $r */
$r = $orderCompatibility->fillTaxFromRequest($order->getTax(), $fields);
if (!$r->isSuccess()) {
$result->addErrors($r->getErrors());
return $result;
}
if ($isStartField) {
$hasMeaningfulFields = $order->hasMeaningfulField();
/** @var Sale\Result $r */
$r = $order->doFinalAction($hasMeaningfulFields);
if (!$r->isSuccess()) {
$result->addErrors($r->getErrors());
return $result;
}
}
/** @var Sale\Result $r */
$r = $orderCompatibility->fillShipmentCollectionFromRequest($order->getShipmentCollection(), $fields);
if (!$r->isSuccess()) {
$result->addErrors($r->getErrors());
return $result;
}
$order->setMathActionOnly(false);
/** @var Sale\Result $r */
$r = $orderCompatibility->fillPaymentCollectionFromRequest($fields);
if (!$r->isSuccess()) {
$result->addErrors($r->getErrors());
return $result;
}
/** @var Sale\Result $r */
$r = Sale\Compatible\OrderCompatibility::fillOrderFromRequest($order, $fields);
if (!$r->isSuccess()) {
$result->addErrors($r->getErrors());
return $result;
}
} catch (Sale\UserMessageException $e) {
$result->addError(new Sale\ResultError($e->getMessage(), $e->getCode()));
return $result;
}
static::transformationLocation($order);
/** @var Sale\Result $r */
$r = $order->save();
if ($r->isSuccess()) {
if ($orderData = $r->getData()) {
$result->setData($orderData);
}
if ($orderId = $r->getId()) {
$result->setId($orderId);
}
/** @var Sale\Result $r */
$r = $orderCompatibility->saveRawFields($order, static::ENTITY_ORDER);
}
if (!$r->isSuccess()) {
$result->addErrors($r->getErrors());
} else {
$oldFields = static::convertDateFieldsToOldFormat($order->getFieldValues());
$oldFields = $oldFields + $orderCompatibility->rawFields;
/** @var Sale\PaymentCollection $paymentCollection */
if ($paymentCollection = $order->getPaymentCollection()) {
/** @var Sale\Payment $payment */
foreach ($paymentCollection as $payment) {
/** @var Sale\Result $r */
$r = $orderCompatibility->saveRawFields($payment, static::ENTITY_PAYMENT);
if (!$r->isSuccess()) {
$result->addErrors($r->getErrors());
}
}
}
$result->setData(array('OLD_FIELDS' => $oldFields));
}
return $result;
}
/**
* Method is called to deduct all products of the order or undo deduction
*
* @param int $orderID
* @param bool $bUndoDeduction
* @param int $recurringID
* @param bool $bAutoDeduction
* @param array $arStoreBarcodeOrderFormData
* @return mixed array
*/
function OrderDeduction($orderID, $bUndoDeduction = false, $recurringID = 0, $bAutoDeduction = true, $arStoreBarcodeOrderFormData = array())
{
global $APPLICATION;
static $storesCount = NULL;
static $bAutoDeductionAllowed = NULL;
$bRealDeductionAllowed = true;
$defaultDeductionStore = 0;
$arSavedStoreBarcodeData = array();
$arItems = array();
$arResult = array();
$isOrderConverted = \Bitrix\Main\Config\Option::get("main", "~sale_converted_15", 'N');
if (defined("SALE_DEBUG") && SALE_DEBUG) {
CSaleHelper::WriteToLog("OrderDeduction: started", array("orderID" => $orderID, "bUndoDeduction" => intval($bUndoDeduction), "bAutoDeduction" => intval($bAutoDeduction), "arStoreBarcodeOrderFormData" => $arStoreBarcodeOrderFormData), "OD1");
}
//TODO - recurringID - ?
$orderID = IntVal($orderID);
if ($orderID <= 0) {
$arResult["RESULT"] = false;
return $arResult;
}
if ($isOrderConverted == "Y") {
$ship = !$bUndoDeduction;
/** @var \Bitrix\Sale\Result $r */
$r = \Bitrix\Sale\Compatible\OrderCompatibility::shipment($orderID, $ship, $arStoreBarcodeOrderFormData);
if (!$r->isSuccess(true)) {
foreach ($r->getErrorMessages() as $error) {
// $APPLICATION->ThrowException($error);
$arResult["ERROR"]["MESSAGE"] = $error;
// $arResult["ERROR"]["CODE"] = $ex->GetID();
break;
}
$arResult["RESULT"] = false;
return $arResult;
}
$arResult["RESULT"] = true;
return $arResult;
}
$dbBasketList = CSaleBasket::GetList(array(), array("ORDER_ID" => $orderID), false, false, array('ID', 'LID', 'PRODUCT_ID', 'PRODUCT_PROVIDER_CLASS', 'MODULE', 'BARCODE_MULTI', 'QUANTITY', 'RESERVED', 'TYPE', 'SET_PARENT_ID'));
//check basket items and emulate deduction
while ($arBasket = $dbBasketList->Fetch()) {
if (CSaleBasketHelper::isSetParent($arBasket)) {
continue;
}
if (defined("SALE_DEBUG") && SALE_DEBUG) {
CSaleHelper::WriteToLog("Deducting product #" . $arBasket["PRODUCT_ID"], array(), "OD2");
}
/** @var $productProvider IBXSaleProductProvider */
if ($productProvider = CSaleBasket::GetProductProvider($arBasket)) {
if (is_null($storesCount)) {
$storesCount = intval($productProvider::GetStoresCount(array("SITE_ID" => $arBasket["LID"])));
}
if (defined("SALE_DEBUG") && SALE_DEBUG) {
CSaleHelper::WriteToLog("stores count: " . $storesCount, array(), "OD3");
}
if (is_null($bAutoDeductionAllowed)) {
$defaultDeductionStore = COption::GetOptionString("sale", "deduct_store_id", "", $arBasket["LID"]);
if ($storesCount == 1 || $storesCount == -1 || intval($defaultDeductionStore) > 0) {
// if stores' count = 1 or stores aren't used or default deduction store is defined
$bAutoDeductionAllowed = true;
} else {
$bAutoDeductionAllowed = false;
}
}
if (defined("SALE_DEBUG") && SALE_DEBUG) {
CSaleHelper::WriteToLog("auto deduction allowed: " . intval($bAutoDeductionAllowed), array(), "OD4");
}
if ($bAutoDeduction && !$bAutoDeductionAllowed && !$bUndoDeduction) {
if (defined("SALE_DEBUG") && SALE_DEBUG) {
CSaleHelper::WriteToLog("DDCT_AUTO_DEDUCT_WRONG_STORES_QUANTITY", array(), "OD5");
}
$APPLICATION->ThrowException(Loc::getMessage("DDCT_AUTO_DEDUCT_WRONG_STORES_QUANTITY"), "DDCT_WRONG_STORES_QUANTITY");
$bRealDeductionAllowed = false;
} else {
if ($bAutoDeduction && $arBasket["BARCODE_MULTI"] == "Y" && !$bUndoDeduction) {
if (defined("SALE_DEBUG") && SALE_DEBUG) {
CSaleHelper::WriteToLog("DDCT_AUTO_DEDUCT_BARCODE_MULTI", array(), "OD6");
}
$APPLICATION->ThrowException(Loc::getMessage("DDCT_AUTO_DEDUCT_BARCODE_MULTI", array("#PRODUCT_ID#" => $arBasket["PRODUCT_ID"])), "DDCT_CANT_DEDUCT_BARCODE_MULTI");
$bRealDeductionAllowed = false;
} else {
//get saved store & barcode data if stores are used to know where to return products
if ($bUndoDeduction && $storesCount > 0) {
$dbStoreBarcode = CSaleStoreBarcode::GetList(array(), array("BASKET_ID" => $arBasket["ID"]), false, false, array("ID", "BASKET_ID", "BARCODE", "QUANTITY", "STORE_ID"));
while ($arStoreBarcode = $dbStoreBarcode->Fetch()) {
$arSavedStoreBarcodeData[$arBasket["ID"]][] = $arStoreBarcode;
}
if (defined("SALE_DEBUG") && SALE_DEBUG) {
CSaleHelper::WriteToLog("OrderDeduction: CSaleStoreBarcode data (stores) to return products to", array("arSavedStoreBarcodeData" => $arSavedStoreBarcodeData), "OD7");
}
}
$arFields = array("PRODUCT_ID" => $arBasket["PRODUCT_ID"], "EMULATE" => "Y", "PRODUCT_RESERVED" => $arBasket["RESERVED"], "UNDO_DEDUCTION" => $bUndoDeduction ? "Y" : "N");
if ($bUndoDeduction) {
if ($storesCount > 0) {
$arFields["QUANTITY"] = 0;
//won't be used during deduction
$arFields["STORE_DATA"] = $arSavedStoreBarcodeData[$arBasket["ID"]];
} else {
$arFields["QUANTITY"] = $arBasket["QUANTITY"];
$arFields["STORE_DATA"] = array();
}
} else {
if ($storesCount == 1) {
$arFields["QUANTITY"] = 0;
if ($bAutoDeduction) {
if ($arProductStore = $productProvider::GetProductStores(array("PRODUCT_ID" => $arBasket["PRODUCT_ID"], "SITE_ID" => $arBasket["LID"], 'BASKET_ID' => $arBasket['ID']))) {
$arFields["STORE_DATA"] = array("0" => array("STORE_ID" => $arProductStore[0]["STORE_ID"], "QUANTITY" => $arBasket["QUANTITY"], "AMOUNT" => $arProductStore[0]["AMOUNT"]));
} else {
$arFields["STORE_DATA"] = array();
}
} else {
$arFields["STORE_DATA"] = $arStoreBarcodeOrderFormData[$arBasket["ID"]];
}
} else {
if (intval($defaultDeductionStore) > 0) {
$arFields["QUANTITY"] = 0;
if ($bAutoDeduction) {
if ($arProductStore = $productProvider::GetProductStores(array("PRODUCT_ID" => $arBasket["PRODUCT_ID"], "SITE_ID" => $arBasket["LID"], 'BASKET_ID' => $arBasket['ID']))) {
foreach ($arProductStore as $storeData) {
if ($storeData["STORE_ID"] == intval($defaultDeductionStore)) {
$arFields["STORE_DATA"] = array("0" => array("STORE_ID" => $storeData["STORE_ID"], "QUANTITY" => $arBasket["QUANTITY"], "AMOUNT" => $storeData["AMOUNT"]));
break;
}
}
} else {
$arFields["STORE_DATA"] = array();
}
} else {
$arFields["STORE_DATA"] = $arStoreBarcodeOrderFormData[$arBasket["ID"]];
}
} else {
if ($storesCount > 1) {
$arFields["QUANTITY"] = 0;
//won't be used during deduction
$arFields["STORE_DATA"] = $arStoreBarcodeOrderFormData[$arBasket["ID"]];
} else {
$arFields["QUANTITY"] = $arBasket["QUANTITY"];
$arFields["STORE_DATA"] = array();
}
}
}
}
if (defined("SALE_DEBUG") && SALE_DEBUG) {
CSaleHelper::WriteToLog("Emulating ::DeductProduct call", array("arFields" => $arFields), "OD7");
}
$eventParams = array('ORDER_ID' => $orderID, 'RECURRING_ID' => $recurringID, 'AUTO_DEDUCTION' => $bAutoDeduction, 'STORE_DATA' => $arStoreBarcodeOrderFormData);
foreach (GetModuleEvents('sale', 'OnBeforeBasketDeductProduct', true) as $event) {
if (ExecuteModuleEventEx($event, array($eventParams, $arBasket, &$arFields)) === false) {
if (defined("SALE_DEBUG") && SALE_DEBUG) {
CSaleHelper::WriteToLog("Emulating ::DeductProduct call - error", array(), "OD7-1");
}
$arResult["RESULT"] = false;
return $arResult;
}
}
unset($eventParams);
//emulate deduction
$res = $productProvider::DeductProduct($arFields);
if ($res["RESULT"]) {
$arBasket["FIELDS"] = $arFields;
$arItems[] = $arBasket;
if (defined("SALE_DEBUG") && SALE_DEBUG) {
CSaleHelper::WriteToLog("Emulating ::DeductProduct call - success", array(), "OD8");
}
} else {
$bRealDeductionAllowed = false;
if (defined("SALE_DEBUG") && SALE_DEBUG) {
CSaleHelper::WriteToLog("Emulating ::DeductProduct call - error", array(), "OD9");
}
}
}
}
if ($ex = $APPLICATION->GetException()) {
$arResult["ERROR"]["MESSAGE"] = $ex->GetString();
$arResult["ERROR"]["CODE"] = $ex->GetID();
}
if (!$bRealDeductionAllowed) {
break;
}
}
}
// real deduction
if ($bRealDeductionAllowed) {
$bProductsDeductedSuccessfully = true;
$arDeductedItems = array();
foreach ($arItems as $arItem) {
/** @var $productProvider IBXSaleProductProvider */
if ($productProvider = CSaleBasket::GetProductProvider($arItem)) {
$arItem["FIELDS"]["EMULATE"] = "N";
if (defined("SALE_DEBUG") && SALE_DEBUG) {
CSaleHelper::WriteToLog("Call ::DeductProduct", array("fields" => $arItem["FIELDS"]), "OD10");
}
// finally real deduction
$res = $productProvider::DeductProduct($arItem["FIELDS"]);
if ($res["RESULT"]) {
$arDeductedItems[] = $arItem;
if (!$bUndoDeduction && $storesCount > 0) {
if ($bAutoDeduction) {
$arStoreBarcodeFields = array("BASKET_ID" => $arItem["ID"], "BARCODE" => "", "STORE_ID" => array_pop(array_keys($res["STORES"])), "QUANTITY" => $arItem["QUANTITY"], "CREATED_BY" => intval($GLOBALS["USER"]->GetID()) > 0 ? IntVal($GLOBALS["USER"]->GetID()) : "", "MODIFIED_BY" => intval($GLOBALS["USER"]->GetID()) > 0 ? IntVal($GLOBALS["USER"]->GetID()) : "");
if (defined("SALE_DEBUG") && SALE_DEBUG) {
CSaleHelper::WriteToLog("Call CSaleStoreBarcode::Add (auto deduction = true)", array("arStoreBarcodeFields" => $arStoreBarcodeFields), "OD11");
}
CSaleStoreBarcode::Add($arStoreBarcodeFields);
}
}
if ($bUndoDeduction) {
$dbStoreBarcode = CSaleStoreBarcode::GetList(array(), array("BASKET_ID" => $arItem["ID"]), false, false, array("ID", "BASKET_ID"));
while ($arStoreBarcode = $dbStoreBarcode->GetNext()) {
CSaleStoreBarcode::Delete($arStoreBarcode["ID"]);
}
}
$tmpRes = $bUndoDeduction ? "N" : "Y";
CSaleBasket::Update($arItem["ID"], array("DEDUCTED" => $tmpRes));
// set parent deducted status
if ($bUndoDeduction) {
if (CSaleBasketHelper::isSetItem($arItem)) {
CSaleBasket::Update($arItem["SET_PARENT_ID"], array("DEDUCTED" => "N"));
}
} else {
if (CSaleBasketHelper::isSetItem($arItem) && CSaleBasketHelper::isSetDeducted($arItem["SET_PARENT_ID"])) {
CSaleBasket::Update($arItem["SET_PARENT_ID"], array("DEDUCTED" => "Y"));
}
}
if (defined("SALE_DEBUG") && SALE_DEBUG) {
CSaleHelper::WriteToLog("Call ::DeductProduct - Success (DEDUCTED = " . $tmpRes . ")", array(), "OD11");
}
} else {
CSaleBasket::Update($arItem["ID"], array("DEDUCTED" => "N"));
$bProductsDeductedSuccessfully = false;
if ($ex = $APPLICATION->GetException()) {
$arResult["ERROR"]["MESSAGE"] = $ex->GetString();
$arResult["ERROR"]["CODE"] = $ex->GetID();
}
if (defined("SALE_DEBUG") && SALE_DEBUG) {
CSaleHelper::WriteToLog("Call ::DeductProduct - Error (DEDUCTED = N)", array(), "OD12");
}
break;
}
}
}
if ($bProductsDeductedSuccessfully) {
$arResult["RESULT"] = true;
} else {
$arFields = array();
foreach ($arDeductedItems as $arItem) {
/** @var $productProvider IBXSaleProductProvider */
if ($productProvider = CSaleBasket::GetProductProvider($arItem)) {
if ($storesCount > 0) {
$arFields = array("PRODUCT_ID" => $arItem["PRODUCT_ID"], "QUANTITY" => $arItem["QUANTITY"], "UNDO_DEDUCTION" => "Y", "EMULATE" => "N", "PRODUCT_RESERVED" => $arItem["FIELDS"]["PRODUCT_RESERVED"], "STORE_DATA" => $arItem["FIELDS"]["STORE_DATA"]);
} else {
$arFields = array("PRODUCT_ID" => $arItem["PRODUCT_ID"], "QUANTITY" => $arItem["QUANTITY"], "UNDO_DEDUCTION" => "Y", "PRODUCT_RESERVED" => $arItem["FIELDS"]["PRODUCT_RESERVED"], "EMULATE" => "N");
}
if (defined("SALE_DEBUG") && SALE_DEBUG) {
CSaleHelper::WriteToLog("Call ::DeductProduct - Revert deduction", array("storesCount" => $storesCount, "arFields" => $arFields), "OD13");
}
$res = $productProvider::DeductProduct($arFields);
if ($res["RESULT"]) {
CSaleBasket::Update($arItem["ID"], array("DEDUCTED" => "N"));
if (CSaleBasketHelper::isSetItem($arItem)) {
// todo - possibly not all the time, but once
CSaleBasket::Update($arItem["SET_PARENT_ID"], array("DEDUCTED" => "N"));
}
}
}
}
$arResult["RESULT"] = false;
}
} else {
$arResult["RESULT"] = false;
}
if (defined("SALE_DEBUG") && SALE_DEBUG) {
CSaleHelper::WriteToLog("OrderDeduction - result", array("arResult" => $arResult), "OD14");
}
return $arResult;
}
public static function execOldEventWithNewParams(Bitrix\Main\Event $params)
{
/** @var \Bitrix\Sale\Shipment $shipment*/
if (!($shipment = $params->getParameter("SHIPMENT"))) {
return new \Bitrix\Main\EventResult(\Bitrix\Main\EventResult::ERROR, null, 'sale');
}
/** @var \Bitrix\Sale\Delivery\Services\Base $deliverySrv */
if (!($deliverySrv = $shipment->getDelivery())) {
return new \Bitrix\Main\EventResult(\Bitrix\Main\EventResult::ERROR, null, 'sale');
}
if (get_class($deliverySrv) != 'Bitrix\\Sale\\Delivery\\Services\\AutomaticProfile') {
return new \Bitrix\Main\EventResult(\Bitrix\Main\EventResult::ERROR, null, 'sale');
}
if (!($code = $deliverySrv->getCode())) {
return new \Bitrix\Main\EventResult(\Bitrix\Main\EventResult::ERROR, null, 'sale');
}
$sidAndProfile = \CSaleDeliveryHelper::getDeliverySIDAndProfile($code);
/** @var \Bitrix\Sale\Delivery\CalculationResult $result*/
if (!($result = $params->getParameter("RESULT"))) {
throw new \Bitrix\Main\ArgumentNullException("params[RESULT]");
}
if (!($collection = $shipment->getCollection())) {
return new \Bitrix\Main\EventResult(\Bitrix\Main\EventResult::ERROR, null, 'sale');
}
/** @var \Bitrix\Sale\Order $order */
if (!($order = $collection->getOrder())) {
return new \Bitrix\Main\EventResult(\Bitrix\Main\EventResult::ERROR, null, 'sale');
}
$oldOrder = \Bitrix\Sale\Compatible\OrderCompatibility::convertOrderToArray($order);
$oldResult = array("VALUE" => $result->getPrice(), "TRANSIT" => $result->getPeriodDescription(), "TEXT" => $result->isSuccess() ? $result->getDescription() : implode("<br>\n", $result->getErrorMessages()), "RESULT" => $result->isSuccess() ? "OK" : "ERROR");
if ($result->isNextStep()) {
$oldResult["RESULT"] = "NEXT_STEP";
}
if ($result->isSuccess() && strlen($result->getDescription()) > 0) {
$oldResult["RESULT"] = "NOTE";
}
if (intval($result->getPacksCount()) > 0) {
$oldResult["PACKS_COUNT"] = $result->getPacksCount();
}
if ($result->isNextStep() && strlen($result->getTmpData()) > 0) {
$oldResult["TEMP"] = CUtil::JSEscape($result->getTmpData());
}
$oldResult = self::__executeCalculateEvents($sidAndProfile["SID"], $sidAndProfile["PROFILE"], $oldOrder, $oldResult);
$result->setDeliveryPrice($oldResult["VALUE"]);
if ($oldResult["RESULT"] == "ERROR") {
$result->addError(new \Bitrix\Main\Entity\EntityError($oldResult["TEXT"]));
} elseif ($oldResult["RESULT"] == "NEXT_STEP") {
$result->setAsNextStep();
}
if (isset($oldResult["TRANSIT"])) {
$result->setPeriodDescription($oldResult["TRANSIT"]);
}
if (isset($oldResult["TEXT"])) {
$result->setDescription($oldResult["TEXT"]);
}
if (isset($oldResult["PACKS_COUNT"])) {
$result->setPacksCount($oldResult["PACKS_COUNT"]);
}
if (isset($oldResult["TEMP"])) {
$result->setTmpData($oldResult["TEMP"]);
}
return $result;
}
/**
* @param Main\Event $event
*
* @return Main\EventResult
* @throws Main\ObjectNotFoundException
*/
public static function onSaleOrderStatusChangeSendEmail(Main\Event $event)
{
$parameters = $event->getParameters();
/** @var Sale\Order $basketItem */
$order = $parameters['ENTITY'];
$value = $parameters['VALUE'];
$oldValue = $parameters['OLD_VALUE'];
if (!$order instanceof Sale\Order) {
return new Main\EventResult(Main\EventResult::ERROR, new Sale\ResultError(Main\Localization\Loc::getMessage('SALE_EVENT_COMPATIBILITY_ORDER_STATUS_CHANGE_WRONG_ORDER'), 'SALE_EVENT_COMPATIBILITY_ORDER_STATUS_CHANGE_WRONG_ORDER'), 'sale');
}
$orderFields = array();
/** @var Sale\Result $resultOrderFields */
$resultOrderFields = OrderCompatibility::getOrderFields($order);
if ($resultOrderFields->isSuccess()) {
if ($orderFieldsResultData = $resultOrderFields->getData()) {
if (!empty($orderFieldsResultData['ORDER_FIELDS']) && is_array($orderFieldsResultData['ORDER_FIELDS'])) {
$orderFields = $orderFieldsResultData['ORDER_FIELDS'];
}
}
}
\CSaleMobileOrderPush::send(static::EVENT_COMPATIBILITY_MOBILE_PUSH_ORDER_STATUS_CHANGE, array("ORDER" => $orderFields));
$propertyCollection = $order->getPropertyCollection();
$userEmail = "";
/** @var Sale\PropertyValue $userEmailProperty */
if ($userEmailProperty = $propertyCollection->getUserEmail()) {
$userEmail = $userEmailProperty->getValue();
}
if (strval(trim($userEmail)) == '') {
$userRes = \CUser::GetByID($order->getUserId());
if ($userData = $userRes->fetch()) {
$userEmail = $userData["EMAIL"];
}
}
static $cacheSiteData = array();
if (!isset($cacheSiteData[$order->getSiteId()])) {
$siteRes = \CSite::GetByID($order->getSiteId());
$siteData = $siteRes->Fetch();
} else {
$siteData = $cacheSiteData[$order->getSiteId()];
}
if (($statusData = \CSaleStatus::GetByID($order->getField("STATUS_ID"), $siteData['LANGUAGE_ID'])) && $statusData['NOTIFY'] == "Y") {
$fields = array("ORDER_ID" => $order->getField("ACCOUNT_NUMBER"), "ORDER_DATE" => $order->getField("DATE_INSERT")->toString(), "ORDER_STATUS" => $statusData["NAME"], "EMAIL" => $userEmail, "ORDER_DESCRIPTION" => $statusData["DESCRIPTION"], "TEXT" => "", "SALE_EMAIL" => Main\Config\Option::get("sale", "order_email", "order@" . $_SERVER["SERVER_NAME"]));
foreach (GetModuleEvents("sale", static::EVENT_COMPATIBILITY_ORDER_STATUS_EMAIL, true) as $oldEvent) {
$fields["TEXT"] = ExecuteModuleEventEx($oldEvent, array($order->getId(), $statusData["ID"]));
}
$eventName = "SALE_STATUS_CHANGED_" . $order->getField("STATUS_ID");
$isSend = true;
foreach (GetModuleEvents("sale", static::EVENT_COMPATIBILITY_ORDER_STATUS_SEND_EMAIL, true) as $oldEvent) {
if (ExecuteModuleEventEx($oldEvent, array($order->getId(), &$eventName, &$fields, $order->getField("STATUS_ID"))) === false) {
$isSend = false;
}
}
if ($isSend) {
$b = '';
$o = '';
$eventMessage = new \CEventMessage();
$eventMessageRes = $eventMessage->GetList($b, $o, array("EVENT_NAME" => $eventName, "SITE_ID" => $order->getSiteId(), 'ACTIVE' => 'Y'));
if (!($eventMessageData = $eventMessageRes->Fetch())) {
$eventName = "SALE_STATUS_CHANGED";
}
unset($o, $b);
$event = new \CEvent();
$event->Send($eventName, $order->getSiteId(), $fields, "N");
}
}
return new Main\EventResult(Main\EventResult::SUCCESS, null, 'sale');
}
/**
* @internal
* @param string $action
* @param array $fields
*
* @return Sale\Result
* @throws Main\ArgumentNullException
* @throws Main\ObjectNotFoundException
*/
public static function modifyOrder($action, array $fields)
{
$result = new Sale\Result();
try {
$adminSection = defined('ADMIN_SECTION') && ADMIN_SECTION === true;
/** @var Sale\Compatible\OrderCompatibility $orderCompatibility */
$orderCompatibility = Sale\Compatible\OrderCompatibility::create($fields);
/** @var Sale\Order $order */
$order = $orderCompatibility->getOrder();
$oldPrice = $order->getPrice();
// $isStartField = $order->isStartField();
/** @var Sale\Basket $basket */
$basket = $order->getBasket();
if (!$basket && $action == static::ORDER_COMPAT_ACTION_SAVE) {
$fUserId = Sale\Fuser::getIdByUserId($order->getUserId());
if (!$adminSection) {
$siteId = !empty($fields["SITE_ID"]) ? $fields["SITE_ID"] : (!empty($fields["LID"]) ? $fields['LID'] : null);
$basket = Sale\Basket::loadItemsForFUser($fUserId, $siteId);
}
if (!$basket) {
$basket = Sale\Basket::create($order->getSiteId(), $fUserId);
}
}
if ($basket) {
$basketCompatibility = BasketCompatibility::create($orderCompatibility);
// $orderCompatibility->resetOrderPrice($basket, $fields);
/** @var Sale\Result $r */
$r = $basketCompatibility->fillBasket($basket, $fields);
if (!$r->isSuccess()) {
$result->addErrors($r->getErrors());
return $result;
}
if ($action == static::ORDER_COMPAT_ACTION_SAVE && $order->getId() == 0 && count($basket->getOrderableItems()) > 0) {
$order->setMathActionOnly(true);
$order->setBasket($basket->getOrderableItems());
$order->setMathActionOnly(false);
}
if ($orderCompatibility->isExistPrice() && $oldPrice == $order->getPrice()) {
$order->setFieldNoDemand('PRICE', $orderCompatibility->externalPrice);
}
}
/** @var Sale\Result $r */
$r = Sale\Compatible\OrderCompatibility::fillTaxFromRequest($order->getTax(), $fields);
if (!$r->isSuccess()) {
$result->addErrors($r->getErrors());
return $result;
}
/** @var Sale\Result $r */
$r = OrderCompatibility::fillShipmentCollectionFromRequest($order->getShipmentCollection(), $fields);
if (!$r->isSuccess()) {
$result->addErrors($r->getErrors());
return $result;
}
$order->setMathActionOnly(false);
/** @var Sale\Result $r */
$r = Sale\Compatible\OrderCompatibility::fillPaymentCollectionFromRequest($order->getPaymentCollection(), $fields);
if (!$r->isSuccess()) {
$result->addErrors($r->getErrors());
return $result;
}
/** @var Sale\Result $r */
$r = Sale\Compatible\OrderCompatibility::fillOrderFromRequest($order, $fields);
if (!$r->isSuccess()) {
$result->addErrors($r->getErrors());
return $result;
}
} catch (Sale\UserMessageException $e) {
$result->addError(new Sale\ResultError($e->getMessage(), $e->getCode()));
return $result;
}
static::transformationLocation($order);
/** @var Sale\Result $r */
$r = $order->save();
if ($r->isSuccess()) {
if ($orderData = $r->getData()) {
$result->setData($orderData);
}
if ($orderId = $r->getId()) {
$result->setId($orderId);
}
/** @var Sale\Result $r */
$r = $orderCompatibility->saveRawFields();
}
if (!$r->isSuccess()) {
$result->addErrors($r->getErrors());
} else {
$oldFields = static::convertDateFieldsToOldFormat($order->getFieldValues());
$oldFields = $oldFields + $orderCompatibility->rawFields;
$result->setData(array('OLD_FIELDS' => $oldFields));
}
return $result;
}
public static function adapt(array $row)
{
$data = OrderCompatibility::convertDateFieldsToOldFormat($row);
if (isset($data['DELIVERY_ID']) && intval($data['DELIVERY_ID']) > 0) {
$data['DELIVERY_ID'] = \Bitrix\Sale\Delivery\Services\Table::getCodeById($data['DELIVERY_ID']);
}
return $data;
}
function GetList($arOrder = array("ID" => "DESC"), $arFilter = array(), $arGroupBy = false, $arNavStartParams = false, $arSelectFields = array(), $arOptions = array())
{
global $DB, $USER_FIELD_MANAGER;
if (!is_array($arOrder)) {
$arOrder = array('ID' => 'DESC');
}
if (!is_array($arFilter)) {
$arFilter = array();
}
if (!is_array($arSelectFields)) {
$arSelectFields = array();
}
$isOrderConverted = \Bitrix\Main\Config\Option::get("main", "~sale_converted_15", 'N');
$obUserFieldsSql = new CUserTypeSQL();
$obUserFieldsSql->SetEntity("ORDER", "O.ID");
$obUserFieldsSql->SetSelect($arSelectFields);
$obUserFieldsSql->SetFilter($arFilter);
$obUserFieldsSql->SetOrder($arOrder);
if (array_key_exists("DATE_FROM", $arFilter)) {
$val = $arFilter["DATE_FROM"];
unset($arFilter["DATE_FROM"]);
$arFilter[">=DATE_INSERT"] = $val;
}
if (array_key_exists("DATE_TO", $arFilter)) {
$val = $arFilter["DATE_TO"];
unset($arFilter["DATE_TO"]);
$arFilter["<=DATE_INSERT"] = $val;
}
if (array_key_exists("DATE_INSERT_FROM", $arFilter)) {
$val = $arFilter["DATE_INSERT_FROM"];
unset($arFilter["DATE_INSERT_FROM"]);
$arFilter[">=DATE_INSERT"] = $val;
}
if (array_key_exists("DATE_INSERT_TO", $arFilter)) {
$val = $arFilter["DATE_INSERT_TO"];
unset($arFilter["DATE_INSERT_TO"]);
$arFilter["<=DATE_INSERT"] = $val;
}
if (array_key_exists("DATE_UPDATE_FROM", $arFilter)) {
$val = $arFilter["DATE_UPDATE_FROM"];
unset($arFilter["DATE_UPDATE_FROM"]);
$arFilter[">=DATE_UPDATE"] = $val;
}
if (array_key_exists("DATE_UPDATE_TO", $arFilter)) {
$val = $arFilter["DATE_UPDATE_TO"];
unset($arFilter["DATE_UPDATE_TO"]);
$arFilter["<=DATE_UPDATE"] = $val;
}
if (array_key_exists("DATE_STATUS_FROM", $arFilter)) {
$val = $arFilter["DATE_STATUS_FROM"];
unset($arFilter["DATE_STATUS_FROM"]);
$arFilter[">=DATE_STATUS"] = $val;
}
if (array_key_exists("DATE_STATUS_TO", $arFilter)) {
$val = $arFilter["DATE_STATUS_TO"];
unset($arFilter["DATE_STATUS_TO"]);
$arFilter["<=DATE_STATUS"] = $val;
}
if (array_key_exists("DATE_PAYED_FROM", $arFilter)) {
$val = $arFilter["DATE_PAYED_FROM"];
unset($arFilter["DATE_PAYED_FROM"]);
$arFilter[">=DATE_PAYED"] = $val;
}
if (array_key_exists("DATE_PAYED_TO", $arFilter)) {
$val = $arFilter["DATE_PAYED_TO"];
unset($arFilter["DATE_PAYED_TO"]);
$arFilter["<=DATE_PAYED"] = $val;
}
if (array_key_exists("DATE_ALLOW_DELIVERY_FROM", $arFilter)) {
$val = $arFilter["DATE_ALLOW_DELIVERY_FROM"];
unset($arFilter["DATE_ALLOW_DELIVERY_FROM"]);
$arFilter[">=DATE_ALLOW_DELIVERY"] = $val;
}
if (array_key_exists("DATE_ALLOW_DELIVERY_TO", $arFilter)) {
$val = $arFilter["DATE_ALLOW_DELIVERY_TO"];
unset($arFilter["DATE_ALLOW_DELIVERY_TO"]);
$arFilter["<=DATE_ALLOW_DELIVERY"] = $val;
}
if (array_key_exists("DATE_CANCELED_FROM", $arFilter)) {
$val = $arFilter["DATE_CANCELED_FROM"];
unset($arFilter["DATE_CANCELED_FROM"]);
$arFilter[">=DATE_CANCELED"] = $val;
}
if (array_key_exists("DATE_CANCELED_TO", $arFilter)) {
$val = $arFilter["DATE_CANCELED_TO"];
unset($arFilter["DATE_CANCELED_TO"]);
$arFilter["<=DATE_CANCELED"] = $val;
}
if (array_key_exists("DATE_DEDUCTED_FROM", $arFilter)) {
$val = $arFilter["DATE_DEDUCTED_FROM"];
unset($arFilter["DATE_DEDUCTED_FROM"]);
$arFilter[">=DATE_DEDUCTED"] = $val;
}
if (array_key_exists("DATE_DEDUCTED_TO", $arFilter)) {
$val = $arFilter["DATE_DEDUCTED_TO"];
unset($arFilter["DATE_DEDUCTED_TO"]);
$arFilter["<=DATE_DEDUCTED"] = $val;
}
if (array_key_exists("DATE_MARKED_FROM", $arFilter)) {
$val = $arFilter["DATE_MARKED_FROM"];
unset($arFilter["DATE_MARKED_FROM"]);
$arFilter[">=DATE_MARKED"] = $val;
}
if (array_key_exists("DATE_MARKED_TO", $arFilter)) {
$val = $arFilter["DATE_MARKED_TO"];
unset($arFilter["DATE_MARKED_TO"]);
$arFilter["<=DATE_MARKED"] = $val;
}
if (array_key_exists("DATE_PAY_BEFORE_FROM", $arFilter)) {
$val = $arFilter["DATE_PAY_BEFORE_FROM"];
unset($arFilter["DATE_PAY_BEFORE_FROM"]);
$arFilter[">=DATE_PAY_BEFORE"] = $val;
}
if (array_key_exists("DATE_PAY_BEFORE_TO", $arFilter)) {
$val = $arFilter["DATE_PAY_BEFORE_TO"];
unset($arFilter["DATE_PAY_BEFORE_TO"]);
$arFilter["<=DATE_PAY_BEFORE"] = $val;
}
if (array_key_exists("DELIVERY_REQUEST_SENT", $arFilter)) {
if ($arFilter["DELIVERY_REQUEST_SENT"] == "Y") {
$arFilter["!DELIVERY_DATE_REQUEST"] = "";
} else {
$arFilter["+DELIVERY_DATE_REQUEST"] = "";
}
unset($arFilter["DELIVERY_REQUEST_SENT"]);
}
$callback = false;
if (array_key_exists("CUSTOM_SUBQUERY", $arFilter)) {
$callback = $arFilter["CUSTOM_SUBQUERY"];
unset($arFilter["CUSTOM_SUBQUERY"]);
}
if ($isOrderConverted == "Y") {
$result = \Bitrix\Sale\Compatible\OrderCompatibility::getList($arOrder, $arFilter, $arGroupBy, $arNavStartParams, $arSelectFields, $callback);
if ($result instanceof \Bitrix\Sale\Compatible\CDBResult) {
$result->addFetchAdapter(new \Bitrix\Sale\Compatible\OrderFetchAdapter());
}
return $result;
}
if (empty($arSelectFields)) {
$arSelectFields = array("ID", "LID", "PERSON_TYPE_ID", "PAYED", "DATE_PAYED", "EMP_PAYED_ID", "CANCELED", "DATE_CANCELED", "EMP_CANCELED_ID", "REASON_CANCELED", "MARKED", "DATE_MARKED", "EMP_MARKED_ID", "REASON_MARKED", "STATUS_ID", "DATE_STATUS", "PAY_VOUCHER_NUM", "PAY_VOUCHER_DATE", "EMP_STATUS_ID", "PRICE_DELIVERY", "ALLOW_DELIVERY", "DATE_ALLOW_DELIVERY", "EMP_ALLOW_DELIVERY_ID", "DEDUCTED", "DATE_DEDUCTED", "EMP_DEDUCTED_ID", "REASON_UNDO_DEDUCTED", "RESERVED", "PRICE", "CURRENCY", "DISCOUNT_VALUE", "SUM_PAID", "USER_ID", "PAY_SYSTEM_ID", "DELIVERY_ID", "DATE_INSERT", "DATE_INSERT_FORMAT", "DATE_UPDATE", "USER_DESCRIPTION", "ADDITIONAL_INFO", "PS_STATUS", "PS_STATUS_CODE", "PS_STATUS_DESCRIPTION", "PS_STATUS_MESSAGE", "PS_SUM", "PS_CURRENCY", "PS_RESPONSE_DATE", "COMMENTS", "TAX_VALUE", "STAT_GID", "RECURRING_ID", "RECOUNT_FLAG", "USER_LOGIN", "USER_NAME", "USER_LAST_NAME", "USER_EMAIL", "DELIVERY_DOC_NUM", "DELIVERY_DOC_DATE", "DELIVERY_DATE_REQUEST", "STORE_ID", "ORDER_TOPIC", "RESPONSIBLE_ID", "RESPONSIBLE_LOGIN", "RESPONSIBLE_NAME", "RESPONSIBLE_LAST_NAME", "RESPONSIBLE_SECOND_NAME", "RESPONSIBLE_EMAIL", "RESPONSIBLE_WORK_POSITION", "RESPONSIBLE_PERSONAL_PHOTO", "RESPONSIBLE_GROUP_ID", "DATE_PAY_BEFORE", "DATE_BILL", "ACCOUNT_NUMBER", "TRACKING_NUMBER", "XML_ID");
} elseif (in_array("*", $arSelectFields)) {
$arSelectFields = array("ID", "LID", "PERSON_TYPE_ID", "PAYED", "DATE_PAYED", "EMP_PAYED_ID", "CANCELED", "DATE_CANCELED", "EMP_CANCELED_ID", "REASON_CANCELED", "MARKED", "DATE_MARKED", "EMP_MARKED_ID", "REASON_MARKED", "STATUS_ID", "DATE_STATUS", "PAY_VOUCHER_NUM", "PAY_VOUCHER_DATE", "EMP_STATUS_ID", "PRICE_DELIVERY", "ALLOW_DELIVERY", "DATE_ALLOW_DELIVERY", "EMP_ALLOW_DELIVERY_ID", "DEDUCTED", "DATE_DEDUCTED", "EMP_DEDUCTED_ID", "REASON_UNDO_DEDUCTED", "RESERVED", "PRICE", "CURRENCY", "DISCOUNT_VALUE", "SUM_PAID", "USER_ID", "PAY_SYSTEM_ID", "DELIVERY_ID", "DATE_INSERT", "DATE_INSERT_FORMAT", "DATE_UPDATE", "USER_DESCRIPTION", "ADDITIONAL_INFO", "PS_STATUS", "PS_STATUS_CODE", "PS_STATUS_DESCRIPTION", "PS_STATUS_MESSAGE", "PS_SUM", "PS_CURRENCY", "PS_RESPONSE_DATE", "COMMENTS", "TAX_VALUE", "STAT_GID", "RECURRING_ID", "RECOUNT_FLAG", "USER_LOGIN", "USER_NAME", "USER_LAST_NAME", "USER_EMAIL", "DELIVERY_DOC_NUM", "DELIVERY_DOC_DATE", "DELIVERY_DATE_REQUEST", "STORE_ID", "ORDER_TOPIC", "RESPONSIBLE_ID", "RESPONSIBLE_LOGIN", "RESPONSIBLE_NAME", "RESPONSIBLE_LAST_NAME", "RESPONSIBLE_SECOND_NAME", "RESPONSIBLE_EMAIL", "RESPONSIBLE_WORK_POSITION", "RESPONSIBLE_PERSONAL_PHOTO", "RESPONSIBLE_GROUP_ID", "DATE_PAY_BEFORE", "DATE_BILL", "ACCOUNT_NUMBER", "TRACKING_NUMBER", "XML_ID");
}
$maxLock = IntVal(COption::GetOptionString("sale", "MAX_LOCK_TIME", "60"));
if (is_object($GLOBALS["USER"])) {
$userID = IntVal($GLOBALS["USER"]->GetID());
} else {
$userID = 0;
}
// FIELDS -->
$arFields = array("ID" => array("FIELD" => "O.ID", "TYPE" => "int"), "LID" => array("FIELD" => "O.LID", "TYPE" => "string"), "PERSON_TYPE_ID" => array("FIELD" => "O.PERSON_TYPE_ID", "TYPE" => "int"), "PAYED" => array("FIELD" => "O.PAYED", "TYPE" => "char"), "DATE_PAYED" => array("FIELD" => "O.DATE_PAYED", "TYPE" => "datetime"), "EMP_PAYED_ID" => array("FIELD" => "O.EMP_PAYED_ID", "TYPE" => "int"), "CANCELED" => array("FIELD" => "O.CANCELED", "TYPE" => "char"), "DATE_CANCELED" => array("FIELD" => "O.DATE_CANCELED", "TYPE" => "datetime"), "EMP_CANCELED_ID" => array("FIELD" => "O.EMP_CANCELED_ID", "TYPE" => "int"), "REASON_CANCELED" => array("FIELD" => "O.REASON_CANCELED", "TYPE" => "string"), "STATUS_ID" => array("FIELD" => "O.STATUS_ID", "TYPE" => "string"), "DATE_STATUS" => array("FIELD" => "O.DATE_STATUS", "TYPE" => "datetime"), "PAY_VOUCHER_NUM" => array("FIELD" => "O.PAY_VOUCHER_NUM", "TYPE" => "string"), "PAY_VOUCHER_DATE" => array("FIELD" => "O.PAY_VOUCHER_DATE", "TYPE" => "date"), "EMP_STATUS_ID" => array("FIELD" => "O.EMP_STATUS_ID", "TYPE" => "int"), "PRICE_DELIVERY" => array("FIELD" => "O.PRICE_DELIVERY", "TYPE" => "double"), "ALLOW_DELIVERY" => array("FIELD" => "O.ALLOW_DELIVERY", "TYPE" => "char"), "DATE_ALLOW_DELIVERY" => array("FIELD" => "O.DATE_ALLOW_DELIVERY", "TYPE" => "datetime"), "EMP_ALLOW_DELIVERY_ID" => array("FIELD" => "O.EMP_ALLOW_DELIVERY_ID", "TYPE" => "int"), "DEDUCTED" => array("FIELD" => "O.DEDUCTED", "TYPE" => "char"), "DATE_DEDUCTED" => array("FIELD" => "O.DATE_DEDUCTED", "TYPE" => "datetime"), "EMP_DEDUCTED_ID" => array("FIELD" => "O.EMP_DEDUCTED_ID", "TYPE" => "int"), "REASON_UNDO_DEDUCTED" => array("FIELD" => "O.REASON_UNDO_DEDUCTED", "TYPE" => "string"), "RESERVED" => array("FIELD" => "O.RESERVED", "TYPE" => "char"), "MARKED" => array("FIELD" => "O.MARKED", "TYPE" => "char"), "DATE_MARKED" => array("FIELD" => "O.DATE_MARKED", "TYPE" => "datetime"), "EMP_MARKED_ID" => array("FIELD" => "O.EMP_MARKED_ID", "TYPE" => "int"), "REASON_MARKED" => array("FIELD" => "O.REASON_MARKED", "TYPE" => "string"), "PRICE" => array("FIELD" => "O.PRICE", "TYPE" => "double"), "CURRENCY" => array("FIELD" => "O.CURRENCY", "TYPE" => "string"), "DISCOUNT_VALUE" => array("FIELD" => "O.DISCOUNT_VALUE", "TYPE" => "double"), "SUM_PAID" => array("FIELD" => "O.SUM_PAID", "TYPE" => "double"), "USER_ID" => array("FIELD" => "O.USER_ID", "TYPE" => "int"), "PAY_SYSTEM_ID" => array("FIELD" => "O.PAY_SYSTEM_ID", "TYPE" => "int"), "DELIVERY_ID" => array("FIELD" => "O.DELIVERY_ID", "TYPE" => "string"), "DATE_INSERT" => array("FIELD" => "O.DATE_INSERT", "TYPE" => "datetime"), "DATE_INSERT_FORMAT" => array("FIELD" => "O.DATE_INSERT", "TYPE" => "datetime"), "DATE_UPDATE" => array("FIELD" => "O.DATE_UPDATE", "TYPE" => "datetime"), "USER_DESCRIPTION" => array("FIELD" => "O.USER_DESCRIPTION", "TYPE" => "string"), "ADDITIONAL_INFO" => array("FIELD" => "O.ADDITIONAL_INFO", "TYPE" => "string"), "PS_STATUS" => array("FIELD" => "O.PS_STATUS", "TYPE" => "char"), "PS_STATUS_CODE" => array("FIELD" => "O.PS_STATUS_CODE", "TYPE" => "string"), "PS_STATUS_DESCRIPTION" => array("FIELD" => "O.PS_STATUS_DESCRIPTION", "TYPE" => "string"), "PS_STATUS_MESSAGE" => array("FIELD" => "O.PS_STATUS_MESSAGE", "TYPE" => "string"), "PS_SUM" => array("FIELD" => "O.PS_SUM", "TYPE" => "double"), "PS_CURRENCY" => array("FIELD" => "O.PS_CURRENCY", "TYPE" => "string"), "PS_RESPONSE_DATE" => array("FIELD" => "O.PS_RESPONSE_DATE", "TYPE" => "datetime"), "COMMENTS" => array("FIELD" => "O.COMMENTS", "TYPE" => "string"), "TAX_VALUE" => array("FIELD" => "O.TAX_VALUE", "TYPE" => "double"), "STAT_GID" => array("FIELD" => "O.STAT_GID", "TYPE" => "string"), "RECURRING_ID" => array("FIELD" => "O.RECURRING_ID", "TYPE" => "int"), "RECOUNT_FLAG" => array("FIELD" => "O.RECOUNT_FLAG", "TYPE" => "char"), "AFFILIATE_ID" => array("FIELD" => "O.AFFILIATE_ID", "TYPE" => "int"), "LOCKED_BY" => array("FIELD" => "O.LOCKED_BY", "TYPE" => "int"), "LOCK_STATUS" => array("FIELD" => "if(DATE_LOCK is null, 'green', if(DATE_ADD(DATE_LOCK, interval " . $maxLock . " MINUTE)<now(), 'green', if(LOCKED_BY=" . $userID . ", 'yellow', 'red')))", "TYPE" => "string"), "LOCK_USER_NAME" => array("FIELD" => "concat('(', UL.LOGIN ,') ',UL.NAME,' ',UL.LAST_NAME)", "FROM" => "LEFT JOIN b_user UL ON (O.LOCKED_BY = UL.ID)", "TYPE" => "string"), "DELIVERY_DOC_NUM" => array("FIELD" => "O.DELIVERY_DOC_NUM", "TYPE" => "string"), "DELIVERY_DOC_DATE" => array("FIELD" => "O.DELIVERY_DOC_DATE", "TYPE" => "date"), "UPDATED_1C" => array("FIELD" => "O.UPDATED_1C", "TYPE" => "string"), "STORE_ID" => array("FIELD" => "O.STORE_ID", "TYPE" => "int"), "BY_RECOMMENDATION" => array("FIELD" => "(SELECT (CASE WHEN MAX(BR.RECOMMENDATION) IS NULL OR MAX(BR.RECOMMENDATION) = '' THEN 'N' ELSE 'Y' END) FROM b_sale_basket BR WHERE BR.ORDER_ID=O.ID GROUP BY BR.ORDER_ID)", "TYPE" => "char"), "ORDER_TOPIC" => array("FIELD" => "O.ORDER_TOPIC", "TYPE" => "string"), "RESPONSIBLE_ID" => array("FIELD" => "O.RESPONSIBLE_ID", "TYPE" => "int"), "DATE_PAY_BEFORE" => array("FIELD" => "O.DATE_PAY_BEFORE", "TYPE" => "date"), "DATE_BILL" => array("FIELD" => "O.DATE_BILL", "TYPE" => "date"), "ACCOUNT_NUMBER" => array("FIELD" => "O.ACCOUNT_NUMBER", "TYPE" => "string"), "TRACKING_NUMBER" => array("FIELD" => "O.TRACKING_NUMBER", "TYPE" => "string"), "XML_ID" => array("FIELD" => "O.XML_ID", "TYPE" => "string"), "ID_1C" => array("FIELD" => "O.ID_1C", "TYPE" => "string"), "VERSION_1C" => array("FIELD" => "O.VERSION_1C", "TYPE" => "string"), "VERSION" => array("FIELD" => "O.VERSION", "TYPE" => "int"), "EXTERNAL_ORDER" => array("FIELD" => "O.EXTERNAL_ORDER", "TYPE" => "string"), "NAME_SEARCH" => array("FIELD" => "U.NAME, U.LAST_NAME, U.SECOND_NAME, U.EMAIL, U.LOGIN, U.ID", "TYPE" => "string", "FROM" => "INNER JOIN b_user U ON (O.USER_ID = U.ID)"), "USER_LOGIN" => array("FIELD" => "U.LOGIN", "TYPE" => "string", "FROM" => "INNER JOIN b_user U ON (O.USER_ID = U.ID)"), "USER_NAME" => array("FIELD" => "U.NAME", "TYPE" => "string", "FROM" => "INNER JOIN b_user U ON (O.USER_ID = U.ID)"), "USER_LAST_NAME" => array("FIELD" => "U.LAST_NAME", "TYPE" => "string", "FROM" => "INNER JOIN b_user U ON (O.USER_ID = U.ID)"), "USER_EMAIL" => array("FIELD" => "U.EMAIL", "TYPE" => "string", "FROM" => "INNER JOIN b_user U ON (O.USER_ID = U.ID)"), "USER_GROUP_ID" => array("FIELD" => "UG.GROUP_ID", "TYPE" => "int", "FROM" => "LEFT JOIN b_user_group UG ON (UG.USER_ID = O.USER_ID)"), "RESPONSIBLE_LOGIN" => array("FIELD" => "UR.LOGIN", "TYPE" => "string", "FROM" => "LEFT JOIN b_user UR ON (O.RESPONSIBLE_ID = UR.ID)"), "RESPONSIBLE_NAME" => array("FIELD" => "UR.NAME", "TYPE" => "string", "FROM" => "LEFT JOIN b_user UR ON (O.RESPONSIBLE_ID = UR.ID)"), "RESPONSIBLE_LAST_NAME" => array("FIELD" => "UR.LAST_NAME", "TYPE" => "string", "FROM" => "LEFT JOIN b_user UR ON (O.RESPONSIBLE_ID = UR.ID)"), "RESPONSIBLE_SECOND_NAME" => array("FIELD" => "UR.SECOND_NAME", "TYPE" => "string", "FROM" => "LEFT JOIN b_user UR ON (O.RESPONSIBLE_ID = UR.ID)"), "RESPONSIBLE_EMAIL" => array("FIELD" => "UR.EMAIL", "TYPE" => "string", "FROM" => "LEFT JOIN b_user UR ON (O.RESPONSIBLE_ID = UR.ID)"), "RESPONSIBLE_WORK_POSITION" => array("FIELD" => "UR.WORK_POSITION", "TYPE" => "string", "FROM" => "LEFT JOIN b_user UR ON (O.RESPONSIBLE_ID = UR.ID)"), "RESPONSIBLE_PERSONAL_PHOTO" => array("FIELD" => "UR.PERSONAL_PHOTO", "TYPE" => "string", "FROM" => "LEFT JOIN b_user UR ON (O.RESPONSIBLE_ID = UR.ID)"), "BUYER" => array("FIELD" => "U.LOGIN,U.NAME,U.LAST_NAME,U.EMAIL,U.ID", "WHERE_ONLY" => "Y", "TYPE" => "string", "FROM" => "INNER JOIN b_user U ON (O.USER_ID = U.ID)"), "BASKET_ID" => array("FIELD" => "B.ID", "TYPE" => "int", "FROM" => "INNER JOIN b_sale_basket B ON (O.ID = B.ORDER_ID)"), "BASKET_PRODUCT_ID" => array("FIELD" => "B.PRODUCT_ID", "TYPE" => "int", "FROM" => "INNER JOIN b_sale_basket B ON (O.ID = B.ORDER_ID)"), "BASKET_PRODUCT_XML_ID" => array("FIELD" => "B.PRODUCT_XML_ID", "TYPE" => "string", "FROM" => "INNER JOIN b_sale_basket B ON (O.ID = B.ORDER_ID)"), "BASKET_MODULE" => array("FIELD" => "B.MODULE", "TYPE" => "string", "FROM" => "INNER JOIN b_sale_basket B ON (O.ID = B.ORDER_ID)"), "BASKET_NAME" => array("FIELD" => "B.NAME", "TYPE" => "string", "FROM" => "INNER JOIN b_sale_basket B ON (O.ID = B.ORDER_ID)"), "BASKET_QUANTITY" => array("FIELD" => "B.QUANTITY", "TYPE" => "int", "FROM" => "INNER JOIN b_sale_basket B ON (O.ID = B.ORDER_ID)"), "BASKET_PRICE" => array("FIELD" => "B.PRICE", "TYPE" => "double", "FROM" => "INNER JOIN b_sale_basket B ON (O.ID = B.ORDER_ID)"), "BASKET_CURRENCY" => array("FIELD" => "B.CURRENCY", "TYPE" => "string", "FROM" => "INNER JOIN b_sale_basket B ON (O.ID = B.ORDER_ID)"), "BASKET_DISCOUNT_PRICE" => array("FIELD" => "B.DISCOUNT_PRICE", "TYPE" => "double", "FROM" => "INNER JOIN b_sale_basket B ON (O.ID = B.ORDER_ID)"), "BASKET_DISCOUNT_NAME" => array("FIELD" => "B.DISCOUNT_NAME", "TYPE" => "string", "FROM" => "INNER JOIN b_sale_basket B ON (O.ID = B.ORDER_ID)"), "BASKET_DISCOUNT_VALUE" => array("FIELD" => "B.DISCOUNT_VALUE", "TYPE" => "string", "FROM" => "INNER JOIN b_sale_basket B ON (O.ID = B.ORDER_ID)"), "BASKET_DISCOUNT_COUPON" => array("FIELD" => "B.DISCOUNT_COUPON", "TYPE" => "string", "FROM" => "INNER JOIN b_sale_basket B ON (O.ID = B.ORDER_ID)"), "BASKET_VAT_RATE" => array("FIELD" => "B.VAT_RATE", "TYPE" => "string", "FROM" => "INNER JOIN b_sale_basket B ON (O.ID = B.ORDER_ID)"), "BASKET_RECOMMENDATION" => array("FIELD" => "B.RECOMMENDATION", "TYPE" => "string", "FROM" => "INNER JOIN b_sale_basket B ON (O.ID = B.ORDER_ID)"), "BASKET_PRICE_TOTAL" => array("FIELD" => "(B.PRICE * B.QUANTITY)", "TYPE" => "double", "FROM" => "INNER JOIN b_sale_basket B ON (O.ID = B.ORDER_ID)"), "PROPERTY_ID" => array("FIELD" => "SP.ID", "TYPE" => "int", "FROM" => "INNER JOIN b_sale_order_props_value SP ON (O.ID = SP.ORDER_ID)"), "PROPERTY_ORDER_PROPS_ID" => array("FIELD" => "SP.ORDER_PROPS_ID", "TYPE" => "int", "FROM" => "INNER JOIN b_sale_order_props_value SP ON (O.ID = SP.ORDER_ID)"), "PROPERTY_NAME" => array("FIELD" => "SP.NAME", "TYPE" => "string", "FROM" => "INNER JOIN b_sale_order_props_value SP ON (O.ID = SP.ORDER_ID)"), "PROPERTY_VALUE" => array("FIELD" => "SP.VALUE", "TYPE" => "string", "FROM" => "INNER JOIN b_sale_order_props_value SP ON (O.ID = SP.ORDER_ID)"), "PROPERTY_CODE" => array("FIELD" => "SP.CODE", "TYPE" => "string", "FROM" => "INNER JOIN b_sale_order_props_value SP ON (O.ID = SP.ORDER_ID)"), "PROPERTY_VAL_BY_CODE" => array("FIELD" => "SP.VALUE", "TYPE" => "string", "FROM" => "INNER JOIN b_sale_order_props_value SP ON (O.ID = SP.ORDER_ID)"), "DELIVERY_DATE_REQUEST" => array("FIELD" => "OD.DATE_REQUEST", "TYPE" => "datetime", "FROM" => "LEFT JOIN b_sale_order_delivery OD ON (O.ID = OD.ORDER_ID)"));
require_once $_SERVER["DOCUMENT_ROOT"] . '/bitrix/modules/sale/general/status.php';
CSaleStatusAdapter::addFieldsTo($arFields, 'O.STATUS_ID', 'STATUS_PERMS_');
// <-- FIELDS
$arPropIDsTmp = array();
foreach ($arOrder as $key => $value) {
CSaleOrder::PrepareGetListArray($key, $arFields, $arPropIDsTmp);
}
foreach ($arFilter as $key => $value) {
$arKeyTmp = CSaleOrder::GetFilterOperation($key);
$key = $arKeyTmp["FIELD"];
CSaleOrder::PrepareGetListArray($key, $arFields, $arPropIDsTmp);
}
if (is_array($arGroupBy)) {
foreach ($arGroupBy as $key => $value) {
CSaleOrder::PrepareGetListArray($key, $arFields, $arPropIDsTmp);
}
}
foreach ($arSelectFields as $key => $value) {
CSaleOrder::PrepareGetListArray($key, $arFields, $arPropIDsTmp);
}
$arSqls = CSaleOrder::PrepareSql($arFields, $arOrder, $arFilter, $arGroupBy, $arSelectFields, $obUserFieldsSql, $callback, $arOptions);
$arSqls["SELECT"] = str_replace("%%_DISTINCT_%%", "", $arSqls["SELECT"]);
$r = $obUserFieldsSql->GetFilter();
$strSqlUFFilter = '';
if (strlen($r) > 0) {
$strSqlUFFilter = " (" . $r . ") ";
}
if (is_array($arGroupBy) && count($arGroupBy) == 0) {
$strSql = "SELECT " . $arSqls["SELECT"] . " " . $obUserFieldsSql->GetSelect() . " " . "FROM b_sale_order O " . "\t" . $arSqls["FROM"] . " " . $obUserFieldsSql->GetJoin("O.ID") . " ";
if (strlen($arSqls["WHERE"]) > 0) {
$strSql .= "WHERE " . $arSqls["WHERE"] . " ";
}
if (strlen($arSqls["WHERE"]) > 0 && strlen($strSqlUFFilter) > 0) {
$strSql .= " AND " . $strSqlUFFilter . " ";
} elseif (strlen($arSqls["WHERE"]) <= 0 && strlen($strSqlUFFilter) > 0) {
$strSql .= " WHERE " . $strSqlUFFilter . " ";
}
if (strlen($arSqls["GROUPBY"]) > 0) {
$strSql .= "GROUP BY " . $arSqls["GROUPBY"] . " ";
}
//echo "!1!=".htmlspecialcharsbx($strSql)."<br>";
$dbRes = $DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
$dbRes->SetUserFields($USER_FIELD_MANAGER->GetUserFields("ORDER"));
if ($arRes = $dbRes->Fetch()) {
return $arRes["CNT"];
} else {
return False;
}
}
$strSql = "SELECT " . $arSqls["SELECT"] . " " . $obUserFieldsSql->GetSelect() . " " . "FROM b_sale_order O " . "\t" . $arSqls["FROM"] . " " . $obUserFieldsSql->GetJoin("O.ID") . " ";
if (strlen($arSqls["WHERE"]) > 0) {
$strSql .= "WHERE " . $arSqls["WHERE"] . " ";
}
if (strlen($arSqls["WHERE"]) > 0 && strlen($strSqlUFFilter) > 0) {
$strSql .= " AND " . $strSqlUFFilter . " ";
} elseif (strlen($arSqls["WHERE"]) <= 0 && strlen($strSqlUFFilter) > 0) {
$strSql .= " WHERE " . $strSqlUFFilter . " ";
}
if (strlen($arSqls["GROUPBY"]) > 0) {
$strSql .= "GROUP BY " . $arSqls["GROUPBY"] . " ";
}
if (strlen($arSqls["ORDERBY"]) > 0) {
$strSql .= "ORDER BY " . $arSqls["ORDERBY"] . " ";
}
if (is_array($arNavStartParams) && IntVal($arNavStartParams["nTopCount"]) <= 0) {
$strSql_tmp = "SELECT COUNT('x') as CNT " . "FROM b_sale_order O " . "\t" . $arSqls["FROM"] . " " . $obUserFieldsSql->GetJoin("O.ID") . " ";
if (strlen($arSqls["WHERE"]) > 0) {
$strSql_tmp .= "WHERE " . $arSqls["WHERE"] . " ";
}
if (strlen($arSqls["WHERE"]) > 0 && strlen($strSqlUFFilter) > 0) {
$strSql_tmp .= " AND " . $strSqlUFFilter . " ";
} elseif (strlen($arSqls["WHERE"]) <= 0 && strlen($strSqlUFFilter) > 0) {
$strSql_tmp .= " WHERE " . $strSqlUFFilter . " ";
}
if (strlen($arSqls["GROUPBY"]) > 0) {
$strSql_tmp .= "GROUP BY " . $arSqls["GROUPBY"] . " ";
}
//echo "!2.1!=".htmlspecialcharsbx($strSql_tmp)."<br>";
$dbRes = $DB->Query($strSql_tmp, false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
$cnt = 0;
if (strlen($arSqls["GROUPBY"]) <= 0) {
if ($arRes = $dbRes->Fetch()) {
$cnt = $arRes["CNT"];
}
} else {
$cnt = $dbRes->SelectedRowsCount();
}
$dbRes = new CDBResult();
//echo "!2.2!=".htmlspecialcharsbx($strSql)."<br>";
$dbRes->SetUserFields($USER_FIELD_MANAGER->GetUserFields("ORDER"));
$dbRes->NavQuery($strSql, $cnt, $arNavStartParams);
} else {
if (is_array($arNavStartParams) && IntVal($arNavStartParams["nTopCount"]) > 0) {
$strSql .= "LIMIT " . IntVal($arNavStartParams["nTopCount"]);
}
//echo "!3!=".htmlspecialcharsbx($strSql)."<br>";
$dbRes = $DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
$dbRes->SetUserFields($USER_FIELD_MANAGER->GetUserFields("ORDER"));
}
return $dbRes;
}
$runtimeFields['PROP_' . $propIterator] = array('data_type' => 'Bitrix\\Sale\\Internals\\OrderPropsValueTable', 'reference' => array('ref.ORDER_ID' => 'this.ID'), 'join_type' => 'inner');
$arFilter["=PROP_" . $propIterator . ".ORDER_PROPS_ID"] = $key;
if (isset($filterOrderProps["%PROPERTY_VALUE_" . $key])) {
$arFilter["%PROP_" . $propIterator . ".VALUE"] = $filterOrderPropValue[$key];
} else {
$arFilter["PROP_" . $propIterator . ".VALUE"] = $filterOrderPropValue[$key];
}
}
}
$shownFieldsList = COption::GetOptionString("sale", "order_list_fields", "ID,USER,PAY_SYSTEM,PRICE,STATUS,PAYED,PS_STATUS,CANCELED,BASKET");
$arShownFieldsList = explode(",", $shownFieldsList);
$arShownFieldsParams = array();
$aliasFields = array();
$arSelectFields = array("PAYED");
$ind = -1;
$aliasFieldsList = \Bitrix\Sale\Compatible\OrderCompatibility::getAliasFields();
$alreadyUsedFields = \Bitrix\Sale\Order::getAllFields();
foreach ($aliasFieldsList as $fieldName => $fieldAlias) {
if (!in_array($fieldName, $alreadyUsedFields)) {
$aliasFields[$fieldName] = $fieldAlias;
}
}
foreach ($GLOBALS["AVAILABLE_ORDER_FIELDS"] as $key => $value) {
if (in_array($key, $arShownFieldsList)) {
$ind++;
$arShownFieldsParams[$ind] = $value;
$arShownFieldsParams[$ind]["KEY"] = $key;
$arFields_tmp = array();
if (strlen($value["SELECT"]) > 0) {
$arFields_tmp = explode(",", $value["SELECT"]);
}
