hz_crm_api/models/help_doc/classify.go

package help_doc

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

type HelpDocClassify struct {
	ClassifyId      int       `orm:"column(classify_id);pk"`
	ClassifyName    string    `description:"分类名称"`
	ParentId        int       `description:"父级id"`
	CreateTime      time.Time `description:"创建时间"`
	ModifyTime      time.Time `description:"修改时间"`
	SysUserId       int       `description:"创建人id"`
	SysUserRealName string    `description:"创建人姓名"`
	Level           int       `description:"层级"`
	Sort            int       `description:"排序字段，越小越靠前，默认值：10"`
}

func AddHelpDocClassify(item *HelpDocClassify) (lastId int64, err error) {
	o := orm.NewOrm()
	lastId, err = o.Insert(item)
	return
}

type AddHelpDocClassifyReq struct {
	HelpDocClassifyName string `description:"分类名称"`
	ParentId            int    `description:"父级id,第一级传0"`
	Level               int    `description:"层级,第一级传0，其余传上一级的层级"`
}

func GetHelpDocClassifyCount(HelpDocClassifyName string, parentId int) (count int, err error) {
	o := orm.NewOrm()
	sql := `SELECT COUNT(1) AS count FROM help_doc_classify WHERE parent_id=? AND classify_name=? `
	err = o.Raw(sql, parentId, HelpDocClassifyName).QueryRow(&count)
	return
}

type EditHelpDocClassifyReq struct {
	HelpDocClassifyName string `description:"分类名称"`
	HelpDocClassifyId   int    `description:"分类id"`
	ParentId            int    `description:"父级id"`
}

func GetHelpDocClassifyById(classifyId int) (item *HelpDocClassify, err error) {
	o := orm.NewOrm()
	sql := `SELECT * FROM help_doc_classify WHERE classify_id=? `
	err = o.Raw(sql, classifyId).QueryRow(&item)
	return
}

func GetHelpDocClassifyCountById(classifyId int) (count int, err error) {
	o := orm.NewOrm()
	sql := `SELECT count(1) AS count FROM help_doc_classify WHERE classify_id=? `
	err = o.Raw(sql, classifyId).QueryRow(&count)
	return
}

func EditHelpDocClassify(classifyId, parentId int, HelpDocClassifyName string) (err error) {
	o := orm.NewOrm()
	sql := `UPDATE help_doc_classify SET classify_name=?,parent_id = ?, modify_time=NOW() WHERE classify_id=? `
	_, err = o.Raw(sql, HelpDocClassifyName, parentId, classifyId).Exec()
	return
}

func GetChartInfoCountByClassifyId(classifyId int) (count int, err error) {
	o := orm.NewOrm()
	sql := ` SELECT COUNT(1) AS count FROM chart_info AS a
				WHERE a.classify_id IN(
				SELECT t.classify_id FROM 
				(
				SELECT rd.*
				FROM (SELECT * FROM help_doc_classify WHERE parent_id IS NOT NULL) rd,
					 (SELECT @pid := ?) pd 
				WHERE FIND_IN_SET(parent_id, @pid) > 0 
				  AND @pid := CONCAT(@pid, ',', classify_id) 
				UNION SELECT * FROM help_doc_classify WHERE classify_id = @pid
				)AS t
				) `
	err = o.Raw(sql, classifyId).QueryRow(&count)
	return
}

// GetHelpDocClassifyByParentId
func GetHelpDocClassifyByParentId(parentId int, keyWord string) (items []*HelpDocClassifyItems, err error) {
	o := orm.NewOrm()
	sql := ``
	if keyWord != ""{
		sql = ` SELECT * FROM help_doc_classify WHERE parent_id=? AND (classify_name LIKE '%` + keyWord + `%' ) order by sort asc,classify_id asc`
	} else {
		sql = ` SELECT * FROM help_doc_classify WHERE parent_id=? order by sort asc,classify_id asc`
	}
	_, err = o.Raw(sql, parentId).QueryRows(&items)
	return
}

// GetHelpDocClassifyAll
func GetHelpDocClassifyAll(keyWord string) (items []*HelpDocClassifyItems, err error) {
	o := orm.NewOrm()
	sql := ``
	if keyWord != ""{
		sql = ` SELECT * FROM help_doc_classify WHERE parent_id<>0 AND (classify_name LIKE '%` + keyWord + `%' ) order by sort asc,classify_id asc`
	} else {
		sql = ` SELECT * FROM help_doc_classify WHERE parent_id<>0 order by sort asc,classify_id asc`
	}
	_, err = o.Raw(sql).QueryRows(&items)
	return
}

type HelpDocClassifyItems struct {
	ClassifyId     int `description:"分类id"`
	ClassifyName   string
	ParentId              int
	Level                 int    `description:"层级"`
	Sort                  int    `description:"排序字段，越小越靠前，默认值：10"`
	SourceName            string `description:"来源名称"`
	SysUserId             int    `description:"创建人id"`
	SysUserRealName       string `description:"创建人姓名"`
	Children              []*HelpDocClassifyItems
}

type HelpDocClassifyListResp struct {
	AllNodes []*HelpDocClassifyItems
}

type HelpDocClassifyDeleteCheckResp struct {
	DeleteStatus int    `description:"检测状态:0:默认值，如果为0，继续走其他校验，1:该分类下关联不可删除,2:确认删除当前目录及包含的子目录吗"`
	TipsMsg      string `description:"提示信息"`
}

type HelpDocClassifyDeleteCheckReq struct {
	HelpDocClassifyId int `description:"分类id"`
	ChartInfoId       int `description:"指标id"`
}

