feature: chatbot

app/Http/Controllers/Api/ChatbotController.php

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

app/Http/Controllers/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/Services/OpenAIService.php

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

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

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

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');
+        });
+    }
+};

package-lock.json

@@ -1,5 +1,5 @@
 {
-  "name": "sibedas-pbg-web",
+  "name": "sibedas-pbg",
   "lockfileVersion": 3,
   "requires": true,
   "packages": {

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

resources/js/chatbot/index.js

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

resources/js/dashboards/pbg.js

@@ -17,35 +17,64 @@ document.addEventListener("DOMContentLoaded", async function () {
         targetPadElement.textContent = formatCurrency(targetPadValue);
 
         // Total Potensi Berkas
-        const totalPotensiBerkas = document.getElementById("total-potensi-berkas");
+        const totalPotensiBerkas = document.getElementById(
+            "total-potensi-berkas"
+        );
         if (!totalPotensiBerkas) return;
         const totalPotensiBerkasValue = await getDataTotalPotensi(selectedYear);
-        totalPotensiBerkas.textContent = formatCurrency(totalPotensiBerkasValue.totalData);
+        totalPotensiBerkas.textContent = formatCurrency(
+            totalPotensiBerkasValue.totalData
+        );
 
         // Total Berkas Terverifikasi
-        const totalBerkasTerverifikasi = document.getElementById("total-berkas-terverifikasi");
+        const totalBerkasTerverifikasi = document.getElementById(
+            "total-berkas-terverifikasi"
+        );
         if (!totalBerkasTerverifikasi) return;
-        const totalBerkasTerverifikasiValue = await getDataVerification(selectedYear);
+        const totalBerkasTerverifikasiValue = await getDataVerification(
-        totalBerkasTerverifikasi.textContent = formatCurrency(totalBerkasTerverifikasiValue.totalData);
+            selectedYear
+        );
+        totalBerkasTerverifikasi.textContent = formatCurrency(
+            totalBerkasTerverifikasiValue.totalData
+        );
 
         // Total Kekurangan potensi
-        const totalKekuranganPotensi = document.getElementById("total-kekurangan-potensi");
+        const totalKekuranganPotensi = document.getElementById(
+            "total-kekurangan-potensi"
+        );
         if (!totalKekuranganPotensi) return;
-        const totalKekuranganPotensiValue = new Big(targetPadValue) - new Big(totalPotensiBerkasValue.totalData);
+        const totalKekuranganPotensiValue =
-        totalKekuranganPotensi.textContent = formatCurrency(totalKekuranganPotensiValue)
+            new Big(targetPadValue) -
+            new Big(totalPotensiBerkasValue.totalData);
+        totalKekuranganPotensi.textContent = formatCurrency(
+            totalKekuranganPotensiValue
+        );
 
         // Total Potensi PBG dari tata ruang
-        const totalPotensiPBGTataRuang = document.getElementById("total-potensi-pbd-tata-ruang");
+        const totalPotensiPBGTataRuang = document.getElementById(
+            "total-potensi-pbd-tata-ruang"
+        );
         if (!totalPotensiPBGTataRuang) return;
-        const totalPotensiPBGTataRuangValue = await getDataSettings("TATA_RUANG");
+        const totalPotensiPBGTataRuangValue = await getDataSettings(
-        totalPotensiPBGTataRuang.textContent = formatCurrency(totalPotensiPBGTataRuangValue);
+            "TATA_RUANG"
+        );
+        totalPotensiPBGTataRuang.textContent = formatCurrency(
+            totalPotensiPBGTataRuangValue
+        );
 
         // Total Berkas Belum terverifikasi
-        const totalBerkasBelumTerverifikasi = document.getElementById("total-berkas-belum-terverifikasi");
+        const totalBerkasBelumTerverifikasi = document.getElementById(
+            "total-berkas-belum-terverifikasi"
+        );
         if (!totalBerkasBelumTerverifikasi) return;
-        const totalBerkasBelumTerverifikasiValue = await getDataNonVerification(selectedYear);
+        const totalBerkasBelumTerverifikasiValue = await getDataNonVerification(
-        const totalBerkasBelumTerverifikasiCount = totalBerkasBelumTerverifikasiValue.countData;
+            selectedYear
-        totalBerkasBelumTerverifikasi.textContent = formatCurrency(totalBerkasBelumTerverifikasiValue.totalData);
+        );
+        const totalBerkasBelumTerverifikasiCount =
+            totalBerkasBelumTerverifikasiValue.countData;
+        totalBerkasBelumTerverifikasi.textContent = formatCurrency(
+            totalBerkasBelumTerverifikasiValue.totalData
+        );
 
         // Total Berkas Usaha
         const totalBerkasUsahaValue = await getDataBusiness(selectedYear);
@@ -58,21 +87,40 @@ document.addEventListener("DOMContentLoaded", async function () {
         const totalBerkasNonUsahaTotalData = totalBerkasNonUsahaValue.totalData;
 
         // Pie Chart Section
-        let persenUsaha = totalBerkasBelumTerverifikasiCount > 0 
+        let persenUsaha =
-            ? ((totalBerkasUsahaCount / totalBerkasBelumTerverifikasiCount) * 100).toFixed(2)
+            totalBerkasBelumTerverifikasiCount > 0
-            : "0";
+                ? (
+                      (totalBerkasUsahaCount /
+                          totalBerkasBelumTerverifikasiCount) *
+                      100
+                  ).toFixed(2)
+                : "0";
 
-        let persenNonUsaha = totalBerkasBelumTerverifikasiCount > 0 
+        let persenNonUsaha =
-            ? ((totalBerkasNonUsahaCount / totalBerkasBelumTerverifikasiCount) * 100).toFixed(2)
+            totalBerkasBelumTerverifikasiCount > 0
-            : "0";
+                ? (
+                      (totalBerkasNonUsahaCount /
+                          totalBerkasBelumTerverifikasiCount) *
+                      100
+                  ).toFixed(2)
+                : "0";
 
-        const dataSeriesPieChart = [Number(persenUsaha), Number(persenNonUsaha)]
+        const dataSeriesPieChart = [
+            Number(persenUsaha),
+            Number(persenNonUsaha),
+        ];
         const labelsPieChart = ["Berkas Usaha", "Berkas Non Usaha"];
-        document.querySelector("td[data-category='non-usaha']").textContent = formatCurrency(totalBerkasNonUsahaTotalData).toLocaleString();
+        document.querySelector("td[data-category='non-usaha']").textContent =
-        document.querySelector("td[data-category='non-usaha-percentage']").textContent = persenNonUsaha + "%";
+            formatCurrency(totalBerkasNonUsahaTotalData).toLocaleString();
+        document.querySelector(
+            "td[data-category='non-usaha-percentage']"
+        ).textContent = persenNonUsaha + "%";
 
-        document.querySelector("td[data-category='usaha']").textContent = formatCurrency(totalBerkasUsahaTotalData).toLocaleString();
+        document.querySelector("td[data-category='usaha']").textContent =
-        document.querySelector("td[data-category='usaha-percentage']").textContent = persenUsaha + "%";
+            formatCurrency(totalBerkasUsahaTotalData).toLocaleString();
+        document.querySelector(
+            "td[data-category='usaha-percentage']"
+        ).textContent = persenUsaha + "%";
 
         updatePieChart(dataSeriesPieChart, labelsPieChart);
 
@@ -81,27 +129,30 @@ document.addEventListener("DOMContentLoaded", async function () {
         console.log(allLocation);
 
         // Filter hanya data yang memiliki angka valid
-        let validLocations = allLocation.dataLocation.filter(loc => {
+        let validLocations = allLocation.dataLocation.filter((loc) => {
-            return !isNaN(parseFloat(loc.longitude)) && !isNaN(parseFloat(loc.latitude));
+            return (
+                !isNaN(parseFloat(loc.longitude)) &&
+                !isNaN(parseFloat(loc.latitude))
+            );
         });
 
         // Ubah string ke float
-        validLocations = validLocations.map(loc => ({
+        validLocations = validLocations.map((loc) => ({
             name: loc.project_name,
             longitude: parseFloat(loc.longitude),
-            latitude: parseFloat(loc.latitude)
+            latitude: parseFloat(loc.latitude),
         }));
 
-        console.log(validLocations.name)
+        console.log(validLocations.name);
 
         // Inisialisasi peta
-        var map = L.map('map').setView([-7.0230, 107.5275], 10);
+        var map = L.map("map").setView([-7.023, 107.5275], 10);
-        L.tileLayer('https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png', {
+        L.tileLayer("https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png", {
-            attribution: '© OpenStreetMap contributors'
+            attribution: "© OpenStreetMap contributors",
         }).addTo(map);
 
         // Tambahkan marker ke peta
-        validLocations.forEach(function(loc) {
+        validLocations.forEach(function (loc) {
             L.marker([loc.latitude, loc.longitude])
                 .addTo(map)
                 .bindPopup(`<b>${loc.name}</b>`) // Popup saat diklik
@@ -109,22 +160,40 @@ document.addEventListener("DOMContentLoaded", async function () {
         });
 
         // Realisasi terbit PBG
-        const totalRealisasiTerbitPBG = document.getElementById("realisasi-terbit-pbg");
+        const totalRealisasiTerbitPBG = document.getElementById(
+            "realisasi-terbit-pbg"
+        );
         if (!totalRealisasiTerbitPBG) return;
-        const totalRealisasiTerbitPBGValue = await getDataSettings("REALISASI_TERBIT_PBG_SUM");
+        const totalRealisasiTerbitPBGValue = await getDataSettings(
-        totalRealisasiTerbitPBG.textContent = formatCurrency(totalRealisasiTerbitPBGValue);
+            "REALISASI_TERBIT_PBG_SUM"
+        );
+        totalRealisasiTerbitPBG.textContent = formatCurrency(
+            totalRealisasiTerbitPBGValue
+        );
 
         // Menunggu Klik DPMPTSP
-        const totalMenungguKlikDpmptsp = document.getElementById("waiting-click-dpmptsp");
+        const totalMenungguKlikDpmptsp = document.getElementById(
+            "waiting-click-dpmptsp"
+        );
         if (!totalMenungguKlikDpmptsp) return;
-        const totalMenungguKlikDpmptspValue = await getDataSettings("MENUNGGU_KLIK_DPMPTSP_SUM");
+        const totalMenungguKlikDpmptspValue = await getDataSettings(
-        totalMenungguKlikDpmptsp.textContent = formatCurrency(totalMenungguKlikDpmptspValue);
+            "MENUNGGU_KLIK_DPMPTSP_SUM"
+        );
+        totalMenungguKlikDpmptsp.textContent = formatCurrency(
+            totalMenungguKlikDpmptspValue
+        );
 
         // Proses Dinas Teknis
-        const totalProsesDinasTeknis = document.getElementById("processing-technical-services");
+        const totalProsesDinasTeknis = document.getElementById(
+            "processing-technical-services"
+        );
         if (!totalProsesDinasTeknis) return;
-        const totalProsesDinasTeknisValue = await getDataSettings("PROSES_DINAS_TEKNIS_SUM");
+        const totalProsesDinasTeknisValue = await getDataSettings(
-        totalProsesDinasTeknis.textContent = formatCurrency(totalProsesDinasTeknisValue);
+            "PROSES_DINAS_TEKNIS_SUM"
+        );
+        totalProsesDinasTeknis.textContent = formatCurrency(
+            totalProsesDinasTeknisValue
+        );
 
         // Load Tabel Baru di Update
         const tableLastUpdated = new GeneralTable(
@@ -172,25 +241,32 @@ document.addEventListener("DOMContentLoaded", async function () {
 
         tableSKPBGTerbit.init();
 
-        document.querySelector("#pbg-filter-by-updated-at .gridjs-search").hidden = true;
+        document.querySelector(
-        document.querySelector("#pbg-filter-by-updated-at .gridjs-footer").hidden = true;
+            "#pbg-filter-by-updated-at .gridjs-search"
-        document.querySelector("#pbg-filter-by-status .gridjs-search").hidden = true;
+        ).hidden = true;
-        document.querySelector("#pbg-filter-by-status .gridjs-footer").hidden = true;
+        document.querySelector(
+            "#pbg-filter-by-updated-at .gridjs-footer"
+        ).hidden = true;
+        document.querySelector(
+            "#pbg-filter-by-status .gridjs-search"
+        ).hidden = true;
+        document.querySelector(
+            "#pbg-filter-by-status .gridjs-footer"
+        ).hidden = true;
     }
 
     await updateDataByYear(yearPicker.value);
 
     yearPicker.addEventListener("change", async function () {
-        console.log("event change dropdown")
+        console.log("event change dropdown");
         await updateDataByYear(yearPicker.value);
     });
-
 });
 
 async function getDataSettings(string_key) {
     try {
         const response = await fetch(
-            `${GlobalConfig.apiHost}/api/api-data-settings?search=${string_key}`,
+            `${GlobalConfig.apiHost}/api/data-settings?search=${string_key}`,
             {
                 credentials: "include",
                 headers: {
@@ -224,7 +300,7 @@ async function getDataTotalPotensi(year) {
                     Authorization: `Bearer ${
                         document.querySelector("meta[name='api-token']").content
                     }`,
-                    "Content-Type": "application/json"
+                    "Content-Type": "application/json",
                 },
             }
         );
@@ -251,8 +327,7 @@ async function getDataVerification(year) {
                 credentials: "include",
                 headers: {
                     Authorization: `Bearer ${
-                        document.querySelector("meta[name='api-token']")
+                        document.querySelector("meta[name='api-token']").content
-                            .content
                     }`,
                     "Content-Type": "application/json",
                 },
@@ -263,26 +338,25 @@ async function getDataVerification(year) {
             console.error("Network response was not ok", response);
         }
 
-        const data = await response.json()
+        const data = await response.json();
         return {
             totalData: data.data.total,
         };
     } catch (error) {
         console.error("Error fetching chart data:", error);
-        return 0
+        return 0;
     }
 }
 
 async function getDataNonVerification(year) {
     try {
-        const response = await fetch (
+        const response = await fetch(
             `${GlobalConfig.apiHost}/api/non-verification-documents?year=${year}`,
             {
                 credentials: "include",
                 headers: {
                     Authorization: `Bearer ${
-                        document.querySelector("meta[name='api-token']")
+                        document.querySelector("meta[name='api-token']").content
-                            .content
                     }`,
                     "Content-Type": "application/json",
                 },
@@ -297,7 +371,7 @@ async function getDataNonVerification(year) {
         return {
             countData: data.data.count,
             totalData: data.data.total,
-        }
+        };
     } catch (error) {
         console.error("Error fetching chart data:", error);
         return 0;
@@ -312,8 +386,7 @@ async function getDataBusiness(year) {
                 credentials: "include",
                 headers: {
                     Authorization: `Bearer ${
-                        document.querySelector("meta[name='api-token']")
+                        document.querySelector("meta[name='api-token']").content
-                            .content
                     }`,
                     "Content-Type": "application/json",
                 },
@@ -343,8 +416,7 @@ async function getDataNonBusiness(year) {
                 credentials: "include",
                 headers: {
                     Authorization: `Bearer ${
-                        document.querySelector("meta[name='api-token']")
+                        document.querySelector("meta[name='api-token']").content
-                            .content
                     }`,
                     "Content-Type": "application/json",
                 },
@@ -357,8 +429,8 @@ async function getDataNonBusiness(year) {
         const data = await response.json();
         return {
             countData: data.data.count,
-            totalData: data.data.total
+            totalData: data.data.total,
-        }
+        };
     } catch (error) {
         console.error("Error fetching chart data:", error);
         return 0;
@@ -373,8 +445,7 @@ async function getAllLocation() {
                 credentials: "include",
                 headers: {
                     Authorization: `Bearer ${
-                        document.querySelector("meta[name='api-token']")
+                        document.querySelector("meta[name='api-token']").content
-                            .content
                     }`,
                     "Content-Type": "application/json",
                 },
@@ -386,7 +457,7 @@ async function getAllLocation() {
         const data = await response.json();
         return {
             dataLocation: data.data,
-        }
+        };
     } catch (error) {
         console.error("Error fetching chart data:", error);
         return 0;
@@ -397,38 +468,40 @@ async function initChart() {
     var options = {
         chart: {
             height: 180,
-            type: 'donut',
+            type: "donut",
         },
         series: [0, 0], // Inisialisasi dengan nilai awal
         labels: ["Berkas Usaha", "Berkas Non Usaha"],
         legend: {
-            show: false
+            show: false,
         },
         stroke: {
-            width: 0
+            width: 0,
         },
         plotOptions: {
             pie: {
                 donut: {
-                    size: '60%',
+                    size: "60%",
-                }
+                },
-            }
+            },
         },
         colors: ["#7e67fe", "#17c553"],
         dataLabels: {
-            enabled: false
+            enabled: false,
         },
-        responsive: [{
+        responsive: [
-            breakpoint: 480,
+            {
-            options: {
+                breakpoint: 480,
-                chart: {
+                options: {
-                    width: 200
+                    chart: {
-                }
+                        width: 200,
-            }
+                    },
-        }],
+                },
+            },
+        ],
         fill: {
-            type: 'gradient'
+            type: "gradient",
-        }
+        },
     };
 
     chart = new ApexCharts(document.querySelector("#conversions"), options);
@@ -447,7 +520,7 @@ async function updatePieChart(dataSeries, labels) {
     // Perbarui label jika diperlukan
     if (Array.isArray(labels) && labels.length === dataSeries.length) {
         chart.updateOptions({
-            labels: labels
+            labels: labels,
         });
     }
 }
@@ -457,7 +530,7 @@ function formatCurrency(number) {
     return new Intl.NumberFormat("id-ID", {
         style: "currency",
         currency: "IDR",
-        minimumFractionDigits: 0
+        minimumFractionDigits: 0,
     }).format(number);
 }
 
@@ -467,4 +540,4 @@ const pbgTaskColumns = [
     "Nomor Registrasi",
     "Nomor Dokumen",
     "Alamat",
-]
+];

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

@@ -20,9 +20,9 @@ const dataTourismsColumns = [
         name: "Actions",
         widht: "120px",
         formatter: function (cell, row) {
-            const id = row.cells[10].data;
+            const id = row.cells[11].data;
-            const long = row.cells[8].data;
+            const long = row.cells[9].data;
-            const lat = row.cells[9].data;
+            const lat = row.cells[10].data;
             const model = "data/tourisms";
             return gridjs.html(`
                 <div class="d-flex justify-items-end gap-10">

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

@@ -27,7 +27,7 @@ const dataUMKMColumns = [
         name: "Actions",
         widht: "120px",
         formatter: function(cell, row) {
-            const id = row.cells[18].data;
+            const id = row.cells[19].data;
             const model = "data/umkm";
             return gridjs.html(`
                 <div class="d-flex justify-items-end gap-10">

resources/views/chatbot/index.blade.php

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

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

routes/api.php

@@ -21,9 +21,11 @@ use App\Http\Controllers\Api\AdvertisementController;
 use App\Http\Controllers\Api\UmkmController;
 use App\Http\Controllers\Api\TourismController;
 use App\Http\Controllers\Api\SpatialPlanningController;
+use App\Http\Controllers\Api\ChatbotController;
 use Illuminate\Support\Facades\Route;
 
 Route::post('/login', [UsersController::class, 'login'])->name('api.user.login');
+Route::post('/generate-text', [ChatbotController::class, 'generateText']);
 Route::group(['middleware' => 'auth:sanctum'], function (){
     // users
     Route::controller(UsersController::class)->group(function(){

routes/web.php

@@ -19,6 +19,7 @@ use App\Http\Controllers\Data\TourismController;
 use App\Http\Controllers\Data\SpatialPlanningController;
 use App\Http\Controllers\Report\ReportTourismController;
 use App\Http\Controllers\SpatialPlanningsController;
+use App\Http\Controllers\Chatbot\ChatbotController;
 use Illuminate\Support\Facades\Route;
 
 require __DIR__ . '/auth.php';
@@ -58,6 +59,9 @@ Route::group(['middleware' => 'auth'], function(){
     // menus
     Route::resource('/menus', MenusController::class);
 
+    // chatbot
+    Route::resource('/chatbot', ChatbotController::class);
+
     // roles
     Route::resource('/roles', RolesController::class);
     Route::group(['prefix' => '/roles'], function (){

vite.config.js

@@ -98,6 +98,7 @@ export default defineConfig({
                 "resources/js/customers/index.js",
                 "resources/js/customers/create.js",
                 "resources/js/customers/edit.js",
+		"resources/js/dashboards/pbg.js"
             ],
             refresh: true,
         }),