fix handle disable button when upload business industries

README.md

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

app/Http/Controllers/Api/BigDataResumeController.php

@@ -3,6 +3,7 @@
 namespace App\Http\Controllers\Api;
 
 use App\Http\Controllers\Controller;
+use App\Http\Resources\BigdataResumeResource;
 use App\Models\BigdataResume;
 use App\Models\DataSetting;
 use Illuminate\Http\Request;
@@ -38,14 +39,14 @@ class BigDataResumeController extends Controller
             }
 
             $target_pad = floatval(optional($data_settings->where('key', 'TARGET_PAD')->first())->value);
-            $tata_ruang = floatval(optional($data_settings->where('key', 'TATA_RUANG')->first())->value);
             $realisasi_terbit_pbg_sum = floatval(optional($data_settings->where('key', 'REALISASI_TERBIT_PBG_SUM')->first())->value);
             $realisasi_terbit_pbg_count = floatval(optional($data_settings->where('key', 'REALISASI_TERBIT_PBG_COUNT')->first())->value);
             $menuggu_klik_dpmptsp_sum = floatval(optional($data_settings->where('key', 'MENUNGGU_KLIK_DPMPTSP_SUM')->first())->value);
             $menuggu_klik_dpmptsp_count = floatval(optional($data_settings->where('key', 'MENUNGGU_KLIK_DPMPTSP_COUNT')->first())->value);
             $proses_dinas_teknis_sum = floatval(optional($data_settings->where('key', 'PROSES_DINAS_TEKNIS_SUM')->first())->value);
             $proses_dinas_teknis_count = floatval(optional($data_settings->where('key', 'PROSES_DINAS_TEKNIS_COUNT')->first())->value);
-
+            
+            $tata_ruang = $big_data_resume->spatial_sum;
             $kekurangan_potensi = $target_pad - $big_data_resume->potention_sum;
 
             // percentage kekurangan potensi
@@ -94,7 +95,8 @@ class BigDataResumeController extends Controller
                     'percentage' => 100,
                 ],
                 'tata_ruang' => [
-                    'sum' => $tata_ruang,
+                    'sum' => $big_data_resume->spatial_sum,
+                    'count' => $big_data_resume->spatial_count,
                     'percentage' => $tata_ruang_percentage,
                 ],
                 'kekurangan_potensi' => [
@@ -148,6 +150,22 @@ class BigDataResumeController extends Controller
         }
     }
 
+    public function bigdata_report(Request $request){
+        try{
+            $query = BigdataResume::query()->orderBy('id', 'desc');
+        
+            if($request->filled('search')){
+                $query->where('name', 'LIKE', '%'.$request->input('search').'%');
+            }
+
+            $query = $query->paginate(15);
+            return  BigdataResumeResource::collection($query)->response()->getData(true);
+        }catch(\Exception $e){
+            Log::error($e->getMessage());
+            return response()->json(['message' => 'Error when fetching data'], 500);
+        }
+    }
+
     /**
      * Store a newly created resource in storage.
      */

app/Http/Controllers/Api/BusinessOrIndustriesController.php

@@ -9,6 +9,7 @@ use App\Models\BusinessOrIndustry;
 use Illuminate\Http\Request;
 use Maatwebsite\Excel\Facades\Excel;
 use \Illuminate\Support\Facades\Validator;
+use App\Http\Requests\ExcelUploadRequest;
 class BusinessOrIndustriesController extends Controller
 {
     /**
@@ -79,29 +80,15 @@ class BusinessOrIndustriesController extends Controller
         }
     }
 
-    public function upload(Request $request){
+    public function upload(ExcelUploadRequest $request){
-
-        if ($request->hasFile('file')) {
-            $file = $request->file('file');
-        }
-
-        // Validasi file
-        $validator = Validator::make($request->all(), [
-            'file' => 'required|mimes:xlsx,xls|max:102400', // Max 100MB
-        ]);
-
-        if ($validator->fails()) {
-            return response()->json([
-                'message' => 'File validation failed.',
-                'errors' => $validator->errors()
-            ], 400);
-        }
-
         try {
-            // Ambil file dari request
+            if(!$request->hasFile('file')){
-            $file = $request->file('file');
+                return response()->json([
+                   'error' => 'No file provided'
+                ], 400);
+            }
 
-            // Menggunakan Laravel Excel untuk mengimpor file
+            $file = $request->file('file');
             Excel::import(new BusinessIndustriesImport, $file);
 
             // Jika sukses, kembalikan respons sukses

app/Http/Controllers/Api/ChatbotController.php

@@ -1,84 +0,0 @@
-<?php
-
-namespace App\Http\Controllers\Api;
-
-use Illuminate\Http\Request;
-use App\Services\OpenAIService;
-use App\Http\Controllers\Controller;
-use Illuminate\Http\Response;
-use Illuminate\Support\Facades\DB;
-
-class ChatbotController extends Controller
-{
-    protected $openAIService;
-
-    public function __construct(OpenAIService $openAIService)
-    {
-        $this->openAIService = $openAIService;
-    }
-
-    public function generateText(Request $request)
-    {
-        info($request);
-        $request->validate([
-            'tab_active' => 'required|string',
-            'prompt' => 'required|string',
-        ]);
-
-        $tab_active = $request->input('tab_active');
-        $main_content = match ($tab_active) {
-            "count-retribusi" => "RETRIBUTION",
-            "document-validation" => "DOCUMENT VALIDATION",
-            "data-information" => "DATA SUMMARY",
-            default => "UNKNOWN",
-        };
-
-        if ($main_content === "UNKNOWN") {
-            return response()->json(['response' => 'Invalid tab_active value.'], 400);
-        }
-
-        info($main_content);
-
-        // Klasifikasi apakah pertanyaan butuh database atau bisa dijawab langsung
-        $classifyResponse = $this->openAIService->generateClassifyMainContent($request->input('prompt'), $main_content);
-
-        if ($classifyResponse === "DATABASE") {
-            $queryResponse = $this->openAIService->generateQueryBasedMainContent($request->input('prompt'), $main_content);
-            if (is_array($queryResponse)) {
-                info('Query Response is an array: ', $queryResponse);
-            } else {
-                info('Query Response is a string: ' . $queryResponse);
-            }
-            
-            // Validasi query dua kali sebelum eksekusi
-            if (
-                $this->openAIService->validateSyntaxQuery($queryResponse) === "VALID" &&
-                $this->openAIService->validateSyntaxQuery($queryResponse) === "VALID"
-            ) {
-                info($queryResponse);
-                $queryResponse = str_replace(['```sql', '```'], '', $queryResponse);
-                $resultQuery = DB::select($queryResponse);
-                $formattedResultQuery = json_encode($resultQuery, JSON_PRETTY_PRINT);
-                $nlpResult = $this->openAIService->generateNLPFromQuery($request->input('prompt'), $formattedResultQuery);
-                $finalGeneratedText =$this->openAIService->generateFinalText($nlpResult);
-                return response()->json(['response' => $finalGeneratedText]);
-            }
-
-            return response()->json(['response' => ''], 400);
-        }
-
-        if ($classifyResponse === "GENERAL") {
-            $nlpResult = $this->openAIService->generateGeneralText($request->input('prompt'), $main_content);
-            $finalGeneratedText =$this->openAIService->generateFinalText($nlpResult);
-            return response()->json(['response' => $finalGeneratedText]);
-        }
-
-        return response()->json(['response' => ''], 500);
-    }
-
-
-    private function classifyContent(string $prompt) {
-        $classifyResponse = $this->openAIService->generateClassifyContent($prompt);
-        return $classifyResponse;
-    }
-}

app/Http/Controllers/Api/CustomersController.php

@@ -22,7 +22,7 @@ class CustomersController extends Controller
         if ($request->has('search') &&!empty($request->get('search'))) {
             $query = $query->where('nomor_pelanggan', 'LIKE', '%'.$request->get('search').'%')
                 ->orWhere('nama', 'LIKE', '%'.$request->get('search').'%')
-                ->orWhere('kota_palayanan', 'LIKE', '%'.$request->get('search').'%');
+                ->orWhere('kota_pelayanan', 'LIKE', '%'.$request->get('search').'%');
         }
         return CustomersResource::collection($query->paginate());
     }

app/Http/Controllers/BigdataResumesController.php

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

app/Http/Controllers/Chatbot/ChatbotController.php

@@ -1,17 +0,0 @@
-<?php
-
-namespace App\Http\Controllers\Chatbot;
-
-use App\Http\Controllers\Controller;
-use Illuminate\Http\Request;
-
-class ChatbotController extends Controller
-{
-    /**
-     * Displya a listing of the resource
-     */
-    public function index()
-    {
-        return view('chatbot.index');
-    }
-}

