operate.go 77 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593
  1. package db
  2. import (
  3. "context"
  4. "fmt"
  5. "github.com/caixw/lib.go/conv"
  6. "github.com/sirupsen/logrus"
  7. "log"
  8. "reflect"
  9. "time"
  10. "youngee_m_api/model/common_model"
  11. "youngee_m_api/model/gorm_model"
  12. "youngee_m_api/model/http_model"
  13. "youngee_m_api/util"
  14. )
  15. func CreatePricingStrategy(ctx context.Context, req *http_model.AddPricingRequest) (string, string, error) {
  16. db := GetReadDB(ctx)
  17. project_type, fee_form, platform, fans_low, fans_up, service_charge, base_offer := req.ProjectType, req.ManuscriptForm, req.Platform, req.FansLow, req.FansHigh, req.PlatformFee, req.BaseOffer
  18. var IsExclusive gorm_model.InfoPricingStrategy
  19. err := db.Where(" fee_form = ? && platform = ? && fans_low <= ? && fans_up >= ?", fee_form, platform, fans_low, fans_up).First(&IsExclusive).Error
  20. if err == nil {
  21. return "该策略与已经运行的策略互斥,请修改相关字段后重新创建", "", nil
  22. }
  23. var newStrategy gorm_model.InfoPricingStrategy
  24. var strategyInfo gorm_model.InfoPricingStrategy
  25. getMonth := time.Now().Format("01") //获取月
  26. getDay := time.Now().Day() //获取日
  27. dayString := ""
  28. if getDay < 10 {
  29. dayString = conv.MustString(getDay, "")
  30. dayString = "0" + dayString
  31. } else {
  32. dayString = conv.MustString(getDay, "")
  33. }
  34. monthAndDay := conv.MustString(getMonth, "") + dayString
  35. err = db.Where(fmt.Sprintf(" strategyId like '%s%%'", monthAndDay)).Last(&strategyInfo).Error
  36. num := 1
  37. if strategyInfo.StrategyId != "" {
  38. num = conv.MustInt(strategyInfo.StrategyId[4:6], 0)
  39. num = num + 1 //获取日
  40. } else {
  41. num = 1
  42. }
  43. numString := ""
  44. if num < 10 {
  45. numString = conv.MustString(num, "")
  46. numString = "0" + numString
  47. } else {
  48. numString = conv.MustString(num, "")
  49. }
  50. newStrategy.StrategyId = monthAndDay + numString
  51. newStrategy.Status = 0
  52. newStrategy.FansLow = fans_low
  53. newStrategy.FansUp = fans_up
  54. newStrategy.ProjectType = conv.MustInt64(project_type, 0)
  55. newStrategy.BaseOffer = conv.MustFloat32(base_offer, 0)
  56. newStrategy.Platform = conv.MustInt64(platform, 0)
  57. newStrategy.FeeForm = conv.MustInt64(fee_form, 0)
  58. newStrategy.ServiceCharge = conv.MustInt64(service_charge, 0)
  59. newStrategy.CreateAt = time.Now()
  60. newStrategy.UpdateAt = time.Now()
  61. err = db.Create(&newStrategy).Error
  62. if err != nil {
  63. return "创建失败", "", err
  64. }
  65. return "创建成功", monthAndDay + numString, nil
  66. }
  67. func SearchPricing(ctx context.Context, pageSize, pageNum int32, conditions *common_model.PricingConditions) ([]*gorm_model.InfoPricingStrategy, int64, error) {
  68. db := GetReadDB(ctx)
  69. db = db.Model(gorm_model.InfoPricingStrategy{})
  70. // 根据 查询条件过滤
  71. conditionType := reflect.TypeOf(conditions).Elem()
  72. conditionValue := reflect.ValueOf(conditions).Elem()
  73. for i := 0; i < conditionType.NumField(); i++ {
  74. field := conditionType.Field(i)
  75. tag := field.Tag.Get("condition")
  76. value := conditionValue.FieldByName(field.Name)
  77. if !util.IsBlank(value) && tag != "update_at" {
  78. db = db.Where(fmt.Sprintf("%s = ?", tag), value.Interface())
  79. } else if tag == "update_at" && value.Interface() != nil {
  80. db = db.Where(fmt.Sprintf("update_at like '%s%%'", value.Interface()))
  81. }
  82. }
  83. // 查询总数
  84. var total int64
  85. var PricingDatas []*gorm_model.InfoPricingStrategy
  86. if err := db.Count(&total).Error; err != nil {
  87. logrus.WithContext(ctx).Errorf("[SearchPricing] error query mysql total, err:%+v", err)
  88. return nil, 0, err
  89. }
  90. // 查询该页数据
  91. limit := pageSize
  92. offset := pageSize * pageNum // assert pageNum start with 0
  93. err := db.Order("update_at desc").Limit(int(limit)).Offset(int(offset)).Find(&PricingDatas).Error
  94. if err != nil {
  95. logrus.WithContext(ctx).Errorf("[SearchPricing] error query mysql find, err:%+v", err)
  96. return nil, 0, err
  97. }
  98. return PricingDatas, total, nil
  99. }
  100. func ModifyPricing(ctx context.Context, req *http_model.ModifyPricingRequest) (string, error) {
  101. db := GetReadDB(ctx)
  102. strategyId := req.StrategyId
  103. db = db.Model(gorm_model.InfoPricingStrategy{}).Where("strategyId = ?", strategyId)
  104. project_type, fee_form, platform, fans_low, fans_up, service_charge, base_offer := req.ProjectType, req.FeeForm, req.Platform, req.FansLow, req.FansHigh, req.PlatformFee, req.BaseOffer
  105. var IsExclusive gorm_model.InfoPricingStrategy
  106. err := db.Where(" fee_form = ? && platform = ? && fans_low <= ? && fans_up >= ?", fee_form, platform, fans_low, fans_up).First(&IsExclusive).Error
  107. if err == nil {
  108. return "要修改策略与已经运行的策略互斥,请修改相关字段", nil
  109. }
  110. err = db.Updates(map[string]interface{}{
  111. "project_type": project_type, "base_offer": base_offer, "fee_form": fee_form,
  112. "platform": platform, "fans_low": fans_low, "fans_up": fans_up, "service_charge": service_charge,
  113. }).Error
  114. if err != nil {
  115. return "", err
  116. }
  117. return "修改成功", nil
  118. }
  119. func UpdateAutoTaskTime(ctx context.Context, time int32, num int32) error {
  120. db := GetReadDB(ctx)
  121. var autoTaskInfo gorm_model.InfoAutoTask
  122. err := db.Model(gorm_model.InfoAutoTask{}).Last(&autoTaskInfo).Error
  123. if err != nil {
  124. logrus.WithContext(ctx).Errorf("[UpdateAutoTaskTime] error get Last mysql, err:%+v", err)
  125. return err
  126. }
  127. switch num {
  128. case 1:
  129. autoTaskInfo.SignInOffline = time
  130. case 2:
  131. autoTaskInfo.SignInVirtual = time
  132. case 3:
  133. autoTaskInfo.ReviewInMv = time
  134. case 4:
  135. autoTaskInfo.ReviewUnlimited = time
  136. case 5:
  137. autoTaskInfo.Postreview = time
  138. case 6:
  139. autoTaskInfo.CaseClose = time
  140. case 7:
  141. autoTaskInfo.Invalid = time
  142. case 8:
  143. autoTaskInfo.DraftDefaultInPic = time
  144. case 9:
  145. autoTaskInfo.DraftDefaultInMv = time
  146. case 10:
  147. autoTaskInfo.ScriptDefault = time
  148. case 11:
  149. autoTaskInfo.LinkBreach = time
  150. case 12:
  151. autoTaskInfo.CaseCloseDefault = time
  152. }
  153. autoTaskInfo.AutoTaskID += 1
  154. err = db.Model(gorm_model.InfoAutoTask{}).Create(&autoTaskInfo).Error
  155. if err != nil {
  156. logrus.WithContext(ctx).Errorf("[UpdateAutoTaskTime] error Create mysql, err:%+v", err)
  157. return err
  158. }
  159. return nil
  160. }
  161. func UpdateAutoDefaultRate(ctx context.Context, rate int, num int32) error {
  162. db := GetReadDB(ctx)
  163. autoDefaultRateInfo := gorm_model.InfoAutoDefaultHandle{}
  164. err := db.Model(&gorm_model.InfoAutoDefaultHandle{}).Last(&autoDefaultRateInfo).Error
  165. if err != nil {
  166. logrus.WithContext(ctx).Errorf("[UpdateAutoDefaultRate] error get Last mysql, err:%+v", err)
  167. return err
  168. }
  169. switch num {
  170. case 1:
  171. autoDefaultRateInfo.SketchReplaceNotUpload = rate
  172. case 2:
  173. autoDefaultRateInfo.SketchReplaceTimeOut = rate
  174. case 3:
  175. autoDefaultRateInfo.SketchOtherNotUpload = rate
  176. case 4:
  177. autoDefaultRateInfo.SketchOtherTimeOut = rate
  178. case 5:
  179. autoDefaultRateInfo.ScriptReplaceNotUpload = rate
  180. case 6:
  181. autoDefaultRateInfo.ScriptReplaceTimeOut = rate
  182. case 7:
  183. autoDefaultRateInfo.ScriptOtherNotUpload = rate
  184. case 8:
  185. autoDefaultRateInfo.ScriptOtherTimeOut = rate
  186. case 9:
  187. autoDefaultRateInfo.LinkReplaceNotUpload = rate
  188. case 10:
  189. autoDefaultRateInfo.LinkReplaceTimeOut = rate
  190. case 11:
  191. autoDefaultRateInfo.LinkOtherNotUpload = rate
  192. case 12:
  193. autoDefaultRateInfo.LinkOtherTimeOut = rate
  194. case 13:
  195. autoDefaultRateInfo.DataReplaceNotUpload = rate
  196. case 14:
  197. autoDefaultRateInfo.DataReplaceTimeOut = rate
  198. case 15:
  199. autoDefaultRateInfo.DataOtherNotUpload = rate
  200. case 16:
  201. autoDefaultRateInfo.DataOtherTimeOut = rate
  202. }
  203. autoDefaultRateInfo.AutoDefaultID += 1
  204. err = db.Model(&gorm_model.InfoAutoDefaultHandle{}).Create(autoDefaultRateInfo).Error
  205. if err != nil {
  206. logrus.WithContext(ctx).Errorf("[UpdateAutoDefaultRate] error Create mysql, err:%+v", err)
  207. return err
  208. }
  209. return nil
  210. }
  211. func GetSignInOfflineTask(projectForm int32) error {
  212. db := GetReadDB(context.Background())
  213. var projectInfos []*gorm_model.ProjectInfo
  214. err := db.Model(gorm_model.ProjectInfo{}).Where("project_type = ? AND project_form = ?", 1, projectForm).Find(&projectInfos).Error
  215. if err != nil {
  216. return err
  217. }
  218. projectIdMap := make(map[int64]int64)
  219. taskIDs := make(map[int]int)
  220. var projectIds []int64
  221. var taskIds []int
  222. var t int32
  223. for _, projectInfo := range projectInfos {
  224. autoTaskId := projectInfo.AutoTaskID
  225. dbStart := GetReadDB(context.Background())
  226. var autoTaskInfo gorm_model.InfoAutoTask
  227. dbStart.Model(gorm_model.InfoAutoTask{}).Where("auto_task_id = ?", autoTaskId).First(&autoTaskInfo)
  228. //fmt.Println("t:", autoTaskInfo.SignInOffline)
  229. if projectForm == 3 {
  230. t = autoTaskInfo.SignInOffline
  231. } else {
  232. t = autoTaskInfo.SignInVirtual
  233. }
  234. projectIds = append(projectIds, projectInfo.ProjectID)
  235. if _, ok := projectIdMap[projectInfo.ProjectID]; !ok {
  236. projectIdMap[projectInfo.ProjectID] = projectInfo.ContentType
  237. db1 := GetReadDB(context.Background())
  238. var taskInfos []gorm_model.YoungeeTaskInfo
  239. db1.Model(gorm_model.YoungeeTaskInfo{}).Where("project_id = ? AND logistics_status = ?", projectInfo.ProjectID, 2).Find(&taskInfos)
  240. //fmt.Println("taskInfos", taskInfos)
  241. for _, taskInfo := range taskInfos {
  242. fmt.Println("TaskId", taskInfo.TaskId)
  243. if _, ok1 := taskIDs[taskInfo.TaskId]; !ok1 {
  244. taskIds = append(taskIds, taskInfo.TaskId)
  245. taskIDs[taskInfo.TaskId] = taskInfo.ProjectId
  246. var logisticInfo gorm_model.YoungeeTaskLogistics
  247. db2 := GetReadDB(context.Background())
  248. db2.Model(gorm_model.YoungeeTaskLogistics{}).Where("task_id = ?", taskInfo.TaskId).Find(&logisticInfo)
  249. fmt.Println("logisticID", logisticInfo.LogisticsID)
  250. dd, _ := time.ParseDuration(conv.MustString(t, "") + "h")
  251. if logisticInfo.AutoSignAt.IsZero() {
  252. db5 := GetReadDB(context.Background())
  253. db5.Model(gorm_model.YoungeeTaskLogistics{}).Where("logistics_id = ?", logisticInfo.LogisticsID).
  254. Updates(&gorm_model.YoungeeTaskLogistics{AutoSignAt: logisticInfo.DeliveryTime.Add(dd)})
  255. fmt.Println("已添加自动签收时间")
  256. }
  257. }
  258. }
  259. }
  260. }
  261. //fmt.Println("projectIdMap", projectIdMap)
  262. fmt.Println("taskIds", taskIds)
  263. var logisticInfos []gorm_model.YoungeeTaskLogistics
  264. db3 := GetReadDB(context.Background())
  265. err = db3.Model(gorm_model.YoungeeTaskLogistics{}).Where("auto_sign_at <= ? AND task_id IN ?", time.Now(), taskIds).Find(&logisticInfos).Error
  266. if err != nil {
  267. log.Println("DB AutoGetSignInOfflineTask error :", err)
  268. return err
  269. }
  270. var signedTaskId []int
  271. for _, logisticInfo := range logisticInfos {
  272. signedTaskId = append(signedTaskId, logisticInfo.TaskID)
  273. if logisticInfo.SignedTime.IsZero() {
  274. db6 := GetReadDB(context.Background())
  275. db6.Model(gorm_model.YoungeeTaskLogistics{}).Where("logistics_id = ?", logisticInfo.LogisticsID).Updates(&gorm_model.YoungeeTaskLogistics{SignedTime: time.Now()})
  276. fmt.Println("已更新签收时间")
  277. }
  278. }
  279. util.RemoveIntRepByMap(signedTaskId)
  280. //fmt.Println("signedTaskId", signedTaskId)
  281. for _, taskID := range signedTaskId {
  282. //fmt.Println("taskID", taskID)
  283. db4 := GetReadDB(context.Background())
  284. taskNeedMod := gorm_model.YoungeeTaskInfo{}
  285. db4.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", taskID).Find(&taskNeedMod)
  286. if projectIdMap[int64(taskIDs[taskID])] == 1 {
  287. if taskNeedMod.LogisticsStatus == 2 && taskNeedMod.TaskStage == 5 {
  288. db4.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", taskID).Updates(&gorm_model.YoungeeTaskInfo{LogisticsStatus: 3, TaskStage: 9})
  289. fmt.Println("内容形式为图片的项目 已修改任务状态为待传初稿 及物流状态为已签收")
  290. }
  291. } else if projectIdMap[int64(taskIDs[taskID])] == 2 {
  292. if taskNeedMod.LogisticsStatus == 2 && taskNeedMod.TaskStage == 5 {
  293. db4.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", taskID).Updates(&gorm_model.YoungeeTaskInfo{LogisticsStatus: 3, TaskStage: 7})
  294. fmt.Println("内容形式为视频的项目 已修改任务状态为待传脚本 及物流状态为已签收")
  295. }
  296. }
  297. }
  298. return nil
  299. }
  300. func GetAutoReviewTask(contentType int32) error {
  301. db := GetReadDB(context.Background())
  302. var projectInfos []*gorm_model.ProjectInfo
  303. if contentType == 2 {
  304. err := db.Model(gorm_model.ProjectInfo{}).Where("project_type = ? AND content_type = ?", 1, contentType).Find(&projectInfos).Error
  305. if err != nil {
  306. return err
  307. }
  308. var projectIds []int64
  309. projectIdToAutoTaskIdMap := map[int64]int{}
  310. for _, projectInfo := range projectInfos {
  311. projectIds = append(projectIds, projectInfo.ProjectID)
  312. projectIdToAutoTaskIdMap[projectInfo.ProjectID] = projectInfo.AutoTaskID
  313. }
  314. //fmt.Println("projectIds:", projectIds)
  315. TaskIdToProjectId := make(map[int]int)
  316. var taskId []int
  317. db1 := GetReadDB(context.Background())
  318. for _, projectId := range projectIds {
  319. // 获取 autoTaskId 及其对应的限制时间、
  320. autoTaskId := projectIdToAutoTaskIdMap[projectId]
  321. dbStart := GetReadDB(context.Background())
  322. var ReviewInMv int32
  323. dbStart.Model(gorm_model.InfoAutoTask{}).Select("review_in_mv").Where("auto_task_id = ?", autoTaskId).First(&ReviewInMv)
  324. //fmt.Println("t:", autoTaskInfo.ReviewInMv)
  325. // 获取 projectId 对应的 taskId 及添加脚本自动审核时间
  326. var taskInfos []gorm_model.YoungeeTaskInfo
  327. db1.Model(gorm_model.YoungeeTaskInfo{}).Where("project_id = ?", projectId).Find(&taskInfos)
  328. for _, taskInfo := range taskInfos {
  329. //fmt.Println("TaskID:", taskInfo.TaskId)
  330. taskId = append(taskId, taskInfo.TaskId)
  331. TaskIdToProjectId[taskInfo.TaskId] = int(projectId)
  332. db2 := GetReadDB(context.Background())
  333. var scriptInfos gorm_model.YounggeeScriptInfo
  334. db2.Model(gorm_model.YounggeeScriptInfo{}).Where("task_id = ? AND is_submit = ? AND is_review = ? ", taskInfo.TaskId, 1, 0).Find(&scriptInfos)
  335. dd, _ := time.ParseDuration(conv.MustString(ReviewInMv, "") + "h")
  336. if scriptInfos.AutoAgreeAt.IsZero() && scriptInfos.IsSubmit == 1 {
  337. db3 := GetReadDB(context.Background())
  338. db3.Model(gorm_model.YounggeeScriptInfo{}).Where("task_id = ?", taskInfo.TaskId).Updates(&gorm_model.YounggeeScriptInfo{AutoAgreeAt: scriptInfos.SubmitAt.Add(dd)})
  339. fmt.Println("已添加脚本自动审核时间")
  340. }
  341. }
  342. }
  343. //fmt.Println("TaskIdToProjectId:", TaskIdToProjectId)
  344. //fmt.Println("taskId:", taskId)
  345. var scriptInfos []gorm_model.YounggeeScriptInfo
  346. db4 := GetReadDB(context.Background())
  347. err = db4.Model(gorm_model.YounggeeScriptInfo{}).Where("auto_agree_at <= ? AND task_id IN ?", time.Now(), taskId).Find(&scriptInfos).Error
  348. if err != nil {
  349. log.Println("DB GetAutoReviewTask error in script :", err)
  350. return err
  351. }
  352. //fmt.Println("scriptInfos:", scriptInfos)
  353. var scriptTaskIds []int
  354. for _, scriptInfo := range scriptInfos {
  355. scriptTaskIds = append(scriptTaskIds, scriptInfo.TaskID)
  356. scriptReviewNeedMod := gorm_model.YounggeeScriptInfo{}
  357. db5 := GetReadDB(context.Background())
  358. db5.Model(gorm_model.YounggeeScriptInfo{}).Where("script_id = ?", scriptInfo.ScriptID).Find(&scriptReviewNeedMod)
  359. if scriptInfo.AgreeAt.IsZero() && scriptInfo.IsSubmit == 1 {
  360. if scriptReviewNeedMod.IsReview != 1 {
  361. db7 := GetReadDB(context.Background())
  362. db7.Model(gorm_model.YounggeeScriptInfo{}).Where("script_id = ?", scriptInfo.ScriptID).Updates(&gorm_model.YounggeeScriptInfo{AgreeAt: time.Now(), IsReview: 1, IsOk: 1})
  363. fmt.Println("已更新脚本同意时间 及脚本审核状态")
  364. }
  365. }
  366. }
  367. fmt.Println("scriptTaskIds:", scriptTaskIds)
  368. for _, scriptTaskId := range scriptTaskIds {
  369. //fmt.Println("scriptTaskId", scriptTaskId)
  370. taskStatusNeedMod := gorm_model.YoungeeTaskInfo{}
  371. db6 := GetReadDB(context.Background())
  372. db6.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", scriptTaskId).Find(&taskStatusNeedMod)
  373. if (taskStatusNeedMod.ScriptStatus == 2 || taskStatusNeedMod.ScriptStatus == 4) && taskStatusNeedMod.TaskStage == 7 {
  374. db8 := GetReadDB(context.Background())
  375. db8.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", scriptTaskId).Updates(&gorm_model.YoungeeTaskInfo{ScriptStatus: 5, TaskStage: 9})
  376. fmt.Println("已更新任务阶段为待传初稿 及脚本上传状态为已通过")
  377. }
  378. }
  379. return nil
  380. } else {
  381. err := db.Model(gorm_model.ProjectInfo{}).Where("project_type = ? ", 1).Find(&projectInfos).Error
  382. if err != nil {
  383. return err
  384. }
  385. var projectIds []int64
  386. projectIdToAutoTaskIdMap := map[int64]int{}
  387. for _, projectInfo := range projectInfos {
  388. projectIds = append(projectIds, projectInfo.ProjectID)
  389. projectIdToAutoTaskIdMap[projectInfo.ProjectID] = projectInfo.AutoTaskID
  390. }
  391. //fmt.Println("projectIds:", projectIds)
  392. TaskIdToProjectId := make(map[int]int)
  393. var taskId []int
  394. db1 := GetReadDB(context.Background())
  395. for _, projectId := range projectIds {
  396. // 获取 autoTaskId 及其对应的限制时间、
  397. autoTaskId := projectIdToAutoTaskIdMap[projectId]
  398. dbStart := GetReadDB(context.Background())
  399. var ReviewUnlimited int32
  400. dbStart.Model(gorm_model.InfoAutoTask{}).Select("review_unlimited").Where("auto_task_id = ?", autoTaskId).First(&ReviewUnlimited)
  401. //fmt.Println("t:", autoTaskInfo.ReviewUnlimited)
  402. var taskInfos []gorm_model.YoungeeTaskInfo
  403. db1.Model(gorm_model.YoungeeTaskInfo{}).Where("project_id = ?", projectId).Find(&taskInfos)
  404. for _, taskInfo := range taskInfos {
  405. TaskIdToProjectId[taskInfo.TaskId] = int(projectId)
  406. taskId = append(taskId, taskInfo.TaskId)
  407. db2 := GetReadDB(context.Background())
  408. var scriptInfos gorm_model.YounggeeSketchInfo
  409. db2.Model(gorm_model.YounggeeSketchInfo{}).Where("task_id = ? AND is_submit = ? AND is_review = ? ", taskInfo.TaskId, 1, 0).Find(&scriptInfos)
  410. dd, _ := time.ParseDuration(conv.MustString(ReviewUnlimited, "") + "h")
  411. if scriptInfos.AutoAgreeAt.IsZero() && scriptInfos.IsSubmit == 1 {
  412. db3 := GetReadDB(context.Background())
  413. db3.Model(gorm_model.YounggeeSketchInfo{}).Where("task_id = ?", scriptInfos.TaskID).Updates(&gorm_model.YounggeeSketchInfo{AutoAgreeAt: scriptInfos.SubmitAt.Add(dd)})
  414. fmt.Println("已添加脚本自动审核时间")
  415. }
  416. }
  417. }
  418. //fmt.Println("TaskIdToProjectId:", TaskIdToProjectId)
  419. //fmt.Println("taskId:", taskId)
  420. var sketchInfos []gorm_model.YounggeeSketchInfo
  421. db3 := GetReadDB(context.Background())
  422. err = db3.Model(gorm_model.YounggeeSketchInfo{}).Where("auto_agree_at <= ? AND task_id IN ?", time.Now(), taskId).Find(&sketchInfos).Error
  423. if err != nil {
  424. log.Println("DB GetAutoReviewTask error in sketch:", err)
  425. return err
  426. }
  427. var sketchTaskIds []int
  428. for _, scriptInfo := range sketchInfos {
  429. sketchTaskIds = append(sketchTaskIds, scriptInfo.TaskID)
  430. sketchNeedMod := gorm_model.YounggeeSketchInfo{}
  431. db4 := GetReadDB(context.Background())
  432. db4.Model(gorm_model.YounggeeSketchInfo{}).Where("sketch_id = ?", scriptInfo.SketchID).Find(&sketchNeedMod)
  433. if scriptInfo.AgreeAt.IsZero() && scriptInfo.IsSubmit == 1 {
  434. if sketchNeedMod.IsReview != 1 {
  435. db6 := GetReadDB(context.Background())
  436. db6.Model(gorm_model.YounggeeSketchInfo{}).Where("sketch_id = ?", scriptInfo.SketchID).Updates(&gorm_model.YounggeeSketchInfo{AgreeAt: time.Now(), IsReview: 1, IsOk: 1})
  437. fmt.Println("已更新初稿审核同意时间")
  438. }
  439. }
  440. }
  441. for _, sketchTaskId := range sketchTaskIds {
  442. //fmt.Println("taskID", sketchTaskId)
  443. sketchNeedMod := gorm_model.YoungeeTaskInfo{}
  444. db5 := GetReadDB(context.Background())
  445. db5.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", sketchTaskId).Find(&sketchNeedMod)
  446. if (sketchNeedMod.SketchStatus == 2 || sketchNeedMod.SketchStatus == 4) && sketchNeedMod.TaskStage == 9 {
  447. db7 := GetReadDB(context.Background())
  448. db7.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", sketchTaskId).Updates(&gorm_model.YoungeeTaskInfo{SketchStatus: 5, TaskStage: 11})
  449. fmt.Println("已更新任务阶段为待传链接 及初稿上传状态为已通过")
  450. }
  451. }
  452. return nil
  453. }
  454. }
  455. func GetAutoPostReviewTask() error {
  456. db := GetReadDB(context.Background())
  457. var projectInfos []*gorm_model.ProjectInfo
  458. err := db.Model(gorm_model.ProjectInfo{}).Where("project_type = ? ", 1).Find(&projectInfos).Error
  459. if err != nil {
  460. return err
  461. }
  462. var projectIds []int64
  463. projectIdToAutoTaskIdMap := map[int64]int{}
  464. for _, projectInfo := range projectInfos {
  465. projectIds = append(projectIds, projectInfo.ProjectID)
  466. projectIdToAutoTaskIdMap[projectInfo.ProjectID] = projectInfo.AutoTaskID
  467. }
  468. //fmt.Println("projectIds:", projectIds)
  469. TaskIdToProjectId := make(map[int]int)
  470. var taskId []int
  471. db1 := GetReadDB(context.Background())
  472. for _, projectId := range projectIds {
  473. // 获取 autoTaskId 及其对应的限制时间、
  474. autoTaskId := projectIdToAutoTaskIdMap[projectId]
  475. dbStart := GetReadDB(context.Background())
  476. var Postreview int32
  477. dbStart.Model(gorm_model.InfoAutoTask{}).Select("postreview").Where("auto_task_id = ?", autoTaskId).First(&Postreview)
  478. //fmt.Println("t:", autoTaskInfo.Postreview)
  479. var taskInfos []gorm_model.YoungeeTaskInfo
  480. db1.Model(gorm_model.YoungeeTaskInfo{}).Where("project_id = ?", projectId).Find(&taskInfos)
  481. for _, taskInfo := range taskInfos {
  482. TaskIdToProjectId[taskInfo.TaskId] = int(projectId)
  483. taskId = append(taskId, taskInfo.TaskId)
  484. db2 := GetReadDB(context.Background())
  485. var linkInfos gorm_model.YounggeeLinkInfo
  486. db2.Model(gorm_model.YounggeeLinkInfo{}).Where("task_id = ? AND is_submit = ? AND is_review = ? ", taskInfo.TaskId, 1, 0).Find(&linkInfos)
  487. dd, _ := time.ParseDuration(conv.MustString(Postreview, "") + "h")
  488. if linkInfos.AutoAgreeAt.IsZero() && linkInfos.IsSubmit == 1 {
  489. db3 := GetReadDB(context.Background())
  490. db3.Model(gorm_model.YounggeeLinkInfo{}).Where("task_id = ?", linkInfos.TaskID).Updates(&gorm_model.YounggeeLinkInfo{AutoAgreeAt: linkInfos.SubmitAt.Add(dd)})
  491. fmt.Println("已添加链接自动审核时间")
  492. }
  493. }
  494. }
  495. var linkInfos []gorm_model.YounggeeLinkInfo
  496. db3 := GetReadDB(context.Background())
  497. err = db3.Model(gorm_model.YounggeeLinkInfo{}).Where("auto_agree_at <= ? AND task_id IN ?", time.Now(), taskId).Find(&linkInfos).Error
  498. if err != nil {
  499. log.Println("DB GetAutoPostReviewTask error in sketch:", err)
  500. return err
  501. }
  502. var linkTaskIds []int
  503. for _, linkInfo := range linkInfos {
  504. linkTaskIds = append(linkTaskIds, linkInfo.TaskID)
  505. linkNeedMod := gorm_model.YounggeeLinkInfo{}
  506. db4 := GetReadDB(context.Background())
  507. db4.Model(gorm_model.YounggeeLinkInfo{}).Where("link_id = ?", linkInfo.LinkID).Find(&linkNeedMod)
  508. if linkInfo.AgreeAt.IsZero() && linkInfo.IsSubmit == 1 {
  509. if linkNeedMod.IsReview != 1 {
  510. db6 := GetReadDB(context.Background())
  511. db6.Model(gorm_model.YounggeeLinkInfo{}).Where("link_id = ?", linkInfo.LinkID).Updates(&gorm_model.YounggeeLinkInfo{AgreeAt: time.Now(), IsReview: 1, IsOk: 1})
  512. fmt.Println("已更新链接审核同意时间")
  513. }
  514. }
  515. }
  516. for _, linkTaskId := range linkTaskIds {
  517. //fmt.Println("taskID", linkTaskId)
  518. linkNeedMod := gorm_model.YoungeeTaskInfo{}
  519. db5 := GetReadDB(context.Background())
  520. db5.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", linkTaskId).Find(&linkNeedMod)
  521. if (linkNeedMod.LinkStatus == 2 || linkNeedMod.LinkStatus == 4) && linkNeedMod.TaskStage == 11 {
  522. db7 := GetReadDB(context.Background())
  523. db7.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", linkTaskId).Updates(&gorm_model.YoungeeTaskInfo{LinkStatus: 5, TaskStage: 13})
  524. fmt.Println("已更新任务阶段为待传数据 及 链接上传状态为已通过")
  525. }
  526. }
  527. return nil
  528. }
  529. func GetAutoCaseCloseTask() error {
  530. db := GetReadDB(context.Background())
  531. var projectInfos []*gorm_model.ProjectInfo
  532. err := db.Model(gorm_model.ProjectInfo{}).Where("project_type = ? ", 1).Find(&projectInfos).Error
  533. if err != nil {
  534. return err
  535. }
  536. var projectIds []int64
  537. projectIdToAutoTaskIdMap := map[int64]int{}
  538. for _, projectInfo := range projectInfos {
  539. projectIds = append(projectIds, projectInfo.ProjectID)
  540. projectIdToAutoTaskIdMap[projectInfo.ProjectID] = projectInfo.AutoTaskID
  541. }
  542. //fmt.Println("projectIds:", projectIds)
  543. TaskIdToProjectId := make(map[int]int)
  544. var taskId []int
  545. db1 := GetReadDB(context.Background())
  546. for _, projectId := range projectIds {
  547. // 获取 autoTaskId 及其对应的限制时间、
  548. autoTaskId := projectIdToAutoTaskIdMap[projectId]
  549. dbStart := GetReadDB(context.Background())
  550. var CaseClose int32
  551. dbStart.Model(gorm_model.InfoAutoTask{}).Select("case_close").Where("auto_task_id = ?", autoTaskId).First(&CaseClose)
  552. //fmt.Println("t:", autoTaskInfo.CaseClose)
  553. var taskInfos []gorm_model.YoungeeTaskInfo
  554. db1.Model(gorm_model.YoungeeTaskInfo{}).Where("project_id = ?", projectId).Find(&taskInfos)
  555. for _, taskInfo := range taskInfos {
  556. TaskIdToProjectId[taskInfo.TaskId] = int(projectId)
  557. taskId = append(taskId, taskInfo.TaskId)
  558. db2 := GetReadDB(context.Background())
  559. var dataInfos gorm_model.YounggeeDataInfo
  560. db2.Model(gorm_model.YounggeeDataInfo{}).Where("task_id = ? AND is_submit = ? AND is_review = ? ", taskInfo.TaskId, 1, 0).Find(&dataInfos)
  561. dd, _ := time.ParseDuration(conv.MustString(CaseClose, "") + "h")
  562. if dataInfos.AutoAgreeAt.IsZero() && dataInfos.IsSubmit == 1 {
  563. db3 := GetReadDB(context.Background())
  564. db3.Model(gorm_model.YounggeeDataInfo{}).Where("task_id = ?", dataInfos.TaskID).Updates(&gorm_model.YounggeeDataInfo{AutoAgreeAt: dataInfos.SubmitAt.Add(dd)})
  565. fmt.Println("已添加链接自动审核时间")
  566. }
  567. }
  568. }
  569. var dataInfos []gorm_model.YounggeeDataInfo
  570. db3 := GetReadDB(context.Background())
  571. err = db3.Model(gorm_model.YounggeeDataInfo{}).Where("auto_agree_at <= ? AND task_id IN ?", time.Now(), taskId).Find(&dataInfos).Error
  572. if err != nil {
  573. log.Println("DB GetAutoCaseCloseTask error in sketch:", err)
  574. return err
  575. }
  576. var dataTaskIds []int
  577. for _, dataInfo := range dataInfos {
  578. dataTaskIds = append(dataTaskIds, dataInfo.TaskID)
  579. dataNeedMod := gorm_model.YounggeeDataInfo{}
  580. db4 := GetReadDB(context.Background())
  581. db4.Model(gorm_model.YounggeeDataInfo{}).Where("data_id = ?", dataInfo.DataID).Find(&dataNeedMod)
  582. if dataInfo.AgreeAt.IsZero() && dataInfo.IsSubmit == 1 {
  583. if dataNeedMod.IsReview != 1 {
  584. db6 := GetReadDB(context.Background())
  585. db6.Model(gorm_model.YounggeeDataInfo{}).Where("data_id = ?", dataInfo.DataID).Updates(&gorm_model.YounggeeDataInfo{AgreeAt: time.Now(), IsReview: 1, IsOk: 1})
  586. fmt.Println("已更新数据审核同意时间")
  587. }
  588. }
  589. }
  590. for _, dataTaskId := range dataTaskIds {
  591. dataNeedMod := gorm_model.YoungeeTaskInfo{}
  592. db5 := GetReadDB(context.Background())
  593. db5.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", dataTaskId).Find(&dataNeedMod)
  594. if (dataNeedMod.DataStatus == 2 || dataNeedMod.DataStatus == 4) && dataNeedMod.TaskStage == 13 {
  595. db7 := GetReadDB(context.Background())
  596. db7.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", dataTaskId).Updates(&gorm_model.YoungeeTaskInfo{DataStatus: 5, TaskStage: 15})
  597. fmt.Println("已更新任务阶段为已结案 及 数据上传状态为已通过")
  598. }
  599. }
  600. return nil
  601. }
  602. func GetAutoInvalidTask() error {
  603. db := GetReadDB(context.Background())
  604. var projectInfos []*gorm_model.ProjectInfo
  605. err := db.Model(gorm_model.ProjectInfo{}).Where("project_type = ? AND project_status = ? ", 1, 6).Find(&projectInfos).Error
  606. if err != nil {
  607. return err
  608. }
  609. var projectIds []int64
  610. projectIdToAutoTaskIdMap := map[int64]int{}
  611. for _, projectInfo := range projectInfos {
  612. projectIds = append(projectIds, projectInfo.ProjectID)
  613. projectIdToAutoTaskIdMap[projectInfo.ProjectID] = projectInfo.AutoTaskID
  614. }
  615. for _, projectId := range projectIds {
  616. // 获取 autoTaskId 及其对应的限制时间、
  617. autoTaskId := projectIdToAutoTaskIdMap[projectId]
  618. dbStart := GetReadDB(context.Background())
  619. var Invalid int32
  620. dbStart.Model(gorm_model.InfoAutoTask{}).Select("invalid").Where("auto_task_id = ?", autoTaskId).First(&Invalid)
  621. //fmt.Println("t:", autoTaskInfo.Invalid)
  622. db1 := GetReadDB(context.Background())
  623. project := gorm_model.ProjectInfo{}
  624. db1.Model(gorm_model.ProjectInfo{}).Where("project_id = ?", projectId).First(&project)
  625. if project.AutoFailAt.IsZero() {
  626. dd, _ := time.ParseDuration(conv.MustString(Invalid, "") + "h")
  627. db2 := GetReadDB(context.Background())
  628. db2.Model(gorm_model.ProjectInfo{}).Where("project_id = ?", projectId).Updates(&gorm_model.ProjectInfo{AutoFailAt: project.RecruitDdl.Add(dd)})
  629. fmt.Println("已添加失效自动处理时间")
  630. }
  631. projectNeedMod := gorm_model.ProjectInfo{}
  632. db2 := GetReadDB(context.Background())
  633. db2.Where("project_id = ?", projectId).First(&projectNeedMod)
  634. if !projectNeedMod.AutoFailAt.IsZero() {
  635. if projectNeedMod.AutoFailAt.Sub(time.Now()) <= 0 && projectNeedMod.ProjectStatus < 8 {
  636. db4 := GetReadDB(context.Background())
  637. err1 := db4.Model(gorm_model.ProjectInfo{}).Where("project_id = ?", projectId).Updates(&gorm_model.ProjectInfo{ProjectStatus: 8}).Error
  638. if err1 != nil {
  639. return err1
  640. }
  641. fmt.Println("已更新项目状态")
  642. }
  643. }
  644. }
  645. return nil
  646. }
  647. func GetAutoDraftDefaultInPicTask() error {
  648. db := GetReadDB(context.Background())
  649. var projectInfos []*gorm_model.ProjectInfo
  650. err := db.Model(gorm_model.ProjectInfo{}).Where("project_type = ? AND content_type = ? ", 1, 1).Find(&projectInfos).Error
  651. if err != nil {
  652. return err
  653. }
  654. // 项目类型为 实体商品寄拍、虚拟产品测评、线下探店打卡 均为正常的 收发货情况,以签收状况作为判断条件
  655. var projectIds []int64
  656. // 存储素材微原创的项目id,此情况单独处理,它不涉及到物流,也不涉及到脚本,初稿上一个状态直接就是支付。
  657. var specialProjectIds []int64
  658. projectIdToAutoTaskIdMap := map[int64]int{}
  659. // 项目id 对 违约定时任务id 的map
  660. projectIdToAutoDefaultIdMap := map[int64]int{}
  661. // taskId 对 稿费形式的 map
  662. taskIdToFeeFormMap := make(map[int]int)
  663. TaskIdToProjectId := make(map[int]int)
  664. var taskNeedModIds []int
  665. var specialTaskNeedModIds []int
  666. // 已提交初稿的任务记录id
  667. var submitTaskNeedModIds []int
  668. for _, projectInfo := range projectInfos {
  669. if projectInfo.ProjectForm == 4 {
  670. specialProjectIds = append(specialProjectIds, projectInfo.ProjectID)
  671. specialProjectInfo := gorm_model.ProjectInfo{}
  672. db1 := GetReadDB(context.Background())
  673. db1.Model(gorm_model.ProjectInfo{}).Where("project_id = ?", projectInfo.ProjectID).First(&specialProjectInfo)
  674. dbStart := GetReadDB(context.Background())
  675. var DraftDefaultInPic int32
  676. dbStart.Model(gorm_model.InfoAutoTask{}).Select("draft_default_in_pic").Where("auto_task_id = ?", specialProjectInfo.AutoTaskID).First(&DraftDefaultInPic)
  677. dd, _ := time.ParseDuration(conv.MustString(DraftDefaultInPic, "") + "h")
  678. if !projectInfo.PayAt.IsZero() && projectInfo.AutoSketchBreakAt.IsZero() {
  679. db1.Model(gorm_model.ProjectInfo{}).Where("project_id = ?", projectInfo.ProjectID).Updates(&gorm_model.ProjectInfo{AutoSketchBreakAt: projectInfo.PayAt.Add(dd)})
  680. fmt.Println("已添加素材微原创的初稿违约自动处理时间")
  681. }
  682. } else {
  683. projectIds = append(projectIds, projectInfo.ProjectID)
  684. }
  685. projectIdToAutoTaskIdMap[projectInfo.ProjectID] = projectInfo.AutoTaskID
  686. projectIdToAutoDefaultIdMap[projectInfo.ProjectID] = projectInfo.AutoDefaultID
  687. }
  688. //fmt.Println("projectIds:", projectIds)
  689. //fmt.Println("specialProjectIds:", specialProjectIds)
  690. for _, specialProjectId := range specialProjectIds {
  691. db2 := GetReadDB(context.Background())
  692. var taskInfos []gorm_model.YoungeeTaskInfo
  693. db2.Model(gorm_model.YoungeeTaskInfo{}).Where("project_id = ? AND cur_default_type = ?", specialProjectId, 0).Find(&taskInfos)
  694. for _, taskInfo := range taskInfos {
  695. TaskIdToProjectId[taskInfo.TaskId] = int(specialProjectId)
  696. taskIdToFeeFormMap[taskInfo.TaskId] = taskInfo.FeeForm
  697. specialTaskNeedMod := gorm_model.YoungeeTaskInfo{}
  698. db3 := GetReadDB(context.Background())
  699. // 保存所有初稿上传状态为 1或 3 的任务记录的id
  700. db3.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", taskInfo.TaskId).First(&specialTaskNeedMod)
  701. if specialTaskNeedMod.SketchStatus == 1 && taskInfo.TaskStage == 10 {
  702. specialTaskNeedModIds = append(specialTaskNeedModIds, taskInfo.TaskId)
  703. }
  704. if specialTaskNeedMod.SketchStatus == 3 && taskInfo.TaskStage == 10 {
  705. submitTaskNeedModIds = append(submitTaskNeedModIds, taskInfo.TaskId)
  706. }
  707. }
  708. }
  709. //fmt.Println("specialTaskNeedModIds:", specialTaskNeedModIds)
  710. for _, specialTaskNeedModId := range specialTaskNeedModIds {
  711. projectNeedMod := gorm_model.ProjectInfo{}
  712. db1 := GetReadDB(context.Background())
  713. db1.Model(gorm_model.ProjectInfo{}).Where("project_id = ?", TaskIdToProjectId[specialTaskNeedModId]).First(&projectNeedMod)
  714. var sketchDefaultRate int
  715. if taskIdToFeeFormMap[specialTaskNeedModId] == 1 {
  716. db6 := GetReadDB(context.Background())
  717. db6.Model(gorm_model.InfoAutoDefaultHandle{}).Select("script_replace_time_out").Where("auto_default_id = ?", projectIdToAutoDefaultIdMap[int64(TaskIdToProjectId[specialTaskNeedModId])]).Find(&sketchDefaultRate)
  718. } else {
  719. db6 := GetReadDB(context.Background())
  720. db6.Model(gorm_model.InfoAutoDefaultHandle{}).Select("script_other_time_out").Where("auto_default_id = ?", projectIdToAutoDefaultIdMap[int64(TaskIdToProjectId[specialTaskNeedModId])]).Find(&sketchDefaultRate)
  721. }
  722. if projectNeedMod.AutoSketchBreakAt.Sub(time.Now()) <= 0 && !projectNeedMod.AutoSketchBreakAt.IsZero() {
  723. db2 := GetReadDB(context.Background())
  724. err1 := db2.Model(gorm_model.YoungeeContractInfo{}).Create(&gorm_model.YoungeeContractInfo{
  725. TaskID: specialTaskNeedModId, BreakType: 2, BreakAt: time.Now(), DefaultStatus: 1}).Error
  726. if err1 != nil {
  727. return err1
  728. }
  729. db3 := GetReadDB(context.Background())
  730. db3.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", specialTaskNeedModId).Updates(&gorm_model.YoungeeTaskInfo{CurDefaultType: 3, SketchBreakRate: sketchDefaultRate})
  731. fmt.Println("已创建素材微原创的任务初稿违约记录")
  732. }
  733. }
  734. for _, projectId := range projectIds {
  735. db1 := GetReadDB(context.Background())
  736. var taskInfos []gorm_model.YoungeeTaskInfo
  737. db1.Model(gorm_model.YoungeeTaskInfo{}).Where("project_id = ? AND cur_default_type = ? ", projectId, 0).Find(&taskInfos)
  738. for _, taskInfo := range taskInfos {
  739. TaskIdToProjectId[taskInfo.TaskId] = int(projectId)
  740. taskNeedMod := gorm_model.YoungeeTaskInfo{}
  741. db2 := GetReadDB(context.Background())
  742. // 保存所有满足物流状态为3 且 初稿上传状态为 1或 3 的任务记录的id
  743. db2.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", taskInfo.TaskId).First(&taskNeedMod)
  744. if taskNeedMod.LogisticsStatus == 3 && taskNeedMod.ScriptStatus == 1 {
  745. taskNeedModIds = append(taskNeedModIds, taskInfo.TaskId)
  746. }
  747. if taskNeedMod.LogisticsStatus == 3 && taskNeedMod.ScriptStatus == 3 {
  748. submitTaskNeedModIds = append(submitTaskNeedModIds, taskInfo.TaskId)
  749. }
  750. }
  751. }
  752. //fmt.Println("projectIdToAutoTaskIdMap:", projectIdToAutoTaskIdMap)
  753. //fmt.Println("TaskIdToProjectId:", TaskIdToProjectId)
  754. //fmt.Println("taskNeedModIds:", taskNeedModIds)
  755. for _, taskNeedModId := range taskNeedModIds {
  756. // 获取 autoTaskId 及其对应的限制时间、
  757. //fmt.Println("taskNeedModId:", taskNeedModId)
  758. autoTaskId := projectIdToAutoTaskIdMap[int64(TaskIdToProjectId[taskNeedModId])]
  759. dbStart := GetReadDB(context.Background())
  760. var DraftDefaultInPic int32
  761. dbStart.Model(gorm_model.InfoAutoTask{}).Select("draft_default_in_pic").Where("auto_task_id = ?", autoTaskId).First(&DraftDefaultInPic)
  762. //fmt.Println("t:", autoTaskInfo.DraftDefaultInPic)
  763. db3 := GetReadDB(context.Background())
  764. taskLogisticNeedMod := gorm_model.YoungeeTaskLogistics{}
  765. db3.Model(gorm_model.YoungeeTaskLogistics{}).Where("task_id = ?", taskNeedModId).First(&taskLogisticNeedMod)
  766. var sketchDefaultRate int
  767. if taskIdToFeeFormMap[taskNeedModId] == 1 {
  768. db6 := GetReadDB(context.Background())
  769. db6.Model(gorm_model.InfoAutoDefaultHandle{}).Select("script_replace_time_out").Where("auto_default_id = ?", projectIdToAutoDefaultIdMap[int64(TaskIdToProjectId[taskNeedModId])]).Find(&sketchDefaultRate)
  770. } else {
  771. db6 := GetReadDB(context.Background())
  772. db6.Model(gorm_model.InfoAutoDefaultHandle{}).Select("script_other_time_out").Where("auto_default_id = ?", projectIdToAutoDefaultIdMap[int64(TaskIdToProjectId[taskNeedModId])]).Find(&sketchDefaultRate)
  773. }
  774. if taskLogisticNeedMod.AutoSketchBreakAt.IsZero() {
  775. dd, _ := time.ParseDuration(conv.MustString(DraftDefaultInPic, "") + "h")
  776. db4 := GetReadDB(context.Background())
  777. logisticNeedMod := gorm_model.YoungeeTaskLogistics{}
  778. db4.Model(gorm_model.YoungeeTaskLogistics{}).Where("task_id = ?", taskNeedModId).First(&logisticNeedMod)
  779. if logisticNeedMod.ThingsType == 1 && !logisticNeedMod.SignedTime.IsZero() {
  780. db4.Where("task_id = ?", taskNeedModId).Updates(&gorm_model.YoungeeTaskLogistics{
  781. AutoSketchBreakAt: taskLogisticNeedMod.SignedTime.Add(dd),
  782. })
  783. fmt.Println("已添加实物的图片初稿违约自动处理时间")
  784. }
  785. if logisticNeedMod.ThingsType != 1 && !logisticNeedMod.AutoSignAt.IsZero() {
  786. db4.Where("task_id = ?", taskNeedModId).Updates(&gorm_model.YoungeeTaskLogistics{
  787. AutoSketchBreakAt: taskLogisticNeedMod.AutoSignAt.Add(dd),
  788. })
  789. fmt.Println("已添加虚拟产品及线下探店的图片初稿违约自动处理时间")
  790. }
  791. }
  792. db7 := GetReadDB(context.Background())
  793. taskLogisticNeedMod2 := gorm_model.YoungeeTaskLogistics{}
  794. db7.Model(gorm_model.YoungeeTaskLogistics{}).Where("task_id = ?", taskNeedModId).First(&taskLogisticNeedMod2)
  795. if !taskLogisticNeedMod2.AutoSketchBreakAt.IsZero() && taskLogisticNeedMod2.AutoSketchBreakAt.Sub(time.Now()) <= 0 {
  796. db5 := GetReadDB(context.Background())
  797. err1 := db5.Model(gorm_model.YoungeeContractInfo{}).Create(&gorm_model.YoungeeContractInfo{
  798. TaskID: taskNeedModId, BreakType: 2, BreakAt: time.Now(), DefaultStatus: 1}).Error
  799. if err1 != nil {
  800. return err1
  801. }
  802. db8 := GetReadDB(context.Background())
  803. db8.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", taskLogisticNeedMod2.TaskID).Updates(&gorm_model.YoungeeTaskInfo{CurDefaultType: 3, SketchBreakRate: sketchDefaultRate})
  804. fmt.Println("已创建图文类型的初稿违约记录")
  805. }
  806. }
  807. for _, submitTaskNeedModId := range submitTaskNeedModIds {
  808. db2 := GetReadDB(context.Background())
  809. var DraftDefaultInMv int32
  810. db2.Model(&gorm_model.InfoAutoTask{}).Select("draft_default_in_mv").Where("auto_task_id = ?", projectIdToAutoTaskIdMap[int64(TaskIdToProjectId[submitTaskNeedModId])]).First(&DraftDefaultInMv)
  811. dd, _ := time.ParseDuration(conv.MustString(DraftDefaultInMv, "") + "h")
  812. var sketchDefaultRate int
  813. if taskIdToFeeFormMap[submitTaskNeedModId] == 1 {
  814. db6 := GetReadDB(context.Background())
  815. db6.Model(gorm_model.InfoAutoDefaultHandle{}).Select("script_replace_time_out").Where("auto_default_id = ?", projectIdToAutoDefaultIdMap[int64(TaskIdToProjectId[submitTaskNeedModId])]).Find(&sketchDefaultRate)
  816. } else {
  817. db6 := GetReadDB(context.Background())
  818. db6.Model(gorm_model.InfoAutoDefaultHandle{}).Select("script_other_time_out").Where("auto_default_id = ?", projectIdToAutoDefaultIdMap[int64(TaskIdToProjectId[submitTaskNeedModId])]).Find(&sketchDefaultRate)
  819. }
  820. db1 := GetReadDB(context.Background())
  821. var taskSketchInfo gorm_model.YounggeeSketchInfo
  822. db1.Model(gorm_model.YounggeeSketchInfo{}).Where("task_id = ?", submitTaskNeedModId).Order("reject_at desc").First(&taskSketchInfo)
  823. if taskSketchInfo.AutoSketchBreakAt.IsZero() {
  824. err4 := db1.Where("task_id = ?", submitTaskNeedModId).Updates(&gorm_model.YounggeeSketchInfo{AutoSketchBreakAt: taskSketchInfo.RejectAt.Add(dd)}).Error
  825. if err4 != nil {
  826. return err4
  827. }
  828. fmt.Println("已添加图文形式的初稿违约自动处理时间")
  829. if taskSketchInfo.RejectAt.Add(dd).Sub(time.Now()) <= 0 {
  830. db4 := GetReadDB(context.Background())
  831. err1 := db4.Model(gorm_model.YoungeeContractInfo{}).Create(&gorm_model.YoungeeContractInfo{
  832. TaskID: submitTaskNeedModId, BreakType: 2, BreakAt: time.Now(), DefaultStatus: 1}).Error
  833. if err1 != nil {
  834. return err1
  835. }
  836. db3 := GetReadDB(context.Background())
  837. err2 := db3.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", submitTaskNeedModId).Updates(&gorm_model.YoungeeTaskInfo{CurDefaultType: 3, SketchBreakRate: sketchDefaultRate}).Error
  838. if err2 != nil {
  839. return err2
  840. }
  841. fmt.Println("创建时已违约则创建已提交初稿的图文类型的初稿违约记录")
  842. }
  843. } else {
  844. if taskSketchInfo.AutoSketchBreakAt.Sub(time.Now()) <= 0 {
  845. db4 := GetReadDB(context.Background())
  846. err1 := db4.Model(gorm_model.YoungeeContractInfo{}).Create(&gorm_model.YoungeeContractInfo{
  847. TaskID: submitTaskNeedModId, BreakType: 2, BreakAt: time.Now(), DefaultStatus: 1}).Error
  848. if err1 != nil {
  849. return err1
  850. }
  851. db3 := GetReadDB(context.Background())
  852. err2 := db3.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", submitTaskNeedModId).Updates(&gorm_model.YoungeeTaskInfo{CurDefaultType: 3, SketchBreakRate: sketchDefaultRate}).Error
  853. if err2 != nil {
  854. return err2
  855. }
  856. fmt.Println("创建已提交初稿的图文类型的初稿违约记录")
  857. }
  858. }
  859. }
  860. return nil
  861. }
  862. func GetAutoDraftDefaultInMvTask() error {
  863. db := GetReadDB(context.Background())
  864. var VideoProjectIds []int64
  865. err := db.Select("project_id").Model(gorm_model.ProjectInfo{}).Where("project_type = ? AND content_type = ? ", 1, 2).Find(&VideoProjectIds).Error
  866. if err != nil {
  867. return err
  868. }
  869. //fmt.Println("VideoProjectIds:", VideoProjectIds)
  870. // 任务id 对 项目id 的map
  871. taskIdToProjectIdMap := map[int]int64{}
  872. // 项目id 对 定时任务id 的map
  873. projectIdToAutoTaskIdMap := map[int64]int{}
  874. // 项目id 对 违约定时任务id 的map
  875. projectIdToAutoDefaultIdMap := map[int64]int{}
  876. // taskId 对 稿费形式的 map
  877. taskIdToFeeFormMap := make(map[int]int)
  878. var videoTaskIds []int
  879. for _, VideoProjectId := range VideoProjectIds {
  880. db2 := GetReadDB(context.Background())
  881. autoIds := gorm_model.ProjectInfo{}
  882. db2.Select([]string{"auto_task_id", "auto_default_id"}).Model(&gorm_model.ProjectInfo{}).Where("project_id = ?", VideoProjectId).First(&autoIds)
  883. projectIdToAutoTaskIdMap[VideoProjectId] = autoIds.AutoTaskID
  884. projectIdToAutoDefaultIdMap[VideoProjectId] = autoIds.AutoDefaultID
  885. var videoTaskInfos []*gorm_model.YoungeeTaskInfo
  886. db1 := GetReadDB(context.Background())
  887. db1.Model(&gorm_model.YoungeeTaskInfo{}).Where("project_id = ? AND cur_default_type = ? ", VideoProjectId, 0).Find(&videoTaskInfos)
  888. for _, videoTaskInfo := range videoTaskInfos {
  889. taskIdToProjectIdMap[videoTaskInfo.TaskId] = VideoProjectId
  890. taskIdToFeeFormMap[videoTaskInfo.TaskId] = videoTaskInfo.FeeForm
  891. videoTaskIds = append(videoTaskIds, videoTaskInfo.TaskId)
  892. }
  893. }
  894. //fmt.Println("taskIdToProjectIdMap:", taskIdToProjectIdMap)
  895. //fmt.Println("projectIdToAutoTaskIdMap:", projectIdToAutoTaskIdMap)
  896. //fmt.Println("videoTaskIds:", videoTaskIds)
  897. // 首次提交初稿的任务记录id
  898. var videoTaskNeedModIds []int
  899. // 已提交初稿的任务记录id
  900. var submitVideoTaskNeedModIds []int
  901. for _, videoTaskId := range videoTaskIds {
  902. var taskInfo gorm_model.YoungeeTaskInfo
  903. db3 := GetReadDB(context.Background())
  904. // 保存所有初稿上传状态为 1 且任务状态为10 的任务记录的id
  905. db3.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", videoTaskId).First(&taskInfo)
  906. if taskInfo.SketchStatus == 1 && taskInfo.TaskStage == 10 {
  907. videoTaskNeedModIds = append(videoTaskNeedModIds, videoTaskId)
  908. }
  909. // 保存所有初稿上传状态为 3 且任务状态为10 的任务记录的id
  910. if taskInfo.SketchStatus == 3 && taskInfo.TaskStage == 10 {
  911. submitVideoTaskNeedModIds = append(submitVideoTaskNeedModIds, videoTaskId)
  912. }
  913. }
  914. //fmt.Println("videoTaskNeedModIds:", videoTaskNeedModIds)
  915. //fmt.Println("submitVideoTaskNeedModIds:", submitVideoTaskNeedModIds)
  916. for _, videoTaskNeedModId := range videoTaskNeedModIds {
  917. db2 := GetReadDB(context.Background())
  918. var DraftDefaultInMv int32
  919. db2.Model(&gorm_model.InfoAutoTask{}).Select("draft_default_in_mv").Where("auto_task_id = ?", projectIdToAutoTaskIdMap[taskIdToProjectIdMap[videoTaskNeedModId]]).First(&DraftDefaultInMv)
  920. dd, _ := time.ParseDuration(conv.MustString(DraftDefaultInMv, "") + "h")
  921. var sketchDefaultRate int
  922. if taskIdToFeeFormMap[videoTaskNeedModId] == 1 {
  923. db6 := GetReadDB(context.Background())
  924. db6.Model(gorm_model.InfoAutoDefaultHandle{}).Select("script_replace_time_out").Where("auto_default_id = ?", projectIdToAutoDefaultIdMap[taskIdToProjectIdMap[videoTaskNeedModId]]).Find(&sketchDefaultRate)
  925. } else {
  926. db6 := GetReadDB(context.Background())
  927. db6.Model(gorm_model.InfoAutoDefaultHandle{}).Select("script_other_time_out").Where("auto_default_id = ?", projectIdToAutoDefaultIdMap[taskIdToProjectIdMap[videoTaskNeedModId]]).Find(&sketchDefaultRate)
  928. }
  929. db1 := GetReadDB(context.Background())
  930. var taskScriptInfo gorm_model.YounggeeScriptInfo
  931. db1.Model(gorm_model.YounggeeScriptInfo{}).Where("task_id = ? AND is_ok = ?", videoTaskNeedModId, 1).Find(&taskScriptInfo)
  932. if taskScriptInfo.AutoSketchBreakAt.IsZero() {
  933. db1.Where("task_id = ?", videoTaskNeedModId).Updates(&gorm_model.YounggeeScriptInfo{AutoSketchBreakAt: taskScriptInfo.AutoAgreeAt.Add(dd)})
  934. fmt.Println("已添加视频形式的初稿违约自动处理时间")
  935. if taskScriptInfo.AutoAgreeAt.Add(dd).Sub(time.Now()) <= 0 {
  936. db4 := GetReadDB(context.Background())
  937. err1 := db4.Model(gorm_model.YoungeeContractInfo{}).Create(&gorm_model.YoungeeContractInfo{
  938. TaskID: videoTaskNeedModId, BreakType: 2, BreakAt: time.Now(), DefaultStatus: 1}).Error
  939. if err1 != nil {
  940. return err1
  941. }
  942. db3 := GetReadDB(context.Background())
  943. err2 := db3.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", videoTaskNeedModId).Updates(&gorm_model.YoungeeTaskInfo{CurDefaultType: 3, SketchBreakRate: sketchDefaultRate}).Error
  944. if err2 != nil {
  945. return err2
  946. }
  947. fmt.Println("创建时已违约则创建视频类型的初稿违约记录")
  948. }
  949. } else {
  950. if taskScriptInfo.AutoSketchBreakAt.Sub(time.Now()) <= 0 {
  951. db4 := GetReadDB(context.Background())
  952. err1 := db4.Model(gorm_model.YoungeeContractInfo{}).Create(&gorm_model.YoungeeContractInfo{
  953. TaskID: videoTaskNeedModId, BreakType: 2, BreakAt: time.Now(), DefaultStatus: 1}).Error
  954. if err1 != nil {
  955. return err1
  956. }
  957. db3 := GetReadDB(context.Background())
  958. err2 := db3.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", videoTaskNeedModId).Updates(&gorm_model.YoungeeTaskInfo{CurDefaultType: 3, SketchBreakRate: sketchDefaultRate}).Error
  959. if err2 != nil {
  960. return err2
  961. }
  962. fmt.Println("已创建视频类型的初稿违约记录")
  963. }
  964. }
  965. }
  966. for _, submitVideoTaskNeedModId := range submitVideoTaskNeedModIds {
  967. db2 := GetReadDB(context.Background())
  968. var DraftDefaultInMv int32
  969. db2.Model(&gorm_model.InfoAutoTask{}).Select("draft_default_in_mv").Where("auto_task_id = ?", projectIdToAutoTaskIdMap[taskIdToProjectIdMap[submitVideoTaskNeedModId]]).First(&DraftDefaultInMv)
  970. dd, _ := time.ParseDuration(conv.MustString(DraftDefaultInMv, "") + "h")
  971. var sketchDefaultRate int
  972. if taskIdToFeeFormMap[submitVideoTaskNeedModId] == 1 {
  973. db6 := GetReadDB(context.Background())
  974. db6.Model(gorm_model.InfoAutoDefaultHandle{}).Select("script_replace_time_out").Where("auto_default_id = ?", projectIdToAutoDefaultIdMap[taskIdToProjectIdMap[submitVideoTaskNeedModId]]).Find(&sketchDefaultRate)
  975. } else {
  976. db6 := GetReadDB(context.Background())
  977. db6.Model(gorm_model.InfoAutoDefaultHandle{}).Select("script_other_time_out").Where("auto_default_id = ?", projectIdToAutoDefaultIdMap[taskIdToProjectIdMap[submitVideoTaskNeedModId]]).Find(&sketchDefaultRate)
  978. }
  979. db1 := GetReadDB(context.Background())
  980. var taskSketchInfo gorm_model.YounggeeSketchInfo
  981. db1.Model(gorm_model.YounggeeSketchInfo{}).Where("task_id = ?", submitVideoTaskNeedModId).Order("reject_at desc").First(&taskSketchInfo)
  982. if taskSketchInfo.AutoSketchBreakAt.IsZero() {
  983. err4 := db1.Where("task_id = ?", submitVideoTaskNeedModId).Updates(&gorm_model.YounggeeSketchInfo{AutoSketchBreakAt: taskSketchInfo.RejectAt.Add(dd)}).Error
  984. if err4 != nil {
  985. return err4
  986. }
  987. fmt.Println("已添加视频形式的初稿违约自动处理时间")
  988. if taskSketchInfo.RejectAt.Add(dd).Sub(time.Now()) <= 0 {
  989. db4 := GetReadDB(context.Background())
  990. err1 := db4.Model(gorm_model.YoungeeContractInfo{}).Create(&gorm_model.YoungeeContractInfo{
  991. TaskID: submitVideoTaskNeedModId, BreakType: 2, BreakAt: time.Now(), DefaultStatus: 1}).Error
  992. if err1 != nil {
  993. return err1
  994. }
  995. db3 := GetReadDB(context.Background())
  996. err2 := db3.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", submitVideoTaskNeedModId).Updates(&gorm_model.YoungeeTaskInfo{CurDefaultType: 3, SketchBreakRate: sketchDefaultRate}).Error
  997. if err2 != nil {
  998. return err2
  999. }
  1000. fmt.Println("创建时已违约则创建已提交初稿的视频类型的初稿违约记录")
  1001. }
  1002. } else {
  1003. if taskSketchInfo.AutoSketchBreakAt.Sub(time.Now()) <= 0 {
  1004. db4 := GetReadDB(context.Background())
  1005. err1 := db4.Model(gorm_model.YoungeeContractInfo{}).Create(&gorm_model.YoungeeContractInfo{
  1006. TaskID: submitVideoTaskNeedModId, BreakType: 2, BreakAt: time.Now(), DefaultStatus: 1}).Error
  1007. if err1 != nil {
  1008. return err1
  1009. }
  1010. db3 := GetReadDB(context.Background())
  1011. err2 := db3.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", submitVideoTaskNeedModId).Updates(&gorm_model.YoungeeTaskInfo{CurDefaultType: 3, SketchBreakRate: sketchDefaultRate}).Error
  1012. if err2 != nil {
  1013. return err2
  1014. }
  1015. fmt.Println("创建已提交初稿的视频类型的初稿违约记录")
  1016. }
  1017. }
  1018. }
  1019. return nil
  1020. }
  1021. func GetAutoScriptDefaultTask() error {
  1022. db := GetReadDB(context.Background())
  1023. var VideoProjectIds []int64
  1024. var specialProjectIds []int
  1025. err := db.Select("project_id").Model(gorm_model.ProjectInfo{}).Where("project_type = ? AND content_type = ? AND project_form != 4", 1, 2).Find(&VideoProjectIds).Error
  1026. if err != nil {
  1027. return err
  1028. }
  1029. db.Select("project_id").Model(gorm_model.ProjectInfo{}).Where("project_type = ? AND content_type = ? AND project_form = 4", 1, 2).Find(&specialProjectIds)
  1030. //fmt.Println("VideoProjectIds:", VideoProjectIds)
  1031. //fmt.Println("specialProjectIds:", specialProjectIds)
  1032. // 任务id 对 项目id 的map
  1033. taskIdToProjectIdMap := map[int]int64{}
  1034. // 项目id 对 定时任务id 的map
  1035. projectIdToAutoTaskIdMap := map[int64]int{}
  1036. // 项目id 对 违约定时任务id 的map
  1037. projectIdToAutoDefaultIdMap := map[int64]int{}
  1038. // taskId 对 稿费形式的 map
  1039. taskIdToFeeFormMap := make(map[int]int)
  1040. // 素材微原创的任务id
  1041. var specialVideoTaskIds []int
  1042. // 需要判断是否违约的素材微原创的任务id
  1043. var specialTaskNeedModIds []int
  1044. // 首次提交脚本的任务记录id
  1045. var videoTaskNeedModIds []int
  1046. // 已提交脚本的任务记录id
  1047. var submitVideoTaskNeedModIds []int
  1048. for _, specialProjectId := range specialProjectIds {
  1049. db2 := GetReadDB(context.Background())
  1050. var projectInfo gorm_model.ProjectInfo
  1051. db2.Model(&gorm_model.ProjectInfo{}).Where("project_id = ?", specialProjectId).First(&projectInfo)
  1052. projectIdToAutoTaskIdMap[int64(specialProjectId)] = projectInfo.AutoTaskID
  1053. projectIdToAutoDefaultIdMap[int64(specialProjectId)] = projectInfo.AutoDefaultID
  1054. var ScriptDefault int32
  1055. dbStart := GetReadDB(context.Background())
  1056. dbStart.Model(gorm_model.InfoAutoTask{}).Select("script_default").Where("auto_task_id = ?", projectInfo.AutoTaskID).First(&ScriptDefault)
  1057. dd, _ := time.ParseDuration(conv.MustString(ScriptDefault, "") + "h")
  1058. if !projectInfo.PayAt.IsZero() && projectInfo.AutoScriptBreakAt.IsZero() {
  1059. db1 := GetReadDB(context.Background())
  1060. db1.Model(gorm_model.ProjectInfo{}).Where("project_id = ?", projectInfo.ProjectID).Updates(&gorm_model.ProjectInfo{AutoScriptBreakAt: projectInfo.PayAt.Add(dd)})
  1061. fmt.Println("已添加素材微原创的脚本违约自动处理时间")
  1062. }
  1063. var videoTaskInfos []*gorm_model.YoungeeTaskInfo
  1064. db1 := GetReadDB(context.Background())
  1065. db1.Model(&gorm_model.YoungeeTaskInfo{}).Where("project_id = ? AND cur_default_type = ? ", specialProjectId, 0).Find(&videoTaskInfos)
  1066. for _, videoTaskInfo := range videoTaskInfos {
  1067. taskIdToProjectIdMap[videoTaskInfo.TaskId] = int64(specialProjectId)
  1068. specialVideoTaskIds = append(specialVideoTaskIds, videoTaskInfo.TaskId)
  1069. specialTaskNeedMod := gorm_model.YoungeeTaskInfo{}
  1070. db3 := GetReadDB(context.Background())
  1071. // 保存所有脚本上传状态为 1 且任务状态为8 的任务记录的id
  1072. db3.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", videoTaskInfo.TaskId).First(&specialTaskNeedMod)
  1073. if specialTaskNeedMod.ScriptStatus == 1 && specialTaskNeedMod.TaskStage == 8 {
  1074. specialTaskNeedModIds = append(specialTaskNeedModIds, videoTaskInfo.TaskId)
  1075. }
  1076. // 保存所有脚本上传状态为 3 且任务状态为8 的任务记录的id
  1077. if specialTaskNeedMod.ScriptStatus == 3 && specialTaskNeedMod.TaskStage == 8 {
  1078. submitVideoTaskNeedModIds = append(submitVideoTaskNeedModIds, videoTaskInfo.TaskId)
  1079. }
  1080. taskIdToFeeFormMap[videoTaskInfo.TaskId] = videoTaskInfo.FeeForm
  1081. }
  1082. }
  1083. //fmt.Println("submitVideoTaskNeedModIds:", submitVideoTaskNeedModIds)
  1084. //fmt.Println("specialTaskNeedModIds:", specialTaskNeedModIds)
  1085. for _, specialTaskNeedModId := range specialTaskNeedModIds {
  1086. projectNeedMod := gorm_model.ProjectInfo{}
  1087. db1 := GetReadDB(context.Background())
  1088. db1.Model(gorm_model.ProjectInfo{}).Where("project_id = ?", taskIdToProjectIdMap[specialTaskNeedModId]).First(&projectNeedMod)
  1089. if projectNeedMod.AutoScriptBreakAt.Sub(time.Now()) <= 0 && !projectNeedMod.AutoScriptBreakAt.IsZero() {
  1090. var scriptDefaultRate int
  1091. if taskIdToFeeFormMap[specialTaskNeedModId] == 1 {
  1092. db6 := GetReadDB(context.Background())
  1093. db6.Model(gorm_model.InfoAutoDefaultHandle{}).Select("script_replace_time_out").Where("auto_default_id = ?", projectIdToAutoDefaultIdMap[taskIdToProjectIdMap[specialTaskNeedModId]]).Find(&scriptDefaultRate)
  1094. } else {
  1095. db6 := GetReadDB(context.Background())
  1096. db6.Model(gorm_model.InfoAutoDefaultHandle{}).Select("script_other_time_out").Where("auto_default_id = ?", projectIdToAutoDefaultIdMap[taskIdToProjectIdMap[specialTaskNeedModId]]).Find(&scriptDefaultRate)
  1097. }
  1098. db2 := GetReadDB(context.Background())
  1099. err1 := db2.Model(gorm_model.YoungeeContractInfo{}).Create(&gorm_model.YoungeeContractInfo{
  1100. TaskID: specialTaskNeedModId, BreakType: 1, BreakAt: time.Now(), DefaultStatus: 1}).Error
  1101. if err1 != nil {
  1102. return err1
  1103. }
  1104. db3 := GetReadDB(context.Background())
  1105. db3.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", specialTaskNeedModId).Updates(&gorm_model.YoungeeTaskInfo{CurDefaultType: 1, ScriptBreakRate: scriptDefaultRate})
  1106. fmt.Println("已创建素材微原创的任务脚本违约记录")
  1107. }
  1108. }
  1109. var videoTaskIds []int
  1110. for _, VideoProjectId := range VideoProjectIds {
  1111. db2 := GetReadDB(context.Background())
  1112. var autoTaskId int
  1113. db2.Select("auto_task_id").Model(&gorm_model.ProjectInfo{}).Where("project_id = ?", VideoProjectId).First(&autoTaskId)
  1114. projectIdToAutoTaskIdMap[VideoProjectId] = autoTaskId
  1115. var videoTaskInfos []*gorm_model.YoungeeTaskInfo
  1116. db1 := GetReadDB(context.Background())
  1117. db1.Model(&gorm_model.YoungeeTaskInfo{}).Where("project_id = ? AND cur_default_type = ? ", VideoProjectId, 0).Find(&videoTaskInfos)
  1118. for _, videoTaskInfo := range videoTaskInfos {
  1119. taskIdToProjectIdMap[videoTaskInfo.TaskId] = VideoProjectId
  1120. videoTaskIds = append(videoTaskIds, videoTaskInfo.TaskId)
  1121. }
  1122. }
  1123. //fmt.Println("taskIdToProjectIdMap:", taskIdToProjectIdMap)
  1124. //fmt.Println("projectIdToAutoTaskIdMap:", projectIdToAutoTaskIdMap)
  1125. //fmt.Println("videoTaskIds:", videoTaskIds)
  1126. for _, videoTaskId := range videoTaskIds {
  1127. var taskInfo gorm_model.YoungeeTaskInfo
  1128. db3 := GetReadDB(context.Background())
  1129. // 保存所有脚本上传状态为 1 且任务状态为8 的任务记录的id
  1130. db3.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", videoTaskId).First(&taskInfo)
  1131. if taskInfo.ScriptStatus == 1 && taskInfo.TaskStage == 8 {
  1132. videoTaskNeedModIds = append(videoTaskNeedModIds, videoTaskId)
  1133. }
  1134. // 保存所有脚本上传状态为 3 且任务状态为8 的任务记录的id
  1135. if taskInfo.ScriptStatus == 3 && taskInfo.TaskStage == 8 {
  1136. submitVideoTaskNeedModIds = append(submitVideoTaskNeedModIds, videoTaskId)
  1137. }
  1138. }
  1139. //fmt.Println("videoTaskNeedModIds:", videoTaskNeedModIds)
  1140. //fmt.Println("submitVideoTaskNeedModIds:", submitVideoTaskNeedModIds)
  1141. for _, videoTaskNeedModId := range videoTaskNeedModIds {
  1142. db2 := GetReadDB(context.Background())
  1143. var ScriptDefault int32
  1144. db2.Model(&gorm_model.InfoAutoTask{}).Select("script_default").Where("auto_task_id = ?", projectIdToAutoTaskIdMap[taskIdToProjectIdMap[videoTaskNeedModId]]).First(&ScriptDefault)
  1145. dd, _ := time.ParseDuration(conv.MustString(ScriptDefault, "") + "h")
  1146. db1 := GetReadDB(context.Background())
  1147. var taskLogisticInfo gorm_model.YoungeeTaskLogistics
  1148. db1.Model(gorm_model.YoungeeTaskLogistics{}).Where("task_id = ?", videoTaskNeedModId).Find(&taskLogisticInfo)
  1149. var scriptDefaultRate int
  1150. if taskIdToFeeFormMap[videoTaskNeedModId] == 1 {
  1151. db6 := GetReadDB(context.Background())
  1152. db6.Model(gorm_model.InfoAutoDefaultHandle{}).Select("script_replace_time_out").Where("auto_default_id = ?", projectIdToAutoDefaultIdMap[taskIdToProjectIdMap[videoTaskNeedModId]]).Find(&scriptDefaultRate)
  1153. } else {
  1154. db6 := GetReadDB(context.Background())
  1155. db6.Model(gorm_model.InfoAutoDefaultHandle{}).Select("script_other_time_out").Where("auto_default_id = ?", projectIdToAutoDefaultIdMap[taskIdToProjectIdMap[videoTaskNeedModId]]).Find(&scriptDefaultRate)
  1156. }
  1157. if taskLogisticInfo.AutoScriptBreakAt.IsZero() {
  1158. db1.Where("task_id = ?", videoTaskNeedModId).Updates(&gorm_model.YoungeeTaskLogistics{AutoScriptBreakAt: taskLogisticInfo.AutoSignAt.Add(dd)})
  1159. fmt.Println("已添加视频形式的脚本违约自动处理时间")
  1160. if taskLogisticInfo.AutoSignAt.Add(dd).Sub(time.Now()) <= 0 {
  1161. db4 := GetReadDB(context.Background())
  1162. err1 := db4.Model(gorm_model.YoungeeContractInfo{}).Create(&gorm_model.YoungeeContractInfo{
  1163. TaskID: videoTaskNeedModId, BreakType: 1, BreakAt: time.Now(), DefaultStatus: 1}).Error
  1164. if err1 != nil {
  1165. return err1
  1166. }
  1167. db3 := GetReadDB(context.Background())
  1168. err2 := db3.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", videoTaskNeedModId).Updates(&gorm_model.YoungeeTaskInfo{CurDefaultType: 1, ScriptBreakRate: scriptDefaultRate}).Error
  1169. if err2 != nil {
  1170. return err2
  1171. }
  1172. fmt.Println("创建时已违约则创建视频类型的脚本违约记录")
  1173. }
  1174. } else {
  1175. if taskLogisticInfo.AutoScriptBreakAt.Sub(time.Now()) <= 0 {
  1176. db4 := GetReadDB(context.Background())
  1177. err1 := db4.Model(gorm_model.YoungeeContractInfo{}).Create(&gorm_model.YoungeeContractInfo{
  1178. TaskID: videoTaskNeedModId, BreakType: 1, BreakAt: time.Now(), DefaultStatus: 1}).Error
  1179. if err1 != nil {
  1180. return err1
  1181. }
  1182. db3 := GetReadDB(context.Background())
  1183. err2 := db3.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", videoTaskNeedModId).Updates(&gorm_model.YoungeeTaskInfo{CurDefaultType: 1, ScriptBreakRate: scriptDefaultRate}).Error
  1184. if err2 != nil {
  1185. return err2
  1186. }
  1187. fmt.Println("已创建视频类型的脚本违约记录")
  1188. }
  1189. }
  1190. }
  1191. // 根据最近一次拒绝时间判断当前是否违约
  1192. for _, submitVideoTaskNeedModId := range submitVideoTaskNeedModIds {
  1193. db2 := GetReadDB(context.Background())
  1194. var ScriptDefault int32
  1195. db2.Model(&gorm_model.InfoAutoTask{}).Select("script_default").Where("auto_task_id = ?", projectIdToAutoTaskIdMap[taskIdToProjectIdMap[submitVideoTaskNeedModId]]).First(&ScriptDefault)
  1196. dd, _ := time.ParseDuration(conv.MustString(ScriptDefault, "") + "h")
  1197. db1 := GetReadDB(context.Background())
  1198. var taskScriptInfo gorm_model.YounggeeScriptInfo
  1199. db1.Model(gorm_model.YounggeeScriptInfo{}).Where("task_id = ?", submitVideoTaskNeedModId).Order("reject_at desc").First(&taskScriptInfo)
  1200. var scriptDefaultRate int
  1201. if taskIdToFeeFormMap[submitVideoTaskNeedModId] == 1 {
  1202. db6 := GetReadDB(context.Background())
  1203. db6.Model(gorm_model.InfoAutoDefaultHandle{}).Select("script_replace_time_out").Where("auto_default_id = ?", projectIdToAutoDefaultIdMap[taskIdToProjectIdMap[submitVideoTaskNeedModId]]).Find(&scriptDefaultRate)
  1204. } else {
  1205. db6 := GetReadDB(context.Background())
  1206. db6.Model(gorm_model.InfoAutoDefaultHandle{}).Select("script_other_time_out").Where("auto_default_id = ?", projectIdToAutoDefaultIdMap[taskIdToProjectIdMap[submitVideoTaskNeedModId]]).Find(&scriptDefaultRate)
  1207. }
  1208. if taskScriptInfo.AutoScriptBreakAt.IsZero() {
  1209. err4 := db1.Where("task_id = ?", submitVideoTaskNeedModId).Updates(&gorm_model.YounggeeScriptInfo{AutoScriptBreakAt: taskScriptInfo.RejectAt.Add(dd)}).Error
  1210. if err4 != nil {
  1211. return err4
  1212. }
  1213. fmt.Println("已添加视频形式的脚本违约自动处理时间")
  1214. if taskScriptInfo.RejectAt.Add(dd).Sub(time.Now()) <= 0 {
  1215. db4 := GetReadDB(context.Background())
  1216. err1 := db4.Model(gorm_model.YoungeeContractInfo{}).Create(&gorm_model.YoungeeContractInfo{
  1217. TaskID: submitVideoTaskNeedModId, BreakType: 1, BreakAt: time.Now(), DefaultStatus: 1}).Error
  1218. if err1 != nil {
  1219. return err1
  1220. }
  1221. db3 := GetReadDB(context.Background())
  1222. err2 := db3.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", submitVideoTaskNeedModId).Updates(&gorm_model.YoungeeTaskInfo{
  1223. CurDefaultType: 1, ScriptBreakRate: scriptDefaultRate}).Error
  1224. if err2 != nil {
  1225. return err2
  1226. }
  1227. fmt.Println("创建时已违约则创建已提交脚本的视频类型的脚本违约记录")
  1228. }
  1229. } else {
  1230. if taskScriptInfo.AutoScriptBreakAt.Sub(time.Now()) <= 0 {
  1231. db4 := GetReadDB(context.Background())
  1232. err1 := db4.Model(gorm_model.YoungeeContractInfo{}).Create(&gorm_model.YoungeeContractInfo{
  1233. TaskID: submitVideoTaskNeedModId, BreakType: 1, BreakAt: time.Now(), DefaultStatus: 1}).Error
  1234. if err1 != nil {
  1235. return err1
  1236. }
  1237. db3 := GetReadDB(context.Background())
  1238. err2 := db3.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", submitVideoTaskNeedModId).Updates(&gorm_model.YoungeeTaskInfo{
  1239. CurDefaultType: 1, ScriptBreakRate: scriptDefaultRate}).Error
  1240. if err2 != nil {
  1241. return err2
  1242. }
  1243. fmt.Println("创建已提交脚本的视频类型的脚本违约记录")
  1244. }
  1245. }
  1246. }
  1247. return nil
  1248. }
  1249. func GetAutoLinkBreachTask() error {
  1250. db := GetReadDB(context.Background())
  1251. var projectIds []int64
  1252. err := db.Select("project_id").Model(gorm_model.ProjectInfo{}).Where("project_type = ?", 1).Find(&projectIds).Error
  1253. if err != nil {
  1254. return err
  1255. }
  1256. //fmt.Println("projectIds:", projectIds)
  1257. // 任务id 对 项目id 的map
  1258. taskIdToProjectIdMap := map[int]int64{}
  1259. // 项目id 对 定时任务id 的map
  1260. projectIdToAutoTaskIdMap := map[int64]int{}
  1261. // 项目id 对 违约定时任务id 的map
  1262. projectIdToAutoDefaultIdMap := map[int64]int{}
  1263. var taskIds []int
  1264. // taskId 对 稿费形式的 map
  1265. taskIdToFeeFormMap := make(map[int]int)
  1266. for _, projectId := range projectIds {
  1267. db2 := GetReadDB(context.Background())
  1268. autoIds := gorm_model.ProjectInfo{}
  1269. db2.Select([]string{"auto_task_id", "auto_default_id"}).Model(&gorm_model.ProjectInfo{}).Where("project_id = ?", projectId).First(&autoIds)
  1270. projectIdToAutoTaskIdMap[projectId] = autoIds.AutoTaskID
  1271. projectIdToAutoDefaultIdMap[projectId] = autoIds.AutoDefaultID
  1272. var taskInfos []*gorm_model.YoungeeTaskInfo
  1273. db1 := GetReadDB(context.Background())
  1274. db1.Model(&gorm_model.YoungeeTaskInfo{}).Where("project_id = ? AND cur_default_type = ? ", projectId, 0).Find(&taskInfos)
  1275. for _, taskInfo := range taskInfos {
  1276. taskIdToProjectIdMap[taskInfo.TaskId] = projectId
  1277. taskIds = append(taskIds, taskInfo.TaskId)
  1278. taskIdToFeeFormMap[taskInfo.TaskId] = taskInfo.FeeForm
  1279. }
  1280. }
  1281. //fmt.Println("taskIdToProjectIdMap:", taskIdToProjectIdMap)
  1282. //fmt.Println("taskIds:", taskIds)
  1283. // 首次提交链接的任务记录id
  1284. var taskNeedModIds []int
  1285. // 已提交链接的任务记录id
  1286. var submitTaskNeedModIds []int
  1287. for _, taskId := range taskIds {
  1288. var taskInfo gorm_model.YoungeeTaskInfo
  1289. db3 := GetReadDB(context.Background())
  1290. // 保存所有链接上传状态为 1 且任务状态为12 的任务记录的id
  1291. db3.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", taskId).First(&taskInfo)
  1292. if taskInfo.LinkStatus == 1 && taskInfo.TaskStage == 12 {
  1293. taskNeedModIds = append(taskNeedModIds, taskId)
  1294. }
  1295. // 保存所有链接上传状态为 3 且任务状态为12 的任务记录的id
  1296. if taskInfo.LinkStatus == 3 && taskInfo.TaskStage == 12 {
  1297. submitTaskNeedModIds = append(submitTaskNeedModIds, taskId)
  1298. }
  1299. }
  1300. //fmt.Println("taskNeedModIds:", taskNeedModIds)
  1301. //fmt.Println("submitTaskNeedModIds:", submitTaskNeedModIds)
  1302. for _, taskNeedModId := range taskNeedModIds {
  1303. db2 := GetReadDB(context.Background())
  1304. var linkBreach int32
  1305. db2.Model(&gorm_model.InfoAutoTask{}).Select("link_breach").Where("auto_task_id = ?", projectIdToAutoTaskIdMap[taskIdToProjectIdMap[taskNeedModId]]).First(&linkBreach)
  1306. dd, _ := time.ParseDuration(conv.MustString(linkBreach, "") + "h")
  1307. var linkDefaultRate int
  1308. if taskIdToFeeFormMap[taskNeedModId] == 1 {
  1309. db6 := GetReadDB(context.Background())
  1310. db6.Model(gorm_model.InfoAutoDefaultHandle{}).Select("link_replace_time_out").Where("auto_default_id = ?", projectIdToAutoDefaultIdMap[taskIdToProjectIdMap[taskNeedModId]]).Find(&linkDefaultRate)
  1311. } else {
  1312. db6 := GetReadDB(context.Background())
  1313. db6.Model(gorm_model.InfoAutoDefaultHandle{}).Select("link_other_time_out").Where("auto_default_id = ?", projectIdToAutoDefaultIdMap[taskIdToProjectIdMap[taskNeedModId]]).Find(&linkDefaultRate)
  1314. }
  1315. db1 := GetReadDB(context.Background())
  1316. var taskSketchInfo gorm_model.YounggeeSketchInfo
  1317. db1.Model(gorm_model.YounggeeSketchInfo{}).Where("task_id = ? AND is_ok = ?", taskNeedModId, 1).Find(&taskSketchInfo)
  1318. if taskSketchInfo.AutoLinkBreakAt.IsZero() {
  1319. db1.Where("task_id = ?", taskNeedModId).Updates(&gorm_model.YounggeeSketchInfo{AutoLinkBreakAt: taskSketchInfo.AutoAgreeAt.Add(dd)})
  1320. fmt.Println("已添加链接违约自动处理时间")
  1321. if taskSketchInfo.AutoAgreeAt.Add(dd).Sub(time.Now()) <= 0 {
  1322. db4 := GetReadDB(context.Background())
  1323. err1 := db4.Model(gorm_model.YoungeeContractInfo{}).Create(&gorm_model.YoungeeContractInfo{
  1324. TaskID: taskNeedModId, BreakType: 3, BreakAt: time.Now(), DefaultStatus: 1}).Error
  1325. if err1 != nil {
  1326. return err1
  1327. }
  1328. db3 := GetReadDB(context.Background())
  1329. err2 := db3.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", taskNeedModId).Updates(&gorm_model.YoungeeTaskInfo{CurDefaultType: 5, LinkBreakRate: linkDefaultRate}).Error
  1330. if err2 != nil {
  1331. return err2
  1332. }
  1333. fmt.Println("创建时已违约则创建链接违约记录")
  1334. }
  1335. } else {
  1336. if taskSketchInfo.AutoLinkBreakAt.Sub(time.Now()) <= 0 {
  1337. db4 := GetReadDB(context.Background())
  1338. err1 := db4.Model(gorm_model.YoungeeContractInfo{}).Create(&gorm_model.YoungeeContractInfo{
  1339. TaskID: taskNeedModId, BreakType: 3, BreakAt: time.Now(), DefaultStatus: 1}).Error
  1340. if err1 != nil {
  1341. return err1
  1342. }
  1343. db3 := GetReadDB(context.Background())
  1344. err2 := db3.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", taskNeedModId).Updates(&gorm_model.YoungeeTaskInfo{CurDefaultType: 5, LinkBreakRate: linkDefaultRate}).Error
  1345. if err2 != nil {
  1346. return err2
  1347. }
  1348. fmt.Println("已创建链接违约记录")
  1349. }
  1350. }
  1351. }
  1352. // 根据最近一次拒绝时间判断当前是否违约
  1353. for _, submitTaskNeedModId := range submitTaskNeedModIds {
  1354. db2 := GetReadDB(context.Background())
  1355. var LinkBreach int32
  1356. db2.Model(&gorm_model.InfoAutoTask{}).Select("link_breach").Where("auto_task_id = ?", projectIdToAutoTaskIdMap[taskIdToProjectIdMap[submitTaskNeedModId]]).First(&LinkBreach)
  1357. dd, _ := time.ParseDuration(conv.MustString(LinkBreach, "") + "h")
  1358. var linkDefaultRate int
  1359. if taskIdToFeeFormMap[submitTaskNeedModId] == 1 {
  1360. db6 := GetReadDB(context.Background())
  1361. db6.Model(gorm_model.InfoAutoDefaultHandle{}).Select("link_replace_time_out").Where("auto_default_id = ?", projectIdToAutoDefaultIdMap[taskIdToProjectIdMap[submitTaskNeedModId]]).Find(&linkDefaultRate)
  1362. } else {
  1363. db6 := GetReadDB(context.Background())
  1364. db6.Model(gorm_model.InfoAutoDefaultHandle{}).Select("link_other_time_out").Where("auto_default_id = ?", projectIdToAutoDefaultIdMap[taskIdToProjectIdMap[submitTaskNeedModId]]).Find(&linkDefaultRate)
  1365. }
  1366. db1 := GetReadDB(context.Background())
  1367. var taskLinkInfo gorm_model.YounggeeLinkInfo
  1368. db1.Model(gorm_model.YounggeeLinkInfo{}).Where("task_id = ?", submitTaskNeedModId).Order("reject_at desc").First(&taskLinkInfo)
  1369. if taskLinkInfo.AutoLinkBreakAt.IsZero() {
  1370. err4 := db1.Where("task_id = ?", submitTaskNeedModId).Updates(&gorm_model.YounggeeLinkInfo{AutoLinkBreakAt: taskLinkInfo.RejectAt.Add(dd)}).Error
  1371. if err4 != nil {
  1372. return err4
  1373. }
  1374. fmt.Println("已添加链接违约自动处理时间")
  1375. if taskLinkInfo.RejectAt.Add(dd).Sub(time.Now()) <= 0 {
  1376. db4 := GetReadDB(context.Background())
  1377. err1 := db4.Model(gorm_model.YoungeeContractInfo{}).Create(&gorm_model.YoungeeContractInfo{
  1378. TaskID: submitTaskNeedModId, BreakType: 3, BreakAt: time.Now(), DefaultStatus: 1}).Error
  1379. if err1 != nil {
  1380. return err1
  1381. }
  1382. db3 := GetReadDB(context.Background())
  1383. err2 := db3.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", submitTaskNeedModId).Updates(&gorm_model.YoungeeTaskInfo{CurDefaultType: 5, LinkBreakRate: linkDefaultRate}).Error
  1384. if err2 != nil {
  1385. return err2
  1386. }
  1387. fmt.Println("创建时已违约则创建已提交链接的链接违约记录")
  1388. }
  1389. } else {
  1390. if taskLinkInfo.AutoLinkBreakAt.Sub(time.Now()) <= 0 {
  1391. db4 := GetReadDB(context.Background())
  1392. err1 := db4.Model(gorm_model.YoungeeContractInfo{}).Create(&gorm_model.YoungeeContractInfo{
  1393. TaskID: submitTaskNeedModId, BreakType: 3, BreakAt: time.Now(), DefaultStatus: 1}).Error
  1394. if err1 != nil {
  1395. return err1
  1396. }
  1397. db3 := GetReadDB(context.Background())
  1398. err2 := db3.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", submitTaskNeedModId).Updates(&gorm_model.YoungeeTaskInfo{CurDefaultType: 5, LinkBreakRate: linkDefaultRate}).Error
  1399. if err2 != nil {
  1400. return err2
  1401. }
  1402. fmt.Println("创建已提交链接的链接违约记录")
  1403. }
  1404. }
  1405. }
  1406. return nil
  1407. }
  1408. func GetAutoCaseCloseDefaultTask() error {
  1409. db := GetReadDB(context.Background())
  1410. var projectIds []int64
  1411. err := db.Select("project_id").Model(gorm_model.ProjectInfo{}).Where("project_type = ?", 1).Find(&projectIds).Error
  1412. if err != nil {
  1413. return err
  1414. }
  1415. //fmt.Println("projectIds:", projectIds)
  1416. // 任务id 对 项目id 的map
  1417. taskIdToProjectIdMap := map[int]int64{}
  1418. // 项目id 对 定时任务id 的map
  1419. projectIdToAutoTaskIdMap := map[int64]int{}
  1420. // 项目id 对 违约定时任务id 的map
  1421. projectIdToAutoDefaultIdMap := map[int64]int{}
  1422. var taskIds []int
  1423. for _, projectId := range projectIds {
  1424. db2 := GetReadDB(context.Background())
  1425. autoIds := gorm_model.ProjectInfo{}
  1426. db2.Select([]string{"auto_task_id", "auto_default_id"}).Model(&gorm_model.ProjectInfo{}).Where("project_id = ?", projectId).First(&autoIds)
  1427. projectIdToAutoTaskIdMap[projectId] = autoIds.AutoTaskID
  1428. projectIdToAutoDefaultIdMap[projectId] = autoIds.AutoDefaultID
  1429. var taskInfos []int32
  1430. db1 := GetReadDB(context.Background())
  1431. db1.Select("task_id").Model(&gorm_model.YoungeeTaskInfo{}).Where("project_id = ? AND cur_default_type = ? ", projectId, 0).Find(&taskInfos)
  1432. for _, taskInfo := range taskInfos {
  1433. taskIdToProjectIdMap[int(taskInfo)] = projectId
  1434. taskIds = append(taskIds, int(taskInfo))
  1435. }
  1436. }
  1437. //fmt.Println("projectIdToAutoTaskIdMap:", projectIdToAutoTaskIdMap)
  1438. //fmt.Println("projectIdToAutoDefaultIdMap:", projectIdToAutoDefaultIdMap)
  1439. //fmt.Println("taskIdToProjectIdMap:", taskIdToProjectIdMap)
  1440. //fmt.Println("taskIds:", taskIds)
  1441. // 首次提交链接的任务记录id
  1442. var taskNeedModIds []int
  1443. // 已提交链接的任务记录id
  1444. var submitTaskNeedModIds []int
  1445. // taskId 对 稿费形式的 map
  1446. taskIdToFeeFormMap := make(map[int]int)
  1447. for _, taskId := range taskIds {
  1448. var taskInfo gorm_model.YoungeeTaskInfo
  1449. db3 := GetReadDB(context.Background())
  1450. // 保存所有数据上传状态为 1 且任务状态为14 的任务记录的id
  1451. db3.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", taskId).First(&taskInfo)
  1452. if taskInfo.DataStatus == 1 && taskInfo.TaskStage == 14 {
  1453. taskNeedModIds = append(taskNeedModIds, taskId)
  1454. }
  1455. // 保存所有数据上传状态为 3 且任务状态为14 的任务记录的id
  1456. if taskInfo.DataStatus == 3 && taskInfo.TaskStage == 14 {
  1457. submitTaskNeedModIds = append(submitTaskNeedModIds, taskId)
  1458. }
  1459. taskIdToFeeFormMap[taskId] = taskInfo.FeeForm
  1460. }
  1461. //fmt.Println("taskIdToFeeFormMap:", taskIdToFeeFormMap)
  1462. //fmt.Println("taskNeedModIds:", taskNeedModIds)
  1463. //fmt.Println("submitTaskNeedModIds:", submitTaskNeedModIds)
  1464. for _, taskNeedModId := range taskNeedModIds {
  1465. db2 := GetReadDB(context.Background())
  1466. var CaseCloseDefault int32
  1467. db2.Model(&gorm_model.InfoAutoTask{}).Select("case_close_default").Where("auto_task_id = ?", projectIdToAutoTaskIdMap[taskIdToProjectIdMap[taskNeedModId]]).First(&CaseCloseDefault)
  1468. dd, _ := time.ParseDuration(conv.MustString(CaseCloseDefault, "") + "h")
  1469. var dataDefaultRate int
  1470. if taskIdToFeeFormMap[taskNeedModId] == 1 {
  1471. db6 := GetReadDB(context.Background())
  1472. db6.Model(gorm_model.InfoAutoDefaultHandle{}).Select("data_replace_time_out").Where("auto_default_id = ?", projectIdToAutoDefaultIdMap[taskIdToProjectIdMap[taskNeedModId]]).Find(&dataDefaultRate)
  1473. } else {
  1474. db6 := GetReadDB(context.Background())
  1475. db6.Model(gorm_model.InfoAutoDefaultHandle{}).Select("data_other_time_out").Where("auto_default_id = ?", projectIdToAutoDefaultIdMap[taskIdToProjectIdMap[taskNeedModId]]).Find(&dataDefaultRate)
  1476. }
  1477. //fmt.Println("dataDefaultRate:", dataDefaultRate)
  1478. db1 := GetReadDB(context.Background())
  1479. var taskLinkInfo gorm_model.YounggeeLinkInfo
  1480. db1.Model(gorm_model.YounggeeLinkInfo{}).Where("task_id = ? AND is_ok = ?", taskNeedModId, 1).Find(&taskLinkInfo)
  1481. if taskLinkInfo.AutoDataBreakAt.IsZero() {
  1482. db1.Where("task_id = ?", taskNeedModId).Updates(&gorm_model.YounggeeLinkInfo{AutoDataBreakAt: taskLinkInfo.AutoAgreeAt.Add(dd)})
  1483. fmt.Println("已添加数据违约自动处理时间")
  1484. if taskLinkInfo.AutoAgreeAt.Add(dd).Sub(time.Now()) <= 0 {
  1485. db4 := GetReadDB(context.Background())
  1486. err1 := db4.Model(gorm_model.YoungeeContractInfo{}).Create(&gorm_model.YoungeeContractInfo{
  1487. TaskID: taskNeedModId, BreakType: 4, BreakAt: time.Now(), DefaultStatus: 1}).Error
  1488. if err1 != nil {
  1489. return err1
  1490. }
  1491. db3 := GetReadDB(context.Background())
  1492. err2 := db3.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", taskNeedModId).Updates(&gorm_model.YoungeeTaskInfo{CurDefaultType: 7, DataBreakRate: dataDefaultRate}).Error
  1493. if err2 != nil {
  1494. return err2
  1495. }
  1496. fmt.Println("创建时已违约则创建数据违约记录")
  1497. }
  1498. } else {
  1499. if taskLinkInfo.AutoDataBreakAt.Sub(time.Now()) <= 0 {
  1500. db4 := GetReadDB(context.Background())
  1501. err1 := db4.Model(gorm_model.YoungeeContractInfo{}).Create(&gorm_model.YoungeeContractInfo{
  1502. TaskID: taskNeedModId, BreakType: 4, BreakAt: time.Now(), DefaultStatus: 1}).Error
  1503. if err1 != nil {
  1504. return err1
  1505. }
  1506. db3 := GetReadDB(context.Background())
  1507. err2 := db3.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", taskNeedModId).Updates(&gorm_model.YoungeeTaskInfo{CurDefaultType: 7, DataBreakRate: dataDefaultRate}).Error
  1508. if err2 != nil {
  1509. return err2
  1510. }
  1511. fmt.Println("已创建数据违约记录")
  1512. }
  1513. }
  1514. }
  1515. // 根据最近一次拒绝时间判断当前是否违约
  1516. for _, submitTaskNeedModId := range submitTaskNeedModIds {
  1517. db2 := GetReadDB(context.Background())
  1518. var LinkBreach int32
  1519. db2.Model(&gorm_model.InfoAutoTask{}).Select("case_close_default").Where("auto_task_id = ?", projectIdToAutoTaskIdMap[taskIdToProjectIdMap[submitTaskNeedModId]]).First(&LinkBreach)
  1520. dd, _ := time.ParseDuration(conv.MustString(LinkBreach, "") + "h")
  1521. var dataDefaultRate int
  1522. if taskIdToFeeFormMap[submitTaskNeedModId] == 1 {
  1523. db6 := GetReadDB(context.Background())
  1524. db6.Model(gorm_model.InfoAutoDefaultHandle{}).Select("data_replace_time_out").Where("auto_default_id = ?", projectIdToAutoDefaultIdMap[taskIdToProjectIdMap[submitTaskNeedModId]]).Find(&dataDefaultRate)
  1525. } else {
  1526. db6 := GetReadDB(context.Background())
  1527. db6.Model(gorm_model.InfoAutoDefaultHandle{}).Select("data_other_time_out").Where("auto_default_id = ?", projectIdToAutoDefaultIdMap[taskIdToProjectIdMap[submitTaskNeedModId]]).Find(&dataDefaultRate)
  1528. }
  1529. db1 := GetReadDB(context.Background())
  1530. var taskDataInfo gorm_model.YounggeeDataInfo
  1531. db1.Model(gorm_model.YounggeeDataInfo{}).Where("task_id = ?", submitTaskNeedModId).Order("reject_at desc").First(&taskDataInfo)
  1532. if taskDataInfo.AutoDataBreakAt.IsZero() {
  1533. err4 := db1.Where("task_id = ?", submitTaskNeedModId).Updates(&gorm_model.YounggeeDataInfo{AutoDataBreakAt: taskDataInfo.RejectAt.Add(dd)}).Error
  1534. if err4 != nil {
  1535. return err4
  1536. }
  1537. fmt.Println("已添加数据违约自动处理时间")
  1538. if taskDataInfo.RejectAt.Add(dd).Sub(time.Now()) <= 0 {
  1539. db4 := GetReadDB(context.Background())
  1540. err1 := db4.Model(gorm_model.YoungeeContractInfo{}).Create(&gorm_model.YoungeeContractInfo{
  1541. TaskID: submitTaskNeedModId, BreakType: 4, BreakAt: time.Now(), DefaultStatus: 1}).Error
  1542. if err1 != nil {
  1543. return err1
  1544. }
  1545. db3 := GetReadDB(context.Background())
  1546. err2 := db3.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", submitTaskNeedModId).Updates(&gorm_model.YoungeeTaskInfo{CurDefaultType: 7, DataBreakRate: dataDefaultRate}).Error
  1547. if err2 != nil {
  1548. return err2
  1549. }
  1550. fmt.Println("创建时已违约则创建已提交数据的数据违约记录")
  1551. }
  1552. } else {
  1553. if taskDataInfo.AutoDataBreakAt.Sub(time.Now()) <= 0 {
  1554. db4 := GetReadDB(context.Background())
  1555. err1 := db4.Model(gorm_model.YoungeeContractInfo{}).Create(&gorm_model.YoungeeContractInfo{
  1556. TaskID: submitTaskNeedModId, BreakType: 4, BreakAt: time.Now(), DefaultStatus: 1}).Error
  1557. if err1 != nil {
  1558. return err1
  1559. }
  1560. db3 := GetReadDB(context.Background())
  1561. err2 := db3.Model(gorm_model.YoungeeTaskInfo{}).Where("task_id = ?", submitTaskNeedModId).Updates(&gorm_model.YoungeeTaskInfo{
  1562. CurDefaultType: 7, DataBreakRate: dataDefaultRate}).Error
  1563. if err2 != nil {
  1564. return err2
  1565. }
  1566. fmt.Println("创建已提交数据的数据违约记录")
  1567. }
  1568. }
  1569. }
  1570. return nil
  1571. }