public function search_student(Request $request)
{
$search = $request->search ? $request->search : '';
if ($search == '' || $search == null) {
return $this->responseBadRequest('No search term provided!');
}
$limit = $request->limit ? $request->limit : 10;
$students = User::where('role', 0)->whereExists(function ($query) {
$query->select(DB::raw(1))->from('registers')->where('status', 0)->whereRaw('registers.user_id = users.id');
})->where(function ($query) use($search) {
$query->where('email', 'like', '%' . $search . '%')->orWhere('phone', 'like', '%' . $search . '%')->orWhere('name', 'like', '%' . $search . '%');
})->paginate($limit);
$newest_code = Register::orderBy('code', 'desc')->first()->code;
return $this->respondWithPagination($students, ['data' => $this->studentTransformer->transformCollection($students), 'newest_code' => $newest_code]);
}
public function search_student(Request $request)
{
$search = $request->search;
$students = User::whereExists(function ($query) {
$query->select(DB::raw(1))->from('registers')->where('status', 0)->whereRaw('registers.user_id = users.id');
})->where(function ($query) use($search) {
$query->where('email', 'like', '%' . $search . '%')->orWhere('phone', 'like', '%' . $search . '%')->orWhere('name', 'like', '%' . $search . '%');
})->take(20)->get();
// $arr = array();
// foreach ($students as &$student) {
// if ($student->registers->count() > 0) {
// $arr[] = $student;
// }
// }
$this->data['students'] = $students;
$code = Register::orderBy('code', 'desc')->first()->code;
$nextNumber = explode("M", $code)[1] + 1;
$this->data['nextCode'] = "CM" . $nextNumber;
if ($students->count() > 0) {
return view('ajax.search_student', $this->data);
} else {
return "<h3>Không tìm thấy</h3>";
}
}
