eta_api/controllers/knowledge/resource.go

package knowledge

import (
	"encoding/json"
	"eta_gn/eta_api/controllers"
	"eta_gn/eta_api/models"
	"eta_gn/eta_api/models/knowledge"
	"eta_gn/eta_api/services"
	knowledgeServ "eta_gn/eta_api/services/knowledge"
	"eta_gn/eta_api/utils"
	"github.com/h2non/filetype"
	"github.com/rdlucklib/rdluck_tools/paging"
	"github.com/tealeg/xlsx"
	"html"
	"io/ioutil"
	"os"
	"path"
	"strconv"
	"strings"
	"time"
)

// 分类
type ResourceController struct {
	controllers.BaseAuthController
}

// ListReport
// @Title 获取事件列表接口
// @Description 获取事件列表
// @Param   PageSize   query   int  true       "每页数据条数"
// @Param   CurrentIndex   query   int  true       "当前页页码，从1开始"
// @Param   TimeType     query string true  "筛选的时间类别：publish_time(发布时间)，modify_time（更新时间）；approve_time（审批时间）"
// @Param   StartDate   query   string  true       "开始时间"
// @Param   EndDate   query   string  true       "结束时间"
// @Param   Frequency   query   string  true       "频度"
// @Param   ClassifyIdFirst   query   int  true       "一级分类id"
// @Param   ClassifyIdSecond   query   int  true       "二级分类id"
// @Param   ClassifyIdThird   query   int  true       "三级分类id"
// @Param   State   query   int  true       "状态"
// @Param   KeyWord   query   string  true       "搜索关键词"
// @Param   PublishSort   query   string  true       "desc:降序，asc 升序（预留）"
// @Param   FilterReportType   query   string  true       "筛选事件类型，1：公共研报，2：共享研报，3：我的研报"
// @Success 200 {object} knowledge.KnowledgeResourceListResp
// @router /resource/list [get]
func (this *ResourceController) List() {
	br := new(models.BaseResponse).Init()
	defer func() {
		this.Data["json"] = br
		this.ServeJSON()
	}()
	pageSize, _ := this.GetInt("PageSize")
	currentIndex, _ := this.GetInt("CurrentIndex")

	classifyIds := this.GetString("ClassifyIds")
	// 添加人
	addUserIds, _ := this.GetInt("SysUserIds")
	// 标签
	tagIds := this.GetString("TagIds")

	keyWord := this.GetString("Keyword")
	resourceType, _ := this.GetInt("ResourceType")

	var startSize int
	if pageSize <= 0 {
		pageSize = utils.PageSize20
	}
	if currentIndex <= 0 {
		currentIndex = 1
	}
	startSize = utils.StartIndex(currentIndex, pageSize)

	var condition string
	var pars []interface{}

	condition += ` AND resource_type = ? `
	pars = append(pars, resourceType)

	if keyWord != "" {
		condition += ` AND (title LIKE ?) `
		pars = utils.GetLikeKeywordPars(pars, keyWord, 2)
	}
	if classifyIds != "" {
		//转成数组，并把类型转成int
		classifyIdsArr := strings.Split(classifyIds, ",")
		var classifyIdsInt []int
		for _, v := range classifyIdsArr {
			classifyId, _ := strconv.Atoi(v)
			classifyIdsInt = append(classifyIdsInt, classifyId)
		}
		condition += ` AND classify_id in (?) `
		pars = append(pars, classifyIdsInt)
	}
	if addUserIds > 0 {
		// 转成数组，并把类型转成int
		addUserIdsArr := strings.Split(strconv.Itoa(addUserIds), ",")
		var addUserIdsInt []int
		for _, v := range addUserIdsArr {
			addUserId, _ := strconv.Atoi(v)
			addUserIdsInt = append(addUserIdsInt, addUserId)
		}
		condition += ` AND admin_id in (?) `
		pars = append(pars, addUserIdsInt)
	}
	if tagIds != "" {
		//转成数组，并把类型转成int
		tagIdsArr := strings.Split(tagIds, ",")
		var tagIdsInt []int
		for _, v := range tagIdsArr {
			tagId, _ := strconv.Atoi(v)
			tagIdsInt = append(tagIdsInt, tagId)
		}
		condition += ` AND tag_id in (?) `
		pars = append(pars, tagIdsInt)
	}

	var err error
	var total int
	var list []*knowledge.KnowledgeResourceList
	// 共享事件需要连表查询，所以需要单独写
	total, err = knowledge.GetKnowledgeResourceListCount(condition, pars)
	if err != nil {
		br.Msg = "获取失败"
		br.ErrMsg = "获取失败，Err:" + err.Error()
		return
	}
	listTmp, err := knowledge.GetKnowledgeResourceList(condition, pars, startSize, pageSize)
	if err != nil {
		br.Msg = "获取失败"
		br.ErrMsg = "获取失败，Err:" + err.Error()
		return
	}
	// 整理分类ID
	classifyFullNameMap := make(map[int]string)
	classifyIdsArr := make([]int, 0)
	for _, v := range listTmp {
		classifyIdsArr = append(classifyIdsArr, v.ClassifyId)
	}
	// 获取分类列表
	classifyList, err := knowledge.GetFullClassifyListByIdList(classifyIdsArr, resourceType)
	if err != nil {
		br.Msg = "获取失败"
		br.ErrMsg = "获取失败，Err:" + err.Error()
		return
	}
	for _, v := range classifyList {
		name := v.ClassifyName
		if v.ParentName != "" {
			name = v.ParentName + "/" + name
		}
		if v.RootName != "" {
			name = v.RootName + "/" + name
		}
		classifyFullNameMap[v.ClassifyId] = name
	}

	// 整理标签ID
	tagNameMap := make(map[int]string)
	tagIdsArr := make([]int, 0)
	for _, v := range listTmp {
		tagIdsArr = append(tagIdsArr, v.TagId)
	}
	// 获取标签列表
	tagObj := new(knowledge.KnowledgeTag)
	tagList, err := tagObj.GetListByIdList(tagIdsArr, resourceType)
	if err != nil {
		br.Msg = "获取失败"
		br.ErrMsg = "获取失败，Err:" + err.Error()
	}
	for _, v := range tagList {
		tagNameMap[v.TagId] = v.TagName
	}

	for _, v := range listTmp {
		var startTime, endTime string
		if v.StartTime != nil && !v.StartTime.IsZero() {
			startTime = v.StartTime.In(time.Local).Format(utils.FormatDateTime)
			if resourceType == knowledge.KnowledgeResourceTypeOpinion || resourceType == knowledge.KnowledgeResourceTypeKnow {
				startTime = v.StartTime.In(time.Local).Format(utils.FormatDate)
			}
		}
		if v.EndTime != nil && !v.EndTime.IsZero() {
			endTime = v.EndTime.In(time.Local).Format(utils.FormatDateTime)
			if resourceType == knowledge.KnowledgeResourceTypeOpinion || resourceType == knowledge.KnowledgeResourceTypeKnow {
				endTime = v.EndTime.In(time.Local).Format(utils.FormatDate)
			}
		}
		modifyTime := v.ModifyTime.In(time.Local).Format(utils.FormatDateTime)
		createTime := v.CreateTime.In(time.Local).Format(utils.FormatDateTime)
		tmp := &knowledge.KnowledgeResourceList{
			KnowledgeResourceId: v.KnowledgeResourceId,
			ResourceType:        v.ResourceType,
			ClassifyId:          v.ClassifyId,
			Title:               v.Title,
			CreateTime:          createTime,
			ModifyTime:          modifyTime,
			State:               v.State,
			ResourceCode:        v.ResourceCode,
			AdminId:             v.AdminId,
			AdminRealName:       v.AdminRealName,
			SourceFrom:          v.SourceFrom,
			TagId:               v.TagId,
			StartTime:           startTime,
			EndTime:             endTime,
		}

		// todo 编辑状态
		/*markStatus, err := services.UpdateReportEditMark(item.Id, 0, this.SysUser.AdminId, 2, this.SysUser.RealName, this.Lang)
		if err != nil {
			br.Msg = "查询标记状态失败"
			br.ErrMsg = "查询标记状态失败，Err:" + err.Error()
			return
		}
		if markStatus.Status == 0 {
			item.CanEdit = true
		} else {
			item.Editor = markStatus.Editor
		}*/
		classifyName, ok := classifyFullNameMap[tmp.ClassifyId]
		if ok {
			tmp.ClassifyFullName = classifyName
		}
		tagName, ok := tagNameMap[v.TagId]
		if ok {
			tmp.TagName = tagName
		}
		list = append(list, tmp)
	}

	page := paging.GetPaging(currentIndex, pageSize, total)
	resp := new(knowledge.KnowledgeResourceListResp)
	resp.Paging = page
	resp.List = list
	br.Ret = 200
	br.Success = true
	br.Msg = "获取成功"
	br.Data = resp
}

