create file automation deployment using sh

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/Console/Commands/ExecuteScraping.php

@@ -2,6 +2,7 @@
 
 namespace App\Console\Commands;
 
+use App\Jobs\SyncronizeSIMBG;
 use App\Services\ServiceSIMBG;
 use Illuminate\Console\Command;
 use \Illuminate\Support\Facades\Log;
@@ -28,13 +29,12 @@ class ExecuteScraping extends Command
 
     private $service_simbg;
 
-    public function __construct(ServiceSIMBG $service_simbg){
+    public function __construct(){
-        $this->service_simbg = $service_simbg;
         parent::__construct();
     }
     public function handle()
     {
+        SyncronizeSIMBG::dispatch();
         Log::info("running scheduler daily scraping");
-        $this->service_simbg->syncTaskList();
     }
 }

app/Http/Controllers/Api/BigDataResumeController.php

@@ -3,6 +3,7 @@
 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;
@@ -18,11 +19,12 @@ class BigDataResumeController extends Controller
         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();
+                $big_data_resume = BigdataResume::where('year', now()->year)->latest()->first();
+                if (!$big_data_resume) {
+                    return $this->response_empty_resume();
+                }
             } else {
-                // Filter by specific date
                 $big_data_resume = BigdataResume::whereDate('created_at', $filterDate)
                     ->orderBy('id', 'desc')
                     ->first();
@@ -37,15 +39,19 @@ class BigDataResumeController extends Controller
                 return response()->json(['message' => 'No data setting found']);
             }
 
