/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
$date = new \DateTime();
$date->modify('+1 days');
$formatted_date = $date->format('Y-m-d');
$classLessons = ClassLesson::whereDate('time', '=', $formatted_date)->get();
foreach ($classLessons as $classLesson) {
$lesson = $classLesson->lesson;
$class = $classLesson->studyClass;
$surveys = $lesson->surveys;
foreach ($surveys as $survey) {
$classSurvey = new ClassSurvey();
$classSurvey->class_id = $class->id;
$classSurvey->survey_id = $survey->id;
$classSurvey->send_status = 1;
$gen = $class->gen;
foreach ($class->registers()->where("status", 1)->get() as $register) {
$student = $register->user;
$surveyUser = SurveyUser::where('gen_id', $gen->id)->where('survey_id', $survey->id)->where('user_id', $student->id)->first();
if ($surveyUser == null) {
$surveyUser = new SurveyUser();
$surveyUser->survey_id = $survey->id;
$surveyUser->user_id = $student->id;
$surveyUser->gen_id = $gen->id;
$surveyUser->save();
}
}
$classSurvey->save();
}
}
$this->info('The surveys were sent successfully!');
}
public function ajax_send_survey(Request $request)
{
$classSurvey = new ClassSurvey();
$classSurvey->class_id = $request->class_id;
$classSurvey->survey_id = $request->survey_id;
$classSurvey->send_status = 1;
$class = StudyClass::find($request->class_id);
$gen = $class->gen;
foreach ($class->registers()->where("status", 1)->get() as $register) {
$student = $register->user;
$surveyUser = SurveyUser::where('gen_id', $gen->id)->where('survey_id', $request->survey_id)->where('user_id', $student->id)->first();
if ($surveyUser == null) {
$surveyUser = new SurveyUser();
$surveyUser->survey_id = $request->survey_id;
$surveyUser->user_id = $student->id;
$surveyUser->gen_id = $gen->id;
$surveyUser->save();
// send_mail_goodbye($register, ['*****@*****.**']);
}
}
$classSurvey->save();
return ' <i class=" teal-text material-icons">done</i>';
}