1 files changed, 87 insertions, 0 deletions
diff --git a/src/java/com/juick/http/www/Tags.java b/src/java/com/juick/http/www/Tags.java
new file mode 100644
index 00000000..07cff582
--- /dev/null
+++ b/src/java/com/juick/http/www/Tags.java
@@ -0,0 +1,87 @@
+/*
+ * To change this template, choose Tools | Templates
+ * and open the template in the editor.
+ */
+package com.juick.http.www;
+
+import java.io.IOException;
+import java.io.PrintWriter;
+import java.io.UnsupportedEncodingException;
+import java.net.URLEncoder;
+import java.sql.Connection;
+import java.sql.PreparedStatement;
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.util.Arrays;
+import java.util.Locale;
+import java.util.ResourceBundle;
+import javax.servlet.ServletException;
+import javax.servlet.http.HttpServletRequest;
+import javax.servlet.http.HttpServletResponse;
+
+/**
+ *
+ * @author ugnich
+ */
+public class Tags {
+
+    protected void doGetTags(Connection sql, HttpServletRequest request, HttpServletResponse response, com.juick.User visitor) throws ServletException, IOException {
+        Locale locale = request.getLocale();
+        ResourceBundle rbnm = ResourceBundle.getBundle("Blogs", locale);
+
+        response.setContentType("text/html; charset=UTF-8");
+        PrintWriter out = response.getWriter();
+        try {
+            PageTemplates.pageHead(out, rbnm.getString("Tags"), null);
+            PageTemplates.pageNavigation(out, locale, visitor);
+
+            int cnt = 30;
+            com.juick.Tag tags[] = new com.juick.Tag[cnt];
+            int maxUsageCnt = 0;
+            PreparedStatement stmt = null;
+            ResultSet rs = null;
+            try {
+                stmt = sql.prepareStatement("SELECT tags.name AS name,COUNT(DISTINCT messages.user_id) AS cnt FROM (messages INNER JOIN messages_tags ON (messages.ts>TIMESTAMPADD(DAY,-3,NOW()) AND messages.message_id=messages_tags.message_id)) INNER JOIN tags ON messages_tags.tag_id=tags.tag_id GROUP BY tags.tag_id ORDER BY cnt DESC LIMIT ?");
+                stmt.setInt(1, cnt);
+                rs = stmt.executeQuery();
+                rs.beforeFirst();
+                cnt = 0;
+                while (rs.next()) {
+                    tags[cnt] = new com.juick.Tag();
+                    tags[cnt].Name = rs.getString(1);
+                    tags[cnt].UsageCnt = rs.getInt(2);
+                    if (tags[cnt].UsageCnt > maxUsageCnt) {
+                        maxUsageCnt = tags[cnt].UsageCnt;
+                    }
+                    cnt++;
+                }
+            } catch (SQLException e) {
+                System.err.println(e);
+            } finally {
+                Utils.finishSQL(rs, stmt);
+            }
+
+            Arrays.sort(tags, 0, cnt);
+
+            for (int i = 0; i < cnt; i++) {
+                String tag = Utils.encodeHTML(tags[i].Name);
+                try {
+                    tag = "<a href=\"/?tag=" + URLEncoder.encode(tags[i].Name, "UTF-8") + "\">" + tag + "</a>";
+                } catch (UnsupportedEncodingException e) {
+                }
+
+                if (tags[i].UsageCnt > maxUsageCnt / 3 * 2) {
+                    out.print("<big>" + tag + "</big> ");
+                } else if (tags[i].UsageCnt > maxUsageCnt / 3) {
+                    out.print("<small>" + tag + "</small> ");
+                } else {
+                    out.print(tag + " ");
+                }
+            }
+
+            PageTemplates.pageFooter(request, out, locale, visitor);
+        } finally {
+            out.close();
+        }
+    }
+}