work_cron.go 4.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138
  1. package crontab
  2. import (
  3. "encoding/json"
  4. "kpt-pasture/model"
  5. "kpt-pasture/module/backend"
  6. "time"
  7. "gorm.io/gorm"
  8. "gitee.com/xuyiping_admin/pkg/xerr"
  9. "gitee.com/xuyiping_admin/pkg/logger/zaplog"
  10. "go.uber.org/zap"
  11. pasturePb "gitee.com/xuyiping_admin/go_proto/proto/go/backend/cow"
  12. )
  13. // GenerateCalendarBySameTimePlan 生成同期计划的牛只
  14. func (e *Entry) GenerateCalendarBySameTimePlan(cowList []*model.Cow, sameTime *model.SameTime) (int32, error) {
  15. if len(cowList) <= 0 {
  16. return 0, nil
  17. }
  18. newCowList := make([]*model.Cow, 0)
  19. for _, cow := range cowList {
  20. if ok := e.IsExistSameTimeCow(cow, sameTime); ok {
  21. continue
  22. }
  23. newCowList = append(newCowList, cow)
  24. }
  25. if len(newCowList) <= 0 || len(sameTime.CollateNodes) <= 0 {
  26. return 0, nil
  27. }
  28. calendarList := make([]*model.Calendar, 0)
  29. newSameTimeCowDetailList := make([]*model.EventCowSameTime, 0)
  30. newEventMatingList := make([]*model.EventMating, 0)
  31. collateNodes := make([]*pasturePb.CollateNode, 0)
  32. var _ = json.Unmarshal([]byte(sameTime.CollateNodes), &collateNodes)
  33. nowTime := time.Now()
  34. for i, collateNode := range collateNodes {
  35. showDay := nowTime.Format(model.LayoutDate2)
  36. if i > 0 {
  37. showDay = nowTime.Add(time.Hour * 24 * time.Duration(collateNode.NextNodeDay)).Format(model.LayoutDate2)
  38. }
  39. calendarName := backend.CalendarTypeMap()[pasturePb.CalendarType_PG]
  40. calendarType := pasturePb.CalendarType_PG
  41. histCount := int64(0)
  42. if collateNode.SameTimeType == pasturePb.SameTimeType_TAI {
  43. calendarName = backend.CalendarTypeMap()[pasturePb.CalendarType_Mating]
  44. calendarType = pasturePb.CalendarType_Mating
  45. histCount = e.GetTowardTaiCowSum()
  46. newEventMatingList = append(newEventMatingList, model.NewEventMatingList(newCowList, showDay)...)
  47. } else {
  48. if collateNode.SameTimeType == pasturePb.SameTimeType_RnGH {
  49. calendarName = backend.CalendarTypeMap()[pasturePb.CalendarType_RnGH]
  50. calendarType = pasturePb.CalendarType_RnGH
  51. }
  52. histCount = e.GetTowardSameTimeCowSum(sameTime.Id, collateNode.SameTimeType)
  53. newSameTimeCowDetailList = append(
  54. newSameTimeCowDetailList,
  55. model.NewCowSameTimeDetailList(newCowList, sameTime.Id, showDay, collateNode.SameTimeType)...,
  56. )
  57. }
  58. calendarList = append(calendarList, &model.Calendar{
  59. Name: calendarName,
  60. CalendarType: calendarType,
  61. Count: int32(len(newCowList)) + int32(histCount),
  62. ShowDay: showDay,
  63. IsShow: pasturePb.IsShow_Ok,
  64. })
  65. }
  66. newSameTimeCowList := model.NewCowSameTimeList(newCowList, sameTime)
  67. if err := e.DB.Transaction(func(tx *gorm.DB) error {
  68. // 创建牛只同期日历表
  69. if err := tx.Create(calendarList).Error; err != nil {
  70. return xerr.WithStack(err)
  71. }
  72. // 创建牛只同期总表
  73. if err := tx.Create(newSameTimeCowList).Error; err != nil {
  74. return xerr.WithStack(err)
  75. }
  76. // 创建牛只同期详情表
  77. if err := tx.Create(newSameTimeCowDetailList).Error; err != nil {
  78. return xerr.WithStack(err)
  79. }
  80. // 创建牛只配种表
  81. if err := tx.Create(newEventMatingList).Error; err != nil {
  82. return xerr.WithStack(err)
  83. }
  84. return nil
  85. }); err != nil {
  86. return 0, xerr.WithStack(err)
  87. }
  88. return int32(len(newCowList)), nil
  89. }
  90. func (e *Entry) getWorkOrderCalendar(name string) []*model.Calendar {
  91. res := make([]*model.Calendar, 0)
  92. if err := e.DB.Where("name = ?", name).
  93. Where("is_show = ?", pasturePb.IsShow_Ok).
  94. Find(&res).Error; err != nil {
  95. zaplog.Error("getWorkOrderCalendar", zap.Any("err", err))
  96. }
  97. return res
  98. }
  99. // GetTowardSameTimeCowSum 获取历史未打激素牛只总数量
  100. func (e *Entry) GetTowardSameTimeCowSum(sameTimeId int64, sameTimeType pasturePb.SameTimeType_Kind) int64 {
  101. res := int64(0)
  102. if err := e.DB.Model(&model.EventCowSameTime{}).
  103. Where("status = ?", pasturePb.IsShow_No).
  104. Where("same_time_id = ?", sameTimeId).
  105. Where("same_time_type = ?", sameTimeType).
  106. Count(&res).Error; err != nil {
  107. zaplog.Error("GetTowardSameTimeCowSum", zap.Any("err", err))
  108. }
  109. return res
  110. }
  111. // GetTowardTaiCowSum 获取历史未配种牛只总数量
  112. func (e *Entry) GetTowardTaiCowSum() int64 {
  113. res := int64(0)
  114. if err := e.DB.Model(&model.EventMating{}).
  115. Where("status = ?", pasturePb.IsShow_No).
  116. Count(&res).Error; err != nil {
  117. zaplog.Error("GetTowardTaiCowSum", zap.Any("err", err))
  118. }
  119. return res
  120. }