require_once(INSTALLDIR.'/actions/showstream.php');
define('TAGS_PER_PAGE', 100);
-define('AGE_FACTOR', 864000.0);
class TagAction extends StreamAction {
{
# This should probably be cached rather than recalculated
$tags = DB_DataObject::factory('Notice_tag');
+
+ #Need to clear the selection and then only re-add the field
+ #we are grouping by, otherwise it's not a valid 'group by'
+ #even though MySQL seems to let it slide...
+ $tags->selectAdd();
+ $tags->selectAdd('tag');
+
+ #Add the aggregated columns...
$tags->selectAdd('max(notice_id) as last_notice_id');
- $tags->selectAdd(sprintf('sum(exp(-(now() - created)/%f)) as weight', AGE_FACTOR));
+ if(common_config('db','type')=='pgsql') {
+ $calc='sum(exp(-extract(epoch from (now()-created))/%s)) as weight';
+ } else {
+ $calc='sum(exp(-(now() - created)/%s)) as weight';
+ }
+ $tags->selectAdd(sprintf($calc, common_config('tag', 'dropoff')));
$tags->groupBy('tag');
$tags->orderBy('weight DESC');
$tw[$tags->tag] = $tags->weight;
$sum += $tags->weight;
}
+
+ ksort($tw);
foreach ($tw as $tag => $weight) {
- $this->show_tag($tag, $weight/$sum);
+ $this->show_tag($tag, $weight, $weight/$sum);
}
-
+
common_element_end('p');
}
}
- function show_tag($tag, $relative) {
-
+ function show_tag($tag, $weight, $relative) {
+
# XXX: these should probably tune to the size of the site
- $cls = ($relative > 0.1) ? 'largest' :
- ($relative > 0.05) ? 'verylarge' :
- ($relative > 0.02) ? 'large' :
- ($relative > 0.01) ? 'medium' :
- ($relative > 0.005) ? 'small' :
- ($relative > 0.002) ? 'verysmall' :
- 'smallest';
-
- common_element('a', array('class' => $cls,
+ if ($relative > 0.1) {
+ $cls = 'largest';
+ } else if ($relative > 0.05) {
+ $cls = 'verylarge';
+ } else if ($relative > 0.02) {
+ $cls = 'large';
+ } else if ($relative > 0.01) {
+ $cls = 'medium';
+ } else if ($relative > 0.005) {
+ $cls = 'small';
+ } else if ($relative > 0.002) {
+ $cls = 'verysmall';
+ } else {
+ $cls = 'smallest';
+ }
+
+ common_element('a', array('class' => "$cls weight-$weight relative-$relative",
'href' => common_local_url('tag', array('tag' => $tag))),
$tag);
common_text(' ');
}
-
- function show_notices($tag) {
-
- $tags = DB_DataObject::factory('Notice_tag');
-
- $tags->tag = $tag;
- $tags->orderBy('created DESC');
+ function show_notices($tag) {
+ $cnt = 0;
+
$page = ($this->arg('page')) ? ($this->arg('page')+0) : 1;
- $tags->limit((($page-1)*NOTICES_PER_PAGE), NOTICES_PER_PAGE + 1);
+ $notice = Notice_tag::getStream($tag, (($page-1)*NOTICES_PER_PAGE), NOTICES_PER_PAGE + 1);
- $cnt = $tags->find();
-
- if ($cnt > 0) {
+ if ($notice) {
common_element_start('ul', array('id' => 'notices'));
- for ($i = 0; $i < min($cnt, NOTICES_PER_PAGE); $i++) {
- if ($tags->fetch()) {
- $notice = new Notice();
- $notice->id = $tags->notice_id;
- $result = $notice->find(true);
- if (!$result) {
- continue;
- }
- $this->show_notice($notice);
- } else {
- // shouldn't happen!
+ while ($notice->fetch()) {
+ $cnt++;
+ if ($cnt > NOTICES_PER_PAGE) {
break;
}
+ $this->show_notice($notice);
}
common_element_end('ul');
}