plat_task.go 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746
  1. package plat
  2. import (
  3. "bytes"
  4. "context"
  5. workflowModel "dashoo.cn/micro/app/model/workflow"
  6. workflowService "dashoo.cn/micro/app/service/workflow"
  7. "dashoo.cn/opms_libary/plugin/dingtalk/message"
  8. "dashoo.cn/opms_libary/plugin/dingtalk/workflow"
  9. "dashoo.cn/opms_libary/utils"
  10. "database/sql"
  11. "errors"
  12. "fmt"
  13. "strconv"
  14. "strings"
  15. "dashoo.cn/opms_libary/myerrors"
  16. "github.com/360EntSecGroup-Skylar/excelize"
  17. "github.com/gogf/gf/frame/g"
  18. "github.com/gogf/gf/os/gtime"
  19. "github.com/gogf/gf/util/gconv"
  20. "dashoo.cn/micro/app/dao/plat"
  21. model "dashoo.cn/micro/app/model/plat"
  22. "dashoo.cn/micro/app/service"
  23. )
  24. var PlatTaskApprovalProcessCode = "PROC-B2BE7E92-8A12-4CFF-83CD-FF23F397CCE2"
  25. type taskService struct {
  26. *service.ContextService
  27. Dao *plat.PlatTaskDao
  28. }
  29. func NewTaskService(ctx context.Context) (svc *taskService, err error) {
  30. svc = new(taskService)
  31. if svc.ContextService, err = svc.Init(ctx); err != nil {
  32. return nil, err
  33. }
  34. svc.Dao = plat.NewPlatTaskDao(svc.Tenant)
  35. return svc, nil
  36. }
  37. // GetList 任务信息列表
  38. func (s *taskService) GetList(req *model.SearchPlatTaskReq) (total int, TaskList []*model.PlatTaskEx, err error) {
  39. orderBy := "plat_task.created_time DESC"
  40. TaskModel := s.Dao.LeftJoin("plat_task_handle", "plat_task_handle.task_id=plat_task.id")
  41. if req.TaskId != "" {
  42. TaskModel = TaskModel.Where("plat_task.id", req.TaskId)
  43. }
  44. if req.TaskTitle != "" {
  45. TaskModel = TaskModel.Where("plat_task.task_title LIKE ?", "%"+req.TaskTitle+"%")
  46. }
  47. if req.TaskType != "" {
  48. TaskModel = TaskModel.Where("plat_task.task_type", req.TaskType)
  49. }
  50. if req.Source != "" {
  51. TaskModel = TaskModel.Where("plat_task.source", req.Source)
  52. }
  53. if req.TaskStatus != "" {
  54. TaskModel = TaskModel.Where("plat_task.task_status", req.TaskStatus)
  55. }
  56. if req.IsOverdue != "" {
  57. TaskModel = TaskModel.Where("plat_task.is_overdue", req.IsOverdue)
  58. }
  59. if req.MainUserId != "" {
  60. TaskModel = TaskModel.Where("plat_task.main_user_id", req.MainUserId)
  61. }
  62. if req.TargetId != "" {
  63. TaskModel = TaskModel.Where("plat_task.target_id", req.TargetId)
  64. }
  65. if req.TargetType != "" {
  66. TaskModel = TaskModel.Where("plat_task.target_type", req.TargetType)
  67. }
  68. if req.MySelf == "1" {
  69. TaskModel = TaskModel.Where("plat_task.created_by", s.GetCxtUserId())
  70. }
  71. if req.IsMain == "1" {
  72. TaskModel = TaskModel.Where("plat_task.main_user_id", s.GetCxtUserId())
  73. }
  74. if req.OperateType == "1" { // 我的待办
  75. orderBy = "plat_task.task_status ASC, plat_task.created_time DESC"
  76. TaskModel = TaskModel.Where(fmt.Sprintf("plat_task_handle.task_status='10' AND (plat_task_handle.main_user_id=%v OR FIND_IN_SET(%v, plat_task_handle.owner_user_id))", s.GetCxtUserId(), s.GetCxtUserId()))
  77. } else if req.OperateType == "2" { // 我发起的
  78. TaskModel = TaskModel.Where("plat_task.created_by", s.GetCxtUserId())
  79. } else if req.OperateType == "3" { // 我处理的
  80. TaskModel = TaskModel.Where(fmt.Sprintf("plat_task_handle.task_status='20' AND plat_task_handle.handle_user_id=%v", s.GetCxtUserId()))
  81. } else if req.OperateType == "4" { // 抄送我的
  82. TaskModel = TaskModel.Where(fmt.Sprintf("FIND_IN_SET(%v, plat_task.copy_user_id)", s.GetCxtUserId()))
  83. }
  84. TaskModel = TaskModel.Group("plat_task.id")
  85. total, err = TaskModel.Count()
  86. if err != nil {
  87. g.Log().Error(err)
  88. err = myerrors.DbError("获取总行数失败。")
  89. return
  90. }
  91. err = TaskModel.Page(req.GetPage()).Order(orderBy).Fields("plat_task.*,plat_task_handle.step").Scan(&TaskList)
  92. return
  93. }
  94. // Export 导出数据
  95. func (s *taskService) Export(req *model.ExportReq) (content *model.ExportContent, err error) {
  96. var con model.ExportContent
  97. // 获取数据
  98. total, list, err := s.GetList(&req.SearchPlatTaskReq)
  99. if err != nil {
  100. return nil, err
  101. }
  102. //rsp.List
  103. f := excelize.NewFile()
  104. // Create a new sheet.
  105. index := f.NewSheet("Sheet1")
  106. for index, item := range req.Columns {
  107. sheetPosition := service.Div(index+1) + "1"
  108. f.SetCellValue("Sheet1", sheetPosition, item)
  109. }
  110. if total > 0 {
  111. // 构造用户和类型填充数据
  112. userMap := make(map[int]string, 0)
  113. typeMap := make(map[string]string, 0)
  114. users, err := s.Dao.DB.Model("sys_user").FindAll()
  115. if err != nil {
  116. return nil, err
  117. }
  118. types, err := s.Dao.DB.Model("sys_dict_data").Where("dict_type='TaskType'").FindAll()
  119. if err != nil {
  120. return nil, err
  121. }
  122. for _, item := range users {
  123. userMap[item["id"].Int()] = item["nick_name"].String()
  124. }
  125. for _, item := range types {
  126. typeMap[item["dict_value"].String()] = item["dict_label"].String()
  127. }
  128. // 构造excel数据
  129. for lineNum, item := range list {
  130. for index, value := range req.Columns {
  131. if value == "督办标题" {
  132. f.SetCellValue("Sheet1", service.Div(index+1)+strconv.Itoa(lineNum+2), item.TaskTitle)
  133. }
  134. if value == "督办类型" {
  135. f.SetCellValue("Sheet1", service.Div(index+1)+strconv.Itoa(lineNum+2), typeMap[item.TaskType])
  136. }
  137. if value == "状态" {
  138. data := ""
  139. if item.TaskStatus == "10" {
  140. data = "发起"
  141. } else if item.TaskStatus == "20" {
  142. data = "进行中"
  143. } else if item.TaskStatus == "30" {
  144. data = "流程完成"
  145. }
  146. f.SetCellValue("Sheet1", service.Div(index+1)+strconv.Itoa(lineNum+2), data)
  147. }
  148. if value == "督办事项来源" {
  149. f.SetCellValue("Sheet1", service.Div(index+1)+strconv.Itoa(lineNum+2), item.Source)
  150. }
  151. if value == "超期" {
  152. data := ""
  153. if gtime.Now().Format("Y-m-d H:i:s") <= item.TaskEndDate.Format("Y-m-d 23:59:59") {
  154. data = "否"
  155. } else {
  156. data = "是"
  157. }
  158. f.SetCellValue("Sheet1", service.Div(index+1)+strconv.Itoa(lineNum+2), data)
  159. }
  160. if value == "督办说明" {
  161. f.SetCellValue("Sheet1", service.Div(index+1)+strconv.Itoa(lineNum+2), item.TaskDesc)
  162. }
  163. if value == "关联对象" {
  164. f.SetCellValue("Sheet1", service.Div(index+1)+strconv.Itoa(lineNum+2), item.TargetName)
  165. }
  166. if value == "负责人" {
  167. f.SetCellValue("Sheet1", service.Div(index+1)+strconv.Itoa(lineNum+2), userMap[item.MainUserId])
  168. }
  169. if value == "协办人" {
  170. names := ""
  171. if item.OwnerUserId != "" {
  172. ids := strings.Split(item.OwnerUserId, ",")
  173. for _, id := range ids {
  174. if names == "" {
  175. names = userMap[gconv.Int(id)]
  176. } else {
  177. names += "," + userMap[gconv.Int(id)]
  178. }
  179. }
  180. }
  181. f.SetCellValue("Sheet1", service.Div(index+1)+strconv.Itoa(lineNum+2), names)
  182. }
  183. if value == "督办人" {
  184. f.SetCellValue("Sheet1", service.Div(index+1)+strconv.Itoa(lineNum+2), userMap[item.SupervisorUserId])
  185. }
  186. if value == "发布时间" {
  187. f.SetCellValue("Sheet1", service.Div(index+1)+strconv.Itoa(lineNum+2), item.TaskStartDate.Format("Y-m-d"))
  188. }
  189. if value == "要求完成时间" {
  190. f.SetCellValue("Sheet1", service.Div(index+1)+strconv.Itoa(lineNum+2), item.TaskEndDate.Format("Y-m-d"))
  191. }
  192. if value == "创建时间" {
  193. f.SetCellValue("Sheet1", service.Div(index+1)+strconv.Itoa(lineNum+2), item.CreatedTime.Format("Y-m-d H:i:s"))
  194. }
  195. }
  196. }
  197. }
  198. f.SetActiveSheet(index)
  199. var buffer *bytes.Buffer
  200. buffer, _ = f.WriteToBuffer()
  201. con.Content = buffer.Bytes()
  202. return &con, err
  203. }
  204. // Statistics 统计
  205. func (s *taskService) Statistics(req *model.SearchPlatTaskReq) (*model.TaskNumberCount, error) {
  206. var result model.TaskNumberCount
  207. // 统计数量
  208. count, err := s.Dao.InnerJoin("plat_task_handle", "plat_task.Id=plat_task_handle.task_id").Where(fmt.Sprintf("plat_task_handle.task_status='10' AND (plat_task_handle.main_user_id=%v OR FIND_IN_SET(%v, plat_task_handle.owner_user_id))", s.GetCxtUserId(), s.GetCxtUserId())).Group("plat_task.Id").Count()
  209. if err != nil {
  210. return nil, err
  211. }
  212. result.ToDoNumber = count
  213. return &result, nil
  214. }
  215. // Create 添加信息
  216. func (s *taskService) Create(req *model.AddPlatTaskReq) (err error) {
  217. platTask := new(model.PlatTask)
  218. if err = gconv.Struct(req, platTask); err != nil {
  219. return
  220. }
  221. // 初始数据
  222. platTask.IsOverdue = "10" // 是否超期(10否20是)
  223. if platTask.TaskStartDate == nil || platTask.TaskStartDate.IsZero() {
  224. platTask.TaskStartDate = gtime.Now()
  225. }
  226. // 填充创建信息
  227. service.SetCreatedInfo(platTask, s.GetCxtUserId(), s.GetCxtUserName())
  228. // 填充更新信息
  229. //service.SetUpdatedInfo(platTask, s.GetCxtUserId(), s.GetCxtUserName())
  230. res, err := s.Dao.Insert(platTask)
  231. if err != nil {
  232. return
  233. }
  234. // 创建操作任务
  235. id, _ := res.LastInsertId()
  236. platTask.Id = int(id)
  237. err = s.startDingApproval(platTask)
  238. if err != nil {
  239. return
  240. }
  241. // 流程日志
  242. err = CreateTaskLog(s, nil, int(id), s.GetCxtUserId(), s.GetCxtUserName(), "创建督办", "创建督办成功", "")
  243. return
  244. }
  245. // AddTaskApproval 创建督办之后,需要钉钉审批才能生效
  246. func (s *taskService) AddTaskApproval(flow *workflowModel.PlatWorkflow, msg *message.MixMessage) error {
  247. task, err := s.Dao.Where("id = ?", flow.BizCode).FindOne()
  248. if err != nil {
  249. return fmt.Errorf("创建督办审批 bizCode 不合法:%s Id: %d", flow.BizCode, flow.Id)
  250. }
  251. if err != nil {
  252. return err
  253. }
  254. if task == nil {
  255. return fmt.Errorf("督办不存在:%s Id: %d", flow.BizCode, flow.Id)
  256. }
  257. if msg.ProcessType != "finish" && msg.ProcessType != "terminate" {
  258. return fmt.Errorf("无法识别的 ProcessType :%s", msg.ProcessType)
  259. }
  260. if msg.Result != "agree" && msg.Result != "refuse" && msg.Result != "" {
  261. return fmt.Errorf("无法识别的 Result :%s", msg.Result)
  262. }
  263. if msg.ProcessType == "terminate" {
  264. _, err = s.Dao.Update("task_status='50'", fmt.Sprintf("id='%v'", task.Id))
  265. if err != nil {
  266. return err
  267. }
  268. // 流程日志
  269. err = CreateTaskLog(s, nil, task.Id, s.GetCxtUserId(), s.GetCxtUserName(), "督办审批", "撤销", "")
  270. } else {
  271. if msg.Result == "agree" {
  272. nextHandle := createNextTaskHandel(s, task, 10)
  273. _, err = s.Dao.DB.Insert("plat_task_handle", nextHandle)
  274. if err != nil {
  275. return err
  276. }
  277. // 发送消息通知
  278. go taskNotifyMessage(task.MainUserId, task.OwnerUserId, fmt.Sprintf("%v督办任务需要处理", task.TaskTitle))
  279. // 流程日志
  280. err = CreateTaskLog(s, nil, task.Id, s.GetCxtUserId(), s.GetCxtUserName(), "督办审批", "通过", "")
  281. } else if msg.Result == "refuse" {
  282. _, err = s.Dao.Update("task_status='40'", fmt.Sprintf("id='%v'", task.Id))
  283. if err != nil {
  284. return err
  285. }
  286. // 流程日志
  287. err = CreateTaskLog(s, nil, task.Id, s.GetCxtUserId(), s.GetCxtUserName(), "督办审批", "拒绝", "")
  288. }
  289. }
  290. return err
  291. }
  292. // ChangeStatus 修改状态
  293. func (s *taskService) ChangeStatus(req *model.ChangeStatusReq) (err error) {
  294. data := ""
  295. where := fmt.Sprintf("id='%v'", req.TaskId)
  296. nodeName := "状态修改"
  297. desc := "修改成功"
  298. // 类型合规判断
  299. if req.Type == "TaskStatus" {
  300. data = fmt.Sprintf("task_status='%v'", req.NowStatus)
  301. nodeName = "状态修改"
  302. if req.NowStatus == "20" {
  303. desc = "关闭"
  304. data += fmt.Sprintf(",task_end_date='%v'", gtime.Now().Format("Y-m-d H:i:s"))
  305. }
  306. } else if req.Type == "IsOverdue" {
  307. nodeName = "超期状态修改"
  308. if req.NowStatus == "20" {
  309. desc = "超期"
  310. }
  311. data = fmt.Sprintf("is_overdue='%v'", req.NowStatus)
  312. } else {
  313. err = myerrors.TipsError("类型不匹配,请仔细检查。")
  314. return err
  315. }
  316. // 读取现有数据
  317. task, err := s.Dao.Where(where).FindOne()
  318. if err != nil {
  319. return err
  320. }
  321. if task == nil {
  322. err = myerrors.TipsError("数据异常,无匹配数据。")
  323. return err
  324. }
  325. // 状态数据一致性判断
  326. if (req.Type == "TaskStatus" && task.TaskStatus != req.OldStatus) || (req.Type == "IsOverdue" && task.IsOverdue != req.OldStatus) {
  327. err = myerrors.TipsError("状态不匹配,进行该操作")
  328. return err
  329. }
  330. // 更新数据
  331. _, err = s.Dao.Update(data, where)
  332. if err != nil {
  333. return
  334. }
  335. // 流程日志
  336. taskId, _ := strconv.Atoi(req.TaskId)
  337. err = CreateTaskLog(s, nil, taskId, s.GetCxtUserId(), s.GetCxtUserName(), nodeName, desc, "")
  338. return
  339. }
  340. // Handle 督办任务处理
  341. //步骤号(10接收 15暂存 20提交 30审批(督办人) 40评价(监办人))
  342. func (s *taskService) Handle(req *model.HandleReq) (err error) {
  343. // 步骤号(10接收 15暂存 20提交 30审批(督办人) 40评价(监办人))
  344. // 处理结果(10接收20提交30审批通过40审批退回)
  345. logNodeName := ""
  346. logDesc := ""
  347. var taskHandle model.PlatTaskHandle
  348. if req.Step != 15 {
  349. err = s.Dao.DB.Model("plat_task_handle").Where(fmt.Sprintf("task_id='%v' AND step=%v AND task_status='10' AND (main_user_id=%v OR FIND_IN_SET(%v, owner_user_id))", req.TaskId, req.Step, s.GetCxtUserId(), s.GetCxtUserId())).Scan(&taskHandle)
  350. if err != nil {
  351. if err == sql.ErrNoRows {
  352. err = myerrors.TipsError("数据不匹配,刷新数据重试")
  353. return err
  354. }
  355. return err
  356. }
  357. }
  358. now := gtime.Now()
  359. // 数据暂存,不做任何流程修改
  360. if req.Step == 15 {
  361. // 暂存
  362. logNodeName = "暂存"
  363. logDesc = s.GetCxtUserName() + "暂存进展信息"
  364. // 更新进展数据
  365. err = s.saveProgressList(req, now)
  366. if err != nil {
  367. return err
  368. }
  369. } else {
  370. var nextHandle = new(model.PlatTaskHandle)
  371. task, err := s.Dao.Where("id", req.TaskId).FindOne()
  372. if err != nil {
  373. return err
  374. }
  375. if task == nil {
  376. err = myerrors.TipsError("数据异常,无匹配数据")
  377. return err
  378. }
  379. // 构造更新数据
  380. handleData := g.Map{
  381. "task_status": "20",
  382. "handle_user_id": s.GetCxtUserId(),
  383. "handle_date": now.Format("Y-m-d H:i:s"),
  384. "handle_status": req.HandleStatus,
  385. "handle_desc": req.HandleDesc,
  386. "updated_by": s.GetCxtUserId(),
  387. "updated_name": s.GetCxtUserName(),
  388. "updated_time": now.Format("Y-m-d H:i:s"),
  389. }
  390. taskData := g.Map{
  391. "updated_by": s.GetCxtUserId(),
  392. "updated_name": s.GetCxtUserName(),
  393. "updated_time": now.Format("Y-m-d H:i:s"),
  394. }
  395. // 督办任务接收
  396. if req.Step == 10 {
  397. // 接收任务
  398. taskData["task_status"] = "20"
  399. taskData["receive_date"] = now.Format("Y-m-d H:i:s")
  400. nextHandle = createNextTaskHandel(s, task, 20)
  401. logNodeName = "接收"
  402. logDesc = s.GetCxtUserName() + "接收督办任务"
  403. } else if req.Step == 20 {
  404. // 提交数据
  405. nextHandle = createNextTaskHandel(s, task, 30)
  406. logNodeName = "提交"
  407. logDesc = s.GetCxtUserName() + "提交督办任务"
  408. // 更新进展数据
  409. err = s.saveProgressList(req, now)
  410. if err != nil {
  411. return err
  412. }
  413. } else if req.Step == 30 {
  414. // 督办人审批
  415. taskData["approver_id"] = s.GetCxtUserId()
  416. taskData["appro_date"] = now.Format("Y-m-d H:i:s")
  417. taskData["appro_status"] = req.HandleStatus
  418. taskData["appro_desc"] = req.HandleDesc
  419. logNodeName = "审批"
  420. if req.HandleStatus == "30" {
  421. logDesc = s.GetCxtUserName() + "审批通过"
  422. if req.IsComplete == "10" {
  423. // 任务完成
  424. nextHandle = createNextTaskHandel(s, task, 40)
  425. } else {
  426. // 任务未完成,继续执行
  427. nextHandle = createNextTaskHandel(s, task, 20)
  428. }
  429. } else if req.HandleStatus == "40" {
  430. logDesc = s.GetCxtUserName() + "审批退回"
  431. nextHandle = createNextTaskHandel(s, task, 20)
  432. }
  433. } else if req.Step == 40 {
  434. // 监办人评价
  435. taskData["evaluator_id"] = s.GetCxtUserId()
  436. taskData["evaluate_date"] = now.Format("Y-m-d H:i:s")
  437. taskData["evaluate_status"] = req.HandleStatus
  438. taskData["evaluate_desc"] = req.HandleDesc
  439. logNodeName = "评价"
  440. if req.HandleStatus == "30" {
  441. // 监办人评价,审批通过,任务结束
  442. logDesc = s.GetCxtUserName() + "审批通过"
  443. if req.IsComplete == "10" {
  444. // 任务完成
  445. nextHandle = nil
  446. taskData["actual_close_date"] = now.Format("Y-m-d H:i:s")
  447. taskData["task_status"] = "30"
  448. } else {
  449. // 任务未完成,继续执行
  450. nextHandle = createNextTaskHandel(s, task, 20)
  451. }
  452. } else if req.HandleStatus == "40" {
  453. logDesc = s.GetCxtUserName() + "审批退回"
  454. nextHandle = createNextTaskHandel(s, task, 20)
  455. }
  456. } else {
  457. err = myerrors.TipsError("未知步骤,无法操作")
  458. return err
  459. }
  460. // 更新数据
  461. // 更新督办任务数据
  462. _, err = s.Dao.Update(taskData, fmt.Sprintf("id='%v'", req.TaskId))
  463. if err != nil {
  464. return err
  465. }
  466. // 更新任务数据
  467. _, err = s.Dao.DB.Update("plat_task_handle", handleData, fmt.Sprintf("ID='%v'", taskHandle.ID))
  468. if err != nil {
  469. return err
  470. }
  471. // 创建下一条任务
  472. if nextHandle != nil {
  473. _, err = s.Dao.DB.Save("plat_task_handle", nextHandle)
  474. if err != nil {
  475. return err
  476. }
  477. // 只有督办、监办人需要发送提醒
  478. if req.Step == 20 {
  479. go taskNotifyMessage(task.SupervisorUserId, "", fmt.Sprintf("%v督办任务需要处理", task.TaskTitle))
  480. } else if req.Step == 30 && req.HandleStatus == "30" {
  481. go taskNotifyMessage(task.WatchUserId, "", fmt.Sprintf("%v督办任务需要处理", task.TaskTitle))
  482. }
  483. }
  484. }
  485. // 流程日志
  486. err = CreateTaskLog(s, nil, req.TaskId, s.GetCxtUserId(), s.GetCxtUserName(), logNodeName, logDesc, "")
  487. if err != nil {
  488. return err
  489. }
  490. return nil
  491. }
  492. // CreateTaskLog 任务日志创建方法
  493. func CreateTaskLog(s1 *taskService, s2 *taskProgressService, taskId, userId int, userName, nodeName, desc, remark string) (err error) {
  494. var log model.PlatTaskLog
  495. startTime := gtime.Now()
  496. endTime := startTime
  497. // 默认为当前时间,然后随已有日志情况进行更新
  498. if s1 != nil {
  499. logs, err := s1.Dao.DB.Model(plat.PlatTaskLog.Table).Where(fmt.Sprintf("task_id='%v'", taskId)).Order("created_time DESC").FindAll()
  500. if err != nil && err != sql.ErrNoRows {
  501. return err
  502. }
  503. if len(logs) > 0 {
  504. startTime = logs[0]["end_time"].GTime()
  505. }
  506. } else {
  507. logs, err := s2.Dao.DB.Model(plat.PlatTaskLog.Table).Where(fmt.Sprintf("task_id='%v'", taskId)).Order("created_time DESC").FindAll()
  508. if err != nil && err != sql.ErrNoRows {
  509. return err
  510. }
  511. if len(logs) > 0 {
  512. startTime = logs[0]["end_time"].GTime()
  513. }
  514. }
  515. // 填入日志相关数据
  516. log.TaskId = taskId
  517. log.NodeName = nodeName
  518. log.Desc = desc
  519. log.StartTime = startTime
  520. log.EndTime = endTime
  521. log.Remark = remark
  522. log.CreatedTime = endTime
  523. log.CreatedName = userName
  524. log.CreatedBy = userId
  525. if s1 != nil {
  526. _, err = s1.Dao.DB.Save(plat.PlatTaskLog.Table, log)
  527. } else {
  528. _, err = s2.Dao.DB.Save(plat.PlatTaskLog.Table, log)
  529. }
  530. return err
  531. }
  532. // 创建个人的督办任务(其中,暂存不会生成个人任务,不会改变任何东西,只会新增一条日志)
  533. func createNextTaskHandel(s *taskService, task *model.PlatTask, step int) *model.PlatTaskHandle {
  534. // 步骤号(10接收 15暂存 20提交 30审批(督办人) 40评价(监办人))
  535. var personTask model.PlatTaskHandle
  536. personTask.TaskId = task.Id
  537. personTask.TaskStatus = "10"
  538. personTask.Step = step
  539. // 督办任务为发起时
  540. if step == 10 {
  541. personTask.MainUserId = task.MainUserId
  542. personTask.OwnerUserId = task.OwnerUserId
  543. } else if step == 20 {
  544. // 创建提交任务
  545. personTask.MainUserId = task.MainUserId
  546. personTask.OwnerUserId = task.OwnerUserId
  547. } else if step == 30 {
  548. // 提交给督办人审批
  549. personTask.MainUserId = task.SupervisorUserId
  550. } else if step == 40 {
  551. // 提交给监办人评价
  552. personTask.MainUserId = task.WatchUserId
  553. }
  554. // 填充创建信息
  555. service.SetCreatedInfo(&personTask, s.GetCxtUserId(), s.GetCxtUserName())
  556. return &personTask
  557. }
  558. func (s *taskService) startDingApproval(task *model.PlatTask) error {
  559. dictMap := make(map[string]string, 0)
  560. userMap := make(map[int]string, 0)
  561. teamNames := ""
  562. dicts, err := s.Dao.DB.Model("sys_dict_data").Where("dict_type = 'plat_task_source'").FindAll()
  563. if err != nil && err != sql.ErrNoRows {
  564. return err
  565. }
  566. if len(dicts) == 0 {
  567. return errors.New("督办来源数据缺失,请前往配置")
  568. }
  569. for _, dict := range dicts {
  570. dictMap[dict["dict_value"].String()] = dict["dict_label"].String()
  571. }
  572. users, err := s.Dao.DB.Model("sys_user").FindAll()
  573. if err != nil && err != sql.ErrNoRows {
  574. return err
  575. }
  576. if len(users) == 0 {
  577. return errors.New("用户数据数据缺失,请前往配置")
  578. }
  579. for _, user := range users {
  580. userMap[user["id"].Int()] = user["nick_name"].String()
  581. }
  582. if task.OwnerUserId != "" {
  583. ids := strings.Split(task.OwnerUserId, ",")
  584. for _, id := range ids {
  585. if teamNames == "" {
  586. teamNames = userMap[gconv.Int(id)]
  587. } else {
  588. teamNames += "," + userMap[gconv.Int(id)]
  589. }
  590. }
  591. }
  592. workflowSrv, err := workflowService.NewFlowService(s.Ctx)
  593. if err != nil {
  594. return err
  595. }
  596. _, err = workflowSrv.StartProcessInstance(gconv.String(task.Id), "40", "", &workflow.StartProcessInstanceRequest{
  597. ProcessCode: &PlatTaskApprovalProcessCode,
  598. FormComponentValues: []*workflow.StartProcessInstanceRequestFormComponentValues{
  599. {
  600. Id: utils.String("TextField-K2AD4O5B"),
  601. Name: utils.String("督办标题"),
  602. Value: utils.String(task.TaskTitle),
  603. },
  604. {
  605. Id: utils.String("DDDateField_C7LJMHNU6N40"),
  606. Name: utils.String("发布时间"),
  607. Value: utils.String(task.CreatedTime.Format("Y-m-d")),
  608. },
  609. {
  610. Id: utils.String("DDSelectField_OF3POKFZ43K"),
  611. Name: utils.String("督办来源"),
  612. Value: utils.String(dictMap[task.Source]),
  613. },
  614. {
  615. Id: utils.String("TextField_VPO2N6I4N5S0"),
  616. Name: utils.String("督办内容"),
  617. Value: utils.String(task.TaskDesc),
  618. },
  619. {
  620. Id: utils.String("DDAttachment_18RP41VRTITC0"),
  621. Name: utils.String("附件"),
  622. Value: utils.String(""),
  623. },
  624. {
  625. Id: utils.String("DDPhotoField_11WXOUDIZ85C0"),
  626. Name: utils.String("图片"),
  627. Value: utils.String(""),
  628. },
  629. {
  630. Id: utils.String("TextField_1ER7VNEEGU0W0"),
  631. Name: utils.String("督办人"),
  632. Value: utils.String(userMap[task.SupervisorUserId]),
  633. },
  634. {
  635. Id: utils.String("TextField_OKAEW6GD2FK0"),
  636. Name: utils.String("监办人"),
  637. Value: utils.String(userMap[task.WatchUserId]),
  638. },
  639. {
  640. Id: utils.String("TextField_G97RO96HMXK0"),
  641. Name: utils.String("被督办人"),
  642. Value: utils.String(userMap[task.MainUserId]),
  643. },
  644. {
  645. Id: utils.String("TextField_1FKS6CUW7REO0"),
  646. Name: utils.String("共同完成人"),
  647. Value: utils.String(teamNames),
  648. },
  649. {
  650. Id: utils.String("DDDateField_T9YBZCDTB680"),
  651. Name: utils.String("要求完成时间"),
  652. Value: utils.String(task.TaskEndDate.Format("Y-m-d")),
  653. },
  654. {
  655. Id: utils.String("TextField_LMV0Q71JD5C0"),
  656. Name: utils.String("备注"),
  657. Value: utils.String(task.Remark),
  658. },
  659. },
  660. })
  661. if err != nil {
  662. return err
  663. }
  664. return err
  665. }
  666. // 处理暂存、提交任务进展
  667. func (s *taskService) saveProgressList(req *model.HandleReq, now *gtime.Time) (err error) {
  668. ids := ""
  669. deleteWhere := fmt.Sprintf("task_id='%v'", req.TaskId)
  670. for index, progress := range req.ProgressList {
  671. if progress.Id != 0 {
  672. if ids == "" {
  673. ids = fmt.Sprintf("%v", progress.Id)
  674. } else {
  675. ids += fmt.Sprintf(",%v", progress.Id)
  676. }
  677. }
  678. req.ProgressList[index].TaskId = req.TaskId
  679. // 填充创建信息
  680. if progress.CreatedBy == 0 {
  681. service.SetCreatedInfo(req.ProgressList[index], s.GetCxtUserId(), s.GetCxtUserName())
  682. }
  683. // 填充更新信息
  684. service.SetUpdatedInfo(req.ProgressList[index], s.GetCxtUserId(), s.GetCxtUserName())
  685. }
  686. if ids != "" {
  687. deleteWhere += fmt.Sprintf(" AND ID NOT IN (%v)", ids)
  688. }
  689. // 保存督办进展
  690. // 1 标记删除旧的进展数据
  691. _, err = s.Dao.DB.Update("plat_task_progress", fmt.Sprintf("deleted_time='%v'", now.Format("Y-m-d H:i:s")), deleteWhere)
  692. if err != nil {
  693. return err
  694. }
  695. // 2 保存新的数据
  696. if len(req.ProgressList) > 0 {
  697. _, err = s.Dao.DB.Save("plat_task_progress", req.ProgressList)
  698. if err != nil {
  699. return err
  700. }
  701. }
  702. return nil
  703. }