<?php

namespace App\Http\Controllers;

use App\Http\Controllers\SuperAdmin\CustomController;
use App\Models\Country;
use App\Models\Lab;
use App\Models\LabSettle;
use App\Models\LabWorkHours;
use App\Models\Pathology;
use App\Models\Radiology;
use App\Models\Report;
use App\Models\Setting;
use App\Models\User;
use Carbon\Carbon;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\Gate;
use Illuminate\Support\Facades\Hash;
use Illuminate\Support\Facades\Session;
use Symfony\Component\HttpFoundation\Response;

class LabSettingController extends Controller
{
    public function lab_login()
    {
        return view('lab.auth.login');
    }

    public function verify_pathologist(Request $request)
    {
        $request->validate([
            'email' => 'bail|required|email',
            'password' => 'bail|required|min:6'
        ]);

        if(Auth::attempt(['email' => request('email'), 'password' => request('password')]))
        {
            $pathologist = Auth::user()->load('roles');
            if($pathologist->hasRole('laboratory'))
            {
                if($pathologist->verify == 1)
                {
                    $lab = Lab::where('user_id',auth()->user()->id)->first();
                    if($lab->status == 1)
                    {
                        return redirect('pathologist_home');
                    }
                    else
                    {
                        Auth::logout();
                        return redirect()->back()->withErrors('you are disable by admin please contact admin');
                    }
                }
                else
                {
                    return 'verify nthi';
                    // return redirect('doctor/send_otp/'.$doctor->id);
                }
            }
            else
            {
                Auth::logout();
                return redirect()->back()->withErrors('Only Pathologist can login');
            }
        }
        else
        {
            return redirect()->back()->withErrors('your creditial does not match our record');
        }
    }

    public function pathologist_sign_up()
    {
        $countries = Country::get();
        return view('lab.auth.register',compact('countries'));
    }

    public function verify_sign_up(Request $request)
    {
        $request->validate([
            'user_name' => 'bail|required',
            'lab_name' => 'bail|required',
            'phone_code' => 'bail|required',
            'phone' => 'bail|required|digits_between:6,12',
            'address' => 'bail|required',
            'start_time' => 'bail|required',
            'end_time' => 'bail|required',
            'email' => 'bail|required|email|unique:users',
            'password' => 'bail|required|min:6',
            'image' => 'bail|max:1000'
        ],
        [
            'image.max' => 'The Image May Not Be Greater Than 1 MegaBytes.',
        ]);
        $data = $request->all();
        $veri = Setting::first()->verification == 1 ? 0 : 1;
        $user = User::create([
            'name' => $data['user_name'],
            'email' => $data['email'],
            'password' => Hash::make($data['password']),
            'verify' => $veri,
            'phone' => $data['phone'],
            'phone_code' => $data['phone_code'],
            'image' => 'defaultUser.png'
        ]);
        $user->assignRole('laboratory');
        if($request->hasFile('image'))
        {
            $data['image'] = (new CustomController)->imageUpload($request->image);
        }
        else
        {
            $data['image'] = 'defaultUser.png';
        }
        $data['start_time'] = strtolower(Carbon::parse($data['start_time'])->format('h:i a'));
        $data['end_time'] = strtolower(Carbon::parse($data['end_time'])->format('h:i a'));
        $data['user_id'] = $user->id;
        $data['name'] = $data['lab_name'];
        $data['status'] = 1;
        $data['commission'] = Setting::first()->pathologist_commission;
        $lab = Lab::create($data);
        $start_time = strtolower($lab->start_time);
        $end_time = strtolower($lab->end_time);
        $days = array('Sunday','Monday','Tuesday','Wednesday','Thursday','Friday','Saturday');
        for($i = 0; $i < count($days); $i++)
        {
            $master = array();
            $temp2['start_time'] = $start_time;
            $temp2['end_time'] = $end_time;
            array_push($master,$temp2);
            $work_time['lab_id'] = $lab->id;
            $work_time['period_list'] = json_encode($master);
            $work_time['day_index'] = $days[$i];
            $work_time['status'] = 1;
            LabWorkHours::create($work_time);
        }
        if ($user->verify == 1) 
            return redirect('/pathologist_home');
        else
        {
            Session::put('pathologist_id',$user);
            return redirect('/pathologist_send_otp');
        }
    }

    public function pathologist_send_otp()
    {
        $user = Session::get('pathologist_id');
        (new CustomController)->sendOtp($user);
        $status = '';
        if(Setting::first()->using_msg == 1 && Setting::first()->using_mail == 1)
            $status = 'verification code sent in email and phone';

        if ($status == '')
        {
            if (Setting::first()->using_msg == 1 || Setting::first()->using_mail == 1) {
                if (Setting::first()->using_msg == 1)
                    $status = 'verification code sent into phone';
                if (Setting::first()->using_mail == 1)
                    $status = 'verification code sent into email';
            }
        }
        return view('lab.auth.send_otp',compact('user'))->with('status',$status);
    }

    public function verify_pathologist_otp(Request $request)
    {
        $data = $request->all();
        $otp = $data['digit_1'] . $data['digit_2'] . $data['digit_3'] . $data['digit_4'];
        $user = User::find($request->user_id);
        if ($user) {
            if ($user->otp == $otp)
            {
                $user->verify = 1;
                $user->save();
                if(Auth::loginUsingId($user->id))
                {
                    session()->forget('pathologist_id');
                    return redirect('pathologist_home');
                }
            }
            else
                return redirect()->back()->with('error',__('otp does not match'));
        }
        else
        {
            return redirect()->back()->with('error',__('Oops.user not found.!'));
        }
    }

