bedDays.vue 7.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208
  1. <template>
  2. <page-layer>
  3. <template #header>
  4. <el-date-picker v-model="dateRange" type="daterange" range-separator="至" start-placeholder="开始日期"
  5. end-placeholder="结束日期" :shortcuts="shortcuts"> </el-date-picker>
  6. <el-button type="primary" icon="Search" @click="query" style="margin-left: 5px">查询</el-button>
  7. <el-button type="primary" v-if="returnData.length > 0" icon="Download" @click="exportExcel">导出excel </el-button>
  8. </template>
  9. <template #main>
  10. <el-table :data="returnData.slice((currentPage - 1) * pageSize, currentPage * pageSize)" :height="tableHeight"
  11. stripe highlight-current-row show-summary :summary-method="getSummaries" @row-dblclick="ysDaysdetails">
  12. <el-table-column prop="ryks" label="科室"></el-table-column>
  13. <el-table-column prop="days" label="管床日数" sortable></el-table-column>
  14. </el-table>
  15. <el-dialog v-model="showSetldetails" :close-on-click-modal="false" :close-on-press-escape="false"
  16. :title="filterDialogTitle" width="70%">
  17. <div style="width: 130px; height: 36px; position: absolute; top: 16px; right: 60px">
  18. <el-button icon="Download" type="primary" @click="exportDetailExcel">导出Excel</el-button>
  19. </div>
  20. <el-table :data="setldetails.slice(pageSize * (currentPage - 1), pageSize * currentPage)" height="560"
  21. highlight-current-row stripe show-summary :summary-method="getSummaries">
  22. <el-table-column prop="ryks" label="科室"></el-table-column>
  23. <el-table-column prop="doctor" label="医生"></el-table-column>
  24. <el-table-column prop="days" label="管床日数" sortable></el-table-column>
  25. </el-table>
  26. <el-pagination :current-page="currentPage" :page-size="pageSize" :page-sizes="[15, 30, 45, 60]"
  27. :total="setldetails.length" layout="total, sizes, prev, pager, next, jumper" style="margin-top: 5px"
  28. @size-change="handleSizeChange" @current-change="handleCurrentChange"></el-pagination>
  29. </el-dialog>
  30. </template>
  31. </page-layer>
  32. <el-footer style="height: 40px">
  33. <el-pagination @size-change="handleSizeChange" @current-change="handleCurrentChange" :current-page="currentPage"
  34. :page-sizes="[20, 30, 40, 50, 100]" :page-size="pageSize" layout="total, sizes, prev, pager, next, jumper"
  35. :total="returnData.length" style="margin-top: 5px"></el-pagination>
  36. </el-footer>
  37. </template>
  38. <script>
  39. import { reactive, ref } from '@vue/reactivity'
  40. import { shortcuts } from '@/data/shortcuts'
  41. import { clockinShortcuts } from '@/data/shortcuts'
  42. import { onMounted } from 'vue'
  43. import { formatDate, getDateRangeFormatDate } from '@/utils/date'
  44. import { ElMessage } from 'element-plus'
  45. import store from '@/store'
  46. import { clone } from '@/utils/clone'
  47. import { selectBedDays, selectYsDaysDetails } from '@/api/reports/bedDays'
  48. import { ExcelName, Export } from '@/utils/ExportExcel'
  49. import PageLayer from '@/layout/PageLayer.vue'
  50. export default {
  51. setup() {
  52. const windowSize = store.state.app.windowSize;
  53. const tableHeight = windowSize.h / 1.02;
  54. const start = formatDate(clockinShortcuts[1].value[0]);
  55. const end = formatDate(clockinShortcuts[1].value[1]);
  56. const queryTerm = reactive({
  57. startTime: "",
  58. endTime: "",
  59. deptId: "",
  60. });
  61. onMounted(() => {
  62. queryTerm.startTime = start;
  63. queryTerm.endTime = end + " 23:59:59";
  64. dateRange.value = [start, end];
  65. });
  66. const dateRange = ref([]);
  67. const returnData = ref([]);
  68. const query = () => {
  69. if (dateRange.value) {
  70. let dateS = getDateRangeFormatDate(dateRange.value);
  71. queryTerm.startTime = dateS.startTime;
  72. queryTerm.endTime = dateS.endTime;
  73. }
  74. else {
  75. queryTerm.startTime = start;
  76. queryTerm.endTime = end;
  77. ElMessage({
  78. type: "info",
  79. message: "默认查询本月的数据",
  80. duration: 2500,
  81. showClose: true,
  82. });
  83. }
  84. selectBedDays(queryTerm)
  85. .then((res) => {
  86. returnData.value = res;
  87. })
  88. .catch(() => {
  89. returnData.value = [];
  90. });
  91. };
  92. const setldetails = ref([]);
  93. const showSetldetails = ref(false);
  94. const ysDaysdetails = (row) => {
  95. let selectInfo = clone(queryTerm);
  96. selectInfo.deptId = row.deptId;
  97. selectYsDaysDetails(selectInfo)
  98. .then((res) => {
  99. setldetails.value = res;
  100. showSetldetails.value = true;
  101. })
  102. .catch(() => {
  103. setldetails.value = [];
  104. });
  105. };
  106. const filterDialogTitle = computed(() => {
  107. return "管床日数医生明细";
  108. });
  109. const handleSizeChange = (val) => {
  110. pageSize.value = val;
  111. };
  112. const handleCurrentChange = (val) => {
  113. currentPage.value = val;
  114. };
  115. const currentPage = ref(1);
  116. const pageSize = ref(20);
  117. let sum = {};
  118. const getSummaries = (param) => {
  119. const { columns, data } = param;
  120. const sums = [];
  121. columns.forEach((column, index) => {
  122. if (index === 0) {
  123. sums[index] = "合计";
  124. return;
  125. }
  126. if (column.property === "doctor") {
  127. sums[index] = "";
  128. return;
  129. }
  130. const values = data.map((item) => Number(item[column.property]));
  131. if (!values.every((value) => isNaN(value))) {
  132. sums[index] = values.reduce((prev, curr) => {
  133. const value = Number(curr);
  134. if (!isNaN(value)) {
  135. return prev + curr;
  136. }
  137. else {
  138. return prev;
  139. }
  140. }, 0);
  141. }
  142. else {
  143. sums[index] = 0;
  144. }
  145. });
  146. sum = sums;
  147. return sums;
  148. };
  149. const exportExcel = () => {
  150. let title = {
  151. ryks: "科室",
  152. days: "管床日数",
  153. };
  154. const data = clone(returnData.value);
  155. let dd = { ryks: "", days: "" };
  156. dd.ryks = sum[0];
  157. dd.days = sum[1];
  158. data.push(dd);
  159. ExcelName(data, title);
  160. };
  161. const exportDetailExcel = () => {
  162. if (setldetails.value.length === 0) {
  163. ElMessage({
  164. message: "没有可以导出的数据!",
  165. type: "warning",
  166. duration: 2500,
  167. showClose: true,
  168. });
  169. }
  170. else {
  171. const title = {
  172. ryks: "科室",
  173. doctor: "医生",
  174. days: "管床日数",
  175. };
  176. const data = clone(setldetails.value);
  177. let dd = { ryks: "", doctor: "", days: "" };
  178. dd.ryks = sum[0];
  179. dd.doctor = "";
  180. dd.days = sum[2];
  181. data.push(dd);
  182. Export(data, title, filterDialogTitle.value);
  183. }
  184. };
  185. return {
  186. dateRange,
  187. shortcuts,
  188. queryTerm,
  189. returnData,
  190. tableHeight,
  191. pageSize,
  192. currentPage,
  193. filterDialogTitle,
  194. setldetails,
  195. showSetldetails,
  196. query,
  197. exportExcel,
  198. exportDetailExcel,
  199. getSummaries,
  200. ysDaysdetails,
  201. handleSizeChange,
  202. handleCurrentChange,
  203. };
  204. },
  205. components: { PageLayer }
  206. }
  207. </script>