Постман: Информация о пациенте.postman_collection.json
Блок кода | ||||||
---|---|---|---|---|---|---|
| ||||||
--В цоде select top 1 case when mkab.RH = 0 then 1 when mkab.RH = 1 then 2 else 0 end as [RH], -- Если 0, то Undefined gb.NAME as [BloodGroup] -- Если не получили, то Undefined from hlt_mkab mkab with(nolock) left join hlt_GroupOfBloodRH gb with(nolock) on mkab.rf_GroupOfBloodID = gb.GroupOfBloodRHID where UGUID IN (@0) -- мкабы пациента -- Получение RW и HIV select rt.Code as [Code], rt.ResearchName, res.Conclusion as [Result] -- Если нашли то пишем A12.06.011 в RW, а A26.06.048 в HIV from lbr_research res with(nolock) join lbr_ResearchType rt with(nolock) on rt.UGUID = res.rf_ResearchTypeUGUID join lbr_LaboratoryResearch lr with(nolock) on lr.GUID = res.rf_LaboratoryResearchGUID where rt.Code in ('A26.06.048', 'A12.06.011') and lr.rf_MKABID in (select mkabid from hlt_mkab with(nolock) where UGUID IN(@0)) -- мкабы пациента and res.isComplete = 1 |
...