/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $input = Input::all(); $destination = TourDestination::where('name', '=', $input['slDestination'])->first(); $jquery = DB::table('tours'); if ($input['slDestination'] != 1) { $jquery->whereRaw('(depart_from = ? OR going_to = ?)', [$destination->id, $destination->id]); } if ($input['slDuration'] != -1) { $duration = explode('-', $input['slDuration']); if ($duration['1'] == ">") { $jquery->whereRaw('duration > ?', [$duration[0]]); } else { $jquery->whereBetween('duration', $duration); } } if ($input['slPrice'] != -1) { $price = explode('-', $input['slPrice']); if ($price['1'] == ">") { $jquery->whereRaw('price > ?', [$price[0]]); } else { $jquery->whereBetween('price', $price); } } $data = $jquery->where('active', 1)->get(); return view('search.findyourstrip', compact('data')); }
/** * Run the database seeds. * * @return void */ public function run() { $destinations = [['name' => 'Ha Noi', 'alias' => 'ha-noi', 'thumbnail' => '', 'region' => 'Northern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Ho Chi Minh', 'alias' => 'ho-chi-minh', 'thumbnail' => '', 'region' => 'Southern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Hue', 'alias' => 'hue', 'thumbnail' => '', 'region' => 'Central Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Da Nang', 'alias' => 'da-nang', 'thumbnail' => '', 'region' => 'Central Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Nha Trang', 'alias' => 'nha-trang', 'thumbnail' => '', 'region' => 'Central Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Vung Tau', 'alias' => 'vung-tau', 'thumbnail' => '', 'region' => 'Southern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Phu Quoc', 'alias' => 'phu-quoc', 'thumbnail' => '', 'region' => 'Southern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Da Lat', 'alias' => 'da-lat', 'thumbnail' => '', 'region' => 'Central Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Buon Me Thuot', 'alias' => 'buon-me-thuot', 'thumbnail' => '', 'region' => 'Central Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Phan Thiet', 'alias' => 'phan-thiet', 'thumbnail' => '', 'region' => 'Central Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Hoi An', 'alias' => 'hoi-an', 'thumbnail' => '', 'region' => 'Central Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Quy Nhon', 'alias' => 'quy-nhon', 'thumbnail' => '', 'region' => 'Central Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Bac Kan', 'alias' => 'bac-Kan', 'thumbnail' => '', 'region' => 'Northern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Mai Chau', 'alias' => 'mai-chau', 'thumbnail' => '', 'region' => 'Northern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Ha Long', 'alias' => 'ha-long', 'thumbnail' => '', 'region' => 'Northern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Ha Giang', 'alias' => 'ha-giang', 'thumbnail' => '', 'region' => 'Northern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Sapa', 'alias' => 'sapa', 'thumbnail' => '', 'region' => 'Northern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Hoa Binh', 'alias' => 'hoa-binh', 'thumbnail' => '', 'region' => 'Northern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Quang Tri', 'alias' => 'quang-tri', 'thumbnail' => '', 'region' => 'Central Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Quang Ninh', 'alias' => 'quang-ninh', 'thumbnail' => '', 'region' => 'Northern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Yen Minh', 'alias' => 'yen-minh', 'thumbnail' => '', 'region' => 'Northern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Dong Van', 'alias' => 'dong-van', 'thumbnail' => '', 'region' => 'Northern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Bac Ha', 'alias' => 'bac-ha', 'thumbnail' => '', 'region' => 'Northern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Dien Bien', 'alias' => 'dien-bien', 'thumbnail' => '', 'region' => 'Northern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Lai Chau', 'alias' => 'lai-chau', 'thumbnail' => '', 'region' => 'Northern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Son La', 'alias' => 'son-la', 'thumbnail' => '', 'region' => 'Northern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Hai Phong', 'alias' => 'hai-phong', 'thumbnail' => '', 'region' => 'Northern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Co To island', 'alias' => 'co-to-island', 'thumbnail' => '', 'region' => 'Northern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Ninh Binh', 'alias' => 'ninh-binh', 'thumbnail' => '', 'region' => 'Northern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Can Tho', 'alias' => 'can-tho', 'thumbnail' => '', 'region' => 'Southern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Soc Trang', 'alias' => 'soc-trang', 'thumbnail' => '', 'region' => 'Southern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Tay Ninh', 'alias' => 'tay-ninh', 'thumbnail' => '', 'region' => 'Southern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Cu Chi', 'alias' => 'cu-chi', 'thumbnail' => '', 'region' => 'Southern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Chau Doc', 'alias' => 'chau-doc', 'thumbnail' => '', 'region' => 'Southern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Ha Tien', 'alias' => 'ha-tien', 'thumbnail' => '', 'region' => 'Southern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'My Tho', 'alias' => 'my-tho', 'thumbnail' => '', 'region' => 'Southern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Mekong Delta', 'alias' => 'mekong-delta', 'thumbnail' => '', 'region' => 'Southern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Tien Giang', 'alias' => 'tien-giang', 'thumbnail' => '', 'region' => 'Southern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Vinh Long', 'alias' => 'vinh-long', 'thumbnail' => '', 'region' => 'Southern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Con Dao', 'alias' => 'con-dao', 'thumbnail' => '', 'region' => 'Southern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Dong Thap', 'alias' => 'dong-thap', 'thumbnail' => '', 'region' => 'Southern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Cai Be', 'alias' => 'cai-be', 'thumbnail' => '', 'region' => 'Southern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Quang Nam', 'alias' => 'quang-nam', 'thumbnail' => '', 'region' => 'Central Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Ca Mau', 'alias' => 'cai-be', 'thumbnail' => '', 'region' => 'Southern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Bac Lieu', 'alias' => 'bac-lieu', 'thumbnail' => '', 'region' => 'Southern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Long Hai', 'alias' => 'long-hai', 'thumbnail' => '', 'region' => 'Southern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Cao Bang', 'alias' => 'cao-bang', 'thumbnail' => '', 'region' => 'Northern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Phong Nha - Ke Bang', 'alias' => 'phong-nha-ke-bang', 'thumbnail' => '', 'region' => 'Northern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Quang Binh', 'alias' => 'quang-binh', 'thumbnail' => '', 'region' => 'Northern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Can Gio', 'alias' => 'can-gio', 'thumbnail' => '', 'region' => 'Southern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Lao Cai', 'alias' => 'lao-cai', 'thumbnail' => '', 'region' => 'Northern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Vinh Phuc', 'alias' => 'vinh-phuc', 'thumbnail' => '', 'region' => 'Northern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Bac Giang', 'alias' => 'bac-giang', 'thumbnail' => '', 'region' => 'Northern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Vinh', 'alias' => 'vinh', 'thumbnail' => '', 'region' => 'Central Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Kon Tum', 'alias' => 'Kon-Tum', 'thumbnail' => '', 'region' => 'Southern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Lang Son', 'alias' => 'Lang-Son', 'thumbnail' => '', 'region' => 'Northern Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Quang Ngai', 'alias' => 'quang-ngai', 'thumbnail' => '', 'region' => 'Central Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1], ['name' => 'Ninh Thuan', 'alias' => 'ninh-thuan', 'thumbnail' => '', 'region' => 'Central Vietnam', 'glat' => NULL, 'glong' => NULL, 'active' => 1]]; DB::table('tour_destinations')->delete(); foreach ($destinations as $destination) { TourDestination::create($destination); } }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $data = []; $data['tours'] = Tour::select('alias', 'name', 'duration')->latest('created_at')->where('day_tour', 0)->published()->take(6)->get(); $data['day_tours'] = Tour::select('alias', 'name')->latest('created_at')->where('day_tour', 1)->published()->take(12)->get(); $data['destinations'] = TourDestination::where('active', 1)->orderBy('name', 'ASC')->get(); $data['reviews'] = TourReview::latest('created_at')->where('active', 1)->take(4)->get(); $data['title'] = "Vietnam Tours - Planning tours to Vietnam with the best offers"; $data['description'] = "Book travel for less with specials on cheap airline tickets, hotels, car rentals, and flights on TraveloVietnam.com, your one-stop resource for travel and vacation needs"; $data['keywords'] = "vietnam travel, travel to vietnam, vietnam tours, tours in vietnam, vietnam hotels, hotels in vietnam, vietnam visa, visa to vietnam"; return view('welcome', $data); }
/** * Show the tours page filter by destination. * * @return \Illuminate\Http\Response */ public function destination($destination) { $region = ['northern', 'southern', 'central']; if (in_array($destination, $region)) { $destinations = TourDestination::where('region', '=', ucfirst($destination) . ' Vietnam')->get(); $des_array = []; foreach ($destinations as $des) { array_push($des_array, $des->id); } $tours = Tour::whereIn('going_to', $des_array)->orWhereIn('depart_from', $des_array)->published()->get(); return view('vietnam.destination', ['tours' => $tours, 'destination' => ucfirst($destination) . ' Vietnam']); } else { $destination = TourDestination::where('alias', '=', $destination)->first(); if ($destination) { $tours = Tour::where('going_to', $destination->id)->orWhere('depart_from', $destination->id)->published()->get(); return view('vietnam.destination', ['tours' => $tours, 'destination' => $destination->name]); } } }
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id) { $destination = TourDestination::findOrFail($id); $destination->delete(); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $destinations = TourDestination::where('active', 1)->get(); return view('tour_request.index')->withDestinations($destinations); }
/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { $tour = Tour::findOrFail($id); $destinations = TourDestination::select('name')->orderBy('name')->where('active', '1')->get(); return view('admin.tours.edit', ['tour' => $tour, 'destinations' => $destinations]); }