序号

wujingjing

2024-12-31 8d83544ff6e123df4facf40c446e7d9bf4a522b6

 src/views/project/yw/lowCode/sqlAmis/SqlAmis.vue

@@ -1,101 +1,124 @@
<template>
   <HMContainer type="card" v-if="supervisorMgrShow">
   <AHMContainer type="card" v-if="supervisorMgrShow">
      <template #aside>
         <!-- 目录树 -->
         <LeftTreeByMgr
            v-loading="treeLoading"
            class="h100"
            ref="leftTreeRef"
            :defaultProps="{
               id: 'group_id',
               label: 'label',
               children: 'children',
            }"
            :treedata="listTreeData"
            title-name="场景列表"
            :show-more-operate="false"
            defaultExpandAll
            :show-add="false"
            :current-node-key="currentListID"
            :node-icon="() => 'ele-Document'"
            @click="handleClickNode"
         >
         </LeftTreeByMgr>
      </template>
      <template #header>
         <el-form ref="queryFormRef" :inline="true" :model="queryParams">
            <el-form-item label="标题" prop="title">
               <el-input v-model="queryParams.title" style="width: 226.4px" placeholder="标题" clearable />
               <el-input v-model="queryParams.title" style="width: 226.4px" placeholder="标题" clearable @input="debounceQueryTable" />
            </el-form-item>

            <el-form-item>
               <el-button type="primary" icon="ele-Search" @click="handleQueryTable"> 查询 </el-button>
               <!-- <el-button type="primary" icon="ele-Search" @click="handleQueryTable"> 查询 </el-button> -->
               <el-button icon="ele-Refresh" @click="resetQuery">重置 </el-button>
               <el-button icon="ele-Plus" @click="openOptDlg()"> 添加 </el-button>
            </el-form-item>
         </el-form>
      </template>
      <template #main>
         <!-- <div class="h-screen">
            <p>vue-json-editor</p>
            <JsonEditorVue v-model="jsonMsg"></JsonEditorVue>
         </div> -->
         <div class="h-full" ref="chatDragContainerRef">
         <div class="h-full flex-column">
            <div class="flex-0 flex">
               <ColFilter class="ml-auto" :columnList="columnList" />
            </div>
            <el-table
               v-loading="tableLoading"
               ref="draggableTableRef"
               class="h100"
               class="flex-auto"
               border
               :row-class-name="isDragStatus ? 'cursor-move' : 'cursor-pointer'"
               :data="displayTableData"
               highlight-current-row
            >
               <!-- <el-table-column type="expand" fixed="left">
               <template #default="scope">
                  <div class="px-4">
                     <h3 class="mb-2">页面参数</h3>
                     <JsonEditor currentMode="view" :modelValue="scope.row.args" />
                  </div>
               <template v-for="item in columnList" :key="item.prop">
                  <el-table-column
                     v-if="item.isShow ?? true"
                     :type="item.type"
                     :prop="item.prop"
                     :label="item.label"
                     :fixed="item.fixed"
                     :width="item.width"
                     :align="item.align"
                     showOverflowTooltip
                  >
                     <template #default="scope" v-if="item.prop === 'published'">
                        <el-tag :type="scope.row.published === SupervisorPublished.Y ? 'primary' : 'info'">{{
                           supervisorPublishedMap[scope.row.published]
                        }}</el-tag>
                     </template>

                     <template #default="scope" v-else-if="item.prop === 'operate'">
                        <div class="space-x-3 items-center flex">
                           <el-tooltip effect="dark" content="AMIS低代码编辑" placement="top">
                              <i class="ywifont ywicon-didaima !text-[21px] text-blue-400 cursor-pointer" @click="gotoAmisPage(scope.row)"></i>
                           </el-tooltip>
                           <el-tooltip effect="dark" content="数据对接" placement="top">
                              <i class="ywifont ywicon-sjdj !text-[17px] text-blue-400 cursor-pointer" @click="editSqlClick(scope.row)"></i>
                           </el-tooltip>

                           <el-tooltip effect="dark" content="对话测试" placement="top">
                              <i class="ywifont ywicon-ceshi !text-[20px] text-blue-400 cursor-pointer" @click="openChatTest(scope.row)"></i>
                           </el-tooltip>

                           <el-tooltip
                              effect="dark"
                              :content="scope.row.published === SupervisorPublished.Y ? '取消发布' : '发布'"
                              placement="top"
                           >
                              <i
                                 class="ywifont !text-[20px] cursor-pointer"
                                 :class="[
                                    scope.row.published === SupervisorPublished.Y ? 'ywicon-quxiaofabu text-red-400' : 'ywicon-fabu text-blue-400',
                                 ]"
                                 @click="
                                    publishStatusChange(
                                       scope.row.published === SupervisorPublished.Y ? SupervisorPublished.N : SupervisorPublished.Y,
                                       scope.row.id,
                                       scope.$index
                                    )
                                 "
                              ></i>
                           </el-tooltip>
                           <el-tooltip effect="dark" content="编辑" placement="top">
                              <i class="ywifont ywicon-bianji !text-[15px] text-blue-400 cursor-pointer" @click="openOptDlg(scope.row)"></i>
                           </el-tooltip>
                           <el-tooltip effect="dark" content="删除" placement="top">
                              <i
                                 class="ywifont ywicon-shanchu !text-[17px] text-red-400 cursor-pointer"
                                 @click="
                                    () => {
                                       deleteCurrentRow(scope.row, '页面', supervisorAdminApi.deleteSupervisor, () => {
                                          const foundIndex = tableData.findIndex((item) => item === scope.row);
                                          foundIndex > -1 && tableData.splice(foundIndex, 1);
                                          setCurrentLen(-1);
                                       });
                                    }
                                 "
                              ></i>
                           </el-tooltip>
                        </div>
                     </template>
                  </el-table-column>
               </template>
            </el-table-column> -->
               <!-- <el-table-column prop="id" label="id" width="130" fixed="left" show-overflow-tooltip> </el-table-column> -->

               <el-table-column prop="title" label="标题" width="300" fixed="left" show-overflow-tooltip> </el-table-column>
               <el-table-column prop="prompt" label="提示词" show-overflow-tooltip> </el-table-column>
				
               <el-table-column label="创建人" prop="creator" width="100" show-overflow-tooltip> </el-table-column>
               <el-table-column label="创建时间" prop="create_time" width="105" show-overflow-tooltip> </el-table-column>
               <el-table-column label="更新时间" prop="update_time" width="105" show-overflow-tooltip> </el-table-column>
               <el-table-column label="备注" prop="note" show-overflow-tooltip> </el-table-column>
               <el-table-column label="操作" width="200" fixed="right" show-overflow-tooltip>
                  <template #default="scope">
                     <div class="space-x-3 items-center flex">
                        <el-tooltip effect="dark" content="SQL编辑" placement="top">
                           <i class="ywifont ywicon-sql !text-[14px] text-blue-400 cursor-pointer" @click="editSqlClick(scope.row)"></i>
                        </el-tooltip>
                        <el-tooltip effect="dark" content="AMIS低代码编辑" placement="top">
                           <i class="ywifont ywicon-didaima !text-[21px] text-blue-400 cursor-pointer" @click="gotoAmisPage(scope.row)"></i>
                        </el-tooltip>
                        <el-tooltip effect="dark" content="对话测试" placement="top">
                           <i class="ywifont ywicon-ceshi !text-[20px] text-blue-400 cursor-pointer" @click="openChatTest(scope.row)"></i>
                        </el-tooltip>

                        <el-tooltip
                           effect="dark"
                           :content="scope.row.published === SupervisorPublished.Y ? '取消发布' : '发布'"
                           placement="top"
                        >
                           <i
                              class="ywifont !text-[20px] cursor-pointer"
                              :class="[
                                 scope.row.published === SupervisorPublished.Y ? 'ywicon-quxiaofabu text-red-400' : 'ywicon-fabu text-blue-400',
                              ]"
                              @click="
                                 publishStatusChange(
                                    scope.row.published === SupervisorPublished.Y ? SupervisorPublished.N : SupervisorPublished.Y,
                                    scope.row.id,
                                    scope.$index
                                 )
                              "
                           ></i>
                        </el-tooltip>
                        <el-tooltip effect="dark" content="编辑" placement="top">
                           <i class="ywifont ywicon-bianji !text-[15px] text-blue-400 cursor-pointer" @click="openOptDlg(scope.row)"></i>
                        </el-tooltip>
                        <el-tooltip effect="dark" content="删除" placement="top">
                           <i
                              class="ywifont ywicon-shanchu !text-[17px] text-red-400 cursor-pointer"
                              @click="
                                 () => {
                                    deleteCurrentRow(scope.row, '页面', supervisorAdminApi.deleteSupervisor, () => {
                                       const foundIndex = tableData.findIndex((item) => item === scope.row);
                                       foundIndex > -1 && tableData.splice(foundIndex, 1);
                                    });
                                 }
                              "
                           ></i>
                        </el-tooltip>
                     </div>
                  </template>
               </el-table-column>
            </el-table>
            <div
               v-if="chatTestIsShow"
