권혁성
189b38c936
- Auditable 트레이트 신규 생성 (bootAuditable 패턴) - creating: created_by/updated_by 자동 채우기 - updating: updated_by 자동 채우기 - deleting: deleted_by 채우기 + saveQuietly() - created/updated/deleted: audit_logs 자동 기록 - 기존 AuditLogger 패턴과 동일한 try/catch 조용한 실패 - 변경된 필드만 before/after 기록 (updated 이벤트) - auditExclude 프로퍼티로 모델별 제외 필드 설정 가능 - 제외 대상: Attendance, StockTransaction, TodayIssue 등 고빈도/시스템 모델 Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
101 lines
2.3 KiB
PHP
101 lines
2.3 KiB
PHP
<?php
|
|
|
|
namespace App\Models\Orders;
|
|
|
|
use App\Models\BadDebts\BadDebt;
|
|
use App\Traits\Auditable;
|
|
use App\Traits\BelongsToTenant;
|
|
use App\Traits\ModelTrait;
|
|
use Illuminate\Database\Eloquent\Model;
|
|
use Illuminate\Database\Eloquent\Relations\HasMany;
|
|
|
|
class Client extends Model
|
|
{
|
|
use Auditable, BelongsToTenant, ModelTrait;
|
|
|
|
protected $fillable = [
|
|
'tenant_id',
|
|
'client_group_id',
|
|
'client_code',
|
|
'name',
|
|
'contact_person',
|
|
'phone',
|
|
'mobile',
|
|
'fax',
|
|
'email',
|
|
'address',
|
|
'account_id',
|
|
'account_password',
|
|
'purchase_payment_day',
|
|
'sales_payment_day',
|
|
'business_no',
|
|
'business_type',
|
|
'business_item',
|
|
'tax_agreement',
|
|
'tax_amount',
|
|
'tax_start_date',
|
|
'tax_end_date',
|
|
'memo',
|
|
'outstanding_balance',
|
|
'credit_limit',
|
|
'is_active',
|
|
'is_overdue',
|
|
'client_type',
|
|
'manager_name',
|
|
'manager_tel',
|
|
'system_manager',
|
|
];
|
|
|
|
protected $casts = [
|
|
'is_active' => 'boolean',
|
|
'is_overdue' => 'boolean',
|
|
'tax_agreement' => 'boolean',
|
|
'tax_amount' => 'decimal:2',
|
|
'outstanding_balance' => 'decimal:2',
|
|
'credit_limit' => 'decimal:2',
|
|
'tax_start_date' => 'date',
|
|
'tax_end_date' => 'date',
|
|
];
|
|
|
|
protected $hidden = [
|
|
'account_password',
|
|
];
|
|
|
|
// ClientGroup 관계
|
|
public function clientGroup()
|
|
{
|
|
return $this->belongsTo(ClientGroup::class, 'client_group_id');
|
|
}
|
|
|
|
// Orders 관계
|
|
public function orders()
|
|
{
|
|
return $this->hasMany(Order::class, 'client_id');
|
|
}
|
|
|
|
// 악성채권 관계
|
|
public function badDebts(): HasMany
|
|
{
|
|
return $this->hasMany(BadDebt::class);
|
|
}
|
|
|
|
// 활성 악성채권 관계 (추심중, 법적조치)
|
|
public function activeBadDebts(): HasMany
|
|
{
|
|
return $this->hasMany(BadDebt::class)
|
|
->whereIn('status', [BadDebt::STATUS_COLLECTING, BadDebt::STATUS_LEGAL_ACTION])
|
|
->where('is_active', true);
|
|
}
|
|
|
|
// 스코프
|
|
public function scopeActive($query)
|
|
{
|
|
return $query->where('is_active', true);
|
|
}
|
|
|
|
public function scopeCode($query, string $code)
|
|
{
|
|
return $query->where('client_code', $code);
|
|
}
|
|
}
|