function Update($ID, $arFields)
{
global $DB;
$ID = IntVal($ID);
if (!CSaleOrderPropsVariant::CheckFields("UPDATE", $arFields, $ID)) {
return false;
}
$strUpdate = $DB->PrepareUpdate("b_sale_order_props_variant", $arFields);
$strSql = "UPDATE b_sale_order_props_variant SET " . $strUpdate . " WHERE ID = " . $ID . "";
$DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
return $ID;
}
static function GetProfileProps($profileID, $personID) {
if (!empty($profileID)) {
// получаем значения свойств
$props = array();
$res = CSaleOrderUserPropsValue::GetList(array(), array('USER_PROPS_ID'=>$profileID), false, false, array('ID', 'ORDER_PROPS_ID', 'VALUE'));
while ($arRes = $res->Fetch()) {
$props[$arRes['ORDER_PROPS_ID']] = array('VALUE' => htmlspecialchars($arRes['VALUE']));
}
}
// если не задан $personID
if (empty($personID)) {
$res = CSalePersonType::GetList(Array(), Array());
if ($arRes = $res->Fetch()) {
$personID = $arRes["ID"];
}
}
// получаем свойства
$arProps = array();
$res = CSaleOrderProps::GetList(array("SORT"=>"ASC"), array("PERSON_TYPE_ID" => $personID, "USER_PROPS" => "Y"), false, false, array());
while ($arRes = $res->Fetch()) {
if (in_array($arRes["TYPE"], array("SELECT", "MULTISELECT", "RADIO"))) {
$rs = \CSaleOrderPropsVariant::GetList(array(), array("ORDER_PROPS_ID" => $arRes["ID"]));
while ($arRs = $rs->Fetch()) {
$arRes["variants"][] = $arRs;
}
}
if (!empty($props[$arRes['ID']])) {
$arProps[$arRes['ID']] = array_merge($props[$arRes['ID']], $arRes);
} else {
$arProps[$arRes['ID']] = $arRes;
}
}
return $arProps;
}
$propCityId = $id;
}
if(strlen($prop["CODE"]) > 0)
{
//$arGeneralInfo["propCode"][$prop["CODE"]] = $prop["CODE"];
$arGeneralInfo["propCodeID"][$prop["CODE"]] = $id;
$arGeneralInfo["properies"][$prop["PERSON_TYPE_ID"]][$prop["CODE"]] = $prop;
$arGeneralInfo["properies"][$prop["PERSON_TYPE_ID"]][$prop["CODE"]]["ID"] = $id;
}
if(!empty($variants))
{
foreach($variants as $val)
{
$val["ORDER_PROPS_ID"] = $id;
CSaleOrderPropsVariant::Add($val);
}
}
}
/*
$propReplace = "";
foreach($arGeneralInfo["properies"] as $key => $val)
{
if(IntVal($val["LOCATION"]["ID"]) > 0)
$propReplace .= '"PROP_'.$key.'" => Array(0 => "'.$val["LOCATION"]["ID"].'"), ';
}
WizardServices::ReplaceMacrosRecursive(WIZARD_SITE_PATH."personal/order/", Array("PROPS" => $propReplace));
*/
//1C export
if($personType["fiz"] == "Y" && !$fizExist)
{
</td>
<td align="center"><?php
echo GetMessage("SALE_VARIANTS_SORT");
?>
</td>
<td align="center"><?php
echo GetMessage("SALE_VARIANTS_DESCR");
?>
</td>
<td align="center"><?php
echo GetMessage("SALE_VARIANTS_DEL");
?>
</td>
</tr>
<?php
$db_propsVars = CSaleOrderPropsVariant::GetList($b = "SORT", $o = "ASC", array("ORDER_PROPS_ID" => $ID));
$ind = -1;
$oldind = -1;
while ($db_propsVars->ExtractFields("f_")) {
$ind++;
$oldind++;
if ($bInitVars) {
$DB->InitTableVarsForEdit("b_sale_order_props_variant", "", "f_", "_" . $oldind);
}
?>
<tr>
<td>
<input type="hidden" name="ID_<?php
echo $ind;
?>
" value="<?php
function GetRealValue($propertyID, $propertyCode, $propertyType, $value, $lang = false)
{
$propertyID = IntVal($propertyID);
$propertyCode = Trim($propertyCode);
$propertyType = Trim($propertyType);
if ($lang === false) {
$lang = LANGUAGE_ID;
}
$arResult = array();
$curKey = strlen($propertyCode) > 0 ? $propertyCode : $propertyID;
if ($propertyType == "SELECT" || $propertyType == "RADIO") {
$arValue = CSaleOrderPropsVariant::GetByValue($propertyID, $value);
$arResult[$curKey] = $arValue["NAME"];
} elseif ($propertyType == "MULTISELECT") {
$curValue = "";
if (!is_array($value)) {
$value = explode(",", $value);
}
for ($i = 0; $i < count($value); $i++) {
if ($arValue1 = CSaleOrderPropsVariant::GetByValue($propertyID, $value[$i])) {
if ($i > 0) {
$curValue .= ",";
}
$curValue .= $arValue1["NAME"];
}
}
$arResult[$curKey] = $curValue;
} elseif ($propertyType == "LOCATION") {
$arValue = CSaleLocation::GetByID($value, $lang);
$curValue = $arValue["COUNTRY_NAME"] . (strlen($arValue["COUNTRY_NAME"]) <= 0 || strlen($arValue["CITY_NAME"]) <= 0 ? "" : " - ") . $arValue["CITY_NAME"];
$arResult[$curKey] = $curValue;
$arResult[$curKey . "_COUNTRY"] = $arValue["COUNTRY_NAME"];
$arResult[$curKey . "_CITY"] = $arValue["CITY_NAME"];
} else {
$arResult[$curKey] = $value;
}
return $arResult;
}
function getOrderPropFormated($arProperties, $arResult, &$arUserResult, &$arDeleteFieldLocation = array())
{
global $USER;
$curVal = $arUserResult["ORDER_PROP"][$arProperties["ID"]];
$curLocation = false;
static $propertyGroupID = 0;
static $propertyUSER_PROPS = "";
// take data from user profile
if ($arUserResult["PROFILE_CHANGE"] == "Y" && intval($arUserResult["PROFILE_ID"]) > 0 && !($arResult["HAVE_PREPAYMENT"] && $arUserResult["PROFILE_DEFAULT"] == "Y" && !empty($arResult["PREPAY_ORDER_PROPS"][$arProperties["CODE"]]))) {
$dbUserPropsValues = CSaleOrderUserPropsValue::GetList(array("SORT" => "ASC"), array("USER_PROPS_ID" => $arUserResult["PROFILE_ID"], "ORDER_PROPS_ID" => $arProperties["ID"], "USER_ID" => intval($USER->GetID())), false, false, array("VALUE", "PROP_TYPE", "VARIANT_NAME", "SORT", "ORDER_PROPS_ID"));
if ($arUserPropsValues = $dbUserPropsValues->Fetch()) {
$valueTmp = "";
if ($arUserPropsValues["PROP_TYPE"] == "MULTISELECT") {
$arUserPropsValues["VALUE"] = explode(",", $arUserPropsValues["VALUE"]);
}
$curVal = $arUserPropsValues["VALUE"];
}
} elseif ($arUserResult["PROFILE_CHANGE"] == "Y" && intval($arUserResult["PROFILE_ID"]) <= 0) {
if (isset($curVal)) {
unset($curVal);
}
} elseif (isset($arUserResult["ORDER_PROP"][$arProperties["ID"]])) {
$curVal = $arUserResult["ORDER_PROP"][$arProperties["ID"]];
} elseif ($arResult["HAVE_PREPAYMENT"] && !empty($arResult["PREPAY_ORDER_PROPS"][$arProperties["CODE"]])) {
$curVal = $arResult["PREPAY_ORDER_PROPS"][$arProperties["CODE"]];
if ($arProperties["TYPE"] == "LOCATION") {
$curLocation = $curVal;
}
}
if (intval($_REQUEST["NEW_LOCATION_" . $arProperties["ID"]]) > 0) {
$curVal = intval($_REQUEST["NEW_LOCATION_" . $arProperties["ID"]]);
}
$arProperties["FIELD_NAME"] = "ORDER_PROP_" . $arProperties["ID"];
if (strlen($arProperties["CODE"]) > 0) {
$arProperties["FIELD_ID"] = "ORDER_PROP_" . $arProperties["CODE"];
} else {
$arProperties["FIELD_ID"] = "ORDER_PROP_" . $arProperties["ID"];
}
if (intval($arProperties["PROPS_GROUP_ID"]) != $propertyGroupID || $propertyUSER_PROPS != $arProperties["USER_PROPS"]) {
$arProperties["SHOW_GROUP_NAME"] = "Y";
}
$propertyGroupID = $arProperties["PROPS_GROUP_ID"];
$propertyUSER_PROPS = $arProperties["USER_PROPS"];
if ($arProperties["REQUIED"] == "Y" || $arProperties["IS_EMAIL"] == "Y" || $arProperties["IS_PROFILE_NAME"] == "Y" || $arProperties["IS_LOCATION"] == "Y" || $arProperties["IS_LOCATION4TAX"] == "Y" || $arProperties["IS_PAYER"] == "Y" || $arProperties["IS_ZIP"] == "Y") {
$arProperties["REQUIED_FORMATED"] = "Y";
}
if ($arProperties["TYPE"] == "CHECKBOX") {
if ($curVal == "Y" || !isset($curVal) && $arProperties["DEFAULT_VALUE"] == "Y") {
$arProperties["CHECKED"] = "Y";
$arProperties["VALUE_FORMATED"] = GetMessage("SOA_Y");
} else {
$arProperties["VALUE_FORMATED"] = GetMessage("SOA_N");
}
$arProperties["SIZE1"] = intval($arProperties["SIZE1"]) > 0 ? $arProperties["SIZE1"] : 30;
} elseif ($arProperties["TYPE"] == "TEXT") {
if (strlen($curVal) <= 0) {
if (strlen($arProperties["DEFAULT_VALUE"]) > 0 && !isset($curVal)) {
$arProperties["VALUE"] = $arProperties["DEFAULT_VALUE"];
} elseif ($arProperties["IS_EMAIL"] == "Y") {
$arProperties["VALUE"] = $USER->GetEmail();
} elseif ($arProperties["IS_PAYER"] == "Y") {
//$arProperties["VALUE"] = $USER->GetFullName();
$rsUser = CUser::GetByID($USER->GetID());
$fio = "";
if ($arUser = $rsUser->Fetch()) {
$fio = CUser::FormatName(CSite::GetNameFormat(false), array("NAME" => $arUser["NAME"], "LAST_NAME" => $arUser["LAST_NAME"], "SECOND_NAME" => $arUser["SECOND_NAME"]), false, false);
}
$arProperties["VALUE"] = $fio;
}
} else {
$arProperties["VALUE"] = $curVal;
}
//select ZIP for LOCATION
if ($arProperties["IS_ZIP"] == "Y" && $arUserResult["PROFILE_CHANGE"] == "N") {
$dbPropertiesLoc = CSaleOrderProps::GetList(array("ID" => "DESC"), array("PERSON_TYPE_ID" => $arUserResult["PERSON_TYPE_ID"], "ACTIVE" => "Y", "UTIL" => "N", "IS_LOCATION" => "Y"), false, false, array("ID"));
$arPropertiesLoc = $dbPropertiesLoc->Fetch();
if ($arPropertiesLoc["ID"] > 0) {
$arZipLocation = array();
if (strlen($curVal) > 0) {
$arZipLocation = CSaleLocation::GetByZIP($curVal);
}
$rsZipList = CSaleLocation::GetLocationZIP($arUserResult["ORDER_PROP"][$arPropertiesLoc["ID"]]);
if ($arZip = $rsZipList->Fetch()) {
if (strlen($arZip["ZIP"]) > 0 && (empty($arZipLocation) || $arZipLocation["ID"] != $arUserResult["ORDER_PROP"][$arPropertiesLoc["ID"]])) {
$arProperties["VALUE"] = $arZip["ZIP"];
}
}
}
}
if ($arProperties["IS_ZIP"] == "Y") {
$arUserResult["DELIVERY_LOCATION_ZIP"] = $arProperties["VALUE"];
}
$arProperties["VALUE"] = htmlspecialcharsEx($arProperties["VALUE"]);
$arProperties["VALUE_FORMATED"] = $arProperties["VALUE"];
} elseif ($arProperties["TYPE"] == "SELECT") {
$arProperties["SIZE1"] = intval($arProperties["SIZE1"]) > 0 ? $arProperties["SIZE1"] : 1;
$dbVariants = CSaleOrderPropsVariant::GetList(array("SORT" => "ASC", "NAME" => "ASC"), array("ORDER_PROPS_ID" => $arProperties["ID"]), false, false, array("*"));
$flagDefault = "N";
$nameProperty = "";
while ($arVariants = $dbVariants->GetNext()) {
if ($flagDefault == "N" && $nameProperty == "") {
$nameProperty = $arVariants["NAME"];
}
if ($arVariants["VALUE"] == $curVal || (!isset($curVal) || $curVal == "") && $arVariants["VALUE"] == $arProperties["DEFAULT_VALUE"]) {
$arVariants["SELECTED"] = "Y";
$arProperties["VALUE_FORMATED"] = $arVariants["NAME"];
$flagDefault = "Y";
}
$arProperties["VARIANTS"][] = $arVariants;
}
if ($flagDefault == "N") {
$arProperties["VARIANTS"][0]["SELECTED"] = "Y";
$arProperties["VARIANTS"][0]["VALUE_FORMATED"] = $nameProperty;
}
} elseif ($arProperties["TYPE"] == "MULTISELECT") {
$arProperties["FIELD_NAME"] = "ORDER_PROP_" . $arProperties["ID"] . '[]';
$arProperties["SIZE1"] = intval($arProperties["SIZE1"]) > 0 ? $arProperties["SIZE1"] : 5;
$arDefVal = explode(",", $arProperties["DEFAULT_VALUE"]);
$countDefVal = count($arDefVal);
for ($i = 0; $i < $countDefVal; $i++) {
$arDefVal[$i] = Trim($arDefVal[$i]);
}
$dbVariants = CSaleOrderPropsVariant::GetList(array("SORT" => "ASC"), array("ORDER_PROPS_ID" => $arProperties["ID"]), false, false, array("*"));
$i = 0;
while ($arVariants = $dbVariants->GetNext()) {
if (is_array($curVal) && in_array($arVariants["VALUE"], $curVal) || !isset($curVal) && in_array($arVariants["VALUE"], $arDefVal)) {
$arVariants["SELECTED"] = "Y";
if ($i > 0) {
$arProperties["VALUE_FORMATED"] .= ", ";
}
$arProperties["VALUE_FORMATED"] .= $arVariants["NAME"];
$i++;
}
$arProperties["VARIANTS"][] = $arVariants;
}
} elseif ($arProperties["TYPE"] == "TEXTAREA") {
$arProperties["SIZE2"] = intval($arProperties["SIZE2"]) > 0 ? $arProperties["SIZE2"] : 4;
$arProperties["SIZE1"] = intval($arProperties["SIZE1"]) > 0 ? $arProperties["SIZE1"] : 40;
$arProperties["VALUE"] = htmlspecialcharsEx(isset($curVal) ? $curVal : $arProperties["DEFAULT_VALUE"]);
$arProperties["VALUE_FORMATED"] = $arProperties["VALUE"];
} elseif ($arProperties["TYPE"] == "LOCATION") {
//enable location town text
if ($_REQUEST["is_ajax_post"] == "Y" && $arProperties["IS_LOCATION"] == "Y" && intval($arProperties["INPUT_FIELD_LOCATION"]) > 0 && isset($_REQUEST["ORDER_PROP_" . $arProperties["ID"]])) {
$rsLocationsList = CSaleLocation::GetList(array(), array("ID" => $curVal), false, false, array("ID", "CITY_ID"));
$arCity = $rsLocationsList->GetNext();
if (intval($arCity["CITY_ID"]) <= 0) {
unset($arDeleteFieldLocation[$arProperties["ID"]]);
} else {
$arDeleteFieldLocation[$arProperties["ID"]] = $arProperties["INPUT_FIELD_LOCATION"];
}
} elseif ($arProperties["IS_LOCATION"] == "Y" && intval($arProperties["INPUT_FIELD_LOCATION"]) > 0) {
$arDeleteFieldLocation[$arProperties["ID"]] = $arProperties["INPUT_FIELD_LOCATION"];
}
$arProperties["SIZE1"] = intval($arProperties["SIZE1"]) > 0 ? $arProperties["SIZE1"] : 1;
$dbVariants = CSaleLocation::GetList(array("SORT" => "ASC", "COUNTRY_NAME_LANG" => "ASC", "CITY_NAME_LANG" => "ASC"), array("LID" => LANGUAGE_ID), false, false, array("ID", "COUNTRY_NAME", "CITY_NAME", "SORT", "COUNTRY_NAME_LANG", "CITY_NAME_LANG"));
while ($arVariants = $dbVariants->GetNext()) {
if (intval($arVariants["ID"]) == intval($curVal) || !isset($curVal) && intval($arVariants["ID"]) == intval($arProperties["DEFAULT_VALUE"]) || strlen($curLocation) > 0 && ToUpper($curLocation) == ToUpper($arVariants["CITY_NAME"])) {
$arVariants["SELECTED"] = "Y";
$arProperties["VALUE_FORMATED"] = $arVariants["COUNTRY_NAME"] . (strlen($arVariants["CITY_NAME"]) > 0 ? " - " : "") . $arVariants["CITY_NAME"];
$arProperties["VALUE"] = $arVariants["ID"];
if ($arProperties["IS_LOCATION"] == "Y") {
$arUserResult["DELIVERY_LOCATION"] = $arProperties["VALUE"];
}
if ($arProperties["IS_LOCATION4TAX"] == "Y") {
$arUserResult["TAX_LOCATION"] = $arProperties["VALUE"];
}
}
$arVariants["NAME"] = $arVariants["COUNTRY_NAME"] . (strlen($arVariants["CITY_NAME"]) > 0 ? " - " : "") . $arVariants["CITY_NAME"];
$arProperties["VARIANTS"][] = $arVariants;
}
if (count($arProperties["VARIANTS"]) == 1) {
$arProperties["VALUE"] = $arProperties["VARIANTS"][0]["ID"];
if ($arProperties["IS_LOCATION"] == "Y") {
$arUserResult["DELIVERY_LOCATION"] = $arProperties["VALUE"];
}
if ($arProperties["IS_LOCATION4TAX"] == "Y") {
$arUserResult["TAX_LOCATION"] = $arProperties["VALUE"];
}
}
} elseif ($arProperties["TYPE"] == "RADIO") {
$dbVariants = CSaleOrderPropsVariant::GetList(array("SORT" => "ASC"), array("ORDER_PROPS_ID" => $arProperties["ID"]), false, false, array("*"));
while ($arVariants = $dbVariants->GetNext()) {
if ($arVariants["VALUE"] == $curVal || !isset($curVal) && $arVariants["VALUE"] == $arProperties["DEFAULT_VALUE"]) {
$arVariants["CHECKED"] = "Y";
$arProperties["VALUE_FORMATED"] = $arVariants["NAME"];
}
$arProperties["VARIANTS"][] = $arVariants;
}
} elseif ($arProperties["TYPE"] == "FILE") {
$arProperties["SIZE1"] = intval($arProperties["SIZE1"]);
$arProperties["VALUE"] = isset($curVal) ? CSaleHelper::getFileInfo($curVal) : $arProperties["DEFAULT_VALUE"];
}
return $arProperties;
}
array(
"PERSON_TYPE_ID" => $arUserProps["PERSON_TYPE_ID"],
"PROPS_GROUP_ID" => $arOrderPropsGroup["ID"],
"USER_PROPS" => "Y", "ACTIVE" => "Y", "UTIL" => "N"
),
false,
false,
array("ID", "PERSON_TYPE_ID", "NAME", "TYPE", "REQUIED", "DEFAULT_VALUE", "SORT", "USER_PROPS", "IS_LOCATION", "PROPS_GROUP_ID", "SIZE1", "SIZE2", "DESCRIPTION", "IS_EMAIL", "IS_PROFILE_NAME", "IS_PAYER", "IS_LOCATION4TAX", "CODE", "SORT")
);
while($arOrderProps = $dbOrderProps->GetNext())
{
if ($arOrderProps["REQUIED"]=="Y" || $arOrderProps["IS_EMAIL"]=="Y" || $arOrderProps["IS_PROFILE_NAME"]=="Y" || $arOrderProps["IS_LOCATION"]=="Y" || $arOrderProps["IS_PAYER"]=="Y")
$arOrderProps["REQUIED"] = "Y";
if (in_array($arOrderProps["TYPE"], Array("SELECT", "MULTISELECT", "RADIO")))
{
$dbVars = CSaleOrderPropsVariant::GetList(($by="SORT"), ($order="ASC"), Array("ORDER_PROPS_ID"=>$arOrderProps["ID"]));
while ($vars = $dbVars->GetNext())
$arOrderProps["VALUES"][] = $vars;
}
elseif($arOrderProps["TYPE"]=="LOCATION")
{
$propsOfTypeLocation[$arOrderProps['ID']] = true; // required for mapping ID<=>CODE below
if(CSaleLocation::isLocationProMigrated())
{
$arOrderProps["VALUES"] = array();
if(strlen($arOrderProps["DEFAULT_VALUE"]))
$arOrderProps["DEFAULT_VALUE"] = CSaleLocation::getLocationIDbyCODE($arOrderProps["DEFAULT_VALUE"]);
}
else
{
function getOrderPropertiesHTML($arOrderProps, $arPropValues = array(), $LID, $USER_ID = '', $ORDER_ID = 0, $formVarsSubmit = false)
{
$propertyGroupID = -1;
$arDisableFieldForLocation = array();
$resultHtml = "<table id=\"order_related_props\">";
// get order properties values
if ($formVarsSubmit)
{
$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_"))))
{
if (!is_array($value))
$arPropValues[intval(substr($key, strlen("ORDER_PROP_")))] = htmlspecialcharsbx($value);
else
{
$arValues = array();
foreach ($value as $k => $v)
$arValues[$key] = htmlspecialcharsbx($v);
$arPropValues[intval(substr($key, strlen("ORDER_PROP_")))] = $arValues;
}
}
}
}
}
// iterate over list of properties
if (is_array($arOrderProps))
{
foreach ($arOrderProps 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\"";
}
//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.">\n";
if(($arProperties["TYPE"] == "MULTISELECT" || $arProperties["TYPE"] == "TEXTAREA") || ($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 .= '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();
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" => "",
"PUBLIC" => "N",
),
array(
"ID" => "",
"CODE" => $curVal,
"PROVIDE_LINK_BY" => "code",
)
);
$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"
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"]]) && !is_array($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 .= "</table>";
return $resultHtml;
}
function GetRealValue($propertyID, $propertyCode, $propertyType, $value, $lang = false)
{
$propertyID = IntVal($propertyID);
$propertyCode = Trim($propertyCode);
$propertyType = Trim($propertyType);
if ($lang === false) {
$lang = LANGUAGE_ID;
}
$arResult = array();
$curKey = strlen($propertyCode) > 0 ? $propertyCode : $propertyID;
if ($propertyType == "SELECT" || $propertyType == "RADIO") {
$arValue = CSaleOrderPropsVariant::GetByValue($propertyID, $value);
$arResult[$curKey] = $arValue["NAME"];
} elseif ($propertyType == "MULTISELECT") {
$curValue = "";
if (!is_array($value)) {
$value = explode(",", $value);
}
for ($i = 0, $max = count($value); $i < $max; $i++) {
if ($arValue1 = CSaleOrderPropsVariant::GetByValue($propertyID, $value[$i])) {
if ($i > 0) {
$curValue .= ",";
}
$curValue .= $arValue1["NAME"];
}
}
$arResult[$curKey] = $curValue;
} elseif ($propertyType == "LOCATION") {
if (CSaleLocation::isLocationProMigrated()) {
$curValue = '';
if (strlen($value)) {
$arValue = array();
if (intval($value)) {
try {
$locationStreetPropertyValue = '';
$res = \Bitrix\Sale\Location\LocationTable::getPathToNode($value, 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') {
$arResult[$curKey . "_STREET"] = $item['LNAME'];
}
if ($types['ID2CODE'][$item['TYPE_ID']] == 'COUNTRY') {
$arValue["COUNTRY_NAME"] = $item['LNAME'];
}
if ($types['ID2CODE'][$item['TYPE_ID']] == 'REGION') {
$arValue["REGION_NAME"] = $item['LNAME'];
}
if ($types['ID2CODE'][$item['TYPE_ID']] == 'CITY') {
$arValue["CITY_NAME"] = $item['LNAME'];
}
if ($types['ID2CODE'][$item['TYPE_ID']] == 'VILLAGE') {
$arResult[$curKey . "_VILLAGE"] = $item['LNAME'];
}
$path[] = $item['LNAME'];
}
$curValue = implode(' - ', $path);
} catch (\Bitrix\Main\SystemException $e) {
}
}
}
} else {
$arValue = CSaleLocation::GetByID($value, $lang);
$curValue = $arValue["COUNTRY_NAME"] . (strlen($arValue["COUNTRY_NAME"]) <= 0 || strlen($arValue["REGION_NAME"]) <= 0 ? "" : " - ") . $arValue["REGION_NAME"] . (strlen($arValue["COUNTRY_NAME"]) <= 0 || strlen($arValue["CITY_NAME"]) <= 0 ? "" : " - ") . $arValue["CITY_NAME"];
}
$arResult[$curKey] = $curValue;
$arResult[$curKey . "_COUNTRY"] = $arValue["COUNTRY_NAME"];
$arResult[$curKey . "_REGION"] = $arValue["REGION_NAME"];
$arResult[$curKey . "_CITY"] = $arValue["CITY_NAME"];
} else {
$arResult[$curKey] = $value;
}
return $arResult;
}
$curVal = $arResult["POST"]["ORDER_PROP_" . $arProperties["ID"]];
if ($arProperties["TYPE"] == "CHECKBOX") {
if ($curVal == "Y") {
$arProperties["VALUE_FORMATED"] = GetMessage("SALE_YES");
} else {
$arProperties["VALUE_FORMATED"] = GetMessage("SALE_NO");
}
} elseif ($arProperties["TYPE"] == "TEXT" || $arProperties["TYPE"] == "TEXTAREA") {
$arProperties["VALUE_FORMATED"] = $curVal;
} elseif ($arProperties["TYPE"] == "SELECT" || $arProperties["TYPE"] == "RADIO") {
$arVal = CSaleOrderPropsVariant::GetByValue($arProperties["ID"], $curVal);
$arProperties["VALUE_FORMATED"] = htmlspecialcharsEx($arVal["NAME"]);
} elseif ($arProperties["TYPE"] == "MULTISELECT") {
$countCurVal = count($curVal);
for ($i = 0; $i < $countCurVal; $i++) {
$arVal = CSaleOrderPropsVariant::GetByValue($arProperties["ID"], $curVal[$i]);
if ($i > 0) {
$arProperties["VALUE_FORMATED"] .= ", ";
}
$arProperties["VALUE_FORMATED"] .= htmlspecialcharsEx($arVal["NAME"]);
}
} elseif ($arProperties["TYPE"] == "LOCATION") {
$arVal = CSaleLocation::GetByID($curVal, LANGUAGE_ID);
/*
$arProperties["VALUE_FORMATED"] = htmlspecialcharsEx($arVal["COUNTRY_NAME"]);
if (strlen($arVal["COUNTRY_NAME"]) > 0 && strlen($arVal["CITY_NAME"]) > 0)
$arProperties["VALUE_FORMATED"] .= " - ";
$arProperties["VALUE_FORMATED"] .= htmlspecialcharsEx($arVal["CITY_NAME"]);
*/
$locationName = "";
$locationName .= strlen($arVal["COUNTRY_NAME"]) <= 0 ? "" : $arVal["COUNTRY_NAME"];
unset($row['ID']);
if (!CSaleOrderPropsVariant::Update($variantId, $row)) {
$errors[] = Loc::getMessage('ERROR_EDIT_VARIANT') . " {$index}";
}
} else {
$row['ORDER_PROPS_ID'] = $propertyId;
if ($variantId = CSaleOrderPropsVariant::Add($row)) {
$variants[$key]['ID'] = $variantId;
} else {
$errors[] = Loc::getMessage('ERROR_ADD_VARIANT') . " {$index}";
}
}
}
}
} elseif ($existentProperty && $existentProperty['TYPE'] == 'ENUM') {
CSaleOrderPropsVariant::DeleteAll($propertyId);
}
// save property relations
foreach ($relationsSettings as $name => $input) {
CSaleOrderProps::UpdateOrderPropsRelations($propertyId, $relations[$name], $name);
}
}
if ($_POST['save'] && !$errors) {
LocalRedirect("sale_order_props.php?lang=" . LANG . GetFilterParams("filter_", false));
}
if ($_POST['apply'] && !$errors) {
LocalRedirect("sale_order_props_edit.php?lang=" . LANG . "&ID=" . $propertyId . GetFilterParams("filter_", false));
}
}
}
// RENDER VIEW /////////////////////////////////////////////////////////////////////////////////////////////////////////
/**
* @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);
}
function Add($arFields)
{
global $DB;
if (!CSaleOrderPropsVariant::CheckFields("ADD", $arFields)) {
return false;
}
$arInsert = $DB->PrepareInsert("b_sale_order_props_variant", $arFields);
$strSql = "INSERT INTO b_sale_order_props_variant(" . $arInsert[0] . ") " . "VALUES(" . $arInsert[1] . ")";
$DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
$ID = IntVal($DB->LastID());
return $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 . "\">\n\t\t\t<td class=\"adm-detail-content-cell-l\" width=\"40%\">" . GetMessage("NEWO_BUYER") . ":</td>\n\t\t\t<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\">\n\t\t<td class=\"adm-detail-content-cell-l\" width=\"40%\">" . GetMessage("SOE_PERSON_TYPE") . ":</td>\n\t\t<td class=\"adm-detail-content-cell-r\" width=\"60%\">" . $personTypeSelect . "</td>\n\t</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\">\n\t\t<td class=\"adm-detail-content-cell-l\">" . GetMessage("NEWO_BUYER_PROFILE") . ":</td>\n\t\t<td class=\"adm-detail-content-cell-r\">\n\t\t\t<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>\n\t</tr>";
if ($ORDER_ID <= 0) {
$arCountProps = fGetCountProfileProps($PERSON_TYPE_ID);
$resultHtml .= "<tr id=\"btnBuyerNewField\">";
if (count($arCountProps) < 3) {
$resultHtml .= "<td colspan=2>\n\t\t\t\t\t<table width=\"100%\" class=\"edit-table\" >";
if (IntVal($arCountProps["IS_EMAIL"]) <= 0) {
$resultHtml .= "<tr class=\"adm-detail-required-field\">\n\t\t\t\t\t\t\t<td class=\"adm-detail-content-cell-l\" width=\"40%\">" . GetMessage("NEWO_BUYER_REG_MAIL") . "</td>\n\t\t\t\t\t\t\t<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>\n\t\t\t\t\t\t</tr>";
}
if (IntVal($arCountProps["IS_PAYER"]) <= 0) {
$resultHtml .= "<tr class=\"adm-detail-required-field\">\n\t\t\t\t\t\t\t<td class=\"adm-detail-content-cell-l\">" . GetMessage("NEWO_BUYER_REG_LASTNAME") . "</td>\n\t\t\t\t\t\t\t<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>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class=\"adm-detail-required-field\">\n\t\t\t\t\t\t\t<td class=\"adm-detail-content-cell-l\">" . GetMessage("NEWO_BUYER_REG_NAME") . "</td>\n\t\t\t\t\t\t\t<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>\n\t\t\t\t\t\t</tr>";
}
$resultHtml .= "</table>\n\t\t\t\t</td>";
}
$resultHtml .= "</tr>";
}
$arPropValues = array();
if ($formVarsSubmit) {
$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_")))) {
$arPropValues[IntVal(substr($key, strlen("ORDER_PROP_")))] = htmlspecialcharsbx($value);
}
}
}
$userComment = $_POST["USER_DESCRIPTION"];
} elseif ($ORDER_ID == "" and $USER_ID != "") {
//profile
$userProfile = array();
$userProfile = CSaleOrderUserProps::DoLoadProfiles($USER_ID, $PERSON_TYPE_ID);
$arPropValues = $userProfile[$PERSON_TYPE_ID]["VALUES"];
} elseif ($ORDER_ID != "") {
$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()) {
$arPropValues[IntVal($arPropValuesList["ORDER_PROPS_ID"])] = htmlspecialcharsbx($arPropValuesList["VALUE"]);
}
}
//select field (town) for disable
$arDisableFieldForLocation = array();
$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" && in_array($arOrderProps["INPUT_FIELD_LOCATION"], $arDisableFieldForLocation)) {
$arLocation = CSaleLocation::GetByID($arPropValues[$arOrderProps["ORDER_PROPS_ID"]]);
if (IntVal($arLocation["CITY_ID"]) <= 0) {
unset($arDisableFieldForLocation[$arOrderProps["INPUT_FIELD_LOCATION"]]);
}
}
}
$dbProperties = CSaleOrderProps::GetList(array("GROUP_SORT" => "ASC", "PROPS_GROUP_ID" => "ASC", "SORT" => "ASC", "NAME" => "ASC"), array("PERSON_TYPE_ID" => $PERSON_TYPE_ID, "ACTIVE" => "Y"), false, false, array("*"));
$propertyGroupID = -1;
while ($arProperties = $dbProperties->Fetch()) {
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\"";
}
//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 . ">\n";
}
if ($arProperties["TYPE"] == "MULTISELECT" || $arProperties["TYPE"] == "TEXTAREA" || $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 .= htmlspecialcharsEx($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='" . GetMessage('NEWO_BREAK_LAST_NAME') . "';BX.addClass(this.parentNode,'newo_break_active');}\" onfocus=\"if (this.value=='" . 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='" . GetMessage('NEWO_BREAK_NAME') . "';BX.addClass(this.parentNode,'newo_break_active');}\" onfocus=\"if (this.value=='" . 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='" . GetMessage('NEWO_BREAK_SECOND_NAME') . "';BX.addClass(this.parentNode,'newo_break_active');}\" onfocus=\"if (this.value=='" . 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 .= 'id="ORDER_PROP_' . $arProperties["ID"] . '" ' . $change . '>';
if ($arProperties["IS_PAYER"] == "Y" && IntVal($USER_ID) <= 0) {
$resultHtml .= '</div>';
}
} elseif ($arProperties["TYPE"] == "SELECT") {
$resultHtml .= '<select name="ORDER_PROP_' . $arProperties["ID"] . '" ';
$resultHtml .= 'id="ORDER_PROP_' . $arProperties["ID"] . '" ';
$resultHtml .= 'size="5" ';
$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") {
$resultHtml .= '<select multiple name="ORDER_PROP_' . $arProperties["ID"] . '[]" ';
$resultHtml .= 'id="ORDER_PROP_' . $arProperties["ID"] . '" ';
$resultHtml .= 'size="5" ';
$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();
$tmpLocation = $GLOBALS["APPLICATION"]->IncludeComponent('bitrix:sale.ajax.locations', '', 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" => "fRecalProduct('', '', 'N');", "PUBLIC" => "N"), null, array('HIDE_ICONS' => 'Y'));
$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"
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>';
}
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") . ":\n\t\t\t</td>\n\t\t\t<td class=\"adm-detail-content-cell-r\">\n\t\t\t\t<textarea name=\"USER_DESCRIPTION\" rows=\"4\" cols=\"40\">" . htmlspecialcharsbx($userComment) . "</textarea>\n\t\t\t</td>\n\t\t</tr>";
$resultHtml .= "</table>";
return $resultHtml;
}
?>
</option><?php
}
?>
</select>
<?php
} elseif ($value["TYPE"] == "RADIO") {
?>
<input type="radio" name="filter_prop_<?php
echo $key;
?>
" value=""><?php
echo GetMessage("SALE_F_ALL");
?>
<br /><?php
$db_vars = CSaleOrderPropsVariant::GetList($by = "SORT", $order = "ASC", array("ORDER_PROPS_ID" => $value["ID"]));
while ($vars = $db_vars->Fetch()) {
?>
<input type="radio" name="filter_prop_<?php
echo $key;
?>
" value="<?php
echo $vars["VALUE"];
?>
"<?php
if ($vars["VALUE"] == $curVal) {
echo " checked";
}
?>
><?php
echo htmlspecialcharsbx($vars["NAME"]);
function getOrderPropFormated($arProperties, $arResult, &$arUserResult, &$arDeleteFieldLocation = array())
{
global $USER;
$isProfileChanged = ($arUserResult["PROFILE_CHANGE"] == "Y");
$isEmptyUserResult = (empty($arUserResult["ORDER_PROP"]));
$curVal = $arUserResult["ORDER_PROP"][$arProperties["ID"]];
$curLocation = false;
static $propertyGroupID = 0;
static $propertyUSER_PROPS = "";
// take data from user profile
if ($arUserResult["PROFILE_CHANGE"] == "Y"
&& intval($arUserResult["PROFILE_ID"]) > 0
&& !($arResult["HAVE_PREPAYMENT"]
&& $arUserResult["PROFILE_DEFAULT"] == "Y"
&& !empty($arResult["PREPAY_ORDER_PROPS"][$arProperties["CODE"]])))
{
$dbUserPropsValues = CSaleOrderUserPropsValue::GetList(
array("SORT" => "ASC"),
array(
"USER_PROPS_ID" => $arUserResult["PROFILE_ID"],
"ORDER_PROPS_ID" => $arProperties["ID"],
"USER_ID" => intval($USER->GetID()),
),
false,
false,
array("VALUE", "PROP_TYPE", "VARIANT_NAME", "SORT", "ORDER_PROPS_ID")
);
if ($arUserPropsValues = $dbUserPropsValues->Fetch())
{
$valueTmp = "";
if ($arUserPropsValues["PROP_TYPE"] == "MULTISELECT")
{
$arUserPropsValues["VALUE"] = explode(",", $arUserPropsValues["VALUE"]);
}
$curVal = $arUserPropsValues["VALUE"];
}
}
elseif($arUserResult["PROFILE_CHANGE"] == "Y" && intval($arUserResult["PROFILE_ID"]) <= 0)
{
if (isset($curVal))
unset($curVal);
}
elseif(isset($arUserResult["ORDER_PROP"][$arProperties["ID"]]))
$curVal = $arUserResult["ORDER_PROP"][$arProperties["ID"]];
elseif($arResult["HAVE_PREPAYMENT"] && !empty($arResult["PREPAY_ORDER_PROPS"][$arProperties["CODE"]]))
{
$curVal = $arResult["PREPAY_ORDER_PROPS"][$arProperties["CODE"]];
if($arProperties["TYPE"] == "LOCATION")
$curLocation = $curVal;
}
if (intval($_REQUEST["NEW_LOCATION_".$arProperties["ID"]]) > 0)
$curVal = intval($_REQUEST["NEW_LOCATION_".$arProperties["ID"]]);
$arProperties["FIELD_NAME"] = "ORDER_PROP_".$arProperties["ID"];
if(strlen($arProperties["CODE"]) > 0)
$arProperties["FIELD_ID"] = "ORDER_PROP_".$arProperties["CODE"];
else
$arProperties["FIELD_ID"] = "ORDER_PROP_".$arProperties["ID"];
if (intval($arProperties["PROPS_GROUP_ID"]) != $propertyGroupID || $propertyUSER_PROPS != $arProperties["USER_PROPS"])
$arProperties["SHOW_GROUP_NAME"] = "Y";
$propertyGroupID = $arProperties["PROPS_GROUP_ID"];
$propertyUSER_PROPS = $arProperties["USER_PROPS"];
if ($arProperties["REQUIED"]=="Y" || $arProperties["IS_EMAIL"]=="Y" || $arProperties["IS_PROFILE_NAME"]=="Y" || $arProperties["IS_LOCATION"]=="Y" || $arProperties["IS_LOCATION4TAX"]=="Y" || $arProperties["IS_PAYER"]=="Y" || $arProperties["IS_ZIP"]=="Y")
$arProperties["REQUIED_FORMATED"]="Y";
if ($arProperties["TYPE"] == "CHECKBOX")
{
if ($curVal=="Y" || !isset($curVal) && $arProperties["DEFAULT_VALUE"]=="Y")
{
$arProperties["CHECKED"] = "Y";
$arProperties["VALUE_FORMATED"] = GetMessage("SOA_Y");
}
else
$arProperties["VALUE_FORMATED"] = GetMessage("SOA_N");
$arProperties["SIZE1"] = ((intval($arProperties["SIZE1"]) > 0) ? $arProperties["SIZE1"] : 30);
if ($isProfileChanged || $isEmptyUserResult)
{
$arUserResult["ORDER_PROP"][$arProperties["ID"]] = (isset($arProperties["CHECKED"]) && $arProperties["CHECKED"] == "Y" ? 'Y' : "N");
}
}
elseif ($arProperties["TYPE"] == "TEXT")
{
if (strlen($curVal) <= 0)
{
if(strlen($arProperties["DEFAULT_VALUE"])>0 && !isset($curVal))
$arProperties["VALUE"] = $arProperties["DEFAULT_VALUE"];
elseif ($arProperties["IS_EMAIL"] == "Y")
$arProperties["VALUE"] = $USER->GetEmail();
elseif ($arProperties["IS_PAYER"] == "Y")
{
//$arProperties["VALUE"] = $USER->GetFullName();
$rsUser = CUser::GetByID($USER->GetID());
$fio = "";
if ($arUser = $rsUser->Fetch())
{
$fio = CUser::FormatName(CSite::GetNameFormat(false), array("NAME" => $arUser["NAME"], "LAST_NAME" => $arUser["LAST_NAME"], "SECOND_NAME" => $arUser["SECOND_NAME"]), false, false);
}
$arProperties["VALUE"] = $fio;
}
$arProperties["SOURCE"] = 'DEFAULT';
}
else
{
$arProperties["VALUE"] = $curVal;
$arProperties["SOURCE"] = 'FORM';
}
//select ZIP for LOCATION
if ($arProperties["IS_ZIP"] == "Y" && $arUserResult["PROFILE_CHANGE"] == "N")
{
$dbPropertiesLoc = CSaleOrderProps::GetList(
array("ID" => "DESC"),
array(
"PERSON_TYPE_ID" => $arUserResult["PERSON_TYPE_ID"],
"ACTIVE" => "Y",
"UTIL" => "N",
"IS_LOCATION" => "Y"
),
false,
false,
array("ID")
);
$arPropertiesLoc = $dbPropertiesLoc->Fetch();
if ($arPropertiesLoc["ID"] > 0)
{
$arZipLocation = array();
if(strlen($curVal) > 0)
$arZipLocation = CSaleLocation::GetByZIP($curVal);
$rsZipList = CSaleLocation::GetLocationZIP($arUserResult["ORDER_PROP"][$arPropertiesLoc["ID"]]);
if($arZip = $rsZipList->Fetch())
{
if (strlen($arZip["ZIP"]) > 0 && (empty($arZipLocation) || $arZipLocation["ID"] != $arUserResult["ORDER_PROP"][$arPropertiesLoc["ID"]]))
$arProperties["VALUE"] = $arZip["ZIP"];
}
}
}
if ($arProperties["IS_ZIP"]=="Y")
$arUserResult["DELIVERY_LOCATION_ZIP"] = $arProperties["VALUE"];
$arProperties["VALUE"] = htmlspecialcharsEx($arProperties["VALUE"]);
$arProperties["VALUE_FORMATED"] = $arProperties["VALUE"];
if ($isProfileChanged || $isEmptyUserResult)
{
$arUserResult["ORDER_PROP"][$arProperties["ID"]] = $arProperties["VALUE"];
}
}
elseif ($arProperties["TYPE"] == "SELECT")
{
$arProperties["SIZE1"] = ((intval($arProperties["SIZE1"]) > 0) ? $arProperties["SIZE1"] : 1);
$dbVariants = CSaleOrderPropsVariant::GetList(
array("SORT" => "ASC", "NAME" => "ASC"),
array("ORDER_PROPS_ID" => $arProperties["ID"]),
false,
false,
array("*")
);
$flagDefault = "N";
$nameProperty = "";
while ($arVariants = $dbVariants->GetNext())
{
if ($flagDefault == "N" && $nameProperty == "")
{
$nameProperty = $arVariants["NAME"];
}
if (($arVariants["VALUE"] == $curVal) || ((!isset($curVal) || $curVal == "") && ($arVariants["VALUE"] == $arProperties["DEFAULT_VALUE"])))
{
$arVariants["SELECTED"] = "Y";
$arProperties["VALUE_FORMATED"] = $arVariants["NAME"];
$flagDefault = "Y";
if ($isProfileChanged || $isEmptyUserResult)
{
$arUserResult["ORDER_PROP"][$arProperties["ID"]] = $arVariants["NAME"];
}
}
$arProperties["VARIANTS"][] = $arVariants;
}
if ($flagDefault == "N")
{
$arProperties["VARIANTS"][0]["SELECTED"]= "Y";
$arProperties["VARIANTS"][0]["VALUE_FORMATED"] = $nameProperty;
if ($isProfileChanged || $isEmptyUserResult)
{
$arUserResult["ORDER_PROP"][$arProperties["ID"]] = $nameProperty;
}
}
}
elseif ($arProperties["TYPE"] == "MULTISELECT")
{
$setValue = array();
$arProperties["FIELD_NAME"] = "ORDER_PROP_".$arProperties["ID"].'[]';
$arProperties["SIZE1"] = ((intval($arProperties["SIZE1"]) > 0) ? $arProperties["SIZE1"] : 5);
$arDefVal = explode(",", $arProperties["DEFAULT_VALUE"]);
$countDefVal = count($arDefVal);
for ($i = 0; $i < $countDefVal; $i++)
$arDefVal[$i] = Trim($arDefVal[$i]);
$dbVariants = CSaleOrderPropsVariant::GetList(
array("SORT" => "ASC"),
array("ORDER_PROPS_ID" => $arProperties["ID"]),
false,
false,
array("*")
);
$i = 0;
while ($arVariants = $dbVariants->GetNext())
{
if ((is_array($curVal) && in_array($arVariants["VALUE"], $curVal)) || (!isset($curVal) && in_array($arVariants["VALUE"], $arDefVal)))
{
$arVariants["SELECTED"] = "Y";
if ($i > 0)
$arProperties["VALUE_FORMATED"] .= ", ";
$arProperties["VALUE_FORMATED"] .= $arVariants["NAME"];
$setValue[] = $arVariants["VALUE"];
$i++;
}
$arProperties["VARIANTS"][] = $arVariants;
}
if ($isProfileChanged || $isEmptyUserResult)
{
$arUserResult["ORDER_PROP"][$arProperties["ID"]] = $setValue;
}
}
elseif ($arProperties["TYPE"] == "TEXTAREA")
{
$arProperties["SIZE2"] = ((intval($arProperties["SIZE2"]) > 0) ? $arProperties["SIZE2"] : 4);
$arProperties["SIZE1"] = ((intval($arProperties["SIZE1"]) > 0) ? $arProperties["SIZE1"] : 40);
$arProperties["VALUE"] = htmlspecialcharsEx(isset($curVal) ? $curVal : $arProperties["DEFAULT_VALUE"]);
$arProperties["VALUE_FORMATED"] = $arProperties["VALUE"];
if ($isProfileChanged || $isEmptyUserResult)
{
$arUserResult["ORDER_PROP"][$arProperties["ID"]] = $arProperties["VALUE"];
}
}
elseif ($arProperties["TYPE"] == "LOCATION")
{
if(CSaleLocation::isLocationProEnabled())
{
$arProperties["VALUE"] = $curVal;
// variants
$locationFound = false;
$dbVariants = CSaleLocation::GetList(
array("SORT" => "ASC", "COUNTRY_NAME_LANG" => "ASC", "CITY_NAME_LANG" => "ASC"),
array("LID" => LANGUAGE_ID),
false,
false,
array("ID", "COUNTRY_NAME", "CITY_NAME", "SORT", "COUNTRY_NAME_LANG", "CITY_NAME_LANG", "CITY_ID")
);
while ($arVariants = $dbVariants->GetNext())
{
if (intval($arVariants["ID"]) == intval($curVal) || (!isset($curVal) && intval($arVariants["ID"]) == intval($arProperties["DEFAULT_VALUE"])) || (strlen($curLocation) > 0 && ToUpper($curLocation) == ToUpper($arVariants["CITY_NAME"])))
{
// set formatted value
$arProperties["VALUE_FORMATED"] = $arVariants["COUNTRY_NAME"].((strlen($arVariants["CITY_NAME"]) > 0) ? " - " : "").$arVariants["CITY_NAME"];
// location found, set it as DELIVERY_LOCATION and TAX_LOCATION
$arUserResult["DELIVERY_LOCATION"] = $arVariants['ID'];
if($arProperties["IS_LOCATION4TAX"]=="Y")
$arUserResult["TAX_LOCATION"] = $arVariants['ID'];
$locationFound = $arVariants;
$arVariants["SELECTED"] = "Y";
if ($isProfileChanged || $isEmptyUserResult)
{
$arUserResult["ORDER_PROP"][$arProperties["ID"]] = $arVariants['ID'];
}
}
$arVariants["NAME"] = $arVariants["COUNTRY_NAME"].((strlen($arVariants["CITY_NAME"]) > 0) ? " - " : "").$arVariants["CITY_NAME"];
// save to variants
$arProperties["VARIANTS"][] = $arVariants;
}
// this is not a COUNTRY, REGION or CITY, but must appear in $arProperties["VARIANTS"]
if(!$locationFound && IntVal($curVal))
{
$item = CSaleLocation::GetById($curVal);
if($item)
{
// set formatted value
$arProperties["VALUE_FORMATED"] = $item["COUNTRY_NAME"].((strlen($item["CITY_NAME"]) > 0) ? " - " : "").$item["CITY_NAME"];
// location found, set it as DELIVERY_LOCATION and TAX_LOCATION
$arUserResult["DELIVERY_LOCATION"] = $arProperties["VALUE"];
if($arProperties["IS_LOCATION4TAX"]=="Y")
$arUserResult["TAX_LOCATION"] = $arProperties["VALUE"];
if ($isProfileChanged || $isEmptyUserResult)
{
$arUserResult["ORDER_PROP"][$arProperties["ID"]] = $arProperties["VALUE"];
}
$locationFound = $item;
$item['SELECTED'] = 'Y';
$item['NAME'] = $item["COUNTRY_NAME"].((strlen($item["CITY_NAME"]) > 0) ? " - " : "").$item["CITY_NAME"];
// save to variants
$arProperties["VARIANTS"][] = $item;
}
}
if($locationFound)
{
// enable location town text
if(isset($arResult['LOCATION_ALT_PROP_DISPLAY_MANUAL'])) // its an ajax-hit and sale.location.selector.steps is used
{
if(intval($arResult['LOCATION_ALT_PROP_DISPLAY_MANUAL'][$arProperties["ID"]])) // user MANUALLY selected "Other location" in the selector
{
// Manually chosen, decide...
//if(intval($locationFound['CITY_ID'])) // we are already selected CITY, no town property needed
// $arDeleteFieldLocation[$arProperties["ID"]] = $arProperties["INPUT_FIELD_LOCATION"];
//else // somewhere above
unset($arDeleteFieldLocation[$arProperties["ID"]]);
}
else
{
$arDeleteFieldLocation[$arProperties["ID"]] = $arProperties["INPUT_FIELD_LOCATION"];
}
}
else
{
// first load, dont know what to do. default: hide
$arDeleteFieldLocation[$arProperties["ID"]] = $arProperties["INPUT_FIELD_LOCATION"];
}
}
else
{
$arDeleteFieldLocation[$arProperties["ID"]] = $arProperties["INPUT_FIELD_LOCATION"];
}
}
else
{
//enable location town text
if ($_REQUEST["is_ajax_post"] == "Y" && $arProperties["IS_LOCATION"] == "Y" && intval($arProperties["INPUT_FIELD_LOCATION"]) > 0 && isset($_REQUEST["ORDER_PROP_".$arProperties["ID"]]))
{
$rsLocationsList = CSaleLocation::GetList(
array(),
array("ID" => $curVal),
false,
false,
array("ID", "CITY_ID")
);
$arCity = $rsLocationsList->GetNext();
if (intval($arCity["CITY_ID"]) <= 0)
unset($arDeleteFieldLocation[$arProperties["ID"]]);
else
$arDeleteFieldLocation[$arProperties["ID"]] = $arProperties["INPUT_FIELD_LOCATION"];
}
elseif ($arProperties["IS_LOCATION"] == "Y" && intval($arProperties["INPUT_FIELD_LOCATION"]) > 0)
{
$arDeleteFieldLocation[$arProperties["ID"]] = $arProperties["INPUT_FIELD_LOCATION"];
}
$arProperties["SIZE1"] = ((intval($arProperties["SIZE1"]) > 0) ? $arProperties["SIZE1"] : 1);
$dbVariants = CSaleLocation::GetList(
array("SORT" => "ASC", "COUNTRY_NAME_LANG" => "ASC", "CITY_NAME_LANG" => "ASC"),
array("LID" => LANGUAGE_ID),
false,
false,
array("ID", "COUNTRY_NAME", "CITY_NAME", "SORT", "COUNTRY_NAME_LANG", "CITY_NAME_LANG")
);
while ($arVariants = $dbVariants->GetNext())
{
if (intval($arVariants["ID"]) == intval($curVal) || (!isset($curVal) && intval($arVariants["ID"]) == intval($arProperties["DEFAULT_VALUE"])) || (strlen($curLocation) > 0 && ToUpper($curLocation) == ToUpper($arVariants["CITY_NAME"])))
{
$arVariants["SELECTED"] = "Y";
$arProperties["VALUE_FORMATED"] = $arVariants["COUNTRY_NAME"].((strlen($arVariants["CITY_NAME"]) > 0) ? " - " : "").$arVariants["CITY_NAME"];
$arProperties["VALUE"] = $arVariants["ID"];
if ($arProperties["IS_LOCATION"]=="Y")
$arUserResult["DELIVERY_LOCATION"] = $arProperties["VALUE"];
if ($arProperties["IS_LOCATION4TAX"]=="Y")
$arUserResult["TAX_LOCATION"] = $arProperties["VALUE"];
if ($isProfileChanged || $isEmptyUserResult)
{
$arUserResult["ORDER_PROP"][$arProperties["ID"]] = $arProperties["VALUE"];
}
}
$arVariants["NAME"] = $arVariants["COUNTRY_NAME"].((strlen($arVariants["CITY_NAME"]) > 0) ? " - " : "").$arVariants["CITY_NAME"];
$arProperties["VARIANTS"][] = $arVariants;
}
if(count($arProperties["VARIANTS"]) == 1)
{
$arProperties["VALUE"] = $arProperties["VARIANTS"][0]["ID"];
if($arProperties["IS_LOCATION"]=="Y")
$arUserResult["DELIVERY_LOCATION"] = $arProperties["VALUE"];
if($arProperties["IS_LOCATION4TAX"]=="Y")
$arUserResult["TAX_LOCATION"] = $arProperties["VALUE"];
}
}
}
elseif ($arProperties["TYPE"] == "RADIO")
{
$dbVariants = CSaleOrderPropsVariant::GetList(
array("SORT" => "ASC"),
array("ORDER_PROPS_ID" => $arProperties["ID"]),
false,
false,
array("*")
);
while ($arVariants = $dbVariants->GetNext())
{
if ($arVariants["VALUE"] == $curVal || (!isset($curVal) && $arVariants["VALUE"] == $arProperties["DEFAULT_VALUE"]))
{
$arVariants["CHECKED"]="Y";
$arProperties["VALUE_FORMATED"] = $arVariants["NAME"];
if ($isProfileChanged || $isEmptyUserResult)
{
$arUserResult["ORDER_PROP"][$arProperties["ID"]] = $arVariants["VALUE"];
}
}
$arProperties["VARIANTS"][] = $arVariants;
}
}
elseif ($arProperties["TYPE"] == "FILE")
{
$arProperties["SIZE1"] = intval($arProperties["SIZE1"]);
$arProperties["VALUE"] = isset($curVal) ? CSaleHelper::getFileInfo($curVal) : $arProperties["DEFAULT_VALUE"];
if ($isProfileChanged || $isEmptyUserResult)
{
$arUserResult["ORDER_PROP"][$arProperties["ID"]] = $arProperties["VALUE"];
}
}
return $arProperties;
}
echo '<a href="mailto:'.htmlspecialcharsbx($arOrderProps["VALUE"]).'">'.htmlspecialcharsEx($arOrderProps["VALUE"]).'</a>';
else
echo nl2br(htmlspecialcharsbx(trim($arOrderProps["VALUE"])));
}
elseif ($arOrderProps["TYPE"] == "SELECT" || $arOrderProps["TYPE"] == "RADIO")
{
$arVal = CSaleOrderPropsVariant::GetByValue($arOrderProps["ORDER_PROPS_ID"], $arOrderProps["VALUE"]);
echo htmlspecialcharsEx($arVal["NAME"]);
}
elseif ($arOrderProps["TYPE"] == "MULTISELECT")
{
$curVal = explode(",", $arOrderProps["VALUE"]);
$countCurVal = count($curVal);
for ($i = 0; $i < $countCurVal; $i++)
{
$arVal = CSaleOrderPropsVariant::GetByValue($arOrderProps["ORDER_PROPS_ID"], $curVal[$i]);
if ($i > 0)
echo ", ";
echo htmlspecialcharsEx($arVal["NAME"]);
}
}
elseif ($arOrderProps["TYPE"] == "LOCATION")
{
$arOrder["LOCATION_TO"] = $arOrderProps["VALUE"];
if(CSaleLocation::isLocationProEnabled())
{
$locationString = Location\Admin\LocationHelper::getLocationStringByCode($arOrderProps['VALUE']);
if(!strlen($locationString))
$locationString = $arOrderProps['VALUE'];
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;
}
// this is not a COUNTRY, REGION or CITY, but must appear in $arProperties["VARIANTS"]
if (CSaleLocation::isLocationProMigrated() && !$locationFound && IntVal($curVal)) {
// CSaleLocation::GetById() is enought intelligent to accept modern (not-country-or-region-or-city) ID or CODE
$item = CSaleLocation::GetById($curVal);
if ($item) {
$item['NAME'] = $item["COUNTRY_NAME"] . (strlen($item["CITY_NAME"]) > 0 ? " - " : "") . $item["CITY_NAME"];
$item['SELECTED'] = 'Y';
$arProperties["VARIANTS"][] = $item;
}
}
if (count($arProperties["VARIANTS"]) == 1) {
$arProperties["VALUE"] = $arProperties["VARIANTS"][0]["ID"];
}
} elseif ($arProperties["TYPE"] == "RADIO") {
$arProperties["VARIANTS"] = array();
$dbVariants = CSaleOrderPropsVariant::GetList(array("SORT" => "ASC"), array("ORDER_PROPS_ID" => $arProperties["ID"]), false, false, array("*"));
while ($arVariants = $dbVariants->GetNext()) {
if ($arVariants["VALUE"] == $curVal || !isset($curVal) && $arVariants["VALUE"] == $arProperties["DEFAULT_VALUE"]) {
$arVariants["CHECKED"] = "Y";
$arProperties["VALUE_FORMATED"] = $arVariants["NAME"];
}
$arProperties["VARIANTS"][] = $arVariants;
}
}
if ($arProperties["TYPE"] == "CHECKBOX" && strlen($curVal) <= 0 && $arProperties["REQUIED"] != "Y") {
$curVal = "N";
}
if (!empty($curVal) && is_array($curVal) || !is_array($curVal) && (string) $curVal != "") {
$arPropValues[$arProperties["ID"]] = $curVal;
}
if ($arProperties["USER_PROPS"] == "Y") {
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;
}
/**
* Function gets order properties from database
* @param mixed[] $cached Cached data taken from obtainDataCachedStructure()
* @return void
*/
protected function obtainProps(&$cached)
{
if (empty($this->dbResult["ID"])) {
return;
}
$props = array();
$dbOrderProps = CSaleOrderPropsValue::GetOrderProps($this->dbResult["ID"]);
$iGroup = -1;
while ($arOrderProps = $dbOrderProps->GetNext()) {
if (empty($this->arParams["PROP_" . $this->dbResult["PERSON_TYPE_ID"]]) || !in_array($arOrderProps["ORDER_PROPS_ID"], $this->arParams["PROP_" . $this->dbResult["PERSON_TYPE_ID"]])) {
if ($arOrderProps["ACTIVE"] == "Y" && $arOrderProps["UTIL"] == "N") {
$arOrderPropsTmp = $arOrderProps;
if ($iGroup != intval($arOrderProps["PROPS_GROUP_ID"])) {
$arOrderPropsTmp["SHOW_GROUP_NAME"] = "Y";
$iGroup = intval($arOrderProps["PROPS_GROUP_ID"]);
}
if ($arOrderProps["TYPE"] == "SELECT" || $arOrderProps["TYPE"] == "RADIO") {
$arVal = CSaleOrderPropsVariant::GetByValue($arOrderProps["ORDER_PROPS_ID"], $arOrderProps["VALUE"]);
$arOrderPropsTmp["VALUE"] = htmlspecialcharsEx($arVal["NAME"]);
} elseif ($arOrderProps["TYPE"] == "MULTISELECT") {
$arOrderPropsTmp["VALUE"] = "";
$curVal = explode(",", $arOrderProps["VALUE"]);
for ($i = 0, $intCount = count($curVal); $i < $intCount; $i++) {
$arVal = CSaleOrderPropsVariant::GetByValue($arOrderProps["ORDER_PROPS_ID"], $curVal[$i]);
if ($i > 0) {
$arOrderPropsTmp["VALUE"] .= ", ";
}
$arOrderPropsTmp["VALUE"] .= htmlspecialcharsEx($arVal["NAME"]);
}
} elseif ($arOrderProps["TYPE"] == "LOCATION") {
$locationName = "";
if (CSaleLocation::isLocationProMigrated()) {
$locationName = Location\Admin\LocationHelper::getLocationStringById($arOrderProps["VALUE"]);
} else {
$arVal = CSaleLocation::GetByID($arOrderProps["VALUE"], LANGUAGE_ID);
$locationName .= !strlen($arVal["COUNTRY_NAME"]) ? "" : $arVal["COUNTRY_NAME"];
if (strlen($arVal["COUNTRY_NAME"]) && strlen($arVal["REGION_NAME"])) {
$locationName .= " - " . $arVal["REGION_NAME"];
} elseif (strlen($arVal["REGION_NAME"])) {
$locationName .= $arVal["REGION_NAME"];
}
if (strlen($arVal["COUNTRY_NAME"]) || strlen($arVal["REGION_NAME"])) {
$locationName .= " - " . $arVal["CITY_NAME"];
} elseif (strlen($arVal["CITY_NAME"])) {
$locationName .= $arVal["CITY_NAME"];
}
}
$arOrderPropsTmp["VALUE"] = $locationName;
} elseif ($arOrderProps["TYPE"] == "FILE") {
if (strpos($arOrderProps["VALUE"], ",") !== false) {
$fileValue = "";
$values = explode(",", $arOrderProps["VALUE"]);
if (self::isNonemptyArray($values)) {
foreach ($values as $fileId) {
$fileValue .= CFile::ShowFile(trim($fileId), 0, 90, 90, true) . "<br/>";
}
}
$arOrderPropsTmp["VALUE"] = $fileValue;
} else {
$arOrderPropsTmp["VALUE"] = CFile::ShowFile($arOrderProps["VALUE"], 0, 90, 90, true);
}
}
$props[] = $arOrderPropsTmp;
}
}
}
$cached["ORDER_PROPS"] = $props;
}
function getOrderPropFormated($arProperties, $arResult, &$arUserResult, &$arDeleteFieldLocation = array())
{
global $USER;
$curVal = $arUserResult["ORDER_PROP"][$arProperties["ID"]];
$curLocation = false;
static $propertyGroupID = 0;
static $propertyUSER_PROPS = "";
// take data from user profile
if ($arUserResult["PROFILE_CHANGE"] == "Y"
&& intval($arUserResult["PROFILE_ID"]) > 0
&& !($arResult["HAVE_PREPAYMENT"]
&& $arUserResult["PROFILE_DEFAULT"] == "Y"
&& !empty($arResult["PREPAY_ORDER_PROPS"][$arProperties["CODE"]])))
{
$dbUserPropsValues = CSaleOrderUserPropsValue::GetList(
array("SORT" => "ASC"),
array(
"USER_PROPS_ID" => $arUserResult["PROFILE_ID"],
"ORDER_PROPS_ID" => $arProperties["ID"],
"USER_ID" => intval($USER->GetID()),
),
false,
false,
array("VALUE", "PROP_TYPE", "VARIANT_NAME", "SORT", "ORDER_PROPS_ID")
);
if ($arUserPropsValues = $dbUserPropsValues->Fetch())
{
$valueTmp = "";
if ($arUserPropsValues["PROP_TYPE"] == "MULTISELECT")
{
$arUserPropsValues["VALUE"] = explode(",", $arUserPropsValues["VALUE"]);
}
$curVal = $arUserPropsValues["VALUE"];
if(CSaleLocation::isLocationProMigrated())
{
if($arProperties['TYPE'] == 'LOCATION')
$curVal = CSaleLocation::getLocationIDbyCODE($curVal);
}
}
}
elseif($arUserResult["PROFILE_CHANGE"] == "Y" && intval($arUserResult["PROFILE_ID"]) <= 0)
{
if (isset($curVal))
unset($curVal);
}
elseif(isset($arUserResult["ORDER_PROP"][$arProperties["ID"]]))
$curVal = $arUserResult["ORDER_PROP"][$arProperties["ID"]];
elseif($arResult["HAVE_PREPAYMENT"] && !empty($arResult["PREPAY_ORDER_PROPS"][$arProperties["CODE"]]))
{
$curVal = $arResult["PREPAY_ORDER_PROPS"][$arProperties["CODE"]];
if($arProperties["TYPE"] == "LOCATION")
$curLocation = $curVal;
}
if (intval($_REQUEST["NEW_LOCATION_".$arProperties["ID"]]) > 0)
$curVal = intval($_REQUEST["NEW_LOCATION_".$arProperties["ID"]]);
$arProperties["FIELD_NAME"] = "ORDER_PROP_".$arProperties["ID"];
if(strlen($arProperties["CODE"]) > 0)
$arProperties["FIELD_ID"] = "ORDER_PROP_".$arProperties["CODE"];
else
$arProperties["FIELD_ID"] = "ORDER_PROP_".$arProperties["ID"];
if (intval($arProperties["PROPS_GROUP_ID"]) != $propertyGroupID || $propertyUSER_PROPS != $arProperties["USER_PROPS"])
$arProperties["SHOW_GROUP_NAME"] = "Y";
$propertyGroupID = $arProperties["PROPS_GROUP_ID"];
$propertyUSER_PROPS = $arProperties["USER_PROPS"];
if ($arProperties["REQUIED"]=="Y" || $arProperties["IS_EMAIL"]=="Y" || $arProperties["IS_PROFILE_NAME"]=="Y" || $arProperties["IS_LOCATION"]=="Y" || $arProperties["IS_LOCATION4TAX"]=="Y" || $arProperties["IS_PAYER"]=="Y" || $arProperties["IS_ZIP"]=="Y")
$arProperties["REQUIED_FORMATED"]="Y";
if ($arProperties["TYPE"] == "CHECKBOX")
{
if ($curVal=="Y" || !isset($curVal) && $arProperties["DEFAULT_VALUE"]=="Y")
{
$arProperties["CHECKED"] = "Y";
$arProperties["VALUE_FORMATED"] = GetMessage("SOA_Y");
}
else
$arProperties["VALUE_FORMATED"] = GetMessage("SOA_N");
$arProperties["SIZE1"] = ((intval($arProperties["SIZE1"]) > 0) ? $arProperties["SIZE1"] : 30);
}
elseif ($arProperties["TYPE"] == "TEXT")
{
if (strlen($curVal) <= 0)
{
if(strlen($arProperties["DEFAULT_VALUE"])>0 && !isset($curVal))
$arProperties["VALUE"] = $arProperties["DEFAULT_VALUE"];
elseif ($arProperties["IS_EMAIL"] == "Y")
$arProperties["VALUE"] = $USER->GetEmail();
elseif ($arProperties["IS_PAYER"] == "Y")
{
//$arProperties["VALUE"] = $USER->GetFullName();
$rsUser = CUser::GetByID($USER->GetID());
$fio = "";
if ($arUser = $rsUser->Fetch())
{
$fio = CUser::FormatName(CSite::GetNameFormat(false), array("NAME" => $arUser["NAME"], "LAST_NAME" => $arUser["LAST_NAME"], "SECOND_NAME" => $arUser["SECOND_NAME"]), false, false);
}
$arProperties["VALUE"] = $fio;
}
$arProperties["SOURCE"] = 'DEFAULT';
}
else
{
$arProperties["VALUE"] = $curVal;
$arProperties["SOURCE"] = 'FORM';
}
//select ZIP for LOCATION
if ($arProperties["IS_ZIP"] == "Y" && $arUserResult["PROFILE_CHANGE"] == "N")
{
$dbPropertiesLoc = CSaleOrderProps::GetList(
array("ID" => "DESC"),
array(
"PERSON_TYPE_ID" => $arUserResult["PERSON_TYPE_ID"],
"ACTIVE" => "Y",
"UTIL" => "N",
"IS_LOCATION" => "Y"
),
false,
false,
array("ID")
);
$arPropertiesLoc = $dbPropertiesLoc->Fetch();
if ($arPropertiesLoc["ID"] > 0)
{
$arZipLocation = array();
if(strlen($curVal) > 0)
$arZipLocation = CSaleLocation::GetByZIP($curVal);
$rsZipList = CSaleLocation::GetLocationZIP($arUserResult["ORDER_PROP"][$arPropertiesLoc["ID"]]);
if($arZip = $rsZipList->Fetch())
{
if (strlen($arZip["ZIP"]) > 0 && (empty($arZipLocation) || $arZipLocation["ID"] != $arUserResult["ORDER_PROP"][$arPropertiesLoc["ID"]]))
$arProperties["VALUE"] = $arZip["ZIP"];
}
}
}
if ($arProperties["IS_ZIP"]=="Y")
$arUserResult["DELIVERY_LOCATION_ZIP"] = $arProperties["VALUE"];
$arProperties["VALUE"] = htmlspecialcharsEx($arProperties["VALUE"]);
$arProperties["VALUE_FORMATED"] = $arProperties["VALUE"];
}
elseif ($arProperties["TYPE"] == "SELECT")
{
$arProperties["SIZE1"] = ((intval($arProperties["SIZE1"]) > 0) ? $arProperties["SIZE1"] : 1);
$dbVariants = CSaleOrderPropsVariant::GetList(
array("SORT" => "ASC", "NAME" => "ASC"),
array("ORDER_PROPS_ID" => $arProperties["ID"]),
false,
false,
array("*")
);
$flagDefault = "N";
$nameProperty = "";
while ($arVariants = $dbVariants->GetNext())
{
if ($flagDefault == "N" && $nameProperty == "")
{
$nameProperty = $arVariants["NAME"];
}
if (($arVariants["VALUE"] == $curVal) || ((!isset($curVal) || $curVal == "") && ($arVariants["VALUE"] == $arProperties["DEFAULT_VALUE"])))
{
$arVariants["SELECTED"] = "Y";
$arProperties["VALUE_FORMATED"] = $arVariants["NAME"];
$flagDefault = "Y";
}
$arProperties["VARIANTS"][] = $arVariants;
}
if ($flagDefault == "N")
{
$arProperties["VARIANTS"][0]["SELECTED"]= "Y";
$arProperties["VARIANTS"][0]["VALUE_FORMATED"] = $nameProperty;
}
}
elseif ($arProperties["TYPE"] == "MULTISELECT")
{
$arProperties["FIELD_NAME"] = "ORDER_PROP_".$arProperties["ID"].'[]';
$arProperties["SIZE1"] = ((intval($arProperties["SIZE1"]) > 0) ? $arProperties["SIZE1"] : 5);
$arDefVal = explode(",", $arProperties["DEFAULT_VALUE"]);
$countDefVal = count($arDefVal);
for ($i = 0; $i < $countDefVal; $i++)
$arDefVal[$i] = Trim($arDefVal[$i]);
$dbVariants = CSaleOrderPropsVariant::GetList(
array("SORT" => "ASC"),
array("ORDER_PROPS_ID" => $arProperties["ID"]),
false,
false,
array("*")
);
$i = 0;
while ($arVariants = $dbVariants->GetNext())
{
if ((is_array($curVal) && in_array($arVariants["VALUE"], $curVal)) || (!isset($curVal) && in_array($arVariants["VALUE"], $arDefVal)))
{
$arVariants["SELECTED"] = "Y";
if ($i > 0)
$arProperties["VALUE_FORMATED"] .= ", ";
$arProperties["VALUE_FORMATED"] .= $arVariants["NAME"];
$i++;
}
$arProperties["VARIANTS"][] = $arVariants;
}
}
elseif ($arProperties["TYPE"] == "TEXTAREA")
{
$arProperties["SIZE2"] = ((intval($arProperties["SIZE2"]) > 0) ? $arProperties["SIZE2"] : 4);
$arProperties["SIZE1"] = ((intval($arProperties["SIZE1"]) > 0) ? $arProperties["SIZE1"] : 40);
$arProperties["VALUE"] = htmlspecialcharsEx(isset($curVal) ? $curVal : $arProperties["DEFAULT_VALUE"]);
$arProperties["VALUE_FORMATED"] = $arProperties["VALUE"];
}
elseif ($arProperties["TYPE"] == "LOCATION")
{
if(CSaleLocation::isLocationProEnabled())
{
if(!strlen($curVal) && strlen($arProperties["DEFAULT_VALUE"]))
$curVal = CSaleLocation::getLocationIDbyCODE($arProperties["DEFAULT_VALUE"]);
//enable location town text
if ($_REQUEST["is_ajax_post"] == "Y" && $arProperties["IS_LOCATION"] == "Y" && intval($arProperties["INPUT_FIELD_LOCATION"]) > 0 && isset($_REQUEST["ORDER_PROP_".$arProperties["ID"]]))
{
if(isset($arResult['LOCATION_ALT_PROP_DISPLAY_MANUAL'][$arProperties["ID"]])) // look at the manual flag
{
if($arResult['LOCATION_ALT_PROP_DISPLAY_MANUAL'][$arProperties["ID"]]) // if it set to TRUE, show alt location
unset($arDeleteFieldLocation[$arProperties["ID"]]);
else
$arDeleteFieldLocation[$arProperties["ID"]] = $arProperties["INPUT_FIELD_LOCATION"]; // otherwise, hide
}
else
{
// now we have no had-coded type-table for locations, so turn this logic on only when there is "CITY" type
if(!CSaleLocation::checkLocationIsAboveCity($curVal))
{
$arDeleteFieldLocation[$arProperties["ID"]] = $arProperties["INPUT_FIELD_LOCATION"]; // remove by default
}
else
{
unset($arDeleteFieldLocation[$arProperties["ID"]]);
}
}
}
elseif ($arProperties["IS_LOCATION"] == "Y" && intval($arProperties["INPUT_FIELD_LOCATION"]) > 0)
{
$arDeleteFieldLocation[$arProperties["ID"]] = $arProperties["INPUT_FIELD_LOCATION"];
}
$arProperties["VALUE"] = $curVal;
#######################
#######################
#######################
# here we sacrifice perfromance for the sake of compatibility
$arUserResult["DELIVERY_LOCATION"] = $arProperties["VALUE"];
if($arProperties["IS_LOCATION4TAX"]=="Y")
$arUserResult["TAX_LOCATION"] = $arProperties["VALUE"];
// variants
$locationFound = false;
$dbVariants = CSaleLocation::GetList(
array("SORT" => "ASC", "COUNTRY_NAME_LANG" => "ASC", "CITY_NAME_LANG" => "ASC"),
array("LID" => LANGUAGE_ID),
false,
false,
array("ID", "COUNTRY_NAME", "CITY_NAME", "SORT", "COUNTRY_NAME_LANG", "CITY_NAME_LANG")
);
while ($arVariants = $dbVariants->GetNext())
{
if (intval($arVariants["ID"]) == intval($curVal) || (!isset($curVal) && intval($arVariants["ID"]) == intval($arProperties["DEFAULT_VALUE"])) || (strlen($curLocation) > 0 && ToUpper($curLocation) == ToUpper($arVariants["CITY_NAME"])))
{
$locationFound = true;
$arVariants["SELECTED"] = "Y";
$arProperties["VALUE_FORMATED"] = $arVariants["COUNTRY_NAME"].((strlen($arVariants["CITY_NAME"]) > 0) ? " - " : "").$arVariants["CITY_NAME"];
}
$arVariants["NAME"] = $arVariants["COUNTRY_NAME"].((strlen($arVariants["CITY_NAME"]) > 0) ? " - " : "").$arVariants["CITY_NAME"];
$arProperties["VARIANTS"][] = $arVariants;
}
// this is not a COUNTRY, REGION or CITY, but must appear in $arProperties["VARIANTS"]
if(!$locationFound && IntVal($curVal))
{
$item = CSaleLocation::GetById($curVal);
if($item)
{
$item['NAME'] = $arVariants["COUNTRY_NAME"].((strlen($arVariants["CITY_NAME"]) > 0) ? " - " : "").$arVariants["CITY_NAME"];
$item['SELECTED'] = 'Y';
$arProperties["VARIANTS"][] = $item;
}
}
}
else
{
//enable location town text
if ($_REQUEST["is_ajax_post"] == "Y" && $arProperties["IS_LOCATION"] == "Y" && intval($arProperties["INPUT_FIELD_LOCATION"]) > 0 && isset($_REQUEST["ORDER_PROP_".$arProperties["ID"]]))
{
$rsLocationsList = CSaleLocation::GetList(
array(),
array("ID" => $curVal),
false,
false,
array("ID", "CITY_ID")
);
$arCity = $rsLocationsList->GetNext();
if (intval($arCity["CITY_ID"]) <= 0)
unset($arDeleteFieldLocation[$arProperties["ID"]]);
else
$arDeleteFieldLocation[$arProperties["ID"]] = $arProperties["INPUT_FIELD_LOCATION"];
}
elseif ($arProperties["IS_LOCATION"] == "Y" && intval($arProperties["INPUT_FIELD_LOCATION"]) > 0)
{
$arDeleteFieldLocation[$arProperties["ID"]] = $arProperties["INPUT_FIELD_LOCATION"];
}
$arProperties["SIZE1"] = ((intval($arProperties["SIZE1"]) > 0) ? $arProperties["SIZE1"] : 1);
$dbVariants = CSaleLocation::GetList(
array("SORT" => "ASC", "COUNTRY_NAME_LANG" => "ASC", "CITY_NAME_LANG" => "ASC"),
array("LID" => LANGUAGE_ID),
false,
false,
array("ID", "COUNTRY_NAME", "CITY_NAME", "SORT", "COUNTRY_NAME_LANG", "CITY_NAME_LANG")
);
while ($arVariants = $dbVariants->GetNext())
{
if (intval($arVariants["ID"]) == intval($curVal) || (!isset($curVal) && intval($arVariants["ID"]) == intval($arProperties["DEFAULT_VALUE"])) || (strlen($curLocation) > 0 && ToUpper($curLocation) == ToUpper($arVariants["CITY_NAME"])))
{
$arVariants["SELECTED"] = "Y";
$arProperties["VALUE_FORMATED"] = $arVariants["COUNTRY_NAME"].((strlen($arVariants["CITY_NAME"]) > 0) ? " - " : "").$arVariants["CITY_NAME"];
$arProperties["VALUE"] = $arVariants["ID"];
if ($arProperties["IS_LOCATION"]=="Y")
$arUserResult["DELIVERY_LOCATION"] = $arProperties["VALUE"];
if ($arProperties["IS_LOCATION4TAX"]=="Y")
$arUserResult["TAX_LOCATION"] = $arProperties["VALUE"];
}
$arVariants["NAME"] = $arVariants["COUNTRY_NAME"].((strlen($arVariants["CITY_NAME"]) > 0) ? " - " : "").$arVariants["CITY_NAME"];
$arProperties["VARIANTS"][] = $arVariants;
}
if(count($arProperties["VARIANTS"]) == 1)
{
$arProperties["VALUE"] = $arProperties["VARIANTS"][0]["ID"];
if($arProperties["IS_LOCATION"]=="Y")
$arUserResult["DELIVERY_LOCATION"] = $arProperties["VALUE"];
if($arProperties["IS_LOCATION4TAX"]=="Y")
$arUserResult["TAX_LOCATION"] = $arProperties["VALUE"];
}
}
}
elseif ($arProperties["TYPE"] == "RADIO")
{
$dbVariants = CSaleOrderPropsVariant::GetList(
array("SORT" => "ASC"),
array("ORDER_PROPS_ID" => $arProperties["ID"]),
false,
false,
array("*")
);
while ($arVariants = $dbVariants->GetNext())
{
if ($arVariants["VALUE"] == $curVal || (!isset($curVal) && $arVariants["VALUE"] == $arProperties["DEFAULT_VALUE"]))
{
$arVariants["CHECKED"]="Y";
$arProperties["VALUE_FORMATED"] = $arVariants["NAME"];
}
$arProperties["VARIANTS"][] = $arVariants;
}
}
elseif ($arProperties["TYPE"] == "FILE")
{
$arProperties["SIZE1"] = intval($arProperties["SIZE1"]);
$arProperties["VALUE"] = isset($curVal) ? CSaleHelper::getFileInfo($curVal) : $arProperties["DEFAULT_VALUE"];
}
return $arProperties;
}
