Hi Chris,
Why are you not able to change that loop, is the loop itself some how
legacy? It's not clear to me where/how the minimum and maxium members
values need to be determined - where does that come from, is that in
the stat table?
Anyway here are a few different permutations depending on what you
need, none of it is tested (obviously) and I doubt any of them will
give you what you want out of the box, but perhaps they might help on
the way.
OLD:
$start = $this->Stat->findAll(
array(
'Site.category' => $category,
'Stat.s_date' => $start_date
)
);
$finish = $this->Stat->findAll(
array(
'Site.category' => $category,
'Stat.s_date' => $finish_date
)
);
NEW:
$resultsMin = $this->Stat->findAll(
array(
'Site.id' => $siteId,
'Stat.s_date' => "BETWEEN $start_date AND $finish_date",
),
array(
'DISTINCT s_date',
'members',
'threads',
'posts',
etc.
),
'Stat.members ASC'
);
$resultsMax = $this->Stat->findAll(
array(
'Site.id' => $siteId,
'Stat.s_date' => "BETWEEN $start_date AND $finish_date",
),
array(
'DISTINCT s_date',
'members',
'threads',
'posts',
etc.
),
'Stat.members DESC'
);
OR why not get the DB to do it?
$results = $this->Stat->findAll(
"Site.id = '$siteId' AND Stat.s_date BETWEEN $start_date AND
$finish_date GROUP BY Stat.s_date",
),
array(
'MIN(members) as MinMembers',
'MAX(members) as MaxMembers',
etc.
)
);
as mentioned by oldgreycells, agreagate functions are not in the
results for any particular model, but that isn't much of a problem if
you use afterFind or otherwise take account of where this data will be.
HTH,
AD7six
Please note:
The manual/bakery is a good place to start any quest for info.
The cake search (at the time of writing) erroneously reports less/no
results for the google group.
The wiki may contain incorrect info - read at your own risk (it's
mainly user submitted) :) You may get your answer quicker by asking on
the IRC Channel (you can access it with just a browser
here:http://irc.cakephp.org).
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
