011f749786
Perubahan yang dilakukan: - Menambahkan relasi branch di model Account berdasarkan kolom branch_code. - Menambahkan relasi account di model PrintStatementLog untuk akses data account dari log. - Memperbaiki referensi branch_name di PrintStatementController agar menggunakan relasi dari model Account. - Menonaktifkan eager loading pada query di PrintStatementController untuk optimasi performa. Tujuan perubahan: - Memastikan data branch dan account dapat diakses langsung melalui relasi antar model. - Menghindari potensi masalah N+1 query saat mengambil data terkait branch. - Meningkatkan efisiensi kode dan menjaga konsistensi data dalam proses statement.
62 lines
1.4 KiB
PHP
62 lines
1.4 KiB
PHP
<?php
|
|
|
|
namespace Modules\Webstatement\Models;
|
|
|
|
use Illuminate\Database\Eloquent\Model;
|
|
use Illuminate\Database\Eloquent\Factories\HasFactory;
|
|
use Modules\Basicdata\Models\Branch;
|
|
// use Modules\Webstatement\Database\Factories\AccountFactory;
|
|
|
|
class Account extends Model
|
|
{
|
|
use HasFactory;
|
|
|
|
/**
|
|
* The attributes that are mass assignable.
|
|
*/
|
|
protected $fillable = [
|
|
'account_number',
|
|
'customer_code',
|
|
'currency',
|
|
'opening_date',
|
|
'branch_code',
|
|
'open_category',
|
|
'start_year_bal',
|
|
'closure_date',
|
|
'account_type',
|
|
'stmt_email',
|
|
'stmt_sent_type',
|
|
'open_actual_bal',
|
|
'open_cleared_bal'
|
|
];
|
|
|
|
// Relationships
|
|
public function customer()
|
|
{
|
|
return $this->belongsTo(Customer::class, 'customer_code', 'customer_code');
|
|
}
|
|
|
|
/**
|
|
* Get all balances for this account.
|
|
*/
|
|
public function balances()
|
|
{
|
|
return $this->hasMany(AccountBalance::class, 'account_number', 'account_number');
|
|
}
|
|
|
|
/**
|
|
* Get balance for a specific period.
|
|
*
|
|
* @param string $period Format: YYYY-MM
|
|
* @return AccountBalance|null
|
|
*/
|
|
public function getBalanceForPeriod($period)
|
|
{
|
|
return $this->balances()->where('period', $period)->first();
|
|
}
|
|
|
|
public function branch(){
|
|
return $this->belongsTo(Branch::class, 'branch_code','code');
|
|
}
|
|
}
|