eta_api/models/classify.go

package models

import (
	sql2 "database/sql"
	"eta/eta_api/global"
	"eta/eta_api/utils"
	"fmt"
	"time"

	"github.com/beego/beego/v2/client/orm"
	"github.com/rdlucklib/rdluck_tools/paging"
)

//type Classify struct {
//	Id                   int       `orm:"column(id);pk"`
//	ClassifyName         string    `description:"分类名称"`
//	Sort                 int       `json:"-"`
//	ParentId             int       `description:"父级分类id"`
//	CreateTime           time.Time `description:"创建时间"`
//	ModifyTime           time.Time `description:"修改时间"`
//	Abstract             string    `description:"栏目简介"`
//	Descript             string    `description:"分享描述"`
//	ReportAuthor         string    `description:"栏目作者"`
//	AuthorDescript       string    `description:"作者简介"`
//	ColumnImgUrl         string    `description:"栏目配图"`
//	HeadImgUrl           string    `description:"头部banner"`
//	AvatarImgUrl         string    `description:"头像"`
//	ReportImgUrl         string    `description:"报告配图"`
//	HomeImgUrl           string    `description:"首页配图"`
//	ClassifyLabel        string    `description:"分类标签"`
//	ShowType             int       `description:"展示类型：1-列表 2-专栏"`
//	HasTeleconference    int       `description:"是否有电话会：0-否 1-是"`
//	VipTitle             string    `description:"研究员头衔"`
//	IsShow               int       `description:"是否在小程序显示：1-显示 0-隐藏"`
//	YbFiccSort           int       `description:"小程序FICC页排序"`
//	YbFiccIcon           string    `description:"小程序FICC页icon"`
//	YbFiccPcIcon         string    `description:"小程序PC端FICC页背景图"`
//	YbIconUrl            string    `description:"小程序已购页icon"`
//	YbBgUrl              string    `description:"小程序已购详情背景图"`
//	YbListImg            string    `description:"小程序研报列表封面图"`
//	YbShareBgImg         string    `description:"小程序研报详情分享背景图"`
//	YbRightBanner        string    `description:"Pc端详情页，右侧，报告合集背景图"`
//	RelateTel            int       `description:"是否在电话会中可选: 0-否; 1-是"`
//	RelateVideo          int       `description:"是否在路演视频中可选: 0-否; 1-是"`
//	IsMassSend           int       `description:"1:群发,0:非群发"`
//	Enabled              int       `description:"是否可用，1可用，0禁用"`
//	Level                int       `description:"层级"`
//	HasChild             int       `description:"是否有子级别，0：下面没有子分类，1：下面有子分类；默认：0"`
//	ReportDetailShowType int       `description:"报告详情的展示类型：1-拼接；2:目录"`
//}

