eta_index_lib/controllers/base_from_kpler.go

package controllers

import (
	"encoding/json"
	"eta/eta_index_lib/logic"
	"eta/eta_index_lib/models"
	"eta/eta_index_lib/services"
	"eta/eta_index_lib/utils"
	"fmt"
	"sort"
	"strconv"
	"strings"
	"time"
)

// KplerController Kpler数据
type KplerController struct {
	BaseAuthController
}

// GetData
// @Title 开普勒数据-获取数据
// @Description 开普勒数据-获取数据
// @Success 200 {object} models.ThsHfSearchEdbReq
// @router /edb_data [post]
func (this *KplerController) GetData() {
	br := new(models.BaseResponse).Init()
	defer func() {
		if br.ErrMsg == "" {
			br.IsSendEmail = false
		}
		this.Data["json"] = br
		this.ServeJSON()
	}()
	var params models.KplerSearchEdbReq
	if e := json.Unmarshal(this.Ctx.Input.RequestBody, &params); e != nil {
		br.Msg = "参数解析异常"
		br.ErrMsg = fmt.Sprintf("参数解析失败, %v", e)
		return
	}
	params.Granularity = strings.TrimSpace(params.Granularity)
	if params.Granularity == "" {
		br.Msg = "请选择频度"
		return
	}
	split := strings.TrimSpace(params.Split)
	if split == "" {
		split = "Total"
	}
	unit := strings.TrimSpace(params.Unit)
	if unit == "" {
		unit = "Kbd"
	}
	flowDirection := strings.TrimSpace(params.FlowDirection)
	if flowDirection == "" {
		br.Msg = "请选择流向"
		return
	}
	
	// 根据配置获取指标数据
	indexes, _, _, e := services.GetKplerDataByApi(params, "")
	if e != nil {
		br.Msg = "获取失败"
		br.ErrMsg = fmt.Sprintf("获取开普勒高频指标失败, %v", e)
		return
	}

	for _, index := range indexes {
		//根据日期的值倒序
		sort.Slice(index.IndexData, func(i, j int) bool {
			return index.IndexData[i].DataTime > index.IndexData[j].DataTime
		})
		//只显示10条数据
		if len(index.IndexData) > 10 {
			index.IndexData = index.IndexData[:10]
		}
	}

	br.Data = indexes
	br.Ret = 200
	br.Success = true
	br.Msg = "获取成功"
}
// 批量新增指标
// @Title 批量新增指标
// @Description 批量新增指标
// @Success 200 {object} models.KplerSearchEdbReq
// @router /index_add [post]
func (this *KplerController) IndexAdd() {
	br := new(models.BaseResponse).Init()
	defer func() {
		this.Data["json"] = br
		this.ServeJSON()
	}()
	
	var params models.KplerSearchEdbReq
	if e := json.Unmarshal(this.Ctx.Input.RequestBody, &params); e != nil {
		br.Msg = "参数解析异常"
		br.ErrMsg = fmt.Sprintf("参数解析失败, %v", e)
		return
	}
	params.Granularity = strings.TrimSpace(params.Granularity)
	if params.Granularity == "" {
		br.Msg = "请选择频度"
		return
	}
	split := strings.TrimSpace(params.Split)
	if split == "" {
		split = "Total"
	}
	unit := strings.TrimSpace(params.Unit)
	if unit == "" {
		unit = "Kbd"
	}
	flowDirection := strings.TrimSpace(params.FlowDirection)
	if flowDirection == "" {
		br.Msg = "请选择流向"
		return
	}
	
	// 根据配置获取指标数据
	indexes, apiQueryUrl, terminalInfo, e := services.GetKplerDataByApi(params, "")
	if e != nil {
		br.Msg = "获取失败"
		br.ErrMsg = fmt.Sprintf("获取开普勒高频指标失败, %v", e)
		return
	}

	classifyId := 0
	if params.ProductNames != "" {
		productNames := strings.Split(params.ProductNames, ",")
	    // 获取第一个产品的分类ID
		classifyObj := new(models.BaseFromKplerClassify)
		classifyObj, err := classifyObj.GetByProductName(productNames[0])
		if err != nil {
			br.Msg = "获取分类ID失败"
			br.ErrMsg = fmt.Sprintf("获取分类ID失败, %v", err)
			return
		}
		classifyId = classifyObj.ClassifyId
	}
	
	// 批量新增指标
	err := services.AddKplerIndexByApi(indexes, &params, apiQueryUrl, classifyId, terminalInfo.TerminalCode)
	if err != nil {
		br.Msg = "新增失败"
		br.ErrMsg = fmt.Sprintf("新增失败, %v", err)
		return
	}
	br.Ret = 200
	br.Success = true
	br.Msg = "新增成功"
}