// Add
// @Title 新增事件接口
// @Description 新增事件（区分事件类型）
// @Param	request	body knowledge.AddReq true "type json string"
// @Success 200 {object} knowledge.AddResp
// @router /resource/add [post]
func (this *ResourceController) Add() {
	br := new(models.BaseResponse).Init()
	defer func() {
		this.Data["json"] = br
		this.ServeJSON()
	}()
	sysUser := this.SysUser
	if sysUser == nil {
		br.Msg = "请登录"
		br.ErrMsg = "请登录，SysUser Is Empty"
		br.Ret = 408
		return
	}
	var req knowledge.AddReq
	err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
	if err != nil {
		br.Msg = "参数解析异常！"
		br.ErrMsg = "参数解析失败，Err:" + err.Error()
		return
	}

	if req.Title == `` {
		br.Msg = "标题不能为空"
		br.ErrMsg = "标题不能为空"
		br.IsSendEmail = false
		return
	}
	if req.ClassifyId <= 0 {
		br.Msg = "分类必填"
		br.ErrMsg = "分类必填"
		br.IsSendEmail = false
		return
	}
	if req.ResourceType == knowledge.KnowledgeResourceTypeEvent || req.ResourceType == knowledge.KnowledgeResourceTypePolicy {
		if req.StartTime == "" {
			br.Msg = "开始时间必填"
			br.ErrMsg = "开始时间必填"
			return
		}
	}
	item, err, errMsg := knowledgeServ.AddResource(&req, sysUser)
	if err != nil {
		br.Msg = "保存失败"
		if errMsg != "" {
			br.Msg = errMsg
		}
		br.ErrMsg = "保存失败,Err:" + err.Error()
		return
	}

	resp := new(knowledge.AddResp)
	resp.KnowledgeResourceId = item.KnowledgeResourceId
	resp.ResourceCode = item.ResourceCode
	br.Ret = 200
	br.Success = true
	br.Msg = "保存成功"
	br.Data = resp
}

