One Hat Cyber Team

Your IP : 10.30.1.1

Server IP : 103.148.201.5

Server : Linux web-olt 5.15.0-156-generic #166-Ubuntu SMP Sat Aug 9 00:02:46 UTC 2025 x86_64

Server Software : Apache/2.4.52 (Ubuntu)

PHP Version : 8.1.29

Buat File | Buat Folder

Dir : ~/var/www/html/Compro-ISP/app/Http/Controllers/

Edit File: DependantDropdownController.php

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use app\Models\Province;
use App\Models\District;
use App\Models\SubDistrict;
use App\Models\Village; 
use Illuminate\Support\Str;

class DependantDropdownController extends Controller
{
    public function provinces()
    {
//  $provinces = Province::get()
//     ->sortBy(
//         fn ($p) => preg_replace('/[^a-z0-9]+/i', '', Str::lower(trim($p->c_province))),
//         SORT_NATURAL // urut alfabetis natural & case-insensitive
//     )
//     ->values(); 
$provinces = Province::orderByRaw('LOWER(c_province) asc')->get();

//   return response()->json(
//     $provinces->map(fn($p) => ['id' => $p->id, 'text' => $p->c_province])
// );
//   return \Indonesia::allProvinces();
    }

public function district(Request $request)
    {
        // Mengambil kota berdasarkan provinsi
     if (!$request->has('id') || empty($request->id)) {
        return response()->json(['error' => 'Province ID is required'], 400);
    }

try {
        // Ambil kota berdasarkan ID provinsi
        // $province = \Indonesia::findProvince($request->id, ['cities']);
        $items = District::where('ref_reg_province', $request->id)
            ->orderBy('c_district', 'asc')
            ->pluck('c_district', 'id'); // hasil: {"1":"Kab. A", "2":"Kota B", ...}

// Kalau mau 404 ketika kosong:
        // if ($items->isEmpty()) return response()->json(['error' => 'Districts not found'], 404);

return response()->json($items);
    } catch (\Exception $e) {
        // Tangani jika ada kesalahan lain
        return response()->json(['error' => $e->getMessage()], 500);
    }

//   if (!$request->has('id') || empty($request->id)) {
    //     return response()->json(['error' => 'Province ID is required'], 400);
    // }

// try {
    //     // Ambil kota berdasarkan ID provinsi
    //     $province = \Indonesia::findProvince($request->id, ['cities']);

//     // Periksa apakah kota tersedia
    //     if (!$province || !$province->cities) {
    //         return response()->json(['error' => 'Cities not found'], 404);
    //     }

//     return response()->json($province->cities->pluck('name', 'id'));
    // } catch (\Exception $e) {
    //     // Tangani jika ada kesalahan lain
    //     return response()->json(['error' => $e->getMessage()], 500);
    // }
    }

public function subDistrict(Request $request)
    {
       if (!$request->filled('id')) {
        return response()->json(['error' => 'District ID is required'], 400);
    }

$items = SubDistrict::where('ref_reg_district', $request->id)
        ->orderBy('c_sub_district', 'asc') 
        ->pluck('c_sub_district', 'id');
    return response()->json($items);
//  $city = \Indonesia::findCity($request->id, ['districts']);
//         return $city->districts->pluck('name', 'id');
    }

public function villages(Request $request)
    {
       if (!$request->filled('id')) {
        return response()->json(['error' => 'District ID is required'], 400);
    }

$items = Village::where('ref_reg_sub_district', $request->id)
        ->orderBy('c_village', 'asc')      
        ->pluck('c_village', 'id');

return response()->json($items);
//    $district = \Indonesia::findDistrict($request->id, ['villages']);
//         return $district->villages->pluck('name', 'id');
    }

public function postal_code(Request $request)
    {
 if (!$request->filled('id')) {
        return response()->json(['error' => 'Village ID is required'], 400);
    }

// cari village sesuai id
    $village = Village::find($request->id);

if (!$village) {
        return response()->json(['error' => 'Village not found'], 404);
    }

// kembalikan hanya 1 data kodepos
    return response()->json([
        'postal_code' => $village->c_postcode
    ]);
    }
}