index.html 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188
  1. <head>
  2. <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css"
  3. integrity="sha384-HSMxcRTRxnN+Bdg0JdbxYKrThecOKuH5zCYotlSAcp1+c8xmyTe9GYg1l9a69psu" crossorigin="anonymous">
  4. <script src="https://cdn.jsdelivr.net/npm/echarts@4.3.0/dist/echarts.min.js"></script>
  5. <script src="https://apps.bdimg.com/libs/jquery/1.10.2/jquery.min.js"></script>
  6. <link rel="preconnect" href="https://fonts.gstatic.com">
  7. <link href="https://fonts.loli.net/css2?family=Anonymous+Pro:ital,wght@0,400;0,700;1,400;1,700
  8. &family=Noto+Serif+SC:wght@300;400;500;600;700&display=swap" rel="stylesheet">
  9. <link rel="stylesheet" href="../css/style.css">
  10. <!-- <link rel="stylesheet" href="/css/style.css"> -->
  11. <script type="text/javascript">
  12. function decimal(x, n) {
  13. x = Math.round(x * 10 ** n) / 10 ** n;
  14. return x.toFixed(3);
  15. }
  16. function processFiles(event) {
  17. var file = event.target.files[0];
  18. var message = document.getElementById("message");
  19. message.innerHTML = "文件名称:" + file.name + "<br>";
  20. message.innerHTML += "文件大小:" + file.size + " 字节<br>";
  21. message.innerHTML += "文件类型:" + file.type + "<br>";
  22. var reader = new FileReader();
  23. var content = "";
  24. reader.onload = function (event) {
  25. var output = document.getElementById("fileOutput");
  26. var object = eval("(" + event.target.result + ")");
  27. var classText = "", gradingText = "";
  28. var seIds = [], seNames = [];
  29. seIds = object.data.seIds;
  30. for (var i = 0; i < seIds.length; i++) {
  31. for (var j = 0; j < seIds.length; j++) {
  32. if (object.data.multiExam.singleExams[i].seId == seIds[j]) {
  33. seNames[j] = object.data.multiExam.singleExams[i].seCourseName;
  34. }
  35. }
  36. }
  37. var seNameDic = {};
  38. for (var i = 0; i < seIds.length; i++) {
  39. seNameDic[seIds[i]] = seNames[i];
  40. }
  41. seNameDic["0"] = "总分";
  42. for (var i = 0; i < object.data.singleExamClassYsScores.length; i++) {
  43. seNameDic[object.data.singleExamClassYsScores[i].seId + "Ys"] = seNameDic[object.data.singleExamClassYsScores[i].seId] + " " + object.data.singleExamClassYsScores[i].ysClassId;
  44. }
  45. var seIdDic = {};
  46. for (var i = 0; i < seIds.length; i++) {
  47. for (var j = 0; j < seIds.length; j++) {
  48. if (object.data.multiExamStudentScore.singleExamStudentScores[j].seId == seIds[i]) {
  49. seIdDic[j] = i;
  50. }
  51. }
  52. }
  53. var scoreRate = {};
  54. for (var i = 0; i < seIds.length; i++) {
  55. scoreRate[object.data.multiExamStudentScore.singleExamStudentScores[i].seId] = decimal(object.data.multiExamStudentScore.singleExamStudentScores[i].essScore / object.data.multiExam.singleExams[seIdDic[i]].seFullScore, 3);
  56. }
  57. scoreRate["0"] = decimal(object.data.multiExamStudentScore.messScore / object.data.multiExam.meFullScore, 3);
  58. var classOrder = {}, ysClassOrder = {};
  59. for (var i = 0; i < seIds.length; i++) {
  60. classOrder[object.data.multiExamStudentScore.singleExamStudentScores[i].seId] = decimal(1 - object.data.multiExamStudentScore.singleExamStudentScores[i].essClassOrder / object.data.singleExamClassScores[i].secsStudentCount, 3);
  61. }
  62. for (var i = 0; i < object.data.singleExamClassYsScores.length; i++) {
  63. for (var j = 0; j < seIds.length; j++) {
  64. if (object.data.singleExamClassYsScores[i].seId == object.data.multiExamStudentScore.singleExamStudentScores[j].seId) {
  65. ysClassOrder[object.data.singleExamClassYsScores[i].seId + "Ys"] = decimal(1 - object.data.multiExamStudentScore.singleExamStudentScores[j].essYsClassOrder / object.data.singleExamClassYsScores[i].secsStudentCount, 3);
  66. }
  67. }
  68. }
  69. classOrder["0"] = decimal(1 - object.data.multiExamStudentScore.messClassOrder / object.data.multiExamClassScores[0].mecsStudentCount, 3); + "<br>"
  70. var gradeOrder = {};
  71. for (var i = 0; i < seIds.length; i++) {
  72. gradeOrder[object.data.multiExamStudentScore.singleExamStudentScores[i].seId] = decimal(1 - object.data.multiExamStudentScore.singleExamStudentScores[i].essGradeOrder / object.data.multiExam.singleExams[seIdDic[i]].seStudentCount, 3);
  73. }
  74. gradeOrder["0"] = decimal(1 - object.data.multiExamStudentScore.messGradeOrder / object.data.multiExamSchoolScore.mecsStudentCount, 3); + "<br>"
  75. for (var i = 0; i < seIds.length; i++) {
  76. // object.data.multiExamStudentScore.singleExamStudentScores[i].seId
  77. // object.data.singleExamClassScores[i].seId
  78. // object.data.multiExam.singleExams[i].seId
  79. // seIds[i]
  80. // 前两个和后两个数据应该是能分别对上号的(1-2 3-4),用 seIdDic 连接
  81. // seIdDic {key(1-2): value(3-4),..}
  82. classText += "<h4>"
  83. + seNameDic[object.data.multiExamStudentScore.singleExamStudentScores[i].seId] + "</h4>"
  84. + "单科分数:" + object.data.multiExamStudentScore.singleExamStudentScores[i].essScore + "<br><br>"
  85. + "单科分数班级排名:" + object.data.multiExamStudentScore.singleExamStudentScores[i].essClassOrder + "<br>"
  86. + "单科班级参考人数:" + object.data.singleExamClassScores[i].secsStudentCount + "<br>"
  87. + "单科班级年级排名:" + object.data.singleExamClassScores[i].secsClassOrder + "<br>"
  88. + "单科班级其他数据:"
  89. + '<table class="table table-responsive" style="table-layout: fixed;"><tr><td>平均分</td><td>最高分</td><td>四分位数(75%)</td><td>中位数</td><td>四分位数(25%)</td><td>最低分</td></tr>'
  90. + "<tr><td>" + object.data.singleExamClassScores[i].secsAvgScore + "</td><td>" + object.data.singleExamClassScores[i].secsMaxScore + "</td><td>" + object.data.singleExamClassScores[i].secs3quatrerScore + "</td><td>" + object.data.singleExamClassScores[i].secsHalfScore + "</td><td>" + object.data.singleExamClassScores[i].secsQuarterScore + "</td><td>" + object.data.singleExamClassScores[i].secsMinScore + "</td></tr></table>"
  91. ;
  92. for (var j = 0; j < object.data.singleExamClassYsScores.length; j++) {
  93. if (object.data.singleExamClassYsScores[j].seId == object.data.multiExamStudentScore.singleExamStudentScores[i].seId) {
  94. classText += "<br><br>"
  95. + "单科分层班级名称:" + object.data.singleExamClassYsScores[j].ysClassId + "<br>"
  96. + "单科分数分层班级排名:" + object.data.multiExamStudentScore.singleExamStudentScores[i].essYsClassOrder + "<br>"
  97. + "单科分层班级参考人数:" + object.data.singleExamClassYsScores[j].secsStudentCount + "<br>"
  98. + "单科分层班级年级排名:" + object.data.singleExamClassYsScores[j].secsClassOrder + "<br>"
  99. + "单科分层班级其他数据:"
  100. + '<table class="table table-responsive" style="table-layout: fixed;"><tr><td>平均分</td><td>最高分</td><td>四分位数(75%)</td><td>中位数</td><td>四分位数(25%)</td><td>最低分</td></tr>'
  101. + "<tr><td>" + object.data.singleExamClassYsScores[j].secsAvgScore + "</td><td>" + object.data.singleExamClassYsScores[j].secsMaxScore + "</td><td>" + object.data.singleExamClassYsScores[j].secs3quatrerScore + "</td><td>" + object.data.singleExamClassYsScores[j].secsHalfScore + "</td><td>" + object.data.singleExamClassYsScores[j].secsQuarterScore + "</td><td>" + object.data.singleExamClassYsScores[j].secsMinScore + "</td></tr></table>"
  102. ;
  103. }
  104. }
  105. classText += "<br><br>"
  106. + "单科分数年级排名:" + object.data.multiExamStudentScore.singleExamStudentScores[i].essGradeOrder + "<br>"
  107. + "单科年级参考人数:" + object.data.multiExam.singleExams[seIdDic[i]].seStudentCount + "<br>"
  108. + "单科年级其他数据:"
  109. + '<table class="table table-responsive" style="table-layout: fixed;"><tr><td>平均分</td><td>最高分</td><td>四分位数(75%)</td><td>中位数</td><td>四分位数(25%)</td><td>最低分</td></tr>'
  110. + "<tr><td>" + object.data.multiExam.singleExams[seIdDic[i]].seAvgScore + "</td><td>" + object.data.multiExam.singleExams[seIdDic[i]].seMaxScore + "</td><td>" + object.data.multiExam.singleExams[seIdDic[i]].se3QuarterScore + "</td><td>" + object.data.multiExam.singleExams[seIdDic[i]].seHalfScore + "</td><td>" + object.data.multiExam.singleExams[seIdDic[i]].seQuarterScore + "</td><td>" + object.data.multiExam.singleExams[seIdDic[i]].seMinScore + "</td></tr></table><br><br>"
  111. ;
  112. }
  113. function sheetOutput(title, dict) {
  114. gradingText += "<h4>" + title + "</h4>"
  115. gradingText += '<table class="table table-responsive" style="table-layout: fixed;"><tr>';
  116. if (dict != ysClassOrder) {
  117. for (var i in dict) {
  118. gradingText += "<td>" + seNameDic[i].substr(0, 2) + "</td>";
  119. }
  120. }
  121. else {
  122. for (var i in dict) {
  123. gradingText += "<td>" + seNameDic[i] + "</td>";
  124. }
  125. }
  126. gradingText += "</tr><tr>"
  127. for (var i in dict) {
  128. gradingText += "<td>" + dict[i] + "</td>";
  129. }
  130. gradingText += "</tr></table><br><br>";
  131. }
  132. sheetOutput("各科得分比例一览表", scoreRate);
  133. sheetOutput("各科班级排名一览表", classOrder);
  134. sheetOutput("各科分层班级排名一览表", ysClassOrder);
  135. sheetOutput("各科年级排名一览表", gradeOrder);
  136. output.innerHTML = "<br>注:实验中学74桌出品,我抄的速来谴责我<br><br>"
  137. + "行政班级:" + object.data.examStudents[0].classId + "<br>"
  138. + "姓名:" + object.data.multiExamStudentScore.studentName + "<br>"
  139. + "<br><h4>总分</h4>"
  140. + "全科分数:" + object.data.multiExamStudentScore.messScore + "<br><br>"
  141. + "全科分数班级排名:" + object.data.multiExamStudentScore.messClassOrder + "<br>"
  142. + "全科班级参考人数:" + object.data.multiExamClassScores[0].mecsStudentCount + "<br>"
  143. + "全科班级年级排名:" + object.data.multiExamClassScores[0].mecsClassOrder + "<br>"
  144. + "全科班级其他数据:"
  145. + '<table class="table table-responsive" style="table-layout: fixed;"><tr><td>平均分</td><td>最高分</td><td>四分位数(75%)</td><td>中位数</td><td>四分位数(25%)</td><td>最低分</td></tr>'
  146. + "<tr><td>" + object.data.multiExamClassScores[0].mecsAvgScore + "</td><td>" + object.data.multiExamClassScores[0].mecsMaxScore + "</td><td>" + object.data.multiExamClassScores[0].mecs3quatrerScore + "</td><td>" + object.data.multiExamClassScores[0].mecsHalfScore + "</td><td>" + object.data.multiExamClassScores[0].mecsQuarterScore + "</td><td>" + object.data.multiExamClassScores[0].mecsMinScore + "</td></tr></table>"
  147. + "<br><br>全科分数年级排名:" + object.data.multiExamStudentScore.messGradeOrder + "<br>"
  148. + "全科年级参考人数:" + object.data.multiExamSchoolScore.mecsStudentCount + "<br>"
  149. + "全科年级其他数据:"
  150. + '<table class="table table-responsive" style="table-layout: fixed;"><tr><td>平均分</td><td>最高分</td><td>四分位数(75%)</td><td>中位数</td><td>四分位数(25%)</td><td>最低分</td></tr>'
  151. + "<tr><td>" + object.data.multiExam.meAvgScore + "</td><td>" + object.data.multiExam.meMaxScore + "</td><td>" + object.data.multiExam.me3QuatrerScore + "</td><td>" + object.data.multiExam.meHalfScore + "</td><td>" + object.data.multiExam.meQuarterScore + "</td><td>" + object.data.multiExam.meMinScore + "</td></tr></table><br><br>"
  152. + classText
  153. + gradingText;
  154. /* 分班考成绩 */
  155. output.innerHTML += "<br>分班考年级排名:" + object.data.studentMEHistoryScoreVOs[0].gradeOrder;
  156. $("#fileOutput table").css("display", "inline-table");
  157. $("#fileOutput table").css("margin-bottom", "0px");
  158. };
  159. reader.readAsText(file);
  160. }
  161. </script>
  162. </head>
  163. <body>
  164. <div style="text-align: center;">
  165. <a tabindex="0" class="btn btn-default" onclick="document.getElementById('fileInput').click();"
  166. style="text-shadow: rgb(155, 155, 155) 3px 2px 4px;display:inline-block;">
  167. <span class="glyphicon glyphicon-open" aria-hidden="true"></span> <b>打开文件</b><input style="display: none;"
  168. id="fileInput" type="file" onchange="processFiles(event)">
  169. </a>
  170. </div>
  171. <div id="message"></div>
  172. <div id="fileOutput"></div>
  173. </body>