opt_web/src/views/store-manage/online-merchandise/component/DataTable.vue

<script lang="ts" setup>
/**
 * @Name: Table.vue
 * @Description: 市场店铺表格
 * @Author: Cheney
 */

import { Download, InfoFilled, Refresh } from '@element-plus/icons-vue';
import { usePagination } from '/@/utils/usePagination';
import { useTableData } from '/@/utils/useTableData';
import { OnlineMerchandiseColumns } from '/@/views/store-manage/Columns';
import DataTableSlot from './DataTableSlot.vue';
import * as api from '../api';
import { ElMessage } from 'element-plus';


interface Parameter {
  country: string,
  shop: string,
  region: string,
  delivery: string,
  status: string,
  asin: string,
  sku: string
}

const queryParameter: Parameter | undefined = inject('query-parameter');
const { tableOptions, handlePageChange } = usePagination(fetchList);

const gridRef = ref();
const gridOptions: any = reactive({
  id: 'online-merchandise-table',
  keepSource: true,
  size: 'small',
  border: false,
  round: true,
  stripe: true,
  currentRowHighLight: true,
  height: '100%',
  customConfig: {
    storage: {
      visible: true
    }
  },
  toolbarConfig: {
    size: 'large',
    custom: true,
    slots: {
      tools: 'toolbar_tools'
    }
  },
  rowConfig: {
    isHover: true
  },
  columnConfig: {
    resizable: true
  },
  pagerConfig: {
    total: tableOptions.value.total,
    page: tableOptions.value.page,
    limit: tableOptions.value.limit
  },
  loading: false,
  loadingConfig: {
    icon: 'vxe-icon-indicator roll',
    text: '正在拼命加载中...'
  },
  columns: '',
  data: ''
});

onMounted(() => {
  fetchList();
});

async function fetchList() {
  gridOptions.data = [];
  gridOptions.columns = [];

  const query = {
    asin: queryParameter?.asin,
    sku: queryParameter?.sku,
    country_code: queryParameter?.country,
    shop_id: queryParameter?.shop,
    region: queryParameter?.region,
    delivery: queryParameter?.delivery,
    status: queryParameter?.status
  };

  await useTableData(api.getTableData, query, gridOptions);
  await gridRef.value.loadColumn(OnlineMerchandiseColumns);
  gridOptions.showHeader = Boolean(gridOptions.data?.length);
}

function handleRefresh() {
  fetchList();
}

async function handleDownload() {
  gridOptions.loading = true;
  try {
    const query = {
      asin: queryParameter?.asin,
      sku__startswith: queryParameter?.sku,
      country_code: queryParameter?.country,
      shop_id: queryParameter?.shop,
      shop__region: queryParameter?.region,
      fulfillment_channel: queryParameter?.delivery,
      status: queryParameter?.status
    };
    const response = await api.exportData(query);
    const url = window.URL.createObjectURL(new Blob([ response.data ]));
    const link = document.createElement('a');
    link.href = url;
    link.setAttribute('download', '在线商品数据.xlsx');
    document.body.appendChild(link);
    link.click();
    ElMessage.success('数据导出成功！');
  } catch (error) {
    ElMessage.error('数据导出失败，请重试！');
    console.error(error);
  } finally {
    gridOptions.loading = false;
  }
}

defineExpose({ fetchList });
</script>

<template>
  <vxe-grid ref="gridRef" v-bind="gridOptions">

    <!-- 工具栏右侧 -->
    <template #toolbar_tools>
      <el-button circle class="toolbar-btn" @click="handleRefresh">
        <el-icon>
          <Refresh />
        </el-icon>
      </el-button>
      <el-popconfirm
          :icon="InfoFilled"
          icon-color="#626AEF"
          title="是否确认导出当前时间内所有数据项?"
          width="220"
          @confirm="handleDownload"
      >
        <template #reference>
          <el-button circle class="mr-3 toolbar-btn">
            <el-icon>
              <Download />
            </el-icon>
          </el-button>
        </template>
        <template #actions="{ confirm, cancel }">
          <el-button size="small" @click="cancel">No!</el-button>
          <el-button
              size="small"
              type="danger"
              @click="confirm"
          >
            Yes?
          </el-button>
        </template>
      </el-popconfirm>
    </template>
    <template #pager>
      <vxe-pager
          v-model:currentPage="gridOptions.pagerConfig.page"
          v-model:pageSize="gridOptions.pagerConfig.limit"
          :total="gridOptions.pagerConfig.total"
          class="mt-1.5"
          @page-change="handlePageChange"
      />
    </template>
    <template #empty>
      <el-empty description="暂无数据" />
    </template>
    <!-- 自定义列插槽 -->
    <template v-for="col in OnlineMerchandiseColumns" #[`${col.field}`]="{ row }">
      <DataTableSlot :key="row.id" :field="col.field" :row="row" />
    </template>
  </vxe-grid>
</template>

<style scoped>
.toolbar-btn {
  width: 34px;
  height: 34px;
  font-size: 18px
}

:deep(.custom-el-input .el-select__wrapper) {
  border-radius: 20px;
}
</style>