if (!defined('LACONICA')) { exit(1); }
require_once(INSTALLDIR.'/actions/showstream.php');
-define('TAGS_PER_PAGE', 20);
+define('TAGS_PER_PAGE', 100);
class TagAction extends StreamAction {
function show_tags()
{
+ # This should probably be cached rather than recalculated
$tags = DB_DataObject::factory('Notice_tag');
- $tags->selectAdd('count(1) as num');
+
+ #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');
+ 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('num DESC, last_notice_id DESC');
- $tags->whereAdd('created > "' . strftime('%Y-%m-%d %H:%M:%S', strtotime('-1 WEEK')) . '"');
+ $tags->orderBy('weight DESC');
- $page = ($this->arg('page')) ? ($this->arg('page')+0) : 1;
+ # $tags->whereAdd('created > "' . strftime('%Y-%m-%d %H:%M:%S', strtotime('-1 MONTH')) . '"');
- $tags->limit((($page-1)*TAGS_PER_PAGE), TAGS_PER_PAGE + 1);
+ $tags->limit(TAGS_PER_PAGE);
$cnt = $tags->find();
if ($cnt > 0) {
- common_element_start('ul', array('id' => 'notices'));
- for ($i = 0; $i < min($cnt, TAGS_PER_PAGE); $i++) {
- if ($tags->fetch()) {
- TagAction::show_tag($tags);
- } else {
- // shouldn't happen!
- break;
- }
+ common_element_start('p', 'tagcloud');
+
+ $tw = array();
+ $sum = 0;
+ while ($tags->fetch()) {
+ $tw[$tags->tag] = $tags->weight;
+ $sum += $tags->weight;
}
- common_element_end('ul');
- }
- common_pagination($page > 1, $cnt > TAGS_PER_PAGE,
- $page, 'tags');
- }
+ ksort($tw);
+
+ foreach ($tw as $tag => $weight) {
+ $this->show_tag($tag, $weight, $weight/$sum);
+ }
- private static function show_tag($tag) {
- common_element_start('li', array('class' => 'notice_single'));
- common_element_start('a', array(
- 'class' => 'nickname',
- 'href' => common_local_url('tag', array('tag' => $tag->tag)),
- 'title' => sprintf(_("Notices tagged with %s"), $tag->tag)));
- common_text('#' . $tag->tag);
- common_element_end('a');
- common_text(sprintf(_('%s Notices recently tagged with %s'), $tag->num, $tag->tag));
-
- $notice = Notice::staticGet($tag->last_notice_id);
- if ($notice) {
- $noticeurl = common_local_url('shownotice', array('notice' => $notice->id));
- common_element_start('p', 'time');
- common_text(_('Last message posted: '));
- common_element('a', array('class' => 'permalink',
- 'href' => $noticeurl,
- 'title' => common_exact_date($notice->created)),
- common_date_string($notice->created));
-
- common_text(_(' by '));
- $profile = $notice->getProfile();
- common_element('a', array('href' => $profile->profileurl),
- $profile->nickname);
common_element_end('p');
}
- common_element_end('li');
}
+ function show_tag($tag, $weight, $relative) {
+
+ # XXX: these should probably tune to the size of the site
+ 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';
+ }
- function show_notices($tag) {
-
- $tags = DB_DataObject::factory('Notice_tag');
-
- $tags->tag = $tag;
+ common_element('a', array('class' => "$cls weight-$weight relative-$relative",
+ 'href' => common_local_url('tag', array('tag' => $tag))),
+ $tag);
+ common_text(' ');
+ }
- $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);
-
- $cnt = $tags->find();
+ $notice = Notice_tag::getStream($tag, (($page-1)*NOTICES_PER_PAGE), NOTICES_PER_PAGE + 1);
- 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');
}