work_cron.go 5.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156
  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. newEventItemList := make([]*model.EventItem, 0)
  33. var _ = json.Unmarshal([]byte(sameTime.CollateNodes), &collateNodes)
  34. nowTime := time.Now()
  35. for i, collateNode := range collateNodes {
  36. showDay := nowTime
  37. if i > 0 {
  38. showDay = nowTime.Add(time.Hour * 24 * time.Duration(collateNode.NextNodeDay))
  39. }
  40. calendarName := backend.CalendarTypeMap()[pasturePb.CalendarType_PG]
  41. calendarType := pasturePb.CalendarType_PG
  42. histCount := int64(0)
  43. if collateNode.SameTimeType == pasturePb.SameTimeType_TAI {
  44. calendarName = backend.CalendarTypeMap()[pasturePb.CalendarType_Mating]
  45. calendarType = pasturePb.CalendarType_Mating
  46. histCount = e.GetTowardTaiCowSum()
  47. newEventMatingList = append(newEventMatingList, model.NewEventMatingList(newCowList, showDay.Unix())...)
  48. newEventItemList = append(newEventItemList, model.NewEventItemList(newCowList, calendarType)...)
  49. } else {
  50. if collateNode.SameTimeType == pasturePb.SameTimeType_RnGH {
  51. calendarName = backend.CalendarTypeMap()[pasturePb.CalendarType_RnGH]
  52. calendarType = pasturePb.CalendarType_RnGH
  53. }
  54. histCount = e.GetTowardSameTimeCowSum(sameTime.Id, collateNode.SameTimeType)
  55. newEventCowSameTimeList := model.NewEventCowSameTimeList(newCowList, sameTime, showDay.Unix(), collateNode.SameTimeType)
  56. newSameTimeCowDetailList = append(newSameTimeCowDetailList, newEventCowSameTimeList...)
  57. newEventItemList = append(newEventItemList, model.NewEventItemList(newCowList, calendarType)...)
  58. }
  59. calendarList = append(calendarList, &model.Calendar{
  60. Name: calendarName,
  61. CalendarType: calendarType,
  62. Count: int32(len(newCowList)) + int32(histCount),
  63. ShowDay: time.Unix(showDay.Unix(), 0).Format(model.LayoutDate2),
  64. IsShow: pasturePb.IsShow_Ok,
  65. })
  66. }
  67. newSameTimeCowList := model.NewCowSameTimeList(newCowList, sameTime)
  68. if err := e.DB.Transaction(func(tx *gorm.DB) error {
  69. // 创建牛只同期日历表
  70. if err := tx.Create(calendarList).Error; err != nil {
  71. return xerr.WithStack(err)
  72. }
  73. // 创建牛只同期总表
  74. if err := tx.Create(newSameTimeCowList).Error; err != nil {
  75. return xerr.WithStack(err)
  76. }
  77. // 创建牛只同期详情表
  78. if err := tx.Create(newSameTimeCowDetailList).Error; err != nil {
  79. return xerr.WithStack(err)
  80. }
  81. // 创建牛只配种表
  82. if err := tx.Create(newEventMatingList).Error; err != nil {
  83. return xerr.WithStack(err)
  84. }
  85. // 创建牛只事件表
  86. if err := tx.Create(newEventItemList).Error; err != nil {
  87. return xerr.WithStack(err)
  88. }
  89. return nil
  90. }); err != nil {
  91. return 0, xerr.WithStack(err)
  92. }
  93. return int32(len(newCowList)), nil
  94. }
  95. func (e *Entry) getWorkOrderCalendar(name string) []*model.Calendar {
  96. res := make([]*model.Calendar, 0)
  97. if err := e.DB.Where("name = ?", name).
  98. Where("is_show = ?", pasturePb.IsShow_Ok).
  99. Find(&res).Error; err != nil {
  100. zaplog.Error("getWorkOrderCalendar", zap.Any("err", err))
  101. }
  102. return res
  103. }
  104. // GetTowardSameTimeCowSum 获取历史未打激素牛只总数量
  105. func (e *Entry) GetTowardSameTimeCowSum(sameTimeId int64, sameTimeType pasturePb.SameTimeType_Kind) int64 {
  106. res := int64(0)
  107. if err := e.DB.Model(&model.EventCowSameTime{}).
  108. Where("status = ?", pasturePb.IsShow_No).
  109. Where("same_time_id = ?", sameTimeId).
  110. Where("same_time_type = ?", sameTimeType).
  111. Count(&res).Error; err != nil {
  112. zaplog.Error("GetTowardSameTimeCowSum", zap.Any("err", err))
  113. }
  114. return res
  115. }
  116. // GetTowardTaiCowSum 获取历史未配种牛只总数量
  117. func (e *Entry) GetTowardTaiCowSum() int64 {
  118. res := int64(0)
  119. if err := e.DB.Model(&model.EventMating{}).
  120. Where("status = ?", pasturePb.IsShow_No).
  121. Count(&res).Error; err != nil {
  122. zaplog.Error("GetTowardTaiCowSum", zap.Any("err", err))
  123. }
  124. return res
  125. }
  126. // CowPregnant 月度牛只怀孕清单
  127. func (e *Entry) CowPregnant() error {
  128. cowList := make([]*model.Cow, 0)
  129. if err := e.DB.Model(new(model.Cow)).
  130. Where("admission_status = ?", pasturePb.AdmissionStatus_Admission).
  131. Where("is_pregnant = ?", pasturePb.IsShow_Ok).Find(&cowList).Error; err != nil {
  132. return xerr.WithStack(err)
  133. }
  134. cowPregnantList := model.NewCowPregnantList(cowList)
  135. if err := e.DB.Create(cowPregnantList).Error; err != nil {
  136. return xerr.WithStack(err)
  137. }
  138. return nil
  139. }