MAINHACK

Viewing / Editing File: RegionsDataByUser.php

<?php

namespace App\Http\Controllers\Web\traits;

use App\Models\Region;
use Illuminate\Support\Facades\DB;

trait RegionsDataByUser
{
    public function getLocationsData($user)
    {
        $provinces = null;
        $cities = null;
        $districts = null;

$countries = Region::select(DB::raw('*, ST_AsText(geo_center) as geo_center'))
            ->where('type', Region::$country)
            ->get();

if (!empty($user->country_id)) {
            $provinces = Region::select(DB::raw('*, ST_AsText(geo_center) as geo_center'))
                ->where('type', Region::$province)
                ->where('country_id', $user->country_id)
                ->get();
        }

if (!empty($user->province_id)) {
            $cities = Region::select(DB::raw('*, ST_AsText(geo_center) as geo_center'))
                ->where('type', Region::$city)
                ->where('province_id', $user->province_id)
                ->get();
        }

if (!empty($user->city_id)) {
            $districts = Region::select(DB::raw('*, ST_AsText(geo_center) as geo_center'))
                ->where('type', Region::$district)
                ->where('city_id', $user->city_id)
                ->get();
        }

return [
            'countries' => $countries,
            'provinces' => $provinces,
            'cities' => $cities,
            'districts' => $districts,
        ];
    }
}

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: RegionsDataByUser.php

Server Info

System Features

User Info