report_approve.go 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961
  1. package report_approve
  2. import (
  3. "encoding/json"
  4. "eta/eta_api/controllers"
  5. "eta/eta_api/models"
  6. "eta/eta_api/models/report_approve"
  7. "eta/eta_api/services"
  8. "eta/eta_api/utils"
  9. "fmt"
  10. "github.com/rdlucklib/rdluck_tools/paging"
  11. "sort"
  12. "strconv"
  13. "strings"
  14. "time"
  15. )
  16. // ReportApproveController 报告审批
  17. type ReportApproveController struct {
  18. controllers.BaseAuthController
  19. }
  20. // List
  21. // @Title 审批列表
  22. // @Description 审批列表
  23. // @Param PageSize query int true "每页数据条数"
  24. // @Param CurrentIndex query int true "当前页页码"
  25. // @Param ListType query int true "列表类型:1-待处理;2-已处理;3-我发起的"
  26. // @Param ReportType query int false "报告类型:1-中文研报;2-英文研报;3-智能研报"
  27. // @Param ClassifyIdFirst query int false "一级分类ID"
  28. // @Param ClassifyIdSecond query int false "二级分类ID"
  29. // @Param Keyword query string false "搜索关键词"
  30. // @Param ApproveState query int false "审批状态:1-待审批;2-已审批;3-已驳回;4-已撤回"
  31. // @Param TimeType query int false "时间类型:1-提交时间;2-处理时间;3-审批时间"
  32. // @Param StartTime query string false "开始时间"
  33. // @Param EndTime query string false "结束时间"
  34. // @Param SortField query int false "排序字段:1-提交时间;2-处理时间;3-审批时间"
  35. // @Param SortRule query int false "排序方式: 1-正序; 2-倒序(默认)"
  36. // @Success 200 {object} report_approve.ReportApproveListResp
  37. // @router /list [get]
  38. func (this *ReportApproveController) List() {
  39. br := new(models.BaseResponse).Init()
  40. defer func() {
  41. if br.ErrMsg == "" {
  42. br.IsSendEmail = false
  43. }
  44. this.Data["json"] = br
  45. this.ServeJSON()
  46. }()
  47. sysUser := this.SysUser
  48. if sysUser == nil {
  49. br.Msg = "请登录"
  50. br.ErrMsg = "请登录,SysUser Is Empty"
  51. br.Ret = 408
  52. return
  53. }
  54. params := new(report_approve.ReportApproveListReq)
  55. if e := this.ParseForm(params); e != nil {
  56. br.Msg = "获取失败"
  57. br.ErrMsg = "入参解析失败, Err: " + e.Error()
  58. return
  59. }
  60. if params.ListType != 1 && params.ListType != 2 && params.ListType != 3 {
  61. br.Msg = "列表类型有误"
  62. return
  63. }
  64. // 报告分类
  65. cnClassifyIdName, enClassifyIdName := make(map[int]string), make(map[int]string)
  66. cnClassify, e := models.GetAllClassify()
  67. if e != nil {
  68. br.Msg = "获取失败"
  69. br.ErrMsg = "获取中文分类失败, Err: " + e.Error()
  70. return
  71. }
  72. for _, v := range cnClassify {
  73. cnClassifyIdName[v.Id] = v.ClassifyName
  74. }
  75. enClassify, e := models.GetEnglishClassifies()
  76. if e != nil {
  77. br.Msg = "获取失败"
  78. br.ErrMsg = "获取英文分类失败, Err: " + e.Error()
  79. return
  80. }
  81. enRootIdMap := make(map[int]int) // 英文分类的一级分类ID
  82. for _, v := range enClassify {
  83. enClassifyIdName[v.Id] = v.ClassifyName
  84. enRootIdMap[v.Id] = v.RootId
  85. }
  86. // 分页
  87. var startSize int
  88. if params.PageSize <= 0 {
  89. params.PageSize = utils.PageSize20
  90. }
  91. if params.CurrentIndex <= 0 {
  92. params.CurrentIndex = 1
  93. }
  94. startSize = utils.StartIndex(params.CurrentIndex, params.PageSize)
  95. resp := new(report_approve.ReportApproveListResp)
  96. respTotal := 0
  97. respList := make([]*report_approve.ReportApproveItem, 0)
  98. timeField := map[int]string{1: fmt.Sprintf("a.%s", report_approve.ReportApproveCols.CreateTime), 2: fmt.Sprintf("a.%s", report_approve.ReportApproveRecordCols.ApproveTime), 3: fmt.Sprintf("b.%s", report_approve.ReportApproveCols.ApproveTime)}
  99. mineTimeField := map[int]string{1: fmt.Sprintf("%s", report_approve.ReportApproveCols.CreateTime), 3: fmt.Sprintf("%s", report_approve.ReportApproveCols.ApproveTime)}
  100. orderRules := map[int]string{1: "ASC", 2: "DESC"}
  101. ormList := make([]*report_approve.ReportApproveItemOrm, 0)
  102. // 待处理
  103. if params.ListType == 1 {
  104. cond := fmt.Sprintf(` AND a.%s = ? AND b.%s = ? AND a.%s = ?`, report_approve.ReportApproveRecordCols.State, report_approve.ReportApproveCols.State, report_approve.ReportApproveRecordCols.ApproveUserId)
  105. pars := make([]interface{}, 0)
  106. pars = append(pars, report_approve.ReportApproveStateApproving, report_approve.ReportApproveStateApproving, sysUser.AdminId)
  107. order := ""
  108. // 筛选条件
  109. if params.ReportType > 0 && params.ClassifySecondId > 0 {
  110. cond += fmt.Sprintf(` AND b.%s = ? AND b.%s = ?`, report_approve.ReportApproveCols.ReportType, report_approve.ReportApproveCols.ClassifySecondId)
  111. pars = append(pars, params.ReportType, params.ClassifySecondId)
  112. }
  113. if params.TimeType <= 0 {
  114. params.TimeType = 1
  115. }
  116. if params.TimeType == 1 && params.StartTime != "" && params.EndTime != "" {
  117. _, e := time.Parse(utils.FormatDate, params.StartTime)
  118. if e != nil {
  119. br.Msg = "开始时间格式有误"
  120. return
  121. }
  122. _, e = time.Parse(utils.FormatDate, params.EndTime)
  123. if e != nil {
  124. br.Msg = "结束时间格式有误"
  125. return
  126. }
  127. st := fmt.Sprintf("%s %s", params.StartTime, "00:00:00")
  128. ed := fmt.Sprintf("%s %s", params.EndTime, "23:59:59")
  129. cond += fmt.Sprintf(` AND (b.%s BETWEEN ? AND ?)`, report_approve.ReportApproveCols.CreateTime)
  130. pars = append(pars, st, ed)
  131. }
  132. params.Keyword = strings.TrimSpace(params.Keyword)
  133. if params.Keyword != "" {
  134. kw := fmt.Sprint("%", params.Keyword, "%")
  135. cond += fmt.Sprintf(` AND b.%s LIKE ?`, report_approve.ReportApproveCols.ReportTitle)
  136. pars = append(pars, kw)
  137. }
  138. if params.SortField > 0 && params.SortRule > 0 {
  139. orderField := timeField[params.SortField]
  140. if orderField == "" {
  141. br.Msg = "时间排序字段有误"
  142. return
  143. }
  144. orderRule := orderRules[params.SortRule]
  145. if orderRule == "" {
  146. br.Msg = "时间排序方式有误"
  147. return
  148. }
  149. order = fmt.Sprintf("%s %s", orderField, orderRule)
  150. }
  151. total, e := report_approve.GetApprovingReportApproveCount(cond, pars)
  152. if e != nil {
  153. br.Msg = "获取失败"
  154. br.ErrMsg = "GetApprovingReportApproveCount err: " + e.Error()
  155. return
  156. }
  157. respTotal = total
  158. list, e := report_approve.GetApprovingReportApprovePageList(cond, pars, order, startSize, params.PageSize)
  159. if e != nil {
  160. br.Msg = "获取失败"
  161. br.ErrMsg = "GetApprovingReportApprovePageList err: " + e.Error()
  162. return
  163. }
  164. ormList = list
  165. }
  166. // 已处理
  167. if params.ListType == 2 {
  168. cond := fmt.Sprintf(` AND a.%s = ? AND a.%s IN (%s)`, report_approve.ReportApproveRecordCols.ApproveUserId, report_approve.ReportApproveRecordCols.NodeState, utils.GetOrmInReplace(2))
  169. pars := make([]interface{}, 0)
  170. pars = append(pars, sysUser.AdminId, []int{report_approve.ReportApproveStatePass, report_approve.ReportApproveStateRefuse})
  171. order := ""
  172. // 筛选条件
  173. if params.ReportType > 0 && params.ClassifySecondId > 0 {
  174. cond += fmt.Sprintf(` AND b.%s = ? AND b.%s = ?`, report_approve.ReportApproveCols.ReportType, report_approve.ReportApproveCols.ClassifySecondId)
  175. pars = append(pars, params.ReportType, params.ClassifySecondId)
  176. }
  177. if params.TimeType > 0 && params.StartTime != "" && params.EndTime != "" {
  178. _, e := time.Parse(utils.FormatDate, params.StartTime)
  179. if e != nil {
  180. br.Msg = "开始时间格式有误"
  181. return
  182. }
  183. _, e = time.Parse(utils.FormatDate, params.EndTime)
  184. if e != nil {
  185. br.Msg = "结束时间格式有误"
  186. return
  187. }
  188. st := fmt.Sprintf("%s %s", params.StartTime, "00:00:00")
  189. ed := fmt.Sprintf("%s %s", params.EndTime, "23:59:59")
  190. cond += fmt.Sprintf(` AND (%s BETWEEN ? AND ?)`, timeField[params.TimeType])
  191. pars = append(pars, st, ed)
  192. }
  193. params.Keyword = strings.TrimSpace(params.Keyword)
  194. if params.Keyword != "" {
  195. kw := fmt.Sprint("%", params.Keyword, "%")
  196. cond += fmt.Sprintf(` AND b.%s LIKE ?`, report_approve.ReportApproveCols.ReportTitle)
  197. pars = append(pars, kw)
  198. }
  199. if params.SortField > 0 && params.SortRule > 0 {
  200. orderField := timeField[params.SortField]
  201. if orderField == "" {
  202. br.Msg = "时间排序字段有误"
  203. return
  204. }
  205. orderRule := orderRules[params.SortRule]
  206. if orderRule == "" {
  207. br.Msg = "时间排序方式有误"
  208. return
  209. }
  210. order = fmt.Sprintf("%s %s", orderField, orderRule)
  211. }
  212. if params.ApproveState > 0 {
  213. cond += fmt.Sprintf(` AND a.%s = ?`, report_approve.ReportApproveRecordCols.State)
  214. pars = append(pars, params.ApproveState)
  215. }
  216. total, e := report_approve.GetApprovedReportApproveCount(cond, pars)
  217. if e != nil {
  218. br.Msg = "获取失败"
  219. br.ErrMsg = "GetApprovedReportApproveCount err: " + e.Error()
  220. return
  221. }
  222. respTotal = total
  223. list, e := report_approve.GetApprovedReportApprovePageList(cond, pars, order, startSize, params.PageSize)
  224. if e != nil {
  225. br.Msg = "获取失败"
  226. br.ErrMsg = "GetApprovedReportApprovePageList err: " + e.Error()
  227. return
  228. }
  229. for _, v := range list {
  230. // 这个时候的状态,用审批状态
  231. v.RecordState = v.NodeState
  232. v.ApproveTime = v.NodeApproveTime
  233. }
  234. ormList = list
  235. }
  236. // 我发起的
  237. if params.ListType == 3 {
  238. cond := fmt.Sprintf(` AND a.%s = ?`, report_approve.ReportApproveCols.ApplyUserId)
  239. pars := make([]interface{}, 0)
  240. pars = append(pars, sysUser.AdminId)
  241. order := ""
  242. // 筛选条件
  243. if params.ReportType > 0 && params.ClassifySecondId > 0 {
  244. cond += fmt.Sprintf(` AND a.%s = ? AND a.%s = ?`, report_approve.ReportApproveCols.ReportType, report_approve.ReportApproveCols.ClassifySecondId)
  245. pars = append(pars, params.ReportType, params.ClassifySecondId)
  246. }
  247. if params.TimeType > 0 && params.StartTime != "" && params.EndTime != "" {
  248. _, e := time.Parse(utils.FormatDate, params.StartTime)
  249. if e != nil {
  250. br.Msg = "开始时间格式有误"
  251. return
  252. }
  253. _, e = time.Parse(utils.FormatDate, params.EndTime)
  254. if e != nil {
  255. br.Msg = "结束时间格式有误"
  256. return
  257. }
  258. st := fmt.Sprintf("%s %s", params.StartTime, "00:00:00")
  259. ed := fmt.Sprintf("%s %s", params.EndTime, "23:59:59")
  260. field := mineTimeField[params.TimeType]
  261. if field == "" {
  262. br.Msg = "筛选时间有误"
  263. return
  264. }
  265. cond += fmt.Sprintf(` AND (%s BETWEEN ? AND ?)`, field)
  266. pars = append(pars, st, ed)
  267. }
  268. params.Keyword = strings.TrimSpace(params.Keyword)
  269. if params.Keyword != "" {
  270. kw := fmt.Sprint("%", params.Keyword, "%")
  271. cond += fmt.Sprintf(` AND a.%s LIKE ?`, report_approve.ReportApproveCols.ReportTitle)
  272. pars = append(pars, kw)
  273. }
  274. if params.SortField > 0 && params.SortRule > 0 {
  275. orderField := mineTimeField[params.SortField]
  276. if orderField == "" {
  277. br.Msg = "时间排序字段有误"
  278. return
  279. }
  280. orderRule := orderRules[params.SortRule]
  281. if orderRule == "" {
  282. br.Msg = "时间排序方式有误"
  283. return
  284. }
  285. order = fmt.Sprintf("%s %s", orderField, orderRule)
  286. }
  287. if params.ApproveState > 0 {
  288. cond += fmt.Sprintf(` AND a.%s = ?`, report_approve.ReportApproveRecordCols.State)
  289. pars = append(pars, params.ApproveState)
  290. }
  291. total, e := report_approve.GetApplyReportApproveCount(cond, pars)
  292. if e != nil {
  293. br.Msg = "获取失败"
  294. br.ErrMsg = "GetApplyReportApproveCount err: " + e.Error()
  295. return
  296. }
  297. respTotal = total
  298. list, e := report_approve.GetApplyReportApprovePageList(cond, pars, order, startSize, params.PageSize)
  299. if e != nil {
  300. br.Msg = "获取失败"
  301. br.ErrMsg = "GetApplyReportApprovePageList err: " + e.Error()
  302. return
  303. }
  304. ormList = list
  305. }
  306. // 格式化列表
  307. for _, v := range ormList {
  308. t := report_approve.FormatReportApproveOrm2Item(v)
  309. if v.ReportType == report_approve.FlowReportTypeEnglish {
  310. t.ReportClassify = fmt.Sprintf("%s/%s/%s/%s", report_approve.FlowReportTypeMap[v.ReportType], enClassifyIdName[enRootIdMap[v.ClassifySecondId]], enClassifyIdName[v.ClassifyFirstId], enClassifyIdName[v.ClassifySecondId])
  311. } else {
  312. //t.ReportClassify = fmt.Sprintf("%s/%s/%s", report_approve.FlowReportTypeMap[v.ReportType], cnClassifyIdName[v.ClassifyFirstId], cnClassifyIdName[v.ClassifySecondId])
  313. reportClassify := fmt.Sprintf("%s/%s", report_approve.FlowReportTypeMap[v.ReportType], cnClassifyIdName[v.ClassifyFirstId])
  314. if v.ClassifySecondId > 0 {
  315. reportClassify = fmt.Sprintf("%s/%s", reportClassify, cnClassifyIdName[v.ClassifySecondId])
  316. }
  317. if v.ClassifyThirdId > 0 {
  318. reportClassify = fmt.Sprintf("%s/%s", reportClassify, cnClassifyIdName[v.ClassifyThirdId])
  319. }
  320. t.ReportClassify = reportClassify
  321. }
  322. respList = append(respList, t)
  323. }
  324. page := paging.GetPaging(params.CurrentIndex, params.PageSize, respTotal)
  325. resp.Paging = page
  326. resp.List = respList
  327. br.Data = resp
  328. br.Ret = 200
  329. br.Success = true
  330. br.Msg = "获取成功"
  331. }
  332. // Detail
  333. // @Title 审批详情
  334. // @Description 审批详情
  335. // @Param ReportApproveId query int true "审批ID"
  336. // @Success 200 {object} report_approve.ReportApproveDetail
  337. // @router /detail [get]
  338. func (this *ReportApproveController) Detail() {
  339. br := new(models.BaseResponse).Init()
  340. defer func() {
  341. if br.ErrMsg == "" {
  342. br.IsSendEmail = false
  343. }
  344. this.Data["json"] = br
  345. this.ServeJSON()
  346. }()
  347. sysUser := this.SysUser
  348. if sysUser == nil {
  349. br.Msg = "请登录"
  350. br.ErrMsg = "请登录,SysUser Is Empty"
  351. br.Ret = 408
  352. return
  353. }
  354. approveId, _ := this.GetInt("ReportApproveId")
  355. if approveId <= 0 {
  356. br.Msg = "参数有误"
  357. br.ErrMsg = fmt.Sprintf("参数有误, ReportApproveId: %d", approveId)
  358. return
  359. }
  360. approveOb := new(report_approve.ReportApprove)
  361. approveItem, e := approveOb.GetItemById(approveId)
  362. if e != nil {
  363. if e.Error() == utils.ErrNoRow() {
  364. br.Msg = "审批已被删除, 请刷新页面"
  365. return
  366. }
  367. br.Msg = "获取失败"
  368. br.ErrMsg = "获取审批失败, Err: " + e.Error()
  369. return
  370. }
  371. // 审批信息
  372. detail := new(report_approve.ReportApproveDetail)
  373. detail.Approve = new(report_approve.ReportApproveDetailItem)
  374. detail.Approve.ReportApproveId = approveItem.ReportApproveId
  375. detail.Approve.State = approveItem.State
  376. detail.Approve.FlowId = approveItem.FlowId
  377. detail.Approve.FlowVersion = approveItem.FlowVersion
  378. detail.Approve.StartNodeId = approveItem.StartNodeId
  379. detail.Approve.CurrNodeId = approveItem.CurrNodeId
  380. detail.Approve.ApplyUserId = approveItem.ApplyUserId
  381. detail.Approve.ApplyUserName = approveItem.ApplyUserName
  382. detail.Approve.ApproveTime = utils.TimeTransferString(utils.FormatDateTime, approveItem.ApproveTime)
  383. detail.Approve.CreateTime = utils.TimeTransferString(utils.FormatDateTime, approveItem.CreateTime)
  384. detail.Approve.ModifyTime = utils.TimeTransferString(utils.FormatDateTime, approveItem.ModifyTime)
  385. // 审批流
  386. //flowOb := new(report_approve.ReportApproveFlow)
  387. //flowItem, e := flowOb.GetItemById(approveItem.FlowId)
  388. //if e != nil {
  389. // if e.Error() == utils.ErrNoRow() {
  390. // br.Msg = "审批流已被删除, 请刷新页面"
  391. // return
  392. // }
  393. // br.Msg = "获取失败"
  394. // br.ErrMsg = "获取审批流失败, Err: " + e.Error()
  395. // return
  396. //}
  397. //detail.ApproveFlow = report_approve.FormatReportApproveFlow2Item(flowItem)
  398. // 审批节点
  399. nodeOb := new(report_approve.ReportApproveNode)
  400. nodeCond := fmt.Sprintf(` AND %s = ? AND %s = ?`, report_approve.ReportApproveNodeCols.ReportApproveFlowId, report_approve.ReportApproveNodeCols.CurrVersion)
  401. nodePars := make([]interface{}, 0)
  402. nodePars = append(nodePars, approveItem.FlowId, approveItem.FlowVersion)
  403. nodeItems, e := nodeOb.GetItemsByCondition(nodeCond, nodePars, []string{}, "")
  404. if e != nil {
  405. br.Msg = "获取失败"
  406. br.ErrMsg = "获取审批节点失败, Err: " + e.Error()
  407. return
  408. }
  409. // 审批记录
  410. recordOb := new(report_approve.ReportApproveRecord)
  411. recordCond := fmt.Sprintf(` AND %s = ?`, report_approve.ReportApproveRecordCols.ReportApproveId)
  412. recordPars := make([]interface{}, 0)
  413. recordPars = append(recordPars, approveItem.ReportApproveId)
  414. recordItems, e := recordOb.GetItemsByCondition(recordCond, recordPars, []string{}, fmt.Sprintf("%s DESC", report_approve.ReportApproveRecordCols.ApproveTime))
  415. if e != nil {
  416. br.Msg = "获取失败"
  417. br.ErrMsg = "获取审批记录失败, Err: " + e.Error()
  418. return
  419. }
  420. recordMap := make(map[string]*report_approve.ReportApproveRecord)
  421. for _, v := range recordItems {
  422. k := fmt.Sprintf("%d-%d", v.NodeId, v.ApproveUserId)
  423. recordMap[k] = v
  424. }
  425. // 审批流节点详情
  426. detail.ApproveFlowNodes = make([]*report_approve.ReportApproveDetailNodes, 0)
  427. for _, v := range nodeItems {
  428. t := new(report_approve.ReportApproveDetailNodes)
  429. t.ReportApproveNodeId = v.ReportApproveNodeId
  430. t.ReportApproveFlowId = v.ReportApproveFlowId
  431. t.PrevNodeId = v.PrevNodeId
  432. t.NextNodeId = v.NextNodeId
  433. t.NodeType = v.NodeType
  434. t.ApproveType = v.ApproveType
  435. t.Users = make([]*report_approve.ReportApproveDetailNodeUser, 0)
  436. us := make([]*report_approve.ReportApproveNodeUserReq, 0)
  437. if v.Users != "" {
  438. e = json.Unmarshal([]byte(v.Users), &us)
  439. if e != nil {
  440. br.Msg = "获取失败"
  441. br.ErrMsg = "节点用户解析失败, Err: " + e.Error()
  442. return
  443. }
  444. }
  445. for _, vu := range us {
  446. u := new(report_approve.ReportApproveDetailNodeUser)
  447. u.UserType = vu.UserType
  448. u.UserId = vu.UserId
  449. u.UserName = vu.UserName
  450. u.Sort = vu.Sort
  451. // 审批记录
  452. k := fmt.Sprintf("%d-%d", v.ReportApproveNodeId, vu.UserId)
  453. r := recordMap[k]
  454. if r != nil {
  455. u.ApproveRecord = new(report_approve.ReportApproveDetailNodeUserRecord)
  456. u.ApproveRecord.ReportApproveRecordId = r.ReportApproveRecordId
  457. u.ApproveRecord.State = r.State
  458. u.ApproveRecord.ApproveUserId = r.ApproveUserId
  459. u.ApproveRecord.ApproveUserName = r.ApproveUserName
  460. u.ApproveRecord.ApproveRemark = r.ApproveRemark
  461. u.ApproveRecord.ApproveTime = utils.TimeTransferString(utils.FormatDateTime, r.ApproveTime)
  462. }
  463. t.Users = append(t.Users, u)
  464. }
  465. sort.Slice(t.Users, func(k, j int) bool {
  466. return t.Users[k].Sort < t.Users[j].Sort
  467. })
  468. detail.ApproveFlowNodes = append(detail.ApproveFlowNodes, t)
  469. }
  470. // 报告信息
  471. cnClassifyIdName, enClassifyIdName := make(map[int]string), make(map[int]string)
  472. cnClassify, e := models.GetAllClassify()
  473. if e != nil {
  474. br.Msg = "获取失败"
  475. br.ErrMsg = "获取中文分类失败, Err: " + e.Error()
  476. return
  477. }
  478. for _, v := range cnClassify {
  479. cnClassifyIdName[v.Id] = v.ClassifyName
  480. }
  481. enClassify, e := models.GetEnglishClassifies()
  482. if e != nil {
  483. br.Msg = "获取失败"
  484. br.ErrMsg = "获取英文分类失败, Err: " + e.Error()
  485. return
  486. }
  487. enRootIdMap := make(map[int]int) // 英文分类的一级分类ID
  488. for _, v := range enClassify {
  489. enClassifyIdName[v.Id] = v.ClassifyName
  490. enRootIdMap[v.Id] = v.RootId
  491. }
  492. detail.Report = new(report_approve.ReportApproveDetailReport)
  493. detail.Report.ReportType = approveItem.ReportType
  494. detail.Report.ReportId = approveItem.ReportId
  495. detail.Report.ReportTitle = approveItem.ReportTitle
  496. detail.Report.ReportLayout = 1
  497. // 报告分类路由
  498. if approveItem.ReportType == report_approve.FlowReportTypeChinese {
  499. reportInfo, e := models.GetReportLayoutByReportId(approveItem.ReportId)
  500. if e != nil {
  501. br.Msg = "获取失败"
  502. br.ErrMsg = "获取报告失败, Err: " + e.Error()
  503. return
  504. }
  505. detail.Report.ReportLayout = reportInfo.ReportLayout
  506. detail.Report.ReportCode = utils.MD5(strconv.Itoa(approveItem.ReportId))
  507. detail.Report.ReportClassify = fmt.Sprintf("%s/%s/%s", report_approve.FlowReportTypeMap[approveItem.ReportType], cnClassifyIdName[approveItem.ClassifyFirstId], cnClassifyIdName[approveItem.ClassifySecondId])
  508. }
  509. if approveItem.ReportType == report_approve.FlowReportTypeEnglish {
  510. detail.Report.ReportCode = utils.MD5(strconv.Itoa(approveItem.ReportId))
  511. detail.Report.ReportClassify = fmt.Sprintf("%s/%s/%s/%s", report_approve.FlowReportTypeMap[approveItem.ReportType], enClassifyIdName[enRootIdMap[approveItem.ClassifySecondId]], enClassifyIdName[approveItem.ClassifyFirstId], enClassifyIdName[approveItem.ClassifySecondId])
  512. }
  513. if approveItem.ReportType == report_approve.FlowReportTypeSmart {
  514. detail.Report.ReportLayout = 2
  515. detail.Report.ReportCode = utils.MD5(fmt.Sprint("smart_", approveItem.ReportId))
  516. detail.Report.ReportClassify = fmt.Sprintf("%s/%s/%s", report_approve.FlowReportTypeMap[approveItem.ReportType], cnClassifyIdName[approveItem.ClassifyFirstId], cnClassifyIdName[approveItem.ClassifySecondId])
  517. }
  518. br.Data = detail
  519. br.Ret = 200
  520. br.Success = true
  521. br.Msg = "获取成功"
  522. }
  523. // Approve
  524. // @Title 通过审批
  525. // @Description 通过审批
  526. // @Param request body report_approve.ReportApprovePassReq true "type json string"
  527. // @Success 200 string "操作成功"
  528. // @router /approve [post]
  529. func (this *ReportApproveController) Approve() {
  530. br := new(models.BaseResponse).Init()
  531. defer func() {
  532. if br.ErrMsg == "" {
  533. br.IsSendEmail = false
  534. }
  535. this.Data["json"] = br
  536. this.ServeJSON()
  537. }()
  538. sysUser := this.SysUser
  539. if sysUser == nil {
  540. br.Msg = "请登录"
  541. br.ErrMsg = "请登录,SysUser Is Empty"
  542. br.Ret = 408
  543. return
  544. }
  545. var req report_approve.ReportApprovePassReq
  546. if e := json.Unmarshal(this.Ctx.Input.RequestBody, &req); e != nil {
  547. br.Msg = "参数有误"
  548. br.ErrMsg = "参数解析失败, Err: " + e.Error()
  549. return
  550. }
  551. if req.ReportApproveId <= 0 {
  552. br.Msg = "参数有误"
  553. br.ErrMsg = fmt.Sprintf("参数有误, ReportApproveId: %d", req.ReportApproveId)
  554. return
  555. }
  556. approveOb := new(report_approve.ReportApprove)
  557. approveItem, e := approveOb.GetItemById(req.ReportApproveId)
  558. if e != nil {
  559. if e.Error() == utils.ErrNoRow() {
  560. br.Msg = "审批不存在, 请刷新页面"
  561. return
  562. }
  563. br.Msg = "操作失败"
  564. br.ErrMsg = "获取审批信息失败, Err: " + e.Error()
  565. return
  566. }
  567. if approveItem.State != report_approve.ReportApproveStateApproving {
  568. br.Msg = "审批状态有误, 请刷新页面"
  569. br.ErrMsg = fmt.Sprintf("审批状态有误, State: %d", approveItem.State)
  570. return
  571. }
  572. // 校验审批记录和审批
  573. recordOb := new(report_approve.ReportApproveRecord)
  574. recordCond := fmt.Sprintf(` AND %s = ? AND %s = ? AND %s = ?`, report_approve.ReportApproveRecordCols.ReportApproveId, report_approve.ReportApproveRecordCols.ApproveUserId, report_approve.ReportApproveRecordCols.State)
  575. recordPars := make([]interface{}, 0)
  576. recordPars = append(recordPars, approveItem.ReportApproveId, sysUser.AdminId, report_approve.ReportApproveStateApproving)
  577. recordItem, e := recordOb.GetItemByCondition(recordCond, recordPars, "")
  578. if e != nil {
  579. if e.Error() == utils.ErrNoRow() {
  580. br.Msg = "无权审批"
  581. return
  582. }
  583. br.Msg = "操作失败"
  584. br.ErrMsg = "获取审批记录失败, Err: " + e.Error()
  585. return
  586. }
  587. // 通过审批
  588. tips, e := services.PassReportApprove(approveItem, recordItem, sysUser.AdminId, req.ReportUrl)
  589. if e != nil {
  590. br.Msg = "操作失败"
  591. br.ErrMsg = "通过审批失败, Err: " + e.Error()
  592. return
  593. }
  594. if tips != "" {
  595. br.Msg = tips
  596. return
  597. }
  598. br.Ret = 200
  599. br.Success = true
  600. br.Msg = "操作成功"
  601. }
  602. // Refuse
  603. // @Title 驳回审批
  604. // @Description 驳回审批
  605. // @Param request body report_approve.ReportApproveRefuseReq true "type json string"
  606. // @Success 200 string "操作成功"
  607. // @router /refuse [post]
  608. func (this *ReportApproveController) Refuse() {
  609. br := new(models.BaseResponse).Init()
  610. defer func() {
  611. if br.ErrMsg == "" {
  612. br.IsSendEmail = false
  613. }
  614. this.Data["json"] = br
  615. this.ServeJSON()
  616. }()
  617. sysUser := this.SysUser
  618. if sysUser == nil {
  619. br.Msg = "请登录"
  620. br.ErrMsg = "请登录,SysUser Is Empty"
  621. br.Ret = 408
  622. return
  623. }
  624. var req report_approve.ReportApproveRefuseReq
  625. if e := json.Unmarshal(this.Ctx.Input.RequestBody, &req); e != nil {
  626. br.Msg = "参数有误"
  627. br.ErrMsg = "参数解析失败, Err: " + e.Error()
  628. return
  629. }
  630. if req.ReportApproveId <= 0 {
  631. br.Msg = "参数有误"
  632. br.ErrMsg = fmt.Sprintf("参数有误, ReportApproveId: %d", req.ReportApproveId)
  633. return
  634. }
  635. approveOb := new(report_approve.ReportApprove)
  636. approveItem, e := approveOb.GetItemById(req.ReportApproveId)
  637. if e != nil {
  638. if e.Error() == utils.ErrNoRow() {
  639. br.Msg = "审批不存在, 请刷新页面"
  640. return
  641. }
  642. br.Msg = "操作失败"
  643. br.ErrMsg = "获取审批信息失败, Err: " + e.Error()
  644. return
  645. }
  646. if approveItem.State != report_approve.ReportApproveStateApproving {
  647. br.Msg = "审批状态有误, 请刷新页面"
  648. br.ErrMsg = fmt.Sprintf("审批状态有误, State: %d", approveItem.State)
  649. return
  650. }
  651. // 校验审批记录和审批
  652. recordOb := new(report_approve.ReportApproveRecord)
  653. recordCond := fmt.Sprintf(` AND %s = ? AND %s = ? AND %s = ?`, report_approve.ReportApproveRecordCols.ReportApproveId, report_approve.ReportApproveRecordCols.ApproveUserId, report_approve.ReportApproveRecordCols.State)
  654. recordPars := make([]interface{}, 0)
  655. recordPars = append(recordPars, approveItem.ReportApproveId, sysUser.AdminId, report_approve.ReportApproveStateApproving)
  656. recordItem, e := recordOb.GetItemByCondition(recordCond, recordPars, "")
  657. if e != nil {
  658. if e.Error() == utils.ErrNoRow() {
  659. br.Msg = "无权审批"
  660. return
  661. }
  662. br.Msg = "操作失败"
  663. br.ErrMsg = "获取审批记录失败, Err: " + e.Error()
  664. return
  665. }
  666. // 驳回审批
  667. if e = services.RefuseReportApprove(approveItem, recordItem, req.ApproveRemark, sysUser.AdminId); e != nil {
  668. br.Msg = "操作失败"
  669. br.ErrMsg = "驳回审批失败, Err: " + e.Error()
  670. return
  671. }
  672. br.Ret = 200
  673. br.Success = true
  674. br.Msg = "操作成功"
  675. }
  676. // Cancel
  677. // @Title 撤销审批
  678. // @Description 撤销审批
  679. // @Param request body report_approve.ReportApproveCancelReq true "type json string"
  680. // @Success 200 string "操作成功"
  681. // @router /cancel [post]
  682. func (this *ReportApproveController) Cancel() {
  683. br := new(models.BaseResponse).Init()
  684. defer func() {
  685. if br.ErrMsg == "" {
  686. br.IsSendEmail = false
  687. }
  688. this.Data["json"] = br
  689. this.ServeJSON()
  690. }()
  691. sysUser := this.SysUser
  692. if sysUser == nil {
  693. br.Msg = "请登录"
  694. br.ErrMsg = "请登录,SysUser Is Empty"
  695. br.Ret = 408
  696. return
  697. }
  698. var req report_approve.ReportApproveCancelReq
  699. if e := json.Unmarshal(this.Ctx.Input.RequestBody, &req); e != nil {
  700. br.Msg = "参数有误"
  701. br.ErrMsg = "参数解析失败, Err: " + e.Error()
  702. return
  703. }
  704. if req.ReportApproveId <= 0 {
  705. br.Msg = "参数有误"
  706. br.ErrMsg = fmt.Sprintf("参数有误, ReportApproveId: %d", req.ReportApproveId)
  707. return
  708. }
  709. approveOb := new(report_approve.ReportApprove)
  710. approveItem, e := approveOb.GetItemById(req.ReportApproveId)
  711. if e != nil {
  712. if e.Error() == utils.ErrNoRow() {
  713. br.Msg = "审批已被删除, 请刷新页面"
  714. return
  715. }
  716. br.Msg = "操作失败"
  717. br.ErrMsg = "获取审批失败, Err: " + e.Error()
  718. return
  719. }
  720. if approveItem.ApplyUserId != sysUser.AdminId {
  721. br.Msg = "非申请人不可撤销"
  722. return
  723. }
  724. // 撤销审批
  725. e = services.CancelReportApprove(approveItem.ReportType, approveItem.ReportId, approveItem.ReportApproveId, sysUser.AdminId, sysUser.RealName)
  726. if e != nil {
  727. br.Msg = "操作失败"
  728. br.ErrMsg = "撤销审批失败, Err: " + e.Error()
  729. return
  730. }
  731. br.Ret = 200
  732. br.Success = true
  733. br.Msg = "操作成功"
  734. }
  735. // MessageList
  736. // @Title 审批消息列表
  737. // @Description 审批消息列表
  738. // @Param PageSize query int true "每页数据条数"
  739. // @Param CurrentIndex query int true "当前页页码"
  740. // @Success 200 {object} report_approve.ReportApproveMessageListResp
  741. // @router /message/list [get]
  742. func (this *ReportApproveController) MessageList() {
  743. br := new(models.BaseResponse).Init()
  744. defer func() {
  745. if br.ErrMsg == "" {
  746. br.IsSendEmail = false
  747. }
  748. this.Data["json"] = br
  749. this.ServeJSON()
  750. }()
  751. sysUser := this.SysUser
  752. if sysUser == nil {
  753. br.Msg = "请登录"
  754. br.ErrMsg = "请登录,SysUser Is Empty"
  755. br.Ret = 408
  756. return
  757. }
  758. params := new(report_approve.ReportApproveListReq)
  759. if e := this.ParseForm(params); e != nil {
  760. br.Msg = "获取失败"
  761. br.ErrMsg = "入参解析失败, Err: " + e.Error()
  762. return
  763. }
  764. // 分页
  765. var startSize int
  766. if params.PageSize <= 0 {
  767. params.PageSize = utils.PageSize20
  768. }
  769. if params.CurrentIndex <= 0 {
  770. params.CurrentIndex = 1
  771. }
  772. startSize = utils.StartIndex(params.CurrentIndex, params.PageSize)
  773. resp := new(report_approve.ReportApproveMessageListResp)
  774. resp.List = make([]*report_approve.ReportApproveMessageItem, 0)
  775. cond := fmt.Sprintf(` AND %s = ?`, report_approve.ReportApproveMessageCols.ReceiveUserId)
  776. pars := make([]interface{}, 0)
  777. pars = append(pars, sysUser.AdminId)
  778. order := fmt.Sprintf(`%s ASC, %s DESC`, report_approve.ReportApproveMessageCols.IsRead, report_approve.ReportApproveMessageCols.CreateTime)
  779. messageOb := new(report_approve.ReportApproveMessage)
  780. total, e := messageOb.GetCountByCondition(cond, pars)
  781. if e != nil {
  782. br.Msg = "获取失败"
  783. br.ErrMsg = "获取审批消息列表总数失败, Err: " + e.Error()
  784. return
  785. }
  786. list, e := messageOb.GetPageItemsByCondition(cond, pars, []string{}, order, startSize, params.PageSize)
  787. if e != nil {
  788. br.Msg = "获取失败"
  789. br.ErrMsg = "获取审批消息列表失败, Err: " + e.Error()
  790. return
  791. }
  792. for _, v := range list {
  793. t := report_approve.FormatReportApproveMessage2Item(v)
  794. resp.List = append(resp.List, t)
  795. }
  796. // 未读消息数
  797. cond += fmt.Sprintf(` AND %s = ?`, report_approve.ReportApproveMessageCols.IsRead)
  798. pars = append(pars, 0)
  799. unreadTotal, e := messageOb.GetCountByCondition(cond, pars)
  800. if e != nil {
  801. br.Msg = "获取失败"
  802. br.ErrMsg = "获取审批消息列表总数失败, Err: " + e.Error()
  803. return
  804. }
  805. resp.UnreadTotal = unreadTotal
  806. page := paging.GetPaging(params.CurrentIndex, params.PageSize, total)
  807. resp.Paging = page
  808. br.Data = resp
  809. br.Ret = 200
  810. br.Success = true
  811. br.Msg = "获取成功"
  812. }
  813. // MessageRead
  814. // @Title 消息已读
  815. // @Description 消息已读
  816. // @Param request body report_approve.ReportApproveMessageReadReq true "type json string"
  817. // @Success 200 string "操作成功"
  818. // @router /message/read [post]
  819. func (this *ReportApproveController) MessageRead() {
  820. br := new(models.BaseResponse).Init()
  821. defer func() {
  822. if br.ErrMsg == "" {
  823. br.IsSendEmail = false
  824. }
  825. this.Data["json"] = br
  826. this.ServeJSON()
  827. }()
  828. sysUser := this.SysUser
  829. if sysUser == nil {
  830. br.Msg = "请登录"
  831. br.ErrMsg = "请登录,SysUser Is Empty"
  832. br.Ret = 408
  833. return
  834. }
  835. var req report_approve.ReportApproveMessageReadReq
  836. if e := json.Unmarshal(this.Ctx.Input.RequestBody, &req); e != nil {
  837. br.Msg = "参数有误"
  838. br.ErrMsg = "参数解析失败, Err: " + e.Error()
  839. return
  840. }
  841. if req.MessageId <= 0 {
  842. br.Msg = "参数有误"
  843. br.ErrMsg = fmt.Sprintf("参数有误, MessageId: %d", req.MessageId)
  844. return
  845. }
  846. messageOb := new(report_approve.ReportApproveMessage)
  847. messageItem, e := messageOb.GetItemById(req.MessageId)
  848. if e != nil {
  849. if e.Error() == utils.ErrNoRow() {
  850. br.Msg = "消息不存在, 请刷新页面"
  851. return
  852. }
  853. br.Msg = "获取失败"
  854. br.ErrMsg = "获取审批消息失败, Err: " + e.Error()
  855. return
  856. }
  857. messageItem.IsRead = 1
  858. messageItem.ModifyTime = time.Now().Local()
  859. cols := []string{"IsRead", "ModifyTime"}
  860. if e = messageItem.Update(cols); e != nil {
  861. br.Msg = "操作失败"
  862. br.ErrMsg = "更新审批消息已读失败, Err: " + e.Error()
  863. return
  864. }
  865. br.Ret = 200
  866. br.Success = true
  867. br.Msg = "操作成功"
  868. }
  869. // CheckApproveOpen
  870. // @Title 校验分类是否开启审批
  871. // @Description 校验分类是否开启审批
  872. // @Param request body report_approve.ReportApproveCheckApproveOpenReq true "type json string"
  873. // @Success 200 string "操作成功"
  874. // @router /classify/check_open [post]
  875. func (this *ReportApproveController) CheckApproveOpen() {
  876. br := new(models.BaseResponse).Init()
  877. defer func() {
  878. if br.ErrMsg == "" {
  879. br.IsSendEmail = false
  880. }
  881. this.Data["json"] = br
  882. this.ServeJSON()
  883. }()
  884. sysUser := this.SysUser
  885. if sysUser == nil {
  886. br.Msg = "请登录"
  887. br.ErrMsg = "请登录,SysUser Is Empty"
  888. br.Ret = 408
  889. return
  890. }
  891. var req report_approve.ReportApproveCheckApproveOpenReq
  892. if e := json.Unmarshal(this.Ctx.Input.RequestBody, &req); e != nil {
  893. br.Msg = "参数有误"
  894. br.ErrMsg = "参数解析失败, Err: " + e.Error()
  895. return
  896. }
  897. // 校验是否开启了审批流
  898. opening, e := services.CheckReportOpenApprove(req.ReportType, req.ClassifyFirstId, req.ClassifySecondId, req.ClassifyThirdId)
  899. if e != nil {
  900. br.Msg = "操作失败"
  901. br.ErrMsg = "校验报告是否开启审批流失败, Err: " + e.Error()
  902. return
  903. }
  904. br.Data = opening
  905. br.Ret = 200
  906. br.Success = true
  907. br.Msg = "操作成功"
  908. }