/**
  * Display the specified resource.
  *
  * @param  int  $id
  * @return Response
  */
 public function show($id)
 {
     $order = Order::find($id);
     $order_item = Item::where('order_id', $id)->select('item.quantity', 'spares.spar')->join('spares', 'item.spares_id', '=', 'spares.id')->get();
     $data = array('order' => $order, 'order_item' => $order_item);
     return View::make('order.show')->with($data);
 }