wtt
2025-08-21 fe1a4ed8d3a161bc555d4b3fbbce3a7e10a5fbcd
WebTM/views/ÖÊÁ¿¹ÜÀí/ÖÊÁ¿±¨±í/QC_ProcessPerformanceFirstPass.html
@@ -38,15 +38,7 @@
                                            <!--动态渲染年份-->
                                        </select>
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">车间</label>
                                    <div class="layui-input-block" style="width: 190px;">
                                        <select name="HDeptName" id="HDeptName" lay-verify="HDeptName">
                                            <!--动态渲染部门-->
                                        </select>
                                    </div>
                                </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;">
@@ -71,9 +63,12 @@
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">重置</button>
                                <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;">物料编码</label>
                                        <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">物料编码</label>
                                        <div class="layui-input-block" style="margin-left: 120px;">
                                            <input type="text" class="layui-input ForFilteringSchemes" name="HMaterNumber" id="HMaterNumber">
                                            <input type="text" class="layui-input" name="HMaterNumber" id="HMaterNumber" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
                                            <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHMaterID" id="btnHMaterID" style="padding: 0 10px; margin-right: 3px;">
                                                <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                            </button>
                                        </div>
                                    </div>
                                    <div class="layui-inline">
@@ -90,90 +85,7 @@
                                            </select>
                                        </div>
                                    </div>
                                </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>
                        </div>
                        <div>
@@ -265,6 +177,12 @@
            form.on('submit(btnReSearch)', function (data) {
                set_ClearQuery();
            });
            //#region äº§å“ç¼–码
            form.on('submit(btnHMaterID)', function (data) {
                btnHMaterID();
            });
            //#endregion
            //#endregion
            //#region ç‚¹å‡»è¡Œé€‰ä¸­é«˜äº®
@@ -291,8 +209,7 @@
            //#region æ­¤é¡µé¢æ‰€æœ‰æ–¹æ³•
            // åˆå§‹åŒ–界面
            function set_ClearBill() {
                Year(); //初始化年
                DeptName();//初始化车间
                Year(); //初始化年
                Get_HProject(); //获取项目号
                GetGy_Division();//获取事业部
                set_InitGrid(); //初始化表格
@@ -404,91 +321,14 @@
            //快速查询
            function get_FastQuery() {
                var HYear = $("#HYear").val();
                var HDeptName = $("#HDeptName").val();//车间
                var HProject = $("#HProject").val();//项目号
                var HMaterNumber = $("#HMaterNumber").val();//物料代码
                var HMaterName = $("#HMaterName").val();//物料名称
                var HBatchWork = $("#HBatchWork").val();//是否量产
                var HDivisionName = $("#HDivisionName").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;
                }
                
                sWhere = {
                    HYear: HYear
                    , HDeptName: HDeptName
                    HYear: HYear
                    , HProject: HProject
                    , HMaterNumber: HMaterNumber
                    , HMaterName: HMaterName
@@ -503,24 +343,14 @@
            }
            //重置快速查询
            function set_ClearQuery() {
                $("#HYear").val(new Date().getFullYear());
                $("#HDeptName").val("0");
                $("#HYear").val(new Date().getFullYear());
                $("#HProject").val("");
                $("#HMaterNumber").val("");
                $("#HMaterName").val("");
                $("#HBatchWork").val("");
                $("#HDivisionName").val("");
                $("#btnSearch").click();
                $("#ColContent").val("");
                $("#ColName").val("0");
                $("#Comparator").val("0");
                $("#ColContent2").val("");
                $("#ColName2").val("0");
                $("#Comparator2").val("0");
                $("#ColContent1").val("");
                $("#ColName1").val("0");
                $("#Comparator1").val("0");
                $("#btnSearch").click();
                form.render('select');
                sWhere = "";
@@ -643,15 +473,15 @@
                            },
                            itemStyle: {
                                normal: {
                                    color: '#808080', // ä¿®æ­£ä½ç½®ï¼Œå°†é¢œè‰²è®¾ç½®åœ¨è¿™é‡Œ
                                    label: {
                                        show: true,      //开启显示
                                        textStyle: {       //数值样式
                                        show: true,
                                        textStyle: {
                                            color: 'black',
                                            fontSize: 16
                                        }
                                    }
                                },
                                color: '#1E90FF' // è®¾ç½®æŸ±çŠ¶å›¾è“è‰²
                                }
                            },
                            data: HBackWorkQty
                        },
