Server IP : 80.87.202.40 / Your IP : 216.73.216.169 Web Server : Apache System : Linux rospirotorg.ru 5.14.0-539.el9.x86_64 #1 SMP PREEMPT_DYNAMIC Thu Dec 5 22:26:13 UTC 2024 x86_64 User : bitrix ( 600) PHP Version : 8.2.27 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /home/bitrix/ext_www/rospirotorg.ru/bitrix/modules/socialnetwork/classes/mysql/ |
Upload File : |
<?php require_once($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/socialnetwork/classes/general/user.php"); class CSocNetUser extends CAllSocNetUser { public static function SearchUsers($searchString, $groupId = 0, $numberOfUsers = 10) { global $DB; $searchString = Trim($searchString); $groupId = intval($groupId); $numberOfUsers = intval($numberOfUsers); if ($numberOfUsers <= 0) $numberOfUsers = 10; $searchPattern = "'".$DB->ForSql($searchString)."%'"; $strSqlFrom = ""; $strSqlWhere = ""; if ($groupId > 0) { $strSqlFrom = " INNER JOIN b_sonet_user2group UG ON (U.ID = UG.USER_ID AND UG.ROLE <= '".$DB->ForSql(SONET_ROLES_USER)."') "; $strSqlWhere = " AND UG.GROUP_ID = ".$groupId." "; } $strSql = "SELECT U.ID, U.LOGIN, U.EMAIL, U.NAME, U.SECOND_NAME, U.LAST_NAME ". "FROM b_user U ".$strSqlFrom." ". "WHERE (upper(U.NAME) LIKE upper(".$searchPattern.") ". " OR upper(U.LAST_NAME) LIKE upper(".$searchPattern.") ". " OR upper(U.SECOND_NAME) LIKE upper(".$searchPattern.") ". " OR upper(U.EMAIL) LIKE upper(".$searchPattern.") ". " OR upper(U.LOGIN) LIKE upper(".$searchPattern.")) AND ACTIVE = 'Y' ".$strSqlWhere." ". "ORDER BY U.LAST_NAME ASC, U.NAME ASC, U.SECOND_NAME ASC ". "LIMIT 0, ".$numberOfUsers.""; return $DB->Query($strSql); } }