fix syncronize using worker and add duration syncronize

README.md

@@ -17,10 +17,10 @@ sudo nano /etc/supervisor/conf.d/laravel-worker.conf
 
 [program:laravel-worker]
 process_name=%(program_name)s_%(process_num)02d
-command=php /home/arifal/development/sibedas-pbg-web/artisan queue:work --queue=default --timeout=40000 --tries=1 --sleep=3
+command=php /home/arifal/development/sibedas-pbg-web/artisan queue:work --queue=default --timeout=40000 --tries=1
 autostart=true
 autorestart=true
-numprocs=4
+numprocs=1
 redirect_stderr=true
 stdout_logfile=/home/arifal/development/sibedas-pbg-web/storage/logs/worker.log
 stopasgroup=true
@@ -63,6 +63,12 @@ php artisan storage:link
 php artisan migrate
 ```
 
+-   Running seeder
+
+```
+php artisan db:seed
+```
+
 -   Create view table
 -   excute all sql queries on folder database/view_query
 

app/Console/Commands/ScrapingData.php

@@ -0,0 +1,95 @@
+<?php
+
+namespace App\Console\Commands;
+
+use App\Jobs\ScrapingDataJob;
+use App\Models\ImportDatasource;
+use App\Services\ServiceGoogleSheet;
+use App\Services\ServicePbgTask;
+use App\Services\ServiceTabPbgTask;
+use App\Services\ServiceTokenSIMBG;
+use GuzzleHttp\Client; // Import Guzzle Client
+use Illuminate\Console\Command;
+use Illuminate\Support\Facades\Log;
+use Illuminate\Support\Facades\DB;
+
+class ScrapingData extends Command
+{
+    /**
+     * The name and signature of the console command.
+     *
+     * @var string
+     */
+    protected $signature = 'app:scraping-data';
+
+    /**
+     * The console command description.
+     *
+     * @var string
+     */
+    protected $description = 'Command description';
+    /**
+     * Inject dependencies.
+     */
+    public function __construct(
+    ) {
+        parent::__construct();
+    }
+
+    public function handle()
+    {
+        dispatch(new ScrapingDataJob());
+
+        $this->info("Scraping job dispatched successfully");
+    }
+
+    /**
+     * Execute the console command.
+     */
+    // public function handle()
+    // {
+
+    //     try {
+    //         // Create a record with "processing" status
+    //         $import_datasource = ImportDatasource::create([
+    //             'message' => 'Initiating scraping...',
+    //             'response_body' => null,
+    //             'status' => 'processing',
+    //             'start_time' => now()
+    //         ]);
+
+    //         // Run the service
+    //         $service_google_sheet = new ServiceGoogleSheet();
+    //         $service_google_sheet->run_service();
+
+    //         // Run the ServicePbgTask with injected Guzzle Client
+    //         $this->service_pbg_task->run_service();
+
+    //         // run the service pbg task assignments
+    //         $this->service_tab_pbg_task->run_service();
+
+    //         // Update the record status to "success" after completion
+    //         $import_datasource->update([
+    //             'status' => 'success',
+    //             'message' => 'Scraping completed successfully.',
+    //             'finish_time' => now()
+    //         ]);
+
+    //     } catch (\Exception $e) {
+
+    //         // Log the error for debugging
+    //         Log::error('Scraping failed: ' . $e->getMessage(), ['trace' => $e->getTraceAsString()]);
+
+    //         // Handle errors by updating the status to "failed"
+    //         if (isset($import_datasource)) {
+    //             $import_datasource->update([
+    //                 'status' => 'failed',
+    //                 'response_body' => 'Error: ' . $e->getMessage(),
+    //                 'finish_time' => now()
+    //             ]);
+    //         }
+    //     }
+    // }
+
+
+}

app/Exports/DistrictPaymentRecapExport.php

@@ -0,0 +1,31 @@
+<?php
+
+namespace App\Exports;
+
+use App\Models\PbgTaskGoogleSheet;
+use Illuminate\Support\Facades\DB;
+use Maatwebsite\Excel\Concerns\FromCollection;
+use Maatwebsite\Excel\Concerns\WithHeadings;
+
+class DistrictPaymentRecapExport implements FromCollection, WithHeadings
+{
+    /**
+    * @return \Illuminate\Support\Collection
+    */
+    public function collection()
+    {
+        return PbgTaskGoogleSheet::select(
+                    'kecamatan',
+                    DB::raw('SUM(nilai_retribusi_keseluruhan_simbg) as total')
+                )
+                ->groupBy('kecamatan')->get();
+    }
+
+    public function headings(): array{
+        return [
+            'Kecamatan',
+            'Total'
+        ];
+    }
+    
+}

app/Exports/ReportDirectorExport.php

@@ -0,0 +1,90 @@
+<?php
+
+namespace App\Exports;
+
+use App\Models\BigdataResume;
+use Maatwebsite\Excel\Concerns\FromCollection;
+use Maatwebsite\Excel\Concerns\WithHeadings;
+use Maatwebsite\Excel\Concerns\WithMapping;
+
+class ReportDirectorExport implements FromCollection, WithHeadings, WithMapping
+{
+    /**
+    * @return \Illuminate\Support\Collection
+    */
+    public function collection()
+    {
+        return BigdataResume::select(
+            'potention_count',
+            'potention_sum',
+            'non_verified_count',
+            'non_verified_sum',
+            'verified_count',
+            'verified_sum',
+            'business_count',
+            'business_sum',
+            'non_business_count',
+            'non_business_sum',
+            'spatial_count',
+            'spatial_sum',
+            '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',
+            'year',
+            'created_at'
+        )->orderBy('id', 'desc')->get();
+    }
+    public function headings(): array{
+        return [
+            "Jumlah Potensi" ,
+            "Total Potensi" ,
+            "Jumlah Berkas Belum Terverifikasi" ,
+            "Total Berkas Belum Terverifikasi" ,
+            "Jumlah Berkas Terverifikasi" ,
+            "Total Berkas Terverifikasi" ,
+            "Jumlah Usaha" ,
+            "Total Usaha" ,
+            "Jumlah Non Usaha" ,
+            "Total Non Usaha" ,
+            "Jumlah Tata Ruang" ,
+            "Total Tata Ruang" ,
+            "Jumlah Menunggu Klik DPMPTSP" ,
+            "Total Menunggu Klik DPMPTSP" ,
+            "Jumlah Realisasi Terbit PBG" ,
+            "Total Realisasi Terbit PBG" ,
+            "Jumlah Proses Dinas Teknis" ,
+            "Total Proses Dinas Teknis", 
+            "Tahun",
+            "Created"
+        ];
+    }
+
+    public function map($row): array
+    {
+        return [
+            $row->potention_count,
+            $row->potention_sum,
+            $row->non_verified_count,
+            $row->non_verified_sum,
+            $row->verified_count,
+            $row->verified_sum,
+            $row->business_count,
+            $row->business_sum,
+            $row->non_business_count,
+            $row->non_business_sum,
+            $row->spatial_count,
+            $row->spatial_sum,
+            $row->waiting_click_dpmptsp_count,
+            $row->waiting_click_dpmptsp_sum,
+            $row->issuance_realization_pbg_count,
+            $row->issuance_realization_pbg_sum,
+            $row->process_in_technical_office_count,
+            $row->process_in_technical_office_sum,
+            $row->year,
+            $row->created_at ? $row->created_at->format('Y-m-d H:i:s') : null, // Format created_at as Y-m-d
+        ];
+    }
+}

app/Exports/ReportPaymentRecapExport.php

@@ -0,0 +1,71 @@
+<?php
+
+namespace App\Exports;
+
+use App\Models\BigdataResume;
+use Maatwebsite\Excel\Concerns\FromCollection;
+use Maatwebsite\Excel\Concerns\WithHeadings;
+
+class ReportPaymentRecapExport implements FromCollection, WithHeadings
+{
+    /**
+    * @return \Illuminate\Support\Collection
+    */
+    protected $startDate;
+    protected $endDate;
+    public function __construct($startDate, $endDate){
+        $this->startDate = $startDate;
+        $this->endDate = $endDate;
+    }
+    public function collection()
+    {
+        $query = BigdataResume::query()->orderBy('id', 'desc');
+
+        if ($this->startDate && $this->endDate) {
+            $query->whereBetween('created_at', [$this->startDate, $this->endDate]);
+        }
+
+        $items = $query->get();
+
+        $categoryMap = [
+            'potention_sum' => 'Potensi',
+            'non_verified_sum' => 'Belum Terverifikasi',
+            'verified_sum' => 'Terverifikasi',
+            'business_sum' => 'Usaha',
+            'non_business_sum' => 'Non Usaha',
+            'spatial_sum' => 'Tata Ruang',
+            'waiting_click_dpmptsp_sum' => 'Menunggu Klik DPMPTSP',
+            'issuance_realization_pbg_sum' => 'Realisasi Terbit PBG',
+            'process_in_technical_office_sum' => 'Proses Di Dinas Teknis',
+        ];
+
+        // Restructure response
+        $data = [];
+
+        foreach ($items as $item) {
+            $createdAt = $item->created_at;
+            $id = $item->id;
+
+            foreach ($item->toArray() as $key => $value) {
+                // Only include columns with "sum" in their names
+                if (strpos($key, 'sum') !== false) {
+                    $data[] = [
+                        'category' => $categoryMap[$key] ?? $key, // Map category
+                        'nominal' => number_format($value, 0, ',', '.'), // Format number
+                        'created_at' => $createdAt->format('Y-m-d H:i:s'), // Format date
+                    ];
+                }
+            }
+        }
+
+        return collect($data);
+    }
+
+    public function headings(): array{
+        return [
+            'Kategori',
+            'Nominal',
+            'Created'
+        ];
+    }
+}

app/Exports/ReportPbgPtspExport.php

@@ -0,0 +1,32 @@
+<?php
+
+namespace App\Exports;
+
+use App\Models\PbgTask;
+use Illuminate\Support\Facades\DB;
+use Maatwebsite\Excel\Concerns\FromCollection;
+use Maatwebsite\Excel\Concerns\WithHeadings;
+
+class ReportPbgPtspExport implements FromCollection, WithHeadings
+{
+    /**
+    * @return \Illuminate\Support\Collection
+    */
+    public function collection()
+    {
+        return PbgTask::select(
+                    'status_name',
+                    DB::raw('COUNT(*) as total')
+                )
+                ->groupBy('status', 'status_name')
+                ->get();
+    }
+
+    public function headings(): array
+    {
+        return [
+            'Status Name',
+            'Total'
+        ];
+    }
+}

app/Exports/ReportTourismExport.php

@@ -0,0 +1,25 @@
+<?php
+
+namespace App\Exports;
+
+use App\Models\TourismBasedKBLI;
+use Maatwebsite\Excel\Concerns\FromCollection;
+use Maatwebsite\Excel\Concerns\WithHeadings;
+
+class ReportTourismExport implements FromCollection, WithHeadings
+{
+    /**
+    * @return \Illuminate\Support\Collection
+    */
+    public function collection()
+    {
+        return TourismBasedKBLI::select('kbli_title', 'total_records')->get();
+    }
+
+    public function headings(): array{
+        return [
+            'Jenis Bisnis Pariwisata',
+            'Jumlah Total'
+        ];
+    }
+}

app/Http/Controllers/Api/BigDataResumeController.php

@@ -2,12 +2,17 @@
 
 namespace App\Http\Controllers\Api;
 
+use App\Exports\ReportDirectorExport;
+use App\Exports\ReportPaymentRecapExport;
 use App\Http\Controllers\Controller;
 use App\Http\Resources\BigdataResumeResource;
 use App\Models\BigdataResume;
 use App\Models\DataSetting;
+use Barryvdh\DomPDF\Facade\Pdf;
+use Carbon\Carbon;
 use Illuminate\Http\Request;
 use Illuminate\Support\Facades\Log;
+use Maatwebsite\Excel\Facades\Excel;
 
 class BigDataResumeController extends Controller
 {
@@ -178,11 +183,14 @@ class BigDataResumeController extends Controller
         try {
             $query = BigdataResume::query()->orderBy('id', 'desc');
 
-            if ($request->filled('date')) {
+            if ($request->filled('start_date') && $request->filled('end_date')) {
-                $query->where('year', 'LIKE', '%' . $request->input('search') . '%');
+                $startDate = Carbon::parse($request->input('start_date'))->startOfDay();
+                $endDate = Carbon::parse($request->input('end_date'))->endOfDay();
+
+                $query->whereBetween('created_at', [$startDate, $endDate]);
             }
 
-            $data = $query->paginate(10);
+            $data = $query->paginate(50);
 
             // Restructure response
             $transformedData = [];
@@ -207,7 +215,7 @@ class BigDataResumeController extends Controller
             return response()->json([
                 'data' => $transformedData, // Flat array
                 'pagination' => [
-                    'total' => $data->total(),
+                    'total' => count($transformedData),
                     'per_page' => $data->perPage(),
                     'current_page' => $data->currentPage(),
                     'last_page' => $data->lastPage(),
@@ -219,7 +227,99 @@ class BigDataResumeController extends Controller
         }
     }
 
+    public function export_excel_payment_recaps(Request $request)
+    {
+        $startDate = null;
+        $endDate = null;
 
+        if ($request->filled('start_date') && $request->filled('end_date')) {
+            $startDate = Carbon::parse($request->input('start_date'))->startOfDay();
+            $endDate = Carbon::parse($request->input('end_date'))->endOfDay();
+        }
+
+        return Excel::download(new ReportPaymentRecapExport($startDate, $endDate), 'laporan-rekap-pembayaran.xlsx');
+    }
+
+    public function export_pdf_payment_recaps(Request $request){
+        $query = BigdataResume::query()->orderBy('id', 'desc');
+
+        if ($request->filled('start_date') && $request->filled('end_date')) {
+            $startDate = Carbon::parse($request->input('start_date'))->startOfDay();
+            $endDate = Carbon::parse($request->input('end_date'))->endOfDay();
+
+            $query->whereBetween('created_at', [$startDate, $endDate]);
+        }
+
+        $items = $query->get();
+
+        // Define category mapping
+        $categoryMap = [
+            'potention_sum' => 'Potensi',
+            'non_verified_sum' => 'Belum Terverifikasi',
+            'verified_sum' => 'Terverifikasi',
+            'business_sum' => 'Usaha',
+            'non_business_sum' => 'Non Usaha',
+            'spatial_sum' => 'Tata Ruang',
+            'waiting_click_dpmptsp_sum' => 'Menunggu Klik DPMPTSP',
+            'issuance_realization_pbg_sum' => 'Realisasi Terbit PBG',
+            'process_in_technical_office_sum' => 'Proses Di Dinas Teknis',
+        ];
+
+        // Restructure response
+        $data = [];
+
+        foreach ($items as $item) {
+            $createdAt = $item->created_at;
+            $id = $item->id;
+
+            foreach ($item->toArray() as $key => $value) {
+                // Only include columns with "sum" in their names
+                if (strpos($key, 'sum') !== false) {
+                    $data[] = [
+                        'id' => $id,
+                        'category' => $categoryMap[$key] ?? $key, // Map category
+                        'nominal' => $value, // Format number
+                        'created_at' => $createdAt->format('Y-m-d H:i:s'), // Format date
+                    ];
+                }
+            }
+        }
+
+        $pdf = Pdf::loadView('exports.payment_recaps_report', compact('data'));
+        return $pdf->download('laporan-rekap-pembayaran.pdf');
+    }
+
+
+    public function export_excel_report_director(){
+        return Excel::download(new ReportDirectorExport, 'laporan-pimpinan.xlsx');
+    }
+
+    public function export_pdf_report_director(){
+        $data = BigdataResume::select(
+            'potention_count',
+            'potention_sum',
+            'non_verified_count',
+            'non_verified_sum',
+            'verified_count',
+            'verified_sum',
+            'business_count',
+            'business_sum',
+            'non_business_count',
+            'non_business_sum',
+            'spatial_count',
+            'spatial_sum',
+            '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',
+            'year',
+            'created_at'
+        )->orderBy('id', 'desc')->get();
+        $pdf = Pdf::loadView('exports.director_report', compact('data'))->setPaper('a4', 'landscape');
+        return $pdf->download('laporan-pimpinan.pdf');
+    }
     private function response_empty_resume(){
         $result = [
             'target_pad' => [

app/Http/Controllers/Api/MenusController.php

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

app/Http/Controllers/Api/ReportPbgPtspController.php

@@ -0,0 +1,29 @@
+<?php
+
+namespace App\Http\Controllers\Api;
+
+use App\Exports\ReportPbgPtspExport;
+use App\Http\Controllers\Controller;
+use App\Models\PbgTask;
+use Barryvdh\DomPDF\Facade\Pdf;
+use Illuminate\Http\Request;
+use Illuminate\Support\Facades\DB;
+use Maatwebsite\Excel\Facades\Excel;
+
+class ReportPbgPtspController extends Controller
+{
+    public function export_excel(){
+        return Excel::download(new ReportPbgPtspExport, 'laporan-ptsp.xlsx');
+    }
+    public function export_pdf(){
+        $data = PbgTask::select(
+                    'status',
+                    'status_name', // Keeping this column
+                    DB::raw('COUNT(*) as total')
+                )
+                ->groupBy('status', 'status_name')
+                ->get();
+        $pdf = Pdf::loadView('exports.ptsp_report', compact('data'));
+        return $pdf->download('laporan-ptsp.pdf');
+    }
+}

app/Http/Controllers/Api/ReportTourismsController.php

@@ -0,0 +1,22 @@
+<?php
+
+namespace App\Http\Controllers\Api;
+
+use App\Exports\ReportTourismExport;
+use App\Http\Controllers\Controller;
+use App\Models\TourismBasedKBLI;
+use Barryvdh\DomPDF\Facade\Pdf;
+use Illuminate\Http\Request;
+use Maatwebsite\Excel\Facades\Excel;
+
+class ReportTourismsController extends Controller
+{
+    public function export_excel(){
+        return Excel::download(new ReportTourismExport, 'laporan-pariwisata.xlsx');
+    }
+    public function export_pdf(){
+        $data = TourismBasedKBLI::all();
+        $pdf = Pdf::loadView('exports.tourisms_report', compact('data'));
+        return $pdf->download('laporan-pariwisata.pdf');
+    }
+}

app/Http/Controllers/Api/RequestAssignmentController.php

@@ -2,14 +2,17 @@
 
 namespace App\Http\Controllers\Api;
 
+use App\Exports\DistrictPaymentRecapExport;
 use App\Http\Controllers\Controller;
 use App\Http\Resources\RequestAssignmentResouce;
 use App\Models\PbgTask;
 use App\Models\PbgTaskGoogleSheet;
+use Barryvdh\DomPDF\Facade\Pdf;
 use DB;
 use Exception;
 use Illuminate\Http\Request;
 use Log;
+use Maatwebsite\Excel\Facades\Excel;
 
 class RequestAssignmentController extends Controller
 {
@@ -49,6 +52,19 @@ class RequestAssignmentController extends Controller
             return response()->json(['message' => 'Terjadi kesalahan: ' . $e->getMessage()], 500);
         }
     }
+
+    public function export_excel_district_payment_recaps(){
+        return Excel::download(new DistrictPaymentRecapExport, 'laporan-rekap-data-pembayaran.xlsx');
+    }
+    public function export_pdf_district_payment_recaps(){
+        $data = PbgTaskGoogleSheet::select(
+                    'kecamatan',
+                    DB::raw('SUM(nilai_retribusi_keseluruhan_simbg) as total')
+                )
+                ->groupBy('kecamatan')->get();
+        $pdf = Pdf::loadView('exports.district_payment_report', compact('data'));
+        return $pdf->download('laporan-rekap-data-pembayaran.pdf');
+    }
     public function report_pbg_ptsp()
     {
         try {

app/Http/Controllers/Api/ScrapingController.php

@@ -4,9 +4,15 @@ namespace App\Http\Controllers\Api;
 
 use App\Enums\ImportDatasourceStatus;
 use App\Http\Controllers\Controller;
+use App\Jobs\ScrapingDataJob;
 use App\Jobs\SyncronizeSIMBG;
 use App\Models\ImportDatasource;
 use App\Traits\GlobalApiResponse;
+use App\Services\ServiceTokenSIMBG;
+use GuzzleHttp\Client;
+use App\Services\ServiceGoogleSheet;
+use App\Services\ServicePbgTask;
+use App\Services\ServiceTabPbgTask;
 use Illuminate\Support\Facades\Artisan;
 use Illuminate\Http\Request;
 
@@ -23,8 +29,11 @@ class ScrapingController extends Controller
             return $this->resError("Failed to execute while processing another scraping");
         }
 
-        // run service artisan command 
+        // use ole schema synchronization
-        SyncronizeSIMBG::dispatch();
+        // dispatch(new SyncronizeSIMBG());
+
+        // use new schema synchronization
+        dispatch(new ScrapingDataJob());
         return $this->resSuccess(["message" => "Success execute scraping service on background, check status for more"]);
     }
 

app/Http/Controllers/Api/UsersController.php

@@ -85,4 +85,17 @@ class UsersController extends Controller
             return response()->json(['message' => $e->getMessage()],500);
         }
     }
+
+    public function destroy($id){
+        try{
+            $user = User::findOrFail($id);
+            DB::beginTransaction();
+            $user->delete(); 
+            DB::commit();
+            return response()->json(['message' => 'Successfully deleted'], 200);
+        }catch(\Exception $e){
+            Log::error('Failed to delete user: '. $e->getMessage());
+            return response()->json(['message' => 'Failed to delete user'],500);
+        }
+    }
 }

app/Http/Controllers/BusinessOrIndustriesController.php

@@ -14,74 +14,30 @@ class BusinessOrIndustriesController extends Controller
      */
     public function index(Request $request)
     {
-        $menuId = $request->query('menu_id');
+        $menuId = $request->query('menu_id') ?? $request->input('menu_id');
-        $user = Auth::user();
+        $permissions = $this->permissions[$menuId]?? []; // Avoid undefined index error
-        $userId = $user->id;
+        $creator = $permissions['allow_create'] ?? 0;
-
+        $updater = $permissions['allow_update'] ?? 0;
-        // Ambil role_id yang dimiliki user
+        $destroyer = $permissions['allow_destroy'] ?? 0;
-        $roleIds = DB::table('user_role')
+        return view('business-industries.index', compact('creator', 'updater', 'destroyer','menuId'));
-            ->where('user_id', $userId)
-            ->pluck('role_id');
-
-        // Ambil data akses berdasarkan role_id dan menu_id
-        $roleAccess = DB::table('role_menu')
-            ->whereIn('role_id', $roleIds)
-            ->where('menu_id', $menuId)
-            ->first();
-
-        // Pastikan roleAccess tidak null sebelum mengakses properti
-        $creator = $roleAccess->allow_create ?? 0;
-        $updater = $roleAccess->allow_update ?? 0;
-        $destroyer = $roleAccess->allow_destroy ?? 0;
-        return view('business-industries.index', compact('creator', 'updater', 'destroyer'));
     }
     
     /**
      * Show the form for creating a new resource.
      */
-    public function create()
+    public function create(Request $request)
     {
-        return view("business-industries.create");
+        $menuId = $request->query('menu_id') ?? $request->input('menu_id');
-    }
+        return view("business-industries.create", compact('menuId'));
-
-    /**
-     * Store a newly created resource in storage.
-     */
-    public function store(Request $request)
-    {
-        //
-    }
-
-    /**
-     * Display the specified resource.
-     */
-    public function show(string $id)
-    {
-        //
     }
 
     /**
      * Show the form for editing the specified resource.
      */
-    public function edit(string $id)
+    public function edit(string $id, Request $request)
     {
+        $menuId = $request->query('menu_id') ?? $request->input('menu_id');
         $data = BusinessOrIndustry::findOrFail($id);
-        return view('business-industries.edit', compact('data'));
+        return view('business-industries.edit', compact('data', 'menuId'));
-    }
-
-    /**
-     * Update the specified resource in storage.
-     */
-    public function update(Request $request, string $id)
-    {
-        //
-    }
-
-    /**
-     * Remove the specified resource from storage.
-     */
-    public function destroy(string $id)
-    {
-        //
     }
 }

app/Http/Controllers/CustomersController.php

@@ -11,38 +11,27 @@ class CustomersController extends Controller
 {
     public function index(Request $request)
     {
-        $menuId = $request->query('menu_id');
+        $menuId = $request->query('menu_id') ?? $request->input('menu_id');
-        $user = Auth::user();
+        $permissions = $this->permissions[$menuId]?? []; // Avoid undefined index error
-        $userId = $user->id;
+        $creator = $permissions['allow_create'] ?? 0;
+        $updater = $permissions['allow_update'] ?? 0;
+        $destroyer = $permissions['allow_destroy'] ?? 0;
 
-        // Ambil role_id yang dimiliki user
+        return view('customers.index', compact('creator', 'updater', 'destroyer', 'menuId'));
-        $roleIds = DB::table('user_role')
-            ->where('user_id', $userId)
-            ->pluck('role_id');
-
-        // Ambil data akses berdasarkan role_id dan menu_id
-        $roleAccess = DB::table('role_menu')
-            ->whereIn('role_id', $roleIds)
-            ->where('menu_id', $menuId)
-            ->first();
-
-        // Pastikan roleAccess tidak null sebelum mengakses properti
-        $creator = $roleAccess->allow_create ?? 0;
-        $updater = $roleAccess->allow_update ?? 0;
-        $destroyer = $roleAccess->allow_destroy ?? 0;
-
-        return view('customers.index', compact('creator', 'updater', 'destroyer'));
     }
-    public function create()
+    public function create(Request $request)
     {
-        return view('customers.create');
+        $menuId = $request->query('menu_id');
+        return view('customers.create', compact('menuId'));
     }
-    public function edit(string $id)
+    public function edit(Request $request, string $id)
     {
         $data = Customer::findOrFail($id);
-        return view('customers.edit', compact('data'));
+        $menuId = $request->query('menu_id');
+        return view('customers.edit', compact('data', 'menuId'));
     }
-    public function upload(){
+    public function upload(Request $request){
-        return view('customers.upload');
+        $menuId = $request->query('menu_id');
+        return view('customers.upload', compact('menuId'));
     }
 }

app/Http/Controllers/Data/AdvertisementController.php

@@ -15,27 +15,14 @@ class AdvertisementController extends Controller
      */
     public function index(Request $request)
     {
-        $menuId = $request->query('menu_id');
+        $menuId = $request->query('menu_id', 0);
-        $user = Auth::user();
+        $permissions = $this->permissions[$menuId] ?? []; // Avoid undefined index error
-        $userId = $user->id;
 
-        // Ambil role_id yang dimiliki user
+        $creator = $permissions['allow_create'] ?? 0;
-        $roleIds = DB::table('user_role')
+        $updater = $permissions['allow_update'] ?? 0;
-            ->where('user_id', $userId)
+        $destroyer = $permissions['allow_destroy'] ?? 0;
-            ->pluck('role_id');
 
-        // Ambil data akses berdasarkan role_id dan menu_id
+        return view('data.advertisements.index', compact('creator', 'updater', 'destroyer','menuId'));
-        $roleAccess = DB::table('role_menu')
-            ->whereIn('role_id', $roleIds)
-            ->where('menu_id', $menuId)
-            ->first();
-
-        // Pastikan roleAccess tidak null sebelum mengakses properti
-        $creator = $roleAccess->allow_create ?? 0;
-        $updater = $roleAccess->allow_update ?? 0;
-        $destroyer = $roleAccess->allow_destroy ?? 0;
-
-        return view('data.advertisements.index', compact('creator', 'updater', 'destroyer'));
     }
 
     /**
@@ -50,8 +37,9 @@ class AdvertisementController extends Controller
     /**
      * Show the form for creating a new resource.
      */
-    public function create()
+    public function create(Request $request)
     {
+        $menuId = $request->query('menu_id', 0);
         $title = 'Advertisement';
         $subtitle = 'Create Data';
 
@@ -68,14 +56,15 @@ class AdvertisementController extends Controller
         
         // $route = 'advertisements.create';
         // info("AdvertisementController@edit diakses dengan ID: $title");
-        return view('data.advertisements.form', compact('title', 'subtitle', 'fields', 'fieldTypes', 'apiUrl', 'dropdownOptions'));
+        return view('data.advertisements.form', compact('title', 'subtitle', 'fields', 'fieldTypes', 'apiUrl', 'dropdownOptions','menuId'));
     }
 
     /**
      * Show the form for editing the specified resource.
      */
-    public function edit($id)
+    public function edit(Request $request, $id)
     {
+        $menuId = $request->query('menu_id', 0);
         info("AdvertisementController@edit diakses dengan ID: $id");
         $title = 'Advertisement';
         $subtitle = 'Update Data';
@@ -107,7 +96,7 @@ class AdvertisementController extends Controller
 
         // $route = 'advertisements.update'; // Menggunakan route update untuk form edit
         // info("AdvertisementController@edit diakses dengan route: $route");
-        return view('data.advertisements.form', compact('title', 'subtitle', 'modelInstance', 'fields', 'fieldTypes', 'apiUrl', 'dropdownOptions'));
+        return view('data.advertisements.form', compact('title', 'subtitle', 'modelInstance', 'fields', 'fieldTypes', 'apiUrl', 'dropdownOptions', 'menuId'));
     }
 
     private function getFields()

app/Http/Controllers/Data/SpatialPlanningController.php

@@ -5,8 +5,6 @@ namespace App\Http\Controllers\Data;
 use App\Http\Controllers\Controller;
 use App\Models\SpatialPlanning;
 use Illuminate\Http\Request;
-use Illuminate\Support\Facades\DB;
-use Illuminate\Support\Facades\Auth;
 
 class SpatialPlanningController extends Controller
 {
@@ -15,42 +13,31 @@ class SpatialPlanningController extends Controller
      */
     public function index(Request $request)
     {
-        $menuId = $request->query('menu_id');
+        $menuId = $request->query('menu_id', 0);
-        $user = Auth::user();
+        $permissions = $this->permissions[$menuId] ?? []; // Avoid undefined index error
-        $userId = $user->id;
 
-        // Ambil role_id yang dimiliki user
+        $creator = $permissions['allow_create'] ?? 0;
-        $roleIds = DB::table('user_role')
+        $updater = $permissions['allow_update'] ?? 0;
-            ->where('user_id', $userId)
+        $destroyer = $permissions['allow_destroy'] ?? 0;
-            ->pluck('role_id');
 
-        // Ambil data akses berdasarkan role_id dan menu_id
+        return view('data.spatialPlannings.index', compact('creator', 'updater', 'destroyer','menuId'));
-        $roleAccess = DB::table('role_menu')
-            ->whereIn('role_id', $roleIds)
-            ->where('menu_id', $menuId)
-            ->first();
-
-        // Pastikan roleAccess tidak null sebelum mengakses properti
-        $creator = $roleAccess->allow_create ?? 0;
-        $updater = $roleAccess->allow_update ?? 0;
-        $destroyer = $roleAccess->allow_destroy ?? 0;
-
-        return view('data.spatialPlannings.index', compact('creator', 'updater', 'destroyer'));
     }
 
     /**
      * show the form for creating a new resource.
      */
-    public function bulkCreate()
+    public function bulkCreate(Request $request)
     {
-        return view('data.spatialPlannings.form-upload');
+        $menuId = $request->query('menu_id', 0);
+        return view('data.spatialPlannings.form-upload', compact('menuId'));
     }
 
     /**
      * Show the form for creating a new resource.
      */
-    public function create()
+    public function create(Request $request)
     {
+        $menuId = $request->query('menu_id', 0);
         $title = 'Rencana Tata Ruang';
         $subtitle = "Create Data";
 
@@ -61,30 +48,15 @@ class SpatialPlanningController extends Controller
         $fieldTypes = $this->getFieldTypes();
 
         $apiUrl = url('/api/spatial-plannings');
-        return view('data.spatialPlannings.form', compact('title', 'subtitle', 'fields', 'fieldTypes', 'apiUrl', 'dropdownOptions'));
+        return view('data.spatialPlannings.form', compact('title', 'subtitle', 'fields', 'fieldTypes', 'apiUrl', 'dropdownOptions','menuId'));
-    }
-
-    /**
-     * Store a newly created resource in storage.
-     */
-    public function store(Request $request)
-    {
-        //
-    }
-
-    /**
-     * Display the specified resource.
-     */
-    public function show(string $id)
-    {
-        //
     }
 
     /**
      * Show the form for editing the specified resource.
      */
-    public function edit(string $id)
+    public function edit(Request $request,string $id)
     {
+        $menuId = $request->query('menu_id', 0);
         $title = 'Rencana Tata Ruang';
         $subtitle = 'Update Data';
 
@@ -100,23 +72,7 @@ class SpatialPlanningController extends Controller
         $fieldTypes = $this->getFieldTypes();
 
         $apiUrl = url('/api/spatial-plannings');
-        return view('data.spatialPlannings.form', compact('title', 'subtitle', 'modelInstance', 'fields', 'fieldTypes', 'apiUrl', 'dropdownOptions'));
+        return view('data.spatialPlannings.form', compact('title', 'subtitle', 'modelInstance', 'fields', 'fieldTypes', 'apiUrl', 'dropdownOptions','menuId'));
-    }
-
-    /**
-     * Update the specified resource in storage.
-     */
-    public function update(Request $request, string $id)
-    {
-        //
-    }
-
-    /**
-     * Remove the specified resource from storage.
-     */
-    public function destroy(string $id)
-    {
-        //
     }
 
     private function getFields()

app/Http/Controllers/Data/TourismController.php

@@ -15,41 +15,30 @@ class TourismController extends Controller
      */
     public function index(Request $request)
     {
-        $menuId = $request->query('menu_id');
+        $menuId = $request->query('menu_id', 0);
-        $user = Auth::user();
+        $permissions = $this->permissions[$menuId] ?? []; // Avoid undefined index error
-        $userId = $user->id;
 
-        // Ambil role_id yang dimiliki user
+        $creator = $permissions['allow_create'] ?? 0;
-        $roleIds = DB::table('user_role')
+        $updater = $permissions['allow_update'] ?? 0;
-            ->where('user_id', $userId)
+        $destroyer = $permissions['allow_destroy'] ?? 0;
-            ->pluck('role_id');
+        return view('data.tourisms.index', compact('creator', 'updater', 'destroyer', 'menuId'));
-
-        // Ambil data akses berdasarkan role_id dan menu_id
-        $roleAccess = DB::table('role_menu')
-            ->whereIn('role_id', $roleIds)
-            ->where('menu_id', $menuId)
-            ->first();
-
-        // Pastikan roleAccess tidak null sebelum mengakses properti
-        $creator = $roleAccess->allow_create ?? 0;
-        $updater = $roleAccess->allow_update ?? 0;
-        $destroyer = $roleAccess->allow_destroy ?? 0;
-        return view('data.tourisms.index', compact('creator', 'updater', 'destroyer'));
     }
 
     /**
      * show the form for creating a new rsource.
      */
-    public function bulkCreate()
+    public function bulkCreate(Request $request)
     {
-        return view('data.tourisms.form-upload');
+        $menuId = $request->query('menu_id', 0);
+        return view('data.tourisms.form-upload', compact('menuId'));
     }
 
     /**
      * Show th form for creating a new resource
      */
-    public function create()
+    public function create(Request $request)
     {
+        $menuId = $request->query('menu_id', 0);
         $title = 'Pariwisata';
         $subtitle = 'Create Data';
 
@@ -64,14 +53,15 @@ class TourismController extends Controller
 
         $apiUrl = url('/api/tourisms');
 
-        return view('data.tourisms.form', compact('title', 'subtitle', 'fields', 'fieldTypes', 'apiUrl', 'dropdownOptions'));
+        return view('data.tourisms.form', compact('title', 'subtitle', 'fields', 'fieldTypes', 'apiUrl', 'dropdownOptions', 'menuId'));
     }
 
     /**
      * show the form for editing the specified resource.
      */
-    public function edit($id)
+    public function edit(Request $request, $id)
     {
+        $menuId = $request->query('menu_id', 0);
         $title = 'Pariwisata';
         $subtitle = 'Update Data';
 
@@ -98,7 +88,7 @@ class TourismController extends Controller
 
         $apiUrl = url('/api/tourisms');
 
-        return view('data.tourisms.form', compact('title', 'subtitle', 'modelInstance', 'fields', 'fieldTypes', 'apiUrl', 'dropdownOptions'));
+        return view('data.tourisms.form', compact('title', 'subtitle', 'modelInstance', 'fields', 'fieldTypes', 'apiUrl', 'dropdownOptions', 'menuId'));
     }
 
     private function getFields()

app/Http/Controllers/Data/UmkmController.php

@@ -15,41 +15,30 @@ class UmkmController extends Controller
      */
     public function index(Request $request)
     {
-        $menuId = $request->query('menu_id');
+        $menuId = $request->query('menu_id', 0);
-        $user = Auth::user();
+        $permissions = $this->permissions[$menuId] ?? []; // Avoid undefined index error
-        $userId = $user->id;
 
-        // Ambil role_id yang dimiliki user
+        $creator = $permissions['allow_create'] ?? 0;
-        $roleIds = DB::table('user_role')
+        $updater = $permissions['allow_update'] ?? 0;
-            ->where('user_id', $userId)
+        $destroyer = $permissions['allow_destroy'] ?? 0;
-            ->pluck('role_id');
+        return view('data.umkm.index', compact('creator', 'updater', 'destroyer', 'menuId'));
-
-        // Ambil data akses berdasarkan role_id dan menu_id
-        $roleAccess = DB::table('role_menu')
-            ->whereIn('role_id', $roleIds)
-            ->where('menu_id', $menuId)
-            ->first();
-        
-        // Pastikan roleAccess tidak null sebelum mengakses properti
-        $creator = $roleAccess->allow_create ?? 0;
-        $updater = $roleAccess->allow_update ?? 0;
-        $destroyer = $roleAccess->allow_destroy ?? 0;
-        return view('data.umkm.index', compact('creator', 'updater', 'destroyer'));
     }
 
     /**
      * Show the form for creating a new resource.
      */
-    public function bulkCreate()
+    public function bulkCreate(Request $request)
     {
-        return view('data.umkm.form-upload');
+        $menuId = $request->query('menu_id', 0);
+        return view('data.umkm.form-upload', compact('menuId'));
     }
 
     /**
      * Show the form for creating a new resource.
      */
-    public function create()
+    public function create(Request $request)
     {
+        $menuId = $request->query('menu_id', 0);
         $title = 'UMKM';
         $subtitle = 'Create Data';
 
@@ -67,14 +56,15 @@ class UmkmController extends Controller
 
         $apiUrl = url('/api/umkm');
 
-        return view('data.umkm.form', compact('title', 'subtitle', 'fields', 'fieldTypes', 'apiUrl', 'dropdownOptions'));
+        return view('data.umkm.form', compact('title', 'subtitle', 'fields', 'fieldTypes', 'apiUrl', 'dropdownOptions','menuId'));
     }
 
     /**
      * Show the form for editing the specified resource.
      */
-    public function edit($id)
+    public function edit(Request $request,$id)
     {
+        $menuId = $request->query('menu_id', 0);
         $title = 'UMKM';
         $subtitle = 'Update Data';
         $modelInstance = Umkm::find($id);
@@ -116,7 +106,7 @@ class UmkmController extends Controller
         $apiUrl = url('/api/umkm');
 
         // dd($modelInstance->business_form_id, $dropdownOptions['business_form']);
-        return view('data.umkm.form', compact('title', 'subtitle', 'modelInstance', 'fields', 'fieldTypes', 'apiUrl', 'dropdownOptions'));
+        return view('data.umkm.form', compact('title', 'subtitle', 'modelInstance', 'fields', 'fieldTypes', 'apiUrl', 'dropdownOptions','menuId'));
     }
 
     private function getFields()

app/Http/Controllers/DataSettingController.php

@@ -18,34 +18,21 @@ class DataSettingController extends Controller
      */
     public function index(IndexRequest $request)
     {
-        $menuId = $request->query('menu_id');
+        $menuId = $request->query('menu_id') ?? $request->input('menu_id');
-        $user = Auth::user();
+        $permissions = $this->permissions[$menuId]?? []; // Avoid undefined index error
-        $userId = $user->id;
+        $creator = $permissions['allow_create'] ?? 0;
-
+        $updater = $permissions['allow_update'] ?? 0;
-        // Ambil role_id yang dimiliki user
+        $destroyer = $permissions['allow_destroy'] ?? 0;
-        $roleIds = DB::table('user_role')
+        return view("data-settings.index", compact('creator', 'updater', 'destroyer','menuId'));
-            ->where('user_id', $userId)
-            ->pluck('role_id');
-
-        // Ambil data akses berdasarkan role_id dan menu_id
-        $roleAccess = DB::table('role_menu')
-            ->whereIn('role_id', $roleIds)
-            ->where('menu_id', $menuId)
-            ->first();
-
-        // Pastikan roleAccess tidak null sebelum mengakses properti
-        $creator = $roleAccess->allow_create ?? 0;
-        $updater = $roleAccess->allow_update ?? 0;
-        $destroyer = $roleAccess->allow_destroy ?? 0;
-        return view("data-settings.index", compact('creator', 'updater', 'destroyer'));
     }
 
     /**
      * Show the form for creating a new resource.
      */
-    public function create()
+    public function create(IndexRequest $request)
     {
-        return view("data-settings.create");
+        $menuId = $request->query('menu_id') ?? $request->input('menu_id');
+        return view("data-settings.create", compact('menuId'));
     }
 
     /**
@@ -78,14 +65,15 @@ class DataSettingController extends Controller
     /**
      * Show the form for editing the specified resource.
      */
-    public function edit(string $id)
+    public function edit(IndexRequest $request,string $id)
     {
         try{
             $data = DataSetting::findOrFail($id);
+            $menuId = $request->query('menu_id') ?? $request->input('menu_id');
             if(empty($data)){
                 return redirect()->route('data-settings.index')->with('error', 'Invalid id');
             }
-            return view("data-settings.edit", compact("data"));
+            return view("data-settings.edit", compact("data", 'menuId'));
         }catch(Exception $ex){
             return redirect()->route("data-settings.index")->with("error", "Invalid id");
         }

app/Http/Controllers/Master/UsersController.php

@@ -23,32 +23,19 @@ class UsersController extends Controller
         return $this->resSuccess($users);
     }
     public function index(Request $request){
-        $menuId = $request->query('menu_id');
+        $menuId = $request->query('menu_id') ?? $request->input('menu_id');
-        $user = Auth::user();
+        $permissions = $this->permissions[$menuId]?? []; // Avoid undefined index error
-        $userId = $user->id;
+        $creator = $permissions['allow_create'] ?? 0;
-
+        $updater = $permissions['allow_update'] ?? 0;
-        // Ambil role_id yang dimiliki user
+        $destroyer = $permissions['allow_destroy'] ?? 0;
-        $roleIds = DB::table('user_role')
-            ->where('user_id', $userId)
-            ->pluck('role_id');
-
-        // Ambil data akses berdasarkan role_id dan menu_id
-        $roleAccess = DB::table('role_menu')
-            ->whereIn('role_id', $roleIds)
-            ->where('menu_id', $menuId)
-            ->first();
-
-        // Pastikan roleAccess tidak null sebelum mengakses properti
-        $creator = $roleAccess->allow_create ?? 0;
-        $updater = $roleAccess->allow_update ?? 0;
-        $destroyer = $roleAccess->allow_destroy ?? 0;
 
         $users = User::paginate();
-        return view('master.users.index', compact('users', 'creator', 'updater', 'destroyer'));
+        return view('master.users.index', compact('users', 'creator', 'updater', 'destroyer','menuId'));
     }
-    public function create(){
+    public function create(Request $request){
+        $menuId = $request->query('menu_id') ?? $request->input('menu_id');
         $roles = Role::all();
-        return view('master.users.create', compact('roles'));
+        return view('master.users.create', compact('roles', 'menuId'));
     }
     public function store(UsersRequest $request){
         $request->validate([
@@ -86,10 +73,11 @@ class UsersController extends Controller
         $user = User::find($id);
         return view('master.users.show', compact('user'));
     }
-    public function edit($id){
+    public function edit(Request $request, $id){
+        $menuId = $request->query('menu_id') ?? $request->input('menu_id');
         $user = User::find($id);
         $roles = Role::all();
-        return view('master.users.edit', compact('user', 'roles'));
+        return view('master.users.edit', compact('user', 'roles', 'menuId'));
     }
     public function update(Request $request, $id){
         $user = User::find($id);

app/Http/Controllers/MenusController.php

@@ -6,7 +6,6 @@ use App\Http\Requests\MenuRequest;
 use App\Models\Menu;
 use Illuminate\Http\Request;
 use Illuminate\Support\Facades\DB;
-use Illuminate\Support\Facades\Auth;
 
 class MenusController extends Controller
 {
@@ -15,36 +14,33 @@ class MenusController extends Controller
      */
     public function index(Request $request)
     {
-        $menuId = $request->query('menu_id');
+        $menuId = (int) $request->query('menu_id', 0);
-        $user = Auth::user();
+        $permissions = $this->permissions[$menuId] ?? []; // Avoid undefined index error
-        $userId = $user->id;
 
-        // Ambil role_id yang dimiliki user
+        $creator = $permissions['allow_create'] ?? 0;
-        $roleIds = DB::table('user_role')
+        $updater = $permissions['allow_update'] ?? 0;
-            ->where('user_id', $userId)
+        $destroyer = $permissions['allow_destroy'] ?? 0;
-            ->pluck('role_id');
 
-        // Ambil data akses berdasarkan role_id dan menu_id
+        return view('menus.index', compact('creator', 'updater', 'destroyer', 'menuId'));
-        $roleAccess = DB::table('role_menu')
-            ->whereIn('role_id', $roleIds)
-            ->where('menu_id', $menuId)
-            ->first();
-
-        // Pastikan roleAccess tidak null sebelum mengakses properti
-        $creator = $roleAccess->allow_create ?? 0;
-        $updater = $roleAccess->allow_update ?? 0;
-        $destroyer = $roleAccess->allow_destroy ?? 0;
-
-        return view('menus.index', compact('creator', 'updater', 'destroyer'));
     }
 
     /**
      * Show the form for creating a new resource.
      */
-    public function create()
+    public function create(Request $request)
     {
-        $parent_menus = Menu::whereNull('parent_id')->get();
+        $menuId = $request->query('menu_id'); // Get menu_id from request
-        return view("menus.create", compact('parent_menus'));
+        $menu = Menu::with('children')->find($menuId); // Find the menu
+
+        // Get IDs of all child menus to exclude
+        $excludedIds = $menu ? $this->getChildMenuIds($menu) : [$menuId];
+
+        // Fetch only menus that have children and are not in the excluded list
+        $parent_menus = Menu::whereHas('children')
+            ->whereNotIn('id', $excludedIds)
+            ->get();
+
+        return view("menus.create", compact('parent_menus', 'menuId'));
     }
 
     /**
@@ -77,11 +73,16 @@ class MenusController extends Controller
     /**
      * Show the form for editing the specified resource.
      */
-    public function edit(string $id)
+    public function edit(string $id, Request $request)
     {
-        $menu = Menu::findOrFail($id);
+        $menuId = $request->query('menu_id');
-        $parent_menus = Menu::whereNull('parent_id')->where('id','!=',$id)->get();
+        $menu = Menu::with('children')->find($id);
-        return view("menus.edit", compact('menu','parent_menus'));
+        $excludedIds = $menu ? $this->getChildMenuIds($menu) : [$id]; 
+
+        $parent_menus = Menu::whereHas('children')
+            ->whereNotIn('id', $excludedIds)
+            ->get();
+        return view("menus.edit", compact('menu','parent_menus', 'menuId'));
     }
 
     /**
@@ -131,4 +132,15 @@ class MenusController extends Controller
             $child->delete();
         }
     }
+
+    private function getChildMenuIds($menu)
+    {
+        $ids = [$menu->id]; // Start with current menu ID
+
+        foreach ($menu->children as $child) {
+            $ids = array_merge($ids, $this->getChildMenuIds($child)); // Recursively fetch children
+        }
+
+        return $ids;
+    }
 }

app/Http/Controllers/Report/ReportTourismController.php

@@ -15,7 +15,6 @@ class ReportTourismController extends Controller
     public function index()
     {
         $tourismBasedKBLI = TourismBasedKBLI::all();
-        info($tourismBasedKBLI);
         return view('report.tourisms.index', compact('tourismBasedKBLI'));
     }
 }

app/Http/Controllers/RolesController.php

@@ -19,35 +19,22 @@ class RolesController extends Controller
      */
     public function index(Request $request)
     {
-        $menuId = $request->query('menu_id');
+        $menuId = $request->query('menu_id') ?? $request->input('menu_id');
-        $user = Auth::user();
+        $permissions = $this->permissions[$menuId]?? []; // Avoid undefined index error
-        $userId = $user->id;
+        $creator = $permissions['allow_create'] ?? 0;
+        $updater = $permissions['allow_update'] ?? 0;
+        $destroyer = $permissions['allow_destroy'] ?? 0;
 
-        // Ambil role_id yang dimiliki user
+        return view("roles.index", compact('creator', 'updater', 'destroyer', 'menuId'));
-        $roleIds = DB::table('user_role')
-            ->where('user_id', $userId)
-            ->pluck('role_id');
-
-        // Ambil data akses berdasarkan role_id dan menu_id
-        $roleAccess = DB::table('role_menu')
-            ->whereIn('role_id', $roleIds)
-            ->where('menu_id', $menuId)
-            ->first();
-
-        // Pastikan roleAccess tidak null sebelum mengakses properti
-        $creator = $roleAccess->allow_create ?? 0;
-        $updater = $roleAccess->allow_update ?? 0;
-        $destroyer = $roleAccess->allow_destroy ?? 0;
-
-        return view("roles.index", compact('creator', 'updater', 'destroyer'));
     }
 
     /**
      * Show the form for creating a new resource.
      */
-    public function create()
+    public function create(Request $request)
     {
-        return view("roles.create");
+        $menuId = $request->query('menu_id');
+        return view("roles.create", compact('menuId'));
     }
 
     /**
@@ -80,10 +67,11 @@ class RolesController extends Controller
     /**
      * Show the form for editing the specified resource.
      */
-    public function edit(string $id)
+    public function edit(string $id, Request $request)
     {
+        $menuId = $request->query('menu_id');
         $role = Role::findOrFail($id);
-        return view("roles.edit", compact('role'));
+        return view("roles.edit", compact('role', 'menuId'));
     }
 
     /**
@@ -121,12 +109,13 @@ class RolesController extends Controller
         }
     }
 
-    public function menu_permission(string $role_id){
+    public function menu_permission(string $role_id, Request $request){
         try{
+            $menuId = $request->query('menu_id');
             $role = Role::findOrFail($role_id);
             $menus = Menu::all();
             $role_menus = RoleMenu::where('role_id', $role_id)->get() ?? collect();
-            return view('roles.role_menu', compact('role', 'menus', 'role_menus'));
+            return view('roles.role_menu', compact('role', 'menus', 'role_menus', 'menuId'));
         }catch(\Exception $e){
             return redirect()->back()->with("error", $e->getMessage());
         }
@@ -134,8 +123,9 @@ class RolesController extends Controller
 
     public function update_menu_permission(Request $request, string $role_id){
         try{
+            $menuId = $request->query('menu_id');
             $validateData = $request->validate([
-                "permissions" => "array",
+                "permissions" => "nullable|array",
                 "permissions.*.allow_show" => "nullable|boolean",
                 "permissions.*.allow_create" => "nullable|boolean",
                 "permissions.*.allow_update" => "nullable|boolean",
@@ -144,6 +134,13 @@ class RolesController extends Controller
 
             $role = Role::find($role_id);
 
+            // Jika `permissions` tidak ada atau kosong, hapus semua permissions terkait
+            if (!isset($validateData['permissions']) || empty($validateData['permissions'])) {
+                $role->menus()->detach();
+                return redirect()->route("roles.index", ['menu_id' => $menuId])
+                    ->with('success', 'All menu permissions have been removed.');
+            }
+
             $permissionsArray = [];
             foreach ($validateData['permissions'] as $menu_id => $permission) {
                 $permissionsArray[$menu_id] = [
@@ -158,7 +155,7 @@ class RolesController extends Controller
             // Sync will update existing records and insert new ones
             $role->menus()->sync($permissionsArray);
 
-            return redirect()->route("role-menu.permission", $role_id)->with('success','Menu Permission updated successfully');
+            return redirect()->route("roles.index", ['menu_id' => $menuId])->with('success','Menu Permission updated successfully');
         }catch(\Exception $e){
             Log::error("Error updating role_menu:", ["error" => $e->getMessage()]);
             return redirect()->route("role-menu.permission", $role_id)->with("error", $e->getMessage());

app/Http/Resources/ImportDatasourceResource.php

@@ -2,6 +2,7 @@
 
 namespace App\Http\Resources;
 
+use Carbon\Carbon;
 use Illuminate\Http\Request;
 use Illuminate\Http\Resources\Json\JsonResource;
 
@@ -14,11 +15,18 @@ class ImportDatasourceResource extends JsonResource
      */
     public function toArray(Request $request): array
     {
+        $startTime = $this->start_time ? Carbon::parse($this->start_time) : null;
+        $finishTime = $this->finish_time ? Carbon::parse($this->finish_time) : null;
         return [
             "id"=> $this->id,
             "message" => $this->message,
             "response_body" => $this->response_body,
             "status" => $this->status,
+            "start_time" => $startTime ? $startTime->toDateTimeString() : null,
+            "duration" => ($startTime && $finishTime) 
+                ? $finishTime->diff($startTime)->format('%H:%I:%S') 
+                : null,
+            "finish_time" => $finishTime ? $finishTime->toDateTimeString() : null,
             "created_at" => $this->created_at->toDateTimeString(),
             "updated_at" => $this->updated_at->toDateTimeString(),
         ];

app/Http/Resources/MenuResource.php

@@ -14,6 +14,16 @@ class MenuResource extends JsonResource
      */
     public function toArray(Request $request): array
     {
-        return parent::toArray($request);
+        // return parent::toArray($request);
+        return [
+            'id' => $this->id,
+            'name' => $this->name,
+            'icon' => $this->icon,
+            'url' => $this->url,
+            'sort_order' => $this->sort_order,
+            'parent' => $this->parent ? new MenuResource($this->parent) : null,
+            'created_at' => $this->created_at,
+            'updated_at' => $this->updated_at
+        ];
     }
 }

app/Jobs/ScrapingDataJob.php

@@ -0,0 +1,77 @@
+<?php
+
+namespace App\Jobs;
+
+use App\Models\ImportDatasource;
+use App\Services\ServiceGoogleSheet;
+use App\Services\ServicePbgTask;
+use App\Services\ServiceTabPbgTask;
+use App\Services\ServiceTokenSIMBG;
+use GuzzleHttp\Client;
+use Illuminate\Bus\Queueable;
+use Illuminate\Contracts\Queue\ShouldQueue;
+use Illuminate\Foundation\Bus\Dispatchable;
+use Illuminate\Queue\InteractsWithQueue;
+use Illuminate\Queue\SerializesModels;
+use Illuminate\Support\Facades\Log;
+
+class ScrapingDataJob implements ShouldQueue
+{
+    use Dispatchable, InteractsWithQueue, Queueable, SerializesModels;
+
+    /**
+     * Inject dependencies instead of creating them inside.
+     */
+    public function __construct(
+    ) {
+    }
+
+    /**
+     * Execute the job.
+     */
+    public function handle()
+    {
+        try {
+
+            $client = app(Client::class);
+            $service_pbg_task = app(ServicePbgTask::class);
+            $service_tab_pbg_task = app(ServiceTabPbgTask::class);
+            $service_google_sheet = app(ServiceGoogleSheet::class);
+            $service_token = app(ServiceTokenSIMBG::class);
+            // Create a record with "processing" status
+            $import_datasource = ImportDatasource::create([
+                'message' => 'Initiating scraping...',
+                'response_body' => null,
+                'status' => 'processing',
+                'start_time' => now()
+            ]);
+
+            // Run the scraping services
+            $service_google_sheet->run_service();
+            $service_pbg_task->run_service();
+            $service_tab_pbg_task->run_service();
+
+            // Update status to success
+            $import_datasource->update([
+                'status' => 'success',
+                'message' => 'Scraping completed successfully.',
+                'finish_time' => now()
+            ]);
+
+        } catch (\Exception $e) {
+            Log::error('Scraping failed: ' . $e->getMessage(), ['trace' => $e->getTraceAsString()]);
+
+            // Update status to failed
+            if (isset($import_datasource)) {
+                $import_datasource->update([
+                    'status' => 'failed',
+                    'response_body' => 'Error: ' . $e->getMessage(),
+                    'finish_time' => now()
+                ]);
+            }
+
+            // Mark the job as failed
+            $this->fail($e);
+        }
+    }
+}

app/Jobs/SyncronizeSIMBG.php

@@ -2,8 +2,12 @@
 
 namespace App\Jobs;
 
+use App\Models\ImportDatasource;
 use App\Services\GoogleSheetService;
-use App\Services\ServiceSIMBG;
+use App\Services\ServiceGoogleSheet;
+use App\Services\ServicePbgTask;
+use App\Services\ServiceTabPbgTask;
+use GuzzleHttp\Client;
 use Illuminate\Bus\Queueable;
 use Illuminate\Contracts\Queue\ShouldQueue;
 use Illuminate\Foundation\Bus\Dispatchable;
@@ -18,17 +22,58 @@ class SyncronizeSIMBG implements ShouldQueue
 
     public function __construct()
     {
+        // Avoid injecting non-serializable dependencies here
     }
 
     public function handle(): void
     {
+        $import_datasource = ImportDatasource::where('status', 'processing')->first();
+
+        if (!$import_datasource) {
+            $import_datasource = ImportDatasource::create([
+                'message' => 'Initiating scraping...',
+                'response_body' => null,
+                'status' => 'processing'
+            ]);
+        }
         try {
-            $serviceSIMBG = app(ServiceSIMBG::class);
+            // Create an instance of GuzzleHttp\Client inside handle()
-            $serviceSIMBG->syncTaskPBG();
+            $client = new Client();
+
+            // Create instances of services inside handle()
+            $service_pbg_task = app(ServicePbgTask::class);
+            $service_tab_pbg_task = app(ServiceTabPbgTask::class);
+
+            // Create a record with "processing" status
+
+
+            // Run the service
+            $service_google_sheet = new ServiceGoogleSheet();
+            \Log::info('Starting Google Sheet service');
+            $service_google_sheet->run_service();
+            \Log::info('Google Sheet service completed');
+
+            \Log::info('Starting PBG Task service');
+            $service_pbg_task->run_service();
+            \Log::info('PBG Task service completed');
+
+            \Log::info('Starting Tab PBG Task service');
+            $service_tab_pbg_task->run_service();
+            \Log::info('Tab PBG Task service completed');
+
+            // Update the record status to "success" after completion
+            $import_datasource->update([
+                'status' => 'success',
+                'message' => 'Scraping completed successfully.'
+            ]);
         } catch (\Exception $e) {
             \Log::error("SyncronizeSIMBG Job Failed: " . $e->getMessage(), [
                 'exception' => $e,
             ]);
+            $import_datasource->update([
+                'status' => 'failed',
+                'message' => 'Failed job'
+            ]);
             $this->fail($e); // Mark the job as failed
         }
     }

app/Models/ImportDatasource.php

@@ -13,6 +13,8 @@ class ImportDatasource extends Model
         'id',
         'message',
         'response_body',
-        'status'
+        'status',
+        'start_time',
+        'finish_time'
     ];
 }

app/Models/Menu.php

@@ -22,4 +22,7 @@ class Menu extends Model
     public function children(){
         return $this->hasMany(Menu::class,'parent_id');
     }
+    public function parent(){
+        return $this->belongsTo(Menu::class,'parent_id');
+    }
 }

app/Models/User.php

@@ -4,6 +4,7 @@ namespace App\Models;
 
 // use Illuminate\Contracts\Auth\MustVerifyEmail;
 use Illuminate\Database\Eloquent\Factories\HasFactory;
+use Illuminate\Database\Eloquent\SoftDeletes;
 use Illuminate\Foundation\Auth\User as Authenticatable;
 use Illuminate\Notifications\Notifiable;
 use Laravel\Sanctum\HasApiTokens;
@@ -11,7 +12,7 @@ use Laravel\Sanctum\HasApiTokens;
 class User extends Authenticatable
 {
     /** @use HasFactory<\Database\Factories\UserFactory> */
-    use HasFactory, Notifiable, HasApiTokens;
+    use HasFactory, Notifiable, HasApiTokens, SoftDeletes;
 
     /**
      * The attributes that are mass assignable.
@@ -27,6 +28,8 @@ class User extends Authenticatable
         'position'
     ];
 
+    protected $dates = ['deleted_at'];
+
     /**
      * The attributes that should be hidden for serialization.
      *
@@ -50,6 +53,12 @@ class User extends Authenticatable
         ];
     }
 
+    public function delete(){
+        $this->email = $this->email . '_deleted_'. now()->timestamp;
+        $this->save();
+        return parent::delete();
+    }
+
     public function roles(){
         return $this->belongsToMany(Role::class, 'user_role')->withTimestamps();
     }

app/Providers/AppServiceProvider.php

@@ -3,8 +3,13 @@
 namespace App\Providers;
 
 use App\Models\Menu;
+use App\Services\ServiceGoogleSheet;
+use App\Services\ServicePbgTask;
+use App\Services\ServiceTabPbgTask;
+use App\Services\ServiceTokenSIMBG;
 use App\View\Components\Circle;
 use Auth;
+use GuzzleHttp\Client;
 use Illuminate\Support\Facades\Blade;
 use Illuminate\Support\Facades\View;
 use Illuminate\Support\ServiceProvider;
@@ -19,11 +24,24 @@ class AppServiceProvider extends ServiceProvider
      */
     public function register(): void
     {
-        $this->app->singleton(GoogleSheetService::class, function () {
+        $this->app->bind(Client::class, function () {
-            return new GoogleSheetService();
+            return new Client();
         });
-        $this->app->singleton(ServiceSIMBG::class, function ($app) {
+
-            return new ServiceSIMBG($app->make(GoogleSheetService::class));
+        $this->app->bind(ServiceTokenSIMBG::class, function ($app) {
+            return new ServiceTokenSIMBG();
+        });
+
+        $this->app->bind(ServicePbgTask::class, function ($app) {
+            return new ServicePbgTask($app->make(Client::class), $app->make(ServiceTokenSIMBG::class));
+        });
+
+        $this->app->bind(ServiceTabPbgTask::class, function ($app) {
+            return new ServiceTabPbgTask($app->make(Client::class), $app->make(ServiceTokenSIMBG::class));
+        });
+
+        $this->app->bind(ServiceGoogleSheet::class, function ($app) {
+            return new ServiceGoogleSheet();
         });
     }
 

app/Services/ServiceGoogleSheet.php

@@ -0,0 +1,280 @@
+<?php
+
+namespace App\Services;
+use App\Models\DataSetting;
+use App\Models\ImportDatasource;
+use App\Models\PbgTaskGoogleSheet;
+use Carbon\Carbon;
+use Exception;
+use Google_Client;
+use Google_Service_Sheets;
+use Log;
+class ServiceGoogleSheet
+{
+    protected $client;
+    protected $service;
+    protected $spreadsheetID;
+    protected $service_sheets;
+    protected $import_datasource;
+    public function __construct()
+    {
+        $this->client = new Google_Client();
+        $this->client->setApplicationName("Sibedas Google Sheets API");
+        $this->client->setScopes([Google_Service_Sheets::SPREADSHEETS_READONLY]);
+        $this->client->setAuthConfig(storage_path("app/teak-banner-450003-s8-ea05661d9db0.json"));
+        $this->client->setAccessType("offline");
+
+        $this->service = new Google_Service_Sheets($this->client);
+        $this->spreadsheetID = env("SPREAD_SHEET_ID");
+
+        $this->service_sheets = new Google_Service_Sheets($this->client);
+    }
+
+    public function run_service(){
+        try{
+            $this->sync_big_data();
+            $this->sync_google_sheet_data();
+        }catch(Exception $e){
+            throw $e;
+        }
+    }
+    public function sync_google_sheet_data() {
+        try {
+            $sheet_data = $this->get_data_by_sheet(0);
+
+            if (empty($sheet_data) || count($sheet_data) < 2) {
+                Log::warning("sync_google_sheet_data: No valid data found.");
+                throw new \Exception("sync_google_sheet_data: No valid data found.");
+            }
+
+            $cleanValue = function ($value) {
+                return (isset($value) && trim($value) !== '') ? trim($value) : null;
+            };
+
+            $mapUpsert = [];
+            foreach(array_slice($sheet_data, 1) as $row){
+                if(!is_array($row)){
+                    continue;
+                }
+
+                $no_registrasi = $cleanValue($row[2] ?? null);
+
+                // Apply the same logic from your SQL UPDATE
+                if (strpos($no_registrasi, 'PBG-') === 0) {
+                    $format_registrasi = $no_registrasi;
+                } else {
+                    $format_registrasi = sprintf(
+                        "PBG-%s-%s-%s",
+                        substr($no_registrasi, 0, 6) ?: '',
+                        substr($no_registrasi, 7, 8) ?: '',
+                        substr($no_registrasi, -2) ?: ''
+                    );
+                }
+
+                $mapUpsert[] = [
+                    'jenis_konsultasi' => $cleanValue($row[1] ?? null),
+                    'no_registrasi' => $no_registrasi,
+                    'formatted_registration_number' => $format_registrasi,
+                    'nama_pemilik' => $cleanValue($row[3] ?? null),
+                    'lokasi_bg' => $cleanValue($row[4] ?? null),
+                    'fungsi_bg' => $cleanValue($row[5] ?? null),
+                    'nama_bangunan' => $cleanValue($row[6] ?? null),
+                    'tgl_permohonan' => $this->convertToDate($cleanValue($row[7] ?? null)),
+                    'status_verifikasi' => $cleanValue($row[8] ?? null),
+                    'status_permohonan' => $cleanValue($row[9] ?? null),
+                    'alamat_pemilik' => $cleanValue($row[10] ?? null),
+                    'no_hp' => $cleanValue($row[11] ?? null),
+                    'email' => $cleanValue($row[12] ?? null),
+                    'tanggal_catatan' => $this->convertToDate($cleanValue($row[13] ?? null)),
+                    'catatan_kekurangan_dokumen' => $cleanValue($row[14] ?? null),
+                    'gambar' => $cleanValue($row[15] ?? null),
+                    'krk_kkpr' => $cleanValue($row[16] ?? null),
+                    'no_krk' => $cleanValue($row[17] ?? null),
+                    'lh' => $cleanValue($row[18] ?? null),
+                    'ska' => $cleanValue($row[19] ?? null),
+                    'keterangan' => $cleanValue($row[20] ?? null),
+                    'helpdesk' => $cleanValue($row[21] ?? null),
+                    'pj' => $cleanValue($row[22] ?? null),
+                    'kepemilikan' => $cleanValue($row[24] ?? null),
+                    'potensi_taru' => $cleanValue($row[25] ?? null),
+                    'validasi_dinas' => $cleanValue($row[26] ?? null),
+                    'kategori_retribusi' => $cleanValue($row[27] ?? null),
+                    'no_urut_ba_tpt' => $cleanValue($row[28] ?? null),
+                    'tanggal_ba_tpt' => $this->convertToDate($cleanValue($row[29] ?? null)),
+                    'no_urut_ba_tpa' => $cleanValue($row[30] ?? null),
+                    'tanggal_ba_tpa' => $this->convertToDate($cleanValue($row[31] ?? null)),
+                    'no_urut_skrd' => $cleanValue($row[32] ?? null),
+                    'tanggal_skrd' => $this->convertToDate($cleanValue($row[33] ?? null)),
+                    'ptsp' => $cleanValue($row[34] ?? null),
+                    'selesai_terbit' => $cleanValue($row[35] ?? null),
+                    'tanggal_pembayaran' => $cleanValue($row[36] ?? null),
+                    'format_sts' => $cleanValue($row[37] ?? null),
+                    'tahun_terbit' => (int) $cleanValue($row[38] ?? null),
+                    'tahun_berjalan' => (int) $cleanValue($row[39] ?? null),
+                    'kelurahan' => $cleanValue($row[40] ?? null),
+                    'kecamatan' => $cleanValue($row[41] ?? null),
+                    'lb' => $this->convertToDecimal($cleanValue($row[42] ?? 0)),
+                    'tb' => $this->convertToDecimal($cleanValue($row[43] ?? 0)),
+                    'jlb' => (int) $cleanValue($row[44] ?? null),
+                    'unit' => (int) $cleanValue($row[45] ?? null),
+                    'usulan_retribusi' => (int) $cleanValue($row[46] ?? null),
+                    'nilai_retribusi_keseluruhan_simbg' => $this->convertToDecimal($cleanValue($row[47] ?? 0)),
+                    'nilai_retribusi_keseluruhan_pad' => $this->convertToDecimal($cleanValue($row[48] ?? 0)),
+                    'denda' => $this->convertToDecimal($cleanValue($row[49] ?? 0)),
+                    'latitude' => $cleanValue($row[50] ?? null),
+                    'longitude' => $cleanValue($row[51] ?? null),
+                    'nik_nib' => $cleanValue($row[52] ?? null),
+                    'dok_tanah' => $cleanValue($row[53] ?? null),
+                    'temuan' => $cleanValue($row[54] ?? null),
+                    'updated_at' => now()
+                ];
+            }
+
+            // Count occurrences of each no_registrasi
+            $registrasiCounts = array_count_values(array_column($mapUpsert, 'no_registrasi'));
+
+            // Filter duplicates (those appearing more than once)
+            $duplicates = array_filter($registrasiCounts, function ($count) {
+                return $count > 1;
+            });
+
+            if (!empty($duplicates)) {
+                Log::warning("Duplicate no_registrasi found", ['duplicates' => array_keys($duplicates)]);
+            }
+
+            // Remove duplicates before upsert
+            $mapUpsert = collect($mapUpsert)->unique('no_registrasi')->values()->all();
+
+            $batchSize = 1000;
+            $chunks = array_chunk($mapUpsert, $batchSize);
+            foreach ($chunks as $chunk) {
+                PbgTaskGoogleSheet::upsert($chunk, ['no_registrasi']);
+            }
+
+            Log::info("sync google sheet done");
+            return true;
+        } catch (\Exception $e) {
+            Log::error("sync_google_sheet_data failed", ['error' => $e->getMessage()]);
+            throw $e;
+        }
+    }
+
+
+    public function sync_big_data(){
+        try {
+            $sheet_big_data = $this->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"] = $this->convertToInteger($row[2]) ?? null;
+                        $data_setting_result["MENUNGGU_KLIK_DPMPTSP_SUM"] = $this->convertToDecimal($row[3])  ?? null;
+                    } elseif ($found_section === "REALISASI_TERBIT_PBG") {
+                        $data_setting_result["REALISASI_TERBIT_PBG_COUNT"] = $this->convertToInteger($row[2]) ?? null;
+                        $data_setting_result["REALISASI_TERBIT_PBG_SUM"] = $this->convertToDecimal($row[4]) ?? null;
+                    } elseif ($found_section === "PROSES_DINAS_TEKNIS") {
+                        $data_setting_result["PROSES_DINAS_TEKNIS_COUNT"] = $this->convertToInteger($row[2]) ?? null;
+                        $data_setting_result["PROSES_DINAS_TEKNIS_SUM"] = $this->convertToDecimal($row[3]) ?? null;
+                    }
+
+                    // Reset section tracking after capturing "Grand Total"
+                    $found_section = null;
+                }
+            }
+
+            foreach ($data_setting_result as $key => $value) {
+                DataSetting::updateOrInsert(
+                    ["key" => $key], // Find by key
+                    ["value" => $value] // Update or insert value
+                );
+            }
+
+            return true;
+        } catch (\Exception $e) {
+            // **Log error**
+            Log::error("Error syncing Google Sheet data", ['error' => $e->getMessage()]);
+            return false;
+        }
+    }
+
+    private function get_data_by_sheet($no_sheet = 1){
+        $spreadsheet = $this->service->spreadsheets->get($this->spreadsheetID);
+        $sheets = $spreadsheet->getSheets();
+        $sheetTitle = $sheets[$no_sheet]->getProperties()->getTitle();
+        $range = "{$sheetTitle}";
+        $response = $this->service->spreadsheets_values->get($this->spreadsheetID, $range);
+        $values = $response->getValues();
+        return!empty($values)? $values : [];
+    }
+
+    private function convertToInteger($value) {
+        // Check if the value is an empty string, and return null if true
+        if (trim($value) === "") {
+            return null;
+        }
+
+        $cleaned = str_replace('.','', $value);
+
+        // Otherwise, cast to integer
+        return (int) $cleaned;
+    }
+
+    private 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;
+    }
+
+    private 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;
+        }
+    }
+}

app/Services/ServicePbgTask.php

@@ -0,0 +1,173 @@
+<?php
+
+namespace App\Services;
+
+use App\Models\GlobalSetting;
+use App\Models\PbgTask;
+use Carbon\Carbon;
+use GuzzleHttp\Client;
+use Exception;
+use Illuminate\Support\Facades\Log;
+
+class ServicePbgTask
+{
+    private $client;
+    private $simbg_host;
+    private $fetch_per_page;
+    private $pbg_task_url;
+    private $service_token;
+    private $user_token;
+    private $user_refresh_token;
+
+    public function __construct(Client $client, ServiceTokenSIMBG $service_token)
+    {
+        $settings = GlobalSetting::whereIn('key', ['SIMBG_HOST', 'FETCH_PER_PAGE'])
+            ->pluck('value', 'key');
+
+        $this->simbg_host = trim((string) ($settings['SIMBG_HOST'] ?? ""));
+        $this->fetch_per_page = trim((string) ($settings['FETCH_PER_PAGE'] ?? "10"));
+        $this->client = $client;
+        $this->service_token = $service_token;
+        $this->pbg_task_url = "{$this->simbg_host}/api/pbg/v1/list/?page=1&size={$this->fetch_per_page}&sort=ASC";
+        $auth_data = $this->service_token->get_token();
+        $this->user_token = $auth_data['access'];
+        $this->user_refresh_token = $auth_data['refresh'];
+    }
+
+    public function run_service()
+    {
+        try{
+            $this->fetch_pbg_task();
+        }catch(Exception $e){
+            throw $e;
+        }
+    }
+
+    private function fetch_pbg_task()
+    {
+        try {
+            $currentPage = 1;
+            $totalPage = 1;
+
+            $options = [
+                'headers' => [
+                    'Authorization' => "Bearer {$this->user_token}",
+                    'Content-Type' => 'application/json'
+                ]
+            ];
+
+            $maxRetries = 3; // Maximum number of retries
+            $initialDelay = 1; // Initial delay in seconds
+
+            $fetchData = function ($url) use (&$options, $maxRetries, $initialDelay) {
+                $retryCount = 0;
+
+                while ($retryCount < $maxRetries) {
+                    try {
+                        return $this->client->get($url, $options);
+                    } catch (\GuzzleHttp\Exception\ClientException $e) {
+                        if ($e->getCode() === 401) {
+                            Log::warning("Unauthorized. Refreshing token...");
+
+                            // Refresh token
+                            $auth_data = $this->service_token->refresh_token($this->user_refresh_token);
+                            if (!isset($auth_data['access'])) {
+                                Log::error("Token refresh failed.");
+                                throw new Exception("Token refresh failed.");
+                            }
+
+                            // Update tokens
+                            $this->user_token = $auth_data['access'];
+                            $this->user_refresh_token = $auth_data['refresh'];
+
+                            // Update headers
+                            $options['headers']['Authorization'] = "Bearer {$this->user_token}";
+
+                            // Retry request
+                            return $this->client->get($url, $options);
+                        }
+                        throw $e;
+                    } catch (\GuzzleHttp\Exception\ServerException | \GuzzleHttp\Exception\ConnectException $e) {
+                        // Handle 502 or connection issues
+                        if ($e->getCode() === 502) {
+                            Log::warning("502 Bad Gateway - Retrying in {$initialDelay} seconds...");
+                        } else {
+                            Log::error("Network error - Retrying in {$initialDelay} seconds...");
+                        }
+
+                        $retryCount++;
+                        sleep($initialDelay);
+                        $initialDelay *= 2; // Exponential backoff
+                    }
+                }
+
+                Log::error("Max retries reached. Failing request.");
+                throw new Exception("Max retries reached. Failing request.");
+            };
+
+            do {
+                $url = "{$this->simbg_host}/api/pbg/v1/list/?page={$currentPage}&size={$this->fetch_per_page}&sort=ASC";
+
+                $fetch_data = $fetchData($url);
+                if (!$fetch_data) {
+                    Log::error("Failed to fetch data on page {$currentPage} after retries.");
+                    throw new Exception("Failed to fetch data on page {$currentPage} after retries.");
+                }
+
+                $response = json_decode($fetch_data->getBody()->getContents(), true);
+                if (!isset($response['data'])) {
+                    Log::error("Invalid API response on page {$currentPage}");
+                    throw new Exception("Invalid API response on page {$currentPage}");
+                }
+
+                $data = $response['data'];
+                $totalPage = isset($response['total_page']) ? (int) $response['total_page'] : 1;
+
+                $saved_data = [];
+                foreach ($data as $item) {
+                    $saved_data[] = [
+                        'uuid' => $item['uid'] ?? null,
+                        'name' => $item['name'] ?? null,
+                        'owner_name' => $item['owner_name'] ?? null,
+                        'application_type' => $item['application_type'] ?? null,
+                        'application_type_name' => $item['application_type_name'] ?? null,
+                        'condition' => $item['condition'] ?? null,
+                        'registration_number' => $item['registration_number'] ?? null,
+                        'document_number' => $item['document_number'] ?? null,
+                        'address' => $item['address'] ?? null,
+                        'status' => $item['status'] ?? null,
+                        'status_name' => $item['status_name'] ?? null,
+                        'slf_status' => $item['slf_status'] ?? null,
+                        'slf_status_name' => $item['slf_status_name'] ?? null,
+                        'function_type' => $item['function_type'] ?? null,
+                        'consultation_type' => $item['consultation_type'] ?? null,
+                        'due_date' => $item['due_date'] ?? null,
+                        'land_certificate_phase' => $item['land_certificate_phase'] ?? null,
+                        '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(),
+                    ];
+                }
+
+                if (!empty($saved_data)) {
+                    PbgTask::upsert($saved_data, ['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'
+                    ]);
+                }
+
+                Log::info("Page {$currentPage} fetched & saved", ['records' => count($saved_data)]);
+
+                $currentPage++;
+            } while ($currentPage <= $totalPage);
+
+            return true;
+        } catch (Exception $e) {
+            Log::error("Error fetching PBG tasks", ['error' => $e->getMessage()]);
+            throw $e;
+        }
+    }
+
+}

app/Services/ServiceSIMBG.php

@@ -179,60 +179,59 @@ class ServiceSIMBG
             }
             $mapToUpsert = [];
 
-            foreach($sheetData as $data){
+            foreach ($sheetData as $data) {
-                $mapToUpsert[] = 
+                $mapToUpsert[] = [
-                    [
+                    'no_registrasi' => $this->cleanString($data['no__registrasi'] ?? null),
-                        'no_registrasi' => $data['no__registrasi'] ?? null,
+                    'jenis_konsultasi' => $this->cleanString($data['jenis_konsultasi'] ?? null),
-                        'jenis_konsultasi' => $data['jenis_konsultasi'] ?? null,
+                    'fungsi_bg' => $this->cleanString($data['fungsi_bg'] ?? null),
-                        'fungsi_bg' => $data['fungsi_bg'] ?? null,
+                    'tgl_permohonan' => $this->convertToDate($this->cleanString($data['tgl_permohonan'] ?? null)),
-                        'tgl_permohonan' => $this->convertToDate($data['tgl_permohonan']),
+                    'status_verifikasi' => $this->cleanString($data['status_verifikasi'] ?? null),
-                        'status_verifikasi' => $data['status_verifikasi'] ?? null,
+                    'status_permohonan' => $this->convertToDate($this->cleanString($data['status_permohonan'] ?? null)),
-                        'status_permohonan' => $this->convertToDate($data['status_permohonan']),
+                    'alamat_pemilik' => $this->cleanString($data['alamat_pemilik'] ?? null),
-                        'alamat_pemilik' => $data['alamat_pemilik'] ?? null,
+                    'no_hp' => $this->cleanString($data['no__hp'] ?? null),
-                        'no_hp' => $data['no__hp'] ?? null,
+                    'email' => $this->cleanString($data['e_mail'] ?? null),
-                        'email' => $data['e_mail'] ?? null,
+                    'tanggal_catatan' => $this->convertToDate($this->cleanString($data['tanggal_catatan'] ?? null)),
-                        'tanggal_catatan' => $this->convertToDate($data['tanggal_catatan']),
+                    'catatan_kekurangan_dokumen' => $this->cleanString($data['catatan_kekurangan_dokumen'] ?? null),
-                        'catatan_kekurangan_dokumen' => $data['catatan_kekurangan_dokumen'] ?? null,
+                    'gambar' => $this->cleanString($data['gambar'] ?? null),
-                        'gambar' => $data['gambar'] ?? null,
+                    'krk_kkpr' => $this->cleanString($data['krk_kkpr'] ?? null),
-                        'krk_kkpr' => $data['krk_kkpr'] ?? null,
+                    'no_krk' => $this->cleanString($data['no__krk'] ?? null),
-                        'no_krk' => $data['no__krk'] ?? null,
+                    'lh' => $this->cleanString($data['lh'] ?? null),
-                        'lh' => $data['lh'] ?? null,
+                    'ska' => $this->cleanString($data['ska'] ?? null),
-                        'ska' => $data['ska'] ?? null,
+                    'keterangan' => $this->cleanString($data['keterangan'] ?? null),
-                        'keterangan' => $data['keterangan'] ?? null,
+                    'helpdesk' => $this->cleanString($data['helpdesk'] ?? null),
-                        'helpdesk' => $data['helpdesk'] ?? null,
+                    'pj' => $this->cleanString($data['pj'] ?? null),
-                        'pj' => $data['pj'] ?? null,
+                    'kepemilikan' => $this->cleanString($data['kepemilikan'] ?? null),
-                        'kepemilikan' => $data['kepemilikan'] ?? null,
+                    'potensi_taru' => $this->cleanString($data['potensi_taru'] ?? null),
-                        'potensi_taru' => $data['potensi_taru'] ?? null,
+                    'validasi_dinas' => $this->cleanString($data['validasi_dinas'] ?? null),
-                        'validasi_dinas' => $data['validasi_dinas'] ?? null,
+                    'kategori_retribusi' => $this->cleanString($data['kategori_retribusi'] ?? null),
-                        'kategori_retribusi' => $data['kategori_retribusi'] ?? null,
+                    'no_urut_ba_tpt' => $this->cleanString($data['no__urut_ba_tpt__2024_0001_'] ?? null),
-                        'no_urut_ba_tpt' => $data['no__urut_ba_tpt__2024_0001_'] ?? null,
+                    'tanggal_ba_tpt' => $this->convertToDate($this->cleanString($data['tanggal_ba_tpt'] ?? null)),
-                        'tanggal_ba_tpt' => $this->convertToDate($data['tanggal_ba_tpt']),
+                    'no_urut_ba_tpa' => $this->cleanString($data['no__urut_ba_tpa'] ?? null),
-                        'no_urut_ba_tpa' => $data['no__urut_ba_tpa'] ?? null,
+                    'tanggal_ba_tpa' => $this->convertToDate($this->cleanString($data['tanggal_ba_tpa'] ?? null)),
-                        'tanggal_ba_tpa' => $this->convertToDate($data['tanggal_ba_tpa']),
+                    'no_urut_skrd' => $this->cleanString($data['no__urut_skrd__2024_0001_'] ?? null),
-                        'no_urut_skrd' => $data['no__urut_skrd__2024_0001_'] ?? null,
+                    'tanggal_skrd' => $this->convertToDate($this->cleanString($data['tanggal_skrd'] ?? null)),
-                        'tanggal_skrd' => $this->convertToDate($data['tanggal_skrd']),
+                    'ptsp' => $this->cleanString($data['ptsp'] ?? null),
-                        'ptsp' => $data['ptsp'] ?? null,
+                    'selesai_terbit' => $this->cleanString($data['selesai_terbit'] ?? null),
-                        'selesai_terbit' => $data['selesai_terbit'] ?? null,
+                    'tanggal_pembayaran' => $this->convertToDate($this->cleanString($data['tanggal_pembayaran__yyyy_mm_dd_'] ?? null)),
-                        'tanggal_pembayaran' => $this->convertToDate($data['tanggal_pembayaran__yyyy_mm_dd_']),
+                    'format_sts' => $this->cleanString($data['format_sts'] ?? null),
-                        'format_sts' => $data['format_sts'] ?? null,
+                    'tahun_terbit' => (int) ($data['tahun_terbit'] ?? null),
-                        'tahun_terbit' => (int) $data['tahun_terbit'] ?? null,
+                    'tahun_berjalan' => (int) ($data['tahun_berjalan'] ?? null),
-                        'tahun_berjalan' => (int) $data['tahun_berjalan'] ?? null,
+                    'kelurahan' => $this->cleanString($data['kelurahan'] ?? null),
-                        'kelurahan' => $data['kelurahan'] ?? null,
+                    'kecamatan' => $this->cleanString($data['kecamatan'] ?? null),
-                        'kecamatan' => $data['kecamatan'] ?? null,
+                    'lb' => $this->convertToDecimal($data['lb'] ?? null),
-                        'lb' => $this->convertToDecimal($data['lb'])  ?? null,
+                    'tb' => $this->convertToDecimal($data['tb'] ?? null),
-                        'tb' => $this->convertToDecimal($data['tb']) ?? null,
+                    'jlb' => (int) ($data['jlb'] ?? null),
-                        'jlb' => (int) $data['jlb'] ?? null,
+                    'unit' => (int) ($data['unit'] ?? null),
-                        'unit' => (int) $data['unit'] ?? null,
+                    'usulan_retribusi' => (int) ($data['usulan_retribusi'] ?? null),
-                        'usulan_retribusi' => (int) $data['usulan_retribusi'] ?? null,
+                    'nilai_retribusi_keseluruhan_simbg' => $this->convertToDecimal($data['nilai_retribusi_keseluruhan__simbg_'] ?? 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),
-                        'nilai_retribusi_keseluruhan_pad' => $this->convertToDecimal($data['nilai_retribusi_keseluruhan__pad_']) ?? null,
+                    'denda' => $this->convertToDecimal($data['denda'] ?? null),
-                        'denda' => $this->convertToDecimal($data['denda']) ?? null,
+                    'latitude' => $this->cleanString($data['latitude'] ?? null),
-                        'latitude' => $data['latitude'] ?? null,
+                    'longitude' => $this->cleanString($data['longitude'] ?? null),
-                        'longitude' => $data['longitude'] ?? null,
+                    'nik_nib' => $this->cleanString($data['nik_nib'] ?? null),
-                        'nik_nib' => $data['nik_nib'] ?? null,
+                    'dok_tanah' => $this->cleanString($data['dok__tanah'] ?? null),
-                        'dok_tanah' => $data['dok__tanah'] ?? null,
+                    'temuan' => $this->cleanString($data['temuan'] ?? null),
-                        'temuan' => $data['temuan'] ?? null,
+                ];
-                    ];
             }
 
             $batchSize = 1000;
@@ -656,4 +655,9 @@ class ServiceSIMBG
             return null;
         }
     }
+
+    private function cleanString($value)
+    {
+        return isset($value) ? trim(strip_tags($value)) : null;
+    }
 }

app/Services/ServiceTabPbgTask.php

@@ -0,0 +1,408 @@
+<?php
+
+namespace App\Services;
+
+use App\Models\GlobalSetting;
+use App\Models\PbgTask;
+use App\Models\PbgTaskIndexIntegrations;
+use App\Models\PbgTaskPrasarana;
+use App\Models\PbgTaskRetributions;
+use App\Models\TaskAssignment;
+use Carbon\Carbon;
+use GuzzleHttp\Client;
+use Illuminate\Support\Facades\Log;
+class ServiceTabPbgTask
+{
+    private $client;
+    private $simbg_host;
+    private $fetch_per_page;
+    private $service_token;
+    private $user_token;
+    private $user_refresh_token;
+
+    public function __construct(Client $client, ServiceTokenSIMBG $service_token)
+    {
+        $settings = GlobalSetting::whereIn('key', ['SIMBG_HOST', 'FETCH_PER_PAGE'])
+            ->pluck('value', 'key');
+
+        $this->simbg_host = trim((string) ($settings['SIMBG_HOST'] ?? ""));
+        $this->fetch_per_page = trim((string) ($settings['FETCH_PER_PAGE'] ?? "10"));
+        $this->client = $client;
+        $this->service_token = $service_token;
+        $auth_data = $this->service_token->get_token();
+        $this->user_token = $auth_data['access'];
+        $this->user_refresh_token = $auth_data['refresh'];
+    }
+
+    public function run_service()
+    {
+        try {
+            $pbg_tasks = PbgTask::all();
+
+            foreach ($pbg_tasks as $pbg_task) {
+                $this->scraping_task_assignments($pbg_task->uuid);
+                $this->scraping_task_retributions($pbg_task->uuid);
+                $this->scraping_task_integrations($pbg_task->uuid);
+
+                // Process task assignments here if needed
+                Log::info("Successfully fetched for UUID: {$pbg_task->uuid}");
+            }
+        } catch (\Exception $e) {
+            Log::error("Failed to scrape task assignments: " . $e->getMessage());
+            throw $e;
+        }
+    }
+
+    private function scraping_task_assignments($uuid)
+    {
+        $url = "{$this->simbg_host}/api/pbg/v1/list-tim-penilai/{$uuid}/?page=1&size=10";
+        $options = [
+            'headers' => [
+                'Authorization' => "Bearer {$this->user_token}",
+                'Content-Type' => 'application/json'
+            ]
+        ];
+
+        $maxRetries = 3;
+        $initialDelay = 1;
+        $retriedAfter401 = false;
+
+        for ($retryCount = 0; $retryCount < $maxRetries; $retryCount++) {
+            try {
+                $response = $this->client->get($url, $options);
+                $responseData = json_decode($response->getBody()->getContents(), true);
+
+                if (empty($responseData['data']) || !is_array($responseData['data'])) {
+                    return true;
+                }
+
+                $task_assignments = [];
+
+                foreach ($responseData['data'] as $data) {
+                    $task_assignments[] = [
+                        'pbg_task_uid' => $uuid,
+                        'user_id' => $data['user_id'] ?? null,
+                        'name' => $data['name'] ?? null,
+                        'username' => $data['username'] ?? null,
+                        'email' => $data['email'] ?? null,
+                        'phone_number' => $data['phone_number'] ?? null,
+                        'role' => $data['role'] ?? null,
+                        'role_name' => $data['role_name'] ?? null,
+                        'is_active' => $data['is_active'] ?? false,
+                        'file' => !empty($data['file']) ? json_encode($data['file']) : null,
+                        'expertise' => !empty($data['expertise']) ? json_encode($data['expertise']) : null,
+                        'experience' => !empty($data['experience']) ? json_encode($data['experience']) : null,
+                        'is_verif' => $data['is_verif'] ?? false,
+                        'uid' => $data['uid'] ?? null,
+                        'status' => $data['status'] ?? null,
+                        'status_name' => $data['status_name'] ?? null,
+                        'note' => $data['note'] ?? null,
+                        'ta_id' => $data['id'] ?? null,
+                        'created_at' => now(),
+                        'updated_at' => now(),
+                    ];
+                }
+
+                if (!empty($task_assignments)) {
+                    TaskAssignment::upsert(
+                        $task_assignments,
+                        ['uid'],
+                        ['ta_id', 'name', 'username', 'email', 'phone_number', 'role', 'role_name', 'is_active', 'file', 'expertise', 'experience', 'is_verif', 'status', 'status_name', 'note', 'updated_at']
+                    );
+                }
+
+                return $responseData;
+            } catch (\GuzzleHttp\Exception\ClientException $e) {
+                if ($e->getCode() === 401 && !$retriedAfter401) {
+                    Log::warning("401 Unauthorized - Refreshing token and retrying...");
+                    try{
+                        $this->refreshToken();
+                        $options['headers']['Authorization'] = "Bearer {$this->user_token}";
+                        $retriedAfter401 = true;
+                        continue;
+                    }catch(\Exception $refreshError){
+                        Log::error("Token refresh and login failed: " . $refreshError->getMessage());
+                        return false;
+                    }
+                }
+
+                throw $e;
+            } catch (\GuzzleHttp\Exception\ServerException | \GuzzleHttp\Exception\ConnectException $e) {
+                if ($e->getCode() === 502) {
+                    Log::warning("502 Bad Gateway - Retrying in {$initialDelay} seconds...");
+                } else {
+                    Log::error("Network error ({$e->getCode()}) - Retrying in {$initialDelay} seconds...");
+                }
+
+                sleep($initialDelay);
+                $initialDelay *= 2;
+            } catch (\Exception $e) {
+                Log::error("Unexpected error: " . $e->getMessage());
+                throw $e;
+            }
+        }
+
+        Log::error("Failed to fetch task assignments for UUID {$uuid} after {$maxRetries} retries.");
+        throw new \Exception("Failed to fetch task assignments for UUID {$uuid} after retries.");
+    }
+
+    private function scraping_task_retributions($uuid)
+    {
+        $url = "{$this->simbg_host}/api/pbg/v1/detail/" . $uuid . "/retribution/submit/";
+        $options = [
+            'headers' => [
+                'Authorization' => "Bearer {$this->user_token}",
+                'Content-Type' => 'application/json'
+            ]
+        ];
+
+        $maxRetries = 3;
+        $initialDelay = 1;
+        $retriedAfter401 = false;
+
+        for ($retryCount = 0; $retryCount < $maxRetries; $retryCount++) {
+            try {
+                $response = $this->client->get($url, $options);
+                $responseData = json_decode($response->getBody()->getContents(), true, 512, JSON_THROW_ON_ERROR);
+
+                if (empty($responseData['data']) || !is_array($responseData['data'])) {
+                    return true;
+                }
+
+                $data = $responseData['data'];
+
+                $detailCreatedAt = isset($data['created_at']) 
+                    ? Carbon::parse($data['created_at'])->format('Y-m-d H:i:s') 
+                    : null;
+        
+                $detailUpdatedAt = isset($data['updated_at']) 
+                    ? Carbon::parse($data['updated_at'])->format('Y-m-d H:i:s') 
+                    : null;
+        
+                $pbg_task_retributions = PbgTaskRetributions::updateOrCreate(
+                    ['detail_id' => $data['id']],
+                    [
+                        'detail_uid' => $data['uid'] ?? null,
+                        'detail_created_at' => $detailCreatedAt ?? null,
+                        'detail_updated_at' => $detailUpdatedAt ?? null,
+                        'luas_bangunan' => $data['luas_bangunan'] ?? null,
+                        'indeks_lokalitas' => $data['indeks_lokalitas'] ?? null,
+                        'wilayah_shst' => $data['wilayah_shst'] ?? null,
+                        'kegiatan_id' => $data['kegiatan']['id'] ?? null,
+                        'kegiatan_name' => $data['kegiatan']['name'] ?? null,
+                        'nilai_shst' => $data['nilai_shst'] ?? null,
+                        'indeks_terintegrasi' => $data['indeks_terintegrasi'] ?? null,
+                        'indeks_bg_terbangun' => $data['indeks_bg_terbangun'] ?? null,
+                        'nilai_retribusi_bangunan' => $data['nilai_retribusi_bangunan'] ?? null,
+                        'nilai_prasarana' => $data['nilai_prasarana'] ?? null,
+                        'created_by' => $data['created_by'] ?? null,
+                        'pbg_document' => $data['pbg_document'] ?? null,
+                        'underpayment' => $data['underpayment'] ?? null,
+                        'skrd_amount' => $data['skrd_amount'] ?? null,
+                        'pbg_task_uid' => $uuid,
+                    ]
+                );
+        
+                $pbg_task_retribution_id = $pbg_task_retributions->id;
+        
+                $prasaranaData = $data['prasarana'] ?? [];
+                if (!empty($prasaranaData)) {
+                    $insertData = array_map(fn($item) => [
+                        'pbg_task_uid' => $uuid,
+                        'pbg_task_retribution_id' => $pbg_task_retribution_id,
+                        'prasarana_id' => $item['id'] ?? null,
+                        'prasarana_type' => $item['prasarana_type'] ?? null,
+                        'building_type' => $item['building_type'] ?? null,
+                        'total' => $item['total'] ?? null,
+                        'quantity' => $item['quantity'] ?? null,
+                        'unit' => $item['unit'] ?? null,
+                        'index_prasarana' => $item['index_prasarana'] ?? null,
+                    ], $prasaranaData);
+            
+                    PbgTaskPrasarana::upsert($insertData, ['prasarana_id']);
+                }
+
+                return $responseData;
+            } catch (\GuzzleHttp\Exception\ClientException $e) {
+                if ($e->getCode() === 401 && !$retriedAfter401) {
+                    Log::warning("401 Unauthorized - Refreshing token and retrying...");
+                    try{
+                        $this->refreshToken();
+                        $options['headers']['Authorization'] = "Bearer {$this->user_token}";
+                        $retriedAfter401 = true;
+                        continue;
+                    }catch(\Exception $refreshError){
+                        Log::error("Token refresh and login failed: " . $refreshError->getMessage());
+                        return false;
+                    }
+                }
+
+                return false;
+            } catch (\GuzzleHttp\Exception\ServerException | \GuzzleHttp\Exception\ConnectException $e) {
+                if ($e->getCode() === 502) {
+                    Log::warning("502 Bad Gateway - Retrying in {$initialDelay} seconds...");
+                } else {
+                    Log::error("Network error ({$e->getCode()}) - Retrying in {$initialDelay} seconds...");
+                }
+
+                sleep($initialDelay);
+                $initialDelay *= 2;
+            } catch (\GuzzleHttp\Exception\RequestException $e) {
+                Log::error("Request error ({$e->getCode()}): " . $e->getMessage());
+                return false;
+            } catch (\JsonException $e) {
+                Log::error("JSON decoding error: " . $e->getMessage());
+                return false;
+            } catch (\Throwable $e) {
+                Log::critical("Unhandled error: " . $e->getMessage(), ['trace' => $e->getTraceAsString()]);
+                return false;
+            }
+        }
+
+        Log::error("Failed to fetch task retributions for UUID {$uuid} after retries.");
+        throw new \Exception("Failed to fetch task retributions for UUID {$uuid} after retries.");
+    }
+
+    private function scraping_task_integrations($uuid){
+        $url = "{$this->simbg_host}/api/pbg/v1/detail/" . $uuid . "/retribution/indeks-terintegrasi/";
+        $options = [
+            'headers' => [
+                'Authorization' => "Bearer {$this->user_token}",
+                'Content-Type' => 'application/json'
+            ]
+        ];
+        $maxRetries = 3;
+        $initialDelay = 1;
+        $retriedAfter401 = false;
+        for ($retryCount = 0; $retryCount < $maxRetries; $retryCount++) {
+            try {
+                $response = $this->client->get($url, $options);
+                $responseData = json_decode($response->getBody()->getContents(), true, 512, JSON_THROW_ON_ERROR);
+
+                if (empty($responseData['data']) || !is_array($responseData['data'])) {
+                    return true;
+                }
+
+                $data = $responseData['data'];
+
+                $integrations[] = [
+                    'pbg_task_uid' => $uuid,
+                    'indeks_fungsi_bangunan' => $data['indeks_fungsi_bangunan'] ?? null,
+                    'indeks_parameter_kompleksitas' => $data['indeks_parameter_kompleksitas'] ?? null,
+                    'indeks_parameter_permanensi' => $data['indeks_parameter_permanensi'] ?? null,
+                    'indeks_parameter_ketinggian' => $data['indeks_parameter_ketinggian'] ?? null,
+                    'faktor_kepemilikan' => $data['faktor_kepemilikan'] ?? null,
+                    'indeks_terintegrasi' => $data['indeks_terintegrasi'] ?? null,
+                    'total' => $data['total'] ?? null,
+                ];
+
+                if (!empty($integrations)) {
+                    PbgTaskIndexIntegrations::upsert($integrations, ['pbg_task_uid'], ['indeks_fungsi_bangunan', 
+                    'indeks_parameter_kompleksitas', 'indeks_parameter_permanensi', 'indeks_parameter_ketinggian', 'faktor_kepemilikan', 'indeks_terintegrasi', 'total']);
+                }
+
+                return $responseData;
+            } catch (\GuzzleHttp\Exception\ClientException $e) {
+                if ($e->getCode() === 401 && !$retriedAfter401) {
+                    Log::warning("401 Unauthorized - Refreshing token and retrying...");
+                    try{
+                        $this->refreshToken();
+                        $options['headers']['Authorization'] = "Bearer {$this->user_token}";
+                        $retriedAfter401 = true;
+                        continue;
+                    }catch(\Exception $refreshError){
+                        Log::error("Token refresh and login failed: " . $refreshError->getMessage());
+                        return false;
+                    }
+                }
+
+                return false;
+            } catch (\GuzzleHttp\Exception\ServerException | \GuzzleHttp\Exception\ConnectException $e) {
+                if ($e->getCode() === 502) {
+                    Log::warning("502 Bad Gateway - Retrying in {$initialDelay} seconds...");
+                } else {
+                    Log::error("Network error ({$e->getCode()}) - Retrying in {$initialDelay} seconds...");
+                }
+
+                sleep($initialDelay);
+                $initialDelay *= 2;
+            } catch (\GuzzleHttp\Exception\RequestException $e) {
+                Log::error("Request error ({$e->getCode()}): " . $e->getMessage());
+                return false;
+            } catch (\JsonException $e) {
+                Log::error("JSON decoding error: " . $e->getMessage());
+                return false;
+            } catch (\Throwable $e) {
+                Log::critical("Unhandled error: " . $e->getMessage(), ['trace' => $e->getTraceAsString()]);
+                return false;
+            }
+        }
+
+        Log::error("Failed to fetch task index integration for UUID {$uuid} after retries.");
+        throw new \Exception("Failed to fetch task index integration for UUID {$uuid} after retries.");
+    }
+
+    private function refreshToken()
+    {
+        $maxRetries = 3; // Maximum retry attempts
+        $attempt = 0; 
+
+        while ($attempt < $maxRetries) {
+            try {
+                $attempt++;
+                Log::info("Attempt $attempt: Refreshing token...");
+
+                $newAuthToken = $this->service_token->refresh_token($this->user_refresh_token);
+
+                if (!isset($newAuthToken['access']) || !isset($newAuthToken['refresh'])) {
+                    throw new \Exception("Invalid refresh token response.");
+                }
+
+                $this->user_token = $newAuthToken['access'];
+                $this->user_refresh_token = $newAuthToken['refresh'];
+
+                Log::info("Token refreshed successfully on attempt $attempt.");
+                return; // Exit function on success
+            } catch (\Exception $e) {
+                Log::error("Token refresh failed on attempt $attempt: " . $e->getMessage());
+
+                if ($attempt >= $maxRetries) {
+                    Log::info("Max retries reached. Attempting to log in again...");
+                    break;
+                }
+
+                sleep(30); // Wait for 30 seconds before retrying
+            }
+        }
+
+        // If refresh fails after retries, attempt re-login
+        $attempt = 0;
+        while ($attempt < $maxRetries) {
+            try {
+                $attempt++;
+                Log::info("Attempt $attempt: Re-logging in...");
+
+                $loginAgain = $this->service_token->get_token(); // Login again
+
+                if (!isset($loginAgain['access']) || !isset($loginAgain['refresh'])) {
+                    throw new \Exception("Invalid login response.");
+                }
+
+                $this->user_token = $loginAgain['access'];
+                $this->user_refresh_token = $loginAgain['refresh'];
+
+                Log::info("Re-login successful on attempt $attempt.");
+                return; // Exit function on success
+            } catch (\Exception $e) {
+                Log::error("Re-login failed on attempt $attempt: " . $e->getMessage());
+
+                if ($attempt >= $maxRetries) {
+                    throw new \Exception("Both token refresh and login failed after $maxRetries attempts. " . $e->getMessage());
+                }
+
+                sleep(30); // Wait for 30 seconds before retrying
+            }
+        }
+    }
+
+}

app/Services/ServiceTokenSIMBG.php

@@ -0,0 +1,79 @@
+<?php
+
+namespace App\Services;
+use App\Models\GlobalSetting;
+use GuzzleHttp\Client;
+use GuzzleHttp\Exception\RequestException;
+use Illuminate\Support\Facades\Log;
+class ServiceTokenSIMBG
+{
+    private $client;
+    private $login_url;
+    private $email;
+    private $password;
+    private $simbg_host;
+    private $fetch_per_page;
+    private $refresh_url;
+
+    public function __construct()
+    {
+        $settings = GlobalSetting::whereIn('key', [
+            'SIMBG_EMAIL', 'SIMBG_PASSWORD', 'SIMBG_HOST', 'FETCH_PER_PAGE'
+        ])->pluck('value', 'key');
+        $this->email = trim((string) ($settings['SIMBG_EMAIL'] ?? ""));
+        $this->password = trim((string) ($settings['SIMBG_PASSWORD'] ?? ""));
+        $this->simbg_host = trim((string) ($settings['SIMBG_HOST'] ?? ""));
+        $this->fetch_per_page = trim((string) ($settings['FETCH_PER_PAGE'] ?? ""));
+        $this->client = new Client();
+        $this->login_url = $this->simbg_host . "/api/user/v1/auth/login/";
+        $this->refresh_url = $this->simbg_host. "/api/user/v1/auth/token/refresh/";
+    }
+
+    public function get_token(){
+        try {
+            $response = $this->client->request('POST', $this->login_url, [
+                'headers' => [
+                    'Content-Type' => 'application/json',
+                    'Accept' => 'application/json',
+                ],
+                'json' => [
+                    'email' => $this->email,
+                    'password' => $this->password
+                ]
+            ]);
+
+            $data = json_decode($response->getBody()->getContents(), true);
+
+            return $data['token'];
+        } catch (RequestException $e) {
+            Log::error("Failed to get token", [
+                'error' => $e->getMessage(),
+                'response' => $e->getResponse() ? $e->getResponse()->getBody()->getContents() : null
+            ]);
+            return null;
+        }
+    }
+
+    public function refresh_token(string $refresh_token){
+        try {
+            $response = $this->client->request('POST', $this->refresh_url, [
+                'headers' => [
+                    'Content-Type' => 'application/json',
+                    'Accept' => 'application/json',
+                ],
+                'json' => [
+                    'refresh' => $refresh_token
+                ]
+            ]);
+
+            $data = json_decode($response->getBody()->getContents(), true);
+
+            return $data;
+        } catch (\Throwable $th) {
+            Log::error("Failed to refresh token", [
+                'error' => $th->getMessage()
+            ]);
+            return null;
+        }
+    }
+}

composer.json

@@ -10,6 +10,7 @@
     "license": "MIT",
     "require": {
         "php": "^8.2",
+        "barryvdh/laravel-dompdf": "^3.1",
         "google/apiclient": "^2.12",
         "guzzlehttp/guzzle": "^7.9",
         "laravel/framework": "^11.31",

composer.lock

@@ -4,8 +4,85 @@
         "Read more about it at https://getcomposer.org/doc/01-basic-usage.md#installing-dependencies",
         "This file is @generated automatically"
     ],
-    "content-hash": "41bb51871a746904ab745e4095db8b46",
+    "content-hash": "e657a4f0a463fa048a0110c08babba93",
     "packages": [
+        {
+            "name": "barryvdh/laravel-dompdf",
+            "version": "v3.1.1",
+            "source": {
+                "type": "git",
+                "url": "https://github.com/barryvdh/laravel-dompdf.git",
+                "reference": "8e71b99fc53bb8eb77f316c3c452dd74ab7cb25d"
+            },
+            "dist": {
+                "type": "zip",
+                "url": "https://api.github.com/repos/barryvdh/laravel-dompdf/zipball/8e71b99fc53bb8eb77f316c3c452dd74ab7cb25d",
+                "reference": "8e71b99fc53bb8eb77f316c3c452dd74ab7cb25d",
+                "shasum": ""
+            },
+            "require": {
+                "dompdf/dompdf": "^3.0",
+                "illuminate/support": "^9|^10|^11|^12",
+                "php": "^8.1"
+            },
+            "require-dev": {
+                "larastan/larastan": "^2.7|^3.0",
+                "orchestra/testbench": "^7|^8|^9|^10",
+                "phpro/grumphp": "^2.5",
+                "squizlabs/php_codesniffer": "^3.5"
+            },
+            "type": "library",
+            "extra": {
+                "laravel": {
+                    "aliases": {
+                        "PDF": "Barryvdh\\DomPDF\\Facade\\Pdf",
+                        "Pdf": "Barryvdh\\DomPDF\\Facade\\Pdf"
+                    },
+                    "providers": [
+                        "Barryvdh\\DomPDF\\ServiceProvider"
+                    ]
+                },
+                "branch-alias": {
+                    "dev-master": "3.0-dev"
+                }
+            },
+            "autoload": {
+                "psr-4": {
+                    "Barryvdh\\DomPDF\\": "src"
+                }
+            },
+            "notification-url": "https://packagist.org/downloads/",
+            "license": [
+                "MIT"
+            ],
+            "authors": [
+                {
+                    "name": "Barry vd. Heuvel",
+                    "email": "barryvdh@gmail.com"
+                }
+            ],
+            "description": "A DOMPDF Wrapper for Laravel",
+            "keywords": [
+                "dompdf",
+                "laravel",
+                "pdf"
+            ],
+            "support": {
+                "issues": "https://github.com/barryvdh/laravel-dompdf/issues",
+                "source": "https://github.com/barryvdh/laravel-dompdf/tree/v3.1.1"
+            },
+            "funding": [
+                {
+                    "url": "https://fruitcake.nl",
+                    "type": "custom"
+                },
+                {
+                    "url": "https://github.com/barryvdh",
+                    "type": "github"
+                }
+            ],
+            "time": "2025-02-13T15:07:54+00:00"
+        },
         {
             "name": "brick/math",
             "version": "0.12.1",
@@ -538,6 +615,161 @@
             ],
             "time": "2024-02-05T11:56:58+00:00"
         },
+        {
+            "name": "dompdf/dompdf",
+            "version": "v3.1.0",
+            "source": {
+                "type": "git",
+                "url": "https://github.com/dompdf/dompdf.git",
+                "reference": "a51bd7a063a65499446919286fb18b518177155a"
+            },
+            "dist": {
+                "type": "zip",
+                "url": "https://api.github.com/repos/dompdf/dompdf/zipball/a51bd7a063a65499446919286fb18b518177155a",
+                "reference": "a51bd7a063a65499446919286fb18b518177155a",
+                "shasum": ""
+            },
+            "require": {
+                "dompdf/php-font-lib": "^1.0.0",
+                "dompdf/php-svg-lib": "^1.0.0",
+                "ext-dom": "*",
+                "ext-mbstring": "*",
+                "masterminds/html5": "^2.0",
+                "php": "^7.1 || ^8.0"
+            },
+            "require-dev": {
+                "ext-gd": "*",
+                "ext-json": "*",
+                "ext-zip": "*",
+                "mockery/mockery": "^1.3",
+                "phpunit/phpunit": "^7.5 || ^8 || ^9 || ^10 || ^11",
+                "squizlabs/php_codesniffer": "^3.5",
+                "symfony/process": "^4.4 || ^5.4 || ^6.2 || ^7.0"
+            },
+            "suggest": {
+                "ext-gd": "Needed to process images",
+                "ext-gmagick": "Improves image processing performance",
+                "ext-imagick": "Improves image processing performance",
+                "ext-zlib": "Needed for pdf stream compression"
+            },
+            "type": "library",
+            "autoload": {
+                "psr-4": {
+                    "Dompdf\\": "src/"
+                },
+                "classmap": [
+                    "lib/"
+                ]
+            },
+            "notification-url": "https://packagist.org/downloads/",
+            "license": [
+                "LGPL-2.1"
+            ],
+            "authors": [
+                {
+                    "name": "The Dompdf Community",
+                    "homepage": "https://github.com/dompdf/dompdf/blob/master/AUTHORS.md"
+                }
+            ],
+            "description": "DOMPDF is a CSS 2.1 compliant HTML to PDF converter",
+            "homepage": "https://github.com/dompdf/dompdf",
+            "support": {
+                "issues": "https://github.com/dompdf/dompdf/issues",
+                "source": "https://github.com/dompdf/dompdf/tree/v3.1.0"
+            },
+            "time": "2025-01-15T14:09:04+00:00"
+        },
+        {
+            "name": "dompdf/php-font-lib",
+            "version": "1.0.1",
+            "source": {
+                "type": "git",
+                "url": "https://github.com/dompdf/php-font-lib.git",
+                "reference": "6137b7d4232b7f16c882c75e4ca3991dbcf6fe2d"
+            },
+            "dist": {
+                "type": "zip",
+                "url": "https://api.github.com/repos/dompdf/php-font-lib/zipball/6137b7d4232b7f16c882c75e4ca3991dbcf6fe2d",
+                "reference": "6137b7d4232b7f16c882c75e4ca3991dbcf6fe2d",
+                "shasum": ""
+            },
+            "require": {
+                "ext-mbstring": "*",
+                "php": "^7.1 || ^8.0"
+            },
+            "require-dev": {
+                "symfony/phpunit-bridge": "^3 || ^4 || ^5 || ^6"
+            },
+            "type": "library",
+            "autoload": {
+                "psr-4": {
+                    "FontLib\\": "src/FontLib"
+                }
+            },
+            "notification-url": "https://packagist.org/downloads/",
+            "license": [
+                "LGPL-2.1-or-later"
+            ],
+            "authors": [
+                {
+                    "name": "The FontLib Community",
+                    "homepage": "https://github.com/dompdf/php-font-lib/blob/master/AUTHORS.md"
+                }
+            ],
+            "description": "A library to read, parse, export and make subsets of different types of font files.",
+            "homepage": "https://github.com/dompdf/php-font-lib",
+            "support": {
+                "issues": "https://github.com/dompdf/php-font-lib/issues",
+                "source": "https://github.com/dompdf/php-font-lib/tree/1.0.1"
+            },
+            "time": "2024-12-02T14:37:59+00:00"
+        },
+        {
+            "name": "dompdf/php-svg-lib",
+            "version": "1.0.0",
+            "source": {
+                "type": "git",
+                "url": "https://github.com/dompdf/php-svg-lib.git",
+                "reference": "eb045e518185298eb6ff8d80d0d0c6b17aecd9af"
+            },
+            "dist": {
+                "type": "zip",
+                "url": "https://api.github.com/repos/dompdf/php-svg-lib/zipball/eb045e518185298eb6ff8d80d0d0c6b17aecd9af",
+                "reference": "eb045e518185298eb6ff8d80d0d0c6b17aecd9af",
+                "shasum": ""
+            },
+            "require": {
+                "ext-mbstring": "*",
+                "php": "^7.1 || ^8.0",
+                "sabberworm/php-css-parser": "^8.4"
+            },
+            "require-dev": {
+                "phpunit/phpunit": "^7.5 || ^8.5 || ^9.5"
+            },
+            "type": "library",
+            "autoload": {
+                "psr-4": {
+                    "Svg\\": "src/Svg"
+                }
+            },
+            "notification-url": "https://packagist.org/downloads/",
+            "license": [
+                "LGPL-3.0-or-later"
+            ],
+            "authors": [
+                {
+                    "name": "The SvgLib Community",
+                    "homepage": "https://github.com/dompdf/php-svg-lib/blob/master/AUTHORS.md"
+                }
+            ],
+            "description": "A library to read, parse and export to PDF SVG files.",
+            "homepage": "https://github.com/dompdf/php-svg-lib",
+            "support": {
+                "issues": "https://github.com/dompdf/php-svg-lib/issues",
+                "source": "https://github.com/dompdf/php-svg-lib/tree/1.0.0"
+            },
+            "time": "2024-04-29T13:26:35+00:00"
+        },
         {
             "name": "dragonmantank/cron-expression",
             "version": "v3.4.0",
@@ -2794,6 +3026,73 @@
             },
             "time": "2022-12-02T22:17:43+00:00"
         },
+        {
+            "name": "masterminds/html5",
+            "version": "2.9.0",
+            "source": {
+                "type": "git",
+                "url": "https://github.com/Masterminds/html5-php.git",
+                "reference": "f5ac2c0b0a2eefca70b2ce32a5809992227e75a6"
+            },
+            "dist": {
+                "type": "zip",
+                "url": "https://api.github.com/repos/Masterminds/html5-php/zipball/f5ac2c0b0a2eefca70b2ce32a5809992227e75a6",
+                "reference": "f5ac2c0b0a2eefca70b2ce32a5809992227e75a6",
+                "shasum": ""
+            },
+            "require": {
+                "ext-dom": "*",
+                "php": ">=5.3.0"
+            },
+            "require-dev": {
+                "phpunit/phpunit": "^4.8.35 || ^5.7.21 || ^6 || ^7 || ^8 || ^9"
+            },
+            "type": "library",
+            "extra": {
+                "branch-alias": {
+                    "dev-master": "2.7-dev"
+                }
+            },
+            "autoload": {
+                "psr-4": {
+                    "Masterminds\\": "src"
+                }
+            },
+            "notification-url": "https://packagist.org/downloads/",
+            "license": [
+                "MIT"
+            ],
+            "authors": [
+                {
+                    "name": "Matt Butcher",
+                    "email": "technosophos@gmail.com"
+                },
+                {
+                    "name": "Matt Farina",
+                    "email": "matt@mattfarina.com"
+                },
+                {
+                    "name": "Asmir Mustafic",
+                    "email": "goetas@gmail.com"
+                }
+            ],
+            "description": "An HTML5 parser and serializer.",
+            "homepage": "http://masterminds.github.io/html5-php",
+            "keywords": [
+                "HTML5",
+                "dom",
+                "html",
+                "parser",
+                "querypath",
+                "serializer",
+                "xml"
+            ],
+            "support": {
+                "issues": "https://github.com/Masterminds/html5-php/issues",
+                "source": "https://github.com/Masterminds/html5-php/tree/2.9.0"
+            },
+            "time": "2024-03-31T07:05:07+00:00"
+        },
         {
             "name": "monolog/monolog",
             "version": "3.8.1",
@@ -4695,6 +4994,71 @@
             ],
             "time": "2024-04-27T21:32:50+00:00"
         },
+        {
+            "name": "sabberworm/php-css-parser",
+            "version": "v8.7.0",
+            "source": {
+                "type": "git",
+                "url": "https://github.com/MyIntervals/PHP-CSS-Parser.git",
+                "reference": "f414ff953002a9b18e3a116f5e462c56f21237cf"
+            },
+            "dist": {
+                "type": "zip",
+                "url": "https://api.github.com/repos/MyIntervals/PHP-CSS-Parser/zipball/f414ff953002a9b18e3a116f5e462c56f21237cf",
+                "reference": "f414ff953002a9b18e3a116f5e462c56f21237cf",
+                "shasum": ""
+            },
+            "require": {
+                "ext-iconv": "*",
+                "php": "^5.6.20 || ^7.0.0 || ~8.0.0 || ~8.1.0 || ~8.2.0 || ~8.3.0 || ~8.4.0"
+            },
+            "require-dev": {
+                "phpunit/phpunit": "5.7.27 || 6.5.14 || 7.5.20 || 8.5.40"
+            },
+            "suggest": {
+                "ext-mbstring": "for parsing UTF-8 CSS"
+            },
+            "type": "library",
+            "extra": {
+                "branch-alias": {
+                    "dev-main": "9.0.x-dev"
+                }
+            },
+            "autoload": {
+                "psr-4": {
+                    "Sabberworm\\CSS\\": "src/"
+                }
+            },
+            "notification-url": "https://packagist.org/downloads/",
+            "license": [
+                "MIT"
+            ],
+            "authors": [
+                {
+                    "name": "Raphael Schweikert"
+                },
+                {
+                    "name": "Oliver Klee",
+                    "email": "github@oliverklee.de"
+                },
+                {
+                    "name": "Jake Hotson",
+                    "email": "jake.github@qzdesign.co.uk"
+                }
+            ],
+            "description": "Parser for CSS Files written in PHP",
+            "homepage": "https://www.sabberworm.com/blog/2010/6/10/php-css-parser",
+            "keywords": [
+                "css",
+                "parser",
+                "stylesheet"
+            ],
+            "support": {
+                "issues": "https://github.com/MyIntervals/PHP-CSS-Parser/issues",
+                "source": "https://github.com/MyIntervals/PHP-CSS-Parser/tree/v8.7.0"
+            },
+            "time": "2024-10-27T17:38:32+00:00"
+        },
         {
             "name": "symfony/clock",
             "version": "v7.2.0",
@@ -9474,12 +9838,12 @@
     ],
     "aliases": [],
     "minimum-stability": "stable",
-    "stability-flags": {},
+    "stability-flags": [],
     "prefer-stable": true,
     "prefer-lowest": false,
     "platform": {
         "php": "^8.2"
     },
-    "platform-dev": {},
+    "platform-dev": [],
     "plugin-api-version": "2.6.0"
 }

database/migrations/2025_03_17_174508_modify_email_on_task_assignments.php

@@ -0,0 +1,40 @@
+<?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('task_assignments', function (Blueprint $table) {
+            $indexes = DB::select("SHOW INDEXES FROM task_assignments WHERE Key_name = 'task_assignments_email_unique'");
+
+            if (!empty($indexes)) {
+                $table->dropUnique('task_assignments_email_unique');
+            }
+
+            $indexes = DB::select("SHOW INDEXES FROM task_assignments WHERE Key_name = 'task_assignments_username_unique'");
+
+            if (!empty($indexes)) {
+                $table->dropUnique('task_assignments_username_unique');
+            }
+            $table->string('email')->nullable()->change();
+            $table->string('username')->nullable()->change();
+        });
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        Schema::table('task_assignments', function (Blueprint $table) {
+            //
+        });
+    }
+};

database/migrations/2025_03_19_133310_add_soft_deletes_to_users_table.php

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

database/migrations/2025_03_21_162343_add_duration_in_import_datasources.php

@@ -0,0 +1,29 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+return new class extends Migration
+{
+    /**
+     * Run the migrations.
+     */
+    public function up(): void
+    {
+        Schema::table('import_datasources', function (Blueprint $table) {
+            $table->timestamp('start_time')->nullable();
+            $table->timestamp('finish_time')->nullable();
+        });
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        Schema::table('import_datasources', function (Blueprint $table) {
+            $table->dropColumn(['start_time', 'finish_time']);
+        });
+    }
+};

database/seeders/DatabaseSeeder.php

@@ -15,17 +15,23 @@ class DatabaseSeeder extends Seeder
      */
     public function run(): void
     {
-        // User::factory(10)->create();
+        User::updateOrCreate(
+            ['email' => 'user@demo.com'], // Kondisi pencarian
+            [
+                'name' => 'Darkone',
+                'email_verified_at' => now(),
+                'password' => Hash::make('password'),
+                'firstname' => 'John',
+                'lastname' => 'Doe',
+                'position' => 'crusial',
+                'remember_token' => Str::random(10),
+            ]
+        );
 
-        User::factory()->create([
+        $this->call([
-            'name' => 'Darkone',
+            RoleSeeder::class,
-            'email' => 'user@demo.com',
+            MenuSeeder::class,
-            'email_verified_at' => now(),
+            UsersRoleMenuSeeder::class
-            'password' => Hash::make('password'),
-            'firstname' => 'John',
-            'lastname' => 'Doe',
-            'position' => 'crusial',
-            'remember_token' => Str::random(10),
         ]);
     }
 }

database/seeders/MenuSeeder.php

@@ -0,0 +1,287 @@
+<?php
+
+namespace Database\Seeders;
+
+use Illuminate\Database\Console\Seeds\WithoutModelEvents;
+use Illuminate\Database\Seeder;
+use App\Models\Menu;
+use Illuminate\Support\Arr;
+
+class MenuSeeder extends Seeder
+{
+    /**
+     * Run the database seeds.
+     */
+    public function run(): void
+    {
+                $menus = [
+            [
+                "name" => "Dashboard",
+                "url" => "/dashboard",
+                "icon" => "mingcute:home-3-line",
+                "parent_id" => null,
+                "sort_order" => 1,
+                "children" => [
+                    [
+                        "name" => "Dashboard Pimpinan",
+                        "url" => "dashboard.home",
+                        "icon" => null,
+                        "sort_order" => 1,
+                    ],
+                    [
+                        "name" => "Dashboard PBG",
+                        "url" => "dashboard.pbg",
+                        "icon" => null,
+                        "sort_order" => 2,
+                    ],
+                    [
+                        "name" => "Dashboard Potensi",
+                        "url" => '/potentials',
+                        "icon" => null,
+                        "sort_order" => 3,
+                        "children" => [
+                            [
+                                "name" => "Luar Sistem",
+                                "url" => "dashboard.potentials.inside_system",
+                                "icon" => null,
+                                "sort_order" => 1,
+                            ],
+                            [
+                                "name" => "Dalam Sistem",
+                                "url" => "dashboard.potentials.outside_system",
+                                "icon" => null,
+                                "sort_order" => 2,
+                            ],
+                        ]
+                    ],
+                    [
+                        "name" => "PETA",
+                        "url" => "dashboard.maps",
+                        "icon" => null,
+                        "sort_order" => 4,
+                    ],
+                ],
+            ],
+            [
+                "name" => "Master",
+                "url" => "/master",
+                "icon" => "mingcute:cylinder-line",
+                "parent_id" => null,
+                "sort_order" => 2,
+                "children" => [
+                    [
+                        "name" => "Users",
+                        "url" => "users.index",
+                        "icon" => null,
+                        "sort_order" => 1,
+                    ],
+                ]
+            ],
+            [
+                "name" => "Settings",
+                "url" => "/settings",
+                "icon" => "mingcute:settings-6-line",
+                "parent_id" => null,
+                "sort_order" => 3,
+                "children" => [
+                    [
+                        "name" => "Syncronize",
+                        "url" => "settings.syncronize",
+                        "icon" => null,
+                        "sort_order" => 1,
+                    ],
+                    [
+                        "name" => "Menu",
+                        "url" => "menus.index",
+                        "icon" => null,
+                        "sort_order" => 2,
+                    ],
+                    [
+                        "name" => "Role",
+                        "url" => "roles.index",
+                        "icon" => null,
+                        "sort_order" => 3,
+                    ],
+                ]
+            ],
+            [
+                "name" => "Data Settings",
+                "url" => "/data-settings",
+                "icon" => "mingcute:settings-1-line",
+                "parent_id" => null,
+                "sort_order" => 4,
+                "children" => [
+                    [
+                        "name" => "Setting Dashboard",
+                        "url" => "data-settings.index",
+                        "icon" => null,
+                        "sort_order" => 1,
+                    ],
+                ]
+            ],
+            [
+                "name" => "Data",
+                "url" => "/data",
+                "icon" => "mingcute:task-line",
+                "parent_id" => null,
+                "sort_order" => 5,
+                "children" => [
+                    [
+                        "name" => "PBG",
+                        "url" => "pbg-task.index",
+                        "icon" => null,
+                        "sort_order" => 1,
+                    ],
+                    [
+                        "name" => "Reklame",
+                        "url" => "web-advertisements.index",
+                        "icon" => null,
+                        "sort_order" => 2,
+                    ],
+                    [
+                        "name" => "Usaha atau Industri",
+                        "url" => "business-industries.index",
+                        "icon" => null,
+                        "sort_order" => 3,
+                    ],
+                    [
+                        "name" => "UMKM",
+                        "url" => "web-umkm.index",
+                        "icon" => null,
+                        "sort_order" => 4,
+                    ],
+                    [
+                        "name" => "Pariwisata",
+                        "url" => "web-tourisms.index",
+                        "icon" => null,
+                        "sort_order" => 5,
+                    ],
+                    [
+                        "name" => "Tata Ruang",
+                        "url" => "web-spatial-plannings.index",
+                        "icon" => null,
+                        "sort_order" => 6,
+                    ],
+                    [
+                        "name" => "PDAM",
+                        "url" => "customers",
+                        "icon" => null,
+                        "sort_order" => 7,
+                    ],
+                    [
+                        "name" => "Google Sheets",
+                        "url" => "google-sheets",
+                        "icon" => null,
+                        "sort_order" => 8,
+                    ],
+                    [
+                        "name" => "TPA TPT",
+                        "url" => "tpa-tpt.index",
+                        "icon" => null,
+                        "sort_order" => 9,
+                    ],
+                ]
+            ],
+            [
+                "name" => "Laporan",
+                "url" => "/laporan",
+                "icon" => "mingcute:report-line",
+                "parent_id" => null,
+                "sort_order" => 6,
+                "children" => [
+                    [
+                        "name" => "Lap Pariwisata",
+                        "url" => "tourisms-report.index",
+                        "icon" => null,
+                        "sort_order" => 1,
+                    ],
+                    [
+                        "name" => "Lap Pimpinan",
+                        "url" => "bigdata-resumes",
+                        "icon" => null,
+                        "sort_order" => 2,
+                    ],
+                    [
+                        "name" => "Rekap Pembayaran",
+                        "url" => "payment-recaps",
+                        "icon" => null,
+                        "sort_order" => 3,
+                    ],
+                    [
+                        "name" => "Lap Rekap Data Pembayaran",
+                        "url" => "report-payment-recaps",
+                        "icon" => null,
+                        "sort_order" => 4,
+                    ],
+                    [
+                        "name" => "Lap PBG (PTSP)",
+                        "url" => "report-pbg-ptsp",
+                        "icon" => null,
+                        "sort_order" => 5,
+                    ],
+                ]
+            ],
+            [
+                "name" => "Neng Bedas",
+                "url" => "/chat",
+                "icon" => "mingcute:wechat-line",
+                "parent_id" => null,
+                "sort_order" => 7,
+                "children" => [
+                    [
+                        "name" => "Chat",
+                        "url" => "main-chatbot.index",
+                        "icon" => null,
+                        "sort_order" => 1,
+                    ],
+                ]
+            ],
+            [
+                "name" => "Approval",
+                "url" => "/approval",
+                "icon" => "mingcute:user-follow-2-line",
+                "parent_id" => null,
+                "sort_order" => 8,
+                "children" => [
+                    [
+                        "name" => "Approval Pejabat",
+                        "url" => "approval-list",
+                        "icon" => null,
+                        "sort_order" => 1,
+                    ],
+                ]
+            ],
+            [
+                "name" => "Tools",
+                "url" => "/tools",
+                "icon" => "mingcute:tool-line",
+                "parent_id" => null,
+                "sort_order" => 9,
+                "children" => [
+                    [
+                        "name" => "Undangan",
+                        "url" => "invitations",
+                        "icon" => null,
+                        "sort_order" => 1,
+                    ],
+                ]
+            ],
+        ];
+
+        foreach ($menus as $menuData) {
+            $this->createOrUpdateMenu($menuData);
+        }
+    }
+
+        private function createOrUpdateMenu($menuData, $parentId = null){
+        $menuData['parent_id'] = $parentId;
+
+        $menu = Menu::updateOrCreate(['name' => $menuData['name']], Arr::except($menuData, ['children']));
+
+        if(!empty($menuData['children'])){
+            foreach($menuData['children'] as $child){
+                $this->createOrUpdateMenu($child, $menu->id);
+            }
+        }
+    }
+}

database/seeders/RoleSeeder.php

@@ -0,0 +1,37 @@
+<?php
+
+namespace Database\Seeders;
+
+use App\Models\Role;
+use Illuminate\Database\Console\Seeds\WithoutModelEvents;
+use Illuminate\Database\Seeder;
+
+class RoleSeeder extends Seeder
+{
+    /**
+     * Run the database seeds.
+     */
+    public function run(): void
+    {
+        $roles = [
+            [
+                "name" => "superadmin",
+                "description" => "show all menus for super admins",
+            ],
+            [
+                "name" => "admin",
+                "description" => "show only necessary menus for admins",
+            ],
+            [
+                "name" => "operator",
+                "description" => "show only necessary menus for operators",
+            ],
+            [
+                "name" => "user",
+                "description" => "show only necessary menus for users",
+            ]
+        ];
+
+        Role::upsert($roles, ['name']);
+    }
+}

database/seeders/UsersRoleMenuSeeder.php

@@ -13,400 +13,54 @@ class UsersRoleMenuSeeder extends Seeder
     /**
      * Run the database seeds.
      */
-    public function run(): void
+   public function run(): void
     {
-        $roles = [
+        // Fetch roles in a single query
-            [
+        $roles = Role::whereIn('name', ['superadmin', 'admin', 'operator'])->get()->keyBy('name');
-                "name" => "superadmin",
+
-                "description" => "show all menus for super admins",
+        // Fetch all menus in a single query and index by name
+        $menus = Menu::whereIn('name', [
+            'Dashboard', 'Master', 'Settings', 'Data Settings', 'Data', 'Laporan', 'Neng Bedas', 
+            'Approval', 'Tools', 'Dashboard Pimpinan', 'Dashboard PBG', 'Users', 'Syncronize', 
+            'Menu', 'Role', 'Setting Dashboard', 'PBG', 'Reklame', 'Usaha atau Industri', 'Pariwisata', 
+            'Lap Pariwisata', 'UMKM', 'Dashboard Potensi', 'Tata Ruang', 'PDAM', 'PETA', 
+            'Lap Pimpinan', 'Chat', 'Dalam Sistem', 'Luar Sistem', 'Google Sheets', 'TPA TPT', 
+            'Approval Pejabat', 'Undangan', 'Rekap Pembayaran', 'Lap Rekap Data Pembayaran', 'Lap PBG (PTSP)'
+        ])->get()->keyBy('name');
+
+        // Define access levels for each role
+        $permissions = [
+            'superadmin' => [
+                'Dashboard', 'Master', 'Settings', 'Data Settings', 'Data', 'Laporan', 'Neng Bedas', 
+                'Approval', 'Tools', 'Dashboard Pimpinan', 'Dashboard PBG', 'Users', 'Syncronize', 
+                'Menu', 'Role', 'Setting Dashboard', 'PBG', 'Reklame', 'Usaha atau Industri', 'Pariwisata', 
+                'Lap Pariwisata', 'UMKM', 'Dashboard Potensi', 'Tata Ruang', 'PDAM', 'Dalam Sistem', 
+                'Luar Sistem', 'Lap Pimpinan', 'Chat', 'Google Sheets', 'TPA TPT', 'Approval Pejabat', 
+                'Undangan', 'Rekap Pembayaran', 'Lap Rekap Data Pembayaran', 'Lap PBG (PTSP)'
             ],
-            [
+            'admin' => ['Dashboard', 'Master', 'Settings'],
-                "name" => "admin",
+            'operator' => ['Dashboard', 'Data', 'Laporan']
-                "description" => "show only necessary menus for admins",
-            ],
-            [
-                "name" => "operator",
-                "description" => "show only necessary menus for operators",
-            ]
         ];
 
-        Role::upsert($roles, ['name']);
+        // Define permission levels
+        $superadminPermissions = ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true];
+        $adminPermissions = ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true];
+        $operatorPermissions = ["allow_show" => true, "allow_create" => false, "allow_update" => false, "allow_destroy" => false];
 
-        $parent_menus = [
+        // Assign menus to roles
-            [
+        foreach ($permissions as $roleName => $menuNames) {
-                "name" => "Dashboard",
+            $role = $roles[$roleName] ?? null;
-                "url" => "/dashboard",
+            if ($role) {
-                "icon" => "mingcute:home-3-line",
+                $role->menus()->sync(
-                "parent_id" => null,
+                    collect($menuNames)->mapWithKeys(fn($menuName) => [
-                "sort_order" => 1,
+                        $menus[$menuName]->id => ($roleName === 'superadmin' ? $superadminPermissions : 
-            ],
+                                                ($roleName === 'admin' ? $adminPermissions : $operatorPermissions))
-            [
+                    ])->toArray()
-                "name" => "Master",
+                );
-                "url" => "/master",
+            }
-                "icon" => "mingcute:cylinder-line",
-                "parent_id" => null,
-                "sort_order" => 2,
-            ],
-            [
-                "name" => "Settings",
-                "url" => "/settings",
-                "icon" => "mingcute:settings-6-line",
-                "parent_id" => null,
-                "sort_order" => 3,
-            ],
-            [
-                "name" => "Data Settings",
-                "url" => "/data-settings",
-                "icon" => "mingcute:settings-1-line",
-                "parent_id" => null,
-                "sort_order" => 4,
-            ],
-            [
-                "name" => "Data",
-                "url" => "/data",
-                "icon" => "mingcute:task-line",
-                "parent_id" => null,
-                "sort_order" => 5,
-            ],
-            [
-                "name" => "Laporan",
-                "url" => "/laporan",
-                "icon" => "mingcute:report-line",
-                "parent_id" => null,
-                "sort_order" => 6,
-            ],
-            [
-                "name" => "Neng Bedas",
-                "url" => "/chat",
-                "icon" => "mingcute:wechat-line",
-                "parent_id" => null,
-                "sort_order" => 7,
-            ],
-            [
-                "name" => "Approval",
-                "url" => "/approval",
-                "icon" => "mingcute:user-follow-2-line",
-                "parent_id" => null,
-                "sort_order" => 8,
-            ],
-            [
-                "name" => "Tools",
-                "url" => "/tools",
-                "icon" => "mingcute:tool-line",
-                "parent_id" => null,
-                "sort_order" => 9,
-            ],
-        ];
-
-        foreach ($parent_menus as $parent_menu) {
-            Menu::firstOrCreate(['name' => $parent_menu['name']], $parent_menu);
         }
         
-        // Attach Menus to Roles
-        $superadmin = Role::where('name', 'superadmin')->first();
-        $admin = Role::where('name', 'admin')->first();
-        $operator = Role::where('name', 'operator')->first();
-
-        $dashboard = Menu::where('name', 'Dashboard')->first();
-        $master = Menu::where('name', 'Master')->first();
-        $settings = Menu::where('name', 'Settings')->first();
-        $dataSettings = Menu::where('name', 'Data Settings')->first();
-        $data = Menu::where('name', 'Data')->first();
-        $laporan = Menu::where('name', 'Laporan')->first();
-        $chat_bedas = Menu::where('name', 'Neng Bedas')->first();
-        $approval = Menu::where('name', 'Approval')->first();
-        $tools = Menu::where('name', 'Tools')->first();
-
-        // create children menu
-        $children_menus = [
-            [
-                "name" => "Dashboard Pimpinan",
-                "url" => "dashboard.home",
-                "icon" => null,
-                "parent_id" => $dashboard->id,
-                "sort_order" => 1,
-            ],
-            [
-                "name" => "Dashboard PBG",
-                "url" => "dashboard.pbg",
-                "icon" => null,
-                "parent_id" => $dashboard->id,
-                "sort_order" => 2,
-            ],
-            [
-                "name" => "Dashboard Potensi",
-                "url" => null,
-                "icon" => null,
-                "parent_id" => $dashboard->id,
-                "sort_order" => 3,
-            ],
-            [
-                "name" => "PETA",
-                "url" => "dashboard.maps",
-                "icon" => null,
-                "parent_id" => $dashboard->id,
-                "sort_order" => 4,
-            ],
-            [
-                "name" => "Users",
-                "url" => "users.index",
-                "icon" => null,
-                "parent_id" => $master->id,
-                "sort_order" => 1,
-            ],
-            [
-                "name" => "Approval Pejabat",
-                "url" => "approval-list",
-                "icon" => null,
-                "parent_id" => $approval->id,
-                "sort_order" => 1,
-            ],
-            [
-                "name" => "Syncronize",
-                "url" => "settings.syncronize",
-                "icon" => null,
-                "parent_id" => $settings->id,
-                "sort_order" => 1,
-            ],
-            [
-                "name" => "Menu",
-                "url" => "menus.index",
-                "icon" => null,
-                "parent_id" => $settings->id,
-                "sort_order" => 2,
-            ],
-            [
-                "name" => "Role",
-                "url" => "roles.index",
-                "icon" => null,
-                "parent_id" => $settings->id,
-                "sort_order" => 3,
-            ],
-            [
-                "name" => "Setting Dashboard",
-                "url" => "data-settings.index",
-                "icon" => null,
-                "parent_id" => $dataSettings->id,
-                "sort_order" => 1,
-            ],
-            [
-                "name" => "PBG",
-                "url" => "pbg-task.index",
-                "icon" => null,
-                "parent_id" => $data->id,
-                "sort_order" => 1,
-            ],
-            [
-                "name" => "Reklame",
-                "url" => "web.advertisements.index",
-                "icon" => null,
-                "parent_id" => $data->id,
-                "sort_order" => 2,
-            ],
-            [
-                "name" => "Usaha atau Industri",
-                "url" => "business-industries.index",
-                "icon" => null,
-                "parent_id" => $data->id,
-                "sort_order" => 3,
-            ],
-            [
-                "name" => "UMKM",
-                "url" => "web-umkm.index",
-                "icon" => null,
-                "parent_id" => $data->id,
-                "sort_order" => 4,
-            ],
-            [
-                "name" => "Pariwisata",
-                "url" => "web-tourisms.index",
-                "icon" => null,
-                "parent_id" => $data->id,
-                "sort_order" => 5,
-            ],
-            [
-                "name" => "Tata Ruang",
-                "url" => "web-spatial-plannings.index",
-                "icon" => null,
-                "parent_id" => $data->id,
-                "sort_order" => 6,
-            ],
-            [
-                "name" => "PDAM",
-                "url" => "customers",
-                "icon" => null,
-                "parent_id" => $data->id,
-                "sort_order" => 7,
-            ],
-            [
-                "name" => "Google Sheets",
-                "url" => "google-sheets",
-                "icon" => null,
-                "parent_id" => $data->id,
-                "sort_order" => 8,
-            ],
-            [
-                "name" => "TPA TPT",
-                "url" => "tpa-tpt",
-                "icon" => null,
-                "parent_id" => $data->id,
-                "sort_order" => 9,
-            ],
-            [
-                "name" => "Lap Pariwisata",
-                "url" => "tourisms-report.index",
-                "icon" => null,
-                "parent_id" => $laporan->id,
-                "sort_order" => 1,
-            ],
-            [
-                "name" => "Lap Pimpinan",
-                "url" => "bigdata-resumes",
-                "icon" => null,
-                "parent_id" => $laporan->id,
-                "sort_order" => 2,
-            ],
-            [
-                "name" => "Rekap Pembayaran",
-                "url" => "payment-recaps",
-                "icon" => null,
-                "parent_id" => $laporan->id,
-                "sort_order" => 3,
-            ],
-            [
-                "name" => "Lap Rekap Data Pembayaran",
-                "url" => "report-payment-recap",
-                "icon" => null,
-                "parent_id" => $laporan->id,
-                "sort_order" => 4,
-            ],
-            [
-                "name" => "Lap PBG (PTSP)",
-                "url" => "report-pbg-ptsp",
-                "icon" => null,
-                "parent_id" => $laporan->id,
-                "sort_order" => 5,
-            ],
-            [
-                "name" => "Chat",
-                "url" => "main-chatbot.index",
-                "icon" => null,
-                "parent_id" => $chat_bedas->id,
-                "sort_order" => 1,
-            ],
-            [
-                "name" => "Luar Sistem",
-                "url" => "dashboard.potentials.inside_system",
-                "icon" => null,
-                "parent_id" => Menu::where('name', 'Dashboard Potensi')->first()->id,
-                "sort_order" => 1,
-            ],
-            [
-                "name" => "Dalam Sistem",
-                "url" => "dashboard.potentials.outside_system",
-                "icon" => null,
-                "parent_id" => Menu::where('name', 'Dashboard Potensi')->first()->id,
-                "sort_order" => 2,
-            ],
-            [
-                "name" => "Undangan",
-                "url" => "invitations",
-                "icon" => null,
-                "parent_id" => $tools->id,
-                "sort_order" => 1,
-            ],
-        ];
-
-        foreach ($children_menus as $child_menu) {
-            Menu::firstOrCreate(['name' => $child_menu['name']], $child_menu);
-        }
-
-        $dashboard_pimpinan = Menu::where('name', 'Dashboard Pimpinan')->first();
-        $dashboard_pbg = Menu::where('name', 'Dashboard PBG')->first();
-        $users = Menu::where('name', 'Users')->first();
-        $syncronize = Menu::where('name', 'Syncronize')->first();
-        $setting_menu = Menu::where('name', 'Menu')->first();
-        $setting_role = Menu::where('name', 'Role')->first();
-        $setting_dashboard = Menu::where('name', 'Setting Dashboard')->first();
-        $setting_pbg = Menu::where('name', 'PBG')->first();
-        $reklame = Menu::where('name', 'Reklame')->first();
-        $businessIndustries = Menu::where('name', 'Usaha atau Industri')->first();
-        $pariwisata = Menu::where('name', 'Pariwisata')->first();
-        $laporan_pariwisata = Menu::where('name', 'Lap Pariwisata')->first();
-        $umkm = Menu::where('name', 'UMKM')->first();
-        $lack_of_potentials = Menu::where('name', 'Dashboard Potensi')->first();
-        $spatial_plannings = Menu::where('name', 'Tata Ruang')->first();
-        $pdam = Menu::where('name', 'PDAM')->first();
-        $peta = Menu::where('name', 'PETA')->first();
-        $bigdata_resume = Menu::where('name', 'Lap Pimpinan')->first();
-        $chatbot = Menu::where('name', 'Chat')->first();
-        $dalam_sistem = Menu::where('name', 'Dalam Sistem')->first();
-        $luar_sistem = Menu::where('name', 'Luar Sistem')->first();
-        $google_sheets = Menu::where('name', 'Google Sheets')->first();
-        $tpa_tpt = Menu::where('name', 'TPA TPT')->first();
-        $approval_pejabat = Menu::where('name', 'Approval Pejabat')->first();
-        $intivations = Menu::where('name', 'Undangan')->first();
-        $payment_recap = Menu::where('name', 'Rekap Pembayaran')->first();
-        $report_payment_recap = Menu::where('name', 'Lap Rekap Data Pembayaran')->first();
-        $report_pbg_ptsp = Menu::where('name', 'Lap PBG (PTSP)')->first();
-
-        // Superadmin gets all menus
-        $superadmin->menus()->sync([
-            // parent
-            $dashboard->id => ["allow_show" => true, "allow_create" => false, "allow_update" => false, "allow_destroy" => false],
-            $master->id => ["allow_show" => true, "allow_create" => false, "allow_update" => false, "allow_destroy" => false],
-            $settings->id => ["allow_show" => true, "allow_create" => false, "allow_update" => false, "allow_destroy" => false],
-            $dataSettings->id => ["allow_show" => true, "allow_create" => false, "allow_update" => false, "allow_destroy" => false],
-            $data->id => ["allow_show" => true, "allow_create" => false, "allow_update" => false, "allow_destroy" => false],
-            $laporan->id => ["allow_show" => true, "allow_create" => false, "allow_update" => false, "allow_destroy" => false],
-            $chat_bedas->id => ["allow_show" => true, "allow_create" => false, "allow_update" => false, "allow_destroy" => false],
-            $approval->id => ["allow_show" => true, "allow_create" => false, "allow_update" => false, "allow_destroy" => false],
-            $tools->id => ["allow_show" => true, "allow_create" => false, "allow_update" => false, "allow_destroy" => false],
-            // children
-            $dashboard_pimpinan->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
-            $dashboard_pbg->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
-            $users->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
-            $syncronize->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
-            $setting_menu->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
-            $setting_role->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
-            $setting_dashboard->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
-            $setting_pbg->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
-            $reklame->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
-            $businessIndustries->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
-            $pariwisata->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
-            $laporan_pariwisata->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
-            $umkm->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
-            $lack_of_potentials->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
-            $spatial_plannings->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
-            $pdam->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
-            // $peta->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
-            $dalam_sistem->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
-            $luar_sistem->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],
-            $chatbot->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
-            $google_sheets->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
-            $tpa_tpt->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
-            $approval_pejabat->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
-            $intivations->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
-            $payment_recap->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
-            $report_payment_recap->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
-            $report_pbg_ptsp->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
-        ]);
-
-        // Admin gets limited menus
-        $admin->menus()->sync([
-            $dashboard->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
-            $master->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
-            $settings->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
-        ]);
-
-        // Operator gets only basic menus with full permissions
-        $operator->menus()->sync([
-            $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]);
+        User::findOrFail(1)->roles()->sync([$roles['superadmin']->id]);
     }
 }

deploy.sh

@@ -19,16 +19,21 @@ COMPOSER_ALLOW_SUPERUSER=1 composer install --no-interaction --optimize-autoload
 echo "🗄️ Running migrations..."
 php artisan migrate --force
 
+echo "Running seeders..."
+php artisan db:seed --force
+
 echo "⚡ Optimizing application..."
 php artisan optimize:clear
 
 echo "🔄 Restarting PHP service..."
-systemctl restart $PHP_VERSION-fpm
+systemctl reload $PHP_VERSION-fpm
 
 echo "🔁 Restarting Supervisor queue workers..."
-supervisorctl stop all
+php artisan queue:restart
-supervisorctl reload
+
-supervisorctl start all
+supervisorctl reread
+supervisorctl update
+supervisorctl restart all
 
 php artisan up
 echo "🚀 Deployment completed successfully!"

resources/js/bigdata-resumes/index.js

@@ -17,6 +17,8 @@ class BigdataResume {
     async initEvents() {
         await this.initBigdataResumeTable();
         // this.handleSearch();
+        await this.handleExportPDF();
+        await this.handleExportToExcel();
     }
 
     async initBigdataResumeTable() {
@@ -114,6 +116,100 @@ class BigdataResume {
         });
     }
 
+    async handleExportToExcel() {
+        const button = document.getElementById("btn-export-excel");
+        if (!button) {
+            console.error("Button not found: #btn-export-excel");
+            return;
+        }
+
+        let exportUrl = button.getAttribute("data-url");
+
+        button.addEventListener("click", async () => {
+            button.disabled = true;
+            try {
+                const response = await fetch(`${exportUrl}`, {
+                    method: "GET",
+                    credentials: "include",
+                    headers: {
+                        Authorization: `Bearer ${document
+                            .querySelector('meta[name="api-token"]')
+                            .getAttribute("content")}`,
+                    },
+                });
+                if (!response.ok) {
+                    console.error("Error fetching data:", response.statusText);
+                    button.disabled = false;
+                    return;
+                }
+
+                // Convert response to Blob and trigger download
+                const blob = await response.blob();
+                const url = window.URL.createObjectURL(blob);
+                const a = document.createElement("a");
+                a.href = url;
+                a.download = "laporan-pimpinan.xlsx";
+                document.body.appendChild(a);
+                a.click();
+                document.body.removeChild(a);
+                window.URL.revokeObjectURL(url);
+            } catch (error) {
+                console.error("Error fetching data:", error);
+                button.disabled = false;
+                return;
+            } finally {
+                button.disabled = false;
+            }
+        });
+    }
+
+    async handleExportPDF() {
+        const button = document.getElementById("btn-export-pdf");
+        if (!button) {
+            console.error("Button not found: #btn-export-pdf");
+            return;
+        }
+
+        let exportUrl = button.getAttribute("data-url");
+
+        button.addEventListener("click", async () => {
+            button.disabled = true;
+            try {
+                const response = await fetch(`${exportUrl}`, {
+                    method: "GET",
+                    credentials: "include",
+                    headers: {
+                        Authorization: `Bearer ${document
+                            .querySelector('meta[name="api-token"]')
+                            .getAttribute("content")}`,
+                    },
+                });
+                if (!response.ok) {
+                    console.error("Error fetching data:", response.statusText);
+                    button.disabled = false;
+                    return;
+                }
+
+                // Convert response to Blob and trigger download
+                const blob = await response.blob();
+                const url = window.URL.createObjectURL(blob);
+                const a = document.createElement("a");
+                a.href = url;
+                a.download = "laporan-pimpinan.pdf";
+                document.body.appendChild(a);
+                a.click();
+                document.body.removeChild(a);
+                window.URL.revokeObjectURL(url);
+            } catch (error) {
+                console.error("Error fetching data:", error);
+                button.disabled = false;
+                return;
+            } finally {
+                button.disabled = false;
+            }
+        });
+    }
+
     handleSearch() {
         document.getElementById("search-btn").addEventListener("click", () => {
             let searchValue = document.getElementById("search-box").value;

resources/js/business-industries/create.js

@@ -12,6 +12,8 @@ const spinner = document.getElementById("spinner");
 const toastNotification = document.getElementById("toastNotification");
 const toast = new bootstrap.Toast(toastNotification);
 
+let menuId = document.getElementById("menuId").value;
+
 (dropzonePreviewNode.id = ""),
     dropzonePreviewNode &&
         ((previewTemplate = dropzonePreviewNode.parentNode.innerHTML),
@@ -34,7 +36,7 @@ const toast = new bootstrap.Toast(toastNotification);
                         response.message;
                     toast.show();
                     setTimeout(() => {
-                        window.location.href = "/data/business-industries";
+                        window.location.href = `/data/business-industries?menu_id=${menuId}`;
                     }, 2000);
                 });
                 this.on("error", function (file, errorMessage) {

resources/js/business-industries/index.js

@@ -35,6 +35,7 @@ class BusinessIndustries {
         tableContainer.innerHTML = "";
         let canUpdate = tableContainer.getAttribute("data-updater") === "1";
         let canDelete = tableContainer.getAttribute("data-destroyer") === "1";
+        let menuId = tableContainer.getAttribute("data-menuId");
 
         // Create a new Grid.js instance only if it doesn't exist
         this.table = new Grid({
@@ -56,12 +57,11 @@ class BusinessIndustries {
                 {
                     name: "Action",
                     formatter: (cell) => {
-                        
                         let buttons = `<div class="d-flex justify-content-center gap-2">`;
 
                         if (canUpdate) {
                             buttons += `
