1
zrg
2025-11-25 e0092d7ad1f6e1b18cfb14c1b0d6776fd8184c5f
WebTM/views/³µ¼ä¹ÜÀí/±¨±í·ÖÎö/Mes_OrderProcFlowAllReport_TK.html
@@ -52,39 +52,128 @@
                                        <input type="date" class="layui-input ForFilteringSchemes" name="HDate2" id="HDate2" style="width:190px;">
                                    </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">订单跟踪号</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" id="txtHOrderProcNo" style="width:190px;">
                                        </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">订单跟踪号</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input" id="txtHOrderProcNo" style="width:190px;">
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">物料代码</label>
                                        <div class="layui-input-inline">
                                            <input type="text" class="layui-input" lay-verify="txtHMaterNumber" name="txtHMaterNumber" id="txtHMaterNumber" value="" style="float: left; width: 150px; background-color: #efefef4d; display: inline-block;" readonly>
                                            <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHMaterID" id="btnHMaterID" style="width: 40px;">
                                                <i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i>
                                            </button>
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">部门名称</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" id="txtHDeptName" style="width:190px;">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <div class="layui-input-block">
                                            <input type="checkbox" name="chkHShowUnFinish" id="chkHShowUnFinish" lay-skin="primary" lay-filter="chkHShowUnFinish" title="只显示未完工">
                                        </div>
                                    </div>
                                    <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
                                        <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-inline">
                                    <label class="layui-form-label">物料代码</label>
                                    <div class="layui-input-inline">
                                        <input type="text" class="layui-input" lay-verify="txtHMaterNumber" name="txtHMaterNumber" id="txtHMaterNumber" value="" style="float: left; width: 150px; background-color: #efefef4d; display: inline-block;">
                                        <!--<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHMaterID" id="btnHMaterID" style="width: 40px;">
                                            <i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i>
                                        </button>-->
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">部门名称</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input" id="txtHDeptName" style="width:190px;">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <div class="layui-input-block">
                                        <input type="checkbox" name="chkHShowUnFinish" id="chkHShowUnFinish" lay-skin="primary" lay-filter="chkHShowUnFinish" title="只显示未完工">
                                    </div>
                                </div>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
                                    <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 class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
                                </div>
                                <!--显示当前过滤方案-->
                                <div class="layui-inline" style="margin-left:5px;">
                                    <div style="text-align:center;font-size:15px;font-weight:bold;color:#fc9393" id="HFilterScheme_Now"></div>
                                </div>
                                <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
                                    <div class="layui-row" style="margin-top:10px;">
                                        <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" lay-filter="ColName" style="width:190px;" class="ForFilteringSchemes">
                                                    </select>
                                                </div>
                                            </div>
                                            <div class="layui-inline">
                                                <select name="Comparator" id="Comparator" lay-filter="Comparator" style="width:190px;" class="ForFilteringSchemes">
                                                    <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 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" class="ForFilteringSchemes" lay-filter="ColName1" style="width:190px;">
                                                        </select>
                                                    </div>
                                                </div>
                                                <div class="layui-inline">
                                                    <select name="Comparator1" id="Comparator1" class="ForFilteringSchemes" 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 ForFilteringSchemes" 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" class="ForFilteringSchemes" lay-filter="ColName2" style="width:190px;">
                                                        </select>
                                                    </div>
                                                </div>
                                                <div class="layui-inline">
                                                    <select name="Comparator2" id="Comparator2" class="ForFilteringSchemes" 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 ForFilteringSchemes" value="" name="ColContent2" id="ColContent2">
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <table class="" id="mainTable" lay-filter="mainTable"></table>
@@ -222,7 +311,7 @@
                //加载数据到网格
                get_FastQuery();
            }
            //初始化表格
@@ -238,12 +327,12 @@
            }
            //加载网格
            function get_Display(sWhere) {
            function get_Display(txtHOrderProcNo, txtHMaterNumber, check, txtHDeptName, sWhere) {
                var wait = layer.load();//遮罩
                $.ajax({
                    url: GetWEBURL() + '/Mes_OrderProcFlowAllReport/OrderProcFlowAllReportList_Tk',
                    type: "GET",
                    data: { "sWhere": sWhere },
                    data: {"txtHOrderProcNo": txtHOrderProcNo, "txtHMaterNumber": txtHMaterNumber, "check": check, "txtHDeptName": txtHDeptName, "sWhere": sWhere },
                    success: function (data1) {
                        var col = [];
                        if (data1.count == 1) {
@@ -276,6 +365,10 @@
                            option.data = data1.data;
                            ins = table.render(option);
                            DisPlay_HideColumn();
                            if ($("#ColName option").length < 1) {
                                ColFilter();
                            }
                            layer.close(wait);
                        } else {
                            layer.close(wait);
@@ -292,6 +385,7 @@
            function get_FastQuery() {
                var HDate1 = $("#HDate1").val();
                var HDate2 = $("#HDate2").val();
                sWhere = "and å·¥åºå®Œå·¥æ—¥æœŸ1 >='" + HDate1 + "' and å·¥åºå®Œå·¥æ—¥æœŸ1<='" + HDate2 + "'";
                var txtHOrderProcNo = $("#txtHOrderProcNo").val();//订单跟踪号
                var txtHMaterNumber = $("#txtHMaterNumber").val(); //物料
                var txtHDeptName = $("#txtHDeptName").val(); //物料
@@ -300,9 +394,83 @@
                if (chkHShowUnFinish) {
                    check = "Y";
                }
                sWhere = "'" + HDate1 + "','" + HDate2 + "','" + txtHOrderProcNo + "','" + txtHMaterNumber + "','" + check + "'" + ",'" + txtHDeptName + "'";
                get_Display(sWhere);
                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;
                }
                get_Display(txtHOrderProcNo, txtHMaterNumber, check, txtHDeptName, sWhere);
                //sWhere = "'" + HDate1 + "','" + HDate2 + "','" + txtHOrderProcNo + "','" + txtHMaterNumber + "','" + check + "'" + ",'" + txtHDeptName + "'";
                //调用接口后清空sWhere缓存
                sWhere = "";
            }
@@ -326,7 +494,7 @@
                $("#ColName2").val("0");
                $("#Comparator2").val("0");
                form.render('select');
                sWhere = " ";
                get_FastQuery();
            }
@@ -423,7 +591,23 @@
                });
            })
            //#endregion
            //#region åˆ—明显示下拉框
            function ColFilter() {
                var Organization = '<option  value="0" selected="selected" ></option>';
                for (var i = 1; i < option.cols[0].length; i++) {
                    if (option.cols[0][i].hide != true) {
                        Organization += '<option  style="color:blue;" value="' + option.cols[0][i].field + '">' + option.cols[0][i].field + '</option>';
                    }
                }
                $("#ColName").empty();
                $("#ColName").append(Organization);
                $("#ColName1").empty();
                $("#ColName1").append(Organization);
                $("#ColName2").empty();
                $("#ColName2").append(Organization);
                form.render('select');
            }
            //#endregion
            //显示列数据
            function DisPlay_HideColumn() {
                $.ajax({