package ai_predict_model import ( "encoding/json" "eta/eta_api/controllers" "eta/eta_api/models" aiPredictModel "eta/eta_api/models/ai_predict_model" "eta/eta_api/models/data_manage" dataSourceModel "eta/eta_api/models/data_source" "eta/eta_api/services" "eta/eta_api/services/data" "eta/eta_api/services/elastic" "eta/eta_api/utils" "fmt" "sort" "strconv" "strings" "time" ) // AiPredictModelClassifyController AI预测模型-分类 type AiPredictModelClassifyController struct { controllers.BaseAuthController } // List // @Title 分类列表 // @Description 分类列表 // @Param ParentId query bool false "父级ID" // @Success 200 {object} data_manage.ChartClassifyListResp // @router /classify/list [get] func (this *AiPredictModelClassifyController) List() { br := new(models.BaseResponse).Init() defer func() { if br.ErrMsg == "" { br.IsSendEmail = false } this.Data["json"] = br this.ServeJSON() }() parentId, _ := this.GetInt("ParentId") resp := new(aiPredictModel.AiPredictModelClassifyListResp) // (懒加载)仅查询直属分类 classifyOb := new(aiPredictModel.AiPredictModelClassify) { cond := fmt.Sprintf(" AND %s = ?", classifyOb.Cols().ParentId) pars := make([]interface{}, 0) pars = append(pars, parentId) list, e := classifyOb.GetItemsByCondition(cond, pars, []string{}, fmt.Sprintf("%s ASC", classifyOb.Cols().Sort)) if e != nil { br.Msg = "获取失败" br.ErrMsg = fmt.Sprintf("获取子分类失败, %v", e) return } for _, v := range list { resp.AllNodes = append(resp.AllNodes, &aiPredictModel.AiPredictModelClassifyListItem{ NodeName: v.ClassifyName, ClassifyId: v.AiPredictModelClassifyId, ClassifyName: v.ClassifyName, ParentId: v.ParentId, Level: v.Level, Sort: v.Sort, UniqueCode: v.UniqueCode, }) } } // 非顶级目录查询指标 indexOb := new(aiPredictModel.AiPredictModelIndex) if parentId > 0 { parentClassify, e := classifyOb.GetItemById(parentId) if e != nil { br.Msg = "父级分类不存在, 请刷新页面" return } cond := fmt.Sprintf(" AND %s = ?", indexOb.Cols().ClassifyId) pars := make([]interface{}, 0) pars = append(pars, parentId) list, e := indexOb.GetItemsByCondition(cond, pars, []string{}, fmt.Sprintf("%s ASC", indexOb.Cols().Sort)) if e != nil { br.Msg = "获取失败" br.ErrMsg = fmt.Sprintf("获取分类下指标失败, %v", e) return } for _, v := range list { resp.AllNodes = append(resp.AllNodes, &aiPredictModel.AiPredictModelClassifyListItem{ NodeType: 1, NodeName: v.IndexName, ClassifyId: parentClassify.AiPredictModelClassifyId, ClassifyName: parentClassify.ClassifyName, IndexId: v.AiPredictModelIndexId, IndexCode: v.IndexCode, IndexName: v.IndexName, ParentId: parentId, Sort: v.Sort, UniqueCode: v.IndexCode, }) } } sort.Slice(resp.AllNodes, func(i, j int) bool { return resp.AllNodes[i].Sort < resp.AllNodes[j].Sort }) br.Data = resp br.Ret = 200 br.Success = true br.Msg = "获取成功" } // Add // @Title 新增分类 // @Description 新增分类 // @Param request body aiPredictModel.AiPredictModelClassifyAddReq true "type json string" // @Success 200 Ret=200 保存成功 // @router /classify/add [post] func (this *AiPredictModelClassifyController) Add() { br := new(models.BaseResponse).Init() defer func() { if br.ErrMsg == "" { br.IsSendEmail = false } this.Data["json"] = br this.ServeJSON() }() sysUser := this.SysUser if sysUser == nil { br.Msg = "请登录" br.ErrMsg = "请登录,SysUser Is Empty" br.Ret = 408 return } var req aiPredictModel.AiPredictModelClassifyAddReq if e := json.Unmarshal(this.Ctx.Input.RequestBody, &req); e != nil { br.Msg = "参数解析异常" br.ErrMsg = fmt.Sprintf("参数解析异常, %v", e) return } req.ClassifyName = strings.TrimSpace(req.ClassifyName) if req.ClassifyName == "" { br.Msg = "请输入分类名称" return } if req.ParentId < 0 { br.Msg = "请选择上级分类" return } if req.Level > 6 { br.Msg = "目前只支持6级目录" return } // 校验分类名称 classifyOb := new(aiPredictModel.AiPredictModelClassify) { cond := fmt.Sprintf(" AND %s = ?", classifyOb.Cols().ParentId) if this.Lang == utils.EnLangVersion { cond += fmt.Sprintf(" AND %s = ?", classifyOb.Cols().ClassifyNameEn) } else { cond += fmt.Sprintf(" AND %s = ?", classifyOb.Cols().ClassifyName) } pars := make([]interface{}, 0) pars = append(pars, req.ParentId, req.ClassifyName) count, e := classifyOb.GetCountByCondition(cond, pars) if e != nil { br.Msg = "操作失败" br.ErrMsg = fmt.Sprintf("获取分类名称重复数失败, %v", e) return } if count > 0 { br.Msg = "分类名称已存在" return } } // 层级路径 var levelPath string var rootId int if req.ParentId > 0 { parent, e := classifyOb.GetItemById(req.ParentId) if e != nil { br.Msg = "上级分类有误" br.ErrMsg = fmt.Sprintf("获取上级分类失败, %v", e) return } levelPath = parent.LevelPath rootId = parent.RootId } sortMax, e := classifyOb.GetSortMax(req.ParentId) if e != nil { br.Msg = "操作失败" br.ErrMsg = fmt.Sprintf("获取分类最大排序失败, %v", e) return } timestamp := strconv.FormatInt(time.Now().UnixNano(), 10) classifyOb.ParentId = req.ParentId classifyOb.ClassifyName = req.ClassifyName classifyOb.ClassifyNameEn = req.ClassifyName classifyOb.Level = req.Level + 1 classifyOb.Sort = sortMax + 1 classifyOb.SysUserId = sysUser.AdminId classifyOb.SysUserRealName = sysUser.RealName classifyOb.UniqueCode = utils.MD5(classifyOb.TableName() + "_" + timestamp) classifyOb.CreateTime = time.Now().Local() classifyOb.ModifyTime = time.Now().Local() if e = classifyOb.Create(); e != nil { br.Msg = "操作失败" br.ErrMsg = fmt.Sprintf("新增分类失败, %v", e) return } if req.ParentId > 0 { // 用英文逗号拼接方便查询 classifyOb.LevelPath = fmt.Sprintf("%s%d,", levelPath, classifyOb.AiPredictModelClassifyId) classifyOb.RootId = rootId } else { classifyOb.LevelPath = fmt.Sprintf("%d,", classifyOb.AiPredictModelClassifyId) classifyOb.RootId = classifyOb.AiPredictModelClassifyId } if e = classifyOb.Update([]string{classifyOb.Cols().LevelPath, classifyOb.Cols().RootId}); e != nil { br.Msg = "操作失败" br.ErrMsg = fmt.Sprintf("更新分类失败, %v", e) return } br.Ret = 200 br.Msg = "操作成功" br.Success = true } // Edit // @Title 修改分类 // @Description 修改分类 // @Param request body aiPredictModel.AiPredictModelClassifyEditReq true "type json string" // @Success 200 Ret=200 修改成功 // @router /classify/edit [post] func (this *AiPredictModelClassifyController) Edit() { br := new(models.BaseResponse).Init() defer func() { if br.ErrMsg == "" { br.IsSendEmail = false } this.Data["json"] = br this.ServeJSON() }() sysUser := this.SysUser if sysUser == nil { br.Msg = "请登录" br.ErrMsg = "请登录,SysUser Is Empty" br.Ret = 408 return } var req aiPredictModel.AiPredictModelClassifyEditReq if e := json.Unmarshal(this.Ctx.Input.RequestBody, &req); e != nil { br.Msg = "参数解析异常" br.ErrMsg = fmt.Sprintf("参数解析异常, %v", e) return } if req.ClassifyId < 0 { br.Msg = "请选择分类" return } req.ClassifyName = strings.TrimSpace(req.ClassifyName) if req.ClassifyName == "" { br.Msg = "请输入分类名称" return } classifyOb := new(aiPredictModel.AiPredictModelClassify) classifyItem, e := classifyOb.GetItemById(req.ClassifyId) if e != nil { if utils.IsErrNoRow(e) { br.Msg = "分类不存在, 请刷新页面" return } br.Msg = "操作失败" br.ErrMsg = fmt.Sprintf("获取分类失败, %v", e) return } // 校验分类名称 { cond := fmt.Sprintf(" AND %s <> ?", classifyOb.Cols().PrimaryId) if this.Lang == utils.EnLangVersion { cond += fmt.Sprintf(" AND %s = ?", classifyOb.Cols().ClassifyNameEn) } else { cond += fmt.Sprintf(" AND %s = ?", classifyOb.Cols().ClassifyName) } pars := make([]interface{}, 0) pars = append(pars, req.ClassifyId, req.ClassifyName) count, e := classifyOb.GetCountByCondition(cond, pars) if e != nil { br.Msg = "操作失败" br.ErrMsg = fmt.Sprintf("获取分类名称重复数失败, %v", e) return } if count > 0 { br.Msg = "分类名称已存在" return } } classifyItem.ClassifyName = req.ClassifyName classifyItem.ClassifyNameEn = req.ClassifyName classifyItem.ModifyTime = time.Now().Local() updateCols := []string{classifyOb.Cols().ClassifyName, classifyOb.Cols().ClassifyNameEn, classifyOb.Cols().ModifyTime} if e = classifyItem.Update(updateCols); e != nil { br.Msg = "操作失败" br.ErrMsg = fmt.Sprintf("更新分类失败, %v", e) return } br.Ret = 200 br.Msg = "操作成功" br.Success = true } // RemoveCheck // @Title 删除校验 // @Description 删除校验 // @Param request body aiPredictModel.AiPredictModelClassifyRemoveReq true "type json string" // @Success 200 Ret=200 检测成功 // @router /classify/remove_check [post] func (this *AiPredictModelClassifyController) RemoveCheck() { br := new(models.BaseResponse).Init() defer func() { if br.ErrMsg == "" { br.IsSendEmail = false } this.Data["json"] = br this.ServeJSON() }() var req aiPredictModel.AiPredictModelClassifyRemoveReq if e := json.Unmarshal(this.Ctx.Input.RequestBody, &req); e != nil { br.Msg = "参数解析异常" br.ErrMsg = fmt.Sprintf("参数解析异常, %v", e) return } if req.ClassifyId < 0 && req.IndexId <= 0 { br.Msg = "参数错误" return } var deleteStatus int var tipsMsg string var childClassifyIds []int // 删除分类 if req.ClassifyId > 0 && req.IndexId == 0 { classifyInfo, err := aiPredictModel.GetAiPredictModelClassifyById(req.ClassifyId) if err != nil && !utils.IsErrNoRow(err) { br.Msg = "删除失败" br.ErrMsg = "获取分类信息失败,Err:" + err.Error() return }else if err != nil && utils.IsErrNoRow(err) { br.Msg = "分类不存在,请刷新页面" return } childClassifyIds, err = aiPredictModel.GetAiPredictModelClassifyChildIdsByLevelPath(classifyInfo.LevelPath) if err != nil { br.Msg = "删除失败" br.ErrMsg = "获取子分类ID失败,Err:" + err.Error() return } count, err := aiPredictModel.GetAiPredictModelIndexCountByClassifyIds(childClassifyIds) if err != nil { br.Msg = "删除失败" br.ErrMsg = "分类下是否含有预测标的失败,Err:" + err.Error() return } if count > 0 { deleteStatus = 1 tipsMsg = "该分类下关联预测标的不可删除" }else { // 判断分类下是否存在框架 frameworkCount, err := aiPredictModel.GetAiPredictModelFrameworkCountByClassifyIds(childClassifyIds) if err != nil { br.Msg = "删除失败" br.ErrMsg = "分类下是否存在框架失败,Err:" + err.Error() return } if frameworkCount > 0 { deleteStatus = 3 tipsMsg = "该分类下关联模型框架不可删除" } } } if deleteStatus != 1 && req.IndexId == 0 { if len(childClassifyIds) > 0 { deleteStatus = 2 tipsMsg = "确认删除当前目录及包含的子目录吗" } } if deleteStatus == 0 { tipsMsg = "可删除,进行删除操作" } resp := new(data_manage.ChartClassifyDeleteCheckResp) resp.DeleteStatus = deleteStatus resp.TipsMsg = tipsMsg br.Ret = 200 br.Msg = "检测成功" br.Success = true br.Data = resp } // Remove // @Title 删除分类/标的 // @Description 删除分类/标的 // @Param request body aiPredictModel.AiPredictModelClassifyRemoveReq true "type json string" // @Success 200 Ret=200 删除成功 // @router /classify/remove [post] func (this *AiPredictModelClassifyController) Remove() { br := new(models.BaseResponse).Init() defer func() { if br.ErrMsg == "" { br.IsSendEmail = false } this.Data["json"] = br this.ServeJSON() }() var req aiPredictModel.AiPredictModelClassifyRemoveReq if e := json.Unmarshal(this.Ctx.Input.RequestBody, &req); e != nil { br.Msg = "参数解析异常" br.ErrMsg = fmt.Sprintf("参数解析异常, %v", e) return } if req.ClassifyId < 0 && req.IndexId <= 0 { br.Msg = "参数错误" return } // 删除分类 if req.ClassifyId > 0 && req.IndexId == 0 { classifyInfo, err := aiPredictModel.GetAiPredictModelClassifyById(req.ClassifyId) if err != nil && !utils.IsErrNoRow(err) { br.Msg = "删除失败" br.ErrMsg = "获取分类信息失败,Err:" + err.Error() return }else if err != nil && utils.IsErrNoRow(err) { br.Msg = "分类不存在,请刷新页面" return } // 查询所有子分类 childClassifyIds, err := aiPredictModel.GetAiPredictModelClassifyChildIdsByLevelPath(classifyInfo.LevelPath) if err != nil && !utils.IsErrNoRow(err) { br.Msg = "删除失败" br.ErrMsg = "判断名称是否已存在失败,Err:" + err.Error() return } indexCount, err := aiPredictModel.GetAiPredictModelIndexCountByClassifyIds(childClassifyIds) if err != nil { br.Msg = "删除失败" br.ErrMsg = "分类下是否存在指标失败,Err:" + err.Error() return } if indexCount > 0 { br.Msg = "该目录下存在模型标的,不可删除" br.IsSendEmail = false return } // 是都存在模型框架 frameworkCount, err := aiPredictModel.GetAiPredictModelFrameworkCountByClassifyIds(childClassifyIds) if err != nil { br.Msg = "删除失败" br.ErrMsg = "分类下是否存在框架失败,Err:" + err.Error() return } if frameworkCount > 0 { br.Msg = "该目录下存在模型框架,不可删除" br.IsSendEmail = false return } // 删除分类和子分类 err = aiPredictModel.RemoveAiPredictModelClassifyByClassifyIds(childClassifyIds) if err != nil { br.Msg = "删除失败" br.ErrMsg = "删除失败,Err:" + err.Error() return } } // 删除标的 if req.IndexId > 0 { indexOb := new(aiPredictModel.AiPredictModelIndex) aiIndex, e := indexOb.GetItemById(req.IndexId) if e != nil { if utils.IsErrNoRow(e) { br.Ret = 200 br.Msg = "删除成功" br.Success = true return } br.Msg = "操作失败" br.ErrMsg = fmt.Sprintf("获取标的信息失败, %v", e) return } if aiIndex != nil && aiIndex.AiPredictModelIndexId <= 0 { br.Ret = 200 br.Msg = "删除成功" br.Success = true return } // 获取指标图表 var chartIds []int chartTypes := []int{utils.CHART_SOURCE_AI_PREDICT_MODEL_DAILY, utils.CHART_SOURCE_AI_PREDICT_MODEL_MONTHLY} for _, v := range chartTypes { ct, e := data_manage.GetAiPredictChartInfoByIndexId(v, req.IndexId) if e != nil && !utils.IsErrNoRow(e) { br.Msg = "操作失败" br.ErrMsg = fmt.Sprintf("获取标的图表信息失败, %v", e) return } if ct != nil && ct.ChartInfoId > 0 { chartIds = append(chartIds, ct.ChartInfoId) } } // 删除标的及数据 if e = indexOb.RemoveIndexAndData(req.IndexId, chartIds); e != nil { br.Msg = "操作失败" br.ErrMsg = fmt.Sprintf("删除标的及数据失败, %v", e) return } // ES标记标的/图表删除 go func() { indexItem := new(dataSourceModel.SearchDataSource) indexItem.PrimaryId = aiIndex.AiPredictModelIndexId indexItem.IndexName = aiIndex.IndexName indexItem.IndexCode = aiIndex.IndexCode indexItem.ClassifyId = aiIndex.ClassifyId indexItem.Source = utils.DATA_SOURCE_AI_PREDICT_MODEL indexItem.SourceName = "AI预测模型" indexItem.IsDeleted = 1 indexItem.CreateTime = utils.TimeTransferString(utils.FormatDateTime, aiIndex.CreateTime) indexItem.ModifyTime = utils.TimeTransferString(utils.FormatDateTime, aiIndex.ModifyTime) docId := fmt.Sprintf("%d-%d", indexItem.Source, indexItem.PrimaryId) if e := elastic.EsAddOrEditDataSourceIndex(utils.EsDataSourceIndexName, docId, indexItem); e != nil { utils.FileLog.Info("AI预测模型-标记删除es失败, %v", e) return } if len(chartIds) == 0 { return } for _, v := range chartIds { data.EsDeleteChartInfo(v) } }() } br.Ret = 200 br.Msg = "删除成功" br.Success = true br.IsAddLog = true } // Move // @Title 移动 // @Description 移动 // @Success 200 {object} aiPredictModel.AiPredictModelClassifyMoveReq // @router /classify/move [post] func (this *AiPredictModelClassifyController) Move() { br := new(models.BaseResponse).Init() defer func() { if br.ErrMsg == "" { br.IsSendEmail = false } this.Data["json"] = br this.ServeJSON() }() sysUser := this.SysUser if sysUser == nil { br.Msg = "请登录" br.ErrMsg = "请登录,SysUser Is Empty" br.Ret = 408 return } var req aiPredictModel.AiPredictModelClassifyMoveReq if e := json.Unmarshal(this.Ctx.Input.RequestBody, &req); e != nil { br.Msg = "参数解析异常" br.ErrMsg = fmt.Sprintf("参数解析异常, %v", e) return } if req.ClassifyId <= 0 && req.ItemId <= 0 { br.Msg = "请选择分类或指标" return } err, errMsg := services.AiPredictModelMoveClassify(req, sysUser) if errMsg != `` { br.Msg = errMsg br.ErrMsg = errMsg if err != nil { br.ErrMsg = err.Error() } else { br.IsSendEmail = false } return } br.Ret = 200 br.Success = true br.Msg = "移动成功" } // List // @Title 分类列表 // @Description 分类列表 // @Param ParentId query bool false "父级ID" // @Success 200 {object} data_manage.ChartClassifyListResp // @router /classify/framework/list [get] func (this *AiPredictModelClassifyController) FrameworkList() { br := new(models.BaseResponse).Init() defer func() { if br.ErrMsg == "" { br.IsSendEmail = false } this.Data["json"] = br this.ServeJSON() }() parentId, _ := this.GetInt("ParentId") resp := new(aiPredictModel.AiPredictModelClassifyFrameworkListResp) // (懒加载)仅查询直属分类 classifyOb := new(aiPredictModel.AiPredictModelClassify) { cond := fmt.Sprintf(" AND %s = ?", classifyOb.Cols().ParentId) pars := make([]interface{}, 0) pars = append(pars, parentId) list, e := classifyOb.GetItemsByCondition(cond, pars, []string{}, fmt.Sprintf("%s ASC", classifyOb.Cols().Sort)) if e != nil { br.Msg = "获取失败" br.ErrMsg = fmt.Sprintf("获取子分类失败, %v", e) return } for _, v := range list { resp.AllNodes = append(resp.AllNodes, &aiPredictModel.AiPredictModelClassifyFrameworkListItem{ NodeName: v.ClassifyName, ClassifyId: v.AiPredictModelClassifyId, ClassifyName: v.ClassifyName, ParentId: v.ParentId, Level: v.Level, Sort: v.Sort, UniqueCode: v.UniqueCode, }) } } // 非顶级目录查询指标 frameworkOb := new(aiPredictModel.AiPredictModelFramework) if parentId > 0 { parentClassify, e := classifyOb.GetItemById(parentId) if e != nil { br.Msg = "父级分类不存在, 请刷新页面" return } cond := fmt.Sprintf(" AND %s = ?", aiPredictModel.AiPredictModelFrameworkColumns.ClassifyId) pars := make([]interface{}, 0) pars = append(pars, parentId) list, e := frameworkOb.GetItemsByCondition(cond, pars, []string{}, fmt.Sprintf("%s ASC", aiPredictModel.AiPredictModelFrameworkColumns.Sort)) if e != nil { br.Msg = "获取失败" br.ErrMsg = fmt.Sprintf("获取分类下指标失败, %v", e) return } for _, v := range list { resp.AllNodes = append(resp.AllNodes, &aiPredictModel.AiPredictModelClassifyFrameworkListItem{ NodeType: 1, NodeName: v.FrameworkName, ClassifyId: parentClassify.AiPredictModelClassifyId, ClassifyName: parentClassify.ClassifyName, AiPredictModelFrameworkId: v.AiPredictModelFrameworkId, FrameworkImg: v.FrameworkImg, ParentId: parentId, Sort: v.Sort, UniqueCode: v.FrameworkCode, }) } } sort.Slice(resp.AllNodes, func(i, j int) bool { return resp.AllNodes[i].Sort < resp.AllNodes[j].Sort }) br.Data = resp br.Ret = 200 br.Success = true br.Msg = "获取成功" } // Tree // @Title 纯分类列表(不包含预测标的和模型框架) // @Description 纯分类列表 // @Success 200 {object} aiPredictModel.AiPredictModelClassifyTreeResp // @router /classify/tree [get] func (this *AiPredictModelClassifyController) TreeList() { br := new(models.BaseResponse).Init() defer func() { if br.ErrMsg == "" { br.IsSendEmail = false } this.Data["json"] = br this.ServeJSON() }() // 获取所有分类 classifyOb := new(aiPredictModel.AiPredictModelClassify) classifies, e := classifyOb.GetItemsByCondition("", make([]interface{}, 0), []string{}, fmt.Sprintf("%s ASC, %s ASC", classifyOb.Cols().Sort, classifyOb.Cols().PrimaryId)) if e != nil { br.Msg = "获取失败" br.ErrMsg = fmt.Sprintf("获取分类列表失败, %v", e) return } // 构建父子关系映射 classifyMap := make(map[int]*aiPredictModel.AiPredictModelClassifyTreeItem) childrenMap := make(map[int][]*aiPredictModel.AiPredictModelClassifyTreeItem) // 第一遍遍历,构建基础节点和映射关系 for _, v := range classifies { item := &aiPredictModel.AiPredictModelClassifyTreeItem{ ClassifyId: v.AiPredictModelClassifyId, ClassifyName: v.ClassifyName, ParentId: v.ParentId, Level: v.Level, Sort: v.Sort, UniqueCode: v.UniqueCode, Children: make([]*aiPredictModel.AiPredictModelClassifyTreeItem, 0), } // 如果是英文版本,使用英文名称 if this.Lang == utils.EnLangVersion { item.ClassifyName = v.ClassifyNameEn } classifyMap[v.AiPredictModelClassifyId] = item childrenMap[v.ParentId] = append(childrenMap[v.ParentId], item) } // 构建树形结构 resp := new(aiPredictModel.AiPredictModelClassifyTreeResp) resp.List = make([]*aiPredictModel.AiPredictModelClassifyTreeItem, 0) // 获取顶级分类(ParentId = 0的节点) if topLevelNodes, exists := childrenMap[0]; exists { resp.List = topLevelNodes // 递归构建子树 for _, node := range topLevelNodes { buildSubTree(node, childrenMap) } } br.Data = resp br.Ret = 200 br.Success = true br.Msg = "获取成功" } // buildSubTree 递归构建子树 func buildSubTree(node *aiPredictModel.AiPredictModelClassifyTreeItem, childrenMap map[int][]*aiPredictModel.AiPredictModelClassifyTreeItem) { if children, exists := childrenMap[node.ClassifyId]; exists { node.Children = children // 递归处理每个子节点 for _, child := range children { buildSubTree(child, childrenMap) } } }