-            $target_pad = floatval(optional($data_settings->where('key', 'TARGET_PAD')->first())->value);
+            function cleanNumber($value) {
-            $tata_ruang = floatval(optional($data_settings->where('key', 'TATA_RUANG')->first())->value);
+            return floatval(str_replace('.', '', $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);
 
+            $target_pad = floatval(optional($data_settings->where('key', 'TARGET_PAD')->first())->value);
+            $realisasi_terbit_pbg_sum = cleanNumber(optional($data_settings->where('key', 'REALISASI_TERBIT_PBG_SUM')->first())->value);
+            $realisasi_terbit_pbg_count = cleanNumber(optional($data_settings->where('key', 'REALISASI_TERBIT_PBG_COUNT')->first())->value);
+            $menunggu_klik_dpmptsp_sum = cleanNumber(optional($data_settings->where('key', 'MENUNGGU_KLIK_DPMPTSP_SUM')->first())->value);
+            $menunggu_klik_dpmptsp_count = cleanNumber(optional($data_settings->where('key', 'MENUNGGU_KLIK_DPMPTSP_COUNT')->first())->value);
+            $proses_dinas_teknis_sum = cleanNumber(optional($data_settings->where('key', 'PROSES_DINAS_TEKNIS_SUM')->first())->value);
+            $proses_dinas_teknis_count = cleanNumber(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
@@ -81,8 +87,8 @@ class BigDataResumeController extends Controller
             ? 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
+            $menunggu_klik_dpmptsp_percentage = $big_data_resume->verified_sum > 0 && $menunggu_klik_dpmptsp_sum > 0
-            ? round(($menuggu_klik_dpmptsp_sum / $big_data_resume->verified_sum) * 100, 2) : 0;
+            ? round(($menunggu_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
@@ -94,7 +100,8 @@ class BigDataResumeController extends Controller
                     'percentage' => 100,
                 ],
                 'tata_ruang' => [
-                    'sum' => $tata_ruang,
+                    'sum' => $big_data_resume->spatial_sum,
+                    'count' => $big_data_resume->spatial_count,
                     'percentage' => $tata_ruang_percentage,
                 ],
                 'kekurangan_potensi' => [
@@ -132,8 +139,8 @@ class BigDataResumeController extends Controller
                     'percentage' => $realisasi_terbit_percentage
                 ],
                 'menunggu_klik_dpmptsp' => [
-                    'sum' => $menuggu_klik_dpmptsp_sum,
+                    'sum' => $menunggu_klik_dpmptsp_sum,
-                    'count' => $menuggu_klik_dpmptsp_count,
+                    'count' => $menunggu_klik_dpmptsp_count,
                     'percentage' => $menunggu_klik_dpmptsp_percentage
                 ],
                 'proses_dinas_teknis' => [
@@ -148,36 +155,22 @@ class BigDataResumeController extends Controller
         }
     }
 
-    /**
-     * Store a newly created resource in storage.
-     */
-    public function store(Request $request)
-    {
-        //
-    }
 
-    /**
-     * Display the specified resource.
-     */
-    public function show(string $id)
-    {
-        //
-    }
 
-    /**
+    public function bigdata_report(Request $request){
-     * Update the specified resource in storage.
+        try{
-     */
+            $query = BigdataResume::query()->orderBy('id', 'desc');
-    public function update(Request $request, string $id)
+        
-    {
+            if($request->filled('search')){
-        //
+                $query->where('name', 'LIKE', '%'.$request->input('search').'%');
-    }
+            }
 
-    /**
+            $query = $query->paginate(config('app.paginate_per_page', 50));
-     * Remove the specified resource from storage.
+            return  BigdataResumeResource::collection($query)->response()->getData(true);
-     */
+        }catch(\Exception $e){
-    public function destroy(string $id)
+            Log::error($e->getMessage());
-    {
+            return response()->json(['message' => 'Error when fetching data'], 500);
-        //
+        }
     }
 
     private function response_empty_resume(){

app/Http/Controllers/Api/BusinessOrIndustriesController.php

@@ -9,6 +9,7 @@ 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
 {
     /**
@@ -30,7 +31,7 @@ class BusinessOrIndustriesController extends Controller
             });
         }
 
-        return response()->json($query->paginate());
+        return response()->json($query->paginate(config('app.paginate_per_page', 50)));
     }
 
     /**
@@ -79,29 +80,15 @@ class BusinessOrIndustriesController extends Controller
         }
     }
 
-    public function upload(Request $request){
+    public function upload(ExcelUploadRequest $request){
-
-        if ($request->hasFile('file')) {
-            $file = $request->file('file');
-        }
-
-        // Validasi file
-        $validator = Validator::make($request->all(), [
-            'file' => 'required|mimes:xlsx,xls|max:102400', // Max 100MB
-        ]);
-
-        if ($validator->fails()) {
-            return response()->json([
-                'message' => 'File validation failed.',
-                'errors' => $validator->errors()
-            ], 400);
-        }
-
         try {
-            // Ambil file dari request
+            if(!$request->hasFile('file')){
-            $file = $request->file('file');
+                return response()->json([
+                   'error' => 'No file provided'
+                ], 400);
+            }
 
-            // Menggunakan Laravel Excel untuk mengimpor file
+            $file = $request->file('file');
             Excel::import(new BusinessIndustriesImport, $file);
 
             // Jika sukses, kembalikan respons sukses

app/Http/Controllers/Api/CustomersController.php

@@ -22,9 +22,9 @@ class CustomersController extends Controller
         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_palayanan', 'LIKE', '%'.$request->get('search').'%');
+                ->orWhere('kota_pelayanan', 'LIKE', '%'.$request->get('search').'%');
         }
-        return CustomersResource::collection($query->paginate());
+        return CustomersResource::collection($query->paginate(config('app.paginate_per_page', 50)));
     }
 
     /**

app/Http/Controllers/Api/ImportDatasourceController.php

@@ -24,7 +24,7 @@ class ImportDatasourceController extends Controller
             $search = $request->get("search");
             $query->where('status', 'like', "%".$search."%");
         }
-        return ImportDatasourceResource::collection($query->paginate());
+        return ImportDatasourceResource::collection($query->paginate(config('app.paginate_per_page', 50)));
     }
 
     public function checkImportDatasource(){

app/Http/Controllers/Api/LackOfPotentialController.php

@@ -7,6 +7,7 @@ use App\Models\Advertisement;
 use App\Models\Customer;
 use App\Models\SpatialPlanning;
 use Illuminate\Http\Request;
+use App\Models\TourismBasedKBLI;
 
 class LackOfPotentialController extends Controller
 {
@@ -16,11 +17,13 @@ class LackOfPotentialController extends Controller
             $total_reklame = Advertisement::count();
             $total_pdam = Customer::count();
             $total_tata_ruang = SpatialPlanning::count();
+            $data_report_tourism = TourismBasedKBLI::all();
 
             return response()->json([
                 'total_reklame' => $total_reklame,
                 'total_pdam' => $total_pdam,
-                'total_tata_ruang' => $total_tata_ruang
+                'total_tata_ruang' => $total_tata_ruang,
+                'data_report' => $data_report_tourism,
             ], 200);
         }catch(\Exception $e){
             return response()->json([

app/Http/Controllers/Api/MenusController.php

@@ -22,7 +22,7 @@ class MenusController extends Controller
             $query = $query->where("name", "like", "%".$request->get("search")."%");
         }
 
-        return response()->json($query->paginate());
+        return response()->json($query->paginate(config('app.paginate_per_page', 50)));
     }
 
     /**

app/Http/Controllers/Api/RequestAssignmentController.php

@@ -17,7 +17,8 @@ class RequestAssignmentController extends Controller
         $query = PbgTask::query()->orderBy('id', 'desc');
         if($request->has('search') && !empty($request->get("search"))){
             $query->where('name', 'LIKE', '%'.$request->get('search').'%')
-            ->orWhere('registration_number', 'LIKE', '%'.$request->get('search').'%');
+            ->orWhere('registration_number', 'LIKE', '%'.$request->get('search').'%')
+            ->orWhere('document_number', 'LIKE', '%'.$request->get('search').'%');
         }
         return RequestAssignmentResouce::collection($query->paginate());
     }

app/Http/Controllers/Api/RolesController.php

@@ -20,7 +20,7 @@ class RolesController extends Controller
             $query = $query->where('name', 'like', '%'. $request->get('search') . '%');
         }
 
-        return response()->json($query->paginate());
+        return response()->json($query->paginate(config('app.paginate_per_page', 50)));
     }
 
     /**

app/Http/Controllers/Api/ScrapingController.php

@@ -4,6 +4,7 @@ namespace App\Http\Controllers\Api;
 
 use App\Enums\ImportDatasourceStatus;
 use App\Http\Controllers\Controller;
+use App\Jobs\SyncronizeSIMBG;
 use App\Models\ImportDatasource;
 use App\Traits\GlobalApiResponse;
 use Illuminate\Support\Facades\Artisan;
@@ -23,8 +24,8 @@ class ScrapingController extends Controller
         }
 
         // run service artisan command 
-        Artisan::call("app:execute-scraping");
+        SyncronizeSIMBG::dispatch();
-        return $this->resSuccess("Success execute scraping service please wait");
+        return $this->resSuccess(["message" => "Success execute scraping service on background, check status for more"]);
     }
 
     /**

app/Http/Controllers/Api/UsersController.php

@@ -31,7 +31,7 @@ class UsersController extends Controller
         if($request->has('search') && !empty($request->get("search"))){
             $query->where('name', 'LIKE', '%'.$request->get('search').'%');
         }
-        return UserResource::collection($query->paginate());
+        return UserResource::collection($query->paginate(config('app.paginate_per_page', 50)));
     }
     public function logout(Request $request){
         $request->user()->tokens()->delete();

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/Settings/SyncronizeController.php

@@ -17,12 +17,12 @@ class SyncronizeController extends Controller
     }
 
     public function syncPbgTask(){
-        $res = $this->service_simbg->syncTaskList();
+        $res = $this->service_simbg->syncTaskPBG();
         return $res;
     }
 
     public function syncronizeTask(Request $request){
-        $res = $this->service_simbg->syncTaskList();
+        $res = $this->service_simbg->syncTaskPBG();
         return redirect()->back()->with('success', 'Processing completed successfully');
     }
 

app/Http/Resources/BigdataResumeResource.php

@@ -0,0 +1,51 @@
+<?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, ',', '.'),
+            
+            'issuance_realization_pbg_count'        => (int) $this->issuance_realization_pbg_count,
+            'issuance_realization_pbg_sum'          => number_format((float) $this->issuance_realization_pbg_sum, 2, ',', '.'),
+            
+            'waiting_click_dpmptsp_count'        => (int) $this->waiting_click_dpmptsp_count,
+            'waiting_click_dpmptsp_sum'          => number_format((float) $this->waiting_click_dpmptsp_sum, 2, ',', '.'),
+            
+            'process_in_technical_office_count'        => (int) $this->process_in_technical_office_count,
+            'process_in_technical_office_sum'          => number_format((float) $this->process_in_technical_office_sum, 2, ',', '.'),
+            
+            'year'                 => $this->year,
+            'created_at' => $this->created_at->toDateTimeString(),
+        ];
+    }
+}

app/Imports/BusinessIndustriesImport.php

@@ -3,37 +3,105 @@
 namespace App\Imports;
 
 use App\Models\BusinessOrIndustry;
-use Maatwebsite\Excel\Concerns\ToModel;
-use Maatwebsite\Excel\Concerns\ToCollection;
 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
+class BusinessIndustriesImport implements ToCollection, WithMultipleSheets, WithChunkReading, WithBatchInserts, ShouldQueue, WithHeadingRow
 {
     /**
-    * @param array $row
+    * @param Collection $collection
-    *
+    */    
-    * @return \Illuminate\Database\Eloquent\Model|null
+    public function collection(Collection $collection)
-    */
-    public function collection(Collection $rows)
     {
-        foreach ($rows->skip(1) as $row){
+        try{
-            $clean_nop = preg_replace('/[^A-Za-z0-9]/', '', $row[2]);
+            $batchData = [];
-            if (!BusinessOrIndustry::where('nop', $clean_nop)->exists()) {
+            $batchSize = 1000;
-                BusinessOrIndustry::create([
+    
-                    'nama_kecamatan'     => $row[0],
+            foreach ($collection as $row){
-                    'nama_kelurahan'     => $row[1],
+                if(!isset($row['nop']) || empty($row['nop'])){
-                    'nop'                => $clean_nop, // Store cleaned 'nop'
+                    continue;
-                    'nama_wajib_pajak'   => $row[3],
+                }
-                    'alamat_wajib_pajak' => $row[4], 
+    
-                    'alamat_objek_pajak' => $row[5], 
+    
-                    'luas_bumi'          => $row[6], 
+                $clean_nop = preg_replace('/[^A-Za-z0-9]/', '', $row['nop']);
-                    'luas_bangunan'      => $row[7], 
+    
-                    'njop_bumi'          => $row[8], 
+                $batchData[] = [
-                    'njop_bangunan'      => $row[9], 
+                        'nama_kecamatan'     => $row['nama_kecamatan'],
-                    'ketetapan'          => $row[10], 
+                        'nama_kelurahan'     => $row['nama_kelurahan'],
-                    'tahun_pajak'        => $row[11], 
+                        '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

@@ -11,32 +11,61 @@ 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
+class CustomersImport implements ToCollection, WithMultipleSheets, WithChunkReading, WithBatchInserts, ShouldQueue, WithHeadingRow
 {
     /**
     * @param Collection $collection
-    */
+    */    
     public function collection(Collection $collection)
     {
         $batchData = [];
+        $batchSize = 1000;
 
-        foreach ($collection->skip(1) as $row) {
+        foreach ($collection as $row) {
-            if (!isset($row[0]) || empty($row[0])) {
+            if (!isset($row['nomor_pelanggan']) || empty($row['nomor_pelanggan'])) {
                 continue;
             }
 
-            $latitude = filter_var($row[4], FILTER_VALIDATE_FLOAT) ? bcadd($row[4], '0', 18) : null;
+            $latitude = '0';
-            $longitude = filter_var($row[5], FILTER_VALIDATE_FLOAT) ? bcadd($row[5], '0', 18) : null;
+            $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[0],
+                'nomor_pelanggan' => $row['nomor_pelanggan'] ?? '',
-                'kota_pelayanan' => $row[1],
+                'kota_pelayanan' => $row['kota_pelayanan'] ?? '',
-                'nama' => $row[2],
+                'nama' => $row['nama'] ?? '',
-                'alamat' => $row[3],
+                '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)) {
@@ -44,9 +73,20 @@ class CustomersImport implements ToCollection, WithMultipleSheets
         }
     }
 
+
     public function sheets(): array {
         return [
             0 => $this
         ];
     }
+
+    public function chunkSize(): int
+    {
+        return 1000;
+    }
+
+    public function batchSize(): int
+    {
+        return 1000;
+    }
 }

app/Jobs/SyncronizeSIMBG.php

@@ -0,0 +1,27 @@
+<?php
+
+namespace App\Jobs;
+
+use App\Services\GoogleSheetService;
+use App\Services\ServiceSIMBG;
+use Illuminate\Bus\Queueable;
+use Illuminate\Contracts\Queue\ShouldQueue;
+use Illuminate\Foundation\Bus\Dispatchable;
+use Illuminate\Queue\InteractsWithQueue;
+use Illuminate\Queue\SerializesModels;
+
+class SyncronizeSIMBG implements ShouldQueue
+{
+    use Dispatchable, InteractsWithQueue, Queueable, SerializesModels;
+
+
+    public function __construct()
+    {
+    }
+
+    public function handle(): void
+    {
+        $serviceSIMBG = app(ServiceSIMBG::class);
+        $serviceSIMBG->syncTaskPBG();
+    }
+}

app/Models/BigdataResume.php

@@ -21,6 +21,15 @@ class BigdataResume extends Model
         'business_sum',
         'non_business_count',
         'non_business_sum',
+        'spatial_count',
+        'spatial_sum',
+        'year',
+        'waiting_click_dpmptsp_count',
+        'waiting_click_dpmptsp_sum',
+        'issuance_realization_pbg_count',
+        'issuance_realization_pbg_sum',
+        'process_in_technical_office_count',
+        'process_in_technical_office_sum',
     ];
 
     public function importDatasource()
@@ -28,88 +37,84 @@ 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, $data_setting){
-        $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::leftJoin('spatial_plannings as sp', 'pbg_task.document_number', '=', 'sp.number')
+                ->leftJoin('pbg_task_retributions as ptr', 'ptr.pbg_task_uid', '=', 'pbg_task.uuid')
+                ->selectRaw('
+                    CASE 
+                        WHEN COUNT(DISTINCT sp.id) > 0 THEN COUNT(DISTINCT sp.id)
+                        ELSE (SELECT COUNT(*) FROM spatial_plannings) 
+                    END as task_count,
+                    SUM(CASE WHEN sp.id IS NOT NULL AND ptr.id IS NOT NULL THEN ptr.nilai_retribusi_bangunan ELSE 0 END) 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;
+
+        $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 +125,13 @@ 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,
+            'waiting_click_dpmptsp_count' => $data_setting['MENUNGGU_KLIK_DPMPTSP_COUNT'] ?? 0,
+            'waiting_click_dpmptsp_sum' => $data_setting['MENUNGGU_KLIK_DPMPTSP_SUM'] ?? 0.00,
+            'issuance_realization_pbg_count' => $data_setting['REALISASI_TERBIT_PBG_COUNT'] ?? 0,
+            'issuance_realization_pbg_sum' => $data_setting['REALISASI_TERBIT_PBG_SUM'] ?? 0.00,
+            'process_in_technical_office_count' => $data_setting['PROSES_DINAS_TEKNIS_COUNT'] ?? 0,
+            'process_in_technical_office_sum' => $data_setting['PROSES_DINAS_TEKNIS_SUM'] ??0.00,
         ]);
     }
 }

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/Providers/AppServiceProvider.php

@@ -9,6 +9,8 @@ use Illuminate\Support\Facades\Blade;
 use Illuminate\Support\Facades\View;
 use Illuminate\Support\ServiceProvider;
 use Carbon\Carbon;
+use App\Services\ServiceSIMBG;
+use App\Services\GoogleSheetService;
 
 class AppServiceProvider extends ServiceProvider
 {
@@ -17,7 +19,9 @@ class AppServiceProvider extends ServiceProvider
      */
     public function register(): void
     {
-        //
+        $this->app->singleton(ServiceSIMBG::class, function ($app) {
+            return new ServiceSIMBG($app->make(GoogleSheetService::class));
+        });
     }
 
     /**

app/Services/GoogleSheetService.php

@@ -13,6 +13,7 @@ class GoogleSheetService
     protected $client;
     protected $service;
     protected $spreadsheetID;
+    protected $service_sheets;
     public function __construct()
     {
         $this->client = new Google_Client();

app/Services/ServiceSIMBG.php

@@ -15,6 +15,9 @@ use App\Traits\GlobalApiResponse;
 use Illuminate\Support\Facades\Log;
 use Carbon\Carbon;
 use App\Services\ServiceClient;
+use App\Services\GoogleSheetService;
+use App\Models\DataSetting;
+use App\Models\PbgTaskGoogleSheet;
 
 class ServiceSIMBG
 {
@@ -24,10 +27,11 @@ class ServiceSIMBG
     private $simbg_host;
     private $fetch_per_page;
     private $service_client;
+    private $googleSheetService;
     /**
      * Create a new class instance.
      */
-    public function __construct()
+    public function __construct(GoogleSheetService $googleSheetService)
     {
         $settings = GlobalSetting::whereIn('key', [
             'SIMBG_EMAIL', 'SIMBG_PASSWORD', 'SIMBG_HOST', 'FETCH_PER_PAGE'
@@ -39,6 +43,7 @@ class ServiceSIMBG
         $this->fetch_per_page = trim((string) ($settings['FETCH_PER_PAGE'] ?? ""));
     
         $this->service_client = new ServiceClient($this->simbg_host);
+        $this->googleSheetService = $googleSheetService;
     }
 
     public function getToken(){
@@ -81,13 +86,13 @@ class ServiceSIMBG
                 if (empty($res->original['success']) || !$res->original['success']) {
                     // Log error
                     Log::error("API response indicates failure", ['url' => $url, 'uuid' => $uuid]);
-                    return false;
+                    continue;
                 }
             
                 $data = $res->original['data']['data'] ?? null;
                 if (!$data) {
                     Log::error("No valid data returned from API", ['url' => $url, 'uuid' => $uuid]);
-                    return false;
+                    continue;
                 }
 
                 $integrations[] = [
@@ -104,19 +109,6 @@ class ServiceSIMBG
 
             PbgTaskIndexIntegrations::upsert($integrations, ['pbg_task_uid'], ['indeks_fungsi_bangunan', 
             'indeks_parameter_kompleksitas', 'indeks_parameter_permanensi', 'indeks_parameter_ketinggian', 'faktor_kepemilikan', 'indeks_terintegrasi', 'total']);
-        
-            // $resultData = PbgTaskIndexIntegrations::updateOrCreate(
-            //     ['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,
-            //         'indeks_parameter_ketinggian' => $data['indeks_parameter_ketinggian'] ?? null,
-            //         'faktor_kepemilikan' => $data['faktor_kepemilikan'] ?? null,
-            //         'indeks_terintegrasi' => $data['indeks_terintegrasi'] ?? null,
-            //         'total' => $data['total'] ?? null,
-            //     ]
-            // );
             
             return true;
         }catch (Exception $e){
@@ -125,135 +117,298 @@ class ServiceSIMBG
         }
     }
 
-    public function syncTaskList()
+    public function syncTaskPBG()
     {
-        $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'];
+            // sync google sheet first
-        $headers = ['Authorization' => "Bearer " . $apiToken];
+            $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;
+                }
+            }
 
-        $url = "/api/pbg/v1/list/?page=1&size={$this->fetch_per_page}&sort=ASC";
+            foreach ($data_setting_result as $key => $value) {
-        $initialResponse = $this->service_client->get($url, $headers);
+                DataSetting::updateOrInsert(
+                    ["key" => $key], // Find by key
+                    ["value" => $value] // Update or insert value
+                );
+            }
+            $mapToUpsert = [];
+            $count = 0;
 
-        $totalPage = $initialResponse->original['data']['total_page'] ?? 0;
+            foreach($sheetData as $data){
-        if ($totalPage == 0) {
+                $mapToUpsert[] = 
-            $importDatasource->update([
+                    [
-                'status' => ImportDatasourceStatus::Failed->value,
+                        'no_registrasi' => $data['no__registrasi'] ?? null,
-                'message' => 'Invalid response: no total_page'
+                        'jenis_konsultasi' => $data['jenis_konsultasi'] ?? null,
-            ]);
+                        'fungsi_bg' => $data['fungsi_bg'] ?? null,
-            return $this->resError("Invalid response from API");
+                        'tgl_permohonan' => $this->convertToDate($data['tgl_permohonan']),
-        }
+                        'status_verifikasi' => $data['status_verifikasi'] ?? null,
+                        'status_permohonan' => $this->convertToDate($data['status_permohonan']),
+                        'alamat_pemilik' => $data['alamat_pemilik'] ?? null,
+                        'no_hp' => $data['no__hp'] ?? null,
+                        'email' => $data['e_mail'] ?? null,
+                        'tanggal_catatan' => $this->convertToDate($data['tanggal_catatan']),
+                        'catatan_kekurangan_dokumen' => $data['catatan_kekurangan_dokumen'] ?? null,
+                        'gambar' => $data['gambar'] ?? null,
+                        'krk_kkpr' => $data['krk_kkpr'] ?? null,
+                        'no_krk' => $data['no__krk'] ?? null,
+                        'lh' => $data['lh'] ?? null,
+                        'ska' => $data['ska'] ?? null,
+                        'keterangan' => $data['keterangan'] ?? null,
+                        'helpdesk' => $data['helpdesk'] ?? null,
+                        'pj' => $data['pj'] ?? null,
+                        'kepemilikan' => $data['kepemilikan'] ?? null,
+                        'potensi_taru' => $data['potensi_taru'] ?? null,
+                        'validasi_dinas' => $data['validasi_dinas'] ?? null,
+                        'kategori_retribusi' => $data['kategori_retribusi'] ?? null,
+                        'no_urut_ba_tpt' => $data['no__urut_ba_tpt__2024_0001_'] ?? null,
+                        'tanggal_ba_tpt' => $this->convertToDate($data['tanggal_ba_tpt']),
+                        'no_urut_ba_tpa' => $data['no__urut_ba_tpa'] ?? null,
+                        'tanggal_ba_tpa' => $this->convertToDate($data['tanggal_ba_tpa']),
+                        'no_urut_skrd' => $data['no__urut_skrd__2024_0001_'] ?? null,
+                        'tanggal_skrd' => $this->convertToDate($data['tanggal_skrd']),
+                        'ptsp' => $data['ptsp'] ?? null,
+                        'selesai_terbit' => $data['selesai_terbit'] ?? null,
+                        'tanggal_pembayaran' => $this->convertToDate($data['tanggal_pembayaran__yyyy_mm_dd_']),
+                        'format_sts' => $data['format_sts'] ?? null,
+                        'tahun_terbit' => (int) $data['tahun_terbit'] ?? null,
+                        'tahun_berjalan' => (int) $data['tahun_berjalan'] ?? null,
+                        'kelurahan' => $data['kelurahan'] ?? null,
+                        'kecamatan' => $data['kecamatan'] ?? null,
+                        'lb' => $this->convertToDecimal($data['lb'])  ?? null,
+                        'tb' => $this->convertToDecimal($data['tb']) ?? null,
+                        'jlb' => (int) $data['jlb'] ?? null,
+                        'unit' => (int) $data['unit'] ?? null,
+                        'usulan_retribusi' => (int) $data['usulan_retribusi'] ?? null,
+                        'nilai_retribusi_keseluruhan_simbg' => $this->convertToDecimal($data['nilai_retribusi_keseluruhan__simbg_']) ?? null,
+                        'nilai_retribusi_keseluruhan_pad' => $this->convertToDecimal($data['nilai_retribusi_keseluruhan__pad_']) ?? null,
+                        'denda' => $this->convertToDecimal($data['denda']) ?? null,
+                        'latitude' => $data['latitude'] ?? null,
+                        'longitude' => $data['longitude'] ?? null,
+                        'nik_nib' => $data['nik_nib'] ?? null,
+                        'dok_tanah' => $data['dok__tanah'] ?? null,
+                        'temuan' => $data['temuan'] ?? null,
+                    ];
+            }
 
-        $savedCount = $failedCount = 0;
+            $batchSize = 1000;
+            $chunks = array_chunk($mapToUpsert, $batchSize);
 
-        for ($currentPage = 1; $currentPage <= $totalPage; $currentPage++) {
+            foreach($chunks as $chunk){
-            $pageUrl = "/api/pbg/v1/list/?page={$currentPage}&size={$this->fetch_per_page}&sort=ASC";
+                PbgTaskGoogleSheet::upsert($chunk, ["no_registrasi"],[
-            $getToken = $this->getToken();
+                    'jenis_konsultasi',
-            Log::info("response index integration", ['currentPage' => $currentPage]);
+                    'nama_pemilik',
-            if (empty($getToken->original['data']['token']['access'])) {
+                    'lokasi_bg',
+                    'fungsi_bg',
+                    'nama_bangunan',
+                    'tgl_permohonan',
+                    'status_verifikasi',
+                    'status_permohonan',
+                    'alamat_pemilik',
+                    'no_hp',
+                    'email',
+                    'tanggal_catatan',
+                    'catatan_kekurangan_dokumen',
+                    'gambar',
+                    'krk_kkpr',
+                    'no_krk',
+                    'lh',
+                    'ska',
+                    'keterangan',
+                    'helpdesk',
+                    'pj',
+                    'kepemilikan',
+                    'potensi_taru',
+                    'validasi_dinas',
+                    'kategori_retribusi',
+                    'no_urut_ba_tpt',
+                    'tanggal_ba_tpt',
+                    'no_urut_ba_tpa',
+                    'tanggal_ba_tpa',
+                    'no_urut_skrd',
+                    'tanggal_skrd',
+                    'ptsp',
+                    'selesai_terbit',
+                    'tanggal_pembayaran',
+                    'format_sts',
+                    'tahun_terbit',
+                    'tahun_berjalan',
+                    'kelurahan',
+                    'kecamatan',
+                    'lb',
+                    'tb',
+                    'jlb',
+                    'unit',
+                    'usulan_retribusi',
+                    'nilai_retribusi_keseluruhan_simbg',
+                    'nilai_retribusi_keseluruhan_pad',
+                    'denda',
+                    'latitude',
+                    'longitude',
+                    'nik_nib',
+                    'dok_tanah',
+                    'temuan',
+                ]);
+            }
+            
+            $initResToken = $this->getToken();
+            if (empty($initResToken->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'];
+            $apiToken = $initResToken->original['data']['token']['access'];
-            $headers = ['Authorization' => "Bearer " . $token];
+            $headers = ['Authorization' => "Bearer " . $apiToken];
-            $response = $this->service_client->get($pageUrl, $headers);
-            $tasks = $response->original['data']['data'] ?? [];
 
-            if (empty($tasks)) {
+            $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", $data_setting_result);
-                'name', 'owner_name', 'application_type', 'application_type_name', 'condition',
+            BigdataResume::generateResumeData($importDatasource->id, now()->year, $data_setting_result);
-                '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"
             ]);
             
-            $uuids = array_column($tasksCollective, 'uuid');
+            Log::info("syncTaskList completed", ['savedCount' => $savedCount, 'failedCount' => $failedCount]);
-            $this->syncIndexIntegration($uuids, $token);
+
+            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{
@@ -334,5 +489,59 @@ class ServiceSIMBG
             throw $e;
         }
     }
+    protected function convertToDecimal(?string $value): ?float
+    {
+        if (empty($value)) {
+            return null; // Return null if the input is empty
+        }
 
+        // Remove all non-numeric characters except comma and dot
+        $value = preg_replace('/[^0-9,\.]/', '', $value);
+
+        // If the number contains both dot (.) and comma (,)
+        if (strpos($value, '.') !== false && strpos($value, ',') !== false) {
+            $value = str_replace('.', '', $value); // Remove thousands separator
+            $value = str_replace(',', '.', $value); // Convert decimal separator to dot
+        }
+        // If only a dot is present (assumed as thousands separator)
+        elseif (strpos($value, '.') !== false) {
+            $value = str_replace('.', '', $value); // Remove all dots (treat as thousands separators)
+        }
+        // If only a comma is present (assumed as decimal separator)
+        elseif (strpos($value, ',') !== false) {
+            $value = str_replace(',', '.', $value); // Convert comma to dot (decimal separator)
+        }
+
+        // Ensure the value is numeric before returning
+        return is_numeric($value) ? (float) number_format((float) $value, 2, '.', '') : null;
+    }
+
+    protected function convertToInteger($value) {
+        // Check if the value is an empty string, and return null if true
+        if (trim($value) === "") {
+            return null;
+        }
+
+        // Otherwise, cast to integer
+        return (int) $value;
+    }
+
+    protected function convertToDate($dateString)
+    {
+        try {
+            // Check if the string is empty
+            if (empty($dateString)) {
+                return null;
+            }
+
+            // Try to parse the date string
+            $date = Carbon::parse($dateString);
+
+            // Return the Carbon instance
+            return $date->format('Y-m-d');
+        } catch (Exception $e) {
+            // Return null if an error occurs during parsing
+            return null;
+        }
+    }
 }

config/app.php

@@ -123,5 +123,6 @@ return [
         'store' => env('APP_MAINTENANCE_STORE', 'database'),
     ],
 
-    'api_url' => env('API_URL', 'http://localhost:8000')
+    'api_url' => env('API_URL', 'http://localhost:8000'),
+    'paginate_per_page' => 50
 ];

config/queue.php

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

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/migrations/2025_03_03_174851_add_some_column_in_bigdata_resumes.php

@@ -0,0 +1,38 @@
+<?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('waiting_click_dpmptsp_count')->default(0);
+            $table->decimal('waiting_click_dpmptsp_sum', 20,2)->default(0);
+            $table->integer('issuance_realization_pbg_count')->default(0);
+            $table->decimal('issuance_realization_pbg_sum', 20,2)->default(0);
+            $table->integer('process_in_technical_office_count')->default(0);
+            $table->decimal('process_in_technical_office_sum', 20,2)->default(0);
+        });
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        Schema::table('bigdata_resumes', function (Blueprint $table) {
+            $table->dropColumn('waiting_click_dpmptsp_count');
+            $table->dropColumn('waiting_click_dpmptsp_sum');
+            $table->dropColumn('issuance_realization_pbg_count');
+            $table->dropColumn('issuance_realization_pbg_sum');
+            $table->dropColumn('process_in_technical_office_count');
+            $table->dropColumn('process_in_technical_office_sum');
+        });
+    }
+};

database/seeders/UsersRoleMenuSeeder.php

@@ -71,7 +71,7 @@ class UsersRoleMenuSeeder extends Seeder
             [
                 "name" => "Laporan",
                 "url" => "/laporan",
-                "icon" => "mingcute:task-line",
+                "icon" => "mingcute:report-line",
                 "parent_id" => null,
                 "sort_order" => 6,
             ]
@@ -214,6 +214,13 @@ class UsersRoleMenuSeeder extends Seeder
                 "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) {
@@ -237,6 +244,7 @@ class UsersRoleMenuSeeder extends Seeder
         $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([
@@ -265,6 +273,7 @@ class UsersRoleMenuSeeder extends Seeder
             $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
@@ -279,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]);
     }

deploy.sh

@@ -0,0 +1,38 @@
+GIT_BRANCH="dev"
+PHP_VERSION="php8.3"
+
+echo "🚀 Starting deployment..."
+php artisan down
+
+echo "📥 Pulling latest changes from Git..."
+git fetch origin $GIT_BRANCH
+git reset --hard origin/$GIT_BRANCH
+git pull origin $GIT_BRANCH
+
+echo "⚡ Installing NPM dependencies and building assets..."
+npm ci --no-audit --no-fund
+npm run build
+
+echo "📦 Installing composer dependencies..."
+composer install --no-interaction --optimize-autoloader
+
+echo "🗄️ Running migrations..."
+php artisan migrate --force
+
+echo "⚡ Optimizing application..."
+php artisan cache:clear
+php artisan config:clear
+php artisan config:cache
+php artisan route:cache
+php artisan view:cache
+
+echo "🔄 Restarting PHP service..."
+systemctl restart $PHP_VERSION-fpm
+
+echo "🔁 Restarting Supervisor queue workers..."
+supervisorctl stop all
+supervisorctl reload
+supervisorctl start all
+
+php artisan up
+echo "🚀 Deployment completed successfully!"

package.json

@@ -1,36 +1,37 @@
 {
-  "private": true,
+    "private": true,
-  "type": "module",
+    "type": "module",
-  "scripts": {
+    "scripts": {
-    "build": "vite build",
+        "build": "vite build",
-    "dev": "vite"
+        "dev": "vite"
-  },
+    },
-  "devDependencies": {
+    "devDependencies": {
-    "autoprefixer": "^10.4.20",
+        "autoprefixer": "^10.4.20",
-    "axios": "^1.7.4",
+        "axios": "^1.7.4",
-    "concurrently": "^9.0.1",
+        "concurrently": "^9.0.1",
-    "laravel-vite-plugin": "^1.0",
+        "laravel-vite-plugin": "^1.0",
-    "postcss": "^8.4.47",
+        "postcss": "^8.4.47",
-    "sass": "^1.81.1",
+        "sass": "^1.81.1",
-    "tailwindcss": "^3.4.13",
+        "tailwindcss": "^3.4.13",
-    "vite": "^5.0"
+        "vite": "^5.0"
-  },
+    },
-  "dependencies": {
+    "dependencies": {
-    "apexcharts": "^3.44.2",
+        "apexcharts": "^3.44.2",
-    "big.js": "^6.2.2",
+        "big.js": "^6.2.2",
-    "bootstrap": "^5.3.3",
+        "bootstrap": "^5.3.3",
-    "countup.js": "^2.3.2",
+        "countup.js": "^2.3.2",
-    "dropzone": "^5.9.0",
+        "dropzone": "^5.9.0",
-    "flatpickr": "^4.6.13",
+        "flatpickr": "^4.6.13",
-    "gmaps": "^0.4.25",
+        "gmaps": "^0.4.25",
-    "gridjs": "^5.1.0",
+        "gridjs": "^5.1.0",
-    "iconify-icon": "^2.1.0",
+        "iconify-icon": "^2.1.0",
-    "jsvectormap": "^1.5.1",
+        "jsvectormap": "^1.5.1",
-    "moment": "^2.29.4",
+        "leaflet": "^1.9.4",
-    "node-waves": "^0.7.6",
+        "moment": "^2.29.4",
-    "quill": "^1.3.7",
+        "node-waves": "^0.7.6",
-    "simplebar": "^5.3.9",
+        "quill": "^1.3.7",
-    "sweetalert2": "^11.16.0",
+        "simplebar": "^5.3.9",
-    "wnumb": "^1.2.0"
+        "sweetalert2": "^11.16.0",
-  }
+        "wnumb": "^1.2.0"
+    }
 }

public/index.php

@@ -5,6 +5,7 @@ use Illuminate\Http\Request;
 define('LARAVEL_START', microtime(true));
 
 ini_set('max_execution_time',14400);
+ini_set('memory_limit', '2G');
 
 // Determine if the application is in maintenance mode...
 if (file_exists($maintenance = __DIR__.'/../storage/framework/maintenance.php')) {

resources/js/bigdata-resumes/index.js

@@ -0,0 +1,170 @@
+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");
+        this.table = new Grid({
+            columns: [
+                { name: "ID" },
+                { name: "Jumlah Potensi" },
+                { name: "Total Potensi" },
+                { name: "Jumlah Berkas Belum Terverifikasi" },
+                { name: "Total Berkas Belum Terverifikasi" },
+                { name: "Jumlah Berkas Terverifikasi" },
+                { name: "Total Berkas Terverifikasi" },
+                { name: "Jumlah Usaha" },
+                { name: "Total Usaha" },
+                { name: "Jumlah Non Usaha" },
+                { name: "Total Non Usaha" },
+                { name: "Jumlah Tata Ruang" },
+                { name: "Total Tata Ruang" },
+                { name: "Jumlah Menunggu Klik DPMPTSP" },
+                { name: "Total Menunggu Klik DPMPTSP" },
+                { name: "Jumlah Realisasi Terbit PBG" },
+                { name: "Total Realisasi Terbit PBG" },
+                { name: "Jumlah Proses Dinas Teknis" },
+                { name: "Total Proses Dinas Teknis" },
+                {
+                    name: "Created",
+                    attributes: { style: "width: 200px; white-space: nowrap;" }, // Set width dynamically
+                },
+            ],
+            pagination: {
+                limit: 50,
+                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) => {
+                    return 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),
+                        item.waiting_click_dpmptsp_count,
+                        addThousandSeparators(item.waiting_click_dpmptsp_sum),
+                        item.issuance_realization_pbg_count,
+                        addThousandSeparators(
+                            item.issuance_realization_pbg_sum
+                        ),
+                        item.process_in_technical_office_count,
+                        addThousandSeparators(
+                            item.process_in_technical_office_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

@@ -5,9 +5,9 @@ Dropzone.autoDiscover = false;
 var previewTemplate,
     dropzone,
     dropzonePreviewNode = document.querySelector("#dropzone-preview-list");
-console.log(previewTemplate);
+
-console.log(dropzone);
+const uploadButton = document.getElementById("btnUploadBusinessIndustry");
-console.log(dropzonePreviewNode);
+const spinner = document.getElementById("spinner");
 
 const toastNotification = document.getElementById("toastNotification");
 const toast = new bootstrap.Toast(toastNotification);
@@ -29,97 +29,50 @@ const toast = new bootstrap.Toast(toastNotification);
                     .getAttribute("content")}`,
             },
             init: function () {
-                // Listen for the success event
                 this.on("success", function (file, response) {
-                    console.log("File successfully uploaded:", file);
-                    console.log("API Response:", response);
-
-                    // Show success toast
                     document.getElementById("toast-message").innerText =
                         response.message;
                     toast.show();
-                    document.getElementById("submit-upload").innerHTML =
-                        "Upload Files";
-                    // Tunggu sebentar lalu reload halaman
                     setTimeout(() => {
                         window.location.href = "/data/business-industries";
                     }, 2000);
                 });
-                // Listen for the error event
                 this.on("error", function (file, errorMessage) {
                     console.error("Error uploading file:", file);
                     console.error("Error message:", errorMessage);
-                    // Handle the error response
 
-                    // Show error toast
                     document.getElementById("toast-message").innerText =
                         errorMessage.message;
                     toast.show();
-                    document.getElementById("submit-upload").innerHTML =
+                    uploadButton.disabled = false;
-                        "Upload Files";
+                    spinner.classList.add("d-none");
                 });
             },
         })));
 
 // Add event listener to control the submission manually
-document.querySelector("#submit-upload").addEventListener("click", function () {
+document
-    console.log("Ini adalah value dropzone", dropzone.files[0]);
+    .querySelector("#btnUploadBusinessIndustry")
-    const formData = new FormData();
+    .addEventListener("click", function () {
-    console.log("Dropzonefiles", dropzone.files);
+        console.log("Ini adalah value dropzone", dropzone.files[0]);
+        const formData = new FormData();
 
-    this.innerHTML =
+        if (dropzone.files.length > 0) {
-        '<span class="spinner-border spinner-border-sm me-1" role="status" aria-hidden="true"></span>Loading...';
+            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");
+        }
+    });
 
-    // Pastikan ada file dalam queue sebelum memprosesnya
+dropzone.on("addedfile", function (file) {});
-    if (dropzone.files.length > 0) {
-        formData.append("file", dropzone.files[0]);
-        console.log("ini adalah form data on submit", ...formData);
-        dropzone.processQueue(); // Ini akan manual memicu upload
-    } else {
-        // Show error toast when no file is selected
-        document.getElementById("toast-message").innerText =
-            "Please add a file first.";
-        toast.show();
-
-        document.getElementById("submit-upload").innerHTML = "Upload Files";
-    }
-});
-
-// Optional: Listen for the 'addedfile' event to log or control file add behavior
-dropzone.on("addedfile", function (file) {
-    console.log("File ditambahkan:", file);
-    console.log("Nama File:", file.name);
-    console.log("Tipe File:", file.type);
-    console.log("Ukuran File:", (file.size / 1024).toFixed(2) + " KB");
-});
 
 dropzone.on("complete", function (file) {
     dropzone.removeFile(file);
 });
-
-// Function to show toast
-// function showToast(iconClass, iconColor, message) {
-//     const toastElement = document.getElementById("toastUploadAdvertisement");
-//     const toastBody = toastElement.querySelector(".toast-body");
-//     const toastHeader = toastElement.querySelector(".toast-header");
-
-//     // Remove existing icon (if any) before adding the new one
-//     const existingIcon = toastHeader.querySelector(".bx");
-//     if (existingIcon) {
-//         toastHeader.querySelector(".auth-logo").removeChild(existingIcon); // Remove the existing icon
-//     }
-
-//     // Add the new icon to the toast header
-//     const icon = document.createElement("i");
-//     icon.classList.add("bx", iconClass);
-//     icon.style.fontSize = "25px";
-//     icon.style.color = iconColor;
-//     toastHeader.querySelector(".auth-logo").appendChild(icon);
-
-//     // Set the toast message
-//     toastBody.textContent = message;
-
-//     // Show the toast
-//     const toast = new bootstrap.Toast(toastElement); // Inisialisasi Bootstrap Toast
-//     toast.show();
-// }

resources/js/business-industries/index.js

@@ -64,7 +64,7 @@ class BusinessIndustries {
                 },
             ],
             pagination: {
-                limit: 15,
+                limit: 50,
                 server: {
                     url: (prev, page) =>
                         `${prev}${prev.includes("?") ? "&" : "?"}page=${

resources/js/customers/index.js

@@ -53,7 +53,7 @@ class Customers {
                 },
             ],
             pagination: {
-                limit: 15,
+                limit: 50,
                 server: {
                     url: (prev, page) =>
                         `${prev}${prev.includes("?") ? "&" : "?"}page=${

resources/js/dashboards/bigdata.js

@@ -23,121 +23,9 @@ class BigData {
     }
     async updateData(filterDate) {
         try {
-            console.log("Filtering data for date:", filterDate);
             this.resumeBigData = await this.getBigDataResume(filterDate);
-            // this.totalTargetPAD = await this.getDataSettings("TARGET_PAD");
-            // this.resultDataTotal = await this.getDataTotalPotensi(year);
-            // this.dataVerification = await this.getDataVerfication(year);
-            // this.dataNonVerification = await this.getDataNonVerfication(year);
-            // this.dataBusiness = await this.getDataBusiness(year);
-            // this.dataNonBusiness = await this.getDataNonBusiness(year);
-            // this.dataTataRuang = await this.getDataSettings("TATA_RUANG");
-            // this.dataSumRealisasiTerbit = await this.getDataSettings(
-            //     "REALISASI_TERBIT_PBG_SUM"
-            // );
-            // this.dataCountRealisasiTerbit = await this.getDataSettings(
-            //     "REALISASI_TERBIT_PBG_COUNT"
-            // );
-            // this.dataSumMenungguKlikDPMPTSP = await this.getDataSettings(
-            //     "MENUNGGU_KLIK_DPMPTSP_SUM"
-            // );
-            // this.dataCountMenungguKlikDPMPTSP = await this.getDataSettings(
-            //     "MENUNGGU_KLIK_DPMPTSP_COUNT"
-            // );
-            // this.dataSumProsesDinasTeknis = await this.getDataSettings(
-            //     "PROSES_DINAS_TEKNIS_SUM"
-            // );
-            // this.dataCountProsesDinasTeknis = await this.getDataSettings(
-            //     "PROSES_DINAS_TEKNIS_COUNT"
-            // );
 
-            // // total potensi
+            this.initChartTargetPAD(filterDate);
-            // this.bigTargetPAD = new Big(this.totalTargetPAD ?? 0);
-            // this.bigTotalPotensi = new Big(this.resultDataTotal.totalData ?? 0);
-
-            // this.resultPercentage = 0;
-            // if (this.bigTotalPotensi > 0 && this.bigTargetPAD > 0) {
-            //     this.resultPercentage = this.bigTotalPotensi
-            //         .div(this.bigTargetPAD)
-            //         .times(100)
-            //         .toFixed(2);
-            //     if (this.resultPercentage > 100) {
-            //         this.resultPercentage = 100;
-            //     }
-            // }
-
-            // // tata ruang
-            // this.bigTotalTataRuang = new Big(this.dataTataRuang);
-            // this.percentageResultTataRuang =
-            //     this.bigTotalTataRuang <= 0 || this.bigTotalPotensi <= 0
-            //         ? 0
-            //         : this.bigTotalTataRuang
-            //               .div(this.bigTotalPotensi)
-            //               .times(100)
-            //               .toFixed(2);
-
-            // // kekurangan potensi
-            // this.totalKekuranganPotensi = new Big(
-            //     this.bigTargetPAD - this.bigTotalPotensi
-            // );
-
-            // this.percentageKekuranganPotensi =
-            //     this.totalKekuranganPotensi <= 0 || this.bigTargetPAD <= 0
-            //         ? 0
-            //         : this.totalKekuranganPotensi
-            //               .div(this.bigTargetPAD)
-            //               .times(100)
-            //               .toFixed(2);
-
-            // // non-verification documents
-            // this.bigTotalNonVerification = new Big(
-            //     this.dataNonVerification.total
-            // );
-            // this.percentageResultNonVerification =
-            //     this.bigTotalNonVerification <= 0 || this.bigTotalPotensi <= 0
-            //         ? 0
-            //         : this.bigTotalNonVerification
-            //               .div(this.bigTotalPotensi)
-            //               .times(100)
-            //               .toFixed(2);
-
-            // // verification documents
-            // this.bigTotalVerification = new Big(this.dataVerification.total);
-            // this.percetageResultVerification =
-            //     this.bigTotalVerification <= 0 || this.bigTotalPotensi <= 0
-            //         ? 0
-            //         : this.bigTotalVerification
-            //               .div(this.bigTargetPAD)
-            //               .times(100)
-            //               .toFixed(2);
-
-            // // business documents
-            // this.bigTotalBusiness = new Big(this.dataBusiness.total);
-            // this.percentageResultBusiness =
-            //     this.bigTotalNonVerification <= 0 || this.bigTotalBusiness <= 0
-            //         ? 0
-            //         : this.bigTotalBusiness
-            //               .div(this.bigTotalNonVerification)
-            //               .times(100)
-            //               .toFixed(2);
-
-            // // non-business documents
-            // this.bigTotalNonBusiness = new Big(this.dataNonBusiness.total);
-            // this.percentageResultNonBusiness =
-            //     this.bigTotalNonBusiness <= 0 ||
-            //     this.bigTotalNonVerification <= 0
-            //         ? 0
-            //         : this.bigTotalNonBusiness
-            //               .div(this.bigTotalNonVerification)
-            //               .times(100)
-            //               .toFixed(2);
-
-            // if (!this.bigTargetPAD) {
-            //     console.error("Failed to load chart data");
-            //     return;
-            // }
-
-            this.initChartTargetPAD();
             this.initChartUsaha();
             this.initChartNonUsaha();
             this.initChartTotalPotensi();
@@ -180,190 +68,17 @@ class BigData {
             return null;
         }
     }
-    async getDataTotalPotensi(year) {
-        try {
-            const response = await fetch(
-                `${GlobalConfig.apiHost}/api/all-task-documents?year=${year}`,
-                {
-                    credentials: "include",
-                    headers: {
-                        Authorization: `Bearer ${
-                            document.querySelector("meta[name='api-token']")
-                                .content
-                        }`,
-                        "Content-Type": "application/json",
-                    },
-                }
-            );
 
-            if (!response.ok) {
+    initChartTargetPAD(filterDate) {
-                console.error("Network response was not ok", response);
+        const year =
-            }
+            filterDate === "latest"
-
+                ? new Date().getFullYear()
-            const data = await response.json();
+                : new Date(filterDate).getFullYear();
-            return {
+        document
-                countData: data.data.count,
+            .querySelectorAll(".document-title.chart-target-pad")
-                totalData: data.data.total,
+            .forEach((element) => {
-            };
+                element.innerText = `Target PAD ${year}`;
-        } catch (error) {
+            });
-            console.error("Error fetching chart data:", error);
-            return null;
-        }
-    }
-
-    async getDataVerfication(year) {
-        try {
-            const response = await fetch(
-                `${GlobalConfig.apiHost}/api/verification-documents?year=${year}`,
-                {
-                    credentials: "include",
-                    headers: {
-                        Authorization: `Bearer ${
-                            document.querySelector("meta[name='api-token']")
-                                .content
-                        }`,
-                        "Content-Type": "application/json",
-                    },
-                }
-            );
-
-            if (!response.ok) {
-                console.error("Network response was not ok", response);
-            }
-
-            const data = await response.json();
-            return {
-                count: data.data.count,
-                total: data.data.total,
-            };
-        } catch (error) {
-            console.error("Error fetching chart data:", error);
-            return 0;
-        }
-    }
-
-    async getDataNonVerfication(year) {
-        try {
-            const response = await fetch(
-                `${GlobalConfig.apiHost}/api/non-verification-documents?year=${year}`,
-                {
-                    credentials: "include",
-                    headers: {
-                        Authorization: `Bearer ${
-                            document.querySelector("meta[name='api-token']")
-                                .content
-                        }`,
-                        "Content-Type": "application/json",
-                    },
-                }
-            );
-
-            if (!response.ok) {
-                console.error("Network response was not ok", response);
-            }
-
-            const data = await response.json();
-            return {
-                count: data.data.count,
-                total: data.data.total,
-            };
-        } catch (error) {
-            console.error("Error fetching chart data:", error);
-            return 0;
-        }
-    }
-
-    async getDataBusiness(year) {
-        try {
-            const response = await fetch(
-                `${GlobalConfig.apiHost}/api/business-documents?year=${year}`,
-                {
-                    credentials: "include",
-                    headers: {
-                        Authorization: `Bearer ${
-                            document.querySelector("meta[name='api-token']")
-                                .content
-                        }`,
-                        "Content-Type": "application/json",
-                    },
-                }
-            );
-
-            if (!response.ok) {
-                console.error("Network response was not ok", response);
-            }
-
-            const data = await response.json();
-            return {
-                count: data.data.count,
-                total: data.data.total,
-            };
-        } catch (error) {
-            console.error("Error fetching chart data:", error);
-            return 0;
-        }
-    }
-
-    async getDataNonBusiness(year) {
-        try {
-            const response = await fetch(
-                `${GlobalConfig.apiHost}/api/non-business-documents?year=${year}`,
-                {
-                    credentials: "include",
-                    headers: {
-                        Authorization: `Bearer ${
-                            document.querySelector("meta[name='api-token']")
-                                .content
-                        }`,
-                        "Content-Type": "application/json",
-                    },
-                }
-            );
-
-            if (!response.ok) {
-                console.error("Network response was not ok", response);
-            }
-
-            const data = await response.json();
-            return {
-                count: data.data.count,
-                total: data.data.total,
-            };
-        } catch (error) {
-            console.error("Error fetching chart data:", error);
-            return 0;
-        }
-    }
-
-    async getDataSettings(string_key) {
-        try {
-            const response = await fetch(
-                `${GlobalConfig.apiHost}/api/api-data-settings?search=${string_key}`,
-                {
-                    credentials: "include",
-                    headers: {
-                        Authorization: `Bearer ${
-                            document.querySelector("meta[name='api-token']")
-                                .content
-                        }`,
-                        "Content-Type": "application/json",
-                    },
-                }
-            );
-
-            if (!response.ok) {
-                console.error("Network response was not ok", response);
-            }
-
-            const data = await response.json();
-            return data.data[0].value;
-        } catch (error) {
-            console.error("Error fetching chart data:", error);
-            return 0;
-        }
-    }
-
-    initChartTargetPAD() {
         document
             .querySelectorAll(".document-count.chart-target-pad")
             .forEach((element) => {
@@ -373,7 +88,6 @@ class BigData {
             .querySelectorAll(".document-total.chart-target-pad")
             .forEach((element) => {
                 element.innerText = `Rp.${addThousandSeparators(
-                    // this.bigTargetPAD.toString()
                     this.resumeBigData.target_pad.sum.toString()
                 )}`;
             });
@@ -589,20 +303,18 @@ class BigData {
         document
             .querySelectorAll(".document-count.chart-potensi-tata-ruang")
             .forEach((element) => {
-                element.innerText = "";
+                element.innerText = `${this.resumeBigData.tata_ruang.count}`;
             });
         document
             .querySelectorAll(".document-total.chart-potensi-tata-ruang")
             .forEach((element) => {
                 element.innerText = `Rp.${addThousandSeparators(
-                    // this.bigTotalTataRuang.toString()
                     this.resumeBigData.tata_ruang.sum.toString()
                 )}`;
             });
         document
             .querySelectorAll(".small-percentage.chart-potensi-tata-ruang")
             .forEach((element) => {
-                // element.innerText = `${this.percentageResultTataRuang}%`;
                 element.innerText = `${this.resumeBigData.tata_ruang.percentage}%`;
             });
     }

resources/js/dashboards/lack-of-potential.js

@@ -16,6 +16,19 @@ class LackOfPotential {
         this.pdamCount = this.allCountData.total_pdam ?? 0;
         this.tataRuangCount = this.allCountData.total_tata_ruang ?? 0;
 
+        let dataReportTourism = this.allCountData.data_report;
+
+        this.totalVilla = dataReportTourism
+            .filter((item) => item.kbli_title.toLowerCase() === "vila")
+            .reduce((sum, item) => sum + item.total_records, 0);
+        this.totalRestoran = dataReportTourism
+            .filter((item) => item.kbli_title.toLowerCase() === "restoran")
+            .reduce((sum, item) => sum + item.total_records, 0);
+        this.totalPariwisata = dataReportTourism.reduce(
+            (sum, item) => sum + item.total_records,
+            0
+        );
+
         this.bigTargetPAD = new Big(this.totalTargetPAD ?? 0);
         this.bigTotalPotensi = new Big(this.totalPotensi.total ?? 0);
         this.bigTotalLackPotential = this.bigTargetPAD.minus(
@@ -140,6 +153,15 @@ class LackOfPotential {
         document.getElementById("pdam-count").innerText = this.pdamCount;
         document.getElementById("pbb-bangunan-count").innerText =
             this.tataRuangCount;
+        document.getElementById("tata-ruang-count").innerText =
+            this.tataRuangCount;
+        document.getElementById("tata-ruang-usaha-count").innerText =
+            this.tataRuangCount;
+        document.getElementById("restoran-count").innerText =
+            this.totalRestoran;
+        document.getElementById("villa-count").innerText = this.totalVilla;
+        document.getElementById("pariwisata-count").innerText =
+            this.totalPariwisata;
     }
 }
 document.addEventListener("DOMContentLoaded", async function (e) {

resources/js/maps/maps-kml.js

@@ -0,0 +1,79 @@
+import L from "leaflet";
+import "leaflet/dist/leaflet.css";
+
+document.addEventListener("DOMContentLoaded", function () {
+    var map = L.map("map").setView([-6.9175, 107.6191], 10); // Bandung
+
+    L.tileLayer("https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png", {
+        attribution: "© OpenStreetMap contributors",
+    }).addTo(map);
+
+    // Dapatkan elemen loading
+    const loadingDiv = document.getElementById("loading");
+    loadingDiv.style.display = "flex"; // Tampilkan loading
+
+    fetch("/storage/maps/rencana-polaruang.geojson")
+        .then((res) => res.json())
+        .then((geojson) => {
+            let colorMapping = {
+                BJ: "rgb(235, 30, 30)",
+                BA: "rgb(151, 219, 242)",
+                CA: "rgb(70, 70, 165)",
+                "P-2": "rgb(230, 255, 75)",
+                HL: "rgb(50, 95, 40)",
+                HPT: "rgb(75, 155, 55)",
+                HP: "rgb(125, 180, 55)",
+                W: "rgb(255, 165, 255)",
+                PTL: "rgb(0, 255, 205)",
+                "IK-2": "rgb(130, 185, 210)",
+                "P-3": "rgb(175, 175, 55)",
+                PS: "rgb(5, 215, 215)",
+                PD: "rgb(235, 155, 60)",
+                PK: "rgb(245, 155, 30)",
+                HK: "rgb(155, 0, 255)",
+                KPI: "rgb(105, 0, 0)",
+                MBT: "rgb(95, 115, 145)",
+                "P-4": "rgb(185, 235, 185)",
+                TB: "rgb(70, 150, 255)",
+                "P-1": "rgb(200, 245, 70)",
+                TR: "rgb(215, 55, 0)",
+                THR: "rgb(185, 165, 255)",
+                TWA: "rgb(210, 190, 255)",
+            };
+            var geoLayer = L.geoJSON(geojson, {
+                style: function (feature) {
+                    let htmlString = feature.properties.description.toString();
+
+                    let match = htmlString.match(
+                        /<td>Kode Kawasan<\/td>\s*<td>(.*?)<\/td>/
+                    );
+
+                    console.log("Kode Kawasan ", match[1]);
+
+                    let color_code = match[1];
+
+                    return {
+                        color: colorMapping[color_code], 
+                        fillColor: colorMapping[color_code] || "#cccccc", 
+                        fillOpacity: 0.6,
+                        weight: 1.5,
+                    };
+                },
+                onEachFeature: function (feature, layer) {
+                    if (feature.properties && feature.properties.name) {
+                        layer.bindPopup(feature.properties.name);
+                    }
+                },
+            }).addTo(map);
+
+            map.fitBounds(geoLayer.getBounds());
+
+            // Sembunyikan loading setelah selesai render
+            loadingDiv.style.display = "none";
+        })
+        .catch((error) => {
+            console.error("Error loading GeoJSON:", error);
+            loadingDiv.innerHTML =
+                "<div class='loading-text' style='background: red;'>Failed to load data!</div>";
+        });
+});

resources/js/master/users/users.js

@@ -31,7 +31,7 @@ class UsersTable {
                 },
             ],
             pagination: {
-                limit: 15,
+                limit: 50,
                 server: {
                     url: (prev, page) =>
                         `${prev}${prev.includes("?") ? "&" : "?"}page=${

resources/js/menus/index.js

@@ -83,7 +83,7 @@ class Menus {
                 },
             ],
             pagination: {
-                limit: 15,
+                limit: 50,
                 server: {
                     url: (prev, page) =>
                         `${prev}${prev.includes("?") ? "&" : "?"}page=${

resources/js/roles/index.js

@@ -52,7 +52,7 @@ class Roles {
                 },
             ],
             pagination: {
-                limit: 15,
+                limit: 50,
                 server: {
                     url: (prev, page) =>
                         `${prev}${prev.includes("?") ? "&" : "?"}page=${

resources/js/settings/syncronize/syncronize.js

@@ -4,13 +4,21 @@ import "gridjs/dist/gridjs.umd.js";
 import GlobalConfig from "../../global-config.js";
 
 class SyncronizeTask {
+    constructor() {
+        this.toastElement = document.getElementById("toastNotification");
+        this.toastMessage = document.getElementById("toast-message");
+        this.toast = new bootstrap.Toast(this.toastElement);
+        this.table = null;
+    }
     init() {
         this.initTableImportDatasources();
         this.handleSubmitSync();
-        this.handleSubmitSnycGoogleSheet();
     }
     initTableImportDatasources() {
-        new Grid({
+        let tableContainer = document.getElementById(
+            "table-import-datasources"
+        );
+        this.table = new gridjs.Grid({
             columns: ["ID", "Message", "Response", "Status", "Created"],
             search: {
                 server: {
@@ -18,7 +26,7 @@ class SyncronizeTask {
                 },
             },
             pagination: {
-                limit: 15,
+                limit: 50,
                 server: {
                     url: (prev, page) =>
                         `${prev}${prev.includes("?") ? "&" : "?"}page=${
@@ -45,20 +53,24 @@ class SyncronizeTask {
                     ]),
                 total: (data) => data.meta.total,
             },
-        }).render(document.getElementById("table-import-datasources"));
+        }).render(tableContainer);
     }
     handleSubmitSync() {
         const button = document.getElementById("btn-sync-submit");
+        const spinner = document.getElementById("spinner");
+        const apiToken = document
+            .querySelector('meta[name="api-token"]')
+            .getAttribute("content");
+
+        // Show the spinner while checking
+        spinner.classList.remove("d-none");
 
-        // Check if the button should be enabled or disabled based on the status
         fetch(
             `${GlobalConfig.apiHost}/api/import-datasource/check-datasource`,
             {
                 method: "GET",
                 headers: {
-                    Authorization: `Bearer ${document
+                    Authorization: `Bearer ${apiToken}`,
-                        .querySelector('meta[name="api-token"]')
-                        .getAttribute("content")}`,
                     "Content-Type": "application/json",
                 },
             }
@@ -70,49 +82,21 @@ class SyncronizeTask {
                 return response.json();
             })
             .then((data) => {
-                console.log("data check button sync", data.can_execute);
                 button.disabled = !data.can_execute;
 
-                // If the button is enabled, add click event to trigger sync
+                if (!data.can_execute) {
-                if (!button.disabled) {
+                    // Keep spinner visible if cannot execute
-                    button.addEventListener("click", function (e) {
+                    spinner.classList.remove("d-none");
-                        button.disabled = true; // Disable button to prevent multiple clicks
+                } else {
-                        button.textContent = "Syncing..."; // Change button text to show syncing
+                    // Hide spinner when execution is allowed
+                    spinner.classList.add("d-none");
 
-                        // Trigger the scraping API call
+                    // Remove previous event listener before adding a new one
-                        fetch(`${GlobalConfig.apiHost}/api/scraping`, {
+                    button.removeEventListener("click", this.handleSyncClick);
-                            method: "GET",
+                    button.addEventListener(
-                            headers: {
+                        "click",
-                                Authorization: `Bearer ${document
+                        this.handleSyncClick.bind(this)
-                                    .querySelector('meta[name="api-token"]')
+                    );
-                                    .getAttribute("content")}`,
-                                "Content-Type": "application/json",
-                            },
-                        })
-                            .then((response) => {
-                                if (!response.ok) {
-                                    throw new Error(
-                                        "Network response was not ok"
-                                    );
-                                }
-                                return response.json();
-                            })
-                            .then((data) => {
-                                console.log("data sync button", data);
-                                alert("Synchronization executed successfully");
-                                window.location.reload();
-                            })
-                            .catch((err) => {
-                                console.error("Fetch error:", err);
-                                alert(
-                                    "An error occurred during synchronization"
-                                );
-                            })
-                            .finally(() => {
-                                button.disabled = false; // Re-enable the button after the request is complete
-                                button.textContent = "Sync Data"; // Reset button text
-                            });
-                    });
                 }
             })
             .catch((err) => {
@@ -120,42 +104,53 @@ class SyncronizeTask {
                 alert("An error occurred while checking the datasource");
             });
     }
-    handleSubmitSnycGoogleSheet() {
-        const button = document.getElementById("btn-sync-submit-google-sheet");
-        button.addEventListener("click", function (e) {
-            button.disabled = true; // Disable button to prevent multiple clicks
-            button.textContent = "Syncing..."; // Change button text to show syncing
 
-            // Trigger the scraping API call
+    handleSyncClick() {
-            fetch(`${GlobalConfig.apiHost}/api/sync-pbg-task-google-sheet`, {
+        const button = document.getElementById("btn-sync-submit");
-                method: "GET",
+        const spinner = document.getElementById("spinner");
-                headers: {
+        const apiToken = document
-                    Authorization: `Bearer ${document
+            .querySelector('meta[name="api-token"]')
-                        .querySelector('meta[name="api-token"]')
+            .getAttribute("content");
-                        .getAttribute("content")}`,
+
-                    "Content-Type": "application/json",
+        button.disabled = true; // Prevent multiple clicks
-                },
+        spinner.classList.remove("d-none"); // Show spinner during sync
+
+        fetch(`${GlobalConfig.apiHost}/api/scraping`, {
+            method: "GET",
+            headers: {
+                Authorization: `Bearer ${apiToken}`,
+                "Content-Type": "application/json",
+            },
+        })
+            .then(async (response) => {
+                if (!response.ok) {
+                    throw new Error(`HTTP error! Status: ${response.status}`);
+                }
+
+                let data;
+                try {
+                    data = await response.json();
+                } catch (jsonError) {
+                    throw new Error("Failed to parse JSON response");
+                }
+
+                return data;
             })
-                .then((response) => {
+            .then((data) => {
-                    if (!response.ok) {
+                this.toastMessage.innerText =
-                        throw new Error("Network response was not ok");
+                    data.data.message || "Synchronize successfully!";
-                    }
+                this.toast.show();
-                    return response.json();
+
-                })
+                // Update the table if it exists
-                .then((data) => {
+                if (this.table) {
-                    console.log("data sync button", data);
+                    this.table.updateConfig({}).forceRender();
-                    alert("Synchronization executed successfully");
+                }
-                    window.location.reload();
+            })
-                })
+            .catch((err) => {
-                .catch((err) => {
+                console.error("Fetch error:", err);
-                    console.error("Fetch error:", err);
+                alert("An error occurred during synchronization" + err.message);
-                    alert("An error occurred during synchronization");
+                button.disabled = false;
-                })
+            });
-                .finally(() => {
-                    button.disabled = false; // Re-enable the button after the request is complete
-                    button.textContent = "Sync Google Sheet"; // Reset button text
-                });
-        });
     }
 }
 document.addEventListener("DOMContentLoaded", function (e) {

resources/scss/components/_circle.scss

@@ -21,8 +21,8 @@
     // overflow: hidden;
 
     .circle-content {
-        width: 180px; /* Ukuran lingkaran dalam */
+        min-width: 180px; /* Ukuran lingkaran dalam */
-        height: 180px;
+        min-height: 180px;
         background-color: var(--circle-color); /* Warna lingkaran dalam */
         border-radius: 50%;
         display: flex;
@@ -57,17 +57,20 @@
         padding: 0 7px;
         border-radius: 10px;
         margin: 0;
+        max-width: 100%;
     }
 
     .circle-content .document-count {
         font-size: 24px;
         font-weight: bold;
         margin: 0;
+        max-width: 100%;
     }
 
     .circle-content .document-type {
         font-size: 14px;
         margin: 0;
+        max-width: 100%;
     }
 
     .small-circle-container {

resources/views/bigdata-resumes/index.blade.php

@@ -0,0 +1,27 @@
+@extends('layouts.vertical', ['subtitle' => 'Laporan Pimpinan'])
+
+@section('css')
+@vite(['node_modules/gridjs/dist/theme/mermaid.min.css'])
+@endsection
+
+@section('content')
+
+@include('layouts.partials/page-title', ['title' => 'Laporan', 'subtitle' => 'Laporan Pimpinan'])
+
+<x-toast-notification />
+
+<div class="row">
+	<div class="col-12">
+		<div class="card w-100">
+			<div class="card-body">
+				<div id="table-bigdata-resumes"></div>
+			</div>
+		</div>
+	</div>
+</div>
+
+@endsection
+
+@section('scripts')
+@vite(['resources/js/bigdata-resumes/index.js'])
+@endsection

resources/views/business-industries/create.blade.php

@@ -64,7 +64,10 @@
                     <!-- end dropzon-preview -->
                 </div>
                 <div class="d-flex justify-content-end">
-                    <button id="submit-upload" class="btn btn-primary">Upload Files</button>
+                    <button type="button" class="btn btn-primary" id="btnUploadBusinessIndustry">
+                        <span id="spinner" class="spinner-border spinner-border-sm me-1 d-none" role="status" aria-hidden="true"></span>
+                        Upload
+                    </button>
                 </div>
             </div> <!-- end card body -->
         </div> <!-- end card -->

resources/views/business-industries/index.blade.php

@@ -9,7 +9,6 @@
 @include('layouts.partials/page-title', ['title' => 'Data', 'subtitle' => 'Business Industries'])
 
 <x-toast-notification />
-<x-modal-confirmation buttonText="Delete" confirmationMessage="Are you sure you want to delete this?" />
 
 <div class="row">
 	<div class="col-12">

resources/views/customers/upload.blade.php

@@ -1,8 +1,8 @@
-@extends('layouts.vertical', ['subtitle' => 'Data'])
+@extends('layouts.vertical', ['subtitle' => 'PDAM'])
 
 @section('content')
 
-@include('layouts.partials/page-title', ['title' => 'Data', 'subtitle' => 'Tata Ruang'])
+@include('layouts.partials/page-title', ['title' => 'Data', 'subtitle' => 'PDAM'])
 
 <x-toast-notification />
 <div class="row">

resources/views/dashboards/bigdata.blade.php

@@ -9,7 +9,7 @@
 @include('layouts.partials/page-title', ['title' => 'Dashboards', 'subtitle' => 'Dashboard Pimpinan'])
 
 <div id="dashboard-fixed-wrapper" class="row">
-    <div class="col-12">
+    <!-- <div class="col-12">
         <h2 class="mt-3 ms-2 text-danger">
             <span class="float-end fs-6 me-3 text-black d-block d-sm-inline text-end">Terakhir di update - {{$latest_created}}</span>
             ANALISA BIG DATA PROSES PBG <br> 
@@ -24,6 +24,18 @@
                 <input type="text" class="form-control" style="max-width: 125px;" id="datepicker-dashboard-bigdata" placeholder="Filter Date" />
             </div>
         </div>
+    </div> -->
+    <div class="col-12">
+        <div class="d-flex justify-content-between align-items-center mt-3 ms-2">
+            <h2 class="text-danger m-0">
+                ANALISA BIG DATA PROSES PBG <br> 
+                MELALUI APLIKASI SIBEDAS PBG
+            </h2>
+            <div class="text-black text-end d-flex flex-column align-items-end me-3">
+                <span class="fs-5">Terakhir di update - {{$latest_created}}</span>
+                <input type="text" class="form-control mt-2" style="max-width: 125px;" id="datepicker-dashboard-bigdata" placeholder="Filter Date" />
+            </div>
+        </div>
     </div>
     <div id="dashboard-fixed-container" class="row" style="width:1110px;height:770px;position:relative;margin:auto;">
         @component('components.circle', [
@@ -37,7 +49,7 @@
         @endcomponent
 
         @component('components.circle', [
-            'document_title' => 'Target PAD 2024',
+            'document_title' => 'Target PAD',
             'document_color' => '#204f6b',
             'document_type' => '',
             'document_id' => 'chart-target-pad',

resources/views/dashboards/lack_of_potential.blade.php

@@ -9,23 +9,19 @@
 
 <div class="lack-of-potential-wrapper">
     <div class="row" id="lack-of-potential-wrapper">
-        <div class="col-12">
+        <div class="d-flex justify-content-between align-items-center mt-3 ms-2">
-            <h3 class="mt-3 ms-2 text-danger">
+            <h2 class="text-danger m-0">
                 ANALISA BIG DATA MELALUI APLIKASI SIBEDAS PBG
-            </h3>
+            </h2>
+            <div class="text-black text-end d-flex flex-column align-items-end me-3">
+                <input type="text" class="form-control mt-2" style="max-width: 125px;" id="datepicker-lack-of-potential" placeholder="Filter Date" />
+            </div>
         </div>
     </div>
     <div class="wrapper">
-        <div class="row d-flex justify-content-end">
-            <div class="col-12 col-sm-6 col-md-3">
-                <div class="d-flex flex-sm-nowrap flex-wrap justify-content-end">
-                    <input type="text" class="form-control me-3" style="max-width: 125px;" id="datepicker-lack-of-potential" placeholder="Filter Date" />
-                </div>
-            </div>
-        </div>
         <div id="lack-of-potential-fixed-container" class="" style="width:1400px;height:770px;position:relative;margin:auto;z-index:1;">
             <div style="position: absolute; top: 200px; left: 50px;">
-                <x-custom-circle title="Restoran" size="small" style="background-color: #0e4753;" />
+                <x-custom-circle title="Restoran" size="small" style="background-color: #0e4753;" visible_data="true" data_id="restoran-count" data_count="0" />
                 <div class="square dia-top-left-bottom-right" style="top:30px;left:50px;width:150px;height:120px;"></div>
                 <x-custom-circle title="PBB Bangunan" visible_data="true" data_id="pbb-bangunan-count" data_count="0" size="small" style="background-color: #0e4753;" />
                 <div class="square" style="width:150px;height:2px;background-color:black;left:50px;top:150px;"></div>
@@ -56,11 +52,11 @@
                 <div class="square dia-top-right-bottom-left" style="top:-110px;left:90px;width:150px;height:170px;"></div>
                 <div class="square dia-top-left-bottom-right" style="top:-110px;left:230px;width:150px;height:170px;"></div>
                 <div class="square dia-top-left-bottom-right" style="top:-110px;left:260px;width:200px;height:180px;"></div>
-                <x-custom-circle title="Villa" size="small" style="float:left;background-color: #234f6c;" />
+                <x-custom-circle title="Villa" size="small" style="float:left;background-color: #234f6c;" visible_data="true" data_id="villa-count" data_count="0" />
                 <x-custom-circle title="Pabrik" size="small" style="float:left;background-color: #234f6c;" />
                 <x-custom-circle title="Jalan Protocol" size="small" style="float:left;background-color: #234f6c;" />
                 <x-custom-circle title="Ruko" size="small" style="float:left;background-color: #234f6c;" />
-                <x-custom-circle title="Pariwisata" size="small" style="float:left;background-color: #234f6c; margin-right: 20px;" />
+                <x-custom-circle title="Pariwisata" size="small" style="float:left;background-color: #234f6c; margin-right: 20px;" visible_data="true" data_id="pariwisata-count" data_count="0" />
                 <div class="square" style="width:150px;height:2px;background-color:black;left:350px;top:50px;"></div>
                 <x-custom-circle title="DISBUDPAR" size="small" style="background-color: #3a968b;" />
             </div>
@@ -78,23 +74,20 @@
                     'visible_small_circle' => false,
                     'style' => 'margin-left:180px;top:-20px;'
                     ])
-                    @endcomponent
+                @endcomponent
-                    
+                <x-custom-circle title="Tata Ruang" size="large" style="background-color: #da6635;float:left;margin-left:250px;" visible_data="true" data_id="tata-ruang-count" data_count="0" />
-                    <x-custom-circle title="Tata Ruang" size="large" style="background-color: #da6635;float:left;margin-left:250px;" />
+            </div>
-                    
-                </div>
                 
-                <div style="position: absolute; top: 310px; left: 1150px;">
+            <div style="position: absolute; top: 310px; left: 1150px;">
-                    <div class="square dia-top-left-bottom-right" style="top:90px;left:-100px;width:100px;height:100px;"></div>
+                <div class="square dia-top-left-bottom-right" style="top:90px;left:-100px;width:100px;height:100px;"></div>
-                    <div class="square dia-top-right-bottom-left" style="top:-110px;left:-100px;width:100px;height:100px;"></div>
+                <div class="square dia-top-right-bottom-left" style="top:-110px;left:-100px;width:100px;height:100px;"></div>
-                    <x-custom-circle title="Peta" visible_data_type="true" data_type="1:5000" size="small" style="background-color: #224f6d;float:left;" />
+                <x-custom-circle title="Peta" visible_data_type="true" data_type="1:5000" size="small" style="background-color: #224f6d;float:left;" />
-                    <x-custom-circle title="Tapak Bangunan" size="small" style="background-color: #2390af;float:left;margin-left:20px;" />
+                <x-custom-circle title="Tapak Bangunan" size="small" style="background-color: #2390af;float:left;margin-left:20px;" />
-                    
+            </div>
-                </div>
                 
-                <x-custom-circle title="BPN" size="small" style="background-color: #2390af;position:absolute;left:1270px;top:440px;" />
+            <x-custom-circle title="BPN" size="small" style="background-color: #2390af;position:absolute;left:1270px;top:440px;" />
                 
-                <div style="position: absolute; top: 470px; left: 430px;">
+            <div style="position: absolute; top: 470px; left: 430px;">
                 <div class="square dia-top-right-bottom-left" style="top:-80px;left:20px;width:150px;height:120px;"></div>
                 <div class="square dia-top-right-bottom-left" style="top:-50px;left:100px;width:100px;height:100px;"></div>
                 <div class="square dia-top-left-bottom-right" style="top:-50px;left:180px;width:100px;height:100px;"></div>
@@ -109,7 +102,7 @@
 
             <div  style="position: absolute; top: 50px; left: 1100px;">
                 <x-custom-circle title="Non Usaha" size="large" style="background-color: #3a968b;margin-top:20px;" />
-                <x-custom-circle title="USAHA" size="large" style="background-color: #627c8b;margin-top:260px;" />
+                <x-custom-circle title="USAHA" size="large" style="background-color: #627c8b;margin-top:260px;" visible_data="true" data_id="tata-ruang-usaha-count" data_count="0" />
             </div>
         </div>
     </div>

resources/views/layouts/vertical.blade.php

@@ -3,32 +3,57 @@
 
 <style>
     /* .floating-icon {
-        position: fixed;
-        right: 30px;
-        bottom: 70px;
-        background: white;
-        padding: 10px;
-        border-radius: 50%;
-        box-shadow: 0 4px 6px rgba(0, 0, 0, 0.1);
-        cursor: pointer;
-        z-index: 1000;
-    } */
-    .floating-icon {
         position: fixed;
         right: 40px;
         bottom: 100px;
-        width: 70px;  /* Sesuaikan ukuran */
+        width: 70px;  
-        height: 70px; /* Sesuaikan ukuran */
+        height: 70px; 
         background: white;
         border-radius: 50%;
         box-shadow: 0 4px 6px rgba(0, 0, 0, 0.1);
         cursor: pointer;
         z-index: 1000;
-        background-image: url('/images/iconchatbot.jpeg'); /* Path ke gambar */
+        background-image: url('/images/iconchatbot.jpeg');
-        background-size: cover;  /* Agar gambar menyesuaikan */
+        background-size: cover;  
-        background-position: center; /* Memusatkan gambar */
+        background-position: center;
+    } */
+
+
+    .floating-icon {
+        position: fixed;
+        right: 20px;
+        bottom: 20px; 
+        width: 60px;  
+        height: 60px;
+        background: white;
+        border-radius: 50%;
+        box-shadow: 0 4px 8px rgba(0, 0, 0, 0.2); 
+        cursor: pointer;
+        z-index: 1000;
+        background-image: url('/images/iconchatbot.jpeg'); 
+        background-size: contain; 
+        background-repeat: no-repeat;
+        background-position: center;
+        transition: transform 0.3s ease-in-out, box-shadow 0.3s ease-in-out;
     }
 
+    .floating-icon:hover {
+        transform: scale(1.1);
+        box-shadow: 0 6px 12px rgba(0, 0, 0, 0.3);
+    }
+
+    @keyframes bounce {
+        0%, 100% {
+            transform: translateY(0);
+        }
+        50% {
+            transform: translateY(-10px);
+        }
+    }
+
+    .floating-icon.animate {
+        animation: bounce 1s infinite;
+    }
 </style>
 
 <head>

resources/views/maps/google-api.blade.php

@@ -1,45 +1,41 @@
 @extends('layouts.vertical', ['subtitle' => 'Google Maps'])
+
 @section('css')
-<link rel="stylesheet" href="https://unpkg.com/leaflet@1.9.4/dist/leaflet.css" />
+<style>
+    .loading-overlay {
+    position: fixed;
+    top: 0;
+    left: 0;
+    width: 100%;
+    height: 100%;
+    background: rgba(0, 0, 0, 0.5); /* Latar belakang gelap transparan */
+    display: flex;
+    justify-content: center;
+    align-items: center;
+    z-index: 1000;
+}
+
+.loading-text {
+    background: white;
+    padding: 10px 20px;
+    border-radius: 5px;
+    font-size: 18px;
+    font-weight: bold;
+}
+</style>
 @endsection
 
 @section('content')
-@include('layouts.partials/page-title', ['title' => 'Maps', 'subtitle' => 'Google Maps'])
+@include('layouts.partials.page-title', ['title' => 'Maps', 'subtitle' => 'Google Maps'])
+<!-- Elemen loading -->
+<div id="loading" class="loading-overlay">
+    <div class="loading-text">Loading data...</div>
+</div>
+
+<!-- Peta -->
 <div id="map" style="width: 100%; height: 90vh;"></div>
 @endsection
 
 @section('scripts')
-<script src="https://unpkg.com/leaflet@1.9.4/dist/leaflet.js"></script>
+@vite(['resources/js/maps/maps-kml.js'])
-<script src="https://unpkg.com/togeojson@0.16.0"></script>
-<script src="https://unpkg.com/leaflet-omnivore@0.3.4/leaflet-omnivore.min.js"></script>
-<script src="https://unpkg.com/leaflet-kml/L.KML.js"></script>
-<script>
-    document.addEventListener("DOMContentLoaded", function () {
-        var map = L.map('map').setView([-6.9175, 107.6191], 10); // Jakarta
-
-        // Tambahkan peta dasar dari OpenStreetMap
-        L.tileLayer('https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png', {
-            attribution: '&copy; OpenStreetMap contributors'
-        }).addTo(map);
-
-        // Muat file KMZ
-        omnivore.kml("{{ asset('storage/maps/rencanapolaruang_rtrw_2024_2044__rencana_pola_ruang.kml') }}")
-            .on('ready', function () {
-                try {
-                    var bounds = this.getBounds();
-                    if (bounds.isValid()) {
-                        map.fitBounds(bounds);
-                    } else {
-                        console.warn("Bounds tidak valid, gunakan fallback.");
-                        map.setView([-6.9175, 107.6191], 10); // Default ke Jakarta
-                    }
-                } catch (error) {
-                    console.error("Error setting bounds:", error);
-                    map.setView([-6.1751, 106.8650], 10);
-                }
-            })
-            .addTo(map);
-
-    });
-</script>
 @endsection

resources/views/settings/syncronize/index.blade.php

@@ -7,14 +7,16 @@
 @section('content')
 
 @include('layouts.partials/page-title', ['title' => 'Settings', 'subtitle' => 'Syncronize'])
-
+<x-toast-notification />
 <div class="row">
     <div class="col-12">
         <div class="card w-100">
             <div class="card-body">
                 <div class="d-flex flex-wrap justify-content-end gap-2">
-                    <button type="button" class="btn btn-success btn-sm d-block d-sm-inline w-auto" id="btn-sync-submit-google-sheet">Sync Google Sheet</button>
+                    <button type="button" class="btn btn-success btn-sm d-block d-sm-inline w-auto" id="btn-sync-submit">
-                    <button type="button" class="btn btn-success btn-sm d-block d-sm-inline w-auto" id="btn-sync-submit">Sync SIMBG</button>
+                        <span id="spinner" class="spinner-border spinner-border-sm me-1 d-none" role="status" aria-hidden="true"></span>    
+                        Sync SIMBG
+                    </button>
                 </div>
                 <div>
                     <div id="table-import-datasources"></div>

routes/api.php

@@ -134,5 +134,8 @@ Route::group(['middleware' => 'auth:sanctum'], function (){
     Route::get('/dashboard-potential-count', [LackOfPotentialController::class, 'count_lack_of_potential'])->name('api.count-dashboard-potential');
 
     // big data resume
-    Route::get('/bigdata-resume', [BigDataResumeController::class, 'index'])->name('api.bigdata-resume');
+    Route::controller(BigDataResumeController::class)->group(function (){
+        Route::get('/bigdata-resume', 'index')->name('api.bigdata-resume');
+        Route::get('/bigdata-report', 'bigdata_report')->name('api.bigdata-report');
+    });
 });

routes/web.php

@@ -1,5 +1,6 @@
 <?php
 
+use App\Http\Controllers\BigdataResumesController;
 use App\Http\Controllers\BusinessOrIndustriesController;
 use App\Http\Controllers\CustomersController;
 use App\Http\Controllers\Dashboards\LackOfPotentialController;
@@ -112,5 +113,9 @@ Route::group(['middleware' => 'auth'], function(){
     Route::group(['prefix' => '/report'], function(){
         // Resource route, kecuali create karena dibuat terpisah
         Route::resource('/tourisms-report', ReportTourismController::class);
+
+        Route::controller(BigdataResumesController::class)->group(function (){
+            Route::get('/bigdata-resumes', 'index')->name('bigdata-resumes');
+        });
     });
 });

vite.config.js

@@ -3,10 +3,6 @@ import laravel from "laravel-vite-plugin";
 import path from "path";
 
 export default defineConfig({
-    build: {
-        outDir: "public/build",
-        manifest: true, // Menghasilkan manifest.json untuk Laravel
-    },
     resolve: {
         alias: {
             "@": path.resolve(__dirname, "resources/js"),
@@ -98,7 +94,12 @@ export default defineConfig({
                 "resources/js/customers/index.js",
                 "resources/js/customers/create.js",
                 "resources/js/customers/edit.js",
-		"resources/js/dashboards/pbg.js"
+                "resources/js/dashboards/pbg.js",
+                // maps
+                "resources/js/maps/maps-kml.js",
+                // laporan pimpinan
+                "resources/js/bigdata-resumes/index.js",
+                "resources/js/chatbot/index.js",
             ],
             refresh: true,
         }),