Hi all,
I have a problem with the relationship hasMany when find with a
type of condition :
These are 2 models : Company and Location, a Company hasMany
Location, a Location has a name of location, a phone number,
locationID and companyID while a Company has companyID, companyname,
companylegalname.
- Company hasMany Location
- Company : companyID, companyname, companylegalname.
- Location : locationID, locationname, locationphone, companyID.
I want to find companies and every company's locations. On the
search form, I input a name and I want to find company has the
companyname LIKE that name OR any of it's location has that name. My
solution is :
$conditions = array('OR'=>array(
array('Company.companyname
LIKE' => '%'.$name.'%'),
array('Company.companylegalname
LIKE' => '%'.$name.'%'),
array('Location.locationname
LIKE =>'%'.$name.'%')
));
$this->Company->bindModel(array('hasMany'=>array('Location'=>array
('foreignKey'=>'companyID', 'conditions'=>$conditions))));
$companies = $this->Company->find('all');
This will cause an error that it cannot recognize the fiield
Company.companyname or Company.companylegalname on the condition
clause.
So I tried to find with many ways but they seem to be helpless.
When I put the $conditions at the condition clause on the find
instruction, it cannot recognize the Location.locationname because
this the the relationship hasMany.
I need an advisement on this....
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
