本文整理匯總了PHP中StudentInfo::findOrFail方法的典型用法代碼示例。如果您正苦於以下問題：PHP StudentInfo::findOrFail方法的具體用法？PHP StudentInfo::findOrFail怎麽用？PHP StudentInfo::findOrFail使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類StudentInfo的用法示例。
在下文中一共展示了StudentInfo::findOrFail方法的1個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: anySearch
/**
* Open Job Search
*
* @param string $catId
*/
public function anySearch($catId = null)
{
$categories = array();
if (Input::has("q") && trim(Input::get("q")) != "") {
$q = strtolower(Input::get("q"));
$foundCategories = JobCategory::whereRaw("LOWER(keywords) LIKE '%{$q}%' OR Lower(name) LIKE '%{$q}%'")->lists("id");
$categories = array_merge($categories, $foundCategories);
} else {
if (Input::has("catId") && intval(Input::get("catId")) > 0) {
$catId = intval(Input::get("catId"));
$categories[] = $catId;
}
}
$user = Sentry::getUser();
$student = StudentInfo::findOrFail($user->id);
$studentAddress = $student->primaryAddress;
if ($studentAddress == null) {
$studentAddress = $student->primaryAddress;
}
// $categories=$student->studentJobPreferences->lists("id");
$orWhereQ = array();
if (count($categories) > 0) {
$orWhereQ[] = '`jobs`.`job_category_id` IN (' . implode(",", $categories) . ')';
}
if (isset($q)) {
$subWhereTitle = array();
$subWhereDescript = array();
if (strpos($q, ' ') > 0) {
foreach (explode(' ', $q) as $r) {
$subWhereTitle[] = "LOWER(`jobs`.`job_title`) LIKE '%" . $r . "%'";
$subWhereDescript[] = "LOWER(`jobs`.`job_description`) LIKE '%" . $r . "%'";
}
$orWhereQ[] = "(" . implode(" AND ", $subWhereTitle) . ")";
$orWhereQ[] = "(" . implode(" AND ", $subWhereDescript) . ")";
} else {
$orWhereQ[] = "LOWER(`jobs`.`job_title`) LIKE '%" . $q . "%'";
$orWhereQ[] = "LOWER(`jobs`.`job_description`) LIKE '%" . $q . "%'";
}
}
if (count($orWhereQ) > 0) {
$jobs = Job::whereJobStatusId(JobStatus::$OPEN)->where("jobs.start_date", ">=", date("Y-m-d"))->whereRaw('(' . implode(" OR ", $orWhereQ) . ")")->select("jobs.*", Address::distanceSelectStatement($studentAddress->latitude, $studentAddress->longitude, 'distance', 'jobs'))->orderBy('jobs.start_date', 'asc')->having("distance", "<=", $student->studentProfile->preferred_job_radius)->get();
} else {
$jobs = Job::whereJobStatusId(JobStatus::$OPEN)->where("jobs.start_date", ">=", date("Y-m-d"))->select("jobs.*", Address::distanceSelectStatement($studentAddress->latitude, $studentAddress->longitude, 'distance', 'jobs'))->orderBy('jobs.start_date', 'asc')->having("distance", "<=", $student->studentProfile->preferred_job_radius)->get();
}
$student->load('userCertifications');
return View::make("jobs.search", compact("jobs", "student"));
}