// Edit
// @Title 编辑事件基础信息接口
// @Description 编辑事件基础信息（不区分事件类型）
// @Param	request	body knowledge.EditReq true "type json string"
// @Success 200 {object} knowledge.EditResp
// @router /resource/edit [post]
func (this *ResourceController) Edit() {
	br := new(models.BaseResponse).Init()
	defer func() {
		this.Data["json"] = br
		this.ServeJSON()
	}()
	sysUser := this.SysUser
	if sysUser == nil {
		br.Msg = "请登录"
		br.ErrMsg = "请登录，SysUser Is Empty"
		br.Ret = 408
		return
	}

	var req knowledge.EditReq
	err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
	if err != nil {
		br.Msg = "参数解析异常！"
		br.ErrMsg = "参数解析失败，Err:" + err.Error()
		return
	}

	if req.KnowledgeResourceId <= 0 {
		br.Msg = "请选择事件"
		br.ErrMsg = "请选择事件"
		return
	}
	if req.Title == `` {
		br.Msg = "标题不能为空"
		br.ErrMsg = "标题不能为空"
		br.IsSendEmail = false
		return
	}
	if req.ClassifyId <= 0 {
		br.Msg = "分类必填"
		br.ErrMsg = "分类必填"
		br.IsSendEmail = false
		return
	}

	if req.ResourceType == knowledge.KnowledgeResourceTypeEvent || req.ResourceType == knowledge.KnowledgeResourceTypePolicy {
		if req.StartTime == "" {
			br.Msg = "开始时间必填"
			br.ErrMsg = "开始时间必填"
			return
		}
	}

	// todo 更新标记key
	/*markStatus, err := services.UpdateReportEditMark(int(req.KnowledgeResourceId), 0, sysUser.AdminId, 1, sysUser.RealName, this.Lang)
	if err != nil {
		br.Msg = err.Error()
		return
	}
	if markStatus.Status == 1 {
		br.Msg = markStatus.Msg
		//br.Ret = 202 //202 服务器已接受请求，但尚未处理。
		return
	}*/
	resourceObj := new(knowledge.KnowledgeResource)
	resourceInfo, e := resourceObj.GetById(int(req.KnowledgeResourceId))
	if e != nil {
		if utils.IsErrNoRow(e) {
			br.Msg = "事件已被删除, 请刷新页面"
			return
		}
		br.Msg = "操作失败"
		br.ErrMsg = "获取事件失败, Err: " + e.Error()
		return
	}
	if resourceInfo.ResourceType != req.ResourceType {
		br.Msg = "事件类型错误"
		return
	}

	// 编辑事件信息
	err, errMsg := knowledgeServ.EditResource(resourceInfo, req, sysUser)
	if err != nil {
		br.Msg = "保存失败"
		if errMsg != "" {
			br.Msg = errMsg
		}
		br.ErrMsg = "保存失败,Err:" + err.Error()
		return
	}

	resp := new(knowledge.EditResp)
	resp.KnowledgeResourceId = req.KnowledgeResourceId
	resp.ResourceCode = resourceInfo.ResourceCode
	br.Ret = 200
	br.Success = true
	br.Msg = "保存成功"
	br.Data = resp
}