func GetHelpDocClassifyByCondition(condition string, pars []interface{}) (item *HelpDocClassify, err error) {
	o := orm.NewOrm()
	sql := ` SELECT * FROM help_doc_classify WHERE 1=1 `
	if condition != "" {
		sql += condition
	}
	err = o.Raw(sql, pars).QueryRow(&item)
	return
}

// MoveHelpDocClassifyReq 移动分类请求参数
type MoveHelpDocClassifyReq struct {
	ClassifyId       int `description:"分类id"`
	ParentClassifyId int `description:"父级分类id"`
	PrevClassifyId   int `description:"上一个兄弟节点分类id"`
	NextClassifyId   int `description:"下一个兄弟节点分类id"`
}

// GetFirstHelpDocClassifyByParentId 获取当前父级分类下的排序第一条的数据
func GetFirstHelpDocClassifyByParentId(parentId int) (item *HelpDocClassify, err error) {
	o := orm.NewOrm()
	sql := ` SELECT * FROM help_doc_classify WHERE parent_id=? order by sort asc,classify_id asc limit 1`
	err = o.Raw(sql, parentId).QueryRow(&item)
	return
}

// UpdateHelpDocClassifySortByParentId 根据父类id更新排序
func UpdateHelpDocClassifySortByParentId(parentId, classifyId, nowSort int, updateSort string) (err error) {
	o := orm.NewOrm()
	sql := ` update help_doc_classify set sort = ` + updateSort + ` WHERE parent_id=? and sort > ? `
	if classifyId > 0 {
		sql += ` or ( classify_id > ` + fmt.Sprint(classifyId) + ` and sort= ` + fmt.Sprint(nowSort) + `)`
	}
	_, err = o.Raw(sql, parentId, nowSort).Exec()
	return
}

// Update 更新分类基础信息
func (HelpDocClassify *HelpDocClassify) Update(cols []string) (err error) {
	o := orm.NewOrm()
	_, err = o.Update(HelpDocClassify, cols...)
	return
}

// GetHelpDocClassifyMaxSort 获取分类下最大的排序数
func GetHelpDocClassifyMaxSort(parentId int) (sort int, err error) {
	o := orm.NewOrm()
	sql := `SELECT Max(sort) AS sort FROM help_doc_classify WHERE parent_id=?  `
	err = o.Raw(sql, parentId).QueryRow(&sort)
	return
}

type HelpDocClassifyView struct {
	HelpDocClassifyId   int    `orm:"column(classify_id);pk"`
	HelpDocClassifyName string `description:"分类名称"`
	ParentId            int    `description:"父级id"`
}

func GetHelpDocClassifyViewById(classifyId int) (item *HelpDocClassifyView, err error) {
	o := orm.NewOrm()
	sql := `SELECT * FROM help_doc_classify WHERE classify_id=? `
	err = o.Raw(sql, classifyId).QueryRow(&item)
	return
}

func GetHelpDocClassifyByParentIdFromETA(parentId int) (items []*HelpDocClassifyItems, err error) {
	o := orm.NewOrm()
	sql := ` SELECT * FROM help_doc_classify WHERE parent_id=? AND source = 1 order by sort asc,classify_id asc`
	_, err = o.Raw(sql, parentId).QueryRows(&items)
	return
}

func GetHelpDocClassifyAllFromETA() (items []*HelpDocClassifyItems, err error) {
	o := orm.NewOrm()
	sql := ` SELECT * FROM help_doc_classify WHERE parent_id<>0 AND source = 1 order by sort asc,classify_id asc`
	_, err = o.Raw(sql).QueryRows(&items)
	return
}

func GetHelpDocClassifyTwo(source int) (items []*HelpDocClassifyItems, err error) {
	o := orm.NewOrm()
	sql := ` SELECT * FROM help_doc_classify WHERE level=3 AND source = ? order by sort asc,classify_id asc`
	_, err = o.Raw(sql, source).QueryRows(&items)
	return
}

func GetHelpDocClassifyByLevel(level, source int) (items []*HelpDocClassifyItems, err error) {
	o := orm.NewOrm()
	sql := ` SELECT * FROM help_doc_classify WHERE level=? AND source = ? order by sort asc,classify_id asc`
	_, err = o.Raw(sql, level, source).QueryRows(&items)
	return
}

func EditHelpDocClassifySysUser(classifyId, sysUserId int, HelpDocClassifyName string) (err error) {
	o := orm.NewOrm()
	sql := `UPDATE help_doc_classify SET sys_user_id=?,sys_user_real_name=?,modify_time=NOW() WHERE parent_id=?  AND level=3 `
	_, err = o.Raw(sql, sysUserId, HelpDocClassifyName, classifyId).Exec()
	return
}

func GetHelpDocClassifyChildCounts(parentId int) (count int, err error) {
	o := orm.NewOrm()
	sql := `SELECT COUNT(1) AS count FROM help_doc_classify WHERE parent_id=? `
	err = o.Raw(sql, parentId).QueryRow(&count)
	return
}

func GetHelpDocCounts(classifyId int) (count int, err error) {
	o := orm.NewOrm()
	sql := `SELECT COUNT(1) AS count FROM help_doc WHERE classify_id=? `
	err = o.Raw(sql, classifyId).QueryRow(&count)
	return
}

// DeleteHelpDocClassify 删除分类
func DeleteHelpDocClassify(classifyId int) (err error) {
	o := orm.NewOrm()
	sql := ` DELETE FROM help_doc_classify WHERE classify_id =? `
	_, err = o.Raw(sql, classifyId).Exec()
	return
}


// MoveClassifyReq 移动分类请求参数
type MoveClassifyReq struct {
	ClassifyId       int `description:"分类id"`
	ParentClassifyId int `description:"父级分类id"`
	PrevClassifyId   int `description:"上一个兄弟节点分类id"`
	NextClassifyId   int `description:"下一个兄弟节点分类id"`
}