add readme

fix:chatbot ui

.env.example

@@ -67,4 +67,5 @@ AWS_USE_PATH_STYLE_ENDPOINT=false
 VITE_APP_NAME="${APP_NAME}"
 
 API_KEY_GOOGLE="xxxxx"
-SPREAD_SHEET_ID="xxxxx"
+SPREAD_SHEET_ID="xxxxx"
+OPENAI_API_KEY="xxxxx"

README.md

@@ -17,13 +17,14 @@ sudo nano /etc/supervisor/conf.d/laravel-worker.conf
 
 [program:laravel-worker]
 process_name=%(program_name)s_%(process_num)02d
-command=php /path-to-your-project/artisan queue:work --tries=3 --timeout=600
+command=php /home/arifal/development/sibedas-pbg-web/artisan queue:work --queue=default --timeout=40000 --tries=1 --sleep=3
 autostart=true
 autorestart=true
-numprocs=1
-user=www-data
+numprocs=4
 redirect_stderr=true
-stdout_logfile=/var/log/supervisor/laravel-worker.log
+stdout_logfile=/home/arifal/development/sibedas-pbg-web/storage/logs/worker.log
+stopasgroup=true
+killasgroup=true
 ```
 
 -   Reload Supervisor
@@ -35,3 +36,71 @@ sudo supervisorctl start laravel-worker
 sudo supervisorctl restart laravel-worker
 sudo supervisorctl status
 ```
+
+# How to running
+
+-   Install composer package
+
+```
+composer install
+```
+
+-   Install npm package
+
+```
+npm install && npm run build
+```
+
+-   Create symlinks storage
+
+```
+php artisan storage:link
+```
+
+-   Running migration
+
+```
+php artisan migrate
+```
+
+-   Create view table
+-   excute all sql queries on folder database/view_query
+
+# Add ENV variable
+
+-   API_KEY_GOOGLE
+
+```
+Get api key from google developer console for and turn on spreadsheet api or feaature for google sheet
+```
+
+-   SPREAD_SHEET_ID
+
+```
+Get spreadsheet id from google sheet link
+```
+
+-   OPENAI_API_KEY
+
+```
+Get OpenAI API key from chatgpt subscription
+```
+
+-   ENV
+
+```
+
+API_KEY_GOOGLE="xxxxx"
+SPREAD_SHEET_ID="xxxxx"
+OPENAI_API_KEY="xxxxx"
+
+```
+
+# Technology version
+
+-   php 8.3
+-   Laravel 11
+-   node v22.13.0
+-   npm 10.9.2
+-   mariadb Ver 15.1 Distrib 10.6.18-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper
+-   Ubuntu 24.04

app/Console/Commands/ExecuteScraping.php

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

app/Http/Controllers/Api/BigDataResumeController.php

@@ -19,11 +19,12 @@ class BigDataResumeController extends Controller
         try{
             $filterDate = $request->get("filterByDate");
 
-            // If filterByDate is "latest" or empty, get the most recent record
             if (!$filterDate || $filterDate === "latest") {
-                $big_data_resume = BigdataResume::latest()->first();
+                $big_data_resume = BigdataResume::where('year', now()->year)->latest()->first();
+                if (!$big_data_resume) {
+                    return $this->response_empty_resume();
+                }
             } else {
-                // Filter by specific date
                 $big_data_resume = BigdataResume::whereDate('created_at', $filterDate)
                     ->orderBy('id', 'desc')
                     ->first();
@@ -38,13 +39,17 @@ class BigDataResumeController extends Controller
                 return response()->json(['message' => 'No data setting found']);
             }
 
+            function cleanNumber($value) {
+            return floatval(str_replace('.', '', $value));
+            }
+
             $target_pad = floatval(optional($data_settings->where('key', 'TARGET_PAD')->first())->value);
-            $realisasi_terbit_pbg_sum = floatval(optional($data_settings->where('key', 'REALISASI_TERBIT_PBG_SUM')->first())->value);
-            $realisasi_terbit_pbg_count = floatval(optional($data_settings->where('key', 'REALISASI_TERBIT_PBG_COUNT')->first())->value);
-            $menuggu_klik_dpmptsp_sum = floatval(optional($data_settings->where('key', 'MENUNGGU_KLIK_DPMPTSP_SUM')->first())->value);
-            $menuggu_klik_dpmptsp_count = floatval(optional($data_settings->where('key', 'MENUNGGU_KLIK_DPMPTSP_COUNT')->first())->value);
-            $proses_dinas_teknis_sum = floatval(optional($data_settings->where('key', 'PROSES_DINAS_TEKNIS_SUM')->first())->value);
-            $proses_dinas_teknis_count = floatval(optional($data_settings->where('key', 'PROSES_DINAS_TEKNIS_COUNT')->first())->value);
+            $realisasi_terbit_pbg_sum = cleanNumber(optional($data_settings->where('key', 'REALISASI_TERBIT_PBG_SUM')->first())->value);
+            $realisasi_terbit_pbg_count = cleanNumber(optional($data_settings->where('key', 'REALISASI_TERBIT_PBG_COUNT')->first())->value);
+            $menunggu_klik_dpmptsp_sum = cleanNumber(optional($data_settings->where('key', 'MENUNGGU_KLIK_DPMPTSP_SUM')->first())->value);
+            $menunggu_klik_dpmptsp_count = cleanNumber(optional($data_settings->where('key', 'MENUNGGU_KLIK_DPMPTSP_COUNT')->first())->value);
+            $proses_dinas_teknis_sum = cleanNumber(optional($data_settings->where('key', 'PROSES_DINAS_TEKNIS_SUM')->first())->value);
+            $proses_dinas_teknis_count = cleanNumber(optional($data_settings->where('key', 'PROSES_DINAS_TEKNIS_COUNT')->first())->value);
             
             $tata_ruang = $big_data_resume->spatial_sum;
             $kekurangan_potensi = $target_pad - $big_data_resume->potention_sum;
@@ -82,8 +87,8 @@ class BigDataResumeController extends Controller
             ? round(($realisasi_terbit_pbg_sum / $big_data_resume->verified_sum) * 100, 2) : 0;
 
             // percentage menunggu klik dpmptsp
-            $menunggu_klik_dpmptsp_percentage = $big_data_resume->verified_sum > 0 && $menuggu_klik_dpmptsp_sum > 0
-            ? round(($menuggu_klik_dpmptsp_sum / $big_data_resume->verified_sum) * 100, 2) : 0;
+            $menunggu_klik_dpmptsp_percentage = $big_data_resume->verified_sum > 0 && $menunggu_klik_dpmptsp_sum > 0
+            ? round(($menunggu_klik_dpmptsp_sum / $big_data_resume->verified_sum) * 100, 2) : 0;
 
             // percentage proses_dinas_teknis
             $proses_dinas_teknis_percentage = $big_data_resume->verified_sum > 0 && $proses_dinas_teknis_sum > 0
@@ -134,8 +139,8 @@ class BigDataResumeController extends Controller
                     'percentage' => $realisasi_terbit_percentage
                 ],
                 'menunggu_klik_dpmptsp' => [
-                    'sum' => $menuggu_klik_dpmptsp_sum,
-                    'count' => $menuggu_klik_dpmptsp_count,
+                    'sum' => $menunggu_klik_dpmptsp_sum,
+                    'count' => $menunggu_klik_dpmptsp_count,
                     'percentage' => $menunggu_klik_dpmptsp_percentage
                 ],
                 'proses_dinas_teknis' => [
@@ -150,15 +155,17 @@ 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->where('year', 'LIKE', '%'.$request->input('search').'%');
             }
 
-            $query = $query->paginate(15);
+            $query = $query->paginate(config('app.paginate_per_page', 50));
             return  BigdataResumeResource::collection($query)->response()->getData(true);
         }catch(\Exception $e){
             Log::error($e->getMessage());
@@ -166,38 +173,6 @@ class BigDataResumeController extends Controller
         }
     }
 
-    /**
-     * Store a newly created resource in storage.
-     */
-    public function store(Request $request)
-    {
-        //
-    }
-
-    /**
-     * Display the specified resource.
-     */
-    public function show(string $id)
-    {
-        //
-    }
-
-    /**
-     * Update the specified resource in storage.
-     */
-    public function update(Request $request, string $id)
-    {
-        //
-    }
-
-    /**
-     * Remove the specified resource from storage.
-     */
-    public function destroy(string $id)
-    {
-        //
-    }
-
     private function response_empty_resume(){
         $result = [
             'target_pad' => [

app/Http/Controllers/Api/BusinessOrIndustriesController.php

@@ -31,7 +31,7 @@ class BusinessOrIndustriesController extends Controller
             });
         }
 
-        return response()->json($query->paginate());
+        return response()->json($query->paginate(config('app.paginate_per_page', 50)));
     }
 
     /**

app/Http/Controllers/Api/ChatbotController.php

@@ -0,0 +1,119 @@
+<?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;
+use Illuminate\Support\Facades\Log;
+
+class ChatbotController extends Controller
+{
+    protected $openAIService;
+
+    public function __construct(OpenAIService $openAIService)
+    {
+        $this->openAIService = $openAIService;
+    }
+
+    public function generateText(Request $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",
+        };
+
+        $chatHistory = $request->input('chatHistory');
+        // Log::info('Chat history sebelum disimpan:', ['history' => $chatHistory]);
+
+        if ($main_content === "UNKNOWN") {
+            return response()->json(['response' => 'Invalid tab_active value.'], 400);
+        }
+
+        // info($main_content);
+
+        $queryResponse = $this->openAIService->generateQueryBasedMainContent($request->input('prompt'), $main_content, $chatHistory);
+        
+        $firstValidation = $this->openAIService->validateSyntaxQuery($queryResponse);
+        $secondValidation = $this->openAIService->validateSyntaxQuery($queryResponse);
+
+        $formattedResultQuery = "[]";
+        $queryResponse = str_replace(['```sql', '```'], '', $queryResponse);
+        $resultQuery = DB::select($queryResponse);
+        $formattedResultQuery = json_encode($resultQuery, JSON_PRETTY_PRINT);
+        // info($formattedResultQuery);
+        
+        $nlpResult = $this->openAIService->generateNLPFromQuery($request->input('prompt'), $formattedResultQuery);
+        $finalGeneratedText =$this->openAIService->generateFinalText($nlpResult);
+        return response()->json(['response' => $finalGeneratedText, 'nlpResponse' => $queryResponse]);
+    }
+
+    public function mainGenerateText(Request $request)
+    {
+        // Log hanya data yang relevan
+        info("Received prompt: " . $request->input('prompt'));
+
+        // Validasi input
+        $request->validate([
+            'prompt' => 'required|string',
+        ]);
+
+        try {
+            // Panggil service untuk generate text
+            $classifyResponse = $this->openAIService->classifyMainGenerateText($request->input('prompt'));
+            info($classifyResponse);
+
+            // Pastikan hasil klasifikasi valid sebelum melanjutkan
+            $validCategories = [
+                'reklame', 'business_or_industries', 'customers', 
+                'pbg', 'retribusi', 'spatial_plannings', 
+                'tourisms', 'umkms'
+            ];
+
+            if (!in_array($classifyResponse, $validCategories)) {
+                return response()->json([
+                    'error' => ''
+                ], 400);
+            }
+
+            $chatHistory = $request->input('chatHistory');
+            Log::info('Chat history sebelum disimpan:', ['history' => $chatHistory]);
+
+            $queryResponse = $this->openAIService->createMainQuery($classifyResponse, $request->input('prompt'), $chatHistory);
+            info($queryResponse);
+
+            $firstValidation = $this->openAIService->validateSyntaxQuery($queryResponse);
+            $secondValidation = $this->openAIService->validateSyntaxQuery($queryResponse);
+
+            $formattedResultQuery = "[]";
+            
+            $queryResponse = str_replace(['```sql', '```'], '', $queryResponse);
+            $queryResult = DB::select($queryResponse);
+            
+            $formattedResultQuery = json_encode($queryResult, JSON_PRETTY_PRINT);
+            
+            $nlpResult = $this->openAIService->generateNLPFromQuery($request->input('prompt'), $formattedResultQuery);
+            $finalGeneratedText =$this->openAIService->generateFinalText($nlpResult);
+            
+            return response()->json(['response' => $finalGeneratedText, 'nlpResponse' => $queryResponse]);
+        } catch (\Exception $e) {
+            // Tangani error dan log exception
+            \Log::error("Error generating text: " . $e->getMessage());
+
+            return response()->json([
+                'error' => ''
+            ], 500);
+        }
+    }
+
+}

app/Http/Controllers/Api/CustomersController.php

@@ -24,7 +24,7 @@ class CustomersController extends Controller
                 ->orWhere('nama', 'LIKE', '%'.$request->get('search').'%')
                 ->orWhere('kota_pelayanan', 'LIKE', '%'.$request->get('search').'%');
         }
-        return CustomersResource::collection($query->paginate());
+        return CustomersResource::collection($query->paginate(config('app.paginate_per_page', 50)));
     }
 
     /**

app/Http/Controllers/Api/GlobalSettingsController.php

@@ -34,7 +34,7 @@ class GlobalSettingsController extends Controller
         try {
             $data = GlobalSetting::create($request->validated());
             return new GlobalSettingResource($data);
-        } catch (\Exception $e) {
+        } catch (Exception $e) {
             return $this->resError($e->getMessage(), null, $e->getCode());
         }
     }

app/Http/Controllers/Api/ImportDatasourceController.php

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

app/Http/Controllers/Api/LackOfPotentialController.php

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

app/Http/Controllers/Api/MenusController.php

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

app/Http/Controllers/Api/RequestAssignmentController.php

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

app/Http/Controllers/Api/RolesController.php

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

app/Http/Controllers/Api/ScrapingController.php

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

app/Http/Controllers/Api/TaskAssignmentsController.php

@@ -0,0 +1,64 @@
+<?php
+
+namespace App\Http\Controllers\Api;
+
+use App\Http\Controllers\Controller;
+use App\Http\Resources\TaskAssignmentsResource;
+use App\Models\TaskAssignment;
+use Illuminate\Http\Request;
+
+class TaskAssignmentsController extends Controller
+{
+    /**
+     * Display a listing of the resource.
+     */
+    public function index(Request $request, $uuid)
+    {
+        try{
+            $query = TaskAssignment::query()
+            ->where('pbg_task_uid', $uuid)
+                ->orderBy('id', 'desc');
+
+            if ($request->filled('search')) {
+                $query->where('name', 'like', "%{$request->get('search')}%")
+                ->orWhere('email', 'like', "%{$request->get('search')}%");
+            }
+
+            return TaskAssignmentsResource::collection($query->paginate(config('app.paginate_per_page', 50)));
+        }catch(\Exception $exception){
+            return response()->json(['message' => $exception->getMessage()], 500);
+        }
+    }
+
+    /**
+     * Store a newly created resource in storage.
+     */
+    public function store(Request $request)
+    {
+        //
+    }
+
+    /**
+     * Display the specified resource.
+     */
+    public function show(string $id)
+    {
+        //
+    }
+
+    /**
+     * Update the specified resource in storage.
+     */
+    public function update(Request $request, string $id)
+    {
+        //
+    }
+
+    /**
+     * Remove the specified resource from storage.
+     */
+    public function destroy(string $id)
+    {
+        //
+    }
+}

app/Http/Controllers/Api/UsersController.php

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

app/Http/Controllers/Chatbot/ChatbotController.php

@@ -0,0 +1,17 @@
+<?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/Controllers/ChatbotPimpinan/ChatbotPimpinanController.php

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

app/Http/Controllers/Dashboards/PotentialsController.php

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

app/Http/Controllers/Data/AdvertisementController.php

@@ -62,7 +62,7 @@ class AdvertisementController extends Controller
         // Pastikan model ditemukan
         if (!$modelInstance) {
             info("AdvertisementController@edit: Model tidak ditemukan.");
-            return redirect()->route('advertisements.index')->with('error', 'Advertisement not found');
+            return redirect()->route('web.advertisements.index')->with('error', 'Advertisement not found');
         }
 
         // Mengambil dan memetakan village_name dan district_name

app/Http/Controllers/Data/TourismController.php

@@ -58,7 +58,7 @@ class TourismController extends Controller
         $modelInstance = Tourism::find($id);
         // Pastikan model ditemukan
         if (!$modelInstance) {
-            return redirect()->route('tourisms.index') ->with('error', 'Pariwisata tidak ditemukan');
+            return redirect()->route('web-tourisms.index') ->with('error', 'Pariwisata tidak ditemukan');
         }
 
         // Mengambil dan memetakan village_name dan district_name

app/Http/Controllers/Data/UmkmController.php

@@ -60,7 +60,7 @@ class UmkmController extends Controller
         $modelInstance = Umkm::find($id);
         // Pastikan model ditemukan
         if (!$modelInstance) {
-            return redirect()->route('umkm.index')->with('error', 'Umkm not found');
+            return redirect()->route('web-umkm.index')->with('error', 'Umkm not found');
         }
 
         // Mengambil dan memetakan village_name dan district_name

app/Http/Controllers/Settings/SyncronizeController.php

@@ -17,12 +17,12 @@ class SyncronizeController extends Controller
     }
 
     public function syncPbgTask(){
-        $res = $this->service_simbg->syncTaskList();
+        $res = $this->service_simbg->syncTaskPBG();
         return $res;
     }
 
     public function syncronizeTask(Request $request){
-        $res = $this->service_simbg->syncTaskList();
+        $res = $this->service_simbg->syncTaskPBG();
         return redirect()->back()->with('success', 'Processing completed successfully');
     }
 
@@ -33,7 +33,7 @@ class SyncronizeController extends Controller
 
     public function syncIndexIntegration(Request $request, $uuid){
         $token = $request->get('token');
-        $res = $this->service_simbg->syncIndexIntegration($uuid, $token);
+        $res = $this->service_simbg->syncIndexIntegration($uuid);
         return $res;
     }
 
@@ -42,4 +42,9 @@ class SyncronizeController extends Controller
         $res = $this->service_simbg->syncTaskDetailSubmit($uuid, $token);
         return $res;
     }
+
+    public function syncTaskAssignments($uuid){
+        $res = $this->service_simbg->syncTaskAssignments($uuid);
+        return $res;
+    }
 }

app/Http/Resources/BigdataResumeResource.php

@@ -34,7 +34,16 @@ class BigdataResumeResource extends JsonResource
 
             'spatial_count'        => (int) $this->spatial_count,
             'spatial_sum'          => number_format((float) $this->spatial_sum, 2, ',', '.'),
-
+            
+            'issuance_realization_pbg_count'        => (int) $this->issuance_realization_pbg_count,
+            'issuance_realization_pbg_sum'          => number_format((float) $this->issuance_realization_pbg_sum, 2, ',', '.'),
+            
+            'waiting_click_dpmptsp_count'        => (int) $this->waiting_click_dpmptsp_count,
+            'waiting_click_dpmptsp_sum'          => number_format((float) $this->waiting_click_dpmptsp_sum, 2, ',', '.'),
+            
+            'process_in_technical_office_count'        => (int) $this->process_in_technical_office_count,
+            'process_in_technical_office_sum'          => number_format((float) $this->process_in_technical_office_sum, 2, ',', '.'),
+            
             'year'                 => $this->year,
             'created_at' => $this->created_at->toDateTimeString(),
         ];

app/Http/Resources/TaskAssignmentsResource.php

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

app/Jobs/SyncronizeSIMBG.php

@@ -0,0 +1,35 @@
+<?php
+
+namespace App\Jobs;
+
+use App\Services\GoogleSheetService;
+use App\Services\ServiceSIMBG;
+use Illuminate\Bus\Queueable;
+use Illuminate\Contracts\Queue\ShouldQueue;
+use Illuminate\Foundation\Bus\Dispatchable;
+use Illuminate\Queue\InteractsWithQueue;
+use Illuminate\Queue\SerializesModels;
+
+class SyncronizeSIMBG implements ShouldQueue
+{
+    use Dispatchable, InteractsWithQueue, Queueable, SerializesModels;
+
+    public $tries = 1;
+
+    public function __construct()
+    {
+    }
+
+    public function handle(): void
+    {
+        try {
+            $serviceSIMBG = app(ServiceSIMBG::class);
+            $serviceSIMBG->syncTaskPBG();
+        } catch (\Exception $e) {
+            \Log::error("SyncronizeSIMBG Job Failed: " . $e->getMessage(), [
+                'exception' => $e,
+            ]);
+            $this->fail($e); // Mark the job as failed
+        }
+    }
+}

app/Models/BigdataResume.php

@@ -23,7 +23,13 @@ class BigdataResume extends Model
         'non_business_sum',
         'spatial_count',
         'spatial_sum',
-        'year'
+        'year',
+        'waiting_click_dpmptsp_count',
+        'waiting_click_dpmptsp_sum',
+        'issuance_realization_pbg_count',
+        'issuance_realization_pbg_sum',
+        'process_in_technical_office_count',
+        'process_in_technical_office_sum',
     ];
 
     public function importDatasource()
@@ -31,7 +37,7 @@ class BigdataResume extends Model
         return $this->belongsTo(ImportDatasource::class, 'import_datasource_id');
     }
 
-    public static function generateResumeData($import_datasource_id, $year){
+    public static function generateResumeData($import_datasource_id, $year, $data_setting){
         $stats = PbgTask::with(['googleSheet', 'pbg_task_retributions'])
             ->leftJoin('pbg_task_retributions as ptr', 'pbg_task.uuid', '=', 'ptr.pbg_task_uid')
             ->leftJoin('pbg_task_google_sheet as ptgs', 'pbg_task.registration_number', '=', 'ptgs.no_registrasi')
@@ -82,9 +88,15 @@ class BigdataResume extends Model
         $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');
+            $query = PbgTask::leftJoin('spatial_plannings as sp', 'pbg_task.document_number', '=', 'sp.number')
+                ->leftJoin('pbg_task_retributions as ptr', 'ptr.pbg_task_uid', '=', 'pbg_task.uuid')
+                ->selectRaw('
+                    CASE 
+                        WHEN COUNT(DISTINCT sp.id) > 0 THEN COUNT(DISTINCT sp.id)
+                        ELSE (SELECT COUNT(*) FROM spatial_plannings) 
+                    END as task_count,
+                    SUM(CASE WHEN sp.id IS NOT NULL AND ptr.id IS NOT NULL THEN ptr.nilai_retribusi_bangunan ELSE 0 END) as total_retribution
+                ');
 
             if ($year !== 'all') {
                 $query->whereYear('pbg_task.task_created_at', (int) $year);
@@ -94,7 +106,7 @@ class BigdataResume extends Model
         });
 
         $spatial_planning_count = $query_spatial_plannings->task_count ?? 0;
-        $spatial_planning_total = $query_spatial_plannings->total_retribution ?? 0;
+        $spatial_planning_total = $query_spatial_plannings->total_retribution;
 
         $potention_count -= $spatial_planning_count;
         $potention_total -= $spatial_planning_total;
@@ -113,7 +125,13 @@ class BigdataResume extends Model
             'business_sum' => $business_total ?? 0.00,
             'non_business_count' => $non_business_count ?? 0,
             'non_business_sum' => $non_business_total ?? 0.00,
-            'year' => $year
+            'year' => $year,
+            'waiting_click_dpmptsp_count' => $data_setting['MENUNGGU_KLIK_DPMPTSP_COUNT'] ?? 0,
+            'waiting_click_dpmptsp_sum' => $data_setting['MENUNGGU_KLIK_DPMPTSP_SUM'] ?? 0.00,
+            'issuance_realization_pbg_count' => $data_setting['REALISASI_TERBIT_PBG_COUNT'] ?? 0,
+            'issuance_realization_pbg_sum' => $data_setting['REALISASI_TERBIT_PBG_SUM'] ?? 0.00,
+            'process_in_technical_office_count' => $data_setting['PROSES_DINAS_TEKNIS_COUNT'] ?? 0,
+            'process_in_technical_office_sum' => $data_setting['PROSES_DINAS_TEKNIS_SUM'] ??0.00,
         ]);
     }
 }

app/Models/PbgTask.php

@@ -41,4 +41,9 @@ class PbgTask extends Model
     public function googleSheet(){
         return $this->hasOne(PbgTaskGoogleSheet::class, 'no_registrasi', 'registration_number');
     }
+
+    public function taskAssignments()
+    {
+        return $this->hasMany(TaskAssignment::class, 'pbg_task_uid', 'uuid');
+    }
 }

app/Models/TaskAssignment.php

@@ -0,0 +1,28 @@
+<?php
+
+namespace App\Models;
+
+use Illuminate\Database\Eloquent\Model;
+use Illuminate\Database\Eloquent\Factories\HasFactory;
+
+class TaskAssignment extends Model
+{
+    use HasFactory;
+
+    protected $fillable = [
+        'user_id', 'name', 'username', 'email', 'phone_number', 'role',
+        'role_name', 'is_active', 'file', 'expertise', 'experience',
+        'is_verif', 'uid', 'status', 'status_name', 'note', 'pbg_task_uid', 'tas_id'
+    ];
+
+    protected $casts = [
+        'is_active' => 'boolean',
+        'is_verif' => 'boolean',
+        'file' => 'array', // JSON field casting
+    ];
+
+    public function pbgTask()
+    {
+        return $this->belongsTo(PbgTask::class, 'pbg_task_uid', 'uuid');
+    }
+}

app/Providers/AppServiceProvider.php

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

app/Services/GoogleSheetService.php

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

app/Services/OpenAIService.php

