fix get menu id and height auto chart growth

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=82800 --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

app/Console/Commands/ScrapingData.php

@@ -2,10 +2,12 @@
 
 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;
@@ -26,64 +28,68 @@ class ScrapingData extends Command
      * @var string
      */
     protected $description = 'Command description';
-
-    private $client;
-    private $service_pbg_task;
-    private $service_tab_pbg_task;
-
     /**
      * Inject dependencies.
      */
-    public function __construct(Client $client, ServicePbgTask $service_pbg_task, ServiceTabPbgTask $serviceTabPbgTask)
+    public function __construct(
-    {
+    ) {
         parent::__construct();
-        $this->client = $client;
+    }
-        $this->service_pbg_task = $service_pbg_task;
+
-        $this->service_tab_pbg_task = $serviceTabPbgTask;
+    public function handle()
+    {
+        dispatch(new ScrapingDataJob());
+
+        $this->info("Scraping job dispatched successfully");
     }
 
     /**
      * Execute the console command.
      */
-    public function handle()
+    // public function handle()
-    {
+    // {
 
-        try {
+    //     try {
-            // Create a record with "processing" status
+    //         // Create a record with "processing" status
-            $import_datasource = ImportDatasource::create([
+    //         $import_datasource = ImportDatasource::create([
-                'message' => 'Initiating scraping...',
+    //             'message' => 'Initiating scraping...',
-                'response_body' => null,
+    //             'response_body' => null,
-                'status' => 'processing'
+    //             'status' => 'processing',
-            ]);
+    //             'start_time' => now()
+    //         ]);
 
-            // Run the service
+    //         // Run the service
-            $service_google_sheet = new ServiceGoogleSheet($import_datasource->id);
+    //         $service_google_sheet = new ServiceGoogleSheet();
-            $service_google_sheet->run_service();
+    //         $service_google_sheet->run_service();
 
-            // Run the ServicePbgTask with injected Guzzle Client
+    //         // Run the ServicePbgTask with injected Guzzle Client
-            $this->service_pbg_task->run_service();
+    //         $this->service_pbg_task->run_service();
 
-            // run the service pbg task assignments
+    //         // run the service pbg task assignments
-            $this->service_tab_pbg_task->run_service();
+    //         $this->service_tab_pbg_task->run_service();
 
-            // Update the record status to "success" after completion
+    //         // Update the record status to "success" after completion
-            $import_datasource->update([
+    //         $import_datasource->update([
-                'status' => 'success',
+    //             'status' => 'success',
-                'message' => 'Scraping completed successfully.'
+    //             'message' => 'Scraping completed successfully.',
-            ]);
+    //             'finish_time' => now()
+    //         ]);
 
-        } catch (\Exception $e) {
+    //     } 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()
+    //             ]);
+    //         }
+    //     }
+    // }
 
-            // 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()
-                ]);
-            }
-        }
-    }
 }

app/Enums/PbgTaskApplicationTypes.php

@@ -0,0 +1,25 @@
+<?php
+
+namespace App\Enums;
+
+enum PbgTaskApplicationTypes: string
+{
+    case PERSETUJUAN_BG = '1';
+    case PERUBAHAN_BG = '2';
+    case SLF_BB = '4';
+    case SLF = '5';
+    public static function labels(): array
+    {
+        return [
+            null => "Pilih Application Type",
+            self::PERSETUJUAN_BG->value => 'Persetujuan Bangunan Gedung',
+            self::PERUBAHAN_BG->value => 'Perubahan Bangunan Gedung',
+            self::SLF_BB->value => 'Sertifikat Laik Fungsi - Bangunan Baru',
+            self::SLF->value => 'Sertifikat Laik Fungsi',
+        ];
+    }
+    public static function getLabel(?string $status): ?string
+    {
+        return self::labels()[$status] ?? null;
+    }
+}

app/Enums/PbgTaskFilterData.php

@@ -0,0 +1,22 @@
+<?php
+
+namespace App\Enums;
+
+enum PbgTaskFilterData : string
+{
+    case non_business = 'non-business';
+    case business = 'business';
+    case verified = 'verified';
+    case non_verified = 'non-verified';
+    case all = 'all';
+
+    public static function getAllOptions() : array  {
+        return [
+            self::all->value => 'Potensi Berkas',
+            self::business->value => 'Usaha',
+            self::non_business->value => 'Bukan Usaha',
+            self::verified->value => 'Terverifikasi',
+            self::non_verified->value => 'Belum Terverifikasi',
+        ];
+    }
+}

app/Enums/PbgTaskStatus.php

@@ -0,0 +1,59 @@
+<?php
+
+namespace App\Enums;
+
+enum PbgTaskStatus: int
+{
+    case VERIFIKASI_KELENGKAPAN = 1;
+    case PERBAIKAN_DOKUMEN = 2;
+    case PERMOHONAN_DIBATALKAN = 3;
+    case MENUNGGU_PENUGASAN_TPT_TPA = 4;
+    case MENUNGGU_JADWAL_KONSULTASI = 5;
+    case PELAKSANAAN_KONSULTASI = 6;
+    case PERBAIKAN_DOKUMEN_KONSULTASI = 8;
+    case PERMOHONAN_DITOLAK = 9;
+    case PERHITUNGAN_RETRIBUSI = 10;
+    case MENUNGGU_PEMBAYARAN_RETRIBUSI = 14;
+    case VERIFIKASI_PEMBAYARAN_RETRIBUSI = 15;
+    case RETRIBUSI_TIDAK_SESUAI = 16;
+    case VERIFIKASI_SK_PBG = 18;
+    case PENERBITAN_SK_PBG = 19;
+    case SK_PBG_TERBIT = 20;
+    case PENERBITAN_SPPST = 24;
+    case PROSES_PENERBITAN_SKRD = 25;
+    case MENUNGGU_PENUGASAN_TPT = 26;
+    case VERIFIKASI_DATA_TPT = 27;
+    case SERTIFIKAT_SLF_TERBIT = 28;
+
+    public static function getStatuses(): array
+    {
+        return [
+            null => "Pilih Status",
+            self::VERIFIKASI_KELENGKAPAN->value => "Verifikasi Kelengkapan Dokumen",
+            self::PERBAIKAN_DOKUMEN->value => "Perbaikan Dokumen",
+            self::PERMOHONAN_DIBATALKAN->value => "Permohonan Dibatalkan",
+            self::MENUNGGU_PENUGASAN_TPT_TPA->value => "Menunggu Penugasan TPT/TPA",
+            self::MENUNGGU_JADWAL_KONSULTASI->value => "Menunggu Jadwal Konsultasi",
+            self::PELAKSANAAN_KONSULTASI->value => "Pelaksanaan Konsultasi",
+            self::PERBAIKAN_DOKUMEN_KONSULTASI->value => "Perbaikan Dokumen Konsultasi",
+            self::PERMOHONAN_DITOLAK->value => "Permohonan Ditolak",
+            self::PERHITUNGAN_RETRIBUSI->value => "Perhitungan Retribusi",
+            self::MENUNGGU_PEMBAYARAN_RETRIBUSI->value => "Menunggu Pembayaran Retribusi",
+            self::VERIFIKASI_PEMBAYARAN_RETRIBUSI->value => "Verifikasi Pembayaran Retribusi",
+            self::RETRIBUSI_TIDAK_SESUAI->value => "Retribusi Tidak Sesuai",
+            self::VERIFIKASI_SK_PBG->value => "Verifikasi SK PBG",
+            self::PENERBITAN_SK_PBG->value => "Penerbitan SK PBG",
+            self::SK_PBG_TERBIT->value => "SK PBG Terbit",
+            self::PENERBITAN_SPPST->value => "Penerbitan SPPST",
+            self::PROSES_PENERBITAN_SKRD->value => "Proses Penerbitan SKRD",
+            self::MENUNGGU_PENUGASAN_TPT->value => "Menunggu Penugasan TPT",
+            self::VERIFIKASI_DATA_TPT->value => "Verifikasi Data TPT",
+            self::SERTIFIKAT_SLF_TERBIT->value => "Sertifikat SLF Terbit",
+        ];
+    }
+
+    public static function getLabel(?int $status): ?string
+    {
+        return self::getStatuses()[$status] ?? null;
+    }
+}

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/ChatbotController.php

@@ -34,7 +34,7 @@ class ChatbotController extends Controller
         };
 
         $chatHistory = $request->input('chatHistory');
