<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Http\Controllers\Controller;
use App\Proposal;
use App\User;
use App\StudentProposal;
use App\Country;
use App\Models\ReferUser;
use App\Models\Admin;
use App\Models\Requirement;
use App\Models\University;
use App\Models\Publication;
use App\Workexperience;
use App\Institution;
use App\Score;
use Hash;
use DB;
use Session;
use Auth;
use Mail;

class ModalController extends Controller{

    public function get(Request $req, $name){
        $user = Auth::user();
        $carbon=new \Carbon\Carbon;

        $data=[
            'name'=>$name,
            'carbon'=>$carbon
        ];

        if($name=="apply_student_proposal"){
            $student =Auth::user();
            $data['teacher'] = User::find($req->t_id);
            $data['student'] = User::find($student->id);
            $data['proposal']= Proposal::where('student_id',$user->id)->get();
        }elseif($name=="view_apply_proposal"){
            $data['std_proposal'] =StudentProposal::find($req->id);

        }elseif($name=="view_student_proposal"){
            $data['proposal']= Proposal::where(
                    'student_id',$user->id
                )->where(
                    'id',$req->id
                )->first();

        }elseif($name=="add_destination"){

        }elseif($name=="add_wishlist"){
            $user =Auth::guard('teacher')->user();
            $data['refer'] = new ReferUser;

        }elseif($name=="teacher_invited"){
            $data['admin'] =Admin::find($req->id);

        }elseif($name=="add_doc_required"){
            $data['std_proposal']=StudentProposal::find($req->id);
        }elseif($name=="edit_doc_required"){
            $data['requirements']=Requirement::find($req->id);
        }elseif($name=="landing_ragister_form"){
            $data['countries'] =Country::where('status',1)->orderBy('name','ASC')->get();
            //$data['universities'] =University::orderBy('name','ASC')->get();
        }else $name='default';


        return view("modal_pages.{$name}", $data);
    }

