/*
* 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 = "" + tag + "";
} catch (UnsupportedEncodingException e) {
}
if (tags[i].UsageCnt > maxUsageCnt / 3 * 2) {
out.print("" + tag + " ");
} else if (tags[i].UsageCnt > maxUsageCnt / 3) {
out.print("" + tag + " ");
} else {
out.print(tag + " ");
}
}
PageTemplates.pageFooter(request, out, locale, visitor);
} finally {
out.close();
}
}
}