ElementUI table实现复杂表格

根据下图的表格显示数据:

分析:

1、首先根据客户合并行

2、根据销售类型合并行

3、根据物品名称显示该物品在某年某月销售的数量 、销量、利润、利润率

4、显示合计

代码如下:

<template>
  <basic-container>
    <el-table
        :data="directIndentlist"
        :span-method="arraySpanMethod"
        ref="tableELe"
        style="width: 100%;">
      <el-table-column label="客户" align="center" prop="custName" min-width="210"></el-table-column>
      <el-table-column label="销售类型" align="center" prop="saleType" min-width="210"></el-table-column>
      <el-table-column label="物品名" align="center" prop="invtName" width="210"></el-table-column>
      <el-table-column
          align="center"
          v-for="(item, index) in dataList"
          :key="index"
          :label="item.dataType" prop="dataList">
        <el-table-column label="数量" align="center" prop="quantity"
                         :formatter="(row)=>{return dataFormatter(row,index,'quantity')}">
        </el-table-column>
        <el-table-column label="销量" align="center" prop="sale"
                         :formatter="(row)=>{return dataFormatter(row,index,'sale')}">
        </el-table-column>
        <el-table-column label="利润" align="center" prop="profit"
                         :formatter="(row)=>{return dataFormatter(row,index,'profit')}">
        </el-table-column>
        <el-table-column label="利润率" align="center" prop="profitRate"
                         :formatter="(row)=>{return dataFormatter(row,index,'profitRate')}">
        </el-table-column>
      </el-table-column>

    </el-table>

  </basic-container>
</template>

