FM / employee

/home/techb158/ileadtechnology.com/SSM/app/Models/employee/

/home/techb158/ileadtechnology.com/SSM/app/Models/employee

Name	Size	Mode	Actions
Attendance.php	3210	0644	edit dl rm
AttendanceDetail.php	2093	0644	edit dl rm
Employee.php	8573	0644	edit dl rm
EmployeeAccount.php	1926	0644	edit dl rm
EmployeeDesignation.php	1875	0644	edit dl rm
EmployeeDocument.php	1999	0644	edit dl rm
EmployeeQualification.php	1724	0644	edit dl rm
EmployeeTerm.php	1535	0644	edit dl rm
LeaveAllocation.php	2408	0644	edit dl rm
LeaveAllocationDetail.php	1628	0644	edit dl rm
LeaveRequest.php	3527	0644	edit dl rm
LeaveRequestDetail.php	1831	0644	edit dl rm
Payroll.php	3381	0644	edit dl rm
PayrollDetail.php	1265	0644	edit dl rm
PayrollTemplate.php	2143	0644	edit dl rm
PayrollTemplateDetail.php	1580	0644	edit dl rm
Salary.php	3156	0644	edit dl rm
SalaryDetail.php	1788	0644	edit dl rm

Edit: /home/techb158/ileadtechnology.com/SSM/app/Models/employee/Payroll.php (3381B)

<?php

namespace App\Models\Employee;

use Illuminate\Database\Eloquent\Model;
use Spatie\Activitylog\Traits\LogsActivity;

class Payroll extends Model
{
    use LogsActivity;

protected $fillable = [
                            'employee_id',
                            'employee_salary_id',
                            'period',
                            'period_detail',
                            'start_date',
                            'end_date',
                            'per_day_calculation_basis',
                            'payment_status',
                            'total',
                            'paid',
                            'remarks',
                            'options'
                        ];
    protected $casts = ['options' => 'array', 'start_date' => 'date', 'end_date' => 'date'];
    protected $primaryKey = 'id';
    protected $table = 'payrolls';
    protected static $logName = 'payroll';
    protected static $logFillable = true;
    protected static $logOnlyDirty = true;
    protected static $ignoreChangedAttributes = ['updated_at'];
    protected $appends = ['balance','number'];
    
    public function payrollDetails()
    {
        return $this->hasMany('App\Models\Employee\PayrollDetail','payroll_id');
    }

public function employee()
    {
        return $this->belongsTo('App\Models\Employee\Employee');
    }

public function salary()
    {
        return $this->belongsTo('App\Models\Employee\Salary', 'employee_salary_id');
    }

public function transactions()
    {
        return $this->hasMany('App\Models\Finance\Transaction\Transaction');
    }

public function getOption(string $option)
    {
        return array_get($this->options, $option);
    }

public function getBalanceAttribute()
    {
        return $this->total - $this->paid;
    }

public function getNumberAttribute()
    {
        return $this->prefix.str_pad($this->id, 3, '0', STR_PAD_LEFT);
    }

public function scopeInfo($q)
    {
        return $q->with([
            'employee:id,code,prefix,first_name,middle_name,last_name,contact_number',
            'employee.employeeDesignations:id,employee_id,designation_id,department_id,date_effective,date_end',
            'employee.employeeDesignations.designation:id,name,employee_category_id',
            'employee.employeeDesignations.designation.employeeCategory:id,name',
            'employee.employeeDesignations.department:id,name',
            'payrollDetails:id,payroll_id,pay_head_id,amount',
            'payrollDetails.payHead:id,name,alias,type',
            'transactions' => function($q1) {
                $q1->select('id','payroll_id','prefix','number','account_id','payment_method_id','amount','date','instrument_number','instrument_bank_detail','reference_number','instrument_date','instrument_clearing_date')->where('is_cancelled','=',0);
            },
            'transactions.account:id,name',
            'transactions.paymentMethod:id,name,options'
        ]);
    }

public function scopeFilterById($q, $id)
    {
        if (! $id) {
            return $q;
        }

return $q->where('id', '=', $id);
    }

public function scopeFilterByEmployeeId($q, $employee_id)
    {
        if (! $employee_id) {
            return $q;
        }

return $q->where('employee_id', '=', $employee_id);
    }
}

'array', 'start_date' => 'date', 'end_date' => 'date']; protected $primaryKey = 'id'; protected $table = 'payrolls'; protected static $logName = 'payroll'; protected static $logFillable = true; protected static $logOnlyDirty = true; protected static $ignoreChangedAttributes = ['updated_at']; protected $appends = ['balance','number']; public function payrollDetails() { return $this->hasMany('App\Models\Employee\PayrollDetail','payroll_id'); } public function employee() { return $this->belongsTo('App\Models\Employee\Employee'); } public function salary() { return $this->belongsTo('App\Models\Employee\Salary', 'employee_salary_id'); } public function transactions() { return $this->hasMany('App\Models\Finance\Transaction\Transaction'); } public function getOption(string $option) { return array_get($this->options, $option); } public function getBalanceAttribute() { return $this->total - $this->paid; } public function getNumberAttribute() { return $this->prefix.str_pad($this->id, 3, '0', STR_PAD_LEFT); } public function scopeInfo($q) { return $q->with([ 'employee:id,code,prefix,first_name,middle_name,last_name,contact_number', 'employee.employeeDesignations:id,employee_id,designation_id,department_id,date_effective,date_end', 'employee.employeeDesignations.designation:id,name,employee_category_id', 'employee.employeeDesignations.designation.employeeCategory:id,name', 'employee.employeeDesignations.department:id,name', 'payrollDetails:id,payroll_id,pay_head_id,amount', 'payrollDetails.payHead:id,name,alias,type', 'transactions' => function($q1) { $q1->select('id','payroll_id','prefix','number','account_id','payment_method_id','amount','date','instrument_number','instrument_bank_detail','reference_number','instrument_date','instrument_clearing_date')->where('is_cancelled','=',0); }, 'transactions.account:id,name', 'transactions.paymentMethod:id,name,options' ]); } public function scopeFilterById($q, $id) { if (! $id) { return $q; } return $q->where('id', '=', $id); } public function scopeFilterByEmployeeId($q, $employee_id) { if (! $employee_id) { return $q; } return $q->where('employee_id', '=', $employee_id); } }