public function getTimetable(Request $request) { $user_id = $request->input('id'); /** * Dữ liệu trả về */ $response = new stdClass(); $user = User::getInfoById($user_id); if ($user == null) { $response->error = true; $response->error_msg = 'Đã có vấn đề xảy ra! Bạn vui long quay lại sau.'; return response()->json($response); } /** * Giáo viên */ if ($user->type == 'teacher') { $u_x_id = $user->id; $classSubXS = SubClassSubject::all()->where('teacher', intval($u_x_id))->where('nhom', 0); if ($classSubXS->count() == 0) { $response->error = true; $response->error_msg = 'Đã có vấn đề xảy ra! Bạn vui long quay lại sau.'; return response()->json($response); } $arr_items = []; foreach ($classSubXS as $i => $s) { $s_id = $s->id; $subClassSubject = SubClassSubject::all()->where('id', intval($s_id))->first(); $class_id = $subClassSubject->classSubject; $classSubject = ClassSubject::all()->where('id', intval($class_id))->first(); $subject_id = $classSubject->subject; $subject = Subject::all()->where('id', intval($subject_id))->first(); $item_s = new stdClass(); $item_s->maMH = $subject->maMH; $item_s->maLMH = $classSubject->maLMH; $item_s->name = $subject->name; $item_s->soTin = $subject->soTin; $item_s->viTri = $subClassSubject->viTri; $item_s->soTiet = $subClassSubject->soTiet; $item_s->soSV = $subClassSubject->soSV; $item_s->nhom = $subClassSubject->nhom; $item_s->address = $subClassSubject->address; $item_s->teacher = User::getInfoById($subClassSubject->teacher); $arr_items[] = $item_s; } } else { $timetable = TimeTable::all()->where('user', intval($user_id)); if ($timetable->count() == 0) { $response->error = true; $response->error_msg = 'Bạn chưa đồng bộ thời khóa biểu!'; return response()->json($response); } $arr_items = []; foreach ($timetable as $i => $s) { $s_id = $s->subClass; $subClassSubject = SubClassSubject::all()->where('id', intval($s_id))->first(); $class_id = $subClassSubject->classSubject; $classSubject = ClassSubject::all()->where('id', intval($class_id))->first(); $subject_id = $classSubject->subject; $subject = Subject::all()->where('id', intval($subject_id))->first(); $item_s = new stdClass(); $item_s->maMH = $subject->maMH; $item_s->maLMH = $classSubject->maLMH; $item_s->name = $subject->name; $item_s->soTin = $subject->soTin; $item_s->viTri = $subClassSubject->viTri; $item_s->soTiet = $subClassSubject->soTiet; $item_s->soSV = $subClassSubject->soSV; $item_s->nhom = $subClassSubject->nhom; $item_s->address = $subClassSubject->address; $item_s->teacher = User::getInfoById($subClassSubject->teacher); $arr_items[] = $item_s; } } $filter = []; $filter[0] = $arr_items[0]; $j = 0; for ($i = 1; $i < count($arr_items); $i++) { if ($filter[$j]->maLMH != $arr_items[$i]->maLMH || $filter[$j]->nhom != $arr_items[$i]->nhom) { $j++; $filter[$j] = $arr_items[$i]; } } $response->error = false; $response->timetable = $filter; return response()->json($response); }
public function getGroup(Request $request) { onlyAllowPostRequest($request); $id_user = intval($request->input('id')); $base = $request->input('base'); /** * Dữ liệu trả về */ $response = new stdClass(); $users = User::all()->where('id', $id_user); if ($users->count() == 0) { // $response->error = true; $response->error_msg = 'Không tồn tại người dùng này!'; return response()->json($response); } $user = $users->first(); $arrGroup = []; if ($base == 'class_xes') { $id_class = $user->class; $classX = ClassX::all()->where('id', $id_class)->first(); $class_x = new stdClass(); $class_x->id = $classX->id; $class_x->base = $base; $class_x->name = $classX->name; $class_x->soSV = ClassX::getCountStudentByClassId($id_class); $class_x->teacher = User::getInfoById($classX->teacher); $arrGroup = [$class_x]; } if ($base == 'classSubject') { /** * Giáo viên */ if ($user->type == 'teacher') { $u_x_id = $user->id; $classSubXS = SubClassSubject::all()->where('teacher', intval($u_x_id))->where('nhom', 0); if ($classSubXS->count() == 0) { $response->error = true; $response->error_msg = 'Đã có vấn đề xảy ra! Bạn vui long quay lại sau.'; return response()->json($response); } $arrGroup = []; foreach ($classSubXS as $k => $cls) { $sub_id = $cls->id; $subClassSubject = SubClassSubject::all()->where('id', intval($sub_id))->first(); $teacher_id = $subClassSubject->teacher; $lmh_id = $subClassSubject->classSubject; $classSubject = ClassSubject::all()->where('id', intval($lmh_id))->first(); $maLMH = $classSubject->maLMH; $subject_id = $classSubject->subject; $subject = Subject::all()->where('id', intval($subject_id))->first(); $cl = new stdClass(); $cl->base = 'classSubject'; $cl->id = $classSubject->id; $cl->maLMH = $maLMH; $cl->name = $subject->name; $cl->soSV = $subClassSubject->soSV; $cl->teacher = User::getInfoById($teacher_id); $arrGroup[] = $cl; } } else { $timeTables = TimeTable::all()->where('user', $user->id); if ($timeTables->count() == 0) { $response->error = true; $response->error_msg = 'Tài khoản chưa có lớp môn học nào!'; return response()->json($response); } foreach ($timeTables as $tt) { $sub_id = $tt->subClass; $subClassSubject = SubClassSubject::all()->where('id', intval($sub_id))->first(); $teacher_id = $subClassSubject->teacher; $lmh_id = $subClassSubject->classSubject; $classSubject = ClassSubject::all()->where('id', intval($lmh_id))->first(); $maLMH = $classSubject->maLMH; $subject_id = $classSubject->subject; $subject = Subject::all()->where('id', intval($subject_id))->first(); $cl = new stdClass(); $cl->base = 'classSubject'; $cl->id = $classSubject->id; $cl->maLMH = $maLMH; $cl->name = $subject->name; $cl->soSV = $subClassSubject->soSV; $cl->teacher = User::getInfoById($teacher_id); if ($subClassSubject->nhom == 0) { $arrGroup[] = $cl; } } } } $filter = []; $filter[0] = $arrGroup[0]; $j = 0; for ($i = 1; $i < count($arrGroup); $i++) { if ($filter[$j]->maLMH != $arrGroup[$i]->maLMH) { $j++; $filter[$j] = $arrGroup[$i]; } } $arrGroup = $filter; $response->error = false; $response->group = $arrGroup; return response()->json($response); }