권혁성
1df34b2fa9
- Bill 확장 필드 (V8), Loan 상품권 카테고리/접대비 자동 연동 - GeneralJournalEntry CRUD, AccountSubject API - 접대비/복리후생비 날짜 필터, 매출채권 soft delete 제외 - 바로빌 연동 API 엔드포인트 추가 - 부가세 상세 조회 API Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
322 lines
8.5 KiB
PHP
322 lines
8.5 KiB
PHP
<?php
|
|
|
|
namespace App\Models\Tenants;
|
|
|
|
use App\Traits\Auditable;
|
|
use App\Traits\BelongsToTenant;
|
|
use Illuminate\Database\Eloquent\Model;
|
|
use Illuminate\Database\Eloquent\Relations\BelongsTo;
|
|
use Illuminate\Database\Eloquent\Relations\HasMany;
|
|
use Illuminate\Database\Eloquent\SoftDeletes;
|
|
|
|
class Bill extends Model
|
|
{
|
|
use Auditable, BelongsToTenant, SoftDeletes;
|
|
|
|
protected $fillable = [
|
|
'tenant_id',
|
|
'bill_number',
|
|
'bill_type',
|
|
'client_id',
|
|
'client_name',
|
|
'amount',
|
|
'issue_date',
|
|
'maturity_date',
|
|
'status',
|
|
'reason',
|
|
'installment_count',
|
|
'note',
|
|
'is_electronic',
|
|
'bank_account_id',
|
|
'created_by',
|
|
'updated_by',
|
|
'deleted_by',
|
|
// V8 확장 필드
|
|
'instrument_type',
|
|
'medium',
|
|
'bill_category',
|
|
'electronic_bill_no',
|
|
'registration_org',
|
|
'drawee',
|
|
'acceptance_status',
|
|
'acceptance_date',
|
|
'acceptance_refusal_date',
|
|
'acceptance_refusal_reason',
|
|
'endorsement',
|
|
'endorsement_order',
|
|
'storage_place',
|
|
'issuer_bank',
|
|
'is_discounted',
|
|
'discount_date',
|
|
'discount_bank',
|
|
'discount_rate',
|
|
'discount_amount',
|
|
'endorsement_date',
|
|
'endorsee',
|
|
'endorsement_reason',
|
|
'collection_bank',
|
|
'collection_request_date',
|
|
'collection_fee',
|
|
'collection_complete_date',
|
|
'collection_result',
|
|
'collection_deposit_date',
|
|
'collection_deposit_amount',
|
|
'settlement_bank',
|
|
'payment_method',
|
|
'actual_payment_date',
|
|
'payment_place',
|
|
'payment_place_detail',
|
|
'renewal_date',
|
|
'renewal_new_bill_no',
|
|
'renewal_reason',
|
|
'recourse_date',
|
|
'recourse_amount',
|
|
'recourse_target',
|
|
'recourse_reason',
|
|
'buyback_date',
|
|
'buyback_amount',
|
|
'buyback_bank',
|
|
'dishonored_date',
|
|
'dishonored_reason',
|
|
'has_protest',
|
|
'protest_date',
|
|
'recourse_notice_date',
|
|
'recourse_notice_deadline',
|
|
'is_split',
|
|
];
|
|
|
|
protected $casts = [
|
|
'issue_date' => 'date',
|
|
'maturity_date' => 'date',
|
|
'amount' => 'decimal:2',
|
|
'client_id' => 'integer',
|
|
'bank_account_id' => 'integer',
|
|
'installment_count' => 'integer',
|
|
'is_electronic' => 'boolean',
|
|
// V8 확장 casts
|
|
'acceptance_date' => 'date',
|
|
'acceptance_refusal_date' => 'date',
|
|
'discount_date' => 'date',
|
|
'discount_rate' => 'decimal:2',
|
|
'discount_amount' => 'decimal:2',
|
|
'endorsement_date' => 'date',
|
|
'collection_request_date' => 'date',
|
|
'collection_fee' => 'decimal:2',
|
|
'collection_complete_date' => 'date',
|
|
'collection_deposit_date' => 'date',
|
|
'collection_deposit_amount' => 'decimal:2',
|
|
'actual_payment_date' => 'date',
|
|
'renewal_date' => 'date',
|
|
'recourse_date' => 'date',
|
|
'recourse_amount' => 'decimal:2',
|
|
'buyback_date' => 'date',
|
|
'buyback_amount' => 'decimal:2',
|
|
'dishonored_date' => 'date',
|
|
'protest_date' => 'date',
|
|
'recourse_notice_date' => 'date',
|
|
'recourse_notice_deadline' => 'date',
|
|
'is_discounted' => 'boolean',
|
|
'has_protest' => 'boolean',
|
|
'is_split' => 'boolean',
|
|
];
|
|
|
|
/**
|
|
* 배열/JSON 변환 시 날짜 형식 지정
|
|
*/
|
|
/**
|
|
* 날짜 cast 필드 목록 (toArray에서 Y-m-d 형식 변환용)
|
|
*/
|
|
private const DATE_FIELDS = [
|
|
'issue_date', 'maturity_date',
|
|
'acceptance_date', 'acceptance_refusal_date',
|
|
'discount_date', 'endorsement_date',
|
|
'collection_request_date', 'collection_complete_date', 'collection_deposit_date',
|
|
'actual_payment_date',
|
|
'renewal_date', 'recourse_date', 'buyback_date',
|
|
'dishonored_date', 'protest_date', 'recourse_notice_date', 'recourse_notice_deadline',
|
|
];
|
|
|
|
public function toArray(): array
|
|
{
|
|
$array = parent::toArray();
|
|
|
|
foreach (self::DATE_FIELDS as $field) {
|
|
if (isset($array[$field]) && $this->{$field}) {
|
|
$array[$field] = $this->{$field}->format('Y-m-d');
|
|
}
|
|
}
|
|
|
|
return $array;
|
|
}
|
|
|
|
/**
|
|
* 어음 구분 목록
|
|
*/
|
|
public const BILL_TYPES = [
|
|
'received' => '수취',
|
|
'issued' => '발행',
|
|
];
|
|
|
|
/**
|
|
* 증권종류
|
|
*/
|
|
public const INSTRUMENT_TYPES = [
|
|
'promissory' => '약속어음',
|
|
'exchange' => '환어음',
|
|
'cashierCheck' => '자기앞수표',
|
|
'currentCheck' => '당좌수표',
|
|
];
|
|
|
|
/**
|
|
* 수취 어음 상태 목록
|
|
*/
|
|
public const RECEIVED_STATUSES = [
|
|
'stored' => '보관중',
|
|
'endorsed' => '배서양도',
|
|
'discounted' => '할인',
|
|
'collectionRequest' => '추심의뢰',
|
|
'collectionComplete' => '추심완료',
|
|
'maturityDeposit' => '만기입금',
|
|
'paymentComplete' => '결제완료',
|
|
'dishonored' => '부도',
|
|
'renewed' => '개서',
|
|
'buyback' => '환매',
|
|
// 하위호환
|
|
'maturityAlert' => '만기입금(7일전)',
|
|
'maturityResult' => '만기결과',
|
|
];
|
|
|
|
/**
|
|
* 수취 수표 상태 목록
|
|
*/
|
|
public const RECEIVED_CHECK_STATUSES = [
|
|
'stored' => '보관중',
|
|
'endorsed' => '배서양도',
|
|
'deposited' => '입금',
|
|
'dishonored' => '부도',
|
|
];
|
|
|
|
/**
|
|
* 발행 어음 상태 목록
|
|
*/
|
|
public const ISSUED_STATUSES = [
|
|
'stored' => '보관중',
|
|
'issued' => '지급대기',
|
|
'maturityPayment' => '만기결제',
|
|
'paymentComplete' => '결제완료',
|
|
'dishonored' => '부도',
|
|
'renewed' => '개서',
|
|
// 하위호환
|
|
'maturityAlert' => '만기입금(7일전)',
|
|
'collectionRequest' => '추심의뢰',
|
|
'collectionComplete' => '추심완료',
|
|
'suing' => '추소중',
|
|
];
|
|
|
|
/**
|
|
* 발행 수표 상태 목록
|
|
*/
|
|
public const ISSUED_CHECK_STATUSES = [
|
|
'stored' => '보관중',
|
|
'issued' => '지급대기',
|
|
'cashed' => '현금화',
|
|
'dishonored' => '부도',
|
|
];
|
|
|
|
/**
|
|
* 거래처 관계
|
|
*/
|
|
public function client(): BelongsTo
|
|
{
|
|
return $this->belongsTo(\App\Models\Orders\Client::class);
|
|
}
|
|
|
|
/**
|
|
* 입금/출금 계좌 관계
|
|
*/
|
|
public function bankAccount(): BelongsTo
|
|
{
|
|
return $this->belongsTo(BankAccount::class);
|
|
}
|
|
|
|
/**
|
|
* 차수 관계
|
|
*/
|
|
public function installments(): HasMany
|
|
{
|
|
return $this->hasMany(BillInstallment::class);
|
|
}
|
|
|
|
/**
|
|
* 생성자 관계
|
|
*/
|
|
public function creator(): BelongsTo
|
|
{
|
|
return $this->belongsTo(\App\Models\Members\User::class, 'created_by');
|
|
}
|
|
|
|
/**
|
|
* 거래처명 조회 (회원/비회원 통합)
|
|
*/
|
|
public function getDisplayClientNameAttribute(): string
|
|
{
|
|
if ($this->client) {
|
|
return $this->client->name;
|
|
}
|
|
|
|
return $this->client_name ?? '';
|
|
}
|
|
|
|
/**
|
|
* 어음 구분 라벨
|
|
*/
|
|
public function getBillTypeLabelAttribute(): string
|
|
{
|
|
return self::BILL_TYPES[$this->bill_type] ?? $this->bill_type;
|
|
}
|
|
|
|
/**
|
|
* 상태 라벨
|
|
*/
|
|
public function getStatusLabelAttribute(): string
|
|
{
|
|
$isCheck = in_array($this->instrument_type, ['cashierCheck', 'currentCheck']);
|
|
|
|
if ($this->bill_type === 'received') {
|
|
$statuses = $isCheck ? self::RECEIVED_CHECK_STATUSES : self::RECEIVED_STATUSES;
|
|
|
|
return $statuses[$this->status] ?? self::RECEIVED_STATUSES[$this->status] ?? $this->status;
|
|
}
|
|
|
|
$statuses = $isCheck ? self::ISSUED_CHECK_STATUSES : self::ISSUED_STATUSES;
|
|
|
|
return $statuses[$this->status] ?? self::ISSUED_STATUSES[$this->status] ?? $this->status;
|
|
}
|
|
|
|
/**
|
|
* 증권종류 라벨
|
|
*/
|
|
public function getInstrumentTypeLabelAttribute(): string
|
|
{
|
|
return self::INSTRUMENT_TYPES[$this->instrument_type] ?? $this->instrument_type ?? '약속어음';
|
|
}
|
|
|
|
/**
|
|
* 만기까지 남은 일수
|
|
*/
|
|
public function getDaysToMaturityAttribute(): int
|
|
{
|
|
return now()->diffInDays($this->maturity_date, false);
|
|
}
|
|
|
|
/**
|
|
* 만기 7일 전 여부
|
|
*/
|
|
public function isMaturityAlertPeriod(): bool
|
|
{
|
|
$days = $this->days_to_maturity;
|
|
|
|
return $days >= 0 && $days <= 7;
|
|
}
|
|
}
|