feature: set role previledge access

fix:chatbot ui

app/Http/Controllers/Api/ChatbotController.php

@@ -7,6 +7,7 @@ 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
 {
@@ -19,7 +20,6 @@ class ChatbotController extends Controller
 
     public function generateText(Request $request)
     {
-        info($request);
         $request->validate([
             'tab_active' => 'required|string',
             'prompt' => 'required|string',
@@ -33,52 +33,87 @@ class ChatbotController extends Controller
             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);
+        // info($main_content);
 
-        // Klasifikasi apakah pertanyaan butuh database atau bisa dijawab langsung
-        $classifyResponse = $this->openAIService->generateClassifyMainContent($request->input('prompt'), $main_content);
+        $queryResponse = $this->openAIService->generateQueryBasedMainContent($request->input('prompt'), $main_content, $chatHistory);
         
-        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);
-            }
+        $firstValidation = $this->openAIService->validateSyntaxQuery($queryResponse);
+        $secondValidation = $this->openAIService->validateSyntaxQuery($queryResponse);
 
-            // Validasi query dua kali sebelum eksekusi
-            if (
-                $this->openAIService->validateSyntaxQuery($queryResponse) === "VALID" &&
-                $this->openAIService->validateSyntaxQuery($queryResponse) === "VALID"
-            ) {
-                info($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]);
+        return response()->json(['response' => $finalGeneratedText, 'nlpResponse' => $queryResponse]);
     }
 
-            return response()->json(['response' => ''], 400);
+    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);
             }
 
-        if ($classifyResponse === "GENERAL") {
-            $nlpResult = $this->openAIService->generateGeneralText($request->input('prompt'), $main_content);
+            $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]);
+            
+            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);
+        }
     }
 
-        return response()->json(['response' => ''], 500);
-    }
-
-
-    private function classifyContent(string $prompt) {
-        $classifyResponse = $this->openAIService->generateClassifyContent($prompt);
-        return $classifyResponse;
-    }
 }

app/Http/Controllers/Api/TourismController.php

@@ -39,7 +39,7 @@ class TourismController extends Controller
             $tourisms->village_name = $village ? $village->village_name : null;
 
             $district = DB::table('districts')->where('district_code', $tourisms->district_code)->first();
-            $tourisms->district_name = $village ? $village->village_name : null;
+            $tourisms->district_name = $district ? $district->district_name : null;
             return $tourisms;
         });
 

app/Http/Controllers/Api/UsersController.php

@@ -11,6 +11,7 @@ use App\Traits\GlobalApiResponse;
 use Illuminate\Support\Facades\DB;
 use Illuminate\Support\Facades\Hash;
 use Illuminate\Http\Request;
