function Update($ID, $arFields)
{
global $DB;
$ID = IntVal($ID);
if (!CSaleOrderTax::CheckFields("UPDATE", $arFields)) {
return false;
}
$strUpdate = $DB->PrepareUpdate("b_sale_order_tax", $arFields);
$strSql = "UPDATE b_sale_order_tax SET " . "\t" . $strUpdate . " " . "WHERE ID = " . $ID . " ";
$DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
return $ID;
}
function Add($arFields)
{
global $DB;
if (!CSaleOrderTax::CheckFields("ADD", $arFields)) {
return false;
}
$arInsert = $DB->PrepareInsert("b_sale_order_tax", $arFields);
$strSql = "INSERT INTO b_sale_order_tax(" . $arInsert[0] . ") " . "VALUES(" . $arInsert[1] . ")";
$DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
$ID = IntVal($DB->LastID());
return $ID;
}
function Add($arFields)
{
global $DB;
if (!CSaleOrderTax::CheckFields("ADD", $arFields)) {
return false;
}
$dbResult = CSaleOrderTax::GetList(array(), array("ORDER_ID" => $arFields['ORDER_ID'], "TAX_NAME" => $arFields['TAX_NAME'], "CODE" => $arFields['CODE']), false, false, array("ID"));
if ($dbResult->Fetch()) {
return false;
}
$arInsert = $DB->PrepareInsert("b_sale_order_tax", $arFields);
$strSql = "INSERT INTO b_sale_order_tax(" . $arInsert[0] . ") " . "VALUES(" . $arInsert[1] . ")";
$DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
$ID = IntVal($DB->LastID());
return $ID;
}
function nodeHandler(CDataXML $value)
{
$value = $value->GetArray();
if(!empty($value[GetMessage("CC_BSC1_DOCUMENT")]))
{
$value = $value[GetMessage("CC_BSC1_DOCUMENT")];
$arOrder = $this->collectOrderInfo($value);
if(!empty($arOrder))
{
if(strlen($arOrder["ID"]) <= 0 && strlen($arOrder["ID_1C"]) > 0)//try to search order from 1C
{
$dbOrder = CSaleOrder::GetList(array("ID" => "DESC"), array("ID_1C" => $arOrder["ID_1C"]), false, false, array("ID", "ID_1C"));
if($orderInfo = $dbOrder->Fetch())
{
$arOrder["ID"] = $orderInfo["ID"];
}
}
if(strlen($arOrder["ID"]) > 0) // exists site order
{
$dbOrder = CSaleOrder::GetList(array(), array("ACCOUNT_NUMBER" => $arOrder["ID"]), false, false, array("ID", "LID", "PERSON_TYPE_ID", "PAYED", "DATE_PAYED", "CANCELED", "DATE_CANCELED", "REASON_CANCELED", "STATUS_ID", "DATE_STATUS", "PAY_VOUCHER_NUM", "PAY_VOUCHER_DATE", "PRICE_DELIVERY", "ALLOW_DELIVERY", "DATE_ALLOW_DELIVERY", "PRICE", "CURRENCY", "DISCOUNT_VALUE", "USER_ID", "PAY_SYSTEM_ID", "DELIVERY_ID", "DATE_INSERT", "DATE_INSERT_FORMAT", "DATE_UPDATE", "USER_DESCRIPTION", "ADDITIONAL_INFO", "COMMENTS", "TAX_VALUE", "DELIVERY_DOC_NUM", "DELIVERY_DOC_DATE", "STORE_ID", "ACCOUNT_NUMBER", "VERSION", "VERSION_1C", "ID_1C"));
if($orderInfo = $dbOrder->Fetch())
{
if($arOrder["VERSION_1C"] != $orderInfo["VERSION_1C"] || (strlen($orderInfo["VERSION_1C"]) <= 0 || strlen($arOrder["VERSION_1C"]) <= 0)) // skip update if the same version
{
$arOrderFields = array();
$orderId = $orderInfo["ID"];
CSaleOrderChange::AddRecord($orderId, "ORDER_1C_IMPORT");
if($arOrder["ID_1C"] != $orderInfo["ID_1C"])
$arOrderFields["ID_1C"] = $arOrder["ID_1C"];
$arOrderFields["VERSION_1C"] = $arOrder["VERSION_1C"];
if($orderInfo["PAYED"] != "Y" && $orderInfo["ALLOW_DELIVERY"] != "Y" && $orderInfo["STATUS_ID"] != "F")
{
$dbOrderTax = CSaleOrderTax::GetList(
array(),
array("ORDER_ID" => $orderId),
false,
false,
array("ID", "TAX_NAME", "VALUE", "VALUE_MONEY", "CODE", "IS_IN_PRICE")
);
$bTaxFound = false;
if($arOrderTax = $dbOrderTax->Fetch())
{
$bTaxFound = true;
if(IntVal($arOrderTax["VALUE_MONEY"]) != IntVal($arOrder["TAX"]["VALUE_MONEY"]) || IntVal($arOrderTax["VALUE"]) != IntVal($arOrder["TAX"]["VALUE"]) || ($arOrderTax["IS_IN_PRICE"] != $arOrder["TAX"]["IS_IN_PRICE"]))
{
if(IntVal($arOrder["TAX"]["VALUE"])>0)
{
$arFields = Array(
"TAX_NAME" => $arOrder["TAX"]["NAME"],
"ORDER_ID" => $orderId,
"VALUE" => $arOrder["TAX"]["VALUE"],
"IS_PERCENT" => "Y",
"IS_IN_PRICE" => $arOrder["TAX"]["IS_IN_PRICE"],
"VALUE_MONEY" => $arOrder["TAX"]["VALUE_MONEY"],
"CODE" => "VAT1C",
"APPLY_ORDER" => "100"
);
CSaleOrderTax::Update($arOrderTax["ID"], $arFields);
$arOrderFields["TAX_VALUE"] = $arOrder["TAX"]["VALUE_MONEY"];
}
else
{
CSaleOrderTax::Delete($arOrderTax["ID"]);
$arOrderFields["TAX_VALUE"] = 0;
}
}
}
if(!$bTaxFound)
{
if(IntVal($arOrder["TAX"]["VALUE"])>0)
{
$arFields = Array(
"TAX_NAME" => $arOrder["TAX"]["NAME"],
"ORDER_ID" => $orderId,
"VALUE" => $arOrder["TAX"]["VALUE"],
"IS_PERCENT" => "Y",
"IS_IN_PRICE" => $arOrder["TAX"]["IS_IN_PRICE"],
"VALUE_MONEY" => $arOrder["TAX"]["VALUE_MONEY"]
);
CSaleOrderTax::Add($arFields);
$arOrderFields["TAX_VALUE"] = $arOrder["TAX"]["VALUE_MONEY"];
}
}
$arShoppingCart = array();
$bNeedUpdate = false;
$dbBasket = CSaleBasket::GetList(
array("NAME" => "ASC"),
array("ORDER_ID" => $orderId),
false,
false,
array(
"ID",
"QUANTITY",
"CANCEL_CALLBACK_FUNC",
"MODULE",
"PRODUCT_ID",
"PRODUCT_PROVIDER_CLASS",
"RESERVED",
"RESERVE_QUANTITY",
"TYPE",
"SET_PARENT_ID",
"PRICE",
"VAT_RATE",
"DISCOUNT_PRICE",
"PRODUCT_XML_ID",
)
);
while ($arBasket = $dbBasket->Fetch())
{
$arFields = Array();
if(!empty($arOrder["items"][$arBasket["PRODUCT_XML_ID"]]))
{
if($arBasket["QUANTITY"] != $arOrder["items"][$arBasket["PRODUCT_XML_ID"]]["QUANTITY"])
$arFields["QUANTITY"] = $arOrder["items"][$arBasket["PRODUCT_XML_ID"]]["QUANTITY"];
if($arBasket["PRICE"] != $arOrder["items"][$arBasket["PRODUCT_XML_ID"]]["PRICE"])
$arFields["PRICE"] = $arOrder["items"][$arBasket["PRODUCT_XML_ID"]]["PRICE"];
if($arBasket["VAT_RATE"] != $arOrder["items"][$arBasket["PRODUCT_XML_ID"]]["VAT_RATE"])
$arFields["VAT_RATE"] = $arOrder["items"][$arBasket["PRODUCT_XML_ID"]]["VAT_RATE"];
if($arBasket["DISCOUNT_PRICE"] != $arOrder["items"][$arBasket["PRODUCT_XML_ID"]]["DISCOUNT_PRICE"])
$arFields["DISCOUNT_PRICE"] = $arOrder["items"][$arBasket["PRODUCT_XML_ID"]]["DISCOUNT_PRICE"];
if(count($arFields)>0)
{
$arFields["ID"] = $arBasket["ID"];
if(DoubleVal($arFields["QUANTITY"]) <= 0)
$arFields["QUANTITY"] = $arBasket["QUANTITY"];
$bNeedUpdate = true;
$arShoppingCart[] = $arFields;
}
else
{
$arShoppingCart[] = $arBasket;
}
//CSaleBasket::Update($arBasket["ID"], $arFields);
$arOrder["items"][$arBasket["PRODUCT_XML_ID"]]["CHECKED"] = "Y";
}
else
{
if($arOrder["TRAITS"][GetMessage("CC_BSC1_CANCELED")] != "true" && $orderInfo["CANCELED"] == "N")
{
$bNeedUpdate = true;
//CSaleBasket::Delete($arBasket["ID"]);
}
}
}
if(!empty($arOrder["items"]))
{
foreach ($arOrder["items"] as $itemID => $arItem)
{
if ($arItem["CHECKED"] != "Y")
{
if ($arItem["TYPE"] == GetMessage("CC_BSC1_ITEM"))
{
if ($arBasketFields = $this->prepareProduct4Basket($itemID, $arItem, $orderId, $orderInfo))
{
$arShoppingCart[] = $arBasketFields;
$bNeedUpdate = true;
}
}
elseif ($arItem["TYPE"] == GetMessage("CC_BSC1_SERVICE"))
{
if (IntVal($arItem["PRICE"]) != IntVal($orderInfo["PRICE_DELIVERY"]))
$arOrderFields["PRICE_DELIVERY"] = $arItem["PRICE"];
}
}
}
}
if($bNeedUpdate)
{
$arErrors = array();
CSaleBasket::DoSaveOrderBasket($orderId, $orderInfo["LID"], $orderInfo["USER_ID"], $arShoppingCart, $arErrors);
}
if(DoubleVal($arOrder["AMOUNT"]) > 0 && $arOrder["AMOUNT"] != $orderInfo["PRICE"])
$arOrderFields["PRICE"] = $arOrder["AMOUNT"];
if(DoubleVal($orderInfo["DISCOUNT_VALUE"]) > 0)
$arOrderFields["DISCOUNT_VALUE"] = 0;
if(strlen($arOrder["COMMENT"]) > 0 && $arOrder["COMMENT"] != $orderInfo["COMMENTS"])
$arOrderFields["COMMENTS"] = $arOrder["COMMENT"];
$arOrderFields["UPDATED_1C"] = "Y";
if(!empty($arOrderFields))
CSaleOrder::Update($orderId, $arOrderFields);
}
else
{
$this->strError .= "\n".GetMessage("CC_BSC1_FINAL_NOT_EDIT", Array("#ID#" => $orderId));
}
}
$arAditFields = Array();
if($arOrder["TRAITS"][GetMessage("CC_BSC1_CANCELED")] == "true")
{
if($orderInfo["CANCELED"] == "N")
CSaleOrder::CancelOrder($orderInfo["ID"], "Y", $arOrder["COMMENT"]);
$arAditFields["UPDATED_1C"] = "Y";
}
else
{
if(strlen($arOrder["TRAITS"][GetMessage("CC_BSC1_1C_PAYED_DATE")])>1)
{
if($orderInfo["PAYED"]=="N")
CSaleOrder::PayOrder($orderInfo["ID"], "Y");
$arAditFields["PAY_VOUCHER_DATE"] = CDatabase::FormatDate(str_replace("T", " ", $arOrder["TRAITS"][GetMessage("CC_BSC1_1C_PAYED_DATE")]), "YYYY-MM-DD HH:MI:SS", CLang::GetDateFormat("FULL", LANG));
if(strlen($arOrder["TRAITS"][GetMessage("CC_BSC1_1C_PAYED_NUM")])>0)
$arAditFields["PAY_VOUCHER_NUM"] = $arOrder["TRAITS"][GetMessage("CC_BSC1_1C_PAYED_NUM")];
$arAditFields["UPDATED_1C"] = "Y";
}
if(strlen($arOrder["TRAITS"][GetMessage("CC_BSC1_1C_DELIVERY_DATE")])>1)
{
if($orderInfo["ALLOW_DELIVERY"]=="N")
CSaleOrder::DeliverOrder($orderInfo["ID"], "Y");
$arAditFields["DATE_ALLOW_DELIVERY"] = CDatabase::FormatDate(str_replace("T", " ", $arOrder["TRAITS"][GetMessage("CC_BSC1_1C_DELIVERY_DATE")]), "YYYY-MM-DD HH:MI:SS", CLang::GetDateFormat("FULL", LANG));
if(strlen($this->arParams["FINAL_STATUS_ON_DELIVERY"])>0 && $orderInfo["STATUS_ID"] != "F" && $orderInfo["STATUS_ID"] != $this->arParams["FINAL_STATUS_ON_DELIVERY"])
CSaleOrder::StatusOrder($orderInfo["ID"], $this->arParams["FINAL_STATUS_ON_DELIVERY"]);
$arAditFields["UPDATED_1C"] = "Y";
}
}
if(count($arAditFields)>0)
CSaleOrder::Update($orderInfo["ID"], $arAditFields);
}
else
$this->strError .= "\n".GetMessage("CC_BSC1_ORDER_NOT_FOUND", Array("#ID#" => $arOrder["ID"]));
}
elseif($this->arParams["IMPORT_NEW_ORDERS"] == "Y") // create new order (ofline 1C)
{
if(!empty($arOrder["AGENT"]) && strlen($arOrder["AGENT"]["ID"]) > 0)
{
$arOrder["PERSON_TYPE_ID"] = 0;
$arOrder["USER_ID"] = 0;
$arErrors = array();
$dbUProp = CSaleOrderUserProps::GetList(array(), array("XML_ID" => $arOrder["AGENT"]["ID"]), false, false, array("ID", "NAME", "USER_ID", "PERSON_TYPE_ID", "XML_ID", "VERSION_1C"));
if($arUProp = $dbUProp->Fetch())
{
$arOrder["USER_ID"] = $arUProp["USER_ID"];
$arOrder["PERSON_TYPE_ID"] = $arUProp["PERSON_TYPE_ID"];
$arOrder["USER_PROFILE_ID"] = $arUProp["ID"];
$arOrder["USER_PROFILE_VERSION"] = $arUProp["VERSION_1C"];
$dbUPropValue = CSaleOrderUserPropsValue::GetList(array(), array("USER_PROPS_ID" => $arUProp["ID"]));
while($arUPropValue = $dbUPropValue->Fetch())
{
$arOrder["USER_PROPS"][$arUPropValue["ORDER_PROPS_ID"]] = $arUPropValue["VALUE"];
}
}
else
{
if(strlen($arOrder["AGENT"]["ID"]) > 0)
{
$arAI = explode("#", $arOrder["AGENT"]["ID"]);
if(IntVal($arAI[0]) > 0)
{
$dbUser = CUser::GetByID($arAI[0]);
if($arU = $dbUser->Fetch())
{
if(htmlspecialcharsback(substr(htmlspecialcharsbx($arU["ID"]."#".$arU["LOGIN"]."#".$arU["LAST_NAME"]." ".$arU["NAME"]." ".$arU["SECOND_NAME"]), 0, 80)) == $arOrder["AGENT"]["ID"])
{
$arOrder["USER_ID"] = $arU["ID"];
}
}
}
}
if(IntVal($arOrder["USER_ID"]) <= 0)
{
//create new user
$arUser = array(
"NAME" => $arOrder["AGENT"]["ITEM_NAME"],
"EMAIL" => $arOrder["AGENT"]["CONTACT"]["MAIL_NEW"],
);
if (strlen($arUser["NAME"]) <= 0)
$arUser["NAME"] = $arOrder["AGENT"]["CONTACT"]["CONTACT_PERSON"];
if (strlen($arUser["EMAIL"]) <= 0)
$arUser["EMAIL"] = "buyer".time().GetRandomCode(2)."@".$_SERVER["SERVER_NAME"];
$arOrder["USER_ID"] = CSaleUser::DoAutoRegisterUser($arUser["EMAIL"], $arUser["NAME"], $this->arParams["SITE_NEW_ORDERS"], $arErrors);
}
}
if(empty($this->arPersonTypesIDs))
{
$dbPT = CSalePersonType::GetList(array(), array("ACTIVE" => "Y", "LIDS" => $this->arParams["SITE_NEW_ORDERS"]));
while($arPT = $dbPT->Fetch())
{
$this->arPersonTypesIDs[] = $arPT["ID"];
}
}
if(empty($this->arExportInfo))
{
$dbExport = CSaleExport::GetList(array(), array("PERSON_TYPE_ID" => $this->arPersonTypesIDs));
while($arExport = $dbExport->Fetch())
{
$this->arExportInfo[$arExport["PERSON_TYPE_ID"]] = unserialize($arExport["VARS"]);
}
}
if(IntVal($arOrder["PERSON_TYPE_ID"]) <= 0)
{
foreach($this->arExportInfo as $pt => $value)
{
if(
(($value["IS_FIZ"] == "Y" && $arOrder["AGENT"]["TYPE"] == "FIZ")
|| ($value["IS_FIZ"] == "N" && $arOrder["AGENT"]["TYPE"] != "FIZ"))
)
$arOrder["PERSON_TYPE_ID"] = $pt;
}
}
if(IntVal($arOrder["PERSON_TYPE_ID"]) > 0)
{
$arAgent = $this->arExportInfo[$arOrder["PERSON_TYPE_ID"]];
foreach($arAgent as $k => $v)
{
if((strlen($v["VALUE"]) <= 0 || $v["TYPE"] != "PROPERTY") && (empty($arOrder["USER_PROPS"]) || empty($arOrder["USER_PROPS"][$v["VALUE"]])))
unset($arAgent[$k]);
}
if(IntVal($arOrder["USER_ID"]) > 0)
{
$orderFields = array(
"SITE_ID" => $this->arParams["SITE_NEW_ORDERS"],
"PERSON_TYPE_ID" => $arOrder["PERSON_TYPE_ID"],
"PAYED" => "N",
"CANCELED" => "N",
"STATUS_ID" => "N",
"PRICE" => $arOrder["AMOUNT"],
"CURRENCY" => CSaleLang::GetLangCurrency($this->arParams["SITE_NEW_ORDERS"]),
"USER_ID" => $arOrder["USER_ID"],
"TAX_VALUE" => doubleval($arOrder["TAX"]["VALUE_MONEY"]),
"COMMENTS" => $arOrder["COMMENT"],
"BASKET_ITEMS" => array(),
"TAX_LIST" => array(),
"ORDER_PROP" => array(),
);
$arAditFields = array(
"EXTERNAL_ORDER" => "Y",
"ID_1C" => $arOrder["ID_1C"],
"VERSION_1C" => $arOrder["VERSION_1C"],
"UPDATED_1C" => "Y",
"DATE_INSERT" => CDatabase::FormatDate($arOrder["DATE"]." ".$arOrder["TIME"], "YYYY-MM-DD HH:MI:SS", CLang::GetDateFormat("FULL", LANG)),
);
foreach($arOrder["items"] as $productID => $val)
{
$orderFields["BASKET_ITEMS"][] = $this->prepareProduct4Basket($productID, $val, false, $orderFields);
}
if(!empty($arOrder["TAX"]))
{
$orderFields["TAX_LIST"][] = array(
"NAME" => $arOrder["TAX"]["NAME"],
"IS_PERCENT" => "Y",
"VALUE" => $arOrder["TAX"]["VALUE"],
"VALUE_MONEY" => $arOrder["TAX"]["VALUE_MONEY"],
"IS_IN_PRICE" => $arOrder["TAX"]["IS_IN_PRICE"],
);
}
foreach($arAgent as $k => $v)
{
if(!empty($arOrder["ORDER_PROPS"][$k]))
{
$orderFields["ORDER_PROP"][$v["VALUE"]] = $arOrder["ORDER_PROPS"][$k];
}
if(empty($orderFields["ORDER_PROP"][$v["VALUE"]]) && !empty($arOrder["USER_PROPS"][$v["VALUE"]]))
{
$orderFields["ORDER_PROP"][$v["VALUE"]] = $arOrder["USER_PROPS"][$v["VALUE"]];
}
}
if($arOrder["ID"] = CSaleOrder::DoSaveOrder($orderFields, $arAditFields, 0, $arErrors))
{
$arAditFields = array("UPDATED_1C" => "Y");
CSaleOrder::Update($arOrder["ID"], $arAditFields);
//add/update user profile
if(IntVal($arOrder["USER_PROFILE_ID"]) > 0)
{
if($arOrder["USER_PROFILE_VERSION"] != $arOrder["AGENT"]["VERSION"])
CSaleOrderUserProps::Update($arOrder["USER_PROFILE_ID"], array("VERSION_1C" => $arOrder["AGENT"]["VERSION"], "NAME" => $arOrder["AGENT"]["AGENT_NAME"]));
$dbUPV = CSaleOrderUserPropsValue::GetList(array(), array("USER_PROPS_ID" =>$arOrder["USER_PROFILE_ID"]));
while($arUPV = $dbUPV->Fetch())
{
$arOrder["AGENT"]["PROFILE_PROPS_VALUE"][$arUPV["ORDER_PROPS_ID"]] = array("ID" => $arUPV["ID"], "VALUE" => $arUPV["VALUE"]);
}
}
if(IntVal($arOrder["USER_PROFILE_ID"]) <= 0 || (IntVal($arOrder["USER_PROFILE_ID"]) > 0 && $arOrder["USER_PROFILE_VERSION"] != $arOrder["AGENT"]["VERSION"]))
{
$dbOrderProperties = CSaleOrderProps::GetList(
array("SORT" => "ASC"),
array(
"PERSON_TYPE_ID" => $arOrder["PERSON_TYPE_ID"],
"ACTIVE" => "Y",
"UTIL" => "N",
"USER_PROPS" => "Y",
),
false,
false,
array("ID", "TYPE", "NAME", "CODE", "USER_PROPS", "SORT", "MULTIPLE")
);
while ($arOrderProperties = $dbOrderProperties->Fetch())
{
$curVal = $orderFields["ORDER_PROP"][$arOrderProperties["ID"]];
if (strlen($curVal) > 0)
{
if (IntVal($arOrder["USER_PROFILE_ID"]) <= 0)
{
$arFields = array(
"NAME" => $arOrder["AGENT"]["AGENT_NAME"],
"USER_ID" => $arOrder["USER_ID"],
"PERSON_TYPE_ID" => $arOrder["PERSON_TYPE_ID"],
"XML_ID" => $arOrder["AGENT"]["ID"],
"VERSION_1C" => $arOrder["AGENT"]["VERSION"],
);
$arOrder["USER_PROFILE_ID"] = CSaleOrderUserProps::Add($arFields);
}
if(IntVal($arOrder["USER_PROFILE_ID"]) > 0)
{
$arFields = array(
"USER_PROPS_ID" => $arOrder["USER_PROFILE_ID"],
"ORDER_PROPS_ID" => $arOrderProperties["ID"],
"NAME" => $arOrderProperties["NAME"],
"VALUE" => $curVal
);
if(empty($arOrder["AGENT"]["PROFILE_PROPS_VALUE"][$arOrderProperties["ID"]]))
{
CSaleOrderUserPropsValue::Add($arFields);
}
elseif($arOrder["AGENT"]["PROFILE_PROPS_VALUE"][$arOrderProperties["ID"]]["VALUE"] != $curVal)
{
CSaleOrderUserPropsValue::Update($arOrder["AGENT"]["PROFILE_PROPS_VALUE"][$arOrderProperties["ID"]]["ID"], $arFields);
}
}
}
}
}
}
else
{
$this->strError .= "\n".GetMessage("CC_BSC1_ORDER_ADD_PROBLEM", Array("#ID#" => $arOrder["ID_1C"]));
}
}
else
{
$this->strError .= "\n".GetMessage("CC_BSC1_ORDER_USER_PROBLEM", Array("#ID#" => $arOrder["ID_1C"]));
if(!empty($arErrors))
{
foreach($arErrors as $v)
{
$this->strError .= "\n".$v["TEXT"];
}
}
}
}
else
{
$this->strError .= "\n".GetMessage("CC_BSC1_ORDER_PERSON_TYPE_PROBLEM", Array("#ID#" => $arOrder["ID_1C"]));
}
}
else
{
$this->strError .= "\n".GetMessage("CC_BSC1_ORDER_NO_AGENT_ID", Array("#ID#" => $arOrder["ID_1C"]));
}
}
}
}
elseif($this->arParams["IMPORT_NEW_ORDERS"] == "Y")
{
$value = $value[GetMessage("CC_BSC1_AGENT")]["#"];
$arAgentInfo = $this->collectAgentInfo($value);
if(!empty($arAgentInfo["AGENT"]))
{
$mode = false;
$arErrors = array();
$dbUProp = CSaleOrderUserProps::GetList(array(), array("XML_ID" => $arAgentInfo["AGENT"]["ID"]), false, false, array("ID", "NAME", "USER_ID", "PERSON_TYPE_ID", "XML_ID", "VERSION_1C"));
if($arUProp = $dbUProp->Fetch())
{
if($arUProp["VERSION_1C"] != $arAgentInfo["AGENT"]["VERSION"])
{
$mode = "update";
$arAgentInfo["PROFILE_ID"] = $arUProp["ID"];
$arAgentInfo["PERSON_TYPE_ID"] = $arUProp["PERSON_TYPE_ID"];
}
}
else
{
$arUser = array(
"NAME" => $arAgentInfo["AGENT"]["ITEM_NAME"],
"EMAIL" => $arAgentInfo["AGENT"]["CONTACT"]["MAIL_NEW"],
);
if(strlen($arUser["NAME"]) <= 0)
$arUser["NAME"] = $arAgentInfo["AGENT"]["CONTACT"]["CONTACT_PERSON"];
$emServer = $_SERVER["SERVER_NAME"];
if(strpos($_SERVER["SERVER_NAME"], ".") === false)
$emServer .= ".bx";
if(strlen($arUser["EMAIL"]) <= 0)
$arUser["EMAIL"] = "buyer".time().GetRandomCode(2)."@".$emServer;
$arAgentInfo["USER_ID"] = CSaleUser::DoAutoRegisterUser($arUser["EMAIL"], $arUser["NAME"], $this->arParams["SITE_NEW_ORDERS"], $arErrors);
if(IntVal($arAgentInfo["USER_ID"]) > 0)
{
$mode = "add";
}
else
{
$this->strError .= "\n".GetMessage("CC_BSC1_AGENT_USER_PROBLEM", Array("#ID#" => $arAgentInfo["AGENT"]["ID"]));
if(!empty($arErrors))
{
foreach($arErrors as $v)
{
$this->strError .= "\n".$v["TEXT"];
}
}
}
}
if($mode)
{
if(empty($this->arPersonTypesIDs))
{
$dbPT = CSalePersonType::GetList(array(), array("ACTIVE" => "Y", "LIDS" => $this->arParams["SITE_NEW_ORDERS"]));
while($arPT = $dbPT->Fetch())
{
$this->arPersonTypesIDs[] = $arPT["ID"];
}
}
if(empty($this->arExportInfo))
{
$dbExport = CSaleExport::GetList(array(), array("PERSON_TYPE_ID" => $this->arPersonTypesIDs));
while($arExport = $dbExport->Fetch())
{
$this->arExportInfo[$arExport["PERSON_TYPE_ID"]] = unserialize($arExport["VARS"]);
}
}
if(IntVal($arAgentInfo["PERSON_TYPE_ID"]) <= 0)
{
foreach($this->arExportInfo as $pt => $value)
{
if(($value["IS_FIZ"] == "Y" && $arAgentInfo["AGENT"]["TYPE"] == "FIZ")
|| ($value["IS_FIZ"] == "N" && $arAgentInfo["AGENT"]["TYPE"] != "FIZ")
)
$arAgentInfo["PERSON_TYPE_ID"] = $pt;
}
}
if(IntVal($arAgentInfo["PERSON_TYPE_ID"]) > 0)
{
$arAgentInfo["ORDER_PROPS_VALUE"] = array();
$arAgentInfo["PROFILE_PROPS_VALUE"] = array();
$arAgent = $this->arExportInfo[$arAgentInfo["PERSON_TYPE_ID"]];
foreach($arAgent as $k => $v)
{
if(strlen($v["VALUE"]) <= 0 || $v["TYPE"] != "PROPERTY")
unset($arAgent[$k]);
}
foreach($arAgent as $k => $v)
{
if(!empty($arAgentInfo["ORDER_PROPS"][$k]))
$arAgentInfo["ORDER_PROPS_VALUE"][$v["VALUE"]] = $arAgentInfo["ORDER_PROPS"][$k];
}
if (IntVal($arAgentInfo["PROFILE_ID"]) > 0)
{
CSaleOrderUserProps::Update($arUProp["ID"], array("VERSION_1C" => $arAgentInfo["AGENT"]["VERSION"], "NAME" => $arAgentInfo["AGENT"]["AGENT_NAME"]));
$dbUPV = CSaleOrderUserPropsValue::GetList(array(), array("USER_PROPS_ID" => $arAgentInfo["PROFILE_ID"]));
while($arUPV = $dbUPV->Fetch())
{
$arAgentInfo["PROFILE_PROPS_VALUE"][$arUPV["ORDER_PROPS_ID"]] = array("ID" => $arUPV["ID"], "VALUE" => $arUPV["VALUE"]);
}
}
if(empty($this->arOrderProps[$arAgentInfo["PERSON_TYPE_ID"]]))
{
$dbOrderProperties = CSaleOrderProps::GetList(
array("SORT" => "ASC"),
array(
"PERSON_TYPE_ID" => $arAgentInfo["PERSON_TYPE_ID"],
"ACTIVE" => "Y",
"UTIL" => "N",
"USER_PROPS" => "Y",
),
false,
false,
array("ID", "TYPE", "NAME", "CODE", "USER_PROPS", "SORT", "MULTIPLE")
);
while ($arOrderProperties = $dbOrderProperties->Fetch())
{
$this->arOrderProps[$arAgentInfo["PERSON_TYPE_ID"]][] = $arOrderProperties;
}
}
foreach($this->arOrderProps[$arAgentInfo["PERSON_TYPE_ID"]] as $arOrderProperties)
{
$curVal = $arAgentInfo["ORDER_PROPS_VALUE"][$arOrderProperties["ID"]];
if (strlen($curVal) > 0)
{
if (IntVal($arAgentInfo["PROFILE_ID"]) <= 0)
{
$arFields = array(
"NAME" => $arAgentInfo["AGENT"]["AGENT_NAME"],
"USER_ID" => $arAgentInfo["USER_ID"],
"PERSON_TYPE_ID" => $arAgentInfo["PERSON_TYPE_ID"],
"XML_ID" => $arAgentInfo["AGENT"]["ID"],
"VERSION_1C" => $arAgentInfo["AGENT"]["VERSION"],
);
$arAgentInfo["PROFILE_ID"] = CSaleOrderUserProps::Add($arFields);
}
if(IntVal($arAgentInfo["PROFILE_ID"]) > 0)
{
$arFields = array(
"USER_PROPS_ID" => $arAgentInfo["PROFILE_ID"],
"ORDER_PROPS_ID" => $arOrderProperties["ID"],
"NAME" => $arOrderProperties["NAME"],
"VALUE" => $curVal
);
if(empty($arAgentInfo["PROFILE_PROPS_VALUE"][$arOrderProperties["ID"]]))
{
CSaleOrderUserPropsValue::Add($arFields);
}
elseif($arAgentInfo["PROFILE_PROPS_VALUE"][$arOrderProperties["ID"]]["VALUE"] != $curVal)
{
CSaleOrderUserPropsValue::Update($arAgentInfo["PROFILE_PROPS_VALUE"][$arOrderProperties["ID"]]["ID"], $arFields);
}
}
}
}
}
else
{
$this->strError .= "\n".GetMessage("CC_BSC1_AGENT_PERSON_TYPE_PROBLEM", Array("#ID#" => $arAgentInfo["AGENT"]["ID"]));
}
}
}
else
{
$this->strError .= "\n".GetMessage("CC_BSC1_AGENT_NO_AGENT_ID");
}
}
}
function ExportOrders2Xml($arFilter = Array(), $nTopCount = 0, $currency = "", $crmMode = false, $time_limit = 0, $version = false, $arOptions = Array())
{
global $DB;
$count = false;
if(IntVal($nTopCount) > 0)
$count = Array("nTopCount" => $nTopCount);
$bNewVersion = (strlen($version) > 0);
$bExportFromCrm = (isset($arOptions["EXPORT_FROM_CRM"]) && $arOptions["EXPORT_FROM_CRM"] === "Y");
if(IntVal($time_limit) > 0)
{
//This is an optimization. We assume than no step can take more than one year.
if($time_limit > 0)
$end_time = time() + $time_limit;
else
$end_time = time() + 365*24*3600; // One year
//$version
$lastOrderPrefix = "LAST_ORDER_ID";
if($crmMode)
{
$lastOrderPrefix = md5(serialize($arFilter));
if(!empty($_SESSION["BX_CML2_EXPORT"][$lastOrderPrefix]) && IntVal($nTopCount) > 0)
$count["nTopCount"] = $count["nTopCount"]+count($_SESSION["BX_CML2_EXPORT"][$lastOrderPrefix]);
}
else
{
if(IntVal($_SESSION["BX_CML2_EXPORT"][$lastOrderPrefix]) > 0)
{
$arFilter["<ID"] = $_SESSION["BX_CML2_EXPORT"][$lastOrderPrefix];
}
}
}
$arResultStat = array(
"ORDERS" => 0,
"CONTACTS" => 0,
"COMPANIES" => 0,
);
$accountNumberPrefix = COption::GetOptionString("sale", "1C_SALE_ACCOUNT_NUMBER_SHOP_PREFIX", "");
$dbPaySystem = CSalePaySystem::GetList(Array("ID" => "ASC"), Array("ACTIVE" => "Y"), false, false, Array("ID", "NAME", "ACTIVE"));
while($arPaySystem = $dbPaySystem -> Fetch())
$paySystems[$arPaySystem["ID"]] = $arPaySystem["NAME"];
$dbDelivery = CSaleDelivery::GetList(Array("ID" => "ASC"), Array("ACTIVE" => "Y"), false, false, Array("ID", "NAME", "ACTIVE"));
while($arDelivery = $dbDelivery -> Fetch())
$delivery[$arDelivery["ID"]] = $arDelivery["NAME"];
$rsDeliveryHandlers = CSaleDeliveryHandler::GetAdminList(array("SID" => "ASC"));
while ($arHandler = $rsDeliveryHandlers->Fetch())
{
if(is_array($arHandler["PROFILES"]))
{
foreach($arHandler["PROFILES"] as $k => $v)
{
$delivery[$arHandler["SID"].":".$k] = $v["TITLE"]." (".$arHandler["NAME"].")";
}
}
}
$arStore = array();
$arMeasures = array();
if(CModule::IncludeModule("catalog"))
{
$dbList = CCatalogStore::GetList(
array("SORT" => "DESC", "ID" => "ASC"),
array("ACTIVE" => "Y", "ISSUING_CENTER" => "Y"),
false,
false,
array("ID", "SORT", "TITLE", "ADDRESS", "DESCRIPTION", "PHONE", "EMAIL", "XML_ID")
);
while ($arStoreTmp = $dbList->Fetch())
{
if(strlen($arStoreTmp["XML_ID"]) <= 0)
$arStoreTmp["XML_ID"] = $arStoreTmp["ID"];
$arStore[$arStoreTmp["ID"]] = $arStoreTmp;
}
$dbList = CCatalogMeasure::getList(array(), array(), false, false, array("CODE", "MEASURE_TITLE"));
while($arList = $dbList->Fetch())
{
$arMeasures[$arList["CODE"]] = $arList["MEASURE_TITLE"];
}
}
if(empty($arMeasures))
$arMeasures[796] = GetMessage("SALE_EXPORT_SHTUKA");
$dbExport = CSaleExport::GetList();
while($arExport = $dbExport->Fetch())
{
$arAgent[$arExport["PERSON_TYPE_ID"]] = unserialize($arExport["VARS"]);
}
$dateFormat = CSite::GetDateFormat("FULL");
if ($crmMode)
{
echo "<"."?xml version=\"1.0\" encoding=\"UTF-8\"?".">\n";
$arCharSets = array();
$dbSitesList = CSite::GetList(($b=""), ($o=""));
while ($arSite = $dbSitesList->Fetch())
$arCharSets[$arSite["ID"]] = $arSite["CHARSET"];
}
else
echo "<"."?xml version=\"1.0\" encoding=\"windows-1251\"?".">\n";
?>
<<?php
echo GetMessage("SALE_EXPORT_COM_INFORMATION");
?>
<?php
echo GetMessage("SALE_EXPORT_SHEM_VERSION");
?>
="<?php
echo $bNewVersion ? "2.08" : "2.05";
?>
" <?php
echo GetMessage("SALE_EXPORT_SHEM_DATE_CREATE");
?>
="<?php
echo date("Y-m-d");
?>
T<?php
echo date("G:i:s");
?>
" <?php
echo GetMessage("SALE_EXPORT_DATE_FORMAT");
?>
="<?php
echo GetMessage("SALE_EXPORT_DATE_FORMAT_DF");
?>
=yyyy-MM-dd; <?php
echo GetMessage("SALE_EXPORT_DATE_FORMAT_DLF");
?>
=DT" <?php
echo GetMessage("SALE_EXPORT_DATE_FORMAT_DATETIME");
?>
="<?php
echo GetMessage("SALE_EXPORT_DATE_FORMAT_DF");
?>
=<?php
echo GetMessage("SALE_EXPORT_DATE_FORMAT_TIME");
?>
; <?php
echo GetMessage("SALE_EXPORT_DATE_FORMAT_DLF");
?>
=T" <?php
echo GetMessage("SALE_EXPORT_DEL_DT");
?>
="T" <?php
echo GetMessage("SALE_EXPORT_FORM_SUMM");
?>
="<?php
echo GetMessage("SALE_EXPORT_FORM_CC");
?>
=18; <?php
echo GetMessage("SALE_EXPORT_FORM_CDC");
?>
=2; <?php
echo GetMessage("SALE_EXPORT_FORM_CRD");
?>
=." <?php
echo GetMessage("SALE_EXPORT_FORM_QUANT");
?>
="<?php
echo GetMessage("SALE_EXPORT_FORM_CC");
?>
=18; <?php
echo GetMessage("SALE_EXPORT_FORM_CDC");
?>
=2; <?php
echo GetMessage("SALE_EXPORT_FORM_CRD");
?>
=.">
<?
$arOrder = array("ID" => "DESC");
if ($crmMode)
$arOrder = array("DATE_UPDATE" => "ASC");
$arSelect = array(
"ID", "LID", "PERSON_TYPE_ID", "PAYED", "DATE_PAYED", "EMP_PAYED_ID", "CANCELED", "DATE_CANCELED",
"EMP_CANCELED_ID", "REASON_CANCELED", "STATUS_ID", "DATE_STATUS", "PAY_VOUCHER_NUM", "PAY_VOUCHER_DATE", "EMP_STATUS_ID",
"PRICE_DELIVERY", "ALLOW_DELIVERY", "DATE_ALLOW_DELIVERY", "EMP_ALLOW_DELIVERY_ID", "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", "ACCOUNT_NUMBER", "SUM_PAID", "DELIVERY_DOC_DATE", "DELIVERY_DOC_NUM", "TRACKING_NUMBER", "STORE_ID",
"ID_1C", "VERSION",
);
$bCrmModuleIncluded = false;
if ($bExportFromCrm)
{
$arSelect[] = "UF_COMPANY_ID";
$arSelect[] = "UF_CONTACT_ID";
if (IsModuleInstalled("crm") && CModule::IncludeModule("crm"))
$bCrmModuleIncluded = true;
}
$dbOrderList = CSaleOrder::GetList($arOrder, $arFilter, false, $count, $arSelect);
while($arOrder = $dbOrderList->Fetch())
{
if ($crmMode)
{
if($bNewVersion && is_array($_SESSION["BX_CML2_EXPORT"][$lastOrderPrefix]) && in_array($arOrder["ID"], $_SESSION["BX_CML2_EXPORT"][$lastOrderPrefix]) && empty($arFilter["ID"]))
continue;
ob_start();
}
$arResultStat["ORDERS"]++;
$agentParams = $arAgent[$arOrder["PERSON_TYPE_ID"]];
$arProp = Array();
$arProp["ORDER"] = $arOrder;
if (IntVal($arOrder["USER_ID"]) > 0)
{
$dbUser = CUser::GetByID($arOrder["USER_ID"]);
if ($arUser = $dbUser->Fetch())
$arProp["USER"] = $arUser;
}
if ($bExportFromCrm)
{
$arProp["CRM"] = array();
$companyID = isset($arOrder["UF_COMPANY_ID"]) ? intval($arOrder["UF_COMPANY_ID"]) : 0;
$contactID = isset($arOrder["UF_CONTACT_ID"]) ? intval($arOrder["UF_CONTACT_ID"]) : 0;
if ($companyID > 0)
{
$arProp["CRM"]["CLIENT_ID"] = "CRMCO".$companyID;
}
else
{
$arProp["CRM"]["CLIENT_ID"] = "CRMC".$contactID;
}
$clientInfo = array(
"LOGIN" => "",
"NAME" => "",
"LAST_NAME" => "",
"SECOND_NAME" => ""
);
if ($bCrmModuleIncluded)
{
if ($companyID > 0)
{
$arCompanyFilter = array('=ID' => $companyID);
$dbCompany = CCrmCompany::GetListEx(
array(), $arCompanyFilter, false, array("nTopCount" => 1),
array("TITLE")
);
$arCompany = $dbCompany->Fetch();
unset($dbCompany, $arCompanyFilter);
if (is_array($arCompany))
{
if (isset($arCompany["TITLE"]))
$clientInfo["NAME"] = $arCompany["TITLE"];
}
unset($arCompany);
}
else if ($contactID > 0)
{
$arContactFilter = array('=ID' => $contactID);
$dbContact = CCrmContact::GetListEx(
array(), $arContactFilter, false, array("nTopCount" => 1),
array("NAME", "LAST_NAME", "SECOND_NAME")
);
$arContact = $dbContact->Fetch();
unset($dbContact, $arContactFilter);
if (is_array($arContact))
{
if (isset($arContact["NAME"]))
$clientInfo["NAME"] = $arContact["NAME"];
if (isset($arContact["LAST_NAME"]))
$clientInfo["LAST_NAME"] = $arContact["LAST_NAME"];
if (isset($arContact["SECOND_NAME"]))
$clientInfo["SECOND_NAME"] = $arContact["SECOND_NAME"];
}
unset($arContact);
}
}
$arProp["CRM"]["CLIENT"] = $clientInfo;
unset($clientInfo);
}
if(IntVal($arOrder["PAY_SYSTEM_ID"]) > 0)
$arProp["ORDER"]["PAY_SYSTEM_NAME"] = $paySystems[$arOrder["PAY_SYSTEM_ID"]];
if(strlen($arOrder["DELIVERY_ID"]) > 0)
$arProp["ORDER"]["DELIVERY_NAME"] = $delivery[$arOrder["DELIVERY_ID"]];
$dbOrderPropVals = CSaleOrderPropsValue::GetList(
array(),
array("ORDER_ID" => $arOrder["ID"]),
false,
false,
array("ID", "CODE", "VALUE", "ORDER_PROPS_ID", "PROP_TYPE")
);
while ($arOrderPropVals = $dbOrderPropVals->Fetch())
{
if ($arOrderPropVals["PROP_TYPE"] == "CHECKBOX")
{
if ($arOrderPropVals["VALUE"] == "Y")
$arProp["PROPERTY"][$arOrderPropVals["ORDER_PROPS_ID"]] = "true";
else
$arProp["PROPERTY"][$arOrderPropVals["ORDER_PROPS_ID"]] = "false";
}
elseif ($arOrderPropVals["PROP_TYPE"] == "TEXT" || $arOrderPropVals["PROP_TYPE"] == "TEXTAREA")
{
$arProp["PROPERTY"][$arOrderPropVals["ORDER_PROPS_ID"]] = $arOrderPropVals["VALUE"];
}
elseif ($arOrderPropVals["PROP_TYPE"] == "SELECT" || $arOrderPropVals["PROP_TYPE"] == "RADIO")
{
$arVal = CSaleOrderPropsVariant::GetByValue($arOrderPropVals["ORDER_PROPS_ID"], $arOrderPropVals["VALUE"]);
$arProp["PROPERTY"][$arOrderPropVals["ORDER_PROPS_ID"]] = $arVal["NAME"];
}
elseif ($arOrderPropVals["PROP_TYPE"] == "MULTISELECT")
{
$curVal = explode(",", $arOrderPropVals["VALUE"]);
foreach($curVal as $vm)
{
$arVal = CSaleOrderPropsVariant::GetByValue($arOrderPropVals["ORDER_PROPS_ID"], $vm);
$arProp["PROPERTY"][$arOrderPropVals["ORDER_PROPS_ID"]] .= ", ".$arVal["NAME"];
}
$arProp["PROPERTY"][$arOrderPropVals["ORDER_PROPS_ID"]] = substr($arProp["PROPERTY"][$arOrderPropVals["ORDER_PROPS_ID"]], 2);
}
elseif ($arOrderPropVals["PROP_TYPE"] == "LOCATION")
{
$arVal = CSaleLocation::GetByID($arOrderPropVals["VALUE"], LANGUAGE_ID);
$arProp["PROPERTY"][$arOrderPropVals["ORDER_PROPS_ID"]] = ($arVal["COUNTRY_NAME"].((strlen($arVal["COUNTRY_NAME"])<=0 || strlen($arVal["REGION_NAME"])<=0) ? "" : " - ").$arVal["REGION_NAME"].((strlen($arVal["COUNTRY_NAME"])<=0 || strlen($arVal["CITY_NAME"])<=0) ? "" : " - ").$arVal["CITY_NAME"]);
$arProp["PROPERTY"][$arOrderPropVals["ORDER_PROPS_ID"]."_CITY"] = $arVal["CITY_NAME"];
$arProp["PROPERTY"][$arOrderPropVals["ORDER_PROPS_ID"]."_COUNTRY"] = $arVal["COUNTRY_NAME"];
$arProp["PROPERTY"][$arOrderPropVals["ORDER_PROPS_ID"]."_REGION"] = $arVal["REGION_NAME"];
}
else
{
$arProp["PROPERTY"][$arOrderPropVals["ORDER_PROPS_ID"]] = $arOrderPropVals["VALUE"];
}
}
foreach($agentParams as $k => $v)
{
if(strpos($k, "REKV_") !== false)
{
if(!is_array($v))
{
$agent["REKV"][$k] = $v;
}
else
{
if(strlen($v["TYPE"])<=0)
$agent["REKV"][$k] = $v["VALUE"];
else
$agent["REKV"][$k] = $arProp[$v["TYPE"]][$v["VALUE"]];
}
}
else
{
if(!is_array($v))
{
$agent[$k] = $v;
}
else
{
if(strlen($v["TYPE"])<=0)
$agent[$k] = $v["VALUE"];
else
$agent[$k] = $arProp[$v["TYPE"]][$v["VALUE"]];
}
}
}
?>
<<?php
echo GetMessage("SALE_EXPORT_DOCUMENT");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ID");
?>
><?php
echo $arOrder["ID"];
?>
</<?php
echo GetMessage("SALE_EXPORT_ID");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_NUMBER");
?>
><?php
echo $accountNumberPrefix . $arOrder["ACCOUNT_NUMBER"];
?>
</<?php
echo GetMessage("SALE_EXPORT_NUMBER");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_DATE");
?>
><?php
echo $DB->FormatDate($arOrder["DATE_INSERT_FORMAT"], $dateFormat, "YYYY-MM-DD");
?>
</<?php
echo GetMessage("SALE_EXPORT_DATE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_HOZ_OPERATION");
?>
><?php
echo GetMessage("SALE_EXPORT_ITEM_ORDER");
?>
</<?php
echo GetMessage("SALE_EXPORT_HOZ_OPERATION");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ROLE");
?>
><?php
echo GetMessage("SALE_EXPORT_SELLER");
?>
</<?php
echo GetMessage("SALE_EXPORT_ROLE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_CURRENCY");
?>
><?php
echo htmlspecialcharsbx(strlen($currency) > 0 ? substr($currency, 0, 3) : substr($arOrder["CURRENCY"], 0, 3));
?>
</<?php
echo GetMessage("SALE_EXPORT_CURRENCY");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_CURRENCY_RATE");
?>
>1</<?php
echo GetMessage("SALE_EXPORT_CURRENCY_RATE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_AMOUNT");
?>
><?php
echo $arOrder["PRICE"];
?>
</<?php
echo GetMessage("SALE_EXPORT_AMOUNT");
?>
>
<?
if($bNewVersion)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_VERSION");
?>
><?php
echo IntVal($arOrder["VERSION"]) > 0 ? $arOrder["VERSION"] : 0;
?>
</<?php
echo GetMessage("SALE_EXPORT_VERSION");
?>
>
<?
if(strlen($arOrder["ID_1C"]) > 0)
{
?><<?php
echo GetMessage("SALE_EXPORT_ID_1C");
?>
><?php
echo htmlspecialcharsbx($arOrder["ID_1C"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_ID_1C");
?>
><?
}
}
if ($crmMode)
{
?><DateUpdate><?php
echo $DB->FormatDate($arOrder["DATE_UPDATE"], $dateFormat, "YYYY-MM-DD HH:MI:SS");
?>
</DateUpdate><?
}
$deliveryAdr = CSaleExport::ExportContragents(
$arOrder, $arProp, $agent, $arResultStat, $bNewVersion,
$bExportFromCrm ? array("EXPORT_FROM_CRM" => "Y") : array()
);
?>
<<?php
echo GetMessage("SALE_EXPORT_TIME");
?>
><?php
echo $DB->FormatDate($arOrder["DATE_INSERT_FORMAT"], $dateFormat, "HH:MI:SS");
?>
</<?php
echo GetMessage("SALE_EXPORT_TIME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_COMMENTS");
?>
><?php
echo htmlspecialcharsbx($arOrder["COMMENTS"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_COMMENTS");
?>
>
<?
$dbOrderTax = CSaleOrderTax::GetList(
array(),
array("ORDER_ID" => $arOrder["ID"]),
false,
false,
array("ID", "TAX_NAME", "VALUE", "VALUE_MONEY", "CODE", "IS_IN_PRICE")
);
$i=-1;
$orderTax = 0;
while ($arOrderTax = $dbOrderTax->Fetch())
{
$arOrderTax["VALUE_MONEY"] = roundEx($arOrderTax["VALUE_MONEY"], 2);
$orderTax += $arOrderTax["VALUE_MONEY"];
$i++;
if($i == 0)
echo "<".GetMessage("SALE_EXPORT_TAXES").">";
?>
<<?php
echo GetMessage("SALE_EXPORT_TAX");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo htmlspecialcharsbx($arOrderTax["TAX_NAME"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_IN_PRICE");
?>
><?php
echo $arOrderTax["IS_IN_PRICE"] == "Y" ? "true" : "false";
?>
</<?php
echo GetMessage("SALE_EXPORT_IN_PRICE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_AMOUNT");
?>
><?php
echo $arOrderTax["VALUE_MONEY"];
?>
</<?php
echo GetMessage("SALE_EXPORT_AMOUNT");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_TAX");
?>
>
<?
}
if($i != -1)
echo "</".GetMessage("SALE_EXPORT_TAXES").">";
?>
<?if(DoubleVal($arOrder["DISCOUNT_VALUE"]) > 0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_DISCOUNTS");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_DISCOUNT");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_ORDER_DISCOUNT");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_AMOUNT");
?>
><?php
echo $arOrder["DISCOUNT_VALUE"];
?>
</<?php
echo GetMessage("SALE_EXPORT_AMOUNT");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_IN_PRICE");
?>
>false</<?php
echo GetMessage("SALE_EXPORT_IN_PRICE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_DISCOUNT");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_DISCOUNTS");
?>
>
<?
}
$storeBasket = "";
if(IntVal($arOrder["STORE_ID"]) > 0 && !empty($arStore[$arOrder["STORE_ID"]]))
{
?>
<<?php
echo GetMessage("SALE_EXPORT_STORIES");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_STORY");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ID");
?>
><?php
echo $arStore[$arOrder["STORE_ID"]]["XML_ID"];
?>
</<?php
echo GetMessage("SALE_EXPORT_ID");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo htmlspecialcharsbx($arStore[$arOrder["STORE_ID"]]["TITLE"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ADDRESS");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_PRESENTATION");
?>
><?php
echo htmlspecialcharsbx($arStore[$arOrder["STORE_ID"]]["ADDRESS"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_PRESENTATION");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
><?php
echo GetMessage("SALE_EXPORT_STREET");
?>
</<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($arStore[$arOrder["STORE_ID"]]["ADDRESS"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_ADDRESS");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_CONTACTS");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_CONTACT");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
><?php
echo $bNewVersion ? GetMessage("SALE_EXPORT_WORK_PHONE_NEW") : GetMessage("SALE_EXPORT_WORK_PHONE");
?>
</<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($arStore[$arOrder["STORE_ID"]]["PHONE"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_CONTACT");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_CONTACTS");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_STORY");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_STORIES");
?>
>
<?
/*
$storeBasket = "
<".GetMessage("SALE_EXPORT_STORIES").">
<".GetMessage("SALE_EXPORT_STORY").">
<".GetMessage("SALE_EXPORT_ID").">".$arStore[$arOrder["STORE_ID"]]["XML_ID"]."</".GetMessage("SALE_EXPORT_ID").">
<".GetMessage("SALE_EXPORT_ITEM_NAME").">".htmlspecialcharsbx($arStore[$arOrder["STORE_ID"]]["TITLE"])."</".GetMessage("SALE_EXPORT_ITEM_NAME").">
</".GetMessage("SALE_EXPORT_STORY").">
</".GetMessage("SALE_EXPORT_STORIES").">
";
*/
}
?>
<<?php
echo GetMessage("SALE_EXPORT_ITEMS");
?>
>
<?
$dbBasket = CSaleBasket::GetList(
array("NAME" => "ASC"),
array("ORDER_ID" => $arOrder["ID"]),
false,
false,
array("ID", "NOTES", "PRODUCT_XML_ID", "CATALOG_XML_ID", "NAME", "PRICE", "QUANTITY", "DISCOUNT_PRICE", "VAT_RATE", "MEASURE_CODE")
);
$basketSum = 0;
$priceType = "";
$bVat = false;
$vatRate = 0;
$vatSum = 0;
while ($arBasket = $dbBasket->Fetch())
{
if(strlen($priceType) <= 0)
$priceType = $arBasket["NOTES"];
?>
<<?php
echo GetMessage("SALE_EXPORT_ITEM");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ID");
?>
><?php
echo htmlspecialcharsbx($arBasket["PRODUCT_XML_ID"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_ID");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_CATALOG_ID");
?>
><?php
echo htmlspecialcharsbx($arBasket["CATALOG_XML_ID"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_CATALOG_ID");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo htmlspecialcharsbx($arBasket["NAME"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<?
if($bNewVersion)
{
if(IntVal($arBasket["MEASURE_CODE"]) <= 0)
$arBasket["MEASURE_CODE"] = 796;
?>
<<?php
echo GetMessage("SALE_EXPORT_UNIT");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_CODE");
?>
><?php
echo $arBasket["MEASURE_CODE"];
?>
</<?php
echo GetMessage("SALE_EXPORT_CODE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_FULL_NAME_UNIT");
?>
><?php
echo htmlspecialcharsbx($arMeasures[$arBasket["MEASURE_CODE"]]);
?>
</<?php
echo GetMessage("SALE_EXPORT_FULL_NAME_UNIT");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_UNIT");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_KOEF");
?>
>1</<?php
echo GetMessage("SALE_EXPORT_KOEF");
?>
>
<?
}
else
{
?>
<<?php
echo GetMessage("SALE_EXPORT_BASE_UNIT");
?>
<?php
echo GetMessage("SALE_EXPORT_CODE");
?>
="796" <?php
echo GetMessage("SALE_EXPORT_FULL_NAME_UNIT");
?>
="<?php
echo GetMessage("SALE_EXPORT_SHTUKA");
?>
" <?php
echo GetMessage("SALE_EXPORT_INTERNATIONAL_ABR");
?>
="<?php
echo GetMessage("SALE_EXPORT_RCE");
?>
"><?php
echo GetMessage("SALE_EXPORT_SHT");
?>
</<?php
echo GetMessage("SALE_EXPORT_BASE_UNIT");
?>
>
<?
}
if(DoubleVal($arBasket["DISCOUNT_PRICE"]) > 0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_DISCOUNTS");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_DISCOUNT");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_ITEM_DISCOUNT");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_AMOUNT");
?>
><?php
echo $arBasket["DISCOUNT_PRICE"];
?>
</<?php
echo GetMessage("SALE_EXPORT_AMOUNT");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_IN_PRICE");
?>
>true</<?php
echo GetMessage("SALE_EXPORT_IN_PRICE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_DISCOUNT");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_DISCOUNTS");
?>
>
<?
}
?>
<<?php
echo GetMessage("SALE_EXPORT_PRICE_PER_ITEM");
?>
><?php
echo $arBasket["PRICE"];
?>
</<?php
echo GetMessage("SALE_EXPORT_PRICE_PER_ITEM");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_QUANTITY");
?>
><?php
echo $arBasket["QUANTITY"];
?>
</<?php
echo GetMessage("SALE_EXPORT_QUANTITY");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_AMOUNT");
?>
><?php
echo $arBasket["PRICE"] * $arBasket["QUANTITY"];
?>
</<?php
echo GetMessage("SALE_EXPORT_AMOUNT");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTIES_VALUES");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_TYPE_NOMENKLATURA");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo GetMessage("SALE_EXPORT_ITEM");
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_TYPE_OF_NOMENKLATURA");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo GetMessage("SALE_EXPORT_ITEM");
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<?
$dbProp = CSaleBasket::GetPropsList(Array("SORT" => "ASC", "ID" => "ASC"), Array("BASKET_ID" => $arBasket["ID"], "!CODE" => array("CATALOG.XML_ID", "PRODUCT.XML_ID")), false, false, array("NAME", "VALUE", "CODE"));
while($arProp = $dbProp->Fetch())
{
?>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo htmlspecialcharsbx($arProp["NAME"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($arProp["VALUE"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<?
}
?>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTIES_VALUES");
?>
>
<?if(DoubleVal($arBasket["VAT_RATE"]) > 0)
{
$bVat = true;
$vatRate = DoubleVal($arBasket["VAT_RATE"]);
$basketVatSum = (($arBasket["PRICE"] / ($arBasket["VAT_RATE"]+1)) * $arBasket["VAT_RATE"]);
$vatSum += roundEx($basketVatSum * $arBasket["QUANTITY"], 2);
?>
<<?php
echo GetMessage("SALE_EXPORT_TAX_RATES");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TAX_RATE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_VAT");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_RATE");
?>
><?php
echo $arBasket["VAT_RATE"] * 100;
?>
</<?php
echo GetMessage("SALE_EXPORT_RATE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_TAX_RATE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_TAX_RATES");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TAXES");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TAX");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_VAT");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_IN_PRICE");
?>
>true</<?php
echo GetMessage("SALE_EXPORT_IN_PRICE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_AMOUNT");
?>
><?php
echo roundEx($basketVatSum, 2);
?>
</<?php
echo GetMessage("SALE_EXPORT_AMOUNT");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_TAX");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_TAXES");
?>
>
<?
}
?>
<?php
echo $storeBasket;
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM");
?>
>
<?
$basketSum += $arBasket["PRICE"]*$arBasket["QUANTITY"];
}
if(IntVal($arOrder["PRICE_DELIVERY"]) > 0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_ITEM");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ID");
?>
>ORDER_DELIVERY</<?php
echo GetMessage("SALE_EXPORT_ID");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_ORDER_DELIVERY");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<?
if($bNewVersion)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_UNIT");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_CODE");
?>
>796</<?php
echo GetMessage("SALE_EXPORT_CODE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_FULL_NAME_UNIT");
?>
><?php
echo htmlspecialcharsbx($arMeasures[796]);
?>
</<?php
echo GetMessage("SALE_EXPORT_FULL_NAME_UNIT");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_UNIT");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_KOEF");
?>
>1</<?php
echo GetMessage("SALE_EXPORT_KOEF");
?>
>
<?
}
else
{
?>
<<?php
echo GetMessage("SALE_EXPORT_BASE_UNIT");
?>
<?php
echo GetMessage("SALE_EXPORT_CODE");
?>
="796" <?php
echo GetMessage("SALE_EXPORT_FULL_NAME_UNIT");
?>
="<?php
echo GetMessage("SALE_EXPORT_SHTUKA");
?>
" <?php
echo GetMessage("SALE_EXPORT_INTERNATIONAL_ABR");
?>
="<?php
echo GetMessage("SALE_EXPORT_RCE");
?>
"><?php
echo GetMessage("SALE_EXPORT_SHT");
?>
</<?php
echo GetMessage("SALE_EXPORT_BASE_UNIT");
?>
>
<?
}
?>
<<?php
echo GetMessage("SALE_EXPORT_PRICE_PER_ITEM");
?>
><?php
echo $arOrder["PRICE_DELIVERY"];
?>
</<?php
echo GetMessage("SALE_EXPORT_PRICE_PER_ITEM");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_QUANTITY");
?>
>1</<?php
echo GetMessage("SALE_EXPORT_QUANTITY");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_AMOUNT");
?>
><?php
echo $arOrder["PRICE_DELIVERY"];
?>
</<?php
echo GetMessage("SALE_EXPORT_AMOUNT");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTIES_VALUES");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_TYPE_NOMENKLATURA");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo GetMessage("SALE_EXPORT_SERVICE");
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_TYPE_OF_NOMENKLATURA");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo GetMessage("SALE_EXPORT_SERVICE");
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTIES_VALUES");
?>
>
<?if($bVat)
{
$deliveryTax = roundEx((($arOrder["PRICE_DELIVERY"] / ($vatRate+1)) * $vatRate), 2);
if($orderTax > $vatSum && $orderTax == roundEx($vatSum + $deliveryTax, 2))
{
?>
<<?php
echo GetMessage("SALE_EXPORT_TAX_RATES");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TAX_RATE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_VAT");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_RATE");
?>
><?php
echo $vatRate * 100;
?>
</<?php
echo GetMessage("SALE_EXPORT_RATE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_TAX_RATE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_TAX_RATES");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TAXES");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TAX");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_VAT");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_IN_PRICE");
?>
>true</<?php
echo GetMessage("SALE_EXPORT_IN_PRICE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_AMOUNT");
?>
><?php
echo $deliveryTax;
?>
</<?php
echo GetMessage("SALE_EXPORT_AMOUNT");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_TAX");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_TAXES");
?>
>
<?
}
}
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM");
?>
>
<?
}
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEMS");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTIES_VALUES");
?>
>
<?if(strlen($arOrder["DATE_PAYED"])>0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_DATE_PAID");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo $arOrder["DATE_PAYED"];
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<?
}
if(strlen($arOrder["PAY_VOUCHER_NUM"])>0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_PAY_NUMBER");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($arOrder["PAY_VOUCHER_NUM"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<?
}
if(IntVal($arOrder["PAY_SYSTEM_ID"])>0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_PAY_SYSTEM");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($paySystems[$arOrder["PAY_SYSTEM_ID"]]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_PAY_SYSTEM_ID");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($arOrder["PAY_SYSTEM_ID"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<?
}
if(strlen($arOrder["DATE_ALLOW_DELIVERY"])>0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_DATE_ALLOW_DELIVERY");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo $arOrder["DATE_ALLOW_DELIVERY"];
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<?
}
if(strlen($arOrder["DELIVERY_ID"])>0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_DELIVERY_SERVICE");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($delivery[$arOrder["DELIVERY_ID"]]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<?
}
?>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_ORDER_PAID");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo $arOrder["PAYED"] == "Y" ? "true" : "false";
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_ALLOW_DELIVERY");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo $arOrder["ALLOW_DELIVERY"] == "Y" ? "true" : "false";
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_CANCELED");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo $arOrder["CANCELED"] == "Y" ? "true" : "false";
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_FINAL_STATUS");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo $arOrder["STATUS_ID"] == "F" ? "true" : "false";
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_ORDER_STATUS");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?$arStatus = CSaleStatus::GetLangByID($arOrder["STATUS_ID"]); echo htmlspecialcharsbx("[".$arOrder["STATUS_ID"]."] ".$arStatus["NAME"]);?></<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_ORDER_STATUS_ID");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($arOrder["STATUS_ID"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<?if(strlen($arOrder["DATE_CANCELED"])>0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_DATE_CANCEL");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo $arOrder["DATE_CANCELED"];
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_CANCEL_REASON");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($arOrder["REASON_CANCELED"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<?
}
if(strlen($arOrder["DATE_STATUS"])>0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_DATE_STATUS");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo $arOrder["DATE_STATUS"];
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<?
}
if(strlen($arOrder["USER_DESCRIPTION"])>0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_USER_DESCRIPTION");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($arOrder["USER_DESCRIPTION"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<?
}
$dbSite = CSite::GetByID($arOrder["LID"]);
$arSite = $dbSite->Fetch();
?>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_SITE_NAME");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>[<?php
echo $arOrder["LID"];
?>
] <?php
echo htmlspecialcharsbx($arSite["NAME"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<?
if(!empty($agent["REKV"]))
{
foreach($agent["REKV"] as $k => $v)
{
if(strlen($agentParams[$k]["NAME"]) > 0 && strlen($v) > 0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo htmlspecialcharsbx($agentParams[$k]["NAME"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($v);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<?
}
}
}
if(strlen($deliveryAdr) > 0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_DELIVERY_ADDRESS");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($deliveryAdr);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<?
}
?>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTIES_VALUES");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_DOCUMENT");
?>
>
<?
if ($crmMode)
{
$c = ob_get_clean();
$c = CharsetConverter::ConvertCharset($c, $arCharSets[$arOrder["LID"]], "utf-8");
echo $c;
$_SESSION["BX_CML2_EXPORT"][$lastOrderPrefix][] = $arOrder["ID"];
}
else
{
$_SESSION["BX_CML2_EXPORT"][$lastOrderPrefix] = $arOrder["ID"];
}
if(IntVal($time_limit) > 0 && time() > $end_time)
{
break;
}
}
?>
</<?php
echo GetMessage("SALE_EXPORT_COM_INFORMATION");
?>
>
<?
return $arResultStat;
}
if (empty($arResult["ERROR"]))
{
$countResultTax = count($arResult["arTaxList"]);
for ($i = 0; $i < $countResultTax; $i++)
{
$arFields = array(
"ORDER_ID" => $arResult["ORDER_ID"],
"TAX_NAME" => $arResult["arTaxList"][$i]["NAME"],
"IS_PERCENT" => $arResult["arTaxList"][$i]["IS_PERCENT"],
"VALUE" => ($arResult["arTaxList"][$i]["IS_PERCENT"]=="Y") ? $arResult["arTaxList"][$i]["VALUE"] : RoundEx(CCurrencyRates::ConvertCurrency($arResult["arTaxList"][$i]["VALUE"], $arResult["arTaxList"][$i]["CURRENCY"], $arResult["BASE_LANG_CURRENCY"]), SALE_VALUE_PRECISION),
"VALUE_MONEY" => $arResult["arTaxList"][$i]["VALUE_MONEY"],
"APPLY_ORDER" => $arResult["arTaxList"][$i]["APPLY_ORDER"],
"IS_IN_PRICE" => $arResult["arTaxList"][$i]["IS_IN_PRICE"],
"CODE" => $arResult["arTaxList"][$i]["CODE"]
);
CSaleOrderTax::Add($arFields);
}
$arTmpUserPropsVal = Array();
if(IntVal($arUserResult["PROFILE_ID"]) > 0)
{
$dbUserPropsValues = CSaleOrderUserPropsValue::GetList(
array("SORT" => "ASC"),
array(
"USER_PROPS_ID" => $arUserResult["PROFILE_ID"],
),
false,
false,
array("ORDER_PROPS_ID", "ID", "SORT")
);
while($arUserPropsValues = $dbUserPropsValues->Fetch())
}
?>
<tr>
<td align="right" colspan="4">
Сумма:
</td>
<td align="right" nowrap>
<?php
echo number_format($total_sum, 2, ',', ' ');
?>
</td>
</tr>
<?php
$db_tax_list = CSaleOrderTax::GetList(array("APPLY_ORDER" => "ASC"), array("ORDER_ID" => $ORDER_ID));
while ($ar_tax_list = $db_tax_list->Fetch()) {
?>
<tr>
<td align="right" colspan="4">
<?php
if ($ar_tax_list["IS_IN_PRICE"] == "Y") {
echo "В том числе ";
}
echo htmlspecialcharsbx($ar_tax_list["TAX_NAME"]);
if ($ar_tax_list["IS_PERCENT"] == "Y") {
echo " (" . $ar_tax_list["VALUE"] . "%)";
}
?>
:
</td>
function _Delete($ID)
{
global $DB;
$ID = IntVal($ID);
$bSuccess = True;
foreach (GetModuleEvents("sale", "OnBeforeOrderDelete", true) as $arEvent) {
if (ExecuteModuleEventEx($arEvent, array($ID)) === false) {
return false;
}
}
$DB->StartTransaction();
if ($bSuccess) {
$dbBasket = CSaleBasket::GetList(array(), array("ORDER_ID" => $ID));
while ($arBasket = $dbBasket->Fetch()) {
$bSuccess = CSaleBasket::Delete($arBasket["ID"]);
if (!$bSuccess) {
break;
}
}
}
if ($bSuccess) {
$dbRecurring = CSaleRecurring::GetList(array(), array("ORDER_ID" => $ID));
while ($arRecurring = $dbRecurring->Fetch()) {
$bSuccess = CSaleRecurring::Delete($arRecurring["ID"]);
if (!$bSuccess) {
break;
}
}
}
if ($bSuccess) {
$bSuccess = CSaleOrderPropsValue::DeleteByOrder($ID);
}
if ($bSuccess) {
$bSuccess = CSaleOrderTax::DeleteEx($ID);
}
if ($bSuccess) {
$bSuccess = CSaleUserTransact::DeleteByOrder($ID);
}
if ($bSuccess) {
unset($GLOBALS["SALE_ORDER"]["SALE_ORDER_CACHE_" . $ID]);
}
if ($bSuccess) {
$bSuccess = $DB->Query("DELETE FROM b_sale_order WHERE ID = " . $ID . "", true);
}
if ($bSuccess) {
$DB->Commit();
} else {
$DB->Rollback();
}
foreach (GetModuleEvents("sale", "OnOrderDelete", true) as $arEvent) {
ExecuteModuleEventEx($arEvent, array($ID, $bSuccess));
}
return $bSuccess;
}
function nodeHandler(CDataXML $value)
{
$value = $value->GetArray();
$value = $value[GetMessage("CC_BSC1_DOCUMENT")];
if ($value["#"][GetMessage("CC_BSC1_OPERATION")][0]["#"] == GetMessage("CC_BSC1_ORDER")) {
$orderId = IntVal($value["#"][GetMessage("CC_BSC1_NUMBER")][0]["#"]);
$arOrder = array();
$arItem = array();
$arOrder["AMOUNT"] = $value["#"][GetMessage("CC_BSC1_SUMM")][0]["#"];
$arOrder["AMOUNT"] = str_replace($SumFormat, ".", $arOrder["AMOUNT"]);
$arOrder["COMMENT"] = $value["#"][GetMessage("CC_BSC1_COMMENT")][0]["#"];
foreach ($value["#"][GetMessage("CC_BSC1_REK_VALUES")][0]["#"][GetMessage("CC_BSC1_REK_VALUE")] as $val) {
$arOrder["TRAITS"][$val["#"][GetMessage("CC_BSC1_NAME")][0]["#"]] = $val["#"][GetMessage("CC_BSC1_VALUE")][0]["#"];
}
$taxValue = 0;
$taxValueTmp = 0;
$taxName = "";
if (is_array($value["#"][GetMessage("CC_BSC1_ITEMS")][0]["#"][GetMessage("CC_BSC1_ITEM")])) {
foreach ($value["#"][GetMessage("CC_BSC1_ITEMS")][0]["#"][GetMessage("CC_BSC1_ITEM")] as $val) {
$val = $val["#"];
$productID = $val[GetMessage("CC_BSC1_ID")][0]["#"];
$bGood = false;
$discountPrice = "";
$priceAll = str_replace($SumFormat, ".", $val[GetMessage("CC_BSC1_SUMM")][0]["#"]);
$priceone = str_replace($SumFormat, ".", $val[GetMessage("CC_BSC1_PRICE_PER_UNIT")][0]["#"]);
$quantity = str_replace($QuantityFormat, ".", $val[GetMessage("CC_BSC1_QUANTITY")][0]["#"]);
$price = $priceAll / $quantity;
if ($priceone != $price) {
$discountPrice = $priceone - $price;
}
//DISCOUNTS!
$arItem[$productID] = array("NAME" => $val[GetMessage("CC_BSC1_NAME")][0]["#"], "PRICE" => $price, "QUANTITY" => $quantity, "DISCOUNT_PRICE" => $discountPrice);
if (is_array($val[GetMessage("CC_BSC1_PROPS_ITEMS")][0]["#"][GetMessage("CC_BSC1_PROP_ITEM")])) {
foreach ($val[GetMessage("CC_BSC1_PROPS_ITEMS")][0]["#"][GetMessage("CC_BSC1_PROP_ITEM")] as $val1) {
$arItem[$productID]["ATTRIBUTES"][$val1["#"][GetMessage("CC_BSC1_NAME")][0]["#"]] = $val1["#"][GetMessage("CC_BSC1_VALUE")][0]["#"];
}
}
if (is_array($val[GetMessage("CC_BSC1_REK_VALUES")][0]["#"][GetMessage("CC_BSC1_REK_VALUE")])) {
foreach ($val[GetMessage("CC_BSC1_REK_VALUES")][0]["#"][GetMessage("CC_BSC1_REK_VALUE")] as $val1) {
if ($val1["#"][GetMessage("CC_BSC1_NAME")][0]["#"] == GetMessage("CC_BSC1_ITEM_TYPE")) {
$arItem[$productID]["TYPE"] = $val1["#"][GetMessage("CC_BSC1_VALUE")][0]["#"];
}
}
}
if (strlen($value["#"][GetMessage("CC_BSC1_TAXES")][0]["#"][GetMessage("CC_BSC1_TAX")][0]["#"][GetMessage("CC_BSC1_NAME")][0]["#"]) > 0) {
$taxValueTmp = $val[GetMessage("CC_BSC1_TAXES")][0]["#"][GetMessage("CC_BSC1_TAX")][0]["#"][GetMessage("CC_BSC1_TAX_VALUE")][0]["#"];
$arItem[$productID]["VAT_RATE"] = $taxValueTmp / 100;
if (IntVal($taxValueTmp) > IntVal($taxValue)) {
$taxName = $val[GetMessage("CC_BSC1_TAXES")][0]["#"][GetMessage("CC_BSC1_TAX")][0]["#"][GetMessage("CC_BSC1_NAME")][0]["#"];
$taxValue = $taxValueTmp;
}
}
}
}
if (IntVal($taxValue) > 0) {
$price = str_replace($SumFormat, ".", $value["#"][GetMessage("CC_BSC1_TAXES")][0]["#"][GetMessage("CC_BSC1_TAX")][0]["#"][GetMessage("CC_BSC1_SUMM")][0]["#"]);
$arOrder["TAX"] = array("NAME" => $taxName, "VALUE" => $taxValue, "IS_IN_PRICE" => $value["#"][GetMessage("CC_BSC1_TAXES")][0]["#"][GetMessage("CC_BSC1_TAX")][0]["#"][GetMessage("CC_BSC1_IN_PRICE")][0]["#"] == "true" ? "Y" : "N", "VALUE_MONEY" => $price);
}
$arOrder["items"] = $arItem;
$v = $arOrder;
if ($orderInfo = CSaleOrder::GetByID($orderId)) {
if ($orderInfo["PAYED"] != "Y" && $orderInfo["ALLOW_DELIVERY"] != "Y" && $orderInfo["STATUS_ID"] != "F") {
$dbOrderTax = CSaleOrderTax::GetList(array(), array("ORDER_ID" => $orderId), false, false, array("ID", "TAX_NAME", "VALUE", "VALUE_MONEY", "CODE", "IS_IN_PRICE"));
$bTaxFound = false;
if ($arOrderTax = $dbOrderTax->Fetch()) {
$bTaxFound = true;
if (IntVal($arOrderTax["VALUE_MONEY"]) != IntVal($v["TAX"]["VALUE_MONEY"]) || IntVal($arOrderTax["VALUE"]) != IntVal($v["TAX"]["VALUE"]) || $arOrderTax["IS_IN_PRICE"] != $v["TAX"]["IS_IN_PRICE"]) {
if (IntVal($v["TAX"]["VALUE"]) > 0) {
$arFields = array("TAX_NAME" => $v["TAX"]["NAME"], "ORDER_ID" => $orderId, "VALUE" => $v["TAX"]["VALUE"], "IS_PERCENT" => "Y", "IS_IN_PRICE" => $v["TAX"]["IS_IN_PRICE"], "VALUE_MONEY" => $v["TAX"]["VALUE_MONEY"], "CODE" => "VAT1C", "APPLY_ORDER" => "100");
CSaleOrderTax::Update($arOrderTax["ID"], $arFields);
CSaleOrder::Update($orderId, array("TAX_VALUE" => $v["TAX"]["VALUE_MONEY"]));
} else {
CSaleOrderTax::Delete($arOrderTax["ID"]);
CSaleOrder::Update($orderId, array("TAX_VALUE" => 0));
}
}
}
if (!$bTaxFound) {
if (IntVal($v["TAX"]["VALUE"]) > 0) {
$arFields = array("TAX_NAME" => $v["TAX"]["NAME"], "ORDER_ID" => $orderId, "VALUE" => $v["TAX"]["VALUE"], "IS_PERCENT" => "Y", "IS_IN_PRICE" => $v["TAX"]["IS_IN_PRICE"], "VALUE_MONEY" => $v["TAX"]["VALUE_MONEY"]);
CSaleOrderTax::Add($arFields);
CSaleOrder::Update($orderId, array("TAX_VALUE" => $v["TAX"]["VALUE_MONEY"]));
}
}
$dbBasket = CSaleBasket::GetList(array("NAME" => "ASC"), array("ORDER_ID" => $orderId));
$basketSum = 0;
while ($arBasket = $dbBasket->Fetch()) {
$arFields = array();
if (!empty($v["items"][$arBasket["PRODUCT_XML_ID"]])) {
if ($arBasket["QUANTITY"] != $v["items"][$arBasket["PRODUCT_XML_ID"]]["QUANTITY"]) {
$arFields["QUANTITY"] = $v["items"][$arBasket["PRODUCT_XML_ID"]]["QUANTITY"];
}
if ($arBasket["PRICE"] != $v["items"][$arBasket["PRODUCT_XML_ID"]]["PRICE"]) {
$arFields["PRICE"] = $v["items"][$arBasket["PRODUCT_XML_ID"]]["PRICE"];
}
if ($arBasket["VAT_RATE"] != $v["items"][$arBasket["PRODUCT_XML_ID"]]["VAT_RATE"]) {
$arFields["VAT_RATE"] = $v["items"][$arBasket["PRODUCT_XML_ID"]]["VAT_RATE"];
}
if ($arBasket["DISCOUNT_PRICE"] != $v["items"][$arBasket["PRODUCT_XML_ID"]]["DISCOUNT_PRICE"]) {
$arFields["DISCOUNT_PRICE"] = $v["items"][$arBasket["PRODUCT_XML_ID"]]["DISCOUNT_PRICE"];
}
if (count($arFields) > 0) {
CSaleBasket::Update($arBasket["ID"], $arFields);
}
$v["items"][$arBasket["PRODUCT_XML_ID"]]["CHECKED"] = "Y";
} else {
CSaleBasket::Delete($arBasket["ID"]);
}
}
foreach ($v["items"] as $itemID => $arItem) {
if ($arItem["CHECKED"] != "Y") {
if ($arItem["TYPE"] == GetMessage("CC_BSC1_ITEM")) {
CModule::IncludeModule("iblock");
$dbIBlockElement = CIBlockElement::GetList(array(), array("XML_ID" => $itemID, "ACTIVE" => "Y", "CHECK_PERMISSIONS" => "Y"), false, false, array("ID", "IBLOCK_ID", "XML_ID", "NAME", "DETAIL_PAGE_URL"));
if ($arIBlockElement = $dbIBlockElement->GetNext()) {
$dbIBlock = CIBlock::GetList(array(), array("ID" => $arIBlockElement["IBLOCK_ID"]));
if ($arIBlock = $dbIBlock->Fetch()) {
$arProps[] = array("NAME" => "Catalog XML_ID", "CODE" => "CATALOG.XML_ID", "VALUE" => $arIBlock["XML_ID"]);
}
$arProps[] = array("NAME" => "Product XML_ID", "CODE" => "PRODUCT.XML_ID", "VALUE" => $arIBlockElement["XML_ID"]);
$arProduct = CCatalogProduct::GetByID($arIBlockElement["ID"]);
$arFields = array("ORDER_ID" => $orderId, "PRODUCT_ID" => $arIBlockElement["ID"], "PRICE" => $arItem["PRICE"], "CURRENCY" => $orderInfo["CURRENCY"], "WEIGHT" => $arProduct["WEIGHT"], "QUANTITY" => $arItem["QUANTITY"], "LID" => $orderInfo["LID"], "DELAY" => "N", "CAN_BUY" => "Y", "NAME" => $arIBlockElement["~NAME"], "CALLBACK_FUNC" => "CatalogBasketCallback", "MODULE" => "catalog", "NOTES" => $arProduct["CATALOG_GROUP_NAME"], "ORDER_CALLBACK_FUNC" => "CatalogBasketOrderCallback", "CANCEL_CALLBACK_FUNC" => "CatalogBasketCancelCallback", "PAY_CALLBACK_FUNC" => "CatalogPayOrderCallback", "DETAIL_PAGE_URL" => $arIBlockElement["DETAIL_PAGE_URL"], "CATALOG_XML_ID" => $arIBlock["XML_ID"], "PRODUCT_XML_ID" => $arIBlockElement["XML_ID"], "IGNORE_CALLBACK_FUNC" => "Y", "VAT_RATE" => $arItem["VAT_RATE"]);
CSaleBasket::Add($arFields);
} else {
$this->strError .= "\n" . GetMessage("CC_BSC1_PRODUCT_NOT_FOUND") . $orderId . " - [" . $itemID . "] " . $arItem["NAME"];
}
} elseif ($arItem["TYPE"] == GetMessage("CC_BSC1_SERVICE")) {
if (IntVal($arItem["PRICE"]) != IntVal($orderInfo["PRICE_DELIVERY"])) {
CSaleOrder::Update($orderId, array("PRICE_DELIVERY" => $arItem["PRICE"]));
}
}
}
}
$arOrderFields = array();
if ($v["AMOUNT"] != $orderInfo["PRICE"]) {
$arOrderFields = array("PRICE" => $v["AMOUNT"]);
}
if (DoubleVal($orderInfo["DISCOUNT_VALUE"]) > 0) {
$arOrderFields["DISCOUNT_VALUE"] = 0;
}
$arOrderFields["UPDATED_1C"] = "Y";
if (!empty($arOrderFields)) {
CSaleOrder::Update($orderId, $arOrderFields);
}
} else {
$this->strError .= "\n" . GetMessage("CC_BSC1_FINAL_NOT_EDIT", array("#ID#" => $orderId));
}
$arAditFields = array();
if ($v["TRAITS"][GetMessage("CC_BSC1_CANCELED")] == "true") {
if ($orderInfo["CANCELED"] == "N") {
CSaleOrder::CancelOrder($orderId, "Y", $v["COMMENT"]);
}
$arAditFields["UPDATED_1C"] = "Y";
} else {
if ($orderInfo["CANCELED"] == "Y") {
CSaleOrder::CancelOrder($orderId, "N", $v["COMMENT"]);
}
$arAditFields["UPDATED_1C"] = "Y";
if (strlen($v["TRAITS"][GetMessage("CC_BSC1_1C_PAYED_DATE")]) > 1) {
if ($orderInfo["PAYED"] == "N") {
CSaleOrder::PayOrder($orderId, "Y");
}
$arAditFields["PAY_VOUCHER_DATE"] = CDatabase::FormatDate(str_replace("T", " ", $v["TRAITS"][GetMessage("CC_BSC1_1C_PAYED_DATE")]), "YYYY-MM-DD HH:MI:SS", CLang::GetDateFormat("FULL", LANG));
if (strlen($v["TRAITS"][GetMessage("CC_BSC1_1C_PAYED_NUM")]) > 0) {
$arAditFields["PAY_VOUCHER_NUM"] = $v["TRAITS"][GetMessage("CC_BSC1_1C_PAYED_NUM")];
}
$arAditFields["UPDATED_1C"] = "Y";
}
if (strlen($v["TRAITS"][GetMessage("CC_BSC1_1C_DELIVERY_DATE")]) > 1) {
if ($orderInfo["ALLOW_DELIVERY"] == "N") {
CSaleOrder::DeliverOrder($orderId, "Y");
}
$arAditFields["DATE_ALLOW_DELIVERY"] = CDatabase::FormatDate(str_replace("T", " ", $v["TRAITS"][GetMessage("CC_BSC1_1C_DELIVERY_DATE")]), "YYYY-MM-DD HH:MI:SS", CLang::GetDateFormat("FULL", LANG));
if (strlen($arParams["FINAL_STATUS_ON_DELIVERY"]) > 0 && $orderInfo["STATUS_ID"] != "F" && $orderInfo["STATUS_ID"] != $arParams["FINAL_STATUS_ON_DELIVERY"]) {
CSaleOrder::StatusOrder($orderId, $arParams["FINAL_STATUS_ON_DELIVERY"]);
}
$arAditFields["UPDATED_1C"] = "Y";
}
}
if (count($arAditFields) > 0) {
CSaleOrder::Update($orderId, $arAditFields);
}
} else {
$this->strError .= "\n" . GetMessage("CC_BSC1_ORDER_NOT_FOUND", array("#ID#" => $orderId));
}
}
}
/**
* <p>Метод осуществляет продление подписки с кодом ID.</p> <p><b>Примечание</b>. Метод использует внутреннюю транзакцию. Если у вас используется <b>MySQL</b> и <b>InnoDB</b>, и ранее была открыта транзакция, то ее необходимо закрыть до подключения метода.</p>
*
*
*
*
* @param int $ID Код записи с информацией о продлении.
*
*
*
* @return bool <p>Метод возвращает <i>true</i> в случае успешного продления или <i>false</i>
* в случае ошибки.</p><br><br>
*
* @static
* @link http://dev.1c-bitrix.ru/api_help/sale/classes/csalerecurring/csalerecurring.nextpayment.php
* @author Bitrix
*/
public static function NextPayment($ID)
{
global $DB;
global $USER;
$ID = IntVal($ID);
if ($ID <= 0)
{
$GLOBALS["APPLICATION"]->ThrowException(GetMessage("SKGR_NO_RECID"), "NO_RECORD_ID");
return False;
}
$arRecur = CSaleRecurring::GetByID($ID);
if (!$arRecur)
{
$GLOBALS["APPLICATION"]->ThrowException(str_replace("#ID#", $ID, GetMessage("SKGR_NO_RECID1")), "NO_RECORD");
return False;
}
$arOrder = CSaleOrder::GetByID($arRecur["ORDER_ID"]);
if (!$arOrder)
{
$GLOBALS["APPLICATION"]->ThrowException(str_replace("#ID#", $arRecur["ORDER_ID"], GetMessage("SKGR_NO_ORDER1")), "NO_ORDER");
return False;
}
$bSuccess = True;
$newOrderID = IntVal($arRecur["ORDER_ID"]);
/** @var $productProvider IBXSaleProductProvider */
if ($productProvider = CSaleBasket::GetProductProvider($arRecur))
{
$arProduct = $productProvider::RecurringOrderProduct(array(
"PRODUCT_ID" => $arRecur["PRODUCT_ID"],
"USER_ID" => $arOrder["USER_ID"]
));
}
else
{
$arProduct = CSaleRecurring::ExecuteCallbackFunction(
$arRecur["CALLBACK_FUNC"],
$arRecur["MODULE"],
$arRecur["PRODUCT_ID"],
$arOrder["USER_ID"]
);
}
if (!$arProduct || !is_array($arProduct) || count($arProduct) <= 0)
{
CSaleRecurring::CancelRecurring($arRecur["ID"], "Y", "Product is not found");
/*
$arFields = array(
"CANCELED" => "Y",
"DATE_CANCELED" => Date(CDatabase::DateFormatToPHP(CLang::GetDateFormat("FULL", LANG))),
"CANCELED_REASON" => "Product is not found"
);
CSaleRecurring::Update($arRecur["ID"], $arFields);
*/
//CSaleRecurring::Delete($arRecur["ID"]);
return True;
}
if ($arProduct["WITHOUT_ORDER"] == "Y" || $arRecur["SUCCESS_PAYMENT"] == "Y")
{
$baseSiteCurrency = CSaleLang::GetLangCurrency($arOrder["LID"]);
$productPrice = roundEx(CCurrencyRates::ConvertCurrency($arProduct["PRICE"], $arProduct["CURRENCY"], $baseSiteCurrency), SALE_VALUE_PRECISION);
// Delivery
$deliveryPrice = 0;
$deliveryID = 0;
$arOrder["DELIVERY_ID"] = IntVal($arOrder["DELIVERY_ID"]);
if ($arOrder["DELIVERY_ID"] > 0)
{
$deliveryLocation = 0;
$dbOrderPropValues = CSaleOrderPropsValue::GetList(
array(),
array(
"ORDER_ID" => $arRecur["ORDER_ID"],
"PROP_IS_LOCATION" => "Y"
),
false,
false,
array("VALUE")
);
if ($arOrderPropValues = $dbOrderPropValues->Fetch())
$deliveryLocation = IntVal($arOrderPropValues["VALUE"]);
$dbDelivery = CSaleDelivery::GetList(
array("SORT" => "ASC", "NAME" => "ASC"),
array(
"LID" => $arOrder["LID"],
"WEIGHT" => DoubleVal($arProduct["WEIGHT"]) * DoubleVal($arProduct["QUANTITY"]), // Changed by Sigurd, 2007-08-16
"ORDER_PRICE" => $productPrice * DoubleVal($arProduct["QUANTITY"]),
"ACTIVE" => "Y",
"LOCATION" => $deliveryLocation
)
);
while ($arDelivery = $dbDelivery->Fetch())
{
$deliveryPriceTmp = roundEx(CCurrencyRates::ConvertCurrency($arDelivery["PRICE"], $arDelivery["CURRENCY"], $baseSiteCurrency), SALE_VALUE_PRECISION);
if (IntVal($arDelivery["ID"]) == $arOrder["DELIVERY_ID"])
{
$deliveryID = IntVal($arDelivery["ID"]);
$deliveryPrice = $deliveryPriceTmp;
break;
}
if ($deliveryPriceTmp < $deliveryPrice || $deliveryID <= 0)
{
$deliveryID = IntVal($arDelivery["ID"]);
$deliveryPrice = $deliveryPriceTmp;
}
}
if ($deliveryID <= 0)
{
$GLOBALS["APPLICATION"]->ThrowException(GetMessage("SKGR_NO_DELIVERY"), "NO_DELIVERY");
return False;
}
}
// Sale discounts
$discount = 0;
$discountPrice = $productPrice;
$discountProduct = 0;
$dbDiscount = CSaleDiscount::GetList(
array("SORT" => "ASC"),
array(
"LID" => $arOrder["LID"],
"ACTIVE" => "Y",
"!>ACTIVE_FROM" => Date($DB->DateFormatToPHP(CSite::GetDateFormat("FULL"))),
"!<ACTIVE_TO" => Date($DB->DateFormatToPHP(CSite::GetDateFormat("FULL"))),
"<=PRICE_FROM" => $productPrice,
">=PRICE_TO" => $productPrice,
"USER_GROUPS" => $USER->GetUserGroup($arOrder['USER_ID']),
)
);
if ($arDiscount = $dbDiscount->Fetch())
{
if ($arDiscount["DISCOUNT_TYPE"] == "P")
{
$discountProduct = roundEx($productPrice * $arDiscount["DISCOUNT_VALUE"] / 100, SALE_VALUE_PRECISION);
$discount = roundEx($discountProduct * DoubleVal($arProduct["QUANTITY"]), SALE_VALUE_PRECISION); // Changed by Sigurd, 2007-08-16
$discountPrice = $productPrice - $discountProduct;
}
else
{
$discountValue = CCurrencyRates::ConvertCurrency($arDiscount["DISCOUNT_VALUE"], $arDiscount["CURRENCY"], $baseSiteCurrency);
$discountValue = roundEx($discountValue, SALE_VALUE_PRECISION);
$discountProduct = roundEx(1.0 * $discountValue / DoubleVal($arProduct["QUANTITY"]), SALE_VALUE_PRECISION);// Changed by Sigurd, 2007-08-16
$discount = roundEx($curDiscount * DoubleVal($arProduct["QUANTITY"]), SALE_VALUE_PRECISION);
$discountPrice = $productPrice - $discountProduct;
}
}
$bUseVat = false;
$vatRate = 0;
if(DoubleVal($arProduct["VAT_RATE"]) > 0)
{
$bUseVat = true;
$vatRate = $arProduct["VAT_RATE"];
}
// Tax
$arTaxExempt = array();
$dbUserGroups = CUser::GetUserGroupEx($arOrder["USER_ID"]);
while ($arUserGroups = $dbUserGroups->Fetch())
{
$dbTaxExemptTmp = CSaleTax::GetExemptList(array("GROUP_ID" => $arUserGroups["GROUP_ID"]));
while ($arTaxExemptTmp = $dbTaxExemptTmp->Fetch())
{
$arTaxExemptTmp["TAX_ID"] = IntVal($arTaxExemptTmp["TAX_ID"]);
if (!in_array($arTaxExemptTmp["TAX_ID"], $arTaxExempt))
$arTaxExempt[] = $arTaxExemptTmp["TAX_ID"];
}
}
$taxPrice = 0;
$taxVatPrice = 0;
if(!$bUseVat)
{
$taxLocation = 0;
$dbOrderPropValues = CSaleOrderPropsValue::GetList(
array(),
array(
"ORDER_ID" => $arRecur["ORDER_ID"],
"PROP_IS_LOCATION4TAX" => "Y"
),
false,
false,
array("VALUE")
);
if ($arOrderPropValues = $dbOrderPropValues->Fetch())
$taxLocation = IntVal($arOrderPropValues["VALUE"]);
$arTaxList = array();
$dbTaxRateTmp = CSaleTaxRate::GetList(
array("APPLY_ORDER" => "ASC"),
array(
"LID" => $arOrder["LID"],
"PERSON_TYPE_ID" => $arOrder["PERSON_TYPE_ID"],
"ACTIVE" => "Y",
"LOCATION" => $taxLocation
)
);
while ($arTaxRateTmp = $dbTaxRateTmp->Fetch())
{
if (!in_array(IntVal($arTaxRateTmp["TAX_ID"]), $arTaxExempt))
{
$arTaxList[] = $arTaxRateTmp;
}
}
}
else
{
$arTaxList[] = Array(
"ID" => 0,
"TAX_NAME" => GetMessage("SKGR_VAT"),
"IS_PERCENT" => "Y",
"VALUE" => $vatRate*100,
"VALUE_MONEY" => 0,
"APPLY_ORDER" => 100,
"IS_IN_PRICE" => "Y",
"CODE" => "VAT"
);
}
$arTaxSums = array();
if (!empty($arTaxList))
{
if(!$bUseVat)
{
$taxPriceTmp = CSaleOrderTax::CountTaxes(
$discountPrice * DoubleVal($arProduct["QUANTITY"]),
$arTaxList,
$baseSiteCurrency
);
for ($di = 0, $intCount = count($arTaxList); $di < $intCount; $di++)
{
$arTaxList[$di]["VALUE_MONEY"] += $arTaxList[$di]["TAX_VAL"];
}
for ($di = 0, $intCount = count($arTaxList); $di < $intCount; $di++)
{
$arTaxSums[$arTaxList[$di]["TAX_ID"]]["VALUE"] = $arTaxList[$di]["VALUE_MONEY"];
$arTaxSums[$arTaxList[$di]["TAX_ID"]]["NAME"] = $arTaxList[$di]["NAME"];
if ($arTaxList[$di]["IS_IN_PRICE"] != "Y")
{
$taxPrice += $arTaxList[$di]["VALUE_MONEY"];
}
}
}
else
{
$arTaxList[0]["VALUE_MONEY"] = (($discountPrice / ($vatRate +1)) * $vatRate) * DoubleVal($arProduct["QUANTITY"]);
$taxVatPrice = $arTaxList[0]["VALUE_MONEY"];
}
}
// Changed by Sigurd, 2007-08-16
$totalOrderPrice = $discountPrice * DoubleVal($arProduct["QUANTITY"]) + $deliveryPrice + $taxPrice;
$arProduct["WITHOUT_ORDER"] = (($arProduct["WITHOUT_ORDER"]=="Y") ? "Y" : "N");
if ($arProduct["WITHOUT_ORDER"] == "N")
{
$DB->StartTransaction();
// Saving
$arSaleUser = CSaleUser::GetList(Array(), Array("USER_ID" => $arOrder["USER_ID"]));
if(!empty($arSaleUser))
{
$currentFUser = $arSaleUser["ID"];
}
else
{
$currentFUser = CSaleUser::_Add(
array(
"=DATE_INSERT" => $DB->GetNowFunction(),
"=DATE_UPDATE" => $DB->GetNowFunction(),
"USER_ID" => $arOrder["USER_ID"]
)
);
}
$arFields = array(
"FUSER_ID" => $currentFUser,
"PRODUCT_ID" => $arProduct["PRODUCT_ID"],
"PRODUCT_NAME" => $arProduct["PRODUCT_NAME"],
"PRODUCT_URL" => $arProduct["PRODUCT_URL"],
"PRODUCT_PRICE_ID" => $arProduct["PRODUCT_PRICE_ID"],
"PRICE" => $arProduct["PRICE"],
"CURRENCY" => $arProduct["CURRENCY"],
"WEIGHT" => $arProduct["WEIGHT"],
"QUANTITY" => $arProduct["QUANTITY"],
"LID" => $arOrder["LID"],
"DELAY" => "N",
"CAN_BUY" => "Y",
"NAME" => $arProduct["NAME"],
"CALLBACK_FUNC" => $arProduct["CALLBACK_FUNC"],
"ORDER_CALLBACK_FUNC" => $arProduct["ORDER_CALLBACK_FUNC"],
"CANCEL_CALLBACK_FUNC" => $arProduct["CANCEL_CALLBACK_FUNC"],
"PAY_CALLBACK_FUNC" => $arProduct["PAY_CALLBACK_FUNC"],
"PRODUCT_PROVIDER_CLASS" => $arProduct["PRODUCT_PROVIDER_CLASS"],
"MODULE" => $arRecur["MODULE"],
"NOTES" => $arProduct["CATALOG_GROUP_NAME"],
"DETAIL_PAGE_URL" => $arProduct["DETAIL_PAGE_URL"],
"VATE_RATE" => $arProduct["VATE_RATE"],
"PRODUCT_XML_ID" => $arProduct["PRODUCT_XML_ID"],
"RENEWAL" => "Y"
);
$basketID = CSaleBasket::Add($arFields);
$basketID = IntVal($basketID);
if ($basketID <= 0)
$bSuccess = False;
if ($bSuccess)
{
if (CModule::IncludeModule("statistic"))
CStatistic::Set_Event("eStore", "add2basket", $arFields["PRODUCT_ID"]);
$arFields = array(
"LID" => $arOrder["LID"],
"PERSON_TYPE_ID" => $arOrder["PERSON_TYPE_ID"],
"PAYED" => "N",
"CANCELED" => "N",
"STATUS_ID" => "N",
"PRICE_DELIVERY" => $deliveryPrice,
"ALLOW_DELIVERY" => "N",
"PRICE" => $totalOrderPrice,
"CURRENCY" => $baseSiteCurrency,
"DISCOUNT_VALUE" => $discount,
"USER_ID" => $arOrder["USER_ID"],
"PAY_SYSTEM_ID" => $arOrder["PAY_SYSTEM_ID"],
"DELIVERY_ID" => $deliveryID,
"USER_DESCRIPTION" => $arOrder["USER_DESCRIPTION"],
"TAX_VALUE" => (($bUseVat)? $taxVatPrice : $taxPrice),
"STAT_GID" => $arOrder["STAT_GID"],
"RECURRING_ID" => $arRecur["ID"]
);
$newOrderID = CSaleOrder::Add($arFields);
$newOrderID = IntVal($newOrderID);
if ($newOrderID <= 0)
$bSuccess = False;
}
if ($bSuccess)
{
$arDiscounts = array();
$arDiscounts[$basketID] = $discountProduct;
CSaleBasket::OrderBasket($newOrderID, $currentFUser, $arOrder["LID"], $arDiscounts);
}
if ($bSuccess)
{
for ($it = 0, $intCount = count($arTaxList); $it < $intCount; $it++)
{
$arFields = array(
"ORDER_ID" => $newOrderID,
"TAX_NAME" => $arTaxList[$it]["TAX_NAME"],
"IS_PERCENT" => $arTaxList[$it]["IS_PERCENT"],
"VALUE" => ($arTaxList[$it]["IS_PERCENT"]=="Y") ? $arTaxList[$it]["VALUE"] : RoundEx(CCurrencyRates::ConvertCurrency($arTaxList[$it]["VALUE"], $arTaxList[$it]["CURRENCY"], $baseSiteCurrency), 2),
"VALUE_MONEY" => $arTaxList[$it]["VALUE_MONEY"],
"APPLY_ORDER" => $arTaxList[$it]["APPLY_ORDER"],
"IS_IN_PRICE" => $arTaxList[$it]["IS_IN_PRICE"],
"CODE" => $arTaxList[$it]["CODE"]
);
CSaleOrderTax::Add($arFields);
}
$dbOrderPropValues = CSaleOrderPropsValue::GetList(
array(),
array("ORDER_ID" => $arRecur["ORDER_ID"]),
false,
false,
array("ORDER_PROPS_ID", "NAME", "CODE", "VALUE", "PROP_IS_PAYER", "PROP_IS_EMAIL")
);
while ($arOrderPropValues = $dbOrderPropValues->Fetch())
{
$arFields = array(
"ORDER_ID" => $newOrderID,
"ORDER_PROPS_ID" => $arOrderPropValues["ORDER_PROPS_ID"],
"NAME" => $arOrderPropValues["NAME"],
"CODE" => $arOrderPropValues["CODE"],
"VALUE" => $arOrderPropValues["VALUE"]
);
CSaleOrderPropsValue::Add($arFields);
if ($arOrderPropValues["PROP_IS_PAYER"] == "Y")
$payerName = $arOrderPropValues["VALUE"];
if ($arOrderPropValues["PROP_IS_EMAIL"] == "Y")
$payerEMail = $arOrderPropValues["VALUE"];
}
}
if ($bSuccess)
{
if (CModule::IncludeModule("statistic"))
CStatistic::Set_Event("eStore", "order_create", $newOrderID);
}
if ($bSuccess)
{
$strOrderList = "";
$dbBasketTmp = CSaleBasket::GetList(
array("NAME" => "ASC"),
array("ORDER_ID" => $newOrderID)
);
while ($arBasketTmp = $dbBasketTmp->Fetch())
{
$strOrderList .= $arBasketTmp["NAME"]." - ".$arBasketTmp["QUANTITY"]." ".GetMessage("SALE_QUANTITY_UNIT");
$strOrderList .= "\n";
}
if (strlen($payerName) <= 0 || strlen($payerEMail) <= 0)
{
$dbUser = CUser::GetByID($arOrder["USER_ID"]);
if ($arUser = $dbUser->Fetch())
{
if (strlen($payerName) <= 0)
$payerName = $arUser["NAME"].((strlen($arUser["NAME"])<=0 || strlen($arUser["LAST_NAME"])<=0) ? "" : " ").$arUser["LAST_NAME"];
if (strlen($payerEMail) <= 0)
$payerEMail = $arUser["EMAIL"];
}
}
$arFields = Array(
"ORDER_ID" => $newOrderID,
"ORDER_DATE" => Date($DB->DateFormatToPHP(CLang::GetDateFormat("SHORT", $arOrder["LID"]))),
"ORDER_USER" => $payerName,
"PRICE" => SaleFormatCurrency($totalOrderPrice, $baseSiteCurrency),
"BCC" => COption::GetOptionString("sale", "order_email", "order@".$SERVER_NAME),
"EMAIL" => $payerEMail,
"ORDER_LIST" => $strOrderList,
"SALE_EMAIL" => COption::GetOptionString("sale", "order_email", "order@".$SERVER_NAME)
);
$eventName = "SALE_NEW_ORDER_RECURRING";
$bSend = true;
foreach(GetModuleEvents("sale", "OnOrderRecurringSendEmail", true) as $arEvent)
{
if (ExecuteModuleEventEx($arEvent, Array($newOrderID, &$eventName, &$arFields))===false)
$bSend = false;
}
if($bSend)
{
$event = new CEvent;
$event->Send($eventName, $arOrder["LID"], $arFields, "N");
}
}
if ($bSuccess)
$DB->Commit();
else
$DB->Rollback();
}
}
else
{
$totalOrderPrice = $arOrder["PRICE"];
$baseSiteCurrency = $arOrder["CURRENCY"];
}
$res = False;
if ($bSuccess)
{
$res = CSaleUserAccount::Pay($arOrder["USER_ID"], $totalOrderPrice, $baseSiteCurrency, $newOrderID, True);
if ($res)
{
if ($arProduct["WITHOUT_ORDER"] == "N")
{
CSaleOrder::PayOrder($newOrderID, "Y", False, False, $arRecur["ID"]);
CSaleOrder::DeliverOrder($newOrderID, "Y", $arRecur["ID"]);
CSaleOrder::DeductOrder($newOrderID, "Y", "", true, array(), $arRecur["ID"]);
}
else
{
/** @var $productProvider IBXSaleProductProvider */
if ($productProvider = CSaleBasket::GetProductProvider($arProduct))
{
$r = $productProvider::DeliverProduct(array(
"PRODUCT_ID" => $arProduct["PRODUCT_ID"],
"USER_ID" => $arOrder["USER_ID"],
"PAID" => true
));
}
else
{
$r = CSaleBasket::ExecuteCallbackFunction(
$arProduct["PAY_CALLBACK_FUNC"],
$arRecur["MODULE"],
$arProduct["PRODUCT_ID"],
$arOrder["USER_ID"],
true
);
}
}
$arFields = array(
"ORDER_ID" => $newOrderID,
"PRODUCT_NAME" => $arProduct["PRODUCT_NAME"],
"PRODUCT_URL" => $arProduct["PRODUCT_URL"],
"PRICE_TYPE" => $arProduct["PRICE_TYPE"],
"RECUR_SCHEME_TYPE" => $arProduct["RECUR_SCHEME_TYPE"],
"RECUR_SCHEME_LENGTH" => $arProduct["RECUR_SCHEME_LENGTH"],
"WITHOUT_ORDER" => $arProduct["WITHOUT_ORDER"],
"PRIOR_DATE" => Date($GLOBALS["DB"]->DateFormatToPHP(CLang::GetDateFormat("FULL", SITE_ID))),
"NEXT_DATE" => $arProduct["NEXT_DATE"],
"REMAINING_ATTEMPTS" => (Defined("SALE_PROC_REC_ATTEMPTS") ? SALE_PROC_REC_ATTEMPTS : 3),
"SUCCESS_PAYMENT" => "Y"
);
CSaleRecurring::Update($arRecur["ID"], $arFields);
}
else
{
$arFields = array(
"ORDER_ID" => $newOrderID,
"PRODUCT_NAME" => $arProduct["PRODUCT_NAME"],
"PRODUCT_URL" => $arProduct["PRODUCT_URL"],
"PRICE_TYPE" => $arProduct["PRICE_TYPE"],
"RECUR_SCHEME_LENGTH" => $arProduct["RECUR_SCHEME_LENGTH"],
"RECUR_SCHEME_TYPE" => $arProduct["RECUR_SCHEME_TYPE"],
"WITHOUT_ORDER" => $arProduct["WITHOUT_ORDER"],
"NEXT_DATE" => Date($GLOBALS["DB"]->DateFormatToPHP(CLang::GetDateFormat("FULL", SITE_ID)), time() + SALE_PROC_REC_TIME + CTimeZone::GetOffset()),
"REMAINING_ATTEMPTS" => (IntVal($arRecur["REMAINING_ATTEMPTS"]) - 1),
"SUCCESS_PAYMENT" => "N"
);
CSaleRecurring::Update($arRecur["ID"], $arFields);
if ((IntVal($arRecur["REMAINING_ATTEMPTS"]) - 1) <= 0)
{
CSaleRecurring::CancelRecurring($arRecur["ID"], "Y", "Can't pay order");
/*
$arFields["CANCELED"] = "Y";
$arFields["DATE_CANCELED"] = Date(CDatabase::DateFormatToPHP(CLang::GetDateFormat("FULL", LANG)));
$arFields["CANCELED_REASON"] = "Can't pay order";
*/
}
}
}
return $res;
}
function getOrderTax($orderId)
{
$arResult = array();
if ($orderId > 0) {
$dbOrderTax = CSaleOrderTax::GetList(array(), array("ORDER_ID" => $orderId), false, false, array("ID", "TAX_NAME", "VALUE", "VALUE_MONEY", "CODE", "IS_IN_PRICE"));
$i = -1;
$orderTax = 0;
while ($arOrderTax = $dbOrderTax->Fetch()) {
$arResult[] = $arOrderTax;
}
}
return $arResult;
}
if (!isset($arFilter) || !is_array($arFilter)) {
die("Wrong use 1");
}
$dbOrderList = CSaleOrder::GetList(array($by => $order), $arFilter, false, false, array("ID", "LID", "PERSON_TYPE_ID", "PAYED", "DATE_PAYED", "EMP_PAYED_ID", "CANCELED", "DATE_CANCELED", "EMP_CANCELED_ID", "REASON_CANCELED", "STATUS_ID", "DATE_STATUS", "PAY_VOUCHER_NUM", "PAY_VOUCHER_DATE", "EMP_STATUS_ID", "PRICE_DELIVERY", "ALLOW_DELIVERY", "DATE_ALLOW_DELIVERY", "EMP_ALLOW_DELIVERY_ID", "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"));
ob_start();
echo "<" . "?xml version=\"1.0\" encoding=\"" . LANG_CHARSET . "\"?" . ">\n";
echo "<BizTalk xmlns=\"urn:schemas-biztalk-org:biztalk/biztalk-0.81.xml\"><Route><From locationID=\"\" locationType=\"\" process=\"\" path=\"\" handle=\"\"/><To locationID=\"\" locationType=\"\" process=\"\" path=\"\" handle=\"\"/></Route><Body>\n";
echo "\t<" . GetMessage("CommerceInfo") . " xmlns=\"urn:CommerceML\">\n";
$arContra = array();
while ($dbOrderList->NavNext(true, "f_")) {
echo "\t\t<" . GetMessage("Document") . " " . GetMessage("Operation") . "=\"Order\" " . GetMessage("NumberDoc") . "=\"" . $f_ID . "\" ";
echo "" . GetMessage("DateDoc") . "=\"" . CDatabase::FormatDate($f_DATE_INSERT, CLang::GetDateFormat("FULL", LANG), "Y-M-D") . "\" " . GetMessage("TimeDoc") . "=\"" . CDatabase::FormatDate($f_DATE_INSERT, CLang::GetDateFormat("FULL", LANG), "HH:MI:SS") . "\" " . GetMessage("PaymentDate") . "=\"\" ";
echo "" . GetMessage("Sum") . "=\"" . $f_PRICE . "\" " . GetMessage("Comment") . "=\"\" " . GetMessage("Currency") . "=\"" . $f_CURRENCY . "\">\n";
echo "\t\t\t<" . GetMessage("CompanyInDocument") . " " . GetMessage("Role") . "=\"Saler\" " . GetMessage("Company") . "=\"" . $SALER_COMPANY_XML_ID . "\"/>\n";
echo "\t\t\t<" . GetMessage("CompanyInDocument") . " " . GetMessage("Role") . "=\"Buyer\" " . GetMessage("Company") . "=\"BC" . $f_USER_ID . "\"/>\n";
$dbOrderTax = CSaleOrderTax::GetList(array(), array("ORDER_ID" => $f_ID), false, false, array("ID", "TAX_NAME", "VALUE", "VALUE_MONEY", "CODE", "IS_IN_PRICE"));
while ($arOrderTax = $dbOrderTax->Fetch()) {
echo "\t\t\t<" . GetMessage("TaxSum") . " " . GetMessage("Tax") . "=\"" . htmlspecialcharsbx($arOrderTax["TAX_NAME"]) . "\" " . GetMessage("TaxRate") . "=\"" . htmlspecialcharsbx($arOrderTax["VALUE"]) . "\" " . GetMessage("Sum") . "=\"" . htmlspecialcharsbx($arOrderTax["VALUE_MONEY"]) . "\" " . GetMessage("IncludedInSum") . "=\"" . ($arOrderTax["IS_IN_PRICE"] == "Y" ? 1 : 0) . "\"/>\n";
}
$dbBasket = CSaleBasket::GetList(array("NAME" => "ASC"), array("ORDER_ID" => $f_ID));
while ($arBasket = $dbBasket->Fetch()) {
$CATALOG_XML_ID = $arBasket["CATALOG_XML_ID"];
$PRODUCT_XML_ID = $arBasket["PRODUCT_XML_ID"];
if (strlen($PRODUCT_XML_ID) <= 0 && strlen($CATALOG_XML_ID) <= 0) {
$dbBasketProps = CSaleBasket::GetPropsList(array("CODE" => "ASC"), array("BASKET_ID" => $arBasket["ID"]));
while ($arBasketProps = $dbBasketProps->Fetch()) {
if ($arBasketProps["CODE"] == "CATALOG.XML_ID") {
$CATALOG_XML_ID = $arBasketProps["VALUE"];
} elseif ($arBasketProps["CODE"] == "PRODUCT.XML_ID") {
$PRODUCT_XML_ID = $arBasketProps["VALUE"];
if (substr($PRODUCT_XML_ID, 0, 2) == "ID") {
static function DoSaveOrderTax($orderId, $taxList, &$arErrors)
{
$duplicateList = array();
$idList = array();
$res = CSaleOrderTax::GetList(array('ID' => 'ASC'), array("ORDER_ID" => $orderId), false, false, array("ID", "TAX_NAME", "CODE"));
while ($data = $res->Fetch()) {
$hash = $data["TAX_NAME"] . "|" . $data["CODE"];
if (!array_key_exists($hash, $idList)) {
$idList[$data["TAX_NAME"] . "|" . $data["CODE"]] = $data["ID"];
} else {
$duplicateList[$hash] = $data['ID'];
}
}
$isChanged = false;
if (is_array($taxList)) {
foreach ($taxList as $itemData) {
$fields = array("ORDER_ID" => $orderId, "TAX_NAME" => $itemData["NAME"], "IS_PERCENT" => $itemData["IS_PERCENT"], "VALUE" => $itemData["VALUE"], "VALUE_MONEY" => $itemData["VALUE_MONEY"], "APPLY_ORDER" => $itemData["APPLY_ORDER"], "IS_IN_PRICE" => $itemData["IS_IN_PRICE"], "CODE" => $itemData["CODE"]);
$hash = $itemData["NAME"] . "|" . $itemData["CODE"];
$isNew = false;
if (array_key_exists($hash, $idList)) {
$taxId = CSaleOrderTax::Update($idList[$hash], $fields);
unset($idList[$hash]);
} elseif (!array_key_exists($hash, $duplicateList)) {
$isNew = true;
$taxId = CSaleOrderTax::Add($fields);
}
if ($orderId > 0) {
\Bitrix\Sale\OrderHistory::addLog('TAX', $orderId, $isNew ? 'TAX_ADD' : 'TAX_UPDATE', $taxId, null, array("NAME" => $itemData["NAME"], "CODE" => $itemData["CODE"]), \Bitrix\Sale\OrderHistory::SALE_ORDER_HISTORY_LOG_LEVEL_1);
$isChanged = true;
}
}
}
foreach ($idList as $code => $id) {
CSaleOrderTax::Delete($id);
if ($orderId > 0) {
\Bitrix\Sale\OrderHistory::addLog('TAX', $orderId, 'TAX_DELETED', $id, null, array(), \Bitrix\Sale\OrderHistory::SALE_ORDER_HISTORY_LOG_LEVEL_1);
}
}
if (!empty($duplicateList)) {
foreach ($duplicateList as $hash => $id) {
CSaleOrderTax::Delete($id);
\Bitrix\Sale\OrderHistory::addLog('TAX', $orderId, 'TAX_DUPLICATE_DELETED', $id, null, array(), \Bitrix\Sale\OrderHistory::SALE_ORDER_HISTORY_LOG_LEVEL_1);
}
}
if ($isChanged) {
\Bitrix\Sale\OrderHistory::addAction('TAX', $orderId, "TAX_SAVED");
}
}
public static function getTaxList($ID)
{
if (!CModule::IncludeModule('sale')) {
return false;
}
$arResult = array();
$dbTaxList = CSaleOrderTax::GetList(array("APPLY_ORDER" => "ASC"), array("ORDER_ID" => $ID));
while ($arTaxList = $dbTaxList->Fetch()) {
$arResult[] = array('IS_IN_PRICE' => $arTaxList['IS_IN_PRICE'], 'TAX_NAME' => $arTaxList['TAX_NAME'], 'IS_PERCENT' => $arTaxList['IS_PERCENT'], 'VALUE' => $arTaxList['VALUE'], 'VALUE_MONEY' => $arTaxList['VALUE_MONEY']);
}
return $arResult;
}
public static function ExportOrders2Xml($arFilter = Array(), $nTopCount = 0, $currency = "", $crmMode = false)
{
global $DB;
$count = false;
if(IntVal($nTopCount)>0)
$count = Array("nTopCount" => $nTopCount);
$arResultStat = array(
"ORDERS" => 0,
"CONTACTS" => 0,
"COMPANIES" => 0,
);
$accountNumberPrefix = COption::GetOptionString("sale", "1C_SALE_ACCOUNT_NUMBER_SHOP_PREFIX", "");
$arOrder = array("ID" => "DESC");
if ($crmMode)
$arOrder = array("DATE_UPDATE" => "ASC");
$dbOrderList = CSaleOrder::GetList(
$arOrder,
$arFilter,
false,
$count,
array(
"ID", "LID", "PERSON_TYPE_ID", "PAYED", "DATE_PAYED", "EMP_PAYED_ID", "CANCELED", "DATE_CANCELED",
"EMP_CANCELED_ID", "REASON_CANCELED", "STATUS_ID", "DATE_STATUS", "PAY_VOUCHER_NUM", "PAY_VOUCHER_DATE", "EMP_STATUS_ID",
"PRICE_DELIVERY", "ALLOW_DELIVERY", "DATE_ALLOW_DELIVERY", "EMP_ALLOW_DELIVERY_ID", "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", "ACCOUNT_NUMBER"
)
);
$dbPaySystem = CSalePaySystem::GetList(Array("ID" => "ASC"), Array("ACTIVE" => "Y"), false, false, Array("ID", "NAME", "ACTIVE"));
while($arPaySystem = $dbPaySystem -> Fetch())
$paySystems[$arPaySystem["ID"]] = $arPaySystem["NAME"];
$dbDelivery = CSaleDelivery::GetList(Array("ID" => "ASC"), Array("ACTIVE" => "Y"), false, false, Array("ID", "NAME", "ACTIVE"));
while($arDelivery = $dbDelivery -> Fetch())
$delivery[$arDelivery["ID"]] = $arDelivery["NAME"];
$rsDeliveryHandlers = CSaleDeliveryHandler::GetAdminList(array("SID" => "ASC"));
while ($arHandler = $rsDeliveryHandlers->Fetch())
{
if(is_array($arHandler["PROFILES"]))
{
foreach($arHandler["PROFILES"] as $k => $v)
{
$delivery[$arHandler["SID"].":".$k] = $v["TITLE"]." (".$arHandler["NAME"].")";
}
}
}
$dbExport = CSaleExport::GetList();
while($arExport = $dbExport->Fetch())
{
$arAgent[$arExport["PERSON_TYPE_ID"]] = unserialize($arExport["VARS"]);
}
$dateFormat = CSite::GetDateFormat("FULL");
if ($crmMode)
{
echo "<"."?xml version=\"1.0\" encoding=\"UTF-8\"?".">\n";
$arCharSets = array();
$dbSitesList = CSite::GetList(($b=""), ($o=""));
while ($arSite = $dbSitesList->Fetch())
$arCharSets[$arSite["ID"]] = $arSite["CHARSET"];
}
else
echo "<"."?xml version=\"1.0\" encoding=\"windows-1251\"?".">\n";
?>
<<?php
echo GetMessage("SALE_EXPORT_COM_INFORMATION");
?>
<?php
echo GetMessage("SALE_EXPORT_SHEM_VERSION");
?>
="2.05" <?php
echo GetMessage("SALE_EXPORT_SHEM_DATE_CREATE");
?>
="<?php
echo date("Y-m-d");
?>
T<?php
echo date("G:i:s");
?>
" <?php
echo GetMessage("SALE_EXPORT_DATE_FORMAT");
?>
="<?php
echo GetMessage("SALE_EXPORT_DATE_FORMAT_DF");
?>
=yyyy-MM-dd; <?php
echo GetMessage("SALE_EXPORT_DATE_FORMAT_DLF");
?>
=DT" <?php
echo GetMessage("SALE_EXPORT_DATE_FORMAT_DATETIME");
?>
="<?php
echo GetMessage("SALE_EXPORT_DATE_FORMAT_DF");
?>
=<?php
echo GetMessage("SALE_EXPORT_DATE_FORMAT_TIME");
?>
; <?php
echo GetMessage("SALE_EXPORT_DATE_FORMAT_DLF");
?>
=T" <?php
echo GetMessage("SALE_EXPORT_DEL_DT");
?>
="T" <?php
echo GetMessage("SALE_EXPORT_FORM_SUMM");
?>
="<?php
echo GetMessage("SALE_EXPORT_FORM_CC");
?>
=18; <?php
echo GetMessage("SALE_EXPORT_FORM_CDC");
?>
=2; <?php
echo GetMessage("SALE_EXPORT_FORM_CRD");
?>
=." <?php
echo GetMessage("SALE_EXPORT_FORM_QUANT");
?>
="<?php
echo GetMessage("SALE_EXPORT_FORM_CC");
?>
=18; <?php
echo GetMessage("SALE_EXPORT_FORM_CDC");
?>
=2; <?php
echo GetMessage("SALE_EXPORT_FORM_CRD");
?>
=.">
<?
while($arOrder = $dbOrderList->Fetch())
{
if ($crmMode)
ob_start();
$arResultStat["ORDERS"]++;
$agentParams = $arAgent[$arOrder["PERSON_TYPE_ID"]];
$arProp = Array();
$arProp["ORDER"] = $arOrder;
if (IntVal($arOrder["USER_ID"]) > 0)
{
$dbUser = CUser::GetByID($arOrder["USER_ID"]);
if ($arUser = $dbUser->Fetch())
$arProp["USER"] = $arUser;
}
$dbOrderPropVals = CSaleOrderPropsValue::GetList(
array(),
array("ORDER_ID" => $arOrder["ID"]),
false,
false,
array("ID", "CODE", "VALUE", "ORDER_PROPS_ID", "PROP_TYPE")
);
while ($arOrderPropVals = $dbOrderPropVals->Fetch())
{
//$arProp["PROPERTY"][$arOrderPropVals["ORDER_PROPS_ID"]] = $arOrderPropVals["VALUE"];
if ($arOrderPropVals["PROP_TYPE"] == "CHECKBOX")
{
if ($arOrderPropVals["VALUE"] == "Y")
$arProp["PROPERTY"][$arOrderPropVals["ORDER_PROPS_ID"]] = "true";
else
$arProp["PROPERTY"][$arOrderPropVals["ORDER_PROPS_ID"]] = "false";
}
elseif ($arOrderPropVals["PROP_TYPE"] == "TEXT" || $arOrderPropVals["PROP_TYPE"] == "TEXTAREA")
{
$arProp["PROPERTY"][$arOrderPropVals["ORDER_PROPS_ID"]] = $arOrderPropVals["VALUE"];
}
elseif ($arOrderPropVals["PROP_TYPE"] == "SELECT" || $arOrderPropVals["PROP_TYPE"] == "RADIO")
{
$arVal = CSaleOrderPropsVariant::GetByValue($arOrderPropVals["ORDER_PROPS_ID"], $arOrderPropVals["VALUE"]);
$arProp["PROPERTY"][$arOrderPropVals["ORDER_PROPS_ID"]] = $arVal["NAME"];
}
elseif ($arOrderPropVals["PROP_TYPE"] == "MULTISELECT")
{
$curVal = explode(",", $arOrderPropVals["VALUE"]);
for ($i = 0; $i < count($curVal); $i++)
{
$arVal = CSaleOrderPropsVariant::GetByValue($arOrderPropVals["ORDER_PROPS_ID"], $curVal[$i]);
if ($i > 0)
$arProp["PROPERTY"][$arOrderPropVals["ORDER_PROPS_ID"]] .= ", ";
$arProp["PROPERTY"][$arOrderPropVals["ORDER_PROPS_ID"]] .= $arVal["NAME"];
}
}
elseif ($arOrderPropVals["PROP_TYPE"] == "LOCATION")
{
$arVal = CSaleLocation::GetByID($arOrderPropVals["VALUE"], LANGUAGE_ID);
$arProp["PROPERTY"][$arOrderPropVals["ORDER_PROPS_ID"]] = ($arVal["COUNTRY_NAME"].((strlen($arVal["COUNTRY_NAME"])<=0 || strlen($arVal["CITY_NAME"])<=0) ? "" : " - ").$arVal["CITY_NAME"]);
$arProp["PROPERTY"][$arOrderPropVals["ORDER_PROPS_ID"]."_CITY"] = $arVal["CITY_NAME"];
$arProp["PROPERTY"][$arOrderPropVals["ORDER_PROPS_ID"]."_COUNTRY"] = $arVal["COUNTRY_NAME"];
}
else
{
$arProp["PROPERTY"][$arOrderPropVals["ORDER_PROPS_ID"]] = $arOrderPropVals["VALUE"];
}
}
foreach($agentParams as $k => $v)
{
if(strpos($k, "REKV_") !== false)
{
if(!is_array($v))
{
$agent["REKV"][$k] = $v;
}
else
{
if(strlen($v["TYPE"])<=0)
{
$agent["REKV"][$k] = $v["VALUE"];
}
else
{
$agent["REKV"][$k] = $arProp[$v["TYPE"]][$v["VALUE"]];
}
}
}
else
{
if(!is_array($v))
{
$agent[$k] = $v;
}
else
{
if(strlen($v["TYPE"])<=0)
{
$agent[$k] = $v["VALUE"];
}
else
{
$agent[$k] = $arProp[$v["TYPE"]][$v["VALUE"]];
}
}
}
}
?>
<<?php
echo GetMessage("SALE_EXPORT_DOCUMENT");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ID");
?>
><?php
echo $arOrder["ID"];
?>
</<?php
echo GetMessage("SALE_EXPORT_ID");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_NUMBER");
?>
><?php
echo $accountNumberPrefix . $arOrder["ACCOUNT_NUMBER"];
?>
</<?php
echo GetMessage("SALE_EXPORT_NUMBER");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_DATE");
?>
><?php
echo $DB->FormatDate($arOrder["DATE_INSERT_FORMAT"], $dateFormat, "YYYY-MM-DD");
?>
</<?php
echo GetMessage("SALE_EXPORT_DATE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_HOZ_OPERATION");
?>
><?php
echo GetMessage("SALE_EXPORT_ITEM_ORDER");
?>
</<?php
echo GetMessage("SALE_EXPORT_HOZ_OPERATION");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ROLE");
?>
><?php
echo GetMessage("SALE_EXPORT_SELLER");
?>
</<?php
echo GetMessage("SALE_EXPORT_ROLE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_CURRENCY");
?>
><?php
echo htmlspecialcharsbx(strlen($currency) > 0 ? substr($currency, 0, 3) : substr($arOrder["CURRENCY"], 0, 3));
?>
</<?php
echo GetMessage("SALE_EXPORT_CURRENCY");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_CURRENCY_RATE");
?>
>1</<?php
echo GetMessage("SALE_EXPORT_CURRENCY_RATE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_AMOUNT");
?>
><?php
echo $arOrder["PRICE"];
?>
</<?php
echo GetMessage("SALE_EXPORT_AMOUNT");
?>
>
<?
if ($crmMode)
{
?><DateUpdate><?php
echo $DB->FormatDate($arOrder["DATE_UPDATE"], $dateFormat, "YYYY-MM-DD HH:MI:SS");
?>
</DateUpdate><?
}
?>
<<?php
echo GetMessage("SALE_EXPORT_CONTRAGENTS");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_CONTRAGENT");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ID");
?>
><?php
echo htmlspecialcharsbx($arOrder["USER_ID"] . "#" . $arProp["USER"]["LOGIN"] . "#" . $arProp["USER"]["LAST_NAME"] . " " . $arProp["USER"]["NAME"] . " " . $arProp["USER"]["SECOND_NAME"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_ID");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo htmlspecialcharsbx($agent["AGENT_NAME"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<?
$address = "<".GetMessage("SALE_EXPORT_PRESENTATION").">".htmlspecialcharsbx($agent["ADDRESS_FULL"])."</".GetMessage("SALE_EXPORT_PRESENTATION").">";
if(strlen($agent["INDEX"])>0)
{
$address .= "<".GetMessage("SALE_EXPORT_ADDRESS_FIELD").">
<".GetMessage("SALE_EXPORT_TYPE").">".GetMessage("SALE_EXPORT_POST_CODE")."</".GetMessage("SALE_EXPORT_TYPE").">
<".GetMessage("SALE_EXPORT_VALUE").">".htmlspecialcharsbx($agent["INDEX"])."</".GetMessage("SALE_EXPORT_VALUE").">
</".GetMessage("SALE_EXPORT_ADDRESS_FIELD").">";
}
if(strlen($agent["COUNTRY"])>0)
{
$address .= "<".GetMessage("SALE_EXPORT_ADDRESS_FIELD").">
<".GetMessage("SALE_EXPORT_TYPE").">".GetMessage("SALE_EXPORT_COUNTRY")."</".GetMessage("SALE_EXPORT_TYPE").">
<".GetMessage("SALE_EXPORT_VALUE").">".htmlspecialcharsbx($agent["COUNTRY"])."</".GetMessage("SALE_EXPORT_VALUE").">
</".GetMessage("SALE_EXPORT_ADDRESS_FIELD").">";
}
if(strlen($agent["REGION"])>0)
{
$address .= "<".GetMessage("SALE_EXPORT_ADDRESS_FIELD").">
<".GetMessage("SALE_EXPORT_TYPE").">".GetMessage("SALE_EXPORT_REGION")."</".GetMessage("SALE_EXPORT_TYPE").">
<".GetMessage("SALE_EXPORT_VALUE").">".htmlspecialcharsbx($agent["REGION"])."</".GetMessage("SALE_EXPORT_VALUE").">
</".GetMessage("SALE_EXPORT_ADDRESS_FIELD").">";
}
if(strlen($agent["STATE"])>0)
{
$address .= "<".GetMessage("SALE_EXPORT_ADDRESS_FIELD").">
<".GetMessage("SALE_EXPORT_TYPE").">".GetMessage("SALE_EXPORT_STATE")."</".GetMessage("SALE_EXPORT_TYPE").">
<".GetMessage("SALE_EXPORT_VALUE").">".htmlspecialcharsbx($agent["STATE"])."</".GetMessage("SALE_EXPORT_VALUE").">
</".GetMessage("SALE_EXPORT_ADDRESS_FIELD").">";
}
if(strlen($agent["TOWN"])>0)
{
$address .= "<".GetMessage("SALE_EXPORT_ADDRESS_FIELD").">
<".GetMessage("SALE_EXPORT_TYPE").">".GetMessage("SALE_EXPORT_SMALL_CITY")."</".GetMessage("SALE_EXPORT_TYPE").">
<".GetMessage("SALE_EXPORT_VALUE").">".htmlspecialcharsbx($agent["TOWN"])."</".GetMessage("SALE_EXPORT_VALUE").">
</".GetMessage("SALE_EXPORT_ADDRESS_FIELD").">";
}
if(strlen($agent["CITY"])>0)
{
$address .= "<".GetMessage("SALE_EXPORT_ADDRESS_FIELD").">
<".GetMessage("SALE_EXPORT_TYPE").">".GetMessage("SALE_EXPORT_CITY")."</".GetMessage("SALE_EXPORT_TYPE").">
<".GetMessage("SALE_EXPORT_VALUE").">".htmlspecialcharsbx($agent["CITY"])."</".GetMessage("SALE_EXPORT_VALUE").">
</".GetMessage("SALE_EXPORT_ADDRESS_FIELD").">";
}
if(strlen($agent["STREET"])>0)
{
$address .= "<".GetMessage("SALE_EXPORT_ADDRESS_FIELD").">
<".GetMessage("SALE_EXPORT_TYPE").">".GetMessage("SALE_EXPORT_STREET")."</".GetMessage("SALE_EXPORT_TYPE").">
<".GetMessage("SALE_EXPORT_VALUE").">".htmlspecialcharsbx($agent["STREET"])."</".GetMessage("SALE_EXPORT_VALUE").">
</".GetMessage("SALE_EXPORT_ADDRESS_FIELD").">";
}
if(strlen($agent["HOUSE"])>0)
{
$address .= "<".GetMessage("SALE_EXPORT_ADDRESS_FIELD").">
<".GetMessage("SALE_EXPORT_TYPE").">".GetMessage("SALE_EXPORT_HOUSE")."</".GetMessage("SALE_EXPORT_TYPE").">
<".GetMessage("SALE_EXPORT_VALUE").">".htmlspecialcharsbx($agent["HOUSE"])."</".GetMessage("SALE_EXPORT_VALUE").">
</".GetMessage("SALE_EXPORT_ADDRESS_FIELD").">";
}
if(strlen($agent["BUILDING"])>0)
{
$address .= "<".GetMessage("SALE_EXPORT_ADDRESS_FIELD").">
<".GetMessage("SALE_EXPORT_TYPE").">".GetMessage("SALE_EXPORT_BUILDING")."</".GetMessage("SALE_EXPORT_TYPE").">
<".GetMessage("SALE_EXPORT_VALUE").">".htmlspecialcharsbx($agent["BUILDING"])."</".GetMessage("SALE_EXPORT_VALUE").">
</".GetMessage("SALE_EXPORT_ADDRESS_FIELD").">";
}
if(strlen($agent["FLAT"])>0)
{
$address .= "<".GetMessage("SALE_EXPORT_ADDRESS_FIELD").">
<".GetMessage("SALE_EXPORT_TYPE").">".GetMessage("SALE_EXPORT_FLAT")."</".GetMessage("SALE_EXPORT_TYPE").">
<".GetMessage("SALE_EXPORT_VALUE").">".htmlspecialcharsbx($agent["FLAT"])."</".GetMessage("SALE_EXPORT_VALUE").">
</".GetMessage("SALE_EXPORT_ADDRESS_FIELD").">";
}
if($agent["IS_FIZ"]=="Y")
{
$arResultStat["CONTACTS"]++;
?>
<<?php
echo GetMessage("SALE_EXPORT_FULL_NAME");
?>
><?php
echo htmlspecialcharsbx($agent["FULL_NAME"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_FULL_NAME");
?>
>
<?
if(strlen($agent["SURNAME"])>0)
{
?><<?php
echo GetMessage("SALE_EXPORT_SURNAME");
?>
><?php
echo htmlspecialcharsbx($agent["SURNAME"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_SURNAME");
?>
><?
}
if(strlen($agent["NAME"])>0)
{
?><<?php
echo GetMessage("SALE_EXPORT_NAME");
?>
><?php
echo htmlspecialcharsbx($agent["NAME"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_NAME");
?>
><?
}
if(strlen($agent["SECOND_NAME"])>0)
{
?><<?php
echo GetMessage("SALE_EXPORT_MIDDLE_NAME");
?>
><?php
echo htmlspecialcharsbx($agent["SECOND_NAME"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_MIDDLE_NAME");
?>
><?
}
if(strlen($agent["BIRTHDAY"])>0)
{
?><<?php
echo GetMessage("SALE_EXPORT_BIRTHDAY");
?>
><?php
echo htmlspecialcharsbx($agent["BIRTHDAY"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_BIRTHDAY");
?>
><?
}
if(strlen($agent["MALE"])>0)
{
?><<?php
echo GetMessage("SALE_EXPORT_SEX");
?>
><?php
echo htmlspecialcharsbx($agent["MALE"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_SEX");
?>
><?
}
if(strlen($agent["INN"])>0)
{
?><<?php
echo GetMessage("SALE_EXPORT_INN");
?>
><?php
echo htmlspecialcharsbx($agent["INN"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_INN");
?>
><?
}
if(strlen($agent["KPP"])>0)
{
?><<?php
echo GetMessage("SALE_EXPORT_KPP");
?>
><?php
echo htmlspecialcharsbx($agent["KPP"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_KPP");
?>
><?
}
?>
<<?php
echo GetMessage("SALE_EXPORT_REGISTRATION_ADDRESS");
?>
>
<?php
echo $address;
?>
</<?php
echo GetMessage("SALE_EXPORT_REGISTRATION_ADDRESS");
?>
>
<?
}
else
{
$arResultStat["COMPANIES"]++;
?>
<<?php
echo GetMessage("SALE_EXPORT_OFICIAL_NAME");
?>
><?php
echo htmlspecialcharsbx($agent["FULL_NAME"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_OFICIAL_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_UR_ADDRESS");
?>
>
<?php
echo $address;
?>
</<?php
echo GetMessage("SALE_EXPORT_UR_ADDRESS");
?>
>
<?
if(strlen($agent["INN"])>0)
{
?><<?php
echo GetMessage("SALE_EXPORT_INN");
?>
><?php
echo htmlspecialcharsbx($agent["INN"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_INN");
?>
><?
}
if(strlen($agent["KPP"])>0)
{
?><<?php
echo GetMessage("SALE_EXPORT_KPP");
?>
><?php
echo htmlspecialcharsbx($agent["KPP"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_KPP");
?>
><?
}
if(strlen($agent["EGRPO"])>0)
{
?><<?php
echo GetMessage("SALE_EXPORT_EGRPO");
?>
><?php
echo htmlspecialcharsbx($agent["EGRPO"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_EGRPO");
?>
><?
}
if(strlen($agent["OKVED"])>0)
{
?><<?php
echo GetMessage("SALE_EXPORT_OKVED");
?>
><?php
echo htmlspecialcharsbx($agent["OKVED"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_OKVED");
?>
><?
}
if(strlen($agent["OKDP"])>0)
{
?><<?php
echo GetMessage("SALE_EXPORT_OKDP");
?>
><?php
echo htmlspecialcharsbx($agent["OKDP"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_OKDP");
?>
><?
}
if(strlen($agent["OKOPF"])>0)
{
?><<?php
echo GetMessage("SALE_EXPORT_OKOPF");
?>
><?php
echo htmlspecialcharsbx($agent["OKOPF"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_OKOPF");
?>
><?
}
if(strlen($agent["OKFC"])>0)
{
?><<?php
echo GetMessage("SALE_EXPORT_OKFC");
?>
><?php
echo htmlspecialcharsbx($agent["OKFC"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_OKFC");
?>
><?
}
if(strlen($agent["OKPO"])>0)
{
?><<?php
echo GetMessage("SALE_EXPORT_OKPO");
?>
><?php
echo htmlspecialcharsbx($agent["OKPO"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_OKPO");
?>
><?
}
if(strlen($agent["ACCOUNT_NUMBER"])>0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_MONEY_ACCOUNTS");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_MONEY_ACCOUNT");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ACCOUNT_NUMBER");
?>
><?php
echo htmlspecialcharsbx($agent["ACCOUNT_NUMBER"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_ACCOUNT_NUMBER");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_BANK");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo htmlspecialcharsbx($agent["B_NAME"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ADDRESS");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_PRESENTATION");
?>
><?php
echo htmlspecialcharsbx($agent["B_ADDRESS_FULL"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_PRESENTATION");
?>
>
<?
if(strlen($agent["B_INDEX"])>0)
{
?><<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
><?php
echo GetMessage("SALE_EXPORT_POST_CODE");
?>
</<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($agent["B_INDEX"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
><?
}
if(strlen($agent["B_COUNTRY"])>0)
{
?><<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
><?php
echo GetMessage("SALE_EXPORT_COUNTRY");
?>
</<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($agent["B_COUNTRY"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
><?
}
if(strlen($agent["B_REGION"])>0)
{
?><<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
><?php
echo GetMessage("SALE_EXPORT_REGION");
?>
</<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($agent["B_REGION"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
><?
}
if(strlen($agent["B_STATE"])>0)
{
?><<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
><?php
echo GetMessage("SALE_EXPORT_STATE");
?>
</<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($agent["B_STATE"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
><?
}
if(strlen($agent["B_TOWN"])>0)
{
?><<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
><?php
echo GetMessage("SALE_EXPORT_SMALL_CITY");
?>
</<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($agent["B_TOWN"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
><?
}
if(strlen($agent["B_CITY"])>0)
{
?><<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
><?php
echo GetMessage("SALE_EXPORT_CITY");
?>
</<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($agent["B_CITY"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
><?
}
if(strlen($agent["B_STREET"])>0)
{
?><<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
><?php
echo GetMessage("SALE_EXPORT_STREET");
?>
</<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($agent["B_STREET"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
><?
}
if(strlen($agent["B_HOUSE"])>0)
{
?><<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
><?php
echo GetMessage("SALE_EXPORT_HOUSE");
?>
</<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($agent["B_HOUSE"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
><?
}
if(strlen($agent["B_BUILDING"])>0)
{
?><<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
><?php
echo GetMessage("SALE_EXPORT_BUILDING");
?>
</<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($agent["B_BUILDING"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
><?
}
if(strlen($agent["B_FLAT"])>0)
{
?><<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
><?php
echo GetMessage("SALE_EXPORT_FLAT");
?>
</<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($agent["B_FLAT"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
><?
}
?>
</<?php
echo GetMessage("SALE_EXPORT_ADDRESS");
?>
>
<?
if(strlen($agent["B_BIK"])>0)
{
?><<?php
echo GetMessage("SALE_EXPORT_BIC");
?>
><?php
echo htmlspecialcharsbx($agent["B_BIK"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_BIC");
?>
><?
}
?>
</<?php
echo GetMessage("SALE_EXPORT_BANK");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_MONEY_ACCOUNT");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_MONEY_ACCOUNTS");
?>
>
<?
}
}
if(strlen($agent["F_ADDRESS_FULL"])>0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_ADDRESS");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_PRESENTATION");
?>
><?php
echo htmlspecialcharsbx($agent["F_ADDRESS_FULL"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_PRESENTATION");
?>
>
<?
if(strlen($agent["F_INDEX"])>0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
><?php
echo GetMessage("SALE_EXPORT_POST_CODE");
?>
</<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($agent["F_INDEX"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
>
<?
}
if(strlen($agent["F_COUNTRY"])>0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
><?php
echo GetMessage("SALE_EXPORT_COUNTRY");
?>
</<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($agent["F_COUNTRY"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
>
<?
}
if(strlen($agent["F_REGION"])>0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
><?php
echo GetMessage("SALE_EXPORT_REGION");
?>
</<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($agent["F_REGION"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
>
<?
}
if(strlen($agent["F_STATE"])>0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
><?php
echo GetMessage("SALE_EXPORT_STATE");
?>
</<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($agent["F_STATE"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
>
<?
}
if(strlen($agent["F_TOWN"])>0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
><?php
echo GetMessage("SALE_EXPORT_SMALL_CITY");
?>
</<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($agent["F_TOWN"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
>
<?
}
if(strlen($agent["F_CITY"])>0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
><?php
echo GetMessage("SALE_EXPORT_CITY");
?>
</<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($agent["F_CITY"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
>
<?
}
if(strlen($agent["F_STREET"])>0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
><?php
echo GetMessage("SALE_EXPORT_STREET");
?>
</<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($agent["F_STREET"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
>
<?
}
if(strlen($agent["F_HOUSE"])>0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
><?php
echo GetMessage("SALE_EXPORT_HOUSE");
?>
</<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($agent["F_HOUSE"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
>
<?
}
if(strlen($agent["F_BUILDING"])>0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
><?php
echo GetMessage("SALE_EXPORT_BUILDING");
?>
</<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($agent["F_BUILDING"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
>
<?
}
if(strlen($agent["F_FLAT"])>0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
><?php
echo GetMessage("SALE_EXPORT_FLAT");
?>
</<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($agent["F_FLAT"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_ADDRESS_FIELD");
?>
>
<?
}
?>
</<?php
echo GetMessage("SALE_EXPORT_ADDRESS");
?>
>
<?
}
if(strlen($agent["PHONE"])>0 || strlen($agent["EMAIL"])>0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_CONTACTS");
?>
>
<?
if(strlen($agent["PHONE"])>0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_CONTACT");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
><?php
echo GetMessage("SALE_EXPORT_WORK_PHONE");
?>
</<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($agent["PHONE"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_CONTACT");
?>
>
<?
}
if(strlen($agent["EMAIL"])>0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_CONTACT");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
><?php
echo GetMessage("SALE_EXPORT_MAIL");
?>
</<?php
echo GetMessage("SALE_EXPORT_TYPE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($agent["EMAIL"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_CONTACT");
?>
>
<?
}
?>
</<?php
echo GetMessage("SALE_EXPORT_CONTACTS");
?>
>
<?
}
if(strlen($agent["CONTACT_PERSON"])>0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_REPRESENTATIVES");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_REPRESENTATIVE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_CONTRAGENT");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_RELATION");
?>
><?php
echo GetMessage("SALE_EXPORT_CONTACT_PERSON");
?>
</<?php
echo GetMessage("SALE_EXPORT_RELATION");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ID");
?>
><?php
echo md5($agent["CONTACT_PERSON"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_ID");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo htmlspecialcharsbx($agent["CONTACT_PERSON"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_CONTRAGENT");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_REPRESENTATIVE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_REPRESENTATIVES");
?>
>
<?
}?>
<<?php
echo GetMessage("SALE_EXPORT_ROLE");
?>
><?php
echo GetMessage("SALE_EXPORT_BUYER");
?>
</<?php
echo GetMessage("SALE_EXPORT_ROLE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_CONTRAGENT");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_CONTRAGENTS");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TIME");
?>
><?php
echo $DB->FormatDate($arOrder["DATE_INSERT_FORMAT"], $dateFormat, "HH:MI:SS");
?>
</<?php
echo GetMessage("SALE_EXPORT_TIME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_COMMENTS");
?>
><?php
echo htmlspecialcharsbx($arOrder["COMMENTS"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_COMMENTS");
?>
>
<?
$dbOrderTax = CSaleOrderTax::GetList(
array(),
array("ORDER_ID" => $arOrder["ID"]),
false,
false,
array("ID", "TAX_NAME", "VALUE", "VALUE_MONEY", "CODE", "IS_IN_PRICE")
);
$i=-1;
$orderTax = 0;
while ($arOrderTax = $dbOrderTax->Fetch())
{
$arOrderTax["VALUE_MONEY"] = roundEx($arOrderTax["VALUE_MONEY"], 2);
$orderTax += $arOrderTax["VALUE_MONEY"];
$i++;
if($i == 0)
echo "<".GetMessage("SALE_EXPORT_TAXES").">";
?>
<<?php
echo GetMessage("SALE_EXPORT_TAX");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo htmlspecialcharsbx($arOrderTax["TAX_NAME"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_IN_PRICE");
?>
><?php
echo $arOrderTax["IS_IN_PRICE"] == "Y" ? "true" : "false";
?>
</<?php
echo GetMessage("SALE_EXPORT_IN_PRICE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_AMOUNT");
?>
><?php
echo $arOrderTax["VALUE_MONEY"];
?>
</<?php
echo GetMessage("SALE_EXPORT_AMOUNT");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_TAX");
?>
>
<?
}
if($i != -1)
echo "</".GetMessage("SALE_EXPORT_TAXES").">";
?>
<?if(IntVal($arOrder["DISCOUNT_VALUE"])>0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_DISCOUNTS");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_DISCOUNT");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_ORDER_DISCOUNT");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_AMOUNT");
?>
><?php
echo $arOrder["DISCOUNT_VALUE"];
?>
</<?php
echo GetMessage("SALE_EXPORT_AMOUNT");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_IN_PRICE");
?>
>false</<?php
echo GetMessage("SALE_EXPORT_IN_PRICE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_DISCOUNT");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_DISCOUNTS");
?>
>
<?
}
?>
<<?php
echo GetMessage("SALE_EXPORT_ITEMS");
?>
>
<?
$dbBasket = CSaleBasket::GetList(
array("NAME" => "ASC"),
array("ORDER_ID" => $arOrder["ID"])
);
$basketSum = 0;
$priceType = "";
$bVat = false;
$vatRate = 0;
$vatSum = 0;
while ($arBasket = $dbBasket->Fetch())
{
if(strlen($priceType) <= 0)
$priceType = $arBasket["NOTES"];
?>
<<?php
echo GetMessage("SALE_EXPORT_ITEM");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ID");
?>
><?php
echo htmlspecialcharsbx($arBasket["PRODUCT_XML_ID"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_ID");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_CATALOG_ID");
?>
><?php
echo htmlspecialcharsbx($arBasket["CATALOG_XML_ID"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_CATALOG_ID");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo htmlspecialcharsbx($arBasket["NAME"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_BASE_UNIT");
?>
<?php
echo GetMessage("SALE_EXPORT_CODE");
?>
="796" <?php
echo GetMessage("SALE_EXPORT_FULL_NAME_UNIT");
?>
="<?php
echo GetMessage("SALE_EXPORT_SHTUKA");
?>
" <?php
echo GetMessage("SALE_EXPORT_INTERNATIONAL_ABR");
?>
="<?php
echo GetMessage("SALE_EXPORT_RCE");
?>
"><?php
echo GetMessage("SALE_EXPORT_SHT");
?>
</<?php
echo GetMessage("SALE_EXPORT_BASE_UNIT");
?>
>
<?
if(IntVal($arBasket["DISCOUNT_PRICE"])>0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_DISCOUNTS");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_DISCOUNT");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_ITEM_DISCOUNT");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_AMOUNT");
?>
><?php
echo $arBasket["DISCOUNT_PRICE"];
?>
</<?php
echo GetMessage("SALE_EXPORT_AMOUNT");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_IN_PRICE");
?>
>true</<?php
echo GetMessage("SALE_EXPORT_IN_PRICE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_DISCOUNT");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_DISCOUNTS");
?>
>
<?
}
?>
<<?php
echo GetMessage("SALE_EXPORT_PRICE_PER_ITEM");
?>
><?php
echo $arBasket["PRICE"];
?>
</<?php
echo GetMessage("SALE_EXPORT_PRICE_PER_ITEM");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_QUANTITY");
?>
><?php
echo $arBasket["QUANTITY"];
?>
</<?php
echo GetMessage("SALE_EXPORT_QUANTITY");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_AMOUNT");
?>
><?php
echo $arBasket["PRICE"] * $arBasket["QUANTITY"];
?>
</<?php
echo GetMessage("SALE_EXPORT_AMOUNT");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTIES_VALUES");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_TYPE_NOMENKLATURA");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo GetMessage("SALE_EXPORT_ITEM");
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_TYPE_OF_NOMENKLATURA");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo GetMessage("SALE_EXPORT_ITEM");
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<?
$dbProp = CSaleBasket::GetPropsList(Array("SORT" => "ASC", "ID" => "ASC"), Array("BASKET_ID" => $arBasket["ID"], "!CODE" => array("CATALOG.XML_ID", "PRODUCT.XML_ID")));
while($arProp = $dbProp->Fetch())
{
?>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo htmlspecialcharsbx($arProp["NAME"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($arProp["VALUE"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<?
}
?>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTIES_VALUES");
?>
>
<?if(DoubleVal($arBasket["VAT_RATE"]) > 0)
{
$bVat = true;
$vatRate = DoubleVal($arBasket["VAT_RATE"]);
$basketVatSum = (($arBasket["PRICE"] / ($arBasket["VAT_RATE"]+1)) * $arBasket["VAT_RATE"]);
$vatSum += roundEx($basketVatSum * $arBasket["QUANTITY"], 2);
?>
<<?php
echo GetMessage("SALE_EXPORT_TAX_RATES");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TAX_RATE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_VAT");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_RATE");
?>
><?php
echo $arBasket["VAT_RATE"] * 100;
?>
</<?php
echo GetMessage("SALE_EXPORT_RATE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_TAX_RATE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_TAX_RATES");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TAXES");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TAX");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_VAT");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_IN_PRICE");
?>
>true</<?php
echo GetMessage("SALE_EXPORT_IN_PRICE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_AMOUNT");
?>
><?php
echo roundEx($basketVatSum, 2);
?>
</<?php
echo GetMessage("SALE_EXPORT_AMOUNT");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_TAX");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_TAXES");
?>
>
<?
}
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM");
?>
>
<?
$basketSum += $arBasket["PRICE"]*$arBasket["QUANTITY"];
}
if(IntVal($arOrder["PRICE_DELIVERY"]) > 0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_ITEM");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ID");
?>
>ORDER_DELIVERY</<?php
echo GetMessage("SALE_EXPORT_ID");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_ORDER_DELIVERY");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_BASE_UNIT");
?>
<?php
echo GetMessage("SALE_EXPORT_CODE");
?>
="796" <?php
echo GetMessage("SALE_EXPORT_FULL_NAME_UNIT");
?>
="<?php
echo GetMessage("SALE_EXPORT_SHTUKA");
?>
" <?php
echo GetMessage("SALE_EXPORT_INTERNATIONAL_ABR");
?>
="<?php
echo GetMessage("SALE_EXPORT_RCE");
?>
"><?php
echo GetMessage("SALE_EXPORT_SHT");
?>
</<?php
echo GetMessage("SALE_EXPORT_BASE_UNIT");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_PRICE_PER_ITEM");
?>
><?php
echo $arOrder["PRICE_DELIVERY"];
?>
</<?php
echo GetMessage("SALE_EXPORT_PRICE_PER_ITEM");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_QUANTITY");
?>
>1</<?php
echo GetMessage("SALE_EXPORT_QUANTITY");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_AMOUNT");
?>
><?php
echo $arOrder["PRICE_DELIVERY"];
?>
</<?php
echo GetMessage("SALE_EXPORT_AMOUNT");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTIES_VALUES");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_TYPE_NOMENKLATURA");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo GetMessage("SALE_EXPORT_SERVICE");
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_TYPE_OF_NOMENKLATURA");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo GetMessage("SALE_EXPORT_SERVICE");
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTIES_VALUES");
?>
>
<?if($bVat)
{
$deliveryTax = roundEx((($arOrder["PRICE_DELIVERY"] / ($vatRate+1)) * $vatRate), 2);
if($orderTax > $vatSum && $orderTax == roundEx($vatSum + $deliveryTax, 2))
{
?>
<<?php
echo GetMessage("SALE_EXPORT_TAX_RATES");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TAX_RATE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_VAT");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_RATE");
?>
><?php
echo $vatRate * 100;
?>
</<?php
echo GetMessage("SALE_EXPORT_RATE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_TAX_RATE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_TAX_RATES");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TAXES");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_TAX");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_VAT");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_IN_PRICE");
?>
>true</<?php
echo GetMessage("SALE_EXPORT_IN_PRICE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_AMOUNT");
?>
><?php
echo $deliveryTax;
?>
</<?php
echo GetMessage("SALE_EXPORT_AMOUNT");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_TAX");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_TAXES");
?>
>
<?
}
}
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM");
?>
>
<?
}
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEMS");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTIES_VALUES");
?>
>
<?if(strlen($arOrder["DATE_PAYED"])>0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_DATE_PAID");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo $arOrder["DATE_PAYED"];
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<?
}
if(strlen($arOrder["PAY_VOUCHER_NUM"])>0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_PAY_NUMBER");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo $arOrder["PAY_VOUCHER_NUM"];
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<?
}
if(IntVal($arOrder["PAY_SYSTEM_ID"])>0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_PAY_SYSTEM");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($paySystems[$arOrder["PAY_SYSTEM_ID"]]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<?
}
if(strlen($arOrder["DATE_ALLOW_DELIVERY"])>0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_DATE_ALLOW_DELIVERY");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo $arOrder["DATE_ALLOW_DELIVERY"];
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<?
}
if(strlen($arOrder["DELIVERY_ID"])>0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_DELIVERY_SERVICE");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($delivery[$arOrder["DELIVERY_ID"]]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<?
}
?>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_ORDER_PAID");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo $arOrder["PAYED"] == "Y" ? "true" : "false";
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_ALLOW_DELIVERY");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo $arOrder["ALLOW_DELIVERY"] == "Y" ? "true" : "false";
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_CANCELED");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo $arOrder["CANCELED"] == "Y" ? "true" : "false";
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_FINAL_STATUS");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo $arOrder["STATUS_ID"] == "F" ? "true" : "false";
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_ORDER_STATUS");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?$arStatus = CSaleStatus::GetLangByID($arOrder["STATUS_ID"]); echo htmlspecialcharsbx("[".$arOrder["STATUS_ID"]."] ".$arStatus["NAME"]);?></<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<?if(strlen($arOrder["DATE_CANCELED"])>0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_DATE_CANCEL");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo $arOrder["DATE_CANCELED"];
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_CANCEL_REASON");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($arOrder["REASON_CANCELED"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<?
}
if(strlen($arOrder["DATE_STATUS"])>0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_DATE_STATUS");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo $arOrder["DATE_STATUS"];
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<?
}
if(strlen($arOrder["USER_DESCRIPTION"])>0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_USER_DESCRIPTION");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($arOrder["USER_DESCRIPTION"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<?
}
$dbSite = CSite::GetByID($arOrder["LID"]);
$arSite = $dbSite->Fetch();
?>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo GetMessage("SALE_EXPORT_SITE_NAME");
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>[<?php
echo $arOrder["LID"];
?>
] <?php
echo htmlspecialcharsbx($arSite["NAME"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<?
if(!empty($agent["REKV"]))
{
foreach($agent["REKV"] as $k => $v)
{
if(strlen($agentParams[$k]["NAME"]) > 0 && strlen($v) > 0)
{
?>
<<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
><?php
echo htmlspecialcharsbx($agentParams[$k]["NAME"]);
?>
</<?php
echo GetMessage("SALE_EXPORT_ITEM_NAME");
?>
>
<<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
><?php
echo htmlspecialcharsbx($v);
?>
</<?php
echo GetMessage("SALE_EXPORT_VALUE");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTY_VALUE");
?>
>
<?
}
}
}
?>
</<?php
echo GetMessage("SALE_EXPORT_PROPERTIES_VALUES");
?>
>
</<?php
echo GetMessage("SALE_EXPORT_DOCUMENT");
?>
>
<?
if ($crmMode)
{
$c = ob_get_clean();
$c = CharsetConverter::ConvertCharset($c, $arCharSets[$arOrder["LID"]], "utf-8");
echo $c;
}
}
?>
</<?php
echo GetMessage("SALE_EXPORT_COM_INFORMATION");
?>
>
<?
return $arResultStat;
}
<p class=Normal align=center style='margin:0cm;margin-bottom:.0001pt;
text-align:center;line-height:normal'> </p>
</td>
</tr>
<?php
$mi++;
}
if (DoubleVal($arOrder["PRICE_DELIVERY"]) > 0) {
$nds_val = 0.0;
$nds_pr = 0;
if (DoubleVal($arTaxList[0]["VALUE_MONEY"]) == DoubleVal($total_nds)) {
$item_price = DoubleVal($arOrder["PRICE_DELIVERY"]);
//$nds_val = 0.00;
//$nds_pr = 0;
} else {
$basket_tax = CSaleOrderTax::CountTaxes(DoubleVal($arOrder["PRICE_DELIVERY"]), $arTaxList, $arOrder["CURRENCY"]);
//определяем начальную цену
$item_price = DoubleVal($arOrder["PRICE_DELIVERY"]);
for ($i = 0; $i < count($arTaxList); $i++) {
if ($arTaxList[$i]["IS_IN_PRICE"] == "Y") {
$item_price -= $arTaxList[$i]["TAX_VAL"];
}
$nds_val += $arTaxList[$i]["TAX_VAL"];
$nds_pr += $arTaxList[$i]["VALUE"];
//
//$nds_val = 0.00;
//$nds_pr = 0;
//if($iNds > -1)
//{
// $nds_val = $arTaxList[$iNds]["TAX_VAL"];
// $nds_pr = $arTaxList[$iNds]["VALUE"];
static function DoSaveOrderTax($orderId, $arTaxList, &$arErrors)
{
$arIDs = array();
$dbResult = CSaleOrderTax::GetList(array(), array("ORDER_ID" => $orderId), false, false, array("ID", "TAX_NAME", "CODE"));
while ($arResult = $dbResult->Fetch()) {
$arIDs[$arResult["TAX_NAME"] . "|" . $arResult["CODE"]] = $arResult["ID"];
}
if (is_array($arTaxList)) {
foreach ($arTaxList as $arItem) {
$arFields = array("ORDER_ID" => $orderId, "TAX_NAME" => $arItem["NAME"], "IS_PERCENT" => $arItem["IS_PERCENT"], "VALUE" => $arItem["VALUE"], "VALUE_MONEY" => $arItem["VALUE_MONEY"], "APPLY_ORDER" => $arItem["APPLY_ORDER"], "IS_IN_PRICE" => $arItem["IS_IN_PRICE"], "CODE" => $arItem["CODE"]);
if (array_key_exists($arItem["NAME"] . "|" . $arItem["CODE"], $arIDs)) {
CSaleOrderTax::Update($arIDs[$arItem["NAME"] . "|" . $arItem["CODE"]], $arFields);
unset($arIDs[$arItem["NAME"] . "|" . $arItem["CODE"]]);
} else {
CSaleOrderTax::Add($arFields);
}
}
}
foreach ($arIDs as $id) {
CSaleOrderTax::Delete($id);
}
}
static function DoSaveOrderTax($orderId, $taxList, &$arErrors)
{
$duplicateList = array();
$idList = array();
$res = CSaleOrderTax::GetList(array('ID' => 'ASC'), array("ORDER_ID" => $orderId), false, false, array("ID", "TAX_NAME", "CODE"));
while ($data = $res->Fetch()) {
$hash = $data["TAX_NAME"] . "|" . $data["CODE"];
if (!array_key_exists($hash, $idList)) {
$idList[$data["TAX_NAME"] . "|" . $data["CODE"]] = $data["ID"];
} else {
$duplicateList[$hash] = $data['ID'];
}
}
if (is_array($taxList)) {
foreach ($taxList as $itemData) {
$fields = array("ORDER_ID" => $orderId, "TAX_NAME" => $itemData["NAME"], "IS_PERCENT" => $itemData["IS_PERCENT"], "VALUE" => $itemData["VALUE"], "VALUE_MONEY" => $itemData["VALUE_MONEY"], "APPLY_ORDER" => $itemData["APPLY_ORDER"], "IS_IN_PRICE" => $itemData["IS_IN_PRICE"], "CODE" => $itemData["CODE"]);
$hash = $itemData["NAME"] . "|" . $itemData["CODE"];
if (array_key_exists($hash, $idList)) {
CSaleOrderTax::Update($idList[$hash], $fields);
unset($idList[$hash]);
} elseif (!array_key_exists($hash, $duplicateList)) {
CSaleOrderTax::Add($fields);
}
}
}
foreach ($idList as $code => $id) {
CSaleOrderTax::Delete($id);
}
if (!empty($duplicateList)) {
foreach ($duplicateList as $hash => $id) {
CSaleOrderTax::Delete($id);
}
}
}
/**
* Read some data from database, using cache. Under some info we mean status list, delivery system list and so on.
* This will be a shared cache between sale.personal.order.list and sale.personal.order.detail, so beware of collisions.
* @throws Main\SystemException
* @return void
*/
protected function obtainDataReferences()
{
if ($this->startCache(array('spo-shared'))) {
try {
$cachedData = array();
/////////////////////
/////////////////////
// Person type
$cachedData['PERSON_TYPE'] = array();
$dbPType = CSalePersonType::GetList(array("SORT" => "ASC"));
while ($arPType = $dbPType->Fetch()) {
$cachedData['PERSON_TYPE'][$arPType["ID"]] = $arPType;
}
// Tax list
$cachedData['TAX'] = array();
$dbTaxList = CSaleOrderTax::GetList(array("APPLY_ORDER" => "ASC"));
while ($arTaxList = $dbTaxList->Fetch()) {
$cachedData['TAX'] = $arTaxList;
}
// Save statuses for Filter form
$cachedData['STATUS'] = array();
$dbStatus = CSaleStatus::GetList(array("SORT" => "ASC"), array("LID" => LANGUAGE_ID));
while ($arStatus = $dbStatus->Fetch()) {
$cachedData['STATUS'][$arStatus["ID"]] = $arStatus;
}
$cachedData['PAYSYS'] = array();
$dbPaySystem = CSalePaySystem::GetList(array("SORT" => "ASC"));
while ($arPaySystem = $dbPaySystem->Fetch()) {
$cachedData['PAYSYS'][$arPaySystem["ID"]] = $arPaySystem;
}
$cachedData['DELIVERY'] = array();
$dbDelivery = CSaleDelivery::GetList(array("SORT" => "ASC"));
while ($arDelivery = $dbDelivery->Fetch()) {
$cachedData['DELIVERY'][$arDelivery["ID"]] = $arDelivery;
}
$cachedData['DELIVERY_HANDLERS'] = array();
$dbDelivery = CSaleDeliveryHandler::GetList(array(), array(array("SITE_ID" => SITE_ID)));
while ($arDeliveryHandler = $dbDelivery->Fetch()) {
$cachedData['DELIVERY_HANDLERS'][$arDeliveryHandler["SID"]] = $arDeliveryHandler;
}
/////////////////////
/////////////////////
} catch (Exception $e) {
$this->abortCache();
throw $e;
}
$this->endCache($cachedData);
} else {
$cachedData = $this->getCacheData();
}
$this->dbResult = array_merge($this->dbResult, $cachedData);
}
/**
* @return array
*/
protected function loadList()
{
$resultList = array();
$order = $this->getOrder();
if ($order->getId() <= 0) {
return null;
}
$dbTaxList = \CSaleOrderTax::GetList(array("APPLY_ORDER" => "ASC"), array("ORDER_ID" => $order->getId()));
while ($taxList = $dbTaxList->Fetch()) {
$taxList['NAME'] = $taxList['TAX_NAME'];
$resultList[] = $taxList;
}
return !empty($resultList) ? $resultList : null;
}
function _Delete($ID)
{
global $DB, $USER_FIELD_MANAGER;
$ID = IntVal($ID);
$bSuccess = True;
foreach(GetModuleEvents("sale", "OnBeforeOrderDelete", true) as $arEvent)
if (ExecuteModuleEventEx($arEvent, Array($ID))===false)
return false;
$DB->StartTransaction();
if ($bSuccess)
{
$dbBasket = CSaleBasket::GetList(array(), array("ORDER_ID" => $ID));
while ($arBasket = $dbBasket->Fetch())
{
if (CSaleBasketHelper::isSetItem($arBasket)) // set items are deleted when parent is deleted
continue;
$bSuccess = CSaleBasket::Delete($arBasket["ID"]);
if (!$bSuccess)
break;
}
}
if ($bSuccess)
{
$dbRecurring = CSaleRecurring::GetList(array(), array("ORDER_ID" => $ID));
while ($arRecurring = $dbRecurring->Fetch())
{
$bSuccess = CSaleRecurring::Delete($arRecurring["ID"]);
if (!$bSuccess)
break;
}
}
if ($bSuccess)
$bSuccess = CSaleOrderPropsValue::DeleteByOrder($ID);
if ($bSuccess)
$bSuccess = CSaleOrderTax::DeleteEx($ID);
if($bSuccess)
$bSuccess = CSaleUserTransact::DeleteByOrder($ID);
if ($bSuccess)
unset($GLOBALS["SALE_ORDER"]["SALE_ORDER_CACHE_".$ID]);
if ($bSuccess)
$bSuccess = $DB->Query("DELETE FROM b_sale_order WHERE ID = ".$ID."", true);
if ($bSuccess)
$USER_FIELD_MANAGER->Delete("ORDER", $ID);
if ($bSuccess)
$DB->Commit();
else
$DB->Rollback();
foreach(GetModuleEvents("sale", "OnOrderDelete", true) as $arEvent)
ExecuteModuleEventEx($arEvent, Array($ID, $bSuccess));
return $bSuccess;
}
/**
* Return order tax list
*
* @param array &$cached Cached data.
* @return void
*/
protected function obtainTaxes(&$cached)
{
$cached['TAX'] = array();
if (!empty($this->dbResult['ID'])) {
$taxIterator = CSaleOrderTax::GetList(array('APPLY_ORDER' => 'ASC'), array('ORDER_ID' => $this->dbResult['ID']));
while ($tax = $taxIterator->Fetch()) {
$cached['TAX'][] = $tax;
}
unset($tax, $taxIterator);
}
$cached['TAX_LIST'] = $cached['TAX'];
}
echo GetMessage("SOE_TAX_SORT");
?>
</td>
<td>
<?php
echo GetMessage("SOE_TAX_CODE");
?>
</td>
<td>
<?php
echo GetMessage("SOE_TAX_IN_PRICE");
?>
</td>
</tr>
<?php
$dbTaxList = CSaleOrderTax::GetList(array("APPLY_ORDER" => "ASC"), array("ORDER_ID" => $ID), false, false, array("*"));
$ind = -1;
while ($arTaxList = $dbTaxList->Fetch()) {
$ind++;
$str_TAX_NAME = htmlspecialcharsbx($arTaxList["TAX_NAME"]);
$str_TAX_VALUE = htmlspecialcharsbx($arTaxList["VALUE"]);
$str_TAX_VALUE_MONEY = htmlspecialcharsbx($arTaxList["VALUE_MONEY"]);
$str_TAX_APPLY_ORDER = htmlspecialcharsbx($arTaxList["APPLY_ORDER"]);
$str_TAX_CODE = htmlspecialcharsbx($arTaxList["CODE"]);
$str_TAX_IS_IN_PRICE = htmlspecialcharsbx($arTaxList["IS_IN_PRICE"]);
if ($bVarsFromForm) {
$str_TAX_NAME = htmlspecialcharsbx(${"TAX_NAME_" . $ind});
$str_TAX_VALUE = htmlspecialcharsbx(${"TAX_VALUE_" . $ind});
$str_TAX_VALUE_MONEY = htmlspecialcharsbx(${"TAX_VALUE_MONEY_" . $ind});
$str_TAX_APPLY_ORDER = htmlspecialcharsbx(${"TAX_APPLY_ORDER_" . $ind});
$str_TAX_CODE = htmlspecialcharsbx(${"TAX_CODE_" . $ind});