@@ -117,48 +140,316 @@
         </div>
      </template>

      <OptDlg v-model="optDlgIsShow" :item="optDlgMapRow" @insert="insertOpt" @update="updateOpt"></OptDlg>
   </HMContainer>
   <SqlAmisEdit v-else :supervisor="sqlEditMapSupervisor" @backLastPage="backLastPage"></SqlAmisEdit>
      <OptDlg v-model="optDlgIsShow" :item="optDlgMapRow" @insert="insertOpt" @update="updateOpt" :groupId="currentListID"></OptDlg>

      <!-- 增加、修改数据对话框 -->
      <el-dialog
         :destroy-on-close="true"
         v-model="moduleDialogIsShow"
         width="300"
         :close-on-click-modal="false"
         @closed="closeModuleDialog"
      >
         <template #header>
            <div style="color: #fff">
               <SvgIcon :name="moduleDialogHeaderIcon" :size="16" style="margin-right: 3px; display: inline; vertical-align: middle" />
               <span> {{ moduleDialogTitle }} </span>
            </div>
         </template>

         <el-form :model="moduleDialogFormValue" ref="moduleDialogFormRef" :rules="moduleDialogFormRules" label-width="55">
            <el-form-item label="名称" prop="title">
               <el-input placeholder="请输入名称" v-model="moduleDialogFormValue.title"></el-input>
            </el-form-item>
            <el-form-item label="父级" prop="parent_id" v-if="!isEditModuleDialog">
               <el-tree-select
                  filterable
                  class="w100"
                  v-model="moduleDialogFormValue.parent_id"
                  :props="{
                     id: 'id',
                     label: 'title',
                     children: 'children',
                  }"
                  defaultExpandAll
                  :data="parentSelectOptions"
                  node-key="id"
                  :clearable="true"
                  :accordion="false"
                  :expandNode="false"
                  :check-strictly="true"
                  placeholder="请选择父级"
               >
               </el-tree-select>
            </el-form-item>
         </el-form>
         <template #footer>
            <div>
               <el-button @click="closeModuleDialog">取 消</el-button>
               <el-button type="primary" @click="submitModuleFormValue">确 定</el-button>
            </div>
         </template>
      </el-dialog>
   </AHMContainer>
   <SqlAmisEdit
      v-else
      :supervisor="sqlEditMapSupervisor"
      @backLastPage="backLastPage"
      @updatePublished="updatePublishedById"
   ></SqlAmisEdit>
