use of cn.edu.zjnu.acm.judge.domain.Language in project judge by zjnu-acm.
the class StatusController method status.
@GetMapping({ "/status", "/submissions" })
@SuppressWarnings("AssignmentToMethodParameter")
public String status(HttpServletRequest request, @RequestParam(value = "problem_id", defaultValue = "") String pid, @RequestParam(value = "contest_id", required = false) @Nullable Long contestId, @RequestParam(value = "language", defaultValue = "-1") int language, @RequestParam(value = "size", defaultValue = "20") int size, @RequestParam(value = "bottom", required = false) final Long bottom, @RequestParam(value = "score", required = false) @Nullable Integer sc, @RequestParam(value = "user_id", defaultValue = "") String userId, @RequestParam(value = "top", required = false) final Long top, Model model) {
long problemId = 0;
Map<Long, long[]> problemsMap = Collections.emptyMap();
if (contestId != null) {
problemsMap = contestService.getProblemsMap(contestId);
}
try {
problemId = Long.parseLong(pid);
} catch (NumberFormatException ex) {
if (contestId != null && pid.length() == 1) {
// TODO the character is the index in the list.
int x = Character.toUpperCase(pid.charAt(0)) - 'A';
for (Map.Entry<Long, long[]> entry : problemsMap.entrySet()) {
long key = entry.getKey();
long[] value = entry.getValue();
if (x == value[0]) {
problemId = key;
break;
}
}
}
}
SubmissionQueryForm form = SubmissionQueryForm.builder().problem(problemId == 0 ? null : problemId).contest(contestId).score(sc).size(Math.max(Math.min(size, 500), 0)).top(top).bottom(bottom).user(StringUtils.hasText(userId) ? userId : null).language(language != -1 ? language : null).build();
log.debug("{}", form);
List<Submission> submissions = submissionMapper.findAllByCriteria(form);
OptionalLong min = submissions.stream().mapToLong(Submission::getId).min();
OptionalLong max = submissions.stream().mapToLong(Submission::getId).max();
model.addAttribute("contestId", contestId);
model.addAttribute("title", "Problem Status List");
StringBuilder sb = new StringBuilder("<p align=center><font size=4 color=#339>Problem Status List</font></p>" + "<form method=get action='status'/><label for='pid'>Problem ID:</label><input id='pid' type=text name=problem_id size=8 value=\"").append(HtmlEscape.escapeHtml4Xml(pid)).append("\"/> <label for='uid'>User ID:</label><input id='uid' type=text name=user_id size=15 value=\"").append(HtmlEscape.escapeHtml4Xml(userId)).append("\"/>" + " <label for='languag'>Language:</label>" + "<select id='languag' size=\"1\" name=\"language\">" + "<option value=\"\">All</option>");
for (Map.Entry<Integer, Language> entry : languageService.getAvailableLanguages().entrySet()) {
int key = entry.getKey();
Language value = entry.getValue();
sb.append("<option value=\"").append(key).append("\"").append(key == language ? " selected" : "").append(">").append(HtmlEscape.escapeHtml4Xml(value.getName())).append("</option>");
}
sb.append("</select>");
if (contestId != null) {
sb.append("<input type=hidden name=contest_id value='").append(contestId).append("' />");
}
sb.append(" <button type=submit>Go</button></form>" + "<TABLE cellSpacing=0 cellPadding=0 width=100% border=1 class=table-back style=\"border-collapse: collapse\" bordercolor=#FFF>" + "<tr bgcolor=#6589D1><td align=center width=8%><b>Run ID</b></td><td align=center width=10%><b>User</b></td><td align=center width=6%><b>Problem</b></td>" + "<td align=center width=10%><b>Result</b></td><td align=center width=10%><b>Score</b></td><td align=center width=7%><b>Memory</b></td><td align=center width=7%><b>Time</b></td><td align=center width=7%><b>Language</b></td><td align=center width=7%><b>Code Length</b></td><td align=center width=17%><b>Submit Time</b></td></tr>");
boolean admin = UserDetailsServiceImpl.isAdministrator(request);
boolean sourceBrowser = UserDetailsServiceImpl.isSourceBrowser(request);
for (Submission submission : submissions) {
long id = submission.getId();
String user_id1 = submission.getUser();
long problem_id1 = submission.getProblem();
Long contest_id1 = submission.getContest();
long[] num = problemsMap.getOrDefault(problem_id1, new long[] { -1 });
int score = submission.getScore();
Instant inDate = submission.getInDate();
String language1 = languageService.getLanguageName(submission.getLanguage());
String color;
if (score == 100) {
color = "blue";
} else {
color = "red";
}
sb.append("<tr align=center><td>").append(id).append("</td>");
sb.append("<td><a href=userstatus?user_id=").append(user_id1).append(">").append(user_id1).append("</a></td>");
if (contestId == null || num[0] == -1) {
sb.append("<td><a href=showproblem?problem_id=").append(problem_id1).append(">").append(problem_id1).append("</a></td>");
} else {
sb.append("<td><a href=contests/").append(contestId).append("/problems/").append(num[1]).append("?_format=html>").append(contestService.toProblemIndex(num[0])).append("</a></td>");
}
if (score == ResultType.COMPILE_ERROR) {
if (submissionService.canView(request, submission)) {
sb.append("<td><a href=\"showcompileinfo?solution_id=").append(id).append("\" target=_blank><font color=green>").append(ResultType.getResultDescription(score)).append("</font></a></td>");
} else {
sb.append("<td><font color=green>").append(ResultType.getResultDescription(score)).append("</font></td>");
}
} else if (submissionService.canView(request, submission)) {
sb.append("<td><a href=showsolutiondetails?solution_id=").append(id).append(" target=_blank><strong><font color=").append(color).append(">").append(ResultType.getResultDescription(score)).append("</font></strong></a></td>");
} else {
sb.append("<td><font color=").append(color).append(">").append(ResultType.getResultDescription(score)).append("</font></a></td>");
}
if (score <= 100 && score >= 0) {
sb.append("<td>").append(score).append("</td>");
} else {
sb.append("<td> </td>");
}
boolean ended = true;
if (!admin && contest_id1 != null) {
Contest contest = contestMapper.findOne(contest_id1);
if (contest != null) {
ended = contest.isEnded();
}
}
if (score == 100 && ended) {
sb.append("<td>").append(submission.getMemory()).append("K</td><td>").append(submission.getTime()).append("MS</td>");
} else {
sb.append("<td> </td><td> </td>");
}
if (admin || sourceBrowser || UserDetailsServiceImpl.isUser(user_id1)) {
sb.append("<td><a href=showsource?solution_id=").append(id).append(" target=_blank>").append(language1).append("</a></td>");
} else {
sb.append("<td>").append(language1).append("</td>");
}
if (ended) {
int sourceLength = submission.getSourceLength();
String t = sourceLength > 2048 ? new DecimalFormat("0.00").format(sourceLength / 1024.) + " KB" : sourceLength + " B";
sb.append("<td>").append(t).append("</td>");
} else {
sb.append("<td> </td>");
}
sb.append("<td>").append(dtf.format(inDate.atZone(ZoneId.systemDefault()).toLocalDateTime())).append("</td></tr>");
}
URIBuilder uri = URIBuilder.fromRequest(request).replaceQueryParam("top").replaceQueryParam("bottom");
log.debug("uri={}", uri);
sb.append("</table><p align=center>[<a href=\"").append(request.getContextPath()).append(uri).append("\">Top</a>] ");
sb.append("[<a href=\"").append(request.getContextPath());
if (max.isPresent()) {
uri.replaceQueryParam("bottom", Long.toString(max.getAsLong()));
sb.append(uri);
uri.replaceQueryParam("bottom");
} else {
sb.append(uri);
}
sb.append("\"><font color=blue>Previous Page</font></a>]" + " [<a href=\"").append(request.getContextPath());
if (min.isPresent()) {
uri.replaceQueryParam("top", Long.toString(min.getAsLong()));
}
sb.append(uri).append("\"><font color=blue>Next Page</font></a>] </p>" + "<script>!function(w){setTimeout(function(){w.location.reload()},60000)}(this)</script>");
model.addAttribute("content", sb.toString());
return "legacy";
}
use of cn.edu.zjnu.acm.judge.domain.Language in project judge by zjnu-acm.
the class ContestStatisticsController method contestStatistics.
@GetMapping("conteststatistics")
public String contestStatistics(Model model, @RequestParam("contest_id") long contestId) throws SQLException {
Instant now = Instant.now();
Contest contest = contestService.findOneByIdAndNotDisabled(contestId);
String title = contest.getTitle();
Instant endTime = contest.getEndTime();
model.addAttribute("contestId", contestId);
model.addAttribute("title", "Contest Statistics");
StringBuilder sb = new StringBuilder("<p align=center><font size=5 color=blue>Contest Statistics--");
sb.append(HtmlEscape.escapeHtml4Xml(title));
if (!contest.isEnded()) {
if (endTime != null) {
sb.append("<br/>Time to go:").append(JudgeUtils.INSTANCE.formatTime(now, endTime));
} else {
sb.append("<br/>Time to go Infinity");
}
}
sb.append("</font></p>" + "<TABLE align=center cellSpacing=0 cellPadding=0 width=600 border=1 class=table-back style=\"border-collapse: collapse\" bordercolor=#FFF>" + "<tr bgcolor=#6589D1><th> </th><th>100</th><th>99~70</th><th>69~31</th><th>30~1</th><th>0</th><th>CE</th><th>Others</th><th>Total</th>");
Map<Integer, Language> languages = languageService.getAvailableLanguages();
int languageCount = languages.size();
StringBuilder sql = new StringBuilder(600).append("select ");
for (int i : languages.keySet()) {
sql.append("sum(if(language=").append(i).append(",1,0)) g").append(i).append(",");
}
sql.append("s.problem_id,sum(if(score=100,1,0)) A,sum(if(score<100 and score >=70,1,0)) B,sum(if(score<70 and score >30,1,0)) D,sum(if(score>0 and score <=30,1,0)) C,sum(if(score=0,1,0)) E,sum(if(score=-7,1,0)) F,sum(if(score<-7 or score > 100,1,0)) G,count(*) Total from contest_problem cp left join solution s on cp.problem_id=s.problem_id and cp.contest_id=s.contest_id where s.contest_id=? group by cp.problem_id order by cp.num");
String[] judgeStatus = { "A", "B", "C", "D", "E", "F", "G", "Total" };
long[] byScore = new long[judgeStatus.length];
long[] byLanguage = new long[languageCount];
sb.append("<th> </th>");
languages.values().stream().map(Language::getName).map(HtmlEscape::escapeHtml4Xml).forEach(languageName -> sb.append("<th>").append(languageName).append("</th>"));
sb.append("</tr>");
log.debug("{}", sql);
Map<Long, long[]> problemsMap = contestService.getProblemsMap(contestId);
try (Connection conn = dataSource.getConnection();
PreparedStatement ps = conn.prepareStatement(sql.toString())) {
ps.setLong(1, contestId);
try (ResultSet rs = ps.executeQuery()) {
while (rs.next()) {
long problemId = rs.getLong("problem_id");
long[] num = problemsMap.get(problemId);
if (num != null) {
sb.append("<tr><th><a href=contests/").append(contestId).append("/problems/").append(num[1]).append("?_format=html>").append(contestService.toProblemIndex(num[0])).append("</a></th>");
}
for (int i = 0; i < judgeStatus.length; ++i) {
long value = rs.getLong(judgeStatus[i]);
byScore[i] += value;
if (value == 0) {
sb.append("<td> </td>");
} else if (i == judgeStatus.length - 1) {
sb.append("<th><a href=status?contest_id=").append(contestId).append("&problem_id=").append(problemId).append(">").append(value).append("</a></th>");
} else {
sb.append("<td>").append(value).append("</td>");
}
}
sb.append("<td> </td>");
for (int i = 0; i < languageCount; ++i) {
long value = rs.getLong(i + 1);
byLanguage[i] += value;
if (value == 0) {
sb.append("<td> </td>");
} else {
sb.append("<td>").append(value).append("</td>");
}
}
sb.append("</tr>");
}
}
}
sb.append("<tr><th>Total</th>");
for (int i = 0; i < judgeStatus.length; ++i) {
if (byScore[i] == 0) {
sb.append("<td> </td>");
} else if (i == judgeStatus.length - 1) {
sb.append("<th>").append(byScore[i]).append("</th>");
} else {
sb.append("<td>").append(byScore[i]).append("</td>");
}
}
sb.append("<td> </td>");
for (int i = 0; i < languageCount; ++i) {
if (byLanguage[i] == 0) {
sb.append("<td> </td>");
} else {
sb.append("<td>").append(byLanguage[i]).append("</td>");
}
}
sb.append("</tr></table>");
model.addAttribute("content", sb.toString());
return "legacy";
}
use of cn.edu.zjnu.acm.judge.domain.Language in project judge by zjnu-acm.
the class LanguageControllerTest method testSave.
/**
* Test of save method, of class LanguageController.
*
* {@link LanguageController#save(Language)}
*/
@Test
public void testSave() throws Exception {
log.info("save");
Language language = Language.builder().name("mock language").sourceExtension("tmp").executableExtension("dummy").description("test description").build();
MvcResult result = mvc.perform(post("/api/languages?_format=json").content(objectMapper.writeValueAsString(language)).contentType(MediaType.APPLICATION_JSON)).andExpect(status().isNoContent()).andReturn();
}
Aggregations