-        // Log::info('Chat history sebelum disimpan:', ['history' => $chatHistory]);
+        Log::info('Chat history sebelum disimpan:', ['history' => $chatHistory]);
 
         if ($main_content === "UNKNOWN") {
             return response()->json(['response' => 'Invalid tab_active value.'], 400);
@@ -43,15 +43,16 @@ class ChatbotController extends Controller
         // info($main_content);
 
         $queryResponse = $this->openAIService->generateQueryBasedMainContent($request->input('prompt'), $main_content, $chatHistory);
-        
+
-        $firstValidation = $this->openAIService->validateSyntaxQuery($queryResponse);
+        if (str_contains($queryResponse, 'tidak relevan') || str_contains($queryResponse, 'tidak valid') || str_starts_with($queryResponse, 'Prompt')) {
-        $secondValidation = $this->openAIService->validateSyntaxQuery($queryResponse);
+            return response()->json(['response' => $queryResponse], 400);
+        }
 
         $formattedResultQuery = "[]";
         $queryResponse = str_replace(['```sql', '```'], '', $queryResponse);
         $resultQuery = DB::select($queryResponse);
         $formattedResultQuery = json_encode($resultQuery, JSON_PRETTY_PRINT);
-        // info($formattedResultQuery);
+        info($formattedResultQuery);
         
         $nlpResult = $this->openAIService->generateNLPFromQuery($request->input('prompt'), $formattedResultQuery);
         $finalGeneratedText =$this->openAIService->generateFinalText($nlpResult);
@@ -92,9 +93,6 @@ class ChatbotController extends Controller
             $queryResponse = $this->openAIService->createMainQuery($classifyResponse, $request->input('prompt'), $chatHistory);
             info($queryResponse);
 
-            $firstValidation = $this->openAIService->validateSyntaxQuery($queryResponse);
-            $secondValidation = $this->openAIService->validateSyntaxQuery($queryResponse);
-
             $formattedResultQuery = "[]";
             
             $queryResponse = str_replace(['```sql', '```'], '', $queryResponse);

app/Http/Controllers/Api/GrowthReportAPIController.php

@@ -0,0 +1,85 @@
+<?php
+
+namespace App\Http\Controllers\Api;
+
+use App\Http\Controllers\Controller;
+use App\Models\BigdataResume;
+use Carbon\Carbon;
+use Illuminate\Http\Request;
+use Illuminate\Support\Facades\DB;
+
+class GrowthReportAPIController extends Controller
+{
+    /**
+     * Display a listing of the resource.
+     */
+    public function index(Request $request)
+    {
+        // Get current date
+        $today = Carbon::today();
+    
+        // Define default range: 1 month back from today
+        $defaultStart = $today->copy()->subMonth();
+        $defaultEnd = $today;
+    
+        // Use request values if provided, else use defaults
+        $startDate = $request->input('start_date', $defaultStart->toDateString());
+        $endDate = $request->input('end_date', $defaultEnd->toDateString());
+    
+        // Optional year filter (used if specified)
+        $year = $request->input('year', now()->year);
+    
+        $query = BigdataResume::selectRaw("
+            DATE(created_at) as date,
+            SUM(potention_sum) as potention_sum,
+            SUM(verified_sum) as verified_sum,
+            SUM(non_verified_sum) as non_verified_sum
+        ")
+        ->whereBetween('created_at', [$startDate, $endDate]);
+    
+        $query->whereNotNull('year')
+        ->where('year', '!=', 'all');
+    
+        $data = $query->groupBy(DB::raw('DATE(created_at)'))
+            ->orderBy(DB::raw('DATE(created_at)'))
+            ->get()
+            ->map(function ($item) {
+                $item->date = Carbon::parse($item->date)->format('d M Y');
+                return $item;
+            });
+    
+        return response()->json($data);
+    }
+
+    /**
+     * Store a newly created resource in storage.
+     */
+    public function store(Request $request)
+    {
+        //
+    }
+
+    /**
+     * Display the specified resource.
+     */
+    public function show(string $id)
+    {
+        //
+    }
+
+    /**
+     * Update the specified resource in storage.
+     */
+    public function update(Request $request, string $id)
+    {
+        //
+    }
+
+    /**
+     * Remove the specified resource from storage.
+     */
+    public function destroy(string $id)
+    {
+        //
+    }
+}

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/PbgTaskAttachmentsController.php

@@ -0,0 +1,109 @@
+<?php
+
+namespace App\Http\Controllers\Api;
+
+use App\Http\Controllers\Controller;
+use App\Models\PbgTaskAttachment;
+use Illuminate\Http\Request;
+use Illuminate\Support\Facades\Storage;
+use Symfony\Component\HttpFoundation\Response;
+
+class PbgTaskAttachmentsController extends Controller
+{
+    /**
+     * Display a listing of the resource.
+     */
+    public function index()
+    {
+        //
+    }
+
+    /**
+     * Store a newly created resource in storage.
+     */
+    public function store(Request $request, $pbg_task_id)
+    {
+        try{
+            $request->validate([
+                'file' => 'required|file|mimes:jpg,png,pdf|max:5120',
+                'pbg_type' => 'string'
+            ]);
+
+            $attachment = PbgTaskAttachment::create([
+                'pbg_task_id' => $pbg_task_id,
+                'file_name' => $request->file('file')->getClientOriginalName(),
+                'file_path' => '', // empty path initially
+                'pbg_type' => $request->pbg_type == 'bukti_bayar' ? 'bukti_bayar' : 'berita_acara'
+            ]);
+
+            $file = $request->file('file');
+            $path = $file->store("uploads/pbg-tasks/{$pbg_task_id}/{$attachment->id}", "public");
+
+            $attachment->update([
+                'file_path' => $path,
+            ]);
+
+            return response()->json([
+                'message' => 'File uploaded successfully.',
+                'attachment' => [
+                    'id' => $attachment->id,
+                    'file_name' => $attachment->file_name,
+                    'file_url' => Storage::url($attachment->file_path),
+                    'pbg_type' => $attachment->pbg_type
+                ] 
+            ]);
+        }catch(\Exception $e){
+            \Log::error($e->getMessage());
+            return response()->json([
+                "success" => false,
+                "message" => $e->getTraceAsString()
+            ]);
+        }
+    }
+
+    /**
+     * Display the specified resource.
+     */
+    public function show(string $id)
+    {
+        //
+    }
+
+    /**
+     * Update the specified resource in storage.
+     */
+    public function update(Request $request, string $id)
+    {
+        //
+    }
+
+    /**
+     * Remove the specified resource from storage.
+     */
+    public function destroy(string $id)
+    {
+        //
+    }
+
+    public function download(string $id)
+    {
+        try {
+            $data = PbgTaskAttachment::findOrFail($id);
+            $filePath = $data->file_path; // already relative to 'public' disk
+
+            if (!Storage::disk('public')->exists($filePath)) {
+                return response()->json([
+                    "success" => false,
+                    "message" => "File not found on server"
+                ], Response::HTTP_NOT_FOUND);
+            }
+
+            return Storage::disk('public')->download($filePath, $data->file_name);
+        } catch (\Exception $e) {
+            return response()->json([
+                "success" => false,
+                "message" => $e->getMessage()
+            ]);
+        }
+    }
+}

app/Http/Controllers/Api/PbgTaskController.php

@@ -3,6 +3,8 @@
 namespace App\Http\Controllers\Api;
 
 use App\Enums\ImportDatasourceStatus;
+use App\Enums\PbgTaskApplicationTypes;
+use App\Enums\PbgTaskStatus;
 use App\Http\Controllers\Controller;
 use App\Http\Requests\PbgTaskMultiStepRequest;
 use App\Http\Resources\PbgTaskResource;
@@ -14,6 +16,7 @@ use App\Services\GoogleSheetService;
 use Carbon\Carbon;
 use Illuminate\Http\Request;
 use Illuminate\Support\Facades\DB;
+use Illuminate\Validation\Rules\Enum;
 
 class PbgTaskController extends Controller
 {
@@ -116,9 +119,63 @@ class PbgTaskController extends Controller
     /**
      * Update the specified resource in storage.
      */
-    public function update(Request $request, string $id)
+    public function update(Request $request, string $task_uuid)
     {
-        //
+        try{
+            $pbg_task = PbgTask::where('uuid',$task_uuid)->first();
+
+            if(!$pbg_task){
+                return response()->json([
+                    "success"=> false,
+                    "message"=> "Data PBG Task tidak ditemukan",
+                ], 404);
+            }
+
+            $validated = $request->validate([
+                'name' => 'required|string|max:255',
+                'owner_name' => 'required|string|max:255',
+                'application_type' => ['nullable', new Enum(PbgTaskApplicationTypes::class)],
+                'condition' => 'required|string|max:255',
+                'registration_number' => 'required|string|max:255',
+                'document_number' => 'required|string|max:255',
+                'status' => ['nullable', new Enum(PbgTaskStatus::class)],
+                'address' => 'required|string|max:255',
+                'slf_status_name' => 'nullable|string|max:255',
+                'function_type' => 'required|string|max:255',
+                'consultation_type' => 'required|string|max:255',
+                'due_date' => 'nullable|date|after_or_equal:today',
+            ]);
+
+            $statusLabel = $validated['status'] !== null ? PbgTaskStatus::getLabel($validated['status']) : null;
+            $applicationLabel = $validated['application_type'] !== null ? PbgTaskApplicationTypes::getLabel($validated['application_type']) : null;
+
+            $pbg_task->update([
+                'name' => $validated['name'],
+                'owner_name' => $validated['owner_name'],
+                'application_type' => $validated['application_type'],
+                'application_type_name' => $applicationLabel, // Automatically set application_type_name
+                'condition' => $validated['condition'],
+                'registration_number' => $validated['registration_number'],
+                'document_number' => $validated['document_number'],
+                'status' => $validated['status'],
+                'status_name' => $statusLabel, // Automatically set status_name
+                'address' => $validated['address'],
+                'slf_status_name' => $validated['slf_status_name'],
+                'function_type' => $validated['function_type'],
+                'consultation_type' => $validated['consultation_type'],
+                'due_date' => $validated['due_date'],
+            ]);
+            return response()->json([
+                "success"=> true,
+                "message"=> "Data berhasil diubah",
+                "data"=> $pbg_task
+            ]);
+        }catch(\Exception $e){
+            return response()->json([
+                "success"=> false,
+                "message"=> $e->getMessage(),
+            ]);
+         }
     }
 
     /**
@@ -135,255 +192,4 @@ class PbgTaskController extends Controller
         ]);
     }
 
-    public function syncPbgFromGoogleSheet(){
-        $import_datasource = ImportDatasource::create([
-            "message" => "initialization",
-            "response_body" => null,
-            "status" => ImportDatasourceStatus::Processing->value,
-        ]);
-        try{
-            $totalRowCount = $this->googleSheetService->getLastRowByColumn("C");
-            $sheetData = $this->googleSheetService->getSheetDataCollection($totalRowCount);
-            $sheet_big_data = $this->googleSheetService->get_data_by_sheet();
-            $data_setting_result = []; // Initialize result storage
-        
-            $found_section = null; // Track which section is found
-        
-            foreach ($sheet_big_data as $row) {
-                // Check for section headers
-                if (in_array("•PROSES PENERBITAN:", $row)) {
-                    $found_section = "MENUNGGU_KLIK_DPMPTSP";
-                } elseif (in_array("•BERKAS AKTUAL TERVERIFIKASI DINAS TEKNIS 2024:", $row)) {
-                    $found_section = "REALISASI_TERBIT_PBG";
-                } elseif (in_array("•TERPROSES DI DPUTR: belum selesai rekomtek'", $row)) {
-                    $found_section = "PROSES_DINAS_TEKNIS";
-                }
-        
-                // If a section is found and we reach "Grand Total", save the corresponding values
-                if ($found_section && isset($row[0]) && trim($row[0]) === "Grand Total") {
-                    if ($found_section === "MENUNGGU_KLIK_DPMPTSP") {
-                        $data_setting_result["MENUNGGU_KLIK_DPMPTSP_COUNT"] = $row[2] ?? null;
-                        $data_setting_result["MENUNGGU_KLIK_DPMPTSP_SUM"] = $row[3] ?? null;
-                    } elseif ($found_section === "REALISASI_TERBIT_PBG") {
-                        $data_setting_result["REALISASI_TERBIT_PBG_COUNT"] = $row[2] ?? null;
-                        $data_setting_result["REALISASI_TERBIT_PBG_SUM"] = $row[4] ?? null;
-                    } elseif ($found_section === "PROSES_DINAS_TEKNIS") {
-                        $data_setting_result["PROSES_DINAS_TEKNIS_COUNT"] = $row[2] ?? null;
-                        $data_setting_result["PROSES_DINAS_TEKNIS_SUM"] = $row[3] ?? null;
-                    }
-        
-                    // Reset section tracking after capturing "Grand Total"
-                    $found_section = null;
-                }
-            }
-            foreach ($data_setting_result as $key => $value) {
-                DataSetting::updateOrInsert(
-                    ["key" => $key], // Find by key
-                    ["value" => $value] // Update or insert value
-                );
-            }
-            $mapToUpsert = [];
-            $count = 0;
-
-            foreach($sheetData as $data){
-                $mapToUpsert[] = 
-                    [
-                        'no_registrasi' => $data['no__registrasi'] ?? null,
-                        'jenis_konsultasi' => $data['jenis_konsultasi'] ?? null,
-                        'fungsi_bg' => $data['fungsi_bg'] ?? null,
-                        'tgl_permohonan' => $this->convertToDate($data['tgl_permohonan']),
-                        'status_verifikasi' => $data['status_verifikasi'] ?? null,
-                        'status_permohonan' => $this->convertToDate($data['status_permohonan']),
-                        'alamat_pemilik' => $data['alamat_pemilik'] ?? null,
-                        'no_hp' => $data['no__hp'] ?? null,
-                        'email' => $data['e_mail'] ?? null,
-                        'tanggal_catatan' => $this->convertToDate($data['tanggal_catatan']),
-                        'catatan_kekurangan_dokumen' => $data['catatan_kekurangan_dokumen'] ?? null,
-                        'gambar' => $data['gambar'] ?? null,
-                        'krk_kkpr' => $data['krk_kkpr'] ?? null,
-                        'no_krk' => $data['no__krk'] ?? null,
-                        'lh' => $data['lh'] ?? null,
-                        'ska' => $data['ska'] ?? null,
-                        'keterangan' => $data['keterangan'] ?? null,
-                        'helpdesk' => $data['helpdesk'] ?? null,
-                        'pj' => $data['pj'] ?? null,
-                        'kepemilikan' => $data['kepemilikan'] ?? null,
-                        'potensi_taru' => $data['potensi_taru'] ?? null,
-                        'validasi_dinas' => $data['validasi_dinas'] ?? null,
-                        'kategori_retribusi' => $data['kategori_retribusi'] ?? null,
-                        'no_urut_ba_tpt' => $data['no__urut_ba_tpt__2024_0001_'] ?? null,
-                        'tanggal_ba_tpt' => $this->convertToDate($data['tanggal_ba_tpt']),
-                        'no_urut_ba_tpa' => $data['no__urut_ba_tpa'] ?? null,
-                        'tanggal_ba_tpa' => $this->convertToDate($data['tanggal_ba_tpa']),
-                        'no_urut_skrd' => $data['no__urut_skrd__2024_0001_'] ?? null,
-                        'tanggal_skrd' => $this->convertToDate($data['tanggal_skrd']),
-                        'ptsp' => $data['ptsp'] ?? null,
-                        'selesai_terbit' => $data['selesai_terbit'] ?? null,
-                        'tanggal_pembayaran' => $this->convertToDate($data['tanggal_pembayaran__yyyy_mm_dd_']),
-                        'format_sts' => $data['format_sts'] ?? null,
-                        'tahun_terbit' => (int) $data['tahun_terbit'] ?? null,
-                        'tahun_berjalan' => (int) $data['tahun_berjalan'] ?? null,
-                        'kelurahan' => $data['kelurahan'] ?? null,
-                        'kecamatan' => $data['kecamatan'] ?? null,
-                        'lb' => $this->convertToDecimal($data['lb'])  ?? null,
-                        'tb' => $this->convertToDecimal($data['tb']) ?? null,
-                        'jlb' => (int) $data['jlb'] ?? null,
-                        'unit' => (int) $data['unit'] ?? null,
-                        'usulan_retribusi' => (int) $data['usulan_retribusi'] ?? null,
-                        'nilai_retribusi_keseluruhan_simbg' => $this->convertToDecimal($data['nilai_retribusi_keseluruhan__simbg_']) ?? null,
-                        'nilai_retribusi_keseluruhan_pad' => $this->convertToDecimal($data['nilai_retribusi_keseluruhan__pad_']) ?? null,
-                        'denda' => $this->convertToDecimal($data['denda']) ?? null,
-                        'latitude' => $data['latitude'] ?? null,
-                        'longitude' => $data['longitude'] ?? null,
-                        'nik_nib' => $data['nik_nib'] ?? null,
-                        'dok_tanah' => $data['dok__tanah'] ?? null,
-                        'temuan' => $data['temuan'] ?? null,
-                    ];
-            }
-
-            DB::beginTransaction();
-
-            $batchSize = 1000;
-            $chunks = array_chunk($mapToUpsert, $batchSize);
-
-            foreach($chunks as $chunk){
-                PbgTaskGoogleSheet::upsert($chunk, ["no_registrasi"],[
-                    'jenis_konsultasi',
-                    'nama_pemilik',
-                    'lokasi_bg',
-                    'fungsi_bg',
-                    'nama_bangunan',
-                    'tgl_permohonan',
-                    'status_verifikasi',
-                    'status_permohonan',
-                    'alamat_pemilik',
-                    'no_hp',
-                    'email',
-                    'tanggal_catatan',
-                    'catatan_kekurangan_dokumen',
-                    'gambar',
-                    'krk_kkpr',
-                    'no_krk',
-                    'lh',
-                    'ska',
-                    'keterangan',
-                    'helpdesk',
-                    'pj',
-                    'kepemilikan',
-                    'potensi_taru',
-                    'validasi_dinas',
-                    'kategori_retribusi',
-                    'no_urut_ba_tpt',
-                    'tanggal_ba_tpt',
-                    'no_urut_ba_tpa',
-                    'tanggal_ba_tpa',
-                    'no_urut_skrd',
-                    'tanggal_skrd',
-                    'ptsp',
-                    'selesai_terbit',
-                    'tanggal_pembayaran',
-                    'format_sts',
-                    'tahun_terbit',
-                    'tahun_berjalan',
-                    'kelurahan',
-                    'kecamatan',
-                    'lb',
-                    'tb',
-                    'jlb',
-                    'unit',
-                    'usulan_retribusi',
-                    'nilai_retribusi_keseluruhan_simbg',
-                    'nilai_retribusi_keseluruhan_pad',
-                    'denda',
-                    'latitude',
-                    'longitude',
-                    'nik_nib',
-                    'dok_tanah',
-                    'temuan',
-                ]);
-            }
-
-            $total_data = count($mapToUpsert);
-
-            $import_datasource->update([
-                "message" => "Successfully processed: {$total_data}",
-                "status" => ImportDatasourceStatus::Success->value,
-            ]);
-
-            DB::commit();
-
-            return response()->json([
-                "success" => true,
-                "message" => "Data berhasil disimpan ke database"
-            ], 200);
-        }catch(\Exception $ex){
-            DB::rollBack();
-            $import_datasource->update([
-                "message" => "Failed to importing",
-                "response_body" => $ex->getMessage(),
-                "status" => ImportDatasourceStatus::Failed->value,
-            ]);
-            return response()->json([
-                "success" => false,
-                "message" => "Gagal menyimpan data",
-                "error" => $ex->getMessage()
-            ], 500);
-        }
-    }
-
-    protected function convertToDecimal(?string $value): ?float
-    {
-        if (empty($value)) {
-            return null; // Return null if the input is empty
-        }
-
-        // Remove all non-numeric characters except comma and dot
-        $value = preg_replace('/[^0-9,\.]/', '', $value);
-
-        // If the number contains both dot (.) and comma (,)
-        if (strpos($value, '.') !== false && strpos($value, ',') !== false) {
-            $value = str_replace('.', '', $value); // Remove thousands separator
-            $value = str_replace(',', '.', $value); // Convert decimal separator to dot
-        }
-        // If only a dot is present (assumed as thousands separator)
-        elseif (strpos($value, '.') !== false) {
-            $value = str_replace('.', '', $value); // Remove all dots (treat as thousands separators)
-        }
-        // If only a comma is present (assumed as decimal separator)
-        elseif (strpos($value, ',') !== false) {
-            $value = str_replace(',', '.', $value); // Convert comma to dot (decimal separator)
-        }
-
-        // Ensure the value is numeric before returning
-        return is_numeric($value) ? (float) number_format((float) $value, 2, '.', '') : null;
-    }
-
-    protected function convertToInteger($value) {
-        // Check if the value is an empty string, and return null if true
-        if (trim($value) === "") {
-            return null;
-        }
-
-        // Otherwise, cast to integer
-        return (int) $value;
-    }
-
-    protected function convertToDate($dateString)
-    {
-        try {
-            // Check if the string is empty
-            if (empty($dateString)) {
-                return null;
-            }
-
-            // Try to parse the date string
-            $date = Carbon::parse($dateString);
-
-            // Return the Carbon instance
-            return $date->format('Y-m-d');
-        } catch (\Exception $e) {
-            // Return null if an error occurs during parsing
-            return null;
-        }
-    }
 }

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 DB;
+use Barryvdh\DomPDF\Facade\Pdf;
+use Illuminate\Support\Facades\DB;
 use Exception;
 use Illuminate\Http\Request;
 use Log;
+use Maatwebsite\Excel\Facades\Excel;
 
 class RequestAssignmentController extends Controller
 {
@@ -18,12 +21,51 @@ class RequestAssignmentController extends Controller
      */
     public function index(Request $request)
     {
-        $query = PbgTask::query()->orderBy('id', 'desc');
+        $query = PbgTask::with([
-        if($request->has('search') && !empty($request->get("search"))){
+            'attachments' => function ($q) {
-            $query->where('name', 'LIKE', '%'.$request->get('search').'%')
+                $q->whereIn('pbg_type', ['berita_acara', 'bukti_bayar']);
-            ->orWhere('registration_number', 'LIKE', '%'.$request->get('search').'%')
+            },
-            ->orWhere('document_number', 'LIKE', '%'.$request->get('search').'%');
+            'googleSheet'
+        ])->orderBy('id', 'desc');
+    
+        if ($request->has('filter') && !empty($request->get('filter'))) {
+            $filter = strtolower($request->get('filter'));
+    
+            switch ($filter) {
+                case 'non-business':
+                    $query->whereRaw("LOWER(function_type) != ?", ['sebagai tempat usaha'])->orWhereNull('function_type');
+                    break;
+    
+                case 'business':
+                    $query->whereRaw("LOWER(function_type) = ?", ['sebagai tempat usaha']);
+                    break;
+    
+                case 'verified':
+                    $query->whereHas('googleSheet', function ($q) {
+                        $q->whereRaw("LOWER(status_verifikasi) = ?", ['selesai verifikasi']);
+                    });
+                    break;
+    
+                case 'non-verified':
+                    $query->where(function ($q) {
+                        $q->whereDoesntHave('googleSheet')
+                          ->orWhereHas('googleSheet', function ($q2) {
+                              $q2->whereRaw("LOWER(status_verifikasi) != ?", ['selesai verifikasi'])->orWhereNull('status_verifikasi');
+                          });
+                    });
+                    break;
+            }
         }
+    
+        if ($request->has('search') && !empty($request->get("search"))) {
+            $search = $request->get('search');
+            $query->where(function ($q) use ($search) {
+                $q->where('name', 'LIKE', "%$search%")
+                  ->orWhere('registration_number', 'LIKE', "%$search%")
+                  ->orWhere('document_number', 'LIKE', "%$search%");
+            });
+        }
+    
         return RequestAssignmentResouce::collection($query->paginate());
     }
 
@@ -49,6 +91,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,16 @@ namespace App\Http\Controllers\Api;
 
 use App\Enums\ImportDatasourceStatus;
 use App\Http\Controllers\Controller;
+use App\Jobs\RetrySyncronizeJob;
+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,40 +30,33 @@ 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"]);
     }
 
-    /**
+    public function retry_syncjob(string $import_datasource_id){
-     * Store a newly created resource in storage.
+        try{
-     */
-    public function store(Request $request)
-    {
-        //
-    }
 
-    /**
+            $import_datasource = ImportDatasource::find($import_datasource_id);
-     * Display the specified resource.
+            if(!$import_datasource){
-     */
+                return $this->resError("Invalid import datasource id", null, 404);
-    public function show(string $id)
+            }
-    {
-        //
-    }
 
-    /**
+            dispatch(new RetrySyncronizeJob($import_datasource->id));
-     * Update the specified resource in storage.
+            return response()->json([
-     */
+                "success" => true,
-    public function update(Request $request, string $id)
+                "message" => "Retrying scrape job on background, check status for more"
-    {
+            ]);
-        //
+        }catch(\Exception $e){
-    }
+            return response()->json([
-
+                "success" => false,
-    /**
+                "message" => "Failed to retry sync job",
-     * Remove the specified resource from storage.
+                "error" => $e->getMessage()
-     */
+            ]);
-    public function destroy(string $id)
+        }
-    {
-        //
     }
 }

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/Dashboards/BigDataController.php

@@ -4,6 +4,7 @@ namespace App\Http\Controllers\Dashboards;
 
 use App\Http\Controllers\Controller;
 use App\Models\ImportDatasource;
+use App\Models\Menu;
 use Illuminate\Http\Request;
 
 class BigDataController extends Controller
@@ -12,7 +13,8 @@ class BigDataController extends Controller
         $latest_import_datasource = ImportDatasource::latest()->first();
         $latest_created = $latest_import_datasource ? 
         $latest_import_datasource->created_at->format("j F Y H:i:s") : null;
-        return view('dashboards.bigdata', compact('latest_created'));
+        $menus = Menu::all();
+        return view('dashboards.bigdata', compact('latest_created', 'menus'));
     }
 
     public function pbg()

app/Http/Controllers/Dashboards/PotentialsController.php

@@ -3,12 +3,14 @@
 namespace App\Http\Controllers\Dashboards;
 
 use App\Http\Controllers\Controller;
+use App\Models\Menu;
 use Illuminate\Http\Request;
 
 class PotentialsController extends Controller
 {
     public function inside_system(){
-        return view('dashboards.potentials.inside_system');
+        $menus = Menu::all();
+        return view('dashboards.potentials.inside_system', compact('menus'));
     }
     public function outside_system(){
         return view('dashboards.potentials.outside_system');

app/Http/Controllers/PbgTaskAttachmentsController.php

@@ -0,0 +1,21 @@
+<?php
+
+namespace App\Http\Controllers;
+
+use App\Models\PbgTask;
+use App\Models\PbgTaskAttachment;
+use Illuminate\Http\Request;
+
+class PbgTaskAttachmentsController extends Controller
+{
+    public function show(string $id, Request $request){
+        try{
+            $title = $request->get('type') == "berita-acara" ? "Berita Acara" : "Bukti Bayar";
+            $data = PbgTaskAttachment::findOrFail($id);
+            $pbg = PbgTask::findOrFail($data->pbg_task_id);
+            return view('pbg-task-attachment.show', compact('data', 'pbg', 'title'));
+        }catch(\Exception $e){
+            return view('pages.404');
+        }
+    }
+}

app/Http/Controllers/QuickSearchController.php

@@ -0,0 +1,87 @@
+<?php
+
+namespace App\Http\Controllers;
+
+use App\Enums\PbgTaskApplicationTypes;
+use App\Enums\PbgTaskStatus;
+use App\Http\Resources\TaskAssignmentsResource;
+use App\Models\PbgTask;
+use App\Models\TaskAssignment;
+use Illuminate\Http\Request;
+
+class QuickSearchController extends Controller
+{
+    public function index(){
+        return view("quick-search.index");
+    }
+
+    public function search_result(Request $request){
+        $keyword = $request->get("keyword");
+
+        return view('quick-search.result', compact('keyword'));
+    }
+
+    public function quick_search_datatable(Request $request)
+    {
+        try {
+            $query = PbgTask::orderBy('id', 'desc');
+
+            if ($request->filled('search')) {
+                $search = $request->get('search');
+                $query->where(function ($q) use ($search) {
+                    $q->where('name', 'LIKE', "%$search%")
+                        ->orWhere('registration_number', 'LIKE', "%$search%")
+                        ->orWhere('address', 'LIKE', "%$search%")
+                        ->orWhere('document_number', 'LIKE', "%$search%");
+                });
+            }
+
+            return response()->json($query->paginate());
+        } catch (\Throwable $e) {
+            \Log::error("Error fetching datatable data: " . $e->getMessage());
+            return response()->json([
+                'message' => 'Terjadi kesalahan saat mengambil data.',
+                'error' => $e->getMessage(),
+            ], 500);
+        }
+    }
+
+    public function show($id)
+    {
+        try {
+            $data = PbgTask::with([
+                'pbg_task_retributions',
+                'pbg_task_index_integrations',
+                'pbg_task_retributions.pbg_task_prasarana'
+            ])->findOrFail($id);
+
+            $statusOptions = PbgTaskStatus::getStatuses();
+            $applicationTypes = PbgTaskApplicationTypes::labels();
+
+            return view("quick-search.detail", compact("data", 'statusOptions', 'applicationTypes'));
+        } catch (\Illuminate\Database\Eloquent\ModelNotFoundException $e) {
+            \Log::warning("PbgTask with ID {$id} not found.");
+            return redirect()->route('quick-search.index')->with('error', 'Data tidak ditemukan.');
+        } catch (\Throwable $e) {
+            \Log::error("Error in QuickSearchController@show: " . $e->getMessage());
+            return response()->view('pages.404', [], 500); // Optional: create `resources/views/errors/500.blade.php`
+        }
+    }
+
+    public function task_assignments(Request $request, $uuid){
+        try{
+            $query = TaskAssignment::query()
+            ->where('pbg_task_uid', $uuid)
+                ->orderBy('id', 'desc');
+
+            if ($request->filled('search')) {
+                $query->where('name', 'like', "%{$request->get('search')}%")
+                ->orWhere('email', 'like', "%{$request->get('search')}%");
+            }
+
+            return TaskAssignmentsResource::collection($query->paginate(config('app.paginate_per_page', 50)));
+        }catch(\Exception $exception){
+            return response()->json(['message' => $exception->getMessage()], 500);
+        }
+    }
+}

app/Http/Controllers/Report/GrowthReportsController.php

@@ -0,0 +1,14 @@
+<?php
+
+namespace App\Http\Controllers\Report;
+
+use App\Http\Controllers\Controller;
+use App\Models\Menu;
+use Illuminate\Http\Request;
+
+class GrowthReportsController extends Controller
+{
+    public function index(){
+        return view('report.growth-report.index');
+    }
+}

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/RequestAssignment/PbgTaskController.php

@@ -2,11 +2,14 @@
 
 namespace App\Http\Controllers\RequestAssignment;
 
+use App\Enums\PbgTaskApplicationTypes;
+use App\Enums\PbgTaskFilterData;
 use App\Http\Controllers\Controller;
 use App\Models\PbgTask;
 use Illuminate\Http\Request;
 use Illuminate\Support\Facades\DB;
 use Illuminate\Support\Facades\Auth;
+use App\Enums\PbgTaskStatus;
 
 class PbgTaskController extends Controller
 {
@@ -15,27 +18,21 @@ class PbgTaskController extends Controller
      */
     public function index(Request $request)
     {
-        $menuId = $request->query('menu_id');
+        $menuId = $request->query('menu_id') ?? $request->input('menu_id');
-        $user = Auth::user();
+        $filter = $request->query('filter');
-        $userId = $user->id;
 
-        // Ambil role_id yang dimiliki user
+        $permissions = $this->permissions[$menuId]?? []; // Avoid undefined index error
-        $roleIds = DB::table('user_role')
+        $creator = $permissions['allow_create'] ?? 0;
-            ->where('user_id', $userId)
+        $updater = $permissions['allow_update'] ?? 0;
-            ->pluck('role_id');
+        $destroyer = $permissions['allow_destroy'] ?? 0;
-
+        
-        // Ambil data akses berdasarkan role_id dan menu_id
+        return view('pbg_task.index', [
-        $roleAccess = DB::table('role_menu')
+            'creator' => $creator,
-            ->whereIn('role_id', $roleIds)
+            'updater' => $updater,
-            ->where('menu_id', $menuId)
+            'destroyer' => $destroyer,
-            ->first();
+            'filter' => $filter,
-
+            'filterOptions' => PbgTaskFilterData::getAllOptions(),
-        // Pastikan roleAccess tidak null sebelum mengakses properti
+        ]);        
-        $creator = $roleAccess->allow_create ?? 0;
-        $updater = $roleAccess->allow_update ?? 0;
-        $destroyer = $roleAccess->allow_destroy ?? 0;
-
-        return view('pbg_task.index', compact('creator', 'updater', 'destroyer'));
     }
 
     /**
@@ -60,7 +57,9 @@ class PbgTaskController extends Controller
     public function show(string $id)
     {
         $data = PbgTask::with(['pbg_task_retributions','pbg_task_index_integrations', 'pbg_task_retributions.pbg_task_prasarana'])->findOrFail($id);
-        return view("pbg_task.show", compact("data"));
+        $statusOptions = PbgTaskStatus::getStatuses();
+        $applicationTypes = PbgTaskApplicationTypes::labels();
+        return view("pbg_task.show", compact("data", 'statusOptions', 'applicationTypes'));
     }
 
     /**

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,13 +15,21 @@ 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(),
+            "failed_uuid" => $this->failed_uuid
         ];
     }
 }

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/Http/Resources/RequestAssignmentResouce.php

@@ -34,6 +34,14 @@ class RequestAssignmentResouce extends JsonResource
             'due_date' => $this->due_date,
             'land_certificate_phase' => $this->land_certificate_phase,
             'task_created_at' => $this->task_created_at,
+            'attachment_berita_acara' => $this->attachments
+                ->where('pbg_type', 'berita_acara')
+                ->sortByDesc('created_at')
+                ->first(),
+            'attachment_bukti_bayar' => $this->attachments
+                ->where('pbg_type', 'bukti_bayar')
+                ->sortByDesc('created_at')
+                ->first(),
         ];
     }
 }

app/Jobs/RetrySyncronizeJob.php

@@ -0,0 +1,76 @@
+<?php
+
+namespace App\Jobs;
+
+use App\Enums\ImportDatasourceStatus;
+use App\Models\BigdataResume;
+use App\Models\ImportDatasource;
+use Illuminate\Contracts\Queue\ShouldQueue;
+use Illuminate\Foundation\Queue\Queueable;
+use App\Services\ServiceTabPbgTask;
+use App\Services\ServiceGoogleSheet;
+use Illuminate\Foundation\Bus\Dispatchable;
+use Illuminate\Queue\InteractsWithQueue;
+use Illuminate\Queue\SerializesModels;
+class RetrySyncronizeJob implements ShouldQueue
+{
+    use Queueable, Dispatchable, InteractsWithQueue, SerializesModels;
+    private $import_datasource_id;
+    public function __construct(int $import_datasource_id)
+    {
+        $this->import_datasource_id = $import_datasource_id;
+    }
+
+    /**
+     * Execute the job.
+     */
+    public function handle(): void
+    {
+        try{
+            $service_tab_pbg_task = app(ServiceTabPbgTask::class);
+            $service_google_sheet = app(ServiceGoogleSheet::class);
+    
+            $failed_import = ImportDatasource::find($this->import_datasource_id);
+    
+            $failed_import->update([
+                'message' => "Retrying from UUID: ". $failed_import->failed_uuid, 
+                'status' => ImportDatasourceStatus::Processing->value,
+                'start_time' => now()
+            ]);
+    
+            $current_failed_uuid = null;
+            try{
+                $service_tab_pbg_task->run_service($failed_import->failed_uuid);
+            }catch(\Exception $e){
+                $current_failed_uuid = $service_tab_pbg_task->getFailedUUID();
+                throw $e;
+            }
+    
+            $data_setting_result = $service_google_sheet->get_big_resume_data();
+    
+            BigdataResume::generateResumeData($failed_import->id, "all", $data_setting_result);
+            BigdataResume::generateResumeData($failed_import->id, now()->year, $data_setting_result);
+    
+            $failed_import->update([
+                'status' => ImportDatasourceStatus::Success->value,
+                'message' => "Retry completed successfully from UUID: ". $failed_import->failed_uuid,
+                'finish_time' => now(),
+                'failed_uuid' => null
+            ]);
+        }catch(\Exception $e){
+            \Log::error("RetrySyncronizeJob Failed: ". $e->getMessage(), [
+                'exception' => $e,
+            ]);
+            if(isset($failed_import)){
+                $failed_import->update([
+                    'status' => ImportDatasourceStatus::Failed->value,
+                    'message' => "Retry failed from UUID: ". $failed_import->failed_uuid,
+                    'finish_time' => now(),
+                    'failed_uuid' => $current_failed_uuid
+                ]);
+            }
+
+            $this->fail($e);
+        }
+    }
+}

app/Jobs/ScrapingDataJob.php

@@ -0,0 +1,92 @@
+<?php
+
+namespace App\Jobs;
+
+use App\Models\BigdataResume;
+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(),
+                'failed_uuid' => null
+            ]);
+
+            $failed_uuid = null;
+
+            // Run the scraping services
+            $service_google_sheet->run_service();
+            $service_pbg_task->run_service();
+            try{
+                $service_tab_pbg_task->run_service();
+            }catch(\Exception $e){
+                $failed_uuid = $service_tab_pbg_task->getFailedUUID();
+                throw $e;
+            }
+
+            $data_setting_result = $service_google_sheet->get_big_resume_data();
+
+            BigdataResume::generateResumeData($import_datasource->id, "all", $data_setting_result);
+            BigdataResume::generateResumeData($import_datasource->id, now()->year, $data_setting_result);
+
+            // 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(),
+                    'failed_uuid' => $failed_uuid,
+                ]);
+            }
+
+            // 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,9 @@ class ImportDatasource extends Model
         'id',
         'message',
         'response_body',
