package daytask

import (
	model "go_server/model/biz_modules/daytask"
	"go_server/model/common/response"
	"go_server/service/base"

	"github.com/gin-gonic/gin"
)

type DtUserService struct {
	base.BizCommonService
}

func (s *DtUserService) Get(c *gin.Context) {
	s.SetDbAlias("daytask")
	base.NewBaseHandler(model.NewDtUser()).Get(c, s.DB())
}

func (s *DtUserService) Find(c *gin.Context) {
	s.SetDbAlias("daytask")
	type request[T any] struct {
		base.ListRequest[T]
		Id        *int64  `form:"id"`
		Uid       *string `form:"uid"`
		Phone     *string `form:"phone"`
		Nickname  *string `form:"nickname"`
		InviteCode *string `form:"inviteCode"`
		ParentId  *int64  `form:"parentId"`
		LevelId   *int64  `form:"levelId"`
		Status    *int8   `form:"status"`
		IsRealName *int8  `form:"isRealName"`
		BeginTime *int64  `form:"beginTime"`
		EndTime   *int64  `form:"endTime"`
	}
	req := new(request[model.DtUser])
	if err := c.BindQuery(req); err != nil {
		response.Resp(c, err.Error())
		return
	}
	db := s.DB()
	if req.Id != nil && *req.Id != 0 {
		db = db.Where("id", req.Id)
	}
	if req.Uid != nil && *req.Uid != "" {
		db = db.Where("uid", req.Uid)
	}
	if req.Phone != nil && *req.Phone != "" {
		db = db.Where("phone LIKE ?", "%"+*req.Phone+"%")
	}
	if req.Nickname != nil && *req.Nickname != "" {
		db = db.Where("nickname LIKE ?", "%"+*req.Nickname+"%")
	}
	if req.InviteCode != nil && *req.InviteCode != "" {
		db = db.Where("invite_code", req.InviteCode)
	}
	if req.ParentId != nil && *req.ParentId != 0 {
		db = db.Where("parent_id", req.ParentId)
	}
	if req.LevelId != nil && *req.LevelId != 0 {
		db = db.Where("level_id", req.LevelId)
	}
	if req.Status != nil {
		db = db.Where("status", req.Status)
	}
	if req.IsRealName != nil {
		db = db.Where("is_real_name", req.IsRealName)
	}
	if req.BeginTime != nil && *req.BeginTime > 0 && req.EndTime != nil && *req.EndTime > 0 {
		db = db.Where("created_at BETWEEN ? AND ?", *req.BeginTime, *req.EndTime)
	}

	colInfo := s.GetColumnCommentFromStruct(model.DtUser{})
	resp, err := base.NewQueryBaseHandler(model.NewDtUser()).List(db, req)
	if err != nil {
		response.Resp(c, err.Error())
		return
	}
	response.Resp(c, map[string]interface{}{
		"cols":   colInfo,
		"list":   resp.List,
		"paging": resp.Paging,
	})
}

func (s *DtUserService) Create(c *gin.Context) {
	s.SetDbAlias("daytask")
	base.NewBaseHandler(model.NewDtUser()).Create(c, s.DB())
}

func (s *DtUserService) Update(c *gin.Context) {
	s.SetDbAlias("daytask")
	base.NewBaseHandler(model.NewDtUser()).UpdateOne(c, s.DB())
}

func (s *DtUserService) Delete(c *gin.Context) {
	s.SetDbAlias("daytask")
	base.NewBaseHandler(model.NewDtUser()).DeleteOne(c, s.DB())
}

func (s *DtUserService) Comment(c *gin.Context) {
	s.SetDbAlias("daytask")
	dbs, err := s.GetColumnComment("daytask", model.NewDtUser().TableName())
	if err != nil {
		response.Resp(c, "获取失败")
		return
	}
	response.Resp(c, gin.H{"dbs": dbs})
}