本文整理匯總了PHP中app\Question::whereNotNull方法的典型用法代碼示例。如果您正苦於以下問題:PHP Question::whereNotNull方法的具體用法?PHP Question::whereNotNull怎麽用?PHP Question::whereNotNull使用的例子?那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類app\Question
的用法示例。
在下文中一共展示了Question::whereNotNull方法的1個代碼示例,這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚,您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: index
/**
* Show the application dashboard to the user.
*
* @return Response
*/
public function index()
{
if (Auth::user()) {
$countryId = Auth::user()->country_id;
} else {
$location = GeoIPFacade::getLocation();
$countryId = Country::where('country_code', '=', $location['isoCode'])->first()->id;
}
$questions = Question::whereNotNull('questions.user_id')->whereNotNull('questions.question_category_id')->whereNotNull('questions.country_id')->where('questions.is_displayed', '=', 1)->where('questions.country_id', '=', $countryId)->where('questions_countries.country_id', '=', $countryId)->with('author')->with('category')->with('country')->join('questions_countries', 'questions.id', '=', 'questions_countries.question_id')->orderBy('questions_countries.count', 'DESC')->limit(5)->get();
$allQuestions = Question::orderBy('updated_at', 'DESC')->paginate(10);
return view('pages.home', compact('questions', 'allQuestions'));
}