WebTM/views/ÖÊÁ¿¹ÜÀí/ÖÊÁ¿±¨±í/QC_EquipMentCollectionTechParam.html
@@ -46,7 +46,7 @@
                                        </button>
                                    </div>
                                </div>
                                <div class="layui-inline">
                                <div class="layui-inline" style="display:none">
                                    <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">工序</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input" lay-verify="HProcName" name="HProcName" id="HProcName" value="" style="background-color: #efefef4d; width: 75%; display: inline-block;" readonly>
@@ -55,7 +55,15 @@
                                        </button>
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label" style="width: 85px;">采集来源</label>
                                    <div class="layui-input-block" style="margin-left: 120px; width: 185px;">
                                        <select name="HEquipType" id="HEquipType" class=" ForFilteringSchemes" lay-verify="HEquipType">
                                            <option value="手动输入">手动输入</option>
                                            <option value="设备采集">设备采集</option>
                                        </select>
                                    </div>
                                </div>
                                <div class="layui-row" style="margin-top:5px;margin-left:82px;margin-bottom:5px;">
                                    <div class="layui-inline">
                                        <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">工艺参数</label>
@@ -67,101 +75,21 @@
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">日期</label>
                                        <label class="layui-form-label">开始日期</label>
                                        <div class="layui-input-block">
                                            <input type="date" class="layui-input ForFilteringSchemes" id="HDate" style="width:190px;">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">结束日期</label>
                                        <div class="layui-input-block">
                                            <input type="date" class="layui-input ForFilteringSchemes" id="HDate1" style="width:190px;">
                                        </div>
                                    </div>
                                    <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch" style="padding: 0 10px;margin-left: 20px;">
                                        <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                    </button>
                                    <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">重置</button>
                                </div>
                                <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
                                    <div class="layui-row" style="margin-top:5px">
                                        <div class="layui-inline">
                                            <label class="layui-form-label">过滤</label>
                                            <div class="layui-input-block">
                                                <select name="ColName" id="ColName" class="ForFilteringSchemes" lay-filter="ColName" style="width:190px;">
                                                </select>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <select name="Comparator" id="Comparator" class="ForFilteringSchemes" lay-filter="Comparator" style="width:190px;">
                                                <option value="0" selected="selected"></option>
                                                <option value="=">=</option>
                                                <option value=">=">>=</option>
                                                <option value=">">></option>
                                                <option value="<="><=</option>
                                                <option value="<"><</option>
                                                <option value="<>"><></option>
                                                <option value="7">包含</option>
                                                <option value="8">左包含</option>
                                                <option value="9">右包含</option>
                                                <option value="10">不包含</option>
                                            </select>
                                        </div>
                                        <div class="layui-inline">
                                            <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent" id="ColContent">
                                        </div>
                                    </div>
                                    <div class="layui-row" style="margin-top:5px">
                                        <div class="layui-inline">
                                            <label class="layui-form-label">过滤</label>
                                            <div class="layui-input-block">
                                                <select name="ColName1" id="ColName1" lay-filter="ColName1" style="width:190px;">
                                                </select>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <select name="Comparator1" id="Comparator1" lay-filter="Comparator1" style="width:190px;">
                                                <option value="0" selected="selected"></option>
                                                <option value="=">=</option>
                                                <option value=">=">>=</option>
                                                <option value=">">></option>
                                                <option value="<="><=</option>
                                                <option value="<"><</option>
                                                <option value="<>"><></option>
                                                <option value="7">包含</option>
                                                <option value="8">左包含</option>
                                                <option value="9">右包含</option>
                                                <option value="10">不包含</option>
                                            </select>
                                        </div>
                                        <div class="layui-inline">
                                            <input type="text" class="layui-input" value="" name="ColContent1" id="ColContent1">
                                        </div>
                                    </div>
                                    <div class="layui-row" style="margin-top:5px">
                                        <div class="layui-inline">
                                            <label class="layui-form-label">过滤</label>
                                            <div class="layui-input-block">
                                                <select name="ColName2" id="ColName2" lay-filter="ColName2" style="width:190px;">
                                                </select>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <select name="Comparator2" id="Comparator2" lay-filter="Comparator2" style="width:190px;">
                                                <option value="0" selected="selected"></option>
                                                <option value="=">=</option>
                                                <option value=">=">>=</option>
                                                <option value=">">></option>
                                                <option value="<="><=</option>
                                                <option value="<"><</option>
                                                <option value="<>"><></option>
                                                <option value="7">包含</option>
                                                <option value="8">左包含</option>
                                                <option value="9">右包含</option>
                                                <option value="10">不包含</option>
                                            </select>
                                        </div>
                                        <div class="layui-inline">
                                            <input type="text" class="layui-input" value="" name="ColContent2" id="ColContent2">
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
@@ -273,6 +201,7 @@
            // åˆå§‹åŒ–界面
            function set_ClearBill() {
                $("#HDate").val(Format(new Date, "yyyy-MM-dd"));
                $("#HDate1").val(Format(new Date, "yyyy-MM-dd"));
                set_InitGrid(); //初始化表格
                get_FastQuery();
                ////加载折线图
@@ -293,14 +222,10 @@
                    , limits: [50, 500, 5000, 20000]
                    , cols: [[
                        { type: 'checkbox', totalRowText: '合计行' }
                        , { field: '日期', title: '日期', sort: true }
                        , { field: '设备编码', title: '设备编码', sort: true }
                        , { field: '采集日期', title: '采集日期', sort: true }
                        , { field: '工艺参数', title: '工艺参数', sort: true }
                        , { field: '单位 ', title: '单位 ',sort: true }
                        , { field: '上限值', title: '上限值', sort: true }
                        , { field: '标准值', title: '标准值', sort: true }
                        , { field: '下限值', title: '下限值', sort: true }
                        , { field: '实际值', title: '实际值', sort: true }
                        , { field: '数采值', title: '数采值', sort: true }
                    ]]
                };
