Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //Код для result_modifier.php компонента lists.list
- $connection = Bitrix\Main\Application::getConnection();
- $sqlHelper = $connection->getSqlHelper();
- $name = $arResult["FILTER_ID"];
- $user_id = $_GET["user"];
- $user_name = "";
- $propUserID = "";
- switch ($arResult["FILTER_ID"]) {
- case "lists_list_elements_14";
- $propUserID = "93";
- break;
- case "lists_list_elements_11";
- $propUserID = "94";
- break;
- case "lists_list_elements_27";
- $propUserID = "97";
- break;
- }
- $rsUsers = CUser::GetList($by = "ID", $order = "desc", array("ID" => $user_id), array("SELECT" => array(), "FIELDS" => array("ID", "NAME", "LAST_NAME", "SECOND_NAME")));
- while ($rs = $rsUsers->GetNext()) {
- $user_name = $rs["LAST_NAME"] . " " . $rs["NAME"] . " " . $rs["SECOND_NAME"];
- $user_name = trim($user_name);
- }
- $sql = "SELECT * FROM b_user_option WHERE NAME = '" . $name . "' AND USER_ID = '" . $user_id . "' AND CATEGORY = 'main.ui.filter'";
- $arrAllData = [];
- $recordset = $connection->query($sql);
- while ($record = $recordset->fetch()) {
- $arrAllData = $record;
- }
- if (!empty($arrAllData)) {
- $nowParam = unserialize($arrAllData["VALUE"]);
- $nowParam["filters"]["tmp_filter"]["fields"]["PROPERTY_" . $propUserID] = $user_id;
- $nowParam["filters"]["tmp_filter"]["fields"]["PROPERTY_" . $propUserID . "_label"] = $user_name;
- $nowParam = serialize($nowParam);
- $sql = "UPDATE b_user_option SET VALUE='" . $nowParam . "' WHERE `ID`='" . $arrAllData["ID"] . "'";
- $connection->query($sql);
- } else {
- $dew = array(
- 'use_pin_preset' => true,
- 'deleted_presets' =>
- array(),
- 'default_presets' =>
- array(),
- 'default' => 'default_filter',
- 'filter' => 'default_filter',
- 'filters' =>
- array(
- 'default_filter' =>
- array(
- 'fields' =>
- array(),
- 'filter_rows' => 'NAME,CREATED_BY',
- ),
- 'tmp_filter' =>
- array(
- 'fields' =>
- array(
- 'NAME' => '',
- 'CREATED_BY' => '',
- 'CREATED_BY_label' => '',
- ),
- 'filter_rows' => 'NAME,CREATED_BY',
- ),
- ),
- );
- $dew["filters"]["tmp_filter"]["fields"]["PROPERTY_".$propUserID] = $user_id;
- $dew["filters"]["tmp_filter"]["fields"]["PROPERTY_".$propUserID."_label"] = $user_name;
- $nowParam = serialize($dew);
- $sql = "INSERT INTO `b_user_option` (`USER_ID`, `CATEGORY`, `NAME`, `VALUE`, `COMMON`) VALUES ('" . $user_id . "', 'main.ui.filter', '" . $name . "', '" . $nowParam . "', 'N');";
- $connection->query($sql);
- }
- global $APPLICATION;
- $page = $APPLICATION->GetCurPage();
- LocalRedirect($page, false, '301 Moved permanently');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement