golang微信小程序
package keyrepaly
import (
"github.com/gin-gonic/gin"
"net/http"
"golangWeixin/model"
"golangWeixin/common"
"strconv"
"github.com/gin-gonic/gin/binding"
"fmt"
"golangWeixin/constant"
"github.com/jinzhu/gorm"
"golangWeixin/utils"
)
type KeyReplyVo struct {
ID int `json:"id"`
Key string `json:"key"`
MsgType int `json:"msg_type"` // text,image,voice, --video,music,news
Value string `json:"value"`
KeyReplyNewsVos []KeyReplyNewsVo `json:"key_reply_news_vos,omitempty"`
KeyReplyMusicVo KeyReplyMusicVo `json:"key_reply_music_vo,omitempty"`
KeyReplyVedioVo KeyReplyVedioVo `json:"key_reply_vedio_vo,omitempty"`
//HttpMethod string `json:"method"`
}
//music
type KeyReplyMusicVo struct {
ID int `json:"id"`
Title string `json:"title,omitempty"`
Description string `json:"description,omitempty"`
MusicUrl string `json:"music_url,omitempty"`
HqMusicUrl string `json:"hq_music_url,omitempty"`
ThumbMediaId string `json:"thumb_media_id,omitempty"`
ReplyId int `json:"reply_id,omitempty"`
}
//news
type KeyReplyNewsVo struct {
ID int `json:"id"`
Title string `json:"title"`
Description string `json:"description"`
PicUrl string `json:"pic_url"`
Url string `json:"url"`
ReplyId int `json:"reply_id"`
}
//vedio
type KeyReplyVedioVo struct {
ID int `json:"id"`
Title string `json:"title,omitempty"`
Description string `json:"description,omitempty"`
MediaId string `json:"media_id,omitempty"`
ReplyId int `json:"reply_id,omitempty"`
}
//根据关键字和page，limit，进行分页模糊查找
func KeyRpeyls(c *gin.Context) {
queryString, _ := c.GetQuery("name")
pageQ := c.DefaultQuery("page", "0")
limitQ := c.DefaultQuery("limit", "20")
page, _ := strconv.Atoi(pageQ)
limit, _ := strconv.Atoi(limitQ)
reply, err := model.FindAllKeysReplyPage(queryString, page, limit)
if err != nil {
common.SendErrJSON( "查找全部用户出错", c)
return
}
// entity_model
var keyReplys []KeyReplyVo
for _, entity := range *reply {
var keyReply KeyReplyVo
if err := utils.TransformToOther(&entity, &keyReply); err != nil {
common.SendErrJSON( "序列化出错", c)
return
}
//添加相应的子类
switch entity.MsgType {
case model.KeywordsReplyMsgVideo:
var keyReplyVideo KeyReplyVedioVo
//查找数据
video, err := model.FindKeywordsReplyVideoSubByReplyId(true, entity.ID)
if err != nil {
common.SendErrJSON( "查找子类video出错", c)
return
}
if err := utils.TransformToOther(&video, &keyReplyVideo); err != nil {
common.SendErrJSON( "序列化出错", c)
return
}
//复值
keyReply.KeyReplyVedioVo = keyReplyVideo
break
case model.KeywordsReplyMsgMusic:
var keyReplyMusic KeyReplyMusicVo
//查找数据
music, err := model.FindKeywordsReplyMusicSubByReplyId(true, entity.ID)
if err != nil {
common.SendErrJSON( "查找子类Music出错", c)
return
}
if err := utils.TransformToOther(&music, &keyReplyMusic); err != nil {
common.SendErrJSON( "序列化出错", c)
return
}
//复值
keyReply.KeyReplyMusicVo = keyReplyMusic
break
case model.KeywordsReplyMsgNews:
var keyReplyNews []KeyReplyNewsVo
//查找数据
news, err := model.FindKeywordsReplyNewsSubByReplyId(true, entity.ID)
if err != nil {
common.SendErrJSON( "查找子类New出错", c)
return
}
if err := utils.TransformToOther(&news, &keyReplyNews); err != nil {
common.SendErrJSON( "序列化出错", c)
return
}
//复值
keyReply.KeyReplyNewsVos = keyReplyNews
break
}
//添加相应的切片
keyReplys = append(keyReplys, keyReply)
}
c.JSON(http.StatusOK, gin.H{
"errNo": common.ErrorCode.SUCCESS,
"msg": "success",
"data": gin.H{
"keyplies": keyReplys,
"total": len(keyReplys),
},
})
}
func Test(c *gin.Context) {
//queryString, _ := c.GetQuery("name")
//var table model.KeywordsReply
//model.FindOne(&table,true,"1")
//
//c.JSON(http.StatusOK, gin.H{
// "errNo": common.ErrorCode.SUCCESS,
// "msg": "success",
// "data": table,
//})
c.JSON(http.StatusOK, gin.H{
"errNo": common.ErrorCode.SUCCESS,
"msg": "success",
"data": "success",
})
}
//该接口新增关键字
func KeyReplyAddAndUpdate(c *gin.Context) {
// 使用gorm的事务管理框架
tx := common.DB.Begin()
SendErrJSON := common.SendErrJSON
var keyReplyVo KeyReplyVo
if err := c.ShouldBindWith(&keyReplyVo, binding.JSON); err != nil {
fmt.Println(err.Error())
SendErrJSON( "解析参数有误", c)
return
}
// 新增更新的时候，重复的关键字判断
if keyReplyVo.ID != -1 {
if _, err := model.FindKeyWordReplyByKey(keyReplyVo.Key); err != nil && err != gorm.ErrRecordNotFound {
SendErrJSON( "重复的关键字", c)
return
}
}
//新增有4类
//添加主表
var key *model.KeywordsReply
if err := utils.TransformToOther(&keyReplyVo, &key); err != nil {
common.SendErrJSON( "序列化出错", c)
return
}
if keyReplyVo.ID > 0 {
err := key.Update(tx, model.SystemUser)
if err != nil {
common.SendErrJSON( "更新失败")
}
} else if keyReplyVo.ID == 0 {
err := key.Insert(tx, model.SystemUser)
if err != nil {
common.SendErrJSON( "保存失败")
}
} else if keyReplyVo.ID == -1 {
err := key.Delete(tx, model.SystemUser)
if err != nil {
common.SendErrJSON( "删除失败")
}
}
//得到原始的值
oldKey, err := model.FindKeyWordReplyByOne(true, keyReplyVo.ID)
if err != nil && err == gorm.ErrRecordNotFound {
common.SendErrJSON("查找失败")
return
}
//说明更换类型了,删除对应的子表记录,否则说明没有更换类型
if keyReplyVo.MsgType != oldKey.MsgType {
switch oldKey.MsgType {
case model.KeywordsReplyMsgVideo:
var keyReplayVideo model.KeywordsReplyVideoSub
keyReplayVideo.ReplyId=key.ID
keyReplayVideo.Delete(tx, model.SystemUser)
break
case model.KeywordsReplyMsgMusic:
var keyReplyMusic model.KeywordsReplyMusicSub
if err := utils.TransformToOther(&keyReplyVo.KeyReplyMusicVo, &keyReplyMusic); err != nil {
common.SendErrJSON( "序列化出错", c)
return
}
keyReplyMusic.Delete(tx, model.SystemUser)
break
case model.KeywordsReplyMsgNews:
var keyReplayVideos []model.KeywordsReplyNewsSub
if err := utils.TransformToOther(&keyReplyVo.KeyReplyNewsVos, &keyReplayVideos); err != nil {
common.SendErrJSON( "序列化出错", c)
return
}
for _, value := range keyReplayVideos {
value.Delete(tx, model.SystemUser)
}
break
}
//子表为新增
keyReplyVo.ID = constant.Zero
}
//更新新增对应的子表
switch keyReplyVo.MsgType {
case model.KeywordsReplyMsgVideo:
var keyReplayVideo model.KeywordsReplyVideoSub
if err := utils.TransformToOther(&keyReplyVo.KeyReplyMusicVo, &keyReplayVideo); err != nil {
common.SendErrJSON( "序列化出错", c)
return
}
if keyReplyVo.ID > constant.Zero {
err := keyReplayVideo.Update(tx, model.SystemUser)
if err != nil {
common.SendErrJSON( "更新Video失败")
}
} else if keyReplyVo.ID == constant.Zero {
keyReplayVideo.ID = key.ID
err := keyReplayVideo.Insert(tx, model.SystemUser)
if err != nil {
common.SendErrJSON("新增Video失败")
}
} else if keyReplyVo.ID < constant.NegativeOne {
err := keyReplayVideo.Delete(tx, model.SystemUser)
if err != nil {
common.SendErrJSON( "删除Video失败")
}
}
break
case model.KeywordsReplyMsgMusic:
var keyReplyMusic model.KeywordsReplyMusicSub
if err := utils.TransformToOther(&keyReplyVo.KeyReplyMusicVo, &keyReplyMusic); err != nil {
common.SendErrJSON( "序列化出错", c)
return
}
if keyReplyVo.ID > constant.Zero {
err := keyReplyMusic.Update(tx, model.SystemUser)
if err != nil {
common.SendErrJSON( "更新Vi