package ppt_english

import (
	"eta/eta_api/global"
	"eta/eta_api/utils"
	"time"
)

// ppt目录和ppt 映射表
type PptEnglishGroupMapping struct {
	GroupPptId      int64     `orm:"column(group_ppt_id);pk" gorm:"primaryKey" description:"自增序号"`
	GroupId         int64     `description:"ppt目录ID"`
	PptSort         int64     `description:"Ppt的排序"`
	PptId           int64     `description:"ppt ID"`
	CreateTime      time.Time `orm:"auto_now_add;type(datetime)" description:"创建时间"`
	ModifyTime      time.Time `orm:"auto_now;type(datetime)" description:"修改时间"`
	AdminId         int       `description:"移动ppt到该目录的系统用户id"`
	AdminRealName   string    `description:"系统用户名称"`
	ChildGroupPptId int64     `description:"设置共享后的新映射ID"`
	IsMoved         bool      `description:"true表示改PPT被人为移动过"`
}

// AddPptGroupMapping 新增目录和ppt的映射关系
func AddPptGroupMapping(item *PptEnglishGroupMapping) (lastId int64, err error) {
	o := global.DbMap[utils.DbNameReport]
	err = o.Create(item).Error
	if err != nil {
		return
	}
	lastId = item.GroupPptId
	return
}

// GetPptMappingCountByGroupId 查询目录下，ppt的个数
func GetPptMappingCountByGroupId(groupId int64) (total int64, err error) {
	o := global.DbMap[utils.DbNameReport]
	sql := `select count(*) from ppt_english_group_mapping where group_id=?`
	err = o.Raw(sql, groupId).Scan(&total).Error
	return
}

// GetPptMappingListByGroupId 查询目录下，ppt列表
func GetPptMappingListByGroupId(groupId int64) (list []*PptEnglishGroupMapping, err error) {
	o := global.DbMap[utils.DbNameReport]
	sql := `select group_ppt_id, group_id, ppt_id, ppt_sort, admin_id, admin_real_name, create_time from ppt_english_group_mapping where group_id=? order by ppt_sort asc, group_ppt_id asc `
	err = o.Raw(sql, groupId).Find(&list).Error
	return
}

// GetPptMappingListByGroupIds 根据分组ID查找
func GetPptMappingListByGroupIds(groupIds []int64) (list []*PptEnglishGroupMapping, err error) {
	o := global.DbMap[utils.DbNameReport] /*.
	QueryTable("ppt_english_group_mapping").
	Filter("group_id__in", groupIds).
	OrderBy("-ppt_sort", "group_ppt_id").
	All(&list)*/
	sql := `select * from ppt_english_group_mapping where group_id in ` + utils.GetOrmInReplace(len(groupIds)) + ` order by ppt_sort desc, group_ppt_id asc`
	err = o.Raw(sql, groupIds).Find(&list).Error
	return
}

// GetPptMappingByPptId 查询目录下, pptId对应的目录映射关系
func GetPptMappingByPptId(pptId int64) (item *PptEnglishGroupMapping, err error) {
	o := global.DbMap[utils.DbNameReport]
	sql := ` select * from ppt_english_group_mapping where ppt_id=? `
	err = o.Raw(sql, pptId).First(&item).Error
	return
}

// GetPptMappingListByGroupId 查询目录下，ppt列表, 降序排列
func GetPptMappingListByGroupIdDesc(groupId int64) (list []*PptEnglishGroupMapping, err error) {
	o := global.DbMap[utils.DbNameReport]
	sql := `select group_ppt_id, group_id, ppt_id, ppt_sort, admin_id, admin_real_name, create_time from ppt_english_group_mapping where group_id=? order by ppt_sort desc, group_ppt_id desc `
	err = o.Raw(sql, groupId).Find(&list).Error
	return
}

// GetPptMappingByGroupPptId 查询根据映射ID，查询单个映射关系
func GetPptMappingByGroupPptId(groupPptId int64, adminId int) (item *PptEnglishGroupMapping, err error) {
	o := global.DbMap[utils.DbNameReport]
	sql := `select * from ppt_english_group_mapping where group_ppt_id=? and admin_id=?`
	err = o.Raw(sql, groupPptId, adminId).First(&item).Error
	return
}