@@ -0,0 +1,276 @@
+<?php
+
+namespace App\Services;
+
+use OpenAI;
+use Illuminate\Support\Facades\Storage;
+use Illuminate\Support\Facades\Log;
+
+class OpenAIService
+{
+    protected $client;
+
+    public function __construct()
+    {
+        // $this->client = OpenAI::client(env('OPENAI_API_KEY'));
+        $this->client = OpenAI::client(env('OPENAI_API_KEY'));
+    }
+
+    public function generateQueryBasedMainContent($prompt, $mainContent, $chatHistory)
+    {
+        // 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'];
+
+        // Menyusun pesan untuk OpenAI
+        $messages = [
+            ['role' => 'system', 'content' => $promptTemplate],
+        ];
+
+        // Menambahkan chat history sebagai konteks
+        foreach ($chatHistory as $chat) {
+            if (isset($chat['user'])) {
+                $messages[] = ['role' => 'user', 'content' => $chat['user']];
+            }
+            if (isset($chat['rawBotResponse'])) {
+                $messages[] = ['role' => 'assistant', 'content' => $chat['rawBotResponse']];
+            }
+        }
+
+        // Tambahkan prompt terbaru user
+        $messages[] = ['role' => 'user', 'content' => $prompt];
+
+        // Kirim request ke OpenAI API
+        $response = $this->client->chat()->create([
+            'model' => 'gpt-4o-mini',
+            'messages' => $messages,
+        ]);
+
+        return trim($response['choices'][0]['message']['content'] ?? 'No response');
+    }
+
+    
+    // public function generateQueryBasedMainContent($prompt, $mainContent, $chatHistory)
+    // {
+    //     // 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');
+    }
+
+    public function classifyMainGenerateText($prompt) {
+        $response = $this->client->chat()->create([
+            'model' => 'gpt-4o-mini',
+            'messages' => [
+                [
+                    'role' => 'system',
+                    'content' => "You are an assistant that classifies text into one of the following categories:
+                    - reklame (ads or product/service promotions)
+                    - business_or_industries (business or industries in general)
+                    - customers (customers, consumers, or service users)
+                    - pbg (tasks related to Building Approval)
+                    - retribusi (retributions related to PBG)
+                    - spatial_plannings (spatial planning)
+                    - tourisms (tourism and tourist destinations)
+                    - umkms (Micro, Small, and Medium Enterprises)
+    
+                    Respond with only one of the categories above without any additional explanation."
+                ],
+                [
+                    'role' => 'user',
+                    'content' => "Classify the following text:\n\n" . $prompt
+                ],
+            ],
+        ]);
+    
+        return trim($response['choices'][0]['message']['content'] ?? 'No response');
+    }
+
+    public function createMainQuery($classify, $prompt, $chatHistory)
+    {
+        // Load file JSON
+        $jsonPath = public_path('templates/table_config.json');
+        $jsonConfig = json_decode(file_get_contents($jsonPath), true);
+
+        // Pastikan kategori tersedia dalam konfigurasi
+        if (!isset($jsonConfig[$classify])) {
+            return "Error: Kategori tidak ditemukan dalam konfigurasi.";
+        }
+
+        // Ambil nama tabel dan kolom
+        $tableName = $jsonConfig[$classify]['table_name'];
+        $columns = implode(', ', $jsonConfig[$classify]['list_column']);
+
+        // Konversi chatHistory ke dalam format messages
+        $messages = [
+            [
+                'role' => 'system',
+                'content' => "You are an AI assistant that generates only valid MariaDB queries based on user requests. 
+                Use the following table information to construct the SQL query:
+
+                - Table Name: $tableName
+                - Available Columns: $columns
+
+                Generate only the SQL query without any explanation or additional text.
+                The query should include `LIMIT 10` to restrict the results."
+            ]
+        ];
+
+        // Menambahkan chat history sebagai konteks
+        foreach ($chatHistory as $chat) {
+            if (isset($chat['user'])) {
+                $messages[] = ['role' => 'user', 'content' => $chat['user']];
+            }
+            if (isset($chat['rawBotResponse'])) {
+                $messages[] = ['role' => 'assistant', 'content' => $chat['rawBotResponse']];
+            }
+        }
+
+        // Tambahkan prompt utama pengguna
+        $messages[] = ['role' => 'user', 'content' => $prompt];
+
+        // Kirim permintaan ke model AI
+        $response = $this->client->chat()->create([
+            'model' => 'gpt-4o-mini',
+            'messages' => $messages
+        ]);
+
+        return trim($response['choices'][0]['message']['content'] ?? 'No response');
+    }
+
+    
+    // public function createMainQuery($classify, $prompt)
+    // {
+    //     // Load file JSON
+    //     $jsonPath = public_path('templates/table_config.json');
+    //     $jsonConfig = json_decode(file_get_contents($jsonPath), true);
+
+    //     // Pastikan kategori tersedia dalam konfigurasi
+    //     if (!isset($jsonConfig[$classify])) {
+    //         return "Error: Kategori tidak ditemukan dalam konfigurasi.";
+    //     }
+
+    //     // Ambil nama tabel dan kolom
+    //     $tableName = $jsonConfig[$classify]['table_name'];
+    //     $columns = implode(', ', $jsonConfig[$classify]['list_column']);
+
+    //     $response = $this->client->chat()->create([
+    //         'model' => 'gpt-4o-mini',
+    //         'messages' => [
+    //             [
+    //                 'role' => 'system',
+    //                 'content' => "You are an AI assistant that generates only valid MariaDB queries based on user requests. 
+    //                 Use the following table information to construct the SQL query:
+
+    //                 - Table Name: $tableName
+    //                 - Available Columns: $columns
+
+    //                 Generate only the SQL query without any explanation or additional text
+    //                 The query should include `LIMIT 10` to restrict the results."
+    //             ],
+    //             [
+    //                 'role' => 'user',
+    //                 'content' => $prompt
+    //             ],
+    //         ],
+    //     ]);
+    
+    //     return trim($response['choices'][0]['message']['content'] ?? 'No response');
+    // }
+}

app/Services/ServiceClient.php

@@ -51,10 +51,26 @@ class ServiceClient
 
             $resultResponse = json_decode($responseBody, true, 512, JSON_THROW_ON_ERROR);
             return $this->resSuccess($resultResponse);
-        } catch (Exception $e) {
-            \Log::error('error from client service'. $e->getMessage());
-            return $this->resError($e->getMessage());
-        }
+            } catch (\GuzzleHttp\Exception\ClientException $e) {
+                // Handle 4xx errors (e.g., 401 Unauthorized)
+                $responseBody = (string) $e->getResponse()->getBody();
+                $errorResponse = json_decode($responseBody, true);
+
+                if (isset($errorResponse['code']) && $errorResponse['code'] === 'token_not_valid') {
+                    return $this->resError('Invalid token, please refresh your token.', $errorResponse, 401);
+                }
+
+                return $this->resError('Client error from API', $errorResponse, $e->getResponse()->getStatusCode());
+            } catch (\GuzzleHttp\Exception\ServerException $e) {
+                // Handle 5xx errors (e.g., Internal Server Error)
+                return $this->resError('Server error from API', (string) $e->getResponse()->getBody(), 500);
+            } catch (\GuzzleHttp\Exception\RequestException $e) {
+                // Handle network errors (e.g., timeout, connection issues)
+                return $this->resError('Network error: ' . $e->getMessage(), null, 503);
+            } catch (Exception $e) {
+                // Handle unexpected errors
+                return $this->resError('Unexpected error: ' . $e->getMessage(), null, 500);
+            }
     }
 
     // Fungsi untuk melakukan permintaan GET

app/Services/ServiceSIMBG.php

@@ -9,12 +9,16 @@ use App\Models\ImportDatasource;
 use App\Models\PbgTaskIndexIntegrations;
 use App\Models\PbgTaskPrasarana;
 use App\Models\PbgTaskRetributions;
+use App\Models\TaskAssignment;
 use Exception;
 use App\Models\PbgTask;
 use App\Traits\GlobalApiResponse;
 use Illuminate\Support\Facades\Log;
 use Carbon\Carbon;
 use App\Services\ServiceClient;
+use App\Services\GoogleSheetService;
+use App\Models\DataSetting;
+use App\Models\PbgTaskGoogleSheet;
 
 class ServiceSIMBG
 {
@@ -24,10 +28,11 @@ class ServiceSIMBG
     private $simbg_host;
     private $fetch_per_page;
     private $service_client;
+    private $googleSheetService;
     /**
      * Create a new class instance.
      */
-    public function __construct()
+    public function __construct(GoogleSheetService $googleSheetService)
     {
         $settings = GlobalSetting::whereIn('key', [
             'SIMBG_EMAIL', 'SIMBG_PASSWORD', 'SIMBG_HOST', 'FETCH_PER_PAGE'
@@ -39,6 +44,7 @@ class ServiceSIMBG
         $this->fetch_per_page = trim((string) ($settings['FETCH_PER_PAGE'] ?? ""));
     
         $this->service_client = new ServiceClient($this->simbg_host);
+        $this->googleSheetService = $googleSheetService;
     }
 
     public function getToken(){
@@ -61,12 +67,19 @@ class ServiceSIMBG
         }
     }
 
-    public function syncIndexIntegration($uuids, $token)
+    public function syncIndexIntegration($uuids)
     {
         try{
             if(empty($uuids)){
                 return false;
             }
+
+            $initResToken = $this->getToken();
+            if (empty($initResToken->original['data']['token']['access'])) {
+                Log::error("API response indicates failure", ['token' => 'Failed to retrieve token']);
+                return false;
+            }
+            $token = $initResToken->original['data']['token']['access'];
             
             $integrations = [];
             foreach($uuids as $uuid){
@@ -112,22 +125,184 @@ class ServiceSIMBG
         }
     }
 
-    public function syncTaskList()
+    public function syncTaskPBG()
     {
         try {
+            Log::info("Processing google sheet sync");
             $importDatasource = ImportDatasource::create([
                 'status' => ImportDatasourceStatus::Processing->value,
             ]);
 
+            // sync google sheet first
+            $totalRowCount = $this->googleSheetService->getLastRowByColumn("C");
+            $sheetData = $this->googleSheetService->getSheetDataCollection($totalRowCount);
+            $sheet_big_data = $this->googleSheetService->get_data_by_sheet();
+            $data_setting_result = []; // Initialize result storage
+        
+            $found_section = null; // Track which section is found
+        
+            foreach ($sheet_big_data as $row) {
+                // Check for section headers
+                if (in_array("•PROSES PENERBITAN:", $row)) {
+                    $found_section = "MENUNGGU_KLIK_DPMPTSP";
+                } elseif (in_array("•BERKAS AKTUAL TERVERIFIKASI DINAS TEKNIS 2024:", $row)) {
+                    $found_section = "REALISASI_TERBIT_PBG";
+                } elseif (in_array("•TERPROSES DI DPUTR: belum selesai rekomtek'", $row)) {
+                    $found_section = "PROSES_DINAS_TEKNIS";
+                }
+        
+                // If a section is found and we reach "Grand Total", save the corresponding values
+                if ($found_section && isset($row[0]) && trim($row[0]) === "Grand Total") {
+                    if ($found_section === "MENUNGGU_KLIK_DPMPTSP") {
+                        $data_setting_result["MENUNGGU_KLIK_DPMPTSP_COUNT"] = $this->convertToInteger($row[2]) ?? null;
+                        $data_setting_result["MENUNGGU_KLIK_DPMPTSP_SUM"] = $this->convertToDecimal($row[3])  ?? null;
+                    } elseif ($found_section === "REALISASI_TERBIT_PBG") {
+                        $data_setting_result["REALISASI_TERBIT_PBG_COUNT"] = $this->convertToInteger($row[2]) ?? null;
+                        $data_setting_result["REALISASI_TERBIT_PBG_SUM"] = $this->convertToDecimal($row[4]) ?? null;
+                    } elseif ($found_section === "PROSES_DINAS_TEKNIS") {
+                        $data_setting_result["PROSES_DINAS_TEKNIS_COUNT"] = $this->convertToInteger($row[2]) ?? null;
+                        $data_setting_result["PROSES_DINAS_TEKNIS_SUM"] = $this->convertToDecimal($row[3]) ?? null;
+                    }
+        
+                    // Reset section tracking after capturing "Grand Total"
+                    $found_section = null;
+                }
+            }
+
+            Log::info("data setting result", ['result' => $data_setting_result]);
+
+            foreach ($data_setting_result as $key => $value) {
+                DataSetting::updateOrInsert(
+                    ["key" => $key], // Find by key
+                    ["value" => $value] // Update or insert value
+                );
+            }
+            $mapToUpsert = [];
+
+            foreach($sheetData as $data){
+                $mapToUpsert[] = 
+                    [
+                        'no_registrasi' => $data['no__registrasi'] ?? null,
+                        'jenis_konsultasi' => $data['jenis_konsultasi'] ?? null,
+                        'fungsi_bg' => $data['fungsi_bg'] ?? null,
+                        'tgl_permohonan' => $this->convertToDate($data['tgl_permohonan']),
+                        'status_verifikasi' => $data['status_verifikasi'] ?? null,
+                        'status_permohonan' => $this->convertToDate($data['status_permohonan']),
+                        'alamat_pemilik' => $data['alamat_pemilik'] ?? null,
+                        'no_hp' => $data['no__hp'] ?? null,
+                        'email' => $data['e_mail'] ?? null,
+                        'tanggal_catatan' => $this->convertToDate($data['tanggal_catatan']),
+                        'catatan_kekurangan_dokumen' => $data['catatan_kekurangan_dokumen'] ?? null,
+                        'gambar' => $data['gambar'] ?? null,
+                        'krk_kkpr' => $data['krk_kkpr'] ?? null,
+                        'no_krk' => $data['no__krk'] ?? null,
+                        'lh' => $data['lh'] ?? null,
+                        'ska' => $data['ska'] ?? null,
+                        'keterangan' => $data['keterangan'] ?? null,
+                        'helpdesk' => $data['helpdesk'] ?? null,
+                        'pj' => $data['pj'] ?? null,
+                        'kepemilikan' => $data['kepemilikan'] ?? null,
+                        'potensi_taru' => $data['potensi_taru'] ?? null,
+                        'validasi_dinas' => $data['validasi_dinas'] ?? null,
+                        'kategori_retribusi' => $data['kategori_retribusi'] ?? null,
+                        'no_urut_ba_tpt' => $data['no__urut_ba_tpt__2024_0001_'] ?? null,
+                        'tanggal_ba_tpt' => $this->convertToDate($data['tanggal_ba_tpt']),
+                        'no_urut_ba_tpa' => $data['no__urut_ba_tpa'] ?? null,
+                        'tanggal_ba_tpa' => $this->convertToDate($data['tanggal_ba_tpa']),
+                        'no_urut_skrd' => $data['no__urut_skrd__2024_0001_'] ?? null,
+                        'tanggal_skrd' => $this->convertToDate($data['tanggal_skrd']),
+                        'ptsp' => $data['ptsp'] ?? null,
+                        'selesai_terbit' => $data['selesai_terbit'] ?? null,
+                        'tanggal_pembayaran' => $this->convertToDate($data['tanggal_pembayaran__yyyy_mm_dd_']),
+                        'format_sts' => $data['format_sts'] ?? null,
+                        'tahun_terbit' => (int) $data['tahun_terbit'] ?? null,
+                        'tahun_berjalan' => (int) $data['tahun_berjalan'] ?? null,
+                        'kelurahan' => $data['kelurahan'] ?? null,
+                        'kecamatan' => $data['kecamatan'] ?? null,
+                        'lb' => $this->convertToDecimal($data['lb'])  ?? null,
+                        'tb' => $this->convertToDecimal($data['tb']) ?? null,
+                        'jlb' => (int) $data['jlb'] ?? null,
+                        'unit' => (int) $data['unit'] ?? null,
+                        'usulan_retribusi' => (int) $data['usulan_retribusi'] ?? null,
+                        'nilai_retribusi_keseluruhan_simbg' => $this->convertToDecimal($data['nilai_retribusi_keseluruhan__simbg_']) ?? null,
+                        'nilai_retribusi_keseluruhan_pad' => $this->convertToDecimal($data['nilai_retribusi_keseluruhan__pad_']) ?? null,
+                        'denda' => $this->convertToDecimal($data['denda']) ?? null,
+                        'latitude' => $data['latitude'] ?? null,
+                        'longitude' => $data['longitude'] ?? null,
+                        'nik_nib' => $data['nik_nib'] ?? null,
+                        'dok_tanah' => $data['dok__tanah'] ?? null,
+                        'temuan' => $data['temuan'] ?? null,
+                    ];
+            }
+
+            $batchSize = 1000;
+            $chunks = array_chunk($mapToUpsert, $batchSize);
+
+            foreach($chunks as $chunk){
+                PbgTaskGoogleSheet::upsert($chunk, ["no_registrasi"],[
+                    'jenis_konsultasi',
+                    'nama_pemilik',
+                    'lokasi_bg',
+                    'fungsi_bg',
+                    'nama_bangunan',
+                    'tgl_permohonan',
+                    'status_verifikasi',
+                    'status_permohonan',
+                    'alamat_pemilik',
+                    'no_hp',
+                    'email',
+                    'tanggal_catatan',
+                    'catatan_kekurangan_dokumen',
+                    'gambar',
+                    'krk_kkpr',
+                    'no_krk',
+                    'lh',
+                    'ska',
+                    'keterangan',
+                    'helpdesk',
+                    'pj',
+                    'kepemilikan',
+                    'potensi_taru',
+                    'validasi_dinas',
+                    'kategori_retribusi',
+                    'no_urut_ba_tpt',
+                    'tanggal_ba_tpt',
+                    'no_urut_ba_tpa',
+                    'tanggal_ba_tpa',
+                    'no_urut_skrd',
+                    'tanggal_skrd',
+                    'ptsp',
+                    'selesai_terbit',
+                    'tanggal_pembayaran',
+                    'format_sts',
+                    'tahun_terbit',
+                    'tahun_berjalan',
+                    'kelurahan',
+                    'kecamatan',
+                    'lb',
+                    'tb',
+                    'jlb',
+                    'unit',
+                    'usulan_retribusi',
+                    'nilai_retribusi_keseluruhan_simbg',
+                    'nilai_retribusi_keseluruhan_pad',
+                    'denda',
+                    'latitude',
+                    'longitude',
+                    'nik_nib',
+                    'dok_tanah',
+                    'temuan',
+                ]);
+            }
+            
+            $initResToken = $this->getToken();
             if (empty($initResToken->original['data']['token']['access'])) {
                 $importDatasource->update([
                     'status' => ImportDatasourceStatus::Failed->value,
-                    'message' => 'Failed to retrieve token'
+                    'response_body' => 'Failed to retrieve token'
                 ]);
                 return $this->resError("Failed to retrieve token");
             }
-
-            $initResToken = $this->getToken();
             $apiToken = $initResToken->original['data']['token']['access'];
             $headers = ['Authorization' => "Bearer " . $apiToken];
 
@@ -138,20 +313,49 @@ class ServiceSIMBG
             if ($totalPage == 0) {
                 $importDatasource->update([
                     'status' => ImportDatasourceStatus::Failed->value,
-                    'message' => 'Invalid response: no total_page'
+                    'response_body' => 'Invalid response: no total_page'
                 ]);
                 return $this->resError("Invalid response from API");
             }
 
             $savedCount = $failedCount = 0;
 
+            Log::info("Fetching tasks", ['total page' => $totalPage]);
+
             for ($currentPage = 1; $currentPage <= $totalPage; $currentPage++) {
                 try {
                     $pageUrl = "/api/pbg/v1/list/?page={$currentPage}&size={$this->fetch_per_page}&sort=ASC";
 
                     Log::info("Fetching tasks", ['currentPage' => $currentPage]);
+                    $headers = [
+                        'Authorization' => "Bearer " . $apiToken, // Update headers
+                    ];
+
+                    for ($attempt = 0; $attempt < 2; $attempt++) { // Try twice (original + retry)
+
+                        $response = $this->service_client->get($pageUrl, $headers);
+
+                        if ($response instanceof \Illuminate\Http\JsonResponse) {
+                            $decodedResponse = json_decode($response->getContent(), true);
+
+                            if (isset($decodedResponse['errors']['code']) && $decodedResponse['errors']['code'] === 'token_not_valid') {
+                                $initResToken = $this->getToken();
+
+                                if (!empty($initResToken->original['data']['token']['access'])) {
+                                    $new_token = $initResToken->original['data']['token']['access'];
+                                    $headers['Authorization'] = "Bearer " . $new_token;
+                                    continue;
+                                } else {
+                                    Log::error("Failed to refresh token");
+                                    return $this->resError("Failed to refresh token");
+                                }
+                            }
+                        }
+
+                        // Success case, break loop
+                        break;
+                    }
 
-                    $response = $this->service_client->get($pageUrl, $headers);
                     $tasks = $response->original['data']['data'] ?? [];
 
                     if (empty($tasks)) {
@@ -186,6 +390,7 @@ class ServiceSIMBG
                             ];
 
                             $this->syncTaskDetailSubmit($item['uid'], $apiToken);
+                            $this->syncTaskAssignments($item['uid']);
                             $savedCount++;
                         } catch (Exception $e) {
                             $failedCount++;
@@ -206,7 +411,7 @@ class ServiceSIMBG
                         ]);
 
                         $uuids = array_column($tasksCollective, 'uuid');
-                        $this->syncIndexIntegration($uuids, $apiToken);
+                        $this->syncIndexIntegration($uuids);
                     }
                 } catch (Exception $e) {
                     Log::error("Failed to process page", [
@@ -217,8 +422,8 @@ class ServiceSIMBG
                 }
             }
 
-            BigdataResume::generateResumeData($importDatasource->id, "all");
-            BigdataResume::generateResumeData($importDatasource->id, now()->year);
+            BigdataResume::generateResumeData($importDatasource->id, "all", $data_setting_result);
+            BigdataResume::generateResumeData($importDatasource->id, now()->year, $data_setting_result);
 
             // Final update after processing all pages
             $importDatasource->update([
@@ -235,34 +440,51 @@ class ServiceSIMBG
             if (isset($importDatasource)) {
                 $importDatasource->update([
                     'status' => ImportDatasourceStatus::Failed->value,
-                    'message' => 'Critical failure: ' . $e->getMessage()
+                    'response_body' => 'Critical failure: ' . $e->getMessage()
                 ]);
             }
             return $this->resError("Critical failure occurred: " . $e->getMessage());
         }
     }
 
-
-
     public function syncTaskDetailSubmit($uuid, $token)
     {
         try{
             $url = "/api/pbg/v1/detail/" . $uuid . "/retribution/submit/";
+
             $headers = [
                 'Authorization' => "Bearer " . $token,
             ];
-    
-            $res = $this->service_client->get($url, $headers);
-    
-            if (empty($res->original['success']) || !$res->original['success']) {
-                // Log error
-                Log::error("API response indicates failure", ['url' => $url, 'uuid' => $uuid]);
-                return false;
+
+            for ($attempt = 0; $attempt < 2; $attempt++) { 
+                $res = $this->service_client->get($url, $headers);
+
+                // Check if response is JsonResponse and decode it
+                if ($res instanceof \Illuminate\Http\JsonResponse) {
+                    $decodedResponse = json_decode($res->getContent(), true);
+
+                    if (isset($decodedResponse['errors']['code']) && $decodedResponse['errors']['code'] === 'token_not_valid') {
+                        $initResToken = $this->getToken();
+
+                        if (!empty($initResToken->original['data']['token']['access'])) {
+                            $new_token = $initResToken->original['data']['token']['access'];
+
+                            $headers['Authorization'] = "Bearer " . $new_token;
+                            continue; 
+                        } else {
+                            Log::error("Failed to refresh token");
+                            return $this->resError("Failed to refresh token");
+                        }
+                    }
+                }
+
+                break;
             }
-    
-            $data = $res->original['data']['data'] ?? [];
+
+            // Ensure response is valid before accessing properties
+            $responseData = $res->original ?? [];
+            $data = $responseData['data']['data'] ?? [];
             if (empty($data)) {
-                Log::error("No data returned from API", ['url' => $url, 'uuid' => $uuid]);
                 return false;
             }
     
@@ -325,4 +547,113 @@ class ServiceSIMBG
         }
     }
 
+    public function syncTaskAssignments($uuid){
+        try{
+            $init_token = $this->getToken();
+            $token = $init_token->original['data']['token']['access'];
+            $url = "/api/pbg/v1/list-tim-penilai/". $uuid . "/?page=1&size=10";
+            $headers = [
+                'Authorization' => "Bearer " . $token,
+            ];
+
+            $response = $this->service_client->get($url, $headers);
+            $datas = $response->original['data']['data'] ?? [];
+            if(empty($datas)){
+                return false;
+            }
+            $task_assignments = [];
+
+            foreach ($datas as $data) {
+                $task_assignments[] = [
+                    'pbg_task_uid' => $uuid,
+                    'user_id' => $data['user_id'],
+                    'name' => $data['name'],
+                    'username' => $data['username'],
+                    'email' => $data['email'],
+                    'phone_number' => $data['phone_number'],
+                    'role' => $data['role'],
+                    'role_name' => $data['role_name'],
+                    'is_active' => $data['is_active'],
+                    'file' => !empty($data['file']) ? json_encode($data['file']) : null, 
+                    'expertise' => !empty($data['expertise']) ? json_encode($data['expertise']) : null,
+                    'experience' => !empty($data['experience']) ? json_encode($data['experience']) : null,
+                    'is_verif' => $data['is_verif'],
+                    'uid' => $data['uid'],
+                    'status' => $data['status'],
+                    'status_name' => $data['status_name'],
+                    'note' => $data['note'],
+                    'ta_id' => $data['id'],
+                    'created_at' => now(),
+                    'updated_at' => now(),
+                ];
+            }
+            TaskAssignment::upsert(
+                $task_assignments,
+                ['uid'], 
+                ['ta_id','name', 'username', 'email', 'phone_number', 'role', 'role_name', 'is_active', 'file', 'expertise', 'experience', 'is_verif', 'status', 'status_name', 'note', 'updated_at']
+            );
+            return true;
+        }catch(Exception $e){
+            Log::error("Failed to sync task assignments", ['error' => $e->getMessage()]);
+            throw $e;
+        }
+    }
+
+    protected function convertToDecimal(?string $value): ?float
+    {
+        if (empty($value)) {
+            return null; // Return null if the input is empty
+        }
+
+        // Remove all non-numeric characters except comma and dot
+        $value = preg_replace('/[^0-9,\.]/', '', $value);
+
+        // If the number contains both dot (.) and comma (,)
+        if (strpos($value, '.') !== false && strpos($value, ',') !== false) {
+            $value = str_replace('.', '', $value); // Remove thousands separator
+            $value = str_replace(',', '.', $value); // Convert decimal separator to dot
+        }
+        // If only a dot is present (assumed as thousands separator)
+        elseif (strpos($value, '.') !== false) {
+            $value = str_replace('.', '', $value); // Remove all dots (treat as thousands separators)
+        }
+        // If only a comma is present (assumed as decimal separator)
+        elseif (strpos($value, ',') !== false) {
+            $value = str_replace(',', '.', $value); // Convert comma to dot (decimal separator)
+        }
+
+        // Ensure the value is numeric before returning
+        return is_numeric($value) ? (float) number_format((float) $value, 2, '.', '') : null;
+    }
+
+    protected function convertToInteger($value) {
+        // Check if the value is an empty string, and return null if true
+        if (trim($value) === "") {
+            return null;
+        }
+
+        $cleaned = str_replace('.','', $value);
+
+        // Otherwise, cast to integer
+        return (int) $cleaned;
+    }
+
+    protected function convertToDate($dateString)
+    {
+        try {
+            // Check if the string is empty
+            if (empty($dateString)) {
+                return null;
+            }
+
+            // Try to parse the date string
+            $date = Carbon::parse($dateString);
+
+            // Return the Carbon instance
+            return $date->format('Y-m-d');
+        } catch (Exception $e) {
+            // Return null if an error occurs during parsing
+            return null;
+        }
+    }
 }

composer.json

@@ -15,7 +15,8 @@
         "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",
@@ -56,7 +57,7 @@
         ],
         "dev": [
             "Composer\\Config::disableProcessTimeout",
-            "npx concurrently -c \"#93c5fd,#c4b5fd,#fb7185,#fdba74\" \"php artisan serve\" \"php artisan queue:listen --tries=1\" \"php artisan pail --timeout=0\" \"npm run dev\" --names=server,queue,logs,vite"
+            "npx concurrently -c \"#93c5fd,#c4b5fd,#fb7185,#fdba74\" \"php artisan serve\" \"php artisan pail --timeout=0\" \"npm run dev\" --names=server,queue,logs,vite"
         ]
     },
     "extra": {

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": "52617d098d62b15c6ce8538cc8aea775",
+    "content-hash": "41bb51871a746904ab745e4095db8b46",
     "packages": [
         {
             "name": "brick/math",
@@ -3296,6 +3296,97 @@
             ],
             "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",
@@ -3413,6 +3504,141 @@
             },
             "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",
@@ -7155,74 +7381,6 @@
             },
             "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",
@@ -9316,12 +9474,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/app.php

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

config/database.php

@@ -79,6 +79,8 @@ return [
             'engine' => null,
             'options' => extension_loaded('pdo_mysql') ? array_filter([
                 PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
+                PDO::ATTR_TIMEOUT => 40000,
+                PDO::MYSQL_ATTR_INIT_COMMAND => "SET SESSION wait_timeout=40000; SET SESSION interactive_timeout=40000;"
             ]) : [],
         ],
 

config/queue.php

@@ -112,7 +112,7 @@ return [
     // set timeout queue
 
     'worker' => [
-        'timeout' => 300
+        'timeout' => 40000
     ]
 
 ];

database/migrations/2025_02_27_163347_add_formatted_registration_number_to_pbg_task_google_sheet.php

@@ -0,0 +1,28 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+return new class extends Migration
+{
+    /**
+     * Run the migrations.
+     */
+    public function up(): void
+    {
+        Schema::table('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/migrations/2025_03_03_174851_add_some_column_in_bigdata_resumes.php

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

database/migrations/2025_03_05_211133_create_task_assignments_table.php

@@ -0,0 +1,48 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+return new class extends Migration
+{
+    /**
+     * Run the migrations.
+     */
+    public function up(): void
+    {
+        Schema::create('task_assignments', function (Blueprint $table) {
+            $table->id(); // Auto-increment primary key
+            
+            // Foreign key reference to pbg_tasks (uid column)
+            $table->string('pbg_task_uid');
+            $table->foreign('pbg_task_uid')->references('uuid')->on('pbg_task')->onDelete('cascade');
+
+            $table->unsignedBigInteger('user_id'); // Reference to users table
+            $table->string('name');
+            $table->string('username')->unique();
+            $table->string('email')->unique();
+            $table->string('phone_number')->nullable();
+            $table->unsignedInteger('role'); // Assuming role is numeric
+            $table->string('role_name');
+            $table->boolean('is_active')->default(true);
+            $table->json('file')->nullable(); // Store as JSON if 'file' is an array
+            $table->string('expertise')->nullable();
+            $table->string('experience')->nullable();
+            $table->boolean('is_verif')->default(false);
+            $table->string('uid')->unique();
+            $table->unsignedTinyInteger('status')->default(0); // Assuming status is a small integer
+            $table->string('status_name')->nullable();
+            $table->text('note')->nullable();
+            $table->timestamps();
+        });
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        Schema::dropIfExists('task_assignments');
+    }
+};

database/migrations/2025_03_07_105725_modify_expertise_experience_in_task_assignments.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('task_assignments', function (Blueprint $table) {
+            $table->json('expertise')->nullable()->change();
+            $table->json('experience')->nullable()->change();
+            $table->bigInteger('ta_id')->nullable()->after('id');
+        });
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+        Schema::table('task_assignments', function (Blueprint $table) {
+            $table->text('expertise')->nullable()->change();
+            $table->text('experience')->nullable()->change();
+            $table->dropColumn('ta_id');
+        });
+    }
+};

database/seeders/UsersRoleMenuSeeder.php

@@ -74,6 +74,13 @@ class UsersRoleMenuSeeder extends Seeder
                 "icon" => "mingcute:report-line",
                 "parent_id" => null,
                 "sort_order" => 6,
+            ],
+            [
+                "name" => "Neng Bedas",
+                "url" => "/chat",
+                "icon" => "mingcute:wechat-line",
+                "parent_id" => null,
+                "sort_order" => 7,
             ]
         ];
 
@@ -92,6 +99,7 @@ class UsersRoleMenuSeeder extends Seeder
         $dataSettings = Menu::where('name', 'Data Settings')->first();
         $data = Menu::where('name', 'Data')->first();
         $laporan = Menu::where('name', 'Laporan')->first();
+        $chat_bedas = Menu::where('name', 'Neng Bedas')->first();
 
         // create children menu
         $children_menus = [
@@ -111,7 +119,7 @@ class UsersRoleMenuSeeder extends Seeder
             ],
             [
                 "name" => "Dashboard Potensi",
-                "url" => "dashboard.lack_of_potential",
+                "url" => null,
                 "icon" => null,
                 "parent_id" => $dashboard->id,
                 "sort_order" => 3,
@@ -167,7 +175,7 @@ class UsersRoleMenuSeeder extends Seeder
             ],
             [
                 "name" => "Reklame",
-                "url" => "advertisements.index",
+                "url" => "web.advertisements.index",
                 "icon" => null,
                 "parent_id" => $data->id,
                 "sort_order" => 2,
@@ -181,21 +189,21 @@ class UsersRoleMenuSeeder extends Seeder
             ],
             [
                 "name" => "UMKM",
-                "url" => "umkm.index",
+                "url" => "web-umkm.index",
                 "icon" => null,
                 "parent_id" => $data->id,
                 "sort_order" => 4,
             ],
             [
                 "name" => "Pariwisata",
-                "url" => "tourisms.index",
+                "url" => "web-tourisms.index",
                 "icon" => null,
                 "parent_id" => $data->id,
                 "sort_order" => 5,
             ],
             [
                 "name" => "Tata Ruang",
-                "url" => "spatial-plannings.index",
+                "url" => "web-spatial-plannings.index",
                 "icon" => null,
                 "parent_id" => $data->id,
                 "sort_order" => 6,
@@ -209,7 +217,7 @@ class UsersRoleMenuSeeder extends Seeder
             ],
             [
                 "name" => "Lap Pariwisata",
-                "url" => "tourisms.index",
+                "url" => "tourisms-report.index",
                 "icon" => null,
                 "parent_id" => $laporan->id,
                 "sort_order" => 1,
@@ -221,6 +229,27 @@ class UsersRoleMenuSeeder extends Seeder
                 "parent_id" => $laporan->id,
                 "sort_order" => 2,
             ],
+            [
+                "name" => "Chat",
+                "url" => "main-chatbot.index",
+                "icon" => null,
+                "parent_id" => $chat_bedas->id,
+                "sort_order" => 1,
+            ],
+            [
+                "name" => "Dalam Sistem",
+                "url" => "dashboard.potentials.inside_system",
+                "icon" => null,
+                "parent_id" => Menu::where('name', 'Dashboard Potensi')->first()->id,
+                "sort_order" => 1,
+            ],
+            [
+                "name" => "Luar Sistem",
+                "url" => "dashboard.potentials.outside_system",
+                "icon" => null,
+                "parent_id" => Menu::where('name', 'Dashboard Potensi')->first()->id,
+                "sort_order" => 2,
+            ],
         ];
 
         foreach ($children_menus as $child_menu) {
@@ -245,6 +274,9 @@ class UsersRoleMenuSeeder extends Seeder
         $pdam = Menu::where('name', 'PDAM')->first();
         $peta = Menu::where('name', 'PETA')->first();
         $bigdata_resume = Menu::where('name', 'Lap Pimpinan')->first();
+        $chatbot = Menu::where('name', 'Chat')->first();
+        $dalam_sistem = Menu::where('name', 'Dalam Sistem')->first();
+        $luar_sistem = Menu::where('name', 'Luar Sistem')->first();
 
         // Superadmin gets all menus
         $superadmin->menus()->sync([
@@ -255,6 +287,7 @@ class UsersRoleMenuSeeder extends Seeder
             $dataSettings->id => ["allow_show" => true, "allow_create" => false, "allow_update" => false, "allow_destroy" => false],
             $data->id => ["allow_show" => true, "allow_create" => false, "allow_update" => false, "allow_destroy" => false],
             $laporan->id => ["allow_show" => true, "allow_create" => false, "allow_update" => false, "allow_destroy" => false],
+            $chat_bedas->id => ["allow_show" => true, "allow_create" => false, "allow_update" => false, "allow_destroy" => false],
             // children
             $dashboard_pimpinan->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
             $dashboard_pbg->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
@@ -272,8 +305,11 @@ class UsersRoleMenuSeeder extends Seeder
             $lack_of_potentials->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
             $spatial_plannings->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
             $pdam->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
-            $peta->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
+            // $peta->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
+            $dalam_sistem->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
+            $luar_sistem->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
             $bigdata_resume->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
+            $chatbot->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
         ]);
 
         // Admin gets limited menus

database/view_query/v_advertisements.sql

@@ -0,0 +1,21 @@
+CREATE VIEW v_advertisements AS 
+SELECT 
+    a.no,
+    a.business_name,
+    a.npwpd,
+    a.advertisement_type,
+    a.advertisement_content,
+    a.business_address,
+    a.advertisement_location,
+    v.village_name AS village_name,
+    d.district_name AS district_name,
+    a.length,
+    a.width,
+    a.viewing_angle,
+    a.face,
+    a.area,
+    a.angle,
+    a.contact
+FROM advertisements a 
+JOIN villages v ON a.village_code = v.village_code
+JOIN districts d ON a.district_code = d.district_code;

database/view_query/v_tourism_base_kbli.sql

@@ -0,0 +1,8 @@
+CREATE VIEW v_tourisms_based_kbli AS
+SELECT kbli_title, total_records
+FROM (
+    SELECT kbli, kbli_title, COUNT(*) AS total_records
+    FROM tourisms
+    GROUP BY kbli, kbli_title
+) AS subquery
+ORDER BY total_records DESC;

database/view_query/v_tourisms.sql

@@ -0,0 +1,29 @@
+CREATE VIEW v_tourisms AS 
+SELECT 
+	t.project_id,
+	t.project_type_id,
+	t.nib,
+	t.business_name,
+	t.oss_publication_date,
+	t.investment_status_description,
+	t.business_form,
+	t.project_risk,
+	t.project_name,
+	t.business_scale,
+	t.business_address,
+	v.village_name as village_name,
+	d.district_name as district_name,
+	t.longitude,
+	t.latitude,
+	t.project_submission_date,
+	t.kbli_title,
+	t.supervisory_sector,
+	t.user_name,
+	t.email,
+	t.contact,
+	t.land_area_in_m2,
+	t.investment_amount,
+	t.tki
+FROM tourisms t
+JOIN villages v on t.village_code = v.village_code
+JOIN districts d on t.district_code = d.district_code;

database/view_query/v_umkms.sql

@@ -0,0 +1,28 @@
+CREATE VIEW v_umkms AS 
+SELECT 
+	u.business_address,
+	u.business_contact,
+	u.business_desc,
+	bf.business_form,
+	u.business_id_number,
+	u.business_name,
+	bs.business_scale,
+	u.business_type,
+	u.created_at,
+	d.district_name,
+	u.land_area,
+	u.number_of_employee,
+	u.owner_address,
+	u.owner_contact,
+	u.owner_id,
+	u.owner_name,
+	ps.permit_status,
+	u.revenue,
+	u.updated_at,
+	v.village_name
+FROM umkms u 
+JOIN business_form bf on u.business_form_id  = bf.id
+JOIN permit_status ps on u.permit_status_id = ps.id
+JOIn business_scale bs on u.business_scale_id = bs.id
+JOIN villages v on u.village_code = v.village_code
+JOIN districts d on u.district_code = v.district_code;

deploy.sh

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

public/index.php

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

public/templates/contentTemplatePrompt.json

@@ -0,0 +1,11 @@
+{
+    "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.\n\n        The query should include `LIMIT 5` to restrict the results."
+    },
+    "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.\n\n        The query should include `LIMIT 5` to restrict the results."
+    },
+    "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.\n\n        The query should include `LIMIT 5` to restrict the results."
+    }
+}

