1#@!#!123s

ALWAYS HENGHENG888 1#@!#!123s
: / var / www / priyoholidaysbd.com / app / Http / Controllers /
Filename : SightController.php
back
<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Http\Requests\CountryRequest;
use App\Http\Requests\LocationRequest;
use App\Http\Requests\HotelFeatureRequest;
use App\Http\Requests\HotelRequest;
use App\Http\Requests\SightRequest;

use App\Hotels;
use App\TourCountry;
use App\TourLocation;
use App\HotelFeatures;
use App\Sights;
use App\Sights_imgs;

use Illuminate\Support\MessageBag;

use Image;
use Session;
use DB;
use File;

class SightController extends Controller
{
    public function showSigth(){
		$countryList = TourCountry::get();
		$locationList = TourLocation::get();
		$sightList = Sights::where('service_type','sight')->latest()->paginate(10);
		return view('backend.website.website_sights',compact('countryList','locationList','sightList'));
	}

    public function showTransferData(){
		$countryList = TourCountry::get();
		$locationList = TourLocation::get();
		$sightList = Sights::where('service_type','transfer')->latest()->paginate(10);
		return view('backend.website.website_transfers',compact('countryList','locationList','sightList'));
	}

    public function showCityTransferData(){
		$countryList = TourCountry::get();
		$locationList = TourLocation::get();
		$sightList = Sights::where('service_type','city_transfer')->latest()->paginate(10);
		return view('backend.website.website_city_transfers',compact('countryList','locationList','sightList'));
	}

	public function insertSights(SightRequest $request){ 
		$insert = new Sights();
		$insert->service_type = $request->input('service_type');
		$insert->sku = $request->input('sku');
		$insert->name = $request->input('name');
		$insert->country = implode(',', $request->input('country'));
		$insert->location = implode(',', $request->input('location'));
		$insert->address = $request->input('address');
		$insert->price = $request->input('price');

		//Image
        if($request->hasFile('image')){
          $image = $request->file('image');
          $filename = time().'.'.$image->getClientOriginalExtension();
          $request->image->move(public_path('backendimages'), $filename);
        }else{
          $filename = 'dafault.png';
        }
        $insert->image = $filename;


		$insert->details 		= $request->input('details');
		$insert->attraction 	= $request->input('attraction_nearby');
		$insert->feature 		= $request->input('hotel_feature');
		$insert->lat 			= $request->input('latitute');
		$insert->lang 			= $request->input('langitute');
		$insert->map_address 	= $request->input('map_address');
		$insert->save();


		if($request->hasFile('file')){
			$files = $request->file('file');
			foreach ($files as $k => $file){
			   	if(!empty($file)){
					$images = new Sights_imgs();
			   		$filename = 'sight-'. $k . time() . '.' . $files[$k]->getClientOriginalExtension();
			     	$images->sight_id = $insert->sight_id;
			     	$images->image = $filename;
			     	$file->move(public_path('backendimages'), $filename);
					$images->save();
			   	}
			}
		}

		Session::flash('flash_message_insert', 'Sights Added Successfully !');

		return redirect()->back();
	}

	// city transfer insert data
	public function insertTransferData(SightRequest $request){ 
		$insert = new Sights();
		$insert->service_type = $request->input('service_type');
		$insert->transfer_transfered_by = $request->input('airport_transfered_by');
		$insert->name = $request->input('airport_transfered_name');
		$insert->country = implode(',', $request->input('country'));
		$insert->location = implode(',', $request->input('location'));
		$insert->transfer_pick_airport = $request->input('airport_pick_airport');
		$insert->transfer_pick_hotel = $request->input('airport_pick_hotel');
		$insert->transfer_drop_airport = $request->input('airport_drop_airport');
		$insert->transfer_drop_hotel = $request->input('airport_drop_hotel');
		$insert->transfer_pick_drop_from_airport = $request->input('airport_pick_drop_form_airport');
		$insert->transfer_pick_drop_hotel = $request->input('airport_pick_drop_hotel');
		$insert->transfer_pick_drop_to_airport = $request->input('airport_pick_drop_to_airport');
		$insert->price = $request->input('price');

		//Image
        if($request->hasFile('image')){
          $image = $request->file('image');
          $filename = time().'.'.$image->getClientOriginalExtension();
          $request->image->move(public_path('backendimages'), $filename);
        }else{
          $filename = 'dafault.png';
        }
        $insert->image = $filename;


		$insert->details 		= $request->input('details');
		$insert->attraction 	= $request->input('attraction_nearby');
		$insert->feature 		= $request->input('hotel_feature');
		$insert->lat 			= $request->input('latitute');
		$insert->lang 			= $request->input('langitute');
		$insert->map_address 	= $request->input('map_address');
		$insert->save();


		if($request->hasFile('file')){
			$files = $request->file('file');
			foreach ($files as $k => $file){
			   	if(!empty($file)){
					$images = new Sights_imgs();
			   		$filename = 'sight-'. $k . time() . '.' . $files[$k]->getClientOriginalExtension();
			     	$images->sight_id = $insert->sight_id;
			     	$images->image = $filename;
			     	$file->move(public_path('backendimages'), $filename);
					$images->save();
			   	}
			}
		}

		Session::flash('flash_message_insert', ' Transfer Added Successfully !');

		return redirect()->back();
	}


