research_donation_sample_collection.py 8.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260
  1. """科研捐赠样本采集信息列表 CRUD(样本信息管理 · 样本采集信息)"""
  2. from __future__ import annotations
  3. import math
  4. from datetime import datetime
  5. from typing import Any, Dict, List, Optional, Tuple
  6. from sqlalchemy import and_, or_
  7. from sqlalchemy.orm import Session
  8. from app.core.utils import format_date
  9. from app.utils.sample_special import sample_special_to_dict
  10. from app.models.models import (
  11. BizCellSampleType,
  12. BizCollectionHospital,
  13. BizCollectionRegion,
  14. )
  15. from app.models.research_donation import (
  16. BizResearchDonation,
  17. BizResearchDonationCollection,
  18. BizResearchDonationParty,
  19. BizResearchDonationSample,
  20. )
  21. def total_pages(total: int, page_size: int) -> int:
  22. if total <= 0:
  23. return 0
  24. return int(math.ceil(total / float(page_size)))
  25. def _fmt_dt(t: Optional[datetime]) -> str:
  26. return t.strftime("%Y-%m-%d %H:%M:%S") if t else ""
  27. def _sample_status_label(status: str) -> str:
  28. return {
  29. "ycj": "已采集",
  30. "jcz": "检测中",
  31. "yrk": "已入库",
  32. "yzf": "已作废",
  33. }.get(status, "未采集" if not status else status)
  34. def _row_to_dict(
  35. *,
  36. donation_sample_id: str,
  37. research_donation_id: str,
  38. donation_no: str,
  39. donation_status: str,
  40. expected_delivery_date: str,
  41. mother_name: str,
  42. newborn_name: str,
  43. sample_code: str,
  44. sample_type_name: str,
  45. sample_status: str,
  46. sample_status_label: str,
  47. region_name: str,
  48. hospital_name: str,
  49. medical_staff: str,
  50. sample_collect_time: str,
  51. maternal_blood_collect_time: str,
  52. ) -> Dict[str, Any]:
  53. return {
  54. "donationSampleId": donation_sample_id,
  55. "researchDonationId": research_donation_id,
  56. "donationNo": donation_no,
  57. "donationStatus": donation_status,
  58. "expectedDeliveryDate": expected_delivery_date,
  59. "motherName": mother_name,
  60. "newbornName": newborn_name,
  61. "sampleCode": sample_code,
  62. "sampleTypeName": sample_type_name,
  63. "sampleStatus": sample_status,
  64. "sampleStatusLabel": sample_status_label,
  65. "regionName": region_name,
  66. "hospitalName": hospital_name,
  67. "medicalStaff": medical_staff,
  68. "sampleCollectTime": sample_collect_time,
  69. "maternalBloodCollectTime": maternal_blood_collect_time,
  70. }
  71. def _base_query(db: Session, tenant_no: str):
  72. return (
  73. db.query(
  74. BizResearchDonationSample,
  75. BizResearchDonation,
  76. BizResearchDonationParty,
  77. BizResearchDonationCollection,
  78. )
  79. .join(
  80. BizResearchDonation,
  81. and_(
  82. BizResearchDonation.id == BizResearchDonationSample.research_donation_id,
  83. BizResearchDonation.del_flag == 0,
  84. ),
  85. )
  86. .outerjoin(
  87. BizResearchDonationParty,
  88. and_(
  89. BizResearchDonationParty.research_donation_id == BizResearchDonation.id,
  90. BizResearchDonationParty.del_flag == 0,
  91. ),
  92. )
  93. .outerjoin(
  94. BizResearchDonationCollection,
  95. and_(
  96. BizResearchDonationCollection.research_donation_id == BizResearchDonation.id,
  97. BizResearchDonationCollection.del_flag == 0,
  98. ),
  99. )
  100. .filter(
  101. BizResearchDonationSample.tenant_no == tenant_no,
  102. BizResearchDonationSample.del_flag == 0,
  103. )
  104. )
  105. def _apply_sample_status_filter(q, sample_status: Optional[str]):
  106. st = (sample_status or "").strip()
  107. if not st or st == "all":
  108. return q
  109. if st == "uncollected":
  110. return q.filter(
  111. or_(
  112. BizResearchDonationSample.sample_status.is_(None),
  113. BizResearchDonationSample.sample_status == "",
  114. )
  115. )
  116. return q.filter(BizResearchDonationSample.sample_status == st)
  117. def list_donation_sample_collections(
  118. db: Session,
  119. *,
  120. page: int = 1,
  121. page_size: int = 10,
  122. tenant_no: str,
  123. keyword: Optional[str] = None,
  124. sample_status: Optional[str] = None,
  125. user_info=None,
  126. ) -> Tuple[List[Dict[str, Any]], int]:
  127. if not tenant_no:
  128. return [], 0
  129. q = _base_query(db, tenant_no)
  130. q = _apply_sample_status_filter(q, sample_status)
  131. if keyword and keyword.strip():
  132. kw = f"%{keyword.strip()}%"
  133. kw_conds = [
  134. BizResearchDonationParty.mother_name.like(kw),
  135. BizResearchDonationSample.sample_code.like(kw),
  136. ]
  137. from app.crud import sample_reception as reception_svc
  138. lab_codes = reception_svc.sample_codes_matching_lab_storage_keyword(
  139. db, tenant_no, keyword, reception_source="research_donation"
  140. )
  141. if lab_codes:
  142. kw_conds.append(BizResearchDonationSample.sample_code.in_(lab_codes))
  143. q = q.filter(or_(*kw_conds))
  144. if user_info:
  145. from app.core.data_scope import apply_data_scope
  146. q = apply_data_scope(q, BizResearchDonation, user_info, db, tenant_no)
  147. total = q.count()
  148. page = max(1, page)
  149. page_size = min(max(1, page_size), 100)
  150. rows = (
  151. q.order_by(
  152. BizResearchDonationParty.expected_delivery_date.is_(None),
  153. BizResearchDonationParty.expected_delivery_date.desc(),
  154. BizResearchDonation.create_time.desc(),
  155. BizResearchDonationSample.id.desc(),
  156. )
  157. .offset((page - 1) * page_size)
  158. .limit(page_size)
  159. .all()
  160. )
  161. sample_type_ids = list({
  162. ds.sample_type_id for ds, _, _, _ in rows if ds and ds.sample_type_id
  163. })
  164. type_map: Dict[str, str] = {}
  165. if sample_type_ids:
  166. for t in (
  167. db.query(BizCellSampleType)
  168. .filter(BizCellSampleType.id.in_(sample_type_ids), BizCellSampleType.del_flag == 0)
  169. .all()
  170. ):
  171. type_map[t.id] = t.type_name or ""
  172. region_ids = list({
  173. (ci.region_id or "").strip()
  174. for _, _, _, ci in rows
  175. if ci and (ci.region_id or "").strip()
  176. })
  177. hospital_ids = list({
  178. (ci.hospital_id or "").strip()
  179. for _, _, _, ci in rows
  180. if ci and (ci.hospital_id or "").strip()
  181. })
  182. region_name_map: Dict[str, str] = {}
  183. hospital_name_map: Dict[str, str] = {}
  184. if region_ids:
  185. for r in (
  186. db.query(BizCollectionRegion.id, BizCollectionRegion.region_name)
  187. .filter(BizCollectionRegion.id.in_(region_ids), BizCollectionRegion.del_flag == 0)
  188. .all()
  189. ):
  190. region_name_map[r.id] = r.region_name or ""
  191. if hospital_ids:
  192. for h in (
  193. db.query(BizCollectionHospital.id, BizCollectionHospital.hospital_name)
  194. .filter(BizCollectionHospital.id.in_(hospital_ids), BizCollectionHospital.del_flag == 0)
  195. .all()
  196. ):
  197. hospital_name_map[h.id] = h.hospital_name or ""
  198. items: List[Dict[str, Any]] = []
  199. for dsample, donation, party, ci in rows:
  200. status = (dsample.sample_status or "").strip() if dsample else ""
  201. region_id = (ci.region_id or "").strip() if ci else ""
  202. hospital_id = (ci.hospital_id or "").strip() if ci else ""
  203. item = _row_to_dict(
  204. donation_sample_id=dsample.id,
  205. research_donation_id=donation.id if donation else "",
  206. donation_no=(donation.donation_no or "") if donation else "",
  207. donation_status=(donation.donation_status or "") if donation else "",
  208. expected_delivery_date=format_date(party.expected_delivery_date) if party else "",
  209. mother_name=(party.mother_name or "") if party else "",
  210. newborn_name=(party.newborn_name or "") if party else "",
  211. sample_code=dsample.sample_code or "",
  212. sample_type_name=type_map.get(dsample.sample_type_id or "", ""),
  213. sample_status=status,
  214. sample_status_label=_sample_status_label(status),
  215. region_name=region_name_map.get(region_id, ""),
  216. hospital_name=hospital_name_map.get(hospital_id, ""),
  217. medical_staff=(ci.medical_staff or "") if ci else "",
  218. sample_collect_time=_fmt_dt(ci.sample_collect_time) if ci else "",
  219. maternal_blood_collect_time=_fmt_dt(ci.maternal_blood_collect_time) if ci else "",
  220. )
  221. item.update(sample_special_to_dict(dsample))
  222. items.append(item)
  223. if items and tenant_no:
  224. from app.crud import sample_reception as reception_svc
  225. codes = [i["sampleCode"] for i in items if i.get("sampleCode")]
  226. code_map = reception_svc.get_lab_storage_code_map_by_sample_codes(
  227. db, tenant_no, codes, reception_source="research_donation"
  228. )
  229. for item in items:
  230. sc = (item.get("sampleCode") or "").strip()
  231. item["labStorageCode"] = code_map.get(sc, "") if sc else ""
  232. return items, total