    public function post(Request $req, $name){

        $user=Auth::user();
        $carbon=new \Carbon\Carbon;

        if($name=='apply_student_proposal'){

            $new_rules=[
                'proposal_id'=>'required',
            ];

            $validator=\Validator::make($req->all(),$new_rules,[
                'proposal_id.required'=>'No Proposal available.',
                'startdate'=>'required',
                'startmonth'=>'required',
            ]);

            if($validator->fails()){

                $errors=$validator->errors()->all();
                return response(['msg'=>$errors[0]], 422);
            }

            $already_exists = StudentProposal::where('student_id',$req->student_id)->exists();
            if($already_exists){
                return response(['msg'=>'Sorry! You already submitted. You can not submit proposal.'],403);
            }

            //$publication =Publication::where('student_id',$req->student_id)->doesntExist();
            //$worK_exp =Workexperience::where('student_id',$req->student_id)->doesntExist();
            //$institution =Institution::where('student_id',$req->student_id)->doesntExist();
            //$score =Score::where('student_id',$req->student_id)->doesntExist();
            
            $publication =User::where('id',$req->student_id)->whereNull('is_publication')->exists();
            $worK_exp =User::where('id',$req->student_id)->whereNull('is_work_experience')->exists();
            $institution =User::where('id',$req->student_id)->whereNull('is_education')->exists();
            $score =User::where('id',$req->student_id)->whereNull('is_test_score')->exists();

            if($publication || $worK_exp || $institution || $score){
                return response(['msg'=>'you didn\'t complete your profile.'],403);
            }

             
            $student_proposal =new StudentProposal;
            $student_proposal->student_id =$req->student_id;
            $student_proposal->teacher_id =$req->teacher_id;
            $student_proposal->proposal_id =$req->proposal_id;
            $student_proposal->start_year =$req->startdate;
            $student_proposal->start_month =$req->startmonth;
            $student_proposal->created_by =$user->id;
            $student_proposal->student_apply_ref =studentRefNoGenerate();
            $student_proposal->save();

            $student_data =User::find($student_proposal->student_id);
            $student_data->freez_profile =1;
            $student_data->update();
            
            $proposal_user =User::find($student_proposal->teacher_id);

			 if($user){
				$data['name'] = $student_data->first_name.' '.$student_data->last_name;
				$data['teacher'] = $proposal_user->first_name.' '.$proposal_user->last_name;
				$data['arn'] = $proposal_user->ref_no;
				$user_mail =$student_data->email;
				$from = 'asraful@revinr.com';
				Mail::send('email.student_proposal_email',$data, function ($message) use ($user_mail,$from,$student_proposal) {
					$message->from($from);
					$message->to($user_mail)->subject('Apply Ref:' .$student_proposal->student_apply_ref. '- Proposal has been submitted successfully ');
				});
			 }

             $proposal =Proposal::where(
                    'student_id',$student_proposal->student_id
                )->where(
                    'id',$student_proposal->proposal_id
                )->first();

             if($proposal_user){
                $data['name'] = $proposal_user->first_name.' '.$proposal_user->last_name;
                $data['std_name'] = $user->first_name.' '.$user->last_name;
                $data['proposal_title'] =$proposal->title;
                $data['date_time']=$student_proposal->created_at;
				$user_mail =$proposal_user->email;
				$from = 'asraful@revinr.com';
				Mail::send('email.teacher_proposal_email',$data, function ($message) use ($user_mail,$from) {
					$message->from($from);
					$message->to($user_mail)->subject('New Email Send to you');
				});
             }


            return response(['msg'=>'Proposal send successfully.']);

        }elseif($name=="add_wishlist"){
            $user =Auth::guard('teacher')->user();
            $validator=\Validator::make($req->all(), [
                'name'=>'required',
                'email'=>'required|email|max:255|unique:users'
            ]);

            if($validator->fails()){
                $errors=$validator->errors()->all();
                return response(['msg'=>$errors[0]], 422);
            }

            $already_exists =User::where('email',$req->email)->exists();

            if($already_exists){
                return response(['msg'=>'Sorry! this email is already exists!.'],403);
            }

            $user_data =new User;
            $user_data->first_name =$req->name;
            $user_data->email =$req->email;
            $user_data->wishlist_teacher_id =$user->id;
            $user_data->user_type =1;
            $user_data->save();

            $refer =new ReferUser;
            $refer->name =$req->name;
            $refer->email =$req->email;
            $refer->refer_by =$user->id;
            $refer->teacher_id =$user->id;
            $refer->save();

            if($refer->save()){
                $data['name'] = $refer->name;
                $data['teacher_id'] = $refer->teacher_id;
                $data['student_id'] = $user_data->id;
                $data['std_email'] = $refer->email;
                $data['applicant_name'] = $user->first_name.' '.$user->last_name;
                $user_mail = $refer->email;
                $from = 'asraful@revinr.com';

                Mail::send('email.wishlist_email',$data, function ($message) use ($user_mail,$from) {
                    $message->from($from);
                    $message->to($user_mail)->subject('Research Admission Platform Sign-Up');
                });
            }

            return response(
                ['msg'=>'Refer saved successfully.']
            );

        }elseif($name=="teacher_invited"){

            $admin =Admin::find($req->id);
            $validator=\Validator::make($req->all(), [
                'name'=>'required',
                'email'=>'required|email|max:255'
            ]);

            if($validator->fails()){
                $errors=$validator->errors()->all();
                return response(['msg'=>$errors[0]], 422);
            }

            $user_check_data =User::where('email',$req->email)->doesntExist();

            if($user_check_data){
               // return response(['msg'=>'Sorry! this email is already exists!.'],403);
                $user_data =new User;
                $user_data->first_name =$req->name;
                $user_data->email =$req->email;
                $user_data->admin_invite_id =$admin->id;
                $user_data->user_type =2;
                $user_data->register_type =1; // 1=invitation ; 2=wishlist/landing
                $user_data->registered_date =now();  
                $user_data->save();
            } 

            $user_data =User::where('email',$req->email)->where('user_type',2)->first();

            $refer =new ReferUser;
            $refer->name =$req->name;
            $refer->email =$req->email;
            $refer->refer_by =$admin->id; 
            $refer->teacher_id =$user_data->id; 
            $refer->save();


            if($refer->save()){
                $data['name'] = $refer->name;
                $data['teacher_id'] = $user_data->id;
                $data['applicant_name'] = $admin->first_name.' '.$admin->last_name;
                $data['email']=$refer->email;
                $user_mail = $refer->email;
                $from = 'asraful@revinr.com';

                Mail::send('email.teacher_invited_email',$data, function ($message) use ($user_mail,$from) {
                    $message->from($from);
                    $message->to($user_mail)->subject('Manage Doctoral Applicants with Ease - You’re invited!');
                });
            }

            $already_invited =ReferUser::where('email',$refer->email)->count();

            if($already_invited > 0) {
                return response(
                    ['msg'=>"Successfully saved. Already invitation send {$already_invited} times."]
                ); 
            }else{
                return response(
                    ['msg'=>'Invitation saved successfully.']
                );

            }


        }elseif($name=="add_doc_required"){
            $user=auth_user();

            $new_rules=[
                'others'=>'required|array',
                'others.*.requirement_title'=>'required',
            ];
            $validator=\Validator::make($req->all(),$new_rules,[
                'others.*.requirement_title.required'=>'Please!, fill-up all requirement field.'
            ]);

            if($validator->fails()){
                $errors=$validator->errors()->all();
                return response(['msg'=>$errors[0]], 422);
            }

            $std_proposal=StudentProposal::find($req->id);

            foreach($req->others as $row){
                   Requirement::create([
                    'std_proposal_id'=>$std_proposal->id,
                    'requirement_title'=>$row['requirement_title'],
                    'need_upload'=>$row['need_upload'],
                    'created_by'=>$user->id
                ]);
            }

            return response([
                'msg'=>'Successfully Saved.'
            ]);

        }elseif($name=="edit_doc_required"){
            $requirements=Requirement::find($req->id);
            $requirements->requirement_title =$req->requirement_title;
            $requirements->need_upload =$req->need_upload;
            $requirements->update();

            return response([
                'msg'=>'Successfully updated.'
            ]);
        }elseif($name=="landing_ragister_form"){

            $validator=\Validator::make($req->all(), [
                'name'=>'required',
                'email'=>'required|email|max:255|unique:users'
            ]);

            if($validator->fails()){
                $errors=$validator->errors()->all();
                return response(['msg'=>$errors[0]], 422);
            }

            // $already_exists =User::where('email',$req->email)->exists();

            // if($already_exists){
            //     return response(['msg'=>'Sorry! this email is already exists!.'],403);
            // }

            $user_check_data =User::where('email',$req->email)->doesntExist();

            if($user_check_data){ 
               $user_data =new User;
               $user_data->first_name =$req->name;
               $user_data->email =$req->email;
               $user_data->nationality =$req->country_id;
               $user_data->university_name =$req->university;
               $user_data->uni_website =$req->uni_website;
               $user_data->user_type =2;
               $user_data->register_type =2; // 1=invitation ; 2= landing/wishlish
              // $user_data->invitation_date =now();  
               $user_data->save();
            } 

            $user =User::where('email',$req->email)->where('user_type',2)->first();
            
                $refer =new ReferUser;
                $refer->name =$req->name;
                $refer->email =$req->email;
                $refer->teacher_id =$user->id; 
                $refer->save();

            return response(
                ['msg'=>'Successfully saved.']
            );
        }

        return response(['msg'=>'No name argument found.'], 403);

    }

}