samien
/
lr_chengji


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300
							<!--
 * @Author: yancheng
 * @Date: 2023-09-18 09:40:05
 * @LastEditors: yancheng
 * @LastEditTime: 2023-10-24 14:56:51
-->
<!DOCTYPE html>
<html>

<head>
    <meta charset="utf-8">
    <title>
        成绩查看
    </title>
</head>
<link href="css/index.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" href="css/jquery-ui-1.9.2.custom.css" type="text/css">
<script src="js/jq2.1.4.js"></script>
<script src="js/xlsx.js"></script>
<script src="js/export.js"></script>
<script src="js/selected.js"></script>


<script src="js/jquery-ui-1.9.2.custom.js" type="text/javascript" language="javascript"></script>
<script src="js/share.js" type="text/javascript"></script>

<body>


    <!-- <div id="dropArea">
        <p class="drop-text">拖拽文件到此区域进行上传</p>
        <input type="file" id="fileInput">
     </div> -->

    <div id="content">
        <h2>文件拖入此处解析</h2>

        <input type="file" id="fileUpload">

        <button id="printButton">打印成绩单</button>
        <button id="export">导出成绩</button>

        <label for="myFileInput">

            <input type="file" id="myFileInput" webkitdirectory directory multiple style="display: none;">
            <div class="folder">
                选中文件夹
            </div>
        </label>

        <div class="error-text">遇到异常按键盘F5键 可以刷新重置</div>
    </div>
    <div class="where-div">
        <div class="where-search">
            学号: <input id="id">

            <div>
                <input type="text" id="time" class="ui-datepicker-time" readonly value="" />
                <button class="ui-date-quick-button" style="width: 80px;" type="button"  onclick="cleanDate()">清除时间</button>
                <div class="ui-datepicker-css">
                    <div class="ui-datepicker-quick">
                        <p>快捷日期<a class="ui-close-date">X</a></p>
                        <div>
                            <input class="ui-date-quick-button" type="button" value="今天" alt="0" name="" />
                            <input class="ui-date-quick-button" type="button" value="昨天" alt="-1" name="" />
                            <input class="ui-date-quick-button" type="button" value="7天内" alt="-6" name="" />
                            <input class="ui-date-quick-button" type="button" value="14天内" alt="-13" name="" />
                            <input class="ui-date-quick-button" type="button" value="30天内" alt="-29" name="" />
                            <input class="ui-date-quick-button" type="button" value="60天内" alt="-59" name="" />
                        </div>
                    </div>
                    <div class="ui-datepicker-choose">
                        <p>自选日期</p>
                        <div class="ui-datepicker-date">
                            <input name="startDate" id="startDate" class="startDate" readonly value="2023/11/01"
                                type="text">
                            一
                            <input name="endDate" id="endDate" class="endDate" readonly value="2023/11/30" type="text"
                                disabled onchange="datePickers()">

                        </div>
                    </div>
                </div>
            </div>

            <button class="folder" id="secelt-button">
                过滤数据
            </button>
        </div>
    </div>


    <table class="score-list" id="list">
        <thead>
            <tr id="th">
                <th>学号</th>
                <th>查看病历本</th>
                <th>核对患者信息</th>
                <th>叩诊</th>
                <th>索要胸片</th>
                <th>辅助检查-X光片</th>
                <th>辅助检查-超声检查</th>
                <th>询问过敏史</th>
                <th>解释胸穿目的和注意事项</th>
                <th>签署知情同意书</th>
                <th>术前器械准备</th>
                <th>吸氧</th>
                <th>选择穿刺点</th>
                <th>消毒</th>
                <th>检查胸穿包有效期</th>
                <th>选择麻醉药物</th>
                <th>选择穿戴无菌手套</th>
                <th>洞巾</th>
                <th>进行麻醉</th>
                <th>检查器械</th>
                <th>穿刺点进针</th>
                <th>观察胸液是否凝固</th>
                <th>标本送检</th>
                <th>继续抽液缓解胸腔压迫</th>
                <th>废液处理</th>
                <th>操作完毕告知注意事项</th>
                <th>测血压</th>
                <th>总得分</th>
                <th>创建时间</th>
            </tr>
        </thead>
        <tbody id="dataContainer">
            <tr>
                <td>请上传文件</td>
                <td>请上传文件</td>
                <td>请上传文件</td>
                <td>请上传文件</td>
                <td>请上传文件</td>
                <td>请上传文件</td>
                <td>请上传文件</td>
                <td>请上传文件</td>
                <td>请上传文件</td>
                <td>请上传文件</td>
                <td>请上传文件</td>
                <td>请上传文件</td>
                <td>请上传文件</td>
                <td>请上传文件</td>
                <td>请上传文件</td>
                <td>请上传文件</td>
                <td>请上传文件</td>
                <td>请上传文件</td>
                <td>请上传文件</td>
                <td>请上传文件</td>
                <td>请上传文件</td>
                <td>请上传文件</td>
                <td>请上传文件</td>
                <td>请上传文件</td>
                <td>请上传文件</td>
                <td>请上传文件</td>
                <td>请上传文件</td>
                <td>请上传文件</td>
                <td>请上传文件</td>

            </tr>
        </tbody>
    </table>
