sla.php

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

<?php
 
require_once($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/support/classes/general/sla.php");
 
class CTicketSLA extends CAllTicketSLA
{
    // get SLA list
    public static function GetList(&$arSort, $arFilter=Array(), &$isFiltered)
    {
        global $DB, $USER, $APPLICATION;
        $isFiltered = false;
 
        // filter params correct
        if (CTicket::CheckFilter($arFilter))
        {
            $arSqlSearch = Array();
 
            if (is_array($arFilter) && count($arFilter)>0)
            {
 
                $filterKeys = array_keys($arFilter);
                $filterKeysCount = count($filterKeys);
                for ($i=0; $i<$filterKeysCount; $i++)
                {
 
                    $key = $filterKeys[$i];
                    $val = $arFilter[$filterKeys[$i]];
                    if ((is_array($val) && count($val)<=0) || (!is_array($val) && ((string) $val == '' || $val==='NOT_REF')))
                    {
                        continue;
                    }
                    $matchValueSet = (in_array($key."_EXACT_MATCH", $filterKeys)) ? true : false;
                    $key = mb_strtoupper($key);
                    if (is_array($val))
                    {
                        $val = implode(" | ",$val);
                    }
                    switch($key)
                    {
 
                        case "ID":
                        case "SLA_ID":
                            $match = ($arFilter[$key."_EXACT_MATCH"]=="N" && $matchValueSet) ? "Y" : "N";
                            $arSqlSearch[] = GetFilterQuery("S.".$key,$val,$match);
                            break;
                        case "NAME":
                        case "DESCRIPTION":
                        case "DEADLINE_SOURCE":
                            $match = ($arFilter[$key."_EXACT_MATCH"]=="Y" && $matchValueSet) ? "N" : "Y";
                            $arSqlSearch[] = GetFilterQuery("S.".$key, $val, $match);
                            break;
                        case "SITE":
                            $val .= " | ALL";
                            $match = ($arFilter[$key."_EXACT_MATCH"]=="N" && $matchValueSet) ? "Y" : "N";
                            $arSqlSearch[] = GetFilterQuery("SS.SITE_ID", $val, $match);
                            $left_join_site = "LEFT JOIN b_ticket_sla_2_site SS ON (S.ID = SS.SLA_ID)";
                            break;
 
                    }
                }
            }
        }
 
        $strSqlSearch = GetFilterSqlSearch($arSqlSearch);
 
        $arSort = is_array($arSort) ? $arSort : array();
        if (count($arSort)>0)
        {
            $ar1 = array_merge($DB->GetTableFieldsList("b_ticket_sla"), array());
            $ar2 = array_keys($arSort);
            $arDiff = array_diff($ar2, $ar1);
            if (is_array($arDiff) && count($arDiff)>0)
            {
                foreach($arDiff as $value)
                {
                    unset($arSort[$value]);
                }
            }
        }
        if (count($arSort)<=0)
        {
            $arSort = array("PRIORITY" => "DESC");
        }
        foreach ($arSort as $by => $order)
        {
            if(mb_strtoupper($order) != "DESC" )
            {
                $order="ASC";
            }
            if ($by=="RESPONSE_TIME")
            {
                $arSqlOrder[] = "case RESPONSE_TIME_UNIT when 'day' then 3 when 'hour' then 2 when 'minute' then 1 end $order";
                $arSqlOrder[] = $by." ".$order;
            }
            else
            {
                $arSqlOrder[] = $by." ".$order;
            }
        }
        if (is_array($arSqlOrder) && count($arSqlOrder)>0)
        {
            $strSqlOrder = " ORDER BY ".implode(",", $arSqlOrder);
        }
 
        $strSql = "
            SELECT DISTINCT
                S.*,
                case S.RESPONSE_TIME_UNIT
                    when 'day' then S.RESPONSE_TIME*1440
                    when 'hour' then S.RESPONSE_TIME*60
                    when 'minute' then S.RESPONSE_TIME
                    end                                         M_RESPONSE_TIME,
                case S.NOTICE_TIME_UNIT
                    when 'day' then S.NOTICE_TIME*1440
                    when 'hour' then S.NOTICE_TIME*60
                    when 'minute' then S.NOTICE_TIME
                    end                                         M_NOTICE_TIME,
                S.ID                                            REFERENCE_ID,
                S.NAME                                          REFERENCE,
                ".$DB->DateToCharFunction("S.DATE_MODIFY")."    DATE_MODIFY_F,
                ".$DB->DateToCharFunction("S.DATE_CREATE")." DATE_CREATE_F
            FROM
                b_ticket_sla S
            $left_join_site
            WHERE
            $strSqlSearch
            $strSqlOrder
            ";
 
        $rs = $DB->Query($strSql);
        $isFiltered = (IsFiltered($strSqlSearch));
        return $rs;
    }
}