app/Http/Resources/BigdataResumeResource.php

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

app/Imports/BusinessIndustriesImport.php

@@ -3,37 +3,105 @@
 namespace App\Imports;
 
 use App\Models\BusinessOrIndustry;
-use Maatwebsite\Excel\Concerns\ToModel;
-use Maatwebsite\Excel\Concerns\ToCollection;
 use Illuminate\Support\Collection;
+use Maatwebsite\Excel\Concerns\ToCollection;
+use Maatwebsite\Excel\Concerns\WithChunkReading;
+use Maatwebsite\Excel\Concerns\WithHeadingRow;
+use Maatwebsite\Excel\Concerns\WithMultipleSheets;
+use Illuminate\Contracts\Queue\ShouldQueue;
+use Maatwebsite\Excel\Concerns\WithBatchInserts;
+use Illuminate\Support\Facades\Log;
 
-class BusinessIndustriesImport implements ToCollection
+class BusinessIndustriesImport implements ToCollection, WithMultipleSheets, WithChunkReading, WithBatchInserts, ShouldQueue, WithHeadingRow
 {
     /**
-    * @param array $row
+    * @param Collection $collection
-    *
+    */    
-    * @return \Illuminate\Database\Eloquent\Model|null
+    public function collection(Collection $collection)
-    */
-    public function collection(Collection $rows)
     {
-        foreach ($rows->skip(1) as $row){
+        try{
-            $clean_nop = preg_replace('/[^A-Za-z0-9]/', '', $row[2]);
+            $batchData = [];
-            if (!BusinessOrIndustry::where('nop', $clean_nop)->exists()) {
+            $batchSize = 1000;
-                BusinessOrIndustry::create([
+    
-                    'nama_kecamatan'     => $row[0],
+            foreach ($collection as $row){
-                    'nama_kelurahan'     => $row[1],
+                if(!isset($row['nop']) || empty($row['nop'])){
-                    'nop'                => $clean_nop, // Store cleaned 'nop'
+                    continue;
-                    'nama_wajib_pajak'   => $row[3],
+                }
-                    'alamat_wajib_pajak' => $row[4], 
+    
-                    'alamat_objek_pajak' => $row[5], 
+    
-                    'luas_bumi'          => $row[6], 
+                $clean_nop = preg_replace('/[^A-Za-z0-9]/', '', $row['nop']);
-                    'luas_bangunan'      => $row[7], 
+    
-                    'njop_bumi'          => $row[8], 
+                $batchData[] = [
-                    'njop_bangunan'      => $row[9], 
+                        'nama_kecamatan'     => $row['nama_kecamatan'],
-                    'ketetapan'          => $row[10], 
+                        'nama_kelurahan'     => $row['nama_kelurahan'],
-                    'tahun_pajak'        => $row[11], 
+                        'nop'                => $clean_nop,
+                        'nama_wajib_pajak'   => $row['nama_wajib_pajak'],
+                        'alamat_wajib_pajak' => $row['alamat_wajib_pajak'], 
+                        'alamat_objek_pajak' => $row['alamat_objek_pajak'], 
+                        'luas_bumi'          => $row['luas_bumi'], 
+                        'luas_bangunan'      => $row['luas_bangunan'], 
+                        'njop_bumi'          => $row['njop_bumi'], 
+                        'njop_bangunan'      => $row['njop_bangunan'], 
+                        'ketetapan'          => $row['ketetapan'], 
+                        'tahun_pajak'        => $row['tahun_pajak'], 
+                ];
+    
+                if(count($batchData) >= $batchSize){
+                    BusinessOrIndustry::upsert($batchData, ['nop'], [
+                        'nama_kecamatan',
+                        'nama_kelurahan',
+                        'nama_wajib_pajak',
+                        'alamat_wajib_pajak',
+                        'alamat_objek_pajak',
+                        'luas_bumi',
+                        'luas_bangunan',
+                        'njop_bumi',
+                        'njop_bangunan',
+                        'ketetapan',
+                        'tahun_pajak',
+                    ]);
+                    $batchData = [];
+                }
+            }
+            if(!empty($batchData)){
+                BusinessOrIndustry::upsert($batchData, ['nop'], [
+                    'nama_kecamatan',
+                    'nama_kelurahan',
+                    'nama_wajib_pajak',
+                    'alamat_wajib_pajak',
+                    'alamat_objek_pajak',
+                    'luas_bumi',
+                    'luas_bangunan',
+                    'njop_bumi',
+                    'njop_bangunan',
+                    'ketetapan',
+                    'tahun_pajak',
                 ]);
             }
+        }catch(\Exception $exception){
+            Log::error('Error while importing Business Industries data:', ['error' => $exception->getMessage()]);
+            return;
         }
     }
+
+    public function sheets(): array {
+        return [
+            0 => $this
+        ];
+    }
+
+    public function headingRow(): int
+    {
+        return 1;
+    }
+
+    public function chunkSize(): int
+    {
+        return 1000;
+    }
+
+    public function batchSize(): int
+    {
+        return 1000;
+    }
 }

app/Imports/CustomersImport.php

@@ -11,32 +11,61 @@ use Maatwebsite\Excel\Concerns\WithHeadingRow;
 use Maatwebsite\Excel\Concerns\WithMultipleSheets;
 use Illuminate\Contracts\Queue\ShouldQueue;
 use Maatwebsite\Excel\Concerns\WithBatchInserts;
+use Illuminate\Support\Facades\Log;
 
-class CustomersImport implements ToCollection, WithMultipleSheets
+class CustomersImport implements ToCollection, WithMultipleSheets, WithChunkReading, WithBatchInserts, ShouldQueue, WithHeadingRow
 {
     /**
     * @param Collection $collection
-    */
+    */    
     public function collection(Collection $collection)
     {
         $batchData = [];
+        $batchSize = 1000;
 
-        foreach ($collection->skip(1) as $row) {
+        foreach ($collection as $row) {
-            if (!isset($row[0]) || empty($row[0])) {
+            if (!isset($row['nomor_pelanggan']) || empty($row['nomor_pelanggan'])) {
                 continue;
             }
 
-            $latitude = filter_var($row[4], FILTER_VALIDATE_FLOAT) ? bcadd($row[4], '0', 18) : null;
+            $latitude = '0';
-            $longitude = filter_var($row[5], FILTER_VALIDATE_FLOAT) ? bcadd($row[5], '0', 18) : null;
+            $longitude = '0';
+
+            if (isset($row['latkor']) && !empty(trim($row['latkor']))) {
+                $latitude = str_replace(',', '.', trim($row['latkor']));
+                if (is_numeric($latitude)) {
+                    $latitude = bcadd($latitude, '0', 18); 
+                } else {
+                    $latitude = '0'; 
+                }
+            } else {
+                $latitude = '0';
+            }
+
+            if (isset($row['lonkor']) && !empty(trim($row['lonkor']))) {
+                $longitude = str_replace(',', '.', trim($row['lonkor'])); 
+                if (is_numeric($longitude)) {
+                    $longitude = bcadd($longitude, '0', 18); 
+                } else {
+                    $longitude = '0';
+                }
+            } else {
+                $longitude = '0';
+            }
 
             $batchData[] = [
-                'nomor_pelanggan' => $row[0],
+                'nomor_pelanggan' => $row['nomor_pelanggan'] ?? '',
-                'kota_pelayanan' => $row[1],
+                'kota_pelayanan' => $row['kota_pelayanan'] ?? '',
-                'nama' => $row[2],
+                'nama' => $row['nama'] ?? '',
-                'alamat' => $row[3],
+                'alamat' => $row['alamat'] ?? '',
                 'latitude' => $latitude,
                 'longitude' => $longitude,
             ];
+
+            if (count($batchData) >= $batchSize) {
+                Customer::upsert($batchData, ['nomor_pelanggan'], ['kota_pelayanan', 'nama', 'alamat', 'latitude', 'longitude']);
+                $batchData = [];
+            }
         }
 
         if (!empty($batchData)) {
@@ -44,9 +73,20 @@ class CustomersImport implements ToCollection, WithMultipleSheets
         }
     }
 
+
     public function sheets(): array {
         return [
             0 => $this
         ];
     }
+
+    public function chunkSize(): int
+    {
+        return 1000;
+    }
+
+    public function batchSize(): int
+    {
+        return 1000;
+    }
 }

app/Models/BigdataResume.php

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

app/Models/PbgTask.php

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

app/Services/OpenAIService.php

@@ -1,157 +0,0 @@
-<?php
-
-namespace App\Services;
-
-use OpenAI;
-use Illuminate\Support\Facades\Storage;
-
-class OpenAIService
-{
-    protected $client;
-
-    public function __construct()
-    {
-        $this->client = OpenAI::client(env('OPENAI_API_KEY'));
-    }
-
-    public function generateGeneralText($prompt, $mainContent)
-    {
-        $response = $this->client->chat()->create([
-            'model' => 'gpt-4o-mini',
-            'messages' => [
-                [
-                    'role' => 'system', 
-                    'content' => "You are an expert assistant. Your task is to generate a concise response based on the provided prompt and main content. 
-
-                    Guidelines:
-                    - Summarize the key points in exactly 5 bullet points.
-                    - Ensure the response is clear and relevant to the prompt.
-                    - Use simple and professional language."
-                ],
-                ['role' => 'user', 'content' => "Prompt: $prompt \nMain Content: $mainContent"],
-            ],
-        ]);
-
-        return trim($response['choices'][0]['message']['content'] ?? 'No response');
-    }
-
-    public function generateClassifyMainContent($prompt, $mainContent)
-    {
-        $response = $this->client->chat()->create([
-            'model' => 'gpt-4o-mini',
-            'messages' => [
-                [
-                    'role' => 'system', 
-                    'content' => "You are an expert assistant in classifying questions based on whether their answers must be retrieved from a database or can be explained generally.
-                    Your task is to return one of the following two labels:
-                    - \"DATABASE\" → If the question requires specific data that can only be obtained from a database.
-                    - \"GENERAL\" → If the question can be answered without accessing a database.
-                    
-                    Consider the following context: \"$mainContent\"
-                    
-                    Respond with only one of the labels: \"DATABASE\" or \"GENERAL\"."
-                ],
-                ['role' => 'user', 'content' => $prompt],
-            ],
-        ]);
-
-        return trim($response['choices'][0]['message']['content'] ?? 'No response');
-    }
-
-    public function generateQueryBasedMainContent($prompt, $mainContent)
-    {
-        // Load file JSON
-        $jsonPath = public_path('templates/contentTemplatePrompt.json'); // Sesuaikan path
-        $jsonData = json_decode(file_get_contents($jsonPath), true);
-
-        // Periksa apakah kategori ada dalam JSON
-        if (!isset($jsonData[$mainContent])) {
-            return "Template prompt tidak ditemukan.";
-        }
-
-        // Ambil template berdasarkan kategori
-        $promptTemplate = $jsonData[$mainContent]['prompt'];
-
-        $response = $this->client->chat()->create([
-            'model' => 'gpt-4o-mini',
-            'messages' => [
-                ['role' => 'system', 'content' => $promptTemplate],
-                ['role' => 'user', 'content' => $prompt],
-            ],
-        ]);
-
-        return trim($response['choices'][0]['message']['content'] ?? 'No response');
-    }
-
-
-    public function validateSyntaxQuery($queryResponse)
-    {
-        $response = $this->client->chat()->create([
-            'model' => 'gpt-4o-mini',
-            'messages' => [
-                [
-                    'role' => 'system', 
-                    'content' => "You are a MariaDB SQL expert. Your task is to validate the syntax of an SQL query to ensure it follows proper MariaDB syntax rules. 
-
-                    Guidelines:
-                    - Check for any syntax errors, missing keywords, or incorrect clause usage.
-                    - Ensure the query is well-structured and adheres to best practices.
-                    - Verify that all SQL keywords are used correctly and in the right order.
-                    - If the query is valid, respond with: \"VALID\".
-                    - If the query has issues, respond with: \"INVALID\".
-                    
-                    Always respond with either \"VALID\" or \"INVALID\"."
-                ],
-                ['role' => 'user', 'content' => $queryResponse],
-            ],
-        ]);
-
-        return trim($response['choices'][0]['message']['content'] ?? 'No response');
-    }
-
-    public function generateNLPFromQuery($inputUser, $resultQuery) {
-        $response = $this->client->chat()->create([
-            'model' => 'gpt-4o-mini',
-            'messages' => [
-                [
-                    'role' => 'system', 
-                    'content' => "You are an expert assistant. Your task is to analyze the database query results and transform them into a human-readable answer based on the user's question.
-    
-                    Guidelines:
-                    - Understand the user's question and extract the key intent.
-                    - Summarize or format the query results to directly answer the user's question.
-                    - Ensure the response is clear, concise, and relevant.
-                    - If the query result is empty or does not match the question, provide a polite response indicating that no data is available.
-    
-                    Always provide a well-structured response that makes sense based on the input question."
-                ],
-                ['role' => 'user', 'content' => "User's question: $inputUser \nDatabase result: $resultQuery"],
-            ],
-        ]);
-    
-        return trim($response['choices'][0]['message']['content'] ?? 'No response');
-    }
-
-    public function generateFinalText($nlpResult) {
-        $response = $this->client->chat()->create([
-            'model' => 'gpt-4o-mini',
-            'messages' => [
-                [
-                    'role' => 'system',
-                    'content' => "You are an expert text formatter. Your task is to take the given NLP result and format it into a structured, human-readable text suitable for rendering inside an HTML <div>.
-    
-                    Guidelines:
-                    - Preserve the meaning and clarity of the content.
-                    - Use proper line breaks for readability.
-                    - If the text contains lists, convert them into bullet points.
-                    - Emphasize important keywords using <strong> tags if necessary.
-                    - Ensure the response remains clean and concise without extra explanations."
-                ],
-                ['role' => 'user', 'content' => "Here is the NLP result that needs formatting:\n\n$nlpResult"],
-            ],
-        ]);
-    
-        return trim($response['choices'][0]['message']['content'] ?? 'No response');
-    }    
-
-}

app/Services/ServiceSIMBG.php

@@ -81,13 +81,13 @@ class ServiceSIMBG
                 if (empty($res->original['success']) || !$res->original['success']) {
                     // Log error
                     Log::error("API response indicates failure", ['url' => $url, 'uuid' => $uuid]);
-                    return false;
+                    continue;
                 }
             
                 $data = $res->original['data']['data'] ?? null;
                 if (!$data) {
                     Log::error("No valid data returned from API", ['url' => $url, 'uuid' => $uuid]);
-                    return false;
+                    continue;
                 }
 
                 $integrations[] = [
@@ -104,19 +104,6 @@ class ServiceSIMBG
 
             PbgTaskIndexIntegrations::upsert($integrations, ['pbg_task_uid'], ['indeks_fungsi_bangunan', 
             'indeks_parameter_kompleksitas', 'indeks_parameter_permanensi', 'indeks_parameter_ketinggian', 'faktor_kepemilikan', 'indeks_terintegrasi', 'total']);
-        
-            // $resultData = PbgTaskIndexIntegrations::updateOrCreate(
-            //     ['pbg_task_uid' => $uuid],
-            //     [
-            //         'indeks_fungsi_bangunan' => $data['indeks_fungsi_bangunan'] ?? null,
-            //         'indeks_parameter_kompleksitas' => $data['indeks_parameter_kompleksitas'] ?? null,
-            //         'indeks_parameter_permanensi' => $data['indeks_parameter_permanensi'] ?? null,
-            //         'indeks_parameter_ketinggian' => $data['indeks_parameter_ketinggian'] ?? null,
-            //         'faktor_kepemilikan' => $data['faktor_kepemilikan'] ?? null,
-            //         'indeks_terintegrasi' => $data['indeks_terintegrasi'] ?? null,
-            //         'total' => $data['total'] ?? null,
-            //     ]
-            // );
             
             return true;
         }catch (Exception $e){
@@ -127,133 +114,136 @@ class ServiceSIMBG
 
     public function syncTaskList()
     {
-        $initResToken = $this->getToken();
+        try {
-
+            $importDatasource = ImportDatasource::create([
-        $importDatasource = ImportDatasource::create([
+                'status' => ImportDatasourceStatus::Processing->value,
-            'status' => ImportDatasourceStatus::Processing->value,
-        ]);
-
-        if (empty($initResToken->original['data']['token']['access'])) {
-            $importDatasource->update([
-                'status' => ImportDatasourceStatus::Failed->value,
-                'message' => 'Failed to retrieve token'
             ]);
-            return $this->resError("Failed to retrieve token");
-        }
 
-        $apiToken = $initResToken->original['data']['token']['access'];
+            if (empty($initResToken->original['data']['token']['access'])) {
-        $headers = ['Authorization' => "Bearer " . $apiToken];
-
-        $url = "/api/pbg/v1/list/?page=1&size={$this->fetch_per_page}&sort=ASC";
-        $initialResponse = $this->service_client->get($url, $headers);
-
-        $totalPage = $initialResponse->original['data']['total_page'] ?? 0;
-        if ($totalPage == 0) {
-            $importDatasource->update([
-                'status' => ImportDatasourceStatus::Failed->value,
-                'message' => 'Invalid response: no total_page'
-            ]);
-            return $this->resError("Invalid response from API");
-        }
-
-        $savedCount = $failedCount = 0;
-
-        for ($currentPage = 1; $currentPage <= $totalPage; $currentPage++) {
-            $pageUrl = "/api/pbg/v1/list/?page={$currentPage}&size={$this->fetch_per_page}&sort=ASC";
-            $getToken = $this->getToken();
-            Log::info("response index integration", ['currentPage' => $currentPage]);
-            if (empty($getToken->original['data']['token']['access'])) {
                 $importDatasource->update([
                     'status' => ImportDatasourceStatus::Failed->value,
                     'message' => 'Failed to retrieve token'
                 ]);
-                break;
+                return $this->resError("Failed to retrieve token");
             }
-            $token = $getToken->original['data']['token']['access'];
-            $headers = ['Authorization' => "Bearer " . $token];
-            $response = $this->service_client->get($pageUrl, $headers);
-            $tasks = $response->original['data']['data'] ?? [];
 
-            if (empty($tasks)) {
+            $initResToken = $this->getToken();
+            $apiToken = $initResToken->original['data']['token']['access'];
+            $headers = ['Authorization' => "Bearer " . $apiToken];
+
+            $url = "/api/pbg/v1/list/?page=1&size={$this->fetch_per_page}&sort=ASC";
+            $initialResponse = $this->service_client->get($url, $headers);
+
+            $totalPage = $initialResponse->original['data']['total_page'] ?? 0;
+            if ($totalPage == 0) {
                 $importDatasource->update([
                     'status' => ImportDatasourceStatus::Failed->value,
-                    'message' => 'No data found on page'
+                    'message' => 'Invalid response: no total_page'
                 ]);
-                Log::warning("No data found on page", ['page' => $currentPage]);
+                return $this->resError("Invalid response from API");
-                break;
             }
 
-            Log::info("executed page", ['page' => $currentPage, 'total' => $totalPage]);
+            $savedCount = $failedCount = 0;
 
-            $tasksCollective = [];
+            for ($currentPage = 1; $currentPage <= $totalPage; $currentPage++) {
-            foreach ($tasks as $item) {
                 try {
-                    $tasksCollective[] = [
+                    $pageUrl = "/api/pbg/v1/list/?page={$currentPage}&size={$this->fetch_per_page}&sort=ASC";
-                        'uuid' => $item['uid'],
-                        'name' => $item['name'],
-                        'owner_name' => $item['owner_name'],
-                        'application_type' => $item['application_type'],
-                        'application_type_name' => $item['application_type_name'],
-                        'condition' => $item['condition'],
-                        'registration_number' => $item['registration_number'],
-                        'document_number' => $item['document_number'],
-                        'address' => $item['address'],
-                        'status' => $item['status'],
-                        'status_name' => $item['status_name'],
-                        'slf_status' => $item['slf_status'] ?? null,
-                        'slf_status_name' => $item['slf_status_name'] ?? null,
-                        'function_type' => $item['function_type'],
-                        'consultation_type' => $item['consultation_type'],
-                        'due_date' => $item['due_date'],
-                        'land_certificate_phase' => $item['land_certificate_phase'],
-                        'task_created_at' => isset($item['created_at']) ? Carbon::parse($item['created_at'])->format('Y-m-d H:i:s') : null,
-                        'updated_at' => now(),
-                        'created_at' => now(),
-                    ];
 
-                    // $this->syncIndexIntegration($item['uid'], $token);
+                    Log::info("Fetching tasks", ['currentPage' => $currentPage]);
 
-                    $this->syncTaskDetailSubmit($item['uid'], $token);
+                    $response = $this->service_client->get($pageUrl, $headers);
-                    
+                    $tasks = $response->original['data']['data'] ?? [];
-                    $savedCount++;
+
+                    if (empty($tasks)) {
+                        Log::warning("No data found on page", ['page' => $currentPage]);
+                        continue;
+                    }
+
+                    $tasksCollective = [];
+                    foreach ($tasks as $item) {
+                        try {
+                            $tasksCollective[] = [
+                                'uuid' => $item['uid'],
+                                'name' => $item['name'],
+                                'owner_name' => $item['owner_name'],
+                                'application_type' => $item['application_type'],
+                                'application_type_name' => $item['application_type_name'],
+                                'condition' => $item['condition'],
+                                'registration_number' => $item['registration_number'],
+                                'document_number' => $item['document_number'],
+                                'address' => $item['address'],
+                                'status' => $item['status'],
+                                'status_name' => $item['status_name'],
+                                'slf_status' => $item['slf_status'] ?? null,
+                                'slf_status_name' => $item['slf_status_name'] ?? null,
+                                'function_type' => $item['function_type'],
+                                'consultation_type' => $item['consultation_type'],
+                                'due_date' => $item['due_date'],
+                                'land_certificate_phase' => $item['land_certificate_phase'],
+                                'task_created_at' => isset($item['created_at']) ? Carbon::parse($item['created_at'])->format('Y-m-d H:i:s') : null,
+                                'updated_at' => now(),
+                                'created_at' => now(),
+                            ];
+
+                            $this->syncTaskDetailSubmit($item['uid'], $apiToken);
+                            $savedCount++;
+                        } catch (Exception $e) {
+                            $failedCount++;
+                            Log::error("Failed to process task", [
+                                'error' => $e->getMessage(),
+                                'task' => $item,
+                            ]);
+                            continue; // Skip failed task, continue processing the rest
+                        }
+                    }
+
+                    if (!empty($tasksCollective)) {
+                        PbgTask::upsert($tasksCollective, ['uuid'], [
+                            'name', 'owner_name', 'application_type', 'application_type_name', 'condition',
+                            'registration_number', 'document_number', 'address', 'status', 'status_name',
+                            'slf_status', 'slf_status_name', 'function_type', 'consultation_type', 'due_date',
+                            'land_certificate_phase', 'task_created_at', 'updated_at'
+                        ]);
+
+                        $uuids = array_column($tasksCollective, 'uuid');
+                        $this->syncIndexIntegration($uuids, $apiToken);
+                    }
                 } catch (Exception $e) {
-                    $failedCount++;
+                    Log::error("Failed to process page", [
-                    $importDatasource->update([
-                        'status' => ImportDatasourceStatus::Failed->value,
-                        'message' => "Successfully processed: $savedCount, Failed: $failedCount"
-                    ]);
-                    Log::error("Failed to process task", [
                         'error' => $e->getMessage(),
-                        'task' => $item,
+                        'page' => $currentPage,
                     ]);
-                    break;
+                    continue; // Skip the failed page and move to the next
                 }
             }
 
-            PbgTask::upsert($tasksCollective, ['uuid'], [
+            BigdataResume::generateResumeData($importDatasource->id, "all");
-                'name', 'owner_name', 'application_type', 'application_type_name', 'condition',
+            BigdataResume::generateResumeData($importDatasource->id, now()->year);
-                'registration_number', 'document_number', 'address', 'status', 'status_name',
+
-                'slf_status', 'slf_status_name', 'function_type', 'consultation_type', 'due_date',
+            // Final update after processing all pages
-                'land_certificate_phase', 'task_created_at', 'updated_at'
+            $importDatasource->update([
+                'status' => ImportDatasourceStatus::Success->value,
+                'message' => "Successfully processed: $savedCount, Failed: $failedCount"
             ]);
             
-            $uuids = array_column($tasksCollective, 'uuid');
+            Log::info("syncTaskList completed", ['savedCount' => $savedCount, 'failedCount' => $failedCount]);
-            $this->syncIndexIntegration($uuids, $token);
+
+            return $this->resSuccess(['savedCount' => $savedCount, 'failedCount' => $failedCount]);
+
+        } catch (Exception $e) {
+            Log::error("syncTaskList failed", ['error' => $e->getMessage()]);
+            if (isset($importDatasource)) {
+                $importDatasource->update([
+                    'status' => ImportDatasourceStatus::Failed->value,
+                    'message' => 'Critical failure: ' . $e->getMessage()
+                ]);
+            }
+            return $this->resError("Critical failure occurred: " . $e->getMessage());
         }
-        
-        $importDatasource->update([
-            'status' => ImportDatasourceStatus::Success->value,
-            'message' => "Successfully processed: $savedCount, Failed: $failedCount"
-        ]);
-
-        BigdataResume::generateResumeData($importDatasource->id);
-
-        Log::info("syncTaskList completed", ['savedCount' => $savedCount, 'failedCount' => $failedCount]);
-
-        return $this->resSuccess(['savedCount' => $savedCount, 'failedCount' => $failedCount]);
     }
 
 
+
     public function syncTaskDetailSubmit($uuid, $token)
     {
         try{

composer.json

@@ -15,8 +15,7 @@
         "laravel/framework": "^11.31",
         "laravel/sanctum": "^4.0",
         "laravel/tinker": "^2.9",
-        "maatwebsite/excel": "^3.1",
+        "maatwebsite/excel": "^3.1"
-        "openai-php/client": "^0.10.3"
     },
     "require-dev": {
         "fakerphp/faker": "^1.23",

composer.lock

@@ -4,7 +4,7 @@
         "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": "52617d098d62b15c6ce8538cc8aea775",
     "packages": [
         {
             "name": "brick/math",
@@ -3296,97 +3296,6 @@
             ],
             "time": "2024-11-21T10:39:51+00:00"
         },
-        {
-            "name": "openai-php/client",
-            "version": "v0.10.3",
-            "source": {
-                "type": "git",
-                "url": "https://github.com/openai-php/client.git",
-                "reference": "4a565d145e0fb3ea1baba8fffe39d86c56b6dc2c"
-            },
-            "dist": {
-                "type": "zip",
-                "url": "https://api.github.com/repos/openai-php/client/zipball/4a565d145e0fb3ea1baba8fffe39d86c56b6dc2c",
-                "reference": "4a565d145e0fb3ea1baba8fffe39d86c56b6dc2c",
-                "shasum": ""
-            },
-            "require": {
-                "php": "^8.1.0",
-                "php-http/discovery": "^1.20.0",
-                "php-http/multipart-stream-builder": "^1.4.2",
-                "psr/http-client": "^1.0.3",
-                "psr/http-client-implementation": "^1.0.1",
-                "psr/http-factory-implementation": "*",
-                "psr/http-message": "^1.1.0|^2.0.0"
-            },
-            "require-dev": {
-                "guzzlehttp/guzzle": "^7.9.2",
-                "guzzlehttp/psr7": "^2.7.0",
-                "laravel/pint": "^1.18.1",
-                "mockery/mockery": "^1.6.12",
-                "nunomaduro/collision": "^7.11.0|^8.5.0",
-                "pestphp/pest": "^2.36.0|^3.5.0",
-                "pestphp/pest-plugin-arch": "^2.7|^3.0",
-                "pestphp/pest-plugin-type-coverage": "^2.8.7|^3.1.0",
-                "phpstan/phpstan": "^1.12.7",
-                "symfony/var-dumper": "^6.4.11|^7.1.5"
-            },
-            "type": "library",
-            "autoload": {
-                "files": [
-                    "src/OpenAI.php"
-                ],
-                "psr-4": {
-                    "OpenAI\\": "src/"
-                }
-            },
-            "notification-url": "https://packagist.org/downloads/",
-            "license": [
-                "MIT"
-            ],
-            "authors": [
-                {
-                    "name": "Nuno Maduro",
-                    "email": "enunomaduro@gmail.com"
-                },
-                {
-                    "name": "Sandro Gehri"
-                }
-            ],
-            "description": "OpenAI PHP is a supercharged PHP API client that allows you to interact with the Open AI API",
-            "keywords": [
-                "GPT-3",
-                "api",
-                "client",
-                "codex",
-                "dall-e",
-                "language",
-                "natural",
-                "openai",
-                "php",
-                "processing",
-                "sdk"
-            ],
-            "support": {
-                "issues": "https://github.com/openai-php/client/issues",
-                "source": "https://github.com/openai-php/client/tree/v0.10.3"
-            },
-            "funding": [
-                {
-                    "url": "https://www.paypal.com/paypalme/enunomaduro",
-                    "type": "custom"
-                },
-                {
-                    "url": "https://github.com/gehrisandro",
-                    "type": "github"
-                },
-                {
-                    "url": "https://github.com/nunomaduro",
-                    "type": "github"
-                }
-            ],
-            "time": "2024-11-12T20:51:16+00:00"
-        },
         {
             "name": "paragonie/constant_time_encoding",
             "version": "v3.0.0",
@@ -3504,141 +3413,6 @@
             },
             "time": "2020-10-15T08:29:30+00:00"
         },
-        {
-            "name": "php-http/discovery",
-            "version": "1.20.0",
-            "source": {
-                "type": "git",
-                "url": "https://github.com/php-http/discovery.git",
-                "reference": "82fe4c73ef3363caed49ff8dd1539ba06044910d"
-            },
-            "dist": {
-                "type": "zip",
-                "url": "https://api.github.com/repos/php-http/discovery/zipball/82fe4c73ef3363caed49ff8dd1539ba06044910d",
-                "reference": "82fe4c73ef3363caed49ff8dd1539ba06044910d",
-                "shasum": ""
-            },
-            "require": {
-                "composer-plugin-api": "^1.0|^2.0",
-                "php": "^7.1 || ^8.0"
-            },
-            "conflict": {
-                "nyholm/psr7": "<1.0",
-                "zendframework/zend-diactoros": "*"
-            },
-            "provide": {
-                "php-http/async-client-implementation": "*",
-                "php-http/client-implementation": "*",
-                "psr/http-client-implementation": "*",
-                "psr/http-factory-implementation": "*",
-                "psr/http-message-implementation": "*"
-            },
-            "require-dev": {
-                "composer/composer": "^1.0.2|^2.0",
-                "graham-campbell/phpspec-skip-example-extension": "^5.0",
-                "php-http/httplug": "^1.0 || ^2.0",
-                "php-http/message-factory": "^1.0",
-                "phpspec/phpspec": "^5.1 || ^6.1 || ^7.3",
-                "sebastian/comparator": "^3.0.5 || ^4.0.8",
-                "symfony/phpunit-bridge": "^6.4.4 || ^7.0.1"
-            },
-            "type": "composer-plugin",
-            "extra": {
-                "class": "Http\\Discovery\\Composer\\Plugin",
-                "plugin-optional": true
-            },
-            "autoload": {
-                "psr-4": {
-                    "Http\\Discovery\\": "src/"
-                },
-                "exclude-from-classmap": [
-                    "src/Composer/Plugin.php"
-                ]
-            },
-            "notification-url": "https://packagist.org/downloads/",
-            "license": [
-                "MIT"
-            ],
-            "authors": [
-                {
-                    "name": "Márk Sági-Kazár",
-                    "email": "mark.sagikazar@gmail.com"
-                }
-            ],
-            "description": "Finds and installs PSR-7, PSR-17, PSR-18 and HTTPlug implementations",
-            "homepage": "http://php-http.org",
-            "keywords": [
-                "adapter",
-                "client",
-                "discovery",
-                "factory",
-                "http",
-                "message",
-                "psr17",
-                "psr7"
-            ],
-            "support": {
-                "issues": "https://github.com/php-http/discovery/issues",
-                "source": "https://github.com/php-http/discovery/tree/1.20.0"
-            },
-            "time": "2024-10-02T11:20:13+00:00"
-        },
-        {
-            "name": "php-http/multipart-stream-builder",
-            "version": "1.4.2",
-            "source": {
-                "type": "git",
-                "url": "https://github.com/php-http/multipart-stream-builder.git",
-                "reference": "10086e6de6f53489cca5ecc45b6f468604d3460e"
-            },
-            "dist": {
-                "type": "zip",
-                "url": "https://api.github.com/repos/php-http/multipart-stream-builder/zipball/10086e6de6f53489cca5ecc45b6f468604d3460e",
-                "reference": "10086e6de6f53489cca5ecc45b6f468604d3460e",
-                "shasum": ""
-            },
-            "require": {
-                "php": "^7.1 || ^8.0",
-                "php-http/discovery": "^1.15",
-                "psr/http-factory-implementation": "^1.0"
-            },
-            "require-dev": {
-                "nyholm/psr7": "^1.0",
-                "php-http/message": "^1.5",
-                "php-http/message-factory": "^1.0.2",
-                "phpunit/phpunit": "^7.5.15 || ^8.5 || ^9.3"
-            },
-            "type": "library",
-            "autoload": {
-                "psr-4": {
-                    "Http\\Message\\MultipartStream\\": "src/"
-                }
-            },
-            "notification-url": "https://packagist.org/downloads/",
-            "license": [
-                "MIT"
-            ],
-            "authors": [
-                {
-                    "name": "Tobias Nyholm",
-                    "email": "tobias.nyholm@gmail.com"
-                }
-            ],
-            "description": "A builder class that help you create a multipart stream",
-            "homepage": "http://php-http.org",
-            "keywords": [
-                "factory",
-                "http",
-                "message",
-                "multipart stream",
-                "stream"
-            ],
-            "support": {
-                "issues": "https://github.com/php-http/multipart-stream-builder/issues",
-                "source": "https://github.com/php-http/multipart-stream-builder/tree/1.4.2"
-            },
-            "time": "2024-09-04T13:22:54+00:00"
-        },
         {
             "name": "phpoffice/phpspreadsheet",
             "version": "1.29.10",
@@ -7381,6 +7155,74 @@
             },
             "time": "2020-07-09T08:09:16+00:00"
         },
+        {
+            "name": "ibex/crud-generator",
+            "version": "v2.1.2",
+            "source": {
+                "type": "git",
+                "url": "https://github.com/awais-vteams/laravel-crud-generator.git",
+                "reference": "3906f4a702c91bbe3a84d940c3021d1511834320"
+            },
+            "dist": {
+                "type": "zip",
+                "url": "https://api.github.com/repos/awais-vteams/laravel-crud-generator/zipball/3906f4a702c91bbe3a84d940c3021d1511834320",
+                "reference": "3906f4a702c91bbe3a84d940c3021d1511834320",
+                "shasum": ""
+            },
+            "require": {
+                "laravel/framework": "^10.30|^11.0",
+                "php": "^8.2"
+            },
+            "type": "library",
+            "extra": {
+                "laravel": {
+                    "providers": [
+                        "Ibex\\CrudGenerator\\CrudServiceProvider"
+                    ]
+                }
+            },
+            "autoload": {
+                "psr-4": {
+                    "Ibex\\CrudGenerator\\": "src/"
+                }
+            },
+            "notification-url": "https://packagist.org/downloads/",
+            "license": [
+                "MIT"
+            ],
+            "authors": [
+                {
+                    "name": "M Awais",
+                    "email": "asargodha@gmail.com"
+                }
+            ],
+            "description": "Laravel CRUD Generator",
+            "keywords": [
+                "alpine js",
+                "bootstrap css",
+                "crud",
+                "crud generator",
+                "laravel",
+                "laravel crud generator",
+                "laravel package",
+                "tailwind css"
+            ],
+            "support": {
+                "issues": "https://github.com/awais-vteams/laravel-crud-generator/issues",
+                "source": "https://github.com/awais-vteams/laravel-crud-generator/tree/v2.1.2"
+            },
+            "funding": [
+                {
+                    "url": "https://github.com/awais-vteams",
+                    "type": "github"
+                },
+                {
+                    "url": "https://ko-fi.com/mawais",
+                    "type": "ko_fi"
+                }
+            ],
+            "time": "2024-12-09T06:01:54+00:00"
+        },
         {
             "name": "laravel/pail",
             "version": "v1.2.2",
@@ -9474,12 +9316,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

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

database/migrations/2025_02_26_140440_add_spatial_in_bigdata_resumes.php

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

database/migrations/2025_02_27_163347_add_formatted_registration_number_to_pbg_task_google_sheet.php

@@ -1,28 +0,0 @@
-<?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('pbg_task_google_sheet', function (Blueprint $table) {
-            $table->string('formatted_registration_number')->nullable()->after('no_registrasi');
-        });
-    }
-
-    /**
-     * Reverse the migrations.
-     */
-    public function down(): void
-    {
-        Schema::table('pbg_task_google_sheet', function (Blueprint $table) {
-            $table->dropColumn('formatted_registration_number');
-        });
-    }
-};

database/seeders/UsersRoleMenuSeeder.php

@@ -71,7 +71,7 @@ class UsersRoleMenuSeeder extends Seeder
             [
                 "name" => "Laporan",
                 "url" => "/laporan",
-                "icon" => "mingcute:task-line",
+                "icon" => "mingcute:report-line",
                 "parent_id" => null,
                 "sort_order" => 6,
             ]
@@ -214,6 +214,13 @@ class UsersRoleMenuSeeder extends Seeder
                 "parent_id" => $laporan->id,
                 "sort_order" => 1,
             ],
+            [
+                "name" => "Lap Pimpinan",
+                "url" => "bigdata-resumes",
+                "icon" => null,
+                "parent_id" => $laporan->id,
+                "sort_order" => 2,
+            ],
         ];
 
         foreach ($children_menus as $child_menu) {
@@ -237,6 +244,7 @@ class UsersRoleMenuSeeder extends Seeder
         $spatial_plannings = Menu::where('name', 'Tata Ruang')->first();
         $pdam = Menu::where('name', 'PDAM')->first();
         $peta = Menu::where('name', 'PETA')->first();
+        $bigdata_resume = Menu::where('name', 'Lap Pimpinan')->first();
 
         // Superadmin gets all menus
         $superadmin->menus()->sync([
@@ -265,6 +273,7 @@ class UsersRoleMenuSeeder extends Seeder
             $spatial_plannings->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
             $pdam->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
             $peta->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
+            $bigdata_resume->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
         ]);
 
         // Admin gets limited menus
@@ -279,6 +288,7 @@ class UsersRoleMenuSeeder extends Seeder
             $dashboard->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
             $data->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
         ]);
+        
         // Attach User to role super admin
         User::findOrFail(1)->roles()->sync([$superadmin->id]);
     }

package.json

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

public/templates/contentTemplatePrompt.json

@@ -1,11 +0,0 @@
-{
-    "RETRIBUTION": {
-        "prompt": "You are a MariaDB SQL expert. Your task is to generate an efficient and optimized SQL query based on user input.\n\n        The query should retrieve data from the view table `v_pbg_task_with_retributions`, specifically selecting the following columns:\n\n        - nilai_retribusi_bangunan\n        - land_certificate_phase\n        - due_date\n        - consultation_type\n        - function_type\n        - slf_status_name\n        - slf_status\n        - status_name\n        - status\n        - address\n        - document_number\n        - registration_number\n        - application_type_name\n        - application_type\n        - owner_name\n        - name\n\n        Ensure the query is well-structured, uses best indexing practices, and avoids performance bottlenecks.\n\n        Consider the following context: \"$mainContent\".\n\n        Always return only the SQL query without any additional explanation."
-    },
-    "DOCUMENT VALIDATION": {
-        "prompt": "You are a MariaDB SQL expert. Your task is to generate an efficient and optimized SQL query based on user input.\n\n        The query should retrieve data from the view table `pbg_task`, specifically selecting the following columns:\n\n        - name\n        - owner_name\n        - application_type\n        - application_type_name\n        - registration_number\n        - document_number\n        - address\n        - status_name\n        - slf_status\n        - slf_status_name\n        - function_type\n        - consultation_type\n        - function_type\n        - consultation_type\n        - due_date\n        - land_certificate_phase\n\n        Ensure the query is well-structured, uses best indexing practices, and avoids performance bottlenecks.\n\n        Consider the following context: \"$mainContent\".\n\n        Always return only the SQL query without any additional explanation."
-    },
-    "DATA SUMMARY": {
-        "prompt": "You are a MariaDB SQL expert. Your task is to generate an efficient and optimized SQL query based on user input.\n\n        The query should retrieve data from the view table `bigdata_resumes`, specifically selecting the following columns:\n\n        - potention_count\n        - potention_sum\n        - non_verified_count\n        - non_verified_sum\n        - verified_sum\n        - verified_count\n        - business_count\n        - business_sum\n        - non_business_count\n        - non_business_sum\n        - spatial_count\n        - spatial_sum\n        - updated_at\n\n        Ensure the query is well-structured, uses best indexing practices, and avoids performance bottlenecks.\n\n        Consider the following context: \"$mainContent\".\n\n        Always return only the SQL query without any additional explanation."
-    }
-}

resources/js/bigdata-resumes/index.js

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

resources/js/business-industries/create.js

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

resources/js/chatbot/index.js

@@ -1,176 +0,0 @@
-import GlobalConfig from "../global-config.js";
-
-document.addEventListener("DOMContentLoaded", function () {
-    document.querySelectorAll(".nav-link").forEach(tab => {
-        tab.addEventListener("click", function () {
-            setTimeout(() => {
-                const tab_active = getActiveTabId();
-                console.log("Active Tab ID:", tab_active);
-            }, 100); // Timeout untuk memastikan class `active` sudah diperbarui
-        });
-    });
-
-    const textarea = document.getElementById("user-message");
-    const sendButton = document.getElementById("send");
-    const conversationArea = document.querySelector(".row.flex-grow");
-
-    // Fungsi untuk mengirim pesan
-    async function sendMessage() {
-        const userText = textarea.value.trim();
-        if (userText !== "") {
-            // Kosongkan textarea setelah mengirim
-            textarea.value = "";
-
-            // Ambil tab aktif saat ini
-            const currentTab = getActiveTabId();
-
-            // Tambahkan pesan user ke UI
-            addMessage(userText, "user");
-
-            // Tambahkan pesan bot sementara dengan "Loading..."
-            const botMessageElement = addMessage('<div class="loader w-auto"></div>', "bot");
-
-            // Panggil API untuk mendapatkan response dari bot
-            const botResponse = await getBotResponse(currentTab, userText);
-
-            // Perbarui pesan bot dengan respons yang sebenarnya
-            botMessageElement.innerHTML = botResponse;;
-        }
-    }
-
-    // Event listener untuk klik tombol
-    sendButton.addEventListener("click", sendMessage);
-
-    // Event listener untuk menekan Enter di textarea
-    textarea.addEventListener("keydown", function (event) {
-        if (event.key === "Enter" && !event.shiftKey) {
-            event.preventDefault(); // Mencegah newline di textarea
-            sendMessage(); // Panggil fungsi kirim pesan
-        }
-    });
-
-    function addMessage(text, sender) {
-        const messageRow = document.createElement("div");
-        messageRow.classList.add("row", "flex-grow", "overflow-auto");
-    
-        const messageCol = document.createElement("div");
-        messageCol.classList.add("w-auto", "d-inline-block"); // Menyesuaikan lebar konten
-    
-        if (sender === "user") {
-            messageCol.classList.add("ms-auto", "max-w-50"); // Rata kanan, max 50% (setara col-6)
-        } else {
-            messageCol.classList.add("max-w-75"); // Max 75% (setara col-9)
-    
-            // Tambahkan avatar hanya untuk bot
-            const avatarSpan = document.createElement("span");
-            avatarSpan.classList.add("d-flex", "align-items-center", "mb-1");
-    
-            const avatarImg = document.createElement("img");
-            avatarImg.classList.add("rounded-circle");
-            avatarImg.width = 32;
-            avatarImg.src = "/images/iconchatbot.jpeg";
-            avatarImg.alt = "bot-avatar";
-    
-            avatarSpan.appendChild(avatarImg);
-            messageCol.appendChild(avatarSpan);
-        }
-    
-        const messageDiv = document.createElement("div");
-        messageDiv.classList.add("p-2", "rounded", "mb-2");
-    
-        if (sender === "user") {
-            messageDiv.classList.add("user-response", "bg-primary", "text-white");
-        } else {
-            messageDiv.classList.add("bot-response", "bg-light");
-        }
-    
-        // Menyisipkan konten HTML langsung (bisa berupa teks atau loader)
-        messageDiv.innerHTML = text;
-        messageCol.appendChild(messageDiv);
-        messageRow.appendChild(messageCol);
-    
-        // Tambahkan ke area percakapan
-        conversationArea.appendChild(messageRow);
-    
-        // Scroll otomatis ke bawah
-        conversationArea.scrollTop = conversationArea.scrollHeight;
-    
-        return messageDiv; // Mengembalikan elemen agar bisa diperbarui nanti
-    }
-    
-
-    // function addMessage(text, sender) {
-    //     const messageRow = document.createElement("div");
-    //     messageRow.classList.add("row", "flex-grow", "overflow-auto");
-    
-    //     const messageCol = document.createElement("div");
-    //     messageCol.classList.add("col-9", "w-auto");
-    
-    //     if (sender === "user") {
-    //         messageCol.classList.add("ms-auto"); // Geser ke kanan untuk user
-    //     }
-    
-    //     const messageDiv = document.createElement("div");
-    //     messageDiv.classList.add("p-2", "rounded", "mb-2");
-    
-    //     if (sender === "user") {
-    //         messageDiv.classList.add("user-response", "bg-primary", "text-white");
-    //     } else {
-    //         messageDiv.classList.add("bot-response", "bg-light");
-    
-    //         // Tambahkan avatar hanya untuk bot
-    //         const avatarSpan = document.createElement("span");
-    //         avatarSpan.classList.add("d-flex", "align-items-center", "mb-1");
-    
-    //         const avatarImg = document.createElement("img");
-    //         avatarImg.classList.add("rounded-circle");
-    //         avatarImg.width = 32;
-    //         avatarImg.src = "/images/iconchatbot.jpeg";
-    //         avatarImg.alt = "bot-avatar";
-    
-    //         avatarSpan.appendChild(avatarImg);
-    //         messageCol.appendChild(avatarSpan);
-    //     }
-    
-    //     // Menyisipkan konten HTML langsung (bisa berupa teks atau loader)
-    //     messageDiv.innerHTML = text;
-    //     messageCol.appendChild(messageDiv);
-    //     messageRow.appendChild(messageCol);
-    
-    //     // Tambahkan ke area percakapan
-    //     conversationArea.appendChild(messageRow);
-    
-    //     // Scroll otomatis ke bawah
-    //     conversationArea.scrollTop = conversationArea.scrollHeight;
-    
-    //     return messageDiv; // Mengembalikan elemen agar bisa diperbarui nanti
-    // }
-
-    // Fungsi untuk memanggil API
-    async function getBotResponse(tab_active, userText) {
-        try {
-            const url = `${GlobalConfig.apiHost}/api/generate-text`;
-            const response = await fetch(url, {
-                method: "POST",
-                body: JSON.stringify({tab_active:tab_active, prompt: userText }),
-                headers: {
-                    Authorization: `Bearer ${document
-                        .querySelector('meta[name="api-token"]')
-                        .getAttribute("content")}`,
-                    "Content-Type": "application/json",
-                },
-            });
-
-            const data = await response.json();
-            return data.response || "Maaf, saya tidak mengerti.";
-        } catch (error) {
-            console.error("Error fetching bot response:", error);
-            return "Terjadi kesalahan, coba lagi nanti.";
-        }
-    }
-});
-
-function getActiveTabId() {
-    const activeTab = document.querySelector(".nav-link.active");
-    return activeTab ? activeTab.id : null;
-}

resources/js/dashboards/bigdata.js

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

resources/js/maps/maps-kml.js

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

resources/scss/components/_circle.scss

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

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

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

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

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

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

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

resources/views/chatbot/index.blade.php

@@ -1,92 +0,0 @@
-@extends('layouts.vertical', ['subtitle' => 'Chatbot'])
-
-@section('css')
-@vite(['node_modules/gridjs/dist/theme/mermaid.min.css'])
-<style>
-#user-message {
-    height: 60px; /* Menambah tinggi textarea */
-    font-size: 1.1rem; /* Memperbesar font */
-    padding: 10px; /* Menambah ruang di dalam textarea */
-    resize: none; /* Mencegah resize manual */
-}
-
-.loader {
-  width: 10px;
-  aspect-ratio: 1;
-  border-radius: 50%;
-  animation: l5 1s infinite linear alternate;
-}
-
-@keyframes l5 {
-    0%  {box-shadow: 10px 0 #000, -10px 0 #0002; background: #000 }
-    33% {box-shadow: 10px 0 #000, -10px 0 #0002; background: #0002}
-    66% {box-shadow: 10px 0 #0002, -10px 0 #000; background: #0002}
-    100%{box-shadow: 10px 0 #0002, -10px 0 #000; background: #000 }
-}
-</style>
-@endsection
-
-@section('content')
-@include('layouts.partials/page-title', ['title' => 'Chatbot', 'subtitle' => 'Chatbot'])
-
-<div class="card">
-    <div class="card-header">
-        <ul class="nav nav-tabs nav-justified">
-            <li class="nav-item">
-                <button id="count-retribusi" data-bs-toggle="tab" aria-expanded="false" class="nav-link">
-                    <span class="d-block d-sm-none"><i class="bx bx-home"></i></span>
-                    <span class="d-none d-sm-block">Perhitungan Retribusi</span>
-                </button>
-            </li>
-            <li class="nav-item">
-                <button id="document-validation" data-bs-toggle="tab" aria-expanded="true"
-                    class="nav-link active">
-                    <span class="d-block d-sm-none"><i class="bx bx-user"></i></span>
-                    <span class="d-none d-sm-block">Validasi Dokumen PBG</span>
-                </button>
-            </li>
-            <li class="nav-item">
-                <button id="data-information" data-bs-toggle="tab" aria-expanded="false" class="nav-link">
-                    <span class="d-block d-sm-none"><i class="bx bx-envelope"></i></span>
-                    <span class="d-none d-sm-block">Pengumpulan Data PBG</span>
-                </button>
-            </li>
-        </ul>
-    </div>
-    <div class="card-body d-flex flex-column" style="height: 700px;">
-        <!-- Conversation Area -->
-        
-        <!-- Bot Response -->
-        <div class="row flex-grow overflow-auto">
-            <div class="col-9 w-auto">
-                <span class="d-flex align-items-center mb-1">
-                    <img class="rounded-circle" width="32" src="/images/iconchatbot.jpeg" alt="avatar-3">
-               </span>
-                <div class="bot-response p-2 bg-light rounded mb-2">
-                    <p>Halo! Ada yang bisa saya bantu?</p>
-                </div>
-            </div>
-        </div>
-    
-        <!-- Input & Button (Selalu di Bawah) -->
-        <div class="row mt-auto">
-            <div class="col-xl-12 d-flex align-items-end gap-1">
-                <textarea class="form-control" id="user-message"></textarea>
-                <button id="send" class="btn btn-primary btn-lg rounded-pill">
-                    <i class='bx bx-send'></i>
-                </button>
-            </div>
-            {{-- <div class="col-xl-2 d-flex justify-content-end">
-                
-            </div> --}}
-        </div>
-        </div>
-        
-    </div>    
-</div>
-
-@endsection
-
-@section('scripts')
-@vite(['resources/js/chatbot/index.js'])
-@endsection

resources/views/dashboards/bigdata.blade.php

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

resources/views/dashboards/lack_of_potential.blade.php

@@ -9,20 +9,16 @@
 
 <div class="lack-of-potential-wrapper">
     <div class="row" id="lack-of-potential-wrapper">
-        <div class="col-12">
+        <div class="d-flex justify-content-between align-items-center mt-3 ms-2">
-            <h3 class="mt-3 ms-2 text-danger">
+            <h2 class="text-danger m-0">
                 ANALISA BIG DATA MELALUI APLIKASI SIBEDAS PBG
-            </h3>
+            </h2>
+            <div class="text-black text-end d-flex flex-column align-items-end me-3">
+                <input type="text" class="form-control mt-2" style="max-width: 125px;" id="datepicker-lack-of-potential" placeholder="Filter Date" />
+            </div>
         </div>
     </div>
     <div class="wrapper">
-        <div class="row d-flex justify-content-end">
-            <div class="col-12 col-sm-6 col-md-3">
-                <div class="d-flex flex-sm-nowrap flex-wrap justify-content-end">
-                    <input type="text" class="form-control me-3" style="max-width: 125px;" id="datepicker-lack-of-potential" placeholder="Filter Date" />
-                </div>
-            </div>
-        </div>
         <div id="lack-of-potential-fixed-container" class="" style="width:1400px;height:770px;position:relative;margin:auto;z-index:1;">
             <div style="position: absolute; top: 200px; left: 50px;">
                 <x-custom-circle title="Restoran" size="small" style="background-color: #0e4753;" />

resources/views/layouts/partials/topbar.blade.php

@@ -22,20 +22,14 @@
 
                <div class="d-flex align-items-center gap-2">
                     <!-- Theme Color (Light/Dark) -->
-                    {{-- <div class="topbar-item">
+                    <!-- <div class="topbar-item">
                          <button type="button" class="topbar-button" id="light-dark-mode">
                               <iconify-icon icon="solar:moon-outline"
                                    class="fs-22 align-middle light-mode"></iconify-icon>
                               <iconify-icon icon="solar:sun-2-outline"
                                    class="fs-22 align-middle dark-mode"></iconify-icon>
                          </button>
-                    </div> --}}
+                    </div> -->
-
-                    <div class="topbar-item">
-                         <a href="{{ route('chatbot.index') }}" class="topbar-button">
-                             <iconify-icon icon="solar:chat-square-outline" class="fs-22 align-middle"></iconify-icon>
-                         </a>
-                     </div>
 
                     <!-- Notification -->
                     <div class="dropdown topbar-item">

resources/views/layouts/vertical.blade.php

@@ -1,36 +1,6 @@
 <!DOCTYPE html>
 <html lang="en" @yield('html-attribute')>
 
-<style>
-    /* .floating-icon {
-        position: fixed;
-        right: 30px;
-        bottom: 70px;
-        background: white;
-        padding: 10px;
-        border-radius: 50%;
-        box-shadow: 0 4px 6px rgba(0, 0, 0, 0.1);
-        cursor: pointer;
-        z-index: 1000;
-    } */
-    .floating-icon {
-        position: fixed;
-        right: 40px;
-        bottom: 100px;
-        width: 70px;  /* Sesuaikan ukuran */
-        height: 70px; /* Sesuaikan ukuran */
-        background: white;
-        border-radius: 50%;
-        box-shadow: 0 4px 6px rgba(0, 0, 0, 0.1);
-        cursor: pointer;
-        z-index: 1000;
-        background-image: url('/images/iconchatbot.jpeg'); /* Path ke gambar */
-        background-size: cover;  /* Agar gambar menyesuaikan */
-        background-position: center; /* Memusatkan gambar */
-    }
-
-</style>
-
 <head>
     @include('layouts.partials/title-meta')
 
@@ -47,25 +17,10 @@
 
         <div class="page-content">
 
-            {{-- <div class="container-fluid">
-
-                @yield('content')
-                <div>
-                    <iconify-icon icon="solar:chat-square-outline" class="fs-35 align-middle"></iconify-icon>
-                </div>
-
-            </div> --}}
             <div class="container-fluid">
+
                 @yield('content')
-            
+
-                {{-- <div class="floating-icon">
-                    
-                </div>             --}}
-                @if (!Request::is('chatbot'))
-                    <a href="{{ route('chatbot.index') }}" class="floating-icon">
-                        
-                    </a>
-                @endif
             </div>
 
             @include('layouts.partials/footer')

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

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

routes/api.php

@@ -21,11 +21,9 @@ use App\Http\Controllers\Api\AdvertisementController;
 use App\Http\Controllers\Api\UmkmController;
 use App\Http\Controllers\Api\TourismController;
 use App\Http\Controllers\Api\SpatialPlanningController;
-use App\Http\Controllers\Api\ChatbotController;
 use Illuminate\Support\Facades\Route;
 
 Route::post('/login', [UsersController::class, 'login'])->name('api.user.login');
-Route::post('/generate-text', [ChatbotController::class, 'generateText']);
 Route::group(['middleware' => 'auth:sanctum'], function (){
     // users
     Route::controller(UsersController::class)->group(function(){
@@ -134,5 +132,8 @@ Route::group(['middleware' => 'auth:sanctum'], function (){
     Route::get('/dashboard-potential-count', [LackOfPotentialController::class, 'count_lack_of_potential'])->name('api.count-dashboard-potential');
 
     // big data resume
-    Route::get('/bigdata-resume', [BigDataResumeController::class, 'index'])->name('api.bigdata-resume');
+    Route::controller(BigDataResumeController::class)->group(function (){
+        Route::get('/bigdata-resume', 'index')->name('api.bigdata-resume');
+        Route::get('/bigdata-report', 'bigdata_report')->name('api.bigdata-report');
+    });
 });

routes/web.php

@@ -1,5 +1,6 @@
 <?php
 
+use App\Http\Controllers\BigdataResumesController;
 use App\Http\Controllers\BusinessOrIndustriesController;
 use App\Http\Controllers\CustomersController;
 use App\Http\Controllers\Dashboards\LackOfPotentialController;
@@ -19,7 +20,6 @@ use App\Http\Controllers\Data\TourismController;
 use App\Http\Controllers\Data\SpatialPlanningController;
 use App\Http\Controllers\Report\ReportTourismController;
 use App\Http\Controllers\SpatialPlanningsController;
-use App\Http\Controllers\Chatbot\ChatbotController;
 use Illuminate\Support\Facades\Route;
 
 require __DIR__ . '/auth.php';
@@ -59,9 +59,6 @@ Route::group(['middleware' => 'auth'], function(){
     // menus
     Route::resource('/menus', MenusController::class);
 
-    // chatbot
-    Route::resource('/chatbot', ChatbotController::class);
-
     // roles
     Route::resource('/roles', RolesController::class);
     Route::group(['prefix' => '/roles'], function (){
@@ -112,5 +109,9 @@ Route::group(['middleware' => 'auth'], function(){
     Route::group(['prefix' => '/report'], function(){
         // Resource route, kecuali create karena dibuat terpisah
         Route::resource('/tourisms-report', ReportTourismController::class);
+
+        Route::controller(BigdataResumesController::class)->group(function (){
+            Route::get('/bigdata-resumes', 'index')->name('bigdata-resumes');
+        });
     });
 });

vite.config.js

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