event_health.go 22 KB

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