BehospitalInfoMapper.java 6.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257
  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.BehospitalInfoDTO;
  5. import com.diagbot.dto.DeptNumDTO;
  6. import com.diagbot.dto.EntryStatisticsDTO;
  7. import com.diagbot.dto.ExportExcelDTO;
  8. import com.diagbot.dto.HomePageNumDTO;
  9. import com.diagbot.dto.LevelStatisticsDTO;
  10. import com.diagbot.dto.LevelStatisticsTZDTO;
  11. import com.diagbot.dto.MsgDTO;
  12. import com.diagbot.dto.NumDTO;
  13. import com.diagbot.dto.QcResultShortDTO;
  14. import com.diagbot.entity.BehospitalInfo;
  15. import com.diagbot.vo.AnalyzeCodeVO;
  16. import com.diagbot.vo.AnalyzeVO;
  17. import com.diagbot.vo.BehospitalPageVO;
  18. import com.diagbot.vo.EntryStatisticsVO;
  19. import com.diagbot.vo.ExportQcresultVO;
  20. import com.diagbot.vo.FilterOrderByDeptVO;
  21. import com.diagbot.vo.FilterOrderVO;
  22. import com.diagbot.vo.FilterPageByDeptVO;
  23. import com.diagbot.vo.FilterPageVO;
  24. import com.diagbot.vo.FilterVO;
  25. import com.diagbot.vo.QcResultShortPageVO;
  26. import com.diagbot.vo.TaskVO;
  27. import org.apache.ibatis.annotations.Param;
  28. import java.util.List;
  29. /**
  30. * <p>
  31. * 住院病历信息 Mapper 接口
  32. * </p>
  33. *
  34. * @author zhoutg
  35. * @since 2020-04-13
  36. */
  37. public interface BehospitalInfoMapper extends BaseMapper<BehospitalInfo> {
  38. public IPage<BehospitalInfoDTO> getPage(BehospitalPageVO behospitalPageVO);
  39. public List<MsgDTO> getMsg(AnalyzeVO analyzeVO);
  40. public List<MsgDTO> getMsgByEntryCode(AnalyzeCodeVO analyzeCodeVO);
  41. /**
  42. * 各科室缺陷占比-全院-首页
  43. *
  44. * @param filterVO
  45. * @return
  46. */
  47. public List<NumDTO> entryByDept(FilterVO filterVO);
  48. /**
  49. * 质控结果缺陷总数查询
  50. *
  51. * @param filterVO
  52. * @return
  53. */
  54. public int getTotleResultNum(FilterVO filterVO);
  55. public List<BehospitalInfo> getNoGrade(TaskVO taskVO);
  56. IPage<BehospitalInfoDTO> getPageByDept(BehospitalPageVO behospitalPageVO);
  57. IPage<BehospitalInfoDTO> getPageByPerson(BehospitalPageVO behospitalPageVO);
  58. IPage<BehospitalInfoDTO> getPageByGroup(BehospitalPageVO behospitalPageVO);
  59. /**
  60. * 出院总人数统计-全院-首页
  61. *
  62. * @param filterVO
  63. * @return
  64. */
  65. public int leaveHosCount(FilterVO filterVO);
  66. /**
  67. * 新生儿出院人数统计-全院-首页
  68. *
  69. * @param filterVO
  70. * @return
  71. */
  72. public int newBornCount(FilterVO filterVO);
  73. /**
  74. * 死亡人数统计-全院-首页
  75. *
  76. * @param filterVO
  77. * @return
  78. */
  79. public int deathCount(FilterVO filterVO);
  80. /**
  81. * 手术人数统计-全院-首页
  82. *
  83. * @param filterVO
  84. * @return
  85. */
  86. public int operationCount(FilterVO filterVO);
  87. /**
  88. * 出院总人数统计-科室-首页
  89. *
  90. * @param filterVO
  91. * @return
  92. */
  93. public List<NumDTO> leaveHosCountByDept(FilterVO filterVO);
  94. /**
  95. * 新生儿出院人数统计-科室-首页
  96. *
  97. * @param filterVO
  98. * @return
  99. */
  100. public List<NumDTO> newBornCountByDept(FilterVO filterVO);
  101. /**
  102. * 死亡人数统计-科室-首页
  103. *
  104. * @param filterVO
  105. * @return
  106. */
  107. public List<NumDTO> deathCountByDept(FilterVO filterVO);
  108. /**
  109. * 手术人数统计-科室-首页
  110. *
  111. * @param filterVO
  112. * @return
  113. */
  114. public List<NumDTO> operationCountByDept(FilterVO filterVO);
  115. /**
  116. * 各科室缺陷占比排行(分页)
  117. *
  118. * @param filterPageVO
  119. * @return
  120. */
  121. public IPage<NumDTO> resultStatisticsByDeptPage(@Param("filterPageVO") FilterPageVO filterPageVO);
  122. /**
  123. * 各科室缺陷占比(组合)
  124. *
  125. * @param filterOrderVO
  126. * @return
  127. */
  128. public List<LevelStatisticsDTO> levelStatistics(FilterOrderVO filterOrderVO);
  129. /**
  130. * 病案首页合格率占比
  131. *
  132. * @param filterOrderVO
  133. * @return
  134. */
  135. public List<HomePageNumDTO> homePageLevelStatistics(FilterOrderVO filterOrderVO);
  136. /**
  137. * 各科室缺陷占比(主任医生)
  138. *
  139. * @param filterOrderByDeptVO
  140. * @return
  141. */
  142. public List<LevelStatisticsDTO> levelStatisticsByDept(FilterOrderByDeptVO filterOrderByDeptVO);
  143. /**
  144. * 病案首页合格率占比(主任医生)
  145. *
  146. * @param filterOrderByDeptVO
  147. * @return
  148. */
  149. public List<HomePageNumDTO> homePageLevelStatisticsByDept(FilterOrderByDeptVO filterOrderByDeptVO);
  150. /**
  151. * 科室缺陷占比-科室(分页)
  152. *
  153. * @param filterPageByDeptVO
  154. * @return
  155. */
  156. public IPage<DeptNumDTO> resultStatisticsByDeptAndDoctorPage(@Param("filterPageByDeptVO") FilterPageByDeptVO filterPageByDeptVO);
  157. /**
  158. * 各科室缺陷占比(组合)-全院-根据内外科系统统计-关联上级科室
  159. *
  160. * @param filterOrderVO
  161. * @return
  162. */
  163. public List<LevelStatisticsTZDTO> levelStatisticsByDeptClass(FilterOrderVO filterOrderVO);
  164. /**
  165. * 各科室缺陷占比(组合)-全院-根据内外科系统统计(台州)
  166. *
  167. * @param filterOrderVO
  168. * @return
  169. */
  170. public List<LevelStatisticsTZDTO> levelStatisticsByDeptClass_TZ(FilterOrderVO filterOrderVO);
  171. List<ExportExcelDTO> exportExcel();
  172. /**
  173. * 质控评分导出到excel
  174. *
  175. * @param exportQcresultVO
  176. * @return
  177. */
  178. public List<ExportExcelDTO> exportQcresult(ExportQcresultVO exportQcresultVO);
  179. /**
  180. * 科室质控评分导出到excel
  181. *
  182. * @param exportQcresultVO
  183. * @return
  184. */
  185. public List<ExportExcelDTO> exportQcresultByDept(ExportQcresultVO exportQcresultVO);
  186. /**
  187. * 医疗组质控评分导出到excel
  188. *
  189. * @param exportQcresultVO
  190. * @return
  191. */
  192. public List<ExportExcelDTO> exportQcresultByGroup(ExportQcresultVO exportQcresultVO);
  193. /**
  194. * 条目缺陷质控评分页(内页)
  195. *
  196. * @param qcResultShortPageVO
  197. * @return
  198. */
  199. public IPage<QcResultShortDTO> qcResultShortPage(@Param("qcResultShortPageVO") QcResultShortPageVO qcResultShortPageVO);
  200. /**
  201. * 条目缺陷质控评分页-科室(内页)
  202. *
  203. * @param qcResultShortPageVO
  204. * @return
  205. */
  206. public IPage<QcResultShortDTO> qcResultShortByDeptPage(@Param("qcResultShortPageVO") QcResultShortPageVO qcResultShortPageVO);
  207. /**
  208. * 根据两个主键-批量修改
  209. *
  210. * @param list
  211. */
  212. public void updateBatchByKey(List<BehospitalInfo> list);
  213. /**
  214. * 关键条目缺陷占比统计
  215. *
  216. * @param entryStatisticsVO
  217. * @return
  218. */
  219. public List<EntryStatisticsDTO> entryStatistics(EntryStatisticsVO entryStatisticsVO);
  220. }