event_health.go 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653
  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. "gorm.io/gorm"
  13. pasturePb "gitee.com/xuyiping_admin/go_proto/proto/go/backend/cow"
  14. "gitee.com/xuyiping_admin/pkg/xerr"
  15. )
  16. // CowDiseaseCreate 牛只发病提交
  17. func (s *StoreEntry) CowDiseaseCreate(ctx context.Context, req *pasturePb.EventCowDiseaseRequest, source string) error {
  18. userModel, err := s.GetUserModel(ctx)
  19. if err != nil {
  20. return xerr.WithStack(err)
  21. }
  22. // 牛只信息
  23. cow, err := s.GetCowInfoByCowId(ctx, userModel.AppPasture.Id, int64(req.CowId))
  24. if err != nil {
  25. return xerr.Customf("牛只信息错误: %d", req.CowId)
  26. }
  27. operationUser, err := s.GetSystemUserById(ctx, int64(req.OperationId))
  28. if err != nil {
  29. return xerr.Customf("请检查操作人信息")
  30. }
  31. disease, err := s.GetDiseaseById(ctx, userModel.AppPasture.Id, req.DiseaseId)
  32. if err != nil {
  33. return xerr.WithStack(err)
  34. }
  35. newEventCowDisease := model.NewEventCowDisease(userModel.AppPasture.Id, cow, disease, req, operationUser, userModel.SystemUser)
  36. defer func() {
  37. // 更新牛只健康状态
  38. if newEventCowDisease.HealthStatus == pasturePb.HealthStatus_Disease || newEventCowDisease.HealthStatus == pasturePb.HealthStatus_Treatment {
  39. cow.EventHealthStatusUpdate(pasturePb.HealthStatus_Disease)
  40. if err = s.DB.Model(new(model.Cow)).
  41. Select("health_status").
  42. Where("id = ?", req.CowId).
  43. Updates(cow).Error; err != nil {
  44. zaplog.Error("CowDiseaseCreate", zap.Any("EventHealthStatusUpdate", err))
  45. }
  46. }
  47. if req.PenId > 0 {
  48. penMap := s.PenMap(ctx, userModel.AppPasture.Id)
  49. penData, ok := penMap[req.PenId]
  50. if !ok {
  51. return
  52. }
  53. cow.EventPenUpdate(penData)
  54. if err = s.DB.Model(new(model.Cow)).
  55. Select("pen_id", "pen_name").
  56. Where("id = ?", cow.Id).
  57. Updates(cow).Error; err != nil {
  58. zaplog.Error("CowDiseaseCreate", zap.Any("EventPenUpdate", err))
  59. }
  60. }
  61. }()
  62. // PC端直接跳过诊断过程
  63. if source == model.SourcePC {
  64. newEventCowDisease.DiagnosedResult = pasturePb.IsShow_Ok
  65. newEventCowDisease.DiagnoseOperationId = int32(operationUser.Id)
  66. newEventCowDisease.DiagnoseOperationName = operationUser.Name
  67. newEventCowDisease.Source = model.SourcePC
  68. newEventCowDisease.DiagnoseId = req.DiseaseId
  69. newEventCowDisease.DiagnoseName = disease.Name
  70. newEventCowDisease.HealthStatus = pasturePb.HealthStatus_Disease
  71. }
  72. if req.PrescriptionId > 0 || len(req.PrescriptionDetail) > 0 {
  73. newEventCowDisease.HealthStatus = pasturePb.HealthStatus_Treatment
  74. newEventCowDisease.DiagnosedResult = pasturePb.IsShow_Ok
  75. newEventCowDisease.FirstTreatmentAt = int64(req.DiseaseAt)
  76. newEventCowDisease.LastTreatmentAt = int64(req.DiseaseAt)
  77. }
  78. newEventCowTreatment := &model.EventCowTreatment{}
  79. newCowTreatmentRequest := &pasturePb.CowTreatmentRequest{}
  80. var isCreatePrescription bool
  81. diseaseTypeMap := s.DiseaseTypeMap()
  82. prescription := &model.Prescription{}
  83. if req.PrescriptionId > 0 || len(req.PrescriptionDetail) > 0 {
  84. isCreatePrescription = true
  85. if req.PrescriptionId > 0 {
  86. prescription, err = s.GetPrescriptionById(ctx, userModel.AppPasture.Id, req.PrescriptionId)
  87. if err != nil {
  88. return xerr.WithStack(err)
  89. }
  90. prescriptionDrugs, err := s.PrescriptionDrugsByPrescriptionId(ctx, userModel.AppPasture.Id, prescription.Id)
  91. if err != nil {
  92. return xerr.WithStack(err)
  93. }
  94. req.PrescriptionDetail = model.PrescriptionDrugsSlice(prescriptionDrugs).ToPB()
  95. }
  96. }
  97. if err = s.DB.Transaction(func(tx *gorm.DB) error {
  98. lastPrescriptionName := ""
  99. // 已有的处方使用次数+1
  100. if req.PrescriptionId > 0 {
  101. prescription.EventUseCountUpdate()
  102. if err = tx.Model(new(model.Prescription)).
  103. Where("id = ?", prescription.Id).
  104. Updates(prescription).Error; err != nil {
  105. return xerr.WithStack(err)
  106. }
  107. lastPrescriptionName = prescription.Name
  108. }
  109. // 新的临时处方
  110. if req.PrescriptionId <= 0 && len(req.PrescriptionDetail) > 0 {
  111. newPrescriptionRequest := &pasturePb.PrescriptionRequest{
  112. Name: fmt.Sprintf("%s-%s-%s", disease.Name, time.Now().Format("20060102"), operationUser.Name),
  113. ApplicableDiseaseIds: []int32{req.DiseaseId},
  114. IsShow: pasturePb.IsShow_Ok,
  115. }
  116. newPrescription := model.NewPrescription(
  117. userModel.AppPasture.Id,
  118. newPrescriptionRequest,
  119. fmt.Sprintf("%d", disease.Id),
  120. 1,
  121. 0,
  122. 0,
  123. userModel.SystemUser,
  124. )
  125. newPrescription.UseCount += 1
  126. if err = tx.Model(new(model.Prescription)).Create(newPrescription).Error; err != nil {
  127. return xerr.WithStack(err)
  128. }
  129. prescription = newPrescription
  130. lastPrescriptionName = newPrescription.Name
  131. newPrescriptionDrugs := model.NewPrescriptionDrugs(userModel.AppPasture.Id, prescription.Id, req.PrescriptionDetail)
  132. if err = tx.Model(new(model.PrescriptionDrugs)).Create(newPrescriptionDrugs).Error; err != nil {
  133. return xerr.WithStack(err)
  134. }
  135. }
  136. // 创建 CowDisease
  137. newEventCowDisease.LastPrescriptionName = lastPrescriptionName
  138. if err = tx.Model(new(model.EventCowDisease)).Create(newEventCowDisease).Error; err != nil {
  139. return xerr.WithStack(err)
  140. }
  141. // 创建治疗记录
  142. if isCreatePrescription {
  143. newCowTreatmentRequest = &pasturePb.CowTreatmentRequest{
  144. CowId: req.CowId,
  145. PrescriptionId: prescription.Id,
  146. DiseaseId: req.DiseaseId,
  147. DiseaseName: disease.Name,
  148. DiseaseType: disease.DiseaseType,
  149. PrescriptionDetail: req.PrescriptionDetail,
  150. TreatmentResult: pasturePb.TreatmentResult_GoOn,
  151. Remarks: req.Remarks,
  152. TreatmentAt: req.DiseaseAt,
  153. }
  154. newEventCowTreatment = model.NewEventCowTreatment(userModel.AppPasture.Id, prescription, newCowTreatmentRequest, diseaseTypeMap, operationUser, userModel.SystemUser)
  155. newEventCowTreatment.CowDiseaseId = newEventCowDisease.Id
  156. // 创建治疗记录
  157. if err = tx.Model(new(model.EventCowTreatment)).Create(newEventCowTreatment).Error; err != nil {
  158. return xerr.WithStack(err)
  159. }
  160. }
  161. return nil
  162. }); err != nil {
  163. return xerr.WithStack(err)
  164. }
  165. return nil
  166. }
  167. func (s *StoreEntry) EstrusCowList(ctx context.Context, req *pasturePb.EstrusItemsRequest, pagination *pasturePb.PaginationModel) (*pasturePb.EventEstrusResponse, error) {
  168. userModel, err := s.GetUserModel(ctx)
  169. if err != nil {
  170. return nil, xerr.WithStack(err)
  171. }
  172. var count int64
  173. neckRingEstrusList := make([]*model.NeckRingEstrus, 0)
  174. pref := s.DB.Model(new(model.NeckRingEstrus)).
  175. Where("pasture_id = ?", userModel.AppPasture.Id).
  176. Where("is_show = ?", pasturePb.IsShow_Ok)
  177. if len(req.CowIds) > 0 {
  178. cowIds := strings.Split(util.ArrayInt32ToStrings(req.CowIds, ","), ",")
  179. pref.Where("cow_id IN ?", cowIds)
  180. }
  181. if req.Level > 0 {
  182. pref.Where("level = ?", req.Level)
  183. }
  184. if len(req.PenIds) > 0 {
  185. penIds := strings.Split(util.ArrayInt32ToStrings(req.PenIds, ","), ",")
  186. pref.Where("pen_id IN ?", penIds)
  187. }
  188. if err = pref.Order("level desc").
  189. Count(&count).
  190. Limit(int(pagination.PageSize)).
  191. Offset(int(pagination.PageOffset)).
  192. Find(&neckRingEstrusList).Error; err != nil {
  193. return nil, xerr.WithStack(err)
  194. }
  195. cowMap := make(map[int64]*model.Cow)
  196. eventLogMap := make(map[int64]string)
  197. cowIds := make([]int64, 0)
  198. for _, v := range neckRingEstrusList {
  199. cowIds = append(cowIds, v.CowId)
  200. lastEventLog := s.GetCowLastEvent(userModel.AppPasture.Id, v.CowId, pasturePb.EventCategory_Breed)
  201. if lastEventLog != nil {
  202. eventLogMap[v.CowId] = lastEventLog.EventDescription
  203. }
  204. }
  205. if len(cowIds) > 0 {
  206. cowList, _ := s.GetCowInfoByCowIds(ctx, userModel.AppPasture.Id, cowIds)
  207. for _, cow := range cowList {
  208. cowMap[cow.Id] = cow
  209. }
  210. }
  211. return &pasturePb.EventEstrusResponse{
  212. Code: http.StatusOK,
  213. Msg: "ok",
  214. Data: &pasturePb.EstrusItemsData{
  215. List: model.NeckRingEstrusSlice(neckRingEstrusList).ToPB(cowMap, eventLogMap),
  216. Total: int32(count),
  217. PageSize: pagination.PageSize,
  218. Page: pagination.Page,
  219. },
  220. }, nil
  221. }
  222. // CowDiseaseList 发病牛只清单
  223. func (s *StoreEntry) CowDiseaseList(ctx context.Context, req *pasturePb.SearchEventCowTreatmentRequest, pagination *pasturePb.PaginationModel) (*pasturePb.EventCowDiseaseResponse, error) {
  224. userModel, err := s.GetUserModel(ctx)
  225. if err != nil {
  226. return nil, xerr.WithStack(err)
  227. }
  228. cowDiseaseList := make([]*model.EventCowDisease, 0)
  229. var count int64 = 0
  230. pref := s.DB.Table(fmt.Sprintf("%s as a", new(model.EventCowDisease).TableName())).
  231. Joins(fmt.Sprintf("JOIN %s AS b on a.cow_id = b.id", new(model.Cow).TableName())).
  232. Select("a.*,b.pen_name").
  233. Where("a.pasture_id = ?", userModel.AppPasture.Id)
  234. if len(req.CowIds) > 0 {
  235. pref.Where("a.cow_id IN ?", req.CowIds)
  236. }
  237. if req.DiseaseId > 0 {
  238. pref.Where("a.disease_id = ?", req.DiseaseId)
  239. }
  240. if req.PenId > 0 {
  241. pref.Where("b.pen_id = ?", req.PenId)
  242. }
  243. if req.HealthStatus > 0 {
  244. pref.Where("a.health_status = ?", req.HealthStatus)
  245. }
  246. if req.DiseasedStartAt > 0 && req.DiseaseEndAt > 0 && req.DiseaseEndAt >= req.DiseasedStartAt {
  247. pref.Where("a.disease_at BETWEEN ? AND ?", req.DiseasedStartAt, req.DiseaseEndAt)
  248. }
  249. if err = pref.Order("a.id desc").
  250. Count(&count).Limit(int(pagination.PageSize)).
  251. Offset(int(pagination.PageOffset)).
  252. Find(&cowDiseaseList).Error; err != nil {
  253. return nil, xerr.WithStack(err)
  254. }
  255. healthStatusMap := s.HealthStatusMap()
  256. return &pasturePb.EventCowDiseaseResponse{
  257. Code: http.StatusOK,
  258. Msg: "ok",
  259. Data: &pasturePb.EventCowDiseaseData{
  260. List: model.EventCowDiseaseSlice(cowDiseaseList).ToPB(healthStatusMap),
  261. Total: int32(count),
  262. PageSize: pagination.PageSize,
  263. Page: pagination.Page,
  264. },
  265. }, nil
  266. }
  267. // CowDiseaseDiagnose 发病牛只诊断
  268. func (s *StoreEntry) CowDiseaseDiagnose(ctx context.Context, req *pasturePb.CowDiagnosedRequest) error {
  269. userModel, err := s.GetUserModel(ctx)
  270. if err != nil {
  271. return xerr.WithStack(err)
  272. }
  273. cow, err := s.GetCowInfoByCowId(ctx, userModel.AppPasture.Id, int64(req.CowId))
  274. if err != nil {
  275. return xerr.Customf("错误的牛只信息: %d", req.CowId)
  276. }
  277. eventCowDisease := &model.EventCowDisease{}
  278. if err = s.DB.Model(new(model.EventCowDisease)).
  279. Where("cow_id = ?", req.CowId).
  280. Where("id = ?", req.Id).
  281. Where("health_status = ?", pasturePb.HealthStatus_Health).
  282. Where("pasture_id = ?", userModel.AppPasture.Id).
  283. First(eventCowDisease).Error; err != nil {
  284. zaplog.Error("CowDiseaseDiagnose", zap.Any("req", req), zap.Any("userModel", userModel))
  285. return xerr.Custom("异常牛只数据")
  286. }
  287. if eventCowDisease == nil || eventCowDisease.Id <= 0 {
  288. return xerr.Custom("异常牛只数据")
  289. }
  290. if req.DiagnosedResult == pasturePb.IsShow_No {
  291. // 未发病更新
  292. eventCowDisease.EventUnDiseaseUpdate(userModel.SystemUser, req.Remarks)
  293. if err = s.DB.Model(eventCowDisease).
  294. Select("diagnosed_result", "diagnose_operation_id", "diagnose_operation_name", "remarks").
  295. Where("id = ?", req.Id).
  296. Updates(eventCowDisease).Error; err != nil {
  297. return xerr.WithStack(err)
  298. }
  299. return nil
  300. }
  301. // 已发病
  302. disease, err := s.GetDiseaseById(ctx, userModel.AppPasture.Id, req.DiseaseId)
  303. if err != nil {
  304. return xerr.WithStack(err)
  305. }
  306. systemUser, err := s.GetSystemUserById(ctx, int64(req.OperationId))
  307. if err != nil {
  308. return xerr.WithStack(err)
  309. }
  310. if err = s.DB.Transaction(func(tx *gorm.DB) error {
  311. eventCowDisease.EventDiseaseUpdate(disease, systemUser, req.Temperature)
  312. if err = tx.Model(eventCowDisease).
  313. Select("health_status", "diagnosed_result", "diagnose_id", "diagnose_name", "temperature", "diagnose_operation_id", "diagnose_operation_name", "diagnosed_at").
  314. Where("id = ?", req.Id).
  315. Where("cow_id = ?", req.CowId).
  316. Updates(eventCowDisease).Error; err != nil {
  317. return xerr.WithStack(err)
  318. }
  319. cow.EventHealthStatusUpdate(pasturePb.HealthStatus_Disease)
  320. if err = tx.Model(cow).
  321. Select("health_status").
  322. Where("id = ?", cow.Id).
  323. Updates(cow).Error; err != nil {
  324. return xerr.WithStack(err)
  325. }
  326. return nil
  327. }); err != nil {
  328. return xerr.WithStack(err)
  329. }
  330. return nil
  331. }
  332. // CowDiseaseTreatment 发病牛只治疗
  333. func (s *StoreEntry) CowDiseaseTreatment(ctx context.Context, req *pasturePb.CowTreatmentRequest) error {
  334. userModel, err := s.GetUserModel(ctx)
  335. if err != nil {
  336. return xerr.WithStack(err)
  337. }
  338. // 牛只疾病信息
  339. eventCowDisease := &model.EventCowDisease{}
  340. if err = s.DB.Where("cow_id = ?", req.CowId).
  341. Where("pasture_id = ?", userModel.AppPasture.Id).
  342. Where("id = ?", req.Id).
  343. First(eventCowDisease).Error; err != nil {
  344. return xerr.WithStack(err)
  345. }
  346. if eventCowDisease.HealthStatus != pasturePb.HealthStatus_Disease &&
  347. eventCowDisease.HealthStatus != pasturePb.HealthStatus_Treatment {
  348. return xerr.Custom("异常牛只数据")
  349. }
  350. cow, err := s.GetCowInfoByCowId(ctx, userModel.AppPasture.Id, int64(req.CowId))
  351. if err != nil {
  352. return xerr.WithStack(err)
  353. }
  354. // 操作人信息
  355. operationUser, err := s.GetSystemUserById(ctx, int64(req.OperationId))
  356. if err != nil {
  357. return xerr.Customf("操作人数据异常: %d", req.OperationId)
  358. }
  359. // 处方信息
  360. prescription, err := s.GetPrescriptionById(ctx, userModel.AppPasture.Id, req.PrescriptionId)
  361. if err != nil {
  362. return xerr.WithStack(err)
  363. }
  364. // 疾病信息
  365. disease, err := s.GetDiseaseById(ctx, userModel.AppPasture.Id, eventCowDisease.DiseaseId)
  366. if err != nil {
  367. return xerr.WithStack(err)
  368. }
  369. req.DiseaseName = disease.Name
  370. req.DiseaseType = disease.DiseaseType
  371. // 处方信息
  372. prescriptionDrugs, err := s.PrescriptionDrugsByPrescriptionId(ctx, userModel.AppPasture.Id, prescription.Id)
  373. if err != nil {
  374. return xerr.WithStack(err)
  375. }
  376. // 处方详情
  377. unitMap := s.UnitMap()
  378. prescriptionDetail := make([]*pasturePb.PrescriptionDrugsList, len(prescriptionDrugs))
  379. for i, v := range prescriptionDrugs {
  380. prescriptionDetail[i] = &pasturePb.PrescriptionDrugsList{
  381. DrugsId: int32(v.DrugsId),
  382. DrugsName: v.DrugsName,
  383. Unit: v.Unit,
  384. UnitName: unitMap[v.Unit],
  385. Dosages: v.Dosages,
  386. }
  387. }
  388. req.PrescriptionDetail = prescriptionDetail
  389. healthStatus := pasturePb.HealthStatus_Treatment
  390. if req.TreatmentResult == pasturePb.TreatmentResult_Curable {
  391. healthStatus = pasturePb.HealthStatus_Curable
  392. }
  393. if req.TreatmentResult == pasturePb.TreatmentResult_Out {
  394. healthStatus = pasturePb.HealthStatus_Out
  395. }
  396. if req.TreatmentResult == pasturePb.TreatmentResult_Dead {
  397. healthStatus = pasturePb.HealthStatus_Dead
  398. }
  399. diseaseTypeMap := s.DiseaseTypeMap()
  400. newEventCowTreatment := model.NewEventCowTreatment(userModel.AppPasture.Id, prescription, req, diseaseTypeMap, operationUser, userModel.SystemUser)
  401. if err = s.DB.Transaction(func(tx *gorm.DB) error {
  402. if err = tx.Create(newEventCowTreatment).Error; err != nil {
  403. return xerr.WithStack(err)
  404. }
  405. eventCowDisease.EventTreatmentUpdate(healthStatus, int64(req.TreatmentAt), prescription.Name)
  406. if err = tx.Model(eventCowDisease).
  407. Select("health_status", "first_treatment_at", "last_treatment_at", "last_prescription_name").
  408. Where("id = ?", req.Id).
  409. Where("cow_id = ?", req.CowId).
  410. Updates(eventCowDisease).Error; err != nil {
  411. return xerr.WithStack(err)
  412. }
  413. cow.EventHealthStatusUpdate(healthStatus)
  414. if err = tx.Model(new(model.Cow)).
  415. Select("health_status").
  416. Where("id = ?", req.CowId).
  417. Updates(cow).Error; err != nil {
  418. return xerr.WithStack(err)
  419. }
  420. prescription.EventUseCountUpdate()
  421. if err = tx.Model(prescription).
  422. Select("use_count").
  423. Where("id = ?", prescription.Id).
  424. Updates(prescription).Error; err != nil {
  425. return xerr.WithStack(err)
  426. }
  427. return nil
  428. }); err != nil {
  429. return xerr.WithStack(err)
  430. }
  431. return nil
  432. }
  433. func (s *StoreEntry) DiseaseSuggestPrescription(ctx context.Context, diseaseId int64) (*pasturePb.ConfigOptionsListResponse, error) {
  434. userModel, err := s.GetUserModel(ctx)
  435. if err != nil {
  436. return nil, xerr.WithStack(err)
  437. }
  438. res := make([]*pasturePb.ConfigOptionsList, 0)
  439. prescriptionList := make([]*model.Prescription, 0)
  440. if err = s.DB.Model(new(model.Prescription)).
  441. Where("is_show = ?", pasturePb.IsShow_Ok).
  442. Where("pasture_id = ?", userModel.AppPasture.Id).
  443. Find(&prescriptionList).Error; err != nil {
  444. return nil, xerr.WithStack(err)
  445. }
  446. for _, v := range prescriptionList {
  447. disabled := false
  448. if strings.Contains(v.ApplicableDisease, fmt.Sprintf("%d", diseaseId)) {
  449. disabled = true
  450. }
  451. res = append(res, &pasturePb.ConfigOptionsList{
  452. Value: v.Id,
  453. Label: v.Name,
  454. Disabled: disabled,
  455. })
  456. }
  457. return &pasturePb.ConfigOptionsListResponse{
  458. Code: http.StatusOK,
  459. Msg: "ok",
  460. Data: res,
  461. }, nil
  462. }
  463. // CowDiseaseTreatmentDetail 发病牛只治疗详情列表
  464. func (s *StoreEntry) CowDiseaseTreatmentDetail(
  465. ctx context.Context,
  466. req *pasturePb.EventCowTreatmentDetailRequest,
  467. pagination *pasturePb.PaginationModel,
  468. ) (*pasturePb.EventCowTreatmentDetailResponse, error) {
  469. userModel, err := s.GetUserModel(ctx)
  470. if err != nil {
  471. return nil, xerr.WithStack(err)
  472. }
  473. eventCowDiseaseList := make([]*model.EventCowDisease, 0)
  474. var count int64 = 0
  475. pref := s.DB.Model(new(model.EventCowDisease)).
  476. Where("cow_id = ?", req.CowId).Where("pasture_id = ?", userModel.AppPasture.Id)
  477. if req.DiseaseId > 0 {
  478. pref.Where("disease_id = ?", req.DiseaseId)
  479. }
  480. if req.DiseaseStartAt > 0 && req.DiseaseEndAt > 0 && req.DiseaseStartAt <= req.DiseaseEndAt {
  481. pref.Where("disease_at BETWEEN ? AND ?", req.DiseaseStartAt, req.DiseaseEndAt)
  482. }
  483. if err = pref.Count(&count).
  484. Limit(int(pagination.PageSize)).
  485. Offset(int(pagination.PageOffset)).
  486. Order("id desc").
  487. Find(&eventCowDiseaseList).Error; err != nil {
  488. return nil, xerr.WithStack(err)
  489. }
  490. eventCowTreatmentList := make([]*model.EventCowTreatment, 0)
  491. cowDiseaseIds := make([]int64, len(eventCowDiseaseList))
  492. for i, v := range eventCowDiseaseList {
  493. cowDiseaseIds[i] = v.Id
  494. }
  495. if err := s.DB.Model(new(model.EventCowTreatment)).
  496. Where("cow_disease_id IN ?", cowDiseaseIds).
  497. Where("cow_id = ?", req.CowId).
  498. Group("cow_disease_id").
  499. Order("id desc").
  500. Find(&eventCowTreatmentList).Error; err != nil {
  501. return nil, xerr.WithStack(err)
  502. }
  503. return &pasturePb.EventCowTreatmentDetailResponse{
  504. Code: http.StatusOK,
  505. Msg: "ok",
  506. Data: &pasturePb.EventCowTreatmentDetail{
  507. List: model.EventCowTreatmentSlice(eventCowTreatmentList).ToPB(eventCowDiseaseList),
  508. Total: int32(count),
  509. PageSize: pagination.Page,
  510. Page: pagination.PageSize,
  511. },
  512. }, nil
  513. }
  514. func (s *StoreEntry) CowDiseaseCurable(ctx context.Context, req *pasturePb.EventCowCurableRequest) error {
  515. userModel, err := s.GetUserModel(ctx)
  516. if err != nil {
  517. return xerr.WithStack(err)
  518. }
  519. eventCowDiseaseList := make([]*model.EventCowDisease, 0)
  520. if err = s.DB.Where("id IN ?", req.Ids).
  521. Where("health_status = ?", pasturePb.HealthStatus_Treatment).
  522. Where("pasture_id = ?", userModel.AppPasture.Id).
  523. Find(&eventCowDiseaseList).Error; err != nil {
  524. zaplog.Error("GetEventCowDiseaseList", zap.Any("err", err), zap.Any("req", req))
  525. return xerr.Custom("异常数据")
  526. }
  527. if len(eventCowDiseaseList) == 0 {
  528. return nil
  529. }
  530. operationUser, err := s.GetSystemUserById(ctx, int64(req.OperationId))
  531. if err != nil {
  532. return xerr.Customf("该用户不存在: %d", req.OperationId)
  533. }
  534. eventCowTreatmentList := make([]*model.EventCowTreatment, 0)
  535. for _, v := range eventCowDiseaseList {
  536. newEventCowTreatment := model.NewEventCowCurableTreatment(userModel.AppPasture.Id, userModel.SystemUser, operationUser, v, req.Remarks, int64(req.CurableAt))
  537. eventCowTreatmentList = append(eventCowTreatmentList, newEventCowTreatment)
  538. }
  539. if len(eventCowTreatmentList) <= 0 {
  540. return nil
  541. }
  542. if err = s.DB.Transaction(func(tx *gorm.DB) error {
  543. cow := &model.Cow{}
  544. for _, eventCowDisease := range eventCowDiseaseList {
  545. eventCowDisease.EventCurableUpdate(int64(req.CurableAt))
  546. if err = tx.Model(eventCowDisease).
  547. Select("health_status", "diagnosed_result", "curable_at").
  548. Where("id = ?", eventCowDisease.Id).
  549. Where("health_status = ?", pasturePb.HealthStatus_Treatment).
  550. Updates(eventCowDisease).Error; err != nil {
  551. return xerr.WithStack(err)
  552. }
  553. cow, err = s.GetCowInfoByCowId(ctx, userModel.AppPasture.Id, eventCowDisease.CowId)
  554. if err != nil {
  555. return xerr.WithStack(err)
  556. }
  557. // 更新牛只健康状态
  558. cow.EventHealthStatusUpdate(pasturePb.HealthStatus_Curable)
  559. if err = tx.Model(cow).
  560. Select("health_status").
  561. Where("id = ?", eventCowDisease.CowId).
  562. Updates(cow).Error; err != nil {
  563. return xerr.WithStack(err)
  564. }
  565. }
  566. if err = tx.Model(new(model.EventCowTreatment)).Create(eventCowTreatmentList).Error; err != nil {
  567. return xerr.WithStack(err)
  568. }
  569. return nil
  570. }); err != nil {
  571. return xerr.WithStack(err)
  572. }
  573. return nil
  574. }