report_approve.go 32 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981
  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. cnReportIdList := make([]int, 0)
  307. for _, v := range ormList {
  308. if v.ReportType == report_approve.FlowReportTypeChinese {
  309. cnReportIdList = append(cnReportIdList, v.ReportId)
  310. }
  311. }
  312. reportLayoutMap := make(map[int]int8)
  313. if len(cnReportIdList) > 0 {
  314. layoutList, e := models.GetReportLayoutByReportIdList(cnReportIdList)
  315. if e != nil {
  316. br.Msg = "获取失败"
  317. br.ErrMsg = "GetReportLayoutByReportIdList err: " + e.Error()
  318. return
  319. }
  320. for _, v := range layoutList {
  321. reportLayoutMap[v.Id] = v.ReportLayout
  322. }
  323. }
  324. // 格式化列表
  325. for _, v := range ormList {
  326. t := report_approve.FormatReportApproveOrm2Item(v)
  327. if v.ReportType == report_approve.FlowReportTypeEnglish {
  328. t.ReportClassify = fmt.Sprintf("%s/%s/%s/%s", report_approve.FlowReportTypeMap[v.ReportType], enClassifyIdName[enRootIdMap[v.ClassifySecondId]], enClassifyIdName[v.ClassifyFirstId], enClassifyIdName[v.ClassifySecondId])
  329. } else {
  330. //t.ReportClassify = fmt.Sprintf("%s/%s/%s", report_approve.FlowReportTypeMap[v.ReportType], cnClassifyIdName[v.ClassifyFirstId], cnClassifyIdName[v.ClassifySecondId])
  331. reportClassify := fmt.Sprintf("%s/%s", report_approve.FlowReportTypeMap[v.ReportType], cnClassifyIdName[v.ClassifyFirstId])
  332. if v.ClassifySecondId > 0 {
  333. reportClassify = fmt.Sprintf("%s/%s", reportClassify, cnClassifyIdName[v.ClassifySecondId])
  334. }
  335. if v.ClassifyThirdId > 0 {
  336. reportClassify = fmt.Sprintf("%s/%s", reportClassify, cnClassifyIdName[v.ClassifyThirdId])
  337. }
  338. t.ReportClassify = reportClassify
  339. }
  340. // 布局方式
  341. {
  342. t.ReportLayout = 1
  343. if v.ReportType == report_approve.FlowReportTypeChinese {
  344. if layout, ok := reportLayoutMap[v.ReportId]; ok {
  345. t.ReportLayout = layout
  346. }
  347. }
  348. }
  349. respList = append(respList, t)
  350. }
  351. page := paging.GetPaging(params.CurrentIndex, params.PageSize, respTotal)
  352. resp.Paging = page
  353. resp.List = respList
  354. br.Data = resp
  355. br.Ret = 200
  356. br.Success = true
  357. br.Msg = "获取成功"
  358. }
  359. // Detail
  360. // @Title 审批详情
  361. // @Description 审批详情
  362. // @Param ReportApproveId query int true "审批ID"
  363. // @Success 200 {object} report_approve.ReportApproveDetail
  364. // @router /detail [get]
  365. func (this *ReportApproveController) Detail() {
  366. br := new(models.BaseResponse).Init()
  367. defer func() {
  368. if br.ErrMsg == "" {
  369. br.IsSendEmail = false
  370. }
  371. this.Data["json"] = br
  372. this.ServeJSON()
  373. }()
  374. sysUser := this.SysUser
  375. if sysUser == nil {
  376. br.Msg = "请登录"
  377. br.ErrMsg = "请登录,SysUser Is Empty"
  378. br.Ret = 408
  379. return
  380. }
  381. approveId, _ := this.GetInt("ReportApproveId")
  382. if approveId <= 0 {
  383. br.Msg = "参数有误"
  384. br.ErrMsg = fmt.Sprintf("参数有误, ReportApproveId: %d", approveId)
  385. return
  386. }
  387. approveOb := new(report_approve.ReportApprove)
  388. approveItem, e := approveOb.GetItemById(approveId)
  389. if e != nil {
  390. if e.Error() == utils.ErrNoRow() {
  391. br.Msg = "审批已被删除, 请刷新页面"
  392. return
  393. }
  394. br.Msg = "获取失败"
  395. br.ErrMsg = "获取审批失败, Err: " + e.Error()
  396. return
  397. }
  398. // 审批信息
  399. detail := new(report_approve.ReportApproveDetail)
  400. detail.Approve = new(report_approve.ReportApproveDetailItem)
  401. detail.Approve.ReportApproveId = approveItem.ReportApproveId
  402. detail.Approve.State = approveItem.State
  403. detail.Approve.FlowId = approveItem.FlowId
  404. detail.Approve.FlowVersion = approveItem.FlowVersion
  405. detail.Approve.StartNodeId = approveItem.StartNodeId
  406. detail.Approve.CurrNodeId = approveItem.CurrNodeId
  407. detail.Approve.ApplyUserId = approveItem.ApplyUserId
  408. detail.Approve.ApplyUserName = approveItem.ApplyUserName
  409. detail.Approve.ApproveTime = utils.TimeTransferString(utils.FormatDateTime, approveItem.ApproveTime)
  410. detail.Approve.CreateTime = utils.TimeTransferString(utils.FormatDateTime, approveItem.CreateTime)
  411. detail.Approve.ModifyTime = utils.TimeTransferString(utils.FormatDateTime, approveItem.ModifyTime)
  412. // 审批流
  413. //flowOb := new(report_approve.ReportApproveFlow)
  414. //flowItem, e := flowOb.GetItemById(approveItem.FlowId)
  415. //if e != nil {
  416. // if e.Error() == utils.ErrNoRow() {
  417. // br.Msg = "审批流已被删除, 请刷新页面"
  418. // return
  419. // }
  420. // br.Msg = "获取失败"
  421. // br.ErrMsg = "获取审批流失败, Err: " + e.Error()
  422. // return
  423. //}
  424. //detail.ApproveFlow = report_approve.FormatReportApproveFlow2Item(flowItem)
  425. // 审批节点
  426. nodeOb := new(report_approve.ReportApproveNode)
  427. nodeCond := fmt.Sprintf(` AND %s = ? AND %s = ?`, report_approve.ReportApproveNodeCols.ReportApproveFlowId, report_approve.ReportApproveNodeCols.CurrVersion)
  428. nodePars := make([]interface{}, 0)
  429. nodePars = append(nodePars, approveItem.FlowId, approveItem.FlowVersion)
  430. nodeItems, e := nodeOb.GetItemsByCondition(nodeCond, nodePars, []string{}, "")
  431. if e != nil {
  432. br.Msg = "获取失败"
  433. br.ErrMsg = "获取审批节点失败, Err: " + e.Error()
  434. return
  435. }
  436. // 审批记录
  437. recordOb := new(report_approve.ReportApproveRecord)
  438. recordCond := fmt.Sprintf(` AND %s = ?`, report_approve.ReportApproveRecordCols.ReportApproveId)
  439. recordPars := make([]interface{}, 0)
  440. recordPars = append(recordPars, approveItem.ReportApproveId)
  441. recordItems, e := recordOb.GetItemsByCondition(recordCond, recordPars, []string{}, fmt.Sprintf("%s DESC", report_approve.ReportApproveRecordCols.ApproveTime))
  442. if e != nil {
  443. br.Msg = "获取失败"
  444. br.ErrMsg = "获取审批记录失败, Err: " + e.Error()
  445. return
  446. }
  447. recordMap := make(map[string]*report_approve.ReportApproveRecord)
  448. for _, v := range recordItems {
  449. k := fmt.Sprintf("%d-%d", v.NodeId, v.ApproveUserId)
  450. recordMap[k] = v
  451. }
  452. // 审批流节点详情
  453. detail.ApproveFlowNodes = make([]*report_approve.ReportApproveDetailNodes, 0)
  454. for _, v := range nodeItems {
  455. t := new(report_approve.ReportApproveDetailNodes)
  456. t.ReportApproveNodeId = v.ReportApproveNodeId
  457. t.ReportApproveFlowId = v.ReportApproveFlowId
  458. t.PrevNodeId = v.PrevNodeId
  459. t.NextNodeId = v.NextNodeId
  460. t.NodeType = v.NodeType
  461. t.ApproveType = v.ApproveType
  462. t.Users = make([]*report_approve.ReportApproveDetailNodeUser, 0)
  463. us := make([]*report_approve.ReportApproveNodeUserReq, 0)
  464. if v.Users != "" {
  465. e = json.Unmarshal([]byte(v.Users), &us)
  466. if e != nil {
  467. br.Msg = "获取失败"
  468. br.ErrMsg = "节点用户解析失败, Err: " + e.Error()
  469. return
  470. }
  471. }
  472. for _, vu := range us {
  473. u := new(report_approve.ReportApproveDetailNodeUser)
  474. u.UserType = vu.UserType
  475. u.UserId = vu.UserId
  476. u.UserName = vu.UserName
  477. u.Sort = vu.Sort
  478. // 审批记录
  479. k := fmt.Sprintf("%d-%d", v.ReportApproveNodeId, vu.UserId)
  480. r := recordMap[k]
  481. if r != nil {
  482. u.ApproveRecord = new(report_approve.ReportApproveDetailNodeUserRecord)
  483. u.ApproveRecord.ReportApproveRecordId = r.ReportApproveRecordId
  484. u.ApproveRecord.State = r.State
  485. u.ApproveRecord.ApproveUserId = r.ApproveUserId
  486. u.ApproveRecord.ApproveUserName = r.ApproveUserName
  487. u.ApproveRecord.ApproveRemark = r.ApproveRemark
  488. u.ApproveRecord.ApproveTime = utils.TimeTransferString(utils.FormatDateTime, r.ApproveTime)
  489. }
  490. t.Users = append(t.Users, u)
  491. }
  492. sort.Slice(t.Users, func(k, j int) bool {
  493. return t.Users[k].Sort < t.Users[j].Sort
  494. })
  495. detail.ApproveFlowNodes = append(detail.ApproveFlowNodes, t)
  496. }
  497. // 报告信息
  498. cnClassifyIdName, enClassifyIdName := make(map[int]string), make(map[int]string)
  499. cnClassify, e := models.GetAllClassify()
  500. if e != nil {
  501. br.Msg = "获取失败"
  502. br.ErrMsg = "获取中文分类失败, Err: " + e.Error()
  503. return
  504. }
  505. for _, v := range cnClassify {
  506. cnClassifyIdName[v.Id] = v.ClassifyName
  507. }
  508. enClassify, e := models.GetEnglishClassifies()
  509. if e != nil {
  510. br.Msg = "获取失败"
  511. br.ErrMsg = "获取英文分类失败, Err: " + e.Error()
  512. return
  513. }
  514. enRootIdMap := make(map[int]int) // 英文分类的一级分类ID
  515. for _, v := range enClassify {
  516. enClassifyIdName[v.Id] = v.ClassifyName
  517. enRootIdMap[v.Id] = v.RootId
  518. }
  519. detail.Report = new(report_approve.ReportApproveDetailReport)
  520. detail.Report.ReportType = approveItem.ReportType
  521. detail.Report.ReportId = approveItem.ReportId
  522. detail.Report.ReportTitle = approveItem.ReportTitle
  523. // 报告分类路由
  524. if approveItem.ReportType == report_approve.FlowReportTypeChinese {
  525. detail.Report.ReportCode = utils.MD5(strconv.Itoa(approveItem.ReportId))
  526. detail.Report.ReportClassify = fmt.Sprintf("%s/%s/%s", report_approve.FlowReportTypeMap[approveItem.ReportType], cnClassifyIdName[approveItem.ClassifyFirstId], cnClassifyIdName[approveItem.ClassifySecondId])
  527. }
  528. if approveItem.ReportType == report_approve.FlowReportTypeEnglish {
  529. detail.Report.ReportCode = utils.MD5(strconv.Itoa(approveItem.ReportId))
  530. detail.Report.ReportClassify = fmt.Sprintf("%s/%s/%s/%s", report_approve.FlowReportTypeMap[approveItem.ReportType], enClassifyIdName[enRootIdMap[approveItem.ClassifySecondId]], enClassifyIdName[approveItem.ClassifyFirstId], enClassifyIdName[approveItem.ClassifySecondId])
  531. }
  532. if approveItem.ReportType == report_approve.FlowReportTypeSmart {
  533. detail.Report.ReportCode = utils.MD5(fmt.Sprint("smart_", approveItem.ReportId))
  534. detail.Report.ReportClassify = fmt.Sprintf("%s/%s/%s", report_approve.FlowReportTypeMap[approveItem.ReportType], cnClassifyIdName[approveItem.ClassifyFirstId], cnClassifyIdName[approveItem.ClassifySecondId])
  535. }
  536. br.Data = detail
  537. br.Ret = 200
  538. br.Success = true
  539. br.Msg = "获取成功"
  540. }
  541. // Approve
  542. // @Title 通过审批
  543. // @Description 通过审批
  544. // @Param request body report_approve.ReportApprovePassReq true "type json string"
  545. // @Success 200 string "操作成功"
  546. // @router /approve [post]
  547. func (this *ReportApproveController) Approve() {
  548. br := new(models.BaseResponse).Init()
  549. defer func() {
  550. if br.ErrMsg == "" {
  551. br.IsSendEmail = false
  552. }
  553. this.Data["json"] = br
  554. this.ServeJSON()
  555. }()
  556. sysUser := this.SysUser
  557. if sysUser == nil {
  558. br.Msg = "请登录"
  559. br.ErrMsg = "请登录,SysUser Is Empty"
  560. br.Ret = 408
  561. return
  562. }
  563. var req report_approve.ReportApprovePassReq
  564. if e := json.Unmarshal(this.Ctx.Input.RequestBody, &req); e != nil {
  565. br.Msg = "参数有误"
  566. br.ErrMsg = "参数解析失败, Err: " + e.Error()
  567. return
  568. }
  569. if req.ReportApproveId <= 0 {
  570. br.Msg = "参数有误"
  571. br.ErrMsg = fmt.Sprintf("参数有误, ReportApproveId: %d", req.ReportApproveId)
  572. return
  573. }
  574. approveOb := new(report_approve.ReportApprove)
  575. approveItem, e := approveOb.GetItemById(req.ReportApproveId)
  576. if e != nil {
  577. if e.Error() == utils.ErrNoRow() {
  578. br.Msg = "审批不存在, 请刷新页面"
  579. return
  580. }
  581. br.Msg = "操作失败"
  582. br.ErrMsg = "获取审批信息失败, Err: " + e.Error()
  583. return
  584. }
  585. if approveItem.State != report_approve.ReportApproveStateApproving {
  586. br.Msg = "审批状态有误, 请刷新页面"
  587. br.ErrMsg = fmt.Sprintf("审批状态有误, State: %d", approveItem.State)
  588. return
  589. }
  590. // 校验审批记录和审批
  591. recordOb := new(report_approve.ReportApproveRecord)
  592. recordCond := fmt.Sprintf(` AND %s = ? AND %s = ? AND %s = ?`, report_approve.ReportApproveRecordCols.ReportApproveId, report_approve.ReportApproveRecordCols.ApproveUserId, report_approve.ReportApproveRecordCols.State)
  593. recordPars := make([]interface{}, 0)
  594. recordPars = append(recordPars, approveItem.ReportApproveId, sysUser.AdminId, report_approve.ReportApproveStateApproving)
  595. recordItem, e := recordOb.GetItemByCondition(recordCond, recordPars, "")
  596. if e != nil {
  597. if e.Error() == utils.ErrNoRow() {
  598. br.Msg = "无权审批"
  599. return
  600. }
  601. br.Msg = "操作失败"
  602. br.ErrMsg = "获取审批记录失败, Err: " + e.Error()
  603. return
  604. }
  605. // 通过审批
  606. tips, e := services.PassReportApprove(approveItem, recordItem, sysUser.AdminId, req.ReportUrl)
  607. if e != nil {
  608. br.Msg = "操作失败"
  609. br.ErrMsg = "通过审批失败, Err: " + e.Error()
  610. return
  611. }
  612. if tips != "" {
  613. br.Msg = tips
  614. return
  615. }
  616. br.Ret = 200
  617. br.Success = true
  618. br.Msg = "操作成功"
  619. }
  620. // Refuse
  621. // @Title 驳回审批
  622. // @Description 驳回审批
  623. // @Param request body report_approve.ReportApproveRefuseReq true "type json string"
  624. // @Success 200 string "操作成功"
  625. // @router /refuse [post]
  626. func (this *ReportApproveController) Refuse() {
  627. br := new(models.BaseResponse).Init()
  628. defer func() {
  629. if br.ErrMsg == "" {
  630. br.IsSendEmail = false
  631. }
  632. this.Data["json"] = br
  633. this.ServeJSON()
  634. }()
  635. sysUser := this.SysUser
  636. if sysUser == nil {
  637. br.Msg = "请登录"
  638. br.ErrMsg = "请登录,SysUser Is Empty"
  639. br.Ret = 408
  640. return
  641. }
  642. var req report_approve.ReportApproveRefuseReq
  643. if e := json.Unmarshal(this.Ctx.Input.RequestBody, &req); e != nil {
  644. br.Msg = "参数有误"
  645. br.ErrMsg = "参数解析失败, Err: " + e.Error()
  646. return
  647. }
  648. if req.ReportApproveId <= 0 {
  649. br.Msg = "参数有误"
  650. br.ErrMsg = fmt.Sprintf("参数有误, ReportApproveId: %d", req.ReportApproveId)
  651. return
  652. }
  653. approveOb := new(report_approve.ReportApprove)
  654. approveItem, e := approveOb.GetItemById(req.ReportApproveId)
  655. if e != nil {
  656. if e.Error() == utils.ErrNoRow() {
  657. br.Msg = "审批不存在, 请刷新页面"
  658. return
  659. }
  660. br.Msg = "操作失败"
  661. br.ErrMsg = "获取审批信息失败, Err: " + e.Error()
  662. return
  663. }
  664. if approveItem.State != report_approve.ReportApproveStateApproving {
  665. br.Msg = "审批状态有误, 请刷新页面"
  666. br.ErrMsg = fmt.Sprintf("审批状态有误, State: %d", approveItem.State)
  667. return
  668. }
  669. // 校验审批记录和审批
  670. recordOb := new(report_approve.ReportApproveRecord)
  671. recordCond := fmt.Sprintf(` AND %s = ? AND %s = ? AND %s = ?`, report_approve.ReportApproveRecordCols.ReportApproveId, report_approve.ReportApproveRecordCols.ApproveUserId, report_approve.ReportApproveRecordCols.State)
  672. recordPars := make([]interface{}, 0)
  673. recordPars = append(recordPars, approveItem.ReportApproveId, sysUser.AdminId, report_approve.ReportApproveStateApproving)
  674. recordItem, e := recordOb.GetItemByCondition(recordCond, recordPars, "")
  675. if e != nil {
  676. if e.Error() == utils.ErrNoRow() {
  677. br.Msg = "无权审批"
  678. return
  679. }
  680. br.Msg = "操作失败"
  681. br.ErrMsg = "获取审批记录失败, Err: " + e.Error()
  682. return
  683. }
  684. // 驳回审批
  685. if e = services.RefuseReportApprove(approveItem, recordItem, req.ApproveRemark, sysUser.AdminId); e != nil {
  686. br.Msg = "操作失败"
  687. br.ErrMsg = "驳回审批失败, Err: " + e.Error()
  688. return
  689. }
  690. br.Ret = 200
  691. br.Success = true
  692. br.Msg = "操作成功"
  693. }
  694. // Cancel
  695. // @Title 撤销审批
  696. // @Description 撤销审批
  697. // @Param request body report_approve.ReportApproveCancelReq true "type json string"
  698. // @Success 200 string "操作成功"
  699. // @router /cancel [post]
  700. func (this *ReportApproveController) Cancel() {
  701. br := new(models.BaseResponse).Init()
  702. defer func() {
  703. if br.ErrMsg == "" {
  704. br.IsSendEmail = false
  705. }
  706. this.Data["json"] = br
  707. this.ServeJSON()
  708. }()
  709. sysUser := this.SysUser
  710. if sysUser == nil {
  711. br.Msg = "请登录"
  712. br.ErrMsg = "请登录,SysUser Is Empty"
  713. br.Ret = 408
  714. return
  715. }
  716. var req report_approve.ReportApproveCancelReq
  717. if e := json.Unmarshal(this.Ctx.Input.RequestBody, &req); e != nil {
  718. br.Msg = "参数有误"
  719. br.ErrMsg = "参数解析失败, Err: " + e.Error()
  720. return
  721. }
  722. if req.ReportApproveId <= 0 {
  723. br.Msg = "参数有误"
  724. br.ErrMsg = fmt.Sprintf("参数有误, ReportApproveId: %d", req.ReportApproveId)
  725. return
  726. }
  727. approveOb := new(report_approve.ReportApprove)
  728. approveItem, e := approveOb.GetItemById(req.ReportApproveId)
  729. if e != nil {
  730. if e.Error() == utils.ErrNoRow() {
  731. br.Msg = "审批已被删除, 请刷新页面"
  732. return
  733. }
  734. br.Msg = "操作失败"
  735. br.ErrMsg = "获取审批失败, Err: " + e.Error()
  736. return
  737. }
  738. if approveItem.ApplyUserId != sysUser.AdminId {
  739. br.Msg = "非申请人不可撤销"
  740. return
  741. }
  742. // 撤销审批
  743. e = services.CancelReportApprove(approveItem.ReportType, approveItem.ReportId, approveItem.ReportApproveId, sysUser.AdminId, sysUser.RealName)
  744. if e != nil {
  745. br.Msg = "操作失败"
  746. br.ErrMsg = "撤销审批失败, Err: " + e.Error()
  747. return
  748. }
  749. br.Ret = 200
  750. br.Success = true
  751. br.Msg = "操作成功"
  752. }
  753. // MessageList
  754. // @Title 审批消息列表
  755. // @Description 审批消息列表
  756. // @Param PageSize query int true "每页数据条数"
  757. // @Param CurrentIndex query int true "当前页页码"
  758. // @Success 200 {object} report_approve.ReportApproveMessageListResp
  759. // @router /message/list [get]
  760. func (this *ReportApproveController) MessageList() {
  761. br := new(models.BaseResponse).Init()
  762. defer func() {
  763. if br.ErrMsg == "" {
  764. br.IsSendEmail = false
  765. }
  766. this.Data["json"] = br
  767. this.ServeJSON()
  768. }()
  769. sysUser := this.SysUser
  770. if sysUser == nil {
  771. br.Msg = "请登录"
  772. br.ErrMsg = "请登录,SysUser Is Empty"
  773. br.Ret = 408
  774. return
  775. }
  776. params := new(report_approve.ReportApproveListReq)
  777. if e := this.ParseForm(params); e != nil {
  778. br.Msg = "获取失败"
  779. br.ErrMsg = "入参解析失败, Err: " + e.Error()
  780. return
  781. }
  782. // 分页
  783. var startSize int
  784. if params.PageSize <= 0 {
  785. params.PageSize = utils.PageSize20
  786. }
  787. if params.CurrentIndex <= 0 {
  788. params.CurrentIndex = 1
  789. }
  790. startSize = utils.StartIndex(params.CurrentIndex, params.PageSize)
  791. resp := new(report_approve.ReportApproveMessageListResp)
  792. resp.List = make([]*report_approve.ReportApproveMessageItem, 0)
  793. cond := fmt.Sprintf(` AND %s = ?`, report_approve.ReportApproveMessageCols.ReceiveUserId)
  794. pars := make([]interface{}, 0)
  795. pars = append(pars, sysUser.AdminId)
  796. order := fmt.Sprintf(`%s ASC, %s DESC`, report_approve.ReportApproveMessageCols.IsRead, report_approve.ReportApproveMessageCols.CreateTime)
  797. messageOb := new(report_approve.ReportApproveMessage)
  798. total, e := messageOb.GetCountByCondition(cond, pars)
  799. if e != nil {
  800. br.Msg = "获取失败"
  801. br.ErrMsg = "获取审批消息列表总数失败, Err: " + e.Error()
  802. return
  803. }
  804. list, e := messageOb.GetPageItemsByCondition(cond, pars, []string{}, order, startSize, params.PageSize)
  805. if e != nil {
  806. br.Msg = "获取失败"
  807. br.ErrMsg = "获取审批消息列表失败, Err: " + e.Error()
  808. return
  809. }
  810. for _, v := range list {
  811. t := report_approve.FormatReportApproveMessage2Item(v)
  812. resp.List = append(resp.List, t)
  813. }
  814. // 未读消息数
  815. cond += fmt.Sprintf(` AND %s = ?`, report_approve.ReportApproveMessageCols.IsRead)
  816. pars = append(pars, 0)
  817. unreadTotal, e := messageOb.GetCountByCondition(cond, pars)
  818. if e != nil {
  819. br.Msg = "获取失败"
  820. br.ErrMsg = "获取审批消息列表总数失败, Err: " + e.Error()
  821. return
  822. }
  823. resp.UnreadTotal = unreadTotal
  824. page := paging.GetPaging(params.CurrentIndex, params.PageSize, total)
  825. resp.Paging = page
  826. br.Data = resp
  827. br.Ret = 200
  828. br.Success = true
  829. br.Msg = "获取成功"
  830. }
  831. // MessageRead
  832. // @Title 消息已读
  833. // @Description 消息已读
  834. // @Param request body report_approve.ReportApproveMessageReadReq true "type json string"
  835. // @Success 200 string "操作成功"
  836. // @router /message/read [post]
  837. func (this *ReportApproveController) MessageRead() {
  838. br := new(models.BaseResponse).Init()
  839. defer func() {
  840. if br.ErrMsg == "" {
  841. br.IsSendEmail = false
  842. }
  843. this.Data["json"] = br
  844. this.ServeJSON()
  845. }()
  846. sysUser := this.SysUser
  847. if sysUser == nil {
  848. br.Msg = "请登录"
  849. br.ErrMsg = "请登录,SysUser Is Empty"
  850. br.Ret = 408
  851. return
  852. }
  853. var req report_approve.ReportApproveMessageReadReq
  854. if e := json.Unmarshal(this.Ctx.Input.RequestBody, &req); e != nil {
  855. br.Msg = "参数有误"
  856. br.ErrMsg = "参数解析失败, Err: " + e.Error()
  857. return
  858. }
  859. if req.MessageId <= 0 {
  860. br.Msg = "参数有误"
  861. br.ErrMsg = fmt.Sprintf("参数有误, MessageId: %d", req.MessageId)
  862. return
  863. }
  864. messageOb := new(report_approve.ReportApproveMessage)
  865. messageItem, e := messageOb.GetItemById(req.MessageId)
  866. if e != nil {
  867. if e.Error() == utils.ErrNoRow() {
  868. br.Msg = "消息不存在, 请刷新页面"
  869. return
  870. }
  871. br.Msg = "获取失败"
  872. br.ErrMsg = "获取审批消息失败, Err: " + e.Error()
  873. return
  874. }
  875. messageItem.IsRead = 1
  876. messageItem.ModifyTime = time.Now().Local()
  877. cols := []string{"IsRead", "ModifyTime"}
  878. if e = messageItem.Update(cols); e != nil {
  879. br.Msg = "操作失败"
  880. br.ErrMsg = "更新审批消息已读失败, Err: " + e.Error()
  881. return
  882. }
  883. br.Ret = 200
  884. br.Success = true
  885. br.Msg = "操作成功"
  886. }
  887. // CheckApproveOpen
  888. // @Title 校验分类是否开启审批
  889. // @Description 校验分类是否开启审批
  890. // @Param request body report_approve.ReportApproveCheckApproveOpenReq true "type json string"
  891. // @Success 200 string "操作成功"
  892. // @router /classify/check_open [post]
  893. func (this *ReportApproveController) CheckApproveOpen() {
  894. br := new(models.BaseResponse).Init()
  895. defer func() {
  896. if br.ErrMsg == "" {
  897. br.IsSendEmail = false
  898. }
  899. this.Data["json"] = br
  900. this.ServeJSON()
  901. }()
  902. sysUser := this.SysUser
  903. if sysUser == nil {
  904. br.Msg = "请登录"
  905. br.ErrMsg = "请登录,SysUser Is Empty"
  906. br.Ret = 408
  907. return
  908. }
  909. var req report_approve.ReportApproveCheckApproveOpenReq
  910. if e := json.Unmarshal(this.Ctx.Input.RequestBody, &req); e != nil {
  911. br.Msg = "参数有误"
  912. br.ErrMsg = "参数解析失败, Err: " + e.Error()
  913. return
  914. }
  915. // 校验是否开启了审批流
  916. opening, e := services.CheckReportOpenApprove(req.ReportType, req.ClassifyFirstId, req.ClassifySecondId, req.ClassifyThirdId)
  917. if e != nil {
  918. br.Msg = "操作失败"
  919. br.ErrMsg = "校验报告是否开启审批流失败, Err: " + e.Error()
  920. return
  921. }
  922. br.Data = opening
  923. br.Ret = 200
  924. br.Success = true
  925. br.Msg = "操作成功"
  926. }