exprot-excel-conf.js 4.72 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: 'number',
        },
        {
          caption: '提现状态',
          type: 'string',
        },
        {
          caption: '可提现日期',
          type: 'string',
        },
        {
          caption: '提现申请日期',
          type: 'string',
        },
      ],
      rows: [
        'id',
        'businessTime',
        'orderCode',
        'productSku',
        'quantity',
        'productName',
        'billTypeDesc',
        'clearingTypeName',
        'lastPrice',
        'clearingDiscount',
        'shopDeserveAmount',
        'withdrawServiceAmount',
        'serviceAmount',
        'shopNetAmount',
        'statusName',
        'withdrawalTime',
        'withdrawApplyTime',
      ],
    },
  },
  //服务费账单报表导出配置
  shopServiceList: {
    apiUrl: '/erp/shopWithdrawServiceList',
    conf: {
      cols: [
        {
          caption: '账务ID',
          type: 'number',
        },
        {
          caption: '提现时间',
          type: 'string',
        },
        {
          caption: '商家收款账户',
          type: 'string',
        },
        {
          caption: '订单号',
          type: 'string',
        },
        {
          caption: 'SKU',
          type: 'number',
        },
        {
          caption: '商品名称',
          type: 'string',
        },
        {
          caption: '账务类型',
          type: 'string',
        },
        {
          caption: '子服务类型',
          type: 'string',
        },
        {
          caption: '交易服务费',
          type: 'number',
        },
        {
          caption: '提现服务费',
          type: 'number',
        },
        {
          caption: '服务费金额',
          type: 'number',
        },
        {
          caption: '提现状态',
          type: 'string',
        },
        {
          caption: '提现成功日期',
          type: 'string',
        },
      ],
      rows: [
        'id',
        'withdrawTime',
        'targetAccount',
        'orderCode',
        'productSku',
        'productName',
        'clearingType',
        'clearingTypeName',
        'tradeServiceAmount',
        'withdrawServiceAmount',
        'serviceAmount',
        'statusName',
        'withdrawTime',
      ],
    },
  },
  //运费账务明细报表导出配置
  shopFreightList: {
    apiUrl: '/erp/shopWithdrawFreightList',
    conf: {
      cols: [
        {
          caption: '账务ID',
          type: 'number',
        },
        {
          caption: '结算时间',
          type: 'string',
        },
        {
          caption: '订单号',
          type: 'string',
        },
        {
          caption: '商品名称',
          type: 'string',
        },
        {
          caption: '账务类型',
          type: 'string',
        },
        {
          caption: '运费',
          type: 'number',
        },
        {
          caption: '提现服务费',
          type: 'number',
        },
        {
          caption: '商家实收',
          type: 'number',
        },
        {
          caption: '提现状态',
          type: 'string',
        },
        {
          caption: '提现成功日期',
          type: 'string',
        },
      ],
      rows: [
        'id',
        'clearingTime',
        'orderCode',
        'productName',
        'clearingType',
        'freightAmount',
        'withdrawServiceAmount',
        'realIncome',
        'statusName',
        'withdrawTime',
      ],
    },
  },
};
module.exports = exportExcelConfs;