使用RubyonRails合并物件并從JSON格式添加鍵

我有一個查詢的陣列串列，需要根據物件與相同的 location_id 合并。

**這是生成陣列的代碼**

       filled  =  Product.on_hand_location(pid).to_a
       empty   =  Product.on_hand_location_empty_cylinder(pid).to_a
       data    = filled   empty 
  
 
       result = data.map{ |k| 
        { 
        details: { 
              location_id: k['location_id'],
              "location_name"=>k['location_name'],
              "onhandcylynder"=>k['onhand'] == nil ?  0 :  k['onhand'],
              "emptycylynder"=> k['emptyonhand'] == nil ?  0 :  k['emptyonhand']
           } ,
        }
     }
    
    respond_with [ onhand: result ]

下面這個 JSON 格式是上面代碼的輸出。其中有 location_id 需要合并

[{
    "onhand": [{
            "details": {
                "location_id": 1,
                "location_name": "Capitol Drive",
                "onhandcylynder": "4.0",
                "emptycylynder": 0
            }
        },
        {
            "details": {
                "location_id": 2,
                "location_name": "SM City Butuan",
                "onhandcylynder": "5.0",
                "emptycylynder": 0
            }
        },
        {
            "details": {
                "location_id": 1,
                "location_name": null,
                "onhandcylynder": 0,
                "emptycylynder": "2.0"
            }
        }
    ]
  }]

我想要的輸出

  [{
     "onhand": [{
        "details": {
            "location_id": 1,
            "location_name": "Capitol Drive",
            "onhandcylynder": "4.0",
            "emptycylynder": 0
        }
    },
    {
        "details": {
            "location_id": 2,
            "location_name": "SM City Butuan",
            "onhandcylynder": "5.0",
            "emptycylynder": "2.0"
        }
    }
   ]
 }]

uj5u.com熱心網友回復：

我認為data = filled empty你應該嘗試

data = Product.on_hand_location(pid).to_a
empty = Product.on_hand_location_empty_cylinder(pid).to_a
empty.each do |location|
  data.push(location) if data.none? { |item| item['location_id'] == product['location_id'] }
end 
 
result = ...

或者

hash = {}
Product.on_hand_location_empty_cylinder(pid).map { |l| hash[l['location_id']] = l }
Product.on_hand_location(pid).map { |l| hash[l['location_id']] = l }
data = hash.values

如果您需要兩個查詢中的一些資料，您應該嘗試

hash = {}
Product.on_hand_location_empty_cylinder(pid).map { |l| hash[l['location_id']] = l }
Product.on_hand_location(pid).map { |l| hash[l['location_id']].merge!(l) }
data = hash.values

就地合并

uj5u.com熱心網友回復：

我重構了我的代碼并能夠得到我想要的結果

  filled  =  Product.on_hand_location(pid).to_a
  emptyTank =  Product.on_hand_location_empty_cylinder(pid).to_a
  data = filled   emptyTank 
  
  cylinder = data.map(&:dup)
  .group_by { |e| e.delete('location_id') }

   finalResult = cylinder.map{|_, location_id | location_id.reduce({}) { |result, location_id|
     result.merge(location_id)
  } }

  respond_with [ onhand: finalResult]

結果已經與相同的位置 ID 合并，并且 emptyonhand 鍵已經合并到與其位置 ID 對應的位置

[
{
    "onhand": [
        {
            "onhand": "1.0",
            "location_name": "Capitol Drive",
            "emptyonhand": "5.0"
        },
        {
            "onhand": "5.0",
            "location_name": "SM City Butuan"
        }
    ]
}

]

標籤：轨道上的红宝石红宝石ruby-on-rails-5

上一篇：為什么我運行創建時Rails忽略驗證

下一篇：根據用戶組過濾視圖