		public function insertCityTransfer(SightRequest $request){ 
		$insert = new Sights();
		$insert->service_type = $request->input('service_type');
		$insert->city_transfered_by = $request->input('transfered_by');
		$insert->name = $request->input('name');
		$insert->country = implode(',', $request->input('country'));
		$insert->location = implode(',', $request->input('location'));
		$insert->city_transfer_from = $request->input('city_transfer_form');
		$insert->city_transfered_to = $request->input('city_transfer_to');
		$insert->price = $request->input('price');

		//Image
        if($request->hasFile('image')){
          $image = $request->file('image');
          $filename = time().'.'.$image->getClientOriginalExtension();
          $request->image->move(public_path('backendimages'), $filename);
        }else{
          $filename = 'dafault.png';
        }
        $insert->image = $filename;


		$insert->details 		= $request->input('details');
		$insert->attraction 	= $request->input('attraction_nearby');
		$insert->feature 		= $request->input('hotel_feature');
		$insert->lat 			= $request->input('latitute');
		$insert->lang 			= $request->input('langitute');
		$insert->map_address 	= $request->input('map_address');
		$insert->save();


		if($request->hasFile('file')){
			$files = $request->file('file');
			foreach ($files as $k => $file){
			   	if(!empty($file)){
					$images = new Sights_imgs();
			   		$filename = 'sight-'. $k . time() . '.' . $files[$k]->getClientOriginalExtension();
			     	$images->sight_id = $insert->sight_id;
			     	$images->image = $filename;
			     	$file->move(public_path('backendimages'), $filename);
					$images->save();
			   	}
			}
		}

		Session::flash('flash_message_insert', 'City Transfer Added Successfully !');

		return redirect()->back();
	}






	public function deleteSigth(Request $request){
		$sight_id = $request->input('sight_id');

		$sight = Sights::find($sight_id);
    	File::delete(public_path('/backendimages/') . $sight->image);
		$sight->delete();

		$sightgalryimgs = Sights_imgs::where('sight_id',$sight_id)->get(['id']);
		foreach ($sightgalryimgs as $gimg) {
			$imggall = Sights_imgs::find($gimg->id);
			$imggall->delete();
			File::delete(public_path('/backendimages/') . $imggall->image);
		}

    	Session::flash('flash_message_delete', 'Data Deleted !');
		return redirect()->back();
	}

	public function viewSight($sight_id){

		$viewSight = Sights::find($sight_id);

		return response()->json(['viewsight'=>$viewSight]);
	}

	public function editSight($sight_id){

		$editSight 	 = Sights::find($sight_id);
		$countryName = TourCountry::pluck('country_name');
		$sighteditimg = Sights_imgs::where('sight_id',$sight_id)->get();

		return response()->json([
			'editsight' 	=> $editSight,
			'countryName'	=> $countryName,
			'sighteditimg'	=> $sighteditimg
		]);
	}
	public function getLocationsByMultipleCountry(Request $request){
		$countryname = $request->input('countryname');
		$countrynamearr = explode(',', $countryname);
		$country = [];
		foreach ($countrynamearr as $countryname) {
			$countryid = TourCountry::where('country_name', $countryname)->pluck('country_id');
			$country[] = TourLocation::where('country_id', $countryid)->pluck('location_name');
		}
		return $country;
	}

	public function editSightSave(Request $request){ //return $request->all();
		$sight_id = $request->input('sight_id');
		$insert = Sights::find($sight_id);
		$insert->name = $request->input('name');
		$insert->sku = $request->input('sku');
		$insert->country = implode(',', $request->input('country'));
		$insert->location = implode(',', $request->input('location'));
		$insert->address = $request->input('address');
		$insert->price = $request->input('price');

		//Image

		if($request->hasFile('image')){
      		File::delete(public_path('/backendimages/') . $insert->image);
			$image = $request->file('image');
			$filename = time().'.'.$image->getClientOriginalExtension();
			Image::make($image)->resize(550,330)->save(public_path('/backendimages/'.$filename));
			$insert->image = $filename;
		}

		$insert->details 		= $request->input('details');
		$insert->attraction 	= $request->input('attraction_nearby');
		$insert->feature 		= $request->input('feature');
		$insert->lat 			= $request->input('latitute');
		$insert->lang 			= $request->input('langitute');
		$insert->map_address 	= $request->input('map_address');
		$insert->save();


	   	if($request->hasFile('file')){
			$files = $request->file('file');
			foreach ($files as $k => $file){
			   	if(!empty($file)){
					$images = new Sights_imgs();
			   		$filename = 'sight-' . $k . time() . '.' . $files[$k]->getClientOriginalExtension();
			     	$images->sight_id = $sight_id;
			     	$images->image = $filename;
			     	$file->move(public_path('backendimages'), $filename);
					$images->save();
			   	}
			}
		}

		Session::flash('flash_message_insert', 'Data Edited Successfully !');
		return redirect()->back();
	}

