Search in sources :

Example 6 with Language

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>&nbsp;</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>&nbsp;</td><td>&nbsp;</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>&nbsp;</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>]&nbsp;&nbsp;");
    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>]" + "&nbsp;&nbsp;[<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>]&nbsp;&nbsp;</p>" + "<script>!function(w){setTimeout(function(){w.location.reload()},60000)}(this)</script>");
    model.addAttribute("content", sb.toString());
    return "legacy";
}
Also used : Submission(cn.edu.zjnu.acm.judge.domain.Submission) Instant(java.time.Instant) DecimalFormat(java.text.DecimalFormat) URIBuilder(cn.edu.zjnu.acm.judge.util.URIBuilder) Language(cn.edu.zjnu.acm.judge.domain.Language) SubmissionQueryForm(cn.edu.zjnu.acm.judge.data.form.SubmissionQueryForm) OptionalLong(java.util.OptionalLong) OptionalLong(java.util.OptionalLong) Contest(cn.edu.zjnu.acm.judge.domain.Contest) Map(java.util.Map) GetMapping(org.springframework.web.bind.annotation.GetMapping)

Example 7 with Language

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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</td>");
                for (int i = 0; i < languageCount; ++i) {
                    long value = rs.getLong(i + 1);
                    byLanguage[i] += value;
                    if (value == 0) {
                        sb.append("<td>&nbsp;</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>&nbsp;</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>&nbsp;</td>");
    for (int i = 0; i < languageCount; ++i) {
        if (byLanguage[i] == 0) {
            sb.append("<td>&nbsp;</td>");
        } else {
            sb.append("<td>").append(byLanguage[i]).append("</td>");
        }
    }
    sb.append("</tr></table>");
    model.addAttribute("content", sb.toString());
    return "legacy";
}
Also used : Instant(java.time.Instant) Connection(java.sql.Connection) PreparedStatement(java.sql.PreparedStatement) Language(cn.edu.zjnu.acm.judge.domain.Language) ResultSet(java.sql.ResultSet) Contest(cn.edu.zjnu.acm.judge.domain.Contest) GetMapping(org.springframework.web.bind.annotation.GetMapping)

Example 8 with Language

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();
}
Also used : Language(cn.edu.zjnu.acm.judge.domain.Language) MvcResult(org.springframework.test.web.servlet.MvcResult) Test(org.junit.jupiter.api.Test) SpringBootTest(org.springframework.boot.test.context.SpringBootTest)

Aggregations

Language (cn.edu.zjnu.acm.judge.domain.Language)8 Instant (java.time.Instant)4 GetMapping (org.springframework.web.bind.annotation.GetMapping)4 Contest (cn.edu.zjnu.acm.judge.domain.Contest)3 DecimalFormat (java.text.DecimalFormat)3 Map (java.util.Map)3 SpringBootTest (org.springframework.boot.test.context.SpringBootTest)3 SubmissionQueryForm (cn.edu.zjnu.acm.judge.data.form.SubmissionQueryForm)2 Submission (cn.edu.zjnu.acm.judge.domain.Submission)2 RunResult (cn.edu.zjnu.acm.judge.support.RunResult)2 IOException (java.io.IOException)2 Path (java.nio.file.Path)2 Connection (java.sql.Connection)2 PreparedStatement (java.sql.PreparedStatement)2 ResultSet (java.sql.ResultSet)2 ArrayList (java.util.ArrayList)2 OptionalLong (java.util.OptionalLong)2 Application (cn.edu.zjnu.acm.judge.Application)1 ExecuteResult (cn.edu.zjnu.acm.judge.core.ExecuteResult)1 GroovyHolder (cn.edu.zjnu.acm.judge.core.GroovyHolder)1