// Detail
// @Title 获取事件详情接口
// @Description 获取事件详情
// @Param	request	body knowledge.KnowledgeResourceDetailReq true "type json string"
// @Success 200 {object} knowledge.KnowledgeResource
// @router /resource/detail [get]
func (this *ResourceController) Detail() {
	br := new(models.BaseResponse).Init()
	defer func() {
		this.Data["json"] = br
		this.ServeJSON()
	}()
	/*var req knowledge.KnowledgeResourceDetailReq
	err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
	if err != nil {
		br.Msg = "参数解析异常！"
		br.ErrMsg = "参数解析失败，Err:" + err.Error()
		return
	}
	if req.KnowledgeResourceId <= 0 {
		br.Msg = "参数错误"
		return
	}*/
	knowledgeResourceId, err := this.GetInt("KnowledgeResourceId")
	if err != nil {
		br.Msg = "获取参数失败！"
		br.ErrMsg = "获取参数失败，Err:" + err.Error()
		return
	}
	if knowledgeResourceId <= 0 {
		br.Msg = "参数错误"
		return
	}
	resourceObj := new(knowledge.KnowledgeResource)
	item, err := resourceObj.GetById(knowledgeResourceId)
	if err != nil {
		if utils.IsErrNoRow(err) {
			br.Msg = "事件已被删除"
			return
		}
		br.Msg = "获取失败"
		br.ErrMsg = "获取失败，Err:" + err.Error()
		return
	}
	item.Content = html.UnescapeString(item.Content)

	resp := &knowledge.KnowledgeResourceDetailView{
		KnowledgeResource: item,
	}
	br.Ret = 200
	br.Success = true
	br.Msg = "获取成功"
	br.Data = resp
}

// SaveReportContent
// @Title 保存草稿
// @Description 保存草稿
// @Param	request	body knowledge.SaveReportContent true "type json string"
// @Success 200 {object} knowledge.KnowledgeResourceAuthorResp
// @router /resource/saveContent [post]
func (this *ResourceController) SaveReportContent() {
	br := new(models.BaseResponse).Init()
	br.IsSendEmail = false
	defer func() {
		this.Data["json"] = br
		this.ServeJSON()
	}()
	sysUser := this.SysUser
	if sysUser == nil {
		br.Msg = "请登录"
		br.ErrMsg = "请登录，SysUser Is Empty"
		br.Ret = 408
		return
	}
	var req knowledge.SaveReportContent
	err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
	if err != nil {
		br.Msg = "参数解析异常！"
		br.ErrMsg = "参数解析失败，Err:" + err.Error()
		return
	}
	knowledgeResourceId := req.KnowledgeResourceId
	//noChangeFlag := req.NoChange

	if knowledgeResourceId <= 0 {
		resp := new(knowledge.SaveReportContentResp)
		resp.KnowledgeResourceId = knowledgeResourceId
		br.Ret = 200
		br.Success = true
		br.Msg = "保存成功"
		br.Data = resp
		return
	}

	// 获取事件详情
	/*resourceInfo, _ := knowledge.GetReportByknowledgeResourceId(req.KnowledgeResourceId)
	if resourceInfo != nil && resourceInfo.State == 2 {
		br.Msg = "该事件已发布，不允许编辑"
		br.ErrMsg = "该事件已发布，不允许编辑"
		br.IsSendEmail = false
		return
	}

	// 标记更新中
	{
		markStatus, err := services.UpdateReportEditMark(req.KnowledgeResourceId, 0, sysUser.AdminId, 1, sysUser.RealName, this.Lang)
		if err != nil {
			br.Msg = err.Error()
			return
		}
		if markStatus.Status == 1 {
			br.Msg = markStatus.Msg
			return
		}
	}

	// 内容有过修改的话，那么逻辑处理
	if noChangeFlag != 1 {
		content := req.Content
		if content == "" {
			content = this.GetString("Content")
		}
		if content != "" {
			e := utils.ContentXssCheck(req.Content)
			if e != nil {
				br.Msg = "存在非法标签"
				br.ErrMsg = "存在非法标签, Err: " + e.Error()
				return
			}
			contentClean, e := services.FilterReportContentBr(req.Content)
			if e != nil {
				br.Msg = "内容去除前后空格失败"
				br.ErrMsg = "内容去除前后空格失败, Err: " + e.Error()
				return
			}
			content = contentClean

			contentSub, err := services.GetReportContentSub(content)
			if err != nil {
				go alarm_msg.SendAlarmMsg("解析 ContentSub 失败，Err："+err.Error(), 3)
				//utils.SendEmail(utils.APPNAME+"失败提醒", "解析 ContentSub 失败，Err:"+err.Error(), utils.EmailSendToUsers)
			}
			resourceInfo.Content = html.EscapeString(content)
			resourceInfo.ContentSub = html.EscapeString(contentSub)
			resourceInfo.ContentStruct = html.EscapeString(req.ContentStruct)
			resourceInfo.HeadImg = req.HeadImg
			resourceInfo.EndImg = req.EndImg
			resourceInfo.CanvasColor = req.CanvasColor
			resourceInfo.HeadResourceId = req.HeadResourceId
			resourceInfo.EndResourceId = req.EndResourceId
			resourceInfo.ModifyTime = time.Now()
			resourceInfo.ContentModifyTime = time.Now()
			updateCols := []string{"Content", "ContentSub", "ContentStruct", "HeadImg", "EndImg", "CanvasColor", "HeadResourceId", "EndResourceId", "ModifyTime", "ContentModifyTime"}
			err = resourceInfo.UpdateReport(updateCols)
			if err != nil {
				br.Msg = "保存失败"
				br.ErrMsg = "保存失败，Err:" + err.Error()
				return
			}
			go knowledge.AddReportSaveLog(knowledgeResourceId, this.SysUser.AdminId, resourceInfo.Content, resourceInfo.ContentSub, resourceInfo.ContentStruct, resourceInfo.CanvasColor, this.SysUser.AdminName, resourceInfo.HeadResourceId, resourceInfo.EndResourceId)
		}
	}
	*/
	resp := new(knowledge.SaveReportContentResp)
	resp.KnowledgeResourceId = knowledgeResourceId
	br.Ret = 200
	br.Success = true
	br.Msg = "保存成功"
	br.Data = resp
}

