exprot-excel-conf.js 1.85 KB
const exportExcelConfs = {
  shopBill: {
    apiUrl: '/erp/queryShopBillList',
    conf: {
      cols: [
        {
          caption: '账务ID',
          type: 'number',
        },
        {
          caption: '结算时间',
          type: 'string',
        },
        {
          caption: '订单号',
          type: 'string',
        },
        {
          caption: 'SKU',
          type: 'string',
        },
        {
          caption: '数量',
          type: 'number',
        },
        {
          caption: '商品名称',
          type: 'string',
        },
        {
          caption: '账务类型',
          type: 'string',
        },
        {
          caption: '业务描述',
          type: 'string',
        },
        {
          caption: '成交价/优惠价',
          type: 'number',
        },
        {
          caption: '商家应收/分摊比例',
          type: 'number',
        },
        {
          caption: '商家应收',
          type: 'number',
        },
        {
          caption: '提现服务费',
          type: 'number',
        },
        {
          caption: '商家实收',
          type: 'number',
        },
        {
          caption: '提现状态',
          type: 'string',
        },
        {
          caption: '可提现日期',
          type: 'string',
        },
        {
          caption: '提现申请日期',
          type: 'string',
        },
      ],
      rows: [
        'id',
        'businessTime',
        'orderCode',
        'productSku',
        'quantity',
        'productName',
        'billTypeDesc',
        'clearingTypeName',
        'lastPrice',
        'clearingDiscount',
        'shopDeserveAmount',
        'withdrawServiceAmount',
        'shopNetAmount',
        'statusName',
        'withdrawalTime',
        'withdrawApplyTime',
      ],
    },
  },
};
module.exports = exportExcelConfs;