public function scopeGetTotalCalled($scope)
{
$current_gen = Gen::getCurrentGen();
$classes = StudyClass::where('gen_id', $current_gen->id)->get();
$class_id_list = $classes->pluck('id')->all();
$count = Register::whereIn('class_id', $class_id_list)->select('user_id')->where('call_status', 1)->groupBy('user_id')->get()->count();
return $count;
}
public function transform($course)
{
if ($this->user) {
$this->classTransformer->setUser($this->user);
}
$current_gen = Gen::getCurrentGen();
return ['name' => $course->name, 'detail' => $course->detail, 'description' => $course->description, 'icon_url' => $course->icon_url, 'image_url' => $course->image_url, 'cover_url' => $course->cover_url, 'classes' => $this->classTransformer->transformCollection($course->classes()->where('gen_id', $current_gen->id)->orderBy('name', 'desc')->get())];
}
public function scopeGetCurrentGen()
{
//status = 1: gen dang duoc tuyen sinh
$gens = Gen::where('status', 1)->get();
if ($gens->count() > 0) {
$gen = $gens[0];
} else {
$gen = new Gen();
$gen->id = -1;
$gen->name = "Không có";
}
return $gen;
}
public function search_student(Request $request)
{
$search = "";
if ($request->q) {
$search = $request->q;
}
$gen = Gen::getCurrentGen();
$students = User::where('role', 0)->whereExists(function ($query) use($gen) {
$query->select(DB::raw(1))->from('registers')->where('status', 0)->where('gen_id', $gen->id)->where('call_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 . '%');
})->orderBy('created_at', 'desc')->take(5)->get();
return response()->json(['students' => $this->studentTransformer->transformCollection($students)]);
}
public function enroll($domain, $classId)
{
$register = $this->user->registers()->where('class_id', $classId)->first();
if ($register) {
return $this->respond(['message' => "Bạn đă đăng kí lớp học này. "]);
} else {
$register = new Register();
$register->user_id = $this->user->id;
$register->gen_id = Gen::getCurrentGen()->id;
$register->class_id = $classId;
$register->status = 0;
$register->save();
send_mail_confirm_registration($this->user, $classId, ["*****@*****.**", "*****@*****.**"]);
return $this->respond(['message' => "Bạn đă đăng kí thành công. Bạn hãy check email để kiểm tra thông tin đăng kí."]);
}
}
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
$date = new \DateTime();
$date->modify('+3 days');
$formatted_date_from = $date->format('Y-m-d');
$date->modify('+6 days');
$formatted_date_to = $date->format('Y-m-d');
$dates = createDateRangeArray(strtotime($formatted_date_from), strtotime($formatted_date_to));
$bases = Base::where('center', 1)->get();
$current_gen = Gen::getCurrentGen();
$shiftSessions = ShiftSession::where('active', 1)->get();
$lastShift = Shift::where('gen_id', $current_gen->id)->orderBy('week', 'desc')->first();
$week = $lastShift ? $lastShift->week : 0;
foreach ($dates as $date) {
foreach ($bases as $base) {
foreach ($shiftSessions as $shiftSession) {
$shift = new Shift();
$shift->gen_id = $current_gen->id;
$shift->base_id = $base->id;
$shift->shift_session_id = $shiftSession->id;
$shift->week = $week + 1;
$shift->date = $date;
$shift->save();
}
}
}
$role_ids = Tab::find(35)->roles->pluck('id')->unique()->toArray();
$roles = Role::whereIn('id', $role_ids)->get();
if ($week == 0) {
$week = 1;
}
foreach ($roles as $role) {
$users = $role->users;
foreach ($users as $user) {
send_mail_regis_shift($user, $week, $current_gen, ['*****@*****.**']);
}
}
$this->info('done');
}
public function send_rating(Request $request = null)
{
$gen = Gen::find($request->gen_id);
$this->data['gen'] = $gen;
$this->data['gens'] = Gen::all();
return view('manage.send_rating', $this->data);
}
public function get_current_shifts($gen_id = null)
{
if ($gen_id) {
$current_gen = Gen::find($gen_id);
} else {
$current_gen = Gen::getCurrentGen();
}
$shifts = $current_gen->shifts()->get();
$weeks = $shifts->pluck('week')->unique()->sortByDesc(function ($week, $key) {
return $week;
});
$return_arr = [];
foreach ($weeks as $week) {
$week_shifts = $shifts->where('week', $week);
$dates = $week_shifts->pluck('date')->unique();
$return_dates = [];
foreach ($dates as $date) {
$obj = new \stdClass();
$obj->date = date_shift(strtotime($date));
$obj->shifts = $shifts->filter(function ($item) use($date) {
return $item->date == $date;
});
$shiftsData = $this->shiftTransfromer->transformCollection($obj->shifts);
$obj->shifts = $shiftsData;
$return_dates[] = $obj;
}
$return_arr[] = ['dates' => $return_dates, 'week' => $week];
}
return response()->json(['weeks' => $return_arr]);
}
public function landing_register(Request $request)
{
$user = User::where('email', '=', $request->email)->first();
// dd('WORK');
if ($user == null) {
$user = new User();
$user->name = $request->name;
$user->phone = $request->phone;
$user->email = $request->email;
$user->university = $request->university;
$user->work = $request->work;
$user->address = $request->address;
$user->how_know = $request->how_know;
$user->username = $request->email;
$user->facebook = $request->facebook;
$user->gender = $request->gender;
$user->dob = strtotime($request->dob);
$user->password = bcrypt($request->phone);
$user->save();
} else {
$user->university = $request->university;
$user->work = $request->work;
$user->address = $request->address;
$user->phone = $request->phone;
$user->gender = $request->gender;
$user->dob = date('Y-m-d', strtotime($request->dob));
$user->facebook = $request->facebook;
$user->save();
}
$register = new Register();
$register->user_id = $user->id;
$register->gen_id = Gen::getCurrentGen()->id;
$register->class_id = $request->class_id;
$register->status = 0;
$register->leader_phone = $request->leader_phone;
$register->coupon = $request->coupon;
$register->save();
send_mail_confirm_registration($user, $request->class_id, ["*****@*****.**", "*****@*****.**"]);
return redirect('register_success');
}
public function dashboard($domain, $gen_id, $base_id = null)
{
// $current_gen = Gen::getCurrentGen();
if ($this->user->role == 0) {
return $this->responseUnAuthorized('Bạn không có quyền truy cập dữ liệu này');
}
$data = [];
if ($gen_id) {
$current_gen = Gen::find($gen_id);
} else {
return response()->json([message => "gen_id is required"], 400);
}
$data['current_gen'] = $this->genTransformer->transform($current_gen);
if ($base_id == null) {
$zero_paid_num = Register::where('gen_id', $current_gen->id)->where('status', '=', 1)->where('money', '=', 0)->count();
$total_money = Register::where('gen_id', $current_gen->id)->sum('money');
$num = Register::where('gen_id', $current_gen->id)->count();
$paid_number = Register::where('gen_id', $current_gen->id)->where('code', "!=", "")->count();
$uncalled_number = Register::where('gen_id', $current_gen->id)->where('call_status', 0)->groupBy('user_id')->count();
$total_classes = $current_gen->studyclasses->count();
$remain_days = strtotime($current_gen->end_time) - time();
$registers_by_date = Register::select(DB::raw('count(1) as num'))->where('gen_id', $current_gen->id)->groupBy(DB::raw('DATE(created_at)'))->pluck('num')->toArray();
$money_by_date = Register::select(DB::raw('sum(money) as money'))->where('gen_id', $current_gen->id)->groupBy(DB::raw('DATE(paid_time)'))->pluck('money')->toArray();
$registers_by_hour = Register::select(DB::raw('HOUR(created_at) as \'hour\', count(1) as num'))->where('gen_id', $current_gen->id)->groupBy(DB::raw('HOUR(created_at)'))->get();
$registers_hour_array = array();
for ($i = 0; $i < 24; $i++) {
$registers_hour_array[$i] = 0;
}
foreach ($registers_by_hour as $regis) {
$registers_hour_array[$regis->hour] = $regis->num;
}
$data['money_by_date'] = $money_by_date;
$data['zero_paid_num'] = $zero_paid_num;
$data['classes'] = $this->classTransformer->transformCollection($current_gen->studyclasses);
$data['total_money'] = is_numeric($total_money) ? $total_money : 0;
$data['register_number'] = is_numeric($num) ? $num : 0;
$data['paid_number'] = is_numeric($paid_number) ? $paid_number : 0;
$data['uncalled_number'] = is_numeric($uncalled_number) ? $uncalled_number : 0;
$data['total_classes'] = is_numeric($total_classes) ? $total_classes : 0;
$data['remain_days'] = round((is_numeric($remain_days) ? $remain_days : 0) / (24 * 3600), 2);
$data['date_array'] = createDateRangeArray(strtotime($current_gen->start_time), strtotime($current_gen->end_time));
$data['registers_by_date'] = $registers_by_date;
$data['registers_by_hour'] = $registers_hour_array;
} else {
$base = Base::find($base_id);
$classes = $base->classes()->where('gen_id', $current_gen->id);
$registers = Register::where('gen_id', $current_gen->id)->where('gen_id', $current_gen->id)->whereIn('class_id', $classes->pluck('id'));
$zero_paid_num = Register::where('status', '=', 1)->where('money', '=', 0)->whereIn('class_id', $classes->pluck('id'))->count();
$total_money = $registers->sum('money');
$num = $registers->count();
$paid_number = $registers->where('gen_id', $current_gen->id)->where('code', "!=", "")->count();
$uncalled_number = $registers->where('call_status', 0)->groupBy('user_id')->count();
$total_classes = $classes->count();
$remain_days = strtotime($current_gen->end_time) - time();
$classes_id = $classes->pluck("id");
$registers_by_date = Register::select(DB::raw('count(1) as num'))->whereIn("class_id", $classes_id)->where('gen_id', $current_gen->id)->groupBy(DB::raw('DATE(created_at)'))->pluck('num')->toArray();
$registers_by_hour = Register::select(DB::raw('HOUR(created_at) as \'hour\', count(1) as num'))->whereIn("class_id", $classes_id)->where('gen_id', $current_gen->id)->groupBy(DB::raw('HOUR(created_at)'))->get();
$money_by_date = Register::select(DB::raw('sum(money) as money'))->whereIn("class_id", $classes_id)->where('gen_id', $current_gen->id)->groupBy(DB::raw('DATE(paid_time)'))->pluck('money')->toArray();
$registers_hour_array = array();
for ($i = 0; $i < 24; $i++) {
$registers_hour_array[$i] = 0;
}
foreach ($registers_by_hour as $regis) {
$registers_hour_array[$regis->hour] = $regis->num;
}
$data['money_by_date'] = $money_by_date;
$data['zero_paid_num'] = $zero_paid_num;
$data['classes'] = $this->classTransformer->transformCollection($current_gen->studyclasses);
$data['total_money'] = is_numeric($total_money) ? $total_money : 0;
$data['register_number'] = is_numeric($num) ? $num : 0;
$data['paid_number'] = is_numeric($paid_number) ? $paid_number : 0;
$data['uncalled_number'] = is_numeric($uncalled_number) ? $uncalled_number : 0;
$data['total_classes'] = is_numeric($total_classes) ? $total_classes : 0;
$data['remain_days'] = round((is_numeric($remain_days) ? $remain_days : 0) / (24 * 3600), 2);
$data['date_array'] = createDateRangeArray(strtotime($current_gen->start_time), strtotime($current_gen->end_time));
$data['registers_by_date'] = $registers_by_date;
$data['registers_by_hour'] = $registers_hour_array;
}
return response()->json($data, 200);
}
public function download_paid_students(Request $request)
{
$genId = $request->genid;
$gen = Gen::find($genId);
$registers_id = $gen->registers()->where('status', 1)->get()->pluck('user_id')->toArray();
$students = User::whereIn('id', $registers_id)->get();
$students = $students->map(function ($student) use($gen) {
$student->how_know = how_know($student->how_know);
$student->gender = gender($student->gender);
$student->dob = format_date($student->dob);
$registers = $student->registers()->where('gen_id', $gen->id)->get();
$student->class = $registers->map(function ($register) {
$class = $register->studyClass;
$base = $class->base;
$className = $class->name . " (" . $base->name . ": " . $base->address . ")";
return $className;
})->reduce(function ($carry, $item) {
return $carry . ", " . $item;
}, "");
unset($student->id);
unset($student->created_at);
unset($student->updated_at);
unset($student->role);
unset($student->code);
unset($student->avatar_url);
unset($student->cover_url);
unset($student->description);
unset($student->money);
unset($student->status);
unset($student->avatar_name);
unset($student->cover_name);
unset($student->cover_name);
unset($student->order);
unset($student->registers);
return $student;
})->toArray();
return Excel::create('Khoá ' . $gen->name, function ($excel) use($students) {
$excel->sheet('students', function ($sheet) use($students) {
$sheet->fromArray($students);
});
})->download('xls');
}
public function about_us_data($domain)
{
$gen = Gen::getCurrentGen();
$classes = $gen->studyclasses()->where('name', 'like', '%.%')->count();
$student = Register::where('code', '!=', null)->count() + 2000;
$posts = Product::count() + 4000;
return $this->respond(['gen' => ['name' => $gen->name, 'detail' => $gen->detail], 'studentsNumber' => $student, 'classesNumber' => $classes, 'postsNumber' => $posts]);
}