</template>

<script setup lang="ts">
import { deleteCurrentRow } from '/@/utils/util';
import { useDraggable } from '@vueuse/core';
import { debounce, deleteCurrentRow, travelTree } from '/@/utils/util';

import { onMounted, ref } from 'vue';
import HMContainer from '/@/components/layout/HMContainer.vue';
import { computed, onMounted, ref } from 'vue';
import { usePageDisplay } from '/@/hooks/usePageDisplay';
import { useQueryTable } from '/@/hooks/useQueryTable';
// import { useTableSort } from '/@/hooks/useTableSort';
// import { useValidateUniqueness } from '/@/hooks/useValidateUniqueness';
import Chat from '/@/components/chat/Chat.vue';
import type { CancelTokenSource } from 'axios';
import axios from 'axios';
import type { FormInstance, FormRules } from 'element-plus';
import { ElMessage, ElMessageBox } from 'element-plus';
import { nextTick } from 'vue';
import SqlAmisEdit from './edit/SqlAmisEdit.vue';
import OptDlg from './optDlg/OptDlg.vue';
import { SupervisorPublished, supervisorPublishedMap } from './types';
import * as agentGroupApi from '/@/api/ai/agentGroup';
import * as supervisorAdminApi from '/@/api/supervisorAdmin';
import { checkSupervisorValidate, updatePublishStatus } from '/@/api/supervisorAdmin';
import JsonEditor from '/@/components/form/jsonEditor/JsonEditor.vue';
import amisLogo from '/@/assets/logo/amis-logo.png';
import * as supervisorGroupApi from '/@/api/supervisorAdmin/supervisorGroup';
import Chat from '/@/components/chat/Chat.vue';
import AHMContainer from '/@/components/layout/AHMContainer.vue';
import ColFilter from '/@/components/table/colFilter/ColFilter.vue';
import type { TableCol } from '/@/components/table/colFilter/types';
import LeftTreeByMgr from '/@/components/tree/leftTreeByMgr.vue';
import { useUpdateData } from '/@/hooks/useUpdateData';
import emitter from '/@/utils/mitt';
import { deepClone } from '/@/utils/other';
import { gotoRoute } from '/@/utils/route';
import { useCompRef } from '/@/utils/types';
import { nextTick } from 'vue';
import { ElMessage } from 'element-plus';
import { convertListToTree } from '/@/utils/util';
import { OptClassificationMap, classificationEnum } from '/@/views/types/metrics';

