/**
* @var $query_restrict , will be "department,grade"
* department 1 ~ 60
* grade 1 ~ 6
*/
public function query($query_restrict)
{
$department = substr($query_restrict, 0, -2);
$grade = substr($query_restrict, -1);
if ($grade < 6) {
return $this->course->where('course_department', 'like', "%" . $department . "%")->where('course_grade', $grade)->get();
} else {
return $this->course->where('course_department', 'like', "%" . $department . "%")->get();
}
}
public function query($query_restrict, $extend)
{
$rule = $this->valid_query_string($query_restrict);
if (empty($rule)) {
return new \Illuminate\Database\Eloquent\Collection();
}
if (isset($extend['now'])) {
$this->course = $this->course->where('time1', '!=', '');
}
foreach ($rule as $key => $value_array) {
$column = $this->rule_mapping[$key];
$this->course = $this->course->where(function ($query) use($column, $value_array) {
if ($column == 'course_department' || $column == 'time1' || $column == 'time2' || $column == 'place') {
foreach ($value_array as $value) {
$query->orWhere($column, 'like', '%' . $value . '%');
}
} else {
$query->whereIn($column, $value_array);
}
});
}
return $this->course->get();
}
public function query($query_restrict, $extend)
{
return $this->course->where("course_nameCH", 'like', "%" . $query_restrict . "%")->orWhere("course_nameEN", 'like', "%" . $query_restrict . "%")->get();
}