type Classify struct {
	Id                   int       `gorm:"column:id;primaryKey" json:"id"`                                //`orm:"column(id);pk" gorm:"primaryKey" `
	ClassifyName         string    `gorm:"column:classify_name" json:"classify_name"`                     //`description:"分类名称"`
	Sort                 int       `gorm:"column:sort" json:"sort"`                                       //`json:"-"`
	ParentId             int       `gorm:"column:parent_id" json:"parent_id"`                             //`description:"父级分类id"`
	CreateTime           time.Time `gorm:"column:create_time" json:"create_time"`                         //`description:"创建时间"`
	ModifyTime           time.Time `gorm:"column:modify_time" json:"modify_time"`                         //`description:"修改时间"`
	Abstract             string    `gorm:"column:abstract" json:"abstract"`                               //`description:"栏目简介"`
	Descript             string    `gorm:"column:descript" json:"descript"`                               //`description:"分享描述"`
	ReportAuthor         string    `gorm:"column:report_author" json:"report_author"`                     //`description:"栏目作者"`
	AuthorDescript       string    `gorm:"column:author_descript" json:"author_descript"`                 //`description:"作者简介"`
	ColumnImgUrl         string    `gorm:"column:column_img_url" json:"column_img_url"`                   //`description:"栏目配图"`
	HeadImgUrl           string    `gorm:"column:head_img_url" json:"head_img_url"`                       //`description:"头部banner"`
	AvatarImgUrl         string    `gorm:"column:avatar_img_url" json:"avatar_img_url"`                   //`description:"头像"`
	ReportImgUrl         string    `gorm:"column:report_img_url" json:"report_img_url"`                   //`description:"报告配图"`
	HomeImgUrl           string    `gorm:"column:home_img_url" json:"home_img_url"`                       //`description:"首页配图"`
	ClassifyLabel        string    `gorm:"column:classify_label" json:"classify_label"`                   //`description:"分类标签"`
	ShowType             int       `gorm:"column:show_type" json:"show_type"`                             //`description:"展示类型：1-列表 2-专栏"`
	HasTeleconference    int       `gorm:"column:has_teleconference" json:"has_teleconference"`           //`description:"是否有电话会：0-否 1-是"`
	VipTitle             string    `gorm:"column:vip_title" json:"vip_title"`                             //`description:"研究员头衔"`
	IsShow               int       `gorm:"column:is_show" json:"is_show"`                                 //`description:"是否在小程序显示：1-显示 0-隐藏"`
	YbFiccSort           int       `gorm:"column:yb_ficc_sort" json:"yb_ficc_sort"`                       //`description:"小程序FICC页排序"`
	YbFiccIcon           string    `gorm:"column:yb_ficc_icon" json:"yb_ficc_icon"`                       // `description:"小程序FICC页icon"`
	YbFiccPcIcon         string    `gorm:"column:yb_ficc_pc_icon" json:"yb_ficc_pc_icon"`                 //`description:"小程序PC端FICC页背景图"`
	YbIconUrl            string    `gorm:"column:yb_icon_url" json:"yb_icon_url"`                         //`description:"小程序已购页icon"`
	YbBgUrl              string    `gorm:"column:yb_bg_url" json:"yb_bg_url"`                             //`description:"小程序已购详情背景图"`
	YbListImg            string    `gorm:"column:yb_list_img" json:"yb_list_img"`                         //`description:"小程序研报列表封面图"`
	YbShareBgImg         string    `gorm:"column:yb_share_bg_img" json:"yb_share_bg_img"`                 //`description:"小程序研报详情分享背景图"`
	YbRightBanner        string    `gorm:"column:yb_right_banner" json:"yb_right_banner"`                 //`description:"Pc端详情页，右侧，报告合集背景图"`
	RelateTel            int       `gorm:"column:relate_tel" json:"relate_tel"`                           //`description:"是否在电话会中可选: 0-否; 1-是"`
	RelateVideo          int       `gorm:"column:relate_video" json:"relate_video"`                       //`description:"是否在路演视频中可选: 0-否; 1-是"`
	IsMassSend           int       `gorm:"column:is_mass_send" json:"is_mass_send"`                       //`description:"1:群发,0:非群发"`
	Enabled              int       `gorm:"column:enabled" json:"enabled"`                                 //`description:"是否可用，1可用，0禁用"`
	Level                int       `gorm:"column:level" json:"level"`                                     //`description:"层级"`
	HasChild             int       `gorm:"column:has_child" json:"has_child"`                             //`description:"是否有子级别，0：下面没有子分类，1：下面有子分类；默认：0"`
	ReportDetailShowType int       `gorm:"column:report_detail_show_type" json:"report_detail_show_type"` //`description:"报告详情的展示类型：1-拼接；2:目录"`
}

//type ClassifyVO struct {
//	Id            int    `orm:"column(id);pk"`
//	ClassifyName  string `description:"分类名称"`
//	Sort          int    `json:"-"`
//	ParentId      int    `description:"父级分类id"`
//	ClassifyLabel string `description:"分类标签"`
//	Enabled       int    `description:"是否可用，1可用，0禁用"`
//	Level         int    `description:"层级"`
//	Children      *[]ClassifyVO
//}

type ClassifyVO struct {
	Id            int    `gorm:"column:id;primaryKey"`
	ClassifyName  string `description:"分类名称"`
	Sort          int    `json:"-"`
	ParentId      int    `description:"父级分类id"`
	ClassifyLabel string `description:"分类标签"`
	Enabled       int    `description:"是否可用，1可用，0禁用"`
	Level         int    `description:"层级"`
	Children      *[]ClassifyVO
}

