knowledgeBase/rpc/knowledge/internal/service/keywordlistService.go

package service

import (
	. "bp.jydev.jianyu360.cn/SocialPlatform/knowledgeBase/entity"
	"bp.jydev.jianyu360.cn/SocialPlatform/knowledgeBase/rpc/knowledge/knowledge"
	"bp.jydev.jianyu360.cn/SocialPlatform/knowledgeBase/rpc/knowledge/util"
	"encoding/json"
	"fmt"
)

type SKeywordService struct {
	*knowledge.KeywordListReq
}

func NewSKeywordService(in *knowledge.KeywordListReq) *SKeywordService {
	return &SKeywordService{
		in,
	}
}
func (s *SKeywordService) GetKeywordList() (resp *knowledge.KeywordListResp, err error) {
	res := Mysql.SelectBySql(fmt.Sprintf(`SELECT sk.name,sk.state,sk.mold FROM %s sk WHERE sk.state >= 0 AND FIND_IN_SET(1,sk.group)`, util.TableKeyword))
	resp = &knowledge.KeywordListResp{}
	if res != nil && len(*res) > 0 {
		var (
			b, e = json.Marshal(*res)
			list []*knowledge.KeywordList
		)
		if e == nil && len(b) > 0 {
			e = json.Unmarshal(b, &list)
		}
		if e != nil {
			resp.ErrorMsg = e.Error()
			resp.ErrorCode = -1
		} else {
			resp.Data = list
		}
	} else {
		resp.ErrorMsg = fmt.Sprintf("未查到 %s 的数据", util.TableKeyword)
		resp.ErrorCode = -1
	}
	return
}