将同级数据处理成树形数据

将同级数据处理成树形数据

  <script>
    const oldArray = [
      {
        batchNo: "1",
        factoryCnName: "苹果",
        goodsCnName: "pingguo",
        inputNum: 1,
      },
      {
        batchNo: "1",
        factoryCnName: "苹果",
        goodsCnName: "pingguo",
        inputNum: 3,
      },
      {
        batchNo: "1",
        factoryCnName: "梨子",
        goodsCnName: "lizi",
        inputNum: 3,
      },
      {
        batchNo: "1",
        factoryCnName: "梨子",
        goodsCnName: "lizi",
        inputNum: 3,
      },
      {
        batchNo: "2",
        factoryCnName: "苹果",
        goodsCnName: "pingguo",
        inputNum: 3,
      },
    ];
    const inStoreTabData = TabFormartFun(oldArray);
    console.log(inStoreTabData, "inStoreTabData");
    //处理出入库表格数据
    function TabFormartFun(arr) {
      const data1 = dataformart1(arr, "goodsCnName");
      const data2 = dataformart2(data1, "factoryCnName");
      const result = dataformart3(data2, "batchIdNo");
      return result;
    }
    //格式化表格数据
    function dataformart1(beforeData, name) {
      var tempArr = [];
      var afterData = [];
      for (var i = 0; i < beforeData.length; i++) {
        if (tempArr.indexOf(beforeData[i][name]) == -1) {
          afterData.push({
            Name: beforeData[i][name],
            show: i == 0 || name == "batchIdNo" ? true : false,
            children: [beforeData[i]],
          });
          tempArr.push(beforeData[i][name]);
        } else {
          for (var j = 0; j < afterData.length; j++) {
            if (afterData[j].Name == beforeData[i][name]) {
              afterData[j].children.push(beforeData[i]);
              break;
            }
          }
        }
      }
      return afterData;
    }
    function dataformart2(beforeData, name) {
      beforeData.forEach((element, index) => {
        var afterData = [];
        var tempArr = [];
        var ele = element.children;
        var itemArr = dataformart1(ele, name);
        beforeData[index].children = itemArr;
      });
      return beforeData;
    }
    function dataformart3(beforeData, name) {
      beforeData.forEach((element, index) => {
        var afterData = [];
        var tempArr = [];
        var ele = element.children;
        var itemArr = dataformart2(ele, name);
        //计算数量
        itemArr.forEach((eve) => {
          eve.children.forEach((item) => {
            var total = 0;
            item.children.forEach((e) => {
              total = total + (e.inputNum - 0);
            });
            item.total = total;
          });
        });
        beforeData[index].children = itemArr;
      });
      return beforeData;
    }
  </script>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96