Hi,
I have a Company table, User table and employees table.
The company details are there in company table.
In employee table there is one company_id and user_id fields. The
relationship is as follows.
One company can have multiple employees, and each employee should have a
record in users table.
Actually When I am finding data of company , I need it to contain all the
employees with their user data on it.
To access the company data.
I tried the following methods but getting error.
Database Error
*Error: * SQLSTATE[42S22]: Column not found: 1054 Unknown column
'Users.company_id' in 'where clause'
================================
Company Model
========
public function initialize(array $config) {
$this->hasMany('Employees');
$this->hasMany('Users', [ 'through' => 'Employees']);
}
Employees Model
===============
public function initialize(array $config) {
$this->belongsTo('Companies');
$this->belongsTo('Users');
}
Users Model
===========
$this->hasMany('Employees');
Would you please help me to find a solution?
Regards,
Jipson
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.