type ClassifyAddReq struct {
	ClassifyName          string `description:"分类名称"`
	ParentId              int    `description:"父级分类id，没有父级分类传0"`
	ChartPermissionIdList []int  `description:"权限id数组"`
	/*Abstract              string                 `description:"栏目简介"`
	Descript              string                 `description:"分享描述"`
	ReportAuthor          string                 `description:"栏目作者"`
	AuthorDescript        string                 `description:"作者简介"`
	ColumnImgUrl          string                 `description:"栏目配图"`
	ReportImgUrl          string                 `description:"报告配图"`
	HeadImgUrl            string                 `description:"头部banner"`
	AvatarImgUrl          string                 `description:"头像"`
	HomeImgUrl            string                 `description:"首页配图"`
	ClassifyLabel         string                 `description:"分类标签"`
	ShowType              int                    `description:"展示类型：1-列表 2-专栏"`
	HasTeleconference     int                    `description:"是否有电话会：0-否 1-是"`
	VipTitle              string                 `description:"研究员头衔"`
	Sort                  int                    `description:"后台排序"`
	IsShow                int                    `description:"是否在小程序显示：1-显示 0-隐藏"`
	YbFiccSort            int                    `description:"小程序FICC页排序"`
	YbFiccIcon            string                 `description:"小程序FICC页icon"`
	YbFiccPcIcon          string                 `description:"小程序PC端FICC页背景图"`
	YbIconUrl             string                 `description:"小程序已购页icon"`
	YbBgUrl               string                 `description:"小程序已购详情背景图"`
	YbListImg             string                 `description:"小程序研报列表封面图"`
	YbShareBgImg          string                 `description:"小程序研报详情分享背景图"`
	YbRightBanner         string                 `description:"Pc端详情页，右侧，报告合集背景图"`
	MenuList              []*ClassifyMenuSaveReq `description:"子目录列表"`
	ClassifyMenuId        int                    `description:"二级分类-子目录ID"`
	RelateTel             int                    `description:"是否在电话会中可选: 0-否; 1-是"`
	RelateVideo           int                    `description:"是否在路演视频中可选: 0-否; 1-是"`*/
}

func (c *Classify) Delete(childIds []int) (err error) {
	tx := global.DbMap[utils.DbNameReport].Begin()
	defer func() {
		if err != nil {
			tx.Rollback()
		} else {
			tx.Commit()
		}
	}()
	// 删除自身
	err = tx.Delete(c).Error
	if err != nil {
		return
	}
	// 删除子分类
	if len(childIds) > 0 {
		sql := `DELETE FROM classify WHERE id IN (` + utils.GetOrmInReplace(len(childIds)) + `)`
		err = tx.Exec(sql, childIds).Error
		if err != nil {
			return
		}
	}

	// 检查是否需要更新父类
	if c.ParentId > 0 {
		var count int
		sql := `SELECT COUNT(*) FROM classify WHERE parent_id=? `

		var countNull sql2.NullInt64
		err = tx.Raw(sql, c.ParentId).Scan(&countNull).Error
		if err != nil {
			return
		}
		if countNull.Valid {
			count = int(countNull.Int64)
		}

		if err != nil {
			return
		}
		if count == 0 {
			sql = `UPDATE classify SET has_child=0 WHERE id=? `
			err = tx.Exec(sql, c.ParentId).Error
			if err != nil {
				return
			}
		}
	}

	deleteImgSql := `DELETE FROM banner WHERE classify_id=? `
	err = tx.Exec(deleteImgSql, c.Id).Error
	return
}

func GetClassifyByName(classifyName string, parentId int) (item *Classify, err error) {
	sql := `SELECT * FROM classify WHERE classify_name=? AND parent_id=? `
	err = global.DbMap[utils.DbNameReport].Raw(sql, classifyName, parentId).First(&item).Error
	return
}

func GetClassifyById(classifyId int) (item *Classify, err error) {
	sql := `SELECT * FROM classify WHERE id=? `
	err = global.DbMap[utils.DbNameReport].Raw(sql, classifyId).First(&item).Error
	return
}

// 添加分类
func AddClassify(item *Classify) (err error) {
	err = global.DbMap[utils.DbNameReport].Create(item).Error
	return
}

func GetReportCountByClassifyId(classifyId int) (count int, err error) {
	sql := `SELECT COUNT(1) AS count FROM report WHERE classify_id_second=? `
	var countNull sql2.NullInt64
	err = global.DbMap[utils.DbNameReport].Raw(sql, classifyId).Scan(&countNull).Error
	if err != nil {
		return
	}
	if countNull.Valid {
		count = int(countNull.Int64)
	}
	return
}

func GetClassifySubCountByClassifyId(classifyId int) (count int, err error) {
	sql := `SELECT COUNT(1) as num FROM classify AS a
        INNER JOIN report AS b ON a.id=b.classify_id_second
        WHERE a.parent_id=? `
	var countNull sql2.NullInt64
	err = global.DbMap[utils.DbNameReport].Raw(sql, classifyId).Scan(&countNull).Error
	if err != nil {
		return
	}
	if countNull.Valid {
		count = int(countNull.Int64)
	}
	return
}

func GetClassifySubCountByParentId(classifyId int) (count int, err error) {
	sqlCount := `
	SELECT COUNT(1) as num FROM classify AS a
	WHERE a.parent_id=? `
	var countNull sql2.NullInt64
	err = global.DbMap[utils.DbNameReport].Raw(sqlCount, classifyId).Scan(&countNull).Error
	if err != nil {
		return
	}
	if countNull.Valid {
		count = int(countNull.Int64)
	}
	return
}

