[0035]クロージャでJOINする際に複数条件でのON (JOIN b ON a.id = b.id AND a.name = b.name)

■construct

複数条件のため、クロージャとONを利用します。

実際の例だと、LEFTJOIN book_negotiation_details ON book_negotiation_details.material_hidden = book_hotels.hotel_material_hidden AND book_negotiation_details.book_no = book_hotels.book_no

XXXController.php

              
$book_hotels = BookHotel::where('book_hotels.book_no',$book_no)->join('hotels','hotels.id','=','book_hotels.hotel_code')
        ->leftjoin('hotel_categorys','hotel_categorys.id','=','book_hotels.hotel_category')
        ->leftjoin('book_negotiation_details',function($hquery){
            $hquery->on('book_negotiation_details.material_hidden','=','book_hotels.hotel_material_hidden')
            ->on('book_negotiation_details.book_no','=','book_hotels.book_no')
            ->where('book_negotiation_details.material_case',2);
        })
        ->orderBy('book_hotels.sort_order')->get(['book_hotels.*','hotels.name as hname','hotel_categorys.name as catename','book_negotiation_details.negotiation_sup_price']);