-                                <a href="/data/business-industries/${cell}/edit" class="btn btn-yellow btn-sm d-inline-flex align-items-center justify-content-center">
+                                <a href="/data/business-industries/${cell}/edit?menu_id=${menuId}" class="btn btn-yellow btn-sm d-inline-flex align-items-center justify-content-center">
                                     <i class='bx bx-edit'></i>
                                 </a>
                             `;

resources/js/business-industries/update.js

@@ -13,6 +13,8 @@ class UpdateBusinessIndustries {
         const spinner = document.getElementById("spinner");
         const toast = new bootstrap.Toast(toastNotification);
 
+        let menuId = document.getElementById("menuId").value;
+
         if (!submitButton) {
             console.error("Error: Submit button not found!");
             return;
@@ -53,7 +55,7 @@ class UpdateBusinessIndustries {
                         data.message;
                     toast.show();
                     setTimeout(() => {
-                        window.location.href = "/data/business-industries";
+                        window.location.href = `/data/business-industries?menu_id=${menuId}`;
                     }, 2000);
                 } else {
                     // Show error toast with message from API

resources/js/customers/create.js

@@ -6,6 +6,7 @@ class CreateCustomer {
     initCreateCustomer() {
         const toastNotification = document.getElementById("toastNotification");
         const toast = new bootstrap.Toast(toastNotification);
+        let menuId = document.getElementById("menuId").value;
         document
             .getElementById("btnCreateCustomer")
             .addEventListener("click", async function () {
@@ -41,7 +42,7 @@ class CreateCustomer {
                             result.message;
                         toast.show();
                         setTimeout(() => {
-                            window.location.href = "/data/customers";
+                            window.location.href = `/data/customers?menu_id=${menuId}`;
                         }, 2000);
                     } else {
                         let error = await response.json();

resources/js/customers/edit.js

@@ -6,6 +6,7 @@ class UpdateCustomer {
     initUpdateCustomer() {
         const toastNotification = document.getElementById("toastNotification");
         const toast = new bootstrap.Toast(toastNotification);
+        let menuId = document.getElementById("menuId").value;
         document
             .getElementById("btnUpdateCustomer")
             .addEventListener("click", async function () {
@@ -41,7 +42,7 @@ class UpdateCustomer {
                             result.message;
                         toast.show();
                         setTimeout(() => {
-                            window.location.href = "/data/customers";
+                            window.location.href = `/data/customers?menu_id=${menuId}`;
                         }, 2000);
                     } else {
                         let error = await response.json();

resources/js/customers/index.js

@@ -32,6 +32,7 @@ class Customers {
         tableContainer.innerHTML = "";
         let canUpdate = tableContainer.getAttribute("data-updater") === "1";
         let canDelete = tableContainer.getAttribute("data-destroyer") === "1";
+        let menuId = tableContainer.getAttribute("data-menuId");
         this.table = new Grid({
             columns: [
                 "ID",
@@ -48,7 +49,7 @@ class Customers {
 
                         if (canUpdate) {
                             buttons += `
