/**
* Define the application's command schedule.
*
* @param \Illuminate\Console\Scheduling\Schedule $schedule
*
* @return void
*/
protected function schedule(Schedule $schedule)
{
$schedule->command('inspire')->hourly();
// 进入维护模式
$schedule->command('down')->evenInMaintenanceMode()->dailyAt('23:00');
//->when(function () {return true;});//
// 更新用户等级
$schedule->call(function () {
$registrations = Registration::where('state', 0)->where(function ($query) {
$query->where('registration_date', Carbon::yesterday()->toDateString());
})->get();
foreach ($registrations as $registration) {
$user = $registration->user;
$user->credit_level -= 1;
$user->save();
}
})->evenInMaintenanceMode()->daily();
//
// 重置rest_num
$schedule->call(function () {
$doctor_schedules = DocSchedule::where('state', 0)->where(function ($query) {
$week = [1 => 'monday', 2 => 'tuesday', 3 => 'wednesday', 4 => 'thursday', 5 => 'friday', 6 => 'saturday', 7 => 'sunday'];
$query->where('doctoring_date', $week[Carbon::today()->dayOfWeek]);
})->get();
foreach ($doctor_schedules as $doctor_schedule) {
$doctor_schedule->rest_num = $doctor_schedule->total_num;
$doctor_schedule->save();
}
})->evenInMaintenanceMode()->dailyAt('3:00');
//
// 离开维护模式
$schedule->command('up')->evenInMaintenanceMode()->dailyAt('7:00');
//
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
$student = Auth::user();
$regs = Registration::where('student_id', '=', $student->id)->get();
if (count($regs) > 0) {
Flash::error('You have completed registration!.');
return redirect()->route('registration');
}
$courses = json_decode(stripslashes($request["courses_selected"]));
$courses_unique = array_unique($courses);
foreach ($courses_unique as $course) {
Registration::create(['course_id' => $course, 'student_id' => $student->id]);
}
Flash::success('Registration complete.');
return redirect()->route('registration.index');
}
public function traineeHome()
{
$id = Auth::user()->id;
$regId = Registration::where('user_id', '=', Auth::user()->id)->pluck('id');
$user_id = Auth::user()->id;
$course_ids = TraineeCourse::where('trainee_id', $user_id)->select('course_id')->get();
//$course_ids=Info::where('trainee_login_id', $user_id)->get();
$courseAttendance = [];
foreach ($course_ids as $course_id) {
$course_name = $this->course_name_by_course_id($course_id->course_id);
if (!$course_name->isempty()) {
$absent = Attendance::where('course_id', $course_id->course_id)->where('trainee_id', $user_id)->where('trainee_attendance', '=', 'A')->count('id');
$courseAttendance[] = array('course_name' => $course_name, 'absent' => $absent);
}
}
$info = Info::wheretrainee_login_id($user_id)->firstOrFail();
return view('trainee.trainee', compact('regId', 'courseAttendance', 'info'));
//dd($regId);
return view('trainee.trainee', compact('regId'))->with('id', $id);
}
/**
* 创建预约
*
* @param Request $request
* @param Schedule $schedule
*
* @return \Illuminate\Http\JsonResponse
*/
public function store(Request $request, Schedule $schedule)
{
$user = $request->user();
if (Registration::where(['user_id' => $user->id, 'schedule_id' => $schedule->id, 'registration_date' => $schedule->doctoring_date])->count() > 0) {
return response()->json(['status' => 2, 'message' => '已预约']);
}
if ($schedule->rest_num < 1) {
return response()->json(['status' => 3, 'message' => '暂无余号']);
}
$registration = new Registration();
$registration->schedule_id = $schedule->id;
$registration->registration_date = $schedule->doctoring_date;
$registration->fee = $schedule->doctor->fee;
$schedule->rest_num -= 1;
if ($user->registrations()->save($registration)) {
if ($schedule->save()) {
return response()->json(['status' => 0]);
} else {
return response()->json(['status' => 7, 'message' => '系统繁忙,请稍后再试']);
}
}
return response()->json(['status' => 7, 'message' => '系统繁忙,请稍后再试']);
}
public function register($event_slug)
{
$json['errors'] = [];
$json['messages'] = [];
$event = Event::where('slug', $event_slug)->where('verified', true)->first();
if (Session::has('id')) {
$student = Student::where('id', Session::get('id'))->first();
if ($event) {
if (Registration::where('student_id', Session::get('id'))->where('event_id', $event->id)->first()) {
$json['errors'][] = "Already Registered";
} else {
$round = $event->rounds->where('no', '1')->first();
$qualifier = new Qualifier();
$qualifier->save();
$round->qualifiers()->save($qualifier);
$student->qualifiers()->save($qualifier);
$registration = new Registration();
$registration->save();
$student->registrations()->save($registration);
$event->registrations()->save($registration);
$json['messages'][] = "successfull";
}
} else {
$json['errors'][] = "Event dont exist";
}
} else {
$json['errors'][] = "Please login to continue";
}
return response()->json($json);
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
$input = $request->all();
if (isset($input['img_path'])) {
$Image = $input['img_path'];
//dd($Image);
$imagePath = $this->imageUpload($Image);
//call public function imageUpload for small img
} else {
$imagePath = Registration::where('id', '=', $id)->pluck('img_path');
//dd($imagePath);
}
$regData = Registration::whereid($id)->firstOrFail();
//dd($input,$id);
$regData->bengali_name = $request->get('bengali_name');
$regData->english_name = $request->get('english_name');
$regData->father_name = $request->get('father_name');
$regData->mother_name = $request->get('mother_name');
$regData->date_of_birth = $request->get('date_of_birth');
$regData->village = $request->get('village');
$regData->post_office = $request->get('post_office');
$regData->upazila = $request->get('upazila');
$regData->district = $request->get('district');
$regData->id_code = $request->get('id_code');
$regData->organization = $request->get('organization');
$regData->telephone = $request->get('telephone');
$regData->fax = $request->get('fax');
$regData->e_mail = $request->get('e-mail');
$regData->mobile = $request->get('mobile');
$regData->joining_date = $request->get('joining_date');
$regData->service_code = $request->get('service_code');
$regData->marital_status = $request->get('marital_status');
$regData->contact_person_name = $request->get('contact_person_name');
$regData->contact_person_address = $request->get('contact_person_address');
$regData->contact_person_tel = $request->get('contact_person_tel');
$regData->participant_rel = $request->get('participant_rel');
$regData->img_path = $imagePath;
//$regData->edu_id=$lastEduId;
//$regData->user_id=1;
$regData->save();
DB::table('educations')->where('id', $regData->edu_id)->update(['name_of_degree' => $request->name_of_degree, 'subject' => $request->subject, 'Year' => $request->Year, 'board' => $request->board]);
return redirect()->intended('trainee')->with('status', 'Update Success!');
//return redirect()->intended('registration');
}
/**
* 获取医生出诊时间
*
* @param Request $request
* @param Doctor $doctor
*
* @return string
*/
public function getSchedules(Request $request, Doctor $doctor)
{
$user_id = empty($request->user()) ? '' : $request->user()->id;
$shedules = $doctor->schedules;
foreach ($shedules as $schedule) {
$schedule->ordered = Registration::where(['user_id' => $user_id, 'schedule_id' => $schedule->id, 'registration_date' => $schedule->doctoring_date])->count() > 0 ? 1 : 0;
}
return $shedules;
}
public function remove(Request $request)
{
$circle_id = $request->circle_id;
$pupil_id = $request->pupil_id;
Registration::where('circle_id', $circle_id)->where('pupil_id', $pupil_id)->delete();
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function traineeHome()
{
$regId = Registration::where('user_id', '=', Auth::user()->id)->pluck('id');
//dd($regId);
return view('trainee.trainee', compact('regId'));
}
