// ==UserScript==
// @name         金智教育教务成绩导出和加权平均学分计算（如南大、南师大、复旦）
// @namespace    hb123
// @version      0.2
// @description  导出全部成绩，金智教育教务可能可以，如复旦、南大、南师大
// @author       何碧
// @match        *://*.edu.cn/*
// @require      https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.18.5/xlsx.core.min.js
// @grant        GM_addStyle
// @grant        GM_getValue
// @grant        GM_listValues
// @grant        GM_setValue
// @grant        GM_addValueChangeListener
// ==/UserScript==

/* ==UserConfig== 
configure:
    terms:
        title: 选择查询哪些学期
        type: mult-select
        description: 选择查询的学期有哪些
        bind: $terms
    all:
        title: 查询所有
        type: checkbox
        description: 选中即查询所有学期
        default: false
    mode:
        title: 模式
        description: 计算 or 导出
        type: select
        default: "导出为xlsx"
        values: ["计算","导出为xlsx"]    
    exclude:
        title: 筛选关键词（用，或者, 分割）
        type:  text
        description: 计算过程中需要排除的关键词
    include:
        title: 包含的关键词（用，或者, 分割）
        type: text
        description: 计算过程中需要包含的关键词，只要含有其中的关键词，一定不会被过滤
==/UserConfig== */


// setInterval(() => {
//     console.log(GM_listValues())
//     console.log(GM_getValue("configure.terms"), GM_getValue("configure.all"), GM_getValue("terms"))
// }, 2000);
(function () {
    'use strict';
    let now = new Date().getFullYear()

    let terms = [];
    for (let index = 0; index < 4; index++) {
        terms.push(`${now - index}-${now - index + 1}-1`, `${now - index}-${now - index + 1}-2`)
    }
    GM_setValue("terms", terms)
    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" style:"margin-right:5px"></span>
    `;
        let btn = document.createElement("button");
        btn.textContent = GM_getValue("configure.mode");
        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 = () => {
            if (GM_getValue("configure.all") && GM_getValue("configure.mode", "") == "导出为xlsx") {
                console.log("[何碧]正在导出......", XLSX);
                getAllCourses().then(courses => {
                    exportXlsx(courses)
                })
            } else if (!GM_getValue("configure.all") && GM_getValue("configure.mode", "") == "计算") {
                let terms = GM_getValue("configure.terms", [])
                getCourses(terms).then(courses => {
                    let average = calulate(courses)
                    document.getElementById("average-credit").textContent = `${average.toFixed(2)}分, GPA:${(((average) / 100) * 4).toFixed(3)}`
                })
            } else if (GM_getValue("configure.all") && GM_getValue("configure.mode", "") == "计算") {
                getAllCourses().then(courses => {
                    let average = calulate(courses).toFixed(2);
                    document.getElementById("average-credit").textContent = `${average}分, GPA:${(((average) / 100) * 4).toFixed(3)}`;
                })
            } else {
                let terms = GM_getValue("configure.terms", [])
                getCourses(terms).then(courses => {
                    exportXlsx(courses)
                })
            }
        }
        box.appendChild(btn);
        GM_addValueChangeListener("configure.mode", () => {
            document.getElementById("jw-export").textContent = GM_getValue("configure.mode", "计算")
        })
    }, 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(terms) {
    let querySetting = [{ "name": "XNXQDM", "value": terms.join(","), "linkOpt": "and", "builder": "m_value_equal" }, { "name": "SFYX", "caption": "是否有效", "linkOpt": "AND", "builderList": "cbl_m_List", "builder": "m_value_equal", "value": "1", "value_display": "是" }]
    let form = `querySetting=${JSON.stringify(querySetting)}&*order=${encodeURIComponent("KCH,KXH")}&pageSize: 10&pageNumber: 1`
    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": form,
        "method": "POST",
        "mode": "cors",
        "credentials": "include"
    }).then(response => response.json()).then(result => { return result.datas.xscjcx.rows })
}

function getAllCourses() {
    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 })
}


const exportXlsx = (courses) => {
    const wb = XLSX.utils.book_new();
    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");
}

function calulate(courses) {
    courses = CoursesFilter(courses)
    let res = courses.reduce((prev, curr) => {
        prev.credits += parseInt(curr.XF)
        prev.total += parseFloat(curr.ZCJ * curr.XF)
        return prev;
    }, { credits: 0, total: 0 })
    console.log(`平均学分:${res.total / res.credits}`)
    return res.total / res.credits
}

function CoursesFilter(courses) {
    let inclueStr = GM_getValue("configure.include", "")
    let includes = inclueStr.split(/[,，]/g)
    let exclueStr = GM_getValue("configure.exclude", "")
    let excludes = exclueStr.split(/[,，]/g)
    console.log("包含", includes, "排除", excludes)
    return courses.filter(course => {
        let str = JSON.stringify(course);

        includes.forEach(v => {
            if (str.indexOf(v) == -1) {
                console.log(`过滤了${course.KCM}`)
                return false
            } else {
                return true
            }
        })
        excludes.forEach(v => {
            if (str.indexOf(v) != -1) {
                console.log(`过滤了${course.KCM}`)
                return false
            }
        })
        return true
    })
}