Google Chart Encoding | Codetter（こーどったー）

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
-- T-SQL --
set nocount on
-- Declares the parameters
declare @VALUE int
declare @ENCODE varchar(64)
declare @DIVISOR int
declare @DIVISION_NUMBER int
declare @COUNTER int
-- ---------------------------
-- CONFIGURABLE SETTINGS:START
-- ---------------------------
-- Defines the numbers which you want to encode
set @VALUE = 100
-- Supported encoding characters
set @ENCODE = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789-.'
-- ---------------------------
-- CONFIGURABLE SETTINGS:END
-- ---------------------------
-- Defines the format (which should be simple or extended)
if @VALUE > (len(@ENCODE) * len(@ENCODE) - 1)
begin
    -- Extended Encoding --
    -- Defines the parameters
    set @DIVISOR = @VALUE - (len(@ENCODE) * len(@ENCODE) - 1)
    set @DIVISION_NUMBER = 1
    set @COUNTER = 0
    -- Loops
    while (len(@DIVISOR) - 3) > @COUNTER
    begin
        -- Defines the parameters
        set @DIVISION_NUMBER = @DIVISION_NUMBER * 10
        set @COUNTER = @COUNTER + 1
    end
    -- Defines the values
    set @VALUE = @VALUE / @DIVISION_NUMBER
    -- Retrieves the encoding characters
    select right(left(@ENCODE, @VALUE / len(@ENCODE) + 1), 1) + right(left(@ENCODE, @VALUE % len(@ENCODE) + 1), 1), @DIVISION_NUMBER
end
else
begin
    -- Simple Encoding --
    -- Retrieves the encoding characters
    select right(left(@ENCODE, @VALUE / len(@ENCODE) + 1), 1) + right(left(@ENCODE, @VALUE % len(@ENCODE) + 1), 1)
end
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX