public function reserve_ticket(Request $request)
   {
        $name=$request->get('name');
        $pp = $request->get('pp');
        $nn = $request->get('nn');
        $cost = $request->get('cost');
        $datein = $request->get('datein');
        $dateout = $request->get('dateout');
        $source = $request->get('source');
        $endways = $request->get('endways');
        $time_out = $request->get('time_out');
        $id_van = DB::table('carride_tbls')->where('source',$source)
                                           ->Where('endways',$endways)
                                           ->Where('time_out',$time_out)->value('id_van');
        $carride_id=DB::table('carride_tbls')->where('source',$source)
                                           ->Where('endways',$endways)
                                           ->Where('time_out',$time_out)->value('carrid_id');
        if($request->get('book_below')=="true")
        {
          if(count(DB::table('reservations')->where('id_van',$id_van)->where('date',$dateout)->get())>0)
            $seat = DB::table('reservations')->where('id_van',$id_van)->where('date',$dateout)->get();
          else
            $seat=null;
        }
        else
        {
            if(count(DB::table('reservations')->where('id_van',$id_van)->where('date',$datein)->get())>0)
                $seat = DB::table('reservations')->where('id_van',$id_van)->where('date',$datein)->get();
            else
                $seat=null;
       }
        $carride_tbls = DB::table('carride_tbls')->orderBy('carrid_id', 'desc')->paginate(25);
        $carride = (Carride_tbl::find($carride_id));
        $van = (Van_tbl::find($carride->id_van));
        return view('reserve_ticket')->with('carride',$carride)
                                      ->with('carride_tbls',$carride_tbls)
                                      ->with('van',$van)
                                      ->with('pp',$pp)
                                      ->with('nn',$nn)
                                      ->with('cost',$cost)
                                      ->with('datein',$datein)
                                      ->with('dateout',$dateout)
                                      ->with('time_out',$time_out)
                                      ->with('id_van',$id_van)
                                      ->with('seat',$seat)
                                      ->with('twoways',$request->get('twoways'))
                                      ->with('book_above',$request->get('book_above'))
                                      ->with('book_below',$request->get('book_below'))
                                      ->with('name',$request->get('name'));

   }