Illuminate without laravel Error Use DB Fatal error: Uncaught exception 'RuntimeException' with message 'A facade root has not been set

 

use Illuminate\Database\Capsule\Manager as DB;

Filament Disable Button Create Edit Delete

   

    public static function canCreate(): bool

    {

        return false;

    }

   

    public static function canEdit(Model $record): bool

    {

        return false;

    }

   

    public static function canDelete(Model $record): bool

    {

        return false;

    }

   

    public static function canDeleteAny(): bool

    {

        return false;

    }

 

select field first_name and last name show data concat field

 

Select::make('people_id')             

  ->searchable()

  ->getSearchResultsUsing(fn (string $search): array =>

    Peoples::select(DB::raw('CONCAT(first_name ," ", last_name) AS name'), 'id')

   ->where('first_name', 'like', "%{$search}%")->limit(50)->pluck('name', 'id')

->toArray())

  ->getOptionLabelUsing(fn ($value): ?string => Peoples::find($value)->FullName ),

Group Action View Edit Delete Table with :::

 

       

        ->actions([

        Tables\Actions\ActionGroup::make([

                    Tables\Actions\ViewAction::make(),    

                    Tables\Actions\EditAction::make(),

                    Tables\Actions\DeleteBulkAction::make(),

                ])

            ])

Filament error duplicate on edit record

 using ignoreRecord: true

    TextInput::make('name')->required()->unique(ignoreRecord: true)->label('ชื่อห้อง'),

   

collapse navigation bar left filament

class AdminPanelProvider extends PanelProvider

{

    public function panel(Panel $panel): Panel

    {

        return $panel

            ->default()

            ->id('admin')

            ->path('admin')

            ->login()

            ->colors([

                'primary' => Color::Amber,

            ])

          ->sidebarCollapsibleOnDesktop() 

         

เพิ่ม Dropdown Navigation Dashboard Filament

 

protected static ?string $navigationGroup = 'ข้อมูลหลัก';   

protected static ?string $modelLabel = 'ข้อมูลจังหวัด ';

   

    protected static ?int $navigationSort = 3;

Filament fix unique() for editing

 

public static function form(Form $form): Form

    {     

  return $form

            ->schema([

                Card::make()

                ->schema([

     TextInput::make('room_no')->required()->unique(ignoreRecord: true)->label('รหัส'),

    TextInput::make('name')->required()->unique(ignoreRecord: true)->label('ชื่อห้อง'),

      TextInput::make('electric_no')->label('เลขมาตรไฟฟ้า'),

      TextInput::make('water_no')->label('เลขมาตรน้ำ'),

      TextInput::make('electric_unit')->label('หน่วยไฟฟ้าล่าสุด'),

      TextInput::make('water_unit')->label('หน่วยน้ำประปาล่าสุด'),

      TextInput::make('price')->numeric()->label('ราคาห้อง'),

      TextInput::make('price_tax')->numeric()->label('ราคาห้อง ส่งภาษี'),

                        ])->columns(2),

                   

            ]);

    }