芝麻web文件管理V1.00

编辑当前文件:/home/qrafawbu/rentandbuyrealty.com/rentandbuyrealty.com/app/Http/Controllers/ApiController.php

<?php

namespace App\Http\Controllers;

use DateTime;

use Exception;
use Carbon\Carbon;
use App\Models\Type;
use App\Models\User;
use App\Models\Chats;
use App\Models\Slider;

use GuzzleHttp\Client;
use App\Models\Article;
use App\Models\Package;
use App\Models\Setting;
use App\Models\Category;
use App\Models\Customer;
use App\Models\Language;

use App\Models\Payments;
use App\Models\Projects;
use App\Models\Property;
use App\Libraries\Paypal;
use App\Models\Favourite;
use App\Models\parameter;

use App\Models\Usertokens;
use App\Models\SeoSettings;
use Carbon\CarbonInterface;
use Illuminate\Support\Str;
use App\Models\ProjectPlans;
use App\Models\user_reports;
use App\Models\UserInterest;
use Illuminate\Http\Request;
use App\Libraries\Paypal_pro;
use App\Models\Advertisement;
use App\Models\Notifications;
use App\Models\InterestedUser;
use App\Models\PropertyImages;

// use GuzzleHttp\Client;
use App\Models\report_reasons;
use App\Models\Contactrequests;

use App\Models\AssignParameters;

use App\Models\ProjectDocuments;
use function PHPSTORM_META\type;
use Tymon\JWTAuth\Claims\Issuer;
use App\Models\OutdoorFacilities;
use kornrunner\Blurhash\Blurhash;
use Illuminate\Support\Facades\DB;
use Tymon\JWTAuth\Facades\JWTAuth;
use App\Models\UserPurchasedPackage;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\Http;

use App\Models\AssignedOutdoorFacilities;
// use PayPal_Pro as GlobalPayPal_Pro;
use Illuminate\Support\Facades\Validator;

use Tymon\JWTAuth\Exceptions\JWTException;
use Intervention\Image\ImageManagerStatic as Image;

