Hi experts,
I am having an issue with containable. I have no problems returning the
proper records for Attendance condition but the database call will still
return all users in database with empty attendance field.
I need to return only User.school_id that match admin's $session_school_id
tried this
$this->User->Behaviors->attach('Containable');
$from = $this->data['User']['start_date']['year'] . "-" .
$this->data['User']['start_date']['month'] . "-" .
$this->data['User']['start_date']['day'];
$to = $this->data['User']['end_date']['year'] . "-" .
$this->data['User']['end_date']['month'] . "-" .
$this->data['User']['end_date']['day'];
$cond = array('Attendance.created BETWEEN ? AND ?' => array($from, $to),
'Attendance.school_id' => $session_school_id);
// return only school user
$cond2 = array('User.school_id' => $session_school_id);
$users = $this->User->find('all', array('contain' => array('Attendance' =>
array('conditions' => $cond), 'Usermembership', 'User' =>
array('conditions' => $cond2) )));
this gives me Warning (512): Model "User" is not associated with model
"User"
and tried this
$users = $this->User->find('all', array('conditions' => $cond2),
array('contain' => array('Attendance' => array('conditions' => $cond),
'Usermembership' )));
does not work either.
cake 1.3
Thank you
Robert
--
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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
