Re: complex find()

Are you running the find() on the User or Attendance model? It looks
to me like it's the former.

Anyway, you could tighten this up a little by putting some code in the
model, and by adding a helper function to bootstrap.php:

function dateStr($a)
{
if (!empty($a['year']) && !empty($a['month']) && !empty($a['day']))
{
return "${a['year']}-${a['month']}-${a['day']}";
}
return null;
}

Also, you can put the school_id in the forma as well, instead of
passing it through the session.

public function admin_attendance_by_date_range()
{
$data = $this->User->attendanceByDateRange(
$this->data['Attendance']['school_id'],
dateStr($this->data['Attendance']['start_date']),
dateStr($this->data['Attendance']['end_date'])
);

...
}

User model:

public function attendanceByDateRange($school_id, $from, $to)
{
return $this->Attendance->find(
'all',
array(
'conditions' => array(
'Attendance.created BETWEEN ? AND ?' => array($from, $to),
'Attendance.school_id' => $school_id
),
'contain' => array(
'User' => array(
'fields' => array(
'User.id',
// other User fields you want
)
)
)
)
);
}

On Wed, Aug 29, 2012 at 2:16 AM, rockbust <rockbust@optonline.net> wrote:
> If anyone can point me in the right direction.. It will be much appreciated
>
> I am trying to return a list of User where Attendance.created is between a
> date specified in my form.
> Further Attendance.created needs to be equal or greater than
> attendance_count input from the form.
> Attendance belongsTo User
>
> I have tried this but get sql error Unknown column 'Attendance.created'
>
> function admin_attendance_by_date_range() {
> $this->Attendance->recursive = 0;
> $session_school_id = $this->Session->read('Userinfo.currentSchoolid');
>
> $from = $this->data['Attendance']['start_date']['year'] . "-" .
> $this->data['Attendance']['start_date']['month'] . "-" .
> $this->data['Attendance']['start_date']['day'];
> $to = $this->data['Attendance']['end_date']['year'] . "-" .
> $this->data['Attendance']['end_date']['month'] . "-" .
> $this->data['Attendance']['end_date']['day'];
> $cond = array('Attendance.created BETWEEN ? AND ?' => array($from, $to),
> 'Attendance.school_id' => $session_school_id);
>
> Robert
>
>
>
>
> --
> View this message in context: http://cakephp.1045679.n5.nabble.com/complex-find-tp5710758.html
> Sent from the CakePHP mailing list archive at Nabble.com.
>
> --
> You received this message because you are subscribed to the Google Groups "CakePHP" group.
> To post to this group, send email to cake-php@googlegroups.com.
> To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com.
> Visit this group at http://groups.google.com/group/cake-php?hl=en-US.
>
>

--
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com.
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en-US.