Widget CheckField

CREATE PROCEDURE [dbo].[fm_tst-statistic_checkItemField]
    @itemID int,
    @username nvarchar(256),
    @field nvarchar(256),
    @value nvarchar(max),
    @parameters ExtendedDictionaryParameter readonly
AS
BEGIN
    declare @langID int
    select @langID = try_cast(Value as int) from @parameters where [Key] = 'langID'

    declare @valuta nvarchar(32) = iif(@langID=1, 'dollars', 'руб.')
    declare @count nvarchar(32) = iif(@langID=1, 'cnt', 'шт.')

    declare @count1 nvarchar(16), @count2 nvarchar(16), @count3 nvarchar(16)
    declare @count11 nvarchar(16), @count22 nvarchar(16), @count33 nvarchar(16)
    declare @tooltip nvarchar(16)

    if @field = 'period' begin
        if @value = 1 begin
            select @count1 = '+7', @count11 = '22 000 ' + @valuta
            select @count2 = '+12', @count22 = '101 ' + @count
            select @count3 = '+14', @count33 = '130 000 '+@valuta, @tooltip = iif(@langID=1,'(month)', '(за месяц)')
        end else if @value = 2 begin
            select @count1 = '+5', @count11 = '27 0000 ' + @valuta
            select @count2 = '+56', @count22 = '299 ' + @count
            select @count3 = '+47', @count33 = '450 000 ' + @valuta, @tooltip = iif(@langID=1,'(quartal)','(за квартал)')
        end else if @value = 3 begin
            select @count1 = '+4', @count11 = '25 000 ' + @valuta
            select @count2 = '+12', @count22 = '1305 ' + @count
            select @count3 = '+280', @count33 = '900 000 ' + @valuta, @tooltip = iif(@langID=1,'(year)','(за год)')
        end
    end

    declare @ReplaceContainerHtml nvarchar(max)
    select @ReplaceContainerHtml =
    '
    <div class="row mt-2">
        <div class="col-12 col-md-4 border border-1 rounded-left p-3">
          <div class="text-success">'+@count1+'<span class="text-secondary ml-1">'+@tooltip+'</span></div>
          <div class="h3 font-weight-bold text-center">'+@count11+'</div>
          <div class="font-weight-bold text-center text-secondary">'+iif(@langID=1, 'Avg check', 'СРЕДНИЙ ЧЕК')+'</div>
        </div>
        <div class="col-12 col-md-4 border border-1 p-3">
          <div class="text-success">'+@count2+'<span class="text-secondary ml-1">'+@tooltip+'</span></div>
          <div class="h3 font-weight-bold text-center">'+@count22+'</div>
          <div class="font-weight-bold text-center text-secondary">'+iif(@langID=1, 'Orders count', 'КОЛ-ВО ЗАКАЗОВ')+'</div>
        </div>
        <div class="col-12 col-md-4 border border-1 rounded-right p-3">
          <div class="text-success">'+@count3+'<span class="text-secondary ml-1">'+@tooltip+'</span></div>
          <div class="h3 font-weight-bold text-center">'+@count33+'</div>
          <div class="font-weight-bold text-center text-secondary">'+iif(@langID=1, 'Total income', 'ВЫРУЧКА')+'</div>
        </div>
    </div>
    '

    -- SELECT 1
    select '' Msg, 1 Result, '' ShowContainer, '' HideContainer, '' RefreshContainer,
        '#selector1' ReplaceContainer, @ReplaceContainerHtml ReplaceContainerHtml
END