const columnList = ref<TableCol[]>([
   { type: 'index', label: '序号', width: 55, fixed: 'left', align: 'center' },
   { prop: 'title', label: '标题', width: 300, fixed: 'left' },
   { prop: 'published', label: '发布状态', width: 85 },
   { prop: 'prompt', label: '提示词', width: 300 },
   { prop: 'question', label: '问题', width: 300 },
   { prop: 'creator', label: '创建人', width: 100 },
   { prop: 'create_time', label: '创建时间', width: 105 },
   { prop: 'update_time', label: '更新时间', width: 105 },
   { prop: 'note', label: '备注' },
   { prop: 'operate', label: '操作', width: 200, fixed: 'right' },
]);

//#region ====================== 左侧树数据，tree init ======================
const leftTreeRef = useCompRef(LeftTreeByMgr);
const treeLoading = ref(false);
const listData = ref([]);
const currentListID = computed(() => currentNode.value?.group_id);
const currentNode = ref(null);

const listTreeData = computed(() => {
   const byParentData = convertListToTree(listData.value, {
      ID: 'group_id',
      ParentID: 'p_group_id',
      Children: 'children',
   });
   const result = [];
   byParentData.forEach((item) => {
      if (
         item.group_type != OptClassificationMap[classificationEnum.Office] &&
         item.group_type != OptClassificationMap[classificationEnum.Knowledge]
      ) {
         result.push(item);
      }
   });
   return result;
});

const updateRelatedType = (extendType) => {
   emitter.emit('basic.sys.type.update', {
      ExtendType: extendType,
   });
};
const handleClickNode = (data) => {
   nextTick(() => {
      leftTreeRef.value?.treeRef.setCurrentKey(data.id);
   });
   currentNode.value = data;
   getTableData();
};
const getListTreeData = async () => {
   const res = await agentGroupApi.getSceneGroupTreeByPost();
   listData.value = res.groups || [];
   const firstListTreeNode = listTreeData.value[0];
   if (firstListTreeNode) {
      handleClickNode(firstListTreeNode);
   } else {
      tableData.value = [];
      currentNode.value = null;
   }
};
//#endregion

//#region ====================== 删除左侧树系统模块数据 ======================

const deleteCurrentModule = (row: any) => {
   ElMessageBox.confirm(`确定删除页面分组：【${row.title}】?`, '提示', {
      confirmButtonText: '确定',
      cancelButtonText: '取消',
      type: 'warning',
   }).then(async () => {
      const res = await supervisorGroupApi.deleteSupervisorGroup({
         group_id: row.id,
      });
      ElMessage.success('删除成功！');
      const foundIndex = listData.value.findIndex((item) => row.id === item.id);
      listData.value.splice(foundIndex, 1);
      if (listData.value.length > 0) {
         handleClickNode(listData.value[foundIndex]);
      }
   });
};
//#endregion

