fix handle disable button when upload business industries

README.md

@@ -1,66 +1,37 @@
-<p align="center"><a href="https://laravel.com" target="_blank"><img src="https://raw.githubusercontent.com/laravel/art/master/logo-lockup/5%20SVG/2%20CMYK/1%20Full%20Color/laravel-logolockup-cmyk-red.svg" width="400" alt="Laravel Logo"></a></p>
+# Usage icon
 
-<p align="center">
+search or pick icon in <a href="https://icon-sets.iconify.design/mingcute/?keyword=mingcute">here</a>
-<a href="https://github.com/laravel/framework/actions"><img src="https://github.com/laravel/framework/workflows/tests/badge.svg" alt="Build Status"></a>
-<a href="https://packagist.org/packages/laravel/framework"><img src="https://img.shields.io/packagist/dt/laravel/framework" alt="Total Downloads"></a>
-<a href="https://packagist.org/packages/laravel/framework"><img src="https://img.shields.io/packagist/v/laravel/framework" alt="Latest Stable Version"></a>
-<a href="https://packagist.org/packages/laravel/framework"><img src="https://img.shields.io/packagist/l/laravel/framework" alt="License"></a>
-</p>
 
-## About Laravel
+# Set up queue for running automatically
 
-Laravel is a web application framework with expressive, elegant syntax. We believe development must be an enjoyable and creative experience to be truly fulfilling. Laravel takes the pain out of development by easing common tasks used in many web projects, such as:
+-   Install Supervisor
 