// 删除分类
//func DeleteClassify(classifyId int) (err error) {
//	sql := `DELETE FROM classify WHERE id=? `
//	o := orm.NewOrmUsingDB("rddp")
//	_, err = o.Raw(sql, classifyId).Exec()
//	if err != nil {
//		return
//	}
//	deleteImgSql := `DELETE FROM banner WHERE classify_id=? `
//	_, err = o.Raw(deleteImgSql, classifyId).Exec()
//	return
//}

// classifyName, abstract, descript string, parentId, classifyId int
// 修改分类
//func EditClassify(req *EditClassifyReq) (err error) {
//	o := orm.NewOrmUsingDB("rddp")
//	//sql := `UPDATE classify SET classify_name = ?,abstract=?, parent_id= ?,descript=?,report_author=?,author_descript=?,column_img_url=?,head_img_url=?,avatar_img_url=?,report_img_url=?,home_img_url=?,classify_label=?,show_type=?,has_teleconference=?,vip_title=?,modify_time= NOW() WHERE id = ? `
//	//_, err = o.Raw(sql, req.ClassifyName, req.Abstract, req.ParentId, req.Descript, req.ReportAuthor, req.AuthorDescript, req.ColumnImgUrl, req.HeadImgUrl, req.AvatarImgUrl, req.ReportImgUrl, req.HomeImgUrl, req.ClassifyLabel, req.ShowType, req.HasTeleconference, req.VipTitle, req.ClassifyId).Exec()
//	sql := `UPDATE classify SET classify_name = ?,parent_id= ?,modify_time= NOW() WHERE id = ? `
//	_, err = o.Raw(sql, req.ClassifyName, req.ParentId, req.ClassifyId).Exec()
//
//	return
//}

// ParentClassify
// @Description: 获取父级分类
// @author: Roc
// @datetime 2024-06-18 15:03:49
// @return items []*Classify
// @return err error
//func ParentClassify() (items []*Classify, err error) {
//	sql := `SELECT * FROM classify WHERE parent_id=0 order by id desc `
//	o := orm.NewOrmUsingDB("rddp")
//	_, err = o.Raw(sql).QueryRows(&items)
//	return
//}

// 根据id获取分类详情
func FindByIdClassify(classifyId int) (item *Classify, err error) {
	sql := `SELECT * FROM classify WHERE id=? `
	err = global.DbMap[utils.DbNameReport].Raw(sql, classifyId).First(&item).Error
	return
}

//type ClassifyList struct {
//	Id                    int       `orm:"column(id);pk"`
//	ClassifyName          string    `description:"分类名称"`
//	Sort                  int       `description:"排序"`
//	ParentId              int       `description:"父级分类id"`
//	CreateTime            time.Time `description:"创建时间"`
//	ModifyTime            time.Time `description:"修改时间"`
//	Abstract              string    `description:"简介"`
//	Descript              string    `description:"描述"`
//	ClassifyLabel         string    `description:"分类标签"`
//	ShowType              int       `description:"展示类型：1-列表 2-专栏"`
//	HasTeleconference     int       `description:"是否有电话会：0-否 1-是"`
//	IsShow                int       `description:"是否在小程序显示：1-显示 0-隐藏"`
//	YbFiccSort            int       `description:"小程序FICC页排序"`
//	YbFiccIcon            string    `description:"小程序FICC页icon"`
//	YbFiccPcIcon          string    `description:"小程序PC端FICC页背景图"`
//	YbIconUrl             string    `description:"小程序已购页icon"`
//	YbBgUrl               string    `description:"小程序已购详情背景图"`
//	YbListImg             string    `description:"小程序研报列表封面图"`
//	YbShareBgImg          string    `description:"小程序研报详情分享背景图"`
//	YbRightBanner         string    `description:"Pc端详情页，右侧，报告合集背景图"`
//	RelateTel             int       `description:"是否在电话会中可选: 0-否; 1-是"`
//	RelateVideo           int       `description:"是否在路演视频中可选: 0-否; 1-是"`
//	Enabled               int       `description:"是否可用，1可用，0禁用"`
//	Child                 []*ClassifyList
//	ClassifyMenuId        int `description:"二级分类-子目录ID"`
//	ClassifyMenuList      []*ClassifyMenu
//	ChartPermissionIdList []int `description:"绑定的权限ID"`
//	Level                 int   `description:"层级"`
//	HasChild              int   `description:"是否有子级别，0：下面没有子分类，1：下面有子分类；默认：0"`
//	IsEnableDelete        int   `description:"是否允许删除: 0-否; 1-是"`
//}

