권혁성
595e3d59b4
- 차원 테이블: dim_client, dim_product 마이그레이션 + SCD Type 2 동기화 (DimensionSyncService) - 재고 통계: stat_inventory_daily + InventoryStatService (stocks, stock_transactions, inspections) - 견적/영업 통계: stat_quote_pipeline_daily + QuoteStatService (quotes, biddings, sales_prospects) - 인사/근태 통계: stat_hr_attendance_daily + HrStatService (attendances, leaves, user_tenants) - KPI/알림: stat_kpi_targets, stat_alerts + KpiAlertService + StatCheckKpiAlertsCommand - StatAggregatorService에 inventory, quote, hr 도메인 추가 (총 6개 도메인) - 스케줄러: stat:check-kpi-alerts 매일 09:00 등록 Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
23 lines
568 B
PHP
23 lines
568 B
PHP
<?php
|
|
|
|
namespace App\Models\Stats\Daily;
|
|
|
|
use App\Models\Stats\BaseStatModel;
|
|
|
|
class StatInventoryDaily extends BaseStatModel
|
|
{
|
|
protected $table = 'stat_inventory_daily';
|
|
|
|
protected $casts = [
|
|
'stat_date' => 'date',
|
|
'total_stock_qty' => 'decimal:2',
|
|
'total_stock_value' => 'decimal:2',
|
|
'receipt_qty' => 'decimal:2',
|
|
'receipt_amount' => 'decimal:2',
|
|
'issue_qty' => 'decimal:2',
|
|
'issue_amount' => 'decimal:2',
|
|
'inspection_pass_rate' => 'decimal:2',
|
|
'turnover_rate' => 'decimal:2',
|
|
];
|
|
}
|