Class EchoareaStat

jnode-core/src/jnode/stat/EchoareaStat.java:39–93

import jnode.stat.threads.StatPoster;

public class EchoareaStat implements IStatPoster, IEventHandler {
	private StatPoster poster;

	public EchoareaStat() {
		Notifier.INSTANSE.register(NewEchoareaEvent.class, this);
	}

	@Override
	public String getSubject() {
		return "Echoarea messages per day";
	}

	@Override
	public String getText() {

		Long before = new Date().getTime() - (24 * 3600 * 1000);
		Long after = new Date().getTime();
		GenericRawResults<String[]> results = ORMManager
				.get(Echomail.class)
				.getRaw(String
						.format("SELECT a.name,a.description,count(e.id) AS count FROM echomail e"
								+ " LEFT JOIN echoarea a ON (e.echoarea_id=a.id) WHERE e.date >= %d AND e.date <= %d"
								+ " GROUP BY a.name,a.description ORDER BY count DESC",
								before, after));

		ReportBuilder builder = new ReportBuilder();
		builder.setColumns(Arrays.asList("Area", "Count", "Description"));
		builder.setColLength(Arrays.asList(35, 5, 35));

		for (String[] res : results) {

			builder.printLine(res[0], res[2], res[1]);

		}
		return builder.getText().toString();
	}

	@Override
	public void handle(IEvent event) {
		if (event instanceof NewEchoareaEvent) {
			Echoarea area = FtnTools.getAreaByName(poster.getTechEchoarea(),
					null);
			FtnTools.writeEchomail(area, "New echoarea created",
					event.getEvent());

		}

	}

	@Override
	public void init(StatPoster poster) {
		this.poster = poster;

	}
}