<?php

namespace App\Http\Controllers\Admin;

use App\Http\Controllers\Controller;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use Mail;
use App\Mail\Reservation;
use App\TableReservations;
use App\Mail\ReservationAccept;
use App\Mail\ReservationReject;

class ReservationController extends Controller
{
    /**
     * Create a new controller instance.
     *
     * @return void
     */
    public $data = [];
    public function __construct(){
    }

    /**
     * Show the application dashboard.
     *
     * @return \Illuminate\Http\Response
     */
    
    /*
    | Reservations view
    |--------------------------------------------------------------------------
    */
    public function get_reservations()
    {
        $this->data['title'] = 'Reservations'; 
        $this->data['reservations'] = TableReservations::orderBy('id','desc')->get();

        $template_accept = "";
        $file_to_open = base_path() . "/resources/views/email/reservation_accept.blade.php";
        if(file_exists($file_to_open)){
			$template_accept = file_get_contents($file_to_open);
        }
        $this->data['template_accept'] = $template_accept;

        $template_reject = "";
        $file_to_open = base_path() . "/resources/views/email/reservation_reject.blade.php";
        if(file_exists($file_to_open)){
			$template_reject = file_get_contents($file_to_open);
        }
        $this->data['template_reject'] = $template_reject;

        return view('admin.reservations.reservations', $this->data);
    }

    /*
    | Change booking status
    |--------------------------------------------------------------------------
    */
    public function status_booking(Request $request)
    {   
        $booking = TableReservations::find($request->id);
        $emaildata = array('id' => $booking->id,'name' =>$booking->name,'person' =>$booking->person,'booking_date' =>$booking->booking_date,'booking_time' => $booking->booking_time);

        if($request->status == 1){
            DB::table('table_reservations')->where('id',$request->id)->update(['verify_booking' => 1]);
            
            // Accept
			if($booking->email != ''){
                $email = $booking->email;
                Mail::to($email)->queue(new ReservationAccept($emaildata));
			}

        }else{
            DB::table('table_reservations')->where('id',$request->id)->update(['verify_booking' => 2]);

            // Reject
			if($booking->email != ''){
                $email = $booking->email;
                Mail::to($email)->queue(new ReservationReject($emaildata));
			}
        }
        
        return response()->json($booking->verify_booking);
    }

    /*
    | email templates
    |--------------------------------------------------------------------------
    */
    public function emailTemplates(Request $request)
    {
        if($request->template_accept){
            $template_accept = $request->template_accept;
            unlink(base_path() . "/resources/views/email/reservation_accept.blade.php");
            $fp = fopen(base_path() . "/resources/views/email/reservation_accept.blade.php","wb");
            fwrite($fp,$template_accept);
            fclose($fp);
        }

        if($request->template_reject){
            $template_reject = $request->template_reject;
            unlink(base_path() . "/resources/views/email/reservation_reject.blade.php");
            $fp = fopen(base_path() . "/resources/views/email/reservation_reject.blade.php","wb");
            fwrite($fp,$template_reject);
            fclose($fp);
        }

        return back();
    }

}