// GetPptMappingByGroupPptId 查询根据映射ID，查询单个映射关系数量
func GetPptMappingCountByGroupPptId(groupPptId int64, adminId int) (count int, err error) {
	o := global.DbMap[utils.DbNameReport]
	sql := `select COUNT(*) AS count from ppt_english_group_mapping where group_ppt_id=? and admin_id=?`
	err = o.Raw(sql, groupPptId, adminId).Scan(&count).Error
	return
}

// Update 更新ppt目录映射的基本信息
func (item *PptEnglishGroupMapping) Update(cols []string) (err error) {
	o := global.DbMap[utils.DbNameReport]
	err = o.Select(cols).Updates(item).Error
	return
}

// AddPptGroupMappingMulti 批量新增ppt和目录的映射关系
func AddPptGroupMappingMulti(list []*PptEnglishGroupMapping) (err error) {
	o := global.DbMap[utils.DbNameReport]
	err = o.CreateInBatches(list, utils.MultiAddNum).Error
	return
}

// UpdatePptGroupMappingSortMulti 批量更新初始排序标识
func UpdatePptGroupMappingSortMulti(groupPptIds []int64) (err error) {
	o := global.DbMap[utils.DbNameReport]
	sql := "UPDATE ppt_english_group_mapping SET ppt_sort = group_ppt_id WHERE group_ppt_id = ?"
	for _, v := range groupPptIds {
		err = o.Exec(sql, v).Error
		if err != nil {
			return
		}
	}
	return
}

// DeletePptGroupMapping 删除ppt目录
func DeletePptGroupMapping(groupId int64, adminId int) (err error) {
	o := global.DbMap[utils.DbNameReport]
	sql := `DELETE FROM ppt_english_group_mapping WHERE group_ppt_id=? and admin_id=? `
	err = o.Exec(sql, groupId, adminId).Error
	return
}

// DeletePptGroupMappingByPptId 删除ppt目录
func DeletePptGroupMappingByPptId(pptId int) (err error) {
	o := global.DbMap[utils.DbNameReport]
	sql := `DELETE FROM ppt_english_group_mapping WHERE ppt_id=?`
	err = o.Exec(sql, pptId).Error
	return
}

// MoveUpGroupPptBySort 往上移动ppt
func MoveUpGroupPptBySort(groupId, nextSort, currentSort int64) (err error) {
	o := global.DbMap[utils.DbNameReport]
	sql := `update ppt_english_group_mapping set ppt_sort = ppt_sort + 1 where group_id=? and ppt_sort >= ? and ppt_sort< ?`
	err = o.Exec(sql, groupId, nextSort, currentSort).Error
	return
}

// MoveDownGroupPptBySort 往下移动ppt
func MoveDownGroupPptBySort(groupId, prevSort, currentSort int64) (err error) {
	o := global.DbMap[utils.DbNameReport]
	sql := `update ppt_english_group_mapping set ppt_sort = ppt_sort - 1 where group_id=? and ppt_sort <= ? and ppt_sort> ? `
	err = o.Exec(sql, groupId, prevSort, currentSort).Error
	return
}

// GetGroupPptByPptId 根据pptID 查找各个目录下的ppt
func GetGroupPptByPptId(pptId int) (list []*PptEnglishGroupMapping, err error) {
	o := global.DbMap[utils.DbNameReport]
	sql := `select * from ppt_english_group_mapping where ppt_id=?`
	err = o.Raw(sql, pptId).Find(&list).Error
	return
}

// GetPublicGroupPptByPptIds 根据pptid查询公共目录下的ppt
func GetPublicGroupPptByPptIds(pptIds []string) (list []*PptEnglishGroupMapping, err error) {
	sql := `select p.* from ppt_english_group as g inner join ppt_english_group_mapping as p on g.group_id = p.group_id where g.is_share = 1 and p.ppt_id in ` + utils.GetOrmInReplace(len(pptIds)) + ` order by g.share_time asc, p.ppt_sort asc`
	// 执行 SQL 语句
	o := global.DbMap[utils.DbNameReport]
	err = o.Raw(sql).Find(&list).Error
	return
}