fix back button

app/Http/Controllers/Api/GoogleSheetController.php

@@ -3,33 +3,15 @@
 namespace App\Http\Controllers\Api;
 
 use App\Http\Controllers\Controller;
-use App\Services\GoogleSheetService;
 use Illuminate\Http\Request;
 
 class GoogleSheetController extends Controller
 {
-    protected $googleSheetService;
-    public function __construct(GoogleSheetService $googleSheetService){
-        $this->googleSheetService = $googleSheetService;
-    }
-    /**
-     * Display a listing of the resource.
-     */
-    public function index()
+    public function index(Request $request)
     {
-        $dataCollection = $this->googleSheetService->getSheetDataCollection();
-        $result = [
-            "last_row" => $this->googleSheetService->getLastRowByColumn("C"),
-            "last_column" => $this->googleSheetService->getLastColumn(),
-            "header" => $this->googleSheetService->getHeader(),
-            "data_collection" => $dataCollection
-        ];
-        return response()->json($result);
+        
     }
 
-    /**
-     * Store a newly created resource in storage.
-     */
     public function store(Request $request)
     {
         //

app/Http/Controllers/Api/PbgTaskGoogleSheetsController.php

@@ -0,0 +1,61 @@
+<?php
+
+namespace App\Http\Controllers\Api;
+
+use App\Http\Controllers\Controller;
+use App\Http\Resources\PbgTaskGoogleSheetResource;
+use App\Models\PbgTaskGoogleSheet;
+use Illuminate\Http\Request;
+
+class PbgTaskGoogleSheetsController extends Controller
+{
+    /**
+     * Display a listing of the resource.
+     */
+    public function index(Request $request)
+    {
+        $query = PbgTaskGoogleSheet::query()->orderBy('id', 'desc');
+        if ($request->filled('search')) {
+            $query->where('no_registrasi', 'like', "%{$request->get('search')}%");
+        }
+        return PbgTaskGoogleSheetResource::collection($query->paginate(config('app.paginate_per_page', 50)));
+    }
+
+    /**
+     * Store a newly created resource in storage.
+     */
+    public function store(Request $request)
+    {
+        //
+    }
+
+    /**
+     * Display the specified resource.
+     */
+    public function show(string $id)
+    {
+        //
+    }
+
+    /**
+     * Update the specified resource in storage.
+     */
+    public function update(Request $request, string $id)
+    {
+        //
+    }
+
+    /**
+     * Remove the specified resource from storage.
+     */
+    public function destroy(string $id)
+    {
+        try{
+            $data = PbgTaskGoogleSheet::find($id);
+            $data->delete();
+            return response()->json(['message' => 'Data deleted successfully'], 200);
+        }catch(\Exception $e){
+            return response()->json(['message' => 'Failed to delete data'], 500);
+        }
+    }
+}

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

@@ -2,7 +2,54 @@
 
 namespace App\Http\Controllers;
 
+use Illuminate\Support\Facades\Auth;
+
 abstract class Controller
 {
-    //
+    protected array $permissions = [];
+
+    public function __construct()
+    {
+        if (!Auth::check()) {
+            return;
+        }
+        $this->setUserPermissions();
+    }
+
+    protected function setUserPermissions()
+    {
+        $user = Auth::user();
+
+        if (!$user) {
+            return;
+        }
+
+        $menus = $user->roles()
+            ->with(['menus' => function ($query) {
+                $query->select('menus.id', 'menus.name')
+                      ->withPivot(['allow_show' ,'allow_create', 'allow_update', 'allow_destroy']);
+            }])
+            ->get()
+            ->pluck('menus')
+            ->flatten()
+            ->unique('id');
+
+        // Store permissions in an associative array
+        foreach ($menus as $menu) {
+            $this->permissions[$menu->id] = [
+                'allow_show' => $menu->pivot->allow_show ?? 0,
+                'allow_create' => $menu->pivot->allow_create ?? 0,
+                'allow_update' => $menu->pivot->allow_update ?? 0,
+                'allow_destroy' => $menu->pivot->allow_destroy ?? 0,
+            ];
+        }
+
+        // Share permissions globally in views
+        view()->share('permissions', $this->permissions);
+    }
+
+    public function getPermissions()
+    {
+        return $this->permissions;
+    }
 }

app/Http/Controllers/CustomersController.php

@@ -4,12 +4,34 @@ namespace App\Http\Controllers;
 
 use App\Models\Customer;
 use Illuminate\Http\Request;
+use Illuminate\Support\Facades\Auth;
+use Illuminate\Support\Facades\DB;
 
 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'));
     }
 
     /**

app/Http/Controllers/Data/GoogleSheetsController.php

@@ -0,0 +1,36 @@
+<?php
+
+namespace App\Http\Controllers\Data;
+
+use App\Http\Controllers\Controller;
+use App\Models\PbgTaskGoogleSheet;
+use Illuminate\Http\Request;
+
+class GoogleSheetsController extends Controller
+{
+    /**
+     * Display a listing of the resource.
+     */
+    public function index(Request $request)
+    {
+        $menu_id = $request->query('menu_id');
+        $user_menu_permission = $this->permissions[$menu_id];
+        return view('data.google-sheet.index', compact('user_menu_permission'));
+    }
+
+    public function create()
+    {
+        return view('data.google-sheet.create');
+    }
+
+    public function show(string $id)
+    {
+        $data = PbgTaskGoogleSheet::find($id);
+        return view('data.google-sheet.show', compact('data'));
+    }
+
+    public function edit(string $id)
+    {
+        return view('data.google-sheet.edit');
+    }
+}

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

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

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

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

@@ -6,6 +6,8 @@ use App\Http\Controllers\Controller;
 use App\Services\ServiceSIMBG;
 use Illuminate\Http\Request;
 use Exception;
