index.vue 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511
  1. <template>
  2. <div class="p-2">
  3. <transition :enter-active-class="proxy?.animate.searchAnimate.enter" :leave-active-class="proxy?.animate.searchAnimate.leave">
  4. <div v-show="showSearch" class="mb-[20px]">
  5. <el-card shadow="hover">
  6. <el-form ref="queryFormRef" :model="queryParams" :inline="true">
  7. <el-form-item label="名称" prop="name">
  8. <el-input v-model="queryParams.name" placeholder="请输入名称" clearable @keyup.enter="handleQuery" />
  9. </el-form-item>
  10. <el-form-item label="备注" prop="description">
  11. <el-input v-model="queryParams.description" placeholder="请输入备注" clearable @keyup.enter="handleQuery" />
  12. </el-form-item>
  13. <el-form-item>
  14. <el-button type="primary" icon="Search" @click="handleQuery">搜索</el-button>
  15. <el-button icon="Refresh" @click="resetQuery">重置</el-button>
  16. </el-form-item>
  17. </el-form>
  18. </el-card>
  19. </div>
  20. </transition>
  21. <el-card shadow="never">
  22. <template #header>
  23. <el-row :gutter="10" class="mb8">
  24. <el-col :span="1.5">
  25. <el-button type="primary" plain icon="Plus" @click="handleAdd" v-hasPermi="['business:structures:add']">新增盲注表</el-button>
  26. </el-col>
  27. <el-col :span="1.5">
  28. <el-button type="success" plain icon="Edit" :disabled="single" @click="handleUpdate()" v-hasPermi="['business:structures:edit']"
  29. >修改</el-button
  30. >
  31. </el-col>
  32. <el-col :span="1.5">
  33. <el-button type="danger" plain icon="Delete" :disabled="multiple" @click="handleDelete()" v-hasPermi="['business:structures:remove']"
  34. >删除</el-button
  35. >
  36. </el-col>
  37. <el-col :span="1.5">
  38. <el-button type="warning" plain icon="Download" @click="handleExport" v-hasPermi="['business:structures:export']">导出</el-button>
  39. </el-col>
  40. <right-toolbar v-model:showSearch="showSearch" @queryTable="getList"></right-toolbar>
  41. </el-row>
  42. </template>
  43. <el-table v-loading="loading" border :data="structuresList" @selection-change="handleSelectionChange">
  44. <el-table-column type="selection" width="55" align="center" />
  45. <el-table-column label="id" align="center" prop="id" v-if="false" />
  46. <el-table-column label="名称" align="center" prop="name" />
  47. <!-- 新增列:盲注等级 -->
  48. <el-table-column label="预览" align="center" width="150">
  49. <template #default="scope">
  50. <span class="level-link" @click="handleViewLevels(scope.row)" style="color: blue; cursor: pointer; text-decoration: underline">
  51. {{ formatBlindLevel(scope.row.blindLevels) }}
  52. </span>
  53. </template>
  54. </el-table-column>
  55. <el-table-column label="备注" align="center" prop="description" />
  56. <el-table-column label="创建时间" align="center" prop="createdAt" width="180">
  57. <template #default="scope">
  58. <span>{{ parseTime(scope.row.createdAt, '{y}-{m}-{d} {h}:{i}:{s}') }}</span>
  59. </template>
  60. </el-table-column>
  61. <el-table-column label="创建人" align="center" prop="createName" />
  62. <!-- <el-table-column label="更新时间" align="center" prop="updatedAt" width="180">
  63. <template #default="scope">
  64. <span>{{ parseTime(scope.row.updatedAt, '{y}-{m}-{d} {h}:{i}:{s}') }}</span>
  65. </template>
  66. </el-table-column>-->
  67. <el-table-column label="操作" align="center" class-name="small-padding fixed-width">
  68. <template #default="scope">
  69. <el-tooltip content="修改" placement="top">
  70. <el-button link type="primary" icon="Edit" @click="handleUpdate(scope.row)" v-hasPermi="['business:structures:edit']"></el-button>
  71. </el-tooltip>
  72. <el-tooltip content="删除" placement="top">
  73. <el-button link type="primary" icon="Delete" @click="handleDelete(scope.row)" v-hasPermi="['business:structures:remove']"></el-button>
  74. </el-tooltip>
  75. <el-tooltip content="查看" placement="top">
  76. <el-button link type="primary" icon="View" @click="handleViewLevels(scope.row)" v-hasPermi="['business:levels:view']"></el-button>
  77. </el-tooltip>
  78. </template>
  79. </el-table-column>
  80. </el-table>
  81. <pagination v-show="total > 0" :total="total" v-model:page="queryParams.pageNum" v-model:limit="queryParams.pageSize" @pagination="getList" />
  82. </el-card>
  83. <!-- 添加或修改【请填写功能名称】对话框 -->
  84. <el-dialog :title="dialog.title" v-model="dialog.visible" width="500px" append-to-body @close="cancel">
  85. <el-form ref="structuresFormRef" :model="form" :rules="rules" label-width="120px">
  86. <el-form-item label="盲注表名称" prop="name">
  87. <el-input v-model="form.name" placeholder="请输入盲注表名称" />
  88. </el-form-item>
  89. <el-form-item label="上传盲注表" prop="file">
  90. <div class="upload-container">
  91. <el-upload
  92. class="upload-demo"
  93. action="#"
  94. :on-change="handleFileChange"
  95. :on-remove="handleFileRemove"
  96. :file-list="fileList"
  97. :auto-upload="false"
  98. :limit="1"
  99. accept=".xlsx,.xls"
  100. >
  101. <!-- 触发上传按钮 -->
  102. <template #trigger>
  103. <el-button type="primary">点击上传盲注表</el-button>
  104. </template>
  105. <!-- 自定义文件列表 -->
  106. <template #file="{ file }">
  107. <div style="display: flex; align-items: center">
  108. <span class="el-upload__tip">{{ file.name }}</span>
  109. <el-button type="text" icon="el-icon-delete" @click.stop="() => handleFileRemove(file)" style="margin-left: auto"> 删除 </el-button>
  110. </div>
  111. </template>
  112. <!-- 提示信息 -->
  113. <template #tip>
  114. <div class="el-upload__tip">
  115. <el-link type="primary" @click="downloadTemplate"> <i class="el-icon-download"></i> 模板下载 </el-link>
  116. |
  117. <el-button link @click="openPreview"> <i class="el-icon-document"></i> 预 览 </el-button>
  118. </div>
  119. </template>
  120. </el-upload>
  121. </div>
  122. </el-form-item>
  123. <el-form-item label="盲注表备注" prop="description">
  124. <el-input v-model="form.description" type="textarea" placeholder="请输入盲注表备注" />
  125. </el-form-item>
  126. </el-form>
  127. <template #footer>
  128. <div class="dialog-footer">
  129. <el-button :loading="buttonLoading" type="primary" @click="submitForm">确 定</el-button>
  130. <el-button @click="cancel">取 消</el-button>
  131. </div>
  132. </template>
  133. </el-dialog>
  134. <el-dialog v-model="levelsDialogVisible" title="盲注等级列表" width="80%">
  135. <!-- 使用 component 动态加载目标组件 -->
  136. <levels-index :blind-structure-id="dialogParams.blindStructureId" :name="dialogParams.name" />
  137. </el-dialog>
  138. <!-- 预览弹窗 -->
  139. <el-dialog title="预览" v-model="previewVisible" width="70%" append-to-body>
  140. <div style="max-height: 500px; overflow-y: auto">
  141. <el-table :data="previewData" border v-if="previewData.length > 0">
  142. <!-- 使用动态表头 -->
  143. <el-table-column v-for="(header, index) in previewHeaders" :key="index" :label="header">
  144. <template #default="scope">
  145. {{ scope.row[index] }}
  146. </template>
  147. </el-table-column>
  148. </el-table>
  149. <p v-else>暂无数据可预览</p>
  150. </div>
  151. <template #footer>
  152. <div class="dialog-footer">
  153. <el-button @click="closePreview">关 闭</el-button>
  154. </div>
  155. </template>
  156. </el-dialog>
  157. </div>
  158. </template>
  159. <script setup name="Structures" lang="ts">
  160. import {
  161. listStructures,
  162. getStructures,
  163. delStructures,
  164. addStructures,
  165. updateStructures,
  166. downloadImportTemplate
  167. } from '@/api/system/business/structures';
  168. import { StructuresVO, StructuresQuery, StructuresForm } from '@/api/system/business/structures/types';
  169. import { ref } from 'vue';
  170. import LevelsIndex from '@/views/system/business/levels/index.vue';
  171. import * as XLSX from 'xlsx';
  172. // 控制 Dialog 是否显示
  173. const levelsDialogVisible = ref(false);
  174. // 传递给子组件的参数
  175. const dialogParams = ref({
  176. blindStructureId: null,
  177. name: null
  178. });
  179. const { proxy } = getCurrentInstance() as ComponentInternalInstance;
  180. const structuresList = ref<StructuresVO[]>([]);
  181. const buttonLoading = ref(false);
  182. const loading = ref(true);
  183. const showSearch = ref(true);
  184. const ids = ref<Array<string | number>>([]);
  185. const single = ref(true);
  186. const multiple = ref(true);
  187. const total = ref(0);
  188. const queryFormRef = ref<ElFormInstance>();
  189. const structuresFormRef = ref<ElFormInstance>();
  190. const dialog = reactive<DialogOption>({
  191. visible: false,
  192. title: ''
  193. });
  194. const initFormData: StructuresForm = {
  195. id: undefined,
  196. name: undefined,
  197. description: undefined,
  198. taskId: undefined,
  199. updatedAt: undefined
  200. };
  201. const data = reactive<PageData<StructuresForm, StructuresQuery>>({
  202. form: { ...initFormData },
  203. queryParams: {
  204. pageNum: 1,
  205. pageSize: 10,
  206. name: undefined,
  207. description: undefined,
  208. createdAt: undefined,
  209. updatedAt: undefined,
  210. params: {}
  211. },
  212. rules: {
  213. id: [{ required: true, message: '不能为空', trigger: 'blur' }],
  214. name: [
  215. { required: true, message: '盲注结构名称不能为空', trigger: 'blur' },
  216. { max: 25, message: '名称长度不能超过25个字符', trigger: 'blur' }]
  217. }
  218. });
  219. const { queryParams, form, rules } = toRefs(data);
  220. /** 查询【请填写功能名称】列表 */
  221. const getList = async () => {
  222. loading.value = true;
  223. const res = await listStructures(queryParams.value);
  224. structuresList.value = res.rows;
  225. total.value = res.total;
  226. loading.value = false;
  227. };
  228. /** 取消按钮 */
  229. const cancel = () => {
  230. reset();
  231. dialog.visible = false;
  232. // ✅ 清空文件和预览数据
  233. fileList.value = [];
  234. previewData.value = [];
  235. previewHeaders.value = [];
  236. };
  237. /** 表单重置 */
  238. const reset = () => {
  239. form.value = { ...initFormData };
  240. structuresFormRef.value?.resetFields();
  241. };
  242. /** 搜索按钮操作 */
  243. const handleQuery = () => {
  244. queryParams.value.pageNum = 1;
  245. getList();
  246. };
  247. /** 重置按钮操作 */
  248. const resetQuery = () => {
  249. queryFormRef.value?.resetFields();
  250. handleQuery();
  251. };
  252. /** 多选框选中数据 */
  253. const handleSelectionChange = (selection: StructuresVO[]) => {
  254. ids.value = selection.map((item) => item.id);
  255. single.value = selection.length != 1;
  256. multiple.value = !selection.length;
  257. };
  258. /** 新增按钮操作 */
  259. const handleAdd = () => {
  260. reset();
  261. dialog.visible = true;
  262. dialog.title = '新增盲注表';
  263. };
  264. /** 修改按钮操作 */
  265. const handleUpdate = async (row?: StructuresVO) => {
  266. reset();
  267. const _id = row?.id || ids.value[0];
  268. const res = await getStructures(_id);
  269. Object.assign(form.value, res.data);
  270. dialog.visible = true;
  271. dialog.title = '修改盲注表';
  272. initFormData.id = row?.id || ids.value[0];
  273. };
  274. /** 提交按钮 */
  275. const submitForm = () => {
  276. structuresFormRef.value?.validate(async (valid: boolean) => {
  277. if (valid) {
  278. buttonLoading.value = true;
  279. try {
  280. const formData = new FormData();
  281. // 如果有文件,添加文件字段
  282. if (fileList.value.length > 0 && fileList.value[0].raw) {
  283. formData.append('file', fileList.value[0].raw); // 假设后端接收字段名为 'file'
  284. } else {
  285. buttonLoading.value = false;
  286. return proxy?.$modal.msgError('文件内容为空');
  287. }
  288. // 添加常规字段
  289. formData.append('name', form.value.name || '');
  290. formData.append('description', form.value.description || '');
  291. // 发送请求
  292. const uds = form.value.id;
  293. if (uds) {
  294. const json = JSON.stringify({ 'name': form.value.name || '', 'description': form.value.description || '', 'id': uds || '' });
  295. const blob = new Blob([json], { type: 'application/json' });
  296. formData.append('BlindStructuresBo', blob);
  297. await updateStructures(formData).finally(() => (buttonLoading.value = false));
  298. } else {
  299. await addStructures(formData).finally(() => (buttonLoading.value = false));
  300. }
  301. proxy?.$modal.msgSuccess('操作成功');
  302. dialog.visible = false;
  303. // ✅ 清空文件和预览数据
  304. fileList.value = [];
  305. previewData.value = [];
  306. previewHeaders.value = [];
  307. await getList();
  308. } catch (error) {
  309. proxy?.$modal.msgError('提交失败');
  310. }
  311. }
  312. });
  313. };
  314. /** 删除按钮操作 */
  315. const handleDelete = async (row?: StructuresVO) => {
  316. const _ids = row?.id || ids.value;
  317. const name = row?.name;
  318. await proxy?.$modal.confirm('是否确认删除【盲注管理】名称为"' + name + '"的数据项?').finally(() => (loading.value = false));
  319. await delStructures(_ids);
  320. proxy?.$modal.msgSuccess('删除成功');
  321. await getList();
  322. };
  323. /** 导出按钮操作 */
  324. const handleExport = () => {
  325. proxy?.download(
  326. '/business/structures/export',
  327. {
  328. ...queryParams.value
  329. },
  330. `structures_${new Date().getTime()}.xlsx`
  331. );
  332. };
  333. onMounted(() => {
  334. getList();
  335. });
  336. const formatBlindLevel = (blindLevels) => {
  337. if (!blindLevels || !Array.isArray(blindLevels) || blindLevels.length === 0) {
  338. return '—';
  339. }
  340. const firstLevel = blindLevels[0];
  341. return `${firstLevel.smallBlind}/${firstLevel.bigBlind} ${firstLevel.ante}`;
  342. };
  343. const handleViewLevels = (row) => {
  344. dialogParams.value.blindStructureId = row.id;
  345. dialogParams.value.name = row.name;
  346. levelsDialogVisible.value = true;
  347. };
  348. const downloadTemplate = async () => {
  349. try {
  350. const response = await downloadImportTemplate();
  351. // 创建 Blob 对象(直接使用 response)
  352. // 确保正确获取 blob 数据
  353. const blobData = new Blob([response.data || response], {
  354. type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
  355. });
  356. // 创建对象 URL
  357. const urlBlob = window.URL.createObjectURL(blobData);
  358. const link = document.createElement('a');
  359. link.href = urlBlob;
  360. link.setAttribute('download', '盲注结构模板.xlsx');
  361. document.body.appendChild(link);
  362. // 触发点击事件并稍作延迟,确保链接生效
  363. link.click();
  364. setTimeout(() => {
  365. link.remove();
  366. window.URL.revokeObjectURL(urlBlob);
  367. }, 0);
  368. } catch (error) {
  369. console.error('Download error:', error); // 输出具体的错误信息
  370. ElMessage.error('下载失败,请重试');
  371. }
  372. };
  373. const fileList = ref([]);
  374. const handleFileChange = (file) => {
  375. const index = fileList.value.findIndex((f) => f.uid === file.uid);
  376. // 如果文件不存在于列表中,则添加进去
  377. if (index === -1) {
  378. fileList.value.push(file);
  379. }
  380. };
  381. // 删除文件处理函数
  382. const handleFileRemove = (file) => {
  383. const index = fileList.value.findIndex((f) => f.uid === file.uid);
  384. if (index > -1) {
  385. const newFileList = [...fileList.value];
  386. newFileList.splice(index, 1);
  387. fileList.value = newFileList;
  388. }
  389. };
  390. // 预览数据
  391. const previewData = ref<any[]>([]);
  392. const previewHeaders = ref<string[]>([]); // 新增表头数组
  393. const previewVisible = ref(false); // 控制预览弹窗
  394. // 打开预览弹窗并解析文件
  395. const openPreview = () => {
  396. if (fileList.value.length === 0) {
  397. return;
  398. }
  399. const file = fileList.value[0].raw;
  400. const isValidType = ['application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'application/vnd.ms-excel'].includes(file.type);
  401. if (!isValidType) {
  402. return;
  403. }
  404. const reader = new FileReader();
  405. reader.onload = (e) => {
  406. const data = new Uint8Array(e.target?.result as ArrayBuffer);
  407. const workbook = XLSX.read(data, { type: 'array' });
  408. const sheetName = workbook.SheetNames[0];
  409. const worksheet = workbook.Sheets[sheetName];
  410. // 获取表头(第二行)
  411. const headerRow = XLSX.utils.decode_range(worksheet['!ref']).e.r + 1;
  412. const headerRange = `A2:E2`; // 假设最多5列
  413. const headerCells = XLSX.utils.decode_range(headerRange);
  414. previewHeaders.value = [];
  415. for (let C = headerCells.s.c; C <= headerCells.e.c; ++C) {
  416. const cellAddress = XLSX.utils.encode_cell({ c: C, r: 0 });
  417. const cell = worksheet[cellAddress];
  418. if (cell && cell.v) {
  419. previewHeaders.value.push(cell.v.toString());
  420. }
  421. }
  422. // 获取数据(第三行开始)
  423. const jsonData = XLSX.utils.sheet_to_json(worksheet, { header: 1, range: 1 }); // 从第3行开始读取
  424. previewData.value = jsonData;
  425. previewVisible.value = true;
  426. };
  427. reader.readAsArrayBuffer(file);
  428. };
  429. // 关闭预览弹窗
  430. const closePreview = () => {
  431. previewVisible.value = false;
  432. };
  433. /*const handleFileChange = async (file) => {
  434. const index = fileList.value.findIndex((f) => f.uid === file.uid);
  435. if (index === -1) {
  436. // 如果文件不在列表中,则添加进去
  437. fileList.value.push(file);
  438. }
  439. try {
  440. const rawFile = file.raw;
  441. const res = await importData(rawFile);
  442. if (res.code === 200) {
  443. // 更新文件状态为成功
  444. fileList.value[index] = {
  445. ...file,
  446. status: 'success',
  447. response: res
  448. };
  449. ElMessage.success('上传成功');
  450. } else {
  451. throw new Error(res.msg);
  452. }
  453. } catch (error) {
  454. // 更新文件状态为失败
  455. fileList.value[index] = {
  456. ...file,
  457. status: 'fail',
  458. error: '上传失败'
  459. };
  460. ElMessage.error('上传失败,请重试');
  461. }
  462. };*/
  463. </script>