Hi all!
I'm in the process of building my first app with Cake and was
wondering if someone could look over some code and let me know if what
I have done is correct or waay off base...
Its basically a few lines to get 3 different arrays populated with
data from 2 tables via a HABTM releationship.
It gets a bit complicated when I try and use conditions from each
table, but hopefully to you guys it should make sense.. anyways, here
it is:
//closed jobs
$this->Job->User->recursive = 3;
$this->Job->unbindModel(array('hasMany'=>array('Notes')));
$this->Job->User-
>unbindModel(array('hasAndBelongsToMany'=>array('Modules')));
$conditions = array("status_id" => 3);
$this->set('closed_jobs', $this->Job->findAll($conditions));
//user's open jobs
$this->Job->unbindModel(array('hasMany'=>array('Notes')));
$this->Job->bindModel(array('hasOne'=>array('JobUser'=>array())));
$constraint['Job.status_id'] = '<> 3';
$constraint['JobUser.user_id'] = $this->Session->read('User');
$this->set('user_jobs', $this->Job->findAll($constraint));
//other user's open jobs
$this->Job->unbindModel(array('hasMany'=>array('Notes')));
$this->Job->bindModel(array('hasOne'=>array('JobUser'=>array())));
$constraint['Job.status_id'] = '<> 3';
$constraint['JobUser.user_id'] = '<> '.$this->Session-
>read('User');
$this->set('others_jobs', $this->Job->findAll($constraint));
If I'm doing things correctly then great!! If not, a pointer or 2
would be gratefully recieved!
TIA,
d.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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
-~----------~----~----~----~------~----~------~--~---
