public static function tryUnshipmentProduct($productId)
{
$result = new \Bitrix\Sale\Result();
$fields = array();
$strUseStoreControl = COption::GetOptionString('catalog', 'default_use_store_control');
$disableReservation = COption::GetOptionString("catalog", "enable_reservation") == "N" && COption::GetOptionString("sale", "product_reserve_condition", "O") != "S" && $strUseStoreControl != "Y";
if ($disableReservation) {
return $result;
}
$rsProducts = CCatalogProduct::GetList(array(), array('ID' => $productId), false, false, array('ID', 'QUANTITY', 'QUANTITY_RESERVED', 'QUANTITY_TRACE', 'CAN_BUY_ZERO'));
if ($arProduct = $rsProducts->Fetch()) {
$fields["QUANTITY_TRACE"] = $arProduct["QUANTITY_TRACE"] == "Y";
}
if (!empty($fields)) {
$result->addData($fields);
}
return $result;
}
/**
* @param bool|false $renameTable
* @return \Bitrix\Sale\Result
* @throws Exception
* @throws \Bitrix\Main\ArgumentException
* @internal
*/
public static function convertToNew($renameTable = false)
{
$result = new \Bitrix\Sale\Result();
$con = \Bitrix\Main\Application::getConnection();
if (!$con->isTableExists("b_sale_delivery")) {
return $result;
}
if (!$con->isTableExists("b_sale_delivery2location_tmp")) {
$fields = $con->getTableFields('b_sale_delivery2location');
$con->createTable('b_sale_delivery2location_tmp', $fields, array('DELIVERY_ID', 'LOCATION_CODE', 'LOCATION_TYPE'));
$con->queryExecute('
INSERT INTO
b_sale_delivery2location_tmp(DELIVERY_ID, LOCATION_CODE, LOCATION_TYPE)
SELECT
DELIVERY_ID, LOCATION_CODE, LOCATION_TYPE FROM b_sale_delivery2location
');
$con->queryExecute('DELETE FROM b_sale_delivery2location');
}
$sqlHelper = $con->getSqlHelper();
$deliveryRes = $con->query('SELECT * FROM b_sale_delivery WHERE CONVERTED != \'Y\'');
while ($delivery = $deliveryRes->fetch()) {
$delivery["CODE"] = $delivery["ID"];
unset($delivery["ID"]);
$newId = \CSaleDelivery::Add($delivery);
if (intval($newId) <= 0) {
$result->addError(new \Bitrix\Main\Entity\EntityError("Can't convert old delivery id: " . $delivery["CODE"]));
continue;
}
$res = \Bitrix\Sale\Delivery\Restrictions\Table::add(array("DELIVERY_ID" => $newId, "CLASS_NAME" => '\\Bitrix\\Sale\\Delivery\\Restrictions\\ByLocation', "SORT" => 100));
$result->addErrors($res->getErrors());
if ($result->isSuccess()) {
$con->queryExecute('UPDATE b_sale_delivery SET CONVERTED=\'Y\' WHERE ID=' . $sqlHelper->forSql($delivery["CODE"]));
$con->queryExecute("UPDATE b_sale_order SET DELIVERY_ID=" . $sqlHelper->forSql($newId) . " WHERE DELIVERY_ID = " . $sqlHelper->forSql($delivery["CODE"]));
$con->queryExecute("UPDATE b_sale_order_history SET DELIVERY_ID=" . $sqlHelper->forSql($newId) . " WHERE DELIVERY_ID = " . $sqlHelper->forSql($delivery["CODE"]));
$con->queryExecute("UPDATE b_sale_delivery2paysystem SET DELIVERY_ID=" . $sqlHelper->forSql($newId) . ", LINK_DIRECTION='" . DeliveryPaySystemTable::LINK_DIRECTION_DELIVERY_PAYSYSTEM . "' WHERE DELIVERY_ID = " . $sqlHelper->forSql($delivery["CODE"]));
$con->queryExecute('
INSERT INTO
b_sale_delivery2location(DELIVERY_ID, LOCATION_CODE, LOCATION_TYPE)
SELECT
' . $sqlHelper->forSql($newId) . ', LOCATION_CODE, LOCATION_TYPE FROM b_sale_delivery2location_tmp
WHERE
DELIVERY_ID = ' . $sqlHelper->forSql($delivery["CODE"]) . '
');
$con->queryExecute('DELETE FROM b_sale_delivery2location_tmp WHERE DELIVERY_ID = ' . $sqlHelper->forSql($delivery["CODE"]));
$d2pRes = \Bitrix\Sale\Internals\DeliveryPaySystemTable::getList(array('filter' => array('DELIVERY_ID' => $newId), 'select' => array("DELIVERY_ID"), 'group' => array("DELIVERY_ID")));
if ($d2p = $d2pRes->fetch()) {
$res = \Bitrix\Sale\Delivery\Restrictions\Table::add(array("DELIVERY_ID" => $d2p["DELIVERY_ID"], "CLASS_NAME" => '\\Bitrix\\Sale\\Delivery\\Restrictions\\ByPaySystem', "SORT" => 100));
if (!$res->isSuccess()) {
$result->addErrors($res->getErrors());
}
}
}
}
if ($result->isSuccess()) {
$con->dropTable('b_sale_delivery2location_tmp');
if ($renameTable) {
$con->renameTable("b_sale_delivery", "b_sale_delivery_old");
}
}
return $result;
}
/**
* @return \Bitrix\Sale\Result|bool
* @throws Exception
* @throws \Bitrix\Main\SystemException
*/
public static function convertToNew($renameTable = false)
{
$result = new \Bitrix\Sale\Result();
$con = \Bitrix\Main\Application::getConnection();
if (!$con->isTableExists("b_sale_delivery_handler")) {
return true;
}
$sqlHelper = $con->getSqlHelper();
$deliveryRes = $con->query('SELECT * FROM b_sale_delivery_handler WHERE CONVERTED != \'Y\'');
$tablesToUpdate = array('b_sale_order', 'b_sale_order_history');
\CSaleDeliveryHandler::Initialize();
$handlers = \CSaleDeliveryHandler::__getRegisteredHandlers();
while ($delivery = $deliveryRes->fetch()) {
if (strlen($delivery["PROFILES"]) > 0) {
$delivery["PROFILES"] = unserialize($delivery["PROFILES"]);
} else {
$delivery["PROFILES"] = $handlers[$delivery["HID"]]["PROFILES"];
foreach ($delivery["PROFILES"] as $id => $params) {
$delivery["PROFILES"][$id]["ACTIVE"] = $delivery["ACTIVE"];
}
}
// Something strange it probably not used
if ($delivery["PROFILES"] == false || !is_array($delivery["PROFILES"]) || empty($delivery["PROFILES"])) {
$result->addError(new \Bitrix\Main\Entity\EntityError("Can't receive info about profiles. Delivery HID: \"" . $delivery["HID"] . "\""));
continue;
}
unset($delivery["ID"]);
$delivery["CONFIG"] = array();
if (strlen($delivery["SETTINGS"]) > 0) {
if (isset($handlers[$delivery["HID"]]["DBGETSETTINGS"]) && is_callable($handlers[$delivery["HID"]]["DBGETSETTINGS"])) {
$delivery["CONFIG"] = call_user_func($handlers[$delivery["HID"]]["DBGETSETTINGS"], $delivery["SETTINGS"]);
} else {
$delivery["CONFIG"] = $delivery["SETTINGS"];
}
} elseif (is_callable($handlers[$delivery["HID"]]["GETCONFIG"])) {
$config = call_user_func($handlers[$delivery["HID"]]["GETCONFIG"], strlen($delivery["LID"]) > 0 ? $delivery["LID"] : false);
foreach ($config["CONFIG"] as $key => $arConfig) {
if (!empty($arConfig["DEFAULT"])) {
$delivery["CONFIG"][$key] = $arConfig["DEFAULT"];
}
}
}
$delivery["SID"] = $handlers[$delivery["HID"]]["SID"];
$id = \CSaleDeliveryHandler::Set($delivery["HID"], $delivery, strlen($delivery["LID"]) > 0 ? $delivery["LID"] : false);
if (intval($id) <= 0) {
$result->addError(new \Bitrix\Main\Entity\EntityError("Can't convert delivery handler with hid: " . $delivery["HID"] . (strlen($delivery["LID"]) > 0 ? " for site: " . $delivery["LID"] : "")));
continue;
}
$con->queryExecute('UPDATE b_sale_delivery_handler SET CONVERTED="Y" WHERE HID="' . $sqlHelper->forSql($delivery["HID"]) . '"');
$ids = array($id);
foreach ($delivery["PROFILES"] as $profileName => $profileData) {
$fullSid = $delivery["HID"] . ":" . $profileName;
$profileId = \Bitrix\Sale\Delivery\Services\Table::getIdByCode($fullSid);
$ids[] = $profileId;
if (intval($profileId) > 0) {
foreach ($tablesToUpdate as $table) {
$con->queryExecute("UPDATE " . $table . " SET DELIVERY_ID=" . $sqlHelper->forSql($profileId) . " WHERE DELIVERY_ID = '" . $sqlHelper->forSql($fullSid) . "'");
}
$con->queryExecute("UPDATE b_sale_delivery2paysystem SET DELIVERY_ID=" . $sqlHelper->forSql($profileId) . ", DELIVERY_PROFILE_ID='' WHERE DELIVERY_ID = '" . $sqlHelper->forSql($delivery["HID"]) . "' AND DELIVERY_PROFILE_ID='" . $profileName . "'");
} else {
$result->addError(new \Bitrix\Main\Entity\EntityError("Cant determine id for profile code: " . $fullSid));
}
}
$con->queryExecute("UPDATE b_sale_delivery2paysystem SET DELIVERY_ID=" . $sqlHelper->forSql($id) . ", DELIVERY_PROFILE_ID='' WHERE DELIVERY_ID = '" . $sqlHelper->forSql($delivery["HID"]) . "' AND (DELIVERY_PROFILE_ID='' OR DELIVERY_PROFILE_ID IS NULL)");
$d2pRes = \Bitrix\Sale\Internals\DeliveryPaySystemTable::getList(array('filter' => array('DELIVERY_ID' => $ids), 'select' => array("DELIVERY_ID"), 'group' => array("DELIVERY_ID")));
while ($d2p = $d2pRes->fetch()) {
$res = \Bitrix\Sale\Delivery\Restrictions\Table::add(array("DELIVERY_ID" => $d2p["DELIVERY_ID"], "CLASS_NAME" => '\\Bitrix\\Sale\\Delivery\\Restrictions\\ByPaySystem', "SORT" => 100));
if (!$res->isSuccess()) {
$result->addErrors($res->getErrors());
}
}
}
if ($renameTable && $result->isSuccess()) {
$con->queryExecute("ALTER TABLE b_sale_delivery_handler RENAME b_sale_delivery_handler_old");
}
return $result;
}
<?php
/**
* @var CUser $USER
* @var CMain $APPLICATION
*/
use Bitrix\Sale\Helpers\Admin\OrderEdit;
use Bitrix\Main\Localization\Loc;
use Bitrix\Sale\Helpers\Admin\Blocks;
require_once $_SERVER["DOCUMENT_ROOT"] . "/bitrix/modules/main/include/prolog_admin_before.php";
require_once $_SERVER["DOCUMENT_ROOT"] . "/bitrix/modules/sale/prolog.php";
Bitrix\Main\Loader::includeModule('sale');
$moduleId = "sale";
$result = new \Bitrix\Sale\Result();
$order = null;
Loc::loadMessages(__FILE__);
$saleModulePermissions = $APPLICATION->GetGroupRight("sale");
$arUserGroups = $USER->GetUserGroupArray();
$boolLocked = false;
if ($saleModulePermissions == "D") {
$APPLICATION->AuthForm(Loc::getMessage("ACCESS_DENIED"));
}
/** @var \Bitrix\Sale\Order $order */
if (!isset($_REQUEST["ID"]) || intval($_REQUEST["ID"]) <= 0) {
LocalRedirect("/bitrix/admin/sale_order.php?lang=" . LANGUAGE_ID . GetFilterParams("filter_", false));
}
$ID = intval($_REQUEST["ID"]);
$intLockUserID = 0;
$strLockTime = '';
if (isset($_REQUEST['dontsave']) && $_REQUEST['dontsave'] == 'Y') {
if (!\Bitrix\Sale\Order::isLocked($ID)) {
/**
* @return \Bitrix\Sale\Result
* @throws Exception
* @throws \Bitrix\Main\SystemException
*/
public static function convertToNew($renameTable = false)
{
$result = new \Bitrix\Sale\Result();
$con = \Bitrix\Main\Application::getConnection();
if (!$con->isTableExists("b_sale_delivery_handler")) {
return $result;
}
$sqlHelper = $con->getSqlHelper();
$deliveryRes = $con->query('SELECT * FROM b_sale_delivery_handler WHERE CONVERTED != \'Y\'');
$tablesToUpdate = array('b_sale_order', 'b_sale_order_history');
\CSaleDeliveryHandler::Initialize();
$handlers = \CSaleDeliveryHandler::__getRegisteredHandlers();
while ($delivery = $deliveryRes->fetch()) {
if (strlen($delivery["HID"]) <= 0) {
$result->addError(new \Bitrix\Main\Entity\EntityError("Can't find delivery HID. ID: \"" . $delivery["ID"] . "\""));
continue;
}
if (!isset($handlers[$delivery["HID"]])) {
\CEventLog::Add(array("SEVERITY" => "ERROR", "AUDIT_TYPE_ID" => "SALE_CONVERTER_ERROR", "MODULE_ID" => "sale", "ITEM_ID" => "CAllSaleDeliveryHandler::convertToNew()", "DESCRIPTION" => "Can't find delivery handler for registered HID: \"" . $delivery["HID"] . "\""));
//$result->addError( new \Bitrix\Main\Entity\EntityError("Can't find delivery handler for registered HID: \"".$delivery["HID"]."\""));
continue;
}
if (strlen($delivery["PROFILES"]) > 0) {
//get from base
$delivery["PROFILES"] = unserialize($delivery["PROFILES"]);
} else {
//or default.
$delivery["PROFILES"] = $handlers[$delivery["HID"]]["PROFILES"];
}
// Something strange it probably not used
if ($delivery["PROFILES"] == false || !is_array($delivery["PROFILES"]) || empty($delivery["PROFILES"])) {
$result->addError(new \Bitrix\Main\Entity\EntityError("Can't receive info about profiles. Delivery HID: \"" . $delivery["HID"] . "\""));
continue;
}
//Set profiles activity
foreach ($delivery["PROFILES"] as $id => $params) {
if (!isset($delivery["PROFILES"][$id]["ACTIVE"]) || $delivery["ACTIVE"] == "N") {
$delivery["PROFILES"][$id]["ACTIVE"] = $delivery["ACTIVE"];
}
}
unset($delivery["ID"]);
$delivery["CONFIG"] = array();
if (strlen($delivery["SETTINGS"]) > 0) {
if (isset($handlers[$delivery["HID"]]["DBGETSETTINGS"]) && is_callable($handlers[$delivery["HID"]]["DBGETSETTINGS"])) {
$delivery["CONFIG"] = call_user_func($handlers[$delivery["HID"]]["DBGETSETTINGS"], $delivery["SETTINGS"]);
} else {
$delivery["CONFIG"] = $delivery["SETTINGS"];
}
} elseif (isset($handlers[$delivery["HID"]]["GETCONFIG"]) && is_callable($handlers[$delivery["HID"]]["GETCONFIG"])) {
$config = call_user_func($handlers[$delivery["HID"]]["GETCONFIG"], strlen($delivery["LID"]) > 0 ? $delivery["LID"] : false);
foreach ($config["CONFIG"] as $key => $arConfig) {
if (!empty($arConfig["DEFAULT"])) {
$delivery["CONFIG"][$key] = $arConfig["DEFAULT"];
}
}
}
if (empty($delivery["NAME"])) {
if (!empty($handlers[$delivery["HID"]]["NAME"])) {
$delivery["NAME"] = $handlers[$delivery["HID"]]["NAME"];
} else {
$delivery["NAME"] = "-";
}
}
$delivery["SID"] = $handlers[$delivery["HID"]]["SID"];
$id = \CSaleDeliveryHandler::Set($delivery["HID"], $delivery, strlen($delivery["LID"]) > 0 ? $delivery["LID"] : false);
if (intval($id) <= 0) {
$result->addError(new \Bitrix\Main\Entity\EntityError("Can't convert delivery handler with hid: " . $delivery["HID"] . (strlen($delivery["LID"]) > 0 ? " for site: " . $delivery["LID"] : "")));
continue;
}
$con->queryExecute("UPDATE b_sale_delivery_handler SET CONVERTED='Y' WHERE HID LIKE '" . $sqlHelper->forSql($delivery["HID"]) . "'");
$ids = array($id);
foreach ($delivery["PROFILES"] as $profileName => $profileData) {
$fullSid = $delivery["HID"] . ":" . $profileName;
$profileId = \CSaleDelivery::getIdByCode($fullSid);
$ids[] = $profileId;
if (intval($profileId) > 0) {
foreach ($tablesToUpdate as $table) {
$con->queryExecute("UPDATE " . $table . " SET DELIVERY_ID='" . $sqlHelper->forSql($profileId) . "' WHERE DELIVERY_ID = '" . $sqlHelper->forSql($fullSid) . "'");
}
$con->queryExecute("UPDATE b_sale_delivery2paysystem SET DELIVERY_ID='" . $sqlHelper->forSql($profileId) . "', DELIVERY_PROFILE_ID='##CONVERTED##' WHERE DELIVERY_ID = '" . $sqlHelper->forSql($delivery["HID"]) . "' AND DELIVERY_PROFILE_ID='" . $profileName . "'");
} else {
$result->addError(new \Bitrix\Main\Entity\EntityError("Cant determine id for profile code: " . $fullSid));
}
}
$con->queryExecute("UPDATE b_sale_delivery2paysystem SET DELIVERY_ID='" . $sqlHelper->forSql($id) . "', DELIVERY_PROFILE_ID='##CONVERTED##' WHERE DELIVERY_ID = '" . $sqlHelper->forSql($delivery["HID"]) . "' AND (DELIVERY_PROFILE_ID='' OR DELIVERY_PROFILE_ID IS NULL)");
$d2pRes = \Bitrix\Sale\Internals\DeliveryPaySystemTable::getList(array('filter' => array('DELIVERY_ID' => $ids), 'select' => array("DELIVERY_ID"), 'group' => array("DELIVERY_ID")));
while ($d2p = $d2pRes->fetch()) {
$res = \Bitrix\Sale\Internals\ServiceRestrictionTable::add(array("SERVICE_ID" => $d2p["DELIVERY_ID"], "SERVICE_TYPE" => \Bitrix\Sale\Services\Base\RestrictionManager::SERVICE_TYPE_SHIPMENT, "CLASS_NAME" => '\\Bitrix\\Sale\\Delivery\\Restrictions\\ByPaySystem', "SORT" => 100));
if (!$res->isSuccess()) {
$result->addErrors($res->getErrors());
}
}
}
if ($renameTable && $result->isSuccess()) {
$con->renameTable('b_sale_delivery_handler', 'b_sale_delivery_handler_old');
}
return $result;
}
public static function tryUnshipmentProduct($productId)
{
$result = new \Bitrix\Sale\Result();
$strUseStoreControl = COption::GetOptionString('catalog', 'default_use_store_control');
$disableReservation = COption::GetOptionString("catalog", "enable_reservation") == "N" && COption::GetOptionString("sale", "product_reserve_condition", "O") != "S" && $strUseStoreControl != "Y";
if ($disableReservation) {
return $result;
}
$rsProducts = CCatalogProduct::GetList(array(), array('ID' => $productId), false, false, array('ID', 'QUANTITY', 'QUANTITY_RESERVED', 'QUANTITY_TRACE', 'CAN_BUY_ZERO', 'NEGATIVE_AMOUNT_TRACE'));
if (!($arProduct = $rsProducts->Fetch())) {
$result->addError(new \Bitrix\Sale\ResultError(Loc::getMessage(""), 'PROVIDER_UNSHIPMENT_PRODUCT'));
}
return $result;
}
<?php
/**
* @var CUser $USER
* @var CMain $APPLICATION
*/
use Bitrix\Sale\Helpers\Admin\OrderEdit;
use Bitrix\Main\Localization\Loc;
use Bitrix\Sale\Helpers\Admin\Blocks;
require_once $_SERVER["DOCUMENT_ROOT"] . "/bitrix/modules/main/include/prolog_admin_before.php";
require_once $_SERVER["DOCUMENT_ROOT"] . "/bitrix/modules/sale/prolog.php";
Bitrix\Main\Loader::includeModule('sale');
$moduleId = "sale";
$result = new \Bitrix\Sale\Result();
$order = null;
Loc::loadMessages(__FILE__);
$saleModulePermissions = $APPLICATION->GetGroupRight("sale");
$arUserGroups = $USER->GetUserGroupArray();
$boolLocked = false;
if ($saleModulePermissions == "D") {
$APPLICATION->AuthForm(Loc::getMessage("ACCESS_DENIED"));
}
/** @var \Bitrix\Sale\Order $order */
if (!isset($_REQUEST["ID"]) || intval($_REQUEST["ID"]) <= 0) {
LocalRedirect("/bitrix/admin/sale_order.php?lang=" . LANGUAGE_ID . GetFilterParams("filter_", false));
}
$ID = intval($_REQUEST["ID"]);
$boolLocked = \Bitrix\Sale\Order::isLocked($ID);
if ($boolLocked) {
LocalRedirect("sale_order_view.php?ID=" . $ID . "&lang=" . LANGUAGE_ID . GetFilterParams("filter_", false));
}
/**
* @param Order $order
* @param array $formData
* @param int $userId
*
* @return \Bitrix\Sale\Result
*/
protected static function fillSimpleFields(Order $order, array $formData, $userId = 0)
{
$result = new \Bitrix\Sale\Result();
if (isset($formData["ORDER"]["RESPONSIBLE_ID"])) {
/** @var \Bitrix\Sale\Result $r */
$r = $order->setField("RESPONSIBLE_ID", $formData["ORDER"]["RESPONSIBLE_ID"]);
if (!$r->isSuccess()) {
$result->addErrors($r->getErrors());
}
}
if (isset($formData["PERSON_TYPE_ID"]) && intval($formData["PERSON_TYPE_ID"]) > 0) {
/** @var \Bitrix\Sale\Result $r */
$r = $order->setPersonTypeId(intval($formData['PERSON_TYPE_ID']));
} else {
/** @var \Bitrix\Sale\Result $r */
$r = $order->setPersonTypeId(Blocks\OrderBuyer::getDefaultPersonType($order->getSiteId()));
}
if (!$r->isSuccess()) {
$result->addErrors($r->getErrors());
}
if (isset($formData["ORDER"]["COMMENTS"])) {
/** @var \Bitrix\Sale\Result $r */
$r = $order->setField("COMMENTS", $formData["ORDER"]["COMMENTS"]);
if (!$r->isSuccess()) {
$result->addErrors($r->getErrors());
}
}
if (isset($formData["USER_DESCRIPTION"])) {
/** @var \Bitrix\Sale\Result $r */
$r = $order->setField("USER_DESCRIPTION", $formData["USER_DESCRIPTION"]);
if (!$r->isSuccess()) {
$result->addErrors($r->getErrors());
}
}
if (isset($formData["RESPONSIBLE_ID"])) {
/** @var \Bitrix\Sale\Result $r */
$r = $order->setField("RESPONSIBLE_ID", $formData["RESPONSIBLE_ID"]);
if (!$r->isSuccess()) {
$result->addErrors($r->getErrors());
}
}
if (isset($formData["STATUS_ID"]) && strlen($formData["STATUS_ID"]) > 0) {
$statusesList = \Bitrix\Sale\OrderStatus::getAllowedUserStatuses($userId, \Bitrix\Sale\OrderStatus::getInitialStatus());
if (array_key_exists($formData["STATUS_ID"], $statusesList)) {
/** @var \Bitrix\Sale\Result $r */
$r = $order->setField("STATUS_ID", $formData["STATUS_ID"]);
if (!$r->isSuccess()) {
$result->addErrors($r->getErrors());
}
}
}
return $result;
}
