event.go 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613
  1. package backend
  2. import (
  3. "context"
  4. "fmt"
  5. "kpt-pasture/model"
  6. "net/http"
  7. "strconv"
  8. "strings"
  9. pasturePb "gitee.com/xuyiping_admin/go_proto/proto/go/backend/cow"
  10. "gitee.com/xuyiping_admin/pkg/xerr"
  11. "gorm.io/gorm"
  12. )
  13. func (s *StoreEntry) EventTemplate(ctx context.Context, req *pasturePb.SearchEventRequest) {
  14. }
  15. func (s *StoreEntry) CreateEventTemplate(ctx context.Context, req *pasturePb.SearchEventRequest) *pasturePb.EventData {
  16. return nil
  17. }
  18. func (s *StoreEntry) EnterList(ctx context.Context, req *pasturePb.SearchEventRequest, pagination *pasturePb.PaginationModel) (*pasturePb.SearchEnterEventResponse, error) {
  19. eventEnterList := make([]*pasturePb.SearchEnterData, 0)
  20. var count int64 = 0
  21. pref := s.DB.Table(fmt.Sprintf("%s as a", new(model.EventEnter).TableName())).
  22. Select(`a.id,a.birth_at,a.weaning_at,a.dry_milk_at,a.cow_source_id,a.remarks,a.mating_at,a.lact,
  23. a.breed_status,a.mother_id,a.cow_kind,a.cow_id,a.ear_number,a.sex,a.created_at,a.updated_at,a.enter_at,
  24. a.weight / 100 as weight,a.price / 100 as price,b.name as breed_status_name,c.name as cow_source_name,d.name as cow_type_name,
  25. e.name as cow_kind_name,f.name as pen_name,g.name as operation_name,h.name as staff_member_name`).
  26. Joins(fmt.Sprintf("JOIN %s AS b ON a.breed_status = b.id", new(model.ConfigBreedStatus).TableName())).
  27. Joins(fmt.Sprintf("JOIN %s AS c on a.cow_source_id = c.id", new(model.ConfigCowSource).TableName())).
  28. Joins(fmt.Sprintf("JOIN %s AS d on a.cow_type = d.id", new(model.ConfigCowType).TableName())).
  29. Joins(fmt.Sprintf("JOIN %s AS e ON a.cow_kind = e.id", new(model.ConfigCowKind).TableName())).
  30. Joins(fmt.Sprintf("JOIN %s AS f on a.pen_id = f.id", new(model.Pen).TableName())).
  31. Joins(fmt.Sprintf("JOIN %s AS g on a.operation_id = g.id", new(model.SystemUser).TableName())).
  32. Joins(fmt.Sprintf("JOIN %s AS h on a.staff_member_id = h.id", new(model.SystemUser).TableName()))
  33. if len(req.CowId) > 0 {
  34. cowIds := strings.Split(req.CowId, ",")
  35. pref.Where("a.cow_id IN ?", cowIds)
  36. }
  37. if err := pref.Order("a.id desc").
  38. Count(&count).Limit(int(pagination.PageSize)).
  39. Offset(int(pagination.PageOffset)).
  40. Find(&eventEnterList).Error; err != nil {
  41. return nil, xerr.WithStack(err)
  42. }
  43. return &pasturePb.SearchEnterEventResponse{
  44. Code: http.StatusOK,
  45. Message: "ok",
  46. Data: &pasturePb.SearchEnterEventData{
  47. List: eventEnterList,
  48. Total: int32(count),
  49. PageSize: pagination.PageSize,
  50. Page: pagination.Page,
  51. },
  52. }, nil
  53. }
  54. func (s *StoreEntry) CreateEnter(ctx context.Context, req *pasturePb.SearchEnterData) error {
  55. if err := s.DB.Transaction(func(tx *gorm.DB) error {
  56. newCowData := model.NewCow(req)
  57. if err := tx.Create(newCowData).Error; err != nil {
  58. return xerr.WithStack(err)
  59. }
  60. operationUser, _ := s.GetCurrentSystemUser(ctx)
  61. if err := tx.Create(model.NewEventEnter(newCowData.Id, operationUser.Id, req)).Error; err != nil {
  62. return xerr.WithStack(err)
  63. }
  64. return nil
  65. }); err != nil {
  66. return xerr.WithStack(err)
  67. }
  68. return nil
  69. }
  70. func (s *StoreEntry) GroupTransferList(ctx context.Context, req *pasturePb.SearchEventRequest, pagination *pasturePb.PaginationModel) (*pasturePb.SearchTransferGroupEventResponse, error) {
  71. eventGroupTransferList := make([]*pasturePb.SearchTransferGroupData, 0)
  72. var count int64 = 0
  73. pref := s.DB.Table(fmt.Sprintf("%s as a", new(model.EventTransferGroup).TableName())).
  74. Select(`a.id,a.cow_id,a.transfer_in_pen_id,a.transfer_out_pen_id,a.lact,a.remarks,a.transfer_reason_id,
  75. a.transfer_date,a.created_at,a.staff_member_id,b.name as transfer_in_pen_name,c.name as transfer_out_pen_name,
  76. d.name as transfer_reason_name,e.name as staff_member_name,f.lact,f.ear_number`).
  77. Joins(fmt.Sprintf("JOIN %s AS b ON a.transfer_in_pen_id = b.id", new(model.Pen).TableName())).
  78. Joins(fmt.Sprintf("JOIN %s AS c on a.transfer_out_pen_id = c.id", new(model.Pen).TableName())).
  79. Joins(fmt.Sprintf("JOIN %s AS d on a.transfer_reason_id = d.id", new(model.ConfigTransferPenReason).TableName())).
  80. Joins(fmt.Sprintf("JOIN %s AS e ON a.staff_member_id = e.id", new(model.SystemUser).TableName())).
  81. Joins(fmt.Sprintf("JOIN %s AS f ON a.cow_id = f.id", new(model.Cow).TableName()))
  82. if len(req.CowId) > 0 {
  83. cowIds := strings.Split(req.CowId, ",")
  84. pref.Where("a.cow_id IN ?", cowIds)
  85. }
  86. if err := pref.Order("a.id desc").Group("a.id").
  87. Count(&count).Limit(int(pagination.PageSize)).
  88. Offset(int(pagination.PageOffset)).
  89. Find(&eventGroupTransferList).Error; err != nil {
  90. return nil, xerr.WithStack(err)
  91. }
  92. return &pasturePb.SearchTransferGroupEventResponse{
  93. Code: http.StatusOK,
  94. Message: "ok",
  95. Data: &pasturePb.SearchTransferGroupEventData{
  96. List: eventGroupTransferList,
  97. Total: int32(count),
  98. PageSize: pagination.PageSize,
  99. Page: pagination.Page,
  100. },
  101. }, nil
  102. }
  103. func (s *StoreEntry) CreateGroupTransfer(ctx context.Context, req *pasturePb.TransferGroupEventRequest) error {
  104. system, _ := s.GetCurrentSystemUser(ctx)
  105. res := make([]*model.EventTransferGroup, 0)
  106. for _, v := range req.Body {
  107. cow, err := s.GetCowInfo(ctx, int64(v.CowId))
  108. if err != nil {
  109. return xerr.WithStack(err)
  110. }
  111. // 转去栏舍和当前栏舍相同,则不处理
  112. if cow.PenId == int64(v.TransferInPenId) {
  113. continue
  114. }
  115. pen, err := s.GetPenInfo(ctx, int64(v.TransferInPenId))
  116. if err != nil {
  117. return xerr.WithStack(err)
  118. }
  119. transferReasonData, err := s.GetTransferReasonInfo(ctx, int64(v.TransferReasonId))
  120. if err != nil {
  121. return xerr.WithStack(err)
  122. }
  123. staffMemberData, err := s.GetSystemUserInfo(ctx, int64(v.StaffMemberId))
  124. if err != nil {
  125. return xerr.WithStack(err)
  126. }
  127. res = append(res, &model.EventTransferGroup{
  128. CowId: int64(v.CowId),
  129. TransferInPenId: int64(v.TransferInPenId),
  130. TransferOutPenId: pen.Id,
  131. Lact: cow.Lact,
  132. DayAge: cow.GetDayAge(),
  133. TransferDate: v.TransferDate,
  134. TransferReasonId: transferReasonData.Id,
  135. Remarks: v.Remarks,
  136. StaffMemberId: staffMemberData.Id,
  137. OperationId: system.Id,
  138. })
  139. }
  140. if len(res) <= 0 {
  141. return nil
  142. }
  143. if err := s.DB.Transaction(func(tx *gorm.DB) error {
  144. if err := tx.Create(res).Error; err != nil {
  145. return xerr.WithStack(err)
  146. }
  147. for _, v := range res {
  148. cow, err := s.GetCowInfo(ctx, v.CowId)
  149. if err != nil {
  150. return xerr.WithStack(err)
  151. }
  152. if err = s.DB.Model(cow).Update("pen_id", v.TransferInPenId).Error; err != nil {
  153. return xerr.WithStack(err)
  154. }
  155. }
  156. return nil
  157. }); err != nil {
  158. return xerr.WithStack(err)
  159. }
  160. return nil
  161. }
  162. func (s *StoreEntry) BodyScoreList(ctx context.Context, req *pasturePb.SearchEventRequest, pagination *pasturePb.PaginationModel) (*pasturePb.SearchBodyScoreEventResponse, error) {
  163. bodyScoreList := make([]*pasturePb.SearchBodyScoreList, 0)
  164. var count int64 = 0
  165. pref := s.DB.Table(fmt.Sprintf("%s as a", new(model.EventBodyScore).TableName())).
  166. Select(`a.id,a.cow_id,a.ear_number,a.score as body_score,a.lact,a.day_age,a.score_at,a.remarks,a.created_at,
  167. a.updated_at,a.staff_member_id,a.operation_id,b.name as staff_member_name,c.name as operation_name`).
  168. Joins(fmt.Sprintf("JOIN %s AS b on a.staff_member_id = b.id", new(model.SystemUser).TableName())).
  169. Joins(fmt.Sprintf("JOIN %s AS c on a.operation_id = c.id", new(model.SystemUser).TableName()))
  170. if len(req.CowId) > 0 {
  171. cowIds := strings.Split(req.CowId, ",")
  172. pref.Where("a.cow_id IN ?", cowIds)
  173. }
  174. if err := pref.Order("a.id desc").
  175. Count(&count).Limit(int(pagination.PageSize)).
  176. Offset(int(pagination.PageOffset)).
  177. Find(&bodyScoreList).Error; err != nil {
  178. return nil, xerr.WithStack(err)
  179. }
  180. return &pasturePb.SearchBodyScoreEventResponse{
  181. Code: http.StatusOK,
  182. Message: "ok",
  183. Data: &pasturePb.SearchBodyScoreData{
  184. List: bodyScoreList,
  185. Total: int32(count),
  186. PageSize: pagination.PageSize,
  187. Page: pagination.Page,
  188. },
  189. }, nil
  190. }
  191. func (s *StoreEntry) CreateBodyScore(ctx context.Context, req *pasturePb.BodyScoreEventRequest) error {
  192. if len(req.CowId) <= 0 {
  193. return xerr.Custom("请选择相关牛只")
  194. }
  195. currentSystemUser, _ := s.GetCurrentSystemUser(ctx)
  196. cowList := strings.Split(req.CowId, ",")
  197. bodyScourEvent := make([]*model.EventBodyScore, 0)
  198. for _, cowIdStr := range cowList {
  199. cowId, _ := strconv.ParseInt(cowIdStr, 10, 64)
  200. cow, err := s.GetCowInfo(ctx, cowId)
  201. if err != nil {
  202. return xerr.WithStack(err)
  203. }
  204. bodyScourEvent = append(bodyScourEvent, model.NewEventBodyScore(cow, currentSystemUser.Id, req))
  205. }
  206. if len(bodyScourEvent) <= 0 {
  207. return nil
  208. }
  209. return s.DB.Create(bodyScourEvent).Error
  210. }
  211. func (s *StoreEntry) CalvingList(ctx context.Context, req *pasturePb.SearchEventRequest, pagination *pasturePb.PaginationModel) (*pasturePb.SearchLavingEventResponse, error) {
  212. lavingList := make([]*model.EventCalvingList, 0)
  213. var count int64 = 0
  214. pref := s.DB.Table(fmt.Sprintf("%s as a", new(model.EventCalving).TableName())).
  215. Select(`a.*,b.name as pen_name,c.name as staff_member_name`).
  216. Joins(fmt.Sprintf("JOIN %s AS b on a.pen_id = b.id", new(model.Pen).TableName())).
  217. Joins(fmt.Sprintf("JOIN %s AS c on a.staff_member_id = c.id", new(model.SystemUser).TableName()))
  218. if len(req.CowId) > 0 {
  219. cowIds := strings.Split(req.CowId, ",")
  220. pref.Where("a.cow_id IN ?", cowIds)
  221. }
  222. if err := pref.Order("a.id desc").
  223. Count(&count).Limit(int(pagination.PageSize)).
  224. Offset(int(pagination.PageOffset)).
  225. Find(&lavingList).Error; err != nil {
  226. return nil, xerr.WithStack(err)
  227. }
  228. calvingIds := make([]int64, 0)
  229. for _, v := range lavingList {
  230. calvingIds = append(calvingIds, v.Id)
  231. }
  232. calvingCalfList := make([]*model.CalvingCalf, 0)
  233. if err := s.DB.Model(new(model.CalvingCalf)).Where("calving_id IN ?", calvingIds).Find(&calvingCalfList).Error; err != nil {
  234. return nil, xerr.WithStack(err)
  235. }
  236. return &pasturePb.SearchLavingEventResponse{
  237. Code: http.StatusOK,
  238. Message: "ok",
  239. Data: &pasturePb.SearchLavingData{
  240. List: model.EventCalvingListSlice(lavingList).ToPB(calvingCalfList),
  241. Total: int32(count),
  242. PageSize: pagination.PageSize,
  243. Page: pagination.Page,
  244. },
  245. }, nil
  246. }
  247. func (s *StoreEntry) CalvingCreate(ctx context.Context, req *pasturePb.CalvingEventRequest) error {
  248. if len(req.CowId) <= 0 {
  249. return xerr.Custom("请选择相关牛只")
  250. }
  251. cowList := strings.Split(req.CowId, ",")
  252. cowId, _ := strconv.ParseInt(cowList[0], 10, 64)
  253. cow, err := s.GetCowInfo(ctx, cowId)
  254. if err != nil {
  255. return xerr.WithStack(err)
  256. }
  257. if err = s.DB.Transaction(func(tx *gorm.DB) error {
  258. // 母牛信息
  259. newCalving := model.NewEventCalving(cow, req)
  260. if err = tx.Create(newCalving).Error; err != nil {
  261. return xerr.WithStack(err)
  262. }
  263. // 犊牛信息
  264. newCalvingCalfList := model.NewEventCalvingCalf(cow.Id, newCalving.Id, req)
  265. for _, v := range newCalvingCalfList {
  266. if v.IsLive == pasturePb.IsShow_No || v.IsAdoption == pasturePb.IsShow_No {
  267. continue
  268. }
  269. // 留养犊牛
  270. newCow := model.NewCalfCow(cow.Id, cow.LastBullId, v)
  271. if err = tx.Create(newCow).Error; err != nil {
  272. return xerr.WithStack(err)
  273. }
  274. v.CowId = newCow.Id
  275. }
  276. if err = tx.Create(newCalvingCalfList).Error; err != nil {
  277. return xerr.WithStack(err)
  278. }
  279. return nil
  280. }); err != nil {
  281. return xerr.WithStack(err)
  282. }
  283. return nil
  284. }
  285. func (s *StoreEntry) PregnantCheckList(ctx context.Context, req *pasturePb.SearchEventRequest, pagination *pasturePb.PaginationModel) (*pasturePb.PregnantCheckEventResponse, error) {
  286. pregnantCheckList := make([]*model.EventPregnantCheck, 0)
  287. var count int64 = 0
  288. pref := s.DB.Table(new(model.EventPregnantCheck).TableName())
  289. if len(req.CowId) > 0 {
  290. cowIds := strings.Split(req.CowId, ",")
  291. pref.Where("cow_id IN ?", cowIds)
  292. }
  293. if err := pref.Order("id desc").
  294. Count(&count).Limit(int(pagination.PageSize)).
  295. Offset(int(pagination.PageOffset)).
  296. Find(&pregnantCheckList).Error; err != nil {
  297. return nil, xerr.WithStack(err)
  298. }
  299. systemUserList, _ := s.SystemUserList(ctx)
  300. pregnantCheckResult := s.PregnantCheckResultEnumList()
  301. pregnantCheckMethod := s.PregnantCheckMethodEnumList()
  302. return &pasturePb.PregnantCheckEventResponse{
  303. Code: http.StatusOK,
  304. Message: "ok",
  305. Data: &pasturePb.SearchPregnantCheckData{
  306. List: model.EventPregnantCheckSlice(pregnantCheckList).ToPB(systemUserList, pregnantCheckResult, pregnantCheckMethod),
  307. Total: int32(count),
  308. PageSize: pagination.PageSize,
  309. Page: pagination.Page,
  310. },
  311. }, nil
  312. }
  313. func (s *StoreEntry) PregnantCheckCreate(ctx context.Context, req *pasturePb.PregnantCheckEventRequest) error {
  314. if len(req.CowId) <= 0 {
  315. return xerr.Custom("请选择相关牛只")
  316. }
  317. cowList := strings.Split(req.CowId, ",")
  318. eventPregnantCheckList := make([]*model.EventPregnantCheck, 0)
  319. currentUser, _ := s.GetCurrentSystemUser(ctx)
  320. for _, v := range cowList {
  321. cowId, _ := strconv.ParseInt(v, 10, 64)
  322. cow, err := s.GetCowInfo(ctx, cowId)
  323. if err != nil {
  324. return xerr.WithStack(err)
  325. }
  326. eventPregnantCheckList = append(eventPregnantCheckList, model.NewEventPregnantCheck(cow, currentUser, req))
  327. }
  328. if err := s.DB.Create(eventPregnantCheckList).Error; err != nil {
  329. return xerr.WithStack(err)
  330. }
  331. return nil
  332. }
  333. func (s *StoreEntry) MatingList(ctx context.Context, req *pasturePb.SearchEventRequest, pagination *pasturePb.PaginationModel) (*pasturePb.MatingEventResponse, error) {
  334. matingList := make([]*model.EventMating, 0)
  335. var count int64 = 0
  336. pref := s.DB.Table(new(model.EventMating).TableName())
  337. if len(req.CowId) > 0 {
  338. cowIds := strings.Split(req.CowId, ",")
  339. pref.Where("cow_id IN ?", cowIds)
  340. }
  341. if err := pref.Order("id desc").
  342. Count(&count).Limit(int(pagination.PageSize)).
  343. Offset(int(pagination.PageOffset)).
  344. Find(&matingList).Error; err != nil {
  345. return nil, xerr.WithStack(err)
  346. }
  347. systemUserList, _ := s.SystemUserList(ctx)
  348. exposeEstrusTypeMap := s.ExposeEstrusTypeMap()
  349. return &pasturePb.MatingEventResponse{
  350. Code: http.StatusOK,
  351. Message: "ok",
  352. Data: &pasturePb.SearchMatingData{
  353. List: model.EventMatingSlice(matingList).ToPB(systemUserList, exposeEstrusTypeMap),
  354. Total: int32(count),
  355. PageSize: pagination.PageSize,
  356. Page: pagination.Page,
  357. },
  358. }, nil
  359. }
  360. func (s *StoreEntry) MatingCreate(ctx context.Context, req *pasturePb.MatingEventRequest) error {
  361. if len(req.CowId) <= 0 {
  362. return xerr.Custom("请选择相关牛只")
  363. }
  364. cowList := strings.Split(req.CowId, ",")
  365. matingList := make([]*model.EventMating, 0)
  366. eventFrozenSemenLogList := make([]*model.EventFrozenSemenLog, 0)
  367. currentUser, _ := s.GetCurrentSystemUser(ctx)
  368. for _, v := range cowList {
  369. cowId, _ := strconv.ParseInt(v, 10, 64)
  370. cow, err := s.GetCowInfo(ctx, cowId)
  371. if err != nil {
  372. return xerr.WithStack(err)
  373. }
  374. matingList = append(matingList, model.NewEventMating(cow, currentUser, req))
  375. eventFrozenSemenLogList = append(eventFrozenSemenLogList, model.NewEventFrozenSemenLog(req.BullId, cow, int64(req.StaffMemberId)))
  376. }
  377. frozenSemen := &model.EventFrozenSemen{}
  378. if err := s.DB.Where("bull_id = ?", req.BullId).First(frozenSemen).Error; err != nil {
  379. return xerr.WithStack(err)
  380. }
  381. if err := s.DB.Transaction(func(tx *gorm.DB) error {
  382. if err := tx.Create(matingList).Error; err != nil {
  383. return xerr.WithStack(err)
  384. }
  385. // 创建冻精使用记录日志
  386. if err := tx.Create(eventFrozenSemenLogList).Error; err != nil {
  387. return xerr.WithStack(err)
  388. }
  389. if err := tx.Table(new(model.EventFrozenSemen).TableName()).
  390. Where("bull_id = ?", req.BullId).
  391. Where("quantity > 0").UpdateColumn("quantity", gorm.Expr("quantity - ?", len(matingList))).Error; err != nil {
  392. return xerr.WithStack(err)
  393. }
  394. return nil
  395. }); err != nil {
  396. return xerr.WithStack(err)
  397. }
  398. return nil
  399. }
  400. func (s *StoreEntry) EstrusList(ctx context.Context, req *pasturePb.SearchEventRequest, pagination *pasturePb.PaginationModel) (*pasturePb.EstrusEventResponse, error) {
  401. estrusList := make([]*model.EventEstrus, 0)
  402. var count int64 = 0
  403. pref := s.DB.Table(new(model.EventEstrus).TableName())
  404. if len(req.CowId) > 0 {
  405. cowIds := strings.Split(req.CowId, ",")
  406. pref.Where("cow_id IN ?", cowIds)
  407. }
  408. if err := pref.Order("id desc").
  409. Count(&count).Limit(int(pagination.PageSize)).
  410. Offset(int(pagination.PageOffset)).
  411. Find(&estrusList).Error; err != nil {
  412. return nil, xerr.WithStack(err)
  413. }
  414. systemUserList, _ := s.SystemUserList(ctx)
  415. return &pasturePb.EstrusEventResponse{
  416. Code: http.StatusOK,
  417. Message: "ok",
  418. Data: &pasturePb.SearchEstrusData{
  419. List: model.EstrusSlice(estrusList).ToPB(systemUserList),
  420. Total: int32(count),
  421. PageSize: pagination.PageSize,
  422. Page: pagination.Page,
  423. },
  424. }, nil
  425. }
  426. func (s *StoreEntry) EstrusCreate(ctx context.Context, req *pasturePb.EstrusEventRequest) error {
  427. if len(req.CowId) <= 0 {
  428. return xerr.Custom("请选择相关牛只")
  429. }
  430. cowList := strings.Split(req.CowId, ",")
  431. estrusList := make([]*model.EventEstrus, 0)
  432. currentUser, _ := s.GetCurrentSystemUser(ctx)
  433. for _, v := range cowList {
  434. cowId, _ := strconv.ParseInt(v, 10, 64)
  435. cow, err := s.GetCowInfo(ctx, cowId)
  436. if err != nil {
  437. return xerr.WithStack(err)
  438. }
  439. estrusList = append(estrusList, model.NewEventEstrus(cow, currentUser, req))
  440. }
  441. if err := s.DB.Create(estrusList).Error; err != nil {
  442. return xerr.WithStack(err)
  443. }
  444. return nil
  445. }
  446. func (s *StoreEntry) FrozenSemenList(ctx context.Context, req *pasturePb.FrozenSemenRequest, pagination *pasturePb.PaginationModel) (*pasturePb.FrozenSemenResponse, error) {
  447. frozenSemenList := make([]*model.EventFrozenSemen, 0)
  448. var count int64 = 0
  449. pref := s.DB.Table(new(model.EventFrozenSemen).TableName())
  450. if req.BullId != "" {
  451. pref.Where("bull_id = ?", req.BullId)
  452. }
  453. if req.Producer != "" {
  454. pref.Where("producer = ?", req.Producer)
  455. }
  456. if err := pref.Order("id desc").
  457. Count(&count).Limit(int(pagination.PageSize)).
  458. Offset(int(pagination.PageOffset)).
  459. Find(&frozenSemenList).Error; err != nil {
  460. return nil, xerr.WithStack(err)
  461. }
  462. frozenSemenTypeMap := s.FrozenSemenTypeMap()
  463. unitMap := s.UnitMap()
  464. return &pasturePb.FrozenSemenResponse{
  465. Code: http.StatusOK,
  466. Message: "ok",
  467. Data: &pasturePb.SearchFrozenSemenData{
  468. List: model.EventFrozenSemenSlice(frozenSemenList).ToPB(frozenSemenTypeMap, unitMap),
  469. Total: int32(count),
  470. PageSize: pagination.PageSize,
  471. Page: pagination.Page,
  472. },
  473. }, nil
  474. }
  475. func (s *StoreEntry) FrozenSemenCreate(ctx context.Context, req *pasturePb.SearchFrozenSemenList) error {
  476. currentUser, _ := s.GetCurrentSystemUser(ctx)
  477. req.CowKindName = s.CowKindMap()[req.CowKind]
  478. newFrozenSemen := model.NewEventFrozenSemen(req, currentUser)
  479. if err := s.DB.Create(newFrozenSemen).Error; err != nil {
  480. return xerr.WithStack(err)
  481. }
  482. return nil
  483. }
  484. func (s *StoreEntry) WeightList(ctx context.Context, req *pasturePb.SearchEventRequest, pagination *pasturePb.PaginationModel) (*pasturePb.SearchWeightEventResponse, error) {
  485. weightList := make([]*pasturePb.SearchWeightList, 0)
  486. var count int64 = 0
  487. pref := s.DB.Table(fmt.Sprintf("%s as a", new(model.EventWeight).TableName())).
  488. Select(`a.id,a.cow_id,a.ear_number,a.weight / 100 as weight,a.lact,a.day_age,a.weight_at,a.remarks,a.created_at,
  489. a.updated_at,a.staff_member_id,a.operation_id,b.name as staff_member_name,c.name as operation_name`).
  490. Joins(fmt.Sprintf("JOIN %s AS b on a.staff_member_id = b.id", new(model.SystemUser).TableName())).
  491. Joins(fmt.Sprintf("JOIN %s AS c on a.operation_id = c.id", new(model.SystemUser).TableName()))
  492. if len(req.CowId) > 0 {
  493. cowIds := strings.Split(req.CowId, ",")
  494. pref.Where("a.cow_id IN ?", cowIds)
  495. }
  496. if err := pref.Order("a.id desc").
  497. Count(&count).Limit(int(pagination.PageSize)).
  498. Offset(int(pagination.PageOffset)).
  499. Find(&weightList).Error; err != nil {
  500. return nil, xerr.WithStack(err)
  501. }
  502. return &pasturePb.SearchWeightEventResponse{
  503. Code: http.StatusOK,
  504. Message: "ok",
  505. Data: &pasturePb.SearchWeightData{
  506. List: weightList,
  507. Total: int32(count),
  508. PageSize: pagination.PageSize,
  509. Page: pagination.Page,
  510. },
  511. }, nil
  512. }
  513. func (s *StoreEntry) CreateWeight(ctx context.Context, req *pasturePb.WeightEventRequest) error {
  514. if len(req.CowId) <= 0 {
  515. return xerr.Custom("请选择相关牛只")
  516. }
  517. currentSystemUser, _ := s.GetCurrentSystemUser(ctx)
  518. weightEvent := make([]*model.EventWeight, 0)
  519. for _, item := range req.WeightItems {
  520. cow, err := s.GetCowInfo(ctx, int64(item.CowId))
  521. if err != nil {
  522. return xerr.WithStack(err)
  523. }
  524. var weight = int32(item.Weight * 100)
  525. weightEvent = append(weightEvent, model.NewEventWeight(cow, currentSystemUser, weight, req))
  526. }
  527. if len(weightEvent) <= 0 {
  528. return nil
  529. }
  530. if err := s.DB.Transaction(func(tx *gorm.DB) error {
  531. for _, item := range weightEvent {
  532. if err := tx.Model(new(model.Cow)).Where("id = ?", item.CowId).Updates(map[string]interface{}{
  533. "last_weight_at": item.WeightAt,
  534. "current_weight": item.Weight,
  535. }).Error; err != nil {
  536. return xerr.WithStack(err)
  537. }
  538. }
  539. if err := tx.Create(weightEvent).Error; err != nil {
  540. return xerr.WithStack(err)
  541. }
  542. return nil
  543. }); err != nil {
  544. return xerr.WithStack(err)
  545. }
  546. return nil
  547. }