+use Illuminate\Support\Facades\Auth;
+use Illuminate\Support\Facades\DB;
 class SyncronizeController extends Controller
 {
     protected $service_simbg;
@@ -13,7 +15,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(){

app/Http/Resources/PbgTaskGoogleSheetResource.php

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

app/Models/RoleMenu.php

@@ -18,6 +18,13 @@ class RoleMenu extends Model
         'allow_destroy',
     ];
 
+    protected $casts = [
+        'allow_show' => 'boolean',
+        'allow_create' => 'boolean',
+        'allow_update' => 'boolean',
+        'allow_destroy' => 'boolean',
+    ];
+
     public $timestamps = true;
 
     public function role(){

app/Models/User.php

@@ -53,4 +53,11 @@ class User extends Authenticatable
     public function roles(){
         return $this->belongsToMany(Role::class, 'user_role')->withTimestamps();
     }
+
+    public function menus(){
+        return Menu::whereHas('roles', function ($query){
+            $query->whereIn('roles.id', $this->roles->pluck('id'))
+            ->where('role_menu.allow_show', true);
+        });
+    }
 }

app/Providers/AppServiceProvider.php

@@ -34,21 +34,24 @@ class AppServiceProvider extends ServiceProvider
     {
         Blade::component('circle', Circle::class);
 
-        View::composer('layouts.partials.sidebar', function ($view){
+        View::composer('layouts.partials.sidebar', function ($view) {
             $user = Auth::user();
 
-            if($user){
-                $menus = Menu::whereHas('roles', function ($query) use ($user){
-                    $query->where('roles.id', $user->roles->pluck('id'));
-                })
-                ->with(['children' => function ($query) {
-                    $query->whereHas('roles', function ($subQuery) {
-                        $subQuery->where('role_menu.allow_show', 1);
-                    });
-                }])
-                ->orderBy('sort_order', 'asc')
-                ->get();
-            }else{
+            if ($user) {
+                $menus = Menu::whereHas('roles', function ($query) use ($user) {
+                        $query->whereIn('roles.id', $user->roles->pluck('id'))
+                            ->where('role_menu.allow_show', 1);
+                    })
+                    ->with(['children' => function ($query) use ($user) {
+                        $query->whereHas('roles', function ($subQuery) use ($user) {
+                            $subQuery->whereIn('roles.id', $user->roles->pluck('id'))
+                                    ->where('role_menu.allow_show', 1);
+                        });
+                    }])
+                    ->whereNull('parent_id') // Ambil hanya menu utama
+                    ->orderBy('sort_order', 'asc')
+                    ->get();
+            } else {
                 $menus = collect();
             }
 

app/Providers/RouteServiceProvider.php

@@ -17,7 +17,7 @@ class RouteServiceProvider extends ServiceProvider
      *
      * @var string
      */
-    public const HOME = '/dashboards/bigdata';
+    public const HOME = '/home';
 
     /**
      * Define your route model bindings, pattern filters, and other route configuration.

database/seeders/UsersRoleMenuSeeder.php

@@ -215,6 +215,13 @@ class UsersRoleMenuSeeder extends Seeder
                 "parent_id" => $data->id,
                 "sort_order" => 7,
             ],
+            [
+                "name" => "Google Sheets",
+                "url" => "google-sheets",
+                "icon" => null,
+                "parent_id" => $data->id,
+                "sort_order" => 8,
+            ],
             [
                 "name" => "Lap Pariwisata",
                 "url" => "tourisms-report.index",
@@ -277,6 +284,7 @@ class UsersRoleMenuSeeder extends Seeder
         $chatbot = Menu::where('name', 'Chat')->first();
         $dalam_sistem = Menu::where('name', 'Dalam Sistem')->first();
         $luar_sistem = Menu::where('name', 'Luar Sistem')->first();
+        $google_sheets = Menu::where('name', 'Google Sheets')->first();
 
         // Superadmin gets all menus
         $superadmin->menus()->sync([
@@ -310,6 +318,7 @@ class UsersRoleMenuSeeder extends Seeder
             $luar_sistem->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
             $bigdata_resume->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
             $chatbot->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
+            $google_sheets->id => ["allow_show" => true, "allow_create" => true, "allow_update" => true, "allow_destroy" => true],
         ]);
 
         // Admin gets limited menus

resources/js/app.js

@@ -2,30 +2,6 @@ import bootstrap from "bootstrap/dist/js/bootstrap";
 window.bootstrap = bootstrap;
 import "iconify-icon";
 import "simplebar/dist/simplebar";
-// import flatpickr from "flatpickr";
-// import "flatpickr/dist/flatpickr.min.css";
-
-// class InitDatePicker {
-//     constructor(selector = ".datepicker") {
-//         this.selector = selector;
-//     }
-//     init() {
-//         const elements = document.querySelectorAll(this.selector);
-//         if (elements.length === 0) return; // Skip if no elements found
-
-//         const today = new Date();
-//         const minYear = today.getFullYear() - 5;
-
-//         elements.forEach((element) => {
-//             flatpickr(element, {
-//                 enableTime: false,
-//                 dateFormat: "Y-m-d",
-//                 minDate: `${minYear}-01-01`,
-//                 maxDate: today,
-//             });
-//         });
-//     }
-// }
 
 class Components {
     initBootstrapComponents() {
@@ -131,7 +107,6 @@ class FormValidation {
 }
 document.addEventListener("DOMContentLoaded", function (e) {
     new Components().init(), new FormValidation().init();
-    // new InitDatePicker().init();
 });
 class ThemeLayout {
     constructor() {

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">
-                                              <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>
-                                              <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>
-                                              </button>
-                                          </div>
-                                      `),
+                    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>
+                                </button>
+                            `;
+                        }
+                
+                        buttons += `</div>`;
+                
+                        return gridjs.html(buttons);
+                    },
                 },
             ],
             pagination: {

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">
-                                      <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>
-                                      <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>
-                                      </button>
-                                  </div>
-                              `),
+                    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>
+                                </button>
+                            `;
+                        }
+        
+                        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>
-                                <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>
+                            `;
+                        }
+        
+                        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>
                                 </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>
-            `);
+                        data-id="${id}">
+                        <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/google-sheet/index.js

@@ -0,0 +1,211 @@
+import { Grid } from "gridjs/dist/gridjs.umd.js";
+import gridjs from "gridjs/dist/gridjs.umd.js";
+import "gridjs/dist/gridjs.umd.js";
+import GlobalConfig from "../../global-config.js";
+
+class GoogleSheets {
+    constructor() {
+        this.toastMessage = document.getElementById("toast-message");
+        this.toastElement = document.getElementById("toastNotification");
+        this.toast = new bootstrap.Toast(this.toastElement);
+        this.table = null;
+
+        // Initialize functions
+        this.initTableGoogleSheets();
+        this.initEvents();
+    }
+
+    initEvents() {
+        document.body.addEventListener("click", async (event) => {
+            const deleteButton = event.target.closest(
+                ".btn-delete-google-sheet"
+            );
+            if (deleteButton) {
+                event.preventDefault();
+                await this.handleDelete(deleteButton);
+            }
+        });
+    }
+
+    initTableGoogleSheets() {
+        let tableContainer = document.getElementById(
+            "table-data-google-sheets"
+        );
+
+        if (!tableContainer) {
+            console.error("Table container not found!");
+            return;
+        }
+
+        // Clear previous table content
+        tableContainer.innerHTML = "";
+
+        // Get user permissions from data attributes
+        let canUpdate = tableContainer.getAttribute("data-updater") === "1";
+        let canDelete = tableContainer.getAttribute("data-destroyer") === "1";
+
+        this.table = new Grid({
+            columns: [
+                "ID",
+                "No Registratsi",
+                "No KRK",
+                "Format STS",
+                "Fungsi BG",
+                "Selesai Terbit",
+                "Selesai Verifikasi",
+                "Tanggal Permohonan",
+                {
+                    name: "Action",
+                    formatter: (cell) => {
+                        let buttons = "";
+
+                        buttons += `
+                          <a href="/data/google-sheets/${cell}" class="btn btn-primary btn-sm d-inline-flex align-items-center justify-content-center">
+                            <i class='bx bx-show'></i>
+                          </a>
+                        `;
+
+                        if (canUpdate) {
+                            buttons += `
+                            <a href="#" 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-google-sheet d-inline-flex align-items-center justify-content-center">
+                                <i class='bx bxs-trash'></i>
+                            </button>
+                        `;
+                        }
+
+                        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: {
+                limit: 50,
+                server: {
+                    url: (prev, page) => {
+                        let separator = prev.includes("?") ? "&" : "?";
+                        return `${prev}${separator}page=${page + 1}`;
+                    },
+                },
+            },
+            sort: true,
+            search: {
+                server: {
+                    url: (prev, keyword) => {
+                        let separator = prev.includes("?") ? "&" : "?";
+                        return `${prev}${separator}search=${encodeURIComponent(
+                            keyword
+                        )}`;
+                    },
+                },
+                debounceTimeout: 1000,
+            },
+            server: {
+                url: `${GlobalConfig.apiHost}/api/pbg-task-google-sheet`,
+                headers: {
+                    Authorization: `Bearer ${document
+                        .querySelector('meta[name="api-token"]')
+                        .getAttribute("content")}`,
+                    "Content-Type": "application/json",
+                },
+                then: (data) => {
+                    if (!data || !data.data) {
+                        console.warn("⚠️ No data received from API");
+                        return [];
+                    }
+
+                    return data.data.map((item) => {
+                        console.log("🔹 Processing Item:", item);
+                        return [
+                            item.id,
+                            item.no_registrasi,
+                            item.no_krk,
+                            item.format_sts,
+                            item.fungsi_bg,
+                            item.selesai_terbit,
+                            item.selesai_verifikasi,
+                            item.tgl_permohonan,
+                            item.id,
+                        ];
+                    });
+                },
+                total: (data) => {
+                    let totalRecords = data?.meta?.total || 0;
+                    return totalRecords;
+                },
+                catch: (error) => {
+                    console.error("❌ Error fetching data:", error);
+                },
+            },
+        }).render(tableContainer);
+    }
+
+    async handleDelete(deleteButton) {
+        const id = deleteButton.getAttribute("data-id");
+
+        const result = await Swal.fire({
+            title: "Are you sure?",
+            text: "You won't be able to revert this!",
+            icon: "warning",
+            showCancelButton: true,
+            confirmButtonColor: "#3085d6",
+            cancelButtonColor: "#d33",
+            confirmButtonText: "Yes, delete it!",
+        });
+
+        if (result.isConfirmed) {
+            try {
+                let response = await fetch(
+                    `${GlobalConfig.apiHost}/api/pbg-task-google-sheet/${id}`,
+                    {
+                        method: "DELETE",
+                        credentials: "include",
+                        headers: {
+                            Authorization: `Bearer ${document
+                                .querySelector('meta[name="api-token"]')
+                                .getAttribute("content")}`,
+                            "Content-Type": "application/json",
+                        },
+                    }
+                );
+
+                if (response.ok) {
+                    let result = await response.json();
+                    this.toastMessage.innerText =
+                        result.message || "Deleted successfully!";
+                    this.toast.show();
+
+                    // Refresh Grid.js table
+                    if (typeof this.table !== "undefined") {
+                        this.table.updateConfig({}).forceRender();
+                    }
+                } else {
+                    let error = await response.json();
+                    console.error("Delete failed:", error);
+                    this.toastMessage.innerText =
+                        error.message || "Delete failed!";
+                    this.toast.show();
+                }
+            } catch (error) {
+                console.error("Error deleting item:", error);
+                this.toastMessage.innerText = "An error occurred!";
+                this.toast.show();
+            }
+        }
+    }
+}
+document.addEventListener("DOMContentLoaded", function (e) {
+    new GoogleSheets();
+});

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/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,25 +29,52 @@ 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">
-                    <button class="btn btn-warning me-2 btn-edit" 
-                        data-id="${id}" 
+
+            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>'
+            );
         },
     },
 ];
@@ -51,6 +86,15 @@ document.addEventListener("DOMContentLoaded", () => {
         `${GlobalConfig.apiHost}`,
         dataTourismsColumns
     );
+    const customIcon = new L.Icon({
+        iconUrl: "/leaflet/marker-icon.png",
+        iconRetinaUrl: "leaflet/marker-icon-2x.png",
+        shadowUrl: "/leaflet/marker-shadow.png",
+        iconSize: [25, 41],
+        iconAnchor: [12, 41],
+        popupAnchor: [1, -34],
+        shadowSize: [41, 41],
+    });
 
     table.processData = function (data) {
         return data.data.map((item) => {
@@ -74,24 +118,133 @@ 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();
+
+            const loading = document.getElementById("loading");
+            loading.style.display = "block";
+
+            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], { icon: customIcon })
+                    .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());
+                        loading.style.display = "none";
+                    })
+                    .catch((error) => {
+                        console.error("Error loading GeoJSON:", error);
+                        loading.style.display = "none";
+                    });
+            }, 500);
         }
     });
 });

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>
-            `);
+                        data-id="${id}">
+                        <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/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,35 +28,9 @@ class Menus {
     initTableMenus() {
         let tableContainer = document.getElementById("table-menus");
 
-        // if (this.table) {
-        //     // If table exists, update its data instead of recreating
-        //     this.table
-        //         .updateConfig({
-        //             server: {
-        //                 url: `${GlobalConfig.apiHost}/api/menus`,
-        //                 credentials: "include",
-        //                 headers: {
-        //                     Authorization: `Bearer ${document
-        //                         .querySelector('meta[name="api-token"]')
-        //                         .getAttribute("content")}`,
-        //                     "Content-Type": "application/json",
-        //                 },
-        //                 then: (data) =>
-        //                     data.data.map((item) => [
-        //                         item.id,
-        //                         item.name,
-        //                         item.url,
-        //                         item.icon,
-        //                         item.parent_id,
-        //                         item.sort_order,
-        //                         item.id,
-        //                     ]),
-        //                 total: (data) => data.total,
-        //             },
-        //         })
-        //         .forceRender();
-        //     return;
-        // }
+        tableContainer.innerHTML = "";
+        let canUpdate = tableContainer.getAttribute("data-updater") === "1";
+        let canDelete = tableContainer.getAttribute("data-destroyer") === "1";
 
         this.table = new Grid({
             columns: [
@@ -68,18 +42,33 @@ class Menus {
                 "Sort Order",
                 {
                     name: "Action",
-                    formatter: (cell) =>
-                        gridjs.html(`
-                        <div class="d-flex justify-content-center align-items-center gap-2">
-                            <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>
-                            </button>
-                        </div>
-                      `),
+                    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>
+                            `;
+                        }
+
+                        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>
+                            `;
+                        }
+
+                        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: [
@@ -34,22 +38,38 @@ class Roles {
                 "Name",
                 "Description",
                 {
-                    name: "Action",
-                    formatter: (cell) =>
-                        gridjs.html(`
-                            <div class="d-flex justify-content-center gap-2">
-                                <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>
-                                <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>
-                                </button>
-                            </div>
-                        `),
+                name: "Action",
+                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>
+                            </button>
+                        `;
+                    }
+
+                    if (!canUpdate && !canDelete) {
+                        buttons += `<span class="text-muted">No Privilege</span>`;
+                    }
+
+                    buttons += `</div>`;
+
+                    return gridjs.html(buttons);
                 },
+            },
             ],
             pagination: {
                 limit: 50,

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 || {
@@ -42,8 +47,8 @@ class GeneralTable {
                 total: (data) => data.meta.total,
             },
         });
-
-        table.render(document.getElementById(this.tableId));
+    
+        table.render(tableContainer);
         this.handleActions();
     }
 

resources/scss/structure/_sidebar_custom.scss

@@ -0,0 +1,120 @@
+//
+// sidebar_custom.scss
+//
+
+.app-sidebar {
+    box-shadow: 2px 0 10px rgba(0, 0, 0, 0.1);
+    background-color: #f8f9fa; /* Warna sidebar putih */
+}
+
+.logo-box {
+    text-align: center;
+    padding: 15px;
+    border-bottom: 1px solid rgba(0, 0, 0, 0.1);
+}
+
+/* Menu utama */
+.navbar-nav {
+    list-style: none;
+    padding: 0;
+    margin: 0;
+}
+
+.menu-title {
+    font-size: 14px;
+    font-weight: bold;
+    text-transform: uppercase;
+    color: #6c757d;
+    padding: 10px 15px;
+    border-bottom: 1px solid rgba(0, 0, 0, 0.1);
+}
+
+/* Parent Menu */
+.nav-item {
+    position: relative;
+}
+
+.nav-item > .nav-link {
+    display: flex;
+    align-items: center;
+    font-size: 16px;
+    font-weight: bold;
+    color: #343a40;
+    text-decoration: none;
+    padding: 12px 20px;
+    transition: background 0.3s ease-in-out, color 0.3s ease-in-out;
+    cursor: pointer;
+}
+
+.nav-item > .nav-link:hover {
+    background: rgba(0, 0, 0, 0.05);
+    color: #007bff;
+}
+
+/* Ikon di sebelah kiri menu */
+.nav-icon {
+    font-size: 20px;
+    margin-right: 10px;
+    color: #6c757d;
+}
+
+/* CHILD MENU (Submenu) */
+.sub-navbar-nav {
+    list-style: none;
+    padding-left: 20px;
+}
+
+/* Menampilkan submenu ketika parent di-hover atau memiliki fokus */
+.nav-item:hover > .sub-navbar-nav,
+.nav-item:focus-within > .sub-navbar-nav {
+    display: block;
+}
+
+/* Aturan untuk setiap submenu item */
+.sub-navbar-nav .nav-item {
+    margin-left: 0;
+    width: 100%;
+}
+
+.sub-navbar-nav .nav-link {
+    font-size: 14px;
+    font-weight: normal;
+    color: #6c757d;
+    display: flex;
+    align-items: center;
+    padding: 8px 15px;
+    transition: color 0.3s ease-in-out, background 0.3s ease-in-out;
+}
+
+/* Hover effect untuk submenu */
+.sub-navbar-nav .nav-link:hover {
+    background: rgba(0, 0, 0, 0.05);
+    color: #007bff;
+}
+
+/* CHILD dari CHILD (Level lebih dalam) */
+.sub-navbar-nav .sub-navbar-nav {
+    margin-left: 15px;
+}
+
+/* Menampilkan submenu level dalam saat parent di-hover */
+.nav-item:hover > .sub-navbar-nav .nav-item:hover > .sub-navbar-nav {
+    display: block;
+}
+
+/* Aturan tambahan untuk submenu anak-anak */
+.sub-navbar-nav .sub-navbar-nav .nav-link {
+    font-size: 13px;
+    color: #868e96;
+}
+
+/* Ikon anak panah saat menu terbuka */
+.menu-arrow {
+    transition: transform 0.3s ease;
+}
+
+/* Efek putar ikon saat submenu terbuka */
+.nav-item:hover > .nav-link .menu-arrow,
+.nav-item:focus-within > .nav-link .menu-arrow {
+    transform: rotate(90deg);
+}

resources/scss/style.scss

@@ -16,6 +16,7 @@
 @import "structure/general";
 @import "structure/topbar";
 @import "structure/sidebar";
+@import "structure/sidebar_custom";
 @import "structure/footer";
 @import "structure/page-title";
 

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">
-					<a href="{{ route('business-industries.create')}}" class="btn btn-success btn-sm d-block d-sm-inline w-auto">Upload</a>
+					@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/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">
-                    <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>
+                    @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/dashboards/potentials/outside_system.blade.php

@@ -19,7 +19,7 @@
             </div>
         </div>
     </div>
-    <div id="outside-system-fixed-container" class="" style="width:1400px;height:770px;position:relative;margin:auto;z-index:1;">
+    <div id="outside-system-fixed-container" class="" style="width:880px;height:770px;position:relative;margin:auto;z-index:1;">
         <div style="position: absolute; top: 70px; left: 50px; width: 200px; height: 500px;">
             @component('components.circle', [
                 'document_title' => 'Non Usaha',

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">
-					<a href="{{ route('data-settings.create')}}" class="btn btn-success btn-sm d-block d-sm-inline w-auto">Create</a>
+					@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,16 +16,21 @@
     <div class="card-body">
         <div class="row">
             <div class="d-flex justify-content-end gap-10 pb-3">
-                <button class="btn btn-success me-2 width-lg btn-create" data-model="data/advertisements">
-                    <i class='bx bxs-file-plus'></i>
-                    Create</button>
-                <button class="btn btn-primary width-lg btn-bulk-create" data-model="data/advertisements">
-                    <i class='bx bx-upload' ></i>
-                    Bulk Create
-                </button>
+                @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>
+                    <button class="btn btn-primary width-lg btn-bulk-create" data-model="data/advertisements">
+                        <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/google-sheet/create.blade.php

@@ -0,0 +1,162 @@
+@extends('layouts.vertical', ['subtitle' => 'Menu'])
+
+@section('content')
+
+@include('layouts.partials/page-title', ['title' => 'Settings', 'subtitle' => 'Menu'])
+
+<x-toast-notification />
+<div class="row">
+    <div class="card">
+        <div class="card-header d-flex justify-content-end">
+            <a href="{{ route('google-sheets') }}" class="btn btn-sm btn-secondary">Back</a>
+        </div>
+        <form id="formCreateGoogleSheet" action="{{route("pbg-task-google-sheet.store")}}" method="post">
+            @csrf
+            <div class="row">
+                <div class="col-6">
+                    <div class="mb-3 mr-3">
+                        <label class="form-label" for="jenis_konsultasi">Jenis Konsultasi</label>
+                        <input type="text" id="jenis_konsultasi" name="jenis_konsultasi"
+                                class="form-control" placeholder="Jenis Konsultasi" >
+                    </div>
+                    <div class="mb-3 mr-3">
+                        <label class="form-label" for="no_registrasi">No Registrasi</label>
+                        <input type="text" id="no_registrasi" name="no_registrasi"
+                                class="form-control" placeholder="Nomor Registrasi" >
+                    </div>
+                    <div class="mb-3 mr-3">
+                        <label class="form-label" for="nama_pemilik">Nama Pemilik</label>
+                        <input type="text" id="nama_pemilik" name="nama_pemilik"
+                                class="form-control" placeholder="Nama Pemilik" >
+                    </div>
+                    <div class="mb-3 mr-3">
+                        <label class="form-label" for="lokasi_bg">Lokasi BG</label>
+                        <input type="text" id="lokasi_bg" name="lokasi_bg"
+                                class="form-control" placeholder="Lokasi BG" >
+                    </div>
+                    <div class="mb-3 mr-3">
+                        <label class="form-label" for="fungsi_bg">Fungsi BG</label>
+                        <input type="text" id="fungsi_bg" name="fungsi_bg"
+                                class="form-control" placeholder="Fungsi BG" >
+                    </div>
+                    <div class="mb-3 mr-3">
+                        <label class="form-label" for="nama_bangunan">Nama Bangunan</label>
+                        <input type="text" id="nama_bangunan" name="nama_bangunan"
+                                class="form-control" placeholder="Nama Bangunan" >
+                    </div>
+                    <div class="mb-3 mr-3">
+                        <label class="form-label" for="tgl_permohonan">Tanggal Permohonan</label>
+                        <input type="text" id="tgl_permohonan" name="tgl_permohonan"
+                                class="form-control" placeholder="Tanggal Permohonan" >
+                    </div>
+                    <div class="mb-3 mr-3">
+                        <label class="form-label" for="status_verifikasi">Status Verifikasi</label>
+                        <input type="text" id="status_verifikasi" name="status_verifikasi"
+                                class="form-control" placeholder="Status Verifikasi" >
+                    </div>
+                    <div class="mb-3 mr-3">
+                        <label class="form-label" for="status_permohonan">Status Permohonan</label>
+                        <input type="text" id="status_permohonan" name="status_permohonan"
+                                class="form-control" placeholder="Status Permohonan" >
+                    </div>
+                    <div class="mb-3 mr-3">
+                        <label class="form-label" for="status_permohonan">Status Permohonan</label>
+                        <input type="text" id="status_permohonan" name="status_permohonan"
+                                class="form-control" placeholder="Status Permohonan" >
+                    </div>
+                    <div class="mb-3 mr-3">
+                        <label class="form-label" for="alamat_pemilik">Alamat Pemilik</label>
+                        <input type="text" id="alamat_pemilik" name="alamat_pemilik"
+                                class="form-control" placeholder="Alamat Pemilik" >
+                    </div>
+                </div>
+                <div class="col-6">
+                    <div class="mb-3">
+                        <label class="form-label" for="no_hp">No Hp</label>
+                        <input type="text" id="no_hp" name="no_hp"
+                                class="form-control" placeholder="No Hp" >
+                    </div>
+                    <div class="mb-3">
+                        <label class="form-label" for="email">Email</label>
+                        <input type="text" id="email" name="email"
+                                class="form-control" placeholder="Email" >
+                    </div>
+                    <div class="mb-3">
+                        <label class="form-label" for="tanggal_catatan">Tanggal Catatan</label>
+                        <input type="text" id="tanggal_catatan" name="tanggal_catatan"
+                                class="form-control" placeholder="Tanggal Catatan" >
+                    </div>
+                    <div class="mb-3">
+                        <label class="form-label" for="catatan_kekurangan_dokumen">Catatan Kekurangan Dokumen</label>
+                        <input type="text" id="catatan_kekurangan_dokumen" name="catatan_kekurangan_dokumen"
+                                class="form-control" placeholder="Catatan Kekurangan Dokumen" >
+                    </div>
+                    <div class="mb-3">
+                        <label class="form-label" for="gambar">Gambar</label>
+                        <input type="text" id="gambar" name="gambar"
+                                class="form-control" placeholder="Gambar" >
+                    </div>
+                    <div class="mb-3">
+                        <label class="form-label" for="krk_kkpr">KRK KKPR</label>
+                        <input type="text" id="krk_kkpr" name="krk_kkpr"
+                                class="form-control" placeholder="KRK KKPR" >
+                    </div>
+                    <div class="mb-3">
+                        <label class="form-label" for="no_krk">NO KRK</label>
+                        <input type="text" id="no_krk" name="no_krk"
+                                class="form-control" placeholder="NO KRK" >
+                    </div>
+                    <div class="mb-3">
+                        <label class="form-label" for="lh">LH</label>
+                        <input type="text" id="lh" name="lh"
+                                class="form-control" placeholder="LH" >
+                    </div>
+                    <div class="mb-3">
+                        <label class="form-label" for="ska">SKA</label>
+                        <input type="text" id="ska" name="ska"
+                                class="form-control" placeholder="SKA" >
+                    </div>
+                    <div class="mb-3">
+                        <label class="form-label" for="keterangan">Keterangan</label>
+                        <input type="text" id="keterangan" name="keterangan"
+                                class="form-control" placeholder="Keterangan" >
+                    </div>
+                    <div class="mb-3">
+                        <label class="form-label" for="helpdesk">Help Desk</label>
+                        <input type="text" id="helpdesk" name="helpdesk"
+                                class="form-control" placeholder="Help Desk" >
+                    </div>
+                    <div class="mb-3">
+                        <label class="form-label" for="pj">PJ</label>
+                        <input type="text" id="pj" name="pj" class="form-control" placeholder="PJ" >
+                    </div>
+                    <div class="mb-3">
+                        <label class="form-label" for="kepemilikan">Kepemilikan</label>
+                        <input type="text" id="kepemilikan" name="kepemilikan" class="form-control" placeholder="Kepemilikan" >
+                    </div>
+                    <div class="mb-3">
+                        <label class="form-label" for="potensi_taru">Potensi Taru</label>
+                        <input type="text" id="potensi_taru" name="potensi_taru" class="form-control" placeholder="Potensi Taru" >
+                    </div>
+                    <div class="mb-3">
+                        <label class="form-label" for="validasi_dinas">Validasi Dinas</label>
+                        <input type="text" id="validasi_dinas" name="validasi_dinas" class="form-control" placeholder="Validasi Dinas" >
+                    </div>
+                    <div class="mb-3">
+                        <label class="form-label" for="kategori_retribusi">Kategori Retribusi</label>
+                        <input type="text" id="kategori_retribusi" name="kategori_retribusi" class="form-control" placeholder="Kategori Retribusi" >
+                    </div>
+                </div>
+            </div>
+            <button class="btn btn-primary me-1" type="button" id="btnCreateGoogleSheet">
+                <span id="spinner" class="spinner-border spinner-border-sm me-1 d-none" role="status" aria-hidden="true"></span>
+                Create
+            </button>
+        </form>
+    </div>
+</div>
+
+@endsection
+
+@section('scripts')
+@endsection

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

@@ -0,0 +1,3 @@
+<div>
+    <!-- Always remember that you are absolutely unique. Just like everyone else. - Margaret Mead -->
+</div>

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

@@ -0,0 +1,35 @@
+@extends('layouts.vertical', ['subtitle' => 'Google Sheets'])
+
+@section('css')
+@vite(['node_modules/gridjs/dist/theme/mermaid.min.css'])
+@endsection
+
+@section('content')
+
+@include('layouts.partials/page-title', ['title' => 'Data', 'subtitle' => 'Google Sheets'])
+
+<x-toast-notification />
+
+<div class="row">
+	<div class="col-12">
+		<div class="card w-100">
+			<div class="card-body">
+				<div class="d-flex flex-wrap justify-content-end align-items-center mb-2">
+					@if ($user_menu_permission['allow_create'])
+						<a href="#" class="btn btn-success btn-sm d-block d-sm-inline w-auto">Create</a>
+					@endif
+				</div>
+				<div id="table-data-google-sheets"
+                     data-updater="{{ $user_menu_permission['allow_update'] }}"
+                     data-destroyer="{{ $user_menu_permission['allow_destroy'] }}">
+				</div>
+			</div>
+		</div>
+	</div>
+</div>
+
+@endsection
+
+@section('scripts')
+@vite(['resources/js/data/google-sheet/index.js'])
+@endsection

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

@@ -0,0 +1,90 @@
+@extends('layouts.vertical', ['subtitle' => 'Google Sheets'])
+
+@section('css')
+@endsection
+
+@section('content')
+
+@include('layouts.partials/page-title', ['title' => 'Data', 'subtitle' => 'Google Sheets'])
+
+<x-toast-notification />
+<div class="card w-100">
+  <div class="card-header d-flex justify-content-end">
+    <a href="{{ route('google-sheets', ['menu_id' => 32]) }}" class="btn btn-sm btn-secondary">Back</a>
+  </div>
+  <div class="card-body">
+    <div class="row">
+      @php
+        function displayData($label, $value) {
+            echo "<dt>{$label}</dt><dd>" . (!empty($value) ? $value : '-') . "</dd>";
+        }
+      @endphp
+
+      <div class="col-sm-6 col-md-6 col-lg-6">
+          @php
+            displayData('Jenis Konsultasi', $data->jenis_konsultasi);
+            displayData('No Registrasi', $data->no_registrasi);
+            displayData('Nama Pemilik', $data->nama_pemilik);
+            displayData('Lokasi Bangunan', $data->lokasi_bg);
+            displayData('Fungsi Bangunan', $data->fungsi_bg);
+            displayData('Nama Bangunan', $data->nama_bangunan);
+            displayData('Tanggal Permohonan', $data->tgl_permohonan);
+            displayData('Status Verifikasi', $data->status_verifikasi);
+            displayData('Status Permohonan', $data->status_permohonan);
+            displayData('Alamat Pemilik', $data->alamat_pemilik);
+            displayData('No Hp', $data->no_hp);
+            displayData('Email', $data->email);
+            displayData('Tanggal Catatan', $data->tanggal_catatan);
+            displayData('Catatan Kekurangan Dokumen', $data->catatan_kekurangan_dokumen);
+            displayData('Gambar', $data->gambar);
+            displayData('KRK KKPR', $data->krk_kkpr);
+            displayData('No KRK', $data->no_krk);
+            displayData('LH', $data->lh);
+            displayData('SKA', $data->ska);
+            displayData('Keterangan', $data->keterangan);
+            displayData('Helpdesk', $data->helpdesk);
+            displayData('PJ', $data->pj);
+            displayData('Kepemilikan', $data->Kepemilikan);
+            displayData('Potensi Taru', $data->potensi_taru);
+            displayData('Validasi Dinas', $data->validasi_dinas);
+            displayData('Kategori Retribusi', $data->kategori_retribusi);
+          @endphp
+      </div>
+
+      <div class="col-sm-6 col-md-6 col-lg-6">
+          @php
+            displayData('No Urut BA TPT', $data->no_urut_ba_tpt);
+            displayData('Tanggal BA TPT', $data->tanggal_ba_tpt);
+            displayData('No Urut BA TPA', $data->no_urut_ba_tpa);
+            displayData('Tanggal BA TPA', $data->tanggal_ba_tpa);
+            displayData('No Urut SKRD', $data->no_urut_skrd);
+            displayData('Tanggal SKRD', $data->tanggal_skrd);
+            displayData('PTSP', $data->ptsp);
+            displayData('Selesai Terbit', $data->selesai_terbit);
+            displayData('Tanggal Pembayaran', $data->tanggal_pembayaran);
+            displayData('Format STS', $data->format_sts);
+            displayData('Tahun Terbit', $data->tahun_terbit);
+            displayData('Tahun Berjalan', $data->tahun_berjalan);
+            displayData('Kelurahan', $data->kelurahan);
+            displayData('Kecamatan', $data->kecamatan);
+            displayData('LB', $data->lb);
+            displayData('TB', $data->tb);
+            displayData('JLB', $data->jlb);
+            displayData('Unit', $data->unit);
+            displayData('Usulan Retribusi', $data->usulan_retribusi);
+            displayData('Nilai Retribusi Keseluruhan SIMBG', $data->nilai_retribusi_keseluruhan_simbg);
+            displayData('Nilai Retribusi Keseluruhan PAD', $data->nilai_retribusi_keseluruhan_pad);
+            displayData('Denda', $data->denda);
+            displayData('Latitude', $data->latitude);
+            displayData('Longitude', $data->longitude);
+            displayData('NIK NIB', $data->nik_nib);
+            displayData('Dokumen Tanah', $data->dok_tanah);
+            displayData('Temuan', $data->temuan);
+          @endphp
+      </div>
+    </div>
+  </div>
+</div>
+
+
+@endsection

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

@@ -14,16 +14,21 @@
     <div class="card-body">
         <div class="row">
             <div class="d-flex justify-content-end gap-10 pb-3">
-                <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>
-                <button class="btn btn-primary width-lg btn-bulk-create" data-model="data/spatial-plannings">
-                    <i class='bx bx-upload' ></i>
-                    Bulk Create
-                </button>
+                @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>
+                    <button class="btn btn-primary width-lg btn-bulk-create" data-model="data/spatial-plannings">
+                        <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,16 +14,21 @@
     <div class="card-body">
         <div class="row">
             <div class="d-flex justify-content-end gap-10 pb-3">
-                <button class="btn btn-success me-2 width-lg btn-create" data-model="data/tourisms">
-                    <i class='bx bxs-file-plus'></i>
-                    Create</button>
-                <button class="btn btn-primary width-lg btn-bulk-create" data-model="data/tourisms">
-                    <i class='bx bx-upload' ></i>
-                    Bulk Create
-                </button>
+                @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>
+                    <button class="btn btn-primary width-lg btn-bulk-create" data-model="data/tourisms">
+                        <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>
@@ -35,25 +40,21 @@
     <div class="modal-dialog modal-dialog-centered modal-lg  modal-sm">
         <div class="modal-content">
             <div class="modal-header">
+                <div id="loading" style="display: none; text-align: center; padding: 20px;">
+                    <div class="spinner-border" role="status">
+                        <span class="visually-hidden">Loading...</span>
+                    </div>
+                </div>
                 <button type="button" class="btn-close" data-bs-dismiss="modal"
                     aria-label="Close"></button>
             </div>
             <div class="modal-body">
-                <iframe 
-                        src="" 
-                        width="100%" 
-                        height="450" 
-                        style="border:0;" 
-                        allowfullscreen="" 
-                        loading="lazy">
-                </iframe>
+                <div id="map" style="height: 400px;"></div>
             </div>
         </div>
     </div>
 </div>
 
-{{-- <div id="alert-container"></div> --}}
-
 @endsection
 
 @section('scripts')

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

@@ -14,16 +14,21 @@
     <div class="card-body">
         <div class="row">
             <div class="d-flex justify-content-end gap-10 pb-3">
-                <button class="btn btn-success me-2 width-lg btn-create" data-model="data/umkm">
-                    <i class='bx bxs-file-plus'></i>
-                    Create</button>
-                <button class="btn btn-primary width-lg btn-bulk-create" data-model="data/umkm">
-                    <i class='bx bx-upload' ></i>
-                    Bulk Create
-                </button>
+                @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>
+                    <button class="btn btn-primary width-lg btn-bulk-create" data-model="data/umkm">
+                        <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/home/index.blade.php

@@ -1,396 +1,9 @@
-@extends('layouts.vertical', ['subtitle' => 'Dashboard'])
+@extends('layouts.vertical', ['subtitle' => 'Home'])
 
 @section('content')
 
-@include('layouts.partials/page-title', ['title' => 'Home', 'subtitle' => 'Dashboard'])
+@include('layouts.partials/page-title', ['title' => 'Home', 'subtitle' => 'Home'])
 
-<div class="row">
-    <!-- Card 1 -->
-    <div class="col-md-6 col-xl-3">
-        <div class="card">
-            <div class="card-body">
-                <div class="row">
-                    <div class="col-6">
-                        <p class="text-muted mb-0 text-truncate">Total Income</p>
-                        <h3 class="text-dark mt-2 mb-0">$78.8k</h3>
-                    </div>
-
-                    <div class="col-6">
-                        <div class="ms-auto avatar-md bg-soft-primary rounded">
-                            <iconify-icon icon="solar:globus-outline"
-                                class="fs-32 avatar-title text-primary"></iconify-icon>
-                        </div>
-                    </div>
-                </div>
-            </div>
-            <div id="chart01"></div>
-        </div>
-    </div>
-
-    <!-- Card 2 -->
-    <div class="col-md-6 col-xl-3">
-        <div class="card">
-            <div class="card-body">
-                <div class="row">
-                    <div class="col-6">
-                        <p class="text-muted mb-0 text-truncate">New Users</p>
-                        <h3 class="text-dark mt-2 mb-0">2,150</h3>
-                    </div>
-
-                    <div class="col-6">
-                        <div class="ms-auto avatar-md bg-soft-primary rounded">
-                            <iconify-icon icon="solar:users-group-two-rounded-broken"
-                                class="fs-32 avatar-title text-primary"></iconify-icon>
-                        </div>
-                    </div>
-                </div>
-            </div>
-            <div id="chart02"></div>
-        </div>
-    </div>
-
-    <!-- Card 3 -->
-    <div class="col-md-6 col-xl-3">
-        <div class="card">
-            <div class="card-body">
-                <div class="row">
-                    <div class="col-6">
-                        <p class="text-muted mb-0 text-truncate">Orders</p>
-                        <h3 class="text-dark mt-2 mb-0">1,784</h3>
-                    </div>
-
-                    <div class="col-6">
-                        <div class="ms-auto avatar-md bg-soft-primary rounded">
-                            <iconify-icon icon="solar:cart-5-broken"
-                                class="fs-32 avatar-title text-primary"></iconify-icon>
-                        </div>
-                    </div>
-                </div>
-            </div>
-            <div id="chart03"></div>
-        </div>
-    </div>
-
-    <!-- Card 4 -->
-    <div class="col-md-6 col-xl-3">
-        <div class="card">
-            <div class="card-body">
-                <div class="row">
-                    <div class="col-6">
-                        <p class="text-muted mb-0 text-truncate">Conversion Rate</p>
-                        <h3 class="text-dark mt-2 mb-0">12.3%</h3>
-                    </div>
-
-                    <div class="col-6">
-                        <div class="ms-auto avatar-md bg-soft-primary rounded">
-                            <iconify-icon icon="solar:pie-chart-2-broken"
-                                class="fs-32 avatar-title text-primary"></iconify-icon>
-                        </div>
-                    </div>
-                </div>
-            </div>
-            <div id="chart04"></div>
-        </div>
-    </div>
-</div>
-
-
-
-<div class="row">
-    <div class="col-lg-4">
-        <div class="card card-height-100">
-            <div class="card-header d-flex align-items-center justify-content-between gap-2">
-                <h4 class=" mb-0 flex-grow-1 mb-0">Revenue</h4>
-                <div>
-                    <button type="button" class="btn btn-sm btn-outline-light">ALL</button>
-                    <button type="button" class="btn btn-sm btn-outline-light">1M</button>
-                    <button type="button" class="btn btn-sm btn-outline-light">6M</button>
-                    <button type="button" class="btn btn-sm btn-outline-light active">1Y</button>
-                </div>
-            </div>
-
-            <div class="card-body pt-0">
-                <div dir="ltr">
-                    <div id="dash-performance-chart" class="apex-charts"></div>
-                </div>
-            </div>
-
-        </div> <!-- end card-->
-    </div> <!-- end col -->
-
-    <div class="col-lg-4">
-        <div class="card card-height-100">
-            <div class="card-header d-flex align-items-center justify-content-between gap-2">
-                <h4 class="card-title flex-grow-1 mb-0">Sales By Category</h4>
-                <div>
-                    <button type="button" class="btn btn-sm btn-outline-light">ALL</button>
-                    <button type="button" class="btn btn-sm btn-outline-light">1M</button>
-                    <button type="button" class="btn btn-sm btn-outline-light">6M</button>
-                    <button type="button" class="btn btn-sm btn-outline-light active">1Y</button>
-                </div>
-            </div>
-
-            <div class="card-body">
-                <div dir="ltr">
-                    <div id="conversions" class="apex-charts"></div>
-                </div>
-                <div class="table-responsive mb-n1 mt-2">
-                    <table class="table table-nowrap table-borderless table-sm table-centered mb-0">
-                        <thead class="bg-light bg-opacity-50 thead-sm">
-                            <tr>
-                                <th class="py-1">
-                                    Category
-                                </th>
-                                <th class="py-1">Orders</th>
-                                <th class="py-1">Perc.</th>
-                            </tr>
-                        </thead>
-                        <tbody>
-                            <tr>
-                                <td>Grocery</td>
-                                <td>187,232</td>
-                                <td>
-                                    48.63%
-                                    <span class="badge badge-soft-success float-end">2.5% Up</span>
-                                </td>
-                            </tr>
-                            <tr>
-                                <td>Electonics</td>
-                                <td>126,874</td>
-                                <td>
-                                    36.08%
-                                    <span class="badge badge-soft-success float-end">8.5% Up</span>
-                                </td>
-                            </tr>
-                            <tr>
-                                <td>Other</td>
-                                <td>90,127</td>
-                                <td>
-                                    23.41%
-                                    <span class="badge badge-soft-danger float-end">10.98% Down</span>
-                                </td>
-                            </tr>
-                        </tbody>
-                    </table>
-                </div>
-                <!-- end table-responsive-->
-            </div>
-
-        </div> <!-- end card-->
-    </div> <!-- end col -->
-
-    <div class="col-lg-4">
-        <div class="card">
-            <div
-                class="d-flex card-header justify-content-between align-items-center border-bottom border-dashed">
-                <h4 class="card-title mb-0">Sessions by Country</h4>
-                <div class="dropdown">
-                    <a href="#" class="dropdown-toggle btn btn-sm btn-outline-light"
-                        data-bs-toggle="dropdown" aria-expanded="false">
-                        View Data
-                    </a>
-                    <div class="dropdown-menu dropdown-menu-end">
-                        <!-- item-->
-                        <a href="javascript:void(0);" class="dropdown-item">Download</a>
-                        <!-- item-->
-                        <a href="javascript:void(0);" class="dropdown-item">Export</a>
-                        <!-- item-->
-                        <a href="javascript:void(0);" class="dropdown-item">Import</a>
-                    </div>
-                </div>
-            </div>
-
-            <div class="card-body pt-0">
-                <div id="world-map-markers" class="mt-3" style="height: 309px">
-                </div>
-            </div> <!-- end card-body-->
-
-
-        </div> <!-- end card-->
-    </div> <!-- end col-->
-
-</div> <!-- End row -->
-
-<div class="row">
-    <div class="col-xl-6">
-        <div class="card">
-            <div class="card-header d-flex justify-content-between align-items-center">
-                <h4 class="card-title mb-0">New Accounts</h4>
-                <a href="#!" class="btn btn-sm btn-light">
-                    View All
-                </a>
-            </div>
-            <!-- end card-header-->
-
-            <div class="card-body pb-1">
-                <div class="table-responsive">
-                    <table class="table table-hover mb-0 table-centered">
-                        <thead>
-                            <th class="py-1">ID</th>
-                            <th class="py-1">Date</th>
-                            <th class="py-1">User</th>
-                            <th class="py-1">Account</th>
-                            <th class="py-1">Username</th>
-                        </thead>
-                        <tbody>
-                            <tr>
-                                <td>#US523</td>
-                                <td>24 April, 2024</td>
-                                <td>
-                                    <img src="/images/users/avatar-2.jpg" alt="avatar-2"
-                                        class="img-fluid avatar-xs rounded-circle" />
-                                    <span class="align-middle ms-1">Dan Adrick</span>
-                                </td>
-                                <td>
-                                    <span class="badge badge-soft-success">Verified</span>
-                                </td>
-                                <td>@omions</td>
-                            </tr>
-                            <tr>
-                                <td>#US652</td>
-                                <td>24 April, 2024</td>
-                                <td>
-                                    <img src="/images/users/avatar-3.jpg" alt="avatar-2"
-                                        class="img-fluid avatar-xs rounded-circle" />
-                                    <span class="align-middle ms-1">Daniel Olsen</span>
-                                </td>
-                                <td>
-                                    <span class="badge badge-soft-success">Verified</span>
-                                </td>
-                                <td>@alliates</td>
-                            </tr>
-                            <tr>
-                                <td>#US862</td>
-                                <td>20 April, 2024</td>
-                                <td>
-                                    <img src="/images/users/avatar-4.jpg" alt="avatar-2"
-                                        class="img-fluid avatar-xs rounded-circle" />
-                                    <span class="align-middle ms-1">Jack Roldan</span>
-                                </td>
-                                <td>
-                                    <span class="badge badge-soft-warning">Pending</span>
-                                </td>
-                                <td>@griys</td>
-                            </tr>
-                            <tr>
-                                <td>#US756</td>
-                                <td>18 April, 2024</td>
-                                <td>
-                                    <img src="/images/users/avatar-5.jpg" alt="avatar-2"
-                                        class="img-fluid avatar-xs rounded-circle" />
-                                    <span class="align-middle ms-1">Betty Cox</span>
-                                </td>
-                                <td>
-                                    <span class="badge badge-soft-success">Verified</span>
-                                </td>
-                                <td>@reffon</td>
-                            </tr>
-                            <tr>
-                                <td>#US420</td>
-                                <td>18 April, 2024</td>
-                                <td>
-                                    <img src="/images/users/avatar-6.jpg" alt="avatar-2"
-                                        class="img-fluid avatar-xs rounded-circle" />
-                                    <span class="align-middle ms-1">Carlos
-                                        Johnson</span>
-                                </td>
-                                <td>
-                                    <span class="badge badge-soft-danger">Blocked</span>
-                                </td>
-                                <td>@bebo</td>
-                            </tr>
-                        </tbody>
-                    </table>
-                </div>
-            </div>
-            <!-- end card body -->
-        </div>
-        <!-- end card-->
-    </div>
-    <!-- end col -->
-
-    <div class="col-xl-6">
-        <div class="card">
-            <div class="card-header d-flex justify-content-between align-items-center">
-                <h4 class="card-title mb-0">
-                    Recent Transactions
-                </h4>
-
-                <a href="#!" class="btn btn-sm btn-light">
-                    View All
-                </a>
-            </div>
-            <!-- end card-header-->
-
-            <div class="card-body">
-                <div class="table-responsive">
-                    <table class="table table-hover mb-0 table-centered">
-                        <thead>
-                            <th class="py-1">ID</th>
-                            <th class="py-1">Date</th>
-                            <th class="py-1">Amount</th>
-                            <th class="py-1">Status</th>
-                            <th class="py-1">
-                                Description
-                            </th>
-                        </thead>
-                        <tbody>
-                            <tr>
-                                <td>#98521</td>
-                                <td>24 April, 2024</td>
-                                <td>$120.55</td>
-                                <td>
-                                    <span class="badge bg-success">Cr</span>
-                                </td>
-                                <td>Commisions</td>
-                            </tr>
-                            <tr>
-                                <td>#20158</td>
-                                <td>24 April, 2024</td>
-                                <td>$9.68</td>
-                                <td>
-                                    <span class="badge bg-success">Cr</span>
-                                </td>
-                                <td>Affiliates</td>
-                            </tr>
-                            <tr>
-                                <td>#36589</td>
-                                <td>20 April, 2024</td>
-                                <td>$105.22</td>
-                                <td>
-                                    <span class="badge bg-danger">Dr</span>
-                                </td>
-                                <td>Grocery</td>
-                            </tr>
-                            <tr>
-                                <td>#95362</td>
-                                <td>18 April, 2024</td>
-                                <td>$80.59</td>
-                                <td>
-                                    <span class="badge bg-success">Cr</span>
-                                </td>
-                                <td>Refunds</td>
-                            </tr>
-                            <tr>
-                                <td>#75214</td>
-                                <td>18 April, 2024</td>
-                                <td>$750.95</td>
-                                <td>
-                                    <span class="badge bg-danger">Dr</span>
-                                </td>
-                                <td>Bill Payments</td>
-                            </tr>
-                        </tbody>
-                    </table>
-                </div>
-            </div>
-            <!-- end card body -->
-        </div>
-        <!-- end card-->
-    </div>
-    <!-- end col -->
-</div>
-<!-- end row -->
 @endsection
 
 @section('scripts')

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

@@ -14,44 +14,52 @@
 
      <div class="scrollbar" data-simplebar>
           <ul class="navbar-nav" id="navbar-nav">
-               <li class="menu-title">Menu</li>
+          <li class="menu-title">Menu</li>
 
-               @php
-                    // Fungsi rekursif untuk menampilkan menu bertingkat dengan indentasi
-                    function renderMenu($menus, $depth = 0) {
-                         foreach ($menus as $menu) {
-                              $collapseId = "sidebar-" . $menu->id; // Unique ID untuk Bootstrap Collapse
-                              $hasChildren = $menu->children->count() > 0; // Cek apakah punya anak
-                              $marginLeft = $depth * 5; // Set jarak margin berdasarkan level
+          @php
+          function renderMenu($menus) {
+               foreach ($menus as $menu) {
+                    $collapseId = "sidebar-" . $menu->id;
+                    $hasChildren = $menu->children->count() > 0;
 
-                              echo '<li class="nav-item">';
-
-                              // Menu utama / anak (dengan dropdown jika punya anak)
-                              echo '<a class="nav-link ' . ($hasChildren ? 'menu-arrow' : '') . '" 
-                                   href="' . ($hasChildren ? "#$collapseId" : ($menu->url ? (Route::has($menu->url) ? route($menu->url, ['menu_id' => $menu->id]) : $menu->url . '?menu_id=' . $menu->id) : '#')) . '" 
-                                   ' . ($hasChildren ? 'data-bs-toggle="collapse" role="button" aria-expanded="false" aria-controls="' . $collapseId . '"' : '') . '>
-                                   <span class="nav-icon">
-                                        <iconify-icon icon="' . $menu->icon . '"></iconify-icon>
-                                   </span>
-                                   <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>';
+                    // Pastikan route tersedia dan boleh ditampilkan
+                    $menuUrl = '#';
+                    if ($menu->url) {
+                         if (Route::has($menu->url)) {
+                              $menuUrl = route($menu->url, ['menu_id' => $menu->id]);
+                         } else {
+                              $menuUrl = $menu->url . '?menu_id=' . $menu->id;
                          }
                     }
-               @endphp
 
-               @php 
-                    // Tampilkan hanya menu dengan parent_id NULL (menu utama)
-                    renderMenu($menus->where('parent_id', null)); 
-               @endphp
+                    echo '<li class="nav-item ' . ($hasChildren ? 'has-children' : '') . '">';
+                    echo '<a class="nav-link ' . ($hasChildren ? 'menu-arrow' : '') . '" 
+                              href="' . ($hasChildren ? "#$collapseId" : $menuUrl) . '" 
+                              ' . ($hasChildren ? 'data-bs-toggle="collapse" role="button" aria-expanded="false" aria-controls="' . $collapseId . '"' : '') . '>';
+                    
+                    // Tampilkan ikon hanya jika tersedia
+                    if (!empty($menu->icon)) {
+                         echo '<span class="nav-icon">
+                                   <iconify-icon icon="' . $menu->icon . '"></iconify-icon>
+                              </span>';
+                    }
+
+                    echo '<span class="nav-text">' . $menu->name . '</span>';
+                    echo '</a>';
+
+                    if ($hasChildren) {
+                         echo '<div class="collapse" id="' . $collapseId . '">
+                                   <ul class="nav sub-navbar-nav">';
+                         renderMenu($menu->children);
+                         echo '</ul></div>';
+                    }
+
+                    echo '</li>';
+               }
+          }
+          @endphp
+
+          @php renderMenu($menus); @endphp
           </ul>
      </div>
 </div>
@@ -61,4 +69,7 @@
      @for ($i = 0; $i < 20; $i++)
           <div class="shooting-star"></div>
      @endfor
+     @for ($i = 0; $i < 20; $i++)
+          <div class="shooting-star"></div>
+     @endfor
 </div>

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">
-                    <a href="{{ route('users.create') }}" class="btn btn-success btn-sm d-block d-sm-inline w-auto">
-                        Create
-                    </a>
+                    @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/create.blade.php

@@ -1,9 +1,5 @@
 @extends('layouts.vertical', ['subtitle' => 'Menu'])
 
-@section('css')
-@vite(['node_modules/gridjs/dist/theme/mermaid.min.css'])
-@endsection
-
 @section('content')
 
 @include('layouts.partials/page-title', ['title' => 'Settings', 'subtitle' => 'Menu'])

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">
-                    <a href="{{ route('menus.create')}}" class="btn btn-success btn-sm d-block d-sm-inline w-auto">Create</a>
+                    @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">
-          <a href="{{ route('pbg-task.create')}}" class="btn btn-success btn-sm d-block d-sm-inline w-auto">Create</a>
+          @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/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">
-                    <a href="{{ route('roles.create')}}" class="btn btn-success btn-sm d-block d-sm-inline w-auto">Create</a>
+                    @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">
-                    <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>
+                    @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

@@ -11,6 +11,7 @@ use App\Http\Controllers\Api\ImportDatasourceController;
 use App\Http\Controllers\Api\LackOfPotentialController;
 use App\Http\Controllers\Api\MenusController;
 use App\Http\Controllers\Api\PbgTaskController;
+use App\Http\Controllers\Api\PbgTaskGoogleSheetsController;
 use App\Http\Controllers\Api\RequestAssignmentController;
 use App\Http\Controllers\Api\RolesController;
 use App\Http\Controllers\Api\ScrapingController;
@@ -146,4 +147,7 @@ Route::group(['middleware' => 'auth:sanctum'], function (){
     Route::controller(TaskAssignmentsController::class)->group(function (){
         Route::get('/task-assignments/{uuid}', 'index')->name('api.task-assignments');
     });
+
+    // pbg-task-google-sheet
+    Route::apiResource('pbg-task-google-sheet', PbgTaskGoogleSheetsController::class);
 });

routes/web.php

@@ -8,6 +8,7 @@ use App\Http\Controllers\Dashboards\PotentialsController;
 use App\Http\Controllers\DataSettingController;
 use App\Http\Controllers\Dashboards\BigDataController;
 use App\Http\Controllers\GoogleApisController;
+use App\Http\Controllers\Home\HomeController;
 use App\Http\Controllers\Master\UsersController;
 use App\Http\Controllers\MenusController;
 use App\Http\Controllers\RequestAssignment\PbgTaskController;
@@ -18,6 +19,7 @@ use App\Http\Controllers\Data\AdvertisementController;
 use App\Http\Controllers\Data\UmkmController;
 use App\Http\Controllers\Data\TourismController;
 use App\Http\Controllers\Data\SpatialPlanningController;
+use App\Http\Controllers\Data\GoogleSheetsController;
 use App\Http\Controllers\Report\ReportTourismController;
 use App\Http\Controllers\Chatbot\ChatbotController;
 use App\Http\Controllers\ChatbotPimpinan\ChatbotPimpinanController;
@@ -29,6 +31,7 @@ require __DIR__ . '/auth.php';
 Route::group(['middleware' => 'auth'], function(){
 
     Route::get('', [BigDataController::class, 'index'])->name('any');
+    Route::get('/home', [HomeController::class, 'index']);
 
     //dashboards
     Route::group(['prefix' => '/dashboards'], function(){
@@ -112,6 +115,13 @@ Route::group(['middleware' => 'auth'], function(){
             Route::get('/customers/{customer_id}/edit', 'edit')->name('customers.edit');
             Route::get('/customers/upload', 'upload')->name('customers.upload');
         });
+
+        Route::controller(GoogleSheetsController::class)->group(function (){
+            Route::get('/google-sheets', 'index')->name('google-sheets');
+            Route::get('/google-sheets/create', 'create')->name('google-sheets.create');
+            Route::get('/google-sheets/{google_sheet_id}', 'show')->name('google-sheets.show');
+            Route::get('/google-sheets/{google_sheet_id}/edit', 'edit')->name('google-sheets.edit');
+        });
     });
 
     // Report

vite.config.js

@@ -18,6 +18,8 @@ export default defineConfig({
                 "resources/scss/dashboards/_bigdata.scss",
                 "resources/scss/dashboards/_lack-of-potential.scss",
                 "resources/scss/components/_custom_circle.scss",
+                "resources/scss/dashboards/potentials/_inside_system.scss",
+                "resources/scss/dashboards/potentials/_outside_system.scss",
 
                 "node_modules/quill/dist/quill.snow.css",
                 "node_modules/quill/dist/quill.bubble.css",
@@ -104,6 +106,8 @@ export default defineConfig({
                 //pbg-task
                 "resources/js/pbg-task/index.js",
                 "resources/js/pbg-task/show.js",
+                // google-sheets
+                "resources/js/data/google-sheet/index.js",
             ],
             refresh: true,
         }),