-- [Simple, fast routing engine](https://laravel.com/docs/routing).
+```
-- [Powerful dependency injection container](https://laravel.com/docs/container).
+sudo apt update && sudo apt install supervisor -y
-- Multiple back-ends for [session](https://laravel.com/docs/session) and [cache](https://laravel.com/docs/cache) storage.
+```
-- Expressive, intuitive [database ORM](https://laravel.com/docs/eloquent).
-- Database agnostic [schema migrations](https://laravel.com/docs/migrations).
-- [Robust background job processing](https://laravel.com/docs/queues).
-- [Real-time event broadcasting](https://laravel.com/docs/broadcasting).
 
-Laravel is accessible, powerful, and provides tools required for large, robust applications.
+-   Create Supervisor Config
 
-## Learning Laravel
+```
+sudo nano /etc/supervisor/conf.d/laravel-worker.conf
 
-Laravel has the most extensive and thorough [documentation](https://laravel.com/docs) and video tutorial library of all modern web application frameworks, making it a breeze to get started with the framework.
+[program:laravel-worker]
+process_name=%(program_name)s_%(process_num)02d
+command=php /path-to-your-project/artisan queue:work --tries=3 --timeout=600
+autostart=true
+autorestart=true
+numprocs=1
+user=www-data
+redirect_stderr=true
+stdout_logfile=/var/log/supervisor/laravel-worker.log
+```
 
-You may also try the [Laravel Bootcamp](https://bootcamp.laravel.com), where you will be guided through building a modern Laravel application from scratch.
+-   Reload Supervisor
 
-If you don't feel like reading, [Laracasts](https://laracasts.com) can help. Laracasts contains thousands of video tutorials on a range of topics including Laravel, modern PHP, unit testing, and JavaScript. Boost your skills by digging into our comprehensive video library.
+```
-
+sudo supervisorctl reread
-## Laravel Sponsors
+sudo supervisorctl update
-
+sudo supervisorctl start laravel-worker
-We would like to extend our thanks to the following sponsors for funding Laravel development. If you are interested in becoming a sponsor, please visit the [Laravel Partners program](https://partners.laravel.com).
+sudo supervisorctl restart laravel-worker
-
+sudo supervisorctl status
-### Premium Partners
+```
-
-- **[Vehikl](https://vehikl.com/)**
-- **[Tighten Co.](https://tighten.co)**
-- **[WebReinvent](https://webreinvent.com/)**
-- **[Kirschbaum Development Group](https://kirschbaumdevelopment.com)**
-- **[64 Robots](https://64robots.com)**
-- **[Curotec](https://www.curotec.com/services/technologies/laravel/)**
-- **[Cyber-Duck](https://cyber-duck.co.uk)**
-- **[DevSquad](https://devsquad.com/hire-laravel-developers)**
-- **[Jump24](https://jump24.co.uk)**
-- **[Redberry](https://redberry.international/laravel/)**
-- **[Active Logic](https://activelogic.com)**
-- **[byte5](https://byte5.de)**
-- **[OP.GG](https://op.gg)**
-
-## Contributing
-
-Thank you for considering contributing to the Laravel framework! The contribution guide can be found in the [Laravel documentation](https://laravel.com/docs/contributions).
-
-## Code of Conduct
-
-In order to ensure that the Laravel community is welcoming to all, please review and abide by the [Code of Conduct](https://laravel.com/docs/contributions#code-of-conduct).
-
-## Security Vulnerabilities
-
-If you discover a security vulnerability within Laravel, please send an e-mail to Taylor Otwell via [taylor@laravel.com](mailto:taylor@laravel.com). All security vulnerabilities will be promptly addressed.
-
-## License
-
-The Laravel framework is open-sourced software licensed under the [MIT license](https://opensource.org/licenses/MIT).

app/Http/Controllers/Api/AdvertisementController.php

@@ -53,7 +53,7 @@ class AdvertisementController extends Controller
             $advertisement->village_name = $village ? $village->village_name : null;
             
             $district = DB::table('districts')->where('district_code', $advertisement->district_code)->first();
-        $advertisement->district_name = $district ? $district->district_name : null;
+            $advertisement->district_name = $district ? $district->district_name : null;
             return $advertisement;
         });
 
@@ -75,10 +75,10 @@ class AdvertisementController extends Controller
     {
         $data = $request->validated();
 
-        // Cari village_code berdasarkan village_name
-        $village_code = DB::table('villages')->where('village_name', $data['village_name'])->value('village_code');
         // Cari district_code berdasarkan district_name
         $district_code = DB::table('districts')->where('district_name', $data['district_name'])->value('district_code');
+        // Cari village_code berdasarkan village_name
+        $village_code = DB::table('villages')->where('village_name', $data['village_name'])->where('district_code', $district_code)->value('village_code');
 
         // Tambahkan village_code dan district_code ke data
         $data['village_code'] = $village_code;
@@ -142,10 +142,10 @@ class AdvertisementController extends Controller
     {
         $data = $request->validated();
 
-        // Cari village_code berdasarkan village_name
-        $village_code = DB::table('villages')->where('village_name', $data['village_name'])->value('village_code');
         // Cari district_code berdasarkan district_name
         $district_code = DB::table('districts')->where('district_name', $data['district_name'])->value('district_code');
+        // Cari village_code berdasarkan village_name
+        $village_code = DB::table('villages')->where('village_name', $data['village_name'])->where('district_code', $district_code)->value('village_code');
 
         // Tambahkan village_code dan district_code ke data
         $data['village_code'] = $village_code;
@@ -196,4 +196,17 @@ class AdvertisementController extends Controller
 
         return response()->json($results);
     }
+
+    public function downloadExcelAdvertisement()
+    {
+        $filePath = public_path('templates/template_reklame.xlsx');
+
+        // Cek apakah file ada
+        if (!file_exists($filePath)) {
+            return response()-> json(['message' => 'File tidak ditemukan!'], Response::HTTP_NOT_FOUND);
+        }
+
+        // Return file to download
+        return response()->download($filePath);
+    }
 }

app/Http/Controllers/Api/BigDataResumeController.php

@@ -0,0 +1,259 @@
+<?php
+
+namespace App\Http\Controllers\Api;
+
+use App\Http\Controllers\Controller;
+use App\Http\Resources\BigdataResumeResource;
+use App\Models\BigdataResume;
+use App\Models\DataSetting;
+use Illuminate\Http\Request;
+use Illuminate\Support\Facades\Log;
+
+class BigDataResumeController extends Controller
+{
+    /**
+     * Display a listing of the resource.
+     */
+    public function index(Request $request)
+    {
+        try{
+            $filterDate = $request->get("filterByDate");
+
+            // If filterByDate is "latest" or empty, get the most recent record
+            if (!$filterDate || $filterDate === "latest") {
+                $big_data_resume = BigdataResume::latest()->first();
+            } else {
+                // Filter by specific date
+                $big_data_resume = BigdataResume::whereDate('created_at', $filterDate)
+                    ->orderBy('id', 'desc')
+                    ->first();
+
+                if (!$big_data_resume) {
+                    return $this->response_empty_resume();
+                }
+            }
+
+            $data_settings = DataSetting::all();
+            if($data_settings->isEmpty()){
+                return response()->json(['message' => 'No data setting found']);
+            }
+
+            $target_pad = floatval(optional($data_settings->where('key', 'TARGET_PAD')->first())->value);
+            $realisasi_terbit_pbg_sum = floatval(optional($data_settings->where('key', 'REALISASI_TERBIT_PBG_SUM')->first())->value);
+            $realisasi_terbit_pbg_count = floatval(optional($data_settings->where('key', 'REALISASI_TERBIT_PBG_COUNT')->first())->value);
+            $menuggu_klik_dpmptsp_sum = floatval(optional($data_settings->where('key', 'MENUNGGU_KLIK_DPMPTSP_SUM')->first())->value);
+            $menuggu_klik_dpmptsp_count = floatval(optional($data_settings->where('key', 'MENUNGGU_KLIK_DPMPTSP_COUNT')->first())->value);
+            $proses_dinas_teknis_sum = floatval(optional($data_settings->where('key', 'PROSES_DINAS_TEKNIS_SUM')->first())->value);
+            $proses_dinas_teknis_count = floatval(optional($data_settings->where('key', 'PROSES_DINAS_TEKNIS_COUNT')->first())->value);
+            
+            $tata_ruang = $big_data_resume->spatial_sum;
+            $kekurangan_potensi = $target_pad - $big_data_resume->potention_sum;
+
+            // percentage kekurangan potensi
+            $kekurangan_potensi_percentage = $target_pad > 0 && $target_pad > 0 
+            ? round(($kekurangan_potensi / $target_pad) * 100, 2) : 0;
+
+            // percentage total potensi
+            $total_potensi_percentage = $big_data_resume->potention_sum > 0 && $target_pad > 0 
+            ? round(($big_data_resume->potention_sum / $target_pad) * 100, 2) : 0;
+            
+            // percentage verified document
+            $verified_percentage = $big_data_resume->verified_sum > 0 && $big_data_resume->potention_sum > 0 
+            ? round(($big_data_resume->verified_sum / $big_data_resume->potention_sum) * 100, 2) : 0;
+
+            // percentage non-verified document
+            $non_verified_percentage = $big_data_resume->non_verified_sum > 0 && $big_data_resume->potention_sum > 0 
+            ? round(($big_data_resume->non_verified_sum / $big_data_resume->potention_sum) * 100, 2) : 0;
+
+            // percentage business document
+            $business_percentage = $big_data_resume->business_sum > 0 && $big_data_resume->non_verified_sum > 0 
+            ? round(($big_data_resume->business_sum / $big_data_resume->non_verified_sum) * 100, 2) : 0;
+
+            // percentage non-business document
+            $non_business_percentage = $big_data_resume->non_business_sum > 0 && $big_data_resume->potention_sum > 0 
+            ? round(($big_data_resume->non_business_sum / $big_data_resume->potention_sum) * 100, 2) : 0;
+
+            // percentage tata ruang
+            $tata_ruang_percentage = $tata_ruang > 0 && $big_data_resume->potention_sum > 0 
+            ? round(($tata_ruang / $big_data_resume->potention_sum) * 100, 2) : 0;
+
+            // percentage realisasi terbit pbg
+            $realisasi_terbit_percentage = $big_data_resume->verified_sum > 0 && $realisasi_terbit_pbg_sum > 0
+            ? round(($realisasi_terbit_pbg_sum / $big_data_resume->verified_sum) * 100, 2) : 0;
+
+            // percentage menunggu klik dpmptsp
+            $menunggu_klik_dpmptsp_percentage = $big_data_resume->verified_sum > 0 && $menuggu_klik_dpmptsp_sum > 0
+            ? round(($menuggu_klik_dpmptsp_sum / $big_data_resume->verified_sum) * 100, 2) : 0;
+
+            // percentage proses_dinas_teknis
+            $proses_dinas_teknis_percentage = $big_data_resume->verified_sum > 0 && $proses_dinas_teknis_sum > 0
+            ? round(($proses_dinas_teknis_sum / $big_data_resume->verified_sum) * 100, 2) : 0;
+
+            $result = [
+                'target_pad' => [
+                    'sum' => $target_pad,
+                    'percentage' => 100,
+                ],
+                'tata_ruang' => [
+                    'sum' => $big_data_resume->spatial_sum,
+                    'count' => $big_data_resume->spatial_count,
+                    'percentage' => $tata_ruang_percentage,
+                ],
+                'kekurangan_potensi' => [
+                    'sum' => $kekurangan_potensi,
+                    'percentage' => $kekurangan_potensi_percentage
+                ],
+                'total_potensi' => [
+                    'sum' => (float) $big_data_resume->potention_sum,
+                    'count' => $big_data_resume->potention_count,
+                    'percentage' => $total_potensi_percentage
+                ],
+                'verified_document' => [
+                    'sum' => (float) $big_data_resume->verified_sum,
+                    'count' => $big_data_resume->verified_count,
+                    'percentage' => $verified_percentage
+                ],
+                'non_verified_document' => [
+                    'sum' => (float) $big_data_resume->non_verified_sum,
+                    'count' => $big_data_resume->non_verified_count,
+                    'percentage' => $non_verified_percentage
+                ],
+                'business_document' => [
+                    'sum' => (float) $big_data_resume->business_sum,
+                    'count' => $big_data_resume->business_count,
+                    'percentage' => $business_percentage
+                ],
+                'non_business_document' => [
+                    'sum' => (float) $big_data_resume->non_business_sum,
+                    'count' => $big_data_resume->non_business_count,
+                    'percentage' => $non_business_percentage
+                ],
+                'realisasi_terbit' => [
+                    'sum' => $realisasi_terbit_pbg_sum,
+                    'count' => $realisasi_terbit_pbg_count,
+                    'percentage' => $realisasi_terbit_percentage
+                ],
+                'menunggu_klik_dpmptsp' => [
+                    'sum' => $menuggu_klik_dpmptsp_sum,
+                    'count' => $menuggu_klik_dpmptsp_count,
+                    'percentage' => $menunggu_klik_dpmptsp_percentage
+                ],
+                'proses_dinas_teknis' => [
+                    'sum' => $proses_dinas_teknis_sum,
+                    'count' => $proses_dinas_teknis_count,
+                    'percentage' => $proses_dinas_teknis_percentage
+                ]
+            ];
+            return response()->json($result);
+        }catch(\Exception $e){
+            return response()->json(['message' => 'Error when fetching data'], 500);
+        }
+    }
+
+    public function bigdata_report(Request $request){
+        try{
+            $query = BigdataResume::query()->orderBy('id', 'desc');
+        
+            if($request->filled('search')){
+                $query->where('name', 'LIKE', '%'.$request->input('search').'%');
+            }
+
+            $query = $query->paginate(15);
+            return  BigdataResumeResource::collection($query)->response()->getData(true);
+        }catch(\Exception $e){
+            Log::error($e->getMessage());
+            return response()->json(['message' => 'Error when fetching data'], 500);
+        }
+    }
+
+    /**
+     * Store a newly created resource in storage.
+     */
+    public function store(Request $request)
+    {
+        //
+    }
+
+    /**
+     * Display the specified resource.
+     */
+    public function show(string $id)
+    {
+        //
+    }
+
+    /**
+     * Update the specified resource in storage.
+     */
+    public function update(Request $request, string $id)
+    {
+        //
+    }
+
+    /**
+     * Remove the specified resource from storage.
+     */
+    public function destroy(string $id)
+    {
+        //
+    }
+
+    private function response_empty_resume(){
+        $result = [
+            'target_pad' => [
+                'sum' => 0,
+                'percentage' => 100,
+            ],
+            'tata_ruang' => [
+                'sum' => 0,
+                'percentage' => 0,
+            ],
+            'kekurangan_potensi' => [
+                'sum' => 0,
+                'percentage' => 0
+            ],
+            'total_potensi' => [
+                'sum' => 0,
+                'count' => 0,
+                'percentage' => 0
+            ],
+            'verified_document' => [
+                'sum' => 0,
+                'count' => 0,
+                'percentage' => 0
+            ],
+            'non_verified_document' => [
+                'sum' => 0,
+                'count' => 0,
+                'percentage' => 0
+            ],
+            'business_document' => [
+                'sum' => 0,
+                'count' => 0,
+                'percentage' => 0
+            ],
+            'non_business_document' => [
+                'sum' => 0,
+                'count' => 0,
+                'percentage' => 0
+            ],
+            'realisasi_terbit' => [
+                'sum' => 0,
+                'count' => 0,
+                'percentage' => 0
+            ],
+            'menunggu_klik_dpmptsp' => [
+                'sum' => 0,
+                'count' => 0,
+                'percentage' => 0
+            ],
+            'proses_dinas_teknis' => [
+                'sum' => 0,
+                'count' => 0,
+                'percentage' => 0
+            ]
+        ];
+
+        return response()->json($result);
+    }
+}

app/Http/Controllers/Api/BusinessOrIndustriesController.php

@@ -0,0 +1,107 @@
+<?php
+
+namespace App\Http\Controllers\Api;
+
+use App\Http\Controllers\Controller;
+use App\Http\Requests\BusinessIndustryRequest;
+use App\Imports\BusinessIndustriesImport;
+use App\Models\BusinessOrIndustry;
+use Illuminate\Http\Request;
+use Maatwebsite\Excel\Facades\Excel;
+use \Illuminate\Support\Facades\Validator;
+use App\Http\Requests\ExcelUploadRequest;
+class BusinessOrIndustriesController extends Controller
+{
+    /**
+     * Display a listing of the resource.
+     */
+    public function index(Request $request)
+    {
+        $query = BusinessOrIndustry::query()->orderBy('id', 'desc');
+
+        if ($request->has("search") && !empty($request->get("search"))) {
+            $search = $request->get("search");
+
+            info($request); // Debugging log
+
+            $query->where(function ($q) use ($search) {
+                $q->where("nop", "LIKE", "%{$search}%")
+                ->orWhere("nama_kecamatan", "LIKE", "%{$search}%")
+                ->orWhere("nama_kelurahan", "LIKE", "%{$search}%");
+            });
+        }
+
+        return response()->json($query->paginate());
+    }
+
+    /**
+     * Store a newly created resource in storage.
+     */
+    public function store(Request $request)
+    {
+        //
+    }
+
+    /**
+     * Display the specified resource.
+     */
+    public function show(string $id)
+    {
+        //
+    }
+
+    /**
+     * Update the specified resource in storage.
+     */
+    public function update(BusinessIndustryRequest $request, string $id)
+    {
+        try{
+            $data = BusinessOrIndustry::findOrFail($id);
+            $data->update($request->validated());
+            return response()->json(['message' => 'Data updated successfully.'], 200);
+        }catch(\Exception $e){
+            \Log::error($e->getMessage());
+            return response()->json(['message' => 'Failed to update data'],500);
+        }
+    }
+
+    /**
+     * Remove the specified resource from storage.
+     */
+    public function destroy(string $id)
+    {
+        try{
+            $data = BusinessOrIndustry::findOrFail($id);
+            $data->delete();
+            return response()->json(['message' => 'Data deleted successfully.'], 200);
+        }catch(\Exception $e){
+            \Log::error($e->getMessage());
+            return response()->json(['message' => 'Failed to delete data'],500);
+        }
+    }
+
+    public function upload(ExcelUploadRequest $request){
+        try {
+            if(!$request->hasFile('file')){
+                return response()->json([
+                   'error' => 'No file provided'
+                ], 400);
+            }
+
+            $file = $request->file('file');
+            Excel::import(new BusinessIndustriesImport, $file);
+
+            // Jika sukses, kembalikan respons sukses
+            return response()->json([
+                'message' => 'File uploaded and imported successfully!'
+            ], 200);
+        } catch (\Exception $e) {
+            // Jika ada error, kembalikan error response
+            return response()->json([
+                'message' => 'Error during file import.',
+                'error' => $e->getMessage()
+            ], 500);
+        }
+
+    }
+}

app/Http/Controllers/Api/CustomersController.php

@@ -0,0 +1,130 @@
+<?php
+
+namespace App\Http\Controllers\Api;
+
+use App\Http\Controllers\Controller;
+use App\Http\Requests\CustomersRequest;
+use App\Http\Requests\ExcelUploadRequest;
+use App\Http\Resources\CustomersResource;
+use App\Imports\CustomersImport;
+use App\Models\Customer;
+use Illuminate\Http\Request;
+use Maatwebsite\Excel\Facades\Excel;
+
+class CustomersController extends Controller
+{
+    /**
+     * Display a listing of the resource.
+     */
+    public function index(Request $request)
+    {
+        $query = Customer::query()->orderBy('id', 'desc');
+        if ($request->has('search') &&!empty($request->get('search'))) {
+            $query = $query->where('nomor_pelanggan', 'LIKE', '%'.$request->get('search').'%')
+                ->orWhere('nama', 'LIKE', '%'.$request->get('search').'%')
+                ->orWhere('kota_pelayanan', 'LIKE', '%'.$request->get('search').'%');
+        }
+        return CustomersResource::collection($query->paginate());
+    }
+
+    /**
+     * Store a newly created resource in storage.
+     */
+    public function store(CustomersRequest $request)
+    {
+        try{
+            $customer = Customer::create($request->validated());
+            return response()->json(['message' => 'Successfully created', new CustomersResource($customer)]);
+        }catch(\Exception $e){
+            return response()->json([
+                'message' => 'Failed to create customer',
+                'error' => $e->getMessage()
+            ], 500);
+        }
+    }
+
+    /**
+     * Display the specified resource.
+     */
+    public function show(string $id)
+    {
+        try{
+            $customer = Customer::find($id);
+            if($customer){
+                return new CustomersResource($customer);
+            } else {
+                return response()->json(['message' => 'Customer not found'], 404);
+            }
+        }catch(\Exception $e){
+            return response()->json([
+                'message' => 'Failed to retrieve customer',
+                'error' => $e->getMessage()
+            ], 500);
+        }
+    }
+
+    /**
+     * Update the specified resource in storage.
+     */
+    public function update(CustomersRequest $request, string $id)
+    {
+        try{
+            $customer = Customer::find($id);
+            if($customer){
+                $customer->update($request->validated());
+                return response()->json(['message' => 'Successfully updated', new CustomersResource($customer)]);
+            } else {
+                return response()->json(['message' => 'Customer not found'], 404);
+            }
+        }catch(\Exception $e) {
+            return response()->json([
+                'message' => 'Failed to update customer',
+                'error' => $e->getMessage()
+            ], 500);
+        }
+    }
+
+    /**
+     * Remove the specified resource from storage.
+     */
+    public function destroy(string $id)
+    {
+        try{
+            $customer = Customer::find($id);
+            if($customer){
+                $customer->delete();
+                return response()->json(['message' => 'Successfully deleted']);
+            }else {
+                return response()->json(['message' => 'Customer not found'], 404);
+            }
+        }catch(\Exception $e) {
+            return response()->json([
+                'message' => 'Failed to delete customer',
+                'error' => $e->getMessage()
+            ], 500);
+        }
+    }
+
+    public function upload(ExcelUploadRequest $request){
+        try{
+            if(!$request->hasFile('file')){
+                return response()->json([
+                   'error' => 'No file provided'
+                ], 400);
+            }
+
+            $file = $request->file('file');
+            Excel::import(new CustomersImport, $file);
+
+            return response()->json([
+                'message' => 'File uploaded successfully',
+            ]);
+        }catch(\Exception $e){
+            \Log::info($e->getMessage());
+            return response()->json([
+                'error' => 'Failed to upload file',
+               'message' => $e->getMessage()
+            ], 500);
+        }
+    }
+}

app/Http/Controllers/Api/LackOfPotentialController.php

@@ -0,0 +1,31 @@
+<?php
+
+namespace App\Http\Controllers\Api;
+
+use App\Http\Controllers\Controller;
+use App\Models\Advertisement;
+use App\Models\Customer;
+use App\Models\SpatialPlanning;
+use Illuminate\Http\Request;
+
+class LackOfPotentialController extends Controller
+{
+
+    public function count_lack_of_potential(){
+        try{
+            $total_reklame = Advertisement::count();
+            $total_pdam = Customer::count();
+            $total_tata_ruang = SpatialPlanning::count();
+
+            return response()->json([
+                'total_reklame' => $total_reklame,
+                'total_pdam' => $total_pdam,
+                'total_tata_ruang' => $total_tata_ruang
+            ], 200);
+        }catch(\Exception $e){
+            return response()->json([
+                'message' => 'Error: '.$e->getMessage()
+            ], 500);
+        }
+    }
+}

app/Http/Controllers/Api/MenusController.php

@@ -3,8 +3,11 @@
 namespace App\Http\Controllers\Api;
 
 use App\Http\Controllers\Controller;
+use App\Http\Requests\MenuRequest;
+use App\Http\Resources\MenuResource;
 use App\Models\Menu;
 use Illuminate\Http\Request;
+use Illuminate\Support\Facades\Log;
 
 class MenusController extends Controller
 {
@@ -13,7 +16,7 @@ class MenusController extends Controller
      */
     public function index(Request $request)
     {
-        $query = Menu::query();
+        $query = Menu::query()->orderBy('id', 'desc');
 
         if($request->has("search") && !empty($request->get("search"))){
             $query = $query->where("name", "like", "%".$request->get("search")."%");
@@ -25,9 +28,15 @@ class MenusController extends Controller
     /**
      * Store a newly created resource in storage.
      */
-    public function store(Request $request)
+    public function store(MenuRequest $request)
     {
-        //
+        try{
+            $menu = Menu::create($request->validated());
+            return response()->json(['message' => 'Menu created successfully', 'data' => new MenuResource($menu)]);
+        }catch(\Exception $e){
+            Log::error($e);
+            return response()->json(['message' => 'Error when creating menu'], 500);
+        }
     }
 
     /**
@@ -35,15 +44,37 @@ class MenusController extends Controller
      */
     public function show(string $id)
     {
-        //
+        try{
+            $menu = Menu::find($id);
+            if($menu){
+                return response()->json(['message' => 'Menu found', 'data' => new MenuResource($menu)]);
+            } else {
+                return response()->json(['message' => 'Menu not found'], 404);
+            }
+        }catch(\Exception $e){
+            Log::error($e);
+            Log::error($e->getMessage());
+            return response()->json(['message' => 'Error when finding menu'], 500);
+        }
     }
 
     /**
      * Update the specified resource in storage.
      */
-    public function update(Request $request, string $id)
+    public function update(MenuRequest $request, string $id)
     {
-        //
+        try{
+            $menu = Menu::findOrFail($id);
+            if($menu){
+                $menu->update($request->validated());
+                return response()->json(['message' => 'Menu updated successfully', 'data' => new MenuResource($menu)]);
+            } else {
+                return response()->json(['message' => 'Menu not found'], 404);
+            }
+        }catch(\Exception $e){
+            Log::error($e);
+            return response()->json(['message' => 'Error when updating menu'], 500);
+        }
     }
 
     /**
@@ -51,6 +82,28 @@ class MenusController extends Controller
      */
     public function destroy(string $id)
     {
-        //
+        try{
+            $menu = Menu::findOrFail($id);
+            if($menu){
+                $this->deleteChildren($menu);
+                $menu->roles()->detach();
+                $menu->delete();
+                return response()->json(['message' => 'Menu deleted successfully']);
+            } else {
+                return response()->json(['message' => 'Menu not found'], 404);
+            }
+        }catch(\Exception $e){
+            Log::error($e);
+            return response()->json(['message' => 'Error when deleting menu'], 500);
+        }
+    }
+
+    private function deleteChildren($menu)
+    {
+        foreach ($menu->children as $child) {
+            $this->deleteChildren($child); // Recursively delete its children
+            $child->roles()->detach(); // Detach roles before deleting
+            $child->delete();
+        }
     }
 }

app/Http/Controllers/Api/PbgTaskController.php

@@ -6,6 +6,7 @@ use App\Enums\ImportDatasourceStatus;
 use App\Http\Controllers\Controller;
 use App\Http\Requests\PbgTaskMultiStepRequest;
 use App\Http\Resources\PbgTaskResource;
+use App\Models\DataSetting;
 use App\Models\ImportDatasource;
 use App\Models\PbgTask;
 use App\Models\PbgTaskGoogleSheet;
@@ -20,9 +21,35 @@ class PbgTaskController extends Controller
     public function __construct(GoogleSheetService $googleSheetService){
         $this->googleSheetService = $googleSheetService;
     }
-    public function index()
+    public function index(Request $request)
     {
-        //
+        info($request);
+        
+        $isLastUpdated = filter_var($request->query('isLastUpdated', false), FILTER_VALIDATE_BOOLEAN);
+
+        $query = PbgTask::query();
+
+        if ($isLastUpdated) {
+            $query->orderBy('updated_at', 'desc');
+        } else {
+            $query->where('status', 20);
+        }
+
+        // Ambil maksimal 10 data
+        $pbg_task = $query->limit(10)->get();
+        $totalData = $pbg_task->count();
+
+        // Tambahkan nomor urut
+        $data = $pbg_task->map(function ($item, $index) {
+            return array_merge($item->toArray(), ['no' => $index + 1]);
+        });
+
+        return response()->json([
+            'data' => $data,
+            'meta' => [
+                'total' => $totalData
+            ]
+        ]);
     }
 
     /**
@@ -109,18 +136,55 @@ class PbgTaskController extends Controller
     }
 
     public function syncPbgFromGoogleSheet(){
+        $import_datasource = ImportDatasource::create([
+            "message" => "initialization",
+            "response_body" => null,
+            "status" => ImportDatasourceStatus::Processing->value,
+        ]);
         try{
             $totalRowCount = $this->googleSheetService->getLastRowByColumn("C");
             $sheetData = $this->googleSheetService->getSheetDataCollection($totalRowCount);
+            $sheet_big_data = $this->googleSheetService->get_data_by_sheet();
+            $data_setting_result = []; // Initialize result storage
+        
+            $found_section = null; // Track which section is found
+        
+            foreach ($sheet_big_data as $row) {
+                // Check for section headers
+                if (in_array("•PROSES PENERBITAN:", $row)) {
+                    $found_section = "MENUNGGU_KLIK_DPMPTSP";
+                } elseif (in_array("•BERKAS AKTUAL TERVERIFIKASI DINAS TEKNIS 2024:", $row)) {
+                    $found_section = "REALISASI_TERBIT_PBG";
+                } elseif (in_array("•TERPROSES DI DPUTR: belum selesai rekomtek'", $row)) {
+                    $found_section = "PROSES_DINAS_TEKNIS";
+                }
+        
+                // If a section is found and we reach "Grand Total", save the corresponding values
+                if ($found_section && isset($row[0]) && trim($row[0]) === "Grand Total") {
+                    if ($found_section === "MENUNGGU_KLIK_DPMPTSP") {
+                        $data_setting_result["MENUNGGU_KLIK_DPMPTSP_COUNT"] = $row[2] ?? null;
+                        $data_setting_result["MENUNGGU_KLIK_DPMPTSP_SUM"] = $row[3] ?? null;
+                    } elseif ($found_section === "REALISASI_TERBIT_PBG") {
+                        $data_setting_result["REALISASI_TERBIT_PBG_COUNT"] = $row[2] ?? null;
+                        $data_setting_result["REALISASI_TERBIT_PBG_SUM"] = $row[4] ?? null;
+                    } elseif ($found_section === "PROSES_DINAS_TEKNIS") {
+                        $data_setting_result["PROSES_DINAS_TEKNIS_COUNT"] = $row[2] ?? null;
+                        $data_setting_result["PROSES_DINAS_TEKNIS_SUM"] = $row[3] ?? null;
+                    }
+        
+                    // Reset section tracking after capturing "Grand Total"
+                    $found_section = null;
+                }
+            }
+            foreach ($data_setting_result as $key => $value) {
+                DataSetting::updateOrInsert(
+                    ["key" => $key], // Find by key
+                    ["value" => $value] // Update or insert value
+                );
+            }
             $mapToUpsert = [];
             $count = 0;
 
-            $import_datasource = ImportDatasource::create([
-                "message" => "initialization",
-                "response_body" => null,
-                "status" => ImportDatasourceStatus::Processing->value,
-            ]);
-
             foreach($sheetData as $data){
                 $mapToUpsert[] = 
                     [

app/Http/Controllers/Api/RolesController.php

@@ -3,6 +3,7 @@
 namespace App\Http\Controllers\Api;
 
 use App\Http\Controllers\Controller;
+use App\Http\Requests\RoleRequest;
 use App\Models\Role;
 use Illuminate\Http\Request;
 
@@ -13,7 +14,7 @@ class RolesController extends Controller
      */
     public function index(Request $request)
     {
-        $query = Role::query();
+        $query = Role::query()->orderBy('id', 'desc');
 
         if($request->has('search') && !empty($request->get('search'))){
             $query = $query->where('name', 'like', '%'. $request->get('search') . '%');
@@ -25,9 +26,14 @@ class RolesController extends Controller
     /**
      * Store a newly created resource in storage.
      */
-    public function store(Request $request)
+    public function store(RoleRequest $request)
     {
-        //
+        try{
+            $role = Role::create($request->validated());
+            return response()->json(['message' => 'Successfully created', 'data' => $role]);
+        }catch(\Exception $e){
+            return response()->json(['message' => 'Error when creating role', 'error' => $e->getMessage()], 500);
+        }
     }
 
     /**
@@ -35,15 +41,34 @@ class RolesController extends Controller
      */
     public function show(string $id)
     {
-        //
+        try{
+            $role = Role::find($id);
+            if($role){
+                return response()->json(['data' => $role]);
+            } else {
+                return response()->json(['message' => 'Role not found'], 404);
+            }
+        }catch(\Exception $e){
+            return response()->json(['message' => 'Error when getting role', 'error' => $e->getMessage()], 500);
+        }
     }
 
     /**
      * Update the specified resource in storage.
      */
-    public function update(Request $request, string $id)
+    public function update(RoleRequest $request, string $id)
     {
-        //
+        try{
+            $role = Role::find($id);
+            if($role){
+                $role->update($request->validated());
+                return response()->json(['message' => 'Successfully updated', 'data' => $role]);
+            } else {
+                return response()->json(['message' => 'Role not found'], 404);
+            }
+        }catch(\Exception $e){
+            return response()->json(['message' => 'Error when updating role', 'error' => $e->getMessage()], 500);
+        }
     }
 
     /**
@@ -51,6 +76,16 @@ class RolesController extends Controller
      */
     public function destroy(string $id)
     {
-        //
+        try{
+            $role = Role::find($id);
+            if($role){
+                $role->delete();
+                return response()->json(['message' => 'Successfully deleted']);
+            } else {
+                return response()->json(['message' => 'Role not found'], 404);
+            }
+        }catch(\Exception $e){
+            return response()->json(['message' => 'Error when deleting role', 'error' => $e->getMessage()], 500);
+        }
     }
 }

app/Http/Controllers/Api/SpatialPlanningController.php

@@ -0,0 +1,146 @@
+<?php
+
+namespace App\Http\Controllers\Api;
+
+use App\Models\SpatialPlanning;
+use Illuminate\Http\Request;
+use App\Http\Requests\SpatialPlanningRequest;
+use Illuminate\Http\Response;
+use App\Http\Controllers\Controller;
+use App\Http\Resources\SpatialPlanningResource;
+use Illuminate\Support\Facades\DB;
+use Illuminate\Support\Facades\Validator;
+use Maatwebsite\Excel\Facades\Excel;
+use App\Imports\SpatialPlanningImport;
+use Illuminate\Support\Facades\Storage;
+
+class SpatialPlanningController extends Controller
+{
+    /**
+     * Display a listing of the resource.
+     */
+    public function index(Request $request)
+    {
+        info($request);
+        $perPage = $request->input('per_page', 15);
+        $search = $request->input('search', '');
+
+        $query = SpatialPlanning::query();
+        if ($search) {
+            $query->where(function ($q) use ($search) {
+                $q->where('name', 'like', "%$search%")
+                    ->orWhere('kbli', 'like', "%$search%")
+                    ->orWhere('activities', 'like', "%$search%")
+                    ->orWhere('area', 'like', "%$search%")
+                    ->orWhere('location', 'like', "%$search%")
+                    ->orWhere('number', 'like', "%$search%");
+            });
+        }
+                
+        $spatialPlannings = $query->paginate($perPage);
+
+        // Menambhakan nomor urut (No)
+        $start = ($spatialPlannings->currentPage()-1) * $perPage + 1;
+
+        // Tambahkan nomor urut ke dalam data
+        $data = $spatialPlannings->map(function ($item, $index) use ($start) {
+            return array_merge($item->toArray(), ['no' => $start + $index]);
+        });
+
+        info($data);
+
+        return response()->json([
+            'data' => $data,
+            'meta' => [
+                'total' => $spatialPlannings->total(),
+                'per_page' => $spatialPlannings->perPage(),
+                'current_page' => $spatialPlannings->currentPage(),
+                'last_page'=>$spatialPlannings->lastPage(),
+            ]
+        ]);
+    }
+
+    /**
+     * Store a newly created resource in storage.
+     */
+    public function store(SpatialPlanningRequest $request): SpatialPlanning
+    {
+        $data = $request->validated();
+        return SpatialPlanning::create($data);
+    }
+    
+    /**
+     * import spatial planning from excel
+     */
+    public function importFromFile(Request $request)
+    {
+        info($request);
+        //validasi file
+        $validator = Validator::make($request->all(), [
+            'file' => 'required|mimes:xlsx, xls|max:10240'
+        ]);
+
+        if ($validator->fails()) {
+            return response()->json([
+                'message'=>'File vaildation failed.',
+                "errors"=>$validator->errors()
+            ], 400);
+        }
+
+        try {
+            $file = $request->file('file');
+            Excel::import(new SpatialPlanningImport, $file);
+            return response()->json([
+                'message'=>'File uploaded and imported successfully!'
+            ], 200);
+        } catch (\Exception $e) {
+            return response()->json([
+                'message'=>'Error during file import.',
+                'error'=>$e->getMessage()
+            ], 500);
+        }
+    }
+
+    /**
+     * Display the specified resource.
+     */
+    public function show(SpatialPlanning $spatialPlanning): SpatialPlanning
+    {
+        return $spatialPlanning;
+    }
+
+    /**
+     * Update the specified resource in storage.
+     */
+    public function update(SpatialPlanningRequest $request, SpatialPlanning $spatialPlanning): SpatialPlanning
+    {
+        info($request);
+        $data = $request->validated();
+        info($data);
+
+        $spatialPlanning->update($data);
+
+        return $spatialPlanning;
+    }
+
+    public function destroy(SpatialPlanning $spatialPlanning): Response
+    {
+        $spatialPlanning->delete();
+
+        return response()->noContent();
+    }
+
+    public function downloadExcelSpatialPlanning()
+    {
+        $filePath = public_path('templates/template_spatial_planning.xlsx');
+        info(sprintf("File Path: %s | Exists: %s", $filePath, file_exists($filePath) ? 'Yes' : 'No'));
+
+        // Cek apakah file ada
+        if (!file_exists($filePath)) {
+            return response()-> json(['message' => 'File tidak ditemukan!'], Response::HTTP_NOT_FOUND);
+        }
+
+        // Return file to download
+        return response()->download($filePath);
+    }
+}

app/Http/Controllers/Api/TourismController.php

@@ -0,0 +1,169 @@
+<?php
+
+namespace App\Http\Controllers\Api;
+
+use App\Models\Tourism;
+use Illuminate\Http\Request;
+use App\Http\Requests\TourismRequest;
+use Illuminate\Http\Response;
+use App\Http\Controllers\Controller;
+use App\Http\Resources\TourismResource;
+use Illuminate\Support\Facades\DB;
+use Illuminate\Support\Facades\Validator;
+use Maatwebsite\Excel\Facades\Excel;
+use App\Imports\TourismImport;
+use Illuminate\Support\Facades\Storage;
+
+class TourismController extends Controller
+{
+    /**
+     * Display a listing of the resource.
+     */
+    public function index(Request $request)
+    {
+        $perPage = $request->input('per_page', 15);
+        $search = $request->input('search', '');
+
+        $query = Tourism::query();
+        if ($search) {
+            $query->where(function ($q) use ($search) {
+                $q->where('business_name', 'like', "%$search%")
+                    ->orWhere('project_name', 'like', "%$search%")
+                    ->orWhere('business_address', 'like', "%$search%");
+            });
+        }
+        $tourisms = $query->paginate($perPage);
+
+        $tourisms->getCollection()->transform(function ($tourisms) {
+            $village = DB::table('villages')->where('village_code', $tourisms->village_code)->first();
+            $tourisms->village_name = $village ? $village->village_name : null;
+
+            $district = DB::table('districts')->where('district_code', $tourisms->district_code)->first();
+            $tourisms->district_name = $village ? $village->village_name : null;
+            return $tourisms;
+        });
+
+        $start = ($tourisms->currentPage()-1) * $perPage + 1;
+
+        $data = $tourisms->map(function ($item, $index) use ($start) {
+            return array_merge($item->toArray(), ['no' => $start + $index]);
+        });
+
+        return response()->json([
+            'data' => $data,
+            'meta' => [
+                'total' => $tourisms->total(),
+                'per_page' => $tourisms->perPage(),
+                'current_page' => $tourisms->currentPage(),
+                'last_page'=>$tourisms->lastPage(),
+            ]
+        ]);
+    }
+
+    /**
+     * Store a newly created resource in storage.
+     */
+    public function store(TourismRequest $request): Tourism
+    {
+        $data = $request->validated();
+        $district_code = DB::table('districts')->where('district_name', $data['district_name'])->value('district_code');
+        $village_code = DB::table('villages')->where('village_name', $data['village_name'])->where('district_code', $district_code)->value('village_code');
+
+        $data['district_code'] = $district_code;
+        $data['village_code'] = $village_code;
+
+        return Tourism::create($data);
+    }
+
+    /**
+     * Import advertisements from Excel
+     */
+    public function importFromFile(Request $request)
+    {
+        //Validasi file
+        $validator = Validator::make($request->all(), [
+            'file' => 'required|mimes:xlsx, xls|max:10240'
+        ]);
+
+        if ($validator->fails()) {
+            return response()->json([
+                'message'=>'File validation failed.',
+                'errors'=>$validator->errors()
+            ], 400);
+        }
+
+        try {
+            $file = $request->file('file');
+            Excel::import(new TourismImport, $file);
+            return response()->json([
+                'message'=>'File uploaded and imported successfully!'
+            ], 200);
+        } catch (\Exception $e) {
+            return response()->json([
+                'message'=>'Error during file import.',
+                'error'=>$e->getMessage()
+            ], 500);
+        }
+    }
+
+    public function getAllLocation()
+    {
+        $locations = Tourism::whereNotNull('longitude')
+                    ->whereNotNull('latitude')
+                    ->select('project_name', 'longitude', 'latitude')
+                    ->get();
+
+        return response()->json([
+            'data' => $locations
+        ]);
+    }
+
+    /**
+     * Display the specified resource.
+     */
+    public function show(Tourism $tourism): Tourism
+    {
+        return $tourism;
+    }
+
+    /**
+     * Update the specified resource in storage.
+     */
+    public function update(TourismRequest $request, Tourism $tourism): Tourism
+    {
+        $data = $request->validated();
+
+        // Cari district_code berdasarkan district_name
+        $district_code = DB::table('districts')->where('district_name', $data['district_name'])->value('district_code');
+        // Cari village_code berdasarkan village_name
+        $village_code = DB::table('villages')->where('village_name', $data['village_name'])->where('district_code', $district_code)->value('village_code');
+        // Tambahkan village_code dan district_code ke data
+        $data['village_code'] = $village_code;
+        $data['district_code'] = $district_code;
+
+        $tourism->update($data);
+
+        return $tourism;
+    }
+
+    public function destroy(Tourism $tourism): Response
+    {
+        $tourism->delete();
+
+        return response()->noContent();
+    }
+
+    public function downloadExcelTourism()
+    {
+        $filePath = public_path('templates/template_pariwisata.xlsx');
+        info(sprintf("File Path: %s | Exists: %s", $filePath, file_exists($filePath) ? 'Yes' : 'No'));
+
+        // Cek apakah file ada
+        if (!file_exists($filePath)) {
+            return response()-> json(['message' => 'File tidak ditemukan!'], Response::HTTP_NOT_FOUND);
+        }
+
+        // Return file to download
+        return response()->download($filePath);
+    }
+}

app/Http/Controllers/Api/UmkmController.php

@@ -0,0 +1,206 @@
+<?php
+
+namespace App\Http\Controllers\Api;
+
+use App\Models\Umkm;
+use Illuminate\Http\Request;
+use App\Http\Requests\UmkmRequest;
+use Illuminate\Http\Response;
+use App\Http\Controllers\Controller;
+use App\Http\Resources\UmkmResource;
+use Illuminate\Support\Facades\DB;
+use Illuminate\Support\Facades\Validator;
+use Maatwebsite\Excel\Facades\Excel;
+use App\Imports\UmkmImport;
+use Illuminate\Support\Facades\Storage;
+
+class UmkmController extends Controller
+{
+    /**
+     * Display a listing of the resource.
+     */
+    public function index(Request $request)
+    {
+        info($request);
+        $perPage = $request->input('per_page', 15);
+        $search = $request->input('search', '');
+
+        $query = Umkm::query();
+
+        if ($search) {
+            $query->where(function ($q) use ($search) {
+                $q->where('business_name', 'like', "%$search%")
+                    ->orWhere('business_address', 'like', "%$search%")
+                    ->orWhere('business_desc', 'like', "%$search%")
+                    ->orWhere('business_id_number', 'like', "%$search%")
+                    ->orWhere('owner_id', 'like', "%$search%")
+                    ->orWhere('owner_name', 'like', "%$search%");
+            });
+        }
+
+        $umkm = $query->paginate($perPage);
+
+        $umkm->getCollection()->transform(function ($umkm) {
+            $village = DB::table('villages')->where('village_code', $umkm->village_code)->first();
+            $umkm->village_name = $village ? $village->village_name : null;
+            
+            $district = DB::table('districts')->where('district_code', $umkm->district_code)->first();
+            $umkm->district_name = $district ? $district->district_name : null;
+
+            $business_scale = DB::table('business_scale')->where('id', $umkm->business_scale_id)->first();
+            $umkm->business_scale = $business_scale ? $business_scale->business_scale : null;
+
+            $permit_status = DB::table('permit_status')->where('id', $umkm->permit_status_id)->first();
+            $umkm->permit_status = $permit_status ? $permit_status->permit_status : null;
+
+            $business_form = DB::table('business_form')->where('id', $umkm->business_form_id)->first();
+            $umkm->business_form = $business_form ? $business_form->business_form : null;
+            return $umkm;
+        });
+
+        $start = ($umkm->currentPage()-1) * $perPage + 1;
+
+        $data = $umkm->map(function ($item, $index) use ($start) {
+            return array_merge($item->toArray(), ['no' => $start + $index]);
+        });
+
+        return response()->json([
+            'data' => $data,
+            'meta' => [
+                'total' => $umkm->total(),
+                'per_page' => $umkm->perPage(),
+                'current_page' => $umkm->currentPage(),
+                'last_page' => $umkm->lastPage(),
+            ]
+        ]);
+    }
+
+    /**
+     * Store a newly created resource in storage.
+     */
+    public function store(UmkmRequest $request): Umkm
+    {
+        info($request);
+        $data = $request->validated();
+
+        // Cari kode berdasarkan nama
+        $district_code = DB::table('districts')->where('district_name', $data['district_name'])->value('district_code');
+        $village_code = DB::table('villages')->where('village_name', $data['village_name'])->where('district_code', $district_code)->value('village_code');
+        $business_scale_id = DB::table('business_scale')->where('id', $data['business_scale_id'])->value('id');
+        $permit_status_id = DB::table('permit_status')->where('id', $data['permit_status_id'])->value('id');
+        $business_form_id = DB::table('business_form')->where('id', $data['business_form_id'])->value('id');
+
+        info($business_scale_id);
+
+        // Update data dengan kode yang ditemukan
+        $data['village_code'] = $village_code;
+        $data['district_code'] = $district_code;
+        $data['land_area'] = (double) $request['land_area'];
+        $data['business_scale_id'] = (int) $business_scale_id;
+        $data['permit_status_id'] = (int) $permit_status_id;
+        $data['business_form_id'] = (int) $business_form_id;
+
+        info($data);
+
+        // Simpan ke database
+        return Umkm::create($data);
+    }
+
+    /**
+     * Import advertisements from Excel or CSV.
+     */
+    public function importFromFile(Request $request)
+    {
+        // Validasi file
+        $validator = Validator::make($request->all(), [
+            'file' => 'required|mimes:xlsx, xls|max:10240',
+        ]);
+
+        if ($validator->fails()) {
+            return response()->json([
+                'message' => 'File validation failed.',
+                'errors' => $validator->errors()
+            ], 400);
+        }
+
+        try {
+            // Ambil file dari request
+            $file = $request->file('file');
+
+            // Menggunakan Laravel Excel untuk mengimpor file
+            Excel::import(new UmkmImport, $file);
+
+            // Jika sukses, kembalikan response sukses
+            return response()->json([
+                'message' => 'File uploaded and imported successfully!'
+            ], 200);
+        } catch (\Exception $e) {
+            return response()->json([
+                'message' => 'Error during file import.',
+                'error' => $e->getMessage()
+            ], 500);
+        }
+    }
+
+    /**
+     * Display the specified resource.
+     */
+    public function show(Umkm $umkm): Umkm
+    {
+        return $umkm;
+    }
+
+    /**
+     * Update the specified resource in storage.
+     */
+    public function update(UmkmRequest $request, Umkm $umkm): Umkm
+    {
+        info($request);
+        $data = $request->validated();
+
+        
+        // Cari district_code berdasarkan district_name
+        $district_code = DB::table('districts')->where('district_name', $data['district_name'])->value('district_code');
+        // Cari village_code berdasarkan village_name
+        $village_code = DB::table('villages')->where('village_name', $data['village_name'])->where('district_code', $district_code)->value('village_code');
+        $business_scale_id = DB::table('business_scale')->where('id', $data['business_scale_id'])->value('id');
+        $permit_status_id = DB::table('permit_status')->where('id', $data['permit_status_id'])->value('id');
+        $business_form_id = DB::table('business_form')->where('id', $data['business_form_id'])->value('id');
+
+        
+        // Tambahkan village_code dan district_code ke data
+        $data['village_code'] = $village_code;
+        $data['district_code'] = $district_code;
+        $data['land_area'] = (double) $request['land_area'];
+        $data['business_scale_id'] = (int) $business_scale_id;
+        $data['permit_status_id'] = (int) $permit_status_id;
+        $data['business_form_id'] = (int) $business_form_id;
+
+        // Log data setelah transformasi
+        info($data);
+
+        $umkm->update($data);
+
+        return $umkm;
+    }
+
+    public function destroy(Umkm $umkm): Response
+    {
+        $umkm->delete();
+
+        return response()->noContent();
+    }
+
+    public function downloadExcelUmkm()
+    {
+        $filePath = public_path('templates/template_umkm.xlsx');
+
+        // Cek apakah file ada
+        if (!file_exists($filePath)) {
+            return response()-> json(['message' => 'File tidak ditemukan!'], Response::HTTP_NOT_FOUND);
+        }
+
+        // Return file to download
+        return response()->download($filePath);
+    }
+}

app/Http/Controllers/Api/UsersController.php

@@ -4,9 +4,11 @@ namespace App\Http\Controllers\Api;
 
 use App\Http\Controllers\Controller;
 use App\Http\Requests\Auth\LoginRequest;
+use App\Http\Requests\UsersRequest;
 use App\Http\Resources\UserResource;
 use App\Models\User;
 use App\Traits\GlobalApiResponse;
+use Illuminate\Support\Facades\DB;
 use Illuminate\Support\Facades\Hash;
 use Illuminate\Http\Request;
 
@@ -35,4 +37,50 @@ class UsersController extends Controller
         $request->user()->tokens()->delete();
         return response()->json(['message' => 'logged out successfully']);
     }
+    public function store(UsersRequest $request){
+        $validate_data = $request->validated();
+
+        DB::beginTransaction();
+        try{
+            $user = User::create([
+                'name' => $validate_data['name'],
+                'email' => $validate_data['email'],
+                'password' => Hash::make($validate_data['password']),
+                'firstname' => $validate_data['firstname'],
+                'lastname' => $validate_data['lastname'],
+                'position' => $validate_data['position'],
+            ]);
+
+            $user->roles()->attach((int) $validate_data['role_id']);
+
+            DB::commit();
+            return response()->json(['message' => 'Successfully created'],201);
+        }catch(\Exception $e){
+            DB::rollBack();
+            return response()->json(['message' => $e->getMessage()],500);
+        };
+    }
+    public function update(UsersRequest $request, $id){
+        try{
+            $validate_data = $request->validated();
+            $user = User::findOrFail($id);
+
+            DB::beginTransaction();
+            $user->update([
+                'name' => $validate_data['name'],
+                'email' => $validate_data['email'],
+                'firstname' => $validate_data['firstname'],
+                'lastname' => $validate_data['lastname'],
+                'position' => $validate_data['position']
+            ]);
+
+            $user->roles()->sync($request->role_id);
+
+            DB::commit();
+            return response()->json(['message' => 'Successfully updated'], 200);
+        }catch(\Exception $e){
+            DB::rollBack();
+            return response()->json(['message' => $e->getMessage()],500);
+        }
+    }
 }

app/Http/Controllers/BigdataResumesController.php

@@ -0,0 +1,48 @@
+<?php
+
+namespace App\Http\Controllers;
+
+use Illuminate\Http\Request;
+
+class BigdataResumesController extends Controller
+{
+    /**
+     * Display a listing of the resource.
+     */
+    public function index()
+    {
+        return view('bigdata-resumes.index');
+    }
+
+    /**
+     * Show the form for creating a new resource.
+     */
+    public function create()
+    {
+        //
+    }
+
+    /**
+     * Display the specified resource.
+     */
+    public function show(string $id)
+    {
+        //
+    }
+
+    /**
+     * Show the form for editing the specified resource.
+     */
+    public function edit(string $id)
+    {
+        //
+    }
+
+    /**
+     * Remove the specified resource from storage.
+     */
+    public function destroy(string $id)
+    {
+        //
+    }
+}

app/Http/Controllers/BusinessOrIndustriesController.php

@@ -0,0 +1,66 @@
+<?php
+
+namespace App\Http\Controllers;
+
+use App\Models\BusinessOrIndustry;
+use Illuminate\Http\Request;
+
+class BusinessOrIndustriesController extends Controller
+{
+    /**
+     * Display a listing of the resource.
+     */
+    public function index()
+    {
+        return view('business-industries.index');
+    }
+
+    /**
+     * Show the form for creating a new resource.
+     */
+    public function create()
+    {
+        return view("business-industries.create");
+    }
+
+    /**
+     * Store a newly created resource in storage.
+     */
+    public function store(Request $request)
+    {
+        //
+    }
+
+    /**
+     * Display the specified resource.
+     */
+    public function show(string $id)
+    {
+        //
+    }
+
+    /**
+     * Show the form for editing the specified resource.
+     */
+    public function edit(string $id)
+    {
+        $data = BusinessOrIndustry::findOrFail($id);
+        return view('business-industries.edit', compact('data'));
+    }
+
+    /**
+     * Update the specified resource in storage.
+     */
+    public function update(Request $request, string $id)
+    {
+        //
+    }
+
+    /**
+     * Remove the specified resource from storage.
+     */
+    public function destroy(string $id)
+    {
+        //
+    }
+}

app/Http/Controllers/CustomersController.php

@@ -0,0 +1,26 @@
+<?php
+
+namespace App\Http\Controllers;
+
+use App\Models\Customer;
+use Illuminate\Http\Request;
+
+class CustomersController extends Controller
+{
+    public function index()
+    {
+        return view('customers.index');
+    }
+    public function create()
+    {
+        return view('customers.create');
+    }
+    public function edit(string $id)
+    {
+        $data = Customer::findOrFail($id);
+        return view('customers.edit', compact('data'));
+    }
+    public function upload(){
+        return view('customers.upload');
+    }
+}

app/Http/Controllers/Dashboards/BigDataController.php

@@ -15,7 +15,8 @@ class BigDataController extends Controller
         return view('dashboards.bigdata', compact('latest_created'));
     }
 
-    public function pbg(){
+    public function pbg()
-        return view('index');
+    {
+        return view('dashboards.pbg');
     }
 }

app/Http/Controllers/Dashboards/LackOfPotentialController.php

@@ -0,0 +1,13 @@
+<?php
+
+namespace App\Http\Controllers\Dashboards;
+
+use App\Http\Controllers\Controller;
+use Illuminate\Http\Request;
+
+class LackOfPotentialController extends Controller
+{
+    public function lack_of_potential(){
+        return view('dashboards.lack_of_potential');
+    }
+}

app/Http/Controllers/Data/SpatialPlanningController.php

@@ -0,0 +1,125 @@
+<?php
+
+namespace App\Http\Controllers\Data;
+
+use App\Http\Controllers\Controller;
+use App\Models\SpatialPlanning;
+use Illuminate\Http\Request;
+
+class SpatialPlanningController extends Controller
+{
+    /**
+     * Display a listing of the resource.
+     */
+    public function index()
+    {
+        return view('data.spatialPlannings.index');
+    }
+
+    /**
+     * show the form for creating a new resource.
+     */
+    public function bulkCreate()
+    {
+        return view('data.spatialPlannings.form-upload');
+    }
+
+    /**
+     * Show the form for creating a new resource.
+     */
+    public function create()
+    {
+        $title = 'Rencana Tata Ruang';
+        $subtitle = "Create Data";
+
+        // Mengambil data untuk dropdown
+        $dropdownOptions = [];
+
+        $fields = $this->getFields();
+        $fieldTypes = $this->getFieldTypes();
+
+        $apiUrl = url('/api/spatial-plannings');
+        return view('data.spatialPlannings.form', compact('title', 'subtitle', 'fields', 'fieldTypes', 'apiUrl', 'dropdownOptions'));
+    }
+
+    /**
+     * Store a newly created resource in storage.
+     */
+    public function store(Request $request)
+    {
+        //
+    }
+
+    /**
+     * Display the specified resource.
+     */
+    public function show(string $id)
+    {
+        //
+    }
+
+    /**
+     * Show the form for editing the specified resource.
+     */
+    public function edit(string $id)
+    {
+        $title = 'Rencana Tata Ruang';
+        $subtitle = 'Update Data';
+
+        $modelInstance = SpatialPlanning::find($id);
+        // Pastikan model ditemukan
+        if (!$modelInstance) {
+            return redirect()->route('spatialPlanning.index') ->with('error', 'Rencana tata ruang tidak ditemukan');
+        }
+
+        $dropdownOptions = [];
+
+        $fields = $this->getFields();
+        $fieldTypes = $this->getFieldTypes();
+
+        $apiUrl = url('/api/spatial-plannings');
+        return view('data.spatialPlannings.form', compact('title', 'subtitle', 'modelInstance', 'fields', 'fieldTypes', 'apiUrl', 'dropdownOptions'));
+    }
+
+    /**
+     * Update the specified resource in storage.
+     */
+    public function update(Request $request, string $id)
+    {
+        //
+    }
+
+    /**
+     * Remove the specified resource from storage.
+     */
+    public function destroy(string $id)
+    {
+        //
+    }
+
+    private function getFields()
+    {
+        return [
+            "name"=> "Nama",
+            "kbli"=> "KBLI",
+            "activities"=> "Kegiatan",
+            "area"=> "Luas (m2)",
+            "location"=> "Lokasi",
+            "number"=> "Nomor",
+            "date"=> "Tanggal",
+        ];
+    }
+
+    private function getFieldTypes() 
+    {
+        return [
+            "name"=> "text",
+            "kbli"=> "text",
+            "activities"=> "text",
+            "area"=> "text",
+            "location"=> "text",
+            "number"=> "text",
+            "date"=> "date",
+        ];
+    }
+}

app/Http/Controllers/Data/TourismController.php

@@ -0,0 +1,145 @@
+<?php
+
+namespace App\Http\Controllers\Data;
+
+use App\Http\Controllers\Controller;
+use App\Models\Tourism;
+use Illuminate\Http\Request;
+use Illuminate\Support\Facades\DB;
+
+class TourismController extends Controller
+{
+    /**
+     * Display a listing of the resource
+     */
+    public function index()
+    {
+        return view('data.tourisms.index');
+    }
+
+    /**
+     * show the form for creating a new rsource.
+     */
+    public function bulkCreate()
+    {
+        return view('data.tourisms.form-upload');
+    }
+
+    /**
+     * Show th form for creating a new resource
+     */
+    public function create()
+    {
+        $title = 'Pariwisata';
+        $subtitle = 'Create Data';
+
+        // Mengambil data untuk dropdown
+        $dropdownOptions = [
+            'village_name' => DB::table('villages')->orderBy('village_name')->pluck('village_name', 'village_code'),
+            'district_name' => DB::table('districts')->orderBy('district_name')->pluck('district_name', 'district_code')
+        ];
+
+        $fields = $this->getFields();
+        $fieldTypes = $this->getFieldTypes();
+
+        $apiUrl = url('/api/tourisms');
+
+        return view('data.tourisms.form', compact('title', 'subtitle', 'fields', 'fieldTypes', 'apiUrl', 'dropdownOptions'));
+    }
+
+    /**
+     * show the form for editing the specified resource.
+     */
+    public function edit($id)
+    {
+        $title = 'Pariwisata';
+        $subtitle = 'Update Data';
+
+        $modelInstance = Tourism::find($id);
+        // Pastikan model ditemukan
+        if (!$modelInstance) {
+            return redirect()->route('tourisms.index') ->with('error', 'Pariwisata tidak ditemukan');
+        }
+
+        // Mengambil dan memetakan village_name dan district_name
+        $village = DB::table('villages')->where('village_code', $modelInstance->village_code)->first();
+        $modelInstance->village_name = $village ? $village->village_name : null;
+
+        $district = DB::table('districts')->where('district_code', $modelInstance->district_code)->first();
+        $modelInstance->district_name = $district ? $district->district_name : null;
+
+        $dropdownOptions = [
+            'village_name' => DB::table('villages')->orderBy('village_name')->pluck('village_name', 'village_code'),
+            'district_name' => DB::table('districts')->orderBy('district_name')->pluck('district_name', 'district_code')
+        ];
+
+        $fields = $this->getFields();
+        $fieldTypes = $this->getFieldTypes();
+
+        $apiUrl = url('/api/tourisms');
+
+        return view('data.tourisms.form', compact('title', 'subtitle', 'modelInstance', 'fields', 'fieldTypes', 'apiUrl', 'dropdownOptions'));
+    }
+
+    private function getFields()
+    {
+        return [
+            "project_id" => "ID Proyek",
+            "project_type_id" => "Jenis Proyek",
+            "nib" => "NIB",
+            "business_name" => "Nama Perusahaan",
+            "oss_publication_date" => "Tanggal Terbit OSS",
+            "investment_status_description" => "Uraian Status Penanaman Modal",
+            "business_form" => "Uraian Jenis Perusahaan",
+            "project_risk" => "Risiko Proyek",
+            "project_name" => "Nama Proyek",
+            "business_scale" => "Uraian Skala Usaha",
+            "business_address" => "Alamat Usaha",
+            "district_name" => "Kecamatan",
+            "village_name" => "Desa",
+            "longitude" => "Longitude",
+            "latitude" => "Latitude",
+            "project_submission_date" => "Tanggal Pengajuan Project",
+            "kbli" => "KBLI",
+            "kbli_title" => "Judul KBLI",
+            "supervisory_sector" => "Sektor Pembina",
+            "user_name" => "Nama User",
+            "email" => "Email",
+            "contact" => "Kontak",
+            "land_area_in_m2" => "Luas Tanah (m2)",
+            "investment_amount" => "Jumlah Investasi",
+            "tki" => "TKI",
+        ];
+    }
+
+    private function getFieldTypes()
+    {
+        return [
+            "project_id" => "text",
+            "project_type_id" => "text",
+            "nib" => "text",
+            "business_name" => "text",
+            "oss_publication_date" => "date",
+            "investment_status_description" => "text",
+            "business_form" => "text",
+            "project_risk" => "text",
+            "project_name" => "text",
+            "business_scale" => "text",
+            "business_address" => "text",
+            "district_name" => "combobox",
+            "village_name" => "combobox",
+            "longitude" => "text",
+            "latitude" => "text",
+            "project_submission_date" => "date",
+            "kbli" => "text",
+            "kbli_title" => "text",
+            "supervisory_sector" => "text",
+            "user_name" => "text",
+            "email" => "text",
+            "contact" => "text",
+            "land_area_in_m2" => "text",
+            "investment_amount" => "text",
+            "tki" => "text",
+        ];
+    }
+}

app/Http/Controllers/Data/UmkmController.php

@@ -0,0 +1,149 @@
+<?php
+
+namespace App\Http\Controllers\Data;
+
+use App\Http\Controllers\Controller;
+use App\Models\Umkm;
+use Illuminate\Http\Request;
+use Illuminate\Support\Facades\DB;
+
+class UmkmController extends Controller
+{
+    /**
+     * Display a listing of the resource.
+     */
+    public function index()
+    {
+        return view('data.umkm.index');
+    }
+
+    /**
+     * Show the form for creating a new resource.
+     */
+    public function bulkCreate()
+    {
+        return view('data.umkm.form-upload');
+    }
+
+    /**
+     * Show the form for creating a new resource.
+     */
+    public function create()
+    {
+        $title = 'UMKM';
+        $subtitle = 'Create Data';
+
+        // Mengambil data untuk dropdown
+        $dropdownOptions = [
+            'village_name' => DB::table('villages')->orderBy('village_name')->pluck('village_name', 'village_code'),
+            'district_name' => DB::table('districts')->orderBy('district_name')->pluck('district_name', 'district_code'),
+            'business_scale_id' => DB::table('business_scale')->orderBy('business_scale')->pluck('business_scale', 'id'),
+            'permit_status_id' => DB::table('permit_status')->orderBy('permit_status')->pluck('permit_status', 'id'),
+            'business_form_id' => DB::table('business_form')->orderBy('business_form')->pluck('business_form', 'id')
+        ];
+
+        $fields = $this->getFields();
+        $fieldTypes = $this->getFieldTypes();
+
+        $apiUrl = url('/api/umkm');
+
+        return view('data.umkm.form', compact('title', 'subtitle', 'fields', 'fieldTypes', 'apiUrl', 'dropdownOptions'));
+    }
+
+    /**
+     * Show the form for editing the specified resource.
+     */
+    public function edit($id)
+    {
+        $title = 'UMKM';
+        $subtitle = 'Update Data';
+        $modelInstance = Umkm::find($id);
+        // Pastikan model ditemukan
+        if (!$modelInstance) {
+            return redirect()->route('umkm.index')->with('error', 'Umkm not found');
+        }
+
+        // Mengambil dan memetakan village_name dan district_name
+        $village = DB::table('villages')->where('village_code', $modelInstance->village_code)->first();
+        $modelInstance->village_name = $village ? $village->village_name : null;
+
+        $district = DB::table('districts')->where('district_code', $modelInstance->district_code)->first();
+        $modelInstance->district_name = $district ? $district->district_name : null;
+
+        $business_scale = DB::table('business_scale')->where('id', $modelInstance->business_scale_id)->first();
+        $modelInstance->business_scale_id = $business_scale ? $business_scale->id : null;
+        
+        $permit_status = DB::table('permit_status')->where('id', $modelInstance->permit_status_id)->first();
+        $modelInstance->permit_status_id = $permit_status ? $permit_status->id : null;
+
+        $business_form = DB::table('business_form')->where('id', $modelInstance->business_form_id)->first();
+        $modelInstance->business_form_id = $business_form ? $business_form->id : null;
+
+        // dd($modelInstance['business_form_id']);
+        // Mengambil data untuk dropdown
+        $dropdownOptions = [
+            'village_name' => DB::table('villages')->orderBy('village_name')->pluck('village_name', 'village_code'),
+            'district_name' => DB::table('districts')->orderBy('district_name')->pluck('district_name', 'district_code'),
+            'business_scale_id' => DB::table('business_scale')->orderBy('business_scale')->pluck('business_scale', 'id'),
+            'permit_status_id' => DB::table('permit_status')->orderBy('permit_status')->pluck('permit_status', 'id'),
+            'business_form_id' => DB::table('business_form')->orderBy('business_form')->pluck('business_form', 'id')
+        ];
+
+        info("AdvertisementController@edit diakses dengan Model Instance: $modelInstance");
+        $fields = $this->getFields();
+        $fieldTypes = $this->getFieldTypes();
+
+        $apiUrl = url('/api/umkm');
+
+        // dd($modelInstance->business_form_id, $dropdownOptions['business_form']);
+        return view('data.umkm.form', compact('title', 'subtitle', 'modelInstance', 'fields', 'fieldTypes', 'apiUrl', 'dropdownOptions'));
+    }
+
+    private function getFields()
+    {
+        return [
+            "business_name" => "Nama Usaha",
+            "business_address" => "Alamat Usaha",
+            "business_desc" => "Deskripsi Usaha",
+            "business_contact" => "Kontak Usaha",
+            "business_id_number" => "NIB",
+            "business_scale_id" => "Skala Usaha",
+            "owner_id" => "NIK",
+            "owner_name" => "Nama Pemilik",
+            "owner_address" => "Alamat Pemilik",
+            "owner_contact" => "Kontak Pemilik",
+            "business_type" => "Jenis Usaha",
+            "district_name" => "Kecamatan",
+            "village_name" => "Desa",
+            "number_of_employee" => "Jumlah Karyawan",
+            "land_area" => "Luas Tanah",
+            "permit_status_id" => "Ijin Status",
+            "business_form_id" => "Bisnis Form",
+            "revenue" => "Omset"
+        ];
+    }
+
+    private function getFieldTypes()
+    {
+        return [
+            "business_name" => "text",
+            "business_address" => "text",
+            "business_desc" => "textarea",
+            "business_contact" => "text",
+            "business_id_number" => "text",
+            "business_scale_id" => "select",
+            "owner_id" => "text",
+            "owner_name" => "text",
+            "owner_address" => "text",
+            "owner_contact" => "text",
+            "business_type" => "text",
+            "district_name" => "combobox",
+            "village_name" => "combobox",
+            "number_of_employee" => "text",
+            "land_area" => "text",
+            "permit_status_id" => "select",
+            "business_form_id" => "select",
+            "revenue" => "text"
+        ];
+    }
+}

app/Http/Controllers/GoogleApisController.php

@@ -0,0 +1,12 @@
+<?php
+
+namespace App\Http\Controllers;
+
+use Illuminate\Http\Request;
+
+class GoogleApisController extends Controller
+{
+    public function index(){
+        return view('maps.google-api');
+    }
+}

app/Http/Controllers/Master/UsersController.php

@@ -3,6 +3,7 @@
 namespace App\Http\Controllers\Master;
 
 use App\Http\Controllers\Controller;
+use App\Http\Requests\UsersRequest;
 use App\Models\Role;
 use Illuminate\Http\Request;
 use Illuminate\Support\Facades\DB;
@@ -28,7 +29,7 @@ class UsersController extends Controller
         $roles = Role::all();
         return view('master.users.create', compact('roles'));
     }
-    public function store(Request $request){
+    public function store(UsersRequest $request){
         $request->validate([
             'name' => ['required', 'string', 'max:255'],
             'email' => ['required', 'string', 'email', 'max:255', 'unique:users'],
@@ -39,6 +40,7 @@ class UsersController extends Controller
             'role_id' => 'required|exists:roles,id'
         ]);
 
+
         DB::beginTransaction();
         try{
             $user = User::create([

app/Http/Controllers/Report/ReportTourismController.php

@@ -0,0 +1,21 @@
+<?php
+
+namespace App\Http\Controllers\Report;
+
+use App\Http\Controllers\Controller;
+use App\Models\TourismBasedKBLI;
+use Illuminate\Http\Request;
+use Illuminate\Support\Facades\DB;
+
+class ReportTourismController extends Controller
+{
+    /**
+     * Display a listring of the resource
+     */
+    public function index()
+    {
+        $tourismBasedKBLI = TourismBasedKBLI::all();
+        info($tourismBasedKBLI);
+        return view('report.tourisms.index', compact('tourismBasedKBLI'));
+    }
+}

app/Http/Requests/AdvertisementRequest.php

@@ -40,4 +40,40 @@ class AdvertisementRequest extends FormRequest
 			'contact' => 'required|string',
         ];
     }
+
+    /**
+     * pesan error validasi
+     */
+    public function messages(): array
+    {
+        return [
+            'no.required' => 'Nomor harus diisi.',
+            'business_name.required' => 'Nama usaha harus diisi.',
+            'business_name.string' => 'Nama usaha harus berupa teks.',
+            'npwpd.required' => 'NPWPD harus diisi.',
+            'npwpd.string' => 'NPWPD harus berupa teks.',
+            'advertisement_type.required' => 'Jenis reklame harus diisi.',
+            'advertisement_type.string' => 'Jenis reklame harus berupa teks.',
+            'advertisement_content.required' => 'Isi reklame harus diisi.',
+            'advertisement_content.string' => 'Isi reklame harus berupa teks.',
+            'business_address.required' => 'Alamat usaha harus diisi.',
+            'business_address.string' => 'Alamat usaha harus berupa teks.',
+            'advertisement_location.required' => 'Lokasi reklame harus diisi.',
+            'advertisement_location.string' => 'Lokasi reklame harus berupa teks.',
+            'village_name.required' => 'Nama desa harus diisi.',
+            'district_name.required' => 'Nama kecamatan harus diisi.',
+            'length.required' => 'Panjang harus diisi.',
+            'width.required' => 'Lebar harus diisi.',
+            'viewing_angle.required' => 'Sudut pandang harus diisi.',
+            'viewing_angle.string' => 'Sudut pandang harus berupa teks.',
+            'face.required' => 'Jumlah sisi harus diisi.',
+            'face.string' => 'Jumlah sisi harus berupa teks.',
+            'area.required' => 'Luas harus diisi.',
+            'area.string' => 'Luas harus berupa teks.',
+            'angle.required' => 'Sudut harus diisi.',
+            'angle.string' => 'Sudut harus berupa teks.',
+            'contact.required' => 'Kontak harus diisi.',
+            'contact.string' => 'Kontak harus berupa teks.',
+        ];
+    }
 }

app/Http/Requests/BusinessIndustryRequest.php

@@ -0,0 +1,39 @@
+<?php
+
+namespace App\Http\Requests;
+
+use Illuminate\Foundation\Http\FormRequest;
+
+class BusinessIndustryRequest extends FormRequest
+{
+    /**
+     * Determine if the user is authorized to make this request.
+     */
+    public function authorize(): bool
+    {
+        return true;
+    }
+
+    /**
+     * Get the validation rules that apply to the request.
+     *
+     * @return array<string, \Illuminate\Contracts\Validation\ValidationRule|array<mixed>|string>
+     */
+    public function rules(): array
+    {
+        return [
+            'nama_kecamatan' => 'required|string|max:255',
+            'nama_kelurahan' => 'required|string|max:255',
+            'nop' => 'required|string|max:255|unique:business_or_industries,nop,' . $this->route('api_business_industry'),
+            'nama_wajib_pajak' => 'required|string|max:255',
+            'alamat_wajib_pajak' => 'nullable|string|max:255',
+            'alamat_objek_pajak' => 'required|string|max:255',
+            'luas_bumi' => 'required|numeric',
+            'luas_bangunan' => 'required|numeric',
+            'njop_bumi' => 'required|numeric',
+            'njop_bangunan' => 'required|numeric',
+            'ketetapan' => 'required|string|max:255',
+            'tahun_pajak' => 'required|integer|min:1900|max:' . date('Y'),
+        ];
+    }
+}

app/Http/Requests/CustomersRequest.php

@@ -0,0 +1,33 @@
+<?php
+
+namespace App\Http\Requests;
+
+use Illuminate\Foundation\Http\FormRequest;
+
+class CustomersRequest extends FormRequest
+{
+    /**
+     * Determine if the user is authorized to make this request.
+     */
+    public function authorize(): bool
+    {
+        return true;
+    }
+
+    /**
+     * Get the validation rules that apply to the request.
+     *
+     * @return array<string, \Illuminate\Contracts\Validation\ValidationRule|array<mixed>|string>
+     */
+    public function rules(): array
+    {
+        return [
+            'nomor_pelanggan' => ['required', 'string'],
+            'kota_pelayanan' => ['required', 'string'],
+            'nama' => ['required', 'string'],
+            'alamat' => ['required', 'string'],
+            'latitude' => ['required', 'numeric', 'between:-90,90'],
+            'longitude' => ['required', 'numeric', 'between:-180,180'],
+        ];
+    }
+}

app/Http/Requests/DataSettingRequest.php

@@ -21,7 +21,7 @@ class DataSettingRequest extends FormRequest
      */
     public function rules(): array
     {
-        $id = $this->route('data_setting');
+        $id = $this->route('data_setting_id');
         return [
             "key" => "required|unique:data_settings,key," . $id,
             "value" => "required",

app/Http/Requests/ExcelUploadRequest.php

@@ -0,0 +1,28 @@
+<?php
+
+namespace App\Http\Requests;
+
+use Illuminate\Foundation\Http\FormRequest;
+
+class ExcelUploadRequest extends FormRequest
+{
+    /**
+     * Determine if the user is authorized to make this request.
+     */
+    public function authorize(): bool
+    {
+        return true;
+    }
+
+    /**
+     * Get the validation rules that apply to the request.
+     *
+     * @return array<string, \Illuminate\Contracts\Validation\ValidationRule|array<mixed>|string>
+     */
+    public function rules(): array
+    {
+        return [
+            "file" => "required|file|mimes:xlsx,xls|max:102400"
+        ];
+    }
+}

app/Http/Requests/MenuRequest.php

@@ -3,6 +3,7 @@
 namespace App\Http\Requests;
 
 use Illuminate\Foundation\Http\FormRequest;
+use Illuminate\Validation\Rule;
 
 class MenuRequest extends FormRequest
 {
@@ -21,12 +22,14 @@ class MenuRequest extends FormRequest
      */
     public function rules(): array
     {
+        $menuId = $this->route('menu_id'); // Get the menu ID if updating
+
         return [
-            'name' => ['required','string','max:255'],
+            'name' => ['required', 'string', 'max:255', Rule::unique('menus', 'name')->ignore($menuId)],
-            'url' => ['nullable','string','max:255'],
+            'url' => ['nullable', 'string', 'max:255'],
-            'icon' => ['nullable','string','max:255'],
+            'icon' => ['nullable', 'string', 'max:255'],
-            'parent_id' => ['nullable','exists:menus,id'],
+            'parent_id' => ['nullable', 'exists:menus,id'],
-            'sort_order' => ['required','integer'],
+            'sort_order' => ['required', 'integer'],
         ];
     }
 }

app/Http/Requests/RoleRequest.php

@@ -21,7 +21,7 @@ class RoleRequest extends FormRequest
      */
     public function rules(): array
     {
-        $roleId = $this->route('role');
+        $roleId = $this->route('role_id');
         return [
             'name' => 'required|string|max:255|unique:roles,name,' . ($roleId ?? 'NULL') . ',id',
             'description' => 'nullable|string',

app/Http/Requests/SpatialPlanningRequest.php

@@ -0,0 +1,52 @@
+<?php
+
+namespace App\Http\Requests;
+
+use Illuminate\Foundation\Http\FormRequest;
+
+class SpatialPlanningRequest extends FormRequest
+{
+    /**
+     * Determine if the user is authorized to make this request.
+     */
+    public function authorize(): bool
+    {
+        return true;
+    }
+
+    /**
+     * Get the validation rules that apply to the request.
+     *
+     * @return array<string, \Illuminate\Contracts\Validation\ValidationRule|array<mixed>|string>
+     */
+    public function rules(): array
+    {
+        return [
+			'name' => 'string',
+			'kbli' => 'string',
+			'activities' => 'string',
+			'area' => 'string',
+			'location' => 'string',
+			'number' => 'string',
+            'date' => 'date_format:Y-m-d',
+        ];
+    }
+
+    /**
+     * Get the validation messages for the defined validation rules.
+     *
+     * @return array<string, string>
+     */
+    public function messages(): array
+    {
+        return [
+            'name.string' => 'Kolom Nama harus berupa teks.',
+            'kbli.string' => 'Kolom KBLI harus berupa teks.',
+            'activities.string' => 'Kolom Kegiatan harus berupa teks.',
+            'area.string' => 'Kolom Area harus berupa teks.',
+            'location.string' => 'Kolom Lokasi harus berupa teks.',
+            'number.string' => 'Kolom Nomor harus berupa teks.',
+            'date.date_format' => 'Format tanggal tidak valid, gunakan format Y-m-d H:i:s.',
+        ];
+    }
+}

app/Http/Requests/SpatialPlanningsRequest.php

@@ -0,0 +1,35 @@
+<?php
+
+namespace App\Http\Requests;
+
+use Illuminate\Foundation\Http\FormRequest;
+use Illuminate\Validation\Rule;
+
+class SpatialPlanningsRequest extends FormRequest
+{
+    /**
+     * Determine if the user is authorized to make this request.
+     */
+    public function authorize(): bool
+    {
+        return true;
+    }
+
+    /**
+     * Get the validation rules that apply to the request.
+     *
+     * @return array<string, \Illuminate\Contracts\Validation\ValidationRule|array<mixed>|string>
+     */
+    public function rules(): array
+    {
+        return [
+            'name' => ['required','string','max:255'],
+            'kbli' => ['required','string','max:255'],
+            'kegiatan' => ['required','string'],
+            'luas' => ['required','numeric','regex:/^\d{1,16}(\.\d{1,2})?$/'],
+            'lokasi' => ['required','string'],
+            'nomor' => ['required','string','max:255',Rule::unique('spatial_plannings')->ignore($this->id)],
+            'sp_date' => ['required','date'],
+        ];
+    }
+}

app/Http/Requests/TourismRequest.php

@@ -0,0 +1,133 @@
+<?php
+
+namespace App\Http\Requests;
+
+use Illuminate\Foundation\Http\FormRequest;
+
+class TourismRequest extends FormRequest
+{
+    /**
+     * Determine if the user is authorized to make this request.
+     */
+    public function authorize(): bool
+    {
+        return true;
+    }
+
+    /**
+     * Get the validation rules that apply to the request.
+     *
+     * @return array<string, \Illuminate\Contracts\Validation\ValidationRule|array<mixed>|string>
+     */
+    public function rules(): array
+    {
+        return [
+			'project_id' => 'required|string',
+			'project_type_id' => 'required|string',
+			'nib' => 'required|string',
+			'business_name' => 'required|string',
+			'oss_publication_date' => 'required',
+			'investment_status_description' => 'required|string',
+			'business_form' => 'required|string',
+			'project_risk' => 'required|string',
+			'project_name' => 'required|string',
+			'business_scale' => 'required|string',
+			'business_address' => 'required|string',
+			'district_name' => 'required',
+			'village_name' => 'required',
+			'longitude' => 'required|string',
+			'latitude' => 'required|string',
+			'project_submission_date' => 'required',
+			'kbli' => 'required|string',
+			'kbli_title' => 'required|string',
+			'supervisory_sector' => 'required|string',
+			'user_name' => 'required|string',
+			'email' => 'required|string',
+			'contact' => 'required|string',
+			'land_area_in_m2' => 'required|string',
+			'investment_amount' => 'required|string',
+			'tki' => 'required|string',
+        ];
+    }
+
+	/**
+	 * Get the validation messages for the defined validation rules.
+	 *
+	 * @return array<string, string>
+	 */
+	public function messages(): array
+	{
+		return [
+			'project_id.required' => 'ID proyek harus diisi.',
+			'project_id.string' => 'ID proyek harus berupa teks.',
+
+			'project_type_id.required' => 'ID tipe proyek harus diisi.',
+			'project_type_id.string' => 'ID tipe proyek harus berupa teks.',
+
+			'nib.required' => 'NIB harus diisi.',
+			'nib.string' => 'NIB harus berupa teks.',
+
+			'business_name.required' => 'Nama usaha harus diisi.',
+			'business_name.string' => 'Nama usaha harus berupa teks.',
+
+			'oss_publication_date.required' => 'Tanggal publikasi OSS harus diisi.',
+
+			'investment_status_description.required' => 'Deskripsi status investasi harus diisi.',
+			'investment_status_description.string' => 'Deskripsi status investasi harus berupa teks.',
+
+			'business_form.required' => 'Bentuk usaha harus diisi.',
+			'business_form.string' => 'Bentuk usaha harus berupa teks.',
+
+			'project_risk.required' => 'Risiko proyek harus diisi.',
+			'project_risk.string' => 'Risiko proyek harus berupa teks.',
+
+			'project_name.required' => 'Nama proyek harus diisi.',
+			'project_name.string' => 'Nama proyek harus berupa teks.',
+
+			'business_scale.required' => 'Skala usaha harus diisi.',
+			'business_scale.string' => 'Skala usaha harus berupa teks.',
+
+			'business_address.required' => 'Alamat usaha harus diisi.',
+			'business_address.string' => 'Alamat usaha harus berupa teks.',
+
+			'district_name.required' => 'Nama kecamatan harus diisi.',
+
+			'village_name.required' => 'Nama desa harus diisi.',
+
+			'longitude.required' => 'Garis bujur harus diisi.',
+			'longitude.string' => 'Garis bujur harus berupa teks.',
+
+			'latitude.required' => 'Garis lintang harus diisi.',
+			'latitude.string' => 'Garis lintang harus berupa teks.',
+
+			'project_submission_date.required' => 'Tanggal pengajuan proyek harus diisi.',
+
+			'kbli.required' => 'Kode KBLI harus diisi.',
+			'kbli.string' => 'Kode KBLI harus berupa teks.',
+
+			'kbli_title.required' => 'Judul KBLI harus diisi.',
+			'kbli_title.string' => 'Judul KBLI harus berupa teks.',
+
+			'supervisory_sector.required' => 'Sektor pengawasan harus diisi.',
+			'supervisory_sector.string' => 'Sektor pengawasan harus berupa teks.',
+
+			'user_name.required' => 'Nama pengguna harus diisi.',
+			'user_name.string' => 'Nama pengguna harus berupa teks.',
+
+			'email.required' => 'Email harus diisi.',
+			'email.string' => 'Email harus berupa teks.',
+
+			'contact.required' => 'Kontak harus diisi.',
+			'contact.string' => 'Kontak harus berupa teks.',
+
+			'land_area_in_m2.required' => 'Luas lahan dalam m² harus diisi.',
+			'land_area_in_m2.string' => 'Luas lahan dalam m² harus berupa teks.',
+
+			'investment_amount.required' => 'Jumlah investasi harus diisi.',
+			'investment_amount.string' => 'Jumlah investasi harus berupa teks.',
+
+			'tki.required' => 'Jumlah tenaga kerja Indonesia harus diisi.',
+			'tki.string' => 'Jumlah tenaga kerja Indonesia harus berupa teks.',
+		];
+	}
+}

app/Http/Requests/UmkmRequest.php

@@ -0,0 +1,106 @@
+<?php
+
+namespace App\Http\Requests;
+
+use Illuminate\Foundation\Http\FormRequest;
+
+class UmkmRequest extends FormRequest
+{
+    /**
+     * Determine if the user is authorized to make this request.
+     */
+    public function authorize(): bool
+    {
+        return true;
+    }
+
+    /**
+     * Get the validation rules that apply to the request.
+     *
+     * @return array<string, \Illuminate\Contracts\Validation\ValidationRule|array<mixed>|string>
+     */
+    public function rules(): array
+    {
+        return [
+			'business_name' => 'required|string',
+			'business_address' => 'required|string',
+			'business_desc' => 'required|string',
+			'business_contact' => 'required|string',
+			'business_id_number' => 'string',
+			'business_scale_id' => 'required',
+			'owner_id' => 'required|string',
+			'owner_name' => 'required|string',
+			'owner_address' => 'required|string',
+			'owner_contact' => 'required|string',
+			'business_type' => 'required|string',
+			'business_form_id' => 'required|string',
+			'revenue' => 'required|numeric|between:0,999999999999999999.99',
+			'village_name' => 'required|string',
+			'district_name' => 'required',
+			'number_of_employee' => 'required',
+			'permit_status_id' => 'required',
+            'land_area' => 'required|integer|between:0,99999999999',
+        ];
+    }
+
+    /**
+     * Get the validation messages for the request.
+     *
+     * @return array<string, string>
+     */
+    public function messages(): array
+    {
+        return [
+            'business_name.required' => 'Nama usaha wajib diisi.',
+            'business_name.string' => 'Nama usaha harus berupa teks.',
+
+            'business_address.required' => 'Alamat usaha wajib diisi.',
+            'business_address.string' => 'Alamat usaha harus berupa teks.',
+
+            'business_desc.required' => 'Deskripsi usaha wajib diisi.',
+            'business_desc.string' => 'Deskripsi usaha harus berupa teks.',
+
+            'business_contact.required' => 'Kontak usaha wajib diisi.',
+            'business_contact.string' => 'Kontak usaha harus berupa teks.',
+
+            'business_id_number.string' => 'Nomor ID usaha harus berupa teks.',
+
+            'business_scale_id.required' => 'Skala usaha wajib diisi.',
+
+            'owner_id.required' => 'ID pemilik wajib diisi.',
+            'owner_id.string' => 'ID pemilik harus berupa teks.',
+
+            'owner_name.required' => 'Nama pemilik wajib diisi.',
+            'owner_name.string' => 'Nama pemilik harus berupa teks.',
+
+            'owner_address.required' => 'Alamat pemilik wajib diisi.',
+            'owner_address.string' => 'Alamat pemilik harus berupa teks.',
+
+            'owner_contact.required' => 'Kontak pemilik wajib diisi.',
+            'owner_contact.string' => 'Kontak pemilik harus berupa teks.',
+
+            'business_type.required' => 'Jenis usaha wajib diisi.',
+            'business_type.string' => 'Jenis usaha harus berupa teks.',
+
+            'business_form.required' => 'Bentuk usaha wajib diisi.',
+            'business_form.string' => 'Bentuk usaha harus berupa teks.',
+
+            'revenue.required' => 'Omset wajib diisi.',
+            'revenue.numeric' => 'Omset harus berupa angka yang valid.',
+            'revenue.between' => 'Omset harus berada di antara 0 dan 9.999.999.999,99.',
+
+            'village_name.required' => 'Nama desa wajib diisi.',
+            'village_name.string' => 'Nama desa harus berupa teks.',
+
+            'district_name.required' => 'Nama distrik wajib diisi.',
+
+            'number_of_employee.required' => 'Jumlah karyawan wajib diisi.',
+
+            'permit_status_id.required' => 'Status izin wajib diisi.',
+
+            'land_area.required' => 'Luas lahan wajib diisi.',
+            'land_area.integer' => 'Luas lahan harus berupa angka bulat.',
+            'land_area.between' => 'Luas lahan harus berada di antara 0 dan 99.999.999.999.',
+        ];
+    }
+}

app/Http/Requests/UsersRequest.php

@@ -0,0 +1,43 @@
+<?php
+
+namespace App\Http\Requests;
+
+use Illuminate\Foundation\Http\FormRequest;
+use Illuminate\Validation\Rule;
+
+class UsersRequest extends FormRequest
+{
+    /**
+     * Determine if the user is authorized to make this request.
+     */
+    public function authorize(): bool
+    {
+        return true;
+    }
+
+    /**
+     * Get the validation rules that apply to the request.
+     *
+     * @return array<string, \Illuminate\Contracts\Validation\ValidationRule|array<mixed>|string>
+     */
+    public function rules(): array
+    {
+        $userId = $this->route('users'); // Get user ID from route (used in update)
+
+        return [
+            'name' => ['required', 'string', 'max:255'],
+            'email' => [
+                'required',
+                'string',
+                'email',
+                'max:255',
+                Rule::unique('users')->ignore($userId)
+            ],
+            'password' => [$this->isMethod('post') ? 'required' : 'nullable', 'confirmed', 'max:255'],
+            'firstname' => ['required', 'string', 'max:255'],
+            'lastname' => ['required', 'string', 'max:255'],
+            'position' => ['required', 'string', 'max:255'],
+            'role_id' => ['required', 'exists:roles,id'],
+        ];
+    }
+}

app/Http/Resources/BigdataResumeResource.php

@@ -0,0 +1,42 @@
+<?php
+
+namespace App\Http\Resources;
+
+use Illuminate\Http\Request;
+use Illuminate\Http\Resources\Json\JsonResource;
+
+class BigdataResumeResource extends JsonResource
+{
+    /**
+     * Transform the resource into an array.
+     *
+     * @return array<string, mixed>
+     */
+    public function toArray(Request $request): array
+    {
+        return [
+            'id' => $this->id,
+            'import_datasource_id' => $this->import_datasource_id,
+            'potention_count'      => (int) $this->potention_count,
+            'potention_sum'        => number_format((float) $this->potention_sum, 2, ',', '.'),
+
+            'non_verified_count'   => (int) $this->non_verified_count,
+            'non_verified_sum'     => number_format((float) $this->non_verified_sum, 2, ',', '.'),
+
+            'verified_count'       => (int) $this->verified_count,
+            'verified_sum'         => number_format((float) $this->verified_sum, 2, ',', '.'),
+
+            'business_count'       => (int) $this->business_count,
+            'business_sum'         => number_format((float) $this->business_sum, 2, ',', '.'),
+
+            'non_business_count'   => (int) $this->non_business_count,
+            'non_business_sum'     => number_format((float) $this->non_business_sum, 2, ',', '.'),
+
+            'spatial_count'        => (int) $this->spatial_count,
+            'spatial_sum'          => number_format((float) $this->spatial_sum, 2, ',', '.'),
+
+            'year'                 => $this->year,
+            'created_at' => $this->created_at->toDateTimeString(),
+        ];
+    }
+}

app/Http/Resources/CustomersResource.php

@@ -0,0 +1,19 @@
+<?php
+
+namespace App\Http\Resources;
+
+use Illuminate\Http\Request;
+use Illuminate\Http\Resources\Json\JsonResource;
+
+class CustomersResource extends JsonResource
+{
+    /**
+     * Transform the resource into an array.
+     *
+     * @return array<string, mixed>
+     */
+    public function toArray(Request $request): array
+    {
+        return parent::toArray($request);
+    }
+}

app/Http/Resources/MenuResource.php

@@ -0,0 +1,19 @@
+<?php
+
+namespace App\Http\Resources;
+
+use Illuminate\Http\Request;
+use Illuminate\Http\Resources\Json\JsonResource;
+
+class MenuResource extends JsonResource
+{
+    /**
+     * Transform the resource into an array.
+     *
+     * @return array<string, mixed>
+     */
+    public function toArray(Request $request): array
+    {
+        return parent::toArray($request);
+    }
+}

app/Http/Resources/SpatialPlanningResource.php

@@ -0,0 +1,19 @@
+<?php
+
+namespace App\Http\Resources;
+
+use Illuminate\Http\Request;
+use Illuminate\Http\Resources\Json\JsonResource;
+
+class SpatialPlanningResource extends JsonResource
+{
+    /**
+     * Transform the resource into an array.
+     *
+     * @return array<string, mixed>
+     */
+    public function toArray(Request $request): array
+    {
+        return parent::toArray($request);
+    }
+}

app/Http/Resources/SpatialPlanningsResource.php

@@ -0,0 +1,19 @@
+<?php
+
+namespace App\Http\Resources;
+
+use Illuminate\Http\Request;
+use Illuminate\Http\Resources\Json\JsonResource;
+
+class SpatialPlanningsResource extends JsonResource
+{
+    /**
+     * Transform the resource into an array.
+     *
+     * @return array<string, mixed>
+     */
+    public function toArray(Request $request): array
+    {
+        return parent::toArray($request);
+    }
+}

app/Http/Resources/TourismResource.php

@@ -0,0 +1,19 @@
+<?php
+
+namespace App\Http\Resources;
+
+use Illuminate\Http\Request;
+use Illuminate\Http\Resources\Json\JsonResource;
+
+class TourismResource extends JsonResource
+{
+    /**
+     * Transform the resource into an array.
+     *
+     * @return array<string, mixed>
+     */
+    public function toArray(Request $request): array
+    {
+        return parent::toArray($request);
+    }
+}

app/Http/Resources/UmkmResource.php

@@ -0,0 +1,19 @@
+<?php
+
+namespace App\Http\Resources;
+
+use Illuminate\Http\Request;
+use Illuminate\Http\Resources\Json\JsonResource;
+
+class UmkmResource extends JsonResource
+{
+    /**
+     * Transform the resource into an array.
+     *
+     * @return array<string, mixed>
+     */
+    public function toArray(Request $request): array
+    {
+        return parent::toArray($request);
+    }
+}

app/Imports/AdvertisementImport.php

@@ -47,7 +47,7 @@ class AdvertisementImport implements ToCollection
             $districtCode = $districts[$districtName] ?? null;
 
             $listTrueVillage = DB::table('villages')
-                ->where('district_code', $districtCode) // Perbaikan pada where()
+                ->where('district_code', $districtCode)
                 ->get()
                 ->mapWithKeys(function ($item) {
                     return [strtolower(trim($item->village_name)) => [

app/Imports/BusinessIndustriesImport.php

@@ -0,0 +1,107 @@
+<?php
+
+namespace App\Imports;
+
+use App\Models\BusinessOrIndustry;
+use Illuminate\Support\Collection;
+use Maatwebsite\Excel\Concerns\ToCollection;
+use Maatwebsite\Excel\Concerns\WithChunkReading;
+use Maatwebsite\Excel\Concerns\WithHeadingRow;
+use Maatwebsite\Excel\Concerns\WithMultipleSheets;
+use Illuminate\Contracts\Queue\ShouldQueue;
+use Maatwebsite\Excel\Concerns\WithBatchInserts;
+use Illuminate\Support\Facades\Log;
+
+class BusinessIndustriesImport implements ToCollection, WithMultipleSheets, WithChunkReading, WithBatchInserts, ShouldQueue, WithHeadingRow
+{
+    /**
+    * @param Collection $collection
+    */    
+    public function collection(Collection $collection)
+    {
+        try{
+            $batchData = [];
+            $batchSize = 1000;
+    
+            foreach ($collection as $row){
+                if(!isset($row['nop']) || empty($row['nop'])){
+                    continue;
+                }
+    
+    
+                $clean_nop = preg_replace('/[^A-Za-z0-9]/', '', $row['nop']);
+    
+                $batchData[] = [
+                        'nama_kecamatan'     => $row['nama_kecamatan'],
+                        'nama_kelurahan'     => $row['nama_kelurahan'],
+                        'nop'                => $clean_nop,
+                        'nama_wajib_pajak'   => $row['nama_wajib_pajak'],
+                        'alamat_wajib_pajak' => $row['alamat_wajib_pajak'], 
+                        'alamat_objek_pajak' => $row['alamat_objek_pajak'], 
+                        'luas_bumi'          => $row['luas_bumi'], 
+                        'luas_bangunan'      => $row['luas_bangunan'], 
+                        'njop_bumi'          => $row['njop_bumi'], 
+                        'njop_bangunan'      => $row['njop_bangunan'], 
+                        'ketetapan'          => $row['ketetapan'], 
+                        'tahun_pajak'        => $row['tahun_pajak'], 
+                ];
+    
+                if(count($batchData) >= $batchSize){
+                    BusinessOrIndustry::upsert($batchData, ['nop'], [
+                        'nama_kecamatan',
+                        'nama_kelurahan',
+                        'nama_wajib_pajak',
+                        'alamat_wajib_pajak',
+                        'alamat_objek_pajak',
+                        'luas_bumi',
+                        'luas_bangunan',
+                        'njop_bumi',
+                        'njop_bangunan',
+                        'ketetapan',
+                        'tahun_pajak',
+                    ]);
+                    $batchData = [];
+                }
+            }
+            if(!empty($batchData)){
+                BusinessOrIndustry::upsert($batchData, ['nop'], [
+                    'nama_kecamatan',
+                    'nama_kelurahan',
+                    'nama_wajib_pajak',
+                    'alamat_wajib_pajak',
+                    'alamat_objek_pajak',
+                    'luas_bumi',
+                    'luas_bangunan',
+                    'njop_bumi',
+                    'njop_bangunan',
+                    'ketetapan',
+                    'tahun_pajak',
+                ]);
+            }
+        }catch(\Exception $exception){
+            Log::error('Error while importing Business Industries data:', ['error' => $exception->getMessage()]);
+            return;
+        }
+    }
+
+    public function sheets(): array {
+        return [
+            0 => $this
+        ];
+    }
+
+    public function headingRow(): int
+    {
+        return 1;
+    }
+
+    public function chunkSize(): int
+    {
+        return 1000;
+    }
+
+    public function batchSize(): int
+    {
+        return 1000;
+    }
+}

app/Imports/CustomersImport.php

@@ -0,0 +1,92 @@
+<?php
+
+namespace App\Imports;
+
+use App\Models\Customer;
+use Illuminate\Support\Collection;
+use Maatwebsite\Excel\Concerns\ToCollection;
+use Maatwebsite\Excel\Concerns\WithLimit;
+use Maatwebsite\Excel\Concerns\WithChunkReading;
+use Maatwebsite\Excel\Concerns\WithHeadingRow;
+use Maatwebsite\Excel\Concerns\WithMultipleSheets;
+use Illuminate\Contracts\Queue\ShouldQueue;
+use Maatwebsite\Excel\Concerns\WithBatchInserts;
+use Illuminate\Support\Facades\Log;
+
+class CustomersImport implements ToCollection, WithMultipleSheets, WithChunkReading, WithBatchInserts, ShouldQueue, WithHeadingRow
+{
+    /**
+    * @param Collection $collection
+    */    
+    public function collection(Collection $collection)
+    {
+        $batchData = [];
+        $batchSize = 1000;
+
+        foreach ($collection as $row) {
+            if (!isset($row['nomor_pelanggan']) || empty($row['nomor_pelanggan'])) {
+                continue;
+            }
+
+            $latitude = '0';
+            $longitude = '0';
+
+            if (isset($row['latkor']) && !empty(trim($row['latkor']))) {
+                $latitude = str_replace(',', '.', trim($row['latkor']));
+                if (is_numeric($latitude)) {
+                    $latitude = bcadd($latitude, '0', 18); 
+                } else {
+                    $latitude = '0'; 
+                }
+            } else {
+                $latitude = '0';
+            }
+
+            if (isset($row['lonkor']) && !empty(trim($row['lonkor']))) {
+                $longitude = str_replace(',', '.', trim($row['lonkor'])); 
+                if (is_numeric($longitude)) {
+                    $longitude = bcadd($longitude, '0', 18); 
+                } else {
+                    $longitude = '0';
+                }
+            } else {
+                $longitude = '0';
+            }
+
+            $batchData[] = [
+                'nomor_pelanggan' => $row['nomor_pelanggan'] ?? '',
+                'kota_pelayanan' => $row['kota_pelayanan'] ?? '',
+                'nama' => $row['nama'] ?? '',
+                'alamat' => $row['alamat'] ?? '',
+                'latitude' => $latitude,
+                'longitude' => $longitude,
+            ];
+
+            if (count($batchData) >= $batchSize) {
+                Customer::upsert($batchData, ['nomor_pelanggan'], ['kota_pelayanan', 'nama', 'alamat', 'latitude', 'longitude']);
+                $batchData = [];
+            }
+        }
+
+        if (!empty($batchData)) {
+            Customer::upsert($batchData, ['nomor_pelanggan'], ['kota_pelayanan', 'nama', 'alamat', 'latitude', 'longitude']);
+        }
+    }
+
+
+    public function sheets(): array {
+        return [
+            0 => $this
+        ];
+    }
+
+    public function chunkSize(): int
+    {
+        return 1000;
+    }
+
+    public function batchSize(): int
+    {
+        return 1000;
+    }
+}

app/Imports/SpatialPlanningImport.php

@@ -0,0 +1,63 @@
+<?php
+
+namespace App\Imports;
+
+use App\Models\SpatialPlanning;
+use Illuminate\Support\Collection;
+use Maatwebsite\Excel\Concerns\ToCollection;
+use Illuminate\Support\Facades\DB;
+use DateTime;
+use Carbon\Carbon;
+
+class SpatialPlanningImport implements ToCollection
+{
+    protected static $processed = false;
+
+    /**
+     * Process each row in the file
+     */
+    public function collection(Collection $rows)
+    {
+        if (self::$processed) {
+            return;
+        }
+        self::$processed = true;
+
+        if ($rows->isEmpty())
+        {
+            return;
+        }
+
+        //cari header secara otomatis
+        $header = $rows->first();
+        $headerIndex = collect($header)->search(fn($value) => !empty($value));
+
+        // Pastikan header ditemukan
+        if ($headerIndex === false) {
+            return;
+        }
+
+        foreach ($rows->skip(1) as $row) {
+            $dateValue = trim($row[7]);
+            info($dateValue);
+            $parsedDate = Carbon::createFromFormat('Y-m-d', $dateValue)->format('Y-m-d');
+            info($parsedDate); 
+
+            $dataToInsert[] = [
+                'name'=>$row[1],
+                'kbli'=>$row[2],
+                'activities'=>$row[3],
+                'area'=>$row[4],
+                'location'=>$row[5],
+                'number'=>$row[6],
+                'date'=>$parsedDate,
+            ];
+        }
+
+        if(!empty($dataToInsert)) {
+            SpatialPlanning::insert($dataToInsert);
+        } else {
+            return;
+        }
+    }
+}

app/Imports/TourismImport.php

@@ -0,0 +1,113 @@
+<?php
+
+namespace App\Imports;
+
+use App\Models\Tourism;
+use Illuminate\Support\Collection;
+use Maatwebsite\Excel\Concerns\ToCollection;
+use Illuminate\Support\Facades\DB;
+use DateTime;
+use Carbon\Carbon;
+
+class TourismImport implements ToCollection
+{
+    protected static $processed = false;
+    /**
+     * Process each row in the file.
+     */
+    public function collection(Collection $rows)
+    {
+        if (self::$processed) {
+            return;
+        }
+        self::$processed = true;
+
+        if ($rows->isEmpty())
+        {
+            return;
+        }
+
+        // Ambil data districts dengan normalisasi nama
+        $districts = DB::table('districts')
+            ->get()
+            ->mapWithKeys(function ($item) {
+                return [strtolower(trim($item->district_name)) => $item->district_code];
+            })
+            ->toArray();
+        // Cari header secara otomatis
+        $header = $rows->first();
+        $headerIndex = collect($header)->search(fn($value) => !empty($value));
+
+        // Pastikan header ditemukan
+        if ($headerIndex === false) {
+            return;
+        }
+        
+        foreach ($rows->skip(1) as $row) {
+            // Normalisasi nama kecamatan dan desa
+            $districtName = strtolower(trim(str_replace('Kecamatan', '', $row[12])));
+            $villageName = strtolower(trim($row[13]));
+
+            // Cari distric_code dari table districts
+            $districtCode = $districts[$districtName] ?? null;
+
+            $listTrueVillage = DB::table('villages')
+                ->where('district_code', $districtCode)
+                ->get()
+                ->mapWithKeys(function ($item) {
+                    return [strtolower(trim($item->village_name)) => [
+                        'village_code' => $item->village_code,
+                        'district_code' => $item->district_code
+                    ]];
+                })
+                ->toArray();
+            
+            // ambill village code yang village_name sama dengan $villageName
+            $villageCode = $listTrueVillage[$villageName]['village_code'] ?? '000000';
+
+            $excelSerialDate = $row[16];
+            if (is_numeric($excelSerialDate)) {
+                $projectSubmissionDate = Carbon::createFromFormat('Y-m-d', '1899-12-30')
+                    ->addDays($excelSerialDate)
+                    ->format('Y-m-d H:i:s');
+            } else {
+                $projectSubmissionDate = Carbon::createFromFormat('m/d/Y', $excelSerialDate)
+                    ->format('Y-m-d H:i:s');
+            }
+
+            $dataToInsert[] = [
+                'project_id' => $row[1],
+                'project_type_id' => $row[2],
+                'nib' => $row[3],
+                'business_name' => $row[4],
+                'oss_publication_date' => DateTime::createFromFormat('d/m/Y', $row[5]),
+                'investment_status_description' => $row[6],
+                'business_form' => $row[7],
+                'project_risk' => $row[8],
+                'project_name' => $row[9],
+                'business_scale' => $row[10],
+                'business_address' => $row[12],
+                'district_code' => $districtCode,
+                'village_code' => $villageCode,
+                'longitude' => $row[14],
+                'latitude' => (string) $row[15],
+                'project_submission_date' => $projectSubmissionDate,
+                'kbli'=> $row[17],
+                'kbli_title'=>$row[18],
+                'supervisory_sector'=>$row[19],
+                'user_name'=>$row[20],
+                'email'=>$row[21],
+                'contact'=>$row[22],
+                'land_area_in_m2'=>$row[23],
+                'investment_amount'=>$row[24],
+                'tki'=>$row[25]
+            ];
+        }
+
+        if(!empty($dataToInsert)) {
+            Tourism::insert($dataToInsert);
+        } else {
+            return;
+        }
+    }
+}

app/Imports/UmkmImport.php

@@ -0,0 +1,98 @@
+<?php
+
+namespace App\Imports;
+
+use App\Models\Umkm;
+use Illuminate\Support\Collection;
+use Maatwebsite\Excel\Concerns\ToCollection;
+use Illuminate\Support\Facades\DB;
+
+class UmkmImport implements ToCollection
+{
+
+    protected static $processed = false;
+    /**
+     * Process each row in the file.
+     */
+    public function collection(Collection $rows)
+    {
+        if (self::$processed) {
+            return;
+        }
+        self::$processed = true;
+
+        if ($rows->isEmpty())
+        {
+            return;
+        }
+
+        // Ambil data districts dengan normalisasi nama
+        $districts = DB::table('districts')
+            ->get()
+            ->mapWithKeys(function ($item) {
+                return [strtolower(trim($item->district_name)) => $item->district_code];
+            })
+            ->toArray();
+        // Cari header secara otomatis
+        $header = $rows->first();
+        $headerIndex = collect($header)->search(fn($value) => !empty($value));
+
+        // Pastikan header ditemukan
+        if ($headerIndex === false) {
+            return;
+        }
+
+        info($rows);
+
+        foreach ($rows->skip(1) as $row) {
+            // Normalisasi nama kecamatan dan desa
+            $districtName = strtolower(trim(str_replace('Kecamatan', '', $row[14])));
+            $villageName = strtolower(trim($row[13]));
+
+            // Cari distric_code dari table districts
+            $districtCode = $districts[$districtName] ?? null;
+
+            $listTrueVillage = DB::table('villages')
+                ->where('district_code', $districtCode)
+                ->get()
+                ->mapWithKeys(function ($item) {
+                    return [strtolower(trim($item->village_name)) => [
+                        'village_code' => $item->village_code,
+                        'district_code' => $item->district_code
+                    ]];
+                })
+                ->toArray();
+            
+            // ambil village code yang village_name sama dengan $villageName
+            $villageCode = $listTrueVillage[$villageName]['village_code'] ?? '0000';
+
+            $dataToInsert[] = [
+                'business_name' => $row[0],
+                'business_address' => $row[1],
+                'business_desc' => $row[2],
+                'business_contact' => $row[3],
+                'business_id_number' => $row[4],
+                'business_scale_id' => $row[5],
+                'owner_id' => $row[6],
+                'owner_name' => $row[7],
+                'owner_address' => $row[8],
+                'owner_contact' => $row[9],
+                'business_type' => $row[10],
+                'business_form_id' => $row[11],
+                'revenue' => $row[12],
+                'village_code' => $villageCode,
+                'district_code' => $districtCode,
+                'number_of_employee' => $row[15],
+                'land_area' => $row[16],
+                'permit_status_id' => $row[17],
+            ];
+        }
+
+        info($dataToInsert);
+        if (!empty($dataToInsert)) {
+            Umkm::insert($dataToInsert);
+        } else {
+            return;
+        }
+    }
+}

app/Models/BigdataResume.php

@@ -21,6 +21,9 @@ class BigdataResume extends Model
         'business_sum',
         'non_business_count',
         'non_business_sum',
+        'spatial_count',
+        'spatial_sum',
+        'year'
     ];
 
     public function importDatasource()
@@ -28,88 +31,78 @@ class BigdataResume extends Model
         return $this->belongsTo(ImportDatasource::class, 'import_datasource_id');
     }
 
-    public static function generateResumeData($import_datasource_id){
+    public static function generateResumeData($import_datasource_id, $year){
-        $query_verified = once( function () {
+        $stats = PbgTask::with(['googleSheet', 'pbg_task_retributions'])
-            return DB::table('pbg_task AS pt')
+            ->leftJoin('pbg_task_retributions as ptr', 'pbg_task.uuid', '=', 'ptr.pbg_task_uid')
-                ->leftJoin('pbg_task_google_sheet AS ptgs', 'pt.registration_number', '=', 'ptgs.no_registrasi')
+            ->leftJoin('pbg_task_google_sheet as ptgs', 'pbg_task.registration_number', '=', 'ptgs.no_registrasi')
-                ->leftJoin('pbg_task_retributions AS ptr', 'pt.uuid', '=', 'ptr.pbg_task_uid')
+            ->when($year !== 'all', function ($query) use ($year) {
-                ->whereRaw('LOWER(TRIM(ptgs.status_verifikasi)) = ?', [strtolower(trim('Selesai Verifikasi'))])
+                $query->whereYear('pbg_task.task_created_at', (int) $year);
-                ->selectRaw('COUNT(pt.id) AS total_data, 
-                            SUM(ptr.nilai_retribusi_bangunan) AS total_retribution') 
-                ->first();
-        }); 
-
-        $verified_count = $query_verified->total_data ?? 0;
-        $verified_total = $query_verified->total_retribution ?? 0;
-
-        $query_business = once(function () {
-            return DB::table('pbg_task AS pt')
-                ->leftJoin('pbg_task_google_sheet AS ptgs', 'pt.registration_number', '=', 'ptgs.no_registrasi')
-                ->leftJoin('pbg_task_retributions AS ptr', 'pt.uuid', '=', 'ptr.pbg_task_uid')
-                ->where(function ($query) {
-                    $query->whereRaw('LOWER(TRIM(ptgs.status_verifikasi)) != ?', [strtolower(trim('Selesai Verifikasi'))])
-                        ->orWhereNull('ptgs.status_verifikasi');
-                })
-                ->where(function ($query) {
-                    $query->whereRaw('LOWER(TRIM(pt.function_type)) = ?', [strtolower(trim('Sebagai Tempat Usaha'))]);
-                })
-                ->selectRaw('COUNT(pt.id) AS total_data, 
-                            SUM(ptr.nilai_retribusi_bangunan) AS total_retribution')
-                ->first();
-        });
-
-        $business_count = $query_business->total_data ?? 0;
-        $business_total = $query_business->total_retribution ?? 0;
-
-        $query_non_business = once( function () {
-            return DB::table('pbg_task AS pt')
-            ->leftJoin('pbg_task_google_sheet AS ptgs', 'pt.registration_number', '=', 'ptgs.no_registrasi')
-            ->leftJoin('pbg_task_retributions AS ptr', 'pt.uuid', '=', 'ptr.pbg_task_uid') // Join ke pbg_task_retributions
-            ->where(function ($query) {
-                $query->whereRaw('LOWER(TRIM(ptgs.status_verifikasi)) != ?', [strtolower(trim('Selesai Verifikasi'))])
-                    ->orWhereNull('ptgs.status_verifikasi'); // Include NULL values
             })
-            ->where(function ($query) {
+            ->selectRaw("
-                $query->whereRaw('LOWER(TRIM(pt.function_type)) != ?', [strtolower(trim('Sebagai Tempat Usaha'))])
+                COUNT(CASE WHEN LOWER(TRIM(ptgs.status_verifikasi)) = 'selesai verifikasi' THEN 1 END) AS verified_count,
-                    ->orWhereNull('pt.function_type'); // Include NULL values
+                SUM(CASE WHEN LOWER(TRIM(ptgs.status_verifikasi)) = 'selesai verifikasi' THEN ptr.nilai_retribusi_bangunan ELSE 0 END) AS verified_total,
-            })
+                
-            ->selectRaw('COUNT(pt.id) AS total_data, 
+                COUNT(CASE WHEN LOWER(TRIM(ptgs.status_verifikasi)) != 'selesai verifikasi' OR ptgs.status_verifikasi IS NULL THEN 1 END) AS non_verified_count,
-                        SUM(ptr.nilai_retribusi_bangunan) AS total_retribution') // Menambahkan SUM dari pbg_task_retributions
+                SUM(CASE WHEN LOWER(TRIM(ptgs.status_verifikasi)) != 'selesai verifikasi' OR ptgs.status_verifikasi IS NULL THEN ptr.nilai_retribusi_bangunan ELSE 0 END) AS non_verified_total,
-            ->first();
+                
-        });
+                COUNT(CASE WHEN (LOWER(TRIM(ptgs.status_verifikasi)) != 'selesai verifikasi' OR ptgs.status_verifikasi IS NULL) 
-        $non_business_count = $query_non_business->total_data ?? 0;
+                        AND LOWER(TRIM(pbg_task.function_type)) = 'sebagai tempat usaha' THEN 1 END) AS business_count,
-        $non_business_total = $query_non_business->total_retribution ?? 0;
+                SUM(CASE WHEN (LOWER(TRIM(ptgs.status_verifikasi)) != 'selesai verifikasi' OR ptgs.status_verifikasi IS NULL) 
+                        AND LOWER(TRIM(pbg_task.function_type)) = 'sebagai tempat usaha' THEN ptr.nilai_retribusi_bangunan ELSE 0 END) AS business_total,
 
-        $query_non_verified = once(function () {
+                COUNT(CASE WHEN (LOWER(TRIM(ptgs.status_verifikasi)) != 'selesai verifikasi' OR ptgs.status_verifikasi IS NULL) 
-            return DB::table('pbg_task AS pt')
+                        AND (LOWER(TRIM(pbg_task.function_type)) != 'sebagai tempat usaha' OR pbg_task.function_type IS NULL) THEN 1 END) AS non_business_count,
-            ->leftJoin('pbg_task_google_sheet AS ptgs', 'pt.registration_number', '=', 'ptgs.no_registrasi')
+                SUM(CASE WHEN (LOWER(TRIM(ptgs.status_verifikasi)) != 'selesai verifikasi' OR ptgs.status_verifikasi IS NULL) 
-            ->leftJoin('pbg_task_retributions AS ptr', 'pt.uuid', '=', 'ptr.pbg_task_uid') // Join tabel pbg_task_retributions
+                        AND (LOWER(TRIM(pbg_task.function_type)) != 'sebagai tempat usaha' OR pbg_task.function_type IS NULL) THEN ptr.nilai_retribusi_bangunan ELSE 0 END) AS non_business_total
-            ->where(function ($query) {
+            ")
-                $query->whereRaw('LOWER(TRIM(ptgs.status_verifikasi)) != ?', [strtolower(trim('Selesai Verifikasi'))])
-                    ->orWhereNull('ptgs.status_verifikasi'); // Include NULL values
-            })
-            ->selectRaw('COUNT(pt.id) AS total_data, 
-                        SUM(ptr.nilai_retribusi_bangunan) AS total_retribution') // Menambahkan SUM dari pbg_task_retributions
             ->first();
+
+        // Assign Results
+        $verified_count = $stats->verified_count ?? 0;
+        $verified_total = $stats->verified_total ?? 0;
+        $non_verified_count = $stats->non_verified_count ?? 0;
+        $non_verified_total = $stats->non_verified_total ?? 0;
+        $business_count = $stats->business_count ?? 0;
+        $business_total = $stats->business_total ?? 0;
+        $non_business_count = $stats->non_business_count ?? 0;
+        $non_business_total = $stats->non_business_total ?? 0;
+
+        $query_potention = once(function () use ($year) {
+            $query = PbgTask::leftJoin('pbg_task_retributions as ptr', 'pbg_task.uuid', '=', 'ptr.pbg_task_uid')
+                ->selectRaw('COUNT(DISTINCT pbg_task.id) as task_count, SUM(ptr.nilai_retribusi_bangunan) as total_retribution');
+
+            if ($year !== 'all') {
+                $query->whereYear('pbg_task.task_created_at', (int) $year);
+            }
+
+            return $query->first();
         });
 
-        $non_verified_count = $query_non_verified->total_data ?? 0;
-        $non_verified_total = $query_non_verified->total_retribution ?? 0;
-
-        $query_potention = once( function () {
-            return DB::table('pbg_task as pt')
-            ->leftJoin('pbg_task_retributions as ptr', 'pt.uuid', '=', 'ptr.pbg_task_uid')
-            ->select(
-                DB::raw('COUNT(DISTINCT pt.id) as task_count'),
-                DB::raw('SUM(ptr.nilai_retribusi_bangunan) as total_retribution')
-            )
-            ->first();
-        });
         $potention_count = $query_potention->task_count ?? 0;
         $potention_total = $query_potention->total_retribution ?? 0;
 
+        $query_spatial_plannings = once(function () use ($year) {
+            $query = PbgTask::join('spatial_plannings as sp', 'pbg_task.document_number', '=', 'sp.number')
+                ->join('pbg_task_retributions as ptr', 'ptr.pbg_task_uid', '=', 'pbg_task.uuid')
+                ->selectRaw('COUNT(DISTINCT pbg_task.id) as task_count, SUM(ptr.nilai_retribusi_bangunan) as total_retribution');
+
+            if ($year !== 'all') {
+                $query->whereYear('pbg_task.task_created_at', (int) $year);
+            }
+
+            return $query->first();
+        });
+
+        $spatial_planning_count = $query_spatial_plannings->task_count ?? 0;
+        $spatial_planning_total = $query_spatial_plannings->total_retribution ?? 0;
+
+        $potention_count -= $spatial_planning_count;
+        $potention_total -= $spatial_planning_total;
+
         return self::create([
             'import_datasource_id' => $import_datasource_id,
+            'spatial_count' => $spatial_planning_count,
+            'spatial_sum' => $spatial_planning_total ?? 0.00,
             'potention_count' => $potention_count ?? 0,
             'potention_sum' => $potention_total ?? 0.00,
             'non_verified_count' => $non_verified_count ?? 0,
@@ -120,6 +113,7 @@ class BigdataResume extends Model
             'business_sum' => $business_total ?? 0.00,
             'non_business_count' => $non_business_count ?? 0,
             'non_business_sum' => $non_business_total ?? 0.00,
+            'year' => $year
         ]);
     }
 }

app/Models/BusinessOrIndustry.php

@@ -0,0 +1,24 @@
+<?php
+
+namespace App\Models;
+
+use Illuminate\Database\Eloquent\Model;
+
+class BusinessOrIndustry extends Model
+{
+    protected $table = "business_or_industries";
+    protected $fillable = [
+        'nama_kecamatan',
+        'nama_kelurahan',
+        'nop',
+        'nama_wajib_pajak',
+        'alamat_wajib_pajak',
+        'alamat_objek_pajak',
+        'luas_bumi',
+        'luas_bangunan',
+        'njop_bumi',
+        'njop_bangunan',
+        'ketetapan',
+        'tahun_pajak',
+    ];
+}

app/Models/Customer.php

@@ -0,0 +1,20 @@
+<?php
+
+namespace App\Models;
+
+use Illuminate\Database\Eloquent\Model;
+
+class Customer extends Model
+{
+    protected $table = 'customers';
+    protected $fillable = [
+        'nomor_pelanggan',
+        'kota_pelayanan',
+        'nama',
+        'alamat',
+        'latitude',
+        'longitude',
+    ];
+
+    
+}

app/Models/PbgTask.php

@@ -37,4 +37,8 @@ class PbgTask extends Model
     public function pbg_task_index_integrations(){
         return $this->hasOne(PbgTaskIndexIntegrations::class, 'pbg_task_uid', 'uuid');
     }
+
+    public function googleSheet(){
+        return $this->hasOne(PbgTaskGoogleSheet::class, 'no_registrasi', 'registration_number');
+    }
 }

app/Models/SpatialPlanning.php

@@ -0,0 +1,37 @@
+<?php
+
+namespace App\Models;
+
+use Illuminate\Database\Eloquent\Model;
+
+/**
+ * Class SpatialPlanning
+ *
+ * @property $id
+ * @property $created_at
+ * @property $updated_at
+ * @property $name
+ * @property $kbli
+ * @property $activities
+ * @property $area
+ * @property $location
+ * @property $number
+ * @property $date
+ *
+ * @package App
+ * @mixin \Illuminate\Database\Eloquent\Builder
+ */
+class SpatialPlanning extends Model
+{
+    
+    protected $perPage = 20;
+
+    /**
+     * The attributes that are mass assignable.
+     *
+     * @var array<int, string>
+     */
+    protected $fillable = ['name', 'kbli', 'activities', 'area', 'location', 'number', 'date'];
+
+
+}

app/Models/Tourism.php

@@ -0,0 +1,55 @@
+<?php
+
+namespace App\Models;
+
+use Illuminate\Database\Eloquent\Model;
+
+/**
+ * Class Tourism
+ *
+ * @property $id
+ * @property $created_at
+ * @property $updated_at
+ * @property $project_id
+ * @property $project_type_id
+ * @property $nib
+ * @property $business_name
+ * @property $oss_publication_date
+ * @property $investment_status_description
+ * @property $business_form
+ * @property $project_risk
+ * @property $project_name
+ * @property $business_scale
+ * @property $business_address
+ * @property $district_code
+ * @property $village_code
+ * @property $longitude
+ * @property $latitude
+ * @property $project_submission_date
+ * @property $kbli
+ * @property $kbli_title
+ * @property $supervisory_sector
+ * @property $user_name
+ * @property $email
+ * @property $contact
+ * @property $land_area_in_m2
+ * @property $investment_amount
+ * @property $tki
+ *
+ * @package App
+ * @mixin \Illuminate\Database\Eloquent\Builder
+ */
+class Tourism extends Model
+{
+    
+    protected $perPage = 20;
+
+    /**
+     * The attributes that are mass assignable.
+     *
+     * @var array<int, string>
+     */
+    protected $fillable = ['project_id', 'project_type_id', 'nib', 'business_name', 'oss_publication_date', 'investment_status_description', 'business_form', 'project_risk', 'project_name', 'business_scale', 'business_address', 'district_code', 'village_code', 'longitude', 'latitude', 'project_submission_date', 'kbli', 'kbli_title', 'supervisory_sector', 'user_name', 'email', 'contact', 'land_area_in_m2', 'investment_amount', 'tki'];
+
+
+}

app/Models/TourismBasedKBLI.php

@@ -0,0 +1,14 @@
+<?php
+
+namespace App\Models;
+
+use Illuminate\Database\Eloquent\Model;
+
+class TourismBasedKBLI extends Model
+{
+    protected $table = 'v_tourisms_based_kbli';
+    protected $primaryKey = null;
+
+    public $timestamps = false;
+    protected $fillable = ['kbli_title', 'total_records'];
+}

app/Models/Umkm.php

@@ -0,0 +1,48 @@
+<?php
+
+namespace App\Models;
+
+use Illuminate\Database\Eloquent\Model;
+
+/**
+ * Class Umkm
+ *
+ * @property $id
+ * @property $created_at
+ * @property $updated_at
+ * @property $business_name
+ * @property $business_address
+ * @property $business_desc
+ * @property $business_contact
+ * @property $business_id_number
+ * @property $business_scale_id
+ * @property $owner_id
+ * @property $owner_name
+ * @property $owner_address
+ * @property $owner_contact
+ * @property $business_type
+ * @property $business_form_id
+ * @property $revenue
+ * @property $village_code
+ * @property $distric_code
+ * @property $number_of_employee
+ * @property $land_area
+ * @property $permit_status_id
+ *
+ * @package App
+ * @mixin \Illuminate\Database\Eloquent\Builder
+ */
+class Umkm extends Model
+{
+    
+    protected $perPage = 20;
+
+    /**
+     * The attributes that are mass assignable.
+     *
+     * @var array<int, string>
+     */
+    protected $fillable = ['business_name', 'business_address', 'business_desc', 'business_contact', 'business_id_number', 'business_scale_id', 'owner_id', 'owner_name', 'owner_address', 'owner_contact', 'business_type', 'business_form_id', 'revenue', 'village_code', 'district_code', 'number_of_employee', 'land_area', 'permit_status_id'];
+
+
+}

app/Services/GoogleSheetService.php

@@ -140,4 +140,13 @@ class GoogleSheetService
             throw $e;
         }
     }
+    public function get_data_by_sheet($no_sheet = 1){
+        $spreadsheet = $this->service->spreadsheets->get($this->spreadsheetID);
+        $sheets = $spreadsheet->getSheets();
+        $sheetTitle = $sheets[$no_sheet]->getProperties()->getTitle();
+        $range = "{$sheetTitle}";
+        $response = $this->service->spreadsheets_values->get($this->spreadsheetID, $range);
+        $values = $response->getValues();
+        return!empty($values)? $values : [];
+    }
 }

app/Services/ServiceSIMBG.php

@@ -29,10 +29,15 @@ class ServiceSIMBG
      */
     public function __construct()
     {
-        $this->email = trim((string) GlobalSetting::where('key','SIMBG_EMAIL')->firstOrFail()->value);
+        $settings = GlobalSetting::whereIn('key', [
-        $this->password = trim((string) GlobalSetting::where('key','SIMBG_PASSWORD')->firstOrFail()->value);
+            'SIMBG_EMAIL', 'SIMBG_PASSWORD', 'SIMBG_HOST', 'FETCH_PER_PAGE'
-        $this->simbg_host = trim((string)GlobalSetting::where('key','SIMBG_HOST')->firstOrFail()->value);
+        ])->pluck('value', 'key');
-        $this->fetch_per_page = trim((string)GlobalSetting::where('key','FETCH_PER_PAGE')->firstOrFail()->value);
+    
+        $this->email = trim((string) ($settings['SIMBG_EMAIL'] ?? ""));
+        $this->password = trim((string) ($settings['SIMBG_PASSWORD'] ?? ""));
+        $this->simbg_host = trim((string) ($settings['SIMBG_HOST'] ?? ""));
+        $this->fetch_per_page = trim((string) ($settings['FETCH_PER_PAGE'] ?? ""));
+    
         $this->service_client = new ServiceClient($this->simbg_host);
     }
 
@@ -56,32 +61,37 @@ class ServiceSIMBG
         }
     }
 
-    public function syncIndexIntegration($uuid, $token)
+    public function syncIndexIntegration($uuids, $token)
     {
         try{
-            $url = "/api/pbg/v1/detail/" . $uuid . "/retribution/indeks-terintegrasi/";
+            if(empty($uuids)){
-    
-            $headers = [
-                'Authorization' => "Bearer " . $token,
-            ];
-        
-            $res = $this->service_client->get($url, $headers);
-        
-            if (empty($res->original['success']) || !$res->original['success']) {
-                // Log error
-                Log::error("API response indicates failure", ['url' => $url, 'uuid' => $uuid]);
                 return false;
             }
+            
+            $integrations = [];
+            foreach($uuids as $uuid){
+                $url = "/api/pbg/v1/detail/" . $uuid . "/retribution/indeks-terintegrasi/";
         
-            $data = $res->original['data']['data'] ?? null;
+                $headers = [
-            if (!$data) {
+                    'Authorization' => "Bearer " . $token,
-                Log::error("No valid data returned from API", ['url' => $url, 'uuid' => $uuid]);
+                ];
-                return false;
+            
-            }
+                $res = $this->service_client->get($url, $headers);
-        
+            
-            $resultData = PbgTaskIndexIntegrations::updateOrCreate(
+                if (empty($res->original['success']) || !$res->original['success']) {
-                ['pbg_task_uid' => $uuid],
+                    // Log error
-                [
+                    Log::error("API response indicates failure", ['url' => $url, 'uuid' => $uuid]);
+                    continue;
+                }
+            
+                $data = $res->original['data']['data'] ?? null;
+                if (!$data) {
+                    Log::error("No valid data returned from API", ['url' => $url, 'uuid' => $uuid]);
+                    continue;
+                }
+
+                $integrations[] = [
+                    'pbg_task_uid' => $uuid,
                     'indeks_fungsi_bangunan' => $data['indeks_fungsi_bangunan'] ?? null,
                     'indeks_parameter_kompleksitas' => $data['indeks_parameter_kompleksitas'] ?? null,
                     'indeks_parameter_permanensi' => $data['indeks_parameter_permanensi'] ?? null,
@@ -89,8 +99,11 @@ class ServiceSIMBG
                     'faktor_kepemilikan' => $data['faktor_kepemilikan'] ?? null,
                     'indeks_terintegrasi' => $data['indeks_terintegrasi'] ?? null,
                     'total' => $data['total'] ?? null,
-                ]
+                ];
-            );
+            }
+
+            PbgTaskIndexIntegrations::upsert($integrations, ['pbg_task_uid'], ['indeks_fungsi_bangunan', 
+            'indeks_parameter_kompleksitas', 'indeks_parameter_permanensi', 'indeks_parameter_ketinggian', 'faktor_kepemilikan', 'indeks_terintegrasi', 'total']);
             
             return true;
         }catch (Exception $e){
@@ -101,130 +114,136 @@ class ServiceSIMBG
 
     public function syncTaskList()
     {
-        $initResToken = $this->getToken();
+        try {
-
+            $importDatasource = ImportDatasource::create([
-        $importDatasource = ImportDatasource::create([
+                'status' => ImportDatasourceStatus::Processing->value,
-            'status' => ImportDatasourceStatus::Processing->value,
-        ]);
-
-        if (empty($initResToken->original['data']['token']['access'])) {
-            $importDatasource->update([
-                'status' => ImportDatasourceStatus::Failed->value,
-                'message' => 'Failed to retrieve token'
             ]);
-            return $this->resError("Failed to retrieve token");
-        }
 
-        $apiToken = $initResToken->original['data']['token']['access'];
+            if (empty($initResToken->original['data']['token']['access'])) {
-        $headers = ['Authorization' => "Bearer " . $apiToken];
-
-        $url = "/api/pbg/v1/list/?page=1&size={$this->fetch_per_page}&sort=ASC";
-        $initialResponse = $this->service_client->get($url, $headers);
-
-        $totalPage = $initialResponse->original['data']['total_page'] ?? 0;
-        if ($totalPage == 0) {
-            $importDatasource->update([
-                'status' => ImportDatasourceStatus::Failed->value,
-                'message' => 'Invalid response: no total_page'
-            ]);
-            return $this->resError("Invalid response from API");
-        }
-
-        $savedCount = $failedCount = 0;
-
-        for ($currentPage = 1; $currentPage <= $totalPage; $currentPage++) {
-            $pageUrl = "/api/pbg/v1/list/?page={$currentPage}&size={$this->fetch_per_page}&sort=ASC";
-            $getToken = $this->getToken();
-            Log::info("response index integration", ['currentPage' => $currentPage]);
-            if (empty($getToken->original['data']['token']['access'])) {
                 $importDatasource->update([
                     'status' => ImportDatasourceStatus::Failed->value,
                     'message' => 'Failed to retrieve token'
                 ]);
-                break;
+                return $this->resError("Failed to retrieve token");
             }
-            $token = $getToken->original['data']['token']['access'];
-            $headers = ['Authorization' => "Bearer " . $token];
-            $response = $this->service_client->get($pageUrl, $headers);
-            $tasks = $response->original['data']['data'] ?? [];
 
-            if (empty($tasks)) {
+            $initResToken = $this->getToken();
+            $apiToken = $initResToken->original['data']['token']['access'];
+            $headers = ['Authorization' => "Bearer " . $apiToken];
+
+            $url = "/api/pbg/v1/list/?page=1&size={$this->fetch_per_page}&sort=ASC";
+            $initialResponse = $this->service_client->get($url, $headers);
+
+            $totalPage = $initialResponse->original['data']['total_page'] ?? 0;
+            if ($totalPage == 0) {
                 $importDatasource->update([
                     'status' => ImportDatasourceStatus::Failed->value,
-                    'message' => 'No data found on page'
+                    'message' => 'Invalid response: no total_page'
                 ]);
-                Log::warning("No data found on page", ['page' => $currentPage]);
+                return $this->resError("Invalid response from API");
-                break;
             }
 
-            Log::info("executed page", ['page' => $currentPage, 'total' => $totalPage]);
+            $savedCount = $failedCount = 0;
 
-            $tasksCollective = [];
+            for ($currentPage = 1; $currentPage <= $totalPage; $currentPage++) {
-            foreach ($tasks as $item) {
                 try {
-                    $tasksCollective[] = [
+                    $pageUrl = "/api/pbg/v1/list/?page={$currentPage}&size={$this->fetch_per_page}&sort=ASC";
-                        'uuid' => $item['uid'],
-                        'name' => $item['name'],
-                        'owner_name' => $item['owner_name'],
-                        'application_type' => $item['application_type'],
-                        'application_type_name' => $item['application_type_name'],
-                        'condition' => $item['condition'],
-                        'registration_number' => $item['registration_number'],
-                        'document_number' => $item['document_number'],
-                        'address' => $item['address'],
-                        'status' => $item['status'],
-                        'status_name' => $item['status_name'],
-                        'slf_status' => $item['slf_status'] ?? null,
-                        'slf_status_name' => $item['slf_status_name'] ?? null,
-                        'function_type' => $item['function_type'],
-                        'consultation_type' => $item['consultation_type'],
-                        'due_date' => $item['due_date'],
-                        'land_certificate_phase' => $item['land_certificate_phase'],
-                        'task_created_at' => isset($item['created_at']) ? Carbon::parse($item['created_at'])->format('Y-m-d H:i:s') : null,
-                        'updated_at' => now(),
-                        'created_at' => now(),
-                    ];
 
-                    $this->syncIndexIntegration($item['uid'], $token);
+                    Log::info("Fetching tasks", ['currentPage' => $currentPage]);
 
-                    $this->syncTaskDetailSubmit($item['uid'], $token);
+                    $response = $this->service_client->get($pageUrl, $headers);
-                    
+                    $tasks = $response->original['data']['data'] ?? [];
-                    $savedCount++;
+
+                    if (empty($tasks)) {
+                        Log::warning("No data found on page", ['page' => $currentPage]);
+                        continue;
+                    }
+
+                    $tasksCollective = [];
+                    foreach ($tasks as $item) {
+                        try {
+                            $tasksCollective[] = [
+                                'uuid' => $item['uid'],
+                                'name' => $item['name'],
+                                'owner_name' => $item['owner_name'],
+                                'application_type' => $item['application_type'],
+                                'application_type_name' => $item['application_type_name'],
+                                'condition' => $item['condition'],
+                                'registration_number' => $item['registration_number'],
+                                'document_number' => $item['document_number'],
+                                'address' => $item['address'],
+                                'status' => $item['status'],
+                                'status_name' => $item['status_name'],
+                                'slf_status' => $item['slf_status'] ?? null,
+                                'slf_status_name' => $item['slf_status_name'] ?? null,
+                                'function_type' => $item['function_type'],
+                                'consultation_type' => $item['consultation_type'],
+                                'due_date' => $item['due_date'],
+                                'land_certificate_phase' => $item['land_certificate_phase'],
+                                'task_created_at' => isset($item['created_at']) ? Carbon::parse($item['created_at'])->format('Y-m-d H:i:s') : null,
+                                'updated_at' => now(),
+                                'created_at' => now(),
+                            ];
+
+                            $this->syncTaskDetailSubmit($item['uid'], $apiToken);
+                            $savedCount++;
+                        } catch (Exception $e) {
+                            $failedCount++;
+                            Log::error("Failed to process task", [
+                                'error' => $e->getMessage(),
+                                'task' => $item,
+                            ]);
+                            continue; // Skip failed task, continue processing the rest
+                        }
+                    }
+
+                    if (!empty($tasksCollective)) {
+                        PbgTask::upsert($tasksCollective, ['uuid'], [
+                            'name', 'owner_name', 'application_type', 'application_type_name', 'condition',
+                            'registration_number', 'document_number', 'address', 'status', 'status_name',
+                            'slf_status', 'slf_status_name', 'function_type', 'consultation_type', 'due_date',
+                            'land_certificate_phase', 'task_created_at', 'updated_at'
+                        ]);
+
+                        $uuids = array_column($tasksCollective, 'uuid');
+                        $this->syncIndexIntegration($uuids, $apiToken);
+                    }
                 } catch (Exception $e) {
-                    $failedCount++;
+                    Log::error("Failed to process page", [
-                    $importDatasource->update([
-                        'status' => ImportDatasourceStatus::Failed->value,
-                        'message' => "Successfully processed: $savedCount, Failed: $failedCount"
-                    ]);
-                    Log::error("Failed to process task", [
                         'error' => $e->getMessage(),
-                        'task' => $item,
+                        'page' => $currentPage,
                     ]);
-                    break;
+                    continue; // Skip the failed page and move to the next
                 }
             }
 
-            PbgTask::upsert($tasksCollective, ['uuid'], [
+            BigdataResume::generateResumeData($importDatasource->id, "all");
-                'name', 'owner_name', 'application_type', 'application_type_name', 'condition',
+            BigdataResume::generateResumeData($importDatasource->id, now()->year);
-                'registration_number', 'document_number', 'address', 'status', 'status_name',
+
-                'slf_status', 'slf_status_name', 'function_type', 'consultation_type', 'due_date',
+            // Final update after processing all pages
-                'land_certificate_phase', 'task_created_at', 'updated_at'
+            $importDatasource->update([
+                'status' => ImportDatasourceStatus::Success->value,
+                'message' => "Successfully processed: $savedCount, Failed: $failedCount"
             ]);
+            
+            Log::info("syncTaskList completed", ['savedCount' => $savedCount, 'failedCount' => $failedCount]);
+
+            return $this->resSuccess(['savedCount' => $savedCount, 'failedCount' => $failedCount]);
+
+        } catch (Exception $e) {
+            Log::error("syncTaskList failed", ['error' => $e->getMessage()]);
+            if (isset($importDatasource)) {
+                $importDatasource->update([
+                    'status' => ImportDatasourceStatus::Failed->value,
+                    'message' => 'Critical failure: ' . $e->getMessage()
+                ]);
+            }
+            return $this->resError("Critical failure occurred: " . $e->getMessage());
         }
-
-        $importDatasource->update([
-            'status' => ImportDatasourceStatus::Success->value,
-            'message' => "Successfully processed: $savedCount, Failed: $failedCount"
-        ]);
-
-        BigdataResume::generateResumeData($importDatasource->id);
-
-        Log::info("syncTaskList completed", ['savedCount' => $savedCount, 'failedCount' => $failedCount]);
-
-        return $this->resSuccess(['savedCount' => $savedCount, 'failedCount' => $failedCount]);
     }
 
 
+
     public function syncTaskDetailSubmit($uuid, $token)
     {
         try{
@@ -306,5 +325,4 @@ class ServiceSIMBG
         }
     }
 
-}
+}
-

app/View/Components/CustomCircle.php

@@ -0,0 +1,26 @@
+<?php
+
+namespace App\View\Components;
+
+use Closure;
+use Illuminate\Contracts\View\View;
+use Illuminate\View\Component;
+
+class CustomCircle extends Component
+{
+    /**
+     * Create a new component instance.
+     */
+    public function __construct()
+    {
+        //
+    }
+
+    /**
+     * Get the view / contents that represent the component.
+     */
+    public function render(): View|Closure|string
+    {
+        return view('components.custom-circle');
+    }
+}

composer.json

@@ -19,7 +19,6 @@
     },
     "require-dev": {
         "fakerphp/faker": "^1.23",
-        "ibex/crud-generator": "^2.1",
         "laravel/pail": "^1.1",
         "laravel/pint": "^1.13",
         "laravel/sail": "^1.26",

config/queue.php

@@ -109,4 +109,10 @@ return [
         'table' => 'failed_jobs',
     ],
 
+    // set timeout queue
+
+    'worker' => [
+        'timeout' => 300
+    ]
+
 ];

database/migrations/2025_02_12_083512_create_table_umkm.php

@@ -0,0 +1,46 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+return new class extends Migration
+{
+    /**
+     * Run the migrations.
+     */
+    public function up(): void
+    {
+        Schema::create('umkm', function (Blueprint $table) {
+            $table->id();
+            $table->timestamp('created_at')->default(DB::raw('CURRENT_TIMESTAMP'));
+            $table->timestamp('updated_at')->default(DB::raw('CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'));
+            $table->string('business_name');
+            $table->string('business_address');
+            $table->string('business_desc');
+            $table->string('business_contact');
+            $table->string('business_id_number')->nullable();
+            $table->integer('business_scale_id');
+            $table->string('owner_id');
+            $table->string('owner_name');
+            $table->string('owner_address');
+            $table->string('owner_contact');
+            $table->string('business_type');
+            $table->string('business_form');
+            $table->decimal('revenue');
+            $table->string('village_code');
+            $table->integer('distric_code');
+            $table->integer('number_of_employee');
+            $table->float('land_area')->nullable();
+            $table->integer('permit_status_id');
+        });
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        Schema::dropIfExists('umkm');
+    }
+};

database/migrations/2025_02_12_091119_create_business_scale_table.php

@@ -0,0 +1,29 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+return new class extends Migration
+{
+    /**
+     * Run the migrations.
+     */
+    public function up(): void
+    {
+        Schema::create('business_scale', function (Blueprint $table) {
+            $table->id();
+            $table->timestamp('created_at')->default(DB::raw('CURRENT_TIMESTAMP'));
+            $table->timestamp('updated_at')->default(DB::raw('CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'));
+            $table->string('business_scale');
+        });
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        Schema::dropIfExists('business_scale');
+    }
+};

database/migrations/2025_02_12_091312_create_permit_status_table.php

@@ -0,0 +1,29 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+return new class extends Migration
+{
+    /**
+     * Run the migrations.
+     */
+    public function up(): void
+    {
+        Schema::create('permit_status', function (Blueprint $table) {
+            $table->id();
+            $table->timestamp('created_at')->default(DB::raw('CURRENT_TIMESTAMP'));
+            $table->timestamp('updated_at')->default(DB::raw('CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'));
+            $table->string('permit_status');
+        });
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        Schema::dropIfExists('permit_status');
+    }
+};

database/migrations/2025_02_12_100256_update_business_form_column_in_umkm_table.php

@@ -0,0 +1,30 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+return new class extends Migration
+{
+    /**
+     * Run the migrations.
+     */
+    public function up(): void
+    {
+        Schema::table('umkm', function (Blueprint $table) {
+            $table->dropColumn('business_form');
+            $table->integer('business_form_id')->nullable();
+        });
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        Schema::table('umkm', function (Blueprint $table) {
+            $table->dropColumn('business_form_id');
+            $table->string('business_form')->nullable();
+        });
+    }
+};

database/migrations/2025_02_12_100644_create_business_form_table.php

@@ -0,0 +1,29 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+return new class extends Migration
+{
+    /**
+     * Run the migrations.
+     */
+    public function up(): void
+    {
+        Schema::create('business_form', function (Blueprint $table) {
+            $table->id();
+            $table->timestamp('created_at')->default(DB::raw('CURRENT_TIMESTAMP'));
+            $table->timestamp('updated_at')->default(DB::raw('CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'));
+            $table->string('business_form');
+        });
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        Schema::dropIfExists('business_form');
+    }
+};

database/migrations/2025_02_12_103210_update_distric_code_column_in_umkm_table.php

@@ -0,0 +1,28 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+return new class extends Migration
+{
+    /**
+     * Run the migrations.
+     */
+    public function up(): void
+    {
+        Schema::table('umkm', function (Blueprint $table) {
+            $table->renameColumn('distric_code', 'district_code');
+        });
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        Schema::table('umkm', function (Blueprint $table) {
+            $table->renameColumn('district_code', 'distric_code');
+        });
+    }
+};

database/migrations/2025_02_13_072400_rename_umkms_table_to_umkm.php

@@ -0,0 +1,28 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+return new class extends Migration
+{
+    /**
+     * Run the migrations.
+     */
+    public function up(): void
+    {
+        Schema::table('umkm', function (Blueprint $table) {
+            Schema::rename('umkm', 'umkms'); 
+        });
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        Schema::table('umkm', function (Blueprint $table) {
+            Schema::rename('umkm', 'umkms');
+        });
+    }
+};

database/migrations/2025_02_13_102551_update_revenue_and_land_area_columns_in_umkm_table.php

@@ -0,0 +1,36 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+return new class extends Migration
+{
+    /**
+     * Run the migrations.
+     */
+    public function up(): void
+    {
+        Schema::table('umkms', function (Blueprint $table) {
+            // Mengubah kolom 'revenue' menjadi decimal(20, 2)
+            $table->decimal('revenue', 20, 2)->change();
+
+            // Mengubah kolom 'land_area' menjadi decimal(20, 2)
+            $table->integer('land_area')->nullable()->change();
+        });
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        Schema::table('umkm', function (Blueprint $table) {
+            // Mengembalikan kolom 'revenue' ke decimal default (jika ada)
+            $table->decimal('revenue')->change();
+
+            // Mengembalikan kolom 'land_area' ke tipe sebelumnya (float atau lainnya)
+            $table->float('land_area')->nullable()->change();
+        });
+    }
+};

database/migrations/2025_02_17_072649_create_tourism_table.php

@@ -0,0 +1,36 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+return new class extends Migration
+{
+    /**
+     * Run the migrations.
+     */
+    public function up(): void
+    {
+        Schema::create('tourism', function (Blueprint $table) {
+            $table->id();
+            $table->timestamp('created_at')->default(DB::raw('CURRENT_TIMESTAMP'));
+            $table->timestamp('updated_at')->default(DB::raw('CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'));
+            $table->string('business_name');
+            $table->string('project_name');
+            $table->string('business_address');
+            $table->string('village_code');
+            $table->string('land_area');
+            $table->string('investment_amount');
+            $table->string('number_of_employee');
+            $table->string('business_type_id');
+        });
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        Schema::dropIfExists('tourism');
+    }
+};

database/migrations/2025_02_17_075547_create_business_type_table.php

@@ -0,0 +1,29 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+return new class extends Migration
+{
+    /**
+     * Run the migrations.
+     */
+    public function up(): void
+    {
+        Schema::create('business_type', function (Blueprint $table) {
+            $table->id();
+            $table->timestamp('created_at')->default(DB::raw('CURRENT_TIMESTAMP'));
+            $table->timestamp('updated_at')->default(DB::raw('CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'));
+            $table->string('business_type');
+        });
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        Schema::dropIfExists('business_type');
+    }
+};

database/migrations/2025_02_17_082731_add_district_code_to_tourism_table.php

@@ -0,0 +1,28 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+return new class extends Migration
+{
+    /**
+     * Run the migrations.
+     */
+    public function up(): void
+    {
+        Schema::table('tourism', function (Blueprint $table) {
+            $table->string('district_code')->after('business_address');
+        });
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        Schema::table('tourism', function (Blueprint $table) {
+            $table->dropColumn('district_code');
+        });
+    }
+};

database/migrations/2025_02_17_092740_rename_tourism_to_tourisms.php

@@ -0,0 +1,24 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+return new class extends Migration
+{
+    /**
+     * Run the migrations.
+     */
+    public function up(): void
+    {
+        Schema::rename('tourism', 'tourisms');
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        Schema::rename('tourisms', 'tourism');
+    }
+};

database/migrations/2025_02_17_123444_add_columns_to_tourisms_table.php

@@ -0,0 +1,36 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+return new class extends Migration
+{
+    /**
+     * Run the migrations.
+     */
+    public function up(): void
+    {
+        Schema::table('tourisms', function (Blueprint $table) {
+            $table->integer('project_id')->nullable()->after('id');
+            $table->string('jenis_proyek')->nullable()->after('project_id');
+            $table->string('nib')->nullable()->after('jenis_proyek');
+            $table->integer('business_scale_id')->nullable()->after('project_name');
+            $table->date('terbit_oss')->nullable()->after('business_name');
+            $table->string('status_penanaman_modal')->nullable()->after('terbit_oss');
+            $table->string('business_form')->nullable()->after('status_penanaman_modal');
+            $table->string('uraian_resiko_proyek')->nullable()->after('business_form');
+        });
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        Schema::table('tourisms', function (Blueprint $table) {
+            $table->dropColumn(['project_id', 'jenis_proyek', 'nib', 'business_scale_id', 'terbit_oss',
+                                'status_penanaman_modal', 'business_form', 'uraian_resiko_proyek']);
+        });
+    }
+};

database/migrations/2025_02_17_131349_change_project_id_to_string_in_tourisms.php

@@ -0,0 +1,32 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+return new class extends Migration
+{
+    /**
+     * Run the migrations.
+     */
+    public function up(): void
+    {
+        Schema::table('tourisms', function (Blueprint $table) {
+            $table->string('project_id')->change();
+            $table->integer('district_code')->change();
+            $table->integer('business_type_id')->change();
+        });
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        Schema::table('tourisms', function (Blueprint $table) {
+            $table->integer('project_id')->change();
+            $table->string('district_code')->change();
+            $table->string('business_type_id')->change();
+        });
+    }
+};

database/migrations/2025_02_17_144423_create_business_or_industries_table.php

@@ -0,0 +1,39 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+return new class extends Migration
+{
+    /**
+     * Run the migrations.
+     */
+    public function up(): void
+    {
+        Schema::create('business_or_industries', function (Blueprint $table) {
+            $table->id();
+            $table->string('nama_kecamatan');
+            $table->string('nama_kelurahan');
+            $table->string('nop')->unique();
+            $table->string('nama_wajib_pajak');
+            $table->text('alamat_wajib_pajak')->nullable();
+            $table->text('alamat_objek_pajak');
+            $table->decimal('luas_bumi',20,2)->default(0);
+            $table->decimal('luas_bangunan',20,2)->default(0);
+            $table->decimal('njop_bumi',20,2)->default(0);
+            $table->decimal('njop_bangunan',20,2)->default(0);
+            $table->decimal('ketetapan',20,2)->default(0);
+            $table->integer('tahun_pajak');
+            $table->timestamps();
+        });
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        Schema::dropIfExists('business_or_industries');
+    }
+};

database/migrations/2025_02_18_104702_rebuild_tourisms_table.php

@@ -0,0 +1,54 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+return new class extends Migration
+{
+    /**
+     * Run the migrations.
+     */
+    public function up(): void
+    {
+        Schema::dropIfExists('tourisms'); 
+        Schema::create('tourisms', function (Blueprint $table) {
+            $table->id();
+            $table->timestamp('created_at')->default(DB::raw('CURRENT_TIMESTAMP'));
+            $table->timestamp('updated_at')->default(DB::raw('CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'));
+            $table->string('project_id');
+            $table->string('project_type_id');
+            $table->string('nib');
+            $table->string('business_name');
+            $table->datetime('oss_publication_date');
+            $table->string('investment_status_description');
+            $table->string('business_form');
+            $table->string('project_risk');
+            $table->string('project_name');
+            $table->string('business_scale');
+            $table->string('business_address');
+            $table->integer('district_code');
+            $table->integer('village_code');
+            $table->string('longitude');
+            $table->string('latitude');
+            $table->datetime('project_submission_date');
+            $table->string('kbli');
+            $table->string('kbli_title');
+            $table->string('supervisory_sector');
+            $table->string('user_name');
+            $table->string('email');
+            $table->string('contact');
+            $table->string('land_area_in_m2');
+            $table->string('investment_amount');
+            $table->string('tki');
+        });
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        Schema::dropIfExists('tourisms');
+    }
+};

database/migrations/2025_02_18_160922_change_village_code_to_string.php

@@ -0,0 +1,28 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+return new class extends Migration
+{
+    /**
+     * Run the migrations.
+     */
+    public function up(): void
+    {
+        Schema::table('tourisms', function (Blueprint $table) {
+            $table->string('village_code')->change();
+        });
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        Schema::table('tourisms', function (Blueprint $table) {
+            $table->integer('village_code')->change();
+        });
+    }
+};

database/migrations/2025_02_20_050004_create_spatial_planning_table.php

@@ -0,0 +1,35 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+return new class extends Migration
+{
+    /**
+     * Run the migrations.
+     */
+    public function up(): void
+    {
+        Schema::create('spatial_planning', function (Blueprint $table) {
+            $table->id();
+            $table->timestamp('created_at')->default(DB::raw('CURRENT_TIMESTAMP'));
+            $table->timestamp('updated_at')->default(DB::raw('CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'));
+            $table->string('name')->nullable();
+            $table->string('kbli')->nullable();
+            $table->string('activities')->nullable();
+            $table->string('area')->nullable();
+            $table->string('location')->nullable();
+            $table->string('number')->nullable();
+            $table->dateTime('date')->nullable();
+        });
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        Schema::dropIfExists('spatial_planning');
+    }
+};

database/migrations/2025_02_20_073855_rename_spatial_planning_table.php

@@ -0,0 +1,24 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+return new class extends Migration
+{
+    /**
+     * Run the migrations.
+     */
+    public function up(): void
+    {
+        Schema::rename('spatial_planning', 'spatial_plannings');
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        Schema::rename('spatial_plannings', 'spatial_planning');
+    }
+};

database/migrations/2025_02_20_154106_create_customers_table.php

@@ -0,0 +1,33 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+return new class extends Migration
+{
+    /**
+     * Run the migrations.
+     */
+    public function up(): void
+    {
+        Schema::create('customers', function (Blueprint $table) {
+            $table->id();
+            $table->string('nomor_pelanggan')->unique();
+            $table->string('kota_pelayanan');
+            $table->string('nama');
+            $table->text('alamat');
+            $table->decimal('latitude', 22,18);
+            $table->decimal('longitude', 22,18);
+            $table->timestamps();
+        });
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        Schema::dropIfExists('customers');
+    }
+};

database/migrations/2025_02_26_140440_add_spatial_in_bigdata_resumes.php

@@ -0,0 +1,32 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+return new class extends Migration
+{
+    /**
+     * Run the migrations.
+     */
+    public function up(): void
+    {
+        Schema::table('bigdata_resumes', function (Blueprint $table) {
+            $table->integer('spatial_count')->default(0);
+            $table->decimal('spatial_sum', 20,2)->default(0);
+            $table->string('year');
+        });
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        Schema::table('bigdata_resumes', function (Blueprint $table) {
+            $table->dropColumn('spatial_count');
+            $table->dropColumn('spatial_sum');
+            $table->dropColumn('year');
+        });
+    }
+};

database/seeders/BusinessFormSeeder.php

@@ -0,0 +1,26 @@
+<?php
+
+namespace Database\Seeders;
+
+use Illuminate\Database\Console\Seeds\WithoutModelEvents;
+use Illuminate\Database\Seeder;
+use Illuminate\Support\Facades\DB;
+
+class BusinessFormSeeder extends Seeder
+{
+    /**
+     * Run the database seeds.
+     */
+    public function run(): void
+    {
+        DB::table('business_form')->insert([
+            ['business_form' => 'Perseorangan'],
+            ['business_form' => 'Persekutuan'],
+            ['business_form' => 'Koperasi'],
+            ['business_form' => 'CV'],
+            ['business_form' => 'PT'],
+            ['business_form' => 'PTTB'],
+            ['business_form' => 'Perseroan'],
+        ]);
+    }
+}

database/seeders/BusinessScaleSeeder.php

@@ -0,0 +1,22 @@
+<?php
+
+namespace Database\Seeders;
+
+use Illuminate\Database\Console\Seeds\WithoutModelEvents;
+use Illuminate\Database\Seeder;
+use Illuminate\Support\Facades\DB;
+
+class BusinessScaleSeeder extends Seeder
+{
+    /**
+     * Run the database seeds.
+     */
+    public function run(): void
+    {
+        DB::table('business_scale')->insert([
+            ['business_scale' => 'Micro'],
+            ['business_scale' => 'Kecil'],
+            ['business_scale' => 'Menengah'],
+        ]);
+    }
+}

database/seeders/BusinessTypeSeeder.php

@@ -0,0 +1,28 @@
+<?php
+
+namespace Database\Seeders;
+
+use Illuminate\Database\Console\Seeds\WithoutModelEvents;
+use Illuminate\Database\Seeder;
+use Illuminate\Support\Facades\DB;
+
+class BusinessTypeSeeder extends Seeder
+{
+    /**
+     * Run the database seeds.
+     */
+    public function run(): void
+    {
+        DB::table('business_type')->insert([
+            ['business_type' => 'Villas'],
+            ['business_type' => 'Hotels'],
+            ['business_type' => 'Restaurants / Food Stores'],
+            ['business_type' => 'Cafes'],
+            ['business_type' => 'Adventure / Outdoor Activities'],
+            ['business_type' => 'Event Organizers'],
+            ['business_type' => 'Travel & Tours'],
+            ['business_type' => 'Miscellaneous'],
+            ['business_type' => 'Others'],
+        ]);
+    }
+}

database/seeders/DataSettingSeeder.php

@@ -23,7 +23,37 @@ class DataSettingSeeder extends Seeder
             "key" => "TATA_RUANG",
             "value" => "10000000000",
             "type" => "integer"
-            ]
+            ],
+            [
+                "key" => "REALISASI_TERBIT_PBG_SUM",
+                "value" => "1507253788",
+                "type" => "integer"
+            ],
+            [
+                "key" => "REALISASI_TERBIT_PBG_COUNT",
+                "value" => "88",
+                "type" => "integer"
+            ],
+            [
+                "key" => "MENUNGGU_KLIK_DPMPTSP_SUM",
+                "value" => "83457536",
+                "type" => "integer"
+            ],
+            [
+                "key" => "MENUNGGU_KLIK_DPMPTSP_COUNT",
+                "value" => "266",
+                "type" => "integer"
+            ],
+            [
+                "key" => "PROSES_DINAS_TEKNIS_SUM",
+                "value" => "83457536",
+                "type" => "integer"
+            ],
+            [
+                "key" => "PROSES_DINAS_TEKNIS_COUNT",
+                "value" => "11",
+                "type" => "integer"
+            ],
         ];
 
         foreach ($data_settings as $setting) {

database/seeders/PermitStatusSeeder.php

@@ -0,0 +1,22 @@
+<?php
+
+namespace Database\Seeders;
+
+use Illuminate\Database\Console\Seeds\WithoutModelEvents;
+use Illuminate\Database\Seeder;
+use Illuminate\Support\Facades\DB;
+
+class PermitStatusSeeder extends Seeder
+{
+    /**
+     * Run the database seeds.
+     */
+    public function run(): void
+    {
+        DB::table('permit_status')->insert([
+            ['permit_status' => 'Not Registered'],
+            ['permit_status' => 'Registered'],
+            ['permit_status' => 'Application Process'],
+        ]);
+    }
+}

database/seeders/UsersRoleMenuSeeder.php

@@ -67,6 +67,13 @@ class UsersRoleMenuSeeder extends Seeder
                 "icon" => "mingcute:task-line",
                 "parent_id" => null,
                 "sort_order" => 5,
+            ],
+            [
+                "name" => "Laporan",
+                "url" => "/laporan",
+                "icon" => "mingcute:report-line",
+                "parent_id" => null,
+                "sort_order" => 6,
             ]
         ];
 
@@ -84,6 +91,7 @@ class UsersRoleMenuSeeder extends Seeder
         $settings = Menu::where('name', 'Settings')->first();
         $dataSettings = Menu::where('name', 'Data Settings')->first();
         $data = Menu::where('name', 'Data')->first();
+        $laporan = Menu::where('name', 'Laporan')->first();
 
         // create children menu
         $children_menus = [
@@ -101,6 +109,20 @@ class UsersRoleMenuSeeder extends Seeder
                 "parent_id" => $dashboard->id,
                 "sort_order" => 2,
             ],
+            [
+                "name" => "Dashboard Potensi",
+                "url" => "dashboard.lack_of_potential",
+                "icon" => null,
+                "parent_id" => $dashboard->id,
+                "sort_order" => 3,
+            ],
+            [
+                "name" => "PETA",
+                "url" => "dashboard.maps",
+                "icon" => null,
+                "parent_id" => $dashboard->id,
+                "sort_order" => 4,
+            ],
             [
                 "name" => "Users",
                 "url" => "users.index",
@@ -148,8 +170,57 @@ class UsersRoleMenuSeeder extends Seeder
                 "url" => "advertisements.index",
                 "icon" => null,
                 "parent_id" => $data->id,
+                "sort_order" => 2,
+            ],
+            [
+                "name" => "Usaha atau Industri",
+                "url" => "business-industries.index",
+                "icon" => null,
+                "parent_id" => $data->id,
+                "sort_order" => 3,
+            ],
+            [
+                "name" => "UMKM",
+                "url" => "umkm.index",
+                "icon" => null,
+                "parent_id" => $data->id,
+                "sort_order" => 4,
+            ],
+            [
+                "name" => "Pariwisata",
+                "url" => "tourisms.index",
+                "icon" => null,
+                "parent_id" => $data->id,
+                "sort_order" => 5,
+            ],
+            [
+                "name" => "Tata Ruang",
+                "url" => "spatial-plannings.index",
+                "icon" => null,
+                "parent_id" => $data->id,
+                "sort_order" => 6,
+            ],
+            [
+                "name" => "PDAM",
+                "url" => "customers",
+                "icon" => null,
+                "parent_id" => $data->id,
+                "sort_order" => 7,
+            ],
+            [
+                "name" => "Lap Pariwisata",
+                "url" => "tourisms.index",
+                "icon" => null,
+                "parent_id" => $laporan->id,
                 "sort_order" => 1,
             ],
+            [
+                "name" => "Lap Pimpinan",
+                "url" => "bigdata-resumes",
+                "icon" => null,
+                "parent_id" => $laporan->id,
+                "sort_order" => 2,
+            ],
         ];
 
         foreach ($children_menus as $child_menu) {
@@ -165,6 +236,15 @@ class UsersRoleMenuSeeder extends Seeder
         $setting_dashboard = Menu::where('name', 'Setting Dashboard')->first();
         $setting_pbg = Menu::where('name', 'PBG')->first();
         $reklame = Menu::where('name', 'Reklame')->first();
+        $businessIndustries = Menu::where('name', 'Usaha atau Industri')->first();
+        $pariwisata = Menu::where('name', 'Pariwisata')->first();
+        $laporan_pariwisata = Menu::where('name', 'Lap Pariwisata')->first();
+        $umkm = Menu::where('name', 'UMKM')->first();
+        $lack_of_potentials = Menu::where('name', 'Dashboard Potensi')->first();
+        $spatial_plannings = Menu::where('name', 'Tata Ruang')->first();
+        $pdam = Menu::where('name', 'PDAM')->first();
+        $peta = Menu::where('name', 'PETA')->first();
+        $bigdata_resume = Menu::where('name', 'Lap Pimpinan')->first();
 
         // Superadmin gets all menus
         $superadmin->menus()->sync([
@@ -174,6 +254,7 @@ class UsersRoleMenuSeeder extends Seeder
             $settings->id => ["allow_show" => true, "allow_create" => false, "allow_update" => false, "allow_destroy" => false],
             $dataSettings->id => ["allow_show" => true, "allow_create" => false, "allow_update" => false, "allow_destroy" => false],
             $data->id => ["allow_show" => true, "allow_create" => false, "allow_update" => false, "allow_destroy" => false],
+            $laporan->id => ["allow_show" => true, "allow_create" => false, "allow_update" => false, "allow_destroy" => false],
             // children
             $dashboard_pimpinan->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
             $dashboard_pbg->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
@@ -184,6 +265,15 @@ class UsersRoleMenuSeeder extends Seeder
             $setting_dashboard->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
             $setting_pbg->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
             $reklame->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
+            $businessIndustries->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
+            $pariwisata->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
+            $laporan_pariwisata->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
+            $umkm->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
+            $lack_of_potentials->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
+            $spatial_plannings->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
+            $pdam->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
+            $peta->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
+            $bigdata_resume->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
         ]);
 
         // Admin gets limited menus
@@ -198,6 +288,7 @@ class UsersRoleMenuSeeder extends Seeder
             $dashboard->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
             $data->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
         ]);
+        
         // Attach User to role super admin
         User::findOrFail(1)->roles()->sync([$superadmin->id]);
     }

database/view_query/business_type_counts.sql

@@ -0,0 +1,5 @@
+CREATE VIEW business_type_counts AS
+SELECT b.business_type, COUNT(t.id) AS count
+FROM tourisms t
+JOIN business_type b ON t.business_type_id = b.id
+GROUP BY b.business_type;

package-lock.json

@@ -15,10 +15,12 @@
                 "gridjs": "^5.1.0",
                 "iconify-icon": "^2.1.0",
                 "jsvectormap": "^1.5.1",
+                "leaflet": "^1.9.4",
                 "moment": "^2.29.4",
                 "node-waves": "^0.7.6",
                 "quill": "^1.3.7",
                 "simplebar": "^5.3.9",
+                "sweetalert2": "^11.16.0",
                 "wnumb": "^1.2.0"
             },
             "devDependencies": {
@@ -60,22 +62,6 @@
                 "node": ">=12"
             }
         },
-        "node_modules/@esbuild/win32-x64": {
-            "version": "0.21.5",
-            "resolved": "https://registry.npmjs.org/@esbuild/win32-x64/-/win32-x64-0.21.5.tgz",
-            "integrity": "sha512-tQd/1efJuzPC6rCFwEvLtci/xNFcTZknmXs98FYDfGE4wP9ClFV98nyKrzJKVPMhdDnjzLhdUyMX4PsQAPjwIw==",
-            "cpu": [
-                "x64"
-            ],
-            "dev": true,
-            "optional": true,
-            "os": [
-                "win32"
-            ],
-            "engines": {
-                "node": ">=12"
-            }
-        },
         "node_modules/@iconify/types": {
             "version": "2.0.0",
             "resolved": "https://registry.npmjs.org/@iconify/types/-/types-2.0.0.tgz",
@@ -262,26 +248,6 @@
                 "url": "https://opencollective.com/parcel"
             }
         },
-        "node_modules/@parcel/watcher-win32-x64": {
-            "version": "2.5.0",
-            "resolved": "https://registry.npmjs.org/@parcel/watcher-win32-x64/-/watcher-win32-x64-2.5.0.tgz",
-            "integrity": "sha512-lPrxve92zEHdgeff3aiu4gDOIt4u7sJYha6wbdEZDCDUhtjTsOMiaJzG5lMY4GkWH8p0fMmO2Ppq5G5XXG+DQw==",
-            "cpu": [
-                "x64"
-            ],
-            "dev": true,
-            "optional": true,
-            "os": [
-                "win32"
-            ],
-            "engines": {
-                "node": ">= 10.0.0"
-            },
-            "funding": {
-                "type": "opencollective",
-                "url": "https://opencollective.com/parcel"
-            }
-        },
         "node_modules/@pkgjs/parseargs": {
             "version": "0.11.0",
             "resolved": "https://registry.npmjs.org/@pkgjs/parseargs/-/parseargs-0.11.0.tgz",
@@ -328,19 +294,6 @@
                 "linux"
             ]
         },
-        "node_modules/@rollup/rollup-win32-x64-msvc": {
-            "version": "4.28.0",
-            "resolved": "https://registry.npmjs.org/@rollup/rollup-win32-x64-msvc/-/rollup-win32-x64-msvc-4.28.0.tgz",
-            "integrity": "sha512-Bvno2/aZT6usSa7lRDL2+hMjVAGjuqaymF1ApZm31JXzniR/hvr14jpU+/z4X6Gt5BPlzosscyJZGUvguXIqeQ==",
-            "cpu": [
-                "x64"
-            ],
-            "dev": true,
-            "optional": true,
-            "os": [
-                "win32"
-            ]
-        },
         "node_modules/@types/estree": {
             "version": "1.0.6",
             "resolved": "https://registry.npmjs.org/@types/estree/-/estree-1.0.6.tgz",
@@ -1515,6 +1468,12 @@
                 "vite": "^5.0.0 || ^6.0.0"
             }
         },
+        "node_modules/leaflet": {
+            "version": "1.9.4",
+            "resolved": "https://registry.npmjs.org/leaflet/-/leaflet-1.9.4.tgz",
+            "integrity": "sha512-nxS1ynzJOmOlHp+iL3FyWqK89GtNL8U8rvlMOsQdTTssxZwCXh8N2NB3GDQOL+YR3XnWyZAxwQixURb+FA74PA==",
+            "license": "BSD-2-Clause"
+        },
         "node_modules/lilconfig": {
             "version": "2.1.0",
             "resolved": "https://registry.npmjs.org/lilconfig/-/lilconfig-2.1.0.tgz",
@@ -2521,6 +2480,16 @@
                 "node": ">= 0.8.0"
             }
         },
+        "node_modules/sweetalert2": {
+            "version": "11.16.0",
+            "resolved": "https://registry.npmjs.org/sweetalert2/-/sweetalert2-11.16.0.tgz",
+            "integrity": "sha512-4CGgNMpQHcwV+Gov0j4u3lDc/5lyl04NBsa1vW0Se9cqsrQoUimD6/Z5UyZiRP4kMbwQGyb7wsp0x3ytybti6w==",
+            "license": "MIT",
+            "funding": {
+                "type": "individual",
+                "url": "https://github.com/sponsors/limonte"
+            }
+        },
         "node_modules/tailwindcss": {
             "version": "3.4.15",
             "resolved": "https://registry.npmjs.org/tailwindcss/-/tailwindcss-3.4.15.tgz",

package.json

@@ -26,10 +26,12 @@
         "gridjs": "^5.1.0",
         "iconify-icon": "^2.1.0",
         "jsvectormap": "^1.5.1",
+        "leaflet": "^1.9.4",
         "moment": "^2.29.4",
         "node-waves": "^0.7.6",
         "quill": "^1.3.7",
         "simplebar": "^5.3.9",
+        "sweetalert2": "^11.16.0",
         "wnumb": "^1.2.0"
     }
 }

public/build/.vite/manifest.json

@@ -1,408 +0,0 @@
-{
-  "__commonjsHelpers-C4iS2aBk.js": {
-    "file": "assets/_commonjsHelpers-C4iS2aBk.js",
-    "name": "_commonjsHelpers"
-  },
-  "_apexcharts.common-7mov3gaG.js": {
-    "file": "assets/apexcharts.common-7mov3gaG.js",
-    "name": "apexcharts.common",
-    "imports": [
-      "__commonjsHelpers-C4iS2aBk.js"
-    ]
-  },
-  "_dropzone-B5tMhgFp.js": {
-    "file": "assets/dropzone-B5tMhgFp.js",
-    "name": "dropzone"
-  },
-  "_global-config-9uDKFQ8j.js": {
-    "file": "assets/global-config-9uDKFQ8j.js",
-    "name": "global-config"
-  },
-  "_gridjs.umd-BiCNXlqL.js": {
-    "file": "assets/gridjs.umd-BiCNXlqL.js",
-    "name": "gridjs.umd",
-    "imports": [
-      "__commonjsHelpers-C4iS2aBk.js"
-    ]
-  },
-  "_world-BH8KG5u4.js": {
-    "file": "assets/world-BH8KG5u4.js",
-    "name": "world",
-    "imports": [
-      "__commonjsHelpers-C4iS2aBk.js"
-    ]
-  },
-  "node_modules/flatpickr/dist/flatpickr.min.css": {
-    "file": "assets/flatpickr-CksuuEqD.css",
-    "src": "node_modules/flatpickr/dist/flatpickr.min.css",
-    "isEntry": true
-  },
-  "node_modules/flatpickr/dist/themes/dark.css": {
-    "file": "assets/dark-CLxH30By.css",
-    "src": "node_modules/flatpickr/dist/themes/dark.css",
-    "isEntry": true
-  },
-  "node_modules/gridjs/dist/theme/mermaid.css": {
-    "file": "assets/mermaid-B5wPN5RC.css",
-    "src": "node_modules/gridjs/dist/theme/mermaid.css",
-    "isEntry": true
-  },
-  "node_modules/gridjs/dist/theme/mermaid.min.css": {
-    "file": "assets/mermaid-1KsrsKla.css",
-    "src": "node_modules/gridjs/dist/theme/mermaid.min.css",
-    "isEntry": true
-  },
-  "node_modules/quill/dist/quill.bubble.css": {
-    "file": "assets/quill-BzaoboQ1.css",
-    "src": "node_modules/quill/dist/quill.bubble.css",
-    "isEntry": true
-  },
-  "node_modules/quill/dist/quill.snow.css": {
-    "file": "assets/quill-D-Ncpkvi.css",
-    "src": "node_modules/quill/dist/quill.snow.css",
-    "isEntry": true
-  },
-  "public/images/bg-dashboard.jpg": {
-    "file": "assets/bg-dashboard-CUwt8_jP.jpg",
-    "src": "public/images/bg-dashboard.jpg"
-  },
-  "resources/fonts/boxicons.eot": {
-    "file": "assets/boxicons-0t2gX1vj.eot",
-    "src": "resources/fonts/boxicons.eot"
-  },
-  "resources/fonts/boxicons.svg": {
-    "file": "assets/boxicons-KSR1BgPC.svg",
-    "src": "resources/fonts/boxicons.svg"
-  },
-  "resources/fonts/boxicons.ttf": {
-    "file": "assets/boxicons-BEZXjQG5.ttf",
-    "src": "resources/fonts/boxicons.ttf"
-  },
-  "resources/fonts/boxicons.woff": {
-    "file": "assets/boxicons-CEgI8ccS.woff",
-    "src": "resources/fonts/boxicons.woff"
-  },
-  "resources/fonts/boxicons.woff2": {
-    "file": "assets/boxicons-C7pETWQJ.woff2",
-    "src": "resources/fonts/boxicons.woff2"
-  },
-  "resources/js/app.js": {
-    "file": "assets/app-Wz_4hh3O.js",
-    "name": "app",
-    "src": "resources/js/app.js",
-    "isEntry": true,
-    "imports": [
-      "__commonjsHelpers-C4iS2aBk.js"
-    ]
-  },
-  "resources/js/config.js": {
-    "file": "assets/config-DqV4EBmE.js",
-    "name": "config",
-    "src": "resources/js/config.js",
-    "isEntry": true
-  },
-  "resources/js/dashboards/bigdata.js": {
-    "file": "assets/bigdata-DYDUaCEC.js",
-    "name": "bigdata",
-    "src": "resources/js/dashboards/bigdata.js",
-    "isEntry": true,
-    "imports": [
-      "_global-config-9uDKFQ8j.js"
-    ],
-    "css": [
-      "assets/flatpickr-CksuuEqD.css"
-    ]
-  },
-  "resources/js/data-settings/create.js": {
-    "file": "assets/create-C1IbeTHP.js",
-    "name": "create",
-    "src": "resources/js/data-settings/create.js",
-    "isEntry": true
-  },
-  "resources/js/data-settings/index.js": {
-    "file": "assets/index-BOfsbw53.js",
-    "name": "index",
-    "src": "resources/js/data-settings/index.js",
-    "isEntry": true,
-    "imports": [
-      "_gridjs.umd-BiCNXlqL.js",
-      "_global-config-9uDKFQ8j.js",
-      "__commonjsHelpers-C4iS2aBk.js"
-    ]
-  },
-  "resources/js/data-settings/update.js": {
-    "file": "assets/update-nNw3P4hj.js",
-    "name": "update",
-    "src": "resources/js/data-settings/update.js",
-    "isEntry": true
-  },
-  "resources/js/data/advertisements/data-advertisements.js": {
-    "file": "assets/data-advertisements-C_ZfB4RA.js",
-    "name": "data-advertisements",
-    "src": "resources/js/data/advertisements/data-advertisements.js",
-    "isEntry": true,
-    "imports": [
-      "_gridjs.umd-BiCNXlqL.js",
-      "_global-config-9uDKFQ8j.js",
-      "__commonjsHelpers-C4iS2aBk.js"
-    ]
-  },
-  "resources/js/data/advertisements/form-create-update.js": {
-    "file": "assets/form-create-update-CyN97GsU.js",
-    "name": "form-create-update",
-    "src": "resources/js/data/advertisements/form-create-update.js",
-    "isEntry": true,
-    "imports": [
-      "_global-config-9uDKFQ8j.js"
-    ]
-  },
-  "resources/js/data/advertisements/form-upload.js": {
-    "file": "assets/form-upload-Ci7Kyzc7.js",
-    "name": "form-upload",
-    "src": "resources/js/data/advertisements/form-upload.js",
-    "isEntry": true,
-    "imports": [
-      "_dropzone-B5tMhgFp.js"
-    ]
-  },
-  "resources/js/master/users/create.js": {
-    "file": "assets/create-RO4xgm-f.js",
-    "name": "create",
-    "src": "resources/js/master/users/create.js",
-    "isEntry": true
-  },
-  "resources/js/master/users/update.js": {
-    "file": "assets/update-DhoG4v8r.js",
-    "name": "update",
-    "src": "resources/js/master/users/update.js",
-    "isEntry": true
-  },
-  "resources/js/master/users/users.js": {
-    "file": "assets/users-jfWUOWyP.js",
-    "name": "users",
-    "src": "resources/js/master/users/users.js",
-    "isEntry": true,
-    "imports": [
-      "_gridjs.umd-BiCNXlqL.js",
-      "_global-config-9uDKFQ8j.js",
-      "__commonjsHelpers-C4iS2aBk.js"
-    ]
-  },
-  "resources/js/menus/create.js": {
-    "file": "assets/create-ChUgh-yc.js",
-    "name": "create",
-    "src": "resources/js/menus/create.js",
-    "isEntry": true
-  },
-  "resources/js/menus/index.js": {
-    "file": "assets/index-C4xA1kYa.js",
-    "name": "index",
-    "src": "resources/js/menus/index.js",
-    "isEntry": true,
-    "imports": [
-      "_gridjs.umd-BiCNXlqL.js",
-      "_global-config-9uDKFQ8j.js",
-      "__commonjsHelpers-C4iS2aBk.js"
-    ]
-  },
-  "resources/js/menus/update.js": {
-    "file": "assets/update-8JQOGES4.js",
-    "name": "update",
-    "src": "resources/js/menus/update.js",
-    "isEntry": true
-  },
-  "resources/js/pages/chart.js": {
-    "file": "assets/chart-DQBoD9wk.js",
-    "name": "chart",
-    "src": "resources/js/pages/chart.js",
-    "isEntry": true,
-    "imports": [
-      "_apexcharts.common-7mov3gaG.js",
-      "__commonjsHelpers-C4iS2aBk.js"
-    ]
-  },
-  "resources/js/pages/dashboard.js": {
-    "file": "assets/dashboard-nkb3Omy9.js",
-    "name": "dashboard",
-    "src": "resources/js/pages/dashboard.js",
-    "isEntry": true,
-    "imports": [
-      "_apexcharts.common-7mov3gaG.js",
-      "_world-BH8KG5u4.js",
-      "__commonjsHelpers-C4iS2aBk.js"
-    ]
-  },
-  "resources/js/pages/form-fileupload.js": {
-    "file": "assets/form-fileupload-DGbdX8GT.js",
-    "name": "form-fileupload",
-    "src": "resources/js/pages/form-fileupload.js",
-    "isEntry": true,
-    "imports": [
-      "_dropzone-B5tMhgFp.js"
-    ]
-  },
-  "resources/js/pages/form-flatepicker.js": {
-    "file": "assets/form-flatepicker-ChSlk6xC.js",
-    "name": "form-flatepicker",
-    "src": "resources/js/pages/form-flatepicker.js",
-    "isEntry": true,
-    "imports": [
-      "__commonjsHelpers-C4iS2aBk.js"
-    ]
-  },
-  "resources/js/pages/form-quilljs.js": {
-    "file": "assets/form-quilljs-pSObT4Ti.js",
-    "name": "form-quilljs",
-    "src": "resources/js/pages/form-quilljs.js",
-    "isEntry": true,
-    "imports": [
-      "__commonjsHelpers-C4iS2aBk.js"
-    ]
-  },
-  "resources/js/pages/maps-canada.js": {
-    "file": "assets/maps-canada-Btz07hSk.js",
-    "name": "maps-canada",
-    "src": "resources/js/pages/maps-canada.js",
-    "isEntry": true
-  },
-  "resources/js/pages/maps-google.js": {
-    "file": "assets/maps-google-KamR_rNw.js",
-    "name": "maps-google",
-    "src": "resources/js/pages/maps-google.js",
-    "isEntry": true,
-    "imports": [
-      "__commonjsHelpers-C4iS2aBk.js"
-    ]
-  },
-  "resources/js/pages/maps-iraq.js": {
-    "file": "assets/maps-iraq-Blhf9V_8.js",
-    "name": "maps-iraq",
-    "src": "resources/js/pages/maps-iraq.js",
-    "isEntry": true
-  },
-  "resources/js/pages/maps-russia.js": {
-    "file": "assets/maps-russia-C3XucoMP.js",
-    "name": "maps-russia",
-    "src": "resources/js/pages/maps-russia.js",
-    "isEntry": true
-  },
-  "resources/js/pages/maps-spain.js": {
-    "file": "assets/maps-spain-CdBIHB66.js",
-    "name": "maps-spain",
-    "src": "resources/js/pages/maps-spain.js",
-    "isEntry": true
-  },
-  "resources/js/pages/maps-vector.js": {
-    "file": "assets/maps-vector-C2WpvMU7.js",
-    "name": "maps-vector",
-    "src": "resources/js/pages/maps-vector.js",
-    "isEntry": true,
-    "imports": [
-      "_world-BH8KG5u4.js",
-      "__commonjsHelpers-C4iS2aBk.js"
-    ]
-  },
-  "resources/js/pages/table-gridjs.js": {
-    "file": "assets/table-gridjs-BQh80cFh.js",
-    "name": "table-gridjs",
-    "src": "resources/js/pages/table-gridjs.js",
-    "isEntry": true,
-    "imports": [
-      "_gridjs.umd-BiCNXlqL.js",
-      "__commonjsHelpers-C4iS2aBk.js"
-    ]
-  },
-  "resources/js/pbg-task/index.js": {
-    "file": "assets/index-CqcfkvSL.js",
-    "name": "index",
-    "src": "resources/js/pbg-task/index.js",
-    "isEntry": true,
-    "imports": [
-      "_gridjs.umd-BiCNXlqL.js",
-      "_global-config-9uDKFQ8j.js",
-      "__commonjsHelpers-C4iS2aBk.js"
-    ]
-  },
-  "resources/js/roles/create.js": {
-    "file": "assets/create-Dd-lHOwF.js",
-    "name": "create",
-    "src": "resources/js/roles/create.js",
-    "isEntry": true
-  },
-  "resources/js/roles/index.js": {
-    "file": "assets/index-C_kI_q7O.js",
-    "name": "index",
-    "src": "resources/js/roles/index.js",
-    "isEntry": true,
-    "imports": [
-      "_gridjs.umd-BiCNXlqL.js",
-      "_global-config-9uDKFQ8j.js",
-      "__commonjsHelpers-C4iS2aBk.js"
-    ]
-  },
-  "resources/js/roles/role_menu.js": {
-    "file": "assets/role_menu-BuFAi1wM.js",
-    "name": "role_menu",
-    "src": "resources/js/roles/role_menu.js",
-    "isEntry": true
-  },
-  "resources/js/roles/update.js": {
-    "file": "assets/update-CapXnAP8.js",
-    "name": "update",
-    "src": "resources/js/roles/update.js",
-    "isEntry": true
-  },
-  "resources/js/settings/general/general-settings.js": {
-    "file": "assets/general-settings-BoJeYQk1.js",
-    "name": "general-settings",
-    "src": "resources/js/settings/general/general-settings.js",
-    "isEntry": true,
-    "imports": [
-      "_gridjs.umd-BiCNXlqL.js",
-      "_global-config-9uDKFQ8j.js",
-      "__commonjsHelpers-C4iS2aBk.js"
-    ]
-  },
-  "resources/js/settings/syncronize/syncronize.js": {
-    "file": "assets/syncronize-DjtcngRb.js",
-    "name": "syncronize",
-    "src": "resources/js/settings/syncronize/syncronize.js",
-    "isEntry": true,
-    "imports": [
-      "_gridjs.umd-BiCNXlqL.js",
-      "_global-config-9uDKFQ8j.js",
-      "__commonjsHelpers-C4iS2aBk.js"
-    ]
-  },
-  "resources/js/tables/common-table.js": {
-    "file": "assets/common-table-KF_NVAIE.js",
-    "name": "common-table",
-    "src": "resources/js/tables/common-table.js",
-    "isEntry": true,
-    "imports": [
-      "_gridjs.umd-BiCNXlqL.js",
-      "_global-config-9uDKFQ8j.js",
-      "__commonjsHelpers-C4iS2aBk.js"
-    ]
-  },
-  "resources/scss/components/_circle.scss": {
-    "file": "assets/_circle-DgPqpfJw.css",
-    "src": "resources/scss/components/_circle.scss",
-    "isEntry": true
-  },
-  "resources/scss/dashboards/_bigdata.scss": {
-    "file": "assets/_bigdata-0hCjAhYp.css",
-    "src": "resources/scss/dashboards/_bigdata.scss",
-    "isEntry": true
-  },
-  "resources/scss/icons.scss": {
-    "file": "assets/icons-CHxf0fE3.css",
-    "src": "resources/scss/icons.scss",
-    "isEntry": true
-  },
-  "resources/scss/style.scss": {
-    "file": "assets/style-DUYVmgAM.css",
-    "src": "resources/scss/style.scss",
-    "isEntry": true
-  }
-}

resources/js/app.js

@@ -2,6 +2,30 @@ import bootstrap from "bootstrap/dist/js/bootstrap";
 window.bootstrap = bootstrap;
 import "iconify-icon";
 import "simplebar/dist/simplebar";
+// import flatpickr from "flatpickr";
+// import "flatpickr/dist/flatpickr.min.css";
+
+// class InitDatePicker {
+//     constructor(selector = ".datepicker") {
+//         this.selector = selector;
+//     }
+//     init() {
+//         const elements = document.querySelectorAll(this.selector);
+//         if (elements.length === 0) return; // Skip if no elements found
+
+//         const today = new Date();
+//         const minYear = today.getFullYear() - 5;
+
+//         elements.forEach((element) => {
+//             flatpickr(element, {
+//                 enableTime: false,
+//                 dateFormat: "Y-m-d",
+//                 minDate: `${minYear}-01-01`,
+//                 maxDate: today,
+//             });
+//         });
+//     }
+// }
 
 class Components {
     initBootstrapComponents() {
@@ -107,6 +131,7 @@ class FormValidation {
 }
 document.addEventListener("DOMContentLoaded", function (e) {
     new Components().init(), new FormValidation().init();
+    // new InitDatePicker().init();
 });
 class ThemeLayout {
     constructor() {

resources/js/bigdata-resumes/index.js

@@ -0,0 +1,154 @@
+import { Grid } from "gridjs/dist/gridjs.umd.js";
+import gridjs from "gridjs/dist/gridjs.umd.js";
+import "gridjs/dist/gridjs.umd.js";
+import GlobalConfig, { addThousandSeparators } from "../global-config.js";
+import Swal from "sweetalert2";
+import moment from "moment";
+
+class BigdataResume {
+    constructor() {
+        this.toastMessage = document.getElementById("toast-message");
+        this.toastElement = document.getElementById("toastNotification");
+        this.toast = new bootstrap.Toast(this.toastElement);
+        this.table = null;
+
+        // Initialize functions
+        this.initTableDataSettings();
+        // this.initEvents();
+    }
+    initEvents() {
+        document.body.addEventListener("click", async (event) => {
+            const deleteButton = event.target.closest(
+                ".btn-delete-data-settings"
+            );
+            if (deleteButton) {
+                event.preventDefault();
+                await this.handleDelete(deleteButton);
+            }
+        });
+    }
+
+    initTableDataSettings() {
+        let tableContainer = document.getElementById("table-bigdata-resumes");
+        // Create a new Grid.js instance only if it doesn't exist
+        this.table = new Grid({
+            columns: [
+                { name: "ID" },
+                { name: "Potention Count" },
+                { name: "Potention Sum" },
+                { name: "Non Verified Count" },
+                { name: "Non Verified Sum" },
+                { name: "Verified Count" },
+                { name: "Verified Sum" },
+                { name: "Business Count" },
+                { name: "Business Sum" },
+                { name: "Non Business Count" },
+                { name: "Non Business Sum" },
+                { name: "Spatial Sum" },
+                { name: "Spatial Count" },
+                {
+                    name: "Created",
+                    attributes: { style: "width: 200px; white-space: nowrap;" }, // Set width dynamically
+                },
+            ],
+            pagination: {
+                limit: 15,
+                server: {
+                    url: (prev, page) =>
+                        `${prev}${prev.includes("?") ? "&" : "?"}page=${
+                            page + 1
+                        }`,
+                },
+            },
+            sort: true,
+            search: {
+                server: {
+                    url: (prev, keyword) => `${prev}?search=${keyword}`,
+                },
+            },
+            server: {
+                url: `${GlobalConfig.apiHost}/api/bigdata-report`,
+                headers: {
+                    Authorization: `Bearer ${document
+                        .querySelector('meta[name="api-token"]')
+                        .getAttribute("content")}`,
+                    "Content-Type": "application/json",
+                },
+                then: (data) =>
+                    data.data.map((item) => [
+                        item.id,
+                        item.potention_count,
+                        addThousandSeparators(item.potention_sum),
+                        item.non_verified_count,
+                        addThousandSeparators(item.non_verified_sum),
+                        item.verified_count,
+                        addThousandSeparators(item.verified_sum),
+                        item.business_count,
+                        addThousandSeparators(item.business_sum),
+                        item.non_business_count,
+                        addThousandSeparators(item.non_business_sum),
+                        item.spatial_count,
+                        addThousandSeparators(item.spatial_sum),
+                        moment(item.created_at).format("YYYY-MM-DD H:mm:ss"),
+                    ]),
+                total: (data) => data.total,
+            },
+        }).render(tableContainer);
+    }
+    async handleDelete(deleteButton) {
+        const id = deleteButton.getAttribute("data-id");
+
+        const result = await Swal.fire({
+            title: "Are you sure?",
+            text: "You won't be able to revert this!",
+            icon: "warning",
+            showCancelButton: true,
+            confirmButtonColor: "#3085d6",
+            cancelButtonColor: "#d33",
+            confirmButtonText: "Yes, delete it!",
+        });
+
+        if (result.isConfirmed) {
+            try {
+                let response = await fetch(
+                    `${GlobalConfig.apiHost}/api/data-settings/${id}`,
+                    {
+                        method: "DELETE",
+                        credentials: "include",
+                        headers: {
+                            Authorization: `Bearer ${document
+                                .querySelector('meta[name="api-token"]')
+                                .getAttribute("content")}`,
+                            "Content-Type": "application/json",
+                        },
+                    }
+                );
+
+                if (response.ok) {
+                    let result = await response.json();
+                    this.toastMessage.innerText =
+                        result.message || "Deleted successfully!";
+                    this.toast.show();
+
+                    // Refresh Grid.js table
+                    if (typeof this.table !== "undefined") {
+                        this.table.updateConfig({}).forceRender();
+                    }
+                } else {
+                    let error = await response.json();
+                    console.error("Delete failed:", error);
+                    this.toastMessage.innerText =
+                        error.message || "Delete failed!";
+                    this.toast.show();
+                }
+            } catch (error) {
+                console.error("Error deleting item:", error);
+                this.toastMessage.innerText = "An error occurred!";
+                this.toast.show();
+            }
+        }
+    }
+}
+document.addEventListener("DOMContentLoaded", function (e) {
+    new BigdataResume();
+});

resources/js/business-industries/create.js

@@ -0,0 +1,78 @@
+import { Dropzone } from "dropzone";
+import GlobalConfig from "../global-config";
+Dropzone.autoDiscover = false;
+
+var previewTemplate,
+    dropzone,
+    dropzonePreviewNode = document.querySelector("#dropzone-preview-list");
+
+const uploadButton = document.getElementById("btnUploadBusinessIndustry");
+const spinner = document.getElementById("spinner");
+
+const toastNotification = document.getElementById("toastNotification");
+const toast = new bootstrap.Toast(toastNotification);
+
+(dropzonePreviewNode.id = ""),
+    dropzonePreviewNode &&
+        ((previewTemplate = dropzonePreviewNode.parentNode.innerHTML),
+        dropzonePreviewNode.parentNode.removeChild(dropzonePreviewNode),
+        (dropzone = new Dropzone(".dropzone", {
+            url: `${GlobalConfig.apiHost}/api/api-business-industries/upload`,
+            method: "post",
+            acceptedFiles: ".xls,.xlsx", // Use acceptedFiles for better validation
+            previewTemplate: previewTemplate,
+            previewsContainer: "#dropzone-preview",
+            autoProcessQueue: false, // Disable auto post
+            headers: {
+                Authorization: `Bearer ${document
+                    .querySelector('meta[name="api-token"]')
+                    .getAttribute("content")}`,
+            },
+            init: function () {
+                this.on("success", function (file, response) {
+                    document.getElementById("toast-message").innerText =
+                        response.message;
+                    toast.show();
+                    setTimeout(() => {
+                        window.location.href = "/data/business-industries";
+                    }, 2000);
+                });
+                this.on("error", function (file, errorMessage) {
+                    console.error("Error uploading file:", file);
+                    console.error("Error message:", errorMessage);
+
+                    document.getElementById("toast-message").innerText =
+                        errorMessage.message;
+                    toast.show();
+                    uploadButton.disabled = false;
+                    spinner.classList.add("d-none");
+                });
+            },
+        })));
+
+// Add event listener to control the submission manually
+document
+    .querySelector("#btnUploadBusinessIndustry")
+    .addEventListener("click", function () {
+        console.log("Ini adalah value dropzone", dropzone.files[0]);
+        const formData = new FormData();
+
+        if (dropzone.files.length > 0) {
+            formData.append("file", dropzone.files[0]);
+            dropzone.processQueue(); // Ini akan manual memicu upload
+            uploadButton.disabled = true;
+            spinner.classList.remove("d-none");
+        } else {
+            document.getElementById("toast-message").innerText =
+                "Please add a file first.";
+            toast.show();
+            uploadButton.disabled = false;
+            spinner.classList.add("d-none");
+        }
+    });
+
+dropzone.on("addedfile", function (file) {});
+
+dropzone.on("complete", function (file) {
+    dropzone.removeFile(file);
+});