Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__);
$res = $db_res->Fetch();
if (!empty($res))
return $res;
}
return false;
}
public static function SelectBox($sFieldName, $sValue, $sDefaultValue = "", $JavaChangeFunc = "", $sAdditionalParams = "")
{
if (empty(self::$arExtraCache))
{
self::$arExtraCache = Catalog\ExtraTable::getExtraList();
}
$s = '';
}
public static function Update($ID, $arFields)
{
global $DB;
$ID = (int)$ID;
if ($ID <= 0)
return false;
if (!static::CheckFields('UPDATE', $arFields, $ID))
return false;
$strUpdate = $DB->PrepareUpdate("b_catalog_extra", $arFields);
if (!empty($strUpdate))
{
$strSql = "UPDATE b_catalog_extra SET ".$strUpdate." WHERE ID = ".$ID;
$DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__);
if (isset($arFields['RECALCULATE']) && 'Y' == $arFields['RECALCULATE'])
{
CPrice::ReCalculate('EXTRA', $ID, $arFields['PERCENTAGE']);
}
static::ClearCache();
Catalog\ExtraTable::cleanCache();
Catalog\Model\Price::clearSettings();
}
return true;
}
public static function Delete($ID)
{
global $DB;
$ID = (int)$ID;
if ($ID <= 0)
return false;
$DB->Query("UPDATE b_catalog_price SET EXTRA_ID = NULL WHERE EXTRA_ID = ".$ID);
static::ClearCache();
Catalog\ExtraTable::cleanCache();
Catalog\Model\Price::clearSettings();
return $DB->Query("DELETE FROM b_catalog_extra WHERE ID = ".$ID, true);
}
public static function CheckFields($strAction, &$arFields, $ID = 0)
{
global $APPLICATION;
$arMsg = array();
$boolResult = true;
$strAction = mb_strtoupper($strAction);
$ID = (int)$ID;
if ('UPDATE' == $strAction && 0 >= $ID)
{
$arMsg[] = array('id' => 'ID', 'text' => Loc::getMessage('CAT_EXTRA_ERR_UPDATE_NOT_ID'));
$boolResult = false;
}
if (array_key_exists('ID', $arFields))
{
unset($arFields['ID']);
}
if ('ADD' == $strAction)
{
if (!array_key_exists('NAME', $arFields))
{
$arMsg[] = array('id' => 'NAME', 'text' => Loc::getMessage('CAT_EXTRA_ERROR_NONAME'));
$boolResult = false;
}
if (!array_key_exists('PERCENTAGE', $arFields))
{
$arMsg[] = array('id' => 'PERCENTAGE', 'text' => Loc::getMessage('CAT_EXTRA_ERROR_NOPERCENTAGE'));
$boolResult = false;
}
}
if ($boolResult)
{
if (array_key_exists('NAME', $arFields))
{
$arFields["NAME"] = trim($arFields["NAME"]);
if ('' == $arFields["NAME"])
{
$arMsg[] = array('id' => 'NAME', 'text' => Loc::getMessage('CAT_EXTRA_ERROR_NONAME'));
$boolResult = false;
}
}
if (array_key_exists('PERCENTAGE', $arFields))
{
$arFields["PERCENTAGE"] = trim($arFields["PERCENTAGE"]);
if ('' == $arFields["PERCENTAGE"])
{
$arMsg[] = array('id' => 'PERCENTAGE', 'text' => Loc::getMessage('CAT_EXTRA_ERROR_NOPERCENTAGE'));
$boolResult = false;
}
else
{
$arFields["PERCENTAGE"] = doubleval($arFields["PERCENTAGE"]);
}
}
}
if (!$boolResult)
{
$obError = new CAdminException($arMsg);
$APPLICATION->ResetException();
$APPLICATION->ThrowException($obError);
}
return $boolResult;
}
/**
* @deprecated deprecated since catalog 12.5.6
*
* @param array $arFields
* @param int $intID
* @return false
*/
public static function PrepareInsert(&$arFields, &$intID)
{
return false;
}
}