package cygx

import (
	"github.com/beego/beego/v2/client/orm"
	"time"
)

//用户交流反馈表

// 权益服务明细表
type CygxUserFeedback struct {
	UserFeedbackId int       `orm:"column(user_feedback_id);pk";comment:"主键id"`
	Content        string    `comment:"服务内容说明"`
	UserId         int       `comment:"用户ID"`
	Mobile         string    `comment:"手机号"`
	Email          string    `comment:"邮箱"`
	CompanyId      int       `comment:"公司ID"`
	CompanyName    string    `comment:"公司名称"`
	RealName       string    `comment:"用户实际名称"`
	AdminId        int       `comment:"操作人ID"`
	CreateTime     time.Time `comment:"创建时间"`
}

// 权益服务明细表
type CygxUserFeedbackResp struct {
	UserFeedbackId int    `comment:"主键id"`
	Content        string `comment:"服务内容说明"`
	CreateTime     string `comment:"创建时间"`
}

type AddCygxUserFeedbackReq struct {
	Content string `comment:"服务内容说明"`
	UserId  int    `comment:"用户ID"`
}

type CygxUserFeedbackIdReq struct {
	UserFeedbackId int `comment:"UserFeedbackId 主键ID"`
}

// 添加
func AddCygxUserFeedback(item *CygxUserFeedback) (newId int64, err error) {
	o := orm.NewOrmUsingDB("hz_cygx")
	newId, err = o.Insert(item)
	return
}

// 删除数据
func DeleteCygxUserFeedback(userFeedbackId int) (err error) {
	o := orm.NewOrmUsingDB("hz_cygx")
	sql := ` DELETE FROM cygx_user_feedback WHERE user_feedback_id = ?  `
	_, err = o.Raw(sql, userFeedbackId).Exec()
	return
}

// 列表
func GetCygxUserFeedbackListByUserId(userId int) (items []*CygxUserFeedbackResp, err error) {
	o := orm.NewOrmUsingDB("hz_cygx")
	sql := `SELECT * FROM cygx_user_feedback WHERE  user_id = ? `
	sql += `  ORDER BY user_feedback_id DESC  LIMIT  100 `
	_, err = o.Raw(sql, userId).QueryRows(&items)
	return
}

type CygxCygxUserFeedbackResp struct {
	List []*CygxUserFeedbackResp
}