export_data_1.go
5.0 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
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
package service
import (
"fmt"
"strings"
"gitlab.fjmaimaimai.com/allied-creation/performance/pkg/infrastructure/dao"
)
// 员工绩效-综合管理-导出绩效指标
// excel表头部字段
type HeaderLevel struct {
Name string `json:"name"`
Filter map[string]int `json:"-"`
Child []HeaderLevel `json:"child"`
}
// 添加下一层级的字段
func (h *HeaderLevel) addChild(name string) (child *HeaderLevel) {
cIndex, ok := h.Filter[name]
if !ok {
h.Child = append(h.Child, HeaderLevel{
Name: name,
Filter: map[string]int{},
Child: []HeaderLevel{},
})
h.Filter[name] = len(h.Child) - 1
cIndex = h.Filter[name]
}
return &h.Child[cIndex]
}
// 获取表头的所有列表名
func (h *HeaderLevel) collectAllColumn(all *[][]string) {
for _, v := range h.Child {
v.collectColumn(&v, all, nil)
}
}
func (h *HeaderLevel) collectColumn(child *HeaderLevel, columns *[][]string, column *[]string) {
if column == nil {
column = &[]string{}
}
*column = append(*column, h.Name)
for _, v := range child.Child {
if len(v.Child) > 0 {
v.collectColumn(&v, columns, column)
}
if len(v.Child) == 0 {
item := make([]string, len(*column))
copy(item, *column)
item = append(item, v.Name)
*columns = append(*columns, item)
}
}
}
type exportData struct {
userName []string //员工的名称列表 ,对应excel文件的多个sheet
usrIdMap map[string]string
userDayMap map[string][]string //每个员工对应的日期列表 key=员工名称 value= 日期列表
tableHeader map[string]*HeaderLevel //每个员工数据表格对应表头 key=员工名称
data map[string]*strings.Builder //每个员工表头对应的评估填写的数据 key=员工名称+日期+表头
data2 map[string]string //每个员工评估项的标准描述
data3 map[string]string //每个员工评估项的标准权重
}
func newExportData() *exportData {
return &exportData{
userName: nil,
usrIdMap: map[string]string{},
userDayMap: map[string][]string{},
tableHeader: map[string]*HeaderLevel{},
data: map[string]*strings.Builder{},
data2: map[string]string{},
data3: map[string]string{},
}
}
// 设置表格头部字段。和对应的员工列表
func (e *exportData) setCategoryNameList(param []dao.ContentCategoryName) {
for _, v := range param {
if _, ok := e.usrIdMap[v.TargetUserId]; !ok {
if _, ok := e.tableHeader[v.TargetUserName]; ok {
//出现重名,id不同但名称相同
uname := fmt.Sprintf("%s%d", v.TargetUserName, len(e.usrIdMap))
e.usrIdMap[v.TargetUserId] = uname
} else {
e.usrIdMap[v.TargetUserId] = v.TargetUserName
}
e.userName = append(e.userName, e.usrIdMap[v.TargetUserId])
}
userName := e.usrIdMap[v.TargetUserId]
if _, ok := e.tableHeader[userName]; !ok {
e.tableHeader[userName] = &HeaderLevel{
Name: "个人绩效评估等级统计表",
Filter: map[string]int{},
Child: []HeaderLevel{},
}
}
child := e.tableHeader[userName].addChild(v.Category) //第一级,"分类"
weight := e.weightDesc(v.Weight)
child = child.addChild(weight) //第二级 '得分项' '加分项'
child.addChild(v.Name) //第三级 评估项名称
}
}
func (e *exportData) setData(param []*dao.ExportData2) {
userName := ""
key := ""
userDay := map[string]struct{}{}
for _, v := range param {
//员工填写的评估内容
if _, ok := e.usrIdMap[v.TargetUserId]; !ok {
continue
}
userName = e.usrIdMap[v.TargetUserId]
weight := e.weightDesc(v.Weight)
key = e.dataKey(userName, v.BeginDay, v.Category, weight, v.ContentName)
e.data[key] = &strings.Builder{}
e.data[key].WriteString(v.Value + "\n") //填写的等级
for _, vv := range v.Remark {
e.data[key].WriteString(vv.Definition + "\n")
e.data[key].WriteString(vv.RemarkText + "\n")
}
if _, ok := userDay[userName+v.BeginDay]; !ok {
userDay[userName+v.BeginDay] = struct{}{}
e.userDayMap[userName] = append(e.userDayMap[userName], v.BeginDay)
}
key23 := e.data23Key(userName, v.Category, weight, v.ContentName)
e.data2[key23] = v.PromptText
if v.Weight == 0 {
e.data3[key23] = ""
} else {
e.data3[key23] = fmt.Sprintf("%.2f %%", v.Weight)
}
}
}
func (e *exportData) dataKey(userName string, beginDay string, category string, weight string, contentName string) string {
key := fmt.Sprintf("%s-%s-%s-%s-%s", userName, weight, beginDay, category, contentName)
return key
}
func (e *exportData) data23Key(userName string, category string, weight string, contentName string) string {
key := fmt.Sprintf("%s-%s-%s-%s", userName, weight, category, contentName)
return key
}
func (e *exportData) weightDesc(weight float64) string {
if weight == 0 {
return "加分项"
} else {
return "得分项"
}
}
func (e *exportData) userDayKey(userName string) string {
return userName
}