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>