</body>

</html>

<script>
    document.getElementById('fileUpload').addEventListener('change', function (event) {
        var file = event.target.files[0];
        var reader = new FileReader();
        reader.onload = function (event) {
            var jsonData = JSON.parse(event.target.result);
            updateData(jsonData);
        };
        reader.readAsText(file);
    });

    let content = document.getElementById("content");
    content.addEventListener("dragover", handleDragOver, false);
    content.addEventListener("drop", handleFileSelect, false);
    const dropArea = document.getElementById('content');
    // 添加拖拽区域的事件监听器
    dropArea.addEventListener('dragover', handleDragOver);
    dropArea.addEventListener('dragleave', handleDragLeave);


    document.getElementById('printButton').addEventListener('click', function () {
        var yc = document.getElementById("content");
        yc.style.display = "none";
        window.print();
        yc.style.display = "block";
        // window.location.reload(); //刷新页面，可写可不写
        // document.body.innerHTML = older; //将网页还原
        return false;
    });

    //导出excel表格,js逻辑写在js/export.js 里面 
    document.getElementById('export').addEventListener('click', function () {
        // console.log(achievement)
        var table1 = document.querySelector("#list");
        var sheet = XLSX.utils.table_to_sheet(table1);//将一个table对象转换成一个sheet对象
        openDownloadDialog(sheet2blob(sheet), '导出.xlsx');
    });


    var input = document.getElementById('myFileInput');
    input.addEventListener('change', function (event) {
        var dataLists = [];
        var input = document.getElementById('myFileInput');
        var files = input.files;
        for (var i = 0; i < files.length; i++) {
            // console.log('文件名：', files[i].name);  
            // console.log('文件大小：', files[i].size);  
            // console.log('文件类型：', files[i].type);  
            if (files[i].type == 'application/json') {
                var reader1 = new FileReader();
                reader1.onload = function (e) {
                    let jsonData = JSON.parse(e.target.result);
                    jsonData.forEach(e => {
                        dataLists.push(e);
                    });
                };
                reader1.readAsText(files[i]);
            }
        }
        //延时加载数据出来 等待上传完毕
        setTimeout(() => {
            updateData(dataLists);
        }, 50);
    });


    //开始过滤对应数据,js逻辑写在js/export.js 里面 
    document.getElementById('secelt-button').addEventListener('click', function () {
        handSelect();
    });


    const arr = [
        {
            "score": 10.0,
            "number": "abbbr",
            "time": "2023年11月20日21时54分41秒",
            "stamp": "1700732536",
            "isExam": false
        },
        {
            "score": 10.0,
            "number": "ahhj",
            "time": "2023年11月20日21时54分41秒",
            "stamp": "1700732536",
            "isExam": false
        },
        {
            "score": 10.0,
            "number": "cccj",
            "time": "2023年10月20日21时54分41秒",
            "stamp": "1698054136",
            "isExam": false
        },
        {
            "score": 10.0,
            "number": "aaacccja",
            "time": "2023年10月10日21时54分41秒",
            "stamp": "1698054136",
            "isExam": false
        }
    ];


    const conditions = ['a'];
    // const timeConditions = ['2023年11月', '2023年1月'];
    const dateStr = "2023-10-10 21:54:41";
    const dateObj = new Date(dateStr); // 创建一个 Date 对象  
    const timestamp = dateObj.getTime() / 1000; // 转换为秒  
    console.log(timestamp);

    const time1 = '1700732530';
    const time2 = '1800732536';
    // 转换为 Date 对象  

    const filteredArr = arr.filter(item => {
        let hasNameCondition = conditions.some(condition => item.number.includes(condition));
        const time = item.stamp;
        let hasTimeCondition = time >= time1 && time <= time2;
        return hasNameCondition && hasTimeCondition;
    });
    console.log(filteredArr, new Date(2023 - 10 - 10))
</script>