☰

Automatic retroactive

try to take over the world!

// ==UserScript==
// @name         Automatic retroactive
// @namespace    http://tampermonkey.net/
// @version      2.2
// @description  try to take over the world!
// @author       xiaowei
// @match        *https://class.bigdata.ncvt.net*
// @icon         data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==
// @license     
// @grant        none
// @require       https://code.jquery.com/jquery-3.6.0.min.js
// @require       https://cdn.bootcss.com/xlsx/0.11.5/xlsx.core.min.js
// ==/UserScript==

(function() {
    'use strict';
    let xx = $("body");
    xx.append(`<input type="file" id="xiaowei"/>`);
    $("#xiaowei").css({position:"absolute",top:"10px",right:"203px"})
    xx.append(`<button id="zdbq">自动补签</button>`)
    $("#zdbq").css({position:"absolute",top:"10px",right:"209px"})
    $("#zdbq").click(()=>{
        let iframe = document.getElementById('I2').contentWindow;
        let main = iframe.document.querySelector("tbody")
        let trs = $(main).children();
        trs.each(function (){
            let doc1 = $(this).children().eq(1)
            let personId = $(this).children().eq(1).html();
            $.each(date,function (i,v){
               if(Number(v) == personId){
                    if(!doc1.prev().children().eq(0).is(":checked")){
                        doc1.prev().children().eq(0).click()
                    }
                }else {
                    console.log(false);
                }
            })
        })
    })
    function readWorkbookFromLocalFile(file, callback) {
        var reader = new FileReader();
        reader.onload = function(e) {
            var data = e.target.result;
            var workbook = XLSX.read(data, {type: 'binary'});
            console.log(workbook)
            if(callback) callback(workbook);
        };
        reader.readAsBinaryString(file);
    }
    let date = [];
    $("#xiaowei").change(function (e){
        let file = e.target.files;
        console.log(file[0])
        readWorkbookFromLocalFile(file[0],function (k){
            let listName = k.SheetNames[0]
            console.log(listName)
            $.each(k.Sheets[listName],function (){
                let xx = $(this)[0];
                if(xx){
                   date.push(xx.v);
                }

            })
        })
    })

})();