function Update($ID, $arFields)
{
global $DB;
$ID = IntVal($ID);
if (!CSaleOrderPropsGroup::CheckFields("UPDATE", $arFields, $ID)) {
return false;
}
$strUpdate = $DB->PrepareUpdate("b_sale_order_props_group", $arFields);
$strSql = "UPDATE b_sale_order_props_group SET " . $strUpdate . " WHERE ID = " . $ID . "";
$DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
return $ID;
}
/**
* <p>Функция добавляет новую группу свойств заказа. Группа используется только для группировки свойств. </p>
*
*
*
*
* @param array $arFields Ассоциативный массив параметров группы свойств, в котором
* ключами являются названия параметров, а значениями - их
* значения.<br> Допустимые ключи:<ul> <li> <b>PERSON_TYPE_ID</b> - тип
* плательщика;</li> <li> <b>NAME</b> - название группы (группа привязывается
* к типу плательщика, тип плательщика привязывается к сайту, сайт
* привязывается к языку, название задается на этом языке);</li> <li>
* <b>SORT</b> - индекс сортировки.</li> </ul>
*
*
*
* @return int <p>Возвращается код добавленной группы или <i>false</i> в случае
* ошибки.</p> <br><br>
*
* @static
* @link http://dev.1c-bitrix.ru/api_help/sale/classes/csaleorderpropsgroup/csaleorderpropsgroup__add.017e008c.php
* @author Bitrix
*/
public static function Add($arFields)
{
global $DB;
if (!CSaleOrderPropsGroup::CheckFields("ADD", $arFields)) {
return false;
}
$arInsert = $DB->PrepareInsert("b_sale_order_props_group", $arFields);
$strSql = "INSERT INTO b_sale_order_props_group(" . $arInsert[0] . ") " . "VALUES(" . $arInsert[1] . ")";
$DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
$ID = IntVal($DB->LastID());
return $ID;
}
}
}
$arResult["ERROR_MESSAGE"] = $errorMessage;
$arResult["TITLE"] = str_replace("#ID#", $arUserProps["ID"], GetMessage("SPPD_PROFILE_NO"));
$arResult["PERSON_TYPE"] = CSalePersonType::GetByID($arUserProps["PERSON_TYPE_ID"]);
$arResult["PERSON_TYPE"]["NAME"] = htmlspecialcharsEx($arResult["PERSON_TYPE"]["NAME"]);
// get prop description
$arrayTmp = Array();
$propsOfTypeLocation = array();
$dbOrderPropsGroup = CSaleOrderPropsGroup::GetList(
array("SORT" => "ASC", "NAME" => "ASC"),
array("PERSON_TYPE_ID" => $arUserProps["PERSON_TYPE_ID"]),
false,
false,
array("ID", "PERSON_TYPE_ID", "NAME", "SORT")
);
while ($arOrderPropsGroup = $dbOrderPropsGroup->GetNext())
{
$arrayTmp[$arOrderPropsGroup["ID"]] = $arOrderPropsGroup;
$dbOrderProps = CSaleOrderProps::GetList(
array("SORT" => "ASC", "NAME" => "ASC"),
array(
"PERSON_TYPE_ID" => $arUserProps["PERSON_TYPE_ID"],
"PROPS_GROUP_ID" => $arOrderPropsGroup["ID"],
"USER_PROPS" => "Y", "ACTIVE" => "Y", "UTIL" => "N"
),
false,
false,
if($shopLocalization == "ua")
{
if ($fizUaExist)
{
$dbSaleOrderPropsGroup = CSaleOrderPropsGroup::GetList(Array(), Array("PERSON_TYPE_ID" => $arGeneralInfo["personType"]["fiz_ua"], "NAME" => GetMessage("SALE_WIZARD_PROP_GROUP_FIZ1")), false, false, array("ID"));
if ($arSaleOrderPropsGroup = $dbSaleOrderPropsGroup->GetNext())
$arGeneralInfo["propGroup"]["user_fiz_ua"] = $arSaleOrderPropsGroup["ID"];
$dbSaleOrderPropsGroup = CSaleOrderPropsGroup::GetList(Array(),Array("PERSON_TYPE_ID" => $arGeneralInfo["personType"]["fiz_ua"], "NAME" => GetMessage("SALE_WIZARD_PROP_GROUP_FIZ2")), false, false, array("ID"));
if ($arSaleOrderPropsGroup = $dbSaleOrderPropsGroup->GetNext())
$arGeneralInfo["propGroup"]["adres_fiz_ua"] = $arSaleOrderPropsGroup["ID"];
}
elseif ($personType["fiz_ua"] == "Y")
{
$arGeneralInfo["propGroup"]["user_fiz_ua"] = CSaleOrderPropsGroup::Add(Array("PERSON_TYPE_ID" => $arGeneralInfo["personType"]["fiz_ua"], "NAME" => GetMessage("SALE_WIZARD_PROP_GROUP_FIZ1"), "SORT" => 100));
$arGeneralInfo["propGroup"]["adres_fiz_ua"] = CSaleOrderPropsGroup::Add(Array("PERSON_TYPE_ID" => $arGeneralInfo["personType"]["fiz_ua"], "NAME" => GetMessage("SALE_WIZARD_PROP_GROUP_FIZ2"), "SORT" => 200));
}
}
$arProps = Array();
if($personType["fiz"] == "Y")
{
$arProps[] = Array(
"PERSON_TYPE_ID" => $arGeneralInfo["personType"]["fiz"],
"NAME" => GetMessage("SALE_WIZARD_PROP_6"),
"TYPE" => "TEXT",
"REQUIED" => "Y",
"DEFAULT_VALUE" => "",
"SORT" => 100,
"USER_PROPS" => "Y",
"IS_LOCATION" => "N",
"PROPS_GROUP_ID" => $arGeneralInfo["propGroup"]["user_fiz"],
if ($str_USER_PROPS == "Y") {
echo "checked";
}
?>
>
</td>
</tr>
<tr>
<td width="40%"><?php
echo GetMessage("F_PROPS_GROUP_ID");
?>
:</td>
<td width="60%">
<select name="PROPS_GROUP_ID">
<?php
$l = CSaleOrderPropsGroup::GetList($b = "NAME", $o = "ASC", array("PERSON_TYPE_ID" => $PERSON_TYPE_ID));
while ($l->ExtractFields("l_")) {
?>
<option value="<?php
echo $l_ID;
?>
"<?php
if (IntVal($str_PROPS_GROUP_ID) == IntVal($l_ID)) {
echo " selected";
}
?>
>[<?php
echo $l_ID;
?>
] <?php
echo $l_NAME;
</select>
</td>
</tr>
<tr>
<td><?php
echo GetMessage("SALE_F_GROUP");
?>
:</td>
<td>
<select name="filter_group">
<option value="">(<?php
echo GetMessage("SALE_ALL");
?>
)</option>
<?php
$l = CSaleOrderPropsGroup::GetList(array("PERSON_TYPE_ID" => "ASC", "SORT" => "ASC", "NAME" => "ASC"));
while ($arL = $l->Fetch()) {
?>
<option value="<?php
echo $arL["ID"];
?>
"<?php
if (IntVal($filter_group) == IntVal($arL["ID"])) {
echo " selected";
}
?>
>[<?php
echo $arL["ID"];
?>
] <?php
echo htmlspecialcharsbx($arL["NAME"]);
@set_time_limit(0);
$DB->StartTransaction();
if (!CSaleOrderPropsGroup::Delete($ID)) {
$DB->Rollback();
if ($ex = $APPLICATION->GetException()) {
$lAdmin->AddGroupError($ex->GetString(), $ID);
} else {
$lAdmin->AddGroupError(GetMessage("SOPGAN_DELETE_ERROR"), $ID);
}
}
$DB->Commit();
break;
}
}
}
$dbResultList = CSaleOrderPropsGroup::GetList(array($by => $order), $arFilter);
$dbResultList = new CAdminResult($dbResultList, $sTableID);
$dbResultList->NavStart();
$lAdmin->NavText($dbResultList->GetNavPrint(GetMessage("PERS_TYPE_NAV")));
$lAdmin->AddHeaders(array(array("id" => "ID", "content" => GetMessage("PERS_TYPE_ID"), "sort" => "ID", "default" => true), array("id" => "NAME", "content" => GetMessage("PERS_TYPE_NAME"), "sort" => "NAME", "default" => true), array("id" => "PERSON_TYPE_ID", "content" => GetMessage('PERS_TYPE_TYPE'), "sort" => "PERSON_TYPE_ID", "default" => true), array("id" => "SORT", "content" => GetMessage("PERS_TYPE_SORT"), "sort" => "SORT", "default" => true), array("id" => "PROPS", "content" => GetMessage("SOPGAN_PROPS"), "sort" => "", "default" => true)));
$arPersonTypeList = array();
$dbPersonType = CSalePersonType::GetList(array("SORT" => "ASC", "NAME" => "ASC"), array());
while ($arPersonType = $dbPersonType->Fetch()) {
$arPersonTypeList[$arPersonType["ID"]] = array("ID" => $arPersonType["ID"], "NAME" => htmlspecialcharsEx($arPersonType["NAME"]), "LID" => implode(", ", $arPersonType["LIDS"]));
}
$arVisibleColumns = $lAdmin->GetVisibleHeaderColumns();
while ($arPropsGroup = $dbResultList->NavNext(true, "f_")) {
$editUrl = "sale_order_props_group_edit.php?ID=" . $f_ID . "&lang=" . LANG . GetFilterParams("filter_");
$row =& $lAdmin->AddRow($f_ID, $arPropsGroup, $editUrl, GetMessage("SOPGAN_EDIT_PROMT"));
$row->AddField("ID", "<b><a href='" . $editUrl . "' title='" . GetMessage("SOPGAN_EDIT_PROMT") . "'>" . $f_ID . "</a>");
$row->AddInputField("NAME", array("size" => "30"));
if (!$variants) {
$result = CSaleOrderPropsVariant::GetList($b = 'SORT', $o = 'ASC', array('ORDER_PROPS_ID' => $propertyId));
while ($row = $result->Fetch()) {
$variants[] = $row;
}
}
break;
case 'FILE':
$property['DEFAULT_VALUE'] = Input\File::loadInfo($property['DEFAULT_VALUE']);
break;
}
// variant settings
$variantSettings = array('VALUE' => array('TYPE' => 'STRING', 'LABEL' => Loc::getMessage('SALE_VARIANTS_CODE'), 'SIZE' => '5', 'MAXLENGTH' => 255, 'REQUIRED' => 'Y'), 'NAME' => array('TYPE' => 'STRING', 'LABEL' => Loc::getMessage('SALE_VARIANTS_NAME'), 'SIZE' => '20', 'MAXLENGTH' => 255, 'REQUIRED' => 'Y'), 'SORT' => array('TYPE' => 'NUMBER', 'LABEL' => Loc::getMessage('SALE_VARIANTS_SORT'), 'MIN' => 0, 'STEP' => 1, 'VALUE' => 100), 'DESCRIPTION' => array('TYPE' => 'STRING', 'LABEL' => Loc::getMessage('SALE_VARIANTS_DESCR'), 'SIZE' => '30', 'MAXLENGTH' => 255), 'ID' => array('TYPE' => 'NUMBER', 'MIN' => 0, 'STEP' => 1, 'HIDDEN' => 'Y'));
// common settings
$groupOptions = array();
$result = \CSaleOrderPropsGroup::GetList($b = "NAME", $o = "ASC", array('PERSON_TYPE_ID' => $personTypeId));
while ($row = $result->Fetch()) {
$groupOptions[$row['ID']] = $row['NAME'];
}
$commonSettings = array('PERSON_TYPE_ID' => array('TYPE' => 'NUMBER', 'LABEL' => Loc::getMessage('SALE_PERS_TYPE'), 'MIN' => 0, 'STEP' => 1, 'HIDDEN' => 'Y', 'REQUIRED' => 'Y', 'RLABEL' => "[{$personTypeId}] {$personType['NAME']} ({$personType['LID']})"), 'PROPS_GROUP_ID' => array('TYPE' => 'ENUM', 'LABEL' => Loc::getMessage('F_PROPS_GROUP_ID'), 'OPTIONS' => $groupOptions, 'RLABEL' => ' <a href="sale_order_props_group.php?lang=' . LANG . '" target="_blank">' . Loc::getMessage('SALE_PROPS_GROUP') . '</a>'), 'NAME' => array('TYPE' => 'STRING', 'LABEL' => Loc::getMessage('F_NAME'), 'MAXLENGTH' => 255, 'REQUIRED' => 'Y'), 'CODE' => array('TYPE' => 'STRING', 'LABEL' => Loc::getMessage('F_CODE'), 'MAXLENGTH' => 50), 'ACTIVE' => array('TYPE' => 'Y/N', 'LABEL' => Loc::getMessage('F_ACTIVE'), 'VALUE' => 'Y'), 'UTIL' => array('TYPE' => 'Y/N', 'LABEL' => Loc::getMessage('F_UTIL')), 'USER_PROPS' => array('TYPE' => 'Y/N', 'LABEL' => Loc::getMessage('F_USER_PROPS')), 'IS_FILTERED' => array('TYPE' => 'Y/N', 'LABEL' => Loc::getMessage('F_IS_FILTERED'), 'DESCRIPTION' => Loc::getMessage('MULTIPLE_DESCRIPTION')), 'SORT' => array('TYPE' => 'NUMBER', 'LABEL' => Loc::getMessage('F_SORT'), 'MIN' => 0, 'STEP' => 1, 'VALUE' => 100), 'DESCRIPTION' => array('TYPE' => 'STRING', 'LABEL' => Loc::getMessage('F_DESCRIPTION'), 'MULTILINE' => 'Y', 'ROWS' => 3, 'COLS' => 40));
if ($propertyId > 0) {
$commonSettings = array_merge(array('ID' => array('TYPE' => 'NUMBER', 'LABEL' => 'ID', 'MIN' => 0, 'STEP' => 1, 'HIDDEN' => 'Y', 'RLABEL' => &$propertyId)), $commonSettings);
}
$commonSettings += Input\Manager::getCommonSettings($property, $reload);
$commonSettings['MULTIPLE']['DESCRIPTION'] = Loc::getMessage('MULTIPLE_DESCRIPTION');
unset($commonSettings['VALUE']);
$commonSettings['DEFAULT_VALUE'] = array('REQUIRED' => 'N', 'DESCRIPTION' => null, 'VALUE' => $property['DEFAULT_VALUE'], 'LABEL' => Loc::getMessage('F_DEFAULT_VALUE')) + $property;
if ($property['TYPE'] == 'ENUM') {
$defaultOptions = $property['MULTIPLE'] == 'Y' ? array() : array('' => Loc::getMessage('NO_DEFAULT_VALUE'));
foreach ($variants as $row) {
$defaultOptions[$row['VALUE']] = $row['NAME'];
COption::SetOptionString('sale', '1C_SALE_USE_ZIP', 'Y');
}
COption::SetOptionString('sale', 'weight_unit', GetMessage("SALE_WIZARD_WEIGHT_UNIT"));
COption::SetOptionString('sale', 'WEIGHT_different_set', 'N');
COption::SetOptionString('sale', 'ADDRESS_different_set', 'N');
COption::SetOptionString('sale', 'measurement_path', '/bitrix/modules/sale/measurements.php');
COption::SetOptionString('sale', 'delivery_handles_custom_path', '/bitrix/php_interface/include/sale_delivery/');
COption::SetOptionString('sale', 'location_zip', '101000');
COption::SetOptionString('sale', 'weight_koef', '1');
COption::SetOptionString('sale', 'location', '547');
COption::SetOptionString('sale', 'recalc_product_list', 'Y');
COption::SetOptionString('sale', 'recalc_product_list_period', '7');
//Order Prop Group
$arGeneralInfo["propGroup"]["adres_fiz"] = CSaleOrderPropsGroup::Add(array("PERSON_TYPE_ID" => $arGeneralInfo["personType"]["fiz"], "NAME" => GetMessage("SALE_WIZARD_PROP_GROUP_FIZ1"), "SORT" => 100));
$arGeneralInfo["propGroup"]["compl_fiz"] = CSaleOrderPropsGroup::Add(array("PERSON_TYPE_ID" => $arGeneralInfo["personType"]["fiz"], "NAME" => GetMessage("SALE_WIZARD_PROP_GROUP_FIZ2"), "SORT" => 50));
$arGeneralInfo["propGroup"]["adres_ur"] = CSaleOrderPropsGroup::Add(array("PERSON_TYPE_ID" => $arGeneralInfo["personType"]["ur"], "NAME" => GetMessage("SALE_WIZARD_PROP_GROUP_UR1"), "SORT" => 100));
$arProps = array(array("PERSON_TYPE_ID" => $arGeneralInfo["personType"]["fiz"], "NAME" => GetMessage("SALE_WIZARD_PROP_1"), "TYPE" => "RADIO", "REQUIED" => "Y", "DEFAULT_VALUE" => "F", "SORT" => 100, "USER_PROPS" => "N", "IS_LOCATION" => "N", "PROPS_GROUP_ID" => $arGeneralInfo["propGroup"]["compl_fiz"], "SIZE1" => 0, "SIZE2" => 0, "DESCRIPTION" => "", "IS_EMAIL" => "N", "IS_PROFILE_NAME" => "N", "IS_PAYER" => "N", "IS_LOCATION4TAX" => "N", "CODE" => "", "IS_FILTERED" => "N", "VARIANTS" => array(array("NAME" => GetMessage("SALE_WIZARD_PROP_1_VAL_1"), "VALUE" => "F", "SORT" => 100), array("NAME" => GetMessage("SALE_WIZARD_PROP_1_VAL_2"), "VALUE" => "P", "SORT" => 200))), array("PERSON_TYPE_ID" => $arGeneralInfo["personType"]["fiz"], "NAME" => GetMessage("SALE_WIZARD_PROP_2"), "TYPE" => "LOCATION", "REQUIED" => "Y", "DEFAULT_VALUE" => "", "SORT" => 50, "USER_PROPS" => "Y", "IS_LOCATION" => "Y", "PROPS_GROUP_ID" => $arGeneralInfo["propGroup"]["adres_fiz"], "SIZE1" => 3, "SIZE2" => 0, "DESCRIPTION" => "", "IS_EMAIL" => "N", "IS_PROFILE_NAME" => "N", "IS_PAYER" => "N", "IS_LOCATION4TAX" => "N", "CODE" => "LOCATION", "IS_FILTERED" => "N"), array("PERSON_TYPE_ID" => $arGeneralInfo["personType"]["ur"], "NAME" => GetMessage("SALE_WIZARD_PROP_2"), "TYPE" => "LOCATION", "REQUIED" => "Y", "DEFAULT_VALUE" => "", "SORT" => 1800, "USER_PROPS" => "Y", "IS_LOCATION" => "Y", "PROPS_GROUP_ID" => $arGeneralInfo["propGroup"]["adres_ur"], "SIZE1" => 3, "SIZE2" => 0, "DESCRIPTION" => "", "IS_EMAIL" => "N", "IS_PROFILE_NAME" => "N", "IS_PAYER" => "N", "IS_LOCATION4TAX" => "Y", "CODE" => "F_LOCATION", "IS_FILTERED" => "N"), array("PERSON_TYPE_ID" => $arGeneralInfo["personType"]["fiz"], "NAME" => GetMessage("SALE_WIZARD_PROP_3"), "TYPE" => "TEXT", "REQUIED" => "Y", "DEFAULT_VALUE" => "", "SORT" => 60, "USER_PROPS" => "Y", "IS_LOCATION" => "Y", "PROPS_GROUP_ID" => $arGeneralInfo["propGroup"]["adres_fiz"], "SIZE1" => 1, "SIZE2" => 40, "DESCRIPTION" => GetMessage("SALE_WIZARD_PROP_3_DESCR"), "IS_EMAIL" => "N", "IS_PROFILE_NAME" => "N", "IS_PAYER" => "N", "IS_LOCATION4TAX" => "N", "CODE" => "", "IS_FILTERED" => "N"), array("PERSON_TYPE_ID" => $arGeneralInfo["personType"]["fiz"], "NAME" => GetMessage("SALE_WIZARD_PROP_4"), "TYPE" => "TEXT", "REQUIED" => "Y", "DEFAULT_VALUE" => "", "SORT" => 70, "USER_PROPS" => "Y", "IS_LOCATION" => "N", "PROPS_GROUP_ID" => $arGeneralInfo["propGroup"]["adres_fiz"], "SIZE1" => 8, "SIZE2" => 0, "DESCRIPTION" => "", "IS_EMAIL" => "N", "IS_PROFILE_NAME" => "N", "IS_PAYER" => "N", "IS_LOCATION4TAX" => "N", "CODE" => "INDEX", "IS_FILTERED" => "N"), array("PERSON_TYPE_ID" => $arGeneralInfo["personType"]["fiz"], "NAME" => GetMessage("SALE_WIZARD_PROP_5"), "TYPE" => "TEXTAREA", "REQUIED" => "Y", "DEFAULT_VALUE" => "", "SORT" => 80, "USER_PROPS" => "Y", "IS_LOCATION" => "N", "PROPS_GROUP_ID" => $arGeneralInfo["propGroup"]["adres_fiz"], "SIZE1" => 30, "SIZE2" => 2, "DESCRIPTION" => "", "IS_EMAIL" => "N", "IS_PROFILE_NAME" => "N", "IS_PAYER" => "N", "IS_LOCATION4TAX" => "N", "CODE" => "ADDRESS", "IS_FILTERED" => "N"), array("PERSON_TYPE_ID" => $arGeneralInfo["personType"]["fiz"], "NAME" => "E-Mail", "TYPE" => "TEXT", "REQUIED" => "Y", "DEFAULT_VALUE" => "", "SORT" => 40, "USER_PROPS" => "Y", "IS_LOCATION" => "N", "PROPS_GROUP_ID" => $arGeneralInfo["propGroup"]["adres_fiz"], "SIZE1" => 40, "SIZE2" => 0, "DESCRIPTION" => "", "IS_EMAIL" => "Y", "IS_PROFILE_NAME" => "N", "IS_PAYER" => "N", "IS_LOCATION4TAX" => "N", "CODE" => "EMAIL", "IS_FILTERED" => "N"), array("PERSON_TYPE_ID" => $arGeneralInfo["personType"]["fiz"], "NAME" => GetMessage("SALE_WIZARD_PROP_6"), "TYPE" => "TEXT", "REQUIED" => "Y", "DEFAULT_VALUE" => "", "SORT" => 100, "USER_PROPS" => "Y", "IS_LOCATION" => "N", "PROPS_GROUP_ID" => $arGeneralInfo["propGroup"]["adres_fiz"], "SIZE1" => 40, "SIZE2" => 0, "DESCRIPTION" => "", "IS_EMAIL" => "N", "IS_PROFILE_NAME" => "Y", "IS_PAYER" => "Y", "IS_LOCATION4TAX" => "N", "CODE" => "CONTACT_PERSON", "IS_FILTERED" => "N"), array("PERSON_TYPE_ID" => $arGeneralInfo["personType"]["ur"], "NAME" => GetMessage("SALE_WIZARD_PROP_7"), "TYPE" => "TEXTAREA", "REQUIED" => "Y", "DEFAULT_VALUE" => "", "SORT" => 1100, "USER_PROPS" => "Y", "IS_LOCATION" => "N", "PROPS_GROUP_ID" => $arGeneralInfo["propGroup"]["adres_ur"], "SIZE1" => 40, "SIZE2" => 0, "DESCRIPTION" => "", "IS_EMAIL" => "N", "IS_PROFILE_NAME" => "N", "IS_PAYER" => "N", "IS_LOCATION4TAX" => "N", "CODE" => "F_ADDRESS_FULL", "IS_FILTERED" => "N"), array("PERSON_TYPE_ID" => $arGeneralInfo["personType"]["ur"], "NAME" => "E-Mail", "TYPE" => "TEXT", "REQUIED" => "Y", "DEFAULT_VALUE" => "", "SORT" => 2200, "USER_PROPS" => "Y", "IS_LOCATION" => "N", "PROPS_GROUP_ID" => $arGeneralInfo["propGroup"]["adres_ur"], "SIZE1" => 40, "SIZE2" => 0, "DESCRIPTION" => "", "IS_EMAIL" => "Y", "IS_PROFILE_NAME" => "N", "IS_PAYER" => "N", "IS_LOCATION4TAX" => "N", "CODE" => "F_EMAIL", "IS_FILTERED" => "N"), array("PERSON_TYPE_ID" => $arGeneralInfo["personType"]["ur"], "NAME" => GetMessage("SALE_WIZARD_PROP_8"), "TYPE" => "TEXT", "REQUIED" => "Y", "DEFAULT_VALUE" => "", "SORT" => 1000, "USER_PROPS" => "Y", "IS_LOCATION" => "N", "PROPS_GROUP_ID" => $arGeneralInfo["propGroup"]["adres_ur"], "SIZE1" => 40, "SIZE2" => 0, "DESCRIPTION" => "", "IS_EMAIL" => "N", "IS_PROFILE_NAME" => "Y", "IS_PAYER" => "N", "IS_LOCATION4TAX" => "N", "CODE" => "F_COMPANY_NAME", "IS_FILTERED" => "N"), array("PERSON_TYPE_ID" => $arGeneralInfo["personType"]["ur"], "NAME" => GetMessage("SALE_WIZARD_PROP_9"), "TYPE" => "TEXT", "REQUIED" => "Y", "DEFAULT_VALUE" => "", "SORT" => 1600, "USER_PROPS" => "Y", "IS_LOCATION" => "N", "PROPS_GROUP_ID" => $arGeneralInfo["propGroup"]["adres_ur"], "SIZE1" => 0, "SIZE2" => 0, "DESCRIPTION" => "", "IS_EMAIL" => "N", "IS_PROFILE_NAME" => "N", "IS_PAYER" => "N", "IS_LOCATION4TAX" => "N", "CODE" => "F_PHONE", "IS_FILTERED" => "N"), array("PERSON_TYPE_ID" => $arGeneralInfo["personType"]["ur"], "NAME" => GetMessage("SALE_WIZARD_PROP_10"), "TYPE" => "TEXT", "REQUIED" => "Y", "DEFAULT_VALUE" => "", "SORT" => 2000, "USER_PROPS" => "Y", "IS_LOCATION" => "N", "PROPS_GROUP_ID" => $arGeneralInfo["propGroup"]["adres_ur"], "SIZE1" => 0, "SIZE2" => 0, "DESCRIPTION" => "", "IS_EMAIL" => "N", "IS_PROFILE_NAME" => "N", "IS_PAYER" => "Y", "IS_LOCATION4TAX" => "N", "CODE" => "F_NAME", "IS_FILTERED" => "N"), array("PERSON_TYPE_ID" => $arGeneralInfo["personType"]["ur"], "NAME" => GetMessage("SALE_WIZARD_PROP_11"), "TYPE" => "TEXT", "REQUIED" => "Y", "DEFAULT_VALUE" => "", "SORT" => 1700, "USER_PROPS" => "Y", "IS_LOCATION" => "N", "PROPS_GROUP_ID" => $arGeneralInfo["propGroup"]["adres_ur"], "SIZE1" => 0, "SIZE2" => 0, "DESCRIPTION" => "", "IS_EMAIL" => "N", "IS_PROFILE_NAME" => "N", "IS_PAYER" => "N", "IS_LOCATION4TAX" => "N", "CODE" => "F_FAX", "IS_FILTERED" => "N"), array("PERSON_TYPE_ID" => $arGeneralInfo["personType"]["ur"], "NAME" => GetMessage("SALE_WIZARD_PROP_12"), "TYPE" => "TEXT", "REQUIED" => "Y", "DEFAULT_VALUE" => "", "SORT" => 1900, "USER_PROPS" => "Y", "IS_LOCATION" => "N", "PROPS_GROUP_ID" => $arGeneralInfo["propGroup"]["adres_ur"], "SIZE1" => 0, "SIZE2" => 0, "DESCRIPTION" => "", "IS_EMAIL" => "N", "IS_PROFILE_NAME" => "N", "IS_PAYER" => "N", "IS_LOCATION4TAX" => "N", "CODE" => "F_ADDRESS", "IS_FILTERED" => "N"));
if ($bRus) {
$arProps[] = array("PERSON_TYPE_ID" => $arGeneralInfo["personType"]["ur"], "NAME" => GetMessage("SALE_WIZARD_PROP_13"), "TYPE" => "TEXT", "REQUIED" => "Y", "DEFAULT_VALUE" => "", "SORT" => 1200, "USER_PROPS" => "Y", "IS_LOCATION" => "N", "PROPS_GROUP_ID" => $arGeneralInfo["propGroup"]["adres_ur"], "SIZE1" => 0, "SIZE2" => 0, "DESCRIPTION" => "", "IS_EMAIL" => "N", "IS_PROFILE_NAME" => "N", "IS_PAYER" => "N", "IS_LOCATION4TAX" => "N", "CODE" => "F_INN", "IS_FILTERED" => "N");
$arProps[] = array("PERSON_TYPE_ID" => $arGeneralInfo["personType"]["ur"], "NAME" => GetMessage("SALE_WIZARD_PROP_14"), "TYPE" => "TEXT", "REQUIED" => "Y", "DEFAULT_VALUE" => "", "SORT" => 1300, "USER_PROPS" => "Y", "IS_LOCATION" => "N", "PROPS_GROUP_ID" => $arGeneralInfo["propGroup"]["adres_ur"], "SIZE1" => 0, "SIZE2" => 0, "DESCRIPTION" => "", "IS_EMAIL" => "N", "IS_PROFILE_NAME" => "N", "IS_PAYER" => "N", "IS_LOCATION4TAX" => "N", "CODE" => "F_KPP", "IS_FILTERED" => "N");
}
foreach ($arProps as $prop) {
$variants = array();
if (!empty($prop["VARIANTS"])) {
$variants = $prop["VARIANTS"];
unset($prop["VARIANTS"]);
}
$id = CSaleOrderProps::Add($prop);
if (strlen($prop["CODE"]) > 0) {
$arGeneralInfo["propCode"][$prop["CODE"]] = $prop["CODE"];
$arGeneralInfo["propCodeID"][$prop["CODE"]] = $id;
if (strlen($errorMessage) <= 0) {
if (strlen($apply) <= 0) {
LocalRedirect("/bitrix/admin/sale_order_props_group.php?lang=" . LANG . GetFilterParams("filter_", false));
}
} else {
$bVarsFromForm = true;
}
}
require_once $_SERVER["DOCUMENT_ROOT"] . "/bitrix/modules/sale/prolog.php";
if ($ID > 0) {
$APPLICATION->SetTitle(GetMessage("SOPGEN_UPDATING"));
} else {
$APPLICATION->SetTitle(GetMessage("SOPGEN_ADDING"));
}
require $_SERVER["DOCUMENT_ROOT"] . "/bitrix/modules/main/include/prolog_admin_after.php";
$dbPropsGroup = CSaleOrderPropsGroup::GetList(array(), array("ID" => $ID));
if (!$dbPropsGroup->ExtractFields("str_")) {
if ($saleModulePermissions < "W") {
$errorMessage .= GetMessage("SOPGEN_NO_PERMS2ADD") . ". ";
}
$ID = 0;
}
if ($bVarsFromForm) {
$DB->InitTableVarsForEdit("b_sale_order_props_group", "", "str_");
}
?>
<?php
$aMenu = array(array("TEXT" => GetMessage("SOPGEN_2FLIST"), "ICON" => "btn_list", "LINK" => "/bitrix/admin/sale_order_props_group.php?lang=" . LANG . GetFilterParams("filter_")));
if ($ID > 0 && $saleModulePermissions >= "W") {
$aMenu[] = array("SEPARATOR" => "Y");
if ($arSaleOrderPropsGroup = $dbSaleOrderPropsGroup->GetNext()) {
$arPropGroup["adres_fiz"] = $arSaleOrderPropsGroup["ID"];
} else {
$arPropGroup["adres_fiz"] = CSaleOrderPropsGroup::Add(array("PERSON_TYPE_ID" => $contactPTID, "NAME" => Loc::getMessage("CRM_ORD_PROP_GROUP_FIZ2"), "SORT" => 200));
}
$dbSaleOrderPropsGroup = CSaleOrderPropsGroup::GetList(array(), array("PERSON_TYPE_ID" => $companyPTID, "NAME" => Loc::getMessage("CRM_ORD_PROP_GROUP_UR1")), false, false, array("ID"));
if ($arSaleOrderPropsGroup = $dbSaleOrderPropsGroup->GetNext()) {
$arPropGroup["user_ur"] = $arSaleOrderPropsGroup["ID"];
} else {
$arPropGroup["user_ur"] = CSaleOrderPropsGroup::Add(array("PERSON_TYPE_ID" => $companyPTID, "NAME" => Loc::getMessage("CRM_ORD_PROP_GROUP_UR1"), "SORT" => 300));
}
$dbSaleOrderPropsGroup = CSaleOrderPropsGroup::GetList(array(), array("PERSON_TYPE_ID" => $companyPTID, "NAME" => Loc::getMessage("CRM_ORD_PROP_GROUP_UR2")), false, false, array("ID"));
if ($arSaleOrderPropsGroup = $dbSaleOrderPropsGroup->GetNext()) {
$arPropGroup["adres_ur"] = $arSaleOrderPropsGroup["ID"];
} else {
$arPropGroup["adres_ur"] = CSaleOrderPropsGroup::Add(array("PERSON_TYPE_ID" => $companyPTID, "NAME" => Loc::getMessage("CRM_ORD_PROP_GROUP_UR2"), "SORT" => 400));
}
$arProps = array();
$arProps[] = array("PERSON_TYPE_ID" => $contactPTID, "NAME" => Loc::getMessage("CRM_ORD_PROP_6"), "TYPE" => "TEXT", "REQUIED" => "Y", "DEFAULT_VALUE" => "", "SORT" => 100, "USER_PROPS" => "Y", "IS_LOCATION" => "N", "PROPS_GROUP_ID" => $arPropGroup["user_fiz"], "SIZE1" => 40, "SIZE2" => 0, "DESCRIPTION" => "", "IS_EMAIL" => "N", "IS_PROFILE_NAME" => "Y", "IS_PAYER" => "Y", "IS_LOCATION4TAX" => "N", "CODE" => "FIO", "IS_FILTERED" => "Y");
$arProps[] = array("PERSON_TYPE_ID" => $contactPTID, "NAME" => "E-Mail", "TYPE" => "TEXT", "REQUIED" => "Y", "DEFAULT_VALUE" => "", "SORT" => 110, "USER_PROPS" => "Y", "IS_LOCATION" => "N", "PROPS_GROUP_ID" => $arPropGroup["user_fiz"], "SIZE1" => 40, "SIZE2" => 0, "DESCRIPTION" => "", "IS_EMAIL" => "Y", "IS_PROFILE_NAME" => "N", "IS_PAYER" => "N", "IS_LOCATION4TAX" => "N", "CODE" => "EMAIL", "IS_FILTERED" => "Y");
$arProps[] = array("PERSON_TYPE_ID" => $contactPTID, "NAME" => Loc::getMessage("CRM_ORD_PROP_9"), "TYPE" => "TEXT", "REQUIED" => "Y", "DEFAULT_VALUE" => "", "SORT" => 120, "USER_PROPS" => "Y", "IS_LOCATION" => "N", "PROPS_GROUP_ID" => $arPropGroup["user_fiz"], "SIZE1" => 0, "SIZE2" => 0, "DESCRIPTION" => "", "IS_EMAIL" => "N", "IS_PROFILE_NAME" => "N", "IS_PAYER" => "N", "IS_LOCATION4TAX" => "N", "CODE" => "PHONE", "IS_FILTERED" => "N");
$arProps[] = array("PERSON_TYPE_ID" => $contactPTID, "NAME" => Loc::getMessage("CRM_ORD_PROP_4"), "TYPE" => "TEXT", "REQUIED" => "N", "DEFAULT_VALUE" => "101000", "SORT" => 130, "USER_PROPS" => "Y", "IS_LOCATION" => "N", "PROPS_GROUP_ID" => $arPropGroup["adres_fiz"], "SIZE1" => 8, "SIZE2" => 0, "DESCRIPTION" => "", "IS_EMAIL" => "N", "IS_PROFILE_NAME" => "N", "IS_PAYER" => "N", "IS_LOCATION4TAX" => "N", "CODE" => "ZIP", "IS_FILTERED" => "N", "IS_ZIP" => "Y");
$arProps[] = array("PERSON_TYPE_ID" => $contactPTID, "NAME" => Loc::getMessage("CRM_ORD_PROP_21"), "TYPE" => "TEXT", "REQUIED" => "N", "DEFAULT_VALUE" => "", "SORT" => 145, "USER_PROPS" => "Y", "IS_LOCATION" => "N", "PROPS_GROUP_ID" => $arPropGroup["adres_fiz"], "SIZE1" => 40, "SIZE2" => 0, "DESCRIPTION" => "", "IS_EMAIL" => "N", "IS_PROFILE_NAME" => "N", "IS_PAYER" => "N", "IS_LOCATION4TAX" => "N", "CODE" => "CITY", "IS_FILTERED" => "Y");
$arProps[] = array("PERSON_TYPE_ID" => $contactPTID, "NAME" => Loc::getMessage("CRM_ORD_PROP_2"), "TYPE" => "LOCATION", "REQUIED" => "Y", "DEFAULT_VALUE" => "", "SORT" => 140, "USER_PROPS" => "Y", "IS_LOCATION" => "Y", "PROPS_GROUP_ID" => $arPropGroup["adres_fiz"], "SIZE1" => 40, "SIZE2" => 0, "DESCRIPTION" => "", "IS_EMAIL" => "N", "IS_PROFILE_NAME" => "N", "IS_PAYER" => "N", "IS_LOCATION4TAX" => "Y", "CODE" => "LOCATION", "IS_FILTERED" => "N", "INPUT_FIELD_LOCATION" => "");
$arProps[] = array("PERSON_TYPE_ID" => $contactPTID, "NAME" => Loc::getMessage("CRM_ORD_PROP_5"), "TYPE" => "TEXTAREA", "REQUIED" => "Y", "DEFAULT_VALUE" => "", "SORT" => 150, "USER_PROPS" => "Y", "IS_LOCATION" => "N", "PROPS_GROUP_ID" => $arPropGroup["adres_fiz"], "SIZE1" => 30, "SIZE2" => 3, "DESCRIPTION" => "", "IS_EMAIL" => "N", "IS_PROFILE_NAME" => "N", "IS_PAYER" => "N", "IS_LOCATION4TAX" => "N", "CODE" => "ADDRESS", "IS_FILTERED" => "N");
if ($shopLocalization == "ru") {
$arProps[] = array("PERSON_TYPE_ID" => $companyPTID, "NAME" => Loc::getMessage("CRM_ORD_PROP_13"), "TYPE" => "TEXT", "REQUIED" => "N", "DEFAULT_VALUE" => "", "SORT" => 220, "USER_PROPS" => "Y", "IS_LOCATION" => "N", "PROPS_GROUP_ID" => $arPropGroup["user_ur"], "SIZE1" => 0, "SIZE2" => 0, "DESCRIPTION" => "", "IS_EMAIL" => "N", "IS_PROFILE_NAME" => "N", "IS_PAYER" => "N", "IS_LOCATION4TAX" => "N", "CODE" => "INN", "IS_FILTERED" => "N");
$arProps[] = array("PERSON_TYPE_ID" => $companyPTID, "NAME" => Loc::getMessage("CRM_ORD_PROP_14"), "TYPE" => "TEXT", "REQUIED" => "N", "DEFAULT_VALUE" => "", "SORT" => 230, "USER_PROPS" => "Y", "IS_LOCATION" => "N", "PROPS_GROUP_ID" => $arPropGroup["user_ur"], "SIZE1" => 0, "SIZE2" => 0, "DESCRIPTION" => "", "IS_EMAIL" => "N", "IS_PROFILE_NAME" => "N", "IS_PAYER" => "N", "IS_LOCATION4TAX" => "N", "CODE" => "KPP", "IS_FILTERED" => "N");
} elseif ($shopLocalization == "de") {
$arProps[] = array("PERSON_TYPE_ID" => $companyPTID, "NAME" => Loc::getMessage("CRM_ORD_PROP_BLZ"), "TYPE" => "TEXT", "REQUIED" => "N", "DEFAULT_VALUE" => "", "SORT" => 220, "USER_PROPS" => "Y", "IS_LOCATION" => "N", "PROPS_GROUP_ID" => $arPropGroup["user_ur"], "SIZE1" => 0, "SIZE2" => 0, "DESCRIPTION" => "", "IS_EMAIL" => "N", "IS_PROFILE_NAME" => "N", "IS_PAYER" => "N", "IS_LOCATION4TAX" => "N", "CODE" => "BLZ", "IS_FILTERED" => "N");
$arProps[] = array("PERSON_TYPE_ID" => $companyPTID, "NAME" => Loc::getMessage("CRM_ORD_PROP_IBAN"), "TYPE" => "TEXT", "REQUIED" => "N", "DEFAULT_VALUE" => "", "SORT" => 230, "USER_PROPS" => "Y", "IS_LOCATION" => "N", "PROPS_GROUP_ID" => $arPropGroup["user_ur"], "SIZE1" => 0, "SIZE2" => 0, "DESCRIPTION" => "", "IS_EMAIL" => "N", "IS_PROFILE_NAME" => "N", "IS_PAYER" => "N", "IS_LOCATION4TAX" => "N", "CODE" => "IBAN", "IS_FILTERED" => "N");
"VALUES" => $arColumns,
"DEFAULT" => array(),
"ADDITIONAL_VALUES" => "N",
"PARENT" => "ADDITIONAL_SETTINGS",
),
)
);
$arUsersGroups = Array();
$rsGroups = CGroup::GetList(($by="c_sort"), ($order="desc"), Array("ACTIVE" => "Y"));
while($arGroups = $rsGroups->Fetch()){
$arUsersGroups[$arGroups["ID"]] = $arGroups["NAME"];
}
$arPropsGroup = Array();
$db_propsGroup = CSaleOrderPropsGroup::GetList(array("SORT" => "ASC"), array(), false, false, array());
while ($propsGroup = $db_propsGroup->Fetch())
{
$arPropsGroup[$propsGroup["PERSON_TYPE_ID"]][$propsGroup["ID"]] = $propsGroup["NAME"];
}
$arPersonType = Array();
$dbPerson = CSalePersonType::GetList(array("SORT" => "ASC", "NAME" => "ASC"));
while($arPerson = $dbPerson->GetNext())
{
$arPersonType[$arPerson["ID"]] = $arPerson["NAME"];
$arPers2Prop = array("" => GetMessage("SOA_SHOW_ALL"));
$bProp = false;
$dbProp = CSaleOrderProps::GetList(array("SORT" => "ASC", "NAME" => "ASC"), array("PERSON_TYPE_ID" => $arPerson["ID"]));
while($arProp = $dbProp -> Fetch())
{
<td width="60%">
<input type="text" name="SORT" value="<?echo $str_SORT ?>">
</td>
</tr>
<tr>
<td width="40%"><?echo GetMessage("F_USER_PROPS");?>:</td>
<td width="60%">
<input type="checkbox" name="USER_PROPS" value="Y" <?if ($str_USER_PROPS=="Y") echo "checked"?>>
</td>
</tr>
<tr>
<td width="40%"><?echo GetMessage("F_PROPS_GROUP_ID") ?>:</td>
<td width="60%">
<select name="PROPS_GROUP_ID">
<?
$l = CSaleOrderPropsGroup::GetList(($b="NAME"), ($o="ASC"), Array("PERSON_TYPE_ID"=>$PERSON_TYPE_ID));
while ($l->ExtractFields("l_")):
?><option value="<?echo $l_ID?>"<?if (IntVal($str_PROPS_GROUP_ID)==IntVal($l_ID)) echo " selected"?>>[<?echo $l_ID ?>] <?echo $l_NAME?></option><?
endwhile;
?>
</select>
<a href="sale_order_props_group.php?lang=<?echo LANG?>" target="_blank"><b><?echo GetMessage("SALE_PROPS_GROUP")?> >></b></a>
</td>
</tr>
<tr>
<td width="40%" valign="top"><?echo GetMessage("F_SIZE1");?>:</td>
<td width="60%" valign="top">
<input type="text" name="SIZE1" value="<?echo $str_SIZE1 ?>"><br>
<small><?echo GetMessage("F_SIZE1_DESCR");?></small><br>
</td>