<script>
export default {
  data() {
    return {
      directIndentlist: [],
      dataList: []
    }
  },
  created() {
    let data = {
      "code": 200,
      "msg": "000",
      "data": {
        "total": 5,
        "rows": [{
          "custId": "AI001",
          "custName": "大连保税区爱利化学有限公司",
          "saleType": null,
          "dataList": [{
            "saleType": "DIRECT",
            "invtId": "1000100037",
            "invtName": "REMAZOL YELLOW RU-N NEW",
            "unit": "0",
            "dataList": [{
              "dataType": "201408",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201407",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201409",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201404",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201403",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201406",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201405",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201411",
              "unit": null,
              "quantity": 200.00,
              "sale": 21829.06,
              "saleRate": null,
              "profit": 2223.06,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201410",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201402",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201412",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201401",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "ROW_TOTAL",
              "unit": null,
              "quantity": 200.00,
              "sale": 21829.06,
              "saleRate": null,
              "profit": 2223.06,
              "thisProfitRate": null,
              "profitRate": null
            }],
            "dataMap": null
          }, {
            "saleType": "DIRECT",
            "invtId": "1000100106",
            "invtName": "REMAZOL RED RUN HI-GRAN 150%",
            "unit": "0",
            "dataList": [{
              "dataType": "201408",
              "unit": null,
              "quantity": 25.00,
              "sale": 4380.34,
              "saleRate": null,
              "profit": 177.34,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201407",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201409",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201404",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201403",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201406",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201405",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201411",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201410",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201402",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201412",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201401",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "ROW_TOTAL",
              "unit": null,
              "quantity": 25.00,
              "sale": 4380.34,
              "saleRate": null,
              "profit": 177.34,
              "thisProfitRate": null,
              "profitRate": null
            }],
            "dataMap": null
          }, {
            "saleType": "DIRECT",
            "invtId": "1000100115",
            "invtName": "REMAZOL BLUE RU-N",
            "unit": "0",
            "dataList": [{
              "dataType": "201408",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201407",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201409",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201404",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201403",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201406",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201405",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201411",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201410",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201402",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201412",
              "unit": null,
              "quantity": 100.00,
              "sale": 23854.70,
              "saleRate": null,
              "profit": 2392.70,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201401",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "ROW_TOTAL",
              "unit": null,
              "quantity": 100.00,
              "sale": 23854.70,
              "saleRate": null,
              "profit": 2392.70,
              "thisProfitRate": null,
              "profitRate": null
            }],
            "dataMap": null
          }, {
            "saleType": "DIRECT",
            "invtId": "1000100117",
            "invtName": "PROCION YELLOW PX-8G",
            "unit": "0",
            "dataList": [{
              "dataType": "201408",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201407",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201409",
              "unit": null,
              "quantity": 50.00,
              "sale": 5555.56,
              "saleRate": null,
              "profit": 769.06,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201404",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201403",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201406",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201405",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201411",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201410",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201402",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201412",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201401",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "ROW_TOTAL",
              "unit": null,
              "quantity": 50.00,
              "sale": 5555.56,
              "saleRate": null,
              "profit": 769.06,
              "thisProfitRate": null,
              "profitRate": null
            }],
            "dataMap": null
          }, {
            "saleType": "DIRECT",
            "invtId": "1000100166",
            "invtName": "Remazol Deep Black N-X 150% gran",
            "unit": "0",
            "dataList": [{
              "dataType": "201408",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201407",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201409",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201404",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201403",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201406",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201405",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201411",
              "unit": null,
              "quantity": 700.00,
              "sale": 40205.13,
              "saleRate": null,
              "profit": 6584.13,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201410",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201402",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201412",
              "unit": null,
              "quantity": 300.00,
              "sale": 17205.13,
              "saleRate": null,
              "profit": 2820.13,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201401",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "ROW_TOTAL",
              "unit": null,
              "quantity": 1000.00,
              "sale": 57410.26,
              "saleRate": null,
              "profit": 9404.26,
              "thisProfitRate": null,
              "profitRate": null
            }],
            "dataMap": null
          }],
          "currentTotal": {
            "saleType": null,
            "invtId": null,
            "invtName": null,
            "unit": null,
            "dataList": [{
              "dataType": "201408",
              "unit": null,
              "quantity": 0,
              "sale": 21901.70,
              "saleRate": null,
              "profit": 886.70,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201407",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201409",
              "unit": null,
              "quantity": 0,
              "sale": 27777.80,
              "saleRate": null,
              "profit": 3845.30,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201404",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201403",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201406",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201405",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201411",
              "unit": null,
              "quantity": 0,
              "sale": 310170.95,
              "saleRate": null,
              "profit": 44035.95,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201410",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201402",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201412",
              "unit": null,
              "quantity": 0,
              "sale": 205299.15,
              "saleRate": null,
              "profit": 26064.15,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201401",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "ROW_TOTAL",
              "unit": null,
              "quantity": 0,
              "sale": 113029.92,
              "saleRate": null,
              "profit": 14966.42,
              "thisProfitRate": null,
              "profitRate": null
            }],
            "dataMap": {}
          },
          "beforeTotal": {
            "saleType": null,
            "invtId": null,
            "invtName": null,
            "unit": null,
            "dataList": [{
              "dataType": "201408",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201407",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201409",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201404",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201403",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201406",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201405",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": null,
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": null,
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201402",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": null,
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201401",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "ROW_TOTAL",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }],
            "dataMap": {}
          },
          "earlyStageRate": {
            "saleType": null,
            "invtId": null,
            "invtName": null,
            "unit": null,
            "dataList": [{
              "dataType": "201408",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201407",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201409",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201404",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201403",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201406",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201405",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201411",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201410",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201402",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201412",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201401",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "ROW_TOTAL",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }],
            "dataMap": {}
          }
        }, {
          "custId": "AN001",
          "custName": "安丘德隆寝装用品有限公司",
          "saleType": null,
          "dataList": [{
            "saleType": "DIRECT",
            "invtId": "1000200373",
            "invtName": "NTR-KⅡ",
            "unit": "0",
            "dataList": [{
              "dataType": "201408",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201407",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201409",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201404",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201403",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201406",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201405",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201411",
              "unit": null,
              "quantity": 18.00,
              "sale": 2923.08,
              "saleRate": null,
              "profit": 1038.54,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201410",
              "unit": null,
              "quantity": 72.00,
              "sale": 11692.31,
              "saleRate": null,
              "profit": 4154.14,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201402",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201412",
              "unit": null,
              "quantity": 90.00,
              "sale": 14615.38,
              "saleRate": null,
              "profit": 5180.66,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201401",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "ROW_TOTAL",
              "unit": null,
              "quantity": 180.00,
              "sale": 29230.77,
              "saleRate": null,
              "profit": 10373.34,
              "thisProfitRate": null,
              "profitRate": null
            }],
            "dataMap": null
          }, {
            "saleType": "DIRECT",
            "invtId": "1000200427",
            "invtName": "NTR-TKI522",
            "unit": "0",
            "dataList": [{
              "dataType": "201408",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201407",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201409",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201404",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201403",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201406",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201405",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201411",
              "unit": null,
              "quantity": 200.00,
              "sale": 39316.24,
              "saleRate": null,
              "profit": 6818.54,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201410",
              "unit": null,
              "quantity": 360.00,
              "sale": 70769.23,
              "saleRate": null,
              "profit": 12299.12,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201402",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201412",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201401",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "ROW_TOTAL",
              "unit": null,
              "quantity": 560.00,
              "sale": 110085.47,
              "saleRate": null,
              "profit": 19117.66,
              "thisProfitRate": null,
              "profitRate": null
            }],
            "dataMap": null
          }],
          "currentTotal": {
            "saleType": null,
            "invtId": null,
            "invtName": null,
            "unit": null,
            "dataList": [{
              "dataType": "201408",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201407",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201409",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201404",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201403",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201406",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201405",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201411",
              "unit": null,
              "quantity": 0,
              "sale": 84478.64,
              "saleRate": null,
              "profit": 15714.16,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201410",
              "unit": null,
              "quantity": 0,
              "sale": 164923.08,
              "saleRate": null,
              "profit": 32906.52,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201402",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201412",
              "unit": null,
              "quantity": 0,
              "sale": 29230.76,
              "saleRate": null,
              "profit": 10361.32,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201401",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "ROW_TOTAL",
              "unit": null,
              "quantity": 0,
              "sale": 139316.24,
              "saleRate": null,
              "profit": 29491.00,
              "thisProfitRate": null,
              "profitRate": null
            }],
            "dataMap": {}
          },
          "beforeTotal": {
            "saleType": null,
            "invtId": null,
            "invtName": null,
            "unit": null,
            "dataList": [{
              "dataType": "201408",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201407",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201409",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201404",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201403",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201406",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201405",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": null,
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": null,
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201402",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": null,
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201401",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "ROW_TOTAL",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }],
            "dataMap": {}
          },
          "earlyStageRate": {
            "saleType": null,
            "invtId": null,
            "invtName": null,
            "unit": null,
            "dataList": [{
              "dataType": "201408",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201407",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201409",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201404",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201403",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201406",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201405",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201411",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201410",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201402",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201412",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201401",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "ROW_TOTAL",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }],
            "dataMap": {}
          }
        }, {
          "custId": "AN002",
          "custName": "安徽中天印染股份有限公司",
          "saleType": null,
          "dataList": [{
            "saleType": "DIRECT",
            "invtId": "1000200400",
            "invtName": "RUEDYE-W BINDER 100SF",
            "unit": "0",
            "dataList": [{
              "dataType": "201408",
              "unit": null,
              "quantity": 1000.00,
              "sale": 21367.52,
              "saleRate": null,
              "profit": 5982.90,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201407",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201409",
              "unit": null,
              "quantity": 2000.00,
              "sale": 42735.04,
              "saleRate": null,
              "profit": 11965.81,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201404",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201403",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201406",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201405",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201411",
              "unit": null,
              "quantity": 1500.00,
              "sale": 32051.28,
              "saleRate": null,
              "profit": 8974.36,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201410",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201402",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201412",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201401",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "ROW_TOTAL",
              "unit": null,
              "quantity": 4500.00,
              "sale": 96153.84,
              "saleRate": null,
              "profit": 26923.07,
              "thisProfitRate": null,
              "profitRate": null
            }],
            "dataMap": null
          }],
          "currentTotal": {
            "saleType": null,
            "invtId": null,
            "invtName": null,
            "unit": null,
            "dataList": [{
              "dataType": "201408",
              "unit": null,
              "quantity": 0,
              "sale": 21367.52,
              "saleRate": null,
              "profit": 5982.90,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201407",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201409",
              "unit": null,
              "quantity": 0,
              "sale": 42735.04,
              "saleRate": null,
              "profit": 11965.81,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201404",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201403",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201406",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201405",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201411",
              "unit": null,
              "quantity": 0,
              "sale": 32051.28,
              "saleRate": null,
              "profit": 8974.36,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201410",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201402",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201412",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201401",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "ROW_TOTAL",
              "unit": null,
              "quantity": 0,
              "sale": 96153.84,
              "saleRate": null,
              "profit": 26923.07,
              "thisProfitRate": null,
              "profitRate": null
            }],
            "dataMap": {}
          },
          "beforeTotal": {
            "saleType": null,
            "invtId": null,
            "invtName": null,
            "unit": null,
            "dataList": [{
              "dataType": "201408",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201407",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201409",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201404",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201403",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201406",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201405",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": null,
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": null,
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201402",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": null,
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201401",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "ROW_TOTAL",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }],
            "dataMap": {}
          },
          "earlyStageRate": {
            "saleType": null,
            "invtId": null,
            "invtName": null,
            "unit": null,
            "dataList": [{
              "dataType": "201408",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201407",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201409",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201404",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201403",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201406",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201405",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201411",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201410",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201402",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201412",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201401",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "ROW_TOTAL",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }],
            "dataMap": {}
          }
        }, {
          "custId": "AN004",
          "custName": "安徽安利合成革有限公司",
          "saleType": null,
          "dataList": [{
            "saleType": "DIRECT",
            "invtId": "1000200122",
            "invtName": "RESAMINE CU-8522-28",
            "unit": "0",
            "dataList": [{
              "dataType": "201408",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201407",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201409",
              "unit": null,
              "quantity": 6000.00,
              "sale": 146153.84,
              "saleRate": null,
              "profit": 4384.61,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201404",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201403",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201406",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201405",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201411",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201410",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201402",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201412",
              "unit": null,
              "quantity": 12000.00,
              "sale": 292307.70,
              "saleRate": null,
              "profit": 8769.24,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201401",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "ROW_TOTAL",
              "unit": null,
              "quantity": 18000.00,
              "sale": 438461.54,
              "saleRate": null,
              "profit": 13153.85,
              "thisProfitRate": null,
              "profitRate": null
            }],
            "dataMap": null
          }],
          "currentTotal": {
            "saleType": null,
            "invtId": null,
            "invtName": null,
            "unit": null,
            "dataList": [{
              "dataType": "201408",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201407",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201409",
              "unit": null,
              "quantity": 0,
              "sale": 146153.84,
              "saleRate": null,
              "profit": 4384.61,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201404",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201403",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201406",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201405",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201411",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201410",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201402",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201412",
              "unit": null,
              "quantity": 0,
              "sale": 292307.70,
              "saleRate": null,
              "profit": 8769.24,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201401",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "ROW_TOTAL",
              "unit": null,
              "quantity": 0,
              "sale": 438461.54,
              "saleRate": null,
              "profit": 13153.85,
              "thisProfitRate": null,
              "profitRate": null
            }],
            "dataMap": {}
          },
          "beforeTotal": {
            "saleType": null,
            "invtId": null,
            "invtName": null,
            "unit": null,
            "dataList": [{
              "dataType": "201408",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201407",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201409",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201404",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201403",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201406",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201405",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": null,
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": null,
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201402",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": null,
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201401",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "ROW_TOTAL",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }],
            "dataMap": {}
          },
          "earlyStageRate": {
            "saleType": null,
            "invtId": null,
            "invtName": null,
            "unit": null,
            "dataList": [{
              "dataType": "201408",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201407",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201409",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201404",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201403",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201406",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201405",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201411",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201410",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201402",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201412",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201401",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "ROW_TOTAL",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }],
            "dataMap": {}
          }
        }, {
          "custId": "AN006",
          "custName": "安徽新南港江森汽车饰件有限公司",
          "saleType": null,
          "dataList": [{
            "saleType": "DIRECT",
            "invtId": "1000200165",
            "invtName": "SUNLIFE LPS-980NZ",
            "unit": "0",
            "dataList": [{
              "dataType": "201408",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201407",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201409",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201404",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201403",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201406",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201405",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201411",
              "unit": null,
              "quantity": 400.00,
              "sale": 41025.64,
              "saleRate": null,
              "profit": 4102.56,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201410",
              "unit": null,
              "quantity": 300.00,
              "sale": 30769.23,
              "saleRate": null,
              "profit": 3076.92,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201402",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201412",
              "unit": null,
              "quantity": 150.00,
              "sale": 15384.62,
              "saleRate": null,
              "profit": 1538.47,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201401",
              "unit": null,
              "quantity": 0.00,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "ROW_TOTAL",
              "unit": null,
              "quantity": 850.00,
              "sale": 87179.49,
              "saleRate": null,
              "profit": 8717.95,
              "thisProfitRate": null,
              "profitRate": null
            }],
            "dataMap": null
          }],
          "currentTotal": {
            "saleType": null,
            "invtId": null,
            "invtName": null,
            "unit": null,
            "dataList": [{
              "dataType": "201408",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201407",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201409",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201404",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201403",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201406",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201405",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201411",
              "unit": null,
              "quantity": 0,
              "sale": 41025.64,
              "saleRate": null,
              "profit": 4102.56,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201410",
              "unit": null,
              "quantity": 0,
              "sale": 30769.23,
              "saleRate": null,
              "profit": 3076.92,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201402",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201412",
              "unit": null,
              "quantity": 0,
              "sale": 15384.62,
              "saleRate": null,
              "profit": 1538.47,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201401",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "ROW_TOTAL",
              "unit": null,
              "quantity": 0,
              "sale": 87179.49,
              "saleRate": null,
              "profit": 8717.95,
              "thisProfitRate": null,
              "profitRate": null
            }],
            "dataMap": {}
          },
          "beforeTotal": {
            "saleType": null,
            "invtId": null,
            "invtName": null,
            "unit": null,
            "dataList": [{
              "dataType": "201408",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201407",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201409",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201404",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201403",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201406",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201405",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": null,
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": null,
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201402",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": null,
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "201401",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }, {
              "dataType": "ROW_TOTAL",
              "unit": null,
              "quantity": 0,
              "sale": 0.00,
              "saleRate": null,
              "profit": 0.00,
              "thisProfitRate": null,
              "profitRate": null
            }],
            "dataMap": {}
          },
          "earlyStageRate": {
            "saleType": null,
            "invtId": null,
            "invtName": null,
            "unit": null,
            "dataList": [{
              "dataType": "201408",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201407",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201409",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201404",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201403",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201406",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201405",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201411",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201410",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201402",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201412",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "201401",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }, {
              "dataType": "ROW_TOTAL",
              "unit": null,
              "quantity": 0,
              "sale": 0,
              "saleRate": "0.0%",
              "profit": 0,
              "thisProfitRate": null,
              "profitRate": "0.0%"
            }],
            "dataMap": {}
          }
        }],
        "code": 200,
        "msg": "查询成功"
      },
      "expandData": {}
    };
    // 组装数据
    this.formatTableData(data.data.rows)

    // 获取动态列
    var dataList = this.directIndentlist[0].dataList;
    this.dataList = dataList;
  },
  updated() {
    if (this.$refs.tableELe && this.$refs.tableELe.doLayout) {
      this.$refs.tableELe.doLayout();
    }
  },
  methods: {
    //自定义列显示的数据
    dataFormatter(row, index, prop) {
      if (row && row.dataList && row.dataList[index]) {
        var value = row.dataList[index][prop];
        return value;
      }
    },
    // 格式化表格数据
    formatTableData(tableData) {
      this.directIndentlist = [];
      tableData.forEach(item => {
        console.log(item)
        item.dataList.map(child => {
          let trObj = child;
          trObj['custId'] = item.custId;
          trObj['custName'] = item.custName;
          trObj['saleType'] = child.saleType;
          trObj['invtId'] = child.invtId;
          trObj['invtName'] = child.invtName;
          this.directIndentlist.push(trObj)
        })
        let total = {
          title: 'total',
          custId: item.custId,
          custName: item.custName,
          saleType: '小计',
          invtId: '',
          invtName: '当前合计',
          dataList: item.currentTotal.dataList
        }
        let total2 = {
          title: 'total',
          custId: item.custId,
          custName: item.custName,
          saleType: '小计',
          invtId: '',
          invtName: '前期合计',
          dataList: item.beforeTotal.dataList
        }
        let total3 = {
          title: 'total',
          custId: item.custId,
          custName: item.custName,
          saleType: '小计',
          invtId: '',
          invtName: '前期比',
          dataList: item.earlyStageRate.dataList
        }
        this.directIndentlist.push(total);
        this.directIndentlist.push(total2);
        this.directIndentlist.push(total3);
      })
      this.getSpanArr(this.directIndentlist)
      this.getSpanArr2(this.directIndentlist)
      this.getSpanArr3(this.directIndentlist)
    },
    //合并行列
    arraySpanMethod({row, column, rowIndex, columnIndex}) {
      if (columnIndex === 0) {
        const _row = this.spanArr[rowIndex];
        const _col = _row > 0 ? 1 : 0;
        return {
          rowspan: _row,
          colspan: _col
        }
      } else if (columnIndex === 1) {
        const _row = this.spanArr2[rowIndex];
        const _col = _row > 0 ? 1 : 0;
        return {
          rowspan: _row,
          colspan: _col
        }
      } else if (column.label === '数量') {
        if (row.invtName == '当前合计') {
          return {
            rowspan: 3,
            colspan: 1
          }
        }
        if (row.invtName == '前期合计' || row.invtName == '前期比') {
          return {
            rowspan: 0,
            colspan: 0
          }
        }
      } else if (columnIndex === 2) {
        const _row = this.spanArr3[rowIndex];
        const _col = _row > 0 ? 1 : 0;
        return {
          rowspan: _row,
          colspan: _col
        }
      }
    },
    //统计要合并的行(根据客户合并)
    getSpanArr(data = []) {
      this.spanArr = []
      for (var i = 0; i < data.length; i++) {
        if (i === 0) {
          this.spanArr.push(1);
          this.pos = 0
        } else {
          // 判断当前元素与上一个元素是否相同
          if (data[i].custId === data[i - 1].custId) {
            this.spanArr[this.pos] += 1;
            this.spanArr.push(0);
          } else {
            this.spanArr.push(1);
            this.pos = i;
          }
        }
      }
      console.log('spanArr:', this.spanArr)
    },
    //统计要合并的行(根据销售类型合并)
    getSpanArr2(data = []) {
      this.spanArr2 = []
      for (var i = 0; i < data.length; i++) {
        if (i === 0) {
          this.spanArr2.push(1);
          this.pos = 0
        } else {
          // 判断当前元素与上一个元素是否相同
          if (data[i].saleType === data[i - 1].saleType) {
            this.spanArr2[this.pos] += 1;
            this.spanArr2.push(0);
          } else {
            this.spanArr2.push(1);
            this.pos = i;
          }
        }
      }
      console.log('spanArr2:', this.spanArr2)
    },
    //统计要合并的行(根据物品名称)
    getSpanArr3(data = []) {
      this.spanArr3 = []
      for (var i = 0; i < data.length; i++) {
        if (i === 0) {
          this.spanArr3.push(1);
          this.pos = 0
        } else {
          // 判断当前元素与上一个元素是否相同
          if (data[i].invtId === data[i - 1].invtId) {
            this.spanArr3[this.pos] += 1;
            this.spanArr3.push(0);
          } else {
            this.spanArr3.push(1);
            this.pos = i;
          }
        }
      }
      console.log('spanArr3:', this.spanArr3)
    },
  }
};
</script>

<style>
.el-table__header-wrapper tr th, .el-table__body-wrapper .el-table__row td {
  border: 1px solid #EBEEF5 !important;
}
</style>

最终效果如下:

  • 3
    点赞
  • 7
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值