neck_active_habit.go 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319
  1. package model
  2. import (
  3. "fmt"
  4. "kpt-pasture/util"
  5. "math"
  6. "strconv"
  7. "strings"
  8. pasturePb "gitee.com/xuyiping_admin/go_proto/proto/go/backend/cow"
  9. )
  10. const (
  11. InitChangeFilter = -10000
  12. DefaultChangeFilter = -99
  13. DefaultRuminaFilter = -99
  14. DefaultChewFilter = -99
  15. DefaultFilterCorrect = 100
  16. DefaultWeeklyActive = 1500
  17. DefaultRecordCount = 6
  18. )
  19. type NeckActiveHabit struct {
  20. Id int64 `json:"id"`
  21. PastureId int64 `json:"pastureId"`
  22. NeckRingNumber string `json:"neckRingNumber"`
  23. CowId int64 `json:"cowId"`
  24. EarNumber string `json:"earNumber"`
  25. Lact int32 `json:"lact"`
  26. CalvingAge int32 `json:"calvingAge"`
  27. ActiveTime string `json:"activeTime"`
  28. Frameid int32 `json:"frameid"`
  29. HeatDate string `json:"heatDate"`
  30. Rumina int32 `json:"rumina"`
  31. Intake int32 `json:"intake"`
  32. Inactive int32 `json:"inactive"`
  33. Gasp int32 `json:"gasp"`
  34. Other int32 `json:"other"`
  35. High int32 `json:"high"`
  36. Active int32 `json:"active"`
  37. FilterHigh int32 `json:"filterHigh"`
  38. FilterRumina int32 `json:"filterRumina"`
  39. FilterChew int32 `json:"filterChew"`
  40. WeekHigh int32 `json:"weekHigh"`
  41. HighHabit int32 `json:"highHabit"`
  42. RuminaHabit int32 `json:"ruminaHabit"`
  43. IntakeHabit int32 `json:"intakeHabit"`
  44. ChewHabit int32 `json:"chewHabit"`
  45. InactiveHabit int32 `json:"inactiveHabit"`
  46. OtherHabit int32 `json:"otherHabit"`
  47. ChangeHigh int32 `json:"changeHigh"`
  48. ChangeRumina int32 `json:"changeRumina"`
  49. ChangeChew int32 `json:"changeChew"`
  50. ChangeAdjust int32 `json:"changeAdjust"`
  51. ChangeFilter int32 `json:"changeFilter"`
  52. RuminaFilter int32 `json:"ruminaFilter"`
  53. ChewFilter int32 `json:"chewFilter"`
  54. FilterCorrect int32 `json:"filterCorrect"`
  55. SumRumina int32 `json:"sumRumina"`
  56. SumIntake int32 `json:"sumIntake"`
  57. SumInactive int32 `json:"sumInactive"`
  58. SumActive int32 `json:"sumActive"`
  59. SumMinHigh int32 `json:"sumMinHigh"`
  60. SumMaxHigh int32 `json:"sumMaxHigh"`
  61. SumMinChew int32 `json:"SumMinChew"`
  62. BeforeThreeSumRumina int32 `json:"beforeThreeSumRumina"`
  63. BeforeThreeSumIntake int32 `json:"beforeThreeSumIntake"`
  64. Score int32 `json:"score"`
  65. IsShow pasturePb.IsShow_Kind `json:"isShow"`
  66. Cft float32 `json:"cft"`
  67. Voltage int32 `json:"voltage"`
  68. RecordCount int32 `json:"recordCount"`
  69. FirmwareVersion int32 `json:"firmwareVersion"`
  70. CreatedAt int64 `json:"createdAt"`
  71. UpdatedAt int64 `json:"updatedAt"`
  72. }
  73. func (n *NeckActiveHabit) UnShardTableName() string {
  74. return "neck_active_habit"
  75. }
  76. /*func (n *NeckActiveHabit) TableName() string {
  77. return fmt.Sprintf("%s_%06d", n.UnShardTableName(), n.PastureId)
  78. }*/
  79. func (n *NeckActiveHabit) TableName() string {
  80. return "neck_active_habit"
  81. }
  82. func (n *NeckActiveHabit) SumAvg() {
  83. n.Rumina = n.Rumina / n.RecordCount * n.RecordCount
  84. n.Inactive = n.Inactive / n.RecordCount * n.RecordCount
  85. n.Active = n.Active / n.RecordCount * n.RecordCount
  86. n.Intake = n.Intake / n.RecordCount * n.RecordCount
  87. n.Other = n.Other / n.RecordCount * n.RecordCount
  88. n.Gasp = n.Gasp / n.RecordCount * n.RecordCount
  89. n.High = n.High / n.RecordCount * n.RecordCount
  90. }
  91. func (n *NeckActiveHabit) UpdateIsShowOk() {
  92. n.IsShow = pasturePb.IsShow_Ok
  93. }
  94. func NewNeckActiveHabit(data *NeckRingOriginalMerge) *NeckActiveHabit {
  95. return &NeckActiveHabit{
  96. PastureId: data.PastureId,
  97. Frameid: data.XframeId,
  98. HeatDate: data.ActiveDate,
  99. NeckRingNumber: data.NeckRingNumber,
  100. Active: data.Active,
  101. Gasp: data.Gasp,
  102. High: data.High,
  103. Inactive: data.Inactive,
  104. Intake: data.Intake,
  105. Other: data.Other,
  106. Rumina: data.Rumina,
  107. IsShow: data.IsShow,
  108. WeekHigh: DefaultWeeklyActive,
  109. ChangeFilter: InitChangeFilter,
  110. FilterCorrect: InitChangeFilter,
  111. RuminaFilter: InitChangeFilter,
  112. ChewFilter: InitChangeFilter,
  113. ActiveTime: fmt.Sprintf("%s %02d:00:00", data.ActiveDate, data.XframeId*2+1),
  114. RecordCount: data.RecordCount,
  115. FirmwareVersion: data.FirmwareVersion,
  116. Voltage: data.Voltage,
  117. }
  118. }
  119. type NeckActiveHabitSlice []*NeckActiveHabit
  120. func (n NeckActiveHabitSlice) Len() int { return len(n) }
  121. func (n NeckActiveHabitSlice) Swap(i, j int) { n[i], n[j] = n[j], n[i] }
  122. func (n NeckActiveHabitSlice) Less(i, j int) bool {
  123. if n[i].HeatDate != n[j].HeatDate {
  124. return n[i].HeatDate < n[j].HeatDate
  125. }
  126. return n[i].Frameid < n[j].Frameid
  127. }
  128. func (n NeckActiveHabitSlice) ToPB(curveName string) *CowBehaviorCurveData {
  129. res := &CowBehaviorCurveData{
  130. OriginalDateList: make([]int32, 0),
  131. ChangeDateList: make([]int32, 0),
  132. SumDateList: make([]int32, 0),
  133. DateTimeList: make([]string, 0),
  134. EstrusList: make(map[pasturePb.EstrusLevel_Kind][]string),
  135. EventList: make([]*pasturePb.CowEvent, 0),
  136. EventMap: make(map[pasturePb.EventType_Kind]string),
  137. RuminaChange: make([]int32, 0),
  138. IQR1: make([]int32, 0),
  139. IQR3: make([]int32, 0),
  140. }
  141. initFrameId := int32(0)
  142. dateFrameMap := make(map[string][]int32)
  143. for _, v := range n {
  144. if dateFrameMap[v.HeatDate] == nil {
  145. initFrameId = 0
  146. dateFrameMap[v.HeatDate] = make([]int32, 0)
  147. }
  148. // 补全结尾不够的数据
  149. if initFrameId == 0 && len(res.DateTimeList) > 0 {
  150. lastDateTime := res.DateTimeList[len(res.DateTimeList)-1]
  151. lastDatePare := strings.Split(lastDateTime, " ")
  152. if len(lastDatePare) == 2 {
  153. lastDay := lastDatePare[0]
  154. lastHourStr := lastDatePare[1]
  155. lastHour, _ := strconv.ParseInt(lastHourStr, 10, 64)
  156. maxHour := util.ExpectedFrameIDs[len(util.ExpectedFrameIDs)-1]
  157. xframeId := int32(lastHour-1)/2 + 1
  158. if xframeId != maxHour {
  159. for ; xframeId <= maxHour; xframeId++ {
  160. res.DateTimeList = append(res.DateTimeList, fmt.Sprintf("%s %02d", lastDay, util.ExpectedFrameIDs[xframeId]*2+1))
  161. res.OriginalDateList = append(res.OriginalDateList, 0)
  162. res.ChangeDateList = append(res.ChangeDateList, 0)
  163. res.SumDateList = append(res.SumDateList, 0)
  164. res.RuminaChange = append(res.RuminaChange, 0)
  165. res.SumChewList = append(res.SumChewList, 0)
  166. }
  167. }
  168. }
  169. }
  170. expectedFrameId := util.ExpectedFrameIDs[initFrameId]
  171. if expectedFrameId != v.Frameid {
  172. maxFrameId := int32(math.Abs(float64(expectedFrameId - v.Frameid)))
  173. for ; expectedFrameId < maxFrameId; expectedFrameId++ {
  174. res.DateTimeList = append(res.DateTimeList, fmt.Sprintf("%s %02d", v.HeatDate, util.ExpectedFrameIDs[expectedFrameId]*2+1))
  175. res.OriginalDateList = append(res.OriginalDateList, 0)
  176. res.ChangeDateList = append(res.ChangeDateList, 0)
  177. res.SumDateList = append(res.SumDateList, 0)
  178. res.RuminaChange = append(res.RuminaChange, 0)
  179. res.SumChewList = append(res.SumChewList, 0)
  180. }
  181. initFrameId = expectedFrameId
  182. }
  183. // 格式化为到小时的字符串
  184. parsedTime, _ := util.TimeParseLocal(LayoutTime, v.ActiveTime)
  185. hourStr := parsedTime.Format(LayoutHour)
  186. res.DateTimeList = append(res.DateTimeList, hourStr)
  187. switch curveName {
  188. case "active": // 活动量
  189. changeDateList := v.ChangeFilter * v.FilterCorrect / 100
  190. if changeDateList == DefaultChangeFilter {
  191. changeDateList = 0
  192. }
  193. res.OriginalDateList = append(res.OriginalDateList, v.High)
  194. res.ChangeDateList = append(res.ChangeDateList, changeDateList)
  195. res.RuminaChange = append(res.RuminaChange, v.RuminaFilter)
  196. case "rumina": // 反刍
  197. res.OriginalDateList = append(res.OriginalDateList, v.Rumina)
  198. res.ChangeDateList = append(res.ChangeDateList, v.RuminaFilter)
  199. res.SumDateList = append(res.SumDateList, v.SumRumina)
  200. res.SumChewList = append(res.SumChewList, v.SumRumina+v.SumIntake)
  201. case "intake": // 采食
  202. res.OriginalDateList = append(res.OriginalDateList, v.Intake)
  203. res.SumDateList = append(res.SumDateList, v.SumIntake)
  204. res.SumChewList = append(res.SumChewList, v.SumRumina+v.SumIntake)
  205. case "inactive": // 休息
  206. res.OriginalDateList = append(res.OriginalDateList, v.Inactive)
  207. res.SumDateList = append(res.SumDateList, v.SumInactive)
  208. case "chew": // 咀嚼
  209. res.OriginalDateList = append(res.OriginalDateList, v.Rumina+v.Intake)
  210. res.ChangeDateList = append(res.ChangeDateList, v.ChewFilter)
  211. res.SumDateList = append(res.SumDateList, v.SumRumina+v.SumIntake)
  212. case "immobility": // 静止
  213. res.OriginalDateList = append(res.OriginalDateList, 120-v.Active)
  214. res.SumDateList = append(res.SumDateList, 60*24-v.SumActive)
  215. }
  216. initFrameId++
  217. }
  218. return res
  219. }
  220. func (n NeckActiveHabitSlice) ToPB2(dataBetween []string, groupNeckActiveHabitList []*NeckActiveHabit) *pasturePb.CowBehaviorRateData {
  221. data := &pasturePb.CowBehaviorRateData{
  222. DateTime: dataBetween,
  223. RuminaRate: make([]float32, 0),
  224. IntakeRate: make([]float32, 0),
  225. InactiveRate: make([]float32, 0),
  226. GaspRate: make([]float32, 0),
  227. }
  228. neckActiveHabitMap := make(map[string]*NeckActiveHabit)
  229. for _, v := range n {
  230. if v.HeatDate == "" {
  231. continue
  232. }
  233. if _, ok := neckActiveHabitMap[v.HeatDate]; !ok {
  234. neckActiveHabitMap[v.HeatDate] = v
  235. }
  236. }
  237. groupNeckActiveHabitMap := make(map[string]*NeckActiveHabit)
  238. for _, v := range groupNeckActiveHabitList {
  239. if v.HeatDate == "" {
  240. continue
  241. }
  242. if _, ok := groupNeckActiveHabitMap[v.HeatDate]; !ok {
  243. groupNeckActiveHabitMap[v.HeatDate] = v
  244. }
  245. }
  246. for _, t := range dataBetween {
  247. ruminaRate, intakeRate, inactiveRate, gaspRate := float32(0), float32(0), float32(0), float32(0)
  248. if v, ok := neckActiveHabitMap[t]; ok {
  249. sum := v.Rumina + v.Intake + v.Inactive + v.Gasp
  250. if sum > 0 {
  251. // 保留小数点后两位
  252. ruminaRate = float32(math.Round(float64(v.Rumina)/float64(sum)*100) / 100)
  253. intakeRate = float32(math.Round(float64(v.Intake)/float64(sum)*100) / 100)
  254. inactiveRate = float32(math.Round(float64(v.Inactive)/float64(sum)*100) / 100)
  255. gaspRate = float32(math.Round(float64(v.Gasp)/float64(sum)*100) / 100)
  256. }
  257. }
  258. data.RuminaRate = append(data.RuminaRate, ruminaRate)
  259. data.IntakeRate = append(data.IntakeRate, intakeRate)
  260. data.InactiveRate = append(data.InactiveRate, inactiveRate)
  261. data.GaspRate = append(data.GaspRate, gaspRate)
  262. groupRuminaRate, groupIntakeRate, groupInactiveRate, groupGaspRate := float32(0), float32(0), float32(0), float32(0)
  263. if v, ok := groupNeckActiveHabitMap[t]; ok {
  264. groupSum := v.Rumina + v.Intake + v.Inactive + v.Gasp
  265. if groupSum > 0 {
  266. // 保留小数点后两位
  267. groupRuminaRate = float32(math.Round(float64(v.Rumina)/float64(groupSum)*100) / 100)
  268. groupIntakeRate = float32(math.Round(float64(v.Intake)/float64(groupSum)*100) / 100)
  269. groupInactiveRate = float32(math.Round(float64(v.Inactive)/float64(groupSum)*100) / 100)
  270. groupGaspRate = float32(math.Round(float64(v.Gasp)/float64(groupSum)*100) / 100)
  271. }
  272. }
  273. data.GroupRuminaRate = append(data.GroupRuminaRate, groupRuminaRate)
  274. data.GroupIntakeRate = append(data.GroupIntakeRate, groupIntakeRate)
  275. data.GroupInactiveRate = append(data.GroupInactiveRate, groupInactiveRate)
  276. data.GroupGaspRate = append(data.GroupGaspRate, groupGaspRate)
  277. }
  278. return data
  279. }
  280. type MaxHabitIdModel struct {
  281. Id int64 `json:"id"`
  282. }
  283. type WeeklyActiveModel struct {
  284. CowId int64 `json:"cow_id"`
  285. HeatDate string `json:"heat_date"`
  286. Nb int32 `json:"nb"`
  287. High int32 `json:"high"`
  288. }
  289. type NeckRingErrorModel struct {
  290. CowId int64
  291. Nb int32
  292. Nba int32
  293. Voltage int32
  294. }