12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130 |
- package data
- import (
- "errors"
- "eta/eta_api/models/data_manage"
- "eta/eta_api/models/system"
- "eta/eta_api/services/data/data_manage_permission"
- "eta/eta_api/utils"
- "fmt"
- "strconv"
- "time"
- )
- func chartClassifyHaveChild(allNode []*data_manage.ChartClassifyItems, node *data_manage.ChartClassifyItems) (childs []*data_manage.ChartClassifyItems, yes bool) {
- for _, v := range allNode {
- if v.ParentId == node.ChartClassifyId {
- childs = append(childs, v)
- }
- }
- if len(childs) > 0 {
- yes = true
- }
- return
- }
- func ChartClassifyItemsMakeTree(sysUser *system.Admin, allNode []*data_manage.ChartClassifyItems, node *data_manage.ChartClassifyItems, permissionClassifyIdList []int, level int) {
- node.HaveOperaAuth = data_manage_permission.CheckEdbClassifyPermissionByPermissionIdList(node.IsJoinPermission, node.ChartClassifyId, permissionClassifyIdList)
- button := GetChartClassifyOpButton(sysUser, node.SysUserId, node.HaveOperaAuth)
- node.Button = button
- node.Disable = true
- if node.Level == level {
- node.Disable = false
- }
- childs, _ := chartClassifyHaveChild(allNode, node)
- if len(childs) > 0 {
- for _, child := range childs {
- child.HaveOperaAuth = data_manage_permission.CheckEdbClassifyPermissionByPermissionIdList(child.IsJoinPermission, child.ChartClassifyId, permissionClassifyIdList)
- childButton := GetChartClassifyOpButton(sysUser, child.SysUserId, child.HaveOperaAuth)
- if child.Level == 6 {
- childButton.AddButton = false
- }
- child.Disable = true
- if child.Level == level {
- child.Disable = false
- }
- child.Button = childButton
-
- }
- node.Children = append(node.Children, childs[0:]...)
- for _, v := range childs {
- v.HaveOperaAuth = data_manage_permission.CheckEdbClassifyPermissionByPermissionIdList(v.IsJoinPermission, v.ChartClassifyId, permissionClassifyIdList)
-
- _, has := chartClassifyHaveChild(allNode, v)
- if has {
- ChartClassifyItemsMakeTree(sysUser, allNode, v, permissionClassifyIdList, level)
- } else {
- if level > 0 {
- v.Children = nil
- } else {
- childrenArr := make([]*data_manage.ChartClassifyItems, 0)
- v.Children = childrenArr
- }
- }
- }
- } else {
- if level > 0 {
- node.Children = nil
- } else {
- childrenArr := make([]*data_manage.ChartClassifyItems, 0)
- node.Children = childrenArr
- }
- }
- }
- func FixChartClassify() {
-
- list, err := data_manage.GetChartClassifyByLevel(2, 1)
- if err != nil {
- return
- }
- for _, v := range list {
- classify := new(data_manage.ChartClassify)
- classify.ParentId = v.ChartClassifyId
- classify.ChartClassifyName = v.ChartClassifyName
- classify.HasData = 0
- classify.CreateTime = time.Now()
- classify.ModifyTime = time.Now()
- if utils.RunMode == "debug" {
- classify.SysUserId = 11
- } else {
- classify.SysUserId = 163
- }
- classify.SysUserRealName = "admin"
- classify.Level = 3
- timestamp := strconv.FormatInt(time.Now().UnixNano(), 10)
- classify.UniqueCode = utils.MD5(utils.DATA_PREFIX + "_" + timestamp)
- classify.Sort = v.Sort
- classify.Source = utils.CHART_SOURCE_DEFAULT
- id, err := data_manage.AddChartClassify(classify)
- if err != nil {
- return
- }
- err = data_manage.FIXChartClassifyId(int(id), v.ChartClassifyId)
- if err != nil {
- return
- }
- }
- }
- func FixChartClassifySysUserId() {
-
- list, err := data_manage.GetChartClassifyByLevel(2, 1)
- if err != nil {
- return
- }
- for _, v := range list {
- err := data_manage.EditChartClassifySysUser(v.ChartClassifyId, v.SysUserId, v.SysUserRealName)
- if err != nil {
- return
- }
- fmt.Println("ChartClassifyId:", v.ChartClassifyId)
- }
- fmt.Println("FixChartClassifySysUserId end")
- }
- func GetChartClassifyOpButton(sysUser *system.Admin, belongUserId int, haveOperaAuth bool) (button data_manage.ChartClassifyItemsButton) {
-
- if !haveOperaAuth {
- return
- }
-
-
- button.AddButton = true
- button.OpButton = true
- button.DeleteButton = true
- button.MoveButton = true
-
- return
- }
- func GetCanOpChartClassify(roleTypeCode string) (canOpClassify bool) {
-
- if utils.InArrayByStr([]string{utils.ROLE_TYPE_CODE_ADMIN, utils.ROLE_TYPE_CODE_FICC_ADMIN, utils.ROLE_TYPE_CODE_RESEARCHR, utils.ROLE_TYPE_CODE_FICC_RESEARCHR}, roleTypeCode) {
- canOpClassify = true
- }
- return
- }
- func GetChartOpButton(sysUser *system.Admin, belongUserId int, haveOperaAuth bool) (button data_manage.ChartClassifyItemsButton) {
-
- if !haveOperaAuth {
- return
- }
-
- if sysUser.RoleTypeCode == utils.ROLE_TYPE_CODE_ADMIN || sysUser.RoleTypeCode == utils.ROLE_TYPE_CODE_FICC_ADMIN || sysUser.AdminId == belongUserId || sysUser.PredictEdbPermission == 1 {
- button.AddButton = true
- button.OpButton = true
- button.DeleteButton = true
- button.MoveButton = true
- }
- return
- }
- func HandleNoPermissionChart(allNodes []*data_manage.ChartClassifyItems, noPermissionChartIdMap map[int]bool, sysUserId int) (newAllNodes []*data_manage.ChartClassifyItems) {
-
- classifyIdList := make([]int, 0)
-
- newAllNodes = make([]*data_manage.ChartClassifyItems, 0)
- for _, node := range allNodes {
-
- tmpNodeInfo := *node
- tmpNodeList := make([]*data_manage.ChartClassifyItems, 0)
- if node.Children != nil {
- for _, chartInfo := range node.Children {
-
- if _, ok := noPermissionChartIdMap[chartInfo.ChartInfoId]; ok {
- continue
- }
- tmpNodeList = append(tmpNodeList, chartInfo)
- classifyIdList = append(classifyIdList, chartInfo.ChartClassifyId)
- }
- }
- tmpNodeInfo.Children = tmpNodeList
- newAllNodes = append(newAllNodes, &tmpNodeInfo)
- classifyIdList = append(classifyIdList, node.ChartClassifyId)
- }
-
- if len(classifyIdList) > 0 {
-
- chartClassifyList, err := data_manage.GetChartClassifyByIdList(classifyIdList)
- if err != nil {
- return
- }
- chartClassifyMap := make(map[int]*data_manage.ChartClassify)
- for _, v := range chartClassifyList {
- chartClassifyMap[v.ChartClassifyId] = v
- }
-
- permissionChartIdList, permissionClassifyIdList, err := data_manage_permission.GetUserChartAndClassifyPermissionList(sysUserId, 0, 0)
- if err != nil {
- return
- }
- for _, node := range newAllNodes {
- if node.Children != nil {
- for _, chartInfo := range node.Children {
- if currClassify, ok := chartClassifyMap[chartInfo.ChartClassifyId]; ok {
- chartInfo.HaveOperaAuth = data_manage_permission.CheckChartPermissionByPermissionIdList(chartInfo.IsJoinPermission, currClassify.IsJoinPermission, chartInfo.ChartInfoId, chartInfo.ChartClassifyId, permissionChartIdList, permissionClassifyIdList)
- }
- }
- }
- if currClassify, ok := chartClassifyMap[node.ChartClassifyId]; ok {
- node.HaveOperaAuth = data_manage_permission.CheckChartPermissionByPermissionIdList(node.IsJoinPermission, currClassify.IsJoinPermission, node.ChartInfoId, node.ChartClassifyId, permissionChartIdList, permissionClassifyIdList)
- }
- }
- }
- return
- }
- func AddChartClassify(chartClassifyName string, parentId, level, source int, lang string, sysUser *system.Admin) (classifyInfo *data_manage.ChartClassify, err error, errMsg string, isSendEmail bool) {
- isSendEmail = true
- errMsg = "保存分类失败"
-
- {
- var count int
- switch lang {
- case utils.EnLangVersion:
- count, err = data_manage.GetChartClassifyEnCount(chartClassifyName, parentId, source)
- default:
- count, err = data_manage.GetChartClassifyCount(chartClassifyName, parentId, source)
- }
- if err != nil {
- errMsg = "判断名称是否已存在失败"
- return
- }
- if count > 0 {
- errMsg = "分类名称已存在,请重新输入"
- err = errors.New(errMsg)
- isSendEmail = false
- return
- }
- }
- if level > 5 {
- errMsg = `最高只支持添加6级分类`
- return
- }
-
- maxSort, err := data_manage.GetChartClassifyMaxSort(parentId, source)
- if err != nil {
- errMsg = "获取失败"
- err = errors.New("查询排序信息失败,Err:" + err.Error())
- return
- }
-
- rootId := 0
- if parentId > 0 {
- parentClassify, tErr := data_manage.GetChartClassifyById(parentId)
- if tErr != nil {
- if tErr.Error() == utils.ErrNoRow() {
- errMsg = "父级分类不存在"
- err = errors.New(errMsg)
- return
- }
- errMsg = "获取失败"
- err = errors.New("获取分类信息失败,Err:" + tErr.Error())
- return
- }
- rootId = parentClassify.RootId
- }
- classifyInfo = new(data_manage.ChartClassify)
- classifyInfo.ParentId = parentId
- classifyInfo.ChartClassifyName = chartClassifyName
- classifyInfo.ChartClassifyNameEn = chartClassifyName
- classifyInfo.HasData = 0
- classifyInfo.CreateTime = time.Now()
- classifyInfo.ModifyTime = time.Now()
- classifyInfo.SysUserId = sysUser.AdminId
- classifyInfo.SysUserRealName = sysUser.RealName
- classifyInfo.Level = level + 1
- timestamp := strconv.FormatInt(time.Now().UnixNano(), 10)
- classifyInfo.UniqueCode = utils.MD5(utils.DATA_PREFIX + "_" + timestamp)
- classifyInfo.Sort = maxSort + 1
- classifyInfo.Source = source
- classifyInfo.RootId = rootId
- newId, err := data_manage.AddChartClassify(classifyInfo)
- if err != nil {
- return
- }
- if parentId == 0 {
- classifyInfo.RootId = int(newId)
- err = classifyInfo.Update([]string{"RootId"})
- if err != nil {
- errMsg = "更新分类失败"
- return
- }
- }
-
- if classifyInfo.Source == utils.CHART_SOURCE_DEFAULT {
- go data_manage_permission.InheritParentClassify(5, classifyInfo.Source, classifyInfo.ChartClassifyId, classifyInfo.ParentId, classifyInfo.ChartClassifyName)
- }
- return
- }
- func EditChartClassify(chartClassifyId, source int, chartClassifyName, lang string, sysUser *system.Admin) (classifyInfo *data_manage.ChartClassify, err error, errMsg string, isSendEmail bool) {
- isSendEmail = true
- errMsg = "保存失败"
-
- classifyInfo, err = data_manage.GetChartClassifyById(chartClassifyId)
- if err != nil {
- return
- }
-
- if classifyInfo.Source != source {
- errMsg = "图表分类异常"
- err = errors.New(fmt.Sprintf("图表分类来源异常,修改来源:%d,分类来源:%d", source, classifyInfo.Source))
- isSendEmail = false
- return
- }
-
- updateCols := make([]string, 0)
-
- switch lang {
- case utils.EnLangVersion:
- if classifyInfo.ChartClassifyNameEn != chartClassifyName {
- count, tmpErr := data_manage.GetChartClassifyEnCount(chartClassifyName, classifyInfo.ParentId, source)
- if tmpErr != nil {
- errMsg = "判断名称是否已存在失败"
- err = errors.New("判断名称是否已存在失败,Err:" + tmpErr.Error())
- return
- }
- if count > 0 {
- errMsg = "分类名称已存在,请重新输入"
- err = errors.New(errMsg)
- isSendEmail = false
- return
- }
- classifyInfo.ChartClassifyNameEn = chartClassifyName
- classifyInfo.ModifyTime = time.Now()
- updateCols = append(updateCols, "ChartClassifyNameEn", "ModifyTime")
- }
- default:
- if classifyInfo.ChartClassifyName != chartClassifyName {
- count, tmpErr := data_manage.GetChartClassifyCount(chartClassifyName, classifyInfo.ParentId, source)
- if tmpErr != nil {
- errMsg = "判断名称是否已存在失败"
- err = errors.New("判断名称是否已存在失败,Err:" + tmpErr.Error())
- return
- }
- if count > 0 {
- errMsg = "分类名称已存在,请重新输入"
- err = errors.New(errMsg)
- isSendEmail = false
- return
- }
- classifyInfo.ChartClassifyName = chartClassifyName
- classifyInfo.ModifyTime = time.Now()
- updateCols = append(updateCols, "ChartClassifyName", "ModifyTime")
- }
- }
- if len(updateCols) > 0 {
- err = classifyInfo.Update(updateCols)
- }
- return
- }
- func MoveChartClassify(req data_manage.MoveChartClassifyReq, sysUser *system.Admin, source int) (err error, errMsg string) {
- classifyId := req.ClassifyId
- parentClassifyId := req.ParentClassifyId
- prevClassifyId := req.PrevClassifyId
- nextClassifyId := req.NextClassifyId
- chartInfoId := req.ChartInfoId
- prevChartInfoId := req.PrevChartInfoId
- nextChartInfoId := req.NextChartInfoId
-
-
-
-
-
- var parentChartClassifyInfo *data_manage.ChartClassify
- if parentClassifyId > 0 {
- parentChartClassifyInfo, err = data_manage.GetChartClassifyById(parentClassifyId)
- if err != nil {
- errMsg = "移动失败"
- err = errors.New("获取上级分类信息失败,Err:" + err.Error())
- return
- }
- }
-
- var (
- chartClassifyInfo *data_manage.ChartClassify
- prevClassify *data_manage.ChartClassify
- nextClassify *data_manage.ChartClassify
- chartInfo *data_manage.ChartInfo
- prevChartInfo *data_manage.ChartInfo
- nextChartInfo *data_manage.ChartInfo
- prevSort int
- nextSort int
- )
-
- if chartInfoId == 0 {
- chartClassifyInfo, err = data_manage.GetChartClassifyById(classifyId)
- if err != nil {
- if err.Error() == utils.ErrNoRow() {
- errMsg = "当前分类不存在"
- err = errors.New("获取分类信息失败,Err:" + err.Error())
- return
- }
- errMsg = "移动失败"
- err = errors.New("获取分类信息失败,Err:" + err.Error())
- return
- }
- if parentClassifyId > 0 && parentChartClassifyInfo.Level == 6 {
- errMsg = "最高只支持添加6级分类"
- err = errors.New(errMsg)
- return
- }
-
- exists, e := data_manage.GetChartClassifyByParentIdAndName(parentClassifyId, chartClassifyInfo.ChartClassifyName, classifyId)
- if e != nil && e.Error() != utils.ErrNoRow() {
- errMsg = "移动失败"
- err = fmt.Errorf("获取父级分类下的同名分类失败, Err: %s", e.Error())
- return
- }
- if exists != nil {
- errMsg = "移动失败,分类名称已存在"
- return
- }
-
- {
-
- permissionClassifyIdList, tmpErr := data_manage_permission.GetUserChartClassifyPermissionList(sysUser.AdminId, classifyId)
- if tmpErr != nil {
- errMsg = "移动失败"
- err = errors.New("获取已授权分类id数据失败,Err:" + tmpErr.Error())
- return
- }
-
- haveOperaAuth := data_manage_permission.CheckChartClassifyPermissionByPermissionIdList(chartClassifyInfo.IsJoinPermission, chartClassifyInfo.ChartClassifyId, permissionClassifyIdList)
- button := GetChartClassifyOpButton(sysUser, chartClassifyInfo.SysUserId, haveOperaAuth)
- if !button.MoveButton {
- errMsg = "无操作权限"
- err = errors.New(errMsg)
- return
- }
- }
- } else {
- chartInfo, err = data_manage.GetChartInfoById(req.ChartInfoId)
- if err != nil {
- if err.Error() == utils.ErrNoRow() {
- errMsg = "当前图表不存在"
- err = errors.New("获取分类信息失败,Err:" + err.Error())
- return
- }
- errMsg = "移动失败"
- err = errors.New("获取分类信息失败,Err:" + err.Error())
- return
- }
- if parentClassifyId == 0 {
- errMsg = "移动失败,图表必须挂在分类下"
- err = errors.New(errMsg)
- return
- }
- var haveOperaAuth bool
-
- {
- haveOperaAuth, err = data_manage_permission.CheckChartPermissionByChartInfoId(chartInfo.ChartInfoId, chartInfo.ChartClassifyId, chartInfo.IsJoinPermission, sysUser.AdminId)
- if err != nil {
- errMsg = "移动失败"
- err = errors.New("获取图表权限信息失败,Err:" + err.Error())
- return
- }
- }
-
- button := GetChartOpButton(sysUser, chartInfo.SysUserId, haveOperaAuth)
- if !button.MoveButton {
- errMsg = "无操作权限"
- err = errors.New(errMsg)
- return
- }
- }
- if prevClassifyId > 0 {
- prevClassify, err = data_manage.GetChartClassifyById(prevClassifyId)
- if err != nil {
- errMsg = "移动失败"
- err = errors.New("获取上一个兄弟节点分类信息失败,Err:" + err.Error())
- return
- }
- prevSort = prevClassify.Sort
- } else if prevChartInfoId > 0 {
- prevChartInfo, err = data_manage.GetChartInfoById(prevChartInfoId)
- if err != nil {
- errMsg = "移动失败"
- err = errors.New("获取上一个兄弟节点分类信息失败,Err:" + err.Error())
- return
- }
- prevSort = prevChartInfo.Sort
- }
- if nextClassifyId > 0 {
-
- nextClassify, err = data_manage.GetChartClassifyById(nextClassifyId)
- if err != nil {
- errMsg = "移动失败"
- err = errors.New("获取下一个兄弟节点分类信息失败,Err:" + err.Error())
- return
- }
- nextSort = nextClassify.Sort
- } else if nextChartInfoId > 0 {
-
- nextChartInfo, err = data_manage.GetChartInfoById(nextChartInfoId)
- if err != nil {
- errMsg = "移动失败"
- err = errors.New("获取下一个兄弟节点分类信息失败,Err:" + err.Error())
- return
- }
- nextSort = nextChartInfo.Sort
- }
- err, errMsg = moveChartClassify(parentChartClassifyInfo, chartClassifyInfo, prevClassify, nextClassify, chartInfo, prevChartInfo, nextChartInfo, parentClassifyId, prevSort, nextSort, source)
- return
- }
- func moveChartClassify(parentChartClassifyInfo, chartClassifyInfo, prevClassify, nextClassify *data_manage.ChartClassify, chartInfo, prevChartInfo, nextChartInfo *data_manage.ChartInfo, parentClassifyId, prevSort, nextSort, source int) (err error, errMsg string) {
- updateCol := make([]string, 0)
-
- if chartClassifyInfo != nil {
- oldParentId := chartClassifyInfo.ParentId
- oldLevel := chartClassifyInfo.Level
- var classifyIds []int
- if oldParentId != parentClassifyId {
-
- childList, e, m := GetChildChartClassifyByClassifyId(chartClassifyInfo.ChartClassifyId)
- if e != nil {
- errMsg = "移动失败"
- err = errors.New("查询子分类失败,Err:" + e.Error() + m)
- return
- }
- if len(childList) > 0 {
- for _, v := range childList {
- if v.ChartClassifyId == chartClassifyInfo.ChartClassifyId {
- continue
- }
- classifyIds = append(classifyIds, v.ChartClassifyId)
- }
- }
- }
-
- if chartClassifyInfo.ParentId != parentClassifyId && parentClassifyId != 0 {
- if chartClassifyInfo.Level != parentChartClassifyInfo.Level+1 {
- errMsg = "移动失败"
- err = errors.New("不支持目录层级变更")
- return
- }
- chartClassifyInfo.ParentId = parentChartClassifyInfo.ChartClassifyId
- chartClassifyInfo.RootId = parentChartClassifyInfo.RootId
- chartClassifyInfo.Level = parentChartClassifyInfo.Level + 1
- chartClassifyInfo.ModifyTime = time.Now()
- updateCol = append(updateCol, "ParentId", "RootId", "Level", "ModifyTime")
- } else if chartClassifyInfo.ParentId != parentClassifyId && parentClassifyId == 0 {
- errMsg = "移动失败"
- err = errors.New("不支持目录层级变更")
- return
- }
- if prevSort > 0 {
-
- if nextSort > 0 {
-
-
- if prevSort == nextSort || prevSort == chartClassifyInfo.Sort {
-
- updateSortStr := `sort + 2`
-
- if prevClassify != nil {
- _ = data_manage.UpdateChartClassifySortByParentIdAndSource(parentClassifyId, prevClassify.ChartClassifyId, prevClassify.Sort, updateSortStr, source)
- } else {
- _ = data_manage.UpdateChartClassifySortByParentIdAndSource(parentClassifyId, 0, prevSort, updateSortStr, source)
- }
-
- if prevChartInfo != nil {
-
- _ = data_manage.UpdateChartInfoSortByClassifyIdV2(parentClassifyId, prevSort, prevChartInfo.ChartInfoId, updateSortStr)
- } else {
- _ = data_manage.UpdateChartInfoSortByClassifyIdV2(parentClassifyId, prevSort, 0, updateSortStr)
- }
- } else {
-
- if nextSort-prevSort == 1 {
-
- updateSortStr := `sort + 1`
-
- if prevClassify != nil {
- _ = data_manage.UpdateChartClassifySortByParentIdAndSource(parentClassifyId, prevClassify.ChartClassifyId, prevSort, updateSortStr, source)
- } else {
- _ = data_manage.UpdateChartClassifySortByParentIdAndSource(parentClassifyId, 0, prevSort, updateSortStr, source)
- }
-
- if prevChartInfo != nil {
-
- _ = data_manage.UpdateChartInfoSortByClassifyIdV2(parentClassifyId, prevSort, prevChartInfo.ChartInfoId, updateSortStr)
- } else {
- _ = data_manage.UpdateChartInfoSortByClassifyIdV2(parentClassifyId, prevSort, 0, updateSortStr)
- }
- }
- }
- }
- chartClassifyInfo.Sort = prevSort + 1
- chartClassifyInfo.ModifyTime = time.Now()
- updateCol = append(updateCol, "Sort", "ModifyTime")
- } else if prevClassify == nil && nextClassify == nil && prevChartInfo == nil && nextChartInfo == nil && parentClassifyId > 0 {
-
- var maxSort int
- maxSort, err = GetChartClassifyMaxSort(parentClassifyId, source)
- if err != nil {
- errMsg = "移动失败"
- err = errors.New("查询组内排序信息失败,Err:" + err.Error())
- return
- }
- chartClassifyInfo.Sort = maxSort + 1
- chartClassifyInfo.ModifyTime = time.Now()
- updateCol = append(updateCol, "Sort", "ModifyTime")
- } else {
-
- firstClassify, tmpErr := data_manage.GetFirstChartClassifyByParentId(parentClassifyId)
- if tmpErr != nil && tmpErr.Error() != utils.ErrNoRow() {
- errMsg = "移动失败"
- err = errors.New("获取获取当前父级分类下的排序第一条的分类信息失败,Err:" + tmpErr.Error())
- return
- }
-
- if firstClassify != nil && firstClassify.Sort == 0 {
- updateSortStr := ` sort + 1 `
- _ = data_manage.UpdateChartClassifySortByParentIdAndSource(parentClassifyId, firstClassify.ChartClassifyId-1, 0, updateSortStr, source)
-
- _ = data_manage.UpdateChartInfoSortByClassifyIdV2(parentClassifyId, 0, 0, updateSortStr)
- } else {
-
- firstEdb, tErr := data_manage.GetFirstChartInfoByClassifyId(parentClassifyId)
- if tErr != nil && tErr.Error() != utils.ErrNoRow() {
- errMsg = "移动失败"
- err = errors.New("获取获取当前父级分类下的排序第一条的分类信息失败,Err:" + tErr.Error())
- return
- }
-
- if firstEdb != nil && firstEdb.Sort == 0 {
- updateSortStr := ` sort + 1 `
- _ = data_manage.UpdateChartInfoSortByClassifyIdV2(parentClassifyId, 0, firstEdb.ChartInfoId-1, updateSortStr)
- _ = data_manage.UpdateChartClassifySortByParentIdAndSource(parentClassifyId, 0, 0, updateSortStr, source)
- }
- }
- chartClassifyInfo.Sort = 0
- chartClassifyInfo.ModifyTime = time.Now()
- updateCol = append(updateCol, "Sort", "ModifyTime")
- }
-
- if len(updateCol) > 0 {
- err = chartClassifyInfo.Update(updateCol)
- if err != nil {
- errMsg = "移动失败"
- err = errors.New("修改失败,Err:" + err.Error())
- return
- }
-
- if oldParentId != parentClassifyId {
- if len(classifyIds) > 0 {
- levelStep := chartClassifyInfo.Level - oldLevel
- err = data_manage.UpdateEdbClassifyChildByParentClassifyId(classifyIds, chartClassifyInfo.RootId, levelStep)
- if err != nil {
- errMsg = "移动失败"
- err = errors.New("更新子分类失败,Err:" + err.Error())
- return
- }
- }
- }
- }
- } else {
- if chartInfo == nil {
- errMsg = "当前图表不存在"
- err = errors.New(errMsg)
- return
- }
-
- if chartInfo.ChartClassifyId != parentClassifyId {
- chartInfo.ChartClassifyId = parentClassifyId
- chartInfo.ModifyTime = time.Now()
- updateCol = append(updateCol, "ChartClassifyId", "ModifyTime")
- }
- if prevSort > 0 {
-
- if nextSort > 0 {
-
-
- if prevSort == nextSort || prevSort == chartInfo.Sort {
-
- updateSortStr := `sort + 2`
-
- if prevClassify != nil {
- _ = data_manage.UpdateChartClassifySortByParentIdAndSource(parentClassifyId, prevClassify.ChartClassifyId, prevClassify.Sort, updateSortStr, source)
- } else {
- _ = data_manage.UpdateChartClassifySortByParentIdAndSource(parentClassifyId, 0, prevSort, updateSortStr, source)
- }
-
- if prevChartInfo != nil {
-
- _ = data_manage.UpdateChartInfoSortByClassifyIdV2(parentClassifyId, prevSort, prevChartInfo.ChartInfoId, updateSortStr)
- } else {
- _ = data_manage.UpdateChartInfoSortByClassifyIdV2(parentClassifyId, prevSort, 0, updateSortStr)
- }
- } else {
-
- if nextSort-prevSort == 1 {
-
- updateSortStr := `sort + 1`
-
- if prevClassify != nil {
- _ = data_manage.UpdateChartClassifySortByParentIdAndSource(parentClassifyId, prevClassify.ChartClassifyId, prevSort, updateSortStr, source)
- } else {
- _ = data_manage.UpdateChartClassifySortByParentIdAndSource(parentClassifyId, 0, prevSort, updateSortStr, source)
- }
-
- if prevChartInfo != nil {
-
- _ = data_manage.UpdateChartInfoSortByClassifyIdV2(parentClassifyId, prevSort, prevChartInfo.ChartInfoId, updateSortStr)
- } else {
- _ = data_manage.UpdateChartInfoSortByClassifyIdV2(parentClassifyId, prevSort, 0, updateSortStr)
- }
- }
- }
- }
- chartInfo.Sort = prevSort + 1
- chartInfo.ModifyTime = time.Now()
- updateCol = append(updateCol, "Sort", "ModifyTime")
- } else if prevClassify == nil && nextClassify == nil && prevChartInfo == nil && nextChartInfo == nil && parentClassifyId > 0 {
-
- var maxSort int
- maxSort, err = GetChartClassifyMaxSort(parentClassifyId, source)
- if err != nil {
- errMsg = "移动失败"
- err = errors.New("查询组内排序信息失败,Err:" + err.Error())
- return
- }
- chartInfo.Sort = maxSort + 1
- chartInfo.ModifyTime = time.Now()
- updateCol = append(updateCol, "Sort", "ModifyTime")
- } else {
-
- firstClassify, tmpErr := data_manage.GetFirstChartClassifyByParentId(parentClassifyId)
- if tmpErr != nil && tmpErr.Error() != utils.ErrNoRow() {
- errMsg = "移动失败"
- err = errors.New("获取获取当前父级分类下的排序第一条的分类信息失败,Err:" + tmpErr.Error())
- return
- }
-
- if firstClassify != nil && firstClassify.Sort == 0 {
- updateSortStr := ` sort + 1 `
- _ = data_manage.UpdateChartClassifySortByParentIdAndSource(parentClassifyId, firstClassify.ChartClassifyId-1, 0, updateSortStr, source)
-
- _ = data_manage.UpdateChartInfoSortByClassifyIdV2(parentClassifyId, 0, 0, updateSortStr)
- } else {
-
- firstEdb, tErr := data_manage.GetFirstChartInfoByClassifyId(parentClassifyId)
- if tErr != nil && tErr.Error() != utils.ErrNoRow() {
- errMsg = "移动失败"
- err = errors.New("获取获取当前父级分类下的排序第一条的分类信息失败,Err:" + tErr.Error())
- return
- }
-
- if firstEdb != nil && firstEdb.Sort == 0 {
- updateSortStr := ` sort + 1 `
- _ = data_manage.UpdateChartInfoSortByClassifyIdV2(parentClassifyId, 0, firstEdb.ChartInfoId-1, updateSortStr)
- _ = data_manage.UpdateChartClassifySortByParentIdAndSource(parentClassifyId, 0, 0, updateSortStr, source)
- }
- }
- chartInfo.Sort = 0
- chartInfo.ModifyTime = time.Now()
- updateCol = append(updateCol, "Sort", "ModifyTime")
- }
-
- if len(updateCol) > 0 {
- err = chartInfo.Update(updateCol)
- if err != nil {
- errMsg = "移动失败"
- err = errors.New("修改失败,Err:" + err.Error())
- return
- }
- }
- }
- return
- }
- func GetChildChartClassifyByClassifyId(targetClassifyId int) (targetList []*data_manage.ChartClassifyIdItems, err error, errMsg string) {
-
- targetClassify, err := data_manage.GetChartClassifyById(targetClassifyId)
- if err != nil {
- if err.Error() == utils.ErrNoRow() {
- errMsg = "当前分类不存在"
- err = errors.New(errMsg)
- return
- }
- errMsg = "获取失败"
- err = errors.New("获取分类信息失败,Err:" + err.Error())
- return
- }
- orderStr := ` order by level asc, sort asc, chart_classify_id asc`
- tmpList, err := data_manage.GetChartClassifyByRootIdLevel(targetClassify.RootId, targetClassify.Source, orderStr)
- if err != nil && err.Error() != utils.ErrNoRow() {
- errMsg = "获取失败"
- err = errors.New("获取数据失败,Err:" + err.Error())
- return
- }
- idMap := make(map[int]struct{})
- if len(tmpList) > 0 {
- for _, v := range tmpList {
- if v.ChartClassifyId == targetClassify.ChartClassifyId {
- idMap[v.ChartClassifyId] = struct{}{}
- }
- }
- for _, v := range tmpList {
- if _, ok := idMap[v.ParentId]; ok {
- idMap[v.ChartClassifyId] = struct{}{}
- }
- }
- for _, v := range tmpList {
- if _, ok := idMap[v.ChartClassifyId]; ok {
- targetItem := new(data_manage.ChartClassifyIdItems)
- targetItem.ChartClassifyId = v.ChartClassifyId
- targetItem.ParentId = v.ParentId
- targetItem.RootId = v.RootId
- targetItem.UniqueCode = v.UniqueCode
- targetItem.Level = v.Level
- targetItem.ChartClassifyName = v.ChartClassifyName
- targetItem.IsJoinPermission = v.IsJoinPermission
- targetList = append(targetList, targetItem)
- }
- }
- }
- return
- }
- func GetChartClassifyMaxSort(parentId, source int) (maxSort int, err error) {
-
- classifyMaxSort, err := data_manage.GetChartClassifyMaxSort(parentId, source)
- if err != nil {
- return
- }
- maxSort = classifyMaxSort
- edbMaxSort, err := data_manage.GetChartInfoMaxSortByClassifyId(parentId)
- if err != nil {
- return
- }
- if maxSort < edbMaxSort {
- maxSort = edbMaxSort
- }
- return
- }
- func GetChartClassifyTreeRecursive(list []*data_manage.ChartClassifyItems, parentId int) []*data_manage.ChartClassifyItems {
- res := make([]*data_manage.ChartClassifyItems, 0)
- for _, v := range list {
- if v.ParentId == parentId {
- v.Children = GetChartClassifyTreeRecursive(list, v.ChartClassifyId)
- res = append(res, v)
- }
- }
- return res
- }
- func GetChartClassifyParentRecursive(list []*data_manage.ChartClassifyItems, classifyId int) []*data_manage.ChartClassifyItems {
- res := make([]*data_manage.ChartClassifyItems, 0)
- for _, v := range list {
- if v.ChartClassifyId == classifyId {
- if v.ParentId > 0 {
- res = GetChartClassifyParentRecursive(list, v.ParentId)
- }
- res = append(res, v)
- }
- }
- return res
- }
- func EditChartClassifyV2(chartClassifyId, praentId, source int, chartClassifyName, lang string) (classifyInfo *data_manage.ChartClassify, err error, errMsg string, isSendEmail bool) {
- isSendEmail = true
- errMsg = "保存失败"
-
- classifyInfo, err = data_manage.GetChartClassifyById(chartClassifyId)
- if err != nil {
- return
- }
- if praentId != classifyInfo.ParentId {
- parentClassifyInfo, e := data_manage.GetChartClassifyById(praentId)
- if e != nil {
- err = e
- return
- }
- if classifyInfo.Level != parentClassifyInfo.Level - 1 {
- err = errors.New("父级分类层级异常")
- }
- }
-
- if classifyInfo.Source != source {
- errMsg = "图表分类异常"
- err = errors.New(fmt.Sprintf("图表分类来源异常,修改来源:%d,分类来源:%d", source, classifyInfo.Source))
- isSendEmail = false
- return
- }
-
- updateCols := make([]string, 0)
- if praentId != classifyInfo.ParentId {
- classifyInfo.ParentId = praentId
- classifyInfo.ModifyTime = time.Now()
- updateCols = append(updateCols, "ParentId")
- }
-
- switch lang {
- case utils.EnLangVersion:
- if classifyInfo.ChartClassifyNameEn != chartClassifyName {
- count, tmpErr := data_manage.GetChartClassifyEnCount(chartClassifyName, classifyInfo.ParentId, source)
- if tmpErr != nil {
- errMsg = "判断名称是否已存在失败"
- err = errors.New("判断名称是否已存在失败,Err:" + tmpErr.Error())
- return
- }
- if count > 0 {
- errMsg = "分类名称已存在,请重新输入"
- err = errors.New(errMsg)
- isSendEmail = false
- return
- }
- classifyInfo.ChartClassifyNameEn = chartClassifyName
- classifyInfo.ModifyTime = time.Now()
- updateCols = append(updateCols, "ChartClassifyNameEn", "ModifyTime")
- }
- default:
- if classifyInfo.ChartClassifyName != chartClassifyName {
- count, tmpErr := data_manage.GetChartClassifyCount(chartClassifyName, classifyInfo.ParentId, source)
- if tmpErr != nil {
- errMsg = "判断名称是否已存在失败"
- err = errors.New("判断名称是否已存在失败,Err:" + tmpErr.Error())
- return
- }
- if count > 0 {
- errMsg = "分类名称已存在,请重新输入"
- err = errors.New(errMsg)
- isSendEmail = false
- return
- }
- classifyInfo.ChartClassifyName = chartClassifyName
- classifyInfo.ModifyTime = time.Now()
- updateCols = append(updateCols, "ChartClassifyName", "ModifyTime")
- }
- }
- if len(updateCols) > 0 {
- err = classifyInfo.Update(updateCols)
- }
- return
- }
- func RemoveNotChartClassifyItemsMakeTree(node *data_manage.ChartClassifyItems, selfChartClassifyIdList []int) (isSelf bool) {
- if utils.InArrayByInt(selfChartClassifyIdList, node.ChartClassifyId) {
- return true
- }
- childrenList := make([]*data_manage.ChartClassifyItems, 0)
- for _, child := range node.Children {
- if tmpIsSelf := RemoveNotChartClassifyItemsMakeTree(child, selfChartClassifyIdList); tmpIsSelf {
- childrenList = append(childrenList, child)
- isSelf = tmpIsSelf
- }
- }
- node.Children = childrenList
- return
- }
- func GetChartClassifyChildrenRecursive(list []*data_manage.ChartClassifyItems, parentId int) []*data_manage.ChartClassifyItems {
- var res []*data_manage.ChartClassifyItems
- for _, v := range list {
- if v.ParentId == parentId {
-
- children := GetChartClassifyChildrenRecursive(list, v.ChartClassifyId)
-
- res = append(res, v)
- res = append(res, children...)
- } else if v.ChartClassifyId == parentId {
-
- res = append(res, v)
- }
- }
- return res
- }
- func GetChartClassifyChildrenRecursiveByParentIds(list []*data_manage.ChartClassifyItems, parentIds []string) []*data_manage.ChartClassifyItems {
- var res []*data_manage.ChartClassifyItems
- for _, v := range list {
- for _, id := range parentIds {
- parentId, _ := strconv.Atoi(id)
- if v.ParentId == parentId || v.ChartClassifyId == parentId {
-
- children := GetChartClassifyChildrenRecursive(list, v.ChartClassifyId)
-
- res = append(res, v)
- res = append(res, children...)
- }
- }
- }
- return res
- }
|