核心JavaScript问题 - 如果条件相遇，则从列中删除json文件中的对象

Question

我需要代码在Core JavaScript中使用的代码是我们使用的工具，它使用Mozilla中的Rhino，因此它不能包含与网页操纵有关的对象或方法。

我正在尝试使用core javaScript从两个JSON文件中比较数据，当order_number和evend相同时，我们将比较计数（fullFilments.line_items）和数量（这是该成就符​​号下的所有数量的总数， fullfilments.line_items.quantity）。如果Order_number和Ext_ID组合以及上面的计数和总和匹配，则无需执行任何操作。如果没有匹配，我们将删除退款。该代码在Visual Studio中正常工作。我是Pentaho的新手，我认为只有Core JS使用此工具，因此需要更改代码。

在订单文件中是示例JSON结构，例如order_number（在这种情况下为66）需要计算和比较订单项的计数（在这种情况下为6）以及项目的数量（在这种情况下为7） t匹配需要删除对象退款及其元素，否则没有更改。

'

[
    {
        "app_id": 111,
        "fulfillments": 
        [
        {
            "id": 39828,
            "order_id": 450625,
            "receipt": {},
            "service": "manual",
            "shipment_status": null,
            "status": "success",
            "updated_at": "2022-05-24",
            "line_items": 
            [{
                "id": 376,
                "quantity": 2
            },
            {
                "id": 992,
                "quantity": 1
            },
            {
                "id": 929,
                "quantity": 1
            },
            {
                "id": 768,
                "quantity": 1
            },
            {
                "id": 929,
                "quantity": 1
            },
            {
                "id": 768,
                "quantity": 1
            }
           ]
        }
        ],
        "line_items": [],
        "name": "#59",
        "number": 6,
        "order_number": 66,
        "ext_id": 110,
        "refunds": [
            {
                "id": 80,
                "created_at": "2000-06-17T14:31:06-04:00"
            }
        ]
    },
    {
        "app_id": 111,
        "fulfillments": [
        {
            "id": 398000,
            "order_id": 450005,
            "receipt": {},
            "service": "manual",
            "shipment_status": null,
            "status": "success",
            "updated_at": "2022-05-24",
            "line_items": 
            [{
                "id": 376,
                "quantity": 2
            },
            {
                "id": 992,
                "quantity": 1
            },
            {
                "id": 929,
                "quantity": 1
            },
            {
                "id": 768,
                "quantity": 1
            }
           ]
        }
        ],
        "line_items": [],
        "name": "#59",
        "number": 6,
        "order_number": 67,
        "ext_id": 114,
        "refunds": [
            {
                "id": 81,
                "created_at": "2000-06-17T14:31:06-04:00"
            }
        ]
    },
    {
        "app_id": 111,
        "fulfillments": [
        {
            "id": 39828,
            "order_id": 450625,
            "receipt": {},
            "service": "manual",
            "shipment_status": null,
            "status": "success",
            "updated_at": "2022-05-24",
            "line_items": 
            [{
                "id": 376,
                "quantity": 2
            },
            {
                "id": 768,
                "quantity": 1
            },
            {
                "id": 929,
                "quantity": 2
            },
            {
                "id": 768,
                "quantity": 2
            }
           ]
        }
        ],
        "line_items": [],
        "name": "#59",
        "number": 6,
        "order_number": 68,
        "ext_id": 113,
        "refunds": [
            {
                "id": 80,
                "created_at": "2000-06-17T14:31:06-04:00"
            }
        ]
    }
]

' ````````````''' //结果集文件内容

[ { “ order_number”：66， “明显”：110， “ line_items_count”：6， “数量”：7 }，， { “ order_number”：67， “明显”：114， “ line_items_count”：4， “数量”：7 }，， { “ order_number”：68， “明显”：113， “ line_items_count”：4， “数量”：6 } ]`

```````````````````''代码````````````''

/**
 * orders.json file has some sample orders
 * resultset.json file has results from sql Lookup to the orders.
 * 
 */

const orders = require('./orders.json');

function compare(order) {
  let isMatched = false;
  let resultSet = require('./resultset.json');
  let result = resultSet.find(function (item) {
    return item.order_number === order.order_number;
  });

  
  if (
    result &&
    result.line_items_count === order.items &&
    result.quantity === order.quantity
  ) {
    isMatched = true;
  }
  return isMatched;
}

function fixOrders(orders) {
  orders.map(function (order) {
    let { order_number, line_items } = order;

    let quantity = line_items.reduce(function (quantity, line_item) {
      return (quantity += line_item.quantity);
    }, 0);

    if (!compare({ order_number, items: line_items.length, quantity })) {
      delete order.refunds;
    }
  });

  return orders;
}

let fixedOrders = fixOrders(orders);

console.log(fixedOrders);

// store in output.js
//========================================

// var fs = require('fs');
// fs.writeFile('outputFile.json', JSON.stringify(fixedOrders), (err) => {
//   if (err) console.log(err);
//   else {
//     console.log('File written successfully\n');
//  // console.log('The written has the following contents:');
//  // console.log(fs.readFileSync('outputFile.json', 'utf8'));
//   }
// });

[PDI Flow][1]


  [1]: https://i.sstatic.net/3OzQE.png