    public function pathologist_home()
    {
        $lab = Lab::where('user_id',auth()->user()->id)->first();
        $pathology = Pathology::where('lab_id',$lab->id)->count();
        $radiology = Radiology::where('lab_id',$lab->id)->count();
        $test_reports = Report::where('lab_id',$lab->id)->whereDate('created_at',Carbon::now(env('timezone')))->orderBy('id','DESC')->get();
        $currency = Setting::first()->currency_symbol;
        return view('lab.home',compact('pathology','radiology','test_reports','currency'));
    }

    public function lab_commission()
    {
        abort_if(Gate::denies('lab_commission'), Response::HTTP_FORBIDDEN, '403 Forbidden');
        $lab = Lab::where('user_id',auth()->user()->id)->first();
        $now = Carbon::today(env('timezone'));
        $currency = Setting::first()->currency_symbol;
        $past = Carbon::now(env('timezone'))->subDays(35);
        $now = Carbon::today(env('timezone'));
        $c = $now->diffInDays($past);
        $loop = $c / 10;
        $data = [];
        while ($now->greaterThan($past)) {
            $t = $past->copy();
            $t->addDay();
            $temp['start'] = $t->toDateString();
            $past->addDays(10);
            if ($past->greaterThan($now)) {
                $temp['end'] = $now->toDateString();
            } else {
                $temp['end'] = $past->toDateString();
            }
            array_push($data, $temp);
        }

        $settels = array();
        $orderIds = array();
        foreach ($data as $key)
        {
            $settle = LabSettle::where('lab_id', $lab->id)->where('created_at', '>=', $key['start'].' 00.00.00')->where('created_at', '<=', $key['end'].' 23.59.59')->get();
            $value['d_total_task'] = $settle->count();
            $value['admin_earning'] = $settle->sum('admin_amount');
            $value['lab_amount'] = $settle->sum('lab_amount');
            $value['d_total_amount'] = $value['admin_earning'] + $value['lab_amount'];
            $remainingOnline = LabSettle::where([['lab_id', $lab->id], ['payment', 0],['lab_status', 0]])->where('created_at', '>=', $key['start'].' 00.00.00')->where('created_at', '<=', $key['end'].' 23.59.59')->get();
            $remainingOffline = LabSettle::where([['lab_id', $lab->id], ['payment', 1],['lab_status', 0]])->where('created_at', '>=', $key['start'].' 00.00.00')->where('created_at', '<=', $key['end'].' 23.59.59')->get();

            $online = $remainingOnline->sum('lab_amount'); // admin e devana
            $offline = $remainingOffline->sum('admin_amount'); // admin e levana

            $value['duration'] = $key['start'] . ' - ' . $key['end'];
            $value['d_balance'] = $offline - $online; // + hoy to levana - devana
            array_push($settels,$value);
        }
        return view('superAdmin.lab.commission',compact('lab', 'currency','settels'));
    }

    public function show_lab_settalement(Request $request)
    {
        $duration = explode(' - ',$request->duration);
        $currency = Setting::first()->currency_symbol;
        $settle = LabSettle::where('created_at', '>=', $duration[0].' 00.00.00')->where('created_at', '<=', $duration[1].' 23.59.59')->get();
        foreach($settle as $s)
        {
            $s->date = $s->created_at->toDateString();
        }
        return response(['success' => true , 'data' => $settle , 'currency' => $currency]);
    }

    public function lab_timeslot()
    {
        $lab = Lab::where('user_id',auth()->user()->id)->first();
        $lab->workingHours = LabWorkHours::where('lab_id',$lab->id)->get();
        $lab->firstHours = LabWorkHours::where('lab_id',$lab->id)->first();
        return view('lab.schedule',compact('lab'));
    }
    
    public function display_lab_timeslot($id)
    {
        $work = LabWorkHours::find($id);
        return response(['success' => true , 'data' => $work]);
    }

    public function edit_lab_timeslot($id)
    {
        $work = LabWorkHours::find($id);
        return response(['success' => true , 'data' => $work]);
    }

    public function update_lab_timeslot(Request $request)
    {
        $data = $request->all();
        $work = LabWorkHours::find($request->working_id);
        $master = array();
        for ($i=0; $i < count($request->start_time); $i++)
        {
            $temp['start_time'] = strtolower($request->start_time[$i]);
            $temp['end_time'] = strtolower($request->end_time[$i]);
            array_push($master,$temp);
        }
        $data['period_list'] = json_encode($master);
        $data['status'] = $request->has('status') ? 1 : 0;
        $work->update($data);
        return redirect()->back();
    }

    public function change_lab_payment_status($id)
    {
        Report::find($id)->update(['payment_status' => 1]);
        return ['success' => true];
    }

    public function lab_profile()
    {
        $lab = Lab::where('user_id',auth()->user()->id)->first();
        $lab['start_time'] = strtolower(Carbon::parse($lab['start_time'])->format('H:i'));
        $lab['end_time'] = strtolower(Carbon::parse($lab['end_time'])->format('H:i'));
        return view('superAdmin.lab.edit_lab',compact('lab'));
    }
}