Method list

jnode-core/src/jnode/robot/AreaFix.java:198–239

Отправляем %LIST @param link @return @throws SQLException

(Link link)

	 * @throws SQLException
	 */
	private String list(Link link) throws SQLException {
		StringBuilder sb = new StringBuilder();
		sb.append("Legend: * - subscribed\n\n========== List of echoareas ==========\n");
		String[] groups = FtnTools.getOptionStringArray(link,
				LinkOption.SARRAY_LINK_GROUPS);
		List<Echoarea> areas = ORMManager.get(Echoarea.class).getOrderAnd(
				"name", true);
		for (Echoarea area : areas) {
			boolean denied = true;
			if (!"".equals(area.getGroup())) {
				for (String group : groups) {
					if (area.getGroup().equals(group)) {
						denied = false;
						break;
					}
				}
			} else {
				denied = false;
			}
			if (denied) {
				continue;
			}
			Subscription sub = ORMManager.get(Subscription.class).getFirstAnd(
					"echoarea_id", "=", area.getId(), "link_id", "=",
					link.getId());

			if (sub != null) {
				sb.append("* ");
			} else {
				sb.append("  ");
			}
			sb.append(area.getName());
			if (area.getDescription().length() > 0) {
				sb.append(" - ");
				sb.append(area.getDescription());
			}
			sb.append('\n');
		}
		sb.append("========== List of echoareas ==========\n");
		return sb.toString();

	}

	/**
	 * Отправляем %QUERY