From 1f93e9c7d05f3a62009a37f5d4b2534b1568621c Mon Sep 17 00:00:00 2001
From: 潘志宝 <979469083@qq.com>
Date: 星期四, 12 九月 2024 17:27:40 +0800
Subject: [PATCH] 数据集配置
---
src/api/data/ind/data/data.field.ts | 35 +++++
src/api/data/ind/data/data.set.ts | 40 +++++
src/views/data/ind/data/index.vue | 161 +++++++++++++++++++++++
src/views/data/ind/data/DataSetForm.vue | 129 ++++++++++++++++++
4 files changed, 365 insertions(+), 0 deletions(-)
diff --git a/src/api/data/ind/data/data.field.ts b/src/api/data/ind/data/data.field.ts
new file mode 100644
index 0000000..ae4e230
--- /dev/null
+++ b/src/api/data/ind/data/data.field.ts
@@ -0,0 +1,35 @@
+import request from '@/config/axios'
+
+export type DataSetFieldVO = {
+ id: number | undefined
+ dataSetId: string
+ fieldCode: string
+ fieldName: string
+ fieldType: string
+ sort: number
+}
+
+// 查询列表
+export const getDataSetFieldPage = (params: PageParam) => {
+ return request.get({ url: '/data/ind/data-set-field/page', params })
+}
+
+// 查询详情
+export const getDataSetField = (id: number) => {
+ return request.get({ url: '/data/ind/data-set-field/get?id=' + id })
+}
+
+// 新增
+export const createDataSetField = (data: DataSetFieldVO) => {
+ return request.post({ url: '/data/ind/data-set-field/create', data })
+}
+
+// 修改
+export const updateDataSetField = (data: DataSetFieldVO) => {
+ return request.put({ url: '/data/ind/data-set-field/update', data })
+}
+
+// 删除
+export const deleteDataSetField = (id: number) => {
+ return request.delete({ url: '/data/ind/data-set-field/delete?id=' + id })
+}
diff --git a/src/api/data/ind/data/data.set.ts b/src/api/data/ind/data/data.set.ts
new file mode 100644
index 0000000..371f9db
--- /dev/null
+++ b/src/api/data/ind/data/data.set.ts
@@ -0,0 +1,40 @@
+import request from '@/config/axios'
+
+export type DataSetVO = {
+ id: number | undefined
+ name: string
+ dataSource: string
+ querySql: string
+ remark: string
+ sort: number
+}
+
+// 查询列表
+export const getDataSetList = () => {
+ return request.get({ url: '/data/ind/data-set/list-all-simple' })
+}
+
+// 查询列表
+export const getDataSetPage = (params: PageParam) => {
+ return request.get({ url: '/data/ind/data-set/page', params })
+}
+
+// 查询详情
+export const getDataSet = (id: number) => {
+ return request.get({ url: '/data/ind/data-set/get?id=' + id })
+}
+
+// 新增
+export const createDataSet = (data: DataSetVO) => {
+ return request.post({ url: '/data/ind/data-set/create', data })
+}
+
+// 修改
+export const updateDataSet = (data: DataSetVO) => {
+ return request.put({ url: '/data/ind/data-set/update', data })
+}
+
+// 删除
+export const deleteDataSet = (id: number) => {
+ return request.delete({ url: '/data/ind/data-set/delete?id=' + id })
+}
diff --git a/src/views/data/ind/data/DataSetForm.vue b/src/views/data/ind/data/DataSetForm.vue
new file mode 100644
index 0000000..132e25c
--- /dev/null
+++ b/src/views/data/ind/data/DataSetForm.vue
@@ -0,0 +1,129 @@
+<template>
+ <Dialog v-model="dialogVisible" :title="dialogTitle">
+ <el-form
+ ref="formRef"
+ v-loading="formLoading"
+ :model="formData"
+ :rules="formRules"
+ label-width="80px"
+ >
+ <el-form-item label="名称" prop="name">
+ <el-input v-model="formData.name" placeholder="请输入名称" />
+ </el-form-item>
+ <el-form-item label="数据源" prop="dataSource">
+ <el-select v-model="formData.dataSource" clearable placeholder="请选择数据源">
+ <el-option
+ v-for="item in dataSourceList"
+ :key="item.id"
+ :label="item.name"
+ :value="item.id + ''"
+ />
+ </el-select>
+ </el-form-item>
+ <el-form-item label="查询语句" prop="querySql">
+ <el-input v-model="formData.querySql" placeholder="请输入内容" type="textarea" maxlength="200"
+ show-word-limit spellcheck="false"/>
+ </el-form-item>
+ <el-form-item label="备注" prop="remark">
+ <el-input v-model="formData.remark" placeholder="请输入内容" type="textarea" maxlength="100"
+ show-word-limit/>
+ </el-form-item>
+ </el-form>
+ <template #footer>
+ <el-button :disabled="formLoading" type="primary" @click="submitForm">确 定</el-button>
+ <el-button @click="dialogVisible = false">取 消</el-button>
+ </template>
+ </Dialog>
+</template>
+<script lang="ts" setup>
+ import { DICT_TYPE, getIntDictOptions } from '@/utils/dict'
+ import * as DataSetApi from '@/api/data/ind/data/data.set'
+ import { CommonStatusEnum } from '@/utils/constants'
+ import * as DataSourceConfigApi from "@/api/infra/dataSourceConfig";
+
+ defineOptions({ name: 'IndDataSetForm' })
+
+ const { t } = useI18n() // 国际化
+ const message = useMessage() // 消息弹窗
+
+ const dialogVisible = ref(false) // 弹窗的是否展示
+ const dialogTitle = ref('') // 弹窗的标题
+ const formLoading = ref(false) // 表单的加载中：1）修改时的数据加载；2）提交的按钮禁用
+ const formType = ref('') // 表单的类型：create - 新增；update - 修改
+ const formData = ref({
+ id: undefined,
+ name: '',
+ dataSource: '',
+ querySql: '',
+ remark: ''
+ })
+ const formRules = reactive({
+ name: [{ required: true, message: '名称不能为空', trigger: 'blur' }],
+ dataSource: [{ required: true, message: '数据源不能为空', trigger: 'blur' }],
+ querySql: [{ required: true, message: '查询语句不能为空', trigger: 'change' }]
+ })
+ const formRef = ref() // 表单 Ref
+ const dataSourceList = ref([] as DataSourceConfigApi.DataSourceConfigVO[])
+
+ /** 打开弹窗 */
+ const open = async (type: string, id?: number) => {
+ dialogVisible.value = true
+ dialogTitle.value = t('action.' + type)
+ formType.value = type
+ resetForm()
+
+ // 加载数据源列表
+ dataSourceList.value = await DataSourceConfigApi.getDataSourceConfigList()
+
+ // 修改时，设置数据
+ if (id) {
+ formLoading.value = true
+ try {
+ formData.value = await DataSetApi.getDataSet(id)
+ } finally {
+ formLoading.value = false
+ }
+ }
+
+
+ }
+ defineExpose({ open }) // 提供 open 方法，用于打开弹窗
+
+ /** 提交表单 */
+ const emit = defineEmits(['success']) // 定义 success 事件，用于操作成功后的回调
+ const submitForm = async () => {
+ // 校验表单
+ if (!formRef) return
+ const valid = await formRef.value.validate()
+ if (!valid) return
+ // 提交请求
+ formLoading.value = true
+ try {
+ const data = formData.value as DataSetApi.DataSetVO
+ if (formType.value === 'create') {
+ await DataSetApi.createDataSet(data)
+ message.success(t('common.createSuccess'))
+ } else {
+ await DataSetApi.updateDataSet(data)
+ message.success(t('common.updateSuccess'))
+ }
+ dialogVisible.value = false
+ // 发送操作成功的事件
+ emit('success')
+ } finally {
+ formLoading.value = false
+ }
+ }
+
+ /** 重置表单 */
+ const resetForm = () => {
+ formData.value = {
+ id: undefined,
+ name: '',
+ dataSource: '',
+ querySql: '',
+ remark: ''
+ }
+ formRef.value?.resetFields()
+ }
+</script>
diff --git a/src/views/data/ind/data/index.vue b/src/views/data/ind/data/index.vue
new file mode 100644
index 0000000..41df56d
--- /dev/null
+++ b/src/views/data/ind/data/index.vue
@@ -0,0 +1,161 @@
+<template>
+ <!-- 搜索工作栏 -->
+ <ContentWrap>
+ <el-form
+ ref="queryFormRef"
+ :inline="true"
+ :model="queryParams"
+ class="-mb-15px"
+ label-width="68px"
+ >
+ <el-form-item label="名称" prop="name">
+ <el-input
+ v-model="queryParams.name"
+ class="!w-240px"
+ clearable
+ placeholder="请输入名称"
+ @keyup.enter="handleQuery"
+ />
+ </el-form-item>
+ <el-form-item>
+ <el-button @click="handleQuery">
+ <Icon class="mr-5px" icon="ep:search" />
+ 搜索
+ </el-button>
+ <el-button @click="resetQuery">
+ <Icon class="mr-5px" icon="ep:refresh" />
+ 重置
+ </el-button>
+ <el-button
+ v-hasPermi="['system:dict:create']"
+ plain
+ type="primary"
+ @click="openForm('create')"
+ >
+ <Icon class="mr-5px" icon="ep:plus" />
+ 新增
+ </el-button>
+ </el-form-item>
+ </el-form>
+ </ContentWrap>
+
+ <!-- 列表 -->
+ <ContentWrap>
+ <el-table v-loading="loading" :data="list">
+ <el-table-column align="center" label="名称" prop="name" show-overflow-tooltip />
+ <el-table-column align="center" label="备注" prop="remark" />
+ <el-table-column
+ :formatter="dateFormatter"
+ align="center"
+ label="创建时间"
+ prop="createTime"
+ width="180"
+ />
+ <el-table-column align="center" label="操作">
+ <template #default="scope">
+ <el-button
+ v-hasPermi="['system:dict:update']"
+ link
+ type="primary"
+ @click="openForm('update', scope.row.id)"
+ >
+ 修改
+ </el-button>
+ <router-link :to="'/ind/data/field/' + scope.row.type">
+ <el-button link type="primary">字段</el-button>
+ </router-link>
+ <el-button
+ v-hasPermi="['system:dict:delete']"
+ link
+ type="danger"
+ @click="handleDelete(scope.row.id)"
+ >
+ 删除
+ </el-button>
+ </template>
+ </el-table-column>
+ </el-table>
+ <!-- 分页 -->
+ <Pagination
+ v-model:limit="queryParams.pageSize"
+ v-model:page="queryParams.pageNo"
+ :total="total"
+ @pagination="getList"
+ />
+ </ContentWrap>
+
+ <!-- 表单弹窗：添加/修改 -->
+ <DataSetForm ref="formRef" @success="getList" />
+</template>
+
+<script lang="ts" setup>
+ import { DICT_TYPE, getIntDictOptions } from '@/utils/dict'
+ import { dateFormatter } from '@/utils/formatTime'
+ import * as DataSetApi from '@/api/data/ind/data/data.set'
+ import DataSetForm from './DataSetForm.vue'
+ import download from '@/utils/download'
+
+ defineOptions({ name: 'IndDataSet' })
+
+ const message = useMessage() // 消息弹窗
+ const { t } = useI18n() // 国际化
+
+ const loading = ref(true) // 列表的加载中
+ const total = ref(0) // 列表的总页数
+ const list = ref([]) // 字典表格数据
+ const queryParams = reactive({
+ pageNo: 1,
+ pageSize: 10,
+ name: ''
+ })
+ const queryFormRef = ref() // 搜索的表单
+ const exportLoading = ref(false) // 导出的加载中
+
+ /** 查询字典类型列表 */
+ const getList = async () => {
+ loading.value = true
+ try {
+ const data = await DataSetApi.getDataSetPage(queryParams)
+ list.value = data.list
+ total.value = data.total
+ } finally {
+ loading.value = false
+ }
+ }
+
+ /** 搜索按钮操作 */
+ const handleQuery = () => {
+ queryParams.pageNo = 1
+ getList()
+ }
+
+ /** 重置按钮操作 */
+ const resetQuery = () => {
+ queryFormRef.value.resetFields()
+ handleQuery()
+ }
+
+ /** 添加/修改操作 */
+ const formRef = ref()
+ const openForm = (type: string, id?: number) => {
+ formRef.value.open(type, id)
+ }
+
+ /** 删除按钮操作 */
+ const handleDelete = async (id: number) => {
+ try {
+ // 删除的二次确认
+ await message.delConfirm()
+ // 发起删除
+ await DataSetApi.deleteDataSet(id)
+ message.success(t('common.delSuccess'))
+ // 刷新列表
+ await getList()
+ } catch {}
+ }
+
+ /** 初始化 **/
+ onMounted(() => {
+ getList()
+ })
+</script>
--
Gitblit v1.9.3