HEX
Server: Apache
System: Linux server2.voipitup.com.au 4.18.0-553.109.1.lve.el8.x86_64 #1 SMP Thu Mar 5 20:23:46 UTC 2026 x86_64
User: posscale (1027)
PHP: 8.2.30
Disabled: exec,passthru,shell_exec,system
Upload Files
File: //home/posscale/public_html/printmanager/app/Filament/Resources/OrderResource.php
<?php

namespace App\Filament\Resources;

use App\Filament\Resources\OrderResource\Pages;
use App\Filament\Resources\OrderResource\RelationManagers;
use App\Models\Order;
use Filament\Forms;
use App\Enums\OrderStatusEnum;
use App\Models\Supplier;
use App\Models\Tenant;
use App\Models\TonerLevelMonitoring;
use Filament\Forms\Components\DateTimePicker;
use Filament\Forms\Components\Select;
use Filament\Forms\Components\TextInput;
use Filament\Forms\Components\Toggle;
use Filament\Forms\Form;
use Filament\Resources\Resource;
use Filament\Tables;
use Filament\Tables\Columns\IconColumn;
use Filament\Tables\Columns\TextColumn;
use Filament\Tables\Filters\SelectFilter;
use Filament\Tables\Table;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\SoftDeletingScope;

class OrderResource extends Resource
{
    protected static ?string $model = Order::class;

    protected static ?string $navigationIcon = 'heroicon-o-shopping-cart';
    protected static ?string $navigationGroup = "Printer Parts";
    protected static ?int $navigationSort = 9;


    public static function form(Form $form): Form
    {
        return $form
            ->schema([
                Select::make('printer_instance_id')
                    ->label('Printer Instance')
                    ->required()
                    ->live()
                    ->searchable()
                    ->options(function () {
                        return TonerLevelMonitoring::get()
                            ->groupBy('tenant_id') 
                            ->mapWithKeys(function ($group, $tenantId) {                                
                                $tenantName = $tenantId
                                    ? \App\Models\Tenant::find($tenantId)->name ?? "Tenant #$tenantId"
                                    : 'Unknown Tenant';                                
                                $options = $group->mapWithKeys(fn ($record) => [
                                    $record->printer_instance_id => $record->printer_name_tenant,
                                ])->toArray();
                                return [$tenantName => $options];
                            })
                            ->toArray();
                    }),
                Select::make('supplier_id')
                    ->label('Supplier ID')
                    ->options(Supplier::all()->pluck('name', 'id'))
                    ->searchable()->required(true),
                TextInput::make('quantity')
                    ->required()
                    ->numeric()
                    ->default(1),
                TextInput::make('total_price')
                    ->numeric(),
                DateTimePicker::make('order_date'),
                Select::make('status')
                    ->label('Status')
                     ->native(false)
                    ->options(OrderStatusEnum::options()) ->required(true), 
                Toggle::make('auto_ordered')
                    ->required(),
                
            ]);
    }

    public static function table(Table $table): Table
    {
        return $table
            ->columns([
                TextColumn::make('tenant_id')
                    ->label('Customer name')
                    ->searchable()
                    ->toggleable(isToggledHiddenByDefault: true),
                TextColumn::make('printer_name_tenant')
                ->label('Printer Name'),                
                TextColumn::make('tonerink.part_no')
                    ->label('Toner ink')
                    ->numeric()
                    ->sortable()
                    ->toggleable(isToggledHiddenByDefault: true),
                TextColumn::make('supplier.name')
                    ->numeric()
                    ->sortable()
                    ->toggleable(isToggledHiddenByDefault: true),
                TextColumn::make('quantity')
                    ->numeric()
                    ->sortable()
                    ->toggleable(isToggledHiddenByDefault: true),
                TextColumn::make('total_price')
                    ->numeric()
                    ->sortable()
                    ->toggleable(isToggledHiddenByDefault: true),
                TextColumn::make('order_date')
                    ->dateTime()
                    ->sortable()
                    ->toggleable(isToggledHiddenByDefault: true),
                    TextColumn::make('user.name')
                        ->numeric()
                        ->sortable()
                        ->toggleable(isToggledHiddenByDefault: true),                
                TextColumn::make('status'),
                IconColumn::make('auto_ordered')
                    ->boolean(),
            ])
            ->filters([
                SelectFilter::make('tenant_id')
                ->label('Filter by Customer name')
                ->options(Tenant::all()->pluck('id', 'id'))
                ->default(null),
            ])
            ->actions([
                Tables\Actions\EditAction::make(),
            ])
            ->bulkActions([
                Tables\Actions\BulkActionGroup::make([
                    Tables\Actions\DeleteBulkAction::make(),
                ]),
            ]);
    }

    public static function getRelations(): array
    {
        return [
            //
        ];
    }

    public static function getPages(): array
    {
        return [
            'index' => Pages\ListOrders::route('/'),
            'create' => Pages\CreateOrder::route('/create'),
            'edit' => Pages\EditOrder::route('/{record}/edit'),
        ];
    }
}