// BaseDetail
// @Title 获取事件基础信息详情接口
// @Description 获取事件基础信息详情接口
// @Param	request	body knowledge.KnowledgeResourceDetailReq true "type json string"
// @Success 200 {object} knowledge.KnowledgeResource
// @router /resource/detail/base [get]
func (this *ResourceController) BaseDetail() {
	br := new(models.BaseResponse).Init()
	defer func() {
		this.Data["json"] = br
		this.ServeJSON()
	}()
	/*var req knowledge.KnowledgeResourceDetailReq
	err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
	if err != nil {
		br.Msg = "参数解析异常！"
		br.ErrMsg = "参数解析失败，Err:" + err.Error()
		return
	}
	if req.KnowledgeResourceId <= 0 {
		br.Msg = "参数错误"
		return
	}*/
	/*knowledgeResourceId, err := this.GetInt("KnowledgeResourceId")
	if err != nil {
		br.Msg = "获取参数失败！"
		br.ErrMsg = "获取参数失败，Err:" + err.Error()
		return
	}
	if knowledgeResourceId <= 0 {
		br.Msg = "参数错误"
		return
	}
	resourceInfo, err := knowledge.GetReportById(knowledgeResourceId)
	if err != nil {
		if utils.IsErrNoRow(err) {
			br.Msg = "事件已被删除"
			return
		}
		br.Msg = "获取失败"
		br.ErrMsg = "获取失败，Err:" + err.Error()
		return
	}

	// 基础信息就不获取章节信息了
	chapterList := make([]*knowledge.KnowledgeResourceChapter, 0)

	resourceInfo.Content = html.UnescapeString(resourceInfo.Content)
	resourceInfo.ContentSub = html.UnescapeString(resourceInfo.ContentSub)

	grandAdminList := make([]knowledge.KnowledgeResourceDetailViewAdmin, 0)
	permissionList := make([]knowledge.KnowledgeResourceDetailViewPermission, 0)

	// 处理事件授权用户列表
	{
		obj := report.ReportGrant{}
		grantList, tmpErr := obj.GetGrantListById(knowledgeResourceId)
		if tmpErr != nil {
			br.Msg = "获取章节id授权用户列表失败"
			br.ErrMsg = "获取章节id授权用户列表失败, Err: " + tmpErr.Error()
			return
		}

		if len(grantList) > 0 {
			grandAdminIdList := make([]int, 0)
			for _, v := range grantList {
				grandAdminIdList = append(grandAdminIdList, v.AdminId)
			}
			adminList, tmpErr := system.GetAdminListByIdList(grandAdminIdList)
			if tmpErr != nil {
				br.Msg = "获取章节id授权用户列表失败"
				br.ErrMsg = "获取章节id授权用户列表失败, Err: " + tmpErr.Error()
				return
			}
			for _, v := range adminList {
				grandAdminList = append(grandAdminList, knowledge.KnowledgeResourceDetailViewAdmin{
					AdminId:   v.AdminId,
					AdminName: v.RealName,
				})
			}
		}

	}

	// 处理章节id关联品种id列表
	{
		minClassifyId := resourceInfo.ClassifyIdThird
		if minClassifyId <= 0 {
			minClassifyId = resourceInfo.ClassifyIdSecond
		}
		if minClassifyId <= 0 {
			minClassifyId = resourceInfo.ClassifyIdFirst
		}
		if minClassifyId <= 0 {
			br.Msg = "分类异常"
			br.ErrMsg = "分类异常"
			return
		}

		// 获取分类关联的品种id
		classifyPermissionList, tmpErr := knowledge.GetPermission(minClassifyId)
		if tmpErr != nil {
			br.Msg = "获取分类信息失败"
			br.ErrMsg = "获取失败，Err:" + tmpErr.Error()
			return
		}

		if len(classifyPermissionList) > 0 {
			permissionIdList := make([]int, 0)
			for _, v := range classifyPermissionList {
				permissionIdList = append(permissionIdList, v.ChartPermissionId)
			}
			adminList, tmpErr := knowledge.GetChartPermissionByIdList(permissionIdList)
			if tmpErr != nil {
				br.Msg = "获取章节id授权用户列表失败"
				br.ErrMsg = "获取章节id授权用户列表失败, Err: " + tmpErr.Error()
				return
			}
			for _, v := range adminList {
				permissionList = append(permissionList, knowledge.KnowledgeResourceDetailViewPermission{
					PermissionId:   v.ChartPermissionId,
					PermissionName: v.PermissionName,
				})
			}
		}

	}

	resp := &knowledge.KnowledgeResourceDetailView{
		ReportDetail:   resourceInfo,
		ChapterList:    chapterList,
		GrandAdminList: grandAdminList,
		PermissionList: permissionList,
	}
	br.Ret = 200
	br.Success = true
	br.Msg = "获取成功"
	br.Data = resp*/
}

