README

Description

The Moonshine Database Manager package is a powerful extension for the Moonshine Admin Panel that facilitates seamless database management directly from the admin interface. This Laravel package enhances the functionality of the Moonshine Admin Panel by allowing administrators to effortlessly interact with the underlying database without the need for complex SQL queries or external tools.

Features

Intuitive Interface: The package integrates seamlessly with the Moonshine Admin Panel, providing a user-friendly interface to manage databases. Administrators can perform CRUD (Create, Read, Update, Delete) operations on database records effortlessly.
User Permissions: Control access to the database manager with robust user permission settings. Define which administrators can view, edit, or delete database records and tables.
Easy Installation: The package is easy to install and configure.

Installation

Install the package via composer:

composer require sweet1s/moonshine-database

Publish the configuration file:

php artisan vendor:publish --provider="Sweet1s\MoonShineDatabase\Providers\MoonShineDatabaseServiceProvider"

Add the item to your MoonShineServiceProvider file, like this:

public function boot(): void
    {
        app(MoonShine::class)->menu([
            ...
            \Sweet1s\MoonShineDatabase\Menu\DatabaseItem::make(),
            ...
        ]);
    }

Authentication

To utilize authentication, Moonshine Database relies on the Laravel Gate system. To enable this functionality, you need to add the following code to your AuthServiceProvider and implement your own authorization logic. First, you should set the auth parameter to true in the moonshine-database.php configuration file. Here's an example code snippet:

In your config/moonshine-database.php file

...
'auth' => [
    'enable' => true
],
...

In your app/Providers/AuthServiceProvider.php file

<?php

namespace App\Providers;

use Illuminate\Foundation\Support\Providers\AuthServiceProvider as ServiceProvider;use Illuminate\Support\Facades\Gate;

class AuthServiceProvider extends ServiceProvider
{
    /**
     * Register any authentication / authorization services.
     *
     * @return void
     */
    public function boot()
    {
        ...
        foreach (config('moonshine-database.auth.permissions') as $key => $value) {
            Gate::define($value, function ($user) use ($value) {
                // Here you can implement your own authorization logic

                // I use spatie/laravel-permission package, so I can do like this:
                return $user->role->hasPermissionTo($value);
            });
        }
    }
}