<%--
|
Created by IntelliJ IDEA.
|
User: Dell
|
Date: 2023/11/23
|
Time: 14:33
|
To change this template use File | Settings | File Templates.
|
--%>
|
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
|
<html>
|
<head>
|
<link rel="stylesheet" href="../../CSS/layui.css">
|
<link rel="stylesheet" href="../../CSS/layer.css">
|
<title>Title</title>
|
<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.18.2/xlsx.full.min.js"></script>
|
<script src="https://cdnjs.cloudflare.com/ajax/libs/FileSaver.js/2.0.5/FileSaver.min.js"></script>
|
</head>
|
<body>
|
<div class="layui-container" style="width: 100%;margin: 0px;padding: 0px">
|
<div class="layui-row">
|
<div class="layui-col-xs12 layui-col-md12">
|
<table class="layui-hide" id="lishikaoqin" lay-filter="lishikaoqin"></table>
|
</div>
|
</div>
|
</div>
|
<input type="text" class="layui-input" id="seah" placeholder="输入编号 / 姓名" style="width: 270px;height: 38px;margin-left: 100px;position: absolute;border: 1px solid #cccccc;z-index: 999;left: 50px;top: 40px;">
|
<div class="layui-form">
|
<div class="layui-inline" style="position: absolute;top: 40px;left: 460px;z-index: 99999">
|
<div class="layui-input-inline">
|
<div class="layui-form-item">
|
<div class="layui-inline"> <label class="layui-form-label">日期范围</label>
|
<div class="layui-inline" id="test6">
|
<div class="layui-input-inline">
|
<input type="text" autocomplete="off" id="test-startDate-1" class="layui-input" placeholder="开始日期">
|
</div>
|
<div class="layui-form-mid">
|
-
|
</div>
|
<div class="layui-input-inline">
|
<input type="text" autocomplete="off" id="test-endDate-1" class="layui-input" placeholder="结束日期">
|
</div>
|
</div>
|
</div>
|
</div>
|
</div>
|
</div>
|
</div>
|
</body>
|
<script type="text/html" id="toolbarDemo">
|
<div class="layui-btn-container" style="margin-left: 0px;margin-top: 20px;display: inline-block">
|
<button class="layui-btn layui-btn-primary" lay-event="getshuaxin">刷新</button>
|
<button class="layui-btn layui-btn-normal" lay-event="getsearch" style="margin-left: 1000px;position: absolute;border-radius: 4px;z-index: 9999;left: 70px;top: 29px">搜索</button>
|
<button class="layui-btn layui-btn-normal" id="btnUpdate" style="margin-left: 1100px;position: absolute;border-radius: 4px;z-index: 9999;left: 70px;top: 29px" onclick="exportTableToXLSX('考勤数据')">导出数据</button>
|
</div>
|
</script>
|
<script type="text/html" id="barDemotag">
|
<a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del">删除</a>
|
</script>
|
<script src="/hxzkuwb/HouTai/Js/jquery-3.5.1.js"></script>
|
|
<script src="../../JS/layui.js"></script>
|
<script src="../../JS/layer.js"></script>
|
<script src="LiShiKaoQinJs/LiShiKaoQin.js"></script>
|
<script src="../Role/Role1.js"></script>
|
<script>
|
layui.use('laydate', function() {
|
var laydate = layui.laydate;
|
|
//自定义颜色
|
//日期范围
|
laydate.render({
|
elem: '#test6'
|
,type:'datetime'
|
//设置开始日期、日期日期的 input 选择器
|
//数组格式为 2.6.6 开始新增，之前版本直接配置 true 或任意分割字符即可
|
,range: ['#test-startDate-1', '#test-endDate-1']
|
});
|
})
|
setInterval(function (){
|
var time1 = $("#test-startDate-1").val();
|
var time2 = $("#test-endDate-1").val();
|
|
|
|
let today = new Date();
|
let year = today.getFullYear();
|
let month = (today.getMonth() + 1).toString().padStart(2, '0'); // 注意月份要加 1，且补零
|
let day = today.getDate().toString().padStart(2, '0'); // 注意日期补零
|
let hours = today.getHours().toString().padStart(2, '0');
|
let minutes = today.getMinutes().toString().padStart(2, '0');
|
let seconds = today.getSeconds().toString().padStart(2, '0');
|
let formattedDate = year + '-' + month + '-' + day+" "+hours+":"+minutes+":"+seconds;
|
|
|
// 转换为日期对象
|
let date1 = new Date(time2);
|
let date2 = new Date(formattedDate);
|
// 比较日期大小
|
if (date1> date2) {
|
$("#test-endDate-1").val(formattedDate);
|
layer.msg('当前选择的结束日期晚于今天，已默认设置结束日期为今天')
|
}
|
|
},1000)
|
|
function exportTableToXLSX(filename) {
|
var wb = XLSX.utils.book_new();
|
|
var time1 = $("#test-startDate-1").val();
|
var time2 = $("#test-endDate-1").val();
|
var specifiedTime = " " + time1 + " - " + time2;
|
|
var headerRow = ["序号", "区域", "名称", "部门", "设备ID", "进入时间", "出去时间"];
|
var data = [ [specifiedTime], headerRow ]; // 将指定时间和标题行添加到数据数组中
|
|
var seah = $("#seah").val();
|
var postData = "tagid=" + seah + "&name=" + time1 + "&bumen=" + time2 + "&page=1" + "&limit=10000";
|
|
$.post("/hxzkuwb/findLiShiKaoQinSearch", postData, function(responseData) {
|
for (var i = 0; i < responseData.data.length; i++) {
|
var rowData = [
|
responseData.data[i].id,
|
responseData.data[i].area,
|
responseData.data[i].name,
|
responseData.data[i].bumen,
|
responseData.data[i].tagid,
|
responseData.data[i].intime,
|
responseData.data[i].outtime
|
];
|
data.push(rowData); // 将每行数据添加到数据数组中
|
}
|
|
var ws = XLSX.utils.aoa_to_sheet(data); // 使用完整的数据数组创建工作表
|
|
XLSX.utils.book_append_sheet(wb, ws, "Sheet1");
|
|
var wbout = XLSX.write(wb, { bookType: "xlsx", type: "binary" });
|
function s2ab(s) {
|
var buf = new ArrayBuffer(s.length);
|
var view = new Uint8Array(buf);
|
for (var i = 0; i < s.length; i++) view[i] = s.charCodeAt(i) & 0xff;
|
return buf;
|
}
|
saveAs(new Blob([s2ab(wbout)], { type: "application/octet-stream" }), filename + ".xlsx");
|
});
|
}
|
</script>
|
</html>
|