// Delete
// @Title 删除事件接口
// @Description 删除事件
// @Param	request	body knowledge.DeleteReq true "type json string"
// @Success 200 Ret=200 删除成功
// @router /resource/delete [post]
func (this *ResourceController) Delete() {
	br := new(models.BaseResponse).Init()
	defer func() {
		this.Data["json"] = br
		this.ServeJSON()
	}()
	var req knowledge.DeleteReq
	err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
	if err != nil {
		br.Msg = "参数解析异常！"
		br.ErrMsg = "参数解析失败，Err:" + err.Error()
		return
	}
	if req.KnowledgeResourceId <= 0 {
		br.Msg = "参数错误"
		br.ErrMsg = "参数错误，事件id不可为空"
		return
	}
	resourceObj := new(knowledge.KnowledgeResource)
	item, err := resourceObj.GetById(req.KnowledgeResourceId)
	if err != nil {
		if utils.IsErrNoRow(err) {
			br.Msg = "事件不存在"
			br.ErrMsg = "事件不存在"
			return
		}
	}
	if item.ResourceType != req.ResourceType {
		br.Msg = "事件类型不匹配"
		return
	}
	if err = item.Delete(req.KnowledgeResourceId); err != nil {
		br.Msg = "删除失败"
		br.ErrMsg = "删除事件失败, Err: " + err.Error()
		return
	}

	br.Ret = 200
	br.Success = true
	br.Msg = "删除成功"
}

// ImportData
// @Title Excel导入事件
// @Description Excel导入事件
// @Param   EntryFile   query   file  true       "文件"
// @Success 200 Ret=200 录入成功
// @router /resource/import_add [post]
func (c *ResourceController) ImportData() {
	br := new(models.BaseResponse).Init()
	defer func() {
		c.Data["json"] = br
		c.ServeJSON()
	}()
	sysUser := c.SysUser
	if sysUser == nil {
		br.Msg = "请重新登录"
		return
	}
	resourceType, _ := c.GetInt("ResourceType")
	file, _, err := c.GetFile("EntryFile")
	if err != nil {
		br.Msg = "获取文件失败"
		br.ErrMsg = "获取文件失败，Err:" + err.Error()
		return
	}
	path := "./static/knowledge_import_" + strconv.Itoa(resourceType) + "_" + time.Now().Format(utils.FormatDateTimeUnSpace) + ".xlsx"
	defer file.Close()
	err = c.SaveToFile("EntryFile", path)
	if err != nil {
		br.Msg = "文件保存失败"
		br.ErrMsg = "文件保存失败，Err:" + err.Error()
		return
	}
	if utils.RunMode == "debug" {
		defer os.Remove(path)
	}

	successCount, failCount, err, errMsg := knowledgeServ.ImportResourceData(path, resourceType, sysUser)
	if err != nil {
		br.Msg = errMsg
		br.ErrMsg = err.Error()
		return
	}

	resp := models.EdbdataImportResp{
		SuccessCount: successCount,
		FailCount:    failCount,
	}
	if failCount > 0 {
		if successCount == 0 {
			resp.Status = -1
			resp.Msg = "导入失败"
		} else {
			resp.Status = 1
			resp.Msg = "存在部分导入失败"
		}
	} else {
		resp.Status = 0
	}
	br.Msg = "导入成功"
	br.Ret = 200
	br.Success = true
	br.Data = resp
}

