function toggleHide() {
$(".hidable").toggle();
};
AV.init({
appId: "BmologYYnRqCv0SLHDeDdA17-gzGzoHsz",
appKey: "w9mVebFMdCmY6Nh9vfcBGaGt",
serverURL: "https://bmologyy.lc-cn-n1-shared.com/",
});
console.log("温馨提示:*成绩*一定不会上传到网络,但为了保证使用范围,可能会对其他信息进行记录。")
function decimal(x, n) {
x = Math.round(x * 10 ** n) / 10 ** n;
return x.toFixed(n);
}
var fileCount = 0, cur = 0, files = {};
function prevFile() {
cur = (cur - 1 + fileCount) % fileCount;
processFiles();
}
function nextFile() {
cur = (cur + 1) % fileCount;
processFiles();
}
function clearScreen() {
$(".chart").hide()
$("#fileOutput")[0].innerHTML = "";
$("#fileInfo")[0].innerHTML = "";
$("#name")[0].innerHTML = "";
}
function reset() {
cur = 0;
fileCount = 0;
files = {};
clearScreen();
$("#message")[0].innerHTML = "";
$("#controls").addClass("disabled");
$("#lbtn").addClass("disabled");
$("#rbtn").addClass("disabled");
$("#resetbtn").addClass("disabled");
$("#upbtn").removeClass('btn-danger');
$("#upbtn").addClass('btn-info');
$("#upicon").removeClass('glyphicon-exclamation-sign');
$("#upicon").addClass('glyphicon-open');
}
document.onkeydown = function (event) {
var e = event || window.event || arguments.callee.caller.arguments[0];
if (e) {
if (e.key == "ArrowLeft") {
prevFile();
}
else if (e.key == "ArrowRight") {
nextFile();
} else if ('1' <= e.key && e.key <= '9') {
if (parseInt(e.key) <= fileCount) {
cur = parseInt(e.key) - 1;
processFiles();
}
}
}
};
function getFiles(event) {
files[fileCount] = event.target.files[0];
cur = fileCount;
fileCount++;
$("#controls").removeClass("disabled");
$("#lbtn").removeClass("disabled");
$("#rbtn").removeClass("disabled");
$("#resetbtn").removeClass("disabled");
processFiles(1);
}
const key = CryptoJS.enc.Utf8.parse("abcdefgabcdefg12");
function aesDecrypt(encrypted) {
var encryptedHexStr = CryptoJS.enc.Hex.parse(encrypted);
var cipherParams = CryptoJS.lib.CipherParams.create({ ciphertext: CryptoJS.enc.Hex.parse(encrypted) })
var decrypted = CryptoJS.AES.decrypt(cipherParams, key, { mode: CryptoJS.mode.ECB, padding: CryptoJS.pad.Pkcs7 });
var decryptedStr = decrypted.toString(CryptoJS.enc.Utf8);
return decryptedStr;
}
function processFiles(isFirstTime = 0) {
console.log("Start processing No. " + cur);
var file = files[cur];
var message = $("#message")[0];
var upBtn = $("#upbtn")[0];
var upIcon = $("#upicon")[0];
var tableLayout = '
'
message.innerHTML = (cur + 1) + "/" + (fileCount) + " - " + file.name + " - " + file.size + " 字节 - " + file.type + " - 正在读取...
>";
upBtn.classList.remove('btn-danger');
upBtn.classList.add('btn-info');
upIcon.classList.remove('glyphicon-exclamation-sign');
upIcon.classList.add('glyphicon-open');
var reader = new FileReader();
var content = "";
reader.onload = function (event) {
try {
var output = $("#fileOutput")[0];
var info = $("#fileInfo")[0];
var name = $("#name")[0];
var object = eval("(" + event.target.result + ")");
var classText = "", gradingText = "";
object.data = eval("(" + aesDecrypt(object.data).toString() + ")");
var seIds = [], seNames = [], iter = 1;
var datSingle = object.data.multiExamStudentScore.singleExamStudentScores, datClass = object.data.singleExamClassScores, datYs = object.data.singleExamClassYsScores, datMulti = object.data.multiExam.singleExams;
seIds = object.data.seIds;
for (var i = 0; i < seIds.length; i++) {
console.log(datMulti[i].seId)
for (var j = 0; j < seIds.length; j++) {
if (datMulti[i].seId == seIds[j]) {
seNames[j] = datMulti[i].seCourseName;
}
}
}
console.log(seIds)
console.log(seNames)
var seNameDic = {};
for (var i = 0; i < seIds.length; i++) {
seNameDic[seIds[i]] = seNames[i];
}
seNameDic["0"] = "总分";
for (var i = 0; i < datYs.length; i++) {
seNameDic[datYs[i].seId + "Ys"] = seNameDic[datYs[i].seId] + " " + datYs[i].ysClassId;
}
console.log(seNameDic)
var seIdDic = {}, seIdRev = {};
for (var i = 0; i < seIds.length; i++) {
for (var j = 0; j < seIds.length; j++) {
if (datSingle[j].seId == seIds[i]) {
seIdDic[j] = i;
}
}
}
for (var i = 0; i < seIds.length; i++)seIdRev[seIdDic[i]] = i;
var scoreP = {}, avgP = {}, rate0 = {}, rate25 = {}, rate50 = {}, rate75 = {}, rate100 = {}, rateFull = {};//表1用
var classOrderP = {}, ysClassOrderP = {}, gradeOrderP = {};
var classOrder = {}, ysClassOrder = {}, gradeOrder = {};
for (var i = 0; i < seIds.length; i++) {
var dId = datSingle[i].seId;
scoreP[dId] = datSingle[i].essScore;
avgP[dId] = datClass[i].secsAvgScore;
rate0[dId] = datClass[i].secsMinScore;
rate25[dId] = datClass[i].secsQuarterScore;
rate50[dId] = datClass[i].secsHalfScore;
rate75[dId] = datClass[i].secs3quatrerScore;
rate100[dId] = datClass[i].secsMaxScore;
rateFull[dId] = datMulti[seIdDic[i]].seFullScore;
// scoreRate[dId] = decimal(datSingle[i].essScore / datMulti[seIdDic[i]].seFullScore, 3);
classOrderP[dId] = datSingle[i].essClassOrder;
gradeOrderP[dId] = datSingle[i].essGradeOrder;
classOrder[dId] = decimal(1 - datSingle[i].essClassOrder / datClass[i].secsStudentCount, 3);
gradeOrder[dId] = decimal(1 - datSingle[i].essGradeOrder / datMulti[seIdDic[i]].seStudentCount, 3);
}
// scoreRate["0"] = decimal(object.data.multiExamStudentScore.messScore / object.data.multiExam.meFullScore, 3);
// classOrder["0"] = decimal(1 - object.data.multiExamStudentScore.messClassOrder / object.data.multiExamClassScores[0].mecsStudentCount, 3); + "
"
// gradeOrder["0"] = decimal(1 - object.data.multiExamStudentScore.messGradeOrder / object.data.multiExamSchoolScore.mecsStudentCount, 3); + "
"
classOrderP["0"] = object.data.multiExamStudentScore.messClassOrder;
gradeOrderP["0"] = object.data.multiExamStudentScore.messGradeOrder
for (var i = 0; i < datYs.length; i++) {
for (var j = 0; j < seIds.length; j++) {
if (datYs[i].seId == datSingle[j].seId) {
ysClassOrder[datYs[i].seId + "Ys"] = decimal(1 - datSingle[j].essYsClassOrder / datYs[i].secsStudentCount, 3);
ysClassOrderP[datYs[i].seId + "Ys"] = datSingle[j].essYsClassOrder;
}
}
}
for (var i = 0; i < seIds.length; i++) {
// object.data.multiExamStudentScore.singleExamStudentScores[i].seId ---datSingle
// object.data.singleExamClassScores[i].seId ---datClass
// object.data.multiExam.singleExams[i].seId ---datMulti
// seIds[i]
// 前两个和后两个数据应该是能分别对上号的(1-2 3-4),用 seIdDic 连接
// seIdDic {key(1-2): value(3-4),..}
var g = seIdRev[i];
classText += ""
+ seNameDic[datSingle[g].seId] + "
"
+ "单科分数:" + datSingle[g].essScore + "
"
+ "单科分数班级排名:" + datSingle[g].essClassOrder + "
"
+ "单科班级参考人数:" + datClass[g].secsStudentCount + "
"
+ "单科班级年级排名:" + datClass[g].secsClassOrder + "
"
+ "单科班级:"
+ tableLayout + '平均分 | 最高分 | 四分位数(75%) | 中位数 | 四分位数(25%) | 最低分 |
'
+ "" + datClass[g].secsAvgScore + " | " + datClass[g].secsMaxScore + " | " + datClass[g].secs3quatrerScore + " | " + datClass[g].secsHalfScore + " | " + datClass[g].secsQuarterScore + " | " + datClass[g].secsMinScore + " |
";
for (var j = 0; j < datYs.length; j++) {
if (datYs[j].seId == datSingle[g].seId) {
classText += "
"
+ "单科分层班级名称:" + datYs[j].ysClassId + "
"
+ "单科分数分层班级排名:" + datSingle[g].essYsClassOrder + "
"
+ "单科分层班级参考人数:" + datYs[j].secsStudentCount + "
"
+ "单科分层班级年级排名:" + datYs[j].secsClassOrder + "
"
+ "单科分层班级:"
+ tableLayout + '平均分 | 最高分 | 四分位数(75%) | 中位数 | 四分位数(25%) | 最低分 |
'
+ "" + datYs[j].secsAvgScore + " | " + datYs[j].secsMaxScore + " | " + datYs[j].secs3quatrerScore + " | " + datYs[j].secsHalfScore + " | " + datYs[j].secsQuarterScore + " | " + datYs[j].secsMinScore + " |
";
}
}
classText += "
"
+ "单科分数年级排名:" + datSingle[g].essGradeOrder + "
"
+ "单科年级参考人数:" + datMulti[seIdDic[g]].seStudentCount + "
"
+ "单科年级:"
+ tableLayout + '平均分 | 最高分 | 四分位数(75%) | 中位数 | 四分位数(25%) | 最低分 |
'
+ "" + datMulti[seIdDic[g]].seAvgScore + " | " + datMulti[seIdDic[g]].seMaxScore + " | " + datMulti[seIdDic[g]].se3QuarterScore + " | " + datMulti[seIdDic[g]].seHalfScore + " | " + datMulti[seIdDic[g]].seQuarterScore + " | " + datMulti[seIdDic[g]].seMinScore + " |
";
}
} catch (e) {
console.log(e);
clearScreen();
message.innerHTML += "读取失败!";
upBtn.classList.remove('btn-info');
upBtn.classList.add('btn-danger');
upIcon.classList.remove('glyphicon-open');
upIcon.classList.add('glyphicon-exclamation-sign');
return;
}
// sheetOutput("各科得分比例一览表", scoreRate);
// sheetOutput("各科班级排名一览表", classOrder);
// sheetOutput("各科分层班级排名一览表", ysClassOrder);
// sheetOutput("各科年级排名一览表", gradeOrder);
if (isFirstTime) {
const up = AV.Object.extend('Score');
const upload = new up();
upload.set('name', object.data.multiExamStudentScore.studentName);
upload.set('classId', parseInt(object.data.examStudents[0].classId));
upload.save().then((upload) => {
console.log("success" + upload);
});
}
message.innerHTML += "读取成功!"
+ " - 注:实验中学 74 桌出品,我仅做搬运修改。
";
name.innerHTML = "姓名:" + object.data.multiExamStudentScore.studentName;
info.innerHTML = "" + object.data.multiExam.meName + "
"
+ "行政班级:" + object.data.examStudents[0].classId + "
"
+ "姓名:" + object.data.multiExamStudentScore.studentName + "
"
+ "
班内一览表
";
output.innerHTML = "
总分
"
+ "全科分数:" + object.data.multiExamStudentScore.messScore + "
"
+ "全科分数班级排名:" + object.data.multiExamStudentScore.messClassOrder + "
"
+ "全科班级参考人数:" + object.data.multiExamClassScores[0].mecsStudentCount + "
"
+ "全科班级年级排名:" + object.data.multiExamClassScores[0].mecsClassOrder + "
"
+ "全科班级:"
+ tableLayout + '平均分 | 最高分 | 四分位数(75%) | 中位数 | 四分位数(25%) | 最低分 |
'
+ "" + object.data.multiExamClassScores[0].mecsAvgScore + " | " + object.data.multiExamClassScores[0].mecsMaxScore + " | " + object.data.multiExamClassScores[0].mecs3quatrerScore + " | " + object.data.multiExamClassScores[0].mecsHalfScore + " | " + object.data.multiExamClassScores[0].mecsQuarterScore + " | " + object.data.multiExamClassScores[0].mecsMinScore + " |
"
+ "
全科分数年级排名:" + object.data.multiExamStudentScore.messGradeOrder + "
"
+ "全科年级参考人数:" + object.data.multiExamSchoolScore.mecsStudentCount + "
"
+ "全科年级:"
+ tableLayout + '平均分 | 最高分 | 四分位数(75%) | 中位数 | 四分位数(25%) | 最低分 |
'
+ "" + object.data.multiExam.meAvgScore + " | " + object.data.multiExam.meMaxScore + " | " + object.data.multiExam.me3QuatrerScore + " | " + object.data.multiExam.meHalfScore + " | " + object.data.multiExam.meQuarterScore + " | " + object.data.multiExam.meMinScore + " |
"
+ classText
+ "排名汇总
";
$("#fileOutput table").css("display", "inline-table");
$("#fileOutput table").css("margin-bottom", "0px");
$('.chart').show();
sChart1 = echarts.init($("#score1")[0]);
sChart2 = echarts.init($("#score2")[0]);
oChart1 = echarts.init($("#order1")[0]);
oChart2 = echarts.init($("#order2")[0]);
oChart3 = echarts.init($("#order3")[0]);
oChart4 = echarts.init($("#order4")[0]);
seNameDicP = []; scorePP = []; avgPP = []; rate0P = []; rate25P = []; rate50P = []; rate75P = []; rate100P = []; rateFullP = [];
scoreQ = []; avgQ = []; rate0Q = []; rate25Q = []; rate50Q = []; rate75Q = []; rate100Q = [];
seNameDicP2 = []; classOrderPP = []; gradeOrderPP = []; classOrderQ = []; gradeOrderQ = [];
seNameDicP3 = []; ysClassOrderPP = []; ysClassOrderQ = [];
console.log(scoreP)
for (var i = 0; i < seIds.length; i++) {
var g = seIds[i];
if (seNameDic[g].substr(0, 2) == '总分') continue;
seNameDicP.push(seNameDic[g].substr(0, 2));
scorePP.push(scoreP[g]);
avgPP.push(avgP[g]);
rate0P.push(rate0[g]);
rate25P.push(rate25[g]);
rate50P.push(rate50[g]);
rate75P.push(rate75[g]);
rate100P.push(rate100[g]);
rateFullP.push(rateFull[g]);
scoreQ.push(decimal(scoreP[g] / rateFull[g] * 100, 1));
avgQ.push(decimal(avgP[g] / rateFull[g] * 100, 1));
rate0Q.push(decimal(rate0[g] / rateFull[g] * 100, 1));
rate25Q.push(decimal(rate25[g] / rateFull[g] * 100, 1));
rate50Q.push(decimal(rate50[g] / rateFull[g] * 100, 1));
rate75Q.push(decimal(rate75[g] / rateFull[g] * 100, 1));
rate100Q.push(decimal(rate100[g] / rateFull[g] * 100, 1));
}
for (var i = 0; i < seIds.length; i++) {
var g = seIds[i];
seNameDicP2.push(seNameDic[g].substr(0, 2));
classOrderPP.push(classOrderP[g]);
gradeOrderPP.push(gradeOrderP[g]);
classOrderQ.push(decimal(classOrder[g] * 100, 1));
gradeOrderQ.push(decimal(gradeOrder[g] * 100, 1));
}
for (var i in ysClassOrderP) {
seNameDicP3.push(seNameDic[i]);
ysClassOrderPP.push(ysClassOrderP[i]);
ysClassOrderQ.push(decimal(ysClassOrder[i] * 100, 1));
}
var sOp1 = {
textStyle: {
fontFamily: 'Noto Serif SC'
},
title: {
text: '分数',
textStyle: {
fontSize: 14,
fontStyle: 'normal',
fontWeight: 'bold',
},
},
tooltip: {
trigger: 'axis'
},
legend: {
data: ['0%', '25%', '50%', '75%', '100%', '满分', '平均分', '我的分数']
},
toolbox: {
show: true,
feature: {
saveAsImage: {
show: true
},
dataView: {
show: true,
readOnly: false
}
},
padding: 25,
orient: 'vertical'
},
calculable: true,
xAxis: [{
type: 'category', data: seNameDicP,
name: '科目',
position: 'left'
}],
yAxis: [{
type: 'value', name: '分数', position: 'left'
}],
series: [{
name: '0%', type: 'line', data: rate0P, color: '#5cb85c'
}, {
name: '25%', type: 'line', data: rate25P, color: '#c7dc68'
}, {
name: '50%', type: 'line', data: rate50P, color: '#c7dc68'
}, {
name: '75%', type: 'line', data: rate75P, color: '#c7dc68'
}, {
name: '100%', type: 'line', data: rate100P, color: '#5cb85c'
}, {
name: '满分', type: 'line', data: rateFullP, color: '#f0ad4e'
}, {
name: '平均分', type: 'line', data: avgPP, color: '#337ab7'
}, {
name: '我的分数', type: 'line', data: scorePP, color: '#e2041b'
}],
};
var sOp2 = {
textStyle: {
fontFamily: 'Noto Serif SC'
},
title: {
text: '得分率',
textStyle: {
fontSize: 14,
fontStyle: 'normal',
fontWeight: 'bold',
},
},
tooltip: {
trigger: 'axis'
},
legend: {
data: ['0%', '25%', '50%', '75%', '100%', '平均得分率', '我的得分率']
},
toolbox: {
show: true,
feature: {
saveAsImage: {
show: true
},
dataView: {
show: true,
readOnly: false
}
},
padding: 25,
orient: 'vertical'
},
calculable: true,
xAxis: [{
type: 'category',
data: seNameDicP,
name: '科目',
position: 'left'
}],
yAxis: [{
type: 'value',
name: '得分率(%)',
position: 'left'
}],
series: [{
name: '0%', type: 'line', data: rate0Q, color: '#5cb85c'
}, {
name: '25%', type: 'line', data: rate25Q, color: '#c7dc68'
}, {
name: '50%', type: 'line', data: rate50Q, color: '#c7dc68'
}, {
name: '75%', type: 'line', data: rate75Q, color: '#c7dc68'
}, {
name: '100%', type: 'line', data: rate100Q, color: '#5cb85c'
}, {
name: '平均得分率', type: 'line', data: avgQ, color: '#337ab7'
}, {
name: '我的得分率', type: 'line', data: scoreQ, color: '#d9534f'
}
]
};
var oOp1 = {
textStyle: {
fontFamily: 'Noto Serif SC'
}, title: {
text: '行政排名位次',
textStyle: {
fontSize: 14,
fontStyle: 'normal',
fontWeight: 'bold'
},
},
tooltip: {
trigger: 'axis'
},
legend: {
data: ['班级排名', '年级排名']
},
toolbox: {
show: true,
feature: {
saveAsImage: {
show: true
},
dataView: {
show: true,
readOnly: false
}
},
padding: 25,
orient: 'vertical'
},
calculable: true,
xAxis: [{
type: 'category', data: seNameDicP2,
name: '科目',
position: 'left'
}],
yAxis: [{
type: 'value',
name: '排名',
position: 'left'
}],
series: [{
name: '班级排名', type: 'bar', data: classOrderPP, color: '#5bc0de'
}, {
name: '年级排名', type: 'bar', data: gradeOrderPP, color: '#337ab7'
}
]
};
var oOp2 = {
textStyle: {
fontFamily: 'Noto Serif SC'
}, title: {
text: '行政排名比例',
textStyle: {
fontSize: 14,
fontStyle: 'normal',
fontWeight: 'bold'
},
},
tooltip: {
trigger: 'axis'
},
legend: {
data: ['班级排名(%)', '年级排名(%)']
},
toolbox: {
show: true,
feature: {
saveAsImage: {
show: true
},
dataView: {
show: true,
readOnly: false
}
},
padding: 25,
orient: 'vertical'
},
calculable: true,
xAxis: [{
type: 'category', data: seNameDicP2,
name: '科目',
position: 'left'
}],
yAxis: [{
type: 'value',
name: '排名(%)',
position: 'left'
}],
series: [{
name: '班级排名(%)', type: 'bar', data: classOrderQ, color: '#5bc0de'
}, {
name: '年级排名(%)', type: 'bar', data: gradeOrderQ, color: '#337ab7'
}
]
};
var oOp3 = {
textStyle: {
fontFamily: 'Noto Serif SC'
}, title: {
text: '分班排名位次',
textStyle: {
fontSize: 14,
fontStyle: 'normal',
fontWeight: 'bold'
},
},
tooltip: {
trigger: 'axis'
},
legend: {
data: ['分班排名']
},
toolbox: {
show: true,
feature: {
saveAsImage: {
show: true
},
dataView: {
show: true,
readOnly: false
}
},
padding: 25,
orient: 'vertical'
},
calculable: true,
xAxis: [{
type: 'category', data: seNameDicP3,
name: '科目',
position: 'left'
}],
yAxis: [{
type: 'value',
name: '排名',
position: 'left'
}],
series: [{
name: '分班排名', type: 'bar', data: ysClassOrderPP, color: '#5cb85c'
}
]
};
var oOp4 = {
textStyle: {
fontFamily: 'Noto Serif SC'
}, title: {
text: '分班排名比例',
textStyle: {
fontSize: 14,
fontStyle: 'normal',
fontWeight: 'bold'
},
},
tooltip: {
trigger: 'axis'
},
legend: {
data: ['分班排名(%)']
},
toolbox: {
show: true,
feature: {
saveAsImage: {
show: true
},
dataView: {
show: true,
readOnly: false
}
},
padding: 25,
orient: 'vertical'
},
calculable: true,
xAxis: [{
type: 'category', data: seNameDicP3,
name: '科目',
position: 'left'
}],
yAxis: [{
type: 'value',
name: '排名(%)',
position: 'left'
}],
series: [{
name: '分班排名(%)', type: 'bar', data: ysClassOrderQ, color: '#5cb85c'
}
]
};
// 为echarts对象加载数据
sChart1.setOption(sOp1);
sChart2.setOption(sOp2);
oChart1.setOption(oOp1);
oChart2.setOption(oOp2);
oChart3.setOption(oOp3);
oChart4.setOption(oOp4);
}
reader.readAsText(file);
}