user.php

См. документацию.

<?php
 
##############################################
# Bitrix Site Manager Forum                  #
# Copyright (c) 2002-2009 Bitrix             #
# https://www.bitrixsoft.com                 #
# mailto:admin@bitrixsoft.com                #
##############################################
 
class CAllVoteUser
{
    public static function OnUserLogin()
    {
        $_SESSION["VOTE"] = array("VOTES" => array());
    }
 
    public static function Delete($USER_ID)
    {
        global $DB;
        $USER_ID = intval($USER_ID);
        if ($USER_ID<=0) return;
        $strSql = "DELETE FROM b_vote_user WHERE ID=$USER_ID";
        $res = $DB->Query($strSql);
        return $res;
    }
 
    public static function GetList($by = 's_id', $order = 'desc', $arFilter = [])
    {
        global $DB;
 
        $arSqlSearch = Array();
        $str_table = "";
        $left_join = "";
        if (is_array($arFilter))
        {
            $filter_keys = array_keys($arFilter);
            foreach ($arFilter as $key => $val)
            {
                if(is_array($val))
                {
                    if(count($val) <= 0)
                        continue;
                }
                else
                {
                    if( ((string)$val == '') || ($val === "NOT_REF") )
                        continue;
                }
                $match_value_set = (in_array($key."_EXACT_MATCH", $filter_keys)) ? true : false;
                $key = strtoupper($key);
                switch($key)
                {
                    case "ID":
                        $match = ($arFilter[$key."_EXACT_MATCH"]=="N" && $match_value_set) ? "Y" : "N";
                        $arSqlSearch[] = GetFilterQuery("U.ID",$val,$match);
                        break;
                    case "DATE_START_1":
                        $arSqlSearch[] = "U.DATE_FIRST>=".$DB->CharToDateFunction($val, "SHORT");
                        break;
                    case "DATE_START_2":
                        $arSqlSearch[] = "U.DATE_FIRST<=".$DB->CharToDateFunction($val." 23:59:59", "FULL");
                        break;
                    case "DATE_END_1":
                        $arSqlSearch[] = "U.DATE_LAST>=".$DB->CharToDateFunction($val, "SHORT");
                        break;
                    case "DATE_END_2":
                        $arSqlSearch[] = "U.DATE_LAST<=".$DB->CharToDateFunction($val." 23:59:59", "FULL");
                        break;
                    case "COUNTER_1":
                        $arSqlSearch[] = "U.COUNTER>='".intval($val)."'";
                        break;
                    case "COUNTER_2":
                        $arSqlSearch[] = "U.COUNTER<='".intval($val)."'";
                        break;
                    case "USER":
                        $match = ($arFilter[$key."_EXACT_MATCH"]=="Y" && $match_value_set) ? "N" : "Y";
                        $arSqlSearch[] = GetFilterQuery("U.AUTH_USER_ID,A.LOGIN,A.LAST_NAME,A.NAME",$val,$match);
                        $left_join = "LEFT JOIN b_user A ON (A.ID=U.AUTH_USER_ID)";
                        break;
                    case "GUEST":
                        $match = ($arFilter[$key."_EXACT_MATCH"]=="N" && $match_value_set) ? "Y" : "N";
                        $arSqlSearch[] = GetFilterQuery("U.STAT_GUEST_ID",$val,$match);
                        break;
                    case "IP":
                        $match = ($arFilter[$key."_EXACT_MATCH"]=="Y" && $match_value_set) ? "N" : "Y";
                        $arSqlSearch[] = GetFilterQuery("U.LAST_IP",$val,$match,array("."));
                        break;
                    case "VOTE":
                        $str_table = "
                            INNER JOIN b_vote_event E ON (E.VOTE_USER_ID = U.ID)
                            INNER JOIN b_vote V ON (V.ID = E.VOTE_ID)
                            ";
                        $match = ($arFilter[$key."_EXACT_MATCH"]=="Y" && $match_value_set) ? "N" : "Y";
                        $arSqlSearch[] = GetFilterQuery("E.VOTE_ID, V.TITLE",$val,$match);
                        break;
                    case "VOTE_ID":
                        $str_table = "
                            INNER JOIN b_vote_event E ON (E.VOTE_USER_ID = U.ID)
                            INNER JOIN b_vote V ON (V.ID = E.VOTE_ID)
                            ";
                        $match = ($arFilter[$key."_EXACT_MATCH"]=="N" && $match_value_set) ? "Y" : "N";
                        $arSqlSearch[] = GetFilterQuery("E.VOTE_ID",$val,$match);
                        break;
                }
            }
        }
 
        if ($by == "s_id")                  $strSqlOrder = "ORDER BY U.ID";
        elseif ($by == "s_date_start")        $strSqlOrder = "ORDER BY U.DATE_FIRST";
        elseif ($by == "s_date_end")      $strSqlOrder = "ORDER BY U.DATE_LAST";
        elseif ($by == "s_counter")           $strSqlOrder = "ORDER BY U.COUNTER";
        elseif ($by == "s_user")          $strSqlOrder = "ORDER BY U.AUTH_USER_ID";
        elseif ($by == "s_stat_guest_id")         $strSqlOrder = "ORDER BY U.STAT_GUEST_ID";
        elseif ($by == "s_ip")                $strSqlOrder = "ORDER BY U.LAST_IP";
        else 
        {
            $strSqlOrder = "ORDER BY U.ID";
        }
 
        if ($order != "asc")
        {
            $strSqlOrder .= " desc ";
        }
 
        $strSqlSearch = GetFilterSqlSearch($arSqlSearch);
        $strSql = "
        SELECT VU.ID, U.STAT_GUEST_ID, U.AUTH_USER_ID, U.COUNTER, U.LAST_IP,
            ".$DB->DateToCharFunction("U.DATE_FIRST")." DATE_FIRST,
            ".$DB->DateToCharFunction("U.DATE_LAST")."   DATE_LAST,
            BUSER.LOGIN, BUSER.NAME, BUSER.LAST_NAME, BUSER.SECOND_NAME, BUSER.PERSONAL_PHOTO
        FROM (
            SELECT U.ID
            FROM b_vote_user U
                $str_table
                $left_join
            WHERE $strSqlSearch
            GROUP BY U.ID
        ) VU
        LEFT JOIN b_vote_user U ON (VU.ID = U.ID)
        LEFT JOIN b_user BUSER ON (U.AUTH_USER_ID = BUSER.ID)
        ".$strSqlOrder;
        $res = $DB->Query($strSql);
 
        return $res;
    }
}