-                                <a href="/data/customers/${cell}/edit" class="btn btn-yellow btn-sm d-inline-flex align-items-center justify-content-center">
+                                <a href="/data/customers/${cell}/edit?menu_id=${menuId}" class="btn btn-yellow btn-sm d-inline-flex align-items-center justify-content-center">
                                     <i class='bx bx-edit'></i>
                                 </a>
                             `;
@@ -66,7 +67,9 @@ class Customers {
                             buttons = `<span class="text-muted">No Privilege</span>`;
                         }
 
-                        return gridjs.html(`<div class="d-flex justify-content-center gap-2">${buttons}</div>`);
+                        return gridjs.html(
+                            `<div class="d-flex justify-content-center gap-2">${buttons}</div>`
+                        );
                     },
                 },
             ],

resources/js/customers/upload.js

@@ -20,6 +20,7 @@ class UploadCustomers {
     initDropzone() {
         const toastNotification = document.getElementById("toastNotification");
         const toast = new bootstrap.Toast(toastNotification);
+        let menuId = document.getElementById("menuId").value;
         var previewTemplate,
             dropzonePreviewNode = document.querySelector(
                 "#dropzone-preview-list"
@@ -46,7 +47,7 @@ class UploadCustomers {
                                 response.message;
                             toast.show();
                             setTimeout(() => {
-                                window.location.href = "/data/customers";
+                                window.location.href = `/data/customers?menu_id=${menuId}`;
                             }, 2000);
                         });
                         this.on("error", function (file, errorMessage) {

resources/js/dashboards/pbg.js

@@ -3,107 +3,99 @@ import GlobalConfig, { addThousandSeparators } from "../global-config.js";
 import ApexCharts from "apexcharts";
 import "gridjs/dist/gridjs.umd.js";
 import GeneralTable from "../table-generator.js";
+import InitDatePicker from "../utils/InitDatePicker.js";
 
 var chart;
-document.addEventListener("DOMContentLoaded", async function () {
-    await initChart();
-    const yearPicker = document.getElementById("yearPicker");
 
-    async function updateDataByYear(selectedYear) {
+class DashboardPBG {
-        // Target PAD Element
+    async init() {
+        try {
+            new InitDatePicker(
+                "#datepicker-dashboard-pbg",
+                this.handleChangedDate.bind(this)
+            ).init();
+
+            // Load initial data
+            this.updateData("latest");
+        } catch (error) {
+            console.error("Error initializing data:", error);
+        }
+    }
+
+    handleChangedDate(filterDate) {
+        if (!filterDate) return;
+        this.updateData(filterDate);
+    }
+
+    async updateData(filterDate) {
+        let resumeData = await this.getResume(filterDate);
+        if (!resumeData) return;
+
+        let targetPAD = resumeData.target_pad.sum;
         const targetPadElement = document.getElementById("target-pad");
-        if (!targetPadElement) return;
+        targetPadElement.textContent = formatCurrency(targetPAD);
-        const targetPadValue = await getDataSettings("TARGET_PAD");
-        targetPadElement.textContent = formatCurrency(targetPadValue);
 
-        // Total Potensi Berkas
         const totalPotensiBerkas = document.getElementById(
             "total-potensi-berkas"
         );
-        if (!totalPotensiBerkas) return;
-        const totalPotensiBerkasValue = await getDataTotalPotensi(selectedYear);
         totalPotensiBerkas.textContent = formatCurrency(
-            totalPotensiBerkasValue.totalData
+            resumeData.total_potensi.sum
         );
 
-        // Total Berkas Terverifikasi
         const totalBerkasTerverifikasi = document.getElementById(
             "total-berkas-terverifikasi"
         );
-        if (!totalBerkasTerverifikasi) return;
-        const totalBerkasTerverifikasiValue = await getDataVerification(
-            selectedYear
-        );
         totalBerkasTerverifikasi.textContent = formatCurrency(
-            totalBerkasTerverifikasiValue.totalData
+            resumeData.verified_document.sum
         );
 
-        // Total Kekurangan potensi
         const totalKekuranganPotensi = document.getElementById(
             "total-kekurangan-potensi"
         );
-        if (!totalKekuranganPotensi) return;
-        const totalKekuranganPotensiValue =
-            new Big(targetPadValue) -
-            new Big(totalPotensiBerkasValue.totalData);
         totalKekuranganPotensi.textContent = formatCurrency(
-            totalKekuranganPotensiValue
+            resumeData.kekurangan_potensi.sum
         );
 
-        // Total Potensi PBG dari tata ruang
         const totalPotensiPBGTataRuang = document.getElementById(
             "total-potensi-pbd-tata-ruang"
         );
-        if (!totalPotensiPBGTataRuang) return;
+        totalPotensiPBGTataRuang.textContent = "Rp.-";
-        const totalPotensiPBGTataRuangValue = await getDataSettings(
-            "TATA_RUANG"
-        );
-        totalPotensiPBGTataRuang.textContent = formatCurrency(
-            totalPotensiPBGTataRuangValue
-        );
 
-        // Total Berkas Belum terverifikasi
         const totalBerkasBelumTerverifikasi = document.getElementById(
             "total-berkas-belum-terverifikasi"
         );
-        if (!totalBerkasBelumTerverifikasi) return;
-        const totalBerkasBelumTerverifikasiValue = await getDataNonVerification(
-            selectedYear
-        );
-        const totalBerkasBelumTerverifikasiCount =
-            totalBerkasBelumTerverifikasiValue.countData;
         totalBerkasBelumTerverifikasi.textContent = formatCurrency(
-            totalBerkasBelumTerverifikasiValue.totalData
+            resumeData.non_verified_document.sum
         );
 
+        const totalRealisasiTerbitPBG = document.getElementById(
+            "realisasi-terbit-pbg"
+        );
+        totalRealisasiTerbitPBG.textContent = formatCurrency(
+            resumeData.realisasi_terbit.sum
+        );
+
+        const totalProsesDinasTeknis = document.getElementById(
+            "processing-technical-services"
+        );
+        totalProsesDinasTeknis.textContent = formatCurrency(
+            resumeData.proses_dinas_teknis.sum
+        );
+
+        await this.initPieChart(resumeData);
+    }
+
+    async initPieChart(data) {
         // Total Berkas Usaha
-        const totalBerkasUsahaValue = await getDataBusiness(selectedYear);
+        const totalBerkasUsahaTotalData = data.verified_document.sum;
-        const totalBerkasUsahaCount = totalBerkasUsahaValue.countData;
-        const totalBerkasUsahaTotalData = totalBerkasUsahaValue.totalData;
 
         // Total Berkas Non Usaha
-        const totalBerkasNonUsahaValue = await getDataNonBusiness(selectedYear);
+        const totalBerkasNonUsahaTotalData = data.non_verified_document.sum;
-        const totalBerkasNonUsahaCount = totalBerkasNonUsahaValue.countData;
-        const totalBerkasNonUsahaTotalData = totalBerkasNonUsahaValue.totalData;
 
         // Pie Chart Section
-        let persenUsaha =
+        let persenUsaha = data.verified_document.percentage;
-            totalBerkasBelumTerverifikasiCount > 0
-                ? (
-                      (totalBerkasUsahaCount /
-                          totalBerkasBelumTerverifikasiCount) *
-                      100
-                  ).toFixed(2)
-                : "0";
 
-        let persenNonUsaha =
+        let persenNonUsaha = data.non_verified_document.percentage;
-            totalBerkasBelumTerverifikasiCount > 0
-                ? (
-                      (totalBerkasNonUsahaCount /
-                          totalBerkasBelumTerverifikasiCount) *
-                      100
-                  ).toFixed(2)
-                : "0";
 
         const dataSeriesPieChart = [
             Number(persenUsaha),
@@ -123,7 +115,41 @@ document.addEventListener("DOMContentLoaded", async function () {
         ).textContent = persenUsaha + "%";
 
         updatePieChart(dataSeriesPieChart, labelsPieChart);
+    }
 
+    async getResume(filterByDate) {
+        try {
+            const response = await fetch(
+                `${GlobalConfig.apiHost}/api/bigdata-resume?filterByDate=${filterByDate}`,
+                {
+                    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;
+        } catch (error) {
+            console.error("Error fetching chart data:", error);
+            return null;
+        }
+    }
+}
+document.addEventListener("DOMContentLoaded", async function (e) {
+    await new DashboardPBG().init();
+    await initChart();
+
+    async function updateDataByYear() {
         // Load all Tourism location
         const allLocation = await getAllLocation();
         console.log(allLocation);
@@ -159,42 +185,6 @@ document.addEventListener("DOMContentLoaded", async function () {
                 .bindTooltip(loc.name, { permanent: false, direction: "top" }); // Tooltip saat di-hover
         });
 
-        // Realisasi terbit PBG
-        const totalRealisasiTerbitPBG = document.getElementById(
-            "realisasi-terbit-pbg"
-        );
-        if (!totalRealisasiTerbitPBG) return;
-        const totalRealisasiTerbitPBGValue = await getDataSettings(
-            "REALISASI_TERBIT_PBG_SUM"
-        );
-        totalRealisasiTerbitPBG.textContent = formatCurrency(
-            totalRealisasiTerbitPBGValue
-        );
-
-        // Menunggu Klik DPMPTSP
-        const totalMenungguKlikDpmptsp = document.getElementById(
-            "waiting-click-dpmptsp"
-        );
-        if (!totalMenungguKlikDpmptsp) return;
-        const totalMenungguKlikDpmptspValue = await getDataSettings(
-            "MENUNGGU_KLIK_DPMPTSP_SUM"
-        );
-        totalMenungguKlikDpmptsp.textContent = formatCurrency(
-            totalMenungguKlikDpmptspValue
-        );
-
-        // Proses Dinas Teknis
-        const totalProsesDinasTeknis = document.getElementById(
-            "processing-technical-services"
-        );
-        if (!totalProsesDinasTeknis) return;
-        const totalProsesDinasTeknisValue = await getDataSettings(
-            "PROSES_DINAS_TEKNIS_SUM"
-        );
-        totalProsesDinasTeknis.textContent = formatCurrency(
-            totalProsesDinasTeknisValue
-        );
-
         // Load Tabel Baru di Update
         const tableLastUpdated = new GeneralTable(
             "pbg-filter-by-updated-at",
@@ -255,188 +245,9 @@ document.addEventListener("DOMContentLoaded", async function () {
         ).hidden = true;
     }
 
-    await updateDataByYear(yearPicker.value);
+    await updateDataByYear();
-
-    yearPicker.addEventListener("change", async function () {
-        console.log("event change dropdown");
-        await updateDataByYear(yearPicker.value);
-    });
 });
 
-async function getDataSettings(string_key) {
-    try {
-        const response = await fetch(
-            `${GlobalConfig.apiHost}/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 ?? 0; // Pastikan tidak error jika data kosong
-    } catch (error) {
-        console.error("Error fetching data:", error);
-        return 0;
-    }
-}
-
-async function 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) {
-            console.error("Network response was not ok", response);
-        }
-
-        const data = await response.json();
-        return {
-            totalData: data.data.total,
-        };
-    } catch (error) {
-        console.error("Error fetching chart data:", error);
-        return null;
-    }
-}
-
-async function getDataVerification(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 {
-            totalData: data.data.total,
-        };
-    } catch (error) {
-        console.error("Error fetching chart data:", error);
-        return 0;
-    }
-}
-
-async function getDataNonVerification(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 {
-            countData: data.data.count,
-            totalData: data.data.total,
-        };
-    } catch (error) {
-        console.error("Error fetching chart data:", error);
-        return 0;
-    }
-}
-
-async function 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 {
-            countData: data.data.count,
-            totalData: data.data.total,
-        };
-    } catch (error) {
-        console.error("Error fetching chart data:", error);
-        return 0;
-    }
-}
-
-async function 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 {
-            countData: data.data.count,
-            totalData: data.data.total,
-        };
-    } catch (error) {
-        console.error("Error fetching chart data:", error);
-        return 0;
-    }
-}
-
 async function getAllLocation() {
     try {
         const response = await fetch(

resources/js/data-settings/create.js

@@ -1,6 +1,7 @@
 document.addEventListener("DOMContentLoaded", function (e) {
     const toastNotification = document.getElementById("toastNotification");
     const toast = new bootstrap.Toast(toastNotification);
+    let menuId = document.getElementById("menuId").value;
     document
         .getElementById("btnCreateDataSettings")
         .addEventListener("click", async function () {
@@ -37,7 +38,7 @@ document.addEventListener("DOMContentLoaded", function (e) {
                         result.data.message;
                     toast.show();
                     setTimeout(() => {
-                        window.location.href = "/data-settings";
+                        window.location.href = `/data-settings?menu_id=${menuId}`;
                     }, 2000);
                 } else {
                     let error = await response.json();

resources/js/data-settings/index.js

@@ -32,7 +32,8 @@ class DataSettings {
 
         tableContainer.innerHTML = "";
         let canUpdate = tableContainer.getAttribute("data-updater") === "1";
-        let canDelete = tableContainer.getAttribute("data-destroyer") === "1"
+        let canDelete = tableContainer.getAttribute("data-destroyer") === "1";
+        let menuId = tableContainer.getAttribute("data-menuId");
         // Create a new Grid.js instance only if it doesn't exist
         this.table = new Grid({
             columns: [
@@ -48,7 +49,7 @@ class DataSettings {
 
                         if (canUpdate) {
                             buttons += `
-                                <a href="/data-settings/${cell}/edit" class="btn btn-yellow btn-sm d-inline-flex align-items-center justify-content-center">
+                                <a href="/data-settings/${cell}/edit?menu_id=${menuId}" class="btn btn-yellow btn-sm d-inline-flex align-items-center justify-content-center">
                                     <i class='bx bx-edit'></i>
                                 </a>
                             `;
@@ -66,7 +67,9 @@ class DataSettings {
                             buttons = `<span class="text-muted">No Privilege</span>`;
                         }
 
-                        return gridjs.html(`<div class="d-flex justify-content-center gap-2">${buttons}</div>`);
+                        return gridjs.html(
+                            `<div class="d-flex justify-content-center gap-2">${buttons}</div>`
+                        );
                     },
                 },
             ],

resources/js/data-settings/update.js

@@ -6,6 +6,7 @@ document.addEventListener("DOMContentLoaded", function (e) {
     let toast = new bootstrap.Toast(
         document.getElementById("toastNotification")
     );
+    let menuId = document.getElementById("menuId").value;
     submitButton.addEventListener("click", async function () {
         let submitButton = this;
 
@@ -36,7 +37,7 @@ document.addEventListener("DOMContentLoaded", function (e) {
                 toastMessage.innerText = result.data.message;
                 toast.show();
                 setTimeout(() => {
-                    window.location.href = "/data-settings";
+                    window.location.href = `/data-settings?menu_id=${menuId}`;
                 }, 2000);
             } else {
                 let error = await response.json();

resources/js/data/advertisements/data-advertisements.js

@@ -8,6 +8,7 @@ import GeneralTable from "../../table-generator.js";
 const tableElement = document.getElementById("reklame-data-table");
 const canUpdate = tableElement.getAttribute("data-updater") === "1";
 const canDelete = tableElement.getAttribute("data-destroyer") === "1";
+let menuId = document.getElementById("menuId").value;
 
 const dataAdvertisementsColumns = [
     "No",
@@ -23,9 +24,9 @@ const dataAdvertisementsColumns = [
     {
         name: "Actions",
         width: "120px",
-        formatter: function(cell, row) {
+        formatter: function (cell, row) {
             const id = row.cells[10].data;
-            const model = "data/advertisements";
+            const model = `data/web-advertisements`;
 
             let actionButtons = '<div class="d-flex justify-items-end gap-10">';
             let hasPrivilege = false;
@@ -36,7 +37,8 @@ const dataAdvertisementsColumns = [
                 actionButtons += `
                     <button class="btn btn-warning me-2 btn-edit" 
                         data-id="${id}" 
-                        data-model="${model}">
+                        data-model="${model}"
+                        data-menu="${menuId}">
                         <i class='bx bx-edit'></i>
                     </button>`;
             }
@@ -51,12 +53,16 @@ const dataAdvertisementsColumns = [
                     </button>`;
             }
 
-            actionButtons += '</div>';
+            actionButtons += "</div>";
 
             // Jika tidak memiliki akses, tampilkan teks "No Privilege"
-            return gridjs.html(hasPrivilege ? actionButtons : '<span class="text-muted">No Privilege</span>');
+            return gridjs.html(
-        }
+                hasPrivilege
-    }
+                    ? actionButtons
+                    : '<span class="text-muted">No Privilege</span>'
+            );
+        },
+    },
 ];
 
 document.addEventListener("DOMContentLoaded", () => {

resources/js/data/advertisements/form-create-update.js

@@ -5,6 +5,8 @@ document.addEventListener("DOMContentLoaded", function () {
     const modalButton = document.querySelector(".btn-modal");
     const form = document.querySelector("form#create-update-form");
     var authLogo = document.querySelector(".auth-logo");
+    let menuId = document.getElementById("menuId").value;
+    console.log(menuId);
 
     if (!saveButton || !form) return;
 
@@ -73,7 +75,7 @@ document.addEventListener("DOMContentLoaded", function () {
                     }, 2000);
 
                     setTimeout(() => {
-                        window.location.href = "/data/web-advertisements";
+                        window.location.href = `/data/web-advertisements?menu_id=${menuId}`;
                     }, 1000);
                 } else {
                     if (authLogo) {

resources/js/data/advertisements/form-upload.js

@@ -28,6 +28,7 @@ console.log(dropzonePreviewNode);
                     .getAttribute("content")}`,
             },
             init: function () {
+                let menuId = document.getElementById("menuId").value;
                 // Listen for the success event
                 this.on("success", function (file, response) {
                     console.log("File successfully uploaded:", file);
@@ -39,7 +40,7 @@ console.log(dropzonePreviewNode);
                         "Upload Files";
                     // Tunggu sebentar lalu reload halaman
                     setTimeout(() => {
-                        window.location.href = "/data/web-advertisements";
+                        window.location.href = `/data/web-advertisements?menu_id=${menuId}`;
                     }, 2000);
                 });
                 // Listen for the error event

resources/js/data/google-sheet/index.js

@@ -41,8 +41,8 @@ class GoogleSheets {
         tableContainer.innerHTML = "";
 
         // Get user permissions from data attributes
-        let canUpdate = tableContainer.getAttribute("data-updater") === "1";
+        // let canUpdate = tableContainer.getAttribute("data-updater") === "1";
-        let canDelete = tableContainer.getAttribute("data-destroyer") === "1";
+        // let canDelete = tableContainer.getAttribute("data-destroyer") === "1";
 
         this.table = new Grid({
             columns: [
@@ -65,25 +65,25 @@ class GoogleSheets {
                           </a>
                         `;
 
-                        if (canUpdate) {
+                        // if (canUpdate) {
-                            buttons += `
+                        //     buttons += `
-                            <a href="#" class="btn btn-yellow btn-sm d-inline-flex align-items-center justify-content-center">
+                        //     <a href="#" class="btn btn-yellow btn-sm d-inline-flex align-items-center justify-content-center">
-                                <i class='bx bx-edit'></i>
+                        //         <i class='bx bx-edit'></i>
-                            </a>
+                        //     </a>
-                        `;
+                        // `;
-                        }
+                        // }
 
-                        if (canDelete) {
+                        // if (canDelete) {
-                            buttons += `
+                        //     buttons += `
-                            <button data-id="${cell}" class="btn btn-sm btn-red btn-delete-google-sheet d-inline-flex align-items-center justify-content-center">
+                        //     <button data-id="${cell}" class="btn btn-sm btn-red btn-delete-google-sheet d-inline-flex align-items-center justify-content-center">
-                                <i class='bx bxs-trash'></i>
+                        //         <i class='bx bxs-trash'></i>
-                            </button>
+                        //     </button>
-                        `;
+                        // `;
-                        }
+                        // }
 
-                        if (!canUpdate && !canDelete) {
+                        // if (!canUpdate && !canDelete) {
-                            buttons = `<span class="text-muted">No Privilege</span>`;
+                        //     buttons = `<span class="text-muted">No Privilege</span>`;
-                        }
+                        // }
 
                         return gridjs.html(
                             `<div class="d-flex justify-content-center gap-2">${buttons}</div>`

resources/js/data/spatialPlannings/data-spatialPlannings.js

@@ -8,6 +8,7 @@ import GeneralTable from "../../table-generator.js";
 const tableElement = document.getElementById("spatial-planning-data-table");
 const canUpdate = tableElement.getAttribute("data-updater") === "1";
 const canDelete = tableElement.getAttribute("data-destroyer") === "1";
+let menuId = document.getElementById("menuId").value;
 
 const dataSpatialPlanningColumns = [
     "No",
@@ -23,7 +24,7 @@ const dataSpatialPlanningColumns = [
         widht: "120px",
         formatter: function (cell, row) {
             const id = row.cells[8].data;
-            const model = "data/spatial-plannings";
+            const model = "data/web-spatial-plannings";
 
             let actionButtons = '<div class="d-flex justify-items-end gap-10">';
             let hasPrivilege = false;
@@ -34,7 +35,8 @@ const dataSpatialPlanningColumns = [
                 actionButtons += `
                     <button class="btn btn-warning me-2 btn-edit" 
                         data-id="${id}" 
-                        data-model="${model}">
+                        data-model="${model}"
+                        data-menu="${menuId}">
                         <i class='bx bx-edit'></i>
                     </button>`;
             }
@@ -49,10 +51,14 @@ const dataSpatialPlanningColumns = [
                     </button>`;
             }
 
-            actionButtons += '</div>';
+            actionButtons += "</div>";
 
             // Jika tidak memiliki akses, tampilkan teks "No Privilege"
-            return gridjs.html(hasPrivilege ? actionButtons : '<span class="text-muted">No Privilege</span>');
+            return gridjs.html(
+                hasPrivilege
+                    ? actionButtons
+                    : '<span class="text-muted">No Privilege</span>'
+            );
         },
     },
 ];

resources/js/data/spatialPlannings/form-create-update.js

@@ -5,6 +5,7 @@ document.addEventListener("DOMContentLoaded", function () {
     const modalButton = document.querySelector(".btn-modal");
     const form = document.querySelector("form#create-update-form");
     var authLogo = document.querySelector(".auth-logo");
+    let menuId = document.getElementById("menuId").value;
 
     if (!saveButton || !form) return;
 
@@ -73,7 +74,7 @@ document.addEventListener("DOMContentLoaded", function () {
                     }, 3000);
 
                     setTimeout(() => {
-                        window.location.href = "/data/web-spatial-plannings";
+                        window.location.href = `/data/web-spatial-plannings?menu_id=${menuId}`;
                     }, 3000);
                 } else {
                     if (authLogo) {

resources/js/data/spatialPlannings/form-upload.js

@@ -28,6 +28,7 @@ console.log(dropzonePreviewNode);
                     .getAttribute("content")}`,
             },
             init: function () {
+                let menuId = document.getElementById("menuId").value;
                 // Listen for the success event
                 this.on("success", function (file, response) {
                     console.log("File successfully uploaded:", file);
@@ -39,7 +40,7 @@ console.log(dropzonePreviewNode);
                         "Upload Files";
                     // Tunggu sebentar lalu reload halaman
                     setTimeout(() => {
-                        window.location.href = "/data/web-spatial-plannings";
+                        window.location.href = `/data/web-spatial-plannings?menu_id=${menuId}`;
                     }, 2000);
                 });
                 // Listen for the error event

resources/js/data/tourisms/data-tourisms.js

@@ -11,6 +11,7 @@ const tableElement = document.getElementById("tourisms-data-table");
 const canView = "1";
 const canUpdate = tableElement.getAttribute("data-updater") === "1";
 const canDelete = tableElement.getAttribute("data-destroyer") === "1";
+let menuId = document.getElementById("menuId").value;
 
 const dataTourismsColumns = [
     "No",
@@ -32,7 +33,7 @@ const dataTourismsColumns = [
             const district = row.cells[4].data;
             const long = row.cells[9].data;
             const lat = row.cells[10].data;
-            const model = "data/tourisms";
+            const model = "data/web-tourisms";
 
             let actionButtons = '<div class="d-flex justify-items-end gap-10">';
             let hasPrivilege = false;
@@ -53,7 +54,8 @@ const dataTourismsColumns = [
                 actionButtons += `
                     <button class="btn btn-warning me-2 btn-edit"
                         data-id="${id}"
-                        data-model="${model}">
+                        data-model="${model}"
+                        data-menu="${menuId}">
                         <i class='bx bx-edit'></i>
                     </button>`;
             }

resources/js/data/tourisms/form-create-update.js

@@ -5,6 +5,7 @@ document.addEventListener("DOMContentLoaded", function () {
     const modalButton = document.querySelector(".btn-modal");
     const form = document.querySelector("form#create-update-form");
     var authLogo = document.querySelector(".auth-logo");
+    let menuId = document.getElementById("menuId").value;
 
     if (!saveButton || !form) return;
 
@@ -73,7 +74,7 @@ document.addEventListener("DOMContentLoaded", function () {
                     }, 3000);
 
                     setTimeout(() => {
-                        window.location.href = "/data/web-tourisms";
+                        window.location.href = `/data/web-tourisms?menu_id=${menuId}`;
                     }, 3000);
                 } else {
                     if (authLogo) {

resources/js/data/tourisms/form-upload.js

@@ -28,6 +28,7 @@ console.log(dropzonePreviewNode);
                     .getAttribute("content")}`,
             },
             init: function () {
+                let menuId = document.getElementById("menuId").value;
                 // Listen for the success event
                 this.on("success", function (file, response) {
                     console.log("File successfully uploaded:", file);
@@ -39,7 +40,7 @@ console.log(dropzonePreviewNode);
                         "Upload Files";
                     // Tunggu sebentar lalu reload halaman
                     setTimeout(() => {
-                        window.location.href = "/data/web-tourisms";
+                        window.location.href = `/data/web-tourisms?menu_id=${menuId}`;
                     }, 2000);
                 });
                 // Listen for the error event

resources/js/data/umkm/data-umkm.js

@@ -7,6 +7,7 @@ import GeneralTable from "../../table-generator.js";
 const tableElement = document.getElementById("umkm-data-table");
 const canUpdate = tableElement.getAttribute("data-updater") === "1";
 const canDelete = tableElement.getAttribute("data-destroyer") === "1";
+let menuId = document.getElementById("menuId").value;
 
 const dataUMKMColumns = [
     "No",
@@ -31,9 +32,9 @@ const dataUMKMColumns = [
     {
         name: "Actions",
         widht: "120px",
-        formatter: function(cell, row) {
+        formatter: function (cell, row) {
             const id = row.cells[19].data;
-            const model = "data/umkm";
+            const model = "data/web-umkm";
 
             let actionButtons = '<div class="d-flex justify-items-end gap-10">';
             let hasPrivilege = false;
@@ -44,7 +45,8 @@ const dataUMKMColumns = [
                 actionButtons += `
                     <button class="btn btn-warning me-2 btn-edit" 
                         data-id="${id}" 
-                        data-model="${model}">
+                        data-model="${model}"
+                        data-menu="${menuId}">
                         <i class='bx bx-edit'></i>
                     </button>`;
             }
@@ -59,12 +61,16 @@ const dataUMKMColumns = [
                     </button>`;
             }
 
-            actionButtons += '</div>';
+            actionButtons += "</div>";
 
             // Jika tidak memiliki akses, tampilkan teks "No Privilege"
-            return gridjs.html(hasPrivilege ? actionButtons : '<span class="text-muted">No Privilege</span>');
+            return gridjs.html(
-        }
+                hasPrivilege
-    }
+                    ? actionButtons
+                    : '<span class="text-muted">No Privilege</span>'
+            );
+        },
+    },
 ];
 
 document.addEventListener("DOMContentLoaded", () => {

resources/js/data/umkm/form-create-update.js

@@ -5,6 +5,7 @@ document.addEventListener("DOMContentLoaded", function () {
     const modalButton = document.querySelector(".btn-modal");
     const form = document.querySelector("form#create-update-form");
     var authLogo = document.querySelector(".auth-logo");
+    let menuId = document.getElementById("menuId").value;
 
     if (!saveButton || !form) return;
 
@@ -74,7 +75,7 @@ document.addEventListener("DOMContentLoaded", function () {
                     }, 2000);
 
                     setTimeout(() => {
-                        window.location.href = "/data/web-umkm";
+                        window.location.href = `/data/web-umkm?menu_id=${menuId}`;
                     }, 1000);
                 } else {
                     if (authLogo) {

resources/js/data/umkm/form-upload.js

@@ -28,6 +28,7 @@ console.log(dropzonePreviewNode);
                     .getAttribute("content")}`,
             },
             init: function () {
+                let menuId = document.getElementById("menuId").value;
                 // Listen for the success event
                 this.on("success", function (file, response) {
                     console.log("File successfully uploaded:", file);
@@ -39,7 +40,7 @@ console.log(dropzonePreviewNode);
                         "Upload Files";
                     // Tunggu sebentar lalu reload halaman
                     setTimeout(() => {
-                        window.location.href = "/data/web-umkm";
+                        window.location.href = `/data/web-umkm?menu_id=${menuId}`;
                     }, 2000);
                 });
                 // Listen for the error event

resources/js/master/users/create.js

@@ -1,6 +1,7 @@
 document.addEventListener("DOMContentLoaded", function (e) {
     const toastNotification = document.getElementById("toastNotification");
     const toast = new bootstrap.Toast(toastNotification);
+    let menuId = document.getElementById("menuId").value;
     document
         .getElementById("btnCreateUsers")
         .addEventListener("click", async function () {
@@ -45,7 +46,7 @@ document.addEventListener("DOMContentLoaded", function (e) {
                         result.message;
                     toast.show();
                     setTimeout(() => {
-                        window.location.href = "/master/users";
+                        window.location.href = `/master/users?menu_id=${menuId}`;
                     }, 2000);
                 } else {
                     let error = await response.json();

resources/js/master/users/update.js

@@ -6,6 +6,7 @@ document.addEventListener("DOMContentLoaded", function (e) {
     let toast = new bootstrap.Toast(
         document.getElementById("toastNotification")
     );
+    let menuId = document.getElementById("menuId").value;
     submitButton.addEventListener("click", async function () {
         let submitButton = this;
 
@@ -36,7 +37,7 @@ document.addEventListener("DOMContentLoaded", function (e) {
                 toastMessage.innerText = result.message;
                 toast.show();
                 setTimeout(() => {
-                    window.location.href = "/master/users";
+                    window.location.href = `/master/users?menu_id=${menuId}`;
                 }, 2000);
             } else {
                 let error = await response.json();

resources/js/master/users/users.js

@@ -2,20 +2,35 @@ import { Grid } from "gridjs/dist/gridjs.umd.js";
 import gridjs from "gridjs/dist/gridjs.umd.js";
 import "gridjs/dist/gridjs.umd.js";
 import GlobalConfig from "../../global-config";
+import Swal from "sweetalert2";
 
 class UsersTable {
-    init() {
+    constructor() {
+        this.toastMessage = document.getElementById("toast-message");
+        this.toastElement = document.getElementById("toastNotification");
+        this.toast = new bootstrap.Toast(this.toastElement);
+        this.table = null;
         this.initTableUsers();
+        this.initEvents();
+    }
+    initEvents() {
+        document.body.addEventListener("click", async (event) => {
+            const deleteButton = event.target.closest(".btn-delete-users");
+            if (deleteButton) {
+                event.preventDefault();
+                await this.handleDelete(deleteButton);
+            }
+        });
     }
 
     initTableUsers() {
-        let tableContainer = document.getElementById(
+        let tableContainer = document.getElementById("table-users");
-            "table-users"
+        let menuId = tableContainer.getAttribute("data-menuId");
-        );
 
         tableContainer.innerHTML = "";
         let canUpdate = tableContainer.getAttribute("data-updater") === "1";
-        new Grid({
+        let canDestroy = tableContainer.getAttribute("data-destroyer") === "1";
+        this.table = new Grid({
             columns: [
                 "ID",
                 "Name",
@@ -26,17 +41,29 @@ class UsersTable {
                 "Roles",
                 {
                     name: "Action",
-                    formatter: (cell) =>{
+                    formatter: (cell) => {
-                        if (!canUpdate) {
+                        if (!canUpdate && !canDestroy) {
-                            return gridjs.html(`<span class="text-muted">No Privilege</span>`);
+                            return gridjs.html(
+                                `<span class="text-muted">No Privilege</span>`
+                            );
                         }
-                        return gridjs.html(`
+
-                            <div class="d-flex justify-content-center">
+                        let buttons = `<div class="d-flex justify-content-center align-items-center gap-2">`;
-                                <a href="/master/users/${cell}/edit" class="btn btn-yellow btn-sm d-inline-flex align-items-center justify-content-center">
+
+                        buttons += `
+                                <a href="/master/users/${cell}/edit?menu_id=${menuId}" class="btn btn-yellow btn-sm d-inline-flex align-items-center justify-content-center">
                                     <i class='bx bx-edit'></i>
                                 </a>
-                            </div>
+                            `;
-                        `);
+                        buttons += `
+                                <button data-id="${cell}" class="btn btn-sm btn-red btn-delete-users d-inline-flex align-items-center justify-content-center">
+                                    <i class='bx bxs-trash'></i>
+                                </button>
+                            `;
+
+                        buttons += `</div>`;
+
+                        return gridjs.html(buttons);
                     },
                 },
             ],
@@ -66,7 +93,6 @@ class UsersTable {
                     "Content-Type": "application/json",
                 },
                 then: (data) => {
-                    console.log(data.data);
                     return data.data.map((item) => [
                         item.id,
                         item.name,
@@ -82,8 +108,62 @@ class UsersTable {
             },
         }).render(document.getElementById("table-users"));
     }
+
+    async handleDelete(button) {
+        const id = button.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/users/${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 UsersTable().init();
+    new UsersTable();
 });

resources/js/menus/create.js

@@ -6,6 +6,7 @@ class CreateMenu {
     initCreateMenu() {
         const toastNotification = document.getElementById("toastNotification");
         const toast = new bootstrap.Toast(toastNotification);
+        let menuId = document.getElementById("menuId").value;
         document
             .getElementById("btnCreateMenus")
             .addEventListener("click", async function () {
@@ -41,7 +42,7 @@ class CreateMenu {
                             result.message;
                         toast.show();
                         setTimeout(() => {
-                            window.location.href = "/menus";
+                            window.location.href = `/menus?menu_id=${menuId}`;
                         }, 2000);
                     } else {
                         let error = await response.json();

resources/js/menus/index.js

@@ -31,6 +31,7 @@ class Menus {
         tableContainer.innerHTML = "";
         let canUpdate = tableContainer.getAttribute("data-updater") === "1";
         let canDelete = tableContainer.getAttribute("data-destroyer") === "1";
+        let menuId = tableContainer.getAttribute("data-menuId");
 
         this.table = new Grid({
             columns: [
@@ -38,7 +39,7 @@ class Menus {
                 "Name",
                 "Url",
                 "Icon",
-                "ParentID",
+                "Parent Name",
                 "Sort Order",
                 {
                     name: "Action",
@@ -47,7 +48,7 @@ class Menus {
 
                         if (canUpdate) {
                             buttons += `
-                                <a href="/menus/${cell}/edit" class="btn btn-yellow btn-sm d-inline-flex align-items-center justify-content-center">
+                                <a href="/menus/${cell}/edit?menu_id=${menuId}" class="btn btn-yellow btn-sm d-inline-flex align-items-center justify-content-center">
                                     <i class='bx bx-edit'></i>
                                 </a>
                             `;
@@ -96,16 +97,22 @@ class Menus {
                         .getAttribute("content")}`,
                     "Content-Type": "application/json",
                 },
-                then: (data) =>
+                then: (data) => {
-                    data.data.map((item) => [
+                    console.log("Full API Response:", data); // Log the full response
-                        item.id,
+
-                        item.name,
+                    return data.data.map((item, index) => {
-                        item.url,
+                        console.log(`Item ${index + 1}:`, item); // Log each item
-                        item.icon,
+                        return [
-                        item.parent_id,
+                            item.id,
-                        item.sort_order,
+                            item.name,
-                        item.id,
+                            item.url,
-                    ]),
+                            item.icon,
+                            item.parent?.name,
+                            item.sort_order,
+                            item.id,
+                        ];
+                    });
+                },
                 total: (data) => data.total,
             },
         }).render(tableContainer);

resources/js/menus/update.js

@@ -6,6 +6,7 @@ class UpdateMenu {
     initUpdateMenu() {
         const toastNotification = document.getElementById("toastNotification");
         const toast = new bootstrap.Toast(toastNotification);
+        let menuId = document.getElementById("menuId").value;
         document
             .getElementById("btnUpdateMenus")
             .addEventListener("click", async function () {
@@ -41,7 +42,7 @@ class UpdateMenu {
                             result.message;
                         toast.show();
                         setTimeout(() => {
-                            window.location.href = "/menus";
+                            window.location.href = `/menus?menu_id=${menuId}`;
                         }, 2000);
                     } else {
                         let error = await response.json();

resources/js/payment-recaps/index.js

@@ -11,8 +11,15 @@ class PaymentRecaps {
         this.toastElement = document.getElementById("toastNotification");
         this.toast = new bootstrap.Toast(this.toastElement);
         this.table = null;
+        this.startDate = undefined;
+        this.endDate = undefined;
+    }
+    init() {
         this.initTablePaymentRecaps();
         this.initFilterDatepicker();
+        this.handleFilterBtn();
+        this.handleExportPDF();
+        this.handleExportToExcel();
     }
     initFilterDatepicker() {
         new InitDatePicker(
@@ -20,8 +27,13 @@ class PaymentRecaps {
             this.handleChangeFilterDate.bind(this)
         ).init();
     }
-    handleChangeFilterDate(strDate) {
+    handleChangeFilterDate(filterDate) {
-        console.log("filter date : ", strDate);
+        this.startDate = moment(filterDate, "YYYY-MM-DD")
+            .startOf("day")
+            .format("YYYY-MM-DD");
+        this.endDate = moment(filterDate, "YYYY-MM-DD")
+            .endOf("day")
+            .format("YYYY-MM-DD");
     }
     formatCategory(category) {
         const categoryMap = {
@@ -41,64 +53,208 @@ class PaymentRecaps {
     initTablePaymentRecaps() {
         let tableContainer = document.getElementById("table-payment-recaps");
 
-        this.table = new Grid({
+        // Fetch data from the server
-            columns: [
+        fetch(
-                { name: "Kategori", data: (row) => row[0] },
+            `${GlobalConfig.apiHost}/api/payment-recaps?start_date=${
-                { name: "Nominal", data: (row) => row[1] },
+                this.startDate || ""
-                {
+            }&end_date=${this.endDate || ""}`,
-                    name: "Created",
+            {
-                    data: (row) => row[2],
-                    attributes: { style: "width: 200px; white-space: nowrap;" },
-                },
-            ],
-            pagination: {
-                limit: 10,
-                server: {
-                    url: (prev, page) =>
-                        `${prev}${prev.includes("?") ? "&" : "?"}page=${
-                            page + 1
-                        }`,
-                },
-            },
-            sort: true,
-            server: {
-                url: `${GlobalConfig.apiHost}/api/payment-recaps`,
                 headers: {
                     Authorization: `Bearer ${document
                         .querySelector('meta[name="api-token"]')
                         .getAttribute("content")}`,
                     "Content-Type": "application/json",
                 },
-                then: (response) => {
+            }
-                    console.log("API Response:", response); // Debugging
+        )
+            .then((response) => response.json())
+            .then((data) => {
+                if (!data || !Array.isArray(data.data)) {
+                    console.error("Error: Data is not an array", data);
+                    return;
+                }
 
-                    if (!response.data || !Array.isArray(response.data)) {
+                let formattedData = data.data.map((item) => [
-                        console.error(
+                    this.formatCategory(item.category ?? "Unknown"),
-                            "Error: Data is not an array",
+                    addThousandSeparators(Number(item.nominal).toString() || 0),
-                            response.data
+                    moment(item.created_at).isValid()
-                        );
+                        ? moment(item.created_at).format("YYYY-MM-DD H:mm:ss")
-                        return [];
+                        : "-",
-                    }
+                ]);
 
-                    return response.data.map((item) => [
+                // 🔥 If the table already exists, update it instead of re-creating
-                        this.formatCategory(item.category ?? "Unknown"), // Ensure category is not null
+                if (this.table) {
-                        addThousandSeparators(
+                    this.table
-                            Number(item.nominal).toString() || 0
+                        .updateConfig({
-                        ), // Ensure nominal is a valid number
+                            data: formattedData.length > 0 ? formattedData : [],
-                        moment(item.created_at).isValid()
+                        })
-                            ? moment(item.created_at).format(
+                        .forceRender();
-                                  "YYYY-MM-DD H:mm:ss"
+                } else {
-                              )
+                    // 🔹 First-time initialization
-                            : "-", // Handle invalid dates
+                    this.table = new Grid({
-                    ]);
+                        columns: [
-                },
+                            { name: "Kategori", data: (row) => row[0] },
-                total: (response) => response.pagination?.total || 0,
+                            { name: "Nominal", data: (row) => row[1] },
-            },
+                            {
-            width: "auto",
+                                name: "Created",
-            fixedHeader: true,
+                                data: (row) => row[2],
-        }).render(tableContainer);
+                                attributes: {
+                                    style: "width: 200px; white-space: nowrap;",
+                                },
+                            },
+                        ],
+                        pagination: {
+                            limit: 50,
+                        },
+                        sort: true,
+                        data: formattedData.length > 0 ? formattedData : [],
+                        width: "auto",
+                        fixedHeader: true,
+                    }).render(tableContainer);
+                }
+            })
+            .catch((error) => console.error("Error fetching data:", error));
+    }
+
+    async handleFilterBtn() {
+        const filterBtn = document.getElementById("btnFilterData");
+        if (!filterBtn) {
+            console.error("Button not found: #btnFilterData");
+            return;
+        }
+        filterBtn.addEventListener("click", async () => {
+            if (!this.startDate || !this.endDate) {
+                console.log("No date filter applied, using default data");
+            } else {
+                console.log(
+                    `Filtering with dates: ${this.startDate} - ${this.endDate}`
+                );
+            }
+
+            // Reinitialize table with updated filters
+            this.initTablePaymentRecaps();
+        });
+    }
+
+    async handleExportToExcel() {
+        const button = document.getElementById("btn-export-excel");
+        if (!button) {
+            console.error("Button not found: #btn-export-excel");
+            return;
+        }
+
+        button.addEventListener("click", async () => {
+            button.disabled = true;
+            let exportUrl = new URL(button.getAttribute("data-url"));
+
+            if (this.startDate) {
+                exportUrl.searchParams.append("start_date", this.startDate);
+            } else {
+                console.warn("⚠️ start_date is missing");
+            }
+
+            if (this.endDate) {
+                exportUrl.searchParams.append("end_date", this.endDate);
+            } else {
+                console.warn("⚠️ end_date is missing");
+            }
+
+            // Final check
+            console.log("Final Export URL:", exportUrl.toString());
+            try {
+                const response = await fetch(`${exportUrl}`, {
+                    method: "GET",
+                    credentials: "include",
+                    headers: {
+                        Authorization: `Bearer ${document
+                            .querySelector('meta[name="api-token"]')
+                            .getAttribute("content")}`,
+                    },
+                });
+                if (!response.ok) {
+                    console.error("Error fetching data:", response.statusText);
+                    button.disabled = false;
+                    return;
+                }
+
+                // Convert response to Blob and trigger download
+                const blob = await response.blob();
+                const url = window.URL.createObjectURL(blob);
+                const a = document.createElement("a");
+                a.href = url;
+                a.download = "rekap-pembayaran.xlsx";
+                document.body.appendChild(a);
+                a.click();
+                document.body.removeChild(a);
+                window.URL.revokeObjectURL(url);
+            } catch (error) {
+                console.error("Error fetching data:", error);
+                button.disabled = false;
+                return;
+            } finally {
+                button.disabled = false;
+            }
+        });
+    }
+
+    async handleExportPDF() {
+        const button = document.getElementById("btn-export-pdf");
+        if (!button) {
+            console.error("Button not found: #btn-export-pdf");
+            return;
+        }
+
+        button.addEventListener("click", async () => {
+            button.disabled = true;
+            let exportUrl = new URL(button.getAttribute("data-url"));
+
+            if (this.startDate) {
+                exportUrl.searchParams.append("start_date", this.startDate);
+            } else {
+                console.warn("⚠️ start_date is missing");
+            }
+
+            if (this.endDate) {
+                exportUrl.searchParams.append("end_date", this.endDate);
+            } else {
+                console.warn("⚠️ end_date is missing");
+            }
+            try {
+                const response = await fetch(`${exportUrl}`, {
+                    method: "GET",
+                    credentials: "include",
+                    headers: {
+                        Authorization: `Bearer ${document
+                            .querySelector('meta[name="api-token"]')
+                            .getAttribute("content")}`,
+                    },
+                });
+                if (!response.ok) {
+                    console.error("Error fetching data:", response.statusText);
+                    button.disabled = false;
+                    return;
+                }
+
+                // Convert response to Blob and trigger download
+                const blob = await response.blob();
+                const url = window.URL.createObjectURL(blob);
+                const a = document.createElement("a");
+                a.href = url;
+                a.download = "rekap-pembayaran.pdf";
+                document.body.appendChild(a);
+                a.click();
+                document.body.removeChild(a);
+                window.URL.revokeObjectURL(url);
+            } catch (error) {
+                console.error("Error fetching data:", error);
+                button.disabled = false;
+                return;
+            } finally {
+                button.disabled = false;
+            }
+        });
     }
 }
 document.addEventListener("DOMContentLoaded", function (e) {
-    new PaymentRecaps();
+    new PaymentRecaps().init();
 });

resources/js/report-payment-recaps/index.js

@@ -7,6 +7,8 @@ class ReportPaymentRecaps {
     constructor() {
         this.table = null;
         this.initTableReportPaymentRecaps();
+        this.handleExportPDF();
+        this.handleExportToExcel();
     }
     initTableReportPaymentRecaps() {
         let tableContainer = document.getElementById(
@@ -63,6 +65,100 @@ class ReportPaymentRecaps {
             fixedHeader: true,
         }).render(tableContainer);
     }
+
+    async handleExportToExcel() {
+        const button = document.getElementById("btn-export-excel");
+        if (!button) {
+            console.error("Button not found: #btn-export-excel");
+            return;
+        }
+
+        let exportUrl = button.getAttribute("data-url");
+
+        button.addEventListener("click", async () => {
+            button.disabled = true;
+            try {
+                const response = await fetch(`${exportUrl}`, {
+                    method: "GET",
+                    credentials: "include",
+                    headers: {
+                        Authorization: `Bearer ${document
+                            .querySelector('meta[name="api-token"]')
+                            .getAttribute("content")}`,
+                    },
+                });
+                if (!response.ok) {
+                    console.error("Error fetching data:", response.statusText);
+                    button.disabled = false;
+                    return;
+                }
+
+                // Convert response to Blob and trigger download
+                const blob = await response.blob();
+                const url = window.URL.createObjectURL(blob);
+                const a = document.createElement("a");
+                a.href = url;
+                a.download = "laporan-rekap-data-pembayaran.xlsx";
+                document.body.appendChild(a);
+                a.click();
+                document.body.removeChild(a);
+                window.URL.revokeObjectURL(url);
+            } catch (error) {
+                console.error("Error fetching data:", error);
+                button.disabled = false;
+                return;
+            } finally {
+                button.disabled = false;
+            }
+        });
+    }
+
+    async handleExportPDF() {
+        const button = document.getElementById("btn-export-pdf");
+        if (!button) {
+            console.error("Button not found: #btn-export-pdf");
+            return;
+        }
+
+        let exportUrl = button.getAttribute("data-url");
+
+        button.addEventListener("click", async () => {
+            button.disabled = true;
+            try {
+                const response = await fetch(`${exportUrl}`, {
+                    method: "GET",
+                    credentials: "include",
+                    headers: {
+                        Authorization: `Bearer ${document
+                            .querySelector('meta[name="api-token"]')
+                            .getAttribute("content")}`,
+                    },
+                });
+                if (!response.ok) {
+                    console.error("Error fetching data:", response.statusText);
+                    button.disabled = false;
+                    return;
+                }
+
+                // Convert response to Blob and trigger download
+                const blob = await response.blob();
+                const url = window.URL.createObjectURL(blob);
+                const a = document.createElement("a");
+                a.href = url;
+                a.download = "laporan-rekap-data-pembayaran.pdf";
+                document.body.appendChild(a);
+                a.click();
+                document.body.removeChild(a);
+                window.URL.revokeObjectURL(url);
+            } catch (error) {
+                console.error("Error fetching data:", error);
+                button.disabled = false;
+                return;
+            } finally {
+                button.disabled = false;
+            }
+        });
+    }
 }
 document.addEventListener("DOMContentLoaded", function (e) {
     new ReportPaymentRecaps();

resources/js/report-pbg-ptsp/index.js

@@ -7,6 +7,8 @@ class ReportPbgPTSP {
     constructor() {
         this.table = null;
         this.initTableReportPbgPTSP();
+        this.handleExportToExcel();
+        this.handleExportPDF();
     }
     initTableReportPbgPTSP() {
         let tableContainer = document.getElementById("table-report-pbg-ptsp");
@@ -61,6 +63,99 @@ class ReportPbgPTSP {
             fixedHeader: true,
         }).render(tableContainer);
     }
+    async handleExportToExcel() {
+        const button = document.getElementById("btn-export-excel");
+        if (!button) {
+            console.error("Button not found: #btn-export-excel");
+            return;
+        }
+
+        let exportUrl = button.getAttribute("data-url");
+
+        button.addEventListener("click", async () => {
+            button.disabled = true;
+            try {
+                const response = await fetch(`${exportUrl}`, {
+                    method: "GET",
+                    credentials: "include",
+                    headers: {
+                        Authorization: `Bearer ${document
+                            .querySelector('meta[name="api-token"]')
+                            .getAttribute("content")}`,
+                    },
+                });
+                if (!response.ok) {
+                    console.error("Error fetching data:", response.statusText);
+                    button.disabled = false;
+                    return;
+                }
+
+                // Convert response to Blob and trigger download
+                const blob = await response.blob();
+                const url = window.URL.createObjectURL(blob);
+                const a = document.createElement("a");
+                a.href = url;
+                a.download = "laporan-ptsp.xlsx";
+                document.body.appendChild(a);
+                a.click();
+                document.body.removeChild(a);
+                window.URL.revokeObjectURL(url);
+            } catch (error) {
+                console.error("Error fetching data:", error);
+                button.disabled = false;
+                return;
+            } finally {
+                button.disabled = false;
+            }
+        });
+    }
+
+    async handleExportPDF() {
+        const button = document.getElementById("btn-export-pdf");
+        if (!button) {
+            console.error("Button not found: #btn-export-pdf");
+            return;
+        }
+
+        let exportUrl = button.getAttribute("data-url");
+
+        button.addEventListener("click", async () => {
+            button.disabled = true;
+            try {
+                const response = await fetch(`${exportUrl}`, {
+                    method: "GET",
+                    credentials: "include",
+                    headers: {
+                        Authorization: `Bearer ${document
+                            .querySelector('meta[name="api-token"]')
+                            .getAttribute("content")}`,
+                    },
+                });
+                if (!response.ok) {
+                    console.error("Error fetching data:", response.statusText);
+                    button.disabled = false;
+                    return;
+                }
+
+                // Convert response to Blob and trigger download
+                const blob = await response.blob();
+                const url = window.URL.createObjectURL(blob);
+                const a = document.createElement("a");
+                a.href = url;
+                a.download = "laporan-ptsp.pdf";
+                document.body.appendChild(a);
+                a.click();
+                document.body.removeChild(a);
+                window.URL.revokeObjectURL(url);
+            } catch (error) {
+                console.error("Error fetching data:", error);
+                button.disabled = false;
+                return;
+            } finally {
+                button.disabled = false;
+            }
+        });
+    }
 }
 document.addEventListener("DOMContentLoaded", function (e) {
     new ReportPbgPTSP();

resources/js/report/tourisms/index.js

@@ -3,14 +3,121 @@ import "gridjs/dist/gridjs.umd.js";
 
 // Mengambil data dari input dengan id="business_type_counts"
 const businessTypeCountsElement = document.getElementById("tourism_based_KBLI");
-console.log(businessTypeCountsElement); 
+const businessTypeCounts = JSON.parse(businessTypeCountsElement.value); // Cek apakah data sudah terbawa dengan benar
-const businessTypeCounts = JSON.parse(businessTypeCountsElement.value);  // Cek apakah data sudah terbawa dengan benar
 
 // Membuat Grid.js instance
 new gridjs.Grid({
-    columns: ["Jenis Bisnis Pariwisata", "Jumlah Total"],  // Nama kolom
+    columns: ["Jenis Bisnis Pariwisata", "Jumlah Total"], // Nama kolom
-    data: businessTypeCounts.map(item => [item.kbli_title, item.total_records]),  // Mengubah data untuk Grid.js
+    data: businessTypeCounts.map((item) => [
-    search: true,  // Menambahkan fitur pencarian
+        item.kbli_title,
-    pagination: true,  // Menambahkan fitur pagination
+        item.total_records,
-    sort: true,  // Menambahkan fitur sorting
+    ]), // Mengubah data untuk Grid.js
+    search: true, // Menambahkan fitur pencarian
+    pagination: true, // Menambahkan fitur pagination
+    sort: true, // Menambahkan fitur sorting
 }).render(document.getElementById("tourisms-report-data-table"));
+
+class TourismReport {
+    init() {
+        this.handleExportToExcel();
+        this.handleExportPDF();
+    }
+
+    async handleExportToExcel() {
+        const button = document.getElementById("btn-export-excel");
+        if (!button) {
+            console.error("Button not found: #btn-export-excel");
+            return;
+        }
+
+        let exportUrl = button.getAttribute("data-url");
+
+        button.addEventListener("click", async () => {
+            button.disabled = true;
+            try {
+                const response = await fetch(`${exportUrl}`, {
+                    method: "GET",
+                    credentials: "include",
+                    headers: {
+                        Authorization: `Bearer ${document
+                            .querySelector('meta[name="api-token"]')
+                            .getAttribute("content")}`,
+                    },
+                });
+                if (!response.ok) {
+                    console.error("Error fetching data:", response.statusText);
+                    button.disabled = false;
+                    return;
+                }
+
+                // Convert response to Blob and trigger download
+                const blob = await response.blob();
+                const url = window.URL.createObjectURL(blob);
+                const a = document.createElement("a");
+                a.href = url;
+                a.download = "laporan-pariwisata.xlsx";
+                document.body.appendChild(a);
+                a.click();
+                document.body.removeChild(a);
+                window.URL.revokeObjectURL(url);
+            } catch (error) {
+                console.error("Error fetching data:", error);
+                button.disabled = false;
+                return;
+            } finally {
+                button.disabled = false;
+            }
+        });
+    }
+
+    async handleExportPDF() {
+        const button = document.getElementById("btn-export-pdf");
+        if (!button) {
+            console.error("Button not found: #btn-export-pdf");
+            return;
+        }
+
+        let exportUrl = button.getAttribute("data-url");
+
+        button.addEventListener("click", async () => {
+            button.disabled = true;
+            try {
+                const response = await fetch(`${exportUrl}`, {
+                    method: "GET",
+                    credentials: "include",
+                    headers: {
+                        Authorization: `Bearer ${document
+                            .querySelector('meta[name="api-token"]')
+                            .getAttribute("content")}`,
+                    },
+                });
+                if (!response.ok) {
+                    console.error("Error fetching data:", response.statusText);
+                    button.disabled = false;
+                    return;
+                }
+
+                // Convert response to Blob and trigger download
+                const blob = await response.blob();
+                const url = window.URL.createObjectURL(blob);
+                const a = document.createElement("a");
+                a.href = url;
+                a.download = "laporan-pariwisata.pdf";
+                document.body.appendChild(a);
+                a.click();
+                document.body.removeChild(a);
+                window.URL.revokeObjectURL(url);
+            } catch (error) {
+                console.error("Error fetching data:", error);
+                button.disabled = false;
+                return;
+            } finally {
+                button.disabled = false;
+            }
+        });
+    }
+}
+
+document.addEventListener("DOMContentLoaded", function () {
+    new TourismReport().init();
+});

resources/js/roles/create.js

@@ -6,6 +6,7 @@ class CreateRoles {
     initCreateRole() {
         const toastNotification = document.getElementById("toastNotification");
         const toast = new bootstrap.Toast(toastNotification);
+        let menuId = document.getElementById("menuId").value;
         document
             .getElementById("btnCreateRole")
             .addEventListener("click", async function () {
@@ -41,7 +42,7 @@ class CreateRoles {
                             result.message;
                         toast.show();
                         setTimeout(() => {
-                            window.location.href = "/roles";
+                            window.location.href = `/roles?menu_id=${menuId}`;
                         }, 2000);
                     } else {
                         let error = await response.json();

resources/js/roles/index.js

@@ -31,6 +31,7 @@ class Roles {
         tableContainer.innerHTML = "";
         let canUpdate = tableContainer.getAttribute("data-updater") === "1";
         let canDelete = tableContainer.getAttribute("data-destroyer") === "1";
+        let menuId = tableContainer.getAttribute("data-menuId");
         // Create a new Grid.js instance only if it doesn't exist
         this.table = new gridjs.Grid({
             columns: [
@@ -38,38 +39,38 @@ class Roles {
                 "Name",
                 "Description",
                 {
-                name: "Action",
+                    name: "Action",
-                formatter: (cell) => {
+                    formatter: (cell) => {
-                    let buttons = `<div class="d-flex justify-content-center gap-2">`;
+                        let buttons = `<div class="d-flex justify-content-center gap-2">`;
 
-                    if (canUpdate) {
+                        if (canUpdate) {
-                        buttons += `
+                            buttons += `
-                            <a href="/roles/${cell}/edit" class="btn btn-yellow btn-sm d-inline-flex align-items-center justify-content-center">
+                            <a href="/roles/${cell}/edit?menu_id=${menuId}" class="btn btn-yellow btn-sm d-inline-flex align-items-center justify-content-center">
                                 <i class='bx bx-edit'></i>
                             </a>
-                            <a href="/roles/role-menu/${cell}" class="btn btn-primary btn-sm d-inline-flex align-items-center justify-content-center">
+                            <a href="/roles/role-menu/${cell}?menu_id=${menuId}" class="btn btn-primary btn-sm d-inline-flex align-items-center justify-content-center">
                                 Role Menu
                             </a>
                         `;
-                    }
+                        }
 
-                    if (canDelete) {
+                        if (canDelete) {
-                        buttons += `
+                            buttons += `
-                            <button data-id="${cell}" class="btn btn-sm btn-red btn-delete-role d-inline-flex align-items-center justify-content-center">
+                            <button data-id="${cell}" class="btn btn-sm btn-red btn-delete-role d-none d-inline-flex align-items-center justify-content-center">
                                 <i class='bx bxs-trash'></i>
                             </button>
                         `;
-                    }
+                        }
 
-                    if (!canUpdate && !canDelete) {
+                        if (!canUpdate && !canDelete) {
-                        buttons += `<span class="text-muted">No Privilege</span>`;
+                            buttons += `<span class="text-muted">No Privilege</span>`;
-                    }
+                        }
 
-                    buttons += `</div>`;
+                        buttons += `</div>`;
 
-                    return gridjs.html(buttons);
+                        return gridjs.html(buttons);
+                    },
                 },
-            },
             ],
             pagination: {
                 limit: 50,

resources/js/roles/update.js

@@ -6,6 +6,7 @@ class UpdateRoles {
     initUpdateRole() {
         const toastNotification = document.getElementById("toastNotification");
         const toast = new bootstrap.Toast(toastNotification);
+        let menuId = document.getElementById("menuId").value;
         document
             .getElementById("btnUpdateRole")
             .addEventListener("click", async function () {
@@ -41,7 +42,7 @@ class UpdateRoles {
                             result.message;
                         toast.show();
                         setTimeout(() => {
-                            window.location.href = "/roles";
+                            window.location.href = `/roles?menu_id=${menuId}`;
                         }, 2000);
                     } else {
                         let error = await response.json();

resources/js/settings/syncronize/syncronize.js

@@ -19,7 +19,16 @@ class SyncronizeTask {
             "table-import-datasources"
         );
         this.table = new gridjs.Grid({
-            columns: ["ID", "Message", "Response", "Status", "Created"],
+            columns: [
+                "ID",
+                "Message",
+                "Response",
+                "Status",
+                "Started",
+                "Duration",
+                "Finished",
+                "Created",
+            ],
             search: {
                 server: {
                     url: (prev, keyword) => `${prev}?search=${keyword}`,
@@ -49,6 +58,9 @@ class SyncronizeTask {
                         item.message,
                         item.response_body,
                         item.status,
+                        item.start_time,
+                        item.duration,
+                        item.finish_time,
                         item.created_at,
                     ]),
                 total: (data) => data.meta.total,
@@ -148,8 +160,11 @@ class SyncronizeTask {
             })
             .catch((err) => {
                 console.error("Fetch error:", err);
-                alert("An error occurred during synchronization" + err.message);
+                this.toastMessage.innerText =
+                    err.message || "Failed to syncronize something wrong!";
+                this.toast.show();
                 button.disabled = false;
+                spinner.classList.add("d-none");
             });
     }
 }

resources/js/table-generator.js

@@ -88,13 +88,15 @@ class GeneralTable {
     handleCreate(event) {
         // Menggunakan model dan ID untuk membangun URL dinamis
         const model = event.target.getAttribute("data-model"); // Mengambil model dari data-model
-        window.location.href = `${this.baseUrl}/${model}/create`;
+        let menuId = event.target.getAttribute("data-menu");
+        window.location.href = `${this.baseUrl}/${model}/create?menu_id=${menuId}`;
     }
 
     handleBulkCreate(event) {
         // Menggunakan model dan ID untuk membangun URL dinamis
         const model = event.target.getAttribute("data-model");
-        window.location.href = `${this.baseUrl}/${model}/bulk-create`;
+        let menuId = event.target.getAttribute("data-menu");
+        window.location.href = `${this.baseUrl}/${model}/bulk-create?menu_id=${menuId}`;
     }
 
     // Fungsi untuk menangani edit
@@ -103,7 +105,8 @@ class GeneralTable {
         const model = event.target.getAttribute("data-model"); // Mengambil model dari data-model
         console.log("Editing record with ID:", id);
         // Menggunakan model dan ID untuk membangun URL dinamis
-        window.location.href = `${this.baseUrl}/${model}/${id}/edit`;
+        let menuId = event.target.getAttribute("data-menu");
+        window.location.href = `${this.baseUrl}/${model}/${id}/edit?menu_id=${menuId}`;
     }
 
     // Fungsi untuk menangani delete

resources/views/auth/signin.blade.php

@@ -30,7 +30,7 @@ class="authentication-bg"
 
                             @if (sizeof($errors) > 0)
                             @foreach ($errors->all() as $error)
-                            <p class="text-red-600 mb-3">{{ $error }}</p>
+                            <p class="text-red mb-3">{{ $error }}</p>
                             @endforeach
                             @endif
 
@@ -39,6 +39,7 @@ class="authentication-bg"
                                 <input type="email" class="form-control" id="email" name="email" placeholder="Enter your email">
                             </div>
                             <div class="mb-3">
+                                <label for="password" class="form-label">Password</label>
                                 <input type="password" class="form-control" id="password" name="password" placeholder="Enter your password">
                             </div>
                             <div class="d-grid">

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

@@ -13,6 +13,19 @@
 <div class="row">
     <div class="col-12">
         <div class="card w-100 h-100">
+            <div class="card-header d-flex justify-content-between align-items-center">
+                <h5 class="card-title mb-0">Laporan Pimpinan</h5>
+                <div class="d-flex gap-2">
+                    <button class="btn btn-sm bg-black text-white d-flex align-items-center content-center gap-2" id="btn-export-excel" data-url="{{ route('api.report-director.excel') }}">
+                        <span>.xlsx</span>
+                        <iconify-icon icon="mingcute:file-export-line" width="20" height="20" class="d-flex align-items-center"></iconify-icon>
+                    </button>
+                    <button class="btn btn-sm bg-black text-white d-flex align-items-center content-center gap-2" id="btn-export-pdf" data-url="{{ route('api.report-director.pdf') }}">
+                        <span>.pdf</span>
+                        <iconify-icon icon="mingcute:file-export-line" width="20" height="20" class="d-flex align-items-center"></iconify-icon>
+                    </button>
+                </div>
+            </div>
             <div class="card-body">
                 <div id="table-bigdata-resumes"></div>
             </div>

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

@@ -5,6 +5,7 @@
 @include('layouts.partials/page-title', ['title' => 'Data', 'subtitle' => 'Business Industries'])
 
 <x-toast-notification />
+<input type="hidden" id="menuId" value="{{ $menuId ?? 0 }}">
 <div class="row">
     <div class="col-xl-12">
         <div class="card">

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

@@ -5,6 +5,7 @@
 @include('layouts.partials/page-title', ['title' => 'Data Settings', 'subtitle' => 'Setting Dashboard'])
 
 <x-toast-notification />
+<input type="hidden" id="menuId" value="{{ $menuId ?? 0 }}">
 <div class="row d-flex justify-content-center">
 	<div class="col-lg-6">
 		<div class="card">

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

@@ -16,12 +16,13 @@
 			<div class="card-body">
 				<div class="d-flex flex-wrap justify-content-end align-items-center mb-2">
 					@if ($creator)
-						<a href="{{ route('business-industries.create')}}" class="btn btn-success btn-sm d-block d-sm-inline w-auto">Upload</a>
+						<a href="{{ route('business-industries.create', ['menu_id' => $menuId])}}" class="btn btn-success btn-sm d-block d-sm-inline w-auto">Upload</a>
 					@endif
 				</div>
 				<div id="table-business-industries"
 					data-updater="{{ $updater }}"
-					data-destroyer="{{ $destroyer }}">
+					data-destroyer="{{ $destroyer }}"
+					data-menuId="{{ $menuId }}">
 				</div>
 			</div>
 		</div>

resources/views/customers/create.blade.php

@@ -5,11 +5,12 @@
 @include('layouts.partials/page-title', ['title' => 'Data', 'subtitle' => 'PDAM'])
 
 <x-toast-notification />
+<input type="hidden" id="menuId" value="{{ $menuId ?? 0 }}">
 <div class="row d-flex justify-content-center">
     <div class="col-md-6">
         <div class="card">
             <div class="card-header d-flex justify-content-end">
-                <a href="{{ route('customers') }}" class="btn btn-sm btn-secondary">Back</a>
+                <a href="{{ route('customers', ['menu_id' => $menuId]) }}" class="btn btn-sm btn-secondary">Back</a>
             </div>
             <div class="card-body">
                 <form id="formCreateCustomer" action="{{ route('api.customers.store') }}" method="post">

resources/views/customers/edit.blade.php

@@ -5,11 +5,12 @@
 @include('layouts.partials/page-title', ['title' => 'Data', 'subtitle' => 'PDAM'])
 
 <x-toast-notification />
+<input type="hidden" id="menuId" value="{{ $menuId ?? 0 }}">
 <div class="row d-flex justify-content-center">
     <div class="col-md-6">
         <div class="card">
             <div class="card-header d-flex justify-content-end">
-                <a href="{{ route('customers') }}" class="btn btn-sm btn-secondary">Back</a>
+                <a href="{{ route('customers', ['menu_id' => $menuId]) }}" class="btn btn-sm btn-secondary">Back</a>
             </div>
             <div class="card-body">
                 <form id="formUpdateCustomer" action="{{ route('api.customers.update', $data->id) }}" method="post">

resources/views/customers/index.blade.php

@@ -16,13 +16,14 @@
             <div class="card-body">
                 <div class="d-flex flex-wrap justify-content-end align-items-center mb-2">
                     @if ($creator)
-                        <a href="{{ route('customers.create')}}" class="btn btn-success btn-sm d-block d-sm-inline w-auto me-3">Create</a>
+                        <a href="{{ route('customers.create', ['menu_id' => $menuId]) }}" class="btn btn-success btn-sm d-block d-sm-inline w-auto me-3">Create</a>
-                        <a href="{{ route('customers.upload')}}" class="btn btn-success btn-sm d-block d-sm-inline w-auto">Upload</a>
+                        <a href="{{ route('customers.upload', ['menu_id' => $menuId]) }}" class="btn btn-success btn-sm d-block d-sm-inline w-auto">Upload</a>
                     @endif
                 </div>
                 <div id="table-customers"
                      data-updater="{{ $updater }}"
-                     data-destroyer="{{ $destroyer }}">
+                     data-destroyer="{{ $destroyer }}"
+                     data-menuId="{{ $menuId }}">
                 </div>
             </div>
         </div>

resources/views/customers/upload.blade.php

@@ -5,6 +5,7 @@
 @include('layouts.partials/page-title', ['title' => 'Data', 'subtitle' => 'PDAM'])
 
 <x-toast-notification />
+<input type="hidden" id="menuId" value="{{ $menuId ?? 0 }}">
 <div class="row">
     <div class="col-xl-12">
         <div class="card">

resources/views/dashboards/pbg.blade.php

@@ -12,11 +12,7 @@
 <div class="card mb-3 mb-xl-0">
     <div class="card-title mt-3">
         <div class="d-flex flex-sm-nowrap flex-wrap justify-content-end gap-2 me-3">
-            <select class="form-select w-25 w-sm-auto" id="yearPicker" name="year" style="min-width: 100px;">
+            <input type="text" class="form-control mt-2" style="max-width: 125px;" id="datepicker-dashboard-pbg" placeholder="Filter Date" />
-            @for ($i = date('Y'); $i > date('Y') - 5; $i--)
-                <option value="{{ $i }}" {{ $i == date('Y') ? 'selected' : '' }}>{{ $i }}</option>
-            @endfor
-            </select>
         </div>
     </div>
     
@@ -218,7 +214,7 @@
 
         <div class="row">
             <!-- Card 1 -->
-            <div class="col-md-12 col-lg-12 col-xl-4">
+            <div class="col-md-12 col-lg-12 col-xl-6">
                 <div class="card">
                     <div class="card-body">
                         <div class="row">
@@ -240,7 +236,7 @@
             </div>
             
             <!-- Card 2 -->
-            <div class="col-md-12 col-lg-12 col-xl-4">
+            <div class="col-md-12 col-lg-12 col-xl-4 d-none">
                 <div class="card">
                     <div class="card-body">
                         <div class="row">
@@ -262,7 +258,7 @@
             </div>
 
             <!-- Card 3 -->
-            <div class="col-md-12 col-lg-12 col-xl-4">
+            <div class="col-md-12 col-lg-12 col-xl-6">
                 <div class="card">
                     <div class="card-body">
                         <div class="row">

resources/views/data-settings/create.blade.php

@@ -5,11 +5,12 @@
 @include('layouts.partials/page-title', ['title' => 'Data Settings', 'subtitle' => 'Setting Dashboard'])
 
 <x-toast-notification />
+<input type="hidden" id="menuId" value="{{ $menuId ?? 0 }}">
 <div class="row d-flex justify-content-center">
   <div class="col-lg-6">
     <div class="card">
       <div class="card-header d-flex justify-content-end">
-        <a href="{{ route('data-settings.index') }}" class="btn btn-sm btn-secondary">Back</a>
+        <a href="{{ route('data-settings.index', ['menu_id' => $menuId]) }}" class="btn btn-sm btn-secondary">Back</a>
       </div>
       <div class="card-body">
         <form id="formDataSettings" action="{{ route('api.data-settings.store') }}" method="POST">

resources/views/data-settings/edit.blade.php

@@ -5,11 +5,12 @@
 @include('layouts.partials/page-title', ['title' => 'Data Settings', 'subtitle' => 'Setting Dashboard'])
 
 <x-toast-notification />
+<input type="hidden" id="menuId" value="{{ $menuId ?? 0 }}">
 <div class="row d-flex justify-content-center">
 	<div class="col-lg-6">
 		<div class="card">
 			<div class="card-header d-flex justify-content-end">
-        <a href="{{ route('data-settings.index') }}" class="btn btn-sm btn-secondary">Back</a>
+        <a href="{{ route('data-settings.index', ['menu_id' => $menuId]) }}" class="btn btn-sm btn-secondary">Back</a>
       </div>
 			<div class="card-body">
 				<form id="formUpdateDataSettings" action="{{ route('api.data-settings.update', $data->id) }}" method="POST">