获取以下代码片段。我正在加载具有与Inventory
:的关系的OrderDetail
模型
// Load order details for live orders and inventory ids
$order_details = 'OrderDetail::whereIn('order_id', $live_order_ids)
->whereIn('inventory_id', $inventory_ids)
->with('inventory')
->get();
加载集合后,我将进行以下处理:
// Deduct reserved stock from live un-picked orders
foreach ($order_details as $detail)
if (array_key_exists($detail->inventory->sku, $free_stocks))
$free_stocks[$detail->inventory->sku] -=
($detail->qty_ordered - $detail->qty_picked);
正如你所看到的,从加载的集合中,我只需要以下内容:
- order_details.qty_ordered
- order_details.qty_picked
- inventory.sku
我想优化这一点,只加载我需要的内容,即明确指定我想从主表和相关表加载哪些列。
我该怎么做?当我尝试以下操作时,它似乎不起作用:
// Load order details for live orders and inventory ids
$order_details = 'OrderDetail::whereIn('order_id', $live_order_ids)
->whereIn('inventory_id', $inventory_ids)
->with('inventory')
->get(['qty_ordered','qty_picked','sku']);
// Load order details for live orders and inventory ids
$order_details = 'OrderDetail::whereIn('order_id', $live_order_ids)
->whereIn('inventory_id', $inventory_ids)
->with(['inventory' => function($query) {
$query->addSelect(['id','sku']);
}])
->get(['qty_ordered','qty_picked']);
有什么想法吗?
您需要在查询中使用select来获取所选列。或者,如果它不起作用,您需要使用laravel联接。
另请参阅laravel官方文件中查询的选择列。http://laravel.com/docs/4.2/queries.
// Load order details for live orders and inventory ids
$order_details = 'OrderDetail::whereIn('order_id', $live_order_ids)
->whereIn('inventory_id', $inventory_ids)
->with(['inventory' => function($query) {
$query->addSelect(['id','sku']);
}])
->select('qty_ordered','qty_picked')
->get();