data_table.go
2.4 KB
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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
package domain
import "strings"
type DataTable struct {
Fields []*Field `json:"fields"`
Data [][]string `json:"data"`
Total int64 `json:"total"`
}
type Where struct {
PageNumber int `json:"pageNumber"`
PageSize int `json:"pageSize"`
HeaderRow int `json:"headerRow"` // 行号 默认:0
Conditions []Condition `json:"conditions"`
}
func (w Where) Offset() int {
if w.PageNumber == 0 && w.PageSize == 0 {
return 0
}
return (w.PageNumber - 1) * w.PageSize
}
func (w Where) ValidSql() (err error) {
for _, c := range w.Conditions {
if err = SqlDetections(c.Like); err != nil {
return err
}
//if err = SqlDetections(c.In...); err != nil {
// return err
//}
//if err = SqlDetections(c.Ex...); err != nil {
// return err
//}
if err = SqlDetections(c.Order); err != nil {
return err
}
for _, r := range c.Range {
if err = SqlDetections(r.Val); err != nil {
return err
}
}
}
return
}
type Condition struct {
Field *Field `json:"field"`
Like string `json:"like"`
In []interface{} `json:"in"`
Ex []interface{} `json:"ex"`
Range []RangStruct `json:"range"`
Order string `json:"order"`
}
func (t *DataTable) OptionalValue(args ...string) []string {
var values = make([]string, 0)
match := ""
filedType := ""
if len(args) > 0 {
match = args[0]
}
if len(args) > 1 {
filedType = args[1]
}
if len(t.Data) > 0 && len(t.Data[0]) == 1 {
for i := range t.Data {
if len(t.Data[i]) == 0 {
continue
}
if len(match) > 0 && !strings.Contains(t.Data[i][0], match) {
continue
}
if filedType == Float.ToString() || filedType == Date.ToString() {
values = append(values, RoundFieldValue(&Field{SQLType: filedType}, t.Data[i][0]))
continue
}
values = append(values, t.Data[i][0])
}
}
return values
}
func (t *DataTable) Values(f *Field) []string {
var res = make([]string, 0)
index := -1
for i := range t.Fields {
if t.Fields[i].SQLName == f.SQLName {
index = i
break
}
if t.Fields[i].Name == f.SQLName {
index = i
break
}
}
if index < 0 {
return res
}
for i := range t.Data {
for j := range t.Data[i] {
if j == index {
res = append(res, RoundFieldValue(f, t.Data[i][j]))
break
}
}
}
return res
}
func (t *DataTable) MatchFields(from []*Field) []*Field {
return from
}
type RangStruct struct {
Op string `json:"op"`
Val interface{} `json:"val"`
}