@@ -313,10 +238,10 @@
                var ajaxLoad = layer.load();
                //进入页面显示的缓存列表
                $.ajax({
                    url: GetWEBURL() + '/QC_CustomerAppealReport/SB_EquipICMOTechParamList',
                    url: GetWEBURL() + '/QC_CustomerAppealReport/Get_QC_EquipMentCollectionTechParamList',
                    type: "GET",
                    async:false,
                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] },
                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"]},
                    success: function (data1) {
                        if (data1.count == 1) {
                            var data = [];
@@ -378,101 +303,31 @@
                });
                layer.close(index);
            }
            //快速查询
            function get_FastQuery() {
                var HEquipNumber = $("#HEquipNumber").val();
                var HEquipName = $("#HEquipName").val();
                var HProcName = $("#HProcName").val();
                var HTechParamName = $("#HTechParamName").val();
                var HDate = $("#HDate").val();
                var ColName = $("#ColName").val();//复选框
                var Comparator = $("#Comparator").val()
                var ColContent = $("#ColContent").val();
                var ColName1 = $("#ColName1").val();//复选框
                var Comparator1 = $("#Comparator1").val()
                var ColContent1 = $("#ColContent1").val();
                var ColName2 = $("#ColName2").val();//复选框
                var Comparator2 = $("#Comparator2").val()
                var ColContent2 = $("#ColContent2").val();
                if (ColName != 0 && Comparator != 0) {
                    var com = "";
                    switch (Comparator) {
                        case "7":
                            com = "like'%" + ColContent + "%'";
                            break;
                        case "8":
                            com = "like'%" + ColContent + "'";
                            break;
                        case "9":
                            com = "like'" + ColContent + "%'";
                            break;
                        case "10":
                            com = "not like'%" + ColContent + "%'";
                            break;
                        default:
                            com = "" + Comparator + "'" + ColContent + "'";
                            break;
                    }
                    sWhere += " and " + ColName + " " + com;
                }
                if (ColName1 != 0 && Comparator1 != 0) {
                    var com1 = "";
                    switch (Comparator1) {
                        case "7":
                            com1 = "like'%" + ColContent1 + "%'";
                            break;
                        case "8":
                            com1 = "like'%" + ColContent1 + "'";
                            break;
                        case "9":
                            com1 = "like'" + ColContent1 + "%'";
                            break;
                        case "10":
                            com1 = "not like'%" + ColContent1 + "%'";
                            break;
                        default:
                            com1 = "" + Comparator1 + "'" + ColContent1 + "'";
                            break;
                    }
                    sWhere += " and " + ColName1 + " " + com1;
                }
                if (ColName2 != 0 && Comparator2 != 0) {
                    var com2 = "";
                    switch (Comparator2) {
                        case "7":
                            com2 = "like'%" + ColContent2 + "%'";
                            break;
                        case "8":
                            com2 = "like'%" + ColContent2 + "'";
                            break;
                        case "9":
                            com2 = "like'" + ColContent2 + "%'";
                            break;
                        case "10":
                            com2 = "not like'%" + ColContent2 + "%'";
                            break;
                        default:
                            com2 = "" + Comparator + "'" + ColContent + "'";
                            break;
                    }
                    sWhere += " and " + ColName2 + " " + com2;
                }
                if (HEquipNumber != "" && HEquipName != "" && HProcName != "" && HTechParamName != "") {
                var HDate = $("#HDate").val(); //开始日期
                var HDate1 = $("#HDate1").val();//结束日期
                var HEquipType = $("#HEquipType").val();
                if (HEquipNumber != "" || HTechParamName != "") {
                    sWhere = {
                        HEquipNumber: HEquipNumber
                        , HEquipName: HEquipName
                        , HProcName: HProcName
                        , HTechParamName: HTechParamName
                        , HDate: HDate
                        , HDate1: HDate1
                        , HEquipType: HEquipType
                    }
                    get_Display(JSON.stringify(sWhere));
                    sWhere = "";//调用接口后清空sWhere缓存
                }
            }
            //重置快速查询
            function set_ClearQuery() {
                $("#HEquipNumber").val("");
@@ -495,6 +350,7 @@
                sWhere = "";
            }
            //刷新
            function get_Refresh() {
                $("#btnSearch").trigger('click');
@@ -508,18 +364,37 @@
                //折线图绑定数据
                var H_X = [];//X轴标题
                var HVaule = [];//实际值
                var HVaule = [];//实际值
                var HStd = [];//标准值
                var HMax = [];//上线值
                var HMin = [];//下限值
                var HTitle = "设备工艺参数趋势分析图";//图形标题
                if (option.data.length > 0) {
                    for (let i = 0; i < option.data.length ; i++) {
                        H_X.push(option.data[i].采集日期);
                    }
                    // å¡«å……数据
                    for (let i = 0; i < option.data.length; i++) {
                        HVaule.push(option.data[i].数采值);
                    for (let i = 0; i < option.data.length; i++) {
                        if ($("#HEquipType").val() == "手动输入") {
                            HMax.push(option.data[i].上限值);
                            HMin.push(option.data[i].下限值);
                            HStd.push(option.data[i].标准值);
                            HVaule.push(option.data[i].实际值);
                        } else {
                            HVaule.push(option.data[i].数采值);
                            HMax.push(option.data[i].上限值);
                            HMin.push(option.data[i].下限值);
                            HStd.push(option.data[i].标准值);
                        }
                    }
                }
                var minValue = Math.min(...HVaule) - 10; //折线的最大值
                var maxValue = Math.max(...HVaule) + 10; //折线的最小值
                var interval = Math.floor((maxValue - minValue) / 10); //显示折线的间隔
                minValue = Number(minValue.toFixed(2)); // ä¿ç•™ä¸¤ä½å°æ•°å¹¶è½¬æ¢ä¸ºæ•°å­—
                minValue = Number(minValue.toFixed(2)); // ä¿ç•™ä¸¤ä½å°æ•°å¹¶è½¬æ¢ä¸ºæ•°å­—
                option_ZZT = {
                    title: {
                        text: HTitle,
@@ -529,7 +404,7 @@
                        trigger: 'axis'
                    },
                    legend: {
                        data: ['数采值'],
                        data: ['数采值', '上限值', '下限值', '标准值'],
                        top: 'bottom',
                        left: 'center'
                    },
@@ -555,7 +430,10 @@
                    ],
                    yAxis: [
                        {
                            type: 'value'
                            type: 'value',
                            min: minValue,
                            max: maxValue,
                            interval: interval
                        }
                    ],
                    series: [
@@ -572,6 +450,72 @@
                                }
                            },
                            data: HVaule
                        },
                        {
                            name: '上限值',
                            type: 'line',
                            label: {
                                show: true,
                                formatter: '{c}'
                            },
                            tooltip: {
                                valueFormatter: function (value) {
                                    return value;
                                }
                            },
                            itemStyle: {
                                normal: {
                                    lineStyle: {
                                        color: 'red' // è®¾ç½®çº¿æ¡é¢œè‰²ä¸ºçº¢è‰²
                                    },
                                    color: 'red' // è®¾ç½®æŠ˜çº¿ç‚¹é¢œè‰²ä¸ºçº¢è‰²
                                }
                            },
                            data: HMax
                        },
                        {
                            name: '下限值',
                            type: 'line',
                            label: {
                                show: true,
                                formatter: '{c}'
                            },
                            tooltip: {
                                valueFormatter: function (value) {
                                    return value;
                                }
                            },
                            itemStyle: {
                                normal: {
                                    lineStyle: {
                                        color: 'red' // è®¾ç½®çº¿æ¡é¢œè‰²ä¸ºçº¢è‰²
                                    },
                                    color: 'red' // è®¾ç½®æŠ˜çº¿ç‚¹é¢œè‰²ä¸ºçº¢è‰²
                                }
                            },
                            data: HMin
                        },
                        {
                            name: '标准值',
                            type: 'line',
                            label: {
                                show: true,
                                formatter: '{c}'
                            },
                            tooltip: {
                                valueFormatter: function (value) {
                                    return value;
                                }
                            },
                            itemStyle: {
                                normal: {
                                    lineStyle: {
                                        color: 'green' // è®¾ç½®çº¿æ¡é¢œè‰²ä¸ºçº¢è‰²
                                    },
                                    color: 'green' // è®¾ç½®æŠ˜çº¿ç‚¹é¢œè‰²ä¸ºçº¢è‰²
                                }
                            },
                            data: HStd
                        }
                    ]
                };