//#region ====================== 增加、删除系统模块操作, dialog init======================
const isEditModuleDialog = ref(false);
const moduleDialogTitle = computed(() => {
   return isEditModuleDialog.value ? '修改页面分组' : '添加页面分组';
});
const moduleDialogHeaderIcon = computed(() => {
   return isEditModuleDialog.value ? 'ele-Edit' : 'ele-Plus';
});
const moduleDialogFormValue = ref({
   Name: '',
   Code: '',
   Description: '',
}) as any;
const moduleDialogIsShow = ref(false);
const moduleDialogFormRef = ref<FormInstance>(null);

const moduleDialogFormRules = ref<FormRules>({
   title: [{ required: true, message: '请输入标题', trigger: 'blur' }],
});
const openOperateModuleDialog = (data?) => {
   if (data) {
      isEditModuleDialog.value = true;
      const { id, title } = data;
      moduleDialogFormValue.value = deepClone({ group_id: id, title });
   } else {
      isEditModuleDialog.value = false;
      moduleDialogFormValue.value = { title: '', parent_id: '' };
   }
   moduleDialogIsShow.value = true;
};

const closeModuleDialog = () => {
   moduleDialogIsShow.value = false;
   moduleDialogFormRef.value.clearValidate();
};
const parentSelectOptions = computed(() => {
   const cloneTreeData = deepClone(listTreeData.value);
   travelTree(cloneTreeData, (value, index, array, parent) => {
      if ((value as any).id === moduleDialogFormValue.value.id) {
         if (parent === array) {
            parent?.splice(index, 1);
         } else {
            parent?.Children?.splice(index, 1);
         }
      }
   });
   return cloneTreeData;
});

const submitModuleFormValue = async () => {
   const valid = await moduleDialogFormRef.value.validate().catch(() => {});
   if (!valid) return;

   if (isEditModuleDialog.value) {
      const res = await supervisorGroupApi.updateSupervisorGroup(moduleDialogFormValue.value);
      const foundIndex = listData.value.findIndex((item) => item.id === moduleDialogFormValue.value.id);
      if (foundIndex > -1) {
         listData.value[foundIndex] = {
            ...listData.value[foundIndex],
            title: moduleDialogFormValue.value.title,
         };
      }
      getListTreeData();
      moduleDialogIsShow.value = false;
      ElMessage.success('修改页面分组成功');
   } else {
      const res = await supervisorGroupApi.addSupervisorGroup(moduleDialogFormValue.value);
      const newNode = {
         ...moduleDialogFormValue.value,
         id: res.group_id,
         parent: moduleDialogFormValue.value.parent_id,
      };
      Reflect.deleteProperty(newNode, 'parent_id');
      listData.value.push(newNode);
      handleClickNode(newNode);
      moduleDialogIsShow.value = false;
      ElMessage.success('添加页面分组成功');
   }
};
//#endregion

//#region ====================== 表格数据，table init ======================

const setCurrentLen = (offset: 1 | -1) => {
   currentNode.value.label = `${currentNode.value.group_name} (${tableData.value.length})`;
   const pId = currentNode.value.p_group_id;
   if (pId) {
      travelTree(listTreeData.value, (value) => {
         if (value.group_id === pId) {
            value.len += offset;
            value.label = `${value.group_name} (${value.len})`;
            return true;
         }
      });
   }
   // 修改名称后，不知道为什么会失去 current 选中
   setTimeout(() => {
      leftTreeRef.value?.treeRef.setCurrentKey(currentListID.value);
   }, 0);
};
const setListLen = () => {
   travelTree(listTreeData.value, (value, index, array, parent) => {
      const id = value.group_id;
      const len = allTableData.value.filter(
         (item) => item.group_id === id || value.children?.some((treeItem) => treeItem.group_id === item.group_id)
      ).length;
      value.len = len;
      value.label = `${value.group_name} (${len})`;
   });
   // 修改名称后，不知道为什么会失去 current 选中
   setTimeout(() => {
      leftTreeRef.value?.treeRef.setCurrentKey(currentListID.value);
   }, 0);
};
const tableLoading = ref(false);
const tableData = ref([]);
const isDragStatus = ref(false);
const allTableData = ref(null);
const getTableData = async () => {
   tableLoading.value = true;
   const res = await supervisorAdminApi.getSupervisorList().finally(() => {
      tableLoading.value = false;
   });
   tableData.value = (res.values || []).map((item) => {
      item.create_time = item.create_time?.slice(0, 10);
      item.update_time = item.update_time?.slice(0, 10);
   if (!allTableData.value) {
      const res = await supervisorAdminApi.getSupervisorList();
      allTableData.value = (res.values || []).map((item) => {
         item.create_time = item.create_time?.slice(0, 10);
         item.update_time = item.update_time?.slice(0, 10);

      return item;
   });
         return item;
      });
      setListLen();
   }
   tableData.value = allTableData.value.filter(
      (item) =>
         item.group_id === currentListID.value || currentNode.value.children?.some((treeItem) => treeItem.group_id === item.group_id)
   );
};
//#endregion