@@ -665,25 +495,25 @@
                            tooltip: {
                                valueFormatter: function (value) {
                                    return value;
                                }
                                }
                            },
                            itemStyle: {
                                normal: {
                                    color: '#FF0000', // ä¿®æ­£ä½ç½®ï¼Œå°†é¢œè‰²è®¾ç½®åœ¨è¿™é‡Œ
                                    label: {
                                        show: true,      //开启显示
                                        textStyle: {       //数值样式
                                        show: true,
                                        textStyle: {
                                            color: 'black',
                                            fontSize: 16
                                        }
                                    }
                                },
                                color: '#FFFF00' // è®¾ç½®æŸ±çŠ¶å›¾é»„è‰²
                                }
                            },
                            data: HWasterQty_Work
                        },
                        {
                            name: '料废',
                            type: 'bar',
                            type: 'bar',
                            stack: 'Ad',
                            emphasis: {
                                focus: 'series'
@@ -695,21 +525,22 @@
                            },
                            itemStyle: {
                                normal: {
                                    color: '#FFFF00', // ä¿®æ­£ä½ç½®ï¼Œå°†é¢œè‰²è®¾ç½®åœ¨è¿™é‡Œ
                                    label: {
                                        show: true,      //开启显示
                                        textStyle: {       //数值样式
                                        show: true,
                                        textStyle: {
                                            color: 'black',
                                            fontSize: 16
                                        }
                                    }
                                },
                                color: '#FF8C00' // è®¾ç½®æŸ±çŠ¶å›¾æ©™è‰²
                                }
                            },
                            data: HWasterQty_Mater
                        },
                        {
                            name: '一次合格率',
                            type: 'line',
                            yAxisIndex: 1, // ä½¿ç”¨ç¬¬äºŒä¸ª yAxis æ˜¾ç¤ºç™¾åˆ†æ¯”
                            label: {
                                show: true,
                                formatter: '{c}%'
@@ -732,6 +563,7 @@
                        {
                            name: '目标值',
                            type: 'line',
                            yAxisIndex: 1, // ä½¿ç”¨ç¬¬äºŒä¸ª yAxis æ˜¾ç¤ºç™¾åˆ†æ¯”
                            label: {
                                show: true,
                                formatter: '{c}%'
@@ -834,9 +666,10 @@
                    series: [
                        {
                            name: '工料率',
                            type: 'line',
                            type: 'line',
                            label: {
                                show: true
                                show: true,
                                formatter: '{c}%'
                            },
                            itemStyle: {
                                normal: {
@@ -852,7 +685,8 @@
                            name: '料废率',
                            type: 'line',
                            label: {
                                show: true
                                show: true,
                                formatter: '{c}%'
                            },
                            itemStyle: {
                                normal: {
@@ -1108,6 +942,32 @@
            }
            //#endregion
            //物料列表
            function btnHMaterID() {
                layer.open({
                    type: 2 //类型
                    , skin: 'layui-layer-rim'//加上边框
                    , area: ['90%', '90%']//大小
                    , title: '物料列表'//标题
                    , shift: 2//弹出动画
                    , content: ['../../基础资料/公用基础资料/Gy_Material.html', 'yes']
                    , btn: ['确定', '取消']
                    , btn1: function (index, layero) {//按钮【按钮一】的回调
                        var iframeWindow = window['layui-layer-iframe' + index]  //获取弹框页面
                        var checkStatus = iframeWindow.layui.table.checkStatus('mainTable');//获取table的elem:"#test"
                        if (checkStatus.data.length === 0) {
                            return layer.msg('请选择数据');
                        }
                        //获取数据
                        $("#HMaterNumber").val(checkStatus.data[0].物料代码);
                        $("#HMaterName").val(checkStatus.data[0].物料名称);
                        layer.close(index); //它获取的始终是最新弹出的某个层,值是由layer内部动态递增计算的
                    }
                    , btn2: function (index, layero) { }
                })
            }
            //以上是layui模块
        });
    </script>