本文整理匯總了PHP中Facilities::join方法的典型用法代碼示例。如果您正苦於以下問題：PHP Facilities::join方法的具體用法？PHP Facilities::join怎麽用？PHP Facilities::join使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Facilities的用法示例。
在下文中一共展示了Facilities::join方法的1個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: index
/**
* Display a listing of the resource.
* GET /facilities
*
* @return Response
*/
public function index()
{
$facility = Facilities::join('facility_pic', 'facility.ID_Facility', '=', 'facility_pic.ID_Facility')->where('facility_pic.Main_Pic', '=', 'YES')->where('facility.Status', '=', 'Active')->paginate(5, ['facility.Facility_Name', 'facility_pic.Picture', DB::raw("CONCAT(SUBSTRING(facility.Description, 1, 100), '...') as isiFac"), 'facility.ID_Facility']);
$faciList = Facilities::where('Status', '=', 'Active')->get();
$data['room'] = Rooms::select('roomtype.RoomType_Name', 'roomtype.ID_RoomType', 'roomtype_pic.Picture')->join('roomtype_pic', 'roomtype.ID_RoomType', '=', 'roomtype_pic.ID_RoomType')->where('roomtype_pic.Main_Pic', '=', 'YES')->where('roomtype.Status', '=', 'Active')->take(40)->get()->all();
$data['offer'] = Offer::where('Status', '=', 'Active')->take(40)->get()->all();
$data['about'] = About::get()->all();
return View::make('Facilities.index', compact('facility'))->with('faci_active', 'active')->with('faciList', $faciList)->with('data', $data);
}