+use Illuminate\Support\Facades\Log;
 
 class UsersController extends Controller
 {

app/Http/Controllers/Auth/AuthenticatedSessionController.php

@@ -38,8 +38,6 @@ class AuthenticatedSessionController extends Controller
 
         // Buat token untuk API
         $token = $user->createToken(env('APP_KEY'))->plainTextToken;
-
-        // Simpan token di session (bisa digunakan di JavaScript)
         session(['api_token' => $token]);
 
         return redirect()->intended(RouteServiceProvider::HOME);

app/Http/Controllers/BusinessOrIndustriesController.php

@@ -4,15 +4,36 @@ namespace App\Http\Controllers;
 
 use App\Models\BusinessOrIndustry;
 use Illuminate\Http\Request;
+use Illuminate\Support\Facades\DB;
+use Illuminate\Support\Facades\Auth;
 
 class BusinessOrIndustriesController extends Controller
 {
     /**
      * Display a listing of the resource.
      */
-    public function index()
+    public function index(Request $request)
     {
-        return view('business-industries.index');
+        $menuId = $request->query('menu_id');
+        $user = Auth::user();
+        $userId = $user->id;
+
+        // Ambil role_id yang dimiliki user
+        $roleIds = DB::table('user_role')
+            ->where('user_id', $userId)
+            ->pluck('role_id');
+
+        // Ambil data akses berdasarkan role_id dan menu_id
+        $roleAccess = DB::table('role_menu')
+            ->whereIn('role_id', $roleIds)
+            ->where('menu_id', $menuId)
+            ->first();
+
+        // Pastikan roleAccess tidak null sebelum mengakses properti
+        $creator = $roleAccess->allow_create ?? 0;
+        $updater = $roleAccess->allow_update ?? 0;
+        $destroyer = $roleAccess->allow_destroy ?? 0;
+        return view('business-industries.index', compact('creator', 'updater', 'destroyer'));
     }
 
     /**

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

@@ -4,12 +4,33 @@ namespace App\Http\Controllers;
 
 use App\Models\Customer;
 use Illuminate\Http\Request;
+use Illuminate\Support\Facades\Auth;
 
 class CustomersController extends Controller
 {
-    public function index()
+    public function index(Request $request)
     {
-        return view('customers.index');
+        $menuId = $request->query('menu_id');
+        $user = Auth::user();
+        $userId = $user->id;
+
+        // Ambil role_id yang dimiliki user
+        $roleIds = DB::table('user_role')
+            ->where('user_id', $userId)
+            ->pluck('role_id');
+
+        // Ambil data akses berdasarkan role_id dan menu_id
+        $roleAccess = DB::table('role_menu')
+            ->whereIn('role_id', $roleIds)
+            ->where('menu_id', $menuId)
+            ->first();
+
+        // Pastikan roleAccess tidak null sebelum mengakses properti
+        $creator = $roleAccess->allow_create ?? 0;
+        $updater = $roleAccess->allow_update ?? 0;
+        $destroyer = $roleAccess->allow_destroy ?? 0;
+
+        return view('customers.index', compact('creator', 'updater', 'destroyer'));
     }
     public function create()
     {

app/Http/Controllers/Data/AdvertisementController.php

@@ -6,15 +6,36 @@ use App\Http\Controllers\Controller;
 use App\Models\Advertisement;
 use Illuminate\Http\Request;
 use Illuminate\Support\Facades\DB;
+use Illuminate\Support\Facades\Auth;
 
 class AdvertisementController extends Controller
 {
     /**
      * Display a listing of the resource.
      */
-    public function index()
+    public function index(Request $request)
     {
-        return view('data.advertisements.index');
+        $menuId = $request->query('menu_id');
+        $user = Auth::user();
+        $userId = $user->id;
+
+        // Ambil role_id yang dimiliki user
+        $roleIds = DB::table('user_role')
+            ->where('user_id', $userId)
+            ->pluck('role_id');
+
+        // Ambil data akses berdasarkan role_id dan menu_id
+        $roleAccess = DB::table('role_menu')
+            ->whereIn('role_id', $roleIds)
+            ->where('menu_id', $menuId)
+            ->first();
+
+        // Pastikan roleAccess tidak null sebelum mengakses properti
+        $creator = $roleAccess->allow_create ?? 0;
+        $updater = $roleAccess->allow_update ?? 0;
+        $destroyer = $roleAccess->allow_destroy ?? 0;
+
+        return view('data.advertisements.index', compact('creator', 'updater', 'destroyer'));
     }
 
     /**
@@ -62,7 +83,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/SpatialPlanningController.php

@@ -5,15 +5,37 @@ namespace App\Http\Controllers\Data;
 use App\Http\Controllers\Controller;
 use App\Models\SpatialPlanning;
 use Illuminate\Http\Request;
+use Illuminate\Support\Facades\DB;
+use Illuminate\Support\Facades\Auth;
 
 class SpatialPlanningController extends Controller
 {
     /**
      * Display a listing of the resource.
      */
-    public function index()
+    public function index(Request $request)
     {
-        return view('data.spatialPlannings.index');
+        $menuId = $request->query('menu_id');
+        $user = Auth::user();
+        $userId = $user->id;
+
+        // Ambil role_id yang dimiliki user
+        $roleIds = DB::table('user_role')
+            ->where('user_id', $userId)
+            ->pluck('role_id');
+
+        // Ambil data akses berdasarkan role_id dan menu_id
+        $roleAccess = DB::table('role_menu')
+            ->whereIn('role_id', $roleIds)
+            ->where('menu_id', $menuId)
+            ->first();
+
+        // Pastikan roleAccess tidak null sebelum mengakses properti
+        $creator = $roleAccess->allow_create ?? 0;
+        $updater = $roleAccess->allow_update ?? 0;
+        $destroyer = $roleAccess->allow_destroy ?? 0;
+
+        return view('data.spatialPlannings.index', compact('creator', 'updater', 'destroyer'));
     }
 
     /**

app/Http/Controllers/Data/TourismController.php

@@ -6,15 +6,35 @@ use App\Http\Controllers\Controller;
 use App\Models\Tourism;
 use Illuminate\Http\Request;
 use Illuminate\Support\Facades\DB;
+use Illuminate\Support\Facades\Auth;
 
 class TourismController extends Controller
 {
     /**
      * Display a listing of the resource
      */
-    public function index()
+    public function index(Request $request)
     {
-        return view('data.tourisms.index');
+        $menuId = $request->query('menu_id');
+        $user = Auth::user();
+        $userId = $user->id;
+
+        // Ambil role_id yang dimiliki user
+        $roleIds = DB::table('user_role')
+            ->where('user_id', $userId)
+            ->pluck('role_id');
+
+        // Ambil data akses berdasarkan role_id dan menu_id
+        $roleAccess = DB::table('role_menu')
+            ->whereIn('role_id', $roleIds)
+            ->where('menu_id', $menuId)
+            ->first();
+
+        // Pastikan roleAccess tidak null sebelum mengakses properti
+        $creator = $roleAccess->allow_create ?? 0;
+        $updater = $roleAccess->allow_update ?? 0;
+        $destroyer = $roleAccess->allow_destroy ?? 0;
+        return view('data.tourisms.index', compact('creator', 'updater', 'destroyer'));
     }
 
     /**
@@ -58,7 +78,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

@@ -6,15 +6,35 @@ use App\Http\Controllers\Controller;
 use App\Models\Umkm;
 use Illuminate\Http\Request;
 use Illuminate\Support\Facades\DB;
+use Illuminate\Support\Facades\Auth;
 
 class UmkmController extends Controller
 {
     /**
      * Display a listing of the resource.
      */
-    public function index()
+    public function index(Request $request)
     {
-        return view('data.umkm.index');
+        $menuId = $request->query('menu_id');
+        $user = Auth::user();
+        $userId = $user->id;
+
+        // Ambil role_id yang dimiliki user
+        $roleIds = DB::table('user_role')
+            ->where('user_id', $userId)
+            ->pluck('role_id');
+
+        // Ambil data akses berdasarkan role_id dan menu_id
+        $roleAccess = DB::table('role_menu')
+            ->whereIn('role_id', $roleIds)
+            ->where('menu_id', $menuId)
+            ->first();
+        
+        // Pastikan roleAccess tidak null sebelum mengakses properti
+        $creator = $roleAccess->allow_create ?? 0;
+        $updater = $roleAccess->allow_update ?? 0;
+        $destroyer = $roleAccess->allow_destroy ?? 0;
+        return view('data.umkm.index', compact('creator', 'updater', 'destroyer'));
     }
 
     /**
@@ -60,7 +80,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/DataSettingController.php

@@ -8,15 +8,36 @@ use Exception;
 use Illuminate\Support\Facades\DB;
 use Illuminate\Support\Facades\Log;
 use Illuminate\Support\Facades\Request;
+use Illuminate\Support\Facades\Auth;
+use Illuminate\Http\Request as IndexRequest;
 
 class DataSettingController extends Controller
 {
     /**
      * Display a listing of the resource.
      */
-    public function index()
+    public function index(IndexRequest $request)
     {
-        return view("data-settings.index");
+        $menuId = $request->query('menu_id');
+        $user = Auth::user();
+        $userId = $user->id;
+
+        // Ambil role_id yang dimiliki user
+        $roleIds = DB::table('user_role')
+            ->where('user_id', $userId)
+            ->pluck('role_id');
+
+        // Ambil data akses berdasarkan role_id dan menu_id
+        $roleAccess = DB::table('role_menu')
+            ->whereIn('role_id', $roleIds)
+            ->where('menu_id', $menuId)
+            ->first();
+
+        // Pastikan roleAccess tidak null sebelum mengakses properti
+        $creator = $roleAccess->allow_create ?? 0;
+        $updater = $roleAccess->allow_update ?? 0;
+        $destroyer = $roleAccess->allow_destroy ?? 0;
+        return view("data-settings.index", compact('creator', 'updater', 'destroyer'));
     }
 
     /**

app/Http/Controllers/Master/UsersController.php

@@ -13,6 +13,7 @@ use Illuminate\Support\Facades\Hash;
 use App\Models\User;
 use App\Traits\GlobalApiResponse;
 use Illuminate\Auth\Events\Registered;
+use Illuminate\Support\Facades\Auth;
 
 class UsersController extends Controller
 {
@@ -21,9 +22,29 @@ class UsersController extends Controller
         $users = User::all();
         return $this->resSuccess($users);
     }
-    public function index(){
+    public function index(Request $request){
+        $menuId = $request->query('menu_id');
+        $user = Auth::user();
+        $userId = $user->id;
+
+        // Ambil role_id yang dimiliki user
+        $roleIds = DB::table('user_role')
+            ->where('user_id', $userId)
+            ->pluck('role_id');
+
+        // Ambil data akses berdasarkan role_id dan menu_id
+        $roleAccess = DB::table('role_menu')
+            ->whereIn('role_id', $roleIds)
+            ->where('menu_id', $menuId)
+            ->first();
+
+        // Pastikan roleAccess tidak null sebelum mengakses properti
+        $creator = $roleAccess->allow_create ?? 0;
+        $updater = $roleAccess->allow_update ?? 0;
+        $destroyer = $roleAccess->allow_destroy ?? 0;
+
         $users = User::paginate();
-        return view('master.users.index', compact('users'));
+        return view('master.users.index', compact('users', 'creator', 'updater', 'destroyer'));
     }
     public function create(){
         $roles = Role::all();

app/Http/Controllers/MenusController.php

@@ -6,15 +6,36 @@ use App\Http\Requests\MenuRequest;
 use App\Models\Menu;
 use Illuminate\Http\Request;
 use Illuminate\Support\Facades\DB;
+use Illuminate\Support\Facades\Auth;
 
 class MenusController extends Controller
 {
     /**
      * Display a listing of the resource.
      */
-    public function index()
+    public function index(Request $request)
     {
-        return view('menus.index');
+        $menuId = $request->query('menu_id');
+        $user = Auth::user();
+        $userId = $user->id;
+
+        // Ambil role_id yang dimiliki user
+        $roleIds = DB::table('user_role')
+            ->where('user_id', $userId)
+            ->pluck('role_id');
+
+        // Ambil data akses berdasarkan role_id dan menu_id
+        $roleAccess = DB::table('role_menu')
+            ->whereIn('role_id', $roleIds)
+            ->where('menu_id', $menuId)
+            ->first();
+
+        // Pastikan roleAccess tidak null sebelum mengakses properti
+        $creator = $roleAccess->allow_create ?? 0;
+        $updater = $roleAccess->allow_update ?? 0;
+        $destroyer = $roleAccess->allow_destroy ?? 0;
+
+        return view('menus.index', compact('creator', 'updater', 'destroyer'));
     }
 
     /**

app/Http/Controllers/RequestAssignment/PbgTaskController.php

@@ -5,15 +5,37 @@ namespace App\Http\Controllers\RequestAssignment;
 use App\Http\Controllers\Controller;
 use App\Models\PbgTask;
 use Illuminate\Http\Request;
+use Illuminate\Support\Facades\DB;
+use Illuminate\Support\Facades\Auth;
 
 class PbgTaskController extends Controller
 {
     /**
      * Display a listing of the resource.
      */
-    public function index()
+    public function index(Request $request)
     {
-        return view('pbg_task.index');
+        $menuId = $request->query('menu_id');
+        $user = Auth::user();
+        $userId = $user->id;
+
+        // Ambil role_id yang dimiliki user
+        $roleIds = DB::table('user_role')
+            ->where('user_id', $userId)
+            ->pluck('role_id');
+
+        // Ambil data akses berdasarkan role_id dan menu_id
+        $roleAccess = DB::table('role_menu')
+            ->whereIn('role_id', $roleIds)
+            ->where('menu_id', $menuId)
+            ->first();
+
+        // Pastikan roleAccess tidak null sebelum mengakses properti
+        $creator = $roleAccess->allow_create ?? 0;
+        $updater = $roleAccess->allow_update ?? 0;
+        $destroyer = $roleAccess->allow_destroy ?? 0;
+
+        return view('pbg_task.index', compact('creator', 'updater', 'destroyer'));
     }
 
     /**
@@ -37,7 +59,7 @@ class PbgTaskController extends Controller
      */
     public function show(string $id)
     {
-        $data = PbgTask::with(['pbg_task_retributions','pbg_task_index_integrations', 'pbg_task_retributions.pbg_task_prasarana'])->findOrFail($id);
+        $data = PbgTask::with(['pbg_task_retributions','pbg_task_index_integrations', 'pbg_task_retributions.pbg_task_prasarana', 'taskAssignments'])->findOrFail($id);
         return view("pbg_task.show", compact("data"));
     }
 

app/Http/Controllers/RolesController.php

@@ -10,15 +10,36 @@ use Illuminate\Http\Request;
 use Illuminate\Support\Facades\DB;
 use Illuminate\Support\Facades\Log;
 use Illuminate\Support\Facades\Schema;
+use Illuminate\Support\Facades\Auth;
 
 class RolesController extends Controller
 {
     /**
      * Display a listing of the resource.
      */
-    public function index()
+    public function index(Request $request)
     {
-        return view("roles.index");
+        $menuId = $request->query('menu_id');
+        $user = Auth::user();
+        $userId = $user->id;
+
+        // Ambil role_id yang dimiliki user
+        $roleIds = DB::table('user_role')
+            ->where('user_id', $userId)
+            ->pluck('role_id');
+
+        // Ambil data akses berdasarkan role_id dan menu_id
+        $roleAccess = DB::table('role_menu')
+            ->whereIn('role_id', $roleIds)
+            ->where('menu_id', $menuId)
+            ->first();
+
+        // Pastikan roleAccess tidak null sebelum mengakses properti
+        $creator = $roleAccess->allow_create ?? 0;
+        $updater = $roleAccess->allow_update ?? 0;
+        $destroyer = $roleAccess->allow_destroy ?? 0;
+
+        return view("roles.index", compact('creator', 'updater', 'destroyer'));
     }
 
     /**

app/Http/Controllers/Settings/SyncronizeController.php

@@ -13,7 +13,27 @@ class SyncronizeController extends Controller
         $this->service_simbg = $service_simbg;
     }
     public function index(Request $request){
-        return view('settings.syncronize.index');
+        $menuId = $request->query('menu_id');
+        $user = Auth::user();
+        $userId = $user->id;
+
+        // Ambil role_id yang dimiliki user
+        $roleIds = DB::table('user_role')
+            ->where('user_id', $userId)
+            ->pluck('role_id');
+
+        // Ambil data akses berdasarkan role_id dan menu_id
+        $roleAccess = DB::table('role_menu')
+            ->whereIn('role_id', $roleIds)
+            ->where('menu_id', $menuId)
+            ->first();
+
+        // Pastikan roleAccess tidak null sebelum mengakses properti
+        $creator = $roleAccess->allow_create ?? 0;
+        $updater = $roleAccess->allow_update ?? 0;
+        $destroyer = $roleAccess->allow_destroy ?? 0;
+
+        return view('settings.syncronize.index', compact('creator', 'updater', 'destroyer'));
     }
 
     public function syncPbgTask(){
@@ -33,7 +53,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 +62,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/Jobs/SyncronizeSIMBG.php

@@ -14,6 +14,7 @@ class SyncronizeSIMBG implements ShouldQueue
 {
     use Dispatchable, InteractsWithQueue, Queueable, SerializesModels;
 
+    public $tries = 1;
 
     public function __construct()
     {

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'
+    ];
+
+    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

@@ -19,6 +19,9 @@ 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/OpenAIService.php

@@ -4,6 +4,7 @@ namespace App\Services;
 
 use OpenAI;
 use Illuminate\Support\Facades\Storage;
+use Illuminate\Support\Facades\Log;
 
 class OpenAIService
 {
@@ -11,54 +12,11 @@ class OpenAIService
 
     public function __construct()
     {
+        // $this->client = OpenAI::client(env('OPENAI_API_KEY'));
         $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)
+    public function generateQueryBasedMainContent($prompt, $mainContent, $chatHistory)
     {
         // Load file JSON
         $jsonPath = public_path('templates/contentTemplatePrompt.json'); // Sesuaikan path
@@ -72,18 +30,60 @@ class OpenAIService
         // 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' => [
-                ['role' => 'system', 'content' => $promptTemplate],
-                ['role' => 'user', 'content' => $prompt],
-            ],
+            '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([
@@ -154,4 +154,123 @@ class OpenAIService
         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,9 +51,25 @@ class ServiceClient
 
             $resultResponse = json_decode($responseBody, true, 512, JSON_THROW_ON_ERROR);
             return $this->resSuccess($resultResponse);
+            } 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) {
-            \Log::error('error from client service'. $e->getMessage());
-            return $this->resError($e->getMessage());
+                // Handle unexpected errors
+                return $this->resError('Unexpected error: ' . $e->getMessage(), null, 500);
             }
     }
 

app/Services/ServiceSIMBG.php

@@ -9,6 +9,7 @@ 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;
@@ -66,13 +67,20 @@ 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){
                 $url = "/api/pbg/v1/detail/" . $uuid . "/retribution/indeks-terintegrasi/";
@@ -120,6 +128,7 @@ class ServiceSIMBG
     public function syncTaskPBG()
     {
         try {
+            Log::info("Processing google sheet sync");
             $importDatasource = ImportDatasource::create([
                 'status' => ImportDatasourceStatus::Processing->value,
             ]);
@@ -145,14 +154,14 @@ class ServiceSIMBG
                 // If a section is found and we reach "Grand Total", save the corresponding values
                 if ($found_section && isset($row[0]) && trim($row[0]) === "Grand Total") {
                     if ($found_section === "MENUNGGU_KLIK_DPMPTSP") {
-                        $data_setting_result["MENUNGGU_KLIK_DPMPTSP_COUNT"] = $row[2] ?? null;
-                        $data_setting_result["MENUNGGU_KLIK_DPMPTSP_SUM"] = $row[3] ?? null;
+                        $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"] = $row[2] ?? null;
-                        $data_setting_result["REALISASI_TERBIT_PBG_SUM"] = $row[4] ?? null;
+                        $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"] = $row[2] ?? null;
-                        $data_setting_result["PROSES_DINAS_TEKNIS_SUM"] = $row[3] ?? null;
+                        $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"
@@ -160,6 +169,8 @@ class ServiceSIMBG
                 }
             }
 
+            Log::info("data setting result", ['result' => $data_setting_result]);
+
             foreach ($data_setting_result as $key => $value) {
                 DataSetting::updateOrInsert(
                     ["key" => $key], // Find by key
@@ -167,7 +178,6 @@ class ServiceSIMBG
                 );
             }
             $mapToUpsert = [];
-            $count = 0;
 
             foreach($sheetData as $data){
                 $mapToUpsert[] = 
@@ -289,7 +299,7 @@ class ServiceSIMBG
             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");
             }
@@ -303,20 +313,57 @@ 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') {
+                                Log::warning("Token is invalid, refreshing token...");
+
+                                // Regenerate token
+                                $initResToken = $this->getToken();
+
+                                // Check if new token is valid
+                                if (!empty($initResToken->original['data']['token']['access'])) {
+                                    $new_token = $initResToken->original['data']['token']['access'];
+
+                                    // **Fix: Update headers before retrying**
+                                    $headers['Authorization'] = "Bearer " . $new_token;
+
+                                    Log::info("Token refreshed successfully, retrying API request...");
+                                    continue; // Retry with new token
+                                } else {
+                                    Log::error("Failed to refresh token");
+                                    return $this->resError("Failed to refresh token");
+                                }
+                            }
+                        }
+
+                        // Success case, break loop
+                        break;
+                    }
+
                     $tasks = $response->original['data']['data'] ?? [];
 
                     if (empty($tasks)) {
@@ -351,6 +398,7 @@ class ServiceSIMBG
                             ];
 
                             $this->syncTaskDetailSubmit($item['uid'], $apiToken);
+                            $this->syncTaskAssignments($item['uid']);
                             $savedCount++;
                         } catch (Exception $e) {
                             $failedCount++;
@@ -371,7 +419,7 @@ class ServiceSIMBG
                         ]);
 
                         $uuids = array_column($tasksCollective, 'uuid');
-                        $this->syncIndexIntegration($uuids, $apiToken);
+                        $this->syncIndexIntegration($uuids);
                     }
                 } catch (Exception $e) {
                     Log::error("Failed to process page", [
@@ -400,34 +448,61 @@ 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,
             ];
 
+            for ($attempt = 0; $attempt < 2; $attempt++) { // Try twice (original + retry)
                 $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;
+                // Check if response is JsonResponse and decode it
+                if ($res instanceof \Illuminate\Http\JsonResponse) {
+                    $decodedResponse = json_decode($res->getContent(), true);
+
+                    // Handle invalid token case
+                    if (isset($decodedResponse['errors']['code']) && $decodedResponse['errors']['code'] === 'token_not_valid') {
+                        Log::warning("Token is invalid, refreshing token...");
+
+                        // Regenerate the token
+                        $initResToken = $this->getToken();
+
+                        // Check if the new token is valid
+                        if (!empty($initResToken->original['data']['token']['access'])) {
+                            $new_token = $initResToken->original['data']['token']['access'];
+
+                            // **Fix: Update headers with the new token**
+                            $headers['Authorization'] = "Bearer " . $new_token;
+
+                            Log::info("Token refreshed successfully, retrying API request...");
+                            continue; // Retry the request with the new token
+                        } else {
+                            Log::error("Failed to refresh token");
+                            return $this->resError("Failed to refresh token");
+                        }
+                    }
                 }
 
-            $data = $res->original['data']['data'] ?? [];
+                // If request succeeds, break out of retry loop
+                break;
+            }
+
+            // 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]);
+                Log::error("API response indicates failure", ['url' => $url, 'uuid' => $uuid, 'response' => $responseData]);
                 return false;
             }
     
@@ -489,6 +564,58 @@ class ServiceSIMBG
             throw $e;
         }
     }
+
+    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, // Assuming this is a foreign key
+                    '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' => json_encode($data['file']), // Store as JSON if it's an array
+                    'expertise' => $data['expertise'],
+                    'experience' => $data['experience'],
+                    'is_verif' => $data['is_verif'],
+                    'uid' => $data['uid'], // Unique identifier
+                    'status' => $data['status'],
+                    'status_name' => $data['status_name'],
+                    'note' => $data['note'],
+                    'created_at' => now(),
+                    'updated_at' => now(),
+                ];
+            }
+            TaskAssignment::upsert(
+                $task_assignments, // Data to insert/update
+                ['uid'], // Unique key for conflict resolution
+                ['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)) {
@@ -522,8 +649,10 @@ class ServiceSIMBG
             return null;
         }
 
+        $cleaned = str_replace('.','', $value);
+
         // Otherwise, cast to integer
-        return (int) $value;
+        return (int) $cleaned;
     }
 
     protected function convertToDate($dateString)

composer.json

@@ -57,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": {

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/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 = [
@@ -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,13 @@ 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,
+            ],
         ];
 
         foreach ($children_menus as $child_menu) {
@@ -245,6 +260,7 @@ 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();
 
         // Superadmin gets all menus
         $superadmin->menus()->sync([
@@ -255,6 +271,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],
@@ -274,6 +291,7 @@ class UsersRoleMenuSeeder extends Seeder
             $pdam->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
             $peta->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
             $bigdata_resume->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
+            $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

@@ -14,17 +14,13 @@ npm ci --no-audit --no-fund
 npm run build
 
 echo "📦 Installing composer dependencies..."
-composer install --no-interaction --optimize-autoloader
+COMPOSER_ALLOW_SUPERUSER=1 composer install --no-interaction --optimize-autoloader
 
 echo "🗄️ Running migrations..."
 php artisan migrate --force
 
 echo "⚡ Optimizing application..."
-php artisan cache:clear
-php artisan config:clear
-php artisan config:cache
-php artisan route:cache
-php artisan view:cache
+php artisan optimize:clear
 
 echo "🔄 Restarting PHP service..."
 systemctl restart $PHP_VERSION-fpm

public/templates/contentTemplatePrompt.json

@@ -1,11 +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."
+        "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."
+        "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."
+        "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

@@ -66,11 +66,11 @@ class BigdataResume {
                 },
             },
             sort: true,
-            search: {
-                server: {
-                    url: (prev, keyword) => `${prev}?search=${keyword}`,
-                },
-            },
+            // search: {
+            //     server: {
+            //         url: (prev, keyword) => `${prev}?search=${keyword}`,
+            //     },
+            // },
             server: {
                 url: `${GlobalConfig.apiHost}/api/bigdata-report`,
                 headers: {
@@ -109,8 +109,10 @@ class BigdataResume {
                 },
                 total: (data) => data.total,
             },
+            width: "auto",
         }).render(tableContainer);
     }
+    handleSearch() {}
     async handleDelete(deleteButton) {
         const id = deleteButton.getAttribute("data-id");
 

resources/js/business-industries/index.js

@@ -31,6 +31,11 @@ class BusinessIndustries {
         let tableContainer = document.getElementById(
             "table-business-industries"
         );
+
+        tableContainer.innerHTML = "";
+        let canUpdate = tableContainer.getAttribute("data-updater") === "1";
+        let canDelete = tableContainer.getAttribute("data-destroyer") === "1";
+        
         // Create a new Grid.js instance only if it doesn't exist
         this.table = new Grid({
             columns: [
@@ -50,17 +55,30 @@ class BusinessIndustries {
                 { name: "Created", width: "180px" },
                 {
                     name: "Action",
-                    formatter: (cell) =>
-                        gridjs.html(`
-                                          <div class="d-flex justify-content-center gap-2">
+                    formatter: (cell) => {
+                        
+                        let buttons = `<div class="d-flex justify-content-center gap-2">`;
+                
+                        if (canUpdate) {
+                            buttons += `
                                 <a href="/data/business-industries/${cell}/edit" class="btn btn-yellow btn-sm d-inline-flex align-items-center justify-content-center">
                                     <i class='bx bx-edit'></i>
                                 </a>
+                            `;
+                        }
+                
+                        if (canDelete) {
+                            buttons += `
                                 <button data-id="${cell}" class="btn btn-sm btn-red btn-delete-business-industry d-inline-flex align-items-center justify-content-center">
-                                                  <i class='bx bxs-trash' ></i>
+                                    <i class='bx bxs-trash'></i>
                                 </button>
-                                          </div>
-                                      `),
+                            `;
+                        }
+                
+                        buttons += `</div>`;
+                
+                        return gridjs.html(buttons);
+                    },
                 },
             ],
             pagination: {

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

@@ -1,11 +1,63 @@
 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
         });
     });
@@ -13,6 +65,7 @@ document.addEventListener("DOMContentLoaded", function () {
     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() {
@@ -28,13 +81,20 @@ document.addEventListener("DOMContentLoaded", function () {
             addMessage(userText, "user");
 
             // Tambahkan pesan bot sementara dengan "Loading..."
-            const botMessageElement = addMessage('<div class="loader w-auto"></div>', "bot");
+            const botMessageElement = addMessage('<div class="bot-message-text">...</div>', "bot");
 
-            // Panggil API untuk mendapatkan response dari bot
-            const botResponse = await getBotResponse(currentTab, userText);
+            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
-            botMessageElement.innerHTML = botResponse;;
+            if (messageTextContainer) {
+                messageTextContainer.innerHTML = botResponse;
+            }
         }
     }
 
@@ -49,110 +109,86 @@ document.addEventListener("DOMContentLoaded", function () {
         }
     });
 
+    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");
-        messageRow.classList.add("row", "flex-grow", "overflow-auto");
+        // 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("w-auto", "d-inline-block"); // Menyesuaikan lebar konten
+        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") {
-            messageCol.classList.add("ms-auto", "max-w-50"); // Rata kanan, max 50% (setara col-6)
+            messageContainer.classList.add("user-response", "bg-primary", "text-white");
         } else {
-            messageCol.classList.add("max-w-75"); // Max 75% (setara col-9)
+            messageContainer.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 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 = 32;
+            avatarImg.width = 45;
             avatarImg.src = "/images/iconchatbot.jpeg";
             avatarImg.alt = "bot-avatar";
     
-            avatarSpan.appendChild(avatarImg);
-            messageCol.appendChild(avatarSpan);
+            avatarContainer.appendChild(avatarImg);
+            messageRow.appendChild(avatarContainer);
         }
     
-        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);
+        // Masukkan nama dan bubble ke dalam wrapper
+        messageWrapper.appendChild(messageName);
+        messageWrapper.appendChild(messageContainer);
+        messageCol.appendChild(messageWrapper);
         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
+        return messageContainer;
     }    
 
-
-    // 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) {
+    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 }),
+                body: JSON.stringify({tab_active:tab_active, prompt: userText, chatHistory: historyChat }),
                 headers: {
                     Authorization: `Bearer ${document
                         .querySelector('meta[name="api-token"]')
@@ -162,6 +198,12 @@ document.addEventListener("DOMContentLoaded", function () {
             });
 
             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);

resources/js/customers/index.js

@@ -28,6 +28,10 @@ class Customers {
     initTableCustomers() {
         let tableContainer = document.getElementById("table-customers");
         // Create a new Grid.js instance only if it doesn't exist
+
+        tableContainer.innerHTML = "";
+        let canUpdate = tableContainer.getAttribute("data-updater") === "1";
+        let canDelete = tableContainer.getAttribute("data-destroyer") === "1";
         this.table = new Grid({
             columns: [
                 "ID",
@@ -39,17 +43,31 @@ class Customers {
                 "Longitude",
                 {
                     name: "Action",
-                    formatter: (cell) =>
-                        gridjs.html(`
-                                  <div class="d-flex justify-content-center gap-2">
+                    formatter: (cell) => {
+                        let buttons = "";
+        
+                        if (canUpdate) {
+                            buttons += `
                                 <a href="/data/customers/${cell}/edit" class="btn btn-yellow btn-sm d-inline-flex align-items-center justify-content-center">
                                     <i class='bx bx-edit'></i>
                                 </a>
+                            `;
+                        }
+        
+                        if (canDelete) {
+                            buttons += `
                                 <button data-id="${cell}" class="btn btn-sm btn-red btn-delete-customers d-inline-flex align-items-center justify-content-center">
-                                          <i class='bx bxs-trash' ></i>
+                                    <i class='bx bxs-trash'></i>
                                 </button>
-                                  </div>
-                              `),
+                            `;
+                        }
+        
+                        if (!canUpdate && !canDelete) {
+                            buttons = `<span class="text-muted">No Privilege</span>`;
+                        }
+        
+                        return gridjs.html(`<div class="d-flex justify-content-center gap-2">${buttons}</div>`);
+                    },
                 },
             ],
             pagination: {

resources/js/data-settings/index.js

@@ -29,6 +29,10 @@ class DataSettings {
 
     initTableDataSettings() {
         let tableContainer = document.getElementById("table-data-settings");
+
+        tableContainer.innerHTML = "";
+        let canUpdate = tableContainer.getAttribute("data-updater") === "1";
+        let canDelete = tableContainer.getAttribute("data-destroyer") === "1"
         // Create a new Grid.js instance only if it doesn't exist
         this.table = new Grid({
             columns: [
@@ -40,16 +44,29 @@ class DataSettings {
                     name: "Actions",
                     width: "120px",
                     formatter: function (cell) {
-                        return gridjs.html(`
-                            <div class="d-flex justify-content-center gap-2">
+                        let buttons = "";
+        
+                        if (canUpdate) {
+                            buttons += `
                                 <a href="/data-settings/${cell}/edit" class="btn btn-yellow btn-sm d-inline-flex align-items-center justify-content-center">
                                     <i class='bx bx-edit'></i>
                                 </a>
+                            `;
+                        }
+        
+                        if (canDelete) {
+                            buttons += `
                                 <button class="btn btn-sm btn-red d-inline-flex align-items-center justify-content-center btn-delete-data-settings" data-id="${cell}">
-                                    <i class='bx bxs-trash' ></i>
+                                    <i class='bx bxs-trash'></i>
                                 </button>
-                            </div>
-                        `);
+                            `;
+                        }
+        
+                        if (!canUpdate && !canDelete) {
+                            buttons = `<span class="text-muted">No Privilege</span>`;
+                        }
+        
+                        return gridjs.html(`<div class="d-flex justify-content-center gap-2">${buttons}</div>`);
                     },
                 },
             ],

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

@@ -4,6 +4,11 @@ import "gridjs/dist/gridjs.umd.js";
 import GlobalConfig from "../../global-config.js";
 import GeneralTable from "../../table-generator.js";
 
+// Ambil hak akses dari data-attribute
+const tableElement = document.getElementById("reklame-data-table");
+const canUpdate = tableElement.getAttribute("data-updater") === "1";
+const canDelete = tableElement.getAttribute("data-destroyer") === "1";
+
 const dataAdvertisementsColumns = [
     "No",
     "Nama Wajib Pajak",
@@ -17,21 +22,39 @@ const dataAdvertisementsColumns = [
     "Kontak",
     {
         name: "Actions",
-        widht: "120px",
+        width: "120px",
         formatter: function(cell, row) {
             const id = row.cells[10].data;
             const model = "data/advertisements";
-            return gridjs.html(`
-                <div class="d-flex justify-items-end gap-10">
+            
+            let actionButtons = '<div class="d-flex justify-items-end gap-10">';
+            let hasPrivilege = false;
+    
+            // Tampilkan tombol Edit jika user punya akses update
+            if (canUpdate) {
+                hasPrivilege = true;
+                actionButtons += `
                     <button class="btn btn-warning me-2 btn-edit" 
                         data-id="${id}" 
                         data-model="${model}">
-                        <i class='bx bx-edit' ></i></button>
+                        <i class='bx bx-edit'></i>
+                    </button>`;
+            }
+    
+            // Tampilkan tombol Delete jika user punya akses delete
+            if (canDelete) {
+                hasPrivilege = true;
+                actionButtons += `
                     <button class="btn btn-red btn-delete" 
                         data-id="${id}">
-                            <i class='bx bxs-trash' ></i></button>
-                </div>
-            `);
+                        <i class='bx bxs-trash'></i>
+                    </button>`;
+            }
+    
+            actionButtons += '</div>';
+    
+            // Jika tidak memiliki akses, tampilkan teks "No Privilege"
+            return gridjs.html(hasPrivilege ? actionButtons : '<span class="text-muted">No Privilege</span>');
         }
     }
 ];

resources/js/data/advertisements/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,52 +40,54 @@ document.addEventListener("DOMContentLoaded", function () {
                     .querySelector('meta[name="api-token"]')
                     .getAttribute("content")}`,
                 "Content-Type": "application/json",
-            }
+            },
         })
-        .then(response => response.json())
-        .then(data => {
+            .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');
+                        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
+                        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
+                    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
+                        toast.classList.remove("show"); // Hide the toast after 3 seconds
                     }, 2000);
 
                     setTimeout(() => {
-                    window.location.href = '/data/advertisements';
+                        window.location.href = "/data/web-advertisements";
                     }, 1000);
                 } else {
                     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,27 +98,28 @@ document.addEventListener("DOMContentLoaded", function () {
                     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 =
+                        "Failed: " + (data.message || "Something went wrong");
+                    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 => {
+            .catch((errors) => {
                 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);
@@ -126,11 +129,12 @@ document.addEventListener("DOMContentLoaded", function () {
                 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
+                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);
             });
     });
@@ -141,7 +145,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") {
@@ -149,30 +157,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 => {
+            .then((response) => response.json())
+            .then((data) => {
                 let dataList = document.getElementById(field + "Options");
                 dataList.innerHTML = "";
 
-            data.forEach(item => {
+                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));
+            .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

@@ -25,51 +25,54 @@ console.log(dropzonePreviewNode);
             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
     } 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,22 +85,24 @@ 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() {
+document
+    .getElementById("downloadtempadvertisement")
+    .addEventListener("click", function () {
         var url = `${GlobalConfig.apiHost}/api/download-template-advertisement`;
         fetch(url, {
-        method: 'GET',
+            method: "GET",
             headers: {
                 Authorization: `Bearer ${document
                     .querySelector('meta[name="api-token"]')
-                .getAttribute("content")}`
+                    .getAttribute("content")}`,
             },
         })
-    .then(response => {
+            .then((response) => {
                 if (response.ok) {
                     return response.blob();
                 } else {
@@ -106,38 +111,42 @@ document.getElementById('downloadtempadvertisement').addEventListener('click', f
             })
             .then((blob) => {
                 const url = window.URL.createObjectURL(blob);
-        const a = document.createElement('a');
-        a.style.display = 'none';
+                const a = document.createElement("a");
+                a.style.display = "none";
                 a.href = url;
-        a.download = 'template_reklame.xlsx';
+                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.");
-    })
-})
+                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/data-spatialPlannings.js

@@ -4,6 +4,11 @@ import "gridjs/dist/gridjs.umd.js";
 import GlobalConfig from "../../global-config.js";
 import GeneralTable from "../../table-generator.js";
 
+// Ambil hak akses dari data-attribute
+const tableElement = document.getElementById("spatial-planning-data-table");
+const canUpdate = tableElement.getAttribute("data-updater") === "1";
+const canDelete = tableElement.getAttribute("data-destroyer") === "1";
+
 const dataSpatialPlanningColumns = [
     "No",
     "Nama",
@@ -19,18 +24,35 @@ const dataSpatialPlanningColumns = [
         formatter: function (cell, row) {
             const id = row.cells[8].data;
             const model = "data/spatial-plannings";
-            return gridjs.html(`
-                <div class="d-flex justify-items-end gap-10">
+
+            let actionButtons = '<div class="d-flex justify-items-end gap-10">';
+            let hasPrivilege = false;
+
+            // Tampilkan tombol Edit jika user punya akses update
+            if (canUpdate) {
+                hasPrivilege = true;
+                actionButtons += `
                     <button class="btn btn-warning me-2 btn-edit" 
                         data-id="${id}" 
                         data-model="${model}">
-                        <i class='bx bx-edit'></i></button>
+                        <i class='bx bx-edit'></i>
+                    </button>`;
+            }
 
+            // Tampilkan tombol Delete jika user punya akses delete
+            if (canDelete) {
+                hasPrivilege = true;
+                actionButtons += `
                     <button class="btn btn-red btn-delete" 
                         data-id="${id}">
-                        <i class='bx bxs-trash'></i></button>
-                </div>
-            `);
+                        <i class='bx bxs-trash'></i>
+                    </button>`;
+            }
+
+            actionButtons += '</div>';
+
+            // Jika tidak memiliki akses, tampilkan teks "No Privilege"
+            return gridjs.html(hasPrivilege ? actionButtons : '<span class="text-muted">No Privilege</span>');
         },
     },
 ];

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

@@ -25,51 +25,54 @@ console.log(dropzonePreviewNode);
             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
     } 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,22 +85,24 @@ 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() {
+document
+    .getElementById("downloadtempspatialPlannings")
+    .addEventListener("click", function () {
         var url = `${GlobalConfig.apiHost}/api/download-template-spatialPlannings`;
         fetch(url, {
-        method: 'GET',
+            method: "GET",
             headers: {
                 Authorization: `Bearer ${document
                     .querySelector('meta[name="api-token"]')
-                .getAttribute("content")}`
+                    .getAttribute("content")}`,
             },
         })
-    .then(response => {
+            .then((response) => {
                 if (response.ok) {
                     return response.blob(); // Jika respons OK, konversi menjadi blob
                 } else {
@@ -107,38 +112,42 @@ document.getElementById('downloadtempspatialPlannings').addEventListener('click'
             .then((blob) => {
                 console.log(blob);
                 const url = window.URL.createObjectURL(blob);
-        const a = document.createElement('a');
-        a.style.display = 'none';
+                const a = document.createElement("a");
+                a.style.display = "none";
                 a.href = url;
-        a.download = 'template_rencana_tata_ruang.xlsx';
+                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.");
-    })
-})
+                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/data-tourisms.js

@@ -3,6 +3,14 @@ import gridjs from "gridjs/dist/gridjs.umd.js";
 import "gridjs/dist/gridjs.umd.js";
 import GlobalConfig from "../../global-config.js";
 import GeneralTable from "../../table-generator.js";
+import L from "leaflet";
+import "leaflet/dist/leaflet.css";
+
+// Ambil hak akses dari data-attribute
+const tableElement = document.getElementById("tourisms-data-table");
+const canView = "1";
+const canUpdate = tableElement.getAttribute("data-updater") === "1";
+const canDelete = tableElement.getAttribute("data-destroyer") === "1";
 
 const dataTourismsColumns = [
     "No",
@@ -21,26 +29,49 @@ const dataTourismsColumns = [
         widht: "120px",
         formatter: function (cell, row) {
             const id = row.cells[11].data;
+            const district = row.cells[4].data;
             const long = 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">
+
+            let actionButtons = '<div class="d-flex justify-items-end gap-10">';
+            let hasPrivilege = false;
+
+            // Tampilkan tombol View jika user punya akses view
+            if (canView) {
+                hasPrivilege = true;
+                actionButtons += `
+                <button class="btn btn-info me-2 btn-view" 
+                    data-long="${long}" data-lat="${lat}" data-district="${district}">
+                    <i class='bx bx-map'></i>
+                </button>`
+            }
+            
+            // Tampilkan tombol Edit jika user punya akses update
+            if (canUpdate) {
+                hasPrivilege = true;
+                actionButtons += `
                     <button class="btn btn-warning me-2 btn-edit"
                         data-id="${id}"
                         data-model="${model}">
-                        <i class='bx bx-edit'></i></button>
-                    
-                    <button class="btn btn-info me-2 btn-view" 
-                        data-long="${long}" data-lat="${lat}">
-                        <i class='bx bx-map'></i></button>
+                        <i class='bx bx-edit'></i>
+                    </button>`;
+            }
 
+            // Tampilkan tombol Delete jika user punya akses delete
+            if (canDelete) {
+                hasPrivilege = true;
+                actionButtons += `
                     <button class="btn btn-red btn-delete" 
                         data-id="${id}">
-                        <i class='bx bxs-trash'></i></button>
-                </div>
-            `);
-        },
+                        <i class='bx bxs-trash'></i>
+                    </button>`
+            }
+
+            actionButtons += '</div>';
+            // Jika tidak memiliki akses, tampilkan teks "No Privilege"
+            return gridjs.html(hasPrivilege ? actionButtons : '<span class="text-muted">No Privilege</span>');
+        }
     },
 ];
 
@@ -74,24 +105,117 @@ document.addEventListener("DOMContentLoaded", () => {
     table.init();
 
     // Event listener untuk tombol "View" yang memunculkan modal
+    // document.addEventListener("click", function (e) {
+    //     if (e.target && e.target.classList.contains("btn-view")) {
+    //         const long = e.target.getAttribute("data-long");
+    //         const lat = e.target.getAttribute("data-lat");
+
+    //         // Menyiapkan URL iframe dengan koordinat yang didapatkan
+    //         const iframeSrc = `https://www.google.com/maps?q=${lat},${long}&hl=es;z=14&output=embed`;
+
+    //         // Menemukan modal dan iframe di dalam modal
+    //         const modal = document.querySelector(".modalGMaps");
+    //         const iframe = modal.querySelector("iframe");
+
+    //         // Set src iframe untuk menampilkan peta dengan koordinat yang relevan
+    //         iframe.src = iframeSrc;
+
+    //         // Menampilkan modal
+    //         var modalInstance = new bootstrap.Modal(modal);
+    //         modalInstance.show();
+    //     }
+    // });
+
+    let map;
+    let geoLayer;
+    // Event listener untuk tombol "View" yang memunculkan modal dengan Leaflet
     document.addEventListener("click", function (e) {
         if (e.target && e.target.classList.contains("btn-view")) {
-            const long = e.target.getAttribute("data-long");
-            const lat = e.target.getAttribute("data-lat");
+            const long = parseFloat(e.target.getAttribute("data-long"));
+            const lat = parseFloat(e.target.getAttribute("data-lat"));
+            const district = e.target.getAttribute("data-district");
 
-            // Menyiapkan URL iframe dengan koordinat yang didapatkan
-            const iframeSrc = `https://www.google.com/maps?q=${lat},${long}&hl=es;z=14&output=embed`;
-
-            // Menemukan modal dan iframe di dalam modal
             const modal = document.querySelector(".modalGMaps");
-            const iframe = modal.querySelector("iframe");
-
-            // Set src iframe untuk menampilkan peta dengan koordinat yang relevan
-            iframe.src = iframeSrc;
-
-            // Menampilkan modal
             var modalInstance = new bootstrap.Modal(modal);
             modalInstance.show();
+
+            setTimeout(() => {
+                if (!map) {
+                    map = L.map("map").setView([lat, long], 14);
+                    
+                    // Tambahkan tile layer (peta dasar)
+                    L.tileLayer("https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png", {
+                        attribution: '&copy; OpenStreetMap contributors'
+                    }).addTo(map);
+                } else {
+                    map.setView([lat, long], 14);
+                }
+
+                if (geoLayer) {
+                    map.removeLayer(geoLayer);
+                }
+
+                // Tambahkan marker untuk lokasi
+                L.marker([lat, long]).addTo(map)
+                    .bindPopup(`<b>${district}</b><br>Lat: ${lat}, Long: ${long}`)
+                    .openPopup();
+
+                // Tambahkan GeoJSON ke dalam peta
+                fetch(`/storage/maps/tourisms/${district.toUpperCase()}.json`)
+                .then((res) => res.json())
+                .then((geojson) => {
+                    let colorMapping = {
+                        BJ: "rgb(235, 30, 30)",
+                        BA: "rgb(151, 219, 242)",
+                        CA: "rgb(70, 70, 165)",
+                        "P-2": "rgb(230, 255, 75)",
+                        HL: "rgb(50, 95, 40)",
+                        HPT: "rgb(75, 155, 55)",
+                        HP: "rgb(125, 180, 55)",
+                        W: "rgb(255, 165, 255)",
+                        PTL: "rgb(0, 255, 205)",
+                        "IK-2": "rgb(130, 185, 210)",
+                        "P-3": "rgb(175, 175, 55)",
+                        PS: "rgb(5, 215, 215)",
+                        PD: "rgb(235, 155, 60)",
+                        PK: "rgb(245, 155, 30)",
+                        HK: "rgb(155, 0, 255)",
+                        KPI: "rgb(105, 0, 0)",
+                        MBT: "rgb(95, 115, 145)",
+                        "P-4": "rgb(185, 235, 185)",
+                        TB: "rgb(70, 150, 255)",
+                        "P-1": "rgb(200, 245, 70)",
+                        TR: "rgb(215, 55, 0)",
+                        THR: "rgb(185, 165, 255)",
+                        TWA: "rgb(210, 190, 255)",
+                    };
+                    var geoLayer = L.geoJSON(geojson, {
+                        style: function (feature) {
+                            let htmlString = feature.properties.description.toString();
+                            let match = htmlString.match(
+                                /<td>Kode Zona<\/td>\s*<td>(.*?)<\/td>/
+                            );
+
+                            let color_code = match[1];
+                            return {
+                                color: colorMapping[color_code],
+                                fillColor: colorMapping[color_code] || "#cccccc", 
+                                fillOpacity: 0.6,
+                                weight: 1.5,
+                            };
+                        },
+                        onEachFeature: function(feature, layer) {
+                            if (feature.properties && feature.properties.name) {
+                                layer.bindPopup(feature.properties.name);
+                            }
+                        },
+                    }).addTo(map);
+                    map.fitBounds(geoLayer.getBounds());
+                })
+                .catch((error) => {
+                    console.error("Error loading GeoJSON:", error);
+                });
+            }, 500);
         }
     });
 });

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

@@ -25,51 +25,54 @@ console.log(dropzonePreviewNode);
             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
     } 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,22 +85,24 @@ 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() {
+document
+    .getElementById("downloadtemptourisms")
+    .addEventListener("click", function () {
         var url = `${GlobalConfig.apiHost}/api/download-template-tourism`;
         fetch(url, {
-        method: 'GET',
+            method: "GET",
             headers: {
                 Authorization: `Bearer ${document
                     .querySelector('meta[name="api-token"]')
-                .getAttribute("content")}`
+                    .getAttribute("content")}`,
             },
         })
-    .then(response => {
+            .then((response) => {
                 if (response.ok) {
                     return response.blob(); // Jika respons OK, konversi menjadi blob
                 } else {
@@ -107,38 +112,42 @@ document.getElementById('downloadtemptourisms').addEventListener('click', functi
             .then((blob) => {
                 console.log(blob);
                 const url = window.URL.createObjectURL(blob);
-        const a = document.createElement('a');
-        a.style.display = 'none';
+                const a = document.createElement("a");
+                a.style.display = "none";
                 a.href = url;
-        a.download = 'template_pariwisata.xlsx';
+                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.");
-    })
-})
+                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/data-umkm.js

@@ -3,6 +3,11 @@ import "gridjs/dist/gridjs.umd.js";
 import GlobalConfig from "../../global-config.js";
 import GeneralTable from "../../table-generator.js";
 
+// Ambil hak akses dari data-attribute
+const tableElement = document.getElementById("umkm-data-table");
+const canUpdate = tableElement.getAttribute("data-updater") === "1";
+const canDelete = tableElement.getAttribute("data-destroyer") === "1";
+
 const dataUMKMColumns = [
     "No",
     "Nama Usaha",
@@ -29,17 +34,35 @@ const dataUMKMColumns = [
         formatter: function(cell, row) {
             const id = row.cells[19].data;
             const model = "data/umkm";
-            return gridjs.html(`
-                <div class="d-flex justify-items-end gap-10">
+
+            let actionButtons = '<div class="d-flex justify-items-end gap-10">';
+            let hasPrivilege = false;
+    
+            // Tampilkan tombol Edit jika user punya akses update
+            if (canUpdate) {
+                hasPrivilege = true;
+                actionButtons += `
                     <button class="btn btn-warning me-2 btn-edit" 
                         data-id="${id}" 
                         data-model="${model}">
-                        <i class='bx bx-edit' ></i></button>
+                        <i class='bx bx-edit'></i>
+                    </button>`;
+            }
+    
+            // Tampilkan tombol Delete jika user punya akses delete
+            if (canDelete) {
+                hasPrivilege = true;
+                actionButtons += `
                     <button class="btn btn-red btn-delete" 
                         data-id="${id}">
-                            <i class='bx bxs-trash' ></i></button>
-                </div>
-            `);
+                        <i class='bx bxs-trash'></i>
+                    </button>`;
+            }
+    
+            actionButtons += '</div>';
+    
+            // Jika tidak memiliki akses, tampilkan teks "No Privilege"
+            return gridjs.html(hasPrivilege ? actionButtons : '<span class="text-muted">No Privilege</span>');
         }
     }
 ];

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,55 @@ document.addEventListener("DOMContentLoaded", function () {
                     .querySelector('meta[name="api-token"]')
                     .getAttribute("content")}`,
                 "Content-Type": "application/json",
-            }
+            },
         })
-        .then(response => response.json())
-        .then(data => {
+            .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');
+                        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
+                        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
+                    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
+                        toast.classList.remove("show"); // Hide the toast after 3 seconds
                     }, 2000);
 
                     setTimeout(() => {
-                    window.location.href = '/data/umkm';
+                        window.location.href = "/data/web-umkm";
                     }, 1000);
                 } else {
                     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,30 +98,30 @@ 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 =
+                        "Error: " + (data.message || "Something went wrong");
+                    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 => {
+            .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);
@@ -130,11 +132,12 @@ document.addEventListener("DOMContentLoaded", function () {
                 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
+                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);
             });
     });
@@ -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 => {
+            .then((response) => response.json())
+            .then((data) => {
                 let dataList = document.getElementById(field + "Options");
                 dataList.innerHTML = "";
 
-            data.forEach(item => {
+                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));
+            .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

@@ -25,51 +25,54 @@ console.log(dropzonePreviewNode);
             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
     } 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,22 +85,24 @@ 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() {
+document
+    .getElementById("downloadtempumkm")
+    .addEventListener("click", function () {
         var url = `${GlobalConfig.apiHost}/api/download-template-umkm`;
         fetch(url, {
-        method: 'GET',
+            method: "GET",
             headers: {
                 Authorization: `Bearer ${document
                     .querySelector('meta[name="api-token"]')
-                .getAttribute("content")}`
+                    .getAttribute("content")}`,
             },
         })
-    .then(response => {
+            .then((response) => {
                 if (response.ok) {
                     return response.blob(); // Jika respons OK, konversi menjadi blob
                 } else {
@@ -106,38 +111,42 @@ document.getElementById('downloadtempumkm').addEventListener('click', function()
             })
             .then((blob) => {
                 const url = window.URL.createObjectURL(blob);
-        const a = document.createElement('a');
-        a.style.display = 'none';
+                const a = document.createElement("a");
+                a.style.display = "none";
                 a.href = url;
-        a.download = 'template_umkm.xlsx';
+                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.");
-    })
-})
+                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

@@ -9,6 +9,12 @@ class UsersTable {
     }
 
     initTableUsers() {
+        let tableContainer = document.getElementById(
+            "table-users"
+        );
+
+        tableContainer.innerHTML = "";
+        let canUpdate = tableContainer.getAttribute("data-updater") === "1";
         new Grid({
             columns: [
                 "ID",
@@ -20,14 +26,18 @@ class UsersTable {
                 "Roles",
                 {
                     name: "Action",
-                    formatter: (cell) =>
-                        gridjs.html(`
+                    formatter: (cell) =>{
+                        if (!canUpdate) {
+                            return gridjs.html(`<span class="text-muted">No Privilege</span>`);
+                        }
+                        return gridjs.html(`
                             <div class="d-flex justify-content-center">
                                 <a href="/master/users/${cell}/edit" class="btn btn-yellow btn-sm d-inline-flex align-items-center justify-content-center">
                                     <i class='bx bx-edit'></i>
                                 </a>
                             </div>
-                        `),
+                        `);
+                    },
                 },
             ],
             pagination: {

resources/js/menus/index.js

@@ -28,6 +28,9 @@ class Menus {
     initTableMenus() {
         let tableContainer = document.getElementById("table-menus");
 
+        tableContainer.innerHTML = "";
+        let canUpdate = tableContainer.getAttribute("data-updater") === "1";
+        let canDelete = tableContainer.getAttribute("data-destroyer") === "1";
         if (this.table) {
             // If table exists, update its data instead of recreating
             this.table
@@ -68,18 +71,33 @@ class Menus {
                 "Sort Order",
                 {
                     name: "Action",
-                    formatter: (cell) =>
-                        gridjs.html(`
-                        <div class="d-flex justify-content-center align-items-center gap-2">
+                    formatter: (cell) => {
+                        let buttons = `<div class="d-flex justify-content-center align-items-center gap-2">`;
+    
+                        if (canUpdate) {
+                            buttons += `
                                 <a href="/menus/${cell}/edit" class="btn btn-yellow btn-sm d-inline-flex align-items-center justify-content-center">
                                     <i class='bx bx-edit'></i>
                                 </a>
-                            <button data-id="${cell}"
-                            class="btn btn-red btn-sm btn-delete-menu d-inline-flex align-items-center justify-content-center">
-                                <i class='bx bxs-trash' ></i>
+                            `;
+                        }
+    
+                        if (canDelete) {
+                            buttons += `
+                                <button data-id="${cell}" class="btn btn-red btn-sm btn-delete-menu d-inline-flex align-items-center justify-content-center">
+                                    <i class='bx bxs-trash'></i>
                                 </button>
-                        </div>
-                      `),
+                            `;
+                        }
+    
+                        if (!canUpdate && !canDelete) {
+                            buttons += `<span class="text-muted">No Privilege</span>`;
+                        }
+    
+                        buttons += `</div>`;
+    
+                        return gridjs.html(buttons);
+                    },
                 },
             ],
             pagination: {

resources/js/pbg-task/index.js

@@ -9,6 +9,11 @@ class PbgTasks {
     }
 
     initTableRequestAssignment() {
+        let tableContainer = document.getElementById("table-pbg-tasks");
+
+        // Pastikan kontainer kosong sebelum merender ulang Grid.js
+        tableContainer.innerHTML = "";
+        let canUpdate = tableContainer.getAttribute("data-updater") === "1";
         new Grid({
             columns: [
                 "ID",
@@ -24,13 +29,24 @@ class PbgTasks {
                 {
                     name: "Action",
                     formatter: function (cell) {
+                        let tableContainer = document.getElementById("table-pbg-tasks");
+                        let canUpdate = tableContainer.getAttribute("data-updater") === "1";
+                
+                        if (!canUpdate) {
+                            return gridjs.html(`
+                                <span class="text-muted">No Privilege</span>
+                            `);
+                        }
+                
                         return gridjs.html(`
                             <div class="d-flex justify-content-center align-items-center gap-2">
-                                <a href="/pbg-task/${cell}" class="btn btn-yellow btn-sm d-inline-flex align-items-center justify-content-center">Detail</a
+                                <a href="/pbg-task/${cell}" class="btn btn-yellow btn-sm d-inline-flex align-items-center justify-content-center">
+                                    Detail
+                                </a>
                             </div>
                         `);
                     },
-                },
+                }
             ],
             search: {
                 server: {

resources/js/roles/index.js

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

resources/js/table-generator.js

@@ -12,6 +12,11 @@ class GeneralTable {
     }
 
     init() {
+        const tableContainer = document.getElementById(this.tableId);
+    
+        // Kosongkan container sebelum render ulang
+        tableContainer.innerHTML = "";
+    
         const table = new Grid({
             columns: this.columns,
             search: this.options.search || {
@@ -40,7 +45,7 @@ class GeneralTable {
             },
         });
     
-        table.render(document.getElementById(this.tableId));
+        table.render(tableContainer);
         this.handleActions();
     }
 

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

@@ -2,6 +2,79 @@
 
 @section('css')
 @vite(['node_modules/gridjs/dist/theme/mermaid.min.css'])
+<style>
+/* Ensure the Grid.js container allows full scrolling */
+#table-bigdata-resumes {
+    overflow-x: auto;
+    overflow-y: hidden; /* Prevent vertical scrolling */
+    white-space: nowrap;
+    max-width: 100%;
+    height: 100%; /* Adjust height if necessary */
+}
+
+/* Ensure Grid.js wrapper is scrollable */
+.gridjs-wrapper {
+    max-width: 100%;
+    overflow-x: auto;
+    overflow-y: hidden;
+    white-space: nowrap;
+}
+
+/* Make the entire scrollbar much bigger */
+.gridjs-wrapper::-webkit-scrollbar {
+    height: 40px; /* Increase scrollbar height */
+}
+
+/* Scrollbar track (background) */
+.gridjs-wrapper::-webkit-scrollbar-track {
+    background: #ddd;
+    border-radius: 20px;
+}
+
+/* Scrollbar thumb (draggable part) */
+.gridjs-wrapper::-webkit-scrollbar-thumb {
+    background: #007bff;
+    border-radius: 20px;
+    width: 40px; /* Wider scrollbar thumb */
+    min-width: 40px;
+}
+
+/* Scrollbar thumb hover effect */
+.gridjs-wrapper::-webkit-scrollbar-thumb:hover {
+    background: #0056b3;
+}
+
+/* Bigger Scrollbar Buttons */
+.gridjs-wrapper::-webkit-scrollbar-button {
+    background: #007bff;
+    height: 40px; /* Force bigger button height */
+    width: 40px; /* Force bigger button width */
+    border-radius: 10px;
+}
+
+/* Left Scroll Button */
+.gridjs-wrapper::-webkit-scrollbar-button:horizontal:decrement {
+    display: block;
+    background: url('data:image/svg+xml;utf8,<svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24" fill="white"><path d="M15 18l-6-6 6-6"/></svg>') no-repeat center;
+    background-size: 30px;
+    width: 40px; /* Ensure button size */
+    height: 40px;
+}
+
+/* Right Scroll Button */
+.gridjs-wrapper::-webkit-scrollbar-button:horizontal:increment {
+    display: block;
+    background: url('data:image/svg+xml;utf8,<svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24" fill="white"><path d="M9 18l6-6-6-6"/></svg>') no-repeat center;
+    background-size: 30px;
+    width: 40px; /* Ensure button size */
+    height: 40px;
+}
+
+/* Scrollbar button hover effect */
+.gridjs-wrapper::-webkit-scrollbar-button:hover {
+    background: #0056b3;
+}
+</style>
 @endsection
 
 @section('content')
@@ -12,7 +85,11 @@
 
 <div class="row">
     <div class="col-12">
-		<div class="card w-100">
+        <div class="card w-100 h-100">
+            <div class="card-header d-flex align-items-center">
+                <input type="text" class="form-control me-2 w-auto" />
+                <button id="search-btn" class="btn btn-md btn-info text-white">Cari</button>
+            </div>
             <div class="card-body">
                 <div id="table-bigdata-resumes"></div>
             </div>

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

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

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

@@ -30,59 +30,66 @@
 @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">
+            <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">Perhitungan Retribusi</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 active">
+            <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">Validasi Dokumen PBG</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">Pengumpulan Data PBG</span>
+                <span class="d-none d-sm-block fs-4">Pengumpulan Data PBG</span>
             </button>
         </li>
     </ul>
-    </div>
+    {{-- <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">
+        <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">
-                <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>
+                <!-- 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 rounded-pill">
+                <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 class="col-xl-2 d-flex justify-content-end">
-                
-            </div> --}}
         </div>
     </div>    
-        
-    </div>    
 </div>
 
 @endsection

resources/views/customers/index.blade.php

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

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

@@ -15,9 +15,14 @@
 		<div class="card w-100">
 			<div class="card-body">
 				<div class="d-flex flex-wrap justify-content-end align-items-center mb-2">
+					@if ($creator)
 						<a href="{{ route('data-settings.create')}}" class="btn btn-success btn-sm d-block d-sm-inline w-auto">Create</a>
+					@endif
+				</div>
+				<div id="table-data-settings"
+                     data-updater="{{ $updater }}"
+                     data-destroyer="{{ $destroyer }}">
 				</div>
-				<div id="table-data-settings"></div>
 			</div>
 		</div>
 	</div>

resources/views/data/advertisements/index.blade.php

@@ -16,6 +16,7 @@
     <div class="card-body">
         <div class="row">
             <div class="d-flex justify-content-end gap-10 pb-3">
+                @if ($creator)
                     <button class="btn btn-success me-2 width-lg btn-create" data-model="data/advertisements">
                         <i class='bx bxs-file-plus'></i>
                         Create</button>
@@ -23,9 +24,13 @@
                         <i class='bx bx-upload' ></i>
                         Bulk Create
                     </button>
+                @endif
             </div>
             <div>
-                <div id="reklame-data-table"></div>
+                <div id="reklame-data-table"
+                     data-updater="{{ $updater }}"
+                     data-destroyer="{{ $destroyer }}">
+                </div>
             </div>
         </div>
     </div>

resources/views/data/spatialPlannings/index.blade.php

@@ -14,6 +14,7 @@
     <div class="card-body">
         <div class="row">
             <div class="d-flex justify-content-end gap-10 pb-3">
+                @if ($creator)
                     <button class="btn btn-success me-2 width-lg btn-create" data-model="data/spatial-plannings">
                         <i class='bx bxs-file-plus'></i>
                         Create</button>
@@ -21,9 +22,13 @@
                         <i class='bx bx-upload' ></i>
                         Bulk Create
                     </button>
+                @endif
             </div>
             <div>
-                <div id="spatial-planning-data-table"></div>
+                <div id="spatial-planning-data-table"
+                    data-updater="{{ $updater }}"
+                    data-destroyer="{{ $destroyer }}">
+                </div>
             </div>
         </div>
     </div>

resources/views/data/tourisms/index.blade.php

@@ -14,6 +14,7 @@
     <div class="card-body">
         <div class="row">
             <div class="d-flex justify-content-end gap-10 pb-3">
+                @if ($creator)
                     <button class="btn btn-success me-2 width-lg btn-create" data-model="data/tourisms">
                         <i class='bx bxs-file-plus'></i>
                         Create</button>
@@ -21,9 +22,13 @@
                         <i class='bx bx-upload' ></i>
                         Bulk Create
                     </button>
+                @endif
             </div>
             <div>
-                <div id="tourisms-data-table"></div>
+                <div id="tourisms-data-table"
+                    data-updater="{{ $updater }}"
+                    data-destroyer="{{ $destroyer }}">
+                </div>
             </div>
         </div>
     </div>
@@ -39,14 +44,15 @@
                     aria-label="Close"></button>
             </div>
             <div class="modal-body">
-                <iframe 
+                {{-- <iframe 
                         src="" 
                         width="100%" 
                         height="450" 
                         style="border:0;" 
                         allowfullscreen="" 
                         loading="lazy">
-                </iframe>
+                </iframe> --}}
+                <div id="map" style="height: 400px;"></div>
             </div>
         </div>
     </div>

resources/views/data/umkm/index.blade.php

@@ -14,6 +14,7 @@
     <div class="card-body">
         <div class="row">
             <div class="d-flex justify-content-end gap-10 pb-3">
+                @if ($creator)
                     <button class="btn btn-success me-2 width-lg btn-create" data-model="data/umkm">
                         <i class='bx bxs-file-plus'></i>
                         Create</button>
@@ -21,9 +22,13 @@
                         <i class='bx bx-upload' ></i>
                         Bulk Create
                     </button>
+                @endif
             </div>
             <div>
-                <div id="umkm-data-table"></div>
+                <div id="umkm-data-table"
+                    data-updater="{{ $updater }}"
+                    data-destroyer="{{ $destroyer }}">
+                </div>
             </div>
         </div>
     </div>

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 * 10; // Set jarak margin berdasarkan level
+
+                              echo '<li class="nav-item" style="margin-left: ' . $marginLeft . 'px;">';
+
+                              // 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">
+     @for ($i = 0; $i < 20; $i++)
           <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>
+     @endfor
 </div>

resources/views/layouts/vertical.blade.php

@@ -86,7 +86,7 @@
                 {{-- <div class="floating-icon">
                     
                 </div>             --}}
-                @if (!Request::is('chatbot'))
+                @if (!Request::is('chatbot') && !Request::is('main-chatbot'))
                     <a href="{{ route('chatbot.index') }}" class="floating-icon">
                         
                     </a>

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

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

resources/views/menus/index.blade.php

@@ -16,10 +16,15 @@
         <div class="card w-100">
             <div class="card-body">
                 <div class="d-flex flex-wrap justify-content-end align-items-center mb-2">
+                    @if ($creator)
                         <a href="{{ route('menus.create')}}" class="btn btn-success btn-sm d-block d-sm-inline w-auto">Create</a>
+                    @endif
                 </div>
                 <div>
-                    <div id="table-menus"></div>
+                    <div id="table-menus"
+                        data-updater="{{ $updater }}"
+                        data-destroyer="{{ $destroyer }}">
+                    </div>
                 </div>
             </div>
         </div>

resources/views/pbg_task/index.blade.php

@@ -13,9 +13,14 @@
     <div class="card w-100">
       <div class="card-body">
         <div class="d-flex flex-wrap justify-content-end">
+          @if ($creator)
             <a href="{{ route('pbg-task.create')}}" class="btn btn-success btn-sm d-block d-sm-inline w-auto">Create</a>
+          @endif
+        </div>
+        <div id="table-pbg-tasks"
+					data-updater="{{ $updater }}"
+					data-destroyer="{{ $destroyer }}">
         </div>
-        <div id="table-pbg-tasks"></div>
       </div>
     </div>
   </div>

resources/views/pbg_task/show.blade.php

@@ -92,6 +92,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 +251,40 @@
                             @endif
                         </div>
                     </div>
+                    <div class="tab-pane" id="pbgTaskAssignments">
+                        @if ($data->taskAssignments && $data->taskAssignments->isNotEmpty())
+                            @foreach ($data->taskAssignments  as $task_assignment)
+                                <div class="border p-3 rounded shadow-sm col-md-4">
+                                    <div class="mb-3">
+                                        <dt>Nama</dt>
+                                        <dd>{{$task_assignment->name}}</dd>
+                                    </div>
+                                    <div class="mb-3">
+                                        <dt>Email</dt>
+                                        <dd>{{$task_assignment->email}}</dd>
+                                    </div>
+                                    <div class="mb-3">
+                                        <dt>Nomor Telepon</dt>
+                                        <dd>{{$task_assignment->phone_number}}</dd>
+                                    </div>
+                                    <div class="mb-3">
+                                        <dt>Keahlian</dt>
+                                        <dd>{{$task_assignment->expertise}}</dd>
+                                    </div>
+                                    <div class="mb-3">
+                                        <dt>Status</dt>
+                                        <dd>{{$task_assignment->status_name}}</dd>
+                                    </div>
+                                </div>
+                            @endforeach
+                        @else
+                            <div class="row">
+                                <div class="col-md-12">
+                                    Data Not Available
+                                </div>
+                            </div>
+                        @endif
+                    </div>
                 </div>
             </div>
         </div>

resources/views/roles/index.blade.php

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

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

@@ -13,10 +13,12 @@
         <div class="card w-100">
             <div class="card-body">
                 <div class="d-flex flex-wrap justify-content-end gap-2">
+                    @if ($creator)
                         <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>
+                    @endif
                 </div>
                 <div>
                     <div id="table-import-datasources"></div>

routes/api.php

@@ -26,6 +26,7 @@ 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(){
@@ -101,6 +102,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 (){

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

@@ -21,6 +21,7 @@ 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';
@@ -63,6 +64,9 @@ Route::group(['middleware' => 'auth'], function(){
     // 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 (){
@@ -73,30 +77,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

@@ -100,6 +100,7 @@ export default defineConfig({
                 // laporan pimpinan
                 "resources/js/bigdata-resumes/index.js",
                 "resources/js/chatbot/index.js",
+                "resources/js/chatbot-pimpinan/index.js",
             ],
             refresh: true,
         }),