-        'status'
+        'status',
+        'start_time',
+        'finish_time',
+        'failed_uuid'
     ];
 }

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/PbgTask.php

@@ -46,4 +46,8 @@ class PbgTask extends Model
     {
         return $this->hasMany(TaskAssignment::class, 'pbg_task_uid', 'uuid');
     }
+
+    public function attachments(){
+        return $this->hasMany(PbgTaskAttachment::class, 'pbg_task_id', 'id');
+    }
 }

app/Models/PbgTaskAttachment.php

@@ -0,0 +1,14 @@
+<?php
+
+namespace App\Models;
+
+use Illuminate\Database\Eloquent\Model;
+
+class PbgTaskAttachment extends Model
+{
+    protected $fillable = ['pbg_task_id', 'file_name', 'file_path', 'pbg_type'];
+
+    public function task(){
+        return $this->belongsTo(PbgTask::class);
+    }
+}

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/OpenAIService.php

@@ -27,6 +27,11 @@ class OpenAIService
             return "Template prompt tidak ditemukan.";
         }
 
+        $validationResponse = $this->validatePromptTopic($prompt);
+        if ($validationResponse !== 'VALID') {
+            return "Prompt yang Anda masukkan tidak relevan dengan data PUPR/SIMBG/DPUTR atau pekerjaan sejenis.";
+        }
+
         // Ambil template berdasarkan kategori
         $promptTemplate = $jsonData[$mainContent]['prompt'];
 
@@ -273,4 +278,26 @@ class OpenAIService
     
     //     return trim($response['choices'][0]['message']['content'] ?? 'No response');
     // }
+
+    public function validatePromptTopic($prompt)
+    {
+        $messages = [
+            [
+                'role' => 'system',
+                'content' => "You are a classification expert. Determine if the user's request is related to the Indonesian Ministry of Public Works and Public Housing (PUPR), DPUTR, SIMBG, or construction-related tasks managed by these institutions. 
+            
+    Only respond with:
+    - VALID → if it's relevant to those topics
+    - INVALID → if not related at all"
+            ],
+            ['role' => 'user', 'content' => $prompt],
+        ];
+
+        $response = $this->client->chat()->create([
+            'model' => 'gpt-4o-mini',
+            'messages' => $messages,
+        ]);
+
+        return trim($response['choices'][0]['message']['content'] ?? 'INVALID');
+    }
 }

app/Services/ServiceGoogleSheet.php

@@ -5,6 +5,7 @@ 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;
@@ -15,7 +16,7 @@ class ServiceGoogleSheet
     protected $spreadsheetID;
     protected $service_sheets;
     protected $import_datasource;
-    public function __construct(int $import_datasource_id)
+    public function __construct()
     {
         $this->client = new Google_Client();
         $this->client->setApplicationName("Sibedas Google Sheets API");
@@ -27,21 +28,15 @@ class ServiceGoogleSheet
         $this->spreadsheetID = env("SPREAD_SHEET_ID");
 
         $this->service_sheets = new Google_Service_Sheets($this->client);
-        $this->import_datasource = ImportDatasource::findOrFail($import_datasource_id);
     }
 
     public function run_service(){
-        $run_one = $this->sync_big_data();
+        try{
-        if(!$run_one){
+            $this->sync_big_data();
-            $this->import_datasource->update(['status' => 'failed']);
+            $this->sync_google_sheet_data();
-            return false;
+        }catch(Exception $e){
+            throw $e;
         }
-        $run_two = $this->sync_google_sheet_data();
-        if(!$run_two){
-            $this->import_datasource->update(['status' => 'failed']);
-            return false;
-        }
-        return true;
     }
     public function sync_google_sheet_data() {
         try {
@@ -49,7 +44,7 @@ class ServiceGoogleSheet
 
             if (empty($sheet_data) || count($sheet_data) < 2) {
                 Log::warning("sync_google_sheet_data: No valid data found.");
-                return false;
+                throw new Exception("sync_google_sheet_data: No valid data found.");
             }
 
             $cleanValue = function ($value) {
@@ -157,9 +152,10 @@ class ServiceGoogleSheet
             }
 
             Log::info("sync google sheet done");
+            return true;
         } catch (\Exception $e) {
             Log::error("sync_google_sheet_data failed", ['error' => $e->getMessage()]);
-            return false;
+            throw $e;
         }
     }
 
@@ -214,6 +210,47 @@ class ServiceGoogleSheet
         }
     }
 
+    public function get_big_resume_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;
+                }
+            }
+            return $data_setting_result;
+        }catch(Exception $exception){
+            Log::error("Error getting big resume data", ['error' => $exception->getMessage()]);
+            throw $exception;
+        }
+    }
+
     private function get_data_by_sheet($no_sheet = 1){
         $spreadsheet = $this->service->spreadsheets->get($this->spreadsheetID);
         $sheets = $spreadsheet->getSheets();

app/Services/ServicePbgTask.php

@@ -158,8 +158,6 @@ class ServicePbgTask
                     ]);
                 }
 
-                Log::info("Page {$currentPage} fetched & saved", ['records' => count($saved_data)]);
-
                 $currentPage++;
             } while ($currentPage <= $totalPage);
 

app/Services/ServiceTabPbgTask.php

@@ -19,6 +19,7 @@ class ServiceTabPbgTask
     private $service_token;
     private $user_token;
     private $user_refresh_token;
+    protected $current_uuid = null;
 
     public function __construct(Client $client, ServiceTokenSIMBG $service_token)
     {
@@ -34,25 +35,42 @@ class ServiceTabPbgTask
         $this->user_refresh_token = $auth_data['refresh'];
     }
 
-    public function run_service()
+    public function run_service($retry_uuid = null)
     {
         try {
-            $pbg_tasks = PbgTask::all();
+            $pbg_tasks = PbgTask::orderBy('id')->get();
+            $start = false;
 
             foreach ($pbg_tasks as $pbg_task) {
-                $this->scraping_task_assignments($pbg_task->uuid);
+                if($retry_uuid){
-                $this->scraping_task_retributions($pbg_task->uuid);
+                    if($pbg_task->uuid === $retry_uuid){
-                $this->scraping_task_integrations($pbg_task->uuid);
+                        $start = true;
+                    }
 
-                // Process task assignments here if needed
+                    if(!$start){
-                Log::info("Successfully fetched for UUID: {$pbg_task->uuid}");
+                        continue;
+                    }
+                }
+                try{
+                    $this->current_uuid = $pbg_task->uuid;
+                    $this->scraping_task_assignments($pbg_task->uuid);
+                    $this->scraping_task_retributions($pbg_task->uuid);
+                    $this->scraping_task_integrations($pbg_task->uuid);
+                }catch(\Exception $e){
+                    Log::error("Failed on UUID: {$this->current_uuid}, Error: " . $e->getMessage());
+                    throw $e;
+                }
             }
         } catch (\Exception $e) {
-            Log::error("Failed to scrape task assignments: " . $e->getMessage());
+            Log::error("Failed to syncronize: " . $e->getMessage());
             throw $e;
         }
     }
 
