locallife_task.go 42 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331
  1. package db
  2. import (
  3. "context"
  4. "errors"
  5. "fmt"
  6. "github.com/issue9/conv"
  7. "github.com/sirupsen/logrus"
  8. "gorm.io/gorm"
  9. "strconv"
  10. "strings"
  11. "time"
  12. "youngee_b_api/model/gorm_model"
  13. "youngee_b_api/model/http_model"
  14. )
  15. func GetLocalRecruittime(ctx context.Context, request http_model.GetLocalRecruitTimeRequest) (*http_model.GetLocalRecruitTimeResponse, error) {
  16. db := GetReadDB(ctx)
  17. var localinfo gorm_model.YounggeeLocalLifeInfo
  18. err := db.Model(&gorm_model.YounggeeLocalLifeInfo{}).Where("local_id = ?", request.ProjectId).Find(&localinfo).Error
  19. var result http_model.GetLocalRecruitTimeResponse
  20. if err != nil {
  21. return &result, err
  22. }
  23. result.RecruitTime = localinfo.RecruitDdl.Format("2006-01-02 15:04:05")
  24. return &result, nil
  25. }
  26. func GetLocalTalentstatusCount(db *gorm.DB, request http_model.GetLocalTalentstatusNumRequest, status int) (int64, error) {
  27. query := db.Model(&gorm_model.YoungeeLocalTaskInfo{}).Where("project_id = ? AND task_status = ?", request.ProjectId, status)
  28. // 计算总数
  29. var total int64
  30. if err := query.Count(&total).Error; err != nil {
  31. return 0, err
  32. }
  33. return total, nil
  34. }
  35. func GetLocalTalentstatusNumCount(ctx context.Context, request http_model.GetLocalTalentstatusNumRequest) (*http_model.GetLocalTalentstatusNumResponse, error) {
  36. db := GetReadDB(ctx)
  37. var unoperatenum, agreetalentnum, refusetalentnum int64
  38. unoperatenum, _ = GetLocalTalentstatusCount(db, request, 1)
  39. agreetalentnum, _ = GetLocalTalentstatusCount(db, request, 2)
  40. refusetalentnum, _ = GetLocalTalentstatusCount(db, request, 3)
  41. count := &http_model.GetLocalTalentstatusNumResponse{
  42. UnoperateTalentnum: unoperatenum,
  43. AgreeTalentnum: agreetalentnum,
  44. RefuseTalentnum: refusetalentnum,
  45. }
  46. return count, nil
  47. }
  48. func GetLocalTalentstatusNum(db *gorm.DB, request http_model.GetLocalTalentstatusCountRequest, status int) (int64, error) {
  49. query := db.Model(&gorm_model.YoungeeLocalTaskInfo{}).Where("project_id = ? AND task_stage = ?", request.ProjectId, status)
  50. var total int64
  51. if err := query.Count(&total).Error; err != nil {
  52. return 0, err
  53. }
  54. return total, nil
  55. }
  56. func GetLocalTalentstatusCountNum(ctx context.Context, request http_model.GetLocalTalentstatusCountRequest) (*http_model.GetLocalTalentstatusCountResponse, error) {
  57. db := GetReadDB(ctx)
  58. var unoperatenum, agreetalentnum, refusetalentnum int64
  59. unoperatenum, _ = GetLocalTalentstatusNum(db, request, request.TaskStage)
  60. agreetalentnum, _ = GetLocalTalentstatusNum(db, request, request.TaskStage+1)
  61. refusetalentnum, _ = GetLocalTalentstatusNum(db, request, request.TaskStage+2)
  62. count := &http_model.GetLocalTalentstatusCountResponse{
  63. UnoperateTalentnum: unoperatenum,
  64. AgreeTalentnum: agreetalentnum,
  65. RefuseTalentnum: refusetalentnum,
  66. }
  67. return count, nil
  68. }
  69. func GetLocallifetaskList(ctx context.Context, request http_model.GetLocalTaskListRequest) (*http_model.GetLocalTaskListData, error) {
  70. db := GetReadDB(ctx)
  71. var projecrtaskinfo []gorm_model.YoungeeLocalTaskInfo
  72. query := db.Model(&gorm_model.YoungeeLocalTaskInfo{}).Where("local_id = ? AND task_status = ?", request.ProjectId, request.CoopType)
  73. var localinfo gorm_model.YounggeeLocalLifeInfo
  74. err := db.Model(&gorm_model.YounggeeLocalLifeInfo{}).Where("local_id = ?", request.ProjectId).First(&localinfo).Error
  75. if err != nil {
  76. return &http_model.GetLocalTaskListData{}, err
  77. }
  78. // 构建查询条件
  79. if request.FeeFrom != nil {
  80. query = query.Where("fee_form = ?", request.FeeFrom)
  81. }
  82. if request.Type != nil {
  83. switch *request.Type {
  84. case 1:
  85. query = query.Where("supplier_id = 0 AND supplier_status = 0")
  86. case 2:
  87. query = query.Where("supplier_id !=0 AND supplier_status = 2")
  88. }
  89. }
  90. if request.Others != "" {
  91. query = query.Where("talent_name LIKE ? OR s_operate_name LIKE ?", "%"+request.Others+"%", "%"+request.Others+"%")
  92. }
  93. if request.TalentFromList != "" {
  94. provinceList := strings.Split(request.TalentFromList, ",") // 解析传入的省份列表
  95. query = query.Where("SUBSTRING_INDEX(city, ' ', 1) IN (?)", provinceList) // 提取城市字段中的省份并进行匹配
  96. }
  97. // 计算总数
  98. var total int64
  99. if err := query.Count(&total).Error; err != nil {
  100. return nil, err
  101. }
  102. // 添加分页逻辑
  103. pageSize := request.PageSize
  104. if pageSize == 0 {
  105. pageSize = 10
  106. }
  107. pageNum := request.PageNum
  108. if pageNum == 0 {
  109. pageNum = 1
  110. }
  111. offset := (pageNum - 1) * pageSize
  112. // 处理多字段排序逻辑
  113. if len(request.SortField) > 0 && len(request.SortOrder) > 0 && len(request.SortField) == len(request.SortOrder) {
  114. for i := 0; i < len(request.SortField); i++ {
  115. field := request.SortField[i]
  116. order := request.SortOrder[i]
  117. switch field {
  118. case "fansnum":
  119. if order == "asc" {
  120. query = query.Order("fans_num asc")
  121. } else {
  122. query = query.Order("fans_num desc")
  123. }
  124. case "voteavg":
  125. if order == "asc" {
  126. query = query.Order("vote_avg asc")
  127. } else {
  128. query = query.Order("vote_avg desc")
  129. }
  130. case "commentavg":
  131. if order == "asc" {
  132. query = query.Order("commit_avg asc")
  133. } else {
  134. query = query.Order("commit_avg desc")
  135. }
  136. case "collectnum":
  137. if order == "asc" {
  138. query = query.Order("view_num asc")
  139. } else {
  140. query = query.Order("view_num desc")
  141. }
  142. }
  143. }
  144. } else {
  145. // Default sorting if no valid sort parameters
  146. query = query.Order("task_status asc").Order("task_stage asc")
  147. }
  148. // 执行分页查询
  149. if err := query.Offset(offset).Limit(pageSize).Find(&projecrtaskinfo).Error; err != nil {
  150. return nil, err
  151. }
  152. taskInfoPointers := make([]*http_model.LocaLTaskInfo, 0, len(projecrtaskinfo))
  153. for _, task := range projecrtaskinfo {
  154. var Time time.Time
  155. switch request.CoopType {
  156. case 1:
  157. Time = task.CreateDate
  158. case 2:
  159. Time = task.SelectDate //2 signedtime
  160. case 3:
  161. Time = task.CompleteDate
  162. }
  163. var listtime, stageintro string
  164. switch task.TaskStage {
  165. case 4:
  166. {
  167. listtime = task.SelectDate.Format("2006-01-02 15:04:05")
  168. stageintro = "执行开始时间"
  169. }
  170. case 5:
  171. {
  172. listtime = task.ReserveTime.Format("2006-01-02 15:04:05")
  173. stageintro = "达人探店时间预约申请时间"
  174. }
  175. case 6:
  176. {
  177. listtime = task.ExploreTime.Format("2006-01-02 15:04:05")
  178. stageintro = "达人探店时间预约申请时间"
  179. }
  180. case 9:
  181. {
  182. listtime = task.CurBreakAt.Format("2006-01-02 15:04:05")
  183. stageintro = "初稿上传截止时间"
  184. }
  185. case 10:
  186. {
  187. var sketchinfo gorm_model.YounggeeSketchInfo
  188. err := db.Model(&gorm_model.YounggeeSketchInfo{}).Where("task_id = ? and is_review = 0", task.TaskId).First(&sketchinfo).Error
  189. if err != nil {
  190. return nil, err
  191. }
  192. listtime = sketchinfo.SubmitAt.Format("2006-01-02 15:04:05")
  193. stageintro = "达人上传初稿时间" //
  194. }
  195. case 11:
  196. {
  197. listtime = task.CurBreakAt.Format("2006-01-02 15:04:05")
  198. stageintro = " 链接上传截止时间"
  199. }
  200. case 12:
  201. {
  202. var linkinfo gorm_model.YounggeeLinkInfo
  203. err := db.Model(&gorm_model.YounggeeLinkInfo{}).Where("task_id = ? and is_review = 0", task.TaskId).First(&linkinfo).Error
  204. if err != nil {
  205. return nil, err
  206. }
  207. listtime = linkinfo.SubmitAt.Format("2006-01-02 15:04:05")
  208. stageintro = "达人上传链接时间"
  209. }
  210. case 13:
  211. {
  212. listtime = task.CurBreakAt.Format("2006-01-02 15:04:05")
  213. stageintro = "数据待传截止时间"
  214. }
  215. case 14:
  216. {
  217. var datainfo gorm_model.YounggeeDataInfo
  218. err := db.Model(&gorm_model.YounggeeDataInfo{}).Where("task_id = ? and is_review = 0", task.TaskId).First(&datainfo).Error
  219. if err != nil {
  220. return nil, err
  221. }
  222. listtime = datainfo.SubmitAt.Format("2006-01-02 15:04:05")
  223. stageintro = "品牌最晚结算时间"
  224. }
  225. case 15:
  226. {
  227. listtime = task.CompleteDate.Format("2006-01-02 15:04:05")
  228. stageintro = "品牌结算时间"
  229. }
  230. case 16:
  231. {
  232. listtime = task.CancelTime.Format("2006-01-02 15:04:05")
  233. stageintro = "解约时间"
  234. }
  235. }
  236. boperator := getBOperator(db, task.BOperator, task.BOperatorType)
  237. nickname, headurl, gender, fans, voteavg := getTalentinfo(db, task.TalentId)
  238. Iscoop := getIscoop(db, task.TalentId, request.EnterPriseId)
  239. s_type, s_name := stype(db, task.SupplierId, task.SupplierStatus, localinfo.LocalType)
  240. response := &http_model.LocaLTaskInfo{
  241. TaskId: task.TaskId,
  242. ProjectId: task.LocalId,
  243. TalentId: task.TalentId,
  244. FansNum: fans,
  245. DraftFee: task.DraftFee,
  246. Voteavg: voteavg,
  247. FeeFrom: task.FeeForm,
  248. TaskStage: task.TaskStage,
  249. Commentavg: 0,
  250. CollectNum: 0,
  251. CurrentDefaultType: task.CurDefaultType,
  252. From: determineFrom(task.SupplierId, task.SupplierStatus),
  253. SType: s_type,
  254. SName: s_name,
  255. Boperator: boperator,
  256. CreateAt: Time.Format("2006-01-02 15:04:05"),
  257. NickName: nickname,
  258. HeadUrl: headurl,
  259. ISCoop: Iscoop,
  260. Gender: gender,
  261. Sprojectid: task.SLocalLifeId,
  262. City: task.City,
  263. StageIntro: stageintro,
  264. ListTime: listtime,
  265. }
  266. taskInfoPointers = append(taskInfoPointers, response)
  267. }
  268. return &http_model.GetLocalTaskListData{
  269. TaskList: taskInfoPointers,
  270. Total: conv.MustString(total, ""),
  271. }, nil
  272. }
  273. func PassLocalTaskCoop(ctx context.Context, req http_model.PasslocalTaskCoopRequest) (bool, error) {
  274. db := GetReadDB(ctx)
  275. var count int64
  276. err := db.Model(gorm_model.YoungeeLocalTaskInfo{}).Where("task_id IN ? AND task_stage = 1", req.TaskIds).Count(&count).Error
  277. if err != nil {
  278. return false, err
  279. }
  280. if int64(len(req.TaskIds)) == 0 || count != int64(len(req.TaskIds)) {
  281. return false, errors.New("任务id有误")
  282. }
  283. // 2. 查询任务对应达人id(用于生成达人消息)
  284. var talentIds []string
  285. err = db.Model(gorm_model.YoungeeLocalTaskInfo{}).Where("task_id IN ?", req.TaskIds).Select("talent_id").Find(&talentIds).Error
  286. if err != nil {
  287. return false, err
  288. }
  289. // 3. 查询任务对应project名称(用于生成达人消息)
  290. var project gorm_model.YounggeeLocalLifeInfo
  291. err = db.Model(gorm_model.YounggeeLocalLifeInfo{}).Where("local_id = ?", req.ProjectId).Find(&project).Error
  292. if err != nil {
  293. return false, err
  294. }
  295. var taskstages int
  296. if project.TaskForm == 1 {
  297. taskstages = 4
  298. } else {
  299. taskstages = 9
  300. }
  301. nextstage := [6]int{0, 0, 0, 0, 0, 0} // 数组长度为6,表示6种工具 4,9,11,13
  302. if req.IsSpecial == 1 {
  303. toolList := strings.Split(project.Tools, ",")
  304. for _, tool := range toolList {
  305. // 将 tool 转换为整数
  306. if t, err := strconv.Atoi(tool); err == nil && t >= 0 && t <= len(nextstage) {
  307. nextstage[t-1] = 1
  308. }
  309. }
  310. fmt.Println(nextstage)
  311. for i := 1; i < len(nextstage); i++ { // 从位置1开始
  312. if nextstage[i] == 1 {
  313. switch i {
  314. case 1:
  315. taskstages = 4
  316. case 2:
  317. taskstages = 9
  318. case 3:
  319. taskstages = 11
  320. case 4:
  321. taskstages = 13
  322. case 5:
  323. taskstages = 15
  324. }
  325. break
  326. }
  327. }
  328. }
  329. //4.根据达人来源改变状态、阶段、数目
  330. var tasks []gorm_model.YoungeeLocalTaskInfo
  331. err = db.Model(gorm_model.YoungeeLocalTaskInfo{}).Where("task_id IN ? AND task_stage = 1", req.TaskIds).Find(&tasks).Error
  332. if err != nil {
  333. return false, err
  334. }
  335. err = db.Transaction(func(tx *gorm.DB) error {
  336. // 2. 修改任务状态和任务阶段
  337. for _, taskInfo := range tasks {
  338. if taskInfo.SupplierId != 0 && taskInfo.SupplierStatus == 2 { //服务商招募数量+1
  339. updateData := gorm_model.YoungeeLocalTaskInfo{
  340. TaskStage: taskstages,
  341. TaskStatus: 2,
  342. UpdateAt: time.Now(),
  343. BOperator: req.OperatorId,
  344. BOperatorType: req.OperateType,
  345. SelectDate: time.Now(),
  346. }
  347. err = tx.Model(gorm_model.YoungeeLocalTaskInfo{}).Where("task_id = ? AND task_stage = 1", taskInfo.TaskId).Updates(updateData).Error
  348. if err != nil {
  349. return err
  350. }
  351. //project招募数+1,预估成本+服务商价格
  352. var projectinfo gorm_model.YounggeeLocalLifeInfo
  353. err = db.Model(gorm_model.YounggeeLocalLifeInfo{}).Where("local_id = ?", req.ProjectId).Find(&projectinfo).Error
  354. if err != nil {
  355. return err
  356. }
  357. projectinfo.RecruitNum += 1
  358. projectinfo.EstimatedCost += taskInfo.SupportFee
  359. err = tx.Model(gorm_model.YounggeeLocalLifeInfo{}).Where("local_id = ? ", req.ProjectId).Updates(projectinfo).Error
  360. if err != nil {
  361. return err
  362. }
  363. //服务商s_project已招募人数+1改成s_locallife
  364. var sprojectinfo gorm_model.YounggeeSProjectInfo
  365. err = db.Model(gorm_model.YounggeeSProjectInfo{}).Where(" s_project_id =?", taskInfo.SLocalLifeId).Find(&sprojectinfo).Error
  366. if err != nil {
  367. return err
  368. }
  369. sprojectinfo.RecruitNum += 1
  370. fmt.Println("......", projectinfo.RecruitNum)
  371. err = tx.Model(gorm_model.YounggeeSProjectInfo{}).Where(" s_project_id =?", taskInfo.SLocalLifeId).Updates(sprojectinfo).Error
  372. if err != nil {
  373. return err
  374. } //
  375. }
  376. //if project.TaskForm != 1 { //素材分发
  377. // var draft_default gorm_model.InfoAutoTask
  378. // err = db.Model(gorm_model.InfoAutoTask{}).Where("auto_task_id = ?", project.AutoTaskId).Find(&draft_default).Error
  379. // if err != nil {
  380. // return err
  381. // }
  382. // duration := time.Duration(draft_default.DraftDefault) * time.Hour
  383. // upbreakdate := gorm_model.YoungeeLocalTaskInfo{
  384. // CurBreakAt: time.Now().Add(duration),
  385. // }
  386. // err = tx.Model(gorm_model.YoungeeLocalTaskInfo{}).Where("task_id = ? ", taskInfo.TaskId).Updates(upbreakdate).Error
  387. // if err != nil {
  388. // return err
  389. // }
  390. //}
  391. if taskInfo.SupplierId == 0 && taskInfo.SupplierStatus == 0 { //来源于公海
  392. updateData := gorm_model.YoungeeLocalTaskInfo{
  393. TaskStage: taskstages,
  394. TaskStatus: 2,
  395. UpdateAt: time.Now(),
  396. BOperator: req.OperatorId,
  397. BOperatorType: req.OperateType,
  398. SelectDate: time.Now(),
  399. }
  400. err = tx.Model(gorm_model.YoungeeLocalTaskInfo{}).Where("task_id = ? AND task_stage = 1", taskInfo.TaskId).Updates(updateData).Error
  401. if err != nil {
  402. return err
  403. }
  404. //project招募数+1
  405. var projectinfo gorm_model.YounggeeLocalLifeInfo
  406. err = db.Model(gorm_model.YounggeeLocalLifeInfo{}).Where("local_id = ?", req.ProjectId).Find(&projectinfo).Error
  407. if err != nil {
  408. return err
  409. }
  410. projectinfo.RecruitNum += 1
  411. err = tx.Model(gorm_model.YounggeeLocalLifeInfo{}).Where("local_id = ? ", req.ProjectId).Updates(projectinfo).Error
  412. if err != nil {
  413. return err
  414. }
  415. }
  416. }
  417. // 4. 生成达人消息
  418. for _, talendId := range talentIds {
  419. err = CreateMessage(ctx, 1, 1, talendId, project.LocalName)
  420. if err != nil {
  421. return err
  422. }
  423. }
  424. // 返回 nil 提交事务
  425. return nil
  426. })
  427. if err != nil {
  428. return false, err
  429. }
  430. return true, nil
  431. }
  432. func RefuseLocalTaskCoop(ctx context.Context, req http_model.RefuselocalTaskCoopRequest) (bool, error) {
  433. db := GetWriteDB(ctx)
  434. // 1. 校验
  435. var count int64
  436. err := db.Model(gorm_model.YoungeeLocalTaskInfo{}).Where("task_id IN ? AND task_stage = 1", req.TaskIds).Count(&count).Error
  437. if err != nil {
  438. return false, err
  439. }
  440. if count != int64(len(req.TaskIds)) {
  441. return false, errors.New("任务id有误")
  442. }
  443. // 2. 查询任务对应达人id(用于生成达人消息)
  444. var talentIds []string
  445. err = db.Model(gorm_model.YoungeeLocalTaskInfo{}).Where("task_id IN ?", req.TaskIds).Select("talent_id").Find(&talentIds).Error
  446. if err != nil {
  447. return false, err
  448. }
  449. var tasks []gorm_model.YoungeeLocalTaskInfo
  450. err = db.Model(gorm_model.YoungeeLocalTaskInfo{}).Where("task_id IN ? AND task_stage = 1", req.TaskIds).Find(&tasks).Error
  451. err = db.Transaction(func(tx *gorm.DB) error {
  452. // 2. 修改任务状态和任务阶段
  453. for _, taskInfo := range tasks {
  454. updateData := gorm_model.YoungeeLocalTaskInfo{
  455. TaskStage: 3,
  456. TaskStatus: 3,
  457. UpdateAt: time.Now(),
  458. BOperator: req.OperatorId,
  459. BOperatorType: req.OperateType,
  460. CompleteDate: time.Now(),
  461. }
  462. err = tx.Model(gorm_model.YoungeeLocalTaskInfo{}).Where("task_id = ? AND task_stage = 1", taskInfo.TaskId).Updates(updateData).Error
  463. }
  464. if err != nil {
  465. return err
  466. }
  467. // 返回 nil 提交事务
  468. return nil
  469. })
  470. if err != nil {
  471. return false, err
  472. }
  473. return true, nil
  474. }
  475. func GetLocallifeData(ctx context.Context, req http_model.LocallifeDataRequest) (http_model.LocallifeDataResponse, error) {
  476. db := GetReadDB(ctx)
  477. var projectInfo gorm_model.YounggeeLocalLifeInfo
  478. // 查询项目基本信息
  479. if err := db.Where("local_id = ?", req.LocallifeId).First(&projectInfo).Error; err != nil {
  480. logrus.WithContext(ctx).Errorf("[Locallife db] GetLocallifeData error, err: %+v", err)
  481. return http_model.LocallifeDataResponse{}, err
  482. }
  483. fmt.Println("projectInfo---", projectInfo.LocalId)
  484. var projectTasks []gorm_model.YoungeeLocalTaskInfo
  485. if err := db.Where("local_id = ? AND task_status = ?", req.LocallifeId, 2).Find(&projectTasks).Error; err != nil {
  486. return http_model.LocallifeDataResponse{}, err
  487. }
  488. var totalTasks int64
  489. if err := db.Model(&gorm_model.YoungeeLocalTaskInfo{}).Where("local_id = ? AND task_status = ?", req.LocallifeId, 2).Count(&totalTasks).Error; err != nil {
  490. return http_model.LocallifeDataResponse{}, err
  491. }
  492. // 初始化统计数据
  493. dateStats := make(map[string]int)
  494. fansCounts := map[int64]int{0: 0, 1: 0, 2: 0, 3: 0}
  495. feeCounts := map[int]int{1: 0, 2: 0, 3: 0}
  496. startDate := *projectInfo.CreatedAt
  497. endDate := time.Now()
  498. // 填充日期统计
  499. for d := startDate; d.Before(endDate) || d.Equal(endDate); d = d.Add(24 * time.Hour) {
  500. dateStats[d.Format("2006-01-02")] = 0
  501. }
  502. var totalCost float64
  503. var totalFans int
  504. var serverTaskCount float64
  505. var maleCount int64
  506. // 处理每个任务
  507. for _, task := range projectTasks {
  508. totalCost += task.DraftFee
  509. var talentInfo gorm_model.YoungeeTalentInfo
  510. // 查询达人信息
  511. if err := db.Where("id = ?", task.TalentId).First(&talentInfo).Error; err != nil {
  512. logrus.WithContext(ctx).Errorf("[Locallife db] GetLocallifeData error, err: %+v", err)
  513. return http_model.LocallifeDataResponse{}, err
  514. }
  515. // 统计性别
  516. if talentInfo.Sex == 1 {
  517. maleCount++
  518. }
  519. totalFans += task.FansNum
  520. // 统计来自服务商的任务
  521. if task.SupplierId != 0 && task.SupplierStatus == 2 {
  522. serverTaskCount++
  523. }
  524. // 稿费形式统计
  525. feeCounts[task.FeeForm]++
  526. // 统计粉丝数
  527. switch {
  528. case task.FansNum < 10000:
  529. fansCounts[0]++
  530. case task.FansNum < 100000:
  531. fansCounts[1]++
  532. case task.FansNum < 1000000:
  533. fansCounts[2]++
  534. default:
  535. fansCounts[3]++
  536. }
  537. SelectDate := task.SelectDate.Format("2006-01-02")
  538. if _, exists := dateStats[SelectDate]; exists {
  539. dateStats[SelectDate]++
  540. }
  541. }
  542. // 计算平均值
  543. var avgFansNum int
  544. if totalTasks > 0 {
  545. avgFansNum = totalFans / int(totalTasks)
  546. } else {
  547. avgFansNum = 0
  548. }
  549. var fromType float64
  550. if totalTasks > 0 {
  551. fromType = serverTaskCount / float64(totalTasks)
  552. } else {
  553. fromType = 0
  554. }
  555. var manRatio float64
  556. if totalTasks > 0 {
  557. manRatio = float64(maleCount) / float64(totalTasks)
  558. } else {
  559. manRatio = 0
  560. }
  561. // 构建响应
  562. res := http_model.LocallifeDataResponse{
  563. Recruittime: *projectInfo.PassAt,
  564. RecruitDDl: *projectInfo.RecruitDdl,
  565. AgreeNum: projectInfo.RecruitNum,
  566. ApplyNum: projectInfo.ApplyNum,
  567. DraftFee: totalCost,
  568. AvgFansNum: avgFansNum,
  569. FromType: fromType,
  570. ManRatio: manRatio,
  571. DateStats: dateStats,
  572. FeeMap: feeCounts,
  573. FansMap: fansCounts,
  574. }
  575. return res, nil
  576. }
  577. func GetLocalPreSketchList(ctx context.Context, request http_model.LocalPreSketchListRequest) (*http_model.GetLocalSketchTaskListData, error) {
  578. db := GetReadDB(ctx)
  579. var localinfo gorm_model.YounggeeLocalLifeInfo
  580. err := db.Model(&gorm_model.YounggeeLocalLifeInfo{}).Where("local_id = ?", request.ProjectId).First(&localinfo).Error
  581. if err != nil {
  582. return &http_model.GetLocalSketchTaskListData{}, err
  583. }
  584. var projecrtaskinfo []gorm_model.YoungeeLocalTaskInfo
  585. query := db.Model(&gorm_model.YoungeeLocalTaskInfo{}).Where("local_id = ? AND task_stage = ?", request.ProjectId, request.ScriptStatus)
  586. if request.Others != "" {
  587. query = query.Where("talent_name LIKE ? OR s_operate_name LIKE ?", "%"+request.Others+"%", "%"+request.Others+"%")
  588. }
  589. // 计算总数
  590. var total int64
  591. if err := query.Count(&total).Error; err != nil {
  592. return nil, err
  593. }
  594. // 添加分页逻辑
  595. pageSize := request.PageSize
  596. if pageSize == 0 {
  597. pageSize = 10
  598. }
  599. pageNum := request.PageNum
  600. if pageNum == 0 {
  601. pageNum = 1
  602. }
  603. offset := (pageNum - 1) * pageSize
  604. // 执行分页查询
  605. // 处理多字段排序逻辑
  606. if len(request.SortField) > 0 && len(request.SortOrder) > 0 && len(request.SortField) == len(request.SortOrder) {
  607. for i := 0; i < len(request.SortField); i++ {
  608. field := request.SortField[i]
  609. order := request.SortOrder[i]
  610. switch field {
  611. case "fansnum":
  612. if order == "asc" {
  613. query = query.Order("fans_num asc")
  614. } else {
  615. query = query.Order("fans_num desc")
  616. }
  617. case "voteavg":
  618. if order == "asc" {
  619. query = query.Order("vote_avg asc")
  620. } else {
  621. query = query.Order("vote_avg desc")
  622. }
  623. case "commentavg":
  624. if order == "asc" {
  625. query = query.Order("commit_avg asc")
  626. } else {
  627. query = query.Order("commit_avg desc")
  628. }
  629. case "collectnum":
  630. if order == "asc" {
  631. query = query.Order("view_num asc")
  632. } else {
  633. query = query.Order("view_num desc")
  634. }
  635. }
  636. }
  637. } else {
  638. // Default sorting if no valid sort parameters
  639. query = query.Order("task_status asc").Order("task_stage asc")
  640. }
  641. if err := query.Offset(offset).Limit(pageSize).Find(&projecrtaskinfo).Error; err != nil {
  642. return nil, err
  643. }
  644. taskInfoPointers := make([]*http_model.LocalTasksketchInfo, 0, len(projecrtaskinfo))
  645. for _, task := range projecrtaskinfo {
  646. nickname, headurl, gender, fans, voteavg := getTalentinfo(db, task.TalentId)
  647. Iscoop := getIscoop(db, task.TalentId, request.EnterpriseId)
  648. s_type, s_name := stype(db, task.SupplierId, task.SupplierStatus, localinfo.LocalType)
  649. taskinfo := &http_model.LocaLTaskInfo{
  650. TaskId: task.TaskId,
  651. ProjectId: task.LocalId,
  652. TalentId: task.TalentId,
  653. FansNum: fans,
  654. DraftFee: task.DraftFee,
  655. Voteavg: voteavg,
  656. FeeFrom: task.FeeForm,
  657. TaskStage: task.TaskStage,
  658. Commentavg: 0,
  659. CurrentDefaultType: task.CurDefaultType,
  660. From: determineFrom(task.SupplierId, task.SupplierStatus),
  661. SType: s_type,
  662. SName: s_name,
  663. NickName: nickname,
  664. HeadUrl: headurl,
  665. Gender: gender,
  666. CollectNum: 0,
  667. ISCoop: Iscoop,
  668. City: task.City,
  669. }
  670. response := &http_model.LocalTasksketchInfo{
  671. Task: taskinfo,
  672. DDl: task.CurBreakAt.Format("2006-01-02 15:04:05"),
  673. }
  674. taskInfoPointers = append(taskInfoPointers, response)
  675. }
  676. return &http_model.GetLocalSketchTaskListData{
  677. TasksketchList: taskInfoPointers,
  678. Total: conv.MustString(total, ""),
  679. }, nil
  680. }
  681. func GetLocalSketchList(ctx context.Context, request http_model.LocalTasksketchlistRequest) (*http_model.GetsketchlocaltaskListData, error) {
  682. db := GetReadDB(ctx)
  683. var localinfo gorm_model.YounggeeLocalLifeInfo
  684. err := db.Model(&gorm_model.YounggeeLocalLifeInfo{}).Where("local_id = ?", request.ProjectId).First(&localinfo).Error
  685. if err != nil {
  686. return &http_model.GetsketchlocaltaskListData{}, err
  687. }
  688. var projecrtaskinfo []gorm_model.YoungeeLocalTaskInfo
  689. query := db.Model(&gorm_model.YoungeeLocalTaskInfo{}).Where("local_id = ? AND task_stage = ?", request.ProjectId, request.ScriptStatus)
  690. if request.Others != "" {
  691. query = query.Where("talent_name LIKE ? OR s_operate_name LIKE ?", "%"+request.Others+"%", "%"+request.Others+"%")
  692. }
  693. // 计算总数
  694. var total int64
  695. if err := query.Count(&total).Error; err != nil {
  696. return nil, err
  697. }
  698. // 添加分页逻辑
  699. pageSize := request.PageSize
  700. if pageSize == 0 {
  701. pageSize = 10
  702. }
  703. pageNum := request.PageNum
  704. if pageNum == 0 {
  705. pageNum = 1
  706. }
  707. offset := (pageNum - 1) * pageSize
  708. // 执行分页查询
  709. // 处理多字段排序逻辑
  710. if len(request.SortField) > 0 && len(request.SortOrder) > 0 && len(request.SortField) == len(request.SortOrder) {
  711. for i := 0; i < len(request.SortField); i++ {
  712. field := request.SortField[i]
  713. order := request.SortOrder[i]
  714. switch field {
  715. case "fansnum":
  716. if order == "asc" {
  717. query = query.Order("fans_num asc")
  718. } else {
  719. query = query.Order("fans_num desc")
  720. }
  721. case "voteavg":
  722. if order == "asc" {
  723. query = query.Order("vote_avg asc")
  724. } else {
  725. query = query.Order("vote_avg desc")
  726. }
  727. case "commentavg":
  728. if order == "asc" {
  729. query = query.Order("commit_avg asc")
  730. } else {
  731. query = query.Order("commit_avg desc")
  732. }
  733. case "collectnum":
  734. if order == "asc" {
  735. query = query.Order("view_num asc")
  736. } else {
  737. query = query.Order("view_num desc")
  738. }
  739. }
  740. }
  741. } else {
  742. // Default sorting if no valid sort parameters
  743. query = query.Order("task_status asc").Order("task_stage asc")
  744. }
  745. if err := query.Offset(offset).Limit(pageSize).Find(&projecrtaskinfo).Error; err != nil {
  746. return nil, err
  747. }
  748. taskInfoPointers := make([]*http_model.LocalTasksketchinfo, 0, len(projecrtaskinfo))
  749. for _, task := range projecrtaskinfo {
  750. nickname, headurl, gender, fans, voteavg := getTalentinfo(db, task.TalentId)
  751. s_type, s_name := stype(db, task.SupplierId, task.SupplierStatus, localinfo.LocalType)
  752. taskinfo := &http_model.LocaLTaskInfo{
  753. TaskId: task.TaskId,
  754. ProjectId: task.LocalId,
  755. TalentId: task.TalentId,
  756. FansNum: fans,
  757. DraftFee: task.DraftFee,
  758. Voteavg: voteavg,
  759. FeeFrom: task.FeeForm,
  760. TaskStage: task.TaskStage,
  761. Commentavg: 0,
  762. CollectNum: 0,
  763. CurrentDefaultType: task.CurDefaultType,
  764. SType: s_type,
  765. SName: s_name,
  766. From: determineFrom(task.SupplierId, task.SupplierStatus),
  767. NickName: nickname,
  768. Gender: gender,
  769. HeadUrl: headurl,
  770. City: task.City,
  771. }
  772. var sketchinfo gorm_model.YounggeeSketchInfo
  773. switch request.ScriptStatus {
  774. case 10:
  775. err := db.Model(&gorm_model.YounggeeSketchInfo{}).Where("task_id = ? and is_review = 0 ", task.TaskId).First(&sketchinfo).Error
  776. if err != nil {
  777. return nil, err
  778. }
  779. case 11:
  780. err := db.Model(&gorm_model.YounggeeSketchInfo{}).Where("task_id = ? and is_ok = 1", task.TaskId).First(&sketchinfo).Error
  781. if err != nil {
  782. return nil, err
  783. }
  784. }
  785. boperator := getBOperator(db, task.BOperator, task.BOperatorType)
  786. response := &http_model.LocalTasksketchinfo{
  787. Task: taskinfo,
  788. SketchId: sketchinfo.SketchID,
  789. SubmitAt: sketchinfo.SubmitAt.Format("2006-01-02 15:04:05"),
  790. AgreeAt: sketchinfo.AgreeAt.Format("2006-01-02 15:04:05"),
  791. Operator: boperator,
  792. }
  793. taskInfoPointers = append(taskInfoPointers, response)
  794. }
  795. return &http_model.GetsketchlocaltaskListData{
  796. LocalTasksketchList: taskInfoPointers,
  797. Total: conv.MustString(total, ""),
  798. }, nil
  799. }
  800. func GetLocalPreLinkList(ctx context.Context, request http_model.LocalPreLinkListRequest) (*http_model.GetLocalPreLinkListData, error) {
  801. db := GetReadDB(ctx)
  802. var localinfo gorm_model.YounggeeLocalLifeInfo
  803. err := db.Model(&gorm_model.YounggeeLocalLifeInfo{}).Where("local_id = ?", request.ProjectId).First(&localinfo).Error
  804. if err != nil {
  805. return &http_model.GetLocalPreLinkListData{}, err
  806. }
  807. var projecrtaskinfo []gorm_model.YoungeeLocalTaskInfo
  808. query := db.Model(&gorm_model.YoungeeLocalTaskInfo{}).Where("local_id = ? AND task_stage = ?", request.ProjectId, request.LinkStatus)
  809. if request.Others != "" {
  810. query = query.Where("talent_name LIKE ? OR s_operate_name LIKE ?", "%"+request.Others+"%", "%"+request.Others+"%")
  811. }
  812. // 计算总数
  813. var total int64
  814. if err := query.Count(&total).Error; err != nil {
  815. return nil, err
  816. }
  817. // 添加分页逻辑
  818. pageSize := request.PageSize
  819. if pageSize == 0 {
  820. pageSize = 10
  821. }
  822. pageNum := request.PageNum
  823. if pageNum == 0 {
  824. pageNum = 1
  825. }
  826. offset := (pageNum - 1) * pageSize
  827. // 执行分页查询
  828. // 处理多字段排序逻辑
  829. if len(request.SortField) > 0 && len(request.SortOrder) > 0 && len(request.SortField) == len(request.SortOrder) {
  830. for i := 0; i < len(request.SortField); i++ {
  831. field := request.SortField[i]
  832. order := request.SortOrder[i]
  833. switch field {
  834. case "fansnum":
  835. if order == "asc" {
  836. query = query.Order("fans_num asc")
  837. } else {
  838. query = query.Order("fans_num desc")
  839. }
  840. case "voteavg":
  841. if order == "asc" {
  842. query = query.Order("vote_avg asc")
  843. } else {
  844. query = query.Order("vote_avg desc")
  845. }
  846. case "commentavg":
  847. if order == "asc" {
  848. query = query.Order("commit_avg asc")
  849. } else {
  850. query = query.Order("commit_avg desc")
  851. }
  852. case "collectnum":
  853. if order == "asc" {
  854. query = query.Order("view_num asc")
  855. } else {
  856. query = query.Order("view_num desc")
  857. }
  858. }
  859. }
  860. } else {
  861. // Default sorting if no valid sort parameters
  862. query = query.Order("task_status asc").Order("task_stage asc")
  863. }
  864. if err := query.Offset(offset).Limit(pageSize).Find(&projecrtaskinfo).Error; err != nil {
  865. return nil, err
  866. }
  867. taskInfoPointers := make([]*http_model.LocalTasklinkinfo, 0, len(projecrtaskinfo))
  868. for _, task := range projecrtaskinfo {
  869. nickname, headurl, gender, fans, voteavg := getTalentinfo(db, task.TalentId)
  870. Iscoop := getIscoop(db, task.TalentId, request.EnterpriseId)
  871. s_type, s_name := stype(db, task.SupplierId, task.SupplierStatus, localinfo.LocalType)
  872. taskinfo := &http_model.LocaLTaskInfo{
  873. TaskId: task.TaskId,
  874. ProjectId: task.LocalId,
  875. TalentId: task.TalentId,
  876. FansNum: fans,
  877. DraftFee: task.DraftFee,
  878. Voteavg: voteavg,
  879. FeeFrom: task.FeeForm,
  880. TaskStage: task.TaskStage,
  881. Commentavg: 0,
  882. CollectNum: 0,
  883. CurrentDefaultType: task.CurDefaultType,
  884. From: determineFrom(task.SupplierId, task.SupplierStatus),
  885. SType: s_type,
  886. SName: s_name,
  887. NickName: nickname,
  888. HeadUrl: headurl,
  889. Gender: gender,
  890. ISCoop: Iscoop,
  891. City: task.City,
  892. }
  893. response := &http_model.LocalTasklinkinfo{
  894. Task: taskinfo,
  895. DDl: task.CurBreakAt.Format("2006-01-02 15:04:05"),
  896. }
  897. taskInfoPointers = append(taskInfoPointers, response)
  898. }
  899. return &http_model.GetLocalPreLinkListData{
  900. TasklinkList: taskInfoPointers,
  901. Total: conv.MustString(total, ""),
  902. }, nil
  903. }
  904. func GetLocalLinkList(ctx context.Context, request http_model.LocalTaskLinklistRequest) (*http_model.GetLocalTaskLinkListData, error) {
  905. db := GetReadDB(ctx)
  906. var localinfo gorm_model.YounggeeLocalLifeInfo
  907. err := db.Model(&gorm_model.YounggeeLocalLifeInfo{}).Where("local_id = ?", request.ProjectId).First(&localinfo).Error
  908. if err != nil {
  909. return &http_model.GetLocalTaskLinkListData{}, err
  910. }
  911. var projecrtaskinfo []gorm_model.YoungeeLocalTaskInfo
  912. query := db.Model(&gorm_model.YoungeeLocalTaskInfo{}).Where("local_id = ? AND task_stage = ?", request.ProjectId, request.LinkStatus)
  913. if request.Others != "" {
  914. query = query.Where("talent_name LIKE ? OR s_operate_name LIKE ?", "%"+request.Others+"%", "%"+request.Others+"%")
  915. }
  916. // 计算总数
  917. var total int64
  918. if err := query.Count(&total).Error; err != nil {
  919. return nil, err
  920. }
  921. // 添加分页逻辑
  922. pageSize := request.PageSize
  923. if pageSize == 0 {
  924. pageSize = 10
  925. }
  926. pageNum := request.PageNum
  927. if pageNum == 0 {
  928. pageNum = 1
  929. }
  930. offset := (pageNum - 1) * pageSize
  931. // 执行分页查询
  932. // 处理多字段排序逻辑
  933. if len(request.SortField) > 0 && len(request.SortOrder) > 0 && len(request.SortField) == len(request.SortOrder) {
  934. for i := 0; i < len(request.SortField); i++ {
  935. field := request.SortField[i]
  936. order := request.SortOrder[i]
  937. switch field {
  938. case "fansnum":
  939. if order == "asc" {
  940. query = query.Order("fans_num asc")
  941. } else {
  942. query = query.Order("fans_num desc")
  943. }
  944. case "voteavg":
  945. if order == "asc" {
  946. query = query.Order("vote_avg asc")
  947. } else {
  948. query = query.Order("vote_avg desc")
  949. }
  950. case "commentavg":
  951. if order == "asc" {
  952. query = query.Order("commit_avg asc")
  953. } else {
  954. query = query.Order("commit_avg desc")
  955. }
  956. case "collectnum":
  957. if order == "asc" {
  958. query = query.Order("view_num asc")
  959. } else {
  960. query = query.Order("view_num desc")
  961. }
  962. }
  963. }
  964. } else {
  965. // Default sorting if no valid sort parameters
  966. query = query.Order("task_status asc").Order("task_stage asc")
  967. }
  968. if err := query.Offset(offset).Limit(pageSize).Find(&projecrtaskinfo).Error; err != nil {
  969. return nil, err
  970. }
  971. taskInfoPointers := make([]*http_model.LocalTaskLinkinfo, 0, len(projecrtaskinfo))
  972. for _, task := range projecrtaskinfo {
  973. nickname, headurl, gender, fans, voteavg := getTalentinfo(db, task.TalentId)
  974. Iscoop := getIscoop(db, task.TalentId, request.EnterpriseId)
  975. s_type, s_name := stype(db, task.SupplierId, task.SupplierStatus, localinfo.LocalType)
  976. taskinfo := &http_model.LocaLTaskInfo{
  977. TaskId: task.TaskId,
  978. ProjectId: task.LocalId,
  979. TalentId: task.TalentId,
  980. FansNum: fans,
  981. DraftFee: task.DraftFee,
  982. Voteavg: voteavg,
  983. FeeFrom: task.FeeForm,
  984. TaskStage: task.TaskStage,
  985. Commentavg: 0,
  986. CollectNum: 0,
  987. CurrentDefaultType: task.CurDefaultType,
  988. From: determineFrom(task.SupplierId, task.SupplierStatus),
  989. SType: s_type,
  990. SName: s_name,
  991. NickName: nickname,
  992. HeadUrl: headurl,
  993. Gender: gender,
  994. ISCoop: Iscoop,
  995. City: task.City,
  996. }
  997. var linkinfo gorm_model.YounggeeLinkInfo
  998. switch request.LinkStatus {
  999. case "12":
  1000. err := db.Model(&gorm_model.YounggeeLinkInfo{}).Where("task_id = ? and is_review = 0 ", task.TaskId).First(&linkinfo).Error
  1001. if err != nil {
  1002. return nil, err
  1003. }
  1004. case "13":
  1005. err := db.Model(&gorm_model.YounggeeLinkInfo{}).Where("task_id = ? and is_ok = 1", task.TaskId).First(&linkinfo).Error
  1006. if err != nil {
  1007. return nil, err
  1008. }
  1009. }
  1010. boperator := getBOperator(db, task.BOperator, task.BOperatorType)
  1011. response := &http_model.LocalTaskLinkinfo{
  1012. Task: taskinfo,
  1013. LinkId: linkinfo.LinkID,
  1014. SubmitAt: linkinfo.SubmitAt.Format("2006-01-02 15:04:05"),
  1015. AgreeAt: linkinfo.AgreeAt.Format("2006-01-02 15:04:05"),
  1016. LinkUrl: linkinfo.LinkUrl,
  1017. PhotoUrl: linkinfo.PhotoUrl,
  1018. Operator: boperator,
  1019. }
  1020. taskInfoPointers = append(taskInfoPointers, response)
  1021. }
  1022. return &http_model.GetLocalTaskLinkListData{
  1023. LocalTaskLinklist: taskInfoPointers,
  1024. Total: conv.MustString(total, ""),
  1025. }, nil
  1026. }
  1027. func GetLocalPreDataList(ctx context.Context, request http_model.LocalPreDataListRequest) (*http_model.GetLocalPreDataListData, error) {
  1028. db := GetReadDB(ctx)
  1029. var localinfo gorm_model.YounggeeLocalLifeInfo
  1030. err := db.Model(&gorm_model.YounggeeLocalLifeInfo{}).Where("local_id = ?", request.ProjectId).First(&localinfo).Error
  1031. if err != nil {
  1032. return &http_model.GetLocalPreDataListData{}, err
  1033. }
  1034. var projecrtaskinfo []gorm_model.YoungeeLocalTaskInfo
  1035. query := db.Model(&gorm_model.YoungeeLocalTaskInfo{}).Where("local_id = ? AND task_stage = ?", request.ProjectId, request.DataStatus)
  1036. if request.Others != "" {
  1037. query = query.Where("talent_name LIKE ? OR s_operate_name LIKE ?", "%"+request.Others+"%", "%"+request.Others+"%")
  1038. }
  1039. // 计算总数
  1040. var total int64
  1041. if err := query.Count(&total).Error; err != nil {
  1042. return nil, err
  1043. }
  1044. // 添加分页逻辑
  1045. pageSize := request.PageSize
  1046. if pageSize == 0 {
  1047. pageSize = 10
  1048. }
  1049. pageNum := request.PageNum
  1050. if pageNum == 0 {
  1051. pageNum = 1
  1052. }
  1053. offset := (pageNum - 1) * pageSize
  1054. // 执行分页查询
  1055. // 处理多字段排序逻辑
  1056. if len(request.SortField) > 0 && len(request.SortOrder) > 0 && len(request.SortField) == len(request.SortOrder) {
  1057. for i := 0; i < len(request.SortField); i++ {
  1058. field := request.SortField[i]
  1059. order := request.SortOrder[i]
  1060. switch field {
  1061. case "fansnum":
  1062. if order == "asc" {
  1063. query = query.Order("fans_num asc")
  1064. } else {
  1065. query = query.Order("fans_num desc")
  1066. }
  1067. case "voteavg":
  1068. if order == "asc" {
  1069. query = query.Order("vote_avg asc")
  1070. } else {
  1071. query = query.Order("vote_avg desc")
  1072. }
  1073. case "commentavg":
  1074. if order == "asc" {
  1075. query = query.Order("commit_avg asc")
  1076. } else {
  1077. query = query.Order("commit_avg desc")
  1078. }
  1079. case "collectnum":
  1080. if order == "asc" {
  1081. query = query.Order("view_num asc")
  1082. } else {
  1083. query = query.Order("view_num desc")
  1084. }
  1085. }
  1086. }
  1087. } else {
  1088. // Default sorting if no valid sort parameters
  1089. query = query.Order("task_status asc").Order("task_stage asc")
  1090. }
  1091. if err := query.Offset(offset).Limit(pageSize).Find(&projecrtaskinfo).Error; err != nil {
  1092. return nil, err
  1093. }
  1094. taskInfoPointers := make([]*http_model.LocalTaskdatainfo, 0, len(projecrtaskinfo))
  1095. for _, task := range projecrtaskinfo {
  1096. nickname, headurl, gender, fans, voteavg := getTalentinfo(db, task.TalentId)
  1097. Iscoop := getIscoop(db, task.TalentId, request.EnterpriseId)
  1098. s_type, s_name := stype(db, task.SupplierId, task.SupplierStatus, localinfo.LocalType)
  1099. taskinfo := &http_model.LocaLTaskInfo{
  1100. TaskId: task.TaskId,
  1101. ProjectId: task.LocalId,
  1102. TalentId: task.TalentId,
  1103. FansNum: fans,
  1104. DraftFee: task.DraftFee,
  1105. Voteavg: voteavg,
  1106. FeeFrom: task.FeeForm,
  1107. TaskStage: task.TaskStage,
  1108. Commentavg: 0,
  1109. CollectNum: 0,
  1110. CurrentDefaultType: task.CurDefaultType,
  1111. From: determineFrom(task.SupplierId, task.SupplierStatus),
  1112. SType: s_type,
  1113. SName: s_name,
  1114. NickName: nickname,
  1115. HeadUrl: headurl,
  1116. Gender: gender,
  1117. ISCoop: Iscoop,
  1118. City: task.City,
  1119. }
  1120. response := &http_model.LocalTaskdatainfo{
  1121. Task: taskinfo,
  1122. DDl: task.CurBreakAt.Format("2006-01-02 15:04:05"),
  1123. }
  1124. taskInfoPointers = append(taskInfoPointers, response)
  1125. }
  1126. return &http_model.GetLocalPreDataListData{
  1127. TaskdataList: taskInfoPointers,
  1128. Total: conv.MustString(total, ""),
  1129. }, nil
  1130. }
  1131. func GetLocalDataList(ctx context.Context, request http_model.LocalTaskDatalistRequest) (*http_model.GetLocalTaskDatalistData, error) {
  1132. db := GetReadDB(ctx)
  1133. var localinfo gorm_model.YounggeeLocalLifeInfo
  1134. err := db.Model(&gorm_model.YounggeeLocalLifeInfo{}).Where("local_id = ?", request.ProjectId).First(&localinfo).Error
  1135. if err != nil {
  1136. return &http_model.GetLocalTaskDatalistData{}, err
  1137. }
  1138. var projecrtaskinfo []gorm_model.YoungeeLocalTaskInfo
  1139. query := db.Model(&gorm_model.YoungeeLocalTaskInfo{}).Where("local_id = ? AND task_stage = ?", request.ProjectId, request.DataStatus)
  1140. if request.Others != "" {
  1141. query = query.Where("talent_name LIKE ? OR s_operate_name LIKE ?", "%"+request.Others+"%", "%"+request.Others+"%")
  1142. }
  1143. // 计算总数
  1144. var total int64
  1145. if err := query.Count(&total).Error; err != nil {
  1146. return nil, err
  1147. }
  1148. // 添加分页逻辑
  1149. pageSize := request.PageSize
  1150. if pageSize == 0 {
  1151. pageSize = 10
  1152. }
  1153. pageNum := request.PageNum
  1154. if pageNum == 0 {
  1155. pageNum = 1
  1156. }
  1157. offset := (pageNum - 1) * pageSize
  1158. // 执行分页查询
  1159. // 处理多字段排序逻辑
  1160. if len(request.SortField) > 0 && len(request.SortOrder) > 0 && len(request.SortField) == len(request.SortOrder) {
  1161. for i := 0; i < len(request.SortField); i++ {
  1162. field := request.SortField[i]
  1163. order := request.SortOrder[i]
  1164. switch field {
  1165. case "fansnum":
  1166. if order == "asc" {
  1167. query = query.Order("fans_num asc")
  1168. } else {
  1169. query = query.Order("fans_num desc")
  1170. }
  1171. case "voteavg":
  1172. if order == "asc" {
  1173. query = query.Order("vote_avg asc")
  1174. } else {
  1175. query = query.Order("vote_avg desc")
  1176. }
  1177. case "commentavg":
  1178. if order == "asc" {
  1179. query = query.Order("commit_avg asc")
  1180. } else {
  1181. query = query.Order("commit_avg desc")
  1182. }
  1183. case "collectnum":
  1184. if order == "asc" {
  1185. query = query.Order("view_num asc")
  1186. } else {
  1187. query = query.Order("view_num desc")
  1188. }
  1189. }
  1190. }
  1191. } else {
  1192. // Default sorting if no valid sort parameters
  1193. query = query.Order("task_status asc").Order("task_stage asc")
  1194. }
  1195. if err := query.Offset(offset).Limit(pageSize).Find(&projecrtaskinfo).Error; err != nil {
  1196. return nil, err
  1197. }
  1198. taskInfoPointers := make([]*http_model.LocalTaskDatainfo, 0, len(projecrtaskinfo))
  1199. for _, task := range projecrtaskinfo {
  1200. nickname, headurl, gender, fans, voteavg := getTalentinfo(db, task.TalentId)
  1201. Iscoop := getIscoop(db, task.TalentId, request.EnterpriseId)
  1202. s_type, s_name := stype(db, task.SupplierId, task.SupplierStatus, localinfo.LocalType)
  1203. taskinfo := &http_model.LocaLTaskInfo{
  1204. TaskId: task.TaskId,
  1205. ProjectId: task.LocalId,
  1206. TalentId: task.TalentId,
  1207. FansNum: fans,
  1208. DraftFee: task.DraftFee,
  1209. Voteavg: voteavg,
  1210. FeeFrom: task.FeeForm,
  1211. TaskStage: task.TaskStage,
  1212. Commentavg: 0,
  1213. CollectNum: 0,
  1214. CurrentDefaultType: task.CurDefaultType,
  1215. From: determineFrom(task.SupplierId, task.SupplierStatus),
  1216. SType: s_type,
  1217. SName: s_name,
  1218. NickName: nickname,
  1219. HeadUrl: headurl,
  1220. Gender: gender,
  1221. ISCoop: Iscoop,
  1222. City: task.City,
  1223. }
  1224. var datainfo gorm_model.YounggeeDataInfo
  1225. switch request.DataStatus {
  1226. case "12":
  1227. err := db.Model(&gorm_model.YounggeeDataInfo{}).Where("task_id = ? and is_review = 0 ", task.TaskId).First(&datainfo).Error
  1228. if err != nil {
  1229. return nil, err
  1230. }
  1231. case "13":
  1232. err := db.Model(&gorm_model.YounggeeDataInfo{}).Where("task_id = ? and is_ok = 1", task.TaskId).First(&datainfo).Error
  1233. if err != nil {
  1234. return nil, err
  1235. }
  1236. }
  1237. boperator := getBOperator(db, task.BOperator, task.BOperatorType)
  1238. response := &http_model.LocalTaskDatainfo{
  1239. Task: taskinfo,
  1240. DataId: datainfo.DataID,
  1241. SubmitAt: datainfo.SubmitAt.Format("2006-01-02 15:04:05"),
  1242. AgreeAt: datainfo.AgreeAt.Format("2006-01-02 15:04:05"),
  1243. PhotoUrl: datainfo.PhotoUrl,
  1244. PlayNumber: datainfo.PlayNumber,
  1245. LikeNumber: datainfo.LikeNumber,
  1246. CollectNumber: datainfo.CollectNumber,
  1247. CommentNumber: datainfo.CommentNumber,
  1248. SettleAmount: task.SettleAmount,
  1249. Breakrate: task.SketchBreakRate + task.LinkBreakRate + task.DataBreakRate,
  1250. Operator: boperator,
  1251. }
  1252. taskInfoPointers = append(taskInfoPointers, response)
  1253. }
  1254. return &http_model.GetLocalTaskDatalistData{
  1255. LocalTaskDatalist: taskInfoPointers,
  1256. Total: conv.MustString(total, ""),
  1257. }, nil
  1258. }