<%--
|
Created by IntelliJ IDEA.
|
User: Lenovo
|
Date: 2024/10/10
|
Time: 14:05
|
To change this template use File | Settings | File Templates.
|
--%>
|
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
|
<html>
|
<head>
|
<title>Title</title>
|
<link rel="stylesheet" href="../../CSS/layui2.css">
|
<link rel="stylesheet" href="../../CSS/layer.css">
|
</head>
|
<body>
|
<div class="layui-container" style="width: 100%;height: 100%;margin: 0px;padding: 0px">
|
<div class="layui-row">
|
<div class="layui-col-xs12 layui-col-md12">
|
<table class="layui-hide" id="XunJian" lay-even="XunJian" lay-filter="XunJian" style="height: 100%"></table>
|
</div>
|
</div>
|
</div>
|
</body>
|
<script type="text/html" id="toolbarDemo">
|
<div>
|
<%-- <button class="layui-btn layui-btn-normal" id="btnAdd" style="" lay-event="getadd">新增</button>--%>
|
<%-- <button class="layui-btn layui-btn-warm" id="btnUpdate" style="" onclick="update()" lay-event="getUpdate">修改</button>--%>
|
<%-- <button class="layui-btn layui-btn-danger" id="btnDelete" style="" lay-event="getdelete">删除</button>--%>
|
<button class="layui-btn layui-btn-primary" id="btnShuaXin" style="" lay-event="getshuaxin">刷新</button>
|
<input type="text" class="layui-input" id="seah" placeholder="请输入设备编号 \ 区域名称" style="display: inline-block;width: 250px;height:38px;border-right: none;border-top-right-radius: 0px;border-bottom-right-radius: 0px;position: relative;top: 0.1vh;margin-left: 5%">
|
<button class="layui-btn layui-btn-normal" id="btnSerach" lay-event="getsearch" style="border-bottom-right-radius: 8px;border-top-right-radius: 8px;position: relative;top: 0vh;left: -0.5%;">搜索</button>
|
</div>
|
</script>
|
<script src="../../JS/layui.js"></script>
|
<script src="../../JS/layer.js"></script>
|
<script src="/hxzkuwb/HouTai/Js/jquery-3.5.1.js"></script>
|
<script src="../../languages/languages.js"></script>
|
<script>
|
window.addEventListener('load', function() {
|
$.ajaxSetup({
|
headers: {
|
'x-access-token': localStorage.getItem("hxzkmars3d")
|
}
|
});
|
|
})
|
|
layui.use(['table', 'jquery'], function(){
|
var table = layui.table;
|
var layer = layui.layer;
|
var form = layui.form;
|
var $ = layui.jquery;
|
$.ajaxSetup({
|
headers: {
|
'x-access-token': localStorage.getItem("hxzkmars3d")
|
}
|
});
|
|
table.render({
|
elem: '#XunJian'
|
, url: '/hxzkuwb/findXunJian'
|
, size: 'sm'
|
, page:true
|
,totalRow:true
|
, toolbar: '#toolbarDemo'
|
, cols: [[ //表头
|
{type: 'checkbox', sort: true, fixed: "left", width: 80}
|
, {field: 'id', title: 'ID', sort: true}
|
, {field: 'name', title: '名称'}
|
, {field: 'tagid', title: '设备编号'}
|
, {field: 'quyu', title: '区域名称'}
|
, {field: 'bianhao', title: '编号'}
|
, {field: 'intime', title: '进入时间'}
|
, {field: 'outtime', title: '出去时间'}
|
, {field: 'alltime', title: '停留时间', totalRow: true}
|
, {field: 'addtime', title: '更新时间'}
|
]]
|
,done: function (res, curr, count) {
|
// 自定义合计行的显示格式
|
var alltimeTotal = 0;
|
|
// 获取当前页的数据，累加 alltime 列的值
|
res.data.forEach(function(item){
|
|
alltimeTotal =parseInt(alltimeTotal)+parseInt(item.alltime); // 确保alltime字段存在
|
});
|
|
// 将合计行的 alltime 列格式化为 hh:mm:ss
|
var formattedTime = secondsToDhms(alltimeTotal);
|
console.log(formattedTime)
|
// 找到合计行的 DOM 并修改其内容
|
$('.layui-table-total td[data-field="alltime"]').text(formattedTime);
|
}
|
});
|
|
languages1 = "一次只能选中一个进行修改"
|
languages2 = "请选中一条数据"
|
languages13 = "刷新成功"
|
languages14 = "搜索成功"
|
languages15 = "操作成功"
|
|
|
table.on('toolbar(XunJian)', function (obj) {
|
var checkStatus = table.checkStatus(obj.config.id);
|
var ds = "username="+sessionStorage.getItem("username")
|
var add = "Yes";
|
var udelete = "Yes";
|
var uupdate = "Yes";
|
$.ajax({
|
url: "/hxzkuwb/findUserRole",
|
type: "GET",
|
data:ds,
|
dataType: "json",
|
async: false, // 设置为同步
|
success: function(data) {
|
if (data.uadd == "No") {
|
add = "No";
|
}
|
if (data.udelete == "No") {
|
udelete = "No";
|
}
|
if (data.uupdate == "No") {
|
uupdate = "No";
|
}
|
}
|
});
|
switch(obj.event) {
|
case 'getshuaxin':
|
layer.msg(languages13)
|
setTimeout(function (){
|
location.reload();
|
},500)
|
break;
|
case 'getsearch':
|
var seah = $("#seah").val();
|
var whereParams = {
|
tagid: seah
|
};
|
table.reload('XunJian', {
|
url: "/hxzkuwb/findXunJianSearch",
|
method:'get',
|
page: {
|
curr: 1 // 重新从第 1 页开始
|
}
|
,where: whereParams
|
});
|
layer.msg('搜索成功')
|
$("#seah").val(seah)
|
break
|
}
|
|
})
|
|
$.post("/hxzkuwb/XunJianFindFence",function (data){
|
for (let i=0; i <data.length;i++){
|
$("#ad2").append('<option value="'+data[i].name+'">'+data[i].name+'</option>')
|
}
|
form.render('select');
|
})
|
});
|
|
function secondsToDhms(seconds) {
|
const days = Math.floor(seconds / (3600 * 24));
|
seconds %= (3600 * 24);
|
const hours = Math.floor(seconds / 3600);
|
seconds %= 3600;
|
const minutes = Math.floor(seconds / 60);
|
const remainingSeconds = seconds % 60;
|
|
return days+'天'+hours+"小时"+minutes+"分钟"+remainingSeconds+"秒"
|
}
|
</script>
|
</html>
|
