event_breed.go 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698
  1. package backend
  2. import (
  3. "context"
  4. "fmt"
  5. "kpt-pasture/model"
  6. "kpt-pasture/util"
  7. "net/http"
  8. "strings"
  9. "time"
  10. "gitee.com/xuyiping_admin/pkg/logger/zaplog"
  11. "go.uber.org/zap"
  12. pasturePb "gitee.com/xuyiping_admin/go_proto/proto/go/backend/cow"
  13. "gitee.com/xuyiping_admin/pkg/xerr"
  14. "gorm.io/gorm"
  15. )
  16. func (s *StoreEntry) CalvingList(ctx context.Context, req *pasturePb.SearchEventRequest, pagination *pasturePb.PaginationModel) (*pasturePb.SearchLavingEventResponse, error) {
  17. userModel, err := s.GetUserModel(ctx)
  18. if err != nil {
  19. return nil, xerr.WithStack(err)
  20. }
  21. lavingList := make([]*model.EventCalvingList, 0)
  22. var count int64 = 0
  23. pref := s.DB.Table(fmt.Sprintf("%s as a", new(model.EventCalving).TableName())).
  24. Select(`a.*,b.name as pen_name,c.name as staff_member_name`).
  25. Joins(fmt.Sprintf("JOIN %s AS b on a.pen_id = b.id", new(model.Pen).TableName())).
  26. Joins(fmt.Sprintf("JOIN %s AS c on a.operation_id = c.id", new(model.SystemUser).TableName())).
  27. Where("a.pasture_id = ?", userModel.AppPasture.Id).Where("a.status = ?", pasturePb.IsShow_No)
  28. if len(req.CowId) > 0 {
  29. cowIds := strings.Split(req.CowId, ",")
  30. pref.Where("a.cow_id IN ?", cowIds)
  31. }
  32. if err = pref.Order("a.id desc").
  33. Count(&count).Limit(int(pagination.PageSize)).
  34. Offset(int(pagination.PageOffset)).
  35. Find(&lavingList).Error; err != nil {
  36. return nil, xerr.WithStack(err)
  37. }
  38. calvingIds := make([]int64, 0)
  39. for _, v := range lavingList {
  40. calvingIds = append(calvingIds, v.Id)
  41. }
  42. calvingCalfList := make([]*model.CalvingCalf, 0)
  43. if err = s.DB.Model(new(model.CalvingCalf)).
  44. Where("calving_id IN ?", calvingIds).
  45. Find(&calvingCalfList).Error; err != nil {
  46. return nil, xerr.WithStack(err)
  47. }
  48. return &pasturePb.SearchLavingEventResponse{
  49. Code: http.StatusOK,
  50. Msg: "ok",
  51. Data: &pasturePb.SearchLavingData{
  52. List: model.EventCalvingListSlice(lavingList).ToPB(calvingCalfList),
  53. Total: int32(count),
  54. PageSize: pagination.PageSize,
  55. Page: pagination.Page,
  56. },
  57. }, nil
  58. }
  59. func (s *StoreEntry) CalvingCreate(ctx context.Context, req *pasturePb.EventCalving) (err error) {
  60. userModel, err := s.GetUserModel(ctx)
  61. if err != nil {
  62. return xerr.WithStack(err)
  63. }
  64. cow, err := s.GetCowInfoByCowId(ctx, userModel.AppPasture.Id, int64(req.CowId))
  65. if err != nil {
  66. zaplog.Error("CalvingCreate", zap.Any("cow_id", req.CowId), zap.Any("err", err))
  67. return xerr.Custom("请选择相关牛只")
  68. }
  69. operationUser, err := s.GetSystemUserById(ctx, int64(req.OperationId))
  70. if err != nil {
  71. return xerr.Customf("获取操作人员信息失败: %s", err.Error())
  72. }
  73. req.OperationName = operationUser.Name
  74. penMap := s.PenMap(ctx, userModel.AppPasture.Id)
  75. // 记录牛只事件日志
  76. defer func() {
  77. if err == nil {
  78. // 母牛事件日志
  79. cowLogs := s.SubmitEventLog(ctx, userModel.AppPasture.Id, cow, pasturePb.EventType_Calving, pasturePb.ExposeEstrusType_Invalid, req)
  80. s.DB.Table(cowLogs.TableName()).Create(cowLogs)
  81. // 犊牛事件日志
  82. for _, v := range req.CalfItemList {
  83. if v.IsLive == pasturePb.IsShow_No || v.IsAdoption == pasturePb.IsShow_No {
  84. continue
  85. }
  86. cow, _ = s.GetCowInfoByCowId(ctx, userModel.AppPasture.Id, int64(v.CowId))
  87. cowLogs = s.SubmitEventLog(ctx, userModel.AppPasture.Id, cow, pasturePb.EventType_Birth, pasturePb.ExposeEstrusType_Invalid, v)
  88. s.DB.Table(cowLogs.TableName()).Create(cowLogs)
  89. }
  90. }
  91. }()
  92. newEventCalving := &model.EventCalving{}
  93. if err = s.DB.Model(new(model.EventCalving)).
  94. Where("cow_id = ?", cow.Id).
  95. Where("lact = ?", cow.Lact).
  96. First(newEventCalving).Error; err != nil {
  97. return xerr.Custom("该母牛信息不存在")
  98. }
  99. if err = s.DB.Transaction(func(tx *gorm.DB) error {
  100. // 更新产犊事件表
  101. newEventCalving.EventUpdate(operationUser, req, cow)
  102. if err = tx.Model(new(model.EventCalving)).
  103. Select("operation_id", "operation_name", "reality_day", "day_age", "pregnancy_age", "bull_number",
  104. "calving_level", "child_number", "status", "is_inducing_childbirth", "pen_id", "dystocia_reason", "remarks").
  105. Where("id = ?", newEventCalving.Id).
  106. Updates(newEventCalving).Error; err != nil {
  107. return xerr.WithStack(err)
  108. }
  109. for _, v := range req.CalfItemList {
  110. if v.IsLive == pasturePb.IsShow_No || v.IsAdoption == pasturePb.IsShow_No {
  111. continue
  112. }
  113. // 犊牛信息
  114. newCalvingCalf := model.NewEventCalvingCalf(userModel.AppPasture.Id, int64(req.CowId), newEventCalving.Id, int64(req.CalvingAt), penMap, v)
  115. // 留养犊牛
  116. newCow := model.NewCalfCow(cow.Id, cow.LastBullNumber, newCalvingCalf)
  117. if err = tx.Create(newCow).Error; err != nil {
  118. return xerr.WithStack(err)
  119. }
  120. v.CowId = int32(newCow.Id)
  121. if err = tx.Create(newCalvingCalf).Error; err != nil {
  122. return xerr.WithStack(err)
  123. }
  124. }
  125. // 更新母牛信息
  126. cow.EventCalvingUpdate(int64(req.CalvingAt))
  127. if err = tx.Model(cow).
  128. Select("calving_age", "mating_times", "pregnancy_age", "lact", "breed_status", "is_pregnant", "last_calving_at").
  129. Where("id = ?", cow.Id).
  130. Updates(cow).Error; err != nil {
  131. return xerr.WithStack(err)
  132. }
  133. return nil
  134. }); err != nil {
  135. return xerr.WithStack(err)
  136. }
  137. return nil
  138. }
  139. func (s *StoreEntry) SameTimeCreate(ctx context.Context, req *pasturePb.EventSameTime) (err error) {
  140. userModel, err := s.GetUserModel(ctx)
  141. if err != nil {
  142. return xerr.WithStack(err)
  143. }
  144. operationUser, err := s.GetSystemUserById(ctx, int64(req.OperationId))
  145. if err != nil {
  146. return xerr.WithStack(err)
  147. }
  148. eventCowSameTime, err := s.GetEventCowSameTimeByCowId(ctx, userModel.AppPasture.Id, int64(req.CowId))
  149. if err != nil {
  150. zaplog.Error("SameTimeCreate", zap.Any("err", err), zap.Any("req", req))
  151. return xerr.Customf("异常数据")
  152. }
  153. drugs := &model.Drugs{}
  154. if drugs, err = s.GetDrugsById(ctx, userModel.AppPasture.Id, int64(req.DrugsId)); err != nil {
  155. zaplog.Error("SameTimeCreate", zap.Any("err", err), zap.Any("req", req))
  156. return xerr.Customf("该药品不存在: %d", req.DrugsId)
  157. }
  158. req.DrugsName = drugs.Name
  159. eventCowSameTime.EventUpdate(drugs, req.Usage, req.Remarks, operationUser, userModel.SystemUser)
  160. defer func() {
  161. if err == nil {
  162. // 记录牛只事件日志
  163. cow, _ := s.GetCowInfoByCowId(ctx, userModel.AppPasture.Id, eventCowSameTime.CowId)
  164. cowLogs := s.SubmitEventLog(ctx, userModel.AppPasture.Id, cow, pasturePb.EventType_Seme_Time, pasturePb.ExposeEstrusType_Same_Time, req)
  165. s.DB.Table(cowLogs.TableName()).Create(cowLogs)
  166. }
  167. }()
  168. if err = s.DB.Model(new(model.EventCowSameTime)).
  169. Select("status", "drugs_id", "unit", "usage", "remarks", "operation_id", "operation_name").
  170. Where("id = ?", eventCowSameTime.Id).
  171. Updates(eventCowSameTime).Error; err != nil {
  172. return xerr.WithStack(err)
  173. }
  174. return nil
  175. }
  176. func (s *StoreEntry) SameTimeBatch(ctx context.Context, req *pasturePb.EventSameTimeBatch) (err error) {
  177. userModel, err := s.GetUserModel(ctx)
  178. if err != nil {
  179. return xerr.WithStack(err)
  180. }
  181. operationUser, err := s.GetSystemUserById(ctx, int64(req.OperationId))
  182. if err != nil {
  183. return xerr.Customf("异常数据")
  184. }
  185. req.OperationName = operationUser.Name
  186. drugs := &model.Drugs{}
  187. if drugs, err = s.GetDrugsById(ctx, userModel.AppPasture.Id, int64(req.DrugsId)); err != nil {
  188. zaplog.Error("SameTimeBatch", zap.Any("err", err), zap.Any("req", req))
  189. return xerr.Customf("该药物不存在: %d", req.DrugsId)
  190. }
  191. req.DrugsName = drugs.Name
  192. eventCowSameTimeList := make([]*model.EventCowSameTime, 0)
  193. for _, v := range req.CowIds {
  194. eventCowSameTime, err := s.GetEventCowSameTimeByCowId(ctx, userModel.AppPasture.Id, int64(v))
  195. if err != nil {
  196. zaplog.Error("SameTimeCreate", zap.Any("err", err), zap.Any("req", req))
  197. return xerr.WithStack(err)
  198. }
  199. eventCowSameTimeList = append(eventCowSameTimeList, eventCowSameTime)
  200. }
  201. defer func() {
  202. // 记录牛只事件日志
  203. if err == nil {
  204. for _, v := range eventCowSameTimeList {
  205. cow, _ := s.GetCowInfoByCowId(ctx, userModel.AppPasture.Id, v.CowId)
  206. cowLogs := s.SubmitEventLog(
  207. ctx,
  208. userModel.AppPasture.Id,
  209. cow,
  210. pasturePb.EventType_Seme_Time,
  211. pasturePb.ExposeEstrusType_Same_Time,
  212. &pasturePb.EventSameTime{
  213. Id: int32(v.Id),
  214. CowId: int32(v.CowId),
  215. SameTimeId: int32(v.SameTimeId),
  216. SameTimeType: v.SameTimeType,
  217. SameTimeTypeName: v.SameTimeName,
  218. DrugsId: int32(v.DrugsId),
  219. DrugsName: drugs.Name,
  220. Usage: req.Usage,
  221. OperationId: int32(operationUser.Id),
  222. OperationName: operationUser.Name,
  223. SameTimeAt: req.SameTimeAt,
  224. })
  225. s.DB.Table(cowLogs.TableName()).Create(cowLogs)
  226. }
  227. }
  228. }()
  229. if err = s.DB.Transaction(func(tx *gorm.DB) error {
  230. for _, v := range eventCowSameTimeList {
  231. // 更新SameTime
  232. v.EventUpdate(drugs, req.Usage, req.Remarks, userModel.SystemUser, operationUser)
  233. if err = tx.Model(new(model.EventCowSameTime)).
  234. Select("status", "drugs_id", "unit", "usage", "remarks", "operation_id", "operation_name").
  235. Where("id = ?", v.Id).
  236. Updates(v).Error; err != nil {
  237. return xerr.WithStack(err)
  238. }
  239. }
  240. return nil
  241. }); err != nil {
  242. return xerr.WithStack(err)
  243. }
  244. return nil
  245. }
  246. func (s *StoreEntry) SameTimeList(
  247. ctx context.Context,
  248. req *pasturePb.SearchEventRequest,
  249. pagination *pasturePb.PaginationModel,
  250. ) (*pasturePb.SearchSameTimeResponse, error) {
  251. userModel, err := s.GetUserModel(ctx)
  252. if err != nil {
  253. return nil, xerr.WithStack(err)
  254. }
  255. cowSameTimeList := make([]*model.EventCowSameTime, 0)
  256. var count int64 = 0
  257. pref := s.DB.Table(new(model.EventCowSameTime).TableName()).Where("pasture_id = ?", userModel.AppPasture.Id)
  258. if req.CowId != "" {
  259. cowIds := strings.Split(req.CowId, ",")
  260. pref.Where("cow_id IN ?", cowIds)
  261. }
  262. if err = pref.Count(&count).
  263. Limit(int(pagination.PageSize)).
  264. Offset(int(pagination.PageOffset)).
  265. Find(&cowSameTimeList).Error; err != nil {
  266. return nil, xerr.WithStack(err)
  267. }
  268. sameTimeTypeMap := s.SameTimeTypeMap()
  269. return &pasturePb.SearchSameTimeResponse{
  270. Code: http.StatusOK,
  271. Msg: "ok",
  272. Data: &pasturePb.SameTimeData{
  273. List: model.EventCowSameTimeSlice(cowSameTimeList).ToPB(sameTimeTypeMap),
  274. Total: int32(count),
  275. PageSize: pagination.PageSize,
  276. Page: pagination.Page,
  277. },
  278. }, nil
  279. }
  280. func (s *StoreEntry) EstrusList(ctx context.Context, req *pasturePb.EstrusItemsRequest, pagination *pasturePb.PaginationModel) (*pasturePb.EventEstrusResponse, error) {
  281. userModel, err := s.GetUserModel(ctx)
  282. if err != nil {
  283. return nil, xerr.WithStack(err)
  284. }
  285. estrusList := make([]*model.NeckRingEstrus, 0)
  286. var count int64 = 0
  287. pref := s.DB.Table(new(model.NeckRingEstrus).TableName()).
  288. Where("is_show = ?", pasturePb.IsShow_Ok).
  289. Where("pasture_id = ?", userModel.AppPasture.Id).
  290. Where("expose_estrus_type = ?", pasturePb.ExposeEstrusType_Natural_Estrus)
  291. if len(req.CowIds) > 0 {
  292. cowIds := strings.Split(util.ArrayInt32ToStrings(req.CowIds, ","), ",")
  293. pref.Where("cow_id IN ?", cowIds)
  294. }
  295. if req.Level > 0 {
  296. pref.Where("level = ?", req.Level)
  297. }
  298. if len(req.PenIds) > 0 {
  299. penIds := strings.Split(util.ArrayInt32ToStrings(req.PenIds, ","), ",")
  300. pref.Where("pen_id IN ?", penIds)
  301. }
  302. if err = pref.Order("id desc").
  303. Count(&count).Limit(int(pagination.PageSize)).
  304. Offset(int(pagination.PageOffset)).
  305. Find(&estrusList).Error; err != nil {
  306. return nil, xerr.WithStack(err)
  307. }
  308. getCowInfoByCowId := GetCowInfoByCowId
  309. getCowLastEvent := GetCowLastEvent
  310. return &pasturePb.EventEstrusResponse{
  311. Code: http.StatusOK,
  312. Msg: "ok",
  313. Data: &pasturePb.EstrusItemsData{
  314. List: model.NeckRingEstrusSlice(estrusList).ToPB(s.DB, getCowInfoByCowId, getCowLastEvent),
  315. Total: int32(count),
  316. PageSize: pagination.PageSize,
  317. Page: pagination.Page,
  318. },
  319. }, nil
  320. }
  321. func (s *StoreEntry) EstrusBatchMating(ctx context.Context, req *pasturePb.EventNaturalEstrusBatch) (err error) {
  322. userModel, err := s.GetUserModel(ctx)
  323. if err != nil {
  324. return xerr.WithStack(err)
  325. }
  326. eventEstrusList := make([]*model.EventEstrus, 0)
  327. eventMatingList := make([]*model.EventMating, 0)
  328. unMatingReasonsMap := s.UnMatingReasonsMap()
  329. for _, item := range req.Items {
  330. cowInfo, err := s.GetCowInfoByCowId(ctx, userModel.AppPasture.Id, int64(item.CowId))
  331. if err != nil {
  332. return xerr.Custom("牛只信息不存在")
  333. }
  334. if cowInfo.Sex != pasturePb.Genders_Female {
  335. return xerr.Custom("该牛只不是母牛")
  336. }
  337. existsEventEstrus, isExists, err := s.FindEventEstrusByCowId(ctx, userModel.AppPasture.Id, int64(item.CowId))
  338. if err != nil {
  339. return xerr.WithStack(err)
  340. }
  341. // 如果存在,并且是脖环揭发则跳过
  342. if isExists {
  343. if existsEventEstrus.ExposeEstrusType == pasturePb.ExposeEstrusType_Neck_Ring {
  344. zaplog.Info("EventNaturalEstrusBatch", zap.Any("existsEventEstrus", existsEventEstrus), zap.Any("item", item))
  345. continue
  346. }
  347. realityDay := time.Unix(existsEventEstrus.RealityDay, 0).Format(model.LayoutDate2)
  348. planDay := time.Unix(int64(item.EstrusAt), 0).Format(model.LayoutDate2)
  349. if realityDay == planDay {
  350. return xerr.Customf("该牛只:%d,今天已经提交过发情数据", item.CowId)
  351. }
  352. }
  353. operationUser, _ := s.GetSystemUserById(ctx, userModel.SystemUser.Id)
  354. item.OperationName = operationUser.Name
  355. newEventEstrus := model.NewEventEstrus(
  356. userModel.AppPasture.Id,
  357. cowInfo,
  358. pasturePb.ExposeEstrusType_Natural_Estrus,
  359. pasturePb.IsShow_Ok,
  360. item.IsMating,
  361. item.EstrusAt,
  362. operationUser,
  363. userModel.SystemUser,
  364. )
  365. if item.IsMating == pasturePb.IsShow_Ok {
  366. newEventMating := model.NewEventMating(userModel.AppPasture.Id, cowInfo, time.Now().Unix(), pasturePb.ExposeEstrusType_Natural_Estrus)
  367. eventMatingList = append(eventMatingList, newEventMating)
  368. } else {
  369. newEventEstrus.UnMatingReasonsKind = item.UnMatingReasonsKind
  370. newEventEstrus.UnMatingReasonsName = unMatingReasonsMap[item.UnMatingReasonsKind]
  371. }
  372. newEventEstrus.Remarks = item.Remarks
  373. eventEstrusList = append(eventEstrusList, newEventEstrus)
  374. }
  375. // 记录事件日志
  376. defer func() {
  377. if err == nil && len(eventEstrusList) > 0 {
  378. for _, v := range eventEstrusList {
  379. cow, _ := s.GetCowInfoByCowId(ctx, userModel.AppPasture.Id, v.CowId)
  380. cowLogs := s.SubmitEventLog(ctx, userModel.AppPasture.Id, cow, pasturePb.EventType_Estrus, v.ExposeEstrusType, v)
  381. s.DB.Table(cowLogs.TableName()).Create(cowLogs)
  382. }
  383. }
  384. }()
  385. if err = s.DB.Transaction(func(tx *gorm.DB) error {
  386. if len(eventMatingList) > 0 {
  387. if err = tx.Model(new(model.EventMating)).Create(eventMatingList).Error; err != nil {
  388. return xerr.WithStack(err)
  389. }
  390. }
  391. if len(eventEstrusList) > 0 {
  392. if err = tx.Model(new(model.EventEstrus)).Create(eventEstrusList).Error; err != nil {
  393. return xerr.WithStack(err)
  394. }
  395. }
  396. return nil
  397. }); err != nil {
  398. return xerr.WithStack(err)
  399. }
  400. return nil
  401. }
  402. func (s *StoreEntry) MatingList(ctx context.Context, req *pasturePb.SearchEventRequest, pagination *pasturePb.PaginationModel) (*pasturePb.EventMatingResponse, error) {
  403. userModel, err := s.GetUserModel(ctx)
  404. if err != nil {
  405. return nil, xerr.WithStack(err)
  406. }
  407. matingList := make([]*model.EventMating, 0)
  408. var count int64 = 0
  409. pref := s.DB.Model(new(model.EventMating)).
  410. Where("mating_result > ?", pasturePb.MatingResult_Invalid).
  411. Where("status = ?", pasturePb.IsShow_Ok).
  412. Where("pasture_id = ?", userModel.AppPasture.Id)
  413. if len(req.CowId) > 0 {
  414. cowIds := strings.Split(req.CowId, ",")
  415. pref.Where("cow_id IN ?", cowIds)
  416. }
  417. if err = pref.Order("id desc").
  418. Count(&count).Limit(int(pagination.PageSize)).
  419. Offset(int(pagination.PageOffset)).
  420. Find(&matingList).Error; err != nil {
  421. return nil, xerr.WithStack(err)
  422. }
  423. exposeEstrusTypeMap := s.ExposeEstrusTypeMap()
  424. return &pasturePb.EventMatingResponse{
  425. Code: http.StatusOK,
  426. Msg: "ok",
  427. Data: &pasturePb.SearchMatingData{
  428. List: model.EventMatingSlice(matingList).ToPB(exposeEstrusTypeMap),
  429. Total: int32(count),
  430. PageSize: pagination.PageSize,
  431. Page: pagination.Page,
  432. },
  433. }, nil
  434. }
  435. // MatingCreate 牛只配种
  436. func (s *StoreEntry) MatingCreate(ctx context.Context, req *pasturePb.EventMating) (err error) {
  437. eventCheckModel, err := s.MatingCreateCheck(ctx, req)
  438. if err != nil {
  439. return xerr.WithStack(err)
  440. }
  441. req.OperationName = eventCheckModel.OperationUser.Name
  442. if err = s.DB.Transaction(func(tx *gorm.DB) error {
  443. for _, cow := range eventCheckModel.CowList {
  444. // 获取牛只最近一次配种信息
  445. lastEventMating, ok, err := s.FindLastEventMatingByCowId(ctx, eventCheckModel.UserModel.AppPasture.Id, cow.Id)
  446. if err != nil {
  447. return xerr.WithStack(err)
  448. }
  449. // 1. 没有配种信息,(第一次参加配种的牛只,并且没有参与同期的牛只 )
  450. if !ok {
  451. newMating := model.NewEventMatingNaturalEstrus(eventCheckModel.UserModel.AppPasture.Id, cow, req, eventCheckModel.UserModel.SystemUser)
  452. if err = tx.Create(newMating).Error; err != nil {
  453. return xerr.WithStack(err)
  454. }
  455. if err = s.MatingCowUpdate(ctx, eventCheckModel.UserModel.AppPasture.Id, cow, req, false); err != nil {
  456. return xerr.WithStack(err)
  457. }
  458. continue
  459. }
  460. // 2. 所有有配种数据的牛只
  461. if lastEventMating == nil || lastEventMating.Id <= 0 {
  462. zaplog.Error("MatingCreate", zap.Any("cow", cow), zap.Any("UserModel", eventCheckModel.UserModel))
  463. return xerr.Customf("异常牛数据: %d", cow.Id)
  464. }
  465. // 2.1 复配 => 本胎次配次不加1
  466. isReMating := lastEventMating.IsReMating(cow, int64(req.MatingAt))
  467. if isReMating {
  468. lastEventMating.EventReMatingUpdate(int64(req.MatingAt))
  469. if err = tx.Model(lastEventMating).
  470. Select("mating_result", "mating_result_at", "status").
  471. Where("id = ?", lastEventMating.Id).
  472. Updates(lastEventMating).Error; err != nil {
  473. }
  474. }
  475. // 2.2. 同期初配
  476. IsMatingUpdate := lastEventMating.IsMatingUpdate()
  477. if IsMatingUpdate {
  478. lastEventMating.EventUpdate(int64(req.MatingAt), req.FrozenSemenNumber, isReMating, eventCheckModel.OperationUser, eventCheckModel.UserModel.SystemUser)
  479. if err = tx.Model(lastEventMating).
  480. Select("mating_at", "status", "reality_day", "frozen_semen_number", "operation_id", "operation_name", "message_id", "message_name").
  481. Where("id = ?", lastEventMating.Id).
  482. Updates(lastEventMating).Error; err != nil {
  483. return xerr.WithStack(err)
  484. }
  485. }
  486. // 2.3. 提交的配种数据中,定位出空怀的牛只,
  487. isEmptyMating := lastEventMating.IsEmptyMating(cow, int64(req.MatingAt))
  488. if isEmptyMating {
  489. // 把上次配种结果信息更新成空怀
  490. lastEventMating.EventMatingResultUpdate(pasturePb.MatingResult_Empty, int64(req.MatingAt))
  491. if err = tx.Model(lastEventMating).
  492. Select("mating_result", "mating_result_at").
  493. Where("id = ?", lastEventMating.Id).
  494. Updates(lastEventMating).Error; err != nil {
  495. return xerr.WithStack(err)
  496. }
  497. // 先创建一条新的配种数据
  498. newMating := model.NewEventMating(eventCheckModel.UserModel.AppPasture.Id, cow, int64(req.MatingAt), req.ExposeEstrusType)
  499. newMating.EventUpdate(int64(req.MatingAt), req.FrozenSemenNumber, isReMating, eventCheckModel.OperationUser, eventCheckModel.UserModel.SystemUser)
  500. if err = tx.Model(newMating).Create(newMating).Error; err != nil {
  501. return xerr.WithStack(err)
  502. }
  503. // 更新牛只配种结果日志
  504. if err = s.UpdateMatingResultEventCowLogByCowId(ctx, cow.Id, s.MatingResultMap()[pasturePb.MatingResult_Empty]); err != nil {
  505. zaplog.Error("MatingCreate", zap.Any("UpdateEventCowLogByCowId", err), zap.Any("cow", cow))
  506. }
  507. }
  508. // 牛只基本中配种信息更新
  509. if err = s.MatingCowUpdate(ctx, eventCheckModel.UserModel.AppPasture.Id, cow, req, isReMating); err != nil {
  510. return xerr.WithStack(err)
  511. }
  512. }
  513. // 创建冻精使用记录日志
  514. itemFrozenSemenLog := model.NewEventFrozenSemenLog(eventCheckModel.FrozenSemen.PastureId, req)
  515. if err = tx.Create(itemFrozenSemenLog).Error; err != nil {
  516. return xerr.WithStack(err)
  517. }
  518. // 减去精液的数量
  519. eventCheckModel.FrozenSemen.EventQuantityUpdate(req.FrozenSemenCount)
  520. if err = tx.Model(eventCheckModel.FrozenSemen).
  521. Select("quantity").
  522. Where("id = ?", eventCheckModel.FrozenSemen.Id).
  523. Updates(eventCheckModel.FrozenSemen).Error; err != nil {
  524. return xerr.WithStack(err)
  525. }
  526. return nil
  527. }); err != nil {
  528. return xerr.WithStack(err)
  529. }
  530. return nil
  531. }
  532. func (s *StoreEntry) MatingCowUpdate(ctx context.Context, pastureId int64, cow *model.Cow, req *pasturePb.EventMating, isReMating bool) error {
  533. // 牛只基本中配种信息更新
  534. cow.EventMatingUpdate(int64(req.MatingAt), req.FrozenSemenNumber, isReMating)
  535. if err := s.DB.Model(cow).
  536. Select("last_mating_at", "mating_times", "last_bull_number", "first_mating_at", "is_pregnant", "breed_status").
  537. Where("id = ?", cow.Id).
  538. Updates(cow).Error; err != nil {
  539. return xerr.WithStack(err)
  540. }
  541. // 记录日志
  542. cowLogs := s.SubmitEventLog(ctx, pastureId, cow, pasturePb.EventType_Mating, req.ExposeEstrusType, req)
  543. if err := s.DB.Table(cowLogs.TableName()).Create(cowLogs).Error; err != nil {
  544. return xerr.WithStack(err)
  545. }
  546. return nil
  547. }
  548. func (s *StoreEntry) WeaningBatch(ctx context.Context, req *pasturePb.EventWeaningBatchRequest) (err error) {
  549. userModel, err := s.GetUserModel(ctx)
  550. if err != nil {
  551. return xerr.WithStack(err)
  552. }
  553. if len(req.Item) <= 0 {
  554. return nil
  555. }
  556. cowIds := make([]int64, 0)
  557. cowWeightMap := make(map[int64]float64)
  558. for _, item := range req.Item {
  559. cowIds = append(cowIds, int64(item.CowId))
  560. cowWeightMap[int64(item.CowId)] = float64(item.Weight)
  561. }
  562. eventWeaningList := make([]*model.EventWeaning, 0)
  563. if err = s.DB.Model(new(model.EventWeaning)).
  564. Where("cow_id IN ?", cowIds).
  565. Where("status = ?", pasturePb.IsShow_No).
  566. Find(&eventWeaningList).Error; err != nil {
  567. return xerr.WithStack(err)
  568. }
  569. operation, err := s.GetSystemUserById(ctx, int64(req.OperationId))
  570. if err != nil {
  571. return xerr.WithStack(err)
  572. }
  573. defer func() {
  574. if err != nil {
  575. for _, cowId := range cowIds {
  576. cow, _ := s.GetCowInfoByCowId(ctx, userModel.AppPasture.Id, cowId)
  577. cowLogs := s.SubmitEventLog(ctx, userModel.AppPasture.Id, cow, pasturePb.EventType_Weaning, pasturePb.ExposeEstrusType_Invalid, req)
  578. s.DB.Table(cowLogs.TableName()).Create(cowLogs)
  579. }
  580. }
  581. }()
  582. if err = s.DB.Transaction(func(tx *gorm.DB) error {
  583. cowInfo := &model.Cow{}
  584. for _, v := range eventWeaningList {
  585. v.EventUpdate(int64(req.WeaningAt), req.Remarks, req.PenId, operation, userModel.SystemUser)
  586. if err = tx.Model(new(model.EventWeaning)).
  587. Select("status", "reality_day", "operation_id", "operation_name", "message_id", "message_name", "remarks", "after_pen_id").
  588. Where("id = ?", v.Id).
  589. Updates(v).Error; err != nil {
  590. return xerr.WithStack(err)
  591. }
  592. cowInfo, err = s.GetCowInfoByCowId(ctx, userModel.AppPasture.Id, v.CowId)
  593. if err != nil {
  594. return xerr.WithStack(err)
  595. }
  596. cowInfo.EventWeaningUpdate(int64(req.WeaningAt), req.PenId, int64(cowWeightMap[cowInfo.Id]*1000))
  597. if err = tx.Model(new(model.Cow)).
  598. Select("pen_id", "current_weight", "weaning_at", "last_weight_at").
  599. Where("id = ?", v.CowId).
  600. Updates(cowInfo).Error; err != nil {
  601. return xerr.WithStack(err)
  602. }
  603. // 创建牛只的体重记录
  604. newEventWeight := model.NewEventWeight(
  605. userModel.AppPasture.Id,
  606. cowInfo,
  607. userModel.SystemUser,
  608. &pasturePb.EventWeight{
  609. WeightAt: req.WeaningAt,
  610. OperationId: req.OperationId,
  611. OperationName: req.OperationName,
  612. Remarks: req.Remarks,
  613. Weight: float32(cowWeightMap[cowInfo.Id]),
  614. Height: 0,
  615. })
  616. if err = tx.Create(newEventWeight).Error; err != nil {
  617. return xerr.WithStack(err)
  618. }
  619. }
  620. return nil
  621. }); err != nil {
  622. return xerr.WithStack(err)
  623. }
  624. return nil
  625. }