public function ResetDefaultView()
{
$res = CUserOptions::GetList(null, array("CATEGORY" => "main.interface.grid", "NAME" => $this->grid_id));
while ($row = $res->Fetch()) {
$options = unserialize($row["VALUE"]);
if (!is_array($options)) {
$options = array();
}
unset($options["views"]["default"]);
$options["current_view"] = "default";
CUserOptions::SetOption("main.interface.grid", $this->grid_id, $options, false, $row["USER_ID"]);
}
}
$redirectPath .= "?user_settings_id=" . $newID;
} else {
$redirectPath .= "&user_settings_id=" . $newID;
}
LocalRedirect($redirectPath);
}
} else {
$arResult["ShowStep"] = 1;
$arResult["Templates"] = array();
foreach ($arUserTemplatesList as $arUserTemplate) {
$arUserTemplate["LINK"] = htmlspecialcharsbx($APPLICATION->GetCurPageParam("user_template_id=" . $arUserTemplate["NAME"], array("user_template_id")));
if (StrLen($arUserTemplate["TITLE"]) <= 0) {
$arUserTemplate["TITLE"] = $arUserTemplate["NAME"];
}
$arResult["Templates"][] = $arUserTemplate;
}
$arResult["Settings"] = array();
$dbUserOptionsList = CUserOptions::GetList(array("ID" => "ASC"), array("USER_ID_EXT" => $GLOBALS["USER"]->GetID(), "CATEGORY" => $userSettingsCategory));
while ($arUserOptionTmp = $dbUserOptionsList->Fetch()) {
$val = unserialize($arUserOptionTmp["VALUE"]);
if ($val["IBLOCK_ID"] != $iblockId || $val["TASK_TYPE"] != $taskType || $val["OWNER_ID"] != $ownerId) {
continue;
}
$id = IntVal(SubStr($arUserOptionTmp["NAME"], $userSettingsNamePartLength));
$arResult["Settings"][] = array("ID" => $id, "TITLE" => HtmlSpecialCharsbx($val["TITLE"]), "LINK" => htmlspecialcharsbx($APPLICATION->GetCurPageParam("user_template_id=" . $val["TEMPLATE"] . "&user_settings_id=" . $id, array("user_template_id", "user_settings_id"))));
}
}
}
$arResult["arSocNetFeaturesSettings"] = CSocNetAllowed::GetAllowedFeatures();
}
$this->IncludeComponentTemplate();
function __InTaskInstallViews($iblockId, $taskType, $ownerId)
{
$iblockId = IntVal($iblockId);
$ownerId = IntVal($ownerId);
if (!In_Array($taskType, array("user", "group"))) {
$taskType = "user";
}
$newID = 0;
$dbUserOptionsList = CUserOptions::GetList(array("ID" => "DESC"), array());
if ($arUserOptionTmp = $dbUserOptionsList->Fetch()) {
$newID = IntVal($arUserOptionTmp["ID"]);
}
$arTaskStatus = array();
$dbRes = CIBlockProperty::GetPropertyEnum("TASKSTATUS", array("SORT" => "ASC"), array("IBLOCK_ID" => $iblockId));
while ($arRes = $dbRes->Fetch()) {
$arTaskStatus[StrToUpper($arRes["XML_ID"])] = $arRes;
}
if ($taskType == "group") {
$newID++;
CUserOptions::SetOption("IntranetTasks", "Settings_" . $newID, array("TEMPLATE" => ".default", "TITLE" => GetMessage("INTASK_I_ASSIGNED2ME_ACT"), "IBLOCK_ID" => $iblockId, "TASK_TYPE" => $taskType, "OWNER_ID" => $ownerId, "COLUMNS" => array("NAME" => 1, "TIMESTAMP_X" => 2, "CREATED_BY" => 3, "TASKPRIORITY" => 4, "DATE_ACTIVE_FROM" => 5, "DATE_ACTIVE_TO" => 6, "TASKSTATUS" => 7, "TASKCOMPLETE" => 8), "ORDER_BY_0" => "TIMESTAMP_X", "ORDER_DIR_0" => "DESC", "ORDER_BY_1" => "ID", "ORDER_DIR_1" => "DESC", "FILTER" => array("!TASKSTATUS" => $arTaskStatus["COMPLETED"]["ID"], "TASKASSIGNEDTO" => "current"), "THROUGH_SAMPLING" => $taskType == "user" ? "Y" : "N", "COMMON" => "Y"), true);
$newID++;
CUserOptions::SetOption("IntranetTasks", "Settings_" . $newID, array("TEMPLATE" => ".default", "TITLE" => GetMessage("INTASK_I_BY_PRIORITY"), "IBLOCK_ID" => $iblockId, "TASK_TYPE" => $taskType, "OWNER_ID" => $ownerId, "COLUMNS" => array("NAME" => 1, "TIMESTAMP_X" => 2, "CREATED_BY" => 3, "TASKPRIORITY" => 4, "DATE_ACTIVE_FROM" => 5, "DATE_ACTIVE_TO" => 6, "TASKSTATUS" => 7, "TASKCOMPLETE" => 8), "ORDER_BY_0" => "TASKPRIORITY", "ORDER_DIR_0" => "ASC", "ORDER_BY_1" => "DATE_ACTIVE_TO", "ORDER_DIR_1" => "ASC", "FILTER" => array("TASKASSIGNEDTO" => "current", "!TASKSTATUS" => $arTaskStatus["COMPLETED"]["ID"]), "THROUGH_SAMPLING" => "Y", "COMMON" => "Y"), true);
$newID++;
CUserOptions::SetOption("IntranetTasks", "Settings_" . $newID, array("TEMPLATE" => ".default", "TITLE" => GetMessage("INTASK_I_ASSIGNED2ME_FIN"), "IBLOCK_ID" => $iblockId, "TASK_TYPE" => $taskType, "OWNER_ID" => $ownerId, "COLUMNS" => array("NAME" => 1, "CREATED_BY" => 2, "TASKSIZE" => 3, "TASKSIZEREAL" => 4, "TASKFINISH" => 5), "ORDER_BY_0" => "TASKFINISH", "ORDER_DIR_0" => "DESC", "ORDER_BY_1" => "DATE_ACTIVE_TO", "ORDER_DIR_1" => "DESC", "FILTER" => array("TASKSTATUS" => $arTaskStatus["COMPLETED"]["ID"], "TASKASSIGNEDTO" => "current"), "THROUGH_SAMPLING" => $taskType == "user" ? "Y" : "N", "COMMON" => "Y"), true);
$newID++;
CUserOptions::SetOption("IntranetTasks", "Settings_" . $newID, array("TEMPLATE" => ".default", "TITLE" => GetMessage("INTASK_I_CREATED_BY_ACT"), "IBLOCK_ID" => $iblockId, "TASK_TYPE" => $taskType, "OWNER_ID" => $ownerId, "COLUMNS" => array("NAME" => 1, "TIMESTAMP_X" => 2, "TASKASSIGNEDTO" => 3, "DATE_ACTIVE_FROM" => 4, "DATE_ACTIVE_TO" => 5, "TASKSTATUS" => 6, "TASKCOMPLETE" => 7), "ORDER_BY_0" => "TIMESTAMP_X", "ORDER_DIR_0" => "DESC", "ORDER_BY_1" => "ID", "ORDER_DIR_1" => "DESC", "FILTER" => array("!TASKSTATUS" => $arTaskStatus["COMPLETED"]["ID"], "CREATED_BY" => "current"), "THROUGH_SAMPLING" => $taskType == "user" ? "Y" : "N", "COMMON" => "Y"), true);
$newID++;
CUserOptions::SetOption("IntranetTasks", "Settings_" . $newID, array("TEMPLATE" => ".default", "TITLE" => GetMessage("INTASK_I_CREATED_BY_FIN"), "IBLOCK_ID" => $iblockId, "TASK_TYPE" => $taskType, "OWNER_ID" => $ownerId, "COLUMNS" => array("NAME" => 1, "TASKASSIGNEDTO" => 2, "TASKSIZE" => 3, "TASKSIZEREAL" => 4, "TASKFINISH" => 5), "ORDER_BY_0" => "TASKFINISH", "ORDER_DIR_0" => "DESC", "ORDER_BY_1" => "ID", "ORDER_DIR_1" => "DATE_ACTIVE_TO", "FILTER" => array("TASKSTATUS" => $arTaskStatus["COMPLETED"]["ID"], "CREATED_BY" => "current"), "THROUGH_SAMPLING" => $taskType == "user" ? "Y" : "N", "COMMON" => "Y"), true);
$newID++;
CUserOptions::SetOption("IntranetTasks", "Settings_" . $newID, array("TEMPLATE" => ".default", "TITLE" => GetMessage("INTASK_I_TODAY"), "IBLOCK_ID" => $iblockId, "TASK_TYPE" => $taskType, "OWNER_ID" => $ownerId, "COLUMNS" => array("NAME" => 1, "TIMESTAMP_X" => 2, "CREATED_BY" => 3, "TASKPRIORITY" => 4, "DATE_ACTIVE_FROM" => 5, "DATE_ACTIVE_TO" => 6, "TASKSTATUS" => 7, "TASKCOMPLETE" => 8), "ORDER_BY_0" => "TASKPRIORITY", "ORDER_DIR_0" => "ASC", "ORDER_BY_1" => "DATE_ACTIVE_TO", "ORDER_DIR_1" => "ASC", "FILTER" => array("TASKASSIGNEDTO" => "current", "!TASKSTATUS" => $arTaskStatus["COMPLETED"]["ID"], "<DATE_ACTIVE_FROM" => "current"), "THROUGH_SAMPLING" => "Y", "COMMON" => "Y"), true);
$newID++;
CUserOptions::SetOption("IntranetTasks", "Settings_" . $newID, array("TEMPLATE" => "gant", "TITLE" => GetMessage("INTASK_I_GANT"), "IBLOCK_ID" => $iblockId, "TASK_TYPE" => $taskType, "OWNER_ID" => $ownerId, "COLUMNS" => array("NAME" => 1, "TIMESTAMP_X" => 2, "CREATED_BY" => 3, "TASKASSIGNEDTO" => 4, "TASKPRIORITY" => 5, "DATE_ACTIVE_FROM" => 6, "DATE_ACTIVE_TO" => 7, "TASKSTATUS" => 8, "TASKCOMPLETE" => 9), "ORDER_BY_0" => "DATE_ACTIVE_TO", "ORDER_DIR_0" => "ASC", "ORDER_BY_1" => "TASKPRIORITY", "ORDER_DIR_1" => "ASC", "ORDER_BY_3" => "DATE_ACTIVE_FROM", "ORDER_DIR_3" => "ASC", "FILTER" => array("!TASKSTATUS" => $arTaskStatus["COMPLETED"]["ID"]), "THROUGH_SAMPLING" => "Y", "COMMON" => "Y"), true);
$newID++;
CUserOptions::SetOption("IntranetTasks", "Settings_" . $newID, array("TEMPLATE" => ".default", "TITLE" => GetMessage("INTASK_I_FIN"), "IBLOCK_ID" => $iblockId, "TASK_TYPE" => $taskType, "OWNER_ID" => $ownerId, "COLUMNS" => array("NAME" => 1, "TASKASSIGNEDTO" => 2, "TASKSIZE" => 3, "TASKSIZEREAL" => 4, "TASKFINISH" => 5), "ORDER_BY_0" => "TASKFINISH", "ORDER_DIR_0" => "DESC", "ORDER_BY_1" => "ID", "ORDER_DIR_1" => "DATE_ACTIVE_TO", "FILTER" => array("TASKSTATUS" => $arTaskStatus["COMPLETED"]["ID"]), "THROUGH_SAMPLING" => $taskType == "user" ? "Y" : "N", "COMMON" => "Y"), true);
} elseif ($taskType == "user" && $ownerId == $GLOBALS["USER"]->GetID()) {
$newID++;
CUserOptions::SetOption("IntranetTasks", "Settings_" . $newID, array("TEMPLATE" => ".default", "TITLE" => GetMessage("INTASK_I_ASSIGNED2ME_ACT"), "IBLOCK_ID" => $iblockId, "TASK_TYPE" => $taskType, "OWNER_ID" => $ownerId, "COLUMNS" => array("NAME" => 1, "TIMESTAMP_X" => 2, "CREATED_BY" => 3, "TASKPRIORITY" => 4, "DATE_ACTIVE_FROM" => 5, "DATE_ACTIVE_TO" => 6, "TASKSTATUS" => 7, "TASKCOMPLETE" => 8), "ORDER_BY_0" => "TIMESTAMP_X", "ORDER_DIR_0" => "DESC", "ORDER_BY_1" => "ID", "ORDER_DIR_1" => "DESC", "FILTER" => array("!TASKSTATUS" => $arTaskStatus["COMPLETED"]["ID"], "TASKASSIGNEDTO" => "current"), "THROUGH_SAMPLING" => $taskType == "user" ? "Y" : "N", "COMMON" => "N"), false);
$newID++;
CUserOptions::SetOption("IntranetTasks", "Settings_" . $newID, array("TEMPLATE" => ".default", "TITLE" => GetMessage("INTASK_I_BY_PRIORITY"), "IBLOCK_ID" => $iblockId, "TASK_TYPE" => $taskType, "OWNER_ID" => $ownerId, "COLUMNS" => array("NAME" => 1, "TIMESTAMP_X" => 2, "CREATED_BY" => 3, "TASKPRIORITY" => 4, "DATE_ACTIVE_FROM" => 5, "DATE_ACTIVE_TO" => 6, "TASKSTATUS" => 7, "TASKCOMPLETE" => 8), "ORDER_BY_0" => "TASKPRIORITY", "ORDER_DIR_0" => "ASC", "ORDER_BY_1" => "DATE_ACTIVE_TO", "ORDER_DIR_1" => "ASC", "FILTER" => array("TASKASSIGNEDTO" => "current", "!TASKSTATUS" => $arTaskStatus["COMPLETED"]["ID"]), "THROUGH_SAMPLING" => "Y", "COMMON" => "N"), false);
$newID++;
CUserOptions::SetOption("IntranetTasks", "Settings_" . $newID, array("TEMPLATE" => ".default", "TITLE" => GetMessage("INTASK_I_ASSIGNED2ME_FIN"), "IBLOCK_ID" => $iblockId, "TASK_TYPE" => $taskType, "OWNER_ID" => $ownerId, "COLUMNS" => array("NAME" => 1, "CREATED_BY" => 2, "TASKSIZE" => 3, "TASKSIZEREAL" => 4, "TASKFINISH" => 5), "ORDER_BY_0" => "TASKFINISH", "ORDER_DIR_0" => "DESC", "ORDER_BY_1" => "DATE_ACTIVE_TO", "ORDER_DIR_1" => "DESC", "FILTER" => array("TASKSTATUS" => $arTaskStatus["COMPLETED"]["ID"], "TASKASSIGNEDTO" => "current"), "THROUGH_SAMPLING" => $taskType == "user" ? "Y" : "N", "COMMON" => "N"), false);
$newID++;
CUserOptions::SetOption("IntranetTasks", "Settings_" . $newID, array("TEMPLATE" => ".default", "TITLE" => GetMessage("INTASK_I_CREATED_BY_ACT"), "IBLOCK_ID" => $iblockId, "TASK_TYPE" => $taskType, "OWNER_ID" => $ownerId, "COLUMNS" => array("NAME" => 1, "TIMESTAMP_X" => 2, "TASKASSIGNEDTO" => 3, "DATE_ACTIVE_FROM" => 4, "DATE_ACTIVE_TO" => 5, "TASKSTATUS" => 6, "TASKCOMPLETE" => 7), "ORDER_BY_0" => "TIMESTAMP_X", "ORDER_DIR_0" => "DESC", "ORDER_BY_1" => "ID", "ORDER_DIR_1" => "DESC", "FILTER" => array("!TASKSTATUS" => $arTaskStatus["COMPLETED"]["ID"], "CREATED_BY" => "current"), "THROUGH_SAMPLING" => $taskType == "user" ? "Y" : "N", "COMMON" => "N"), false);
$newID++;
CUserOptions::SetOption("IntranetTasks", "Settings_" . $newID, array("TEMPLATE" => ".default", "TITLE" => GetMessage("INTASK_I_CREATED_BY_FIN"), "IBLOCK_ID" => $iblockId, "TASK_TYPE" => $taskType, "OWNER_ID" => $ownerId, "COLUMNS" => array("NAME" => 1, "TASKASSIGNEDTO" => 2, "TASKSIZE" => 3, "TASKSIZEREAL" => 4, "TASKFINISH" => 5), "ORDER_BY_0" => "TASKFINISH", "ORDER_DIR_0" => "DESC", "ORDER_BY_1" => "ID", "ORDER_DIR_1" => "DATE_ACTIVE_TO", "FILTER" => array("TASKSTATUS" => $arTaskStatus["COMPLETED"]["ID"], "CREATED_BY" => "current"), "THROUGH_SAMPLING" => $taskType == "user" ? "Y" : "N", "COMMON" => "N"), false);
$newID++;
CUserOptions::SetOption("IntranetTasks", "Settings_" . $newID, array("TEMPLATE" => ".default", "TITLE" => GetMessage("INTASK_I_TODAY"), "IBLOCK_ID" => $iblockId, "TASK_TYPE" => $taskType, "OWNER_ID" => $ownerId, "COLUMNS" => array("NAME" => 1, "TIMESTAMP_X" => 2, "CREATED_BY" => 3, "TASKPRIORITY" => 4, "DATE_ACTIVE_FROM" => 5, "DATE_ACTIVE_TO" => 6, "TASKSTATUS" => 7, "TASKCOMPLETE" => 8), "ORDER_BY_0" => "TASKPRIORITY", "ORDER_DIR_0" => "ASC", "ORDER_BY_1" => "DATE_ACTIVE_TO", "ORDER_DIR_1" => "ASC", "FILTER" => array("TASKASSIGNEDTO" => "current", "!TASKSTATUS" => $arTaskStatus["COMPLETED"]["ID"], "<DATE_ACTIVE_FROM" => "current"), "THROUGH_SAMPLING" => "Y", "COMMON" => "N"), false);
$newID++;
CUserOptions::SetOption("IntranetTasks", "Settings_" . $newID, array("TEMPLATE" => "gant", "TITLE" => GetMessage("INTASK_I_GANT"), "IBLOCK_ID" => $iblockId, "TASK_TYPE" => $taskType, "OWNER_ID" => $ownerId, "COLUMNS" => array("NAME" => 1, "TIMESTAMP_X" => 2, "CREATED_BY" => 3, "TASKASSIGNEDTO" => 4, "TASKPRIORITY" => 5, "DATE_ACTIVE_FROM" => 6, "DATE_ACTIVE_TO" => 7, "TASKSTATUS" => 8, "TASKCOMPLETE" => 9), "ORDER_BY_0" => "DATE_ACTIVE_TO", "ORDER_DIR_0" => "ASC", "ORDER_BY_1" => "TASKPRIORITY", "ORDER_DIR_1" => "ASC", "ORDER_BY_3" => "DATE_ACTIVE_FROM", "ORDER_DIR_3" => "ASC", "FILTER" => array("TASKASSIGNEDTO" => "current", "!TASKSTATUS" => $arTaskStatus["COMPLETED"]["ID"]), "THROUGH_SAMPLING" => "Y", "COMMON" => "N"), false);
$userIBlockSectionId = 0;
$dbSectionsList = CIBlockSection::GetList(array(), array("GLOBAL_ACTIVE" => "Y", "EXTERNAL_ID" => "users_tasks", "IBLOCK_ID" => $iblockId, "SECTION_ID" => 0), false);
if ($arSection = $dbSectionsList->GetNext()) {
$userIBlockSectionId = $arSection["ID"];
}
$newID++;
CUserOptions::SetOption("IntranetTasks", "Settings_" . $newID, array("TEMPLATE" => ".default", "TITLE" => GetMessage("INTASK_I_PERSONAL"), "IBLOCK_ID" => $iblockId, "TASK_TYPE" => $taskType, "OWNER_ID" => $ownerId, "COLUMNS" => array("NAME" => 1, "TIMESTAMP_X" => 2, "CREATED_BY" => 3, "TASKPRIORITY" => 4, "DATE_ACTIVE_FROM" => 5, "DATE_ACTIVE_TO" => 6, "TASKSTATUS" => 7, "TASKCOMPLETE" => 8), "ORDER_BY_0" => "TIMESTAMP_X", "ORDER_DIR_0" => "DESC", "ORDER_BY_1" => "ID", "ORDER_DIR_1" => "DESC", "FILTER" => array("TASKASSIGNEDTO" => $ownerId, "IBLOCK_SECTION" => $userIBlockSectionId), "THROUGH_SAMPLING" => "Y", "COMMON" => "N"), false);
} elseif ($taskType == "user") {
$newID++;
CUserOptions::SetOption("IntranetTasks", "Settings_" . $newID, array("TEMPLATE" => "gant", "TITLE" => GetMessage("INTASK_I_GANT"), "IBLOCK_ID" => $iblockId, "TASK_TYPE" => $taskType, "OWNER_ID" => $ownerId, "COLUMNS" => array("NAME" => 1, "TIMESTAMP_X" => 2, "CREATED_BY" => 3, "TASKASSIGNEDTO" => 4, "TASKPRIORITY" => 5, "DATE_ACTIVE_FROM" => 6, "DATE_ACTIVE_TO" => 7, "TASKSTATUS" => 8, "TASKCOMPLETE" => 9), "ORDER_BY_0" => "DATE_ACTIVE_TO", "ORDER_DIR_0" => "ASC", "ORDER_BY_1" => "TASKPRIORITY", "ORDER_DIR_1" => "ASC", "ORDER_BY_3" => "DATE_ACTIVE_FROM", "ORDER_DIR_3" => "ASC", "FILTER" => array("!TASKSTATUS" => $arTaskStatus["COMPLETED"]["ID"]), "THROUGH_SAMPLING" => "Y", "COMMON" => "N"), false);
$userIBlockSectionId = 0;
$dbSectionsList = CIBlockSection::GetList(array(), array("GLOBAL_ACTIVE" => "Y", "EXTERNAL_ID" => "users_tasks", "IBLOCK_ID" => $iblockId, "SECTION_ID" => 0), false);
if ($arSection = $dbSectionsList->GetNext()) {
$userIBlockSectionId = $arSection["ID"];
}
$newID++;
CUserOptions::SetOption("IntranetTasks", "Settings_" . $newID, array("TEMPLATE" => ".default", "TITLE" => GetMessage("INTASK_I_PERSONAL"), "IBLOCK_ID" => $iblockId, "TASK_TYPE" => $taskType, "OWNER_ID" => $ownerId, "COLUMNS" => array("NAME" => 1, "TIMESTAMP_X" => 2, "CREATED_BY" => 3, "TASKPRIORITY" => 4, "DATE_ACTIVE_FROM" => 5, "DATE_ACTIVE_TO" => 6, "TASKSTATUS" => 7, "TASKCOMPLETE" => 8), "ORDER_BY_0" => "TIMESTAMP_X", "ORDER_DIR_0" => "DESC", "ORDER_BY_1" => "ID", "ORDER_DIR_1" => "DESC", "FILTER" => array("TASKASSIGNEDTO" => $ownerId, "IBLOCK_SECTION" => $userIBlockSectionId), "THROUGH_SAMPLING" => "Y", "COMMON" => "N"), false);
}
}
static function DeleteFields($iblock_id)
{
global $DB;
$iblock_id = intval($iblock_id);
$DB->Query("
DELETE FROM b_lists_field
WHERE IBLOCK_ID = ".$iblock_id."
", false, "File: ".__FILE__."<br>Line: ".__LINE__);
$rsOptions = CUserOptions::GetList(array("ID" => "ASC"), array(
"CATEGORY" => "form",
"NAME" => "form_element_".$iblock_id,
));
while($arOption = $rsOptions->Fetch())
{
CUserOptions::DeleteOption(
$arOption["CATEGORY"],
$arOption["NAME"],
$arOption["COMMON"] == "Y",
$arOption["USER_ID"]
);
}
}
public static function clearViewParams($id)
{
global $USER;
if (get_class($USER) === 'CUser' && $id !== null && intval($id) >= 0) {
$user_id = $USER->GetId();
if ($user_id != null) {
$dbRes = CUserOptions::GetList(array("ID" => "ASC"), array('USER_ID' => $user_id, 'CATEGORY' => 'report', 'NAME_MASK' => 'view_params_' . $id . '_'));
if (is_object($dbRes)) {
while ($row = $dbRes->fetch()) {
if (strpos($row['NAME'], 'view_params_' . $id . '_') === 0) {
CUserOptions::DeleteOption('report', $row['NAME'], false, $user_id);
}
}
}
}
}
}
}
}
}
}
}
$updatedReports[$reportID] = serialize($reportSettings);
}
}
}
if (!empty($updatedReports)) {
foreach ($updatedReports as $reportID => &$reportSettings) {
$reportID = intval($reportID);
$expression = $DB->PrepareUpdate('b_report', array('SETTINGS' => $reportSettings), 'report');
$sql = "UPDATE b_report SET {$expression} WHERE ID = {$reportID}";
$DB->QueryBind($sql, array('SETTINGS' => $reportSettings), false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
$dbRes = CUserOptions::GetList(array("ID" => "ASC"), array('CATEGORY' => 'report', 'NAME_MASK' => 'view_params_' . $reportID . '_'));
if (is_object($dbRes)) {
while ($row = $dbRes->fetch()) {
if (strpos($row['NAME'], 'view_params_' . $reportID . '_') === 0) {
CUserOptions::DeleteOptionsByName('report', $row['NAME']);
}
}
}
unset($dbRes);
}
}
unset($reportSettings);
}
if (empty($error)) {
$message = Loc::getMessage('SALE_CONVERTER_AJAX_STEP_UPDATE_BASKET');
$type = 'PROCESS';