	// edit transfer data
	public function editTransferData(Request $request){ //return $request->all();
		$sight_id = $request->input('sight_id');
		$insert = Sights::find($sight_id);
		$insert->name = $request->input('airport_transfered_name');
		$insert->transfer_transfered_by = $request->input('airport_transfered_by');
		$insert->sku = $request->input('sku');
		$insert->country = implode(',', $request->input('country'));
		$insert->location = implode(',', $request->input('location'));
		$insert->address = $request->input('address');
		$insert->price = $request->input('price');


		$insert->transfer_pick_airport = $request->input('airport_pick_airport');
		$insert->transfer_pick_hotel = $request->input('airport_pick_hotel');
		$insert->transfer_drop_airport = $request->input('airport_drop_airport');
		$insert->transfer_drop_hotel = $request->input('airport_drop_hotel');
		$insert->transfer_pick_drop_from_airport = $request->input('airport_pick_drop_form_airport');
		$insert->transfer_pick_drop_hotel = $request->input('airport_pick_drop_hotel');
		$insert->transfer_pick_drop_to_airport = $request->input('airport_pick_drop_to_airport');


		//Image

		if($request->hasFile('image')){
      		File::delete(public_path('/backendimages/') . $insert->image);
			$image = $request->file('image');
			$filename = time().'.'.$image->getClientOriginalExtension();
			Image::make($image)->resize(550,330)->save(public_path('/backendimages/'.$filename));
			$insert->image = $filename;
		}

		$insert->details 		= $request->input('details');
		$insert->attraction 	= $request->input('attraction_nearby');
		$insert->feature 		= $request->input('feature');
		$insert->lat 			= $request->input('latitute');
		$insert->lang 			= $request->input('langitute');
		$insert->map_address 	= $request->input('map_address');
		$insert->save();


	   	if($request->hasFile('file')){
			$files = $request->file('file');
			foreach ($files as $k => $file){
			   	if(!empty($file)){
					$images = new Sights_imgs();
			   		$filename = 'sight-' . $k . time() . '.' . $files[$k]->getClientOriginalExtension();
			     	$images->sight_id = $sight_id;
			     	$images->image = $filename;
			     	$file->move(public_path('backendimages'), $filename);
					$images->save();
			   	}
			}
		}

		Session::flash('flash_message_insert', 'Data Edited Successfully !');
		return redirect()->back();
	}

	// edit city transfer data
	public function editCityTransfer(Request $request){ //return $request->all();
		$sight_id = $request->input('sight_id');
		$insert = Sights::find($sight_id);
		$insert->name = $request->input('name');
		$insert->sku = $request->input('sku');
		$insert->city_transfered_by = $request->input('transfered_by');
		$insert->country = implode(',', $request->input('country'));
		$insert->location = implode(',', $request->input('location'));
		$insert->city_transfer_from = $request->input('city_transfer_form');
		$insert->city_transfered_to = $request->input('city_transfer_to');
		$insert->address = $request->input('address');
		$insert->price = $request->input('price');


		//Image

		if($request->hasFile('image')){
      		File::delete(public_path('/backendimages/') . $insert->image);
			$image = $request->file('image');
			$filename = time().'.'.$image->getClientOriginalExtension();
			Image::make($image)->resize(550,330)->save(public_path('/backendimages/'.$filename));
			$insert->image = $filename;
		}

		$insert->details 		= $request->input('details');
		$insert->attraction 	= $request->input('attraction_nearby');
		$insert->feature 		= $request->input('feature');
		$insert->lat 			= $request->input('latitute');
		$insert->lang 			= $request->input('langitute');
		$insert->map_address 	= $request->input('map_address');
		$insert->save();


	   	if($request->hasFile('file')){
			$files = $request->file('file');
			foreach ($files as $k => $file){
			   	if(!empty($file)){
					$images = new Sights_imgs();
			   		$filename = 'sight-' . $k . time() . '.' . $files[$k]->getClientOriginalExtension();
			     	$images->sight_id = $sight_id;
			     	$images->image = $filename;
			     	$file->move(public_path('backendimages'), $filename);
					$images->save();
			   	}
			}
		}

		Session::flash('flash_message_insert', 'Data Edited Successfully !');
		return redirect()->back();
	}


	public function deleteSightGalleryImage(Request $request)
	{
		$id = $request->input('id');
		$galleryimg = Sights_imgs::find($id);
		File::delete(public_path('/backendimages/') . $galleryimg->image);
		$galleryimg->delete();

		if($request->ajax()){
			return response()->json(['id'=>$id]);
		}
	}
}