/**
* SQL query to get all Datatype-Mappings.
*
* @param site current site
* @throws Exception
*/
private static String listAllDatatypeMappings(int site, String sort) throws Exception {
LGDDatabase database = LGDDatabase.getInstance();
String s = "";
Object[][] a =
database.execute(
"SELECT dm.k, datatype, user_id, COALESCE(usage_count, 0) AS usage_count FROM lgd_map_datatype AS dm LEFT OUTER JOIN lgd_stat_tags_k ON lgd_stat_tags_k.k=dm.k WHERE "
+ (User.getInstance().getView().equals(Functions.MAIN_BRANCH)
? "user_id='main' AND datatype!='deleted'"
: "(user_id='main' AND (dm.k, datatype) IN (SELECT k, datatype FROM lgd_map_datatype WHERE user_id='"
+ User.getInstance().getUsername()
+ "' AND datatype != 'deleted')) OR (user_id='"
+ User.getInstance().getUsername()
+ "' AND datatype!='deleted' AND (dm.k, datatype) NOT IN (SELECT k, datatype FROM lgd_map_datatype WHERE user_id='main')) OR (user_id='main' AND datatype != 'deleted' AND dm.k NOT IN (SELECT k FROM lgd_map_datatype WHERE user_id='"
+ User.getInstance().getUsername()
+ "'))")
+ " ORDER BY "
+ (sort.startsWith("d") ? sort.replaceFirst("d", "") + " DESC" : sort + " ASC")
+ " Limit 20 OFFSET "
+ ((site - 1) * 20));
for (int i = 0; i < a.length; i++) {
s +=
addDatatypeMapping(
i,
a[i][0].toString(),
a[i][1].toString(),
a[i][3].toString(),
a[i][2].toString(),
site,
sort);
}
return s;
}
/**
* Template for user fields.
*
* @param id id for toggle visiblity
* @param submitName submit name
* @param submitValue submit value
* @param columns column count
* @return HTML code
*/
private static String getUserField(
String id, String submitName, String submitValue, int columns) {
String re;
if (!User.getInstance().isLoggedIn()) {
re = "\t\t\t\t\t\t<tr id=\"" + id + "\" style=\"display: none;\">\n";
re += "\t\t\t\t\t\t\t<td colspan=\"" + (columns - 3) + "\" align=\"center\">\n";
re += "\t\t\t\t\t\t\t\t<label>Username:</label>\n";
re +=
"\t\t\t\t\t\t\t\t<input type=\"text\" name=\"user\" value=\""
+ User.getInstance().getUsername()
+ "\" style=\"width: 25em;\" placeholder=\"Username\" required />\n";
re += "\t\t\t\t\t\t\t\t<label>Comment:</label>\n";
re +=
"\t\t\t\t\t\t\t\t<textarea name=\"comment\" style=\"width: 30em; height: 5em;\" placeholder=\"No comment.\" required></textarea>\n";
re += "\t\t\t\t\t\t\t</td>\n";
re += "\t\t\t\t\t\t\t<td colspan=\"" + 3 + "\" align=\"center\">\n";
re +=
"\t\t\t\t\t\t\t\t<input type=\"submit\" name=\""
+ submitName
+ "\" value=\""
+ submitValue
+ "\" />\n";
re += "\t\t\t\t\t\t\t</td>\n";
re += "\t\t\t\t\t\t</tr>\n";
} else {
re = "\t\t\t\t\t\t<tr id=\"" + id + "\" style=\"display: none;\">\n";
re += "\t\t\t\t\t\t\t<td colspan=\"" + (columns - 3) + "\" align=\"center\">\n";
re += "\t\t\t\t\t\t\t\t<label>Comment:</label>\n";
re +=
"\t\t\t\t\t\t\t\t<textarea name=\"comment\" style=\"width: 30em; height: 5em;\" placeholder=\"No comment.\" required></textarea>\n";
re += "\t\t\t\t\t\t\t</td>\n";
re += "\t\t\t\t\t\t\t<td colspan=\"" + 3 + "\" align=\"center\">\n";
re +=
"\t\t\t\t\t\t\t\t<input type=\"submit\" name=\""
+ submitName
+ "\" value=\""
+ submitValue
+ "\" />\n";
re += "\t\t\t\t\t\t\t</td>\n";
re += "\t\t\t\t\t\t</tr>\n";
}
return re;
}
/**
* SQL query to get all K-Mappings.
*
* @param site current site
* @throws Exception
*/
private static String listAllKVMappings(int site, String sort) throws Exception {
LGDDatabase database = LGDDatabase.getInstance();
String s = "";
Object[][] a =
database.execute(
"SELECT kvm.k, kvm.v, property, object, user_id, COALESCE(usage_count, 0) AS usage_count FROM lgd_map_resource_kv AS kvm LEFT OUTER JOIN lgd_stat_tags_kv ON lgd_stat_tags_kv.k=kvm.k AND lgd_stat_tags_kv.v=kvm.v WHERE "
+ (User.getInstance().getView().equals(Functions.MAIN_BRANCH)
? "user_id='main' AND object!='' AND property!=''"
: "(user_id='main' AND (kvm.k, kvm.v, property, object) IN (SELECT k, v, property, object FROM lgd_map_resource_kv WHERE user_id='"
+ User.getInstance().getUsername()
+ "' AND property != '' AND object != '')) OR (user_id='"
+ User.getInstance().getUsername()
+ "' AND property != '' AND object != '' AND (kvm.k, kvm.v, property, object) NOT IN (SELECT k, v, property, object FROM lgd_map_resource_kv WHERE user_id='main')) OR (user_id='main' AND property != '' AND object != '' AND (kvm.k, kvm.v) NOT IN (SELECT k, v FROM lgd_map_resource_kv WHERE user_id='"
+ User.getInstance().getUsername()
+ "'))")
+ " ORDER BY "
+ (sort.startsWith("d")
? (sort.contains("k")
? sort.replaceFirst("d", "") + ", v"
: sort.replaceFirst("d", ""))
+ " DESC"
: (sort.equals("k") ? "k, v" : sort) + " ASC")
+ " Limit 20 OFFSET "
+ ((site - 1) * 20));
for (int i = 0; i < a.length; i++) {
s +=
addKVMapping(
i,
a[i][0].toString(),
a[i][1].toString(),
a[i][2].toString(),
a[i][3].toString(),
a[i][5].toString(),
a[i][4].toString(),
site,
sort);
}
return s;
}
/**
* Template for Literal-Mappings.
*
* @param id id
* @param k k
* @param property property
* @param language language
* @param affectedEntities affected Entities
* @param user userspace
* @param site current site
* @param sort sort
* @return HTML code
*/
private static String addLiteralMapping(
int id,
String k,
String property,
String language,
String affectedEntities,
String user,
int site,
String sort) {
String s = "\t\t\t\t\t\t<tr id=\"lk" + id + "a\">\n";
s += "\t\t\t\t\t\t\t<td>" + k + "</td>\n";
s += "\t\t\t\t\t\t\t<td>" + Functions.shortenURL(property) + "</td>\n";
s += "\t\t\t\t\t\t\t<td>" + language + "</td>\n";
s += "\t\t\t\t\t\t\t<td>" + affectedEntities + "</td>\n";
s += "\t\t\t\t\t\t\t<td><a onclick=\"toggle_visibility('lk" + id + "')\">Edit</a></td>\n";
s += "\t\t\t\t\t\t\t<td><a onclick=\"toggle_visibility('lkd" + id + "')\">Delete</a></td>\n";
if (!user.equals("main") && !User.getInstance().getView().equals(Functions.MAIN_BRANCH))
s += "\t\t\t\t\t\t<td><a onclick=\"toggle_visibility('lkc" + id + "')\">Commit</a></td>\n";
else if (user.equals("main") && !User.getInstance().getView().equals(Functions.MAIN_BRANCH))
s += "\t\t\t\t\t\t<td>Commit</td>\n";
s += "\t\t\t\t\t\t</tr>\n";
s +=
"\t\t\t\t\t\t<form action=\"?tab=all&type=literal&site="
+ site
+ "&sort="
+ sort
+ (User.getInstance().isLoggedIn() ? "" : "&captcha=yes")
+ "\" method=\"post\" accept-charset=\"UTF-8\" autocomplete=\"off\">\n";
s += "\t\t\t\t\t\t\t<tr id=\"lk" + id + "\" style=\"display: none;\">\n";
s += "\t\t\t\t\t\t\t\t<td>" + k + "</td>\n";
s +=
"\t\t\t\t\t\t\t\t<td><input type=\"text\" class=\"property\" name=\"property\" value=\""
+ property
+ "\" style=\"width: 27em;\" required /></td>\n";
s +=
"\t\t\t\t\t\t\t\t<td><input type=\"text\" name=\"language\" value=\""
+ language
+ "\" style=\"width: 27em;\" /></td>\n";
s += "\t\t\t\t\t\t\t\t<td>" + affectedEntities + "</td>\n";
s += "\t\t\t\t\t\t\t\t<input type=\"hidden\" name=\"k\" value=\"" + k + "\" />\n";
s +=
"\t\t\t\t\t\t\t\t<input type=\"hidden\" name=\"aproperty\" value=\"" + property + "\" />\n";
s +=
"\t\t\t\t\t\t\t\t<input type=\"hidden\" name=\"alanguage\" value=\"" + language + "\" />\n";
s += "\t\t\t\t\t\t\t\t<td><a onclick=\"toggle_visibility('lk" + id + "')\">Hide</a></td>\n";
s += "\t\t\t\t\t\t\t\t<td>Delete</td>\n";
if (!User.getInstance().getView().equals(Functions.MAIN_BRANCH))
s += "\t\t\t\t\t\t<td>Commit</td>\n";
s += "\t\t\t\t\t\t\t</tr>\n";
s +=
getUserField(
"lk" + id + "u",
"lmapping",
"Save",
(User.getInstance().getView().equals(Functions.MAIN_BRANCH) ? 6 : 7));
s += "\t\t\t\t\t\t</form>\n";
// delete
s +=
"\t\t\t\t\t\t<form action=\"?tab=all&type=literal&site="
+ site
+ "&sort="
+ sort
+ (User.getInstance().isLoggedIn() ? "" : "&captcha=yes")
+ "\" method=\"post\" accept-charset=\"UTF-8\" autocomplete=\"off\">\n";
s += "\t\t\t\t\t\t\t<tr id=\"lkd" + id + "\" style=\"display: none;\">\n";
s += "\t\t\t\t\t\t\t\t<td>" + k + "</td>\n";
s += "\t\t\t\t\t\t\t\t<td>" + property + "</td>\n";
s += "\t\t\t\t\t\t\t\t<td>" + language + "</td>\n";
s += "\t\t\t\t\t\t\t\t<td>" + affectedEntities + "</td>\n";
s += "\t\t\t\t\t\t\t\t<input type=\"hidden\" name=\"k\" value=\"" + k + "\" />\n";
s += "\t\t\t\t\t\t\t\t<input type=\"hidden\" name=\"property\" value=\"" + property + "\" />\n";
s += "\t\t\t\t\t\t\t\t<input type=\"hidden\" name=\"language\" value=\"" + language + "\" />\n";
s += "\t\t\t\t\t\t\t\t<td>Edit</td>\n";
s += "\t\t\t\t\t\t\t\t<td><a onclick=\"toggle_visibility('lkd" + id + "')\">Hide</a></td>\n";
if (!User.getInstance().getView().equals(Functions.MAIN_BRANCH))
s += "\t\t\t\t\t\t<td>Commit</td>\n";
s += "\t\t\t\t\t\t\t</tr>\n";
s +=
getUserField(
"lkd" + id + "u",
"lmapping",
"Delete",
(User.getInstance().getView().equals(Functions.MAIN_BRANCH) ? 6 : 7));
s += "\t\t\t\t\t\t</form>\n";
// commit
if (!user.equals("main") && !User.getInstance().getView().equals(Functions.MAIN_BRANCH)) {
s +=
"\t\t\t\t\t\t<form action=\"?tab=all&type=literal&site="
+ site
+ "&sort="
+ sort
+ "\" method=\"post\" accept-charset=\"UTF-8\" autocomplete=\"off\">\n";
s += "\t\t\t\t\t\t\t<tr id=\"lkc" + id + "\" style=\"display: none;\">\n";
s += "\t\t\t\t\t\t\t\t<td>" + k + "</td>\n";
s += "\t\t\t\t\t\t\t\t<td>" + property + "</td>\n";
s += "\t\t\t\t\t\t\t\t<td>" + language + "</td>\n";
s += "\t\t\t\t\t\t\t\t<td>" + affectedEntities + "</td>\n";
s += "\t\t\t\t\t\t\t\t<input type=\"hidden\" name=\"k\" value=\"" + k + "\" />\n";
s +=
"\t\t\t\t\t\t\t\t<input type=\"hidden\" name=\"property\" value=\""
+ property
+ "\" />\n";
s +=
"\t\t\t\t\t\t\t\t<input type=\"hidden\" name=\"language\" value=\""
+ language
+ "\" />\n";
s += "\t\t\t\t\t\t\t\t<td>Edit</td>\n";
s += "\t\t\t\t\t\t\t\t<td>Delete</td>\n";
s += "\t\t\t\t\t\t<td><a onclick=\"toggle_visibility('lkc" + id + "')\">Hide</a></td>\n";
s += "\t\t\t\t\t\t\t</tr>\n";
s += getUserField("lkc" + id + "u", "lmapping", "Commit", 7);
s += "\t\t\t\t\t\t</form>\n";
}
return s;
}
/**
* Template for Datatype-Mappings.
*
* @param id id
* @param k k
* @param datatype datatype
* @param affectedEntities affected Entities
* @param user userspace
* @param site current site
* @param sort sort
* @return HTML code
*/
private static String addDatatypeMapping(
int id,
String k,
String datatype,
String affectedEntities,
String user,
int site,
String sort) {
String s = "\t\t\t\t\t\t<tr id=\"tk" + id + "a\">\n";
s += "\t\t\t\t\t\t\t<td>" + k + "</td>\n";
s += "\t\t\t\t\t\t\t<td>" + datatype + "</td>\n";
s += "\t\t\t\t\t\t\t<td>" + affectedEntities + "</td>\n";
s += "\t\t\t\t\t\t\t<td><a onclick=\"toggle_visibility('tk" + id + "')\">Edit</a></td>\n";
s += "\t\t\t\t\t\t\t<td><a onclick=\"toggle_visibility('tkd" + id + "')\">Delete</a></td>\n";
if (!user.equals("main") && !User.getInstance().getView().equals(Functions.MAIN_BRANCH))
s += "\t\t\t\t\t\t<td><a onclick=\"toggle_visibility('tkc" + id + "')\">Commit</a></td>\n";
else if (user.equals("main") && !User.getInstance().getView().equals(Functions.MAIN_BRANCH))
s += "\t\t\t\t\t\t<td>Commit</td>\n";
s += "\t\t\t\t\t\t</tr>\n";
s +=
"\t\t\t\t\t\t<form action=\"?tab=all&type=datatype&site="
+ site
+ "&sort="
+ sort
+ (User.getInstance().isLoggedIn() ? "" : "&captcha=yes")
+ "\" method=\"post\" accept-charset=\"UTF-8\" autocomplete=\"off\">\n";
s += "\t\t\t\t\t\t\t<tr id=\"tk" + id + "\" style=\"display: none;\">\n";
s += "\t\t\t\t\t\t\t\t<td>" + k + "</td>\n";
s += "\t\t\t\t\t\t\t\t<td align=\"center\"><label>Datatype: </label>\n";
s += "\t\t\t\t\t\t\t\t\t<div class=\"select\"><select name=\"datatype\">\n";
s +=
"\t\t\t\t\t\t\t\t\t\t<option value=\"boolean\" "
+ (datatype.equals("boolean") ? "selected" : "")
+ ">boolean</option>\n";
s +=
"\t\t\t\t\t\t\t\t\t\t<option value=\"int\" "
+ (datatype.equals("int") ? "selected" : "")
+ ">int</option>\n";
s +=
"\t\t\t\t\t\t\t\t\t\t<option value=\"float\" "
+ (datatype.equals("float") ? "selected" : "")
+ ">float</option>\n";
s += "\t\t\t\t\t\t\t\t\t</select></div>\n";
s += "\t\t\t\t\t\t\t\t</td>\n";
s += "\t\t\t\t\t\t\t\t<td>" + affectedEntities + "</td>\n";
s += "\t\t\t\t\t\t\t\t<input type=\"hidden\" name=\"k\" value=\"" + k + "\" />\n";
s +=
"\t\t\t\t\t\t\t\t<input type=\"hidden\" name=\"adatatype\" value=\"" + datatype + "\" />\n";
s += "\t\t\t\t\t\t\t\t<td><a onclick=\"toggle_visibility('tk" + id + "')\">Hide</a></td>\n";
s += "\t\t\t\t\t\t\t\t<td>Delete</td>\n";
if (!User.getInstance().getView().equals(Functions.MAIN_BRANCH))
s += "\t\t\t\t\t\t<td>Commit</td>\n";
s += "\t\t\t\t\t\t\t</tr>\n";
s +=
getUserField(
"tk" + id + "u",
"dmapping",
"Save",
(User.getInstance().getView().equals(Functions.MAIN_BRANCH) ? 5 : 6));
s += "\t\t\t\t\t\t</form>\n";
// delete
s +=
"\t\t\t\t\t\t<form action=\"?tab=all&type=datatype&site="
+ site
+ "&sort="
+ sort
+ (User.getInstance().isLoggedIn() ? "" : "&captcha=yes")
+ "\" method=\"post\" accept-charset=\"UTF-8\" autocomplete=\"off\">\n";
s += "\t\t\t\t\t\t\t<tr id=\"tkd" + id + "\" style=\"display: none;\">\n";
s += "\t\t\t\t\t\t\t\t<td>" + k + "</td>\n";
s += "\t\t\t\t\t\t\t\t<td>" + datatype + "</td>\n";
s += "\t\t\t\t\t\t\t\t<td>" + affectedEntities + "</td>\n";
s += "\t\t\t\t\t\t\t\t<input type=\"hidden\" name=\"k\" value=\"" + k + "\" />\n";
s += "\t\t\t\t\t\t\t\t<input type=\"hidden\" name=\"datatype\" value=\"" + datatype + "\" />\n";
s += "\t\t\t\t\t\t\t\t<td>Edit</td>\n";
s += "\t\t\t\t\t\t\t\t<td><a onclick=\"toggle_visibility('tkd" + id + "')\">Hide</a></td>\n";
if (!User.getInstance().getView().equals(Functions.MAIN_BRANCH))
s += "\t\t\t\t\t\t<td>Commit</td>\n";
s += "\t\t\t\t\t\t\t</tr>\n";
s +=
getUserField(
"tkd" + id + "u",
"dmapping",
"Delete",
(User.getInstance().getView().equals(Functions.MAIN_BRANCH) ? 5 : 6));
s += "\t\t\t\t\t\t</form>\n";
// commit
if (!user.equals("main") && !User.getInstance().getView().equals(Functions.MAIN_BRANCH)) {
s +=
"\t\t\t\t\t\t<form action=\"?tab=all&type=datatype&site="
+ site
+ "&sort="
+ sort
+ "\" method=\"post\" accept-charset=\"UTF-8\" autocomplete=\"off\">\n";
s += "\t\t\t\t\t\t\t<tr id=\"tkc" + id + "\" style=\"display: none;\">\n";
s += "\t\t\t\t\t\t\t\t<td>" + k + "</td>\n";
s += "\t\t\t\t\t\t\t\t<td>" + datatype + "</td>\n";
s += "\t\t\t\t\t\t\t\t<td>" + affectedEntities + "</td>\n";
s += "\t\t\t\t\t\t\t\t<input type=\"hidden\" name=\"k\" value=\"" + k + "\" />\n";
s +=
"\t\t\t\t\t\t\t\t<input type=\"hidden\" name=\"datatype\" value=\""
+ datatype
+ "\" />\n";
s += "\t\t\t\t\t\t\t\t<td>Edit</td>\n";
s += "\t\t\t\t\t\t\t\t<td>Delete</td>\n";
s += "\t\t\t\t\t\t<td><a onclick=\"toggle_visibility('tkc" + id + "')\">Hide</a></td>\n";
s += "\t\t\t\t\t\t\t</tr>\n";
s += getUserField("tkc" + id + "u", "dmapping", "Commit", 6);
s += "\t\t\t\t\t\t</form>\n";
}
return s;
}
/**
* Template for EditHistory.
*
* @param type k/kv/datatype/literal
* @param site current displayed site
* @return HTML code
* @throws Exception
*/
public static String listAllMappings(String type, String site, String sort) throws Exception {
LGDDatabase.getInstance().connect(); // make sure database is connected
String s = "";
if (!site.equals("")) {
if (Integer.valueOf(site) < 1) {
site = "1";
}
} // set negativ site value to 1
if (type.equalsIgnoreCase("k")) {
// insert tablehead
s = "\t\t\t\t\t<h2>List of all K-Mappings</h2>\n";
s += "\t\t\t\t\t<table class=\"table\">\n";
s += "\t\t\t\t\t\t<tr>\n";
s +=
"\t\t\t\t\t\t\t<th><a href=\"?tab=all&type="
+ type
+ "&sort="
+ (sort.equals("k") ? "dk" : "k")
+ "\">k</a></th>\n";
s += "\t\t\t\t\t\t\t<th>property</th>\n";
s += "\t\t\t\t\t\t\t<th>object</th>\n";
s +=
"\t\t\t\t\t\t\t<th><a href=\"?tab=all&type="
+ type
+ "&sort="
+ (sort.equals("usage_count") ? "dusage_count" : "usage_count")
+ "\">affected Entities</a></th>\n";
s += "\t\t\t\t\t\t\t<th>edit</th>\n";
s += "\t\t\t\t\t\t\t<th>delete</th>\n";
if (!User.getInstance().getView().equals(Functions.MAIN_BRANCH))
s += "\t\t\t\t\t\t<th>commit</th>\n";
s += "\t\t\t\t\t\t</tr>\n";
// insert edithistory from db
s += listAllKMappings(Integer.parseInt(site), sort);
} else if (type.equalsIgnoreCase("kv")) {
// insert tablehead
s = "\t\t\t\t\t<h2>List of all KV-Mappings</h2>\n";
s += "\t\t\t\t\t<table class=\"table\">\n";
s += "\t\t\t\t\t\t<tr>\n";
s +=
"\t\t\t\t\t\t\t<th><a href=\"?tab=all&type="
+ type
+ "&sort="
+ (sort.equals("k") ? "dk" : "k")
+ "\">k</a></th>\n";
s +=
"\t\t\t\t\t\t\t<th><a href=\"?tab=all&type="
+ type
+ "&sort="
+ (sort.equals("v") ? "dv" : "v")
+ "\">v</a></th>\n";
s += "\t\t\t\t\t\t\t<th>property</th>\n";
s += "\t\t\t\t\t\t\t<th>object</th>\n";
s +=
"\t\t\t\t\t\t\t<th><a href=\"?tab=all&type="
+ type
+ "&sort="
+ (sort.equals("usage_count") ? "dusage_count" : "usage_count")
+ "\">affected Entities</a></th>\n";
s += "\t\t\t\t\t\t\t<th>edit</th>\n";
s += "\t\t\t\t\t\t\t<th>delete</th>\n";
if (!User.getInstance().getView().equals(Functions.MAIN_BRANCH))
s += "\t\t\t\t\t\t<th>commit</th>\n";
s += "\t\t\t\t\t\t</tr>\n";
// insert edithistory from db
s += listAllKVMappings(Integer.parseInt(site), sort);
} else if (type.equalsIgnoreCase("datatype")) {
// insert tablehead
s = "\t\t\t\t\t<h2>List of all Datatype-Mappings</h2>\n";
s += "\t\t\t\t\t<table class=\"table\">\n";
s += "\t\t\t\t\t\t<tr>\n";
s +=
"\t\t\t\t\t\t\t<th><a href=\"?tab=all&type="
+ type
+ "&sort="
+ (sort.equals("k") ? "dk" : "k")
+ "\">k</a></th>\n";
s += "\t\t\t\t\t\t\t<th>datatype</th>\n";
s +=
"\t\t\t\t\t\t\t<th><a href=\"?tab=all&type="
+ type
+ "&sort="
+ (sort.equals("usage_count") ? "dusage_count" : "usage_count")
+ "\">affected Entities</a></th>\n";
s += "\t\t\t\t\t\t\t<th>edit</th>\n";
s += "\t\t\t\t\t\t\t<th>delete</th>\n";
if (!User.getInstance().getView().equals(Functions.MAIN_BRANCH))
s += "\t\t\t\t\t\t<th>commit</th>\n";
s += "\t\t\t\t\t\t</tr>\n";
// insert edithistory from db
s += listAllDatatypeMappings(Integer.parseInt(site), sort);
} else if (type.equalsIgnoreCase("literal")) {
// insert tablehead
s = "\t\t\t\t\t<h2>List of all Literal-Mappings</h2>\n";
s += "\t\t\t\t\t<table class=\"table\">\n";
s += "\t\t\t\t\t\t<tr>\n";
s +=
"\t\t\t\t\t\t\t<th><a href=\"?tab=all&type="
+ type
+ "&sort="
+ (sort.equals("k") ? "dk" : "k")
+ "\">k</a></th>\n";
s += "\t\t\t\t\t\t\t<th>property</th>\n";
s += "\t\t\t\t\t\t\t<th>language</th>\n";
s +=
"\t\t\t\t\t\t\t<th><a href=\"?tab=all&type="
+ type
+ "&sort="
+ (sort.equals("usage_count") ? "dusage_count" : "usage_count")
+ "\">affected Entities</a></th>\n";
s += "\t\t\t\t\t\t\t<th>edit</th>\n";
s += "\t\t\t\t\t\t\t<th>delete</th>\n";
if (!User.getInstance().getView().equals(Functions.MAIN_BRANCH))
s += "\t\t\t\t\t\t<th>commit</th>\n";
s += "\t\t\t\t\t\t</tr>\n";
// insert edithistory from db
s += listAllLiteralMappings(Integer.parseInt(site), sort);
}
// insert table foot
s += "\t\t\t\t\t</table>\n";
// prev-next-site
s += "\t\t\t\t\t<div style=\"float: right;\">\n";
if (Integer.valueOf(site) > 1) {
int prevsite = Integer.valueOf(site) - 1;
s +=
"\t\t\t\t\t\t<a href=\"?tab=all&type="
+ type
+ "&sort="
+ sort
+ "&site="
+ prevsite
+ "\"><prev</a> ";
}
int nextsite = Integer.valueOf(site) + 1;
s +=
"\t\t\t\t\t\t<a href=\"?tab=all&type="
+ type
+ "&sort="
+ sort
+ "&site="
+ nextsite
+ "\">next></a>\n";
s += "\t\t\t\t\t</div>\n";
return s;
}