link.go 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534
  1. package db
  2. import (
  3. "context"
  4. "fmt"
  5. "reflect"
  6. "strconv"
  7. "strings"
  8. "time"
  9. "youngee_m_api/model/common_model"
  10. "youngee_m_api/model/gorm_model"
  11. "youngee_m_api/model/http_model"
  12. "youngee_m_api/pack"
  13. "youngee_m_api/util"
  14. "github.com/caixw/lib.go/conv"
  15. "github.com/sirupsen/logrus"
  16. )
  17. // GetTaskLinkList 查询上传链接的task list
  18. func GetTaskLinkList(ctx context.Context, projectID string, pageSize, pageNum int64, conditions *common_model.TalentConditions) ([]*http_model.TaskLinkInfo, int64, error) {
  19. db := GetReadDB(ctx)
  20. // 查询Task表信息
  21. db = db.Debug().Model(gorm_model.YoungeeTaskInfo{}).Where("task_status = 2")
  22. // 根据Project条件过滤
  23. conditionType := reflect.TypeOf(conditions).Elem()
  24. conditionValue := reflect.ValueOf(conditions).Elem()
  25. var platform_nickname string = ""
  26. for i := 0; i < conditionType.NumField(); i++ {
  27. field := conditionType.Field(i)
  28. tag := field.Tag.Get("condition")
  29. value := conditionValue.FieldByName(field.Name)
  30. if tag == "link_status" {
  31. fmt.Printf("link %+v", value.Interface() == int64(0))
  32. if value.Interface() == int64(0) {
  33. db = db.Where("task_stage = 12")
  34. } else {
  35. db = db.Where("task_stage > 12 and task_stage <> 16")
  36. }
  37. continue
  38. } else if !util.IsBlank(value) {
  39. if tag == "platform_nickname" {
  40. platform_nickname = fmt.Sprintf("%v", value.Interface())
  41. continue
  42. } else if tag == "project_id" || tag == "strategy_id" {
  43. db = db.Where(fmt.Sprintf("%s = ?", tag), value.Interface())
  44. }
  45. }
  46. }
  47. var taskInfos []gorm_model.YoungeeTaskInfo
  48. db = db.Model(gorm_model.YoungeeTaskInfo{})
  49. // 查询总数
  50. var totalTask int64
  51. if err := db.Count(&totalTask).Error; err != nil {
  52. logrus.WithContext(ctx).Errorf("[GetProjectTaskList] error query mysql total, err:%+v", err)
  53. return nil, 0, err
  54. }
  55. db.Order("task_id").Find(&taskInfos)
  56. // 查询任务id
  57. var taskIds []string
  58. taskMap := make(map[string]gorm_model.YoungeeTaskInfo)
  59. for _, taskInfo := range taskInfos {
  60. taskIds = append(taskIds, taskInfo.TaskID)
  61. taskMap[taskInfo.TaskID] = taskInfo
  62. }
  63. db1 := GetReadDB(ctx)
  64. db1 = db1.Debug().Model(gorm_model.YounggeeLinkInfo{})
  65. var LinkInfos []gorm_model.YounggeeLinkInfo
  66. db1 = db1.Model(gorm_model.YounggeeLinkInfo{}).Where("task_id IN ? AND is_submit=? ", taskIds, 1)
  67. if conditions.LinkStatus == int64(0) {
  68. db1 = db1.Where("is_review = 0").Find(&LinkInfos)
  69. } else {
  70. db1 = db1.Where("is_ok = 1").Find(&LinkInfos)
  71. }
  72. LinkMap := make(map[string]gorm_model.YounggeeLinkInfo)
  73. for _, LinkInfo := range LinkInfos {
  74. LinkMap[LinkInfo.TaskID] = LinkInfo
  75. }
  76. // 查询总数
  77. var totalLink int64
  78. if err := db1.Count(&totalLink).Error; err != nil {
  79. logrus.WithContext(ctx).Errorf("[GetProjectTalentList] error query mysql total, err:%+v", err)
  80. return nil, 0, err
  81. }
  82. var misNum int64
  83. if totalLink > totalTask {
  84. misNum = totalLink - totalTask
  85. } else {
  86. misNum = totalTask - totalLink
  87. }
  88. logrus.Println("totalLink,totalTalent,misNum:", totalLink, totalTask, misNum)
  89. // 查询该页数据
  90. limit := pageSize + misNum
  91. offset := pageSize * pageNum // assert pageNum start with 0
  92. err := db.Order("task_id").Limit(int(limit)).Offset(int(offset)).Error
  93. if err != nil {
  94. logrus.WithContext(ctx).Errorf("[GetProjectTaskList] error query mysql total, err:%+v", err)
  95. return nil, 0, err
  96. }
  97. var TaskLinks []*http_model.TaskLink
  98. var taskLinks []*http_model.TaskLinkInfo
  99. var newTaskLinks []*http_model.TaskLinkInfo
  100. for _, taskId := range taskIds {
  101. TaskLink := new(http_model.TaskLink)
  102. TaskLink.Talent = taskMap[taskId]
  103. TaskLink.Link = LinkMap[taskId]
  104. TaskLinks = append(TaskLinks, TaskLink)
  105. }
  106. taskLinks = pack.TaskLinkToTaskInfo(TaskLinks)
  107. for _, v := range taskLinks {
  108. if platform_nickname == "" {
  109. newTaskLinks = append(newTaskLinks, v)
  110. } else if strings.Contains(v.PlatformNickname, platform_nickname) {
  111. newTaskLinks = append(newTaskLinks, v)
  112. } else if strings.Contains(conv.MustString(v.TaskID, ""), platform_nickname) {
  113. newTaskLinks = append(newTaskLinks, v)
  114. } else {
  115. totalTask--
  116. }
  117. }
  118. return newTaskLinks, totalTask, nil
  119. }
  120. // LinkOpinion 提交意见
  121. func LinkOpinion(ctx context.Context, TaskID string, ReviseOpinion string, operatorid string, projectid string) error {
  122. var opid string
  123. var optype int
  124. opid = operatorid
  125. optype = 3
  126. db := GetReadDB(ctx)
  127. err := db.Model(gorm_model.YounggeeLinkInfo{}).Where("task_id = ? and is_review = 0", TaskID).Updates(map[string]interface{}{"revise_opinion": ReviseOpinion, "reject_at": time.Now(), "is_review": 1, "b_operator": opid, "b_operator_type": optype}).Error
  128. if err != nil {
  129. logrus.WithContext(ctx).Errorf("[Link db] Update YounggeeLinkInfo error,err:%+v", err)
  130. return err
  131. }
  132. var project gorm_model.ProjectInfo
  133. err = db.Model(gorm_model.ProjectInfo{}).Where("project_id = ?", projectid).Find(&project).Error
  134. if err != nil {
  135. logrus.WithContext(ctx).Errorf("[Sketch db] Find ProjectInfo error,err:%+v", err)
  136. return err
  137. }
  138. var link_default gorm_model.InfoAutoTask
  139. err = db.Model(gorm_model.InfoAutoTask{}).Where("auto_task_id = ?", project.AutoTaskID).Find(&link_default).Error
  140. if err != nil {
  141. return err
  142. }
  143. duration := time.Duration(link_default.LinkBreach) * time.Hour
  144. err = db.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", TaskID).Updates(gorm_model.YoungeeTaskInfo{LinkStatus: 3, CurBreakAt: time.Now().Add(duration)}).Error
  145. if err != nil {
  146. logrus.WithContext(ctx).Errorf("[Link db] Update YoungeeTaskInfo error,err:%+v", err)
  147. return err
  148. }
  149. err = db.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", TaskID).Updates(gorm_model.YoungeeTaskInfo{TaskStage: 11}).Error
  150. if err != nil {
  151. logrus.WithContext(ctx).Errorf("[Link db] Update YoungeeTaskInfo error,err:%+v", err)
  152. return err
  153. }
  154. return nil
  155. }
  156. // LinkOpinion 提交意见
  157. func LocalLinkOpinion(ctx context.Context, TaskID string, ReviseOpinion string, operatorid string, projectid string) error {
  158. var opid string
  159. var optype int
  160. opid = operatorid
  161. optype = 3
  162. db := GetReadDB(ctx)
  163. err := db.Model(gorm_model.YounggeeLinkInfo{}).Where("task_id = ? and is_review = 0", TaskID).Updates(map[string]interface{}{"revise_opinion": ReviseOpinion, "reject_at": time.Now(), "is_review": 1, "b_operator": opid, "b_operator_type": optype}).Error
  164. if err != nil {
  165. logrus.WithContext(ctx).Errorf("[Link db] Update YounggeeLinkInfo error,err:%+v", err)
  166. return err
  167. }
  168. var project gorm_model.YounggeeLocalLifeInfo
  169. err = db.Model(gorm_model.YounggeeLocalLifeInfo{}).Where("local_id = ?", projectid).Find(&project).Error
  170. if err != nil {
  171. logrus.WithContext(ctx).Errorf("[Sketch db] Find ProjectInfo error,err:%+v", err)
  172. return err
  173. }
  174. var link_default gorm_model.InfoAutoTask
  175. err = db.Model(gorm_model.InfoAutoTask{}).Where("auto_task_id = ?", project.AutoTaskId).Find(&link_default).Error
  176. if err != nil {
  177. return err
  178. }
  179. duration := time.Duration(link_default.LinkBreach) * time.Hour
  180. err = db.Model(gorm_model.YoungeeLocalTaskInfo{}).Where("task_id = ?", TaskID).Updates(gorm_model.YoungeeLocalTaskInfo{LinkStatus: 3, CurBreakAt: time.Now().Add(duration)}).Error
  181. if err != nil {
  182. logrus.WithContext(ctx).Errorf("[Link db] Update YoungeeTaskInfo error,err:%+v", err)
  183. return err
  184. }
  185. err = db.Model(gorm_model.YoungeeLocalTaskInfo{}).Where("task_id = ?", TaskID).Updates(gorm_model.YoungeeLocalTaskInfo{TaskStage: 11}).Error
  186. if err != nil {
  187. logrus.WithContext(ctx).Errorf("[Link db] Update YoungeeTaskInfo error,err:%+v", err)
  188. return err
  189. }
  190. return nil
  191. }
  192. //// AcceptLink 同意链接
  193. //func AcceptLink(ctx context.Context, TaskIDs []string) error {
  194. // db := GetReadDB(ctx)
  195. // err := db.Model(gorm_model.YounggeeLinkInfo{}).Where("task_id in ? and is_review = 0", TaskIDs).Updates(map[string]interface{}{"is_ok": 1, "is_review": 1, "agree_at": time.Now()}).Error
  196. // if err != nil {
  197. // logrus.WithContext(ctx).Errorf("[Link db] Update YounggeeLinkInfo error,err:%+v", err)
  198. // return err
  199. // }
  200. // err = db.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id in ?", TaskIDs).Updates(gorm_model.YoungeeTaskInfo{LinkStatus: 5}).Error
  201. // if err != nil {
  202. // logrus.WithContext(ctx).Errorf("[Link db] Update YoungeeTaskInfo error,err:%+v", err)
  203. // return err
  204. // }
  205. // err = db.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id in ?", TaskIDs).Updates(gorm_model.YoungeeTaskInfo{TaskStage: 13}).Error
  206. // if err != nil {
  207. // logrus.WithContext(ctx).Errorf("[Link db] Update YoungeeTaskInfo error,err:%+v", err)
  208. // return err
  209. // }
  210. // return nil
  211. //}
  212. // AcceptLink 同意链接
  213. func AcceptLink(ctx context.Context, TaskIDs []string, operatorid string, projectid string, isspecial int) error {
  214. var opid string
  215. var optype int
  216. opid = operatorid
  217. optype = 3
  218. db := GetReadDB(ctx)
  219. err := db.Model(gorm_model.YounggeeLinkInfo{}).Where("task_id in ? and is_review = 0", TaskIDs).Updates(map[string]interface{}{"is_ok": 1, "is_review": 1, "agree_at": time.Now(), "b_operator": opid, "b_operator_type": optype}).Error
  220. if err != nil {
  221. logrus.WithContext(ctx).Errorf("[Link db] Update YounggeeLinkInfo error,err:%+v", err)
  222. return err
  223. }
  224. var project gorm_model.ProjectInfo
  225. err = db.Model(gorm_model.ProjectInfo{}).Where("project_id = ?", projectid).Find(&project).Error
  226. if err != nil {
  227. logrus.WithContext(ctx).Errorf("[Sketch db] Find ProjectInfo error,err:%+v", err)
  228. return err
  229. }
  230. taskstages := 13
  231. nextstage := [6]int{0, 0, 0, 0, 0, 0} // 数组长度为6,表示6种工具 4,9,11,13
  232. if isspecial == 1 {
  233. toolList := strings.Split(project.Tools, ",")
  234. for _, tool := range toolList {
  235. // 将 tool 转换为整数
  236. if t, err := strconv.Atoi(tool); err == nil && t >= 0 && t <= len(nextstage) {
  237. nextstage[t-1] = 1
  238. }
  239. }
  240. for i := 4; i < len(nextstage); i++ { // 从位置1开始
  241. if nextstage[i] == 1 {
  242. switch i {
  243. case 4:
  244. taskstages = 13
  245. case 5:
  246. taskstages = 15
  247. }
  248. break
  249. }
  250. }
  251. }
  252. var data_default gorm_model.InfoAutoTask
  253. err = db.Model(gorm_model.InfoAutoTask{}).Where("auto_task_id = ?", project.AutoTaskID).Find(&data_default).Error
  254. if err != nil {
  255. return err
  256. }
  257. duration := time.Duration(data_default.CaseCloseDefault) * time.Hour
  258. err = db.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id in ?", TaskIDs).Updates(gorm_model.YoungeeTaskInfo{LinkStatus: 5, CurBreakAt: time.Now().Add(duration)}).Error
  259. if err != nil {
  260. logrus.WithContext(ctx).Errorf("[Link db] Update YoungeeTaskInfo error,err:%+v", err)
  261. return err
  262. }
  263. err = db.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id in ?", TaskIDs).Updates(gorm_model.YoungeeTaskInfo{TaskStage: taskstages}).Error
  264. if err != nil {
  265. logrus.WithContext(ctx).Errorf("[Link db] Update YoungeeTaskInfo error,err:%+v", err)
  266. return err
  267. }
  268. return nil
  269. }
  270. // AcceptLink 同意链接
  271. func LocalAcceptLink(ctx context.Context, TaskIDs []string, operatorid string, projectid string, isspecial int) error {
  272. var opid string
  273. var optype int
  274. opid = operatorid
  275. optype = 3
  276. db := GetReadDB(ctx)
  277. err := db.Model(gorm_model.YounggeeLinkInfo{}).Where("task_id in ? and is_review = 0", TaskIDs).Updates(map[string]interface{}{"is_ok": 1, "is_review": 1, "agree_at": time.Now(), "b_operator": opid, "b_operator_type": optype}).Error
  278. if err != nil {
  279. logrus.WithContext(ctx).Errorf("[Link db] Update YounggeeLinkInfo error,err:%+v", err)
  280. return err
  281. }
  282. var project gorm_model.YounggeeLocalLifeInfo
  283. err = db.Model(gorm_model.YounggeeLocalLifeInfo{}).Where("local_id = ?", projectid).Find(&project).Error
  284. if err != nil {
  285. logrus.WithContext(ctx).Errorf("[Sketch db] Find YounggeeLocalLifeInfo error,err:%+v", err)
  286. return err
  287. }
  288. taskstages := 13
  289. nextstage := [6]int{0, 0, 0, 0, 0, 0} // 数组长度为6,表示6种工具 4,9,11,13
  290. if isspecial == 1 {
  291. toolList := strings.Split(project.Tools, ",")
  292. for _, tool := range toolList {
  293. // 将 tool 转换为整数
  294. if t, err := strconv.Atoi(tool); err == nil && t >= 0 && t <= len(nextstage) {
  295. nextstage[t-1] = 1
  296. }
  297. }
  298. for i := 4; i < len(nextstage); i++ { // 从位置1开始
  299. if nextstage[i] == 1 {
  300. switch i {
  301. case 4:
  302. taskstages = 13
  303. case 5:
  304. taskstages = 15
  305. }
  306. break
  307. }
  308. }
  309. }
  310. var data_default gorm_model.InfoAutoTask
  311. err = db.Model(gorm_model.InfoAutoTask{}).Where("auto_task_id = ?", project.AutoTaskId).Find(&data_default).Error
  312. if err != nil {
  313. return err
  314. }
  315. duration := time.Duration(data_default.CaseCloseDefault) * time.Hour
  316. err = db.Model(gorm_model.YoungeeLocalTaskInfo{}).Where("task_id in ?", TaskIDs).Updates(gorm_model.YoungeeLocalTaskInfo{LinkStatus: 5, CurBreakAt: time.Now().Add(duration)}).Error
  317. if err != nil {
  318. logrus.WithContext(ctx).Errorf("[Link db] Update YoungeeLocalTaskInfo error,err:%+v", err)
  319. return err
  320. }
  321. err = db.Model(gorm_model.YoungeeLocalTaskInfo{}).Where("task_id in ?", TaskIDs).Updates(gorm_model.YoungeeLocalTaskInfo{TaskStage: taskstages}).Error
  322. if err != nil {
  323. logrus.WithContext(ctx).Errorf("[Link db] Update YoungeeLocalTaskInfo error,err:%+v", err)
  324. return err
  325. }
  326. return nil
  327. }
  328. // RejectLink 不同意链接
  329. func RejectLink(ctx context.Context, TaskIDs []string, operatorid string, projectid string) error {
  330. var opid string
  331. var optype int
  332. opid = operatorid
  333. optype = 3
  334. db := GetReadDB(ctx)
  335. err := db.Model(gorm_model.YounggeeLinkInfo{}).Where("task_id in ? and is_review = 0", TaskIDs).Updates(map[string]interface{}{"is_ok": 0, "is_review": 1, "reject_at": time.Now(), "b_operator": opid, "b_operator_type": optype}).Error
  336. if err != nil {
  337. logrus.WithContext(ctx).Errorf("[Link db] Update YounggeeLinkInfo error,err:%+v", err)
  338. return err
  339. }
  340. var project gorm_model.ProjectInfo
  341. err = db.Model(gorm_model.ProjectInfo{}).Where("project_id = ?", projectid).Find(&project).Error
  342. if err != nil {
  343. logrus.WithContext(ctx).Errorf("[Sketch db] Find ProjectInfo error,err:%+v", err)
  344. return err
  345. }
  346. var link_default gorm_model.InfoAutoTask
  347. err = db.Model(gorm_model.InfoAutoTask{}).Where("auto_task_id = ?", project.AutoTaskID).Find(&link_default).Error
  348. if err != nil {
  349. return err
  350. }
  351. duration := time.Duration(link_default.LinkBreach) * time.Hour
  352. err = db.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id in ?", TaskIDs).Updates(gorm_model.YoungeeTaskInfo{LinkStatus: 3, CurBreakAt: time.Now().Add(duration)}).Error
  353. if err != nil {
  354. logrus.WithContext(ctx).Errorf("[Link db] Update YoungeeTaskInfo error,err:%+v", err)
  355. return err
  356. }
  357. err = db.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id in ?", TaskIDs).Updates(gorm_model.YoungeeTaskInfo{TaskStage: 11}).Error
  358. if err != nil {
  359. logrus.WithContext(ctx).Errorf("[Link db] Update YoungeeTaskInfo error,err:%+v", err)
  360. return err
  361. }
  362. return nil
  363. }
  364. // RejectLink 不同意链接
  365. func LocalRejectLink(ctx context.Context, TaskIDs []string, operatorid string, projectid string) error {
  366. var opid string
  367. var optype int
  368. opid = operatorid
  369. optype = 3
  370. db := GetReadDB(ctx)
  371. err := db.Model(gorm_model.YounggeeLinkInfo{}).Where("task_id in ? and is_review = 0", TaskIDs).Updates(map[string]interface{}{"is_ok": 0, "is_review": 1, "reject_at": time.Now(), "b_operator": opid, "b_operator_type": optype}).Error
  372. if err != nil {
  373. logrus.WithContext(ctx).Errorf("[Link db] Update YounggeeLinkInfo error,err:%+v", err)
  374. return err
  375. }
  376. var project gorm_model.YounggeeLocalLifeInfo
  377. err = db.Model(gorm_model.YounggeeLocalLifeInfo{}).Where("local_id = ?", projectid).Find(&project).Error
  378. if err != nil {
  379. logrus.WithContext(ctx).Errorf("[Sketch db] Find ProjectInfo error,err:%+v", err)
  380. return err
  381. }
  382. var link_default gorm_model.InfoAutoTask
  383. err = db.Model(gorm_model.InfoAutoTask{}).Where("auto_task_id = ?", project.AutoTaskId).Find(&link_default).Error
  384. if err != nil {
  385. return err
  386. }
  387. duration := time.Duration(link_default.LinkBreach) * time.Hour
  388. err = db.Model(gorm_model.YoungeeLocalTaskInfo{}).Where("task_id in ?", TaskIDs).Updates(gorm_model.YoungeeLocalTaskInfo{LinkStatus: 3, CurBreakAt: time.Now().Add(duration)}).Error
  389. if err != nil {
  390. logrus.WithContext(ctx).Errorf("[Link db] Update YoungeeLocalTaskInfo error,err:%+v", err)
  391. return err
  392. }
  393. err = db.Model(gorm_model.YoungeeLocalTaskInfo{}).Where("task_id in ?", TaskIDs).Updates(gorm_model.YoungeeLocalTaskInfo{TaskStage: 11}).Error
  394. if err != nil {
  395. logrus.WithContext(ctx).Errorf("[Link db] Update YoungeeLocalTaskInfo error,err:%+v", err)
  396. return err
  397. }
  398. return nil
  399. }
  400. // GetSpecialTaskLinkList 专项任务-查询上传链接的task list
  401. func GetSpecialTaskLinkList(ctx context.Context, projectID string, pageSize, pageNum int64, conditions *common_model.TalentConditions) ([]*http_model.SpecialTaskLinkInfo, int64, error) {
  402. db := GetReadDB(ctx)
  403. // 查询Task表信息
  404. db = db.Debug().Model(gorm_model.YoungeeTaskInfo{}).Where("task_status = 2")
  405. // 根据Project条件过滤
  406. conditionType := reflect.TypeOf(conditions).Elem()
  407. conditionValue := reflect.ValueOf(conditions).Elem()
  408. var platform_nickname string = ""
  409. for i := 0; i < conditionType.NumField(); i++ {
  410. field := conditionType.Field(i)
  411. tag := field.Tag.Get("condition")
  412. value := conditionValue.FieldByName(field.Name)
  413. if tag == "link_status" {
  414. fmt.Printf("link %+v", value.Interface() == int64(0))
  415. if value.Interface() == int64(0) {
  416. db = db.Where("task_stage = 12")
  417. } else {
  418. db = db.Where("task_stage > 12 and task_stage <> 16")
  419. }
  420. continue
  421. } else if !util.IsBlank(value) {
  422. if tag == "platform_nickname" {
  423. platform_nickname = fmt.Sprintf("%v", value.Interface())
  424. continue
  425. } else if tag == "project_id" {
  426. db = db.Where(fmt.Sprintf("%s = ?", tag), value.Interface())
  427. }
  428. }
  429. }
  430. var taskInfos []gorm_model.YoungeeTaskInfo
  431. db = db.Model(gorm_model.YoungeeTaskInfo{})
  432. // 查询总数
  433. var totalTask int64
  434. if err := db.Count(&totalTask).Error; err != nil {
  435. logrus.WithContext(ctx).Errorf("[GetProjectTaskList] error query mysql total, err:%+v", err)
  436. return nil, 0, err
  437. }
  438. db.Order("task_id").Find(&taskInfos)
  439. // 查询任务id
  440. var taskIds []string
  441. taskMap := make(map[string]gorm_model.YoungeeTaskInfo)
  442. for _, taskInfo := range taskInfos {
  443. taskIds = append(taskIds, taskInfo.TaskID)
  444. taskMap[taskInfo.TaskID] = taskInfo
  445. }
  446. db1 := GetReadDB(ctx)
  447. db1 = db1.Debug().Model(gorm_model.YounggeeLinkInfo{})
  448. var LinkInfos []gorm_model.YounggeeLinkInfo
  449. db1 = db1.Model(gorm_model.YounggeeLinkInfo{}).Where("task_id IN ? AND is_submit=? ", taskIds, 1)
  450. if conditions.LinkStatus == int64(0) {
  451. db1 = db1.Where("is_review = 0").Find(&LinkInfos)
  452. } else {
  453. db1 = db1.Where("is_ok = 1").Find(&LinkInfos)
  454. }
  455. LinkMap := make(map[string]gorm_model.YounggeeLinkInfo)
  456. for _, LinkInfo := range LinkInfos {
  457. LinkMap[LinkInfo.TaskID] = LinkInfo
  458. }
  459. // 查询总数
  460. var totalLink int64
  461. if err := db1.Count(&totalLink).Error; err != nil {
  462. logrus.WithContext(ctx).Errorf("[GetProjectTalentList] error query mysql total, err:%+v", err)
  463. return nil, 0, err
  464. }
  465. var misNum int64
  466. if totalLink > totalTask {
  467. misNum = totalLink - totalTask
  468. } else {
  469. misNum = totalTask - totalLink
  470. }
  471. //logrus.Println("totalLink,totalTalent,misNum:", totalLink, totalTask, misNum)
  472. // 查询该页数据
  473. limit := pageSize + misNum
  474. offset := pageSize * pageNum // assert pageNum start with 0
  475. err := db.Order("task_id").Limit(int(limit)).Offset(int(offset)).Error
  476. if err != nil {
  477. logrus.WithContext(ctx).Errorf("[GetProjectTaskList] error query mysql total, err:%+v", err)
  478. return nil, 0, err
  479. }
  480. var TaskLinks []*http_model.SpecialTaskLink
  481. var taskLinks []*http_model.SpecialTaskLinkInfo
  482. var newTaskLinks []*http_model.SpecialTaskLinkInfo
  483. for _, taskId := range taskIds {
  484. TaskLink := new(http_model.SpecialTaskLink)
  485. TaskLink.Talent = taskMap[taskId]
  486. TaskLink.Link = LinkMap[taskId]
  487. TaskLinks = append(TaskLinks, TaskLink)
  488. }
  489. taskLinks = pack.SpecialTaskLinkToTaskInfo(TaskLinks)
  490. for _, v := range taskLinks {
  491. if platform_nickname == "" {
  492. newTaskLinks = append(newTaskLinks, v)
  493. } else if strings.Contains(v.PlatformNickname, platform_nickname) {
  494. newTaskLinks = append(newTaskLinks, v)
  495. } else if strings.Contains(conv.MustString(v.TaskID, ""), platform_nickname) {
  496. newTaskLinks = append(newTaskLinks, v)
  497. } else {
  498. totalTask--
  499. }
  500. }
  501. return newTaskLinks, totalTask, nil
  502. }