File manager - Edit - /var/www/payraty/accounting_main/app/Models/ChartOfAccount.php
Back
<?php namespace App\Models; use Illuminate\Database\Eloquent\Model; use App\Scopes\OrganisationScope; class ChartOfAccount extends Model { protected $fillable = [ 'name', 'code', 'type', 'sub_type', 'parent', 'is_enabled', 'description', 'created_by', 'organisation_id', ]; protected static function booted() { static::addGlobalScope(new OrganisationScope); // Automatically set the organisation_id before creating the model static::creating(function ($model) { if (auth()->check()) { $model->organisation_id = auth()->user()->organisation_id; } }); } public function types() { return $this->hasOne('App\Models\ChartOfAccountType', 'id', 'type'); } public function accounts() { return $this->hasOne('App\Models\JournalItem', 'account', 'id'); } public function balance() { $journalItem = JournalItem::select(\DB::raw('sum(credit) as totalCredit'), \DB::raw('sum(debit) as totalDebit'), \DB::raw('sum(credit) - sum(debit) as netAmount'))->where('account', $this->id); $journalItem = $journalItem->first(); $data['totalCredit'] = $journalItem->totalCredit; $data['totalDebit'] = $journalItem->totalDebit; $data['netAmount'] = $journalItem->netAmount; return $data; } public function subType() { return $this->hasOne('App\Models\ChartOfAccountSubType', 'id', 'sub_type'); } public function parentAccount() { return $this->hasOne('App\Models\ChartOfAccountParent', 'id', 'parent'); } public function bankAccount() { return $this->hasOne('App\Models\BankAccount', 'chart_account_id', 'id'); } }
| ver. 1.4 |
Github
|
.
| PHP 8.3.30 | Generation time: 0 |
proxy
|
phpinfo
|
Settings