// Add
// @Title 新增Kpler指标接口
// @Description 新增Kpler指标接口
// @Success 200 {object} models.AddEdbInfoReq
// @router /add [post]
func (this *KplerController) Add() {
	br := new(models.BaseResponse).Init()
	var cacheKey string
	defer func() {
		this.Data["json"] = br
		this.ServeJSON()
	}()
	kpler := new(models.BaseFromKpler)
	source := kpler.GetSource()
	var req models.AddEdbInfoReq
	err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
	if err != nil {
		br.Msg = "参数解析异常！"
		br.ErrMsg = "参数解析失败，Err:" + err.Error()
		return
	}
	if req.EdbCode == "" {
		br.Msg = "请输入指标编码！"
		br.ErrMsg = "请输入指标编码，指标编码为空"
		return
	}
	cacheKey = utils.CACHE_EDB_DATA_ADD + strconv.Itoa(source) + "_" + req.EdbCode
	if utils.Rc.IsExist(cacheKey) {
		br.Ret = 501
		br.Success = true
		br.Msg = "系统处理中，请稍后重试"
		return
	}
	utils.Rc.SetNX(cacheKey, 1, 1*time.Minute)
	defer func() {
		utils.Rc.Delete(cacheKey)
	}()
	err = kpler.Add(req.EdbCode)
	if err != nil {
		br.Msg = "获取指标信息失败！"
		br.ErrMsg = "获取指标信息失败 AddEdbDataFromKpler，Err:" + err.Error()
		return
	}
	br.Ret = 200
	br.Success = true
	br.Msg = "获取成功"
	return
}

// Refresh
// @Title 刷新Kpler指标接口
// @Description 刷新Kpler指标接口
// @Success 200 {object} models.RefreshEdbInfoReq
// @router /refresh [post]
func (this *KplerController) Refresh() {
	br := new(models.BaseResponse).Init()
	var cacheKey string
	defer func() {
		this.Data["json"] = br
		this.ServeJSON()
	}()
	kpler := new(models.BaseFromKpler)
	source := kpler.GetSource()
	var req models.RefreshEdbInfoReq
	err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
	if err != nil {
		br.Msg = "参数解析异常！"
		br.ErrMsg = "参数解析失败，Err:" + err.Error()
		return
	}
	if req.EdbCode == "" {
		br.Msg = "请输入指标编码！"
		br.ErrMsg = "请输入指标编码，指标编码为空"
		return
	}
	if req.EdbInfoId < 0 {
		br.Msg = "请输入指标ID！"
		br.ErrMsg = "请输入指标ID"
		return
	}

	// 获取指标详情
	edbInfo, err := models.GetEdbInfoByEdbCode(source, req.EdbCode)
	if err != nil {
		br.Msg = "指标不存在！"
		br.ErrMsg = "指标不存在"
		return
	}
	cacheKey = utils.CACHE_EDB_DATA_REFRESH + strconv.Itoa(source) + "_" + req.EdbCode
	if utils.Rc.IsExist(cacheKey) {
		br.Ret = 501
		br.Success = true
		br.Msg = "系统处理中，请稍后重试"
		return
	}
	utils.Rc.SetNX(cacheKey, 1, 1*time.Minute)
	defer func() {
		utils.Rc.Delete(cacheKey)
	}()
	if req.EdbInfoId <= 0 {
		req.EdbInfoId = edbInfo.EdbInfoId
	}
	err = kpler.Refresh(req.EdbInfoId, req.EdbCode, req.StartDate)
	if err != nil && !utils.IsErrNoRow(err) {
		br.Msg = "刷新指标信息失败！"
		br.ErrMsg = "刷新指标信息失败 RefreshEdbDataFromKpler，Err:" + err.Error()
		return
	}
	// 更新指标最大最小值
	err, errMsg := models.UnifiedModifyEdbInfoMaxAndMinInfo(edbInfo)
	if err != nil {
		br.Msg = errMsg
		br.ErrMsg = err.Error()
		return
	}

	// 更新ES
	go logic.UpdateEs(edbInfo.EdbInfoId)

	br.Ret = 200
	br.Success = true
	br.Msg = "获取成功"
}

// HandleExcelData
// @Title 处理Kpler指标的接口
// @Description 处理Kpler指标的接口
// @Success 200 {object} models.HandleKplerExcelDataReq
// @router /handle/excel_data [post]
func (this *KplerController) HandleExcelData() {
	br := new(models.BaseResponse).Init()
	defer func() {
		this.Data["json"] = br
		this.ServeJSON()
	}()
	var req models.HandleKplerExcelDataReq
	err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
	if err != nil {
		br.Msg = "参数解析异常！"
		br.ErrMsg = "参数解析失败，Err:" + err.Error()
		return
	}

	// 处理excel表数据
	err = services.HandleKplerIndex(&req)
	if err != nil {
		fmt.Println("HandleKplerIndex Err:" + err.Error())
		br.Msg = "处理失败"
		br.ErrMsg = "处理失败,Err:" + err.Error()
		return
	}

	br.Ret = 200
	br.Success = true
	br.Msg = "处理成功"
}