提交查询基础数据缓慢问题

guoyujie

2025-05-16 65232e8416d83a977936aa8754c6c662132a1be5

提交查询基础数据缓慢问题

 north-glass-erp/northglass-erp/src/components/pp/Optimization.vue

New file
@@ -0,0 +1,11 @@
<script setup>

</script>

<template>
  <canvas id="canvas"></canvas>
</template>

<style scoped>

</style>

 north-glass-erp/northglass-erp/src/views/sd/basicData/SearchBasicData.vue

@@ -154,7 +154,7 @@
    {title: t('basicData.operate'), width: 110, slots: { default: 'button_slot' },fixed:"left",},
    {type: 'seq', title: t('basicData.number'), width: 80 ,fixed:"left",},
    {field:'basicName',title: t('orderBasicData.name'),filters: [{data: ''}],slots: {filter: 'num1_filter'},filterMethod: filterChanged},
    {field:'nickname',title: t('orderBasicData.alias')},
    {field:'nickname',title: t('orderBasicData.alias'),slots: { default: 'showNickname' }},
    {field:'createTime',title: t('basicData.creationTime')},


@@ -278,6 +278,12 @@
          </el-popconfirm>
        </template>

        <template #showNickname="{ row }">
          <span v-if="row.basicCategory==='icon' && row.nickname!=null">picture</span>
          <span v-else>{{row.nickname}}</span>

        </template>

        <template #num1_filter="{ column, $panel }">
          <div>
            <div v-for="(option, index) in column.filters" :key="index">

 north-glass-erp/src/main/java/com/example/erp/service/sd/BasicDateService.java

@@ -31,7 +31,7 @@
    public Map<String, List<Object>> getOrderBasicData() {
        //获取订单基本数据类型
        //创建Map对象
        Map<String, List<Object>> orderBasicDataMap = new HashMap<>(); ;
        Map<String, List<Object>> orderBasicDataMap = new HashMap<>();
        //创建List对象
        orderBasicDataMap = getBasicDataByType("order");


 north-glass-erp/src/main/resources/mapper/sd/BasicDataMapper.xml

@@ -5,7 +5,7 @@
<mapper namespace="com.example.erp.mapper.sd.BasicDateMapper">
    <select id="getOrderBasicData">
        select
            *
            id,basic_type,if(basic_category='icon',null,nickname) as 'nickname',basic_name,basic_category,create_time,update_time
        from
            basic_data as a
        where a.basic_type=#{type}