// ImportFailListDownload
// @Title 下载失败列表
// @Description 下载失败列表
// @Success 200 {object} models.EdbdataClassifyResp
// @router /resource/download_fail [get]
func (this *ResourceController) ImportFailListDownload() {
	br := new(models.BaseResponse).Init()
	defer func() {
		this.Data["json"] = br
		this.ServeJSON()
	}()
	sysUser := this.SysUser
	if sysUser == nil {
		br.Msg = "请重新登录"
		return
	}
	resourceType, _ := this.GetInt("ResourceType")
	failObj := new(knowledge.KnowledgeImportFail)
	item, err := failObj.GetListBySysUserId(sysUser.AdminId, resourceType)
	if err != nil {
		br.Msg = "获取数据失败"
		br.Msg = "获取数据失败，Err:" + err.Error()
		return
	}
	xlsxFile := xlsx.NewFile()
	SheetName := "导入失败数据"
	if this.Lang == utils.EnLangVersion {
		SheetName = "Import Fail List"
	}

	sheet, err := xlsxFile.AddSheet(SheetName)
	if err != nil {
		br.Msg = "获取sheet失败"
		br.Msg = "获取sheet失败，Err:" + err.Error()
		return
	}
	if resourceType == knowledge.KnowledgeResourceTypeEvent || resourceType == knowledge.KnowledgeResourceTypePolicy {
		headRow := sheet.AddRow()
		headRow.AddCell().SetValue("开始日期")
		headRow.AddCell().SetValue("开始时间")
		headRow.AddCell().SetValue("结束日期")
		headRow.AddCell().SetValue("结束时间")
		headRow.AddCell().SetValue("标题")
		headRow.AddCell().SetValue("正文")
		headRow.AddCell().SetValue("来源")
		headRow.AddCell().SetValue("一级分类")
		headRow.AddCell().SetValue("二级分类")
		headRow.AddCell().SetValue("三级分类")
		headRow.AddCell().SetValue("标签")
		headRow.AddCell().SetValue("备注")

		for _, v := range item {
			row := sheet.AddRow()
			row.AddCell().SetValue(v.StartDate)
			row.AddCell().SetValue(v.StartTime)
			row.AddCell().SetValue(v.EndDate)
			row.AddCell().SetValue(v.EndTime)
			row.AddCell().SetValue(v.Title)
			row.AddCell().SetValue(v.Content)
			row.AddCell().SetValue(v.SourceFrom)
			row.AddCell().SetValue(v.ClassifyFirst)
			row.AddCell().SetValue(v.ClassifySecond)
			row.AddCell().SetValue(v.ClassifyThird)
			row.AddCell().SetValue(v.Tag)
			row.AddCell().SetValue(v.Remark)
		}
	} else {
		headRow := sheet.AddRow()
		headRow.AddCell().SetValue("时间")
		headRow.AddCell().SetValue("标题")
		headRow.AddCell().SetValue("正文")
		headRow.AddCell().SetValue("来源")
		headRow.AddCell().SetValue("一级分类")
		headRow.AddCell().SetValue("二级分类")
		headRow.AddCell().SetValue("三级分类")
		headRow.AddCell().SetValue("标签")
		headRow.AddCell().SetValue("备注")

		for _, v := range item {
			row := sheet.AddRow()
			row.AddCell().SetValue(v.StartDate)
			row.AddCell().SetValue(v.Title)
			row.AddCell().SetValue(v.Content)
			row.AddCell().SetValue(v.SourceFrom)
			row.AddCell().SetValue(v.ClassifyFirst)
			row.AddCell().SetValue(v.ClassifySecond)
			row.AddCell().SetValue(v.ClassifyThird)
			row.AddCell().SetValue(v.Tag)
			row.AddCell().SetValue(v.Remark)
		}
	}

	fileName := time.Now().Format(utils.FormatDateTimeUnSpace) + ".xlsx"
	savePath := "./static/" + fileName
	err = xlsxFile.Save(savePath)
	if err != nil {
		br.Msg = "文件保存失败"
		br.ErrMsg = "文件保存失败,Err:" + err.Error()
		return
	}
	defer func() {
		os.Remove(savePath)
	}()
	finalFileName := "失败列表.xlsx"

	if this.Lang == utils.EnLangVersion {
		finalFileName = "Failure List.xlsx"
	}
	this.Ctx.Output.Download(savePath, finalFileName)
}

