X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=actions%2Ftag.php;h=75bf6c8bfb76267ed56850926e754f689ecfd4dc;hb=f2e3021b59f3661b3c900b06600a580b8970df2f;hp=9e0b093243002ba86ee3aeef0239a120511c5123;hpb=fdfb8068014176a2443265018a0a53027d535506;p=quix0rs-gnu-social.git

diff --git a/actions/tag.php b/actions/tag.php
index 9e0b093243..75bf6c8bfb 100644
--- a/actions/tag.php
+++ b/actions/tag.php
@@ -20,7 +20,7 @@
 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 {
 
@@ -86,95 +86,93 @@ 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');
 		}