BehospitalInfoMapper.java 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498
  1. package com.diagbot.mapper;
  2. import com.baomidou.mybatisplus.core.mapper.BaseMapper;
  3. import com.baomidou.mybatisplus.core.metadata.IPage;
  4. import com.diagbot.dto.*;
  5. import com.diagbot.entity.BehospitalInfo;
  6. import com.diagbot.vo.*;
  7. import org.apache.ibatis.annotations.Param;
  8. import java.util.List;
  9. import java.util.Map;
  10. import java.util.Set;
  11. /**
  12. * <p>
  13. * 住院病历信息 Mapper 接口
  14. * </p>
  15. *
  16. * @author zhoutg
  17. * @since 2020-04-13
  18. */
  19. public interface BehospitalInfoMapper extends BaseMapper<BehospitalInfo> {
  20. public IPage<BehospitalInfoDTO> getPage(BehospitalPageVO behospitalPageVO);
  21. public List<MsgDTO> getMsg(AnalyzeVO analyzeVO);
  22. public List<MsgDTO> getMsgByEntryCode(AnalyzeCodeVO analyzeCodeVO);
  23. /**
  24. * 各科室缺陷占比-全院-首页
  25. *
  26. * @param filterVO
  27. * @return
  28. */
  29. public List<NumDTO> entryByDept(FilterVO filterVO);
  30. /**
  31. * 质控结果缺陷总数查询
  32. *
  33. * @param filterVO
  34. * @return
  35. */
  36. public int getTotleResultNum(FilterVO filterVO);
  37. public List<BehospitalInfo> getNoGrade(TaskVO taskVO);
  38. IPage<BehospitalInfoDTO> getPageByDept(BehospitalPageVO behospitalPageVO);
  39. IPage<BehospitalInfoDTO> getPageByPerson(BehospitalPageVO behospitalPageVO);
  40. IPage<BehospitalInfoDTO> getPageByGroup(BehospitalPageVO behospitalPageVO);
  41. /**
  42. * 出院总人数统计-全院-首页
  43. *
  44. * @param filterVO
  45. * @return
  46. */
  47. public int leaveHosCount(FilterVO filterVO);
  48. /**
  49. * 新生儿出院人数统计-全院-首页
  50. *
  51. * @param filterVO
  52. * @return
  53. */
  54. public int newBornCount(FilterVO filterVO);
  55. /**
  56. * 死亡人数统计-全院-首页
  57. *
  58. * @param filterVO
  59. * @return
  60. */
  61. public int deathCount(FilterVO filterVO);
  62. /**
  63. * 手术人数统计-全院-首页
  64. *
  65. * @param filterVO
  66. * @return
  67. */
  68. public int operationCount(FilterVO filterVO);
  69. /**
  70. * 出院总人数统计-科室-首页
  71. *
  72. * @param filterVO
  73. * @return
  74. */
  75. public List<NumDTO> leaveHosCountByDept(FilterVO filterVO);
  76. /**
  77. * 入院总人数统计-科室-首页
  78. *
  79. * @param filterVO
  80. * @return
  81. */
  82. public List<AdmissionCountDTO> admissionHosCountByDept(FilterVO filterVO);
  83. /**
  84. * 新生儿出院人数统计-科室-首页
  85. *
  86. * @param filterVO
  87. * @return
  88. */
  89. public List<NumDTO> newBornCountByDept(FilterVO filterVO);
  90. /**
  91. * 死亡人数统计-科室-首页
  92. *
  93. * @param filterVO
  94. * @return
  95. */
  96. public List<NumDTO> deathCountByDept(FilterVO filterVO);
  97. /**
  98. * 手术人数统计-科室-首页
  99. *
  100. * @param filterVO
  101. * @return
  102. */
  103. public List<NumDTO> operationCountByDept(FilterVO filterVO);
  104. /**
  105. * 各科室缺陷占比排行(分页)
  106. *
  107. * @param filterPageVO
  108. * @return
  109. */
  110. public IPage<NumDTO> resultStatisticsByDeptPage(@Param("filterPageVO") FilterPageVO filterPageVO);
  111. /**
  112. * 各科室缺陷占比(组合)
  113. *
  114. * @param filterOrderVO
  115. * @return
  116. */
  117. public List<LevelStatisticsDTO> levelStatistics(FilterOrderVO filterOrderVO);
  118. /**
  119. * 病案首页合格率占比
  120. *
  121. * @param filterOrderVO
  122. * @return
  123. */
  124. public List<HomePageNumDTO> homePageLevelStatistics(FilterOrderVO filterOrderVO);
  125. /**
  126. * 各科室缺陷占比(主任医生)
  127. *
  128. * @param filterOrderVO
  129. * @return
  130. */
  131. public List<LevelStsByDeptDTO> levelStatisticsByDept(FilterOrderVO filterOrderVO);
  132. /**
  133. * 病案首页合格率占比(主任医生)
  134. *
  135. * @param filterOrderByDeptVO
  136. * @return
  137. */
  138. public List<HomePageByDeptDTO> homePageLevelStatisticsByDept(FilterOrderByDeptVO filterOrderByDeptVO);
  139. /**
  140. * 单条条目缺陷统计-首页
  141. *
  142. * @param filterVO
  143. * @return
  144. */
  145. public List<AdmissionCountDTO> casesEntryStatisticsByDept(FilterVO filterVO);
  146. /**
  147. * 科室缺陷占比-科室(分页)
  148. *
  149. * @param filterPageByDeptVO
  150. * @return
  151. */
  152. public IPage<DeptNumDTO> resultStatisticsByDeptAndDoctorPage(@Param("filterPageByDeptVO") FilterPageByDeptVO filterPageByDeptVO);
  153. /**
  154. * 病案首页合格/不合格数
  155. *
  156. * @param qcResultPageVO
  157. * @return
  158. */
  159. public IPage<QcResultShortDTO> getIsGoodLevelByDept(QcResultPageVO qcResultPageVO);
  160. /**
  161. * 各科室缺陷占比(组合)-全院-根据内外科系统统计-关联上级科室
  162. *
  163. * @param filterOrderVO
  164. * @return
  165. */
  166. public List<LevelStatisticsTZDTO> levelStatisticsByDeptClass(FilterOrderVO filterOrderVO);
  167. /**
  168. * 各科室缺陷占比(组合)-全院-根据内外科系统统计(台州)
  169. *
  170. * @param filterOrderVO
  171. * @return
  172. */
  173. public List<LevelStatisticsTZDTO> levelStatisticsByDeptClass_TZ(FilterOrderVO filterOrderVO);
  174. List<ExportExcelDTO> exportExcel();
  175. /**
  176. * 质控评分导出到excel
  177. *
  178. * @param exportQcresultVO
  179. * @return
  180. */
  181. public List<ExportExcelDTO> exportQcresult(ExportQcresultVO exportQcresultVO);
  182. /**
  183. * 个人质控评分导出到excel
  184. *
  185. * @param exportQcresultVO
  186. * @return
  187. */
  188. public List<ExportExcelDTO> exportQcresultByPerson(ExportQcresultVO exportQcresultVO);
  189. /**
  190. * 科室质控评分导出到excel
  191. *
  192. * @param exportQcresultVO
  193. * @return
  194. */
  195. public List<ExportExcelDTO> exportQcresultByDept(ExportQcresultVO exportQcresultVO);
  196. /**
  197. * 医疗组质控评分导出到excel
  198. *
  199. * @param exportQcresultVO
  200. * @return
  201. */
  202. public List<ExportExcelDTO> exportQcresultByGroup(ExportQcresultVO exportQcresultVO);
  203. /**
  204. * 条目缺陷质控评分页(内页)
  205. *
  206. * @param qcResultShortPageVO
  207. * @return
  208. */
  209. public IPage<QcResultShortDTO> qcResultShortPage(@Param("qcResultShortPageVO") QcResultShortPageVO qcResultShortPageVO);
  210. /**
  211. * 条目缺陷质控评分页-科室(内页)
  212. *
  213. * @param qcResultShortPageVO
  214. * @return
  215. */
  216. public IPage<QcResultShortDTO> qcResultShortByDeptPage(@Param("qcResultShortPageVO") QcResultShortPageVO qcResultShortPageVO);
  217. /**
  218. * 根据两个主键-批量修改
  219. *
  220. * @param list
  221. */
  222. public void updateBatchByKey(List<BehospitalInfo> list);
  223. /**
  224. * 关键条目缺陷占比统计
  225. *
  226. * @param entryStatisticsVO
  227. * @return
  228. */
  229. public List<EntryStatisticsDTO> entryStatistics(EntryStatisticsVO entryStatisticsVO);
  230. /**
  231. * 关键条目缺陷占比统计-科室
  232. *
  233. * @param entryStatisticsVO
  234. * @return
  235. */
  236. public List<EntryStasByDeptDTO> entryStatisticsByDept(EntryStatisticsVO entryStatisticsVO);
  237. /**
  238. * 非医嘱离院病人记录
  239. *
  240. * @param filterVO
  241. * @return
  242. */
  243. public int nonAdviceCount(FilterVO filterVO);
  244. /**
  245. * 31天内再入院记录
  246. *
  247. * @param filterVO
  248. * @return
  249. */
  250. public int get31DaysBehospitalCount(FilterVO filterVO);
  251. /**
  252. * 病案首页质控病历数统计-全院(首页)
  253. *
  254. * @param filterVO
  255. * @return
  256. */
  257. public HomePageNumDTO homePageQcPercent(FilterVO filterVO);
  258. /**
  259. * 病案首页完整率统计-全院(首页)
  260. *
  261. * @param filterVO
  262. * @return
  263. */
  264. public HomePageNumDTO hmEmptyEntryPercent(FilterVO filterVO);
  265. /**
  266. * 离院病人质控评分详情页
  267. *
  268. * @param qcResultShortPageVO
  269. * @return
  270. */
  271. public IPage<QcResultShortDTO> leaveHosMRPage(@Param("qcResultShortPageVO") QcResultShortPageVO qcResultShortPageVO);
  272. /**
  273. * 离院病人质控评分年龄单独查询详情页
  274. *
  275. * @param
  276. * @return
  277. */
  278. List<Map<String,Object>>getAge(@Param("hospitalId")String hospitalId, @Param("behospitalCodes")Set<String> behospitalCodes);
  279. /**
  280. * 改善率统计-全院(首页)
  281. *
  282. * @param filterVO
  283. * @return
  284. */
  285. public HomePageImproveDTO homePageImproveCount(FilterVO filterVO);
  286. /**
  287. * 质控核查统计(内页)
  288. *
  289. * @param filterOrderVO
  290. * @return
  291. */
  292. public List<HomePageImproveDTO> qcCheckStatistics(FilterOrderVO filterOrderVO);
  293. /**
  294. * 离院病人质控评分详情页导出到excel
  295. *
  296. * @param qcResultShortPageVO
  297. * @return
  298. */
  299. public List<ExportExcelDTO> leaveHosMRPageExport(@Param("qcResultShortPageVO") QcResultShortPageVO qcResultShortPageVO);
  300. /**
  301. * 条目缺陷质控评分详情页导出到excel
  302. *
  303. * @param qcResultShortPageVO
  304. * @return
  305. */
  306. public List<ExportExcelDTO> qcResultShortPageExport(@Param("qcResultShortPageVO") QcResultShortPageVO qcResultShortPageVO);
  307. /**
  308. * 未整改病历统计
  309. *
  310. * @param filterUnModifyMRVO
  311. * @return
  312. */
  313. public List<UnModifyMRDetailDTO> unModifyMRStatistics(FilterUnModifyMRVO filterUnModifyMRVO);
  314. /**
  315. * 病历稽查表
  316. *
  317. * @param filterVO
  318. * @return
  319. */
  320. public IPage<MedicalCheckDTO> getMedicalCheck(@Param("filterVO")FilterMedicalCheckVO filterVO);
  321. public List<MedicalCheckIdNameDTO> getMedicalEntryIds(@Param("casesEntryIds")List<Long> casesEntryIds);
  322. /**
  323. * 病历稽查表导出
  324. *
  325. * @param filterVO
  326. * @return
  327. */
  328. public List<MedicalCheckExportDTO> getMedicalCheckExport(@Param("filterVO")FilterMedicalCheckVO filterVO);
  329. /**
  330. * 未整改病历质控评分页(内页)
  331. *
  332. * @param qcResultShortPageVO
  333. * @return
  334. */
  335. public IPage<QcResultShortDTO> unModifyMRPage(@Param("qcResultShortPageVO") QcResultShortPageVO qcResultShortPageVO);
  336. /**
  337. * 不合格/合格数病历号(内页)
  338. *
  339. * @param qcResultPageVO
  340. * @return
  341. */
  342. public IPage<QcResultShortDTO> badLevelPage(@Param("qcResultPageVO") QcResultPageVO qcResultPageVO);
  343. /**
  344. * 未整改病历缺陷评分详情页导出
  345. *
  346. * @param qcResultShortPageVO
  347. * @return
  348. */
  349. public List<ExportExcelDTO> unModifyMRPageExport(@Param("qcResultShortPageVO") QcResultShortPageVO qcResultShortPageVO);
  350. /**
  351. * 病案首页不合格/合格数病历详情页导出
  352. *
  353. * @param qcResultShortPageVO
  354. * @return
  355. */
  356. public List<ExportExcelDTO> badLevelPagePageExport(@Param("qcResultShortPageVO") QcResultShortPageVO qcResultShortPageVO);
  357. /**
  358. * 病案首页不合格/合格数病历详情页导出-科室
  359. *
  360. * @param qcResultShortPageVO
  361. * @return
  362. */
  363. public List<ExportExcelByDeptDTO> homePageOrLevelExportByDept(@Param("qcResultShortPageVO") QcResultShortPageVO qcResultShortPageVO);
  364. /**
  365. * 缺陷详情质控评分页导出-科室
  366. *
  367. * @param qcResultShortPageVO
  368. * @return
  369. */
  370. public List<ExportExcelByDeptDTO> qcResultShortByDeptPageExport(@Param("qcResultShortPageVO") QcResultShortPageVO qcResultShortPageVO);
  371. /**
  372. * 31天再入院详情页
  373. *
  374. * @param reBeHosPageVO
  375. * @return
  376. */
  377. public IPage<ReBeHosMergeDTO> reHos31DaysPage(@Param("reBeHosPageVO") ReBeHosPageVO reBeHosPageVO);
  378. /**
  379. * 入院人数统计-首页
  380. *
  381. * @param filterVO
  382. * @return
  383. */
  384. public List<NumDTO> beHosCount(FilterVO filterVO);
  385. /**
  386. * 单条条目缺陷统计-首页
  387. *
  388. * @param filterVO
  389. * @return
  390. */
  391. public List<NumDTO> casesEntryStatisticsById(FilterVO filterVO);
  392. /**
  393. * 病案首页改善率质控评分页(内页)
  394. *
  395. * @param qcResultShortPageVO
  396. * @return
  397. */
  398. public IPage<QcResultShortDTO> hmImproveMRPage(@Param("qcResultShortPageVO") QcResultShortPageVO qcResultShortPageVO);
  399. /**
  400. * 病案首页改善率质控评分页导出
  401. *
  402. * @param qcResultShortPageVO
  403. * @return
  404. */
  405. public List<ExportExcelDTO> hmImproveMRPageExport(@Param("qcResultShortPageVO") QcResultShortPageVO qcResultShortPageVO);
  406. /**
  407. * 质控核查质控评分页(内页)
  408. *
  409. * @param qcResultShortPageVO
  410. * @return
  411. */
  412. public IPage<QcResultShortDTO> qcCheckMRPage(@Param("qcResultShortPageVO") QcResultShortPageVO qcResultShortPageVO);
  413. /**
  414. * 质控核查质控评分页导出
  415. *
  416. * @param qcResultShortPageVO
  417. * @return
  418. */
  419. public List<ExportExcelDTO> qcCheckMRPageExport(@Param("qcResultShortPageVO") QcResultShortPageVO qcResultShortPageVO);
  420. }