Files
Vasyka a2026f640a Stage 6 — Purchase System: partial receipt + supplier analytics
Schema:
- purchase_items.qty_received (backfilled from `received` boolean)
- purchases.warehouse_id (target warehouse FK)
- supplier_part_prices (price history per supplier/part with purchase ref)
- New status `partial` between ordered and received

Purchase ↔ Warehouse integration:
- Purchase::receiveItem(item, qty, warehouse?) — routes through
  WarehouseService::receive: creates batch + receipt event + supplier price row
- Purchase::receiveAllRemaining(warehouse?) — receives all outstanding lines
- Purchase::recomputeStatus() — auto: ordered → partial → received

Old flat markReceived() removed — every receipt now writes batches + ledger.

Filament:
- Purchase list: progress %, partial badge, warehouse picker on form
- ItemsRelationManager: per-line "Recepționează" with qty + warehouse modal,
  qty_received shown as "X.XX / Y.YY" with colour
- PartResource: new PriceHistoryRelationManager (supplier price history)
- SupplierResource: derived columns onTimeRate / avgDeliveryDays / spend(90d)
  + "Rerating" action

Analytics:
- App\Services\Warehouse\SupplierAnalytics (onTimeRate, avgDeliveryDays,
  spend, count, computedRating)
- `suppliers:rate` artisan command + weekly schedule (Mon 04:00)
- Computed rating: 70% on-time + 20% volume + 10% speed bonus

Tests (6 new, all pass):
- Partial receipt of 3/10 → status=partial + 1 batch + 1 price row
- receiveAllRemaining → status=received with received_at set
- Over-receive throws InvalidArgumentException
- Two partial receipts (4+6) → 2 batches FIFO + status=received
- onTimeRate 50% with 1 on-time + 1 late
- computedRating null when <2 deliveries

Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>
2026-05-27 19:37:12 +00:00

136 lines
6.4 KiB
PHP

<?php
namespace App\Filament\Tenant\Resources;
use App\Filament\Tenant\Resources\SupplierResource\Pages;
use App\Models\Tenant\Supplier;
use Filament\Actions;
use Filament\Forms;
use Filament\Resources\Resource;
use Filament\Schemas;
use Filament\Schemas\Schema;
use Filament\Tables;
use Filament\Tables\Table;
class SupplierResource extends Resource
{
protected static ?string $model = Supplier::class;
protected static string|\BackedEnum|null $navigationIcon = 'heroicon-o-building-storefront';
protected static ?string $navigationLabel = 'Furnizori';
protected static string|\UnitEnum|null $navigationGroup = 'Depozit';
protected static ?string $modelLabel = 'furnizor';
protected static ?string $pluralModelLabel = 'furnizori';
protected static ?int $navigationSort = 42;
public static function form(Schema $schema): Schema
{
return $schema->components([
Schemas\Components\Section::make('Identificare')
->columns(2)
->schema([
Forms\Components\TextInput::make('name')->label('Nume')->required()->maxLength(160),
Forms\Components\TextInput::make('contact_name')->label('Persoană contact')->maxLength(120),
Forms\Components\TextInput::make('phone')->tel()->maxLength(40),
Forms\Components\TextInput::make('email')->email()->maxLength(120),
Forms\Components\TextInput::make('website')->url()->maxLength(160),
]),
Schemas\Components\Section::make('Comercial')
->columns(3)
->schema([
Forms\Components\TextInput::make('pay_terms')->label('Termeni plată')->placeholder('Net 30 / Avans')->maxLength(60),
Forms\Components\TextInput::make('delivery_days')->label('Zile livrare')->numeric()->default(0),
Forms\Components\Select::make('rating')
->label('Rating')
->options([1 => '★', 2 => '★★', 3 => '★★★', 4 => '★★★★', 5 => '★★★★★'])
->default(3)
->required(),
Forms\Components\TextInput::make('discount_pct')->label('Discount %')->numeric()->default(0),
Forms\Components\TagsInput::make('categories')->label('Categorii')->placeholder('Frâne, Ulei, ...')->columnSpan(2),
Forms\Components\Toggle::make('is_active')->label('Activ')->default(true),
]),
Forms\Components\Textarea::make('notes')->label('Observații')->columnSpanFull()->rows(2),
]);
}
public static function table(Table $table): Table
{
return $table
->columns([
Tables\Columns\TextColumn::make('name')->searchable()->sortable(),
Tables\Columns\TextColumn::make('contact_name')->label('Contact')->placeholder('—'),
Tables\Columns\TextColumn::make('phone')->copyable()->placeholder('—'),
Tables\Columns\TextColumn::make('rating')
->label('Rating')
->formatStateUsing(fn ($s) => str_repeat('★', (int) $s)),
Tables\Columns\TextColumn::make('on_time_pct')
->label('La timp 90d')
->state(fn (Supplier $r) => app(\App\Services\Warehouse\SupplierAnalytics::class)->onTimeRate($r))
->formatStateUsing(fn ($s) => $s === null ? '—' : "{$s}%")
->color(fn ($s) => $s === null ? 'gray' : ($s >= 90 ? 'success' : ($s >= 70 ? 'warning' : 'danger')))
->alignRight()
->toggleable(),
Tables\Columns\TextColumn::make('avg_delivery_days')
->label('Avg zile')
->state(fn (Supplier $r) => app(\App\Services\Warehouse\SupplierAnalytics::class)->avgDeliveryDays($r))
->formatStateUsing(fn ($s) => $s === null ? '—' : (string) $s)
->alignRight()
->toggleable(),
Tables\Columns\TextColumn::make('spend_90d')
->label('Cheltuit 90d')
->state(fn (Supplier $r) => app(\App\Services\Warehouse\SupplierAnalytics::class)->spend($r))
->money('MDL')
->alignRight()
->toggleable(),
Tables\Columns\TextColumn::make('delivery_days')->label('Livrare (zile)')->alignRight()->toggleable(),
Tables\Columns\TextColumn::make('discount_pct')->label('Discount')
->formatStateUsing(fn ($s) => $s . '%')->alignRight()->toggleable(),
Tables\Columns\IconColumn::make('is_active')->boolean(),
])
->filters([
Tables\Filters\TernaryFilter::make('is_active')->label('Activi'),
])
->actions([
Actions\Action::make('rate')
->label('Rerating')
->icon('heroicon-m-arrow-path')
->color('gray')
->action(function (Supplier $r) {
$score = app(\App\Services\Warehouse\SupplierAnalytics::class)
->computedRating($r);
if ($score === null) {
\Filament\Notifications\Notification::make()
->title('Date insuficiente')
->body('Necesită cel puțin 2 recepții complete cu data așteptată setată.')
->warning()
->send();
return;
}
$r->rating = $score;
$r->saveQuietly();
\Filament\Notifications\Notification::make()
->title("Rating actualizat → {$score}")
->success()
->send();
}),
Actions\EditAction::make(),
Actions\DeleteAction::make(),
])
->defaultSort('name');
}
public static function getPages(): array
{
return [
'index' => Pages\ListSuppliers::route('/'),
'create' => Pages\CreateSupplier::route('/create'),
'edit' => Pages\EditSupplier::route('/{record}/edit'),
];
}
}