IntelligentRecognition/ah-jjsp-web/bns/js/dutyTask/dutyStatistic.js

let form, layer, table, laydate, user = getUser();
let pageNum = 1, limitSize = 50; // 默认第一页，分页数量为10
layui.use(['form', 'layer', 'table', 'laydate'], function () {
    form = layui.form;
    layer = layui.layer;
    table = layui.table;
    laydate = layui.laydate;
    laydate.render({
        elem: '#createTime', //指定元素  元素选择器
        type: 'date', //选择时间类型 可选值:year(年) month(年月)  date(年月日)  time(时分秒)  datetime(年月日时分秒)
        trigger: 'click',
        max: Date.parse(new Date()),
        format: 'yyyy-MM-dd', //时间格式  常用时间格式:yyyy-MM-dd HH:mm:ss
        btns: ['clear', 'now', 'confirm'], //选择框右下角显示的按钮 清除-现在-确定
        done: function (value, date) { //时间回调
        }
    });
    $('#createTime').val(getNowTime())
    pages(1, 50, 1);
})

function pages(pageNum, pageSize, typeNum) {
    let params = getReqParams(pageNum, pageSize, typeNum);
    $.ajax({
        headers: {
            "encrypt": sm3(JSON.stringify(params))
        },
        url: dataUrl + "proteam/pot/dutyStatistics/getDutyStatisticsList?token=" + token,
        data: params,
        type: 'POST',
        async: false,
        success: function (result) {
            if (result.code === 200) {
                if (result.data) {
                    initTable(result.data, result.limit, result.curr)
                    laypages(result.count, result.curr, result.limit)
                }
            } else if (result.code === 500) {
                layer.alert(result.msg, {icon: 2})
            } else if (result.code === 401) {
                logout(1);
            }
        }, error: function () {
        }
    });
}

function laypages(total, page, limit) {
    layui.use(['laypage'], function () {
        let laypage = layui.laypage;
        laypage.render({
            elem: 'voi-page',
            count: total,
            curr: page,
            limit: limit,
            limits: [30,50,100],
            layout: ['prev', 'page', 'next', 'skip', 'count', 'limit'],
            groups: 5,
            jump: function (obj, first) {
                if (!first) {
                    pageNum = obj.curr, limitSize = obj.limit;
                    pages(obj.curr, obj.limit, null);
                }
            }
        });
    })
}

/*初始化表格*/
function initTable(dataList, limit, page) {
    let loadingMsg = layer.msg("数据加载中,请稍候...", {icon: 16, scrollbar: false, time: 0,});
    tableIns = table.render({
        elem: "#dutyStatisticTable",
        height: "full-120",
        data: dataList,
        limit: limit,
        cols: [
            [
                //表头
                {
                    title: "序号",
                    width: 80,
                    unresize: true,
                    align: "center",
                    templet: function (d) {
                        return (page - 1) * limit + d.LAY_INDEX;
                    }
                },
                {
                    field: "checkUser",
                    title: "值班员",
                    unresize: true,
                    align: "center",
                    sort:true
                },
                {
                    field: "totalTaskNum",
                    title: "巡视任务数",
                    unresize: true,
                    align: "center",
                    sort:true
                },
                {
                    field: "finshTaskNum",
                    title: "已巡视任务数",
                    unresize: true,
                    align: "center",
                    sort:true
                },
                {
                    field: "issueNum",
                    title: "发现问题数",
                    unresize: true,
                    align: "center",
                    sort:true
                },
                {
                    field: "checkTime",
                    title: "巡查总时长（h）",
                    unresize: true,
                    align: "center",
                    sort:true
                },
            ],
        ],
        done: function (res, curr, count) {
            layer.close(loadingMsg);
            table.resize("dutyStatisticTable");
            count || this.elem.next(".layui-table-view").find(".layui-table-header").css("display", "inline-block");
            count || this.elem.next(".layui-table-view").find(".layui-table-box").css("overflow", "auto");
        },
    });
}


// 获取参数
function getReqParams(page, limit, type) {
    let obj = {};
    if (!type) {
        obj = {
            page: page + "",
            limit: limit + "",
            checkUser: $("#checkUser").val(),
            createTime: $("#createTime").val(),
            currentUserId: user.userId + '',
            isSup: user.isSup
        };
    } else {
        obj = {
            page: '1',
            limit: '50',
            checkUser: '',
            createTime: getNowTime(),
            currentUserId: user.userId + '',
            isSup: user.isSup
        };
    }
    return obj;
}

/*导出*/
function exportData() {
    let checkUser = $("#checkUser").val(),
        createTime = $("#createTime").val(),
        currentUserId = user.userId + '',
        isSup = user.isSup;
    let loadingMsg = layer.msg("数据导出中,请稍候...", {icon: 16, scrollbar: false, time: 0,});
    let url = dataUrl + "proteam/pot/dutyStatistics/exportData?checkUser=" + checkUser + "&createTime="
        + createTime + "&currentUserId=" + currentUserId + "&isSup=" + isSup + "&token=" + token;
    let xhr = new XMLHttpRequest();
    xhr.open("get", url, true);
    xhr.responseType = "blob"; // 转换流
    xhr.setRequestHeader("encrypt",
        sm3(JSON.stringify({
            checkUser: checkUser,
            createTime: createTime,
            currentUserId: currentUserId,
            isSup: isSup,
        })));
    xhr.onload = function () {
        layer.close(loadingMsg);
        if (this.status === 200) {
            let blob = this.response;
            var a = document.createElement("a");
            var url = window.URL.createObjectURL(blob);
            a.href = url;
            a.download = "值班统计" + getNowDate() + ".xlsx"; // 文件名
        } else {
            layer.msg("数据发生异常,请稍后重试", {icon: 16, scrollbar: false, time: 2000});
        }
        a.click();
        window.URL.revokeObjectURL(url);
    };
    xhr.send();
}

// 查询/重置
function query() {
    let pattern = new RegExp("[%_<>]");
    if (pattern.test($("#checkUser").val())) {
        $("#checkUser").val('');
        return layer.msg('值班员查询包含特殊字符，请重新输入', {
            icon: 2,
            time: 2000 //2秒关闭（如果不配置，默认是3秒）
        });
    }
    pageNum = 1;
    pages(1, limitSize);
}