dwh.js

  var parseCityData = function (cityList, ts) {
    var totalCityList = { time: "", cityData: [] };
    (cityList || []).forEach((element) => {
      hasCityExisted = totalCityList.cityData.some(function (item) {
        return item.cityId === element.CITYID;
      });
      // If it doesnt exist in our list, we are adding the data to our list. 
      if (!hasCityExisted) {
        totalCityList.cityData.push({
          cityId: element.CITYID,
          totalOrderCount: element.TOTALCOUNT,
          totalPriceSum: element.TOTALPRICE,
        });
        
        // If the current city exists in our list, we are updating it's information.
      } else {
        totalCityList.cityData.forEach(function (item) {
          if (item.cityId === element.CITYID) {
            item.totalOrderCount += element.TOTALCOUNT;
            item.totalPriceSum += element.TOTALPRICE;
          }
        });
      }
    });
    totalCityList.time = ts;

    return totalCityList;
  };