public static function CheckFields($ACTION, &$arFields, $ID = 0)
{
if ((is_set($arFields, "ORDER_ID") || $ACTION == "ADD") && IntVal($arFields["ORDER_ID"]) <= 0) {
$GLOBALS["APPLICATION"]->ThrowException(GetMessage("SKGOPV_EMPTY_ORDER_ID"), "EMPTY_ORDER_ID");
return false;
}
if ((is_set($arFields, "ORDER_PROPS_ID") || $ACTION == "ADD") && IntVal($arFields["ORDER_PROPS_ID"]) <= 0) {
$GLOBALS["APPLICATION"]->ThrowException(GetMessage("SKGOPV_EMPTY_PROP_ID"), "EMPTY_ORDER_PROPS_ID");
return false;
}
if (is_set($arFields, "ORDER_ID")) {
if (!($arOrder = CSaleOrder::GetByID($arFields["ORDER_ID"]))) {
$GLOBALS["APPLICATION"]->ThrowException(str_replace("#ID#", $arFields["ORDER_ID"], GetMessage("SKGOPV_NO_ORDER_ID")), "ERROR_NO_ORDER");
return false;
}
}
if (is_set($arFields, "ORDER_PROPS_ID")) {
if (!($arOrder = CSaleOrderProps::GetByID($arFields["ORDER_PROPS_ID"]))) {
$GLOBALS["APPLICATION"]->ThrowException(str_replace("#ID#", $arFields["ORDER_PROPS_ID"], GetMessage("SKGOPV_NO_PROP_ID")), "ERROR_NO_PROPERY");
return false;
}
if (is_set($arFields, "ORDER_ID")) {
$arFilter = array("ORDER_ID" => $arFields["ORDER_ID"], "ORDER_PROPS_ID" => $arFields["ORDER_PROPS_ID"]);
if (IntVal($ID) > 0) {
$arFilter["!ID"] = $ID;
}
$dbP = CSaleOrderPropsValue::GetList(array(), $arFilter);
if ($arP = $dbP->Fetch()) {
$GLOBALS["APPLICATION"]->ThrowException(GetMessage("SKGOPV_DUPLICATE_PROP_ID", array("#ID#" => $arFields["ORDER_PROPS_ID"], "#ORDER_ID#" => $arFields["ORDER_ID"])), "ERROR_DUPLICATE_PROP_ID");
return false;
}
}
}
return True;
}
static function DoSaveUserProfile($userId, $profileId, $profileName, $personTypeId, $orderProps, &$arErrors)
{
$profileId = intval($profileId);
$arIDs = array();
if ($profileId > 0) {
$dbProfile = CSaleOrderUserProps::GetList(array(), array("ID" => $profileId), false, false, array("ID", "NAME", "USER_ID", "PERSON_TYPE_ID"));
$arProfile = $dbProfile->Fetch();
if (!$arProfile) {
$arErrors[] = array("CODE" => "PROFILE_NOT_FOUND", "TEXT" => GetMessage('SKGOUP_PROFILE_NOT_FOUND'));
return false;
}
if ($arProfile["USER_ID"] != $userId || $arProfile["PERSON_TYPE_ID"] != $personTypeId) {
$arErrors[] = array("CODE" => "PARAM", "TEXT" => GetMessage('SKGOUP_PARRAMS_ERROR'));
return false;
}
//if (strlen($profileName) > 0 && $profileName != $arProfile["NAME"])
if (strlen($profileName) > 0) {
$arFields = array("NAME" => $profileName, "USER_ID" => $userId);
CSaleOrderUserProps::Update($profileId, $arFields);
}
$dbUserPropsValues = CSaleOrderUserPropsValue::GetList(array(), array("USER_PROPS_ID" => $profileId), false, false, array("ID", "ORDER_PROPS_ID"));
while ($arUserPropsValue = $dbUserPropsValues->Fetch()) {
$arIDs[$arUserPropsValue["ORDER_PROPS_ID"]] = $arUserPropsValue["ID"];
}
}
if (!is_array($orderProps)) {
$dbOrderPropsValues = CSaleOrderPropsValue::GetList(array(), array("ORDER_ID" => intval($orderProps)), false, false, array("ORDER_PROPS_ID", "VALUE"));
$orderProps = array();
while ($arOrderPropsValue = $dbOrderPropsValues->Fetch()) {
$orderProps[$arOrderPropsValue["ORDER_PROPS_ID"]] = $arOrderPropsValue["VALUE"];
}
}
$dbOrderProperties = CSaleOrderProps::GetList(array(), array("PERSON_TYPE_ID" => $personTypeId, "ACTIVE" => "Y", "UTIL" => "N", "USER_PROPS" => "Y"), false, false, array("ID", "TYPE", "NAME", "CODE"));
while ($arOrderProperty = $dbOrderProperties->Fetch()) {
$curVal = $orderProps[$arOrderProperty["ID"]];
if ($arOrderProperty["TYPE"] == "MULTISELECT" && is_array($curVal)) {
$curVal = implode(",", $curVal);
}
if (strlen($curVal) > 0) {
if ($profileId <= 0) {
if (strlen($profileName) <= 0) {
$profileName = GetMessage("SOA_PROFILE") . " " . Date("Y-m-d");
}
$arFields = array("NAME" => $profileName, "USER_ID" => $userId, "PERSON_TYPE_ID" => $personTypeId);
$profileId = CSaleOrderUserProps::Add($arFields);
}
if (array_key_exists($arOrderProperty["ID"], $arIDs)) {
$arFields = array("NAME" => $arOrderProperty["NAME"], "VALUE" => $curVal);
CSaleOrderUserPropsValue::Update($arIDs[$arOrderProperty["ID"]], $arFields);
unset($arIDs[$arOrderProperty["ID"]]);
} else {
$arFields = array("USER_PROPS_ID" => $profileId, "ORDER_PROPS_ID" => $arOrderProperty["ID"], "NAME" => $arOrderProperty["NAME"], "VALUE" => $curVal);
CSaleOrderUserPropsValue::Add($arFields);
}
}
}
foreach ($arIDs as $id) {
CSaleOrderUserPropsValue::Delete($id);
}
}
protected static function getOrderInfo($orderId)
{
// order itself
$order = \CSaleOrder::getById($orderId);
// buyer info
$siteUserId = $order['USER_ID'];
$phone = '';
$email = '';
$result = \CSaleOrderPropsValue::GetList(array(), array("ORDER_ID" => $orderId));
while ($row = $result->fetch()) {
if (empty($phone) && stripos($row['CODE'], 'PHONE') !== false) {
$stPhone = static::normalizePhoneNumber($row['VALUE']);
if (!empty($stPhone)) {
$phone = sha1($stPhone);
}
}
if (empty($email) && stripos($row['CODE'], 'EMAIL') !== false) {
if (!empty($row['VALUE'])) {
$email = sha1($row['VALUE']);
}
}
}
// products info
$products = array();
$result = \CSaleBasket::getList(array(), $arFilter = array('ORDER_ID' => $orderId), false, false, array('PRODUCT_ID'));
while ($row = $result->fetch()) {
$products[] = array('product_id' => $row['PRODUCT_ID'], 'recommendation' => '0');
}
// all together
$data = array('order_id' => $orderId, 'user_id' => $siteUserId, 'phone' => $phone, 'email' => $email, 'products' => $products);
return $data;
}
public static function getOrderPropsValue($orderId, $fetchByCode = true)
{
static $result = array();
$hash = $orderId . '_' . $fetchByCode;
if($result[$hash] === null)
{
$result[$hash] = array();
$rs = \CSaleOrderPropsValue::GetList(array(), array('ORDER_ID' => $orderId), false, false, array('NAME', 'VALUE', 'CODE'));
while($ar = $rs->GetNext(true, false))
{
$obj = new OrderPropsValue($ar);
if($fetchByCode)
{
$result[$hash][$ar['CODE']] = $obj;
}
else
{
$result[$hash][] = $obj;
}
}
}
return $result[$hash];
}
public static function OnBeforeEventAddHandler(&$event, &$lid, &$arFields)
{
if ($event == "SALE_NEW_ORDER") {
$orderId = $arFields['ORDER_ID'];
$dbOrderProps = CSaleOrderPropsValue::GetList(array("CODE" => "ASC"), array("ORDER_ID" => $orderId, "CODE" => array("ORDER_PHONE", "ORDER_ADDRESS", "ORDER_ADDRESS_DETAILS", "ORDER_NAME")));
while ($arOrderProps = $dbOrderProps->GetNext()) {
$arFields[$arOrderProps['CODE']] = $arOrderProps['~VALUE'];
}
$arFields["ORDER_DESCRIPTION"] = trim(CSaleOrder::GetByID($orderId)["USER_DESCRIPTION"]);
}
}
public function getProperties()
{
if (!isset($this->props)) {
$this->props = $this->propsRaw = array();
$res = \CSaleOrderPropsValue::GetList(array('SORT' => 'ASC'), array('ORDER_ID' => $this->id));
while ($row = $res->Fetch()) {
$this->props[$row['CODE']] = $row['VALUE'];
$this->propsRaw[] = $row;
}
}
return $this->props;
}
function AddOrderProperty($prop_id, $value, $order)
{
if (!strlen($prop_id)) {
return false;
}
if (CModule::IncludeModule('sale')) {
if ($arOrderProps = CSaleOrderProps::GetByID($prop_id)) {
$db_vals = CSaleOrderPropsValue::GetList(array(), array('ORDER_ID' => $order, 'ORDER_PROPS_ID' => $arOrderProps['ID']));
if ($arVals = $db_vals->Fetch()) {
return CSaleOrderPropsValue::Update($arVals['ID'], array('NAME' => $arVals['NAME'], 'CODE' => $arVals['CODE'], 'ORDER_PROPS_ID' => $arVals['ORDER_PROPS_ID'], 'ORDER_ID' => $arVals['ORDER_ID'], 'VALUE' => $value));
} else {
return CSaleOrderPropsValue::Add(array('NAME' => $arOrderProps['NAME'], 'CODE' => $arOrderProps['CODE'], 'ORDER_PROPS_ID' => $arOrderProps['ID'], 'ORDER_ID' => $order, 'VALUE' => $value));
}
}
}
}
$arFields = CSaleOrder::GetById($order['externalId']);
// incorrect order
if ($arFields === false || empty($arFields)) {
die();
}
$LID = $arFields['LID'];
$userId = $arFields['USER_ID'];
if(isset($order['customer']['externalId']) && !is_null($order['customer']['externalId'])) {
$userId = $order['customer']['externalId'];
}
$rsOrderProps = CSaleOrderPropsValue::GetList(array(), array('ORDER_ID' => $arFields['ID']));
$arUpdateProps = array();
while ($ar = $rsOrderProps->Fetch()) {
$prop = CSaleOrderProps::GetByID($ar['ORDER_PROPS_ID']);
$arUpdateProps[ $ar['CODE'] ] = array('ID' => $ar['ID'], 'TYPE' => $prop['TYPE'], 'VALUE' => $ar['VALUE']);
}
$order['fio'] = trim(
implode(
' ',
array(
isset($order['lastName']) ? $order['lastName'] : '',
isset($order['firstName']) ? $order['firstName'] : '',
isset($order['patronymic']) ? $order['patronymic'] : '',
)
)
<?if (!defined("B_PROLOG_INCLUDED") || B_PROLOG_INCLUDED !== true) die();?>
<?
CModule::IncludeModule('sale');
$ORDER_ID = $GLOBALS['ORDER_ID'];
$resProp = CSaleOrderPropsValue::GetList(array(), array('ORDER_ID' => $ORDER_ID, 'CODE'=>CSalePaySystemAction::GetParamValue('ORDER_BANK')), false, false, array());
if ($arProp = $resProp->GetNext()) {
$orderId = $arProp['VALUE'];
$url = CSalePaySystemAction::GetParamValue('URL_API').'getOrderStatus.do?';
$json = file_get_contents( $url.'userName='******'LOGIN') ).'&password='******'PASS') ).'&orderId='.urlencode($orderId) );
$obj = json_decode($json);
if($obj->{'errorCode'} == 0 && $obj->{'OrderStatus'} == 2) {
// оплачено
CSaleOrder::PayOrder($ORDER_ID, 'Y');
if (CSalePaySystemAction::GetParamValue('STATUS_PAY')) {
CSaleOrder::Update($ORDER_ID, array('STATUS_ID'=>CSalePaySystemAction::GetParamValue('STATUS_PAY')));
}
return true;
}
}
return false;
function InitParamArrays($arOrder, $orderID = 0, $psParams = "", $relatedData = array(), $payment = array())
{
if (!is_array($relatedData)) {
$relatedData = array();
}
$GLOBALS["SALE_INPUT_PARAMS"] = array();
$GLOBALS["SALE_CORRESPONDENCE"] = array();
if (!is_array($arOrder) || count($arOrder) <= 0 || !array_key_exists("ID", $arOrder)) {
$arOrder = array();
$orderID = IntVal($orderID);
if ($orderID > 0) {
$arOrderTmp = CSaleOrder::GetByID($orderID);
}
if (!empty($arOrderTmp)) {
foreach ($arOrderTmp as $k => $v) {
$arOrder["~" . $k] = $v;
$arOrder[$k] = htmlspecialcharsbx($v);
}
}
} else {
if ($orderID == 0 && $arOrder['ID'] > 0) {
$orderID = $arOrder['ID'];
}
}
if (empty($payment) && $orderID > 0) {
$payment = \Bitrix\Sale\Internals\PaymentTable::getRow(array('select' => array('*'), 'filter' => array('ORDER_ID' => $orderID, '!PAY_SYSTEM_ID' => \Bitrix\Sale\PaySystem\Manager::getInnerPaySystemId())));
}
if (count($arOrder) > 0) {
$GLOBALS["SALE_INPUT_PARAMS"]["ORDER"] = $arOrder;
}
if (!empty($payment)) {
$GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["PAYMENT_ID"] = $payment['ID'];
$GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["~PAYMENT_ID"] = $payment['ID'];
$GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["SHOULD_PAY"] = $payment['SUM'];
$GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["~SHOULD_PAY"] = $payment['SUM'];
$GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["PAYED"] = $payment['PAID'];
$GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["~PAYED"] = $payment['PAID'];
$GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["PAY_SYSTEM_ID"] = $payment['PAY_SYSTEM_ID'];
$GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["~PAY_SYSTEM_ID"] = $payment['PAY_SYSTEM_ID'];
$GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["ORDER_PAYMENT_ID"] = $payment['ID'];
$GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["~ORDER_PAYMENT_ID"] = $payment['ID'];
$GLOBALS["SALE_INPUT_PARAMS"]["PAYMENT"] = $payment;
} else {
$GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["SHOULD_PAY"] = DoubleVal($GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["PRICE"]) - DoubleVal($GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["SUM_PAID"]);
}
$arDateInsert = explode(" ", $GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["DATE_INSERT"]);
if (is_array($arDateInsert) && count($arDateInsert) > 0) {
$GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["DATE_INSERT_DATE"] = $arDateInsert[0];
} else {
$GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["DATE_INSERT_DATE"] = $GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["DATE_INSERT"];
}
if (!empty($payment)) {
$GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["DATE_BILL_DATE"] = ConvertTimeStamp(MakeTimeStamp($payment["DATE_BILL"]), 'SHORT');
}
$userID = IntVal($GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["USER_ID"]);
if ($userID > 0) {
$dbUser = CUser::GetByID($userID);
if ($arUser = $dbUser->GetNext()) {
$GLOBALS["SALE_INPUT_PARAMS"]["USER"] = $arUser;
}
}
$arCurOrderProps = array();
if (isset($relatedData["PROPERTIES"]) && is_array($relatedData["PROPERTIES"])) {
$properties = $relatedData["PROPERTIES"];
foreach ($properties as $key => $value) {
$arCurOrderProps["~" . $key] = $value;
$arCurOrderProps[$key] = htmlspecialcharsEx($value);
}
} else {
$dbOrderPropVals = CSaleOrderPropsValue::GetList(array(), array("ORDER_ID" => $GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["ID"]), false, false, array("ID", "CODE", "VALUE", "ORDER_PROPS_ID", "PROP_TYPE"));
while ($arOrderPropVals = $dbOrderPropVals->Fetch()) {
$arCurOrderPropsTmp = CSaleOrderProps::GetRealValue($arOrderPropVals["ORDER_PROPS_ID"], $arOrderPropVals["CODE"], $arOrderPropVals["PROP_TYPE"], $arOrderPropVals["VALUE"], LANGUAGE_ID);
foreach ($arCurOrderPropsTmp as $key => $value) {
$arCurOrderProps["~" . $key] = $value;
$arCurOrderProps[$key] = htmlspecialcharsEx($value);
}
}
}
if (count($arCurOrderProps) > 0) {
$GLOBALS["SALE_INPUT_PARAMS"]["PROPERTY"] = $arCurOrderProps;
}
$shipment = \Bitrix\Sale\Internals\ShipmentTable::getRow(array('select' => array('DELIVERY_ID'), 'filter' => array('ORDER_ID' => $orderID, 'SYSTEM' => 'N')));
if ($shipment) {
$GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["DELIVERY_ID"] = $shipment['DELIVERY_ID'];
$GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["~DELIVERY_ID"] = $shipment['DELIVERY_ID'];
}
$paySystemId = '';
if ($payment && $payment['PAY_SYSTEM_ID'] > 0) {
$paySystemId = $payment['PAY_SYSTEM_ID'];
} elseif (isset($arOrder['PAY_SYSTEM_ID']) && $arOrder['PAY_SYSTEM_ID'] > 0) {
$paySystemId = $arOrder['PAY_SYSTEM_ID'];
} else {
$psParams = unserialize($psParams);
if (isset($psParams['BX_PAY_SYSTEM_ID'])) {
$paySystemId = $psParams['BX_PAY_SYSTEM_ID']['VALUE'];
}
}
if ($paySystemId !== '') {
if (!isset($arOrder['PERSON_TYPE_ID']) || $arOrder['PERSON_TYPE_ID'] <= 0) {
// for crm quote compatibility
$personTypes = CSalePaySystem::getPaySystemPersonTypeIds($paySystemId);
$personTypeId = array_shift($personTypes);
} else {
$personTypeId = $arOrder['PERSON_TYPE_ID'];
}
$params = CSalePaySystemAction::getParamsByConsumer('PAYSYSTEM_' . $paySystemId, $personTypeId);
foreach ($params as $key => $value) {
$params[$key]['~VALUE'] = htmlspecialcharsbx($value['VALUE']);
}
$GLOBALS["SALE_CORRESPONDENCE"] = $params;
}
if ($payment['COMPANY_ID'] > 0) {
if (!array_key_exists('COMPANY', $GLOBALS["SALE_INPUT_PARAMS"])) {
$GLOBALS["SALE_INPUT_PARAMS"]["COMPANY"] = array();
}
global $USER_FIELD_MANAGER;
$userFieldsList = $USER_FIELD_MANAGER->GetUserFields(\Bitrix\Sale\Internals\CompanyTable::getUfId(), null, LANGUAGE_ID);
foreach ($userFieldsList as $key => $userField) {
$value = $USER_FIELD_MANAGER->GetUserFieldValue(\Bitrix\Sale\Internals\CompanyTable::getUfId(), $key, $payment['COMPANY_ID']);
$GLOBALS["SALE_INPUT_PARAMS"]["COMPANY"][$key] = $value;
$GLOBALS["SALE_INPUT_PARAMS"]["COMPANY"]["~" . $key] = $value;
}
$companyFieldList = \Bitrix\Sale\Internals\CompanyTable::getRowById($payment['COMPANY_ID']);
foreach ($companyFieldList as $key => $value) {
$GLOBALS["SALE_INPUT_PARAMS"]["COMPANY"][$key] = $value;
$GLOBALS["SALE_INPUT_PARAMS"]["COMPANY"]["~" . $key] = $value;
}
}
// fields with no interface
$GLOBALS["SALE_CORRESPONDENCE"]['PAYER_STREET']["TYPE"] = 'PROPERTY';
$GLOBALS["SALE_CORRESPONDENCE"]['PAYER_STREET']["VALUE"] = 'LOCATION_STREET';
$GLOBALS["SALE_CORRESPONDENCE"]['PAYER_STREET']["~VALUE"] = 'LOCATION_STREET';
$GLOBALS["SALE_CORRESPONDENCE"]['PAYER_VILLAGE']["TYPE"] = 'PROPERTY';
$GLOBALS["SALE_CORRESPONDENCE"]['PAYER_VILLAGE']["VALUE"] = 'LOCATION_VILLAGE';
$GLOBALS["SALE_CORRESPONDENCE"]['PAYER_VILLAGE']["~VALUE"] = 'LOCATION_VILLAGE';
$GLOBALS["SALE_CORRESPONDENCE"]['ORDER_PAYMENT_ID']["TYPE"] = 'ORDER';
$GLOBALS["SALE_CORRESPONDENCE"]['ORDER_PAYMENT_ID']["VALUE"] = 'PAYMENT_ID';
$GLOBALS["SALE_CORRESPONDENCE"]['ORDER_PAYMENT_ID']["~VALUE"] = 'PAYMENT_ID';
$GLOBALS["SALE_CORRESPONDENCE"]['PAYED']["TYPE"] = 'ORDER';
$GLOBALS["SALE_CORRESPONDENCE"]['PAYED']["VALUE"] = 'PAYED';
$GLOBALS["SALE_CORRESPONDENCE"]['PAYED']["~VALUE"] = 'PAYED';
if (isset($relatedData["BASKET_ITEMS"]) && is_array($relatedData["BASKET_ITEMS"])) {
$GLOBALS["SALE_INPUT_PARAMS"]["BASKET_ITEMS"] = $relatedData["BASKET_ITEMS"];
}
if (isset($relatedData["TAX_LIST"]) && is_array($relatedData["TAX_LIST"])) {
$GLOBALS["SALE_INPUT_PARAMS"]["TAX_LIST"] = $relatedData["TAX_LIST"];
}
if (isset($relatedData["REQUISITE"]) && is_array($relatedData["REQUISITE"])) {
$GLOBALS["SALE_INPUT_PARAMS"]["REQUISITE"] = $relatedData["REQUISITE"];
self::$relatedData['REQUISITE'] = array('GET_INSTANCE_VALUE' => function ($providerInstance, $providerValue, $personTypeId) {
return $GLOBALS['SALE_INPUT_PARAMS']['REQUISITE'][$providerValue];
});
}
if (isset($relatedData["BANK_DETAIL"]) && is_array($relatedData["BANK_DETAIL"])) {
$GLOBALS["SALE_INPUT_PARAMS"]["BANK_DETAIL"] = $relatedData["BANK_DETAIL"];
self::$relatedData['BANK_DETAIL'] = array('GET_INSTANCE_VALUE' => function ($providerInstance, $providerValue, $personTypeId) {
return $GLOBALS['SALE_INPUT_PARAMS']['BANK_DETAIL'][$providerValue];
});
}
if (isset($relatedData["CRM_COMPANY"]) && is_array($relatedData["CRM_COMPANY"])) {
$GLOBALS["SALE_INPUT_PARAMS"]["CRM_COMPANY"] = $relatedData["CRM_COMPANY"];
self::$relatedData['CRM_COMPANY'] = array('GET_INSTANCE_VALUE' => function ($providerInstance, $providerValue, $personTypeId) {
return $GLOBALS['SALE_INPUT_PARAMS']['CRM_COMPANY'][$providerValue];
});
}
if (isset($relatedData["CRM_CONTACT"]) && is_array($relatedData["CRM_CONTACT"])) {
$GLOBALS["SALE_INPUT_PARAMS"]["CRM_CONTACT"] = $relatedData["CRM_CONTACT"];
self::$relatedData['CRM_CONTACT'] = array('GET_INSTANCE_VALUE' => function ($providerInstance, $providerValue, $personTypeId) {
return $GLOBALS['SALE_INPUT_PARAMS']['CRM_CONTACT'][$providerValue];
});
}
if (isset($relatedData["MC_REQUISITE"]) && is_array($relatedData["MC_REQUISITE"])) {
$GLOBALS["SALE_INPUT_PARAMS"]["MC_REQUISITE"] = $relatedData["MC_REQUISITE"];
self::$relatedData['MC_REQUISITE'] = array('GET_INSTANCE_VALUE' => function ($providerInstance, $providerValue, $personTypeId) {
return $GLOBALS['SALE_INPUT_PARAMS']['MC_REQUISITE'][$providerValue];
});
}
if (isset($relatedData["MC_BANK_DETAIL"]) && is_array($relatedData["MC_BANK_DETAIL"])) {
$GLOBALS["SALE_INPUT_PARAMS"]["MC_BANK_DETAIL"] = $relatedData["MC_BANK_DETAIL"];
self::$relatedData['MC_BANK_DETAIL'] = array('GET_INSTANCE_VALUE' => function ($providerInstance, $providerValue, $personTypeId) {
return $GLOBALS['SALE_INPUT_PARAMS']['MC_BANK_DETAIL'][$providerValue];
});
}
if (isset($relatedData["CRM_MYCOMPANY"]) && is_array($relatedData["CRM_MYCOMPANY"])) {
$GLOBALS["SALE_INPUT_PARAMS"]["CRM_MYCOMPANY"] = $relatedData["CRM_MYCOMPANY"];
self::$relatedData['CRM_MYCOMPANY'] = array('GET_INSTANCE_VALUE' => function ($providerInstance, $providerValue, $personTypeId) {
return $GLOBALS['SALE_INPUT_PARAMS']['CRM_MYCOMPANY'][$providerValue];
});
}
if ($relatedData) {
$eventManager = \Bitrix\Main\EventManager::getInstance();
$eventManager->addEventHandler('sale', 'OnGetBusinessValueProviders', array('\\CSalePaySystemAction', 'getProviders'));
}
}
static function DoSaveOrderProps($orderId, $personTypeId, $arOrderProps, &$arErrors)
{
$arIDs = array();
$dbResult = CSaleOrderPropsValue::GetList(array(), array("ORDER_ID" => $orderId), false, false, array("ID", "ORDER_PROPS_ID"));
while ($arResult = $dbResult->Fetch()) {
$arIDs[$arResult["ORDER_PROPS_ID"]] = $arResult["ID"];
}
$dbOrderProperties = CSaleOrderProps::GetList(array("SORT" => "ASC"), array("PERSON_TYPE_ID" => $personTypeId, "ACTIVE" => "Y"), false, false, array("ID", "TYPE", "NAME", "CODE", "USER_PROPS", "SORT"));
while ($arOrderProperty = $dbOrderProperties->Fetch()) {
$curVal = $arOrderProps[$arOrderProperty["ID"]];
if ($arOrderProperty["TYPE"] == "MULTISELECT" && is_array($curVal)) {
$curVal = implode(",", $curVal);
}
if (strlen($curVal) > 0) {
$arFields = array("ORDER_ID" => $orderId, "ORDER_PROPS_ID" => $arOrderProperty["ID"], "NAME" => $arOrderProperty["NAME"], "CODE" => $arOrderProperty["CODE"], "VALUE" => $curVal);
if (array_key_exists($arOrderProperty["ID"], $arIDs)) {
CSaleOrderPropsValue::Update($arIDs[$arOrderProperty["ID"]], $arFields);
unset($arIDs[$arOrderProperty["ID"]]);
} else {
CSaleOrderPropsValue::Add($arFields);
}
}
}
foreach ($arIDs as $id) {
CSaleOrderPropsValue::Delete($id);
}
}
function fGetBuyerType($PERSON_TYPE_ID, $LID, $USER_ID = '', $ORDER_ID = 0, $formVarsSubmit = false)
{
global $locationZipID, $locationID, $DELIVERY_LOCATION, $DELIVERY_LOCATION_ZIP;
$resultHtml = "<script>locationZipID = 0;locationID = 0;</script><table width=\"100%\" id=\"order_type_props\" class=\"edit-table\">";
//select person type
$arPersonTypeList = array();
$personTypeSelect = "<select name='buyer_type_id' id='buyer_type_id' OnChange='fBuyerChangeType(this);' >";
$dbPersonType = CSalePersonType::GetList(array("SORT" => "ASC", "NAME" => "ASC"), array("ACTIVE" => "Y"));
while ($arPersonType = $dbPersonType->GetNext())
{
if (!in_array($LID, $arPersonType["LIDS"]))
continue;
if (!isset($PERSON_TYPE_ID) OR $PERSON_TYPE_ID == "")
$PERSON_TYPE_ID = $arPersonType["ID"];
$class = "";
if (intval($arPersonType["ID"]) == intval($PERSON_TYPE_ID))
$class = " selected";
$personTypeSelect .= "<option value=\"".$arPersonType["ID"]."\" ".$class.">".$arPersonType["NAME"]." [".$arPersonType["ID"]."]</option>";
}
$personTypeSelect .= "</select>";
$userComment = "";
$userDisplay = "none";
if (intval($ORDER_ID) > 0)
{
$dbOrder = CSaleOrder::GetList(
array(),
array("ID" => $ORDER_ID, "ACTIVE" => "Y"),
false,
false,
array()
);
$arOrder = $dbOrder->Fetch();
$userComment = $arOrder["USER_DESCRIPTION"];
$userDisplay = "table-row";
}
if ($formVarsSubmit && $_REQUEST["btnTypeBuyer"] == "btnBuyerNew")
$userDisplay = "none";
elseif ($formVarsSubmit && $_REQUEST["btnTypeBuyer"] == "btnBuyerExist")
$userDisplay = "table-row";
$resultHtml .= "<tr id=\"btnBuyerExistField\" style=\"display:".$userDisplay."\">
<td class=\"adm-detail-content-cell-l\" width=\"40%\">".GetMessage("NEWO_BUYER").":</td>
<td class=\"adm-detail-content-cell-r\" width=\"60%\"><div id=\"user_name\">".fGetUserName($USER_ID)."</div></td></tr>";
$resultHtml .= "<tr class=\"adm-detail-required-field\">
<td class=\"adm-detail-content-cell-l\" width=\"40%\">".GetMessage("SOE_PERSON_TYPE").":</td>
<td class=\"adm-detail-content-cell-r\" width=\"60%\">".$personTypeSelect."</td>
</tr>";
$bShowTrProfile = "none";
if ($formVarsSubmit && $_POST["btnTypeBuyer"] == "btnBuyerExist")
$bShowTrProfile = "table-row";
$resultHtml .= "<tr id=\"buyer_profile_display\" style=\"display:".$bShowTrProfile."\" class=\"adm-detail-required-field\">
<td class=\"adm-detail-content-cell-l\">".GetMessage("NEWO_BUYER_PROFILE").":</td>
<td class=\"adm-detail-content-cell-r\">
<div id=\"buyer_profile_select\">";
if ($formVarsSubmit && $_POST["btnTypeBuyer"] == "btnBuyerExist")
{
$resultHtml .= fUserProfile(intval($_POST["user_id"]), intval($_POST["buyer_type_id"]), $default = '');
}
$resultHtml .= "</div></td>
</tr>";
if ($ORDER_ID <= 0)
{
$arCountProps = fGetCountProfileProps($PERSON_TYPE_ID);
$resultHtml .= "<tr id=\"btnBuyerNewField\">";
if (count($arCountProps) < 3)
{
$resultHtml .= "<td colspan=2>
<table width=\"100%\" class=\"edit-table\" >";
if (intval($arCountProps["IS_EMAIL"]) <= 0)
$resultHtml .= "<tr class=\"adm-detail-required-field\">
<td class=\"adm-detail-content-cell-l\" width=\"40%\">".GetMessage("NEWO_BUYER_REG_MAIL")."</td>
<td class=\"adm-detail-content-cell-r\"><input type=\"text\" name=\"NEW_BUYER_EMAIL\" size=\"30\" value=\"".htmlspecialcharsbx(trim($_REQUEST["NEW_BUYER_EMAIL"]))."\" tabindex=\"1\" /></td>
</tr>";
if (intval($arCountProps["IS_PAYER"]) <= 0)
$resultHtml .= "<tr class=\"adm-detail-required-field\">
<td class=\"adm-detail-content-cell-l\">".GetMessage("NEWO_BUYER_REG_LASTNAME")."</td>
<td class=\"adm-detail-content-cell-r\"><input type=\"text\" name=\"NEW_BUYER_LAST_NAME\" size=\"30\" value=\"".htmlspecialcharsbx(trim($_REQUEST["NEW_BUYER_LAST_NAME"]))."\" tabindex=\"3\" /></td>
</tr>
<tr class=\"adm-detail-required-field\">
<td class=\"adm-detail-content-cell-l\">".GetMessage("NEWO_BUYER_REG_NAME")."</td>
<td class=\"adm-detail-content-cell-r\"><input type=\"text\" name=\"NEW_BUYER_NAME\" size=\"30\" value=\"".htmlspecialcharsbx(trim($_REQUEST["NEW_BUYER_NAME"]))."\" tabindex=\"2\" /></td>
</tr>";
$resultHtml .= "</table>
</td>";
}
$resultHtml .= "</tr>";
}
$arPropertiesList = array();
$dbProperties = CSaleOrderProps::GetList(
array("GROUP_SORT" => "ASC", "PROPS_GROUP_ID" => "ASC", "SORT" => "ASC", "NAME" => "ASC"),
array("PERSON_TYPE_ID" => $PERSON_TYPE_ID, "ACTIVE" => "Y", "RELATED" => false),
false,
false,
array("*")
);
while($property = $dbProperties->Fetch())
{
$arPropertiesList[$property['ID']] = $property;
}
// getting values
$arPropValues = array();
if ($formVarsSubmit) // from request
{
$locationIndexForm = "";
foreach ($_POST as $key => $value)
{
if (substr($key, 0, strlen("CITY_ORDER_PROP_")) == "CITY_ORDER_PROP_")
{
$arPropValues[intval(substr($key, strlen("CITY_ORDER_PROP_")))] = htmlspecialcharsbx($value);
$locationIndexForm = intval(substr($key, strlen("CITY_ORDER_PROP_")));
}
if (substr($key, 0, strlen("ORDER_PROP_")) == "ORDER_PROP_")
{
if ($locationIndexForm != intval(substr($key, strlen("ORDER_PROP_"))) && !is_array($value))
$arPropValues[intval(substr($key, strlen("ORDER_PROP_")))] = htmlspecialcharsbx($value);
}
}
$userComment = $_POST["USER_DESCRIPTION"];
}
elseif ($ORDER_ID == "" AND $USER_ID != "") // from profile
{
//profile
$userProfile = array();
$userProfile = CSaleOrderUserProps::DoLoadProfiles($USER_ID, $PERSON_TYPE_ID);
$arPropValues = $userProfile[$PERSON_TYPE_ID]["VALUES"];
}
elseif ($ORDER_ID != "") // from order properties
{
$dbPropValuesList = CSaleOrderPropsValue::GetList(
array(),
array("ORDER_ID" => $ORDER_ID, "ACTIVE" => "Y"),
false,
false,
array("ID", "ORDER_PROPS_ID", "NAME", "VALUE", "CODE")
);
while ($arPropValuesList = $dbPropValuesList->Fetch())
{
// from db
if(CSaleLocation::isLocationProMigrated() && $arPropertiesList[$arPropValuesList['ORDER_PROPS_ID']]['TYPE'] == 'LOCATION')
$arPropValuesList["VALUE"] = CSaleLocation::getLocationIDbyCODE($arPropValuesList["VALUE"]);
$arPropValues[intval($arPropValuesList["ORDER_PROPS_ID"])] = htmlspecialcharsbx($arPropValuesList["VALUE"]);
}
}
$location2townFldMap = array();
$arDisableFieldForLocation = array();
//select field (town) for disable
$dbProperties = CSaleOrderProps::GetList(
array(),
array("PERSON_TYPE_ID" => $PERSON_TYPE_ID, "ACTIVE" => "Y", ">INPUT_FIELD_LOCATION" => 0),
false,
false,
array("INPUT_FIELD_LOCATION")
);
while ($arProperties = $dbProperties->Fetch())
{
$arDisableFieldForLocation[$arProperties["INPUT_FIELD_LOCATION"]] = $arProperties["INPUT_FIELD_LOCATION"];
}
//show town if location is another
$arEnableTownProps = array();
$dbOrderProps = CSaleOrderPropsValue::GetOrderProps($ORDER_ID);
while ($arOrderProps = $dbOrderProps->Fetch())
{
if($arOrderProps["TYPE"] == "LOCATION" && $arOrderProps["ACTIVE"] == "Y" && $arOrderProps["IS_LOCATION"] == "Y")
{
if (in_array($arOrderProps["INPUT_FIELD_LOCATION"], $arDisableFieldForLocation))
{
if(CSaleLocation::isLocationProMigrated())
{
if(CSaleLocation::checkLocationIsAboveCity($arPropValues[$arOrderProps["ORDER_PROPS_ID"]]))
unset($arDisableFieldForLocation[$arOrderProps["INPUT_FIELD_LOCATION"]]);
}
else
{
$arLocation = CSaleLocation::GetByID($arPropValues[$arOrderProps["ORDER_PROPS_ID"]]);
if (intval($arLocation["CITY_ID"]) <= 0)
unset($arDisableFieldForLocation[$arOrderProps["INPUT_FIELD_LOCATION"]]);
}
}
$location2townFldMap[$arOrderProps['ORDER_PROPS_ID']] = $arOrderProps['INPUT_FIELD_LOCATION'];
}
}
$propertyGroupID = -1;
foreach($arPropertiesList as $arProperties)
{
if (intval($arProperties["PROPS_GROUP_ID"]) != $propertyGroupID)
{
$resultHtml .= "<tr><td colspan=\"2\" style=\"text-align:center;font-weight:bold;font-size:14px;color:rgb(75, 98, 103);\" >".htmlspecialcharsEx($arProperties["GROUP_NAME"])."\n</td>\n</tr>";
$propertyGroupID = intval($arProperties["PROPS_GROUP_ID"]);
}
if (intval($arProperties["PROPS_GROUP_ID"]) != $propertyGroupID)
$propertyGroupID = intval($arProperties["PROPS_GROUP_ID"]);
$adit = "";
$requiredField = "";
if ($arProperties["REQUIED"] == "Y" || $arProperties["IS_PROFILE_NAME"] == "Y" || $arProperties["IS_LOCATION"] == "Y" || $arProperties["IS_LOCATION4TAX"] == "Y" || $arProperties["IS_PAYER"] == "Y" || $arProperties["IS_ZIP"] == "Y")
{
$adit = " class=\"adm-detail-required-field\"";
$requiredField = " class=\"adm-detail-content-cell-l\"";
}
$isTownProperty = in_array($arProperties["ID"], $location2townFldMap) || $arProperties['CODE'] == 'CITY';
//delete town from location
if (in_array($arProperties["ID"], $arDisableFieldForLocation))
$resultHtml .= "<tr style=\"display:none;\" id=\"town_location_".$arProperties["ID"]."\"".$adit.">\n";
else
$resultHtml .= "<tr id=\"town_location_".$arProperties["ID"]."\"".$adit.($isTownProperty ? " class=\"-bx-order-property-city\"" : '').">\n";
if(($arProperties["TYPE"] == "MULTISELECT" || $arProperties["TYPE"] == "TEXTAREA" || $arProperties["TYPE"] == "FILE") || ($ORDER_ID <= 0 && $arProperties["IS_PROFILE_NAME"] == "Y") )
$resultHtml .= "<td valign=\"top\" class=\"adm-detail-content-cell-l\" width=\"40%\">\n";
else
$resultHtml .= "<td align=\"right\" width=\"40%\" ".$requiredField.">\n";
$resultHtml .= $arProperties["NAME"].":</td>";
$curVal = $arPropValues[intval($arProperties["ID"])];
if($arProperties["IS_EMAIL"] == "Y" || $arProperties["IS_PAYER"] == "Y")
{
if(strlen($arProperties["DEFAULT_VALUE"]) <= 0 && intval($USER_ID) > 0)
{
$rsUser = CUser::GetByID($USER_ID);
if ($arUser = $rsUser->Fetch())
{
if($arProperties["IS_EMAIL"] == "Y")
$arProperties["DEFAULT_VALUE"] = $arUser["EMAIL"];
else
{
if (strlen($arUser["LAST_NAME"]) > 0)
$arProperties["DEFAULT_VALUE"] .= $arUser["LAST_NAME"];
if (strlen($arUser["NAME"]) > 0)
$arProperties["DEFAULT_VALUE"] .= " ".$arUser["NAME"];
if (strlen($arUser["SECOND_NAME"]) > 0 AND strlen($arUser["NAME"]) > 0)
$arProperties["DEFAULT_VALUE"] .= " ".$arUser["SECOND_NAME"];
}
}
}
}
$resultHtml .= "<td class=\"adm-detail-content-cell-r\" width=\"60%\">";
if ($arProperties["TYPE"] == "CHECKBOX")
{
$resultHtml .= '<input type="checkbox" class="inputcheckbox" ';
$resultHtml .= 'name="ORDER_PROP_'.$arProperties["ID"].'" value="Y"';
$resultHtml .= 'id="ORDER_PROP_'.$arProperties["ID"].'" ';
if ($curVal=="Y" || !isset($curVal) && $arProperties["DEFAULT_VALUE"]=="Y")
$resultHtml .= " checked";
$resultHtml .= '>';
}
elseif ($arProperties["TYPE"] == "TEXT")
{
$change = "";
if ($arProperties["IS_ZIP"] == "Y")
{
$DELIVERY_LOCATION_ZIP = $curVal;
$resultHtml .= '<script> locationZipID = \''.$arProperties["ID"].'\';</script>';
$locationZipID = ((isset($curVal)) ? htmlspecialcharsEx($curVal) : htmlspecialcharsex($arProperties["DEFAULT_VALUE"]));
}
if ($arProperties["IS_PAYER"] == "Y" && intval($USER_ID) <= 0)
{
$resultHtml .= '<div id="BREAK_NAME"';
if ($ORDER_ID > 0 || ($formVarsSubmit && $_REQUEST["btnTypeBuyer"] == "btnBuyerExist"))
$resultHtml .= ' style="display:none"';
$resultHtml .= '>';
$BREAK_LAST_NAME_TMP = GetMessage('NEWO_BREAK_LAST_NAME');
if (isset($_REQUEST["BREAK_LAST_NAME"]) && strlen($_REQUEST["BREAK_LAST_NAME"]) > 0)
$BREAK_LAST_NAME_TMP = htmlspecialcharsbx(trim($_REQUEST["BREAK_LAST_NAME"]));
$NEWO_BREAK_NAME_TMP = GetMessage('NEWO_BREAK_NAME');
if (isset($_REQUEST["BREAK_NAME"]) && strlen($_REQUEST["BREAK_NAME"]) > 0)
$NEWO_BREAK_NAME_TMP = htmlspecialcharsbx(trim($_REQUEST["BREAK_NAME"]));
$BREAK_SECOND_NAME_TMP = GetMessage('NEWO_BREAK_SECOND_NAME');
if (isset($_REQUEST["BREAK_SECOND_NAME"]) && strlen($_REQUEST["BREAK_SECOND_NAME"]) > 0)
$BREAK_SECOND_NAME_TMP = htmlspecialcharsbx(trim($_REQUEST["BREAK_SECOND_NAME"]));
$resultHtml .= "<div class=\"fio newo_break_active\"><input onblur=\"if (this.value==''){this.value='".CUtil::JSEscape(GetMessage('NEWO_BREAK_LAST_NAME'))."';BX.addClass(this.parentNode,'newo_break_active');}\" onfocus=\"if (this.value=='".CUtil::JSEscape(GetMessage('NEWO_BREAK_LAST_NAME'))."') {this.value='';BX.removeClass(this.parentNode,'newo_break_active');}\" type=\"text\" name=\"BREAK_LAST_NAME\" id=\"BREAK_LAST_NAME\" size=\"30\" value=\"".$BREAK_LAST_NAME_TMP."\" /></div>";
$resultHtml .= "<div class=\"fio newo_break_active\"><input onblur=\"if (this.value==''){this.value='".CUtil::JSEscape(GetMessage('NEWO_BREAK_NAME'))."';BX.addClass(this.parentNode,'newo_break_active');}\" onfocus=\"if (this.value=='".CUtil::JSEscape(GetMessage('NEWO_BREAK_NAME'))."') {this.value='';BX.removeClass(this.parentNode,'newo_break_active');}\" type=\"text\" name=\"BREAK_NAME\" id=\"BREAK_NAME_BUYER\" size=\"30\" value=\"".$NEWO_BREAK_NAME_TMP."\" /></div>";
$resultHtml .= "<div class=\"fio newo_break_active\"><input onblur=\"if (this.value==''){this.value='".CUtil::JSEscape(GetMessage('NEWO_BREAK_SECOND_NAME'))."';BX.addClass(this.parentNode,'newo_break_active');}\" onfocus=\"if (this.value=='".CUtil::JSEscape(GetMessage('NEWO_BREAK_SECOND_NAME'))."') {this.value='';BX.removeClass(this.parentNode,'newo_break_active');}\" type=\"text\" name=\"BREAK_SECOND_NAME\" id=\"BREAK_SECOND_NAME\" size=\"30\" value=\"".$BREAK_SECOND_NAME_TMP."\" /></div>";
$resultHtml .= '</div>';
$resultHtml .= '<div id="NO_BREAK_NAME"';
if ($ORDER_ID <= 0)
$tmpNone = ' style="display:none"';
if ($formVarsSubmit && $_REQUEST["btnTypeBuyer"] == "btnBuyerExist")
$tmpNone = ' style="display:block"';
$resultHtml .= $tmpNone.'>';
}
$resultHtml .= '<input type="text" maxlength="250" ';
$resultHtml .= 'size="30" ';
$resultHtml .= 'value="'.((isset($curVal)) ? $curVal : $arProperties["DEFAULT_VALUE"]).'" ';
$resultHtml .= 'name="ORDER_PROP_'.$arProperties["ID"].'" ';
$resultHtml .= ($arProperties["IS_ZIP"] == "Y" ? 'class="-bx-property-is-zip" ' : '');
$resultHtml .= 'id="ORDER_PROP_'.$arProperties["ID"].'" '.$change.'>';
if ($arProperties["IS_PAYER"] == "Y" && intval($USER_ID) <= 0)
$resultHtml .= '</div>';
}
elseif ($arProperties["TYPE"] == "SELECT")
{
$size = (intval($arProperties["SIZE1"]) > 0) ? intval($arProperties["SIZE1"]) : 5;
$resultHtml .= '<select name="ORDER_PROP_'.$arProperties["ID"].'" ';
$resultHtml .= 'id="ORDER_PROP_'.$arProperties["ID"].'" ';
$resultHtml .= 'size='.$size.' ';
$resultHtml .= 'class="typeselect">';
$dbVariants = CSaleOrderPropsVariant::GetList(
array("SORT" => "ASC"),
array("ORDER_PROPS_ID" => $arProperties["ID"]),
false,
false,
array("*")
);
while ($arVariants = $dbVariants->Fetch())
{
$resultHtml .= '<option value="'.htmlspecialcharsex($arVariants["VALUE"]).'"';
if ($arVariants["VALUE"] == $curVal || !isset($curVal) && $arVariants["VALUE"] == $arProperties["DEFAULT_VALUE"])
$resultHtml .= " selected";
$resultHtml .= '>'.htmlspecialcharsEx($arVariants["NAME"]).'</option>';
}
$resultHtml .= '</select>';
}
elseif ($arProperties["TYPE"] == "MULTISELECT")
{
$size = (intval($arProperties["SIZE1"]) > 0) ? intval($arProperties["SIZE1"]) : 5;
$resultHtml .= '<select multiple name="ORDER_PROP_'.$arProperties["ID"].'[]" ';
$resultHtml .= 'id="ORDER_PROP_'.$arProperties["ID"].'" ';
$resultHtml .= 'size='.$size.' ';
$resultHtml .= 'class="typeselect" type="multyselect">';
if (!is_array($curVal))
{
if (strlen($curVal) > 0 OR $ORDER_ID != "")
$curVal = explode(",", $curVal);
else
$curVal = explode(",", $arProperties["DEFAULT_VALUE"]);
$arCurVal = array();
$countCurVal = count($curVal);
for ($i = 0; $i < $countCurVal; $i++)
$arCurVal[$i] = Trim($curVal[$i]);
}
else
$arCurVal = $curVal;
$dbVariants = CSaleOrderPropsVariant::GetList(
array("SORT" => "ASC"),
array("ORDER_PROPS_ID" => $arProperties["ID"]),
false,
false,
array("*")
);
while ($arVariants = $dbVariants->Fetch())
{
$resultHtml .= '<option value="'.htmlspecialcharsex($arVariants["VALUE"]).'"';
if (in_array($arVariants["VALUE"], $arCurVal))
$resultHtml .= " selected";
$resultHtml .= '>'.htmlspecialcharsEx($arVariants["NAME"]).'</option>';
}
$resultHtml .= '</select>';
}
elseif ($arProperties["TYPE"] == "TEXTAREA")
{
$resultHtml .= '<textarea ';
$resultHtml .= 'rows="4" ';
$resultHtml .= 'cols="40" ';
$resultHtml .= 'name="ORDER_PROP_'.$arProperties["ID"].'" ';
$resultHtml .= 'id="ORDER_PROP_'.$arProperties["ID"].'" type="textarea">';
$resultHtml .= ((isset($curVal)) ? $curVal : $arProperties["DEFAULT_VALUE"]);
$resultHtml .= '</textarea>';
}
elseif ($arProperties["TYPE"] == "LOCATION")
{
$countryID = "";
$cityID = "";
$cityList = "";
$DELIVERY_LOCATION = $arPropValues[intval($arProperties["ID"])];
$locationID = $curVal;
$tmpLocation = '';
ob_start();
?>
<?if($arProperties['IS_LOCATION'] == 'Y'):?>
<?
$funcId = 'changeLocationCity_'.$arProperties['ID'];
?>
<script>
window['<?php
echo $funcId;
?>
'] = function(node, info){
fChangeLocationCity(node, info, <?php
echo intval($location2townFldMap[$arProperties['ID']]);
?>
)
}
window.orderNewLocationPropId = <?php
echo intval($arProperties['ID']);
?>
;
</script>
<?endif?>
<?
CSaleLocation::proxySaleAjaxLocationsComponent(
array(
"SITE_ID" => $LID,
"AJAX_CALL" => "N",
"COUNTRY_INPUT_NAME" => "ORDER_PROP_".$arProperties["ID"],
"REGION_INPUT_NAME" => "REGION_ORDER_PROP_".$arProperties["ID"],
"CITY_INPUT_NAME" => "CITY_ORDER_PROP_".$arProperties["ID"],
"CITY_OUT_LOCATION" => "Y",
"ALLOW_EMPTY_CITY" => "Y",
"LOCATION_VALUE" => $curVal,
"COUNTRY" => "",
"ONCITYCHANGE" => "fChangeLocationCity();",
"PUBLIC" => "N",
),
array(
"JS_CALLBACK" => $arProperties['IS_LOCATION'] == 'Y' ? $funcId : false,
"ID" => $curVal,
"CODE" => '',
"SHOW_DEFAULT_LOCATIONS" => 'Y',
"JS_CONTROL_GLOBAL_ID" => intval($arProperties["ID"])
),
'',
false,
'location-selector-wrapper'
);
$tmpLocation = ob_get_contents();
ob_end_clean();
$resultHtml .= '<script>var locationID = \''.$arProperties["ID"].'\';</script>';
$resultHtml .= $tmpLocation;
}
elseif ($arProperties["TYPE"] == "RADIO")
{
$dbVariants = CSaleOrderPropsVariant::GetList(
array("SORT" => "ASC"),
array("ORDER_PROPS_ID" => $arProperties["ID"]),
false,
false,
array("*")
);
$resultHtml .= '<div id="ORDER_PROP_'.$arProperties["ID"].'" type="radio">';// type="radio"
while ($arVariants = $dbVariants->Fetch())
{
$resultHtml .= '<input type="radio" class="inputradio" ';
$resultHtml .= 'name="ORDER_PROP_'.$arProperties["ID"].'" ';
$resultHtml .= 'value="'.htmlspecialcharsex($arVariants["VALUE"]).'"';
if ($arVariants["VALUE"] == $curVal || !isset($curVal) && $arVariants["VALUE"] == $arProperties["DEFAULT_VALUE"])
$resultHtml .= " checked";
$resultHtml .= '>'.htmlspecialcharsEx($arVariants["NAME"]).'<br>';
}
$resultHtml .= '</div>';
}
elseif ($arProperties["TYPE"] == "FILE")
{
$arValues = array();
$arTmpValues = array();
if (isset($arPropValues[$arProperties["ID"]]))
{
$arTmpValues = explode(", ", $arPropValues[$arProperties["ID"]]);
foreach ($arTmpValues as $key => $value)
$arValues[$value] = $value;
}
$resultHtml .= fShowFilePropertyField("ORDER_PROP_".$arProperties["ID"], $arProperties, $arValues, $arProperties["SIZE1"], $formVarsSubmit);
}
if (strlen($arProperties["DESCRIPTION"]) > 0)
{
$resultHtml .= "<br><small>".htmlspecialcharsEx($arProperties["DESCRIPTION"])."</small>";
}
$resultHtml .= "\n</td>\n</tr>";
}//end while
$resultHtml .= "<tr>\n<td valign=\"top\" class=\"adm-detail-content-cell-l\">".GetMessage("SOE_BUYER_COMMENT").":
</td>
<td class=\"adm-detail-content-cell-r\">
<textarea name=\"USER_DESCRIPTION\" rows=\"4\" cols=\"40\">".htmlspecialcharsbx($userComment)."</textarea>
</td>
</tr>";
$resultHtml .= "</table>";
return $resultHtml;
}
function RemindPayment()
{
$reminder = COption::GetOptionString("sale", "pay_reminder", "");
$arReminder = unserialize($reminder);
if (!empty($arReminder)) {
$arSites = array();
$minDay = mktime();
foreach ($arReminder as $key => $val) {
if ($val["use"] == "Y") {
$arSites[] = $key;
$days = array();
for ($i = 0; $i <= floor($val["period"] / $val["frequency"]); $i++) {
$day = AddToTimeStamp(array("DD" => -($val["after"] + $val["period"] - $val["frequency"] * $i)));
if ($day < mktime()) {
if ($minDay > $day) {
$minDay = $day;
}
$day = ConvertTimeStamp($day);
$days[] = $day;
}
}
$arReminder[$key]["days"] = $days;
}
}
if (!empty($arSites)) {
$bTmpUser = False;
if (!isset($GLOBALS["USER"]) || !is_object($GLOBALS["USER"])) {
$bTmpUser = True;
$GLOBALS["USER"] = new CUser();
}
$arFilter = array("LID" => $arSites, "PAYED" => "N", "CANCELED" => "N", "ALLOW_DELIVERY" => "N", ">=DATE_INSERT" => ConvertTimeStamp($minDay));
$dbOrder = CSaleOrder::GetList(array("ID" => "DESC"), $arFilter, false, false, array("ID", "DATE_INSERT", "PAYED", "USER_ID", "LID", "PRICE", "CURRENCY"));
while ($arOrder = $dbOrder->GetNext()) {
$date_insert = ConvertDateTime($arOrder["DATE_INSERT"], CSite::GetDateFormat("SHORT"));
if (in_array($date_insert, $arReminder[$arOrder["LID"]]["days"])) {
$strOrderList = "";
$dbBasketTmp = CSaleBasket::GetList(array("NAME" => "ASC"), array("ORDER_ID" => $arOrder["ID"]), false, false, array("ID", "NAME", "QUANTITY"));
while ($arBasketTmp = $dbBasketTmp->Fetch()) {
$strOrderList .= $arBasketTmp["NAME"] . " (" . $arBasketTmp["QUANTITY"] . ")";
$strOrderList .= "\n";
}
$payerEMail = "";
$dbOrderProp = CSaleOrderPropsValue::GetList(array(), array("ORDER_ID" => $arOrder["ID"], "PROP_IS_EMAIL" => "Y"));
if ($arOrderProp = $dbOrderProp->Fetch()) {
$payerEMail = $arOrderProp["VALUE"];
}
$payerName = "";
$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" => $arOrder["ID"], "ORDER_DATE" => $date_insert, "ORDER_USER" => $payerName, "PRICE" => SaleFormatCurrency($arOrder["PRICE"], $arOrder["CURRENCY"]), "BCC" => COption::GetOptionString("sale", "order_email", "order@" . $_SERVER["SERVER_NAME"]), "EMAIL" => $payerEMail, "ORDER_LIST" => $strOrderList, "SALE_EMAIL" => COption::GetOptionString("sale", "order_email", "order@" . $SERVER_NAME));
$eventName = "SALE_ORDER_REMIND_PAYMENT";
$bSend = true;
foreach (GetModuleEvents("sale", "OnOrderRemindSendEmail", true) as $arEvent) {
if (ExecuteModuleEventEx($arEvent, array($arOrder["ID"], &$eventName, &$arFields)) === false) {
$bSend = false;
}
}
if ($bSend) {
$event = new CEvent();
$event->Send($eventName, $arOrder["LID"], $arFields, "N");
}
}
}
if ($bTmpUser) {
unset($GLOBALS["USER"]);
}
}
}
return "CSaleOrder::RemindPayment();";
}
function Withdraw($sum, $currency, $arUserCard, $orderID = 0)
{
$sum = str_replace(",", ".", $sum);
$sum = roundEx(DoubleVal($sum), SALE_VALUE_PRECISION);
if ($sum <= 0) {
$GLOBALS["APPLICATION"]->ThrowException(GetMessage("SKGUC_EMPTY_SUM"), "EMPTY_SUM");
return false;
}
$currency = Trim($currency);
if (strlen($currency) <= 0) {
$GLOBALS["APPLICATION"]->ThrowException(GetMessage("SKGUC_EMPTY_CURRENCY"), "EMPTY_SUM_CURRENCY");
return false;
}
if (!is_array($arUserCard) || count($arUserCard) <= 0) {
$GLOBALS["APPLICATION"]->ThrowException(GetMessage("SKGUC_NO_PARAMS"), "EMPTY_CARD_ARRAY");
return false;
}
$orderID = IntVal($orderID);
if (DoubleVal($arUserCard["SUM_MAX"]) > 0) {
$maxSum = roundEx(CCurrencyRates::ConvertCurrency($arUserCard["SUM_MAX"], $arUserCard["SUM_CURRENCY"], $currency), SALE_VALUE_PRECISION);
if ($maxSum < $sum) {
$GLOBALS["APPLICATION"]->ThrowException(str_replace("#SUM1#", SaleFormatCurrency($arUserCard["SUM_MAX"], $arUserCard["SUM_CURRENCY"]), str_replace("#SUM2#", SaleFormatCurrency($sum, $currency), GetMessage("SKGUC_CROSS_BOUND"))), "MAX_SUM_LIMIT");
return false;
}
}
$arPSAction = CSalePaySystemAction::GetByID($arUserCard["PAY_SYSTEM_ACTION_ID"]);
if (!$arPSAction) {
$GLOBALS["APPLICATION"]->ThrowException(str_replace("#ID#", $arUserCard["PAY_SYSTEM_ACTION_ID"], GetMessage("SKGUC_NO_ACTION")), "NO_PAY_SYSTEM_ACTION");
return false;
}
$psActionPath = $_SERVER["DOCUMENT_ROOT"] . $arPSAction["ACTION_FILE"];
if (!file_exists($psActionPath)) {
$GLOBALS["APPLICATION"]->ThrowException(str_replace("#FILE#", $arPSAction["ACTION_FILE"], GetMessage("SKGUC_NO_PATH")), "NO_PS_PATH");
return false;
}
if (is_file($psActionPath)) {
$psActionPath = dirname($psActionPath);
}
if (!file_exists($psActionPath . "/action.php")) {
$GLOBALS["APPLICATION"]->ThrowException(str_replace("#FILE#", $psActionPath . "/action.php", GetMessage("SKGUC_NO_SCRIPT")), "NO_PS_SCRIPT");
return false;
}
$INPUT_CARD_TYPE = $arUserCard["CARD_TYPE"];
$INPUT_CARD_NUM = CSaleUserCards::CryptData($arUserCard["CARD_NUM"], "D");
$INPUT_CARD_EXP_MONTH = $arUserCard["CARD_EXP_MONTH"];
$INPUT_CARD_EXP_YEAR = $arUserCard["CARD_EXP_YEAR"];
$INPUT_CARD_CODE = $arUserCard["CARD_CODE"];
$INPUT_SUM = $sum;
if (DoubleVal($arUserCard["SUM_MIN"]) > 0) {
$minSum = roundEx(CCurrencyRates::ConvertCurrency($arUserCard["SUM_MIN"], $arUserCard["SUM_CURRENCY"], $currency), SALE_VALUE_PRECISION);
if ($minSum > $sum) {
$INPUT_SUM = $minSum;
}
}
$INPUT_CURRENCY = $currency;
$GLOBALS["SALE_INPUT_PARAMS"] = array();
$dbUser = CUser::GetByID(IntVal($arUserCard["USER_ID"]));
if ($arUser = $dbUser->Fetch()) {
$GLOBALS["SALE_INPUT_PARAMS"]["USER"] = $arUser;
}
if ($orderID > 0) {
if ($arOrder = CSaleOrder::GetByID($orderID)) {
$GLOBALS["SALE_INPUT_PARAMS"]["ORDER"] = $arOrder;
$GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["SHOULD_PAY"] = DoubleVal($arOrder["PRICE"]) - DoubleVal($arOrder["SUM_PAID"]);
$arDateInsert = explode(" ", $arOrder["DATE_INSERT"]);
if (is_array($arDateInsert) && count($arDateInsert) > 0) {
$GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["DATE_INSERT_DATE"] = $arDateInsert[0];
} else {
$GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["DATE_INSERT_DATE"] = $arOrder["DATE_INSERT"];
}
}
$arCurOrderProps = array();
$dbOrderPropVals = CSaleOrderPropsValue::GetList(array(), array("ORDER_ID" => $ORDER_ID), false, false, array("ID", "CODE", "VALUE", "ORDER_PROPS_ID", "PROP_TYPE"));
while ($arOrderPropVals = $dbOrderPropVals->Fetch()) {
$arCurOrderPropsTmp = CSaleOrderProps::GetRealValue($arOrderPropVals["ORDER_PROPS_ID"], $arOrderPropVals["CODE"], $arOrderPropVals["PROP_TYPE"], $arOrderPropVals["VALUE"], LANGUAGE_ID);
foreach ($arCurOrderPropsTmp as $key => $value) {
$arCurOrderProps[$key] = $value;
}
}
if (count($arCurOrderProps) > 0) {
$GLOBALS["SALE_INPUT_PARAMS"]["PROPERTY"] = $arCurOrderProps;
}
}
$GLOBALS["SALE_CORRESPONDENCE"] = CSalePaySystemAction::UnSerializeParams($arPSAction["PARAMS"]);
include $psActionPath . "/action.php";
$INPUT_CARD_NUM = "";
if (strlen($OUTPUT_ERROR_MESSAGE) > 0) {
$GLOBALS["APPLICATION"]->ThrowException($OUTPUT_ERROR_MESSAGE, "ERROR_MESSAGE");
return false;
}
$arFields = array("LAST_STATUS" => $OUTPUT_STATUS, "LAST_STATUS_CODE" => $OUTPUT_STATUS_CODE, "LAST_STATUS_DESCRIPTION" => $OUTPUT_STATUS_DESCRIPTION, "LAST_STATUS_MESSAGE" => $OUTPUT_STATUS_MESSAGE, "LAST_SUM" => $OUTPUT_SUM, "LAST_CURRENCY" => $OUTPUT_CURRENCY, "LAST_DATE" => Date(CDatabase::DateFormatToPHP(CLang::GetDateFormat("FULL", LANG))));
CSaleUserCards::Update($arUserCard["ID"], $arFields);
if ($OUTPUT_STATUS == "Y") {
$OUTPUT_SUM = str_replace(",", ".", $OUTPUT_SUM);
$OUTPUT_SUM = DoubleVal($OUTPUT_SUM);
if ($OUTPUT_CURRENCY != $currency) {
$OUTPUT_SUM = roundEx(CCurrencyRates::ConvertCurrency($OUTPUT_SUM, $OUTPUT_CURRENCY, $currency), SALE_VALUE_PRECISION);
}
return $OUTPUT_SUM;
}
$GLOBALS["APPLICATION"]->ThrowException($OUTPUT_STATUS_DESCRIPTION, "ERROR_PAY");
return False;
}
function GetParam($iOrderID, $iPersonType, $sPPField)
{
require $_SERVER["DOCUMENT_ROOT"] . "/bitrix/modules/epages.pickpoint/constants.php";
$arTableOptions = unserialize(COption::GetOptionString("epages.pickpoint", "OPTIONS"));
if (!isset($arTableOptions[$iPersonType][$sPPField])) {
$arData = array($arOptionDefaults[$sPPField]);
} else {
$arData = $arTableOptions[$iPersonType][$sPPField];
}
$arReturn = array();
foreach ($arData as $arOption) {
switch ($arOption["TYPE"]) {
case "ANOTHER":
$arReturn[] = $arOption["VALUE"];
break;
case "USER":
$obOrder = CSaleOrder::GetList(array(), array("ID" => $iOrderID), false, false, array("ID", "USER_ID"));
$arOrder = $obOrder->Fetch();
$obUser = CUser::GetByID($arOrder["USER_ID"]);
if ($arUser = $obUser->Fetch()) {
if ($arOption["VALUE"] == "USER_FIO") {
$arReturn[] = $arUser["LAST_NAME"] . ($arUser["NAME"] ? " " . $arUser["NAME"] : "") . ($arUser["SECOND_NAME"] ? " " . $arUser["SECOND_NAME"] : "");
} elseif (strlen($arUser[$arOption["VALUE"]])) {
$arReturn[] = $arUser[$arOption["VALUE"]];
}
}
break;
case "ORDER":
$arOrder = CSaleOrder::GetByID($iOrderID);
$arReturn[] = $arOrder[$arOption["VALUE"]];
break;
case "PROPERTY":
$obProperty = CSaleOrderPropsValue::GetList(array(), array("ORDER_ID" => $iOrderID, "ORDER_PROPS_ID" => $arOption["VALUE"]), false, false, array("VALUE"));
if ($arProperty = $obProperty->Fetch()) {
if (strlen($arProperty["VALUE"]) > 0) {
$arReturn[] = $arProperty["VALUE"];
}
}
break;
}
}
return $arReturn;
}
/**
* <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 InitParamArrays($arOrder, $orderID = 0, $psParams = "", $relatedData = array())
{
if (!is_array($relatedData)) {
$relatedData = array();
}
$GLOBALS["SALE_INPUT_PARAMS"] = array();
$GLOBALS["SALE_CORRESPONDENCE"] = array();
if (!is_array($arOrder) || count($arOrder) <= 0 || !array_key_exists("ID", $arOrder)) {
$arOrder = array();
$orderID = IntVal($orderID);
if ($orderID > 0) {
$arOrderTmp = CSaleOrder::GetByID($orderID);
}
if (!empty($arOrderTmp)) {
foreach ($arOrderTmp as $k => $v) {
$arOrder["~" . $k] = $v;
$arOrder[$k] = htmlspecialcharsbx($v);
}
}
}
if (count($arOrder) > 0) {
$GLOBALS["SALE_INPUT_PARAMS"]["ORDER"] = $arOrder;
}
$GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["SHOULD_PAY"] = DoubleVal($GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["PRICE"]) - DoubleVal($GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["SUM_PAID"]);
$arDateInsert = explode(" ", $GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["DATE_INSERT"]);
if (is_array($arDateInsert) && count($arDateInsert) > 0) {
$GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["DATE_INSERT_DATE"] = $arDateInsert[0];
} else {
$GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["DATE_INSERT_DATE"] = $GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["DATE_INSERT"];
}
if (strlen(trim($GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["DATE_BILL"])) > 0) {
$GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["DATE_BILL_DATE"] = ConvertTimeStamp(MakeTimeStamp($GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["DATE_BILL"]), 'SHORT');
} else {
$GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["DATE_BILL_DATE"] = "";
}
$userID = IntVal($GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["USER_ID"]);
if ($userID > 0) {
$dbUser = CUser::GetByID($userID);
if ($arUser = $dbUser->GetNext()) {
$GLOBALS["SALE_INPUT_PARAMS"]["USER"] = $arUser;
}
}
$arCurOrderProps = array();
if (isset($relatedData["PROPERTIES"]) && is_array($relatedData["PROPERTIES"])) {
$properties = $relatedData["PROPERTIES"];
foreach ($properties as $key => $value) {
$arCurOrderProps["~" . $key] = $value;
$arCurOrderProps[$key] = htmlspecialcharsEx($value);
}
} else {
$dbOrderPropVals = CSaleOrderPropsValue::GetList(array(), array("ORDER_ID" => $GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["ID"]), false, false, array("ID", "CODE", "VALUE", "ORDER_PROPS_ID", "PROP_TYPE"));
while ($arOrderPropVals = $dbOrderPropVals->Fetch()) {
$arCurOrderPropsTmp = CSaleOrderProps::GetRealValue($arOrderPropVals["ORDER_PROPS_ID"], $arOrderPropVals["CODE"], $arOrderPropVals["PROP_TYPE"], $arOrderPropVals["VALUE"], LANGUAGE_ID);
foreach ($arCurOrderPropsTmp as $key => $value) {
$arCurOrderProps["~" . $key] = $value;
$arCurOrderProps[$key] = htmlspecialcharsEx($value);
}
}
}
if (count($arCurOrderProps) > 0) {
$GLOBALS["SALE_INPUT_PARAMS"]["PROPERTY"] = $arCurOrderProps;
}
if (strlen($psParams) <= 0) {
$dbPaySysAction = CSalePaySystemAction::GetList(array(), array("PAY_SYSTEM_ID" => IntVal($GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["PAY_SYSTEM_ID"]), "PERSON_TYPE_ID" => IntVal($GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["PERSON_TYPE_ID"])), false, false, array("PARAMS"));
if ($arPaySysAction = $dbPaySysAction->Fetch()) {
$psParams = $arPaySysAction["PARAMS"];
}
}
$GLOBALS["SALE_CORRESPONDENCE"] = CSalePaySystemAction::UnSerializeParams($psParams);
foreach ($GLOBALS["SALE_CORRESPONDENCE"] as $key => $val) {
$GLOBALS["SALE_CORRESPONDENCE"][$key]["~VALUE"] = $val["VALUE"];
$GLOBALS["SALE_CORRESPONDENCE"][$key]["VALUE"] = htmlspecialcharsEx($val["VALUE"]);
}
// fields with no interface
$GLOBALS["SALE_CORRESPONDENCE"]['PAYER_STREET']["TYPE"] = 'PROPERTY';
$GLOBALS["SALE_CORRESPONDENCE"]['PAYER_STREET']["VALUE"] = 'LOCATION_STREET';
$GLOBALS["SALE_CORRESPONDENCE"]['PAYER_STREET']["~VALUE"] = 'LOCATION_STREET';
$GLOBALS["SALE_CORRESPONDENCE"]['PAYER_VILLAGE']["TYPE"] = 'PROPERTY';
$GLOBALS["SALE_CORRESPONDENCE"]['PAYER_VILLAGE']["VALUE"] = 'LOCATION_VILLAGE';
$GLOBALS["SALE_CORRESPONDENCE"]['PAYER_VILLAGE']["~VALUE"] = 'LOCATION_VILLAGE';
if (isset($relatedData["BASKET_ITEMS"]) && is_array($relatedData["BASKET_ITEMS"])) {
$GLOBALS["SALE_INPUT_PARAMS"]["BASKET_ITEMS"] = $relatedData["BASKET_ITEMS"];
}
if (isset($relatedData["TAX_LIST"]) && is_array($relatedData["TAX_LIST"])) {
$GLOBALS["SALE_INPUT_PARAMS"]["TAX_LIST"] = $relatedData["TAX_LIST"];
}
}
function InitParamArrays($arOrder, $orderID = 0, $psParams = "")
{
$GLOBALS["SALE_INPUT_PARAMS"] = array();
$GLOBALS["SALE_CORRESPONDENCE"] = array();
if (!is_array($arOrder) || count($arOrder) <= 0 || !array_key_exists("ID", $arOrder)) {
$arOrder = array();
$orderID = IntVal($orderID);
if ($orderID > 0) {
$arOrderTmp = CSaleOrder::GetByID($orderID);
}
if (!empty($arOrderTmp)) {
foreach ($arOrderTmp as $k => $v) {
$arOrder["~" . $k] = $v;
$arOrder[$k] = htmlspecialcharsbx($v);
}
}
}
if (count($arOrder) > 0) {
$GLOBALS["SALE_INPUT_PARAMS"]["ORDER"] = $arOrder;
}
$GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["SHOULD_PAY"] = DoubleVal($GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["PRICE"]) - DoubleVal($GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["SUM_PAID"]);
$arDateInsert = explode(" ", $GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["DATE_INSERT"]);
if (is_array($arDateInsert) && count($arDateInsert) > 0) {
$GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["DATE_INSERT_DATE"] = $arDateInsert[0];
} else {
$GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["DATE_INSERT_DATE"] = $GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["DATE_INSERT"];
}
$userID = IntVal($GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["USER_ID"]);
if ($userID > 0) {
$dbUser = CUser::GetByID($userID);
if ($arUser = $dbUser->GetNext()) {
$GLOBALS["SALE_INPUT_PARAMS"]["USER"] = $arUser;
}
}
$arCurOrderProps = array();
$dbOrderPropVals = CSaleOrderPropsValue::GetList(array(), array("ORDER_ID" => $GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["ID"]), false, false, array("ID", "CODE", "VALUE", "ORDER_PROPS_ID", "PROP_TYPE"));
while ($arOrderPropVals = $dbOrderPropVals->Fetch()) {
$arCurOrderPropsTmp = CSaleOrderProps::GetRealValue($arOrderPropVals["ORDER_PROPS_ID"], $arOrderPropVals["CODE"], $arOrderPropVals["PROP_TYPE"], $arOrderPropVals["VALUE"], LANGUAGE_ID);
foreach ($arCurOrderPropsTmp as $key => $value) {
$arCurOrderProps["~" . $key] = $value;
$arCurOrderProps[$key] = htmlspecialcharsEx($value);
}
}
if (count($arCurOrderProps) > 0) {
$GLOBALS["SALE_INPUT_PARAMS"]["PROPERTY"] = $arCurOrderProps;
}
if (strlen($psParams) <= 0) {
$dbPaySysAction = CSalePaySystemAction::GetList(array(), array("PAY_SYSTEM_ID" => IntVal($GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["PAY_SYSTEM_ID"]), "PERSON_TYPE_ID" => IntVal($GLOBALS["SALE_INPUT_PARAMS"]["ORDER"]["PERSON_TYPE_ID"])), false, false, array("PARAMS"));
if ($arPaySysAction = $dbPaySysAction->Fetch()) {
$psParams = $arPaySysAction["PARAMS"];
}
}
$GLOBALS["SALE_CORRESPONDENCE"] = CSalePaySystemAction::UnSerializeParams($psParams);
foreach ($GLOBALS["SALE_CORRESPONDENCE"] as $key => $val) {
$GLOBALS["SALE_CORRESPONDENCE"][$key]["~VALUE"] = $val["VALUE"];
$GLOBALS["SALE_CORRESPONDENCE"][$key]["VALUE"] = htmlspecialcharsEx($val["VALUE"]);
}
}
protected static function getOrderInfo($orderId)
{
// order itself
$order = \CSaleOrder::getById($orderId);
// buyer info
$siteUserId = $order['USER_ID'];
$phone = '';
$email = '';
$result = \CSaleOrderPropsValue::GetList(array(), array("ORDER_ID" => $orderId));
while ($row = $result->fetch()) {
if (empty($phone) && stripos($row['CODE'], 'PHONE') !== false) {
$stPhone = static::normalizePhoneNumber($row['VALUE']);
if (!empty($stPhone)) {
$phone = sha1($stPhone);
}
}
if (empty($email) && stripos($row['CODE'], 'EMAIL') !== false) {
if (!empty($row['VALUE'])) {
$email = sha1($row['VALUE']);
}
}
}
// products info
$products = array();
$result = \CSaleBasket::getList(array(), $arFilter = array('ORDER_ID' => $orderId, 'MODULE' => 'catalog'), false, false, array('PRODUCT_ID', 'RECOMMENDATION', 'QUANTITY', 'PRICE', 'CURRENCY'));
while ($row = $result->fetch()) {
$productInfo = \CCatalogSKU::GetProductInfo($row['PRODUCT_ID']);
$iblockId = 0;
if (!empty($productInfo['ID'])) {
$realProductId = $productInfo['ID'];
$iblockId = $productInfo['IBLOCK_ID'];
} else {
$realProductId = $row['PRODUCT_ID'];
// get iblock id
$element = \Bitrix\Iblock\ElementTable::getRow(array('select' => array('IBLOCK_ID'), 'filter' => array('=ID' => $realProductId)));
if (!empty($element)) {
$iblockId = $element['IBLOCK_ID'];
}
}
$products[] = array('product_id' => $realProductId, 'iblock_id' => $iblockId, 'quantity' => $row['QUANTITY'], 'price' => $row['PRICE'], 'currency' => $row['CURRENCY'], 'recommendation' => $row['RECOMMENDATION']);
}
// all together
$data = array('order_id' => $orderId, 'user_id' => $siteUserId, 'phone' => $phone, 'email' => $email, 'products' => $products, 'price' => $order['PRICE'], 'currency' => $order['CURRENCY']);
return $data;
}
static function DoSaveUserProfile($userId, $profileId, $profileName, $personTypeId, $orderProps, &$arErrors)
{
$profileId = intval($profileId);
$arIDs = array();
if ($profileId > 0) {
$dbProfile = CSaleOrderUserProps::GetList(array(), array("ID" => $profileId), false, false, array("ID", "NAME", "USER_ID", "PERSON_TYPE_ID"));
$arProfile = $dbProfile->Fetch();
if (!$arProfile) {
$arErrors[] = array("CODE" => "PROFILE_NOT_FOUND", "TEXT" => GetMessage('SKGOUP_PROFILE_NOT_FOUND'));
return false;
}
if ($arProfile["USER_ID"] != $userId || $arProfile["PERSON_TYPE_ID"] != $personTypeId) {
$arErrors[] = array("CODE" => "PARAM", "TEXT" => GetMessage('SKGOUP_PARRAMS_ERROR'));
return false;
}
//if (strlen($profileName) > 0 && $profileName != $arProfile["NAME"])
if (strlen($profileName) > 0) {
$arFields = array("NAME" => $profileName, "USER_ID" => $userId);
CSaleOrderUserProps::Update($profileId, $arFields);
}
$dbUserPropsValues = CSaleOrderUserPropsValue::GetList(array(), array("USER_PROPS_ID" => $profileId), false, false, array("ID", "ORDER_PROPS_ID"));
while ($arUserPropsValue = $dbUserPropsValues->Fetch()) {
$arIDs[$arUserPropsValue["ORDER_PROPS_ID"]] = $arUserPropsValue["ID"];
}
}
if (!is_array($orderProps)) {
$dbOrderPropsValues = CSaleOrderPropsValue::GetList(array(), array("ORDER_ID" => intval($orderProps)), false, false, array("ORDER_PROPS_ID", "VALUE"));
$orderProps = array();
while ($arOrderPropsValue = $dbOrderPropsValues->Fetch()) {
$orderProps[$arOrderPropsValue["ORDER_PROPS_ID"]] = $arOrderPropsValue["VALUE"];
}
}
/*
TRANSLATION_CUT_OFF
else
{
// map location ID to CODE, if taken from parameters
static::TranslateLocationPropertyValues($personTypeId, $orderProps);
}
*/
$utilPropertyList = array();
$dbOrderProperties = CSaleOrderProps::GetList(array(), array("PERSON_TYPE_ID" => $personTypeId, "ACTIVE" => "Y", "USER_PROPS" => "Y"), false, false, array("ID", "TYPE", "NAME", "CODE", "UTIL"));
while ($arOrderProperty = $dbOrderProperties->Fetch()) {
if ($arOrderProperty['UTIL'] == "Y") {
$utilPropertyList[] = $arIDs[$arOrderProperty["ID"]];
continue;
}
$curVal = $orderProps[$arOrderProperty["ID"]];
if ($arOrderProperty["TYPE"] == "MULTISELECT" && is_array($curVal)) {
$curVal = implode(",", $curVal);
}
if ($arOrderProperty["TYPE"] == "FILE" && is_array($curVal)) {
$fileList = array();
foreach ($curVal as $fileDat) {
$fileList[] = $fileDat['ID'];
}
$curVal = serialize($fileList);
}
if (strlen($curVal) > 0) {
if ($profileId <= 0) {
if (strlen($profileName) <= 0) {
$profileName = GetMessage("SOA_PROFILE") . " " . Date("Y-m-d");
}
$arFields = array("NAME" => $profileName, "USER_ID" => $userId, "PERSON_TYPE_ID" => $personTypeId);
$profileId = CSaleOrderUserProps::Add($arFields);
}
if (array_key_exists($arOrderProperty["ID"], $arIDs)) {
$arFields = array("NAME" => $arOrderProperty["NAME"], "VALUE" => $curVal);
CSaleOrderUserPropsValue::Update($arIDs[$arOrderProperty["ID"]], $arFields);
unset($arIDs[$arOrderProperty["ID"]]);
} else {
$arFields = array("USER_PROPS_ID" => $profileId, "ORDER_PROPS_ID" => $arOrderProperty["ID"], "NAME" => $arOrderProperty["NAME"], "VALUE" => $curVal);
CSaleOrderUserPropsValue::Add($arFields);
}
}
}
foreach ($arIDs as $id) {
if (!empty($utilPropertyList) && in_array($id, $utilPropertyList)) {
continue;
}
CSaleOrderUserPropsValue::Delete($id);
}
}
$SORT = 100;
}
$PROPS_GROUP_ID = IntVal($PROPS_GROUP_ID);
if ($PROPS_GROUP_ID <= 0) {
$strError .= GetMessage("ERROR_NO_GROUP") . "<br>";
}
if (strlen($strError) <= 0) {
unset($arFields);
$arFields = array("PERSON_TYPE_ID" => $PERSON_TYPE_ID, "NAME" => $NAME, "TYPE" => $TYPE, "REQUIED" => $REQUIED, "DEFAULT_VALUE" => $DEFAULT_VALUE, "SORT" => $SORT, "CODE" => strlen($CODE) <= 0 ? False : $CODE, "USER_PROPS" => $USER_PROPS, "IS_LOCATION" => $IS_LOCATION, "IS_LOCATION4TAX" => $IS_LOCATION4TAX, "PROPS_GROUP_ID" => $PROPS_GROUP_ID, "SIZE1" => $SIZE1, "SIZE2" => $SIZE2, "DESCRIPTION" => $DESCRIPTION, "IS_EMAIL" => $IS_EMAIL, "IS_PROFILE_NAME" => $IS_PROFILE_NAME, "IS_PAYER" => $IS_PAYER, "IS_FILTERED" => $IS_FILTERED, "IS_ZIP" => $IS_ZIP, "ACTIVE" => $ACTIVE, "UTIL" => $UTIL, "INPUT_FIELD_LOCATION" => $INPUT_FIELD_LOCATION);
if ($ID > 0) {
if (!CSaleOrderProps::Update($ID, $arFields)) {
$strError .= GetMessage("ERROR_EDIT_PROP") . "<br>";
}
if (strlen($strError) <= 0) {
//$db_order_props_tmp = CSaleOrderPropsValue::GetList(($b="NAME"), ($o="ASC"), Array("ORDER_PROPS_ID"=>$ID));
$db_order_props_tmp = CSaleOrderPropsValue::GetList($b = "ID", $o = "ASC", array("ORDER_PROPS_ID" => $ID, "!CODE" => strlen($CODE) <= 0 ? False : $CODE));
while ($ar_order_props_tmp = $db_order_props_tmp->Fetch()) {
CSaleOrderPropsValue::Update($ar_order_props_tmp["ID"], array("CODE" => strlen($CODE) <= 0 ? False : $CODE));
}
}
} else {
$ID = CSaleOrderProps::Add($arFields);
if ($ID <= 0) {
$strError .= GetMessage("ERROR_ADD_PROP") . "<br>";
}
}
}
if (strlen($strError) <= 0) {
if ($TYPE == "SELECT" || $TYPE == "MULTISELECT" || $TYPE == "RADIO") {
$numpropsvals = IntVal($numpropsvals);
for ($i = 0; $i <= $numpropsvals; $i++) {
/**
* @param \Bitrix\Sale\Order $order
* @param $arOrder
* @param $agentParams
* @param $bExportFromCrm
* @param $bCrmModuleIncluded
* @param $paySystems
* @param $delivery
* @param array $options
*
* @return array|void
*/
function getSaleProperties(Bitrix\Sale\Order $order, $arOrder, $agentParams, $bExportFromCrm, $bCrmModuleIncluded, $paySystems, $delivery, array $options = array())
{
$providersInstance = self::getProvidersInstanceByOrder($order);
$personTypeId = $order->getPersonTypeId();
$personTypes = BusinessValue::getPersonTypes();
if (!($personType = $personTypes[$personTypeId])) {
self::logError($order->getId(), 'Undefined DOMAIN for person type id "' . $personTypeId . '"');
return;
}
$systemCodes1C = array_flip(self::$systemCodes[$personType['DOMAIN']]);
$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"));
$locationStreetPropertyValue = '';
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);
if (CSaleLocation::isLocationProEnabled()) {
if (intval($arVal['ID'])) {
try {
$res = \Bitrix\Sale\Location\LocationTable::getPathToNode($arVal['ID'], array('select' => array('LNAME' => 'NAME.NAME', 'TYPE_ID'), 'filter' => array('=NAME.LANGUAGE_ID' => LANGUAGE_ID)));
$types = \Bitrix\Sale\Location\Admin\TypeHelper::getTypeCodeIdMapCached();
$path = array();
while ($item = $res->fetch()) {
// copy street to STREET property
if ($types['ID2CODE'][$item['TYPE_ID']] == 'STREET') {
$locationStreetPropertyValue = $item['LNAME'];
}
$path[] = $item['LNAME'];
}
$locationString = implode(' - ', $path);
} catch (\Bitrix\Main\SystemException $e) {
$locationString = '';
}
} else {
$locationString = '';
}
} else {
$locationString = $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"]] = $locationString;
$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) {
//params
if (!is_array($v)) {
$agent["REKV"][$k] = $v;
} else {
if (strlen($v["TYPE"]) <= 0) {
$agent["REKV"][$k] = $v["VALUE"];
} else {
switch ($v["TYPE"]) {
case 'CRM':
$agent["REKV"][$k] = $arProp[$v["TYPE"]][$v["VALUE"]];
//value
break;
default:
if (!($codeKey = $systemCodes1C[$k]) && substr($k, 0, 5) === 'REKV_' && ($codeIndex = substr($k, 5)) !== '' && ($codeKey = BusinessValueConsumer1C::getRekvCodeKey($order->getPersonTypeId(), $codeIndex)) && ($providerInstance = $providersInstance[$order->getId()][$v["TYPE"]]) && is_set($providerInstance)) {
$agent["REKV"][$k] = Bitrix\Sale\BusinessValue::getValueFromProvider($providerInstance, $codeKey, BusinessValueConsumer1C::CONSUMER_KEY);
}
}
}
}
} else {
if (!is_array($v)) {
$agent[$k] = $v;
} else {
if (strlen($v["TYPE"]) <= 0) {
$agent[$k] = $v["VALUE"];
} else {
switch ($v["TYPE"]) {
case 'CRM':
$agent[$k] = $arProp[$v["TYPE"]][$v["VALUE"]];
break;
default:
if (($codeKey = $systemCodes1C[$k]) && ($providerInstance = $providersInstance[$order->getId()][$v["TYPE"]]) && is_set($providerInstance)) {
$agent[$k] = Bitrix\Sale\BusinessValue::getValueFromProvider($providerInstance, $codeKey, BusinessValueConsumer1C::CONSUMER_KEY);
}
}
}
if ($k == 'STREET' && strlen($locationStreetPropertyValue)) {
$agent[$k] = $locationStreetPropertyValue . (strlen($agent[$k]) ? ', ' : '') . $agent[$k];
}
}
}
}
return array('agent' => $agent, 'arProp' => $arProp);
}
} else {
$transaction->setPaymentTransactionType();
}
$notification_url = \Bitrix\Main\Config\Option::get($module_id, "notification_url");
$notification_url = str_replace('bitrix.local', 'bitrix.webhook.begateway.com:8443', $notification_url);
$transaction->setNotificationUrl($notification_url);
$transaction->setSuccessUrl(\Bitrix\Main\Config\Option::get($module_id, "success_url"));
$transaction->setFailUrl(\Bitrix\Main\Config\Option::get($module_id, "fail_url"));
$transaction->setDeclineUrl(\Bitrix\Main\Config\Option::get($module_id, "fail_url"));
$transaction->setCancelUrl(\Bitrix\Main\Config\Option::get($module_id, "cancel_url"));
//Получаем информацию о клиенте из профиля
$firstName = $_SESSION["SESS_AUTH"]["FIRST_NAME"];
$lastName = $_SESSION["SESS_AUTH"]["LAST_NAME"];
$email = $_SESSION["SESS_AUTH"]["EMAIL"];
if (\Bitrix\Main\Loader::includeModule("sale")) {
$db_prop_order_vals = CSaleOrderPropsValue::GetList(array("SORT" => "ASC"), array("ORDER_ID" => $order_id, "CODE" => array("CITY", "ZIP", "PHONE", "ADDRESS")), false, false, array("CODE", "ID", "VALUE"));
while ($val = $db_prop_order_vals->Fetch()) {
if (!empty($val["VALUE"])) {
${strtolower($val["CODE"])} = $val["VALUE"];
}
}
}
//Тестовые данные
//$firstName = "John";
//$city = "RigaGGG";
//$zip = "LV-1082";
//$email = "*****@*****.**";
//$country = "LV";
//$phone = ;
//$state = ;
if ($firtName) {
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;
}
$val["DISCOUNT_RATION_PERCENT"] = round($val["PRICE"] * 100 / $priceTotal, 5);
$val["DISCOUNT_RATION_VALUE"] = round($discount * $val["DISCOUNT_RATION_PERCENT"] / 100, 5);
$val["PRICE"] -= $val["DISCOUNT_RATION_VALUE"];
$arBasket[$key] = $val;
}
return $arBasket;
}
if (CModule::IncludeModule("sale")) {
if ($arOrder = CSaleOrder::GetByID($ORDER_ID)) {
$rep_file_name = GetRealPath2Report($doc . ".php");
if (strlen($rep_file_name) <= 0) {
ShowError("PRINT TEMPLATE NOT FOUND");
die;
}
$arOrderProps = array();
$dbOrderPropVals = CSaleOrderPropsValue::GetList(array(), array("ORDER_ID" => $ORDER_ID), false, false, array("ID", "CODE", "VALUE", "ORDER_PROPS_ID", "PROP_TYPE"));
while ($arOrderPropVals = $dbOrderPropVals->Fetch()) {
$arCurOrderPropsTmp = CSaleOrderProps::GetRealValue($arOrderPropVals["ORDER_PROPS_ID"], $arOrderPropVals["CODE"], $arOrderPropVals["PROP_TYPE"], $arOrderPropVals["VALUE"], LANGUAGE_ID);
foreach ($arCurOrderPropsTmp as $key => $value) {
$arOrderProps[$key] = $value;
}
}
if (CSaleLocation::isLocationProMigrated()) {
if (strlen($arOrderProps['LOCATION_VILLAGE']) && !strlen($arOrderProps['LOCATION_CITY'])) {
$arOrderProps['LOCATION_CITY'] = $arOrderProps['LOCATION_VILLAGE'];
}
// street added to the beginning of address, as it used to be before
if (strlen($arOrderProps['LOCATION_STREET']) && isset($arOrderProps['ADDRESS'])) {
$arOrderProps['ADDRESS'] = $arOrderProps['LOCATION_STREET'] . (strlen($arOrderProps['ADDRESS']) ? ', ' . $arOrderProps['ADDRESS'] : '');
}
}
static function DoSaveOrderProps($orderId, $personTypeId, $arOrderProps, &$arErrors, $paysystemId = 0, $deliveryId = "")
{
$arIDs = array();
$dbResult = CSaleOrderPropsValue::GetList(array(), array("ORDER_ID" => $orderId), false, false, array("ID", "ORDER_PROPS_ID"));
while ($arResult = $dbResult->Fetch()) {
$arIDs[$arResult["ORDER_PROPS_ID"]] = $arResult["ID"];
}
$arFilter = array("PERSON_TYPE_ID" => $personTypeId, "ACTIVE" => "Y");
if ($paysystemId != 0) {
$arFilter["RELATED"]["PAYSYSTEM_ID"] = $paysystemId;
$arFilter["RELATED"]["TYPE"] = "WITH_NOT_RELATED";
}
if (strlen($deliveryId) > 0) {
$arFilter["RELATED"]["DELIVERY_ID"] = $deliveryId;
$arFilter["RELATED"]["TYPE"] = "WITH_NOT_RELATED";
}
$dbOrderProperties = CSaleOrderProps::GetList(array("SORT" => "ASC"), $arFilter, false, false, array("ID", "TYPE", "NAME", "CODE", "USER_PROPS", "SORT"));
while ($arOrderProperty = $dbOrderProperties->Fetch()) {
$curVal = $arOrderProps[$arOrderProperty["ID"]];
if ($arOrderProperty["TYPE"] == "MULTISELECT" && is_array($curVal)) {
$curVal = implode(",", $curVal);
}
if ($arOrderProperty["TYPE"] == "FILE" && is_array($curVal)) {
$tmpVal = "";
foreach ($curVal as $index => $fileData) {
$bModify = true;
if (isset($fileData["file_id"])) {
if (isset($fileData["del"])) {
$arFile = CFile::MakeFileArray($fileData["file_id"]);
$arFile["del"] = $fileData["del"];
$arFile["old_file"] = $fileData["file_id"];
} else {
$bModify = false;
if (strlen($tmpVal) > 0) {
$tmpVal .= ", " . $fileData["file_id"];
} else {
$tmpVal = $fileData["file_id"];
}
}
} else {
// new file array
$arFile = $fileData;
}
if (isset($arFile["name"]) && strlen($arFile["name"]) > 0 && $bModify) {
$arFile["MODULE_ID"] = "sale";
$fid = CFile::SaveFile($arFile, "sale");
if (intval($fid) > 0) {
if (strlen($tmpVal) > 0) {
$tmpVal .= ", " . $fid;
} else {
$tmpVal = $fid;
}
}
}
}
$curVal = $tmpVal;
}
if (strlen($curVal) > 0) {
$arFields = array("ORDER_ID" => $orderId, "ORDER_PROPS_ID" => $arOrderProperty["ID"], "NAME" => $arOrderProperty["NAME"], "CODE" => $arOrderProperty["CODE"], "VALUE" => $curVal);
if (array_key_exists($arOrderProperty["ID"], $arIDs)) {
CSaleOrderPropsValue::Update($arIDs[$arOrderProperty["ID"]], $arFields);
unset($arIDs[$arOrderProperty["ID"]]);
} else {
CSaleOrderPropsValue::Add($arFields);
}
}
}
foreach ($arIDs as $id) {
CSaleOrderPropsValue::Delete($id);
}
}
false,
array("ID", "NAME", "TYPE", "REQUIED", "IS_LOCATION", "IS_EMAIL", "IS_PROFILE_NAME", "IS_PAYER", "IS_LOCATION4TAX", "CODE", "SORT")
);
while ($arOrderProps = $dbOrderProps->Fetch())
{
$orderPropList[$arOrderProps['ID']] = $arOrderProps;
if ($arOrderProps['TYPE'] == 'FILE')
$orderFileProps[$arOrderProps['ID']] = $arOrderProps;
}
if ($crmMode && $ID > 0 && !empty($orderFileProps))
{
$rsFileOrderProps = CSaleOrderPropsValue::GetList(
array(),
array("ORDER_ID" => $ID, 'ORDER_PROPS_ID' => array_keys($orderFileProps)),
false,
false,
array("ID", "ORDER_ID", "ORDER_PROPS_ID", "VALUE")
);
while ($oneFileOrderProp = $rsFileOrderProps->Fetch())
{
if (!isset($orderFilePropsValue[$oneFileOrderProp['ORDER_PROPS_ID']]))
$orderFilePropsValue[$oneFileOrderProp['ORDER_PROPS_ID']] = array();
$oneFileOrderProp['VALUE'] = trim($oneFileOrderProp['VALUE']);
if ($oneFileOrderProp['VALUE'] != '')
{
$orderFilePropsValue[$oneFileOrderProp['ORDER_PROPS_ID']] = explode(', ', $oneFileOrderProp['VALUE']);
}
}
unset($oneFileOrderProp, $rsFileOrderProps);
}
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;
}
echo $arPersTypeList["ID"];
?>
] <?php
echo $arPersTypeList["NAME"];
?>
</option><?php
}
?>
</select>
</td>
</tr>
<?php
$arPropValues = array();
if (!$bVarsFromForm || $PARTIAL_SUBMIT == "Y") {
$dbPropValuesList = CSaleOrderPropsValue::GetList(array(), array("ORDER_ID" => $ID), false, false, array("ID", "ORDER_PROPS_ID", "NAME", "VALUE", "CODE"));
while ($arPropValuesList = $dbPropValuesList->Fetch()) {
$arPropValues[IntVal($arPropValuesList["ORDER_PROPS_ID"])] = $arPropValuesList["VALUE"];
}
} else {
foreach ($_REQUEST as $key => $value) {
if (substr($key, 0, strlen("ORDER_PROP_")) == "ORDER_PROP_") {
$arPropValues[IntVal(substr($key, strlen("ORDER_PROP_")))] = htmlspecialcharsEx($value);
}
}
}
$propertyGroupID = -1;
$dbProperties = CSaleOrderProps::GetList(array("GROUP_SORT" => "ASC", "PROPS_GROUP_ID" => "ASC", "SORT" => "ASC", "NAME" => "ASC"), array("PERSON_TYPE_ID" => $str_PERSON_TYPE_ID), false, false, array("*"));
while ($arProperties = $dbProperties->Fetch()) {
if (IntVal($arProperties["PROPS_GROUP_ID"]) != $propertyGroupID) {
?>
}
$property['DEFAULT_VALUE'] = $files;
}
// prepare property for database & set defaults
$propertyForDB = array();
foreach ($commonSettings + $inputSettings + $stringSettings + $locationSettings as $name => $input) {
$propertyForDB[$name] = Input\Manager::getValue($input, $property[$name]);
}
$propertyForDB['SETTINGS'] = array_intersect_key($propertyForDB, $inputSettings);
$propertyForDB = array_diff_key($propertyForDB, $propertyForDB['SETTINGS']);
// 1. update property
if ($propertyId) {
$update = OrderPropsTable::update($propertyId, array_diff_key($propertyForDB, array('ID' => 1)));
if ($update->isSuccess()) {
$propertyCode = ($v = $property['CODE']) ? $v : false;
$result = CSaleOrderPropsValue::GetList($b = 'ID', $o = 'ASC', array('ORDER_PROPS_ID' => $propertyId, '!CODE' => $propertyCode));
while ($row = $result->Fetch()) {
CSaleOrderPropsValue::Update($row['ID'], array('CODE' => $propertyCode));
}
} else {
$errors[] = loc::getMessage('ERROR_EDIT_PROP') . ': ' . implode(', ', $update->getErrorMessages());
}
} else {
$insert = OrderPropsTable::add($propertyForDB);
if ($insert->isSuccess()) {
$propertyId = $property['ID'] = $insert->getId();
} else {
$errors[] = loc::getMessage('ERROR_ADD_PROP') . ': ' . implode(', ', $insert->getErrorMessages());
}
}
// cleanup files