public/templates/table_config.json

@@ -0,0 +1,169 @@
+{
+    "reklame": {
+        "table_name": "v_advertisements",
+        "list_column": [
+            "no",
+            "business_name",
+            "npwpd",
+            "advertisement_type",
+            "advertisement_content",
+            "business_address",
+            "advertisement_location",
+            "village_name",
+            "district_name",
+            "length",
+            "width",
+            "viewing_angle",
+            "face",
+            "area",
+            "angle",
+            "contact"
+        ]
+    },
+    "business_or_industries": {
+        "table_name": "business_or_industries",
+        "list_column": [
+            "nama_kecamatan",
+            "nama_kelurahan",
+            "nop",
+            "nama_wajib_pajak",
+            "alamat_wajib_pajak",
+            "alamat_objek_pajak",
+            "luas_bumi",
+            "luas_bangunan",
+            "njop_bumi",
+            "njop_bangunan",
+            "ketetapan",
+            "tahun_pajak",
+            "created_at",
+            "updated_at"
+        ]
+    },
+    "customers": {
+        "table_name": "customers",
+        "list_column": [
+            "nomor_pelanggan",
+            "kota_pelayanan",
+            "nama",
+            "alamat",
+            "latitude",
+            "longitude",
+            "created_at",
+            "updated_at"
+        ]
+    },
+    "pbg": {
+        "table_name": "pbg_task",
+        "list_column": [
+            "uuid",
+            "name",
+            "owner_name",
+            "application_type",
+            "application_type_name",
+            "condition",
+            "registration_number",
+            "document_number",
+            "address",
+            "status_name",
+            "slf_status_name",
+            "function_type",
+            "consultation_type",
+            "due_date",
+            "land_certificate_phase",
+            "created_at",
+            "updated_at",
+            "task_created_at"
+        ]
+    },
+    "retribusi": {
+        "table_name": "v_pbg_task_with_retributions",
+        "list_column": [
+            "uuid",
+            "name",
+            "owner_name",
+            "application_type",
+            "application_type_name",
+            "condition",
+            "registration_number",
+            "document_number",
+            "address",
+            "status_name",
+            "slf_status_name",
+            "consultation_type",
+            "due_date",
+            "land_certificate_phase",
+            "created_at",
+            "updated_at",
+            "task_created_at",
+            "nilai_retribusi_bangunan"
+        ]
+    },
+    "spatial_plannings": {
+        "table_name": "spatial_plannings",
+        "list_column": [
+            "created_at",
+            "updated_at",
+            "name",
+            "kbli",
+            "activities",
+            "area",
+            "location",
+            "number",
+            "date"
+        ]
+    },
+    "tourisms": {
+        "table_name": "v_tourisms",
+        "list_column": [
+            "project_id",
+            "project_type_id",
+            "nib",
+            "business_name",
+            "oss_publication_date",
+            "investment_status_description",
+            "business_form",
+            "project_risk",
+            "project_name",
+            "business_scale",
+            "business_address",
+            "village_name",
+            "district_name",
+            "longitude",
+            "latitude",
+            "project_submission_date",
+            "kbli_title",
+            "supervisory_sector",
+            "user_name",
+            "email",
+            "contact",
+            "land_area_in_m2",
+            "investment_amount",
+            "tki"
+        ]
+    },
+    "umkms": {
+        "table_name": "v_umkms",
+        "list_column": [
+            "business_address",
+            "business_contact",
+            "business_desc",
+            "business_form",
+            "business_id_number",
+            "business_name",
+            "business_scale",
+            "business_type",
+            "created_at",
+            "district_name",
+            "land_area",
+            "number_of_employee",
+            "owner_address",
+            "owner_contact",
+            "owner_id",
+            "owner_name",
+            "permit_status",
+            "revenue",
+            "updated_at",
+            "village_name"
+        ]
+    }
+}

resources/js/bigdata-resumes/index.js

@@ -2,7 +2,6 @@ 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 {
@@ -13,46 +12,46 @@ class BigdataResume {
         this.table = null;
 
         // Initialize functions
-        this.initTableDataSettings();
-        // this.initEvents();
+        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);
-            }
-        });
+    async initEvents() {
+        await this.initBigdataResumeTable();
+        // this.handleSearch();
     }
 
