Level 1
class EmployeeBankAccount extends Model
{
protected $table='sys_employee_bank_accounts';
protected $fillable=['emp_id','bank_name','branch_name','account_name','account_number','ifsc_code','pan_no'];
public function employee()
{
return $this->belongsTo('App\Employee');
}
}
class Employee extends Model
{
protected $table = 'sys_employee';
/* designation Function Start Here */
public function designation_name()
{
return $this->hasOne('App\Designation','id','designation');
}
/* department Function Start Here */
public function department_name()
{
return $this->hasOne('App\Department','id','department');
}
}
$csvpayroll=EmployeeBankAccount::with('employee')->get();
