report_approve.go 33 KB

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