knowledgeinfologic.go 1.4 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243
  1. package logic
  2. import (
  3. quitl "app.yhyue.com/moapp/jybase/common"
  4. "context"
  5. "github.com/zeromicro/go-zero/core/logx"
  6. . "knowledgeBase/rpc/knowledge/init"
  7. "knowledgeBase/rpc/knowledge/internal/svc"
  8. "knowledgeBase/rpc/knowledge/knowledgeclient"
  9. "knowledgeBase/rpc/knowledge/util"
  10. )
  11. type KnowledgeInfoLogic struct {
  12. ctx context.Context
  13. svcCtx *svc.ServiceContext
  14. logx.Logger
  15. }
  16. func NewKnowledgeInfoLogic(ctx context.Context, svcCtx *svc.ServiceContext) *KnowledgeInfoLogic {
  17. return &KnowledgeInfoLogic{
  18. ctx: ctx,
  19. svcCtx: svcCtx,
  20. Logger: logx.WithContext(ctx),
  21. }
  22. }
  23. // 知识详情
  24. func (l *KnowledgeInfoLogic) KnowledgeInfo(in *knowledgeclient.KnowledgeEntity) (*knowledgeclient.InfoResponse, error) {
  25. // todo: add your logic here and delete this line
  26. //答案问题详情
  27. result := &knowledgeclient.InfoResponse{}
  28. sql := "SELECT b.content as answer ,c.content as question ,b.id FROM ? b LEFT JOIN ? c ON b.id = c.answer_id WHERE b.`status` =1 "
  29. datalist := Mysql.SelectBySql(sql, util.ANSWER, util.QUESTION, in.AnswerId)
  30. if datalist != nil && *datalist != nil && len(*datalist) > 0 {
  31. knowledge := knowledgeclient.KnowledgeEntity{}
  32. knowledge.Answer = quitl.ObjToString((*datalist)[0]["answer"])
  33. knowledge.Question = quitl.ObjToString((*datalist)[0]["question"])
  34. knowledge.AnswerId = quitl.Int64All((*datalist)[0]["id"])
  35. result.Data = &knowledge
  36. }
  37. return &knowledgeclient.InfoResponse{}, nil
  38. }