eta_api/controllers/rag/abstract.go

package rag

import (
	"encoding/json"
	"eta/eta_api/controllers"
	"eta/eta_api/models"
	"eta/eta_api/models/rag"
	"eta/eta_api/models/rag/request"
	"eta/eta_api/models/rag/response"
	"eta/eta_api/utils"
	"fmt"
	"github.com/rdlucklib/rdluck_tools/paging"
	"strings"
	"time"
)

// AbstractController
// @Description: 摘要管理
type AbstractController struct {
	controllers.BaseAuthController
}

// List
// @Title 列表
// @Description 列表
// @Param   PageSize   query   int  true       "每页数据条数"
// @Param   CurrentIndex   query   int  true       "当前页页码，从1开始"
// @Param   KeyWord   query   string  true       "搜索关键词"
// @Success 200 {object} []*rag.QuestionListListResp
// @router /abstract/list [get]
func (c *AbstractController) List() {
	br := new(models.BaseResponse).Init()
	defer func() {
		c.Data["json"] = br
		c.ServeJSON()
	}()

	sysUser := c.SysUser
	if sysUser == nil {
		br.Msg = "请登录"
		br.ErrMsg = "请登录，SysUser Is Empty"
		return
	}
	pageSize, _ := c.GetInt("PageSize")
	currentIndex, _ := c.GetInt("CurrentIndex")
	keyWord := c.GetString("KeyWord")
	tagId, _ := c.GetInt("TagId")

	var startSize int
	if pageSize <= 0 {
		pageSize = utils.PageSize20
	}
	if currentIndex <= 0 {
		currentIndex = 1
	}
	startSize = utils.StartIndex(currentIndex, pageSize)

	var condition string
	var pars []interface{}

	if keyWord != "" {
		condition = fmt.Sprintf(` AND a.%s like ?`, rag.WechatArticleAbstractColumns.Content)
		pars = append(pars, `%`+keyWord+`%`)
	}

	if tagId > 0 {
		condition = fmt.Sprintf(` AND d.%s = ?`, rag.WechatPlatformTagMappingColumns.TagID)
		pars = append(pars, tagId)
	}

	obj := new(rag.WechatArticleAbstract)
	total, list, err := obj.GetPageListByTagAndPlatformCondition(condition, pars, startSize, pageSize)
	if err != nil {
		br.Msg = "获取失败"
		br.ErrMsg = "获取失败，Err:" + err.Error()
		return
	}

	viewList := obj.WechatArticleAbstractItem(list)

	page := paging.GetPaging(currentIndex, pageSize, total)
	resp := response.AbstractListListResp{
		List:   viewList,
		Paging: page,
	}

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

// 向量库删除
// 摘要库删除
// 批量加入到向量库

// vector_key

// Add
// @Title 新增问题
// @Description 新增问题
// @Param	request	body request.AddQuestionReq true "type json string"
// @Success 200 Ret=200 新增成功
// @router /abstract/add [post]
func (c *AbstractController) Add() {
	br := new(models.BaseResponse).Init()
	defer func() {
		c.Data["json"] = br
		c.ServeJSON()
	}()
	var req request.AddQuestionReq
	err := json.Unmarshal(c.Ctx.Input.RequestBody, &req)
	if err != nil {
		br.Msg = "参数解析异常！"
		br.ErrMsg = "参数解析失败，Err:" + err.Error()
		return
	}
	req.Content = strings.TrimSpace(req.Content)
	if req.Content == "" {
		br.Msg = "请输入问题"
		br.IsSendEmail = false
		return
	}
	item := &rag.Question{
		QuestionId:      0,
		QuestionContent: req.Content,
		Sort:            0,
		ModifyTime:      time.Now(),
		CreateTime:      time.Now(),
	}
	err = item.Create()
	if err != nil {
		br.Msg = "添加失败"
		br.ErrMsg = "添加失败，Err:" + err.Error()
		return
	}

	br.Ret = 200
	br.Success = true
	br.Msg = `添加成功`
}

// Del
// @Title 删除摘要
// @Description 删除摘要
// @Param	request	body request.DelAbstractReq true "type json string"
// @Success 200 Ret=200 新增成功
// @router /abstract/del [post]
func (c *AbstractController) Del() {
	br := new(models.BaseResponse).Init()
	defer func() {
		c.Data["json"] = br
		c.ServeJSON()
	}()
	var req request.DelAbstractReq
	err := json.Unmarshal(c.Ctx.Input.RequestBody, &req)
	if err != nil {
		br.Msg = "参数解析异常！"
		br.ErrMsg = "参数解析失败，Err:" + err.Error()
		return
	}
	if len(req.WechatArticleAbstractIdList) <= 0 {
		br.Msg = "请选择摘要"
		br.IsSendEmail = false
		return
	}

	obj := rag.WechatArticleAbstract{}
	list, err := obj.GetByIdList(req.WechatArticleAbstractIdList)
	if err != nil {
		br.Msg = "修改失败"
		br.ErrMsg = "修改失败，查找问题失败，Err:" + err.Error()
		if utils.IsErrNoRow(err) {
			br.Msg = "问题不存在"
			br.IsSendEmail = false
		}
		return
	}

	if len(list) > 0 {
		err = obj.DelByIdList(req.WechatArticleAbstractIdList)
		if err != nil {
			br.Msg = "删除失败"
			br.ErrMsg = "删除失败，Err:" + err.Error()
			return
		}
	}

	//for _,v:=range list{
	//	// todo 删除向量库
	//}

	br.Ret = 200
	br.Success = true
	br.Msg = `删除成功`
}

// VectorDel
// @Title 删除摘要向量库
// @Description 删除摘要向量库
// @Param	request	body request.EditQuestionReq true "type json string"
// @Success 200 Ret=200 新增成功
// @router /abstract/vector/del [post]
func (c *AbstractController) VectorDel() {
	br := new(models.BaseResponse).Init()
	defer func() {
		c.Data["json"] = br
		c.ServeJSON()
	}()
	var req request.DelAbstractReq
	err := json.Unmarshal(c.Ctx.Input.RequestBody, &req)
	if err != nil {
		br.Msg = "参数解析异常！"
		br.ErrMsg = "参数解析失败，Err:" + err.Error()
		return
	}
	if len(req.WechatArticleAbstractIdList) <= 0 {
		br.Msg = "请选择摘要"
		br.IsSendEmail = false
		return
	}

	obj := rag.WechatArticleAbstract{}
	list, err := obj.GetByIdList(req.WechatArticleAbstractIdList)
	if err != nil {
		br.Msg = "修改失败"
		br.ErrMsg = "修改失败，查找问题失败，Err:" + err.Error()
		if utils.IsErrNoRow(err) {
			br.Msg = "问题不存在"
			br.IsSendEmail = false
		}
		return
	}
	for _, item := range list {
		// todo 删除向量库
		item.VectorKey = ``
		err = item.Update([]string{"vector_key", "modify_time"})
		if err != nil {
			br.Msg = "删除失败"
			br.ErrMsg = "删除失败，Err:" + err.Error()
			return
		}
	}

	br.Ret = 200
	br.Success = true
	br.Msg = `删除成功`
}

// AddVector
// @Title 删除摘要向量库
// @Description 删除摘要向量库
// @Param	request	body request.EditQuestionReq true "type json string"
// @Success 200 Ret=200 新增成功
// @router /abstract/vector/add [post]
func (c *AbstractController) AddVector() {
	br := new(models.BaseResponse).Init()
	defer func() {
		c.Data["json"] = br
		c.ServeJSON()
	}()
	var req request.DelAbstractReq
	err := json.Unmarshal(c.Ctx.Input.RequestBody, &req)
	if err != nil {
		br.Msg = "参数解析异常！"
		br.ErrMsg = "参数解析失败，Err:" + err.Error()
		return
	}
	if len(req.WechatArticleAbstractIdList) <= 0 {
		br.Msg = "请选择摘要"
		br.IsSendEmail = false
		return
	}

	obj := rag.WechatArticleAbstract{}
	list, err := obj.GetByIdList(req.WechatArticleAbstractIdList)
	if err != nil {
		br.Msg = "修改失败"
		br.ErrMsg = "修改失败，查找问题失败，Err:" + err.Error()
		if utils.IsErrNoRow(err) {
			br.Msg = "问题不存在"
			br.IsSendEmail = false
		}
		return
	}
	for _, item := range list {
		// todo 删除向量库
		item.VectorKey = ``
		err = item.Update([]string{"vector_key", "modify_time"})
		if err != nil {
			br.Msg = "删除失败"
			br.ErrMsg = "删除失败，Err:" + err.Error()
			return
		}
	}

	br.Ret = 200
	br.Success = true
	br.Msg = `添加成功`
}