[CORE-862] Support Manager: make support_tickets.code varchar - Blesta

Details

Support Manager ticket.code value should be varchar instead of int.

In addition, we should add a setting to control the format of support ticket codes.

Flags:

%n - a number
%y - a 4-digit year
%m - a 2-digit month
%d - a 2-digit day
%c - a lower case character (a-z)
%C - an upper case character (A-Z)

Examples:

%n%n%n%n%n%n = 6-digit number
ABC%n%n%n%n = ABC followed by a 4-digit number
%y%m%n%n%n = 4-digit year, 2-digit month followed by 3 numbers

Cody Phillips (Inactive) created issue - 05/Nov/13 4:59 PM

Paul Phillips made changes - 23/Apr/14 5:04 PM

Field	Original Value	New Value
Fix Version/s		3.2.0-b2 [ 10501 ]
Fix Version/s	3.2.0-b1 [ 10002 ]

Paul Phillips made changes - 02/May/14 6:38 PM

Fix Version/s		3.2.0-b3 [ 10503 ]
Fix Version/s	3.2.0-b2 [ 10501 ]

Paul Phillips made changes - 09/May/14 2:14 PM

Fix Version/s		3.2.0 [ 10502 ]
Fix Version/s	3.2.0-b3 [ 10503 ]

Cody Phillips (Inactive) made changes - 12/May/14 5:08 PM

Security

Private [ 10000 ]

Paul Phillips made changes - 14/May/14 1:11 PM

Fix Version/s		3.3.0 [ 10100 ]
Fix Version/s	3.2.0 [ 10502 ]

Paul Phillips made changes - 27/Aug/14 4:52 PM

Fix Version/s		3.3.0-b2 [ 10507 ]
Fix Version/s	3.3.0-b1 [ 10100 ]

Paul Phillips made changes - 08/Sep/14 6:19 PM

Fix Version/s		3.5.0 [ 10401 ]
Fix Version/s	3.3.0-b2 [ 10507 ]

Paul Phillips made changes - 08/Apr/15 1:01 PM

Fix Version/s		3.5.0-b2 [ 10701 ]
Fix Version/s	3.5.0-b1 [ 10401 ]

Paul Phillips made changes - 08/Apr/15 4:02 PM

Fix Version/s

3.5.0-b2 [ 10701 ]

Paul Phillips made changes - 21/Jul/16 1:32 PM

Fix Version/s

Long Term [ 10801 ]