Greasy Fork is available in English.
导出全部成绩，金智教育
// ==UserScript==
// @name 金智教育教务成绩导出
// @namespace hb123
// @version 0.1
// @description 导出全部成绩，金智教育
// @author 何碧
// @match *://*.edu.cn/*
// @require https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.18.5/xlsx.core.min.js
// @grant GM_addStyle
// @license MIT
// ==/UserScript==
(function () {
'use strict';
make_xlsx_lib(XLSX)
waitUtil('ul.jqx-tabs-title-container', function (target) {
let box = document.createElement("div");
box.style = "display:flex;float:right;margin-right:20px;justify-content: center;align-items: center;flex: 1;height: 100%;"
target.appendChild(box);
box.innerHTML = `
<span id="average-credit"></span>
`;
let btn = document.createElement("button");
btn.textContent = "导出为xlsx";
btn.className = "jw-btn";
btn.style = `
outline: none;
border: #ccc 1px solid;
border-radius: 8px;
padding: 2px 8px;
background-color: #1195da;
box-shadow: 0px 0px 1px 0.5px #119ddd;
`;
btn.id = "jw-export";
btn.onclick = () => {
console.log("[何碧]正在导出......", XLSX);
const wb = XLSX.utils.book_new();
getCourses().then(courses => {
let table = [["课程名称", "学年学期", "课序号", "学分", "成绩", "满分", "学时", "修读方式", "修读类型", "重修初修", "课程性质", "考试日期", "开课单位", "是否及格"]]
courses.forEach(course => {
table.push([course.KCM, course.XNXQDM_DISPLAY, course.XSKCH,
parseInt(course.XF),// 学分
course.ZCJ,// 成绩
parseInt(course.DJCJLXDM),// 满分
course.XS, //学时
course.XDFSDM_DISPLAY,//修读方式
course.SFZX_DISPLAY, // 修读类型
course.CXCKDM_DISPLAY,
course.KCLBDM_DISPLAY, // 课程性质
course.XNXQDM_DISPLAY, // 考试日期
course.KKDWDM_DISPLAY, course.SFJG_DISPLAY])
})
const ws = XLSX.utils.aoa_to_sheet(table);
XLSX.utils.book_append_sheet(wb, ws, "所有成绩");
XLSX.writeFile(wb, "所有成绩.xlsx");
})
}
box.appendChild(btn);
}, 5000);
GM_addStyle(`
.jw-btn:hover{
box-shadow: 2px 2px 4px 0.5px #119ddd;
}
`);
})();
function waitUtil(ele, callback, timeout) {
let success = false;
let id = setInterval(function () {
let target = document.querySelector(ele)
if (target != null) {
success = true
clearInterval(id);
callback(target)
}
}, 100)
setTimeout(() => {
if (!success) {
clearInterval(id)
console.log("[何碧]页面超时")
}
}, timeout)
}
function getCourses() {
return fetch("/jwapp/sys/cjcx/modules/cjcx/xscjcx.do", {
"headers": {
"accept": "application/json, text/javascript, */*; q=0.01",
"accept-language": "zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6",
"content-type": "application/x-www-form-urlencoded; charset=UTF-8",
"x-requested-with": "XMLHttpRequest"
},
"referrerPolicy": "strict-origin-when-cross-origin",
"body": "querySetting=%5B%7B%22name%22%3A%22SFYX%22%2C%22caption%22%3A%22%E6%98%AF%E5%90%A6%E6%9C%89%E6%95%88%22%2C%22linkOpt%22%3A%22AND%22%2C%22builderList%22%3A%22cbl_m_List%22%2C%22builder%22%3A%22m_value_equal%22%2C%22value%22%3A%221%22%2C%22value_display%22%3A%22%E6%98%AF%22%7D%2C%7B%22name%22%3A%22SHOWMAXCJ%22%2C%22caption%22%3A%22%E6%98%BE%E7%A4%BA%E6%9C%80%E9%AB%98%E6%88%90%E7%BB%A9%22%2C%22linkOpt%22%3A%22AND%22%2C%22builderList%22%3A%22cbl_String%22%2C%22builder%22%3A%22equal%22%2C%22value%22%3A0%2C%22value_display%22%3A%22%E5%90%A6%22%7D%5D&*order=-XNXQDM%2C-KCH%2C-KXH&pageSize=100&pageNumber=1",
"method": "POST",
"mode": "cors",
"credentials": "include"
}).then(response => response.json()).then(result => { return result.datas.xscjcx.rows })
}