eta_index_lib/controllers/base_from_rzd.go

// @Author gmy 2024/8/13 16:01:00
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"
	"strconv"
	"time"
)

type BaseFromRzdController struct {
	BaseAuthController
}

// Add
// @Title 新增睿姿得指标
// @Description 新增粮油商务网指标
// @router /add [post]
func (this *BaseFromRzdController) Add() {
	br := new(models.BaseResponse).Init()
	var cacheKey string
	defer func() {
		utils.Rc.Delete(cacheKey)
		this.Data["json"] = br
		this.ServeJSON()
	}()
	source := utils.DATA_SOURCE_RZD
	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) {
		utils.Rc.SetNX(cacheKey, 1, 1*time.Minute)
		err = models.AddEdbDataFromRzd(req.EdbCode)
		if err != nil {
			br.Msg = "获取指标信息失败！"
			br.ErrMsg = "获取指标信息失败 AddEdbDataFromSci99，Err:" + err.Error()
			return
		}
		br.Ret = 200
		br.Success = true
		br.Msg = "获取成功"
	} else {
		br.Ret = 501
		br.Success = true
		br.Msg = "系统处理中，请稍后重试"
	}
}

// Refresh
// @Title 刷新粮油商务网指标接口
// @Description 刷新粮油商务网指标接口
// @Success 200 {object} models.RefreshEdbInfoReq
// @router /refresh [post]
func (this *BaseFromRzdController) Refresh() {
	br := new(models.BaseResponse).Init()
	var cacheKey string
	defer func() {
		if br.ErrMsg == "" {
			br.IsSendEmail = false
		}
		_ = utils.Rc.Delete(cacheKey)
		this.Data["json"] = br
		this.ServeJSON()
	}()
	source := utils.DATA_SOURCE_RZD
	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
	}
	dataUpdateTime := time.Now().Format(utils.FormatDateTime)
	utils.Rc.SetNX(cacheKey, 1, 1*time.Minute)
	err = models.RefreshEdbDataFromBloomberg(req.EdbInfoId, req.EdbCode, req.StartDate)
	if err != nil && err.Error() != utils.ErrNoRow() {
		br.Msg = "刷新指标信息失败！"
		br.ErrMsg = "刷新指标信息失败 RefreshEdbDataFromBloomberg，Err:" + err.Error()
		return
	}

	// 更新指标最大最小值
	erDataUpdateDate, err, errMsg := models.UnifiedModifyEdbInfoMaxAndMinInfoDataUpdate(edbInfo, dataUpdateTime)
	if err != nil {
		br.Msg = errMsg
		br.ErrMsg = err.Error()
		return
	}
	// 添加指标刷新成功日志
	if erDataUpdateDate != "" {
		_ = services.AddEdbInfoUpdateLog(edbInfo.EdbInfoId, 1, "", 1, "", 0, 0)
	} else {
		_ = services.AddEdbInfoUpdateLog(edbInfo.EdbInfoId, 1, "", 2, "未刷新到数据", 0, 0)
	}

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

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