type ClassifyList struct {
	Id                    int             `gorm:"column:id"`                 //`orm:"column(id);pk" gorm:"primaryKey" `
	ClassifyName          string          `gorm:"column:classify_name"`      //`description:"分类名称"`
	Sort                  int             `gorm:"column:sort"`               //`description:"排序"`
	ParentId              int             `gorm:"column:parent_id"`          //`description:"父级分类id"`
	CreateTime            time.Time       `gorm:"column:create_time"`        //`description:"创建时间"`
	ModifyTime            time.Time       `gorm:"column:modify_time"`        //`description:"修改时间"`
	Abstract              string          `gorm:"column:abstract"`           //`description:"简介"`
	Descript              string          `gorm:"column:descript"`           //`description:"描述"`
	ClassifyLabel         string          `gorm:"column:classify_label"`     //`description:"分类标签"`
	ShowType              int             `gorm:"column:show_type"`          //`description:"展示类型：1-列表 2-专栏"`
	HasTeleconference     int             `gorm:"column:has_teleconference"` //`description:"是否有电话会：0-否 1-是"`
	IsShow                int             `gorm:"column:is_show"`            //`description:"是否在小程序显示：1-显示 0-隐藏"`
	YbFiccSort            int             `gorm:"column:yb_ficc_sort"`       //`description:"小程序FICC页排序"`
	YbFiccIcon            string          `gorm:"column:yb_ficc_icon"`       //`description:"小程序FICC页icon"`
	YbFiccPcIcon          string          `gorm:"column:yb_ficc_pc_icon"`    //`description:"小程序PC端FICC页背景图"`
	YbIconUrl             string          `gorm:"column:yb_icon_url"`        //`description:"小程序已购页icon"`
	YbBgUrl               string          `gorm:"column:yb_bg_url"`          //`description:"小程序已购详情背景图"`
	YbListImg             string          `gorm:"column:yb_list_img"`        //`description:"小程序研报列表封面图"`
	YbShareBgImg          string          `gorm:"column:yb_share_bg_img"`    //`description:"小程序研报详情分享背景图"`
	YbRightBanner         string          `gorm:"column:yb_right_banner"`    //`description:"Pc端详情页，右侧，报告合集背景图"`
	RelateTel             int             `gorm:"column:relate_tel"`         //`description:"是否在电话会中可选: 0-否; 1-是"`
	RelateVideo           int             `gorm:"column:relate_video"`       //`description:"是否在路演视频中可选: 0-否; 1-是"`
	Enabled               int             `gorm:"column:enabled"`            //`description:"是否可用，1可用，0禁用"`
	Level                 int             `gorm:"column:level"`              //`description:"层级"`
	HasChild              int             `gorm:"column:has_child"`          //`description:"是否有子级别，0：下面没有子分类，1：下面有子分类；默认：0"`
	Child                 []*ClassifyList `gorm:"-"`
	ClassifyMenuId        int             `gorm:"-"` //`description:"二级分类-子目录ID"`
	ClassifyMenuList      []*ClassifyMenu `gorm:"-"`
	ChartPermissionIdList []int           `gorm:"-"` //`description:"绑定的权限ID"`
	IsEnableDelete        int             `gorm:"-" description:"是否允许删除: 0-否; 1-是"`
}

type ClassifyItem struct {
	Classify
	ClassifyMenuId        int `description:"二级分类-子目录ID"`
	ClassifyMenuList      []*ClassifyMenu
	ChartPermissionIdList []int `description:"绑定的权限ID"`
	Child                 []*ClassifyItem
}

type ClassifyListResp struct {
	List []*ClassifyList
}

type ClassifyPermissionListResp struct {
	List   []*ClassifyList
	Paging *paging.PagingItem `description:"分页数据"`
}

// 获取分类列表
//func GetClassifyList(keyWord string, enabled int) (items []*ClassifyList, err error) {
//	sql := ``
//	companyTypeSqlStr := ``
//	if enabled == 1 {
//		companyTypeSqlStr += ` AND enabled = 1 `
//	}
//	pars := make([]interface{}, 0)
//	if keyWord != "" {
//		sql = `SELECT * FROM (
//                   SELECT * FROM classify
//                   WHERE parent_id=0 ` + companyTypeSqlStr + `  AND classify_name LIKE ?
//                   UNION
//                   SELECT * FROM classify
//                   WHERE id IN( SELECT parent_id FROM classify
//                   WHERE parent_id>0 ` + companyTypeSqlStr + `  AND classify_name LIKE ? )
//                   )AS t
//                   ORDER BY sort ASC,create_time ASC`
//		pars = utils.GetLikeKeywordPars(pars, keyWord, 2)
//	} else {
//		sql = `SELECT * FROM classify WHERE parent_id=0 ` + companyTypeSqlStr
//
//		sql += ` ORDER BY sort ASC, create_time ASC`
//	}
//	pars = append(pars)
//
//	o := orm.NewOrmUsingDB("rddp")
//	_, err = o.Raw(sql, pars...).QueryRows(&items)
//	return
//}