// ResourceUpload 上传文件
// @Title 上传文件
// @Description 上传文件
// @Param   MenuId  query  int  true  "目录ID"
// @Param   File	query  file  true  "文件"
// @Success 200 Ret=200 操作成功
// @router /resource/upload [post]
func (this *ResourceController) ResourceUpload() {
	br := new(models.BaseResponse).Init()
	defer func() {
		if br.ErrMsg == "" {
			br.IsSendEmail = false
		}
		this.Data["json"] = br
		this.ServeJSON()
	}()
	sysUser := this.SysUser
	if sysUser == nil {
		br.Msg = "请登录"
		br.ErrMsg = "请登录，SysUser Is Empty"
		br.Ret = 408
		return
	}
	f, h, e := this.GetFile("File")
	if e != nil {
		br.Msg = "获取资源信息失败"
		br.ErrMsg = "获取资源信息失败, Err:" + e.Error()
		return
	}
	defer func() {
		_ = f.Close()
	}()

	// 不依赖于文件扩展名检查文件格式
	fileData, e := ioutil.ReadAll(f)
	if e != nil {
		br.Msg = "上传失败"
		br.ErrMsg = "读取文件失败, Err: " + e.Error()
		return
	}
	kind, _ := filetype.Match(fileData)
	if kind.Extension != "pdf" && kind.Extension != "ppt" && kind.Extension != "docx" && kind.Extension != "doc" {
		br.Msg = "文件格式有误"
		return
	}

	uploadDir := utils.STATIC_DIR + "hongze/" + time.Now().Format("20060102")
	if e = os.MkdirAll(uploadDir, utils.DIR_MOD); e != nil {
		br.Msg = "存储目录创建失败"
		br.ErrMsg = "存储目录创建失败, Err:" + e.Error()
		return
	}
	ext := path.Ext(h.Filename)
	ossFileName := utils.GetRandStringNoSpecialChar(28) + ext
	filePath := uploadDir + "/" + ossFileName
	if e = this.SaveToFile("file", filePath); e != nil {
		br.Msg = "文件保存失败"
		br.ErrMsg = "文件保存失败, Err:" + e.Error()
		return
	}
	defer func() {
		_ = os.Remove(filePath)
	}()
	// 上传到阿里云
	ossDir := utils.RESOURCE_DIR + "knowledge_resource/"

	resourceUrl := ``
	savePath := ossDir + time.Now().Format("200601/20060102/") + ossFileName
	ossClient := services.NewOssClient()
	if ossClient == nil {
		br.Msg = "上传失败"
		br.ErrMsg = "初始化OSS服务失败"
		return
	}
	resourceUrl, e = ossClient.UploadFile(ossFileName, filePath, savePath)
	if e != nil {
		br.Msg = "文件上传失败"
		br.ErrMsg = "文件上传失败，Err:" + e.Error()
		return
	}

	resourceItem := &knowledge.UpdateResourceResp{
		FileUrl: resourceUrl,
	}

	br.Msg = "上传成功"
	br.Ret = 200
	br.Success = true
	br.Data = resourceItem
}

// GetSourceFrom
// @Title 获取所有来源
// @Description 获取所有来源
// @Success 200 {object} models.EdbdataClassifyResp
// @router /resource/source_from [get]
func (this *ResourceController) GetSourceFrom() {
	br := new(models.BaseResponse).Init()
	defer func() {
		this.Data["json"] = br
		this.ServeJSON()
	}()
	sysUser := this.SysUser
	if sysUser == nil {
		br.Msg = "请重新登录"
		return
	}
	resourceType, _ := this.GetInt("ResourceType")
	keyword := this.GetString("Keyword")
	resourceObj := new(knowledge.KnowledgeResource)
	list, err := resourceObj.GetSourceFrom(keyword, resourceType)
	if err != nil {
		br.Msg = "获取数据失败"
		br.Msg = "获取数据失败，Err:" + err.Error()
		return
	}
	resp := new(knowledge.GetSourceFromResp)
	resp.List = list

	br.Ret = 200
	br.Success = true
	br.Msg = "获取成功"
	br.Data = resp
}

// GetAdminList
// @Title 获取所有创建人
// @Description 获取所有创建人
// @Success 200 {object} models.EdbdataClassifyResp
// @router /resource/admins [get]
func (this *ResourceController) GetAdminList() {
	br := new(models.BaseResponse).Init()
	defer func() {
		this.Data["json"] = br
		this.ServeJSON()
	}()
	sysUser := this.SysUser
	if sysUser == nil {
		br.Msg = "请重新登录"
		return
	}
	resourceType, _ := this.GetInt("ResourceType")
	keyword := this.GetString("Keyword")
	resourceObj := new(knowledge.KnowledgeResource)
	list, err := resourceObj.GetAdmins(keyword, resourceType)
	if err != nil {
		br.Msg = "获取数据失败"
		br.Msg = "获取数据失败，Err:" + err.Error()
		return
	}
	resp := new(knowledge.GetAdminsResp)
	resp.List = list

	br.Ret = 200
	br.Success = true
	br.Msg = "获取成功"
	br.Data = resp
}