+    public function getFailedUUID(){
+        return $this->current_uuid;
+    }
+
     private function scraping_task_assignments($uuid)
     {
         $url = "{$this->simbg_host}/api/pbg/v1/list-tim-penilai/{$uuid}/?page=1&size=10";
@@ -115,10 +133,15 @@ class ServiceTabPbgTask
             } catch (\GuzzleHttp\Exception\ClientException $e) {
                 if ($e->getCode() === 401 && !$retriedAfter401) {
                     Log::warning("401 Unauthorized - Refreshing token and retrying...");
-                    $this->refreshToken();
+                    try{
-                    $options['headers']['Authorization'] = "Bearer {$this->user_token}";
+                        $this->refreshToken();
-                    $retriedAfter401 = true;
+                        $options['headers']['Authorization'] = "Bearer {$this->user_token}";
-                    continue; // Retry with new token
+                        $retriedAfter401 = true;
+                        continue;
+                    }catch(\Exception $refreshError){
+                        Log::error("Token refresh and login failed: " . $refreshError->getMessage());
+                        return false;
+                    }
                 }
 
                 throw $e;
@@ -221,10 +244,15 @@ class ServiceTabPbgTask
             } catch (\GuzzleHttp\Exception\ClientException $e) {
                 if ($e->getCode() === 401 && !$retriedAfter401) {
                     Log::warning("401 Unauthorized - Refreshing token and retrying...");
-                    $this->refreshToken();
+                    try{
-                    $options['headers']['Authorization'] = "Bearer {$this->user_token}";
+                        $this->refreshToken();
-                    $retriedAfter401 = true;
+                        $options['headers']['Authorization'] = "Bearer {$this->user_token}";
-                    continue;
+                        $retriedAfter401 = true;
+                        continue;
+                    }catch(\Exception $refreshError){
+                        Log::error("Token refresh and login failed: " . $refreshError->getMessage());
+                        return false;
+                    }
                 }
 
                 return false;
@@ -295,10 +323,15 @@ class ServiceTabPbgTask
             } catch (\GuzzleHttp\Exception\ClientException $e) {
                 if ($e->getCode() === 401 && !$retriedAfter401) {
                     Log::warning("401 Unauthorized - Refreshing token and retrying...");
-                    $this->refreshToken();
+                    try{
-                    $options['headers']['Authorization'] = "Bearer {$this->user_token}";
+                        $this->refreshToken();
-                    $retriedAfter401 = true;
+                        $options['headers']['Authorization'] = "Bearer {$this->user_token}";
-                    continue;
+                        $retriedAfter401 = true;
+                        continue;
+                    }catch(\Exception $refreshError){
+                        Log::error("Token refresh and login failed: " . $refreshError->getMessage());
+                        return false;
+                    }
                 }
 
                 return false;
@@ -329,22 +362,64 @@ class ServiceTabPbgTask
 
     private function refreshToken()
     {
-        try {
+        $maxRetries = 3; // Maximum retry attempts
+        $attempt = 0; 
 
-            $newAuthToken = $this->service_token->refresh_token($this->user_refresh_token);
+        while ($attempt < $maxRetries) {
+            try {
+                $attempt++;
+                Log::info("Attempt $attempt: Refreshing token...");
 
-            $this->user_token = $newAuthToken['access'];
+                $newAuthToken = $this->service_token->refresh_token($this->user_refresh_token);
-            $this->user_refresh_token = $newAuthToken['refresh'];
 
-            if (!$this->user_token) {
+                if (!isset($newAuthToken['access']) || !isset($newAuthToken['refresh'])) {
-                Log::error("Token refresh failed: No token received.");
+                    throw new \Exception("Invalid refresh token response.");
-                throw new \Exception("Failed to refresh token.");
+                }
+
+                $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
             }
+        }
 
-            Log::info("Token refreshed successfully.");
+        // If refresh fails after retries, attempt re-login
-        } catch (\Exception $e) {
+        $attempt = 0;
-            Log::error("Token refresh error: " . $e->getMessage());
+        while ($attempt < $maxRetries) {
-            throw new \Exception("Token refresh failed.");
+            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/View/Components/Circle.php

@@ -13,13 +13,15 @@ class Circle extends Component
     public $document_type;
     public $document_id;
     public $visible_small_circle;
-    public function __construct($document_id = "",$document_title = "", $document_type = "", $document_color = "#020c5c", $visible_small_circle = true)
+    public $document_url;
+    public function __construct($document_id = "",$document_title = "", $document_type = "", $document_color = "#020c5c", $visible_small_circle = true, $document_url = "#")
     {
         $this->document_title = $document_title;
         $this->document_color = $document_color;
         $this->document_type = $document_type;
         $this->document_id = $document_id;
         $this->visible_small_circle = $visible_small_circle;
+        $this->document_url = $document_url;
     }
 
     /**

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"
 }

config/queue.php

@@ -108,11 +108,4 @@ return [
         'database' => env('DB_CONNECTION', 'sqlite'),
         'table' => 'failed_jobs',
     ],
-
-    // set timeout queue
-
-    'worker' => [
-        'timeout' => 40000
-    ]
-
 ];

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/migrations/2025_03_25_085656_add_failed_uuid_on_import_datasources.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('import_datasources', function (Blueprint $table) {
+            $table->string('failed_uuid')->nullable()->after('status');
+        });
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        Schema::table('import_datasources', function (Blueprint $table) {
+            $table->dropColumn('failed_uuid');
+        });
+    }
+};

database/migrations/2025_04_09_141512_create_pbg_task_attachments_table.php

@@ -0,0 +1,32 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+return new class extends Migration
+{
+    /**
+     * Run the migrations.
+     */
+    public function up(): void
+    {
+        Schema::dropIfExists('pbg_task_attachments');
+        Schema::create('pbg_task_attachments', function (Blueprint $table) {
+            $table->id();
+            $table->foreignId('pbg_task_id')->constrained('pbg_task')->onDelete('cascade');
+            $table->string('file_name');
+            $table->string('file_path');
+            $table->string('pbg_type');
+            $table->timestamps();
+        });
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        Schema::dropIfExists('pbg_task_attachments');
+    }
+};

database/seeders/DatabaseSeeder.php

@@ -15,23 +15,41 @@ class DatabaseSeeder extends Seeder
      */
     public function run(): void
     {
-        User::updateOrCreate(
+        $users = [
-            ['email' => 'user@demo.com'], // Kondisi pencarian
             [
-                'name' => 'Darkone',
+                'email' => 'user@sibedas.com',
+                'name' => 'User',
                 'email_verified_at' => now(),
                 'password' => Hash::make('password'),
-                'firstname' => 'John',
+                'firstname' => 'user',
-                'lastname' => 'Doe',
+                'lastname' => 'user',
-                'position' => 'crusial',
+                'position' => 'user',
                 'remember_token' => Str::random(10),
-            ]
+            ],
-        );
+            [
+                'email' => 'superadmin@sibedas.com',
+                'name' => 'Superadmin',
+                'email_verified_at' => now(),
+                'password' => Hash::make('password'),
+                'firstname' => 'superadmin',
+                'lastname' => 'superadmin',
+                'position' => 'superadmin',
+                'remember_token' => Str::random(10),
+            ],
+        ];
+
+        foreach ($users as $user) {
+            User::updateOrCreate(
+                ['email' => $user['email']], // Search condition
+                $user // Update or create with this data
+            );
+        }
 
         $this->call([
             RoleSeeder::class,
             MenuSeeder::class,
-            UsersRoleMenuSeeder::class
+            UsersRoleMenuSeeder::class,
+            GlobalSettingSeeder::class,
         ]);
     }
 }

database/seeders/MenuSeeder.php

@@ -14,13 +14,20 @@ class MenuSeeder extends Seeder
      */
     public function run(): void
     {
-                $menus = [
+        $menus = [
+            [
+                "name" => "Neng Bedas",
+                "url" => "main-chatbot.index",
+                "icon" => "mingcute:wechat-line",
+                "parent_id" => null,
+                "sort_order" => 1,
+            ],
             [
                 "name" => "Dashboard",
                 "url" => "/dashboard",
                 "icon" => "mingcute:home-3-line",
                 "parent_id" => null,
-                "sort_order" => 1,
+                "sort_order" => 2,
                 "children" => [
                     [
                         "name" => "Dashboard Pimpinan",
@@ -67,7 +74,7 @@ class MenuSeeder extends Seeder
                 "url" => "/master",
                 "icon" => "mingcute:cylinder-line",
                 "parent_id" => null,
-                "sort_order" => 2,
+                "sort_order" => 3,
                 "children" => [
                     [
                         "name" => "Users",
@@ -82,7 +89,7 @@ class MenuSeeder extends Seeder
                 "url" => "/settings",
                 "icon" => "mingcute:settings-6-line",
                 "parent_id" => null,
-                "sort_order" => 3,
+                "sort_order" => 4,
                 "children" => [
                     [
                         "name" => "Syncronize",
@@ -109,7 +116,7 @@ class MenuSeeder extends Seeder
                 "url" => "/data-settings",
                 "icon" => "mingcute:settings-1-line",
                 "parent_id" => null,
-                "sort_order" => 4,
+                "sort_order" => 5,
                 "children" => [
                     [
                         "name" => "Setting Dashboard",
@@ -124,7 +131,7 @@ class MenuSeeder extends Seeder
                 "url" => "/data",
                 "icon" => "mingcute:task-line",
                 "parent_id" => null,
-                "sort_order" => 5,
+                "sort_order" => 6,
                 "children" => [
                     [
                         "name" => "PBG",
@@ -187,7 +194,7 @@ class MenuSeeder extends Seeder
                 "url" => "/laporan",
                 "icon" => "mingcute:report-line",
                 "parent_id" => null,
-                "sort_order" => 6,
+                "sort_order" => 7,
                 "children" => [
                     [
                         "name" => "Lap Pariwisata",
@@ -201,38 +208,29 @@ class MenuSeeder extends Seeder
                         "icon" => null,
                         "sort_order" => 2,
                     ],
+                    [
+                        "name" => "Lap Pertumbuhan",
+                        "url" => "growths",
+                        "icon" => null,
+                        "sort_order" => 3,
+                    ],
                     [
                         "name" => "Rekap Pembayaran",
                         "url" => "payment-recaps",
                         "icon" => null,
-                        "sort_order" => 3,
+                        "sort_order" => 4,
                     ],
                     [
                         "name" => "Lap Rekap Data Pembayaran",
                         "url" => "report-payment-recaps",
                         "icon" => null,
-                        "sort_order" => 4,
+                        "sort_order" => 5,
                     ],
                     [
                         "name" => "Lap PBG (PTSP)",
                         "url" => "report-pbg-ptsp",
                         "icon" => null,
-                        "sort_order" => 5,
+                        "sort_order" => 6,
-                    ],
-                ]
-            ],
-            [
-                "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,
                     ],
                 ]
             ],

database/seeders/RoleSeeder.php

@@ -18,10 +18,6 @@ class RoleSeeder extends Seeder
                 "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",

database/seeders/UsersRoleMenuSeeder.php

@@ -16,7 +16,7 @@ class UsersRoleMenuSeeder extends Seeder
    public function run(): void
     {
         // Fetch roles in a single query
-        $roles = Role::whereIn('name', ['superadmin', 'admin', 'operator'])->get()->keyBy('name');
+        $roles = Role::whereIn('name', ['superadmin', 'user', 'operator'])->get()->keyBy('name');
 
         // Fetch all menus in a single query and index by name
         $menus = Menu::whereIn('name', [
@@ -24,8 +24,8 @@ class UsersRoleMenuSeeder extends Seeder
             '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', 
+            'Lap Pimpinan', 'Dalam Sistem', 'Luar Sistem', 'Google Sheets', 'TPA TPT', 
-            'Approval Pejabat', 'Undangan', 'Rekap Pembayaran', 'Lap Rekap Data Pembayaran', 'Lap PBG (PTSP)'
+            'Approval Pejabat', 'Undangan', 'Rekap Pembayaran', 'Lap Rekap Data Pembayaran', 'Lap PBG (PTSP)', 'Lap Pertumbuhan'
         ])->get()->keyBy('name');
 
         // Define access levels for each role
@@ -35,16 +35,21 @@ class UsersRoleMenuSeeder extends Seeder
                 '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', 
+                'Luar Sistem', 'Lap Pimpinan', 'Google Sheets', 'TPA TPT', 'Approval Pejabat', 
-                'Undangan', 'Rekap Pembayaran', 'Lap Rekap Data Pembayaran', 'Lap PBG (PTSP)'
+                'Undangan', 'Rekap Pembayaran', 'Lap Rekap Data Pembayaran', 'Lap PBG (PTSP)', 'Lap Pertumbuhan'
             ],
-            'admin' => ['Dashboard', 'Master', 'Settings'],
+            'user' => ['Dashboard', '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', 'Google Sheets', 'TPA TPT', 'Approval Pejabat', 
+                'Undangan', 'Rekap Pembayaran', 'Lap Rekap Data Pembayaran', 'Lap PBG (PTSP)'],
             'operator' => ['Dashboard', 'Data', 'Laporan']
         ];
 
         // 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];
+        $userPermissions = ["allow_show" => true, "allow_create" => false, "allow_update" => false, "allow_destroy" => false];
         $operatorPermissions = ["allow_show" => true, "allow_create" => false, "allow_update" => false, "allow_destroy" => false];
 
         // Assign menus to roles
@@ -54,13 +59,18 @@ class UsersRoleMenuSeeder extends Seeder
                 $role->menus()->sync(
                     collect($menuNames)->mapWithKeys(fn($menuName) => [
                         $menus[$menuName]->id => ($roleName === 'superadmin' ? $superadminPermissions : 
-                                                ($roleName === 'admin' ? $adminPermissions : $operatorPermissions))
+                                                ($roleName === 'operator' ? $operatorPermissions : $userPermissions))
                     ])->toArray()
                 );
             }
         }
         
         // Attach User to role super admin
-        User::findOrFail(1)->roles()->sync([$roles['superadmin']->id]);
+        $accountSuperadmin = User::where('email', 'superadmin@sibedas.com')->first();
+        $accountUser = User::where('email', 'user@sibedas.com')->first();
+        $accountDefault = User::where('email','user@demo.com')->first();
+        $accountSuperadmin->roles()->sync([$roles['superadmin']->id]);
+        $accountUser->roles()->sync([$roles['user']->id]);
+        $accountDefault->roles()->sync([$roles['user']->id]);
     }
 }

deploy.sh

@@ -20,18 +20,20 @@ echo "🗄️ Running migrations..."
 php artisan migrate --force
 
 echo "Running seeders..."
-php artisan db:seed
+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() {
@@ -25,6 +27,7 @@ class BigdataResume {
         this.table = new Grid({
             columns: [
                 { name: "ID" },
+                { name: "Year" },
                 { name: "Jumlah Potensi" },
                 { name: "Total Potensi" },
                 { name: "Jumlah Berkas Belum Terverifikasi" },
@@ -77,6 +80,7 @@ class BigdataResume {
                 then: (data) => {
                     return data.data.map((item) => [
                         item.id,
+                        item.year,
                         item.potention_count,
                         addThousandSeparators(item.potention_sum),
                         item.non_verified_count,
@@ -114,6 +118,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/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/dashboards/potentials/inside_system.js

@@ -168,6 +168,13 @@ document.addEventListener("DOMContentLoaded", async function (e) {
     await new DashboardPotentialInsideSystem().init();
 });
 
+function handleCircleClick(element) {
+    const url = element.getAttribute("data-url") || "#";
+    if (url !== "#") {
+        window.location.href = url;
+    }
+}
+
 function resizeDashboard() {
     let targetElement = document.getElementById("lack-of-potential-wrapper");
     let dashboardElement = document.getElementById(

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/master/users/users.js

@@ -2,10 +2,25 @@ 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() {
@@ -14,7 +29,8 @@ class UsersTable {
 
         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,18 +42,28 @@ class UsersTable {
                 {
                     name: "Action",
                     formatter: (cell) => {
-                        if (!canUpdate) {
+                        if (!canUpdate && !canDestroy) {
                             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">`;
+
+                        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);
                     },
                 },
             ],
@@ -67,7 +93,6 @@ class UsersTable {
                     "Content-Type": "application/json",
                 },
                 then: (data) => {
-                    console.log(data.data);
                     return data.data.map((item) => [
                         item.id,
                         item.name,
@@ -83,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/index.js

@@ -39,7 +39,7 @@ class Menus {
                 "Name",
                 "Url",
                 "Icon",
-                "ParentID",
+                "Parent Name",
                 "Sort Order",
                 {
                     name: "Action",
@@ -97,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/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/pbg-task/index.js

@@ -1,69 +1,164 @@
-import { Grid } from "gridjs/dist/gridjs.umd.js";
+import { Grid, html } from "gridjs/dist/gridjs.umd.js";
-import "gridjs/dist/gridjs.umd.js";
-import gridjs from "gridjs/dist/gridjs.umd.js";
 import GlobalConfig from "../global-config";
 import { Dropzone } from "dropzone";
 Dropzone.autoDiscover = false;
 
 class PbgTasks {
-    init() {
+    constructor() {
-        this.initTableRequestAssignment();
+        this.table = null;
-        this.handleSendNotification();
+        this.toastMessage = document.getElementById("toast-message");
-        this.handleUpload();
+        this.toastElement = document.getElementById("toastNotification");
-        this.handleUploadBeritaAcara();
     }
 
-    initTableRequestAssignment() {
+    init() {
-        let tableContainer = document.getElementById("table-pbg-tasks");
+        this.setupFileUploadModal({
+            modalId: "modalBuktiBayar",
+            dropzoneId: "dropzoneBuktiBayar",
+            uploadBtnClass: "upload-btn-bukti-bayar",
+            removeBtnId: "removeFileBtnBuktiBayar",
+            submitBtnId: "submitBuktiBayar",
+            fileNameSpanId: "uploadedFileNameBuktiBayar",
+            fileInfoId: "fileInfoBuktiBayar",
+            pbgType: "bukti_bayar",
+            bindFlag: "uploadHandlerBoundBuktiBayar",
+        });
 
-        // Pastikan kontainer kosong sebelum merender ulang Grid.js
+        this.setupFileUploadModal({
-        tableContainer.innerHTML = "";
+            modalId: "modalBeritaAcara",
-        let canUpdate = tableContainer.getAttribute("data-updater") === "1";
+            dropzoneId: "dropzoneBeritaAcara",
-        new Grid({
+            uploadBtnClass: "upload-btn-berita-acara",
+            removeBtnId: "removeFileBtnBeritaAcara",
+            submitBtnId: "submitBeritaAcara",
+            fileNameSpanId: "uploadedFileNameBeritaAcara",
+            fileInfoId: "fileInfoBeritaAcara",
+            pbgType: "berita_acara",
+            bindFlag: "uploadHandlerBoundBeritaAcara",
+        });
+        this.handleFilterDatatable();
+        this.handleSendNotification();
+    }
+
+    handleFilterDatatable() {
+        const form = document.getElementById("filter-form");
+        const filterSelect = document.getElementById("filter-select");
+
+        const urlParams = new URLSearchParams(window.location.search);
+        const initialFilter = urlParams.get("filter") || "";
+
+        this.initTableRequestAssignment(initialFilter); // Initial load with query param
+
+        form.addEventListener("submit", (e) => {
+            e.preventDefault();
+
+            const selectedFilter = filterSelect.value;
+
+            const params = new URLSearchParams(window.location.search);
+            params.set("filter", selectedFilter);
+
+            // Update the URL without reloading
+            window.history.replaceState(
+                {},
+                "",
+                `${location.pathname}?${params}`
+            );
+
+            // Call the method again with the selected filter
+            this.initTableRequestAssignment(selectedFilter);
+        });
+    }
+
+    initTableRequestAssignment(filterValue = "") {
+        const urlBase = `${GlobalConfig.apiHost}/api/request-assignments`;
+
+        // Ambil token
+        const token = document
+            .querySelector('meta[name="api-token"]')
+            .getAttribute("content");
+
+        const config = {
             columns: [
                 "ID",
-                { name: "Name", width: "15%" },
+                { name: "Name" },
-                { name: "Condition", width: "7%" },
+                { name: "Condition" },
                 "Registration Number",
                 "Document Number",
-                { name: "Address", width: "30%" },
+                { name: "Address" },
                 "Status",
                 "Function Type",
                 "Consultation Type",
-                { name: "Due Date", width: "10%" },
+                { name: "Due Date" },
                 {
                     name: "Action",
                     formatter: (cell) => {
-                        let tableContainer =
-                            document.getElementById("table-pbg-tasks");
                         let canUpdate =
                             tableContainer.getAttribute("data-updater") === "1";
 
                         if (!canUpdate) {
-                            return gridjs.html(
+                            return html(
                                 `<span class="text-muted">No Privilege</span>`
                             );
                         }
 
-                        return gridjs.html(`
+                        return html(`
-                            <div class="d-flex justify-content-center align-items-center gap-2">
+                        <div class="d-flex justify-content-center align-items-center gap-2">
-                                <a href="/pbg-task/${cell}" class="btn btn-yellow btn-sm d-inline-flex align-items-center justify-content-center">
+                            <a href="/pbg-task/${cell.id}" 
-                                    Detail
+                            class="btn btn-yellow btn-sm d-inline-flex align-items-center justify-content-center"
-                                </a>
+                            style="white-space: nowrap; line-height: 1;">
-                                <button class="btn btn-sm btn-info upload-btn" data-id="${cell}">
+                                <iconify-icon icon="mingcute:eye-2-fill" width="15" height="15" style="vertical-align: middle;"></iconify-icon>
-                                    Upload Bukti Bayar
+                            </a>
-                                </button>
+
-                                <button class="btn btn-sm btn-info upload-btn-berita-acara" data-id="${cell}">
+                            ${
-                                    Buat Berita Acara
+                                cell.attachment_berita_acara
-                                </button>
+                                    ? `
-                            </div>
+                                        <a href="/pbg-task-attachment/${cell.attachment_berita_acara.id}?type=berita-acara"
-                        `);
+                                            class="btn btn-success btn-sm d-inline-flex align-items-center justify-content-center"
+                                            style="white-space: nowrap; line-height: 1;"
+                                            target="_blank">
+                                            <iconify-icon icon="mingcute:eye-2-fill" width="15" height="15" style="vertical-align: middle;"></iconify-icon>
+                                            <span class="ms-1">Berita Acara</span>
+                                        </a>
+                                    `
+                                    : `
+                                        <button class="btn btn-sm btn-info d-inline-flex align-items-center justify-content-center upload-btn-berita-acara"
+                                                data-id="${cell.id}"
+                                                style="white-space: nowrap; line-height: 1;">
+                                            <iconify-icon icon="mingcute:upload-2-fill" width="15" height="15" style="vertical-align: middle;"></iconify-icon>
+                                            <span class="ms-1" style="line-height: 1;">Berita Acara</span>
+                                        </button>
+                                    `
+                            }
+
+                            ${
+                                cell.attachment_bukti_bayar
+                                    ? `
+                                        <a href="/pbg-task-attachment/${cell.attachment_bukti_bayar.id}?type=bukti-bayar"
+                                            class="btn btn-success btn-sm d-inline-flex align-items-center justify-content-center"
+                                            style="white-space: nowrap; line-height: 1;"
+                                            target="_blank">
+                                            <iconify-icon icon="mingcute:eye-2-fill" width="15" height="15" style="vertical-align: middle;"></iconify-icon>
+                                            <span class="ms-1">Bukti Bayar</span>
+                                        </a>
+                                    `
+                                    : `
+                                        <button class="btn btn-sm btn-info d-inline-flex align-items-center justify-content-center upload-btn-bukti-bayar"
+                                                data-id="${cell.id}"
+                                                style="white-space: nowrap; line-height: 1;">
+                                            <iconify-icon icon="mingcute:upload-2-fill" width="15" height="15" style="vertical-align: middle;"></iconify-icon>
+                                            <span class="ms-1" style="line-height: 1;">Bukti Bayar</span>
+                                        </button>
+                                    `
+                            }
+                        </div>
+                    `);
                     },
                 },
             ],
             search: {
                 server: {
-                    url: (prev, keyword) => `${prev}?search=${keyword}`,
+                    url: (prev, keyword) =>
+                        `${prev}${
+                            prev.includes("?") ? "&" : "?"
+                        }search=${keyword}`,
                 },
                 debounceTimeout: 1000,
             },
@@ -78,12 +173,10 @@ class PbgTasks {
             },
             sort: true,
             server: {
-                url: `${GlobalConfig.apiHost}/api/request-assignments`,
+                url: `${urlBase}?filter=${filterValue}`,
                 credentials: "include",
                 headers: {
-                    Authorization: `Bearer ${document
+                    Authorization: `Bearer ${token}`,
-                        .querySelector('meta[name="api-token"]')
-                        .getAttribute("content")}`,
                     "Content-Type": "application/json",
                 },
                 then: (data) =>
@@ -98,11 +191,20 @@ class PbgTasks {
                         item.function_type,
                         item.consultation_type,
                         item.due_date,
-                        item.id,
+                        item,
                     ]),
                 total: (data) => data.meta.total,
             },
-        }).render(document.getElementById("table-pbg-tasks"));
+        };
+
+        const tableContainer = document.getElementById("table-pbg-tasks");
+
+        if (this.table) {
+            this.table.updateConfig(config).forceRender();
+        } else {
+            tableContainer.innerHTML = "";
+            this.table = new Grid(config).render(tableContainer);
+        }
     }
 
     handleSendNotification() {
@@ -128,70 +230,208 @@ class PbgTasks {
             });
     }
 
-    handleUpload() {
+    setupFileUploadModal({
-        // Handle button click to show modal
+        modalId,
-        document.addEventListener("click", function (event) {
+        dropzoneId,
-            if (event.target.classList.contains("upload-btn")) {
+        uploadBtnClass,
-                // Show modal
+        removeBtnId,
-                let uploadModal = new bootstrap.Modal(
+        submitBtnId,
-                    document.getElementById("uploadModal")
+        fileNameSpanId,
-                );
+        fileInfoId,
-                uploadModal.show();
+        pbgType,
+        bindFlag,
+    }) {
+        const modalEl = document.getElementById(modalId);
+        const modalInstance = new bootstrap.Modal(modalEl);
+        let taskId;
+
+        // Blur-fix for modal
+        modalEl.addEventListener("hide.bs.modal", () => {
+            if (
+                document.activeElement &&
+                modalEl.contains(document.activeElement)
+            ) {
+                document.activeElement.blur();
+                setTimeout(() => document.body.focus(), 10);
             }
         });
-        let dropzone = new Dropzone("#singleFileDropzone", {
-            url: "/upload-bukti-bayar", // Adjust to your backend endpoint
-            maxFiles: 1, // Allow only 1 file
-            maxFilesize: 5, // Limit size to 5MB
-            acceptedFiles: ".jpg,.png,.pdf", // Allowed file types
-            autoProcessQueue: false, // Prevent automatic upload
-            addRemoveLinks: true, // Show remove button
-            dictDefaultMessage: "Drop your file here or click to upload.",
-            init: function () {
-                let dz = this;
 
-                // Remove previous file when a new file is added
+        // Bind click listener only once
-                dz.on("addedfile", function () {
+        if (!window[bindFlag]) {
-                    if (dz.files.length > 1) {
+            document.addEventListener("click", (e) => {
-                        dz.removeFile(dz.files[0]);
+                const btn = e.target.closest(`.${uploadBtnClass}`);
-                    }
+                if (btn) {
-                });
+                    taskId = btn.getAttribute("data-id");
+                    modalInstance.show();
+                }
+            });
+            window[bindFlag] = true;
+        }
 
-                // Handle upload button click
+        // Avoid reinitializing Dropzone
-                document
+        if (!Dropzone.instances.some((dz) => dz.element.id === dropzoneId)) {
-                    .getElementById("uploadBtn")
+            const self = this;
-                    .addEventListener("click", function () {
+
-                        if (dz.getQueuedFiles().length > 0) {
+            new Dropzone(`#${dropzoneId}`, {
-                            dz.processQueue(); // Manually process upload
+                url: () => `/api/pbg-task-attachment/${taskId}`,
-                        } else {
+                maxFiles: 1,
-                            alert("Please select a file to upload.");
+                maxFilesize: 5, // MB
-                        }
+                acceptedFiles: ".jpg,.png,.pdf",
+                autoProcessQueue: false,
+                paramName: "file",
+                headers: {
+                    "X-CSRF-TOKEN": document.querySelector(
+                        'meta[name="csrf-token"]'
+                    ).content,
+                    Authorization: `Bearer ${
+                        document.querySelector('meta[name="api-token"]').content
+                    }`,
+                    Accept: "application/json",
+                },
+                params: { pbg_type: pbgType },
+                dictDefaultMessage: "Drop your file here or click to upload.",
+                init: function () {
+                    const dz = this;
+
+                    dz.on("addedfile", (file) => {
+                        if (dz.files.length > 1) dz.removeFile(dz.files[0]);
+                        setTimeout(() => {
+                            document.getElementById(
+                                fileNameSpanId
+                            ).textContent = file.name;
+                            document
+                                .getElementById(fileInfoId)
+                                .classList.remove("d-none");
+                            document
+                                .querySelector(".dz-message")
+                                .classList.add("d-none");
+                        }, 10);
                     });
 
-                // Success callback
+                    dz.on("removedfile", () => {
-                dz.on("success", function (file, response) {
+                        document
-                    alert("File uploaded successfully!");
+                            .getElementById(fileInfoId)
-                    dz.removeAllFiles(); // Clear after upload
+                            .classList.add("d-none");
-                });
+                        document.getElementById(fileNameSpanId).textContent =
+                            "";
+                        document
+                            .querySelector(".dz-message")
+                            .classList.remove("d-none");
+                    });
 
-                // Error callback
+                    document
-                dz.on("error", function (file, errorMessage) {
+                        .getElementById(removeBtnId)
-                    alert("Upload failed: " + errorMessage);
+                        .addEventListener("click", () => dz.removeAllFiles());
-                });
+
-            },
+                    document
-        });
+                        .getElementById(submitBtnId)
+                        .addEventListener("click", () => {
+                            if (dz.getQueuedFiles().length > 0) {
+                                dz.processQueue();
+                            } else {
+                                self.toastMessage.innerText =
+                                    "Please select a file to upload.";
+                                self.toast.show();
+                            }
+                        });
+
+                    dz.on("success", () => {
+                        dz.removeAllFiles(true);
+                        document
+                            .getElementById(fileInfoId)
+                            .classList.add("d-none");
+                        document.getElementById(fileNameSpanId).textContent =
+                            "";
+                        document.querySelector(".dz-message").style.display =
+                            "block";
+                        document.activeElement.blur();
+                        setTimeout(() => {
+                            document.body.focus();
+                            modalInstance.hide();
+                        }, 50);
+                        self.toastMessage.innerText =
+                            "File uploaded successfully!";
+                        self.toast.show();
+                        self.initTableRequestAssignment();
+                    });
+
+                    dz.on("error", (file, message) => {
+                        self.toastMessage.innerText =
+                            message || "Upload failed!";
+                        self.toast.show();
+                    });
+                },
+            });
+        }
     }
 
-    handleUploadBeritaAcara() {
+    handleDownloadButtons(buttonClass) {
-        // Handle button click to show modal
+        const buttons = document.querySelectorAll(`.${buttonClass}`);
-        document.addEventListener("click", function (event) {
+
-            if (event.target.classList.contains("upload-btn-berita-acara")) {
+        buttons.forEach((button) => {
-                // Show modal
+            button.addEventListener("click", () => {
-                let uploadModal = new bootstrap.Modal(
+                const attachmentId = button.getAttribute("data-id");
-                    document.getElementById("uploadBeritaAcara")
+                const originalContent = button.innerHTML;
-                );
+
-                uploadModal.show();
+                // Disable button & show loading
-            }
+                button.disabled = true;
+                button.innerHTML = `
+                <span class="spinner-border spinner-border-sm me-1" role="status" aria-hidden="true"></span>
+                Loading...
+            `;
+
+                fetch(`/api/pbg-task-attachment/${attachmentId}/download`, {
+                    method: "GET",
+                    headers: {
+                        "X-CSRF-TOKEN": document.querySelector(
+                            'meta[name="csrf-token"]'
+                        ).content,
+                        Authorization: `Bearer ${document
+                            .querySelector('meta[name="api-token"]')
+                            .getAttribute("content")}`,
+                        Accept: "application/json",
+                    },
+                })
+                    .then((response) => {
+                        if (!response.ok) {
+                            throw new Error("File not found or server error.");
+                        }
+                        return response
+                            .blob()
+                            .then((blob) => ({ blob, response }));
+                    })
+                    .then(({ blob, response }) => {
+                        const url = window.URL.createObjectURL(blob);
+                        const a = document.createElement("a");
+                        a.href = url;
+
+                        const contentDisposition = response.headers.get(
+                            "Content-Disposition"
+                        );
+                        let fileName = "downloaded-file";
+
+                        if (contentDisposition?.includes("filename=")) {
+                            fileName = contentDisposition
+                                .split("filename=")[1]
+                                .replace(/"/g, "")
+                                .trim();
+                        }
+
+                        a.download = fileName;
+                        document.body.appendChild(a);
+                        a.click();
+                        a.remove();
+                        window.URL.revokeObjectURL(url);
+                    })
+                    .catch((error) => {
+                        console.error("Download failed:", error);
+                        alert("Failed to download file.");
+                    })
+                    .finally(() => {
+                        button.disabled = false;
+                        button.innerHTML = originalContent;
+                    });
+            });
         });
     }
 }

resources/js/pbg-task/show.js

@@ -2,10 +2,22 @@ import { Grid } from "gridjs/dist/gridjs.umd.js";
 import "gridjs/dist/gridjs.umd.js";
 import gridjs from "gridjs/dist/gridjs.umd.js";
 import GlobalConfig from "../global-config";
+import flatpickr from "flatpickr";
+import "flatpickr/dist/flatpickr.min.css";
 
 class PbgTaskAssignments {
     init() {
         this.initTablePbgTaskAssignments();
+        this.handleUpdateData();
+        this.initDatePicker();
+    }
+
+    initDatePicker() {
+        let element = document.getElementById("datepicker_due_date");
+        flatpickr(element, {
+            dateFormat: "Y-m-d",
+            minDate: new Date(),
+        });
     }
 
     initTablePbgTaskAssignments() {
@@ -62,6 +74,65 @@ class PbgTaskAssignments {
             },
         }).render(tableContainer);
     }
+
+    handleUpdateData() {
+        const button = document.getElementById("btnUpdatePbgTask");
+        const form = document.getElementById("formUpdatePbgTask");
+        const toastNotification = document.getElementById("toastNotification");
+        const toast = new bootstrap.Toast(toastNotification);
+        button.addEventListener("click", function (event) {
+            event.preventDefault();
+            let submitButton = this;
+            let spinner = document.getElementById("spinner");
+            submitButton.disabled = true;
+            spinner.classList.remove("d-none");
+
+            const formData = new FormData(form);
+            const formObject = {};
+            formData.forEach((value, key) => {
+                formObject[key] = value;
+            });
+            fetch(form.action, {
+                method: "PUT", // Ensure your Laravel route is set to accept PUT requests
+                body: JSON.stringify(formObject), // Convert form data to JSON
+                credentials: "include",
+                headers: {
+                    Authorization: `Bearer ${document
+                        .querySelector('meta[name="api-token"]')
+                        .getAttribute("content")}`,
+                    "Content-Type": "application/json",
+                    "X-CSRF-TOKEN": document.querySelector(
+                        'meta[name="csrf-token"]'
+                    ).content, // For Laravel security
+                },
+            })
+                .then((response) => {
+                    if (!response.ok) {
+                        return response.json().then((err) => {
+                            throw new Error(
+                                err.message || "Something went wrong"
+                            );
+                        });
+                    }
+                    return response.json();
+                })
+                .then((data) => {
+                    document.getElementById("toast-message").innerText =
+                        data.message;
+                    toast.show();
+                    submitButton.disabled = false;
+                    spinner.classList.add("d-none");
+                })
+                .catch((error) => {
+                    console.error("Error updating task:", error);
+                    document.getElementById("toast-message").innerText =
+                        error.message;
+                    toast.show();
+                    submitButton.disabled = false;
+                    spinner.classList.add("d-none");
+                });
+        });
+    }
 }
 
 document.addEventListener("DOMContentLoaded", function (e) {

resources/js/quick-search/detail.js

@@ -0,0 +1,70 @@
+import { Grid } from "gridjs";
+class QuickSearchDetail {
+    init() {
+        this.initTablePbgTaskAssignments();
+    }
+
+    initTablePbgTaskAssignments() {
+        let tableContainer = document.getElementById(
+            "table-pbg-task-assignments"
+        );
+
+        let url_task_assignments = document.getElementById(
+            "url_task_assignments"
+        ).value;
+
+        new Grid({
+            columns: [
+                "ID",
+                "Nama",
+                "Email",
+                "Nomor Telepon",
+                "Keahlian",
+                "Status",
+            ],
+            search: {
+                server: {
+                    url: (prev, keyword) => `${prev}?search=${keyword}`,
+                },
+                debounceTimeout: 1000,
+            },
+            pagination: {
+                limit: 15,
+                server: {
+                    url: (prev, page) =>
+                        `${prev}${prev.includes("?") ? "&" : "?"}page=${
+                            page + 1
+                        }`,
+                },
+            },
+            sort: true,
+            server: {
+                url: `${url_task_assignments}`,
+                then: (data) => {
+                    return data.data.map((item) => {
+                        const expertiseArray =
+                            typeof item.expertise === "string"
+                                ? JSON.parse(item.expertise)
+                                : item.expertise;
+
+                        return [
+                            item.id,
+                            item.name,
+                            item.email,
+                            item.phone_number,
+                            Array.isArray(expertiseArray)
+                                ? expertiseArray.map((e) => e.name).join(", ")
+                                : "-",
+                            item.status_name,
+                        ];
+                    });
+                },
+                total: (data) => data.meta.total,
+            },
+        }).render(tableContainer);
+    }
+}
+
+document.addEventListener("DOMContentLoaded", function (e) {
+    new QuickSearchDetail().init();
+});

resources/js/quick-search/index.js

@@ -0,0 +1,21 @@
+document.addEventListener("DOMContentLoaded", function () {
+    const searchBtn = document.getElementById("searchBtn");
+    const searchInput = document.getElementById("searchInput");
+
+    searchBtn.addEventListener("click", function () {
+        const keyword = searchInput.value.trim();
+        if (keyword !== "") {
+            // Redirect to the route with query parameter
+            window.location.href = `/search-result?keyword=${encodeURIComponent(
+                keyword
+            )}`;
+        }
+    });
+
+    // Optional: trigger search on Enter key
+    searchInput.addEventListener("keydown", function (e) {
+        if (e.key === "Enter") {
+            searchBtn.click();
+        }
+    });
+});

resources/js/quick-search/result.js

@@ -0,0 +1,135 @@
+import { Grid, html } from "gridjs";
+
+class QuickSearchResult {
+    constructor() {
+        this.table = null;
+        const baseInput = document.getElementById("base_url_datatable");
+        this.baseUrl = baseInput ? baseInput.value.split("?")[0] : "";
+        this.keywordInput = document.getElementById("search_input");
+        this.searchButton = document.getElementById("search_button");
+
+        this.datatableUrl = this.buildUrl(this.keywordInput.value);
+    }
+
+    init() {
+        this.bindSearchButton();
+        this.initDatatable();
+    }
+
+    bindSearchButton() {
+        const handleSearch = () => {
+            const newKeyword = this.keywordInput.value.trim();
+            if (newKeyword !== "") {
+                // 1. Update datatable URL and reload
+                this.datatableUrl = this.buildUrl(newKeyword);
+                this.initDatatable();
+
+                // 2. Update URL query string (without reloading the page)
+                const newUrl = `${
+                    window.location.pathname
+                }?keyword=${encodeURIComponent(newKeyword)}`;
+                window.history.pushState({ path: newUrl }, "", newUrl);
+
+                // 3. Update visible keyword text in <em>{{ $keyword }}</em>>
+                const keywordDisplay = document.querySelector(".qs-header em");
+                if (keywordDisplay) {
+                    keywordDisplay.textContent = newKeyword;
+                }
+            }
+        };
+
+        this.searchButton.addEventListener("click", handleSearch);
+
+        this.keywordInput.addEventListener("keydown", (event) => {
+            if (event.key === "Enter") {
+                event.preventDefault();
+                handleSearch();
+            }
+        });
+    }
+
+    buildUrl(keyword) {
+        const url = new URL(this.baseUrl, window.location.origin);
+        url.searchParams.set("search", keyword);
+        return url.toString();
+    }
+
+    initDatatable() {
+        const tableContainer = document.getElementById(
+            "datatable-quick-search-result"
+        );
+
+        const config = {
+            columns: [
+                "ID",
+                { name: "Name" },
+                { name: "Condition" },
+                "Registration Number",
+                "Document Number",
+                { name: "Address" },
+                "Status",
+                "Function Type",
+                "Consultation Type",
+                { name: "Due Date" },
+                {
+                    name: "Action",
+                    formatter: (cell) => {
+                        return html(`
+                          <a href="/quick-search/${cell.id}" 
+                            class="btn btn-yellow btn-sm d-inline-flex align-items-center justify-content-center"
+                            style="white-space: nowrap; line-height: 1;">
+                                <iconify-icon icon="mingcute:eye-2-fill" width="15" height="15" style="vertical-align: middle;"></iconify-icon>
+                          </a>
+                      `);
+                    },
+                },
+            ],
+            search: false,
+            pagination: {
+                limit: 15,
+                server: {
+                    url: (prev, page) =>
+                        `${prev}${prev.includes("?") ? "&" : "?"}page=${
+                            page + 1
+                        }`,
+                },
+            },
+            sort: true,
+            server: {
+                url: this.datatableUrl,
+                then: (data) =>
+                    data.data.map((item) => [
+                        item.id,
+                        item.name,
+                        item.condition,
+                        item.registration_number,
+                        item.document_number,
+                        item.address,
+                        item.status_name,
+                        item.function_type,
+                        item.consultation_type,
+                        item.due_date,
+                        item,
+                    ]),
+                total: (data) => data.total,
+            },
+        };
+
+        if (this.table) {
+            this.table
+                .updateConfig({
+                    ...config,
+                    server: { ...config.server, url: this.datatableUrl },
+                })
+                .forceRender();
+        } else {
+            tableContainer.innerHTML = "";
+            this.table = new Grid(config).render(tableContainer);
+        }
+    }
+}
+
+document.addEventListener("DOMContentLoaded", function () {
+    const app = new QuickSearchResult();
+    app.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/growth-report/index.js

@@ -0,0 +1,94 @@
+import ApexCharts from "apexcharts";
+
+class GrowthReport {
+    init() {
+        this.loadChart();
+    }
+
+    async loadChart() {
+        try {
+            const chartElement = document.getElementById("chart-growth-report");
+            const apiUrl = chartElement.dataset.url;
+
+            const token = document
+                .querySelector('meta[name="api-token"]')
+                .getAttribute("content");
+
+            const response = await fetch(apiUrl, {
+                headers: {
+                    Authorization: `Bearer ${token}`,
+                    Accept: "application/json",
+                },
+            });
+
+            const data = await response.json();
+
+            console.log("data", data);
+
+            const categories = data.map((item) => item.date);
+
+            const potentionSeries = {
+                name: "Potensi Berkas",
+                data: data.map((item) => item.potention_sum),
+            };
+
+            const verifiedSeries = {
+                name: "Terverifikasi",
+                data: data.map((item) => item.verified_sum),
+            };
+
+            const nonVerifiedSeries = {
+                name: "Belum Terverifikasi",
+                data: data.map((item) => item.non_verified_sum),
+            };
+
+            const options = {
+                chart: {
+                    type: "bar",
+                    height: "auto",
+                },
+                title: {
+                    text: "Grafik Pertumbuhan",
+                },
+                dataLabels: {
+                    enabled: false,
+                },
+                legend: {
+                    show: true,
+                },
+                xaxis: {
+                    categories: categories,
+                },
+                yaxis: {
+                    title: {
+                        text: "Total SUM Per Date",
+                    },
+                    labels: {
+                        formatter: function (value) {
+                            return "Rp. " + value.toLocaleString("id-ID");
+                        },
+                    },
+                },
+                noData: {
+                    text: "Data tidak tersedia",
+                    align: "center",
+                    verticalAlign: "middle",
+                    style: {
+                        color: "#999",
+                        fontSize: "16px",
+                    },
+                },
+                series: [potentionSeries, verifiedSeries, nonVerifiedSeries],
+            };
+
+            const chart = new ApexCharts(chartElement, options);
+            chart.render();
+        } catch (error) {
+            console.error("Failed to load growth report data:", error);
+        }
+    }
+}
+
+document.addEventListener("DOMContentLoaded", function () {
+    new GrowthReport().init();
+});

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/index.js

@@ -56,7 +56,7 @@ class Roles {
 
                         if (canDelete) {
                             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>
                         `;

resources/js/settings/syncronize/syncronize.js

@@ -19,7 +19,32 @@ 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",
+                {
+                    name: "Action",
+                    formatter: (cell) => {
+                        if (
+                            cell.status === "failed" &&
+                            cell.failed_uuid !== null
+                        ) {
+                            return gridjs.html(`
+                                <button data-id="${cell.id}" class="btn btn-sm btn-warning d-flex align-items-center gap-1 btn-retry">
+                                    <iconify-icon icon="mingcute:refresh-3-line" width="15" height="15"></iconify-icon>
+                                    <span>Retry</span>
+                                </button>
+                            `);
+                        }
+                    },
+                },
+            ],
             search: {
                 server: {
                     url: (prev, keyword) => `${prev}?search=${keyword}`,
@@ -49,11 +74,24 @@ class SyncronizeTask {
                         item.message,
                         item.response_body,
                         item.status,
+                        item.start_time,
+                        item.duration,
+                        item.finish_time,
                         item.created_at,
+                        item,
                     ]),
                 total: (data) => data.meta.total,
             },
         }).render(tableContainer);
+
+        tableContainer.addEventListener("click", (event) => {
+            let btn = event.target.closest(".btn-retry");
+            if (btn) {
+                const id = btn.getAttribute("data-id");
+                btn.disabled = true;
+                this.handleRetrySync(id, btn);
+            }
+        });
     }
     handleSubmitSync() {
         const button = document.getElementById("btn-sync-submit");
@@ -105,6 +143,48 @@ class SyncronizeTask {
             });
     }
 
+    handleRetrySync(id, btn) {
+        const apiToken = document
+            .querySelector('meta[name="api-token"]')
+            .getAttribute("content");
+
+        fetch(`${GlobalConfig.apiHost}/api/retry-scraping/${id}`, {
+            method: "GET",
+            headers: {
+                Authorization: `Bearer ${apiToken}`,
+                "Content-Type": "application/json",
+            },
+        })
+            .then(async (response) => {
+                if (!response.ok) {
+                    throw new Error(`HTTP error! Status: ${response.status}`);
+                }
+                return response.json();
+            })
+            .then((data) => {
+                console.log("API Response:", data); // Debugging
+
+                // Show success message
+                const message =
+                    data?.data?.message ||
+                    data?.message ||
+                    "Synchronization successful!";
+                this.toastMessage.innerText = message;
+                this.toast.show();
+            })
+            .catch((err) => {
+                console.error("Fetch error:", err);
+
+                // Show error message
+                this.toastMessage.innerText =
+                    err.message ||
+                    "Failed to synchronize, something went wrong!";
+                this.toast.show();
+
+                // Re-enable button on failure
+                btn.disabled = false;
+            });
+    }
     handleSyncClick() {
         const button = document.getElementById("btn-sync-submit");
         const spinner = document.getElementById("spinner");
@@ -148,8 +228,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/scss/pages/quick-search/detail.scss

@@ -0,0 +1,73 @@
+.qs-detail-container {
+    color: #000; // black text
+    font-family: "Segoe UI", Tahoma, Geneva, Verdana, sans-serif;
+
+    .card {
+        background-color: #fff;
+
+        .card-header {
+            background-color: #f5f5f5;
+            font-weight: bold;
+            color: #000;
+        }
+
+        .card-body {
+            dt {
+                font-weight: 600;
+                color: #000;
+            }
+
+            dd {
+                margin-bottom: 10px;
+                color: #000;
+            }
+
+            .nav-tabs {
+                border-bottom: 1px solid #000;
+
+                .nav-link {
+                    color: #000;
+                    border: 1px solid transparent;
+                    border-top-left-radius: 0.25rem;
+                    border-top-right-radius: 0.25rem;
+                    font-weight: 500;
+
+                    &.active {
+                        background-color: #e0e0e0;
+                        border-color: #000 #000 #fff;
+                    }
+
+                    &:hover {
+                        color: #000;
+                    }
+                }
+            }
+
+            .tab-content {
+                padding: 1rem;
+            }
+
+            .mb-3 {
+                dt {
+                    font-weight: bold;
+                }
+
+                dd {
+                    margin-left: 0;
+                }
+            }
+
+            .border {
+                border-color: #000 !important;
+            }
+
+            .shadow-sm {
+                box-shadow: none !important;
+            }
+
+            .rounded {
+                border-radius: 4px !important;
+            }
+        }
+    }
+}

resources/scss/pages/quick-search/index.scss

@@ -0,0 +1,78 @@
+.gsp-body {
+    display: flex;
+    justify-content: center;
+    align-items: center;
+    min-height: 100vh; // ensures full vertical centering
+    background: #f0f2f5;
+}
+
+.gsp-icon {
+    width: 180px; // slightly smaller for better mobile view
+    height: auto;
+    margin-bottom: 15px;
+}
+
+.gsp-title {
+    font-size: 36px;
+    font-weight: 700;
+    color: #333;
+}
+
+.gsp-input {
+    width: 100%;
+    height: 44px;
+    font-size: 16px;
+    padding: 0 20px;
+    border-radius: 24px;
+    border: 1px solid #dfe1e5;
+    background-color: #fff;
+    box-shadow: none;
+    transition: box-shadow 0.2s ease-in-out, border-color 0.2s;
+
+    &:focus {
+        border-color: transparent;
+        box-shadow: 0 1px 6px rgba(32, 33, 36, 0.28);
+        outline: none;
+    }
+}
+
+.gsp-btn {
+    height: 44px;
+    padding: 0 24px;
+    font-size: 16px;
+    border: none;
+    border-radius: 24px;
+    background-color: #1a73e8;
+    color: white;
+    cursor: pointer;
+    transition: background-color 0.2s ease-in-out;
+
+    &:hover {
+        background-color: #1558d6;
+    }
+}
+
+@media (max-width: 576px) {
+    .gsp-input-wrapper {
+        flex-direction: column;
+        align-items: stretch;
+    }
+
+    .gsp-btn {
+        width: 100%;
+        padding: 0 20px;
+    }
+
+    .gsp-input {
+        padding: 0 20px;
+        font-size: 16px;
+    }
+
+    .gsp-title {
+        font-size: 28px;
+    }
+
+    .gsp-icon {
+        width: 140px;
+    }
+}

resources/scss/pages/quick-search/result.scss

@@ -0,0 +1,130 @@
+.qs-wrapper {
+    width: 100%;
+    margin: 0 auto;
+    font-family: "Segoe UI", Tahoma, Geneva, Verdana, sans-serif;
+    color: #2c3e50;
+}
+
+.qs-toolbar {
+    border-bottom: 1px solid #e0e0e0;
+    margin-bottom: 1.5rem;
+}
+
+.qs-search-form {
+    width: 100%;
+    .gsp-input {
+        width: 100%;
+        height: 44px;
+        font-size: 16px;
+        padding: 0 20px;
+        border-radius: 24px;
+        border: 1px solid #dfe1e5;
+        background-color: #fff;
+        box-shadow: none;
+        transition: box-shadow 0.2s ease-in-out, border-color 0.2s;
+
+        &:focus {
+            border-color: transparent;
+            box-shadow: 0 1px 6px rgba(32, 33, 36, 0.28);
+            outline: none;
+        }
+    }
+
+    .gsp-btn {
+        height: 44px;
+        padding: 0 24px;
+        font-size: 16px;
+        border: none;
+        border-radius: 24px;
+        background-color: #1a73e8;
+        color: white;
+        cursor: pointer;
+        transition: background-color 0.2s ease-in-out;
+
+        &:hover {
+            background-color: #1558d6;
+        }
+    }
+}
+
+.qs-header {
+    margin-bottom: 30px;
+    text-align: center;
+
+    h2 {
+        font-size: 24px;
+        font-weight: 600;
+        color: #1a237e;
+
+        em {
+            font-style: normal;
+            color: #0d47a1;
+        }
+    }
+
+    p {
+        font-size: 16px;
+        color: #555;
+    }
+}
+
+.qs-table-wrapper {
+    background-color: #fff;
+    border-radius: 10px;
+    box-shadow: 0 2px 8px rgba(0, 0, 0, 0.08);
+    overflow-x: auto; // allow horizontal scroll on small screens
+}
+
+/* Grid.js overrides */
+.qs-table-wrapper .gridjs {
+    font-size: 14px;
+    color: #333;
+}
+
+.qs-table-wrapper .gridjs-table {
+    width: 100%;
+    border-collapse: collapse;
+}
+
+.qs-table-wrapper .gridjs-th,
+.qs-table-wrapper .gridjs-td {
+    padding: 12px 16px;
+    border: 1px solid #e0e0e0;
+    text-align: left;
+    vertical-align: middle;
+}
+
+.qs-table-wrapper .gridjs-th {
+    background-color: #f5f5f5;
+    font-weight: 600;
+    color: #1b1b1b;
+}
+
+.qs-table-wrapper .gridjs-tr:hover {
+    background-color: #f9f9f9;
+}
+
+.qs-table-wrapper .gridjs-pagination {
+    margin-top: 16px;
+    justify-content: center;
+}
+
+@media (max-width: 768px) {
+    .qs-header h2 {
+        font-size: 20px;
+    }
+
+    .qs-wrapper {
+        padding: 20px 10px;
+    }
+
+    .qs-table-wrapper {
+        padding: 15px;
+    }
+
+    .qs-table-wrapper .gridjs-th,
+    .qs-table-wrapper .gridjs-td {
+        padding: 10px 12px;
+        font-size: 13px;
+    }
+}

resources/views/auth/signin.blade.php

@@ -21,8 +21,8 @@ class="authentication-bg"
                                     <img src="/images/dputr-kab-bandung.png" height="auto" width="100%" alt="logo light">
                                 </a>
                             </div>
-                            <h4 class="fw-bold text-dark mb-2">Welcome Back!</h4>
+                            <h4 class="fw-bold text-dark mb-2">Selamat Datang!</h4>
-                                <p class="text-muted">Sign in to your account to continue</p>
+                                <p class="text-muted">Masuk kedalam akun untuk melihat lebih lanjut</p>
                         </div>
                         <form method="POST" action="{{ route('login') }}" class="mt-4">
 
@@ -30,20 +30,26 @@ 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
 
                             <div class="mb-3">
-                                <label for="email" class="form-label">Email Address</label>
+                                <label for="email" class="form-label">Email </label>
                                 <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">
                                 <button class="btn btn-dark btn-lg fw-medium" type="submit">Sign In</button>
                             </div>
+                            <div class="d-flex justify-content-start mt-3">
+                                <a href="{{ route('search') }}" class="">
+                                    Pencarian cepat
+                                </a>
+                            </div>
                         </form>
                     </div>
                 </div>

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/components/circle.blade.php

@@ -1,8 +1,11 @@
+@props(['document_url' => '#'])
+
 @section('css')
 @vite(['resources/scss/components/_circle.scss'])
 @endsection
 
-<div class="circle-container"  id="{{$document_id}}" style="--circle-color: {{$document_color}};{{$style}}">
+<div class="circle-container"  id="{{$document_id}}" style="--circle-color: {{$document_color}};{{$style}}" data-url="{{ $document_url }}"
+     onclick="handleCircleClick(this)">
     <div class="circle-content">
         <p class="document-title {{$document_id}}" >{{$document_title}}</p>
         <p class="document-total {{$document_id}}" >Rp.0</p>
@@ -17,3 +20,12 @@
     </div>
     @endif
 </div>
+
+<script>
+    function handleCircleClick(element) {
+        const url = element.getAttribute('data-url') || '#';
+        if (url !== '#') {
+            window.location.href = url;
+        }
+    }
+</script>

resources/views/components/custom-circle.blade.php

@@ -1,11 +1,11 @@
 @props(['title' => 'title component', 'visible_data' => false, 'data_count' => '', 'visible_data_type' => false, 
-'data_type' => '','style' => '', 'size' => '', 'line' => [], 'data_id' => ''])
+'data_type' => '','style' => '', 'size' => '', 'data_id' => '', 'document_url' => '#'])
 
 @section('css')
 @vite(['resources/scss/components/_custom_circle.scss'])
 @endsection
 
-<div class="custom-circle-wrapper {{ $size }}" style="{{ $style }}">
+<div class="custom-circle-wrapper {{ $size }}" style="{{ $style }}" data-url="{{ $document_url }}" onclick="handleCircleClick(this)">
     <div class="custom-circle-content">
         <p class="custom-circle-text">{{ $title }}</p>
         @if ($visible_data === "true")
@@ -14,17 +14,5 @@
         @if ($visible_data_type === "true")
             <div class="custom-circle-data-type">{{ $data_type }}</div>
         @endif
-        @if (!empty($lines))
-            <svg class="absolute w-full h-full" viewBox="0 0 100 100" preserveAspectRatio="none">
-                @foreach ($lines as $line)
-                    <line 
-                        x1="{{ $line['x1'] }}" y1="{{ $line['y1'] }}" 
-                        x2="{{ $line['x2'] }}" y2="{{ $line['y2'] }}" 
-                        stroke="{{ $line['color'] ?? 'black' }}" 
-                        stroke-width="{{ $line['width'] ?? 2 }}"
-                    />
-                @endforeach
-            </svg>
-        @endif
     </div>
 </div>

resources/views/dashboards/bigdata.blade.php

@@ -9,22 +9,6 @@
 @include('layouts.partials/page-title', ['title' => 'Dashboards', 'subtitle' => 'Dashboard Pimpinan'])
 
 <div id="dashboard-fixed-wrapper" class="row">
-    <!-- <div class="col-12">
-        <h2 class="mt-3 ms-2 text-danger">
-            <span class="float-end fs-6 me-3 text-black d-block d-sm-inline text-end">Terakhir di update - {{$latest_created}}</span>
-            ANALISA BIG DATA PROSES PBG <br> 
-            MELALUI APLIKASI SIBEDAS PBG
-    
-        </h2>
-    </div>
-
-    <div class="row d-flex justify-content-end">
-        <div class="col-12 col-sm-6 col-md-3">
-            <div class="d-flex flex-sm-nowrap flex-wrap justify-content-end">
-                <input type="text" class="form-control" style="max-width: 125px;" id="datepicker-dashboard-bigdata" placeholder="Filter Date" />
-            </div>
-        </div>
-    </div> -->
     <div class="col-12">
         <div class="d-flex justify-content-between align-items-center mt-3 ms-2">
             <h2 class="text-danger m-0">
@@ -54,7 +38,8 @@
             'document_type' => '',
             'document_id' => 'chart-target-pad',
             'visible_small_circle' => true,
-            'style' => 'left:200px;'
+            'style' => 'left:200px;',
+            'document_url' => route('data-settings.index', ['menu_id' => $menus->where('url','data-settings.index')->first()->id])
         ])
         @endcomponent
 
@@ -72,7 +57,8 @@
             'document_type' => 'Pemohon',
             'document_id' => 'chart-total-potensi',
             'visible_small_circle' => true,
-            'style' => 'left:400px;top:150px;'
+            'style' => 'left:400px;top:150px;',
+            'document_url' => route('pbg-task.index', ['menu_id' => $menus->where('url','pbg-task.index')->first()->id, 'filter' => 'all'])
         ])
         @endcomponent
 
@@ -88,7 +74,8 @@
             'document_type' => '',
             'document_id' => 'chart-potensi-tata-ruang',
             'visible_small_circle' => true,
-            'style' => 'left:600px;'
+            'style' => 'left:600px;',
+            'document_url' => route('web-spatial-plannings.index', ['menu_id' => $menus->where('url','web-spatial-plannings.index')->first()->id])
         ])
         @endcomponent
 
@@ -101,7 +88,8 @@
             'document_type' => 'Berkas',
             'document_id' => 'chart-non-business',
             'visible_small_circle' => true,
-            'style' => 'left:900px;top:150px;'
+            'style' => 'left:900px;top:150px;',
+            'document_url' => route('pbg-task.index', ['menu_id' => $menus->where('url','pbg-task.index')->first()->id, 'filter' => 'non-business'])
         ])
         @endcomponent
 
@@ -111,7 +99,8 @@
             'document_type' => 'Berkas',
             'document_id' => 'chart-business',
             'visible_small_circle' => true,
-            'style' => 'left:900px;top:400px;'
+            'style' => 'left:900px;top:400px;',
+            'document_url' => route('pbg-task.index', ['menu_id' => $menus->where('url','pbg-task.index')->first()->id, 'filter' => 'business'])
         ])
         @endcomponent
 
@@ -121,7 +110,8 @@
             'document_type' => 'Berkas',
             'document_id' => 'chart-berkas-terverifikasi',
             'visible_small_circle' => true,
-            'style' => 'top:300px;left:200px;'
+            'style' => 'top:300px;left:200px;',
+            'document_url' => route('pbg-task.index', ['menu_id' => $menus->where('url','pbg-task.index')->first()->id, 'filter' => 'verified'])
         ])
         @endcomponent
 
@@ -137,7 +127,8 @@
             'document_type' => 'Berkas',
             'document_id' => 'chart-berkas-belum-terverifikasi',
             'visible_small_circle' => true,
-            'style' => 'top:300px;left:600px;'
+            'style' => 'top:300px;left:600px;',
+            'document_url' => route('pbg-task.index', ['menu_id' => $menus->where('url','pbg-task.index')->first()->id, 'filter' => 'non-verified'])
         ])
         @endcomponent
 
@@ -154,7 +145,8 @@
             'document_type' => 'Berkas',
             'document_id' => 'chart-realisasi-tebit-pbg',
             'visible_small_circle' => true,
-            'style' => 'top:550px;left:100px;'
+            'style' => 'top:550px;left:100px;',
+            'document_url' => 'https://docs.google.com/spreadsheets/d/1QoXzuLdEX3MK70Yrfigz0Qj5rAt4T819jX85vubBNdY/edit?gid=1514195399#gid=1514195399'
             ])
         @endcomponent
 
@@ -167,7 +159,8 @@
             'document_type' => 'Berkas',
             'document_id' => 'chart-menunggu-klik-dpmptsp',
             'visible_small_circle' => true,
-            'style' => 'top:550px;left:400px'
+            'style' => 'top:550px;left:400px',
+            'document_url' => 'https://docs.google.com/spreadsheets/d/1QoXzuLdEX3MK70Yrfigz0Qj5rAt4T819jX85vubBNdY/edit?gid=1514195399#gid=1514195399'
             ])
         @endcomponent
 
@@ -180,7 +173,8 @@
             'document_type' => 'Berkas',
             'document_id' => 'chart-proses-dinas-teknis',
             'visible_small_circle' => true,
-            'style' => 'top:550px;left:700px'
+            'style' => 'top:550px;left:700px',
+            'document_url' => 'https://docs.google.com/spreadsheets/d/1QoXzuLdEX3MK70Yrfigz0Qj5rAt4T819jX85vubBNdY/edit?gid=1514195399#gid=1514195399'
             ])
         @endcomponent
     </div>

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/dashboards/potentials/inside_system.blade.php

@@ -21,11 +21,20 @@
     <div class="wrapper">
         <div id="lack-of-potential-fixed-container" class="" style="width:1400px;height:770px;position:relative;margin:auto;z-index:1;">
             <div style="position: absolute; top: 200px; left: 50px;">
-                <x-custom-circle title="Restoran" size="small" style="background-color: #0e4753;" visible_data="true" data_id="restoran-count" data_count="0" />
+                <x-custom-circle title="Restoran" size="small" style="background-color: #0e4753;" 
+                    visible_data="true" data_id="restoran-count" data_count="0" 
+                    document_url="{{ route('web-spatial-plannings.index', ['menu_id' => $menus->where('url','web-spatial-plannings.index')->first()->id]) }}"
+                />
                 <div class="square dia-top-left-bottom-right" style="top:30px;left:50px;width:150px;height:120px;"></div>
-                <x-custom-circle title="PBB Bangunan" visible_data="true" data_id="pbb-bangunan-count" data_count="0" size="small" style="background-color: #0e4753;" />
+                <x-custom-circle title="PBB Bangunan" visible_data="true" data_id="pbb-bangunan-count" 
+                    data_count="0" size="small" style="background-color: #0e4753;" 
+                    document_url="{{ route('web-spatial-plannings.index', ['menu_id' => $menus->where('url','web-spatial-plannings.index')->first()->id]) }}"
+                />
                 <div class="square" style="width:150px;height:2px;background-color:black;left:50px;top:150px;"></div>
-                <x-custom-circle title="Reklame" visible_data="true" data_id="reklame-count" data_count="0" size="small" style="background-color: #0e4753;" />
+                <x-custom-circle title="Reklame" visible_data="true" data_id="reklame-count" 
+                    data_count="0" size="small" style="background-color: #0e4753;" 
+                    document_url="{{ route('web-advertisements.index', ['menu_id' => $menus->where('url','web-advertisements.index')->first()->id]) }}"
+                />
                 <div class="square dia-top-right-bottom-left" style="top:140px;left:50px;width:150px;height:120px;"></div>
             </div>
             
@@ -33,30 +42,39 @@
                 <div class="square dia-top-right-bottom-left" style="top:-100px;left:30px;width:150px;height:120px;"></div>
                 <div class="square dia-top-left-bottom-right" style="top:-100px;left:120px;width:120px;height:120px;"></div>
                 <x-custom-circle title="BAPENDA" size="small" style="float:left;background-color: #234f6c;" />
-                <x-custom-circle title="PDAM" visible_data="true" data_id="pdam-count" data_count="0" visible_data_type="true" data_type="Pelanggan" size="small" style="float:left;background-color: #234f6c;" />
+                <x-custom-circle title="PDAM" visible_data="true" data_id="pdam-count" 
-                <x-custom-circle title="KECAMATAN" size="small" style="float:left;background-color: #234f6c;" />
+                    visible_data_type="true" data_type="Pelanggan"
-                
+                    size="small" style="float:left;background-color: #234f6c;position: absolute;margin-left: 99px;" 
+                    document_url="{{ route('customers', ['menu_id' => $menus->where('url','customers')->first()->id]) }}"
+                />
+                <x-custom-circle title="KECAMATAN" size="small" style="float:left;background-color: #234f6c;position: absolute;margin-left: 198px;" />
             </div>
             
-            <div  style="position: absolute; top: 0px; left: 270px;">
+            <div style="position: absolute; top: 0px; left: 270px;">
                 <div class="square" style="width:5px;height:600px;background-color:black;left:70px;top:50px;"></div>
                 <div class="square dia-top-left-bottom-right" style="top:350px;left:-50px;width:120px;height:120px;"></div>
                 <div class="square dia-top-right-bottom-left" style="top:350px;left:70px;width:120px;height:120px;"></div>
                 <x-custom-circle title="Rumah Tinggal" size="small" style="background-color: #234f6c;margin:auto;" />
                 <x-custom-circle title="Non Usaha" size="large" style="background-color: #3a968b;margin-top:20px;" />
-                <x-custom-circle title="USAHA" size="large" style="background-color: #627c8b;margin-top:150px;" />
+                <x-custom-circle title="USAHA" size="large" style="background-color: #627c8b;margin-top:150px;position: absolute;" />
             </div>
             
-            <div  style="position: absolute; top: 650px; left: 110px;">
+            <div style="position: absolute; top: 650px; left: 110px;">
                 <div class="square dia-top-right-bottom-left" style="top:-110px;left:40px;width:200px;height:120px;"></div>
                 <div class="square dia-top-right-bottom-left" style="top:-110px;left:90px;width:150px;height:170px;"></div>
                 <div class="square dia-top-left-bottom-right" style="top:-110px;left:230px;width:150px;height:170px;"></div>
                 <div class="square dia-top-left-bottom-right" style="top:-110px;left:260px;width:200px;height:180px;"></div>
-                <x-custom-circle title="Villa" size="small" style="float:left;background-color: #234f6c;" visible_data="true" data_id="villa-count" data_count="0" />
+                <x-custom-circle title="Villa" size="small" style="float:left;background-color: #234f6c;" 
+                    visible_data="true" data_id="villa-count" data_count="0" 
+                    document_url="{{ route('web-tourisms.index', ['menu_id' => $menus->where('url','web-tourisms.index')->first()->id]) }}"
+                />
                 <x-custom-circle title="Pabrik" size="small" style="float:left;background-color: #234f6c;" />
                 <x-custom-circle title="Jalan Protocol" size="small" style="float:left;background-color: #234f6c;" />
                 <x-custom-circle title="Ruko" size="small" style="float:left;background-color: #234f6c;" />
-                <x-custom-circle title="Pariwisata" size="small" style="float:left;background-color: #234f6c; margin-right: 20px;" visible_data="true" data_id="pariwisata-count" data_count="0" />
+                <x-custom-circle title="Pariwisata" size="small" style="float:left;background-color: #234f6c; margin-right: 20px;" 
+                    visible_data="true" data_id="pariwisata-count" data_count="0"
+                    document_url="{{ route('web-tourisms.index', ['menu_id' => $menus->where('url','web-tourisms.index')->first()->id]) }}"
+                />
                 <div class="square" style="width:150px;height:2px;background-color:black;left:350px;top:50px;"></div>
                 <x-custom-circle title="DISBUDPAR" size="small" style="background-color: #3a968b;" />
             </div>
@@ -75,7 +93,10 @@
                     'style' => 'margin-left:180px;top:-20px;'
                     ])
                 @endcomponent
-                <x-custom-circle title="Tata Ruang" size="large" style="background-color: #da6635;float:left;margin-left:250px;" visible_data="true" data_id="tata-ruang-count" data_count="0" />
+                <x-custom-circle title="Tata Ruang" size="large" style="background-color: #da6635;float:left;margin-left:250px;" 
+                    visible_data="true" data_id="tata-ruang-count" data_count="0" 
+                    document_url="{{ route('web-spatial-plannings.index', ['menu_id' => $menus->where('url','web-spatial-plannings.index')->first()->id]) }}"
+                />
             </div>
                 
             <div style="position: absolute; top: 310px; left: 1150px;">
@@ -102,7 +123,10 @@
 
             <div  style="position: absolute; top: 50px; left: 1100px;">
                 <x-custom-circle title="Non Usaha" size="large" style="background-color: #3a968b;margin-top:20px;" />
-                <x-custom-circle title="USAHA" size="large" style="background-color: #627c8b;margin-top:260px;" visible_data="true" data_id="tata-ruang-usaha-count" data_count="0" />
+                <x-custom-circle title="USAHA" size="large" style="background-color: #627c8b;margin-top:260px;" 
+                    visible_data="true" data_id="tata-ruang-usaha-count" data_count="0" 
+                    document_url="{!! route('pbg-task.index', ['filter' => 'business', 'menu_id' => $menus->where('url','pbg-task.index')->first()->id]) !!}"
+                />
             </div>
         </div>
     </div>

resources/views/dashboards/potentials/outside_system.blade.php

@@ -27,7 +27,8 @@
                 'document_type' => 'Berkas',
                 'document_id' => 'outside-system-non-business',
                 'visible_small_circle' => true,
-                'style' => 'top:10px;'
+                'style' => 'top:10px;',
+                'document_url' => route('pbg-task.index', ['menu_id' => 13, 'filter' => 'non-business'])
             ])
             @endcomponent
             <div class="square dia-top-right-bottom-left" style="top:10px;left:180px;width:230px;height:120px;"></div>
@@ -37,7 +38,8 @@
                 'document_type' => 'Berkas',
                 'document_id' => 'outside-system-business',
                 'visible_small_circle' => true,
-                'style' => 'top:300px;'
+                'style' => 'top:300px;',
+                'document_url' => route('pbg-task.index', ['menu_id' => 13, 'filter' => 'business'])
                 ])
             @endcomponent
             <div class="square dia-top-right-bottom-left" style="top:320px;left:170px;width:200px;height:100px;"></div>

resources/views/data/google-sheet/index.blade.php

@@ -15,9 +15,9 @@
 		<div class="card w-100">
 			<div class="card-body">
 				<div class="d-flex flex-wrap justify-content-end align-items-center mb-2">
-					@if ($user_menu_permission['allow_create'])
+					<!-- @if ($user_menu_permission['allow_create'])
 						<a href="#" class="btn btn-success btn-sm d-block d-sm-inline w-auto">Create</a>
-					@endif
+					@endif -->
 				</div>
 				<div id="table-data-google-sheets"
                      data-updater="{{ $user_menu_permission['allow_update'] }}"

resources/views/exports/director_report.blade.php

@@ -0,0 +1,69 @@
+<!DOCTYPE html>
+<html lang="en">
+<head>
+    <meta charset="UTF-8">
+    <meta name="viewport" content="width=device-width, initial-scale=1.0">
+    <title>Laporan Pimpinan</title>
+    <style>
+        body { font-size: 10px; } /* Reduce font size */
+        table { width: 100%; border-collapse: collapse; }
+        th, td { padding: 3px; font-size: 9px;  border: 1px solid black;} /* Reduce padding */
+        th { background-color: #f2f2f2; }
+    </style>
+</head>
+<body>
+    <h2>Laporan Pimpinan</h2>
+    <table>
+        <thead>
+            <tr>
+                <th>Jumlah Potensi</th>
+                <th>Total Potensi</th>
+                <th>Jumlah Berkas Belum Terverifikasi</th>
+                <th>Total Berkas Belum Terverifikasi</th>
+                <th>Jumlah Berkas Terverifikasi</th>
+                <th>Total Berkas Terverifikasi</th>
+                <th>Jumlah Usaha</th>
+                <th>Total Usaha</th>
+                <th>Jumlah Non Usaha</th>
+                <th>Total Non Usaha</th>
+                <th>Jumlah Tata Ruang</th>
+                <th>Total Tata Ruang</th>
+                <th>Jumlah Menunggu Klik DPMPTSP</th>
+                <th>Total Menunggu Klik DPMPTSP</th>
+                <th>Jumlah Realisasi Terbit PBG</th>
+                <th>Total Realisasi Terbit PBG</th>
+                <th>Jumlah Proses Dinas Teknis</th>
+                <th>Total Proses Dinas Teknis</th>
+                <th>Tahun</th>
+                <th>Created</th>
+            </tr>
+        </thead>
+        <tbody>
+            @foreach($data as $item)
+            <tr>
+                <td>{{ $item->potention_count }}</td>
+                <td>{{ $item->potention_sum }}</td>
+                <td>{{ $item->non_verified_count }}</td>
+                <td>{{ $item->non_verified_sum }}</td>
+                <td>{{ $item->verified_count }}</td>
+                <td>{{ $item->verified_sum }}</td>
+                <td>{{ $item->business_count }}</td>
+                <td>{{ $item->business_sum }}</td>
+                <td>{{ $item->non_business_count }}</td>
+                <td>{{ $item->non_business_sum }}</td>
+                <td>{{ $item->spatial_count }}</td>
+                <td>{{ $item->spatial_sum }}</td>
+                <td>{{ $item->waiting_click_dpmptsp_count }}</td>
+                <td>{{ $item->waiting_click_dpmptsp_sum }}</td>
+                <td>{{ $item->issuance_realization_pbg_count }}</td>
+                <td>{{ $item->issuance_realization_pbg_sum }}</td>
+                <td>{{ $item->process_in_technical_office_count }}</td>
+                <td>{{ $item->process_in_technical_office_sum }}</td>
+                <td>{{ $item->year }}</td>
+                <td>{{ $item->created_at->format('Y-m-d') }}</td>
+            </tr>
+            @endforeach
+        </tbody>
+    </table>
+</body>
+</html>

resources/views/exports/district_payment_report.blade.php

@@ -0,0 +1,33 @@
+<!DOCTYPE html>
+<html lang="en">
+<head>
+    <meta charset="UTF-8">
+    <meta name="viewport" content="width=device-width, initial-scale=1.0">
+    <title>Laporan Rekap Data Pembayaran</title>
+    <style>
+        body { font-family: Arial, sans-serif; }
+        table { width: 100%; border-collapse: collapse; margin-top: 20px; }
+        th, td { border: 1px solid black; padding: 8px; text-align: center; }
+        th { background-color: #f2f2f2; }
+    </style>
+</head>
+<body>
+    <h2>Laporan Rekap Data Pembayaran</h2>
+    <table>
+        <thead>
+            <tr>
+                <th>Kecamatan</th>
+                <th>Total</th>
+            </tr>
+        </thead>
+        <tbody>
+            @foreach($data as $item)
+            <tr>
+                <td>{{ $item->kecamatan }}</td>
+                <td>{{ $item->total }}</td>
+            </tr>
+            @endforeach
+        </tbody>
+    </table>
+</body>
+</html>

resources/views/exports/payment_recaps_report.blade.php

@@ -0,0 +1,35 @@
+<!DOCTYPE html>
+<html lang="en">
+<head>
+    <meta charset="UTF-8">
+    <meta name="viewport" content="width=device-width, initial-scale=1.0">
+    <title>Laporan Rekap Pembayaran</title>
+    <style>
+        body { font-family: Arial, sans-serif; }
+        table { width: 100%; border-collapse: collapse; margin-top: 20px; }
+        th, td { border: 1px solid black; padding: 8px; text-align: center; }
+        th { background-color: #f2f2f2; }
+    </style>
+</head>
+<body>
+    <h2>Laporan Rekap Pembayaran</h2>
+    <table>
+        <thead>
+            <tr>
+                <th>Kategori</th>
+                <th>Nominal</th>
+                <th>Created</th>
+            </tr>
+        </thead>
+        <tbody>
+            @foreach($data as $item)
+            <tr>
+                <td>{{ $item['category'] }}</td>
+                <td>{{ $item['nominal'] }}</td>
+                <td>{{ $item['created_at'] }}</td>
+            </tr>
+            @endforeach
+        </tbody>
+    </table>
+</body>
+</html>

resources/views/exports/ptsp_report.blade.php

@@ -0,0 +1,33 @@
+<!DOCTYPE html>
+<html lang="en">
+<head>
+    <meta charset="UTF-8">
+    <meta name="viewport" content="width=device-width, initial-scale=1.0">
+    <title>Laporan PBG PTSP</title>
+    <style>
+        body { font-family: Arial, sans-serif; }
+        table { width: 100%; border-collapse: collapse; margin-top: 20px; }
+        th, td { border: 1px solid black; padding: 8px; text-align: center; }
+        th { background-color: #f2f2f2; }
+    </style>
+</head>
+<body>
+    <h2>Laporan PBG PTSP</h2>
+    <table>
+        <thead>
+            <tr>
+                <th>Status</th>
+                <th>Total</th>
+            </tr>
+        </thead>
+        <tbody>
+            @foreach($data as $item)
+            <tr>
+                <td>{{ $item->status_name }}</td>
+                <td>{{ $item->total }}</td>
+            </tr>
+            @endforeach
+        </tbody>
+    </table>
+</body>
+</html>

resources/views/exports/tourisms_report.blade.php

@@ -0,0 +1,33 @@
+<!DOCTYPE html>
+<html lang="en">
+<head>
+    <meta charset="UTF-8">
+    <meta name="viewport" content="width=device-width, initial-scale=1.0">
+    <title>Laporan Pariwisata</title>
+    <style>
+        body { font-family: Arial, sans-serif; }
+        table { width: 100%; border-collapse: collapse; margin-top: 20px; }
+        th, td { border: 1px solid black; padding: 8px; text-align: center; }
+        th { background-color: #f2f2f2; }
+    </style>
+</head>
+<body>
+    <h2>Laporan Pariwisata</h2>
+    <table>
+        <thead>
+            <tr>
+                <th>Jenis Bisnis Pariwisata</th>
+                <th>Jumlah Total</th>
+            </tr>
+        </thead>
+        <tbody>
+            @foreach($data as $item)
+            <tr>
+                <td>{{ $item->kbli_title }}</td>
+                <td>{{ $item->total_records }}</td>
+            </tr>
+            @endforeach
+        </tbody>
+    </table>
+</body>
+</html>

resources/views/master/users/index.blade.php

@@ -8,6 +8,8 @@
 
 @include('layouts.partials/page-title', ['title' => 'Master', 'subtitle' => 'Users'])
 
+<x-toast-notification />
+
 <div class="row">
     <div class="col-12">
         <div class="card w-100">

resources/views/payment-recaps/index.blade.php

@@ -13,6 +13,19 @@
 <div class="row">
     <div class="col-12">
         <div class="card w-100">
+            <div class="card-header d-flex justify-content-between align-items-center">
+                <h5 class="card-title mb-0">Rekap Pembayaran</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.payment-recaps.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.payment-recaps.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 class="row mb-3">
                     <div class="col-12 d-flex justify-content-end align-items-center flex-wrap gap-2">

resources/views/pbg-task-attachment/show.blade.php

@@ -0,0 +1,50 @@
+@extends('layouts.vertical', ['subtitle' => $title])
+
+@section('content')
+@include('layouts.partials.page-title', ['title' => 'Data', 'subtitle' => 'PBG'])
+
+<div class="row mb-4">
+  <div class="col-sm-12">
+    <div class="card border shadow-sm">
+      <div class="card-body">
+        <h5 class="mb-3">{{ $title }}</h5>
+        <p><strong>Document Number:</strong> {{ $pbg->document_number }}</p>
+      </div>
+    </div>
+  </div>
+</div>
+
+<div class="row">
+  <div class="col-sm-12">
+    <div class="card border shadow-sm">
+      <div class="card-body">
+        @php
+            $extension = strtolower(pathinfo($data->file_name, PATHINFO_EXTENSION));
+        @endphp
+
+        @if (in_array($extension, ['jpg', 'jpeg', 'png']))
+            <div class="text-center">
+              <img 
+                src="{{ asset('storage/' . $data->file_path) }}" 
+                alt="{{ $data->file_name }}" 
+                class="img-fluid border rounded" 
+                style="max-height: 600px;"
+              >
+            </div>
+        @elseif ($extension === 'pdf')
+            <iframe 
+              src="{{ asset('storage/' . $data->file_path) }}" 
+              width="100%" 
+              height="700px" 
+              style="border: none;"
+            ></iframe>
+        @else
+            <div class="alert alert-warning">
+              Unsupported file type: <strong>{{ $extension }}</strong>
+            </div>
+        @endif
+      </div>
+    </div>
+  </div>
+</div>
+@endsection

resources/views/pbg_task/index.blade.php

@@ -2,6 +2,26 @@
 
 @section('css')
 @vite(['node_modules/gridjs/dist/theme/mermaid.min.css'])
+<style>
+  #dropzoneBuktiBayar .dz-preview{
+    display: none;
+  }
+  #dropzoneBeritaAcara .dz-preview{
+    display: none;
+  }
+    .file-info-overlay {
+    position: absolute;
+    top: 50%;
+    left: 50%;
+    transform: translate(-50%, -50%);
+    z-index: 10;
+    background: rgba(255, 255, 255, 0.9);
+    padding: 0.75rem 1rem;
+    border-radius: 0.5rem;
+    display: flex;
+    align-items: center;
+  }
+</style>
 @endsection
 
 @section('content')
@@ -22,9 +42,29 @@
             <a href="{{ route('pbg-task.create')}}" class="btn btn-success btn-sm d-block d-sm-inline w-auto">Create</a>
           @endif
         </div>
+
+        <form id="filter-form">
+          <div class="row pb-3">
+            <div class="col-md-4">
+              <select name="filter" id="filter-select" class="form-select">
+                @foreach ($filterOptions as $key => $label)
+                  <option value="{{ $key }}" {{ request('filter') == $key ? 'selected' : '' }}>
+                    {{ $label }}
+                  </option>
+                @endforeach
+              </select>
+              <input name="menu_id" value="13" type="hidden" />
+            </div>
+            <div class="col-md-2">
+              <button type="submit" class="btn btn-primary w-100">Apply</button>
+            </div>
+          </div>
+        </form>
+
+        <!-- Table or Data Display Area -->
         <div id="table-pbg-tasks"
-					data-updater="{{ $updater }}"
+          data-updater="{{ $updater }}"
-					data-destroyer="{{ $destroyer }}">
+          data-destroyer="{{ $destroyer }}">
         </div>
       </div>
     </div>
@@ -71,7 +111,7 @@
 </div>
 
 <!-- Modal -->
-<div class="modal fade" id="uploadModal" tabindex="-1" aria-hidden="true">
+<div class="modal fade" id="modalBuktiBayar" tabindex="-1" aria-hidden="true">
     <div class="modal-dialog">
         <div class="modal-content">
             <div class="modal-header">
@@ -80,20 +120,25 @@
             </div>
             <div class="modal-body">
               <div class="mb-3">
-                  <form action="/upload-bukti-bayar" method="POST" class="dropzone" id="singleFileDropzone">
+                  <form action="/upload-bukti-bayar" method="POST" class="dropzone" id="dropzoneBuktiBayar">
-                      <div class="dz-message needsclick">
+                    <div class="dz-message needsclick">
-                          <i class="h1 bx bx-cloud-upload"></i>
+                      <i class="h1 bx bx-cloud-upload"></i>
-                          <h3>Drop file here or click to upload.</h3>
+                      <h3>Drop file here or click to upload.</h3>
-                          <span class="text-muted fs-13">
+                      <span class="text-muted fs-13">
-                              (Only one file allowed. Selected file will be uploaded upon clicking submit.)
+                        (Only one file allowed. Selected file will be uploaded upon clicking submit.)
-                          </span>
+                      </span>
-                      </div>
+                    </div>
+                    <!-- File info inside dropzone -->
+                    <div id="fileInfoBuktiBayar" class="file-info-overlay d-none">
+                      <span id="uploadedFileNameBuktiBayar" class="text-muted me-3"></span>
+                      <button type="button" id="removeFileBtnBuktiBayar" class="btn btn-sm btn-danger">Hapus</button>
+                    </div>
                   </form>
               </div>
 
               <!-- Submit Button -->
               <div class="d-flex justify-content-end">
-                  <button type="button" id="uploadBtn" class="btn btn-success">
+                  <button type="button" id="submitBuktiBayar" class="btn btn-success">
                       <i class="bx bx-upload"></i> Upload
                   </button>
               </div>
@@ -103,31 +148,36 @@
 </div>
 
 <!-- Modal -->
-<div class="modal fade" id="uploadBeritaAcara" tabindex="-1" aria-hidden="true">
+<div class="modal fade" id="modalBeritaAcara" tabindex="-1" aria-hidden="true">
     <div class="modal-dialog">
         <div class="modal-content">
             <div class="modal-header">
-                <h5 class="modal-title">Upload Berita Acara</h5>
+              <h5 class="modal-title">Upload Berita Acara</h5>
-                <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
+              <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
             </div>
             <div class="modal-body">
               <div class="mb-3">
-                  <form action="/upload-berita-acara" method="POST" class="dropzone" id="singleFileDropzone">
+                <form action="/upload-berita-acara" method="POST" class="dropzone" id="dropzoneBeritaAcara">
-                      <div class="dz-message needsclick">
+                  <div class="dz-message needsclick">
-                          <i class="h1 bx bx-cloud-upload"></i>
+                    <i class="h1 bx bx-cloud-upload"></i>
-                          <h3>Drop file here or click to upload.</h3>
+                    <h3>Drop file here or click to upload.</h3>
-                          <span class="text-muted fs-13">
+                    <span class="text-muted fs-13">
-                              (Only one file allowed. Selected file will be uploaded upon clicking submit.)
+                      (Only one file allowed. Selected file will be uploaded upon clicking submit.)
-                          </span>
+                    </span>
-                      </div>
+                  </div>
-                  </form>
+                  <!-- File info inside dropzone -->
+                  <div id="fileInfoBeritaAcara" class="file-info-overlay d-none">
+                    <span id="uploadedFileNameBeritaAcara" class="text-muted me-3"></span>
+                    <button type="button" id="removeFileBtnBeritaAcara" class="btn btn-sm btn-danger">Hapus</button>
+                  </div>
+                </form>
               </div>
 
               <!-- Submit Button -->
               <div class="d-flex justify-content-end">
-                  <button type="button" id="uploadBeritaAcara" class="btn btn-success">
+                <button type="button" id="submitBeritaAcara" class="btn btn-success">
-                      <i class="bx bx-upload"></i> Upload
+                  <i class="bx bx-upload"></i> Upload
-                  </button>
+                </button>
               </div>
             </div>
         </div>

resources/views/pbg_task/show.blade.php

@@ -7,69 +7,93 @@
 @section('content')
 
 @include('layouts.partials/page-title', ['title' => 'Data', 'subtitle' => 'PBG'])
-
+<x-toast-notification />
 <div class="row">
     <div class="col-12">
         <div class="card">
             <div class="card-body">
-                <div class="row">
+                <form action="{{ route('api.pbg-task.update', ['task_uuid' => $data->uuid]) }}" id="formUpdatePbgTask">
-                    <div class="col-md-6">
+                    @csrf
-                        <div class="mb-3">
+                    <div class="row mb-3">
-                            <dt>Name</dt>
+                        <div class="col-md-6">
-                            <dd>{{$data->name}}</dd>
+                            <div class="mb-3">
+                                <label for="name" class="form-label">Name</label>
+                                <input type="text" class="form-control" id="name" name="name" value="{{$data->name}}">
+                            </div>
+                            <div class="mb-3">
+                                <label for="owner_name" class="form-label">Owner Name</label>
+                                <input type="text" class="form-control" id="owner_name" name="owner_name" value="{{$data->owner_name}}">
+                            </div>
+                            <div class="mb-3">
+                                <label for="application_type" class="form-label">Application Type Name</label>
+                                <select name="application_type" class="form-select">
+                                    @foreach($applicationTypes as $key => $value)
+                                        <option value="{{ $key }}" 
+                                            {{ (old('application_type', $data->application_type ?? '') == $key) ? 'selected' : '' }}>
+                                            {{ $value }}
+                                        </option>
+                                    @endforeach
+                                </select>
+                            </div>
+                            <div class="mb-3">
+                                <label for="condition" class="form-label">Condition</label>
+                                <input type="text" class="form-control" id="condition" name="condition" value="{{$data->condition}}">
+                            </div>
+                            <div class="mb-3">
+                                <label for="registration_number" class="form-label">Registration Number</label>
+                                <input type="text" class="form-control" id="registration_number" name="registration_number" value="{{$data->registration_number}}">
+                            </div>
+                            <div class="mb-3">
+                                <label for="document_number" class="form-label">Document Number</label>
+                                <input type="text" class="form-control" id="document_number" name="document_number" value="{{$data->document_number}}">
+                            </div>
+                            <div class="mb-3">
+                                <label for="status" class="form-label">Status Name</label>
+                                <select name="status" class="form-select">
+                                    @foreach($statusOptions as $key => $value)
+                                        <option value="{{ $key }}" {{ old('status') == $key ? 'selected' : '' }}>
+                                            {{ $value }}
+                                        </option>
+                                    @endforeach
+                                </select>
+                            </div>
                         </div>
-                        <div class="mb-3">
+                        <div class="col-md-6">
-                            <dt>Owner Name</dt>
+                            <div class="mb-3">
-                            <dd>{{$data->owner_name}}</dd>
+                                <label for="address" class="form-label">Address</label>
-                        </div>
+                                <input type="text" class="form-control" id="address" name="address" value="{{$data->address}}">
-                        <div class="mb-3">
+                            </div>
-                            <dt>Aplication Type Name</dt>
+                            <div class="mb-3">
-                            <dd>{{$data->application_type_name}}</dd>
+                                <label for="slf_status_name" class="form-label">SLF Status Name</label>
-                        </div>
+                                <input type="text" class="form-control" id="slf_status_name" name="slf_status_name" value="{{$data->slf_status_name}}">
-                        <div class="mb-3">
+                            </div>
-                            <dt>Condition</dt>
+                            <div class="mb-3">
-                            <dd>{{$data->condition}}</dd>
+                                <label for="function_type" class="form-label">Function Type</label>
-                        </div>
+                                <input type="text" class="form-control" id="function_type" name="function_type" value="{{$data->function_type}}">
-                        <div class="mb-3">
+                            </div>
-                            <dt>Registration Number</dt>
+                            <div class="mb-3">
-                            <dd>{{$data->registration_number}}</dd>
+                                <label for="consultation_type" class="form-label">Consultation Type</label>
-                        </div>
+                                <input type="text" class="form-control" id="consultation_type" name="consultation_type" value="{{$data->consultation_type}}">
-                        <div class="mb-3">
+                            </div>
-                            <dt>Document Number</dt>
+                            <div class="mb-3">
-                            <dd>{{$data->document_number}}</dd>
+                                <label for="due_date" class="form-label">Due Date</label>
-                        </div>
+                                <input type="text" class="form-control" id="datepicker_due_date" name="due_date" value="{{$data->due_date}}">
-                        <div>
+                            </div>
-                            <dt>Status Name</dt>
+                            <div>
-                            <dd>{{$data->status_name}}</dd>
+                                <label for="task_created_at" class="form-label">Task Created At</label>
+                                <input type="datetime-local" class="form-control" id="task_created_at" name="task_created_at" value="{{$data->task_created_at}}" disabled>
+                            </div>
                         </div>
                     </div>
-                    <div class="col-md-6">
+                    <div class="row">
-                        <div class="mb-3">
+                        <div class="d-flex justify-content-end">
-                            <dt>Address</dt>
+                            <button type="button" id="btnUpdatePbgTask" class="btn btn-warning">
-                            <dd>{{$data->address}}</dd>
+                                <span id="spinner" class="spinner-border spinner-border-sm me-1 d-none" role="status" aria-hidden="true"></span>
-                        </div>
+                                Update
-                        <div class="mb-3">
+                            </button>
-                            <dt>SLF Status Name</dt>
-                            <dd>{{$data->slf_status_name}}</dd>
-                        </div>
-                        <div class="mb-3">
-                            <dt>Function Type</dt>
-                            <dd>{{$data->function_type}}</dd>
-                        </div>
-                        <div class="mb-3">
-                            <dt>Consultation Type</dt>
-                            <dd>{{$data->consultation_type}}</dd>
-                        </div>
-                        <div class="mb-3">
-                            <dt>Due Date</dt>
-                            <dd>{{$data->due_date}}</dd>
-                        </div>
-                        <div>
-                            <dt>Task Created At</dt>
-                            <dd>{{$data->task_created_at}}</dd>
                         </div>
                     </div>
-                </div>
+                </form>
             </div>
         </div>
     </div>

resources/views/quick-search/detail.blade.php

@@ -0,0 +1,229 @@
+@extends('layouts.base', ['subtitle' => 'Quick Search'])
+
+@section('css')
+@vite(['resources/scss/pages/quick-search/detail.scss'])
+@vite(['node_modules/gridjs/dist/theme/mermaid.min.css'])
+@endsection
+
+@section('content')
+<div class="container qs-detail-container pt-3">
+    <div class="row">
+        <div class="col-12">
+            <div class="card">
+                <div class="card-header d-flex justify-content-between align-items-center">
+                <h5 class="mb-0">Detail Informasi Permohonan PBG</h5>
+                <a href="javascript:history.back()" class="btn btn-primary">Back</a>
+                </div>
+                <div class="card-body">
+                <div class="row gy-3 gx-4">
+                    <div class="col-md-6">
+                        <dl class="row mb-0">
+                            <dt class="col-sm-5">Nama Pemohon</dt>
+                            <dd class="col-sm-7">{{ $data->name ?? '-' }}</dd>
+
+                            <dt class="col-sm-5">Nama Pemilik</dt>
+                            <dd class="col-sm-7">{{ $data->owner_name ?? '-' }}</dd>
+
+                            <dt class="col-sm-5">Jenis Permohonan</dt>
+                            <dd class="col-sm-7">{{ isset($data->application_type) ? $applicationTypes[$data->application_type] : '-' }}</dd>
+
+                            <dt class="col-sm-5">Kondisi</dt>
+                            <dd class="col-sm-7">{{ $data->condition ?? '-' }}</dd>
+
+                            <dt class="col-sm-5">Nomor Registrasi</dt>
+                            <dd class="col-sm-7">{{ $data->registration_number ?? '-'}}</dd>
+
+                            <dt class="col-sm-5">Nomor Dokumen</dt>
+                            <dd class="col-sm-7">{{ $data->document_number ?? '-' }}</dd>
+
+                            <dt class="col-sm-5">Status</dt>
+                            <dd class="col-sm-7">{{ isset($data->status) ? $statusOptions[$data->status] : '-' }}</dd>
+                        </dl>
+                    </div>
+                    <div class="col-md-6">
+                        <dl class="row mb-0">
+                            <dt class="col-sm-5">Alamat</dt>
+                            <dd class="col-sm-7">{{ $data->address ?? '-' }}</dd>
+
+                            <dt class="col-sm-5">Status SLF</dt>
+                            <dd class="col-sm-7">{{ $data->slf_status_name ?? '-' }}</dd>
+
+                            <dt class="col-sm-5">Fungsi Bangunan</dt>
+                            <dd class="col-sm-7">{{ $data->function_type ?? '-' }}</dd>
+
+                            <dt class="col-sm-5">Jenis Konsultasi</dt>
+                            <dd class="col-sm-7">{{ $data->consultation_type ?? '-' }}</dd>
+
+                            <dt class="col-sm-5">Jatuh Tempo</dt>
+                            <dd class="col-sm-7">{{$data->due_date ? \Carbon\Carbon::parse($data->due_date)->format('d M Y') : '-' }}</dd>
+
+                            <dt class="col-sm-5">Tanggal Dibuat</dt>
+                            <dd class="col-sm-7">{{ \Carbon\Carbon::parse($data->task_created_at)->format('d M Y H:i') }}</dd>
+                        </dl>
+                    </div>
+                </div>
+                </div>
+            </div>
+        </div>
+        <div class="col-12">
+            <div class="card">
+                <div class="card-header">
+                    <ul class="nav nav-tabs nav-justified">
+                        <li class="nav-item">
+                            <a href="#pbgTaskRetributions" data-bs-toggle="tab" aria-expanded="false"
+                                class="nav-link active">
+                                <span class="d-sm-block">PBG Task Retributions</span>
+                            </a>
+                        </li>
+                        <li class="nav-item">
+                            <a href="#pbgTaskIntegration" data-bs-toggle="tab" aria-expanded="false" class="nav-link">
+                                <span class="d-sm-block">PBG Task Index Integrations</span>
+                            </a>
+                        </li>
+                        <li class="nav-item">
+                            <a href="#pbgTaskPrasarana" data-bs-toggle="tab" aria-expanded="false" class="nav-link">
+                                <span class="d-sm-block">PBG Task Prasarana</span>
+                            </a>
+                        </li>
+                        <li class="nav-item">
+                            <a href="#pbgTaskAssignments" data-bs-toggle="tab" aria-expanded="false" class="nav-link">
+                                <span class="d-sm-block">Penugasan</span>
+                            </a>
+                        </li>
+                    </ul>
+                </div>
+                <div class="card-body">
+                    <div class="tab-content">
+                        <div class="tab-pane active" id="pbgTaskRetributions">
+                            @if ($data->pbg_task_retributions)                    
+                                <div class="row">
+                                    <div class="col-md-6">
+                                        <dl class="row mb-0">
+                                            <dt class="col-sm-4">Luas Bangunan</dt>
+                                            <dd class="col-sm-8">{{$data->pbg_task_retributions->luas_bangunan ?? '-'}}</dd>
+    
+                                            <dt class="col-sm-4">Indeks Lokalitas</dt>
+                                            <dd class="col-sm-8">{{$data->pbg_task_retributions->indeks_lokalitas ?? '-'}}</dd>
+                                            
+                                            <dt class="col-sm-4">Wilayah SHST</dt>
+                                            <dd class="col-sm-8">{{$data->pbg_task_retributions->wilayah_shst ?? '-'}}</dd>
+                                            
+                                            <dt class="col-sm-4">Nama Kegiatan</dt>
+                                            <dd class="col-sm-8">{{$data->pbg_task_retributions->kegiatan_name ?? '-'}}</dd>
+                                            
+                                            <dt class="col-sm-4">Nilai SHST</dt>
+                                            <dd class="col-sm-8">{{$data->pbg_task_retributions->nilai_shst ?? '-'}}</dd>
+                                            
+                                            <dt class="col-sm-4">Indeks Integrasi</dt>
+                                            <dd class="col-sm-8">{{$data->pbg_task_retributions->indeks_terintegrasi ?? '-'}}</dd>
+                                            
+                                            <dt class="col-sm-4">Indeks Bg Terbangun</dt>
+                                            <dd class="col-sm-8">{{$data->pbg_task_retributions->indeks_bg_terbangun ?? '-'}}</dd>
+                                        </dl>
+                                    </div>
+                                    <div class="col-md-6">
+                                        <dl class="row mb-0">
+                                            <dt class="col-sm-4">Nilai Retribusi Bangunan</dt>
+                                            <dd class="col-sm-8">{{$data->pbg_task_retributions->nilai_retribusi_bangunan ?? '-'}}</dd>
+
+                                            <dt class="col-sm-4">Nilai Prasarana</dt>
+                                            <dd class="col-sm-8">{{$data->pbg_task_retributions->nilai_prasarana ?? '-'}}</dd>
+                                            
+                                            <dt class="col-sm-4">PBG Dokumen</dt>
+                                            <dd class="col-sm-8">{{$data->pbg_task_retributions->pbg_document ?? '-'}}</dd>
+                                            
+                                            <dt class="col-sm-4">Underpayment</dt>
+                                            <dd class="col-sm-8">{{$data->pbg_task_retributions->underpayment ?? '-'}}</dd>
+                                            
+                                            <dt class="col-sm-4">SKRD Amount</dt>
+                                            <dd class="col-sm-8">{{$data->pbg_task_retributions->skrd_amount ?? '-'}}</dd>
+                                        </dl>
+                                    </div>
+                                </div>
+                            @else
+                                <div class="alert alert-secondary" role="alert">
+                                    Data Not Available
+                                </div>
+                            @endif
+                        </div>
+                        <div class="tab-pane" id="pbgTaskIntegration">
+                            @if ($data->pbg_task_index_integrations)
+                                <dl class="row">
+                                    <dt class="col-sm-4">Indeks Fungsi Bangunan</dt>
+                                    <dd class="col-sm-8">{{$data->pbg_task_index_integrations->indeks_fungsi_bangunan ?? '-'}}</dd>
+
+                                    <dt class="col-sm-4">Indeks Parameter Kompleksitas</dt>
+                                    <dd class="col-sm-8">{{$data->pbg_task_index_integrations->indeks_parameter_kompleksitas ?? '-'}}</dd>
+
+                                    <dt class="col-sm-4">Indeks Parameter Permanensi</dt>
+                                    <dd class="col-sm-8">{{$data->pbg_task_index_integrations->indeks_parameter_permanensi ?? '-'}}</dd>
+
+                                    <dt class="col-sm-4">Indeks Parameter Ketinggian</dt>
+                                    <dd class="col-sm-8">{{$data->pbg_task_index_integrations->indeks_parameter_ketinggian ?? '-'}}</dd>
+
+                                    <dt class="col-sm-4">Faktor Kepemilikan</dt>
+                                    <dd class="col-sm-8">{{$data->pbg_task_index_integrations->faktor_kepemilikan ?? '-'}}</dd>
+
+                                    <dt class="col-sm-4">Indeks Terintegrasi</dt>
+                                    <dd class="col-sm-8">{{$data->pbg_task_index_integrations->indeks_terintegrasi ?? '-'}}</dd>
+
+                                    <dt class="col-sm-4">Total</dt>
+                                    <dd class="col-sm-8">{{$data->pbg_task_index_integrations->total ?? '-'}}</dd>
+                                </dl>
+                            @else
+                                <div class="alert alert-secondary" role="alert">
+                                    Data Not Available
+                                </div>
+                            @endif
+                        </div>
+                        <div class="tab-pane" id="pbgTaskPrasarana">
+                            <div class="row d-flex flex-warp gap-3 justify-content-center">
+                                @if ($data->pbg_task_retributions && $data->pbg_task_retributions->pbg_task_prasarana)
+                                    @foreach ($data->pbg_task_retributions->pbg_task_prasarana as $prasarana)
+                                        <div class="border p-3 rounded shadow-sm col-md-4">
+                                            <dl class="row">
+                                                <dt class="col-sm-4">Prasarana Type</dt>
+                                                <dd class="col-sm-8">{{$prasarana->prasarana_type ?? '-'}}</dd>
+
+                                                <dt class="col-sm-4">Building Type</dt>
+                                                <dd class="col-sm-8">{{$prasarana->building_type ?? '-'}}</dd>
+                                                
+                                                <dt class="col-sm-4">Total</dt>
+                                                <dd class="col-sm-8">{{$prasarana->total ?? '-'}}</dd>
+                                                
+                                                <dt class="col-sm-4">Quantity</dt>
+                                                <dd class="col-sm-8">{{$prasarana->quantity ?? '-'}}</dd>
+                                                
+                                                <dt class="col-sm-4">Unit</dt>
+                                                <dd class="col-sm-8">{{$prasarana->unit ?? '-'}}</dd>
+                                                
+                                                <dt class="col-sm-4">Index Prasarana</dt>
+                                                <dd class="col-sm-8">{{$prasarana->index_prasarana ?? '-'}}</dd>
+                                                
+                                                <dt class="col-sm-4">Created At</dt>
+                                                <dd class="col-sm-8">{{$prasarana->created_at ? \Carbon\Carbon::parse($prasarana->created_at)->format('d M Y') : '-'}}</dd>
+                                            </dl>
+                                        </div>
+                                    @endforeach
+                                @else
+                                    <div class="alert alert-secondary" role="alert">
+                                        Data Not Available
+                                    </div>
+                                @endif
+                            </div>
+                        </div>
+                        <div class="tab-pane" id="pbgTaskAssignments">
+                            <input type="hidden" id="url_task_assignments" value="{{ route('api.quick-search-task-assignments', ['uuid' => $data->uuid]) }}" />
+                            <div id="table-pbg-task-assignments"></div>
+                        </div>
+                    </div>
+                </div>
+            </div>
+        </div>
+    </div>
+</div>
+@endsection
+
+@section('scripts')
+@vite(['resources/js/quick-search/detail.js'])
+@endsection

resources/views/quick-search/index.blade.php

@@ -0,0 +1,35 @@
+@extends('layouts.base', ['subtitle' => 'Quick Search'])
+
+@section('css')
+@vite(['resources/scss/pages/quick-search/index.scss'])
+@endsection
+
+@section('body-attribuet')
+class="gsp-body"
+@endsection
+
+@section('content')
+<div class="position-absolute top-0 end-0 p-3">
+    <a href="{{ route('login') }}" class="btn btn-md btn-secondary">
+        Login
+    </a>
+</div>
+<div class="container min-vh-100 d-flex justify-content-center align-items-center gsp-body">
+    <div class="w-100" style="max-width: 700px;">
+        <div class="text-center mb-4">
+            <img src="{{ asset('images/simbg-dputr.png') }}" alt="PBG Icon" class="img-fluid gsp-icon mb-3">
+            <h1 class="gsp-title">SIBEDAS PBG</h1>
+        </div>
+        <div class="d-flex flex-column flex-sm-row align-items-stretch gap-2">
+            <div class="flex-fill">
+                <input type="text" class="gsp-input" id="searchInput" placeholder="Cari..." autocomplete="off" />
+            </div>
+            <button class="gsp-btn" id="searchBtn">Cari</button>
+        </div>
+    </div>
+</div>
+@endsection
+
+@section('scripts')
+@vite(['resources/js/quick-search/index.js'])
+@endsection 

resources/views/quick-search/result.blade.php

@@ -0,0 +1,44 @@
+@extends('layouts.base', ['subtitle' => 'Quick Search'])
+
+@section('css')
+@vite(['resources/scss/pages/quick-search/result.scss'])
+@vite(['node_modules/gridjs/dist/theme/mermaid.min.css'])
+@endsection
+
+@section('content')
+<input type="hidden" value="{{ route('quick-search-datatable', ['search' => $keyword]) }}" id="base_url_datatable" />
+
+<div class="container qs-wrapper">
+  <div class="qs-toolbar d-flex justify-content-between align-items-center pt-4 pb-4">
+    <!-- Back Button -->
+    <a href="{{ route('search') }}" class="btn btn-light border me-3">
+       Kembali
+    </a>
+    <!-- Search Area (no form action) -->
+    <div class="qs-search-form d-flex align-items-center">
+      <input
+        type="text"
+        id="search_input"
+        class="gsp-input me-2"
+        value="{{ $keyword }}"
+        placeholder="Cari data..."
+        required
+      />
+      <button type="button" id="search_button" class="gsp-btn">Cari</button>
+    </div>
+  </div>
+
+  <div class="qs-header mb-3">
+    <h2>Hasil Pencarian: <em>{{ $keyword }}</em></h2>
+    <p>Berikut adalah data hasil pencarian berdasarkan kata kunci yang Anda masukkan.</p>
+  </div>
+
+  <div class="qs-table-wrapper">
+    <div class="p-3" id="datatable-quick-search-result"></div>
+  </div>
+</div>
+@endsection
+
+@section('scripts')
+@vite(['resources/js/quick-search/result.js'])
+@endsection