//func GetClassifyListCount(keyWord, companyType string, hideDayWeek int) (count int, err error) {
//	sqlCount := ``
//
//	companyTypeSqlStr := ``
//	if companyType == "ficc" {
//		companyTypeSqlStr = " AND id != 40 AND parent_id != 40 "
//	} else if companyType == "权益" {
//		companyTypeSqlStr = " AND (id = 40 or parent_id = 40)  "
//	}
//
//	pars := make([]interface{}, 0)
//
//	if keyWord != "" {
//		sqlCount = `SELECT  COUNT(1) AS count FROM (
//               SELECT * FROM classify
//               WHERE parent_id=0 ` + companyTypeSqlStr + `  AND classify_name LIKE ?
//               UNION
//               SELECT * FROM classify
//               WHERE id IN(SELECT parent_id FROM classify
//               WHERE parent_id>0 ` + companyTypeSqlStr + `  AND classify_name LIKE ? )
//               )AS t `
//		pars = utils.GetLikeKeywordPars(pars, keyWord, 2)
//	} else {
//		sqlCount = `SELECT COUNT(1) AS count FROM classify WHERE parent_id=0 ` + companyTypeSqlStr
//		if hideDayWeek == 1 {
//			sqlCount += ` AND classify_name <> '晨报' AND classify_name <> '周报' `
//		}
//	}
//	o := orm.NewOrmUsingDB("rddp")
//	err = o.Raw(sqlCount, pars...).QueryRow(&count)
//	return
//}

type CheckDeleteClassifyReq struct {
	ClassifyId int `description:"分类ID"`
}

type CheckDeleteClassifyResp struct {
	Code int    `description:"编码：0:检测成功，可进行删除,1：分类不存在，2：该分类有关联报告，不允许删除,3:二级分类有关联报告，不允许删除,4:该分类下有关联分类，是否确认全部删除"`
	Msg  string `description:"描述信息"`
}

type DeleteClassifyReq struct {
	ClassifyId int `description:"分类ID"`
}

type EditClassifyReq struct {
	ClassifyId int `description:"分类ID"`
	ClassifyAddReq
}

type FindByIdClassifyReq struct {
	ClassifyId int `description:"分类ID"`
}

func GetClassifyChild(parentId int, keyWord string) (items []*Classify, err error) {
	sql := ``
	pars := make([]interface{}, 0)
	if keyWord != "" {
		sql = `SELECT * FROM classify WHERE classify_name LIKE ? AND parent_id=? ORDER BY create_time ASC `
		pars = append(pars, utils.GetLikeKeyword(keyWord))
	} else {
		sql = `SELECT * FROM classify WHERE parent_id=? ORDER BY create_time ASC `
	}
	pars = append(pars, parentId)
	err = global.DbMap[utils.DbNameReport].Raw(sql, pars...).Find(&items).Error
	return
}

//func GetClassifyChildByParentIds(parentId []int, keyWord string, enabled int) (items []*Classify, err error) {
//	parentIdLen := len(parentId)
//	if parentIdLen == 0 {
//		return
//	}
//	o := orm.NewOrmUsingDB("rddp")
//	sql := ``
//	pars := make([]interface{}, 0)
//	pars = append(pars, parentId)
//	if keyWord != "" {
//		sql = `SELECT * FROM classify WHERE parent_id IN (` + utils.GetOrmInReplace(parentIdLen) + `) AND classify_name LIKE ? `
//		pars = append(pars, utils.GetLikeKeyword(keyWord))
//	} else {
//		sql = `SELECT * FROM classify WHERE parent_id IN (` + utils.GetOrmInReplace(parentIdLen) + `) `
//	}
//
//	if enabled == 1 {
//		sql += ` AND enabled=1 `
//	}
//	sql += ` ORDER BY create_time ASC `
//	_, err = o.Raw(sql, pars...).QueryRows(&items)
//
//	return
//}

// EditClassifyPermissionReq 编辑分类权限请求
type EditClassifyPermissionReq struct {
	ClassifyId            int   `description:"分类ID"`
	ChartPermissionIdList []int `description:"权限id数组"`
}