// AddRzdClassify
// @Title 新增分类
// @Description 获取分类
// @Success 200 {object} models.BaseFromRzdClassify
// @router /add/rzd/classify [post]
func (this *BaseFromRzdController) AddRzdClassify() {
	br := new(models.BaseResponse).Init()
	var cacheKey string
	defer func() {
		if br.ErrMsg == "" {
			br.IsSendEmail = false
		}
		_ = utils.Rc.Delete(cacheKey)
		this.Data["json"] = br
		this.ServeJSON()
	}()
	var reqData struct {
		ClassifyName string `json:"ClassifyName"`
		ParentId     int    `json:"parentId"`
	}
	err := json.Unmarshal(this.Ctx.Input.RequestBody, &reqData)
	if err != nil {
		br.ErrMsg = "无法解析请求体"
		return
	}
	categoryName := reqData.ClassifyName
	if categoryName == "" {
		br.Msg = "请输入分类！"
		br.ErrMsg = "请输入分类"
		return
	}
	rzdClassify := models.BaseFromRzdClassify{
		ClassifyName: categoryName,
		ParentId:     reqData.ParentId,
		CreateTime:   utils.GetCurrentTime(),
		ModifyTime:   utils.GetCurrentTime(),
	}

	lyClassify, err := models.AddRzdClassify(&rzdClassify)
	if err != nil {
		return
	}

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

// GetRzdClassifyByName
// @Title 获取分类
// @Description 获取分类
// @Success 200 {object} models.BaseFromRzdClassify
// @router /get/rzd/classify/by/name [post]
func (this *BaseFromRzdController) GetRzdClassifyByName() {
	br := new(models.BaseResponse).Init()
	var cacheKey string
	defer func() {
		if br.ErrMsg == "" {
			br.IsSendEmail = false
		}
		_ = utils.Rc.Delete(cacheKey)
		this.Data["json"] = br
		this.ServeJSON()
	}()
	var reqData struct {
		ClassifyName string `json:"ClassifyName"`
	}
	err := json.Unmarshal(this.Ctx.Input.RequestBody, &reqData)
	if err != nil {
		br.ErrMsg = "无法解析请求体"
		return
	}
	categoryName := reqData.ClassifyName
	if categoryName == "" {
		br.Msg = "请输入分类！"
		br.ErrMsg = "请输入分类"
		return
	}

	lyClassify, err := models.GetRzdClassifyByName(categoryName)
	if err != nil {
		return
	}

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

// AddBatchRzdData
// @Title 新增数据源指标数据
// @Description 新增数据源指标数据
// @Success 200 string "处理成功"
// @router /add/batch/rzd/data [post]
func (this *BaseFromRzdController) AddBatchRzdData() {
	br := new(models.BaseResponse).Init()
	var cacheKey string
	defer func() {
		if br.ErrMsg == "" {
			br.IsSendEmail = false
		}
		_ = utils.Rc.Delete(cacheKey)
		this.Data["json"] = br
		this.ServeJSON()
	}()
	var req []models.BaseFromRzdData
	fmt.Println(string(this.Ctx.Input.RequestBody))
	err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
	if err != nil {
		br.Msg = "参数解析异常！"
		br.ErrMsg = "参数解析失败，Err:" + err.Error()
		return
	}

	err = models.AddRzdDataList(req)
	if err != nil {
		br.Msg = "新增指标数据失败！"
		br.ErrMsg = "新增指标数据失败，Err:" + err.Error()
		return
	}

	// 维护start_date，end_date，latest_value字段
	var indexCodes []string
	for _, data := range req {
		indexCodes = append(indexCodes, data.IndexCode)
	}
	mapInfo, err := models.GetRzdDataMaxAndMinDateByIndexCodes(indexCodes)
	if err != nil {
		return
	}
	for indexCode, info := range mapInfo {
		_ = models.UpdateRzdEdbDataByIndexCodes(indexCode, info)
	}

	// 同步新增指标库数据
	// 判断是否存在于指标库
	// 获取指标详情
	/* 调用方对 指标库数据做了维护处理
	var dataList []models.EdbDataRzd
	for _, data := range req {
		edbInfo, err := models.GetEdbInfoByEdbCode(utils.DATA_SOURCE_RZD, data.IndexCode)
		if err != nil {
			br.Msg = "指标不存在！"
			br.ErrMsg = "指标不存在"
			return
		}
		if edbInfo.EdbInfoId == 0 {
			continue
		}
		dataRzd := models.EdbDataRzd{
			EdbInfoId:     data.BaseFromRzdIndexId,
			DataTime:      data.DataTime,
			Value:         data.Value,
			EdbCode:       data.IndexCode,
			CreateTime:    utils.GetCurrentTime(),
			ModifyTime:    utils.GetCurrentTime(),
			DataTimestamp: uint64(time.Now().UnixNano() / int64(time.Millisecond)),
		}
		dataList = append(dataList, dataRzd)
	}
	_ = models.AddRzdEdbDataList(dataList)*/

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

// AddRzdIndex
// @Title 新增指标
// @Description 新增指标
// @Success 200 string "处理成功"
// @router /add/rzd/index [post]
func (this *BaseFromRzdController) AddRzdIndex() {
	br := new(models.BaseResponse).Init()
	var cacheKey string
	defer func() {
		if br.ErrMsg == "" {
			br.IsSendEmail = false
		}
		_ = utils.Rc.Delete(cacheKey)
		this.Data["json"] = br
		this.ServeJSON()
	}()
	var req models.BaseFromRzdIndex
	err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
	if err != nil {
		br.Msg = "参数解析异常！"
		br.ErrMsg = "参数解析失败，Err:" + err.Error()
		return
	}

	indexId, err := models.AddRzdIndex(&req)
	if err != nil {
		return
	}

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

// GetRzdIndexDataByIndexIdAndDataTime
// @Title 根据指标code和时间获取指标数据
// @Description 根据指标code和时间获取指标数据
// @Success 200 {object} models.BaseFromLyData
// @router /get/rzd/index/data/by/code/and/time [post]
func (this *BaseFromRzdController) GetRzdIndexDataByIndexIdAndDataTime() {
	br := new(models.BaseResponse).Init()
	var cacheKey string
	defer func() {
		if br.ErrMsg == "" {
			br.IsSendEmail = false
		}
		_ = utils.Rc.Delete(cacheKey)
		this.Data["json"] = br
		this.ServeJSON()
	}()
	var reqData struct {
		IndexCode string `json:"IndexCode"`
		DataTime  string `json:"DataTime"`
	}
	err := json.Unmarshal(this.Ctx.Input.RequestBody, &reqData)
	if err != nil {
		br.ErrMsg = "无法解析请求体"
		return
	}

	indexCode := reqData.IndexCode
	if indexCode == "" {
		br.Msg = "请输入指标code！"
		br.ErrMsg = "请输入指标code"
		return
	}

	dataTime := reqData.DataTime
	if dataTime == "" {
		br.Msg = "请输入时间！"
		br.ErrMsg = "请输入时间"
		return
	}

	rzdData, err := models.GetRzdDataByIndexCodeAndDataTime(indexCode, dataTime)
	if err != nil {
		return
	}

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

// UpdateRzdDataById
// @Title 更新数据源指标数据
// @Description 更新数据源指标数据
// @Success 200 string "处理成功"
// @router /update/rzd/data/by/id [post]
func (this *BaseFromRzdController) UpdateRzdDataById() {
	br := new(models.BaseResponse).Init()
	var cacheKey string
	defer func() {
		if br.ErrMsg == "" {
			br.IsSendEmail = false
		}
		_ = utils.Rc.Delete(cacheKey)
		this.Data["json"] = br
		this.ServeJSON()
	}()
	var reqData struct {
		Id    int     `json:"Id"`
		Value float64 `json:"Value"`
	}
	err := json.Unmarshal(this.Ctx.Input.RequestBody, &reqData)
	if err != nil {
		br.ErrMsg = "无法解析请求体"
		return
	}

	id := reqData.Id
	if id == 0 {
		br.Msg = "请输入id！"
		br.ErrMsg = "请输入id"
		return
	}

	value := reqData.Value
	if value == 0 {
		br.Msg = "请输入值！"
		br.ErrMsg = "请输入值"
		return
	}

	err = models.UpdateRzdDataById(id, value)
	if err != nil {
		return
	}

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

// GetRzdEdbDataByIndexCodeAndDataTime
// @Title 根据指标编码和精确日期获取指标库数据
// @Description 根据指标编码和精确日期获取指标库数据
// @Success 200 {object} []models.EdbDataRzd
// @router /get/edb/rzd/data/by/code/and/time [post]
func (this *BaseFromRzdController) GetRzdEdbDataByIndexCodeAndDataTime() {
	br := new(models.BaseResponse).Init()
	var cacheKey string
	defer func() {
		if br.ErrMsg == "" {
			br.IsSendEmail = false
		}
		_ = utils.Rc.Delete(cacheKey)
		this.Data["json"] = br
		this.ServeJSON()
	}()
	var reqData struct {
		IndexCode string `json:"IndexCode"`
		DataTime  string `json:"DataTime"`
	}
	err := json.Unmarshal(this.Ctx.Input.RequestBody, &reqData)
	if err != nil {
		br.ErrMsg = "无法解析请求体"
		return
	}

	indexCode := reqData.IndexCode
	if indexCode == "" {
		br.Msg = "请输入指标id！"
		br.ErrMsg = "请输入指标id"
		return
	}

	dataTime := reqData.DataTime
	if dataTime == "" {
		br.Msg = "请输入时间！"
		br.ErrMsg = "请输入时间"
		return
	}

	lyEdbData, err := models.GetLyEdbDataByIndexCodeAndExactDataTime(indexCode, dataTime)
	if err != nil {
		return
	}

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

// GetRzdEdbInfoByIndexCode
// @Title 根据指标编码获取指标库指标
// @Description 根据指标编码获取指标库指标
// @Success 200 {object} []models.EdbDataRzd
// @router /get/rzd/edb/info/by/code [post]
func (this *BaseFromRzdController) GetRzdEdbInfoByIndexCode() {
	br := new(models.BaseResponse).Init()
	var cacheKey string
	defer func() {
		if br.ErrMsg == "" {
			br.IsSendEmail = false
		}
		_ = utils.Rc.Delete(cacheKey)
		this.Data["json"] = br
		this.ServeJSON()
	}()

	var reqData struct {
		IndexCode string `json:"IndexCode"`
		Source    int    `json:"Source"`
	}
	err := json.Unmarshal(this.Ctx.Input.RequestBody, &reqData)
	if err != nil {
		br.ErrMsg = "无法解析请求体"
		return
	}

	indexCode := reqData.IndexCode
	if indexCode == "" {
		br.Msg = "请输入指标id！"
		br.ErrMsg = "请输入指标id"
		return
	}
	source := reqData.Source
	if source == 0 {
		br.Msg = "请输入来源！"
		br.ErrMsg = "请输入来源"
		return
	}

	lyEdbData, err := models.GetEdbInfoByEdbCode(source, indexCode)
	if err != nil {
		return
	}

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

// UpdateRzdEdbDataById
// @Title 更新指标库数据 须根据指标编码和日期更新 仅适合月度数据
// @Description 更新指标库数据 须根据指标编码和日期更新 仅适合月度数据
// @Success 200 string "处理成功"
// @router /update/rzd/edb/data/by/id [post]
func (this *BaseFromRzdController) UpdateRzdEdbDataById() {
	br := new(models.BaseResponse).Init()
	var cacheKey string
	defer func() {
		if br.ErrMsg == "" {
			br.IsSendEmail = false
		}
		_ = utils.Rc.Delete(cacheKey)
		this.Data["json"] = br
		this.ServeJSON()
	}()
	var reqData struct {
		Id    int     `json:"Id"`
		Value float64 `json:"Value"`
	}
	err := json.Unmarshal(this.Ctx.Input.RequestBody, &reqData)
	if err != nil {
		br.ErrMsg = "无法解析请求体"
		return
	}

	id := reqData.Id
	if id == 0 {
		br.Msg = "请输入id！"
		br.ErrMsg = "请输入id"
		return
	}

	value := reqData.Value
	if value == 0 {
		br.Msg = "请输入值！"
		br.ErrMsg = "请输入值"
		return
	}

	err = models.UpdateRzdEdbDataById(id, value)
	if err != nil {
		return
	}

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

// GetRzdIndexByCode
// @Title 查询指标编码是否存在
// @Description 查询指标编码是否存在
// @Success 200 {object} models.BaseFromLyIndex
// @router /get/rzd/index/by/code [post]
func (this *BaseFromRzdController) GetRzdIndexByCode() {
	br := new(models.BaseResponse).Init()
	var cacheKey string
	defer func() {
		if br.ErrMsg == "" {
			br.IsSendEmail = false
		}
		_ = utils.Rc.Delete(cacheKey)
		this.Data["json"] = br
		this.ServeJSON()
	}()
	var reqData struct {
		IndexCode string `json:"IndexCode"`
	}
	err := json.Unmarshal(this.Ctx.Input.RequestBody, &reqData)
	if err != nil {
		br.ErrMsg = "无法解析请求体"
		return
	}

	indexCode := reqData.IndexCode
	if indexCode == "" {
		br.Msg = "请输入指标id！"
		br.ErrMsg = "请输入指标id"
		return
	}

	rzdIndex, err := models.GetRzdIndexByCode(indexCode)
	if err != nil {
		return
	}

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

// AddBatchRzdEdbData
// @Title 批量增加睿咨得指标库数据
// @Description 批量增加睿咨得指标库数据
// @Success 200 string "处理成功"
// @router /add/batch/rzd/edb/data [post]
func (this *BaseFromRzdController) AddBatchRzdEdbData() {
	br := new(models.BaseResponse).Init()
	var cacheKey string
	defer func() {
		if br.ErrMsg == "" {
			br.IsSendEmail = false
		}
		_ = utils.Rc.Delete(cacheKey)
		this.Data["json"] = br
		this.ServeJSON()
	}()
	var req []models.EdbDataRzd
	err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
	if err != nil {
		br.Msg = "参数解析异常！"
		br.ErrMsg = "参数解析失败，Err:" + err.Error()
		return
	}

	err = models.AddRzdEdbDataList(req)
	if err != nil {
		return
	}

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

// UpdateRzdEdbData
// @Title 修改指标数据
// @Description 修改指标数据
// @Success 200 string "处理成功"
// @router /update/rzd/edb/data [post]
func (this *BaseFromRzdController) UpdateRzdEdbData() {
	br := new(models.BaseResponse).Init()
	var cacheKey string
	defer func() {
		if br.ErrMsg == "" {
			br.IsSendEmail = false
		}
		_ = utils.Rc.Delete(cacheKey)
		this.Data["json"] = br
		this.ServeJSON()
	}()
	var req models.BaseFromRzdData
	err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
	if err != nil {
		br.Msg = "参数解析异常！"
		br.ErrMsg = "参数解析失败，Err:" + err.Error()
		return
	}

	err = models.UpdateRzdData(&req)
	if err != nil {
		return
	}

	// 同步更新指标库数据
	edbInfo, err := models.GetEdbInfoByEdbCode(utils.DATA_SOURCE_RZD, req.IndexCode)
	if err != nil {
		br.Msg = "指标不存在！"
		br.ErrMsg = "指标不存在"
		return
	}
	if edbInfo.EdbInfoId > 0 {
		err = models.UpdateRzdEdbDataByIndexCodeAndDataTime(req.BaseFromRzdIndexId, req.DataTime, req.Value)
		if err != nil {
			return
		}
	}

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