class ApiController extends Controller
{

//* START :: get_system_settings   *//
    public function get_system_settings(Request $request)
    {

$result = '';

$result =  Setting::select('type', 'data')->get();
        $data_arr = [];

foreach ($result as $row) {

if ($row->type == "place_api_key" || $row->type == "stripe_secret_key") {

$publicKey = file_get_contents(base_path('public_key.pem')); // Load the public key
                $encryptedData = '';
                if (openssl_public_encrypt($row->data, $encryptedData, $publicKey)) {

$tempRow[$row->type] = base64_encode($encryptedData);
                }
            } else if ($row->type == 'company_logo') {

$tempRow[$row->type] = url('/assets/images/logo/logo.png');
            } else if ($row->type == 'web_logo' || $row->type == 'web_placeholder_logo' || $row->type == 'app_home_screen' || $row->type == 'web_footer_logo') {

$tempRow[$row->type] = url('/assets/images/logo/') . '/' . $row->data;
            } else {
                $tempRow[$row->type] = $row->data;
            }
        }

if (($request->user_id) != "") {
            update_subscription($request->user_id);

$customer_data = Customer::find($request->user_id);
            if ($customer_data->isActive == 0) {

$tempRow['is_active'] = false;
            } else {
                $tempRow['is_active'] = true;
            }
            if ($row->type == "seo_settings") {

$tempRow[$row->type] = $row->data == 1 ? true : false;
            }

$data = UserPurchasedPackage::where('modal_id', $request->user_id)->where('end_date', '<', Carbon::now())->where('end_date', '!=', NULL)->get();

$customer = Customer::select('id', 'subscription', 'is_premium')
                ->where(function ($query) {
                    $query->where('subscription', 1)
                        ->orWhere('is_premium', 1);
                })
                ->find($request->user_id);

if (($customer)) {

// if (count($data)) {

//     $customer->subscription = 0;
                //     $customer->update();
                // }
                $tempRow['is_premium'] = $customer->is_premium == 1 ? true : ($customer->subscription == 1 ? true : false);

$tempRow['subscription'] = $customer->subscription == 1 ? true : false;
            } else {

$tempRow['is_premium'] = false;
                $tempRow['subscription'] = false;
            }
        }
        $language = Language::select('code', 'name')->get();
        $user_data = User::find(1);
        $tempRow['admin_name'] = $user_data->name;
        $tempRow['admin_image'] = url('/assets/images/faces/2.jpg');
        $tempRow['demo_mode'] = env('DEMO_MODE');
        $tempRow['languages'] = $language;
        $tempRow['img_placeholder'] = url('/assets/images/placeholder.svg');

$tempRow['min_price'] = DB::table('propertys')
            ->selectRaw('MIN(CAST(price AS DECIMAL(10, 2))) as min_price')
            ->value('min_price');

$tempRow['max_price'] = DB::table('propertys')
            ->selectRaw('MAX(CAST(price AS DECIMAL(10, 2))) as min_price')
            ->value('min_price');

if (!empty($result)) {
            $response['error'] = false;
            $response['message'] = "Data Fetch Successfully";
            $response['data'] = $tempRow;
        } else {
            $response['error'] = false;
            $response['message'] = "No data found!";
            $response['data'] = [];
        }
        return response()->json($response);
    }
    //* END :: Get System Setting   *//

//* START :: user_signup   *//
    public function user_signup(Request $request)
    {
        $validator = Validator::make($request->all(), [
            'type' => 'required',
            'firebase_id' => 'required',

]);

if (!$validator->fails()) {
            $type = $request->type;
            $firebase_id = $request->firebase_id;

$user = Customer::where('firebase_id', $firebase_id)->where('logintype', $type)->get();
            if ($user->isEmpty()) {
                    $saveCustomer = new Customer();
                    $saveCustomer->name = isset($request->name) ? $request->name : '';
                    $saveCustomer->email = isset($request->email) ? $request->email : '';
                    $saveCustomer->mobile = isset($request->mobile) ? $request->mobile : '';
                    // $saveCustomer->profile = isset($request->profile) ? $request->profile : '';

// $saveCustomer->fcm_id = isset($request->fcm_id) ? $request->fcm_id : '';
                    $saveCustomer->logintype = isset($request->type) ? $request->type : '';
                    $saveCustomer->address = isset($request->address) ? $request->address : '';
                    $saveCustomer->firebase_id = isset($request->firebase_id) ? $request->firebase_id : '';

$saveCustomer->about_me = isset($request->about_me) ? $request->about_me : '';
                    $saveCustomer->facebook_id = isset($request->facebook_id) ? $request->facebook_id : '';
                    $saveCustomer->twiiter_id = isset($request->twiiter_id) ? $request->twiiter_id : '';
                    $saveCustomer->instagram_id = isset($request->instagram_id) ? $request->instagram_id : '';
                    $saveCustomer->pintrest_id = isset($request->pintrest_id) ? $request->pintrest_id : '';

$saveCustomer->latitude = isset($request->latitude) ? $request->latitude : '';
                    $saveCustomer->longitude = isset($request->longitude) ? $request->longitude : '';
                    $saveCustomer->notification = 1;

$destinationPath = public_path('images') . config('global.USER_IMG_PATH');
                    if (!is_dir($destinationPath)) {
                        mkdir($destinationPath, 0777, true);
                    }
                    // image upload

if ($request->hasFile('profile')) {
                        $profile = $request->file('profile');
                        $imageName = microtime(true) . "." . $profile->getClientOriginalExtension();
                        $profile->move($destinationPath, $imageName);
                        $saveCustomer->profile = $imageName;
                    } else {
                        $saveCustomer->profile = $request->profile;
                    }

$saveCustomer->save();
                    if (isset($request->fcm_id)) {
                        $token_exist = Usertokens::where('fcm_id', $request->fcm_id)->where('customer_id', $saveCustomer->id)->get();
                        if (!count($token_exist)) {
                            $user_token = new Usertokens();
                            $user_token->customer_id = $saveCustomer->id;
                            $user_token->fcm_id = isset($request->fcm_id) ? $request->fcm_id : '';
                            $user_token->api_token = '';
                            $user_token->save();
                        }
                        $saveCustomer->fcm_id = ($request->fcm_id) ? $request->fcm_id : '';
                    }

$start_date =  Carbon::now();
                    $package = Package::find(1);

if ($package && $package->status == 1) {
                        $user_package = new UserPurchasedPackage();
                        $user_package->modal()->associate($saveCustomer);
                        $user_package->package_id = 1;
                        $user_package->start_date = $start_date;
                        $user_package->end_date =  Carbon::now()->addDays($package->duration);
                        $user_package->save();

$saveCustomer->subscription = 1;
                        $saveCustomer->update();
                    }

$response['error'] = false;
                    $response['message'] = 'User Register Successfully';

$credentials = Customer::find($saveCustomer->id);
                    $credentials = Customer::where('firebase_id', $firebase_id)->where('logintype', $type)->first();

$token = JWTAuth::fromUser($credentials);
                    try {
                        if (!$token) {
                            $response['error'] = true;
                            $response['message'] = 'Login credentials are invalid.';
                        } else {
                            $credentials->api_token = $token;

$credentials->update();
                        }
                    } catch (JWTException $e) {
                        $response['error'] = true;
                        $response['message'] = 'Could not create token.';
                    }
                    $response['token'] = $token;
                    $response['data'] = $credentials;
            } else {
                $credentials = Customer::where('firebase_id', $firebase_id)->where('logintype', $type)->first();
                try {
                    if ($credentials->isActive == 0) {
                        $response['error'] = true;
                        $response['message'] = 'Account Deactivated by Administrative please connect to them';
                        $response['is_active'] = false;
                        return response()->json($response);
                    }

$token = JWTAuth::fromUser($credentials);
                    if (!$token) {
                        $response['error'] = true;
                        $response['message'] = 'Login credentials are invalid.';
                    } else {
                        $credentials->api_token = $token;
                        $credentials->fcm_id = ($request->fcm_id) ? $request->fcm_id : '';

$credentials->update();
                        if (isset($request->fcm_id)) {

$token_exist = Usertokens::where('fcm_id', $request->fcm_id)->where('customer_id', $credentials->id)->get();
                            if (!count($token_exist)) {
                                $user_token = new Usertokens();
                                $user_token->customer_id = $credentials->id;
                                $user_token->fcm_id = isset($request->fcm_id) ? $request->fcm_id : '';
                                $user_token->api_token = '';
                                $user_token->save();
                            }
                        }
                    }
                } catch (JWTException $e) {
                    $response['error'] = true;
                    $response['message'] = 'Could not create token.';
                }

$response['error'] = false;
                $response['message'] = 'Login Successfully';
                $response['token'] = $token;
                $response['data'] = $credentials;
            }
        } else {
            $response['error'] = true;
            $response['message'] = 'Please fill all data and Submit';
        }
        return response()->json($response);
    }

//* START :: get_slider   *//
    public function get_slider(Request $request)
    {
        $tempRow = array();
        $slider = Slider::select('id', 'image', 'sequence', 'category_id', 'propertys_id')->orderBy('sequence', 'ASC')->get();
        if (!$slider->isEmpty()) {
            foreach ($slider as $row) {
                $property = Property::with('parameters')->find($row->propertys_id);

$tempRow['id'] = $row->id;
                // $tempRow['image'] = $row->image;
                $tempRow['sequence'] = $row->sequence;
                $tempRow['category_id'] = $row->category_id;
                $tempRow['propertys_id'] = $row->propertys_id;
                $tempRow['video_link'] = $property->video_link;
                $tempRow['image'] = $row->image;

$promoted = Slider::where('propertys_id', $row->propertys_id)->first();

if ($promoted) {

} else {
                    $tempRow['promoted'] = false;
                }
                $tempRow['slug_id'] = $property->slug_id;
                $tempRow['property_title'] = $property->title;
                $tempRow['property_title_image'] = $property->title_image;
                $tempRow['property_price'] = $property->price;

if ($property->propery_type == 0) {
                    $tempRow['property_type'] = "sell";
                } elseif ($property->propery_type == 1) {
                    $tempRow['property_type'] = "rent";
                } elseif ($property->propery_type == 2) {
                    $tempRow['property_type'] = "sold";
                } elseif ($property->propery_type == 3) {
                    $tempRow['property_type'] = "Rented";
                }

$tempRow['parameters'] = [];

foreach ($property->parameters as $res) {
                    if (is_string($res->pivot->value) && is_array(json_decode($res->pivot->value, true))) {
                        $value = json_decode($res->pivot->value, true);
                    } else {
                        if ($res->type_of_parameter == "file") {
                            if ($res->pivot->value == "null") {
                                $value = "";
                            } else {
                                $value = url('') . config('global.IMG_PATH') . config('global.PARAMETER_IMG_PATH') . '/' .  $res->pivot->value;
                            }
                        } else {
                            if ($res->pivot->value == "null") {
                                $value = "";
                            } else {
                                $value = $res->pivot->value;
                            }
                        }
                    }

$parameter = [
                        'id' => $res->id,
                        'name' => $res->name,

'value' => $value,
                    ];
                    array_push($tempRow['parameters'], $parameter);
                }

$advertisement = Advertisement::where(['property_id' => $row->propertys_id,'type' => 'Slider'])->first();
                if ($advertisement) {
                    if ($advertisement->status == 0 && $advertisement->is_enable == 1) {
                        $tempRow['promoted'] = true;
                    } else {
                        $tempRow['promoted'] = false;
                    }
                }else{
                    $tempRow['promoted'] = false;
                }

$rows[] = $tempRow;
            }

$response['error'] = false;
            $response['message'] = "Data Fetch Successfully";
            $response['data'] = $rows;
        } else {
            $response['error'] = false;
            $response['message'] = "No data found!";
            $response['data'] = [];
        }
        return response()->json($response);
    }

//* END :: get_slider   *//

//* START :: get_categories   *//
    public function get_categories(Request $request)
    {
        $offset = isset($request->offset) ? $request->offset : 0;
        $limit = isset($request->limit) ? $request->limit : 10;

$categories = Category::select('id', 'category', 'image', 'parameter_types', 'meta_title', 'meta_description', 'meta_keywords', 'slug_id')->where('status', '1')->withCount(['properties' => function ($q) {
            $q->where('status', 1);
        }]);

if (isset($request->search) && !empty($request->search)) {
            $search = $request->search;
            $categories->where('category', 'LIKE', "%$search%");
        }

if (isset($request->id) && !empty($request->id)) {
            $id = $request->id;
            $categories->where('id', $id);
        }
        if (isset($request->slug_id) && !empty($request->slug_id)) {
            $id = $request->slug_id;
            $categories->where('slug_id',$request->slug_id);
        }

$total = $categories->get()->count();
        $result = $categories->orderBy('sequence', 'ASC')->skip($offset)->take($limit)->get();

$result->map(function ($result) {
            $result['meta_image'] = $result->image;
        });
        // $categoriesWithCount = Category::withCount('properties')->get();

if (!$result->isEmpty()) {
            $response['error'] = false;
            $response['message'] = "Data Fetch Successfully";
            foreach ($result as $row) {
                $parameterData = parameterTypesByCategory($row->id);
                if(collect($parameterData)->isNotEmpty()){
                    $parameterData = $parameterData->map(function ($item) {
                        unset($item->assigned_parameter);
                        return $item;
                    });
                }
                $row->parameter_types = $parameterData;
            }

//* START :: about_meofile   *//
    public function update_profile(Request $request)
    {
        $validator = Validator::make($request->all(), [
            'userid' => 'required',
            'name' => 'required',
            'mobile' => 'required'
        ]);

if (!$validator->fails()) {
            $id = $request->userid;

$customer =  Customer::find($id);

if (!empty($customer)) {
                if (isset($request->name)) {
                    $customer->name = ($request->name) ? $request->name : '';
                }
                if (isset($request->email)) {
                    $customer->email = ($request->email) ? $request->email : '';
                }
                if (isset($request->mobile)) {
                    $customer->mobile = ($request->mobile) ? $request->mobile : '';
                }

if (isset($request->fcm_id)) {
                    $token_exist = Usertokens::where('fcm_id', $request->fcm_id)->where('customer_id', $customer->id)->get();
                    if (!count($token_exist)) {
                        $user_token = new Usertokens();
                        $user_token->customer_id = $customer->id;
                        $user_token->fcm_id = isset($request->fcm_id) ? $request->fcm_id : '';
                        $user_token->api_token = '';
                        $user_token->save();
                    }
                    $customer->fcm_id = ($request->fcm_id) ? $request->fcm_id : '';
                }
                if (isset($request->address)) {
                    $customer->address = ($request->address) ? $request->address : '';
                }
                if (isset($request->address)) {
                    $customer->address = ($request->address) ? $request->address : '';
                }

if (isset($request->firebase_id)) {
                    $customer->firebase_id = ($request->firebase_id) ? $request->firebase_id : '';
                }
                if (isset($request->notification)) {
                    $customer->notification = $request->notification;
                }
                if (isset($request->about_me)) {
                    $customer->about_me = $request->about_me;
                }
                if (isset($request->facebook_id)) {
                    $customer->facebook_id = $request->facebook_id;
                }
                if (isset($request->twiiter_id)) {
                    $customer->twiiter_id = $request->twiiter_id;
                }
                if (isset($request->instagram_id)) {
                    $customer->instagram_id = $request->instagram_id;
                }
                if (isset($request->pintrest_id)) {
                    $customer->pintrest_id = $request->pintrest_id;
                }
                if (isset($request->latitude)) {
                    $customer->latitude = $request->latitude;
                }
                if (isset($request->longitude)) {
                    $customer->longitude = $request->longitude;
                }

$customer->city = ($request->city != "") ? $request->city : "";

$customer->state = $request->state != "" ? $request->state : "";

$customer->country = $request->country != "" ? $request->country : "";

$destinationPath = public_path('images') . config('global.USER_IMG_PATH');
                if (!is_dir($destinationPath)) {
                    mkdir($destinationPath, 0777, true);
                }
                // image upload

if ($request->hasFile('profile')) {
                    $old_image = $customer->profile;

$profile = $request->file('profile');
                    $imageName = microtime(true) . "." . $profile->getClientOriginalExtension();

if ($profile->move($destinationPath, $imageName)) {
                        $customer->profile = $imageName;
                        if ($old_image != '') {
                            if (file_exists(public_path('images') . config('global.USER_IMG_PATH') . $old_image)) {
                                unlink(public_path('images') . config('global.USER_IMG_PATH') . $old_image);
                            }
                        }
                    }
                }
                $customer->update();

$response['error'] = false;
                $response['data'] = $customer;
            } else {
                $response['error'] = false;
                $response['message'] = "No data found!";
                $response['data'] = [];
            }
        } else {
            $response['error'] = true;
            $response['message'] = "Please fill all data and Submit";
        }

return response()->json($response);
    }
    //* END :: update_profile   *//

//* START :: get_user_by_id   *//
    public function getUserData(Request $request)
    {
        try{
            $payload = JWTAuth::getPayload($this->bearerToken($request));
            $current_user = ($payload['customer_id']);

$customer =  Customer::find($current_user);
            if (!empty($customer)) {

$response['error'] = false;
                $response['data'] = $customer;
            } else {
                $response['error'] = false;
                $response['message'] = "No data found!";
                $response['data'] = [];
            }

return response()->json($response);
        } catch (Exception $e) {
            $response = array(
                'error' => true,
                'message' => 'Something Went Wrong'
            );
            return response()->json($response,500);
        }
    }
    //* END :: get_user_by_id   *//

//* START :: get_property   *//
    public function get_property(Request $request)
    {
        $offset = isset($request->offset) ? $request->offset : 0;
        $limit = isset($request->limit) ? $request->limit : 10;
        // $payload = JWTAuth::getPayload($this->bearerToken($request));
        $current_user = $request->current_user;
        $property = Property::with('customer','user','category:id,category,image,slug_id','assignfacilities.outdoorfacilities','parameters','favourite','interested_users');

$property_type = $request->property_type;  //0 : Buy 1:Rent
        $max_price = isset($request->max_price) ? $request->max_price : Property::max('price');
        $min_price = isset($request->min_price) ? $request->min_price : 0;
        $top_rated = $request->top_rated;

$userid = $request->userid;
        $posted_since = $request->posted_since;
        $category_id = $request->category_id;
        $id = $request->id;
        $country = $request->country;
        $state = $request->state;
        $city = $request->city;
        $totalClicks = 0;

$furnished = $request->furnished;
        $parameter_id = $request->parameter_id;
        if (isset($parameter_id)) {

$property = $property->whereHas('parameters', function ($q) use ($parameter_id) {
                $q->where('parameter_id', $parameter_id);
            });
        }
        if (isset($userid)) {
            $property = $property->where('post_type', 1)->where('added_by', $userid);
            $totalClicks = $property
                ->where('post_type', 1)
                ->where('added_by', $userid)
                ->sum('total_click');
        } else {
            $property = $property->where('status', 1)
                ->where(function ($query) {
                    $query->where('propery_type', 0)
                        ->orWhere('propery_type', 1)->orWhere('propery_type', 2)->orWhere('propery_type', 3);
                });
        }

if (isset($request->max_price) && isset($request->min_price)) {
            $property = $property->whereBetween('price', [$min_price, $max_price]);
        }
        if (isset($property_type)) {
            if ($property_type == 0 ||  $property_type == 2) {
                $property = $property->where('propery_type', $property_type);
            }
            if ($property_type == 1 ||  $property_type == 3) {
                $property = $property->where('propery_type', $property_type);
            }
        }

if (isset($posted_since)) {
            // 0: last_week   1: yesterday
            if ($posted_since == 0) {
                $property = $property->whereBetween(
                    'created_at',
                    [Carbon::now()->subWeek()->startOfWeek(), Carbon::now()->subWeek()->endOfWeek()]
                );
            }
            if ($posted_since == 1) {
                $property =  $property->whereDate('created_at', Carbon::yesterday());
            }
        }

if (isset($category_id)) {
            $property = $property->where('category_id', $category_id);
        }
        if (isset($id)) {
            if (isset($request->get_simiilar)) {
                $property = $property->where('id', '!=', $id);
            } else {

$property = $property->where('id', $id);
            }
        }

if(isset($request->category_slug_id)){
            $category = Category::where('slug_id', $request->category_slug_id)->first();
            if(collect($category)->isNotEmpty()){
                $property = $property->where('category_id', $category->id);
            }
        }

if (isset($request->slug_id)) {
            if (isset($request->get_simiilar)) {
                $property = $property->where('slug_id', '!=', $request->slug_id);
            } else {
                $property = $property->where('slug_id', $request->slug_id);
            }
        }

if (isset($country)) {
            $property = $property->where('country', $country);
        }
        if (isset($state)) {
            $property = $property->where('state', $state);
        }
        if (isset($city) && $city != '') {
            $property = $property->where('city', $city);
        }

if (isset($furnished)) {
            $property = $property->where('furnished', $furnished);
        }
        if (isset($request->promoted)) {
            $adv = Advertisement::select('property_id')->whereNot('type','Slider')->where('is_enable', 1)->get();

$ad_arr = [];
            foreach ($adv as $ad) {

array_push($ad_arr, $ad->property_id);
            }

$property = $property->whereIn('id', $ad_arr)->inRandomOrder();
        } else {

$response['error'] = false;
            $response['message'] = "No data found!";
            $response['data'] = [];
        }
        if (isset($request->users_promoted)) {
            $adv = Advertisement::select('property_id')->where('customer_id', $current_user)->get();

$ad_arr = [];
            foreach ($adv as $ad) {

array_push($ad_arr, $ad->property_id);
            }
            $property = $property->whereIn('id', $ad_arr);
        } else {

$response['error'] = false;
            $response['message'] = "No data found!";
            $response['data'] = [];
        }
        if (isset($request->promoted)) {

if (!($property->Has('advertisement'))) {
                $response['error'] = false;
                $response['message'] = "No data found!";
                $response['data'] = [];
                return ($response);
            }

$property = $property->with('advertisement');
        }

if (isset($request->search) && !empty($request->search)) {
            $search = $request->search;

$property = $property->where(function ($query) use ($search) {
                $query->where('title', 'LIKE', "%$search%")->orwhere('address', 'LIKE', "%$search%")->orwhereHas('category', function ($query1) use ($search) {
                    $query1->where('category', 'LIKE', "%$search%");
                });
            });
        }
        if (empty($request->search)) {
            $property = $property;
        }

if (isset($top_rated) && $top_rated == 1) {

$property = $property->orderBy('total_click', 'DESC');
        }

if (!$request->most_liked &&  !$request->top_rated) {
            $property = $property->orderBy('id', 'DESC');
        }
        if ($request->most_liked) {

$property = $property->withCount('favourite')
                ->orderBy('favourite_count', 'DESC');
        }
        $total = $property->get()->count();

$result = $property->skip($offset)->take($limit)->get();

if (!$result->isEmpty()) {
            $property_details  = get_property_details($result, $current_user);

$response['error'] = false;
            $response['message'] = "Data Fetch Successfully";
            $response['total_clicks'] = (float)$totalClicks;
            $response['total'] = $total;
            $response['data'] = $property_details;
        } else {

$response['error'] = false;
            $response['message'] = "No data found!";
            $response['data'] = [];
        }
        return ($response);
    }
    //* END :: get_property   *//

//* START :: post_property   *//
    public function post_property(Request $request)
    {
        $validator = Validator::make($request->all(), [
            'title' => 'required',
            'description' => 'required',
            'category_id' => 'required',
            'price' => 'required',
            'property_type' => 'required',
            'address' => 'required',
            'title_image' => 'required|file|max:3000|mimes:jpeg,png,jpg',

]);

if (!$validator->fails()) {
            $payload = JWTAuth::getPayload($this->bearerToken($request));
            $current_user = ($payload['customer_id']);

$current_package = UserPurchasedPackage::where('modal_id', $current_user)
                ->with(['package' => function ($q) {
                    $q->select('id', 'property_limit')->where('property_limit', '>', 0)->orWhere('property_limit', null);
                }])
                ->whereHas('package', function ($q) {
                    $q->where('property_limit', '>', 0)->orWhere('property_limit', null);
                })->where('prop_status', 1)
                ->first();

if (!($current_package)) {
                $response['error'] = false;
                $response['message'] = 'Package not found';
                return response()->json($response);
            } else {
                $actualpackage = Package::find($current_package->package_id);

$package = UserPurchasedPackage::where('modal_id', $current_user)->where('package_id', $actualpackage->id)->where('prop_status', 1)->first();

if (!$package->package) {

$response['error'] = false;
                    $response['message'] = 'Package not found for add property';
                    return response()->json($response);
                }
                $prop_count = $package->package->property_limit;
                if (($package->used_limit_for_property) < ($prop_count) || $prop_count == 0) {

$validator = Validator::make($request->all(), [
                        'userid' => 'required',
                        'category_id' => 'required'
                    ]);

$Saveproperty = new Property();

$Saveproperty->category_id = $request->category_id;
                    $title = $request->title;
                    $Saveproperty->slug_id = generateUniqueSlug($title, $title,1);

$Saveproperty->title = $request->title;
                    $Saveproperty->description = $request->description;
                    $Saveproperty->address = $request->address;
                    $Saveproperty->client_address = (isset($request->client_address)) ? $request->client_address : '';

$Saveproperty->propery_type = $request->property_type;
                    $Saveproperty->price = $request->price;

$Saveproperty->country = (isset($request->country)) ? $request->country : '';
                    $Saveproperty->state = (isset($request->state)) ? $request->state : '';
                    $Saveproperty->city = (isset($request->city)) ? $request->city : '';
                    $Saveproperty->latitude = (isset($request->latitude)) ? $request->latitude : '';
                    $Saveproperty->longitude = (isset($request->longitude)) ? $request->longitude : '';
                    $Saveproperty->rentduration = (isset($request->rentduration)) ? $request->rentduration : '';

$Saveproperty->meta_title = (isset($request->meta_title)) ? $request->meta_title : '';
                    $Saveproperty->meta_description = (isset($request->meta_description)) ? $request->meta_description : '';
                    $Saveproperty->meta_keywords = (isset($request->meta_keywords)) ? $request->meta_keywords : '';

$Saveproperty->added_by = $current_user;
                    $Saveproperty->status = (isset($request->status)) ? $request->status : 0;
                    $Saveproperty->video_link = (isset($request->video_link)) ? $request->video_link : "";

$Saveproperty->package_id = $request->package_id;

$Saveproperty->post_type = 1;
                    if ($request->hasFile('title_image')) {
                        $destinationPath = public_path('images') . config('global.PROPERTY_TITLE_IMG_PATH');
                        if (!is_dir($destinationPath)) {
                            mkdir($destinationPath, 0777, true);
                        }

$profile = $request->file('title_image');
                        $imageName = microtime(true) . "." . $profile->getClientOriginalExtension();
                        $profile->move($destinationPath, $imageName);
                        $Saveproperty->title_image = $imageName;
                    } else {
                        $Saveproperty->title_image  = '';
                    }

if ($request->hasFile('meta_image')) {

$destinationPath = public_path('images') . config('global.PROPERTY_SEO_IMG_PATH');
                        if (!is_dir($destinationPath)) {
                            mkdir($destinationPath, 0777, true);
                        }
                        $profile = $request->file('meta_image');
                        $imageName = microtime(true) . "." . $profile->getClientOriginalExtension();
                        $profile->move($destinationPath, $imageName);
                        $Saveproperty->meta_image = $imageName;
                    }

// threeD_image
                    if ($request->hasFile('threeD_image')) {
                        $destinationPath = public_path('images') . config('global.3D_IMG_PATH');
                        if (!is_dir($destinationPath)) {
                            mkdir($destinationPath, 0777, true);
                        }
                        // $Saveproperty->threeD_image_hash = get_hash($request->file('threeD_image'));
                        $profile = $request->file('threeD_image');
                        $imageName = microtime(true) . "." . $profile->getClientOriginalExtension();
                        $profile->move($destinationPath, $imageName);
                        $Saveproperty->threeD_image = $imageName;
                    } else {
                        $Saveproperty->threeD_image  = '';
                    }
                    // print_r(json_encode($request->parameters));
                    $Saveproperty->is_premium = isset($request->is_premium) ? ($request->is_premium == "true" ? 1 : 0) : 0;
                    $Saveproperty->save();

$package->used_limit_for_property
                        =  $package->used_limit_for_property + 1;
                    $package->save();

if ((($package->used_limit_for_property) >= ($prop_count) || $prop_count == 0)) {
                        $package->prop_status = 0;
                        $package->save();
                    }

// $package->used_limit_for_property
                    //     =  $package->used_limit_for_property + 1;
                    // $package->save();

$destinationPathforparam = public_path('images') . config('global.PARAMETER_IMAGE_PATH');
                    if (!is_dir($destinationPath)) {
                        mkdir($destinationPath, 0777, true);
                    }
                    if ($request->facilities) {
                        foreach ($request->facilities as $key => $value) {

$facilities = new AssignedOutdoorFacilities();
                            $facilities->facility_id = $value['facility_id'];
                            $facilities->property_id = $Saveproperty->id;
                            $facilities->distance = $value['distance'];
                            $facilities->save();
                        }
                    }
                    if ($request->parameters) {
                        foreach ($request->parameters as $key => $parameter) {

$AssignParameters = new AssignParameters();

$AssignParameters->modal()->associate($Saveproperty);

$AssignParameters->parameter_id = $parameter['parameter_id'];
                            if ($request->hasFile('parameters.' . $key . '.value')) {

$profile = $request->file('parameters.' . $key . '.value');
                                $imageName = microtime(true) . "." . $profile->getClientOriginalExtension();
                                $profile->move($destinationPathforparam, $imageName);
                                $AssignParameters->value = $imageName;
                            } else if (filter_var($parameter['value'], FILTER_VALIDATE_URL)) {

$ch = curl_init($parameter['value']);
                                curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
                                $fileContents = curl_exec($ch);
                                curl_close($ch);

$filename
                                    = microtime(true) . basename($parameter['value']);

file_put_contents($destinationPathforparam . '/' . $filename, $fileContents);
                                $AssignParameters->value = $filename;
                            } else {
                                $AssignParameters->value = $parameter['value'];
                            }

$AssignParameters->save();
                        }
                    }

/// START :: UPLOAD GALLERY IMAGE

$FolderPath = public_path('images') . config('global.PROPERTY_GALLERY_IMG_PATH');
                    if (!is_dir($FolderPath)) {
                        mkdir($FolderPath, 0777, true);
                    }

$destinationPath = public_path('images') . config('global.PROPERTY_GALLERY_IMG_PATH') . "/" . $Saveproperty->id;
                    if (!is_dir($destinationPath)) {
                        mkdir($destinationPath, 0777, true);
                    }
                    if ($request->hasfile('gallery_images')) {

foreach ($request->file('gallery_images') as $file) {

$name = time() . rand(1, 100) . '.' . $file->extension();
                            $file->move($destinationPath, $name);

$gallary_image = new PropertyImages();
                            $gallary_image->image = $name;
                            $gallary_image->propertys_id = $Saveproperty->id;

$gallary_image->save();
                        }
                    }

/// END :: UPLOAD GALLERY IMAGE

$result = Property::with('customer')->with('category:id,category,image')->with('assignfacilities.outdoorfacilities')->with('favourite')->with('parameters')->with('interested_users')->where('id', $Saveproperty->id)->get();
                    $property_details = get_property_details($result);

$response['error'] = false;
                    $response['message'] = 'Property Post Succssfully';
                    $response['data'] = $property_details;
                } else {
                    $response['error'] = false;
                    $response['message'] = 'Package Limit is over';
                }
            }
        } else {
            $response['error'] = true;
            $response['message'] = $validator->errors()->first();
        }
        return response()->json($response);
    }

//* END :: post_property   *//
    //* START :: update_post_property   *//
    /// This api use for update and delete  property
    public function update_post_property(Request $request)
    {
        $validator = Validator::make($request->all(), [
            // 'id' => 'required',
            'action_type' => 'required'
        ]);
        $payload = JWTAuth::getPayload($this->bearerToken($request));
        $current_user = ($payload['customer_id']);
        if (!$validator->fails()) {
            $id = $request->id;
            $action_type = $request->action_type;
            if ($request->slug_id) {

$property = Property::where('added_by', $current_user)->where('slug_id', $request->slug_id)->first();
                if (!$property) {
                    $property = Property::where('added_by', $current_user)->find($id);
                }
            } else {
                $property = Property::where('added_by', $current_user)->find($id);
            }

// $property = Property::where('added_by', $current_user)->find($id);
            if (($property)) {
                // 0: Update 1: Delete
                if ($action_type == 0) {

$destinationPath = public_path('images') . config('global.PROPERTY_TITLE_IMG_PATH');
                    if (!is_dir($destinationPath)) {
                        mkdir($destinationPath, 0777, true);
                    }

if (isset($request->category_id)) {
                        $property->category_id = $request->category_id;
                    }

if (isset($request->title)) {
                        $property->title = $request->title;
                    }

if (isset($request->description)) {
                        $property->description = $request->description;
                    }

if (isset($request->address)) {
                        $property->address = $request->address;
                    }

if (isset($request->client_address)) {
                        $property->client_address = $request->client_address;
                    }

if (isset($request->property_type)) {
                        $property->propery_type = $request->property_type;
                    }

if (isset($request->price)) {
                        $property->price = $request->price;
                    }
                    if (isset($request->country)) {
                        $property->country = $request->country;
                    }
                    if (isset($request->state)) {
                        $property->state = $request->state;
                    }
                    if (isset($request->city)) {
                        $property->city = $request->city;
                    }
                    if (isset($request->status)) {
                        $property->status = $request->status;
                    }
                    if (isset($request->latitude)) {
                        $property->latitude = $request->latitude;
                    }
                    if (isset($request->longitude)) {
                        $property->longitude = $request->longitude;
                    }
                    if (isset($request->rentduration)) {
                        $property->rentduration = $request->rentduration;
                    }
                    $property->meta_title = $request->meta_title;
                    $property->meta_description = $request->meta_description;
                    $property->meta_keywords = $request->meta_keywords;
                    // if (isset($request->meta_title)) {
                    //     $property->meta_title = $request->meta_title;
                    // }
                    // if (isset($request->meta_description)) {
                    //     $property->meta_description = $request->meta_description;
                    // }
                    // if (isset($request->meta_keywords)) {
                    //     $property->meta_keywords = $request->meta_keywords;
                    // }

if (isset($request->is_premium)) {
                        $property->is_premium = $request->is_premium == "true" ? 1 : 0;
                    }

if ($request->hasFile('title_image')) {
                        $profile = $request->file('title_image');
                        $imageName = microtime(true) . "." . $profile->getClientOriginalExtension();
                        $profile->move($destinationPath, $imageName);

if ($request->hasFile('meta_image')) {
                        if (!empty($property->meta_image)) {

$url = $property->meta_image;

$relativePath = parse_url($url, PHP_URL_PATH);

if (file_exists(public_path()  . $relativePath)) {
                                unlink(public_path()  . $relativePath);
                            }
                        }

$destinationPath = public_path('images') . config('global.PROPERTY_SEO_IMG_PATH');
                        if (!is_dir($destinationPath)) {
                            mkdir($destinationPath, 0777, true);
                        }

$profile = $request->file('meta_image');
                        $imageName = microtime(true) . "." . $profile->getClientOriginalExtension();
                        $profile->move($destinationPath, $imageName);

$property->meta_image = $imageName;
                    }else{
                        if (!empty($property->meta_image)) {

$url = $property->meta_image;

$relativePath = parse_url($url, PHP_URL_PATH);

if (file_exists(public_path()  . $relativePath)) {
                                unlink(public_path()  . $relativePath);
                            }
                        }
                        $property->meta_image = null;
                    }

if ($request->hasFile('threeD_image')) {
                        $destinationPath1 = public_path('images') . config('global.3D_IMG_PATH');
                        if (!is_dir($destinationPath1)) {
                            mkdir($destinationPath1, 0777, true);
                        }
                        $profile = $request->file('threeD_image');
                        $imageName = microtime(true) . "." . $profile->getClientOriginalExtension();
                        $profile->move($destinationPath1, $imageName);

if ($property->title_image != '') {
                            if (file_exists(public_path('images') . config('global.3D_IMG_PATH') .  $property->title_image)) {
                                unlink(public_path('images') . config('global.3D_IMG_PATH') . $property->title_image);
                            }
                        }
                        $property->threeD_image = $imageName;
                    }
                    if ($request->parameters) {
                        $destinationPathforparam = public_path('images') . config('global.PARAMETER_IMAGE_PATH');
                        if (!is_dir($destinationPath)) {
                            mkdir($destinationPath, 0777, true);
                        }

foreach ($request->parameters as $key => $parameter) {
                            $AssignParameters = AssignParameters::where('modal_id', $property->id)->where('parameter_id', $parameter['parameter_id'])->pluck('id');
                            if (count($AssignParameters)) {
                                $update_data = AssignParameters::find($AssignParameters[0]);
                                if ($request->hasFile('parameters.' . $key . '.value')) {
                                    $profile = $request->file('parameters.' . $key . '.value');
                                    $imageName = microtime(true) . "." . $profile->getClientOriginalExtension();
                                    $profile->move($destinationPathforparam, $imageName);
                                    $update_data->value = $imageName;
                                } else if (filter_var($parameter['value'], FILTER_VALIDATE_URL)) {
                                    $ch = curl_init($parameter['value']);
                                    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
                                    $fileContents = curl_exec($ch);
                                    curl_close($ch);
                                    $filename = microtime(true) . basename($parameter['value']);
                                    file_put_contents($destinationPathforparam . '/' . $filename, $fileContents);
                                    $update_data->value = $filename;
                                } else {
                                    $update_data->value = $parameter['value'];
                                }
                                $update_data->save();
                            } else {

$AssignParameters = new AssignParameters();

$AssignParameters->modal()->associate($property);

$AssignParameters->parameter_id = $parameter['parameter_id'];
                                if ($request->hasFile('parameters.' . $key . '.value')) {

$profile = $request->file('parameters.' . $key . '.value');
                                    $imageName = microtime(true) . "." . $profile->getClientOriginalExtension();
                                    $profile->move($destinationPathforparam, $imageName);
                                    $AssignParameters->value = $imageName;
                                } else if (filter_var($parameter['value'], FILTER_VALIDATE_URL)) {

$ch = curl_init($parameter['value']);
                                    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
                                    $fileContents = curl_exec($ch);
                                    curl_close($ch);

$filename
                                        = microtime(true) . basename($parameter['value']);

file_put_contents($destinationPathforparam . '/' . $filename, $fileContents);
                                    $AssignParameters->value = $filename;
                                } else {
                                    $AssignParameters->value = $parameter['value'];
                                }

$AssignParameters->save();
                            }
                        }

// $AssignParameters->save();
                    }

if ($request->slug_id) {

$prop = Property::where('slug_id', $request->slug_id)->first();
                        $prop_id = $prop->id;
                        AssignedOutdoorFacilities::where('property_id', $prop->id)->delete();
                    } else {
                        $prop_id = $request->id;
                        AssignedOutdoorFacilities::where('property_id', $request->id)->delete();
                    }
                    // AssignedOutdoorFacilities::where('property_id', $request->id)->delete();
                    if ($request->facilities) {
                        foreach ($request->facilities as $key => $value) {

$facilities = new AssignedOutdoorFacilities();
                            $facilities->facility_id = $value['facility_id'];
                            $facilities->property_id = $prop_id;
                            $facilities->distance = $value['distance'];
                            $facilities->save();
                        }
                    }

$property->update();
                    $update_property = Property::with('customer')->with('category:id,category,image')->with('assignfacilities.outdoorfacilities')->with('favourite')->with('parameters')->with('interested_users')->where('id', $request->id)->get();

/// START :: UPLOAD GALLERY IMAGE

$destinationPath = public_path('images') . config('global.PROPERTY_GALLERY_IMG_PATH') . "/" . $property->id;
                    if (!is_dir($destinationPath)) {
                        mkdir($destinationPath, 0777, true);
                    }
                    if ($request->remove_gallery_images) {

foreach ($request->remove_gallery_images as $key => $value) {

$gallary_images = PropertyImages::find($value);

if (file_exists(public_path('images') . config('global.PROPERTY_GALLERY_IMG_PATH') . $gallary_images->propertys_id . '/' . $gallary_images->image)) {

unlink(public_path('images') . config('global.PROPERTY_GALLERY_IMG_PATH') . $gallary_images->propertys_id . '/' . $gallary_images->image);
                            }

$gallary_images->delete();
                        }
                    }
                    if ($request->hasfile('gallery_images')) {

foreach ($request->file('gallery_images') as $file) {
                            $name = time() . rand(1, 100) . '.' . $file->extension();
                            $file->move($destinationPath, $name);

PropertyImages::create([
                                'image' => $name,
                                'propertys_id' => $property->id,

]);
                        }
                    }

/// END :: UPLOAD GALLERY IMAGE
                    $payload = JWTAuth::getPayload($this->bearerToken($request));
                    $current_user = ($payload['customer_id']);
                    $property_details = get_property_details($update_property, $current_user);
                    $response['error'] = false;
                    $response['message'] = 'Property Update Succssfully';
                    $response['data'] = $property_details;
                } elseif ($action_type == 1) {
                    if ($property->delete()) {

$chat = Chats::where('property_id', $property->id);
                        if ($chat) {
                            $chat->delete();
                        }

$slider = Slider::where('propertys_id', $property->id);
                        if ($slider) {
                            $slider->delete();
                        }

$notifications = Notifications::where('propertys_id', $property->id);
                        if ($notifications) {
                            $notifications->delete();
                        }

if ($property->title_image != '') {
                            if (file_exists(public_path('images') . config('global.PROPERTY_TITLE_IMG_PATH') . $property->title_image)) {
                                unlink(public_path('images') . config('global.PROPERTY_TITLE_IMG_PATH') . $property->title_image);
                            }
                        }
                        foreach ($property->gallery as $row) {
                            if (PropertyImages::where('id', $row->id)->delete()) {
                                if ($row->image_url != '') {
                                    if (file_exists(public_path('images') . config('global.PROPERTY_GALLERY_IMG_PATH') . $property->id . "/" . $row->image)) {
                                        unlink(public_path('images') . config('global.PROPERTY_GALLERY_IMG_PATH') . $property->id . "/" . $row->image);
                                    }
                                }
                            }
                        }
                        rmdir(public_path('images') . config('global.PROPERTY_GALLERY_IMG_PATH') . $property->id);

Notifications::where('propertys_id', $id)->delete();

$slider = Slider::where('propertys_id', $id)->get();

foreach ($slider as $row) {
                            $image = $row->image;

if (Slider::where('id', $row->id)->delete()) {
                                if (file_exists(public_path('images') . config('global.SLIDER_IMG_PATH') . $image)) {
                                    unlink(public_path('images') . config('global.SLIDER_IMG_PATH') . $image);
                                }
                            }
                        }

$response['error'] = false;
                        $response['message'] =  'Delete Successfully';
                    } else {
                        $response['error'] = true;
                        $response['message'] = 'something wrong';
                    }
                }
            } else {
                $response['error'] = true;
                $response['message'] = 'No Data Found';
            }
        } else {
            $response['error'] = true;
            $response['message'] = "Please fill all data and Submit";
        }

return response()->json($response);
    }
    //* END :: update_post_property   *//

//* START :: remove_post_images   *//
    public function remove_post_images(Request $request)
    {
        $validator = Validator::make($request->all(), [
            'id' => 'required'
        ]);

if (!$validator->fails()) {
            $id = $request->id;
            $getImage = PropertyImages::where('id', $id)->first();
            $image = $getImage->image;
            $propertys_id =  $getImage->propertys_id;

if (PropertyImages::where('id', $id)->delete()) {
                if (file_exists(public_path('images') . config('global.PROPERTY_GALLERY_IMG_PATH') . $propertys_id . "/" . $image)) {
                    unlink(public_path('images') . config('global.PROPERTY_GALLERY_IMG_PATH') . $propertys_id . "/" . $image);
                }
                $response['error'] = false;
            } else {
                $response['error'] = true;
            }

$countImage = PropertyImages::where('propertys_id', $propertys_id)->get();
            if ($countImage->count() == 0) {
                rmdir(public_path('images') . config('global.PROPERTY_GALLERY_IMG_PATH') . $propertys_id);
            }

$response['error'] = false;
            $response['message'] = 'Property Post Succssfully';
        } else {
            $response['error'] = true;
            $response['message'] = "Please fill all data and Submit";
        }

return response()->json($response);
    }
    //* END :: remove_post_images   *//

//* START :: set_property_inquiry   *//

//* START :: get_notification_list   *//
    public function get_notification_list(Request $request)
    {
        $validator = Validator::make($request->all(), [
            'userid' => 'required',
        ]);

if (!$validator->fails()) {
            $offset = isset($request->offset) ? $request->offset : 0;
            $limit = isset($request->limit) ? $request->limit : 10;
            $id = $request->userid;

$result =  Notifications::where("customers_id", $id)->orwhere('send_type', '1')->orderBy('id', 'DESC');
            $total = $result->get()->count();
            $Notifications = $result->skip($offset)->take($limit)->get();

if (!$Notifications->isEmpty()) {
                for ($i = 0; $i < count($Notifications); $i++) {
                    $property = Property::find($Notifications[$i]->propertys_id);

if ($property) {
                        $prop_img = $property->title_image;
                    } else {
                        $prop_img = "";
                    }
                    $Notifications[$i]->created = $Notifications[$i]->created_at->diffForHumans();
                    $Notifications[$i]->image  = ($Notifications[$i]->image != '') ? url('') . config('global.IMG_PATH') . config('global.NOTIFICATION_IMG_PATH') . $Notifications[$i]->image : $prop_img;
                }
                $response['error'] = false;
                $response['total'] = $total;
                $response['data'] = $Notifications;
            } else {
                $response['error'] = false;
                $response['message'] = "No data found!";
                $response['data'] = [];
            }
        } else {
            $response['error'] = true;
            $response['message'] = "Please fill all data and Submit";
        }

return response()->json($response);
    }
    //* END :: get_notification_list   *//

//* START :: set_property_total_click   *//
    public function set_property_total_click(Request $request)
    {
        $validator = Validator::make($request->all(), [
            'property_id' => 'required_without_all:slug_id,project_id',
            'project_id' => 'required_without_all:slug_id,property_id',
            'slug_id' => 'required_without_all:property_id,project_id',
        ]);

if (!$validator->fails()) {

if (isset($request->project_id)) {

$project = Projects::find($request->project_id);
                $project->increment('total_click');
            }
            if ($request->property_id) {

$property_id = $request->property_id;
                $Property = Property::find($property_id);
                $Property->increment('total_click');
            }

if (isset($request->slug_id)) {
                $project = Projects::where('slug_id', $request->slug_id);
                $project->increment('total_click');
            } else {
                $Property = Property::where('slug_id', $request->slug_id);
                $Property->increment('total_click');
            }

$response['error'] = false;
            $response['message'] = 'Update Succssfully';
        } else {
            $response['error'] = true;
            $response['message'] = $validator->errors()->first();
        }

return response()->json($response);
    }
    //* END :: set_property_total_click   *//

//* START :: delete_user   *//
    public function delete_user(Request $request)
    {
        $validator = Validator::make($request->all(), [
            'userid' => 'required',

]);

if (!$validator->fails()) {
            $userid = $request->userid;

Customer::find($userid)->delete();
            Property::where('added_by', $userid)->delete();

Chats::where('sender_id', $userid)->orWhere('receiver_id', $userid)->delete();
            Notifications::where('customers_id', $userid)->delete();
            Advertisement::where('customer_id', $userid)->delete();

$response['error'] = false;
            $response['message'] = 'Delete Successfully';
        } else {
            $response['error'] = true;
            $response['message'] = "Please fill all data and Submit";
        }

return response()->json($response);
    }
    //* END :: delete_user   *//
    public function bearerToken($request)
    {
        $header = $request->header('Authorization', '');
        if (Str::startsWith($header, 'Bearer ')) {
            return Str::substr($header, 7);
        }
    }
    //*START :: add favoutite *//
    public function add_favourite(Request $request)
    {
        $validator = Validator::make($request->all(), [
            'type' => 'required',
            'property_id' => 'required',

]);

if (!$validator->fails()) {
            //add favourite
            $payload = JWTAuth::getPayload($this->bearerToken($request));
            $current_user = ($payload['customer_id']);
            if ($request->type == 1) {

$fav_prop = Favourite::where('user_id', $current_user)->where('property_id', $request->property_id)->get();

if (count($fav_prop) > 0) {
                    $response['error'] = false;
                    $response['message'] = "Property already add to favourite";
                    return response()->json($response);
                }
                $favourite = new Favourite();
                $favourite->user_id = $current_user;
                $favourite->property_id = $request->property_id;
                $favourite->save();
                $response['error'] = false;
                $response['message'] = "Property add to Favourite add successfully";
            }
            //delete favourite
            if ($request->type == 0) {
                Favourite::where('property_id', $request->property_id)->where('user_id', $current_user)->delete();

$response['error'] = false;
                $response['message'] = "Property remove from Favourite  successfully";
            }
        } else {
            $response['error'] = true;
            $response['message'] = $validator->errors()->first();
        }

return response()->json($response);
    }

public function get_articles(Request $request)
    {
        $offset = isset($request->offset) ? $request->offset : 0;
        $limit = isset($request->limit) ? $request->limit : 10;
        $article = Article::with('category:id,category,slug_id')->select('id', 'slug_id', 'image', 'title', 'description', 'meta_title', 'meta_description', 'meta_keywords', 'category_id', 'created_at');

if (isset($request->category_id)) {
            $category_id = $request->category_id;
            if ($category_id == 0) {
                $article = $article->where('category_id', '');
            } else {

$article = $article->where('category_id', $category_id);
            }
        }

if (isset($request->slug_id)) {
            $category = Category::where('slug_id', $request->slug_id)->first();
            if ($category) {

$article = $article->where('category_id', $category->id);
            } else {
                if (isset($request->get_simiilar)) {
                    $article = $article->where('slug_id', '!=', $request->slug_id);
                } else {
                    $article = $article->where('slug_id', $request->slug_id);
                }
            }
        }

if (isset($request->id)) {
            if (isset($request->get_simiilar)) {
                $article = $article->where('id', '!=', $request->id);
            } else {
                $article = $article->where('id', $request->id);
            }
        }

$total = $article->get()->count();
        $result = $article->orderBy('id', 'ASC')->skip($offset)->take($limit)->get();
        if (!$result->isEmpty()) {
            $result = $result->toArray();

foreach ($result as &$item) {
                $item['meta_image'] = $item['image'];
                $item['created_at'] = Carbon::parse($item['created_at'])->diffForHumans();
            }

$response['data'] = $result;

$response['error'] = false;
            $response['message'] = "Data Fetch Successfully";
            $response['total'] = $total;
            $response['data'] = $result;
        } else {
            $response['error'] = false;
            $response['message'] = "No data found!";
            $response['data'] = [];
        }
        return response()->json($response);
    }

public function store_advertisement(Request $request)
    {

$validator = Validator::make($request->all(), [
            'type' => 'required',
            'property_id' => 'required',

]);
        if (!$validator->fails()) {
            $payload = JWTAuth::getPayload($this->bearerToken($request));
            $current_user = ($payload['customer_id']);

$current_package = UserPurchasedPackage::where('modal_id', $current_user)
                ->with(['package' => function ($q) {
                    $q->select('id', 'advertisement_limit')->where('advertisement_limit', '>', 0)->orWhere('advertisement_limit', null);
                }])
                ->whereHas('package', function ($q) {
                    $q->where('advertisement_limit', '>', 0)->orWhere('advertisement_limit', null);
                })->where('adv_status', 1)
                ->first();

$package = UserPurchasedPackage::where('modal_id', $current_user)->where('package_id', $actualpackage->id)->where('adv_status', 1)->first();
                $advertisement_count = 0;

if (!$package->package) {

$response['error'] = false;
                    $response['message'] = 'Package not found for advertisement';
                    return response()->json($response);
                }
                $advertisement_count = $package->package->advertisement_limit;
                if (($package->used_limit_for_advertisement) < ($advertisement_count) || $advertisement_count == 0) {

$adv = new Advertisement();

$adv->start_date = Carbon::now();
                    if ($package) {
                        if (isset($request->end_date)) {
                            $adv->end_date = $request->end_date;
                        } else {
                            $adv->end_date = Carbon::now()->addDays($package->duration);
                        }
                        $adv->package_id = $package->id;
                        $adv->type = $request->type;
                        $adv->property_id = $request->property_id;
                        $adv->customer_id = $current_user;
                        $adv->is_enable = false;
                        $adv->status = 1;

$destinationPath = public_path('images') . config('global.ADVERTISEMENT_IMAGE_PATH');
                        if (!is_dir($destinationPath)) {
                            mkdir($destinationPath, 0777, true);
                        }

if ($request->type == 'Slider') {
                            $destinationPath_slider = public_path('images') . config('global.SLIDER_IMG_PATH');

if (!is_dir($destinationPath_slider)) {
                                mkdir($destinationPath_slider, 0777, true);
                            }
                            $slider = new Slider();

if ($request->hasFile('image')) {

$file = $request->file('image');

$name = time() . '.' . $file->extension();

$file->move($destinationPath_slider, $name);
                                $sliderimageName = $name;
                                $slider->image = $sliderimageName;
                            } else {
                                $slider->image = '';
                            }
                            $proeprty = Property::find($request->property_id);
                            $slider->category_id = isset($request->category_id) ? $request->category_id : $proeprty->category_id;
                            $slider->propertys_id = $request->property_id;
                            $slider->save();
                        }
                        $result = Property::with('customer')->with('category:id,category,image')->with('favourite')->with('parameters')->with('interested_users')->where('id', $request->property_id)->get();
                        $property_details = get_property_details($result);

$adv->image = "";
                        $adv->save();

$package->used_limit_for_advertisement
                            =  $package->used_limit_for_advertisement + 1;
                        $package->save();

if ((($package->used_limit_for_advertisement) >= ($advertisement_count) || $advertisement_count == 0)) {
                            $package->adv_status = 0;
                            $package->save();
                        }

$response['error'] = false;
                        $response['message'] = "Advertisement add successfully";
                        $response['data'] = $property_details;
                    } else {
                        $response['error'] = false;
                        $response['message'] = "Package not found";
                        return response()->json($response);
                    }
                } else {
                    $response['error'] = false;
                    $response['message'] = "Package Limit is over";
                    return response()->json($response);
                }
            }
        } else {
            $response['error'] = true;
            $response['message'] = $validator->errors()->first();
        }
        return response()->json($response);
    }

public function get_advertisement(Request $request)
    {

$offset = isset($request->offset) ? $request->offset : 0;
        $limit = isset($request->limit) ? $request->limit : 10;

$article = Article::select('id', 'image', 'title', 'description');
        $date = date('Y-m-d');

$adv = Advertisement::select('id', 'image', 'category_id', 'property_id', 'type', 'customer_id', 'is_enable', 'status')->with('customer:id,name')->where('end_date', '>', $date);
        if (isset($request->customer_id)) {
            $adv->where('customer_id', $request->customer_id);
        }
        $total = $adv->get()->count();
        $result = $adv->orderBy('id', 'ASC')->skip($offset)->take($limit)->get();
        if (!$result->isEmpty()) {
            foreach ($adv as $row) {
                if (filter_var($row->image, FILTER_VALIDATE_URL) === false) {
                    $row->image = ($row->image != '') ? url('') . config('global.IMG_PATH') . config('global.ADVERTISEMENT_IMAGE_PATH') . $row->image : '';
                } else {
                    $row->image = $row->image;
                }
            }
            $response['error'] = false;
            $response['message'] = "Data Fetch Successfully";
            $response['data'] = $result;
        } else {
            $response['error'] = false;
            $response['message'] = "No data found!";
            $response['data'] = [];
        }

return response()->json($response);
    }
    public function get_package(Request $request)
    {
        if ($request->platform == "ios") {
            $packages = Package::where('status', 1)
                ->where('ios_product_id', '!=', '')
                ->orderBy('price', 'ASC')
                ->get();
        } else {
            $packages = Package::where('status', 1)
                ->orderBy('price', 'ASC')
                ->get();
        }

$packages->transform(function ($item) use ($request) {
            if ($request->filled('current_user')) {

$user_package = UserPurchasedPackage::where('modal_id', $request->current_user);

if ($request->type == 'property') {
                    $user_package->where('prop_status', 1);
                } else if ($request->type == 'advertisement') {
                    $user_package->where('adv_status', 1);
                }

$user_package = $user_package->where('package_id', $item->id)->first();

if (!empty($user_package)) {
                    $startDate = new DateTime(Carbon::now());
                    $endDate = new DateTime($user_package->end_date);

// Calculate the difference between two dates
                    $interval = $startDate->diff($endDate);

// Get the difference in days
                    $diffInDays = $interval->days;

$item['is_active'] = 1;
                    $item['type'] = $item->type === "premium_user" ? "premium_user" : "product_listing";

if (!($item->type === "premium_user")) {
                        $item['used_limit_for_property'] = $user_package->used_limit_for_property;
                        $item['used_limit_for_advertisement'] = $user_package->used_limit_for_advertisement;
                        $item['property_status'] = $user_package->prop_status;
                        $item['advertisement_status'] = $user_package->adv_status;
                    }

$item['start_date'] = $user_package->start_date;
                    $item['end_date'] = $user_package->end_date;
                    $item['remaining_days'] = $diffInDays;
                } else {
                    $item['is_active'] = 0;
                }
            }

if (!($item->type === "premium_user")) {
                $item['advertisement_limit'] = $item->advertisement_limit == '' ? "unlimited" : ($item->advertisement_limit == 0 ? "not_available" : $item->advertisement_limit);
                $item['property_limit'] = $item->property_limit == '' ? "unlimited" : ($item->property_limit == 0 ? "not_available" : $item->property_limit);
            } else {
                unset($item['property_limit']);
                unset($item['advertisement_limit']);
            }

return $item;
        });

// Sort the packages based on is_active flag (active packages first)
        $packages = $packages->sortByDesc('is_active');

$response = [
            'error' => false,
            'message' => 'Data Fetch Successfully',
            'data' => $packages->values()->all(), // Reset the keys after sorting
        ];

return response()->json($response);
    }

//     public function get_package(Request $request)
    //     {

//  if($request->platform=="ios"){
    //     //  dd("in");
    //               $packages = Package::where('status', 1)->where('ios_product_id','!=','')
    //             ->orderBy('id', 'ASC')

//             ->get();

//             }else{
    //                  $packages = Package::where('status', 1)
    //             ->orderBy('id', 'ASC')

//             ->get();
    //             }

//         // $packages = Package::where('status', 1)
    //         //     ->orderBy('id', 'ASC')

//         //     ->get();

//         $packages->map(function ($item) use ($request) {

//             // If the user has purchased a package, set "is_active" for that specific package
    //             if ($request->filled('current_user')) {
    //                 $user_package = UserPurchasedPackage::where('modal_id', $request->current_user)->first();
    //                 $is_active = $user_package ? 1 : 0;

//                 if ($is_active && $item->id == $user_package->package_id) {
    //                     $item['is_active'] = 1;
    //                 } else {
    //                     $item['is_active'] = 0;
    //                 }
    //             }
    //             $item['advertisement_limit'] = $item->advertisement_limit == '' ? "unlimited" : ($item->advertisement_limit == 0 ? "not_available" : $item->advertisement_limit);
    //             $item['property_limit'] = $item->property_limit == '' ? "unlimited" : ($item->property_limit == 0 ? "not_available" : $item->property_limit);

//             return $item;
    //         });

// // dd($packages->toArray());

//         $response = [
    //             'error' => false,
    //             'message' => 'Data Fetch Successfully',
    //             'data' => $packages,
    //         ];

//         return response()->json($response);
    //     }
    public function user_purchase_package(Request $request)
    {

$start_date =  Carbon::now();
        $validator = Validator::make($request->all(), [

'package_id' => 'required',

]);

if (!$validator->fails()) {
            $payload = JWTAuth::getPayload($this->bearerToken($request));
            $current_user = ($payload['customer_id']);
            if (isset($request->flag)) {
                $user_exists = UserPurchasedPackage::where('modal_id', $current_user)->get();
                if ($user_exists) {
                    UserPurchasedPackage::where('modal_id', $current_user)->delete();
                }
            }

$package = Package::find($request->package_id);
            $user = Customer::find($current_user);
            $data_exists = UserPurchasedPackage::where('modal_id', $current_user)->get();
            if (count($data_exists) == 0 && $package) {
                $user_package = new UserPurchasedPackage();
                $user_package->modal()->associate($user);
                $user_package->package_id = $request->package_id;
                $user_package->start_date = $start_date;
                $user_package->end_date = $package->duratio != 0 ? Carbon::now()->addDays($package->duration) : NULL;
                $user_package->save();

$user->subscription = 1;
                $user->update();

$response['error'] = false;
                $response['message'] = "purchased package  add successfully";
            } else {
                $response['error'] = false;
                $response['message'] = "data already exists or package not found or add flag for add new package";
            }
        } else {
            $response['error'] = true;
            $response['message'] = "Please fill all data and Submit";
        }
        return response()->json($response);
    }
    public function get_favourite_property(Request $request)
    {

$offset = isset($request->offset) ? $request->offset : 0;
        $limit = isset($request->limit) ? $request->limit : 25;

$payload = JWTAuth::getPayload($this->bearerToken($request));
        $current_user = ($payload['customer_id']);

$favourite = Favourite::where('user_id', $current_user)->select('property_id')->get();
        $arr = array();
        foreach ($favourite as $p) {
            $arr[] =  $p->property_id;
        }

$property_details = Property::whereIn('id', $arr)->with('category:id,category,image')->with('assignfacilities.outdoorfacilities')->with('parameters');
        $result = $property_details->orderBy('id', 'ASC')->skip($offset)->take($limit)->get();

$total = $property_details->count();

if (!$result->isEmpty()) {

$response['error'] = false;
            $response['message'] = "Data Fetch Successfully";
            $response['data'] =  get_property_details($result, $current_user);
            $response['total'] = $total;
        } else {
            $response['error'] = false;
            $response['message'] = "No data found!";
            $response['data'] = [];
        }
        return response()->json($response);
    }
    public function delete_advertisement(Request $request)
    {
        $validator = Validator::make($request->all(), [
            'id' => 'required',

]);

if (!$validator->fails()) {
            $adv = Advertisement::find($request->id);
            if (!$adv) {
                $response['error'] = false;
                $response['message'] = "Data not found";
            } else {

$adv->delete();
                $response['error'] = false;
                $response['message'] = "Advertisement Deleted successfully";
            }
        } else {
            $response['error'] = true;
            $response['message'] = $validator->errors()->first();
        }
        return response()->json($response);
    }
    public function interested_users(Request $request)
    {
        $validator = Validator::make($request->all(), [
            'property_id' => 'required',
            'type' => 'required'

]);
        if (!$validator->fails()) {

$payload = JWTAuth::getPayload($this->bearerToken($request));
            $current_user = ($payload['customer_id']);

$interested_user = InterestedUser::where('customer_id', $current_user)->where('property_id', $request->property_id);

if ($request->type == 1) {

if (count($interested_user->get()) > 0) {
                    $response['error'] = false;
                    $response['message'] = "already added to interested users ";
                } else {
                    $interested_user = new InterestedUser();
                    $interested_user->property_id = $request->property_id;
                    $interested_user->customer_id = $current_user;
                    $interested_user->save();
                    $response['error'] = false;
                    $response['message'] = "Interested Users added successfully";
                }
            }
            if ($request->type == 0) {

if (count($interested_user->get()) == 0) {
                    $response['error'] = false;
                    $response['message'] = "No data found to delete";
                } else {
                    $interested_user->delete();

$response['error'] = false;
                    $response['message'] = "Interested Users removed  successfully";
                }
            }
        } else {
            $response['error'] = true;
            $response['message'] = $validator->errors()->first();
        }
        return response()->json($response);
    }

public function user_interested_property(Request $request)
    {

$offset = isset($request->offset) ? $request->offset : 0;
        $limit = isset($request->limit) ? $request->limit : 25;

$payload = JWTAuth::getPayload($this->bearerToken($request));
        $current_user = ($payload['customer_id']);

$favourite = InterestedUser::where('customer_id', $current_user)->select('property_id')->get();
        $arr = array();
        foreach ($favourite as $p) {
            $arr[] =  $p->property_id;
        }
        $property_details = Property::whereIn('id', $arr)->with('category:id,category')->with('parameters');
        $result = $property_details->orderBy('id', 'ASC')->skip($offset)->take($limit)->get();

$total = $result->count();

if (!$result->isEmpty()) {
            foreach ($property_details as $row) {
                if (filter_var($row->image, FILTER_VALIDATE_URL) === false) {
                    $row->image = ($row->image != '') ? url('') . config('global.IMG_PATH') . config('global.PROPERTY_TITLE_IMG_PATH') . $row->image : '';
                } else {
                    $row->image = $row->image;
                }
            }
            $response['error'] = false;
            $response['message'] = "Data Fetch Successfully";
            $response['data'] = $result;
            $response['total'] = $total;
        } else {
            $response['error'] = false;
            $response['message'] = "No data found!";
            $response['data'] = [];
        }
        return response()->json($response);
    }
    // public function get_limits(Request $request)
    // {
    //     $validator = Validator::make($request->all(), [
    //         'id' => 'required',

//     ]);
    //     if (!$validator->fails()) {
    //         $payload = JWTAuth::getPayload($this->bearerToken($request));
    //         $current_user = ($payload['customer_id']);
    //         $package = UserPurchasedPackage::where('modal_id', $current_user)->where('package_id', $request->id)->with(['package' => function ($q) {
    //             $q->select('id', 'property_limit', 'advertisement_limit');
    //         }])->first();
    //         if (!$package) {
    //             $response['error'] = true;
    //             $response['message'] = "package not found";
    //             return response()->json($response);
    //         }
    //         $arr = 0;
    //         $adv_count = 0;
    //         $prop_count = 0;
    //         // foreach ($package as $p) {

//         ($adv_count = $package->package->advertisement_limit == 0 ? "Unlimited" : $package->package->advertisement_limit);
    //         ($prop_count = $package->package->property_limit == 0 ? "Unlimited" : $package->package->property_limit);

//         ($arr = $package->id);
    //         // }

//         $advertisement_limit = Advertisement::where('customer_id', $current_user)->where('package_id', $request->id)->get();
    //         // DB::enableQueryLog();

//         $propeerty_limit = Property::where('added_by', $current_user)->where('package_id', $request->id)->get();

//         $response['total_limit_of_advertisement'] = ($adv_count);
    //         $response['total_limit_of_property'] = ($prop_count);

//         $response['used_limit_of_advertisement'] = $package->used_limit_for_advertisement;
    //         $response['used_limit_of_property'] = $package->used_limit_for_property;
    //     } else {
    //         $response['error'] = true;
    //         $response['message'] = $validator->errors()->first();
    //     }
    //     return response()->json($response);
    // }
    public function get_limits(Request $request)
    {
        $validator = Validator::make($request->all(), [
            'package_type' => 'required',

]);
        if (!$validator->fails()) {
            if ($request->package_type == "property") {
                $package_type = "property_limit";
                $status = "prop_status";
                $message = "Post Property";
            } else {
                $package_type = "advertisement_limit";
                $message = "Advertisement";
                $status = "adv_status";
            }

$payload = JWTAuth::getPayload($this->bearerToken($request));
            $current_user = ($payload['customer_id']);
            $current_package = UserPurchasedPackage::where('modal_id', $current_user)
                ->with(['package' => function ($q) use ($package_type) {
                    $q->select('id', $package_type)->where($package_type, '>', 0)->orWhere($package_type, null);
                }])
                ->whereHas('package', function ($q) use ($package_type) {
                    $q->where($package_type, '>', 0)->orWhere($package_type, null);
                })->where($status, 1)
                ->first();

if (!($current_package)) {
                $response['error'] = false;
                $response['message'] = 'Please Subscribe for ' . $message;
                $response['package'] = false;
            } else {
                $response['error'] = false;
                $response['message'] = "User able to upload";
                $response['package'] = true;
            }

if (($customer)) {

$response['is_premium'] = $customer->is_premium == 1 ? true : ($customer->subscription == 1 ? true : false);

$response['subscription'] = $customer->subscription == 1 ? true : false;
            } else {

$response['is_premium'] = false;
                $response['subscription'] = false;
            }
        } else {
            $response['error'] = true;
            $response['message'] = $validator->errors()->first();
        }
        return response()->json($response);
    }
    public function get_languages(Request $request)
    {
        $validator = Validator::make($request->all(), [
            'language_code' => 'required',
        ]);

if (!$validator->fails()) {
            $language = Language::where('code', $request->language_code)->first();

if ($language) {
                if ($request->web_language_file) {
                    $json_file_path = public_path('web_languages/' . $request->language_code . '.json');
                } else {
                    $json_file_path = public_path('languages/' . $request->language_code . '.json');
                }

if (file_exists($json_file_path)) {
                    $json_string = file_get_contents($json_file_path);
                    $json_data = json_decode($json_string);

if ($json_data !== null) {
                        $language->file_name = $json_data;
                        $response['error'] = false;
                        $response['message'] = "Data Fetch Successfully";
                        $response['data'] = $language;
                    } else {
                        $response['error'] = true;
                        $response['message'] = "Invalid JSON format in the language file";
                    }
                } else {
                    $response['error'] = true;
                    $response['message'] = "Language file not found";
                }
            } else {
                $response['error'] = true;
                $response['message'] = "Language not found";
            }
        } else {
            $response['error'] = true;
            $response['message'] = $validator->errors()->first();
        }

return response()->json($response);
    }
    public function get_payment_details(Request $request)
    {
        $payload = JWTAuth::getPayload($this->bearerToken($request));
        $current_user = ($payload['customer_id']);

$offset = isset($request->offset) ? $request->offset : 0;
        $limit = isset($request->limit) ? $request->limit : 10;
        // $id = $request->userid;

//  $result=  Notifications::where("customers_id",$id)->orwhere('send_type', '1')->orderBy('id', 'DESC');
        // $total = $result->get()->count();
        // $Notifications = $result->skip($offset)->take($limit)->get();

$payment = Payments::where('customer_id', $current_user);
        $total = $payment->get()->count();

$result = $payment->skip($offset)->take($limit)->get();

if (count($result)) {
            $response['error'] = false;
            $response['message'] = "Data Fetch Successfully";

$response['total'] = $total;

$response['data'] = $result;
        } else {
            $response['error'] = false;
            $response['message'] = "No data found!";
            $response['data'] = [];
        }
        return response()->json($response);
    }

public function paypal(Request $request)
    {
        $validator = Validator::make($request->all(), [
            'package_id' => 'required',
            'amount' => 'required'

]);
        if (!$validator->fails()) {
            $payload = JWTAuth::getPayload($this->bearerToken($request));
            $current_user = ($payload['customer_id']);
            $paypal = new Paypal();
            // url('') . config('global.IMG_PATH')
            $returnURL = url('api/app_payment_status');
            $cancelURL = url('api/app_payment_status');
            $notifyURL = url('webhook/paypal');
            // $package_id = $request->package_id;
            $package_id = $request->package_id;
            // Get product data from the database

// Get current user ID from the session
            $paypal->add_field('return', $returnURL);
            $paypal->add_field('cancel_return', $cancelURL);
            $paypal->add_field('notify_url', $notifyURL);
            $custom_data = $package_id . ',' . $current_user;

// // Add fields to paypal form

$paypal->add_field('item_name', "package");
            $paypal->add_field('custom_id', json_encode($custom_data));

$paypal->add_field('custom', ($custom_data));

$paypal->add_field('amount', $request->amount);

// Render paypal form
            $paypal->paypal_auto_form();
        } else {
            $response['error'] = true;
            $response['message'] = "Please fill all data and Submit";
        }
    }
    public function app_payment_status(Request $request)
    {

$paypalInfo = $request->all();

if (!empty($paypalInfo) && isset($_GET['st']) && strtolower($_GET['st']) == "completed") {

$response['error'] = false;
            $response['message'] = "Your Purchase Package Activate Within 10 Minutes ";
            $response['data'] = $paypalInfo['txn_id'];
        } elseif (!empty($paypalInfo) && isset($_GET['st']) && strtolower($_GET['st']) == "authorized") {

$response['error'] = false;
            $response['message'] = "Your payment has been Authorized successfully. We will capture your transaction within 30 minutes, once we process your order. After successful capture Ads wil be credited automatically.";
            $response['data'] = $paypalInfo;
        } else {
            $response['error'] = true;
            $response['message'] = "Payment Cancelled / Declined ";
            $response['data'] = (isset($_GET)) ? $paypalInfo : "";
        }
        return (response()->json($response));
    }
    public function get_payment_settings(Request $request)
    {

$payment_settings =
            Setting::select('type', 'data')->whereIn('type', ['paypal_business_id', 'sandbox_mode', 'paypal_gateway', 'razor_key', 'razor_secret', 'razorpay_gateway', 'paystack_public_key', 'paystack_secret_key', 'paystack_currency', 'paystack_gateway', 'stripe_publishable_key', 'stripe_currency', 'stripe_gateway', 'stripe_secret_key'])->get();

foreach ($payment_settings as $setting) {

if ($setting->type === 'stripe_secret_key') {
                $publicKey = file_get_contents(base_path('public_key.pem')); // Load the public key
                $encryptedData = '';
                if (openssl_public_encrypt($setting->data, $encryptedData, $publicKey)) {
                    $setting->data = base64_encode($encryptedData);
                }
            }
        }

if (count($payment_settings)) {
            $response['error'] = false;
            $response['message'] = "Data Fetch Successfully";
            $response['data'] = $payment_settings;
        } else {
            $response['error'] = false;
            $response['message'] = "No data found!";
            $response['data'] = [];
        }
        return (response()->json($response));
    }
    public function send_message(Request $request)
    {

$validator = Validator::make($request->all(), [
            'sender_id' => 'required',
            'receiver_id' => 'required',

'property_id' => 'required',
        ]);
        $fcm_id = array();
        if (!$validator->fails()) {

$chat = new Chats();
            $chat->sender_id = $request->sender_id;
            $chat->receiver_id = $request->receiver_id;
            $chat->property_id = $request->property_id;
            $chat->message = $request->message;
            $destinationPath = public_path('images') . config('global.CHAT_FILE');
            if (!is_dir($destinationPath)) {
                mkdir($destinationPath, 0777, true);
            }
            // image upload
            if ($request->hasFile('file')) {
                $file = $request->file('file');
                $fileName = microtime(true) . "." . $file->getClientOriginalExtension();
                $file->move($destinationPath, $fileName);
                $chat->file = $fileName;
            } else {
                $chat->file = '';
            }

$audiodestinationPath = public_path('images') . config('global.CHAT_AUDIO');
            if (!is_dir($audiodestinationPath)) {
                mkdir($audiodestinationPath, 0777, true);
            }
            if ($request->hasFile('audio')) {
                $file = $request->file('audio');
                $fileName = microtime(true) . "." . $file->getClientOriginalExtension();
                $file->move($audiodestinationPath, $fileName);
                $chat->audio = $fileName;
            } else {
                $chat->audio = '';
            }
            $chat->save();
            $customer = Customer::select('id', 'fcm_id', 'name', 'profile')->with(['usertokens' => function ($q) {
                $q->select('fcm_id', 'id', 'customer_id');
            }])->find($request->receiver_id);
            $property = Property::find($request->property_id);
            if ($customer) {

foreach ($customer->usertokens as $usertokens) {

array_push($fcm_id, $usertokens->fcm_id);
                }

$username = $customer->name;
                $profile = $customer->profile;
            }
            $user_data = User::select('fcm_id', 'name')->get();

if (!$customer) {
                $username = "Admin";
                $profile = "";

foreach ($user_data as $user) {
                    array_push($fcm_id, $user->fcm_id);
                }
            };
            $customer = Customer::select('fcm_id', 'name')->find($request->sender_id);

$Property = Property::find($request->property_id);

$chat_message_type = "";

if (!empty($request->file('audio'))) {
                $chat_message_type = "audio";
            } else if (!empty($request->file('file')) && $request->message == "") {
                $chat_message_type = "file";
            } else if (!empty($request->file('file')) && $request->message != "") {
                $chat_message_type = "file_and_text";
            } else if (empty($request->file('file')) && $request->message != "" && empty($request->file('audio'))) {
                $chat_message_type = "text";
            } else {
                $chat_message_type = "text";
            }

$fcmMsg = array(
                'title' => 'Message',
                'message' => $request->message,
                'type' => 'chat',
                'body' => $request->message,
                'sender_id' => $request->sender_id,
                'receiver_id' => $request->receiver_id,
                'file' => $chat->file,
                'username' => $username,
                'user_profile' => $profile,
                'audio' => $chat->audio,
                'date' => $chat->created_at,
                'click_action' => 'FLUTTER_NOTIFICATION_CLICK',
                'sound' => 'default',
                'time_ago' => $chat->created_at->diffForHumans(now(), CarbonInterface::DIFF_RELATIVE_AUTO, true),
                'property_id' => $Property->id,
                'property_title_image' => $Property->title_image,
                'title' => $Property->title,
                'chat_message_type' => $chat_message_type,
            );

$send = send_push_notification($fcm_id, $fcmMsg);
            $response['error'] = false;
            $response['message'] = "Data Store Successfully";
            $response['id'] = $chat->id;
            $response['data'] = $send;
        } else {
            $response['error'] = true;
            $response['message'] = "Please fill all data and Submit";
        }
        return (response()->json($response));
    }
    public function get_messages(Request $request)
    {
        $validator = Validator::make($request->all(), [
            'user_id' => 'required',
            'property_id' => 'required'

]);
        if (!$validator->fails()) {
            $payload = JWTAuth::getPayload($this->bearerToken($request));
            $current_user = ($payload['customer_id']);

$tempRow = array();
            $perPage = $request->per_page ? $request->per_page : 15; // Number of results to display per page
            $page = $request->page ?? 1; // Get the current page from the query string, or default to 1
            $chat = Chats::where('property_id', $request->property_id)
                ->where(function ($query) use ($request) {
                    $query->where('sender_id', $request->user_id)
                        ->orWhere('receiver_id', $request->user_id);
                })
                ->Where(function ($query) use ($current_user) {
                    $query->where('sender_id', $current_user)
                        ->orWhere('receiver_id', $current_user);
                })
                ->orderBy('created_at', 'DESC')
                //  ->get();
                ->paginate($perPage, ['*'], 'page', $page);

// You can then pass the $chat object to your view to display the paginated results.

$chat_message_type = "";
            if ($chat) {

$chat->map(function ($chat) use ($chat_message_type, $request) {

if (!empty($chat->audio)) {
                        $chat_message_type = "audio";
                    } else if (!empty($chat->file) && $chat->message == "") {
                        $chat_message_type = "file";
                    } else if (!empty($chat->file) && $chat->message != "") {
                        $chat_message_type = "file_and_text";
                    } else if (empty($chat->file) && !empty($chat->message) && empty($chat->audio)) {
                        $chat_message_type = "text";
                    } else {
                        $chat_message_type = "text";
                    }

$chat['chat_message_type'] = $chat_message_type;
                    if ($request->user_id == 0) {
                        $chat['user_profile'] = url('/assets/images/faces/2.jpg');
                    } else {
                        $user = Customer::find($request->user_id);
                        $chat['user_profile'] = $user->profile;
                    }
                });

$response['error'] = false;
                $response['message'] = "Data Fetch Successfully";
                $response['total_page'] = $chat->lastPage();
                $response['data'] = $chat;
            } else {
                $response['error'] = false;
                $response['message'] = "No data found!";
                $response['data'] = [];
            }
        } else {
            $response['error'] = true;
            $response['message'] = "Please fill all data and Submit";
        }
        return response()->json($response);
    }

public function get_chats(Request $request)
    {
        $payload = JWTAuth::getPayload($this->bearerToken($request));
        $current_user = ($payload['customer_id']);
        $perPage = $request->per_page ? $request->per_page : 15; // Number of results to display per page
        $page = $request->page ?? 1;

$chat = Chats::with(['sender', 'receiver'])->with('property')
            ->select('id', 'sender_id', 'receiver_id', 'property_id', 'created_at')
            ->where('sender_id', $current_user)
            ->orWhere('receiver_id', $current_user)
            ->orderBy('id', 'desc')
            ->groupBy('property_id')
            ->paginate($perPage, ['*'], 'page', $page);

if (!$chat->isEmpty()) {

$rows = array();

$count = 1;

$response['total_page'] = $chat->lastPage();

foreach ($chat as $key => $row) {
                $tempRow = array();
                $tempRow['property_id'] = $row->property_id;
                $tempRow['title'] = $row->property->title;
                $tempRow['title_image'] = $row->property->title_image;
                $tempRow['date'] = $row->created_at;
                $tempRow['property_id'] = $row->property_id;
                if (!$row->receiver || !$row->sender) {
                    $user =
                        user::where('id', $row->sender_id)->orWhere('id', $row->receiver_id)->select('id')->first();

$tempRow['user_id'] = 0;
                    $tempRow['name'] = "Admin";
                    $tempRow['profile'] = '';

// $tempRow['fcm_id'] = $row->receiver->fcm_id;
                } else {
                    if ($row->sender->id == $current_user) {

$tempRow['user_id'] = $row->receiver->id;
                        $tempRow['name'] = $row->receiver->name;
                        $tempRow['profile'] = $row->receiver->profile;
                        $tempRow['firebase_id'] = $row->receiver->firebase_id;
                        $tempRow['fcm_id'] = $row->receiver->fcm_id;
                    }
                    if ($row->receiver->id == $current_user) {
                        $tempRow['user_id'] = $row->sender->id;
                        $tempRow['name'] = $row->sender->name;

$tempRow['profile'] = $row->sender->profile;
                        $tempRow['firebase_id'] = $row->sender->firebase_id;
                        $tempRow['fcm_id'] = $row->sender->fcm_id;
                    }
                }
                $rows[] = $tempRow;
                // $parameters[] = $arr;
                $count++;
            }

if (isset($request->city) || isset($request->state)) {
            if (isset($request->type)) {
                DB::enableQueryLog();

$result = Property::with('category')
                    ->where('status', 1)
                    ->where('propery_type', $request->type)
                    ->where(function ($query) use ($request) {
                        $query->where('state', 'LIKE', "%$request->state%")
                            ->orWhere('city', 'LIKE', "%$request->city%");
                    })
                    ->get();
            } else {
                $result = Property::with('category')->where('city', 'LIKE', "%$request->city%")->where('state', 'LIKE', "%$request->state%")->where('status', 1)->get();
            }
        } else {
            $result = Property::with('category')->where('status', 1)->get();
        }

$rows = array();
        $tempRow = array();
        $count = 1;

if (!$result->isEmpty()) {

foreach ($result as $key => $row) {
                $tempRow['id'] = $row->id;
                $tempRow['slug_id'] = $row->slug_id;
                $tempRow['title'] = $row->title;
                $tempRow['title_image'] = $row->title_image;
                $tempRow['price'] = $row->price;
                $tempRow['latitude'] = $row->latitude;
                $tempRow['longitude'] = $row->longitude;
                $tempRow['city'] = $row->city;
                $tempRow['state'] = $row->state;
                $tempRow['country'] = $row->country;
                $tempRow['category'] = $row->category;

if ($row->propery_type == 0) {
                    $tempRow['property_type'] = "Sell";
                } elseif ($row->propery_type == 1) {
                    $tempRow['property_type'] = "Rent";
                } elseif ($row->propery_type == 2) {
                    $tempRow['property_type'] = "sold";
                } elseif ($row->propery_type == 3) {
                    $tempRow['property_type'] = "Rented";
                }
                $rows[] = $tempRow;

$count++;
            }

$response['error'] = false;
            $response['data'] = $rows;
        } else {
            $response['error'] = false;
            $response['data'] = [];
        }
        return response()->json($response);
    }
    public function update_property_status(Request $request)
    {
        $validator = Validator::make($request->all(), [
            'status' => 'required',
            'property_id' => 'required'

]);
        if (!$validator->fails()) {
            $property = Property::find($request->property_id);
            $property->propery_type = $request->status;
            $property->save();
            $response['error'] = false;
            $response['message'] = "Data updated Successfully";
        } else {
            $response['error'] = true;
            $response['message'] = "Please fill all data and Submit";
        }
        return response()->json($response);
    }
    public function get_count_by_cities_categoris(Request $request)
    {
        // get count by category

$categoriesWithCount = Category::withCount('properties')->get();
        $cat_arr = array();
        $city_arr = array();
        $agent_arr = array();

foreach ($categoriesWithCount as $category) {
            array_push($cat_arr, ['category' => $category->category, 'Count' => $category->properties_count]);
        }
        $response['category_data'] = $cat_arr;
        $propertiesByCity = Property::groupBy('city')
            ->select('city', DB::raw('count(*) as count'))->where('status', 1)
            ->orderBy('count', 'DESC')->get();

foreach ($propertiesByCity as $city) {
            if ($city->city != '') {
                $apiKey = env('UNSPLASH_API_KEY');

// $apiKey = 'nWvrLmCqMn48-hxJr0iJq7TCy6El0mNy1j-ux0LO3jw';
                $query = $city->city;

$perPage = 2;
                $apiUrl = "https://api.unsplash.com/search/photos/?query=$query&per_page=$perPage";
                $ch = curl_init($apiUrl);
                curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
                curl_setopt($ch, CURLOPT_HTTPHEADER, [
                    'Authorization: Client-ID ' . $apiKey,
                ]);
                $unsplashResponse = curl_exec($ch);

curl_close($ch);

$unsplashData = json_decode($unsplashResponse, true);
                // Check if the response contains data
                if (isset($unsplashData['results'])) {
                    $results = $unsplashData['results'];

// Initialize the image URL
                    $imageUrl = '';

// Loop through the results and get the first image URL
                    foreach ($results as $result) {
                        $imageUrl = $result['urls']['regular'];
                        break; // Stop after getting the first image URL
                    }
                    if ($imageUrl != "") {

array_push($city_arr, ['City' => $city->city, 'Count' => $city->count, 'image' => $imageUrl]);
                    }
                }
            }
        }
        $response['city_data'] = $city_arr;

return response()->json($response);
    }

public function get_agents_details(Request $request)
    {
        $offset = isset($request->offset) ? $request->offset : 0;
        $limit = isset($request->limit) ? $request->limit : 10;
        $agent_arr = array();
        $propertiesByAgent = Property::with(['customer' => function ($q) {
            $q->where('role', 1);
        }])
            ->groupBy('added_by')
            ->select('added_by', DB::raw('count(*) as count'))->skip($offset)->take($limit)
            ->get();
        foreach ($propertiesByAgent as $agent) {
            if (count($agent->customer)) {
                array_push($agent_arr, ['agent' => $agent->added_by, 'Count' => $agent->count, 'customer' => $agent->customer]);
            }
        }
        if (count($agent_arr)) {
            $response['error'] = false;
            $response['message'] = "Data Fetch  Successfully";
            $response['agent_data'] = $agent_arr;
        } else {
            $response['error'] = false;
            $response['message'] = "No Data Found";
        }
        return response()->json($response);
    }
    public function get_facilities(Request $request)
    {
        $offset = isset($request->offset) ? $request->offset : 0;
        $limit = isset($request->limit) ? $request->limit : 10;

$facilities = OutdoorFacilities::all();

// if (isset($request->search) && !empty($request->search)) {
        //     $search = $request->search;
        //     $facilities->where('category', 'LIKE', "%$search%");
        // }

if (isset($request->id) && !empty($request->id)) {
            $id = $request->id;
            $facilities->where('id', '=', $id);
        }
        $result = $facilities;

$total = $facilities->count();

if (!$result->isEmpty()) {
            $response['error'] = false;
            $response['message'] = "Data Fetch Successfully";

$response['total'] = $total;
            $response['data'] = $result;
        } else {
            $response['error'] = false;
            $response['message'] = "No data found!";
            $response['data'] = [];
        }
        return response()->json($response);
    }
    public function get_report_reasons(Request $request)
    {
        $offset = isset($request->offset) ? $request->offset : 0;
        $limit = isset($request->limit) ? $request->limit : 10;

$report_reason = report_reasons::all();

if (isset($request->id) && !empty($request->id)) {
            $id = $request->id;
            $report_reason->where('id', '=', $id);
        }
        $result = $report_reason->skip($offset)->take($limit);

$total = $report_reason->count();

if (!$result->isEmpty()) {
            $response['error'] = false;
            $response['message'] = "Data Fetch Successfully";

$response['total'] = $total;
            $response['data'] = $result;
        } else {
            $response['error'] = false;
            $response['message'] = "No data found!";
            $response['data'] = [];
        }
        return response()->json($response);
    }
    public function add_reports(Request $request)
    {
        $validator = Validator::make($request->all(), [
            'reason_id' => 'required',
            'property_id' => 'required',

]);
        $payload = JWTAuth::getPayload($this->bearerToken($request));
        $current_user = ($payload['customer_id']);
        if (!$validator->fails()) {
            $report_count = user_reports::where('property_id', $request->property_id)->where('customer_id', $current_user)->get();
            if (!count($report_count)) {
                $report_reason = new user_reports();
                $report_reason->reason_id = $request->reason_id ? $request->reason_id : 0;
                $report_reason->property_id = $request->property_id;
                $report_reason->customer_id = $current_user;
                $report_reason->other_message = $request->other_message ? $request->other_message : '';

$report_reason->save();

$response['error'] = false;
                $response['message'] = "Report Submited Successfully";
            } else {
                $response['error'] = false;
                $response['message'] = "Already Reported";
            }
        } else {
            $response['error'] = true;
            $response['message'] = "Please fill all data and Submit";
        }
        return response()->json($response);
    }
    public function delete_chat_message(Request $request)
    {
        $validator = Validator::make($request->all(), [

'receiver_id' => 'required',

]);
        if (!$validator->fails()) {

$customer_ids = Customer::select('fcm_id', 'id')->where("fcm_id", "!=", "")->where('id', $request->receiver_id)->pluck('id')->toArray();

$fcm_ids = Usertokens::select('fcm_id')->whereIn('customer_id', $customer_ids)->get()->pluck('fcm_id')->toArray();
            if (isset($request->message_id)) {
                $chat = Chats::find($request->message_id);
                if ($chat) {

if (!empty($fcm_ids)) {

$registrationIDs = array_filter($fcm_ids);

$fcmMsg = array(
                            'title' => "Delete Chat Message",
                            'message' => "Message Deleted Successfully",
                            "image" => '',
                            'type' => 'delete_message',
                            'message_id' => $request->message_id,
                            'body' => 'Message Deleted Successfully',
                            'click_action' => 'FLUTTER_NOTIFICATION_CLICK',
                            'sound' => 'default',

);
                        send_push_notification($registrationIDs, $fcmMsg, 1);
                    }
                    $chat->delete();

$response['error'] = false;
                    $response['message'] = "Message Deleted Successfully";
                }
            }
            if (isset($request->sender_id) && isset($request->receiver_id) && isset($request->property_id)) {

$user_chat = Chats::where('property_id', $request->property_id)
                    ->where(function ($query) use ($request) {
                        $query->where('sender_id', $request->sender_id)
                            ->orWhere('receiver_id', $request->receiver_id);
                    })
                    ->orWhere(function ($query) use ($request) {
                        $query->where('sender_id', $request->receiver_id)
                            ->orWhere('receiver_id', $request->sender_id);
                    });
                if (count($user_chat->get())) {

$user_chat->delete();
                    $response['error'] = false;
                    $response['message'] = "chat deleted successfully";
                } else {
                    $response['error'] = false;
                    $response['message'] = "No Data Found";
                }
            } else {
                $response['error'] = false;
                $response['message'] = "No Data Found";
            }
        }
        return response()->json($response);
    }
    public function get_user_recommendation(Request $request)
    {
        $offset = isset($request->offset) ? $request->offset : 0;
        $limit = isset($request->limit) ? $request->limit : 10;
        $payload = JWTAuth::getPayload($this->bearerToken($request));
        $current_user = ($payload['customer_id']);

$user_interest = UserInterest::where('user_id', $current_user)->first();
        if(collect($user_interest)->isNotEmpty()){

$property = Property::with('customer')->with('user')->with('category:id,category,image')->with('assignfacilities.outdoorfacilities')->with('favourite')->with('parameters')->with('interested_users')->where('status',1);

$property_type = $request->property_type;
            if ($user_interest->category_ids != '') {

$category_ids = explode(',', $user_interest->category_ids);

$property = $property->whereIn('category_id', $category_ids);
            }

if ($user_interest->price_range != '') {

$max_price = explode(',', $user_interest->price_range)[1];

$min_price = explode(',', $user_interest->price_range)[0];

if (isset($max_price) && isset($min_price)) {
                    $min_price = floatval($min_price);
                    $max_price = floatval($max_price);

$property = $property->where(function ($query) use ($min_price, $max_price) {
                        $query->whereRaw("CAST(price AS DECIMAL(10, 2)) >= ?", [$min_price])
                            ->whereRaw("CAST(price AS DECIMAL(10, 2)) <= ?", [$max_price]);
                    });
                }
            }

if ($user_interest->city != '') {                
                $city = $user_interest->city;
                $property = $property->where('city', $city);
            }
            if ($user_interest->property_type != '') {
                $property_type = explode(',',  $user_interest->property_type);
            }
            if ($user_interest->outdoor_facilitiy_ids != '') {

$outdoor_facilitiy_ids = explode(',', $user_interest->outdoor_facilitiy_ids);
                $property = $property->whereHas('assignfacilities.outdoorfacilities', function ($q) use ($outdoor_facilitiy_ids) {
                    $q->whereIn('id', $outdoor_facilitiy_ids);
                });
            }

if (isset($property_type)) {
                if (count($property_type) == 2) {
                    $property_type = $property->where(function($query) use($property_type){
                        $query->where('propery_type', $property_type[0])->orWhere('propery_type', $property_type[1]);
                    });
                } else {
                    if (isset($property_type[0])  &&  $property_type[0] == 0) {

$property = $property->where('propery_type', $property_type[0]);
                    }
                    if (isset($property_type[0])  &&  $property_type[0] == 1) {

$property = $property->where('propery_type', $property_type[0]);
                    }
                }
            }

$total = $property->get()->count();

$result = $property->skip($offset)->take($limit)->get();
            $property_details = get_property_details($result, $current_user);

if (!empty($result)) {
                $response['error'] = false;
                $response['message'] = "Data Fetch Successfully";
                $response['total'] = $total;
                $response['data'] = $property_details;
            } else {

$response['error'] = false;
                $response['message'] = "No data found!";
                $response['data'] = [];
            }
        }else{
            $response['error'] = false;
            $response['message'] = "No data found!";
            $response['data'] = [];
        }
        return ($response);
    }
    public function contct_us(Request $request)
    {
        $validator = Validator::make($request->all(), [

'first_name' => 'required',
            'last_name' => 'required',
            'email' => 'required',
            'subject' => 'required',
            'message' => 'required',

]);

if (!$validator->fails()) {

$contactrequest = new Contactrequests();
            $contactrequest->first_name = $request->first_name;
            $contactrequest->last_name = $request->last_name;
            $contactrequest->email = $request->email;
            $contactrequest->subject = $request->subject;
            $contactrequest->message = $request->message;
            $contactrequest->save();
            $response['error'] = false;
            $response['message'] = "Conatct Request Send successfully";
        } else {

$response['error'] = true;
            $response['message'] =  $validator->errors()->first();
        }
        return response()->json($response);
    }
    public function createPaymentIntent(Request $request)
    {
        $validator = Validator::make($request->all(), [

'package_id' => 'required',
        ]);
        if ($validator->fails()) {
            return response()->json([
                'error' => true,
                'message' => $validator->errors()->first(),
            ], 400);
        }
        try {
            $limit = isset($request->limit) ? $request->limit : 10;
            $payload = JWTAuth::getPayload($this->bearerToken($request));

$secret_key = system_setting('stripe_secret_key');
            $current_user = ($payload['customer_id']);

$stripe_currency = system_setting('stripe_currency');
            $package = Package::find($request->package_id);

$data = [
                'amount' => ((int)($package['price'])) * 100,
                'currency' => $stripe_currency,
                'description' => $request->description,

'payment_method_types[]' => $request->payment_method,
                'metadata' => [
                    'userId' => $current_user,
                    'packageId' => $request->package_id,
                ],
                'shipping' => [
                    'name' => $request['shipping']['name'], // Replace with the actual name
                    'address' => [
                        'line1' => !empty($request['shipping']['address']['line1']) ? $request['shipping']['address']['line1'] : '',
                        'line2' => !empty($request['shipping']['address']['line2']) ? $request['shipping']['address']['line2'] : '',
                        'postal_code' => !empty($request['shipping']['address']['postal_code']) ? $request['shipping']['address']['postal_code'] : '',
                        'city' => !empty($request['shipping']['address']['city']) ? $request['shipping']['address']['city'] : '',
                        'state' => !empty($request['shipping']['address']['state']) ? $request['shipping']['address']['state'] : '',
                        'country' => !empty($request['shipping']['address']['country']) ? $request['shipping']['address']['country'] : '',
                    ],
                ],
            ];
            $headers = [
                'Authorization' => 'Bearer ' . $secret_key,
                'Content-Type' => 'application/x-www-form-urlencoded',
            ];
            $response = Http::withHeaders($headers)->asForm()->post('https://api.stripe.com/v1/payment_intents', $data);
            $responseData = $response->json();
            return response()->json([
                'data' => $responseData,
                'message' => 'Intent created.',
            ]);
        } catch (\Exception $e) {
            return response()->json([
                'error' => true,
                'message' => 'An error occurred while processing the payment.',
            ], 500);
        }
    }
    public function confirmPayment(Request $request)
    {
        $validator = Validator::make($request->all(), [
            'paymentIntentId' => 'required',
        ]);
        if ($validator->fails()) {
            return response()->json([
                'error' => true,
                'message' => $validator->errors()->first(),
            ], 400);
        }
        try {

$secret_key = system_setting('stripe_secret_key');
            $headers = [
                'Authorization' => 'Bearer ' . $secret_key,
                'Content-Type' => 'application/x-www-form-urlencoded',
            ];
            $response = Http::withHeaders($headers)
                ->get("https://api.stripe.com/v1/payment_intents/{$request->paymentIntentId}");
            $responseData = $response->json();
            $statusOfTransaction = $responseData['status'];
            if ($statusOfTransaction == 'succeeded') {
                return response()->json([
                    'message' => 'Transaction successful',
                    'success' => true,
                    'status' => $statusOfTransaction,
                ]);
            } elseif ($statusOfTransaction == 'pending' || $statusOfTransaction == 'captured') {
                return response()->json([
                    'message' => 'Transaction pending',
                    'success' => true,
                    'status' => $statusOfTransaction,
                ]);
            } else {
                return response()->json([
                    'message' => 'Transaction failed',
                    'success' => false,
                    'status' => $statusOfTransaction,
                ]);
            }
        } catch (\Exception $e) {
            return response()->json([
                'error' => true,
                'message' => 'An error occurred while processing the payment.',
            ], 500);
        }
    }
    public function delete_property(Request $request)
    {
        $validator = Validator::make($request->all(), [

'id' => 'required',
        ]);
        if ($validator->fails()) {
            return response()->json([
                'error' => true,
                'message' => $validator->errors()->first(),
            ], 400);
        }
        $property = Property::find($request->id);
        if ($property) {
            if ($property->delete()) {

$chat = Chats::where('property_id', $property->id);
                if ($chat) {
                    $chat->delete();
                }

$slider = Slider::where('propertys_id', $property->id);
                if ($slider) {
                    $slider->delete();
                }

$notifications = Notifications::where('propertys_id', $property->id);
                if ($notifications) {
                    $notifications->delete();
                }

if ($property->title_image != '') {
                    if (file_exists(public_path('images') . config('global.PROPERTY_TITLE_IMG_PATH') . $property->title_image)) {
                        unlink(public_path('images') . config('global.PROPERTY_TITLE_IMG_PATH') . $property->title_image);
                    }
                }
                foreach ($property->gallery as $row) {
                    if (PropertyImages::where('id', $row->id)->delete()) {
                        if ($row->image_url != '') {
                            if (file_exists(public_path('images') . config('global.PROPERTY_GALLERY_IMG_PATH') . $property->id . "/" . $row->image)) {
                                unlink(public_path('images') . config('global.PROPERTY_GALLERY_IMG_PATH') . $property->id . "/" . $row->image);
                            }
                        }
                    }
                }

$slider = Slider::where('propertys_id', $property->id)->get();

foreach ($slider as $row) {
                    $image = $row->image;

if (Slider::where('id', $row->id)->delete()) {
                        if (file_exists(public_path('images') . config('global.SLIDER_IMG_PATH') . $image)) {
                            unlink(public_path('images') . config('global.SLIDER_IMG_PATH') . $image);
                        }
                    }
                }

$response['error'] = false;
                $response['message'] =  'Delete Successfully';
            } else {
                $response['error'] = true;
                $response['message'] = 'something wrong';
            }
        } else {
            $response['error'] = true;
            $response['message'] = 'Data not found';
        }
        return response()->json($response);
    }
    public function assign_package(Request $request)
    {

$validator = Validator::make($request->all(), [
            'package_id' => 'required',
            'product_id' => 'required_if:in_app,true',

]);

if ($validator->fails()) {
            return response()->json([
                'error' => true,
                'message' => $validator->errors()->first(),
            ], 400);
        }
        $payload = JWTAuth::getPayload($this->bearerToken($request));
        $current_user = ($payload['customer_id']);
        $user = Customer::find($current_user);

$start_date =  Carbon::now();

if ($request->in_app === true) {

$package = Package::where('ios_product_id', $request->product_id)->find($request->package_id);
        } else {

$package = Package::where('price', 0)->find($request->package_id);
        }
        $data_exists = UserPurchasedPackage::where('modal_id', $current_user)->get();

if ($package) {

if ($package->type == "premium_user") {
                UserPurchasedPackage::where('modal_id', $current_user)->where('package_id', $package->id)->delete();
            }
            $user_package = new UserPurchasedPackage();

$user_package->modal()->associate($user);
            $user_package->package_id = $request->package_id;
            $user_package->start_date = $start_date;
            $user_package->end_date = $package->duration != 0 ? Carbon::now()->addDays($package->duration) : NULL;
            $user_package->save();

if ($package->type == "premium_user") {
                $user->is_premium = 1;
            } else {

$user->subscription = 1;
            }
            $user->update();
            $response['error'] = false;
            $response['message'] =  'Package Purchased Successfully';
        } else {
            $response['error'] = false;
            $response['message'] =  'Package Not Found';
        }
        return response()->json($response);
    }
    // public function assign_package(Request $request)
    // {

//     $validator = Validator::make($request->all(), [
    //         'package_id' => 'required',
    //         'product_id' => 'required_if:in_app,true',

//     ]);

//     if ($validator->fails()) {
    //         return response()->json([
    //             'error' => true,
    //             'message' => $validator->errors()->first(),
    //         ], 400);
    //     }
    //     $payload = JWTAuth::getPayload($this->bearerToken($request));
    //     $current_user = ($payload['customer_id']);
    //     $user = Customer::find($current_user);
    //     $start_date =  Carbon::now();
    //     if ($request->in_app) {
    //         $package = Package::where('ios_product_id', $request->product_id)->find($request->package_id);
    //     } else {

//         $package = Package::where('price', 0)->find($request->package_id);
    //     }
    //     $data_exists = UserPurchasedPackage::where('modal_id', $current_user)->get();

//     if ($package) {

//         $user_package = new UserPurchasedPackage();

//         $user_package->modal()->associate($user);
    //         $user_package->package_id = $request->package_id;
    //         $user_package->start_date = $start_date;
    //         $user_package->end_date = $package->duration != 0 ? Carbon::now()->addDays($package->duration) : NULL;
    //         $user_package->save();
    //         if ($data_exists) {
    //             UserPurchasedPackage::where('modal_id', $current_user)->where('id', '!=', $user_package->id)->delete();
    //         }
    //         $user->subscription = 1;
    //         $user->update();
    //         $response['error'] = false;
    //         $response['message'] =  'Package Purchased Successfully';
    //     } else {
    //         $response['error'] = false;
    //         $response['message'] =  'Package Not Found';
    //     }
    //     return response()->json($response);
    // }
    public function get_app_settings(Request $request)
    {
        $result =  Setting::select('type', 'data')->whereIn('type', ['splash_logo', 'app_home_screen', 'placeholder_logo', 'light_tertiary', 'light_secondary', 'light_primary', 'dark_tertiary', 'dark_secondary', 'dark_primary'])->get();

$tempRow = [];

if (($request->user_id) != "") {
            update_subscription($request->user_id);

$customer_data = Customer::find($request->user_id);
            if ($customer_data) {
                if ($customer_data->isActive == 0) {

$tempRow['is_active'] = false;
                } else {
                    $tempRow['is_active'] = true;
                }
            }
        }

foreach ($result as $row) {
            $tempRow[$row->type] = $row->data;

if ($row->type == 'splash_logo' || $row->type == 'app_home_screen' || $row->type = "placeholder_logo") {

$tempRow[$row->type] = url('/assets/images/logo/') . '/' . $row->data;
            }
        }

$response['error'] = false;
        $response['data'] = $tempRow;
        return response()->json($response);
    }
    public function get_seo_settings(Request $request)
    {
        $offset = isset($request->offset) ? $request->offset : 0;
        $limit = isset($request->limit) ? $request->limit : 10;

$seo_settings = SeoSettings::select('id', 'page', 'image', 'title', 'description', 'keywords');

if (isset($request->page) && !empty($request->page)) {

$seo_settings->where('page', 'LIKE', "%$request->page%");
        } else {
            $seo_settings->where('page', 'LIKE', "%homepage%");
        }

$total = $seo_settings->count();
        $result = $seo_settings->skip($offset)->take($limit)->get();

// $seo_settingsWithCount = Category::withCount('properties')->get();
        $rows = array();
        $count = 0;
        if (!$result->isEmpty()) {

foreach ($result as $key => $row) {
                $tempRow['id'] = $row->id;
                $tempRow['page'] = $row->page;
                $tempRow['meta_image'] = $row->image;

if ($row->page == "properties-city") {
                    $tempRow['meta_title'] = "[Your City]'s Finest:" . $row->title;
                    $tempRow['meta_description'] = "Discover the charm of living near [Your City]." . $row->description;
                } else {

$tempRow['meta_title'] = $row->title;
                    $tempRow['meta_description'] = $row->description;
                }
                $tempRow['meta_keywords'] = $row->keywords;

$rows[] = $tempRow;

$count++;
            }
        }

if (!$result->isEmpty()) {
            $response['error'] = false;
            $response['message'] = "Data Fetch Successfully";

$response['total'] = $total;
            $response['data'] = $rows;
        } else {
            $response['error'] = false;
            $response['message'] = "No data found!";
            $response['data'] = [];
        }
        return response()->json($response);
    }
    public function get_interested_users(Request $request)
    {
        try {
            $validator = Validator::make($request->all(), [
                'property_id' => 'required_without:slug_id',
            ]);

if ($validator->fails()) {
                return response()->json([
                    'error' => true,
                    'message' => $validator->errors()->first(),
                ], 400);
            }
            $offset = isset($request->offset) ? $request->offset : 0;
            $limit = isset($request->limit) ? $request->limit : 10;
            if (isset($request->slug_id)) {
                $property = Property::where('slug_id', $request->slug_id)->first();
                $property_id = $property->id;
            } else {
                $property_id = $request->property_id;
            }
            $interested_users = InterestedUser::with('customer:id,name,profile,email,mobile')
                ->where('property_id', $property_id)
                ->take($limit)
                ->skip($offset)
                ->get();

$rows = $interested_users->pluck('customer')->filter()->flatten();

$response['error'] = false;
            $response['message'] = "Data Fetch Successfully";
            $response['data'] = $rows;
            $response['total'] = count($rows);
        } catch (\Throwable $th) {
            return response()->json([
                'error' => true,
                'message' => $th->__toString(),
            ], 400);
        }

return response()->json($response);
    }
    public function post_project(Request $request)
    {

if ($request->has('id')) {
            $validator = Validator::make($request->all(), [
                'title' => 'required',
            ]);
        } else {
            $validator = Validator::make($request->all(), [
                'title' => 'required',
                'description' => 'required',

'image' => 'required|file|max:3000|mimes:jpeg,png,jpg',

'category_id' => 'required',
                'city' => 'required',
                'state' => 'required',
                'country' => 'required',

]);
        }
        $seo_settings = \system_setting('seo_settings');

if (!$validator->fails()) {
            $payload = JWTAuth::getPayload($this->bearerToken($request));
            $current_user = ($payload['customer_id']);
            if (!(isset($request->id))) {
                $current_package = check_subscription($current_user, 'property_limit', 'prop_status');

if (!($current_package)) {
                    $response['error'] = false;
                    $response['message'] = 'Package not found';
                    return response()->json($response);
                }

$actualpackage = Package::find($current_package->package_id);

$package = UserPurchasedPackage::where('modal_id', $current_user)->where('package_id', $actualpackage->id)->where('prop_status', 1)->first();
                $prop_count = $package->package->property_limit;

$project = new Projects();
            } else {
                $project = Projects::where('added_by', $current_user)->find($request->id);
                if (!$project) {
                    $response['error'] = false;
                    $response['message'] = 'Project Not Found ';
                }
            }

if ($request->category_id) {
                $project->category_id = $request->category_id;
            }

if ($request->description) {
                $project->description = $request->description;
            }
            if ($request->location) {
                $project->location = $request->location;
            }
            $project->meta_title = $request->meta_title;
            $project->meta_description = $request->meta_description;
            $project->meta_keywords = $request->meta_keywords;
            // if ($request->meta_title) {
            //     $project->meta_title = $request->meta_title;
            // }
            // if ($request->meta_description) {
            //     $project->meta_description = $request->meta_description;
            // }
            // if ($request->meta_keywords) {
            //     $project->meta_keywords = $request->meta_keywords;
            // }

$project->added_by = $current_user;

if ($request->country) {
                $project->country = $request->country;
            }
            if ($request->state) {
                $project->state = $request->state;
            }
            if ($request->city) {
                $project->city = $request->city;
            }
            if ($request->latitude) {
                $project->latitude = $request->latitude;
            }
            if ($request->longitude) {
                $project->longitude = $request->longitude;
            }
            if ($request->video_link) {
                $project->video_link = $request->video_link;
            }
            if ($request->type) {
                $project->type = $request->type;
            }
            if ($request->id) {

if ($project->title !== $request->title) {

$title = !empty($request->title) ? $request->title : $project->title;
                    $project->title = $title;
                    $project->slug_id = generateUniqueSlug($title,null,4);
                } else {
                    $title = $request->title;
                    $project->title = $title;
                }
                if ($request->hasFile('image')) {
                    $project->image = store_image($request->file('image'), 'PROJECT_TITLE_IMG_PATH');
                }
                if ($request->hasFile('meta_image')) {
                    $project->meta_image = store_image($request->file('meta_image'), 'PROJECT_SEO_IMG_PATH');
                }else{
                    if($project->meta_image){
                        unlink_image($project->meta_image);
                    }
                    $project->meta_image = "";
                }
            } else {
                $project->title = $request->title;
                $project->image = $request->hasFile('image') ? store_image($request->file('image'), 'PROJECT_TITLE_IMG_PATH') : '';
                $project->meta_image = $request->hasFile('meta_image') ? store_image($request->file('meta_image'), 'PROJECT_SEO_IMG_PATH') : '';
                $title = $request->title;
                $project->slug_id = generateUniqueSlug($title,null,4);
            }

$project->save();
            if ($request->remove_gallery_images) {
                $remove_gallery_images = explode(',', $request->remove_gallery_images);
                foreach ($remove_gallery_images as $key => $value) {
                    $gallary_images = ProjectDocuments::find($value);
                    unlink_image($gallary_images->name);
                    $gallary_images->delete();
                }
            }
            if ($request->remove_documents) {
                $remove_documents = explode(',', $request->remove_documents);
                foreach ($remove_documents as $key => $value) {
                    $gallary_images = ProjectDocuments::find($value);
                    unlink_image($gallary_images->name);
                    $gallary_images->delete();
                }
            }

if ($request->hasfile('gallery_images')) {
                foreach ($request->file('gallery_images') as $file) {
                    $gallary_image = new ProjectDocuments();
                    $gallary_image->name = store_image($file, 'PROJECT_DOCUMENT_PATH');
                    $gallary_image->project_id = $project->id;
                    $gallary_image->type = 'image';
                    $gallary_image->save();
                }
            }
            if ($request->hasfile('documents')) {

foreach ($request->file('documents') as $file) {
                    $project_documents = new ProjectDocuments();
                    $project_documents->name = store_image($file, 'PROJECT_DOCUMENT_PATH');
                    $project_documents->project_id = $project->id;
                    $project_documents->type = 'doc';
                    $project_documents->save();
                }
            }
            if ($request->plans) {

foreach ($request->plans as $key => $plan) {
                    if (isset($plan['id']) && $plan['id'] != '') {
                        $project_plans =  ProjectPlans::find($plan['id']);
                    } else {
                        $project_plans = new ProjectPlans();
                    }
                    if (isset($plan['document'])) {
                        $project_plans->document = store_image($plan['document'], 'PROJECT_DOCUMENT_PATH');
                    }
                    $project_plans->title = $plan['title'];
                    $project_plans->project_id = $project->id;
                    $project_plans->save();
                }
            }

if ($request->remove_plans) {
                $remove_plans = explode(',', $request->remove_plans);

foreach ($remove_plans as $key => $value) {

$project_plans = ProjectPlans::find($value);

unlink_image($project_plans->document);

$project_plans->delete();
                }
            }

if (!(isset($request->id))) {
                $package->used_limit_for_property
                    =  $package->used_limit_for_property + 1;
                $package->save();

if ((($package->used_limit_for_property) >= ($prop_count) || $prop_count == 0)) {
                    $package->prop_status = 0;
                    $package->save();
                }
            }
            $result = Projects::with('customer')->with('gallary_images')->with('documents')->with('plans')->with('category:id,category,image')->where('id', $project->id)->get();
            $response['error'] = false;
            $response['message'] = isset($request->id) ? 'Project Updated Successfully' : 'Project Post Succssfully';
            $response['data'] = $result;
            // }
        } else {
            $response['error'] = true;
            $response['message'] = $validator->errors()->first();
        }
        return response()->json($response);
    }
    public function delete_project(Request $request)
    {
        $payload = JWTAuth::getPayload($this->bearerToken($request));
        $current_user = ($payload['customer_id']);
        $validator = Validator::make($request->all(), [

'id' => 'required',
        ]);
        if ($validator->fails()) {
            return response()->json([
                'error' => true,
                'message' => $validator->errors()->first(),
            ], 400);
        }
        $project = Projects::where('added_by', $current_user)->with('gallary_images')->with('documents')->with('plans')->find($request->id);

if ($project) {
            foreach ($project->gallary_images as $row) {
                if ($project->title_image != '') {
                    unlink_image($row->title_image);
                }
                $gallary_image = ProjectDocuments::find($row->id);
                if ($gallary_image) {
                    if ($row->name != '') {

unlink_image($row->name);
                    }
                }
            }

foreach ($project->documents as $row) {

$project_documents = ProjectDocuments::find($row->id);
                if ($project_documents) {
                    if ($row->name != '') {

unlink_image($row->name);
                    }
                    $project_documents->delete();
                }
            }
            foreach ($project->plans as $row) {

$project_plans = ProjectPlans::find($row->id);
                if ($project_plans) {
                    if ($row->name != '') {

unlink_image($row->document);
                    }
                    $project_plans->delete();
                }
            }
            $project->delete();
            $response['error'] = false;
            $response['message'] =  'Project Delete Successfully';
        } else {
            $response['error'] = true;
            $response['message'] = 'Data not found';
        }
        return response()->json($response);
    }
    public function get_projects(Request $request)
    {
        $offset = isset($request->offset) ? $request->offset : 0;
        $limit = isset($request->limit) ? $request->limit : 10;

$project = Projects::select('*')->with('customer:id,name,profile,email,mobile,address')->with('gallary_images')->with('documents')->with('plans')->with('category:id,category,image');

if (isset($userid)) {
            $project = $project->where('added_by', $userid);
        } else {
            $project = $project->where('status', 1);
        }

if (isset($posted_since)) {
            // 0: last_week   1: yesterday
            if ($posted_since == 0) {
                $project = $project->whereBetween(
                    'created_at',
                    [Carbon::now()->subWeek()->startOfWeek(), Carbon::now()->subWeek()->endOfWeek()]
                );
            }
            if ($posted_since == 1) {
                $project =  $project->whereDate('created_at', Carbon::yesterday());
            }
        }

if (isset($category_id)) {
            $project = $project->where('category_id', $category_id);
        }
        if (isset($id)) {
            if (isset($request->get_simiilar)) {
                $project = $project->where('id', '!=', $id);
            } else {

$project = $project->where('id', $id);
            }
        }

if (isset($request->slug_id)) {

$category = Category::where('slug_id', $request->slug_id)->first();

if ($category) {

$project = $project->where('category_id', $category->id);
            } else {

if (isset($request->get_similar)) {

$project = $project->where('slug_id', '!=', $request->slug_id);
                } else {
                    DB::enableQueryLog();
                    $project = $project->where('slug_id', $request->slug_id);
                }
            }
        }

if (isset($country)) {
            $project = $project->where('country', $country);
        }
        if (isset($state)) {
            $project = $project->where('state', $state);
        }
        if (isset($city) && $city != '') {
            $project = $project->where('city', $city);
        }

if (isset($request->search) && !empty($request->search)) {
            $search = $request->search;

$project = $project->where(function ($query) use ($search) {
                $query->where('title', 'LIKE', "%$search%")->orwhere('address', 'LIKE', "%$search%")->orwhereHas('category', function ($query1) use ($search) {
                    $query1->where('category', 'LIKE', "%$search%");
                });
            });
        }

$total = $project->get()->count();

$result = $project->skip($offset)->take($limit)->get();

if (!$result->isEmpty()) {

$response['error'] = false;
            $response['message'] = "Data Fetch Successfully";

$response['total'] = $total;
            $response['data'] = $result;
        } else {

$response['error'] = false;
            $response['message'] = "No data found!";
            $response['data'] = [];
        }
        return response()->json($response);
    }

public function getUserPersonalisedInterest(Request $request)
    {
        try {
            // Get Current User From Token
            $payload = JWTAuth::getPayload($this->bearerToken($request));
            $current_user = ($payload['customer_id']);

// Get User Interest Data on the basis of current User
            $userInterest = UserInterest::where('user_id', $current_user)->first();

// Get Datas
            $categoriesIds = !empty($userInterest->category_ids) ? explode(',', $userInterest->category_ids) : '';
            $priceRange = $userInterest->property_type != null ? explode(',', $userInterest->price_range) : '';
            $propertyType = $userInterest->property_type == 0 || $userInterest->property_type == 1 ? explode(',', $userInterest->property_type) : '';
            $outdoorFacilitiesIds = !empty($userInterest->outdoor_facilitiy_ids) ? explode(',', $userInterest->outdoor_facilitiy_ids) : '';
            $city = !empty($userInterest->city) ?  $userInterest->city : '';

// Custom Data Array
            $data = array(
                'user_id'               => $current_user,
                'category_ids'          => $categoriesIds,
                'price_range'           => $priceRange,
                'property_type'         => $propertyType,
                'outdoor_facilitiy_ids' => $outdoorFacilitiesIds,
                'city'                  => $city,
            );

$response = array(
                'error' => false,
                'data' => $data,
                'message' => 'Data fetched Successfully'
            );
            return response()->json($response);
        } catch (Exception $e) {
            $response = array(
                'error' => true,
                'message' => 'Something Went Wrong'
            );
            return response()->json($response,500);
        }
    }

public function storeUserPersonalisedInterest(Request $request)
    {
        try{
            DB::beginTransaction();
            // Get Current User From Token
            $payload = JWTAuth::getPayload($this->bearerToken($request));
            $current_user = ($payload['customer_id']);

// Get User Interest
            $userInterest = UserInterest::where('user_id', $current_user)->first();

// If data Exists then update or else insert new data
            if (collect($userInterest)->isNotEmpty()) {
                $response['error'] = false;
                $response['message'] = "Data updated Successfully";
            } else {
                $userInterest = new UserInterest();
                $response['error'] = false;
                $response['message'] = "Data Store Successfully";
            }

// Change the values
            $userInterest->user_id = $current_user;
            $userInterest->category_ids = (isset($request->category_ids) && !empty($request->category_ids)) ? $request->category_ids : "";
            $userInterest->outdoor_facilitiy_ids = (isset($request->outdoor_facilitiy_ids) && !empty($request->outdoor_facilitiy_ids)) ? $request->outdoor_facilitiy_ids : null;
            $userInterest->price_range = (isset($request->price_range) && !empty($request->price_range)) ? $request->price_range : "";
            $userInterest->city = (isset($request->city) && !empty($request->city)) ? $request->city : "";
            $userInterest->property_type = isset($request->property_type) && ($request->property_type == 0 || $request->property_type == 1) ? $request->property_type : "0,1";
            $userInterest->save();

DB::commit();

// Get Datas
            $categoriesIds = !empty($userInterest->category_ids) ? explode(',', $userInterest->category_ids) : '';
            $priceRange = !empty($userInterest->price_range) ? explode(',', $userInterest->price_range) : '';
            $propertyType = explode(',', $userInterest->property_type);
            $outdoorFacilitiesIds = !empty($userInterest->outdoor_facilitiy_ids) ? explode(',', $userInterest->outdoor_facilitiy_ids) : '';
            $city = !empty($userInterest->city) ?  $userInterest->city : '';

// Custom Data Array
            $data = array(
                'user_id'               => $userInterest->user_id,
                'category_ids'          => $categoriesIds,
                'price_range'           => $priceRange,
                'property_type'         => $propertyType,
                'outdoor_facilitiy_ids' => $outdoorFacilitiesIds,
                'city'                  => $city,
            );
            $response['data'] = $data;

return response()->json($response);
        } catch (Exception $e) {
            DB::rollback();
            $response = array(
                'error' => true,
                'message' => 'Something Went Wrong'
            );
            return response()->json($response,500);
        }
    }

public function deleteUserPersonalisedInterest(Request $request)
    {
        try{
            DB::beginTransaction();
            // Get Current User From Token
            $payload = JWTAuth::getPayload($this->bearerToken($request));
            $current_user = ($payload['customer_id']);

// Get User Interest
            UserInterest::where('user_id', $current_user)->delete();
            DB::commit();
            $response = array(
                'error' => false,
                'message' => 'Data Deleted Successfully'
            );
            return response()->json($response);
        } catch (Exception $e) {
            DB::rollback();
            $response = array(
                'error' => true,
                'message' => 'Something Went Wrong'
            );
            return response()->json($response,500);
        }
    }

public function removeAllPackages(Request $request)
    {
        try{
            DB::beginTransaction();

// Get Current User From Token
            $payload = JWTAuth::getPayload($this->bearerToken($request));
            $current_user = ($payload['customer_id']);

// Delete All Packages
            UserPurchasedPackage:: where('modal_id', $current_user)->delete();

// Make subscription and is premium status 0 in customer table
            $customerData = Customer:: find($current_user);
            $customerData->subscription = 0;
            $customerData->is_premium = 0;
            $customerData->save();

DB::commit();
            $response = array(
                'error' => false,
                'message' => 'Data Deleted Successfully'
            );
            return response()->json($response);
        } catch (Exception $e) {
            DB::rollback();
            $response = array(
                'error' => true,
                'message' => 'Something Went Wrong'
            );
            return response()->json($response,500);
        }
    }
}