Method report

jnode-core/src/jnode/jscript/ReportHelper.java:58–97

(String echoarea, String subject, String sql,
			String headers, String colLen, String formats)

	}

	public void report(String echoarea, String subject, String sql,
			String headers, String colLen, String formats) {

		GenericRawResults<String[]> results = ORMManager.get(Echoarea.class)
				.getRaw(sql);

		if (results == null) {
			return;
		}

		List<String[]> res;
		try {
			res = results.getResults();
		} catch (SQLException e) {
			logger.l3("sql problem", e);
			return;
		}

		if (res == null || res.size() == 0) {
			return;
		}

		ReportBuilder builder = new ReportBuilder();
		builder.setColumns(headers, DELIM);
		builder.setColLength(colLen, DELIM);
		if (formats != null && formats.length() != 0) {
			builder.setFormats(formats, DELIM);
		}

		for (String[] items : res) {
			builder.printLine(items);
		}

		String text = builder.getText().toString();
		if (text.length() != 0) {
			Echoarea area = FtnTools.getAreaByName(echoarea, null);
			FtnTools.writeEchomail(area, subject, text);
			logger.l5("send message to " + echoarea);
		}
	}
}