cow_cron.go 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553
  1. package crontab
  2. import (
  3. "context"
  4. "fmt"
  5. "kpt-pasture/model"
  6. "kpt-pasture/module/backend"
  7. "kpt-pasture/util"
  8. "strings"
  9. "time"
  10. pasturePb "gitee.com/xuyiping_admin/go_proto/proto/go/backend/cow"
  11. "gitee.com/xuyiping_admin/pkg/logger/zaplog"
  12. "gitee.com/xuyiping_admin/pkg/xerr"
  13. "go.uber.org/zap"
  14. )
  15. const (
  16. UpdateCowInfo = "UpdateCowInfo"
  17. ImmunizationPlan = "ImmunizationPlan"
  18. SameTimePlan = "SameTimePlan"
  19. WorkOrderMaster = "WorkOrderMaster"
  20. SystemBasicCrontab = "SystemBasicCrontab"
  21. NeckRingOriginal = "NeckRingOriginal"
  22. )
  23. // GenerateAsynqWorkOrder 异步生成工作单
  24. func (e *Entry) GenerateAsynqWorkOrder() error {
  25. if ok := e.IsExistCrontabLog(WorkOrderMaster); ok {
  26. return nil
  27. }
  28. defer func() {
  29. e.CreateCrontabLog(WorkOrderMaster)
  30. }()
  31. workOrderList := make([]*model.WorkOrderMaster, 0)
  32. if err := e.DB.Where("is_show = ?", pasturePb.IsShow_Ok).Find(&workOrderList).Error; err != nil {
  33. return err
  34. }
  35. for _, workOrder := range workOrderList {
  36. timeUnix, err := util.ConvertParseLocalUnix(workOrder.ExecTime)
  37. if timeUnix <= 0 || err != nil {
  38. zaplog.Error("crontab", zap.Any("GenerateWorkOrder", err), zap.Any("execTime", workOrder.ExecTime))
  39. continue
  40. }
  41. nowTime := time.Now().Unix()
  42. if timeUnix < nowTime {
  43. continue
  44. }
  45. execTime := timeUnix - nowTime
  46. task := model.NewTaskWorkOrderPayload(workOrder.Id, time.Duration(execTime)*time.Second)
  47. if _, err = e.AsynqClient.CtxEnqueue(context.Background(), task); err != nil {
  48. zaplog.Error("PushMessage CtxEnqueue", zap.Any("Err", err))
  49. }
  50. }
  51. return nil
  52. }
  53. // Indicators 月度指标维护
  54. func (e *Entry) Indicators() error {
  55. indicatorsDetailsList := make([]*model.IndicatorsDetails, 0)
  56. if err := e.DB.Model(new(model.IndicatorsDetails)).
  57. Find(&indicatorsDetailsList).Error; err != nil {
  58. return err
  59. }
  60. pastureList := e.FindPastureList()
  61. startTime, endTime := util.GetMonthStartAndEndTimestamp()
  62. for _, indicatorsDetail := range indicatorsDetailsList {
  63. pastureIndicatorList := map[int64]string{}
  64. switch indicatorsDetail.Kind {
  65. case model.AllCow:
  66. pastureIndicatorList = e.FindPastureAllCow(pastureList)
  67. case model.AdultCow:
  68. pastureIndicatorList = e.FindPastureAdultCow(pastureList)
  69. case model.CalvingInterval:
  70. pastureIndicatorList = e.FindCalvingInterval(pastureList, startTime, endTime)
  71. case model.OutputNumber:
  72. pastureIndicatorList = e.FindOutputNumber(pastureList, startTime, endTime)
  73. case model.InputNumber:
  74. pastureIndicatorList = e.FindInputNumber(pastureList, startTime, endTime)
  75. case model.SalesVolume:
  76. pastureIndicatorList = e.FindSalesVolume(pastureList, startTime, endTime)
  77. case model.CalvingNumber:
  78. pastureIndicatorList = e.FindCalvingNumber(pastureList, startTime, endTime)
  79. case model.AdultAbortionRate:
  80. pastureIndicatorList = e.FindAdultAbortionRate(pastureList, "adult", startTime, endTime)
  81. case model.YouthAbortionRate:
  82. pastureIndicatorList = e.FindAdultAbortionRate(pastureList, "youth", startTime, endTime)
  83. case model.AllDieNumber:
  84. pastureIndicatorList = e.FindDepartureNumber(pastureList, pasturePb.DepartureType_Death, startTime, endTime)
  85. case model.DiseaseNumber:
  86. pastureIndicatorList = e.FindDiseaseNumber(pastureList, startTime, endTime)
  87. case model.CureNumber:
  88. pastureIndicatorList = e.FindCureNumber(pastureList, startTime, endTime)
  89. case model.OutNumber:
  90. pastureIndicatorList = e.FindDepartureNumber(pastureList, pasturePb.DepartureType_Out, startTime, endTime)
  91. case model.CalfDieNumber:
  92. pastureIndicatorList = e.FindCalfDieNumber(pastureList, pasturePb.DepartureType_Death, startTime, endTime)
  93. case model.LactationCow:
  94. pastureIndicatorList = e.LactationCow(pastureList, pasturePb.CowMilk_Lactation)
  95. case model.DryMilkCow:
  96. pastureIndicatorList = e.LactationCow(pastureList, pasturePb.CowMilk_Dry_Milk)
  97. case model.ReserveCow:
  98. pastureIndicatorList = e.LactationCow(pastureList, pasturePb.CowMilk_Reserve)
  99. }
  100. for pastureId, value := range pastureIndicatorList {
  101. e.UpdatePastureIndicators(pastureId, indicatorsDetail, startTime, value)
  102. }
  103. }
  104. return nil
  105. }
  106. // UpdateCowInfo 牛只基本信息维护
  107. func (e *Entry) UpdateCowInfo() error {
  108. cowList := make([]*model.Cow, 0)
  109. if err := e.DB.Model(new(model.Cow)).
  110. Where("admission_status = ?", pasturePb.AdmissionStatus_Admission).
  111. Find(&cowList).Error; err != nil {
  112. return err
  113. }
  114. if ok := e.IsExistCrontabLog(UpdateCowInfo); ok {
  115. return nil
  116. }
  117. defer func() {
  118. e.CreateCrontabLog(UpdateCowInfo)
  119. }()
  120. for _, cow := range cowList {
  121. weeklyActive := e.UpdateCowWeeklyHigh(cow)
  122. cow.EventUpdate(weeklyActive)
  123. if err := e.DB.Model(new(model.Cow)).
  124. Select("day_age", "calving_age", "pregnancy_age", "admission_age", "abortion_age", "cow_type",
  125. "weekly_active", "lactation_age", "dry_milk_age").
  126. Where("id = ?", cow.Id).
  127. Updates(cow).Error; err != nil {
  128. zaplog.Error("Crontab", zap.Any("UpdateCowDayAge", err))
  129. }
  130. }
  131. return nil
  132. }
  133. // ImmunizationPlan 免疫计划,生成工作单
  134. func (e *Entry) ImmunizationPlan() error {
  135. if ok := e.IsExistCrontabLog(ImmunizationPlan); ok {
  136. return nil
  137. }
  138. planList := make([]*model.ImmunizationPlan, 0)
  139. if err := e.DB.Model(new(model.ImmunizationPlan)).
  140. Where("is_show = ?", pasturePb.IsShow_Ok).
  141. Order("pasture_id").
  142. Find(&planList).Error; err != nil {
  143. return xerr.WithStack(err)
  144. }
  145. var todayCount int32 = 0
  146. nowTime := time.Now()
  147. for _, plan := range planList {
  148. cowList := make([]*model.Cow, 0)
  149. pref := e.DB.Table(fmt.Sprintf("%s as a", new(model.Cow).TableName())).
  150. Select("a.*").
  151. Where("a.pasture_id = ?", plan.PastureId).
  152. Where("a.admission_status = ?", pasturePb.AdmissionStatus_Admission).
  153. Where("NOT EXISTS ( select 1 from event_immunization_plan b where b.pen_id = a.id and b.status = ? and b.plan_day > ?)", pasturePb.IsShow_No, nowTime.Unix())
  154. if plan.CowType > 0 {
  155. pref.Where("a.cow_type = ?", plan.CowType)
  156. }
  157. switch plan.Conditions {
  158. case pasturePb.ImmunizationConditions_Days_Age:
  159. pref.Where("a.day_age = ?", plan.Value)
  160. case pasturePb.ImmunizationConditions_Days_After_Delivery:
  161. pref.Where("a.calving_age = ?", plan.Value)
  162. case pasturePb.ImmunizationConditions_Days_Of_Pregnancy:
  163. pref.Where("a.pregnancy_age = ?", plan.Value).
  164. Where("a.is_pregnant = ?", pasturePb.IsShow_Ok)
  165. case pasturePb.ImmunizationConditions_Month:
  166. continue
  167. case pasturePb.ImmunizationConditions_Admission_Days:
  168. pref.Where("a.admission_age = ?", plan.Value)
  169. case pasturePb.ImmunizationConditions_Other_Vaccine_After:
  170. if plan.ImmunizationPlanId > 0 {
  171. pref.Joins("INNER JOIN event_immunization_plan as b ON b.plan_id = ? ", plan.ImmunizationPlanId).
  172. Where("b.cow_id = a.id").
  173. Where("DATE_ADD(b.reality_day, INTERVAL ? DAY) = ?", plan.Value, time.Now().Format(model.LayoutDate2)).
  174. Where("b.status = ?", pasturePb.IsShow_Ok)
  175. }
  176. }
  177. if err := pref.Find(&cowList).Debug().Error; err != nil {
  178. return xerr.WithStack(err)
  179. }
  180. if len(cowList) <= 0 {
  181. continue
  182. }
  183. newImmunizationPlanCowList := model.NewCowImmunizationPlanList(cowList, plan)
  184. if err := e.DB.Model(new(model.EventImmunizationPlan)).Create(newImmunizationPlanCowList).Error; err != nil {
  185. zaplog.Error("ImmunizationPlan",
  186. zap.Any("err", err),
  187. zap.Any("plan", plan),
  188. zap.Any("cowList", cowList),
  189. zap.Any("newImmunizationPlanCowList", newImmunizationPlanCowList),
  190. )
  191. return xerr.WithStack(err)
  192. }
  193. todayCount = int32(len(newImmunizationPlanCowList))
  194. if todayCount > 0 {
  195. endDay := nowTime.AddDate(0, 0, model.CalendarTypeEndDaysMap[pasturePb.CalendarType_Immunisation])
  196. e.CreatedCalendar(plan.PastureId, pasturePb.CalendarType_Immunisation, nowTime.Format(model.LayoutDate2), endDay.Format(model.LayoutDate2), todayCount)
  197. }
  198. e.CreateCrontabLog(ImmunizationPlan)
  199. }
  200. return nil
  201. }
  202. // SameTimePlan 同期计划,生成工作单
  203. func (e *Entry) SameTimePlan() error {
  204. if ok := e.IsExistCrontabLog(SameTimePlan); ok {
  205. return nil
  206. }
  207. sameTimeList := make([]*model.SameTime, 0)
  208. if err := e.DB.Model(new(model.SameTime)).
  209. Where("is_show = ?", pasturePb.IsShow_Ok).
  210. Order("pasture_id").
  211. Find(&sameTimeList).Error; err != nil {
  212. return xerr.WithStack(err)
  213. }
  214. if len(sameTimeList) < 0 {
  215. return nil
  216. }
  217. defer func() {
  218. e.CreateCrontabLog(SameTimePlan)
  219. }()
  220. currWeek := time.Now().Weekday()
  221. for _, sameTime := range sameTimeList {
  222. if len(sameTime.WeekType) <= 0 {
  223. continue
  224. }
  225. wts := strings.Split(sameTime.WeekType, model.WeekTypeSeparator)
  226. if len(wts) <= 0 {
  227. continue
  228. }
  229. var info bool
  230. for _, wt := range wts {
  231. if time.Weekday(int(pasturePb.Week_Kind_value[wt])) == currWeek {
  232. info = true
  233. break
  234. }
  235. }
  236. if !info {
  237. continue
  238. }
  239. cowList := make([]*model.Cow, 0)
  240. pref := e.DB.Model(new(model.Cow)).
  241. Where("admission_status = ?", pasturePb.AdmissionStatus_Admission).
  242. Where("sex = ?", pasturePb.Genders_Female).
  243. Where("pasture_id = ?", sameTime.PastureId).
  244. Where("is_pregnant = ?", pasturePb.IsShow_No)
  245. switch sameTime.CowType {
  246. case pasturePb.SameTimeCowType_Breeding_Calf:
  247. pref.Where("calving_age BETWEEN ? AND ?", sameTime.PostpartumDaysStart, sameTime.PostpartumDaysEnd).
  248. Where("lact > ?", 0)
  249. case pasturePb.SameTimeCowType_Empty:
  250. pref.Where(
  251. e.DB.Where("breed_status = ?", pasturePb.BreedStatus_Empty).
  252. Or("breed_status = ?", pasturePb.BreedStatus_Abort),
  253. )
  254. default:
  255. continue
  256. }
  257. if err := pref.Where(`NOT EXISTS (SELECT 1 FROM event_cow_same_time WHERE event_cow_same_time.cow_id = cow.id
  258. AND event_cow_same_time.status = ?)`, pasturePb.IsShow_No).
  259. Find(&cowList).Error; err != nil {
  260. zaplog.Error("crontab", zap.Any("err", err), zap.Any("sameTime", sameTime))
  261. return xerr.WithStack(err)
  262. }
  263. if len(cowList) <= 0 {
  264. continue
  265. }
  266. if err := e.GenerateCalendarBySameTimePlan(cowList, sameTime); err != nil {
  267. zaplog.Error("crontab",
  268. zap.Any("GenerateCalendarBySameTimePlan", err),
  269. zap.Any("cowList", cowList),
  270. zap.Any("plan", sameTime),
  271. )
  272. continue
  273. }
  274. }
  275. return nil
  276. }
  277. // UpdateSameTime 更新每天同期数据
  278. func (e *Entry) UpdateSameTime() error {
  279. calendarTypeList := backend.CalendarTypeEnumList("")
  280. showDay := time.Now().Format(model.LayoutDate2)
  281. for _, v := range calendarTypeList {
  282. count := int64(0)
  283. if err := e.DB.Model(new(model.EventCowSameTime)).
  284. Where("same_time_type = ?", v.Value).
  285. Where("status = ?", pasturePb.IsShow_No).
  286. Count(&count).Error; err != nil {
  287. zaplog.Error("crontab", zap.Any("UpdateSameTime", err), zap.Any("count", count))
  288. }
  289. if count >= 0 {
  290. continue
  291. }
  292. isExist := int64(0)
  293. if err := e.DB.Model(new(model.Calendar)).
  294. Where("calendar_type = ?", v.Value).
  295. Where("show_day = ?", showDay).
  296. Count(&isExist).Error; err != nil {
  297. continue
  298. }
  299. if isExist <= 0 {
  300. continue
  301. }
  302. if err := e.DB.Model(new(model.Calendar)).
  303. Where("calendar_type = ?", v.Value).
  304. Where("show_day = ?", showDay).
  305. Updates(map[string]interface{}{
  306. "count": count,
  307. }).Error; err != nil {
  308. continue
  309. }
  310. }
  311. return nil
  312. }
  313. // SystemBasicCrontab 基础配置计划任务
  314. func (e *Entry) SystemBasicCrontab() error {
  315. if ok := e.IsExistCrontabLog(SystemBasicCrontab); ok {
  316. return nil
  317. }
  318. defer func() {
  319. e.CreateCrontabLog(SystemBasicCrontab)
  320. }()
  321. systemBasicList := make([]*model.SystemBasic, 0)
  322. if err := e.DB.Model(new(model.SystemBasic)).
  323. Where("is_show = ?", pasturePb.IsShow_Ok).
  324. Where("name IN ?", []string{
  325. model.PregnantCheckForFirst,
  326. model.PregnantCheckForSecond,
  327. model.WeaningAge,
  328. model.PregnancyAge,
  329. model.DryMilkAge,
  330. }).Order("pasture_id").
  331. Find(&systemBasicList).Error; err != nil {
  332. zaplog.Error("crontab", zap.Any("PregnancyCheck", err))
  333. return xerr.WithStack(err)
  334. }
  335. currWeekValue := time.Now().Weekday()
  336. for _, systemBasic := range systemBasicList {
  337. // 周执行
  338. if systemBasic.Name == model.PregnantCheckForFirst && systemBasic.WeekValue >= 0 &&
  339. time.Weekday(systemBasic.WeekValue) != currWeekValue {
  340. continue
  341. }
  342. cowList := make([]*model.Cow, 0)
  343. pref := e.DB.Model(new(model.Cow)).
  344. Where("admission_status = ? ", pasturePb.AdmissionStatus_Admission).
  345. Where("pasture_id = ?", systemBasic.PastureId)
  346. switch systemBasic.Name {
  347. case model.PregnantCheckForFirst: // 初检清单
  348. pref.Where("breed_status = ?", pasturePb.BreedStatus_Breeding).
  349. Where("last_mating_at > ?", 0).
  350. Where("DATE(FROM_UNIXTIME(last_mating_at)) BETWEEN DATE_SUB(CURDATE(), INTERVAL ? DAY) AND DATE_SUB(CURDATE(), INTERVAL ? DAY)", systemBasic.MaxValue, systemBasic.MinValue).
  351. Where(`NOT EXISTS (SELECT 1 FROM event_pregnant_check WHERE event_pregnant_check.cow_id = cow.id
  352. AND event_pregnant_check.status = ? AND event_pregnant_check.pregnant_check_name = ?)`, pasturePb.IsShow_No, model.PregnantCheckForFirst)
  353. case model.PregnantCheckForSecond: // 复检清单 过滤初检空怀的牛只
  354. pref.Where("breed_status IN (?)", []pasturePb.BreedStatus_Kind{pasturePb.BreedStatus_Pregnant}).
  355. Where("last_mating_at > ?", 0).
  356. Where("DATE(FROM_UNIXTIME(last_mating_at)) = DATE_SUB(CURDATE(), INTERVAL ? DAY)", systemBasic.MinValue).
  357. Where(`NOT EXISTS (SELECT 1 FROM event_pregnant_check WHERE event_pregnant_check.cow_id = cow.id
  358. AND event_pregnant_check.status = ? AND event_pregnant_check.pregnant_check_name = ? )`, pasturePb.IsShow_No, model.PregnantCheckForSecond)
  359. case model.WeaningAge: // 断奶清单
  360. pref.Where("day_age = ?", systemBasic.MinValue).
  361. Where("NOT EXISTS (SELECT 1 FROM event_weaning WHERE event_weaning.cow_id = cow.id AND event_weaning.status = ?)", pasturePb.IsShow_No)
  362. case model.PregnancyAge: // 产犊清单
  363. pref.Where("pregnancy_age = ?", systemBasic.MinValue-10).
  364. Where("breed_status = ?", pasturePb.BreedStatus_Pregnant).
  365. Where("NOT EXISTS (SELECT 1 FROM event_calving WHERE event_calving.cow_id = cow.id AND event_calving.status = ?)", pasturePb.IsShow_No)
  366. case model.DryMilkAge: // 干奶清单
  367. pref.Where("pregnancy_age = ?", systemBasic.MinValue).
  368. Where("breed_status = ?", pasturePb.BreedStatus_Pregnant).
  369. Where("is_pregnant = ?", pasturePb.IsShow_Ok).
  370. Where("NOT EXISTS (SELECT 1 FROM event_dry_milk WHERE event_dry_milk.cow_id = cow.id AND event_dry_milk.status = ?)", pasturePb.IsShow_No)
  371. default:
  372. continue
  373. }
  374. if err := pref.Find(&cowList).Error; err != nil {
  375. zaplog.Error("crontab", zap.Any("PregnancyCheck", err), zap.Any("cowList", cowList))
  376. continue
  377. }
  378. if len(cowList) <= 0 {
  379. continue
  380. }
  381. e.InitEventData(cowList, systemBasic)
  382. }
  383. return nil
  384. }
  385. func (e *Entry) DeleteOldOriginal() error {
  386. if err := e.DB.Model(new(model.NeckRingOriginal)).
  387. Where("active_date <= ?", time.Now().AddDate(0, 0, -7).Format(model.LayoutDate2)).
  388. Delete(&model.NeckRingOriginal{}).Error; err != nil {
  389. zaplog.Error("crontab", zap.Any("DeleteOldOriginal", err))
  390. }
  391. return nil
  392. }
  393. // UpdateDiseaseToCalendar 更新每天治疗中牛头数到日历表中
  394. func (e *Entry) UpdateDiseaseToCalendar() error {
  395. pastureList := e.FindPastureList()
  396. for _, pasture := range pastureList {
  397. // 更新每天治疗中牛头数到日历表中
  398. var count int64
  399. if err := e.DB.Model(new(model.EventCowDisease)).
  400. Where("pasture_id = ?", pasture.Id).
  401. Where("health_status IN (?)", []pasturePb.HealthStatus_Kind{pasturePb.HealthStatus_Disease, pasturePb.HealthStatus_Treatment}).
  402. Count(&count).Error; err != nil {
  403. zaplog.Error("crontab", zap.Any("UpdateDisease", err))
  404. }
  405. if count > 0 {
  406. calendarTypeName := backend.CalendarTypeMap()[pasturePb.CalendarType_Disease]
  407. startDay := time.Now().Format(model.LayoutDate2)
  408. newCalendar := model.NewCalendar(pasture.Id, calendarTypeName, pasturePb.CalendarType_Disease, startDay, startDay, int32(count))
  409. if err := e.DB.Model(new(model.Calendar)).
  410. Create(newCalendar).Error; err != nil {
  411. zaplog.Error("crontab", zap.Any("UpdateDisease", err))
  412. }
  413. }
  414. }
  415. return nil
  416. }
  417. func (e *Entry) InitEventData(cowList []*model.Cow, systemBasic *model.SystemBasic) {
  418. calendarType := pasturePb.CalendarType_Invalid
  419. nowTime := time.Now()
  420. startDay, endDay := "", ""
  421. switch systemBasic.Name {
  422. case model.PregnantCheckForFirst, model.PregnantCheckForSecond:
  423. penMap, _ := e.GetPenMapList(systemBasic.PastureId)
  424. calendarType = pasturePb.CalendarType_Pregnancy_Check
  425. startDay, endDay = nowTime.Format(model.LayoutDate2), nowTime.AddDate(0, 0, model.CalendarTypeEndDaysMap[calendarType]).Format(model.LayoutDate2)
  426. eventPregnantCheckDataList := model.NewEventPregnantCheckList(systemBasic.PastureId, cowList, penMap, systemBasic.Name, startDay, endDay)
  427. if err := e.DB.Model(new(model.EventPregnantCheck)).Create(eventPregnantCheckDataList).Error; err != nil {
  428. zaplog.Error("crontab", zap.Any("InitEventData", err), zap.Any("eventPregnantCheckDataList", eventPregnantCheckDataList))
  429. return
  430. }
  431. case model.WeaningAge:
  432. calendarType = pasturePb.CalendarType_Weaning
  433. startDay, endDay = nowTime.Format(model.LayoutDate2), nowTime.AddDate(0, 0, model.CalendarTypeEndDaysMap[calendarType]).Format(model.LayoutDate2)
  434. eventWeaningDataList := model.NewEventWeaningList(systemBasic.PastureId, cowList, startDay, endDay)
  435. if err := e.DB.Model(new(model.EventWeaning)).Create(eventWeaningDataList).Error; err != nil {
  436. zaplog.Error("crontab", zap.Any("InitEventData", err), zap.Any("eventWeaningDataList", eventWeaningDataList))
  437. return
  438. }
  439. case model.PregnancyAge:
  440. calendarType = pasturePb.CalendarType_Calving
  441. startDay, endDay = nowTime.Format(model.LayoutDate2), nowTime.AddDate(0, 0, model.CalendarTypeEndDaysMap[calendarType]).Format(model.LayoutDate2)
  442. eventCalvingList := model.NewEventCalvingList(systemBasic.PastureId, cowList, startDay, endDay)
  443. if err := e.DB.Model(new(model.EventCalving)).Create(eventCalvingList).Error; err != nil {
  444. zaplog.Error("crontab", zap.Any("InitEventData", err), zap.Any("eventCalvingList", eventCalvingList))
  445. return
  446. }
  447. case model.DryMilkAge:
  448. calendarType = pasturePb.CalendarType_DryMilk
  449. startDay, endDay = nowTime.Format(model.LayoutDate2), nowTime.AddDate(0, 0, model.CalendarTypeEndDaysMap[calendarType]).Format(model.LayoutDate2)
  450. eventCalvingList := model.NewEventDryMilkList(systemBasic.PastureId, cowList, startDay, endDay)
  451. if err := e.DB.Model(new(model.EventDryMilk)).Create(eventCalvingList).Error; err != nil {
  452. zaplog.Error("crontab", zap.Any("InitEventData", err), zap.Any("eventCalvingList", eventCalvingList))
  453. return
  454. }
  455. }
  456. e.CreatedCalendar(systemBasic.PastureId, calendarType, startDay, endDay, int32(len(cowList)))
  457. }
  458. // UpdateCowWeeklyHigh 更新牛只周活动量
  459. func (e *Entry) UpdateCowWeeklyHigh(cow *model.Cow) int32 {
  460. highData, err := e.GetSystemNeckRingConfigure(cow.PastureId, model.High)
  461. if err != nil || highData == nil || highData.Value <= 0 {
  462. return 0
  463. }
  464. minWeeklyActive, er := e.GetSystemNeckRingConfigure(cow.PastureId, model.MinWeeklyActive)
  465. if er != nil || minWeeklyActive == nil || minWeeklyActive.Value <= 0 {
  466. return 0
  467. }
  468. weeklyActiveModelList := make([]*model.WeeklyActiveModel, 0)
  469. startTime := time.Now().AddDate(0, 0, -8).Format(model.LayoutDate2)
  470. endTime := time.Now().AddDate(0, 0, -2).Format(model.LayoutDate2)
  471. selectStr := fmt.Sprintf(`cow_id,heat_date,count(1) AS nb,IF(ROUND(AVG(high))>%d, ROUND(AVG(high)), %d) AS high`, minWeeklyActive.Value, minWeeklyActive.Value)
  472. if err = e.DB.Model(new(model.NeckActiveHabit)).
  473. Select(selectStr).
  474. Where("cow_id = ?", cow.Id).
  475. Where("heat_date BETWEEN ? AND ?", startTime, endTime).
  476. Where("high > ?", highData.Value).
  477. Having("nb > ?", 8).
  478. Order("high").
  479. Group("heat_date").
  480. Find(&weeklyActiveModelList).Error; err != nil {
  481. zaplog.Error("crontab", zap.Any("UpdateCowWeeklyHigh", err))
  482. return 0
  483. }
  484. if len(weeklyActiveModelList) < 3 {
  485. return 0
  486. }
  487. countHigh := len(weeklyActiveModelList)
  488. sumHigh := int32(0)
  489. minHigh := weeklyActiveModelList[0].High
  490. maxHigh := int32(0)
  491. for _, v := range weeklyActiveModelList {
  492. sumHigh += v.High
  493. if v.High > maxHigh {
  494. maxHigh = v.High
  495. }
  496. if v.High < minHigh {
  497. minHigh = v.High
  498. }
  499. }
  500. diff := 3
  501. x := int32(0)
  502. if countHigh == 3 {
  503. diff = 2
  504. x = weeklyActiveModelList[1].High
  505. }
  506. avgHigh := float64(sumHigh-minHigh-maxHigh-x) / float64(countHigh-diff)
  507. return int32(avgHigh)
  508. }