// GetAllClassify 获取所有分类
func GetAllClassify() (list []*Classify, err error) {
	o := orm.NewOrmUsingDB("rddp")
	sql := ` SELECT * FROM classify `
	_, err = o.Raw(sql).QueryRows(&list)
	return
}

// GetAllClassifyWithDesc 获取所有倒序分类
func GetAllClassifyWithDesc() (list []*Classify, err error) {
	o := orm.NewOrmUsingDB("rddp")
	sql := ` SELECT * FROM classify ORDER BY id DESC `
	_, err = o.Raw(sql).QueryRows(&list)
	return
}

// GetClassifyByKeyword 名称获取分类
//func GetClassifyByKeyword(keyword string) (item Classify, err error) {
//	o := orm.NewOrmUsingDB("rddp")
//	sql := ` SELECT * FROM classify WHERE classify_name = ? LIMIT 1 `
//	err = o.Raw(sql, keyword).QueryRow(&item)
//	return
//}

// UpdateClassify 更新分类
func (classifyInfo *Classify) UpdateClassify(cols []string) (err error) {
	err = global.DbMap[utils.DbNameReport].Select(cols).Updates(classifyInfo).Error
	return
}

// SimpleClassifyList 简版分类列表
type SimpleClassifyList struct {
	Id           int    `description:"分类ID"`
	ClassifyName string `description:"分类名称"`
	ParentId     int    `description:"父级ID"`
	Sort         int    `description:"排序"`
	Child        []*SimpleClassifyList
}

// GetClassifyByCondition 获取分类列表
func GetClassifyByCondition(condition, orderRule string, pars []interface{}) (items []*SimpleClassifyList, err error) {
	sql := `SELECT * FROM classify WHERE 1 = 1 `
	if condition != `` {
		sql += condition
	}
	order := `sort ASC, create_time ASC`
	if orderRule != `` {
		order = orderRule
	}
	sql += ` ORDER BY ` + order
	err = global.DbMap[utils.DbNameReport].Raw(sql, pars...).Find(&items).Error
	return
}

// UpdateChildClassifyRelateSetting 更新子分类关联设置
//func UpdateChildClassifyRelateSetting(parentId, relateTel, relateVideo int) (err error) {
//	o := orm.NewOrmUsingDB("rddp")
//	sql := `UPDATE classify SET relate_tel = ?, relate_video = ? WHERE parent_id = ?`
//	_, err = o.Raw(sql, relateTel, relateVideo, parentId).Exec()
//	return
//}

// RelateTelSecClassifyWithPermissions 关联了电话会的二级分类及权限
type RelateTelSecClassifyWithPermissions struct {
	Id                 int    `description:"分类ID"`
	ClassifyName       string `description:"分类名称"`
	ChartPermissionIds string `description:"权限IDs"`
}

// UpdateClassifySortByParentId 根据父类id更新排序
func UpdateClassifySortByParentId(parentId, permissionId, nowSort int, updateSort string) (err error) {
	sql := ` update classify set sort = ` + updateSort + ` WHERE parent_id=? AND sort > ? `
	if permissionId > 0 {
		sql += ` or ( id > ` + fmt.Sprint(permissionId) + ` and sort = ` + fmt.Sprint(nowSort) + `)`
	}
	err = global.DbMap[utils.DbNameReport].Exec(sql, parentId, nowSort).Error
	return
}

// GetMaxSortByParentId 获取最大的排序值
func (classifyInfo *Classify) GetMaxSortByParentId(parentId int) (maxSort int, err error) {
	sql := `SELECT max(sort) AS sort FROM classify WHERE parent_id = ? `
	if utils.DbDriverName == utils.DbDriverByDm {
		sql = `SELECT COALESCE(MAX(sort), 0) AS sort FROM classify WHERE parent_id = ? `
	}
	var maxNull sql2.NullInt64
	err = global.DbMap[utils.DbNameReport].Raw(sql, parentId).Scan(&maxNull).Error
	if err != nil {
		return
	}
	if maxNull.Valid {
		maxSort = int(maxNull.Int64)
	}
	return
}

// GetMaxSort 获取最大的排序值
func (classifyInfo *Classify) GetMaxSort() (maxSort int, err error) {
	sql := `SELECT max(sort) AS sort FROM classify`
	if utils.DbDriverName == utils.DbDriverByDm {
		sql = `SELECT COALESCE(MAX(sort), 0) AS sort FROM classify`
	}
	var maxNull sql2.NullInt64
	err = global.DbMap[utils.DbNameReport].Raw(sql).Scan(&maxNull).Error
	if err != nil {
		return
	}
	if maxNull.Valid {
		maxSort = int(maxNull.Int64)
	}
	return
}

