public function getClassXById(Request $request)
{
onlyAllowPostRequest($request);
$id_user = intval($request->input('id'));
/**
* 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();
$id_class = $user->class;
$classX = ClassX::all()->where('id', $id_class)->first();
$response->error = false;
$class_x = new stdClass();
$class_x->id = $classX->id;
$class_x->name = $classX->khoa . $classX->lop;
$class_x->soSV = ClassX::getCountStudentByClassId($id_class);
$response->class = $class_x;
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);
}