@@ -603,7 +547,7 @@
            }
            //#endregion
            //工序流转卡弹窗
            //设备弹窗
            form.on('submit(btnHEquip)', function () {
                //页面层-自定义
                layer.open({
@@ -627,7 +571,6 @@
                        $("#HEquipNumber").val(checkStatus.data[0].设备编码);
                        $("#HEquipName").val(checkStatus.data[0].设备名称);
                        layer.close(layer.index); //它获取的始终是最新弹出的某个层,值是由layer内部动态递增计算的
                        get_EquipList();
                    }
                    , btn2: function (index, layero) {
                        //按钮【按钮二】的回调
@@ -681,6 +624,7 @@
            //工艺参数
            form.on('submit(btnHTechParam)', function () {
                var HEquipNumber = $("#HEquipNumber").val();
                //页面层-自定义
                layer.open({
                    type: 2,
@@ -690,7 +634,7 @@
                    shift: 2,
                    area: ['90%', '90%'],
                    maxmin: true,
                    content: ['../../../views/基础资料/公用基础资料/Gy_TechnologyParameterList.html', 'yes'],
                    content: ['../../../views/基础资料/公用基础资料/Gy_TechnologyParameterList.html?type=HTechParam&OperationType=2&HEquipNumber=' + HEquipNumber + '', 'yes'],
                    btn: ['确定', '取消']
                    , btn1: function (index, layero) {