public static function GetAll()
{
if (!CModule::IncludeModule('catalog')) {
return false;
}
$VATS = isset(self::$VATS) ? self::$VATS : null;
if (!$VATS) {
$VATS = array();
$dbResultList = CCatalogVat::GetList(array('C_SORT' => 'ASC'));
while ($arVat = $dbResultList->Fetch()) {
$VATS[$arVat['ID']] = $arVat;
}
self::$VATS = $VATS;
}
return $VATS;
}
if(CModule::IncludeModule("currency"))
{
$dbCur = CCurrency::GetList($by="currency", $o = "asc");
while($arCur = $dbCur->Fetch())
{
if($lang == "ru")
CCurrencyLang::Update($arCur["CURRENCY"], $lang, Array("DECIMALS" => 0));
elseif($arCur["CURRENCY"] == "EUR")
CCurrencyLang::Update($arCur["CURRENCY"], $lang, Array("DECIMALS" => 2, "FORMAT_STRING" => "€#"));
}
}
WizardServices::IncludeServiceLang("step1.php", $lang);
CModule::IncludeModule("catalog");
$dbVat = CCatalogVat::GetList(array(), Array("SITE_ID" => WIZARD_SITE_ID));
if(!($dbVat->Fetch()))
{
$arF = Array ("ACTIVE" => "Y", "SORT" => "100", "NAME" => GetMessage("WIZ_VAT_1"), "RATE" => 0);
CCatalogVat::Set($arF);
$arF = Array ("ACTIVE" => "Y", "SORT" => "200", "NAME" => GetMessage("WIZ_VAT_2"), "RATE" => GetMessage("WIZ_VAT_2_VALUE"));
CCatalogVat::Set($arF);
}
$dbResultList = CCatalogGroup::GetList(Array(), Array("CODE" => "BASE"));
if($arRes = $dbResultList->Fetch())
{
$arFields = Array();
foreach($arLanguages as $langID)
{
WizardServices::IncludeServiceLang("step1.php", $langID);
$arFields["USER_LANG"][$langID] = GetMessage("WIZ_PRICE_NAME");
function GetByID($ID)
{
return CCatalogVat::GetList(array(), array('ID' => $ID));
}
function CheckTax($title, $rate)
{
$tax_name = $title." ".$rate."%";
if(!array_key_exists($tax_name, $this->arTaxCache))
{
$rsVat = CCatalogVat::GetList(
array('CSORT' => 'ASC'),
array(
"NAME" => $tax_name,
"NAME_EXACT_MATCH" => "Y",
"RATE" => $rate,
),
array("ID")
);
if($arVat = $rsVat->Fetch())
$this->arTaxCache[$tax_name] = $arVat["ID"];
else
$this->arTaxCache[$tax_name] = CCatalogVat::Set(array(
"ACTIVE" => "Y",
"NAME" => $tax_name,
"RATE" => $rate,
));
}
return $this->arTaxCache[$tax_name];
}
function CatalogGetVATArray($arFilter = array(), $bInsertEmptyLine = false)
{
$bInsertEmptyLine = true == $bInsertEmptyLine ? true : false;
if (!is_array($arFilter)) {
$arFilter = array();
}
$arFilter['ACTIVE'] = 'Y';
$dbResult = CCatalogVat::GetList(array(), $arFilter, array('ID', 'NAME'));
$arReference = array();
if ($bInsertEmptyLine) {
$arList = array('REFERENCE' => array(0 => GetMessage('CAT_VAT_REF_NOT_SELECTED')), 'REFERENCE_ID' => array(0 => ''));
} else {
$arList = array('REFERENCE' => array(), 'REFERENCE_ID' => array());
}
$bEmpty = true;
while ($arRes = $dbResult->Fetch()) {
$bEmpty = false;
$arList['REFERENCE'][] = $arRes['NAME'];
$arList['REFERENCE_ID'][] = $arRes['ID'];
}
if ($bEmpty && !$bInsertEmptyLine) {
return false;
} else {
return $arList;
}
}
public static function Add($arFields)
{
if (!CModule::IncludeModule('catalog')) {
return false;
}
self::$LAST_ERROR = '';
global $DB;
$tableName = CCrmCatalog::TABLE_NAME;
if (!self::CheckFields('ADD', $arFields, 0)) {
return false;
}
$DB->Add($tableName, $arFields, array(), '', false, 'File: ' . __FILE__ . '<br/>Line: ' . __LINE__);
if (strlen($DB->db_Error) > 0) {
self::RegisterError($DB->db_Error);
return false;
}
// -------------- register in catalog module -------------->
$catalogId = $arFields['ID'];
$arFields = array('IBLOCK_ID' => $catalogId, 'CATALOG' => 'Y');
// get default vat
$defCatVatId = 0;
$dbVat = CCatalogVat::GetList(array('SORT' => 'ASC'));
if ($arVat = $dbVat->Fetch()) {
$defCatVatId = $arVat['ID'];
unset($arVat);
}
unset($dbVat);
$defCatVatId = intval($defCatVatId);
if ($defCatVatId > 0) {
$arFields['VAT_ID'] = $defCatVatId;
}
// add crm iblock to catalog
$CCatalog = new CCatalog();
$dbRes = $CCatalog->GetList(array(), array('ID' => $catalogId), false, false, array('ID'));
if (!$dbRes->Fetch()) {
if ($CCatalog->Add($arFields)) {
COption::SetOptionString('catalog', 'save_product_without_price', 'Y');
COption::SetOptionString('catalog', 'default_can_buy_zero', 'Y');
} else {
self::RegisterError(GetMessage('CRM_ERR_REGISTER_CATALOG'));
return false;
}
}
// <------------- register in catalog module --------------
return true;
}
public static function GetControls($strControlID = false)
{
$arVatList = array();
$arFilter = array();
$rsVats = CCatalogVat::GetList(array(), $arFilter, array('ID', 'NAME'));
while ($arVat = $rsVats->Fetch()) {
$arVatList[$arVat['ID']] = $arVat['NAME'];
}
$arControlList = array('CondIBElement' => array('ID' => 'CondIBElement', 'FIELD' => 'ID', 'FIELD_TYPE' => 'int', 'MULTIPLE' => 'N', 'GROUP' => 'N', 'LABEL' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_ELEMENT_ID_LABEL'), 'PREFIX' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_ELEMENT_ID_PREFIX'), 'LOGIC' => static::GetLogic(array(BT_COND_LOGIC_EQ, BT_COND_LOGIC_NOT_EQ)), 'JS_VALUE' => array('type' => 'popup', 'popup_url' => '/bitrix/admin/iblock_element_search.php', 'popup_params' => array('lang' => LANGUAGE_ID), 'param_id' => 'n', 'show_value' => 'Y'), 'PHP_VALUE' => array('VALIDATE' => 'element')), 'CondIBIBlock' => array('ID' => 'CondIBIBlock', 'FIELD' => 'IBLOCK_ID', 'FIELD_TYPE' => 'int', 'MULTIPLE' => 'N', 'GROUP' => 'N', 'LABEL' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_IBLOCK_ID_LABEL'), 'PREFIX' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_IBLOCK_ID_PREFIX'), 'LOGIC' => static::GetLogic(array(BT_COND_LOGIC_EQ, BT_COND_LOGIC_NOT_EQ)), 'JS_VALUE' => array('type' => 'popup', 'popup_url' => '/bitrix/admin/cat_iblock_search.php', 'popup_params' => array('lang' => LANGUAGE_ID), 'param_id' => 'n', 'show_value' => 'Y'), 'PHP_VALUE' => array('VALIDATE' => 'iblock')), 'CondIBSection' => array('ID' => 'CondIBSection', 'FIELD' => 'SECTION_ID', 'FIELD_TYPE' => 'int', 'MULTIPLE' => 'Y', 'GROUP' => 'N', 'LABEL' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_SECTION_ID_LABEL'), 'PREFIX' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_SECTION_ID_PREFIX'), 'LOGIC' => static::GetLogic(array(BT_COND_LOGIC_EQ, BT_COND_LOGIC_NOT_EQ)), 'JS_VALUE' => array('type' => 'popup', 'popup_url' => '/bitrix/admin/cat_section_search.php', 'popup_params' => array('lang' => LANGUAGE_ID), 'param_id' => 'n', 'show_value' => 'Y'), 'PHP_VALUE' => array('VALIDATE' => 'section')), 'CondIBCode' => array('ID' => 'CondIBCode', 'FIELD' => 'CODE', 'FIELD_TYPE' => 'string', 'FIELD_LENGTH' => 255, 'MULTIPLE' => 'N', 'GROUP' => 'N', 'LABEL' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_CODE_LABEL'), 'PREFIX' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_CODE_PREFIX'), 'LOGIC' => static::GetLogic(array(BT_COND_LOGIC_EQ, BT_COND_LOGIC_NOT_EQ, BT_COND_LOGIC_CONT, BT_COND_LOGIC_NOT_CONT)), 'JS_VALUE' => array('type' => 'input'), 'PHP_VALUE' => ''), 'CondIBXmlID' => array('ID' => 'CondIBXmlID', 'FIELD' => 'XML_ID', 'FIELD_TYPE' => 'string', 'FIELD_LENGTH' => 255, 'MULTIPLE' => 'N', 'GROUP' => 'N', 'LABEL' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_XML_ID_LABEL'), 'PREFIX' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_XML_ID_PREFIX'), 'LOGIC' => static::GetLogic(array(BT_COND_LOGIC_EQ, BT_COND_LOGIC_NOT_EQ, BT_COND_LOGIC_CONT, BT_COND_LOGIC_NOT_CONT)), 'JS_VALUE' => array('type' => 'input'), 'PHP_VALUE' => ''), 'CondIBName' => array('ID' => 'CondIBName', 'FIELD' => 'NAME', 'FIELD_TYPE' => 'string', 'FIELD_LENGTH' => 255, 'MULTIPLE' => 'N', 'GROUP' => 'N', 'LABEL' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_NAME_LABEL'), 'PREFIX' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_NAME_PREFIX'), 'LOGIC' => static::GetLogic(array(BT_COND_LOGIC_EQ, BT_COND_LOGIC_NOT_EQ, BT_COND_LOGIC_CONT, BT_COND_LOGIC_NOT_CONT)), 'JS_VALUE' => array('type' => 'input'), 'PHP_VALUE' => ''), 'CondIBActive' => array('ID' => 'CondIBActive', 'FIELD' => 'ACTIVE', 'FIELD_TYPE' => 'char', 'MULTIPLE' => 'N', 'GROUP' => 'N', 'LABEL' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_ACTIVE_LABEL'), 'PREFIX' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_ACTIVE_PREFIX'), 'LOGIC' => static::GetLogic(array(BT_COND_LOGIC_EQ, BT_COND_LOGIC_NOT_EQ)), 'JS_VALUE' => array('type' => 'select', 'values' => array('Y' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_ACTIVE_VALUE_YES'), 'N' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_ACTIVE_VALUE_NO'))), 'PHP_VALUE' => array('VALIDATE' => 'list')), 'CondIBDateActiveFrom' => array('ID' => 'CondIBDateActiveFrom', 'FIELD' => 'DATE_ACTIVE_FROM', 'FIELD_TYPE' => 'datetime', 'MULTIPLE' => 'N', 'GROUP' => 'N', 'LABEL' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_DATE_ACTIVE_FROM_LABEL'), 'PREFIX' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_DATE_ACTIVE_FROM_PREFIX'), 'LOGIC' => static::GetLogic(array(BT_COND_LOGIC_EQ, BT_COND_LOGIC_NOT_EQ, BT_COND_LOGIC_GR, BT_COND_LOGIC_LS, BT_COND_LOGIC_EGR, BT_COND_LOGIC_ELS)), 'JS_VALUE' => array('type' => 'datetime'), 'PHP_VALUE' => ''), 'CondIBDateActiveTo' => array('ID' => 'CondIBDateActiveTo', 'FIELD' => 'DATE_ACTIVE_TO', 'FIELD_TYPE' => 'datetime', 'MULTIPLE' => 'N', 'GROUP' => 'N', 'LABEL' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_DATE_ACTIVE_TO_LABEL'), 'PREFIX' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_DATE_ACTIVE_TO_PREFIX'), 'LOGIC' => static::GetLogic(array(BT_COND_LOGIC_EQ, BT_COND_LOGIC_NOT_EQ, BT_COND_LOGIC_GR, BT_COND_LOGIC_LS, BT_COND_LOGIC_EGR, BT_COND_LOGIC_ELS)), 'JS_VALUE' => array('type' => 'datetime'), 'PHP_VALUE' => ''), 'CondIBSort' => array('ID' => 'CondIBSort', 'FIELD' => 'SORT', 'FIELD_TYPE' => 'int', 'MULTIPLE' => 'N', 'GROUP' => 'N', 'LABEL' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_SORT_LABEL'), 'PREFIX' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_SORT_PREFIX'), 'LOGIC' => static::GetLogic(array(BT_COND_LOGIC_EQ, BT_COND_LOGIC_NOT_EQ, BT_COND_LOGIC_GR, BT_COND_LOGIC_LS, BT_COND_LOGIC_EGR, BT_COND_LOGIC_ELS)), 'JS_VALUE' => array('type' => 'input'), 'PHP_VALUE' => ''), 'CondIBPreviewText' => array('ID' => 'CondIBPreviewText', 'FIELD' => 'PREVIEW_TEXT', 'FIELD_TYPE' => 'text', 'MULTIPLE' => 'N', 'GROUP' => 'N', 'LABEL' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_PREVIEW_TEXT_LABEL'), 'PREFIX' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_PREVIEW_TEXT_PREFIX'), 'LOGIC' => static::GetLogic(array(BT_COND_LOGIC_EQ, BT_COND_LOGIC_NOT_EQ, BT_COND_LOGIC_CONT, BT_COND_LOGIC_NOT_CONT)), 'JS_VALUE' => array('type' => 'input'), 'PHP_VALUE' => ''), 'CondIBDetailText' => array('ID' => 'CondIBDetailText', 'FIELD' => 'DETAIL_TEXT', 'FIELD_TYPE' => 'text', 'MULTIPLE' => 'N', 'GROUP' => 'N', 'LABEL' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_DETAIL_TEXT_LABEL'), 'PREFIX' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_DETAIL_TEXT_PREFIX'), 'LOGIC' => static::GetLogic(array(BT_COND_LOGIC_EQ, BT_COND_LOGIC_NOT_EQ, BT_COND_LOGIC_CONT, BT_COND_LOGIC_NOT_CONT)), 'JS_VALUE' => array('type' => 'input'), 'PHP_VALUE' => ''), 'CondIBDateCreate' => array('ID' => 'CondIBDateCreate', 'FIELD' => 'DATE_CREATE', 'FIELD_TYPE' => 'datetime', 'MULTIPLE' => 'N', 'GROUP' => 'N', 'LABEL' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_DATE_CREATE_LABEL'), 'PREFIX' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_DATE_CREATE_PREFIX'), 'LOGIC' => static::GetLogic(array(BT_COND_LOGIC_EQ, BT_COND_LOGIC_NOT_EQ, BT_COND_LOGIC_GR, BT_COND_LOGIC_LS, BT_COND_LOGIC_EGR, BT_COND_LOGIC_ELS)), 'JS_VALUE' => array('type' => 'datetime'), 'PHP_VALUE' => ''), 'CondIBCreatedBy' => array('ID' => 'CondIBCreatedBy', 'FIELD' => 'CREATED_BY', 'FIELD_TYPE' => 'int', 'MULTIPLE' => 'N', 'GROUP' => 'N', 'LABEL' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_CREATED_BY_LABEL'), 'PREFIX' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_CREATED_BY_PREFIX'), 'LOGIC' => static::GetLogic(array(BT_COND_LOGIC_EQ, BT_COND_LOGIC_NOT_EQ)), 'JS_VALUE' => array('type' => 'input'), 'PHP_VALUE' => array('VALIDATE' => 'user')), 'CondIBTimestampX' => array('ID' => 'CondIBTimestampX', 'FIELD' => 'TIMESTAMP_X', 'FIELD_TYPE' => 'datetime', 'MULTIPLE' => 'N', 'GROUP' => 'N', 'LABEL' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_TIMESTAMP_X_LABEL'), 'PREFIX' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_TIMESTAMP_X_PREFIX'), 'LOGIC' => static::GetLogic(array(BT_COND_LOGIC_EQ, BT_COND_LOGIC_NOT_EQ, BT_COND_LOGIC_GR, BT_COND_LOGIC_LS, BT_COND_LOGIC_EGR, BT_COND_LOGIC_ELS)), 'JS_VALUE' => array('type' => 'datetime'), 'PHP_VALUE' => ''), 'CondIBModifiedBy' => array('ID' => 'CondIBModifiedBy', 'FIELD' => 'MODIFIED_BY', 'FIELD_TYPE' => 'int', 'MULTIPLE' => 'N', 'GROUP' => 'N', 'LABEL' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_MODIFIED_BY_LABEL'), 'PREFIX' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_MODIFIED_BY_PREFIX'), 'LOGIC' => static::GetLogic(array(BT_COND_LOGIC_EQ, BT_COND_LOGIC_NOT_EQ)), 'JS_VALUE' => array('type' => 'input'), 'PHP_VALUE' => array('VALIDATE' => 'user')), 'CondIBTags' => array('ID' => 'CondIBTags', 'FIELD' => 'TAGS', 'FIELD_TYPE' => 'string', 'FIELD_LENGTH' => 255, 'MULTIPLE' => 'N', 'GROUP' => 'N', 'LABEL' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_TAGS_LABEL'), 'PREFIX' => GetMessage('BT_MOD_CATALOG_COND_CMP_IBLOCK_TAGS_PREFIX'), 'LOGIC' => static::GetLogic(array(BT_COND_LOGIC_EQ, BT_COND_LOGIC_NOT_EQ, BT_COND_LOGIC_CONT, BT_COND_LOGIC_NOT_CONT)), 'JS_VALUE' => array('type' => 'input'), 'PHP_VALUE' => ''), 'CondCatQuantity' => array('ID' => 'CondCatQuantity', 'FIELD' => 'CATALOG_QUANTITY', 'FIELD_TYPE' => 'double', 'MULTIPLE' => 'N', 'GROUP' => 'N', 'LABEL' => GetMessage('BT_MOD_CATALOG_COND_CMP_CATALOG_QUANTITY_LABEL'), 'PREFIX' => GetMessage('BT_MOD_CATALOG_COND_CMP_CATALOG_QUANTITY_PREFIX'), 'LOGIC' => static::GetLogic(array(BT_COND_LOGIC_EQ, BT_COND_LOGIC_NOT_EQ, BT_COND_LOGIC_GR, BT_COND_LOGIC_LS, BT_COND_LOGIC_EGR, BT_COND_LOGIC_ELS)), 'JS_VALUE' => array('type' => 'input')), 'CondCatWeight' => array('ID' => 'CondCatWeight', 'FIELD' => 'CATALOG_WEIGHT', 'FIELD_TYPE' => 'double', 'MULTIPLE' => 'N', 'GROUP' => 'N', 'LABEL' => GetMessage('BT_MOD_CATALOG_COND_CMP_CATALOG_WEIGHT_LABEL'), 'PREFIX' => GetMessage('BT_MOD_CATALOG_COND_CMP_CATALOG_WEIGHT_PREFIX'), 'LOGIC' => static::GetLogic(array(BT_COND_LOGIC_EQ, BT_COND_LOGIC_NOT_EQ, BT_COND_LOGIC_GR, BT_COND_LOGIC_LS, BT_COND_LOGIC_EGR, BT_COND_LOGIC_ELS)), 'JS_VALUE' => array('type' => 'input'), 'PHP_VALUE' => ''), 'CondCatVatID' => array('ID' => 'CondCatVatID', 'FIELD' => 'CATALOG_VAT_ID', 'FIELD_TYPE' => 'int', 'MULTIPLE' => 'N', 'GROUP' => 'N', 'LABEL' => GetMessage('BT_MOD_CATALOG_COND_CMP_CATALOG_VAT_ID_LABEL'), 'PREFIX' => GetMessage('BT_MOD_CATALOG_COND_CMP_CATALOG_VAT_ID_PREFIX'), 'LOGIC' => static::GetLogic(array(BT_COND_LOGIC_EQ, BT_COND_LOGIC_NOT_EQ)), 'JS_VALUE' => array('type' => 'select', 'values' => $arVatList), 'PHP_VALUE' => array('VALIDATE' => 'list')), 'CondCatVatIncluded' => array('ID' => 'CondCatVatIncluded', 'FIELD' => 'CATALOG_VAT_INCLUDED', 'FIELD_TYPE' => 'char', 'MULTIPLE' => 'N', 'GROUP' => 'N', 'LABEL' => GetMessage('BT_MOD_CATALOG_COND_CMP_CATALOG_VAT_INCLUDED_LABEL'), 'PREFIX' => GetMessage('BT_MOD_CATALOG_COND_CMP_CATALOG_VAT_INCLUDED_PREFIX'), 'LOGIC' => static::GetLogic(array(BT_COND_LOGIC_EQ, BT_COND_LOGIC_NOT_EQ)), 'JS_VALUE' => array('type' => 'select', 'values' => array('Y' => GetMessage('BT_MOD_CATALOG_COND_CMP_CATALOG_VAT_INCLUDED_VALUE_YES'), 'N' => GetMessage('BT_MOD_CATALOG_COND_CMP_CATALOG_VAT_INCLUDED_VALUE_NO'))), 'PHP_VALUE' => array('VALIDATE' => 'list')));
if (false === $strControlID) {
return $arControlList;
} elseif (array_key_exists($strControlID, $arControlList)) {
return $arControlList[$strControlID];
} else {
return false;
}
}
break;
case "activate":
case "deactivate":
$arFields = array("ID" => $ID, "ACTIVE" => $_REQUEST['action'] == "activate" ? "Y" : "N");
if (!CCatalogVat::Set($arFields)) {
if ($ex = $APPLICATION->GetException()) {
$lAdmin->AddGroupError($ex->GetString(), $ID);
} else {
$lAdmin->AddGroupError(str_replace("#ID#", $ID, GetMessage("ERROR_UPDATE_VAT")), $ID);
}
}
break;
}
}
}
$dbResultList = CCatalogVat::GetList(array($by => $order), $arFilter);
$dbResultList = new CAdminResult($dbResultList, $sTableID);
$dbResultList->NavStart();
$lAdmin->NavText($dbResultList->GetNavPrint(GetMessage("CVAT_NAV")));
$lAdmin->AddHeaders(array(array("id" => "ID", "content" => "ID", "sort" => "id", "default" => true), array("id" => "C_SORT", "content" => GetMessage("CVAT_SORT"), "sort" => "c_sort", "default" => true), array("id" => "ACTIVE", "content" => GetMessage("CVAT_ACTIVE"), "sort" => "active", "default" => true), array("id" => "NAME", "content" => GetMessage("CVAT_NAME"), "sort" => "name", "default" => true), array("id" => "RATE", "content" => GetMessage("CVAT_RATE"), "sort" => "rate", "default" => true)));
$arVisibleColumns = $lAdmin->GetVisibleHeaderColumns();
while ($arVAT = $dbResultList->NavNext(true, "f_")) {
$row =& $lAdmin->AddRow($f_ID, $arVAT);
$row->AddField("ID", $f_ID);
if ($bReadOnly) {
$row->AddViewField("ACTIVE", $f_ACTIVE);
$row->AddViewField("NAME", $f_NAME);
$row->AddViewField("C_SORT", $f_C_SORT);
} else {
$row->AddCheckField("ACTIVE");
$row->AddInputField("NAME", array("size" => "30"));