// GetFirstClassifyByParentId 获取当前父级分类下，且排序数相同 的排序第一条的数据
func (classifyInfo *Classify) GetFirstClassifyByParentId(parentId int) (item *Classify, err error) {
	sql := `SELECT * FROM classify WHERE parent_id = ? order by sort asc, id asc limit 1`
	err = global.DbMap[utils.DbNameReport].Raw(sql, parentId).First(&item).Error
	return
}

type ClassifyMoveReq struct {
	ClassifyId     int `description:"分类ID"`
	PrevClassifyId int `description:"上一个兄弟节点分类id"`
	NextClassifyId int `description:"下一个兄弟节点分类id"`
}

type ClassifySetEnabledReq struct {
	ClassifyId int `description:"分类ID"`
	Enabled    int `description:"是否可用，1可用，0禁用"`
}

func (classifyInfo *Classify) SetEnabled(id, enabled int) (err error) {
	to := global.DbMap[utils.DbNameReport].Begin()
	defer func() {
		if err != nil {
			_ = to.Rollback()
		} else {
			_ = to.Commit()
		}
	}()
	sql := ` UPDATE classify SET enabled =?  WHERE id = ?`
	err = to.Exec(sql, enabled, id).Error
	if err != nil {
		return
	}
	sql = ` UPDATE classify SET enabled =?  WHERE parent_id = ?`
	err = to.Exec(sql, enabled, id).Error
	if err != nil {
		return
	}
	return
}

// GetCountClassifyChildByParentId
// @Description: 获取父级分类下子分类数量
// @author: Roc
// @datetime 2024-06-17 10:58:46
// @param parentId int
// @return total int
// @return err error
func GetCountClassifyChildByParentId(parentId int) (total int, err error) {
	sql := `SELECT count(1) AS total FROM classify WHERE parent_id = ? `
	var countNull sql2.NullInt64
	err = global.DbMap[utils.DbNameReport].Raw(sql, parentId).Scan(&countNull).Error
	if err != nil {
		return
	}
	if countNull.Valid {
		total = int(countNull.Int64)
	}
	return
}

// GetClassifyListByKeyword
// @Description: 获取分类列表
// @author: Roc
// @datetime 2024-06-19 09:49:33
// @param keyWord string
// @param enabled int
// @return items []*ClassifyList
// @return err error
func GetClassifyListByKeyword(keyWord string, enabled int) (items []*ClassifyList, err error) {
	sql := ``
	pars := make([]interface{}, 0)

	sql = `SELECT * FROM classify WHERE 1=1 `
	if enabled == 1 {
		sql += ` AND enabled = 1 `
	}

	if keyWord != `` {
		sql += ` AND classify_name LIKE ? `
		pars = utils.GetLikeKeywordPars(pars, keyWord, 1)
	}
	sql += ` ORDER BY sort ASC, create_time ASC`

	err = global.DbMap[utils.DbNameReport].Raw(sql, pars...).Find(&items).Error
	return
}

// GetClassifyListByParentIdList
// @Description: 获取分类列表
// @author: Roc
// @datetime 2024-06-19 09:49:33
// @param keyWord string
// @param enabled int
// @return items []*ClassifyList
// @return err error
func GetClassifyListByParentIdList(parentClassifyIdList []int) (items []*ClassifyList, err error) {
	num := len(parentClassifyIdList)
	if num <= 0 {
		return
	}
	sql := `SELECT * FROM classify WHERE id in (` + utils.GetOrmInReplace(num) + `) ORDER BY sort ASC, create_time ASC`

	err = global.DbMap[utils.DbNameReport].Raw(sql, parentClassifyIdList).Find(&items).Error
	return
}

// GetClassifyListByIdList
// @Description: 根据指标ID列表，获取分类列表
// @author: Roc
// @datetime 2024-06-27 15:23:57
// @param classifyIdList []int
// @return items []*Classify
// @return err error
func GetClassifyListByIdList(classifyIdList []int) (items []*Classify, err error) {
	num := len(classifyIdList)
	if num <= 0 {
		return
	}
	sql := `SELECT * FROM classify WHERE id IN (` + utils.GetOrmInReplace(num) + `) `
	err = global.DbMap[utils.DbNameReport].Raw(sql, classifyIdList).Find(&items).Error
	return
}

// GetClassifyListByParentId 查询父分类下所有的子分类
func GetClassifyListByParentId(parentId int) (items []*Classify, err error) {
	sql := `SELECT * FROM classify WHERE parent_id = ? and enabled = 1`
	err = global.DbMap[utils.DbNameReport].Raw(sql, parentId).Find(&items).Error
	return items, err
}