$arFields), "SOCA1");
global $DB;
$arFields1 = array();
foreach ($arFields as $key => $value)
{
if (substr($key, 0, 1)=="=")
{
$arFields1[substr($key, 1)] = $value;
unset($arFields[$key]);
}
}
if (!CSaleOrderChange::CheckFields("ADD", $arFields))
return false;
$arInsert = $DB->PrepareInsert("b_sale_order_change", $arFields);
if (!array_key_exists("DATE_CREATE", $arFields))
{
$arInsert[0] .= ", DATE_CREATE";
$arInsert[1] .= ", ".$DB->GetNowFunction();
}
if (!array_key_exists("DATE_MODIFY", $arFields))
{
$arInsert[0] .= ", DATE_MODIFY";
$arInsert[1] .= ", ".$DB->GetNowFunction();
}
foreach ($arFields1 as $key => $value)
{
if (strlen($arInsert[0])>0)
{
$arInsert[0] .= ", ";
$arInsert[1] .= ", ";
}
$arInsert[0] .= $key;
$arInsert[1] .= $value;
}
$strSql =
"INSERT INTO b_sale_order_change(".$arInsert[0].") ".
"VALUES(".$arInsert[1].")";
$DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__);
$ID = IntVal($DB->LastID());
return $ID;
}
function Update($ID, $arFields)
{
if (defined("SALE_DEBUG") && SALE_DEBUG)
CSaleHelper::WriteToLog("CSaleOrderChange - Update", array("ID" => $ID, "arFields" => $arFields), "SOCU2");
global $DB;
$ID = IntVal($ID);
$arFields1 = array();
foreach ($arFields as $key => $value)
{
if (substr($key, 0, 1)=="=")
{
$arFields1[substr($key, 1)] = $value;
unset($arFields[$key]);
}
}
if (!CSaleOrderChange::CheckFields("UPDATE", $arFields))
return false;
$strUpdate = $DB->PrepareUpdate("b_sale_order_change", $arFields);
foreach ($arFields1 as $key => $value)
{
if (strlen($strUpdate)>0) $strUpdate .= ", ";
$strUpdate .= $key."=".$value." ";
}
$strSql =
"UPDATE b_sale_order_change SET ".
" ".$strUpdate." ";
if($bDateUpdate)
$strSql .= ", DATE_MODIFY = ".$DB->GetNowFunction()." ";
$strSql .= "WHERE ID = ".$ID." ";
$res = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__);
return $ID;
}
function GetList($arOrder = array("ID"=>"DESC"), $arFilter = array(), $arGroupBy = false, $arNavStartParams = false, $arSelectFields = array())
{
global $DB;
if (array_key_exists("DATE_CREATE_FROM", $arFilter))
{
$val = $arFilter["DATE_CREATE_FROM"];
unset($arFilter["DATE_CREATE_FROM"]);
$arFilter[">=DATE_CREATE"] = $val;
}
if (array_key_exists("DATE_CREATE_TO", $arFilter))
{
$val = $arFilter["DATE_CREATE_TO"];
unset($arFilter["DATE_CREATE_TO"]);
$arFilter["<=DATE_CREATE"] = $val;
}
if (array_key_exists("DATE_MODIFY_FROM", $arFilter))
{
$val = $arFilter["DATE_MODIFY_FROM"];
unset($arFilter["DATE_MODIFY_FROM"]);
$arFilter[">=DATE_MODIFY"] = $val;
}
if (array_key_exists("DATE_MODIFY_TO", $arFilter))
{
$val = $arFilter["DATE_MODIFY_TO"];
unset($arFilter["DATE_MODIFY_TO"]);
$arFilter["<=DATE_MODIFY"] = $val;
}
if (count($arSelectFields) <= 0)
$arSelectFields = array("ID", "ORDER_ID", "TYPE", "DATA", "DATE_CREATE", "DATE_MODIFY", "USER_ID", "ENTITY", "ENTITY_ID");
elseif (in_array("*", $arSelectFields))
$arSelectFields = array("ID", "ORDER_ID", "TYPE", "DATA", "DATE_CREATE", "DATE_MODIFY", "USER_ID", "ENTITY", "ENTITY_ID");
$arFields = array(
"ID" => array("FIELD" => "SOC.ID", "TYPE" => "int"),
"ORDER_ID" => array("FIELD" => "SOC.ORDER_ID", "TYPE" => "int"),
"TYPE" => array("FIELD" => "SOC.TYPE", "TYPE" => "string"),
"DATA" => array("FIELD" => "SOC.DATA", "TYPE" => "string"),
"DATE_CREATE" => array("FIELD" => "SOC.DATE_CREATE", "TYPE" => "datetime"),
"DATE_MODIFY" => array("FIELD" => "SOC.DATE_MODIFY", "TYPE" => "datetime"),
"USER_ID" => array("FIELD" => "SOC.USER_ID", "TYPE" => "int"),
"ENTITY" => array("FIELD" => "SOC.ENTITY", "TYPE" => "string"),
"ENTITY_ID" => array("FIELD" => "SOC.ENTITY_ID", "TYPE" => "int"),
);
$arSqls = CSaleOrder::PrepareSql($arFields, $arOrder, $arFilter, $arGroupBy, $arSelectFields);
$arSqls["SELECT"] = str_replace("%%_DISTINCT_%%", "", $arSqls["SELECT"]);
if (is_array($arGroupBy) && count($arGroupBy)==0)
{
$strSql =
"SELECT ".$arSqls["SELECT"]." ".
"FROM b_sale_order_change SOC ".
" ".$arSqls["FROM"]." ";
if (strlen($arSqls["WHERE"]) > 0)
$strSql .= "WHERE ".$arSqls["WHERE"]." ";
if (strlen($arSqls["GROUPBY"]) > 0)
$strSql .= "GROUP BY ".$arSqls["GROUPBY"]." ";
// echo "!1!=".htmlspecialcharsbx($strSql)."
";
$dbRes = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__);
if ($arRes = $dbRes->Fetch())
return $arRes["CNT"];
else
return False;
}
$strSql =
"SELECT ".$arSqls["SELECT"]." ".
"FROM b_sale_order_change SOC ".
" ".$arSqls["FROM"]." ";
if (strlen($arSqls["WHERE"]) > 0)
$strSql .= "WHERE ".$arSqls["WHERE"]." ";
if (strlen($arSqls["GROUPBY"]) > 0)
$strSql .= "GROUP BY ".$arSqls["GROUPBY"]." ";
if (strlen($arSqls["ORDERBY"]) > 0)
$strSql .= "ORDER BY ".$arSqls["ORDERBY"]." ";
if (is_array($arNavStartParams) && IntVal($arNavStartParams["nTopCount"])<=0)
{
$strSql_tmp =
"SELECT COUNT('x') as CNT ".
"FROM b_sale_order_change SOC ".
" ".$arSqls["FROM"]." ";
if (strlen($arSqls["WHERE"]) > 0)
$strSql_tmp .= "WHERE ".$arSqls["WHERE"]." ";
if (strlen($arSqls["GROUPBY"]) > 0)
$strSql_tmp .= "GROUP BY ".$arSqls["GROUPBY"]." ";
// echo "!2.1!=".htmlspecialcharsbx($strSql_tmp)."
";
$dbRes = $DB->Query($strSql_tmp, false, "File: ".__FILE__."
Line: ".__LINE__);
$cnt = 0;
if (strlen($arSqls["GROUPBY"]) <= 0)
{
if ($arRes = $dbRes->Fetch())
$cnt = $arRes["CNT"];
}
else
{
// FOR MYSQL!!! ANOTHER CODE FOR ORACLE
$cnt = $dbRes->SelectedRowsCount();
}
$dbRes = new CDBResult();
//echo "!2.2!=".htmlspecialcharsbx($strSql)."
";
$dbRes->NavQuery($strSql, $cnt, $arNavStartParams);
}
else
{
if (is_array($arNavStartParams) && IntVal($arNavStartParams["nTopCount"])>0)
$strSql .= "LIMIT ".IntVal($arNavStartParams["nTopCount"]);
// echo "!3!=".htmlspecialcharsbx($strSql)."
";
$dbRes = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__);
}
return $dbRes;
}
}