MES / IOT · Files

 let action = null;

layui.config({
    base: "/js/",
    version: 1

}).use(['system', "vue"], function () {

    var form = layui.form,
        $ = layui.jquery,
        element = layui.element,
        table = layui.table,
        system = layui.system,
        sysU = new system.u(),
        sendDataWhere = null,
        sendDataDescWhere = null,
        areaName = "configure",
        controllerName = "BaseProject",
        projectKeys = null,

        projectName = "",

        projectCode = "",
        sysEqAllSumObj = null,

        intervalTime = null,

        vueApp = null,

        app = null;

    action = {

    }

    app = {
        data: {

            cols: [[
                { field: "zizeng", width: 80, title: "序号", fixed: "left", type: "numbers" },
                {
                    field: "equipmentName", width: 220, title: "设备"
                },
                {

                    field: "Status", width: 150, title: "ip地址(5min无数据)", templet: function (d) {

                        //if (d.Status == "" || d.Status == null) return "";

                        var bg = "layui-badge-dot layui-bg-green",
                            statusText = "在线";

                        if (d.Status == "Failure" || d.Status == "Error") {

                            statusText = "故障";
                            bg = "layui-badge-dot layui-bg-red";
                        }

                        if (d.seconds > 300 || d.seconds == -1) {

                            statusText = "离线";
                            bg = "layui-badge-dot layui-bg-gray";
                        }
                        return `<span class="${bg}" style=" left: 7px;"></span> <span style="padding-left: 8px;">${statusText}</span`;
                    }
                }
            ]],

            colsFailure: [[
                { field: "zizeng", width: 80, title: "序号", fixed: "left", type: "numbers" },
                { field: "equipmentName", width: 220, title: "设备" },
                { field: "alarmMessage", width: 300, title: "报警信息" },
                { field: "createTime", width: 150, title: "开始时间" },

                { field: "updateTime", width: 150, title: "结束时间" },
                {
                    field: "errorduration", width: 200, title: "故障时间(分)", templet: function (d) {
                        var minutes = Math.floor(d.errorduration / 60); // 获取整数分钟

                        var remainingSeconds = Math.floor(d.errorduration % 60); // 获取剩余的秒数

                        return minutes + "分钟" + remainingSeconds + "秒";
                    }
                },

            ]],

            colsProper: [[

                { field: "index", width: 70, title: "序号", fixed: "left" },
                { field: "EquipmentName", width: 180, title: "设备名称" }
                //{
                //    field: "remark", width: 200, title: "故障时间-总时间(分)",
                //    templet: function (d) {

                //        return `${d.ErrorDuration}--${d.SumDuration}`; // 返回原始字符串
                //    }
                //}

            ]],
            colsOee: [[
                { field: "zizeng", width: 80, title: "序号", fixed: "left", type: "numbers" },
                { field: "EquipmentCode", width: 220, title: "设备编码" },

                { field: "EquipmentName", width: 180, title: "设备名称" },

                { field: "Date", width: 120, title: "时间" },

                { field: "Oee", width: 150, title: "Oee" },
                {
                    field: "remark", width: 200, title: "运行-空闲-故障时间(分钟)",
                    templet: function (d) {
                        var run = d.RunningDuration;
                        if (run == 0) run = 0;
                        var free = d.FreeDuration;
                        if (free == 0) free = 0;
                        var error = d.ErrorDuration;
                        if (error == 0) error = 0;
                        return `${run}--${free}--${error}`; 
                    }
                }

            ]],
            colsMttr: [[
                { field: "zizeng", width: 80, title: "序号", fixed: "left", type: "numbers" },
                { field: "EquipmentCode", width: 220, title: "设备编码" },

                { field: "EquipmentName", width: 180, title: "设备名称" },

                { field: "Date", width: 120, title: "时间" },

                { field: "Mttr", width: 150, title: "Mttr(单位H)" },
                {
                    field: "remark", width: 200, title: "故障时间(H)-故障次数",
                    templet: function (d) {
                        var temp = (d.ErrorDuration / 60).toFixed(2);
                        if (temp == 0) temp = 0;
                        return `${temp}--${d.ErrorCount}`; 
                    }
                }

            ]],

            colsMtbf: [[
                { field: "zizeng", width: 80, title: "序号", fixed: "left", type: "numbers" },
                { field: "EquipmentCode", width: 220, title: "设备编码" },

                { field: "EquipmentName", width: 180, title: "设备名称" },

                { field: "Date", width: 120, title: "时间" },

                { field: "Mtbf", width: 150, title: "Mtbf(单位H)" },
                {
                    field: "remark", width: 200, title: "运行(H)-空闲时间(H)-故障次数",
                    templet: function (d) {
                        var run = (d.RunningDuration / 60).toFixed(2);
                        if (run == 0) run = 0;
                        var free = (d.FreeDuration / 60).toFixed(2);
                        if (free == 0) free = 0;
                        return `${run}--${free}--${d.ErrorCount}`; 
                    }
                }

            ]],

            colsAlarm: [[
                { field: "zizeng", width: 80, title: "序号", fixed: "left", type: "numbers" },
                { field: "equipmentCode", width: 200, title: "设备编号", hide: true, },
                { field: "equipmentName", width: 150, title: "设备名称" },
                {
                    field: "alarmMessage", width: 400, title: "报警信息" ,templet: function (d) {
                        return d.alarmMessage + " " + d.remark;
                    }
                },

                {
                    field: "errorduration", width: 150, title: "报警持续时间", templet: function (d) {
                        return app.methods.convertSecondsToTime(d.errorduration)
                    }
                },
                { field: "createTime", width: 150, title: "创建时间" }
            ]],

            tableIns: null,
            tableElem: "mainList",

            refreshDataTimeEle: document.getElementById('refreshDataTime'),

            echartOpt: {
                eqTuoShanRateEle: document.getElementById("eqTuoShanRate"),
                eqAlarmsNumberEle: document.getElementById("eqAlarmsNumber"),

                eqPowerOnTimeEle: document.getElementById("eqPowerOnTime"),

                tuoShanRatelegendData: "".GetTimeRange("","",6)

            }

        },
        methods: {

            //设备在线状况 表格

            initTable: function (opt) {
                var config = { projectKeys: projectKeys }

                if (opt != undefined) $.extend(config, opt);
                let options = {
                    elem: "#" + app.data.tableElem,

                    url: `/configure/BaseProject/GetEqInfoByProjectKeys`,

                    cols: app.data.cols,
                    height: 'full-400', // 最大高度减去其他容器已占有的高度差
                    where: config,
                    page: false
                }
                app.data.tableIns = sysU.initTable(options);
            },

            //每台设备妥善率 曲线图

            initEchartsTuoShanRate: function (failureTime) {

                let legendDataTemp = failureTime.uniqueFunc("EquipmentName")

                let legendData = []

                window.eqTuoShanRateOpt.xAxis[0].data = app.data.echartOpt.tuoShanRatelegendData
                window.eqTuoShanRateOpt.series = [];

                for (let i = 0; i < legendDataTemp.length; i++) {

                    legendData.push(legendDataTemp[i].EquipmentName)

                    var seriesItem = {

                        name: legendDataTemp[i].EquipmentName,

                        type: 'line',
                        data: []
                    };
                    for (let j = 0; j < app.data.echartOpt.tuoShanRatelegendData.length; j++) {
                        const timeVal = app.data.echartOpt.tuoShanRatelegendData[j];

                        const result = failureTime.GetArrValueRows({ key: 'Date', val: timeVal }, {

                            key: 'EquipmentName', val: seriesItem.name

                        });

                        let data = 0;

                        if (result.length == 1) {

                            data = result[0].Proper.replace("%", "")

                        } else {
                            //console.log(`ProjectOverview 文件 GetArrValueRows 读取到：${result.length}条数据`)

                        }

                        seriesItem.data.push(data);

                    }
                    window.eqTuoShanRateOpt.series.push(seriesItem)
                }

                //新增默认 目标值
                legendData.push("目标值")
                window.eqTuoShanRateOpt.series.push({
                    name: "目标值",
                    symbolSize: 10, //小圆点的大小
                    color: 'red',
                    type: 'line',
                    data: ["99", "99", "99", "99", "99", "99", "99", "99"],
                    lineStyle: {
                        normal: {
                            width: 3,
                            type: 'dashed',
                        },
                    },
                    itemStyle: {
                        normal: {
                            lineStyle: {
                                width: 4, //线条宽度
                            },
                        },
                    },
                });

                window.eqTuoShanRateOpt.legend.data = legendData

                let myChart = echarts.init(app.data.echartOpt.eqTuoShanRateEle)

                myChart.clear()
                myChart.setOption(window.eqTuoShanRateOpt)
            },

            //设备开机时间

            //设备开机时间
            initEchartsPowerOnTime: function (PowerOnTimeData) {

                var opt = "".copyObj2(window.eqPowerOnTimeOpt)

                opt.legend.data = []
                opt.series = [];
                const legendData = [...new Set(PowerOnTimeData.map(x => x.EquipmentName))];
                opt.legend.data = legendData
                const deviceData = PowerOnTimeData.reduce((acc, curr) => {
                    const { EquipmentName, PowerOnTime } = curr;
                    if (!acc[EquipmentName]) {
                        acc[EquipmentName] = {
                            name: EquipmentName,
                            type: 'line',
                            data: []
                        };
                    }
                    acc[EquipmentName].data.push(PowerOnTime);
                    return acc;
                }, {});

                for (const key in deviceData) {
                    opt.series.push(deviceData[key]);
                }
                opt.xAxis[0].data = app.data.echartOpt.tuoShanRatelegendData

                let myChart = echarts.init(app.data.echartOpt.eqPowerOnTimeEle)

                myChart.clear()
                myChart.setOption(opt)
            },

            //故障次数 柱状图

            initEchartsAlarmsNumber: function (failureCount) {             

                var xaxisdata = [];
                var faultFrequency = []
                let totalCount = 0;

                // 计算所有 x.count 的总和 
                failureCount.forEach(x => {
                    totalCount += x.count;
                });
                const relativeCount = []
                failureCount.forEach(x => {
                    let totalCountNum = (x.count / totalCount) * 100
                    relativeCount.push(totalCountNum.toFixed(2))
                    xaxisdata.push(x.equipmentName)
                    faultFrequency.push(x.count)
                })
                if (failureCount.length <= 15) {
                    window.eqAlarmsNumber.dataZoom[0].end = 99
                } else {
                    window.eqAlarmsNumber.dataZoom[0].end = 20
                }
                window.eqAlarmsNumber.xAxis[0].data =[]
                window.eqAlarmsNumber.xAxis[0].data = xaxisdata;
                window.eqAlarmsNumber.series[0].data = faultFrequency;
                window.eqAlarmsNumber.series[1].data = relativeCount;

                let myChart = echarts.init(app.data.echartOpt.eqAlarmsNumberEle)
                myChart.clear()
                myChart.setOption(window.eqAlarmsNumber)

                myChart.off('click');
                myChart.on("click", params => {
                    var equipmentCode = failureCount[params.dataIndex].equipmentCode;
                    var createTime = app.data.echartOpt.tuoShanRatelegendData[0] + " 00:00:01";
                    var updateTime = app.data.echartOpt.tuoShanRatelegendData[app.data.echartOpt.tuoShanRatelegendData.length - 1] + " 23:59:59";
                    var ajaxConfig = {
                        data: {
                            equipmentCode: equipmentCode,
                            createTime: createTime,
                            updateTime: updateTime,
                        },
                        url: `/equipment/DaqEquipmentAlarmRecord/LoadDesc`,
                        type: "post",
                        success: function (result) {
                            if (sysU.successBefore(result)) return false;

                            sysU.openPage({
                                title: `故障详情【${result.Count}条】`,
                                area: ["1100px", "590px"],
                                type: 1,
                                btn: ['关闭'],
                                content: $('#eleAlarm'),
                                successCallBackFn: function () {
                                    let options = {
                                        elem: "#tableAlarm",
                                        cols: app.data.colsAlarm,
                                        height: 'full-110', 
                                        data: result.Result,
                                        page: false,
                                        limit: Number.MAX_VALUE,
                                    }
                                    sysU.initTable(options);
                                }
                            });
                        }
                    };
                    sysU.ajax(ajaxConfig);
                });

            },

            //设备故障超40分钟

            initTableFailure40: function (failureOverFourty) {
                let options = {
                    elem: "#mainAlarms" ,
                    cols: app.data.colsFailure,
                    data: failureOverFourty,
                    height: 'full-400', // 最大高度减去其他容器已占有的高度差
                    page: false
                }
                app.data.tableIns = sysU.initTable(options);
            },

            refreshDataMethod: function () {

                let currenttime = parseInt(app.data.refreshDataTimeEle.innerHTML);
                if (currenttime === 0) {

                    currenttime = vueApp.refreshDataTime;

                    app.methods.getEquipmentDataList();
                    app.methods.getEqEchartsDataList();
                } else {
                    currenttime--;
                }
                app.data.refreshDataTimeEle.innerHTML = currenttime;
            },

            /**
              * 初始化vue
              */
            initVue: function () {
                vueApp = new Vue({
                    el: '.vueApp',
                    data: {

                        refreshDataTime: 40,

                        head: {
                            projectName: 0

                        },
                        body: {
                            eqCount: 0,

                            eqRunCount: 0,

                            eqStandBy: 0,

                            eqOffline: 0,

                            eqError: 0,

                            eqOnlineRate: 0,

                        },

                        eqSumObj: {
                            oee: 0,
                            mttr: 0,
                            mtbf: 0,
                            proper:0
                        }

                    },
                    methods: {

                    },

                    ready: function () {

                        this.head.projectName = `${projectName}`;

                    }

                });
            },
            /**

              * vue 集合赋值 result.Result.eqCount

              */

            initVueDataValue: function (result) {

                var res = result.Result;
                vueApp.body.eqCount = res.eqSumCount;

                vueApp.body.eqRunCount = res.eqRunCount;

                vueApp.body.eqStandBy = res.eqStandByCount;

                vueApp.body.eqError = res.eqErrorCount;
                vueApp.body.eqOffline = res.eqOffLineCount;

                vueApp.body.eqOnlineRate = res.runningRate;

            },

            getUrlParam: function () {

                projectKeys = localStorage.getItem("projectMapKeys");
                projectName = localStorage.getItem("projectMapName");

                projectCode = localStorage.getItem("projectCode");

            },

            getEquipmentDataList() {
                var ajaxConfig = {
                    data: { pageRequest: null, entity: { flag: "projectMapList", keys: projectKeys } },
                    url: `/configure/BaseProject/LoadProjectOverview`,
                    success: function (result) {
                        if (sysU.successBefore(result)) return false;
                        app.methods.initVueDataValue(result);
                    }
                };
                sysU.ajax(ajaxConfig);
            },

            //妥善率/故障次数/设备故 障统一数据请求接口

            getEqEchartsDataList() {
                var ajaxConfig = {
                    data: { projectKeys: projectKeys },
                    url: `/configure/BaseProject/GetFailureList`,
                    success: function (result) {
                        if (sysU.successBefore(result)) return false;

                        app.methods.initEchartsAlarmsNumber(result.Result.failureCount);

                        app.methods.initTableFailure40(result.Result.failureOverFourty);                  

                    }
                };
                sysU.ajax(ajaxConfig);
            },

            //OEE、MTTR、MTBF、妥善率 请求数据接口

            getEquipmentsExtendIndexData() {
                var endDay = new Date();
                var startDay = new Date(endDay.getTime() - (6 * 24 * 60 * 60 * 1000)); // 6天前
                var ajaxConfig = {
                    data: {
                        projectName: projectName,
                        argument: projectCode,
                        tag: 2,
                        startDay: startDay.format("yyyy-MM-dd"),
                        endDay: endDay.format("yyyy-MM-dd"),
                    },
                    url: `/api/BusEquipmentData/GetEquipmentsExtendIndexData`,
                    type: "get",
                    success: function (result) {
                        if (sysU.successBefore(result)) return false;
                        vueApp.eqSumObj.oee = result.Result.sumDt.Oee;
                        vueApp.eqSumObj.mttr = result.Result.sumDt.Mttr;
                        vueApp.eqSumObj.mtbf = result.Result.sumDt.Mtbf;
                        vueApp.eqSumObj.proper = result.Result.sumDt.Proper;

                        sysEqAllSumObj = result.Result.detailDt;
                    }
                };
                sysU.ajax(ajaxConfig);
            },

            //设备开机时间接口
            getEqEchartsPowerOnTimeDataList() {

                var ajaxConfig = {

                    data: { projectKeys: projectKeys },
                    url: `/configure/BaseProject/GetEqPowerOnTime`,

                    success: function (result) {
                        if (sysU.successBefore(result)) return false;

                        //设备开机时间
                        app.methods.initEchartsPowerOnTime(result.Result);

                    }
                };
                sysU.ajax(ajaxConfig);
            },

            convertSecondsToTime: function (seconds) {
                if (typeof seconds !== 'number') return seconds;
                var hours = Math.floor(seconds / 3600);
                var minutes = Math.floor((seconds % 3600) / 60);

                var remainingSeconds = Math.floor(seconds % 60);

                var result = '';
                if (hours > 0) {
                    result += hours + '小时';
                }
                if (minutes > 0) {
                    result += minutes + '分';
                }
                result += remainingSeconds + '秒';
                return result;
            },

            init: function () {
                var tempElem = $(".sys-a-det");
                tempElem.attr("href", tempElem.data("scr") + `?projectKeys=${projectKeys}`)

                app.methods.getEquipmentDataList();

                app.methods.getEqEchartsDataList();

                app.methods.getEquipmentsExtendIndexData(); 

                app.methods.getEqEchartsPowerOnTimeDataList();

                intervalTime = setInterval(app.methods.refreshDataMethod, 1000);

                //
                for (var i = 0; i < app.data.echartOpt.tuoShanRatelegendData.length; i++) {
                    app.data.colsProper[0].push({ field: "date" + i, width: 100, title: app.data.echartOpt.tuoShanRatelegendData[i] });
                }
            },

            //dataSources 数据源，dateList：日期列表，comparisonKeys 返回的列表的key
            oeeAndMttrAndMTBFDataHandle: function (dataSources, dateList, comparisonKeys) {
                var resultData = []
                const uniqueEqName = dataSources.uniqueFunc('EquipmentName');
                let index = 0
                var nowVal = "";
                for (let i = 0; i < uniqueEqName.length; i++) {
                    nowVal = "";
                    index = 0
                    var defaultCol = { index: i + 1, EquipmentName: uniqueEqName[i].EquipmentName }
                    dateList.forEach((item) => {
                        for (let xp = 0; xp < dataSources.length; xp++) {
                            if (uniqueEqName[i].EquipmentName == dataSources[xp].EquipmentName && dataSources[xp].Date == item) {
                                nowVal = dataSources[xp][comparisonKeys];
                                break
                            }
                        }
                        defaultCol['date' + index++] = nowVal;           
                    })
                    resultData.push(defaultCol)
                }
                return resultData;

            }

        },
        registerEvent: function () {

            $(".sys-a-det").click(function () {
                if (intervalTime != null) clearInterval(intervalTime)
            })

            $('#clickToClickSuccessRate').click(function () {
                sysU.openPage({

                    title: "妥善率(近7天)总时间:堆垛机默认工作24小时,其他设备字典配置PowerOnTime",

                    area: ["1100px", "590px"],

                    type: 1,

                    btn: ['关闭'],

                    content: $('#tuoshanlv'),
                    successCallBackFn: function () {
                        app.methods.initEchartsTuoShanRate(sysEqAllSumObj);

                        debugger
                        var data = app.methods.oeeAndMttrAndMTBFDataHandle(sysEqAllSumObj, app.data.echartOpt.tuoShanRatelegendData, "Proper");

                        let options = {
                            elem: "#tableProper",
                            cols: app.data.colsProper,

                            data: data,

                            height: 'full-410', // 最大高度减去其他容器已占有的高度差

                            page: false
                        }
                        sysU.initTable(options);
                    }

                });
            });

            $('#clickToClickMTTR').click(function () {
                sysU.openPage({
                    title: "MTTR",

                    area: ["1100px", "590px"],

                    type: 1,
                    btn: ['关闭'],

                    content: $('#eleMTTR'),
                    successCallBackFn: function () {

                        var data = app.methods.oeeAndMttrAndMTBFDataHandle(sysEqAllSumObj, app.data.echartOpt.tuoShanRatelegendData, "Mttr");

                        let options = {
                            elem: "#tableMTTR",

                            cols: app.data.colsProper,
                            data: data,

                            height: 'full-110', // 最大高度减去其他容器已占有的高度差

                            page: false
                        }
                        sysU.initTable(options);
                    }

                });
            });

            $('#clickToClickMTBF').click(function () {
                sysU.openPage({
                    title: "MTBF",

                    area: ["1100px", "590px"],

                    type: 1,
                    btn: ['关闭'],
                    content: $('#eleMTBF'),
                    successCallBackFn: function () {

                        var data = app.methods.oeeAndMttrAndMTBFDataHandle(sysEqAllSumObj, app.data.echartOpt.tuoShanRatelegendData, "Mtbf");

                        let options = {
                            elem: "#tableMTBF",

                            cols: app.data.colsProper,
                            data: data,

                            height: 'full-110', // 最大高度减去其他容器已占有的高度差

                            page: false
                        }
                        sysU.initTable(options);
                    }
                });
            });

            $('#clickToClickOEE').click(function () {
                sysU.openPage({
                    title: "OEE",

                    area: ["1100px", "590px"],

                    type: 1,

                    btn: ['关闭'],

                    content: $('#eleOee'),
                    successCallBackFn: function () {

                        var data = app.methods.oeeAndMttrAndMTBFDataHandle(sysEqAllSumObj, app.data.echartOpt.tuoShanRatelegendData, "Oee");

                        let options = {
                            elem: "#tableOee",

                            cols: app.data.colsProper,
                            data: data,

                            height: 'full-110', // 最大高度减去其他容器已占有的高度差

                            page: false
                        }
                        sysU.initTable(options);
                    }

                });
            });  
        },

        init: function () {
            app.methods.getUrlParam();

            app.registerEvent();  

            app.methods.initVue();

            app.methods.initTable();

            app.methods.init();  

        }
    };
    app.init();
});