122 lines
3.1 KiB
PHP
122 lines
3.1 KiB
PHP
<?php
|
|
|
|
namespace App\Models;
|
|
|
|
use App\Traits\BelongsToCompany;
|
|
use App\Traits\HasAuditTrail;
|
|
use Illuminate\Database\Eloquent\Model;
|
|
use Illuminate\Database\Eloquent\Relations\HasMany;
|
|
use Illuminate\Database\Eloquent\Relations\BelongsTo;
|
|
|
|
class PurchaseInvoice extends Model
|
|
{
|
|
use BelongsToCompany, HasAuditTrail;
|
|
|
|
protected $fillable = [
|
|
'invoice_number',
|
|
'invoice_date',
|
|
'due_date',
|
|
'vendor_id',
|
|
'warehouse_id',
|
|
'subtotal',
|
|
'tax_amount',
|
|
'discount_amount',
|
|
'total_amount',
|
|
'paid_amount',
|
|
'debit_note_applied',
|
|
'balance_amount',
|
|
'status',
|
|
'payment_terms',
|
|
'notes',
|
|
'creator_id',
|
|
'created_by'
|
|
];
|
|
|
|
protected $casts = [
|
|
'invoice_date' => 'date',
|
|
'due_date' => 'date',
|
|
'subtotal' => 'decimal:2',
|
|
'tax_amount' => 'decimal:2',
|
|
'discount_amount' => 'decimal:2',
|
|
'total_amount' => 'decimal:2',
|
|
'paid_amount' => 'decimal:2',
|
|
'debit_note_applied' => 'decimal:2',
|
|
'balance_amount' => 'decimal:2'
|
|
];
|
|
|
|
protected $appends = ['display_status'];
|
|
|
|
public function items(): HasMany
|
|
{
|
|
return $this->hasMany(PurchaseInvoiceItem::class, 'invoice_id');
|
|
}
|
|
|
|
public function vendor(): BelongsTo
|
|
{
|
|
return $this->belongsTo(User::class, 'vendor_id');
|
|
}
|
|
|
|
public function warehouse(): BelongsTo
|
|
{
|
|
return $this->belongsTo(Warehouse::class, 'warehouse_id');
|
|
}
|
|
|
|
public function vendorDetails(): BelongsTo
|
|
{
|
|
return $this->belongsTo(\Workdo\Account\Models\Vendor::class, 'vendor_id', 'user_id');
|
|
}
|
|
|
|
public function paymentAllocations(): HasMany
|
|
{
|
|
return $this->hasMany(\Workdo\Account\Models\VendorPaymentAllocation::class, 'invoice_id');
|
|
}
|
|
|
|
public function purchaseReturns(): HasMany
|
|
{
|
|
return $this->hasMany(PurchaseReturn::class, 'original_invoice_id');
|
|
}
|
|
|
|
public function isOverdue(): bool
|
|
{
|
|
return $this->due_date < now() && $this->status !== 'paid';
|
|
}
|
|
|
|
public function getDisplayStatusAttribute(): string
|
|
{
|
|
if ($this->isOverdue()) {
|
|
return 'overdue';
|
|
}
|
|
return $this->status;
|
|
}
|
|
|
|
protected static function boot()
|
|
{
|
|
parent::boot();
|
|
|
|
static::creating(function ($invoice) {
|
|
if (empty($invoice->invoice_number)) {
|
|
$invoice->invoice_number = static::generateInvoiceNumber();
|
|
}
|
|
});
|
|
}
|
|
|
|
public static function generateInvoiceNumber(): string
|
|
{
|
|
$year = date('Y');
|
|
$month = date('m');
|
|
$lastInvoice = static::where('invoice_number', 'like', "PI-{$year}-{$month}-%")
|
|
->where('created_by', creatorId())
|
|
->orderBy('invoice_number', 'desc')
|
|
->first();
|
|
|
|
if ($lastInvoice) {
|
|
$lastNumber = (int) substr($lastInvoice->invoice_number, -3);
|
|
$nextNumber = $lastNumber + 1;
|
|
} else {
|
|
$nextNumber = 1;
|
|
}
|
|
|
|
return "PI-{$year}-{$month}-" . str_pad($nextNumber, 3, '0', STR_PAD_LEFT);
|
|
}
|
|
}
|