-    initTableDataSettings() {
+    async initBigdataResumeTable() {
         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: "Jumlah Potensi" },
+                { name: "Total Potensi" },
+                { name: "Jumlah Berkas Belum Terverifikasi" },
+                { name: "Total Berkas Belum Terverifikasi" },
+                { name: "Jumlah Berkas Terverifikasi" },
+                { name: "Total Berkas Terverifikasi" },
+                { name: "Jumlah Usaha" },
+                { name: "Total Usaha" },
+                { name: "Jumlah Non Usaha" },
+                { name: "Total Non Usaha" },
+                { name: "Jumlah Tata Ruang" },
+                { name: "Total Tata Ruang" },
+                { name: "Jumlah Menunggu Klik DPMPTSP" },
+                { name: "Total Menunggu Klik DPMPTSP" },
+                { name: "Jumlah Realisasi Terbit PBG" },
+                { name: "Total Realisasi Terbit PBG" },
+                { name: "Jumlah Proses Dinas Teknis" },
+                { name: "Total Proses Dinas Teknis" },
                 {
                     name: "Created",
-                    attributes: { style: "width: 200px; white-space: nowrap;" }, // Set width dynamically
+                    attributes: {
+                        style: "width: 200px; white-space: nowrap;",
+                    },
                 },
             ],
             pagination: {
-                limit: 15,
+                limit: 50,
                 server: {
                     url: (prev, page) =>
                         `${prev}${prev.includes("?") ? "&" : "?"}page=${
@@ -65,6 +64,7 @@ class BigdataResume {
                 server: {
                     url: (prev, keyword) => `${prev}?search=${keyword}`,
                 },
+                debounceTimeout: 1000,
             },
             server: {
                 url: `${GlobalConfig.apiHost}/api/bigdata-report`,
@@ -74,8 +74,8 @@ class BigdataResume {
                         .getAttribute("content")}`,
                     "Content-Type": "application/json",
                 },
-                then: (data) =>
-                    data.data.map((item) => [
+                then: (data) => {
+                    return data.data.map((item) => [
                         item.id,
                         item.potention_count,
                         addThousandSeparators(item.potention_sum),
@@ -89,64 +89,88 @@ class BigdataResume {
                         addThousandSeparators(item.non_business_sum),
                         item.spatial_count,
                         addThousandSeparators(item.spatial_sum),
+                        item.waiting_click_dpmptsp_count,
+                        addThousandSeparators(item.waiting_click_dpmptsp_sum),
+                        item.issuance_realization_pbg_count,
+                        addThousandSeparators(
+                            item.issuance_realization_pbg_sum
+                        ),
+                        item.process_in_technical_office_count,
+                        addThousandSeparators(
+                            item.process_in_technical_office_sum
+                        ),
                         moment(item.created_at).format("YYYY-MM-DD H:mm:ss"),
-                    ]),
+                    ]);
+                },
                 total: (data) => data.total,
             },
-        }).render(tableContainer);
-    }
-    async handleDelete(deleteButton) {
-        const id = deleteButton.getAttribute("data-id");
-
-        const result = await Swal.fire({
-            title: "Are you sure?",
-            text: "You won't be able to revert this!",
-            icon: "warning",
-            showCancelButton: true,
-            confirmButtonColor: "#3085d6",
-            cancelButtonColor: "#d33",
-            confirmButtonText: "Yes, delete it!",
+            width: "auto",
+            fixedHeader: true,
         });
 
-        if (result.isConfirmed) {
-            try {
-                let response = await fetch(
-                    `${GlobalConfig.apiHost}/api/data-settings/${id}`,
-                    {
-                        method: "DELETE",
-                        credentials: "include",
+        return new Promise((resolve) => {
+            this.table.render(tableContainer);
+            this.table.on("ready", resolve); // Tunggu event "ready"
+        });
+    }
+
+    handleSearch() {
+        document.getElementById("search-btn").addEventListener("click", () => {
+            let searchValue = document.getElementById("search-box").value;
+
+            if (!this.table) {
+                // Ensure table is initialized
+                console.error("Table element not found!");
+                return;
+            }
+
+            this.table
+                .updateConfig({
+                    server: {
+                        url: `${GlobalConfig.apiHost}/api/bigdata-report?search=${searchValue}`,
                         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();
-            }
-        }
+                        then: (data) => {
+                            return data.data.map((item) => [
+                                item.id,
+                                item.potention_count,
+                                addThousandSeparators(item.potention_sum),
+                                item.non_verified_count,
+                                addThousandSeparators(item.non_verified_sum),
+                                item.verified_count,
+                                addThousandSeparators(item.verified_sum),
+                                item.business_count,
+                                addThousandSeparators(item.business_sum),
+                                item.non_business_count,
+                                addThousandSeparators(item.non_business_sum),
+                                item.spatial_count,
+                                addThousandSeparators(item.spatial_sum),
+                                item.waiting_click_dpmptsp_count,
+                                addThousandSeparators(
+                                    item.waiting_click_dpmptsp_sum
+                                ),
+                                item.issuance_realization_pbg_count,
+                                addThousandSeparators(
+                                    item.issuance_realization_pbg_sum
+                                ),
+                                item.process_in_technical_office_count,
+                                addThousandSeparators(
+                                    item.process_in_technical_office_sum
+                                ),
+                                moment(item.created_at).format(
+                                    "YYYY-MM-DD H:mm:ss"
+                                ),
+                            ]);
+                        },
+                        total: (data) => data.total,
+                    },
+                })
+                .forceRender();
+        });
     }
 }
 document.addEventListener("DOMContentLoaded", function (e) {

resources/js/business-industries/index.js

@@ -64,7 +64,7 @@ class BusinessIndustries {
                 },
             ],
             pagination: {
-                limit: 15,
+                limit: 50,
                 server: {
                     url: (prev, page) =>
                         `${prev}${prev.includes("?") ? "&" : "?"}page=${
@@ -77,6 +77,7 @@ class BusinessIndustries {
                 server: {
                     url: (prev, keyword) => `${prev}?search=${keyword}`,
                 },
+                debounceTimeout: 1000,
             },
             server: {
                 url: `${GlobalConfig.apiHost}/api/api-business-industries`,

resources/js/chatbot-pimpinan/index.js

@@ -0,0 +1,155 @@
+import GlobalConfig from "../global-config.js";
+
+document.addEventListener("DOMContentLoaded", function () {
+    const timeElements = document.querySelectorAll(".sending-message-time p");
+
+    timeElements.forEach((element) => {
+        element.textContent = getCurrentTime();
+    });
+
+    const textarea = document.getElementById("user-message");
+    const sendButton = document.getElementById("send");
+    const conversationArea = document.querySelector(".row.flex-grow");
+    const chatHistory = [];
+
+    // Fungsi untuk mengirim pesan
+    async function sendMessage() {
+        const userText = textarea.value.trim();
+        if (userText !== "") {
+            // Kosongkan textarea setelah mengirim
+            textarea.value = "";
+
+            // Tambahkan pesan user ke UI
+            addMessage(userText, "user");
+
+            // Tambahkan pesan bot sementara dengan "Loading..."
+            const botMessageElement = addMessage('<div class="bot-message-text">...</div>', "bot");
+
+            const messageTextContainer = botMessageElement.querySelector(".bot-message-text");
+            if (messageTextContainer) {
+                messageTextContainer.innerHTML = '<div class="loader ms-3"></div>';
+            }
+
+            // Panggil API untuk mendapatkan respons dari bot
+            const botResponse = await getBotResponse(userText, chatHistory);
+
+            // Perbarui pesan bot dengan respons yang sebenarnya
+            if (messageTextContainer) {
+                messageTextContainer.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 getCurrentTime() {
+        const now = new Date();
+        return now.getHours().toString().padStart(2, "0") + ":" + now.getMinutes().toString().padStart(2, "0");
+    }
+
+    function addMessage(text, sender) {
+        const messageRow = document.createElement("div");
+        // Atur posisi berdasarkan sender (user -> end, bot -> start)
+        messageRow.classList.add("row", "flex-grow", "overflow-auto", sender === "user" ? "justify-content-end" : "justify-content-start");
+    
+        const messageCol = document.createElement("div");
+        messageCol.classList.add("col-9", "w-auto");
+    
+        // Atur lebar maksimum berdasarkan sender
+        messageCol.style.maxWidth = sender === "user" ? "50%" : "75%";
+    
+        // Container untuk menyimpan nama dan bubble chat
+        const messageWrapper = document.createElement("div");
+        messageWrapper.classList.add("d-flex", "flex-column");
+    
+        // Tambahkan Nama di luar bubble chat
+        const messageName = document.createElement("p");
+        messageName.classList.add("fw-bolder", sender === "user" ? "text-end" : "text-start", "mb-1");
+        messageName.textContent = sender === "user" ? "You" : "Neng Bedas";
+    
+        // Bubble Chat
+        const messageContainer = document.createElement("div");
+        messageContainer.classList.add("p-2", "rounded", "mb-2", "d-inline-block");
+        if (sender === "user") {
+            messageContainer.classList.add("user-response", "bg-primary", "text-white");
+        } else {
+            messageContainer.classList.add("bot-response", "bg-light");
+        }
+    
+        const messageContent = document.createElement("div");
+        messageContent.classList.add("bot-message-text", "mb-0", "text-start");
+        messageContent.textContent = text;
+    
+        // Waktu di dalam bubble chat
+        const messageTime = document.createElement("div");
+        messageTime.classList.add("sending-message-time", "text-end", "mt-1");
+        messageTime.innerHTML = `<p class="small mb-0 ${sender === "user" ? "text-white text-start" : "text-muted"}">${getCurrentTime()}</p>`;
+    
+        messageContainer.appendChild(messageContent);
+        messageContainer.appendChild(messageTime);
+    
+        // Jika pengirim adalah bot, tambahkan avatar
+        if (sender !== "user") {
+            const avatarContainer = document.createElement("div");
+            avatarContainer.classList.add("col-auto", "pe-0");
+    
+            const avatarImg = document.createElement("img");
+            avatarImg.classList.add("rounded-circle");
+            avatarImg.width = 45;
+            avatarImg.src = "/images/iconchatbot.jpeg";
+            avatarImg.alt = "bot-avatar";
+    
+            avatarContainer.appendChild(avatarImg);
+            messageRow.appendChild(avatarContainer);
+        }
+    
+        // Masukkan nama dan bubble ke dalam wrapper
+        messageWrapper.appendChild(messageName);
+        messageWrapper.appendChild(messageContainer);
+        messageCol.appendChild(messageWrapper);
+        messageRow.appendChild(messageCol);
+    
+        conversationArea.appendChild(messageRow);
+        conversationArea.scrollTop = conversationArea.scrollHeight;
+    
+        return messageContainer;
+    } 
+
+    // Fungsi untuk memanggil API
+    async function getBotResponse(userText, historyChat) {
+        try {
+            const url = `${GlobalConfig.apiHost}/api/main-generate-text`;
+            const response = await fetch(url, {
+                method: "POST",
+                body: JSON.stringify({prompt: userText,  chatHistory: historyChat}),
+                headers: {
+                    Authorization: `Bearer ${document
+                        .querySelector('meta[name="api-token"]')
+                        .getAttribute("content")}`,
+                    "Content-Type": "application/json",
+                },
+            });
+
+            const data = await response.json();
+            const rawBotResponse = data.nlpResponse;
+            // Tambahkan ke chatHistory
+            chatHistory.push({
+                user: userText,
+                rawBotResponse: rawBotResponse,
+            });
+            return data.response || "Maaf, saya tidak mengerti.";
+        } catch (error) {
+            console.error("Error fetching bot response:", error);
+            return "Terjadi kesalahan, coba lagi nanti.";
+        }
+    }
+});

resources/js/chatbot/index.js

@@ -0,0 +1,218 @@
+import GlobalConfig from "../global-config.js";
+
+document.addEventListener("DOMContentLoaded", function () {
+    const tabs = document.querySelectorAll(".nav-link");
+    const timeElements = document.querySelectorAll(".sending-message-time p");
+
+    timeElements.forEach((element) => {
+        element.textContent = getCurrentTime();
+    });
+
+    function activateTab(tab) {
+        tabs.forEach(btn => {
+            btn.classList.remove("border-3", "bg-primary", "text-white"); // Reset semua tab
+        });
+        tab.classList.add("border-3", "bg-primary", "text-white"); // Tambahkan warna pada tab aktif
+    }
+
+    tabs.forEach(tab => {
+        tab.addEventListener("click", function () {
+            activateTab(this);
+        });
+    });
+
+    // Set warna awal untuk tab aktif (jika ada)
+    const initialActiveTab = document.querySelector(".nav-link.active");
+    if (initialActiveTab) {
+        activateTab(initialActiveTab);
+    }
+
+    document.querySelectorAll(".nav-link").forEach(tab => {
+        tab.addEventListener("click", function () {
+            setTimeout(() => {
+                const tab_active = getActiveTabId();
+                console.log("Active Tab ID:", tab_active);
+
+                // Hapus semua chat kecuali pesan default bot
+                conversationArea.innerHTML = `
+                <div class="row flex-grow overflow-auto align-items-start">
+                    <!-- Avatar -->
+                    <div class="col-auto alignpe-0">
+                        <img class="rounded-circle" width="45" src="/images/iconchatbot.jpeg" alt="avatar-3">
+                    </div>
+
+                    <!-- Nama dan Bubble Chat -->
+                    <div class="col-9 w-auto">
+                        <!-- Nama Bot -->
+                        <p class="fw-bolder mb-1">Neng Bedas</p>
+
+                        <!-- Bubble Chat -->
+                        <div class="bot-response p-2 bg-light rounded mb-2 d-inline-block">
+                            <p class="mb-0">Halo! Ada yang bisa saya bantu?</p>
+
+                            <!-- Waktu (Tetap di Dalam Bubble Chat) -->
+                            <div class="sending-message-time text-end mt-1">
+                                <p class="text-muted small mb-0">Now</p>
+                            </div>
+                        </div>
+                    </div>
+                </div>
+            `;
+            }, 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");
+    const chatHistory = [];
+
+    // 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="bot-message-text">...</div>', "bot");
+
+            const messageTextContainer = botMessageElement.querySelector(".bot-message-text");
+            if (messageTextContainer) {
+                messageTextContainer.innerHTML = '<div class="loader ms-3"></div>';
+            }
+
+            // Panggil API untuk mendapatkan respons dari bot
+            const botResponse = await getBotResponse(currentTab, userText, chatHistory);
+
+            // Perbarui pesan bot dengan respons yang sebenarnya
+            if (messageTextContainer) {
+                messageTextContainer.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 getCurrentTime() {
+        const now = new Date();
+        return now.getHours().toString().padStart(2, "0") + ":" + now.getMinutes().toString().padStart(2, "0");
+    }
+    
+    function addMessage(text, sender) {
+        const messageRow = document.createElement("div");
+        // Atur posisi berdasarkan sender (user -> end, bot -> start)
+        messageRow.classList.add("row", "flex-grow", "overflow-auto", sender === "user" ? "justify-content-end" : "justify-content-start");
+    
+        const messageCol = document.createElement("div");
+        messageCol.classList.add("col-9", "w-auto");
+    
+        // Atur lebar maksimum berdasarkan sender
+        messageCol.style.maxWidth = sender === "user" ? "50%" : "75%";
+    
+        // Container untuk menyimpan nama dan bubble chat
+        const messageWrapper = document.createElement("div");
+        messageWrapper.classList.add("d-flex", "flex-column");
+    
+        // Tambahkan Nama di luar bubble chat
+        const messageName = document.createElement("p");
+        messageName.classList.add("fw-bolder", sender === "user" ? "text-end" : "text-start", "mb-1");
+        messageName.textContent = sender === "user" ? "You" : "Neng Bedas";
+    
+        // Bubble Chat
+        const messageContainer = document.createElement("div");
+        messageContainer.classList.add("p-2", "rounded", "mb-2", "d-inline-block");
+        if (sender === "user") {
+            messageContainer.classList.add("user-response", "bg-primary", "text-white");
+        } else {
+            messageContainer.classList.add("bot-response", "bg-light");
+        }
+    
+        const messageContent = document.createElement("div");
+        messageContent.classList.add("bot-message-text", "mb-0", "text-start");
+        messageContent.textContent = text;
+    
+        // Waktu di dalam bubble chat
+        const messageTime = document.createElement("div");
+        messageTime.classList.add("sending-message-time", "text-end", "mt-1");
+        messageTime.innerHTML = `<p class="small mb-0 ${sender === "user" ? "text-white text-start" : "text-muted"}">${getCurrentTime()}</p>`;
+    
+        messageContainer.appendChild(messageContent);
+        messageContainer.appendChild(messageTime);
+    
+        // Jika pengirim adalah bot, tambahkan avatar
+        if (sender !== "user") {
+            const avatarContainer = document.createElement("div");
+            avatarContainer.classList.add("col-auto", "pe-0");
+    
+            const avatarImg = document.createElement("img");
+            avatarImg.classList.add("rounded-circle");
+            avatarImg.width = 45;
+            avatarImg.src = "/images/iconchatbot.jpeg";
+            avatarImg.alt = "bot-avatar";
+    
+            avatarContainer.appendChild(avatarImg);
+            messageRow.appendChild(avatarContainer);
+        }
+    
+        // Masukkan nama dan bubble ke dalam wrapper
+        messageWrapper.appendChild(messageName);
+        messageWrapper.appendChild(messageContainer);
+        messageCol.appendChild(messageWrapper);
+        messageRow.appendChild(messageCol);
+    
+        conversationArea.appendChild(messageRow);
+        conversationArea.scrollTop = conversationArea.scrollHeight;
+    
+        return messageContainer;
+    }    
+
+    // Fungsi untuk memanggil API
+    async function getBotResponse(tab_active, userText, historyChat) {
+        try {
+            const url = `${GlobalConfig.apiHost}/api/generate-text`;
+            const response = await fetch(url, {
+                method: "POST",
+                body: JSON.stringify({tab_active:tab_active, prompt: userText, chatHistory: historyChat }),
+                headers: {
+                    Authorization: `Bearer ${document
+                        .querySelector('meta[name="api-token"]')
+                        .getAttribute("content")}`,
+                    "Content-Type": "application/json",
+                },
+            });
+
+            const data = await response.json();
+            const rawBotResponse = data.nlpResponse;
+            // Tambahkan ke chatHistory
+            chatHistory.push({
+                user: userText,
+                rawBotResponse: rawBotResponse,
+            });
+            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/customers/index.js

@@ -53,7 +53,7 @@ class Customers {
                 },
             ],
             pagination: {
-                limit: 15,
+                limit: 50,
                 server: {
                     url: (prev, page) =>
                         `${prev}${prev.includes("?") ? "&" : "?"}page=${
@@ -66,6 +66,7 @@ class Customers {
                 server: {
                     url: (prev, keyword) => `${prev}?search=${keyword}`,
                 },
+                debounceTimeout: 1000,
             },
             server: {
                 url: `${GlobalConfig.apiHost}/api/customers`,
@@ -91,6 +92,8 @@ class Customers {
         }).render(tableContainer);
     }
 
+    handleSearch() {}
+
     async handleDelete(deleteButton) {
         const id = deleteButton.getAttribute("data-id");
 

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

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

resources/js/dashboards/potentials/inside_system.js

@@ -0,0 +1,194 @@
+import Big from "big.js";
+import GlobalConfig, { addThousandSeparators } from "../../global-config.js";
+import InitDatePicker from "../../utils/InitDatePicker.js";
+
+class DashboardPotentialInsideSystem {
+    async init() {
+        new InitDatePicker(
+            "#datepicker-lack-of-potential",
+            this.handleChangedDate.bind(this)
+        ).init();
+        this.bigTotalLackPotential = 0;
+        this.totalPotensi = await this.getDataTotalPotensi("latest");
+        this.totalTargetPAD = await this.getDataSettings("TARGET_PAD");
+        this.allCountData = await this.getValueDashboard();
+        this.reklameCount = this.allCountData.total_reklame ?? 0;
+        this.pdamCount = this.allCountData.total_pdam ?? 0;
+        this.tataRuangCount = this.allCountData.total_tata_ruang ?? 0;
+
+        let dataReportTourism = this.allCountData.data_report;
+
+        this.totalVilla = dataReportTourism
+            .filter((item) => item.kbli_title.toLowerCase() === "vila")
+            .reduce((sum, item) => sum + item.total_records, 0);
+        this.totalRestoran = dataReportTourism
+            .filter((item) => item.kbli_title.toLowerCase() === "restoran")
+            .reduce((sum, item) => sum + item.total_records, 0);
+        this.totalPariwisata = dataReportTourism.reduce(
+            (sum, item) => sum + item.total_records,
+            0
+        );
+
+        this.bigTargetPAD = new Big(this.totalTargetPAD ?? 0);
+        this.bigTotalPotensi = new Big(this.totalPotensi.total ?? 0);
+        this.bigTotalLackPotential = this.bigTargetPAD.minus(
+            this.bigTotalPotensi
+        );
+        this.initChartKekuranganPotensi();
+        this.initDataValueDashboard();
+    }
+    async handleChangedDate(filterDate) {
+        const totalPotensi = await this.getDataTotalPotensi(filterDate);
+        this.bigTotalPotensi = new Big(totalPotensi.total ?? 0);
+        this.bigTotalLackPotential = this.bigTargetPAD.minus(
+            this.bigTotalPotensi
+        );
+
+        this.initChartKekuranganPotensi();
+    }
+    async getDataTotalPotensi(filterDate) {
+        try {
+            const response = await fetch(
+                `${GlobalConfig.apiHost}/api/bigdata-resume?filterByDate=${filterDate}`,
+                {
+                    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 {
+                total: data.total_potensi.sum,
+            };
+        } catch (error) {
+            console.error("Error fetching chart data:", error);
+            return null;
+        }
+    }
+    async getDataSettings(string_key) {
+        try {
+            const response = await fetch(
+                `${GlobalConfig.apiHost}/api/data-settings?search=${string_key}`,
+                {
+                    credentials: "include",
+                    headers: {
+                        Authorization: `Bearer ${
+                            document.querySelector("meta[name='api-token']")
+                                .content
+                        }`,
+                        "Content-Type": "application/json",
+                    },
+                }
+            );
+
+            if (!response.ok) {
+                console.error("Network response was not ok", response);
+            }
+
+            const data = await response.json();
+            return data.data[0].value;
+        } catch (error) {
+            console.error("Error fetching chart data:", error);
+            return 0;
+        }
+    }
+    async getValueDashboard() {
+        try {
+            const response = await fetch(
+                `${GlobalConfig.apiHost}/api/dashboard-potential-count`,
+                {
+                    credentials: "include",
+                    headers: {
+                        Authorization: `Bearer ${
+                            document.querySelector("meta[name='api-token']")
+                                .content
+                        }`,
+                        "Content-Type": "application/json",
+                    },
+                }
+            );
+
+            if (!response.ok) {
+                console.error("Network response was not ok", response);
+            }
+
+            const data = await response.json();
+            return data;
+        } catch (error) {
+            console.error("Error fetching chart data:", error);
+            return 0;
+        }
+    }
+    initChartKekuranganPotensi() {
+        document
+            .querySelectorAll(".document-count.chart-lack-of-potential")
+            .forEach((element) => {
+                element.innerText = ``;
+            });
+        document
+            .querySelectorAll(".document-total.chart-lack-of-potential")
+            .forEach((element) => {
+                element.innerText = `Rp.${addThousandSeparators(
+                    this.bigTotalLackPotential.toString()
+                )}`;
+            });
+        document
+            .querySelectorAll(".small-percentage.chart-lack-of-potential")
+            .forEach((element) => {
+                element.innerText = ``;
+            });
+    }
+    initDataValueDashboard() {
+        document.getElementById("reklame-count").innerText = this.reklameCount;
+        document.getElementById("pdam-count").innerText = this.pdamCount;
+        document.getElementById("pbb-bangunan-count").innerText =
+            this.tataRuangCount;
+        document.getElementById("tata-ruang-count").innerText =
+            this.tataRuangCount;
+        document.getElementById("tata-ruang-usaha-count").innerText =
+            this.tataRuangCount;
+        document.getElementById("restoran-count").innerText =
+            this.totalRestoran;
+        document.getElementById("villa-count").innerText = this.totalVilla;
+        document.getElementById("pariwisata-count").innerText =
+            this.totalPariwisata;
+    }
+}
+document.addEventListener("DOMContentLoaded", async function (e) {
+    await new DashboardPotentialInsideSystem().init();
+});
+
+function resizeDashboard() {
+    let targetElement = document.getElementById("lack-of-potential-wrapper");
+    let dashboardElement = document.getElementById(
+        "lack-of-potential-fixed-container"
+    );
+
+    let targetWidth = targetElement.offsetWidth;
+    let dashboardWidth = 1400;
+
+    let scaleFactor = (targetWidth / dashboardWidth).toFixed(2);
+
+    // Prevent scaling beyond 1 (100%) to avoid overflow
+    scaleFactor = Math.min(scaleFactor, 1);
+
+    dashboardElement.style.transformOrigin = "left top";
+    dashboardElement.style.transition = "transform 0.2s ease-in-out";
+    dashboardElement.style.transform = `scale(${scaleFactor})`;
+
+    // Ensure horizontal scrolling is allowed if necessary
+    document.body.style.overflowX = "auto";
+}
+
+window.addEventListener("load", resizeDashboard);
+window.addEventListener("resize", resizeDashboard);

resources/js/dashboards/potentials/outside_system.js

@@ -0,0 +1,121 @@
+import InitDatePicker from "../../utils/InitDatePicker.js";
+import GlobalConfig, { addThousandSeparators } from "../../global-config.js";
+
+class DashboardPotentialOutsideSystem {
+    async init() {
+        new InitDatePicker(
+            "#datepicker-outside-system",
+            this.handleChangedDate.bind(this)
+        ).init();
+        this.bigTotalLackPotential = 0;
+        this.dataResume = await this.getBigDataResume("latest");
+        console.log(this.dataResume);
+        this.initChartNonBusiness();
+        this.initChartBusiness();
+    }
+    async handleChangedDate(filterDate) {
+        this.dataResume = await this.getBigDataResume(filterDate);
+        this.initChartNonBusiness();
+        this.initChartBusiness();
+    }
+    async getBigDataResume(filterDate) {
+        try {
+            const response = await fetch(
+                `${GlobalConfig.apiHost}/api/bigdata-resume?filterByDate=${filterDate}`,
+                {
+                    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);
+            }
+
+            return await response.json();
+        } catch (error) {
+            console.error("Error fetching chart data:", error);
+            return null;
+        }
+    }
+
+    initChartNonBusiness() {
+        const nonBusinessDoc = this.dataResume?.non_business_document ?? {};
+
+        document
+            .querySelectorAll(".document-count.outside-system-non-business")
+            .forEach((element) => {
+                element.innerText = `${nonBusinessDoc.count ?? 0}`;
+            });
+
+        document
+            .querySelectorAll(".document-total.outside-system-non-business")
+            .forEach((element) => {
+                element.innerText = `Rp.${addThousandSeparators(
+                    (nonBusinessDoc.sum ?? 0).toString()
+                )}`;
+            });
+
+        document
+            .querySelectorAll(".small-percentage.outside-system-non-business")
+            .forEach((element) => {
+                element.innerText = `${nonBusinessDoc.percentage ?? 0}%`;
+            });
+    }
+    initChartBusiness() {
+        const businessDoc = this.dataResume?.business_document ?? {};
+
+        document
+            .querySelectorAll(".document-count.outside-system-business")
+            .forEach((element) => {
+                element.innerText = `${businessDoc.count ?? 0}`;
+            });
+
+        document
+            .querySelectorAll(".document-total.outside-system-business")
+            .forEach((element) => {
+                element.innerText = `Rp.${addThousandSeparators(
+                    (businessDoc.sum ?? 0).toString()
+                )}`;
+            });
+
+        document
+            .querySelectorAll(".small-percentage.outside-system-business")
+            .forEach((element) => {
+                element.innerText = `${businessDoc.percentage ?? 0}%`;
+            });
+    }
+}
+document.addEventListener("DOMContentLoaded", async function (e) {
+    await new DashboardPotentialOutsideSystem().init();
+});
+function resizeDashboard() {
+    let targetElement = document.getElementById("outside-system-wrapper");
+    let dashboardElement = document.getElementById(
+        "outside-system-fixed-container"
+    );
+
+    let targetWidth = targetElement.offsetWidth;
+    let dashboardWidth = 1400;
+
+    let scaleFactor = (targetWidth / dashboardWidth).toFixed(2);
+
+    // Prevent scaling beyond 1 (100%) to avoid overflow
+    scaleFactor = Math.min(scaleFactor, 1);
+
+    dashboardElement.style.transformOrigin = "left top";
+    dashboardElement.style.transition = "transform 0.2s ease-in-out";
+    dashboardElement.style.transform = `scale(${scaleFactor})`;
+
+    // Ensure horizontal scrolling is allowed if necessary
+    document.body.style.overflowX = "auto";
+}
+
+window.addEventListener("load", resizeDashboard);
+window.addEventListener("resize", resizeDashboard);

resources/js/data-settings/index.js

@@ -67,6 +67,7 @@ class DataSettings {
                 server: {
                     url: (prev, keyword) => `${prev}?search=${keyword}`,
                 },
+                debounceTimeout: 1000,
             },
             server: {
                 url: `${GlobalConfig.apiHost}/api/data-settings`,

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

@@ -3,7 +3,7 @@ import GlobalConfig from "../../global-config";
 document.addEventListener("DOMContentLoaded", function () {
     const saveButton = document.querySelector(".modal-footer .btn-primary");
     const modalButton = document.querySelector(".btn-modal");
-    const form = document.querySelector("form#create-update-form"); 
+    const form = document.querySelector("form#create-update-form");
     var authLogo = document.querySelector(".auth-logo");
 
     if (!saveButton || !form) return;
@@ -16,10 +16,10 @@ document.addEventListener("DOMContentLoaded", function () {
             Loading...
         `;
         const isEdit = saveButton.classList.contains("btn-edit");
-        const formData = new FormData(form)
-        const toast = document.getElementById('toastEditUpdate');
-        const toastBody = toast.querySelector('.toast-body');
-        const toastHeader = toast.querySelector('.toast-header small');
+        const formData = new FormData(form);
+        const toast = document.getElementById("toastEditUpdate");
+        const toastBody = toast.querySelector(".toast-body");
+        const toastHeader = toast.querySelector(".toast-header small");
 
         const data = {};
 
@@ -27,9 +27,9 @@ document.addEventListener("DOMContentLoaded", function () {
         formData.forEach((value, key) => {
             data[key] = value;
         });
-        
+
         const url = form.getAttribute("action");
-        
+
         const method = isEdit ? "PUT" : "POST";
 
         fetch(url, {
@@ -40,99 +40,103 @@ document.addEventListener("DOMContentLoaded", function () {
                     .querySelector('meta[name="api-token"]')
                     .getAttribute("content")}`,
                 "Content-Type": "application/json",
-            }
+            },
         })
-        .then(response => response.json())
-        .then(data => {
-            if (!data.errors) {
-                // Remove existing icon (if any) before adding the new one
-                if (authLogo) {
-                    // Hapus ikon yang sudah ada jika ada
-                    const existingIcon = authLogo.querySelector('.bx');
-                    if (existingIcon) {
-                        authLogo.removeChild(existingIcon);
-                    }
-                
-                    // Buat ikon baru
-                    const icon = document.createElement('i');
-                    icon.classList.add('bx', 'bxs-check-square');
-                    icon.style.fontSize = '25px';
-                    icon.style.color = 'green'; // Pastikan 'green' dalam bentuk string
-                
-                    // Tambahkan ikon ke dalam auth-logo
-                    authLogo.appendChild(icon);
-                }
-                
-                // Set success message for the toast
-                toastBody.textContent = isEdit ? "Data updated successfully!" : "Data created successfully!";
-                toast.classList.add('show');  // Show the toast
-                setTimeout(() => {
-                    toast.classList.remove('show');  // Hide the toast after 3 seconds
-                }, 2000);
-                
-                setTimeout(() => {
-                    window.location.href = '/data/advertisements';
-                }, 1000);
-            } else {
-                if (authLogo) {
-                    // Hapus ikon yang sudah ada jika ada
-                    const existingIcon = authLogo.querySelector('.bx');
-                    if (existingIcon) {
-                        authLogo.removeChild(existingIcon);
-                    }
-                
-                    // Buat ikon baru
-                    const icon = document.createElement('i');
-                    icon.classList.add('bx', 'bxs-error-alt');
-                    icon.style.fontSize = '25px';
-                    icon.style.color = 'red'; // Pastikan 'green' dalam bentuk string
-                
-                    // Tambahkan ikon ke dalam auth-logo
-                    authLogo.appendChild(icon);
-                }
+            .then((response) => response.json())
+            .then((data) => {
+                if (!data.errors) {
+                    // Remove existing icon (if any) before adding the new one
+                    if (authLogo) {
+                        // Hapus ikon yang sudah ada jika ada
+                        const existingIcon = authLogo.querySelector(".bx");
+                        if (existingIcon) {
+                            authLogo.removeChild(existingIcon);
+                        }
 
+                        // Buat ikon baru
+                        const icon = document.createElement("i");
+                        icon.classList.add("bx", "bxs-check-square");
+                        icon.style.fontSize = "25px";
+                        icon.style.color = "green"; // Pastikan 'green' dalam bentuk string
+
+                        // Tambahkan ikon ke dalam auth-logo
+                        authLogo.appendChild(icon);
+                    }
+
+                    // Set success message for the toast
+                    toastBody.textContent = isEdit
+                        ? "Data updated successfully!"
+                        : "Data created successfully!";
+                    toast.classList.add("show"); // Show the toast
+                    setTimeout(() => {
+                        toast.classList.remove("show"); // Hide the toast after 3 seconds
+                    }, 2000);
+
+                    setTimeout(() => {
+                        window.location.href = "/data/web-advertisements";
+                    }, 1000);
+                } else {
+                    if (authLogo) {
+                        // Hapus ikon yang sudah ada jika ada
+                        const existingIcon = authLogo.querySelector(".bx");
+                        if (existingIcon) {
+                            authLogo.removeChild(existingIcon);
+                        }
+
+                        // Buat ikon baru
+                        const icon = document.createElement("i");
+                        icon.classList.add("bx", "bxs-error-alt");
+                        icon.style.fontSize = "25px";
+                        icon.style.color = "red"; // Pastikan 'green' dalam bentuk string
+
+                        // Tambahkan ikon ke dalam auth-logo
+                        authLogo.appendChild(icon);
+                    }
+
+                    // Enable button and reset its text on error
+                    modalButton.disabled = false;
+                    modalButton.innerHTML = isEdit ? "Update" : "Create";
+
+                    // Set error message for the toast
+                    toastBody.textContent =
+                        "Failed: " + (data.message || "Something went wrong");
+                    toast.classList.add("show"); // Show the toast
+
+                    setTimeout(() => {
+                        toast.classList.remove("show"); // Hide the toast after 3 seconds
+                    }, 3000);
+                }
+            })
+            .catch((errors) => {
+                if (authLogo) {
+                    // Hapus ikon yang sudah ada jika ada
+                    const existingIcon = authLogo.querySelector(".bx");
+                    if (existingIcon) {
+                        authLogo.removeChild(existingIcon);
+                    }
+
+                    // Buat ikon baru
+                    const icon = document.createElement("i");
+                    icon.classList.add("bx", "bxs-error-alt");
+                    icon.style.fontSize = "25px";
+                    icon.style.color = "red"; // Pastikan 'green' dalam bentuk string
+
+                    // Tambahkan ikon ke dalam auth-logo
+                    authLogo.appendChild(icon);
+                }
                 // Enable button and reset its text on error
                 modalButton.disabled = false;
-                modalButton.innerHTML = isEdit ? "Update" : "Create"; 
+                modalButton.innerHTML = isEdit ? "Update" : "Create";
 
                 // Set error message for the toast
-                toastBody.textContent = "Failed: " + (data.message || "Something went wrong");
-                toast.classList.add('show');  // Show the toast
+                toastBody.textContent =
+                    "An error occurred while processing your request.";
+                toast.classList.add("show"); // Show the toast
 
                 setTimeout(() => {
-                    toast.classList.remove('show');  // Hide the toast after 3 seconds
+                    toast.classList.remove("show"); // Hide the toast after 3 seconds
                 }, 3000);
-            }
-        })
-        .catch(errors => {
-            if (authLogo) {
-                // Hapus ikon yang sudah ada jika ada
-                const existingIcon = authLogo.querySelector('.bx');
-                if (existingIcon) {
-                    authLogo.removeChild(existingIcon);
-                }
-            
-                // Buat ikon baru
-                const icon = document.createElement('i');
-                icon.classList.add('bx', 'bxs-error-alt');
-                icon.style.fontSize = '25px';
-                icon.style.color = 'red'; // Pastikan 'green' dalam bentuk string
-            
-                // Tambahkan ikon ke dalam auth-logo
-                authLogo.appendChild(icon);
-            }
-            // Enable button and reset its text on error
-            modalButton.disabled = false;
-            modalButton.innerHTML = isEdit ? "Update" : "Create";
-
-            // Set error message for the toast
-            toastBody.textContent = "An error occurred while processing your request.";
-            toast.classList.add('show');  // Show the toast
-
-            setTimeout(() => {
-                toast.classList.remove('show');  // Hide the toast after 3 seconds
-            }, 3000);
-        });
+            });
     });
 
     // Fungsi fetchOptions untuk autocomplete server-side
@@ -140,39 +144,43 @@ document.addEventListener("DOMContentLoaded", function () {
         let inputValue = document.getElementById(field).value;
         if (inputValue.length < 2) return;
         let districtValue = document.getElementById("district_name").value; // Ambil kecamatan terpilih
-    
-        let url = `${GlobalConfig.apiHost}/api/combobox/search-options?query=${encodeURIComponent(inputValue)}&field=${field}`;
-        
+
+        let url = `${
+            GlobalConfig.apiHost
+        }/api/combobox/search-options?query=${encodeURIComponent(
+            inputValue
+        )}&field=${field}`;
+
         // Jika field desa, tambahkan kecamatan sebagai filter
         if (field === "village_name") {
             url += `&district=${encodeURIComponent(districtValue)}`;
         }
-    
+
         fetch(url, {
-            method: 'GET',
+            method: "GET",
             headers: {
                 Authorization: `Bearer ${document
                     .querySelector('meta[name="api-token"]')
                     .getAttribute("content")}`,
                 "Content-Type": "application/json",
-            }
+            },
         })
-        .then(response => response.json())
-        .then(data => {
-            let dataList = document.getElementById(field + "Options");
-            dataList.innerHTML = "";
-    
-            data.forEach(item => {
-                let option = document.createElement("option");
-                option.value = item.name;
-                option.dataset.code = item.code;
-                dataList.appendChild(option);
-            });
-        })
-        .catch(error => console.error("Error fetching options:", error));
+            .then((response) => response.json())
+            .then((data) => {
+                let dataList = document.getElementById(field + "Options");
+                dataList.innerHTML = "";
+
+                data.forEach((item) => {
+                    let option = document.createElement("option");
+                    option.value = item.name;
+                    option.dataset.code = item.code;
+                    dataList.appendChild(option);
+                });
+            })
+            .catch((error) => console.error("Error fetching options:", error));
     };
 
-    document.querySelector('.btn-back').addEventListener('click', function() {
+    document.querySelector(".btn-back").addEventListener("click", function () {
         window.history.back();
     });
-});
+});

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

@@ -18,58 +18,61 @@ console.log(dropzonePreviewNode);
             url: `${GlobalConfig.apiHost}/api/advertisements/import`,
             // url: "https://httpbin.org/post",
             method: "post",
-            acceptedFiles: ".xls,.xlsx",  // Use acceptedFiles for better validation
+            acceptedFiles: ".xls,.xlsx", // Use acceptedFiles for better validation
             previewTemplate: previewTemplate,
             previewsContainer: "#dropzone-preview",
-            autoProcessQueue: false,  // Disable auto post
+            autoProcessQueue: false, // Disable auto post
             headers: {
                 Authorization: `Bearer ${document
                     .querySelector('meta[name="api-token"]')
-                    .getAttribute("content")}`
+                    .getAttribute("content")}`,
             },
-            init: function() {
+            init: function () {
                 // Listen for the success event
-                this.on("success", function(file, response) {
+                this.on("success", function (file, response) {
                     console.log("File successfully uploaded:", file);
                     console.log("API Response:", response);
-                    
+
                     // Show success toast
-                    showToast('bxs-check-square', 'green', response.message);
-                    document.getElementById("submit-upload").innerHTML = "Upload Files";
+                    showToast("bxs-check-square", "green", response.message);
+                    document.getElementById("submit-upload").innerHTML =
+                        "Upload Files";
                     // Tunggu sebentar lalu reload halaman
                     setTimeout(() => {
-                        window.location.href = "/data/advertisements";
+                        window.location.href = "/data/web-advertisements";
                     }, 2000);
                 });
                 // Listen for the error event
-                this.on("error", function(file, errorMessage) {
+                this.on("error", function (file, errorMessage) {
                     console.error("Error uploading file:", file);
                     console.error("Error message:", errorMessage);
                     // Handle the error response
 
                     // Show error toast
-                    showToast('bxs-error-alt', 'red', errorMessage.message);
-                    document.getElementById("submit-upload").innerHTML = "Upload Files";
+                    showToast("bxs-error-alt", "red", errorMessage.message);
+                    document.getElementById("submit-upload").innerHTML =
+                        "Upload Files";
                 });
-            }
+            },
         })));
 
 // Add event listener to control the submission manually
-document.querySelector("#submit-upload").addEventListener("click", function() {
+document.querySelector("#submit-upload").addEventListener("click", function () {
     console.log("Ini adalah value dropzone", dropzone.files[0]);
-    const formData = new FormData()
-    console.log("Dropzonefiles",dropzone.files);
+    const formData = new FormData();
+    console.log("Dropzonefiles", dropzone.files);
 
-    this.innerHTML = '<span class="spinner-border spinner-border-sm me-1" role="status" aria-hidden="true"></span>Loading...';
+    this.innerHTML =
+        '<span class="spinner-border spinner-border-sm me-1" role="status" aria-hidden="true"></span>Loading...';
 
     // Pastikan ada file dalam queue sebelum memprosesnya
     if (dropzone.files.length > 0) {
-        formData.append('file', dropzone.files[0])
+        formData.append("file", dropzone.files[0]);
         console.log("ini adalah form data on submit", ...formData);
-        dropzone.processQueue();  // Ini akan manual memicu upload
+        dropzone.processQueue(); // Ini akan manual memicu upload
     } else {
         // Show error toast when no file is selected
-        showToast('bxs-error-alt', 'red', "Please add a file first.");
+        showToast("bxs-error-alt", "red", "Please add a file first.");
         document.getElementById("submit-upload").innerHTML = "Upload Files";
     }
 });
@@ -82,62 +85,68 @@ dropzone.on("addedfile", function (file) {
     console.log("Ukuran File:", (file.size / 1024).toFixed(2) + " KB");
 });
 
-dropzone.on("complete", function(file) {
+dropzone.on("complete", function (file) {
     dropzone.removeFile(file);
 });
 
 // Add event listener to donwload file template
-document.getElementById('downloadtempadvertisement').addEventListener('click', function() {
-    var url = `${GlobalConfig.apiHost}/api/download-template-advertisement`;
-    fetch(url, {
-        method: 'GET',
-        headers: {
-            Authorization: `Bearer ${document
-                .querySelector('meta[name="api-token"]')
-                .getAttribute("content")}`
-        },
-    })
-    .then(response => {
-        if (response.ok) {
-            return response.blob();
-        } else {
-            return response.json();
-        }
-    })
-    .then((blob) => {
-        const url = window.URL.createObjectURL(blob);
-        const a = document.createElement('a');
-        a.style.display = 'none';
-        a.href = url;
-        a.download = 'template_reklame.xlsx';
-        document.body.appendChild(a);
-        a.click();
-        window.URL.revokeObjectURL(url);
-    })
-    .catch((error) => {
-        console.error("Gagal mendownload file:", error);
-        showToast('bxs-error-alt', 'red', "Template file is not already exist.");
-    })
-})
+document
+    .getElementById("downloadtempadvertisement")
+    .addEventListener("click", function () {
+        var url = `${GlobalConfig.apiHost}/api/download-template-advertisement`;
+        fetch(url, {
+            method: "GET",
+            headers: {
+                Authorization: `Bearer ${document
+                    .querySelector('meta[name="api-token"]')
+                    .getAttribute("content")}`,
+            },
+        })
+            .then((response) => {
+                if (response.ok) {
+                    return response.blob();
+                } else {
+                    return response.json();
+                }
+            })
+            .then((blob) => {
+                const url = window.URL.createObjectURL(blob);
+                const a = document.createElement("a");
+                a.style.display = "none";
+                a.href = url;
+                a.download = "template_reklame.xlsx";
+                document.body.appendChild(a);
+                a.click();
+                window.URL.revokeObjectURL(url);
+            })
+            .catch((error) => {
+                console.error("Gagal mendownload file:", error);
+                showToast(
+                    "bxs-error-alt",
+                    "red",
+                    "Template file is not already exist."
+                );
+            });
+    });
 
 // 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');
+    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');
+    const existingIcon = toastHeader.querySelector(".bx");
     if (existingIcon) {
-        toastHeader.querySelector('.auth-logo').removeChild(existingIcon); // Remove the existing icon
+        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';
+    const icon = document.createElement("i");
+    icon.classList.add("bx", iconClass);
+    icon.style.fontSize = "25px";
     icon.style.color = iconColor;
-    toastHeader.querySelector('.auth-logo').appendChild(icon);
+    toastHeader.querySelector(".auth-logo").appendChild(icon);
 
     // Set the toast message
     toastBody.textContent = message;
@@ -146,4 +155,3 @@ function showToast(iconClass, iconColor, message) {
     const toast = new bootstrap.Toast(toastElement); // Inisialisasi Bootstrap Toast
     toast.show();
 }
-

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

@@ -73,7 +73,7 @@ document.addEventListener("DOMContentLoaded", function () {
                     }, 3000);
 
                     setTimeout(() => {
-                        window.location.href = "/data/spatial-plannings";
+                        window.location.href = "/data/web-spatial-plannings";
                     }, 3000);
                 } else {
                     if (authLogo) {

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

@@ -18,58 +18,61 @@ console.log(dropzonePreviewNode);
             url: `${GlobalConfig.apiHost}/api/spatial-plannings/import`,
             // url: "https://httpbin.org/post",
             method: "post",
-            acceptedFiles: ".xls,.xlsx",  // Use acceptedFiles for better validation
+            acceptedFiles: ".xls,.xlsx", // Use acceptedFiles for better validation
             previewTemplate: previewTemplate,
             previewsContainer: "#dropzone-preview",
-            autoProcessQueue: false,  // Disable auto post
+            autoProcessQueue: false, // Disable auto post
             headers: {
                 Authorization: `Bearer ${document
                     .querySelector('meta[name="api-token"]')
-                    .getAttribute("content")}`
+                    .getAttribute("content")}`,
             },
-            init: function() {
+            init: function () {
                 // Listen for the success event
-                this.on("success", function(file, response) {
+                this.on("success", function (file, response) {
                     console.log("File successfully uploaded:", file);
                     console.log("API Response:", response);
-                    
+
                     // Show success toast
-                    showToast('bxs-check-square', 'green', response.message);
-                    document.getElementById("submit-upload").innerHTML = "Upload Files";
+                    showToast("bxs-check-square", "green", response.message);
+                    document.getElementById("submit-upload").innerHTML =
+                        "Upload Files";
                     // Tunggu sebentar lalu reload halaman
                     setTimeout(() => {
-                        window.location.href = "/data/spatial-plannings";
+                        window.location.href = "/data/web-spatial-plannings";
                     }, 2000);
                 });
                 // Listen for the error event
-                this.on("error", function(file, errorMessage) {
+                this.on("error", function (file, errorMessage) {
                     console.error("Error uploading file:", file);
                     console.error("Error message:", errorMessage);
                     // Handle the error response
 
                     // Show error toast
-                    showToast('bxs-error-alt', 'red', errorMessage.message);
-                    document.getElementById("submit-upload").innerHTML = "Upload Files";
+                    showToast("bxs-error-alt", "red", errorMessage.message);
+                    document.getElementById("submit-upload").innerHTML =
+                        "Upload Files";
                 });
-            }
+            },
         })));
 
 // Add event listener to control the submission manually
-document.querySelector("#submit-upload").addEventListener("click", function() {
+document.querySelector("#submit-upload").addEventListener("click", function () {
     console.log("Ini adalah value dropzone", dropzone.files[0]);
-    const formData = new FormData()
-    console.log("Dropzonefiles",dropzone.files);
+    const formData = new FormData();
+    console.log("Dropzonefiles", dropzone.files);
 
-    this.innerHTML = '<span class="spinner-border spinner-border-sm me-1" role="status" aria-hidden="true"></span>Loading...';
+    this.innerHTML =
+        '<span class="spinner-border spinner-border-sm me-1" role="status" aria-hidden="true"></span>Loading...';
 
     // Pastikan ada file dalam queue sebelum memprosesnya
     if (dropzone.files.length > 0) {
-        formData.append('file', dropzone.files[0])
+        formData.append("file", dropzone.files[0]);
         console.log("ini adalah form data on submit", ...formData);
-        dropzone.processQueue();  // Ini akan manual memicu upload
+        dropzone.processQueue(); // Ini akan manual memicu upload
     } else {
         // Show error toast when no file is selected
-        showToast('bxs-error-alt', 'red', "Please add a file first.");
+        showToast("bxs-error-alt", "red", "Please add a file first.");
         document.getElementById("submit-upload").innerHTML = "Upload Files";
     }
 });
@@ -82,63 +85,69 @@ dropzone.on("addedfile", function (file) {
     console.log("Ukuran File:", (file.size / 1024).toFixed(2) + " KB");
 });
 
-dropzone.on("complete", function(file) {
+dropzone.on("complete", function (file) {
     dropzone.removeFile(file);
 });
 
 // Add event listener to download file template
-document.getElementById('downloadtempspatialPlannings').addEventListener('click', function() {
-    var url = `${GlobalConfig.apiHost}/api/download-template-spatialPlannings`;
-    fetch(url, {
-        method: 'GET',
-        headers: {
-            Authorization: `Bearer ${document
-                .querySelector('meta[name="api-token"]')
-                .getAttribute("content")}`
-        },
-    })
-    .then(response => {
-        if (response.ok) {
-            return response.blob();  // Jika respons OK, konversi menjadi blob
-        } else {
-            return response.json(); // Jika respons gagal, konversi menjadi JSON untuk menangani pesan error
-        }
-    })
-    .then((blob) => {
-        console.log(blob);
-        const url = window.URL.createObjectURL(blob);
-        const a = document.createElement('a');
-        a.style.display = 'none';
-        a.href = url;
-        a.download = 'template_rencana_tata_ruang.xlsx';
-        document.body.appendChild(a);
-        a.click();
-        window.URL.revokeObjectURL(url);
-    })
-    .catch((error) => {
-        console.error("Gagal mendownload file:", error);
-        showToast('bxs-error-alt', 'red', "Template file is not already exist.");
-    })
-})
+document
+    .getElementById("downloadtempspatialPlannings")
+    .addEventListener("click", function () {
+        var url = `${GlobalConfig.apiHost}/api/download-template-spatialPlannings`;
+        fetch(url, {
+            method: "GET",
+            headers: {
+                Authorization: `Bearer ${document
+                    .querySelector('meta[name="api-token"]')
+                    .getAttribute("content")}`,
+            },
+        })
+            .then((response) => {
+                if (response.ok) {
+                    return response.blob(); // Jika respons OK, konversi menjadi blob
+                } else {
+                    return response.json(); // Jika respons gagal, konversi menjadi JSON untuk menangani pesan error
+                }
+            })
+            .then((blob) => {
+                console.log(blob);
+                const url = window.URL.createObjectURL(blob);
+                const a = document.createElement("a");
+                a.style.display = "none";
+                a.href = url;
+                a.download = "template_rencana_tata_ruang.xlsx";
+                document.body.appendChild(a);
+                a.click();
+                window.URL.revokeObjectURL(url);
+            })
+            .catch((error) => {
+                console.error("Gagal mendownload file:", error);
+                showToast(
+                    "bxs-error-alt",
+                    "red",
+                    "Template file is not already exist."
+                );
+            });
+    });
 
 // Function to show toast
 function showToast(iconClass, iconColor, message) {
-    const toastElement = document.getElementById('toastUploadSpatialPlannings');
-    const toastBody = toastElement.querySelector('.toast-body');
-    const toastHeader = toastElement.querySelector('.toast-header');
+    const toastElement = document.getElementById("toastUploadSpatialPlannings");
+    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');
+    const existingIcon = toastHeader.querySelector(".bx");
     if (existingIcon) {
-        toastHeader.querySelector('.auth-logo').removeChild(existingIcon); // Remove the existing icon
+        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';
+    const icon = document.createElement("i");
+    icon.classList.add("bx", iconClass);
+    icon.style.fontSize = "25px";
     icon.style.color = iconColor;
-    toastHeader.querySelector('.auth-logo').appendChild(icon);
+    toastHeader.querySelector(".auth-logo").appendChild(icon);
 
     // Set the toast message
     toastBody.textContent = message;
@@ -147,4 +156,3 @@ function showToast(iconClass, iconColor, message) {
     const toast = new bootstrap.Toast(toastElement); // Inisialisasi Bootstrap Toast
     toast.show();
 }
-

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

@@ -73,7 +73,7 @@ document.addEventListener("DOMContentLoaded", function () {
                     }, 3000);
 
                     setTimeout(() => {
-                        window.location.href = "/data/tourisms";
+                        window.location.href = "/data/web-tourisms";
                     }, 3000);
                 } else {
                     if (authLogo) {

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

@@ -18,58 +18,61 @@ console.log(dropzonePreviewNode);
             url: `${GlobalConfig.apiHost}/api/tourisms/import`,
             // url: "https://httpbin.org/post",
             method: "post",
-            acceptedFiles: ".xls,.xlsx",  // Use acceptedFiles for better validation
+            acceptedFiles: ".xls,.xlsx", // Use acceptedFiles for better validation
             previewTemplate: previewTemplate,
             previewsContainer: "#dropzone-preview",
-            autoProcessQueue: false,  // Disable auto post
+            autoProcessQueue: false, // Disable auto post
             headers: {
                 Authorization: `Bearer ${document
                     .querySelector('meta[name="api-token"]')
-                    .getAttribute("content")}`
+                    .getAttribute("content")}`,
             },
-            init: function() {
+            init: function () {
                 // Listen for the success event
-                this.on("success", function(file, response) {
+                this.on("success", function (file, response) {
                     console.log("File successfully uploaded:", file);
                     console.log("API Response:", response);
-                    
+
                     // Show success toast
-                    showToast('bxs-check-square', 'green', response.message);
-                    document.getElementById("submit-upload").innerHTML = "Upload Files";
+                    showToast("bxs-check-square", "green", response.message);
+                    document.getElementById("submit-upload").innerHTML =
+                        "Upload Files";
                     // Tunggu sebentar lalu reload halaman
                     setTimeout(() => {
-                        window.location.href = "/data/tourisms";
+                        window.location.href = "/data/web-tourisms";
                     }, 2000);
                 });
                 // Listen for the error event
-                this.on("error", function(file, errorMessage) {
+                this.on("error", function (file, errorMessage) {
                     console.error("Error uploading file:", file);
                     console.error("Error message:", errorMessage);
                     // Handle the error response
 
                     // Show error toast
-                    showToast('bxs-error-alt', 'red', errorMessage.message);
-                    document.getElementById("submit-upload").innerHTML = "Upload Files";
+                    showToast("bxs-error-alt", "red", errorMessage.message);
+                    document.getElementById("submit-upload").innerHTML =
+                        "Upload Files";
                 });
-            }
+            },
         })));
 
 // Add event listener to control the submission manually
-document.querySelector("#submit-upload").addEventListener("click", function() {
+document.querySelector("#submit-upload").addEventListener("click", function () {
     console.log("Ini adalah value dropzone", dropzone.files[0]);
-    const formData = new FormData()
-    console.log("Dropzonefiles",dropzone.files);
+    const formData = new FormData();
+    console.log("Dropzonefiles", dropzone.files);
 
-    this.innerHTML = '<span class="spinner-border spinner-border-sm me-1" role="status" aria-hidden="true"></span>Loading...';
+    this.innerHTML =
+        '<span class="spinner-border spinner-border-sm me-1" role="status" aria-hidden="true"></span>Loading...';
 
     // Pastikan ada file dalam queue sebelum memprosesnya
     if (dropzone.files.length > 0) {
-        formData.append('file', dropzone.files[0])
+        formData.append("file", dropzone.files[0]);
         console.log("ini adalah form data on submit", ...formData);
-        dropzone.processQueue();  // Ini akan manual memicu upload
+        dropzone.processQueue(); // Ini akan manual memicu upload
     } else {
         // Show error toast when no file is selected
-        showToast('bxs-error-alt', 'red', "Please add a file first.");
+        showToast("bxs-error-alt", "red", "Please add a file first.");
         document.getElementById("submit-upload").innerHTML = "Upload Files";
     }
 });
@@ -82,63 +85,69 @@ dropzone.on("addedfile", function (file) {
     console.log("Ukuran File:", (file.size / 1024).toFixed(2) + " KB");
 });
 
-dropzone.on("complete", function(file) {
+dropzone.on("complete", function (file) {
     dropzone.removeFile(file);
 });
 
 // Add event listener to download file template
-document.getElementById('downloadtemptourisms').addEventListener('click', function() {
-    var url = `${GlobalConfig.apiHost}/api/download-template-tourism`;
-    fetch(url, {
-        method: 'GET',
-        headers: {
-            Authorization: `Bearer ${document
-                .querySelector('meta[name="api-token"]')
-                .getAttribute("content")}`
-        },
-    })
-    .then(response => {
-        if (response.ok) {
-            return response.blob();  // Jika respons OK, konversi menjadi blob
-        } else {
-            return response.json(); // Jika respons gagal, konversi menjadi JSON untuk menangani pesan error
-        }
-    })
-    .then((blob) => {
-        console.log(blob);
-        const url = window.URL.createObjectURL(blob);
-        const a = document.createElement('a');
-        a.style.display = 'none';
-        a.href = url;
-        a.download = 'template_pariwisata.xlsx';
-        document.body.appendChild(a);
-        a.click();
-        window.URL.revokeObjectURL(url);
-    })
-    .catch((error) => {
-        console.error("Gagal mendownload file:", error);
-        showToast('bxs-error-alt', 'red', "Template file is not already exist.");
-    })
-})
+document
+    .getElementById("downloadtemptourisms")
+    .addEventListener("click", function () {
+        var url = `${GlobalConfig.apiHost}/api/download-template-tourism`;
+        fetch(url, {
+            method: "GET",
+            headers: {
+                Authorization: `Bearer ${document
+                    .querySelector('meta[name="api-token"]')
+                    .getAttribute("content")}`,
+            },
+        })
+            .then((response) => {
+                if (response.ok) {
+                    return response.blob(); // Jika respons OK, konversi menjadi blob
+                } else {
+                    return response.json(); // Jika respons gagal, konversi menjadi JSON untuk menangani pesan error
+                }
+            })
+            .then((blob) => {
+                console.log(blob);
+                const url = window.URL.createObjectURL(blob);
+                const a = document.createElement("a");
+                a.style.display = "none";
+                a.href = url;
+                a.download = "template_pariwisata.xlsx";
+                document.body.appendChild(a);
+                a.click();
+                window.URL.revokeObjectURL(url);
+            })
+            .catch((error) => {
+                console.error("Gagal mendownload file:", error);
+                showToast(
+                    "bxs-error-alt",
+                    "red",
+                    "Template file is not already exist."
+                );
+            });
+    });
 
 // Function to show toast
 function showToast(iconClass, iconColor, message) {
-    const toastElement = document.getElementById('toastUploadTourisms');
-    const toastBody = toastElement.querySelector('.toast-body');
-    const toastHeader = toastElement.querySelector('.toast-header');
+    const toastElement = document.getElementById("toastUploadTourisms");
+    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');
+    const existingIcon = toastHeader.querySelector(".bx");
     if (existingIcon) {
-        toastHeader.querySelector('.auth-logo').removeChild(existingIcon); // Remove the existing icon
+        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';
+    const icon = document.createElement("i");
+    icon.classList.add("bx", iconClass);
+    icon.style.fontSize = "25px";
     icon.style.color = iconColor;
-    toastHeader.querySelector('.auth-logo').appendChild(icon);
+    toastHeader.querySelector(".auth-logo").appendChild(icon);
 
     // Set the toast message
     toastBody.textContent = message;
@@ -147,4 +156,3 @@ function showToast(iconClass, iconColor, message) {
     const toast = new bootstrap.Toast(toastElement); // Inisialisasi Bootstrap Toast
     toast.show();
 }
-

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

@@ -16,10 +16,10 @@ document.addEventListener("DOMContentLoaded", function () {
             Loading...
         `;
         const isEdit = saveButton.classList.contains("btn-edit");
-        const formData = new FormData(form)
-        const toast = document.getElementById('toastEditUpdate');
-        const toastBody = toast.querySelector('.toast-body');
-        const toastHeader = toast.querySelector('.toast-header small');
+        const formData = new FormData(form);
+        const toast = document.getElementById("toastEditUpdate");
+        const toastBody = toast.querySelector(".toast-body");
+        const toastHeader = toast.querySelector(".toast-header small");
 
         const data = {};
 
@@ -40,53 +40,88 @@ document.addEventListener("DOMContentLoaded", function () {
                     .querySelector('meta[name="api-token"]')
                     .getAttribute("content")}`,
                 "Content-Type": "application/json",
-            }
+            },
         })
-        .then(response => response.json())
-        .then(data => {
-            console.log("Response data:", data);
-            if (!data.errors) {
-                // Remove existing icon (if any) before adding the new one
-                if (authLogo) {
-                    // Hapus ikon yang sudah ada jika ada
-                    const existingIcon = authLogo.querySelector('.bx');
-                    if (existingIcon) {
-                        authLogo.removeChild(existingIcon);
+            .then((response) => response.json())
+            .then((data) => {
+                console.log("Response data:", data);
+                if (!data.errors) {
+                    // Remove existing icon (if any) before adding the new one
+                    if (authLogo) {
+                        // Hapus ikon yang sudah ada jika ada
+                        const existingIcon = authLogo.querySelector(".bx");
+                        if (existingIcon) {
+                            authLogo.removeChild(existingIcon);
+                        }
+
+                        // Buat ikon baru
+                        const icon = document.createElement("i");
+                        icon.classList.add("bx", "bxs-check-square");
+                        icon.style.fontSize = "25px";
+                        icon.style.color = "green"; // Pastikan 'green' dalam bentuk string
+
+                        // Tambahkan ikon ke dalam auth-logo
+                        authLogo.appendChild(icon);
                     }
 
-                    // Buat ikon baru
-                    const icon = document.createElement('i');
-                    icon.classList.add('bx', 'bxs-check-square');
-                    icon.style.fontSize = '25px';
-                    icon.style.color = 'green'; // Pastikan 'green' dalam bentuk string
+                    // Set success message for the toast
+                    toastBody.textContent = isEdit
+                        ? "Data updated successfully!"
+                        : "Data created successfully!";
+                    toast.classList.add("show"); // Show the toast
+                    setTimeout(() => {
+                        toast.classList.remove("show"); // Hide the toast after 3 seconds
+                    }, 2000);
 
-                    // Tambahkan ikon ke dalam auth-logo
-                    authLogo.appendChild(icon);
+                    setTimeout(() => {
+                        window.location.href = "/data/web-umkm";
+                    }, 1000);
+                } else {
+                    if (authLogo) {
+                        // Hapus ikon yang sudah ada jika ada
+                        const existingIcon = authLogo.querySelector(".bx");
+                        if (existingIcon) {
+                            authLogo.removeChild(existingIcon);
+                        }
+
+                        // Buat ikon baru
+                        const icon = document.createElement("i");
+                        icon.classList.add("bx", "bxs-error-alt");
+                        icon.style.fontSize = "25px";
+                        icon.style.color = "red"; // Pastikan 'green' dalam bentuk string
+
+                        // Tambahkan ikon ke dalam auth-logo
+                        authLogo.appendChild(icon);
+                    }
+
+                    // Enable button and reset its text on error
+                    modalButton.disabled = false;
+                    modalButton.innerHTML = isEdit ? "Update" : "Create";
+
+                    // Set error message for the toast
+                    toastBody.textContent =
+                        "Error: " + (data.message || "Something went wrong");
+                    toast.classList.add("show"); // Show the toast
+
+                    setTimeout(() => {
+                        toast.classList.remove("show"); // Hide the toast after 3 seconds
+                    }, 3000);
                 }
-
-                // Set success message for the toast
-                toastBody.textContent = isEdit ? "Data updated successfully!" : "Data created successfully!";
-                toast.classList.add('show');  // Show the toast
-                setTimeout(() => {
-                    toast.classList.remove('show');  // Hide the toast after 3 seconds
-                }, 2000);
-
-                setTimeout(() => {
-                    window.location.href = '/data/umkm';
-                }, 1000);
-            } else {
+            })
+            .catch((error) => {
+                console.error("Error:", error);
                 if (authLogo) {
                     // Hapus ikon yang sudah ada jika ada
-                    const existingIcon = authLogo.querySelector('.bx');
+                    const existingIcon = authLogo.querySelector(".bx");
                     if (existingIcon) {
                         authLogo.removeChild(existingIcon);
                     }
 
                     // Buat ikon baru
-                    const icon = document.createElement('i');
-                    icon.classList.add('bx', 'bxs-error-alt');
-                    icon.style.fontSize = '25px';
-                    icon.style.color = 'red'; // Pastikan 'green' dalam bentuk string
+                    const icon = document.createElement("i");
+                    icon.classList.add("bx", "bxs-error-alt");
+                    icon.style.fontSize = "25px";
+                    icon.style.color = "red"; // Pastikan 'green' dalam bentuk string
 
                     // Tambahkan ikon ke dalam auth-logo
                     authLogo.appendChild(icon);
@@ -96,47 +131,15 @@ document.addEventListener("DOMContentLoaded", function () {
                 modalButton.disabled = false;
                 modalButton.innerHTML = isEdit ? "Update" : "Create";
 
-                
                 // Set error message for the toast
-                toastBody.textContent = "Error: " + (data.message || "Something went wrong");
-                toast.classList.add('show');  // Show the toast
+                toastBody.textContent =
+                    "An error occurred while processing your request.";
+                toast.classList.add("show"); // Show the toast
 
                 setTimeout(() => {
-                    toast.classList.remove('show');  // Hide the toast after 3 seconds
+                    toast.classList.remove("show"); // Hide the toast after 3 seconds
                 }, 3000);
-            }
-        })
-        .catch(error => {
-            console.error("Error:", error);
-            if (authLogo) {
-                // Hapus ikon yang sudah ada jika ada
-                const existingIcon = authLogo.querySelector('.bx');
-                if (existingIcon) {
-                    authLogo.removeChild(existingIcon);
-                }
-
-                // Buat ikon baru
-                const icon = document.createElement('i');
-                icon.classList.add('bx', 'bxs-error-alt');
-                icon.style.fontSize = '25px';
-                icon.style.color = 'red'; // Pastikan 'green' dalam bentuk string
-
-                // Tambahkan ikon ke dalam auth-logo
-                authLogo.appendChild(icon);
-            }
-
-            // Enable button and reset its text on error
-            modalButton.disabled = false;
-            modalButton.innerHTML = isEdit ? "Update" : "Create";
-
-            // Set error message for the toast
-            toastBody.textContent = "An error occurred while processing your request.";
-            toast.classList.add('show');  // Show the toast
-
-            setTimeout(() => {
-                toast.classList.remove('show');  // Hide the toast after 3 seconds
-            }, 3000);
-        });
+            });
     });
 
     // Fungsi fetchOptions untuk autocomplete server-side
@@ -145,7 +148,11 @@ document.addEventListener("DOMContentLoaded", function () {
         if (inputValue.length < 2) return;
         let districtValue = document.getElementById("district_name").value; // Ambil kecamatan terpilih
 
-        let url = `${GlobalConfig.apiHost}/api/combobox/search-options?query=${encodeURIComponent(inputValue)}&field=${field}`;
+        let url = `${
+            GlobalConfig.apiHost
+        }/api/combobox/search-options?query=${encodeURIComponent(
+            inputValue
+        )}&field=${field}`;
 
         // Jika field desa, tambahkan kecamatan sebagai filter
         if (field === "village_name") {
@@ -153,30 +160,30 @@ document.addEventListener("DOMContentLoaded", function () {
         }
 
         fetch(url, {
-            method: 'GET',
+            method: "GET",
             headers: {
                 Authorization: `Bearer ${document
                     .querySelector('meta[name="api-token"]')
                     .getAttribute("content")}`,
                 "Content-Type": "application/json",
-            }
+            },
         })
-        .then(response => response.json())
-        .then(data => {
-            let dataList = document.getElementById(field + "Options");
-            dataList.innerHTML = "";
+            .then((response) => response.json())
+            .then((data) => {
+                let dataList = document.getElementById(field + "Options");
+                dataList.innerHTML = "";
 
-            data.forEach(item => {
-                let option = document.createElement("option");
-                option.value = item.name;
-                option.dataset.code = item.code;
-                dataList.appendChild(option);
-            });
-        })
-        .catch(error => console.error("Error fetching options:", error));
+                data.forEach((item) => {
+                    let option = document.createElement("option");
+                    option.value = item.name;
+                    option.dataset.code = item.code;
+                    dataList.appendChild(option);
+                });
+            })
+            .catch((error) => console.error("Error fetching options:", error));
     };
 
-    document.querySelector('.btn-back').addEventListener('click', function() {
+    document.querySelector(".btn-back").addEventListener("click", function () {
         window.history.back();
     });
-});
+});

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

@@ -18,58 +18,61 @@ console.log(dropzonePreviewNode);
             url: `${GlobalConfig.apiHost}/api/umkm/import`,
             // url: "https://httpbin.org/post",
             method: "post",
-            acceptedFiles: ".xls,.xlsx",  // Use acceptedFiles for better validation
+            acceptedFiles: ".xls,.xlsx", // Use acceptedFiles for better validation
             previewTemplate: previewTemplate,
             previewsContainer: "#dropzone-preview",
-            autoProcessQueue: false,  // Disable auto post
+            autoProcessQueue: false, // Disable auto post
             headers: {
                 Authorization: `Bearer ${document
                     .querySelector('meta[name="api-token"]')
-                    .getAttribute("content")}`
+                    .getAttribute("content")}`,
             },
-            init: function() {
+            init: function () {
                 // Listen for the success event
-                this.on("success", function(file, response) {
+                this.on("success", function (file, response) {
                     console.log("File successfully uploaded:", file);
                     console.log("API Response:", response);
-                    
+
                     // Show success toast
-                    showToast('bxs-check-square', 'green', response.message);
-                    document.getElementById("submit-upload").innerHTML = "Upload Files";
+                    showToast("bxs-check-square", "green", response.message);
+                    document.getElementById("submit-upload").innerHTML =
+                        "Upload Files";
                     // Tunggu sebentar lalu reload halaman
                     setTimeout(() => {
-                        window.location.href = "/data/umkm";
+                        window.location.href = "/data/web-umkm";
                     }, 2000);
                 });
                 // Listen for the error event
-                this.on("error", function(file, errorMessage) {
+                this.on("error", function (file, errorMessage) {
                     console.error("Error uploading file:", file);
                     console.error("Error message:", errorMessage);
                     // Handle the error response
 
                     // Show error toast
-                    showToast('bxs-error-alt', 'red', errorMessage.message);
-                    document.getElementById("submit-upload").innerHTML = "Upload Files";
+                    showToast("bxs-error-alt", "red", errorMessage.message);
+                    document.getElementById("submit-upload").innerHTML =
+                        "Upload Files";
                 });
-            }
+            },
         })));
 
 // Add event listener to control the submission manually
-document.querySelector("#submit-upload").addEventListener("click", function() {
+document.querySelector("#submit-upload").addEventListener("click", function () {
     console.log("Ini adalah value dropzone", dropzone.files[0]);
-    const formData = new FormData()
-    console.log("Dropzonefiles",dropzone.files);
+    const formData = new FormData();
+    console.log("Dropzonefiles", dropzone.files);
 
-    this.innerHTML = '<span class="spinner-border spinner-border-sm me-1" role="status" aria-hidden="true"></span>Loading...';
+    this.innerHTML =
+        '<span class="spinner-border spinner-border-sm me-1" role="status" aria-hidden="true"></span>Loading...';
 
     // Pastikan ada file dalam queue sebelum memprosesnya
     if (dropzone.files.length > 0) {
-        formData.append('file', dropzone.files[0])
+        formData.append("file", dropzone.files[0]);
         console.log("ini adalah form data on submit", ...formData);
-        dropzone.processQueue();  // Ini akan manual memicu upload
+        dropzone.processQueue(); // Ini akan manual memicu upload
     } else {
         // Show error toast when no file is selected
-        showToast('bxs-error-alt', 'red', "Please add a file first.");
+        showToast("bxs-error-alt", "red", "Please add a file first.");
         document.getElementById("submit-upload").innerHTML = "Upload Files";
     }
 });
@@ -82,62 +85,68 @@ dropzone.on("addedfile", function (file) {
     console.log("Ukuran File:", (file.size / 1024).toFixed(2) + " KB");
 });
 
-dropzone.on("complete", function(file) {
+dropzone.on("complete", function (file) {
     dropzone.removeFile(file);
 });
 
 // Add event listener to download file template
-document.getElementById('downloadtempumkm').addEventListener('click', function() {
-    var url = `${GlobalConfig.apiHost}/api/download-template-umkm`;
-    fetch(url, {
-        method: 'GET',
-        headers: {
-            Authorization: `Bearer ${document
-                .querySelector('meta[name="api-token"]')
-                .getAttribute("content")}`
-        },
-    })
-    .then(response => {
-        if (response.ok) {
-            return response.blob();  // Jika respons OK, konversi menjadi blob
-        } else {
-            return response.json(); // Jika respons gagal, konversi menjadi JSON untuk menangani pesan error
-        }
-    })
-    .then((blob) => {
-        const url = window.URL.createObjectURL(blob);
-        const a = document.createElement('a');
-        a.style.display = 'none';
-        a.href = url;
-        a.download = 'template_umkm.xlsx';
-        document.body.appendChild(a);
-        a.click();
-        window.URL.revokeObjectURL(url);
-    })
-    .catch((error) => {
-        console.error("Gagal mendownload file:", error);
-        showToast('bxs-error-alt', 'red', "Template file is not already exist.");
-    })
-})
+document
+    .getElementById("downloadtempumkm")
+    .addEventListener("click", function () {
+        var url = `${GlobalConfig.apiHost}/api/download-template-umkm`;
+        fetch(url, {
+            method: "GET",
+            headers: {
+                Authorization: `Bearer ${document
+                    .querySelector('meta[name="api-token"]')
+                    .getAttribute("content")}`,
+            },
+        })
+            .then((response) => {
+                if (response.ok) {
+                    return response.blob(); // Jika respons OK, konversi menjadi blob
+                } else {
+                    return response.json(); // Jika respons gagal, konversi menjadi JSON untuk menangani pesan error
+                }
+            })
+            .then((blob) => {
+                const url = window.URL.createObjectURL(blob);
+                const a = document.createElement("a");
+                a.style.display = "none";
+                a.href = url;
+                a.download = "template_umkm.xlsx";
+                document.body.appendChild(a);
+                a.click();
+                window.URL.revokeObjectURL(url);
+            })
+            .catch((error) => {
+                console.error("Gagal mendownload file:", error);
+                showToast(
+                    "bxs-error-alt",
+                    "red",
+                    "Template file is not already exist."
+                );
+            });
+    });
 
 // Function to show toast
 function showToast(iconClass, iconColor, message) {
-    const toastElement = document.getElementById('toastUploadUmkm');
-    const toastBody = toastElement.querySelector('.toast-body');
-    const toastHeader = toastElement.querySelector('.toast-header');
+    const toastElement = document.getElementById("toastUploadUmkm");
+    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');
+    const existingIcon = toastHeader.querySelector(".bx");
     if (existingIcon) {
-        toastHeader.querySelector('.auth-logo').removeChild(existingIcon); // Remove the existing icon
+        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';
+    const icon = document.createElement("i");
+    icon.classList.add("bx", iconClass);
+    icon.style.fontSize = "25px";
     icon.style.color = iconColor;
-    toastHeader.querySelector('.auth-logo').appendChild(icon);
+    toastHeader.querySelector(".auth-logo").appendChild(icon);
 
     // Set the toast message
     toastBody.textContent = message;
@@ -146,4 +155,3 @@ function showToast(iconClass, iconColor, message) {
     const toast = new bootstrap.Toast(toastElement); // Inisialisasi Bootstrap Toast
     toast.show();
 }
-

resources/js/master/users/users.js

@@ -31,7 +31,7 @@ class UsersTable {
                 },
             ],
             pagination: {
-                limit: 15,
+                limit: 50,
                 server: {
                     url: (prev, page) =>
                         `${prev}${prev.includes("?") ? "&" : "?"}page=${
@@ -44,6 +44,7 @@ class UsersTable {
                 server: {
                     url: (prev, keyword) => `${prev}?search=${keyword}`,
                 },
+                debounceTimeout: 1000,
             },
             server: {
                 url: `${GlobalConfig.apiHost}/api/users`,

resources/js/menus/index.js

@@ -28,35 +28,35 @@ class Menus {
     initTableMenus() {
         let tableContainer = document.getElementById("table-menus");
 
-        if (this.table) {
-            // If table exists, update its data instead of recreating
-            this.table
-                .updateConfig({
-                    server: {
-                        url: `${GlobalConfig.apiHost}/api/menus`,
-                        credentials: "include",
-                        headers: {
-                            Authorization: `Bearer ${document
-                                .querySelector('meta[name="api-token"]')
-                                .getAttribute("content")}`,
-                            "Content-Type": "application/json",
-                        },
-                        then: (data) =>
-                            data.data.map((item) => [
-                                item.id,
-                                item.name,
-                                item.url,
-                                item.icon,
-                                item.parent_id,
-                                item.sort_order,
-                                item.id,
-                            ]),
-                        total: (data) => data.total,
-                    },
-                })
-                .forceRender();
-            return;
-        }
+        // if (this.table) {
+        //     // If table exists, update its data instead of recreating
+        //     this.table
+        //         .updateConfig({
+        //             server: {
+        //                 url: `${GlobalConfig.apiHost}/api/menus`,
+        //                 credentials: "include",
+        //                 headers: {
+        //                     Authorization: `Bearer ${document
+        //                         .querySelector('meta[name="api-token"]')
+        //                         .getAttribute("content")}`,
+        //                     "Content-Type": "application/json",
+        //                 },
+        //                 then: (data) =>
+        //                     data.data.map((item) => [
+        //                         item.id,
+        //                         item.name,
+        //                         item.url,
+        //                         item.icon,
+        //                         item.parent_id,
+        //                         item.sort_order,
+        //                         item.id,
+        //                     ]),
+        //                 total: (data) => data.total,
+        //             },
+        //         })
+        //         .forceRender();
+        //     return;
+        // }
 
         this.table = new Grid({
             columns: [
@@ -83,7 +83,7 @@ class Menus {
                 },
             ],
             pagination: {
-                limit: 15,
+                limit: 50,
                 server: {
                     url: (prev, page) =>
                         `${prev}${prev.includes("?") ? "&" : "?"}page=${
@@ -96,6 +96,7 @@ class Menus {
                 server: {
                     url: (prev, keyword) => `${prev}?search=${keyword}`,
                 },
+                debounceTimeout: 1000,
             },
             server: {
                 url: `${GlobalConfig.apiHost}/api/menus`,

resources/js/pbg-task/index.js

@@ -36,6 +36,7 @@ class PbgTasks {
                 server: {
                     url: (prev, keyword) => `${prev}?search=${keyword}`,
                 },
+                debounceTimeout: 1000,
             },
             pagination: {
                 limit: 15,

resources/js/pbg-task/show.js

@@ -0,0 +1,69 @@
+import { Grid } from "gridjs/dist/gridjs.umd.js";
+import "gridjs/dist/gridjs.umd.js";
+import gridjs from "gridjs/dist/gridjs.umd.js";
+import GlobalConfig from "../global-config";
+
+class PbgTaskAssignments {
+    init() {
+        this.initTablePbgTaskAssignments();
+    }
+
+    initTablePbgTaskAssignments() {
+        let tableContainer = document.getElementById(
+            "table-pbg-task-assignments"
+        );
+
+        let uuid = document.getElementById("uuid").value;
+
+        new Grid({
+            columns: [
+                "ID",
+                "Nama",
+                "Email",
+                "Nomor Telepon",
+                "Keahlian",
+                "Status",
+            ],
+            search: {
+                server: {
+                    url: (prev, keyword) => `${prev}?search=${keyword}`,
+                },
+                debounceTimeout: 1000,
+            },
+            pagination: {
+                limit: 15,
+                server: {
+                    url: (prev, page) =>
+                        `${prev}${prev.includes("?") ? "&" : "?"}page=${
+                            page + 1
+                        }`,
+                },
+            },
+            sort: true,
+            server: {
+                url: `${GlobalConfig.apiHost}/api/task-assignments/${uuid}`,
+                credentials: "include",
+                headers: {
+                    Authorization: `Bearer ${document
+                        .querySelector('meta[name="api-token"]')
+                        .getAttribute("content")}`,
+                    "Content-Type": "application/json",
+                },
+                then: (data) =>
+                    data.data.map((item) => [
+                        item.id,
+                        item.name,
+                        item.email,
+                        item.phone_number,
+                        item.expertise,
+                        item.status_name,
+                    ]),
+                total: (data) => data.meta.total,
+            },
+        }).render(tableContainer);
+    }
+}
+
+document.addEventListener("DOMContentLoaded", function (e) {
+    new PbgTaskAssignments().init();
+});

resources/js/roles/index.js

@@ -52,7 +52,7 @@ class Roles {
                 },
             ],
             pagination: {
-                limit: 15,
+                limit: 50,
                 server: {
                     url: (prev, page) =>
                         `${prev}${prev.includes("?") ? "&" : "?"}page=${
@@ -65,6 +65,7 @@ class Roles {
                 server: {
                     url: (prev, keyword) => `${prev}?search=${keyword}`,
                 },
+                debounceTimeout: 1000,
             },
             server: {
                 url: `${GlobalConfig.apiHost}/api/roles`,

resources/js/settings/syncronize/syncronize.js

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

resources/js/table-generator.js

@@ -18,12 +18,15 @@ class GeneralTable {
                 server: {
                     url: (prev, keyword) => `${prev}?search=${keyword}`,
                 },
+                debounceTimeout: 1000,
             },
             pagination: this.options.pagination || {
                 limit: 15,
                 server: {
                     url: (prev, page) =>
-                        `${prev}${prev.includes("?") ? "&" : "?"}page=${page + 1}`,
+                        `${prev}${prev.includes("?") ? "&" : "?"}page=${
+                            page + 1
+                        }`,
                 },
             },
             sort: this.options.sort || true,
@@ -48,22 +51,29 @@ class GeneralTable {
     processData(data) {
         return data.data.map((item) => {
             return this.columns.map((column) => {
-                return item[column] || '';
+                return item[column] || "";
             });
         });
     }
 
     handleActions() {
         document.addEventListener("click", (event) => {
-            if (event.target && event.target.classList.contains('btn-edit')) {
+            if (event.target && event.target.classList.contains("btn-edit")) {
                 this.handleEdit(event);
-            }
-            else if (event.target && event.target.classList.contains('btn-delete')) {
+            } else if (
+                event.target &&
+                event.target.classList.contains("btn-delete")
+            ) {
                 this.handleDelete(event);
-            }
-            else if (event.target && event.target.classList.contains('btn-create')) {
+            } else if (
+                event.target &&
+                event.target.classList.contains("btn-create")
+            ) {
                 this.handleCreate(event);
-            } else if (event.target && event.target.classList.contains('btn-bulk-create')) {
+            } else if (
+                event.target &&
+                event.target.classList.contains("btn-bulk-create")
+            ) {
                 this.handleBulkCreate(event);
             }
         });
@@ -72,28 +82,28 @@ class GeneralTable {
     // Fungsi untuk menangani create
     handleCreate(event) {
         // Menggunakan model dan ID untuk membangun URL dinamis
-        const model = event.target.getAttribute('data-model'); // Mengambil model dari data-model
+        const model = event.target.getAttribute("data-model"); // Mengambil model dari data-model
         window.location.href = `${this.baseUrl}/${model}/create`;
     }
 
     handleBulkCreate(event) {
         // Menggunakan model dan ID untuk membangun URL dinamis
-        const model = event.target.getAttribute('data-model');
+        const model = event.target.getAttribute("data-model");
         window.location.href = `${this.baseUrl}/${model}/bulk-create`;
     }
 
     // Fungsi untuk menangani edit
     handleEdit(event) {
-        const id = event.target.getAttribute('data-id');
-        const model = event.target.getAttribute('data-model'); // Mengambil model dari data-model
-        console.log('Editing record with ID:', id);
+        const id = event.target.getAttribute("data-id");
+        const model = event.target.getAttribute("data-model"); // Mengambil model dari data-model
+        console.log("Editing record with ID:", id);
         // Menggunakan model dan ID untuk membangun URL dinamis
         window.location.href = `${this.baseUrl}/${model}/${id}/edit`;
     }
 
     // Fungsi untuk menangani delete
     handleDelete(event) {
-        const id = event.target.getAttribute('data-id');
+        const id = event.target.getAttribute("data-id");
         console.log(id);
         // if (confirm("Are you sure you want to delete this item?")) {
         //     this.deleteRecord(id);
@@ -105,7 +115,7 @@ class GeneralTable {
             showCancelButton: true,
             confirmButtonColor: "#d33",
             cancelButtonColor: "#3085d6",
-            confirmButtonText: "Yes, delete it!"
+            confirmButtonText: "Yes, delete it!",
         }).then((result) => {
             if (result.isConfirmed) {
                 this.deleteRecord(id);
@@ -114,8 +124,8 @@ class GeneralTable {
                     text: "Your record has been deleted.",
                     icon: "success",
                     showConfirmButton: false, // Menghilangkan tombol OK
-                    timer: 2000 // Menutup otomatis dalam 2 detik (opsional)
-                });                
+                    timer: 2000, // Menutup otomatis dalam 2 detik (opsional)
+                });
             }
         });
     }
@@ -123,8 +133,9 @@ class GeneralTable {
     async deleteRecord(id) {
         try {
             console.log(id);
-            const response = await fetch(`${this.apiUrl}/${id}`, { // Menambahkan model dalam URL
-                method: 'DELETE',
+            const response = await fetch(`${this.apiUrl}/${id}`, {
+                // Menambahkan model dalam URL
+                method: "DELETE",
                 headers: this.options.headers || {
                     Authorization: `Bearer ${document
                         .querySelector('meta[name="api-token"]')
@@ -136,10 +147,14 @@ class GeneralTable {
                 location.reload();
             } else {
                 const data = await response.json();
-                showErrorAlert(`Failed to delete record: ${data.message || "Unknown error"}`);
+                showErrorAlert(
+                    `Failed to delete record: ${
+                        data.message || "Unknown error"
+                    }`
+                );
             }
         } catch (error) {
-            console.error('Error deleting data:', error);
+            console.error("Error deleting data:", error);
             showErrorAlert("Error deleting data. Please try again.");
         }
     }
@@ -148,7 +163,7 @@ class GeneralTable {
 // Fungsi untuk menampilkan alert
 function showErrorAlert(message) {
     const alertContainer = document.getElementById("alert-container");
-    
+
     alertContainer.innerHTML = `
         <div class="alert alert-danger alert-dismissible fade show" role="alert">
             ${message}
@@ -157,4 +172,4 @@ function showErrorAlert(message) {
     `;
 }
 
-export default GeneralTable;
+export default GeneralTable;

resources/scss/dashboards/potentials/_inside_system.scss

@@ -0,0 +1,234 @@
+//
+// inside_system.scss
+//
+
+.square {
+    height: 100px;
+    width: 100px;
+    position: absolute;
+    z-index: -1;
+}
+
+.dia-top-left-bottom-right:after {
+    content: "";
+    width: 100%;
+    height: 100%;
+    position: absolute;
+
+    top: 0;
+    left: 0;
+    background: linear-gradient(
+        to top right,
+        transparent calc(50% - 2px),
+        black,
+        transparent calc(50% + 2px)
+    );
+}
+
+.dia-top-right-bottom-left:after {
+    content: "";
+    width: 100%;
+    height: 100%;
+    position: absolute;
+    top: 0;
+    left: 0;
+    background: linear-gradient(
+        to top left,
+        transparent calc(50% - 2px),
+        black,
+        transparent calc(50% + 2px)
+    );
+}
+
+.lack-of-potential-wrapper {
+    background-image: url("/public/images/bg-dashboard.jpg");
+    background-size: cover;
+    background-position: center;
+    background-color: rgba(255, 255, 255, 0.7);
+    max-width: 100vw;
+}
+
+.lack-of-potential-wrapper::before {
+    content: "";
+    position: absolute;
+    pointer-events: none;
+    top: 0;
+    left: 0;
+    width: 100%;
+    height: 100%;
+    background-color: rgba(255, 255, 255, 0.7);
+}
+// #lack-of-potential-fixed-container {
+//     min-width: 1110px;
+//     max-width: unset; /* Allow it to grow if needed */
+// }
+
+// @media (max-width: 768px) {
+//     #lack-of-potential-fixed-container {
+//         transform: scale(0.8); /* Adjust the scale as needed */
+//     }
+// }
+
+// line degrees
+.line {
+    background-color: black;
+    position: absolute;
+    height: 3px;
+}
+.home-to-non-usaha {
+    width: 100px;
+    top: 13%;
+    left: 38%;
+    transform: rotate(90deg);
+}
+.restoran-to-bapenda {
+    width: 110px;
+    top: 14%;
+    left: 60%;
+    transform: rotate(40deg);
+}
+.pbb-to-bapenda {
+    width: 80px;
+    top: 21%;
+    left: 80%;
+}
+.reklame-to-bapenda {
+    width: 120px;
+    left: 75%;
+    top: 30%;
+    transform: rotateZ(142deg);
+}
+.non-usaha-to-bapenda {
+    width: 116px;
+    left: 18%;
+    top: 33%;
+    transform: rotateZ(124deg);
+}
+.non-usaha-to-pdam {
+    width: 100px;
+    left: 38%;
+    top: 34%;
+    transform: rotateZ(90deg);
+}
+.non-usaha-to-kecamatan {
+    width: 140px;
+    left: 55%;
+    top: 33%;
+    transform: rotateZ(237deg);
+}
+.bapenda-to-usaha {
+    width: 114px;
+    left: 18%;
+    top: 49%;
+    transform: rotateZ(56deg);
+}
+.pdam-to-usaha {
+    width: 88px;
+    left: 39%;
+    top: 49%;
+    transform: rotateZ(90deg);
+}
+.kecamatan-to-usaha {
+    width: 118px;
+    left: 56%;
+    top: 50%;
+    transform: rotateZ(117deg);
+}
+.usaha-to-villa {
+    width: 100px;
+    left: 10%;
+    top: 63%;
+    transform: rotateZ(143deg);
+}
+.usaha-to-pabrik {
+    width: 150px;
+    left: 15%;
+    top: 70%;
+    transform: rotateZ(143deg);
+}
+.usaha-to-pariwisata {
+    width: 150px;
+    left: 43%;
+    top: 70%;
+    transform: rotateZ(38deg);
+}
+.usaha-to-protocol {
+    width: 106px;
+    left: 36%;
+    top: 71%;
+    transform: rotateZ(86deg);
+}
+.pariwisata-to-disbudpar {
+    width: 86px;
+    left: 54%;
+    top: 83%;
+    transform: rotateZ(150deg);
+}
+.non-usaha-to-wasdal {
+    width: 300px;
+    left: -32%;
+    top: 34%;
+    transform: rotateZ(226deg);
+}
+.usaha-to-wasdal {
+    width: 300px;
+    left: -34%;
+    top: 50%;
+    transform: rotateZ(129deg);
+}
+.wasdal-to-upt {
+    width: 155px;
+    left: 3%;
+    top: -67%;
+    transform: rotateZ(127deg);
+}
+.wasdal-to-satpol {
+    width: 155px;
+    left: 19%;
+    top: -52%;
+    transform: rotateZ(76deg);
+}
+.wasdal-to-kejari {
+    width: 182px;
+    left: 25%;
+    top: -55%;
+    transform: rotateZ(51deg);
+}
+.wasdal-to-tni {
+    width: 260px;
+    left: 29%;
+    top: -62%;
+    transform: rotateZ(30deg);
+}
+.wasdal-to-potential {
+    width: 50px;
+    left: 28%;
+    top: 41%;
+}
+.potential-to-tata-ruang {
+    width: 50px;
+    left: 72%;
+    top: 41%;
+}
+.tata-ruang-to-non-usaha {
+    width: 220px;
+    left: 0%;
+    top: 30%;
+    transform: rotateZ(144deg);
+}
+.tata-ruang-to-usaha {
+    width: 280px;
+    left: 0%;
+    top: 52%;
+    transform: rotateZ(224deg);
+}
+.tata-ruang-to-peta {
+    width: 122px;
+    left: 8%;
+    top: 41%;
+}
+.peta-to-tapak {
+    width: 30px;
+    left: 47%;
+    top: 41%;
+}

resources/scss/dashboards/potentials/_outside_system.scss

@@ -0,0 +1,59 @@
+//
+// outside_system.scss
+//
+.square {
+    height: 100px;
+    width: 100px;
+    position: absolute;
+    z-index: -1;
+}
+
+.dia-top-left-bottom-right:after {
+    content: "";
+    width: 100%;
+    height: 100%;
+    position: absolute;
+
+    top: 0;
+    left: 0;
+    background: linear-gradient(
+        to top right,
+        transparent calc(50% - 2px),
+        black,
+        transparent calc(50% + 2px)
+    );
+}
+
+.dia-top-right-bottom-left:after {
+    content: "";
+    width: 100%;
+    height: 100%;
+    position: absolute;
+    top: 0;
+    left: 0;
+    background: linear-gradient(
+        to top left,
+        transparent calc(50% - 2px),
+        black,
+        transparent calc(50% + 2px)
+    );
+}
+
+.outside-system-wrapper {
+    background-image: url("/public/images/bg-dashboard.jpg");
+    background-size: cover;
+    background-position: center;
+    background-color: rgba(255, 255, 255, 0.7);
+    max-width: 90vw;
+}
+
+.outside-system-wrapper::before {
+    content: "";
+    position: absolute;
+    pointer-events: none;
+    top: 0;
+    left: 0;
+    width: 100%;
+    height: 100%;
+    background-color: rgba(255, 255, 255, 0.7);
+}

resources/scss/plugins/_gridjs.scss

@@ -1,6 +1,6 @@
-// 
+//
 // _gridjs.scss
-// 
+//
 
 .gridjs-container {
     color: var(--#{$prefix}body-color);
@@ -13,7 +13,6 @@
     border: 1px solid var(--#{$prefix}border-color);
     border-radius: 0px;
 
-
     &::-webkit-scrollbar {
         -webkit-appearance: none;
     }
@@ -24,11 +23,12 @@
     }
 
     &::-webkit-scrollbar:horizontal {
-        height: 5px;
+        height: 15px;
     }
 
     &::-webkit-scrollbar-thumb {
-        background-color: rgba(var(--#{$prefix}dark-rgb), .075);
+        // background-color: rgba(var(--#{$prefix}dark-rgb), 0.075);
+        background-color: $primary;
         border-radius: 10px;
         padding: 5px;
         border: none;
@@ -69,15 +69,13 @@ th {
     &.gridjs-th {
         border-top: 0;
         color: var(--#{$prefix}body-color);
-        background-color: rgba(var(--#{$prefix}light-rgb), .75);
-
+        background-color: rgba(var(--#{$prefix}light-rgb), 0.75);
     }
 
     &.gridjs-th-sort {
-
         &:focus,
         &:hover {
-            background-color: rgba(var(--#{$prefix}light-rgb), .85);
+            background-color: rgba(var(--#{$prefix}light-rgb), 0.85);
         }
     }
 }
@@ -99,7 +97,6 @@ th {
 }
 
 .gridjs-pagination {
-
     .gridjs-pages button {
         background-color: transparent;
         color: var(--#{$prefix}link-color);
@@ -166,7 +163,8 @@ input.gridjs-input {
     background-color: $input-bg;
     color: $input-color;
     line-height: $input-line-height;
-    padding: $input-padding-y $input-padding-x $input-padding-y $input-padding-x * 2.5;
+    padding: $input-padding-y $input-padding-x $input-padding-y $input-padding-x *
+        2.5;
     border-radius: $input-border-radius;
     @include font-size($input-font-size);
 
@@ -203,30 +201,26 @@ th.gridjs-th-sort .gridjs-th-content {
 }
 
 button {
-
     &.gridjs-sort-asc,
     &.gridjs-sort-desc {
         background-size: 7px;
     }
 }
 
-
 // gridjs selection
 .gridjs-tr-selected {
     td {
         background-color: $table-active-bg;
     }
 
-    .gridjs-td .gridjs-checkbox[type=checkbox] {
+    .gridjs-td .gridjs-checkbox[type="checkbox"] {
         background-color: $form-check-input-checked-bg-color;
         border-color: $form-check-input-checked-border-color;
 
         @if $enable-gradients {
             background-image: escape-svg($form-check-input-checked-bg-image),
-            var(--#{$prefix}gradient);
-        }
-
-        @else {
+                var(--#{$prefix}gradient);
+        } @else {
             background-image: escape-svg($form-check-input-checked-bg-image);
         }
     }
@@ -253,7 +247,6 @@ button {
 }
 
 .gridjs-border-none {
-
     td.gridjs-td,
     th.gridjs-th {
         border-right-width: 0;
@@ -267,11 +260,10 @@ button {
 
 [data-bs-theme="dark"] {
     button {
-
         &.gridjs-sort-neutral,
         &.gridjs-sort-asc,
         &.gridjs-sort-desc {
             filter: $btn-close-white-filter;
         }
     }
-}
+}

resources/scss/style.scss

@@ -46,7 +46,8 @@
 @import "components/widgets";
 @import "components/circle";
 @import "components/custom_circle";
-@import "dashboards/lack-of-potential";
+@import "dashboards/potentials/inside_system";
+@import "dashboards/potentials/outside_system";
 
 // Plugin
 @import "plugins/simplebar";

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

@@ -11,13 +11,13 @@
 <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 class="col-12">
+        <div class="card w-100 h-100">
+            <div class="card-body">
+                <div id="table-bigdata-resumes"></div>
+            </div>
+        </div>
+    </div>
 </div>
 
 @endsection

resources/views/chatbot-pimpinan/index.blade.php

@@ -0,0 +1,77 @@
+@extends('layouts.vertical', ['subtitle' => 'Main 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' => 'Main Chatbot', 'subtitle' => 'Main Chatbot'])
+
+<div class="card">
+    <div class="card-body d-flex flex-column" style="height: 700px;">
+        <!-- Conversation Area -->
+
+        <!-- Bot Response -->
+        <div class="row flex-grow overflow-auto align-items-start">
+            <!-- Avatar -->
+            <div class="col-auto alignpe-0">
+                <img class="rounded-circle" width="45" src="/images/iconchatbot.jpeg" alt="avatar-3">
+            </div>
+
+            <!-- Nama dan Bubble Chat -->
+            <div class="col-9 w-auto">
+                <!-- Nama Bot -->
+                <p class="fw-bolder mb-1">Neng Bedas</p>
+
+                <!-- Bubble Chat -->
+                <div class="bot-response p-2 bg-light rounded mb-2 d-inline-block">
+                    <p class="mb-0">Halo! Ada yang bisa saya bantu?</p>
+
+                    <!-- Waktu (Tetap di Dalam Bubble Chat) -->
+                    <div class="sending-message-time text-end mt-1">
+                        <p class="text-muted small mb-0">Now</p>
+                    </div>
+                </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 h-100 d-flex align-items-center">
+                    <i class='bx bx-send'></i>
+                </button>
+            </div>
+        </div>
+    </div>    
+</div>
+
+@endsection
+
+@section('scripts')
+@vite(['resources/js/chatbot-pimpinan/index.js'])
+@endsection

resources/views/chatbot/index.blade.php

@@ -0,0 +1,99 @@
+@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">
+    <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 active">
+                <span class="d-block d-sm-none"><i class="bx bx-home"></i></span>
+                <span class="d-none d-sm-block fs-4">Perhitungan Retribusi</span>
+            </button>
+        </li>
+        <li class="nav-item">
+            <button id="document-validation" data-bs-toggle="tab" aria-expanded="true" class="nav-link">
+                <span class="d-block d-sm-none"><i class="bx bx-user"></i></span>
+                <span class="d-none d-sm-block fs-4">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 fs-4">Pengumpulan Data PBG</span>
+            </button>
+        </li>
+    </ul>
+    {{-- <div class="card-header">
+    </div> --}}
+    <div class="card-body d-flex flex-column" style="height: 700px;">
+        <!-- Conversation Area -->
+
+        <!-- Bot Response -->
+        <div class="row flex-grow overflow-auto align-items-start">
+            <!-- Avatar -->
+            <div class="col-auto alignpe-0">
+                <img class="rounded-circle" width="45" src="/images/iconchatbot.jpeg" alt="avatar-3">
+            </div>
+
+            <!-- Nama dan Bubble Chat -->
+            <div class="col-9 w-auto">
+                <!-- Nama Bot -->
+                <p class="fw-bolder mb-1">Neng Bedas</p>
+
+                <!-- Bubble Chat -->
+                <div class="bot-response p-2 bg-light rounded mb-2 d-inline-block">
+                    <p class="mb-0">Halo! Ada yang bisa saya bantu?</p>
+
+                    <!-- Waktu (Tetap di Dalam Bubble Chat) -->
+                    <div class="sending-message-time text-end mt-1">
+                        <p class="text-muted small mb-0">Now</p>
+                    </div>
+                </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 h-100 d-flex align-items-center">
+                    <i class='bx bx-send'></i>
+                </button>
+            </div>
+        </div>
+    </div>    
+</div>
+
+@endsection
+
+@section('scripts')
+@vite(['resources/js/chatbot/index.js'])
+@endsection

resources/views/customers/upload.blade.php

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

resources/views/dashboards/lack_of_potential.blade.php

@@ -21,7 +21,7 @@
     <div class="wrapper">
         <div id="lack-of-potential-fixed-container" class="" style="width:1400px;height:770px;position:relative;margin:auto;z-index:1;">
             <div style="position: absolute; top: 200px; left: 50px;">
-                <x-custom-circle title="Restoran" size="small" style="background-color: #0e4753;" />
+                <x-custom-circle title="Restoran" size="small" style="background-color: #0e4753;" visible_data="true" data_id="restoran-count" data_count="0" />
                 <div class="square dia-top-left-bottom-right" style="top:30px;left:50px;width:150px;height:120px;"></div>
                 <x-custom-circle title="PBB Bangunan" visible_data="true" data_id="pbb-bangunan-count" data_count="0" size="small" style="background-color: #0e4753;" />
                 <div class="square" style="width:150px;height:2px;background-color:black;left:50px;top:150px;"></div>
@@ -52,11 +52,11 @@
                 <div class="square dia-top-right-bottom-left" style="top:-110px;left:90px;width:150px;height:170px;"></div>
                 <div class="square dia-top-left-bottom-right" style="top:-110px;left:230px;width:150px;height:170px;"></div>
                 <div class="square dia-top-left-bottom-right" style="top:-110px;left:260px;width:200px;height:180px;"></div>
-                <x-custom-circle title="Villa" size="small" style="float:left;background-color: #234f6c;" />
+                <x-custom-circle title="Villa" size="small" style="float:left;background-color: #234f6c;" visible_data="true" data_id="villa-count" data_count="0" />
                 <x-custom-circle title="Pabrik" size="small" style="float:left;background-color: #234f6c;" />
                 <x-custom-circle title="Jalan Protocol" size="small" style="float:left;background-color: #234f6c;" />
                 <x-custom-circle title="Ruko" size="small" style="float:left;background-color: #234f6c;" />
-                <x-custom-circle title="Pariwisata" size="small" style="float:left;background-color: #234f6c; margin-right: 20px;" />
+                <x-custom-circle title="Pariwisata" size="small" style="float:left;background-color: #234f6c; margin-right: 20px;" visible_data="true" data_id="pariwisata-count" data_count="0" />
                 <div class="square" style="width:150px;height:2px;background-color:black;left:350px;top:50px;"></div>
                 <x-custom-circle title="DISBUDPAR" size="small" style="background-color: #3a968b;" />
             </div>
@@ -74,23 +74,20 @@
                     'visible_small_circle' => false,
                     'style' => 'margin-left:180px;top:-20px;'
                     ])
-                    @endcomponent
-                    
-                    <x-custom-circle title="Tata Ruang" size="large" style="background-color: #da6635;float:left;margin-left:250px;" />
-                    
-                </div>
+                @endcomponent
+                <x-custom-circle title="Tata Ruang" size="large" style="background-color: #da6635;float:left;margin-left:250px;" visible_data="true" data_id="tata-ruang-count" data_count="0" />
+            </div>
                 
-                <div style="position: absolute; top: 310px; left: 1150px;">
-                    <div class="square dia-top-left-bottom-right" style="top:90px;left:-100px;width:100px;height:100px;"></div>
-                    <div class="square dia-top-right-bottom-left" style="top:-110px;left:-100px;width:100px;height:100px;"></div>
-                    <x-custom-circle title="Peta" visible_data_type="true" data_type="1:5000" size="small" style="background-color: #224f6d;float:left;" />
-                    <x-custom-circle title="Tapak Bangunan" size="small" style="background-color: #2390af;float:left;margin-left:20px;" />
-                    
-                </div>
+            <div style="position: absolute; top: 310px; left: 1150px;">
+                <div class="square dia-top-left-bottom-right" style="top:90px;left:-100px;width:100px;height:100px;"></div>
+                <div class="square dia-top-right-bottom-left" style="top:-110px;left:-100px;width:100px;height:100px;"></div>
+                <x-custom-circle title="Peta" visible_data_type="true" data_type="1:5000" size="small" style="background-color: #224f6d;float:left;" />
+                <x-custom-circle title="Tapak Bangunan" size="small" style="background-color: #2390af;float:left;margin-left:20px;" />
+            </div>
                 
-                <x-custom-circle title="BPN" size="small" style="background-color: #2390af;position:absolute;left:1270px;top:440px;" />
+            <x-custom-circle title="BPN" size="small" style="background-color: #2390af;position:absolute;left:1270px;top:440px;" />
                 
-                <div style="position: absolute; top: 470px; left: 430px;">
+            <div style="position: absolute; top: 470px; left: 430px;">
                 <div class="square dia-top-right-bottom-left" style="top:-80px;left:20px;width:150px;height:120px;"></div>
                 <div class="square dia-top-right-bottom-left" style="top:-50px;left:100px;width:100px;height:100px;"></div>
                 <div class="square dia-top-left-bottom-right" style="top:-50px;left:180px;width:100px;height:100px;"></div>
@@ -105,7 +102,7 @@
 
             <div  style="position: absolute; top: 50px; left: 1100px;">
                 <x-custom-circle title="Non Usaha" size="large" style="background-color: #3a968b;margin-top:20px;" />
-                <x-custom-circle title="USAHA" size="large" style="background-color: #627c8b;margin-top:260px;" />
+                <x-custom-circle title="USAHA" size="large" style="background-color: #627c8b;margin-top:260px;" visible_data="true" data_id="tata-ruang-usaha-count" data_count="0" />
             </div>
         </div>
     </div>

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

@@ -0,0 +1,115 @@
+@extends('layouts.vertical', ['subtitle' => 'Dashboards'])
+
+@section('css')
+@vite(['resources/scss/dashboards/potentials/_inside_system.scss'])
+@endsection
+
+@section('content')
+@include('layouts.partials.page-title', ['title' => 'Dashboards', 'subtitle' => 'Dalam Sistem'])
+
+<div class="lack-of-potential-wrapper">
+    <div class="row" id="lack-of-potential-wrapper">
+        <div class="d-flex justify-content-between align-items-center mt-3 ms-2">
+            <h2 class="text-danger m-0">
+                ANALISA BIG DATA MELALUI APLIKASI <br> SIBEDAS PBG DALAM SISTEM
+            </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 id="lack-of-potential-fixed-container" class="" style="width:1400px;height:770px;position:relative;margin:auto;z-index:1;">
+            <div style="position: absolute; top: 200px; left: 50px;">
+                <x-custom-circle title="Restoran" size="small" style="background-color: #0e4753;" visible_data="true" data_id="restoran-count" data_count="0" />
+                <div class="square dia-top-left-bottom-right" style="top:30px;left:50px;width:150px;height:120px;"></div>
+                <x-custom-circle title="PBB Bangunan" visible_data="true" data_id="pbb-bangunan-count" data_count="0" size="small" style="background-color: #0e4753;" />
+                <div class="square" style="width:150px;height:2px;background-color:black;left:50px;top:150px;"></div>
+                <x-custom-circle title="Reklame" visible_data="true" data_id="reklame-count" data_count="0" size="small" style="background-color: #0e4753;" />
+                <div class="square dia-top-right-bottom-left" style="top:140px;left:50px;width:150px;height:120px;"></div>
+            </div>
+            
+            <div style="position: absolute; top: 300px; left: 200px;">
+                <div class="square dia-top-right-bottom-left" style="top:-100px;left:30px;width:150px;height:120px;"></div>
+                <div class="square dia-top-left-bottom-right" style="top:-100px;left:120px;width:120px;height:120px;"></div>
+                <x-custom-circle title="BAPENDA" size="small" style="float:left;background-color: #234f6c;" />
+                <x-custom-circle title="PDAM" visible_data="true" data_id="pdam-count" data_count="0" visible_data_type="true" data_type="Pelanggan" size="small" style="float:left;background-color: #234f6c;" />
+                <x-custom-circle title="KECAMATAN" size="small" style="float:left;background-color: #234f6c;" />
+                
+            </div>
+            
+            <div  style="position: absolute; top: 0px; left: 270px;">
+                <div class="square" style="width:5px;height:600px;background-color:black;left:70px;top:50px;"></div>
+                <div class="square dia-top-left-bottom-right" style="top:350px;left:-50px;width:120px;height:120px;"></div>
+                <div class="square dia-top-right-bottom-left" style="top:350px;left:70px;width:120px;height:120px;"></div>
+                <x-custom-circle title="Rumah Tinggal" size="small" style="background-color: #234f6c;margin:auto;" />
+                <x-custom-circle title="Non Usaha" size="large" style="background-color: #3a968b;margin-top:20px;" />
+                <x-custom-circle title="USAHA" size="large" style="background-color: #627c8b;margin-top:150px;" />
+            </div>
+            
+            <div  style="position: absolute; top: 650px; left: 110px;">
+                <div class="square dia-top-right-bottom-left" style="top:-110px;left:40px;width:200px;height:120px;"></div>
+                <div class="square dia-top-right-bottom-left" style="top:-110px;left:90px;width:150px;height:170px;"></div>
+                <div class="square dia-top-left-bottom-right" style="top:-110px;left:230px;width:150px;height:170px;"></div>
+                <div class="square dia-top-left-bottom-right" style="top:-110px;left:260px;width:200px;height:180px;"></div>
+                <x-custom-circle title="Villa" size="small" style="float:left;background-color: #234f6c;" visible_data="true" data_id="villa-count" data_count="0" />
+                <x-custom-circle title="Pabrik" size="small" style="float:left;background-color: #234f6c;" />
+                <x-custom-circle title="Jalan Protocol" size="small" style="float:left;background-color: #234f6c;" />
+                <x-custom-circle title="Ruko" size="small" style="float:left;background-color: #234f6c;" />
+                <x-custom-circle title="Pariwisata" size="small" style="float:left;background-color: #234f6c; margin-right: 20px;" visible_data="true" data_id="pariwisata-count" data_count="0" />
+                <div class="square" style="width:150px;height:2px;background-color:black;left:350px;top:50px;"></div>
+                <x-custom-circle title="DISBUDPAR" size="small" style="background-color: #3a968b;" />
+            </div>
+            
+            <div style="position: absolute; top: 280px; left: 550px;">
+                <div class="square dia-top-left-bottom-right" style="top:-110px;left:-150px;width:200px;height:180px;"></div>
+                <div class="square dia-top-right-bottom-left" style="top:70px;left:-150px;width:200px;height:130px;"></div>
+                <x-custom-circle title="Tim Wasdal Gabungan" size="large" style="background-color: #da6635;float:left" />
+                <div class="square" style="width:650px;height:5px;background-color:black;left:100px;top:75px;"></div>
+                @component('components.circle', [
+                    'document_title' => 'Kekurangan Potensi',
+                    'document_color' => '#ff5757',
+                    'document_type' => '',
+                    'document_id' => 'chart-lack-of-potential',
+                    'visible_small_circle' => false,
+                    'style' => 'margin-left:180px;top:-20px;'
+                    ])
+                @endcomponent
+                <x-custom-circle title="Tata Ruang" size="large" style="background-color: #da6635;float:left;margin-left:250px;" visible_data="true" data_id="tata-ruang-count" data_count="0" />
+            </div>
+                
+            <div style="position: absolute; top: 310px; left: 1150px;">
+                <div class="square dia-top-left-bottom-right" style="top:90px;left:-100px;width:100px;height:100px;"></div>
+                <div class="square dia-top-right-bottom-left" style="top:-110px;left:-100px;width:100px;height:100px;"></div>
+                <x-custom-circle title="Peta" visible_data_type="true" data_type="1:5000" size="small" style="background-color: #224f6d;float:left;" />
+                <x-custom-circle title="Tapak Bangunan" size="small" style="background-color: #2390af;float:left;margin-left:20px;" />
+            </div>
+                
+            <x-custom-circle title="BPN" size="small" style="background-color: #2390af;position:absolute;left:1270px;top:440px;" />
+                
+            <div style="position: absolute; top: 470px; left: 430px;">
+                <div class="square dia-top-right-bottom-left" style="top:-80px;left:20px;width:150px;height:120px;"></div>
+                <div class="square dia-top-right-bottom-left" style="top:-50px;left:100px;width:100px;height:100px;"></div>
+                <div class="square dia-top-left-bottom-right" style="top:-50px;left:180px;width:100px;height:100px;"></div>
+                <div class="square dia-top-left-bottom-right" style="top:-60px;left:240px;width:120px;height:120px;"></div>
+                <x-custom-circle title="UPT Wasdal" size="small" style="background-color: #0f4853;float:left;" />
+                <x-custom-circle title="Satpol PP" size="small" style="background-color: #0f4853;float:left;" />
+                <x-custom-circle title="KEJARI" size="small" style="background-color: #0f4853;float:left;" />
+                <x-custom-circle title="TNI & POLRI" size="small" style="background-color: #0f4853;float:left;" />
+            </div>
+
+            <x-custom-circle title="UUCK" size="small" style="background-color: #2390af;position:absolute;left:980px;top:500px;" />
+
+            <div  style="position: absolute; top: 50px; left: 1100px;">
+                <x-custom-circle title="Non Usaha" size="large" style="background-color: #3a968b;margin-top:20px;" />
+                <x-custom-circle title="USAHA" size="large" style="background-color: #627c8b;margin-top:260px;" visible_data="true" data_id="tata-ruang-usaha-count" data_count="0" />
+            </div>
+        </div>
+    </div>
+</div>
+@endsection
+
+@section('scripts')
+@vite(['resources/js/dashboards/potentials/inside_system.js'])
+@endsection
+

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

@@ -0,0 +1,73 @@
+<!-- base layout -->
+@extends('layouts.vertical', ['subtitle' => 'Dashboards'])
+<!-- style -->
+@section('css')
+@vite(['resources/scss/dashboards/potentials/_outside_system.scss'])
+@endsection
+<!-- content -->
+@section('content')
+@include('layouts.partials.page-title', ['title' => 'Dashboards', 'subtitle' => 'Luar Sistem'])
+<div class="outside-system-wrapper" id="outside-system-wrapper">
+    <div class="row">
+        <div class="d-flex justify-content-between align-items-center mt-3 ms-2">
+            <h2 class="text-danger m-0">
+                ANALISA BIG DATA MELALUI APLIKASI <br>
+                SIBEDAS PBG LUAR SISTEM
+            </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-outside-system" placeholder="Filter Date" />
+            </div>
+        </div>
+    </div>
+    <div id="outside-system-fixed-container" class="" style="width:1400px;height:770px;position:relative;margin:auto;z-index:1;">
+        <div style="position: absolute; top: 70px; left: 50px; width: 200px; height: 500px;">
+            @component('components.circle', [
+                'document_title' => 'Non Usaha',
+                'document_color' => '#399787',
+                'document_type' => 'Berkas',
+                'document_id' => 'outside-system-non-business',
+                'visible_small_circle' => true,
+                'style' => 'top:10px;'
+            ])
+            @endcomponent
+            <div class="square dia-top-right-bottom-left" style="top:10px;left:180px;width:230px;height:120px;"></div>
+            @component('components.circle', [
+                'document_title' => 'Usaha',
+                'document_color' => '#5e7c89',
+                'document_type' => 'Berkas',
+                'document_id' => 'outside-system-business',
+                'visible_small_circle' => true,
+                'style' => 'top:300px;'
+                ])
+            @endcomponent
+            <div class="square dia-top-right-bottom-left" style="top:320px;left:170px;width:200px;height:100px;"></div>
+            
+            <div class="square dia-top-left-bottom-right" style="top:120px;left:180px;width:500px;height:120px;"></div>
+            <div class="square dia-top-left-bottom-right" style="top:410px;left:180px;width:500px;height:160px;"></div>
+        </div>
+        <div style="position: absolute; top: 50px; left: 350px; width: 200px; height: 550px;">
+            <div class="square" style="width:200px;height:2px;background-color:black;left:100px;top:70px;"></div>
+            <x-custom-circle title="Keterangan Rencana Kota (KRK)" size="large" style="background-color: #306364;position: absolute;" />
+            <x-custom-circle title="Keterangan Rencana Kota (KRK)" size="large" style="background-color: #38b64b;position: absolute; top: 320px;" />
+            <div class="square" style="width:200px;height:2px;background-color:black;left:100px;top:390px;"></div>
+        </div>
+        <div style="position: absolute; top: 50px; left: 600px; width: 200px; height: 650px;">
+            <x-custom-circle title="Samirindu DPMPTSP" size="large" style="background-color: #0e4753;position: absolute; top: 0px;" />
+            <x-custom-circle title="RAB dan Gambar" size="large" style="background-color: #f0195b;position: absolute; top: 160px;" />
+            <x-custom-circle title="OSS RBA (Nasional)" size="large" style="background-color: #38b64b;position: absolute; top: 320px;" />
+            <x-custom-circle title="Dokumen Lingkungan (DLH)" size="large" style="background-color: #393536;position: absolute; top: 480px;" />
+            <div class="square dia-top-left-bottom-right" style="top:50px;left:120px;width:250px;height:250px;"></div>
+            <div class="square dia-top-left-bottom-right" style="top:230px;left:120px;width:220px;height:100px;"></div>
+            <div class="square dia-top-right-bottom-left" style="top:320px;left:120px;width:200px;height:100px;"></div>
+            <div class="square dia-top-right-bottom-left" style="top:350px;left:120px;width:250px;height:200px;"></div>
+        </div>
+        <div style="position: absolute; top: 50px; left: 900px; width: 200px; height: 550px;">
+            <x-custom-circle title="Pemohon" size="large" style="background-color: #393536;position: absolute; top: 250px;" />
+        </div>
+    </div>
+</div>
+@endsection
+<!-- javascripts -->
+@section('scripts')
+@vite(['resources/js/dashboards/potentials/outside_system.js'])
+@endsection

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

@@ -16,58 +16,49 @@
           <ul class="navbar-nav" id="navbar-nav">
                <li class="menu-title">Menu</li>
 
-               @foreach ($menus as $menu)
-                    <li class="nav-item">
-                         <!-- parent menu -->
-                         @if ($menu->parent_id == null)
-                              <a class="nav-link menu-arrow" href="#sidebar-{{$menu->id}}" data-bs-toggle="collapse" role="button"
-                                   aria-expanded="true" aria-controls="sidebar-{{$menu->id}}">
+               @php
+                    // Fungsi rekursif untuk menampilkan menu bertingkat dengan indentasi
+                    function renderMenu($menus, $depth = 0) {
+                         foreach ($menus as $menu) {
+                              $collapseId = "sidebar-" . $menu->id; // Unique ID untuk Bootstrap Collapse
+                              $hasChildren = $menu->children->count() > 0; // Cek apakah punya anak
+                              $marginLeft = $depth * 5; // Set jarak margin berdasarkan level
+
+                              echo '<li class="nav-item">';
+
+                              // Menu utama / anak (dengan dropdown jika punya anak)
+                              echo '<a class="nav-link ' . ($hasChildren ? 'menu-arrow' : '') . '" 
+                                   href="' . ($hasChildren ? "#$collapseId" : ($menu->url ? (Route::has($menu->url) ? route($menu->url, ['menu_id' => $menu->id]) : $menu->url . '?menu_id=' . $menu->id) : '#')) . '" 
+                                   ' . ($hasChildren ? 'data-bs-toggle="collapse" role="button" aria-expanded="false" aria-controls="' . $collapseId . '"' : '') . '>
                                    <span class="nav-icon">
-                                        <iconify-icon icon="{{$menu->icon}}"></iconify-icon>
+                                        <iconify-icon icon="' . $menu->icon . '"></iconify-icon>
                                    </span>
-                                   <span class="nav-text">{{$menu->name}}</span>
-                              </a>
-                         @endif
-                         <!-- children menu foreach -->
-                         @if ($menu->children->count() > 0)
-                              <div class="collapse" id="sidebar-{{$menu->id}}">
-                                   <ul class="nav sub-navbar-nav">
-                                        @foreach ( $menu->children as $child)
-                                             <li class="sub-nav-item">
-                                                  <a class="sub-nav-link" href="{{ $child->url ? (Route::has($child->url) ? route($child->url) : $child->url) : '#' }}">
-                                                  {{ $child->name }}
-                                                  </a>
-                                             </li>
-                                        @endforeach
-                                   </ul>
-                              </div>
-                         @endif
-                    </li>
-               @endforeach
+                                   <span class="nav-text">' . $menu->name . '</span>
+                              </a>';
+                              // Jika menu punya anak, buat sub-menu
+                              if ($hasChildren) {
+                                   echo '<div class="collapse" id="' . $collapseId . '">
+                                        <ul class="nav sub-navbar-nav">';
+                                   renderMenu($menu->children, $depth + 1); // Rekursi dengan level lebih dalam
+                                   echo '</ul></div>';
+                              }
+
+                              echo '</li>';
+                         }
+                    }
+               @endphp
+
+               @php 
+                    // Tampilkan hanya menu dengan parent_id NULL (menu utama)
+                    renderMenu($menus->where('parent_id', null)); 
+               @endphp
           </ul>
      </div>
 </div>
 
-
+<!-- Efek Bintang -->
 <div class="animated-stars">
-     <div class="shooting-star"></div>
-     <div class="shooting-star"></div>
-     <div class="shooting-star"></div>
-     <div class="shooting-star"></div>
-     <div class="shooting-star"></div>
-     <div class="shooting-star"></div>
-     <div class="shooting-star"></div>
-     <div class="shooting-star"></div>
-     <div class="shooting-star"></div>
-     <div class="shooting-star"></div>
-     <div class="shooting-star"></div>
-     <div class="shooting-star"></div>
-     <div class="shooting-star"></div>
-     <div class="shooting-star"></div>
-     <div class="shooting-star"></div>
-     <div class="shooting-star"></div>
-     <div class="shooting-star"></div>
-     <div class="shooting-star"></div>
-     <div class="shooting-star"></div>
-     <div class="shooting-star"></div>
+     @for ($i = 0; $i < 20; $i++)
+          <div class="shooting-star"></div>
+     @endfor
 </div>

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

@@ -22,14 +22,20 @@
 
                <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,6 +1,68 @@
 <!DOCTYPE html>
 <html lang="en" @yield('html-attribute')>
 
+<style>
+    /* .floating-icon {
+        position: fixed;
+        right: 40px;
+        bottom: 100px;
+        width: 70px;  
+        height: 70px; 
+        background: white;
+        border-radius: 50%;
+        box-shadow: 0 4px 6px rgba(0, 0, 0, 0.1);
+        cursor: pointer;
+        z-index: 1000;
+        background-image: url('/images/iconchatbot.jpeg');
+        background-size: cover;  
+        background-position: center;
+    } */
+
+
+    .floating-icon {
+        position: fixed;
+        right: 20px;
+        bottom: 20px; 
+        width: 60px;  
+        height: 60px;
+        background: white;
+        border-radius: 50%;
+        box-shadow: 0 4px 8px rgba(0, 0, 0, 0.2); 
+        cursor: pointer;
+        z-index: 1000;
+        background-image: url('/images/iconchatbot.jpeg'); 
+        background-size: contain; 
+        background-repeat: no-repeat;
+        background-position: center;
+        transition: transform 0.3s ease-in-out, box-shadow 0.3s ease-in-out;
+    }
+
+    .floating-icon:hover {
+        transform: scale(1.1);
+        box-shadow: 0 6px 12px rgba(0, 0, 0, 0.3);
+    }
+
+    @keyframes bounce {
+        0%, 100% {
+            transform: translateY(0);
+        }
+        50% {
+            transform: translateY(-10px);
+        }
+    }
+
+    .floating-icon.animate {
+        animation: bounce 1s infinite;
+    }
+     .menu-arrow {
+          transition: transform 0.3s ease;
+     }
+
+     .nav-link[aria-expanded="true"] .menu-arrow i {
+          transform: rotate(180deg);
+     }
+</style>
+
 <head>
     @include('layouts.partials/title-meta')
 
@@ -16,11 +78,14 @@
         @include('layouts.partials/topbar')
 
         <div class="page-content">
-
             <div class="container-fluid">
-
                 @yield('content')
 
+                @if (!Request::is('chatbot') && !Request::is('main-chatbot'))
+                    <a href="{{ route('chatbot.index') }}" class="floating-icon">
+                        
+                    </a>
+                @endif
             </div>
 
             @include('layouts.partials/footer')

resources/views/pbg_task/show.blade.php

@@ -1,6 +1,7 @@
 @extends('layouts.vertical', ['subtitle' => 'Detail'])
 
 @section('css')
+@vite(['node_modules/gridjs/dist/theme/mermaid.min.css'])
 @endsection
 
 @section('content')
@@ -92,6 +93,11 @@
                             <span class="d-none d-sm-block">PBG Task Prasarana</span>
                         </a>
                     </li>
+                    <li class="nav-item">
+                        <a href="#pbgTaskAssignments" data-bs-toggle="tab" aria-expanded="false" class="nav-link">
+                            <span class="d-none d-sm-block">Penugasan</span>
+                        </a>
+                    </li>
                 </ul>
             </div>
             <div class="card-body">
@@ -246,6 +252,10 @@
                             @endif
                         </div>
                     </div>
+                    <div class="tab-pane" id="pbgTaskAssignments">
+                        <input type="hidden" id="uuid" value="{{ $data->uuid }}" />
+                        <div id="table-pbg-task-assignments"></div>
+                    </div>
                 </div>
             </div>
         </div>
@@ -255,4 +265,5 @@
 @endsection
 
 @section('scripts')
+@vite(['resources/js/pbg-task/show.js'])
 @endsection

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

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

routes/api.php

@@ -15,15 +15,19 @@ use App\Http\Controllers\Api\RequestAssignmentController;
 use App\Http\Controllers\Api\RolesController;
 use App\Http\Controllers\Api\ScrapingController;
 use App\Http\Controllers\Api\SpatialPlanningsController;
+use App\Http\Controllers\Api\TaskAssignmentsController;
 use App\Http\Controllers\Api\UsersController;
 use App\Http\Controllers\Settings\SyncronizeController;
 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::post('/main-generate-text', [ChatbotController::class, 'mainGenerateText']);
 Route::group(['middleware' => 'auth:sanctum'], function (){
     // users
     Route::controller(UsersController::class)->group(function(){
@@ -99,6 +103,7 @@ Route::group(['middleware' => 'auth:sanctum'], function (){
     Route::get('/get-user-token', [SyncronizeController::class, 'getUserToken'])->name('api.task.token');
     Route::get('/get-index-integration-retribution/{uuid}', [SyncronizeController::class, 'syncIndexIntegration'])->name('api.task.inntegration');
     Route::get('/sync-task-submit/{uuid}', [SyncronizeController::class, 'syncTaskDetailSubmit'])->name('api.task.submit');
+    Route::get('/sync-task-assignments/{uuid}', [SyncronizeController::class, 'syncTaskAssignments'])->name('api.task.assignments');
 
     // menus api
     Route::controller(MenusController::class)->group(function (){
@@ -136,4 +141,9 @@ Route::group(['middleware' => 'auth:sanctum'], function (){
         Route::get('/bigdata-resume', 'index')->name('api.bigdata-resume');
         Route::get('/bigdata-report', 'bigdata_report')->name('api.bigdata-report');
     });
+
+    // task-assignments
+    Route::controller(TaskAssignmentsController::class)->group(function (){
+        Route::get('/task-assignments/{uuid}', 'index')->name('api.task-assignments');
+    });
 });

routes/console.php

@@ -8,4 +8,4 @@ Artisan::command('inspire', function () {
     $this->comment(Inspiring::quote());
 })->purpose('Display an inspiring quote')->hourly();
 
-Schedule::command("app:execute-scraping")->daily();
+Schedule::command("app:execute-scraping")->dailyAt("00:00");

routes/web.php

@@ -4,10 +4,10 @@ use App\Http\Controllers\BigdataResumesController;
 use App\Http\Controllers\BusinessOrIndustriesController;
 use App\Http\Controllers\CustomersController;
 use App\Http\Controllers\Dashboards\LackOfPotentialController;
+use App\Http\Controllers\Dashboards\PotentialsController;
 use App\Http\Controllers\DataSettingController;
 use App\Http\Controllers\Dashboards\BigDataController;
 use App\Http\Controllers\GoogleApisController;
-use App\Http\Controllers\Home\HomeController;
 use App\Http\Controllers\Master\UsersController;
 use App\Http\Controllers\MenusController;
 use App\Http\Controllers\RequestAssignment\PbgTaskController;
@@ -19,7 +19,8 @@ use App\Http\Controllers\Data\UmkmController;
 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 App\Http\Controllers\ChatbotPimpinan\ChatbotPimpinanController;
 use Illuminate\Support\Facades\Route;
 
 require __DIR__ . '/auth.php';
@@ -35,6 +36,8 @@ Route::group(['middleware' => 'auth'], function(){
         Route::get('/dashboard-pbg', [BigDataController::class, 'pbg'])->name('dashboard.pbg');
         Route::get('/lack-of-potential', [LackOfPotentialController::class, 'lack_of_potential'])->name('dashboard.lack_of_potential');
         Route::get('/maps', [GoogleApisController::class, 'index'])->name('dashboard.maps');
+        Route::get('/inside-system', [PotentialsController::class, 'inside_system'])->name('dashboard.potentials.inside_system');
+        Route::get('/outside-system', [PotentialsController::class, 'outside_system'])->name('dashboard.potentials.outside_system');
     });
     
     // settings
@@ -59,6 +62,12 @@ Route::group(['middleware' => 'auth'], function(){
     // menus
     Route::resource('/menus', MenusController::class);
 
+    // chatbot
+    Route::resource('/chatbot', ChatbotController::class);
+
+    // chatbot - pimpinan
+    Route::resource('/main-chatbot', ChatbotPimpinanController::class);
+
     // roles
     Route::resource('/roles', RolesController::class);
     Route::group(['prefix' => '/roles'], function (){
@@ -69,30 +78,30 @@ Route::group(['middleware' => 'auth'], function(){
     // data
     Route::group(['prefix' => '/data'], function(){
         // Resource route, kecuali create karena dibuat terpisah
-        Route::resource('/advertisements', AdvertisementController::class)->except(['create', 'show']);
+        Route::resource('/web-advertisements', AdvertisementController::class)->except(['create', 'show']);
 
         // Rute khusus untuk create dan bulk-create
         Route::get('/advertisements/create', [AdvertisementController::class, 'create'])->name('advertisements.create');
         Route::get('/advertisements/bulk-create', [AdvertisementController::class, 'bulkCreate'])->name('advertisements.bulk-create');
 
         // Resource route, kecuali create karena dibuat terpisah
-        Route::resource('/umkm', UmkmController::class)->except(['create', 'show']);
+        Route::resource('/web-umkm', UmkmController::class)->except(['create', 'show']);
 
         // Rute khusus untuk create dan bulk-create
         Route::get('/umkm/create', [UmkmController::class, 'create'])->name('umkm.create');
         Route::get('/umkm/bulk-create', [UmkmController::class, 'bulkCreate'])->name('umkm.bulk-create');
 
         // Resource route, kecuali create karena dibuat terpisah
-        Route::resource('/tourisms', TourismController::class)->except(['create', 'show']);
+        Route::resource('/web-tourisms', TourismController::class)->except(['create', 'show']);
         // Rute khusus untuk create dan bulk-create
         Route::get('/tourisms/create', [TourismController::class, 'create'])->name('tourisms.create');
         Route::get('/tourisms/bulk-create', [TourismController::class, 'bulkCreate'])->name('tourisms.bulk-create');
 
         // Resource route, kecuali create karena dibuat terpisah
-        Route::resource('/spatial-plannings', SpatialPlanningController::class)->except(['create', 'show']);
+        Route::resource('/web-spatial-plannings', SpatialPlanningController::class)->except(['create', 'show']);
         // Rute khusus untuk create dan bulk-create
-        Route::get('/spatial-plannings/create', [SpatialPlanningController::class, 'create'])->name('tourisms.create');
-        Route::get('/spatial-plannings/bulk-create', [SpatialPlanningController::class, 'bulkCreate'])->name('tourisms.bulk-create');
+        Route::get('/spatial-plannings/create', [SpatialPlanningController::class, 'create'])->name('spatial-plannings.create');
+        Route::get('/spatial-plannings/bulk-create', [SpatialPlanningController::class, 'bulkCreate'])->name('spatial-plannings.bulk-create');
         
 
         Route::resource('/business-industries',BusinessOrIndustriesController::class);

vite.config.js

@@ -48,13 +48,13 @@ export default defineConfig({
 
                 //js-additional
                 "resources/js/settings/syncronize/syncronize.js",
-                "resources/js/pbg-task/index.js",
                 "resources/js/settings/general/general-settings.js",
                 "resources/js/tables/common-table.js",
 
                 // dashboards
                 "resources/js/dashboards/bigdata.js",
-                "resources/js/dashboards/lack-of-potential.js",
+                "resources/js/dashboards/potentials/inside_system.js",
+                "resources/js/dashboards/potentials/outside_system.js",
                 // roles
                 "resources/js/roles/index.js",
                 "resources/js/roles/create.js",
@@ -97,6 +97,13 @@ export default defineConfig({
                 "resources/js/dashboards/pbg.js",
                 // maps
                 "resources/js/maps/maps-kml.js",
+                // laporan pimpinan
+                "resources/js/bigdata-resumes/index.js",
+                "resources/js/chatbot/index.js",
+                "resources/js/chatbot-pimpinan/index.js",
+                //pbg-task
+                "resources/js/pbg-task/index.js",
+                "resources/js/pbg-task/show.js",
             ],
             refresh: true,
         }),