@@ -170,7 +461,7 @@
const { resetQuery, handleQueryTable, displayTableData } = useQueryTable(tableData, queryParams, () => {
   displayTableData.value = tableData.value;
});

const debounceQueryTable = debounce(handleQueryTable, 400);
//#endregion

//#region ====================== 查询快捷键 ======================
@@ -201,6 +492,9 @@

const backLastPage = () => {
   supervisorMgrShow.value = true;
   nextTick(() => {
      leftTreeRef.value?.treeRef.setCurrentKey(currentListID.value);
   });
};
//#endregion

@@ -224,17 +518,39 @@

const insertOpt = (newData) => {
   tableData.value.unshift({ ...newData, published: SupervisorPublished.N });
   allTableData.value.unshift({ ...newData, published: SupervisorPublished.N });

   setCurrentLen(1);
};
//#endregion

const updatePublishedById = (id: string, published: SupervisorPublished) => {
   const row = tableData.value.find((item) => item.id === id);
   if (row) {
      row.published = published;
   }
};
//#region ====================== 改变发布状态 ======================
const publishStatusChange = async (published: SupervisorPublished, id, index) => {
   const res = await updatePublishStatus({
      id: id,
      publish: published,
   });
   const origin = published ? SupervisorPublished.N : SupervisorPublished.Y;
   displayTableData.value[index].published = res.publish ?? origin;
   published===SupervisorPublished.Y ? ElMessage.success('发布成功'):ElMessage.info('已取消发布')
   const res = await updatePublishStatus(
      {
         id: id,
         publish: published,
      },
      {
         loading: false,
      }
   );
   const origin = published === SupervisorPublished.Y ? SupervisorPublished.N : SupervisorPublished.Y;
   const final = res.publish ?? origin;
   if (final === origin) {
      ElMessage.warning('操作失败' + (res.fail_msg ? `：${res.fail_msg}` : ''));
      return;
   }

   tableData.value[index].published = final;

   published === SupervisorPublished.Y ? ElMessage.success('发布成功') : ElMessage.info('已取消发布');
};
//#endregion

@@ -258,7 +574,9 @@

   nextTick(() => {
      chatRef.value.clear();
      chatRef.value.autoSend(row.prompt);
      setTimeout(() => {
         chatRef.value.autoSend(row.question);
      }, 30);
   });
};

@@ -269,7 +587,6 @@

const draggableChatRef = ref<HTMLElement | null>(null);
const chatDragHandlerRef = ref<HTMLDivElement>(null);
const chatDragContainerRef = ref<HTMLDivElement>(null);

// `style` will be a helper computed for `left: ?px; top: ?px;`
const { x, y, style } = useDraggable(draggableChatRef, {
@@ -280,7 +597,9 @@
   },
});

const questionAi = async (text) => {
const questionAi = async (text, sourceObj: { source: CancelTokenSource }) => {
   const currentSource = axios.CancelToken.source();
   sourceObj.source = currentSource;
   const res = await checkSupervisorValidate(
      {
         id: chatTestMapRow.value.id,
@@ -288,13 +607,23 @@
      },
      {
         loading: false,
         cancelToken: currentSource.token,
      }
   );
   return res;
};
//#endregion

//#region ====================== 更新发布状态 ======================
useUpdateData({
   event: 'supervisor.publish',
   updateFun({ id, published }) {
      updatePublishedById(id, published);
   },
});
//#endregion
onMounted(() => {
   getTableData();
   getListTreeData();
});
</script>
<style scoped lang="scss"></style>