function Update($ID, $arFields)
{
global $DB;
$ID = IntVal($ID);
if (!CSaleOrderPropsValue::CheckFields("UPDATE", $arFields, $ID)) {
return false;
}
$strUpdate = $DB->PrepareUpdate("b_sale_order_props_value", $arFields);
$strSql = "UPDATE b_sale_order_props_value SET " . "\t" . $strUpdate . " " . "WHERE ID = " . $ID . " ";
$DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
return $ID;
}
function Update($ID, $arFields)
{
global $DB;
$ID = IntVal($ID);
if (!CSaleOrderPropsValue::CheckFields("UPDATE", $arFields, $ID)) {
return false;
}
// need to check here if we got CODE or ID came
if (isset($arFields['VALUE']) && (string) $arFields['VALUE'] != '' && CSaleLocation::isLocationProMigrated()) {
$propValue = self::GetByID($ID);
if ($propValue['TYPE'] == 'LOCATION') {
$arFields['VALUE'] = CSaleLocation::tryTranslateIDToCode($arFields['VALUE']);
}
}
$strUpdate = $DB->PrepareUpdate("b_sale_order_props_value", $arFields);
$strSql = "UPDATE b_sale_order_props_value SET " . "\t" . $strUpdate . " " . "WHERE ID = " . $ID . " ";
$DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
return $ID;
}
function Add($arFields)
{
global $DB;
if (!CSaleOrderPropsValue::CheckFields("ADD", $arFields, 0)) {
return false;
}
// translate here
$arFields['VALUE'] = self::translateLocationIDToCode($arFields['VALUE'], $arFields['ORDER_PROPS_ID']);
$arInsert = $DB->PrepareInsert("b_sale_order_props_value", $arFields);
$strSql = "INSERT INTO b_sale_order_props_value(" . $arInsert[0] . ") " . "VALUES(" . $arInsert[1] . ")";
$DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
$ID = IntVal($DB->LastID());
return $ID;
}
function Add($arFields)
{
global $DB;
if (!CSaleOrderPropsValue::CheckFields("ADD", $arFields, 0)) {
return false;
}
$arInsert = $DB->PrepareInsert("b_sale_order_props_value", $arFields);
$strSql = "INSERT INTO b_sale_order_props_value(" . $arInsert[0] . ") " . "VALUES(" . $arInsert[1] . ")";
$DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
$ID = IntVal($DB->LastID());
return $ID;
}
