kg/target/classes/static/admin/js/statistics.js

$(function() {
    var defaultPage = 0;
    var defaultSize = 10;
    var currentPage = defaultPage;
    var currentSize = defaultSize;
    var tableFirstLoad = true;
    layui.config({
        base: './lib/layui_exts/'
    }).use(["form", "table", 'excel', "laypage", "layer"], function() {
        var table = layui.table;
        var laypage = layui.laypage;
        var layer = layui.layer;
        excel = layui.excel;
        var title = $("#realName");
        var searchTitleKey = "";
        var device_name = $("#device_name")
        var startTime = $("#startTime")
        var endTime = $("#endTime")
            // var searchTitleName = "";
        var searchTitleTime = "";
        var searchTitleTime1 = ""

        function loadAirList(page, size, searchTitle) {
            if (page === null || page === undefined) page = defaultPage;
            if (size === null || size === undefined) size = defaultSize;

            var tableOption = {
                elem: "#faultrecord",
                height: "full-81",
                limit: size,
                cols: [
                    [{
                            field: "device_name",
                            title: "故障件名称",
                            templet: '#typeTpl',
                            align: "center",
                            width: 100,

                        },
                        {
                            field: "aircraft_type",
                            title: "故障信息",
                            templet: '#type',
                            width: 185,
                            align: "left"
                        },


                        // {
                        //     field: "info_sources",
                        //     title: "故障信息来源",
                        //     align: "center"
                        // },
                        {
                            field: "fault_time",
                            title: "故障时间",
                            templet: '#book',
                            width: 200,
                            align: "left"
                        },
                        // {
                        //     field: "diagnosis_method",
                        //     title: "故障判断方法",
                        //     align: "center"
                        // },


                        // {
                        //     field: "faultparts_Renovation_times",
                        //     title: "故障件翻修次数",
                        //     align: "center"
                        // },
                        // {
                        //     field: "repair_method",
                        //     title: "排除方法",
                        //     align: "center"
                        // },


                    ]
                ]
            };
            // var device_name.val() = "发动机"
            if (title.val() === "" || startTime.val() === "" || endTime.val() === "") {
                var url = "api/faultrecord/listpage?page=" + (page + 1) + "&size=" + size;
            } else {
                var url = "api/faultrecord/faultsta?name=" + device_name.val() + "&startTime=" + startTime.val() +
                    "&endTime=" + endTime.val() + "&page=" + (page + 1) + "&size=" + size;
            }
            fetchJSON(url, {}, "get", function(data) {
                if (data.status === 0) {
                    if (tableFirstLoad) {
                        tableFirstLoad = false;
                        laypage.render({
                            curr: page + 1,
                            elem: "pagination",
                            count: data.data.total,
                            layout: ["count", "prev", "page", "next", "limit", "refresh", "skip"],
                            jump: function(obj, first) {
                                if (first) return;
                                currentPage = obj.curr - 1;
                                currentSize = obj.limit;
                                loadAirList(currentPage, currentSize, searchTitleKey);
                            }
                        });
                    }
                    // console.log(data.data.total)
                    tableOption.data = data.data.list;
                    table.render(tableOption);
                    // var total = data.data.total
                    // sessionStorage.setItem("name",total)
                } else {
                    showMsg(data.msg, 2, 2000);
                }
            });
        }


        loadAirList();


        //统计
        $("#sure").on("click", function(e) {
            e.preventDefault();
            tableFirstLoad = true;
            var searchTitleKey = device_name.val().trim();
            var searchTitleTime = startTime.val().trim();
            var searchTitleTime1 = endTime.val().trim();
            if (searchTitleKey === "")
                loadAirList(0, currentSize);
            else
                loadAirList(0, currentSize, searchTitleKey);


        })

        $("#searchArticle").on("click", function(e) {
            e.preventDefault();
            tableFirstLoad = true;
            searchTitleKey = title.val().trim();
            if (searchTitleKey === "")
                loadAirList(0, currentSize);
            else
                loadAirList(0, currentSize, searchTitleKey);
        });


        $("#keyword").on("keyup", function(e) {
            e.preventDefault();
            if (e.keyCode === 13) {
                $("#searchArticle").click();
            }
        });

        // 监听表内工具条
        table.on("tool(faultrecord)", function(obj) {
            var data = obj.data;
            // console.log(data)
            if (obj.event === "edit") {
                console.log(data)
                    // 打开编辑框 进行详细编辑
                x_admin_show(
                    "查看",
                    encodeURI(
                        "../admin/faultrecord-add.html?id=" + data.id + "&War_zone=" + data.war_zone + "&army=" + data.army +
                        "&division=" + data.division + "&brigade=" + data.brigade + "&fault_time=" + data.fault_time +
                        "&Is_history=" + data.is_history + "&Aircraft_type=" + data.aircraft_type + "&Discover_opportunity=" +
                        data.discover_opportunity + "&Up_down=" + data.up_down + "&Discoverer=" + data.discoverer +
                        "&Info_sources=" + data.info_sources + "&fault_content=" + data.fault_content + "&Is_falsealarm=" + data.is_falsealarm +
                        "&Fault_degree=" + data.fault_degree + "&Fault_consequence=" + data.fault_consequence +
                        "&Miss_flight_times=" + data.missflight_times + "&Impact_times=" + data.impact_times + "&Fault_liability=" +
                        data.fault_liability + "&Fault_location=" + data.fault_location + "&major=" + data.major +
                        "&fault_reason=" + data.fault_reason + "&Reviewer=" + data.reviewer + "&review_time=" + data.review_time +
                        "&repair_time=" + data.repair_time + "&repair_hours=" + data.repair_hours + "&repair_personnum=" + data.repair_personnum +
                        "&repaired_time=" + data.repaired_time + "&classification=" + data.classification + "&is_grounded=" + data
                        .is_grounded + "&Reporting_department=" + data.reporting_department + "&device_name=" + data.device_name +
                        "&device_type=" + data.device_type + "&replace_device=" + data.replace_device + "&replace_type=" + data.replace_type +
                        "&Diagnosis_method=" + data.diagnosis_method + "&diagnosis_people=" + data.diagnosis_people +
                        "&faultparts_date=" + data.faultparts_date + "&faultparts_hours=" + data.faultparts_hours +
                        "&faultparts_worktimes=" + data.faultparts_worktimes + "&faultparts_renovation_manu=" + data.faultparts_renovation_manu +
                        "&Faultparts_Renovation_hours=" + data.faultparts_Renovation_hours + "&Faultparts_Renovation_times=" +
                        data.faultparts_Renovation_times + "&repair_method=" + data.repair_method + "&Repair_person=" + data.repair_person +
                        "&replace_device_hours=" + data.replace_device_hours + "&replace_device_repairhours" + data.replace_device_repairhours +
                        "&replace_device_repairtimes=" + data.replace_device_repairtimes + "&replace_device_applytimes=" + data.replace_device_applytimes +
                        "&replace_device_manufacturer=" + data.replace_device_manufacturer + "&Faultparts_system=" + data.faultparts_system +
                        "&Inspector=" + data.inspector + "&Handling_opinions=" + data.handling_opinions + "&remark=" + data.remark

                    ),
                    1300,
                    600,
                    function() {
                        loadAirList(currentPage, currentSize);
                    }
                );
            } else
            if (obj.event === "delete") {
                // console.log(data)
                // 删除
                var ids = [];
                ids.push(data.id);
                layer.confirm("确认要删除吗？", function() {
                    fetchJSON("api/faultrecord/delete", {
                        ids: ids
                    }, "post", function(data) {
                        if (data.status === 0) {
                            showMsg("已删除!", 1, 2000);
                            tableFirstLoad = true;
                            loadAirList(currentPage, currentSize);
                        } else {
                            showMsg(data.msg, 2, 2000);
                        }
                    });
                });
            }
        });

        //表格导入
        $("#tolead").on("click", function(e) {
            e.preventDefault();
            tableFirstLoad = true;
            x_admin_show("导入",
                "../admin/faul-add.html",
                350,
                200,
                function() {
                    loadAirList(currentPage, currentSize);
                });
        });

        //表格导出
        function exportFile(id) {

            //根据传入tableID获取表头
            var headers = layui.$("div[lay-id='faultrecord'] .layui-table-box table").get(0);
            var htrs = Array.from(headers.querySelectorAll('tr'));
            var titles = {};
            for (var j = 0; j < htrs.length; j++) {
                var hths = Array.from(htrs[j].querySelectorAll("th"));
                for (var i = 1; i < hths.length - 1; i++) {

                    //排除居左、具有、隐藏字段
                    //修改:默认字段data-field+i,兼容部分数据表格中不存在data-field值的问题
                    titles['data-field' + i] = hths[i].innerText;
                }
            }

            //根据传入tableID获取table内容
            var bodys = layui.$("div[lay-id='faultrecord'] .layui-table-box table").get(1);
            var btrs = Array.from(bodys.querySelectorAll("tr"))
            var bodysArr = new Array();
            for (var j = 0; j < btrs.length; j++) {
                var contents = {};
                var btds = Array.from(btrs[j].querySelectorAll("td"));
                for (var i = 1; i < btds.length - 1; i++) {
                    for (var key in titles) {
                        //修改:默认字段data-field+i,兼容部分数据表格中不存在data-field值的问题
                        var field = 'data-field' + i;
                        if (field === key) {
                            //根据表头字段获取table内容字段
                            contents[field] = btds[i].innerText;
                        }
                    }
                }
                bodysArr.push(contents)
            }
            //将标题行置顶添加到数组
            bodysArr.unshift(titles);
            //导出excel
            excel.exportExcel({
                sheet1: bodysArr
            }, '故障记录' + new Date().toLocaleString() + '.xlsx', 'xlsx');
        }

        $("#exportLog").on("click", function(e) {
            exportFile("faultrecord");
        });
        // 批量删除
        $("#batchDelete").on("click", function(e) {
            e.preventDefault();
            var checkedData = table.checkStatus("faultrecord").data;
            if (checkedData.length === 0) {
                showMsg("未选择需要删除的日志", 2, 2000);
                return;
            }
            layer.confirm("确认要删除吗？", function() {
                var ids = [];
                for (var i = 0; i < checkedData.length; i++) {
                    ids.push(checkedData[i].id);
                }

                fetchJSON("api/faultrecord/delete", {
                    ids: ids
                }, "post", function(data) {
                    if (data.status === 0) {
                        showMsg("已删除!");
                        tableFirstLoad = true;
                        loadAirList(currentPage, currentSize);
                    } else {
                        showMsg(data.msg, 2, 2000);
                    }
                });
            });
        });
        // 新建用户
        $("#addair").on("click", function(e) {
            e.preventDefault();
            tableFirstLoad = true;
            x_admin_show("添加",
                "../admin/faultrecord-edit.html?id=0&war_zone=&army=&division=&brigade=&fault_time=&is_history=&aircraft_type=&Ddiscover_opportunity=&up_down=&discoverer=&info_sources=&fault_content=&is_falsealarm=&fault_degree=&fault_consequence=&miss_flight_times=&impact_times=&fault_liability=&fault_location=&major=&fault_reason=&reviewer=&review_time=&repair_time=&repair_hours=&repair_personnum=&repaired_time=&classification=&is_grounded=&reporting_department=&device_name=&device_type=&replace_device=&replace_type=&diagnosis_method=&diagnosis_people=&faultparts_date=&faultparts_hours=&faultparts_ worktimes=&faultparts_renovation_manu=&faultparts_Renovation_hours=&faultparts_Renovation_times=&repair_method=&repair_person=&replace_device_hours=&replace_device_repairhours=&replace_device_repairtimes=&replace_device_applytimes=&replace_device_manufacturer=&Faultparts_system=&Inspector=&handling_opinions=&remark=",
                1300,
                500,
                function() {
                    loadAirList(currentPage, currentSize);
                });
        });


    });
});