Formで、関連付けられたモデルの内容を表示したいLaravel

Question

Laravelで商品登録画面を作っています。
商品に店名と支店名を関連付けたいのですが、フォームに正しく表示ができません。

*以下のサンプルだとshop_idは表示できるのですが、shop_nameとshop_branch_nameが表示できない。

controller側で、shop_name＋shop_branch_nameを設定したいのですが、
どのようにしたらよいかご教示いただけませんでしょうか。

よろしくお願いいたします。

DB
inventory (id ,,, shop_branch_id)
shop_branch (id ,shop_branch_name, shop_id)
shop(id ,shop_name)

関連付け
inventory->shop_branch->shop

Controller

    public function create()
    {

        $shops = ShopBranch::lists('shop_id','id')->all();        
        $payment = Payment::lists('name','id')->all();
        $condition = Condition::lists('name','id')->all();
        $sale_place = SalePlace::lists('name','id')->all();

        return view('admin.inventory.create',compact('shops','payment', 'condition','sale_place'));

    }

View

	{!! Form::open(['method'=>'POST','action'=>'AdminInventoriesController@store','files'=>true]) !!}



	<div class="form-group">
		{!! Form::label('shop_branch_id','Shop:') !!}
		{!! Form::select('shop_branch_id',[''=>'Choose Shops'] + $shops,null,['class'=>'form-control']) !!}
	</div>


{!! Form::close() !!}

Inventoryモデル

    public function shop_branch() {
      return $this->belongsTo('App\ShopBranch');
    }

ShopBranchモデル

    public function shop() {
    	return $this->belongsTo('App\Shop');
    }

Answer 1

自己解決しましたが、最善ではないため、laravelとして、phpとして改善点がありましたらご指摘いただけますと幸いです。。

controller

    public function edit($id)
    {
        //
        $inventory = Inventory::findOrFail($id);
        $condition = Condition::lists('name','id')->all();
        $payment = Payment::lists('name','id')->all();
        $sale_place = SalePlace::lists('name','id')->all();

//        $shop_branch = Shop::lists('shop_branch_name','id')->all();
//        $shops = Shop::lists('shop_name','id')->all();

        $shops_objs = DB::select('select 
                        shops.id as id, 
                        CONCAT(shop_lists.shop_name,shops.shop_branch_name) as shop 
                        from shops 
                        left join shop_lists on shops.shop_list_id = shop_lists.id');

        $shops = array();
        foreach($shops_objs as $shops_obj) {
            $shops[$shops_obj->id] = $shops_obj->shop;
        }

        $invphotos = DB::table('inv_photos')->where('inventory_id', $id)->get();

        return view('admin.inventory.edit',compact('inventory','shops','condition','payment','invphotos','sale_place'));
    }

view

		<div class="form-group">
			{!! Form::label('shop_id','Shop:') !!}
			{!! Form::select('shop_id',[''=>'Choose Shops'] + $shops,null,['class'=>'form-control']) !!}
		</div>

Answer 2

自己解決しましたが、最善ではないため、laravelとして、phpとして改善点がありましたらご指摘いただけますと幸いです。。

controller

    public function edit($id)
    {
        //
        $inventory = Inventory::findOrFail($id);
        $condition = Condition::lists('name','id')->all();
        $payment = Payment::lists('name','id')->all();
        $sale_place = SalePlace::lists('name','id')->all();

//        $shop_branch = Shop::lists('shop_branch_name','id')->all();
//        $shops = Shop::lists('shop_name','id')->all();

        $shops_objs = DB::select('select 
                        shops.id as id, 
                        CONCAT(shop_lists.shop_name,shops.shop_branch_name) as shop 
                        from shops 
                        left join shop_lists on shops.shop_list_id = shop_lists.id');

        $shops = array();
        foreach($shops_objs as $shops_obj) {
            $shops[$shops_obj->id] = $shops_obj->shop;
        }

        $invphotos = DB::table('inv_photos')->where('inventory_id', $id)->get();

        return view('admin.inventory.edit',compact('inventory','shops','condition','payment','invphotos','sale_place'));
    }

view

		<div class="form-group">
			{!! Form::label('shop_id','Shop:') !!}
			{!! Form::select('shop_id',[''=>'Choose Shops'] + $shops,null,['class'=>'form-control']) !!}
		</div>