数据转化算法

Question

1.需要转化的数据
var data = [
        {
            "billRate":"4.0300%",
            "ebillAmt":"0＜票面金额≤10",
            "dueDate":"2031/03/18≤到期日≤2031/06/30",
            "bankLevel":"1"
        },
        {
            "billRate":"7.0400%",
            "ebillAmt":"0＜票面金额≤10",
            "dueDate":"2031/07/01≤到期日≤2031/10/31",
            "bankLevel":"1"
        },
        {
            "billRate":"8.0400%",
            "ebillAmt":"0＜票面金额≤10",
            "dueDate":"2031/11/01≤到期日≤2032/01/31",
            "bankLevel":"1"
        },
        {
            "billRate":"10.0400%",
            "ebillAmt":"0＜票面金额≤10",
            "dueDate":"2032/02/01≤到期日≤2032/03/18",
            "bankLevel":"1"
        },
        {
            "billRate":"2.0400%",
            "ebillAmt":"10＜票面金额≤50",
            "dueDate":"2031/03/18≤到期日≤2031/06/30",
            "bankLevel":"1"
        },
        {
            "billRate":"6.0400%",
            "ebillAmt":"10＜票面金额≤50",
            "dueDate":"2031/07/01≤到期日≤2031/10/31",
            "bankLevel":"1"
        }
    ]

2.转化的结果
var res = [
        {
            amt10: "7.0400%"
            amt50: "6.0400%"
            amt100: ""
            amt500: ""
            bankLevel: "一类银行"
            dueDate: "截止2031/10/31(含)"
        },
        {
            amt10: "4.0300%"
            amt50: "2.0400%"
            amt100: ""
            amt500: ""
            bankLevel: "一类银行"
            dueDate: "截止2031/06/30(含)"
        },
        {
            amt10: "7.0400%"
            amt50: "6.0400%"
            amt100: ""
            amt500: ""
            bankLevel: "一类银行"
            dueDate: "截止2031/10/31(含)"
        },
        {
            amt10: "10.0400%"
            amt50: ""
            amt100: ""
            amt500: ""
            bankLevel: "一类银行"
            dueDate: "截止2032/03/18(含)"
        }    
    ]

Answer 1

var data = [
  {
    billRate: "4.0300%",
    ebillAmt: "0＜票面金额≤10",
    dueDate: "2031/03/18≤到期日≤2031/06/30",
    bankLevel: "1",
  },
  {
    billRate: "7.0400%",
    ebillAmt: "0＜票面金额≤10",
    dueDate: "2031/07/01≤到期日≤2031/10/31",
    bankLevel: "1",
  },
  {
    billRate: "8.0400%",
    ebillAmt: "0＜票面金额≤10",
    dueDate: "2031/11/01≤到期日≤2032/01/31",
    bankLevel: "1",
  },
  {
    billRate: "10.0400%",
    ebillAmt: "0＜票面金额≤10",
    dueDate: "2032/02/01≤到期日≤2032/03/18",
    bankLevel: "1",
  },
  {
    billRate: "2.0400%",
    ebillAmt: "10＜票面金额≤50",
    dueDate: "2031/03/18≤到期日≤2031/06/30",
    bankLevel: "1",
  },
  {
    billRate: "6.0400%",
    ebillAmt: "10＜票面金额≤50",
    dueDate: "2031/07/01≤到期日≤2031/10/31",
    bankLevel: "1",
  },
];

const bankLevelMap = {
  1: "一类银行",
  2: "二类银行",
  3: "三类银行",
};

const result = data.map((item) => {
  return {
    amt10: item.billRate,
    amt50: "6.0400%", // 这个业务不太懂，怎么来的
    amt100: "",
    amt500: "",
    bankLevel: bankLevelMap[item.bankLevel],
    dueDate: `截止${item.dueDate.slice(-10)}(含)`,
  };
});

console.log(result);